Purchin.php 56 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\ActionLog;
  4. use app\admin\model\GoodLog;
  5. use app\admin\model\ProcessOrder;
  6. use app\BaseController;
  7. use think\facade\Db;
  8. use think\App;
  9. //采购单入库
  10. class Purchin extends Base
  11. {
  12. public function __construct(App $app)
  13. {
  14. parent::__construct($app);
  15. // $this->post=$this->request->post();
  16. }
  17. public function list(){
  18. $page = isset($this->post['page']) && $this->post['page'] !==""? intval($this->post['page']):"1";
  19. $size = isset($this->post['size']) && $this->post['size'] !==""? intval($this->post['size']):"10";
  20. $where =[['a.is_del',"=",0],['b.is_del',"=",0]];
  21. $wsm_in_code=isset($this->post['wsm_in_code']) && $this->post['wsm_in_code']!==""? trim($this->post['wsm_in_code']) :"";
  22. if($wsm_in_code!=""){
  23. $where[]=["a.wsm_in_code",'like',"%$wsm_in_code%"];
  24. }
  25. $cgdNo= isset($this->post['cgdNo']) && $this->post['cgdNo'] !==""? trim($this->post['cgdNo']) :"";
  26. if($cgdNo!=""){
  27. $where[]=['a.cgdNo','like',"%$cgdNo%"];
  28. }
  29. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !==""? trim($this->post['apply_name']):"";
  30. if($apply_name!=""){
  31. $where[]=['a.apply_name','like',"%$apply_name%"];
  32. }
  33. $apply_id= isset($this->post['apply_id']) && $this->post['apply_id'] !==""? trim($this->post['apply_id']):"";
  34. if($apply_id!=""){
  35. $where[]=['a.apply_id','=',$apply_id];
  36. }
  37. $status= isset($this->post['status']) && $this->post['status'] !==""? trim($this->post['status']):"";
  38. if($status!=""){
  39. $where[]=['a.status','=',$status];
  40. }
  41. $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:"";
  42. if ($start !="") {
  43. $where[]= ["a.sendtime",'>=',$start];
  44. }
  45. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :"";
  46. if($end !=""){
  47. $where[]= ["a.sendtime",'<=',$end];
  48. }
  49. $order_type=isset($this->post['order_type']) && $this->post['order_type']!==""? intval($this->post['order_type']):"";
  50. if($order_type !=""){
  51. $where[]= ["b.order_type",'=',$order_type];
  52. }
  53. $good_type_code=isset($this->post['good_type_code']) && $this->post['good_type_code']!==""? trim($this->post['good_type_code']):"";
  54. if($good_type_code !=""){
  55. $where[]= ["b.spuCode",'like',"%$good_type_code%"];
  56. }
  57. $good_name=isset($this->post['good_name']) && $this->post['good_name']!==""? trim($this->post['good_name']):"";
  58. if($good_name !=""){
  59. $where[]= ["b.good_name",'like',"%$good_name%"];
  60. }
  61. $supplie=isset($this->post['supplier']) && $this->post['supplier']!==""? trim($this->post['supplier']):"";
  62. if($supplie !=""){
  63. $where[]= ["b.supplierNo",'like',"%$supplie%"];
  64. }
  65. $wsm_code=isset($this->post['wsm_code']) && $this->post['wsm_code']!==""? trim($this->post['wsm_code']):"";
  66. if($wsm_code !=""){
  67. $where[]= ["a.wsm_code",'=',$wsm_code];
  68. }
  69. $supplierNo =isset($this->post['supplierNo']) &&$this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']):"";
  70. if($supplierNo!=""){
  71. $supplier = Db::name("supplier")->where(["code"=>$supplierNo])->find();
  72. if(empty($supplier)){
  73. return error_show(1004,"未找到供应商信息");
  74. }
  75. $wsmcode = Db::name("warehouse_info")->where([
  76. "is_del"=>0,"supplierNo"=>$supplierNo])->column("wsm_code");
  77. $where[]=['a.wsm_code',"in",$wsmcode];
  78. }
  79. $role=$this->checkRole();
  80. if(!empty($role['write'])){
  81. $where[]=["apply_id","in",$role['write']];
  82. }
  83. $count = Db::name('purchease_in')->alias('a')->join("purchease_order b","b.cgdNo=a.cgdNo","left")
  84. ->where($where)->count();
  85. $total = ceil($count/$size);
  86. $page = $page >= $total ? $total : $page;
  87. $list = Db::name('purchease_in')->alias('a')->join("purchease_order b","b.cgdNo=a.cgdNo","left")
  88. ->where($where)->page($page,$size)
  89. ->field("a.apply_name,a.sendtime,b.order_type,a.status,a.cgdNo,a.wsm_in_code,a.send_num,a.wsm_code,b.good_name,b.spuCode,
  90. a.post_company,a.post_code,a.post_fee,a.apply_id,a.wsm_num,a.error_num,a.wait_num,a.status,a.check_name,a.checkid,b.bkcode,b.supplierNo")
  91. ->order("a.addtime desc")->select();
  92. $data=[];
  93. foreach ($list as $value){
  94. //获取规格、品牌信息
  95. if ($value['order_type'] == 3 || $value['order_type'] == 4) {
  96. $temp = Db::name('good_zixun')
  97. ->alias('gz')
  98. ->field('gz.specinfo,b.brand_name')
  99. ->join('brand b', 'b.id=gz.brand_id')
  100. ->where(['gz.spuCode' => $value['spuCode'], 'gz.is_del' => 0])
  101. ->find();
  102. $value["brand_name"] = $temp['brand_name'];
  103. $value["speclist"] = json_decode($temp['specinfo'], true);
  104. } else {
  105. $value['brand_name'] = Db::name('good_basic')
  106. ->alias('gb')
  107. ->join('brand b', 'b.id=gb.brand_id')
  108. ->where(['gb.spuCode' => $value['spuCode']])
  109. ->value('b.brand_name');
  110. $spec = Db::name("good_spec")
  111. ->where(["spuCode" => $value['spuCode'], "is_del" => 0])
  112. ->select()
  113. ->toArray();
  114. $speclist = [];
  115. if (!empty($spec)) {
  116. foreach ($spec as $val) {
  117. $temp = [];
  118. $temp['id'] = $val['id'];
  119. $temp['spuCode'] = $val['spuCode'];
  120. $temp['spec_id'] = $val['spec_id'];
  121. $temp['spec_value_id'] = $val['spec_value_id'];
  122. $sp = Db::name("specs")->where(["id" => $val['spec_id']])->find();
  123. $temp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
  124. $spv = Db::name("spec_value")->where(["id" => $val['spec_value_id']])->find();
  125. $temp['spec_value'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
  126. $speclist[] = $temp;
  127. }
  128. }
  129. $value["speclist"] = empty($speclist) ? [] : $speclist;
  130. }
  131. $wsmcode = Db::name("warehouse_info")->alias("k")->leftJoin("supplier c","k.supplierNo=c.code")
  132. ->where(["k.wsm_code"=>$value['wsm_code']])->field("k.name as wsm_name,c.name,c.code")->find();
  133. $value['wsm_name'] = $wsmcode['wsm_name'];
  134. $value['wsm_supplier'] = $wsmcode['name'];
  135. $value['wsm_supplierNo'] = $wsmcode['code'];
  136. $data[]=$value;
  137. }
  138. return app_show(0,"获取成功",['list'=>$data,'count'=>$count]);
  139. }
  140. public function add(){
  141. $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo']!=""? trim($this->post['cgdNo']):"";
  142. if($cgdNo==""){
  143. return error_show(1005,"参数cgdNo 不能为空");
  144. }
  145. $cgdinfo = Db::name("purchease_order")->where(['cgdNo'=>$cgdNo,'is_del'=>0])->find();
  146. if(empty($cgdinfo)){
  147. return error_show(1005,"未找到采购单数据");
  148. }
  149. if($cgdinfo['status']==0){
  150. return error_show(1005,"采购单未发货");
  151. }
  152. $wsm_in_code = makeNo("CF");
  153. // $wsm_code = isset($this->post['wsm_code'])&&$this->post['wsm_code']!="" ? trim($this->post['wsm_code']):"";
  154. // if($wsm_code==""){
  155. // return error_show(1004,"参数 wsm_code 不能为空");
  156. // }
  157. $wsminfo = Db::name("warehouse_info")->where(["wsm_code"=>$cgdinfo['wsm_code'],"is_del"=>0])->find();
  158. if(empty($wsminfo)){
  159. return error_show(1004,"未找到仓库信息");
  160. }
  161. $recep = Db::name('warehouse_addr')->where(["wsm_code"=>$cgdinfo['wsm_code'],"is_del"=>0])->find();
  162. $sendtype = isset($this->post['sendtype'])&&$this->post['sendtype']!="" ? intval($this->post['sendtype']):"";
  163. if($sendtype==""){
  164. return error_show(1004,"参数 sendtype 不能为空");
  165. }
  166. $data = GetUserInfo($this->post['token']);
  167. if((!empty($data) && $data['code']!=0) ||empty($data) ){
  168. return error_show($data['code'],$data['message']);
  169. }
  170. $userinfo = $data['data'];
  171. $post_company = isset($this->post['post_company'])&&$this->post['post_company']!="" ? trim($this->post['post_company']):"";
  172. $post_code = isset($this->post['post_code'])&&$this->post['post_code']!="" ? trim($this->post['post_code']):"";
  173. $post_fee = isset($this->post['post_fee'])&&$this->post['post_fee']!="" ? $this->post['post_fee']:"0";
  174. $post_time = isset($this->post['post_time'])&&$this->post['post_time']!="" ? $this->post['post_time']:date("Y-m-d H:i:s");
  175. $send_num = isset($this->post['send_num'])&&$this->post['send_num']!="" ? intval($this->post['send_num']):"";
  176. $status = isset($this->post['status'])&&$this->post['status']!="" ? intval($this->post['status']):"1 ";
  177. if($send_num==''){
  178. return error_show(1004,"参数 send_num 不能为空或零");
  179. }
  180. if($send_num>$cgdinfo['wsend_num']){
  181. return error_show(1009,"采购单剩余未发货数量不足");
  182. }
  183. // if($cgdinfo['order_type']==1||$cgdinfo['order_type']==2 ){
  184. // $goodinfo = Db::name("good_basic")->where(["spuCode"=>$cgdinfo['spuCode'],"is_del"=>0])->find();
  185. // if($goodinfo==false){
  186. // return error_show(1004,"商品数据未找到");
  187. // }
  188. // if($goodinfo['is_stock']==0){
  189. // $status=4;
  190. // }
  191. // } else {
  192. // $send_way = Db::name("good_zixun")->where(["spuCode" => $cgdinfo['spuCode'], "is_del" => 0])->value('send_way');
  193. // if ($send_way) $status = 4;
  194. // }
  195. if($sendtype==2 || $cgdinfo['order_type']!=1){
  196. $status=4;
  197. }
  198. $orin = [
  199. "wsm_in_code"=>$wsm_in_code,
  200. "cgdNo"=>$cgdNo,
  201. "wsm_code"=>$cgdinfo['wsm_code'],
  202. "wsm_reaper"=>isset($recep)&& $recep['wsm_name']!=''? $recep['wsm_name']:"",
  203. "send_num"=>$send_num,
  204. "post_company"=>$post_company,
  205. "post_code"=>$post_code,
  206. "post_fee"=>$post_fee,
  207. "sendtime"=>$post_time,
  208. "apply_id"=>$userinfo['id'],
  209. "apply_name"=>$userinfo['nickname'],
  210. "wait_num"=>0,
  211. "sendtype"=>$sendtype,
  212. "status"=>$status,
  213. "addtime"=>date("Y-m-d H:i:s"),
  214. "updatetime"=>date("Y-m-d H:i:s")
  215. ];
  216. Db::startTrans();
  217. try{
  218. $win = Db::name("purchease_in")->insert($orin,true);
  219. if($win){
  220. $sto = ["order_code"=>$wsm_in_code,"status"=>$status,"action_remark"=>'',"action_type"=>"edit"];
  221. ActionLog::logAdd($this->post['token'],$sto,"RKD",$status,$this->post);
  222. $process=["order_code"=>$wsm_in_code,"order_id"=>$win,"order_status"=>$status,"order_type"=>'RKD'];
  223. ProcessOrder::AddProcess($this->post['token'],$process);
  224. $order = ["order_code"=>$cgdNo,"status"=>$cgdinfo['status'],"action_remark"=>'',"action_type"=>"edit"];
  225. if($status==1){
  226. $cgdinfo['wsend_num']-=$send_num;
  227. $cgdinfo['send_num']+=$send_num;
  228. $cgdinfo['send_status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  229. $cgdinfo['status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  230. $cgdinfo['updatetime']=date("Y-m-d H:i:s");
  231. $up=Db::name("purchease_order")->save($cgdinfo);
  232. if($up){
  233. if($cgdinfo['order_type']!=1){
  234. $good = Db::name("good_stock")->where(["wsm_code"=>$cgdinfo['wsm_code'],"spuCode"=>$cgdinfo['spuCode'],"is_del"=>0])->find();
  235. if(empty($good)) {
  236. $good=[
  237. "spuCode"=>$cgdinfo['spuCode'],
  238. "wsm_code"=>$cgdinfo['wsm_code'],
  239. "usable_stock"=>0,
  240. "wait_out_stock"=>0,
  241. "wait_in_stock"=>0,
  242. "total_stock"=>0,
  243. "addtime"=>date("Y-m-d H:i:s"),
  244. "updatetime"=>date("Y-m-d H:i:s"),
  245. ];
  246. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'', "action_type"=>"create"];
  247. }else{
  248. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'', "action_type"=>"edit"];
  249. }
  250. $good['wait_in_stock']+=$send_num;
  251. $good['updatetime'] = date("Y-m-d H:i:s");
  252. $upd= Db::name("good_stock")->save($good);
  253. if($upd==false){
  254. Db::rollback();
  255. return error_show(1004,"新建失败");
  256. }
  257. $good_data[]=['good_log_code'=>$wsm_in_code,"stock_id"=>isset($good['id'])? $good['id']:Db::name("good_stock")->getLastInsID(),"type"=>1,'stock'=>$send_num,"stock_name"=>"wait_in_stock"];
  258. GoodLog::LogAdd($this->post['token'],$good_data,'RKD');
  259. }
  260. ActionLog::logAdd($this->post['token'],$order,"CGD", $cgdinfo['status'],$cgdinfo);
  261. $process=["order_code"=>$cgdNo,"order_id"=>$cgdinfo['id'],"order_status"=>$cgdinfo['status'],"order_type"=>'CGD'];
  262. ProcessOrder::AddProcess($this->post['token'],$process);
  263. Db::commit();
  264. return app_show(0,'新建成功',["wsm_in_code"=>$wsm_in_code]);
  265. }else{
  266. Db::rollback();
  267. return error_show(1004,"新建失败");
  268. }
  269. }
  270. if($status==4){
  271. $cgdinfo['wsend_num']-=$send_num;
  272. $cgdinfo['send_num']+=$send_num;
  273. $cgdinfo['send_status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  274. $cgdinfo['status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  275. $cgdinfo['updatetime']=date("Y-m-d H:i:s");
  276. $up=Db::name("purchease_order")->save($cgdinfo);
  277. if($up==false){
  278. Db::rollback();
  279. return error_show(1004,"新建失败");
  280. }
  281. $good = Db::name("good_stock")->where(["wsm_code"=>$cgdinfo['wsm_code'],"spuCode"=>$cgdinfo['spuCode'],"is_del"=>0])->find();
  282. if(empty($good)) {
  283. $good=[
  284. "spuCode"=>$cgdinfo['spuCode'],
  285. "wsm_code"=>$cgdinfo['wsm_code'],
  286. "usable_stock"=>0,
  287. "wait_out_stock"=>0,
  288. "wait_in_stock"=>$send_num,
  289. "total_stock"=>0,
  290. "addtime"=>date("Y-m-d H:i:s"),
  291. "updatetime"=>date("Y-m-d H:i:s"),
  292. ];
  293. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'', "action_type"=>"create"];
  294. }else{
  295. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'', "action_type"=>"edit"];
  296. }
  297. $good['wait_in_stock']-=$send_num;
  298. $good['usable_stock']+=$send_num;
  299. $good['total_stock']=$good['usable_stock']+$good['wait_out_stock'];
  300. $good['updatetime'] = date("Y-m-d H:i:s");
  301. $upd= Db::name("good_stock")->save($good);
  302. //商品变动日志表,good_log_code字段存储采购单单号
  303. $good_data[]=['good_log_code'=>$wsm_in_code,"stock_id"=>isset($good['id'])? $good['id']:Db::name("good_stock")->getLastInsID(),"type"=>1,'stock'=>$send_num,"stock_name"=>"usable_stock"];
  304. $good_data[]=['good_log_code'=>$wsm_in_code,"stock_id"=>isset($good['id'])? $good['id']:Db::name("good_stock")->getLastInsID(),"type"=>2,'stock'=>$send_num,"stock_name"=>"wait_in_stock"];
  305. if($upd){
  306. GoodLog::LogAdd($this->post['token'],$good_data,'RKD');
  307. if($cgdinfo['order_type']==1){
  308. $bk =Db::name("order_bk")->where(['cgdNo'=>$cgdinfo['cgdNo']])->lock(true)->find();
  309. if($bk==false){
  310. $bk=[
  311. "cgdNo"=>$cgdinfo['cgdNo'],
  312. "spuCode"=>$cgdinfo['spuCode'],
  313. "companyNo"=>$cgdinfo['companyNo'],
  314. "total_num"=>0,
  315. "merge_num"=>0,
  316. "balance_num"=>0,
  317. "status"=>1,
  318. "is_del"=>0,
  319. 'addtime'=>date("Y-m-d H:i:s"),
  320. "updatetime"=>date("Y-m-d H:i:s")
  321. ];
  322. }
  323. $bk['balance_num']+=$send_num;
  324. $bk['total_num']+=$send_num;
  325. $bk['updatetime']=date("Y-m-d H:i:s");
  326. $upcgd =Db::name("order_bk")->save($bk);
  327. if($upcgd==false){
  328. Db::rollback();
  329. return error_show(1004,"采购单数量更新失败");
  330. }
  331. }
  332. if($cgdinfo['send_status']==3 && $cgdinfo['order_type']!=1){
  333. $send=Db::name("order_send")->where(["cgdNo"=>$cgdNo,"status"=>1])->column("outCode");
  334. if(!empty($send)){
  335. $out =Db::name("order_out")->where(["outCode"=>$send,"status"=>0])->select()
  336. ->toArray();
  337. if(!empty($out)){
  338. $up =Db::name("order_out")->where(["outCode"=>$send,"status"=>0])->update
  339. (["status"=>1,'wsm_code'=>$cgdinfo['wsm_code'],"updatetime"=>date('Y-m-d H:i:s')]);
  340. if($up==false){
  341. Db::rollback();
  342. return error_show(1004,"出库单出库失败");
  343. }else{
  344. foreach ($out as $k => $v_outCode) {
  345. //修改状态,添加待办
  346. ActionLog::logAdd($this->post['token'], [
  347. "order_code" => $v_outCode['outCode'],//出库单号
  348. "status" => 0,//这里的status是之前的值
  349. "action_remark" => '',//备注
  350. "action_type" => "status"//新建create,编辑edit,更改状态status
  351. ], "CKD", 1, $this->post);
  352. ProcessOrder::AddProcess($this->post['token'], [
  353. "order_type" => 'CKD',
  354. "order_code" => $v_outCode['outCode'],//出库单号
  355. "order_id" => $v_outCode['id'],
  356. "order_status" => 1
  357. ]);
  358. }
  359. }
  360. $good1 = Db::name("good_stock")->where(["wsm_code"=>$cgdinfo['wsm_code'], "spuCode"=>$cgdinfo['spuCode'],"is_del"=>0])->find();
  361. if($good1==false){
  362. Db::rollback();
  363. return error_show(1004,"未找到对应商品库存");
  364. }
  365. $out_num = intval(array_sum(array_column($out,"send_num")));
  366. if($out_num>$good1['usable_stock']){
  367. Db::rollback();
  368. return error_show(1004,"库存数量不足发货");
  369. }
  370. $good1['usable_stock']-=$out_num;
  371. $good1['wait_out_stock']+=$out_num;
  372. $good1['total_stock']=$good1['usable_stock']+$good1['wait_out_stock'];
  373. $good1['updatetime'] = date("Y-m-d H:i:s");
  374. $upd= Db::name("good_stock")->save($good1);
  375. if($upd==false){
  376. Db::rollback();
  377. return error_show(1004,"库存数量更新失败");
  378. }
  379. $good_data[]=['good_log_code'=>$wsm_in_code,"stock_id"=>isset($good['id'])?$good['id']:Db::name("good_stock")->getLastInsID(),"type"=>1,'stock'=>$send_num,"stock_name"=>"wait_out_stock"];
  380. $good_data[]=['good_log_code'=>$wsm_in_code,"stock_id"=>isset($good['id'])?$good['id']:Db::name("good_stock")->getLastInsID(),"type"=>1,'stock'=>$send_num,"stock_name"=>"usable_stock"];
  381. GoodLog::LogAdd($this->post['token'],$good_data,'RKD');
  382. $sendp=Db::name("order_send")->where(["cgdNo"=>$cgdNo,"outCode"=>$send,"status"=>1])->save (["status"=>2]);
  383. if($sendp==false){
  384. Db::rollback();
  385. return error_show(1004,"库存发货失败");
  386. }
  387. }
  388. }
  389. }
  390. ActionLog::logAdd($this->post['token'],$order,"CGD", $cgdinfo['status'],$cgdinfo);
  391. $process=["order_code"=>$cgdNo,"order_id"=>$cgdinfo['id'],"order_status"=>$cgdinfo['status'],"order_type"=>'CGD'];
  392. ProcessOrder::AddProcess($this->post['token'],$process);
  393. Db::commit();
  394. return app_show(0,'商品入库成功',["wsm_in_code"=>$wsm_in_code]);
  395. }else{
  396. Db::rollback();
  397. return error_show(1002,"商品入库失败");
  398. }
  399. }
  400. Db::commit();
  401. return app_show(0,'新建成功',["wsm_in_code"=>$wsm_in_code]);
  402. }
  403. Db::rollback();
  404. return error_show(1004,"新建失败");
  405. }catch (\Exception $e){
  406. Db::rollback();
  407. return error_show(1004, $e->getMessage() . '|' . $e->getFile() . '|' . $e->getLine());
  408. }
  409. }
  410. public function info(){
  411. $incode = isset($this->post['wsm_in_code'])&&$this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']) :"";
  412. if($incode==""){
  413. return error_show(1004,"参数wsm_in_code 不为空");
  414. }
  415. $info = Db::name("purchease_in")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  416. if(empty($info)){
  417. return error_show(1004,"未找到数据");
  418. }
  419. $dom = Db::name("purchease_order")->where(['cgdNo'=>$info['cgdNo'],'is_del'=>0])->find();
  420. if($dom['order_type']==3|| $dom['order_type']==4){
  421. $goon = Db::name("good_zixun")->where(["spuCode"=>$dom['spuCode'],"is_del"=>0])->find();
  422. }else {
  423. $goon =Db::name('good_basic')->where(['spuCode'=>$dom['spuCode']])->find();
  424. }
  425. if(empty($goon)){
  426. return error_show(1002,"未找到商品数据");
  427. }
  428. $cat= isset($goon['cat_id']) && $goon['cat_id'] !=0 ? made($goon['cat_id']):[];
  429. $info['cgder']=$dom['cgder'];
  430. $info['spuCode']=$dom['spuCode'];
  431. $info['good_name']=$dom['good_name'];
  432. $info['skuCode']=$dom['skuCode'];
  433. $info['good_num']=$dom['good_num'];
  434. $info['good_price']=$dom['good_price'];
  435. $info['total_fee']=$dom['total_fee'];
  436. $info['diff_fee']=$dom['diff_fee'];
  437. $info['diff_weight']=$dom['diff_weight'];
  438. $info['gold_price']=$dom['gold_price'];
  439. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  440. ->leftJoin("warehouse_addr c","a.wsm_code=c.wsm_code and c.is_del=0")
  441. ->where(["a.wsm_code"=>$info['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();
  442. $info['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  443. $info['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  444. $info['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  445. $info['wsm_contactor'] =isset($wsmcode['wsm_contactor']) ? $wsmcode['wsm_contactor']:"";
  446. $info['wsm_mobile'] =isset($wsmcode['wsm_mobile']) ? $wsmcode['wsm_mobile']:"";
  447. $info['addr_code'] =isset($wsmcode['addr_code']) ? $wsmcode['addr_code']:"";
  448. $info['wsm_addr'] =isset($wsmcode['addr_code']) ? GetAddr($wsmcode['addr_code']):"";
  449. $info['wsm_addr'].=isset($wsmcode['wsm_addr']) ? $wsmcode['wsm_addr']:"";
  450. $check = Db::name("purchease_info")->alias("a")->leftJoin("result_info b","a.error_code=b.result_code")->where
  451. (['wsm_in_code'=>$incode,"a.is_del"=>0])->field("a.id,a.wsm_in_code,a.num,a.error_code,b.result as error_msg,a.error_img,remark,a.is_del")->select();
  452. $info['checkinfo']= $check;
  453. $return = Db::name("purchease_return")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  454. $return['return_contactor']=isset($return['return_contactor'])&&$return['return_contactor']!="" ?$return['return_contactor']:'';
  455. $return['return_addr']=isset($return['return_addr'])&&$return['return_addr']!="" ?$return['return_addr']:'';
  456. $return['return_mobile']=isset($return['return_mobile'])&&$return['return_mobile']!="" ?$return['return_mobile']:'';
  457. //以下字段临时补充到return中
  458. $return['wsm_in_code'] = $incode;
  459. $return['wsm_num'] = isset($return['wsm_num']) ? $return['wsm_num'] : 0;
  460. $return['reissue_num'] = isset($return['reissue_num']) ? $return['reissue_num'] : 0;
  461. $return['return_num'] = isset($return['return_num']) ? $return['return_num'] : 0;
  462. $return['contactor'] = $return['return_contactor'];
  463. $return['addr'] = $return['return_addr'];
  464. $return['mobile'] = $return['return_mobile'];
  465. $return['error_remark'] = isset($return['error_remark']) ? $return['error_remark'] : '';
  466. $return['remark'] = isset($return['remark']) ? $return['remark'] : '';
  467. $info['return']= $return;
  468. $info['can']=$cat;
  469. if(isset($dom['companyNo'])&&$dom['companyNo']!=""){
  470. $company = Db::name("business")->where(["companyNo"=>$dom['companyNo']])->find();
  471. }
  472. $info['company'] = isset($company['company'])?$company['company']:"";
  473. $info['companyNo'] = isset($dom['companyNo'])?$dom['companyNo']:"";
  474. $info['order_type'] = isset($dom['order_type'])?$dom['order_type']:"";
  475. return app_show(0,'获取成功',$info);
  476. }
  477. public function check(){
  478. $incode = isset($this->post['wsm_in_code'])&&$this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']) :"";
  479. if($incode==""){
  480. return error_show(1004,"参数wsm_in_code 不为空");
  481. }
  482. $info = Db::name("purchease_in")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  483. if(empty($info)){
  484. return error_show(1004,"未找到数据");
  485. }
  486. if($info['status']!=1){
  487. return error_show(1004,"发货单状态有误");
  488. }
  489. $order_num = isset($this->post['order_num']) && $this->post['order_num']!==''?intval($this->post['order_num'])
  490. :"";
  491. if($order_num===""){
  492. return error_show(1004,"参数 order_num 不为空");
  493. }
  494. $error_list = isset($this->post['error_list']) && $this->post['error_list']!==''?$this->post['error_list']:"";
  495. $result = GetUserInfo($this->post['token']);
  496. if((!empty($result) && $result['code']!=0) ||empty($result) ){
  497. return error_show($result['code'],$result['message']);
  498. }
  499. $userinfo = $result['data'];
  500. Db::startTrans();
  501. try{
  502. $order = ["order_code"=>$incode,"status"=>$info['status'],"action_remark"=>'',"action_type"=>"edit"];
  503. $info['wsm_num'] = $order_num;
  504. $info['wait_num'] = $info['send_num'];
  505. $info['checkid'] = $userinfo['id'];
  506. $info['check_name'] = $userinfo['nickname'];
  507. $info['status'] =2;
  508. $info['error_num'] = $info['send_num']-$order_num;
  509. $info['updatetime'] = date("Y-m-d H:i:s");
  510. $up =Db::name("purchease_in")->save($info);
  511. if($up){
  512. ActionLog::logAdd($this->post['token'],$order,"RKD",2,$this->post);
  513. $process=["order_code"=>$info['wsm_in_code'],"order_id"=>$info['id'],"order_status"=>$info['status'],"order_type"=>'RKD'];
  514. ProcessOrder::AddProcess($this->post['token'],$process);
  515. if(!empty($error_list)){
  516. $data=[];
  517. foreach ($error_list as $value ){
  518. $temp=[];
  519. $temp['wsm_in_code']=$info['wsm_in_code'];
  520. $temp['num']=$value['num'];
  521. $temp['error_code']=$value['error_code'];
  522. $temp['error_img']=$value['error_img'];
  523. $temp['remark']=$value['remark'];
  524. $temp['is_del']=0;
  525. $temp['addtime']=date("Y-m-d H:i:s");
  526. $temp['updatetime']=date("Y-m-d H:i:s");
  527. $data[]=$temp;
  528. }
  529. $derr= Db::name("purchease_info")->insertAll($data);
  530. if($derr){
  531. Db::commit();
  532. return app_show(0,"验货完成");
  533. }else{
  534. Db::rollback();
  535. return error_show(1002,"验货数据保存失败");
  536. }
  537. }
  538. Db::commit();
  539. return app_show(0,"验货完成");
  540. }
  541. Db::rollback();
  542. return error_show(1002,"验货数据保存失败");
  543. }catch (\Exception $e){
  544. Db::rollback();
  545. return error_show(1002,$e->getMessage());
  546. }
  547. }
  548. public function status(){
  549. $incode = isset($this->post['wsm_in_code'])&&$this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']) :"";
  550. if($incode==""){
  551. return error_show(1004,"参数wsm_in_code 不为空");
  552. }
  553. $info = Db::name("purchease_in")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  554. if(empty($info)){
  555. return error_show(1004,"未找到数据");
  556. }
  557. $status = isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
  558. if($status===""){
  559. return error_show(1004,"参数status 不为空");
  560. }
  561. if($info['status']==4){
  562. return error_show(1004,"入库单已完成");
  563. }
  564. $remark = isset($this->post['remark'])&&$this->post['remark']!="" ? trim($this->post['remark']) :"";
  565. Db::startTrans();
  566. try{
  567. $order = ["order_code"=>$incode,"status"=>$info['status'],"action_remark"=>'',"action_type"=>"status"];
  568. $info['status'] = $status;
  569. $info['remark'] = $remark;
  570. $info['updatetime'] = date("Y-m-d H:i:s");
  571. $update = Db::name("purchease_in")->save($info);
  572. if($update){
  573. ActionLog::logAdd($this->post['token'],$order,"RKD",$status,$this->post);
  574. $process=["order_code"=>$info['wsm_in_code'],"order_id"=>$info['id'],"order_status"=>$status,"order_type"=>'RKD'];
  575. ProcessOrder::AddProcess($this->post['token'],$process);
  576. if($status==0){
  577. $cgdinfo=Db::name("purchease_order")->where(['cgdNo'=>$info['cgdNo'],"is_del"=>0])->find();
  578. if(empty($cgdinfo)){
  579. Db::rollback();
  580. return error_show(1002,"未找到采购单数据");
  581. }
  582. $order = ["order_code"=>$info['cgdNo'],"status"=>$cgdinfo['status'],"action_remark"=>'',"action_type"=>"edit"];
  583. $cgdinfo['wsend_num']+=$info['send_num'];
  584. $cgdinfo['send_num']-=$info['send_num'];
  585. $cgdinfo['send_status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  586. $cgdinfo['status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  587. $cgdinfo['updatetime']=date("Y-m-d H:i:s");
  588. $up=Db::name("purchease_order")->save($cgdinfo);
  589. if($up){
  590. ActionLog::logAdd($this->post['token'],$order,"CGD", $cgdinfo['status'],$cgdinfo);
  591. $process=["order_code"=>$info['cgdNo'],"order_id"=>$cgdinfo['id'],"order_status"=>$cgdinfo['status'],"order_type"=>'CGD'];
  592. ProcessOrder::AddProcess($this->post['token'],$process);
  593. Db::commit();
  594. return app_show(0,'取消成功');
  595. }else{
  596. Db::rollback();
  597. return error_show(1002,"取消失败");
  598. }
  599. }
  600. if($status==1){
  601. $cgdinfo=Db::name("purchease_order")->where(['cgdNo'=>$info['cgdNo'],"is_del"=>0])->find();
  602. if(empty($cgdinfo)){
  603. Db::rollback();
  604. return error_show(1002,"未找到采购单数据");
  605. }
  606. $order = ["order_code"=>$info['cgdNo'],"status"=>$cgdinfo['status'],"action_remark"=>'',"action_type"=>"edit"];
  607. $cgdinfo['wsend_num']-=$info['send_num'];
  608. $cgdinfo['send_num']+=$info['send_num'];
  609. $cgdinfo['send_status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  610. $cgdinfo['status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  611. $cgdinfo['updatetime']=date("Y-m-d H:i:s");
  612. $up=Db::name("purchease_order")->save($cgdinfo);
  613. if($up){
  614. ActionLog::logAdd($this->post['token'],$order,"CGD", $cgdinfo['status'],$cgdinfo);
  615. $process=["order_code"=>$info['cgdNo'],"order_id"=>$cgdinfo['id'],"order_status"=>$cgdinfo['status'],"order_type"=>'CGD'];
  616. ProcessOrder::AddProcess($this->post['token'],$process);
  617. Db::commit();
  618. return app_show(0,'发货成功');
  619. }else{
  620. Db::rollback();
  621. return error_show(1002,"发货失败");
  622. }
  623. }
  624. if($status==4){
  625. $cgdinfo=Db::name("purchease_order")->where(['cgdNo'=>$info['cgdNo'],"is_del"=>0])->find();
  626. if(empty($cgdinfo)){
  627. Db::rollback();
  628. return error_show(1002,"未找到采购单数据");
  629. }
  630. $good = Db::name("good_stock")->where(["wsm_code"=>$info['wsm_code'], "spuCode"=>$cgdinfo['spuCode'],"is_del"=>0])->find();
  631. if(empty($good)) {
  632. $good=[
  633. "spuCode"=>$cgdinfo['spuCode'],
  634. "wsm_code"=>$info['wsm_code'],
  635. "usable_stock"=>0,
  636. "wait_out_stock"=>0,
  637. "wait_in_stock"=>$info['wsm_num'],
  638. "total_stock"=>0,
  639. "addtime"=>date("Y-m-d H:i:s"),
  640. "updatetime"=>date("Y-m-d H:i:s"),
  641. ];
  642. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'',
  643. "action_type"=>"create"];
  644. }else{
  645. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'', "action_type"=>"edit"];
  646. }
  647. $good['usable_stock']+=$info['wsm_num'];
  648. $good['wait_in_stock']-=$info['wsm_num'];
  649. $good['total_stock']=$good['usable_stock']+$good['wait_out_stock'];
  650. $good['updatetime'] = date("Y-m-d H:i:s");
  651. $upd= Db::name("good_stock")->save($good);
  652. //商品变动日志表,good_log_code字段存储入库单编号
  653. $good_data[] = ['good_log_code' => $incode, "stock_id" => isset($good['id']) ? $good['id'] : Db::name("good_stock")->getLastInsID(), "type" => 1, 'stock' => $info['wsm_num'], "stock_name" => "usable_stock"];
  654. $good_data[] = ['good_log_code' => $incode, "stock_id" => isset($good['id']) ? $good['id'] :
  655. Db::name("good_stock")->getLastInsID(), "type" => 2, 'stock' => $info['wsm_num'], "stock_name" => "wait_in_stock"];
  656. if($upd){
  657. GoodLog::LogAdd($this->post['token'],$good_data,'RKD');
  658. Db::commit();
  659. return app_show(0,'商品入库成功');
  660. }else{
  661. Db::rollback();
  662. return error_show(1002,"商品入库失败");
  663. }
  664. }
  665. Db::commit();
  666. return app_show(0,"状态修改完成");
  667. }
  668. Db::rollback();
  669. return error_show(1002,"状态修改失败");
  670. }catch (\Exception $e){
  671. Db::rollback();
  672. return error_show(1002,$e->getMessage());
  673. }
  674. }
  675. /**
  676. * @return \think\response\Json|void
  677. * @throws \think\db\exception\DataNotFoundException
  678. * @throws \think\db\exception\DbException
  679. * @throws \think\db\exception\ModelNotFoundException
  680. */
  681. public function ReturnAdd(){
  682. $incode = isset($this->post['wsm_in_code'])&&$this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']) :"";
  683. if($incode==""){
  684. return error_show(1004,"参数wsm_in_code 不为空");
  685. }
  686. $info = Db::name("purchease_in")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  687. if(empty($info)){
  688. return error_show(1004,"未找到数据");
  689. }
  690. //正常入库数量
  691. $wsm_num = isset($this->post['wsm_num']) &&$this->post['wsm_num']!=="" ? intval($this->post['wsm_num']):"" ;
  692. if($wsm_num===""){
  693. return error_show(1004,"参数wsm_num 不为空");
  694. }
  695. //补货数量
  696. $reissue_num = isset($this->post['reissue_num']) &&$this->post['reissue_num']!=="" ? intval($this->post['reissue_num']):"0" ;
  697. //退货数量
  698. $return_num = isset($this->post['return_num']) &&$this->post['return_num']!=="" ? intval($this->post['return_num']):"0" ;
  699. $contactor = isset($this->post['contactor']) &&$this->post['contactor']!=="" ? trim($this->post['contactor']):"" ;
  700. if($contactor==""){
  701. return error_show(1004,"参数contactor 不为空");
  702. }
  703. $addr = isset($this->post['addr']) &&$this->post['addr']!=="" ? trim($this->post['addr']):"" ;
  704. if($addr==""){
  705. return error_show(1004,"参数addr 不为空");
  706. }
  707. $mobile = isset($this->post['mobile']) &&$this->post['mobile']!=="" ? trim($this->post['mobile']):"" ;
  708. if($mobile==""){
  709. return error_show(1004,"参数mobile 不为空");
  710. }
  711. $error_remark = isset($this->post['error_remark']) &&$this->post['error_remark']!=="" ? trim($this->post['error_remark']):"" ;
  712. $remark = isset($this->post['remark']) &&$this->post['remark']!=="" ? trim($this->post['remark']):"" ;
  713. $result = GetUserInfo($this->post['token']);
  714. if((!empty($result) && $result['code']!=0) ||empty($result) ){
  715. return error_show($result['code'],$result['message']);
  716. }
  717. $userinfo = $result['data'];
  718. Db::startTrans();
  719. try{
  720. $sto = ["order_code"=>$incode,"status"=>$info['status'],"action_remark"=>'',"action_type"=>"edit"];
  721. // $info['status'] =$info['wsm_num']==$wsm_num ? 4 :5;
  722. $info['status'] = $info['send_num'] == $wsm_num ? 4 : 5;//艳蓉说,这里不能用入库数量比较,应该是用入库数量,即总数来比较
  723. $info['is_th'] =$return_num>0 ?1:0;
  724. $info['updatetime'] = date("Y-m-d H:i:s");
  725. $up= Db::name("purchease_in")->save($info);
  726. if($up){
  727. $cgdinfo=Db::name("purchease_order")->where(['cgdNo'=>$info['cgdNo'],"is_del"=>0])->find();
  728. if(empty($cgdinfo)){
  729. Db::rollback();
  730. return error_show(1002,"未找到采购单数据");
  731. }
  732. if($info['status']==4){
  733. $good = Db::name("good_stock")->where(["wsm_code"=>$info['wsm_code'], "spuCode"=>$cgdinfo['spuCode'],"is_del"=>0])->find();
  734. if(empty($good)) {
  735. $good=[
  736. "spuCode"=>$cgdinfo['spuCode'],
  737. "wsm_code"=>$info['wsm_code'],
  738. "usable_stock"=>0,
  739. "wait_out_stock"=>0,
  740. "wait_in_stock"=>$wsm_num,
  741. "total_stock"=>0,
  742. "addtime"=>date("Y-m-d H:i:s"),
  743. "updatetime"=>date("Y-m-d H:i:s"),
  744. ];
  745. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'',
  746. "action_type"=>"create"];
  747. }else{
  748. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'', "action_type"=>"edit"];
  749. }
  750. $good['usable_stock']+=$wsm_num;
  751. $good['wait_in_stock']-=$wsm_num;
  752. $good['total_stock']=$good['usable_stock']+$good['wait_out_stock'];
  753. $good['updatetime'] = date("Y-m-d H:i:s");
  754. $upd= Db::name("good_stock")->save($good);
  755. if($upd==false){
  756. Db::rollback();
  757. return error_show(1002,"库存更新失败");
  758. }
  759. $good_data[]=['good_log_code' => $incode,"stock_id"=>isset($good['id'])? $good['id']:Db::name("good_stock")->getLastInsID(),"type"=>1, 'stock'=>$info['wsm_num'],"stock_name"=>"usable_stock"];
  760. $good_data[]=['good_log_code' => $incode,"stock_id"=>isset($good['id'])? $good['id']:Db::name("good_stock")->getLastInsID(),"type"=>2, 'stock'=>$info['wsm_num'],"stock_name"=>"wait_in_stock"];
  761. GoodLog::LogAdd($this->post['token'],$good_data,'RKD');
  762. $bk =Db::name("order_bk")->where(['cgdNo'=>$cgdinfo['cgdNo']])->lock(true)->find();
  763. if($bk==false){
  764. $bk=[
  765. "cgdNo"=>$cgdinfo['cgdNo'],
  766. "spuCode"=>$cgdinfo['spuCode'],
  767. "companyNo"=>$cgdinfo['companyNo'],
  768. "total_num"=>0,
  769. "merge_num"=>0,
  770. "balance_num"=>0,
  771. "status"=>1,
  772. "is_del"=>0,
  773. 'addtime'=>date("Y-m-d H:i:s"),
  774. "updatetime"=>date("Y-m-d H:i:s")
  775. ];
  776. }
  777. $bk['balance_num']+=$wsm_num;
  778. $bk['total_num']+=$wsm_num;
  779. $bk['updatetime']=date("Y-m-d H:i:s");
  780. $upcgd =Db::name("order_bk")->save($bk);
  781. if($upcgd==false){
  782. Db::rollback();
  783. return error_show(1004,"采购单数量更新失败");
  784. }
  785. }
  786. ActionLog::logAdd($this->post['token'],$sto,"RKD", $info['status'],$this->post);
  787. $process=["order_code"=>$info['wsm_in_code'],"order_id"=>$info['id'],"order_status"=>$info['status'],"order_type"=>'RKD'];
  788. ProcessOrder::AddProcess($this->post['token'],$process);
  789. //需要在详情页把相关退货记录原样取出来,所以这里把if去掉,所有记录都入purchease_return表
  790. // if($info['status']==5){
  791. $data=[
  792. "wsm_in_code"=>$incode,
  793. "wsm_num"=>$wsm_num,
  794. "reissue_num"=>$reissue_num,
  795. "return_num"=>$return_num,
  796. "return_contactor"=>$contactor,
  797. "return_addr"=>$addr,
  798. "return_mobile"=>$mobile,
  799. "error_remark"=>$error_remark,
  800. "post_code"=>"",
  801. "post_company"=>"",
  802. "remark"=>$remark ,
  803. "apply_id"=>$userinfo['id'],
  804. "apply_name"=>$userinfo['nickname'],
  805. "status"=>0,
  806. "addtime"=>date("Y-m-d H:i:s"),
  807. "updatetime"=>date("Y-m-d H:i:s")
  808. ];
  809. $res = Db::name("purchease_return")->insert($data,true);
  810. if($res==false){
  811. Db::rollback();
  812. return error_show(1002,"验货审核失败");
  813. }
  814. $sto = ["order_code"=>$incode,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  815. ActionLog::logAdd($this->post['token'],$sto,"RKTHD",0,$data);
  816. // }
  817. Db::commit();
  818. return app_show(0,"验货审核完成");
  819. }
  820. }catch (\Exception $e){
  821. Db::rollback();
  822. return error_show(1002,$e->getMessage());
  823. }
  824. }
  825. public function ReturnSend(){
  826. $incode = isset($this->post['wsm_in_code'])&&$this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']) :"";
  827. if($incode==""){
  828. return error_show(1004,"参数wsm_in_code 不为空");
  829. }
  830. $info = Db::name("purchease_in")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  831. if(empty($info)){
  832. return error_show(1004,"未找到发货单数据");
  833. }
  834. $return = Db::name("purchease_return")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  835. if(empty($return)){
  836. return error_show(1004,"未找到退货单数据");
  837. }
  838. $cgdinfo=Db::name("purchease_order")->where(['cgdNo'=>$info['cgdNo'],"is_del"=>0])->find();
  839. if(empty($cgdinfo)){
  840. Db::rollback();
  841. return error_show(1002,"未找到采购单数据");
  842. }
  843. $post_code = isset($this->post['post_code']) &&$this->post['post_code']!=="" ? trim($this->post['post_code']):"" ;
  844. if($post_code==""){
  845. return error_show(1004,"参数 post_code 不能为空");
  846. }
  847. $post_company = isset($this->post['post_company']) &&$this->post['post_company']!=="" ? trim($this->post['post_company']):"" ;
  848. if($post_company==""){
  849. return error_show(1004,"参数 post_company 不能为空");
  850. }
  851. $remark = isset($this->post['remark']) &&$this->post['remark']!=="" ? trim($this->post['remark']):"" ;
  852. $data=[
  853. "post_code"=>$post_code,
  854. "post_company"=>$post_company,
  855. "remark"=>$remark,
  856. "status"=>1,
  857. "updatetime"=>date("Y-m-d H:i:s")
  858. ];
  859. Db::startTrans();
  860. try{
  861. $up =Db::name("purchease_return")->where($return)->save($data);
  862. if($up){
  863. $sto = ["order_code"=>$info['wsm_in_code'],"status"=>$return['status'],"action_remark"=>'', "action_type"=>"edit"];
  864. ActionLog::logAdd($this->post['token'],$sto,"RKTHD",1,$this->post);
  865. $ark=$info['status'];
  866. $info['status']=6;
  867. $info['updatetime']=date("Y-m-d H:i:s");
  868. $sa=Db::name("purchease_in")->save($info);
  869. if($sa){
  870. $stn = ["order_code"=>$info['wsm_in_code'],"status"=>$ark,"action_remark"=>'',"action_type"=>"edit"];
  871. ActionLog::logAdd($this->post['token'],$stn,"RKD",6,$info);
  872. $process=["order_code"=>$info['wsm_in_code'],"order_id"=>$info['id'],"order_status"=>6,"order_type"=>'RKD'];
  873. ProcessOrder::AddProcess($this->post['token'],$process);
  874. if($info['status']==6){
  875. $good = Db::name("good_stock")->where(["wsm_code"=>$info['wsm_code'], "spuCode"=>$cgdinfo['spuCode'],"is_del"=>0])->find();
  876. if(empty($good)) {
  877. $good=[
  878. "spuCode"=>$cgdinfo['spuCode'],
  879. "wsm_code"=>$info['wsm_code'],
  880. "usable_stock"=>0,
  881. "wait_out_stock"=>0,
  882. "wait_in_stock"=>$info['wsm_num'],
  883. "total_stock"=>0,
  884. "addtime"=>date("Y-m-d H:i:s"),
  885. "updatetime"=>date("Y-m-d H:i:s"),
  886. ];
  887. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'',
  888. "action_type"=>"create"];
  889. }else{
  890. $order = ["order_code"=>$good['spuCode'],"status"=>1,"action_remark"=>'', "action_type"=>"edit"];
  891. }
  892. $good['usable_stock']+=$info['wsm_num'];
  893. $good['wait_in_stock']-=$info['wsm_num']+$return['return_num']-$return['reissue_num'];
  894. $good['total_stock']=$good['usable_stock']+$good['wait_out_stock'];
  895. $good['updatetime'] = date("Y-m-d H:i:s");
  896. $upd= Db::name("good_stock")->save($good);
  897. if($upd==false){
  898. Db::rollback();
  899. return error_show(1002,"库存更新失败");
  900. }
  901. $good_data[]=['good_log_code' => $incode,"stock_id"=>isset($good['id'])? $good['id']:Db::name("good_stock")->getLastInsID(),"type"=>1, 'stock'=>$info['wsm_num'],"stock_name"=>"usable_stock"];
  902. $good_data[]=['good_log_code' => $incode,"stock_id"=>isset($good['id'])? $good['id']:Db::name("good_stock")->getLastInsID(),"type"=>2, 'stock'=>$good['wait_in_stock'],"stock_name"=>"wait_in_stock"];
  903. GoodLog::LogAdd($this->post['token'],$good_data,'RKD');
  904. }
  905. $order = ["order_code"=>$cgdinfo['cgdNo'],"status"=>$cgdinfo['status'],"action_remark"=>'',"action_type"=>"edit"];
  906. $cgdinfo['wsend_num']+=$return['reissue_num'];
  907. $cgdinfo['send_num']-=$return['return_num'];
  908. $cgdinfo['good_num']-=$return['return_num']-$return['reissue_num'];
  909. $cgdinfo['total_fee']=round($cgdinfo['good_num']*$cgdinfo['good_price'],2);
  910. $cgdinfo['send_status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  911. $cgdinfo['status']=$cgdinfo['wsend_num']==0 ? 3:($cgdinfo['send_num']==0 ?1:2);
  912. $cgdinfo['updatetime']=date("Y-m-d H:i:s");
  913. $up=Db::name("purchease_order")->save($cgdinfo);
  914. if($up==false){
  915. Db::rollback();
  916. return error_show(1004,"采购单数量更新失败");
  917. }
  918. $bk =Db::name("order_bk")->where(['cgdNo'=>$cgdinfo['cgdNo']])->lock(true)->find();
  919. if($bk==false){
  920. $bk=[
  921. "cgdNo"=>$cgdinfo['cgdNo'],
  922. "spuCode"=>$cgdinfo['spuCode'],
  923. "companyNo"=>$cgdinfo['companyNo'],
  924. "total_num"=>0,
  925. "merge_num"=>0,
  926. "balance_num"=>0,
  927. "status"=>1,
  928. "is_del"=>0,
  929. 'addtime'=>date("Y-m-d H:i:s"),
  930. "updatetime"=>date("Y-m-d H:i:s")
  931. ];
  932. }
  933. $bk['balance_num']+=$return['wsm_num'];
  934. $bk['total_num']+=$return['wsm_num'];
  935. $bk['updatetime']=date("Y-m-d H:i:s");
  936. $upcgd =Db::name("order_bk")->save($bk);
  937. if($upcgd==false){
  938. Db::rollback();
  939. return error_show(1004,"采购单数量更新失败");
  940. }
  941. ActionLog::logAdd($this->post['token'],$order,"CGD", $cgdinfo['status'],$cgdinfo);
  942. $process=["order_code"=>$cgdinfo['cgdNo'],"order_id"=>$cgdinfo['id'],"order_status"=>$cgdinfo['status'],"order_type"=>'CGD'];
  943. ProcessOrder::AddProcess($this->post['token'],$process);
  944. Db::commit();
  945. return app_show(0,"退货发货成功");
  946. }else{
  947. Db::rollback();
  948. return error_show(1004,"退货发货失败");
  949. }
  950. }else{
  951. return error_show(1004,"退货发货失败");
  952. }
  953. }catch (\Exception $e){
  954. Db::rollback();
  955. return error_show(1004,$e->getMessage());
  956. }
  957. }
  958. // public function ReturnStatus(){
  959. // $incode = isset($this->post['wsm_in_code'])&&$this->post['wsm_in_code']!="" ? trim($this->post['wsm_in_code']) :"";
  960. // if($incode==""){
  961. // return error_show(1004,"参数wsm_in_code 不为空");
  962. // }
  963. // $info = Db::name("purchease_in")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  964. // if(empty($info)){
  965. // return error_show(1004,"未找到发货单数据");
  966. // }
  967. // $return = Db::name("purchease_return")->where(['wsm_in_code'=>$incode,"is_del"=>0])->find();
  968. // if(empty($return)){
  969. // return error_show(1004,"未找到数据");
  970. // }
  971. // if($info['status']<4){
  972. // return error_show(1004,"入库单未完成");
  973. // }
  974. // $status = isset($this->post['status'])&&$this->post['status']!="" ?$this->post['status']:"";
  975. // if($status==""){
  976. // return error_show(1004,"参数status 不为空");
  977. // }
  978. // Db::startTrans();
  979. // try{
  980. // $data=[
  981. // "status"=>$status,
  982. // "updatetime"=>date("Y-m-d H:i:s")
  983. // ];
  984. // $up =Db::name("purchease_return")->where($return)->save($data);
  985. // if($up){
  986. // $info['status']=$status==1?5:6;
  987. // $info['updatetime']=date("Y-m-d H:i:s");
  988. // $sa=Db::name("purchease_in")->save($info);
  989. // if($sa){
  990. // Db::commit();
  991. // return app_show(0,"更新成功");
  992. // }else{
  993. // Db::rollback();
  994. // return error_show(1004,"更新失败");
  995. // }
  996. // }else{
  997. // Db::rollback();
  998. // return error_show(1004,"更新失败");
  999. // }
  1000. // }catch (\Exception $e){
  1001. // Db::rollback();
  1002. // return error_show(1004,$e->getMessage());
  1003. // }
  1004. //
  1005. // }
  1006. }