Good.php 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192
  1. <?php
  2. namespace app\admin\controller;
  3. use think\App;
  4. use think\facade\Db;
  5. class Good extends \app\BaseController
  6. {
  7. public $post="";
  8. public function __construct(App $app)
  9. {
  10. parent::__construct($app);
  11. $this->post = $this->request->post();
  12. // $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  13. // if($token==""){
  14. // return error_show(101,'token不能为空');
  15. // }
  16. // $effetc = VerifyTokens($token);
  17. // if(!empty($effetc) && $effetc['code']!=0){
  18. // return error_show($effetc['code'],$effetc['message']);
  19. // }
  20. }
  21. public function list(){
  22. $page = isset($this->post['page']) &&$this->post['page'] !=="" ? intval($this->post['page']):1;
  23. $size = isset($this->post['size']) &&$this->post['size'] !=="" ? intval($this->post['size']):10;
  24. $condtion=['a.is_del'=>0,'b.is_del'=>0];
  25. $wsmcode =isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  26. if($wsmcode!=""){
  27. $typecode= Db::name("good_stock")->where(["wsm_code"=>$wsmcode,'is_del'=>0])->column("good_type_code");
  28. $condtion["b.type_code"] = $typecode;
  29. }
  30. $good_code =isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  31. if($good_code!=""){
  32. $condtion['b.type_code'] = $good_code;
  33. }
  34. $goodcode =isset($this->post['good_code']) &&$this->post['good_code'] !=="" ? trim($this->post['good_code'])
  35. :"";
  36. if($goodcode!=""){
  37. $condtion['a.good_code'] = Db::raw("like '%{$goodcode}%'");
  38. }
  39. $good_name =isset($this->post['good_name']) &&$this->post['good_name'] !=="" ? trim($this->post['good_name'])
  40. :"";
  41. if($good_name!=""){
  42. $condtion['a.good_name'] = Db::raw("like '%{$good_name}%'");
  43. }
  44. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  45. if($supplierNo!=""){
  46. $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  47. if(empty($supplier)){
  48. return error_show(1004,"未找到供应商信息");
  49. }
  50. // $typecode = Db::name("good_stock")->alias("a")->join("warehouse_info b","a.wsm_code=b.wsm_code","left")->where(["a.is_del"=>0,
  51. // "b.is_del"=>0,"b.supplierNo"=>$supplierNo])->column("a.good_type_code");
  52. // if(empty($typecode)){
  53. // return error_show(1004,"未找到供应商有关的商品信息");
  54. // }
  55. $condtion["a.gys_code"] = $supplierNo;
  56. }
  57. $count = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  58. ->where($condtion)->count();
  59. $page>=ceil($count/$size) ? $page=ceil($count/$size) :"";
  60. $list = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  61. ->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,
  62. 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")
  63. ->page($page,$size)->select();
  64. $data=[];
  65. foreach ($list as $key=>$value){
  66. $stock = Db::name("good_stock")->where(["good_type_code"=>$value['type_code'],"is_del"=>0])->sum("usable_stock");
  67. $value['usable_stock']=$stock;
  68. $supplier = Db::name("supplier")->where(["code"=>$value['gys_code']])->find();
  69. $value['supplier_name'] =isset($supplier['name']) ?$supplier['name'] :"";
  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. }
  80. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  81. if($type_code!=""){
  82. $condition["good_type_code"] = $type_code;
  83. }
  84. $good= Db::name("good_stock")->where($condition)->find();
  85. if(empty($good)){
  86. return error_show(1005,"未找到数据");
  87. }
  88. $warn_stock = isset($this->post['warn_stock']) &&$this->post['warn_stock'] !=="" ? intval($this->post['warn_stock']):"";
  89. if($warn_stock===""){
  90. return error_show(1005,"参数warn_stock 不能为空");
  91. }
  92. $good['warn_stock'] = $warn_stock;
  93. $good['updatetime'] = date("Y-m-d H:i:s");
  94. $up= Db::name("good_stock")->save($good);
  95. return $up ? app_show(0,"预警库存更新成功"): error_show(1005,"预警库存更新失败");
  96. }
  97. public function SetStatus(){
  98. $id = isset($this->post['id']) &&$this->post['id'] !=="" ? intval($this->post['id']):"";
  99. if($id===""){
  100. return error_show(1005,"参数id 不能为空");
  101. }
  102. $good= Db::name("good_type")->where(["id"=>$id,"is_del"=>0])->find();
  103. if(empty($good)){
  104. return error_show(1005,"未找到数据");
  105. }
  106. $good['status'] = $good['status']==1?0 :1;
  107. $good['updatetime'] = date("Y-m-d H:i:s");
  108. $msg = $good['status']==1?"下架" :"上架";
  109. $up= Db::name("good_type")->save($good);
  110. return $up ? app_show(0,"商品{$msg}成功"): error_show(1005,"商品{$msg}失败");
  111. }
  112. public function GetStock(){
  113. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  114. if($type_code===""){
  115. return error_show(1005,"参数type_code 不能为空");
  116. }
  117. $good= Db::name("good_type")->where(["type_code"=>$type_code,"is_del"=>0])->find();
  118. if(empty($good)){
  119. return error_show(1005,"未找到数据");
  120. }
  121. $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")
  122. ->where(["a.is_del"=>0,"good_type_code"=>$type_code])->field("a.id,b.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();
  123. return app_show(0,"获取成功",$list);
  124. }
  125. public function Stat(){
  126. $condition =["is_del"=>0];
  127. $wsm_code = isset($this->post['wsm_code']) &&$this->post['wsm_code'] !=="" ? trim($this->post['wsm_code']):"";
  128. if($wsm_code!=""){
  129. $condition["wsm_code"] = $wsm_code;
  130. }
  131. $type_code = isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  132. if($type_code!=""){
  133. $condition["good_type_code"] = $type_code;
  134. }
  135. $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();
  136. return app_show(0,"获取成功",$statlist);
  137. }
  138. public function all(){
  139. $condtion=["a.is_del"=>0,"b.is_del"=>0];
  140. $wsmcode =isset($this->post['wsmcode']) &&$this->post['wsmcode'] !=="" ? trim($this->post['wsmcode']):"";
  141. if($wsmcode!=""){
  142. $typecode= Db::name("good_stock")->where(["wsm_code"=>$wsmcode,'is_del'=>0])->column("good_type_code");
  143. $condtion["b.type_code"] = $typecode;
  144. }
  145. $good_code =isset($this->post['type_code']) &&$this->post['type_code'] !=="" ? trim($this->post['type_code']):"";
  146. if($good_code!=""){
  147. $condtion['b.type_code'] = $good_code;
  148. }
  149. $goodcode =isset($this->post['good_code']) &&$this->post['good_code'] !=="" ? trim($this->post['good_code'])
  150. :"";
  151. if($goodcode!=""){
  152. $condtion['a.good_code'] = $goodcode;
  153. }
  154. $good_name =isset($this->post['good_name']) &&$this->post['good_name'] !=="" ? trim($this->post['good_name'])
  155. :"";
  156. if($good_name!=""){
  157. $condtion['a.good_name'] = Db::raw("like '%{$good_name}%'");
  158. }
  159. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  160. if($supplierNo!=""){
  161. $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  162. if(empty($supplier)){
  163. return error_show(1004,"未找到供应商信息");
  164. }
  165. $condtion["a.gys_code"] = $supplierNo;
  166. }
  167. $list = Db::name("good_type")->alias("b")->join("good a","a.good_code = b.good_code","left")
  168. ->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,
  169. 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")
  170. ->select();
  171. $data=[];
  172. foreach ($list as $key=>$value){
  173. $stock = Db::name("good_stock")->where(["good_type_code"=>$value['type_code'],"is_del"=>0])->sum("usable_stock");
  174. $value['usable_stock']=$stock;
  175. $supplier = Db::name("supplier")->where(["code"=>$value['gys_code']])->find();
  176. $value['supplier_name'] =isset($supplier['name']) ?$supplier['name'] :"";
  177. $data[]=$value;
  178. }
  179. return app_show(0,"获取成功",$data);
  180. }
  181. }