<?php

namespace Database\Seeders;

use App\Models\Country;
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Schema;

class CountrySeeder extends Seeder
{
    /**
     * Run the database seeds.
     */
    public function run(): void
    {
        Schema::disableForeignKeyConstraints();
        DB::table("countries")->truncate();
        Schema::enableForeignKeyConstraints();
        $contents = File::get(public_path('countries.json'));
        $countries = json_decode($contents, true);
        foreach ($countries as $country) {
            $status = "ACTIVE";
            if ($country['id'] == "101") {
                $status = "ACTIVE";
            }
            $data = new Country;
            $data->title = $country['name'];
            $data->country_code = $country['iso3'];
            $data->iso3 = $country['iso3'];
            $data->iso2 = $country['iso2'];
            $data->phone_code = $country['phone_code'];
            $data->currency = $country['currency'];
            $data->currency_symbol = $country['currency_symbol'];
            $data->region = $country['region'];
            $data->timezone = !is_null($country["timezones"]) ? $country["timezones"][0]['zoneName'] : NULL;
            $data->offset = !is_null($country["timezones"]) ? $country["timezones"][0]['gmtOffset'] : NULL;
            $data->offset_name = !is_null($country["timezones"]) ? $country["timezones"][0]['gmtOffsetName'] : NULL;
            $data->latitude = $country['latitude'];
            $data->longitude = $country['longitude'];
            $data->status = $status;
            $data->save();
        }
    }
}