/** * PROJECT_TYPE vs PROVINCE vs DISTRICT */ public function project_type_province_district($project_type_key, $province_key, $district_key, Request $request) { $district = District::findByKey($district_key)->first(); if (is_null($district)) { $district = District::where('is_publish', 1)->orderBy('priority')->orderBy('created_at', 'desc')->first(); } $province = $district->province; $wards = $district->wards()->where('is_publish', 1)->orderBy('priority')->orderBy('created_at', 'desc')->get(); $limit = Config::findByKey('rows_per_page_project')->first()->value; $project_type = Project_type::findByKey($project_type_key)->first(); if (is_null($project_type)) { $project_type = Project_type::where('active', 1)->orderBy('priority')->orderBy('created_at', 'desc')->first(); } $projects = Project::where('project_type_id', $project_type->id)->where('district_id', $district->id)->where('active', 1); $projects = $projects->orderBy('priority')->orderBy('created_at', 'desc')->paginate($limit); $searchDescription = $project_type->name . ' ' . $province->name . ' ' . $district->name; $link = route('project_type_province_district', ['project_type_key' => $project_type->key, 'province_key' => $province->key, 'district_key' => $district->key]); $breadcrumb = '<ul class="breadcrumb"> <li class="active"><a href="' . route('homepage') . '">Trang chủ</a></li> <li class="active"><a href="' . route('projects') . '">Dự án</a></li> <li class="active"><a href="' . route('project_type', ['project_type_key' => $project_type->key]) . '">' . $project_type->name . '</a></li> <li class="active"><a href="' . route('project_type_province', ['project_type_key' => $project_type->key, 'province_key' => $province->key]) . '">' . $province->name . '</a></li> <li class=""><a href="' . $link . '">' . $district->name . '</a></li> </ul>'; $heading = $project_type->name . ' ' . $province->name . ' ' . $district->name; $this->setMetadata($searchDescription); return view('frontend.sites1.project_search', ['projects' => $projects, 'project_type' => $project_type, 'province' => $province, 'district' => $district, 'wards' => $wards, 'search_type' => 'project_type_province_district', 'link' => $link, 'searchDescription' => $searchDescription, 'breadcrumb' => $breadcrumb, 'heading' => $heading]); }