<?php

use Illuminate\Database\Seeder;
use App\KommaApp\Pages\Models\Page;
use App\KommaApp\Languages\Models\Language;

class SimpleSiteSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {

        $routes = DB::table('routes');

        $root = new Page(['active' => '0', 'site_id' => 1]);
        $root->makeRoot();
        $root->save();

        $home = new Page(['active' => '1', 'code_name' => 'home', 'site_id' => 1]);
        $home->makeLastChildOf($root);
        $home->save();
        $home->languages()->attach( Language::whereName('Dutch')->first(),['name'=>'Home', 'description' => '[]','slug'=>'home' ,'meta_title'=>'Komma Title','meta_description'=>'Komma description', 'page_id' => '2'] );
        $routes->insert(['route' => 'pages/2', 'alias' => '/', 'routeable_id' => '1', 'routeable_type' => 'App\KommaApp\Pages\Models\PageTranslation', 'site_id' => 1, 'language_id' => 104]);

        $posts = new Page(['active' => '1', 'code_name' => 'posts', 'site_id' => 1]);
        $posts->makeLastChildOf($root);
        $posts->save();
        $posts->languages()->attach( Language::whereName('Dutch')->first(),['name'=>'Nieuws', 'description' => '[]','slug'=>'posts','meta_title'=>'Nieuws | Site','meta_description'=>'Nieuws | Site', 'page_id' => '3'] );
        $routes->insert(['route' => 'posts', 'alias' => 'nieuws', 'routeable_id' => '2', 'routeable_type' => 'App\KommaApp\Pages\Models\PageTranslation', 'site_id' => 1, 'language_id' => 104]);

        $sitemap = new Page(['active' => '1', 'code_name' => 'sitemap', 'site_id' => 1]);
        $sitemap->makeLastChildOf($root);
        $sitemap->save();
        $sitemap->languages()->attach( Language::whereName('Dutch')->first(),['name'=>'Sitemap', 'description' => '[]','slug'=>'sitemap','meta_title'=>'Sitemap','meta_description'=>'Sitemap', 'page_id' => '4'] );
        $routes->insert(['route' => 'pages/4', 'alias' => 'sitemap', 'routeable_id' => '3', 'routeable_type' => 'App\KommaApp\Pages\Models\PageTranslation', 'site_id' => 1, 'language_id' => 104]);




    }
}