"""
Inventory ORM Models — Extended (Stock, Batch, Costing, Reservation, QC, Reporting).

ادامه مدل‌ها — جداسازی برای خوانایی بهتر.
"""
import uuid

from django.db import models
from django.utils.translation import gettext_lazy as _

from apps.core.tenant.models import TenantAwareModel
from .models import (
    ItemModel, WarehouseModel, StorageLocationModel, UnitOfMeasureModel,
)


# ═══════════════════════════════════════════════════════════════════════════
# 3️⃣  STOCK STATUS & LEDGER
# ═══════════════════════════════════════════════════════════════════════════


class StockStatusModel(TenantAwareModel):
    """وضعیت موجودی."""

    class StatusType(models.TextChoices):
        AVAILABLE = "AVAILABLE", _("در دسترس")
        RESERVED = "RESERVED", _("رزرو شده")
        ALLOCATED = "ALLOCATED", _("تخصیص‌یافته")
        BLOCKED = "BLOCKED", _("مسدود")
        QUALITY_INSPECTION = "QUALITY_INSPECTION", _("بازرسی کیفی")
        QUARANTINE = "QUARANTINE", _("قرنطینه")
        IN_TRANSIT = "IN_TRANSIT", _("در راه")
        DAMAGED = "DAMAGED", _("آسیب‌دیده")
        EXPIRED = "EXPIRED", _("منقضی")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    status_code = models.CharField(_("کد وضعیت"), max_length=50)
    status_name = models.CharField(_("نام وضعیت"), max_length=100)
    status_type = models.CharField(
        _("نوع"), max_length=30,
        choices=StatusType.choices, default=StatusType.AVAILABLE,
    )
    is_available_for_sales = models.BooleanField(_("قابل فروش"), default=True)
    is_available_for_production = models.BooleanField(_("قابل تولید"), default=True)
    is_blocked_for_movement = models.BooleanField(_("مسدود برای جابجایی"), default=False)
    sort_order = models.PositiveIntegerField(_("ترتیب"), default=0)
    is_active = models.BooleanField(_("فعال"), default=True, db_index=True)

    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    updated_at = models.DateTimeField(_("تاریخ بروزرسانی"), auto_now=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_stock_status"
        verbose_name = _("وضعیت موجودی")
        verbose_name_plural = _("وضعیت‌های موجودی")
        unique_together = [["tenant", "status_code"]]
        ordering = ["sort_order"]

    def __str__(self):
        return self.status_name


class BatchModel(TenantAwareModel):
    """بچ / لات."""

    class BatchStatus(models.TextChoices):
        ACTIVE = "ACTIVE", _("فعال")
        EXPIRED = "EXPIRED", _("منقضی")
        BLOCKED = "BLOCKED", _("مسدود")
        QUARANTINE = "QUARANTINE", _("قرنطینه")

    class QualityStatus(models.TextChoices):
        APPROVED = "APPROVED", _("تأیید شده")
        PENDING = "PENDING", _("در انتظار")
        REJECTED = "REJECTED", _("رد شده")
        CONDITIONAL = "CONDITIONAL", _("مشروط")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    batch_number = models.CharField(_("شماره بچ"), max_length=100, db_index=True)
    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="batches", verbose_name=_("کالا"),
    )
    manufacturing_date = models.DateField(_("تاریخ تولید"), null=True, blank=True)
    expiry_date = models.DateField(_("تاریخ انقضا"), null=True, blank=True, db_index=True)
    vendor_batch_number = models.CharField(_("شماره بچ تأمین‌کننده"), max_length=100, blank=True)
    vendor = models.ForeignKey(
        "core_organization.BusinessPartner", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("تأمین‌کننده"),
    )
    production_order_id = models.UUIDField(_("سفارش تولید"), null=True, blank=True)

    batch_status = models.CharField(
        _("وضعیت بچ"), max_length=20,
        choices=BatchStatus.choices, default=BatchStatus.ACTIVE,
    )
    quality_status = models.CharField(
        _("وضعیت کیفی"), max_length=20,
        choices=QualityStatus.choices, default=QualityStatus.PENDING,
    )

    batch_attributes = models.JSONField(_("ویژگی‌ها"), default=dict, blank=True)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    is_active = models.BooleanField(_("فعال"), default=True)

    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    updated_at = models.DateTimeField(_("تاریخ بروزرسانی"), auto_now=True)
    created_by = models.UUIDField(_("ایجاد توسط"), null=True, blank=True)
    updated_by = models.UUIDField(_("بروزرسانی توسط"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_batch"
        verbose_name = _("بچ / لات")
        verbose_name_plural = _("بچ‌ها / لات‌ها")
        unique_together = [["tenant", "batch_number"]]
        indexes = [
            models.Index(fields=["tenant", "item", "batch_status"]),
            models.Index(fields=["expiry_date"]),
        ]

    def __str__(self):
        return f"{self.batch_number} ({self.item.item_code})"


class SerialNumberModel(TenantAwareModel):
    """شماره سریال."""

    class SerialStatus(models.TextChoices):
        IN_STOCK = "IN_STOCK", _("در انبار")
        SOLD = "SOLD", _("فروخته‌شده")
        RETURNED = "RETURNED", _("مرجوعی")
        SCRAPPED = "SCRAPPED", _("اسقاطی")
        IN_REPAIR = "IN_REPAIR", _("در تعمیر")
        IN_TRANSIT = "IN_TRANSIT", _("در راه")

    class QualityStatus(models.TextChoices):
        APPROVED = "APPROVED", _("تأیید شده")
        REJECTED = "REJECTED", _("رد شده")
        QUARANTINE = "QUARANTINE", _("قرنطینه")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    serial_no = models.CharField(_("شماره سریال"), max_length=200, db_index=True)
    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="serial_numbers", verbose_name=_("کالا"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="serial_numbers", verbose_name=_("بچ"),
    )

    manufacturing_date = models.DateField(_("تاریخ تولید"), null=True, blank=True)
    warranty_start_date = models.DateField(_("شروع گارانتی"), null=True, blank=True)
    warranty_end_date = models.DateField(_("پایان گارانتی"), null=True, blank=True)
    warranty_months = models.PositiveIntegerField(_("مدت گارانتی (ماه)"), default=0)

    # Current location
    current_warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("انبار فعلی"),
    )
    current_location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("مکان فعلی"),
    )
    current_stock_status = models.ForeignKey(
        StockStatusModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("وضعیت فعلی"),
    )

    # Ownership
    current_owner_type = models.CharField(_("نوع مالکیت"), max_length=30, default="OWN")
    current_owner_id = models.UUIDField(_("مالک فعلی"), null=True, blank=True)

    # Status
    serial_status = models.CharField(
        _("وضعیت سریال"), max_length=20,
        choices=SerialStatus.choices, default=SerialStatus.IN_STOCK, db_index=True,
    )
    quality_status = models.CharField(
        _("وضعیت کیفی"), max_length=20,
        choices=QualityStatus.choices, default=QualityStatus.APPROVED,
    )

    # Traceability
    supplier_serial_number = models.CharField(_("سریال تأمین‌کننده"), max_length=200, blank=True)
    vendor_id = models.UUIDField(_("تأمین‌کننده"), null=True, blank=True)
    purchase_order_id = models.UUIDField(_("سفارش خرید"), null=True, blank=True)
    sales_order_id = models.UUIDField(_("سفارش فروش"), null=True, blank=True)
    customer_id = models.UUIDField(_("مشتری"), null=True, blank=True)
    sold_date = models.DateField(_("تاریخ فروش"), null=True, blank=True)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    is_active = models.BooleanField(_("فعال"), default=True)

    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    updated_at = models.DateTimeField(_("تاریخ بروزرسانی"), auto_now=True)
    created_by = models.UUIDField(_("ایجاد توسط"), null=True, blank=True)
    updated_by = models.UUIDField(_("بروزرسانی توسط"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_serial_number"
        verbose_name = _("شماره سریال")
        verbose_name_plural = _("شماره‌های سریال")
        unique_together = [["tenant", "serial_no"]]
        indexes = [
            models.Index(fields=["tenant", "item", "serial_status"]),
        ]

    def __str__(self):
        return f"{self.serial_no} ({self.item.item_code})"


class SerialNumberHistoryModel(TenantAwareModel):
    """تاریخچه سریال."""

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    serial_number = models.ForeignKey(
        SerialNumberModel, on_delete=models.CASCADE,
        related_name="history", verbose_name=_("سریال"),
    )
    stock_ledger = models.ForeignKey(
        "StockLedgerEntryModel", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("ثبت دفتر"),
    )
    transaction_date = models.DateTimeField(_("تاریخ"))
    transaction_type = models.CharField(_("نوع تراکنش"), max_length=50)

    from_warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("از انبار"),
    )
    to_warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("به انبار"),
    )
    from_location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("از مکان"),
    )
    to_location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("به مکان"),
    )
    from_status = models.ForeignKey(
        StockStatusModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("از وضعیت"),
    )
    to_status = models.ForeignKey(
        StockStatusModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("به وضعیت"),
    )
    remarks = models.TextField(_("توضیحات"), blank=True)
    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_serial_number_history"
        verbose_name = _("تاریخچه سریال")
        verbose_name_plural = _("تاریخچه سریال‌ها")
        ordering = ["-transaction_date"]

    def __str__(self):
        return f"{self.serial_number.serial_no} — {self.transaction_type}"


# ═══════════════════════════════════════════════════════════════════════════
# 4️⃣  STOCK LEDGER
# ═══════════════════════════════════════════════════════════════════════════


class StockLedgerEntryModel(TenantAwareModel):
    """دفتر کل موجودی — هر حرکت = یک ثبت."""

    class TransactionType(models.TextChoices):
        GR = "GR", _("رسید کالا")
        GI = "GI", _("حواله کالا")
        TRANSFER = "TRANSFER", _("انتقال")
        ADJUSTMENT = "ADJUSTMENT", _("تعدیل")
        RETURN = "RETURN", _("مرجوعی")
        SCRAP = "SCRAP", _("ضایعات")

    class OwnershipType(models.TextChoices):
        OWN = "OWN", _("خودی")
        CONSIGNMENT_CUSTOMER = "CONSIGNMENT_CUSTOMER", _("امانی مشتری")
        CONSIGNMENT_VENDOR = "CONSIGNMENT_VENDOR", _("امانی تأمین‌کننده")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    entry_number = models.CharField(
        _("شماره ثبت"), max_length=50, unique=True, db_index=True
    )
    posting_date = models.DateField(_("تاریخ ثبت"), db_index=True)
    posting_time = models.TimeField(_("ساعت ثبت"), null=True, blank=True)

    # Dimensions
    item = models.ForeignKey(
        ItemModel, on_delete=models.PROTECT,
        related_name="ledger_entries", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.PROTECT,
        related_name="ledger_entries", verbose_name=_("انبار"),
    )
    location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("مکان"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="ledger_entries", verbose_name=_("بچ"),
    )
    serial_number = models.ForeignKey(
        SerialNumberModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="ledger_entries", verbose_name=_("سریال"),
    )
    stock_status = models.ForeignKey(
        StockStatusModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("وضعیت"),
    )

    ownership_type = models.CharField(
        _("نوع مالکیت"), max_length=30,
        choices=OwnershipType.choices, default=OwnershipType.OWN,
    )
    owner_id = models.UUIDField(_("مالک"), null=True, blank=True)
    project_id = models.UUIDField(_("پروژه"), null=True, blank=True)

    # Transaction
    transaction_type = models.CharField(
        _("نوع تراکنش"), max_length=20,
        choices=TransactionType.choices, db_index=True,
    )
    transaction_sub_type = models.CharField(
        _("زیرنوع"), max_length=50, blank=True
    )
    source_document_type = models.CharField(
        _("نوع سند مبدأ"), max_length=50, blank=True
    )
    source_document_id = models.UUIDField(_("سند مبدأ"), null=True, blank=True)
    source_document_line_id = models.UUIDField(_("خط سند"), null=True, blank=True)

    # Quantity
    quantity = models.DecimalField(
        _("مقدار"), max_digits=18, decimal_places=4,
        help_text=_("مثبت=ورود، منفی=خروج"),
    )
    uom = models.ForeignKey(
        UnitOfMeasureModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("واحد"),
    )
    quantity_in_base_uom = models.DecimalField(
        _("مقدار (واحد پایه)"), max_digits=18, decimal_places=4,
    )

    # Costing
    unit_cost = models.DecimalField(
        _("بهای واحد"), max_digits=18, decimal_places=4, default=0
    )
    total_cost = models.DecimalField(
        _("بهای کل"), max_digits=18, decimal_places=4, default=0
    )
    costing_method = models.ForeignKey(
        "CostingMethodModel", on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("روش قیمت‌گذاری"),
    )
    currency_code = models.CharField(_("ارز"), max_length=10, default="IRR")

    # References
    reason_code = models.CharField(_("کد دلیل"), max_length=50, blank=True)
    remarks = models.TextField(_("توضیحات"), blank=True)
    reference_number = models.CharField(_("شماره مرجع"), max_length=100, blank=True)

    # Reversal
    is_reversed = models.BooleanField(_("برگشت‌خورده"), default=False)
    reversed_by_sle = models.ForeignKey(
        "self", on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("برگشت توسط"),
    )

    # Company
    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )

    # Fiscal
    fiscal_year = models.PositiveIntegerField(_("سال مالی"), default=0)
    fiscal_period = models.PositiveIntegerField(_("دوره مالی"), default=0)

    # Audit
    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    created_by = models.UUIDField(_("ایجاد توسط"), null=True, blank=True)
    approved_by = models.UUIDField(_("تأیید توسط"), null=True, blank=True)
    approved_at = models.DateTimeField(_("تاریخ تأیید"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_stock_ledger_entry"
        verbose_name = _("ثبت دفتر موجودی")
        verbose_name_plural = _("ثبت‌های دفتر موجودی")
        indexes = [
            models.Index(fields=["tenant", "item", "posting_date"]),
            models.Index(fields=["tenant", "warehouse", "posting_date"]),
            models.Index(fields=["tenant", "item", "warehouse", "posting_date"]),
            models.Index(fields=["tenant", "batch"]),
            models.Index(fields=["tenant", "serial_number"]),
            models.Index(fields=["tenant", "transaction_type"]),
        ]

    def __str__(self):
        return f"{self.entry_number} — {self.item.item_code} ({self.quantity})"


class StockBalanceModel(TenantAwareModel):
    """موجودی فعلی — Materialized View / Trigger-updated."""

    class OwnershipType(models.TextChoices):
        OWN = "OWN", _("خودی")
        CONSIGNMENT_CUSTOMER = "CONSIGNMENT_CUSTOMER", _("امانی مشتری")
        CONSIGNMENT_VENDOR = "CONSIGNMENT_VENDOR", _("امانی تأمین‌کننده")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="balances", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="balances", verbose_name=_("انبار"),
    )
    location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("مکان"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="balances", verbose_name=_("بچ"),
    )
    serial_number = models.ForeignKey(
        SerialNumberModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="balances", verbose_name=_("سریال"),
    )
    stock_status = models.ForeignKey(
        StockStatusModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("وضعیت"),
    )
    ownership_type = models.CharField(
        _("نوع مالکیت"), max_length=30,
        choices=OwnershipType.choices, default=OwnershipType.OWN,
    )
    owner_id = models.UUIDField(_("مالک"), null=True, blank=True)
    project_id = models.UUIDField(_("پروژه"), null=True, blank=True)

    # Quantities
    quantity_on_hand = models.DecimalField(
        _("موجودی کل"), max_digits=18, decimal_places=4, default=0
    )
    quantity_reserved = models.DecimalField(
        _("رزرو شده"), max_digits=18, decimal_places=4, default=0
    )
    quantity_allocated = models.DecimalField(
        _("تخصیص‌یافته"), max_digits=18, decimal_places=4, default=0
    )
    quantity_available = models.DecimalField(
        _("در دسترس"), max_digits=18, decimal_places=4, default=0
    )
    quantity_in_transit = models.DecimalField(
        _("در راه"), max_digits=18, decimal_places=4, default=0
    )
    uom = models.ForeignKey(
        UnitOfMeasureModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("واحد"),
    )

    # Dates
    last_movement_date = models.DateField(_("آخرین حرکت"), null=True, blank=True)
    last_count_date = models.DateField(_("آخرین شمارش"), null=True, blank=True)

    # Valuation
    average_unit_cost = models.DecimalField(
        _("میانگین بهای واحد"), max_digits=18, decimal_places=4, default=0
    )
    total_value = models.DecimalField(
        _("ارزش کل"), max_digits=18, decimal_places=4, default=0
    )

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    last_updated = models.DateTimeField(_("آخرین بروزرسانی"), auto_now=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_stock_balance"
        verbose_name = _("موجودی فعلی")
        verbose_name_plural = _("موجودی‌های فعلی")
        indexes = [
            models.Index(fields=["tenant", "item", "warehouse"]),
            models.Index(fields=["tenant", "item"]),
            models.Index(fields=["tenant", "warehouse"]),
        ]

    def __str__(self):
        return f"{self.item.item_code}@{self.warehouse.warehouse_code}: {self.quantity_on_hand}"


# ═══════════════════════════════════════════════════════════════════════════
# 5️⃣  COSTING & VALUATION
# ═══════════════════════════════════════════════════════════════════════════


class CostingMethodModel(TenantAwareModel):
    """روش قیمت‌گذاری."""

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    method_code = models.CharField(_("کد"), max_length=20)
    method_name = models.CharField(_("نام"), max_length=100)
    description = models.TextField(_("توضیحات"), blank=True)
    is_active = models.BooleanField(_("فعال"), default=True)

    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    updated_at = models.DateTimeField(_("تاریخ بروزرسانی"), auto_now=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_costing_method"
        verbose_name = _("روش قیمت‌گذاری")
        verbose_name_plural = _("روش‌های قیمت‌گذاری")
        unique_together = [["tenant", "method_code"]]

    def __str__(self):
        return self.method_name


class ItemCostingModel(TenantAwareModel):
    """قیمت‌گذاری کالا."""

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    item = models.OneToOneField(
        ItemModel, on_delete=models.CASCADE,
        related_name="costing", verbose_name=_("کالا"),
    )
    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    costing_method = models.ForeignKey(
        CostingMethodModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("روش قیمت‌گذاری"),
    )

    standard_cost = models.DecimalField(
        _("بهای استاندارد"), max_digits=18, decimal_places=4, default=0
    )
    moving_average_cost = models.DecimalField(
        _("میانگین متحرک"), max_digits=18, decimal_places=4, default=0
    )
    last_purchase_cost = models.DecimalField(
        _("آخرین بهای خرید"), max_digits=18, decimal_places=4, default=0
    )
    currency_code = models.CharField(_("ارز"), max_length=10, default="IRR")
    last_cost_update_date = models.DateField(
        _("تاریخ آخرین بروزرسانی بها"), null=True, blank=True
    )
    is_active = models.BooleanField(_("فعال"), default=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_item_costing"
        verbose_name = _("قیمت‌گذاری کالا")
        verbose_name_plural = _("قیمت‌گذاری کالاها")

    def __str__(self):
        return f"{self.item.item_code} — {self.costing_method.method_code}"


class CostLayerModel(TenantAwareModel):
    """لایه هزینه — FIFO/LIFO."""

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="cost_layers", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("انبار"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("بچ"),
    )
    receipt_date = models.DateField(_("تاریخ رسید"))
    receipt_sle = models.ForeignKey(
        StockLedgerEntryModel, on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("ثبت رسید"),
    )

    unit_cost = models.DecimalField(
        _("بهای واحد"), max_digits=18, decimal_places=4
    )
    original_quantity = models.DecimalField(
        _("مقدار اولیه"), max_digits=18, decimal_places=4
    )
    remaining_quantity = models.DecimalField(
        _("مقدار باقیمانده"), max_digits=18, decimal_places=4
    )
    uom = models.ForeignKey(
        UnitOfMeasureModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("واحد"),
    )
    currency_code = models.CharField(_("ارز"), max_length=10, default="IRR")
    is_fully_consumed = models.BooleanField(_("مصرف‌شده"), default=False)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )

    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_cost_layer"
        verbose_name = _("لایه هزینه")
        verbose_name_plural = _("لایه‌های هزینه")
        indexes = [
            models.Index(fields=["tenant", "item", "warehouse", "receipt_date"]),
        ]

    def __str__(self):
        return f"{self.item.item_code} — {self.receipt_date} — {self.remaining_quantity}"


class FinancialPostingModel(TenantAwareModel):
    """ارسال به حسابداری."""

    class PostingStatus(models.TextChoices):
        PENDING = "PENDING", _("در انتظار")
        POSTED = "POSTED", _("ثبت شده")
        FAILED = "FAILED", _("ناموفق")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    stock_ledger = models.ForeignKey(
        StockLedgerEntryModel, on_delete=models.CASCADE,
        related_name="financial_postings", verbose_name=_("ثبت دفتر"),
    )
    posting_date = models.DateField(_("تاریخ ثبت"))
    journal_entry_id = models.UUIDField(_("سند حسابداری"), null=True, blank=True)

    debit_account = models.CharField(_("حساب بدهکار"), max_length=50)
    credit_account = models.CharField(_("حساب بستانکار"), max_length=50)
    amount = models.DecimalField(_("مبلغ"), max_digits=18, decimal_places=4)
    currency_code = models.CharField(_("ارز"), max_length=10, default="IRR")

    cost_center_id = models.UUIDField(_("مرکز هزینه"), null=True, blank=True)
    project_id = models.UUIDField(_("پروژه"), null=True, blank=True)

    posting_status = models.CharField(
        _("وضعیت"), max_length=20,
        choices=PostingStatus.choices, default=PostingStatus.PENDING,
    )
    error_message = models.TextField(_("پیام خطا"), blank=True)
    posted_date = models.DateField(_("تاریخ ارسال"), null=True, blank=True)
    posted_by = models.UUIDField(_("ارسال توسط"), null=True, blank=True)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_financial_posting"
        verbose_name = _("ارسال مالی")
        verbose_name_plural = _("ارسال‌های مالی")
        indexes = [
            models.Index(fields=["tenant", "stock_ledger"]),
            models.Index(fields=["posting_status"]),
        ]

    def __str__(self):
        return f"FP-{self.stock_ledger.entry_number} ({self.posting_status})"


# ═══════════════════════════════════════════════════════════════════════════
# 6️⃣  RESERVATION & ALLOCATION
# ═══════════════════════════════════════════════════════════════════════════


class StockReservationModel(TenantAwareModel):
    """رزرو موجودی."""

    class ReservationStatus(models.TextChoices):
        ACTIVE = "ACTIVE", _("فعال")
        PARTIALLY_ALLOCATED = "PARTIALLY_ALLOCATED", _("تخصیص جزئی")
        FULLY_ALLOCATED = "FULLY_ALLOCATED", _("تخصیص کامل")
        EXPIRED = "EXPIRED", _("منقضی")
        CANCELLED = "CANCELLED", _("لغو شده")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    reservation_number = models.CharField(
        _("شماره رزرو"), max_length=50, unique=True
    )
    reservation_date = models.DateField(_("تاریخ رزرو"))

    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="reservations", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("انبار"),
    )
    location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("مکان"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("بچ"),
    )
    serial_number = models.ForeignKey(
        SerialNumberModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("سریال"),
    )

    reserved_quantity = models.DecimalField(
        _("مقدار رزرو"), max_digits=18, decimal_places=4
    )
    allocated_quantity = models.DecimalField(
        _("مقدار تخصیص"), max_digits=18, decimal_places=4, default=0
    )
    uom = models.ForeignKey(
        UnitOfMeasureModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("واحد"),
    )

    source_document_type = models.CharField(
        _("نوع سند مبدأ"), max_length=50, blank=True
    )
    source_document_id = models.UUIDField(_("سند مبدأ"), null=True, blank=True)
    source_document_line_id = models.UUIDField(_("خط سند"), null=True, blank=True)

    priority_level = models.PositiveIntegerField(_("اولویت"), default=5)
    expiry_date = models.DateField(_("تاریخ انقضای رزرو"), null=True, blank=True)
    reservation_status = models.CharField(
        _("وضعیت"), max_length=30,
        choices=ReservationStatus.choices, default=ReservationStatus.ACTIVE,
    )

    required_by_date = models.DateField(_("نیاز تا تاریخ"), null=True, blank=True)
    requested_by_user_id = models.UUIDField(_("درخواست‌کننده"), null=True, blank=True)
    remarks = models.TextField(_("توضیحات"), blank=True)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )

    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    created_by = models.UUIDField(_("ایجاد توسط"), null=True, blank=True)
    cancelled_at = models.DateTimeField(_("تاریخ لغو"), null=True, blank=True)
    cancelled_by = models.UUIDField(_("لغو توسط"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_stock_reservation"
        verbose_name = _("رزرو موجودی")
        verbose_name_plural = _("رزروهای موجودی")
        indexes = [
            models.Index(fields=["tenant", "item", "reservation_status"]),
        ]

    def __str__(self):
        return f"{self.reservation_number} — {self.item.item_code}"


class StockAllocationModel(TenantAwareModel):
    """تخصیص موجودی."""

    class AllocationStatus(models.TextChoices):
        ALLOCATED = "ALLOCATED", _("تخصیص‌یافته")
        PARTIALLY_PICKED = "PARTIALLY_PICKED", _("برداشت جزئی")
        FULLY_PICKED = "FULLY_PICKED", _("برداشت کامل")
        CANCELLED = "CANCELLED", _("لغو شده")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    allocation_number = models.CharField(
        _("شماره تخصیص"), max_length=50, unique=True
    )
    allocation_date = models.DateField(_("تاریخ تخصیص"))
    reservation = models.ForeignKey(
        StockReservationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="allocations", verbose_name=_("رزرو"),
    )

    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("انبار"),
    )
    location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("مکان"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("بچ"),
    )
    serial_number = models.ForeignKey(
        SerialNumberModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("سریال"),
    )

    allocated_quantity = models.DecimalField(
        _("مقدار تخصیص"), max_digits=18, decimal_places=4
    )
    picked_quantity = models.DecimalField(
        _("مقدار برداشت"), max_digits=18, decimal_places=4, default=0
    )
    uom = models.ForeignKey(
        UnitOfMeasureModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("واحد"),
    )

    source_document_type = models.CharField(
        _("نوع سند"), max_length=50, blank=True
    )
    source_document_id = models.UUIDField(_("سند"), null=True, blank=True)
    source_document_line_id = models.UUIDField(_("خط سند"), null=True, blank=True)

    allocation_status = models.CharField(
        _("وضعیت"), max_length=30,
        choices=AllocationStatus.choices, default=AllocationStatus.ALLOCATED,
    )
    picking_user_id = models.UUIDField(_("برداشت‌کننده"), null=True, blank=True)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    created_by = models.UUIDField(_("ایجاد توسط"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_stock_allocation"
        verbose_name = _("تخصیص موجودی")
        verbose_name_plural = _("تخصیص‌های موجودی")

    def __str__(self):
        return f"{self.allocation_number} — {self.item.item_code}"


# ═══════════════════════════════════════════════════════════════════════════
# 7️⃣  PHYSICAL INVENTORY
# ═══════════════════════════════════════════════════════════════════════════


class PhysicalInventoryModel(TenantAwareModel):
    """سند شمارش فیزیکی."""

    class InventoryType(models.TextChoices):
        FULL = "FULL", _("کامل")
        PARTIAL = "PARTIAL", _("جزئی")
        CYCLE_COUNT = "CYCLE_COUNT", _("چرخشی")

    class InventoryStatus(models.TextChoices):
        DRAFT = "DRAFT", _("پیش‌نویس")
        IN_PROGRESS = "IN_PROGRESS", _("در حال انجام")
        COUNTING = "COUNTING", _("شمارش")
        COMPLETED = "COMPLETED", _("تکمیل‌شده")
        CANCELLED = "CANCELLED", _("لغو شده")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    inventory_number = models.CharField(
        _("شماره شمارش"), max_length=50, unique=True
    )
    inventory_date = models.DateField(_("تاریخ شمارش"))
    inventory_type = models.CharField(
        _("نوع"), max_length=20,
        choices=InventoryType.choices, default=InventoryType.FULL,
    )

    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("انبار"),
    )
    location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("مکان"),
    )
    item_group = models.ForeignKey(
        "ItemGroupModel", on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("گروه کالا"),
    )
    abc_class_filter = models.CharField(_("فیلتر ABC"), max_length=20, blank=True)

    inventory_status = models.CharField(
        _("وضعیت"), max_length=20,
        choices=InventoryStatus.choices, default=InventoryStatus.DRAFT,
    )
    is_blind_count = models.BooleanField(_("شمارش کور"), default=False)
    is_stock_frozen = models.BooleanField(_("فریز موجودی"), default=False)

    required_count_times = models.PositiveIntegerField(_("تعداد دفعات شمارش"), default=1)
    variance_threshold_percent = models.DecimalField(
        _("آستانه انحراف (٪)"), max_digits=5, decimal_places=2, default=5
    )

    scheduled_start_date = models.DateField(_("تاریخ برنامه‌ریزی"), null=True, blank=True)
    actual_start_date = models.DateField(_("تاریخ شروع واقعی"), null=True, blank=True)
    completed_date = models.DateField(_("تاریخ تکمیل"), null=True, blank=True)

    responsible_user_id = models.UUIDField(_("مسئول"), null=True, blank=True)
    approved_by = models.UUIDField(_("تأیید توسط"), null=True, blank=True)
    approved_date = models.DateField(_("تاریخ تأیید"), null=True, blank=True)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    remarks = models.TextField(_("توضیحات"), blank=True)

    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    created_by = models.UUIDField(_("ایجاد توسط"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_physical_inventory"
        verbose_name = _("شمارش فیزیکی")
        verbose_name_plural = _("شمارش‌های فیزیکی")

    def __str__(self):
        return f"{self.inventory_number} ({self.inventory_status})"


class PhysicalInventoryLineModel(TenantAwareModel):
    """اقلام شمارش فیزیکی."""

    class LineStatus(models.TextChoices):
        PENDING = "PENDING", _("در انتظار")
        COUNTED = "COUNTED", _("شمارش‌شده")
        VARIANCE_APPROVED = "VARIANCE_APPROVED", _("انحراف تأیید شده")
        ADJUSTED = "ADJUSTED", _("تعدیل‌شده")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    physical_inventory = models.ForeignKey(
        PhysicalInventoryModel, on_delete=models.CASCADE,
        related_name="lines", verbose_name=_("شمارش فیزیکی"),
    )
    line_number = models.PositiveIntegerField(_("شماره ردیف"))

    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("انبار"),
    )
    location = models.ForeignKey(
        StorageLocationModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("مکان"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("بچ"),
    )
    serial_number = models.ForeignKey(
        SerialNumberModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("سریال"),
    )

    book_quantity = models.DecimalField(
        _("موجودی سیستمی"), max_digits=18, decimal_places=4
    )
    uom = models.ForeignKey(
        UnitOfMeasureModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("واحد"),
    )

    # Counts
    first_count_quantity = models.DecimalField(
        _("شمارش اول"), max_digits=18, decimal_places=4, null=True, blank=True
    )
    first_count_by = models.UUIDField(_("شمارش‌کننده اول"), null=True, blank=True)
    first_count_date = models.DateTimeField(_("تاریخ شمارش اول"), null=True, blank=True)

    second_count_quantity = models.DecimalField(
        _("شمارش دوم"), max_digits=18, decimal_places=4, null=True, blank=True
    )
    second_count_by = models.UUIDField(_("شمارش‌کننده دوم"), null=True, blank=True)
    second_count_date = models.DateTimeField(_("تاریخ شمارش دوم"), null=True, blank=True)

    third_count_quantity = models.DecimalField(
        _("شمارش سوم"), max_digits=18, decimal_places=4, null=True, blank=True
    )
    third_count_by = models.UUIDField(_("شمارش‌کننده سوم"), null=True, blank=True)
    third_count_date = models.DateTimeField(_("تاریخ شمارش سوم"), null=True, blank=True)

    # Final
    final_count_quantity = models.DecimalField(
        _("شمارش نهایی"), max_digits=18, decimal_places=4, null=True, blank=True
    )
    variance_quantity = models.DecimalField(
        _("انحراف مقداری"), max_digits=18, decimal_places=4, default=0
    )
    variance_percent = models.DecimalField(
        _("انحراف درصدی"), max_digits=8, decimal_places=2, default=0
    )
    variance_value = models.DecimalField(
        _("انحراف ریالی"), max_digits=18, decimal_places=4, default=0
    )

    line_status = models.CharField(
        _("وضعیت"), max_length=30,
        choices=LineStatus.choices, default=LineStatus.PENDING,
    )
    variance_reason_code = models.CharField(_("کد دلیل انحراف"), max_length=50, blank=True)
    variance_remarks = models.TextField(_("توضیحات انحراف"), blank=True)
    approved_by = models.UUIDField(_("تأیید توسط"), null=True, blank=True)
    approved_date = models.DateField(_("تاریخ تأیید"), null=True, blank=True)

    adjustment_sle = models.ForeignKey(
        StockLedgerEntryModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("ثبت تعدیل"),
    )

    class Meta:
        app_label = "inventory"
        db_table = "inv_physical_inventory_line"
        verbose_name = _("ردیف شمارش")
        verbose_name_plural = _("ردیف‌های شمارش")
        ordering = ["line_number"]

    def __str__(self):
        return f"Line {self.line_number} — {self.item.item_code}"


class CycleCountScheduleModel(TenantAwareModel):
    """برنامه شمارش چرخشی."""

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    schedule_name = models.CharField(_("نام برنامه"), max_length=255)
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("انبار"),
    )
    count_frequency_days = models.PositiveIntegerField(_("فاصله شمارش (روز)"), default=30)

    item_group = models.ForeignKey(
        "ItemGroupModel", on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("گروه کالا"),
    )
    abc_class = models.CharField(_("طبقه ABC"), max_length=5, blank=True)
    high_value_items_only = models.BooleanField(_("فقط اقلام باارزش"), default=False)

    next_count_date = models.DateField(_("تاریخ شمارش بعدی"), null=True, blank=True)
    last_count_date = models.DateField(_("تاریخ آخرین شمارش"), null=True, blank=True)

    is_active = models.BooleanField(_("فعال"), default=True)
    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)
    created_by = models.UUIDField(_("ایجاد توسط"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_cycle_count_schedule"
        verbose_name = _("برنامه شمارش چرخشی")
        verbose_name_plural = _("برنامه‌های شمارش چرخشی")

    def __str__(self):
        return self.schedule_name


# ═══════════════════════════════════════════════════════════════════════════
# 8️⃣  QUALITY MANAGEMENT
# ═══════════════════════════════════════════════════════════════════════════


class InspectionLotModel(TenantAwareModel):
    """لات بازرسی."""

    class InspectionType(models.TextChoices):
        INCOMING = "INCOMING", _("ورودی")
        IN_PROCESS = "IN_PROCESS", _("حین فرآیند")
        OUTGOING = "OUTGOING", _("خروجی")

    class InspectionStatus(models.TextChoices):
        PENDING = "PENDING", _("در انتظار")
        IN_PROGRESS = "IN_PROGRESS", _("در حال بازرسی")
        COMPLETED = "COMPLETED", _("تکمیل‌شده")

    class QualityDecision(models.TextChoices):
        PENDING = "PENDING", _("در انتظار")
        ACCEPTED = "ACCEPTED", _("پذیرش")
        REJECTED = "REJECTED", _("رد")
        CONDITIONAL = "CONDITIONAL", _("مشروط")
        REWORK = "REWORK", _("بازکار")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    inspection_lot_number = models.CharField(
        _("شماره لات بازرسی"), max_length=50, unique=True
    )
    inspection_type = models.CharField(
        _("نوع"), max_length=20,
        choices=InspectionType.choices, default=InspectionType.INCOMING,
    )
    inspection_date = models.DateField(_("تاریخ بازرسی"))

    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("کالا"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="inspections", verbose_name=_("بچ"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("انبار"),
    )

    source_document_type = models.CharField(_("نوع سند"), max_length=50, blank=True)
    source_document_id = models.UUIDField(_("سند مبدأ"), null=True, blank=True)
    source_sle = models.ForeignKey(
        StockLedgerEntryModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("ثبت دفتر"),
    )

    inspection_quantity = models.DecimalField(
        _("مقدار بازرسی"), max_digits=18, decimal_places=4
    )
    sample_size = models.DecimalField(
        _("حجم نمونه"), max_digits=18, decimal_places=4, default=0
    )
    uom = models.ForeignKey(
        UnitOfMeasureModel, on_delete=models.PROTECT,
        related_name="+", verbose_name=_("واحد"),
    )

    inspection_status = models.CharField(
        _("وضعیت"), max_length=20,
        choices=InspectionStatus.choices, default=InspectionStatus.PENDING,
    )
    quality_decision = models.CharField(
        _("تصمیم کیفی"), max_length=20,
        choices=QualityDecision.choices, default=QualityDecision.PENDING,
    )

    inspection_start_date = models.DateField(_("تاریخ شروع"), null=True, blank=True)
    inspection_complete_date = models.DateField(_("تاریخ تکمیل"), null=True, blank=True)

    inspector_id = models.UUIDField(_("بازرس"), null=True, blank=True)
    approved_by = models.UUIDField(_("تأیید توسط"), null=True, blank=True)
    approved_date = models.DateField(_("تاریخ تأیید"), null=True, blank=True)

    remarks = models.TextField(_("توضیحات"), blank=True)
    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )
    created_at = models.DateTimeField(_("تاریخ ایجاد"), auto_now_add=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_inspection_lot"
        verbose_name = _("لات بازرسی")
        verbose_name_plural = _("لات‌های بازرسی")

    def __str__(self):
        return f"{self.inspection_lot_number} ({self.quality_decision})"


class InspectionResultModel(TenantAwareModel):
    """نتایج بازرسی."""

    class ResultStatus(models.TextChoices):
        PASS = "PASS", _("قبول")
        FAIL = "FAIL", _("رد")
        WARNING = "WARNING", _("هشدار")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    inspection_lot = models.ForeignKey(
        InspectionLotModel, on_delete=models.CASCADE,
        related_name="results", verbose_name=_("لات بازرسی"),
    )
    inspection_characteristic = models.CharField(_("ویژگی بازرسی"), max_length=255)
    target_value = models.CharField(_("مقدار هدف"), max_length=255, blank=True)
    actual_value = models.CharField(_("مقدار واقعی"), max_length=255)
    tolerance_lower = models.DecimalField(
        _("حد پایین تلرانس"), max_digits=18, decimal_places=4, null=True, blank=True
    )
    tolerance_upper = models.DecimalField(
        _("حد بالای تلرانس"), max_digits=18, decimal_places=4, null=True, blank=True
    )
    result_status = models.CharField(
        _("نتیجه"), max_length=20,
        choices=ResultStatus.choices, default=ResultStatus.PASS,
    )
    tested_by = models.UUIDField(_("آزمایش‌کننده"), null=True, blank=True)
    tested_date = models.DateTimeField(_("تاریخ آزمایش"), null=True, blank=True)
    remarks = models.TextField(_("توضیحات"), blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_inspection_result"
        verbose_name = _("نتیجه بازرسی")
        verbose_name_plural = _("نتایج بازرسی")

    def __str__(self):
        return f"{self.inspection_characteristic}: {self.result_status}"


class QualityActionModel(TenantAwareModel):
    """اقدام کیفی."""

    class ActionType(models.TextChoices):
        BLOCK = "BLOCK", _("مسدود")
        QUARANTINE = "QUARANTINE", _("قرنطینه")
        REWORK = "REWORK", _("بازکار")
        SCRAP = "SCRAP", _("ضایعات")
        RETURN_TO_VENDOR = "RETURN_TO_VENDOR", _("مرجوعی تأمین‌کننده")
        RELEASE = "RELEASE", _("آزادسازی")

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    inspection_lot = models.ForeignKey(
        InspectionLotModel, on_delete=models.CASCADE,
        related_name="actions", verbose_name=_("لات بازرسی"),
    )
    action_type = models.CharField(
        _("نوع اقدام"), max_length=30,
        choices=ActionType.choices,
    )
    action_date = models.DateField(_("تاریخ اقدام"))
    action_quantity = models.DecimalField(
        _("مقدار"), max_digits=18, decimal_places=4
    )
    target_stock_status = models.ForeignKey(
        StockStatusModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("وضعیت هدف"),
    )
    action_by = models.UUIDField(_("توسط"), null=True, blank=True)
    remarks = models.TextField(_("توضیحات"), blank=True)
    completed_date = models.DateField(_("تاریخ تکمیل"), null=True, blank=True)

    class Meta:
        app_label = "inventory"
        db_table = "inv_quality_action"
        verbose_name = _("اقدام کیفی")
        verbose_name_plural = _("اقدامات کیفی")

    def __str__(self):
        return f"{self.action_type} — {self.action_quantity}"


# ═══════════════════════════════════════════════════════════════════════════
# 9️⃣  REPORTING AGGREGATES
# ═══════════════════════════════════════════════════════════════════════════


class StockMovementSummaryModel(TenantAwareModel):
    """خلاصه حرکات — Aggregate Table."""

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    summary_date = models.DateField(_("تاریخ"), db_index=True)
    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("انبار"),
    )
    transaction_type = models.CharField(_("نوع تراکنش"), max_length=20, db_index=True)

    total_in_quantity = models.DecimalField(
        _("کل ورودی"), max_digits=18, decimal_places=4, default=0
    )
    total_out_quantity = models.DecimalField(
        _("کل خروجی"), max_digits=18, decimal_places=4, default=0
    )
    net_quantity = models.DecimalField(
        _("خالص"), max_digits=18, decimal_places=4, default=0
    )
    total_in_value = models.DecimalField(
        _("ارزش ورودی"), max_digits=18, decimal_places=4, default=0
    )
    total_out_value = models.DecimalField(
        _("ارزش خروجی"), max_digits=18, decimal_places=4, default=0
    )
    transaction_count = models.PositiveIntegerField(_("تعداد تراکنش"), default=0)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )

    class Meta:
        app_label = "inventory"
        db_table = "inv_stock_movement_summary"
        verbose_name = _("خلاصه حرکات")
        verbose_name_plural = _("خلاصه حرکات")
        indexes = [
            models.Index(fields=["tenant", "item", "warehouse", "summary_date"]),
        ]

    def __str__(self):
        return f"{self.summary_date} — {self.item.item_code}"


class StockAgingBucketModel(TenantAwareModel):
    """سطل‌های عمر موجودی."""

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    item = models.ForeignKey(
        ItemModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("کالا"),
    )
    warehouse = models.ForeignKey(
        WarehouseModel, on_delete=models.CASCADE,
        related_name="+", verbose_name=_("انبار"),
    )
    batch = models.ForeignKey(
        BatchModel, on_delete=models.SET_NULL, null=True, blank=True,
        related_name="+", verbose_name=_("بچ"),
    )

    age_in_days = models.PositiveIntegerField(_("سن (روز)"), default=0)
    aging_category = models.CharField(_("دسته سنی"), max_length=20)
    quantity = models.DecimalField(
        _("مقدار"), max_digits=18, decimal_places=4, default=0
    )
    value = models.DecimalField(
        _("ارزش"), max_digits=18, decimal_places=4, default=0
    )
    snapshot_date = models.DateField(_("تاریخ عکس‌برداری"), db_index=True)

    company = models.ForeignKey(
        "core_organization.Company", on_delete=models.SET_NULL,
        null=True, blank=True, related_name="+", verbose_name=_("شرکت"),
    )

    class Meta:
        app_label = "inventory"
        db_table = "inv_stock_aging_bucket"
        verbose_name = _("سطل عمر موجودی")
        verbose_name_plural = _("سطل‌های عمر موجودی")
        indexes = [
            models.Index(fields=["tenant", "snapshot_date"]),
        ]

    def __str__(self):
        return f"{self.item.item_code} — {self.aging_category} ({self.quantity})"