Sale.php 85 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\GoodLog;
  4. use app\admin\model\ProcessOrder;
  5. use app\BaseController;
  6. use Exception;
  7. use think\App;
  8. use think\facade\Db;
  9. use app\admin\model\ActionLog;
  10. class Sale extends BaseController
  11. {
  12. public $post = "";
  13. public function __construct(App $app)
  14. {
  15. parent::__construct($app);
  16. $this->post = $this->request->post();
  17. }
  18. public function create()
  19. {
  20. $token = isset($this->post['token']) && $this->post['token'] !=="" ?trim($this->post['token']):"";
  21. $orderCode=makeNo("CX");
  22. $customer_code= isset($this->post['customer_code'])&& $this->post['customer_code'] !=="" ? trim($this->post['customer_code']) :"";
  23. if($customer_code==""){
  24. return error_show(1002,"客户customer_code不能为空");
  25. }
  26. $customer=Db::name("customer_info")->where(["companyNo"=>$customer_code])->find();
  27. if($customer==false){
  28. return error_show(1004,"未找到客户数据");
  29. }
  30. $supplierNo= isset($this->post['supplierNo']) && $this->post['supplierNo'] !=="" ? trim($this->post['supplierNo']) :"";
  31. if($supplierNo==""){
  32. return error_show(1002,"参数supplierNo不能为空");
  33. }
  34. $supplier=Db::name("business")->where(["companyNo"=>$supplierNo])->find();
  35. if($supplier==false){
  36. return error_show(1004,"未找到平台供应商数据");
  37. }
  38. $goodtype =isset($this->post['goodtype']) && $this->post['goodtype'] !=="" ?intval($this->post['goodtype']):"1";
  39. $order_type =isset($this->post['order_type']) && $this->post['order_type'] !=="" ?intval($this->post['order_type'])
  40. :"1";
  41. $sendtype =isset($this->post['sendtype']) && $this->post['sendtype'] !=="" ?intval($this->post['sendtype']):"";
  42. if($sendtype==''){
  43. return error_show(1004,"参数sendtype不能为空");
  44. }
  45. $platform_id =isset($this->post['platform_id']) && $this->post['platform_id'] !=="" ?intval($this->post['platform_id']):"";
  46. if($platform_id==''){
  47. return error_show(1004,"参数platform_id不能为空");
  48. }
  49. $zxinfoNo= isset($this->post['zxinfoNo'])&& $this->post['zxinfoNo'] !=="" ? trim($this->post['zxinfoNo']) :"";
  50. if($zxinfoNo=="" &&$order_type!==1){
  51. return error_show(1002,"参数 zxinfoNo 不能为空");
  52. }
  53. $platform_order =isset($this->post['platform_order']) && $this->post['platform_order'] !=="" ?trim($this->post['platform_order']):"";
  54. if($platform_order==''){
  55. return error_show(1004,"参数platform_order不能为空");
  56. }
  57. $good_code =isset($this->post['good_code']) && $this->post['good_code'] !=="" ?trim($this->post['good_code']):"";
  58. if($good_code==''){
  59. return error_show(1004,"参数good_code不能为空");
  60. }
  61. $good_num =isset($this->post['good_num']) && $this->post['good_num'] !=="" ?intval($this->post['good_num']):"";
  62. if($good_num===''){
  63. return error_show(1004,"参数good_num不能为空");
  64. }
  65. if($order_type==3|| $order_type==4){
  66. // $good=Db::name("good_zixun")->where(["spuCode"=>$good_code])->find();
  67. // if($good==false){
  68. // return error_show(1004,"未找到商品数据");
  69. // }
  70. $goodinfo = Db::name("consult_bids")->where(["spuCode"=>$good_code,"is_del"=>0])->find();
  71. if($goodinfo==false){
  72. return error_show(1004,"未找到商品数据");
  73. }
  74. $spuCode = $goodinfo['spuCode'];
  75. $skuCode = "";
  76. $is_stock=0;
  77. $cgd=[
  78. "supplierNo"=>$goodinfo['supplierNo'],
  79. "companyNo"=>$supplierNo,
  80. "spuCode"=>$good_code,
  81. "orderCode"=>$orderCode,
  82. "good_name"=>$goodinfo['good_name'],
  83. "sale_price"=>$goodinfo['sale_price'],
  84. "total_fee"=>$goodinfo['total_fee'],
  85. "pakge_fee"=>$goodinfo['pakge_fee'],
  86. "cert_fee"=>$goodinfo['cert_fee'],
  87. "open_fee"=>$goodinfo['open_fee'],
  88. "delivery_fee"=>$goodinfo['delivery_fee'],
  89. "mark_fee"=>$goodinfo['mark_fee'],
  90. "demo_fee"=>$goodinfo['demo_fee'],
  91. "good_num"=>$good_num,
  92. "good_type"=>$goodtype,
  93. "order_type"=>$order_type,
  94. ];
  95. }else{
  96. $ct = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  97. ->where(['a.skuCode' => $good_code])->find();
  98. if ($ct == false) {
  99. return error_show(1002, "未找到商品数据");
  100. }
  101. $goodinfo=$ct;
  102. $is_stock=$ct['is_stock'];
  103. $spuCode = $ct['spuCode'];
  104. $skuCode = $ct['skuCode'];
  105. $cgd=[
  106. "supplierNo"=>$ct['supplierNo'],
  107. "companyNo"=>$supplierNo,
  108. "orderCode"=>$orderCode,
  109. "spuCode"=>$ct['spuCode'],
  110. "good_name"=>$ct['good_name'],
  111. "sale_price"=>$ct['sale_price'],
  112. "total_fee"=>$ct['total_fee'],
  113. "pakge_fee"=>$ct['pakge_fee'],
  114. "cert_fee"=>$ct['cert_fee'],
  115. "open_fee"=>$ct['open_fee'],
  116. "delivery_fee"=>$ct['delivery_fee'],
  117. "mark_fee"=>$ct['mark_fee'],
  118. "demo_fee"=>$ct['demo_fee'],
  119. "good_num"=>$good_num,
  120. "good_type"=>$goodtype,
  121. "order_type"=>$order_type,
  122. ];
  123. }
  124. if($order_type==1){
  125. $is_activity= isset($this->post['is_activity'])&&$this->post['is_activity']!=="" ?$this->post['is_activity']:"";
  126. if($is_activity===""){
  127. return error_show(1002, "参数is_activity不能为空");
  128. }
  129. }
  130. // if($goodtype===''){
  131. // return error_show(1004,"参数goodtype不能为空");
  132. // }
  133. $arrtime = isset($this->post['arrtime'])&&$this->post['arrtime']!="" ?$this->post['arrtime']:"";
  134. if($arrtime==""){
  135. return error_show(1004,"参数arrtime不能为空");
  136. }
  137. $remark =isset($this->post['remark']) && $this->post['remark'] !=="" ?trim($this->post['remark']):"";
  138. if($sendtype==1){
  139. $addrlist = isset($this->post['addrlist']) && $this->post['addrlist'] !=="" ?$this->post['addrlist']:"";
  140. if($addrlist=="" || empty($addrlist) ||!is_array($addrlist)){
  141. return error_show(1004,"参数addrlist不能为空");
  142. }
  143. }
  144. $proofid= isset($this->post['proof_id'])&&$this->post['proof_id']===""?intval($this->post['proof_id']):"0";
  145. $apply_id =GetUserInfo($token);
  146. if(empty($apply_id)||$apply_id['code']!=0){
  147. return error_show(1002,"申请人数据不存在");
  148. }
  149. $rm= isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  150. $ri= isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  151. Db::startTrans();
  152. try {
  153. $data=[
  154. "orderCode"=>$orderCode,
  155. "good_code"=>$spuCode,
  156. "sku_code"=>$skuCode,
  157. "customer_code"=>$customer_code,
  158. "good_name"=>isset($goodinfo['good_name'])&&$goodinfo['good_name']!==''?$goodinfo['good_name']:'',
  159. "good_num"=>$good_num,
  160. "cat_id"=>$goodinfo['cat_id'],
  161. "apply_id"=>$rm,
  162. "apply_name"=>$ri,
  163. "origin_price"=>$goodinfo['total_fee'],
  164. "sale_price"=>$goodinfo['sale_price'],
  165. "post_fee"=>0,
  166. "status"=>0,
  167. "send_num"=>0,
  168. "wsend_num"=>$good_num,
  169. "send_status"=>1,
  170. "good_type"=>$goodtype,
  171. "send_type"=>$sendtype,
  172. "supplierNo"=>$supplierNo,
  173. "is_del"=>0,
  174. "zxNo"=>$zxinfoNo,
  175. "platform_order"=>$platform_order,
  176. "platform_id"=>$platform_id,
  177. "remark"=>$remark,
  178. "proof_id"=>$proofid,
  179. "order_type"=>$order_type,
  180. "addtime"=>date("Y-m-d H:i:s"),
  181. "updatetime"=>date("Y-m-d H:i:s"),
  182. 'total_price'=>round($goodinfo['sale_price']*$good_num,2),
  183. ];
  184. $datainfo = Db::name('sale')->insert($data,true);
  185. if($datainfo>0){
  186. if($is_stock==0){
  187. $bol=$this->createCgd($cgd);
  188. }
  189. if($bol==false){
  190. Db::rollback();
  191. return error_show(1002,"咨询订单创建失败");
  192. }
  193. if($order_type==3|| $order_type==4){
  194. $limt=[
  195. "spuCode"=>$goodinfo['spuCode'],
  196. "good_name"=>$goodinfo['good_name'],
  197. "brand_id"=>$goodinfo['brand_id'],
  198. "good_unit"=>$goodinfo['good_name'],
  199. "cat_id"=>$goodinfo['cat_id'],
  200. "good_type"=>0,
  201. "moq"=>1,
  202. "customized"=>$goodinfo['work_day'],
  203. "tax"=>$goodinfo['tax'],
  204. "supplierNo"=>$goodinfo["supplierNo"],
  205. "is_auth"=>0,
  206. "craft_desc"=>$goodinfo['good_name'],
  207. "good_remark"=>"",
  208. "good_img"=>$goodinfo['good_img'],
  209. "good_thumb_img"=>"",
  210. "good_info_img"=>"",
  211. "status"=>1,
  212. "is_del"=>0,
  213. "createrid"=>$rm,
  214. "creater"=>$ri,
  215. "addtime"=>date("Y-m-d H:i:s"),
  216. "updatetime"=>date("Y-m-d H:i:s")
  217. ];
  218. $good = Db::name("good_zixun")->insert($limt);
  219. if(!$good){
  220. Db::rollback();
  221. return error_show(1006,"咨询商品录入失败");
  222. }
  223. }
  224. if($sendtype!=2){
  225. foreach ($addrlist as $value){
  226. $temp=[];
  227. $addrs=[];
  228. if($value['addr_code']!==''&&is_array($value['addr_code'])){
  229. $addrs['provice_code'] = $value['addr_code'][0];
  230. $addrs['city_code'] = $value['addr_code'][1];
  231. $addrs['area_code'] = $value['addr_code'][2];
  232. $addr = json_encode($addrs);
  233. }else{
  234. $addr = isset($value['addr_code'])?$value['addr_code']:'';
  235. }
  236. $temp['orderCode']=$orderCode;
  237. $temp['contactor']=$value['contactor'];
  238. $temp['mobile'] = $value['mobile'];
  239. $temp['addr'] = $value['addr'];
  240. $temp['addr_code']=$addr;
  241. $temp['customer_code'] =$customer_code;
  242. $temp['receipt_quantity']=$value['receipt_quantity'];
  243. $temp['post_fee'] =0;
  244. $temp['is_del'] =0;
  245. $temp['addtime'] =date("Y-m-d H:i:s");
  246. $temp['updatetime'] =date("Y-m-d H:i:s");
  247. $temp['arrive_time']=$arrtime;
  248. $vmp = Db::name('order_addr')->insert($temp,true);
  249. if($vmp>0){
  250. $outCode=makeNo("CK");
  251. $out=[
  252. "orderCode"=>$orderCode,
  253. "outCode"=>$outCode,
  254. "apply_id"=>$rm,
  255. "apply_name"=>$ri,
  256. "addrid"=>$vmp,
  257. "post_name"=>"",
  258. "post_code"=>"",
  259. "post_fee"=>0,
  260. "sendtime"=>date("Y-m-d H:i:s"),
  261. "send_num"=>$value['receipt_quantity'],
  262. "check_num"=>0,
  263. "error_num"=>0,
  264. "wsm_code"=>"",
  265. "order_type"=>$order_type,
  266. "status"=>0,
  267. "addtime"=>date("Y-m-d H:i:s"),
  268. "updatetime"=>date("Y-m-d H:i:s")
  269. ];
  270. $ou =Db::name("order_out")->insert($out);
  271. if($ou==false){
  272. Db::rollback();
  273. return error_show(1002,"咨询订单创建失败");
  274. }
  275. }else{
  276. Db::rollback();
  277. return error_show(1002,"咨询订单创建失败");
  278. }
  279. }
  280. }
  281. Db::commit();
  282. return error_show(0,"咨询订单创建成功",["order_code"=>$orderCode]);
  283. }
  284. Db::rollback();
  285. return error_show(1002,"咨询订单创建失败");
  286. }catch(\Exception $e){
  287. Db::rollback();
  288. return error_show(1005,$e->getMessage());
  289. }
  290. }
  291. public function createCgd($data){
  292. $cgdCode = makeNo("CG");
  293. $supplier=Db::name("supplier")->where(["code"=>$data['supplierNo'],"is_del"=>0])->find();
  294. if($supplier==false){
  295. return false;
  296. }
  297. $wsm= Db::name("warehouse_info")->where(["supplierNo"=>$data["supplierNo"],"companyNo"=>$data['companyNo'],"is_del"=>0])->find();
  298. if($wsm==false){
  299. $wsm_code = makeNo("WSM");
  300. $inwsm=[
  301. "wsm_code"=>$wsm_code,
  302. "name"=>$supplier['name'],
  303. "wsm_type"=>2,
  304. "supplierNo"=>$supplier['code'],
  305. "addr"=>"",
  306. "addrs_code"=>"",
  307. "contactor"=>0,
  308. "contactor_name"=>0,
  309. "mobile"=>"",
  310. "position"=>"",
  311. "companyNo"=>$data['companyNo'],
  312. "status"=>1,
  313. "is_del"=>0,
  314. "addtime"=>date("Y-m-d H:i:s"),
  315. "updatetime"=>date("Y-m-d H:i:s")
  316. ];
  317. $in = Db::name("warehouse_info")->insert($inwsm);
  318. if($in==false){
  319. return false;
  320. }
  321. }else{
  322. $wsm_code =$wsm['wsm_code'];
  323. }
  324. $cg =["cgdNo"=>$cgdCode,
  325. "bkcode"=>"",
  326. "wsm_code"=>$wsm_code,
  327. "cgder"=>$supplier['person'],
  328. "cgder_id"=>$supplier['personid'],
  329. "good_code"=>$data['spuCode'],
  330. "good_name"=>$data['good_name'],
  331. "good_num"=>$data['good_num'],
  332. "good_price"=>$data['sale_price'],
  333. "total_fee"=>$data['total_fee'],
  334. "pakge_fee"=>$data['pakge_fee'],
  335. "cert_fee"=>$data['cert_fee'],
  336. "open_fee"=>$data['open_fee'],
  337. "delivery_fee"=>$data['delivery_fee'],
  338. "mark_fee"=>$data['mark_fee'],
  339. "demo_fee"=>$data['demo_fee'],
  340. #"weight"=>$data['weight'],
  341. "diff_weight"=>"0",
  342. "diff_fee"=>"0",
  343. "gold_price"=>"0",
  344. "supplierNo"=>$data['supplierNo'],
  345. "supplier_name"=>$supplier['name'],
  346. "send_status"=>1,
  347. "send_num"=>"0",
  348. "wsend_num"=>$data['good_num'],
  349. "remark"=>"",
  350. "status"=>0,
  351. "lasttime"=>date("Y-m-d H:i:s"),
  352. "is_del"=>0,
  353. "order_type"=>$data['order_type'],
  354. "good_type"=>$data['good_type'],
  355. "addtime"=>date("Y-m-d H:i:s"),
  356. "updatetime"=>date("Y-m-d H:i:s")
  357. ];
  358. $up =Db::name("purchease_order")->insert($cg);
  359. if($up){
  360. $rela=[
  361. "orderCode"=>$data['orderCode'],
  362. "cgdNo"=>$cgdCode,
  363. "good_num"=>$data['good_num'],
  364. "wsend_num"=>$data['good_num'],
  365. "send_num"=>0,
  366. "wait_num"=>0
  367. ];
  368. $re =Db::name("order_num")->save($rela);
  369. if($re==false){
  370. return false;
  371. }else{
  372. return true;
  373. }
  374. }else{
  375. return false;
  376. }
  377. }
  378. public function list()
  379. {
  380. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
  381. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
  382. $where[] = ['is_del', "=", 0];
  383. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !== "" ? trim($this->post['orderCode']) : "";
  384. if ($orderCode !== "") {
  385. $where[] = ['orderCode', "like", "%$orderCode%"];
  386. }
  387. $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !== "" ? trim($this->post['apply_name'])
  388. : "";
  389. if ($apply_name !== "") {
  390. $where[] = ['apply_name', "like", "%$apply_name%"];
  391. }
  392. $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name'])
  393. : "";
  394. if ($good_name !== "") {
  395. $where[] = ['good_name', "like", "%$good_name%"];
  396. }
  397. $good_code = isset($this->post['good_code']) && $this->post['good_code'] !== "" ? trim($this->post['good_code']) : "";
  398. if ($good_code !== "") {
  399. $where[] = ['good_code', "like", "%$good_code%"];
  400. }
  401. $customer_code = isset($this->post['customer_code']) && $this->post['customer_code'] !== "" ? trim($this->post['customer_code']) : "";
  402. if ($customer_code !== "") {
  403. $where[] = ['customer_code', "like", "%$customer_code%"];
  404. }
  405. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
  406. if ($supplierNo !== "") {
  407. $where[] = ['supplierNo', "like", "%$supplierNo%"];
  408. }
  409. $ordertype = isset($this->post['order_type']) && $this->post['order_type'] !== "" ? intval($this->post['order_type'])
  410. : "";
  411. if ($ordertype !== "") {
  412. $where[] = ['order_type', "=", $ordertype];
  413. }
  414. $status = isset($this->post['status']) && $this->post['status'] !== "" ? trim($this->post['status']) : "";
  415. if ($status !== "") {
  416. $where[] = ['status', "=", $status];
  417. }
  418. $start = isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start'] : "";
  419. if ($start != "") {
  420. $where[] = ["addtime", '>=', $start];
  421. }
  422. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] : "";
  423. if ($end != "") {
  424. $where[] = ["addtime", '<=', $end];
  425. }
  426. $count = Db::name('sale')->where($where)->count();
  427. $total = ceil($count / $size);
  428. $page = $page >= $total ? $total : $page;
  429. $list = Db::name('sale')->where($where)->order("addtime desc")->page($page, $size)->select();
  430. $data = [];
  431. foreach ($list as $value) {
  432. if($value['order_type']==3|| $value['order_type']==4){
  433. $var = Db::name("good_zixun")->where(["spuCode"=>$value['good_code'],"is_del"=>0])->find();
  434. }else {
  435. $var = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  436. ->where(['a.skuCode' => $value['sku_code']])->find();
  437. }
  438. $value['can'] = isset($var['cat_id']) && $var['cat_id'] != 0 ? made($var['cat_id']) : [];
  439. $value['supplierName'] = '';
  440. if ($value['supplierNo'] != "") {
  441. $supplier = Db::name("business")->where(["companyNo" => $value['supplierNo']])->find();
  442. $value['supplierName'] = isset($supplier['company']) ? $supplier['company'] : "";
  443. }
  444. $value['customerName'] = '';
  445. if ($value['customer_code'] != "") {
  446. $supplier = Db::name("customer_info")->where(["companyNo" => $value['customer_code']])->find();
  447. $value['customerName'] = isset($supplier['companyName']) ? $supplier['companyName'] : "";
  448. }
  449. $data[] = $value;
  450. }
  451. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  452. }
  453. public function edit()
  454. {
  455. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  456. $id = isset($this->post['id']) && $this->post['id'] !== "" ? trim($this->post['id']) : "";
  457. if ($id == "") {
  458. return error_show(1002, "参数id不能为空");
  459. }
  460. $etid = Db::name("sale")->where(["id" => $id, "is_del" => 0])->find();
  461. if (empty($etid)) {
  462. return error_show(1002, "未找到数据");
  463. }
  464. // $orderCode=isset($this->post['orderCode']) && $this->post['orderCode'] !=="" ? trim($this->post['orderCode']) :"";
  465. // if($orderCode==""){
  466. // return error_show(1002,"销售单code不能为空");
  467. // }
  468. $good_code = isset($this->post['good_code']) && $this->post['good_code'] !== "" ? trim($this->post['good_code']) : "";
  469. if ($good_code == "") {
  470. return error_show(1002, "商品code不能为空");
  471. }
  472. $ct = Db::name('good')->alias('a')->join('good_type b', 'b.good_code=a.good_code', 'left')
  473. ->where(['b.type_code' => $good_code])->find();
  474. if ($ct == "") {
  475. return error_show(1002, "未找到商品数据");
  476. }
  477. $customer_code = isset($this->post['customer_code']) && $this->post['customer_code'] !== "" ? trim($this->post['customer_code']) : "";
  478. if ($customer_code == "") {
  479. return error_show(1002, "客户code不能为空");
  480. }
  481. $customer = Db::name("customer_info")->where(["companyNo" => $customer_code])->find();
  482. if ($customer == false) {
  483. return error_show(1004, "未找到客户数据");
  484. }
  485. $supplierNo = $this->post['supplierNo'] && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
  486. if ($supplierNo == "") {
  487. return error_show(1002, "参数supplierNo不能为空");
  488. }
  489. $supplier = Db::name("supplier")->where(["code" => $supplierNo])->find();
  490. if ($supplier == false) {
  491. return error_show(1004, "未找到平台供应商数据");
  492. }
  493. $apply_id = GetUserInfo($token);
  494. if (empty($apply_id) || $apply_id['code'] != 0) {
  495. return error_show(1002, "申请人数据不存在");
  496. }
  497. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  498. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  499. // $good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim
  500. //($this->post['good_name']) : "";
  501. // $good_num = isset($this->post['good_num']) && $this->post['good_num'] !== "" ? intval
  502. //($this->post['good_num']) : "";
  503. // $origin_price = isset($this->post['origin_price']) && $this->post['origin_price'] !== "" ? intval
  504. // ($this->post['origin_price']) : "";
  505. // $sale_price = isset($this->post['sale_price']) && $this->post['sale_price'] !== "" ? trim($this->post['sale_price']) : "";
  506. // $total_price = isset($this->post['total_price']) && $this->post['total_price'] !== "" ? trim($this->post['total_price']) : "";
  507. // $post_fee = isset($this->post['post_fee']) && $this->post['post_fee'] !== "" ? trim($this->post['post_fee']) : "";
  508. // $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
  509. $vr = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  510. if ($vr == "") {
  511. return error_show(1002, "参数order_addr不能为空");
  512. }
  513. $vi = isset($this->post['good_stock']) && $this->post['good_stock'] !== "" ? $this->post['good_stock'] : "";
  514. if ($vi == "") {
  515. return error_show(1002, "参数good_stock不能为空");
  516. }
  517. $good_num = intval(array_sum(array_column($vi, "num")));
  518. Db::startTrans();
  519. try {
  520. $datn = [
  521. "id" => $id,
  522. "good_code" => $good_code,
  523. "customer_code" => $customer_code,
  524. "good_num" => $good_num,
  525. "supplierNo" => $supplierNo,
  526. "apply_id" => $rm,
  527. "apply_name" => $ri,
  528. "is_del" => 0,
  529. "updatetime" => date("Y-m-d H:i:s")
  530. ];
  531. $datninfo = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->save($datn);
  532. if ($datninfo > 0) {
  533. $stn = ["order_code"=>$etid['orderCode'],"status"=>$etid['status'],"action_remark"=>'',"action_type"=>"edit"];
  534. ActionLog::logAdd($this->post['token'],$stn,"XSQRD",$etid['status'],$datn);
  535. $order=["order_type"=>'XSQRD',"order_code"=>$etid['orderCode'],"order_id"=>$id,"order_status"=>$etid['status']];
  536. ProcessOrder::AddProcess($this->post['token'],$order);
  537. foreach ($vi as $ion) {
  538. $iten = [];
  539. isset($ion['id']) && $ion['id'] !== "" ? $iten['id'] = $ion['id'] : '';
  540. $iten['orderCode'] = $etid['orderCode'];
  541. $iten['wsm_code'] = $ion['wsm_code'];
  542. $iten['stock_id'] = 0;
  543. $iten['num'] = $ion['num'];
  544. $iten['status'] = 1;
  545. $iten['sale_price'] = $ct['original_price'];
  546. isset($ion['id']) && $ion['id'] !== "" ? '' : $iten['addtime'] = date("Y-m-d H:i:s");
  547. $iten['updatetime'] = date("Y-m-d H:i:s");
  548. $vp = Db::name('sale_info')->save($iten);
  549. if ($vp == false)
  550. {
  551. Db::rollback();
  552. return error_show(1002, "更新失败");
  553. }
  554. }
  555. foreach ($vr as $value) {
  556. $temp = [];
  557. isset($value['id']) && $value['id'] !== "" ? $temp['id'] = $value['id'] : '';
  558. $temp['orderCode'] = $etid['orderCode'];
  559. $temp['contactor'] = $value['contactor'];
  560. $temp['mobile'] = $value['mobile'];
  561. $temp['addr'] = $value['addr'];
  562. $temp['addr_code'] = $value['addr_code'];
  563. $temp['customer_code'] = $customer_code;
  564. $temp['receipt_quantity'] = $value['receipt_quantity'];
  565. $temp['post_fee'] = 0;
  566. $temp['is_del'] = $value['is_del'];
  567. isset($value['id']) && $value['id'] !== "" ? '' : $temp['addtime'] = date("Y-m-d H:i:s");
  568. $temp['updatetime'] = date("Y-m-d H:i:s");
  569. $temp['arrive_time'] = date("Y-m-d H:i:s");
  570. $dat = Db::name('order_addr')->save($temp);
  571. if ($dat == false) {
  572. Db::rollback();
  573. return error_show(1002, "更新失败");
  574. }
  575. }
  576. Db::commit();
  577. return error_show(0, "更新成功");
  578. }
  579. Db::rollback();
  580. return error_show(1002, "更新失败");
  581. } catch (Exception $e) {
  582. Db::rollback();
  583. return error_show(1005, $e->getMessage());
  584. }
  585. }
  586. public function info()
  587. {
  588. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  589. if ($id == "") {
  590. return error_show(1002, "参数id不能为空");
  591. }
  592. //->field('good_code,good_name,good_num,customer_code,orderCode')
  593. $einfo = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->find();
  594. if (empty($einfo)) {
  595. return error_show(1002, "未找到销售订单数据");
  596. }
  597. $info = Db::name('sale_diff')->where(['orderCode' => $einfo['orderCode']])->select();
  598. //$de = Db::name('order_out')->where(['orderCode' => $einfo['orderCode']])->select();
  599. $dm = Db::name('order_return')->where(['orderCode' => $einfo['orderCode']])->select();
  600. $dk = Db::name('order_back')->where(['orderCode' => $einfo['orderCode']])->select();
  601. $sa = Db::name('sale_return')->where(['orderCode' => $einfo['orderCode']])->select();
  602. if($einfo['order_type']==3|| $einfo['order_type']==4){
  603. $goon = Db::name("good_zixun")->where(["spuCode"=>$einfo['good_code'],"is_del"=>0])->find();
  604. }else {
  605. $goon = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  606. ->where(['a.skuCode' => $einfo['sku_code']])->find();
  607. }
  608. if ($goon==false) {
  609. return error_show(1003, "未找到商品数据");
  610. }
  611. $int = isset($goon['cat_id']) && $goon['cat_id'] != 0 ? made($goon['cat_id']) : [];
  612. $in = Db::name('customer_info')->where(['companyNo' => $einfo['customer_code']])->field('companyName')->find();
  613. // ->field('addr,contactor,mobile,receipt_quantity,arrive_time')
  614. $einfo['supplierName'] = '';
  615. if ($einfo['supplierNo'] != "") {
  616. $supplier = Db::name("bussiness")->where(["companyNo" => $einfo['supplierNo']])->find();
  617. $einfo['supplierName'] = isset($supplier['company']) ? $supplier['company'] : "";
  618. }
  619. $fo = Db::name('order_addr')->where(['orderCode' => $einfo['orderCode'], 'is_del' => 0])->select();
  620. $bum = Db::name('order_out')->where(['orderCode' => $einfo['orderCode']])->select();
  621. $ins = [];
  622. if (!empty($bum)) {
  623. foreach ($bum as $stn) {
  624. $so = Db::name('order_addr')->where(['id' => $stn['addrid']])->find();
  625. $addr = GetAddr($so['addr_code']);
  626. $stn['addr_info'] = $addr;
  627. $stn['add_code'] = json_decode($so['addr_code'], true);
  628. $stn['addr'] = $so['addr'];
  629. $stn['contact'] = $so['contactor'];
  630. $stn['mobile'] = $so['mobile'];
  631. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b", "a.supplierNo=b.code")
  632. ->where(["a.wsm_code" => $stn['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find();
  633. $stn['wsm_name'] = isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name'] : "";
  634. $stn['wsm_supplier'] = isset($wsmcode['name']) ? $wsmcode['name'] : "";
  635. $stn['wsm_supplierNo'] = isset($wsmcode['code']) ? $wsmcode['code'] : "";
  636. $ins[] = $stn;
  637. }
  638. }
  639. $addrs = [];
  640. if (!empty($fo)) {
  641. foreach ($fo as $value) {
  642. $value['addr_info'] = "";
  643. $value['send_num'] = 0;
  644. if ($value['addr_code'] != "") {
  645. $addr = GetAddr($value['addr_code']);
  646. $value['addr_info'] = $addr;
  647. $value['addr_code'] = json_decode($value['addr_code'], true);
  648. $send = Db::name("order_out")->where(['addrid' => $value['id'], 'orderCode' => $einfo['orderCode']])->sum("send_num");
  649. $value['send_num'] = $send ?? 0;
  650. }
  651. $value['wsend_num'] = $value['receipt_quantity'] - $value['send_num'];
  652. $addrs[] = $value;
  653. }
  654. }
  655. //->field('num,sale_price,wsm_code,stock_id')
  656. $st = Db::name('sale_info')->where(['orderCode' => $einfo['orderCode']])->select();
  657. $data = [];
  658. if (!empty($fo)) {
  659. foreach ($st as $value) {
  660. $value['wsm_name'] = "";
  661. $value['wsm_supplier'] = "";
  662. $value['wsm_supplierNo'] = "";
  663. $value['usable_stock'] = 0;
  664. $value['send_num'] = 0;
  665. if ($value['wsm_code'] != "") {
  666. $wsmcode = Db::name("warehouse_info")->alias("a")->leftJoin("supplier b", "a.supplierNo=b.code")
  667. ->where(["a.wsm_code" => $value['wsm_code']])->field("a.name as wsm_name,b.name,b.code")->find();
  668. $value['wsm_name'] = isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name'] : "";
  669. $value['wsm_supplier'] = isset($wsmcode['name']) ? $wsmcode['name'] : "";
  670. $value['wsm_supplierNo'] = isset($wsmcode['code']) ? $wsmcode['code'] : "";
  671. $dn = Db::name('good_stock')->where(['wsm_code' => $value['wsm_code'], 'good_type_code' => $einfo['good_code']])->find();
  672. $value['usable_stock'] = isset($dn['usable_stock']) ? $dn['usable_stock'] : "0";
  673. $send = Db::name("order_out")->where(["wsm_code" => $value['wsm_code'], 'orderCode' => $einfo['orderCode']])->sum("send_num");
  674. $value['send_num'] = $send ?? 0;
  675. }
  676. $value['wsend_num'] = $value['num'] - $value['send_num'];
  677. $data[] = $value;
  678. }
  679. }
  680. $einfo['info'] = $data;
  681. $einfo['companyName'] = isset($in['companyName']) ? $in['companyName'] : "";
  682. $einfo['addrs'] = $addrs;
  683. $einfo['orderout'] = $ins;
  684. $einfo['can'] = $int;
  685. $einfo['salediff'] = $info;
  686. //$einfo['orderout'] = $de;
  687. $einfo['orderreturn'] = $dm;
  688. $einfo['orderback'] = $dk;
  689. $einfo['salereturn'] = $sa;
  690. if (empty($einfo)) {
  691. return error_show(1002, "未找到销售订单数据");
  692. } else {
  693. return app_show(0, "获取成功", $einfo);
  694. }
  695. }
  696. public function del()
  697. {
  698. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  699. if ($id === "") {
  700. return error_show(1002, "参数id不能为空");
  701. }
  702. $ed = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->find();
  703. if (empty($ed)) {
  704. return error_show(1002, "未找到销售订单数据");
  705. }
  706. $str = Db::name('sale')->update(['id' => $id, 'is_del' => 1, 'updatetime' => date("Y-m-d H:i:s")]);
  707. if ($str) {
  708. $stc = ["order_code"=>$id,"status"=>$ed['status'],"action_remark"=>'',"action_type"=>"delete"];
  709. ActionLog::logAdd($this->post['token'],$stc,"XSQRD",$ed['status'],['id' => $id, 'is_del' => 1, 'updatetime' => date("Y-m-d H:i:s")]);
  710. $order=["order_type"=>'XSQRD',"order_code"=>$ed['orderCode'],"order_id"=>$id,"order_status"=>$ed['status']];
  711. ProcessOrder::workdel($order);
  712. return error_show(0, "删除成功");
  713. } else {
  714. return error_show(1002, "删除失败");
  715. }
  716. }
  717. public function status()
  718. {
  719. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  720. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  721. if ($id == "") {
  722. return error_show(1002, "参数id不能为空");
  723. }
  724. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
  725. if ($status == "") {
  726. return error_show(1002, "订单状态不能为空");
  727. }
  728. $dio = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->find();
  729. if (empty($dio)) {
  730. return error_show(1002, "销售单信息未找到");
  731. }
  732. if ($status == 1 && $dio['order_type'] == 2) {
  733. $zxinfo = Db::name("consult")->where(["zxNo" => $dio['zxNo'], "is_del" => 0])->find();
  734. if ($zxinfo == false) {
  735. return error_show(1004, "未找到咨询单数据");
  736. }
  737. $gold['price'] = 0;
  738. if ($zxinfo['zx_type'] == 2) {
  739. if ($zxinfo['metals'] == "") {
  740. return error_show(1004, "未找到咨询单贵金属类型数据");
  741. }
  742. $metals = $zxinfo['metals'] == '18K' ? 1 : ($zxinfo['metals'] == '24K' ? 2 : 3);
  743. $gold = Db::name("gold_price")->where(["type" => $metals])->order("addtime desc")->find();
  744. if (empty($gold)) {
  745. return error_show(1004, "未找到咨询单贵金属类型数据");
  746. }
  747. $dio['gold_price'] = $gold['price'];
  748. }
  749. $wsm = Db::name("warehouse_info")->where(["supplierNo" => $zxinfo['gysNo'], "wsm_type" => 2])->find();
  750. if (empty($wsm)) {
  751. return error_show(1002, "供应商仓库未找到");
  752. }
  753. }
  754. $apply_id = GetUserInfo($token);
  755. if (empty($apply_id) || $apply_id['code'] != 0) {
  756. return error_show(1002, "申请人数据不存在");
  757. }
  758. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  759. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  760. Db::startTrans();
  761. try {
  762. $vmp =$dio['status'];
  763. $dio['status'] = $status;
  764. $dio['updatetime'] = date("Y-m-d H:i:s");
  765. $st = Db::name('sale')->save($dio);
  766. if ($st) {
  767. $stn = ["order_code"=>$dio['orderCode'],"status"=>$vmp,"action_remark"=>'',"action_type"=>"status"];
  768. ActionLog::logAdd($this->post['token'],$stn, $dio['order_type'] == 2?"ZXQRD":"XSQRD",$dio['status'],$dio);
  769. $order=["order_type"=>$dio['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$dio['orderCode'],"order_id"=>$id,"order_status"=>$dio['status']];
  770. ProcessOrder::AddProcess($this->post['token'],$order);
  771. if ($status == 3 && $dio['order_type'] == 1) {
  772. $dn = Db::name('sale_info')->where(['orderCode' => $st['orderCode']])->select();
  773. foreach ($dn as $value) {
  774. $dm = Db::name('good_stock')->where(['wsm_code' => $value['wsm_code'], 'good_type_code' => $st['good_code']])->find();
  775. if ($dm == "") {
  776. Db::rollback();
  777. return error_show(1003, "未找到商品数据");
  778. }
  779. if ($value['num'] > $dm['usable_stock']) {
  780. Db::rollback();
  781. return error_show(1002, "超出库存数量");
  782. }
  783. $dm['usable_stock'] -= $value['num'];
  784. $dm['wait_out_stock'] += $value['num'];
  785. $send = Db::name("order_out")->where(["wsm_code" => $value['wsm_code']])->sum("send_num");
  786. $value['send_num'] = $send ?? 0;
  787. $value['wsend_num'] = $value['num'] - $value['send_num'];
  788. $Db = Db::name('good_stock')->update($dm);
  789. $Db['updatetime'] = date('Y-m-d H:i:s');
  790. if ($Db == false) {
  791. Db::rollback();
  792. return error_show(1002, "状态更新失败");
  793. }
  794. }
  795. }
  796. if ($status == 1 && $dio['order_type'] == 2) {
  797. $cgd = makeNo("CG");
  798. $clll = [
  799. "cgdNo" => $cgd,
  800. "bkcode" => $dio['orderCode'],
  801. "wsm_code" => $wsm['wsm_code'],
  802. "cgder_id" => "0",
  803. "cgder" => $zxinfo['saler'],
  804. "good_code" => "GD-" . $zxinfo['cpNo'],
  805. "good_name" => $zxinfo['cpName'],
  806. "good_type_code" => $zxinfo['cpNo'],
  807. "good_num" => $dio['good_num'],
  808. "good_price" => $zxinfo['total_fee'],
  809. "total_fee" => round($zxinfo['total_fee'] * $dio['good_num'], 2),
  810. "pakge_fee" => $zxinfo['package_fee'],
  811. "cert_fee" => $zxinfo['cert_fee'],
  812. "open_fee" => $zxinfo['open_fee'],
  813. "delivery_fee" => $zxinfo['delivery_fee'],
  814. "mark_fee" => $zxinfo['mark_fee'],
  815. "teach_fee" => $zxinfo['cost_fee'],
  816. "demo_fee" => $zxinfo['demo_fee'],
  817. "nake_fee" => $zxinfo['bare_fee'],
  818. "weight" => isset($zxinfo['weight']) ? $zxinfo['weight'] : 0,
  819. "supplierNo" => $zxinfo['gysNo'],
  820. "supplier_name" => $zxinfo['gysname'],
  821. "gold_price" => $gold['price'],
  822. "send_num" => 0,
  823. "wsend_num" => $dio['good_num'],
  824. "remark" => '',
  825. "lasttime" => date("Y-m-d H:i:s"),
  826. "is_del" => 0,
  827. "status" => $dio['send_type'] == 1 ? 3 : 0,
  828. "order_type" => 2,
  829. "addtime" => date("Y-m-d H:i:s"),
  830. "updatetime" => date("Y-m-d H:i:s")
  831. ];
  832. $cgin = Db::name("purchease_order")->insert($clll);
  833. // var_dump(Db::name("purchease_order")->getLastSql(),$clll);
  834. if ($cgin == false) {
  835. $stb = ["order_code"=>$cgd,"status"=> $clll['status'],"action_remark"=>'',"action_type"=>"create"];
  836. ActionLog::logAdd($this->post['token'],$stb,"xsd", $clll['status'],$stb);
  837. Db::rollback();
  838. return error_show(1002, "咨询采购单创建商品失败");
  839. }
  840. if ($dio['send_type'] == 1) {
  841. $addr = Db::name('order_addr')->where(["orderCode" => $dio['orderCode'], 'is_del' => 0])->select();
  842. foreach ($addr as $value) {
  843. $outCode = makeNo("CK");
  844. $data = [
  845. "wsm_code" => $wsm['wsm_code'],
  846. "orderCode" => $dio['orderCode'],
  847. "outCode" => $outCode,
  848. "order_type" => $dio['order_type'],
  849. "apply_id" => $rm,
  850. "apply_name" => $ri,
  851. "addrid" => $value['id'],
  852. "post_name" => '',
  853. "post_code" => '',
  854. "post_fee" => '',
  855. "sendtime" => date("Y-m-d H:i:s"),
  856. "send_num" => $value['receipt_quantity'],
  857. "check_num" => 0,
  858. "error_num" => 0,
  859. "status" => 0,
  860. "addtime" => date("Y-m-d H:i:s"),
  861. "updatetime" => date("Y-m-d H:i:s")
  862. ];
  863. $datainfo = Db::name('order_out')->insert($data);
  864. if (!$datainfo) {
  865. $sti = ["order_code"=>$dio['orderCode'],"status"=> 0,"action_remark"=>'',"action_type"=>"create"];
  866. ActionLog::logAdd($this->post['token'],$sti,"xsd",0,$sti);
  867. Db::rollback();
  868. return error_show(1003, "创建失败");
  869. }
  870. }
  871. $wsm_in_code = makeNo("IC");
  872. $orin = [
  873. "wsm_in_code" => $wsm_in_code,
  874. "cgdNo" => $cgd,
  875. "wsm_code" => $wsm['wsm_code'],
  876. "wsm_reaper" => "",
  877. "send_num" => $dio['good_num'],
  878. "post_company" => '',
  879. "post_code" => '',
  880. "post_fee" => '',
  881. "sendtime" => date("Y-m-d H:i:s"),
  882. "apply_id" => $rm,
  883. "apply_name" => $ri,
  884. "wait_num" => 0,
  885. "status" => 4,
  886. "addtime" => date("Y-m-d H:i:s"),
  887. "updatetime" => date("Y-m-d H:i:s")
  888. ];
  889. $win = Db::name("purchease_in")->insert($orin);
  890. if (!$win){
  891. $stv = ["order_code"=>$wsm_in_code,"status"=>4,"action_remark"=>'',"action_type"=>"create"];
  892. ActionLog::logAdd($this->post['token'],$stv,"xsd",4,$stv);
  893. Db::rollback();
  894. return error_show(1003, "创建失败");
  895. }
  896. $good = Db::name("good_stock")->where(["wsm_code" => $wsm['wsm_code'], "good_type_code" => $zxinfo['cpNo'], "is_del" => 0])->find();
  897. if (empty($good)) {
  898. $good = [
  899. "good_type_code" => $zxinfo['cpNo'],
  900. "wsm_code" => $wsm['wsm_code'],
  901. "usable_stock" => 0,
  902. "wait_out_stock" => 0,
  903. "total_stock" => 0,
  904. "addtime" => date("Y-m-d H:i:s"),
  905. "updatetime" => date("Y-m-d H:i:s"),
  906. ];
  907. }
  908. $good['wait_out_stock'] += $dio['good_num'];
  909. $good['total_stock'] = $good['usable_stock'] + $good['wait_out_stock'];
  910. $good['updatetime'] = date("Y-m-d H:i:s");
  911. $upd = Db::name("good_stock")->save($good);
  912. if (!$upd) {
  913. $ste = ["order_code"=> $zxinfo['cpNo'],"status"=>0,"action_remark"=>'',"action_type"=>"create"];
  914. ActionLog::logAdd($this->post['token'],$ste,"xsd",0,$ste);
  915. Db::rollback();
  916. return error_show(1003, "创建失败");
  917. }
  918. }
  919. }
  920. }
  921. Db::commit();
  922. return error_show(0, "订单状态更新成功");
  923. } catch (Exception $e) {
  924. Db::rollback();
  925. return error_show(1005, $e->getMessage());
  926. }
  927. }
  928. public function fee()
  929. {
  930. $id = isset($this->post['id']) && $this->post['id'] !== "" ? trim($this->post['id']) : "";
  931. if ($id == "") {
  932. return error_show(1002, "参数id不能为空");
  933. }
  934. $etid = Db::name("sale")->where(["id" => $id, "is_del" => 0])->find();
  935. if (empty($etid)) {
  936. return error_show(1002, "未找到数据");
  937. }
  938. $vr = isset($this->post['order_addr']) && $this->post['order_addr'] !== "" ? $this->post['order_addr'] : "";
  939. if ($vr == "") {
  940. return error_show(1002, "参数order_addr不能为空");
  941. }
  942. Db::startTrans();
  943. try {
  944. $data = [
  945. "id" => $id,
  946. "status" => 2,
  947. "is_del" => 0,
  948. "updatetime" => date("Y-m-d H:i:s")
  949. ];
  950. $datainfo = Db::name('sale')->where(['id' => $id, 'is_del' => 0])->save($data);
  951. if ($datainfo) {
  952. $stx = ["order_code"=> $etid['orderCode'],"status"=>$etid['status'],"action_remark"=>'',
  953. "action_type"=>"edit"];
  954. ActionLog::logAdd($this->post['token'],$stx,$etid['order_type'] == 2?"ZXQRD":"XSQRD",2,$data);
  955. $order=["order_type"=>$etid['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$etid['orderCode'],"order_id"=>$id,"order_status"=>$data['status']];
  956. ProcessOrder::AddProcess($this->post['token'],$order);
  957. foreach ($vr as $value) {
  958. $tm = [];
  959. $tm['id'] = $value['id'];
  960. $tm['orderCode'] = $etid['orderCode'];
  961. $tm['post_fee'] = $value['post_fee'];
  962. $tm['updatetime'] = date("Y-m-d H:i:s");
  963. $dn = Db::name('order_addr')->save($tm);
  964. if ($dn == false) {
  965. Db::rollback();
  966. return error_show(1002, "更新失败");
  967. }
  968. }
  969. Db::commit();
  970. return error_show(0, "更新成功");
  971. }
  972. Db::rollback();
  973. return error_show(1003, "更新失败");
  974. } catch (Exception $e) {
  975. Db::rollback();
  976. return error_show(1005, $e->getMessage());
  977. }
  978. }
  979. public function out()
  980. {
  981. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  982. $outCode = makeNo("CK");
  983. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !== "" ? trim($this->post['orderCode']) : "";
  984. if ($orderCode == "") {
  985. return error_show(1002, "参数orderCoder不能为空");
  986. }
  987. $der = Db::name('sale')->where(['orderCode' => $orderCode])->find();
  988. if ($der == "") {
  989. return error_show(1002, "未找到出库订单单号");
  990. }
  991. // $wsm_code = isset($this->post['wsm_code']) && $this->post['wsm_code'] !== "" ? trim($this->post['wsm_code']) : "";
  992. // if ($wsm_code == "") {
  993. // return error_show(1002, "参数wsm_code不能为空");
  994. // }
  995. // $wsm = Db::name('sale_info')->where(['wsm_code' => $wsm_code, 'orderCode' => $der['orderCode']])->find();
  996. // if ($wsm == "") {
  997. // return error_show(1002, "未找到仓库编码");
  998. // }
  999. $post_name = isset($this->post['post_name']) && $this->post['post_name'] !== "" ? trim($this->post['post_name']) : "";
  1000. if ($post_name == "") {
  1001. return error_show(1002, "物流公司不能为空");
  1002. }
  1003. $post_code = isset($this->post['post_code']) && $this->post['post_code'] !== "" ? trim($this->post['post_code']) : "";
  1004. if ($post_code == "") {
  1005. return error_show(1002, "物流单号不能为空");
  1006. }
  1007. $post_fee = isset($this->post['post_fee']) && $this->post['post_fee'] !== "" ? intval($this->post['post_fee']) : "";
  1008. if ($post_fee == "") {
  1009. return error_show(1002, "物流费不能为空");
  1010. }
  1011. $send_num = isset($this->post['send_num']) && $this->post['send_num'] !== "" ? $this->post['send_num'] : "";
  1012. if ($send_num == "") {
  1013. return error_show(1002, "发货数量不能为空");
  1014. }
  1015. if ($send_num > $der['wsend_num']) {
  1016. return error_show(1002, "超出可发货数量");
  1017. }
  1018. $apply_id = GetUserInfo($token);
  1019. if (empty($apply_id) || $apply_id['code'] != 0) {
  1020. return error_show(1002, "申请人数据不存在");
  1021. }
  1022. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  1023. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  1024. $addrid = isset($this->post['addrid']) && $this->post['addrid'] !== "" ? intval($this->post['addrid']) : "";
  1025. $dr = Db::name('order_addr')->where(['id' => $addrid, 'is_del' => 0])->find();
  1026. if (empty($dr)) {
  1027. return error_show(1003, "收货人信息未找到");
  1028. }
  1029. if ($dr['orderCode'] !== $orderCode) {
  1030. return error_show(1002, "订单code不存在");
  1031. }
  1032. $sendtime = isset($this->post['sendtime']) && $this->post['sendtime'] !== "" ? $this->post['sendtime'] : date("Y-m-d H:i:s");
  1033. // $check_num = isset($this->post['check_num']) && $this->post['check_num'] !=="" ? $this->post['check_num'] :"";
  1034. // $error_num = isset($this->post['error_num']) && $this->post['error_num'] !=="" ? $this->post['error_num'] :"";
  1035. $status = isset($this->post['status']) && $this->post['status'] !== "" ? $this->post['status'] : "1";
  1036. //$order_type = isset($this->post['order_type']) && $this->post['order_type'] !=="" ? $this->post['order_type'] :"1";
  1037. //$dn=Db::name('sale_info')->where(['wsm_code'=>$outCode])->find();
  1038. Db::startTrans();
  1039. try {
  1040. $data = [
  1041. "wsm_code" => $wsm_code,
  1042. "orderCode" => $orderCode,
  1043. "outCode" => $outCode,
  1044. "order_type" => $der['order_type'],
  1045. "apply_id" => $rm,
  1046. "apply_name" => $ri,
  1047. "addrid" => $dr['id'],
  1048. "post_name" => $post_name,
  1049. "post_code" => $post_code,
  1050. "post_fee" => $post_fee,
  1051. "sendtime" => $sendtime,
  1052. "send_num" => $send_num,
  1053. "check_num" => 0,
  1054. "error_num" => 0,
  1055. "status" => $status,
  1056. "addtime" => date("Y-m-d H:i:s"),
  1057. "updatetime" => date("Y-m-d H:i:s")
  1058. ];
  1059. $datainfo = Db::name('order_out')->insert($data,true);
  1060. if ($datainfo>0) {
  1061. $stx = ["order_code"=>$outCode,"status"=>$status,"action_remark"=>'',"action_type"=>"create"];
  1062. ActionLog::logAdd($this->post['token'],$stx,$der['order_type']==1?"CKD":'ZXCKD',$status,$data);
  1063. $order=["order_type"=>$der['order_type']==1?"CKD":'ZXCKD',"order_code"=>$outCode,"order_id"=>$datainfo,"order_status"=>$data['status']];
  1064. ProcessOrder::AddProcess($this->post['token'],$order);
  1065. if ($status == 1) {
  1066. $var = Db::name('sale_info')->where(['orderCode' => $orderCode, 'wsm_code' => $wsm_code])->find();
  1067. if ($var == "") {
  1068. return error_show(1002, "未找到数据");
  1069. }
  1070. // $send = Db::name("order_out")->where(["wsm_code" => $wsm_code, 'orderCode' => $orderCode])->sum
  1071. //("send_num");
  1072. $item =$der['status'];
  1073. $der['send_num'] += $send_num;
  1074. $der['wsend_num'] -= $send_num;//($der['send_num'])?$der['wsend_num'] =="" ? $der['send']
  1075. $der['send_status'] = $der['send_num'] == 0 ? 1 : $der['wsend_num'] == 0 ? 3 : 2;
  1076. $der['status'] = $der['send_num'] == 0 ? 3 : $der['wsend_num'] == 0 ? 5 : 4;
  1077. $der['updatetime'] = date("Y-m-d H:i:s");
  1078. $si = Db::name('sale')->save($der);
  1079. if ($si == false) {
  1080. Db::rollback();
  1081. return error_show(1003, "更新失败");
  1082. }
  1083. $stx = ["order_code"=>$orderCode,"status"=>$item,"action_remark"=>'',"action_type"=>"edit"];
  1084. ActionLog::logAdd($this->post['token'],$stx,$der['order_type'] == 2?"ZXQRD":"XSQRD",$der['status'],$der);
  1085. $order=["order_type"=>$der['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$orderCode,"order_id"=>$der['id'],"order_status"=>$data['status']];
  1086. ProcessOrder::AddProcess($this->post['token'],$order);
  1087. $str = Db::name('good_stock')->where(['wsm_code' => $var['wsm_code'], 'good_type_code' => $der['good_code']])->find();
  1088. if ($str == false) {
  1089. Db::rollback();
  1090. return error_show(1002, "商品数据未找到");
  1091. }
  1092. if ($send_num > $str['wait_out_stock']) {
  1093. Db::rollback();
  1094. return error_show(1002, "超出库存数量");
  1095. }
  1096. $str['wait_out_stock'] -= $send_num;
  1097. $str['intra_stock'] += $send_num;
  1098. $str['updatetime'] = date("Y-m-d H:i:s");
  1099. $stre = Db::name('good_stock')->save($str);
  1100. if ($stre == false) {
  1101. Db::rollback();
  1102. return error_show(1002, "状态更新失败");
  1103. }
  1104. $good_data[]= ["stock_id"=>$str['id'],"type"=>2,'stock'=>$send_num,"stock_name"=>"wait_out_stock"];
  1105. $good_data[]= ["stock_id"=>$str['id'],"type"=>1,'stock'=>$send_num,"stock_name"=>"intra_stock"];
  1106. GoodLog::LogAdd($this->post['token'],$good_data,$der['order_type'] == 2?"ZXQRD":"XSQRD");
  1107. }
  1108. Db::commit();
  1109. return error_show(0, "创建成功");
  1110. } else {
  1111. Db::rollback();
  1112. return error_show(1003, "创建失败");
  1113. }
  1114. } catch (Exception $e) {
  1115. Db::rollback();
  1116. return error_show(1005, $e->getMessage());
  1117. }
  1118. }
  1119. public function customer()
  1120. {
  1121. $outCode = isset($this->post['outCode']) && $this->post['outCode'] !== "" ? trim($this->post['outCode']) : "";
  1122. if (empty($outCode)) {
  1123. return error_show(1002, "销售订单编号不能为空");
  1124. }
  1125. $codeinfo = Db::name('order_out')->where(['outCode' => $outCode])->find();
  1126. if ($codeinfo == "") {
  1127. return error_show(1003, "未找到订单数据");
  1128. }
  1129. // $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !=="" ? trim($this->post['orderCode']) :"";
  1130. // if($orderCode==""){
  1131. // return error_show(1002,"参数orderCoder不能为空");
  1132. // }
  1133. $dr = Db::name('sale')->where(['orderCode' => $codeinfo['orderCode']])->find();
  1134. if ($dr == "") {
  1135. return error_show(1002, "未找到销售订单");
  1136. }
  1137. $status = isset($this->post['status']) && $this->post['status'] !== "" ? $this->post['status'] : "";
  1138. if ($status == "") {
  1139. return error_show(10002, "状态不能为空");
  1140. }
  1141. Db::startTrans();
  1142. try {
  1143. $time = $codeinfo['status'];
  1144. $codeinfo['status'] = $status;
  1145. $codeinfo['updatetime'] = date("Y-m-d H:i:s");
  1146. $cust = Db::name('order_out')->save($codeinfo);
  1147. if ($cust) {
  1148. $stx = ["order_code"=>$outCode,"status"=>$time,"action_remark"=>'',"action_type"=>"status"];
  1149. ActionLog::logAdd($this->post['token'],$stx,$codeinfo['order_type'] == 2?"ZXCKD":"CKD",$codeinfo['status'],$codeinfo);
  1150. $order=["order_type"=>$codeinfo['order_type'] == 2?"ZXCKD":"CKD","order_code"=>$outCode,
  1151. "order_id"=>$codeinfo['id'],"order_status"=>$codeinfo['status']];
  1152. ProcessOrder::AddProcess($this->post['token'],$order);
  1153. if ($status == 1) {
  1154. $var = Db::name('sale_info')->where(['orderCode' =>$codeinfo['orderCode'], 'wsm_code' =>$codeinfo['wsm_code']])->find();
  1155. //var_dump(Db::name('sale_info')->getLastSql());
  1156. if ($var == "") {
  1157. return error_show(1002, "未找到数据");
  1158. }
  1159. // $send = Db::name("order_out")->where(["wsm_code" => $wsm_code, 'orderCode' => $orderCode])->sum
  1160. //("send_num");
  1161. $item =$dr['status'];
  1162. $dr['send_num'] +=$codeinfo['send_num'];
  1163. $dr['wsend_num'] -= $codeinfo['send_num'];//($der['send_num'])?$der['wsend_num'] =="" ? $der['send']
  1164. $dr['send_status'] = $dr['send_num'] == 0 ? 1 : $dr['wsend_num'] == 0 ? 3 : 2;
  1165. $dr['status'] = $dr['send_num'] == 0 ? 3 : $dr['wsend_num'] == 0 ? 5 : 4;
  1166. $dr['updatetime'] = date("Y-m-d H:i:s");
  1167. $si = Db::name('sale')->save($dr);
  1168. if ($si == false) {
  1169. Db::rollback();
  1170. return error_show(1003, "更新失败");
  1171. }
  1172. $stx = ["order_code"=>$dr['orderCode'],"status"=>$item,"action_remark"=>'',"action_type"=>"edit"];
  1173. ActionLog::logAdd($this->post['token'],$stx,$dr['order_type'] == 2?"ZXQRD":"XSQRD",$dr['status'],
  1174. $dr);
  1175. $order=["order_type"=>$dr['order_type'] == 2?"ZXQRD":"XSQRD","order_code"=>$dr['orderCode'],"order_id"=>$dr['id'],"order_status"=>$dr['status']];
  1176. ProcessOrder::AddProcess($this->post['token'],$order);
  1177. $str = Db::name('good_stock')->where(['wsm_code' => $var['wsm_code'], 'good_type_code' => $dr['good_code']])->find();
  1178. if ($str == false) {
  1179. Db::rollback();
  1180. return error_show(1002, "商品数据未找到");
  1181. }
  1182. if ($codeinfo['send_num'] > $str['wait_out_stock']) {
  1183. Db::rollback();
  1184. return error_show(1002, "超出库存数量");
  1185. }
  1186. $str['wait_out_stock'] -= $codeinfo['send_num'];
  1187. $str['intra_stock'] += $codeinfo['send_num'];
  1188. $str['updatetime'] = date("Y-m-d H:i:s");
  1189. $stre = Db::name('good_stock')->save($str);
  1190. if ($stre == false) {
  1191. Db::rollback();
  1192. return error_show(1002, "状态更新失败");
  1193. }
  1194. $good_data[]= ["stock_id"=>$str['id'],"type"=>2,'stock'=>$codeinfo['send_num'],"stock_name"=>"wait_out_stock"];
  1195. $good_data[]= ["stock_id"=>$str['id'],"type"=>1,'stock'=>$codeinfo['send_num'],"stock_name"=>"intra_stock"];
  1196. GoodLog::LogAdd($this->post['token'],$good_data,'CKD');
  1197. }
  1198. if ($status == 2) {
  1199. $ct = Db::name('sale_info')->where(['orderCode' => $dr['orderCode'], 'wsm_code' => $codeinfo['wsm_code']])->find();
  1200. if ($ct == false) {
  1201. return error_show(1002, "未找到数据");
  1202. }
  1203. $var = Db::name('good_stock')->where(['wsm_code' => $codeinfo['wsm_code'], 'good_type_code' => $dr['good_code']])->find();
  1204. if ($var == false) {
  1205. Db::rollback();
  1206. return error_show(1002, "未找到商品数据");
  1207. }
  1208. if ($ct['num'] > $var['intra_stock']) {
  1209. Db::rollback();
  1210. return error_show(1003, "超出库存数量");
  1211. }
  1212. $var['intra_stock'] -= $codeinfo['send_num'];
  1213. $var['updatetime'] = date("Y-m-d H:i:s");
  1214. $stre = Db::name('good_stock')->save($var);
  1215. $good_data[]= ["stock_id"=>$var['id'],"type"=>2,'stock'=>$codeinfo['send_num'],"stock_name"=>"intra_stock"];
  1216. GoodLog::LogAdd($this->post['token'],$good_data,$codeinfo['order_type'] == 2?"ZXCKD":"CKD");
  1217. if ($stre == false) {
  1218. Db::rollback();
  1219. return error_show(1002, "状态更新失败");
  1220. }
  1221. }
  1222. Db::commit();
  1223. return error_show(0, "出库订单更新成功");
  1224. } else {
  1225. Db::rollback();
  1226. return error_show(1003, "出库订单更新失败");
  1227. }
  1228. } catch (Exception $e) {
  1229. Db::rollback();
  1230. return error_show(1005, $e->getMessage());
  1231. }
  1232. }
  1233. public function difflist()
  1234. {
  1235. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
  1236. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
  1237. $where = [];
  1238. $cgdNo = isset($this->post['orderCode']) && $this->post['orderCode'] != "" ? trim($this->post['orderCode']) : "";
  1239. if ($cgdNo != "") {
  1240. $where[] = ['a.orderCode', "like", "%$cgdNo%"];
  1241. }
  1242. $diffNo = isset($this->post['diffCode']) && $this->post['diffCode'] != "" ? trim($this->post['diffCode']) : "";
  1243. if ($diffNo != "") {
  1244. $where[] = ['a.diffCode', "like", "%$diffNo%"];
  1245. }
  1246. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
  1247. if ($status !== "") {
  1248. $where[] = ['a.status', "=", $status];
  1249. }
  1250. $start = isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start'] : "";
  1251. if ($start != "") {
  1252. $where[] = ["a.addtime", '>=', $start];
  1253. }
  1254. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] : "";
  1255. if ($end != "") {
  1256. $where[] = ["a.addtime", '<=', $end];
  1257. }
  1258. // $apply_name = isset($this->post['apply_name']) && $this->post['apply_name'] !==""? intval($this->post['apply_name']):"";
  1259. // if($apply_name!==""){
  1260. // $where[]=['a.apply_name',"like","%$apply_name%"];
  1261. // }
  1262. $supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
  1263. if ($supplierNo != "") {
  1264. $supplier = Db::name("supplier")->where([['code', "like", "%$supplierNo%"]])->column('code');
  1265. // if(empty($supplier)){
  1266. // return error_show(1004,"未找到供应商信息");
  1267. // }
  1268. $wsmcode = Db::name("sale")->where([
  1269. "is_del" => 0, "supplierNo" => $supplier])->column("orderCode");
  1270. $where[] = ['a.orderCode', "in", $wsmcode];
  1271. }
  1272. $companyNo =isset($this->post['companyNo']) &&$this->post['companyNo'] !=="" ? trim($this->post['companyNo']):"";
  1273. if($companyNo!=""){
  1274. $where[]=['c.customer_code',"like","%$companyNo%"];
  1275. }
  1276. $count = Db::name('sale_diff')->alias('a')
  1277. ->join("sale c", "c.orderCode=a.orderCode", "left")
  1278. ->join("customer_info v", "v.companyNo=c.customer_code", "left")
  1279. ->join("good b", "b.good_code=a.good_code", "left")
  1280. ->where($where)->count();
  1281. $total = ceil($count / $size);
  1282. $page = $page >= $total ? $total : $page;
  1283. //var_dump( Db::name('sale_diff')->getLastSql());
  1284. $list = Db::name('sale_diff')->alias('a')
  1285. ->join("sale c", "c.orderCode=a.orderCode", "left")
  1286. ->join("customer_info v", "v.companyNo=c.customer_code", "left")
  1287. ->join("good b", "b.good_code=a.good_kode", "left")
  1288. ->where($where)->page($page, $size)->field("a.*,b.cat_id,c.customer_code,v.companyName")
  1289. ->order("a.addtime desc")->select();
  1290. $data = [];
  1291. foreach ($list as $value) {
  1292. $value['can'] = isset($value['cat_id']) && $value['cat_id'] != 0 ? made($value['cat_id']) : [];
  1293. $wsm = Db::name("sale")->alias("a")->Join("supplier b", "a.supplierNo=b.code", "left")->where
  1294. (['a.orderCode' => $value['orderCode'], "a.is_del" => 0])->field("b.code,b.name")->find();
  1295. $value['supplierNo'] = isset($wsm['code']) ? $wsm['code'] : "";
  1296. $value['supplierName'] = isset($wsm['name']) ? $wsm['name'] : "";
  1297. $data[] = $value;
  1298. }
  1299. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  1300. }
  1301. /**
  1302. * @return \think\response\Json|void
  1303. * @throws \think\db\exception\DataNotFoundException
  1304. * @throws \think\db\exception\DbException
  1305. * @throws \think\db\exception\ModelNotFoundException
  1306. */
  1307. public function diffcheck()
  1308. {
  1309. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  1310. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  1311. if ($id === "") {
  1312. return error_show(1004, "参数id不能为空");
  1313. }
  1314. $info = Db::name("sale_diff")->where(["id" => $id])->find();
  1315. if (empty($info)) {
  1316. return error_show(1004, "订单数据未找到");
  1317. }
  1318. $is_act = isset($this->post['is_act']) && $this->post['is_act'] !== "" ? intval($this->post['is_act']) : "";
  1319. if ($is_act === '') {
  1320. return error_show(1004, "参数is_act不能为空");
  1321. }
  1322. $customer_remark = isset($this->post['customer_remark']) && $this->post['customer_remark'] !== "" ? trim($this->post['customer_remark']) : "";
  1323. if ($customer_remark === '') {
  1324. return error_show(1004, "参数customer_remark不能为空");
  1325. }
  1326. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "2";
  1327. $remark = isset($this->post['remark']) && $this->post['remark'] !== "" ? trim($this->post['remark']) : "";
  1328. $item = $info['status'];
  1329. $info['is_act'] = $is_act;
  1330. $info['customer_remark'] = $customer_remark;
  1331. $info['status'] = $status;
  1332. $info['remark'] = $remark;
  1333. $info['updatetime'] = date("Y-m-d H:i:s");
  1334. $up = Db::name("sale_diff")->save($info);
  1335. if ($up) {
  1336. $stx = ["order_code"=>$info["orderCode"],"status"=>$item,"action_remark"=>'',"action_type"=>"edit"];
  1337. ActionLog::logAdd($this->post['token'],$stx,"QRGCD",$info['status'],$info);
  1338. $order=["order_type"=>"QRGCD","order_code"=>$info["orderCode"],"order_id"=>$info['id'],"order_status"=>$info['status']];
  1339. ProcessOrder::AddProcess($this->post['token'],$order);
  1340. return app_show(0, "更新成功");
  1341. } else {
  1342. return error_show(1003, "更新失败");
  1343. }
  1344. }
  1345. /**
  1346. * @return \think\response\Json|void
  1347. * @throws \think\db\exception\DataNotFoundException
  1348. * @throws \think\db\exception\DbException
  1349. * @throws \think\db\exception\ModelNotFoundException
  1350. */
  1351. public function diffstatus()
  1352. {
  1353. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  1354. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  1355. if ($id === "") {
  1356. return error_show(1004, "参数id不能为空");
  1357. }
  1358. $info = Db::name("sale_diff")->where(["id" => $id])->find();
  1359. if (empty($info)) {
  1360. return error_show(1004, "订单数据未找到");
  1361. }
  1362. $status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "3";
  1363. $remark = isset($this->post['remark']) && $this->post['remark'] !== "" ? trim($this->post['remark']) : "";
  1364. $ite=$info['status'];
  1365. $info['status'] = $status;
  1366. $info['remark'] = $remark;
  1367. $info['updatetime'] = date("Y-m-d H:i:s");
  1368. $up = Db::name("sale_diff")->save($info);
  1369. if ($up) {
  1370. $stx = ["order_code"=>$info["orderCode"],"status"=>$ite,"action_remark"=>'',"action_type"=>"status"];
  1371. ActionLog::logAdd($this->post['token'],$stx,"QRGCD",$info['status'],$info);
  1372. $order=["order_type"=>"QRGCD","order_code"=>$info["orderCode"],"order_id"=>$info['id'],"order_status"=>$info['status']];
  1373. ProcessOrder::AddProcess($this->post['token'],$order);
  1374. return app_show(0, "更新成功");
  1375. } else {
  1376. return error_show(1003, "更新失败");
  1377. }
  1378. }
  1379. /**
  1380. * @return \think\response\Json|void
  1381. * @throws \think\db\exception\DataNotFoundException
  1382. * @throws \think\db\exception\DbException
  1383. * @throws \think\db\exception\ModelNotFoundException
  1384. */
  1385. public function diffinfo()
  1386. {
  1387. $id = isset($this->post['id']) && $this->post['id'] !== "" ? intval($this->post['id']) : "";
  1388. if ($id === "") {
  1389. return error_show(1004, "参数id不能为空");
  1390. }
  1391. $info = Db::name('sale_diff')->alias('a')->join("good b", "b.good_code=a.good_kode", "left")->where
  1392. (["a.id" => $id])->field("a.*,b.cat_id")->find();
  1393. if (empty($info)) {
  1394. return error_show(1004, "订单数据未找到");
  1395. }
  1396. $info['can'] = isset($info['cat_id']) && $info['cat_id'] !== 0 ? made($info['cat_id']) : [];
  1397. return app_show(0, "获取成功", $info);
  1398. }
  1399. public function saleout(){
  1400. $page = isset($this->post['page']) && $this->post['page'] !=="" ? intval($this->post['page']):"1";
  1401. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']) :"10";
  1402. $where= [];
  1403. $orderCode=isset($this->post['orderCode']) && $this->post['orderCode'] !=="" ? trim($this->post['orderCode'])
  1404. :"";
  1405. if($orderCode !==""){
  1406. $where[]=['a.orderCode',"like","%$orderCode%"];
  1407. }
  1408. $order_type=isset($this->post['order_type']) && $this->post['order_type'] !=="" ? trim($this->post['order_type'])
  1409. :"";
  1410. if($order_type !==""){
  1411. $where[]=['a.order_type',"=",$order_type];
  1412. }
  1413. $outCode=isset($this->post['outCode']) && $this->post['outCode'] !=="" ? trim($this->post['outCode'])
  1414. :"";
  1415. if($outCode !==""){
  1416. $where[]=['a.outCode',"like","%$outCode%"];
  1417. }
  1418. $apply_name=isset($this->post['apply_name']) && $this->post['apply_name'] !=="" ? trim($this->post['apply_name'])
  1419. :"";
  1420. if($apply_name !==""){
  1421. $where[]=['a.apply_name',"like","%$apply_name%"];
  1422. }
  1423. $good_code=isset($this->post['good_code']) && $this->post['good_code'] !=="" ? trim($this->post['good_code'])
  1424. :"";
  1425. if($good_code !==""){
  1426. $where[]=['b.good_code',"like","%$good_code%"];
  1427. }
  1428. $good_name=isset($this->post['good_name']) && $this->post['good_name'] !=="" ? trim($this->post['good_name'])
  1429. :"";
  1430. if($good_name !==""){
  1431. $where[]=['b.good_name',"like","%$good_name%"];
  1432. }
  1433. $status=isset($this->post['status']) && $this->post['status'] !=="" ? trim($this->post['status']):"";
  1434. if($status !==""){
  1435. $where[]=['a.status',"=",$status];
  1436. }
  1437. $start = isset($this->post['start']) && $this->post['start'] !=="" ? $this->post['start'] :"";
  1438. if($start !=""){
  1439. $where[]= ["a.addtime",'>=',$start];
  1440. }
  1441. $end = isset($this->post['end']) && $this->post['end'] !=="" ? $this->post['end'] :"";
  1442. if($end !=""){
  1443. $where[]= ["a.addtime",'<=',$end];
  1444. }
  1445. $companyNo =isset($this->post['companyNo']) &&$this->post['companyNo'] !=="" ? trim($this->post['companyNo']):"";
  1446. if($companyNo!=""){
  1447. $where[]=['b.customer_code',"like","%$companyNo%"];
  1448. }
  1449. $count = Db::name('order_out')->alias('a')
  1450. ->join("sale b", "b.orderCode=a.orderCode", "left")
  1451. ->join("customer_info v", "v.companyNo=b.customer_code", "left")
  1452. //->join("good n","n.good_code=b.good_code","left")
  1453. ->where($where)->count();
  1454. $total = ceil($count / $size);
  1455. $page = $page >= $total ? $total : $page;
  1456. $list = Db::name('order_out')->alias('a')->join("sale b", "b.orderCode=a.orderCode", "left")
  1457. ->join("customer_info v", "v.companyNo=b.customer_code", "left")
  1458. //->join("good n","n.good_code=b.good_code","left")
  1459. ->field("a.*,b.good_name,b.good_code,b.supplierNo,b.customer_code,v.companyName,b.origin_price,b.sale_price,b.total_price")
  1460. ->where($where)->order("addtime desc")->page($page, $size)->select();
  1461. $data=[];
  1462. foreach ($list as $value) {
  1463. $wsmcode = Db::name("warehouse_info")->alias("k")->leftJoin("supplier c", "k.supplierNo=c.code")
  1464. ->where(["k.wsm_code" => $value['wsm_code']])->field("k.name as wsm_name,c.name,c.code")->find();
  1465. $addr = Db::name("order_addr")->where(["id" => $value['addrid']])->find();
  1466. $good = Db::name("good_type")->alias("b")->join("good a", "a.good_code = b.good_code", "left")
  1467. ->where(["type_code" => $value['good_code']])->field('cat_id')->find();
  1468. $value['wsm_name'] = isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name'] : "";
  1469. $value['wsm_supplier'] = isset($wsmcode['name']) ? $wsmcode['name'] : "";
  1470. $value['wsm_supplierNo'] = isset($wsmcode['code']) ? $wsmcode['code'] : "";
  1471. $value['addr'] = isset($addr['addr']) ? $addr['addr'] : "";
  1472. $value['contactor'] = isset($addr['contactor']) ? $addr['contactor'] : "";
  1473. $value['mobile'] = isset($addr['mobile']) ? $addr['mobile'] : "";
  1474. $value['can'] = isset($good['cat_id']) && $good['cat_id'] != 0 ? made($good['cat_id']) : [];
  1475. $data[] = $value;
  1476. }
  1477. return app_show(0, "获取成功", ['list' => $data, 'count' => $count]);
  1478. }
  1479. public function outinfo()
  1480. {
  1481. $outCode = isset($this->post['outCode']) && $this->post['outCode'] !== "" ? trim($this->post['outCode']) : "";
  1482. if ($outCode == "") {
  1483. return error_show(1002, "参数outcode不能为空");
  1484. }
  1485. $codeinfo = Db::name("order_out")->where(['outCode' => $outCode])->find();
  1486. if (empty($codeinfo)) {
  1487. return error_show(1002, "未找到出库数据");
  1488. }
  1489. $item = Db::name("sale")->where(['orderCode' => $codeinfo['orderCode']])->find();
  1490. if($item['order_type']==3|| $item['order_type']==4){
  1491. // $good=Db::name("good_zixun")->where(["spuCode"=>$good_code])->find();
  1492. // if($good==false){
  1493. // return error_show(1004,"未找到商品数据");
  1494. // }
  1495. $goodinfo = Db::name("consult_bids")->where(["spuCode"=>$item['good_code'],"is_del"=>0])->find();
  1496. if($goodinfo==false){
  1497. return error_show(1004,"未找到商品数据");
  1498. }
  1499. }else{
  1500. $goodinfo = Db::name('good_platform')->alias('a')->join('good b', 'b.spuCode=a.spuCode', 'left')
  1501. ->where(['a.skuCode' =>$item['sku_code']])->find();
  1502. if ($goodinfo == false) {
  1503. return error_show(1002, "未找到商品数据");
  1504. }
  1505. }
  1506. $int = isset($goodinfo['cat_id']) && $goodinfo['cat_id'] != 0 ? made($goodinfo['cat_id']) : [];
  1507. // $wsmcode = Db::name("warehouse_info")->alias("k")->leftJoin("supplier c", "k.supplierNo=c.code")
  1508. // ->where(["k.wsm_code" => $codeinfo['wsm_code']])->field("k.name as wsm_name,c.name,c.code")->find();
  1509. $addr = Db::name("order_addr")->where(["id" => $codeinfo['addrid']])->find();
  1510. //$item = Db::name("sale")->where(['orderCode' => $codeinfo['orderCode']])->find();
  1511. $codeinfo['good_name'] = isset($item['good_name']) ? $item['good_name'] : "";
  1512. $codeinfo['good_num'] = isset($item['good_num']) ? $item['good_num'] : "";
  1513. $codeinfo['good_code'] = isset($item['good_code']) ? $item['good_code'] : "";
  1514. $codeinfo['origin_price'] = isset($item['origin_price']) ? $item['origin_price'] : "";
  1515. $codeinfo['sale_price'] = isset($item['sale_price']) ? $item['sale_price'] : "";
  1516. $codeinfo['total_price'] = isset($item['total_price']) ? $item['total_price'] : "";
  1517. // $codeinfo['wsm_name'] = isset($wsmcode['wsm_name']) ? $wsmcode['wsm_name'] : "";
  1518. // $codeinfo['wsm_supplier'] = isset($wsmcode['name']) ? $wsmcode['name'] : "";
  1519. // $codeinfo['wsm_supplierNo'] = isset($wsmcode['code']) ? $wsmcode['code'] : "";
  1520. $codeinfo['addr'] = GetAddr($addr['addr_code']);
  1521. $codeinfo['addr'] .= isset($addr['addr']) ? $addr['addr'] : "";
  1522. $codeinfo['addr_code'] = isset($addr['addr_code']) ? $addr['addr_code'] : "";
  1523. $codeinfo['contactor'] = isset($addr['contactor']) ? $addr['contactor'] : "";
  1524. $codeinfo['mobile'] = isset($addr['mobile']) ? $addr['mobile'] : "";
  1525. $codeinfo['can'] = $int;
  1526. return app_show(0, "获取成功", $codeinfo);
  1527. }
  1528. public function outadd(){
  1529. $token = isset($this->post['token']) && $this->post['token'] !== "" ? trim($this->post['token']) : "";
  1530. $outCode = makeNo("CK");
  1531. $orderCode = isset($this->post['orderCode']) && $this->post['orderCode'] !== "" ? trim($this->post['orderCode']) : "";
  1532. if ($orderCode == "") {
  1533. return error_show(1002, "参数orderCoder不能为空");
  1534. }
  1535. $der = Db::name('sale')->where(['orderCode' => $orderCode])->find();
  1536. if ($der == "") {
  1537. return error_show(1002, "未找到出库订单单号");
  1538. }
  1539. $send_num = isset($this->post['send_num']) && $this->post['send_num'] !== "" ? $this->post['send_num'] : "";
  1540. if ($send_num == "") {
  1541. return error_show(1002, "发货数量不能为空");
  1542. }
  1543. if ($send_num > $der['wsend_num']) {
  1544. return error_show(1002, "超出可发货数量");
  1545. }
  1546. $contactor = isset($this->post['contactor'])&&$this->post['contactor']!="" ? trim($this->post['contactor']):"";
  1547. if($contactor==""){
  1548. return error_show(1002, "参数contactor不能为空");
  1549. }
  1550. $mobile = isset($this->post['mobile'])&&$this->post['mobile']!="" ? trim($this->post['mobile']):"";
  1551. if($mobile==""){
  1552. return error_show(1002, "参数mobile不能为空");
  1553. }
  1554. $addr = isset($this->post['addr'])&&$this->post['addr']!="" ? trim($this->post['addr']):"";
  1555. if($addr==""){
  1556. return error_show(1002, "参数addr不能为空");
  1557. }
  1558. $addr_code = isset($this->post['addr_code'])&&$this->post['addr_code']!="" ? trim($this->post['addr_code']):"";
  1559. if($addr_code==""){
  1560. return error_show(1002, "参数addr_code不能为空");
  1561. }
  1562. $apply_id = GetUserInfo($token);
  1563. if (empty($apply_id) || $apply_id['code'] != 0) {
  1564. return error_show(1002, "申请人数据不存在");
  1565. }
  1566. $rm = isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
  1567. $ri = isset($apply_id["data"]['nickname']) ? $apply_id["data"]['nickname'] : "";
  1568. // $addrid = isset($this->post['addrid']) && $this->post['addrid'] !== "" ? intval($this->post['addrid']) : "";
  1569. // $dr = Db::name('order_addr')->where(['id' => $addrid, 'is_del' => 0])->find();
  1570. // if (empty($dr)) {
  1571. // return error_show(1003, "收货人信息未找到");
  1572. // }
  1573. // if ($dr['orderCode'] !== $orderCode) {
  1574. // return error_show(1002, "订单code不存在");
  1575. // }
  1576. $sendtime = isset($this->post['sendtime']) && $this->post['sendtime'] !== "" ? $this->post['sendtime'] : date("Y-m-d H:i:s");
  1577. try {
  1578. $addrlst =[
  1579. "orderCode"=>$orderCode,
  1580. "addr"=>$addr,
  1581. "addr_code"=>json_encode($addr_code),
  1582. "contactor"=>$contactor,
  1583. "mobile"=>$mobile,
  1584. "customer_code"=>$der['customer_code'],
  1585. "post_fee"=>$der['post_fee'],
  1586. "arrive_time"=>$sendtime,
  1587. "receipt_quantity"=>$send_num,
  1588. "is_del"=>0,
  1589. "addtime"=>date("Y-m-d H:i:s"),
  1590. "updatetime"=>date("Y-m-d H:i:s")
  1591. ];
  1592. $addrid = Db::name("order_addr")->insert($addrlst,true);
  1593. if($addrid>0){
  1594. $data = [
  1595. "wsm_code" => "",
  1596. "orderCode" => $orderCode,
  1597. "outCode" => $outCode,
  1598. "order_type" => $der['order_type'],
  1599. "apply_id" => $rm,
  1600. "apply_name" => $ri,
  1601. "addrid" => $addrid,
  1602. "post_name" => "",
  1603. "post_code" =>"",
  1604. "post_fee" => "",
  1605. "sendtime" => $sendtime,
  1606. "send_num" => $send_num,
  1607. "check_num" => 0,
  1608. "error_num" => 0,
  1609. "status" => 1,
  1610. "addtime" => date("Y-m-d H:i:s"),
  1611. "updatetime" => date("Y-m-d H:i:s")
  1612. ];
  1613. $datainfo = Db::name('order_out')->insert($data,true);
  1614. if($datainfo>0){
  1615. Db::commit();
  1616. return app_show(0,"出库单新建成功",["outCode"=>$outCode]);
  1617. }
  1618. }
  1619. Db::rollback();
  1620. return error_show(1004,"出库单新建失败");
  1621. } catch (Exception $e) {
  1622. Db::rollback();
  1623. return error_show(1005, $e->getMessage());
  1624. }
  1625. }
  1626. public function outSend(){
  1627. $outCode=isset($this->post['outCode'])&& $this->post['outCode']!=""? trim($this->post['outCode']):"";
  1628. if($outCode==""){
  1629. return error_show(1004,"参数outCode不能为空");
  1630. }
  1631. $outinfo = Db::name("order_out")->where(["outCode"=>$outCode])->find();
  1632. if($outinfo==false){
  1633. return error_show(1004,"发货数据未找到");
  1634. }
  1635. $post_name = isset($this->post['post_name']) &&$this->post['post_name']!="" ? trim($this->post['post_name']):"";
  1636. if($post_name==""){
  1637. return error_show(1004,"参数post_name不能为空");
  1638. }
  1639. $post_code = isset($this->post['post_code']) &&$this->post['post_code']!="" ? trim($this->post['post_code']):"";
  1640. if($post_code==""){
  1641. return error_show(1004,"参数post_code不能为空");
  1642. }
  1643. $post_fee = isset($this->post['post_fee']) && $this->post['post_fee']!="" ? floatval($this->post['post_fee']):"";
  1644. $outinfo['post_name'] = $post_name;
  1645. $outinfo['post_code'] = $post_code;
  1646. $outinfo['post_fee'] = $post_fee;
  1647. $outinfo['sendtime'] = date("Y-m-d H:i:s");
  1648. $outinfo['status'] = 2;
  1649. $outinfo['updatetime'] = date("Y-m-d H:i:s");
  1650. $up =Db::name("order_out")->save($outinfo);
  1651. if($up){
  1652. return app_show(0,"发货成功");
  1653. }else{
  1654. return error_show(1004,"发货失败");
  1655. }
  1656. }
  1657. }