# Generated by Django 5.2.13 on 2026-04-24 08:05 import apps.core.storage.paths import django.db.models.deletion import simple_history.models from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ("mel_indicators", "0002_historicalindicatorvariance_indicatorvariance_and_more"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="HistoricalReportTemplate", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("name", models.CharField(db_index=True, max_length=255)), ("slug", models.SlugField(max_length=120)), ("description", models.TextField(blank=True)), ( "report_type", models.CharField( choices=[ ("quarterly", "Quarterly"), ("annual", "Annual"), ("project", "Project"), ("thematic", "Thematic"), ("donor", "Donor"), ("ad_hoc", "Ad hoc"), ], default="quarterly", max_length=16, ), ), ( "sections", models.JSONField( blank=True, default=list, help_text="Ordered list of section keys: indicator_rollup, activity_summary, variance_table, finance, compliance, narrative.", ), ), ( "schedule_cron", models.CharField( blank=True, help_text="Optional cron expression for scheduled generation — parsed by the generate_scheduled_reports Celery task.", max_length=100, ), ), ("is_active", models.BooleanField(db_index=True, default=True)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("updated_at", models.DateTimeField(blank=True, editable=False)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "created_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "logframe", models.ForeignKey( blank=True, db_constraint=False, help_text="Scope — when set, reports consolidate this logframe only.", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_indicators.logframe", ), ), ], options={ "verbose_name": "historical report template", "verbose_name_plural": "historical report templates", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="ReportTemplate", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("name", models.CharField(max_length=255, unique=True)), ("slug", models.SlugField(max_length=120, unique=True)), ("description", models.TextField(blank=True)), ( "report_type", models.CharField( choices=[ ("quarterly", "Quarterly"), ("annual", "Annual"), ("project", "Project"), ("thematic", "Thematic"), ("donor", "Donor"), ("ad_hoc", "Ad hoc"), ], default="quarterly", max_length=16, ), ), ( "sections", models.JSONField( blank=True, default=list, help_text="Ordered list of section keys: indicator_rollup, activity_summary, variance_table, finance, compliance, narrative.", ), ), ( "schedule_cron", models.CharField( blank=True, help_text="Optional cron expression for scheduled generation — parsed by the generate_scheduled_reports Celery task.", max_length=100, ), ), ("is_active", models.BooleanField(db_index=True, default=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_templates_created", to=settings.AUTH_USER_MODEL, ), ), ( "default_recipients", models.ManyToManyField( blank=True, related_name="mel_report_templates_subscribed", to=settings.AUTH_USER_MODEL, ), ), ( "logframe", models.ForeignKey( blank=True, help_text="Scope — when set, reports consolidate this logframe only.", null=True, on_delete=django.db.models.deletion.PROTECT, related_name="report_templates", to="mel_indicators.logframe", ), ), ], options={ "ordering": ["name"], }, ), migrations.CreateModel( name="Report", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("period_label", models.CharField(help_text="e.g. '2026-Q2'.", max_length=40)), ("period_start", models.DateField()), ("period_end", models.DateField()), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("in_review", "In review"), ("approved", "Approved"), ("published", "Published"), ("archived", "Archived"), ], db_index=True, default="draft", max_length=16, ), ), ( "consolidated_data", models.JSONField( default=dict, help_text="Snapshot of builder outputs at generation time." ), ), ( "narrative", models.TextField( blank=True, help_text="Human-written summary appended to the structured data.", ), ), ("generated_at", models.DateTimeField(auto_now_add=True)), ("approved_at", models.DateTimeField(blank=True, null=True)), ("published_at", models.DateTimeField(blank=True, null=True)), ( "generated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_reports_generated", to=settings.AUTH_USER_MODEL, ), ), ( "template", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="reports", to="mel_reports.reporttemplate", ), ), ], options={ "ordering": ["-generated_at"], }, ), migrations.CreateModel( name="HistoricalReport", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("period_label", models.CharField(help_text="e.g. '2026-Q2'.", max_length=40)), ("period_start", models.DateField()), ("period_end", models.DateField()), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("in_review", "In review"), ("approved", "Approved"), ("published", "Published"), ("archived", "Archived"), ], db_index=True, default="draft", max_length=16, ), ), ( "consolidated_data", models.JSONField( default=dict, help_text="Snapshot of builder outputs at generation time." ), ), ( "narrative", models.TextField( blank=True, help_text="Human-written summary appended to the structured data.", ), ), ("generated_at", models.DateTimeField(blank=True, editable=False)), ("approved_at", models.DateTimeField(blank=True, null=True)), ("published_at", models.DateTimeField(blank=True, null=True)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "generated_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "template", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_reports.reporttemplate", ), ), ], options={ "verbose_name": "historical report", "verbose_name_plural": "historical reports", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="ComplianceAlert", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("code", models.CharField(help_text="Machine-readable alert code.", max_length=80)), ( "severity", models.CharField( choices=[ ("low", "Low"), ("medium", "Medium"), ("high", "High"), ("critical", "Critical"), ], db_index=True, default="medium", max_length=16, ), ), ("message", models.TextField()), ("resolved", models.BooleanField(db_index=True, default=False)), ("resolved_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ( "indicator", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_compliance_alerts", to="mel_indicators.indicator", ), ), ( "resolved_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_compliance_alerts_resolved", to=settings.AUTH_USER_MODEL, ), ), ( "report", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="compliance_alerts", to="mel_reports.report", ), ), ], options={ "ordering": ["-created_at"], "indexes": [ models.Index( fields=["severity", "resolved"], name="mel_reports_severit_8cd848_idx" ), models.Index(fields=["report"], name="mel_reports_report__a691bc_idx"), ], }, ), migrations.CreateModel( name="ReportArtifact", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "format", models.CharField( choices=[ ("pdf", "PDF"), ("xlsx", "Excel"), ("csv", "CSV"), ("html", "HTML"), ], max_length=8, ), ), ( "file", models.FileField( max_length=500, upload_to=apps.core.storage.paths.upload_to_mel_reports ), ), ( "checksum", models.CharField( help_text="SHA-256 of the artefact bytes for tamper evidence.", max_length=64, ), ), ("size_bytes", models.PositiveIntegerField(default=0)), ("generated_at", models.DateTimeField(auto_now_add=True)), ( "report", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="artifacts", to="mel_reports.report", ), ), ], options={ "ordering": ["-generated_at"], "indexes": [ models.Index(fields=["report", "format"], name="mel_reports_report__9d4f20_idx") ], "constraints": [ models.UniqueConstraint( fields=("report", "format"), name="uniq_report_artifact_format" ) ], }, ), migrations.CreateModel( name="ReportDistribution", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "recipient_email", models.EmailField( blank=True, help_text="Used when the recipient is not a registered user.", max_length=254, ), ), ( "channel", models.CharField( choices=[ ("email", "Email"), ("download", "Download link"), ("portal", "Portal notification"), ], default="email", max_length=16, ), ), ( "status", models.CharField( choices=[("pending", "Pending"), ("sent", "Sent"), ("failed", "Failed")], db_index=True, default="pending", max_length=16, ), ), ("sent_at", models.DateTimeField(blank=True, null=True)), ("error", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ( "recipient_user", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_report_distributions", to=settings.AUTH_USER_MODEL, ), ), ( "report", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="distributions", to="mel_reports.report", ), ), ], options={ "ordering": ["-created_at"], "indexes": [ models.Index(fields=["report", "status"], name="mel_reports_report__a21b94_idx") ], }, ), migrations.AddIndex( model_name="report", index=models.Index( fields=["template", "period_label"], name="mel_reports_templat_c32859_idx" ), ), migrations.AddIndex( model_name="report", index=models.Index( fields=["status", "generated_at"], name="mel_reports_status_9358fe_idx" ), ), migrations.AddConstraint( model_name="report", constraint=models.UniqueConstraint( fields=("template", "period_label"), name="uniq_report_template_period" ), ), migrations.AddConstraint( model_name="report", constraint=models.CheckConstraint( condition=models.Q(("period_end__gte", models.F("period_start"))), name="report_period_end_after_start", ), ), ]