/** * 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]); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('tags')->truncate(); factory(App\Tag::class, 10)->create(); $posts = Post::all(); foreach ($posts as $post) { $tags = Tag::orderByRaw('RAND()')->take(rand(1, 5))->get(['id']); $post->tags()->sync($tags); } }
/** * Run the database seeds. * * @return void */ public function run() { foreach (['designer', 'place', 'story'] as $type) { for ($id = 1; $id <= 100; $id++) { $tag_ids = Tag::orderByRaw('RAND()')->take(rand(3, 6))->get()->pluck('id'); foreach ($tag_ids as $tag_id) { DB::table('taggable')->insert(['tag_id' => $tag_id, 'taggable_type' => $type, 'taggable_id' => $id]); } } } }