from datetime import date, datetime, timedelta, timezone

from sqlalchemy.orm import Session

from app.config import FOLLOW_UP_SCHEDULE
from app.models import FollowUp, Lead


def compute_fu_state(fu: FollowUp, today: date | None = None) -> str:
    today = today or date.today()
    if fu.status == "done":
        return "done"
    if fu.status == "skipped":
        return "skipped"
    if fu.scheduled_date < today:
        return "overdue"
    if fu.scheduled_date == today:
        return "due"
    return "pending"


def lead_sequence_status(lead: Lead, today: date | None = None) -> str:
    today = today or date.today()
    states = [compute_fu_state(fu, today) for fu in lead.follow_ups]
    if not states:
        return "not_started"
    if all(s in ("done", "skipped") for s in states):
        return "completed"
    if any(s == "overdue" for s in states):
        return "overdue"
    if any(s == "due" for s in states):
        return "due_today"
    if any(s == "done" for s in states):
        return "in_progress"
    return "not_started"


def enrich_lead(lead: Lead, today: date | None = None) -> Lead:
    today = today or date.today()
    for fu in lead.follow_ups:
        fu.computed_state = compute_fu_state(fu, today)  # type: ignore[attr-defined]
    lead.sequence_status = lead_sequence_status(lead, today)  # type: ignore[attr-defined]
    total = len(lead.follow_ups) or 1
    done = sum(1 for fu in lead.follow_ups if fu.status in ("done", "skipped"))
    lead.progress_pct = round((done / total) * 100, 1)  # type: ignore[attr-defined]
    return lead


def build_follow_ups(date_added: date) -> list[FollowUp]:
    items: list[FollowUp] = []
    for spec in FOLLOW_UP_SCHEDULE:
        items.append(
            FollowUp(
                number=spec["number"],
                day_label=spec["day_label"],
                scheduled_date=date_added + timedelta(days=spec["offset_days"]),
                status="pending",
            )
        )
    return items


def next_lead_code(db: Session) -> str:
    last = db.query(Lead).order_by(Lead.id.desc()).first()
    next_num = (last.id + 1) if last else 1
    # Prefer highest lead_code number if present
    codes = [l.lead_code for l in db.query(Lead.lead_code).all()]
    max_n = 0
    for code in codes:
        try:
            max_n = max(max_n, int(code.split("-")[-1]))
        except ValueError:
            pass
    next_num = max(next_num, max_n + 1)
    return f"L-{next_num:03d}"


def mark_follow_up(fu: FollowUp, status: str) -> FollowUp:
    fu.status = status
    if status == "done":
        fu.completed_at = datetime.now(timezone.utc)
    elif status == "pending":
        fu.completed_at = None
    return fu


def reschedule_follow_ups(lead: Lead) -> None:
    """Rebuild pending FU dates from date_added; keep done/skipped as-is dates unless pending."""
    offset_map = {s["number"]: s["offset_days"] for s in FOLLOW_UP_SCHEDULE}
    for fu in lead.follow_ups:
        if fu.status == "pending":
            fu.scheduled_date = lead.date_added + timedelta(days=offset_map[fu.number])
