Post members who've stopped checking in to Slack each morning

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, state, notify, ai
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_trigger
def run(event):
    cutoff = date.today() - timedelta(days=14)
    members = sb("GET", f"members?status=eq.active&last_seen=lt.{cutoff}&select=id,name,last_seen&order=last_seen.asc")
    before = set(state.get("ids") or [])
    lines = [f"{'🆕 ' if m['id'] not in before else ''}{m['name']} – last seen {m['last_seen'][:10]}" for m in members[:20]]
    text = f"{len(members)} members haven't checked in since {cutoff} ({sum(m['id'] not in before for m in members)} new)\n" + "\n".join(lines)
    if len(members) > 20:
        text += f"\n…and {len(members) - 20} more"
    try:
        text += "\n" + ai.generate(f"One sentence on what stands out:\n{text}", max_output_tokens=60).text
    except ai.AIError:
        pass
    notify.slack(text, channel="#retention")
    state.set("ids", [m["id"] for m in members])
    return {"inactive": len(members)}