# Generated by Django 5.2.17 on 2026-09-27 14:36 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', '0004_repair_execution'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='ServiceQualityControl', 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)), ('status', models.CharField(choices=[('IN_PROGRESS', 'In progress'), ('COMPLETED', 'Completed'), ('ABANDONED', 'Abandoned')], default='IN_PROGRESS', max_length=11)), ('checklist_version', models.PositiveSmallIntegerField(default=1)), ('started_at', models.DateTimeField(default=django.utils.timezone.now)), ('completed_at', models.DateTimeField(blank=True, null=True)), ('outcome', models.CharField(blank=True, choices=[('PASSED', 'Passed'), ('FAILED', 'Failed')], max_length=6, null=True)), ('summary', models.TextField(blank=True, help_text='Do not record passwords, screen PINs, account credentials or OTPs.', max_length=4000, validators=[django.core.validators.MaxLengthValidator(4000)])), ('failure_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)])), ('abandoned_at', models.DateTimeField(blank=True, null=True)), ('abandon_reason', models.CharField(blank=True, help_text='Do not record passwords, screen PINs, account credentials or OTPs.', max_length=2000)), ], options={ 'ordering': ['started_at', 'id'], 'abstract': False, }, ), migrations.CreateModel( name='ServiceQualityControlCheck', 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)), ('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)])), ('check_code', models.CharField(max_length=32)), ('check_name', models.CharField(max_length=160)), ('sequence', models.PositiveSmallIntegerField()), ('allows_not_applicable', models.BooleanField(default=False)), ('result', models.CharField(blank=True, choices=[('PASS', 'Pass'), ('FAIL', 'Fail'), ('NOT_APPLICABLE', 'Not applicable')], max_length=14, null=True)), ], options={ 'ordering': ['sequence', 'id'], 'abstract': False, }, ), migrations.CreateModel( name='ServiceQualityControlComplaintCheck', 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)), ('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)])), ('result', models.CharField(blank=True, choices=[('RESOLVED', 'Resolved'), ('NOT_RESOLVED', 'Not resolved'), ('NOT_TESTABLE', 'Not testable')], max_length=12, null=True)), ], 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')]}, ), 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'), ('CANCELLED', 'Cancelled')], default='RECEIVED', max_length=14), ), 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', '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'])), 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='servicequalitycontrol', name='abandoned_by', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='abandoned_quality_controls', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='servicequalitycontrol', name='inspector', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='quality_controls', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='servicequalitycontrol', name='repair_execution', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='quality_controls', to='service.servicerepairexecution'), ), migrations.AddField( model_name='servicequalitycontrol', name='service_case', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='quality_controls', to='service.servicecase'), ), migrations.AddField( model_name='servicequalitycontrolcheck', name='quality_control', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='%(class)ss', to='service.servicequalitycontrol'), ), migrations.AddField( model_name='servicequalitycontrolcomplaintcheck', name='complaint', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='quality_control_checks', to='service.servicecasecomplaint'), ), migrations.AddField( model_name='servicequalitycontrolcomplaintcheck', name='quality_control', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='%(class)ss', to='service.servicequalitycontrol'), ), migrations.AddConstraint( model_name='servicequalitycontrol', constraint=models.UniqueConstraint(condition=models.Q(('status', 'IN_PROGRESS')), fields=('service_case',), name='service_one_open_qc'), ), migrations.AddConstraint( model_name='servicequalitycontrol', constraint=models.CheckConstraint(condition=models.Q(models.Q(('abandon_reason', ''), ('abandoned_at__isnull', True), ('abandoned_by__isnull', True), ('completed_at__isnull', True), ('failure_note', ''), ('outcome__isnull', True), ('status', 'IN_PROGRESS')), models.Q(('abandon_reason', ''), ('abandoned_at__isnull', True), ('abandoned_by__isnull', True), ('completed_at__gte', models.F('started_at')), ('completed_at__isnull', False), ('outcome__isnull', False), ('status', 'COMPLETED'), models.Q(models.Q(('failure_note', ''), ('outcome', 'PASSED')), models.Q(('outcome', 'FAILED'), models.Q(('failure_note', ''), _negated=True)), _connector='OR')), models.Q(('abandoned_at__gte', models.F('started_at')), ('abandoned_at__isnull', False), ('abandoned_by__isnull', False), ('completed_at__isnull', True), ('failure_note', ''), ('outcome__isnull', True), ('status', 'ABANDONED'), models.Q(('abandon_reason', ''), _negated=True)), _connector='OR'), name='service_qc_outcome_coherent'), ), migrations.AddConstraint( model_name='servicequalitycontrol', constraint=models.CheckConstraint(condition=models.Q(('checklist_version__gte', 1)), name='service_qc_version_positive'), ), migrations.AddConstraint( model_name='servicequalitycontrolcheck', constraint=models.UniqueConstraint(fields=('quality_control', 'check_code'), name='service_qc_check_unique'), ), migrations.AddConstraint( model_name='servicequalitycontrolcheck', constraint=models.CheckConstraint(condition=models.Q(('result__isnull', True), ('result__in', ['PASS', 'FAIL', 'NOT_APPLICABLE']), _connector='OR'), name='service_qc_check_result_valid'), ), migrations.AddConstraint( model_name='servicequalitycontrolcheck', constraint=models.CheckConstraint(condition=models.Q(models.Q(('result', 'NOT_APPLICABLE'), _negated=True), models.Q(('allows_not_applicable', True), models.Q(('note', ''), _negated=True)), _connector='OR'), name='service_qc_na_explained'), ), migrations.AddConstraint( model_name='servicequalitycontrolcomplaintcheck', constraint=models.UniqueConstraint(fields=('quality_control', 'complaint'), name='service_qc_complaint_unique'), ), migrations.AddConstraint( model_name='servicequalitycontrolcomplaintcheck', constraint=models.CheckConstraint(condition=models.Q(('result__isnull', True), ('result__in', ['RESOLVED', 'NOT_RESOLVED', 'NOT_TESTABLE']), _connector='OR'), name='service_qc_complaint_result_valid'), ), ]