# ============================================================
# ADDITIVE: Recruitment & Talent Acquisition (new app)
#
# Nothing in Company / Employee / SuperAdmin is modified.
# Candidates are the EXISTING Employee.EmployeeDT rows
# (candidate_id, applied_position, candidate_status ...), the
# existing EmployeeDocument / CandidateBGV / CandidateCompensation
# tables are reused. The models below only hold the extra
# recruitment data those tables do not have.
# ============================================================

from decimal import Decimal

from django.db import models
from django.utils import timezone

from Company.models import company_details
from Employee.models import EmployeeDT, EmployeeDocument, Department


# 13 pipeline stages. The value is stored in the EXISTING
# EmployeeDT.candidate_status column, so old code keeps working.
STAGES = [
    ("APPLIED", "Applied"),
    ("SCREENING", "Screening"),
    ("SHORTLISTED", "Shortlisted"),
    ("INTERVIEW", "Interview"),
    ("FEEDBACK_PENDING", "Feedback Pending"),
    ("SELECTED", "Selected"),
    ("OFFER_SENT", "Offer Sent"),
    ("OFFER_ACCEPTED", "Offer Accepted"),
    ("DOCS_PENDING", "Docs Pending"),
    ("BGV", "BGV"),
    ("READY_TO_JOIN", "Ready To Join"),
    ("JOINED", "Joined"),
    ("REJECTED", "Rejected"),
]
STAGE_CODES = [s[0] for s in STAGES]


class TrackingFields(models.Model):
    """The 4 tracking fields - present on EVERY Recruitment model."""

    # ---- 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,
    )

    class Meta:
        abstract = True

    def save(self, *args, **kwargs):
        # bump the version counter on every UPDATE (not on first insert)
        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"})
        super().save(*args, **kwargs)


class AuditMixin(TrackingFields):
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        abstract = True


# ------------------------------------------------------------
# 1. JOB REQUISITION
# ------------------------------------------------------------
class JobRequisition(AuditMixin):
    PRIORITY = [("Low", "Low"), ("Medium", "Medium"), ("High", "High"), ("Urgent", "Urgent")]
    APPROVAL = [
        ("Draft", "Draft"), ("Submitted", "Submitted"), ("Approved", "Approved"),
        ("Rejected", "Rejected"), ("Closed", "Closed"),
    ]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="job_requisitions")
    requisition_id = models.CharField(max_length=30, db_index=True)  # REQ-2026-001
    position_title = models.CharField(max_length=200)
    department = models.ForeignKey(Department, null=True, blank=True, on_delete=models.SET_NULL, related_name="requisitions")
    department_name = models.CharField(max_length=150, blank=True, null=True)
    work_mode = models.CharField(max_length=50, blank=True, null=True)       # Hybrid / On-site / Remote
    location = models.CharField(max_length=150, blank=True, null=True)
    vacancies = models.PositiveIntegerField(default=1)
    budget_min_lpa = models.DecimalField(max_digits=8, decimal_places=2, null=True, blank=True)
    budget_max_lpa = models.DecimalField(max_digits=8, decimal_places=2, null=True, blank=True)
    # employee connection: hiring manager is a real employee of the company
    hiring_manager = models.ForeignKey(EmployeeDT, null=True, blank=True, on_delete=models.SET_NULL, related_name="managed_requisitions")
    priority = models.CharField(max_length=10, choices=PRIORITY, default="Medium")
    approval_status = models.CharField(max_length=10, choices=APPROVAL, default="Draft", db_index=True)
    approved_by = models.CharField(max_length=150, blank=True, null=True)
    approved_at = models.DateTimeField(null=True, blank=True)
    rejection_reason = models.TextField(blank=True, null=True)
    closed_at = models.DateTimeField(null=True, blank=True)

    class Meta:
        ordering = ["-created_at"]
        unique_together = (("company", "requisition_id"),)

    def __str__(self):
        return f"{self.requisition_id} - {self.position_title}"


# ------------------------------------------------------------
# 2. JOB DESCRIPTION (linked to a requisition)
# ------------------------------------------------------------
class JobDescription(AuditMixin):
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="job_descriptions")
    jd_code = models.CharField(max_length=30, db_index=True)  # JD-001
    requisition = models.OneToOneField(JobRequisition, on_delete=models.CASCADE, related_name="job_description")
    experience_min_years = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    experience_max_years = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    required_skills = models.JSONField(default=list, blank=True)
    responsibilities = models.TextField(blank=True, null=True)
    qualifications = models.TextField(blank=True, null=True)
    is_published = models.BooleanField(default=False)
    published_at = models.DateTimeField(null=True, blank=True)

    class Meta:
        ordering = ["jd_code"]
        unique_together = (("company", "jd_code"),)

    def __str__(self):
        return self.jd_code


# ------------------------------------------------------------
# 3/5. CANDIDATE RECRUITMENT PROFILE (extends EmployeeDT candidate)
# ------------------------------------------------------------
class CandidateProfile(AuditMixin):
    PRIORITY = JobRequisition.PRIORITY

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="candidate_profiles")
    candidate = models.OneToOneField(EmployeeDT, on_delete=models.CASCADE, related_name="recruitment_profile")
    requisition = models.ForeignKey(JobRequisition, null=True, blank=True, on_delete=models.SET_NULL, related_name="candidates")
    current_company = models.CharField(max_length=200, blank=True, null=True)
    total_experience_years = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    notice_period_days = models.PositiveIntegerField(null=True, blank=True)
    priority = models.CharField(max_length=10, choices=PRIORITY, default="Medium")
    # employee connection: recruiter is an employee (name is also kept on EmployeeDT.recruiter_name)
    recruiter = models.ForeignKey(EmployeeDT, null=True, blank=True, on_delete=models.SET_NULL, related_name="recruited_candidates")
    rejection_reason = models.TextField(blank=True, null=True)
    stage_changed_at = models.DateTimeField(default=timezone.now)

    def __str__(self):
        return f"Profile {self.candidate_id}"


class StageHistory(TrackingFields):
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="stage_history")
    candidate = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="stage_history")
    from_stage = models.CharField(max_length=30, blank=True, null=True)
    to_stage = models.CharField(max_length=30)
    note = models.TextField(blank=True, null=True)
    changed_by = models.CharField(max_length=150, blank=True, null=True)
    changed_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        ordering = ["-changed_at"]


# ------------------------------------------------------------
# 6/7. INTERVIEW ROUND (calendar + rounds share this table)
# ------------------------------------------------------------
class InterviewRound(AuditMixin):
    STATUS = [("Scheduled", "Scheduled"), ("Completed", "Completed"), ("Cancelled", "Cancelled"), ("No Show", "No Show")]
    FEEDBACK = [("Pending", "Pending"), ("Submitted", "Submitted")]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="interview_rounds")
    interview_id = models.CharField(max_length=30, db_index=True)  # INT-801
    candidate = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="interview_rounds")
    round_name = models.CharField(max_length=100)           # Technical Round 1, HR Screening ...
    round_no = models.PositiveIntegerField(default=1)
    # employee connection: interviewer is a real employee
    interviewer = models.ForeignKey(EmployeeDT, null=True, blank=True, on_delete=models.SET_NULL, related_name="interviews_taken")
    scheduled_at = models.DateTimeField()
    duration_minutes = models.PositiveIntegerField(default=60)
    mode = models.CharField(max_length=100, blank=True, null=True)    # Google Meet / In Person ...
    meeting_link = models.CharField(max_length=500, blank=True, null=True)
    status = models.CharField(max_length=12, choices=STATUS, default="Scheduled", db_index=True)
    feedback_status = models.CharField(max_length=10, choices=FEEDBACK, default="Pending")
    notes = models.TextField(blank=True, null=True)

    class Meta:
        ordering = ["scheduled_at"]
        unique_together = (("company", "interview_id"),)


# ------------------------------------------------------------
# 8. INTERVIEW FEEDBACK / SCORECARD
# ------------------------------------------------------------
class InterviewFeedback(AuditMixin):
    RECO = [("Strong Hire", "Strong Hire"), ("Hire", "Hire"), ("Hold", "Hold"),
            ("No Hire", "No Hire"), ("Strong No Hire", "Strong No Hire")]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="interview_feedbacks")
    interview = models.OneToOneField(InterviewRound, on_delete=models.CASCADE, related_name="feedback")
    technical_skills = models.PositiveSmallIntegerField(default=0)
    problem_solving = models.PositiveSmallIntegerField(default=0)
    communication = models.PositiveSmallIntegerField(default=0)
    culture_fit = models.PositiveSmallIntegerField(default=0)
    domain_knowledge = models.PositiveSmallIntegerField(default=0)
    leadership = models.PositiveSmallIntegerField(default=0)
    recommendation = models.CharField(max_length=20, choices=RECO)
    strengths = models.TextField(blank=True, null=True)
    concerns = models.TextField(blank=True, null=True)
    comments = models.TextField(blank=True, null=True)
    why_hire = models.TextField(blank=True, null=True)
    why_not_hire = models.TextField(blank=True, null=True)
    submitted_by = models.ForeignKey(EmployeeDT, null=True, blank=True, on_delete=models.SET_NULL, related_name="feedback_given")
    submitted_by_label = models.CharField(max_length=150, blank=True, null=True)

    SCORE_FIELDS = ["technical_skills", "problem_solving", "communication",
                    "culture_fit", "domain_knowledge", "leadership"]

    @property
    def average_score(self):
        vals = [getattr(self, f) for f in self.SCORE_FIELDS if getattr(self, f)]
        return round(sum(vals) / len(vals), 2) if vals else 0

 
# ------------------------------------------------------------
# 9. FINAL SELECTION
# ------------------------------------------------------------
class CandidateSelection(AuditMixin):
    STATUS = [("Selected", "Selected"), ("Offer Generated", "Offer Generated"), ("Rejected", "Rejected")]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="candidate_selections")
    candidate = models.OneToOneField(EmployeeDT, on_delete=models.CASCADE, related_name="selection")
    requisition = models.ForeignKey(JobRequisition, null=True, blank=True, on_delete=models.SET_NULL, related_name="selections")
    approved_ctc_lpa = models.DecimalField(max_digits=8, decimal_places=2, null=True, blank=True)
    joining_date = models.DateField(null=True, blank=True)
    reporting_manager = models.ForeignKey(EmployeeDT, null=True, blank=True, on_delete=models.SET_NULL, related_name="selected_reportees")
    status = models.CharField(max_length=20, choices=STATUS, default="Selected")
    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)


# ------------------------------------------------------------
# 10. OFFER
# ------------------------------------------------------------
class Offer(AuditMixin):
    STATUS = [("Draft", "Draft"), ("Sent", "Sent"), ("Accepted", "Accepted"),
              ("Declined", "Declined"), ("Expired", "Expired"), ("Withdrawn", "Withdrawn")]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="recruitment_offers")
    offer_id = models.CharField(max_length=30, db_index=True)  # OFF-2026-091
    candidate = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="offers")
    designation = models.CharField(max_length=200, blank=True, null=True)
    offered_ctc_lpa = models.DecimalField(max_digits=8, decimal_places=2)
    target_joining_date = models.DateField(null=True, blank=True)
    valid_until = models.DateField(null=True, blank=True)
    status = models.CharField(max_length=10, choices=STATUS, default="Draft", db_index=True)
    letter_text = models.TextField(blank=True, null=True)
    sent_at = models.DateTimeField(null=True, blank=True)
    responded_at = models.DateTimeField(null=True, blank=True)
    decline_reason = models.TextField(blank=True, null=True)

    class Meta:
        ordering = ["-created_at"]
        unique_together = (("company", "offer_id"),)


# ------------------------------------------------------------
# 11. DOCUMENT REVIEW (status on top of existing EmployeeDocument)
# ------------------------------------------------------------
class DocumentReview(TrackingFields):
    STATUS = [("Pending", "Pending"), ("Verified", "Verified"), ("Rejected", "Rejected")]

    document = models.OneToOneField(EmployeeDocument, on_delete=models.CASCADE, related_name="review")
    status = models.CharField(max_length=10, choices=STATUS, default="Pending")
    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)


# ------------------------------------------------------------
# 12. BACKGROUND VERIFICATION CASE
# ------------------------------------------------------------
class BGVCase(AuditMixin):
    STATUS = [("Initiated", "Initiated"), ("In Progress", "In Progress"),
              ("Verified", "Verified"), ("Failed", "Failed")]
    RESULT = [("Pending", "Pending"), ("Clean", "Clean"), ("Adverse", "Adverse")]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="bgv_cases")
    candidate = models.OneToOneField(EmployeeDT, on_delete=models.CASCADE, related_name="bgv_case")
    agency = models.CharField(max_length=250, blank=True, null=True)
    checks = models.JSONField(default=list, blank=True)   # ["National ID","Edu","Emp","Criminal"]
    status = models.CharField(max_length=12, choices=STATUS, default="Initiated", db_index=True)
    result = models.CharField(max_length=10, choices=RESULT, default="Pending")
    result_note = models.TextField(blank=True, null=True)
    report = models.FileField(upload_to="candidate_documents/bgv_reports/", null=True, blank=True)
    completed_at = models.DateTimeField(null=True, blank=True)
    
    
# ============================================================
# ADDITIVE: Hiring Plus models (see models_plus.py)
# ============================================================
from .models_plus import *  # noqa: E402,F401,F403

# ============================================================
# ADDITIVE: Candidate Portal models (see models_portal.py)
# ============================================================
from .models_portal import *  # noqa: E402,F401,F403

# ============================================================
# ADDITIVE: Candidate registration + auto-save drafts (see models_register.py)
# ============================================================
from .models_register import *  # noqa: E402,F401,F403


    