# Generated by Django 5.2.11 on 2026-10-28 00:31

import django.db.models.deletion
from django.conf import settings
from django.db import migrations, models


def seed_queries_permissions(apps, schema_editor):
    from accounts.rbac_catalog import iter_permission_defs

    RbacPermission = apps.get_model('accounts', 'RbacPermission')
    for item in iter_permission_defs():
        RbacPermission.objects.update_or_create(
            codename=item['codename'],
            defaults={
                'module': item['module'],
                'module_label': item['module_label'],
                'action': item['action'],
                'label': item['label'],
                'sort_order': item['sort_order'],
            },
        )


class Migration(migrations.Migration):

    dependencies = [
        ('accounts', '0035_auditlog_and_audit_logs_permission'),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='ContactQuery',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255)),
                ('email', models.EmailField(max_length=254)),
                ('phone', models.CharField(max_length=40)),
                ('message', models.TextField()),
                ('status', models.CharField(choices=[('NEW', 'New'), ('VIEWED', 'Viewed'), ('REPLIED', 'Replied')], db_index=True, default='NEW', max_length=20)),
                ('viewed_at', models.DateTimeField(blank=True, null=True)),
                ('replied_at', models.DateTimeField(blank=True, null=True)),
                ('reply_subject', models.CharField(blank=True, default='', max_length=255)),
                ('reply_body', models.TextField(blank=True, default='')),
                ('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
                ('replied_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='replied_contact_queries', to=settings.AUTH_USER_MODEL)),
                ('viewed_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='viewed_contact_queries', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'verbose_name': 'Contact query',
                'verbose_name_plural': 'Contact queries',
                'ordering': ['-created_at'],
                'indexes': [models.Index(fields=['status', '-created_at'], name='accounts_co_status_d9894c_idx'), models.Index(fields=['email', '-created_at'], name='accounts_co_email_666b50_idx')],
            },
        ),
        migrations.RunPython(seed_queries_permissions, migrations.RunPython.noop),
    ]
