/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id = NULL) { $currUser = Auth::user(); $oCategories = Category::all(); $oCity = Cities::all(); $oVacancy = null; if ($id > 0) { $oVacancy = Vacancy::find($id); } foreach ($oCategories as $item) { $aCategories[$item->id] = $item->name; } if (Auth::user()->is_admin == 0) { $aCompanies = Companies::where('user_id', '=', $currUser->id)->get(); } else { $aCompanies = Companies::all(); } foreach ($aCompanies as $item) { $aCompany[$item->id] = $item->name; } $oQuery = Regions::join('country', 'country.id', '=', 'country_id')->select('regions.id as id', 'regions.name', 'country.name as country_name', 'country.id as country_id'); if ($oRegions = $oQuery->get()) { } foreach ($oRegions as $item) { $aRegions[$item->country_name] = array(); $aCity = Cities::where('region_id', '=', $item->id)->get(); foreach ($aCity as $city) { $aRegions[$item->name][$city->id] = $city->name; } } if ($currUser->is_admin == 0 && (empty($oVacancy) === false && $oVacancy->user_id != $currUser->id)) { return Redirect::route('vacancy-list', array('user_id' => $currUser->id)); } return View::make('/vacancy/edit', array('currUser' => $currUser, 'aCategories' => $aCategories, 'aCompany' => $aCompany, 'aRegions' => $aRegions, 'oVacancy' => $oVacancy, 'id' => $id)); }
static function getCities($regionId, $countryId = "IN") { $cities = Cities::where('country', '=', $countryId)->where('region', '=', $regionId)->lists('name', 'ID'); $queries = DB::getQueryLog(); /* print_R($queries); dd($cities); */ return $cities; }
public function getIndex() { $key = Input::get('search'); if (isset($key)) { $data = Cities::where('name', 'like', '%' . $key . '%')->orderBy('id', 'desc')->paginate(10); } else { $data = Cities::orderBy('id', 'desc')->paginate(10); } return View::make('home/dashboard', array())->nest('content', 'cities/index', array('data' => $data)); }
public function getIndex() { $hotel = Hotel::find(1); $regions = Regions::all(); $country = Countries::where('region_id', '=', $hotel->city->province->country->region->id)->get(); $province = Provinces::where('country_id', '=', $hotel->city->province->country->id)->get(); $city = Cities::where('province_id', '=', $hotel->city->province->id)->get(); $options = array('hotel' => $hotel, 'regions' => $regions, 'country' => $country, 'province' => $province, 'city' => $city); return View::make('home/dashboard', array())->nest('content', 'hotel/profile', $options); }
public function getCity($id) { $city = Cities::where('province_id', '=', $id)->get(); $html = '<option></option>'; foreach ($city as $c) { $html .= "<option value='" . $c->id . "'>" . $c->name . "</option>"; } echo $html; }
public function showProvince($id_city) { $province = Cities::where('id', $id_city)->select('province_id')->first(); $data = Provinces::find($province->province_id); return Response::json($data); }
/** * Search a city by name or postal code. * * @param $search * * @return \Illuminate\Support\Collection */ public function whereNameOrPostalCodeIs($search) { return $this->cities->where('ville_nom', 'LIKE', "{$search}%")->orWhere('ville_nom_simple', 'LIKE', "{$search}%")->orWhere('ville_nom_reel', 'LIKE', "{$search}%")->orWhere('ville_code_postal', 'LIKE', "{$search}%")->orderBy('ville_population_2012', 'DESC')->get(); }