from datetime import date

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

from .. import allowed_branch_ids, check_branch, login_required, write_required
from ..db import commit, placeholders, q
from ..i18n import t
from ..ledger import AccountingError, create_transfer, rate_on
from ..money import to_int
from .common import branch_map, journals_for, user_id

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


@bp.route("/")
@login_required
def index():
    ids = allowed_branch_ids()
    rows = []
    if ids:
        rows = q(f"""
            SELECT m.transfer_ref, m.date, m.ref, m.state,
                   MAX(CASE WHEN ml.credit > 0 AND a.intercompany = 0 THEN m.branch_id END) AS from_branch,
                   MAX(CASE WHEN ml.debit > 0 AND a.intercompany = 0 THEN m.branch_id END) AS to_branch,
                   MAX(CASE WHEN ml.credit > 0 AND a.intercompany = 0 THEN ml.credit END) AS amount_from,
                   MAX(CASE WHEN ml.debit > 0 AND a.intercompany = 0 THEN ml.debit END) AS amount_to,
                   MIN(m.id) AS move_id
            FROM moves m JOIN move_lines ml ON ml.move_id = m.id JOIN accounts a ON a.id = ml.account_id
            WHERE m.move_type = 'transfer' AND m.branch_id IN ({placeholders(ids)})
            GROUP BY m.transfer_ref ORDER BY m.date DESC, MIN(m.id) DESC""", ids)
    return render_template("transfers/list.html", rows=rows, branches=branch_map())


@bp.route("/new", methods=["GET", "POST"])
@write_required
def form():
    branches = branch_map()
    d = {"date": date.today().isoformat()}
    if request.method == "POST":
        fm = request.form
        d.update(fm.items())
        try:
            data = {
                "date": fm["date"], "ref": fm.get("ref"),
                "from_branch": check_branch(fm["from_branch"]), "from_journal": int(fm["from_journal"]),
                "to_branch": check_branch(fm["to_branch"]), "to_journal": int(fm["to_journal"]),
                "amount_from": to_int(fm["amount_from"]),
                "amount_to": to_int(fm.get("amount_to") or fm["amount_from"]),
            }
            create_transfer(data, user_id())
            commit()
            flash(t("Transfer posted in both branches."), "success")
            return redirect(url_for("transfers.index"))
        except (AccountingError, ValueError) as e:
            from ..db import get_db
            get_db().rollback()
            flash(str(e), "error")
    rates = {}
    for b in branches.values():
        try:
            rates[b["currency"]] = rate_on(b["currency"], d["date"])
        except AccountingError:
            rates[b["currency"]] = None
    return render_template("transfers/form.html", d=d, branches=branches, rates=rates,
                           journals=journals_for(list(branches), ["bank", "cash"]))
