1 files changed, 86 insertions, 0 deletions
diff --git a/python/report_ops/fcm.py b/python/report_ops/fcm.py
new file mode 100644
index 00000000..6bff38ff
--- /dev/null
+++ b/python/report_ops/fcm.py
@@ -0,0 +1,86 @@
+from .misc import _recipients
+import datetime
+from serenitas.utils.exchange import ExchangeMessage
+from tabulate import tabulate
+from exchangelib import HTMLBody
+from dataclasses import dataclass
+
+
+@dataclass
+class BamlFcmNotify:
+    account: str
+    curr: str
+    totbal: float
+    homecurrency: str
+    fxrate: float
+    convtotbal: float
+    buysell: bool
+    valuedate: datetime.date
+
+    @classmethod
+    def from_dict(cls, d):
+        _fcm_alias = {"V0NSCLMSPT": "6MZ20049"}
+        if d["sell_currency"] == "USD":
+            key1, key2 = "buy", "sell"
+        else:
+            key1, key2 = "sell", "buy"
+        return cls(
+            account=_fcm_alias.get(d["cash_account"], d["cash_account"]),
+            curr=d[f"{key1}_currency"],
+            totbal=d[f"{key1}_amount"],
+            homecurrency=d[f"{key2}_currency"],
+            fxrate=d["spot_rate"],
+            convtotbal=d[f"{key2}_amount"],
+            buysell="Buy" if d["sell_currency"] == "USD" else "Sell",
+            valuedate=d["settle_date"],
+        )
+
+    def to_list(self):
+        return list(self.__dict__.values())
+
+    def to_tabulate(self):
+        line = self.to_list()
+        num_format = [("{0:,.2f}", 2), ("{0:.5f}", 4), ("{0:,.2f}", 5)]
+        for f, i in num_format:
+            line[i] = f.format(line[i])
+        return tabulate(
+            [line],
+            headers=[
+                "account",
+                "curr",
+                "TotBal",
+                "HomeCurrency",
+                "fxRate",
+                "convTotBal",
+                "BuySell",
+                "Value Date",
+            ],
+            tablefmt="unsafehtml",
+        )
+
+    def email_fcm(self, trade_date):
+        em = ExchangeMessage()
+        em.send_email(
+            f"FX Details: {self.account} Trade Date: {trade_date}",
+            HTMLBody(
+                f"""
+<html>
+  <head>
+    <style>
+      table, th, td {{ border: 1px solid black;  border-collapse: collapse;}}
+      th, td {{ padding: 5px; }}
+    </style>
+  </head>
+  <body>
+  Hello,<br><br>Please see below details for an FX Spot Trade we did with the desk today for account {self.account} Please let me know if you need more information.<br><br>{self.to_tabulate()}
+  </body>
+</html>"""
+            ),
+            to_recipients=_recipients["BAML_FCM"],
+            cc_recipients=_recipients["NYOPS"],
+        )
+
+    @classmethod
+    def process(cls, trade_date, d):
+        trade = cls.from_dict(d)
+        trade.email_fcm(trade_date)