/**
* 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();
}
