"""Customer and vendor statements of account: on screen, as PDF and by email (single or in bulk), and reminders."""
from datetime import date

from flask import Blueprint, Response, abort, flash, redirect, render_template, request, url_for

from .. import context_branch_ids, currency_decimals, login_required, write_required
from ..db import commit, placeholders, q
from ..i18n import nm, t
from ..ledger import AccountingError, company, fy_start
from ..mailer import configured, send
from ..money import fmt
from ..pdf import statement_pdf
from ..statements import BUCKETS, SIDES, balances, statement
from .common import user_id

bp = Blueprint("statements", __name__, url_prefix="/statements")


def side_or_404(side):
    if side not in SIDES:
        abort(404)
    return side


def partner_or_404(pid, side):
    p = q(f"SELECT * FROM partners WHERE id = ? AND is_{side} = 1", (pid,), one=True)
    if not p:
        abort(404)
    return p


def period():
    date_to = request.values.get("date_to") or date.today().isoformat()
    date_from = request.values.get("date_from") or fy_start(date_to)
    if date_from > date_to:
        date_from = date_to
    return date_from, date_to


def decimals_for(sections):
    return {s["currency"]: currency_decimals(s["currency"]) for s in sections}


def amounts_text(sections):
    return ", ".join(f"{s['currency']} {fmt(s['closing'], currency_decimals(s['currency']))}" for s in sections) or "0"


def make_pdf(p, side, sections, date_from, date_to):
    return statement_pdf(company(), p, side, sections, date_from, date_to, decimals_for(sections))


def pdf_name(p, date_to):
    safe = "".join(ch if ch.isalnum() else "_" for ch in p["name_en"]).strip("_")[:40] or "partner"
    return f"Statement_{safe}_{date_to}.pdf"


def default_message(kind, p, side, sections, date_from, date_to):
    co = nm(company())
    if kind == "reminder":
        lines, oldest = [], 0
        for s in sections:
            dec = currency_decimals(s["currency"])
            for o in s["open_items"]:
                if o["days"] > 0:
                    oldest = max(oldest, o["days"])
                    lines.append(f"  {o['number']}  ·  {t('due')} {o['due_date'] or o['date']}  ·  "
                                 f"{s['currency']} {fmt(o['residual'], dec)}  ({o['days']} {t('days overdue')})")
        # the tone gets firmer as the invoices get older
        if oldest > 60:
            title = t("Final notice")
            ask = t("Despite our earlier reminders these invoices remain unpaid. Please settle the balance within 7 days, "
                    "otherwise we will have to put your account on hold.")
        elif oldest > 30:
            title = t("Second payment reminder")
            ask = t("We have not yet received payment for these invoices. Please arrange payment this week, or let us "
                    "know if there is a problem with any of them.")
        else:
            title = t("Payment reminder")
            ask = t("We would appreciate your payment at your earliest convenience. If you have already paid, please "
                    "ignore this message.")
        subject = f"{title} — {co}"
        body = (f"{t('Dear')} {nm(p)},\n\n{t('According to our records, the following invoices are past their due date:')}\n\n"
                + "\n".join(lines or ["  —"]) +
                f"\n\n{t('Balance due')}: {amounts_text(sections)}\n\n{ask}"
                f"\n{t('Your statement of account is attached.')}\n\n{t('Kind regards')},\n{co}")
        return subject, body
    subject = f"{t('Statement of Account')} — {co} — {date_to}"
    body = (f"{t('Dear')} {nm(p)},\n\n{t('Please find attached your statement of account for the period')} "
            f"{date_from} — {date_to}.\n\n{t('Balance') if side == 'customer' else t('Balance payable')}: {amounts_text(sections)}\n\n"
            f"{t('Please contact us if anything does not agree with your records.')}\n\n{t('Kind regards')},\n{co}")
    return subject, body


@bp.route("/<side>")
@login_required
def index(side):
    side_or_404(side)
    ids = context_branch_ids()
    date_from, date_to = period()
    search = request.args.get("q", "").strip()
    with_balance = request.args.get("all") != "1"
    sql = f"SELECT * FROM partners WHERE is_{side} = 1 AND active = 1"
    args = []
    if search:
        sql += " AND (name_en LIKE ? OR name_ar LIKE ? OR email LIKE ?)"
        args += [f"%{search}%"] * 3
    partners = q(sql + " ORDER BY name_en", args)
    bal = balances(side, ids, date_to, [p["id"] for p in partners])
    rows = [{"p": p, "bal": bal.get(p["id"], {})} for p in partners if not with_balance or bal.get(p["id"])]
    last = {r["partner_id"]: r for r in q(
        f"SELECT partner_id, MAX(sent_at) AS sent_at FROM email_log WHERE state = 'sent' AND kind IN ('statement', 'reminder') "
        f"AND partner_id IN ({placeholders([r['p']['id'] for r in rows]) if rows else 'NULL'}) GROUP BY partner_id",
        [r["p"]["id"] for r in rows])}
    totals = {}
    for r in rows:
        for cur, v in r["bal"].items():
            totals[cur] = totals.get(cur, 0) + v
    return render_template("statements/list.html", side=side, rows=rows, totals=totals, last=last, date_from=date_from,
                           date_to=date_to, search=search, with_balance=with_balance, mail_ready=configured())


@bp.route("/<side>/<int:pid>")
@login_required
def view(side, pid):
    side_or_404(side)
    p = partner_or_404(pid, side)
    date_from, date_to = period()
    sections = statement(pid, side, context_branch_ids(), date_from, date_to)
    log = q("SELECT e.*, u.username FROM email_log e LEFT JOIN users u ON u.id = e.sent_by WHERE e.partner_id = ? "
            "ORDER BY e.id DESC LIMIT 8", (pid,))
    return render_template("statements/view.html", side=side, p=p, sections=sections, date_from=date_from,
                           date_to=date_to, buckets=BUCKETS, log=log, mail_ready=configured(),
                           overdue=any(s["overdue"] > 0 for s in sections))


@bp.route("/<side>/<int:pid>/pdf")
@login_required
def pdf(side, pid):
    side_or_404(side)
    p = partner_or_404(pid, side)
    date_from, date_to = period()
    data = make_pdf(p, side, statement(pid, side, context_branch_ids(), date_from, date_to), date_from, date_to)
    disposition = "attachment" if request.args.get("download") else "inline"
    return Response(data, mimetype="application/pdf",
                    headers={"Content-Disposition": f'{disposition}; filename="{pdf_name(p, date_to)}"'})


@bp.route("/<side>/<int:pid>/email", methods=["GET", "POST"])
@write_required
def email(side, pid):
    side_or_404(side)
    p = partner_or_404(pid, side)
    date_from, date_to = period()
    kind = "reminder" if request.values.get("kind") == "reminder" else "statement"
    sections = statement(pid, side, context_branch_ids(), date_from, date_to)
    subject, body = default_message(kind, p, side, sections, date_from, date_to)
    form = {"to": p["email"] or "", "cc": "", "subject": subject, "body": body}
    if request.method == "POST":
        form = {k: request.form.get(k, "") for k in form}
        try:
            send(form["to"], form["subject"], form["body"],
                 [(pdf_name(p, date_to), make_pdf(p, side, sections, date_from, date_to), "application/pdf")],
                 cc=form["cc"], kind=kind, model="partner", record_id=pid, partner_id=pid, user_id=user_id())
            commit()
            flash(t("Email sent."), "success")
            return redirect(url_for("statements.view", side=side, pid=pid, date_from=date_from, date_to=date_to))
        except AccountingError as e:
            commit()  # keep the failed attempt in the email log
            flash(str(e), "error")
    return render_template("emails/compose.html", form=form, attachment=pdf_name(p, date_to), mail_ready=configured(),
                           title=t("Payment reminder") if kind == "reminder" else t("Email statement"),
                           back=url_for("statements.view", side=side, pid=pid, date_from=date_from, date_to=date_to),
                           hidden={"date_from": date_from, "date_to": date_to, "kind": kind})


@bp.route("/<side>/send", methods=["POST"])
@write_required
def send_many(side):
    """Email the statement to every selected partner that has an email address."""
    side_or_404(side)
    date_from, date_to = period()
    ids = context_branch_ids()
    kind = "reminder" if request.form.get("kind") == "reminder" else "statement"
    sent, skipped, failed = 0, [], []
    for pid in request.form.getlist("pid"):
        p = q(f"SELECT * FROM partners WHERE id = ? AND is_{side} = 1", (pid,), one=True)
        if not p:
            continue
        if not p["email"]:
            skipped.append(nm(p))
            continue
        sections = statement(p["id"], side, ids, date_from, date_to)
        subject, body = default_message(kind, p, side, sections, date_from, date_to)
        try:
            send(p["email"], subject, body,
                 [(pdf_name(p, date_to), make_pdf(p, side, sections, date_from, date_to), "application/pdf")],
                 kind=kind, model="partner", record_id=p["id"], partner_id=p["id"], user_id=user_id())
            sent += 1
        except AccountingError as e:
            failed.append(f"{nm(p)}: {e}")
            if not configured():
                break
    commit()
    if sent:
        flash(f"{sent} {t('emails sent.')}", "success")
    if skipped:
        flash(f"{t('No email address')}: {', '.join(skipped)}", "error")
    for f in failed[:5]:
        flash(f, "error")
    if not (sent or skipped or failed):
        flash(t("Select at least one partner."), "error")
    return redirect(url_for("statements.index", side=side, date_from=date_from, date_to=date_to))
