"""Home screen: one tile per app with a live status line."""
from datetime import date, timedelta

from flask import Blueprint, g, redirect, render_template, session, url_for

from .. import context_branch_ids, login_required
from ..apps import GROUPS, locked_apps, visible_apps
from ..db import placeholders, q
from ..i18n import t
from ..ledger import invoice_residuals
from .dashboard import greeting

bp = Blueprint("home", __name__)

# app key -> fixed description, for apps without a live count
STATIC = {"reports": "P&L, balance sheet, VAT", "dashboard": "Key figures and trends",
          "settings": "Company, branches, users", "import": "From your old system"}


def _count(sql, args):
    return q(sql, args, one=True)[0] or 0


def _open_invoices(kind, ids, due_by):
    rows = q(f"SELECT id, COALESCE(due_date, date) AS due FROM invoices WHERE kind = ? AND state = 'posted' "
             f"AND COALESCE(due_date, date) <= ? AND branch_id IN ({placeholders(ids)})", [kind, due_by] + list(ids))
    res = invoice_residuals([r["id"] for r in rows])
    return sum(1 for r in rows if res.get(r["id"], 0) > 0)


def statuses(keys, ids):
    """{app key: (count, text, tone)}; tone is bad / warn / ok / '' (neutral)."""
    today = date.today().isoformat()
    out = {}
    ph = placeholders(ids) if ids else "NULL"

    def put(key, n, forms, none, tone):
        """forms: (singular, plural) text after the number."""
        out[key] = (n, f"{n} {t(forms[0] if n == 1 else forms[1])}" if n else t(none), tone if n else "ok")

    if not ids:
        return out
    if "bank" in keys or "accounting" in keys:
        from ..cheques import due
        n = len(due(ids))
        if n:
            out["cheques"] = n
    if "sales" in keys:
        yesterday = (date.today() - timedelta(days=1)).isoformat()
        put("sales", _open_invoices("out_invoice", ids, yesterday), ("overdue invoice", "overdue invoices"),
            "No overdue invoices", "bad")
    if "purchases" in keys:
        week = (date.today() + timedelta(days=7)).isoformat()
        put("purchases", _open_invoices("in_invoice", ids, week), ("bill due within 7 days", "bills due within 7 days"),
            "No bills due this week", "warn")
    if "inventory" in keys:
        put("inventory", _count(f"SELECT COUNT(*) FROM pickings WHERE state = 'ready' AND branch_id IN ({ph})", ids),
            ("transfer waiting", "transfers waiting"), "Nothing waiting", "warn")
    if "pos" in keys:
        n = _count(f"SELECT COUNT(*) FROM pos_sessions WHERE state = 'open' AND branch_id IN ({ph})", ids)
        out["pos"] = (0, f"{n} {t('session open' if n == 1 else 'sessions open')}" if n else t("No open sessions"),
                      "ok" if n else "")
    if "crm" in keys:
        put("crm", _count("SELECT COUNT(*) FROM crm_activities WHERE done = 0 AND due_date <= ? AND user_id = ?",
                          (today, g.user["id"])), ("activity due", "activities due"), "No activities due",
            "warn")
    if "vendors" in keys:
        soon = (date.today() + timedelta(days=30)).isoformat()
        put("vendors", _count("SELECT COUNT(*) FROM vendor_documents WHERE expiry_date IS NOT NULL AND expiry_date <= ?",
                              (soon,)), ("document expiring", "documents expiring"), "No documents expiring",
            "warn")
    if "accounting" in keys:
        from ..recurring import due_count
        due = due_count(today, ids)
        if due:
            put("accounting", due, ("recurring document due", "recurring documents due"), "", "warn")
        else:
            put("accounting", _count(f"SELECT COUNT(*) FROM moves WHERE state = 'draft' AND branch_id IN ({ph})", ids),
                ("draft entry", "draft entries"), "No draft entries", "")
    if "bank" in keys and out.get("cheques"):
        n = out.pop("cheques")
        put("bank", n, ("cheque due to clear", "cheques due to clear"), "", "warn")
    elif "bank" in keys:
        out.pop("cheques", None)
        put("bank", _count(f"SELECT COUNT(*) FROM bank_statement_lines l JOIN bank_statements s ON s.id = l.statement_id "
                           f"WHERE l.state = 'unmatched' AND s.branch_id IN ({ph})", ids),
            ("line to match", "lines to match"), "All lines matched", "warn")
    if "assets" in keys:
        from ..schedules import due_depreciation
        put("assets", len(due_depreciation(today, ids)), ("depreciation line due", "depreciation lines due"),
            "Depreciation up to date", "warn")
    if "prepaid" in keys:
        from ..schedules import due_recognitions
        due, rev = due_recognitions(today, ids)
        put("prepaid", len(due) + len(rev), ("entry due", "entries due"), "All posted", "warn")
    if "hr" in keys:
        from ..payroll import expiring_documents
        put("hr", len(expiring_documents(ids, 30)), ("document expiring", "documents expiring"), "No documents expiring",
            "warn")
    return out


@bp.route("/")
@login_required
def index():
    ids = context_branch_ids()
    apps = visible_apps()
    st = statuses({a["key"] for a in apps}, ids)
    for a in apps:
        a["count"], a["status"], a["tone"] = st.get(a["key"], (0, t(STATIC.get(a["key"], "")), ""))
    groups = [(grp, [a for a in apps if a["group"] == grp]) for grp in GROUPS]
    return render_template("home.html", groups=[gr for gr in groups if gr[1]], locked=[],  # modules not licensed leave no trace (they are listed under License & Modules)
                           
                           greeting=greeting(), branches_n=len(ids), today=date.today())


@bp.route("/app/<key>")
@login_required
def open_app(key):
    for a in visible_apps():
        if a["key"] == key:
            session["app"] = key
            return redirect(a["url"])
    return redirect(url_for("home.index"))
