/** * Run the database seeds. * * @return void */ public function run() { $country = Region::whereTranslation('name', 'Canada', 'en')->first(); DB::table('regions')->where('country_id', $country->country_id)->where('id', '!=', $country->id)->delete(); $regions = []; $depths = [3, 12, 14, 14, 14]; $regions["Alberta"] = []; $regions["en:British Columbia|fr:Colombie-Brittanique"] = []; $regions["en:British Columbia|fr:Colombie-Brittanique"]["en:Okanagan Valley|fr:Vallée de l'Okanagan"] = []; $regions["en:British Columbia|fr:Colombie-Brittanique"]["en:Okanagan Valley|fr:Vallée de l'Okanagan"]["Golden Mile Bench"] = []; $regions["en:British Columbia|fr:Colombie-Brittanique"]["en:Similkameen Valley|fr:Vallée de la Similkameen"] = []; $regions["en:British Columbia|fr:Colombie-Brittanique"]["en:Fraser Valley|fr:Valée du Fraser"] = []; $regions["en:British Columbia|fr:Colombie-Brittanique"]["en:Vancouver Island|fr:Île de Vancouver"] = []; $regions["en:British Columbia|fr:Colombie-Brittanique"]["en:Gulf Islands|fr:Îles du golfe"] = []; $regions["Manitoba"] = []; $regions["en:New Brunswick|fr:Nouveau-Brunswick"] = []; $regions["en:Newfoundland and Labrador|fr:Terre-Neuve-et-Labrador"] = []; $regions["en:Nova Scotia|fr:Nouvelle-Écosse"] = []; $regions["Ontario"] = []; $regions["Ontario"]["en:Lake Erie North Shore|fr:Rive nord du lac Érié"] = []; $regions["Ontario"]["en:Prince Edward County|fr:Comté du Prince-Édouard"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara Escarpment|fr:Escarpement du Niagara"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara Escarpment|fr:Escarpement du Niagara"]["Short Hills Bench"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara Escarpment|fr:Escarpement du Niagara"]["Twenty Mile Bench"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara Escarpment|fr:Escarpement du Niagara"]["Beamsville Bench"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"]["en:Niagara River|fr:Rivière Niagara"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"]["Niagara Lakeshore"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"]["en:Four Mile Creek|fr:Ruisseau des Quatre Milles"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"]["St. David’s Bench"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"]["Vinemount Ridge"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"]["Creek Shores"] = []; $regions["Ontario"]["en:Niagara Peninsula|fr:Péninsule du Niagara"]["en:Niagara-on-the-Lake|fr:Niagara-sur-le-Lac"]["Lincoln Lakeshore"] = []; $regions["en:Prince Edward Island|fr:Île-du-Prince-Édouard"] = []; $regions["en:Quebec|fr:Québec"] = []; $regions["Saskatchewan"] = []; foreach ($regions as $region => $children) { $this->makeChild($country, $region, $children, $depths, $country->country_id); } $regions = []; $depths = [4]; $regions["Nunavut"] = []; $regions["en:Northwest Territories|fr:Territoires du Nord-Ouest"] = []; $regions["Yukon"] = []; foreach ($regions as $region => $children) { $this->makeChild($country, $region, $children, $depths, $country->country_id); } $existing = Region::whereTranslationIn('name', ['Niagara Escarpment', 'Niagara-on-the-Lake'], 'en')->update(['region_type_id' => 13]); }
/** * Run the database seeds. * * @return void */ public function run() { $country = Region::whereTranslation('name', 'United States', 'en')->first(); $regions = []; $depths = [2, 11, 11, 11, 11, 11, 11, 11]; $regions['Alabama'] = []; $regions['Alaska'] = []; $regions['Arizona'] = []; $regions['Arizona']['Sonoita'] = []; $regions['Arkansas']['Altus'] = []; $regions['Arkansas']['Arkansas Mountain'] = []; $regions['Arkansas']['Ozark Mountain'] = []; $regions['California']['Ben Lomond Mountain'] = []; $regions['California']['Central Coast']['Arroyo Grande Valley'] = []; $regions['California']['Central Coast']['Arroyo Seco'] = []; $regions['California']['Central Coast']['Ballard Canyon'] = []; $regions['California']['Central Coast']['Carmel Valley'] = []; $regions['California']['Central Coast']['Chalone'] = []; $regions['California']['Central Coast']['Cienega Valley'] = []; $regions['California']['Central Coast']['Edna Valley'] = []; $regions['California']['Central Coast']['Hames Valley'] = []; $regions['California']['Central Coast']['Happy Canyon of Santa Barbara'] = []; $regions['California']['Central Coast']['Lime Kiln Valley'] = []; $regions['California']['Central Coast']['Livermore Valley'] = []; $regions['California']['Central Coast']['Monterey'] = []; $regions['California']['Central Coast']['Mt. Harlan'] = []; $regions['California']['Central Coast']['Pacheco Pass'] = []; $regions['California']['Central Coast']['Paicines'] = []; $regions['California']['Central Coast']['Paso Robles']['Adelaida District'] = []; $regions['California']['Central Coast']['Paso Robles']['Creston District'] = []; $regions['California']['Central Coast']['Paso Robles']['El Pomar District'] = []; $regions['California']['Central Coast']['Paso Robles']['Paso Robles Estrella District'] = []; $regions['California']['Central Coast']['Paso Robles']['Paso Robles Geneseo District'] = []; $regions['California']['Central Coast']['Paso Robles']['Paso Robles Highlands District'] = []; $regions['California']['Central Coast']['Paso Robles']['Paso Robles Willow Creek District'] = []; $regions['California']['Central Coast']['Paso Robles']['San Juan Creek'] = []; $regions['California']['Central Coast']['Paso Robles']['San Miguel District'] = []; $regions['California']['Central Coast']['Paso Robles']['Santa Margarita Ranch'] = []; $regions['California']['Central Coast']['Paso Robles']['Templeton Gap District'] = []; $regions['California']['Central Coast']['San Antonio Valley'] = []; $regions['California']['Central Coast']['San Benito'] = []; $regions['California']['Central Coast']['San Bernabe'] = []; $regions['California']['Central Coast']['San Francisco Bay'] = []; $regions['California']['Central Coast']['San Lucas'] = []; $regions['California']['Central Coast']['San Ysidro District'] = []; $regions['California']['Central Coast']['Santa Clara Valley'] = []; $regions['California']['Central Coast']['Santa Lucia Highlands'] = []; $regions['California']['Central Coast']['Santa Maria Valley'] = []; $regions['California']['Central Coast']['Santa Ynez Valley'] = []; $regions['California']['Central Coast']['Sta. Rita Hills'] = []; $regions['California']['Central Coast']['York Mountain'] = []; $regions['California']['Central Valley']['Alta Mesa'] = []; $regions['California']['Central Valley']['Borden Ranch'] = []; $regions['California']['Central Valley']['Capay Valley'] = []; $regions['California']['Central Valley']['Clarksburg'] = []; $regions['California']['Central Valley']['Clements Hills'] = []; $regions['California']['Central Valley']['Cosumnes River'] = []; $regions['California']['Central Valley']['Diablo Grande'] = []; $regions['California']['Central Valley']['Dunnigan Hills'] = []; $regions['California']['Central Valley']['Jahant'] = []; $regions['California']['Central Valley']['Lodi'] = []; $regions['California']['Central Valley']['Madera'] = []; $regions['California']['Central Valley']['Merritt Island'] = []; $regions['California']['Central Valley']['Mokelumne River'] = []; $regions['California']['Central Valley']['River Junction'] = []; $regions['California']['Central Valley']['Salado Creek'] = []; $regions['California']['Central Valley']['Sloughhouse'] = []; $regions['California']['Central Valley']['Tracy Hills'] = []; $regions['California']['Klamath Mountains']['Seiad Valley'] = []; $regions['California']['Klamath Mountains']['Trinity Lakes'] = []; $regions['California']['Klamath Mountains']['Willow Creek'] = []; $regions['California']['Manton Valley'] = []; $regions['California']['North Coast']['Alexander Valley'] = []; $regions['California']['North Coast']['Anderson Valley'] = []; $regions['California']['North Coast']['Atlas Peak'] = []; $regions['California']['North Coast']['Benmore Valley'] = []; $regions['California']['North Coast']['Bennett Valley'] = []; $regions['California']['North Coast']['Big Valley District–Lake County'] = []; $regions['California']['North Coast']['Calistoga'] = []; $regions['California']['North Coast']['Chalk Hill'] = []; $regions['California']['North Coast']['Chiles Valley'] = []; $regions['California']['North Coast']['Clear Lake'] = []; $regions['California']['North Coast']['Cole Ranch'] = []; $regions['California']['North Coast']['Coombsville'] = []; $regions['California']['North Coast']['Covelo'] = []; $regions['California']['North Coast']['Diamond Mountain District'] = []; $regions['California']['North Coast']['Dos Rios'] = []; $regions['California']['North Coast']['Dry Creek Valley'] = []; $regions['California']['North Coast']['Eagle Peak Mendocino County'] = []; $regions['California']['North Coast']['Fort Ross–Seaview'] = []; $regions['California']['North Coast']['Fountaingrove District'] = []; $regions['California']['North Coast']['Green Valley of Russian River Valley'] = []; $regions['California']['North Coast']['Guenoc Valley'] = []; $regions['California']['North Coast']['High Valley'] = []; $regions['California']['North Coast']['Howell Mountain'] = []; $regions['California']['North Coast']['Kelsey Bench–Lake County'] = []; $regions['California']['North Coast']['Knights Valley'] = []; $regions['California']['North Coast']['Los Carneros'] = []; $regions['California']['North Coast']['McDowell Valley'] = []; $regions['California']['North Coast']['Mendocino'] = []; $regions['California']['North Coast']['Mendocino Ridge'] = []; $regions['California']['North Coast']['Moon Mountain District Sonoma County'] = []; $regions['California']['North Coast']['Mt. Veeder'] = []; $regions['California']['North Coast']['Napa Valley'] = []; $regions['California']['North Coast']['Northern Sonoma'] = []; $regions['California']['North Coast']['Oak Knoll District of Napa Valley'] = []; $regions['California']['North Coast']['Oakville'] = []; $regions['California']['North Coast']['Pine Mountain–Cloverdale Peak'] = []; $regions['California']['North Coast']['Potter Valley'] = []; $regions['California']['North Coast']['Red Hills Lake County'] = []; $regions['California']['North Coast']['Redwood Valley'] = []; $regions['California']['North Coast']['Rockpile'] = []; $regions['California']['North Coast']['Russian River Valley'] = []; $regions['California']['North Coast']['Rutherford'] = []; $regions['California']['North Coast']['Solano County Green Valley'] = []; $regions['California']['North Coast']['Sonoma Coast'] = []; $regions['California']['North Coast']['Sonoma Mountain'] = []; $regions['California']['North Coast']['Sonoma Valley'] = []; $regions['California']['North Coast']['Spring Mountain District'] = []; $regions['California']['North Coast']['St. Helena'] = []; $regions['California']['North Coast']['Stags Leap District'] = []; $regions['California']['North Coast']['Suisun Valley'] = []; $regions['California']['North Coast']['Wild Horse Valley'] = []; $regions['California']['North Coast']['Yorkville Highlands'] = []; $regions['California']['North Coast']['Yountville'] = []; $regions['California']['Santa Cruz Mountains'] = []; $regions['California']['Sierra Foothills']['California Shenandoah Valley'] = []; $regions['California']['Sierra Foothills']['El Dorado'] = []; $regions['California']['Sierra Foothills']['Fair Play'] = []; $regions['California']['Sierra Foothills']['Fiddletown'] = []; $regions['California']['Sierra Foothills']['North Yuba'] = []; $regions['California']['South Coast']['Antelope Valley of the California High Desert'] = []; $regions['California']['South Coast']['Cucamonga Valley'] = []; $regions['California']['South Coast']['Leona Valley'] = []; $regions['California']['South Coast']['Malibu Coast']['Malibu–Newton Canyon'] = []; $regions['California']['South Coast']['Malibu Coast']['Saddle Rock–Malibu'] = []; $regions['California']['South Coast']['Ramona Valley'] = []; $regions['California']['South Coast']['San Pasqual Valley'] = []; $regions['California']['South Coast']['Sierra Pelona Valley'] = []; $regions['California']['South Coast']['Temecula Valley'] = []; $regions['California']['Squaw Valley–Miramonte'] = []; $regions['Colorado']['Grand Valley'] = []; $regions['Colorado']['West Elks'] = []; $regions['Connecticut']['Southeastern New England'] = []; $regions['Connecticut']['Western Connecticut Highlands'] = []; $regions['Delaware'] = []; $regions['Florida'] = []; $regions['Georgia']['Upper Hiwassee Highlands'] = []; $regions['Hawaii'] = []; $regions['Idaho']['Snake River Valley'] = []; $regions['Illinois']['Shawnee Hills'] = []; $regions['Illinois']['Upper Mississippi River Valley'] = []; $regions['Indiana']['Indiana Uplands'] = []; $regions['Indiana']['Ohio River Valley'] = []; $regions['Iowa']['Upper Mississippi River Valley'] = '_SHORTCUT'; $regions['Kansas'] = []; $regions['Kentucky']['Ohio River Valley'] = '_SHORTCUT'; $regions['Louisiana']['Mississippi Delta'] = []; $regions['Maine'] = []; $regions['Maryland']['Catoctin'] = []; $regions['Maryland']['Cumberland Valley'] = []; $regions['Maryland']['Linganore'] = []; $regions['Massachusetts']['Martha’s Vineyard'] = []; $regions['Massachusetts']['Southeastern New England'] = '_SHORTCUT'; $regions['Michigan']['Fennville'] = []; $regions['Michigan']['Lake Michigan Shore'] = []; $regions['Michigan']['Leelanau Peninsula'] = []; $regions['Michigan']['Old Mission Peninsula'] = []; $regions['Minnesota']['Alexandria Lakes'] = []; $regions['Minnesota']['Upper Mississippi River Valley'] = '_SHORTCUT'; $regions['Mississippi']['Mississippi Delta'] = '_SHORTCUT'; $regions['Missouri']['Augusta'] = []; $regions['Missouri']['Hermann'] = []; $regions['Missouri']['Ozark Highlands'] = []; $regions['Missouri']['Ozark Mountain'] = '_SHORTCUT'; $regions['Montana'] = []; $regions['Nebraska'] = []; $regions['Nevada'] = []; $regions['New Hampshire'] = []; $regions['New Jersey']['Central Delaware Valley'] = []; $regions['New Jersey']['Outer Coastal Plain'] = []; $regions['New Jersey']['Warren Hills'] = []; $regions['New Mexico']['Mesilla Valley'] = []; $regions['New Mexico']['Middle Rio Grande Valley'] = []; $regions['New Mexico']['Mimbres Valley'] = []; $regions['New York']['Cayuga Lake'] = []; $regions['New York']['Finger Lakes'] = []; $regions['New York']['Hudson River Region'] = []; $regions['New York']['Lake Erie'] = []; $regions['New York']['Long Island'] = []; $regions['New York']['Niagara Escarpment'] = []; $regions['New York']['North Fork of Long Island'] = []; $regions['New York']['Seneca Lake'] = []; $regions['New York']['The Hamptons, Long Island'] = []; $regions['North Carolina']['Haw River Valley'] = []; $regions['North Carolina']['Swan Creek'] = []; $regions['North Carolina']['Upper Hiwassee Highlands'] = '_SHORTCUT'; $regions['North Carolina']['Yadkin Valley'] = []; $regions['North Dakota'] = []; $regions['Ohio']['Grand River Valley'] = []; $regions['Ohio']['Isle St. George'] = []; $regions['Ohio']['Lake Erie'] = '_SHORTCUT'; $regions['Ohio']['Loramie Creek'] = []; $regions['Ohio']['Ohio River Valley'] = '_SHORTCUT'; $regions['Oklahoma']['Ozark Mountain'] = '_SHORTCUT'; $regions['Oregon']['Applegate Valley'] = []; $regions['Oregon']['Chehalem Mountains'] = []; $regions['Oregon']['Columbia Gorge'] = []; $regions['Oregon']['Columbia Valley'] = []; $regions['Oregon']['Dundee Hills'] = []; $regions['Oregon']['Elkton Oregon'] = []; $regions['Oregon']['Eola–Amity Hills'] = []; $regions['Oregon']['McMinnville'] = []; $regions['Oregon']['Red Hill Douglas County, Oregon'] = []; $regions['Oregon']['Ribbon Ridge'] = []; $regions['Oregon']['Rogue Valley'] = []; $regions['Oregon']['Snake River Valley'] = '_SHORTCUT'; $regions['Oregon']['Southern Oregon'] = []; $regions['Oregon']['The Rocks District of Milton–Freewater'] = []; $regions['Oregon']['Umpqua Valley'] = []; $regions['Oregon']['Walla Walla Valley'] = []; $regions['Oregon']['Willamette Valley'] = []; $regions['Oregon']['Yamhill–Carlton'] = []; $regions['Pennsylvania']['Central Delaware Valley'] = '_SHORTCUT'; $regions['Pennsylvania']['Cumberland Valley'] = '_SHORTCUT'; $regions['Pennsylvania']['Lake Erie'] = '_SHORTCUT'; $regions['Pennsylvania']['Lancaster Valley'] = []; $regions['Pennsylvania']['Lehigh Valley'] = []; $regions['Rhode Island']['Mississippi Delta'] = '_SHORTCUT'; $regions['Rhode Island']['Southeastern New England'] = '_SHORTCUT'; $regions['South Carolina'] = []; $regions['South Dakota'] = []; $regions['Tennessee'] = []; $regions['Texas']['Bell Mountain'] = []; $regions['Texas']['Escondido Valley'] = []; $regions['Texas']['Fredericksburg in the Texas Hill Country'] = []; $regions['Texas']['Mesilla Valley'] = '_SHORTCUT'; $regions['Texas']['Texas Davis Mountains'] = []; $regions['Texas']['Texas High Plains'] = []; $regions['Texas']['Texas Hill Country'] = []; $regions['Texas']['Texoma'] = []; $regions['Utah'] = []; $regions['Vermont'] = []; $regions['Virginia']['Middleburg Virginia'] = []; $regions['Virginia']['Monticello'] = []; $regions['Virginia']['North Fork of Roanoke'] = []; $regions['Virginia']['Northern Neck George Washington Birthplace'] = []; $regions['Virginia']['Rocky Knob'] = []; $regions['Virginia']['Shenandoah Valley'] = []; $regions['Virginia']['Virginia’s Eastern Shore'] = []; $regions['Washington']['Ancient Lakes of Columbia Valley'] = []; $regions['Washington']['Columbia Gorge'] = '_SHORTCUT'; $regions['Washington']['Columbia Valley'] = '_SHORTCUT'; $regions['Washington']['Horse Heaven Hills'] = []; $regions['Washington']['Lake Chelan'] = []; $regions['Washington']['Naches Heights'] = []; $regions['Washington']['Puget Sound'] = []; $regions['Washington']['Rattlesnake Hills'] = []; $regions['Washington']['Red Mountain'] = []; $regions['Washington']['Snipes Mountain'] = []; $regions['Washington']['Wahluke Slope'] = []; $regions['Washington']['Walla Walla Valley'] = '_SHORTCUT'; $regions['Washington']['Yakima Valley'] = []; $regions['Washington D.C.'] = []; $regions['West Virginia']['Kanawha River Valley'] = []; $regions['West Virginia']['Ohio River Valley'] = '_SHORTCUT'; $regions['West Virginia']['Shenandoah Valley'] = '_SHORTCUT'; $regions['Wisconsin']['Lake Wisconsin'] = []; $regions['Wisconsin']['Upper Mississippi River Valley'] = '_SHORTCUT'; $regions['Wisconsin']['Wisconsin Ledge'] = []; $regions['Wyoming'] = []; foreach ($regions as $region => $children) { $this->makeChild($country, $region, $children, $depths, $country->country_id); } Region::whereTranslationIn('name', ['Central Valley', 'Klamath Mountains'], 'en')->where('country_id', $country->country_id)->update(['is_structural' => true, 'region_type_id' => 7]); $names = ['Alabama' => ['ru' => 'Алабама', 'zh' => '亚拉巴马', 'zh-Hant' => '阿拉巴馬'], 'Alaska' => ['ru' => 'Аляска', 'zh' => '阿拉斯加', 'zh-Hant' => '阿拉斯加'], 'Arizona' => ['ru' => 'Аризона', 'zh' => '亚利桑那', 'zh-Hant' => '亞利桑那'], 'Arkansas' => ['ru' => 'Арканзас', 'zh' => '阿肯色', 'zh-Hant' => '阿肯色'], 'California' => ['fr' => 'Californie', 'ru' => 'Калифорния', 'zh' => '加利福尼亚', 'zh-Hant' => '加利福尼亞'], 'Colorado' => ['ru' => 'Колорадо', 'zh' => '科罗拉多', 'zh-Hant' => '科羅拉多'], 'Connecticut' => ['ru' => 'Коннектикут', 'zh' => '康涅狄格', 'zh-Hant' => '康涅狄格'], 'Delaware' => ['ru' => 'Делавэр', 'zh' => '特拉华', 'zh-Hant' => '特拉華'], 'Florida' => ['fr' => 'Floride', 'ru' => 'Флорида', 'zh' => '佛罗里达', 'zh-Hant' => '佛羅里達'], 'Georgia' => ['fr' => 'Géorgie', 'ru' => 'Джорджия', 'zh' => '佐治亚', 'zh-Hant' => '佐治亞'], 'Hawaii' => ['es' => 'Hawái', 'fr' => 'Hawaï', 'ru' => 'Гавайи', 'zh' => '夏威夷', 'zh-Hant' => '夏威夷'], 'Idaho' => ['ru' => 'Айдахо', 'zh' => '爱达荷', 'zh-Hant' => '愛達荷'], 'Illinois' => ['ru' => 'Иллинойс', 'zh' => '伊利诺伊', 'zh-Hant' => '伊利諾伊'], 'Indiana' => ['ru' => 'Индиана', 'zh' => '印第安纳', 'zh-Hant' => '印第安納'], 'Iowa' => ['ru' => 'Айова', 'zh' => '艾奥瓦', 'zh-Hant' => '艾奧瓦'], 'Kansas' => ['ru' => 'Канзас', 'zh' => '堪萨斯', 'zh-Hant' => '堪薩斯'], 'Kentucky' => ['ru' => 'Кентукки', 'zh' => '肯塔基', 'zh-Hant' => '肯塔基'], 'Louisiana' => ['es' => 'Luisiana', 'fr' => 'Louisiane', 'ru' => 'Луизиана', 'zh' => '路易斯安那', 'zh-Hant' => '路易斯安那'], 'Maine' => ['ru' => 'Мэн', 'zh' => '缅因', 'zh-Hant' => '緬因'], 'Maryland' => ['ru' => 'Мэриленд', 'zh' => '马里兰', 'zh-Hant' => '馬里蘭'], 'Massachusetts' => ['ru' => 'Массачусетс', 'zh' => '马萨诸塞', 'zh-Hant' => '馬薩諸塞'], 'Michigan' => ['es' => 'Míchigan', 'ru' => 'Мичиган', 'zh' => '密西根', 'zh-Hant' => '密西根'], 'Minnesota' => ['ru' => 'Миннесота', 'zh' => '明尼苏达', 'zh-Hant' => '明尼蘇達'], 'Mississippi' => ['es' => 'Misisipi', 'ru' => 'Миссисипи', 'zh' => '密西西比', 'zh-Hant' => '密西西比'], 'Missouri' => ['es' => 'Misuri', 'ru' => 'Миссури', 'zh' => '密苏里', 'zh-Hant' => '密蘇里'], 'Montana' => ['ru' => 'Монтана', 'zh' => '蒙大拿', 'zh-Hant' => '蒙大拿'], 'Nebraska' => ['ru' => 'Небраска', 'zh' => '内布拉斯加', 'zh-Hant' => '內布拉斯加'], 'Nevada' => ['ru' => 'Невада', 'zh' => '内华达', 'zh-Hant' => '內華達'], 'New Hampshire' => ['es' => 'Nuevo Hampshire', 'ru' => 'Нью-Гэмпшир', 'zh' => '新罕布什尔', 'zh-Hant' => '新罕布什爾'], 'New Jersey' => ['es' => 'Nueva Jersey', 'ru' => 'Нью-Джерси', 'zh' => '新泽西', 'zh-Hant' => '新澤西'], 'New Mexico' => ['es' => 'Nuevo México', 'fr' => 'Nouveau-Mexique', 'ru' => 'Нью-Мексико', 'zh' => '新墨西哥', 'zh-Hant' => '新墨西哥'], 'New York' => ['es' => 'Nueva York', 'ru' => 'Нью-Йорк', 'zh' => '纽约', 'zh-Hant' => '紐約'], 'North Carolina' => ['es' => 'Carolina del Norte', 'fr' => 'Caroline du Nord', 'ru' => 'Северная Каролина', 'zh' => '北卡罗来纳', 'zh-Hant' => '北卡羅來納'], 'North Dakota' => ['es' => 'Dakota del Norte', 'fr' => 'Dakota du Nord', 'ru' => 'Северная Дакота', 'zh' => '北达科他', 'zh-Hant' => '北達科他'], 'Ohio' => ['ru' => 'Огайо', 'zh' => '俄亥俄', 'zh-Hant' => '俄亥俄'], 'Oklahoma' => ['ru' => 'Оклахома', 'zh' => '奧克拉荷馬', 'zh-Hant' => '奧克拉荷馬'], 'Oregon' => ['es' => 'Oregón', 'ru' => 'Орегон', 'zh' => '俄勒冈', 'zh-Hant' => '俄勒岡'], 'Pennsylvania' => ['es' => 'Pensilvania', 'fr' => 'Pennsylvanie', 'ru' => 'Пенсильвания', 'zh' => '宾夕法尼亚', 'zh-Hant' => '賓夕法尼亞'], 'Rhode Island' => ['ru' => 'Род-Айленд', 'zh' => '罗得岛', 'zh-Hant' => '羅得島'], 'South Carolina' => ['es' => 'Carolina del Sur', 'fr' => 'Caroline du Sud', 'ru' => 'Южная Каролина', 'zh' => '南卡罗来纳', 'zh-Hant' => '南卡羅來納'], 'South Dakota' => ['es' => 'Dakota del Sur', 'fr' => 'Dakota du Sud', 'ru' => 'Южная Дакота', 'zh' => '南达科他', 'zh-Hant' => '南達科他'], 'Tennessee' => ['ru' => 'Теннесси', 'zh' => '田纳西', 'zh-Hant' => '田納西'], 'Texas' => ['ru' => 'Техас', 'zh' => '得克萨斯', 'zh-Hant' => '得克薩斯'], 'Utah' => ['ru' => 'Юта', 'zh' => '犹他', 'zh-Hant' => '猶他'], 'Vermont' => ['ru' => 'Вермонт', 'zh' => '佛蒙特', 'zh-Hant' => '佛蒙特'], 'Virginia' => ['fr' => 'Virginie', 'ru' => 'Виргиния', 'zh' => '弗吉尼亚', 'zh-Hant' => '弗吉尼亞'], 'Washington' => ['ru' => 'Вашингтон', 'zh' => '华盛顿', 'zh-Hant' => '華盛頓'], 'West Virginia' => ['es' => 'Virginia Occidental', 'fr' => 'Virginie-Occidentale', 'ru' => 'Западная Виргиния', 'zh' => '西弗吉尼亚', 'zh-Hant' => '西弗吉尼亞'], 'Wisconsin' => ['ru' => 'Висконсин', 'zh' => '威斯康星', 'zh-Hant' => '威斯康星'], 'Wyoming' => ['ru' => 'Вайоминг', 'zh' => '怀俄明', 'zh-Hant' => '懷俄明']]; foreach ($names as $en => $locales) { $region = Region::whereTranslation('name', $en, 'en')->where('country_id', $country->country_id)->first(); if ($region) { $attr = []; foreach ($locales as $locale => $name) { $attr[$locale] = ['name' => $name]; } if (@$attr['zh-Hant'] == @$attr['zh']) { unset($attr['zh-Hant']); } $region->fill($attr)->save(); } else { dd($en); } } }
/** * Run the database seeds. * * @return void */ public function run() { $country = Region::whereTranslation('name', 'Australia', 'en')->first(); DB::table('regions')->where('country_id', $country->country_id)->where('id', '!=', $country->id)->delete(); $regions = []; $depths = [2, 6, 7, 8]; $sa = 'en:South Australia|de:Südaustralien|fr:Australie-Méridionale|es:Australia Meridional|it:Australia Meridionale|ru:Южная Австралия|zh:南澳大利亚州'; $nsw = 'en:New South Wales|de:Neusüdwales|fr:Nouvelle-Galles du Sud|es:Nueva Gales del Sur|it:Nuovo Gales del Sud|zh:新南威尔士州|ru:Новый Южный Уэльс'; $wa = 'en:Western Australia|de:Westaustralien|fr:Australie-Occidentale|zh:西澳大利亚州|ru:Западная Австралия|es:Australia Occidental|it:Australia Occidentale'; $qld = 'en:Queensland|zh:昆士兰州|ru:Квинсленд'; $vic = 'en:Victoria|ru:Виктория|zh:维多利亚州'; $tas = 'en:Tasmania|zh:塔斯马尼亚州|fr:Tasmanie|ru:Тасмания|de:Tasmanien'; $nt = 'en:Northern Territory|es:Territorio del Norte|it:Territorio del Nord|zh:北领地|ru:Северная территория|de:Nordterritorium'; $act = 'en:Australian Capital Territory|de:Australisches Hauptstadtterritorium|es:Territorio de la Capital Australiana|it:Territorio della Capitale Australiana|zh:澳大利亚首都领地|ru:Австралийская столичная территория'; $adelaide = 'en:Adelaide|fr:Adélaïde|es:Adelaida|zh:阿德莱德'; $hunterValley = 'en:Hunter Valley|es:Valle de Hunter|it:Valle de Hunter|fr:Vallée Hunter'; $barossaValley = 'en:Barossa Valley|es:Valle de Barossa|it:Valle de Barossa|fr:Vallée Barossa|ru:Долина Баросса|zh:巴罗莎山谷'; $barossa = 'en:Barossa|ru:Баросса|zh:巴罗莎'; $southWestAustralia = 'en:South West Australia|de:Südwestaustralien|zh:澳大利亚西南部|es:Suroeste de Australia|fr:Sud-ouest de l\'Australie|ru:Юго-западная Австралия'; $southernNsw = 'en:Southern New South Wales|de:Südliches Neusüdwales|fr:Partie sud de la Nouvelle-Galles du Sud|es:Parte sur de Nueva Gales del Sur|it:Parte sur de Nueva Gales del Sur|zh:新南威尔士州南部'; $centralVictoria = 'en:Central Victoria|zh:维多利亚州中部|ru:Центральный Виктория|de:Zentral-Victoria|fr:Centre de Victoria'; $northEastVictoria = 'en:North East Victoria|zh:维多利亚州东北部|ru:Северо-восточный Виктория|de:Nordost-Victoria|fr:Partie nord-est de Victoria|es:Parte noreste de Victoria|it:Parte nord-orientale de Victoria'; $northWestVictoria = 'en:North West Victoria|zh:维多利亚州西北部|ru:Северо-западный Виктория|de:Nordwest-Victoria|fr:Partie nord-ouest de Victoria|es:Parte noroeste de Victoria|it:Parte nord-occidentale de Victoria'; $westernVictoria = 'en:Western Victoria|zh:维多利亚州西部|ru:Западный Виктория|de:West-Victoria|fr:Partie nord-ouest de Victoria|es:Parte noroeste de Victoria|it:Parte nord-occidentale de Victoria'; $southCoast = 'en:South Coast|ru:Южное побережье|zh:南海岸|es:Costa meridionale|it:Costa sur|de:Südküste|fr:Côte sud'; $peninsulas = 'en:The Peninsulas|es:Las penínsulas|it:Le peninsule|fr:Les péninsules|ru:Полуостровов|de:Die Halbinseln|zh:半岛'; $regions[$sa] = []; $regions[$sa][$barossa][$barossaValley] = []; $regions[$sa][$barossa]['Eden Valley']['High Eden'] = []; $regions[$sa]['Far North']['Southern Flinders Ranges'] = []; $regions[$sa]['Fleurieu']['Currency Creek'] = []; $regions[$sa]['Fleurieu']['Kangaroo Island'] = []; $regions[$sa]['Fleurieu']['Langhorne Creek'] = []; $regions[$sa]['Fleurieu']['McLaren Vale'] = []; $regions[$sa]['Fleurieu']['Southern Fleurieu'] = []; $regions[$sa]['Limestone Coast']['Coonawarra'] = []; $regions[$sa]['Limestone Coast']['Mount Benson'] = []; $regions[$sa]['Limestone Coast']['Mount Gambier'] = []; $regions[$sa]['Limestone Coast']['Padthaway'] = []; $regions[$sa]['Limestone Coast']['Robe'] = []; $regions[$sa]['Limestone Coast']['Wrattonbully'] = []; $regions[$sa]['Lower Murray']['Riverland'] = []; $regions[$sa]['Mount Lofty Ranges']['Adelaide Hills']['Lenswood'] = []; $regions[$sa]['Mount Lofty Ranges']['Adelaide Hills']['Piccadilly Valley'] = []; $regions[$sa]['Mount Lofty Ranges']['Adelaide Plains'] = []; $regions[$sa]['Mount Lofty Ranges']['Clare Valley'] = []; $regions[$sa][$peninsulas] = []; $regions[$sa][$adelaide] = []; $regions[$sa][$adelaide]['Mount Lofty Ranges'] = '_SHORTCUT'; $regions[$sa][$adelaide]['Fleurieu'] = '_SHORTCUT'; $regions[$sa][$adelaide][$barossa] = '_SHORTCUT'; $regions[$nsw] = []; $regions[$nsw]['Big Rivers']['Murray Darling'] = []; $regions[$nsw]['Big Rivers']['Perricoota'] = []; $regions[$nsw]['Big Rivers']['Riverina'] = []; $regions[$nsw]['Big Rivers']['Swan Hill'] = []; $regions[$nsw]['Central Ranges']['Cowra'] = []; $regions[$nsw]['Central Ranges']['Mudgee'] = []; $regions[$nsw]['Central Ranges']['Orange'] = []; $regions[$nsw][$hunterValley]['Hunter']['Broke Fordwich'] = []; $regions[$nsw][$hunterValley]['Hunter']['Pokolbin'] = []; $regions[$nsw][$hunterValley]['Hunter']['Upper Hunter Valley'] = []; $regions[$nsw]['Northern Rivers']['Hastings River'] = []; $regions[$nsw]['Northern Slopes']['New England Australia'] = []; $regions[$nsw][$southCoast]['Shoalhaven Coast'] = []; $regions[$nsw][$southCoast]['Southern Highlands'] = []; $regions[$nsw][$southernNsw]['Canberra District'] = []; $regions[$nsw][$southernNsw]['Gundagai'] = []; $regions[$nsw][$southernNsw]['Hilltops'] = []; $regions[$nsw][$southernNsw]['Tumbarumba'] = []; $regions[$wa] = []; $regions[$wa]['Central Western Australia'] = []; $regions[$wa]['Eastern Plains - Inland and North of Western Australia'] = []; $regions[$wa]['Greater Perth']['Peel'] = []; $regions[$wa]['Greater Perth']['Perth Hills'] = []; $regions[$wa]['Greater Perth']['Swan District']['Swan Valley'] = []; $regions[$wa][$southWestAustralia]['Blackwood Valley'] = []; $regions[$wa][$southWestAustralia]['Geographe'] = []; $regions[$wa][$southWestAustralia]['Great Southern']['Albany'] = []; $regions[$wa][$southWestAustralia]['Great Southern']['Denmark'] = []; $regions[$wa][$southWestAustralia]['Great Southern']['Frankland River'] = []; $regions[$wa][$southWestAustralia]['Great Southern']['Mount Barker'] = []; $regions[$wa][$southWestAustralia]['Great Southern']['Porongurup'] = []; $regions[$wa][$southWestAustralia]['Manjimup'] = []; $regions[$wa][$southWestAustralia]['Margaret River'] = []; $regions[$wa][$southWestAustralia]['Pemberton'] = []; $regions[$wa]['West Australian South East Coastal'] = []; $regions[$qld] = []; $regions[$qld]['Granite Belt'] = []; $regions[$qld]['South Burnett'] = []; $regions[$vic] = []; $regions[$vic][$centralVictoria]['Bendigo'] = []; $regions[$vic][$centralVictoria]['Goulburn Valley']['Nagambie Lakes'] = []; $regions[$vic][$centralVictoria]['Heathcote'] = []; $regions[$vic][$centralVictoria]['Strathbogie Ranges'] = []; $regions[$vic][$centralVictoria]['Upper Goulburn'] = []; $regions[$vic]['Gippsland'] = []; $regions[$vic][$northEastVictoria]['Alpine Valleys'] = []; $regions[$vic][$northEastVictoria]['Beechworth'] = []; $regions[$vic][$northEastVictoria]['Glenrowan'] = []; $regions[$vic][$northEastVictoria]['King Valley'] = []; $regions[$vic][$northEastVictoria]['Rutherglen'] = []; $regions[$vic][$northWestVictoria]['Murray Darling'] = '_SHORTCUT'; $regions[$vic][$northWestVictoria]['Swan Hill'] = '_SHORTCUT'; $regions[$vic]['Port Phillip']['Geelong'] = []; $regions[$vic]['Port Phillip']['Macedon Ranges'] = []; $regions[$vic]['Port Phillip']['Mornington Peninsula'] = []; $regions[$vic]['Port Phillip']['Sunbury'] = []; $regions[$vic]['Port Phillip']['Yarra Valley'] = []; $regions[$vic][$westernVictoria]['Grampians']['Great Western'] = []; $regions[$vic][$westernVictoria]['Henty'] = []; $regions[$vic][$westernVictoria]['Pyrenees'] = []; $regions[$tas] = []; $regions[$nt] = []; $regions[$act] = []; foreach ($regions as $region => $children) { $this->makeChild($country, $region, $children, $depths, $country->country_id); } $regions = []; $depths = [5, 2]; $regions['South Eastern Australia'] = []; $regions['South Eastern Australia'][$nsw] = '_SHORTCUT'; $regions['South Eastern Australia'][$sa] = '_SHORTCUT'; $regions['South Eastern Australia'][$qld] = '_SHORTCUT'; $regions['South Eastern Australia'][$vic] = '_SHORTCUT'; foreach ($regions as $region => $children) { $this->makeChild($country, $region, $children, $depths, $country->country_id); } $existing = Region::whereTranslationIn('name', ['Australian Capital Territory', 'Northern Territory'], 'en')->update(['region_type_id' => 4]); }