Reorder.php 84 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\DataGroup as DataGroupModel;
  4. use app\admin\model\GoodLog;
  5. use app\admin\model\GoodStockInfo;use app\admin\model\ProcessOrder;
  6. use think\Exception;
  7. use think\facade\Db;
  8. use think\App;
  9. use app\admin\model\ActionLog;
  10. //销售单退货
  11. class Reorder extends Base
  12. {
  13. public function __construct(App $app)
  14. {
  15. parent::__construct($app);
  16. }
  17. public function create(){
  18. $ordeCode = isset($this->post['orderCode']) &&$this->post['orderCode']!=''?trim($this->post['orderCode']) :"";
  19. if($ordeCode==''){
  20. return error_show(1004,"参数orderCode 不能为空");
  21. }
  22. $order= Db::name("sale")->where(["orderCode"=>$ordeCode,"is_del"=>0])->find();
  23. if(empty($order)){
  24. return error_show(1005,"未找到订单数据");
  25. }
  26. $retrun =Db::name("sale_return")->where([["orderCode","=",$ordeCode],["is_del","=",0],["status","<",4]])
  27. ->count();
  28. if($retrun>0){
  29. return error_show(1005,"存在未完成退货订单数据");
  30. }
  31. if($order['order_type']==3){
  32. $goon = Db::name("good_zixun")->where(["spuCode"=>$order['good_code'],"is_del"=>0])->find();
  33. }else {
  34. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  35. ->where(['a.skuCode' => $order['skuCode']])->field("b.creater,b.createrid,b.supplierNo")->find();
  36. }
  37. if($goon==false){
  38. return error_show(1005,"未找到商品数据");
  39. }
  40. $supplier =Db::name("supplier")->where(["code"=>$goon['supplierNo']])->find();
  41. if($supplier==false){
  42. return error_show(1005,"未找到商品供应商数据");
  43. }
  44. $errorCode = isset($this->post['errorCode']) &&$this->post['errorCode']!=''?trim($this->post['errorCode']) :"";
  45. if($errorCode==''){
  46. return error_show(1004,"参数errorCode 不能为空");
  47. }
  48. $error =Db::name('result_info')->where(["result_code"=>$errorCode,"is_del"=>0])->find();
  49. if(empty($error)){
  50. return error_show(1005,"未找到退货原因数据");
  51. }
  52. $remark =isset($this->post['remark']) &&$this->post['remark']!=''?trim($this->post['remark']) :"";
  53. $thnum =isset($this->post['thnum']) &&$this->post['thnum']!=''?intval($this->post['thnum']) :"";
  54. $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):"";
  55. if($token==''){
  56. return error_show(105,"参数token不能为空");
  57. }
  58. $user =GetUserInfo($token);
  59. if(empty($user)||$user['code']!=0){
  60. return error_show(1002,"申请人数据不存在");
  61. }
  62. $is_addr=0;
  63. $rm= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  64. $ri= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  65. $returnadr =isset($this->post['returnAddr'])&& !empty($this->post['returnAddr']) ? $this->post['returnAddr']:"";
  66. if($returnadr!=''){
  67. $thnum=array_sum(array_column($returnadr,"return_num"));
  68. $is_addr=1;
  69. }
  70. $returnCode=makeNo("RN");
  71. Db::startTrans();
  72. try{
  73. $in = [
  74. "returnCode"=>$returnCode,
  75. "orderCode"=>$ordeCode,
  76. "good_code"=>$order['good_code'],
  77. "good_name"=>$order['good_name'],
  78. "apply_id"=>$rm,
  79. "apply_name"=>$ri,
  80. "cgderid"=>$goon['createrid'],
  81. "cgder"=>$goon['creater'],
  82. "person"=>$supplier['person']??'',
  83. "person_id"=>$supplier['personid']??0,
  84. "error_code"=>$errorCode,
  85. "num"=>$thnum,
  86. "total_fee"=>round($order['sale_price']*$thnum,2),
  87. "good_price"=>$order['sale_price'],
  88. "platform_id"=>$order['platform_id'],
  89. "remark"=>$remark,
  90. "order_type"=>$order['order_type'],
  91. "is_addr"=>$is_addr,
  92. "status"=>$order['is_stock']==1?4:1,
  93. "is_del"=>0,
  94. "addtime"=>date("Y-m-d H:i:s"),
  95. "updatetime"=>date("Y-m-d H:i:s")
  96. ];
  97. $create = Db::name("sale_return")->insert($in,true);
  98. if($create>0){
  99. $stn = ["order_code"=>$returnCode,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  100. ActionLog::logAdd($this->post['token'],$stn,"XSTHD",$in['status'],$in);
  101. $process=["order_code"=>$returnCode,"order_id"=>$create,"order_status"=>$in['status'],"order_type"=>'XSTHD',"before_status"=>0,'holder_id'=>$in['apply_id']];
  102. ProcessOrder::AddProcess($this->post['token'],$process);
  103. //维护台账信息
  104. Db::execute("UPDATE `wsm_standing_book` SET `returnGoodCode`=CONCAT(IFNULL(`returnGoodCode`,''),',{$returnCode}'),`updatetime`='" . date('Y-m-d H:i:s') . "' WHERE `orderCode`='{$ordeCode}'");
  105. if($returnadr!=""){
  106. $inf=[];
  107. foreach ($returnadr as $val){
  108. if ($val['return_num'] == 0) continue;//当退货数量为0时,跳过
  109. $temp=[];
  110. $addrinfo =Db::name("order_addr")->where(['id'=>$val['id'],"orderCode"=>$ordeCode])->find();
  111. if($addrinfo==false){
  112. Db::rollback();
  113. return error_show(1005,"地址信息未找到");
  114. }
  115. $send =Db::name('order_out')->where([["addrid","=",$val['id']]])->find();
  116. if($send['status']>=2){
  117. Db::rollback();
  118. return error_show(1005,"地址已发货");
  119. }
  120. if($order['is_stock']==1){
  121. if ($addrinfo['receipt_quantity'] < $val['return_num']) {
  122. Db::rollback();
  123. return error_show(1004, "地址发货数量不足");
  124. }
  125. $addrinfo['receipt_quantity'] -= $val['return_num'];
  126. $addrinfo['is_del'] = $addrinfo['receipt_quantity'] <= 0 ? 1 : 0;
  127. $addrinfo['updatetime'] = date("Y-m-d H:i:s");
  128. $addrup = Db::name("order_addr")->save($addrinfo);
  129. if ($addrup == false) {
  130. Db::rollback();
  131. return error_show(1004, "地址发货数量更新失败");
  132. }
  133. $out = Db::name("order_out")->where(["addrid"=>$val['id']])->find();
  134. if ($out == false) {
  135. Db::rollback();
  136. return error_show(1004, "地址发货单数据未找到");
  137. }
  138. // if ($send!=false) {
  139. if ($out['status'] >= 2) {
  140. Db::rollback();
  141. return error_show(1004, "地址发货单已发货");
  142. }
  143. if ($out['send_num'] < $val['return_num']) {
  144. Db::rollback();
  145. return error_show(1004, "地址发货单发货数量不足");
  146. }
  147. $out['send_num'] -= $val['return_num'];
  148. $out['is_del'] = $out['send_num']==0?1:0;
  149. $out['updatetime'] = date("Y-m-d H:i:s");
  150. $outup = Db::name("order_out")->save($out);
  151. if ($outup == false) {
  152. Db::rollback();
  153. return error_show(1004, "地址发货单更新失败");
  154. }
  155. // $ordersend = Db::name("order_send")->where(["outCode" => $out['outCode']])->find();
  156. // if ($ordersend['send_num'] < $val['return_num']) {
  157. // Db::rollback();
  158. // return error_show(1004, "发货单发货数量不足");
  159. // }
  160. // $ordersend['send_num'] -= $val['return_num'];
  161. // $ordersend['status'] = $ordersend['send_num'] <= 0 ? 0 : 1;
  162. // $ordersend['updatetime'] = date("Y-m-d H:i:s");
  163. // $sendip = Db::name("order_send")->save($ordersend);
  164. // if ($sendip == false) {
  165. // Db::rollback();
  166. // return error_show(1004, "发货单更新失败");
  167. // }
  168. // }
  169. }
  170. $temp['returnCode']=$returnCode;
  171. $temp['orderCode']=$ordeCode;
  172. $temp['outCode']=isset($send['outCode'])?$send['outCode']:"";
  173. $temp['addrid']=$val['id'];
  174. $temp['send_num']=$addrinfo['receipt_quantity'];
  175. $temp['return_num']=$val['return_num'];
  176. $temp['is_del']=0;
  177. $temp['addtime']=date("Y-m-d H:i:s");
  178. $temp['updatetime']=date("Y-m-d H:i:s");
  179. $inf[]=$temp;
  180. }
  181. $inadd=Db::name("sale_returnaddr")->insertAll($inf);
  182. if($inadd==0){
  183. Db::rollback();
  184. return error_show(1005,"退货单新建失败");
  185. }
  186. }
  187. if($order['is_stock']==1){
  188. if ($order['wsend_num'] < $thnum) {
  189. Db::rollback();
  190. return error_show(1004, "销售单未发货数量不足退货");
  191. }
  192. $lor=$order['status'] ;
  193. $order['wsend_num'] -= $thnum;
  194. $order['send_num'] += $thnum;
  195. $order['status'] = $order['wsend_num']==0?2:($order['send_num']==0?0:1);
  196. $order['send_status'] =$order['wsend_num']==0?3:($order['send_num']==0?1:2);
  197. $order['th_num'] += $thnum;
  198. if($order['th_num']==$order['send_num']&& $order['wsend_num']==0){
  199. $order['status']=3;
  200. }
  201. $order['th_fee'] += round($thnum * $order['sale_price'], 2);
  202. $order['updatetime'] = date("Y-m-d H:i:s");
  203. $uap = Db::name("sale")->save($order);
  204. if ($uap == false) {
  205. Db::rollback();
  206. return error_show(1005, '销售单订单更新失败');
  207. }
  208. ActionLog::logAdd($this->post['token'], [
  209. "order_code" => $order["orderCode"],//出库单号
  210. "status" => $lor,//这里的status是之前的值
  211. "action_remark" => '',//备注
  212. "action_type" => "status"//新建create,编辑edit,更改状态status
  213. ], "XSQRD", $order['status'], $order);
  214. ProcessOrder::AddProcess($this->post['token'], [
  215. "order_type" => 'XSQRD',
  216. "order_code" =>$order["orderCode"],//出库单号
  217. "order_id" => $order["id"],
  218. "order_status" =>$order['status'],"before_status"=>$lor
  219. ]);
  220. // $ordernum = Db::name("order_num")->where(['orderCode' => $ordeCode])->find();
  221. // if ($ordernum == false) {
  222. // Db::rollback();
  223. // return error_show(1005, '未找到关联采购单');
  224. // }
  225. // $ordernum['send_num'] -= $thnum;
  226. // $orderup = Db::name("order_num")->save($ordernum);
  227. // if ($orderup == false) {
  228. // Db::rollback();
  229. // return error_show(1005, '关联数据更新失败');
  230. // }
  231. // $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  232. // if ($cgd == false) {
  233. // Db::rollback();
  234. // return error_show(1005, '未找到采购单数据');
  235. // }
  236. // $cgd['th_fee'] += round($cgd['good_price'] * $thnum, 2);
  237. // $cgd['th_num'] += $thnum;
  238. // $cgd['updatetime'] = date("Y-m-d H:i:s");
  239. // $cgdup = Db::name("purchease_order")->save($cgd);
  240. // if ($cgdup == false) {
  241. // Db::rollback();
  242. // return error_show(1005, '采购单数据更新失败');
  243. // }
  244. // if ($cgd['bkcode'] != "") {
  245. // $bk = Db::name("purchease_order")->where(["bkcode" => $cgd['bkcode'], "order_type" => 1, "order_source" =>0, "is_del" => 0])
  246. // ->find();
  247. // if ($bk == false) {
  248. // Db::rollback();
  249. // return error_show(1005, '未找到备库单数据');
  250. // }
  251. // $orderbk = Db::name("order_bk")->where(['cgdNo' => $bk['cgdNo'], "is_del" => 0])->find();
  252. // if ($orderbk == false) {
  253. // Db::rollback();
  254. // return error_show(1005, '备库单未完全入库');
  255. // }
  256. // $merge_num = Db::name("purchease_order")->where(["bkcode" => $bk['bkcode'], "order_type" =>
  257. // 1, "is_del" => 0])->where("order_source","<>",0)->field("sum(send_num)-sum(th_num) as num")
  258. // ->find();
  259. //
  260. // $orderbk['balance_num'] = $orderbk['total_num'] - $merge_num['num'];
  261. // $orderbk['merge_num'] = $merge_num['num'];
  262. // $orderbk['updatetime'] = date("Y-m-d H:i:s");
  263. // $orderbkup = Db::name("order_bk")->save($orderbk);
  264. // if ($orderbkup == false) {
  265. // Db::rollback();
  266. // return error_show(1005, '备库单库存数据释放失败');
  267. // }
  268. // }
  269. $saleinfo=Db::name("sale_info")->where([["orderCode","=",$ordeCode],["num",">",0]])->select()
  270. ->toArray();
  271. if(empty($saleinfo)) {
  272. $ordernum = Db::name("order_num")->where(['orderCode' => $ordeCode])->find();
  273. if ($ordernum == false) {
  274. Db::rollback();
  275. return error_show(1005, '未找到关联采购单');
  276. }
  277. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  278. if ($cgd == false) {
  279. Db::rollback();
  280. return error_show(1005, '未找到采购单数据');
  281. }
  282. $bn =makeNo("BN");
  283. $stock = Db::name("good_stock")->where(["spuCode" => $order['good_code'], 'wsm_code'=>$cgd['wsm_code'],"is_del"=>0,"status"=>1])->find();
  284. if($stock==false){
  285. Db::rollback();
  286. return error_show(1005, '商品库存数据未找到');
  287. }
  288. $stock['usable_stock']+=$thnum;
  289. $stock['wait_out_stock'] -=$thnum;
  290. $stock['updatetime'] = date("Y-m-d H:i:s");
  291. $st_up = Db::name("good_stock")->save($stock);
  292. if ($st_up == false) {
  293. return error_show(1005, '可售商品入库失败');
  294. }
  295. $yp=GoodStockInfo::AddBn($stock['id'],$bn,$thnum,$cgd['good_price']);
  296. if($yp==false){
  297. Db::rollback();
  298. return error_show(1005, '商品批次退货入库失败');
  299. }
  300. }else{
  301. $tempnum =$thnum;
  302. foreach ( $saleinfo as $va){
  303. if($tempnum ==0) break;
  304. $stock = Db::name("good_stock")->where(["spuCode" => $order['good_code'], 'id' => $va['stockid']])
  305. ->find();
  306. if($stock==false) {
  307. Db::rollback();
  308. return error_show(1005, '商品库存数据未找到');
  309. }
  310. if($va['num']>=$tempnum) {
  311. $tnm = $tempnum;
  312. $va['num']-= $tempnum;
  313. $va['th_num']+= $tempnum;
  314. $tempnum=0;
  315. }else{
  316. $tnm = $va['num'];
  317. $tempnum -=$va['num'];
  318. $va['th_num']+= $va['num'];
  319. $va['num'] =0;
  320. }
  321. $stock['usable_stock']+=$tnm;
  322. $stock['wait_out_stock'] -=$tnm;
  323. $stock['updatetime'] = date("Y-m-d H:i:s");
  324. $st_up = Db::name("good_stock")->save($stock);
  325. if ($st_up == false) {
  326. return error_show(1005, '可售商品入库失败');
  327. }
  328. $ps = GoodStockInfo::AddBn($va['stockid'],$va['bnCode'],$tnm);
  329. if ($ps == false) {
  330. return error_show(1005, '商品批次退货入库失败');
  331. }
  332. $ret = GoodStockInfo::ReturnBn($returnCode,$va['id'],$tnm);
  333. if ($ret == false) {
  334. return error_show(1005, '商品批次退货入库失败');
  335. }
  336. $va['updatetime']=date("Y-m-d H:i:s");
  337. $sal= Db::name("sale_info")->save($va);
  338. if ($sal == false) {
  339. return error_show(1005, '商品批次退货入库失败');
  340. }
  341. $good_data[]= ['good_log_code' => $returnCode, "stock_id" => $va['stockid'], "type" => 1, 'stock' => $thnum, "stock_name" => "usable_stock"];
  342. $good_data[]= ['good_log_code' => $returnCode, "stock_id" => $va['stockid'], "type" => 2, 'stock' => $thnum, "stock_name" => "wait_out_stock"];
  343. GoodLog::LogAdd($this->post['token'], $good_data, 'XSTHD');
  344. }
  345. }
  346. $data=[
  347. "orderCode"=>$ordeCode,
  348. "th_type"=>1,
  349. "th_num"=>$thnum,
  350. "th_fee"=>round($order['sale_price']*$thnum,2),
  351. "thCode"=>$returnCode,
  352. "spuCode"=>$order['good_code'],
  353. "good_name"=>$order['good_name'],
  354. "cat_id"=>$order['cat_id'],
  355. "apply_id"=>$rm,
  356. "apply_name"=>$ri,
  357. "addtime"=>date("Y-m-d H:i:s"),
  358. "status"=>1,
  359. "is_del"=>0
  360. ];
  361. $inse=Db::name("th_data")->insert($data);
  362. if($inse==false){
  363. Db::rollback();
  364. return error_show(1004,"退货单更新失败");
  365. }
  366. }
  367. Db::commit();
  368. return app_show(0,"退货单新建成功",["returnCode"=>$returnCode]);
  369. }
  370. Db::rollback();
  371. return error_show(1005,"退货单新建失败");
  372. }catch (\Exception $e){
  373. Db::rollback();
  374. return error_show(1005,$e->getMessage());
  375. }
  376. }
  377. //退货单列表
  378. public function list(){
  379. $page = isset($this->post['page']) && $this->post['page'] !=="" ? intval($this->post['page']):"1";
  380. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']):"10";
  381. $where =[['sr.is_del',"=",0]];
  382. $bkcode = isset($this->post['returnCode']) && $this->post['returnCode']!="" ? trim($this->post['returnCode']):"";
  383. if($bkcode!=""){
  384. $where[]=['sr.returnCode',"like", "%{$bkcode}%"];
  385. }
  386. $status = isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):"";
  387. if($status!==""){
  388. $where[]=['sr.status',"=", $status];
  389. }
  390. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode']!="" ? trim($this->post['orderCode']) :"";
  391. if($orderCode!=""){
  392. $where[]=['sr.orderCode',"like", "%{$orderCode}%"];
  393. }
  394. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name']!="" ? trim($this->post['apply_name']) :"";
  395. if($apply_name!=""){
  396. $where[]=['sr.apply_name',"like", "%{$apply_name}%"];
  397. }
  398. $start =isset($this->post['start'])&&$this->post['start']!='' ? $this->post['start']:"";
  399. if($start!==""){
  400. $where[]=['sr.addtime',">=", $start.' 00:00:00'];
  401. }
  402. $end =isset($this->post['end'])&&$this->post['end']!='' ? $this->post['end']:"";
  403. if($end!==""){
  404. $where[]=['sr.addtime',"<=", $end.' 23:59:59'];
  405. }
  406. //商品成本编码搜索
  407. $good_code = isset($this->post['good_code']) && $this->post['good_code'] != "" ? trim($this->post['good_code']) : "";
  408. if ($good_code != "") {
  409. $where[] = ['sr.good_code', "like", "%{$good_code}%"];
  410. }
  411. //商品上线编码搜索
  412. $skuCode = isset($this->post['skuCode']) && $this->post['skuCode'] != "" ? trim($this->post['skuCode']) : "";
  413. if ($skuCode != "") {
  414. $where[] = ['b.skuCode', "like", "%{$skuCode}%"];
  415. }
  416. $condition=[];
  417. // $role=$this->checkRole();
  418. // if(!empty($role['write']) && $this->uid!=""){
  419. // // $where[]=["sr.apply_id","in",$role['write']];
  420. // $condition .="sr.cgderid = {$this->uid} or sr.apply_id in (".implode(',',$role['write']).")";
  421. // }
  422. $role = $this->checkDataShare();
  423. $hand = resign_hand_user($this->uid,0);
  424. if (!empty($role[DataGroupModel::$type_全部])) {
  425. $arr= array_unique(array_merge($hand,$role[DataGroupModel::$type_全部]));
  426. // $uidim =implode(",",$hand);
  427. // $condition .= "sr.cgderid in ($uidim) or sr.person_id in ($uidim) or sr.apply_id in (" . implode(',',$arr) .
  428. // ")";
  429. $condition[]= ["sr.apply_id","in",$arr];
  430. $condition[]= ["sr.cgderid","in",$hand];
  431. $condition[]= ["sr.person_id","in",$hand];
  432. }
  433. // $role = $this->checkDataShare();
  434. // if (!empty($role[DataGroupModel::$type_全部])) $condition .= "sr.cgderid = {$this->uid} or sr.person_id = {$this->uid} or sr.apply_id in (" . implode(',', $role[DataGroupModel::$type_全部]) . ")";
  435. if(in_array($this->roleid,config('app.wsm_cgder_role'))){
  436. $where[]=["b.order_type","=",1];
  437. }
  438. $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
  439. if ($company_name !== "") $where[] = ["sr.apply_id", 'in', get_company_item_user_by_name($company_name)];
  440. $count=Db::name("sale_return")
  441. ->alias('sr')
  442. ->leftJoin("depart_user u", "u.uid=sr.apply_id AND u.is_del=0")
  443. ->leftJoin("sale b", "b.orderCode=sr.orderCode AND b.is_del=0")
  444. ->where($where)
  445. ->where(function ($query)use ($condition){$query->whereOr($condition);})
  446. ->count('sr.id');
  447. $total = ceil($count/$size);
  448. $page = $total>=$page ? $page :$total;
  449. $list = Db::name("sale_return")
  450. ->alias('sr')
  451. ->field('sr.*,u.itemid,b.skuCode,b.sale_price,b.good_num total_num ')
  452. ->leftJoin("depart_user u", "u.uid=sr.apply_id AND u.is_del=0")
  453. ->leftJoin("sale b", "b.orderCode=sr.orderCode AND b.is_del=0")
  454. ->where($where)
  455. ->where(function ($query)use ($condition){$query->whereOr($condition);})
  456. ->order("addtime desc")
  457. ->page($page,$size)
  458. ->cursor();
  459. // echo Db::name("sale_return")->getLastSql();
  460. $data=[];
  461. foreach ($list as $value){
  462. $value['error_msg']='';
  463. if($value['error_code']!=''){
  464. $error = Db::name("result_info")->where(["result_code"=>$value['error_code']])->find();
  465. $value['error_msg']= isset($error['result'])?$error['result']:"";
  466. }
  467. // $order =Db::name("sale")->where(["orderCode"=>$value['orderCode'],"is_del"=>0])->find();
  468. // $value['sale_price'] = isset($order['sale_price']) ?$order['sale_price']:0;
  469. $value['return_total'] =$value['sale_price']*$value['num'] ;
  470. // $value['total_num'] =$order['good_num'] ;
  471. $value['company_name'] = implode('/', array_column(GetPart($value['itemid']), 'name'));
  472. //是否具有编辑权限
  473. $value['is_allow_update'] = 0;
  474. if (in_array($this->roleid, [1, 33]) || in_array($value['apply_id'], $role[DataGroupModel::$type_可编辑])) $value['is_allow_update'] = 1;
  475. $data[]=$value ;
  476. }
  477. return app_show(0,"获取成功",["count"=>$count,'list'=>$data]);
  478. }
  479. public function info(){
  480. $code = isset($this->post['returnCode']) && $this->post['returnCode'] !=="" ? trim($this->post['returnCode'])
  481. :"";
  482. if($code==""){
  483. return error_show(1004,"参数returnCode不能为空");
  484. }
  485. $info = Db::name("sale_return")->where(["returnCode"=>$code,"is_del"=>0])->find();
  486. if(empty($info)){
  487. return error_show(1004,"未找到退货数据");
  488. }
  489. $orderinfo = Db::name("sale")->where(["orderCode"=>$info["orderCode"]])->find();
  490. if($orderinfo['order_type']==3){
  491. $goon = Db::name("good_zixun")->where(["spuCode"=>$orderinfo['good_code'],"is_del"=>0])->find();
  492. }else {
  493. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  494. ->where(['a.skuCode' => $orderinfo['skuCode']])->find();
  495. }
  496. if ($goon==false) {
  497. return error_show(1003, "未找到商品数据");
  498. }
  499. $int = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
  500. $info['is_stock']=isset($goon['is_stock'])?$goon['is_stock']:'0';
  501. $info['good_code'] = isset($orderinfo['good_code'])?$orderinfo['good_code']:'';
  502. $info['send_type'] = isset($orderinfo['send_type'])?$orderinfo['send_type']:'';
  503. $info['skuCode'] = isset($orderinfo['skuCode'])?$orderinfo['skuCode']:'';
  504. $info['good_name'] = isset($orderinfo['good_name'])?$orderinfo['good_name']:'';
  505. $info['good_num'] = isset($orderinfo['good_num'])?$orderinfo['good_num']:'';
  506. $info['sale_price'] = isset($orderinfo['sale_price'])?$orderinfo['sale_price']:'0';
  507. $info['origin_price'] = isset($orderinfo['origin_price'])?$orderinfo['origin_price']:'0';
  508. $info['return_total'] = $info['sale_price']*$info['num'] ;
  509. $info['send_num'] = isset($orderinfo['send_num'])?$orderinfo['send_num']:'0';
  510. $info['wsend_num'] = isset($orderinfo['wsend_num'])?$orderinfo['wsend_num']:'0';
  511. $info['send_status'] = isset($orderinfo['send_status'])?$orderinfo['send_status']:'';
  512. $info['total_price'] = isset($orderinfo['total_price'])?$orderinfo['total_price']:'0';
  513. $info['post_fee'] = isset($orderinfo['post_fee'])?$orderinfo['post_fee']:'0';
  514. $info['customer_code'] = isset($orderinfo['customer_code'])?$orderinfo['customer_code']:'';
  515. $info['customer_name']='';
  516. if(isset($orderinfo['customer_code'])&&$orderinfo['customer_code']!=''){
  517. $customerinfo = Db::name("customer_info")->where(['companyNo'=>$orderinfo['customer_code']])->find();
  518. $info['customer_name'] = isset($customerinfo['companyName']) ? $customerinfo['companyName']:"";
  519. }
  520. $info['supplierNo'] = isset($orderinfo['supplierNo'])?$orderinfo['supplierNo']:'';
  521. $info['supplier_name']='';
  522. if(isset($orderinfo['supplierNo'])&&$orderinfo['supplierNo']!=''){
  523. $customerinfo = Db::name("business")->where(['companyNo'=>$orderinfo['supplierNo']])->find();
  524. $info['supplier_name'] = isset($customerinfo['company']) ? $customerinfo['company']:"";
  525. }
  526. $info['platform_name']='';
  527. $info['platform_id']=$orderinfo['platform_id'];
  528. if($orderinfo['platform_id']!=0){
  529. $plat=Db::name("platform")->where(['id'=>$orderinfo['platform_id']])->find();
  530. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  531. }
  532. $info['cgd_wsend']="";
  533. $info['cgd_send']="";
  534. $info['cgd_total']="";
  535. if($orderinfo['order_type']==2){
  536. $cgd = Db::name("purchease_order")->where(["bkcode"=>$info["orderCode"],"order_type"=>2])->find();
  537. $info['cgd_wsend'] = isset($cgd['wsend_num']) ? $cgd['wsend_num']:0;
  538. $info['cgd_send'] = isset($cgd['send_num']) ? $cgd['send_num']:0;
  539. $info['cgd_total'] = isset($cgd['good_num']) ? $cgd['good_num']:0;
  540. }
  541. $info['error_msg']='';
  542. if($info['error_code']!=''){
  543. $error = Db::name("result_info")->where(["result_code"=>$info['error_code']])->find();
  544. $info['error_msg']= isset($error['result'])?$error['result']:"";
  545. }
  546. if($info['return_wsm']!=""){
  547. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  548. ->where(["a.wsm_code"=>$info['return_wsm']])->field("a.name as wsm_name,b.name,b.code")->find();
  549. }
  550. $info['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  551. // $info['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  552. // $info['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  553. $wsm_return = Db::name("sale_returninfo")->where(["returnCode"=>$info["returnCode"],"is_del"=>0])->select()->toArray();
  554. $wsm=[];
  555. if(!empty($wsm_return)){
  556. foreach ($wsm_return as $value){
  557. $value['wsm_name']="";
  558. $value['wsm_supplier']="";
  559. $value['wsm_supplierNo']="";
  560. if($value['wsm_code']!=""){
  561. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  562. ->where(["a.wsm_code"=>$value['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find();
  563. $value['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  564. $value['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  565. $value['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  566. }
  567. $orderwsm = Db::name("sale_info")->where(["orderCode"=>$info["orderCode"],"wsm_code"=>$value["wsm_code"]])->find();
  568. $value["wsm_total"] = isset($orderwsm["num"]) ? $orderwsm["num"]:0;
  569. $send = Db::name("order_out")->where(["wsm_code" => $value['wsm_code'], 'orderCode' => $info['orderCode']])->sum("send_num");
  570. $value['wsm_send'] = $send ?? 0;
  571. $value['wsm_wsend'] = $value['wsm_total'] - $value['wsm_send'];
  572. $wsm[]=$value;
  573. }
  574. }
  575. $info['wsminfo']=$wsm;
  576. $addr =Db::name("sale_returnaddr")->where(["returnCode"=>$info["returnCode"],"is_del"=>0])->select()->toArray();
  577. $addrinfo=[];
  578. if(!empty($addr)){
  579. foreach ( $addr as $value){
  580. $addrlist = Db::name("order_addr")->where(["id"=>$value["addrid"]])->find();
  581. $value['addr']=isset($addrlist['addr'])?$addrlist['addr']:"";
  582. $value['addr_code']=isset($addrlist['addr_code'])?$addrlist['addr_code']:"";
  583. $value['contactor']=isset($addrlist['contactor'])?$addrlist['contactor']:"";
  584. $value['mobile']=isset($addrlist['mobile'])?$addrlist['mobile']:"";
  585. $value['post_fee']=isset($addrlist['post_fee'])?$addrlist['post_fee']:"";
  586. $value['addive_time']=isset($addrlist['addive_time'])?$addrlist['addive_time']:"";
  587. $value['customer_code']=isset($addrlist['customer_code']) ?$addrlist['customer_code']:"" ;
  588. $value['receipt_quantity']=isset($addrlist['receipt_quantity']) ?$addrlist['receipt_quantity']:"" ;
  589. $send = Db::name("order_out")->where(['addrid' => $addrlist['id'], 'orderCode' => $addrlist['orderCode'],"is_del"=>0])->where("status",">=",2)->sum("send_num");
  590. $value['addr_send'] = $send ?? 0;
  591. $value['addr_wsend'] = $value['receipt_quantity'] - $value['addr_send'];
  592. $customer = Db::name("customer_info")->where(['companyNo'=>$addrlist['customer_code']])->find();
  593. $value['customer_name'] = isset($customer['companyName']) ? $customer['companyName']:"";
  594. $addrinfo[]=$value;
  595. }
  596. }
  597. $info['addrinfo']=$addrinfo;
  598. $info['can']=$int;
  599. return app_show(0,"获取成功",$info);
  600. }
  601. /**
  602. * @return \think\response\Json|void
  603. * @throws \think\db\exception\DataNotFoundException
  604. * @throws \think\db\exception\DbException
  605. * @throws \think\db\exception\ModelNotFoundException
  606. */
  607. public function delete(){
  608. $code = isset($this->post['returnCode']) && $this->post['returnCode'] !=="" ? trim($this->post['returnCode'])
  609. :"";
  610. if($code==""){
  611. return error_show(1004,"参数returnCode不能为空");
  612. }
  613. $info = Db::name("sale_return")->where(["returnCode"=>$code,"is_del"=>0])->find();
  614. if(empty($info)){
  615. return error_show(1004,"未找到退货数据");
  616. }
  617. $info["is_del"]=1;
  618. $info["updatetime"]=date("Y-m-d H:i:s");
  619. $del = Db::name("sale_return")->save($info);
  620. if($del){
  621. $ste = ["order_code"=>$code,"status"=>0,"action_remark"=>'',"action_type"=>"delete"];
  622. ActionLog::logAdd($this->post['token'],$ste,"XSTHD",0,$ste);
  623. $process=["order_code"=>$code,"order_id"=>$info['id'],"order_status"=>0,"order_type"=>"XSTHD"];
  624. ProcessOrder::workdel($process);
  625. return app_show(0,"删除成功");
  626. }else{
  627. return error_show(1004,"删除失败");
  628. }
  629. }
  630. /**审核
  631. * @return \think\response\Json|void
  632. * @throws \think\db\exception\DataNotFoundException
  633. * @throws \think\db\exception\DbException
  634. * @throws \think\db\exception\ModelNotFoundException
  635. */
  636. public function exam(){
  637. $code = isset($this->post['returnCode']) && $this->post['returnCode'] !=="" ? trim($this->post['returnCode']):"";
  638. if($code==""){
  639. return error_show(1004,"参数returnCode不能为空");
  640. }
  641. $info = Db::name("sale_return")->where(["returnCode"=>$code,"is_del"=>0])->find();
  642. if(empty($info)){
  643. return error_show(1004,"未找到退货数据");
  644. }
  645. $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']):"";
  646. if($status===""){
  647. return error_show(1004,"参数status不能为空");
  648. }
  649. $remark = isset($this->post['remark']) && $this->post['remark'] !="" ? trim($this->post['remark']) :"";
  650. $var = $info['status'];
  651. $orderinfo = Db::name("sale")->where(["orderCode"=>$info["orderCode"]])->find();
  652. if($orderinfo==false){
  653. return error_show(1004,"未找到订单数据");
  654. }
  655. if($status==4){
  656. if($info['is_addr']==1){
  657. $addr=Db::name("sale_returnaddr")->where(['returnCode'=>$info['returnCode'],"is_del"=>0])->select()
  658. ->toArray();
  659. if(empty($addr)){
  660. return error_show(1004,"未找到发货单地址数据");
  661. }
  662. }
  663. }
  664. if($status==3){
  665. $is_th =isset($this->post['is_th'])&&$this->post['is_th']!=="" ? intval($this->post['is_th']):"";
  666. if($is_th===""){
  667. return error_show(1004,"参数is_th不能为空");
  668. }
  669. $return_wsm =isset($this->post['return_wsm'])&&$this->post['return_wsm']!=="" ? trim($this->post['return_wsm']):"";
  670. if($is_th==0){
  671. if($return_wsm===""){
  672. return error_show(1004,"参数return_wsm 不能为空");
  673. }
  674. $wsmcode = Db::name("warehouse_info")->where(['wsm_code'=>$return_wsm])->find();
  675. if($wsmcode==false){
  676. return error_show(1004,"为找到仓库数据");
  677. }
  678. }
  679. $info['return_wsm'] =$return_wsm ;
  680. $info['is_th'] =$is_th ;
  681. }
  682. Db::startTrans();
  683. try{
  684. $temp= $info['status'];
  685. $info['status'] =$status;
  686. $remark!=""? $info['remark'] =$remark:"";
  687. $info["updatetime"]=date("Y-m-d H:i:s");
  688. $up = Db::name("sale_return")->save($info);
  689. if($up) {
  690. //如果是节点2(待专员审核),要将待办数据推给供应商负责人
  691. if ($info['status'] == 2) $process = ["order_code" => $code, "order_id" => $info['id'], "order_status" => $status, "order_type" => "XSTHD", 'before_status' => $temp, 'wait_id' => $info['person_id'], 'wait_name' => $info['person']];
  692. else $process = ["order_code" => $code, "order_id" => $info['id'], "order_status" => $status, "order_type" => "XSTHD", 'before_status' => $temp, 'holder_id' => $info['apply_id']];
  693. ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], $process);
  694. $ste = ["order_code" => $code, "status" => $temp, "action_remark" => '', "action_type" => "status"];
  695. ActionLog::logAdd(['id' => $this->uid, 'nickname' => $this->uname], $ste, "XSTHD", $status, $info);
  696. if ($status == 4) {
  697. if ($info['is_addr'] == 1) {
  698. if (isset($addr) && !empty($addr)) {
  699. foreach ($addr as $value) {
  700. $addrinfo = Db::name("order_addr")->where(['id' => $value['addrid'], "is_del" => 0])->find();
  701. if ($addrinfo == false) {
  702. Db::rollback();
  703. return error_show(1004, "地址数据未找到");
  704. }
  705. if ($addrinfo['receipt_quantity'] < $value['return_num']) {
  706. Db::rollback();
  707. return error_show(1004, "地址发货数量不足");
  708. }
  709. $addrinfo['receipt_quantity'] -= $value['return_num'];
  710. $addrinfo['is_del'] = $addrinfo['receipt_quantity'] <= 0 ? 1 : 0;
  711. $addrinfo['updatetime'] = date("Y-m-d H:i:s");
  712. $addrup = Db::name("order_addr")->save($addrinfo);
  713. if ($addrup == false) {
  714. Db::rollback();
  715. return error_show(1004, "地址发货数量更新失败");
  716. }
  717. if ($value['outCode'] != "") {
  718. $out = Db::name("order_out")->where(["outCode" => $value['outCode']])->find();
  719. if ($out == false) {
  720. Db::rollback();
  721. return error_show(1004, "地址发货单数据未找到");
  722. }
  723. if ($out['status'] >= 2) {
  724. Db::rollback();
  725. return error_show(1004, "地址发货单已发货");
  726. }
  727. if ($out['send_num'] < $value['return_num']) {
  728. Db::rollback();
  729. return error_show(1004, "地址发货单发货数量不足");
  730. }
  731. $out['send_num'] -= $value['return_num'];
  732. $out['is_del'] = $out['send_num'] <= 0 ? 1 : 0;
  733. $out['updatetime'] = date("Y-m-d H:i:s");
  734. $outup = Db::name("order_out")->save($out);
  735. if ($outup == false) {
  736. Db::rollback();
  737. return error_show(1004, "地址发货单更新失败");
  738. }
  739. }
  740. }
  741. }
  742. }
  743. if ($orderinfo['wsend_num'] < $info['num']) {
  744. Db::rollback();
  745. return error_show(1004, "销售单未发货数量不足退货");
  746. }
  747. $lor=$orderinfo['status'];
  748. $orderinfo['wsend_num'] -= $info['num'];
  749. $orderinfo['send_num'] += $info['num'];
  750. $orderinfo['status'] = $orderinfo['wsend_num']==0?2:($orderinfo['send_num']==0?0:1);
  751. $orderinfo['send_status'] =$orderinfo['wsend_num']==0?3:($orderinfo['send_num']==0?1:2);
  752. if ($orderinfo['is_stock'] == 1) {
  753. $orderinfo['th_num'] += $info['num'];
  754. if($orderinfo['th_num']==$orderinfo['send_num']&& $orderinfo['wsend_num']==0){
  755. $orderinfo['status']=3;
  756. }
  757. $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
  758. $orderinfo['updatetime'] = date("Y-m-d H:i:s");
  759. $uap = Db::name("sale")->save($orderinfo);
  760. if ($uap == false) {
  761. Db::rollback();
  762. return error_show(1005, '销售单订单更新失败');
  763. }
  764. }else{
  765. if ($info['is_th'] == 1){
  766. $orderinfo['th_num'] += $info['num'];
  767. if($orderinfo['th_num']==$orderinfo['send_num']&& $orderinfo['wsend_num']==0){
  768. $orderinfo['status']=3;
  769. }
  770. $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
  771. $orderinfo['updatetime'] = date("Y-m-d H:i:s");
  772. $uap = Db::name("sale")->save($orderinfo);
  773. if ($uap == false) {
  774. Db::rollback();
  775. return error_show(1005, '销售单订单更新失败');
  776. }
  777. $ordernum = Db::name("order_num")->where(['orderCode' => $orderinfo['orderCode']])->find();
  778. if ($ordernum == false) {
  779. Db::rollback();
  780. return error_show(1005, '未找到关联采购单');
  781. }
  782. $ordernum['send_num'] -= $info['num'];
  783. $orderup = Db::name("order_num")->save($ordernum);
  784. if ($orderup == false) {
  785. Db::rollback();
  786. return error_show(1005, '关联数据更新失败');
  787. }
  788. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  789. if ($cgd == false) {
  790. Db::rollback();
  791. return error_show(1005, '未找到采购单数据');
  792. }
  793. if( $info['is_all']==1 && $cgd['send_status']!=1){
  794. Db::rollback();
  795. return error_show(1005, '采购单已入库无法全部退货');
  796. }
  797. $lor=$cgd['status'];
  798. if($cgd['wsend_num']<$info['num']){
  799. $cgd['send_num'] += $cgd['wsend_num']==0?0 :($info['num']-$cgd['wsend_num']);
  800. $cgd['wsend_num']=0;
  801. }else{
  802. $cgd['wsend_num'] -= $info['num'];
  803. $cgd['send_num'] += $info['num'];
  804. }
  805. $cgd['status'] = $cgd['wsend_num']==0?2:($cgd['send_num']==0?0:1);
  806. $cgd['send_status'] =$cgd['wsend_num']==0?3:($cgd['send_num']==0?1:2);
  807. $cgd['th_num'] += $info['num'];
  808. if($cgd['th_num']==$cgd['send_num']&& $cgd['wsend_num']==0){
  809. $cgd['status']=4;
  810. }
  811. $cgd['th_fee'] += round($info['num'] * $cgd['good_price'], 2);
  812. $cgd['updatetime'] = date("Y-m-d H:i:s");
  813. $cgdup = Db::name("purchease_order")->save($cgd);
  814. if ($cgdup == false) {
  815. Db::rollback();
  816. return error_show(1005, '采购单数据更新失败');
  817. }
  818. $stock = Db::name("good_stock")->where(["spuCode" => $info['good_code'], 'wsm_code' =>$cgd['wsm_code']])->find();
  819. if ($stock==false) {
  820. Db::rollback();
  821. return error_show(1005, '商品仓库未找到');
  822. }
  823. if($stock['wait_in_stock']<$info['num']){
  824. $stock['wait_in_stock']=0;
  825. if( $stock['usable_stock']>$info['num']-$stock['wait_in_stock']){
  826. $stock['usable_stock'] -= $info['num']-$stock['wait_in_stock'];
  827. }else{
  828. $stock['usable_stock'] = 0;
  829. $stock['wait_out_stock']-= $info['num']-$stock['wait_in_stock']- $stock['usable_stock'] ;
  830. }
  831. $stock['total_stock']= $stock['usable_stock']+ $stock['wait_out_stock'];
  832. }else{
  833. $stock['wait_in_stock']-=$info['num'];
  834. }
  835. $stock['updatetime'] = date("Y-m-d H:i:s");
  836. $st_up = Db::name("good_stock")->save($stock);
  837. if ($st_up == false) {
  838. Db::rollback();
  839. return error_show(1005, '可售商品入库失败');
  840. }
  841. } else {
  842. $orderinfo['th_num'] += $info['num'];
  843. if($orderinfo['th_num']==$orderinfo['send_num']&& $orderinfo['wsend_num']==0){
  844. $orderinfo['status']=3;
  845. }
  846. $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
  847. $orderinfo['updatetime'] = date("Y-m-d H:i:s");
  848. $uap = Db::name("sale")->save($orderinfo);
  849. if ($uap == false) {
  850. Db::rollback();
  851. return error_show(1005, '销售单订单更新失败');
  852. }
  853. $ordernum = Db::name("order_num")->where(['orderCode' => $orderinfo['orderCode']])->find();
  854. if ($ordernum == false) {
  855. Db::rollback();
  856. return error_show(1005, '未找到关联采购单');
  857. }
  858. $ordernum['send_num'] -= $info['num'];
  859. $ordernum['wsend_num'] = $info['num'];
  860. $orderup = Db::name("order_num")->save($ordernum);
  861. if ($orderup == false) {
  862. Db::rollback();
  863. return error_show(1005, '关联数据更新失败');
  864. }
  865. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  866. if ($cgd == false) {
  867. Db::rollback();
  868. return error_show(1005, '未找到采购单数据');
  869. }
  870. $stock = Db::name("good_stock")->where(["spuCode" => $orderinfo['good_code'], 'wsm_code' =>$cgd['wsm_code']])->find();
  871. if ($stock==false) {
  872. Db::rollback();
  873. return error_show(1005, '商品仓库未找到');
  874. }
  875. if($info['is_all']==1){
  876. if($stock['wait_in_stock']<$info['num']){
  877. Db::rollback();
  878. return error_show(1005, '商品可用库存不足退回数量');
  879. }else{
  880. $stock['wait_in_stock']-= $info['num'];
  881. }
  882. }else{
  883. if($stock['usable_stock']+$stock['wait_out_stock']<$info['num']){
  884. Db::rollback();
  885. return error_show(1005, '商品可用库存不足退回数量');
  886. }else{
  887. if($stock['usable_stock']>$info['num']){
  888. $stock['usable_stock'] -= $info['num'];
  889. }else{
  890. $stock['usable_stock'] = 0;
  891. $stock['wait_out_stock']-= $info['num']- $stock['usable_stock'] ;
  892. }
  893. $stock['total_stock']= $stock['usable_stock']+ $stock['wait_out_stock'];
  894. }
  895. }
  896. $stock['updatetime'] = date("Y-m-d H:i:s");
  897. $st_up = Db::name("good_stock")->save($stock);
  898. if ($st_up == false) {
  899. Db::rollback();
  900. return error_show(1005, '可售商品入库失败');
  901. }
  902. }
  903. }
  904. ActionLog::logAdd($this->post['token'], [
  905. "order_code" => $orderinfo["orderCode"],//出库单号
  906. "status" => $lor,//这里的status是之前的值
  907. "action_remark" => '',//备注
  908. "action_type" => "status"//新建create,编辑edit,更改状态status
  909. ], "XSQRD", $orderinfo['status'], $orderinfo);
  910. ProcessOrder::AddProcess($this->post['token'], [
  911. "order_type" => 'XSQRD',
  912. "order_code" =>$orderinfo["orderCode"],//出库单号
  913. "order_id" => $orderinfo["id"],
  914. "order_status" =>$orderinfo['status'],"before_status"=>$lor
  915. ]);
  916. //对应采购单也要处理
  917. $holder_id = Db::name('supplier')->where(['code' => $cgd['supplierNo'], 'is_del' => 0])->value('personid', 0);
  918. if(in_array($cgd['status'],[4])){
  919. if($orderinfo['is_stock']==1){
  920. //库存品,推给31库管人员、41库管-张凯旋
  921. $uid = Db::name('user_role')
  922. ->where([
  923. ['is_del', '=', 0],
  924. ['roleid', 'in', [31, 41]],
  925. ['status', '=', 1]
  926. ])->column('uid');
  927. // if(!in_array($this->uid,$uid)) throw new Exception('库存品订单只能由库管人员操作');
  928. ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], [
  929. "order_type" => 'CGD',
  930. "order_code" => $cgd['cgdNo'],
  931. "order_id" => $cgd["id"],
  932. "order_status" => $cgd['status'],
  933. "before_status" => $lor,
  934. 'holder_id' => $holder_id,
  935. 'handle_user_list' => implode(',', $uid),
  936. ]);
  937. }else{
  938. // if($this->uid != $holder_id)throw new Exception('非库存品和采返商品只能由供应商负责人操作');
  939. //非库存品和采返商品,推给供应商负责人
  940. ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], [
  941. "order_type" => 'CGD',
  942. "order_code" => $cgd['cgdNo'],
  943. "order_id" => $cgd["id"],
  944. "order_status" => $cgd['status'],
  945. "before_status" => $lor,
  946. 'holder_id' => $holder_id,
  947. 'handle_user_list' => $orderinfo['cgderid'],
  948. ]);
  949. }
  950. }
  951. // ProcessOrder::AddProcess(['id' => $this->uid, 'nickname' => $this->uname], [
  952. // "order_type" => 'CGD',
  953. // "order_code" => $cgd['cgdNo'],
  954. // "order_id" => $cgd["id"],
  955. // "order_status" => $cgd['status'],
  956. // "before_status" => $lor,
  957. // 'holder_id' => $holder_id
  958. // ]);
  959. if($orderinfo['is_stock'] == 1 || $info['is_th'] == 0){
  960. if ($orderinfo['order_type']!=1){
  961. if($orderinfo['order_type']==3){
  962. $goon = Db::name("good_zixun")->where(["spuCode"=>$orderinfo['good_code'],"is_del"=>0])->find();
  963. $isZx=1;
  964. }else {
  965. $goon = Db::name('good_basic')->where(['spuCode' => $orderinfo['good_code']])->find();
  966. $isZx=2;
  967. }
  968. $spuCode = $this->CheckGoodZx($goon,$isZx,$code);
  969. $wsmcode = $info['return_wsm'];
  970. if ($wsmcode == "") {
  971. Db::rollback();
  972. return error_show(1005, '未找到退货仓库');
  973. }
  974. $stock = Db::name("good_stock")->where(["spuCode" => $spuCode, 'wsm_code' => $wsmcode])->find();
  975. if (empty($stock)) {
  976. $stock = [
  977. "spuCode" => $spuCode,
  978. "wsm_code" => $wsmcode,
  979. "usable_stock" => 0,
  980. "wait_out_stock" => 0,
  981. "wait_in_stock" => 0,
  982. "total_stock" => 0,
  983. "addtime" => date("Y-m-d H:i:s"),
  984. "updatetime" => date("Y-m-d H:i:s"),
  985. ];
  986. }
  987. $stock['usable_stock'] += $info['num'];
  988. $stock['updatetime'] = date("Y-m-d H:i:s");
  989. $st_up = Db::name("good_stock")->save($stock);
  990. if ($st_up == false) {
  991. Db::rollback();
  992. return error_show(1005, '可售商品入库失败');
  993. }
  994. $stockid = isset($stock['id']) ? $stock['id'] : Db::name("good_stock")->getLastInsID();
  995. $sabebn =Db::name("sale_info")->where(["orderCode"=>$orderinfo["orderCode"]])->select()->toArray();
  996. if(!empty($sabebn)){
  997. $total_num =$info['num'];
  998. foreach ($sabebn as $ve){
  999. $tempnum=0;
  1000. if ($total_num==0) break;
  1001. if($total_num>=$ve['num']){
  1002. $tempnum = $ve['num'];
  1003. $total_num-=$ve['num'];
  1004. $ve['th_num']+=$ve['num'];
  1005. $ve['num']=0;
  1006. }else{
  1007. $tempnum = $total_num;
  1008. $ve['num']-=$total_num;
  1009. $ve['th_num']+=$total_num;
  1010. $total_num=0;
  1011. }
  1012. $bnin=GoodStockInfo::AddBn($stockid,$ve['bnCode'],$tempnum,$ve['origin_price']);
  1013. if($bnin==false){
  1014. Db::rollback();
  1015. return error_show(1005, '可售商品Bn库存数入库失败');
  1016. }
  1017. $ve['updatetime']=date("Y-m-d H:i:s");
  1018. $up=Db::name("sale_info")->save($ve);
  1019. if($up==false){
  1020. Db::rollback();
  1021. return error_show(1005, '可售商品Bn库存数入库失败');
  1022. }
  1023. $bnin=GoodStockInfo::ReturnBn($info['returnCode'],$ve['id'],$tempnum);
  1024. if($bnin==false){
  1025. Db::rollback();
  1026. return error_show(1005, '可售商品Bn库存数入库失败');
  1027. }
  1028. }
  1029. }else{
  1030. $bn=makeNo("BN");
  1031. $bnin=GoodStockInfo::AddBn($stockid,$bn,$info['num'],$cgd['good_price']??0);
  1032. if($bnin==false){
  1033. Db::rollback();
  1034. return error_show(1005, '可售商品Bn库存数入库失败');
  1035. }
  1036. }
  1037. $good_data = ['good_log_code' => $info['returnCode'], "stock_id" => $stockid, "type" => 1, 'stock'=> $info['num'], "stock_name" => "usable_stock"];
  1038. GoodLog::LogAdd($this->post['token'], $good_data, 'XSTHD');
  1039. }else{
  1040. $sabebn =Db::name("sale_info")->where(["orderCode"=>$orderinfo["orderCode"]])->select()->toArray();
  1041. if(!empty($sabebn)){
  1042. $total_num =$info['num'];
  1043. foreach ($sabebn as $ve){
  1044. $stock = Db::name("good_stock")->where(["spuCode" => $orderinfo['good_code'], 'id' => $ve['stockid']])->find();
  1045. if($stock==false) {
  1046. Db::rollback();
  1047. return error_show(1005, '商品库存数据未找到');
  1048. }
  1049. $tempnum=0;
  1050. if ($total_num==0) break;
  1051. if($total_num>=$ve['num']){
  1052. $tempnum = $ve['num'];
  1053. $total_num-=$ve['num'];
  1054. $ve['th_num']+=$ve['num'];
  1055. $ve['num']=0;
  1056. }else{
  1057. $tempnum = $total_num;
  1058. $ve['num']-=$total_num;
  1059. $ve['th_num']+=$total_num;
  1060. $total_num=0;
  1061. }
  1062. $stock['usable_stock']+=$tempnum;
  1063. $stock['wait_out_stock'] -=$tempnum;
  1064. $stock['updatetime'] = date("Y-m-d H:i:s");
  1065. $st_up = Db::name("good_stock")->save($stock);
  1066. if ($st_up == false) {
  1067. return error_show(1005, '可售商品入库失败');
  1068. }
  1069. $bnin=GoodStockInfo::AddBn($ve['stock_id'],$ve['bnCode'],$tempnum,$ve['origin_price']);
  1070. if($bnin==false){
  1071. Db::rollback();
  1072. return error_show(1005, '可售商品Bn库存数入库失败');
  1073. }
  1074. $ve['updatetime']=date("Y-m-d H:i:s");
  1075. $up=Db::name("sale_info")->save($ve);
  1076. if($up==false){
  1077. Db::rollback();
  1078. return error_show(1005, '可售商品Bn库存数入库失败');
  1079. }
  1080. $bnin=GoodStockInfo::ReturnBn($info['returnCode'],$ve['id'],$tempnum);
  1081. if($bnin==false){
  1082. Db::rollback();
  1083. return error_show(1005, '可售商品Bn库存数入库失败');
  1084. }
  1085. }
  1086. }else{
  1087. $ordernum = Db::name("order_num")->where(['orderCode' =>$orderinfo["orderCode"]])->find();
  1088. if ($ordernum == false) {
  1089. Db::rollback();
  1090. return error_show(1005, '未找到关联采购单');
  1091. }
  1092. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  1093. if ($cgd == false) {
  1094. Db::rollback();
  1095. return error_show(1005, '未找到采购单数据');
  1096. }
  1097. $bn =makeNo("BN");
  1098. $stock = Db::name("good_stock")->where(["spuCode" => $orderinfo['good_code'], 'wsm_code'=>$cgd['wsm_code'],"is_del"=>0,"status"=>1])->find();
  1099. if($stock==false){
  1100. Db::rollback();
  1101. return error_show(1005, '商品库存数据未找到');
  1102. }
  1103. $stock['usable_stock']+=$info['num'];
  1104. $stock['wait_out_stock'] -=$info['num'];
  1105. $stock['updatetime'] = date("Y-m-d H:i:s");
  1106. $st_up = Db::name("good_stock")->save($stock);
  1107. if ($st_up == false) {
  1108. return error_show(1005, '可售商品入库失败');
  1109. }
  1110. $yp=GoodStockInfo::AddBn($stock['id'],$bn,$info['num'],$cgd['good_price']);
  1111. if($yp==false){
  1112. Db::rollback();
  1113. return error_show(1005, '商品批次退货入库失败');
  1114. }
  1115. }
  1116. }
  1117. }
  1118. $data=[
  1119. "orderCode"=>$info['orderCode'],
  1120. "th_type"=>1,
  1121. "th_num"=>$info['num'],
  1122. "th_fee"=>round($info['num']*$orderinfo['sale_price'],2),
  1123. "thCode"=>$info['returnCode'],
  1124. "spuCode"=>$orderinfo['good_code'],
  1125. "good_name"=>$orderinfo['good_name'],
  1126. "cat_id"=>$orderinfo['cat_id'],
  1127. "apply_id"=>$info['apply_id'],
  1128. "apply_name"=>$info['apply_name'],
  1129. "addtime"=>date("Y-m-d H:i:s"),
  1130. "status"=>1,
  1131. "is_del"=>0
  1132. ];
  1133. $inse=Db::name("th_data")->insert($data);
  1134. if($inse==false){
  1135. Db::rollback();
  1136. return error_show(1004,"退货单更新失败");
  1137. }
  1138. }
  1139. }
  1140. Db::commit();
  1141. return app_show(0,"更新成功");
  1142. }catch (\Exception $e){
  1143. Db::rollback();
  1144. return error_show(1004,$e->getMessage()."|".$e->getLine());
  1145. }
  1146. }
  1147. public function zxcreate(){
  1148. $ordeCode = isset($this->post['orderCode']) &&$this->post['orderCode']!=''?trim($this->post['orderCode']) :"";
  1149. if($ordeCode==''){
  1150. return error_show(1004,"参数orderCode 不能为空");
  1151. }
  1152. $order= Db::name("sale")->where(["orderCode"=>$ordeCode,"is_del"=>0])->find();
  1153. if(empty($order)){
  1154. return error_show(1005,"未找到订单数据");
  1155. }
  1156. $errorCode = isset($this->post['errorCode']) &&$this->post['errorCode']!=''?trim($this->post['errorCode']) :"";
  1157. if($errorCode==''){
  1158. return error_show(1004,"参数errorCode 不能为空");
  1159. }
  1160. $error =Db::name('result_info')->where(["result_code"=>$errorCode,"is_del"=>0])->find();
  1161. if(empty($error)){
  1162. return error_show(1005,"未找到退货原因数据");
  1163. }
  1164. $remark =isset($this->post['remark']) &&$this->post['remark']!=''?trim($this->post['remark']) :"";
  1165. $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):"";
  1166. if($token==''){
  1167. return error_show(105,"参数token不能为空");
  1168. }
  1169. $user =GetUserInfo($token);
  1170. if(empty($user)||$user['code']!=0){
  1171. return error_show(1002,"申请人数据不存在");
  1172. }
  1173. $rm= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  1174. $ri= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  1175. $num = isset($this->post['num'])&&$this->post['num']!='' ? intval($this->post['num']):"";
  1176. if($num==''){
  1177. return error_show(1005,"参数num不能为空");
  1178. }
  1179. if($order['wsend_num']<$num){
  1180. return error_show(1002,"仓库未发货数量不足退货");
  1181. }
  1182. $returnCode=makeNo("RS");
  1183. Db::startTrans();
  1184. try{
  1185. $in = [
  1186. "returnCode"=>$returnCode,
  1187. "orderCode"=>$ordeCode,
  1188. "good_code"=>$order['good_code'],
  1189. "good_name"=>$order['good_name'],
  1190. "apply_id"=>$rm,
  1191. "apply_name"=>$ri,
  1192. "error_code"=>$errorCode,
  1193. "num"=>$num,
  1194. "remark"=>$remark,
  1195. "order_type"=>2,
  1196. "status"=>0,
  1197. "is_del"=>0,
  1198. "addtime"=>date("Y-m-d H:i:s"),
  1199. "updatetime"=>date("Y-m-d H:i:s")
  1200. ];
  1201. $create = Db::name("sale_return")->insert($in,true);
  1202. if($create>0) {
  1203. $process=["order_code"=>$returnCode,"order_id"=>$create,"order_status"=>0,"order_type"=>'XSTHD',"before_status"=>0,'holder_id'=>$in['apply_id']];
  1204. ProcessOrder::AddProcess($this->post['token'],$process);
  1205. $ste = ["order_code"=>$returnCode,"status"=>0,"action_remark"=>'',
  1206. "action_type"=>"create"];
  1207. ActionLog::logAdd($this->post['token'],$ste,"XSTHD",3,$in);
  1208. //维护台账记录
  1209. // Db::name('standing_book')
  1210. // ->where('ordeCode', $ordeCode)
  1211. // ->update([
  1212. // 'returnGoodCode' => $returnCode,
  1213. // 'updatetime' => date("Y-m-d H:i:s")
  1214. // ]);
  1215. Db::execute("UPDATE `wsm_standing_book` SET `returnGoodCode`=CONCAT(IFNULL(`returnGoodCode`,''),',{$returnCode}'),`updatetime`='" . date('Y-m-d H:i:s') . "' WHERE `orderCode`='{$ordeCode}'");
  1216. if ($order['send_type'] == 1) {
  1217. $wsend = Db::name("order_out")->where(['orderCode' => $ordeCode, "status" => 1, "order_type"=>2])->select();
  1218. // ->save(["status" => 0, "updatetime" => date("Y-m-d H:i:s")]);
  1219. if(!empty($wsend)){
  1220. foreach ($wsend as $value){
  1221. $tt = $value['status'];
  1222. $value['status']=0;
  1223. $value['updatetime']=date("Y-m-d H:i:s");
  1224. $up =Db::name("order_out")->save($value);
  1225. if($up){
  1226. $process=["order_code"=> $value['outCode'],"order_id"=>$value['id'],"order_status"=>0,"order_type"=>'CKD',"before_status"=>$tt,'holder_id' => $value['apply_id']];
  1227. ProcessOrder::AddProcess($this->post['token'],$process);
  1228. $ste = ["order_code"=>$value['outCode'],"status"=>$tt,"action_remark"=>'',"action_type"=>"status"];
  1229. ActionLog::logAdd($this->post['token'],$ste,"CKD",0,$value);
  1230. }else{
  1231. Db::rollback();
  1232. return error_show(1005,"退货单新建失败");
  1233. }
  1234. }
  1235. }
  1236. }
  1237. Db::commit();
  1238. return error_show(0,"退货单新建成功");
  1239. }
  1240. Db::rollback();
  1241. return error_show(1005,"退货单新建失败");
  1242. }catch (\Exception $e){
  1243. Db::rollback();
  1244. return error_show(1005,$e->getMessage());
  1245. }
  1246. }
  1247. public function allReturn(){
  1248. $orderCode =isset($this->post['orderCode'])&&$this->post['orderCode']!=''? trim($this->post['orderCode']):"";
  1249. if($orderCode==''){
  1250. return error_show(1004,"参数orderCode 不能为空");
  1251. }
  1252. $order= Db::name("sale")->where(["orderCode"=>$orderCode,"is_del"=>0])->find();
  1253. if(empty($order)){
  1254. return error_show(1005,"未找到订单数据");
  1255. }
  1256. if($order['wsend_num']!=$order['good_num']){
  1257. return error_show(1005,"订单未发货数量与总数不等,无法全退");
  1258. }
  1259. $retrun =Db::name("sale_return")->where([["orderCode","=",$orderCode],["is_del","=",0],["status","<",4]])->count();
  1260. if($retrun>0){
  1261. return error_show(1005,"存在退货订单数据");
  1262. }
  1263. if($order['order_type']==3){
  1264. $goon = Db::name("good_zixun")->where(["spuCode"=>$order['good_code'],"is_del"=>0])->find();
  1265. }else {
  1266. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  1267. ->where(['a.skuCode' => $order['skuCode']])->field("b.creater,b.createrid,b.supplierNo")->find();
  1268. }
  1269. if($goon==false){
  1270. return error_show(1005,"未找到商品数据");
  1271. }
  1272. $supplier =Db::name("supplier")->where(["code"=>$goon['supplierNo']])->find();
  1273. if($supplier==false){
  1274. return error_show(1005,"未找到商品供应商数据");
  1275. }
  1276. $errorCode = isset($this->post['errorCode']) &&$this->post['errorCode']!=''?trim($this->post['errorCode']) :"";
  1277. if($errorCode==''){
  1278. return error_show(1004,"参数errorCode 不能为空");
  1279. }
  1280. $error =Db::name('result_info')->where(["result_code"=>$errorCode,"is_del"=>0])->find();
  1281. if(empty($error)){
  1282. return error_show(1005,"未找到退货原因数据");
  1283. }
  1284. $remark =isset($this->post['remark']) &&$this->post['remark']!=''?trim($this->post['remark']) :"";
  1285. $addr =Db::name("order_addr")->where([["orderCode","=",$orderCode],["is_del","=",0]])->select()->toArray();
  1286. if($order['is_stock']==0){
  1287. $ordernum = Db::name("order_num")->where(['orderCode' => $orderCode])->find();
  1288. if ($ordernum == false) {
  1289. return error_show(1005, '未找到关联采购单');
  1290. }
  1291. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  1292. if ($cgd == false) {
  1293. return error_show(1005, '未找到采购单数据');
  1294. }
  1295. }
  1296. if($order['is_stock']==0&&$cgd['send_status']!=1){
  1297. return error_show(1005, '采购单已发起入库');
  1298. }
  1299. $returnCode=makeNo("RN");
  1300. Db::startTrans();
  1301. try{
  1302. $in = [
  1303. "returnCode"=>$returnCode,
  1304. "orderCode"=>$orderCode,
  1305. "good_code"=>$order['good_code'],
  1306. "good_name"=>$order['good_name'],
  1307. "apply_id"=>$this->uid,
  1308. "apply_name"=>$this->uname,
  1309. "cgderid"=>$goon['createrid'],
  1310. "cgder"=>$goon['creater'],
  1311. "person"=>$supplier['person']??'',
  1312. "person_id"=>$supplier['personid']??0,
  1313. "error_code"=>$errorCode,
  1314. "num"=>$order['wsend_num'],
  1315. "total_fee"=>round($order['sale_price']*$order['wsend_num'],2),
  1316. "good_price"=>$order['sale_price'],
  1317. "platform_id"=>$order['platform_id'],
  1318. "remark"=>$remark,
  1319. "order_type"=>$order['order_type'],
  1320. "is_addr"=>count($addr)>0 ?1:0,
  1321. "status"=>$order['is_stock']==1?4:1,
  1322. "is_del"=>0,
  1323. "is_all"=>1,
  1324. "addtime"=>date("Y-m-d H:i:s"),
  1325. "updatetime"=>date("Y-m-d H:i:s")
  1326. ];
  1327. $create = Db::name("sale_return")->insert($in,true);
  1328. if($create>0){
  1329. $stn = ["order_code"=>$returnCode,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  1330. ActionLog::logAdd(["id"=>$this->uid,"nickname"=>$this->uname],$stn,"XSTHD",$in['status'],$in);
  1331. $process=["order_code"=>$returnCode,"order_id"=>$create,"order_status"=>$in['status'],"order_type"=>'XSTHD',"before_status"=>0,'holder_id'=>$in['apply_id']];
  1332. ProcessOrder::AddProcess(["id"=>$this->uid,"nickname"=>$this->uname],$process);
  1333. //维护台账信息
  1334. Db::execute("UPDATE `wsm_standing_book` SET `returnGoodCode`=CONCAT(IFNULL(`returnGoodCode`,''),',{$returnCode}'),`updatetime`='" . date('Y-m-d H:i:s') . "' WHERE `orderCode`='{$orderCode}'");
  1335. if(count($addr)!=0){
  1336. $inf=[];
  1337. foreach ($addr as $val){
  1338. if ($val['receipt_quantity'] == 0) continue;//当退货数量为0时,跳过
  1339. $temp=[];
  1340. $send =Db::name('order_out')->where([["addrid","=",$val['id']]])->find();
  1341. if ($send == false) {
  1342. Db::rollback();
  1343. return error_show(1004, "地址发货单未找到");
  1344. }
  1345. if($send['status']>=2){
  1346. Db::rollback();
  1347. return error_show(1005,"地址已发货");
  1348. }
  1349. if($order['is_stock']==1){
  1350. $val['is_del'] = 1;
  1351. $val['updatetime'] = date("Y-m-d H:i:s");
  1352. $addrup = Db::name("order_addr")->save($val);
  1353. if ($addrup == false) {
  1354. Db::rollback();
  1355. return error_show(1004, "地址更新失败");
  1356. }
  1357. $send['is_del'] = 1;
  1358. $send['remark'] ='全退';
  1359. $send['updatetime'] = date("Y-m-d H:i:s");
  1360. $outup = Db::name("order_out")->save($send);
  1361. if ($outup == false) {
  1362. Db::rollback();
  1363. return error_show(1004, "地址发货单更新失败");
  1364. }
  1365. //处理发货申请单流程
  1366. ProcessOrder::AddProcess(["id" => $this->uid, "nickname" => $this->uname], [
  1367. "order_type" => 'CKD',
  1368. "order_code" => $send["outCode"],//出库单号
  1369. "order_id" => $send["id"],
  1370. "order_status" => 4,//全部退货
  1371. "before_status" => $send['status'],
  1372. 'holder_id=' => $send['apply_id']
  1373. ]);
  1374. // $ordersend = Db::name("order_send")->where(["outCode" => $send['outCode']])->find();
  1375. // if($ordersend==false){
  1376. // Db::rollback();
  1377. // return error_show(1004, "发货单关联数据未找到");
  1378. // }
  1379. // $ordersend['status'] = 0;
  1380. // $ordersend['updatetime'] = date("Y-m-d H:i:s");
  1381. // $sendip = Db::name("order_send")->save($ordersend);
  1382. // if ($sendip == false) {
  1383. // Db::rollback();
  1384. // return error_show(1004, "发货单更新失败");
  1385. // }
  1386. }
  1387. $temp['returnCode']=$returnCode;
  1388. $temp['orderCode']=$orderCode;
  1389. $temp['outCode']=isset($send['outCode'])?$send['outCode']:"";
  1390. $temp['addrid']=$val['id'];
  1391. $temp['send_num']=$val['receipt_quantity'];
  1392. $temp['return_num']=$val['receipt_quantity'];
  1393. $temp['is_del']=0;
  1394. $temp['addtime']=date("Y-m-d H:i:s");
  1395. $temp['updatetime']=date("Y-m-d H:i:s");
  1396. $inf[]=$temp;
  1397. }
  1398. $inadd=Db::name("sale_returnaddr")->insertAll($inf);
  1399. if($inadd==0){
  1400. Db::rollback();
  1401. return error_show(1005,"退货单新建失败");
  1402. }
  1403. }
  1404. if($order['is_stock']==1){
  1405. $lor=$order['status'];
  1406. $thnum = $order['wsend_num'];
  1407. $order['send_num'] += $thnum;
  1408. $order['th_num'] += $thnum;
  1409. $order['wsend_num'] =0;
  1410. $order['status'] = 3;
  1411. $order['send_status']=3;
  1412. $order['th_fee'] += round($thnum * $order['sale_price'], 2);
  1413. $order['updatetime'] = date("Y-m-d H:i:s");
  1414. $uap = Db::name("sale")->save($order);
  1415. if ($uap == false) {
  1416. Db::rollback();
  1417. return error_show(1005, '销售单订单更新失败');
  1418. }
  1419. ActionLog::logAdd(["id"=>$this->uid,"nickname"=>$this->uname], [
  1420. "order_code" => $order["orderCode"],//出库单号
  1421. "status" => $lor,//这里的status是之前的值
  1422. "action_remark" => '',//备注
  1423. "action_type" => "status"//新建create,编辑edit,更改状态status
  1424. ], "XSQRD", $order['status'], $order);
  1425. ProcessOrder::AddProcess(["id"=>$this->uid,"nickname"=>$this->uname], [
  1426. "order_type" => 'XSQRD',
  1427. "order_code" =>$order["orderCode"],//出库单号
  1428. "order_id" => $order["id"],
  1429. "order_status" =>$order['status'],
  1430. "before_status"=>$lor,
  1431. 'holder_id=' => $order['apply_id']
  1432. ]);
  1433. $saleinfo=Db::name("sale_info")->where([["orderCode","=",$orderCode],["num",">",0]])->select()->toArray();
  1434. if(empty($saleinfo)) {
  1435. $ordernum = Db::name("order_num")->where(['orderCode' => $orderCode])->find();
  1436. if ($ordernum == false) {
  1437. Db::rollback();
  1438. return error_show(1005, '未找到关联采购单');
  1439. }
  1440. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  1441. if ($cgd == false) {
  1442. Db::rollback();
  1443. return error_show(1005, '未找到采购单数据');
  1444. }
  1445. $bn =makeNo("BN");
  1446. $stock = Db::name("good_stock")->where(["spuCode" => $order['good_code'], 'wsm_code'=>$cgd['wsm_code'],"is_del"=>0,"status"=>1])->find();
  1447. if($stock==false){
  1448. Db::rollback();
  1449. return error_show(1005, '商品库存数据未找到');
  1450. }
  1451. $stock['usable_stock']+=$thnum;
  1452. $stock['wait_out_stock'] -=$thnum;
  1453. $stock['updatetime'] = date("Y-m-d H:i:s");
  1454. $st_up = Db::name("good_stock")->save($stock);
  1455. if ($st_up == false) {
  1456. return error_show(1005, '可售商品入库失败');
  1457. }
  1458. $yp=GoodStockInfo::AddBn($stock['id'],$bn,$thnum,$cgd['good_price']);
  1459. if($yp==false){
  1460. Db::rollback();
  1461. return error_show(1005, '商品批次退货入库失败');
  1462. }
  1463. }else{
  1464. $tempnum =$thnum;
  1465. foreach ($saleinfo as $va){
  1466. if($tempnum ==0) break;
  1467. $stock = Db::name("good_stock")->where(["spuCode" => $order['good_code'], 'id' => $va['stockid']])->find();
  1468. if($stock==false) {
  1469. Db::rollback();
  1470. return error_show(1005, '商品库存数据未找到');
  1471. }
  1472. if($va['num']>=$tempnum) {
  1473. $tnm = $tempnum;
  1474. $va['num']-= $tempnum;
  1475. $va['th_num']+= $tempnum;
  1476. $tempnum=0;
  1477. }else{
  1478. $tnm = $va['num'];
  1479. $tempnum -=$va['num'];
  1480. $va['th_num']+= $va['num'];
  1481. $va['num'] =0;
  1482. }
  1483. $stock['usable_stock']+=$tnm;
  1484. $stock['wait_out_stock'] -=$tnm;
  1485. $stock['updatetime'] = date("Y-m-d H:i:s");
  1486. $st_up = Db::name("good_stock")->save($stock);
  1487. if ($st_up == false) {
  1488. return error_show(1005, '可售商品入库失败');
  1489. }
  1490. $ps = GoodStockInfo::AddBn($va['stockid'],$va['bnCode'],$tnm);
  1491. if ($ps == false) {
  1492. return error_show(1005, '商品批次退货入库失败');
  1493. }
  1494. $ret = GoodStockInfo::ReturnBn($returnCode,$va['id'],$tnm);
  1495. if ($ret == false) {
  1496. return error_show(1005, '商品批次退货入库失败');
  1497. }
  1498. $va['updatetime']=date("Y-m-d H:i:s");
  1499. $sal= Db::name("sale_info")->save($va);
  1500. if ($sal == false) {
  1501. return error_show(1005, '商品批次退货入库失败');
  1502. }
  1503. $good_data[]= ['good_log_code' => $returnCode, "stock_id" => $va['stockid'], "type" => 1, 'stock' => $tnm, "stock_name" => "usable_stock"];
  1504. $good_data[]= ['good_log_code' => $returnCode, "stock_id" => $va['stockid'], "type" => 2, 'stock' => $tnm, "stock_name" => "wait_out_stock"];
  1505. GoodLog::LogAdd($this->post['token'], $good_data, 'XSTHD');
  1506. }
  1507. }
  1508. $data=[
  1509. "orderCode"=>$orderCode,
  1510. "th_type"=>1,
  1511. "th_num"=>$thnum,
  1512. "th_fee"=>round($order['sale_price']*$thnum,2),
  1513. "thCode"=>$returnCode,
  1514. "spuCode"=>$order['good_code'],
  1515. "good_name"=>$order['good_name'],
  1516. "cat_id"=>$order['cat_id'],
  1517. "apply_id"=>$this->uid,
  1518. "apply_name"=>$this->uname,
  1519. "addtime"=>date("Y-m-d H:i:s"),
  1520. "status"=>1,
  1521. "is_del"=>0
  1522. ];
  1523. $inse=Db::name("th_data")->insert($data);
  1524. if($inse==false){
  1525. Db::rollback();
  1526. return error_show(1004,"退货单更新失败");
  1527. }
  1528. }
  1529. Db::commit();
  1530. return app_show(0,"退货单新建成功",["returnCode"=>$returnCode]);
  1531. }
  1532. Db::rollback();
  1533. return error_show(1005,"退货单新建失败");
  1534. }catch (\Exception $e){
  1535. Db::rollback();
  1536. return error_show(1005, $e->getMessage());
  1537. }
  1538. }
  1539. }