✏️ Edit: LocationSeeder.php
Path:
/home/thiqat5/electronics.thiqatech.com/platform/plugins/location/src/Seeders/LocationSeeder.php
Size: 2.2 KB · Modified: 2022-04-22 10:13:56 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<?php namespace Botble\Location\Seeders; use BaseHelper; use Botble\Base\Models\MetaBox; use Botble\Language\Models\LanguageMeta; use Botble\Location\Models\City; use Botble\Location\Models\CityTranslation; use Botble\Location\Models\Country; use Botble\Location\Models\CountryTranslation; use Botble\Location\Models\State; use Botble\Location\Models\StateTranslation; use Illuminate\Database\Seeder; class LocationSeeder extends Seeder { public function run() { if (defined('LANGUAGE_MODULE_SCREEN_NAME')) { LanguageMeta::whereIn('reference_type', [City::class, State::class, Country::class])->delete(); } City::truncate(); State::truncate(); Country::truncate(); CityTranslation::truncate(); StateTranslation::truncate(); CountryTranslation::truncate(); MetaBox::whereIn('reference_type', [City::class, State::class, Country::class])->delete(); $dataPath = __DIR__ . '/../../database/files'; foreach (BaseHelper::scanFolder($dataPath) as $countryCode) { $country = file_get_contents($dataPath . '/' . $countryCode . '/country.json'); $country = json_decode($country, true); $country = Country::create($country); $states = file_get_contents($dataPath . '/' . $countryCode . '/states.json'); $states = json_decode($states, true); foreach ($states as $state) { $state['country_id'] = $country->id; State::create($state); } $cities = file_get_contents($dataPath . '/' . $countryCode . '/cities.json'); $cities = json_decode($cities, true); foreach ($cities as $item) { $state = State::where('name', $item['name'])->first(); if (!$state) { continue; } foreach ($item['cities'] as $cityName) { $city = [ 'name' => $cityName, 'state_id' => $state->id, 'country_id' => $country->id, ]; City::create($city); } } } } }
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF