/** * Show the home page. * * @return \Illuminate\Http\Response */ public function index() { $designers = Designer::orderBy('id', 'desc')->take(9)->get(); $places = Place::orderBy('id', 'desc')->take(9)->get(); $stories = Story::whereHas('translations', function ($sub_query) { $sub_query->whereIn('locale', ['en', App::getLocale()])->whereNotNull('title')->whereNotNull('content'); })->orderBy('id', 'desc')->take(9)->get(); $tags = Tag::orderByRaw('RAND()')->take(9)->get(); return view('pages.home', ['designers' => $designers, 'places' => $places, 'stories' => $stories, 'tags' => $tags]); }