# ============================================================
# 8. PROMOTIONS   /api/people/promotions/
# ============================================================
from decimal import Decimal

from django.db import transaction
from django.utils import timezone
from rest_framework.decorators import action

from .common import (CrudBase, emp_brief, emp_by_code, ensure_extra, err, iso, log_history, ok, to_bool, to_date,
                     to_decimal)
from .letters import issue_letter
from .models import PromotionRequest
from .views_letters import letter_row


class PromotionViewSet(CrudBase):
    """
    GET  /api/people/promotions/                      ?status= ?employee=<code> ?search=
    POST /api/people/promotions/                      "Nominate Employee"
         {employee_code, proposed_designation, proposed_grade?, hike_percent?, manager_rating?, effective_date?, remarks?}
    POST /api/people/promotions/<id>/update/          (until executed)
    POST /api/people/promotions/<id>/review/          -> Under Review
    POST /api/people/promotions/<id>/approve/         -> Approved by Committee   {remarks?}
    POST /api/people/promotions/<id>/reject/          {remarks}
    POST /api/people/promotions/<id>/execute/         applies designation + grade (+ salary hike if apply_salary_hike=true)
    POST /api/people/promotions/<id>/letter/          "Promotion Letter" (generates PDF, returns download url)
    """
    model = PromotionRequest
    code = "PROMOTION"
    select = ("employee", "employee__department", "letter")
    search_fields = ("employee__name", "employee__employee_code", "proposed_designation")

    def build(self, p):
        return {"id": p.id, "employee": emp_brief(p.employee), "current_designation": p.current_designation,
                "proposed_designation": p.proposed_designation, "current_grade": p.current_grade,
                "proposed_grade": p.proposed_grade, "salary_band_hike": f"+{Decimal(str(p.hike_percent)).normalize():f}%",
                "hike_percent": float(Decimal(str(p.hike_percent))),
                "manager_review": float(p.manager_rating) if p.manager_rating is not None else None,
                "manager_review_label": f"{p.manager_rating}/5.0" if p.manager_rating is not None else None,
                "status": p.status, "effective_date": iso(p.effective_date), "remarks": p.remarks,
                "committee_remarks": p.committee_remarks, "nominated_by": p.nominated_by,
                "decided_by": p.decided_by, "decided_at": iso(p.decided_at), "executed_at": iso(p.executed_at),
                "letter_id": p.letter_id, "can_issue_letter": p.status in ("Approved by Committee", "Executed")}

    def apply(self, p, d, creating):
        if p.status in ("Executed", "Rejected"):
            raise ValueError(f"A {p.status.lower()} promotion cannot be edited.")
        if creating:
            e = emp_by_code(self.company(), d.get("employee_code"))
            if PromotionRequest.objects.filter(employee=e, is_active=True).exclude(status__in=["Executed", "Rejected"]).exists():
                raise ValueError("This employee already has an open promotion nomination.")
            x = ensure_extra(e)
            p.employee, p.current_designation, p.current_grade = e, e.Designation, x.grade_band
            p.nominated_by = self.actor()
        if "proposed_designation" in d or creating:
            p.proposed_designation = (d.get("proposed_designation") or "").strip()
            if not p.proposed_designation:
                raise ValueError("proposed_designation is required.")
        if "proposed_grade" in d:
            p.proposed_grade = d["proposed_grade"]
        if "hike_percent" in d:
            h = to_decimal(d["hike_percent"], Decimal("0"))
            if h < 0 or h > 500:
                raise ValueError("hike_percent must be between 0 and 500.")
            p.hike_percent = h
        if "manager_rating" in d:
            r = to_decimal(d["manager_rating"])
            if r is not None and not (0 <= r <= 5):
                raise ValueError("manager_rating must be between 0 and 5.")
            p.manager_rating = r
        if "effective_date" in d:
            p.effective_date = to_date(d["effective_date"])
        if "remarks" in d:
            p.remarks = d["remarks"]

    def _p(self, pk):
        return self.scope().filter(pk=pk, is_active=True).first()

    @action(detail=True, methods=["post"])
    def review(self, request, pk=None):
        p = self._p(pk)
        if p is None:
            return err("NOT_FOUND", "Promotion not found.", 404)
        if p.status != "Nominated":
            return err("INVALID_STATE", f"Promotion is {p.status}.", 409)
        p.status, p.updated_by = "Under Review", self.actor()
        p.save()
        return ok("PROMOTION_REVIEW", "Moved to review.", self.build(p))

    @action(detail=True, methods=["post"])
    def approve(self, request, pk=None):
        p = self._p(pk)
        if p is None:
            return err("NOT_FOUND", "Promotion not found.", 404)
        if p.status not in ("Nominated", "Under Review"):
            return err("INVALID_STATE", f"Promotion is {p.status}.", 409)
        p.status, p.decided_by, p.decided_at = "Approved by Committee", self.actor(), timezone.now()
        p.committee_remarks, p.updated_by = request.data.get("remarks"), self.actor()
        p.save()
        return ok("PROMOTION_APPROVED", "Approved by committee.", self.build(p))

    @action(detail=True, methods=["post"])
    def reject(self, request, pk=None):
        p = self._p(pk)
        if p is None:
            return err("NOT_FOUND", "Promotion not found.", 404)
        if p.status in ("Executed", "Rejected"):
            return err("INVALID_STATE", f"Promotion is {p.status}.", 409)
        p.status, p.decided_by, p.decided_at = "Rejected", self.actor(), timezone.now()
        p.committee_remarks, p.updated_by = request.data.get("remarks"), self.actor()
        p.save()
        return ok("PROMOTION_REJECTED", "Promotion rejected.", self.build(p))

    @action(detail=True, methods=["post"])
    @transaction.atomic
    def execute(self, request, pk=None):
        p = self._p(pk)
        if p is None:
            return err("NOT_FOUND", "Promotion not found.", 404)
        if p.status != "Approved by Committee":
            return err("NOT_APPROVED", "Only committee-approved promotions can be executed.")
        d, e = request.data, p.employee
        x = ensure_extra(e)
        eff = p.effective_date or timezone.localdate()
        old_salary = e.Basic_Salary
        e.Designation = p.proposed_designation
        if to_bool(d.get("apply_salary_hike")) and e.Basic_Salary:
            e.Basic_Salary = (e.Basic_Salary * (Decimal("1") + p.hike_percent / Decimal("100"))).quantize(Decimal("0.01"))
        e.updated_by = self.actor()
        e.save()
        if p.proposed_grade:
            x.grade_band = p.proposed_grade
            x.updated_by = self.actor()
            x.save()
        p.status, p.executed_at, p.updated_by = "Executed", timezone.now(), self.actor()
        if not p.effective_date:
            p.effective_date = eff
        p.save()
        log_history(p.company, e, "PROMOTION", f"Promoted to {p.proposed_designation}",
                    f"From {p.current_designation or '-'} (+{p.hike_percent}% band hike)", eff,
                    {"promotion_id": p.id, "old_salary": str(old_salary) if old_salary else None,
                     "new_salary": str(e.Basic_Salary) if e.Basic_Salary else None}, self.actor())
        letter = None
        if to_bool(d.get("issue_letter"), True):
            letter = self._letter(p, request)
        return ok("PROMOTION_EXECUTED", "Promotion executed.", {**self.build(p), "letter": letter,
                  "salary_updated": to_bool(d.get("apply_salary_hike")) and bool(old_salary)})

    def _letter(self, p, request):
        if p.letter_id and p.letter.status == "Issued":
            return letter_row(p.letter, request)
        e = p.employee
        l = issue_letter(p.company, e, "PROMOTION", self.actor(), {
            "new_designation": p.proposed_designation, "new_grade": p.proposed_grade or "-",
            "hike_percent": p.hike_percent, "effective_date": p.effective_date or timezone.localdate(),
            "designation": p.current_designation or e.Designation})
        p.letter, p.updated_by = l, self.actor()
        p.save()
        return letter_row(l, request)

    @action(detail=True, methods=["post"])
    def letter(self, request, pk=None):
        p = self._p(pk)
        if p is None:
            return err("NOT_FOUND", "Promotion not found.", 404)
        if p.status not in ("Approved by Committee", "Executed"):
            return err("NOT_APPROVED", "Promotion letter can be issued only after committee approval.")
        return ok("PROMOTION_LETTER", "Promotion letter ready.", self._letter(p, request), 201)
