Reorder.php 47 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\GoodLog;
  4. use app\admin\model\ProcessOrder;
  5. use think\facade\Db;
  6. use think\App;
  7. use app\admin\model\ActionLog;
  8. //销售单退货
  9. class Reorder extends \app\BaseController
  10. {
  11. public $post=[];
  12. public function __construct(App $app)
  13. {
  14. parent::__construct($app);
  15. $this->post =$this->request->post();
  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. $errorCode = isset($this->post['errorCode']) &&$this->post['errorCode']!=''?trim($this->post['errorCode']) :"";
  27. if($errorCode==''){
  28. return error_show(1004,"参数errorCode 不能为空");
  29. }
  30. $error =Db::name('result_info')->where(["result_code"=>$errorCode,"is_del"=>0])->find();
  31. if(empty($error)){
  32. return error_show(1005,"未找到退货原因数据");
  33. }
  34. $remark =isset($this->post['remark']) &&$this->post['remark']!=''?trim($this->post['remark']) :"";
  35. $thnum =isset($this->post['thnum']) &&$this->post['thnum']!=''?intval($this->post['thnum']) :"";
  36. $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):"";
  37. if($token==''){
  38. return error_show(105,"参数token不能为空");
  39. }
  40. $user =GetUserInfo($token);
  41. if(empty($user)||$user['code']!=0){
  42. return error_show(1002,"申请人数据不存在");
  43. }
  44. $is_addr=0;
  45. $rm= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  46. $ri= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  47. $returnadr =isset($this->post['returnAddr'])&& !empty($this->post['returnAddr']) ? $this->post['returnAddr']:"";
  48. if($returnadr!=''){
  49. $thnum=array_sum(array_column($returnadr,"return_num"));
  50. $is_addr=1;
  51. }
  52. $returnCode=makeNo("RS");
  53. Db::startTrans();
  54. try{
  55. $in = [
  56. "returnCode"=>$returnCode,
  57. "orderCode"=>$ordeCode,
  58. "good_code"=>$order['good_code'],
  59. "good_name"=>$order['good_name'],
  60. "apply_id"=>$rm,
  61. "apply_name"=>$ri,
  62. "error_code"=>$errorCode,
  63. "num"=>$thnum,
  64. "remark"=>$remark,
  65. "order_type"=>$order['order_type'],
  66. "is_addr"=>$is_addr,
  67. "status"=>$order['is_stock']==1?4:1,
  68. "is_del"=>0,
  69. "addtime"=>date("Y-m-d H:i:s"),
  70. "updatetime"=>date("Y-m-d H:i:s")
  71. ];
  72. $create = Db::name("sale_return")->insert($in,true);
  73. if($create>0){
  74. $stn = ["order_code"=>$returnCode,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  75. ActionLog::logAdd($this->post['token'],$stn,"QRTHD",0,$stn);
  76. $process=["order_code"=>$returnCode,"order_id"=>$create,"order_status"=>0,"order_type"=>'QRTHD'];
  77. ProcessOrder::AddProcess($this->post['token'],$process);
  78. if($returnadr!=""){
  79. $inf=[];
  80. foreach ($returnadr as $val){
  81. $temp=[];
  82. $addrinfo =Db::name("order_addr")->where(['id'=>$val['id'],"orderCode"=>$ordeCode])->find();
  83. if($addrinfo==false){
  84. Db::rollback();
  85. return error_show(1005,"地址信息未找到");
  86. }
  87. $send =Db::name('order_out')->where([["addrid","=",$val['id']],["status",">=",2]])->find();
  88. if($send!=false && $send['send_num']<$val['return_num']){
  89. Db::rollback();
  90. return error_show(1005,"地址已发货");
  91. }
  92. if($order['is_stock']==1){
  93. if ($addrinfo['receipt_quantity'] < $val['return_num']) {
  94. Db::rollback();
  95. return error_show(1004, "地址发货数量不足");
  96. }
  97. $addrinfo['receipt_quantity'] -= $val['return_num'];
  98. $addrinfo['is_del'] = $addrinfo['receipt_quantity'] <= 0 ? 1 : 0;
  99. $addrinfo['updatetime'] = date("Y-m-d H:i:s");
  100. $addrup = Db::name("order_addr")->save($addrinfo);
  101. if ($addrup == false) {
  102. Db::rollback();
  103. return error_show(1004, "地址发货数量更新失败");
  104. }
  105. $out = Db::name("order_out")->where(["addrid"=>$val['id']])->find();
  106. if ($out == false) {
  107. Db::rollback();
  108. return error_show(1004, "地址发货单数据未找到");
  109. }
  110. if ($send!=false) {
  111. if ($out['status'] >= 2) {
  112. Db::rollback();
  113. return error_show(1004, "地址发货单已发货");
  114. }
  115. if ($out['send_num'] < $val['return_num']) {
  116. Db::rollback();
  117. return error_show(1004, "地址发货单发货数量不足");
  118. }
  119. $out['send_num'] -= $val['return_num'];
  120. $out['is_del'] = $out['send_num'] <= 0 ? 1 : 0;
  121. $out['updatetime'] = date("Y-m-d H:i:s");
  122. $outup = Db::name("order_out")->save($out);
  123. if ($outup == false) {
  124. Db::rollback();
  125. return error_show(1004, "地址发货单更新失败");
  126. }
  127. $ordersend = Db::name("order_send")->where(["outCode" => $out['outCode']])->find();
  128. if ($ordersend['send_num'] < $val['return_num']) {
  129. Db::rollback();
  130. return error_show(1004, "发货单发货数量不足");
  131. }
  132. $ordersend['send_num'] -= $val['return_num'];
  133. $ordersend['status'] = $ordersend['send_num'] <= 0 ? 0 : 1;
  134. $ordersend['updatetime'] = date("Y-m-d H:i:s");
  135. $sendip = Db::name("order_send")->save($ordersend);
  136. if ($sendip == false) {
  137. Db::rollback();
  138. return error_show(1004, "发货单更新失败");
  139. }
  140. }
  141. }
  142. $temp['returnCode']=$returnCode;
  143. $temp['orderCode']=$ordeCode;
  144. $temp['outCode']=isset($send['outCode'])?$send['outCode']:"";
  145. $temp['addrid']=$val['id'];
  146. $temp['send_num']=$addrinfo['receipt_quantity'];
  147. $temp['return_num']=$val['return_num'];
  148. $temp['is_del']=0;
  149. $temp['addtime']=date("Y-m-d H:i:s");
  150. $temp['updatetime']=date("Y-m-d H:i:s");
  151. $inf[]=$temp;
  152. }
  153. $inadd=Db::name("sale_returnaddr")->insertAll($inf);
  154. if($inadd==0){
  155. Db::rollback();
  156. return error_show(1005,"退货单新建失败");
  157. }
  158. }
  159. if($order['is_stock']==1){
  160. if ($is_addr == 0) {
  161. if ($order['wsend_num'] < $order['num']) {
  162. Db::rollback();
  163. return error_show(1004, "销售单未发货数量不足退货");
  164. }
  165. $order['wsend_num'] -= $thnum;
  166. $order['send_num'] += $thnum;
  167. } else {
  168. if ($order['send_num'] < $thnum) {
  169. Db::rollback();
  170. return error_show(1004, "销售单已发货数量不足退货");
  171. }
  172. }
  173. $order['th_num'] += $thnum;
  174. $order['th_fee'] += round($thnum * $order['sale_price'], 2);
  175. $order['updatetime'] = date("Y-m-d H:i:s");
  176. $uap = Db::name("sale")->save($order);
  177. if ($uap == false) {
  178. Db::rollback();
  179. return error_show(1005, '销售单订单更新失败');
  180. }
  181. $ordernum = Db::name("order_num")->where(['orderCode' => $ordeCode])->find();
  182. if ($ordernum == false) {
  183. Db::rollback();
  184. return error_show(1005, '未找到关联采购单');
  185. }
  186. $ordernum['send_num'] -= $thnum;
  187. $orderup = Db::name("order_num")->save($ordernum);
  188. if ($orderup == false) {
  189. Db::rollback();
  190. return error_show(1005, '关联数据更新失败');
  191. }
  192. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  193. if ($cgd == false) {
  194. Db::rollback();
  195. return error_show(1005, '未找到采购单数据');
  196. }
  197. $cgd['th_fee'] += round($cgd['good_price'] * $thnum, 2);
  198. $cgd['th_num'] += $thnum;
  199. $cgd['updatetime'] = date("Y-m-d H:i:s");
  200. $cgdup = Db::name("purchease_order")->save($cgd);
  201. if ($cgdup == false) {
  202. Db::rollback();
  203. return error_show(1005, '采购单数据更新失败');
  204. }
  205. if ($cgd['bkcode'] != "") {
  206. $bk = Db::name("purchease_order")->where(["bkcode" => $cgd['bkcode'], "order_type" => 1, "is_del" => 0])
  207. ->find();
  208. if ($bk == false) {
  209. Db::rollback();
  210. return error_show(1005, '未找到备库单数据');
  211. }
  212. $orderbk = Db::name("order_bk")->where(['cgdNo' => $bk['cgdNo'], "is_del" => 0])->find();
  213. if ($orderbk == false) {
  214. Db::rollback();
  215. return error_show(1005, '备库单未完全入库');
  216. }
  217. $merge_num = Db::name("purchease_order")->where(["bkcode" => $bk['bkcode'], "order_type" => 5, "is_del" => 0])
  218. ->field("sum(send_num)-sum(th_num) as num")->find();
  219. $orderbk['balance_num'] = $orderbk['total_num'] - $merge_num['num'];
  220. $orderbk['merge_num'] = $merge_num['num'];
  221. $orderbk['updatetime'] = date("Y-m-d H:i:s");
  222. $orderbkup = Db::name("order_bk")->save($orderbk);
  223. if ($orderbkup == false) {
  224. Db::rollback();
  225. return error_show(1005, '备库单库存数据释放失败');
  226. }
  227. }
  228. $stock = Db::name("good_stock")->where(["spuCode" => $order['good_code'], 'wsm_code' => $cgd['wsm_code']])
  229. ->find();
  230. if (empty($stock)) {
  231. $stock = [
  232. "spuCode" => $order['good_code'],
  233. "wsm_code" => $cgd['wsm_code'],
  234. "usable_stock" => 0,
  235. "wait_out_stock" => 0,
  236. "wait_in_stock" => 0,
  237. "total_stock" => 0,
  238. "addtime" => date("Y-m-d H:i:s"),
  239. "updatetime" => date("Y-m-d H:i:s"),
  240. ];
  241. }
  242. $stock['usable_stock'] += $thnum;
  243. $stock['updatetime'] = date("Y-m-d H:i:s");
  244. $st_up = Db::name("good_stock")->save($stock);
  245. if ($st_up == false) {
  246. return error_show(1005, '可售商品入库失败');
  247. }
  248. $good_data = ['good_log_code' => $returnCode, "stock_id" => isset($stock['id']) ? $stock['id'] : Db::name("good_stock")->getLastInsID(), "type" => 1, 'stock' => $thnum, "stock_name" => "usable_stock"];
  249. GoodLog::LogAdd($this->post['token'], $good_data, 'XSTHD');
  250. }
  251. Db::commit();
  252. return app_show(0,"退货单新建成功",["returnCode"=>$returnCode]);
  253. }
  254. Db::rollback();
  255. return error_show(1005,"退货单新建失败");
  256. }catch (\Exception $e){
  257. Db::rollback();
  258. return error_show(1005,$e->getMessage());
  259. }
  260. }
  261. public function list(){
  262. $page = isset($this->post['page']) && $this->post['page'] !=="" ? intval($this->post['page']):"1";
  263. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']):"10";
  264. $where =[['is_del',"=",0]];
  265. $bkcode = isset($this->post['returnCode']) && $this->post['returnCode']!="" ? trim($this->post['returnCode']):"";
  266. if($bkcode!=""){
  267. $where[]=['returnCode',"like", "%{$bkcode}%"];
  268. }
  269. $status = isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):"";
  270. if($status!==""){
  271. $where[]=['status',"=", $status];
  272. }
  273. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode']!="" ? trim($this->post['orderCode'])
  274. :"";
  275. if($orderCode!=""){
  276. $where[]=['orderCode',"like", "%{$orderCode}%"];
  277. }
  278. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name']!="" ? trim($this->post['apply_name'])
  279. :"";
  280. if($apply_name!=""){
  281. $where[]=['apply_name',"like", "%{$apply_name}%"];
  282. }
  283. $start =isset($this->post['start'])&&$this->post['start']!='' ? $this->post['start']:"";
  284. if($start!==""){
  285. $where[]=['addtime',">=", $start];
  286. }
  287. $end =isset($this->post['end'])&&$this->post['end']!='' ? $this->post['end']:"";
  288. if($end!==""){
  289. $where[]=['addtime',"<=", $end];
  290. }
  291. $count=Db::name("sale_return")->where($where)->count();
  292. $total = ceil($count/$size);
  293. $page = $total>=$page ? $page :$total;
  294. $list = Db::name("sale_return")->where($where)->order("addtime desc")->page($page,$size)->select();
  295. // echo Db::name("sale_return")->getLastSql();
  296. $data=[];
  297. foreach ($list as $value){
  298. $value['error_msg']='';
  299. if($value['error_code']!=''){
  300. $error = Db::name("result_info")->where(["result_code"=>$value['error_code']])->find();
  301. $value['error_msg']= isset($error['result'])?$error['result']:"";
  302. }
  303. $order =Db::name("sale")->where(["orderCode"=>$value['orderCode'],"is_del"=>0])->find();
  304. $value['sale_price'] = isset($order['sale_price']) ?$order['sale_price']:0;
  305. $value['return_total'] =$value['sale_price']*$value['num'] ;
  306. $value['total_num'] =$order['good_num'] ;
  307. $data[]=$value ;
  308. }
  309. return app_show(0,"获取成功",['list'=>$data,"count"=>$count]);
  310. }
  311. public function info(){
  312. $code = isset($this->post['returnCode']) && $this->post['returnCode'] !=="" ? trim($this->post['returnCode'])
  313. :"";
  314. if($code==""){
  315. return error_show(1004,"参数returnCode不能为空");
  316. }
  317. $info = Db::name("sale_return")->where(["returnCode"=>$code,"is_del"=>0])->find();
  318. if(empty($info)){
  319. return error_show(1004,"未找到退货数据");
  320. }
  321. $orderinfo = Db::name("sale")->where(["orderCode"=>$info["orderCode"]])->find();
  322. if($orderinfo['order_type']==3|| $orderinfo['order_type']==4){
  323. $goon = Db::name("good_zixun")->where(["spuCode"=>$orderinfo['good_code'],"is_del"=>0])->find();
  324. }else {
  325. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  326. ->where(['a.skuCode' => $orderinfo['skuCode']])->find();
  327. }
  328. if ($goon==false) {
  329. return error_show(1003, "未找到商品数据");
  330. }
  331. $int = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
  332. $info['is_stock']=isset($goon['is_stock'])?$goon['is_stock']:'0';
  333. $info['good_code'] = isset($orderinfo['good_code'])?$orderinfo['good_code']:'';
  334. $info['send_type'] = isset($orderinfo['send_type'])?$orderinfo['send_type']:'';
  335. $info['skuCode'] = isset($orderinfo['skuCode'])?$orderinfo['skuCode']:'';
  336. $info['good_name'] = isset($orderinfo['good_name'])?$orderinfo['good_name']:'';
  337. $info['good_num'] = isset($orderinfo['good_num'])?$orderinfo['good_num']:'';
  338. $info['sale_price'] = isset($orderinfo['sale_price'])?$orderinfo['sale_price']:'0';
  339. $info['origin_price'] = isset($orderinfo['origin_price'])?$orderinfo['origin_price']:'0';
  340. $info['return_total'] = $info['sale_price']*$info['num'] ;
  341. $info['send_num'] = isset($orderinfo['send_num'])?$orderinfo['send_num']:'0';
  342. $info['wsend_num'] = isset($orderinfo['wsend_num'])?$orderinfo['wsend_num']:'0';
  343. $info['send_status'] = isset($orderinfo['send_status'])?$orderinfo['send_status']:'';
  344. $info['total_price'] = isset($orderinfo['total_price'])?$orderinfo['total_price']:'0';
  345. $info['post_fee'] = isset($orderinfo['post_fee'])?$orderinfo['post_fee']:'0';
  346. $info['customer_code'] = isset($orderinfo['customer_code'])?$orderinfo['customer_code']:'';
  347. $info['customer_name']='';
  348. if(isset($orderinfo['customer_code'])&&$orderinfo['customer_code']!=''){
  349. $customerinfo = Db::name("customer_info")->where(['companyNo'=>$orderinfo['customer_code']])->find();
  350. $info['customer_name'] = isset($customerinfo['companyName']) ? $customerinfo['companyName']:"";
  351. }
  352. $info['supplierNo'] = isset($orderinfo['supplierNo'])?$orderinfo['supplierNo']:'';
  353. $info['supplier_name']='';
  354. if(isset($orderinfo['supplierNo'])&&$orderinfo['supplierNo']!=''){
  355. $customerinfo = Db::name("business")->where(['companyNo'=>$orderinfo['supplierNo']])->find();
  356. $info['supplier_name'] = isset($customerinfo['company']) ? $customerinfo['company']:"";
  357. }
  358. $info['platform_name']='';
  359. $info['platform_id']=$orderinfo['platform_id'];
  360. if($orderinfo['platform_id']!=0){
  361. $plat=Db::name("platform")->where(['id'=>$orderinfo['platform_id']])->find();
  362. $info['platform_name']=isset($plat['platform_name'])?$plat['platform_name']:"";
  363. }
  364. $info['cgd_wsend']="";
  365. $info['cgd_send']="";
  366. $info['cgd_total']="";
  367. if($orderinfo['order_type']==2){
  368. $cgd = Db::name("purchease_order")->where(["bkcode"=>$info["orderCode"],"order_type"=>2])->find();
  369. $info['cgd_wsend'] = isset($cgd['wsend_num']) ? $cgd['wsend_num']:0;
  370. $info['cgd_send'] = isset($cgd['send_num']) ? $cgd['send_num']:0;
  371. $info['cgd_total'] = isset($cgd['good_num']) ? $cgd['good_num']:0;
  372. }
  373. $info['error_msg']='';
  374. if($info['error_code']!=''){
  375. $error = Db::name("result_info")->where(["result_code"=>$info['error_code']])->find();
  376. $info['error_msg']= isset($error['result'])?$error['result']:"";
  377. }
  378. if($info['return_wsm']!=""){
  379. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  380. ->where(["a.wsm_code"=>$info['return_wsm']])->field("a.name as wsm_name,b.name,b.code")->find();
  381. }
  382. $info['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  383. // $info['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  384. // $info['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  385. $wsm_return = Db::name("sale_returninfo")->where(["returnCode"=>$info["returnCode"],"is_del"=>0])->select()->toArray();
  386. $wsm=[];
  387. if(!empty($wsm_return)){
  388. foreach ($wsm_return as $value){
  389. $value['wsm_name']="";
  390. $value['wsm_supplier']="";
  391. $value['wsm_supplierNo']="";
  392. if($value['wsm_code']!=""){
  393. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b","a.supplierNo=b.code")
  394. ->where(["a.wsm_code"=>$value['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find();
  395. $value['wsm_name'] =isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name']:"";
  396. $value['wsm_supplier'] =isset($wsmcode['name']) ? $wsmcode['name']:"";
  397. $value['wsm_supplierNo'] =isset($wsmcode['code']) ? $wsmcode['code']:"";
  398. }
  399. $orderwsm = Db::name("sale_info")->where(["orderCode"=>$info["orderCode"],"wsm_code"=>$value["wsm_code"]])->find();
  400. $value["wsm_total"] = isset($orderwsm["num"]) ? $orderwsm["num"]:0;
  401. $send = Db::name("order_out")->where(["wsm_code" => $value['wsm_code'], 'orderCode' => $info['orderCode']])->sum("send_num");
  402. $value['wsm_send'] = $send ?? 0;
  403. $value['wsm_wsend'] = $value['wsm_total'] - $value['wsm_send'];
  404. $wsm[]=$value;
  405. }
  406. }
  407. $info['wsminfo']=$wsm;
  408. $addr =Db::name("sale_returnaddr")->where(["returnCode"=>$info["returnCode"],"is_del"=>0])->select()->toArray();
  409. $addrinfo=[];
  410. if(!empty($addr)){
  411. foreach ( $addr as $value){
  412. $addrlist = Db::name("order_addr")->where(["id"=>$value["addrid"]])->find();
  413. $value['addr']=isset($addrlist['addr'])?$addrlist['addr']:"";
  414. $value['addr_code']=isset($addrlist['addr_code'])?$addrlist['addr_code']:"";
  415. $value['contactor']=isset($addrlist['contactor'])?$addrlist['contactor']:"";
  416. $value['mobile']=isset($addrlist['mobile'])?$addrlist['mobile']:"";
  417. $value['post_fee']=isset($addrlist['post_fee'])?$addrlist['post_fee']:"";
  418. $value['addive_time']=isset($addrlist['addive_time'])?$addrlist['addive_time']:"";
  419. $value['customer_code']=isset($addrlist['customer_code']) ?$addrlist['customer_code']:"" ;
  420. $value['receipt_quantity']=isset($addrlist['receipt_quantity']) ?$addrlist['receipt_quantity']:"" ;
  421. $send = Db::name("order_out")->where(['addrid' => $addrlist['id'], 'orderCode' => $addrlist['orderCode']])->sum("send_num");
  422. $value['addr_send'] = $send ?? 0;
  423. $value['addr_wsend'] = $value['receipt_quantity'] - $value['addr_send'];
  424. $customer = Db::name("customer_info")->where(['companyNo'=>$addrlist['customer_code']])->find();
  425. $value['customer_name'] = isset($customer['companyName']) ? $customer['companyName']:"";
  426. $addrinfo[]=$value;
  427. }
  428. }
  429. $info['addrinfo']=$addrinfo;
  430. $info['can']=$int;
  431. return app_show(0,"获取成功",$info);
  432. }
  433. /**
  434. * @return \think\response\Json|void
  435. * @throws \think\db\exception\DataNotFoundException
  436. * @throws \think\db\exception\DbException
  437. * @throws \think\db\exception\ModelNotFoundException
  438. */
  439. public function delete(){
  440. $code = isset($this->post['returnCode']) && $this->post['returnCode'] !=="" ? trim($this->post['returnCode'])
  441. :"";
  442. if($code==""){
  443. return error_show(1004,"参数returnCode不能为空");
  444. }
  445. $info = Db::name("sale_return")->where(["returnCode"=>$code,"is_del"=>0])->find();
  446. if(empty($info)){
  447. return error_show(1004,"未找到退货数据");
  448. }
  449. $info["is_del"]=1;
  450. $info["updatetime"]=date("Y-m-d H:i:s");
  451. $del = Db::name("sale_return")->save($info);
  452. if($del){
  453. $ste = ["order_code"=>$code,"status"=>0,"action_remark"=>'',"action_type"=>"delete"];
  454. ActionLog::logAdd($this->post['token'],$ste,$info['order_type'] == 2?"ZXTHD":"QRTHD",0,$ste);
  455. $process=["order_code"=>$code,"order_id"=>$info['id'],"order_status"=>0,"order_type"=>$info['order_type'] == 2?"ZXTHD":"QRTHD"];
  456. ProcessOrder::workdel($process);
  457. return app_show(0,"删除成功");
  458. }else{
  459. return error_show(1004,"删除失败");
  460. }
  461. }
  462. /**审核
  463. * @return \think\response\Json|void
  464. * @throws \think\db\exception\DataNotFoundException
  465. * @throws \think\db\exception\DbException
  466. * @throws \think\db\exception\ModelNotFoundException
  467. */
  468. public function exam(){
  469. $code = isset($this->post['returnCode']) && $this->post['returnCode'] !=="" ? trim($this->post['returnCode'])
  470. :"";
  471. if($code==""){
  472. return error_show(1004,"参数returnCode不能为空");
  473. }
  474. $info = Db::name("sale_return")->where(["returnCode"=>$code,"is_del"=>0])->find();
  475. if(empty($info)){
  476. return error_show(1004,"未找到退货数据");
  477. }
  478. $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status'])
  479. :"";
  480. if($status===""){
  481. return error_show(1004,"参数status不能为空");
  482. }
  483. $remark = isset($this->post['remark']) && $this->post['remark'] !="" ? trim($this->post['remark']) :"";
  484. $var = $info['status'];
  485. $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):"";
  486. $apply_id =GetUserInfo($token);
  487. if(empty($apply_id)||$apply_id['code']!=0){
  488. return error_show(1002,"申请人数据不存在");
  489. }
  490. $rid= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  491. $rname= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  492. $orderinfo = Db::name("sale")->where(["orderCode"=>$info["orderCode"]])->find();
  493. if($orderinfo==false){
  494. return error_show(1004,"未找到订单数据");
  495. }
  496. if($status==4){
  497. if($info['is_addr']==1){
  498. $addr=Db::name("sale_returnaddr")->where(['returnCode'=>$info['returnCode'],"is_del"=>0])->select()
  499. ->toArray();
  500. if(empty($addr)){
  501. return error_show(1004,"未找到发货单地址数据");
  502. }
  503. }
  504. }
  505. if($status==3){
  506. $is_th =isset($this->post['is_th'])&&$this->post['is_th']!=="" ? intval($this->post['is_th']):"";
  507. if($is_th===""){
  508. return error_show(1004,"参数is_th不能为空");
  509. }
  510. $return_wsm =isset($this->post['return_wsm'])&&$this->post['return_wsm']!=="" ? trim($this->post['return_wsm']):"";
  511. if($return_wsm===""){
  512. return error_show(1004,"参数return_wsm 不能为空");
  513. }
  514. $wsmcode = Db::name("warehouse_info")->where(['wsm_code'=>$return_wsm])->find();
  515. if($wsmcode==false){
  516. return error_show(1004,"为找到仓库数据");
  517. }
  518. $info['return_wsm'] =$return_wsm ;
  519. $info['is_th'] =$is_th ;
  520. }
  521. Db::startTrans();
  522. try{
  523. $temp= $info['status'];
  524. $info['status'] =$status;
  525. $remark!=""? $info['remark'] =$remark:"";
  526. $info["updatetime"]=date("Y-m-d H:i:s");
  527. $up = Db::name("sale_return")->save($info);
  528. if($up) {
  529. $process = ["order_code" => $code, "order_id" => $info['id'], "order_status" => $status, "order_type" => $info['order_type'] == 2 ? "ZXTHD" : "QRTHD"];
  530. ProcessOrder::AddProcess($this->post['token'], $process);
  531. $ste = ["order_code" => $code, "status" => $temp, "action_remark" => '', "action_type" => "status"];
  532. ActionLog::logAdd($this->post['token'], $ste, $info['order_type'] == 2 ? "ZXTHD" : "QRTHD", $status, $info);
  533. if ($status == 4) {
  534. if ($info['is_addr'] == 1) {
  535. if (isset($addr) && !empty($addr)) {
  536. foreach ($addr as $value) {
  537. $addrinfo = Db::name("order_addr")->where(['id' => $value['addrid'], "is_del" => 0])->find();
  538. if ($addrinfo == false) {
  539. Db::rollback();
  540. return error_show(1004, "地址数据未找到");
  541. }
  542. if ($addrinfo['receipt_quantity'] < $value['return_num']) {
  543. Db::rollback();
  544. return error_show(1004, "地址发货数量不足");
  545. }
  546. $addrinfo['receipt_quantity'] -= $value['return_num'];
  547. $addrinfo['is_del'] = $addrinfo['receipt_quantity'] <= 0 ? 1 : 0;
  548. $addrinfo['updatetime'] = date("Y-m-d H:i:s");
  549. $addrup = Db::name("order_addr")->save($addrinfo);
  550. if ($addrup == false) {
  551. Db::rollback();
  552. return error_show(1004, "地址发货数量更新失败");
  553. }
  554. if ($value['outCode'] != "") {
  555. $out = Db::name("order_out")->where(["outCode" => $value['outCode'], "is_del" => 0])
  556. ->find();
  557. if ($out == false) {
  558. Db::rollback();
  559. return error_show(1004, "地址发货单数据未找到");
  560. }
  561. if ($out['status'] >= 2) {
  562. Db::rollback();
  563. return error_show(1004, "地址发货单已发货");
  564. }
  565. if ($out['send_num'] < $value['return_num']) {
  566. Db::rollback();
  567. return error_show(1004, "地址发货单发货数量不足");
  568. }
  569. $out['send_num'] -= $value['return_num'];
  570. $out['is_del'] = $out['send_num'] <= 0 ? 1 : 0;
  571. $out['updatetime'] = date("Y-m-d H:i:s");
  572. $outup = Db::name("order_out")->save($out);
  573. if ($outup == false) {
  574. Db::rollback();
  575. return error_show(1004, "地址发货单更新失败");
  576. }
  577. $ordersend = Db::name("order_send")->where(["outCode" => $value['outCode']])->find();
  578. if ($ordersend['send_num'] < $value['return_num']) {
  579. Db::rollback();
  580. return error_show(1004, "发货单发货数量不足");
  581. }
  582. $ordersend['send_num'] -= $value['return_num'];
  583. $ordersend['status'] = $ordersend['send_num'] <= 0 ? 0 : 1;
  584. $ordersend['updatetime'] = date("Y-m-d H:i:s");
  585. $sendip = Db::name("order_send")->save($ordersend);
  586. if ($sendip == false) {
  587. Db::rollback();
  588. return error_show(1004, "发货单更新失败");
  589. }
  590. }
  591. }
  592. }
  593. }
  594. if ($info['is_addr'] == 0) {
  595. if ($orderinfo['wsend_num'] < $info['num']) {
  596. Db::rollback();
  597. return error_show(1004, "销售单未发货数量不足退货");
  598. }
  599. $orderinfo['wsend_num'] -= $info['num'];
  600. $orderinfo['send_num'] += $info['num'];
  601. } else {
  602. if ($orderinfo['send_num'] < $info['num']) {
  603. Db::rollback();
  604. return error_show(1004, "销售单已发货数量不足退货");
  605. }
  606. }
  607. if ($orderinfo['is_stock'] == 1) {
  608. $orderinfo['th_num'] += $info['num'];
  609. $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
  610. $orderinfo['updatetime'] = date("Y-m-d H:i:s");
  611. $uap = Db::name("sale")->save($orderinfo);
  612. if ($uap == false) {
  613. Db::rollback();
  614. return error_show(1005, '销售单订单更新失败');
  615. }
  616. $ordernum = Db::name("order_num")->where(['orderCode' => $info['orderCode']])->find();
  617. if ($ordernum == false) {
  618. Db::rollback();
  619. return error_show(1005, '未找到关联采购单');
  620. }
  621. $ordernum['send_num'] -= $info['num'];
  622. $orderup = Db::name("order_num")->save($ordernum);
  623. if ($orderup == false) {
  624. Db::rollback();
  625. return error_show(1005, '关联数据更新失败');
  626. }
  627. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  628. if ($cgd == false) {
  629. Db::rollback();
  630. return error_show(1005, '未找到采购单数据');
  631. }
  632. $cgd['th_fee'] += round($cgd['good_price'] * $info['num'], 2);
  633. $cgd['th_num'] += $info['num'];
  634. $cgd['updatetime'] = date("Y-m-d H:i:s");
  635. $cgdup = Db::name("purchease_order")->save($cgd);
  636. if ($cgdup == false) {
  637. Db::rollback();
  638. return error_show(1005, '采购单数据更新失败');
  639. }
  640. if ($cgd['bkcode'] != "") {
  641. $bk = Db::name("purchease_order")->where(["bkcode" => $cgd['bkcode'], "order_type" => 1, "is_del" => 0])
  642. ->find();
  643. if ($bk == false) {
  644. Db::rollback();
  645. return error_show(1005, '未找到备库单数据');
  646. }
  647. $orderbk = Db::name("order_bk")->where(['cgdNo' => $bk['cgdNo'], "is_del" => 0])->find();
  648. if ($orderbk == false) {
  649. Db::rollback();
  650. return error_show(1005, '备库单未完全入库');
  651. }
  652. $merge_num = Db::name("purchease_order")->where(["bkcode" => $bk['bkcode'], "order_type" => 5, "is_del" => 0])
  653. ->field("sum(send_num)-sum(th_num) as num")->find();
  654. $orderbk['balance_num'] = $orderbk['total_num'] - $merge_num['num'];
  655. $orderbk['merge_num'] = $merge_num['num'];
  656. $orderbk['updatetime'] = date("Y-m-d H:i:s");
  657. $orderbkup = Db::name("order_bk")->save($orderbk);
  658. if ($orderbkup == false) {
  659. Db::rollback();
  660. return error_show(1005, '备库单库存数据释放失败');
  661. }
  662. }
  663. } else {
  664. if ($info['is_th'] == 1) {
  665. $orderinfo['th_num'] += $info['num'];
  666. $orderinfo['th_fee'] += round($info['return_num'] * $orderinfo['sale_price'], 2);
  667. $orderinfo['updatetime'] = date("Y-m-d H:i:s");
  668. $uap = Db::name("sale")->save($orderinfo);
  669. if ($uap == false) {
  670. Db::rollback();
  671. return error_show(1005, '销售单订单更新失败');
  672. }
  673. $ordernum = Db::name("order_num")->where(['orderCode' => $orderinfo['orderCode']])->find();
  674. if ($ordernum == false) {
  675. Db::rollback();
  676. return error_show(1005, '未找到关联采购单');
  677. }
  678. $ordernum['send_num'] -= $info['num'];
  679. $orderup = Db::name("order_num")->save($ordernum);
  680. if ($orderup == false) {
  681. Db::rollback();
  682. return error_show(1005, '关联数据更新失败');
  683. }
  684. $cgd = Db::name("purchease_order")->where(["cgdNo" => $ordernum['cgdNo'], "is_del" => 0])->find();
  685. if ($cgd == false) {
  686. Db::rollback();
  687. return error_show(1005, '未找到采购单数据');
  688. }
  689. $cgd['th_num'] += $info['num'];
  690. $cgd['th_fee'] += round($info['num'] * $cgd['good_price'], 2);
  691. $cgd['updatetime'] = date("Y-m-d H:i:s");
  692. $cgdup = Db::name("purchease_order")->save($cgd);
  693. if ($cgdup == false) {
  694. Db::rollback();
  695. return error_show(1005, '采购单数据更新失败');
  696. }
  697. } else {
  698. $orderinfo['th_num'] += $info['num'];
  699. $orderinfo['th_fee'] += round($info['num'] * $orderinfo['sale_price'], 2);
  700. $orderinfo['updatetime'] = date("Y-m-d H:i:s");
  701. $uap = Db::name("sale")->save($orderinfo);
  702. if ($uap == false) {
  703. Db::rollback();
  704. return error_show(1005, '销售单订单更新失败');
  705. }
  706. $ordernum = Db::name("order_num")->where(['orderCode' => $orderinfo['orderCode']])->find();
  707. if ($ordernum == false) {
  708. Db::rollback();
  709. return error_show(1005, '未找到关联采购单');
  710. }
  711. $ordernum['send_num'] -= $info['num'];
  712. $ordernum['wsend_num'] = $info['return_num'];
  713. $orderup = Db::name("order_num")->save($ordernum);
  714. if ($orderup == false) {
  715. Db::rollback();
  716. return error_show(1005, '关联数据更新失败');
  717. }
  718. }
  719. }
  720. $wsmcode = $orderinfo['is_stock'] == 1 ? $cgd['wsm_code'] : $info['return_wsm'];
  721. if ($wsmcode == "") {
  722. Db::rollback();
  723. return error_show(1005, '未找到退货仓库');
  724. }
  725. $stock = Db::name("good_stock")->where(["spuCode" => $info['good_code'], 'wsm_code' => $wsmcode])->find();
  726. if (empty($stock)) {
  727. $stock = [
  728. "spuCode" => $info['good_code'],
  729. "wsm_code" => $wsmcode,
  730. "usable_stock" => 0,
  731. "wait_out_stock" => 0,
  732. "wait_in_stock" => 0,
  733. "total_stock" => 0,
  734. "addtime" => date("Y-m-d H:i:s"),
  735. "updatetime" => date("Y-m-d H:i:s"),
  736. ];
  737. }
  738. $stock['usable_stock'] += $info['num'];
  739. $stock['updatetime'] = date("Y-m-d H:i:s");
  740. $st_up = Db::name("good_stock")->save($stock);
  741. if ($st_up == false) {
  742. return error_show(1005, '可售商品入库失败');
  743. }
  744. $good_data = ['good_log_code' => $info['returnCode'], "stock_id" => isset($stock['id']) ?
  745. $stock['id'] : Db::name
  746. ("good_stock")->getLastInsID(), "type" => 1, 'stock' => $info['num'], "stock_name" => "usable_stock"];
  747. GoodLog::LogAdd($this->post['token'], $good_data, 'QRTHD');
  748. }
  749. }
  750. Db::commit();
  751. return app_show(0,"更新成功");
  752. }catch (\Exception $e){
  753. Db::rollback();
  754. return error_show(1004,"更新失败");
  755. }
  756. }
  757. public function zxcreate(){
  758. $ordeCode = isset($this->post['orderCode']) &&$this->post['orderCode']!=''?trim($this->post['orderCode']) :"";
  759. if($ordeCode==''){
  760. return error_show(1004,"参数orderCode 不能为空");
  761. }
  762. $order= Db::name("sale")->where(["orderCode"=>$ordeCode,"is_del"=>0])->find();
  763. if(empty($order)){
  764. return error_show(1005,"未找到订单数据");
  765. }
  766. $errorCode = isset($this->post['errorCode']) &&$this->post['errorCode']!=''?trim($this->post['errorCode']) :"";
  767. if($errorCode==''){
  768. return error_show(1004,"参数errorCode 不能为空");
  769. }
  770. $error =Db::name('result_info')->where(["result_code"=>$errorCode,"is_del"=>0])->find();
  771. if(empty($error)){
  772. return error_show(1005,"未找到退货原因数据");
  773. }
  774. $remark =isset($this->post['remark']) &&$this->post['remark']!=''?trim($this->post['remark']) :"";
  775. $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):"";
  776. if($token==''){
  777. return error_show(105,"参数token不能为空");
  778. }
  779. $user =GetUserInfo($token);
  780. if(empty($user)||$user['code']!=0){
  781. return error_show(1002,"申请人数据不存在");
  782. }
  783. $rm= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  784. $ri= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  785. $num = isset($this->post['num'])&&$this->post['num']!='' ? intval($this->post['num']):"";
  786. if($num==''){
  787. return error_show(1005,"参数num不能为空");
  788. }
  789. if($order['wsend_num']<$num){
  790. return error_show(1002,"仓库未发货数量不足退货");
  791. }
  792. $returnCode=makeNo("RS");
  793. Db::startTrans();
  794. try{
  795. $in = [
  796. "returnCode"=>$returnCode,
  797. "orderCode"=>$ordeCode,
  798. "good_code"=>$order['good_code'],
  799. "good_name"=>$order['good_name'],
  800. "apply_id"=>$rm,
  801. "apply_name"=>$ri,
  802. "error_code"=>$errorCode,
  803. "num"=>$num,
  804. "remark"=>$remark,
  805. "order_type"=>2,
  806. "status"=>0,
  807. "is_del"=>0,
  808. "addtime"=>date("Y-m-d H:i:s"),
  809. "updatetime"=>date("Y-m-d H:i:s")
  810. ];
  811. $create = Db::name("sale_return")->insert($in,true);
  812. if($create>0) {
  813. $process=["order_code"=>$returnCode,"order_id"=>$create,"order_status"=>0,"order_type"=>'ZXTHD'];
  814. ProcessOrder::AddProcess($this->post['token'],$process);
  815. $ste = ["order_code"=>$returnCode,"status"=>0,"action_remark"=>'',
  816. "action_type"=>"create"];
  817. ActionLog::logAdd($this->post['token'],$ste,"ZXTHD",3,$in);
  818. if ($order['send_type'] == 1) {
  819. $wsend = Db::name("order_out")->where(['orderCode' => $ordeCode, "status" => 1, "order_type"
  820. =>2])->select();
  821. // ->save(["status" => 0, "updatetime" => date("Y-m-d H:i:s")]);
  822. if(!empty($wsend)){
  823. foreach ($wsend as $value){
  824. $tt = $value['status'];
  825. $value['status']=0;
  826. $value['updatetime']=date("Y-m-d H:i:s");
  827. $up =Db::name("order_out")->save($value);
  828. if($up){
  829. $process=["order_code"=> $value['outCode'],"order_id"=>$value['id'],"order_status"=>0,"order_type"=>'CKD'];
  830. ProcessOrder::AddProcess($this->post['token'],$process);
  831. $ste = ["order_code"=>$value['outCode'],"status"=>$tt,"action_remark"=>'',"action_type"=>"status"];
  832. ActionLog::logAdd($this->post['token'],$ste,"CKD",0,$value);
  833. }else{
  834. Db::rollback();
  835. return error_show(1005,"退货单新建失败");
  836. }
  837. }
  838. }
  839. }
  840. Db::commit();
  841. return error_show(0,"退货单新建成功");
  842. }
  843. Db::rollback();
  844. return error_show(1005,"退货单新建失败");
  845. }catch (\Exception $e){
  846. Db::rollback();
  847. return error_show(1005,$e->getMessage());
  848. }
  849. }
  850. }