"""Cheques received and issued, post-dated cheques (PDC): register, deposit, clear, bounce."""
from datetime import date

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

from .. import check_branch, context_branch_ids, login_required, write_required
from ..cheques import DIRECTIONS, STATES, bounce, clear, deposit, register
from ..db import commit, get_db, placeholders, q
from ..i18n import t
from ..ledger import AccountingError, invoice_residuals
from ..money import to_int
from .common import branch_map, default_branch, journals_for, partners_list, user_id

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


def direction_or_404(direction):
    if direction not in DIRECTIONS:
        abort(404)
    return DIRECTIONS[direction]


def get_cheque(cid):
    c = q("SELECT c.*, p.name_en AS pname_en, p.name_ar AS pname_ar, i.number AS inv_number, j.name_en AS jname_en, "
          "j.name_ar AS jname_ar FROM cheques c JOIN partners p ON p.id = c.partner_id "
          "LEFT JOIN invoices i ON i.id = c.invoice_id LEFT JOIN journals j ON j.id = c.bank_journal_id WHERE c.id = ?",
          (cid,), one=True)
    if not c:
        abort(404)
    check_branch(c["branch_id"])
    return c


@bp.route("/<direction>")
@login_required
def index(direction):
    info = direction_or_404(direction)
    ids = context_branch_ids()
    state = request.args.get("state", "open")
    today = date.today().isoformat()
    rows = []
    if ids:
        sql = (f"SELECT c.*, p.name_en AS pname_en, p.name_ar AS pname_ar, i.number AS inv_number FROM cheques c "
               f"JOIN partners p ON p.id = c.partner_id LEFT JOIN invoices i ON i.id = c.invoice_id "
               f"WHERE c.direction = ? AND c.branch_id IN ({placeholders(ids)})")
        args = [direction] + list(ids)
        if state == "open":
            sql += " AND c.state IN ('registered', 'deposited')"
        elif state == "due":
            sql += " AND c.state IN ('registered', 'deposited') AND c.cheque_date <= ?"
            args.append(today)
        elif state in STATES:
            sql += " AND c.state = ?"
            args.append(state)
        rows = q(sql + " ORDER BY c.cheque_date, c.id", args)
    totals = {"hand": 0, "due": 0, "future": 0}
    if ids:
        for r in q(f"SELECT cheque_date, amount FROM cheques WHERE direction = ? AND state IN ('registered', 'deposited') "
                   f"AND branch_id IN ({placeholders(ids)})", [direction] + list(ids)):
            totals["hand"] += r["amount"]
            totals["due" if r["cheque_date"] <= today else "future"] += r["amount"]
    branches = branch_map()
    curs = {b["currency"] for b in branches.values() if b["id"] in ids}
    return render_template("cheques/list.html", rows=rows, direction=direction, info=info, state=state, states=STATES,
                           branches=branches, totals=totals, today=today,
                           cur=curs.pop() if len(curs) == 1 else None)


@bp.route("/<direction>/new", methods=["GET", "POST"])
@write_required
def form(direction):
    info = direction_or_404(direction)
    inv = None
    if request.values.get("invoice_id", type=int):
        inv = q("SELECT * FROM invoices WHERE id = ?", (request.values.get("invoice_id", type=int),), one=True)
        if not inv:
            abort(404)
        check_branch(inv["branch_id"])
    if request.method == "POST":
        f = request.form
        try:
            data = {"direction": direction, "branch_id": check_branch(f["branch_id"]),
                    "partner_id": int(f["partner_id"]) if f.get("partner_id") else None,
                    "invoice_id": inv["id"] if inv else None, "cheque_no": f.get("cheque_no", "").strip(),
                    "bank_name": f.get("bank_name"), "issue_date": f["issue_date"], "cheque_date": f["cheque_date"],
                    "amount": to_int(f["amount"]), "bank_journal_id": int(f["bank_journal_id"]) if f.get("bank_journal_id") else None,
                    "notes": f.get("notes")}
            if not data["partner_id"]:
                raise AccountingError(t("Choose a partner."))
            cid = register(data, user_id())
            commit()
            flash(t("Cheque registered."), "success")
            return redirect(url_for("cheques.view", cid=cid))
        except (AccountingError, ValueError, KeyError) as e:
            get_db().rollback()
            flash(str(e), "error")
    d = dict(request.form.items()) if request.method == "POST" else {
        "branch_id": inv["branch_id"] if inv else default_branch(), "partner_id": inv["partner_id"] if inv else None,
        "issue_date": date.today().isoformat(), "cheque_date": date.today().isoformat(),
        "amount": invoice_residuals([inv["id"]])[inv["id"]] if inv else None}
    if request.method == "POST":
        d["amount"] = to_int(d.get("amount") or 0) if str(d.get("amount") or "").replace(",", "").replace(".", "").isdigit() else 0
    branches = branch_map()
    return render_template("cheques/form.html", d=d, inv=inv, direction=direction, info=info, branches=branches,
                           partners=partners_list(info["partner_type"]),
                           banks=journals_for(list(branches), ["bank"]))


@bp.route("/view/<int:cid>")
@login_required
def view(cid):
    c = get_cheque(cid)
    branch = q("SELECT * FROM branches WHERE id = ?", (c["branch_id"],), one=True)
    pay = q("SELECT * FROM payments WHERE id = ?", (c["payment_id"],), one=True)
    if request.args.get("export"):
        from .. import currency_decimals
        from ..exports import Report, respond
        from ..i18n import nm
        received = c["direction"] == "received"
        rep = Report("Cheque Receipt" if received else "Cheque Issue Voucher",
                     decimals=currency_decimals(branch["currency"]), signatures=True)
        rep.details = [("Number", c["number"]), ("Cheque no.", c["cheque_no"]),
                       ("Received from" if received else "Paid to", nm({"name_en": c["pname_en"], "name_ar": c["pname_ar"]})),
                       ("Bank", c["bank_name"] or "—"), ("Date received" if received else "Date issued", c["issue_date"]),
                       ("Cheque date", c["cheque_date"]), ("Document", c["inv_number"] or "—"), ("Status", t(STATES[c["state"]]))]
        rep.column(t("Description"), width=3).column(t("Amount"), "num")
        rep.row([f"{t('Cheque')} {c['cheque_no']}" + (f" · {c['inv_number']}" if c["inv_number"] else ""), c["amount"]])
        rep.totals = [(f"{t('Amount')} ({branch['currency']})", c["amount"], True)]
        if c["bounce_reason"]:
            rep.notes.append(f"{t('Reason')}: {c['bounce_reason']}")
        out = respond(rep, c["number"].replace("/", "-"))
        if out:
            return out
    return render_template("cheques/view.html", c=c, branch=branch, pay=pay, info=DIRECTIONS[c["direction"]],
                           states=STATES, banks=journals_for([c["branch_id"]], ["bank"]),
                           today=date.today().isoformat())


@bp.route("/view/<int:cid>/<action>", methods=["POST"])
@write_required
def action(cid, action):
    c = get_cheque(cid)
    f = request.form
    try:
        d = f.get("date") or date.today().isoformat()
        if action == "deposit":
            deposit(cid, int(f["bank_journal_id"]), user_id())
        elif action == "clear":
            clear(cid, d, f.get("bank_journal_id"), user_id())
        elif action == "bounce" and c["direction"] == "received":
            bounce(cid, d, f.get("reason", ""), user_id())
        elif action == "cancel":
            bounce(cid, d, f.get("reason", ""), user_id(), state="cancelled")
        else:
            raise AccountingError(t("This action is not allowed in the current state."))
        commit()
        flash(t("Done."), "success")
    except (AccountingError, ValueError, KeyError) as e:
        get_db().rollback()
        flash(str(e), "error")
    return redirect(url_for("cheques.view", cid=cid))
