/**
* 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]);
}
}
}
}
