import uuid
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):
    dependencies = [
        ("club_finance", "0006_ffp_regulatory_multi_season"),
    ]

    operations = [
        migrations.CreateModel(
            name="GLRegulatoryTreatmentPolicy",
            fields=[
                ("id", models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False, serialize=False)),
                ("name", models.CharField(max_length=140)),
                ("version", models.PositiveIntegerField(default=1)),
                ("status", models.CharField(max_length=16, default="DRAFT", choices=[("DRAFT", "Draft"), ("PUBLISHED", "Published"), ("RETIRED", "Retired")])),
                ("effective_from", models.DateTimeField()),
                ("effective_to", models.DateTimeField(null=True, blank=True)),
                ("default_revenue_classification", models.CharField(max_length=32, default="RELEVANT_REVENUE", choices=[
                    ("RELEVANT_REVENUE", "FFP relevant revenue"), ("RELEVANT_EXPENSE", "FFP relevant expense"),
                    ("EXCLUDED_EXPENSE", "Permitted excluded expense"), ("OWNER_CONTRIBUTION", "Owner contribution / equity support"),
                    ("RELATED_PARTY_REVENUE", "Related-party revenue subject to fair value"), ("NON_RELEVANT", "Non-FFP / balance-sheet activity"),
                    ("REVIEW_REQUIRED", "Manual regulatory review required"),
                ])),
                ("default_expense_classification", models.CharField(max_length=32, default="RELEVANT_EXPENSE", choices=[
                    ("RELEVANT_REVENUE", "FFP relevant revenue"), ("RELEVANT_EXPENSE", "FFP relevant expense"),
                    ("EXCLUDED_EXPENSE", "Permitted excluded expense"), ("OWNER_CONTRIBUTION", "Owner contribution / equity support"),
                    ("RELATED_PARTY_REVENUE", "Related-party revenue subject to fair value"), ("NON_RELEVANT", "Non-FFP / balance-sheet activity"),
                    ("REVIEW_REQUIRED", "Manual regulatory review required"),
                ])),
                ("default_balance_sheet_classification", models.CharField(max_length=32, default="NON_RELEVANT", choices=[
                    ("RELEVANT_REVENUE", "FFP relevant revenue"), ("RELEVANT_EXPENSE", "FFP relevant expense"),
                    ("EXCLUDED_EXPENSE", "Permitted excluded expense"), ("OWNER_CONTRIBUTION", "Owner contribution / equity support"),
                    ("RELATED_PARTY_REVENUE", "Related-party revenue subject to fair value"), ("NON_RELEVANT", "Non-FFP / balance-sheet activity"),
                    ("REVIEW_REQUIRED", "Manual regulatory review required"),
                ])),
                ("require_full_classification", models.BooleanField(default=True)),
                ("rules", models.JSONField(default=dict, blank=True)),
                ("notes", models.TextField(default="", blank=True)),
                ("policy_hash", models.CharField(max_length=64, default="", blank=True)),
                ("published_at", models.DateTimeField(null=True, blank=True)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                ("federation", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="gl_regulatory_treatment_policies", to="federations.federation")),
                ("published_by", models.ForeignKey(null=True, blank=True, on_delete=django.db.models.deletion.PROTECT, related_name="published_gl_regulatory_treatment_policies", to="users.user")),
            ],
            options={
                "ordering": ["federation_id", "-effective_from", "-version", "id"],
                "indexes": [models.Index(fields=["federation", "status", "effective_from"], name="cf_gl_reg_policy_active_idx")],
            },
        ),
        migrations.AddConstraint(
            model_name="glregulatorytreatmentpolicy",
            constraint=models.UniqueConstraint(fields=("federation", "name", "version"), name="cf_gl_reg_policy_version_uq"),
        ),
        migrations.AddConstraint(
            model_name="glregulatorytreatmentpolicy",
            constraint=models.CheckConstraint(condition=models.Q(effective_to__isnull=True) | models.Q(effective_to__gt=models.F("effective_from")), name="cf_gl_reg_policy_dates_order"),
        ),
        migrations.CreateModel(
            name="GLRegulatoryTreatmentRule",
            fields=[
                ("id", models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False, serialize=False)),
                ("ordinal", models.PositiveIntegerField()),
                ("priority", models.IntegerField(default=0)),
                ("account_codes", models.JSONField(default=list, blank=True)),
                ("account_types", models.JSONField(default=list, blank=True)),
                ("source_types", models.JSONField(default=list, blank=True)),
                ("metadata_match", models.JSONField(default=dict, blank=True)),
                ("classification", models.CharField(max_length=32, choices=[
                    ("RELEVANT_REVENUE", "FFP relevant revenue"), ("RELEVANT_EXPENSE", "FFP relevant expense"),
                    ("EXCLUDED_EXPENSE", "Permitted excluded expense"), ("OWNER_CONTRIBUTION", "Owner contribution / equity support"),
                    ("RELATED_PARTY_REVENUE", "Related-party revenue subject to fair value"), ("NON_RELEVANT", "Non-FFP / balance-sheet activity"),
                    ("REVIEW_REQUIRED", "Manual regulatory review required"),
                ])),
                ("dimensions", models.JSONField(default=list, blank=True)),
                ("exclusion_type", models.CharField(max_length=32, default="", blank=True)),
                ("require_review", models.BooleanField(default=False)),
                ("notes", models.CharField(max_length=255, default="", blank=True)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("policy", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="treatment_rules", to="club_finance.glregulatorytreatmentpolicy")),
            ],
            options={
                "ordering": ["policy_id", "ordinal", "id"],
                "indexes": [models.Index(fields=["policy", "priority", "ordinal"], name="cf_gl_reg_rule_priority_idx")],
            },
        ),
        migrations.AddConstraint(
            model_name="glregulatorytreatmentrule",
            constraint=models.UniqueConstraint(fields=("policy", "ordinal"), name="cf_gl_reg_rule_ordinal_uq"),
        ),
        migrations.CreateModel(
            name="JournalLineRegulatoryClassification",
            fields=[
                ("id", models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False, serialize=False)),
                ("classification", models.CharField(max_length=32, choices=[
                    ("RELEVANT_REVENUE", "FFP relevant revenue"), ("RELEVANT_EXPENSE", "FFP relevant expense"),
                    ("EXCLUDED_EXPENSE", "Permitted excluded expense"), ("OWNER_CONTRIBUTION", "Owner contribution / equity support"),
                    ("RELATED_PARTY_REVENUE", "Related-party revenue subject to fair value"), ("NON_RELEVANT", "Non-FFP / balance-sheet activity"),
                    ("REVIEW_REQUIRED", "Manual regulatory review required"),
                ])),
                ("dimensions", models.JSONField(default=list, blank=True)),
                ("exclusion_type", models.CharField(max_length=32, default="", blank=True)),
                ("automated", models.BooleanField(default=True)),
                ("requires_review", models.BooleanField(default=False)),
                ("source_context", models.JSONField(default=dict, blank=True)),
                ("rulebook_governance", models.JSONField(default=dict, blank=True)),
                ("classification_hash", models.CharField(max_length=64)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="gl_regulatory_classifications", to="clubs.club")),
                ("entry", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="regulatory_classifications", to="club_finance.journalentry")),
                ("federation", models.ForeignKey(null=True, blank=True, on_delete=django.db.models.deletion.PROTECT, related_name="gl_regulatory_classifications", to="federations.federation")),
                ("journal_line", models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name="regulatory_classification", to="club_finance.journalline")),
                ("period", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="gl_regulatory_classifications", to="club_finance.accountingperiod")),
                ("policy", models.ForeignKey(null=True, blank=True, on_delete=django.db.models.deletion.PROTECT, related_name="line_classifications", to="club_finance.glregulatorytreatmentpolicy")),
                ("policy_rule", models.ForeignKey(null=True, blank=True, on_delete=django.db.models.deletion.PROTECT, related_name="line_classifications", to="club_finance.glregulatorytreatmentrule")),
            ],
            options={
                "ordering": ["entry__accounting_date", "entry_id", "journal_line__line_no"],
                "indexes": [
                    models.Index(fields=["club", "period", "classification"], name="cf_gl_reg_class_period_idx"),
                    models.Index(fields=["policy", "classification"], name="cf_gl_reg_class_policy_idx"),
                ],
            },
        ),
        migrations.AddConstraint(
            model_name="journallineregulatoryclassification",
            constraint=models.CheckConstraint(condition=~models.Q(classification_hash=""), name="cf_gl_reg_class_hash_nonempty"),
        ),
    ]
