Route::get('project', function () { $projects = Project::whereHas('status', function ($q) { $q->where('key', '=', 'published'); })->get(); return $projects; }); Route::get('project/{id}', function ($id) { $project = Project::with(['photos', 'youtubes', 'users'])->find($id); return $project; }); Route::get('/researcher/dropdown/{keyword?}', "Backends\\UserController@apiGetResearcherForDropdown"); Route::get("/province", function () { return \App\Models\Thailand\Province::all(); }); Route::get("/province/{provinceId}/amphur", function ($provinceId) { return \App\Models\Thailand\Amphur::where("PROVINCE_ID", "=", $provinceId)->get(); }); Route::get("/province/{provinceId}/amphur/{amphurId}/district", function ($provinceId, $amphurId) { return \App\Models\Thailand\District::where("PROVINCE_ID", "=", $provinceId)->where("AMPHUR_ID", "=", "{$amphurId}")->get(); }); }); Route::group(['middleware' => ['web']], function () { Route::get('/', "FrontendController@index"); 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);
<div class="menu"> <?php $faculties = \App\Models\Faculty::all(); ?> @foreach($faculties as $faculty) <a class="link item" href="/project?faculty_id={{$faculty->id}}">{{$faculty->name_th}}</a> @endforeach </div> </div> <div class="ui simple dropdown item"> พื้นที่เป้าหมาย <i class="dropdown icon"></i> <div class="menu"> <?php $amphurs = \App\Models\Thailand\Amphur::where("province_id", "=", "44")->get(); ?> @foreach($amphurs as $amphur) <a class="link item" href="/amphur/{{$amphur->AMPHUR_ID}}/{{$amphur->AMPHUR_NAME}}">{{$amphur->AMPHUR_NAME}}</a> @endforeach </div> </div> <div class="ui simple dropdown item"> ปีที่ดำเนินโครงการ <i class="dropdown icon"></i> <div class="menu"> <?php $years = \App\Models\Year::orderBy('year', 'desc')->get(); ?> @foreach($years as $year) <a class="link item" href="/project?year={{$year->year}}">{{$year->year}}</a>