request = $request; } public function apply($builder) { $this->queryBuilder = $builder; $filters = array_filter($this->request->only($this->filters), function ($item) { return $item !== null; }); foreach ($filters as $filter => $value) { if (method_exists($this, $filter)) { $this->$filter($value, $this->queryBuilder); } } return $this->queryBuilder; } public function dispatch_date_start($dispatch_date_start) { $this->queryBuilder->whereDate('dispatch_date', '>=', $dispatch_date_start); } public function dispatch_date_end($dispatch_date_end) { $this->queryBuilder->whereDate('dispatch_date', '<=', $dispatch_date_end); } public function warehouse($warehouse) { $warehouse = array_filter(preg_split('/[,, ]+/is', $warehouse), function ($item) { return $item !== null; }); $this->queryBuilder->whereIn('warehouse_id', $warehouse); } public function labor_company($labor_company) { $labor_company = array_filter(preg_split('/[,, ]+/is', $labor_company), function ($item) { return $item !== null; }); $this->queryBuilder->whereIn('labor_company_id', $labor_company); } public function status($status) { $status = array_filter(preg_split('/[,, ]+/is', $status), function ($item) { return $item !== null; }); $this->queryBuilder->whereIn('status', $status); } }