# ============================================================
# ADDITIVE: Admin Control Center, Governance & Workflows
#
# Reused as-is (NOT duplicated):
#   Users            -> Employee.EmployeeDT + Employee.EmployeeAccount (role, is_login_enabled=lock, last_login)
#   Roles & RBAC     -> Employee.EmployeeRole (the can_* checkboxes ARE the matrix)
#   Sessions         -> Company.AuthLog (login events) ; revocation = SessionRevocation below
#   Departments      -> Employee.Department   |  Locations -> People.Branch
#   Leave approvals  -> Employee.ApprovalWorkflowStep (shown read-only in the workflow list)
# New tables only for things that did not exist yet. Every table is company-scoped (B2B).
# ============================================================
from django.db import models

from Company.models import company_details
from Employee.models import Department, EmployeeDT, EmployeeRole
from People.models import Audit, Branch


class LegalEntity(Audit):
    STATUS = [("Active", "Active"), ("Inactive", "Inactive")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_legal_entities")
    name = models.CharField(max_length=200)                       # Zenith Technologies Pvt Ltd
    code = models.CharField(max_length=30)                        # ZEN-IN
    tax_id = models.CharField(max_length=60, blank=True, null=True)   # CIN / EIN / licence no.
    country = models.CharField(max_length=80, blank=True, null=True)
    currency = models.CharField(max_length=3, blank=True, null=True)  # INR
    timezone = models.CharField(max_length=60, blank=True, null=True)  # Asia/Kolkata
    address = models.TextField(blank=True, null=True)
    is_primary = models.BooleanField(default=False)
    status = models.CharField(max_length=10, choices=STATUS, default="Active", db_index=True)

    class Meta:
        ordering = ["-is_primary", "name"]
        unique_together = (("company", "code"),)


class OrgUnit(Audit):
    TYPES = [("Department", "Department"), ("Business Unit", "Business Unit"), ("Division", "Division"),
             ("Location", "Location"), ("Region", "Region")]
    STATUS = [("Active", "Active"), ("Inactive", "Inactive")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_org_units")
    unit_type = models.CharField(max_length=15, choices=TYPES, db_index=True)
    name = models.CharField(max_length=150)
    code = models.CharField(max_length=30, blank=True, null=True)
    parent = models.ForeignKey("self", on_delete=models.SET_NULL, null=True, blank=True, related_name="children")
    parent_name = models.CharField(max_length=150, blank=True, null=True)   # free text when no parent unit exists ("Corporate")
    head = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    status = models.CharField(max_length=10, choices=STATUS, default="Active", db_index=True)
    department = models.ForeignKey(Department, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")  # link, not a copy
    branch = models.ForeignKey(Branch, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")          # link, not a copy

    class Meta:
        ordering = ["unit_type", "name"]
        unique_together = (("company", "unit_type", "name"),)


class MasterDataValue(Audit):
    STATUS = [("Active", "Active"), ("Inactive", "Inactive")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_master_values")
    category = models.CharField(max_length=80, db_index=True)     # Employment Type, Leave Type, Asset Type ...
    value = models.CharField(max_length=150)
    code = models.CharField(max_length=30)
    sort_order = models.PositiveIntegerField(default=1)
    status = models.CharField(max_length=10, choices=STATUS, default="Active", db_index=True)

    class Meta:
        ordering = ["category", "sort_order", "value"]
        unique_together = (("company", "category", "code"),)


class WorkflowDefinition(Audit):
    MODULES = ["Leave", "Recruitment", "Payroll", "Exit", "Timesheet", "Training", "Assets", "Expense", "Performance", "Documents", "Other"]
    STATUS = [("Active", "Active"), ("Draft", "Draft"), ("Inactive", "Inactive")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_workflows")
    name = models.CharField(max_length=150)
    module = models.CharField(max_length=20, db_index=True)
    trigger_event = models.CharField(max_length=150)              # On Submit / On Amount > 10000
    sla_hours = models.PositiveIntegerField(default=24)
    description = models.TextField(blank=True, null=True)
    status = models.CharField(max_length=10, choices=STATUS, default="Active", db_index=True)

    class Meta:
        ordering = ["module", "name"]
        unique_together = (("company", "name"),)


class WorkflowStep(Audit):
    APPROVERS = ["Reporting Manager", "HOD", "HR Admin", "Role", "Employee", "Finance Controller", "Head of HR", "Hiring Manager", "IT", "Admin", "Finance", "HR"]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_workflow_steps")
    workflow = models.ForeignKey(WorkflowDefinition, on_delete=models.CASCADE, related_name="steps")
    step_order = models.PositiveIntegerField()
    approver_type = models.CharField(max_length=30)
    approver_role = models.ForeignKey(EmployeeRole, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    approver_employee = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    sla_hours = models.PositiveIntegerField(null=True, blank=True)

    class Meta:
        ordering = ["workflow_id", "step_order"]


class ScheduledJob(Audit):
    TYPES = ["Backup", "Reminder", "Payroll", "Sync", "Report", "Other"]
    SCHEDULES = ["Daily", "Weekdays", "Weekly", "Monthly"]
    STATUS = [("Active", "Active"), ("Paused", "Paused")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_jobs")
    name = models.CharField(max_length=150)
    job_type = models.CharField(max_length=10, db_index=True)
    handler = models.CharField(max_length=20, default="log")      # backup | log  (see jobs registry)
    schedule_type = models.CharField(max_length=10, default="Daily")
    time_of_day = models.TimeField(default="02:00")
    day_of_week = models.PositiveSmallIntegerField(null=True, blank=True)   # 0=Mon (Weekly)
    day_of_month = models.PositiveSmallIntegerField(null=True, blank=True)  # 1-28 (Monthly)
    status = models.CharField(max_length=10, choices=STATUS, default="Active", db_index=True)
    last_run_at = models.DateTimeField(null=True, blank=True)
    last_run_status = models.CharField(max_length=15, blank=True, null=True)
    last_run_message = models.CharField(max_length=300, blank=True, null=True)
    next_run_at = models.DateTimeField(null=True, blank=True)

    class Meta:
        ordering = ["name"]
        unique_together = (("company", "name"),)


class IntegrationConnector(Audit):
    TYPES = ["Email", "Biometric", "REST API", "Accounting", "SMS", "Other"]
    STATUS = [("Not Tested", "Not Tested"), ("Connected", "Connected"), ("Error", "Error"), ("Disabled", "Disabled")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_integrations")
    name = models.CharField(max_length=150)
    connector_type = models.CharField(max_length=12, db_index=True)
    endpoint = models.CharField(max_length=300, blank=True, null=True)
    version = models.CharField(max_length=30, blank=True, null=True)
    status = models.CharField(max_length=12, choices=STATUS, default="Not Tested", db_index=True)
    secret_enc = models.TextField(blank=True, null=True)           # encrypted, WRITE-ONLY (never returned)
    secret_hint = models.CharField(max_length=12, blank=True, null=True)   # "****1234"
    last_ping_at = models.DateTimeField(null=True, blank=True)
    last_ping_ms = models.PositiveIntegerField(null=True, blank=True)
    last_ping_message = models.CharField(max_length=300, blank=True, null=True)

    class Meta:
        ordering = ["name"]
        unique_together = (("company", "name"),)


class SecurityPolicy(Audit):
    company = models.OneToOneField(company_details, on_delete=models.CASCADE, related_name="admin_security_policy")
    mfa_required_admins = models.BooleanField(default=True)
    lockout_enabled = models.BooleanField(default=True)
    lockout_attempts = models.PositiveSmallIntegerField(default=5)
    lockout_minutes = models.PositiveSmallIntegerField(default=30)
    password_rotation_enabled = models.BooleanField(default=True)
    password_rotation_days = models.PositiveSmallIntegerField(default=90)
    password_history = models.PositiveSmallIntegerField(default=6)
    idle_timeout_enabled = models.BooleanField(default=True)
    idle_timeout_minutes = models.PositiveSmallIntegerField(default=30)
    ip_allowlist_enabled = models.BooleanField(default=False)
    ip_allowlist = models.JSONField(default=list, blank=True)


class BackupPolicy(Audit):
    STATUS = [("Active", "Active"), ("Paused", "Paused")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_backup_policies")
    target = models.CharField(max_length=150)                      # Full Database Snapshot
    frequency = models.CharField(max_length=80)                    # Daily at 02:00 AM
    retention_days = models.PositiveIntegerField(default=30)
    storage_location = models.CharField(max_length=200, blank=True, null=True)
    status = models.CharField(max_length=10, choices=STATUS, default="Active")

    class Meta:
        ordering = ["target"]
        unique_together = (("company", "target"),)


class BackupSnapshot(Audit):
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_snapshots")
    policy = models.ForeignKey(BackupPolicy, on_delete=models.SET_NULL, null=True, blank=True, related_name="snapshots")
    file_path = models.CharField(max_length=300, blank=True, null=True)
    size_bytes = models.BigIntegerField(default=0)
    checksum = models.CharField(max_length=64, blank=True, null=True)
    record_counts = models.JSONField(default=dict, blank=True)
    status = models.CharField(max_length=12, default="Completed")
    triggered_by = models.CharField(max_length=150, blank=True, null=True)

    class Meta:
        ordering = ["-id"]


class AdminAuditEvent(models.Model):
    """Append-only trail. No update / delete API exists for it by design (immutable)."""

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )
    is_active = models.BooleanField(
        default=True,
    )
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_audit_events")
    actor = models.CharField(max_length=150, blank=True, null=True)
    actor_name = models.CharField(max_length=150, blank=True, null=True)
    action = models.CharField(max_length=30, db_index=True)
    module = models.CharField(max_length=60, db_index=True)
    record_ref = models.CharField(max_length=150, blank=True, null=True)
    old_value = models.TextField(blank=True, null=True)
    new_value = models.TextField(blank=True, null=True)
    ip_address = models.GenericIPAddressField(blank=True, null=True)
    created_at = models.DateTimeField(auto_now_add=True, db_index=True)

    class Meta:
        ordering = ["-id"]


class SessionRevocation(models.Model):
    """Tokens of this actor issued BEFORE `revoked_before` are rejected (see sessions.is_token_revoked)."""

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )
    is_active = models.BooleanField(
        default=True,
    )
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="admin_session_revocations")
    actor_type = models.CharField(max_length=20)
    actor_id = models.CharField(max_length=100)
    revoked_before = models.DateTimeField()
    revoked_by = models.CharField(max_length=150, blank=True, null=True)
    reason = models.CharField(max_length=200, blank=True, null=True)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        unique_together = (("company", "actor_type", "actor_id"),)
