# ============================================================
# ADDITIVE: 30-60-90 Day Review (Profile360 -> "30-60-90 Review" tab)
# Imported at the bottom of People/models.py.
#
#   ReviewMilestone  one row per (employee, 30 | 60 | 90)
#   ReviewCriterion  scored criteria rows of a milestone (score + observation note)
# ============================================================
from django.db import models

from Company.models import company_details
from Employee.models import EmployeeDT

from .models import Audit


class ReviewMilestone(Audit):
    DAYS = [(30, "30 Days - Performance of the Employee"),
            (60, "60 Days - Technical Strong"),
            (90, "90 Days - Overall Flow")]
    STATUS = [("PENDING", "Pending"), ("IN_PROGRESS", "In Progress"), ("COMPLETED", "Completed"),
              ("COMPETENT_STRONG", "Competent & Strong"), ("CONFIRMED", "Confirmed"),
              ("NEEDS_IMPROVEMENT", "Needs Improvement")]
    OUTCOME = [("RECOMMENDED_CONFIRMATION", "Recommended for Full Confirmation"),
               ("EXTEND_PROBATION", "Extend Probation"),
               ("NOT_RECOMMENDED", "Not Recommended for Confirmation")]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="review_milestones")
    employee = models.ForeignKey(EmployeeDT, on_delete=models.CASCADE, related_name="review_milestones")
    milestone_day = models.PositiveSmallIntegerField(choices=DAYS, db_index=True)
    status = models.CharField(max_length=20, choices=STATUS, default="PENDING", db_index=True)
    score = models.DecimalField(max_digits=3, decimal_places=1, null=True, blank=True)   # 1.0 - 5.0
    reviewer_name = models.CharField(max_length=150, blank=True, default="")
    reviewer_title = models.CharField(max_length=150, blank=True, default="")
    target_date = models.DateField(null=True, blank=True)
    completed_date = models.DateField(null=True, blank=True)
    strengths = models.JSONField(default=list, blank=True)       # "Key Strengths (one per line)"
    improvements = models.JSONField(default=list, blank=True)    # "Areas for Improvement / Next Goals (one per line)"
    remarks = models.TextField(blank=True, default="")           # "Manager & HR Feedback Remarks"
    outcome = models.CharField(max_length=30, choices=OUTCOME, blank=True, default="")   # 90-day only

    class Meta:
        unique_together = (("employee", "milestone_day"),)
        ordering = ["employee_id", "milestone_day"]


class ReviewCriterion(Audit):
    milestone = models.ForeignKey(ReviewMilestone, on_delete=models.CASCADE, related_name="criteria")
    position = models.PositiveSmallIntegerField(default=0)
    name = models.CharField(max_length=200)
    score = models.DecimalField(max_digits=3, decimal_places=1, null=True, blank=True)   # 1.0 - 5.0
    note = models.TextField(blank=True, default="")

    class Meta:
        ordering = ["milestone_id", "position", "id"]


# ============================================================
# DYNAMIC CONFIGURATION (per company) - nothing about the review form is hard-coded.
# First access seeds the standard 30/60/90 set (review_engine.DEFAULTS); after that the
# database is the single source of truth and HR edits it through /api/people/review-306090-config/.
# ============================================================
class ReviewSettings(Audit):
    company = models.OneToOneField(company_details, on_delete=models.CASCADE, related_name="review_settings")
    due_soon_days = models.PositiveSmallIntegerField(default=7)        # "due soon" window on the dashboard
    window_days = models.PositiveSmallIntegerField(default=120)        # dashboard: joined within the last N days
    score_min = models.DecimalField(max_digits=3, decimal_places=1, default=1)
    score_max = models.DecimalField(max_digits=3, decimal_places=1, default=5)
    score_step = models.DecimalField(max_digits=3, decimal_places=1, default=0.5)   # drop-down step in the modal
    seeded = models.BooleanField(default=False)


class ReviewTemplate(Audit):
    """One milestone of the company's review plan (default: Day 30 / 60 / 90) - all texts editable."""
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="review_templates")
    milestone_day = models.PositiveSmallIntegerField()                 # days after joining (1 - 730)
    title = models.CharField(max_length=150)
    tab_label = models.CharField(max_length=150, blank=True, default="")
    subtitle = models.CharField(max_length=250, blank=True, default="")
    section_title = models.CharField(max_length=150, blank=True, default="")
    table_headers = models.JSONField(default=dict, blank=True)         # {criterion, score, notes}
    labels = models.JSONField(default=dict, blank=True)                # {target_date, reviewer, status, strengths, improvements, remarks, outcome}
    default_reviewer_title = models.CharField(max_length=150, blank=True, default="")

    class Meta:
        unique_together = (("company", "milestone_day"),)
        ordering = ["company_id", "milestone_day"]


class ReviewTemplateCriterion(Audit):
    template = models.ForeignKey(ReviewTemplate, on_delete=models.CASCADE, related_name="criteria")
    position = models.PositiveSmallIntegerField(default=0)
    name = models.CharField(max_length=200)

    class Meta:
        ordering = ["template_id", "position", "id"]


class ReviewOption(Audit):
    """Company-defined drop-down values: milestone statuses and the final probation outcomes."""
    STATUS, OUTCOME = "STATUS", "OUTCOME"
    KINDS = [(STATUS, "Milestone status"), (OUTCOME, "Final outcome")]
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="review_options")
    kind = models.CharField(max_length=10, choices=KINDS)
    code = models.CharField(max_length=30)
    label = models.CharField(max_length=100)
    counts_as_completed = models.BooleanField(default=False)           # STATUS only: finished assessment?
    milestone_days = models.JSONField(default=list, blank=True)        # [] = every milestone, else only these days
    position = models.PositiveSmallIntegerField(default=0)
    is_system = models.BooleanField(default=False)                     # Pending / In Progress can be renamed, not removed

    class Meta:
        unique_together = (("company", "kind", "code"),)
        ordering = ["company_id", "kind", "position", "id"]
