baoshi-was/app/Services/PackageService.php

<?php

namespace App\Services;

use App\Package;
use App\Services\common\QueryService;
use Illuminate\Http\Request;


Class PackageService
{
    private function conditionQuery($params){
        $packages = Package::query()->orderBy('packages.id','DESC');
        $columnQueryRules=[
            'logistic_number' => ['like' => ''],
            'batch_number' => ['like' => ''],
            'created_at_start' => ['alias' => 'created_at','startDate' => " 00:00:00"],
            'created_at_end' => ['alias' => 'created_at','endDate' => " 23:59:59"],
            'id' => ['multi' => ','],
        ];
        $packages = app(QueryService::class)->query($params,$packages,$columnQueryRules,"packages");
        return $packages;
    }

    public function paginate(Request $request){
        $packages = $this->conditionQuery($request->input());
        return $packages->paginate($request->paginate ?? 50);
    }

    public function get(Request $request){
        $packages = $this->conditionQuery($request->input());
        return $packages->get();
    }

    public function getSql($params){
        return $this->conditionQuery($params)->selectRaw('packages.*')
        ->LeftJoin('owners','packages.owner_id','owners.id')
            ->selectRaw('owners.name owner_name')
        ->LeftJoin('logistics','packages.logistic_id','logistics.id')
            ->selectRaw('logistics.name logistic_name')
        ->LeftJoin('paper_boxes','packages.paper_box_id','paper_boxes.id')
            ->selectRaw('paper_boxes.model paper_box_name')
        ->LeftJoin('measuring_machines','packages.measuring_machine_id','measuring_machines.id')
            ->selectRaw('measuring_machines.name measuring_machine_name')
        ->sql();
    }

}