baoshi-was/app/Services/WeighExceptedService.php

<?php 

namespace App\Services; 

use App\Package;
use App\Services\common\QueryService;

Class WeighExceptedService
{
    private function conditionQuery(array $params){
        $query = Package::query()->orderBy('packages.id','DESC')->selectRaw("packages.* ");
        $columnQueryRules=[
            'id' => ['multi' => ','],
        ];
        return app(QueryService::class)->query($params,$query,$columnQueryRules,"waybills");
    }

    public function getCreateExceptionSql(array $params){
        return $this->conditionQuery($params)->where('packages.status',"上传异常")->orWhere('packages.status',"测量异常")
            ->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();
    }

    public function getIssuedExceptionSql(array $params){
        return $this->conditionQuery($params)->where('packages.status',"下发异常")->orWhere('packages.status',"记录异常")
            ->orWhere('packages.status',"已上传异常")
            ->LeftJoin('logistics','packages.logistic_id','logistics.id')
                ->selectRaw('logistics.name logistic_name')
            ->sql();
    }
}