baoshi-was/app/Filters/OrderPackageFilters.php

<?php


namespace App\Filters;

use App\Order;
use App\OrderIssue;
use App\Services\UserService;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use Illuminate\Support\Carbon;
use Illuminate\Support\Str;
use phpDocumentor\Reflection\Types\Boolean;

class OrderPackageFilters
{
    protected $request;
    protected $queryBuilder;
    protected $filters = ['logistic_number', 'status', 'received_at_start',
        'default_logistics',
        'is_issue',
        'sync_routes_flag',
        'remark',
        'received_at_end', 'is_weighed', 'logistic', 'owner', 'sent_at_start', 'sent_at_end', 'is_exception', 'exception_type', 'default_date', 'has_transfer_status'];

    protected $orderIssueQuery;

    public function __construct(Request $request)
    {
        $this->request = $request;
    }

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

    public function getOrderIssueQuery(): Builder
    {
        if (!$this->orderIssueQuery) {
            $this->orderIssueQuery = OrderIssue::query()->select('order_id');
        }
        return $this->orderIssueQuery;
    }


    private function logistic_number($logistic_number)
    {
        if (strpos($logistic_number, ',') || strpos($logistic_number, '，') || strpos($logistic_number, ' ')) {
            $arr = array_filter(preg_split('/[,， ]+/is', $logistic_number));
            $this->queryBuilder->whereIn('logistic_number', $arr);
        } else {
            $this->queryBuilder->where('logistic_number', 'like', $logistic_number . "%");
        }
    }

    private function exception_type($exception_type)
    {
        $exception_types = array_filter(preg_split('/[,]+/is', $exception_type));
        $this->queryBuilder->whereIn('exception_type', $exception_types);
    }

    private function has_transfer_status($has_transfer_status)
    {
        if ($has_transfer_status == '是') {
            $this->queryBuilder->whereNotNull('transfer_status');
        } elseif ($has_transfer_status == '否') {
            $this->queryBuilder->whereNull('transfer_status');
        }
    }

    private function status($status)
    {
        $this->queryBuilder->where('status', $status);
    }

    private function received_at_start($received_at_start)
    {
        $this->queryBuilder->where('received_at', '>=', $received_at_start);
    }

    private function received_at_end($received_at_end)
    {
        $this->queryBuilder->where('received_at', '<=', $received_at_end);
    }

    private function is_weighed($is_weighed)
    {
        if ($is_weighed == 'true') {
            $this->queryBuilder->whereNotNull('weighed_at');
        } else {
            $this->queryBuilder->whereNull('weighed_at');
        }
    }

    private function logistic($logistic_id)
    {
        $logistic_ids = array_filter(preg_split('/[,， ]+/is', $logistic_id));
        $this->queryBuilder->whereIn('order_id', function ($query) use ($logistic_ids) {
            $query->from('orders')->select('id')->whereIn('logistic_id', $logistic_ids);
        });
    }

    private function owner($owner_id)
    {
        $owner_ids = array_filter(preg_split('/[,， ]+/is', $owner_id));
        $this->queryBuilder->whereIn('owner_id', $owner_ids);
    }

    private function sent_at_start($sent_at_start)
    {
        $this->queryBuilder->where('sent_at', '>=', Carbon::parse($sent_at_start)->startOfDay());
    }

    private function sent_at_end($sent_at_end)
    {
        $this->queryBuilder->where('sent_at', '<=', Carbon::parse($sent_at_end)->endOfDay());
    }

    private function is_exception($is_exception)
    {
        $this->queryBuilder->where('exception', $is_exception);
    }

    public function default_date()
    {
        $this->queryBuilder->where('sent_at', '>=', now()->startOfDay()->subDays(15))->where('sent_at', '<', now()->startOfDay()->addDay());
    }

    public function default_logistics()
    {
        $this->queryBuilder->whereIn('order_id', function ($query) {
            $query->from('orders')
                ->select('id')
                ->whereNotIn('logistic_id', [13, 24, 25, 26, 27, 30, 31, 32, 33, 34, 60, 63, 65, 66, 68, 70, 102, 105, 107, 116, 10, 87]);
        });
    }

    public function is_issue($is_issue)
    {
        if ($is_issue === '是') {
            $this->queryBuilder->whereIn('order_id', function ($query) {
                $query->from('orders')->select('id')->whereIn('id', function ($query) {
                    $query->from('order_issues')->select('order_id')->whereNotNull('order_id');
                });
            });
        } else {
            $this->queryBuilder->whereIn('order_id', function ($query) {
                $query->from('orders')->select('id')->whereNotIn('id', function ($query) {
                    $query->from('order_issues')->select('order_id')->whereNotNull('order_id');
                });
            });
        }
    }

    public function sync_routes_flag($sync_routes_flag)
    {
        $this->queryBuilder->where('sync_routes_flag', $sync_routes_flag === 'true');
    }

    public function remark($remark)
    {
        $this->queryBuilder->whereIn('id', function ($query) use ($remark) {
            $query->from('order_package_remarks')->select('order_package_id')->where('content', 'like', $remark);
        });
    }
}