# Generated by Django 5.2.11 on 2026-02-24 19:18 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("strategy", "0002_add_objective_key_result_checkin"), ("tenant", "0003_tenant_locale_calendar_tenant_locale_country_and_more"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="KPIDefinitionModel", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=500, verbose_name="نام")), ( "code", models.CharField(db_index=True, max_length=100, verbose_name="کد"), ), ("description", models.TextField(blank=True, verbose_name="توضیحات")), ( "category", models.CharField( blank=True, max_length=200, verbose_name="دسته\u200cبندی" ), ), ( "unit_of_measure", models.CharField( blank=True, max_length=100, verbose_name="واحد اندازه\u200cگیری" ), ), ( "direction", models.CharField( choices=[ ("higher_is_better", "بالاتر بهتر"), ("lower_is_better", "پایین\u200cتر بهتر"), ("target", "هدف مشخص"), ], default="higher_is_better", max_length=20, verbose_name="جهت", ), ), ( "frequency", models.CharField( choices=[ ("daily", "روزانه"), ("weekly", "هفتگی"), ("monthly", "ماهانه"), ("quarterly", "سه\u200cماهه"), ("yearly", "سالانه"), ], default="monthly", max_length=20, verbose_name="فراوانی", ), ), ( "data_source", models.CharField( choices=[ ("manual", "دستی"), ("calculated", "محاسباتی"), ("integrated", "یکپارچه"), ], default="manual", max_length=20, verbose_name="منبع داده", ), ), ( "formula", models.TextField( blank=True, null=True, verbose_name="فرمول محاسبه" ), ), ( "threshold_red", models.DecimalField( blank=True, decimal_places=2, max_digits=15, null=True, verbose_name="آستانه قرمز", ), ), ( "threshold_yellow", models.DecimalField( blank=True, decimal_places=2, max_digits=15, null=True, verbose_name="آستانه زرد", ), ), ( "threshold_green", models.DecimalField( blank=True, decimal_places=2, max_digits=15, null=True, verbose_name="آستانه سبز", ), ), ( "responsible_role", models.CharField( blank=True, max_length=200, verbose_name="نقش مسئول" ), ), ( "status", models.CharField( choices=[ ("draft", "پیش\u200cنویس"), ("active", "فعال"), ("archived", "بایگانی"), ], default="draft", max_length=20, verbose_name="وضعیت", ), ), ( "tags", models.JSONField( blank=True, default=list, verbose_name="برچسب\u200cها" ), ), ( "metadata", models.JSONField(blank=True, default=dict, verbose_name="متادیتا"), ), ( "created_at", models.DateTimeField(auto_now_add=True, verbose_name="تاریخ ایجاد"), ), ( "updated_at", models.DateTimeField(auto_now=True, verbose_name="تاریخ بروزرسانی"), ), ( "owner", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="owned_kpis", to=settings.AUTH_USER_MODEL, verbose_name="مالک", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_set", to="tenant.tenant", ), ), ], options={ "verbose_name": "شاخص کلیدی عملکرد", "verbose_name_plural": "شاخص\u200cهای کلیدی عملکرد", "db_table": "str_kpi_definition", "ordering": ["name"], "unique_together": {("tenant", "code")}, }, ), migrations.CreateModel( name="KPIAssignmentModel", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("level", models.CharField(max_length=50, verbose_name="سطح")), ( "entity_id", models.UUIDField( blank=True, null=True, verbose_name="شناسه موجودیت" ), ), ( "weight", models.DecimalField( decimal_places=2, default=1.0, max_digits=5, verbose_name="وزن" ), ), ( "status", models.CharField( choices=[("active", "فعال"), ("inactive", "غیرفعال")], default="active", max_length=20, verbose_name="وضعیت", ), ), ("notes", models.TextField(blank=True, verbose_name="یادداشت")), ( "metadata", models.JSONField(blank=True, default=dict, verbose_name="متادیتا"), ), ( "created_at", models.DateTimeField(auto_now_add=True, verbose_name="تاریخ ایجاد"), ), ( "updated_at", models.DateTimeField(auto_now=True, verbose_name="تاریخ بروزرسانی"), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_set", to="tenant.tenant", ), ), ( "kpi", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="assignments", to="strategy.kpidefinitionmodel", verbose_name="شاخص", ), ), ], options={ "verbose_name": "تخصیص KPI", "verbose_name_plural": "تخصیص\u200cهای KPI", "db_table": "str_kpi_assignment", "ordering": ["level", "-created_at"], }, ), migrations.CreateModel( name="KPIActualModel", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "period_start", models.DateField(blank=True, null=True, verbose_name="شروع دوره"), ), ( "period_end", models.DateField(blank=True, null=True, verbose_name="پایان دوره"), ), ( "actual_value", models.DecimalField( decimal_places=2, default=0, max_digits=15, verbose_name="مقدار واقعی", ), ), ("notes", models.TextField(blank=True, verbose_name="یادداشت")), ( "source", models.CharField( default="manual", max_length=50, verbose_name="منبع" ), ), ( "metadata", models.JSONField(blank=True, default=dict, verbose_name="متادیتا"), ), ( "created_at", models.DateTimeField(auto_now_add=True, verbose_name="تاریخ ایجاد"), ), ( "updated_at", models.DateTimeField(auto_now=True, verbose_name="تاریخ بروزرسانی"), ), ( "recorded_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="recorded_kpi_actuals", to=settings.AUTH_USER_MODEL, verbose_name="ثبت\u200cکننده", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_set", to="tenant.tenant", ), ), ( "kpi", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="actuals", to="strategy.kpidefinitionmodel", verbose_name="شاخص", ), ), ], options={ "verbose_name": "مقدار واقعی KPI", "verbose_name_plural": "مقادیر واقعی KPI", "db_table": "str_kpi_actual", "ordering": ["-period_start"], }, ), migrations.CreateModel( name="KPITargetModel", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "period_start", models.DateField(blank=True, null=True, verbose_name="شروع دوره"), ), ( "period_end", models.DateField(blank=True, null=True, verbose_name="پایان دوره"), ), ( "target_value", models.DecimalField( decimal_places=2, default=0, max_digits=15, verbose_name="مقدار هدف", ), ), ( "stretch_value", models.DecimalField( blank=True, decimal_places=2, max_digits=15, null=True, verbose_name="مقدار چالشی", ), ), ("notes", models.TextField(blank=True, verbose_name="یادداشت")), ( "metadata", models.JSONField(blank=True, default=dict, verbose_name="متادیتا"), ), ( "created_at", models.DateTimeField(auto_now_add=True, verbose_name="تاریخ ایجاد"), ), ( "updated_at", models.DateTimeField(auto_now=True, verbose_name="تاریخ بروزرسانی"), ), ( "kpi", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="targets", to="strategy.kpidefinitionmodel", verbose_name="شاخص", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="%(class)s_set", to="tenant.tenant", ), ), ], options={ "verbose_name": "هدف\u200cگذاری KPI", "verbose_name_plural": "هدف\u200cگذاری\u200cهای KPI", "db_table": "str_kpi_target", "ordering": ["-period_start"], }, ), ]