OrderController.php 26 KB

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