Good.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\GoodLog;
  4. use think\App;
  5. use think\facade\Db;
  6. class Good extends \app\BaseController
  7. {
  8. public $post="";
  9. public function __construct(App $app)
  10. {
  11. parent::__construct($app);
  12. $this->post = $this->request->post();
  13. // $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  14. // if($token==""){
  15. // return error_show(101,'token不能为空');
  16. // }
  17. // $effetc = VerifyTokens($token);
  18. // if(!empty($effetc) && $effetc['code']!=0){
  19. // return error_show($effetc['code'],$effetc['message']);
  20. // }
  21. }
  22. public function list(){
  23. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  24. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  25. $condtion=[['a.is_del',"=",0],['b.is_del',"=",0]];
  26. $wsmcode =isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  27. if($wsmcode!=""){
  28. $typecode= Db::name("good_stock")->where(["wsm_code"=>$wsmcode,'is_del'=>0])->column("good_type_code");
  29. $condtion[]=["b.type_code",'in',$typecode];
  30. }
  31. $good_code =isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  32. if($good_code!=""){
  33. //$condtion['b.type_code'] = $good_code;
  34. $condtion[]=["b.type_code",'=',$good_code];
  35. }
  36. $goodcode =isset($this->post['good_code']) &&$this->post['good_code'] !=="" ? trim($this->post['good_code'])
  37. :"";
  38. if($goodcode!=""){
  39. //$condtion['a.good_code'] = Db::raw("like '%{$goodcode}%'");
  40. $condtion[]=["a.good_code",'like',"%{$goodcode}%"];
  41. }
  42. $good_name =isset($this->post['good_name']) &&$this->post['good_name'] !=="" ? trim($this->post['good_name'])
  43. :"";
  44. if($good_name!=""){
  45. // $condtion['a.good_name'] = Db::raw("like '%{$good_name}%'");
  46. $condtion[]=["a.good_name",'like',"%{$good_name}%"];
  47. }
  48. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  49. if($supplierNo!=""){
  50. $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  51. if(empty($supplier)){
  52. return error_show(1004,"未找到供应商信息");
  53. }
  54. $condtion[]=["a.gys_code",'=',$supplierNo];
  55. }
  56. $count = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  57. ->where($condtion)->count();
  58. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  59. $list = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  60. ->where($condtion)->field("b.id,a.good_code,a.good_name,a.good_desc,a.brand,a.original_price,a.cg_saler,a.good_type,a.market_fee,a.gys_code,a.unit,
  61. a.sort_f,a.sort_s,a.sort_t,b.color,b.material,b.specs,b.is_main,b.type_code,b.attribute,b.status as bstatus,a.addtime,a.updatetime,a.cat_id")
  62. ->page($page,$size)->select();
  63. $data=[];
  64. foreach ($list as $key=>$value){
  65. $stock = Db::name("good_stock")->where(["good_type_code"=>$value['type_code'],"is_del"=>0])->sum("usable_stock");
  66. $value['usable_stock']=$stock;
  67. $supplier = Db::name("supplier")->where(["code"=>$value['gys_code']])->find();
  68. $value['supplier_name'] =isset($supplier['name']) ?$supplier['name'] :"";
  69. $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
  70. $data[]=$value;
  71. }
  72. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  73. }
  74. public function SetWarn(){
  75. $condition=["is_del"=>0];
  76. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  77. if($wsm_code!=""){
  78. $condition["wsm_code"] = $wsm_code;
  79. }else{
  80. return error_show(1004,"参数wsm_code 不能为空");
  81. }
  82. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  83. if($type_code!=""){
  84. $condition["good_type_code"] = $type_code;
  85. }else{
  86. return error_show(1004,"参数type_code 不能为空");
  87. }
  88. $good= Db::name("good_stock")->where($condition)->find();
  89. if(empty($good)){
  90. return error_show(1005,"未找到数据");
  91. }
  92. $warn_stock = isset($this->post['warn_stock']) &&$this->post['warn_stock'] !=="" ? intval($this->post['warn_stock']):"";
  93. if($warn_stock===""){
  94. return error_show(1005,"参数warn_stock 不能为空");
  95. }
  96. $good['warn_stock'] = $warn_stock;
  97. $good['updatetime'] = date("Y-m-d H:i:s");
  98. $up= Db::name("good_stock")->save($good);
  99. if($up){
  100. $data=["stock_id"=>$good['id'],"type"=>1,'stock'=>$warn_stock,"stock_name"=>"warn_stock"];
  101. GoodLog::LogAdd($this->post['token'],$data,'setwarn');
  102. return app_show(0,"预警库存更新成功");
  103. }else{
  104. return error_show(1005,"预警库存更新失败");
  105. }
  106. }
  107. public function SetStatus(){
  108. $id = isset($this->post['id']) &&$this->post['id'] !=="" ? intval($this->post['id']):"";
  109. if($id===""){
  110. return error_show(1005,"参数id 不能为空");
  111. }
  112. $good= Db::name("good_type")->where(["id"=>$id,"is_del"=>0])->find();
  113. if(empty($good)){
  114. return error_show(1005,"未找到数据");
  115. }
  116. $good['status'] = $good['status']==1?0 :1;
  117. $good['updatetime'] = date("Y-m-d H:i:s");
  118. $msg = $good['status']==1?"下架" :"上架";
  119. $up= Db::name("good_type")->save($good);
  120. return $up ? app_show(0,"商品{$msg}成功"): error_show(1005,"商品{$msg}失败");
  121. }
  122. public function GetStock(){
  123. $condition = [["a.is_del","=",0]];
  124. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  125. if($type_code!==""){
  126. $condition[]=["a.good_type_code","=",$type_code];
  127. }
  128. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  129. :"";
  130. if($wsm_code!==""){
  131. //$condition["a.wsm_code"]=$wsm_code;
  132. $condition[]=["a.wsm_code","=",$type_code];
  133. }
  134. $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo'])
  135. :"";
  136. if($suplierNo!==""){
  137. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"is_del"=>0])->column("wsm_code");
  138. $condition[]=["a.wsm_code","in",$wsmcode];
  139. }
  140. $list = Db::name("good_stock")->alias("a")->join("warehouse_info b","a.wsm_code=b.wsm_code","left")->join("supplier c","b.supplierNo=c.code","left")
  141. ->where($condition)->field("a.id,b.name as wsm_name,c.code,c.name,a.wait_in_stock,a.wait_out_stock,a.usable_stock,a.intra_stock,a.total_stock,a.status,a.warn_stock")->select();
  142. if(empty($list)){
  143. return error_show(1004,"未找到数据");
  144. }
  145. return app_show(0,"获取成功",$list);
  146. }
  147. /**
  148. * @return \think\response\Json|void
  149. * @throws \think\db\exception\DataNotFoundException
  150. * @throws \think\db\exception\DbException
  151. * @throws \think\db\exception\ModelNotFoundException
  152. */
  153. public function GetStockBet(){
  154. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  155. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  156. $condition = [["is_del","=",0]];
  157. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  158. if($type_code!==""){
  159. $condition[]=["good_type_code","like","%{$type_code}%"];
  160. }
  161. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  162. :"";
  163. if($wsm_code!==""){
  164. $condition[]=["wsm_code","=",$wsm_code];
  165. }
  166. $suplierNo = isset($this->post['suplierNo']) &&$this->post['suplierNo'] !=="" ? trim($this->post['suplierNo'])
  167. :"";
  168. if($suplierNo!==""){
  169. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"is_del"=>0])->column("wsm_code");
  170. $condition[]=["wsm_code","in",$wsmcode];
  171. }
  172. $start = isset($this->post['start']) &&$this->post['start'] !=="" ? $this->post['start']:"";
  173. $end = isset($this->post['end']) &&$this->post['end'] !=="" ? $this->post['end']:"";
  174. if($start!=""){
  175. $condition[]=["addtime",">=",$start];
  176. }
  177. if($end!=""){
  178. $condition[]=["addtime","<=",$end];
  179. }
  180. $count = Db::name("good_stock")->where($condition)->count();
  181. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  182. $list = Db::name("good_stock")->where($condition)->page($page,$size)->order("addtime desc")->select();
  183. $data=[];
  184. foreach ($list as $key=>$value){
  185. $temp=[];
  186. if($value['wsm_code']!=""){
  187. $wsm = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")->where
  188. (['a.wsm_code'=>$value['wsm_code'],"a.is_del"=>0])->field("a.name as wsm_name,wsm_code,b.code,b.name")
  189. ->find();
  190. }
  191. $temp['wsm_name'] = isset($wsm['wsm_name'])?$wsm['wsm_name']:"";
  192. $temp['wsm_code']=$value['wsm_code'];
  193. $temp['supplier_code']=isset($wsm['code'])?$wsm['code']:"";
  194. $temp['supplier_name']=isset($wsm['name'])?$wsm['name']:"";
  195. if($value['good_type_code']!=""){
  196. $good=Db::name("good_type")->alias("a")->join("good b","a.good_code=b.good_code","left")->where(["a.type_code"=>$value['good_type_code'],"a.is_del"=>0,"b.is_del"=>0])
  197. ->field("a.good_code,a.type_code,b.good_name,b.unit,a.attribute,b.sort_f")->find();
  198. }
  199. $temp['good_code']=isset($good['good_code'])?$good['good_code']:"";
  200. $temp['type_code']=isset($good['type_code'])?$good['type_code']:"";
  201. $temp['good_name']=isset($good['good_name'])?$good['good_name']:"";
  202. $temp['unit']=isset($good['unit'])?$good['unit']:"";
  203. $temp['attribute']=isset($good['attribute'])?$good['attribute']:"";
  204. $temp['sort_f']=isset($good['sort_f'])?$good['sort_f']:"";
  205. $temp['usable_stock'] = $value['usable_stock'];
  206. $temp['wait_in_stock'] = $value['wait_in_stock'];
  207. $temp['wait_out_stock'] = $value['wait_out_stock'];
  208. $temp['intra_stock'] = $value['intra_stock'];
  209. $temp['total_stock'] = $value['total_stock'];
  210. $temp['warn_stock'] = $value['warn_stock'];
  211. $temp['id'] = $value['id'];
  212. $temp['out_total'] =0;
  213. $temp['in_total'] = 0;
  214. $temp['addtime'] = $value['addtime'];
  215. $data[]=$temp;
  216. }
  217. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  218. }
  219. /**
  220. * @return \think\response\Json|void
  221. * @throws \think\db\exception\DataNotFoundException
  222. * @throws \think\db\exception\DbException
  223. * @throws \think\db\exception\ModelNotFoundException
  224. * @throws \think\exception\DbException
  225. */
  226. public function GetStockWsm(){
  227. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  228. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  229. $condition = [["is_del","=",0]];
  230. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  231. :"";
  232. if($wsm_code!==""){
  233. $condition[]=["wsm_code","=",$wsm_code];
  234. }
  235. $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo'])
  236. :"";
  237. if($suplierNo!==""){
  238. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"is_del"=>0])->column("wsm_code");
  239. $condition[]=["wsm_code","in",$wsmcode];
  240. }
  241. $build= Db::name("good_stock")->where($condition)->group("wsm_code")->field("wsm_code")->buildSql();
  242. $count = Db::table($build." a")->count();
  243. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  244. $list = Db::name("good_stock")->where($condition)->page($page,$size)->group("wsm_code")
  245. ->field("wsm_code,sum(wait_in_stock) wait_in_stock,sum(wait_out_stock) wait_out_stock,sum(usable_stock) usable_stock,
  246. sum(intra_stock) intra_stock,sum(warn_stock) warn_stock,sum(total_stock) total_stock")->select();
  247. $data=[];
  248. foreach ($list as $key=>$value){
  249. $temp=[];
  250. if($value['wsm_code']!=""){
  251. $wsm = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")->where
  252. (['a.wsm_code'=>$value['wsm_code'],"a.is_del"=>0])->field("a.name as wsm_name,wsm_code,b.code,b.name")
  253. ->find();
  254. $good = Db::name("good_stock")->alias("a")->join("good_type b","a.good_type_code=b.type_code","left")
  255. ->join("good c","c.good_code=b.good_code","left")->where(["a.wsm_code"=>$value['wsm_code'],"a.is_del"=>0,"b.is_del"=>0,"c.is_del"=>0])
  256. ->field("c.good_code,a.good_type_code,c.good_name,b.attribute,c.sort_f,c.unit,a.usable_stock,a.wait_in_stock,a.wait_out_stock,a.intra_stock,a.total_stock,a.warn_stock")
  257. ->select();
  258. }
  259. $temp['wsm_name'] = isset($wsm['wsm_name'])?$wsm['wsm_name']:"";
  260. $temp['wsm_code']=$value['wsm_code'];
  261. $temp['supplier_code']=isset($wsm['code'])?$wsm['code']:"";
  262. $temp['supplier_name']=isset($wsm['name'])?$wsm['name']:"";
  263. $temp['usable_stock'] = $value['usable_stock'];
  264. $temp['wait_in_stock'] = $value['wait_in_stock'];
  265. $temp['wait_out_stock'] = $value['wait_out_stock'];
  266. $temp['intra_stock'] = $value['intra_stock'];
  267. $temp['total_stock'] = $value['total_stock'];
  268. $temp['warn_stock'] = $value['warn_stock'];
  269. $temp['child']=isset($good)&&!empty($good) ? $good:[];
  270. $data[]=$temp;
  271. }
  272. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  273. }
  274. public function GetStockGod(){
  275. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  276. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  277. $condition = [["a.is_del","=",0],["b.is_del","=",0]];
  278. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code'])
  279. :"";
  280. if($type_code!==""){
  281. $condition[]=["b.type_code","like","%{$type_code}%"];
  282. }
  283. $count = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  284. ->where($condition)->count();
  285. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  286. $list = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  287. ->where($condition)->field("a.good_code,a.good_name,a.unit,a.sort_f,b.type_code,b.attribute,a.addtime")
  288. ->page($page,$size)->order("a.addtime desc")->select();
  289. $data=[];
  290. foreach ($list as $key=>$value){
  291. $temp=[];
  292. if($value['type_code']!=""){
  293. $wsm = Db::name("good_stock")->where(['good_type_code'=>$value['type_code'],"is_del"=>0])->field("sum(wait_in_stock) wait_in_stock,
  294. sum(wait_out_stock) wait_out_stock,sum(usable_stock) usable_stock,sum(intra_stock) intra_stock,sum(warn_stock) warn_stock,sum(total_stock) total_stock")
  295. ->find();
  296. $child = Db::name("good_stock")->alias("a")->join("warehouse_info b","a.wsm_code=b.wsm_code","left")
  297. ->where(['a.good_type_code'=>$value['type_code'],"a.is_del"=>0])->field("a.wsm_code,b.name wsm_name,a.wait_in_stock,a.wait_out_stock,a.usable_stock,a.intra_stock,a.total_stock,a.warn_stock")->select();
  298. }
  299. $temp['good_name'] = $value['good_name'];
  300. $temp['good_code'] = $value['good_code'];
  301. $temp['type_code'] = $value['type_code'];
  302. $temp['unit'] = $value['unit'];
  303. $temp['sort_f']=$value['sort_f'];
  304. $temp['attribute']=$value['attribute'];
  305. $temp['addtime']=$value['addtime'];
  306. $temp['usable_stock'] = isset($wsm['usable_stock'])? $wsm['usable_stock']:"";
  307. $temp['wait_in_stock'] = isset($wsm['wait_in_stock'])? $wsm['wait_in_stock']:"";
  308. $temp['wait_out_stock'] = isset($wsm['wait_out_stock'])? $wsm['wait_out_stock']:"";
  309. $temp['intra_stock'] = isset($wsm['intra_stock'])? $wsm['intra_stock']:"";
  310. $temp['total_stock'] = isset($wsm['total_stock'])? $wsm['total_stock']:"";
  311. $temp['warn_stock'] = isset($wsm['warn_stock'])? $wsm['warn_stock']:"";
  312. $temp['child']=isset($child)&&!empty($child) ? $child:[];
  313. $data[]=$temp;
  314. }
  315. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  316. }
  317. /**
  318. * @return \think\response\Json|void
  319. * @throws \think\db\exception\DataNotFoundException
  320. * @throws \think\db\exception\DbException
  321. * @throws \think\db\exception\ModelNotFoundException
  322. */
  323. public function Stat(){
  324. $condition =[["is_del","=",0]];
  325. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  326. if($wsm_code!=""){
  327. //$condition["wsm_code"] = $wsm_code;
  328. $condition[]=["wsm_code","=",$wsm_code];
  329. }
  330. $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  331. if($suplierNo!==""){
  332. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"is_del"=>0])->column("wsm_code");
  333. $condition[]=["wsm_code","in",$wsmcode];
  334. }
  335. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  336. if($type_code!=""){
  337. $condition[] = ["good_type_code","=",$type_code];
  338. }
  339. $statlist = Db::name("good_stock")->where($condition)->field("sum(wait_in_stock) as wait_in_stock,sum(wait_out_stock) as wait_out_stock ,sum(usable_stock) as usable_stock,sum(intra_stock) as intra_stock,sum(total_stock) as total_stock,sum(warn_stock) as warn_stock")->find();
  340. return app_show(0,"获取成功",$statlist);
  341. }
  342. public function all(){
  343. $condtion=["a.is_del"=>0,"b.is_del"=>0];
  344. $wsmcode =isset($this->post['wsmcode']) &&$this->post['wsmcode'] !=="" ? trim($this->post['wsmcode']):"";
  345. if($wsmcode!=""){
  346. $typecode= Db::name("good_stock")->where(["wsm_code"=>$wsmcode,'is_del'=>0])->column("good_type_code");
  347. $condtion["b.type_code"] = $typecode;
  348. }
  349. $good_code =isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  350. if($good_code!=""){
  351. $condtion['b.type_code'] = $good_code;
  352. }
  353. $goodcode =isset($this->post['good_code']) &&$this->post['good_code'] !=="" ? trim($this->post['good_code'])
  354. :"";
  355. if($goodcode!=""){
  356. $condtion['a.good_code'] = $goodcode;
  357. }
  358. $good_name =isset($this->post['good_name']) &&$this->post['good_name'] !=="" ? trim($this->post['good_name'])
  359. :"";
  360. if($good_name!=""){
  361. $condtion['a.good_name'] = Db::raw("like '%{$good_name}%'");
  362. }
  363. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  364. if($supplierNo!=""){
  365. $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  366. if(empty($supplier)){
  367. return error_show(1004,"未找到供应商信息");
  368. }
  369. $condtion["a.gys_code"] = $supplierNo;
  370. }
  371. $list = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  372. ->where($condtion)->field("b.id,a.good_code,a.good_name,a.good_desc,a.brand,a.original_price,a.cg_saler,a.good_type,a.market_fee,a.gys_code,a.unit,
  373. a.sort_f,a.sort_s,a.sort_t,b.color,b.material,b.specs,b.is_main,b.type_code,b.attribute,b.status as bstatus,a.addtime,a.updatetime")
  374. ->select();
  375. $data=[];
  376. foreach ($list as $key=>$value){
  377. $stock = Db::name("good_stock")->where(["good_type_code"=>$value['type_code'],"is_del"=>0])->sum("usable_stock");
  378. $value['usable_stock']=$stock;
  379. $supplier = Db::name("supplier")->where(["code"=>$value['gys_code']])->find();
  380. $value['supplier_name'] =isset($supplier['name']) ?$supplier['name'] :"";
  381. $data[]=$value;
  382. }
  383. return app_show(0,"获取成功",$data);
  384. }
  385. }