OrderController.php 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Components\Database;
  4. use App\Http\Requests\OrderDelivering;
  5. use App\OracleActAllocationDetails;
  6. use App\OracleDOCOrderHeader;
  7. use App\OracleDOCWaveDetails;
  8. use App\OrderIssueType;
  9. use App\OrderPackage;
  10. use App\Services\LogisticService;
  11. use App\Services\LogService;
  12. use App\Services\OrderPackageService;
  13. use App\Services\OrderService;
  14. use App\Services\RejectedBillItemService;
  15. use App\Services\RejectedBillService;
  16. use Illuminate\Database\Eloquent\Builder;
  17. use Illuminate\Http\Request;
  18. use Illuminate\Support\Facades\Auth;
  19. use Illuminate\Support\Facades\DB;
  20. use Illuminate\Support\Facades\Gate;
  21. use Oursdreams\Export\Export;
  22. use function DeepCopy\deep_copy;
  23. class OrderController extends Controller
  24. {
  25. use Database;
  26. public function delivering(OrderDelivering $request){
  27. /** @var OrderService $orderService */
  28. $orderService = app('OrderService');
  29. $request = $request->input();
  30. $owners = app('OwnerService')->getIntersectPermitting(['id','code']);
  31. $service=app(LogisticService::class);
  32. $logistics=$service->getSelection(['id','name']);
  33. $codes = array_column($owners->toArray(),'code');
  34. if ($request['customerid'] ?? false){
  35. $arr = explode(',',$request['customerid']);
  36. $request['customerid'] = [];
  37. foreach ($arr as $value){
  38. if (in_array($value,$codes))$request['customerid'][] = $value;
  39. }
  40. if (count($request['customerid']) < 1)$request['customerid'] = [''];
  41. }else $request['customerid'] = $codes;
  42. $result = $orderService->paginate($request);
  43. $picktotraceids = $result['picktotraceids'];
  44. $orders = $result['orders'];
  45. $orderService->tagOrderByOrderIssue($orders);
  46. $commodities = $result['commodities'];
  47. $customers=app('OracleBasCustomerService')->getCustomers($codes);
  48. $page = $request["page"] ?? 1;
  49. $codes=DB::connection('oracle')->table('BAS_CODES')->select('code','codename_c')->where('codeid','SO_STS')->orderBy('code','asc')->get();
  50. $orderIssueType = OrderIssueType::all();
  51. return view('order/index/delivering',compact('orders','customers','request','codes','commodities','page','picktotraceids','orderIssueType','logistics'));
  52. }
  53. //导出
  54. public function export(Request $request){
  55. $is_merge = $request->is_merge ?? false;
  56. /** @var OrderService $orderService */
  57. $orderService = app('OrderService');
  58. $req = ['type'=>'order'];
  59. if ($is_merge && $is_merge == 'true')$req["createFormat"] = "merge";
  60. if ($request->data){
  61. $req["sql"] = $orderService->getSql(['data'=>$request->data]);
  62. }else{
  63. $req["sql"] = $orderService->getSql($request->input());
  64. }
  65. $e = new Export();
  66. $e->setOracleConnection(config('database.connections.oracle.host'),
  67. config('database.connections.oracle.port'),config('database.connections.oracle.database')
  68. ,config('database.connections.oracle.username'),config('database.connections.oracle.password'));
  69. if ($is_merge && $is_merge == 'true'){
  70. $e->setMergeFormat([
  71. "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P",
  72. "Q","R","S","Z","AA","AB","AC","AD"
  73. ]);
  74. $e->setDatum("ORDERNO");
  75. } else $e->setWarpTextFormat();
  76. $e->setFileName("订单记录-".date('ymdHis'));
  77. return $e->sql($req["sql"],[
  78. "ORDERNO"=>"编号","ORDERCODENAME"=>"订单状态",
  79. "NOTES"=>"备注","ADDTIME"=>"接口下发时间",
  80. "ISSUEPARTYNAME"=>"店铺名称","CUSTOMER_DESCR_C"=>"客户",
  81. "SOREFERENCE1"=>"客户订单号","CARRIERNAME"=>"承运人",
  82. "SOREFERENCE5"=>"快递单号","C_CONTACT"=>"收货人名称","C_TEL2"=>"收货人电话",
  83. "C_PROVINCE"=> "省","C_CITY"=>"市","C_DISTRICT"=>"区","C_ADDRESS1"=>"收货人地址",
  84. "WAVENO"=>"波次编号","WAREHOUSEID"=>"仓库","EDISENDFLAG2"=>"快递获取标记","EDISENDTIME2"=>"快递获取时间",
  85. "SKU"=>"产品代码","ALTERNATE_SKU1"=>"产品条码","ORDERDETAILCODENAME"=>"明细状态","DESCR_C"=> "产品名称",
  86. "QTYORDERED"=>"订单数量","CHECKTIME"=>"复核时间","ERPCANCELFLAG"=>"接口取消标记",
  87. "PICKING_PRINT_FLAG"=>"拣货单打印标记","EDISENDFLAG"=>"接口回传标记","EDIREMARKS2"=>"接口回传异常备注",
  88. "RELEASESTATUS"=>"订单冻结"],["ADDTIME"=>"date","EDISENDTIME2"=>"date"])->direct();
  89. }
  90. public function createRejectedBill(Request $request){
  91. if(!Gate::allows('订单管理-订单-生成退货单')){ return ['success'=>false,'data'=>'您无权操作!']; }
  92. /** @var OrderService $orderService */
  93. $orderService = app('OrderService');
  94. $result = $orderService->get(['data' => $request->data]);
  95. /** @var RejectedBillService $rejectedBillService */
  96. $rejectedBillService = app('RejectedBillService');
  97. /** @var RejectedBillItemService $rejectedBillItemService */
  98. $rejectedBillItemService = app('RejectedBillItemService');
  99. $commodities = $result['commodities'];
  100. $rejectedBillItems = [];
  101. //分箱号
  102. $picktotraceids = json_decode($result['picktotraceids'],true);
  103. $rejectedBill_collect = collect();// 保存生成的rejectedBill
  104. foreach ($result['orders'] as $order){
  105. $blacklist = ["00","10","20","30","90"/*,"99"*/];
  106. if (array_search($order->sostatus,$blacklist) !== false)return ['success'=>false,'data'=>'“'.$order->orderno."”状态异常,无法操作"];
  107. }
  108. foreach ($result['orders'] as $order){
  109. //不存在时将当前快递单号视为分箱号
  110. if (!($picktotraceids[$order->orderno] ?? false))$picktotraceids[$order->orderno] = [$order->soreference5];
  111. //获取货主与快递方
  112. $owner = app('OwnerService')->firstOrCreate(['name' => $order->customer_descr_c],
  113. ['name' => $order->customer_descr_c, 'code' => $order->customer_descr_c]);
  114. $logistic = app('LogisticService')->firstOrCreate(['name' => $order->carriername],
  115. ['name' => $order->carriername, 'code' => $order->carriername]);
  116. foreach ($picktotraceids[$order->orderno] as $orderno){
  117. $rejectedBill = $rejectedBillService->create([
  118. 'id_owner' => $owner->id,
  119. 'sender' => $order->c_contact,
  120. 'logistic_number_return' => $orderno,
  121. 'id_logistic_return' => $logistic->id,
  122. 'order_number' => $order->soreference1,
  123. 'mobile_sender' => empty($order->c_tel2)?$order->c_tel1:$order->c_tel2,
  124. 'logistic_number' => '原单退回',//$order->soreference1
  125. 'remark' => $order->notes,
  126. 'is_loaded' =>0,
  127. "id_operator" => Auth::id(),
  128. ]);
  129. $rejectedBill_collect->push($rejectedBill);// 保存生成的rejectedBill
  130. LogService::log(__METHOD__,"生成退货单",json_encode($order),Auth::user()['id']);
  131. $cms = $commodities[$order->orderno] ?? [];
  132. if (count($picktotraceids[$order->orderno]) > 0 && $cms){
  133. $sql = <<<sql
  134. SELECT sum(QTY) qty,sku FROM ACT_ALLOCATION_DETAILS where ORDERNO = ? and PICKTOTRACEID = ? GROUP BY sku
  135. sql;
  136. $acts = DB::connection("oracle")->select(DB::raw($sql),[$order->orderno,$orderno]);
  137. $skus = array_column($acts,"sku");
  138. foreach ($cms as $orderCommodities){
  139. $index = array_search($orderCommodities["sku"],$skus);
  140. if ($index === false)continue;
  141. array_push($rejectedBillItems,[
  142. 'id_rejected_bill' => $rejectedBill->id,
  143. 'barcode_goods' => $orderCommodities['alternate_sku1'],
  144. 'name_goods' => $orderCommodities['descr_c'],
  145. 'amount' => $acts[$index]->qty,//$orderCommodities['qtyordered'],
  146. 'id_quality_label' => 1,
  147. 'created_at' => date('Y-m-d H:i:s'),
  148. ]);
  149. }
  150. }
  151. }
  152. }
  153. $rejectedBillItemService->insert($rejectedBillItems);
  154. LogService::log(__METHOD__,"批量生成退货单详情",json_encode($rejectedBillItems),Auth::user()['id']);
  155. $rejectedBill_collect->each(function($rejectedBill)use($rejectedBillService){
  156. $rejectedBillService->joinOrderIssue($rejectedBill);
  157. $rejectedBillService->syncOrderIssue($rejectedBill);
  158. });
  159. return ['success'=>true];
  160. }
  161. public function isRejectedBillExist(Request $request){
  162. if(!Gate::allows('订单管理-订单-生成退货单')){ return redirect(url('/')); }
  163. /** @var RejectedBillService $rejectedBillService */
  164. $rejectedBillService = app('RejectedBillService');
  165. $rejectedBills = $rejectedBillService->get(['order_number' => $request->data]);
  166. if (count($rejectedBills) == 0)return ['success'=>true];
  167. return ['success'=>false, 'data'=>json_encode(array_column($rejectedBills->toArray(),'order_number'))];
  168. }
  169. //批量备注追加
  170. public function batchComments(Request $request){
  171. if(!Gate::allows('订单管理-批量备注')){ return redirect(url('/')); }
  172. $checkData=$request->input('checkData');
  173. $content=$request->input('content');
  174. $ordersNotNull=OracleDOCOrderHeader::query()->select('OrderNo','Notes')->whereIn('orderno',$checkData)
  175. ->whereNotNull('notes')->get();
  176. OracleDOCOrderHeader::query()->select('OrderNo','Notes')->whereIn('orderno',$checkData)
  177. ->whereNull('notes')->update(['notes'=>$content]);
  178. $ordersNotNullArr=array_column($ordersNotNull->toArray(),'orderno');
  179. $ordersNullArr=array_diff($checkData,$ordersNotNullArr);
  180. $data=[];
  181. foreach ($ordersNotNull as $order){
  182. OracleDOCOrderHeader::query()->where('orderno',$order->orderno)->update(["notes"=>($order->notes).",".$content]);
  183. app('LogService')->log(__METHOD__,'批量备注追加修改'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  184. $order->notes=($order->notes).",".$content;
  185. array_push($data,$order);
  186. }
  187. foreach ($ordersNullArr as $order){
  188. array_push($data,["orderno"=>$order,'notes'=>$content]);
  189. }
  190. return $data;
  191. }
  192. //批量冻结
  193. public function freezeAll(Request $request){
  194. if(!Gate::allows('订单管理-编辑')){ return redirect(url('/')); }
  195. $checkData=$request->input('checkData')??'';
  196. //冻结条件只局限于 分配完成sostatus=40 创建订单sostatus=00 拣货完成sostatus=60 播种完成sostatus=61
  197. $sostatus=['40','00','60','61'];
  198. $orders=OracleDOCOrderHeader::select('OrderNo','SoStatus')->whereIn('orderno',$checkData)->whereIn('SoStatus',$sostatus)->get();
  199. if(count($checkData)!=count($orders))return ['success'=>false,'fail_info'=>"勾选订单有不可冻结订单"];
  200. foreach ($orders as $order){
  201. $waveno=OracleDOCOrderHeader::where('orderno',$order->orderno)->value('waveno');
  202. if ($waveno && $waveno!='*'){
  203. OracleDOCWaveDetails::where('waveno',$waveno)->where('orderno',$order->orderno)->delete();
  204. app('LogService')->log(__METHOD__,'批量冻结删除波次号'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  205. }
  206. $is_freeze=OracleDOCOrderHeader::where('orderno',$order->orderno)->update(['releasestatus'=>'H','waveno'=>'*']);
  207. app('LogService')->log(__METHOD__,'批量冻结修改'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  208. if (!$is_freeze)return ['success'=>false,'fail_info'=>"数据 {$order['orderno']} 更新失败"];
  209. }
  210. return ['success'=>true];
  211. }
  212. //批量取消分配
  213. public function deAllocationAll(Request $request){
  214. if(!Gate::allows('订单管理-编辑')){ return redirect(url('/')); }
  215. $checkData=$request->input('checkData')??'';
  216. //取消分配条件只局限于 分配完成sostatus=40 和 部分分配sostatus=30
  217. $sostatus=['30','40'];
  218. $orders=OracleDOCOrderHeader::select('OrderNo','SoStatus')->whereIn('orderno',$checkData)->whereIn('SoStatus',$sostatus)->get();
  219. if(count($checkData)!=count($orders))return ['success'=>false,'fail_info'=>"勾选订单有不可取消分配订单"];
  220. foreach ($orders as $order){
  221. $is_deAllocation=$this->isDeAllocation($order->orderno);
  222. $waveno=OracleDOCOrderHeader::where('orderno',$order->orderno)->value('waveno');
  223. if ($waveno && $waveno!='*'){
  224. OracleDOCWaveDetails::where('waveno',$waveno)->where('orderno',$order->orderno)->delete();
  225. app('LogService')->log(__METHOD__,'批量取消分配删除波次号'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  226. }
  227. $deAllocation=OracleDOCOrderHeader::where('orderno',$order->orderno)->update(['sostatus'=>'00','waveno'=>'*']);
  228. app('LogService')->log(__METHOD__,'批量取消分配'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  229. if (!$is_deAllocation||!$deAllocation)return ['success'=>false,'fail_info'=>"数据 {$order['orderno']} 更新失败"];
  230. }
  231. return ['success'=>true];
  232. }
  233. //冻结
  234. public function freeze(Request $request){
  235. if(!Gate::allows('订单管理-编辑')){ return redirect(url('/')); }
  236. $orderno=$request->input('orderno');
  237. $waveno=$request->input('waveno');
  238. if ($waveno && $waveno!='*'){
  239. OracleDOCWaveDetails::where('waveno',$waveno)->where('orderno',$orderno)->delete();
  240. app('LogService')->log(__METHOD__,'冻结删除波次号'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  241. }
  242. OracleDOCOrderHeader::where('orderno',$orderno)->update(['releasestatus'=>'H','waveno'=>'*']);
  243. app('LogService')->log(__METHOD__,'冻结'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  244. return ['success'=>true];
  245. }
  246. public function thaw(Request $request){
  247. if(!Gate::allows('订单管理-编辑')){ return redirect(url('/')); }
  248. $orderno = $request->orderno;
  249. if (!is_array($orderno)) {
  250. $orderno = [$orderno];
  251. }
  252. OracleDOCOrderHeader::query()->whereIn('orderno',$orderno)->update(['releasestatus'=>'N']);
  253. app('LogService')->log(__METHOD__,'解冻'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  254. return ['success'=>true];
  255. }
  256. //重置快递获取标记
  257. public function resetLogisticsGetMark(Request $request){
  258. if(!Gate::allows('订单管理-编辑')){ return redirect(url('/')); }
  259. $orderno=$request->orderno;
  260. OracleDOCOrderHeader::query()->whereIn('orderno',$orderno)->where('edisendflag2','W')->update(['edisendflag2'=>'N']);
  261. app('LogService')->log(__METHOD__,'解冻'.__FUNCTION__,json_encode($orderno),Auth::user()['id']);
  262. return ['success'=>true];
  263. }
  264. //取消分配
  265. public function deAllocation(Request $request){
  266. if(!Gate::allows('订单管理-编辑')){ return redirect(url('/')); }
  267. $orderno=$request->input('orderno');
  268. $waveno=$request->input('waveno');
  269. if ($waveno && $waveno!='*'){
  270. OracleDOCWaveDetails::where('waveno',$waveno)->where('orderno',$orderno)->delete();
  271. app('LogService')->log(__METHOD__,'取消分配删除波次号'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  272. }
  273. OracleDOCOrderHeader::where('orderno',$orderno)->update(['sostatus'=>'00','waveno'=>'*']);
  274. app('LogService')->log(__METHOD__,'取消分配'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  275. $is_deAllocation=$this->isDeAllocation($orderno);
  276. if($is_deAllocation) return ['success'=>true];
  277. }
  278. //调用sp取消选中订单的分配
  279. public function isDeAllocation($orderno){
  280. $username=config('database.connections.oracle.username');
  281. $password=config('database.connections.oracle.password');
  282. $host=config('database.connections.oracle.host');
  283. $service_name=config('database.connections.oracle.service_name');
  284. $conn=oci_connect($username,$password,$host.'/'.$service_name,'utf8'); //连接oracle数据库
  285. $IN_Warehouse='';
  286. $IN_Process_Action_C='' ;
  287. $IN_Process_By_C='By OrderNO';
  288. $IN_WaveNO_C='';
  289. $IN_OrderNO_C=$orderno;
  290. $IN_OrderLineNO_C='';
  291. $IN_AllocationDetailsID='';
  292. $IN_Language='';
  293. $IN_UserID='';
  294. $OUT_Return_Code='';
  295. $sql_sp="begin SPSO_DEALLOCATION_PROCESS(:IN_Warehouse,:IN_Process_Action_C,:IN_Process_By_C,
  296. :IN_WaveNO_C,:IN_OrderNO_C,:IN_OrderLineNO_C,:IN_AllocationDetailsID,:IN_Language,:IN_UserID,:OUT_Return_Code); end;";
  297. $stmt = oci_parse($conn, $sql_sp);
  298. oci_bind_by_name($stmt,':IN_Warehouse',$IN_Process_Action_C);
  299. oci_bind_by_name($stmt,':IN_Process_Action_C',$IN_Warehouse);
  300. oci_bind_by_name($stmt,':IN_Process_By_C',$IN_Process_By_C);
  301. oci_bind_by_name($stmt,':IN_WaveNO_C',$IN_WaveNO_C);
  302. oci_bind_by_name($stmt,':IN_OrderNO_C',$IN_OrderNO_C);
  303. oci_bind_by_name($stmt,':IN_OrderLineNO_C',$IN_OrderLineNO_C);
  304. oci_bind_by_name($stmt,':IN_AllocationDetailsID',$IN_AllocationDetailsID);
  305. oci_bind_by_name($stmt,':IN_Language',$IN_Language);
  306. oci_bind_by_name($stmt,':IN_UserID',$IN_UserID);
  307. oci_bind_by_name($stmt,':OUT_Return_Code',$OUT_Return_Code,300);
  308. oci_execute($stmt);
  309. if (substr($OUT_Return_Code,0,3) != '000'){
  310. app('LogService')->log(__METHOD__,'调用sp根据订单取消分配失败'.__FUNCTION__,"ORDERNO:".$orderno."ERROR:".$OUT_Return_Code);
  311. return false;
  312. }
  313. oci_close($conn);
  314. return true;
  315. }
  316. public function resetInterfaceReturnMark(Request $request)
  317. {
  318. if(!Gate::allows('订单管理-编辑')){ return redirect(url('/')); }
  319. $orderno=$request->orderno;
  320. $oldIds =OracleDOCOrderHeader::query()
  321. ->whereIn('orderno', $orderno)
  322. ->where('edisendflag', 'N')->pluck('orderno')->toArray();
  323. OracleDOCOrderHeader::query()
  324. ->whereIn('orderno',$orderno)
  325. ->where('sostatus','99')
  326. ->whereIn('edisendflag',['R','W'])
  327. ->where('addwho','EDI')
  328. ->update(['edisendflag'=>'N']);
  329. $failedOrdernos =OracleDOCOrderHeader::query()
  330. ->whereIn('orderno', $orderno)
  331. ->where('edisendflag', '!=', 'N')->pluck('orderno');
  332. $successedOrdernos =OracleDOCOrderHeader::query()
  333. ->whereIn('orderno', array_diff($orderno,$oldIds))
  334. ->where('edisendflag', 'N')->pluck('orderno');
  335. app('LogService')->log(__METHOD__,'重置接口回传标记'.__FUNCTION__,json_encode($orderno),Auth::user()['id']);
  336. if (count($failedOrdernos)==0) {
  337. return ['success'=>true];
  338. } else {
  339. return ['success'=>false,'fail_info'=>"数据 {$failedOrdernos} 更新失败,数据{$successedOrdernos}更新成功"];
  340. }
  341. }
  342. /**
  343. * @param Request $request
  344. * @return array
  345. * 一键回传功能
  346. */
  347. public function manualBack(Request $request): array
  348. {
  349. if(!Gate::allows('订单管理-订单-一键回传'))return["success"=>false,"data"=>"无权操作"];
  350. /** @var OrderService $orderService */
  351. $orderService=app(OrderService::class);
  352. $orderNos=$request->input('ordernos');
  353. $failNo=array();
  354. $successNo=array();
  355. $docOrders=OracleDOCOrderHeader::query()
  356. ->whereIn('orderno',$orderNos)
  357. ->get();
  358. /** @var OrderService $service */
  359. $service=app("OrderService");
  360. foreach ($docOrders as $order){
  361. if ($order->sostatus=='00' || $order->sostatus=='10' || $order->sostatus=='20'){
  362. $res = $service->allocation($order->orderno,null,$order->warehouseid);
  363. if (mb_substr($res,0,3)!='000') {
  364. array_push($failNo,$order->orderno);
  365. app('LogService')->log(__METHOD__,'手动回传分配失败'.__FUNCTION__,json_encode($order->orderno),Auth::user()['id']);
  366. }
  367. }
  368. }
  369. foreach ($orderNos as $no){
  370. $res=$orderService->manualBack($no);
  371. if (!$res){
  372. array_push($failNo,$no);
  373. app('LogService')->log(__METHOD__,'人工回传失败'.__FUNCTION__,json_encode($no),Auth::user()['id']);
  374. }else{
  375. array_push($successNo,$no);
  376. }
  377. }
  378. if (count($orderNos)>=count($failNo))return ["success"=>true,"successNo"=>$orderNos,"failNo"=>$failNo];
  379. else return ["success"=>false,"failNo"=>$failNo];
  380. }
  381. public function allocation(Request $request):array
  382. {
  383. if(!Gate::allows('订单管理-编辑'))return["status"=>'fail',"msg"=>"无权操作"];
  384. $list = $request->input("list",[]);
  385. $error = [];
  386. /** @var OrderService $service */
  387. $service=app("OrderService");
  388. $conn = null;
  389. foreach ($list as $item){
  390. if (!$item["number"]){
  391. $error[] = "'{$item["code"]}'尚未获取快递单号";
  392. continue;
  393. }
  394. if ((int)$item["status"]>30){
  395. $error[] = "'{$item["code"]}'已被分配";
  396. continue;
  397. }
  398. if (!$conn)$conn = $this->getFluxConnection();
  399. $res = $service->allocation($item["code"],null,$item["warehouse"],$conn);
  400. if (mb_substr($res,0,3)=='000')continue;
  401. $error[] = "'{$item["code"]}'{$res}";
  402. }
  403. if ($conn)$this->releaseFluxConnection($conn);
  404. if (!$error)return["status"=>'success'];
  405. $txt = implode(",",$error);
  406. return["status"=>'part',"msg"=>$txt];
  407. }
  408. /**
  409. * 一键揽收分配
  410. * @param Request $request
  411. * @return array
  412. */
  413. public function collectUpload(Request $request): array
  414. {
  415. $inOrderno = $request->orderno;
  416. $strict = $request->strict;
  417. if (empty($inOrderno)) return ['success' => false, 'message' => '选择为空'];
  418. $orderno = deep_copy($inOrderno);
  419. /**
  420. * 是否是严格模式
  421. * 是
  422. * 根据筛选条件
  423. * 1. 状态 61 81
  424. * 2. 承运商是中通
  425. * 3. 有单号
  426. * 4. 有复核,
  427. * 5. 没揽收
  428. * 否
  429. * 筛选出快递单号
  430. * 将快递单号调用一键揽收
  431. * 如果返回异常,记录异常
  432. * 调用分配
  433. * 将入参与过滤结果取差集合,结果就是不复核的单号,作为错误提示返回
  434. */
  435. //严格模式,校验订单与包裹状态
  436. if ($strict) {
  437. $logisticNums = OracleActAllocationDetails::query()
  438. ->select('picktotraceid')
  439. ->whereIn('orderno', $orderno)
  440. ->whereNotNull('picktotraceid')//有单号
  441. ->whereNotNull('checktime')//有复核
  442. ->whereIn('orderno', function (Builder $query) use ($orderno) {
  443. $query->from('doc_order_header')
  444. ->select('orderno')
  445. ->whereIn('orderno', $orderno)
  446. ->whereIn('carriername', ['中通(轻小包裹)', '中通', '中通速递']) // 承运商是中通
  447. ->whereBetween('sostatus', [61, 81]); //状态 61 81
  448. })
  449. ->pluck('picktotraceid');
  450. $logisticNums = OrderPackage::query()
  451. ->select('logistic_number')
  452. ->whereIn('logistic_number', $logisticNums)
  453. ->whereNull('transfer_status')
  454. ->pluck('logistic_number');
  455. }else{
  456. //非严格模式 不进行任何校验
  457. $logisticNums = OracleActAllocationDetails::query()
  458. ->select('picktotraceid')
  459. ->whereIn('orderno', $orderno)
  460. ->pluck('picktotraceid');
  461. }
  462. //调用一键揽收
  463. /** @var OrderPackageService $orderPackageService */
  464. $orderPackageService = app('OrderPackageService');
  465. $collectUpLoadResult = $orderPackageService->collectUpload($logisticNums->toArray());
  466. $error = [];
  467. //揽收有异常记录
  468. if (!$collectUpLoadResult['success']) {
  469. $error['collectUpload'] = $collectUpLoadResult['message'];
  470. }
  471. /** @var OrderService $orderService */
  472. $orderService = app('OrderService');
  473. //根据快递单号查询orderno
  474. $allocationOrdernos = OrderPackage::query()
  475. ->whereIn('logistic_number', $logisticNums)
  476. ->leftJoin('orders', 'order_id', '=', 'orders.id')
  477. ->pluck('code');
  478. //调用分配接口
  479. $allocationOrdernos->each(function ($orderno) use ($orderService) {
  480. $orderService->allocation($orderno);
  481. });
  482. if ($strict) {
  483. //输入的orderno与最终可以一键揽收的orderno取差集合
  484. $errorOrderno = array_diff($inOrderno, $allocationOrdernos->toArray());
  485. }
  486. $result = [];
  487. if (!empty($error)) {
  488. $result['success'] = false;
  489. $result['error_message'] = $error;
  490. }else if(!empty($errorOrderno)){
  491. $result['success'] = false;
  492. $result['error_message'][] = $error;
  493. }
  494. else {
  495. $result['success']=true;
  496. $result['message']='一键揽收分配完成';
  497. }
  498. return $result;
  499. }
  500. }