OrderController.php 27 KB

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