Warn Slack about duplicate invoices before they're paid

from datetime import date, timedelta
from clickruntime import on_event, credentials, http, notify
SUPABASE = "https://your-project.supabase.co/rest/v1"

def sb(method, path, **kw):
    key = credentials.secret("SUPABASE_KEY")
    r = http.request(method, f"{SUPABASE}/{path}", **kw, headers={"apikey": key, "Authorization": f"Bearer {key}", "Prefer": "return=representation,resolution=merge-duplicates"})
    return r.raise_for_status() or (r.json() if r.content else None)

@on_event
def handle(event):
    inv = event.json or {}
    vendor, amount, number = inv["vendor"].strip(), round(float(inv["amount"]), 2), inv.get("number", "")
    since = date.today() - timedelta(days=60)
    same_number = sb("GET", "invoices", params={"vendor": f"ilike.{vendor}", "number": f"eq.{number}"}) if number else []
    same_amount = sb("GET", "invoices", params={"vendor": f"ilike.{vendor}", "amount": f"eq.{amount}", "received_on": f"gte.{since}"})
    match = (same_number or same_amount or [None])[0]
    sb("POST", "invoices", json={"vendor": vendor, "amount": amount, "number": number, "received_on": str(date.today()),
                                 "status": "possible duplicate" if match else "new", "event_id": event.event_id})
    if match:
        notify.slack(f":warning: Possible duplicate: {vendor} {number} for {amount:,.2f} matches invoice {match['number']} "
                     f"received {match['received_on']}", channel="#finance")
    return {"duplicate": bool(match)}