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>
