See your top Square items and how today compares

from collections import Counter
from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, state, notify

API = "https://connect.squareup.com/v2"

def square_headers():
    return {"Authorization": f"Bearer {credentials.secret('SQUARE_ACCESS_TOKEN')}", "Square-Version": "2024-10-17"}

@on_trigger
def run(event):
    h, today = square_headers(), date.today()
    locations = [l["id"] for l in http.get(f"{API}/locations", headers=h).json()["locations"]]
    orders = http.post(f"{API}/orders/search", headers=h, json={"location_ids": locations, "query": {"filter": {
        "state_filter": {"states": ["COMPLETED"]},
        "date_time_filter": {"closed_at": {"start_at": f"{today}T00:00:00Z", "end_at": f"{today}T23:59:59Z"}}}}}
    ).json().get("orders", [])
    qty = Counter()
    for o in orders:
        for item in o.get("line_items", []):
            qty[item["name"]] += float(item["quantity"])
    total = sum(o["total_money"]["amount"] for o in orders) / 100
    totals = state.get("daily_totals") or {}
    last_week = totals.get((today - timedelta(days=7)).isoformat())
    totals[today.isoformat()] = total
    state.set("daily_totals", dict(sorted(totals.items())[-14:]))
    top = "\n".join(f"{i + 1}. {name}: {q:g}" for i, (name, q) in enumerate(qty.most_common(3)))
    vs = f" ({(total - last_week) / last_week:+.0%} vs last {today:%A})" if last_week else ""
    notify.email_me(f"Square today: ${total:,.2f}{vs}", f"Top items:\n{top}\n\nSales: ${total:,.2f}{vs}")
    return {"total": total}