Take WhatsApp orders into Supabase

from clickruntime import on_event, credentials, http, ai

SCHEMA = {"type": "object", "properties": {"items": {"type": "array", "items": {"type": "object",
          "properties": {"name": {"type": "string"}, "qty": {"type": "integer"}}}}}, "required": ["items"]}
SUPABASE_URL = "https://your-project.supabase.co"
sb = lambda: {"apikey": credentials.secret("SUPABASE_SECRET_KEY"), "Authorization": f"Bearer {credentials.secret('SUPABASE_SECRET_KEY')}"}
WA = "https://graph.facebook.com/v20.0/your-phone-number-id/messages"

def wa(to, text):
    http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"},
              json={"messaging_product": "whatsapp", "to": to, "type": "text", "text": {"body": text}}).raise_for_status()
def incoming(event):
    changes = [c for e in (event.json or {}).get("entry", []) for c in e.get("changes", [])]
    return [(m["from"], m["text"]["body"]) for c in changes for m in c["value"].get("messages", []) if m.get("type") == "text"]

@on_event
def handle(event):
    menu = {m["name"].lower(): m["price"] for m in http.get(f"{SUPABASE_URL}/rest/v1/menu", headers=sb(), params={"select": "name,price"}).json()}
    for phone, text in incoming(event):
        items = ai.generate(text[:1500], system=f"Extract ordered items, matching these names where possible: {', '.join(menu)}",
                            json_schema=SCHEMA, max_output_tokens=300).json["items"]
        lines, total, missing = [], 0, []
        for i in items:
            price = menu.get(i["name"].lower())
            if price is None:
                missing.append(i["name"]); continue
            total += price * i["qty"]; lines.append(f"{i['qty']} x {i['name']} = {price * i['qty']:.2f}")
        http.post(f"{SUPABASE_URL}/rest/v1/orders", headers=sb(), json={"phone": phone, "items": items, "total": total, "message": text})
        note = f"\nNot on our menu: {', '.join(missing)}" if missing else ""
        wa(phone, "Thanks! Your order:\n" + "\n".join(lines) + f"\nTotal: {total:.2f}{note}")
    return {"ok": True}