<?php

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

class ImportTellerSEO extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $tellerList = Fortuneteller::all();
        foreach ($tellerList as $item) {
            $tellerUri = '/fortune-teller/detail/' . $item->number;
            $metaSeo = Seo::where('uri', $tellerUri)->where('post_id', $item->id)->first();
            $seoData = [
                'uri'           => $tellerUri,
                'title'         => ($item->desc_1_title != null && $item->desc_1_title != "") ? $item->desc_1_title : $item->name,
                'keywords'      => $item->desc_1_short,
                'description'   => $item->desc_1_full,
                'type'          => 'teller',
                'post_id'       => $item->id,
                'updated_at'    => date('Y-m-d H:s:i'),
            ];
            if ($item->avatar != "") {
                $seoData['image'] = "uploads/image/fortune/thumb_460x360/" . $item->avatar;
            }
            if (isset($metaSeo)) {
                $metaSeo->update($seoData);
            } else {
                $seoData['created_at'] = date('Y-m-d H:s:i');
                Seo::create($seoData);
            }
            print "Imported SEO meta: " . $item->desc_1_title . "\r\n";
        }
    }
}