예제 #1
0
 /**
  * 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]);
 }