aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--servo/migrations/0001_initial.py1106
1 files changed, 1106 insertions, 0 deletions
diff --git a/servo/migrations/0001_initial.py b/servo/migrations/0001_initial.py
new file mode 100644
index 0000000..93f414a
--- /dev/null
+++ b/servo/migrations/0001_initial.py
@@ -0,0 +1,1106 @@
+# Generated by Django 3.2.2 on 2021-05-12 13:23
+
+from django.conf import settings
+import django.contrib.auth.models
+import django.contrib.auth.validators
+import django.contrib.postgres.fields
+import django.core.validators
+from django.db import migrations, models
+import django.db.models.deletion
+import django.utils.timezone
+import mptt.fields
+import servo.defaults
+import servo.lib.shorturl
+import servo.models.account
+import servo.models.note
+import servo.models.product
+import servo.validators
+
+
+class Migration(migrations.Migration):
+
+ initial = True
+
+ dependencies = [
+ ('auth', '0012_alter_user_first_name_max_length'),
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='User',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('password', models.CharField(max_length=128, verbose_name='password')),
+ ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
+ ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
+ ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
+ ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')),
+ ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
+ ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
+ ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
+ ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
+ ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
+ ('full_name', models.CharField(default='New User', editable=False, max_length=128)),
+ ('locale', models.CharField(choices=[('da_DK.UTF-8', 'Danish'), ('nl_NL.UTF-8', 'Dutch'), ('en_US.UTF-8', 'English'), ('et_EE.UTF-8', 'Estonian'), ('fi_FI.UTF-8', 'Finnish'), ('sv_SE.UTF-8', 'Swedish')], default='da_DK.UTF-8', help_text='Select which language you want to use Servo in.', max_length=32, verbose_name='Language')),
+ ('timezone', models.CharField(choices=[('Africa/Abidjan', 'Africa/Abidjan'), ('Africa/Accra', 'Africa/Accra'), ('Africa/Addis_Ababa', 'Africa/Addis_Ababa'), ('Africa/Algiers', 'Africa/Algiers'), ('Africa/Asmara', 'Africa/Asmara'), ('Africa/Bamako', 'Africa/Bamako'), ('Africa/Bangui', 'Africa/Bangui'), ('Africa/Banjul', 'Africa/Banjul'), ('Africa/Bissau', 'Africa/Bissau'), ('Africa/Blantyre', 'Africa/Blantyre'), ('Africa/Brazzaville', 'Africa/Brazzaville'), ('Africa/Bujumbura', 'Africa/Bujumbura'), ('Africa/Cairo', 'Africa/Cairo'), ('Africa/Casablanca', 'Africa/Casablanca'), ('Africa/Ceuta', 'Africa/Ceuta'), ('Africa/Conakry', 'Africa/Conakry'), ('Africa/Dakar', 'Africa/Dakar'), ('Africa/Dar_es_Salaam', 'Africa/Dar_es_Salaam'), ('Africa/Djibouti', 'Africa/Djibouti'), ('Africa/Douala', 'Africa/Douala'), ('Africa/El_Aaiun', 'Africa/El_Aaiun'), ('Africa/Freetown', 'Africa/Freetown'), ('Africa/Gaborone', 'Africa/Gaborone'), ('Africa/Harare', 'Africa/Harare'), ('Africa/Johannesburg', 'Africa/Johannesburg'), ('Africa/Juba', 'Africa/Juba'), ('Africa/Kampala', 'Africa/Kampala'), ('Africa/Khartoum', 'Africa/Khartoum'), ('Africa/Kigali', 'Africa/Kigali'), ('Africa/Kinshasa', 'Africa/Kinshasa'), ('Africa/Lagos', 'Africa/Lagos'), ('Africa/Libreville', 'Africa/Libreville'), ('Africa/Lome', 'Africa/Lome'), ('Africa/Luanda', 'Africa/Luanda'), ('Africa/Lubumbashi', 'Africa/Lubumbashi'), ('Africa/Lusaka', 'Africa/Lusaka'), ('Africa/Malabo', 'Africa/Malabo'), ('Africa/Maputo', 'Africa/Maputo'), ('Africa/Maseru', 'Africa/Maseru'), ('Africa/Mbabane', 'Africa/Mbabane'), ('Africa/Mogadishu', 'Africa/Mogadishu'), ('Africa/Monrovia', 'Africa/Monrovia'), ('Africa/Nairobi', 'Africa/Nairobi'), ('Africa/Ndjamena', 'Africa/Ndjamena'), ('Africa/Niamey', 'Africa/Niamey'), ('Africa/Nouakchott', 'Africa/Nouakchott'), ('Africa/Ouagadougou', 'Africa/Ouagadougou'), ('Africa/Porto-Novo', 'Africa/Porto-Novo'), ('Africa/Sao_Tome', 'Africa/Sao_Tome'), ('Africa/Tripoli', 'Africa/Tripoli'), ('Africa/Tunis', 'Africa/Tunis'), ('Africa/Windhoek', 'Africa/Windhoek'), ('America/Adak', 'America/Adak'), ('America/Anchorage', 'America/Anchorage'), ('America/Anguilla', 'America/Anguilla'), ('America/Antigua', 'America/Antigua'), ('America/Araguaina', 'America/Araguaina'), ('America/Argentina/Buenos_Aires', 'America/Argentina/Buenos_Aires'), ('America/Argentina/Catamarca', 'America/Argentina/Catamarca'), ('America/Argentina/Cordoba', 'America/Argentina/Cordoba'), ('America/Argentina/Jujuy', 'America/Argentina/Jujuy'), ('America/Argentina/La_Rioja', 'America/Argentina/La_Rioja'), ('America/Argentina/Mendoza', 'America/Argentina/Mendoza'), ('America/Argentina/Rio_Gallegos', 'America/Argentina/Rio_Gallegos'), ('America/Argentina/Salta', 'America/Argentina/Salta'), ('America/Argentina/San_Juan', 'America/Argentina/San_Juan'), ('America/Argentina/San_Luis', 'America/Argentina/San_Luis'), ('America/Argentina/Tucuman', 'America/Argentina/Tucuman'), ('America/Argentina/Ushuaia', 'America/Argentina/Ushuaia'), ('America/Aruba', 'America/Aruba'), ('America/Asuncion', 'America/Asuncion'), ('America/Atikokan', 'America/Atikokan'), ('America/Bahia', 'America/Bahia'), ('America/Bahia_Banderas', 'America/Bahia_Banderas'), ('America/Barbados', 'America/Barbados'), ('America/Belem', 'America/Belem'), ('America/Belize', 'America/Belize'), ('America/Blanc-Sablon', 'America/Blanc-Sablon'), ('America/Boa_Vista', 'America/Boa_Vista'), ('America/Bogota', 'America/Bogota'), ('America/Boise', 'America/Boise'), ('America/Cambridge_Bay', 'America/Cambridge_Bay'), ('America/Campo_Grande', 'America/Campo_Grande'), ('America/Cancun', 'America/Cancun'), ('America/Caracas', 'America/Caracas'), ('America/Cayenne', 'America/Cayenne'), ('America/Cayman', 'America/Cayman'), ('America/Chicago', 'America/Chicago'), ('America/Chihuahua', 'America/Chihuahua'), ('America/Costa_Rica', 'America/Costa_Rica'), ('America/Creston', 'America/Creston'), ('America/Cuiaba', 'America/Cuiaba'), ('America/Curacao', 'America/Curacao'), ('America/Danmarkshavn', 'America/Danmarkshavn'), ('America/Dawson', 'America/Dawson'), ('America/Dawson_Creek', 'America/Dawson_Creek'), ('America/Denver', 'America/Denver'), ('America/Detroit', 'America/Detroit'), ('America/Dominica', 'America/Dominica'), ('America/Edmonton', 'America/Edmonton'), ('America/Eirunepe', 'America/Eirunepe'), ('America/El_Salvador', 'America/El_Salvador'), ('America/Fort_Nelson', 'America/Fort_Nelson'), ('America/Fortaleza', 'America/Fortaleza'), ('America/Glace_Bay', 'America/Glace_Bay'), ('America/Goose_Bay', 'America/Goose_Bay'), ('America/Grand_Turk', 'America/Grand_Turk'), ('America/Grenada', 'America/Grenada'), ('America/Guadeloupe', 'America/Guadeloupe'), ('America/Guatemala', 'America/Guatemala'), ('America/Guayaquil', 'America/Guayaquil'), ('America/Guyana', 'America/Guyana'), ('America/Halifax', 'America/Halifax'), ('America/Havana', 'America/Havana'), ('America/Hermosillo', 'America/Hermosillo'), ('America/Indiana/Indianapolis', 'America/Indiana/Indianapolis'), ('America/Indiana/Knox', 'America/Indiana/Knox'), ('America/Indiana/Marengo', 'America/Indiana/Marengo'), ('America/Indiana/Petersburg', 'America/Indiana/Petersburg'), ('America/Indiana/Tell_City', 'America/Indiana/Tell_City'), ('America/Indiana/Vevay', 'America/Indiana/Vevay'), ('America/Indiana/Vincennes', 'America/Indiana/Vincennes'), ('America/Indiana/Winamac', 'America/Indiana/Winamac'), ('America/Inuvik', 'America/Inuvik'), ('America/Iqaluit', 'America/Iqaluit'), ('America/Jamaica', 'America/Jamaica'), ('America/Juneau', 'America/Juneau'), ('America/Kentucky/Louisville', 'America/Kentucky/Louisville'), ('America/Kentucky/Monticello', 'America/Kentucky/Monticello'), ('America/Kralendijk', 'America/Kralendijk'), ('America/La_Paz', 'America/La_Paz'), ('America/Lima', 'America/Lima'), ('America/Los_Angeles', 'America/Los_Angeles'), ('America/Lower_Princes', 'America/Lower_Princes'), ('America/Maceio', 'America/Maceio'), ('America/Managua', 'America/Managua'), ('America/Manaus', 'America/Manaus'), ('America/Marigot', 'America/Marigot'), ('America/Martinique', 'America/Martinique'), ('America/Matamoros', 'America/Matamoros'), ('America/Mazatlan', 'America/Mazatlan'), ('America/Menominee', 'America/Menominee'), ('America/Merida', 'America/Merida'), ('America/Metlakatla', 'America/Metlakatla'), ('America/Mexico_City', 'America/Mexico_City'), ('America/Miquelon', 'America/Miquelon'), ('America/Moncton', 'America/Moncton'), ('America/Monterrey', 'America/Monterrey'), ('America/Montevideo', 'America/Montevideo'), ('America/Montserrat', 'America/Montserrat'), ('America/Nassau', 'America/Nassau'), ('America/New_York', 'America/New_York'), ('America/Nipigon', 'America/Nipigon'), ('America/Nome', 'America/Nome'), ('America/Noronha', 'America/Noronha'), ('America/North_Dakota/Beulah', 'America/North_Dakota/Beulah'), ('America/North_Dakota/Center', 'America/North_Dakota/Center'), ('America/North_Dakota/New_Salem', 'America/North_Dakota/New_Salem'), ('America/Nuuk', 'America/Nuuk'), ('America/Ojinaga', 'America/Ojinaga'), ('America/Panama', 'America/Panama'), ('America/Pangnirtung', 'America/Pangnirtung'), ('America/Paramaribo', 'America/Paramaribo'), ('America/Phoenix', 'America/Phoenix'), ('America/Port-au-Prince', 'America/Port-au-Prince'), ('America/Port_of_Spain', 'America/Port_of_Spain'), ('America/Porto_Velho', 'America/Porto_Velho'), ('America/Puerto_Rico', 'America/Puerto_Rico'), ('America/Punta_Arenas', 'America/Punta_Arenas'), ('America/Rainy_River', 'America/Rainy_River'), ('America/Rankin_Inlet', 'America/Rankin_Inlet'), ('America/Recife', 'America/Recife'), ('America/Regina', 'America/Regina'), ('America/Resolute', 'America/Resolute'), ('America/Rio_Branco', 'America/Rio_Branco'), ('America/Santarem', 'America/Santarem'), ('America/Santiago', 'America/Santiago'), ('America/Santo_Domingo', 'America/Santo_Domingo'), ('America/Sao_Paulo', 'America/Sao_Paulo'), ('America/Scoresbysund', 'America/Scoresbysund'), ('America/Sitka', 'America/Sitka'), ('America/St_Barthelemy', 'America/St_Barthelemy'), ('America/St_Johns', 'America/St_Johns'), ('America/St_Kitts', 'America/St_Kitts'), ('America/St_Lucia', 'America/St_Lucia'), ('America/St_Thomas', 'America/St_Thomas'), ('America/St_Vincent', 'America/St_Vincent'), ('America/Swift_Current', 'America/Swift_Current'), ('America/Tegucigalpa', 'America/Tegucigalpa'), ('America/Thule', 'America/Thule'), ('America/Thunder_Bay', 'America/Thunder_Bay'), ('America/Tijuana', 'America/Tijuana'), ('America/Toronto', 'America/Toronto'), ('America/Tortola', 'America/Tortola'), ('America/Vancouver', 'America/Vancouver'), ('America/Whitehorse', 'America/Whitehorse'), ('America/Winnipeg', 'America/Winnipeg'), ('America/Yakutat', 'America/Yakutat'), ('America/Yellowknife', 'America/Yellowknife'), ('Antarctica/Casey', 'Antarctica/Casey'), ('Antarctica/Davis', 'Antarctica/Davis'), ('Antarctica/DumontDUrville', 'Antarctica/DumontDUrville'), ('Antarctica/Macquarie', 'Antarctica/Macquarie'), ('Antarctica/Mawson', 'Antarctica/Mawson'), ('Antarctica/McMurdo', 'Antarctica/McMurdo'), ('Antarctica/Palmer', 'Antarctica/Palmer'), ('Antarctica/Rothera', 'Antarctica/Rothera'), ('Antarctica/Syowa', 'Antarctica/Syowa'), ('Antarctica/Troll', 'Antarctica/Troll'), ('Antarctica/Vostok', 'Antarctica/Vostok'), ('Arctic/Longyearbyen', 'Arctic/Longyearbyen'), ('Asia/Aden', 'Asia/Aden'), ('Asia/Almaty', 'Asia/Almaty'), ('Asia/Amman', 'Asia/Amman'), ('Asia/Anadyr', 'Asia/Anadyr'), ('Asia/Aqtau', 'Asia/Aqtau'), ('Asia/Aqtobe', 'Asia/Aqtobe'), ('Asia/Ashgabat', 'Asia/Ashgabat'), ('Asia/Atyrau', 'Asia/Atyrau'), ('Asia/Baghdad', 'Asia/Baghdad'), ('Asia/Bahrain', 'Asia/Bahrain'), ('Asia/Baku', 'Asia/Baku'), ('Asia/Bangkok', 'Asia/Bangkok'), ('Asia/Barnaul', 'Asia/Barnaul'), ('Asia/Beirut', 'Asia/Beirut'), ('Asia/Bishkek', 'Asia/Bishkek'), ('Asia/Brunei', 'Asia/Brunei'), ('Asia/Chita', 'Asia/Chita'), ('Asia/Choibalsan', 'Asia/Choibalsan'), ('Asia/Colombo', 'Asia/Colombo'), ('Asia/Damascus', 'Asia/Damascus'), ('Asia/Dhaka', 'Asia/Dhaka'), ('Asia/Dili', 'Asia/Dili'), ('Asia/Dubai', 'Asia/Dubai'), ('Asia/Dushanbe', 'Asia/Dushanbe'), ('Asia/Famagusta', 'Asia/Famagusta'), ('Asia/Gaza', 'Asia/Gaza'), ('Asia/Hebron', 'Asia/Hebron'), ('Asia/Ho_Chi_Minh', 'Asia/Ho_Chi_Minh'), ('Asia/Hong_Kong', 'Asia/Hong_Kong'), ('Asia/Hovd', 'Asia/Hovd'), ('Asia/Irkutsk', 'Asia/Irkutsk'), ('Asia/Jakarta', 'Asia/Jakarta'), ('Asia/Jayapura', 'Asia/Jayapura'), ('Asia/Jerusalem', 'Asia/Jerusalem'), ('Asia/Kabul', 'Asia/Kabul'), ('Asia/Kamchatka', 'Asia/Kamchatka'), ('Asia/Karachi', 'Asia/Karachi'), ('Asia/Kathmandu', 'Asia/Kathmandu'), ('Asia/Khandyga', 'Asia/Khandyga'), ('Asia/Kolkata', 'Asia/Kolkata'), ('Asia/Krasnoyarsk', 'Asia/Krasnoyarsk'), ('Asia/Kuala_Lumpur', 'Asia/Kuala_Lumpur'), ('Asia/Kuching', 'Asia/Kuching'), ('Asia/Kuwait', 'Asia/Kuwait'), ('Asia/Macau', 'Asia/Macau'), ('Asia/Magadan', 'Asia/Magadan'), ('Asia/Makassar', 'Asia/Makassar'), ('Asia/Manila', 'Asia/Manila'), ('Asia/Muscat', 'Asia/Muscat'), ('Asia/Nicosia', 'Asia/Nicosia'), ('Asia/Novokuznetsk', 'Asia/Novokuznetsk'), ('Asia/Novosibirsk', 'Asia/Novosibirsk'), ('Asia/Omsk', 'Asia/Omsk'), ('Asia/Oral', 'Asia/Oral'), ('Asia/Phnom_Penh', 'Asia/Phnom_Penh'), ('Asia/Pontianak', 'Asia/Pontianak'), ('Asia/Pyongyang', 'Asia/Pyongyang'), ('Asia/Qatar', 'Asia/Qatar'), ('Asia/Qostanay', 'Asia/Qostanay'), ('Asia/Qyzylorda', 'Asia/Qyzylorda'), ('Asia/Riyadh', 'Asia/Riyadh'), ('Asia/Sakhalin', 'Asia/Sakhalin'), ('Asia/Samarkand', 'Asia/Samarkand'), ('Asia/Seoul', 'Asia/Seoul'), ('Asia/Shanghai', 'Asia/Shanghai'), ('Asia/Singapore', 'Asia/Singapore'), ('Asia/Srednekolymsk', 'Asia/Srednekolymsk'), ('Asia/Taipei', 'Asia/Taipei'), ('Asia/Tashkent', 'Asia/Tashkent'), ('Asia/Tbilisi', 'Asia/Tbilisi'), ('Asia/Tehran', 'Asia/Tehran'), ('Asia/Thimphu', 'Asia/Thimphu'), ('Asia/Tokyo', 'Asia/Tokyo'), ('Asia/Tomsk', 'Asia/Tomsk'), ('Asia/Ulaanbaatar', 'Asia/Ulaanbaatar'), ('Asia/Urumqi', 'Asia/Urumqi'), ('Asia/Ust-Nera', 'Asia/Ust-Nera'), ('Asia/Vientiane', 'Asia/Vientiane'), ('Asia/Vladivostok', 'Asia/Vladivostok'), ('Asia/Yakutsk', 'Asia/Yakutsk'), ('Asia/Yangon', 'Asia/Yangon'), ('Asia/Yekaterinburg', 'Asia/Yekaterinburg'), ('Asia/Yerevan', 'Asia/Yerevan'), ('Atlantic/Azores', 'Atlantic/Azores'), ('Atlantic/Bermuda', 'Atlantic/Bermuda'), ('Atlantic/Canary', 'Atlantic/Canary'), ('Atlantic/Cape_Verde', 'Atlantic/Cape_Verde'), ('Atlantic/Faroe', 'Atlantic/Faroe'), ('Atlantic/Madeira', 'Atlantic/Madeira'), ('Atlantic/Reykjavik', 'Atlantic/Reykjavik'), ('Atlantic/South_Georgia', 'Atlantic/South_Georgia'), ('Atlantic/St_Helena', 'Atlantic/St_Helena'), ('Atlantic/Stanley', 'Atlantic/Stanley'), ('Australia/Adelaide', 'Australia/Adelaide'), ('Australia/Brisbane', 'Australia/Brisbane'), ('Australia/Broken_Hill', 'Australia/Broken_Hill'), ('Australia/Darwin', 'Australia/Darwin'), ('Australia/Eucla', 'Australia/Eucla'), ('Australia/Hobart', 'Australia/Hobart'), ('Australia/Lindeman', 'Australia/Lindeman'), ('Australia/Lord_Howe', 'Australia/Lord_Howe'), ('Australia/Melbourne', 'Australia/Melbourne'), ('Australia/Perth', 'Australia/Perth'), ('Australia/Sydney', 'Australia/Sydney'), ('Canada/Atlantic', 'Canada/Atlantic'), ('Canada/Central', 'Canada/Central'), ('Canada/Eastern', 'Canada/Eastern'), ('Canada/Mountain', 'Canada/Mountain'), ('Canada/Newfoundland', 'Canada/Newfoundland'), ('Canada/Pacific', 'Canada/Pacific'), ('Europe/Amsterdam', 'Europe/Amsterdam'), ('Europe/Andorra', 'Europe/Andorra'), ('Europe/Astrakhan', 'Europe/Astrakhan'), ('Europe/Athens', 'Europe/Athens'), ('Europe/Belgrade', 'Europe/Belgrade'), ('Europe/Berlin', 'Europe/Berlin'), ('Europe/Bratislava', 'Europe/Bratislava'), ('Europe/Brussels', 'Europe/Brussels'), ('Europe/Bucharest', 'Europe/Bucharest'), ('Europe/Budapest', 'Europe/Budapest'), ('Europe/Busingen', 'Europe/Busingen'), ('Europe/Chisinau', 'Europe/Chisinau'), ('Europe/Copenhagen', 'Europe/Copenhagen'), ('Europe/Dublin', 'Europe/Dublin'), ('Europe/Gibraltar', 'Europe/Gibraltar'), ('Europe/Guernsey', 'Europe/Guernsey'), ('Europe/Helsinki', 'Europe/Helsinki'), ('Europe/Isle_of_Man', 'Europe/Isle_of_Man'), ('Europe/Istanbul', 'Europe/Istanbul'), ('Europe/Jersey', 'Europe/Jersey'), ('Europe/Kaliningrad', 'Europe/Kaliningrad'), ('Europe/Kiev', 'Europe/Kiev'), ('Europe/Kirov', 'Europe/Kirov'), ('Europe/Lisbon', 'Europe/Lisbon'), ('Europe/Ljubljana', 'Europe/Ljubljana'), ('Europe/London', 'Europe/London'), ('Europe/Luxembourg', 'Europe/Luxembourg'), ('Europe/Madrid', 'Europe/Madrid'), ('Europe/Malta', 'Europe/Malta'), ('Europe/Mariehamn', 'Europe/Mariehamn'), ('Europe/Minsk', 'Europe/Minsk'), ('Europe/Monaco', 'Europe/Monaco'), ('Europe/Moscow', 'Europe/Moscow'), ('Europe/Oslo', 'Europe/Oslo'), ('Europe/Paris', 'Europe/Paris'), ('Europe/Podgorica', 'Europe/Podgorica'), ('Europe/Prague', 'Europe/Prague'), ('Europe/Riga', 'Europe/Riga'), ('Europe/Rome', 'Europe/Rome'), ('Europe/Samara', 'Europe/Samara'), ('Europe/San_Marino', 'Europe/San_Marino'), ('Europe/Sarajevo', 'Europe/Sarajevo'), ('Europe/Saratov', 'Europe/Saratov'), ('Europe/Simferopol', 'Europe/Simferopol'), ('Europe/Skopje', 'Europe/Skopje'), ('Europe/Sofia', 'Europe/Sofia'), ('Europe/Stockholm', 'Europe/Stockholm'), ('Europe/Tallinn', 'Europe/Tallinn'), ('Europe/Tirane', 'Europe/Tirane'), ('Europe/Ulyanovsk', 'Europe/Ulyanovsk'), ('Europe/Uzhgorod', 'Europe/Uzhgorod'), ('Europe/Vaduz', 'Europe/Vaduz'), ('Europe/Vatican', 'Europe/Vatican'), ('Europe/Vienna', 'Europe/Vienna'), ('Europe/Vilnius', 'Europe/Vilnius'), ('Europe/Volgograd', 'Europe/Volgograd'), ('Europe/Warsaw', 'Europe/Warsaw'), ('Europe/Zagreb', 'Europe/Zagreb'), ('Europe/Zaporozhye', 'Europe/Zaporozhye'), ('Europe/Zurich', 'Europe/Zurich'), ('GMT', 'GMT'), ('Indian/Antananarivo', 'Indian/Antananarivo'), ('Indian/Chagos', 'Indian/Chagos'), ('Indian/Christmas', 'Indian/Christmas'), ('Indian/Cocos', 'Indian/Cocos'), ('Indian/Comoro', 'Indian/Comoro'), ('Indian/Kerguelen', 'Indian/Kerguelen'), ('Indian/Mahe', 'Indian/Mahe'), ('Indian/Maldives', 'Indian/Maldives'), ('Indian/Mauritius', 'Indian/Mauritius'), ('Indian/Mayotte', 'Indian/Mayotte'), ('Indian/Reunion', 'Indian/Reunion'), ('Pacific/Apia', 'Pacific/Apia'), ('Pacific/Auckland', 'Pacific/Auckland'), ('Pacific/Bougainville', 'Pacific/Bougainville'), ('Pacific/Chatham', 'Pacific/Chatham'), ('Pacific/Chuuk', 'Pacific/Chuuk'), ('Pacific/Easter', 'Pacific/Easter'), ('Pacific/Efate', 'Pacific/Efate'), ('Pacific/Enderbury', 'Pacific/Enderbury'), ('Pacific/Fakaofo', 'Pacific/Fakaofo'), ('Pacific/Fiji', 'Pacific/Fiji'), ('Pacific/Funafuti', 'Pacific/Funafuti'), ('Pacific/Galapagos', 'Pacific/Galapagos'), ('Pacific/Gambier', 'Pacific/Gambier'), ('Pacific/Guadalcanal', 'Pacific/Guadalcanal'), ('Pacific/Guam', 'Pacific/Guam'), ('Pacific/Honolulu', 'Pacific/Honolulu'), ('Pacific/Kiritimati', 'Pacific/Kiritimati'), ('Pacific/Kosrae', 'Pacific/Kosrae'), ('Pacific/Kwajalein', 'Pacific/Kwajalein'), ('Pacific/Majuro', 'Pacific/Majuro'), ('Pacific/Marquesas', 'Pacific/Marquesas'), ('Pacific/Midway', 'Pacific/Midway'), ('Pacific/Nauru', 'Pacific/Nauru'), ('Pacific/Niue', 'Pacific/Niue'), ('Pacific/Norfolk', 'Pacific/Norfolk'), ('Pacific/Noumea', 'Pacific/Noumea'), ('Pacific/Pago_Pago', 'Pacific/Pago_Pago'), ('Pacific/Palau', 'Pacific/Palau'), ('Pacific/Pitcairn', 'Pacific/Pitcairn'), ('Pacific/Pohnpei', 'Pacific/Pohnpei'), ('Pacific/Port_Moresby', 'Pacific/Port_Moresby'), ('Pacific/Rarotonga', 'Pacific/Rarotonga'), ('Pacific/Saipan', 'Pacific/Saipan'), ('Pacific/Tahiti', 'Pacific/Tahiti'), ('Pacific/Tarawa', 'Pacific/Tarawa'), ('Pacific/Tongatapu', 'Pacific/Tongatapu'), ('Pacific/Wake', 'Pacific/Wake'), ('Pacific/Wallis', 'Pacific/Wallis'), ('US/Alaska', 'US/Alaska'), ('US/Arizona', 'US/Arizona'), ('US/Central', 'US/Central'), ('US/Eastern', 'US/Eastern'), ('US/Hawaii', 'US/Hawaii'), ('US/Mountain', 'US/Mountain'), ('US/Pacific', 'US/Pacific'), ('UTC', 'UTC')], default='Europe/Stockholm', help_text='Your current timezone', max_length=128, verbose_name='Time zone')),
+ ('region', models.CharField(choices=[('da_DK.UTF-8', 'Denmark'), ('et_EE.UTF-8', 'Estonia'), ('fi_FI.UTF-8', 'Finland'), ('en_US.UTF-8', 'United States'), ('nl_NL.UTF-8', 'Netherlands'), ('sv_SE.UTF-8', 'Sweden')], default=servo.defaults.locale, help_text='Affects formatting of numbers, dates and currencies.', max_length=32, verbose_name='region')),
+ ('should_notify', models.BooleanField(default=True, help_text='Enable notifications in the toolbar.', verbose_name='Enable notifications')),
+ ('notify_by_email', models.BooleanField(default=False, help_text='Event notifications will also be emailed to you.', verbose_name='Email notifications')),
+ ('autoprint', models.BooleanField(default=True, help_text='Opens print dialog automatically.', verbose_name='print automatically')),
+ ('tech_id', models.CharField(blank=True, default='', max_length=16, verbose_name='Tech ID')),
+ ('gsx_userid', models.CharField(blank=True, default='', max_length=128, verbose_name='User ID')),
+ ('gsx_poprefix', models.CharField(blank=True, default='', help_text='GSX repairs you create will be prefixed', max_length=8, verbose_name='PO prefix')),
+ ('photo', models.ImageField(blank=True, help_text='Maximum avatar size is 1MB', null=True, upload_to='avatars', verbose_name='Photo')),
+ ('is_visible', models.BooleanField(default=True, editable=False)),
+ ],
+ options={
+ 'verbose_name': 'User',
+ 'verbose_name_plural': 'Users & Groups',
+ 'ordering': ('full_name',),
+ },
+ managers=[
+ ('objects', django.contrib.auth.models.UserManager()),
+ ('techies', servo.models.account.TechieManager()),
+ ('active', servo.models.account.ActiveManager()),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Attachment',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('ref', models.CharField(max_length=32)),
+ ('ref_id', models.IntegerField()),
+ ('mime_type', models.CharField(editable=False, max_length=64)),
+ ('content', models.FileField(upload_to='attachments', validators=[servo.validators.file_upload_validator], verbose_name='file')),
+ ],
+ options={
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='Checklist',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Checklist', max_length=255, unique=True, verbose_name='title')),
+ ('enabled', models.BooleanField(default=True, verbose_name='Enabled')),
+ ],
+ options={
+ 'verbose_name': 'Checklist',
+ 'verbose_name_plural': 'Checklists',
+ 'ordering': ('title',),
+ },
+ ),
+ migrations.CreateModel(
+ name='ChecklistItem',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(max_length=255, verbose_name='Task')),
+ ('description', models.TextField(blank=True, default='', verbose_name='Description')),
+ ('checklist', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.checklist')),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Configuration',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('key', models.CharField(max_length=255)),
+ ('value', models.TextField(blank=True, default='')),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Customer',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('name', models.CharField(default='New Customer', max_length=255, verbose_name='name')),
+ ('fullname', models.CharField(default='', editable=False, max_length=255)),
+ ('phone', models.CharField(blank=True, default='', max_length=32, verbose_name='phone')),
+ ('email', models.EmailField(blank=True, default='', max_length=254, verbose_name='email')),
+ ('street_address', models.CharField(blank=True, default='', max_length=128, verbose_name='address')),
+ ('zip_code', models.CharField(blank=True, default='', max_length=32, verbose_name='ZIP Code')),
+ ('city', models.CharField(blank=True, default='', max_length=32, verbose_name='city')),
+ ('country', models.CharField(blank=True, choices=[('AD', 'Andorra'), ('AE', 'United Arab Emirates'), ('AF', 'Afghanistan'), ('AG', 'Antigua & Barbuda'), ('AI', 'Anguilla'), ('AL', 'Albania'), ('AM', 'Armenia'), ('AO', 'Angola'), ('AQ', 'Antarctica'), ('AR', 'Argentina'), ('AS', 'Samoa (American)'), ('AT', 'Austria'), ('AU', 'Australia'), ('AW', 'Aruba'), ('AX', 'Åland Islands'), ('AZ', 'Azerbaijan'), ('BA', 'Bosnia & Herzegovina'), ('BB', 'Barbados'), ('BD', 'Bangladesh'), ('BE', 'Belgium'), ('BF', 'Burkina Faso'), ('BG', 'Bulgaria'), ('BH', 'Bahrain'), ('BI', 'Burundi'), ('BJ', 'Benin'), ('BL', 'St Barthelemy'), ('BM', 'Bermuda'), ('BN', 'Brunei'), ('BO', 'Bolivia'), ('BQ', 'Caribbean NL'), ('BR', 'Brazil'), ('BS', 'Bahamas'), ('BT', 'Bhutan'), ('BV', 'Bouvet Island'), ('BW', 'Botswana'), ('BY', 'Belarus'), ('BZ', 'Belize'), ('CA', 'Canada'), ('CC', 'Cocos (Keeling) Islands'), ('CD', 'Congo (Dem. Rep.)'), ('CF', 'Central African Rep.'), ('CG', 'Congo (Rep.)'), ('CH', 'Switzerland'), ('CI', "Côte d'Ivoire"), ('CK', 'Cook Islands'), ('CL', 'Chile'), ('CM', 'Cameroon'), ('CN', 'China'), ('CO', 'Colombia'), ('CR', 'Costa Rica'), ('CU', 'Cuba'), ('CV', 'Cape Verde'), ('CW', 'Curaçao'), ('CX', 'Christmas Island'), ('CY', 'Cyprus'), ('CZ', 'Czech Republic'), ('DE', 'Germany'), ('DJ', 'Djibouti'), ('DK', 'Denmark'), ('DM', 'Dominica'), ('DO', 'Dominican Republic'), ('DZ', 'Algeria'), ('EC', 'Ecuador'), ('EE', 'Estonia'), ('EG', 'Egypt'), ('EH', 'Western Sahara'), ('ER', 'Eritrea'), ('ES', 'Spain'), ('ET', 'Ethiopia'), ('FI', 'Finland'), ('FJ', 'Fiji'), ('FK', 'Falkland Islands'), ('FM', 'Micronesia'), ('FO', 'Faroe Islands'), ('FR', 'France'), ('GA', 'Gabon'), ('GB', 'Britain (UK)'), ('GD', 'Grenada'), ('GE', 'Georgia'), ('GF', 'French Guiana'), ('GG', 'Guernsey'), ('GH', 'Ghana'), ('GI', 'Gibraltar'), ('GL', 'Greenland'), ('GM', 'Gambia'), ('GN', 'Guinea'), ('GP', 'Guadeloupe'), ('GQ', 'Equatorial Guinea'), ('GR', 'Greece'), ('GS', 'South Georgia & the South Sandwich Islands'), ('GT', 'Guatemala'), ('GU', 'Guam'), ('GW', 'Guinea-Bissau'), ('GY', 'Guyana'), ('HK', 'Hong Kong'), ('HM', 'Heard Island & McDonald Islands'), ('HN', 'Honduras'), ('HR', 'Croatia'), ('HT', 'Haiti'), ('HU', 'Hungary'), ('ID', 'Indonesia'), ('IE', 'Ireland'), ('IL', 'Israel'), ('IM', 'Isle of Man'), ('IN', 'India'), ('IO', 'British Indian Ocean Territory'), ('IQ', 'Iraq'), ('IR', 'Iran'), ('IS', 'Iceland'), ('IT', 'Italy'), ('JE', 'Jersey'), ('JM', 'Jamaica'), ('JO', 'Jordan'), ('JP', 'Japan'), ('KE', 'Kenya'), ('KG', 'Kyrgyzstan'), ('KH', 'Cambodia'), ('KI', 'Kiribati'), ('KM', 'Comoros'), ('KN', 'St Kitts & Nevis'), ('KP', 'Korea (North)'), ('KR', 'Korea (South)'), ('KW', 'Kuwait'), ('KY', 'Cayman Islands'), ('KZ', 'Kazakhstan'), ('LA', 'Laos'), ('LB', 'Lebanon'), ('LC', 'St Lucia'), ('LI', 'Liechtenstein'), ('LK', 'Sri Lanka'), ('LR', 'Liberia'), ('LS', 'Lesotho'), ('LT', 'Lithuania'), ('LU', 'Luxembourg'), ('LV', 'Latvia'), ('LY', 'Libya'), ('MA', 'Morocco'), ('MC', 'Monaco'), ('MD', 'Moldova'), ('ME', 'Montenegro'), ('MF', 'St Martin (French)'), ('MG', 'Madagascar'), ('MH', 'Marshall Islands'), ('MK', 'North Macedonia'), ('ML', 'Mali'), ('MM', 'Myanmar (Burma)'), ('MN', 'Mongolia'), ('MO', 'Macau'), ('MP', 'Northern Mariana Islands'), ('MQ', 'Martinique'), ('MR', 'Mauritania'), ('MS', 'Montserrat'), ('MT', 'Malta'), ('MU', 'Mauritius'), ('MV', 'Maldives'), ('MW', 'Malawi'), ('MX', 'Mexico'), ('MY', 'Malaysia'), ('MZ', 'Mozambique'), ('NA', 'Namibia'), ('NC', 'New Caledonia'), ('NE', 'Niger'), ('NF', 'Norfolk Island'), ('NG', 'Nigeria'), ('NI', 'Nicaragua'), ('NL', 'Netherlands'), ('NO', 'Norway'), ('NP', 'Nepal'), ('NR', 'Nauru'), ('NU', 'Niue'), ('NZ', 'New Zealand'), ('OM', 'Oman'), ('PA', 'Panama'), ('PE', 'Peru'), ('PF', 'French Polynesia'), ('PG', 'Papua New Guinea'), ('PH', 'Philippines'), ('PK', 'Pakistan'), ('PL', 'Poland'), ('PM', 'St Pierre & Miquelon'), ('PN', 'Pitcairn'), ('PR', 'Puerto Rico'), ('PS', 'Palestine'), ('PT', 'Portugal'), ('PW', 'Palau'), ('PY', 'Paraguay'), ('QA', 'Qatar'), ('RE', 'Réunion'), ('RO', 'Romania'), ('RS', 'Serbia'), ('RU', 'Russia'), ('RW', 'Rwanda'), ('SA', 'Saudi Arabia'), ('SB', 'Solomon Islands'), ('SC', 'Seychelles'), ('SD', 'Sudan'), ('SE', 'Sweden'), ('SG', 'Singapore'), ('SH', 'St Helena'), ('SI', 'Slovenia'), ('SJ', 'Svalbard & Jan Mayen'), ('SK', 'Slovakia'), ('SL', 'Sierra Leone'), ('SM', 'San Marino'), ('SN', 'Senegal'), ('SO', 'Somalia'), ('SR', 'Suriname'), ('SS', 'South Sudan'), ('ST', 'Sao Tome & Principe'), ('SV', 'El Salvador'), ('SX', 'St Maarten (Dutch)'), ('SY', 'Syria'), ('SZ', 'Eswatini (Swaziland)'), ('TC', 'Turks & Caicos Is'), ('TD', 'Chad'), ('TF', 'French Southern & Antarctic Lands'), ('TG', 'Togo'), ('TH', 'Thailand'), ('TJ', 'Tajikistan'), ('TK', 'Tokelau'), ('TL', 'East Timor'), ('TM', 'Turkmenistan'), ('TN', 'Tunisia'), ('TO', 'Tonga'), ('TR', 'Turkey'), ('TT', 'Trinidad & Tobago'), ('TV', 'Tuvalu'), ('TW', 'Taiwan'), ('TZ', 'Tanzania'), ('UA', 'Ukraine'), ('UG', 'Uganda'), ('UM', 'US minor outlying islands'), ('US', 'United States'), ('UY', 'Uruguay'), ('UZ', 'Uzbekistan'), ('VA', 'Vatican City'), ('VC', 'St Vincent'), ('VE', 'Venezuela'), ('VG', 'Virgin Islands (UK)'), ('VI', 'Virgin Islands (US)'), ('VN', 'Vietnam'), ('VU', 'Vanuatu'), ('WF', 'Wallis & Futuna'), ('WS', 'Samoa (western)'), ('YE', 'Yemen'), ('YT', 'Mayotte'), ('ZA', 'South Africa'), ('ZM', 'Zambia'), ('ZW', 'Zimbabwe')], default=servo.defaults.country, max_length=2, verbose_name='Country')),
+ ('photo', models.ImageField(blank=True, null=True, upload_to='photos', verbose_name='photo')),
+ ('notes', models.TextField(blank=True, default='', verbose_name='notes')),
+ ('created_at', models.DateTimeField(auto_now=True)),
+ ('is_company', models.BooleanField(default=False, help_text='Companies can contain contacts', verbose_name='company')),
+ ('lft', models.PositiveIntegerField(editable=False)),
+ ('rght', models.PositiveIntegerField(editable=False)),
+ ('tree_id', models.PositiveIntegerField(db_index=True, editable=False)),
+ ('level', models.PositiveIntegerField(editable=False)),
+ ],
+ ),
+ migrations.CreateModel(
+ name='CustomerGroup',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('name', models.CharField(default='New Group', max_length=255, unique=True, verbose_name='name')),
+ ('slug', models.SlugField(editable=False)),
+ ],
+ options={
+ 'ordering': ('id',),
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='Device',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('sn', models.CharField(blank=True, default='', max_length=32, validators=[servo.validators.sn_validator], verbose_name='Serial Number')),
+ ('description', models.CharField(default='New Device', max_length=128, verbose_name='Description')),
+ ('brand', models.CharField(blank=True, default='Apple', max_length=128, verbose_name='Brand')),
+ ('reseller', models.CharField(blank=True, default='', max_length=128, verbose_name='Reseller')),
+ ('created_at', models.DateTimeField(auto_now_add=True, null=True)),
+ ('imei', models.CharField(blank=True, default='', max_length=15, verbose_name='IMEI Number')),
+ ('initial_activation_policy', models.CharField(default='', editable=False, max_length=128, verbose_name='Initial Activation Policy')),
+ ('applied_activation_policy', models.CharField(default='', editable=False, max_length=128, verbose_name='Applied Activation Policy')),
+ ('next_tether_policy', models.CharField(default='', editable=False, max_length=128, verbose_name='Next Tether Policy')),
+ ('unlocked', models.BooleanField(default=None, editable=False, null=True)),
+ ('slug', models.SlugField(editable=False, max_length=128, null=True)),
+ ('product_line', models.CharField(choices=[('APPLETV', 'Apple TV'), ('DISPLAYS', 'Display'), ('IMAC', 'iMac'), ('IPAD', 'iPad'), ('IPADACCESSORY', 'iPad Accessory'), ('IPHONE', 'iPhone'), ('IPHONEACCESSORY', 'iPhone Accessory'), ('MACACCESSORY', 'Mac Accessory'), ('IPODCLASSIC', 'iPod Classic'), ('IPODNANO', 'iPod nano'), ('IPODSHUFFLE', 'iPod Shuffle'), ('IPODTOUCH', 'iPod Touch'), ('MACMINI', 'Mac mini'), ('MACPRO', 'Mac Pro'), ('MACBOOK', 'MacBook'), ('MACBOOKLEGACY', 'MacBook (Legacy)'), ('MACBOOKAIR', 'MacBook Air'), ('MACBOOKPRO', 'MacBook Pro'), ('SERVERS', 'Server'), ('POWERMAC', 'Power Mac'), ('BEATS', 'Beats Products'), ('OTHER', 'Other Products'), ('WATCH', 'Apple Watch'), ('AUDIO', 'Audio')], default='OTHER', max_length=16, verbose_name='Product Line')),
+ ('config_code', models.CharField(default='', editable=False, max_length=8)),
+ ('configuration', models.CharField(blank=True, default='', max_length=256, verbose_name='Configuration')),
+ ('warranty_status', models.CharField(choices=[('QP', 'Quality Program'), ('CS', 'Customer Satisfaction'), ('ALW', 'Apple Limited Warranty'), ('APP', 'AppleCare Protection Plan'), ('CC', 'Custom Bid Contracts'), ('CBC', 'Custom Bid Contracts'), ('WTY', "3'rd Party Warranty"), ('OOW', 'Out Of Warranty (No Coverage)'), ('NA', 'Unknown')], default='NA', max_length=3, verbose_name='Warranty Status')),
+ ('username', models.CharField(blank=True, default='', max_length=32, verbose_name='Username')),
+ ('password', models.CharField(blank=True, default='', max_length=32, verbose_name='Password')),
+ ('purchased_on', models.DateField(blank=True, null=True, verbose_name='Date of Purchase')),
+ ('purchase_country', models.CharField(blank=True, choices=[('AF', 'Afghanistan'), ('AX', 'Åland Islands'), ('AL', 'Albania'), ('DZ', 'Algeria'), ('AS', 'American Samoa'), ('AD', 'Andorra'), ('AO', 'Angola'), ('AI', 'Anguilla'), ('AQ', 'Antarctica'), ('AG', 'Antigua and Barbuda'), ('AR', 'Argentina'), ('AM', 'Armenia'), ('AW', 'Aruba'), ('AU', 'Australia'), ('AT', 'Austria'), ('AZ', 'Azerbaijan'), ('BS', 'Bahamas'), ('BH', 'Bahrain'), ('BD', 'Bangladesh'), ('BB', 'Barbados'), ('BY', 'Belarus'), ('BE', 'Belgium'), ('BZ', 'Belize'), ('BJ', 'Benin'), ('BM', 'Bermuda'), ('BT', 'Bhutan'), ('BO', 'Bolivia'), ('BQ', 'Bonaire, Sint Eustatius and Saba'), ('BA', 'Bosnia and Herzegovina'), ('BW', 'Botswana'), ('BV', 'Bouvet Island'), ('BR', 'Brazil'), ('IO', 'British Indian Ocean Territory'), ('BN', 'Brunei'), ('BG', 'Bulgaria'), ('BF', 'Burkina Faso'), ('BI', 'Burundi'), ('CV', 'Cabo Verde'), ('KH', 'Cambodia'), ('CM', 'Cameroon'), ('CA', 'Canada'), ('KY', 'Cayman Islands'), ('CF', 'Central African Republic'), ('TD', 'Chad'), ('CL', 'Chile'), ('CN', 'China'), ('CX', 'Christmas Island'), ('CC', 'Cocos (Keeling) Islands'), ('CO', 'Colombia'), ('KM', 'Comoros'), ('CG', 'Congo'), ('CD', 'Congo (the Democratic Republic of the)'), ('CK', 'Cook Islands'), ('CR', 'Costa Rica'), ('CI', "Côte d'Ivoire"), ('HR', 'Croatia'), ('CU', 'Cuba'), ('CW', 'Curaçao'), ('CY', 'Cyprus'), ('CZ', 'Czechia'), ('DK', 'Denmark'), ('DJ', 'Djibouti'), ('DM', 'Dominica'), ('DO', 'Dominican Republic'), ('EC', 'Ecuador'), ('EG', 'Egypt'), ('SV', 'El Salvador'), ('GQ', 'Equatorial Guinea'), ('ER', 'Eritrea'), ('EE', 'Estonia'), ('SZ', 'Eswatini'), ('ET', 'Ethiopia'), ('FK', 'Falkland Islands (Malvinas)'), ('FO', 'Faroe Islands'), ('FJ', 'Fiji'), ('FI', 'Finland'), ('FR', 'France'), ('GF', 'French Guiana'), ('PF', 'French Polynesia'), ('TF', 'French Southern Territories'), ('GA', 'Gabon'), ('GM', 'Gambia'), ('GE', 'Georgia'), ('DE', 'Germany'), ('GH', 'Ghana'), ('GI', 'Gibraltar'), ('GR', 'Greece'), ('GL', 'Greenland'), ('GD', 'Grenada'), ('GP', 'Guadeloupe'), ('GU', 'Guam'), ('GT', 'Guatemala'), ('GG', 'Guernsey'), ('GN', 'Guinea'), ('GW', 'Guinea-Bissau'), ('GY', 'Guyana'), ('HT', 'Haiti'), ('HM', 'Heard Island and McDonald Islands'), ('VA', 'Holy See'), ('HN', 'Honduras'), ('HK', 'Hong Kong'), ('HU', 'Hungary'), ('IS', 'Iceland'), ('IN', 'India'), ('ID', 'Indonesia'), ('IR', 'Iran'), ('IQ', 'Iraq'), ('IE', 'Ireland'), ('IM', 'Isle of Man'), ('IL', 'Israel'), ('IT', 'Italy'), ('JM', 'Jamaica'), ('JP', 'Japan'), ('JE', 'Jersey'), ('JO', 'Jordan'), ('KZ', 'Kazakhstan'), ('KE', 'Kenya'), ('KI', 'Kiribati'), ('KW', 'Kuwait'), ('KG', 'Kyrgyzstan'), ('LA', 'Laos'), ('LV', 'Latvia'), ('LB', 'Lebanon'), ('LS', 'Lesotho'), ('LR', 'Liberia'), ('LY', 'Libya'), ('LI', 'Liechtenstein'), ('LT', 'Lithuania'), ('LU', 'Luxembourg'), ('MO', 'Macao'), ('MG', 'Madagascar'), ('MW', 'Malawi'), ('MY', 'Malaysia'), ('MV', 'Maldives'), ('ML', 'Mali'), ('MT', 'Malta'), ('MH', 'Marshall Islands'), ('MQ', 'Martinique'), ('MR', 'Mauritania'), ('MU', 'Mauritius'), ('YT', 'Mayotte'), ('MX', 'Mexico'), ('FM', 'Micronesia (Federated States of)'), ('MD', 'Moldova'), ('MC', 'Monaco'), ('MN', 'Mongolia'), ('ME', 'Montenegro'), ('MS', 'Montserrat'), ('MA', 'Morocco'), ('MZ', 'Mozambique'), ('MM', 'Myanmar'), ('NA', 'Namibia'), ('NR', 'Nauru'), ('NP', 'Nepal'), ('NL', 'Netherlands'), ('NC', 'New Caledonia'), ('NZ', 'New Zealand'), ('NI', 'Nicaragua'), ('NE', 'Niger'), ('NG', 'Nigeria'), ('NU', 'Niue'), ('NF', 'Norfolk Island'), ('KP', 'North Korea'), ('MK', 'North Macedonia'), ('MP', 'Northern Mariana Islands'), ('NO', 'Norway'), ('OM', 'Oman'), ('PK', 'Pakistan'), ('PW', 'Palau'), ('PS', 'Palestine, State of'), ('PA', 'Panama'), ('PG', 'Papua New Guinea'), ('PY', 'Paraguay'), ('PE', 'Peru'), ('PH', 'Philippines'), ('PN', 'Pitcairn'), ('PL', 'Poland'), ('PT', 'Portugal'), ('PR', 'Puerto Rico'), ('QA', 'Qatar'), ('RE', 'Réunion'), ('RO', 'Romania'), ('RU', 'Russia'), ('RW', 'Rwanda'), ('BL', 'Saint Barthélemy'), ('SH', 'Saint Helena, Ascension and Tristan da Cunha'), ('KN', 'Saint Kitts and Nevis'), ('LC', 'Saint Lucia'), ('MF', 'Saint Martin (French part)'), ('PM', 'Saint Pierre and Miquelon'), ('VC', 'Saint Vincent and the Grenadines'), ('WS', 'Samoa'), ('SM', 'San Marino'), ('ST', 'Sao Tome and Principe'), ('SA', 'Saudi Arabia'), ('SN', 'Senegal'), ('RS', 'Serbia'), ('SC', 'Seychelles'), ('SL', 'Sierra Leone'), ('SG', 'Singapore'), ('SX', 'Sint Maarten (Dutch part)'), ('SK', 'Slovakia'), ('SI', 'Slovenia'), ('SB', 'Solomon Islands'), ('SO', 'Somalia'), ('ZA', 'South Africa'), ('GS', 'South Georgia and the South Sandwich Islands'), ('KR', 'South Korea'), ('SS', 'South Sudan'), ('ES', 'Spain'), ('LK', 'Sri Lanka'), ('SD', 'Sudan'), ('SR', 'Suriname'), ('SJ', 'Svalbard and Jan Mayen'), ('SE', 'Sweden'), ('CH', 'Switzerland'), ('SY', 'Syria'), ('TW', 'Taiwan'), ('TJ', 'Tajikistan'), ('TZ', 'Tanzania'), ('TH', 'Thailand'), ('TL', 'Timor-Leste'), ('TG', 'Togo'), ('TK', 'Tokelau'), ('TO', 'Tonga'), ('TT', 'Trinidad and Tobago'), ('TN', 'Tunisia'), ('TR', 'Turkey'), ('TM', 'Turkmenistan'), ('TC', 'Turks and Caicos Islands'), ('TV', 'Tuvalu'), ('UG', 'Uganda'), ('UA', 'Ukraine'), ('AE', 'United Arab Emirates'), ('GB', 'United Kingdom'), ('UM', 'United States Minor Outlying Islands'), ('US', 'United States of America'), ('UY', 'Uruguay'), ('UZ', 'Uzbekistan'), ('VU', 'Vanuatu'), ('VE', 'Venezuela'), ('VN', 'Vietnam'), ('VG', 'Virgin Islands (British)'), ('VI', 'Virgin Islands (U.S.)'), ('WF', 'Wallis and Futuna'), ('EH', 'Western Sahara'), ('YE', 'Yemen'), ('ZM', 'Zambia'), ('ZW', 'Zimbabwe')], default=servo.defaults.country, max_length=128, verbose_name='Purchase Country')),
+ ('sla_description', models.TextField(editable=False, null=True)),
+ ('has_onsite', models.BooleanField(default=False, help_text='Device is eligible for onsite repairs in GSX')),
+ ('contract_start_date', models.DateField(editable=False, null=True)),
+ ('contract_end_date', models.DateField(editable=False, null=True)),
+ ('onsite_start_date', models.DateField(editable=False, null=True)),
+ ('onsite_end_date', models.DateField(editable=False, null=True)),
+ ('parts_and_labor_covered', models.BooleanField(default=False, editable=False)),
+ ('notes', models.TextField(blank=True, default='', verbose_name='notes')),
+ ('photo', models.ImageField(blank=True, null=True, upload_to='devices', verbose_name='Photo')),
+ ('image_url', models.URLField(blank=True, null=True, verbose_name='Image URL')),
+ ('manual_url', models.URLField(blank=True, null=True, verbose_name='Manual URL')),
+ ('exploded_view_url', models.URLField(blank=True, null=True, verbose_name='Exploded View')),
+ ('is_vintage', models.BooleanField(default=False, help_text='Device is considered vintage in GSX', verbose_name='Vintage')),
+ ('fmip_active', models.BooleanField(default=False, editable=False)),
+ ],
+ options={
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='DeviceGroup',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(max_length=128, unique=True)),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Escalation',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('escalation_id', models.CharField(default='', editable=False, max_length=22)),
+ ('contexts', models.TextField(blank=True, default='{}')),
+ ('issue_type', models.CharField(blank=True, choices=[('AMQ', 'Account Management Question'), ('UQ', 'GSX Usage Question'), ('OSI', 'Order Status Issue'), ('PRI', 'Part Return Issue'), ('PPOR', 'Problem Placing Order/Repair'), ('PUR', 'Problem Updating Repair'), ('SCI', 'Shipping Carrier Issue'), ('SES', 'Service Excellence Scoring'), ('ARF', 'Apple Retail Feedback'), ('DF', 'Depot Feedback'), ('FS', 'GSX Feedback/Suggestion'), ('WS', 'GSX Web Services (API)'), ('SEPI', 'Service Excellence Program Information'), ('TTI', 'Technical or Troubleshooting Issue'), ('DTA', 'Diagnostic Tool Assistance'), ('BIQ', 'Billing or Invoice Question'), ('SESC', 'Safety Issue')], default='', max_length=4)),
+ ('status', models.CharField(choices=[('O', 'Open'), ('C', 'Closed'), ('E', 'Escalated')], default='O', max_length=1)),
+ ('submitted_at', models.DateTimeField(null=True)),
+ ('updated_at', models.DateTimeField(auto_now=True)),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ],
+ ),
+ migrations.CreateModel(
+ name='GsxAccount',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New GSX Account', max_length=128)),
+ ('sold_to', models.CharField(max_length=10, verbose_name='Sold-To')),
+ ('ship_to', models.CharField(max_length=10, verbose_name='Ship-To')),
+ ('user_id', models.CharField(blank=True, default='', max_length=128, verbose_name='User ID')),
+ ('region', models.CharField(choices=[('002', 'Asia/Pacific'), ('003', 'Japan'), ('004', 'Europe'), ('005', 'United States'), ('006', 'Canadia'), ('007', 'Latin America')], max_length=3, verbose_name='Region')),
+ ('timezone', models.CharField(choices=[('PST', 'UTC - 8h (Pacific Standard Time)'), ('PDT', 'UTC - 7h (Pacific Daylight Time)'), ('CST', 'UTC - 6h (Central Standard Time)'), ('CDT', 'UTC - 5h (Central Daylight Time)'), ('EST', 'UTC - 5h (Eastern Standard Time)'), ('EDT', 'UTC - 4h (Eastern Daylight Time)'), ('GMT', 'UTC (Greenwich Mean Time)'), ('CET', 'UTC + 1h (Central European Time)'), ('CEST', 'UTC + 2h (Central European Summer Time)'), ('USZ1', 'UTC + 3h (Kaliningrad Time)'), ('MSK', 'UTC + 4h (Moscow Time)'), ('IST', 'UTC + 5.5h (Indian Standard Time)'), ('YEKST', 'UTC + 6h (Yekaterinburg Time)'), ('OMSST', 'UTC + 7h (Omsk Time)'), ('KRAST', 'UTC + 8h (Krasnoyarsk Time)'), ('CCT', 'UTC + 8h (Chinese Coast Time)'), ('IRKST', 'UTC + 9h (Irkutsk Time)'), ('JST', 'UTC + 9h (Japan Standard Time)'), ('YAKST', 'UTC + 10h (Yakutsk Time)'), ('AEST', 'UTC + 10h (Australian Eastern Standard Time)'), ('VLAST', 'UTC + 11h (Vladivostok Time)'), ('AEDT', 'UTC + 11h (Australian Eastern Daylight Time)'), ('ACST', 'UTC + 9.5h (Austrailian Central Standard Time)'), ('ACDT', 'UTC + 10.5h (Australian Central Daylight Time)'), ('NZST', 'UTC + 12h (New Zealand Standard Time)'), ('MAGST', 'UTC + 12h (Magadan Time)')], default='CEST', max_length=8, verbose_name='Timezone')),
+ ('environment', models.CharField(choices=[('pr', 'Production'), ('ut', 'Development'), ('it', 'Testing')], default='pr', max_length=2, verbose_name='Environment')),
+ ],
+ options={
+ 'verbose_name': 'GSX Account',
+ 'verbose_name_plural': 'GSX Accounts',
+ 'ordering': ['title'],
+ 'get_latest_by': 'id',
+ 'unique_together': {('sold_to', 'ship_to', 'environment')},
+ },
+ ),
+ migrations.CreateModel(
+ name='Invoice',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('payment_method', models.IntegerField(choices=[(0, 'No Charge'), (1, 'Cash'), (2, 'Invoice'), (3, 'Credit Card'), (4, 'Mail payment'), (5, 'Online payment')], default=0, editable=False, verbose_name='Payment Method')),
+ ('is_paid', models.BooleanField(default=False, verbose_name='Paid')),
+ ('paid_at', models.DateTimeField(editable=False, null=True)),
+ ('customer_name', models.CharField(default='Walk-in', max_length=255, verbose_name='Name')),
+ ('customer_phone', models.CharField(blank=True, max_length=128, null=True, verbose_name='Phone')),
+ ('customer_email', models.CharField(blank=True, max_length=128, null=True, verbose_name='Email')),
+ ('customer_address', models.CharField(blank=True, max_length=255, null=True, verbose_name='Address')),
+ ('reference', models.CharField(blank=True, max_length=255, null=True, verbose_name='Reference')),
+ ('total_net', models.DecimalField(decimal_places=2, max_digits=8)),
+ ('total_tax', models.DecimalField(decimal_places=2, max_digits=8)),
+ ('total_gross', models.DecimalField(decimal_places=2, max_digits=8)),
+ ('total_margin', models.DecimalField(decimal_places=2, editable=False, max_digits=8)),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('customer', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.customer')),
+ ],
+ options={
+ 'ordering': ('-id',),
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='Location',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Location', max_length=255, unique=True, verbose_name='Name')),
+ ('phone', models.CharField(blank=True, default='', max_length=32, verbose_name='Phone')),
+ ('email', models.EmailField(blank=True, default='', max_length=254, verbose_name='Email')),
+ ('address', models.CharField(blank=True, default='', max_length=32, verbose_name='Address')),
+ ('zip_code', models.CharField(blank=True, default='', max_length=8, verbose_name='ZIP Code')),
+ ('city', models.CharField(blank=True, default='', max_length=16, verbose_name='City')),
+ ('timezone', models.CharField(choices=[('Africa/Abidjan', 'Africa/Abidjan'), ('Africa/Accra', 'Africa/Accra'), ('Africa/Addis_Ababa', 'Africa/Addis_Ababa'), ('Africa/Algiers', 'Africa/Algiers'), ('Africa/Asmara', 'Africa/Asmara'), ('Africa/Bamako', 'Africa/Bamako'), ('Africa/Bangui', 'Africa/Bangui'), ('Africa/Banjul', 'Africa/Banjul'), ('Africa/Bissau', 'Africa/Bissau'), ('Africa/Blantyre', 'Africa/Blantyre'), ('Africa/Brazzaville', 'Africa/Brazzaville'), ('Africa/Bujumbura', 'Africa/Bujumbura'), ('Africa/Cairo', 'Africa/Cairo'), ('Africa/Casablanca', 'Africa/Casablanca'), ('Africa/Ceuta', 'Africa/Ceuta'), ('Africa/Conakry', 'Africa/Conakry'), ('Africa/Dakar', 'Africa/Dakar'), ('Africa/Dar_es_Salaam', 'Africa/Dar_es_Salaam'), ('Africa/Djibouti', 'Africa/Djibouti'), ('Africa/Douala', 'Africa/Douala'), ('Africa/El_Aaiun', 'Africa/El_Aaiun'), ('Africa/Freetown', 'Africa/Freetown'), ('Africa/Gaborone', 'Africa/Gaborone'), ('Africa/Harare', 'Africa/Harare'), ('Africa/Johannesburg', 'Africa/Johannesburg'), ('Africa/Juba', 'Africa/Juba'), ('Africa/Kampala', 'Africa/Kampala'), ('Africa/Khartoum', 'Africa/Khartoum'), ('Africa/Kigali', 'Africa/Kigali'), ('Africa/Kinshasa', 'Africa/Kinshasa'), ('Africa/Lagos', 'Africa/Lagos'), ('Africa/Libreville', 'Africa/Libreville'), ('Africa/Lome', 'Africa/Lome'), ('Africa/Luanda', 'Africa/Luanda'), ('Africa/Lubumbashi', 'Africa/Lubumbashi'), ('Africa/Lusaka', 'Africa/Lusaka'), ('Africa/Malabo', 'Africa/Malabo'), ('Africa/Maputo', 'Africa/Maputo'), ('Africa/Maseru', 'Africa/Maseru'), ('Africa/Mbabane', 'Africa/Mbabane'), ('Africa/Mogadishu', 'Africa/Mogadishu'), ('Africa/Monrovia', 'Africa/Monrovia'), ('Africa/Nairobi', 'Africa/Nairobi'), ('Africa/Ndjamena', 'Africa/Ndjamena'), ('Africa/Niamey', 'Africa/Niamey'), ('Africa/Nouakchott', 'Africa/Nouakchott'), ('Africa/Ouagadougou', 'Africa/Ouagadougou'), ('Africa/Porto-Novo', 'Africa/Porto-Novo'), ('Africa/Sao_Tome', 'Africa/Sao_Tome'), ('Africa/Tripoli', 'Africa/Tripoli'), ('Africa/Tunis', 'Africa/Tunis'), ('Africa/Windhoek', 'Africa/Windhoek'), ('America/Adak', 'America/Adak'), ('America/Anchorage', 'America/Anchorage'), ('America/Anguilla', 'America/Anguilla'), ('America/Antigua', 'America/Antigua'), ('America/Araguaina', 'America/Araguaina'), ('America/Argentina/Buenos_Aires', 'America/Argentina/Buenos_Aires'), ('America/Argentina/Catamarca', 'America/Argentina/Catamarca'), ('America/Argentina/Cordoba', 'America/Argentina/Cordoba'), ('America/Argentina/Jujuy', 'America/Argentina/Jujuy'), ('America/Argentina/La_Rioja', 'America/Argentina/La_Rioja'), ('America/Argentina/Mendoza', 'America/Argentina/Mendoza'), ('America/Argentina/Rio_Gallegos', 'America/Argentina/Rio_Gallegos'), ('America/Argentina/Salta', 'America/Argentina/Salta'), ('America/Argentina/San_Juan', 'America/Argentina/San_Juan'), ('America/Argentina/San_Luis', 'America/Argentina/San_Luis'), ('America/Argentina/Tucuman', 'America/Argentina/Tucuman'), ('America/Argentina/Ushuaia', 'America/Argentina/Ushuaia'), ('America/Aruba', 'America/Aruba'), ('America/Asuncion', 'America/Asuncion'), ('America/Atikokan', 'America/Atikokan'), ('America/Bahia', 'America/Bahia'), ('America/Bahia_Banderas', 'America/Bahia_Banderas'), ('America/Barbados', 'America/Barbados'), ('America/Belem', 'America/Belem'), ('America/Belize', 'America/Belize'), ('America/Blanc-Sablon', 'America/Blanc-Sablon'), ('America/Boa_Vista', 'America/Boa_Vista'), ('America/Bogota', 'America/Bogota'), ('America/Boise', 'America/Boise'), ('America/Cambridge_Bay', 'America/Cambridge_Bay'), ('America/Campo_Grande', 'America/Campo_Grande'), ('America/Cancun', 'America/Cancun'), ('America/Caracas', 'America/Caracas'), ('America/Cayenne', 'America/Cayenne'), ('America/Cayman', 'America/Cayman'), ('America/Chicago', 'America/Chicago'), ('America/Chihuahua', 'America/Chihuahua'), ('America/Costa_Rica', 'America/Costa_Rica'), ('America/Creston', 'America/Creston'), ('America/Cuiaba', 'America/Cuiaba'), ('America/Curacao', 'America/Curacao'), ('America/Danmarkshavn', 'America/Danmarkshavn'), ('America/Dawson', 'America/Dawson'), ('America/Dawson_Creek', 'America/Dawson_Creek'), ('America/Denver', 'America/Denver'), ('America/Detroit', 'America/Detroit'), ('America/Dominica', 'America/Dominica'), ('America/Edmonton', 'America/Edmonton'), ('America/Eirunepe', 'America/Eirunepe'), ('America/El_Salvador', 'America/El_Salvador'), ('America/Fort_Nelson', 'America/Fort_Nelson'), ('America/Fortaleza', 'America/Fortaleza'), ('America/Glace_Bay', 'America/Glace_Bay'), ('America/Goose_Bay', 'America/Goose_Bay'), ('America/Grand_Turk', 'America/Grand_Turk'), ('America/Grenada', 'America/Grenada'), ('America/Guadeloupe', 'America/Guadeloupe'), ('America/Guatemala', 'America/Guatemala'), ('America/Guayaquil', 'America/Guayaquil'), ('America/Guyana', 'America/Guyana'), ('America/Halifax', 'America/Halifax'), ('America/Havana', 'America/Havana'), ('America/Hermosillo', 'America/Hermosillo'), ('America/Indiana/Indianapolis', 'America/Indiana/Indianapolis'), ('America/Indiana/Knox', 'America/Indiana/Knox'), ('America/Indiana/Marengo', 'America/Indiana/Marengo'), ('America/Indiana/Petersburg', 'America/Indiana/Petersburg'), ('America/Indiana/Tell_City', 'America/Indiana/Tell_City'), ('America/Indiana/Vevay', 'America/Indiana/Vevay'), ('America/Indiana/Vincennes', 'America/Indiana/Vincennes'), ('America/Indiana/Winamac', 'America/Indiana/Winamac'), ('America/Inuvik', 'America/Inuvik'), ('America/Iqaluit', 'America/Iqaluit'), ('America/Jamaica', 'America/Jamaica'), ('America/Juneau', 'America/Juneau'), ('America/Kentucky/Louisville', 'America/Kentucky/Louisville'), ('America/Kentucky/Monticello', 'America/Kentucky/Monticello'), ('America/Kralendijk', 'America/Kralendijk'), ('America/La_Paz', 'America/La_Paz'), ('America/Lima', 'America/Lima'), ('America/Los_Angeles', 'America/Los_Angeles'), ('America/Lower_Princes', 'America/Lower_Princes'), ('America/Maceio', 'America/Maceio'), ('America/Managua', 'America/Managua'), ('America/Manaus', 'America/Manaus'), ('America/Marigot', 'America/Marigot'), ('America/Martinique', 'America/Martinique'), ('America/Matamoros', 'America/Matamoros'), ('America/Mazatlan', 'America/Mazatlan'), ('America/Menominee', 'America/Menominee'), ('America/Merida', 'America/Merida'), ('America/Metlakatla', 'America/Metlakatla'), ('America/Mexico_City', 'America/Mexico_City'), ('America/Miquelon', 'America/Miquelon'), ('America/Moncton', 'America/Moncton'), ('America/Monterrey', 'America/Monterrey'), ('America/Montevideo', 'America/Montevideo'), ('America/Montserrat', 'America/Montserrat'), ('America/Nassau', 'America/Nassau'), ('America/New_York', 'America/New_York'), ('America/Nipigon', 'America/Nipigon'), ('America/Nome', 'America/Nome'), ('America/Noronha', 'America/Noronha'), ('America/North_Dakota/Beulah', 'America/North_Dakota/Beulah'), ('America/North_Dakota/Center', 'America/North_Dakota/Center'), ('America/North_Dakota/New_Salem', 'America/North_Dakota/New_Salem'), ('America/Nuuk', 'America/Nuuk'), ('America/Ojinaga', 'America/Ojinaga'), ('America/Panama', 'America/Panama'), ('America/Pangnirtung', 'America/Pangnirtung'), ('America/Paramaribo', 'America/Paramaribo'), ('America/Phoenix', 'America/Phoenix'), ('America/Port-au-Prince', 'America/Port-au-Prince'), ('America/Port_of_Spain', 'America/Port_of_Spain'), ('America/Porto_Velho', 'America/Porto_Velho'), ('America/Puerto_Rico', 'America/Puerto_Rico'), ('America/Punta_Arenas', 'America/Punta_Arenas'), ('America/Rainy_River', 'America/Rainy_River'), ('America/Rankin_Inlet', 'America/Rankin_Inlet'), ('America/Recife', 'America/Recife'), ('America/Regina', 'America/Regina'), ('America/Resolute', 'America/Resolute'), ('America/Rio_Branco', 'America/Rio_Branco'), ('America/Santarem', 'America/Santarem'), ('America/Santiago', 'America/Santiago'), ('America/Santo_Domingo', 'America/Santo_Domingo'), ('America/Sao_Paulo', 'America/Sao_Paulo'), ('America/Scoresbysund', 'America/Scoresbysund'), ('America/Sitka', 'America/Sitka'), ('America/St_Barthelemy', 'America/St_Barthelemy'), ('America/St_Johns', 'America/St_Johns'), ('America/St_Kitts', 'America/St_Kitts'), ('America/St_Lucia', 'America/St_Lucia'), ('America/St_Thomas', 'America/St_Thomas'), ('America/St_Vincent', 'America/St_Vincent'), ('America/Swift_Current', 'America/Swift_Current'), ('America/Tegucigalpa', 'America/Tegucigalpa'), ('America/Thule', 'America/Thule'), ('America/Thunder_Bay', 'America/Thunder_Bay'), ('America/Tijuana', 'America/Tijuana'), ('America/Toronto', 'America/Toronto'), ('America/Tortola', 'America/Tortola'), ('America/Vancouver', 'America/Vancouver'), ('America/Whitehorse', 'America/Whitehorse'), ('America/Winnipeg', 'America/Winnipeg'), ('America/Yakutat', 'America/Yakutat'), ('America/Yellowknife', 'America/Yellowknife'), ('Antarctica/Casey', 'Antarctica/Casey'), ('Antarctica/Davis', 'Antarctica/Davis'), ('Antarctica/DumontDUrville', 'Antarctica/DumontDUrville'), ('Antarctica/Macquarie', 'Antarctica/Macquarie'), ('Antarctica/Mawson', 'Antarctica/Mawson'), ('Antarctica/McMurdo', 'Antarctica/McMurdo'), ('Antarctica/Palmer', 'Antarctica/Palmer'), ('Antarctica/Rothera', 'Antarctica/Rothera'), ('Antarctica/Syowa', 'Antarctica/Syowa'), ('Antarctica/Troll', 'Antarctica/Troll'), ('Antarctica/Vostok', 'Antarctica/Vostok'), ('Arctic/Longyearbyen', 'Arctic/Longyearbyen'), ('Asia/Aden', 'Asia/Aden'), ('Asia/Almaty', 'Asia/Almaty'), ('Asia/Amman', 'Asia/Amman'), ('Asia/Anadyr', 'Asia/Anadyr'), ('Asia/Aqtau', 'Asia/Aqtau'), ('Asia/Aqtobe', 'Asia/Aqtobe'), ('Asia/Ashgabat', 'Asia/Ashgabat'), ('Asia/Atyrau', 'Asia/Atyrau'), ('Asia/Baghdad', 'Asia/Baghdad'), ('Asia/Bahrain', 'Asia/Bahrain'), ('Asia/Baku', 'Asia/Baku'), ('Asia/Bangkok', 'Asia/Bangkok'), ('Asia/Barnaul', 'Asia/Barnaul'), ('Asia/Beirut', 'Asia/Beirut'), ('Asia/Bishkek', 'Asia/Bishkek'), ('Asia/Brunei', 'Asia/Brunei'), ('Asia/Chita', 'Asia/Chita'), ('Asia/Choibalsan', 'Asia/Choibalsan'), ('Asia/Colombo', 'Asia/Colombo'), ('Asia/Damascus', 'Asia/Damascus'), ('Asia/Dhaka', 'Asia/Dhaka'), ('Asia/Dili', 'Asia/Dili'), ('Asia/Dubai', 'Asia/Dubai'), ('Asia/Dushanbe', 'Asia/Dushanbe'), ('Asia/Famagusta', 'Asia/Famagusta'), ('Asia/Gaza', 'Asia/Gaza'), ('Asia/Hebron', 'Asia/Hebron'), ('Asia/Ho_Chi_Minh', 'Asia/Ho_Chi_Minh'), ('Asia/Hong_Kong', 'Asia/Hong_Kong'), ('Asia/Hovd', 'Asia/Hovd'), ('Asia/Irkutsk', 'Asia/Irkutsk'), ('Asia/Jakarta', 'Asia/Jakarta'), ('Asia/Jayapura', 'Asia/Jayapura'), ('Asia/Jerusalem', 'Asia/Jerusalem'), ('Asia/Kabul', 'Asia/Kabul'), ('Asia/Kamchatka', 'Asia/Kamchatka'), ('Asia/Karachi', 'Asia/Karachi'), ('Asia/Kathmandu', 'Asia/Kathmandu'), ('Asia/Khandyga', 'Asia/Khandyga'), ('Asia/Kolkata', 'Asia/Kolkata'), ('Asia/Krasnoyarsk', 'Asia/Krasnoyarsk'), ('Asia/Kuala_Lumpur', 'Asia/Kuala_Lumpur'), ('Asia/Kuching', 'Asia/Kuching'), ('Asia/Kuwait', 'Asia/Kuwait'), ('Asia/Macau', 'Asia/Macau'), ('Asia/Magadan', 'Asia/Magadan'), ('Asia/Makassar', 'Asia/Makassar'), ('Asia/Manila', 'Asia/Manila'), ('Asia/Muscat', 'Asia/Muscat'), ('Asia/Nicosia', 'Asia/Nicosia'), ('Asia/Novokuznetsk', 'Asia/Novokuznetsk'), ('Asia/Novosibirsk', 'Asia/Novosibirsk'), ('Asia/Omsk', 'Asia/Omsk'), ('Asia/Oral', 'Asia/Oral'), ('Asia/Phnom_Penh', 'Asia/Phnom_Penh'), ('Asia/Pontianak', 'Asia/Pontianak'), ('Asia/Pyongyang', 'Asia/Pyongyang'), ('Asia/Qatar', 'Asia/Qatar'), ('Asia/Qostanay', 'Asia/Qostanay'), ('Asia/Qyzylorda', 'Asia/Qyzylorda'), ('Asia/Riyadh', 'Asia/Riyadh'), ('Asia/Sakhalin', 'Asia/Sakhalin'), ('Asia/Samarkand', 'Asia/Samarkand'), ('Asia/Seoul', 'Asia/Seoul'), ('Asia/Shanghai', 'Asia/Shanghai'), ('Asia/Singapore', 'Asia/Singapore'), ('Asia/Srednekolymsk', 'Asia/Srednekolymsk'), ('Asia/Taipei', 'Asia/Taipei'), ('Asia/Tashkent', 'Asia/Tashkent'), ('Asia/Tbilisi', 'Asia/Tbilisi'), ('Asia/Tehran', 'Asia/Tehran'), ('Asia/Thimphu', 'Asia/Thimphu'), ('Asia/Tokyo', 'Asia/Tokyo'), ('Asia/Tomsk', 'Asia/Tomsk'), ('Asia/Ulaanbaatar', 'Asia/Ulaanbaatar'), ('Asia/Urumqi', 'Asia/Urumqi'), ('Asia/Ust-Nera', 'Asia/Ust-Nera'), ('Asia/Vientiane', 'Asia/Vientiane'), ('Asia/Vladivostok', 'Asia/Vladivostok'), ('Asia/Yakutsk', 'Asia/Yakutsk'), ('Asia/Yangon', 'Asia/Yangon'), ('Asia/Yekaterinburg', 'Asia/Yekaterinburg'), ('Asia/Yerevan', 'Asia/Yerevan'), ('Atlantic/Azores', 'Atlantic/Azores'), ('Atlantic/Bermuda', 'Atlantic/Bermuda'), ('Atlantic/Canary', 'Atlantic/Canary'), ('Atlantic/Cape_Verde', 'Atlantic/Cape_Verde'), ('Atlantic/Faroe', 'Atlantic/Faroe'), ('Atlantic/Madeira', 'Atlantic/Madeira'), ('Atlantic/Reykjavik', 'Atlantic/Reykjavik'), ('Atlantic/South_Georgia', 'Atlantic/South_Georgia'), ('Atlantic/St_Helena', 'Atlantic/St_Helena'), ('Atlantic/Stanley', 'Atlantic/Stanley'), ('Australia/Adelaide', 'Australia/Adelaide'), ('Australia/Brisbane', 'Australia/Brisbane'), ('Australia/Broken_Hill', 'Australia/Broken_Hill'), ('Australia/Darwin', 'Australia/Darwin'), ('Australia/Eucla', 'Australia/Eucla'), ('Australia/Hobart', 'Australia/Hobart'), ('Australia/Lindeman', 'Australia/Lindeman'), ('Australia/Lord_Howe', 'Australia/Lord_Howe'), ('Australia/Melbourne', 'Australia/Melbourne'), ('Australia/Perth', 'Australia/Perth'), ('Australia/Sydney', 'Australia/Sydney'), ('Canada/Atlantic', 'Canada/Atlantic'), ('Canada/Central', 'Canada/Central'), ('Canada/Eastern', 'Canada/Eastern'), ('Canada/Mountain', 'Canada/Mountain'), ('Canada/Newfoundland', 'Canada/Newfoundland'), ('Canada/Pacific', 'Canada/Pacific'), ('Europe/Amsterdam', 'Europe/Amsterdam'), ('Europe/Andorra', 'Europe/Andorra'), ('Europe/Astrakhan', 'Europe/Astrakhan'), ('Europe/Athens', 'Europe/Athens'), ('Europe/Belgrade', 'Europe/Belgrade'), ('Europe/Berlin', 'Europe/Berlin'), ('Europe/Bratislava', 'Europe/Bratislava'), ('Europe/Brussels', 'Europe/Brussels'), ('Europe/Bucharest', 'Europe/Bucharest'), ('Europe/Budapest', 'Europe/Budapest'), ('Europe/Busingen', 'Europe/Busingen'), ('Europe/Chisinau', 'Europe/Chisinau'), ('Europe/Copenhagen', 'Europe/Copenhagen'), ('Europe/Dublin', 'Europe/Dublin'), ('Europe/Gibraltar', 'Europe/Gibraltar'), ('Europe/Guernsey', 'Europe/Guernsey'), ('Europe/Helsinki', 'Europe/Helsinki'), ('Europe/Isle_of_Man', 'Europe/Isle_of_Man'), ('Europe/Istanbul', 'Europe/Istanbul'), ('Europe/Jersey', 'Europe/Jersey'), ('Europe/Kaliningrad', 'Europe/Kaliningrad'), ('Europe/Kiev', 'Europe/Kiev'), ('Europe/Kirov', 'Europe/Kirov'), ('Europe/Lisbon', 'Europe/Lisbon'), ('Europe/Ljubljana', 'Europe/Ljubljana'), ('Europe/London', 'Europe/London'), ('Europe/Luxembourg', 'Europe/Luxembourg'), ('Europe/Madrid', 'Europe/Madrid'), ('Europe/Malta', 'Europe/Malta'), ('Europe/Mariehamn', 'Europe/Mariehamn'), ('Europe/Minsk', 'Europe/Minsk'), ('Europe/Monaco', 'Europe/Monaco'), ('Europe/Moscow', 'Europe/Moscow'), ('Europe/Oslo', 'Europe/Oslo'), ('Europe/Paris', 'Europe/Paris'), ('Europe/Podgorica', 'Europe/Podgorica'), ('Europe/Prague', 'Europe/Prague'), ('Europe/Riga', 'Europe/Riga'), ('Europe/Rome', 'Europe/Rome'), ('Europe/Samara', 'Europe/Samara'), ('Europe/San_Marino', 'Europe/San_Marino'), ('Europe/Sarajevo', 'Europe/Sarajevo'), ('Europe/Saratov', 'Europe/Saratov'), ('Europe/Simferopol', 'Europe/Simferopol'), ('Europe/Skopje', 'Europe/Skopje'), ('Europe/Sofia', 'Europe/Sofia'), ('Europe/Stockholm', 'Europe/Stockholm'), ('Europe/Tallinn', 'Europe/Tallinn'), ('Europe/Tirane', 'Europe/Tirane'), ('Europe/Ulyanovsk', 'Europe/Ulyanovsk'), ('Europe/Uzhgorod', 'Europe/Uzhgorod'), ('Europe/Vaduz', 'Europe/Vaduz'), ('Europe/Vatican', 'Europe/Vatican'), ('Europe/Vienna', 'Europe/Vienna'), ('Europe/Vilnius', 'Europe/Vilnius'), ('Europe/Volgograd', 'Europe/Volgograd'), ('Europe/Warsaw', 'Europe/Warsaw'), ('Europe/Zagreb', 'Europe/Zagreb'), ('Europe/Zaporozhye', 'Europe/Zaporozhye'), ('Europe/Zurich', 'Europe/Zurich'), ('GMT', 'GMT'), ('Indian/Antananarivo', 'Indian/Antananarivo'), ('Indian/Chagos', 'Indian/Chagos'), ('Indian/Christmas', 'Indian/Christmas'), ('Indian/Cocos', 'Indian/Cocos'), ('Indian/Comoro', 'Indian/Comoro'), ('Indian/Kerguelen', 'Indian/Kerguelen'), ('Indian/Mahe', 'Indian/Mahe'), ('Indian/Maldives', 'Indian/Maldives'), ('Indian/Mauritius', 'Indian/Mauritius'), ('Indian/Mayotte', 'Indian/Mayotte'), ('Indian/Reunion', 'Indian/Reunion'), ('Pacific/Apia', 'Pacific/Apia'), ('Pacific/Auckland', 'Pacific/Auckland'), ('Pacific/Bougainville', 'Pacific/Bougainville'), ('Pacific/Chatham', 'Pacific/Chatham'), ('Pacific/Chuuk', 'Pacific/Chuuk'), ('Pacific/Easter', 'Pacific/Easter'), ('Pacific/Efate', 'Pacific/Efate'), ('Pacific/Enderbury', 'Pacific/Enderbury'), ('Pacific/Fakaofo', 'Pacific/Fakaofo'), ('Pacific/Fiji', 'Pacific/Fiji'), ('Pacific/Funafuti', 'Pacific/Funafuti'), ('Pacific/Galapagos', 'Pacific/Galapagos'), ('Pacific/Gambier', 'Pacific/Gambier'), ('Pacific/Guadalcanal', 'Pacific/Guadalcanal'), ('Pacific/Guam', 'Pacific/Guam'), ('Pacific/Honolulu', 'Pacific/Honolulu'), ('Pacific/Kiritimati', 'Pacific/Kiritimati'), ('Pacific/Kosrae', 'Pacific/Kosrae'), ('Pacific/Kwajalein', 'Pacific/Kwajalein'), ('Pacific/Majuro', 'Pacific/Majuro'), ('Pacific/Marquesas', 'Pacific/Marquesas'), ('Pacific/Midway', 'Pacific/Midway'), ('Pacific/Nauru', 'Pacific/Nauru'), ('Pacific/Niue', 'Pacific/Niue'), ('Pacific/Norfolk', 'Pacific/Norfolk'), ('Pacific/Noumea', 'Pacific/Noumea'), ('Pacific/Pago_Pago', 'Pacific/Pago_Pago'), ('Pacific/Palau', 'Pacific/Palau'), ('Pacific/Pitcairn', 'Pacific/Pitcairn'), ('Pacific/Pohnpei', 'Pacific/Pohnpei'), ('Pacific/Port_Moresby', 'Pacific/Port_Moresby'), ('Pacific/Rarotonga', 'Pacific/Rarotonga'), ('Pacific/Saipan', 'Pacific/Saipan'), ('Pacific/Tahiti', 'Pacific/Tahiti'), ('Pacific/Tarawa', 'Pacific/Tarawa'), ('Pacific/Tongatapu', 'Pacific/Tongatapu'), ('Pacific/Wake', 'Pacific/Wake'), ('Pacific/Wallis', 'Pacific/Wallis'), ('US/Alaska', 'US/Alaska'), ('US/Arizona', 'US/Arizona'), ('US/Central', 'US/Central'), ('US/Eastern', 'US/Eastern'), ('US/Hawaii', 'US/Hawaii'), ('US/Mountain', 'US/Mountain'), ('US/Pacific', 'US/Pacific'), ('UTC', 'UTC')], default='UTC', max_length=128, verbose_name='Time zone')),
+ ('gsx_shipto', models.CharField(blank=True, default='', max_length=10, verbose_name='Ship-To')),
+ ('gsx_tz', models.CharField(choices=[('PST', 'UTC - 8h (Pacific Standard Time)'), ('PDT', 'UTC - 7h (Pacific Daylight Time)'), ('CST', 'UTC - 6h (Central Standard Time)'), ('CDT', 'UTC - 5h (Central Daylight Time)'), ('EST', 'UTC - 5h (Eastern Standard Time)'), ('EDT', 'UTC - 4h (Eastern Daylight Time)'), ('GMT', 'UTC (Greenwich Mean Time)'), ('CET', 'UTC + 1h (Central European Time)'), ('CEST', 'UTC + 2h (Central European Summer Time)'), ('USZ1', 'UTC + 3h (Kaliningrad Time)'), ('MSK', 'UTC + 4h (Moscow Time)'), ('IST', 'UTC + 5.5h (Indian Standard Time)'), ('YEKST', 'UTC + 6h (Yekaterinburg Time)'), ('OMSST', 'UTC + 7h (Omsk Time)'), ('KRAST', 'UTC + 8h (Krasnoyarsk Time)'), ('CCT', 'UTC + 8h (Chinese Coast Time)'), ('IRKST', 'UTC + 9h (Irkutsk Time)'), ('JST', 'UTC + 9h (Japan Standard Time)'), ('YAKST', 'UTC + 10h (Yakutsk Time)'), ('AEST', 'UTC + 10h (Australian Eastern Standard Time)'), ('VLAST', 'UTC + 11h (Vladivostok Time)'), ('AEDT', 'UTC + 11h (Australian Eastern Daylight Time)'), ('ACST', 'UTC + 9.5h (Austrailian Central Standard Time)'), ('ACDT', 'UTC + 10.5h (Australian Central Daylight Time)'), ('NZST', 'UTC + 12h (New Zealand Standard Time)'), ('MAGST', 'UTC + 12h (Magadan Time)')], default='CEST', max_length=8, verbose_name='Timezone')),
+ ('notes', models.TextField(blank=True, default='Business hours between 9:00 - 18:00', help_text='Will be shown on print templates', verbose_name='Notes')),
+ ('enabled', models.BooleanField(default=True, verbose_name='Enabled')),
+ ('checkin', models.BooleanField(default=True, verbose_name='Use for check-in')),
+ ('gsx_accounts', models.ManyToManyField(blank=True, to='servo.GsxAccount', verbose_name='Accounts')),
+ ('manager', models.ForeignKey(blank=True, limit_choices_to={'is_visible': True}, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='managed_locations', to=settings.AUTH_USER_MODEL)),
+ ],
+ options={
+ 'verbose_name': 'Location',
+ 'verbose_name_plural': 'Locations',
+ 'ordering': ('title',),
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='Notification',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('kind', models.CharField(max_length=16)),
+ ('action', models.CharField(max_length=16)),
+ ('message', models.TextField()),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Order',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('code', models.CharField(max_length=8, null=True, unique=True)),
+ ('url_code', models.CharField(max_length=8, null=True, unique=True)),
+ ('description', models.CharField(default='', max_length=128)),
+ ('status_icon', models.CharField(default='undefined', max_length=16)),
+ ('priority', models.IntegerField(choices=[(2, 'High'), (1, 'Normal'), (0, 'Low')], default=1, verbose_name='priority')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('started_at', models.DateTimeField(null=True)),
+ ('closed_at', models.DateTimeField(null=True)),
+ ('place', models.CharField(default='', max_length=128)),
+ ('customer_name', models.CharField(default='', max_length=128)),
+ ('state', models.IntegerField(choices=[(0, 'Unassigned'), (1, 'Open'), (2, 'Closed'), (3, 'Waiting')], default=0)),
+ ('status_name', models.CharField(default='', max_length=128)),
+ ('status_started_at', models.DateTimeField(null=True)),
+ ('status_limit_green', models.DateTimeField(null=True)),
+ ('status_limit_yellow', models.DateTimeField(null=True)),
+ ('checkin_location', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.location')),
+ ('checkout_location', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.location')),
+ ('closed_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='closed_orders', to=settings.AUTH_USER_MODEL)),
+ ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_orders', to=settings.AUTH_USER_MODEL)),
+ ('customer', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='orders', to='servo.customer')),
+ ],
+ options={
+ 'ordering': ('-priority', 'id'),
+ 'permissions': (('change_user', 'Can set assignee'), ('change_status', 'Can change status'), ('follow_order', 'Can follow order'), ('copy_order', 'Can copy order'), ('batch_process', 'Can batch process')),
+ },
+ ),
+ migrations.CreateModel(
+ name='Product',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('code', models.CharField(default=servo.lib.shorturl.from_time, max_length=32, unique=True, verbose_name='Code')),
+ ('subst_code', models.CharField(default='', editable=False, max_length=32, verbose_name='Substituted (new) code of this part')),
+ ('title', models.CharField(default='New Product', max_length=255, verbose_name='Title')),
+ ('description', models.TextField(blank=True, default='', verbose_name='Description')),
+ ('pct_vat', models.DecimalField(decimal_places=2, default=servo.models.product.default_vat, max_digits=4, verbose_name='VAT %')),
+ ('fixed_price', models.BooleanField(default=False, help_text="Don't update price when recalculating prices or importing parts")),
+ ('price_purchase_exchange', models.DecimalField(decimal_places=2, default=0, max_digits=8, verbose_name='Purchase price')),
+ ('pct_margin_exchange', models.DecimalField(decimal_places=2, default=servo.models.product.get_margin, max_digits=4, verbose_name='Margin %')),
+ ('price_notax_exchange', models.DecimalField(decimal_places=2, default=0, help_text='Purchase price + margin %', max_digits=8, verbose_name='Net price')),
+ ('price_sales_exchange', models.DecimalField(decimal_places=2, default=0, help_text='Purchase price + margin % + shipping + VAT %', max_digits=8, verbose_name='Sales price')),
+ ('price_purchase_stock', models.DecimalField(decimal_places=2, default=0, max_digits=8, verbose_name='Purchase price')),
+ ('pct_margin_stock', models.DecimalField(decimal_places=2, default=servo.models.product.get_margin, max_digits=4, verbose_name='Margin %')),
+ ('price_notax_stock', models.DecimalField(decimal_places=2, default=0, help_text='Purchase price + margin %', max_digits=8, verbose_name='Net price')),
+ ('price_sales_stock', models.DecimalField(decimal_places=2, default=0, help_text='Purchase price + margin % + shipping + VAT %', max_digits=8, verbose_name='Sales price')),
+ ('is_serialized', models.BooleanField(default=False, help_text='Product has a serial number', verbose_name='Is serialized')),
+ ('warranty_period', models.PositiveIntegerField(default=0, verbose_name='Warranty (months)')),
+ ('shelf', models.CharField(blank=True, default='', max_length=8, verbose_name='Shelf code')),
+ ('brand', models.CharField(blank=True, default='', max_length=32, verbose_name='Brand')),
+ ('photo', models.ImageField(blank=True, null=True, upload_to='products', verbose_name='Photo')),
+ ('shipping', models.FloatField(default=0, verbose_name='Shipping')),
+ ('component_code', models.CharField(blank=True, choices=[('0', 'General'), ('1', 'Visual'), ('2', 'Displays'), ('3', 'Mass Storage'), ('4', 'Input Devices'), ('5', 'Boards'), ('6', 'Power'), ('7', 'Printer'), ('8', 'Multi-function Device'), ('9', 'Communication Devices'), ('A', 'Share'), ('B', 'iPhone'), ('E', 'iPod'), ('F', 'iPad'), ('G', 'Beats Products'), ('W', 'Apple Watch')], default='', max_length=1, verbose_name='Component group')),
+ ('labour_tier', models.CharField(blank=True, default='', max_length=15)),
+ ('part_type', models.CharField(choices=[('ADJUSTMENT', 'Adjustment'), ('MODULE', 'Module'), ('REPLACEMENT', 'Replacement'), ('SERVICE', 'Service'), ('SERVICE CONTRACT', 'Service Contract'), ('OTHER', 'Other')], default='OTHER', max_length=18, verbose_name='Part type')),
+ ('eee_code', models.CharField(blank=True, default='', max_length=256, verbose_name='EEE code')),
+ ('total_amount', models.IntegerField(default=0, editable=False)),
+ ],
+ options={
+ 'ordering': ('-id',),
+ 'permissions': (('change_amount', 'Can change product amount'),),
+ },
+ ),
+ migrations.CreateModel(
+ name='Property',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Field', max_length=255, verbose_name='title')),
+ ('type', models.CharField(choices=[('customer', 'Customer'), ('order', 'Order'), ('product', 'Product')], default=('customer', 'Customer'), max_length=32, verbose_name='type')),
+ ('format', models.CharField(blank=True, default='', max_length=32, verbose_name='format')),
+ ('value', models.TextField(blank=True, default='', verbose_name='value')),
+ ],
+ options={
+ 'verbose_name': 'Field',
+ 'verbose_name_plural': 'Fields',
+ 'ordering': ['title'],
+ },
+ ),
+ migrations.CreateModel(
+ name='PurchaseOrder',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('reference', models.CharField(blank=True, default='', max_length=32, verbose_name='Reference')),
+ ('confirmation', models.CharField(blank=True, default='', max_length=32, verbose_name='Confirmation')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('submitted_at', models.DateTimeField(editable=False, null=True)),
+ ('supplier', models.CharField(blank=True, max_length=32, verbose_name='Supplier')),
+ ('carrier', models.CharField(blank=True, max_length=32, verbose_name='Carrier')),
+ ('tracking_id', models.CharField(blank=True, max_length=128, verbose_name='Tracking ID')),
+ ('days_delivered', models.IntegerField(blank=True, default=1, verbose_name='Delivery Time')),
+ ('has_arrived', models.BooleanField(default=False)),
+ ('total', models.FloatField(editable=False, null=True)),
+ ('invoice_id', models.CharField(default='', editable=False, max_length=10)),
+ ('invoice', models.FileField(editable=False, help_text="Apple's sales invoice for this PO", null=True, upload_to='gsx_invoices')),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('location', models.ForeignKey(editable=False, help_text='The location from which this PO was created', null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.location')),
+ ('sales_order', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.order')),
+ ],
+ options={
+ 'ordering': ('-id',),
+ },
+ ),
+ migrations.CreateModel(
+ name='Queue',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Queue', max_length=255, unique=True, verbose_name='Title')),
+ ('keywords', models.TextField(blank=True, default='', help_text='Orders with devices matching these keywords will be automatically assigned to this queue')),
+ ('description', models.TextField(blank=True, verbose_name='description')),
+ ('priority', models.IntegerField(choices=[(2, 'High'), (1, 'Normal'), (0, 'Low')], default=1, verbose_name='priority')),
+ ('gsx_soldto', models.CharField(blank=True, default='', help_text='GSX queries of an order in this queue will be made using this Sold-To', max_length=10, verbose_name='Sold-To')),
+ ('order_template', models.FileField(blank=True, help_text='HTML template for Service Order/Work Confirmation', null=True, upload_to='templates', verbose_name='order template')),
+ ('quote_template', models.FileField(blank=True, help_text='HTML template for cost estimate', null=True, upload_to='templates', verbose_name='quote template')),
+ ('receipt_template', models.FileField(blank=True, help_text='HTML template for Sales Order Receipt', null=True, upload_to='templates', verbose_name='receipt template')),
+ ('dispatch_template', models.FileField(blank=True, help_text='HTML template for dispatched order', null=True, upload_to='templates', verbose_name='dispatch template')),
+ ('locations', models.ManyToManyField(help_text='Pick the locations you want this queue to appear in.', to='servo.Location', verbose_name='locations')),
+ ],
+ options={
+ 'verbose_name': 'Queue',
+ 'verbose_name_plural': 'Queues',
+ 'ordering': ['title'],
+ },
+ ),
+ migrations.CreateModel(
+ name='QueueStatus',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('limit_green', models.IntegerField(default=1, verbose_name='Green limit')),
+ ('limit_yellow', models.IntegerField(default=15, verbose_name='Yellow limit')),
+ ('limit_factor', models.IntegerField(choices=[(60, 'Minutes'), (3600, 'Hours'), (86400, 'Days'), (604800, 'Weeks'), (2419200, 'Months')], default=60, verbose_name='Time unit')),
+ ('idx', models.IntegerField(default=1, verbose_name='Ordering')),
+ ('queue', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.queue')),
+ ],
+ options={
+ 'ordering': ('idx',),
+ },
+ ),
+ migrations.CreateModel(
+ name='Repair',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('tech_id', models.CharField(blank=True, default='', max_length=15, verbose_name='Technician')),
+ ('unit_received_at', models.DateTimeField(default=django.utils.timezone.now, verbose_name='Unit Received')),
+ ('submitted_at', models.DateTimeField(editable=False, null=True)),
+ ('completed_at', models.DateTimeField(editable=False, null=True)),
+ ('request_review', models.BooleanField(default=False, help_text='Repair should be reviewed by Apple before confirmation')),
+ ('confirmation', models.CharField(default='', editable=False, max_length=15)),
+ ('reference', models.CharField(blank=True, default='', max_length=16, verbose_name='Reference')),
+ ('symptom', models.TextField()),
+ ('diagnosis', models.TextField()),
+ ('notes', models.TextField(blank=True, default='', help_text='Notes are mandatory when requesting review.', validators=[django.core.validators.MaxLengthValidator(800)])),
+ ('status', models.CharField(default='', editable=False, max_length=128)),
+ ('status_code', models.CharField(choices=[('AWTP', 'Awaiting Parts'), ('AWTR', 'Parts Allocated'), ('BEGR', 'In Repair'), ('RFPU', 'Ready for Pickup')], default='', editable=False, max_length=4)),
+ ('attachment', models.FileField(blank=True, help_text='Choose files to be sent with the repair creation request', null=True, upload_to='repairs')),
+ ('repair_number', models.CharField(default='', editable=False, max_length=12)),
+ ('mark_complete', models.BooleanField(blank=True, default=False, help_text='Requires replacement serial number', verbose_name='mark complete')),
+ ('replacement_sn', models.CharField(blank=True, default='', help_text='Serial Number of replacement part', max_length=18, verbose_name='New serial number')),
+ ('repair_type', models.CharField(choices=[('CA', 'Carry-In/Non-Replinished'), ('NE', 'Return Before Replace'), ('NT', 'No Trouble Found'), ('ON', 'Onsite (Indirect/Direct)'), ('RR', 'Repair Or Replace/Whole Unit Mail-In'), ('WH', 'Mail-In')], default='CA', editable=False, max_length=2)),
+ ('component_data', models.TextField(default='', editable=False)),
+ ('consumer_law', models.BooleanField(default=None, help_text='Repair is eligible for consumer law coverage', null=True)),
+ ('acplus', models.BooleanField(default=None, help_text='Repair is covered by AppleCare+', null=True, verbose_name='AppleCare+')),
+ ('symptom_code', models.CharField(default='', max_length=7)),
+ ('issue_code', models.CharField(default='', max_length=7)),
+ ('completed_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='completed_repairs', to=settings.AUTH_USER_MODEL)),
+ ('created_by', models.ForeignKey(editable=False, on_delete=django.db.models.deletion.PROTECT, related_name='created_repairs', to=settings.AUTH_USER_MODEL)),
+ ('device', models.ForeignKey(editable=False, on_delete=django.db.models.deletion.PROTECT, to='servo.device')),
+ ('gsx_account', models.ForeignKey(editable=False, on_delete=django.db.models.deletion.PROTECT, to='servo.gsxaccount')),
+ ('order', models.ForeignKey(editable=False, on_delete=django.db.models.deletion.PROTECT, to='servo.order')),
+ ],
+ options={
+ 'get_latest_by': 'created_at',
+ },
+ ),
+ migrations.CreateModel(
+ name='Rule',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('description', models.CharField(default='New Rule', max_length=128)),
+ ('match', models.CharField(choices=[('ANY', 'Any'), ('ALL', 'All')], default='ANY', max_length=3)),
+ ],
+ options={
+ 'abstract': False,
+ },
+ ),
+ migrations.CreateModel(
+ name='Search',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('query', models.TextField()),
+ ('model', models.CharField(max_length=32)),
+ ('title', models.CharField(max_length=128)),
+ ('shared', models.BooleanField(default=True)),
+ ],
+ ),
+ migrations.CreateModel(
+ name='ServiceOrderItem',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('code', models.CharField(blank=True, default='', max_length=128)),
+ ('title', models.CharField(max_length=128, verbose_name='title')),
+ ('description', models.TextField(blank=True, default='', verbose_name='description')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('amount', models.IntegerField(default=1, verbose_name='amount')),
+ ('sn', models.CharField(blank=True, default='', max_length=32, verbose_name='KGB Serial Number')),
+ ('dispatched', models.BooleanField(default=False, verbose_name='dispatched')),
+ ('should_report', models.BooleanField(default=True, verbose_name='report')),
+ ('price', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='sales price')),
+ ('replaced_at', models.DateTimeField(null=True)),
+ ('kbb_sn', models.CharField(blank=True, default='', max_length=32, verbose_name='KBB Serial Number')),
+ ('imei', models.CharField(blank=True, default='', max_length=35, verbose_name='IMEI')),
+ ('price_category', models.CharField(choices=[('warranty', 'Warranty'), ('exchange', 'Exchange Price'), ('stock', 'Stock Price')], default=('warranty', 'Warranty'), max_length=32, verbose_name='Price category')),
+ ('comptia_code', models.CharField(blank=True, default='', max_length=4, verbose_name='Symptom code')),
+ ('comptia_modifier', models.CharField(blank=True, default='', max_length=1, verbose_name='Symptom modifier')),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.order')),
+ ('product', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='servo.product')),
+ ('replaced_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='replaced_parts', to=settings.AUTH_USER_MODEL)),
+ ],
+ options={
+ 'ordering': ('id',),
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='ShippingMethod',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Shipping Method', max_length=128)),
+ ('description', models.TextField(blank=True, default='')),
+ ('notify_email', models.EmailField(blank=True, max_length=254, null=True)),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Template',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Template', max_length=128, unique=True, verbose_name='Title')),
+ ('content', models.TextField(verbose_name='Content')),
+ ],
+ options={
+ 'verbose_name': 'Template',
+ 'verbose_name_plural': 'Templates',
+ 'ordering': ['title'],
+ },
+ ),
+ migrations.CreateModel(
+ name='UserGroup',
+ fields=[
+ ('group_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='auth.group')),
+ ],
+ bases=('auth.group',),
+ managers=[
+ ('objects', django.contrib.auth.models.GroupManager()),
+ ],
+ ),
+ migrations.CreateModel(
+ name='TaggedItem',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('ref', models.CharField(max_length=32)),
+ ('ref_id', models.IntegerField()),
+ ('tag', models.CharField(max_length=128)),
+ ('slug', models.SlugField()),
+ ('color', models.CharField(default='', max_length=8)),
+ ],
+ options={
+ 'unique_together': {('ref', 'ref_id', 'tag')},
+ },
+ ),
+ migrations.CreateModel(
+ name='Tag',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Tag', max_length=255, unique=True, verbose_name='name')),
+ ('type', models.CharField(choices=[('device', 'Device'), ('order', 'Order'), ('note', 'Note'), ('other', 'Other')], max_length=32, verbose_name='type')),
+ ('times_used', models.IntegerField(default=0, editable=False)),
+ ('color', models.CharField(blank=True, choices=[('default', 'Default'), ('success', 'Green'), ('warning', 'Orange'), ('important', 'Red'), ('info', 'Blue')], default='default', max_length=16, null=True)),
+ ('lft', models.PositiveIntegerField(editable=False)),
+ ('rght', models.PositiveIntegerField(editable=False)),
+ ('tree_id', models.PositiveIntegerField(db_index=True, editable=False)),
+ ('level', models.PositiveIntegerField(editable=False)),
+ ('parent', mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='children', to='servo.tag')),
+ ],
+ options={
+ 'verbose_name': 'Tag',
+ 'verbose_name_plural': 'Tags',
+ },
+ ),
+ migrations.CreateModel(
+ name='Status',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Status', max_length=255, verbose_name='name')),
+ ('description', models.TextField(blank=True, null=True, verbose_name='description')),
+ ('limit_green', models.IntegerField(default=1, verbose_name='green limit')),
+ ('limit_yellow', models.IntegerField(default=15, verbose_name='yellow limit')),
+ ('limit_factor', models.IntegerField(choices=[(60, 'Minutes'), (3600, 'Hours'), (86400, 'Days'), (604800, 'Weeks'), (2419200, 'Months')], default=(60, 'Minutes'), verbose_name='time unit')),
+ ('queue', models.ManyToManyField(editable=False, through='servo.QueueStatus', to='servo.Queue')),
+ ],
+ options={
+ 'verbose_name': 'Status',
+ 'verbose_name_plural': 'Statuses',
+ 'ordering': ('title',),
+ },
+ ),
+ migrations.CreateModel(
+ name='Shipment',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('ship_to', models.CharField(default='', editable=False, max_length=10)),
+ ('return_id', models.CharField(editable=False, help_text='The return ID returned by GSX', max_length=10, null=True, unique=True)),
+ ('tracking_id', models.CharField(blank=True, default='', help_text="Carrier's tracking ID", max_length=30, verbose_name='Tracking ID')),
+ ('tracking_url', models.URLField(editable=False, help_text='The tracking URL returned by GSX', null=True)),
+ ('packing_list', models.FileField(editable=False, help_text='The PDF returned by GSX', null=True, upload_to='returns')),
+ ('carrier', models.CharField(blank=True, choices=[('XAER', 'Aero 2000'), ('XAIRBEC', 'Airborne'), ('XAIRB', 'Airborne'), ('XARM', 'Aramex'), ('XOZP', 'Australia Post'), ('XBAX', 'BAX GLOBAL PTE LTD'), ('XCPW', 'CPW Internal'), ('XCL', 'Citylink'), ('XDHL', 'DHL'), ('XDHLC', 'DHL'), ('XDZNA', 'Danzas-AEI'), ('XEAS', 'EAS'), ('XEGL', 'Eagle ASIA PACIFIC HOLDINGS'), ('XEXXN', 'Exel'), ('XFEDE', 'FedEx'), ('XFDE', 'FedEx Air'), ('XGLS', 'GLS-General Logistics Systems'), ('XHNF', 'H and Friends'), ('XNGLN', 'Nightline'), ('XPL', 'Parceline'), ('XPRLA', 'Purolator'), ('SDS', 'SDS An Post'), ('XSNO', 'Seino Transportation Co. Ltd.'), ('XSTE', 'Star Track Express'), ('XTNT', 'TNT'), ('XUPSN', 'UPS'), ('XUTI', 'UTi (Japan) K.K.'), ('XYMT', 'YAMATO')], default='', max_length=18, verbose_name='Carrier')),
+ ('created_at', models.DateTimeField(auto_now=True)),
+ ('dispatched_at', models.DateTimeField(editable=False, null=True)),
+ ('width', models.PositiveIntegerField(blank=True, null=True, verbose_name='width')),
+ ('height', models.PositiveIntegerField(blank=True, null=True, verbose_name='height')),
+ ('length', models.PositiveIntegerField(blank=True, null=True, verbose_name='length')),
+ ('weight', models.PositiveIntegerField(blank=True, null=True, verbose_name='weight')),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_shipments', to=settings.AUTH_USER_MODEL)),
+ ('dispatched_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='dispatched_shipments', to=settings.AUTH_USER_MODEL)),
+ ('location', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.location')),
+ ],
+ options={
+ 'ordering': ('-dispatched_at',),
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='ServicePart',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('comptia_code', models.CharField(editable=False, max_length=4, verbose_name='Symptom Code')),
+ ('comptia_modifier', models.CharField(editable=False, max_length=1, verbose_name='Symptom Modifier')),
+ ('line_number', models.SmallIntegerField(editable=False, null=True)),
+ ('registered_for_return', models.BooleanField(default=False)),
+ ('returned_at', models.DateTimeField(editable=False, null=True)),
+ ('ship_to', models.CharField(editable=False, max_length=18)),
+ ('part_title', models.CharField(max_length=128)),
+ ('part_number', models.CharField(max_length=18)),
+ ('service_order', models.CharField(max_length=10)),
+ ('return_order', models.CharField(default='', max_length=10)),
+ ('return_status', models.CharField(default='', editable=False, max_length=128)),
+ ('return_code', models.CharField(default='', editable=False, max_length=4)),
+ ('order_status', models.CharField(default='', editable=False, max_length=128)),
+ ('order_status_code', models.CharField(default='', editable=False, max_length=4)),
+ ('coverage_description', models.CharField(default='', editable=False, max_length=128)),
+ ('box_number', models.PositiveIntegerField(null=True)),
+ ('return_label', models.FileField(editable=False, null=True, upload_to='return_labels')),
+ ('carrier_url', models.CharField(default='', editable=False, max_length=255)),
+ ('order_item', models.ForeignKey(editable=False, on_delete=django.db.models.deletion.CASCADE, to='servo.serviceorderitem')),
+ ('purchase_order', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.purchaseorder')),
+ ('repair', models.ForeignKey(editable=False, on_delete=django.db.models.deletion.CASCADE, to='servo.repair')),
+ ('shipment', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.shipment')),
+ ],
+ options={
+ 'ordering': ('order_item',),
+ 'get_latest_by': 'id',
+ 'unique_together': {('id', 'shipment')},
+ },
+ ),
+ migrations.AddField(
+ model_name='repair',
+ name='parts',
+ field=models.ManyToManyField(through='servo.ServicePart', to='servo.ServiceOrderItem'),
+ ),
+ migrations.AddField(
+ model_name='queuestatus',
+ name='status',
+ field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.status'),
+ ),
+ migrations.AddField(
+ model_name='queue',
+ name='status_assigned',
+ field=models.ForeignKey(blank=True, help_text='Order has ben assigned to a user', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.queuestatus', verbose_name='Order Assigned'),
+ ),
+ migrations.AddField(
+ model_name='queue',
+ name='status_closed',
+ field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.queuestatus', verbose_name='Order Closed'),
+ ),
+ migrations.AddField(
+ model_name='queue',
+ name='status_created',
+ field=models.ForeignKey(blank=True, help_text='Order has ben placed to a queue', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.queuestatus', verbose_name='Order Created'),
+ ),
+ migrations.AddField(
+ model_name='queue',
+ name='status_dispatched',
+ field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.queuestatus', verbose_name='Order Dispatched'),
+ ),
+ migrations.AddField(
+ model_name='queue',
+ name='status_products_ordered',
+ field=models.ForeignKey(blank=True, help_text='Purchase Order for this Service Order has been submitted', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.queuestatus', verbose_name='Products Ordered'),
+ ),
+ migrations.AddField(
+ model_name='queue',
+ name='status_products_received',
+ field=models.ForeignKey(blank=True, help_text='Products have been received', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.queuestatus', verbose_name='Products Received'),
+ ),
+ migrations.AddField(
+ model_name='queue',
+ name='status_repair_completed',
+ field=models.ForeignKey(blank=True, help_text='GSX repair completed', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.queuestatus', verbose_name='Repair Completed'),
+ ),
+ migrations.CreateModel(
+ name='PurchaseOrderItem',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('code', models.CharField(blank=True, default='', max_length=128)),
+ ('title', models.CharField(max_length=128, verbose_name='title')),
+ ('description', models.TextField(blank=True, default='', verbose_name='description')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('amount', models.IntegerField(default=1, verbose_name='amount')),
+ ('sn', models.CharField(blank=True, default='', max_length=32, verbose_name='KGB Serial Number')),
+ ('price', models.DecimalField(decimal_places=2, help_text='Purchase price without taxes', max_digits=8, verbose_name='Purchase Price')),
+ ('sales_order_ref', models.CharField(default='', editable=False, max_length=8)),
+ ('purchase_order_ref', models.CharField(default='', editable=False, max_length=32)),
+ ('user_fullname', models.CharField(default='', editable=False, max_length=256)),
+ ('reference', models.CharField(blank=True, default='', max_length=128)),
+ ('ordered_at', models.DateTimeField(editable=False, null=True)),
+ ('expected_ship_date', models.DateField(editable=False, null=True)),
+ ('received_at', models.DateTimeField(blank=True, editable=False, null=True, verbose_name='arrived')),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('order_item', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.serviceorderitem')),
+ ('product', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='servo.product')),
+ ('purchase_order', models.ForeignKey(editable=False, on_delete=django.db.models.deletion.CASCADE, to='servo.purchaseorder', verbose_name='Purchase Order')),
+ ('received_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)),
+ ('sales_order', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.order')),
+ ],
+ options={
+ 'ordering': ('id',),
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.CreateModel(
+ name='ProductCategory',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('title', models.CharField(default='New Category', max_length=255, unique=True)),
+ ('slug', models.SlugField(editable=False, null=True)),
+ ('lft', models.PositiveIntegerField(editable=False)),
+ ('rght', models.PositiveIntegerField(editable=False)),
+ ('tree_id', models.PositiveIntegerField(db_index=True, editable=False)),
+ ('level', models.PositiveIntegerField(editable=False)),
+ ('parent', mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='children', to='servo.productcategory')),
+ ],
+ options={
+ 'ordering': ('-title',),
+ 'get_latest_by': 'id',
+ },
+ ),
+ migrations.AddField(
+ model_name='product',
+ name='categories',
+ field=models.ManyToManyField(blank=True, to='servo.ProductCategory', verbose_name='Categories'),
+ ),
+ migrations.AddField(
+ model_name='product',
+ name='device_models',
+ field=models.ManyToManyField(blank=True, to='servo.DeviceGroup', verbose_name='Device models'),
+ ),
+ migrations.CreateModel(
+ name='Payment',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('method', models.IntegerField(choices=[(0, 'No Charge'), (1, 'Cash'), (2, 'Invoice'), (3, 'Credit Card'), (4, 'Mail payment'), (5, 'Online payment')], default=0, verbose_name='Payment Method')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('amount', models.DecimalField(decimal_places=2, max_digits=8)),
+ ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('invoice', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.invoice')),
+ ],
+ ),
+ migrations.CreateModel(
+ name='OrderStatus',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('started_at', models.DateTimeField(auto_now_add=True)),
+ ('finished_at', models.DateTimeField(null=True)),
+ ('green_limit', models.DateTimeField(null=True)),
+ ('yellow_limit', models.DateTimeField(null=True)),
+ ('badge', models.CharField(choices=[('undefined', 'undefined'), ('success', 'success'), ('warning', 'warning'), ('danger', 'danger')], default='undefined', max_length=16)),
+ ('duration', models.IntegerField(default=0)),
+ ('finished_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to=settings.AUTH_USER_MODEL)),
+ ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.order')),
+ ('started_by', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to=settings.AUTH_USER_MODEL)),
+ ('status', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.status')),
+ ],
+ options={
+ 'ordering': ('-started_at',),
+ 'get_latest_by': 'started_at',
+ },
+ ),
+ migrations.CreateModel(
+ name='OrderDevice',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('should_report', models.BooleanField(default=True)),
+ ('repeat_service', models.BooleanField(default=False)),
+ ('repair_strategies', django.contrib.postgres.fields.ArrayField(base_field=models.CharField(max_length=100), help_text='Available repair strategies from GSX', null=True, size=None)),
+ ('device', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='servo.device')),
+ ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.order')),
+ ],
+ options={
+ 'unique_together': {('order', 'device')},
+ },
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='devices',
+ field=models.ManyToManyField(through='servo.OrderDevice', to='servo.Device'),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='followed_by',
+ field=models.ManyToManyField(related_name='followed_orders', to=settings.AUTH_USER_MODEL),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='location',
+ field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='servo.location'),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='queue',
+ field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.queue', verbose_name='queue'),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='started_by',
+ field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='started_orders', to=settings.AUTH_USER_MODEL),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='status',
+ field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.queuestatus', verbose_name='status'),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='statuses',
+ field=models.ManyToManyField(related_name='orders', through='servo.OrderStatus', to='servo.Status'),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='tags',
+ field=models.ManyToManyField(to='servo.Tag', verbose_name='tags'),
+ ),
+ migrations.AddField(
+ model_name='order',
+ name='user',
+ field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL),
+ ),
+ migrations.CreateModel(
+ name='Note',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('subject', models.CharField(blank=True, default=servo.defaults.subject, max_length=255, verbose_name='Subject')),
+ ('body', models.TextField(verbose_name='Message')),
+ ('code', models.CharField(default=servo.lib.shorturl.from_time, editable=False, max_length=9, unique=True)),
+ ('sender', models.CharField(default='', max_length=255, verbose_name='From')),
+ ('recipient', models.CharField(blank=True, default='', max_length=255, verbose_name='To')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('sent_at', models.DateTimeField(editable=False, null=True)),
+ ('is_reported', models.BooleanField(default=False, help_text='Show this note on the confirmation printout', verbose_name='Report')),
+ ('is_read', models.BooleanField(default=True, editable=False, verbose_name='Read')),
+ ('is_flagged', models.BooleanField(default=False, editable=False, verbose_name='Flagged')),
+ ('type', models.IntegerField(blank=True, choices=[(0, 'Note'), (1, 'Problem'), (2, 'Escalation')], default=0, verbose_name='Type')),
+ ('lft', models.PositiveIntegerField(editable=False)),
+ ('rght', models.PositiveIntegerField(editable=False)),
+ ('tree_id', models.PositiveIntegerField(db_index=True, editable=False)),
+ ('level', models.PositiveIntegerField(editable=False)),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('customer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.customer')),
+ ('escalation', servo.models.note.UnsavedForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.escalation')),
+ ('labels', models.ManyToManyField(blank=True, limit_choices_to={'type': 'note'}, to='servo.Tag')),
+ ('order', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='servo.order')),
+ ('parent', mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='replies', to='servo.note')),
+ ],
+ options={
+ 'get_latest_by': 'created_at',
+ },
+ ),
+ migrations.CreateModel(
+ name='InvoiceItem',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('code', models.CharField(blank=True, default='', max_length=128)),
+ ('title', models.CharField(max_length=128, verbose_name='title')),
+ ('description', models.TextField(blank=True, default='', verbose_name='description')),
+ ('created_at', models.DateTimeField(auto_now_add=True)),
+ ('amount', models.IntegerField(default=1, verbose_name='amount')),
+ ('sn', models.CharField(blank=True, default='', max_length=32, verbose_name='KGB Serial Number')),
+ ('price', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='Sales Price')),
+ ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('invoice', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.invoice')),
+ ('product', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='servo.product')),
+ ],
+ ),
+ migrations.AddField(
+ model_name='invoice',
+ name='location',
+ field=models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.location'),
+ ),
+ migrations.AddField(
+ model_name='invoice',
+ name='order',
+ field=models.ForeignKey(editable=False, on_delete=django.db.models.deletion.PROTECT, to='servo.order'),
+ ),
+ migrations.CreateModel(
+ name='FlaggedItem',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('ref', models.CharField(max_length=32)),
+ ('ref_id', models.IntegerField()),
+ ('flagged_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Event',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('ref', models.CharField(max_length=32)),
+ ('ref_id', models.IntegerField()),
+ ('description', models.CharField(max_length=255)),
+ ('triggered_at', models.DateTimeField(auto_now_add=True)),
+ ('handled_at', models.DateTimeField(null=True)),
+ ('action', models.CharField(max_length=32)),
+ ('priority', models.SmallIntegerField(default=1)),
+ ('notify_users', models.ManyToManyField(related_name='notifications', to=settings.AUTH_USER_MODEL)),
+ ('triggered_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ],
+ options={
+ 'ordering': ('priority', '-id'),
+ },
+ ),
+ migrations.AddField(
+ model_name='escalation',
+ name='gsx_account',
+ field=models.ForeignKey(default=servo.defaults.gsx_account, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.gsxaccount', verbose_name='GSX Account'),
+ ),
+ migrations.AddField(
+ model_name='device',
+ name='products',
+ field=models.ManyToManyField(editable=False, help_text='Products that are compatible with this device instance', to='servo.Product'),
+ ),
+ migrations.AddField(
+ model_name='customer',
+ name='devices',
+ field=models.ManyToManyField(blank=True, editable=False, to='servo.Device', verbose_name='devices'),
+ ),
+ migrations.AddField(
+ model_name='customer',
+ name='groups',
+ field=models.ManyToManyField(blank=True, to='servo.CustomerGroup', verbose_name='Groups'),
+ ),
+ migrations.AddField(
+ model_name='customer',
+ name='parent',
+ field=mptt.fields.TreeForeignKey(blank=True, limit_choices_to={'is_company': True}, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='contacts', to='servo.customer', verbose_name='company'),
+ ),
+ migrations.AddField(
+ model_name='customer',
+ name='tags',
+ field=models.ManyToManyField(blank=True, limit_choices_to={'type': 'customer'}, to='servo.Tag', verbose_name='tags'),
+ ),
+ migrations.CreateModel(
+ name='Condition',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('key', models.CharField(choices=[('QUEUE', 'Queue'), ('STATUS', 'Status'), ('DEVICE', 'Device name'), ('CUSTOMER_NAME', 'Customer name')], max_length=16)),
+ ('operator', models.CharField(choices=[('^%s$', 'Equals'), ('%s', 'Contains'), ('%d < %d', 'Less than'), ('%d > %d', 'Greater than')], default='^%s$', max_length=8)),
+ ('value', models.TextField(default='')),
+ ('rule', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.rule')),
+ ],
+ options={
+ 'abstract': False,
+ },
+ ),
+ migrations.CreateModel(
+ name='ChecklistItemValue',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('checked_at', models.DateTimeField(auto_now_add=True)),
+ ('checked_by', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
+ ('item', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.checklistitem')),
+ ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.order')),
+ ],
+ ),
+ migrations.AddField(
+ model_name='checklist',
+ name='queues',
+ field=models.ManyToManyField(blank=True, to='servo.Queue', verbose_name='queue'),
+ ),
+ migrations.CreateModel(
+ name='Article',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('gsx_id', models.CharField(default='', editable=False, max_length=20)),
+ ('date_created', models.DateField(editable=False)),
+ ('date_published', models.DateField(null=True)),
+ ('title', models.TextField(default='New Article')),
+ ('summary', models.TextField(default='')),
+ ('content', models.TextField(default='')),
+ ('priority', models.CharField(choices=[('HIGH', 'High'), ('MEDIUM', 'Medium'), ('LOW', 'Low')], default='HIGH', max_length=128)),
+ ('url', models.URLField(default='')),
+ ('product_model', django.contrib.postgres.fields.ArrayField(base_field=models.CharField(max_length=128), editable=False, null=True, size=None)),
+ ('read_by', django.contrib.postgres.fields.ArrayField(base_field=models.IntegerField(), default=list, size=None)),
+ ('flagged_by', django.contrib.postgres.fields.ArrayField(base_field=models.IntegerField(), default=list, size=None)),
+ ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ],
+ ),
+ migrations.CreateModel(
+ name='Action',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('key', models.CharField(choices=[('SEND_SMS', 'Send SMS'), ('SEND_EMAIL', 'Send email'), ('ADD_TAG', 'Add Tag'), ('SET_PRIO', 'Set Priority'), ('SET_QUEUE', 'Set Queue'), ('SET_USER', 'Assign to')], default='SEND_EMAIL', max_length=32)),
+ ('value', models.TextField(default='')),
+ ('rule', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.rule')),
+ ],
+ options={
+ 'abstract': False,
+ },
+ ),
+ migrations.CreateModel(
+ name='Accessory',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('name', models.TextField()),
+ ('qty', models.IntegerField(default=1)),
+ ('device', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.device')),
+ ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.order')),
+ ],
+ ),
+ migrations.AddField(
+ model_name='user',
+ name='customer',
+ field=mptt.fields.TreeForeignKey(blank=True, limit_choices_to={'is_company': True}, null=True, on_delete=django.db.models.deletion.SET_NULL, to='servo.customer'),
+ ),
+ migrations.AddField(
+ model_name='user',
+ name='groups',
+ field=models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups'),
+ ),
+ migrations.AddField(
+ model_name='user',
+ name='location',
+ field=models.ForeignKey(help_text='Orders you create will be registered to this location.', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='servo.location', verbose_name='Current Location'),
+ ),
+ migrations.AddField(
+ model_name='user',
+ name='locations',
+ field=models.ManyToManyField(blank=True, to='servo.Location'),
+ ),
+ migrations.AddField(
+ model_name='user',
+ name='queues',
+ field=models.ManyToManyField(blank=True, to='servo.Queue', verbose_name='queues'),
+ ),
+ migrations.AddField(
+ model_name='user',
+ name='user_permissions',
+ field=models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions'),
+ ),
+ migrations.AlterUniqueTogether(
+ name='queuestatus',
+ unique_together={('queue', 'status')},
+ ),
+ migrations.CreateModel(
+ name='Message',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('code', models.CharField(default=servo.defaults.uid, max_length=36, unique=True)),
+ ('sender', models.CharField(max_length=128)),
+ ('recipient', models.CharField(max_length=128)),
+ ('body', models.TextField()),
+ ('sent_at', models.DateTimeField(null=True)),
+ ('received_at', models.DateTimeField(null=True)),
+ ('status', models.CharField(choices=[('SENT', 'SENT'), ('DELIVERED', 'DELIVERED'), ('RECEIVED', 'RECEIVED'), ('FAILED', 'FAILED')], max_length=16)),
+ ('method', models.CharField(choices=[('EMAIL', 'EMAIL'), ('SMS', 'SMS'), ('GSX', 'GSX')], default='EMAIL', max_length=16)),
+ ('error', models.TextField()),
+ ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
+ ('note', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.note')),
+ ],
+ options={
+ 'unique_together': {('note', 'recipient')},
+ },
+ ),
+ migrations.CreateModel(
+ name='Inventory',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('amount_minimum', models.PositiveIntegerField(default=0, verbose_name='Minimum amount')),
+ ('amount_reserved', models.PositiveIntegerField(default=0, verbose_name='Reserved amount')),
+ ('amount_stocked', models.IntegerField(default=0, verbose_name='Stocked amount')),
+ ('amount_ordered', models.PositiveIntegerField(default=0, verbose_name='Ordered amount')),
+ ('location', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.location')),
+ ('product', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.product')),
+ ],
+ options={
+ 'unique_together': {('product', 'location')},
+ },
+ ),
+ migrations.CreateModel(
+ name='ContactInfo',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('key', models.CharField(max_length=255)),
+ ('value', models.CharField(max_length=255)),
+ ('customer', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='servo.customer')),
+ ],
+ options={
+ 'unique_together': {('customer', 'key')},
+ },
+ ),
+ ]