Route::get('/post/{id}', "FrontendController@getPost"); }); Route::get('/amphur/{id}/{name}', function ($id, $name) { $amphur = \App\Models\Thailand\Amphur::find($id); $query = Project::query(); $query->where('amphur_id', '=', $id); $projects = $query->get(); return view('frontends.amphur')->with('projects', $projects)->with('amphur', $amphur); }); Route::group(['prefix' => 'project', 'middleware' => ['web']], function () { //project Route::get('/', function (\Symfony\Component\HttpFoundation\Request $request) { $faculty_id = $request->get('faculty_id'); $keyword = $request->get('keyword'); $year = $request->get('year'); $query = Project::query(); if ($faculty_id) { $query = $query->where('faculty_id', '=', $faculty_id); } if ($keyword) { $query = $query->where('name_th', 'LIKE', "%{$keyword}%"); $query = $query->orWhere('name_en', 'LIKE', "%{$keyword}%"); } if ($year) { $query = $query->where('year', '=', $year); } $query->whereHas('status', function ($q) { $q->where('key', '=', 'published'); }); $projects = $query->get(); return view('frontends.search')->with('projects', $projects);