OrderController.php 27 KB

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