baoshi-was/app/Http/Controllers/OrderTrackingController.php

<?php

namespace App\Http\Controllers;

use App\Logistic;
use App\Services\LogService;
use App\Services\OrderTrackingService;
use App\Services\OwnerService;
use Exception;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Gate;
use Illuminate\Support\Facades\Http;

class OrderTrackingController extends Controller
{

    public function index(Request $request)
    {
        if (!Gate::allows('订单管理-跟踪'))
            return redirect(url('/'));

        $owners =  app(OwnerService::class)->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",'planning_sent_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',
        ]);

    }
}