# Generated by Django 5.2.17 on 2026-09-27 05:01

import django.db.models.deletion
import django.core.validators
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', '0001_initial'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='ServiceEngineerAssignment',
            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)),
                ('assigned_at', models.DateTimeField(default=django.utils.timezone.now)),
                ('ended_at', models.DateTimeField(blank=True, null=True)),
                ('end_reason', models.CharField(blank=True, help_text='Do not record passwords, screen PINs, account credentials or OTPs.', max_length=2000)),
                ('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': ['assigned_at', 'id'],
                'abstract': False,
            },
        ),
        migrations.AlterModelOptions(
            name='servicecase',
            options={'ordering': ['-received_at', 'id'], 'permissions': [('handle_servicecase', 'Can receive service case work')]},
        ),
        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'), ('CANCELLED', 'Cancelled')], default='RECEIVED', max_length=9),
        ),
        migrations.AddConstraint(
            model_name='servicecase',
            constraint=models.CheckConstraint(condition=models.Q(('status__in', ['RECEIVED', 'ASSIGNED', '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'])), 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='serviceengineerassignment',
            name='assigned_by',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='assigned_service_work', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='serviceengineerassignment',
            name='ended_by',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='ended_service_work', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='serviceengineerassignment',
            name='engineer',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='service_engineer_assignments', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='serviceengineerassignment',
            name='service_case',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='engineer_assignments', to='service.servicecase'),
        ),
        migrations.AddConstraint(
            model_name='serviceengineerassignment',
            constraint=models.UniqueConstraint(condition=models.Q(('ended_at__isnull', True)), fields=('service_case',), name='service_one_current_engineer'),
        ),
        migrations.AddConstraint(
            model_name='serviceengineerassignment',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('end_reason', ''), ('ended_at__isnull', True), ('ended_by__isnull', True)), models.Q(('ended_at__gte', models.F('assigned_at')), ('ended_at__isnull', False), ('ended_by__isnull', False)), _connector='OR'), name='service_engineer_period_coherent'),
        ),
    ]