# Generated by Django 5.2.13 on 2026-05-18 08:51

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


class Migration(migrations.Migration):

    dependencies = [
        ("rims_finance", "0011_approval_workflow_telemetry"),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name="Reforecast",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                ("generated_at", models.DateTimeField(auto_now_add=True)),
                ("as_of_date", models.DateField()),
                ("forecast_horizon_months", models.PositiveSmallIntegerField(default=12)),
                (
                    "methodology",
                    models.CharField(
                        choices=[
                            ("burn_rate", "Historical burn rate"),
                            ("tranche_schedule", "Tranche schedule"),
                            ("blended", "Blended"),
                        ],
                        default="blended",
                        max_length=24,
                    ),
                ),
                ("notes", models.TextField(blank=True)),
                (
                    "budget",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="reforecasts",
                        to="rims_finance.budget",
                    ),
                ),
                (
                    "generated_by",
                    models.ForeignKey(
                        blank=True,
                        help_text="NULL when generated by the monthly Celery beat.",
                        null=True,
                        on_delete=django.db.models.deletion.SET_NULL,
                        related_name="reforecasts_generated",
                        to=settings.AUTH_USER_MODEL,
                    ),
                ),
            ],
            options={
                "ordering": ["-generated_at"],
            },
        ),
        migrations.CreateModel(
            name="ReforecastLine",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                ("bucket", models.CharField(help_text="YYYY-MM bucket label.", max_length=7)),
                ("forecasted_amount", models.DecimalField(decimal_places=2, max_digits=14)),
                (
                    "historical_burn",
                    models.DecimalField(decimal_places=2, default=0, max_digits=14),
                ),
                ("tranche_inflow", models.DecimalField(decimal_places=2, default=0, max_digits=14)),
                (
                    "budget_line",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.PROTECT,
                        related_name="reforecast_lines",
                        to="rims_finance.budgetline",
                    ),
                ),
                (
                    "reforecast",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="lines",
                        to="rims_finance.reforecast",
                    ),
                ),
            ],
            options={
                "ordering": ["bucket"],
                "constraints": [
                    models.UniqueConstraint(
                        fields=("reforecast", "budget_line", "bucket"),
                        name="uniq_reforecast_line_bucket",
                    )
                ],
            },
        ),
    ]