# Generated by Django 5.2.17 on 2026-09-27 15:27 import django.core.validators import django.db.models.deletion import django.utils.timezone import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ('customers', '0002_customeraddress_customercontact'), ('devices', '0003_customer_device_relationship'), ('organization', '0002_userorganizationassignment'), ('service', '0005_quality_control'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='ServiceCaseClosure', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('closed_at', models.DateTimeField(default=django.utils.timezone.now)), ('note', models.TextField(blank=True, help_text='Do not record passwords, screen PINs, account credentials or OTPs.', max_length=2000, validators=[django.core.validators.MaxLengthValidator(2000)])), ], options={ 'ordering': ['closed_at', 'id'], 'abstract': False, }, ), migrations.CreateModel( name='ServiceCaseDeliveryRelease', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('device_identity', models.CharField(max_length=64)), ('readied_at', models.DateTimeField(default=django.utils.timezone.now)), ('note', models.TextField(blank=True, help_text='Do not record passwords, screen PINs, account credentials or OTPs.', max_length=2000, validators=[django.core.validators.MaxLengthValidator(2000)])), ], options={ 'ordering': ['created_at', 'id'], 'abstract': False, }, ), migrations.CreateModel( name='ServiceCaseHandover', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('recipient_type', models.CharField(choices=[('CUSTOMER', 'Customer'), ('AUTHORIZED_REPRESENTATIVE', 'Authorized representative')], max_length=25)), ('recipient_name', models.CharField(max_length=200)), ('recipient_mobile', models.CharField(blank=True, max_length=32)), ('recipient_relationship', models.CharField(blank=True, max_length=200)), ('recipient_identity_type', models.CharField(blank=True, choices=[('NATIONAL_ID', 'National ID checked'), ('PASSPORT', 'Passport checked'), ('OTHER_DOCUMENT', 'Other document checked')], max_length=16)), ('recipient_identity_reference', models.CharField(blank=True, help_text='Minimal audit reference only. No full identity-document numbers, images, passwords, PINs or OTPs.', max_length=64)), ('verification_method', models.CharField(choices=[('CUSTOMER_RECORD', 'Customer record confirmed'), ('AUTHORIZED_REPRESENTATIVE', 'Representative authorization checked'), ('MANUAL_DOCUMENT_CHECK', 'Manual document check')], max_length=25)), ('verification_reference', models.CharField(blank=True, help_text='Minimal audit reference only. No full identity-document numbers, images, passwords, PINs or OTPs.', max_length=120)), ('delivered_at', models.DateTimeField(default=django.utils.timezone.now)), ('note', models.TextField(blank=True, help_text='Do not record passwords, screen PINs, account credentials or OTPs.', max_length=2000, validators=[django.core.validators.MaxLengthValidator(2000)])), ], options={ 'ordering': ['delivered_at', 'id'], 'abstract': False, }, ), migrations.CreateModel( name='ServiceCaseHandoverAccessory', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('returned_quantity', models.PositiveIntegerField()), ('condition_note', models.TextField(blank=True, help_text='Do not record passwords, screen PINs, account credentials or OTPs.', max_length=2000, validators=[django.core.validators.MaxLengthValidator(2000)])), ], options={ 'ordering': ['created_at', 'id'], 'abstract': False, }, ), migrations.AlterModelOptions( name='servicecase', options={'ordering': ['-received_at', 'id'], 'permissions': [('handle_servicecase', 'Can receive service case work'), ('perform_quality_control', 'Can perform independent quality control'), ('handover_servicecase', 'Can release and hand over service cases'), ('close_servicecase', 'Can close delivered service cases')]}, ), migrations.RemoveConstraint( model_name='servicecase', name='service_status_valid', ), migrations.RemoveConstraint( model_name='servicecase', name='service_cancellation_coherent', ), migrations.AlterField( model_name='servicecase', name='status', field=models.CharField(choices=[('RECEIVED', 'Received'), ('ASSIGNED', 'Assigned'), ('DIAGNOSING', 'Diagnosing'), ('DIAGNOSED', 'Diagnosed'), ('REPAIRING', 'Repairing'), ('REPAIRED', 'Repaired'), ('QC_PENDING', 'QC pending'), ('QC_IN_PROGRESS', 'QC in progress'), ('QC_PASSED', 'QC passed'), ('READY_FOR_DELIVERY', 'Ready for delivery'), ('DELIVERED', 'Delivered'), ('CLOSED', 'Closed'), ('CANCELLED', 'Cancelled')], default='RECEIVED', max_length=18), ), migrations.AddConstraint( model_name='servicecase', constraint=models.CheckConstraint(condition=models.Q(('status__in', ['RECEIVED', 'ASSIGNED', 'DIAGNOSING', 'DIAGNOSED', 'REPAIRING', 'REPAIRED', 'QC_PENDING', 'QC_IN_PROGRESS', 'QC_PASSED', 'READY_FOR_DELIVERY', 'DELIVERED', 'CLOSED', 'CANCELLED'])), name='service_status_valid'), ), migrations.AddConstraint( model_name='servicecase', constraint=models.CheckConstraint(condition=models.Q(models.Q(('cancellation_reason', ''), ('cancelled_at__isnull', True), ('status__in', ['RECEIVED', 'ASSIGNED', 'DIAGNOSING', 'DIAGNOSED', 'REPAIRING', 'REPAIRED', 'QC_PENDING', 'QC_IN_PROGRESS', 'QC_PASSED', 'READY_FOR_DELIVERY', 'DELIVERED', 'CLOSED'])), models.Q(('cancelled_at__gte', models.F('received_at')), ('cancelled_at__isnull', False), ('status', 'CANCELLED')), _connector='OR'), name='service_cancellation_coherent'), ), migrations.AddField( model_name='servicecaseclosure', name='closed_by', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='service_closures', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='servicecaseclosure', name='service_case', field=models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='closure', to='service.servicecase'), ), migrations.AddField( model_name='servicecasedeliveryrelease', name='device', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='service_delivery_releases', to='devices.device'), ), migrations.AddField( model_name='servicecasedeliveryrelease', name='quality_control', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='delivery_releases', to='service.servicequalitycontrol'), ), migrations.AddField( model_name='servicecasedeliveryrelease', name='readied_by', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='service_delivery_releases', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='servicecasedeliveryrelease', name='service_case', field=models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='delivery_release', to='service.servicecase'), ), migrations.AddField( model_name='servicecasehandover', name='delivery_release', field=models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='handover', to='service.servicecasedeliveryrelease'), ), migrations.AddField( model_name='servicecasehandover', name='handed_over_by', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='service_handovers', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='servicecasehandover', name='recipient_customer', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='service_handovers', to='customers.customer'), ), migrations.AddField( model_name='servicecasehandover', name='service_case', field=models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='handover', to='service.servicecase'), ), migrations.AddField( model_name='servicecaseclosure', name='handover', field=models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='closure', to='service.servicecasehandover'), ), migrations.AddField( model_name='servicecasehandoveraccessory', name='handover', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='accessories', to='service.servicecasehandover'), ), migrations.AddField( model_name='servicecasehandoveraccessory', name='intake_accessory', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='handover_acknowledgements', to='service.servicecaseaccessory'), ), migrations.AddConstraint( model_name='servicecasehandover', constraint=models.CheckConstraint(condition=models.Q(models.Q(models.Q(('recipient_customer__isnull', False), ('recipient_relationship', ''), ('recipient_type', 'CUSTOMER'), ('verification_method__in', ['CUSTOMER_RECORD', 'MANUAL_DOCUMENT_CHECK'])), models.Q(('recipient_customer__isnull', True), ('recipient_type', 'AUTHORIZED_REPRESENTATIVE'), ('verification_method__in', ['AUTHORIZED_REPRESENTATIVE', 'MANUAL_DOCUMENT_CHECK']), models.Q(('recipient_mobile', ''), _negated=True), models.Q(('recipient_relationship', ''), _negated=True), models.Q(('verification_reference', ''), _negated=True)), _connector='OR'), models.Q(('recipient_name', ''), _negated=True)), name='service_handover_recipient_valid'), ), migrations.AddConstraint( model_name='servicecasehandover', constraint=models.CheckConstraint(condition=models.Q(models.Q(('recipient_identity_type__in', ['NATIONAL_ID', 'PASSPORT', 'OTHER_DOCUMENT']), ('verification_method', 'MANUAL_DOCUMENT_CHECK'), models.Q(('recipient_identity_reference', ''), _negated=True), models.Q(('verification_reference', ''), _negated=True)), models.Q(('recipient_identity_reference', ''), ('recipient_identity_type', ''), ('verification_method__in', ['CUSTOMER_RECORD', 'AUTHORIZED_REPRESENTATIVE'])), _connector='OR'), name='service_handover_verification_valid'), ), migrations.AddConstraint( model_name='servicecasehandover', constraint=models.CheckConstraint(condition=models.Q(('delivered_at__lte', models.F('created_at'))), name='service_handover_time_valid'), ), migrations.AddConstraint( model_name='servicecaseclosure', constraint=models.CheckConstraint(condition=models.Q(('closed_at__lte', models.F('created_at'))), name='service_closure_time_valid'), ), migrations.AddConstraint( model_name='servicecasehandoveraccessory', constraint=models.UniqueConstraint(fields=('handover', 'intake_accessory'), name='service_handover_accessory_unique'), ), migrations.AddConstraint( model_name='servicecasehandoveraccessory', constraint=models.CheckConstraint(condition=models.Q(('returned_quantity__gte', 0)), name='service_return_quantity_nonnegative'), ), ]