public static function getRandomAdvertByPlace($place) { $ads = Advert::where('place', '=', $place)->orderByRaw("RAND()")->first(); if (!$ads) { return null; } if (!$ads->active) { return null; } if ($ads->show_title) { $advert['title'] = $ads->title; } else { $advert['title'] = null; } if ($ads->show_img) { $advert['img'] = $ads->img; $advert['imglink'] = $ads->imglink; } else { $advert['img'] = null; } if ($ads->show_text) { $advert['text'] = $ads->text; } else { $advert['text'] = null; } return $advert; }
/** * Display a listing of the resource. * отобразить все ресурсы * @return \Illuminate\Http\Response */ public function index(Request $request) { $adverts = Advert::all(); $title = $request->input('title'); $genre = $request->input('genre'); if ($title) { return view('adverts.index', ['adverts' => Advert::where('title', '=', $title)->get()]); } else { return view('adverts.index', ['adverts' => $adverts]); } //return view('adverts.index', ['adverts' => $adverts]); }