#!/usr/bin/env python3
"""Traduction EN→FR hors-ligne (Argos) + régénération SQL."""
from __future__ import annotations

import json
import re
from pathlib import Path

import argostranslate.translate

DIR = Path(__file__).resolve().parent
JSON_PATH = DIR / "classified_all.json"

FIELDS = [
    "summary",
    "pain_point",
    "objections",
    "next_step",
    "urgency",
    "budget",
    "language",
    "scam_type",
    "case_status",
    "payment",
]

STATIC = {
    "French": "Français",
    "English": "Anglais",
    "Russian": "Russe",
    "Polish": "Polonais",
    "Arabic": "Arabe",
    "Turkish": "Turc",
    "New": "Nouveau",
    "In progress": "En cours",
    "Pending": "En attente",
    "hot": "chaud",
    "warm": "tiède",
    "cold": "froid",
}


def is_english(text: str) -> bool:
    if not text or len(text.strip()) < 3:
        return False
    t = text.strip()
    if t in STATIC:
        return True
    if re.fullmatch(r"[\d\s.,€$+\-_/]+", t):
        return False
    low = t.lower()
    eng = len(
        re.findall(
            r"\b(the|and|with|for|from|this|that|customer|interested|follow|called|expressed|"
            r"recovery|account|scam|funds|looking|wants|needs|about|their|have|has|was|were|"
            r"will|would|process|assistance|investment|platform|email|phone|call|next|step|"
            r"she|he|they|his|her|been|being|null)\b",
            low,
        )
    )
    fr = len(
        re.findall(
            r"\b(le|la|les|des|une|un|est|sont|pour|avec|dans|sur|pas|qui|que|"
            r"appel|client|arnaque|compte|fonds|intéressé|suite|elle|il|ils|son|sa)\b",
            low,
        )
    )
    if eng >= 2 and eng >= fr:
        return True
    if eng >= 1 and fr == 0 and not re.search(r"[àâäéèêëïîôùûüç]", low):
        return True
    return False


def translate_fr(text: str) -> str:
    text = (text or "").strip()
    if not text:
        return ""
    if text in STATIC:
        return STATIC[text]
    if not is_english(text):
        return text
    # découper longs textes
    if len(text) < 2000:
        try:
            return argostranslate.translate.translate(text, "en", "fr")
        except Exception:
            return text
    parts: list[str] = []
    rem = text
    while len(rem) > 1800:
        cut = rem.rfind(". ", 0, 1800)
        if cut < 80:
            cut = 1800
        parts.append(rem[: cut + 1].strip())
        rem = rem[cut + 1 :].strip()
    if rem:
        parts.append(rem)
    out = []
    for p in parts:
        try:
            out.append(argostranslate.translate.translate(p, "en", "fr"))
        except Exception:
            out.append(p)
    return " ".join(out)


def dash(v: str) -> str:
    return v if v else "—"


def build_notes_fr(c: dict) -> str:
    status_map = {"hot": "chaud", "warm": "tiède", "cold": "froid"}
    st = status_map.get((c.get("status_temp") or "").lower(), c.get("status_temp") or "—")
    phone = c.get("phone") or ""
    if phone and not str(phone).startswith("+"):
        phone = "+" + "".join(ch for ch in phone if ch.isdigit())
    typ = c.get("type") or c.get("industry") or "—"
    return "\n".join(
        [
            "═══ FICHE CONTACT (import batch) ═══",
            f"Source : {c.get('source_file') or '—'}",
            f"Priorité CRM : {c.get('priority') or 'moyenne'}",
            f"Type : {typ}",
            f"Statut temporaire : {st}",
            "",
            "── Identité ──",
            f"Nom : {dash(c.get('name') or '')}",
            f"Téléphone : {dash(phone)}",
            f"E-mail : {dash(c.get('email') or '')}",
            f"Pays : {dash(c.get('country') or 'France')}",
            f"Langue : {dash(c.get('language') or '')}",
            "",
            "── Commercial ──",
            f"Industrie : {dash(c.get('industry') or typ)}",
            f"Courtier : {dash(c.get('broker') or '')}",
            f"Dépôt : {dash(c.get('deposit') or '')}",
            f"Étape FTD : {dash(c.get('ftd_stage') or '')}",
            f"Urgence : {dash(c.get('urgency') or '')}",
            f"Budget : {dash(c.get('budget') or '')}",
            "",
            "── Recovery ──",
            f"Montant perdu : {dash(c.get('amount_lost') or '')}",
            f"Type d'arnaque : {dash(c.get('scam_type') or '')}",
            f"Statut du dossier : {dash(c.get('case_status') or '')}",
            f"Banque : {dash(c.get('bank') or '')}",
            f"Paiement : {dash(c.get('payment') or '')}",
            "",
            "── Synthèse ──",
            f"Point de douleur : {dash(c.get('pain_point') or '')}",
            f"Objections : {dash(c.get('objections') or '')}",
            f"Résumé : {dash(c.get('summary') or '')}",
            f"Prochaine étape : {dash(c.get('next_step') or '')}",
            "",
            f"Date du lead : {dash(c.get('lead_date') or '')}",
            f"Code de sécurité : {dash(c.get('security_code') or '')}",
        ]
    )


def main() -> None:
    contacts = json.loads(JSON_PATH.read_text(encoding="utf-8"))
    cache: dict[str, str] = {}
    total = len(contacts)
    for i, c in enumerate(contacts, 1):
        name = (c.get("name") or "?").encode("ascii", "replace").decode("ascii")
        if i % 25 == 0 or i == 1:
            print(f"[{i}/{total}] {name}", flush=True)
        for f in FIELDS:
            v = (c.get(f) or "").strip()
            if not v:
                continue
            if v in cache:
                c[f] = cache[v]
            elif is_english(v) or v in STATIC:
                fr = translate_fr(v)
                cache[v] = fr
                c[f] = fr
        c["tags"] = [STATIC.get(t, t) for t in (c.get("tags") or [])]
        c["notes"] = build_notes_fr(c)

    JSON_PATH.write_text(json.dumps(contacts, ensure_ascii=False, indent=2), encoding="utf-8")
    print("JSON OK", flush=True)

    import regen_clients_sql as regen

    regen.main()

    sql = (DIR / "import_ready.sql").read_text(encoding="utf-8")
    for p in ["The customer", "The call", "interested in", "follow-up", "expressed"]:
        print(f"SQL leftover '{p}': {sql.count(p)}", flush=True)
    left = sum(1 for c in contacts if is_english(c.get("summary") or ""))
    print(f"summaries still EN: {left}", flush=True)
    # sample
    for c in contacts:
        if c.get("name") == "Sophie Brana":
            print("SAMPLE Sophie:", (c.get("summary") or "")[:200], flush=True)
            break
    print("DONE", flush=True)


if __name__ == "__main__":
    main()
