<?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\WaybillFinancialExcepted;
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');
            }])->orderBy('id','DESC');
            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'],
            'collect_fee'=>$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);
        $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=="专线"){
                $billingModel_id=$request->input('billingModel');
                if ($billingModel_id){
                    $carrier_weight=$request->input('carrier_weight');
                    $billingModel=BillingModel::find($billingModel_id);
                    if ($carrier_weight<$billingModel->initial_weight){
                        $fee=($billingModel->unit_price)*($billingModel->initial_weight);
                    }else{
                        $fee=($billingModel->unit_price)*$carrier_weight;
                    }
                    $waybill->fee=$fee;
                    $waybill->waybill_price_model_id=$billingModel_id;
                }
                $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 isBillingModel(Request $request){
        $carrier_id=$request->input('carrier_id');
        $destination_city_id=$request->input('destination_city_id');
        $carrier_weight=$request->input('carrier_weight');
        $carrier_weight_unit_id=$request->input('carrier_weight_unit_id');
        if(!$carrier_id)return['success'=>false];
        if(!$destination_city_id)return['success'=>false];
        if(!$carrier_weight)return['success'=>false];
        if(!$carrier_weight_unit_id)return['success'=>false];
        $billingModel=BillingModel::where('carrier_id',$carrier_id)->where('city_id',$destination_city_id)
            ->where('range_min','<',$carrier_weight)->where('range_max','>=',$carrier_weight)
            ->where('unit_id',$carrier_weight_unit_id)->first();
        if($billingModel)return['success'=>$billingModel->id];
        $billingModelRange=BillingModel::whereRaw('carrier_id = ? and city_id = ? and unit_id = ? and range_max is null',[$carrier_id,$destination_city_id,$carrier_weight_unit_id])->first();
        if ($billingModelRange){ return ['success'=>$billingModelRange->id];}
        $city=City::where('id',$destination_city_id)->select('province_id')->first();
        $billingModelProvince=BillingModel::whereRaw('carrier_id = ? and province_id = ? and unit_id = ? and range_max >= ? and range_min < ? and city_id is null',
            [$carrier_id,$city->province_id,$carrier_weight_unit_id,$carrier_weight,$carrier_weight])->first();
        if ($billingModelProvince){return ['success'=>$billingModelProvince->id];}
        $billingModelProvinceRange=BillingModel::whereRaw('carrier_id = ? and province_id = ? and unit_id = ? and range_max is null and city_id is null',
            [$carrier_id,$city->province_id,$carrier_weight_unit_id])->first();
        if ($billingModelProvinceRange){return ['success'=>$billingModelProvinceRange->id];}else{
            return ['success'=>false];
        }
    }

    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);
            if ($waybill->waybill_price_model_id){
                WaybillFinancialSnapshot::create([
                    'waybill_id'=>$id,
                    'json_content'=>$waybillCalculateJson,
                ]);
                $waybill->state='完结';
            }else{
                WaybillFinancialExcepted::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','integer','regex:/^(0\d{6,10})|(1[3|4|5|7|8][0-9]\d{4,8})$/'],
            'charge'=>'required|min:0|numeric',
            'collect_fee'=>'nullable|min:0|numeric',
        ],[
            'required'=>':attribute 为必填项',
            'alpha_num'=>':attribute 应为字母或数字',
            'max'=>':attribute 字符过多',
            'regex'=>':attribute 输入有误',
            'integer'=>':attribute 应为整数',
            'min'=>':attribute 不得为负',
            'numeric'=>':attribute 应为数字',
        ],[
            'wms_bill_number'=>'WMS单号',
            'origination'=>'始发地',
            'destination'=>'目的地',
            'recipient'=>'收件人',
            'recipient_mobile'=>'收件人电话',
            'charge'=>'收费',
            'collect_fee'=>'到付金额',
        ]);
        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',
            ],[
                'required'=>':attribute 为必填项',
                'alpha_num'=>':attribute 应为字母或数字',
                'max'=>':attribute 字符过多',
                'min'=>':attribute 不得为负',
                'numeric'=>':attribute 应为数字',
            ],[
                'carrier_bill'=>'承运商单号',
                'fee'=>'运费',
                'other_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',
                'carrier_id'=>'required|integer',
                'destination_city_id'=>'required|integer',
                'carrier_weight_unit_id'=>'required|integer',
            ],[
                'required'=>':attribute 为必填项',
                'alpha_num'=>':attribute 应为字母或数字',
                'max'=>':attribute 字符过多',
                'min'=>':attribute 不得为负',
                'numeric'=>':attribute 应为数字',
            ],[
                'carrier_bill'=>'承运商单号',
                'warehouse_weight'=>'仓库计重(抛)',
                'carrier_weight'=>'承运商计重(抛)',
                'pick_up_fee'=>'提货费',
                'other_fee'=>'其他费用',
                'carrier_id'=>'承运商',
                'destination_city_id'=>'目的市',
                'carrier_weight_unit_id'=>'承运商计重单位',
            ]);
            return $validator;
        }else{
            return false;
        }
    }
}