# Generated by Django 5.2.13 on 2026-05-03 10:32

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


class Migration(migrations.Migration):

    dependencies = [
        ("mel_reports", "0001_initial"),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name="ReportSection",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                ("ordinal", models.PositiveIntegerField(default=0)),
                (
                    "kind",
                    models.CharField(
                        choices=[
                            ("indicator_table", "Indicator table"),
                            ("chart", "Chart"),
                            ("narrative", "Narrative"),
                            ("feedback_summary", "Feedback summary"),
                            ("participant_timeline", "Participant timeline"),
                            ("finance", "Finance"),
                            ("variance", "Variance table"),
                            ("compliance", "Compliance alerts"),
                        ],
                        max_length=32,
                    ),
                ),
                ("title", models.CharField(blank=True, max_length=255)),
                (
                    "config",
                    models.JSONField(
                        blank=True,
                        default=dict,
                        help_text="Section-specific config: {'indicator_codes':[…], 'window':'last_quarter', …}.",
                    ),
                ),
                (
                    "htmx_lazy",
                    models.BooleanField(
                        default=False,
                        help_text="When true, the section is loaded via an HTMX endpoint after the page renders.",
                    ),
                ),
                (
                    "template",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="section_rows",
                        to="mel_reports.reporttemplate",
                    ),
                ),
            ],
            options={
                "ordering": ["template_id", "ordinal", "pk"],
                "indexes": [
                    models.Index(
                        fields=["template", "ordinal"], name="mel_reports_templat_0f610b_idx"
                    )
                ],
            },
        ),
        migrations.CreateModel(
            name="ScheduledReport",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                (
                    "frequency",
                    models.CharField(
                        choices=[
                            ("daily", "Daily"),
                            ("weekly", "Weekly"),
                            ("monthly", "Monthly"),
                            ("quarterly", "Quarterly"),
                            ("annual", "Annual"),
                        ],
                        default="quarterly",
                        max_length=16,
                    ),
                ),
                (
                    "cron_expression",
                    models.CharField(
                        blank=True,
                        help_text="Optional override — when set, takes precedence over ``frequency``.",
                        max_length=120,
                    ),
                ),
                (
                    "formats",
                    models.JSONField(
                        blank=True,
                        default=list,
                        help_text="List of artefact formats to render: pdf / xlsx / html.",
                    ),
                ),
                (
                    "extra_emails",
                    models.JSONField(
                        blank=True, default=list, help_text="Free-text additional recipient emails."
                    ),
                ),
                ("is_active", models.BooleanField(db_index=True, default=True)),
                ("last_run_at", models.DateTimeField(blank=True, null=True)),
                ("next_run_at", models.DateTimeField(blank=True, db_index=True, null=True)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                ("updated_at", models.DateTimeField(auto_now=True)),
                (
                    "created_by",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.SET_NULL,
                        related_name="mel_report_schedules_created",
                        to=settings.AUTH_USER_MODEL,
                    ),
                ),
                (
                    "recipients",
                    models.ManyToManyField(
                        blank=True, related_name="mel_report_schedules", to=settings.AUTH_USER_MODEL
                    ),
                ),
                (
                    "template",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="schedules",
                        to="mel_reports.reporttemplate",
                    ),
                ),
            ],
            options={
                "ordering": ["next_run_at", "-created_at"],
                "indexes": [
                    models.Index(
                        fields=["is_active", "next_run_at"], name="mel_reports_is_acti_59bbee_idx"
                    )
                ],
            },
        ),
    ]