public function run()
{
Country::insert([['is_enabled' => true, 'code' => 'US', 'name' => 'United States'], ['is_enabled' => true, 'code' => 'CA', 'name' => 'Canada'], ['is_enabled' => true, 'code' => 'AU', 'name' => 'Australia'], ['is_enabled' => false, 'code' => 'FR', 'name' => 'France'], ['is_enabled' => false, 'code' => 'DE', 'name' => 'Germany'], ['is_enabled' => false, 'code' => 'IS', 'name' => 'Iceland'], ['is_enabled' => false, 'code' => 'IE', 'name' => 'Ireland'], ['is_enabled' => false, 'code' => 'IT', 'name' => 'Italy'], ['is_enabled' => false, 'code' => 'ES', 'name' => 'Spain'], ['is_enabled' => false, 'code' => 'SE', 'name' => 'Sweden'], ['is_enabled' => false, 'code' => 'AT', 'name' => 'Austria'], ['is_enabled' => false, 'code' => 'BE', 'name' => 'Belgium'], ['is_enabled' => false, 'code' => 'FI', 'name' => 'Finland'], ['is_enabled' => false, 'code' => 'CZ', 'name' => 'Czech Republic'], ['is_enabled' => false, 'code' => 'DK', 'name' => 'Denmark'], ['is_enabled' => false, 'code' => 'NO', 'name' => 'Norway'], ['is_enabled' => false, 'code' => 'GB', 'name' => 'United Kingdom'], ['is_enabled' => false, 'code' => 'CH', 'name' => 'Switzerland'], ['is_enabled' => false, 'code' => 'NZ', 'name' => 'New Zealand'], ['is_enabled' => false, 'code' => 'RU', 'name' => 'Russian Federation'], ['is_enabled' => false, 'code' => 'PT', 'name' => 'Portugal'], ['is_enabled' => false, 'code' => 'NL', 'name' => 'Netherlands'], ['is_enabled' => false, 'code' => 'IM', 'name' => 'Isle of Man'], ['is_enabled' => false, 'code' => 'AF', 'name' => 'Afghanistan'], ['is_enabled' => false, 'code' => 'AX', 'name' => 'Aland Islands '], ['is_enabled' => false, 'code' => 'AL', 'name' => 'Albania'], ['is_enabled' => false, 'code' => 'DZ', 'name' => 'Algeria'], ['is_enabled' => false, 'code' => 'AS', 'name' => 'American Samoa'], ['is_enabled' => false, 'code' => 'AD', 'name' => 'Andorra'], ['is_enabled' => false, 'code' => 'AO', 'name' => 'Angola'], ['is_enabled' => false, 'code' => 'AI', 'name' => 'Anguilla'], ['is_enabled' => false, 'code' => 'AQ', 'name' => 'Antarctica'], ['is_enabled' => false, 'code' => 'AG', 'name' => 'Antigua and Barbuda'], ['is_enabled' => false, 'code' => 'AR', 'name' => 'Argentina'], ['is_enabled' => false, 'code' => 'AM', 'name' => 'Armenia'], ['is_enabled' => false, 'code' => 'AW', 'name' => 'Aruba'], ['is_enabled' => false, 'code' => 'AZ', 'name' => 'Azerbaijan'], ['is_enabled' => false, 'code' => 'BS', 'name' => 'Bahamas'], ['is_enabled' => false, 'code' => 'BH', 'name' => 'Bahrain'], ['is_enabled' => false, 'code' => 'BD', 'name' => 'Bangladesh'], ['is_enabled' => false, 'code' => 'BB', 'name' => 'Barbados'], ['is_enabled' => false, 'code' => 'BY', 'name' => 'Belarus'], ['is_enabled' => false, 'code' => 'BZ', 'name' => 'Belize'], ['is_enabled' => false, 'code' => 'BJ', 'name' => 'Benin'], ['is_enabled' => false, 'code' => 'BM', 'name' => 'Bermuda'], ['is_enabled' => false, 'code' => 'BT', 'name' => 'Bhutan'], ['is_enabled' => false, 'code' => 'BO', 'name' => 'Bolivia, Plurinational State of'], ['is_enabled' => false, 'code' => 'BQ', 'name' => 'Bonaire, Sint Eustatius and Saba'], ['is_enabled' => false, 'code' => 'BA', 'name' => 'Bosnia and Herzegovina'], ['is_enabled' => false, 'code' => 'BW', 'name' => 'Botswana'], ['is_enabled' => false, 'code' => 'BV', 'name' => 'Bouvet Island'], ['is_enabled' => false, 'code' => 'BR', 'name' => 'Brazil'], ['is_enabled' => false, 'code' => 'IO', 'name' => 'British Indian Ocean Territory'], ['is_enabled' => false, 'code' => 'BN', 'name' => 'Brunei Darussalam'], ['is_enabled' => false, 'code' => 'BG', 'name' => 'Bulgaria'], ['is_enabled' => false, 'code' => 'BF', 'name' => 'Burkina Faso'], ['is_enabled' => false, 'code' => 'BI', 'name' => 'Burundi'], ['is_enabled' => false, 'code' => 'KH', 'name' => 'Cambodia'], ['is_enabled' => false, 'code' => 'CM', 'name' => 'Cameroon'], ['is_enabled' => false, 'code' => 'CV', 'name' => 'Cape Verde'], ['is_enabled' => false, 'code' => 'KY', 'name' => 'Cayman Islands'], ['is_enabled' => false, 'code' => 'CF', 'name' => 'Central African Republic'], ['is_enabled' => false, 'code' => 'TD', 'name' => 'Chad'], ['is_enabled' => false, 'code' => 'CL', 'name' => 'Chile'], ['is_enabled' => false, 'code' => 'CN', 'name' => 'China'], ['is_enabled' => false, 'code' => 'CX', 'name' => 'Christmas Island'], ['is_enabled' => false, 'code' => 'CC', 'name' => 'Cocos (Keeling) Islands'], ['is_enabled' => false, 'code' => 'CO', 'name' => 'Colombia'], ['is_enabled' => false, 'code' => 'KM', 'name' => 'Comoros'], ['is_enabled' => false, 'code' => 'CG', 'name' => 'Congo'], ['is_enabled' => false, 'code' => 'CD', 'name' => 'Congo, the Democratic Republic of the'], ['is_enabled' => false, 'code' => 'CK', 'name' => 'Cook Islands'], ['is_enabled' => false, 'code' => 'CR', 'name' => 'Costa Rica'], ['is_enabled' => false, 'code' => 'CI', 'name' => 'Cote d\'Ivoire'], ['is_enabled' => false, 'code' => 'HR', 'name' => 'Croatia'], ['is_enabled' => false, 'code' => 'CU', 'name' => 'Cuba'], ['is_enabled' => false, 'code' => 'CW', 'name' => 'Curaçao'], ['is_enabled' => false, 'code' => 'CY', 'name' => 'Cyprus'], ['is_enabled' => false, 'code' => 'DJ', 'name' => 'Djibouti'], ['is_enabled' => false, 'code' => 'DM', 'name' => 'Dominica'], ['is_enabled' => false, 'code' => 'DO', 'name' => 'Dominican Republic'], ['is_enabled' => false, 'code' => 'EC', 'name' => 'Ecuador'], ['is_enabled' => false, 'code' => 'EG', 'name' => 'Egypt'], ['is_enabled' => false, 'code' => 'SV', 'name' => 'El Salvador'], ['is_enabled' => false, 'code' => 'GQ', 'name' => 'Equatorial Guinea'], ['is_enabled' => false, 'code' => 'ER', 'name' => 'Eritrea'], ['is_enabled' => false, 'code' => 'EE', 'name' => 'Estonia'], ['is_enabled' => false, 'code' => 'ET', 'name' => 'Ethiopia'], ['is_enabled' => false, 'code' => 'FK', 'name' => 'Falkland Islands (Malvinas)'], ['is_enabled' => false, 'code' => 'FO', 'name' => 'Faroe Islands'], ['is_enabled' => false, 'code' => 'FJ', 'name' => 'Fiji'], ['is_enabled' => false, 'code' => 'GF', 'name' => 'French Guiana'], ['is_enabled' => false, 'code' => 'PF', 'name' => 'French Polynesia'], ['is_enabled' => false, 'code' => 'TF', 'name' => 'French Southern Territories'], ['is_enabled' => false, 'code' => 'GA', 'name' => 'Gabon'], ['is_enabled' => false, 'code' => 'GM', 'name' => 'Gambia'], ['is_enabled' => false, 'code' => 'GE', 'name' => 'Georgia'], ['is_enabled' => false, 'code' => 'GH', 'name' => 'Ghana'], ['is_enabled' => false, 'code' => 'GI', 'name' => 'Gibraltar'], ['is_enabled' => false, 'code' => 'GR', 'name' => 'Greece'], ['is_enabled' => false, 'code' => 'GL', 'name' => 'Greenland'], ['is_enabled' => false, 'code' => 'GD', 'name' => 'Grenada'], ['is_enabled' => false, 'code' => 'GP', 'name' => 'Guadeloupe'], ['is_enabled' => false, 'code' => 'GU', 'name' => 'Guam'], ['is_enabled' => false, 'code' => 'GT', 'name' => 'Guatemala'], ['is_enabled' => false, 'code' => 'GG', 'name' => 'Guernsey'], ['is_enabled' => false, 'code' => 'GN', 'name' => 'Guinea'], ['is_enabled' => false, 'code' => 'GW', 'name' => 'Guinea-Bissau'], ['is_enabled' => false, 'code' => 'GY', 'name' => 'Guyana'], ['is_enabled' => false, 'code' => 'HT', 'name' => 'Haiti'], ['is_enabled' => false, 'code' => 'HM', 'name' => 'Heard Island and McDonald Islands'], ['is_enabled' => false, 'code' => 'VA', 'name' => 'Holy See (Vatican City State)'], ['is_enabled' => false, 'code' => 'HN', 'name' => 'Honduras'], ['is_enabled' => false, 'code' => 'HK', 'name' => 'Hong Kong'], ['is_enabled' => false, 'code' => 'HU', 'name' => 'Hungary'], ['is_enabled' => false, 'code' => 'IN', 'name' => 'India'], ['is_enabled' => false, 'code' => 'ID', 'name' => 'Indonesia'], ['is_enabled' => false, 'code' => 'IR', 'name' => 'Iran, Islamic Republic of'], ['is_enabled' => false, 'code' => 'IQ', 'name' => 'Iraq'], ['is_enabled' => false, 'code' => 'IL', 'name' => 'Israel'], ['is_enabled' => false, 'code' => 'JM', 'name' => 'Jamaica'], ['is_enabled' => false, 'code' => 'JP', 'name' => 'Japan'], ['is_enabled' => false, 'code' => 'JE', 'name' => 'Jersey'], ['is_enabled' => false, 'code' => 'JO', 'name' => 'Jordan'], ['is_enabled' => false, 'code' => 'KZ', 'name' => 'Kazakhstan'], ['is_enabled' => false, 'code' => 'KE', 'name' => 'Kenya'], ['is_enabled' => false, 'code' => 'KI', 'name' => 'Kiribati'], ['is_enabled' => false, 'code' => 'KP', 'name' => 'Korea, Democratic People\'s Republic of'], ['is_enabled' => false, 'code' => 'KR', 'name' => 'Korea, Republic of'], ['is_enabled' => false, 'code' => 'KW', 'name' => 'Kuwait'], ['is_enabled' => false, 'code' => 'KG', 'name' => 'Kyrgyzstan'], ['is_enabled' => false, 'code' => 'LA', 'name' => 'Lao People\'s Democratic Republic'], ['is_enabled' => false, 'code' => 'LV', 'name' => 'Latvia'], ['is_enabled' => false, 'code' => 'LB', 'name' => 'Lebanon'], ['is_enabled' => false, 'code' => 'LS', 'name' => 'Lesotho'], ['is_enabled' => false, 'code' => 'LR', 'name' => 'Liberia'], ['is_enabled' => false, 'code' => 'LY', 'name' => 'Libyan Arab Jamahiriya'], ['is_enabled' => false, 'code' => 'LI', 'name' => 'Liechtenstein'], ['is_enabled' => false, 'code' => 'LT', 'name' => 'Lithuania'], ['is_enabled' => false, 'code' => 'LU', 'name' => 'Luxembourg'], ['is_enabled' => false, 'code' => 'MO', 'name' => 'Macao'], ['is_enabled' => false, 'code' => 'MK', 'name' => 'Macedonia'], ['is_enabled' => false, 'code' => 'MG', 'name' => 'Madagascar'], ['is_enabled' => false, 'code' => 'MW', 'name' => 'Malawi'], ['is_enabled' => false, 'code' => 'MY', 'name' => 'Malaysia'], ['is_enabled' => false, 'code' => 'MV', 'name' => 'Maldives'], ['is_enabled' => false, 'code' => 'ML', 'name' => 'Mali'], ['is_enabled' => false, 'code' => 'MT', 'name' => 'Malta'], ['is_enabled' => false, 'code' => 'MH', 'name' => 'Marshall Islands'], ['is_enabled' => false, 'code' => 'MQ', 'name' => 'Martinique'], ['is_enabled' => false, 'code' => 'MR', 'name' => 'Mauritania'], ['is_enabled' => false, 'code' => 'MU', 'name' => 'Mauritius'], ['is_enabled' => false, 'code' => 'YT', 'name' => 'Mayotte'], ['is_enabled' => false, 'code' => 'MX', 'name' => 'Mexico'], ['is_enabled' => false, 'code' => 'FM', 'name' => 'Micronesia, Federated States of'], ['is_enabled' => false, 'code' => 'MD', 'name' => 'Moldova, Republic of'], ['is_enabled' => false, 'code' => 'MC', 'name' => 'Monaco'], ['is_enabled' => false, 'code' => 'MN', 'name' => 'Mongolia'], ['is_enabled' => false, 'code' => 'ME', 'name' => 'Montenegro'], ['is_enabled' => false, 'code' => 'MS', 'name' => 'Montserrat'], ['is_enabled' => false, 'code' => 'MA', 'name' => 'Morocco'], ['is_enabled' => false, 'code' => 'MZ', 'name' => 'Mozambique'], ['is_enabled' => false, 'code' => 'MM', 'name' => 'Myanmar'], ['is_enabled' => false, 'code' => 'NA', 'name' => 'Namibia'], ['is_enabled' => false, 'code' => 'NR', 'name' => 'Nauru'], ['is_enabled' => false, 'code' => 'NP', 'name' => 'Nepal'], ['is_enabled' => false, 'code' => 'NC', 'name' => 'New Caledonia'], ['is_enabled' => false, 'code' => 'NI', 'name' => 'Nicaragua'], ['is_enabled' => false, 'code' => 'NE', 'name' => 'Niger'], ['is_enabled' => false, 'code' => 'NG', 'name' => 'Nigeria'], ['is_enabled' => false, 'code' => 'NU', 'name' => 'Niue'], ['is_enabled' => false, 'code' => 'NF', 'name' => 'Norfolk Island'], ['is_enabled' => false, 'code' => 'MP', 'name' => 'Northern Mariana Islands'], ['is_enabled' => false, 'code' => 'OM', 'name' => 'Oman'], ['is_enabled' => false, 'code' => 'PK', 'name' => 'Pakistan'], ['is_enabled' => false, 'code' => 'PW', 'name' => 'Palau'], ['is_enabled' => false, 'code' => 'PS', 'name' => 'Palestinian Territory, Occupied'], ['is_enabled' => false, 'code' => 'PA', 'name' => 'Panama'], ['is_enabled' => false, 'code' => 'PG', 'name' => 'Papua New Guinea'], ['is_enabled' => false, 'code' => 'PY', 'name' => 'Paraguay'], ['is_enabled' => false, 'code' => 'PE', 'name' => 'Peru'], ['is_enabled' => false, 'code' => 'PH', 'name' => 'Philippines'], ['is_enabled' => false, 'code' => 'PN', 'name' => 'Pitcairn'], ['is_enabled' => false, 'code' => 'PL', 'name' => 'Poland'], ['is_enabled' => false, 'code' => 'PR', 'name' => 'Puerto Rico'], ['is_enabled' => false, 'code' => 'QA', 'name' => 'Qatar'], ['is_enabled' => false, 'code' => 'RE', 'name' => 'Reunion'], ['is_enabled' => false, 'code' => 'RO', 'name' => 'Romania'], ['is_enabled' => false, 'code' => 'RW', 'name' => 'Rwanda'], ['is_enabled' => false, 'code' => 'BL', 'name' => 'Saint Barthélemy'], ['is_enabled' => false, 'code' => 'SH', 'name' => 'Saint Helena'], ['is_enabled' => false, 'code' => 'KN', 'name' => 'Saint Kitts and Nevis'], ['is_enabled' => false, 'code' => 'LC', 'name' => 'Saint Lucia'], ['is_enabled' => false, 'code' => 'MF', 'name' => 'Saint Martin (French part)'], ['is_enabled' => false, 'code' => 'PM', 'name' => 'Saint Pierre and Miquelon'], ['is_enabled' => false, 'code' => 'VC', 'name' => 'Saint Vincent and the Grenadines'], ['is_enabled' => false, 'code' => 'WS', 'name' => 'Samoa'], ['is_enabled' => false, 'code' => 'SM', 'name' => 'San Marino'], ['is_enabled' => false, 'code' => 'ST', 'name' => 'Sao Tome and Principe'], ['is_enabled' => false, 'code' => 'SA', 'name' => 'Saudi Arabia'], ['is_enabled' => false, 'code' => 'SN', 'name' => 'Senegal'], ['is_enabled' => false, 'code' => 'RS', 'name' => 'Serbia'], ['is_enabled' => false, 'code' => 'SC', 'name' => 'Seychelles'], ['is_enabled' => false, 'code' => 'SL', 'name' => 'Sierra Leone'], ['is_enabled' => false, 'code' => 'SG', 'name' => 'Singapore'], ['is_enabled' => false, 'code' => 'SX', 'name' => 'Sint Maarten (Dutch part)'], ['is_enabled' => false, 'code' => 'SK', 'name' => 'Slovakia'], ['is_enabled' => false, 'code' => 'SI', 'name' => 'Slovenia'], ['is_enabled' => false, 'code' => 'SB', 'name' => 'Solomon Islands'], ['is_enabled' => false, 'code' => 'SO', 'name' => 'Somalia'], ['is_enabled' => false, 'code' => 'ZA', 'name' => 'South Africa'], ['is_enabled' => false, 'code' => 'GS', 'name' => 'South Georgia and the South Sandwich Islands'], ['is_enabled' => false, 'code' => 'LK', 'name' => 'Sri Lanka'], ['is_enabled' => false, 'code' => 'SD', 'name' => 'Sudan'], ['is_enabled' => false, 'code' => 'SR', 'name' => 'Suriname'], ['is_enabled' => false, 'code' => 'SJ', 'name' => 'Svalbard and Jan Mayen'], ['is_enabled' => false, 'code' => 'SZ', 'name' => 'Swaziland'], ['is_enabled' => false, 'code' => 'SY', 'name' => 'Syrian Arab Republic'], ['is_enabled' => false, 'code' => 'TW', 'name' => 'Taiwan, Province of China'], ['is_enabled' => false, 'code' => 'TJ', 'name' => 'Tajikistan'], ['is_enabled' => false, 'code' => 'TZ', 'name' => 'Tanzania, United Republic of'], ['is_enabled' => false, 'code' => 'TH', 'name' => 'Thailand'], ['is_enabled' => false, 'code' => 'TL', 'name' => 'Timor-Leste'], ['is_enabled' => false, 'code' => 'TG', 'name' => 'Togo'], ['is_enabled' => false, 'code' => 'TK', 'name' => 'Tokelau'], ['is_enabled' => false, 'code' => 'TO', 'name' => 'Tonga'], ['is_enabled' => false, 'code' => 'TT', 'name' => 'Trinidad and Tobago'], ['is_enabled' => false, 'code' => 'TN', 'name' => 'Tunisia'], ['is_enabled' => false, 'code' => 'TR', 'name' => 'Turkey'], ['is_enabled' => false, 'code' => 'TM', 'name' => 'Turkmenistan'], ['is_enabled' => false, 'code' => 'TC', 'name' => 'Turks and Caicos Islands'], ['is_enabled' => false, 'code' => 'TV', 'name' => 'Tuvalu'], ['is_enabled' => false, 'code' => 'UG', 'name' => 'Uganda'], ['is_enabled' => false, 'code' => 'UA', 'name' => 'Ukraine'], ['is_enabled' => false, 'code' => 'AE', 'name' => 'United Arab Emirates'], ['is_enabled' => false, 'code' => 'UM', 'name' => 'United States Minor Outlying Islands'], ['is_enabled' => false, 'code' => 'UY', 'name' => 'Uruguay'], ['is_enabled' => false, 'code' => 'UZ', 'name' => 'Uzbekistan'], ['is_enabled' => false, 'code' => 'VU', 'name' => 'Vanuatu'], ['is_enabled' => false, 'code' => 'VE', 'name' => 'Venezuela, Bolivarian Republic of'], ['is_enabled' => false, 'code' => 'VN', 'name' => 'Viet Nam'], ['is_enabled' => false, 'code' => 'VG', 'name' => 'Virgin Islands, British'], ['is_enabled' => false, 'code' => 'VI', 'name' => 'Virgin Islands, U.S.'], ['is_enabled' => false, 'code' => 'WF', 'name' => 'Wallis and Futuna'], ['is_enabled' => false, 'code' => 'EH', 'name' => 'Western Sahara'], ['is_enabled' => false, 'code' => 'YE', 'name' => 'Yemen'], ['is_enabled' => false, 'code' => 'ZM', 'name' => 'Zambia'], ['is_enabled' => false, 'code' => 'ZW', 'name' => 'Zimbabwe']]);
$us = Country::whereCode('US')->first();
$us->states()->createMany([['code' => 'AL', 'name' => 'Alabama'], ['code' => 'AK', 'name' => 'Alaska'], ['code' => 'AS', 'name' => 'American Samoa'], ['code' => 'AZ', 'name' => 'Arizona'], ['code' => 'AR', 'name' => 'Arkansas'], ['code' => 'CA', 'name' => 'California'], ['code' => 'CO', 'name' => 'Colorado'], ['code' => 'CT', 'name' => 'Connecticut'], ['code' => 'DE', 'name' => 'Delaware'], ['code' => 'DC', 'name' => 'Dist. of Columbia'], ['code' => 'FL', 'name' => 'Florida'], ['code' => 'GA', 'name' => 'Georgia'], ['code' => 'GU', 'name' => 'Guam'], ['code' => 'HI', 'name' => 'Hawaii'], ['code' => 'ID', 'name' => 'Idaho'], ['code' => 'IL', 'name' => 'Illinois'], ['code' => 'IN', 'name' => 'Indiana'], ['code' => 'IA', 'name' => 'Iowa'], ['code' => 'KS', 'name' => 'Kansas'], ['code' => 'KY', 'name' => 'Kentucky'], ['code' => 'LA', 'name' => 'Louisiana'], ['code' => 'ME', 'name' => 'Maine'], ['code' => 'MD', 'name' => 'Maryland'], ['code' => 'MH', 'name' => 'Marshall Islands'], ['code' => 'MA', 'name' => 'Massachusetts'], ['code' => 'MI', 'name' => 'Michigan'], ['code' => 'FM', 'name' => 'Micronesia'], ['code' => 'MN', 'name' => 'Minnesota'], ['code' => 'MS', 'name' => 'Mississippi'], ['code' => 'MO', 'name' => 'Missouri'], ['code' => 'MT', 'name' => 'Montana'], ['code' => 'NE', 'name' => 'Nebraska'], ['code' => 'NV', 'name' => 'Nevada'], ['code' => 'NH', 'name' => 'New Hampshire'], ['code' => 'NJ', 'name' => 'New Jersey'], ['code' => 'NM', 'name' => 'New Mexico'], ['code' => 'NY', 'name' => 'New York'], ['code' => 'NC', 'name' => 'North Carolina'], ['code' => 'ND', 'name' => 'North Dakota'], ['code' => 'MP', 'name' => 'Northern Marianas'], ['code' => 'OH', 'name' => 'Ohio'], ['code' => 'OK', 'name' => 'Oklahoma'], ['code' => 'OR', 'name' => 'Oregon'], ['code' => 'PW', 'name' => 'Palau'], ['code' => 'PA', 'name' => 'Pennsylvania'], ['code' => 'PR', 'name' => 'Puerto Rico'], ['code' => 'RI', 'name' => 'Rhode Island'], ['code' => 'SC', 'name' => 'South Carolina'], ['code' => 'SD', 'name' => 'South Dakota'], ['code' => 'TN', 'name' => 'Tennessee'], ['code' => 'TX', 'name' => 'Texas'], ['code' => 'UT', 'name' => 'Utah'], ['code' => 'VT', 'name' => 'Vermont'], ['code' => 'VA', 'name' => 'Virginia'], ['code' => 'VI', 'name' => 'Virgin Islands'], ['code' => 'WA', 'name' => 'Washington'], ['code' => 'WV', 'name' => 'West Virginia'], ['code' => 'WI', 'name' => 'Wisconsin'], ['code' => 'WY', 'name' => 'Wyoming']]);
$ca = Country::whereCode('CA')->first();
$ca->states()->createMany([['code' => 'AB', 'name' => 'Alberta'], ['code' => 'BC', 'name' => 'British Columbia'], ['code' => 'MB', 'name' => 'Manitoba'], ['code' => 'NB', 'name' => 'New Brunswick'], ['code' => 'NL', 'name' => 'Newfoundland and Labrador'], ['code' => 'NT', 'name' => 'Northwest Territories'], ['code' => 'NS', 'name' => 'Nova Scotia'], ['code' => 'NU', 'name' => 'Nunavut'], ['code' => 'ON', 'name' => 'Ontario'], ['code' => 'PE', 'name' => 'Prince Edward Island'], ['code' => 'QC', 'name' => 'Quebec'], ['code' => 'SK', 'name' => 'Saskatchewan'], ['code' => 'YT', 'name' => 'Yukon']]);
$au = Country::whereCode('AU')->first();
$au->states()->createMany([['code' => 'NSW', 'name' => 'New South Wales'], ['code' => 'QLD', 'name' => 'Queensland'], ['code' => 'SA', 'name' => 'South Australia'], ['code' => 'TAS', 'name' => 'Tasmania'], ['code' => 'VIC', 'name' => 'Victoria'], ['code' => 'WA', 'name' => 'Western Australia'], ['code' => 'NT', 'name' => 'Northern Territory'], ['code' => 'ACT', 'name' => 'Australian Capital Territory']]);
$de = Country::whereCode('DE')->first();
$de->states()->createMany([['code' => 'BW', 'name' => 'Baden-Württemberg'], ['code' => 'BY', 'name' => 'Bavaria'], ['code' => 'BE', 'name' => 'Berlin'], ['code' => 'BB', 'name' => 'Brandenburg'], ['code' => 'HB', 'name' => 'Bremen'], ['code' => 'HH', 'name' => 'Hamburg'], ['code' => 'HE', 'name' => 'Hesse'], ['code' => 'MV', 'name' => 'Mecklenburg-Vorpommern'], ['code' => 'NI', 'name' => 'Lower Saxony'], ['code' => 'NW', 'name' => 'North Rhine-Westphalia'], ['code' => 'RP', 'name' => 'Rhineland-Palatinate'], ['code' => 'SL', 'name' => 'Saarland'], ['code' => 'SN', 'name' => 'Saxony'], ['code' => 'ST', 'name' => 'Saxony-Anhalt'], ['code' => 'SH', 'name' => 'Schleswig-Holstein'], ['code' => 'TH', 'name' => 'Thuringia']]);
$ie = Country::whereCode('IE')->first();
$ie->states()->createMany([['code' => 'D', 'name' => 'Dublin'], ['code' => 'WW', 'name' => 'Wicklow'], ['code' => 'WX', 'name' => 'Wexford'], ['code' => 'CW', 'name' => 'Carlow'], ['code' => 'KE', 'name' => 'Kildare'], ['code' => 'MH', 'name' => 'Meath'], ['code' => 'LH', 'name' => 'Louth'], ['code' => 'MN', 'name' => 'Monaghan'], ['code' => 'CN', 'name' => 'Cavan'], ['code' => 'LD', 'name' => 'Longford'], ['code' => 'WH', 'name' => 'Westmeath'], ['code' => 'OY', 'name' => 'Offaly'], ['code' => 'LS', 'name' => 'Laois'], ['code' => 'KK', 'name' => 'Kilkenny'], ['code' => 'WD', 'name' => 'Waterford'], ['code' => 'C', 'name' => 'Cork'], ['code' => 'KY', 'name' => 'Kerry'], ['code' => 'LK', 'name' => 'Limerick'], ['code' => 'TN', 'name' => 'North Tipperary'], ['code' => 'TS', 'name' => 'South Tipperary'], ['code' => 'CE', 'name' => 'Clare'], ['code' => 'G', 'name' => 'Galway'], ['code' => 'MO', 'name' => 'Mayo'], ['code' => 'RN', 'name' => 'Roscommon'], ['code' => 'SO', 'name' => 'Sligo'], ['code' => 'LM', 'name' => 'Leitrim'], ['code' => 'DL', 'name' => 'Donegal']]);
$nl = Country::whereCode('NL')->first();
$nl->states()->createMany([['code' => 'DR', 'name' => 'Drenthe'], ['code' => 'FL', 'name' => 'Flevoland'], ['code' => 'FR', 'name' => 'Friesland'], ['code' => 'GE', 'name' => 'Gelderland'], ['code' => 'GR', 'name' => 'Groningen'], ['code' => 'LI', 'name' => 'Limburg'], ['code' => 'NB', 'name' => 'Noord-Brabant'], ['code' => 'NH', 'name' => 'Noord-Holland'], ['code' => 'OV', 'name' => 'Overijssel'], ['code' => 'UT', 'name' => 'Utrecht'], ['code' => 'ZE', 'name' => 'Zeeland'], ['code' => 'ZH', 'name' => 'Zuid-Holland']]);
$gb = Country::whereCode('GB')->first();
$gb->states()->createMany([["name" => "Aberdeenshire", "code" => "ABE"], ["name" => "Anglesey", "code" => "ALY"], ["name" => "Angus", "code" => "ANG"], ["name" => "Argyll", "code" => "ARG"], ["name" => "Ayrshire", "code" => "AYR"], ["name" => "Banffshire", "code" => "BAN"], ["name" => "Bedfordshire", "code" => "BED"], ["name" => "Berkshire", "code" => "BER"], ["name" => "Berwickshire", "code" => "BWS"], ["name" => "Brecknockshire", "code" => "BRE"], ["name" => "Buckinghamshire", "code" => "BUC"], ["name" => "Bute", "code" => "BUT"], ["name" => "Caernarfonshire", "code" => "CAE"], ["name" => "Caithness", "code" => "CAI"], ["name" => "Cambridgeshire", "code" => "CAM"], ["name" => "Cardiganshire", "code" => "CAR"], ["name" => "Carmarthenshire", "code" => "CMS"], ["name" => "Cheshire", "code" => "CHE"], ["name" => "Clackmannanshire", "code" => "CLA"], ["name" => "Cleveland", "code" => "CLE"], ["name" => "Cornwall", "code" => "COR"], ["name" => "Cromartyshire", "code" => "CRO"], ["name" => "Cumberland", "code" => "CBR"], ["name" => "Cumbria", "code" => "CUM"], ["name" => "Denbighshire", "code" => "DEN"], ["name" => "Derbyshire", "code" => "DER"], ["name" => "Devon", "code" => "DEV"], ["name" => "Dorset", "code" => "DOR"], ["name" => "Dumbartonshire", "code" => "DBS"], ["name" => "Dumfriesshire", "code" => "DUM"], ["name" => "Durham", "code" => "DUR"], ["name" => "East Lothian", "code" => "ELO"], ["name" => "Essex", "code" => "ESS"], ["name" => "Flintshire", "code" => "FLI"], ["name" => "Fife", "code" => "FIF"], ["name" => "Glamorgan", "code" => "GLA"], ["name" => "Gloucestershire", "code" => "GLO"], ["name" => "Hampshire", "code" => "HAM"], ["name" => "Herefordshire", "code" => "HER"], ["name" => "Hertfordshire", "code" => "HTF"], ["name" => "Huntingdonshire", "code" => "HUN"], ["name" => "Inverness", "code" => "INV"], ["name" => "Kent", "code" => "KEN"], ["name" => "Kincardineshire", "code" => "KCD"], ["name" => "Kinross-shire", "code" => "KIN"], ["name" => "Kirkcudbrightshire", "code" => "KIR"], ["name" => "Lanarkshire", "code" => "LKS"], ["name" => "Lancashire", "code" => "LAN"], ["name" => "Leicestershire", "code" => "LEI"], ["name" => "Lincolnshire", "code" => "LIN"], ["name" => "London", "code" => "LON"], ["name" => "Manchester", "code" => "MAN"], ["name" => "Merionethshire", "code" => "MER"], ["name" => "Merseyside", "code" => "MER"], ["name" => "Middlesex", "code" => "MDX"], ["name" => "Midlands", "code" => "MID"], ["name" => "Midlothian", "code" => "MLT"], ["name" => "Monmouthshire", "code" => "MON"], ["name" => "Montgomeryshire", "code" => "MGY"], ["name" => "Moray", "code" => "MOR"], ["name" => "Nairnshire", "code" => "NAI"], ["name" => "Norfolk", "code" => "NOR"], ["name" => "Northamptonshire", "code" => "NMP"], ["name" => "Northumberland", "code" => "NUM"], ["name" => "Nottinghamshire", "code" => "NOT"], ["name" => "Orkney", "code" => "ORK"], ["name" => "Oxfordshire", "code" => "OXF"], ["name" => "Peebleshire", "code" => "PEE"], ["name" => "Pembrokeshire", "code" => "PEM"], ["name" => "Perthshire", "code" => "PER"], ["name" => "Radnorshire", "code" => "RAD"], ["name" => "Renfrewshire", "code" => "REN"], ["name" => "Ross & Cromarty", "code" => "ROS"], ["name" => "Roxburghshire", "code" => "ROX"], ["name" => "Rutland", "code" => "RUT"], ["name" => "Selkirkshire", "code" => "SEL"], ["name" => "Shetland", "code" => "SHE"], ["name" => "Shropshire", "code" => "SHR"], ["name" => "Somerset", "code" => "SOM"], ["name" => "Staffordshire", "code" => "STA"], ["name" => "Stirlingshire", "code" => "STI"], ["name" => "Suffolk", "code" => "SUF"], ["name" => "Surrey", "code" => "SUR"], ["name" => "Sussex", "code" => "SUS"], ["name" => "Sutherland", "code" => "SUT"], ["name" => "Tyne & Wear", "code" => "TYN"], ["name" => "Warwickshire", "code" => "WAR"], ["name" => "West Lothian", "code" => "WLO"], ["name" => "Westmorland", "code" => "WES"], ["name" => "Wigtownshire", "code" => "WIG"], ["name" => "Wiltshire", "code" => "WIL"], ["name" => "Worcestershire", "code" => "WOR"], ["name" => "Yorkshire", "code" => "YOR"]]);
}
public function onDisableLocations()
{
$enable = post('enable', false);
if (($checkedIds = post('checked')) && is_array($checkedIds) && count($checkedIds)) {
foreach ($checkedIds as $objectId) {
if (!($object = Country::find($objectId))) {
continue;
}
$object->is_enabled = $enable;
$object->save();
}
}
if ($enable) {
Flash::success(Lang::get('rainlab.user::lang.locations.enable_success'));
} else {
Flash::success(Lang::get('rainlab.user::lang.locations.disable_success'));
}
return Redirect::to(Backend::url('rainlab/user/locations'));
}
public function getCountryOptions()
{
return Country::getNameList();
}
/**
* Returns rate information for a given location, optionally ignoring by priority.
* @param array $locationInfo
* @param array $ignoredPriorities
* @return object
*/
protected function getRate($locationInfo, $ignoredPriorities = [])
{
$country = Country::find($locationInfo->country_id);
if (!$country) {
return null;
}
$state = null;
if (strlen($locationInfo->state_id)) {
$state = State::find($locationInfo->state_id);
}
$countryCode = $country->code;
$stateCode = $state ? mb_strtoupper($state->code) : '*';
$zipCode = str_replace(' ', '', trim(strtoupper($locationInfo->zip)));
if (!strlen($zipCode)) {
$zipCode = '*';
}
$city = str_replace('-', '', str_replace(' ', '', trim(mb_strtoupper($locationInfo->city))));
if (!strlen($city)) {
$city = '*';
}
$rate = null;
foreach ($this->rates as $row) {
$taxPriority = isset($row['priority']) ? $row['priority'] : 1;
if (in_array($taxPriority, $ignoredPriorities)) {
continue;
}
if ($row['country'] != $countryCode && $row['country'] != '*') {
continue;
}
if (mb_strtoupper($row['state']) != $stateCode && $row['state'] != '*') {
continue;
}
$rowZip = isset($row['zip']) && strlen($row['zip']) ? str_replace(' ', '', $row['zip']) : '*';
if ($rowZip != $zipCode && $rowZip != '*') {
continue;
}
$rowCity = isset($row['city']) && strlen($row['city']) ? str_replace('-', '', str_replace(' ', '', mb_strtoupper($row['city']))) : '*';
if ($rowCity != $city && $rowCity != '*') {
continue;
}
$compound = isset($row['compound']) ? $row['compound'] : 0;
if (preg_match('/^[0-9]+$/', $compound)) {
$compound = (int) $compound;
} else {
$compound = $compound == 'Y' || $compound == 'YES';
}
$rateObj = ['rate' => $row['rate'], 'priority' => $taxPriority, 'name' => isset($row['tax_name']) ? $row['tax_name'] : 'TAX', 'compound' => $compound];
$rate = (object) $rateObj;
break;
}
return $rate;
}
FactoryMuffin::define('DMA\\Friends\\Models\\Activity', ['title' => 'sentence', 'description' => 'optional:text', 'excerpt' => 'optional:text', 'points' => 'randomNumber|4', 'image' => 'optional:imageUrl|400;600', 'activity_code' => 'randomLetter|3', 'activity_lockout' => 'randomDigitNotNull|4', 'time_restriction' => 'randomNumber|2', 'is_published' => 'boolean', 'is_archived' => 'boolean', 'created_at' => 'dateTime|now', 'date_begin' => 'optional:dateTime', 'date_end' => 'optional:dateTime', 'categories' => 'factory|DMA\\Friends\\Models\\Category']);
FactoryMuffin::define('DMA\\Friends\\Models\\ActivityLog', ['user_id' => 'factory|RainLab\\User\\Models\\User', 'action' => function ($object, $saved) {
$activityLog = new ActivityLog();
$types = $activityLog->actionTypes;
$rand = rand(0, count($types) - 1);
return $types[$rand];
}, 'message' => 'text', 'object_type' => 'optional:randomLetter|3', 'object_id' => 'optional:randomDigit', 'points_earned' => 'randomNumber', 'total_points' => 'randomNumber', 'timestamp' => 'dateTime|now', 'timezone' => 'timezone']);
FactoryMuffin::define('DMA\\Friends\\Models\\Badge', ['title' => 'sentence', 'description' => 'optional:text', 'image' => 'optional:imageUrl|400;600', 'excerpt' => 'optional:text', 'congratulations_text' => 'optional:text', 'points' => 'randomNumber|3', 'maximum_earnings' => 'randomNumber|3', 'steps' => 'factory|DMA\\Friends\\Models\\Step', 'is_sequential' => 'boolean', 'show_earners' => 'boolean', 'time_between_steps_min' => 'randomDigitNotNull|8', 'time_between_steps_max' => 'randomDigitNotNull|8', 'maximium_time' => 'randomDigitNotNull|2', 'date_begin' => 'optional:dateTime', 'date_end' => 'optional:dateTime', 'is_published' => 'boolean', 'is_archived' => 'boolean', 'created_at' => 'dateTime|now', 'categories' => 'factory|DMA\\Friends\\Models\\Category']);
FactoryMuffin::define('DMA\\Friends\\Models\\Category', ['name' => 'word', 'description' => 'optional:text', 'slug' => function ($object, $saved) {
return Str::slug($object->title);
}]);
FactoryMuffin::define('DMA\\Friends\\Models\\Location', ['title' => 'word', 'description' => 'optional:text', 'created_at' => 'dateTime|now']);
FactoryMuffin::define('DMA\\Friends\\Models\\Reward', ['title' => 'sentence', 'description' => 'optional:text', 'excerpt' => 'optional:text', 'fine_print' => 'optional:text', 'points' => 'randomDigitNotNull', 'image' => 'optional:imageUrl|400;600', 'barcode' => 'randomLetter|3', 'date_begin' => 'optional:dateTime', 'date_end' => 'optional:dateTime', 'days_valid' => 'optional:randomDigit|2', 'inventory' => 'optional:randomDigit|3', 'enable_email' => 'boolean', 'redemption_email' => 'optional:text', 'is_published' => 'boolean', 'is_archived' => 'boolean', 'hidden' => 'boolean', 'created_at' => 'dateTime|now']);
FactoryMuffin::define('DMA\\Friends\\Models\\Step', ['title' => 'sentence', 'created_at' => 'dateTime|now', 'updated_at' => 'dateTime|now']);
FactoryMuffin::define('RainLab\\User\\Models\\User', ['name' => 'userName', 'username' => 'userName', 'email' => 'email', 'password' => 'password', 'password_confirmation' => 'password', 'is_activated' => 'boolean', 'activated_at' => 'dateTime', 'last_login' => 'dateTime', 'country' => function ($object, $saved) {
return Country::orderByRaw('RAND()')->first();
}, 'state' => function ($object, $saved) {
return State::orderByRaw('RAND()')->first();
}, 'created_at' => 'dateTime|now', 'updated_at' => 'dateTime|now', 'phone' => 'optional:phone', 'company' => 'optional:company', 'street_addr' => 'streetAddress', 'city' => 'city', 'zip' => 'postcode', 'points' => 'randomNumber']);
FactoryMuffin::define('DMA\\Friends\\Models\\Usermeta', ['first_name' => 'firstName', 'last_name' => 'lastName', 'email_optin' => 'boolean', 'current_member' => 'boolean', 'current_member_number' => 'randomNumber']);
/**
* Create and empty group
* @var DMA\Friends\Models\UserGroup
*/
FactoryMuffin::define('DMA\\Friends\\Models\\UserGroup', ['owner_id' => 'factory|RainLab\\User\\Models\\User', 'is_active' => 'boolean|100']);
/**
* Create a group with the maxium of members allow in a group.
* The limit is set in the settings of the plugin
* @var DMA\Friends\Models\UserGroup
*/
FactoryMuffin::define('filled:DMA\\Friends\\Models\\UserGroup', [], function ($object) {
/**
* Returns the province based on the country value @var $address_country.
* @param string $address_country.
* @return array
*/
private function __addressProvince($address_country)
{
$output = [];
$country = \RainLab\User\Models\Country::whereCode($address_country)->first();
if ($country and $country->is_enabled) {
foreach ($country->states as $state) {
$output[$state->code] = trans($state->name);
}
}
return $output;
}
/**
* Updates and save the metadata for a user object
*/
public function updateMetadata(OctoberUser $user, $wordpressId)
{
$metadata = $this->db->table('wp_usermeta')->where('user_id', $wordpressId)->get();
// Organize the metadata for mapping to user fields
$data = ['phone' => '', 'street_address' => '', 'city' => '', 'state' => '', 'zip' => '', 'first_name' => '', 'last_name' => '', '_badgeos_points' => '', 'email_optin' => false, 'current_member' => false, 'current_member_number' => ''];
foreach ($metadata as $mdata) {
$data[$mdata->meta_key] = $mdata->meta_value;
}
$user->phone = $data['phone'];
$user->street_addr = $data['street_address'];
$user->city = $data['city'];
$user->zip = $data['zip'];
$user->points = $data['_badgeos_points'];
// Ensures that we have a barcode id for the user
if (empty($user->barcode_id)) {
$user->barcode_id = $user->name;
}
// Populate state and country objects
if (!empty($data['state'])) {
$state = State::where('code', strtoupper($data['state']))->first();
if (!$state) {
$state = State::where('name', $data['state'])->first();
}
if ($state) {
$user->state()->associate($state);
$user->country()->associate(Country::find($state->country_id));
}
}
$metadata = new Usermeta();
$metadata->first_name = $data['first_name'];
$metadata->last_name = $data['last_name'];
$metadata->email_optin = $data['email_optin'];
$metadata->current_member = $data['current_member'];
$metadata->current_member_number = $data['current_member_number'];
try {
$user->forceSave();
$user->metadata()->delete();
$user->metadata()->save($metadata);
} catch (Exception $e) {
var_dump($e);
}
}
