ImportOrderFromCHandleData.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633
  1. <?php
  2. declare (strict_types=1);
  3. namespace app\command;
  4. use app\admin\model\ActionLog;
  5. use app\admin\model\GoodLog;
  6. use app\admin\model\OrderImportFromC as OIFCModel;
  7. use app\admin\model\ProcessOrder;
  8. use app\admin\model\Test1;
  9. use think\console\Command;
  10. use think\console\Input;
  11. use think\console\input\Argument;
  12. use think\console\input\Option;
  13. use think\console\Output;
  14. use think\Exception;
  15. use think\facade\Cache;
  16. use think\facade\Db;
  17. //C端订单导入-处理
  18. class ImportOrderFromCHandleData extends Command
  19. {
  20. protected function configure()
  21. {
  22. // 指令配置
  23. $this->setName('handleData')
  24. ->setDescription('批量处理C端导入的订单数据');
  25. }
  26. //【脚本2】批量处理C端导入的订单数据
  27. protected function execute(Input $input, Output $output)
  28. {
  29. $key = 'import_order_from_c_key';
  30. $c_data_id = Cache::store('redis')->handler()->rpop($key);
  31. if (!$c_data_id) $output->writeln('没有符合条件的记录');
  32. else {
  33. $order_import_from_c_db = new OIFCModel();
  34. $c_data = $order_import_from_c_db
  35. ->where(['is_del' => OIFCModel::$is_del_normal, 'status' => OIFCModel::$status_wait_relation, 'id' => $c_data_id])
  36. ->lock(true)
  37. ->field('id,createrid,creater')
  38. ->find();
  39. if (empty($c_data)) $output->writeln('未查询到该记录');
  40. else {
  41. Db::startTrans();
  42. try {
  43. //先找用户确认信息
  44. $extend_data = Db::name('order_import_from_c_extend')
  45. ->where(['order_import_from_c_id' => $c_data['id'], 'is_del' => 0, 'type' => 2])
  46. ->find();
  47. if (empty($extend_data)) {
  48. $extend_data = Db::name('order_import_from_c_extend')
  49. ->where(['order_import_from_c_id' => $c_data['id'], 'is_del' => 0, 'type' => 1])
  50. ->find();
  51. }
  52. if (empty($extend_data)) throw new Exception('没有对应的解析数据');
  53. //复用sale::create()方法 -- start
  54. $orderCode = makeNo("QR");
  55. $customer_code = $extend_data['customer_code'];
  56. $customer = Db::name("customer_info")
  57. ->where(["companyNo" => $customer_code])
  58. ->find();
  59. if ($customer == false) throw new Exception('未找到客户数据');
  60. $supplierNo = $extend_data['companyNo'];
  61. $supplier = Db::name("business")
  62. ->where(["companyNo" => $supplierNo])
  63. ->find();
  64. if ($supplier == false) throw new Exception('未找到平台供应商数据');
  65. $goodtype = 1;//1正常商品
  66. $sendtype = 1;//直接发货
  67. $platform_id = $extend_data['platform_id'];
  68. $platform_order = $extend_data['platform_code'];
  69. $good_num = $extend_data['num'];
  70. $arrtime = $extend_data['platform_time'];
  71. $paytime = $extend_data['addtime'];
  72. $workNo = $extend_data['po_code'];
  73. $ct = Db::name('good_platform')
  74. ->alias('a')
  75. ->join('good b', 'b.spuCode=a.spuCode', 'left')
  76. ->where(['a.skuCode' => $extend_data['skuCode'], 'a.exam_status' => 6])//exam_status==6已上线
  77. ->field("b.*,a.skuCode,a.spuCode,a.platform_code,a.plat_code")
  78. ->find();
  79. if ($ct == false) throw new Exception('未找到商品数据');
  80. $goodinfo = $ct;
  81. $is_stock = $ct['is_stock'];
  82. $order_type = $is_stock == 1 ? 5 : 6;//1销售2咨询(1备库 2非库存 3咨询采反 4项目采反,5平台部订单销售库存品,6平台部订单销售非库存品)
  83. $spuCode = $ct['spuCode'];
  84. $skuCode = $ct['skuCode'];
  85. $is_activity = empty($extend_data['activity_name']) ? 0 : 1;
  86. if ($goodinfo['is_stock'] == 1) {
  87. $stock = Db::name("good_stock")
  88. ->alias("a")
  89. ->leftJoin("warehouse_info b", "a.wsm_code=b.wsm_code")
  90. ->where(["spuCode" => $spuCode, "a.is_del" => 0, "a.status" => 1, 'b.wsm_type' => 5, "b.companyNo" => $supplierNo])
  91. ->field("a.id,a.usable_stock,a.wait_out_stock")
  92. ->find();
  93. if ($stock == false || $stock['usable_stock'] < $good_num) throw new Exception('库存数量不足');
  94. $origin_price = 0;
  95. } else {
  96. $origin = Db::name("good_nake")
  97. ->where([["spuCode", "=", $spuCode], ["min_num", "<=", $good_num], ["is_del", "=", 0]])
  98. ->order("min_num desc")
  99. ->find();
  100. if ($origin == false) throw new Exception('未找到相关成本价格');
  101. $origin_price = $origin['nake_total'];
  102. }
  103. $sale_price = $extend_data['price'];
  104. if ($goodtype == 1) {
  105. $good = Db::name("good_ladder")
  106. ->where(["skuCode" => $skuCode, "is_del" => 0, "status" => 1])
  107. ->where([["min_num", "<=", $good_num]])
  108. ->order("min_num desc")
  109. ->find();
  110. if ($good == false) throw new Exception('未找到相关阶梯价格');
  111. $sale_price = $good['sale_price'];
  112. if ($ct['is_gold_price'] == 1 && $is_stock != 1) {
  113. $gold = Db::name("gold_price1")
  114. ->field('id,price')
  115. ->where(["type" => $ct['noble_metal'], "is_del" => 0, "status" => 1])
  116. ->order("addtime desc")
  117. ->find();
  118. //$saleprice(最终售价) = (打样费/购买数量 + 开模费/购买数量 + 商品重量* 最新金价 + 工艺费* 商品重量+包装费+加标费+证书费+产品裸价+物流费)/(1-成本售价/100);
  119. $sale_price = $ct['demo_fee'] / $good_num + $ct['open_fee'] / $good_num + $ct['noble_weight'] * $gold["price"] + $good['cost_fee'] * $ct['noble_weight'] + $origin['package_fee'] + $origin['mark_fee'] + $origin['cert_fee'] + $origin['nake_fee'] + $origin['delivery_fee'];
  120. $ct['cgd_gold_price'] = $gold['price'];
  121. // $order_rate = Db::name("cat")->where(["id" => $ct['cat_id']])->value('order_rate');
  122. // $budget = isset($order_rate) ? $order_rate / 100 : 0;
  123. // $saleprice = $total_fee / (1 - $budget);
  124. }
  125. if ($is_activity == 1) {
  126. $act = Db::name("activity_info")
  127. ->alias("a")
  128. ->leftJoin("good_activity b", "a.activity_code=b.activity_code")
  129. ->where(["a.skuCode" => $skuCode, "a.activity_code" => $extend_data['activity_code'], "a.is_del" => 0, "a.status" => 1, "b.status" => 6, "b.is_del" => 0])
  130. ->find();
  131. if ($act == false) throw new Exception('未找到相关活动价');
  132. if ($act['moq_num'] > $good_num) throw new Exception('商品不满足活动价起订量' . $act['moq_num']);
  133. if ($act['activity_stock'] < $good_num) throw new Exception('商品活动库存剩余' . $act['activity_stock']);
  134. $sale_price = $act['activity_price'];
  135. }
  136. }
  137. $cgd = [
  138. "supplierNo" => $ct['supplierNo'],
  139. "companyNo" => $supplierNo,
  140. "orderCode" => $orderCode,
  141. "spuCode" => $ct['spuCode'],
  142. "skuCode" => $ct['skuCode'],
  143. "good_name" => $ct['good_name'],
  144. "sale_price" => $origin_price,
  145. "total_fee" => $origin_price * $good_num,
  146. "pakge_fee" => $ct['packing_fee'],
  147. "cert_fee" => $ct['cert_fee'],
  148. "open_fee" => $ct['open_fee'],
  149. "cost_fee" => $ct['cost_fee'],
  150. "mark_fee" => $ct['mark_fee'],
  151. "demo_fee" => $ct['demo_fee'],
  152. "good_num" => $good_num,
  153. "good_type" => $goodtype,
  154. "order_type" => $order_type,
  155. "createrid" => $ct['createrid'],
  156. "creater" => $ct['creater'],
  157. 'send_way' => 2
  158. ];
  159. $send_num = $extend_data['num'];
  160. $remark = $extend_data['order_remark'];
  161. $rm = $c_data['createrid'];
  162. $ri = $c_data['creater'];
  163. $data = [
  164. "orderCode" => $orderCode,
  165. "good_code" => $spuCode,
  166. "skuCode" => $skuCode,
  167. "customer_code" => $customer_code,
  168. "good_name" => isset($goodinfo['good_name']) && $goodinfo['good_name'] !== '' ? $goodinfo['good_name'] : '',
  169. "good_num" => $good_num,
  170. "cat_id" => $goodinfo['cat_id'],
  171. "apply_id" => $rm,
  172. "apply_name" => $ri,
  173. "origin_price" => $origin_price,
  174. "sale_price" => $sale_price,
  175. "post_fee" => 0,
  176. "status" => 0,
  177. "send_num" => 0,
  178. "wsend_num" => $good_num,
  179. "send_status" => 1,
  180. "good_type" => $goodtype,
  181. "send_type" => $sendtype,
  182. "supplierNo" => $extend_data['companyNo'],
  183. "is_del" => 0,
  184. "zxNo" => "",
  185. "platform_order" => $platform_order,
  186. "platform_id" => $platform_id,
  187. "remark" => $remark,
  188. "is_stock" => $is_stock,
  189. "is_activity" => $is_activity === "" ? 0 : $is_activity,
  190. "order_type" => $order_type,
  191. // "poNo"=>$poNo,
  192. 'good_weight' => $ct['weight'],
  193. 'gold_price' => $ct['cgd_gold_price'],
  194. 'cost_price' => $ct['cost_fee'],
  195. 'diff_weight' => 0,
  196. 'diff_fee' => 0,
  197. "workNo" => $workNo,
  198. "addtime" => date("Y-m-d H:i:s"),
  199. "updatetime" => date("Y-m-d H:i:s"),
  200. 'total_price' => round($sale_price * $good_num, 2),
  201. ];
  202. $paytime == "" ? "" : $data['paytime'] = $paytime;
  203. $datainfo = Db::name('sale')->insert($data, true);
  204. if ($datainfo > 0) {
  205. if ($is_activity == 1) {
  206. $actup = [
  207. "activity_stock" => $act['activity_stock'] - $good_num,
  208. "updatetime" => date("Y-m-d H:i:s")
  209. ];
  210. $actupp = Db::name("activity_info")
  211. ->where(["skuCode" => $skuCode, "activity_code" => $extend_data['activity_code'], "is_del" => 0, "status" => 1])
  212. ->save($actup);
  213. if ($actupp == false) throw new Exception('活动库存修改失败');
  214. }
  215. if ($is_stock == 0) {
  216. //非库存品
  217. $bol = $this->createCgd($cgd, $rm, $ri);
  218. if ($bol == false) throw new Exception('订单创建失败');
  219. } else {
  220. //库存品
  221. $bol = $this->RelaCgd(['orderCode' => $orderCode, "good_num" => $good_num, "spuCode" => $spuCode, "companyNo" => $supplierNo, 'order_type' => $order_type]);
  222. if ($bol == false) throw new Exception('库存商品关联采购单失败');
  223. if (isset($stock)) {
  224. $stck = [
  225. "usable_stock" => $stock['usable_stock'] - $good_num,
  226. "wait_out_stock" => $stock['wait_out_stock'] + $good_num,
  227. "updatetime" => date("Y-m-d H:i:s")
  228. ];
  229. $upad = Db::name("good_stock")
  230. ->where($stock)
  231. ->update($stck);
  232. if ($upad == false) throw new Exception('库存商品更新库存失败');
  233. //商品变动日志表,good_log_code字段存储采购单号
  234. $good_data[] = ['good_log_code' => $orderCode, "stock_id" => $datainfo, "type" => 2, 'stock' => $good_num, "stock_name" => "usable_stock"];
  235. $good_data[] = ['good_log_code' => $orderCode, "stock_id" => $datainfo, "type" => 1, 'stock' => $good_num, "stock_name" => "wait_out_stock"];
  236. GoodLog::LogAdd(['id' => $rm, 'nickname' => $ri], $good_data, "XSQRD");
  237. }
  238. }
  239. if ($sendtype == 1) {
  240. $temp = [
  241. 'orderCode' => $orderCode,
  242. 'contactor' => $extend_data['contactor'],
  243. 'mobile' => $extend_data['mobile'],
  244. 'addr' => $extend_data['addr'],
  245. 'addr_code' => $extend_data['addr_code'],
  246. 'customer_code' => $customer_code,
  247. 'receipt_quantity' => $extend_data['num'],//收货数量,
  248. 'post_fee' => 0,
  249. 'is_del' => 0,
  250. 'addtime' => date("Y-m-d H:i:s"),
  251. 'updatetime' => date("Y-m-d H:i:s"),
  252. 'arrive_time' => $arrtime,
  253. ];
  254. $vmp = Db::name('order_addr')->insert($temp, true);
  255. if ($vmp > 0) {
  256. $order = Db::name("order_num")
  257. ->where(["orderCode" => $orderCode, "status" => 1])
  258. ->where([["wsend_num", ">=", 0]])
  259. ->lock(true)
  260. ->find();
  261. if ($order == false) throw new Exception('未找到可以发货得采购单数据');
  262. $num = $extend_data['num'];
  263. $outCode = makeNo("DF");
  264. $order['wsend_num'] -= $num;
  265. $order['send_num'] += $num;
  266. $or = Db::name("order_num")->save($order);
  267. if ($or == false) throw new Exception('发货地址更新失败');
  268. $tep = [
  269. "cgdNo" => $order['cgdNo'],
  270. "outCode" => $outCode,
  271. "send_num" => $num,
  272. "status" => 1,
  273. "addtime" => date("Y-m-d H:i:s"),
  274. "updatetime" => date("Y-m-d H:i:s")
  275. ];
  276. $sen = Db::name("order_send")->save($tep);
  277. if ($sen == false) throw new Exception('发货地址添加创建失败');
  278. $cgdinfo = Db::name("purchease_order")->where(["cgdNo" => $order['cgdNo']])->find();
  279. if ($cgdinfo == false) throw new Exception('未匹配到采购数据');
  280. $out = [
  281. "orderCode" => $orderCode,
  282. "outCode" => $outCode,
  283. "apply_id" => $rm,
  284. "apply_name" => $ri,
  285. "addrid" => $vmp,
  286. "post_name" => "",
  287. "post_code" => "",
  288. "post_fee" => 0,
  289. "sendtime" => date("Y-m-d H:i:s"),
  290. "send_num" => $num,
  291. "check_num" => 0,
  292. "error_num" => 0,
  293. "wsm_code" => $cgdinfo['wsm_code'],
  294. "order_type" => $order_type,
  295. "status" => $is_stock == 1 ? 1 : 0,
  296. "addtime" => date("Y-m-d H:i:s"),
  297. "updatetime" => date("Y-m-d H:i:s")
  298. ];
  299. $ou = Db::name("order_out")->insert($out);
  300. if ($ou == false) throw new Exception('发货地址添加创建失败');
  301. else {
  302. //修改状态,添加待办
  303. ActionLog::logAdd(['id' => $rm, 'nickname' => $ri], [
  304. "order_code" => $outCode,//出库单号
  305. "status" => 0,//这里的status是之前的值
  306. "action_remark" => '',//备注
  307. "action_type" => "create"//新建create,编辑edit,更改状态status
  308. ], "CKD", 0, $out);
  309. ProcessOrder::AddProcess(['id' => $rm, 'nickname' => $ri], [
  310. "order_type" => 'CKD',
  311. "order_code" => $outCode,//出库单号
  312. "order_id" => 0,
  313. "order_status" => 0,
  314. "before_status" => 0
  315. ]);
  316. }
  317. } else throw new Exception('发货地址添加失败');
  318. }
  319. }
  320. //复用sale::create()方法 -- end
  321. //处理完成
  322. $order_import_from_c_db
  323. ->where('id', $c_data['id'])
  324. ->where('is_del', OIFCModel::$is_del_normal)
  325. ->save([
  326. 'status' => $order_import_from_c_db::$status_success,
  327. 'updatetime' => date('Y-m-d H:i:s'),
  328. 'remark' => '',
  329. 'updateid' => 0,
  330. 'updater' => 'system',
  331. 'orderCode' => $orderCode
  332. ]);
  333. Db::commit();
  334. $output->writeln(date('Y-m-d H:i:s') . '|处理成功');
  335. } catch (\think\Exception $exception) {
  336. Db::rollback();
  337. $order_import_from_c_db
  338. ->where(['id' => $c_data['id'], 'status' => OIFCModel::$status_wait_relation])
  339. ->save([
  340. 'status' => $order_import_from_c_db::$status_stock_not_enough,
  341. 'updatetime' => date('Y-m-d H:i:s'),
  342. 'remark' => $exception->getMessage(),
  343. 'updateid' => 0,
  344. 'updater' => 'system'
  345. ]);
  346. // 指令输出
  347. $output->writeln(date('Y-m-d H:i:s') . '|处理失败,' . $exception->getMessage() . '|' . $exception->getFile() . '|' . $exception->getLine());
  348. }
  349. }
  350. }
  351. }
  352. //创建采购单
  353. private function createCgd($data = [], $rm = '0', $ri = '')
  354. {
  355. $cgdCode = makeNo("CG");
  356. $supplier = Db::name("supplier")
  357. ->where(["code" => $data['supplierNo'], "is_del" => 0])->find();
  358. if ($supplier == false) return false;
  359. $wsm = Db::name("warehouse_info")
  360. ->where(["supplierNo" => $data["supplierNo"], "companyNo" => $data['companyNo'], "is_del" => 0])
  361. ->find();
  362. if ($wsm == false) {
  363. $wsm_code = makeNo("WSM");
  364. $inwsm = [
  365. "wsm_code" => $wsm_code,
  366. "name" => $supplier['name'],
  367. "wsm_type" => 2,
  368. "supplierNo" => $supplier['code'],
  369. "addr" => "",
  370. "addrs_code" => "",
  371. "contactor" => 0,
  372. "contactor_name" => 0,
  373. "mobile" => "",
  374. "position" => "",
  375. "companyNo" => $data['companyNo'],
  376. "status" => 1,
  377. "is_del" => 0,
  378. "addtime" => date("Y-m-d H:i:s"),
  379. "updatetime" => date("Y-m-d H:i:s")
  380. ];
  381. $in = Db::name("warehouse_info")->insert($inwsm);
  382. if ($in == false) return false;
  383. } else {
  384. $wsm_code = $wsm['wsm_code'];
  385. }
  386. $cg = [
  387. "cgdNo" => $cgdCode,
  388. "bkcode" => "",
  389. "wsm_code" => $wsm_code,
  390. "cgder" => $data['creater'],
  391. "cgder_id" => $data['createrid'],
  392. "spuCode" => $data['spuCode'],
  393. "skuCode" => $data['skuCode'],
  394. "good_name" => $data['good_name'],
  395. "good_num" => $data['good_num'],
  396. "good_price" => $data['sale_price'],
  397. "total_fee" => round($data['sale_price'] * $data['good_num'], 2),
  398. "pakge_fee" => $data['pakge_fee'],
  399. "cert_fee" => $data['cert_fee'],
  400. "open_fee" => $data['open_fee'],
  401. "teach_fee" => $data['cost_fee'],
  402. "mark_fee" => $data['mark_fee'],
  403. "demo_fee" => $data['demo_fee'],
  404. #"weight"=>$data['weight'],
  405. "diff_weight" => "0",
  406. "diff_fee" => "0",
  407. "gold_price" => "0",
  408. "supplierNo" => $data['supplierNo'],
  409. "supplier_name" => $supplier['name'],
  410. "companyNo" => $data['companyNo'],
  411. "send_status" => 1,
  412. "send_num" => 0,
  413. "wsend_num" => $data['good_num'],
  414. "remark" => "",
  415. "status" => 0,//0初始化
  416. "lasttime" => date("Y-m-d H:i:s"),
  417. "is_del" => 0,
  418. "order_type" => $data['order_type'],
  419. "good_type" => $data['good_type'],
  420. "addtime" => date("Y-m-d H:i:s"),
  421. "updatetime" => date("Y-m-d H:i:s")
  422. ];
  423. $up = Db::name("purchease_order")->insert($cg, true);
  424. if ($up) {
  425. //修改状态,添加待办
  426. ActionLog::logAdd(['id' => $rm, 'nickname' => $ri], [
  427. "order_code" => $cg['cgdNo'],//销售单code
  428. "status" => 0,//这里的status是之前的值
  429. "action_remark" => '',//备注
  430. "action_type" => "create"//新建create,编辑edit,更改状态status
  431. ], "CGD", $cg['status'], $cg);
  432. ProcessOrder::AddProcess(['id' => $rm, 'nickname' => $ri], [
  433. "order_type" => 'CGD',
  434. "order_code" => $cg['cgdNo'],//销售单code
  435. "order_id" => $up,
  436. "order_status" => $cg['status'],
  437. "before_status" => 0
  438. ]);
  439. $rela = [
  440. "orderCode" => $data['orderCode'],
  441. "cgdNo" => $cgdCode,
  442. "spuCode" => $data['spuCode'],
  443. "good_num" => $data['good_num'],
  444. "wsend_num" => $data['good_num'],
  445. "send_num" => 0,
  446. "wait_num" => 0,
  447. "status" => 1,
  448. "source" => 2
  449. ];
  450. $re = Db::name("order_num")->save($rela);
  451. if ($re == false) return false;
  452. else {
  453. $stokc = Db::name("good_stock")
  454. ->where(['spuCode' => $data['spuCode'], "wsm_code" => $wsm_code, "is_del" => 0])
  455. ->find();
  456. if ($stokc == false) {
  457. $stokc = [
  458. "spuCode" => $data['spuCode'],
  459. "wsm_code" => $wsm_code,
  460. "wait_in_stock" => 0,
  461. "wait_out_stock" => 0,
  462. "usable_stock" => 0,
  463. "intra_stock" => 0,
  464. "total_stock" => 0,
  465. "status" => 1,
  466. "addtime" => date("Y-m-d H:i:s"),
  467. "updatetime" => date("Y-m-d H:i:s")
  468. ];
  469. $stoc = Db::name("good_stock")->save($stokc);
  470. if ($stoc == false) return false;
  471. }
  472. return true;
  473. }
  474. } else return false;
  475. }
  476. //创建.....
  477. private function RelaCgd(array $outinfo = [])
  478. {
  479. //备库单
  480. $cgd = Db::name("order_bk")
  481. ->where([
  482. ["spuCode", "=", $outinfo['spuCode']],
  483. ["is_del", "=", 0],
  484. ["balance_num", ">=", $outinfo['good_num']],
  485. ['companyNo', "=", $outinfo['companyNo']]
  486. ])
  487. ->lock(true)
  488. ->find();
  489. if ($cgd == false) return false;
  490. $cgdinfo = Db::name("purchease_order")
  491. ->where(['cgdNo' => $cgd['cgdNo'], "is_del" => 0])
  492. ->find();
  493. if ($cgdinfo == false) return false;
  494. $QrdCgd = [
  495. "cgdNo" => makeNo("CG"),
  496. "bkcode" => $cgdinfo['bkcode'],
  497. 'wsm_code' => $cgdinfo['wsm_code'],
  498. "cgder_id" => $cgdinfo['cgder_id'],
  499. "cgder" => $cgdinfo['cgder'],
  500. "spuCode" => $cgdinfo['spuCode'],
  501. "good_name" => $cgdinfo['good_name'],
  502. "good_num" => $outinfo['good_num'],
  503. "good_price" => $cgdinfo['good_price'],
  504. "total_fee" => round($cgdinfo['good_price'] * $outinfo['good_num'], 2),
  505. "pakge_fee" => $cgdinfo['pakge_fee'],
  506. "cert_fee" => $cgdinfo['cert_fee'],
  507. "open_fee" => $cgdinfo['open_fee'],
  508. "delivery_fee" => $cgdinfo['delivery_fee'],
  509. "mark_fee" => $cgdinfo['mark_fee'],
  510. "teach_fee" => $cgdinfo['teach_fee'],
  511. "nake_fee" => $cgdinfo['nake_fee'],
  512. "demo_fee" => $cgdinfo['demo_fee'],
  513. "weight" => $cgdinfo['weight'],
  514. "diff_weight" => $cgdinfo['diff_weight'],
  515. "diff_fee" => $cgdinfo['diff_fee'],
  516. "gold_price" => $cgdinfo['gold_price'],
  517. "supplierNo" => $cgdinfo['supplierNo'],
  518. "supplier_name" => $cgdinfo['supplier_name'],
  519. "companyNo" => $cgdinfo['companyNo'],
  520. "send_status" => 3,
  521. "send_num" => $outinfo['good_num'],
  522. "wsend_num" => 0,
  523. "remark" => $cgdinfo['remark'],
  524. "status" => 3,//入库完成
  525. "lasttime" => $cgdinfo['lasttime'],
  526. "is_del" => 0,
  527. "order_type" => $outinfo['order_type'],
  528. "good_type" => $cgdinfo['good_type'],
  529. "addtime" => date("Y-m-d H:i:s"),
  530. "updatetime" => date("Y-m-d H:i:s")
  531. ];
  532. $insetrCgd = Db::name("purchease_order")->insert($QrdCgd);
  533. if ($insetrCgd == false) return false;
  534. $merge_num = Db::name("purchease_order")
  535. ->where(["bkcode" => $cgdinfo['bkcode'], "order_type" => $outinfo['order_type'], "is_del" => 0])
  536. ->field("sum(send_num)-sum(th_num) as num")
  537. ->find();
  538. $cgd['balance_num'] = $cgd['total_num'] - $merge_num['num'];
  539. $cgd['merge_num'] = $merge_num['num'];
  540. $cgd['updatetime'] = date("Y-m-d H:i:s");
  541. $up = Db::name("order_bk")->save($cgd);
  542. if ($up == false) return false;
  543. $data = [
  544. "orderCode" => $outinfo['orderCode'],
  545. "cgdNo" => $QrdCgd['cgdNo'],
  546. "spuCode" => $outinfo['spuCode'],
  547. "companyNo" => $outinfo['companyNo'],
  548. "good_num" => $outinfo['good_num'],
  549. "wsend_num" => $outinfo['good_num'],
  550. "send_num" => 0,
  551. "wait_num" => $outinfo['good_num'],
  552. "status" => 1,
  553. "source" => 1,
  554. ];
  555. $order = Db::name("order_num")->save($data);
  556. if ($order == false) return false;
  557. return true;
  558. }
  559. }