コード例 #1
0
ファイル: routes.php プロジェクト: pchaow/SuccessModel5
    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);
});
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);
        }
コード例 #2
0
ファイル: layout.blade.php プロジェクト: pchaow/SuccessModel5
            <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>