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


class Migration(migrations.Migration):
    initial = True
    dependencies = [
        ("clubs", "0003_club_squad_membership"),
        ("seasons", "0004_player_progression_orchestration_step"),
        ("economy", "0008_marketplace_account_escrow_wallets"),
    ]
    operations = [
        migrations.CreateModel(
            name="AccountingPeriod",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("name", models.CharField(max_length=120)),
                ("starts_at", models.DateTimeField()), ("ends_at", models.DateTimeField()),
                ("is_closed", models.BooleanField(default=False)), ("closed_at", models.DateTimeField(blank=True, null=True)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="accounting_periods", to="clubs.club")),
                ("season", models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="club_accounting_periods", to="seasons.season")),
            ], options={"ordering": ["-starts_at", "id"]},
        ),
        migrations.CreateModel(
            name="FFPPolicy",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("name", models.CharField(max_length=120)), ("version", models.PositiveIntegerField(default=1)),
                ("effective_from", models.DateTimeField()), ("effective_to", models.DateTimeField(blank=True, null=True)),
                ("max_loss", models.DecimalField(decimal_places=8, default=Decimal("0"), max_digits=24)),
                ("max_wage_to_revenue_ratio", models.DecimalField(decimal_places=4, default=Decimal("0.70"), max_digits=8)),
                ("max_transfer_spend_to_revenue_ratio", models.DecimalField(decimal_places=4, default=Decimal("1.50"), max_digits=8)),
                ("warning_buffer_pct", models.DecimalField(decimal_places=2, default=Decimal("10"), max_digits=5)),
                ("is_active", models.BooleanField(default=True)), ("rules", models.JSONField(blank=True, default=dict)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
            ], options={"ordering": ["-effective_from", "-version"]},
        ),
        migrations.CreateModel(
            name="ClubBudget",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("name", models.CharField(max_length=120)),
                ("status", models.CharField(choices=[("DRAFT","Draft"),("ACTIVE","Active"),("CLOSED","Closed"),("CANCELLED","Cancelled")], default="DRAFT", max_length=12)),
                ("contingency_amount", models.DecimalField(decimal_places=8, default=Decimal("0"), max_digits=24)),
                ("notes", models.TextField(blank=True, default="")), ("activated_at", models.DateTimeField(blank=True, null=True)),
                ("closed_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="budgets", to="clubs.club")),
                ("period", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="budgets", to="club_finance.accountingperiod")),
            ], options={"ordering": ["-created_at", "id"]},
        ),
        migrations.CreateModel(
            name="BudgetLine",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("category", models.CharField(max_length=32)),
                ("planned_amount", models.DecimalField(decimal_places=8, max_digits=24)), ("hard_limit", models.BooleanField(default=False)),
                ("warning_threshold_pct", models.DecimalField(decimal_places=2, default=Decimal("90"), max_digits=5)),
                ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)),
                ("budget", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="lines", to="club_finance.clubbudget")),
            ],
        ),
        migrations.CreateModel(
            name="LedgerClassification",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("direction", models.CharField(max_length=12)), ("category", models.CharField(max_length=32)),
                ("amount", models.DecimalField(decimal_places=8, max_digits=24)), ("ffp_relevant", models.BooleanField(default=True)),
                ("capex", models.BooleanField(default=False)), ("manual_override", models.BooleanField(default=False)),
                ("evidence", models.JSONField(blank=True, default=dict)), ("created_at", models.DateTimeField(auto_now_add=True)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="ledger_classifications", to="clubs.club")),
                ("ledger_entry", models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name="club_finance_classification", to="economy.ledgerentry")),
                ("period", models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="classifications", to="club_finance.accountingperiod")),
            ], options={"ordering": ["-created_at", "id"]},
        ),
        migrations.CreateModel(
            name="FFPAssessment",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("status", models.CharField(max_length=12)),
                ("relevant_income", models.DecimalField(decimal_places=8, max_digits=24)), ("relevant_expense", models.DecimalField(decimal_places=8, max_digits=24)),
                ("result", models.DecimalField(decimal_places=8, max_digits=24)), ("wage_cost", models.DecimalField(decimal_places=8, max_digits=24)),
                ("transfer_spend", models.DecimalField(decimal_places=8, max_digits=24)),
                ("wage_to_revenue_ratio", models.DecimalField(blank=True, decimal_places=6, max_digits=12, null=True)),
                ("transfer_spend_to_revenue_ratio", models.DecimalField(blank=True, decimal_places=6, max_digits=12, null=True)),
                ("reasons", models.JSONField(blank=True, default=list)), ("evidence", models.JSONField(blank=True, default=dict)),
                ("assessed_at", models.DateTimeField(auto_now_add=True)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="ffp_assessments", to="clubs.club")),
                ("period", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="ffp_assessments", to="club_finance.accountingperiod")),
                ("policy", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="assessments", to="club_finance.ffppolicy")),
            ], options={"ordering": ["-assessed_at", "id"]},
        ),
        migrations.CreateModel(
            name="FinancialControlEvent",
            fields=[
                ("id", models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ("event_type", models.CharField(max_length=40)), ("severity", models.CharField(default="INFO", max_length=12)),
                ("reference_type", models.CharField(blank=True, default="", max_length=80)), ("reference_id", models.CharField(blank=True, default="", max_length=120)),
                ("payload", models.JSONField(blank=True, default=dict)), ("created_at", models.DateTimeField(auto_now_add=True)),
                ("club", models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name="financial_control_events", to="clubs.club")),
            ], options={"ordering": ["-created_at", "id"]},
        ),
        migrations.AddConstraint(model_name="accountingperiod", constraint=models.CheckConstraint(condition=models.Q(("ends_at__gt", models.F("starts_at"))), name="cf_period_dates_order")),
        migrations.AddConstraint(model_name="accountingperiod", constraint=models.UniqueConstraint(fields=("club","name"), name="cf_period_unique_club_name")),
        migrations.AddIndex(model_name="accountingperiod", index=models.Index(fields=["club","starts_at","ends_at"], name="cf_period_club_dates_idx")),
        migrations.AddConstraint(model_name="ffppolicy", constraint=models.CheckConstraint(condition=models.Q(("max_loss__gte",0)), name="cf_ffp_max_loss_nonneg")),
        migrations.AddConstraint(model_name="ffppolicy", constraint=models.CheckConstraint(condition=models.Q(("max_wage_to_revenue_ratio__gte",0)), name="cf_ffp_wage_ratio_nonneg")),
        migrations.AddConstraint(model_name="ffppolicy", constraint=models.CheckConstraint(condition=models.Q(("max_transfer_spend_to_revenue_ratio__gte",0)), name="cf_ffp_transfer_ratio_nonneg")),
        migrations.AddConstraint(model_name="ffppolicy", constraint=models.UniqueConstraint(fields=("name","version"), name="cf_ffp_policy_version_unique")),
        migrations.AddConstraint(model_name="clubbudget", constraint=models.CheckConstraint(condition=models.Q(("contingency_amount__gte",0)), name="cf_budget_contingency_nonneg")),
        migrations.AddConstraint(model_name="clubbudget", constraint=models.UniqueConstraint(fields=("club","period","name"), name="cf_budget_unique_name")),
        migrations.AddIndex(model_name="clubbudget", index=models.Index(fields=["club","status"], name="cf_budget_club_status_idx")),
        migrations.AddConstraint(model_name="budgetline", constraint=models.CheckConstraint(condition=models.Q(("planned_amount__gte",0)), name="cf_budget_line_nonneg")),
        migrations.AddConstraint(model_name="budgetline", constraint=models.CheckConstraint(condition=models.Q(("warning_threshold_pct__gte",0),("warning_threshold_pct__lte",100)), name="cf_budget_warning_pct")),
        migrations.AddConstraint(model_name="budgetline", constraint=models.UniqueConstraint(fields=("budget","category"), name="cf_budget_unique_category")),
        migrations.AddConstraint(model_name="ledgerclassification", constraint=models.CheckConstraint(condition=models.Q(("amount__gt",0)), name="cf_class_amount_positive")),
        migrations.AddIndex(model_name="ledgerclassification", index=models.Index(fields=["club","category","created_at"], name="cf_class_club_cat_idx")),
        migrations.AddIndex(model_name="ledgerclassification", index=models.Index(fields=["club","direction","created_at"], name="cf_class_direction_idx")),
        migrations.AddIndex(model_name="ledgerclassification", index=models.Index(fields=["ffp_relevant","created_at"], name="cf_class_ffp_idx")),
        migrations.AddIndex(model_name="ffpassessment", index=models.Index(fields=["club","status","assessed_at"], name="cf_ffp_club_status_idx")),
        migrations.AddIndex(model_name="financialcontrolevent", index=models.Index(fields=["club","event_type","created_at"], name="cf_control_event_idx")),
    ]
