"""Projects and the per-project variable schema (TZ 2.2.2, 2.2.6)."""

from __future__ import annotations

from typing import Any

from django.db import models
from django.utils import timezone

from snapfile.core.fields import UUIDv7Field

DEFAULT_SETTINGS: dict[str, Any] = {
    "max_pages": 200,
    "max_payload_kb": 5120,
    "default_output": "pdf",
    "file_ttl_hours": 72,
    "sync_max_cost": 60,
    "rate_limit_per_min": 600,
    "locale": "ru",
    "timezone": "Europe/Moscow",
    "currency": "RUB",
    "kerning": True,
    "store_payload": True,
    "strict_payload": False,
    "editors_can_publish": True,
    "schema_revision": 0,
    "allowed_webhook_hosts": [],
}


class ProjectQuerySet(models.QuerySet["Project"]):
    def alive(self) -> ProjectQuerySet:
        return self.filter(deleted_at__isnull=True)


class Project(models.Model):
    id = UUIDv7Field(primary_key=True)
    slug = models.CharField(max_length=64, unique=True)
    name = models.CharField(max_length=255)
    client_name = models.CharField(max_length=255, null=True, blank=True)
    client_base_url = models.CharField(max_length=512, null=True, blank=True)
    introspection_url = models.CharField(max_length=512, null=True, blank=True)
    webhook_url = models.CharField(max_length=512, null=True, blank=True)
    # Connector to the client service: language and user lists (docs/dev/aga/service-connector.md).
    service_base_url = models.CharField(max_length=512, null=True, blank=True)
    service_secret_enc = models.TextField(null=True, blank=True)
    service_cache = models.JSONField(default=dict, blank=True)
    webhook_secret_enc = models.TextField(null=True, blank=True)
    allowed_origins = models.JSONField(null=True, blank=True)
    settings = models.JSONField(default=dict)
    storage_quota_mb = models.PositiveIntegerField(null=True, blank=True)
    status = models.CharField(max_length=16, default="active")
    created_at = models.DateTimeField(default=timezone.now)
    updated_at = models.DateTimeField(auto_now=True)
    deleted_at = models.DateTimeField(null=True, blank=True)

    objects = ProjectQuerySet.as_manager()

    class Meta:
        db_table = "projects"

    def __str__(self) -> str:
        return f"{self.slug} ({self.name})"

    def setting(self, key: str) -> Any:
        return (self.settings or {}).get(key, DEFAULT_SETTINGS.get(key))

    @property
    def effective_settings(self) -> dict[str, Any]:
        return {**DEFAULT_SETTINGS, **(self.settings or {})}


class VariableNode(models.Model):
    """One variable or nested field; the tree is assembled via ``parent`` (TZ 2.2.6)."""

    TYPES = ("string", "number", "date", "money", "bool", "image", "array", "object", "derived")

    id = UUIDv7Field(primary_key=True)
    project = models.ForeignKey(Project, on_delete=models.CASCADE, related_name="variables")
    parent = models.ForeignKey("self", null=True, blank=True, on_delete=models.CASCADE, related_name="children")
    key = models.CharField(max_length=64)
    path = models.CharField(max_length=512, db_index=True)
    type = models.CharField(max_length=16)
    item_type = models.CharField(max_length=16, null=True, blank=True)
    format = models.JSONField(null=True, blank=True)
    expression = models.TextField(null=True, blank=True)
    default_value = models.JSONField(null=True, blank=True)
    required = models.BooleanField(default=False)
    nullable = models.BooleanField(default=False)
    constraints = models.JSONField(null=True, blank=True)
    label = models.CharField(max_length=255, null=True, blank=True)
    description = models.TextField(null=True, blank=True)
    example = models.JSONField(null=True, blank=True)
    sort = models.IntegerField(default=0)
    created_by = models.JSONField(null=True, blank=True)
    updated_by = models.JSONField(null=True, blank=True)
    created_at = models.DateTimeField(default=timezone.now)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "variables_schema"
        constraints = [
            models.UniqueConstraint(fields=["project", "parent", "key"], name="variables_unique_key"),
        ]
        ordering = ["sort", "key"]
