getAuthorizedOwners(); $service = app('OrderTrackingService'); $trackOrders = $service->paginate($request->input()); $logistics = Logistic::all(); return view('order.tracking.index', compact('owners', 'trackOrders','logistics')); } public function logisticUpdateApi(Request $request) { if (!Gate::allows('订单管理-跟踪-物流公司编辑')) return redirect(url('/')); try { $bool = app(OrderTrackingService::class)->updateOrderTracingAndSyc($request->input('id'),$request->input('param'),$request->input('value')); LogService::log(__METHOD__, __FUNCTION__, '更新成功' . json_encode($request->getContent()) ); return $bool; } catch (\Exception $e) { LogService::log(__METHOD__, __FUNCTION__, '更新失败' . json_encode($request->getContent()) .'||'.$e->getMessage().'||'.$e->getTraceAsString()); return ['success' => false]; } } public function warehouseUpdateApi(Request $request) { if (!Gate::allows('订单管理-跟踪-仓库编辑')) return redirect(url('/')); try { $bool = app(OrderTrackingService::class)->updateOrderTracingAndSyc($request->input('id'),$request->input('param'),$request->input('value')); LogService::log(__METHOD__, __FUNCTION__, '更新成功' . json_encode($request->getContent())); return $bool; } catch (\Exception $e) { LogService::log(__METHOD__, __FUNCTION__, '更新失败' . json_encode($request->getContent()) .'||'.$e->getMessage().'||'.$e->getTraceAsString()); return ['success' => false]; } } public function export(Request $request) { if (!Gate::allows('订单管理-跟踪')) return redirect(url('/')); /** @var OrderTrackingService $service */ $service = app(OrderTrackingService::class); $sql = $service->getSql($request->input()); $row = ['公司','订单号','WEB+订单号','提货日期','销售','客户','SKU','物料描述','数量','订单备注','重量','体积', '托盘合计','运输方式','运输单号','到达城市','应送达时间','是否赶上卡班','到货情况','签收日期','签收单情况','备注']; $column = ['owners_name','order_client_code','web_order_number','pick_up_at','sale','client','sku','sku_name','amount','order_remark', 'gross_weight','bulk','pallet_total','logistic_name','logistic_number','city','planning_sent_at','is_on_duty_shift','is_arrival','signed_at','receive_bill_status','remark']; $mergeColumn = ['M']; $rule = ["pick_up_at"=> "mysqlDate"]; $post = Http::post(config('go.export.url'),['type'=>'unify','sql'=>$sql, 'connection'=>'mysql','rule' => json_encode($rule), 'row'=>json_encode($row,JSON_UNESCAPED_UNICODE), 'column'=>json_encode($column), 'mergeColumn'=>json_encode($mergeColumn),'datum'=>'pick_up_at','createFormat'=>'merge']); if ($post->status() == 500){ throw new Exception($post->header("Msg")); } return response($post,200, [ "Content-type"=>"application/octet-stream", "Content-Disposition"=>"attachment; filename=订单跟踪件-".date('ymdHis').'.xlsx', ]); } }