<?php

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

class ImportRefName extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $list = ['ア', 'イ', 'ウ', 'エ', 'オ', 'カ', 'キ', 'ク', 'ケ', 'コ', 'サ', 'シ', 'ス', 'セ', 'ソ', 'タ', 'チ', 'テ', 'ト', 'ナ', 'ニ', 'ネ', 'ノ', 'ハ', 'ヒ', 'フ', 'ホ', 'マ', 'ミ', 'ム', 'メ', 'モ', 'ユ', 'リ', 'レ', 'ロ'];
        foreach ($list as $item) {
            $check = RefName::where('name', $item)->count();
            if ($check > 0) continue;
            RefName::create([
                'name'       => $item,
                'created_at' => date('Y-m-d H:i:s'),
                'updated_at' => date('Y-m-d H:i:s')
            ]);
        }

        $rs = Fortuneteller::all();
        foreach ($rs as $key => $item) {
            $name = 'アイネ';
            $firstChar = mb_substr($name, 0, 1, "UTF-8");
            $refName = RefName::where('name', $firstChar)->first();
            $updateData = [
                'name'         => $name,
                'display_name' => '愛音',
                'number'       => $key + 1,
                'ref_name_id'  => $refName->id,
            ];
            Fortuneteller::where('id', $item->id)->update($updateData);
        }
    }
}