Log failed store orders in Airtable and alert Slack

import time
from clickruntime import on_event, credentials, http, notify, state

TABLE = "https://api.airtable.com/v0/your-base-id/Failed%20orders"

@on_event
def handle(event):
    o = event.json or {}
    if o.get("status") != "failed":
        return {"skipped": True}
    h = {"Authorization": f"Bearer {credentials.secret('AIRTABLE_API_KEY')}"}
    http.post(TABLE, headers=h, json={"fields": {"Order": str(o["id"]), "Total": float(o.get("total") or 0),
              "Email": o.get("billing", {}).get("email"), "Method": o.get("payment_method_title"),
              "Time": o.get("date_modified_gmt")}})
    now = time.time()
    recent = [t for t in (state.get("recent") or []) if now - t < 3600] + [now]
    state.set("recent", recent)
    msg = f"❌ Order #{o['id']} failed ({o.get('currency', '')} {o.get('total')}, {o.get('payment_method_title')})"
    if len(recent) >= 5:
        msg += f"\n⚠️ {len(recent)} failed orders in the last hour, check the checkout."
    notify.slack(msg, channel="#ops")
    return {"logged": o["id"]}