<?php

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

class UpdateAreaSeoInfo extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $areas = Area::select('id', 'name', 'slug', 'parent_id')->with('parent')->where('parent_id', '!=', 0)->whereNotNull('parent_id')->get();
        foreach ($areas as $area) {
            if (isset($area->parent) && $area->parent != null) {
                $oldUri = "/area/" . $area->slug;
                $newUri = "/area/" .  $area->parent->slug . "/" . $area->slug;
                Seo::where('uri', $oldUri)->update(['uri' => $newUri]);
                print "Old: " . $oldUri . "\r\n";
                print "New: " . $newUri . "\r\n";
                print "------------------------\r\n";
            }
        }
    }
}