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

<?php

namespace App\Http\Controllers;

use App\BillingModel;
use App\Events\WaybillPriceModelEvent;
use App\WaybillFinancialExcepted;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Event;
use Illuminate\Support\Facades\Gate;

class WaybillFinancialExceptedController extends Controller
{
    public function index(Request $request)
    {
        if(!Gate::allows('财务报表-查询')){ return redirect(url('/'));  }
        $waybillFinancialSnapshots=WaybillFinancialExcepted::orderBy('id', 'DESC');
        if ($request->input('type')=='直发'){
            $waybillFinancialSnapshots=$waybillFinancialSnapshots->where('json_content','like','%直发%');
        }
        if($request->input('type')=='专线'){
            $waybillFinancialSnapshots=$waybillFinancialSnapshots->where('json_content','like','%专线%');
        }
        if ($request->input('created_at_start')){
            $waybillFinancialSnapshots=$waybillFinancialSnapshots->where('created_at','>',$request->input('created_at_start'));
        }
        if ($request->input('created_at_end')){
            $waybillFinancialSnapshots=$waybillFinancialSnapshots->where('created_at','<',$request->input('created_at_end'));
        }
        $waybillFinancialSnapshots=$waybillFinancialSnapshots->paginate(50);
        return view('waybill.waybillFinancialSnapshot.index',['waybillFinancialSnapshots'=>$waybillFinancialSnapshots,'filterData'=>$request->input(),'type'=>$request->input('type'),'excepted'=>true]);
    }
}