<?php

use Illuminate\Database\Seeder;
use App\Area;
use App\Shop;

class UpdateAreaShop extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $areas = Area::where('name', 'like', '%神奈川%')->orderBy('id')->get();
        $rootId = null;
        $areaDelete = [];

        foreach ($areas as $key => $area) {
            if ($key == 0 && $rootId == null) {
                $rootId = $area->id;
                print "Root Id is: " . $rootId . "\r\n";
                continue;
            }

            Shop::where('area_id', $area->id)->update(['area_id' => $rootId]);
            $areaDelete[] = $area->id;
            print "Updated area id: " . $area->id . "\r\n";
        }

        if (count($areaDelete) > 0) Area::whereIn('id', $areaDelete)->delete();
    }
}