public function index(Request $request) { $this->view->title = 'Job Lists'; $this->view->breadcrumbs = ['job-lists' => 'Job Lists']; $this->view->job_types = JobType::orderBy('name', 'ASC')->get(); $jobLists = JobList::query(); // Type. $this->view->selected_type = $request->input('type'); if ($this->view->selected_type !== null) { $jobLists->where('type_id', $this->view->selected_type); } // Identifier. $this->view->name = $request->input('name'); if ($this->view->name !== null) { $jobLists->where('name', 'LIKE', '%' . $this->view->name . '%'); $this->view->quick_s = $this->view->name; $this->view->quick_t = 'jl'; } $this->view->job_lists = $jobLists->paginate(50); return $this->view; }