where('admin_id',10000)->where($where)->count(); } $query = ShopGoods::mQuery()->like('name,cateids')->equal('code,status'); $result = $query->where('admin_id',10000)->order('id desc')->page(true, false, false, 10); $data['count'] =$count; $data['list']=$result; $this->success('我的商品列表',$data); } /** * @Title ("添加商品") * @Param ("name",desc="商品名称") * @Param ("cateids",desc="商品分类") * @Param ("cover",desc="商品封面图") * @Param ("slider",desc="商品轮播图") * @Param ("content",desc="商品详情") * @Param ("stock_total",desc="商品库存") * @Param ("price_selling",desc="商品销售价") * @Param ("price_market",desc="商品市场价") * @Param ("items",desc="商品规格信息") */ public function goods_add(){ $data = $this->_vali( [ 'name.require'=>'商品名称不能为空', 'cateids.require'=>'商品分类不能不选', 'cover.require'=>'商品封面不能为空', 'slider.require'=>'商品轮播图不能为空', 'content.require'=>'商品详情不能为空', 'stock_total.require'=>'商品库存不能为空', 'price_selling.require'=>'商品销售价格不能为空', 'price_market.require'=>'商品市场价格不能为空', 'items.require'=>'商品规格不能为空' ] ); $goods_data= [ 'name'=>$data['name'], 'cateids'=>$data['cateids'], 'cover'=>$data['cover'], 'slider'=>$data['slider'], 'content'=>$data['content'], 'stock_total'=>$data['stock_total'], 'price_selling'=>$data['price_selling'], 'price_market'=>$data['price_market'], 'code'=>CodeExtend::uniqidNumber(20, 'G'), 'data_specs'=>json($data['items']), 'create_at'=>date('Y-m-d H:i:s'), 'admin_id'=>10000, ]; try { ShopGoods::mk()->insertGetId($goods_data); foreach ($data['items']as &$v){ $item_data = [ 'goods_sku'=>CodeExtend::uniqidNumber(12, 'S'), 'goods_code'=>$data['code'], 'goods_spec'=>$v['name'], 'stock_total'=>$v['total'], 'price_selling'=>$v['price_selling'], 'price_market'=>$v['price_market'], 'create_at'=>date('Y-m-d H:i:s'), 'admin_id'=>10000 ]; ShopGoodsItem::mk()->insertGetId($item_data); } $this->success('商品数据入库成功!'); }catch (\Exception $e){ $this->success('商品数据入库失败!'); } } /** * @Title ("商品修改") * @Param ("name",desc="商品名称") * @Param ("cateids",desc="商品分类") * @Param ("cover",desc="商品封面图") * @Param ("slider",desc="商品轮播图") * @Param ("content",desc="商品详情") * @Param ("stock_total",desc="商品库存") * @Param ("price_selling",desc="商品销售价") * @Param ("price_market",desc="商品市场价") * @Param ("items",desc="商品规格信息") * @return void * */ public function goods_edit(){ $goods_id = input('order_id'); $data = $this->_vali( [ 'name.require'=>'商品名称不能为空', 'cateids.require'=>'商品分类不能不选', 'cover.require'=>'商品封面不能为空', 'slider.require'=>'商品轮播图不能为空', 'content.require'=>'商品详情不能为空', 'stock_total.require'=>'商品库存不能为空', 'price_selling.require'=>'商品销售价格不能为空', 'price_market.require'=>'商品市场价格不能为空', 'items.require'=>'商品规格不能为空' ] ); $goods_data= [ 'name'=>$data['name'], 'cateids'=>$data['cateids'], 'cover'=>$data['cover'], 'slider'=>$data['slider'], 'content'=>$data['content'], 'stock_total'=>$data['stock_total'], 'price_selling'=>$data['price_selling'], 'price_market'=>$data['price_market'], 'code'=>CodeExtend::uniqidNumber(20, 'G'), 'data_specs'=>json($data['items']), 'create_at'=>date('Y-m-d H:i:s'), 'admin_id'=>10000, ]; try { ShopGoods::mk()->where('id',$goods_id)->insertGetId($goods_data); foreach ($data['items']as &$v){ $item_data = [ 'goods_sku'=>CodeExtend::uniqidNumber(12, 'S'), 'goods_code'=>$data['code'], 'goods_spec'=>$v['name'], 'stock_total'=>$v['total'], 'price_selling'=>$v['price_selling'], 'price_market'=>$v['price_market'], 'create_at'=>date('Y-m-d H:i:s'), 'admin_id'=>10000 ]; ShopGoodsItem::mk()->where('id',$v['id'])->save($item_data); } $this->success('商品数据入库成功!'); }catch (\Exception $e){ $this->success('商品数据入库失败!'); } } /** * @Title ("商品详情") */ public function goods_details(){ $goods_id = input('goods_id'); $details = ShopGoods::mk()->alias('goods') ->where('goods.id',$goods_id) ->find(); $details['item']=ShopGoodsItem::mk()->where('goods_code', $details['code'])->select(); $this->success('商品详情',$details); } }