SalesOrderService.php 58 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291
  1. <?php
  2. namespace App\Service;
  3. use App\Model\BasicType;
  4. use App\Model\BookingList;
  5. use App\Model\Construction;
  6. use App\Model\Customer;
  7. use App\Model\CustomerInfo;
  8. use App\Model\Depart;
  9. use App\Model\Employee;
  10. use App\Model\InvoiceOrder;
  11. use App\Model\OrderOperation;
  12. use App\Model\PaymentReceipt;
  13. use App\Model\PaymentReceiptInfo;
  14. use App\Model\Product;
  15. use App\Model\ReturnExchangeOrder;
  16. use App\Model\SalesOrder;
  17. use App\Model\SalesOrderInfo;
  18. use App\Model\SalesOrderOtherFee;
  19. use App\Model\SalesOrderProductInfo;
  20. use App\Model\SeeRange;
  21. use App\Model\SportsBag;
  22. use App\Model\SportsBagProductInfo;
  23. use App\Model\WxEmployee;
  24. use App\Service\Weixin\WxSendMessageService;
  25. use Illuminate\Support\Facades\DB;
  26. /**
  27. * 订单管理
  28. */
  29. class SalesOrderService extends Service
  30. {
  31. /**
  32. * 订单编辑
  33. * @param $data
  34. * @param $user
  35. * @return array
  36. */
  37. public function salesOrderEdit($data,$user){
  38. list($status,$msg) = $this->salesOrderRule($data, $user, false);
  39. if(!$status) return [$status,$msg];
  40. $params = $this->getDataFile($data);
  41. (new OperationLogService())->setOperationList($params,$user,2);
  42. try {
  43. DB::beginTransaction();
  44. $model = SalesOrder::where('id', $data['id'])->first();
  45. $model->sales_order_type = $data['sales_order_type'];
  46. $model->model_type = $data['model_type'];
  47. $model->order_number = $data['order_number'];
  48. $model->selling_price = $data['selling_price'] ?? 0;
  49. $model->vin_no = $data['vin_no'] ?? '';
  50. $model->plat_type = $data['plat_type'] ?? 0;
  51. $model->plat_order = $data['plat_order'] ?? '';
  52. $model->order_type = $data['order_type'] ?? 0;
  53. $model->install_method = $data['install_method'] ?? 0;
  54. $model->install_position = $data['install_position'] ?? 0;
  55. $model->customer_id = $data['customer_id'] ?? 0;
  56. $model->customer_contact = $data['customer_contact'] ?? "";
  57. $model->sign_time = $data['sign_time'] ?? 0;
  58. $model->product_total = $data['product_total'] ?? 0;
  59. $model->rate = $data['rate'] ?? 0;
  60. $model->mark = $data['mark'] ?? '';
  61. $model->construction_time = $data['construction_time'] ?? 0;
  62. $model->handover_time = $data['handover_time'] ?? 0;
  63. $model->other_fee = $data['other_fee'] ?? 0;
  64. $model->discount_fee = $data['discount_fee'] ?? 0;
  65. $model->contract_fee = $data['contract_fee'] ?? 0;
  66. $model->pay_way = $data['pay_way'] ?? 0;
  67. $model->car_type = $data['car_type'] ?? 0;
  68. $model->year = $data['year'] ?? '';
  69. $model->mileage = $data['mileage'] ?? '';
  70. $model->color = $data['color'] ?? '';
  71. $model->original_set = $data['original_set'] ?? '';
  72. $model->processing = $data['processing'] ?? '';
  73. $model->save();
  74. $time = time();
  75. SalesOrderInfo::where('del_time',0)
  76. ->where('sales_order_id',$data['id'])
  77. ->update(['del_time' => $time]);
  78. SalesOrderProductInfo::where('del_time',0)
  79. ->where('sales_order_id',$data['id'])
  80. ->update(['del_time' => $time]);
  81. if(! empty($data['employee_one'])){
  82. $insert = [];
  83. foreach ($data['employee_one'] as $value){
  84. $insert[] = [
  85. 'sales_order_id' => $model->id,
  86. 'data_id' => $value,
  87. 'type' => SalesOrderInfo::type_one,
  88. 'crt_time' => $time,
  89. ];
  90. }
  91. SalesOrderInfo::insert($insert);
  92. }
  93. if(! empty($data['employee_two'])){
  94. $insert = [];
  95. foreach ($data['employee_two'] as $value){
  96. $insert[] = [
  97. 'sales_order_id' => $model->id,
  98. 'data_id' => $value,
  99. 'type' => SalesOrderInfo::type_two,
  100. 'crt_time' => $time,
  101. ];
  102. }
  103. SalesOrderInfo::insert($insert);
  104. }
  105. if(! empty($data['employee_three'])){
  106. $insert = [];
  107. foreach ($data['employee_three'] as $value){
  108. $insert[] = [
  109. 'sales_order_id' => $model->id,
  110. 'data_id' => $value,
  111. 'type' => SalesOrderInfo::type_three,
  112. 'crt_time' => $time,
  113. ];
  114. }
  115. SalesOrderInfo::insert($insert);
  116. }
  117. if(! empty($data['product'])){
  118. $insert = [];
  119. foreach ($data['product'] as $value){
  120. $sports_bag_product_info_id = 0;
  121. if(! empty($value['sports_bag_id'])) $sports_bag_product_info_id = empty($value['id']) ? 0 : $value['id'];
  122. $insert[] = [
  123. 'sales_order_id' => $model->id,
  124. 'product_id' => $value['product_id'] ?? 0,
  125. 'number' => $value['number'] ?? 0,
  126. 'cost' => $value['cost'] ?? 0,
  127. 'retail_price' => $value['retail_price'] ?? 0,
  128. 'mark' => $value['mark'] ?? '',
  129. 'crt_time' => $time,
  130. 'basic_type_id' => $value['basic_type_id'],
  131. 'price' => $value['price'] ?? 0,
  132. 'final_amount' => $value['final_amount'] ?? 0,
  133. 'sports_bag_id' => $value['sports_bag_id'] ?? 0,
  134. 'sports_bag_product_info_id' => $sports_bag_product_info_id,
  135. 'rate' => $value['rate'] ?? 0,
  136. ];
  137. }
  138. SalesOrderProductInfo::insert($insert);
  139. }
  140. // $new = [];
  141. // if(! empty($data['file'])){
  142. // $insert = [];
  143. // foreach ($data['file'] as $value){
  144. // $insert[] = [
  145. // 'sales_order_id' => $model->id,
  146. // 'file' => $value['url'],
  147. // 'name' => $value['name'],
  148. // 'type' => SalesOrderInfo::type_four,
  149. // 'crt_time' => $time,
  150. // ];
  151. // $new[] = $value['url'];
  152. // }
  153. // SalesOrderInfo::insert($insert);
  154. // }
  155. // $new = $old = [];
  156. // $order = PaymentReceipt::where('del_time',0)
  157. // ->where('crt_time',$model->crt_time)
  158. // ->where('data_order_no',$data['order_number'])
  159. // ->first();
  160. // if(! empty($order)){
  161. // $old = PaymentReceiptInfo::where('del_time',0)
  162. // ->where('payment_receipt_id',$order->id)
  163. // ->whereIn('type',[PaymentReceiptInfo::type_one])
  164. // ->select('file')
  165. // ->get()->toArray();
  166. // $old = array_column($old,'file');
  167. // }
  168. //
  169. // //收付款信息
  170. // if(! empty($data['payment_receipt'])){
  171. // if(empty($order)){
  172. // $this->savePaymentReceiptOrder($data,$user,$time);
  173. // }else{
  174. // PaymentReceiptInfo::where('del_time',0)
  175. // ->where('payment_receipt_id',$order->id)
  176. // ->update(['del_time' => $time]);
  177. // $this->savePaymentReceiptOrder($data,$user,$time,$order);
  178. // }
  179. // }
  180. DB::commit();
  181. }catch (\Exception $exception){
  182. DB::rollBack();
  183. return [false,$exception->getMessage()];
  184. }
  185. // $this->delStorageFile($old, $new);
  186. if(! empty($data['check'])) {
  187. list($status,$msg) = (new CheckService())->checkAll([
  188. "id" => $data['id'],
  189. "order_number" => $data['order_number'],
  190. "opt_case" => CheckService::eight,
  191. "menu_id" => $data['menu_id']
  192. ],$user);
  193. if(! $status) return [true, '保存成功,合同确认失败,异常信息:' . $msg];
  194. }
  195. return [true,''];
  196. }
  197. /**
  198. * 产品新增
  199. * @param $data
  200. * @param $user
  201. * @return array
  202. */
  203. public function salesOrderAdd($data,$user){
  204. list($status,$msg) = $this->salesOrderRule($data,$user);
  205. if(!$status) return [$status,$msg];
  206. try {
  207. DB::beginTransaction();
  208. $time = time();
  209. $model = new SalesOrder();
  210. $model->sales_order_type = $data['sales_order_type'];
  211. $model->model_type = $data['model_type'];
  212. $model->order_number = $data['order_number'];
  213. $model->selling_price = $data['selling_price'] ?? 0;
  214. $model->vin_no = $data['vin_no'] ?? '';
  215. $model->plat_type = $data['plat_type'] ?? 0;
  216. $model->plat_order = $data['plat_order'] ?? '';
  217. $model->order_type = $data['order_type'] ?? 0;
  218. $model->install_method = $data['install_method'] ?? 0;
  219. $model->install_position = $data['install_position'] ?? 0;
  220. $model->customer_id = $data['customer_id'] ?? 0;
  221. $model->customer_contact = $data['customer_contact'] ?? "";
  222. $model->sign_time = $data['sign_time'] ?? 0;
  223. $model->product_total = $data['product_total'] ?? 0;
  224. $model->rate = $data['rate'] ?? 0;
  225. $model->mark = $data['mark'] ?? '';
  226. $model->construction_time = $data['construction_time'] ?? 0;
  227. $model->handover_time = $data['handover_time'] ?? 0;
  228. $model->other_fee = $data['other_fee'] ?? 0;
  229. $model->discount_fee = $data['discount_fee'] ?? 0;
  230. $model->contract_fee = $data['contract_fee'] ?? 0;
  231. $model->pay_way = $data['pay_way'] ?? 0;
  232. $model->car_type = $data['car_type'] ?? 0;
  233. $model->year = $data['year'] ?? '';
  234. $model->mileage = $data['mileage'] ?? '';
  235. $model->color = $data['color'] ?? '';
  236. $model->original_set = $data['original_set'] ?? '';
  237. $model->processing = $data['processing'] ?? '';
  238. $model->depart_id = $data['depart_id'] ?? 0;
  239. $model->top_depart_id = $data['top_depart_id'] ?? 0;
  240. $model->crt_id = $user['id'];
  241. $model->crt_time = $time;
  242. $model->save();
  243. if(! empty($data['employee_one'])){
  244. $insert = [];
  245. foreach ($data['employee_one'] as $value){
  246. $insert[] = [
  247. 'sales_order_id' => $model->id,
  248. 'data_id' => $value,
  249. 'type' => SalesOrderInfo::type_one,
  250. 'crt_time' => $time,
  251. ];
  252. }
  253. SalesOrderInfo::insert($insert);
  254. }
  255. if(! empty($data['employee_two'])){
  256. $insert = [];
  257. foreach ($data['employee_two'] as $value){
  258. $insert[] = [
  259. 'sales_order_id' => $model->id,
  260. 'data_id' => $value,
  261. 'type' => SalesOrderInfo::type_two,
  262. 'crt_time' => $time,
  263. ];
  264. }
  265. SalesOrderInfo::insert($insert);
  266. }
  267. if(! empty($data['employee_three'])){
  268. $insert = [];
  269. foreach ($data['employee_three'] as $value){
  270. $insert[] = [
  271. 'sales_order_id' => $model->id,
  272. 'data_id' => $value,
  273. 'type' => SalesOrderInfo::type_three,
  274. 'crt_time' => $time,
  275. ];
  276. }
  277. SalesOrderInfo::insert($insert);
  278. }
  279. // if(! empty($data['file'])){
  280. // $insert = [];
  281. // foreach ($data['file'] as $value){
  282. // $insert[] = [
  283. // 'sales_order_id' => $model->id,
  284. // 'file' => $value['url'],
  285. // 'name' => $value['name'],
  286. // 'type' => SalesOrderInfo::type_four,
  287. // 'crt_time' => $time,
  288. // ];
  289. // }
  290. // SalesOrderInfo::insert($insert);
  291. // }
  292. if(! empty($data['product'])){
  293. $insert = [];
  294. foreach ($data['product'] as $value){
  295. $sports_bag_product_info_id = 0;
  296. if(! empty($value['sports_bag_id'])) $sports_bag_product_info_id = empty($value['id']) ? 0 : $value['id'];;
  297. $insert[] = [
  298. 'sales_order_id' => $model->id,
  299. 'product_id' => $value['product_id'] ?? 0,
  300. 'number' => $value['number'] ?? 0,
  301. 'cost' => $value['cost'] ?? 0,
  302. 'retail_price' => $value['retail_price'] ?? 0,
  303. 'mark' => $value['mark'] ?? '',
  304. 'crt_time' => $time,
  305. 'basic_type_id' => $value['basic_type_id'] ?? 0,
  306. 'price' => $value['price'] ?? 0,
  307. 'final_amount' => $value['final_amount'] ?? 0,
  308. 'sports_bag_id' => $value['sports_bag_id'] ?? 0,
  309. 'sports_bag_product_info_id' => $sports_bag_product_info_id,
  310. 'rate' => $value['rate'] ?? 0,
  311. ];
  312. }
  313. SalesOrderProductInfo::insert($insert);
  314. }
  315. //收付款信息
  316. if(! empty($data['payment_receipt']['order_number'])) $this->savePaymentReceiptOrder($data,$user,$time);
  317. DB::commit();
  318. }catch (\Exception $exception){
  319. DB::rollBack();
  320. return [false,$exception->getLine().':'.$exception->getMessage()];
  321. }
  322. (new OperationLogService())->setOperationList($data,$user);
  323. if(! empty($data['check'])) {
  324. list($status,$msg) = (new CheckService())->checkAll([
  325. "id" => $model->id,
  326. "order_number" => $data['order_number'],
  327. "opt_case" => CheckService::eight,
  328. "menu_id" => $data['menu_id']
  329. ],$user);
  330. if(! $status) return [true, '保存成功,合同确认失败,异常信息:' . $msg];
  331. }
  332. return [true,''];
  333. }
  334. public function savePaymentReceiptOrder($data,$user,$time,$orders = null){
  335. $order = $data['payment_receipt'];
  336. if(empty($orders)){
  337. $model = new PaymentReceipt();
  338. $model->order_number = $order['order_number'];
  339. // $model->data_order_no = $data['order_number'];
  340. $model->data_type = $order['data_type'];
  341. $model->type = $order['type'];
  342. $model->account = $order['account'] ?? 0;
  343. $model->pay_way = $order['pay_way'] ?? 0;
  344. // $model->amount = $order['amount'] ?? 0;
  345. $model->mark = $order['mark'] ?? '';
  346. $model->crt_id = $user['id'];
  347. $model->depart_id = $data['depart_id'];
  348. $model->top_depart_id = $data['top_depart_id'];
  349. $model->payment_receipt_date = $order['payment_receipt_date'] ?? 0;
  350. $model->crt_time = $time;
  351. $model->save();
  352. if(! empty($order['file'])){
  353. $insert = [];
  354. foreach ($order['file'] as $value){
  355. $insert[] = [
  356. 'payment_receipt_id' => $model->id,
  357. 'file' => $value['url'],
  358. 'type' => PaymentReceiptInfo::type_one,
  359. 'name' => $value['name'],
  360. 'crt_time' => $time,
  361. ];
  362. }
  363. PaymentReceiptInfo::insert($insert);
  364. }
  365. if(! empty($order['employee_one'])){
  366. $insert = [];
  367. foreach ($order['employee_one'] as $value){
  368. $insert[] = [
  369. 'payment_receipt_id' => $model->id,
  370. 'data_id' => $value,
  371. 'type' => PaymentReceiptInfo::type_two,
  372. 'crt_time' => $time,
  373. ];
  374. }
  375. PaymentReceiptInfo::insert($insert);
  376. }
  377. $insert = [];
  378. $insert[] = [
  379. 'payment_receipt_id' => $model->id,
  380. 'data_type' => $order['type'],
  381. 'data_order_no' => $data['order_number'],
  382. 'data_order_type' => $order['data_type'],
  383. 'amount' => $order['amount'],
  384. 'type' => PaymentReceiptInfo::type_three,
  385. 'crt_time' => $time,
  386. ];
  387. PaymentReceiptInfo::insert($insert);
  388. }else{
  389. $order = $data['payment_receipt'];
  390. $orders->type = $order['type'];
  391. $orders->account = $order['account'] ?? 0;
  392. $orders->pay_way = $order['pay_way'] ?? 0;
  393. $orders->amount = $order['amount'] ?? 0;
  394. $orders->mark = $order['mark'] ?? '';
  395. $orders->payment_receipt_date = $order['payment_receipt_date'] ?? 0;
  396. $orders->save();
  397. if(! empty($order['file'])){
  398. $insert = [];
  399. foreach ($order['file'] as $value){
  400. $insert[] = [
  401. 'payment_receipt_id' => $orders->id,
  402. 'file' => $value['url'],
  403. 'type' => PaymentReceiptInfo::type_one,
  404. 'name' => $value['name'],
  405. 'crt_time' => $time,
  406. ];
  407. $new[] = $value['url'];
  408. }
  409. PaymentReceiptInfo::insert($insert);
  410. }
  411. if(! empty($order['employee_one'])){
  412. $insert = [];
  413. foreach ($order['employee_one'] as $value){
  414. $insert[] = [
  415. 'payment_receipt_id' => $orders->id,
  416. 'data_id' => $value,
  417. 'type' => PaymentReceiptInfo::type_two,
  418. 'crt_time' => $time,
  419. ];
  420. }
  421. PaymentReceiptInfo::insert($insert);
  422. }
  423. }
  424. }
  425. /**
  426. * 订单删除
  427. * @param $data
  428. * @return array
  429. */
  430. public function salesOrderDel($data){
  431. if(empty($data['id']) && empty($data['order_number'])) return [false,'请选择数据!'];
  432. if(! empty($data['id'])){
  433. $sale_order = SalesOrder::where('del_time',0)
  434. ->where('id',$data['id'])
  435. ->first();
  436. }else{
  437. $sale_order = SalesOrder::where('del_time',0)
  438. ->where('order_number',$data['order_number'])
  439. ->first();
  440. $data['id'] = empty($sale_order->id) ? 0 : $sale_order->id;
  441. }
  442. if(empty($sale_order)) return [false,'合同不存在或已被删除'];
  443. $sale_order = $sale_order->toArray();
  444. if($sale_order['state'] > 0) return [false,'请确认合同状态,删除失败'];
  445. try {
  446. DB::beginTransaction();
  447. SalesOrder::where('del_time',0)
  448. ->where('id',$data['id'])->update(['del_time'=> time()]);
  449. // $old = SalesOrderInfo::where('del_time',0)
  450. // ->where('sales_order_id',$data['id'])
  451. // ->whereIn('type',[SalesOrderInfo::type_four])
  452. // ->select('file')
  453. // ->get()->toArray();
  454. // $old = array_column($old,'file');
  455. SalesOrderInfo::where('del_time',0)
  456. ->where('sales_order_id',$data['id'])
  457. ->update(['del_time' => time()]);
  458. SalesOrderProductInfo::where('del_time',0)
  459. ->where('sales_order_id',$data['id'])
  460. ->update(['del_time' => time()]);
  461. SalesOrderOtherFee::where('del_time',0)
  462. ->where('sales_order_id',$data['id'])
  463. ->update(['del_time' => time()]);
  464. (new RangeService())->RangeDelete($data['id'],SeeRange::type_seven);
  465. DB::commit();
  466. }catch (\Exception $exception){
  467. DB::rollBack();
  468. return [false,$exception->getMessage()];
  469. }
  470. // $this->delStorageFile($old);
  471. return [true,''];
  472. }
  473. /**
  474. * 订单详情
  475. * @param $data
  476. * @return array
  477. */
  478. public function detail($data){
  479. if(empty($data['id']) && empty($data['order_number'])) return [false,'请选择数据!'];
  480. if(! empty($data['id'])){
  481. $sales = SalesOrder::where('del_time',0)
  482. ->where('id',$data['id'])
  483. ->first();
  484. }else{
  485. $sales = SalesOrder::where('del_time',0)
  486. ->where('order_number',$data['order_number'])
  487. ->first();
  488. $data['id'] = empty($sales->id) ? 0 : $sales->id;
  489. }
  490. if(empty($sales)) return [false,'合同不存在或已被删除'];
  491. $sales = $sales->toArray();
  492. $customer = Customer::where('id',$sales['customer_id'])->value('title');
  493. $sales['customer_title'] = $customer ?? '';
  494. $sales['sales_order_type_title'] = SalesOrder::$order_type[$sales['sales_order_type']] ?? '';
  495. $sales['activity_product'] = $sales['file'] = $sales['employee_one'] = $sales['employee_two'] = $sales['employee_three'] = $sales['product'] = $sales['dispatch_depart_one'] = $sales['dispatch_employee'] = $sales['dispatch_depart_two'] = [];
  496. $array = [
  497. $sales['plat_type'],
  498. $sales['order_type'],
  499. $sales['car_type'],
  500. $sales['pay_way'],
  501. $sales['install_method'],
  502. $sales['install_position'],
  503. ];
  504. $basic_map = BasicType::whereIn('id',$array)
  505. ->pluck('title','id')
  506. ->toArray();
  507. $sales = [$sales];
  508. foreach ($sales as $key => $value){
  509. $sales[$key]['plat_type_title'] = $basic_map[$value['plat_type']] ?? '';
  510. $sales[$key]['order_type_title'] = $basic_map[$value['order_type']] ?? '';
  511. $sales[$key]['car_type_title'] = $basic_map[$value['car_type']] ?? '';
  512. $sales[$key]['pay_way_title'] = $basic_map[$value['pay_way']] ?? '';
  513. $sales[$key]['install_method_title'] = $basic_map[$value['install_method']] ?? '';
  514. $sales[$key]['install_position_title'] = $basic_map[$value['install_position']] ?? '';
  515. }
  516. $sales = $sales[0];
  517. $sales_info = SalesOrderInfo::where('del_time',0)
  518. ->where('sales_order_id',$sales['id'])
  519. ->get()->toArray();
  520. $emp_id = [];
  521. $emp_id[] = $sales['crt_id'];
  522. foreach ($sales_info as $value){
  523. if(in_array($value['type'],SalesOrderInfo::$man)){
  524. $emp_id[] = $value['data_id'];
  525. }
  526. }
  527. $emp_map = Employee::whereIn('id',array_unique($emp_id))
  528. ->where('del_time',0)
  529. ->pluck('emp_name','id')
  530. ->toArray();
  531. foreach ($sales_info as $value){
  532. if(in_array($value['type'],SalesOrderInfo::$man)){
  533. $tt = $emp_map[$value['data_id']] ?? '';
  534. if(! empty($tt)){
  535. $tmp = [
  536. 'id' => $value['data_id'],
  537. 'name' => $emp_map[$value['data_id']] ?? '',
  538. ];
  539. if($value['type'] == SalesOrderInfo::type_one){
  540. $sales['employee_one'][] = $tmp;
  541. }elseif ($value['type'] == SalesOrderInfo::type_two){
  542. $sales['employee_two'][] = $tmp;
  543. }elseif ($value['type'] == SalesOrderInfo::type_three){
  544. $sales['employee_three'][] = $tmp;
  545. }
  546. }
  547. } elseif ($value['type'] == SalesOrderInfo::type_four){
  548. $sales['file'][] = [
  549. 'url' => $value['file'],
  550. 'name' => $value['name'],
  551. ];
  552. }
  553. }
  554. $sales_p_info = SalesOrderProductInfo::where('del_time',0)
  555. ->where('sales_order_id',$sales['id'])
  556. ->get()->toArray();
  557. $bag = SportsBag::whereIn('id',array_unique(array_column($sales_p_info,'sports_bag_id')))->get()->toArray();
  558. $bag_pro = SportsBagProductInfo::where('del_time',0)->whereIn('sports_bag_id',array_unique(array_column($sales_p_info,'sports_bag_id')))
  559. ->get()->toArray();
  560. $bag_map = array_column($bag,null,'id');
  561. $bag_pro_map = [];
  562. foreach ($bag_pro as $value){
  563. $bag_pro_map[$value['sports_bag_id']][] = $value;
  564. }
  565. $basic_price = BasicType::whereIn('id',array_unique(array_column($sales_p_info,'basic_type_id')))->pluck('title','id')->toArray();
  566. $map = (new ProductService())->getProductDetail(array_column($sales_p_info,'product_id'));
  567. $sports_bag_arr = [];
  568. $sports_bag_pro = [];
  569. foreach ($sales_p_info as $value){
  570. $tmp = $map[$value['product_id']] ?? [];
  571. if(! empty($value['sports_bag_id'])){
  572. $bag_tmp = $bag_map[$value['sports_bag_id']] ?? [];
  573. if(! isset($sports_bag_arr[$value['sports_bag_id']])) $sports_bag_arr[$value['sports_bag_id']] = $bag_tmp;
  574. $bag_pro_tmp = $bag_pro_map[$value['sports_bag_id']] ?? [];
  575. foreach ($bag_pro_tmp as $k => $v){
  576. if($v['product_id'] != $value['product_id']) continue;
  577. $is_choose = false;
  578. $final_amount = 0;
  579. $number = $v['number'];
  580. $mark = "";
  581. if($v['id'] == $value['sports_bag_product_info_id']){
  582. $is_choose = true;
  583. $final_amount = $value['final_amount'];
  584. $number = $value['number'];
  585. $mark = $value['mark'];
  586. }
  587. $bag_pro_tmp[$k]['is_choose'] = $is_choose;
  588. $bag_pro_tmp[$k]['final_amount'] = $final_amount;
  589. $bag_pro_tmp[$k]['number'] = $number;
  590. $bag_pro_tmp[$k]['title'] = $tmp['title'] ?? "";
  591. $bag_pro_tmp[$k]['code'] = $tmp['code'] ?? "";
  592. $bag_pro_tmp[$k]['size'] = $tmp['size'] ?? "";
  593. $bag_pro_tmp[$k]['unit'] = $tmp['unit'] ?? "";
  594. $bag_pro_tmp[$k]['bar_code'] = $tmp['bar_code'] ?? "";
  595. $bag_pro_tmp[$k]['mark'] = $mark ?? "";
  596. $sports_bag_pro[$value['sports_bag_id']][] = $bag_pro_tmp[$k];
  597. }
  598. }else{
  599. $value['title'] = $tmp['title'] ?? "";
  600. $value['code'] = $tmp['code'] ?? "";
  601. $value['size'] = $tmp['size'] ?? "";
  602. $value['unit'] = $tmp['unit'] ?? "";
  603. $value['bar_code'] = $tmp['bar_code'] ?? "";
  604. $value['basic_type_title'] = $basic_price[$value['basic_type_id']] ?? "";
  605. $sales['product'][] = $value;
  606. }
  607. }
  608. foreach ($sports_bag_arr as $key => $value){
  609. $value['product'] = $sports_bag_pro[$key] ?? [];
  610. $sales['activity_product'][] = $value;
  611. }
  612. $sales['crt_name'] = $emp_map[$sales['crt_id']] ?? '';
  613. $sales['crt_time'] = $sales['crt_time'] ? date("Y-m-d H:i:s",$sales['crt_time']): '';
  614. $sales['dispatch_time_first'] = $sales['dispatch_time_first'] ? date("Y-m-d H:i:s",$sales['dispatch_time_first']): '';
  615. $sales['dispatch_time_second'] = $sales['dispatch_time_second'] ? date("Y-m-d H:i:s",$sales['dispatch_time_second']): '';
  616. //派单后数据 也就是可见范围
  617. $return = (new RangeService())->RangeDetail($data['id'],SeeRange::type_seven);
  618. $sales['dispatch_depart_one'] = $return[0] ?? [];
  619. $sales['dispatch_employee'] = $return[1] ?? [];
  620. $sales['dispatch_depart_two'] = $return[2] ?? [];
  621. //退换货信息
  622. $sales['return_exchange'] = (new ReturnExchangeOrderService())->getDifferentAmount($data['id']);
  623. $sales['return_exchange_amount'] = 0;
  624. foreach ($sales['return_exchange'] as $value){
  625. $sales['return_exchange_amount'] += $value['difference_amount'];
  626. }
  627. //回款单信息
  628. $sales['payment_receipt_list'] = (new PaymentReceiptService())->getPaymentReceiptDataList($sales);
  629. //总回款金额 = 合同金额 - 退换货金额 - 坏账金额
  630. $total = $sales['contract_fee'] - $sales['return_exchange_amount'] - $sales['payment_receipt_list']['bad_amount'];
  631. //未回款金额 = 总回款金额 - 已回款金额 + 红冲金额
  632. $sales['payment_receipt_list']['not_receipt_amount'] = $total - $sales['payment_receipt_list']['receipt_amount'] + $sales['payment_receipt_list']['red_amount'];
  633. $sales['not_payment_receipt_amount'] = $sales['payment_receipt_list']['not_receipt_amount'];
  634. //详情里的收付款信息
  635. // $sales['payment_receipt'] = (new PaymentReceiptService())->getPaymentReceiptDeatail($sales);
  636. return [true, $sales];
  637. }
  638. /**
  639. * 订单列表
  640. * @param $data
  641. * @param $user
  642. * @return array
  643. */
  644. public function salesOrderList($data,$user){
  645. $model = SalesOrder::Clear($user,$data);
  646. $model = $model->where('del_time',0)
  647. ->select('id','sales_order_type','model_type','order_number','selling_price','vin_no','car_type','order_type','customer_id','sign_time','crt_id','crt_time','mark','product_total','rate','construction_time','handover_time','other_fee','discount_fee','contract_fee','pay_way','car_type','year','mileage','color','original_set','processing','state','invoice_state','plat_type','plat_order','install_method','install_position','customer_contact','is_confirm')
  648. ->orderby('id', 'desc');
  649. if(! empty($data['order_number'])) $model->where('order_number','LIKE', '%'.$data['order_number'].'%');
  650. if(! empty($data['sales_order_type'])) $model->where('sales_order_type',$data['sales_order_type']);
  651. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  652. if(! empty($data['model_type'])) $model->where('model_type',$data['model_type']);
  653. if(! empty($data['time_type'])) {
  654. if($data['time_type'] == 1) {
  655. $start = strtotime('today');
  656. $end = strtotime('tomorrow') - 1;
  657. }elseif ($data['time_type'] == 2){
  658. $start = strtotime('this week',strtotime('today'));
  659. $end = strtotime('this week +6 days 23:59:59', strtotime('today'));
  660. }
  661. if(! empty($start) && ! empty($end)) {
  662. $model->where('crt_time','>=',$start);
  663. $model->where('crt_time','<=',$end);
  664. }
  665. }
  666. if(! empty($data['add_construction'])) {
  667. //能下施工单的合同状态
  668. $model->where('state','>=',SalesOrder::State_four);
  669. $model->where('state','<',SalesOrder::State_seven);
  670. }
  671. if(! empty($data['add_return'])) {
  672. //能下退换货单的合同状态
  673. $model->where('state','>=',SalesOrder::State_two);
  674. // $model->where('state','<',SalesOrder::State_seven);
  675. }
  676. if(! empty($data['sales_order_id'])) $model->where('id',$data['sales_order_id']);
  677. if(! empty($data['order_list'])){
  678. if($data['order_list'] == 1){
  679. //订单合同 安装件合同 状态未指派总社分社的 或者 快递件合同
  680. $model->where('state', '<=', SalesOrder::State_three);
  681. }elseif($data['order_list'] == 2){
  682. //派单合同 安装件合同 状态已指派总社分社的
  683. $model->where('state', '>=', SalesOrder::State_four);
  684. }
  685. }
  686. if(isset($data['state'])) $model->where('state',$data['state']);
  687. if(isset($data['invoice_state'])) $model->where('invoice_state',$data['invoice_state']);
  688. if(! empty($data['order_type'])) $model->where('order_type',$data['order_type']);
  689. if(! empty($data['plat_type'])) $model->where('plat_type',$data['plat_type']);
  690. if(! empty($data['plat_order'])) $model->where('plat_order','LIKE', '%'.$data['plat_order'].'%');
  691. if(! empty($data['customer'])) {
  692. $model2 = Customer::Clear($user,$data);
  693. $customer = $model2->where('del_time',0)
  694. ->where('title', 'LIKE', '%'.$data['customer'].'%')
  695. ->select('id')
  696. ->get()->toArray();
  697. $model->whereIn('customer_id',array_unique(array_column($customer,'id')));
  698. }
  699. if(! empty($data['customer_id'])) $model->where('customer_id',$data['customer_id']);
  700. if(! empty($data['sign_time'][0]) && ! empty($data['sign_time'][1])){
  701. $return = $this->changeDateToTimeStampAboutRange($data['sign_time']);
  702. $model->where('sign_time','>=',$return[0]);
  703. $model->where('sign_time','<=',$return[1]);
  704. }
  705. if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
  706. $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
  707. $model->where('crt_time','>=',$return[0]);
  708. $model->where('crt_time','<=',$return[1]);
  709. }
  710. if(! empty($data['qd']) || ! empty($data['fz'])){
  711. $sale_order_id = (new RangeService())->salesOrderSearch($data);
  712. $model->whereIn('id',$sale_order_id);
  713. }
  714. if(! empty($data['zp'])){
  715. $sale_order_id = (new RangeService())->salesOrderZpSearch($data);
  716. $model->whereIn('id',$sale_order_id);
  717. }
  718. if(! empty($data['purchase_order_number'])) $model->where('contact_order_no','LIKE', '%'.$data['purchase_order_number'].'%');
  719. $list = $this->limit($model,'',$data);
  720. $list = $this->fillData($list,$data);
  721. return [true, $list];
  722. }
  723. /**
  724. * 订单参数规则
  725. * @param $data
  726. * @param $user
  727. * @param $is_add
  728. * @return array
  729. */
  730. public function salesOrderRule(&$data, $user, $is_add = true){
  731. if(empty($data['model_type'])) return [false,'销售类型不能为空'];
  732. if(! in_array($data['model_type'],SalesOrder::$model_type)) return [false,'销售类型错误'];
  733. if(empty($data['sales_order_type'])) return [false,'产品类型不能为空'];
  734. if(empty($data['order_number'])) return [false,'合同编号不能为空'];
  735. // if(empty($data['customer_id'])) return [false,'请选择客户'];
  736. // if(empty($data['employee_one'])) return [false,'请选择签订人'];
  737. if(! empty($data['sign_time'])) $data['sign_time'] = $this->changeDateToDateMin($data['sign_time']);
  738. if(! empty($data['expire_time'])) $data['expire_time'] = $this->changeDateToDateMin($data['expire_time']);
  739. // if(empty($data['employee_two'])) return [false,'请选择负责人'];
  740. // if(empty($data['product'])) return [false,'请选择产品'];
  741. if(! empty($data['product'])){
  742. foreach ($data['product'] as $value){
  743. if(empty($value['number'])) return [false,'产品数量不能为空'];
  744. $res = $this->checkNumber($value['number']);
  745. if(! $res) return [false,'请输入正确的产品数量'];
  746. }
  747. }
  748. if(! empty($data['contract_fee'])){
  749. $res = $this->checkNumber($data['contract_fee']);
  750. if(! $res) return [false, '合同金额请输入不超过两位小数并且大于0的数值'];
  751. }
  752. if(! empty($data['other_fee'])){
  753. $res = $this->checkNumber($data['other_fee']);
  754. if(! $res) return [false, '其它费用请输入不超过两位小数并且大于0的数值'];
  755. }
  756. if(! empty($data['discount_fee'])){
  757. $res = $this->checkNumber($data['discount_fee']);
  758. if(! $res) return [false, '优惠金额请输入不超过两位小数并且大于0的数值'];
  759. }
  760. //所属部门 以及 顶级部门
  761. if(empty($data['depart_id'])) $data['depart_id'] = $this->getDepart($user);
  762. $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
  763. if($data['model_type'] == SalesOrder::Model_type_one){
  764. // if(empty($data['order_type'])) return [false,'订单类型不能为空'];
  765. if(! empty($data['construction_time'])) $data['construction_time'] = $this->changeDateToDateMin($data['construction_time']);
  766. if(! empty($data['handover_time'])) $data['handover_time'] = $this->changeDateToDateMin($data['handover_time']);
  767. // if(empty($data['deal_type'])) return [false,'成交类型不能为空'];
  768. }elseif($data['model_type'] == SalesOrder::Model_type_two){
  769. }else{
  770. // if(empty($data['car_type'])) return [false,'车型不能为空'];
  771. // if(empty($data['year'])) return [false,'年份不能为空'];
  772. // if(empty($data['mileage'])) return [false,'表显里程不能为空'];
  773. }
  774. //收付款信息
  775. if(! empty($data['payment_receipt']['order_number'])){
  776. if(empty($data['payment_receipt']['data_type'])) $data['payment_receipt']['data_type'] = PaymentReceipt::data_type_one;
  777. if(empty($data['payment_receipt']['data_order_no'])) $data['payment_receipt']['data_order_no'] = $data['payment_receipt']['order_number'];
  778. if(empty($data['payment_receipt']['type'])) return [false,'金额类型不能为空'];
  779. if(empty($data['payment_receipt']['amount'])) return [false,'回款金额不能为空'];
  780. $res = $this->checkNumber($data['payment_receipt']['amount']);
  781. if(! $res) return [false, '回款金额请输入不超过两位小数并且大于0的数值'];
  782. if($data['contract_fee'] < $data['payment_receipt']['amount']) return [false, '回款金额不能大于合同金额'];
  783. if(! empty($data['payment_receipt']['payment_receipt_date'])) $data['payment_receipt']['payment_receipt_date'] = $this->changeDateToDate($data['payment_receipt']['payment_receipt_date']);
  784. }
  785. if($is_add){
  786. $bool = SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])->exists();
  787. if($bool) return [false,'合同编号已存在,请重新获取'];
  788. // if($data['model_type'] == SalesOrder::Model_type_two){
  789. // $boolean = SalesOrder::where('del_time',0)
  790. // ->where('title',$data['title'])
  791. // ->where('model_type',$data['model_type'])
  792. // ->exists();
  793. // }
  794. }else{
  795. if(empty($data['id'])) return [false,'ID不能为空'];
  796. $order = SalesOrder::where('del_time',0)->where('id',$data['id'])->first();
  797. if(empty($order)) return [false,'合同不存在或已被删除'];
  798. $order = $order->toArray();
  799. if($order['state'] != SalesOrder::State2_zero) return [false, '请确认合同状态,编辑失败'];
  800. // if($data['model_type'] == SalesOrder::Model_type_two){
  801. // $boolean = SalesOrder::where('del_time',0)
  802. // ->where('id','<>',$data['id'])
  803. // ->where('title',$data['title'])
  804. // ->where('model_type',$data['model_type'])
  805. // ->exists();
  806. // }
  807. }
  808. // if(isset($boolean) && $boolean) return [false,'合同名称不能重复'];
  809. return [true, $data];
  810. }
  811. /**
  812. * 数据拼接
  813. * @param $data
  814. * @param $ergs
  815. * @return array
  816. */
  817. public function fillData($data,$ergs){
  818. if(empty($data['data'])) return $data;
  819. $array = array_unique(array_merge_recursive(array_column($data['data'],'order_type'),array_column($data['data'],'car_type'),array_column($data['data'],'pay_way'),array_column($data['data'],'install_position'),array_column($data['data'],'install_method'),array_column($data['data'],'plat_type')));
  820. $basic_map = BasicType::whereIn('id',$array)
  821. ->pluck('title','id')
  822. ->toArray();
  823. $emp = Employee::whereIn('id',array_unique(array_column($data['data'],'crt_id')))
  824. ->pluck('emp_name','id')
  825. ->toArray();
  826. $customer = Customer::whereIn('id',array_unique(array_column($data['data'],'customer_id')))
  827. ->pluck('title','id')
  828. ->toArray();
  829. $product = [];
  830. if(! empty($ergs['product'])){
  831. $sales_p_info = SalesOrderProductInfo::where('del_time',0)
  832. ->whereIn('sales_order_id',array_column($data['data'],'id'))
  833. ->get()->toArray();
  834. $basic_price = BasicType::whereIn('id',array_unique(array_column($sales_p_info,'basic_type_id')))->pluck('title','id')->toArray();
  835. $map = (new ProductService())->getProductDetail(array_column($sales_p_info,'product_id'));
  836. foreach ($sales_p_info as $value){
  837. $tmp = $map[$value['product_id']] ?? [];
  838. $value['title'] = $tmp['title'] ?? "";
  839. $value['code'] = $tmp['code'] ?? "";
  840. $value['size'] = $tmp['size'] ?? "";
  841. $value['unit'] = $tmp['unit'] ?? "";
  842. $value['bar_code'] = $tmp['bar_code'] ?? "";
  843. $value['basic_type_title'] = $basic_price[$value['basic_type_id']] ?? "";
  844. $value['install_time'] = $tmp['install_time'] ?? 0;
  845. $product[$value['sales_order_id']][] = $value;
  846. }
  847. }
  848. $for_amount_list = (new PaymentReceiptService())->getPaymentReceiptDataCountList($data['data']);
  849. $getDifferentAmountALL = (new ReturnExchangeOrderService())->getDifferentAmountALL(array_column($data['data'],'id'));
  850. //获取分社订货合同关联的发货单
  851. $invoiceData = $this->getInvoiceOrderData($data['data']);
  852. //分派的总社或分社
  853. $dispatch = $this->getDispatchData($data['data']);
  854. //指派金额
  855. $fee = [];
  856. $sales_o_info = SalesOrderOtherFee::where('del_time',0)
  857. ->whereIn('sales_order_id',array_column($data['data'],'id'))
  858. ->get()->toArray();
  859. foreach ($sales_o_info as $value){
  860. $fee[$value['sales_order_id']] = $value['other_fee_1'];
  861. }
  862. foreach ($data['data'] as $key => $value){
  863. $data['data'][$key]['plat_type_title'] = $basic_map[$value['plat_type']] ?? '';
  864. $data['data'][$key]['sales_order_type_title'] = SalesOrder::$order_type[$value['sales_order_type']] ?? '';
  865. $data['data'][$key]['model_type_title'] = SalesOrder::$model_type_title[$value['model_type']] ?? '';
  866. $data['data'][$key]['order_type_title'] = $basic_map[$value['order_type']] ?? '';
  867. $data['data'][$key]['install_method_title'] = $basic_map[$value['install_method']] ?? '';
  868. $data['data'][$key]['install_position_title'] = $basic_map[$value['install_position']] ?? '';
  869. $data['data'][$key]['car_type_title'] = $basic_map[$value['car_type']] ?? '';
  870. $data['data'][$key]['pay_way_title'] = $basic_map[$value['pay_way']] ?? '';
  871. $data['data'][$key]['customer_title'] = $customer[$value['customer_id']] ?? '';
  872. $data['data'][$key]['sign_time'] = $value['sign_time'] ? date('Y-m-d',$value['sign_time']) : '';
  873. $data['data'][$key]['construction_time'] = $value['construction_time'] ? date('Y-m-d H:i:s',$value['construction_time']) : '';
  874. $data['data'][$key]['handover_time'] = $value['handover_time'] ? date('Y-m-d H:i:s',$value['handover_time']) : '';
  875. $data['data'][$key]['crt_time'] = $value['crt_time'] ? date('Y-m-d H:i:s',$value['crt_time']) : '';
  876. $data['data'][$key]['crt_name'] = $emp[$value['crt_id']] ?? '';
  877. $data['data'][$key]['product'] = $product[$value['id']] ?? [];
  878. $data['data'][$key]['fee'] = $fee[$value['id']] ?? "";
  879. if($value['sales_order_type'] == SalesOrder::Order_type_one){
  880. if($value['model_type'] == SalesOrder::Model_type_four){
  881. $state = SalesOrder::$state[$value['state']] ?? '';
  882. }else{
  883. $state = SalesOrder::$state_2[$value['state']] ?? '';
  884. }
  885. $data['data'][$key]['state_title'] = $state;
  886. }else{
  887. $data['data'][$key]['state_title'] = SalesOrder::$state2[$value['state']] ?? '';
  888. }
  889. $data['data'][$key]['invoice_state_name'] = SalesOrder::$invoice_state[$value['invoice_state']] ?? '';
  890. $data['data'][$key]['is_confirm_title'] = $value['is_confirm'] ? "已接收" : "未接收" ;
  891. $tmp = $invoiceData[$value['id']] ?? [];
  892. $data['data'][$key]['invoice_arr'] = implode(',', $tmp);
  893. $data['data'][$key]['dispatch_company'] = $dispatch[$value['id']] ?? '';
  894. $one = $for_amount_list[$value['order_number'] . PaymentReceipt::type_one] ?? 0;
  895. $data['data'][$key]['payment_receipt_amount'] = $one;
  896. $three = $for_amount_list[$value['order_number'] . PaymentReceipt::type_three] ?? 0;
  897. $data['data'][$key]['red_amount'] = $three;
  898. $four = $for_amount_list[$value['order_number'] . PaymentReceipt::type_four] ?? 0;
  899. $data['data'][$key]['bad_amount'] = $four;
  900. $return_exchange_amount = $getDifferentAmountALL[$value['id']] ?? 0;
  901. $data['data'][$key]['return_exchange_amount'] = $return_exchange_amount;
  902. //最终已收金额
  903. $fee1 = round($one - $three,2);
  904. $data['data'][$key]['fee1'] = $fee1;
  905. //未收金额
  906. $fee2 = round($value['contract_fee'] - $return_exchange_amount - $fee1,2);
  907. $data['data'][$key]['fee2'] = $fee2;
  908. //红冲金额
  909. $data['data'][$key]['fee3'] = $three;
  910. //坏账金额
  911. $data['data'][$key]['fee4'] = $four;
  912. }
  913. return $data;
  914. }
  915. public function salesOrderGet($data){
  916. if(empty($data['model_type'])) return [false,'销售类型不能为空'];
  917. if(! isset(SalesOrder::$prefix[$data['model_type']])) return [false,'销售类型错误'];
  918. $prefix = SalesOrder::$prefix[$data['model_type']];
  919. $order_number = OrderNoService::createSalesOrderNumber($prefix);
  920. if(! $order_number) return [false,'合同编号生成失败!'];
  921. return [true, ['order_number' => $order_number]];
  922. }
  923. /**
  924. * 订单推送
  925. * @param $data
  926. * @return array
  927. */
  928. public function salesOrderDispatchSale($data, $user){
  929. list($status,$msg) = $this->salesOrderDispatchSaleRule($data, $user);
  930. if(! $status) return [false,$msg];
  931. try {
  932. DB::beginTransaction();
  933. $time = time();
  934. SalesOrder::where('del_time',0)->where('id',$msg['id'])->update([
  935. 'state' => SalesOrder::State_three,
  936. 'dispatch_time_first' => $time,
  937. ]);
  938. SeeRange::where('del_time',0)
  939. ->where('data_id',$msg['id'])
  940. ->where('data_type',SeeRange::type_seven)
  941. ->whereIn('type',[SeeRange::data_one, SeeRange::data_two])
  942. ->update(['del_time' => $time]);
  943. if(! empty($data['dispatch_depart_one'])){
  944. $insert = [];
  945. foreach ($data['dispatch_depart_one'] as $value){
  946. $insert[] = [
  947. 'data_id' => $msg['id'],
  948. 'data_type' => SeeRange::type_seven,
  949. 'param_id' => $value,
  950. 'type' => SeeRange::data_one,
  951. 'crt_time' => $time,
  952. ];
  953. }
  954. SeeRange::insert($insert);
  955. }
  956. if(! empty($data['dispatch_employee'])){
  957. $insert = [];
  958. foreach ($data['dispatch_employee'] as $value){
  959. $insert[] = [
  960. 'data_id' => $msg['id'],
  961. 'data_type' => SeeRange::type_seven,
  962. 'param_id' => $value,
  963. 'type' => SeeRange::data_two,
  964. 'crt_time' => $time,
  965. ];
  966. }
  967. SeeRange::insert($insert);
  968. }
  969. (new OrderOperationService())->add([
  970. 'order_number' => $msg['order_number'],
  971. 'msg' => OrderOperation::$type[OrderOperation::one],
  972. 'type' => OrderOperation::one
  973. ],$user);
  974. DB::commit();
  975. }catch (\Exception $exception){
  976. DB::rollBack();
  977. return [false,$exception->getMessage()];
  978. }
  979. return [true,''];
  980. }
  981. /**
  982. * 订单推送规则
  983. * @param $data
  984. * @return array
  985. */
  986. public function salesOrderDispatchSaleRule(&$data, $user){
  987. if(empty($data['id'])) return [false,'请选择合同派单'];
  988. $sale = SalesOrder::where('del_time',0)
  989. ->where('id',$data['id'])
  990. ->first();
  991. if(empty($sale)) return [false,'合同不存在或已被删除'];
  992. $sale = $sale->toArray();
  993. if($sale['sales_order_type'] != SalesOrder::Order_type_one) return [false,'非安装件合同,操作失败'];
  994. if($sale['state'] < SalesOrder::State_two) return [false,'合同还未确认,操作失败'];
  995. if($sale['state'] > SalesOrder::State_three) return [false,'请确认合同状态,操作失败'];
  996. $bool = SalesOrderProductInfo::where('del_time',0)
  997. ->where('sales_order_id',$data['id'])
  998. ->exists();
  999. if(! $bool) return [false,'合同产品不能为空'];
  1000. if(empty($data['dispatch_depart_one']) && empty($data['dispatch_employee'])) return [false, '请指派部门或人员'];
  1001. return [true, $sale];
  1002. }
  1003. /**
  1004. * 订单推送公司
  1005. * @param $data
  1006. * @return array
  1007. */
  1008. public function salesOrderDispatchCompany($data,$user){
  1009. list($status,$msg) = $this->salesOrderDispatchCompanyRule($data);
  1010. if(! $status) return [false,$msg];
  1011. try {
  1012. DB::beginTransaction();
  1013. $time = time();
  1014. SalesOrder::where('del_time',0)->where('id',$msg['id'])->update([
  1015. 'state' => SalesOrder::State_four,
  1016. 'dispatch_time_second' => $time,
  1017. 'dispatch_time_second_id' => $user['id']
  1018. ]);
  1019. SeeRange::where('del_time',0)
  1020. ->where('data_id',$msg['id'])
  1021. ->where('data_type',SeeRange::type_seven)
  1022. ->where('type',SeeRange::data_three)
  1023. ->update(['del_time' => $time]);
  1024. SalesOrderOtherFee::where('del_time',0)
  1025. ->where('sales_order_id',$msg['id'])
  1026. ->update(['del_time' => $time]);
  1027. if(! empty($data['dispatch_depart_two'])){
  1028. $insert = [];
  1029. foreach ($data['dispatch_depart_two'] as $value){
  1030. $insert[] = [
  1031. 'data_id' => $msg['id'],
  1032. 'data_type' => SeeRange::type_seven,
  1033. 'param_id' => $value,
  1034. 'type' => SeeRange::data_three,
  1035. 'crt_time' => $time,
  1036. ];
  1037. }
  1038. SeeRange::insert($insert);
  1039. }
  1040. if(! empty($data['other_fee_1'])){
  1041. $model = new SalesOrderOtherFee();
  1042. $model->sales_order_id = $msg['id'];
  1043. $model->other_fee_1 = $data['other_fee_1'] ?? 0;
  1044. $model->save();
  1045. }
  1046. (new OrderOperationService())->add([
  1047. 'order_number' => $msg['order_number'],
  1048. 'msg' => OrderOperation::$type[OrderOperation::two],
  1049. 'type' => OrderOperation::two
  1050. ],$user);
  1051. DB::commit();
  1052. }catch (\Exception $exception){
  1053. DB::rollBack();
  1054. return [false,$exception->getMessage()];
  1055. }
  1056. $depart_id = $data['dispatch_depart_two'][0] ?? 0;
  1057. if(! empty($depart_id) && $depart_id != $msg['top_depart_id']){
  1058. //发送消息
  1059. $notify_id = Depart::where('id',$depart_id)->value('notify_id');
  1060. if(! empty($notify_id)){
  1061. $emp_name = Employee::whereIn('id',[$msg['crt_id'], $notify_id])->pluck('emp_name','id')->toArray();
  1062. $tmp_data = [
  1063. $msg['order_number'],
  1064. $emp_name[$msg['crt_id']] ?? "",
  1065. $emp_name[$notify_id] ?? "" . "(派单通知)",
  1066. date('Y-m-d H:i:s'),
  1067. ];
  1068. (new OaService())->sendWxMsg($notify_id,1,1,37,$tmp_data);
  1069. }
  1070. }else{
  1071. //直接确认
  1072. SalesOrder::where('del_time',0)->where('id',$msg['id'])->update([
  1073. 'is_confirm' => 1,
  1074. ]);
  1075. }
  1076. return [true,''];
  1077. }
  1078. /**
  1079. * 订单推送公司规则
  1080. * @param $data
  1081. * @return array
  1082. */
  1083. public function salesOrderDispatchCompanyRule($data){
  1084. if(empty($data['id'])) return [false,'请选择合同派单'];
  1085. $sale = SalesOrder::where('del_time',0)
  1086. ->where('id',$data['id'])
  1087. ->first();
  1088. if(empty($sale)) return [false,'合同不存在或已被删除'];
  1089. $sale = $sale->toArray();
  1090. if($sale['sales_order_type'] != SalesOrder::Order_type_one) return [false,'非安装件合同,操作失败'];
  1091. if($sale['state'] < SalesOrder::State_three) return [false,'请确认合同状态,操作失败'];
  1092. if($sale['state'] > SalesOrder::State_four) return [false,'请确认合同状态,操作失败'];
  1093. $product = SalesOrderProductInfo::where('del_time',0)
  1094. ->where('sales_order_id',$data['id'])
  1095. ->select('product_id')
  1096. ->get()->toArray();
  1097. if(empty($product)) return [false,'合同产品不能为空'];
  1098. $bool = Construction::where('del_time',0)
  1099. ->where('sales_order_id',$data['id'])
  1100. ->exists();
  1101. if($bool) return [false,'合同已下施工,操作失败'];
  1102. if(empty($data['dispatch_depart_two'])) return [false, '请指派总社或分社'];
  1103. $product = array_unique(array_column($product,'product_id'));
  1104. $return = RangeService::productNotSeeRange($product);
  1105. if(! empty($return)){
  1106. $map = Product::whereIn('id',$product)->pluck('title','id')->toArray();
  1107. foreach ($data['dispatch_depart_two'] as $value){
  1108. foreach ($return as $key => $values){
  1109. $tmp = $map[$key] ?? "";
  1110. if(in_array($value, $values)) return [false,'产品'. $tmp .'对于该总社或分社不可见'];
  1111. }
  1112. }
  1113. }
  1114. if(empty($data['other_fee_1'])) return [false,'价格不能为空'];
  1115. $res = $this->checkNumber($data['other_fee_1']);
  1116. if(! $res) return [false,'价格请输入不超过两位小数并且大于0的数值'];
  1117. return [true, $sale];
  1118. }
  1119. public function salesOrderListsalesOrderWxList($data,$user){
  1120. $model = SalesOrder::where('del_time',0)
  1121. ->select('id','sales_order_type','model_type','order_number','selling_price','vin_no','car_type','order_type','customer_id','sign_time','crt_id','crt_time','mark','product_total','rate','construction_time','handover_time','other_fee','discount_fee','contract_fee','pay_way','car_type','year','mileage','color','original_set','processing','state','invoice_state','plat_type','plat_order','install_method','install_position','customer_contact','is_confirm')
  1122. ->orderby('id', 'desc');
  1123. if(! empty($data['openid'])){
  1124. $mobile = WxEmployee::where('openid',$data['openid'])->select('mobile')->get()->toArray();
  1125. $mobile = array_column($mobile,'mobile');
  1126. $customer_id = CustomerInfo::where('del_time',0)
  1127. ->where('type',CustomerInfo::type_one)
  1128. ->whereIn('contact_info',$mobile)
  1129. ->select('customer_id')
  1130. ->get()->toArray();
  1131. $customer_id = array_column($customer_id,'customer_id');
  1132. $model->whereIn('customer_id',$customer_id);
  1133. }
  1134. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  1135. $list = $this->limit($model,'',$data);
  1136. $list = $this->fillData($list,$data);
  1137. return [true, $list];
  1138. }
  1139. public function getInvoiceOrderData($data){
  1140. //分社订货模板
  1141. $search_id = [];
  1142. foreach ($data as $value){
  1143. if(! empty($value['invoice_state'])) $search_id[] = $value['id'];
  1144. }
  1145. if(empty($search_id)) return [];
  1146. $invoice = InvoiceOrder::where('del_time',0)
  1147. ->whereIn('sales_order_id',$search_id)
  1148. ->select('sales_order_id','order_number','logistics_number')
  1149. ->get()->toArray();
  1150. $invoice_array = [];
  1151. foreach ($invoice as $value){
  1152. $invoice_array[$value['sales_order_id']][] = $value['logistics_number'];
  1153. }
  1154. return $invoice_array;
  1155. }
  1156. public function getDispatchData($data){
  1157. //分社订货模板
  1158. $search_id = [];
  1159. foreach ($data as $value){
  1160. if($value['state'] >= SalesOrder::State_four) $search_id[] = $value['id'];
  1161. }
  1162. if(empty($search_id)) return [];
  1163. $see = SeeRange::where('del_time',0)
  1164. ->whereIn('data_id',$search_id)
  1165. ->where('data_type',SeeRange::type_seven)
  1166. ->where('type',SeeRange::data_three)
  1167. ->select('data_id','param_id')
  1168. ->get()->toArray();
  1169. $map = Depart::whereIn('id',array_unique(array_column($see,'param_id')))
  1170. ->pluck('title','id')
  1171. ->toArray();
  1172. $see_array = [];
  1173. foreach ($see as $value){
  1174. $see_array[$value['data_id']] = $map[$value['param_id']] ?? "";
  1175. }
  1176. return $see_array;
  1177. }
  1178. }