"""Template: cost approach grid (land + cost new − depreciation)."""

from __future__ import annotations

from typing import Any

from app.tools.coerce import num, pct


def _f(p: dict[str, Any], key: str, default: float) -> float:
    """Tolerant numeric param; keys ending in `_pct` / starting with `taux` are ratios."""
    raw = p.get(key)
    v = pct(raw, None) if (key.endswith("_pct") or key.startswith("taux")) else num(raw, None)
    return float(default) if v is None else v


def build(p: dict[str, Any]) -> dict[str, Any]:
    adresse = p.get("adresse", "Immeuble fictif — Gatineau")
    superficie = _f(p, "superficie_m2", 210)
    cout_unitaire = _f(p, "cout_unitaire_m2", 2450)
    indirects = _f(p, "couts_indirects_pct", 0.12)
    profit = _f(p, "profit_pct", 0.15)
    terrain = _f(p, "valeur_terrain", 185000)
    site = _f(p, "ameliorations_site", 25000)
    age_eff = _f(p, "age_effectif", 12)
    dve = _f(p, "duree_vie_economique", 60)
    dep_fonct = _f(p, "depreciation_fonctionnelle", 0)
    dep_econ = _f(p, "depreciation_economique", 0)
    inputs = [
        {"cell": "B4", "label": "Superficie brute (m²)", "value": superficie, "format": "area",
         "name": "Superficie"},
        {"cell": "B5", "label": "Coût unitaire direct ($/m²)", "value": cout_unitaire,
         "format": "currency", "name": "Cout_Unitaire"},
        {"cell": "B6", "label": "Coûts indirects (% des coûts directs)", "value": indirects,
         "format": "percent", "name": "Indirects_Pct"},
        {"cell": "B7", "label": "Profit de l'entrepreneur (%)", "value": profit,
         "format": "percent", "name": "Profit_Pct"},
        {"cell": "B8", "label": "Âge effectif (ans)", "value": age_eff, "format": "number",
         "name": "Age_Effectif"},
        {"cell": "B9", "label": "Durée de vie économique (ans)", "value": dve,
         "format": "number", "name": "DVE"},
        {"cell": "B10", "label": "Valeur du terrain ($)", "value": terrain, "format": "currency",
         "name": "Valeur_Terrain"},
        {"cell": "B11", "label": "Améliorations du site ($)", "value": site,
         "format": "currency", "name": "Ameliorations_Site"},
        {"cell": "B12", "label": "Dépréciation fonctionnelle ($)", "value": dep_fonct,
         "format": "currency"},
        {"cell": "B13", "label": "Dépréciation économique ($)", "value": dep_econ,
         "format": "currency"},
    ]
    table = {
        "anchor": "A16",
        "columns": [{"header": "Poste", "type": "text"}, {"header": "Montant ($)", "type": "currency"},
                    {"header": "Calcul", "type": "text"}],
        "rows": [
            ["Coûts directs", "=B4*B5", "Superficie × coût unitaire"],
            ["Coûts indirects", "=B17*B6", "Directs × % indirects"],
            ["Profit de l'entrepreneur", "=(B17+B18)*B7", "(Directs + indirects) × % profit"],
            ["Coût neuf (C_N)", "=B17+B18+B19", "Somme"],
            ["Dépréciation physique (âge-vie)", "=B20*B8/B9", "C_N × (âge effectif / DVE)"],
            ["Dépréciation fonctionnelle", "=B12", "Hypothèse"],
            ["Dépréciation économique", "=B13", "Hypothèse"],
            ["Dépréciation totale (D)", "=B21+B22+B23", "Somme"],
            ["Coût déprécié des améliorations", "=B20-B24", "C_N − D"],
            ["Valeur du terrain", "=B10", "Hypothèse"],
            ["Améliorations du site", "=B11", "Hypothèse"],
        ],
        "totals": {"label": "VALEUR INDIQUÉE (méthode du coût)", "formula": "=B25+B26+B27",
                   "name": "Valeur_Indiquee"},
        "bold_rows": [3, 7],
    }
    return {
        "filename": p.get("filename", "methode_du_cout.xlsx"),
        "style": "uqo",
        "sheets": [{
            "name": "Méthode du coût",
            "title": f"Estimation par la méthode du coût — {adresse}",
            "inputs_title": "Hypothèses (cellules bleues modifiables)",
            "inputs": inputs,
            "tables": [table],
            "charts": [{"type": "bar", "title": "Ventilation de la valeur",
                        "categories_range": "A25:A27", "values_range": "B25:B27",
                        "anchor": "E16"}],
            "notes": [
                "V = V_T + (C_N − D) + améliorations du site.",
                "Dépréciation physique estimée par la méthode âge-vie : D = (A_e / DVE) × C_N.",
                "Les cellules bleues sont des hypothèses ; tout le reste est calculé par formule.",
            ],
        }],
    }