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

<?php

namespace App\Http\Controllers;

use App\AuditLog;
use App\BillingModel;
use App\Carrier;
use App\CarType;
use App\City;
use App\Exports\WaybillExport;
use App\Owner;
use App\Unit;
use App\Waybill;
use App\WaybillCalculate;
use App\WaybillFinancialSnapshot;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Gate;
use Illuminate\Support\Facades\Validator;
use Maatwebsite\Excel\Facades\Excel;
use Ramsey\Uuid\Uuid;

class WaybillsController extends Controller
{

    public function index(Request $request)
    {
        if(!Gate::allows('运单管理-查询')){ return redirect(url('/'));  }
        $data=$request->input();
        if ($data != null ) {
            $today=Carbon::now()->subDays(15);
            $waybills=Waybill::with(['owner', 'auditLogs' => function ($query) {
                return $query->with('user');
            }]);
            if ($request->input('waybill_number')){
                $waybills =$waybills->where('waybill_number','like','%'.$request->input('waybill_number').'%')->where('created_at','>',$today->format('Y-m-d'));
            }
            if ($request->input('carrier_bill')){
                $waybills=$waybills->where('carrier_bill','like','%'.$request->input('carrier_bill').'%')->where('created_at','>',$today->format('Y-m-d'));
            }
            if ($request->input('carrier_id')){
                $waybills=$waybills->where('carrier_id','=',$request->input('carrier_id'));
            }
            if ($request->input('owner_id')){
                $waybills=$waybills->where('owner_id','=',$request->input('owner_id'));
            }
            if ($request->input('wms_bill_number')){
                $waybills=$waybills->where('wms_bill_number','like','$'.$request->input('wms_bill_number').'%')->where('created_at','>',$today->format('Y-m-d'));
            }
            if ($request->input('created_at_start')){
                $waybills=$waybills->where('created_at','>',$request->input('created_at_start'));
            }
            if ($request->input('created_at_end')){
                $waybills=$waybills->where('created_at','<',$request->input('created_at_end'));
            }
            if ($request->input('type')){
                $waybills=$waybills->where('type','=',$request->input('type'));
            }
            $waybills=$waybills->paginate($request->input('paginate')?$request->input('paginate'):50);
            $carries = Carrier::get();
            $owners = Owner::get();
            return view('waybill.index', ['waybills' => $waybills, 'carriers' => $carries, 'owners' => $owners,'filterData'=>$data]);
        } else {
            $waybills = Waybill::with(['owner', 'auditLogs' => function ($query) {
                return $query->with('user');
            }])->paginate(50);
            $carries = Carrier::get();
            $owners = Owner::get();
            return view('waybill.index', ['waybills' => $waybills, 'carriers' => $carries, 'owners' => $owners,'filterData'=>$data]);

        }
    }
    public function create()
    {
        if(!Gate::allows('运单管理-录入')){ return redirect(url('/'));  }
        $owners=Owner::get();
        return view('waybill.create',['owners'=>$owners]);
    }

    public function store(Request $request)
    {
        if(!Gate::allows('运单管理-录入')){ return redirect(url('/'));  }
        $this->validatorWaybill($request)->validate();
        $data=$request->input();

        $waybill=new Waybill([
            'type'=>$data['type'],
            'state'=>'未审核',
            'waybill_number'=>Uuid::uuid1(),
            'owner_id'=>$data['owner_id'],
            'wms_bill_number'=>$data['wms_bill_number'],
            'origination'=>$data['origination'],
            'destination'=>$data['destination'],
            'recipient'=>$data['recipient'],
            'recipient_mobile'=>$data['recipient_mobile'],
            'charge'=>$data['charge'],
            'ordering_remark'=>$data['ordering_remark']
        ]);
        $waybill->save();
        $number_id=$waybill->id;
        if ($data['type']=='直发'){
            $waybill_number='BSZF'.date ("ymd").str_pad($number_id>99999?$number_id%99999:$number_id,4,"0",STR_PAD_LEFT);
            $waybill->waybill_number=$waybill_number;
            $waybill->update();
        }else{
            $waybill_number='BSZX'.date ("ymd").str_pad($number_id>99999?$number_id%99999:$number_id,4,"0",STR_PAD_LEFT);
            $waybill->waybill_number=$waybill_number;
            $waybill->update();
        }
        $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
        return redirect('waybill')->with('successTip','新运单“'.$waybill_number.'”录入成功');
    }

    public function edit($id)
    {
        if(!Gate::allows('运单管理-编辑')){ return redirect(url('/'));  }
        $waybill=Waybill::find($id);
        $carriers=Carrier::get();
        $cities=City::get();
        $units=Unit::get();
        $carTypes=CarType::get();
        return view('waybill/edit',['waybill'=>$waybill,'carriers'=>$carriers,'cities'=>$cities,'units'=>$units,'carTypes'=>$carTypes]);
    }

    public function update(Request $request, $id)
    {
        if(!Gate::allows('运单管理-调度')){ return redirect(url('/'));  }
        $this->validatorWaybillDispatch($request)->validate();
        $data=$request->input();
        $waybill=Waybill::find($id);

        if ($waybill->type=="专线"){
            $carrier_weight=$request->input('carrier_weight');
            $isBillingModel=BillingModel::whereRaw('carrier_id = ? and city_id = ? and unit_id = ? and range_min < ? and range_max >= ?',[
                    $request->input('carrier_id'),$request->input('destination_city_id'),
                    $request->input('warehouse_weight_unit_id'),$carrier_weight,
                    $carrier_weight
            ])->first();
            if ($isBillingModel==null){
                return redirect()->back()->with('notBillingModel','计费模型未定义')->withInput();
            }
        }
        $waybill->fill($data);
        if ($waybill->save()){
            if ($waybill->type=="直发"){
                $total_receivable=($waybill->charge);
                $total_expense=($waybill->fee)+($waybill->other_fee)-($waybill->collect_fee);
            }else if ($waybill->type=="专线"){
                if ($carrier_weight<$isBillingModel->initial_weight){
                    $fee=($isBillingModel->unit_price)*($isBillingModel->initial_weight);
                }else{
                    $fee=($isBillingModel->unit_price)*$carrier_weight;
                }
                $waybill->fee=$fee;
                $waybill->save();
                $total_receivable=($waybill->charge);
                $total_expense=($waybill->pick_up_fee)+($waybill->other_fee)+($waybill->fee);
            }
            $waybillCalculate=WaybillCalculate::where('waybill_id','=',$id)->first();
            if ($waybillCalculate){
                $waybillCalculate->waybill_id=$id;
                $waybillCalculate->total_expense=$total_expense;
                $waybillCalculate->total_receivable=$total_receivable;
                $waybillCalculate->gross_margin=$total_receivable-$total_expense;
                $waybillCalculate->gross_profit_rate=(($total_receivable-$total_expense)/$total_receivable);
                $waybillCalculate->save();
            }else{
                WaybillCalculate::create([
                    'waybill_id'=>$id,
                    'total_expense'=>$total_expense,
                    'total_receivable'=>$total_receivable,
                    'gross_margin'=>$total_receivable-$total_expense,
                    'gross_profit_rate'=>(($total_receivable-$total_expense)/$total_receivable),
                ]);
            };
            $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
            return redirect('waybill')->with('successTip','运单“'.$waybill->waybill_number.'”调度成功');
        }
    }

    public function waybillUpdate(Request $request, $id){
        if(!Gate::allows('运单管理-编辑')){ return redirect(url('/'));  }
        $this->validatorWaybill($request)->validate();
        $data=$request->input();
        $waybill=Waybill::find($id);
        $waybill->fill($data);
        if ($waybill->save()){
            $this->log(__METHOD__,__FUNCTION__,json_encode($waybill),Auth::user()['id']);
            return redirect('waybill')->with('successTip','运单“'.$waybill->waybill_number.'”修改成功');
        }
    }

    public function waybillAudit(Request $request){
        if(!Gate::allows('运单管理-运单审核')){ return redirect(url('/'));  }
        $id=$request->input('id');
        $waybill=Waybill::find($id);
        $isAudit=AuditLog::whereRaw('waybill_id = ? and audit_stage = ?',[$id,"运单阶段"])->first();
        if (empty($isAudit)){
            $auditLog=new AuditLog([
                'waybill_id'=>$id,
                'audit_stage'=>'运单阶段',
                'user_id'=>Auth::id(),
            ]);
            $auditLog->save();
            $auditLog['user']=Auth::user();
            $waybill->state='已审核';
            $result=$waybill->save();
            $this->log(__METHOD__,__FUNCTION__,json_encode($waybill),Auth::user()['id']);
            return ['success'=>$result,'state'=>$waybill->state,'auditLog'=>$auditLog];
        }
            return ['exception'=>'请勿重复审核！'];
    }

    public function waybillEdit($id){
        if(!Gate::allows('运单管理-编辑')){ return redirect(url('/'));  }
        $waybill=Waybill::find($id);
        $owners=Owner::get();
        return view('waybill.waybillEdit',['waybill'=>$waybill,'owners'=>$owners]);
    }
    public function waybillRetreatAudit(Request $request){
        if(!Gate::allows('运单管理-调度')){ return redirect(url('/'));  }
        $id=$request->input('id');
        $waybill=Waybill::find($id);
        AuditLog::whereRaw('waybill_id = ? and audit_stage = ?',[$id,"运单阶段"])->delete();
        $waybill->state='待重审';
        $result=$waybill->save();
        $this->log(__METHOD__,__FUNCTION__,json_encode($waybill),Auth::user()['id']);
        return ['success'=>$result,'state'=>$waybill->state];
    }
    public function waybillEndAudit(Request $request){
        if(!Gate::allows('运单管理-调度审核')){ return redirect(url('/'));  }
        $id=$request->input('id');
        $waybill=Waybill::find($id);
        $isAudit=AuditLog::whereRaw('waybill_id = ? and audit_stage = ?',[$id,"调度阶段"])->first();
        if (empty($isAudit)){
            $auditLog=new AuditLog([
                'waybill_id'=>$id,
                'audit_stage'=>'调度阶段',
                'user_id'=>Auth::id(),
            ]);
            $auditLog->save();
            $auditLog['user']=Auth::user();
            $waybillCalculate=WaybillCalculate::where('waybill_id','=',$id)->first();
            $waybillCalculate->load(["waybill"]);
            $waybillCalculate->waybill->load(["owner","carrier","origination_city","destination_city","warehouse_weight_unit","carrier_weight_unit","carType","auditLogs"]);
            $waybillCalculate->waybill->auditLogs->load(["user"]);
            $waybillCalculateJson=json_encode($waybillCalculate,JSON_UNESCAPED_UNICODE);
            WaybillFinancialSnapshot::create([
                'waybill_id'=>$id,
                'json_content'=>$waybillCalculateJson,
            ]);
            $waybill->state='完结';
            $result=$waybill->save();
            $this->log(__METHOD__,__FUNCTION__,$waybillCalculateJson,Auth::user()['id']);
            return ['success'=>$result,'state'=>$waybill->state,'auditLog'=>$auditLog];
        }
        return ['exception'=>'请勿重复审核！'];
    }

    public function waybillExport($id){
        $id = explode( ',',$id);
        $row=[[
            'type'=>'运单类型',
            'waybill_number'=>'运单号',
            'owner'=>'货主',
            'wms_bill_number'=>'WMS单号',
            'origination'=>'始发地',
            'destination'=>'目的地',
            'recipient'=>'收件人',
            'recipient_mobile'=>'收件人电话',
            'charge'=>'收费(元)',
            'ordering_remark'=>'下单备注',
            'carrier'=>'承运商',
            'carrier_bill'=>'承运商单号',
            'origination_city'=>'始发市',
            'destination_city'=>'目的市',
            'warehouse_weight'=>'仓库计重(抛)',
            'warehouse_weight_unit'=>'仓库计重单位	',
            'carrier_weight'=>'承运商计重(抛)',
            'carrier_weight_unit'=>'承运商计重单位',
            'carType'=>'车型',
            'fee'=>'运费(元)',
            'pick_up_fee'=>'提货费(元)',
            'other_fee'=>'其他费用(元)',
            'collect_fee'=>'到付金额(元)',
            'dispatch_remark'=>'调度备注',
            'waybillAuditor'=>'运单审核人',
            'dispatchAuditor'=>'调度审核人',
            'created_at'=>'创建时间'
        ]];
        $list=[];
        for ($i=0; $i<count($id);$i++){
            $waybill=Waybill::with(['owner', 'auditLogs' => function ($query) {
                return $query->with('user');
            }])->find($id[$i]);
            foreach ($waybill->auditLogs as $auditLog){
                if ($auditLog->audit_stage=="运单阶段"){
                    $waybillAuditor=$auditLog->user->name;
                }else{
                    $waybillAuditor='';
                }
                if ($auditLog->audit_stage=="调度阶段"){
                    $dispatchAuditor=$auditLog->user->name;
                }else{
                    $dispatchAuditor='';
                }
            };
            $w=[
                'type'=>isset($waybill->type)?$waybill->type:'',
                'waybill_number'=>isset($waybill->waybill_number)?$waybill->waybill_number:'',
                'owner'=>isset($waybill->owner->name)?$waybill->owner->name:'',
                'wms_bill_number'=>isset($waybill->wms_bill_number)?$waybill->wms_bill_number:'',
                'origination'=>isset($waybill->origination)?$waybill->origination:'',
                'destination'=>isset($waybill->destination)?$waybill->destination:'',
                'recipient'=>isset($waybill->recipient)?$waybill->recipient:'',
                'recipient_mobile'=>isset($waybill->recipient_mobile)?$waybill->recipient_mobile:'',
                'charge'=>isset($waybill->charge)?$waybill->charge:'',
                'ordering_remark'=>isset($waybill->ordering_remark)?$waybill->ordering_remark:'',
                'carrier'=>isset($waybill->carrier_name)?$waybill->carrier_name:'',
                'carrier_bill'=>isset($waybill->carrier_bill)?$waybill->carrier_bill:'',
                'origination_city'=>isset($waybill->origination_city_name)?$waybill->origination_city_name:'',
                'destination_city'=>isset($waybill->destination_city_name)?$waybill->destination_city_name:'',
                'warehouse_weight'=>isset($waybill->warehouse_weight)?$waybill->warehouse_weight:'',
                'warehouse_weight_unit'=>isset($waybill->warehouse_weight_unit_name)?$waybill->warehouse_weight_unit_name:'',
                'carrier_weight'=>isset($waybill->carrier_weight)?$waybill->carrier_weight:'',
                'carrier_weight_unit'=>isset($waybill->carrier_weight_unit_name)?$waybill->carrier_weight_unit_name:'',
                'carType'=>isset($waybill->carType->name)?$waybill->carType->name.($waybill->carType->length.'米'):'',
                'fee'=>isset($waybill->fee)?$waybill->fee:'',
                'pick_up_fee'=>isset($waybill->pick_up_fee)?$waybill->pick_up_fee:'',
                'other_fee'=>isset($waybill->other_fee)?$waybill->other_fee:'',
                'collect_fee'=>isset($waybill->collect_fee)?$waybill->collect_fee:'',
                'dispatch_remark'=>isset($waybill->dispatch_remark)?$waybill->dispatch_remark:'',
                'waybillAuditor'=>isset($waybillAuditor)?$waybillAuditor:'',
                'dispatchAuditor'=>isset($dispatchAuditor)?$dispatchAuditor:'',
                'created_at'=>isset($waybill->created_at)?$waybill->created_at:''
            ];
            $list[$i]=$w;
        }
        $this->log(__METHOD__,__FUNCTION__,json_encode($waybill),Auth::user()['id']);
        return Excel::download(new WaybillExport($row,$list), date('Y:m:d ') . '运单列表.xls');
    }

    protected function validatorWaybill(Request $request){
        $validator=Validator::make($request->input(),[
            'wms_bill_number'=>'nullable|alpha_num|max:50',
            'origination'=>'required|max:255',
            'destination'=>'required|max:255',
            'recipient'=>'required|max:50',
            'recipient_mobile'=>'required|digits:11|integer',
            'charge'=>'required|min:0|numeric',
        ],[
            'required'=>':attribute 为必填项',
            'alpha_num'=>':attribute 应为字母或数字',
            'max'=>':attribute 字符过多',
            'digits'=>':attribute 应为11位',
            'integer'=>':attribute 应为整数',
            'min'=>':attribute 不得为负',
            'numeric'=>':attribute 应为数字',
        ],[
            'wms_bill_number'=>'WMS单号',
            'origination'=>'始发地',
            'destination'=>'目的地',
            'recipient'=>'收件人',
            'recipient_mobile'=>'收件人电话',
            'charge'=>'收费',
        ]);
        return $validator;
    }
    protected function validatorWaybillDispatch(Request $request){
        if ($request->input('type')=='直发'){
            $validator=Validator::make($request->input(),[
                'carrier_bill'=>'required|alpha_num|max:50',
                'fee'=>'required|min:0|numeric',
                'other_fee'=>'nullable|min:0|numeric',
                'collect_fee'=>'nullable|min:0|numeric',
            ],[
                'required'=>':attribute 为必填项',
                'alpha_num'=>':attribute 应为字母或数字',
                'max'=>':attribute 字符过多',
                'min'=>':attribute 不得为负',
                'numeric'=>':attribute 应为数字',
            ],[
                'carrier_bill'=>'承运商单号',
                'fee'=>'运费',
                'other_fee'=>'其他费用',
                'collect_fee'=>'到付金额',
            ]);
            return $validator;
        }else if ($request->input('type')=='专线'){
            $validator=Validator::make($request->input(),[
                'carrier_bill'=>'required|alpha_num|max:50',
                'warehouse_weight'=>'required|min:0|numeric',
                'carrier_weight'=>'required|min:0|numeric',
                'pick_up_fee'=>'required|min:0|numeric',
                'other_fee'=>'nullable|min:0|numeric',
            ],[
                'required'=>':attribute 为必填项',
                'alpha_num'=>':attribute 应为字母或数字',
                'max'=>':attribute 字符过多',
                'min'=>':attribute 不得为负',
                'numeric'=>':attribute 应为数字',
            ],[
                'carrier_bill'=>'承运商单号',
                'warehouse_weight'=>'仓库计重(抛)',
                'carrier_weight'=>'承运商计重(抛)',
                'pick_up_fee'=>'提货费',
                'other_fee'=>'其他费用',
            ]);
            return $validator;
        }else{
            return false;
        }
    }
}