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);
