# Generated by Django 5.1.3 on 2026-05-29 08:02

import django.db.models.deletion
import uuid
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ("organizations", "0001_initial"),
        ("platform_core", "0005_mention"),
        ("tenants", "0001_initial"),
    ]

    operations = [
        migrations.CreateModel(
            name="ReferenceNumberSequence",
            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",
                    ),
                ),
                (
                    "entity_type",
                    models.CharField(
                        db_index=True,
                        help_text="Dotted app_label.model_name, e.g. 'helpdesk.ticket'.",
                        max_length=128,
                        verbose_name="entity type",
                    ),
                ),
                (
                    "prefix",
                    models.CharField(
                        help_text="Short code prepended to the number, e.g. 'TK'.",
                        max_length=32,
                        verbose_name="prefix",
                    ),
                ),
                (
                    "format",
                    models.CharField(
                        default="{prefix}-{seq:04d}",
                        help_text="Python format string. Variables: {prefix}, {year}, {seq}. Example: '{prefix}-{year}-{seq:04d}'",
                        max_length=128,
                        verbose_name="format",
                    ),
                ),
                ("last_number", models.PositiveIntegerField(default=0, verbose_name="last number")),
                (
                    "reset_yearly",
                    models.BooleanField(
                        default=False,
                        help_text="If True, the counter resets to 0 at the start of each year.",
                        verbose_name="reset yearly",
                    ),
                ),
                (
                    "last_reset_year",
                    models.PositiveSmallIntegerField(
                        blank=True,
                        help_text="Year in which the counter was last reset (for reset_yearly).",
                        null=True,
                        verbose_name="last reset year",
                    ),
                ),
                (
                    "use_jalali_year",
                    models.BooleanField(
                        default=False,
                        help_text="Use the Persian (Jalali/Shamsi) year in the {year} variable.",
                        verbose_name="use Jalali year",
                    ),
                ),
                ("is_active", models.BooleanField(default=True, verbose_name="active")),
                (
                    "organization_node",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.PROTECT,
                        related_name="+",
                        to="organizations.organizationnode",
                        verbose_name="organization node",
                    ),
                ),
                (
                    "tenant",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="+",
                        to="tenants.tenant",
                        verbose_name="tenant",
                    ),
                ),
            ],
            options={
                "verbose_name": "reference number sequence",
                "verbose_name_plural": "reference number sequences",
                "ordering": ("entity_type",),
                "indexes": [
                    models.Index(
                        fields=["tenant", "entity_type", "is_active"],
                        name="platform_co_tenant__b3a8c9_idx",
                    )
                ],
                "constraints": [
                    models.UniqueConstraint(
                        fields=("tenant", "entity_type"),
                        name="platform_core_ref_seq_unique_tenant_entity",
                    )
                ],
            },
        ),
    ]