Salezx.php 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\GoodLog;
  4. use app\admin\model\ProcessOrder;
  5. use think\App;
  6. use think\facade\Db;
  7. use app\admin\model\ActionLog;
  8. class Salezx extends \app\BaseController
  9. {
  10. public $post="";
  11. public function __construct(App $app)
  12. {
  13. parent::__construct($app);
  14. $this->post=$this->request->post();
  15. }
  16. public function create(){
  17. $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):"";
  18. $orderCode=makeNo("QR");
  19. $customer_code= isset($this->post['customer_code'])&& $this->post['customer_code'] !=="" ? trim($this->post['customer_code']) :"";
  20. if($customer_code==""){
  21. return error_show(1002,"客户code不能为空");
  22. }
  23. $zxinfoNo= isset($this->post['zxinfoNo'])&& $this->post['zxinfoNo'] !=="" ? trim($this->post['zxinfoNo']) :"";
  24. if($zxinfoNo==""){
  25. return error_show(1002,"参数zxinfoNo 不能为空");
  26. }
  27. $customer=Db::name("customer_info")->where(["companyNo"=>$customer_code])->find();
  28. if($customer==false){
  29. return error_show(1004,"未找到客户数据");
  30. }
  31. $supplierNo= isset($this->post['supplierNo']) && $this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  32. if($supplierNo==""){
  33. return error_show(1002,"参数supplierNo不能为空");
  34. }
  35. $supplier=Db::name("business")->where(["companyNo"=>$supplierNo])->find();
  36. if($supplier==false){
  37. return error_show(1004,"未找到平台供应商数据");
  38. }
  39. $sendtype =isset($this->post['sendtype']) && $this->post['sendtype'] !=="" ?trim($this->post['sendtype']):"";
  40. if($sendtype==''){
  41. return error_show(1004,"参数sendtype不能为空");
  42. }
  43. $platform_id =isset($this->post['platform_id']) && $this->post['platform_id'] !=="" ?intval($this->post['platform_id']):"";
  44. if($platform_id==''){
  45. return error_show(1004,"参数platform_id不能为空");
  46. }
  47. $platform_order =isset($this->post['platform_order']) && $this->post['platform_order'] !=="" ?trim($this->post['platform_order']):"";
  48. if($platform_order==''){
  49. return error_show(1004,"参数platform_order不能为空");
  50. }
  51. $good_code =isset($this->post['good_code']) && $this->post['good_code'] !=="" ?trim($this->post['good_code']):"";
  52. if($good_code==''){
  53. return error_show(1004,"参数good_code不能为空");
  54. }
  55. $good=Db::name("good_zixun")->where(["spuCode"=>$good_code])->find();
  56. if($good==false){
  57. return error_show(1004,"未找到商品数据");
  58. }
  59. $goodinfo = Db::name("consult_bids")->where(["spuCode"=>$good['spuCode'],"is_del"=>0])->find();
  60. if($goodinfo==false){
  61. return error_show(1004,"未找到商品数据");
  62. }
  63. $good_num =isset($this->post['good_num']) && $this->post['good_num'] !=="" ?intval($this->post['good_num']):"";
  64. if($good_num===''){
  65. return error_show(1004,"参数good_num不能为空");
  66. }
  67. $good_num =isset($this->post['p']) && $this->post['good_num'] !=="" ?intval($this->post['good_num']):"";
  68. if($good_num===''){
  69. return error_show(1004,"参数good_num不能为空");
  70. }
  71. // $goodtype =isset($this->post['goodtype']) && $this->post['goodtype'] !=="" ?intval($this->post['goodtype']):"";
  72. // if($goodtype===''){
  73. // return error_show(1004,"参数goodtype不能为空");
  74. // }
  75. $arrtime = isset($this->post['arrtime'])&&$this->post['arrtime']!="" ?$this->post['arrtime']:"";
  76. if($arrtime==""){
  77. return error_show(1004,"参数arrtime不能为空");
  78. }
  79. $remark =isset($this->post['remark']) && $this->post['remark'] !=="" ?trim($this->post['remark']):"";
  80. if($sendtype==1){
  81. $addrlist = isset($this->post['addrlist']) && $this->post['addrlist'] !=="" ?$this->post['addrlist']:"";
  82. if($addrlist=="" || empty($addrlist) ||!is_array($addrlist)){
  83. return error_show(1004,"参数addrlist不能为空");
  84. }
  85. }
  86. $apply_id =GetUserInfo($token);
  87. if(empty($apply_id)||$apply_id['code']!=0){
  88. return error_show(1002,"申请人数据不存在");
  89. }
  90. $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  91. $ri= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  92. Db::startTrans();
  93. try {
  94. $data=[
  95. "orderCode"=>$orderCode,
  96. "good_code"=>$good_code,
  97. "customer_code"=>$customer_code,
  98. "good_name"=>isset($good['good_name'])&&$good['good_name']!==''?$good['good_name']:'',
  99. "good_num"=>$good_num,
  100. "cat_id"=>$goodinfo['cat_id'],
  101. "apply_id"=>$rm,
  102. "apply_name"=>$ri,
  103. "origin_price"=>$goodinfo['total_fee'],
  104. "sale_price"=>$goodinfo['sale_price'],
  105. "post_fee"=>0,
  106. "status"=>0,
  107. "send_num"=>0,
  108. "wsend_num"=>$good_num,
  109. "send_status"=>1,
  110. "good_type"=>1,
  111. "send_type"=>$sendtype,
  112. "supplierNo"=>$supplierNo,
  113. "is_del"=>0,
  114. "zxNo"=>$zxinfoNo,
  115. "platform_order"=>$platform_order,
  116. "platform_id"=>$platform_id,
  117. "remark"=>$remark,
  118. "order_type"=>2,//非库存品
  119. "order_source"=>2,//咨询
  120. "addtime"=>date("Y-m-d H:i:s"),
  121. "updatetime"=>date("Y-m-d H:i:s"),
  122. 'total_price'=>round($goodinfo['sale_price']*$good_num,2),
  123. ];
  124. $datainfo = Db::name('sale')->insert($data,true);
  125. $vat=[];
  126. if($datainfo>0){
  127. $standing_bood_data=[
  128. "orderCode"=>$orderCode,
  129. "sale_id"=>$datainfo,
  130. "customer_code"=>$customer_code,
  131. "supplierNo"=>$supplierNo,
  132. "order_type"=>$data['order_type'],
  133. "order_source"=>$data['order_source'],
  134. "spuCode"=>$good_code,
  135. 'updatetime'=>date("Y-m-d H:i:s"),
  136. ];
  137. $bol= $this->createCgd($data,$good,$goodinfo,$standing_bood_data);
  138. if($bol==false){
  139. Db::rollback();
  140. return error_show(1002,"咨询订单创建失败");
  141. }
  142. if($sendtype!=2){
  143. foreach ($addrlist as $value){
  144. $temp=[];
  145. $addrs=[];
  146. if($value['addr_code']!==''&&is_array($value['addr_code'])){
  147. $addrs['provice_code'] = $value['addr_code'][0];
  148. $addrs['city_code'] = $value['addr_code'][1];
  149. $addrs['area_code'] = $value['addr_code'][2];
  150. $addr = json_encode($addrs);
  151. }else{
  152. $addr = isset($value['addr_code'])?$value['addr_code']:'';
  153. }
  154. $temp['orderCode']=$orderCode;
  155. $temp['contactor']=$value['contactor'];
  156. $temp['mobile'] = $value['mobile'];
  157. $temp['addr'] = $value['addr'];
  158. $temp['addr_code']=$addr;
  159. $temp['customer_code'] =$customer_code;
  160. $temp['receipt_quantity']=$value['receipt_quantity'];
  161. $temp['post_fee'] =0;
  162. $temp['is_del'] =0;
  163. $temp['addtime'] =date("Y-m-d H:i:s");
  164. $temp['updatetime'] =date("Y-m-d H:i:s");
  165. $temp['arrive_time']=$value['arrive_time'];
  166. $vmp = Db::name('order_addr')->insert($temp,true);
  167. if($vmp>0){
  168. $outCode=makeNo("DF");
  169. $out=[
  170. "orderCode"=>$orderCode,
  171. "outCode"=>$outCode,
  172. "apply_id"=>$rm,
  173. "apply_name"=>$ri,
  174. "addrid"=>$vmp,
  175. "post_name"=>"",
  176. "post_code"=>"",
  177. "post_fee"=>0,
  178. "sendtime"=>date("Y-m-d H:i:s"),
  179. "send_num"=>$value['receipt_quantity'],
  180. "check_num"=>0,
  181. "error_num"=>0,
  182. "wsm_code"=>"",
  183. "order_type"=>2,
  184. "status"=>0,
  185. "addtime"=>date("Y-m-d H:i:s"),
  186. "updatetime"=>date("Y-m-d H:i:s")
  187. ];
  188. $ou =Db::name("order_out")->insert($out);
  189. if($ou==false){
  190. Db::rollback();
  191. return error_show(1002,"咨询订单创建失败");
  192. }else{
  193. //修改状态,添加待办
  194. ActionLog::logAdd($this->post['token'], [
  195. "order_code" => $outCode,//出库单号
  196. "status" => $out['status'],//这里的status是之前的值
  197. "action_remark" => '',//备注
  198. "action_type" => "create"//新建create,编辑edit,更改状态status
  199. ], "CKD", $out['status'], $out);
  200. ProcessOrder::AddProcess($this->post['token'], [
  201. "order_type" => 'CKD',
  202. "order_code" => $outCode,//出库单号
  203. "order_id" => 0,
  204. "order_status" => $out['status']
  205. ]);
  206. $standing_bood_data['outCode'][]=$outCode;
  207. }
  208. }else{
  209. Db::rollback();
  210. return error_show(1002,"咨询订单创建失败");
  211. }
  212. }
  213. }
  214. //修改状态,添加待办
  215. ActionLog::logAdd($this->post['token'], [
  216. "order_code" => $orderCode,//销售单code
  217. "status" => 0,//这里的status是之前的值
  218. "action_remark" => '',//备注
  219. "action_type" => "create"//新建create,编辑edit,更改状态status
  220. ], "XSQRD", 0, $data);
  221. ProcessOrder::AddProcess($this->post['token'], [
  222. "order_type" => 'XSQRD',
  223. "order_code" => $orderCode,//销售单code
  224. "order_id" => $datainfo,
  225. "order_status" => 0
  226. ]);
  227. //根据zxinfoNo查找infoNo,找到则更新台账,否则就新增台账
  228. if (isset($standing_bood_data['outCode'])) $standing_bood_data['outCode'] = implode(',', $standing_bood_data['outCode']);
  229. $infoNo = Db::name('consult_bids')->where('bidNo', $zxinfoNo)->value('infoNo');
  230. if (empty($infoNo)) Db::name('standing_book')->insert(array_merge($standing_bood_data, ['addtime' => date('Y-m-d H:i:s'), 'standBookNo' => makeNo("IO")]));
  231. else Db::name('standing_book')->where('infoNo', $infoNo)->update($standing_bood_data);
  232. Db::commit();
  233. return error_show(0,"咨询订单创建成功");
  234. }
  235. Db::rollback();
  236. return error_show(1002,"咨询订单创建失败");
  237. }catch(\Exception $e){
  238. Db::rollback();
  239. return error_show(1005,$e->getMessage());
  240. }
  241. }
  242. public function createCgd($data,$good,$good_info,array &$standing_bood_data=[]){
  243. $cgdCode = makeNo("CG");
  244. $supplier=Db::name("supplier")->where(["code"=>$good['supplierNo'],"is_del"=>0])->find();
  245. if($supplier==false){
  246. return false;
  247. }
  248. $wsm= Db::name("warehouse_info")->where(["supplierNo"=>$good["supplierNo"],"companyNo"=>$data['supplierNo'],"is_del"=>0])->find();
  249. if($wsm==false){
  250. $wsm_code = makeNo("WSM");
  251. $inwsm=[
  252. "wsm_code"=>$wsm_code,
  253. "name"=>$supplier['name'],
  254. "wsm_type"=>2,
  255. "supplierNo"=>$supplier['code'],
  256. "addr"=>"",
  257. "addrs_code"=>"",
  258. "contactor"=>0,
  259. "contactor_name"=>0,
  260. "mobile"=>"",
  261. "position"=>"",
  262. "companyNo"=>$data['supplierNo'],
  263. "status"=>1,
  264. "is_del"=>0,
  265. "addtime"=>date("Y-m-d H:i:s"),
  266. "updatetime"=>date("Y-m-d H:i:s")
  267. ];
  268. $in = Db::name("warehouse_info")->insert($inwsm);
  269. if($in==false){
  270. return false;
  271. }
  272. }else{
  273. $wsm_code =$wsm['wsm_code'];
  274. }
  275. $cg =["cgdNo"=>$cgdCode,
  276. "bkcode"=>"",
  277. "wsm_code"=>$wsm_code,
  278. "cgder"=>$supplier['person'],
  279. "cgder_id"=>$supplier['personid'],
  280. "good_code"=>$good['spuCode'],
  281. "good_name"=>$good['good_name'],
  282. "good_num"=>$data['good_num'],
  283. "good_price"=>$good_info['sale_price'],
  284. "total_fee"=>$good_info['total_fee'],
  285. "pakge_fee"=>$good_info['pakge_fee'],
  286. "cert_fee"=>$good_info['cert_fee'],
  287. "open_fee"=>$good_info['open_fee'],
  288. "delivery_fee"=>$good_info['delivery_fee'],
  289. "mark_fee"=>$good_info['mark_fee'],
  290. "demo_fee"=>$good_info['demo_fee'],
  291. #"weight"=>$data['weight'],
  292. "diff_weight"=>"0",
  293. "diff_fee"=>"0",
  294. "gold_price"=>"0",
  295. "supplierNo"=>$good['supplierNo'],
  296. "supplier_name"=>$supplier['name'],
  297. "send_status"=>1,
  298. "send_num"=>"0",
  299. "wsend_num"=>$data['good_num'],
  300. "remark"=>"",
  301. "status"=>0,
  302. "lasttime"=>date("Y-m-d H:i:s"),
  303. "is_del"=>0,
  304. "order_type"=>$data['order_type'],
  305. "order_source"=>$data['order_source'],
  306. "good_type"=>$good['good_type'],
  307. "addtime"=>date("Y-m-d H:i:s"),
  308. "updatetime"=>date("Y-m-d H:i:s")
  309. ];
  310. $up =Db::name("purchease_order")->insert($cg,true);
  311. if($up){
  312. //修改状态,添加待办
  313. ActionLog::logAdd($this->post['token'], [
  314. "order_code" => $cg['cgdNo'],//销售单code
  315. "status" => 0,//这里的status是之前的值
  316. "action_remark" => '',//备注
  317. "action_type" => "create"//新建create,编辑edit,更改状态status
  318. ], "CGD", $cg['status'], $cg);
  319. ProcessOrder::AddProcess($this->post['token'], [
  320. "order_type" => 'CGD',
  321. "order_code" => $cg['cgdNo'],//销售单code
  322. "order_id" => $up,
  323. "order_status" => $cg['status']
  324. ]);
  325. $standing_bood_data['cgdNo']=$cgdCode;
  326. return true;
  327. }else{
  328. return false;
  329. }
  330. }
  331. // public function edit(){
  332. // $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):"";
  333. //
  334. // $zxNo=isset($this->post['id']) && $this->post['id'] !=="" ?intval($this->post['id']):"";
  335. // if($zxNo==''){
  336. // return error_show(1004,"参数id不能为空");
  337. // }
  338. // $saleinfo = Db::name("sale")->where(["id"=>$zxNo,"is_del"=>0])->find();
  339. // if($saleinfo==false){
  340. // return error_show(1003,"未找到咨询单数据");
  341. // }
  342. // $zxinfo = Db::name("consult")->where(["zxNo"=>$saleinfo['zxNo'],"is_del"=>0])->find();
  343. // if($zxinfo==false){
  344. // return error_show(1004,"未找到咨询单数据");
  345. // }
  346. // $customer_code= $this->post['customer_code'] && $this->post['customer_code'] !=="" ? trim($this->post['customer_code']) :"";
  347. // if($customer_code==""){
  348. // return error_show(1002,"客户code不能为空");
  349. // }
  350. // $customer=Db::name("customer_info")->where(["companyNo"=>$customer_code])->find();
  351. // if($customer==false){
  352. // return error_show(1004,"未找到客户数据");
  353. // }
  354. // $supplierNo= $this->post['supplierNo'] && $this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  355. // if($supplierNo==""){
  356. // return error_show(1002,"参数supplierNo不能为空");
  357. // }
  358. // $supplier=Db::name("supplier")->where(["code"=>$supplierNo])->find();
  359. // if($supplier==false){
  360. // return error_show(1004,"未找到平台供应商数据");
  361. // }
  362. // $wsm=Db::name("warehouse_info")->where(["supplierNo"=>$zxinfo['gysNo'],"wsm_type"=>2])->find();
  363. // if(empty($wsm)){
  364. // return error_show(1004,"未找到供应商仓库数据");
  365. // }
  366. // $sendtype =isset($this->post['sendtype']) && $this->post['sendtype'] !=="" ?trim($this->post['sendtype']):"";
  367. // if($sendtype==''){
  368. // return error_show(1004,"参数sendtype不能为空");
  369. // }
  370. // $good_num =isset($this->post['good_num']) && $this->post['good_num'] !=="" ?intval($this->post['good_num']):"";
  371. // if($good_num===''){
  372. // return error_show(1004,"参数good_num不能为空");
  373. // }
  374. // $goodtype =isset($this->post['goodtype']) && $this->post['goodtype'] !=="" ?intval($this->post['goodtype']):"";
  375. // if($goodtype===''){
  376. // return error_show(1004,"参数goodtype不能为空");
  377. // }
  378. // $remark =isset($this->post['remark']) && $this->post['remark'] !=="" ?trim($this->post['remark']):"";
  379. // if($sendtype!=2){
  380. // $addrlist = isset($this->post['addrlist']) && $this->post['addrlist'] !=="" ?$this->post['addrlist']:"";
  381. // if($addrlist=="" || empty($addrlist)){
  382. // return error_show(1004,"参数addrlist不能为空");
  383. // }
  384. // }
  385. // $apply_id =GetUserInfo($token);
  386. // if(empty($apply_id)||$apply_id['code']!=0){
  387. // return error_show(1002,"申请人数据不存在");
  388. // }
  389. // $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  390. // $ri= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  391. // Db::startTrans();
  392. // try {
  393. // $data=[
  394. // "customer_code"=>$customer_code,
  395. // "good_num"=>$good_num,
  396. // "apply_id"=>$rm,
  397. // "apply_name"=>$ri,
  398. // "wsend_num"=>$good_num,
  399. // "good_type"=>$goodtype,
  400. // "send_type"=>$sendtype,
  401. // "supplierNo"=>$supplierNo,
  402. // "remark"=>$remark,
  403. // "updatetime"=>date("Y-m-d H:i:s"),
  404. // 'total_price'=>round($zxinfo['last_price']*$good_num,2),
  405. // ];
  406. // $datainfo = Db::name('sale')->where(["id"=>$zxNo])->save($data);
  407. // if($datainfo!=false){
  408. // $st = ["order_code"=>$saleinfo['orderCode'],"status"=>0,"action_remark"=>'',"action_type"=>"edit"];
  409. // ActionLog::logAdd($this->post['token'],$st,"ZXQRD",0,$data);
  410. // $order=["order_type"=>"ZXQRD","order_code"=>$saleinfo['orderCode'],"order_id"=>$saleinfo['id'],"order_status"=>$saleinfo['status']];
  411. // ProcessOrder::AddProcess($this->post['token'],$order);
  412. // $saleinfos=[
  413. // "wsm_code"=>$wsm['wsm_code'],
  414. // "num"=>$good_num,
  415. // "sale_price"=>$zxinfo['last_price'],
  416. // "total_price"=>round($zxinfo['last_price']*$good_num,2),
  417. // "updatetime"=>date("Y-m-d H:i:s"),
  418. // ];
  419. // $info = Db::name("sale_info")->where(["orderCode"=>$saleinfo['orderCode']])->save($saleinfos);
  420. // if($info==false){
  421. // Db::rollback();
  422. // return error_show(1002,"咨询订单创建失败");
  423. // }
  424. // if($sendtype!=2){
  425. // foreach ($addrlist as $value){
  426. // $temp=[];
  427. // $addrs=[];
  428. // if($value['addr_code']!==''&&is_array($value['addr_code'])){
  429. // $addrs['provice_code'] = $value['addr_code'][0];
  430. // $addrs['city_code'] = $value['addr_code'][1];
  431. // $addrs['area_code'] = $value['addr_code'][2];
  432. // $addr = json_encode($addrs);
  433. // }else{
  434. // $addr = isset($value['addr_code'])?$value['addr_code']:'';
  435. // }
  436. // isset($value["id"])&&$value["id"]!=""? $temp['id']=$value['id']:"";
  437. // $temp['contactor']=$value['contactor'];
  438. // $temp['mobile'] = $value['mobile'];
  439. // $temp['addr'] = $value['addr'];
  440. // $temp['addr_code']=$addr;
  441. // $temp['orderCode']=$saleinfo['orderCode'];
  442. // $temp['customer_code'] =$customer_code;
  443. // $temp['receipt_quantity']=$value['receipt_quantity'];
  444. // $temp['post_fee'] =0;
  445. // $temp['is_del'] =$value['is_del'];
  446. // $temp['updatetime'] =date("Y-m-d H:i:s");
  447. // isset($value["id"])&&$value["id"]!=""?"":$temp['addtime'] =date("Y-m-d H:i:s");
  448. // $temp['arrive_time']=$value['arrive_time'];
  449. // $vmp = Db::name('order_addr')->save($temp);
  450. // if(!$vmp){
  451. // Db::rollback();
  452. // return error_show(0,"咨询订单地址更新失败");
  453. // }
  454. // }
  455. // }else{
  456. // if($saleinfo['send_type']==1 && $sendtype==2){
  457. // $up=Db::name('order_addr')->where(["orderCode"=>$saleinfo['orderCode']])->save(["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")]);
  458. // if(!$up){
  459. // Db::rollback();
  460. // return error_show(0,"咨询订单地址更新失败");
  461. // }
  462. // }
  463. // }
  464. // Db::commit();
  465. // return error_show(0,"咨询订单更新成功");
  466. // }
  467. // Db::rollback();
  468. // return error_show(1002,"咨询订单更新失败");
  469. // }catch(\Exception $e){
  470. // Db::rollback();
  471. // return error_show(1005,$e->getMessage());
  472. // }
  473. // }
  474. public function out(){
  475. $token= isset($this->post['token']) && $this->post['token'] !=="" ? trim($this->post['token']) :"";
  476. $outCode = isset($this->post['outCode']) && $this->post['outCode'] !=="" ? trim($this->post['outCode']) :"";
  477. if($outCode==""){
  478. return error_show(1002,"参数outCode不能为空");
  479. }
  480. $der = Db::name('order_out')->where(['outCode'=>$outCode])->find();
  481. if($der==""){
  482. return error_show(1002,"未找到出库单数据");
  483. }
  484. $order= Db::name('sale')->where(['orderCode'=>$der['orderCode']])->find();
  485. if(empty($order)){
  486. return error_show(1002,"未找到咨询订单信息");
  487. }
  488. $stock= Db::name("good_stock")->where(["spuCode"=>$order['good_code'],"wsm_code"=>$der['wsm_code']])
  489. ->find();
  490. if(empty($stock)){
  491. return error_show(1002,"未找到仓库库存信息");
  492. }
  493. if($der['send_num'] > $stock['wait_out_stock']){
  494. return error_show(1002,"仓库库存不足");
  495. }
  496. $post_name= isset($this->post['post_name']) && $this->post['post_name'] !=="" ? trim($this->post['post_name']) :"";
  497. if($post_name==""){
  498. return error_show(1002,"物流公司不能为空");
  499. }
  500. $post_code = isset($this->post['post_code']) && $this->post['post_code'] !=="" ? trim($this->post['post_code']) :"";
  501. if($post_code==""){
  502. return error_show(1002,"物流单号不能为空");
  503. }
  504. $post_fee = isset($this->post['post_fee']) && $this->post['post_fee'] !=="" ? intval($this->post['post_fee']) :"";
  505. if($post_fee==""){
  506. return error_show(1002,"物流费不能为空");
  507. }
  508. $sendtime = isset($this->post['sendtime']) && $this->post['sendtime'] !=="" ? $this->post['sendtime']:date("Y-m-d H:i:s");
  509. // $status = isset($this->post['status']) && $this->post['status'] !=="" ? $this->post['status'] :"1";
  510. Db::startTrans();
  511. try {
  512. $var = $der['status'];
  513. $der['post_name'] = $post_name;
  514. $der['post_code'] = $post_code;
  515. $der['post_fee'] = $post_fee;
  516. $der['sendtime'] = $sendtime;
  517. $der['status'] = 1;
  518. $der['updatetime'] = date("Y-m-d H:i:s");
  519. $datainfo = Db::name('order_out')->save($der);
  520. $st = ["order_code"=>$outCode,"status"=>$var,"action_remark"=>'',"action_type"=>"edit"];
  521. ActionLog::logAdd($this->post['token'],$st,"resign_info",$der['status'] ,$st);
  522. if($datainfo) {
  523. $st = ["order_code"=>$der['outCode'],"status"=>$var,"action_remark"=>'',"action_type"=>"edit"];
  524. ActionLog::logAdd($this->post['token'],$st,"CKD",1,$der);
  525. $ord=["order_type"=>"CKD","order_code"=>$der['outCode'],"order_id"=>$der['id'], "order_status"=>$der['status']];
  526. ProcessOrder::AddProcess($this->post['token'],$ord);
  527. // $send =Db::name("order_out")->where(["wsm_code"=>$der['wsm_code'],'orderCode'=>$der['orderCode']])->sum("send_num");
  528. // $order['send_num']+= $der['send_num'];
  529. // $order['wsend_num']-=$der['send_num'] ;//($der['send_num'])?$der['wsend_num'] =="" ? $der['send']
  530. // $order['send_status']=$order['send_num']==0 ? 1 :($order['wsend_num']==0?3:2);
  531. // $order['status']=$order['send_num']==0 ? 2 :($order['wsend_num']==0?4:3);
  532. // $order['updatetime'] = date("Y-m-d H:i:s");
  533. // $si = Db::name('sale')->save($order);
  534. // if($si==false){
  535. // Db::rollback();
  536. // return error_show(1003,"更新失败");
  537. // }
  538. $str = Db::name('good_stock')->where(['wsm_code' => $der['wsm_code'],'spuCode'=>$order['good_code']])
  539. ->find();
  540. if ($str == false) {
  541. Db::rollback();
  542. return error_show(1002, "商品数据未找到");
  543. }
  544. if ($der['send_num'] > $str['wait_out_stock']) {
  545. Db::rollback();
  546. return error_show(1002, "超出库存数量");
  547. }
  548. $str['wait_out_stock'] -= $der['send_num'];
  549. $str['intra_stock'] += $der['send_num'];
  550. $str['updatetime'] = date("Y-m-d H:i:s");
  551. $stre = Db::name('good_stock')->save($str);
  552. if ($stre == false) {
  553. Db::rollback();
  554. return error_show(1002, "状态更新失败");
  555. }
  556. //商品变动日志表,good_log_code字段存储销售订单编号
  557. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $str['id'], "type" => 1, 'stock' => $der['send_num'], "stock_name" => "intra_stock"];
  558. $good_data[] = ['good_log_code' => $outCode, "stock_id" => $str['id'], "type" => 2, 'stock' => $der['send_num'], "stock_name" => "wait_out_stock"];
  559. GoodLog::LogAdd($this->post['token'], $good_data, 'CKD');
  560. Db::commit();
  561. return error_show(0,"创建成功");
  562. }else{
  563. Db::rollback();
  564. return error_show(1003,"创建失败");
  565. }
  566. }catch (\Exception $e) {
  567. Db::rollback();
  568. return error_show(1005, $e->getMessage());
  569. }
  570. }
  571. public function outaddr(){
  572. $token= isset($this->post['token']) && $this->post['token'] !=="" ? trim($this->post['token']) :"";
  573. $outCode=makeNo("DF");
  574. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !=="" ? trim($this->post['orderCode']) :"";
  575. if($orderCode==""){
  576. return error_show(1002,"参数orderCoder不能为空");
  577. }
  578. $der = Db::name('sale')->where(['orderCode'=>$orderCode])->find();
  579. if($der==""){
  580. return error_show(1002,"未找到出库订单单号");
  581. }
  582. if($der['order_type']!=2){
  583. return error_show(1002,"订单不是咨询单无法出库");
  584. }
  585. $wsm= Db::name('sale_info')->where(['orderCode'=>$der['orderCode']])->find();
  586. if(empty($wsm)){
  587. return error_show(1002,"未找到仓库信息");
  588. }
  589. $apply_id =GetUserInfo($token);
  590. if(empty($apply_id)||$apply_id['code']!=0){
  591. return error_show(1002,"申请人数据不存在");
  592. }
  593. $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  594. $ri= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  595. if($der['send_type']==2){
  596. $contactor= isset($this->post['contactor']) && $this->post['contactor'] !=="" ? trim($this->post['contactor'])
  597. :"";
  598. if($contactor==""){
  599. return error_show(1002,"收货人不能为空");
  600. }
  601. $mobile = isset($this->post['mobile']) && $this->post['mobile'] !=="" ? trim($this->post['mobile'])
  602. :"";
  603. if($mobile==""){
  604. return error_show(1002,"收货人联系方式不能为空");
  605. }
  606. $addr = isset($this->post['addr']) && $this->post['addr'] !=="" ? trim($this->post['addr']) :"";
  607. if($addr==""){
  608. return error_show(1002,"参数addr不能为空");
  609. }
  610. $receipt_quantity= isset($this->post['receipt_quantity']) && $this->post['receipt_quantity'] !=="" ? intval
  611. ($this->post['receipt_quantity']) :"";
  612. if($receipt_quantity===""){
  613. return error_show(1002,"参数receipt_quantity不能为空");
  614. }
  615. $addrcode = isset($this->post['addr_code']) && $this->post['addr_code'] !=="" ? $this->post['addr_code'] :"";
  616. if($addrcode==""){
  617. return error_show(1002,"参数addr_code不能为空");
  618. }
  619. $addrs=[];
  620. if(is_array($addrcode)){
  621. $addrs['provice_code'] = $addrcode['addr_code'][0];
  622. $addrs['city_code'] = $addrcode['addr_code'][1];
  623. $addrs['area_code'] = $addrcode['addr_code'][2];
  624. $addrstr = json_encode($addrs);
  625. }else{
  626. $addrstr = $addrcode;
  627. }
  628. }else{
  629. $addrid = isset($this->post['addrid']) && $this->post['addrid'] !=="" ? intval($this->post['addrid']) :"";
  630. $dr = Db::name('order_addr')->where(['id'=>$addrid,"orderCode"=>$orderCode,'is_del'=>0])->find();
  631. if(empty($dr)){
  632. return error_show(1003,"收货人信息未找到");
  633. }
  634. $receipt_quantity = $dr['receipt_quantity'];
  635. }
  636. // if($send_num>$stock['usable_stock']){
  637. // return error_show(1002,"超出可发货数量");
  638. // }
  639. $sendtime = isset($this->post['sendtime']) && $this->post['sendtime'] !=="" ? $this->post['sendtime']:date("Y-m-d H:i:s");
  640. // $status = isset($this->post['status']) && $this->post['status'] !=="" ? $this->post['status'] :"1";
  641. Db::startTrans();
  642. try {
  643. if($der['send_type']==2){
  644. $addr=[
  645. "orderCode"=>$orderCode,
  646. "addr"=>$addr,
  647. "addr_code"=>$addrstr,
  648. "contactor"=>$contactor,
  649. "mobile"=>$mobile,
  650. "customer_code"=>$der['customer_code'],
  651. "post_fee"=>0,
  652. "is_del"=>0,
  653. "receipt_quantity"=>$receipt_quantity,
  654. "addtime"=>date("Y-m-d H:i:s"),
  655. "updatetime"=>date("Y-m-d H:i:s"),
  656. "arrive_time"=>date("Y-m-d H:i:s"),
  657. ];
  658. $addrid = Db::name('order_addr')->insert($addr,true);
  659. if($addrid<=0){
  660. $st = ["order_code"=>$orderCode,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  661. ActionLog::logAdd($this->post['token'],$st,"zxd",0,$st);
  662. Db::rollback();
  663. return error_show(1003,"创建失败");
  664. }
  665. }
  666. $data=[
  667. "wsm_code"=>$wsm['wsm_code'],
  668. "orderCode"=>$orderCode,
  669. "outCode"=>$outCode,
  670. "order_type"=>$der['order_type'],
  671. "apply_id"=>$rm,
  672. "apply_name"=>$ri,
  673. "addrid"=>$addrid,
  674. "post_name"=>'',
  675. "post_code"=>'',
  676. "post_fee"=>'',
  677. "sendtime"=>$sendtime,
  678. "send_num"=>$receipt_quantity,
  679. "check_num"=>0,
  680. "error_num"=>0,
  681. "status"=>0,
  682. "addtime"=>date("Y-m-d H:i:s"),
  683. "updatetime"=>date("Y-m-d H:i:s")
  684. ];
  685. $datainfo = Db::name('order_out')->insert($data,true);
  686. if($datainfo<=0){
  687. Db::rollback();
  688. return error_show(1003,"创建失败");
  689. }
  690. $sio = ["order_code"=>$outCode,"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  691. ActionLog::logAdd($this->post['token'],$sio,"CKD",0,$data);
  692. $order=["order_type"=>"CKD","order_code"=>$data['outCode'],"order_id"=>$datainfo,"order_status"=>$data['status']];
  693. ProcessOrder::AddProcess($this->post['token'],$order);
  694. $item = $der['status'];
  695. $der['send_num']+= $receipt_quantity;
  696. $der['wsend_num']-=$receipt_quantity;//($der['send_num'])?$der['wsend_num'] =="" ? $der['send']
  697. $der['send_status']=$der['send_num']==0 ? 1 :($der['wsend_num']==0?3:2);
  698. $der['status']=$der['send_num']==0 ? 2 :($der['wsend_num']==0?4:3);
  699. $der['updatetime'] = date("Y-m-d H:i:s");
  700. $si = Db::name('sale')->save($der);
  701. if($si==false){
  702. Db::rollback();
  703. return error_show(1003,"创建失败");
  704. }else{
  705. //修改状态,添加待办
  706. ActionLog::logAdd($this->post['token'], [
  707. "order_code" => $der['orderCode'],//销售单code
  708. "status" => $item,//这里的status是之前的值
  709. "action_remark" => '',//备注
  710. "action_type" => "status"//新建create,编辑edit,更改状态status
  711. ], "XSQRD", $der['status'], $der);
  712. ProcessOrder::AddProcess($this->post['token'], [
  713. "order_type" => 'XSQRD',
  714. "order_code" => $der['orderCode'],//销售单code
  715. "order_id" => $der['id'],
  716. "order_status" => $der['status']
  717. ]);
  718. }
  719. $sio = ["order_code"=>$orderCode,"status"=>$item,"action_remark"=>'',"action_type"=>"edit"];
  720. ActionLog::logAdd($this->post['token'],$sio,"zxd",$der['status'],$der);
  721. $order=["order_type"=>"CKD","order_code"=>$orderCode,"order_id"=>$der['id'],"order_status"=>$der['status']];
  722. ProcessOrder::AddProcess($this->post['token'],$order);
  723. Db::commit();
  724. return error_show(0,"创建成功");
  725. }catch (\Exception $e) {
  726. Db::rollback();
  727. return error_show(1005, $e->getMessage());
  728. }
  729. }
  730. }