Purch.php 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\ActionLog;
  4. use think\App;
  5. use think\facade\Db;
  6. class Purch 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. }
  14. public function list(){
  15. $page = isset($this->post['page']) && $this->post['page'] !=="" ? intval($this->post['page']):"1";
  16. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']):"10";
  17. $where =[['is_del',"=",0]];
  18. $bkcode = isset($this->post['bk_code']) && $this->post['bk_code']!="" ? trim($this->post['bk_code']):"";
  19. if($bkcode!=""){
  20. $where[]=['bkcode',"like", "%{$bkcode}%"];
  21. }
  22. $status = isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):"";
  23. if($status!==""){
  24. // $where['status'] = $status;
  25. $where[]=['status',"=", $status];
  26. }
  27. $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ? trim($this->post['cgdNo'])
  28. :"";
  29. if($cgdNo!=""){
  30. //$where['cgdNo'] = Db::Raw("like '%{$cgdNo}%'");
  31. $where[]=['cgdNo',"like", "%{$cgdNo}%"];
  32. }
  33. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name']!="" ? trim($this->post['apply_name']):"";
  34. if($apply_name!=""){
  35. // $where['cgder'] =Db::Raw("like '%{$apply_name}%'");
  36. $where[]=['cgder',"like", "%{$apply_name}%"];
  37. }
  38. $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  39. if($wsm_code!=""){
  40. // $where['wsm_code'] = $wsm_code;
  41. $where[]=['wsm_code',"=", $wsm_code];
  42. }
  43. $wsm_in_code = isset($this->post['wsm_in_code']) && $this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']):"";
  44. if($wsm_in_code!=""){
  45. $incode = Db::name("purchease_in")->where(["wsm_in_code"=>Db::raw(" like %{$wsm_in_code}%"),"is_del"=>0])->column("cgdNo");
  46. if(empty($incode)){
  47. return error_show(1004,"未找到有关入库单信息");
  48. }
  49. $where[]=['cgdNo',"in", $incode];
  50. }
  51. $good_name = isset($this->post['good_name']) && $this->post['good_name']!="" ? trim($this->post['good_name']):"";
  52. if($good_name!=""){
  53. //$where['good_name'] = Db::raw(" like %{$good_name}%");
  54. $where[]=['good_name',"like", "%{$good_name}%"];
  55. }
  56. $good_code = isset($this->post['good_code']) && $this->post['good_code']!="" ? trim($this->post['good_code'])
  57. :"";
  58. if($good_code!=""){
  59. // $where['good_code'] = Db::raw(" like %{$good_code}%");
  60. $where[]=['good_code',"like", "%{$good_code}%"];
  61. }
  62. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo']!="" ? trim($this->post['supplierNo'])
  63. :"";
  64. if($supplierNo!=""){
  65. // $where['good_code'] = Db::raw(" like %{$good_code}%");
  66. $where[]=['supplierNo',"like", "%{$supplierNo}%"];
  67. }
  68. $wsm_supplierNo = isset($this->post['wsm_supplierNo']) && $this->post['wsm_supplierNo']!="" ? trim($this->post['wsm_supplierNo'])
  69. :"";
  70. if($wsm_supplierNo!=""){
  71. $supplier = Db::name("supplier")->where(["code"=>$wsm_supplierNo])->find();
  72. if(empty($supplier)){
  73. return error_show(1004,"未找到供应商信息");
  74. }
  75. $wsmcode = Db::name("warehouse_info")->where(["is_del"=>0,"supplierNo"=>$wsm_supplierNo])->column("wsm_code");
  76. $where[]=['wsm_code',"in", $wsmcode];
  77. }
  78. $start = isset($this->post['start']) && $this->post['start']!="" ?$this->post['start']:"";
  79. if($start!=""){
  80. // $where['addtime'] = Db::raw(" >= '{$start}'");
  81. $where[]=['addtime',">=", $start];
  82. }
  83. $end = isset($this->post['end']) && $this->post['end']!="" ?$this->post['end']:"";
  84. if($end!=""){
  85. $where[]=['addtime',"<=", $end];
  86. }
  87. $last_start = isset($this->post['last_start']) && $this->post['last_start']!="" ?$this->post['last_start']:"";
  88. if($last_start!=""){
  89. //$where['lasttime'] = Db::raw(" >= '{$last_start}'");
  90. $where[]=['lasttime',">=", $last_start];
  91. }
  92. $last_end = isset($this->post['last_end']) && $this->post['last_end']!="" ?$this->post['last_end']:"";
  93. if($last_end!=""){
  94. //$where['lasttime'] = Db::raw(" <= '{$last_end}'");
  95. $where[]=['lasttime',"<=", $last_end];
  96. }
  97. $count=Db::name("purchease_order")->where($where)->count();
  98. $total = ceil($count/$size);
  99. $page = $page >= $total ? $total : $page;
  100. $list = Db::name("purchease_order")->where($where)->page($page,$size)->order("addtime desc")->select();
  101. $data=[];
  102. foreach ($list as $value){
  103. $value['wsm_name']="";
  104. if($value['wsm_code']!=""){
  105. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  106. ->where(["a.wsm_code"=>$value['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find();
  107. $value['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  108. $value['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  109. $value['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  110. }
  111. $inorder= Db::name("purchease_in")->where(['cgdNo'=>$value['cgdNo'],"is_del"=>0])->select();
  112. $value['child']=empty($inorder)? [] : $inorder;
  113. $data[]=$value;
  114. }
  115. return app_show(0,"获取成功",["list"=>$list ,"count"=>$count]);
  116. }
  117. public function info(){
  118. $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ?trim($this->post['cgdNo']):"";
  119. if($cgdNo==""){
  120. return error_show(1004,"参数cgdNo 不能为空");
  121. }
  122. $data = Db::name("purchease_order")->where(["cgdNo"=>$cgdNo,"is_del"=>0])->find();
  123. if(empty($data)){
  124. return error_show(1004,"未找到数据");
  125. }
  126. $im = Db::name('purchease_back')->where(['cgdNo'=>$data['cgdNo'],'is_del'=>0])->select();
  127. //$var = Db::name('purchease_in')->where(['cgdNo'=>$data['cgdNo'],'is_del'=>0])->select();
  128. $dom = Db::name("purchease_diff")->where(['cgdNo'=>$data['cgdNo'],'is_del'=>0])->select();
  129. $goon = Db::name('good')->where(['good_code'=>$data['good_code']])->field("cat_id")->find();
  130. if(empty($goon)){
  131. return error_show(1002,"未找到商品数据");
  132. }
  133. $int= isset($goon['cat_id']) && $goon['cat_id'] !=0 ? made($goon['cat_id']):[];
  134. $data['wsm_name']="";
  135. if($data['wsm_code']!=""){
  136. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  137. ->leftJoin("warehouse_addr c","a.wsm_code=c.wsm_code and c.is_del=0")
  138. ->where(["a.wsm_code"=>$data['wsm_code']])->field("a.name as wsm_name,b.name,b.code,c.wsm_name as wsm_contactor,c.wsm_mobile,c.wsm_addr,c.addr_code")->find();
  139. $data['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  140. $data['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  141. $data['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  142. $data['wsm_contactor'] =isset($wsmcode['wsm_contactor']) ? $wsmcode['wsm_contactor']:"";
  143. $data['wsm_mobile'] =isset($wsmcode['wsm_mobile']) ? $wsmcode['wsm_mobile']:"";
  144. // $data['wsm_addr'] =isset($wsmcode['wsm_addr']) ? $wsmcode['wsm_addr']:"";
  145. $data['addr_code'] =isset($wsmcode['addr_code']) ? $wsmcode['addr_code']:"";
  146. $data['wsm_addr'] =isset($wsmcode['addr_code']) ? GetAddr($wsmcode['addr_code']):"";
  147. $data['wsm_addr'].=isset($wsmcode['wsm_addr']) ? $wsmcode['wsm_addr']:"";
  148. $inorder= Db::name("purchease_in")->where(['cgdNo'=>$data['cgdNo'],"is_del"=>0])->select();
  149. $data['child']=empty($inorder)? [] : $inorder;
  150. }
  151. $feed = Db::name("purchease_feedback")->where(['bkcode'=>$data['bkcode'],'is_del'=>0])->find();
  152. $data['feedback'] = [];
  153. if(!empty($feed)){
  154. $feed['wsm_name']="";
  155. if($feed['warehouse']!=""){
  156. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  157. ->where(["a.wsm_code"=>$feed['warehouse']])->field("a.name as wsm_name,b.name,b.code")->find();
  158. $feed['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  159. $feed['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  160. $feed['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  161. }
  162. if($feed['supplier']!=""){
  163. $supplie = Db::name("supplier")->where(['code'=>$feed['supplier'],"is_del"=>0])->find();
  164. $feed['supplier_name'] =isset($supplie['name']) ? $supplie['name']:"";
  165. }
  166. $data['feedback'] = $feed;
  167. $data['can'] = $int;
  168. $data['var'] = $dom;
  169. //$data['info'] = $var;
  170. $data['item'] = $im;
  171. }
  172. return app_show(0,"获取成功",$data);
  173. }
  174. public function edit(){
  175. $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ?trim($this->post['cgdNo']):"";
  176. if($cgdNo==""){
  177. return error_show(1004,"参数cgdNo 不能为空");
  178. }
  179. $data = Db::name("purchease_order")->where(["cgdNo"=>$cgdNo,"is_del"=>0])->find();
  180. if(empty($data)){
  181. return error_show(1004,"未找到数据");
  182. }
  183. $order = ["order_code"=>$cgdNo,"status"=> $data['status'] ,"action_remark"=>$this->post['remark'],"action_type"=>"edit"];
  184. $wsm_code = isset($this->post['wsm_code'])&&$this->post['wsm_code']!=""? trim($this->post['wsm_code']):"";
  185. if($wsm_code!=""){
  186. $ware = Db::name("warehouse_info")->where(["wsm_code"=>$wsm_code,"is_del"=>0])->find();
  187. if(empty($ware)){
  188. return error_show(1004,"未找到仓库信息");
  189. }
  190. // $good = Db::name("good_stock")->where(["wsm_code"=>$wsm_code,"good_type_code"=>$data['good_type_code'],"is_del"=>0])->find();
  191. // if(empty($good)){
  192. // return error_show(1004,"未找到仓库下商品信息");
  193. // }
  194. $data['wsm_code'] = $wsm_code;
  195. }
  196. $cgdid = isset($this->post['cgder_id'])&&$this->post['cgder_id']!=""?intval($this->post['cgder_id']):"";
  197. if($cgdid!=''){
  198. $cgduser = GetInfoById($this->post['token'],["id"=>$cgdid]);
  199. if((!empty($cgduser) && $cgduser['code']!=0) ||empty($cgduser) ){
  200. return error_show($cgduser['code'],$cgduser['message']);
  201. }
  202. $userinfo = $cgduser['data'];
  203. $data['cgder_id'] = $cgdid;
  204. $data['cgder'] = $userinfo['nickname'];
  205. }
  206. $good_num = isset($this->post['good_num'])&&$this->post['good_num']!=""?intval($this->post['good_num']):"";
  207. if($good_num!=""){
  208. $data['good_num'] = $good_num;
  209. }
  210. $good_price = isset($this->post['good_price'])&&$this->post['good_price']!=""?$this->post['good_price']:"";
  211. if($good_price!=""){
  212. $data['good_price'] = $good_price;
  213. }
  214. // $total_fee = isset($this->post['total_fee'])&&$this->post['total_fee']!=""?$this->post['total_fee']:"";
  215. // if($total_fee!=""){
  216. // $data['total_fee'] = $total_fee;
  217. // }
  218. $pakge_fee = isset($this->post['pakge_fee'])&&$this->post['pakge_fee']!=""?$this->post['pakge_fee']:"";
  219. if($pakge_fee!=""){
  220. $data['pakge_fee'] = $pakge_fee;
  221. }
  222. $cert_fee = isset($this->post['cert_fee'])&&$this->post['cert_fee']!=""?$this->post['cert_fee']:"";
  223. if($cert_fee!=""){
  224. $data['cert_fee'] = $cert_fee;
  225. }
  226. $open_fee = isset($this->post['open_fee'])&&$this->post['open_fee']!=""?$this->post['open_fee']:"";
  227. if($open_fee!=""){
  228. $data['open_fee'] = $open_fee;
  229. }
  230. $delivery_fee = isset($this->post['delivery_fee'])&&$this->post['delivery_fee']!=""?$this->post['delivery_fee']:"";
  231. if($delivery_fee!=""){
  232. $data['delivery_fee'] = $delivery_fee;
  233. }
  234. $mark_fee = isset($this->post['mark_fee'])&&$this->post['mark_fee']!=""?$this->post['mark_fee']:"";
  235. if($mark_fee!=""){
  236. $data['mark_fee'] = $mark_fee;
  237. }
  238. $teach_fee = isset($this->post['teach_fee'])&&$this->post['teach_fee']!=""?$this->post['teach_fee']:"";
  239. if($teach_fee!=""){
  240. $data['teach_fee'] = $teach_fee;
  241. }
  242. $nake_fee = isset($this->post['nake_fee'])&&$this->post['nake_fee']!=""?$this->post['nake_fee']:"";
  243. if($nake_fee!=""){
  244. $data['nake_fee'] = $nake_fee;
  245. }
  246. $weight = isset($this->post['weight'])&&$this->post['weight']!=""?$this->post['weight']:"";
  247. if($weight!=""){
  248. $data['weight'] = $weight;
  249. }
  250. $diff_weight = isset($this->post['diff_weight'])&&$this->post['diff_weight']!=""?$this->post['diff_weight']:"";
  251. if($diff_weight!=""){
  252. $data['diff_weight'] = $diff_weight;
  253. }
  254. $diff_fee = isset($this->post['diff_fee'])&&$this->post['diff_fee']!=""?$this->post['diff_fee']:"";
  255. if($diff_fee!=""){
  256. $data['diff_fee'] = $diff_fee;
  257. }
  258. $supplierNo = isset($this->post['supplierNo'])&&$this->post['supplierNo']!=""?trim($this->post['supplierNo'])
  259. :"";
  260. if($supplierNo!=""){
  261. $supplier =Db::name("supplier")->where(['code'=>$supplierNo])->find();
  262. if(empty($supplier)){
  263. return error_show(1004,"未找到供应商信息");
  264. }
  265. $data['supplierNo'] = $supplierNo;
  266. $data['supplier_name'] = $supplier['name'];
  267. }
  268. $remark = isset($this->post['remark'])&&$this->post['remark']!=""?trim($this->post['remark']):"";
  269. if($remark!=""){
  270. $data['remark'] = $remark;
  271. }
  272. $data['good_price'] = round(($data['pakge_fee']+$data['weight']*$data['gold_price']+$data['nake_fee']+$data['mark_fee']+$data['cert_fee']+$data['open_fee']/$data['good_num']
  273. +$data['teach_fee']*$data['weight']+$data['delivery_fee']),2);
  274. $data['total_fee'] = round($data['good_price']*$data['good_num'],2);
  275. $data['updatetime'] =date("Y-m-d H:i:s");
  276. $upd=Db::name("purchease_order")->save($data);
  277. if($upd){
  278. ActionLog::logAdd($this->post['token'],$order,'cgd',$data['status'],$this->post);
  279. return app_show(0,"更新成功");
  280. }else{
  281. return error_show(1004,'更新失败');
  282. }
  283. }
  284. public function status(){
  285. $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ?trim($this->post['cgdNo']):"";
  286. if($cgdNo==""){
  287. return error_show(1004,"参数cgdNo 不能为空");
  288. }
  289. $data = Db::name("purchease_order")->where(["cgdNo"=>$cgdNo,"is_del"=>0])->find();
  290. if(empty($data)){
  291. return error_show(1004,"未找到数据");
  292. }
  293. $remark= isset($this->post['remark']) && $this->post['remark']!="" ?trim($this->post['remark']):"";
  294. $status = isset($this->post['status'])&&$this->post['status']!==""? intval($this->post['status']):"";
  295. if($status===""){
  296. return error_show(1004,"参数status 不能为空");
  297. }
  298. if($data['send_status']>1 && $status==0){
  299. return error_show(1004,"采购单发货中无法取消");
  300. }
  301. $order = ["order_code"=>$cgdNo,"status"=> $data['status'] ,"action_remark"=>$remark,"action_type"=>"status"];
  302. $data['status'] = $status;
  303. $data['remark'] = $remark;
  304. $data['updatetime'] =date("Y-m-d H:i:s");
  305. $upd=Db::name("purchease_order")->save($data);
  306. if($upd){
  307. ActionLog::logAdd($this->post['token'],$order,'cgd',$status,$this->post);
  308. return app_show(0,"更新成功");
  309. }else{
  310. return error_show(1004,'更新失败');
  311. }
  312. }
  313. public function diffcreat(){
  314. $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):"";
  315. //$cgdNo=makeNo("CG");
  316. $cgdNo = $this->post['cgdNo'] && $this->post['cgdNo'] !=="" ? trim($this->post['cgdNo']) :"";
  317. if($cgdNo==""){
  318. return error_show(1002,"参数good_code不能为空");
  319. }
  320. $cg = Db::name('purchease_order')->where(['cgdNo'=>$cgdNo,'is_del'=>0])->find();
  321. if($cg==""){
  322. return error_show(1002,"未找到采购单数据");
  323. }
  324. $gd= Db::name('good')->where(['good_code'=>$cg['good_code']])->find();
  325. if($gd==""){
  326. return error_show(1002,"未找到商品数据");
  327. }
  328. $diff_weight = isset($this->post['diff_weight']) && $this->post['diff_weight'] !=="" ? trim($this->post['diff_weight']) :"";
  329. if($diff_weight==""){
  330. return error_show(1002,"参数diff_weight不能为空");
  331. }
  332. $apply_id =GetUserInfo($token);
  333. if(empty($apply_id)||$apply_id['code']!=0){
  334. return error_show(1002,"申请人数据不存在");
  335. }
  336. $rid= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  337. $rname= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  338. $diff_price = $diff_weight*$cg['gold_price'];
  339. // $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']) :"";
  340. $data=[
  341. "cgdNo"=>$cgdNo,
  342. "good_code"=>$cg['good_type_code'],
  343. "good_kode"=>$cg['good_code'],
  344. "good_name"=>$cg['good_name'],
  345. "sale_price"=>$cg['good_price'],
  346. "good_weight"=>$cg['weight'],
  347. "good_num"=>$cg['good_num'],
  348. "apply_id"=>$rid,
  349. "apply_name"=>$rname,
  350. "diff_weight"=>$diff_weight,
  351. "diff_price"=>$diff_price,
  352. "gold_price"=>$cg['gold_price'],
  353. "status"=>1,
  354. "is_del"=>0,
  355. "addtime"=>date("Y-m-d H:i:s"),
  356. "updatetime"=>date("Y-m-d H:i:s")
  357. ];
  358. Db::startTrans();
  359. try{
  360. $item = Db::name("purchease_diff")->insert($data);
  361. if($item){
  362. $stm = ["order_code"=>$cgdNo,"status"=>1,"action_remark"=>'',"action_type"=>"create"];
  363. ActionLog::logAdd($this->post['token'],$stm,"BKD",1,$stm);
  364. if($cg['order_type']==2){
  365. $order = Db::name("sale")->where(["orderCode"=>$cg['bkcode']])->find();
  366. if(empty($order)){
  367. Db::rollback();
  368. return error_show(1002,"未找到确认单信息");
  369. }
  370. $data=[
  371. "orderCode"=>$cg['bkcode'],
  372. "good_code"=>$cg['good_type_code'],
  373. "good_kode"=>$cg['good_code'],
  374. "good_name"=>$cg['good_name'],
  375. "diff_weight"=>$diff_weight,
  376. "diff_price"=>$diff_weight*$cg['gold_price'],
  377. "gold_price"=>$cg['gold_price'],
  378. "status"=>1,
  379. "addtime"=>date("Y-m-d H:i:s"),
  380. "updatetime"=>date("Y-m-d H:i:s")
  381. ];
  382. $cgd = Db::name('sale_diff')->insert($data);
  383. if($cgd){
  384. $sto = ["order_code"=>$cg['bkcode'],"status"=>1,"action_remark"=>'',"action_type"=>"create"];
  385. ActionLog::logAdd($this->post['token'],$sto,"BKD",1,$sto);
  386. Db::commit();
  387. return error_show(0,"新建成功");
  388. }else{
  389. Db::rollback();
  390. return error_show(1002,"新建失败");
  391. }
  392. }
  393. Db::commit();
  394. return error_show(0,"新建成功");
  395. }else{
  396. Db::rollback();
  397. return error_show(1002,"新建失败");
  398. }
  399. }catch (\Exception $e){
  400. Db::rollback();
  401. return error_show(1002,$e->getMessage());
  402. }
  403. }
  404. public function difflist(){
  405. $page = isset($this->post['page']) && $this->post['page'] !==""? intval($this->post['page']):"1";
  406. $size = isset($this->post['size']) && $this->post['size'] !==""? intval($this->post['size']):"10";
  407. $where = [['a.is_del',"=",0]];
  408. $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!="" ? trim($this->post['cgdNo']):"";
  409. if($cgdNo!=""){
  410. $where[]=['a.cgdNo',"like", "%$cgdNo%"];
  411. }
  412. $status = isset($this->post['status']) && $this->post['status'] !==""? intval($this->post['status']):"";
  413. if($status!==""){
  414. $where[]=['a.status',"=",$status];
  415. }
  416. $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:"";
  417. if ($start !="") {
  418. $where[]= ["a.addtime",'>=',$start];
  419. }
  420. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :"";
  421. if($end !=""){
  422. $where[]= ["a.addtime",'<=',$end];
  423. }
  424. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !==""? intval($this->post['apply_name']):"";
  425. if($apply_name!==""){
  426. $where[]=['a.apply_name',"like","%$apply_name%"];
  427. }
  428. $count = Db::name('purchease_diff')->alias('a')->join("good b","b.good_code=a.good_kode","left")
  429. ->where($where)->count();
  430. $total = ceil($count/$size);
  431. $page = $page >= $total ? $total : $page;
  432. $list = Db::name('purchease_diff')->alias('a')->join("good b","b.good_code=a.good_kode","left")
  433. ->where($where)->page($page,$size)->order("a.addtime desc")->field("a.*,b.cat_id")->select();
  434. $data=[];
  435. foreach ($list as $value){
  436. $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
  437. $data[]=$value;
  438. }
  439. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  440. }
  441. public function diffinfo(){
  442. $id = isset($this->post['id']) && $this->post['id'] !=="" ? trim($this->post['id']) :"";
  443. if($id==""){
  444. return error_show(1002,"参数id 不能为空");
  445. }
  446. $idinf = Db::name('purchease_diff')->where(['id'=>$id,'is_del'=>0])->find();
  447. if($idinf==false){
  448. return error_show(1002,"未找到采购工差单数据");
  449. }
  450. $dn = Db::name('purchease_order')->where(['cgdNo'=>$idinf['cgdNo'],'is_del'=>0])->field('order_type')->find();
  451. $goon = Db::name('good')->where(['good_code'=>$idinf['good_kode']])->find();
  452. if(empty($goon)){
  453. return error_show(1002,"未找到商品数据");
  454. }
  455. $int= isset($goon['cat_id']) && $goon['cat_id'] !=0 ? made($goon['cat_id']):[];
  456. $idinf['can']=$int;
  457. $idinf['order_type']=$dn['order_type'];
  458. return app_show(0,"获取成功",$idinf);
  459. }
  460. public function diffstatu(){
  461. $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) :"";
  462. if($id==""){
  463. return error_show(1002,"参数id不能为空");
  464. }
  465. $dio = Db::name('purchease_diff')->where(['id'=>$id,'is_del'=>0])->find();
  466. if(empty($dio)){
  467. return error_show(1002,"退货订单未找到");
  468. }
  469. $cgd = Db::name("purchease_order")->where(['cgdNo'=>$dio['cgdNo']])->find();
  470. if(empty($cgd)){
  471. return error_show(1002,"采购单未找到");
  472. }
  473. $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']) :"";
  474. if($status===""){
  475. return error_show(1002,"参数status不能为空");
  476. }
  477. $temp = $dio['status'];
  478. $dio['status']=$status;
  479. $dio['updatetime']=date("Y-m-d H:i:s");
  480. $item = Db::name("purchease_diff")->update($dio);
  481. if ($item){
  482. $sto = ["order_code"=>$id,"status"=>$temp,"action_remark"=>'',"action_type"=>"create"];
  483. ActionLog::logAdd($this->post['token'],$sto,"cgd",$dio['status'],$sto);
  484. return error_show(0,"更新成功");
  485. }else{
  486. return error_show(1002,"更新失败");
  487. }
  488. }
  489. }