from serenitas.analytics.dates import prev_business_day
from serenitas.utils.db import dbconn
from serenitas.utils.exchange import ExchangeMessage
import datetime
import logging

_recipients = {
    "ISOSEL": (
        "simon.oreilly@innocap.com",
        "margincalls@innocapglobal.com",
    ),
}


def _formatting(payment_values):
    if not payment_values:
        return None
    else:
        return "\n".join(
            f"\t* {settle_date}: {amount:,.2f} {currency}"
            for settle_date, (amount, currency) in payment_values.items()
        )


def payment_values(ped, conn, fund):
    sql_str = "SELECT settle_date, currency, sum(payment_amount) as payment_amount FROM payment_settlements ps2 WHERE fund=%s AND asset_class='bond' AND %s < (settle_date + INTERVAL '5' DAY) group by settle_date, currency;"
    with conn.cursor() as c:
        c.execute(sql_str, (fund, ped))
        return _formatting(
            {row.settle_date: (row.payment_amount, row.currency) for row in c}
        )


if __name__ == "__main__":
    import argparse

    parser = argparse.ArgumentParser()
    parser.add_argument(
        "date",
        nargs="?",
        type=datetime.date.fromisoformat,
        default=datetime.date.today(),
        help="working date",
    )
    args = parser.parse_args()
    logger = logging.getLogger(__name__)
    conn = dbconn("dawndb")
    em = ExchangeMessage()
    for fund in ("ISOSEL",):
        if vals := payment_values(args.date, conn, fund):
            em.send_email(
                f"Payment Settlements Bond NT: {fund} {args.date}",
                "Good morning, \n\nWe have the following amounts settling in the next few days:\n\n"
                + vals,
                to_recipients=_recipients[fund],
                cc_recipients=("Selene-Ops@lmcg.com",),
            )