<?php

use Illuminate\Database\Seeder;
use App\City;
use App\Town;
use App\Street;

class CitiesTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $json = json_decode(File::get(__DIR__."/cities.json"));
        $addedCity = 1;
        $totalCity = count($json);
        foreach($json as $city => $towns) {
            $citym = new City;
            $citym->name = $city;

            $cityslug = str_slug($city);
            $slugcount = 2;
            while(City::where("slug", $cityslug)->count() > 0){
                $cityslug = str_slug($city)."-".$slugcount;
                $slugcount++;
            }

            $citym->slug = $cityslug;
            $citym->save();

            foreach($towns as $town => $streets) {
                $townm = new Town;
                $townm->city_id = $citym->id;
                $townm->name = $town;

                $townslug = str_slug($town);
                $slugcount = 2;
                while(Town::where("slug", $townslug)->count() > 0){
                    $townslug = str_slug($town)."-".$slugcount;
                    $slugcount++;
                }

                $townm->slug = $townslug;
                $townm->save();

                foreach($streets as $street) {
                    $streetm = new Street();
                    $streetm->town_id = $townm->id;
                    $streetm->name = $street;

                    $streetslug = str_slug($street);
                    $slugcount = 2;
                    while(Street::where("slug", $streetslug)->count() > 0){
                        $streetslug = str_slug($street)."-".$slugcount;
                        $slugcount++;
                    }

                    $streetm->slug = $streetslug;
                    $streetm->save();

                    $streetOrder++;

                    $this->command->info($city."-".$town."-".$street);
                }
                $townOrder++;
            }
            $cityOrder++;

            $this->command->info("[".$addedCity."/".$totalCity."] City Completed!");
            $addedCity++;
        }
    }
}