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