Good.php 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494
  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. private $acton=[
  10. "allotsend"=>'调拨发货',
  11. "allotin"=>'调拨入库',
  12. "allotincheck"=>'调拨验货',
  13. 'CGD'=>'采购单',
  14. 'BHD'=>'备库单',
  15. 'FKD'=>'备库反馈单',
  16. 'RKD'=>'入库单',
  17. 'ZXQRD'=>'咨询单',
  18. 'XSQRD'=>'销售单',
  19. 'PDD'=>'盘点单',
  20. 'DBD'=>'调拨单',
  21. 'CKD'=>'出库单',
  22. 'CGTHD'=>'采购退货单',
  23. 'XSTHD'=>'销售退货单',
  24. 'CGGCD'=>'采购工差单',
  25. 'ZXGCD'=>'咨询工差单'
  26. ];
  27. public function __construct(App $app)
  28. {
  29. parent::__construct($app);
  30. $this->post = $this->request->post();
  31. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  32. if($token==""){
  33. return error_show(101,'token不能为空');
  34. }
  35. $effetc = VerifyTokens($token);
  36. if(!empty($effetc) && $effetc['code']!=0){
  37. return error_show($effetc['code'],$effetc['message']);
  38. }
  39. }
  40. public function list(){
  41. $page = isset($this->post['page']) && $this->post['page'] !==""? intval($this->post['page']):"1";
  42. $size = isset($this->post['size']) && $this->post['size'] !==""? intval($this->post['size']):"10";
  43. $where =[["a.is_del","=",0]];
  44. $cat_id = isset($this->post['cat_id']) && $this->post['cat_id'] !=="" ? trim($this->post['cat_id']):"";
  45. if($cat_id!==""){
  46. $where[]=['a.cat_id',"=",$cat_id];
  47. }
  48. $good_name = isset($this->post['good_name']) && $this->post['good_name'] !=="" ? trim($this->post['good_name']):"";
  49. if($good_name!==""){
  50. $where[]=['a.good_name',"like","%$good_name%"];
  51. }
  52. $spucode = isset($this->post['spucode']) && $this->post['spucode'] !=="" ? trim($this->post['spucode'])
  53. :"";
  54. if($spucode!==""){
  55. $where [] = ['a.spuCode',"like","%$spucode%"];
  56. }
  57. $start = isset($this->post['start']) && $this->post['start']!=="" ? $this->post['start']:"";
  58. if($start!==""){
  59. $where[]=['a.addtime',">=",date('Y-m-d H:i:s',strtotime($start))];
  60. }
  61. $end = isset($this->post['end']) && $this->post['end']!=="" ? $this->post['end']:"";
  62. if($end!==""){
  63. $where[]=['a.addtime',"<",date('Y-m-d H:i:s',strtotime($end)+24*3600)];
  64. }
  65. $is_stock = isset($this->post['is_stock']) && $this->post['is_stock'] !=="" ? intval($this->post['is_stock'])
  66. :"";
  67. if($is_stock!==""){
  68. $where[]=['is_stock',"=",$is_stock];
  69. }
  70. $good_type = isset($this->post['good_type']) && $this->post['good_type'] !=="" ? intval($this->post['good_type'])
  71. :"";
  72. if($good_type!==""){
  73. $where[]=['good_type',"=",$good_type];
  74. }
  75. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !=="" ? trim($this->post['supplierNo'])
  76. :"";
  77. if($supplierNo!==""){
  78. $where[]=['supplierNo',"=",$supplierNo];
  79. }
  80. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !=="" ? trim($this->post['companyNo']) :"";
  81. if($companyNo!==""){
  82. $where[]=['companyNo',"like","%$companyNo%"];
  83. }
  84. $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status'])
  85. :"";
  86. if($status!==""){
  87. $where[]=['a.status',"=",$status];
  88. }
  89. $platform_code = isset($this->post['platform_code']) && $this->post['platform_code'] !=="" ? trim($this->post['platform_code'])
  90. :"";
  91. if($platform_code!==""){
  92. //$platform = Db::name("good_platform")->where(["platform_code"=>$platform_code,"is_del"=>0])->column
  93. //("spuCode");
  94. $where[]=["platform_code","=",$platform_code];
  95. }
  96. $count = Db::name('good')->alias("a")->leftJoin("good_platform b","a.spuCode=b.spuCode")->where($where)
  97. ->count();
  98. $total = ceil($count / $size);
  99. $page = $page >= $total ? $total : $page;
  100. $list = Db::name('good')->alias("a")->leftJoin("good_platform b","a.spuCode=b.spuCode")->where($where)->page
  101. ($page,$size)->field("b.skuCode,b.platform_code,b.id as good_id,a.*")->order("addtime desc")->select();
  102. $data=[];
  103. foreach ($list as $value){
  104. $value['cat_info']= made($value['cat_id'],[]);
  105. $platform = Db::name("platform")->where(["platform_code"=>$value['platform_code']])->find();
  106. $value['platform_name'] = isset($platform['platform_name']) ? $platform['platform_name']:"";
  107. $supplier = Db::name("supplier")->where(["code"=>$value['supplierNo']])->find();
  108. $value['supplier_name'] = isset($supplier['name']) ? $supplier['name']:"";
  109. $brand=Db::name("brand")->where(["id"=>$value['brand_id']])->find();
  110. $value["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  111. $unit = Db::name("unit")->where(["id"=>$value['good_unit']])->find();
  112. $value['unit'] =isset($unit['unit'])?$unit['unit']:"";
  113. $company = Db::name("business")->where(["companyNo"=>$value['companyNo']])->find();
  114. $value['company'] = isset($company['company'])?$company['company']:"";
  115. $data[]=$value;
  116. }
  117. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  118. }
  119. public function SetWarn(){
  120. $condition=["is_del"=>0];
  121. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  122. if($wsm_code!=""){
  123. $condition["wsm_code"] = $wsm_code;
  124. }else{
  125. return error_show(1004,"参数wsm_code 不能为空");
  126. }
  127. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  128. if($type_code!=""){
  129. $condition["good_type_code"] = $type_code;
  130. }else{
  131. return error_show(1004,"参数type_code 不能为空");
  132. }
  133. $good= Db::name("good_stock")->where($condition)->find();
  134. if(empty($good)){
  135. return error_show(1005,"未找到数据");
  136. }
  137. $warn_stock = isset($this->post['warn_stock']) &&$this->post['warn_stock'] !=="" ? intval($this->post['warn_stock']):"";
  138. if($warn_stock===""){
  139. return error_show(1005,"参数warn_stock 不能为空");
  140. }
  141. $good['warn_stock'] = $warn_stock;
  142. $good['updatetime'] = date("Y-m-d H:i:s");
  143. $up= Db::name("good_stock")->save($good);
  144. if($up){
  145. $data=["stock_id"=>$good['id'],"type"=>1,'stock'=>$warn_stock,"stock_name"=>"warn_stock"];
  146. GoodLog::LogAdd($this->post['token'],$data,'setwarn');
  147. return app_show(0,"预警库存更新成功");
  148. }else{
  149. return error_show(1005,"预警库存更新失败");
  150. }
  151. }
  152. public function SetStatus(){
  153. $id = isset($this->post['id']) &&$this->post['id'] !=="" ? intval($this->post['id']):"";
  154. if($id===""){
  155. return error_show(1005,"参数id 不能为空");
  156. }
  157. $good= Db::name("good_type")->where(["id"=>$id,"is_del"=>0])->find();
  158. if(empty($good)){
  159. return error_show(1005,"未找到数据");
  160. }
  161. $good['status'] = $good['status']==1?0 :1;
  162. $good['updatetime'] = date("Y-m-d H:i:s");
  163. $msg = $good['status']==1?"下架" :"上架";
  164. $up= Db::name("good_type")->save($good);
  165. return $up ? app_show(0,"商品{$msg}成功"): error_show(1005,"商品{$msg}失败");
  166. }
  167. public function GetStock(){
  168. $condition = [["a.is_del","=",0]];
  169. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  170. if($type_code!==""){
  171. $condition[]=["a.good_type_code","=",$type_code];
  172. }
  173. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  174. :"";
  175. if($wsm_code!==""){
  176. //$condition["a.wsm_code"]=$wsm_code;
  177. $condition[]=["a.wsm_code","=",$type_code];
  178. }
  179. $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo'])
  180. :"";
  181. if($suplierNo!==""){
  182. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"wsm_type"=>1,"is_del"=>0])->column("wsm_code");
  183. $condition[]=["a.wsm_code","in",$wsmcode];
  184. }
  185. $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")
  186. ->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();
  187. if(empty($list)){
  188. return error_show(1004,"未找到数据");
  189. }
  190. return app_show(0,"获取成功",$list);
  191. }
  192. /**
  193. * @return \think\response\Json|void
  194. * @throws \think\db\exception\DataNotFoundException
  195. * @throws \think\db\exception\DbException
  196. * @throws \think\db\exception\ModelNotFoundException
  197. */
  198. public function GetStockBet(){
  199. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  200. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  201. $condition = [["is_del","=",0]];
  202. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  203. if($type_code!==""){
  204. $condition[]=["good_type_code","like","%{$type_code}%"];
  205. }
  206. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  207. :"";
  208. if($wsm_code!==""){
  209. $condition[]=["wsm_code","=",$wsm_code];
  210. }
  211. $suplierNo = isset($this->post['suplierNo']) &&$this->post['suplierNo'] !=="" ? trim($this->post['suplierNo'])
  212. :"";
  213. if($suplierNo!==""){
  214. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"wsm_type"=>1,"is_del"=>0])->column("wsm_code");
  215. $condition[]=["wsm_code","in",$wsmcode];
  216. }
  217. $start = isset($this->post['start']) &&$this->post['start'] !=="" ? $this->post['start']:"";
  218. $end = isset($this->post['end']) &&$this->post['end'] !=="" ? $this->post['end']:"";
  219. if($start!=""){
  220. $condition[]=["addtime",">=",$start];
  221. }
  222. if($end!=""){
  223. $condition[]=["addtime","<=",$end];
  224. }
  225. $count = Db::name("good_stock")->where($condition)->count();
  226. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  227. $list = Db::name("good_stock")->where($condition)->page($page,$size)->order("addtime desc")->select();
  228. $data=[];
  229. foreach ($list as $key=>$value){
  230. $temp=[];
  231. if($value['wsm_code']!=""){
  232. $wsm = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")->where
  233. (['a.wsm_code'=>$value['wsm_code'],"a.is_del"=>0])->field("a.name as wsm_name,wsm_code,b.code,b.name")
  234. ->find();
  235. }
  236. $temp['wsm_name'] = isset($wsm['wsm_name'])?$wsm['wsm_name']:"";
  237. $temp['wsm_code']=$value['wsm_code'];
  238. $temp['supplier_code']=isset($wsm['code'])?$wsm['code']:"";
  239. $temp['supplier_name']=isset($wsm['name'])?$wsm['name']:"";
  240. if($value['good_type_code']!=""){
  241. $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])
  242. ->field("a.good_code,a.type_code,b.good_name,b.unit,a.attribute,b.sort_f")->find();
  243. }
  244. $temp['good_code']=isset($good['good_code'])?$good['good_code']:"";
  245. $temp['type_code']=isset($good['type_code'])?$good['type_code']:"";
  246. $temp['good_name']=isset($good['good_name'])?$good['good_name']:"";
  247. $temp['unit']=isset($good['unit'])?$good['unit']:"";
  248. $temp['attribute']=isset($good['attribute'])?$good['attribute']:"";
  249. $temp['sort_f']=isset($good['sort_f'])?$good['sort_f']:"";
  250. $temp['usable_stock'] = $value['usable_stock'];
  251. $temp['wait_in_stock'] = $value['wait_in_stock'];
  252. $temp['wait_out_stock'] = $value['wait_out_stock'];
  253. $temp['intra_stock'] = $value['intra_stock'];
  254. $temp['total_stock'] = $value['total_stock'];
  255. $temp['warn_stock'] = $value['warn_stock'];
  256. $temp['id'] = $value['id'];
  257. $temp['out_total'] =0;
  258. $temp['in_total'] = 0;
  259. $temp['addtime'] = $value['addtime'];
  260. $data[]=$temp;
  261. }
  262. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  263. }
  264. /**
  265. * @return \think\response\Json|void
  266. * @throws \think\db\exception\DataNotFoundException
  267. * @throws \think\db\exception\DbException
  268. * @throws \think\db\exception\ModelNotFoundException
  269. * @throws \think\exception\DbException
  270. */
  271. public function GetStockWsm(){
  272. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  273. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  274. $condition = [["is_del","=",0]];
  275. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code'])
  276. :"";
  277. if($wsm_code!==""){
  278. $condition[]=["wsm_code","=",$wsm_code];
  279. }
  280. $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo'])
  281. :"";
  282. if($suplierNo!==""){
  283. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"wsm_type"=>1,"is_del"=>0])->column("wsm_code");
  284. $condition[]=["wsm_code","in",$wsmcode];
  285. }
  286. $build= Db::name("good_stock")->where($condition)->group("wsm_code")->field("wsm_code")->buildSql();
  287. $count = Db::table($build." a")->count();
  288. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  289. $list = Db::name("good_stock")->where($condition)->page($page,$size)->group("wsm_code")
  290. ->field("wsm_code,sum(wait_in_stock) wait_in_stock,sum(wait_out_stock) wait_out_stock,sum(usable_stock) usable_stock,
  291. sum(intra_stock) intra_stock,sum(warn_stock) warn_stock,sum(total_stock) total_stock")->select();
  292. $data=[];
  293. foreach ($list as $key=>$value){
  294. $temp=[];
  295. if($value['wsm_code']!=""){
  296. $wsm = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")->where
  297. (['a.wsm_code'=>$value['wsm_code'],"a.is_del"=>0])->field("a.name as wsm_name,wsm_code,b.code,b.name")
  298. ->find();
  299. $good = Db::name("good_stock")->alias("a")->join("good_type b","a.good_type_code=b.type_code","left")
  300. ->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])
  301. ->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")
  302. ->select();
  303. }
  304. $temp['wsm_name'] = isset($wsm['wsm_name'])?$wsm['wsm_name']:"";
  305. $temp['wsm_code']=$value['wsm_code'];
  306. $temp['supplier_code']=isset($wsm['code'])?$wsm['code']:"";
  307. $temp['supplier_name']=isset($wsm['name'])?$wsm['name']:"";
  308. $temp['usable_stock'] = $value['usable_stock'];
  309. $temp['wait_in_stock'] = $value['wait_in_stock'];
  310. $temp['wait_out_stock'] = $value['wait_out_stock'];
  311. $temp['intra_stock'] = $value['intra_stock'];
  312. $temp['total_stock'] = $value['total_stock'];
  313. // $temp['warn_stock'] = $value['warn_stock'];
  314. $temp['child']=isset($good)&&!empty($good) ? $good:[];
  315. $data[]=$temp;
  316. }
  317. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  318. }
  319. public function GetStockGod(){
  320. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  321. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  322. $condition = [["a.is_del","=",0],["b.is_del","=",0],["c.usable_stock",">",0]];
  323. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code'])
  324. :"";
  325. if($type_code!==""){
  326. $condition[]=["b.type_code","like","%{$type_code}%"];
  327. }
  328. $count = Db::name("good_type")->alias("b")
  329. ->join("good a","a.good_code = b.good_code","left")
  330. ->join("good_stock c","c.good_type_code = b.type_code","left")
  331. ->where($condition)->group("a.good_code,a.good_name,a.unit,a.sort_f,b.type_code,b.attribute,a.addtime")->count();
  332. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  333. $list = Db::name("good_type")->alias("b")
  334. ->join("good a","a.good_code = b.good_code","left")
  335. ->join("good_stock c","c.good_type_code = b.type_code","left")
  336. ->where($condition)->field("a.good_code,a.good_name,a.unit,a.sort_f,b.type_code,b.attribute,a.addtime,sum(c.wait_in_stock) wait_in_stock,
  337. sum(c.wait_out_stock) wait_out_stock,sum(c.usable_stock) usable_stock,sum(c.intra_stock) intra_stock,sum(c.warn_stock) warn_stock,sum(c.total_stock) total_stock")
  338. ->page($page,$size)->order("a.addtime desc")->group("a.good_code,a.good_name,a.unit,a.sort_f,b.type_code,b.attribute,a.addtime")->select();
  339. // echo Db::name("good_type")->getLastSql();
  340. $data=[];
  341. foreach ($list as $key=>$value){
  342. $temp=[];
  343. if($value['type_code']!=""){
  344. $child = Db::name("good_stock")->alias("a")->join("warehouse_info b","a.wsm_code=b.wsm_code","left")
  345. ->where(['a.good_type_code'=>$value['type_code'],"b.wsm_type"=>1,"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();
  346. }
  347. $temp['good_name'] = $value['good_name'];
  348. $temp['good_code'] = $value['good_code'];
  349. $temp['type_code'] = $value['type_code'];
  350. $temp['unit'] = $value['unit'];
  351. $temp['sort_f']=$value['sort_f'];
  352. $temp['attribute']=$value['attribute'];
  353. $temp['addtime']=$value['addtime'];
  354. $temp['usable_stock'] = isset($value['usable_stock'])? $value['usable_stock']:"";
  355. $temp['wait_in_stock'] = isset($value['wait_in_stock'])? $value['wait_in_stock']:"";
  356. $temp['wait_out_stock'] = isset($value['wait_out_stock'])? $value['wait_out_stock']:"";
  357. $temp['intra_stock'] = isset($value['intra_stock'])? $value['intra_stock']:"";
  358. $temp['total_stock'] = isset($value['total_stock'])? $value['total_stock']:"";
  359. // $temp['warn_stock'] = isset($value['warn_stock'])? $value['warn_stock']:"";
  360. $temp['child']=isset($child)&&!empty($child) ? $child:[];
  361. $data[]=$temp;
  362. }
  363. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  364. }
  365. /**
  366. * @return \think\response\Json|void
  367. * @throws \think\db\exception\DataNotFoundException
  368. * @throws \think\db\exception\DbException
  369. * @throws \think\db\exception\ModelNotFoundException
  370. */
  371. public function Stat(){
  372. $condition =[["is_del","=",0]];
  373. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  374. if($wsm_code!=""){
  375. //$condition["wsm_code"] = $wsm_code;
  376. $condition[]=["wsm_code","=",$wsm_code];
  377. }
  378. $suplierNo = isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  379. if($suplierNo!==""){
  380. $wsmcode = Db::name("warehouse_info")->where(['supplierNo'=>$suplierNo,"wsm_type"=>1,"is_del"=>0])->column("wsm_code");
  381. $condition[]=["wsm_code","in",$wsmcode];
  382. }
  383. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  384. if($type_code!=""){
  385. $condition[] = ["good_type_code","=",$type_code];
  386. }
  387. $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();
  388. return app_show(0,"获取成功",$statlist);
  389. }
  390. public function all(){
  391. $condtion=["a.is_del"=>0,"b.is_del"=>0];
  392. $wsmcode =isset($this->post['wsmcode']) &&$this->post['wsmcode'] !=="" ? trim($this->post['wsmcode']):"";
  393. if($wsmcode!=""){
  394. $typecode= Db::name("good_stock")->where(["wsm_code"=>$wsmcode,'is_del'=>0])->column("good_type_code");
  395. $condtion["b.type_code"] = $typecode;
  396. }
  397. $good_code =isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  398. if($good_code!=""){
  399. $condtion['b.type_code'] = $good_code;
  400. }
  401. $goodcode =isset($this->post['good_code']) &&$this->post['good_code'] !=="" ? trim($this->post['good_code'])
  402. :"";
  403. if($goodcode!=""){
  404. $condtion['a.good_code'] = $goodcode;
  405. }
  406. $good_name =isset($this->post['good_name']) &&$this->post['good_name'] !=="" ? trim($this->post['good_name'])
  407. :"";
  408. if($good_name!=""){
  409. $condtion['a.good_name'] = Db::raw("like '%{$good_name}%'");
  410. }
  411. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  412. if($supplierNo!=""){
  413. $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  414. if(empty($supplier)){
  415. return error_show(1004,"未找到供应商信息");
  416. }
  417. $condtion["a.gys_code"] = $supplierNo;
  418. }
  419. $list = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  420. ->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,
  421. 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")
  422. ->select();
  423. $data=[];
  424. foreach ($list as $key=>$value){
  425. $stock = Db::name("good_stock")->where(["good_type_code"=>$value['type_code'],"is_del"=>0])->sum("usable_stock");
  426. $value['usable_stock']=$stock;
  427. $supplier = Db::name("supplier")->where(["code"=>$value['gys_code']])->find();
  428. $value['supplier_name'] =isset($supplier['name']) ?$supplier['name'] :"";
  429. $data[]=$value;
  430. }
  431. return app_show(0,"获取成功",$data);
  432. }
  433. public function loglist(){
  434. $page = isset($this->post['page']) && $this->post['page']!==""? intval($this->post['page']) :"1";
  435. $size = isset($this->post['size']) && $this->post['size']!==""? intval($this->post['size']) :"10";
  436. $where=[];
  437. $wsm_code= isset($this->post['wsm_code']) && $this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  438. if($wsm_code!=""){
  439. $where[]=['b.wsm_code',"like","%$wsm_code%"];
  440. }
  441. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  442. if($supplierNo!=""){
  443. $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  444. if(empty($supplier)){
  445. return error_show(1004,"未找到供应商信息");
  446. }
  447. $wsmcode = Db::name("warehouse_info")->where([
  448. "is_del"=>0,"wsm_type"=>1,"supplierNo"=>$supplierNo])->column("wsm_code");
  449. $where[]=['b.wsm_code',"in",$wsmcode];
  450. }
  451. $count = Db::name("good_log")->alias('a')
  452. ->join("good_stock b","b.id=a.id","left")->where($where)
  453. ->join("good_type c","c.type_code=b.good_type_code","left")
  454. ->join("good v","v.good_code=c.good_code","left")->count();
  455. $total = ceil($count/$size);
  456. $page = $total>=$page ? $page :$total;
  457. $list = Db::name("good_log")->alias('a')
  458. ->join("good_stock b","b.id=a.stock_id","left")
  459. ->join("good_type c","c.type_code=b.good_type_code","left")
  460. ->join("good v","v.good_code=c.good_code","left")
  461. ->where($where)->page($page,$size)->order("a.addtime desc")
  462. ->field("a.action_name,a.type,a.stock_name,a.stock,a.action_type,
  463. a.addtime,a.action_uid,b.wsm_code,v.good_code,v.good_name,v.cat_id")->select();
  464. $data=[];
  465. foreach ($list as $value){
  466. $db = Db::name("depart_user")->where(['uid'=>$value['action_uid']])->column("itemid");
  467. $item = Db::name("company_item")->where(['id'=>$db])->column("id,name");
  468. $wsm = Db::name("warehouse_info")->alias("a")->Join("supplier b","a.supplierNo=b.code","left")->where
  469. (['a.wsm_code'=>$value['wsm_code'],"a.wsm_type"=>1,"a.is_del"=>0])->field("a.name as wsm_name,wsm_code,b.code,b.name")->find();
  470. $int = isset($value['cat_id']) && $value['cat_id'] != 0 ? made($value['cat_id']) : [];
  471. $value['wsm_name'] =$wsm['wsm_name'];
  472. $value['wsm_code'] =$wsm['wsm_code'];
  473. $value['code'] =$wsm['code'];
  474. $value['name'] =$wsm['name'];
  475. $value['action_type_cn'] =$this->acton[$value['action_type']];
  476. $value['item'] =$item;
  477. $value['can'] =$int;
  478. $data[]=$value;
  479. }
  480. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  481. }
  482. }