OrderController.php 27 KB

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