# Generated by Django 5.2.17 on 2026-09-27 07:50

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', '0002_engineer_assignment'),
        ('service_catalog', '0002_technical_taxonomy'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='ServiceDiagnosticAssessment',
            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)),
                ('started_at', models.DateTimeField(default=django.utils.timezone.now)),
                ('completed_at', models.DateTimeField(blank=True, null=True)),
                ('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)),
                ('technical_note', 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)])),
            ],
            options={
                'ordering': ['started_at', 'id'],
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ServiceDiagnosticFinding',
            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)])),
                ('removed_at', models.DateTimeField(blank=True, null=True)),
            ],
            options={
                'ordering': ['created_at', 'id'],
                'abstract': False,
            },
        ),
        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'), ('CANCELLED', 'Cancelled')], default='RECEIVED', max_length=10),
        ),
        migrations.AddConstraint(
            model_name='servicecase',
            constraint=models.CheckConstraint(condition=models.Q(('status__in', ['RECEIVED', 'ASSIGNED', 'DIAGNOSING', 'DIAGNOSED', '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'])), 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='servicediagnosticassessment',
            name='abandoned_by',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='abandoned_diagnoses', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='servicediagnosticassessment',
            name='completed_by',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='completed_diagnoses', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='servicediagnosticassessment',
            name='engineer_assignment',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='diagnostic_assessments', to='service.serviceengineerassignment'),
        ),
        migrations.AddField(
            model_name='servicediagnosticassessment',
            name='service_case',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='diagnostic_assessments', to='service.servicecase'),
        ),
        migrations.AddField(
            model_name='servicediagnosticassessment',
            name='started_by',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='started_diagnoses', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='servicediagnosticfinding',
            name='assessment',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='findings', to='service.servicediagnosticassessment'),
        ),
        migrations.AddField(
            model_name='servicediagnosticfinding',
            name='fault_diagnosis',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='diagnostic_findings', to='service_catalog.faultdiagnosis'),
        ),
        migrations.AddField(
            model_name='servicediagnosticfinding',
            name='root_cause',
            field=models.ForeignKey(blank=True, help_text='Leave empty when the cause is unknown or unconfirmed.', null=True, on_delete=django.db.models.deletion.PROTECT, related_name='diagnostic_findings', to='service_catalog.rootcause'),
        ),
        migrations.AddConstraint(
            model_name='servicediagnosticassessment',
            constraint=models.UniqueConstraint(condition=models.Q(('abandoned_at__isnull', True), ('completed_at__isnull', True)), fields=('service_case',), name='service_one_open_assessment'),
        ),
        migrations.AddConstraint(
            model_name='servicediagnosticassessment',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('completed_at__isnull', True), ('completed_by__isnull', True)), models.Q(('completed_at__gte', models.F('started_at')), ('completed_at__isnull', False), ('completed_by__isnull', False)), _connector='OR'), name='service_diagnosis_completion'),
        ),
        migrations.AddConstraint(
            model_name='servicediagnosticassessment',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('abandon_reason', ''), ('abandoned_at__isnull', True), ('abandoned_by__isnull', True)), models.Q(('abandoned_at__gte', models.F('started_at')), ('abandoned_at__isnull', False), ('abandoned_by__isnull', False), models.Q(('abandon_reason', ''), _negated=True)), _connector='OR'), name='service_diagnosis_abandonment'),
        ),
        migrations.AddConstraint(
            model_name='servicediagnosticassessment',
            constraint=models.CheckConstraint(condition=models.Q(('completed_at__isnull', True), ('abandoned_at__isnull', True), _connector='OR'), name='service_diagnosis_one_outcome'),
        ),
        migrations.AddConstraint(
            model_name='servicediagnosticfinding',
            constraint=models.UniqueConstraint(condition=models.Q(('removed_at__isnull', True)), fields=('assessment', 'fault_diagnosis', 'root_cause'), name='service_diagnostic_finding_unique', nulls_distinct=False),
        ),
    ]