Sale.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513
  1. <?php
  2. namespace app\abutment\controller;
  3. use app\admin\model\ActionLog;
  4. use app\admin\model\GoodLog;
  5. use app\admin\model\ProcessOrder;
  6. use app\BaseController;
  7. use Exception;
  8. use think\facade\Cache;
  9. use think\facade\Db;
  10. class Sale extends BaseController
  11. {
  12. //发货单列表
  13. public function saleout()
  14. {
  15. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
  16. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
  17. $where = [["a.is_del", "=", 0], ['wpo.supplierNo', '=', $this->request->user['supplierNo']]];
  18. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !== "" ? trim($this->post['orderCode']) : "";
  19. if ($orderCode !== "") {
  20. $where[] = ['a.orderCode', "like", "%$orderCode%"];
  21. }
  22. $order_type = isset($this->post['order_type']) && $this->post['order_type'] !== "" ? trim($this->post['order_type']) : "";
  23. if ($order_type !== "") {
  24. $where[] = ['a.order_type', "=", $order_type];
  25. }
  26. $outCode = isset($this->post['outCode']) && $this->post['outCode'] !== "" ? trim($this->post['outCode']) : "";
  27. if ($outCode !== "") {
  28. $where[] = ['a.outCode', "like", "%$outCode%"];
  29. }
  30. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !== "" ? trim($this->post['apply_name']) : "";
  31. if ($apply_name !== "") {
  32. $where[] = ['a.apply_name', "like", "%$apply_name%"];
  33. }
  34. $good_code = isset($this->post['good_code']) && $this->post['good_code'] !== "" ? trim($this->post['good_code']) : "";
  35. if ($good_code !== "") {
  36. $where[] = ['b.good_code', "like", "%$good_code%"];
  37. }
  38. $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name']) : "";
  39. if ($good_name !== "") {
  40. $where[] = ['b.good_name', "like", "%$good_name%"];
  41. }
  42. $status = isset($this->post['status']) && $this->post['status'] !== "" ? trim($this->post['status']) : "";
  43. if ($status !== "") {
  44. $where[] = ['a.status', "=", $status];
  45. }
  46. $start = isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start'] : "";
  47. if ($start != "") {
  48. $where[] = ["a.addtime", '>=', $start];
  49. }
  50. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] : "";
  51. if ($end != "") {
  52. $where[] = ["a.addtime", '<=', $end];
  53. }
  54. $companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !== "" ? trim($this->post['companyNo']) : "";
  55. if ($companyNo != "") {
  56. $where[] = ['b.customer_code', "like", "%$companyNo%"];
  57. }
  58. $cgdNo = isset($this->post['cgdNo']) && $this->post['cgdNo'] !== "" ? $this->post['cgdNo'] : "";
  59. if ($cgdNo != "") {
  60. $where[] = ["os.cgdNo", 'like', '%' . $cgdNo . '%'];
  61. }
  62. $role = $this->checkRole();
  63. $condition = '';
  64. if (!empty($role['write']) && $this->uid != "") {
  65. // $where[]=["a.apply_id","in",$role['write']];
  66. $condition .= " (b.is_stock=1 and n.contactor = {$this->uid}) or (b.is_stock=0 and wpo.cgder_id = {$this->uid}) or a.apply_id in (" . implode(',',
  67. $role['write']) . ")";
  68. }
  69. // if(!empty($role['platform']) ){
  70. // $where[]=["b.platform_id","in",$role['platform']];
  71. // }
  72. $company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
  73. if ($company_name !== "") $where[] = ["a.apply_id", 'in', get_company_item_user_by_name($company_name)];
  74. //发货时间筛选
  75. $start_sendtime = isset($this->post['start_sendtime']) && $this->post['start_sendtime'] !== "" ? $this->post['start_sendtime'] : "";
  76. $end_sendtime = isset($this->post['end_sendtime']) && $this->post['end_sendtime'] !== "" ? $this->post['end_sendtime'] : "";
  77. if ($start_sendtime != "" && $end_sendtime != "") {
  78. $where[] = ["a.sendtime", 'between', [$start_sendtime . " 00:00:00", $end_sendtime . " 223:59:59"]];
  79. $where[] = ["a.status", '>=', 2];//搜索发货时间时,要指定状态为已发货及之后的状态值(0待发货,1待库管发货,2已发货待收货,3已收货,4已全部退货',)
  80. }
  81. $count = Db::name('order_out')
  82. ->alias('a')
  83. ->join("sale b", "b.orderCode=a.orderCode", "left")
  84. ->join("customer_info v", "v.companyNo=b.customer_code", "left")
  85. ->join("warehouse_info n", "n.wsm_code=a.wsm_code", "left")
  86. ->leftJoin("depart_user u", "u.uid=a.apply_id AND u.is_del=0")
  87. ->leftJoin("order_send os", "os.outCode=a.outCode")
  88. ->leftJoin("purchease_order wpo", "wpo.cgdNo=os.cgdNo")
  89. ->where($where)
  90. ->where($condition)
  91. ->count();
  92. $total = ceil($count / $size);
  93. $page = $page >= $total ? $total : $page;
  94. $list = Db::name('order_out')
  95. ->alias('a')
  96. ->join("sale b", "b.orderCode=a.orderCode", "left")
  97. ->join("customer_info v", "v.companyNo=b.customer_code", "left")
  98. ->join("warehouse_info n", "n.wsm_code=a.wsm_code AND n.is_del=0", "left")
  99. ->leftJoin("order_send os", "os.outCode=a.outCode")
  100. ->leftJoin("purchease_order wpo", "wpo.cgdNo=os.cgdNo")
  101. ->leftJoin("depart_user u", "u.uid=a.apply_id AND u.is_del=0")
  102. ->field("a.*,b.order_type,b.order_source,b.good_name,b.good_code,b.skuCode,b.supplierNo,b.customer_code,v.companyName,b.origin_price,b.sale_price,b.total_price,os.cgdNo,u.itemid")
  103. ->where($where)
  104. ->where($condition)
  105. ->order("addtime desc")
  106. ->page($page, $size)
  107. ->cursor();
  108. $data = [];
  109. foreach ($list as $value) {
  110. $wsmcode = Db::name("warehouse_info")->alias("k")->leftJoin("supplier c", "k.supplierNo=c.code")
  111. ->where(["k.wsm_code" => $value['wsm_code']])->field("k.name as wsm_name,c.name,c.code")->find();
  112. $addr = Db::name("order_addr")->where(["id" => $value['addrid']])->find();
  113. if ($addr) {
  114. $addinfo = $addr['addr_code'] != '' ? json_decode($addr['addr_code'], true) ?? $addr['addr_code'] : '';
  115. if (is_string($addinfo) && $addinfo != '') {
  116. $addinfo = ["provice_code" => '', "city_code" => '', "area_code" => ''];
  117. list($addinfo['provice_code'], $addinfo['city_code'], $addinfo['area_code']) = explode(",", $addr['addr_code']);
  118. }
  119. $addr['addr_cn'] = GetAddr(json_encode($addinfo));
  120. }
  121. if ($value['order_type'] == 3) {
  122. $goon = Db::name("good_zixun")->field('id,cat_id')->where(["spuCode" => $value['good_code'], "is_del" => 0])->find();
  123. } else {
  124. $goon = Db::name('good_platform')->field('a.id,b.cat_id')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')->where(['a.skuCode' => $value['skuCode']])->find();
  125. }
  126. $value['wsm_name'] = isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name'] : "";
  127. $value['wsm_supplier'] = isset($wsmcode['name']) ? $wsmcode['name'] : "";
  128. $value['wsm_supplierNo'] = isset($wsmcode['code']) ? $wsmcode['code'] : "";
  129. $value['addr'] = isset($addr['addr']) ? $addr['addr_cn'] . $addr['addr'] : "";
  130. $value['contactor'] = isset($addr['contactor']) ? $addr['contactor'] : "";
  131. $value['mobile'] = isset($addr['mobile']) ? $addr['mobile'] : "";
  132. $value['can'] = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
  133. $value['company_name'] = implode('/', array_column(GetPart($value['itemid']), 'name'));
  134. $value['sendtime'] = $value['status'] < 2 ? '' : $value['sendtime'];
  135. $data[] = $value;
  136. }
  137. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  138. }
  139. //发货单详情
  140. public function saleOutInfo()
  141. {
  142. $outCode = isset($this->post['outCode']) && $this->post['outCode'] !== "" ? trim($this->post['outCode']) : "";
  143. if ($outCode == "") {
  144. return error_show(1002, "参数outcode不能为空");
  145. }
  146. $codeinfo = Db::name("order_out")->where(['outCode' => $outCode, "is_del" => 0])->find();
  147. if (empty($codeinfo)) {
  148. return error_show(1002, "未找到出库数据");
  149. }
  150. $item = Db::name("sale")->where(['orderCode' => $codeinfo['orderCode']])->find();
  151. if ($item['order_type'] == 3) {
  152. $goodinfo = Db::name("good_zixun")->where(["spuCode" => $item['good_code'], "is_del" => 0])->find();
  153. if ($goodinfo == false) {
  154. return error_show(1004, "未找到商品数据");
  155. }
  156. } else {
  157. $goodinfo = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  158. ->where(['a.skuCode' => $item['skuCode']])->find();
  159. if ($goodinfo == false) {
  160. return error_show(1002, "未找到商品数据");
  161. }
  162. }
  163. $int = isset($goodinfo['cat_id']) && $goodinfo['cat_id'] != 0 ? made($goodinfo['cat_id']) : [];
  164. $addr = Db::name("order_addr")->where(["id" => $codeinfo['addrid']])->find();
  165. if ($addr) {
  166. $addinfo = $addr['addr_code'] != '' ? json_decode($addr['addr_code'], true) ?? $addr['addr_code'] : '';
  167. if (is_string($addinfo) && $addinfo != '') {
  168. $addinfo = ["provice_code" => '', "city_code" => '', "area_code" => ''];
  169. list($addinfo['provice_code'], $addinfo['city_code'], $addinfo['area_code']) = explode(",", $addr['addr_code']);
  170. }
  171. $addr['addr_cn'] = GetAddr(json_encode($addinfo));
  172. }
  173. $codeinfo['good_name'] = isset($item['good_name']) ? $item['good_name'] : "";
  174. $codeinfo['good_num'] = isset($item['good_num']) ? $item['good_num'] : "";
  175. $codeinfo['good_code'] = isset($item['good_code']) ? $item['good_code'] : "";
  176. $codeinfo['origin_price'] = isset($item['origin_price']) ? $item['origin_price'] : "";
  177. $codeinfo['sale_price'] = isset($item['sale_price']) ? $item['sale_price'] : "";
  178. $codeinfo['total_price'] = isset($item['total_price']) ? $item['total_price'] : "";
  179. $codeinfo['skuCode'] = isset($item['skuCode']) ? $item['skuCode'] : "";
  180. $codeinfo['addr'] = $addr['addr_cn'] ?? '';
  181. $codeinfo['addr'] .= isset($addr['addr']) ? $addr['addr'] : "";
  182. $codeinfo['addr_code'] = isset($addr['addr_code']) ? $addr['addr_code'] : "";
  183. $codeinfo['contactor'] = isset($addr['contactor']) ? $addr['contactor'] : "";
  184. $codeinfo['mobile'] = isset($addr['mobile']) ? $addr['mobile'] : "";
  185. $codeinfo['sendtime'] = $codeinfo['status'] < 2 ? '' : $codeinfo['sendtime'];
  186. $codeinfo['can'] = $int;
  187. $codeinfo['order_source'] = $item['order_source'];
  188. $orderReturn = Db::name("order_return")->where(["outCode" => $outCode, "is_del" => 0])->order("id desc")->find();
  189. $codeinfo['order_return'] = $orderReturn;
  190. return app_show(0, "获取成功", $codeinfo);
  191. }
  192. //库管发货
  193. public function outSend()
  194. {
  195. $outCode = isset($this->post['outCode']) && $this->post['outCode'] != "" ? trim($this->post['outCode']) : "";
  196. if ($outCode == "") {
  197. return error_show(1004, "参数outCode不能为空");
  198. }
  199. $outinfo = Db::name("order_out")->where(["outCode" => $outCode, "is_del" => 0])->find();
  200. if ($outinfo == false) {
  201. return error_show(1004, "发货数据未找到");
  202. }
  203. $einfo = Db::name('sale')->where(['orderCode' => $outinfo['orderCode'], 'is_del' => 0])->find();
  204. if (empty($einfo)) {
  205. return error_show(1002, "未找到销售订单数据");
  206. }
  207. $is_reurn = Db::name("sale_return")->where(['orderCode' => $outinfo['orderCode'], 'is_del' => 0])->where("status", "<", 4)->find();
  208. if ($is_reurn != false) {
  209. return error_show(1002, "销售单存在退货未处理完成");
  210. }
  211. $post_name = isset($this->post['post_name']) && $this->post['post_name'] != "" ? trim($this->post['post_name']) : "";
  212. if ($post_name == "") {
  213. return error_show(1004, "参数post_name不能为空");
  214. }
  215. $post_code = isset($this->post['post_code']) && $this->post['post_code'] != "" ? trim($this->post['post_code']) : "";
  216. if ($post_code == "") {
  217. return error_show(1004, "参数post_code不能为空");
  218. }
  219. $remark = isset($this->post['remark']) && $this->post['remark'] != "" ? trim($this->post['remark']) : "";
  220. $post_fee = isset($this->post['post_fee']) && $this->post['post_fee'] != "" ? floatval($this->post['post_fee']) : "";
  221. $outinfo['post_name'] = $post_name;
  222. $outinfo['post_code'] = $post_code;
  223. $outinfo['post_fee'] = $post_fee;
  224. $outinfo['sendtime'] = date("Y-m-d H:i:s");
  225. $old_outinfo_status = $outinfo['status'];
  226. $outinfo['status'] = 2;
  227. $outinfo['updatetime'] = date("Y-m-d H:i:s");
  228. $outinfo['remark'] = $remark;
  229. if ($einfo['wsend_num'] < $outinfo['send_num']) {
  230. return error_show(1004, "订单未发货数量不足");
  231. }
  232. Db::startTrans();
  233. try {
  234. $up = Db::name("order_out")->save($outinfo);
  235. $user_info = GetUserInfo($this->post['token']);
  236. $uid = isset($user_info['data']['id']) ? $user_info['data']['id'] : 0;
  237. $uname = isset($user_info['data']['nickname']) ? $user_info['data']['nickname'] : '';
  238. if ($up) {
  239. //修改状态,添加待办
  240. ActionLog::logAdd(['id' => $uid, 'nickname' => $uname], [
  241. "order_code" => $outinfo['outCode'],//出库单号
  242. "status" => $old_outinfo_status,//这里的status是之前的值
  243. "action_remark" => '',//备注
  244. "action_type" => "edit"//新建create,编辑edit,更改状态status
  245. ], "CKD", $outinfo['status'], $outinfo);
  246. ProcessOrder::AddProcess(['id' => $uid, 'nickname' => $uname], [
  247. "order_type" => 'CKD',
  248. "order_code" => $outinfo['outCode'],//出库单号
  249. "order_id" => $outinfo['id'],
  250. "order_status" => $outinfo['status'],
  251. "before_status" => $old_outinfo_status,
  252. 'wait_id'=>$outinfo['apply_id'],
  253. 'wait_name'=>$outinfo['apply_name'],
  254. ]);
  255. $orderstatus = $einfo['status'];
  256. $einfo['send_num'] += $outinfo['send_num'];
  257. $einfo['wsend_num'] -= $outinfo['send_num'];
  258. $einfo['status'] = $einfo['wsend_num'] == 0 ? 2 : ($einfo['send_num'] == 0 ? 0 : 1);
  259. $einfo['send_status'] = $einfo['wsend_num'] == 0 ? 3 : ($einfo['send_num'] == 0 ? 1 : 2);
  260. $einfo['updatetime'] = date("Y-m-d H:i:s");
  261. $saleup = Db::name("sale")->save($einfo);
  262. if ($saleup == false) {
  263. Db::rollback();
  264. return error_show(1002, "销售单状态更新失败");
  265. }
  266. // }
  267. //修改状态,添加待办
  268. ActionLog::logAdd(['id' => $uid, 'nickname' => $uname], [
  269. "order_code" => $einfo['orderCode'],//出库单号
  270. "status" => $orderstatus,//这里的status是之前的值
  271. "action_remark" => '',//备注
  272. "action_type" => "edit"//新建create,编辑edit,更改状态status
  273. ], "XSQRD", $einfo['status'], $einfo);
  274. ProcessOrder::AddProcess(['id' => $uid, 'nickname' => $uname], [
  275. "order_type" => 'XSQRD',
  276. "order_code" => $einfo['orderCode'],//出库单号
  277. "order_id" => $einfo['id'],
  278. "order_status" => $einfo['status'], "before_status" => $orderstatus
  279. ]);
  280. $stokc = Db::name("good_stock")->where(['spuCode' => $einfo['good_code'], "wsm_code" => $outinfo['wsm_code'], "is_del" => 0])->find();
  281. if ($stokc == false) {
  282. Db::rollback();
  283. return error_show(1002, "未找到库存数据");
  284. } else {
  285. if ($outinfo['send_num'] > $stokc['wait_out_stock']) {
  286. Db::rollback();
  287. return error_show(1002, "超出库存数量");
  288. }
  289. $stokc['wait_out_stock'] -= $outinfo['send_num'];
  290. $stokc['total_stock'] = $stokc['wait_out_stock'] + $stokc['usable_stock'];
  291. // $stokc['intra_stock']+=$outinfo['send_num'];
  292. $stokc['updatetime'] = date("Y-m-d H:i:s");
  293. }
  294. $stoc = Db::name("good_stock")->save($stokc);
  295. if ($stoc == false) {
  296. Db::rollback();
  297. return error_show(1002, "库存更新失败");
  298. }
  299. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $stokc['id'], "type" => 2, 'stock' => $outinfo['send_num'], "stock_name" => "wait_out_stock"];
  300. GoodLog::LogAdd(['id' => $uid, 'nickname' => $uname], $good_data, "CKD");
  301. Cache::store("redis")->handler()->lPush("SENDOUT", $outCode);
  302. Db::commit();
  303. } else {
  304. Db::rollback();
  305. return error_show(1004, "发货失败");
  306. }
  307. //如果是有赞订单的话,将发货信息推到有赞
  308. //有赞信息有可能推送失败(比如超过72小时,不允许多次修改等),所以不应该和这里的事务放到一起
  309. if ($einfo['order_source'] == 5) {
  310. $res = curl_request(config('app.yz_domain') . 'api/yz_out_send', ['orderCode' => $einfo['orderCode'], 'out_stype' => $post_name, 'post_code' => $post_code, 'uid' => $uid, 'uname' => $uname, 'order_out' => $outCode]);
  311. $res = json_decode($res, true);
  312. if ($res['code'] != 0) return app_show(0, '发货成功,' . $res['message']);
  313. }
  314. return app_show(0, "发货成功");
  315. } catch (\Exception $e) {
  316. Db::rollback();
  317. return error_show(1004, $e->getMessage());
  318. }
  319. }
  320. //库管批量发货
  321. public function outSendBatchByImport()
  322. {
  323. $param = $this->request->only(['list', 'token'], 'post', 'trim');
  324. if (empty($param['list'])) return error_show(1005, 'list参数不能为空');
  325. $user = GetUserInfo($param['token']);
  326. $createrid = isset($user['data']['id']) ? $user['data']['id'] : 0;
  327. $creater = isset($user['data']['nickname']) ? $user['data']['nickname'] : '';
  328. //所有发货单信息
  329. $order_out_infos = Db::name("order_out")
  330. ->where('status', 1)
  331. ->where('is_del', 0)
  332. ->whereIn('outCode', array_column($param['list'], 'outCode'))
  333. ->column('id,status,send_num,orderCode,wsm_code,apply_id,apply_name', 'outCode');
  334. //处理数据
  335. Db::startTrans();
  336. try {
  337. $good_data = [];
  338. $temp_out_codes = [];
  339. foreach ($param['list'] as $value) {
  340. if (!isset($order_out_infos[$value['outCode']])) throw new Exception($value['outCode'] . '该发货单未找到或状态不允许发货');
  341. //每次循环都需要重新查询对应数据,为了数据及时更新
  342. $sale_infos = Db::name("sale")
  343. ->where('orderCode', $order_out_infos[$value['outCode']]['orderCode'])
  344. ->where('is_del', 0)
  345. ->column('id,send_num,wsend_num,status,good_code,order_source', 'orderCode');
  346. if (!isset($sale_infos[$order_out_infos[$value['outCode']]['orderCode']])) throw new Exception($value['outCode'] . '该发货单对应的销售单未找到');
  347. //判断发货单是否重复
  348. if (isset($temp_out_codes[$value['outCode']])) {
  349. Db::rollback();
  350. return app_show(1005, '下列发货申请单号重复', [$value]);
  351. } else $temp_out_codes[$value['outCode']] = $value['outCode'];
  352. //【发货单】
  353. //查询已有发货单信息及状态
  354. //更新发货单
  355. $up = Db::name("order_out")
  356. ->where(['id' => $order_out_infos[$value['outCode']]['id'], 'outCode' => $value['outCode'], 'status' => 1, "is_del" => 0])
  357. ->update([
  358. 'post_name' => isset($value['post_name']) ? $value['post_name'] : '',
  359. 'post_code' => $value['post_code'],
  360. 'post_fee' => $value['post_fee'],
  361. 'sendtime' => date('Y-m-d H:i:s'),
  362. 'status' => 2,
  363. 'updatetime' => date('Y-m-d H:i:s'),
  364. 'remark' => isset($value['remark']) ? $value['remark'] : '',
  365. ]);
  366. if ($up) {
  367. //修改状态,添加待办
  368. ActionLog::logAdd(['id' => $createrid, 'nickname' => $creater], [
  369. "order_code" => $value['outCode'],//出库单号
  370. "status" => $order_out_infos[$value['outCode']]['status'],//这里的status是之前的值
  371. "action_remark" => '',//备注
  372. "action_type" => "edit"//新建create,编辑edit,更改状态status
  373. ], "CKD", 2, $order_out_infos[$value['outCode']]);
  374. ProcessOrder::AddProcess(['id' => $createrid, 'nickname' => $creater], [
  375. "order_type" => 'CKD',
  376. "order_code" => $value['outCode'],//出库单号
  377. "order_id" => $order_out_infos[$value['outCode']]['id'],
  378. "order_status" => 2,
  379. "before_status" => $order_out_infos[$value['outCode']]['status'],
  380. 'wait_id' => $order_out_infos[$value['outCode']]['apply_id'],
  381. 'wait_name' => $order_out_infos[$value['outCode']]['apply_name'],
  382. ]);
  383. //【销售单】
  384. $einfo = [];
  385. $einfo['send_num'] = $sale_infos[$order_out_infos[$value['outCode']]['orderCode']]['send_num'] + $order_out_infos[$value['outCode']]['send_num'];
  386. $einfo['wsend_num'] = $sale_infos[$order_out_infos[$value['outCode']]['orderCode']]['wsend_num'] - $order_out_infos[$value['outCode']]['send_num'];
  387. $einfo['status'] = $einfo['wsend_num'] == 0 ? 2 : ($einfo['send_num'] == 0 ? 0 : 1);
  388. $einfo['send_status'] = $einfo['wsend_num'] == 0 ? 3 : ($einfo['send_num'] == 0 ? 1 : 2);
  389. $einfo['updatetime'] = date("Y-m-d H:i:s");
  390. $saleup = Db::name("sale")
  391. ->where('id', $sale_infos[$order_out_infos[$value['outCode']]['orderCode']]['id'])
  392. ->update($einfo);
  393. if ($saleup == false) throw new Exception($value['outCode'] . '销售单状态更新失败');
  394. //修改状态,添加待办
  395. ActionLog::logAdd(['id' => $createrid, 'nickname' => $creater], [
  396. "order_code" => $order_out_infos[$value['outCode']]['orderCode'],//销售单号
  397. "status" => $sale_infos[$order_out_infos[$value['outCode']]['orderCode']]['status'],//这里的status是之前的值
  398. "action_remark" => '',//备注
  399. "action_type" => "edit"//新建create,编辑edit,更改状态status
  400. ], "XSQRD", $einfo['status'], $einfo);
  401. ProcessOrder::AddProcess(['id' => $createrid, 'nickname' => $creater], [
  402. "order_type" => 'XSQRD',
  403. "order_code" => $order_out_infos[$value['outCode']]['orderCode'],//出库单号
  404. "order_id" => $sale_infos[$order_out_infos[$value['outCode']]['orderCode']]['id'],
  405. "order_status" => $einfo['status'], "before_status" => $sale_infos[$order_out_infos[$value['outCode']]['orderCode']]['status']
  406. ]);
  407. //【库存】
  408. $stock = Db::name("good_stock")
  409. ->field('id,wait_out_stock,usable_stock,total_stock,updatetime')
  410. ->where([
  411. "is_del" => 0,
  412. 'spuCode' => $sale_infos[$order_out_infos[$value['outCode']]['orderCode']]['good_code'],
  413. "wsm_code" => $order_out_infos[$value['outCode']]['wsm_code'],
  414. ])->find();
  415. if ($stock == false) throw new Exception($value['outCode'] . '未找到库存数据');
  416. else {
  417. if ($order_out_infos[$value['outCode']]['send_num'] > $stock['wait_out_stock']) throw new Exception($value['outCode'] . '超出库存数量');
  418. $stock['wait_out_stock'] -= $order_out_infos[$value['outCode']]['send_num'];
  419. $stock['total_stock'] = $stock['wait_out_stock'] + $stock['usable_stock'];
  420. $stock['updatetime'] = date("Y-m-d H:i:s");
  421. $stock_rs = Db::name("good_stock")
  422. ->where('id', $stock['id'])
  423. ->update($stock);
  424. if ($stock_rs == false) throw new Exception($value['outCode'] . '库存更新失败');
  425. $good_data[] = [
  426. 'good_log_code' => $value['outCode'],
  427. 'stock_id' => $stock['id'],
  428. 'type' => 2,
  429. 'stock' => $order_out_infos[$value['outCode']]['send_num'],
  430. 'stock_name' => 'wait_out_stock'
  431. ];
  432. }
  433. } else throw new Exception($value['outCode'] . '发货失败');
  434. Cache::store("redis")->handler()->lPush("SENDOUT",$value['outCode']);
  435. }
  436. if (!empty($good_data)) GoodLog::LogAdd(['id' => $createrid, 'nickname' => $creater], $good_data, "CKD");
  437. Db::commit();
  438. return app_show(0, '发货成功');
  439. } catch (Exception $exception) {
  440. Db::rollback();
  441. return error_show(1004, $exception->getMessage());
  442. }
  443. }
  444. }