Post Stripe revenue reports in Slack

import stripe
from clickruntime import on_trigger, credentials, notify, state
from datetime import datetime, timedelta, timezone

@on_trigger
def run(event):
    stripe.api_key = credentials.secret("STRIPE_API_KEY")
    end = datetime.now(timezone.utc).replace(hour=0, minute=0, second=0, microsecond=0)
    period = {"gte": int((end - timedelta(days=1)).timestamp()), "lt": int(end.timestamp())}
    totals = {}
    for tx in stripe.BalanceTransaction.list(created=period, limit=100).auto_paging_iter():
        if tx.type in ("charge", "payment", "refund", "payment_refund"):
            t = totals.setdefault(tx.currency.upper(), {"sales": 0, "refunds": 0})
            t["refunds" if "refund" in tx.type else "sales"] += abs(tx.amount) / 100
    previous = state.get("previous") or {}
    lines = []
    for cur, t in sorted(totals.items()):
        net = t["sales"] - t["refunds"]
        before = previous.get(cur)
        change = f" ({net - before:+,.2f} vs day before)" if before is not None else ""
        lines.append(f"{cur}: sales {t['sales']:,.2f}, refunds {t['refunds']:,.2f}, net {net:,.2f}{change}")
    notify.slack("Stripe revenue yesterday\n" + ("\n".join(lines) or "No payments"), channel="#finance")
    state.set("previous", {c: t["sales"] - t["refunds"] for c, t in totals.items()})
    return {"currencies": len(totals)}