# Generated by Django 5.1.3 on 2026-06-01 08:23

import django.db.models.deletion
import django.utils.timezone
import uuid
from django.conf import settings
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ("bpm", "0005_rules_control_points"),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name="ProcessKPI",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                (
                    "created_at",
                    models.DateTimeField(
                        auto_now_add=True, db_index=True, verbose_name="created at"
                    ),
                ),
                ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")),
                (
                    "public_id",
                    models.UUIDField(
                        db_index=True,
                        default=uuid.uuid4,
                        editable=False,
                        unique=True,
                        verbose_name="public id",
                    ),
                ),
                ("code", models.CharField(max_length=40, verbose_name="code")),
                ("name", models.CharField(max_length=255, verbose_name="name")),
                ("name_fa", models.CharField(blank=True, max_length=255, verbose_name="name (FA)")),
                (
                    "category",
                    models.CharField(
                        choices=[
                            ("effectiveness", "Effectiveness / اثربخشی"),
                            ("efficiency", "Efficiency / کارایی"),
                            ("compliance", "Compliance / انطباق"),
                            ("quality", "Quality / کیفیت"),
                        ],
                        default="effectiveness",
                        max_length=20,
                        verbose_name="category",
                    ),
                ),
                (
                    "formula",
                    models.TextField(
                        blank=True,
                        help_text="Calculation formula or description.",
                        verbose_name="formula",
                    ),
                ),
                (
                    "target_value",
                    models.DecimalField(
                        decimal_places=4, max_digits=18, verbose_name="target value"
                    ),
                ),
                (
                    "target_operator",
                    models.CharField(
                        choices=[
                            (">=", "≥ (greater than or equal)"),
                            ("<=", "≤ (less than or equal)"),
                            ("=", "= (equal)"),
                            (">", "› (greater than)"),
                            ("<", "‹ (less than)"),
                        ],
                        default=">=",
                        max_length=2,
                        verbose_name="target operator",
                    ),
                ),
                (
                    "unit",
                    models.CharField(
                        blank=True,
                        help_text="%  |  day  |  count  |  score …",
                        max_length=30,
                        verbose_name="unit",
                    ),
                ),
                (
                    "frequency",
                    models.CharField(
                        blank=True,
                        help_text="How often to measure, e.g. 'سالانه', 'هر ارزیابی'.",
                        max_length=100,
                        verbose_name="measurement frequency",
                    ),
                ),
                ("description", models.TextField(blank=True, verbose_name="description")),
                (
                    "owner_role",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.SET_NULL,
                        related_name="owned_kpis",
                        to="bpm.processrole",
                        verbose_name="owner role",
                    ),
                ),
                (
                    "pcf_metric",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.SET_NULL,
                        related_name="process_kpis",
                        to="bpm.pcfmetric",
                        verbose_name="PCF metric",
                    ),
                ),
                (
                    "process",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="kpis",
                        to="bpm.processdefinition",
                        verbose_name="process",
                    ),
                ),
            ],
            options={
                "verbose_name": "process KPI",
                "verbose_name_plural": "process KPIs",
                "ordering": ("process", "category", "code"),
            },
        ),
        migrations.CreateModel(
            name="ProcessKPIMeasurement",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                (
                    "created_at",
                    models.DateTimeField(
                        auto_now_add=True, db_index=True, verbose_name="created at"
                    ),
                ),
                ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")),
                (
                    "process_instance_id",
                    models.UUIDField(
                        blank=True,
                        help_text="FK to ProcessInstance.public_id — wired in Phase 6.",
                        null=True,
                        verbose_name="process instance ID",
                    ),
                ),
                (
                    "measured_at",
                    models.DateTimeField(
                        default=django.utils.timezone.now, verbose_name="measured at"
                    ),
                ),
                (
                    "value",
                    models.DecimalField(decimal_places=4, max_digits=18, verbose_name="value"),
                ),
                ("notes", models.TextField(blank=True, verbose_name="notes")),
                (
                    "kpi",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="measurements",
                        to="bpm.processkpi",
                        verbose_name="KPI",
                    ),
                ),
                (
                    "measured_by",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.SET_NULL,
                        related_name="bpm_kpi_measurements",
                        to=settings.AUTH_USER_MODEL,
                        verbose_name="measured by",
                    ),
                ),
            ],
            options={
                "verbose_name": "KPI measurement",
                "verbose_name_plural": "KPI measurements",
                "ordering": ("-measured_at",),
            },
        ),
        migrations.CreateModel(
            name="KPIAlert",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                (
                    "created_at",
                    models.DateTimeField(
                        auto_now_add=True, db_index=True, verbose_name="created at"
                    ),
                ),
                ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")),
                (
                    "alert_type",
                    models.CharField(
                        choices=[
                            ("below_target", "Below Target"),
                            ("above_target", "Above Target"),
                        ],
                        max_length=20,
                        verbose_name="alert type",
                    ),
                ),
                (
                    "notified_users",
                    models.ManyToManyField(
                        blank=True,
                        related_name="bpm_kpi_alerts",
                        to=settings.AUTH_USER_MODEL,
                        verbose_name="notified users",
                    ),
                ),
                (
                    "kpi",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="alerts",
                        to="bpm.processkpi",
                        verbose_name="KPI",
                    ),
                ),
                (
                    "measurement",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="alerts",
                        to="bpm.processkpimeasurement",
                        verbose_name="measurement",
                    ),
                ),
            ],
            options={
                "verbose_name": "KPI alert",
                "verbose_name_plural": "KPI alerts",
                "ordering": ("-created_at",),
            },
        ),
        migrations.AddConstraint(
            model_name="processkpi",
            constraint=models.UniqueConstraint(
                fields=("process", "code"), name="bpm_processkpi_process_code_uniq"
            ),
        ),
    ]