/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id, Requests\CityRequest $request)
{
$cities = Cities::findOrFail($id);
$cities->city_name = \Input::get('city_name');
$cities->save();
\Session::flash('message', 'Город обновлён');
return redirect()->route('admin.city.index');
}
/**
* @param Advertisement $advertisement
* @param Request $request
* @return mixed
*/
public function index(Advertisement $advertisement, Request $request)
{
$ads = $advertisement::orderBy('top', 'desc')->orderBy('id', 'desc');
$input = \Input::all();
if ($request->input('search')) {
$ads = $advertisement->where('text', 'LIKE', '%' . $request->input('search') . '%')->orderBy('top', 'desc')->orderBy('id', 'desc');
}
if ($request->input('category_id')) {
if ($input['category_id'] != 'null') {
$category = Category::findOrFail(\Input::get('category_id'));
$ads = Advertisement::with('category')->where('category_id', '=', $category->id)->orderBy('top', 'desc')->orderBy('id', 'desc');
}
}
if ($request->input('city_id')) {
if ($input['city_id'] != 'null') {
$city = Cities::findOrFail(\Input::get('city_id'));
$ads = Advertisement::with('city')->where('city_id', '=', $city->id)->orderBy('top', 'desc')->orderBy('id', 'desc');
}
}
if ($request->input('type_id')) {
if ($input['type_id'] != 'null') {
$type = AdType::findOrFail(\Input::get('type_id'));
$ads = Advertisement::with('type')->where('type_id', '=', $type->id)->orderBy('top', 'desc')->orderBy('id', 'desc');
}
}
if ($request->input('category_id') && $request->input('type_id')) {
if ($input['category_id'] != 'null' && $input['type_id'] != 'null') {
$category = Category::findOrFail(\Input::get('category_id'));
$type = AdType::findOrFail(\Input::get('type_id'));
$ads = Advertisement::with('category')->with('type')->where('category_id', '=', $category->id)->where('type_id', '=', $type->id)->orderBy('top', 'desc')->orderBy('id', 'desc');
}
}
if ($request->input('city_id') && $request->input('category_id')) {
if ($input['category_id'] != 'null' && $input['city_id'] != 'null') {
$category = Category::findOrFail(\Input::get('category_id'));
$city = Cities::findOrFail(\Input::get('city_id'));
$ads = Advertisement::with('city')->with('category')->where('city_id', '=', $city->id)->where('category_id', '=', $category->id)->orderBy('top', 'desc')->orderBy('id', 'desc');
}
}
if ($request->input('city_id') && $request->input('type_id')) {
if ($input['city_id'] != 'null' && $input['type_id'] != 'null') {
$city = Cities::findOrFail(\Input::get('city_id'));
$type = AdType::findOrFail(\Input::get('type_id'));
$ads = Advertisement::with('city')->with('type')->where('city_id', '=', $city->id)->where('type_id', '=', $type->id)->orderBy('top', 'desc')->orderBy('id', 'desc');
}
}
if ($request->input('city_id') && $request->input('category_id') && $request->input('type_id')) {
if ($input['category_id'] != 'null' && $input['city_id'] != 'null' && $input['type_id'] != 'null') {
$category = Category::findOrFail(\Input::get('category_id'));
$city = Cities::findOrFail(\Input::get('city_id'));
$type = AdType::findOrFail(\Input::get('type_id'));
$ads = Advertisement::with('city')->with('category')->with('type')->where('city_id', '=', $city->id)->where('category_id', '=', $category->id)->where('type_id', '=', $type->id)->orderBy('top', 'desc')->orderBy('id', 'desc');
}
}
if ($_SERVER['HTTP_HOST'] == env('HOST')) {
$ads = $ads->paginate(10);
} else {
$ads = $ads->paginate(20);
}
return View::make('welcome', compact('ads'))->with('input', \Input::all());
}
