baoshi-was/app/Filters/WorkOrderFilters.php

<?php


namespace App\Filters;

use App\Order;
use App\OrderIssue;
use App\OrderIssueType;
use App\OrderPackage;
use App\Services\OwnerService;
use App\Traits\ModelSearchWay;
use App\User;
use App\WorkOrder;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Gate;

class WorkOrderFilters
{
    use ModelSearchWay;

    protected $request;
    protected $queryBuilder;
    protected $filters = [
        'ids',
        'creator',
        'remake',
        'created_at_start','created_at_end',
        'review_at_start','review_at_end',
        'reviewer',
        'word_order_types',
        'word_order_child_types',
        'logistic',
        'is_review',
        'logistic_number',
        'is_issue_order',
        'order_issue_type',
        'grad',
        'owner',
        'client_code',
    ];
    protected $array_filter;
    protected $params = [];

    protected $workOrderTypeQuery;
    protected $orderQuery;
    protected $orderPackageQuery;
    protected $issueTypeQuery;

    public function __construct(Request $request)
    {
        $this->request = $request;
        $this->params = $request->all();
        $this->array_filter = array_filter($this->request->only($this->filters));
    }

    public function apply($builder)
    {
        $this->queryBuilder = $builder;
        $this->afterApply();
        foreach ($this->array_filter as $filter => $value) {
            if (method_exists($this, $filter)) {
                $this->$filter($value, $this->queryBuilder);
            }
        }
        $this->beforeApply();
        return $this->queryBuilder;
    }

    public function afterApply()
    {
        if(isset($this->params['data']))
            $this->id(explode(',',$this->params['data']));

        if (!isset($this->params['owner'])){
            if(Gate::allows('订单管理-工单处理-客服编辑') || Gate::allows('订单管理-工单处理-承运商编辑')){

            }else if(Gate::allows('订单管理-工单处理-货主编辑')){
                $this->queryBuilder->whereIn('owner_id', app('UserService')->getPermittingOwnerIds(Auth::user())??[]);
            }
        }

        $this->afterFilter();
    }

    private function afterFilter()
    {

        $user = Auth::user();

        $logistic_ids = App('UserService')->getPermittingLogisticIds($user);

        $owner_ids = app('UserService')->getPermittingOwnerIds($user);

        $this->afterFilterLogistic($owner_ids,$logistic_ids);

        $this->afterFilterOwner($owner_ids);

        $this->afterFileIssueType();
    }

    // 可见货主过滤
    private function afterFilterOwner($owner_ids)
    {
        if(Gate::allows('订单管理-工单处理-客服编辑') || Gate::allows('订单管理-工单处理-承运商编辑')){

        }else if(Gate::allows('订单管理-工单处理-货主编辑')){
            $this->queryBuilder->whereIn('owner_id',$owner_ids);
        }
    }

    // 可见承运商过滤
    private function afterFilterLogistic($owner_ids,$logistic_ids)
    {
        if(Gate::allows('订单管理-工单处理-客服编辑') || Gate::allows('订单管理-工单处理-货主编辑')){
            if (!isset($this->params['owner'])){
                $this->queryBuilder->whereIn('owner_id', $owner_ids);
            }
        } else if (Gate::allows('订单管理-工单处理-承运商编辑')){
            $this->queryBuilder->whereIn('logistic_id',array_values($logistic_ids));
        }
    }

    public function afterFileIssueType()
    {
        if(Gate::allows('订单管理-工单处理-客服编辑') || Gate::allows('订单管理-工单处理-货主编辑')){
            $this->getOrderIssueQuery()->whereIn('name',['拦截', '信息更改', '其他', '快递异常', '错漏发', '破损', '快递丢件']);
        } else if (Gate::allows('订单管理-工单处理-承运商编辑')){
            $this->getOrderIssueQuery()->whereIn('name',['拦截', '信息更改', '破损', '快递丢件','快递异常']);
        }
    }

    public function beforeApply()
    {
        if ($this->orderPackageQuery){
            $this->queryBuilder->whereIn('order_id',$this->orderPackageQuery);
        }

        if ($this->orderQuery) {
            $this->queryBuilder->whereIn('order_id',$this->orderQuery);
        }

        if ($this->issueTypeQuery){
            $this->queryBuilder->whereIn('order_issue_type_id',$this->issueTypeQuery);
        }
    }

    public function getOrderQuery(): Builder
    {
        if (!$this->orderQuery){
            $this->orderQuery = Order::query()->select('id');
        }
        return $this->orderQuery;
    }

    public function getOrderPackageQuery(): Builder
    {
        if (!$this->orderPackageQuery){
            $this->orderPackageQuery = OrderPackage::query()->select('order_id');
        }
        return $this->orderPackageQuery;
    }

    public function getOrderIssueQuery(): Builder
    {
        if (!$this->issueTypeQuery){
            $this->issueTypeQuery = OrderIssueType::query()->select('id');
        }
        return $this->issueTypeQuery;
    }

    public function id($id)
    {
        if(is_array($id))$this->queryBuilder->whereIn('work_orders.id',$id);
        else $this->queryBuilder->where('work_orders.id',$id);
    }

    // 创建开始时间
    public function created_at_start($create_at_start)
    {
        $this->queryBuilder->where('work_orders.created_at','>=',$create_at_start);
    }
    // 创建结束时间
    public function created_at_end($created_at_end)
    {
        $this->queryBuilder->where('work_orders.created_at','<=',$created_at_end);
    }
    // 审核开始时间
    public function review_at_start($review_at_start)
    {
        $this->queryBuilder->where('work_orders.review_at','>=',$review_at_start);
    }
    // 审核结束时间
    public function review_at_end($review_at_end)
    {
        $this->queryBuilder->where('work_orders.review_at','<=',$review_at_end);
    }
    // 创建人
    public function creator($creator)
    {
        $userQuery = User::query()->select('id')->where('name','like',"%{$creator}%");;
        $this->queryBuilder->whereIn('creator_id',$userQuery);
    }
    // 审核人
    public function reviewer($id)
    {
        if (is_array($id))
            $this->queryBuilder->whereIn('work_orders.reviewer_id',$id);
        else
            $this->queryBuilder->where('work_orders.reviewer_id',$id);
    }

    // 类型
    public function word_order_types($word_order_types)
    {
        if(!$this->workOrderTypeQuery)
            $this->workOrderTypeQuery = WorkOrder::query()->select('id');
        if (is_array($word_order_types))
            $this->workOrderTypeQuery->whereIn('id',$word_order_types);
        else $this->workOrderTypeQuery->where('id',$word_order_types);
    }

    public function order_issue_type($order_issue_type)
    {
        $this->queryBuilder->where('order_issue_type_id',$order_issue_type);
    }

    // 快递单号
    public function logistic_number($logistic_number)
    {
        $this->searchWay($this->getOrderPackageQuery(),$logistic_number,'order_packages.logistic_number');
    }

    // 对应问题件
    public function is_issue_order($is_issue_order)
    {
        $orderIssueQuery = OrderIssue::query()->select('order_id')->whereIn('order_id',WorkOrder::query()->select('order_id'));
        if($is_issue_order == 'true'){
            $this->queryBuilder->whereIn('order_id',$orderIssueQuery);
        } else {
            $this->queryBuilder->whereNotIn('order_id',$orderIssueQuery);
        }
    }

    // 承运商筛选
    public function logistic($logistic)
    {
        $this->searchWay($this->queryBuilder,$logistic,'logistic_id');
    }

    public function grad($grad)
    {
        $this->queryBuilder->where('grad',$grad);
    }

    // 货主
    public function owner($owner)
    {
        $this->searchWay($this->queryBuilder,$owner,'work_orders.owner_id');
    }

    public function client_code($client_code)
    {
        $this->searchWay($this->getOrderQuery(),$client_code,'orders.client_code');
    }

}