<?php

use Illuminate\Database\Seeder;
use App\Seo;

class ImportSEO extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
    	$listMetaInfo = [
    		[ 'uri' => '/', 						'title' => 'ホームページ', 	'keywords' => 'Home page', 		'description' => 'home page' ],
    		[ 'uri' => '/fortune-teller', 			'title' => 'Fortune', 		'keywords' => 'Fortune page', 	'description' => 'home page' ],
    		[ 'uri' => '/contact', 					'title' => 'Contact', 		'keywords' => 'Contact page', 	'description' => 'home page' ],
    		[ 'uri' => '/sitemap', 					'title' => 'Site Map', 		'keywords' => 'Site page', 		'description' => 'home page' ],
    		[ 'uri' => '/policy', 					'title' => 'Policy', 		'keywords' => 'Policy page', 	'description' => 'home page' ],
    		[ 'uri' => '/policy/privacy', 			'title' => 'Privacy', 		'keywords' => 'Privacy page', 	'description' => 'home page' ],
    		[ 'uri' => '/policy/communityguide', 	'title' => 'Guide', 		'keywords' => 'Guide page', 	'description' => 'home page' ],
    		[ 'uri' => '/support', 					'title' => 'Support', 		'keywords' => 'Support page', 	'description' => 'home page' ],
    		[ 'uri' => '/support/link', 			'title' => 'Link', 			'keywords' => 'Link page', 		'description' => 'home page' ],
    	];

    	foreach($listMetaInfo as $item) {
    		$check = Seo::where('type', 'system')->where('uri', $item['uri'])->count();
            $item['updated_at'] = date('Y-m-d H:i:s');
    		if ($check > 0) {
                Seo::where('uri', $item['uri'])->update($item);
            } else {
                $item['created_at'] = date('Y-m-d H:i:s');
                Seo::create($item);
            }
    		
    		print "Imported SEO meta: " . $item['title'] . "\r\n";
    	}
    }
}