# ============================================================
# ADDITIVE: People / "Employees" workspace (new app)
#
# Nothing in Company / Employee / Recruitment / SuperAdmin is modified.
# Employees are the EXISTING Employee.EmployeeDT rows, documents are the
# EXISTING Employee.EmployeeDocument rows, bank/compensation/attendance/
# leave are read from the EXISTING tables. The models below only hold the
# extra data the 10 Employees tabs need.
# ============================================================
from django.db import models
from django.utils import timezone

from Company.models import company_details
from Employee.models import EmployeeDT, EmployeeDocument, Department


class Audit(models.Model):
    """Tracking fields present on EVERY People model (same as Recruitment)."""

    created_by = models.CharField(max_length=150, null=True, blank=True)
    updated_by = models.CharField(max_length=150, null=True, blank=True)
    id_version = models.PositiveIntegerField(default=1)
    is_active = models.BooleanField(default=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        abstract = True

    def save(self, *args, **kwargs):
        if self.pk is not None and not self._state.adding:
            self.id_version = (self.id_version or 1) + 1
            uf = kwargs.get("update_fields")
            if uf is not None:
                kwargs["update_fields"] = list(set(uf) | {"id_version", "updated_at"})
        super().save(*args, **kwargs)


# ------------------------------------------------------------
# Branch / Hub  (directory column "Branch Hub")
# ------------------------------------------------------------
class Branch(Audit):
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_branches")
    name = models.CharField(max_length=150)          # "Pune Tech HQ"
    code = models.CharField(max_length=30, blank=True, null=True)
    city = models.CharField(max_length=100, blank=True, null=True)
    address = models.TextField(blank=True, null=True)

    class Meta:
        ordering = ["name"]
        unique_together = (("company", "name"),)

    def __str__(self):
        return self.name


# ------------------------------------------------------------
# 1/2. Employee master extension (Directory + 360 Profile)
# ------------------------------------------------------------
class EmployeeExtra(Audit):
    LIFECYCLE = [
        ("Probation", "On Probation"),
        ("Extended", "Probation Extended"),
        ("Confirmed", "Permanent Confirmed"),
        ("Notice", "Serving Notice Period (Resigned)"),
        ("Exited", "Exited"),
    ]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_extras")
    employee = models.OneToOneField(EmployeeDT, on_delete=models.CASCADE, related_name="people_profile")
    grade_band = models.CharField(max_length=30, blank=True, null=True)         # L4
    branch = models.ForeignKey(Branch, on_delete=models.SET_NULL, null=True, blank=True, related_name="employees")
    reporting_manager = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True,
                                          related_name="direct_reports")
    uan_number = models.CharField(max_length=30, blank=True, null=True)
    probation_due_date = models.DateField(null=True, blank=True)
    confirmation_date = models.DateField(null=True, blank=True)
    lifecycle_status = models.CharField(max_length=12, choices=LIFECYCLE, default="Probation", db_index=True)
    emergency_contact_name = models.CharField(max_length=150, blank=True, null=True)
    emergency_contact_relation = models.CharField(max_length=60, blank=True, null=True)
    emergency_contact_phone = models.CharField(max_length=30, blank=True, null=True)


# ------------------------------------------------------------
# 3. Onboarding
# ------------------------------------------------------------
class OnboardingRecord(Audit):
    STATUS = [("On Track", "On Track"), ("At Risk", "At Risk"), ("Delayed", "Delayed"), ("Completed", "Completed")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_onboardings")
    employee = models.OneToOneField(EmployeeDT, on_delete=models.CASCADE, related_name="onboarding")
    buddy = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True,
                              related_name="buddy_for")
    status = models.CharField(max_length=12, choices=STATUS, default="On Track", db_index=True)
    started_on = models.DateField(default=timezone.localdate)
    target_days = models.PositiveIntegerField(default=14)
    it_kit_dispatched = models.BooleanField(default=False)
    progress_override = models.PositiveIntegerField(null=True, blank=True)   # used only when no tasks exist
    last_checkin_at = models.DateTimeField(null=True, blank=True)
    completed_on = models.DateField(null=True, blank=True)
    notes = models.TextField(blank=True, null=True)

    class Meta:
        ordering = ["-started_on", "-id"]


class OnboardingTask(Audit):
    record = models.ForeignKey(OnboardingRecord, on_delete=models.CASCADE, related_name="tasks")
    title = models.CharField(max_length=200)
    category = models.CharField(max_length=60, blank=True, null=True)
    due_date = models.DateField(null=True, blank=True)
    is_done = models.BooleanField(default=False)
    done_at = models.DateTimeField(null=True, blank=True)
    done_by = models.CharField(max_length=150, blank=True, null=True)
    sort_order = models.PositiveIntegerField(default=0)

    class Meta:
        ordering = ["sort_order", "id"]


# ------------------------------------------------------------
# 5. Assets
# ------------------------------------------------------------
class AssetMaster(Audit):
    CATEGORY = [("Hardware", "Hardware"), ("Software", "Software"), ("Security", "Security"),
                ("Access", "Access Card / Keys"), ("Furniture", "Furniture"), ("Other", "Other"),
                # added with migration 0002 (Asset Master UI categories)
                ("Laptop", "Laptop"), ("Monitor", "Monitor"), ("Mobile", "Mobile"), ("Peripheral", "Peripheral")]
    STATUS = [("Available", "Available"), ("Allocated", "Allocated"), ("Under Repair", "Under Repair"),
              ("Retired", "Retired"), ("Lost", "Lost"), ("Reserved", "Reserved")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_assets")
    asset_tag = models.CharField(max_length=40)                      # ZH-IT-2026-081
    device_name = models.CharField(max_length=200)
    category = models.CharField(max_length=12, choices=CATEGORY, default="Hardware", db_index=True)
    serial_number = models.CharField(max_length=100, blank=True, null=True)
    purchase_date = models.DateField(null=True, blank=True)
    purchase_cost = models.DecimalField(max_digits=12, decimal_places=2, null=True, blank=True)
    status = models.CharField(max_length=14, choices=STATUS, default="Available", db_index=True)
    notes = models.TextField(blank=True, null=True)
    # ---- migration 0002_asset_tracking_extension ----
    vendor = models.CharField(max_length=150, blank=True, null=True)
    warranty_until = models.DateField(null=True, blank=True)
    reserved_for = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True,
                                     related_name="reserved_assets")
    reserved_on = models.DateField(null=True, blank=True)

    class Meta:
        ordering = ["asset_tag"]
        unique_together = (("company", "asset_tag"),)


class AssetAllocation(Audit):
    STATUS = [("Allocated", "Allocated"), ("Returned", "Returned")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_allocations")
    asset = models.ForeignKey(AssetMaster, on_delete=models.CASCADE, related_name="allocations")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="asset_allocations")
    allocated_on = models.DateField(default=timezone.localdate)
    expected_return = models.DateField(null=True, blank=True)
    returned_on = models.DateField(null=True, blank=True)
    condition_out = models.CharField(max_length=100, blank=True, null=True)
    condition_in = models.CharField(max_length=100, blank=True, null=True)
    status = models.CharField(max_length=10, choices=STATUS, default="Allocated", db_index=True)
    notes = models.TextField(blank=True, null=True)
    # ---- migration 0002_asset_tracking_extension (offboarding return tracking) ----
    return_pending = models.BooleanField(default=False, db_index=True)
    return_requested_on = models.DateField(null=True, blank=True)
    return_due_date = models.DateField(null=True, blank=True)
    return_reason = models.CharField(max_length=250, blank=True, null=True)
    # ---- migration 0009 (employee self-service: acknowledge receipt) ----
    acknowledged_on = models.DateTimeField(null=True, blank=True)
    acknowledged_note = models.CharField(max_length=250, blank=True, null=True)
    
    class Meta:
        ordering = ["-allocated_on", "-id"]


class AssetAudit(Audit):
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_asset_audits")
    asset = models.ForeignKey(AssetMaster, on_delete=models.CASCADE, related_name="audits")
    allocation = models.ForeignKey(AssetAllocation, on_delete=models.SET_NULL, null=True, blank=True,
                                   related_name="audits")
    audited_on = models.DateField(default=timezone.localdate)
    audited_by = models.CharField(max_length=150, blank=True, null=True)
    condition = models.CharField(max_length=100, blank=True, null=True)
    is_ok = models.BooleanField(default=True)
    notes = models.TextField(blank=True, null=True)

    class Meta:
        ordering = ["-audited_on", "-id"]


class AssetMaintenance(Audit):
    """Hardware Maintenance & Lifecycle Log (Asset History tab): repairs, battery replacements, warranty."""
    EVENT = [("Repair", "Repair"), ("Battery Replacement", "Battery Replacement"),
             ("Warranty Claim", "Warranty Claim"), ("Warranty Extension", "Warranty Extension"),
             ("Service", "Service"), ("Upgrade", "Upgrade"), ("Inspection", "Inspection"), ("Other", "Other")]
    STATUS = [("Scheduled", "Scheduled"), ("In Progress", "In Progress"), ("Completed", "Completed")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_asset_maintenance")
    asset = models.ForeignKey(AssetMaster, on_delete=models.CASCADE, related_name="maintenance_logs")
    event_type = models.CharField(max_length=20, choices=EVENT, default="Service", db_index=True)
    event_date = models.DateField(default=timezone.localdate, db_index=True)
    vendor = models.CharField(max_length=150, blank=True, null=True)
    cost = models.DecimalField(max_digits=12, decimal_places=2, null=True, blank=True)
    description = models.TextField(blank=True, null=True)
    warranty_until = models.DateField(null=True, blank=True)
    next_service_due = models.DateField(null=True, blank=True)
    status = models.CharField(max_length=12, choices=STATUS, default="Completed", db_index=True)

    class Meta:
        ordering = ["-event_date", "-id"]


# ------------------------------------------------------------
# 6. Employee history (career timeline)
# ------------------------------------------------------------
class HistoryEvent(Audit):
    TYPES = [("JOINED", "Joined"), ("CONFIRMATION", "Confirmation"), ("PROMOTION", "Promotion"),
             ("TRANSFER", "Transfer"), ("MANAGER_CHANGE", "Manager Change"),
             ("DESIGNATION_CHANGE", "Designation Change"), ("PROBATION_EXTENDED", "Probation Extended"),
             ("EXIT", "Exit"), ("NOTE", "Note")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_history")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="people_history")
    event_type = models.CharField(max_length=20, choices=TYPES, db_index=True)
    title = models.CharField(max_length=250)
    description = models.TextField(blank=True, null=True)
    event_date = models.DateField(default=timezone.localdate, db_index=True)
    meta = models.JSONField(default=dict, blank=True)

    class Meta:
        ordering = ["-event_date", "-id"]


# ------------------------------------------------------------
# 7. Transfers
# ------------------------------------------------------------
class TransferRequest(Audit):
    HOD = [("Pending", "Pending HOD"), ("Approved", "Approved"), ("Rejected", "Rejected")]
    STATUS = [("Requested", "Requested"), ("Approved", "Approved"), ("Executed", "Executed"),
              ("Rejected", "Rejected"), ("Cancelled", "Cancelled")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_transfers")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="transfers")
    from_department_name = models.CharField(max_length=150, blank=True, null=True)
    from_branch_name = models.CharField(max_length=150, blank=True, null=True)
    from_manager = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    to_department = models.ForeignKey(Department, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    to_branch = models.ForeignKey(Branch, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    to_manager = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    effective_date = models.DateField()
    reason = models.TextField(blank=True, null=True)
    hod_status = models.CharField(max_length=10, choices=HOD, default="Pending", db_index=True)
    hod_approver = models.ForeignKey(EmployeeDT, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")
    hod_remarks = models.TextField(blank=True, null=True)
    status = models.CharField(max_length=10, choices=STATUS, default="Requested", db_index=True)
    executed_at = models.DateTimeField(null=True, blank=True)
    reminded_at = models.DateTimeField(null=True, blank=True)

    class Meta:
        ordering = ["effective_date", "-id"]


# ------------------------------------------------------------
# 10. Letters (defined before Promotion / Confirmation so they can link)
# ------------------------------------------------------------
class EmployeeLetter(Audit):
    TYPES = [("APPOINTMENT", "Appointment Letter"), ("CONFIRMATION", "Confirmation Letter"),
             ("PROMOTION", "Promotion Letter"), ("RELIEVING_EXPERIENCE", "Relieving & Experience")]
    STATUS = [("Draft", "Draft"), ("Issued", "Issued"), ("Revoked", "Revoked")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_letters")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="people_letters")
    letter_type = models.CharField(max_length=24, choices=TYPES, db_index=True)
    letter_no = models.CharField(max_length=40)                       # APT-2026-0001
    subject = models.CharField(max_length=250, blank=True, null=True)
    body = models.TextField()
    variables = models.JSONField(default=dict, blank=True)
    status = models.CharField(max_length=8, choices=STATUS, default="Issued", db_index=True)
    issued_on = models.DateField(default=timezone.localdate)
    issued_by = models.CharField(max_length=150, blank=True, null=True)
    pdf_file = models.FileField(upload_to="employee_letters/", null=True, blank=True)

    class Meta:
        ordering = ["-issued_on", "-id"]
        unique_together = (("company", "letter_no"),)


# ------------------------------------------------------------
# 8. Promotions
# ------------------------------------------------------------
class PromotionRequest(Audit):
    STATUS = [("Nominated", "Nominated"), ("Under Review", "Under Review"),
              ("Approved by Committee", "Approved by Committee"), ("Rejected", "Rejected"),
              ("Executed", "Executed")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_promotions")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="promotions")
    current_designation = models.CharField(max_length=200, blank=True, null=True)
    proposed_designation = models.CharField(max_length=200)
    current_grade = models.CharField(max_length=30, blank=True, null=True)
    proposed_grade = models.CharField(max_length=30, blank=True, null=True)
    hike_percent = models.DecimalField(max_digits=5, decimal_places=2, default=0)
    manager_rating = models.DecimalField(max_digits=3, decimal_places=1, null=True, blank=True)
    effective_date = models.DateField(null=True, blank=True)
    remarks = models.TextField(blank=True, null=True)
    status = models.CharField(max_length=24, choices=STATUS, default="Nominated", db_index=True)
    nominated_by = models.CharField(max_length=150, blank=True, null=True)
    committee_remarks = models.TextField(blank=True, null=True)
    decided_by = models.CharField(max_length=150, blank=True, null=True)
    decided_at = models.DateTimeField(null=True, blank=True)
    executed_at = models.DateTimeField(null=True, blank=True)
    letter = models.ForeignKey(EmployeeLetter, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")

    class Meta:
        ordering = ["-id"]


# ------------------------------------------------------------
# 9. Confirmation (probation review)
# ------------------------------------------------------------
class ConfirmationReview(Audit):
    RECO = [("Confirm Permanent", "Confirm Permanent"), ("Extend Probation", "Extend Probation"),
            ("Terminate", "Terminate")]
    STATUS = [("Pending", "Pending"), ("Confirmed", "Confirmed"), ("Extended", "Extended"),
              ("Terminated", "Terminated")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_confirmations")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="confirmations")
    probation_due_date = models.DateField(null=True, blank=True)
    manager_rating = models.DecimalField(max_digits=3, decimal_places=1, null=True, blank=True)
    manager_remarks = models.TextField(blank=True, null=True)
    recommendation = models.CharField(max_length=20, choices=RECO, blank=True, null=True)
    status = models.CharField(max_length=10, choices=STATUS, default="Pending", db_index=True)
    extended_until = models.DateField(null=True, blank=True)
    decided_by = models.CharField(max_length=150, blank=True, null=True)
    decided_on = models.DateField(null=True, blank=True)
    letter = models.ForeignKey(EmployeeLetter, on_delete=models.SET_NULL, null=True, blank=True, related_name="+")

    class Meta:
        ordering = ["probation_due_date", "-id"]


# ------------------------------------------------------------
# 2 (tab "Exit & Clearance")
# ------------------------------------------------------------
class ExitClearance(Audit):
    STATUS = [("Initiated", "Initiated"), ("In Progress", "In Progress"), ("Cleared", "Cleared"),
              ("Completed", "Completed"), ("Withdrawn", "Withdrawn")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_exits")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="people_exits")
    resignation_date = models.DateField(null=True, blank=True)
    last_working_day = models.DateField(null=True, blank=True)
    reason = models.TextField(blank=True, null=True)
    items = models.JSONField(default=list, blank=True)   # [{"department","title","cleared","cleared_by","cleared_at"}]
    status = models.CharField(max_length=12, choices=STATUS, default="Initiated", db_index=True)

    class Meta:
        ordering = ["-id"]


# ------------------------------------------------------------
# 4. Document verification status (on top of existing EmployeeDocument)
# ------------------------------------------------------------
class DocumentCheck(Audit):
    STATUS = [("Pending", "Pending"), ("Verified", "Verified"), ("Rejected", "Rejected")]
    document = models.OneToOneField(EmployeeDocument, on_delete=models.CASCADE, related_name="people_check")
    status = models.CharField(max_length=10, choices=STATUS, default="Pending", db_index=True)
    remarks = models.TextField(blank=True, null=True)
    reviewed_by = models.CharField(max_length=150, blank=True, null=True)
    reviewed_at = models.DateTimeField(null=True, blank=True) 
    

# ============================================================
# ADDITIVE: Enterprise Document Vault & Letters
# (tables already created by migration 0002_vault_documents_policies_templates)
# ============================================================
class CompanyPolicy(Audit):
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_policies")
    title = models.CharField(max_length=200)
    version = models.CharField(max_length=20, default="1.0")
    effective_date = models.DateField(null=True, blank=True)
    is_mandatory = models.BooleanField(default=False)
    compliance_note = models.CharField(max_length=120, blank=True, null=True)   # "Mandatory Annual Compliance"
    description = models.TextField(blank=True, null=True)
    file = models.FileField(upload_to="people/policies/", null=True, blank=True)

    class Meta:
        ordering = ["title", "-id"]


class HRDocument(Audit):
    CATEGORY = [("SOP", "SOP"), ("MANUAL", "Manual"), ("FORM", "Form"), ("OTHER", "Other")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_hr_documents")
    title = models.CharField(max_length=200)
    category = models.CharField(max_length=10, choices=CATEGORY, default="SOP", db_index=True)
    description = models.TextField(blank=True, null=True)
    version = models.CharField(max_length=20, default="1.0")
    file = models.FileField(upload_to="people/hr_documents/", null=True, blank=True)
    uploaded_by = models.CharField(max_length=150, blank=True, null=True)

    class Meta:
        ordering = ["title", "-id"]


class LetterTemplate(Audit):
    """Company override of a standard letterhead template (code = EmployeeLetter.TYPES key).
    No row = the built-in default text from People/letters.py is used."""
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="people_letter_templates")
    code = models.CharField(max_length=24, db_index=True)
    subject = models.CharField(max_length=250, blank=True, null=True)
    body = models.TextField()

    class Meta:
        unique_together = (("company", "code"),)
        

# ---- ADDITIVE: Employee Engagement, Surveys & Culture models ----
from .engagement_models import *  # noqa: E402,F401,F403
 
# ============================================================
# ADDITIVE: Exit Management models (see exit_models.py)
# ============================================================
from .exit_models import *  # noqa: E402,F401,F403

# ============================================================
# ADDITIVE: Statutory Compliance & Legal Governance models (see compliance_models.py)
# ============================================================
from .compliance_models import *  # noqa: E402,F401,F403

# ============================================================
# ADDITIVE: HR MIS & Workforce Analytics models (see reports_models.py)
# ============================================================
from .reports_models import *  # noqa: E402,F401,F403
 
 
# ============================================================
# ADDITIVE: Time, Biometrics & Perimeter Security models (see att_models.py)
# ============================================================
from .att_models import *  # noqa: E402,F401,F403


# ============================================================
# ADDITIVE: Department ownership + HR role map (see org_models.py)
# ============================================================
from .org_models import *  # noqa: E402,F401,F403


# ============================================================
# ADDITIVE: 30-60-90 Day Review models (see review_models.py)
# ============================================================
from .review_models import *  # noqa: E402,F401,F403


# ============================================================
# ADDITIVE: Organization Hierarchy / Org Chart settings (see org_chart_models.py)
# ============================================================
from .org_chart_models import *  # noqa: E402,F401,F403

# ============================================================
# ADDITIVE: Per-company SMTP configuration + email log (see mail_models.py)
# ============================================================
from .mail_models import *  # noqa: E402,F401,F403


# ============================================================
# ADDITIVE: essl_direct_models (essl_direct_models.py: naya model BiometricDeviceLink)
# ============================================================
from .essl_direct_models import *  # noqa: E402,F401,F403


# ============================================================
# ADDITIVE: Letterhead settings for the Document & Letter Issuance Center (see letter_models.py)
# ============================================================
from .letter_models import *  # noqa: E402,F401,F403


