[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","CoastalJewelMahj","name","mahj-theory-dashboard","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_18":55},"id","2b759f23-e6e0-447f-910f-00f30542e885","main.ts","fileId","2d62612e-9cb0-11f1-a670-1607ee4eb77e","parentId","branchId","b31f3eb0-39d9-4656-827e-a8002fb2cc22","branchVersion",46,"latest",true,"createdAt",["D",1788556205809],45,"fileType","http","content","// Mahj Theory Collective — Live Signup Dashboard\n// Deploy as an HTTP val on val.town\n// Set TICKET_TAILOR_API_KEY in your Val Town environment variables\n\nconst API_KEY = Deno.env.get(\"TICKET_TAILOR_API_KEY\") ?? \"\";\nconst LOCATION_FILTER = \"mahj theory collective\";\n\ninterface TicketType {\n id: string;\n name: string;\n quantity: number | null; // min-per-order style number, NOT capacity\n quantity_issued: number; // tickets actually issued/sold\n quantity_remaining: number | null; // NOT returned by this API (undefined); not capacity\n quantity_held: number; // tickets currently held/reserved (in carts)\n quantity_total: number; // THE total allocated slots (true capacity, e.g. 8)\n price: number;\n status: string;\n}\n\ninterface EventTime {\n date: number; // Unix timestamp (always present)\n date_formatted?: string; // may or may not be returned\n time?: string; // may or may not be returned\n timezone?: string;\n}\n\ninterface Event {\n id: string;\n name: string;\n status: string;\n description: string;\n start: EventTime;\n end: EventTime;\n venue: { name: string; formatted_address?: string };\n ticket_types: TicketType[];\n total_issued_tickets: number;\n total_orders: number;\n currency: string;\n url: string;\n}\n\n/** Format a Unix timestamp (seconds) into a human-readable date string. */\nfunction fmtDate(ts: number, tz?: string): string {\n try {\n return new Date(ts * 1000).toLocaleDateString(\"en-US\", {\n weekday: \"short\",\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n ...(tz ? { timeZone: tz } : {}),\n });\n } catch {\n return new Date(ts * 1000).toLocaleDateString(\"en-US\", {\n weekday: \"short\",\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n });\n }\n}\n\n/** Format a Unix timestamp (seconds) into a human-readable time string. */\nfunction fmtTime(ts: number, tz?: string): string {\n try {\n return new Date(ts * 1000).toLocaleTimeString(\"en-US\", {\n hour: \"numeric\",\n minute: \"2-digit\",\n hour12: true,\n ...(tz ? { timeZone: tz } : {}),\n });\n } catch {\n return new Date(ts * 1000).toLocaleTimeString(\"en-US\", {\n hour: \"numeric\",\n minute: \"2-digit\",\n hour12: true,\n });\n }\n}\n\n/**\n * Convert a 24-hour \"HH:MM\" string from the API into \"h:MM AM/PM\".\n * Falls back to the original string if it can't be parsed.\n */\nfunction parse24Time(t: string): string {\n const m = t.match(/^(\\d{1,2}):(\\d{2})$/);\n if (!m) return t;\n let h = parseInt(m[1], 10);\n const min = m[2];\n const ampm = h >= 12 ? \"PM\" : \"AM\";\n h = h % 12 || 12;\n return min === \"00\" ? `${h} ${ampm}` : `${h}:${min} ${ampm}`;\n}\n\n/* Ticket Tailor quirk: `start.date`/`end.date` are date *strings* (\"2026-07-15\"),\n * while the true Unix timestamp lives in `start.unix` (and `iso` is a full string).\n * These helpers normalize so the rest of the code always works with a Unix number. */\n\n/** Resolve a numeric Unix timestamp (seconds) from a Ticket Tailor EventTime. */\nfunction unixTs(t: EventTime): number | null {\n const u = (t as unknown as { unix?: unknown }).unix;\n if (typeof u === \"number\" && Number.isFinite(u)) return u;\n if (typeof t.date === \"number\" && Number.isFinite(t.date)) return t.date;\n const iso = (t as unknown as { iso?: unknown }).iso;\n if (typeof iso === \"string\" && !Number.isNaN(Date.parse(iso))) {\n return Date.parse(iso) / 1000;\n }\n return null;\n}\n\n/** Resolve the display time: prefer API's time string (converted), fall back to fmtTime. */\nfunction displayTime(t: EventTime): string {\n if (t.time) return parse24Time(t.time);\n const ts = unixTs(t);\n if (ts !== null) return fmtTime(ts, t.timezone);\n return \"\";\n}\n\n/** Resolve the display date, falling back to the API's pre-formatted string if any. */\nfunction displayDate(t: EventTime): string {\n const ts = unixTs(t);\n\n if (ts !== null) return fmtDate(ts, t.timezone);\n const formatted = (t as unknown as { formatted?: string }).formatted;\n return typeof formatted === \"string\" ? formatted : \"\";\n}\n\n/** Whether the start time has anything usable to render (used for the \"– end\" suffix). */\nfunction hasStart(t: EventTime): boolean {\n return !!t.time || unixTs(t) !== null;\n}\n\nasync function fetchAllEvents(): Promise {\n const all: Event[] = [];\n let url: string | null =\n \"https://api.tickettailor.com/v1/events?limit=100&status=all\";\n\n while (url) {\n const res = await fetch(url, {\n headers: {\n Authorization: \"Basic \" + btoa(API_KEY + \":\"),\n Accept: \"application/json\",\n },\n });\n\n if (!res.ok) {\n throw new Error(\n `Ticket Tailor API error: ${res.status} ${await res.text()}`,\n );\n }\n\n const json = await res.json();\n all.push(...(json.data ?? []));\n\n // Pagination: Ticket Tailor uses cursor-based pagination\n const next = json.links?.next ?? null;\n url = next;\n }\n\n return all;\n}\n\nfunction matchesLocation(event: Event): boolean {\n const venueName = (event.venue?.name ?? \"\").toLowerCase();\n const venueAddr = (event.venue?.formatted_address ?? \"\").toLowerCase();\n return venueName.includes(LOCATION_FILTER) ||\n venueAddr.includes(LOCATION_FILTER);\n}\n\n/**\n * Whether an event is an \"interest list\" (a way to collect interest/signups rather than\n * sell tickets — e.g. \"Mahj 101 Interest List\", \"Locals Interest List\"). These are\n * identified by the event name, which always contains \"interest list\". We drop them\n * entirely from the dashboard. (Confirmed against the API: interest-list events have a\n * $0 \"Interest List Spot\" ticket type with a huge 999-slot capacity, or are drafts with\n * no ticket types.)\n */\nfunction isInterestList(event: Event): boolean {\n return /interest list/i.test(event.name);\n}\n\n/**\n * Whether an event has already ended. Uses the end time when available; if the event\n * has no usable end time, falls back to the start time. If neither resolves, the event\n * is kept (we can't prove it's over).\n */\nfunction hasEnded(event: Event, nowTs: number): boolean {\n const endTs = unixTs(event.end);\n const refTs = endTs ?? unixTs(event.start);\n if (refTs === null) return false;\n return refTs <= nowTs;\n}\n\nfunction formatCurrency(amount: number, currency: string): string {\n if (amount === 0) return \"Free\";\n return new Intl.NumberFormat(\"en-US\", {\n style: \"currency\",\n currency: currency || \"USD\",\n minimumFractionDigits: 0,\n }).format(amount / 100);\n}\n\nfunction statusBadge(status: string): { label: string; color: string } {\n switch (status) {\n case \"published\":\n return { label: \"Live\", color: \"#22c55e\" };\n case \"draft\":\n return { label: \"Draft\", color: \"#f59e0b\" };\n case \"cancelled\":\n return { label: \"Cancelled\", color: \"#ef4444\" };\n case \"completed\":\n return { label: \"Completed\", color: \"#6b7280\" };\n default:\n return { label: status, color: \"#6b7280\" };\n }\n}\n\n/** Extract the instructor's first name (Jen or Kelly) from the event description. */\nfunction extractInstructor(description: string): string | null {\n // Prefer the name that follows \"taught by\" (e.g. \"taught by Jen\")\n const taughtBy = description.match(/taught by[^A-Za-z]*(Jen|Kelly)/i);\n if (taughtBy) return taughtBy[1];\n // Fall back to any whole-word mention of either instructor\n const any = description.match(/\\b(Jen|Kelly)\\b/i);\n return any ? any[1] : null;\n}\n\nfunction renderEventCard(event: Event): string {\n const badge = statusBadge(event.status);\n const instructor = extractInstructor(event.description);\n // Capacity per ticket type = `quantity_total` (the API's total allocated slots, e.g. 8).\n // Confirmed from the raw response: e.g. tt_6500742 -> quantity:2, quantity_held:0,\n // quantity_in_baskets:0, quantity_issued:6, quantity_total:8. `quantity_total` is the\n // only field that equals the true capacity; `quantity_remaining` is NOT returned at all,\n // and `quantity`/`quantity_held` are subcounts, not totals.\n const ticketCapacity = (t: TicketType): number =>\n Number.isFinite(t.quantity_total) ? t.quantity_total : 0;\n const totalCapacity = event.ticket_types.reduce(\n (sum, t) => sum + ticketCapacity(t),\n 0,\n );\n const hasCapacity = event.ticket_types.some((t) =>\n Number.isFinite(t.quantity_total)\n );\n // Seats left = true capacity minus tickets actually issued. (We could also subtract\n // tickets held in carts, but \"remaining\" here means genuinely available.)\n const seatsRemaining = hasCapacity\n ? totalCapacity - event.total_issued_tickets\n : null;\n const pct = hasCapacity && totalCapacity > 0\n ? Math.min(\n 100,\n Math.round((event.total_issued_tickets / totalCapacity) * 100),\n )\n : null;\n\n const ticketRows = event.ticket_types\n .map(\n (t) => `\n \n ${t.name}\n ${t.quantity_issued}\n ${\n ticketCapacity(t)\n }\n ${\n formatCurrency(t.price, event.currency)\n }\n `,\n )\n .join(\"\");\n\n const barColor = pct !== null\n ? pct >= 90 ? \"#ef4444\" : pct >= 70 ? \"#f59e0b\" : \"#7c3aed\"\n : \"#7c3aed\";\n\n return `\n

\n \n

${event.name}

\n \n ${badge.label}\n \n

\n \n ${displayDate(event.start)}\n

\n \n ${displayTime(event.start)}${\n hasStart(event.end) ? \" – \" + displayTime(event.end) : \"\"\n }\n

\n ${\n event.venue?.name\n ? `

\n \n ${event.venue.name}\n

`\n : \"\"\n }\n ${\n instructor\n ? `

\n \n Instructor: ${instructor}\n

`\n : \"\"\n }\n

\n\n \n

${event.total_issued_tickets}

Signed Up

${event.total_orders}

Orders

\n ${\n hasCapacity\n ? `

= 90\n ? \"ef4444\"\n : pct !== null && pct >= 70\n ? \"f59e0b\"\n : \"22c55e\"\n };line-height:1;\">${pct}%

Full

`\n : \"\"\n }\n ${\n hasCapacity\n ? `

${seatsRemaining}

Seats Left

`\n : \"\"\n }\n

\n\n ${\n hasCapacity && pct !== null\n ? `\n \n

\n ${event.total_issued_tickets} of ${totalCapacity} spots filled\n ${\n Math.max(0, totalCapacity - event.total_issued_tickets)\n } remaining${\n totalCapacity - event.total_issued_tickets < 0 ? \" (oversold)\" : \"\"\n }\n

`\n : \"\"\n }\n\n \n ${\n event.ticket_types.length > 0\n ? `\n

Ticket Breakdown

\n \n \n \n \n \n \n \n \n \n ${ticketRows}\n

Type	Sold	Cap.	Price

`\n : \"\"\n }\n\n \n

\n \n View on Ticket Tailor\n \n \n

`;\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n\n // Debug endpoint: visit /debug to see raw API response for the first event\n if (url.pathname.endsWith(\"/debug\")) {\n try {\n const res = await fetch(\n \"https://api.tickettailor.com/v1/events?limit=2\",\n {\n headers: {\n Authorization: \"Basic \" + btoa(API_KEY + \":\"),\n Accept: \"application/json\",\n },\n },\n );\n const json = await res.json();\n return Response.json(json, {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (e) {\n return new Response(String(e), { status: 500 });\n }\n }\n\n // CSV contact-list export — /contacts.csv\n if (url.pathname.endsWith(\"/contacts.csv\")) {\n try {\n const allEvts = await fetchAllEvents();\n const csvEvents = allEvts.filter(matchesLocation).filter((e) =>\n !isInterestList(e)\n );\n const esc = (s: unknown) => `\"${String(s ?? \"\").replace(/\"/g, '\"\"')}\"`;\n const rows: string[] = [\n \"Event Name,Event Date,Attendee Name,Attendee Email,Attendee Phone\",\n ];\n for (const evt of csvEvents) {\n const evtName = evt.name ?? \"\";\n const evtDate = displayDate(evt.start);\n const base = \"https://api.tickettailor.com/v1/orders?event_id=\" +\n evt.id +\n \"&limit=100\";\n let tUrl: string | null = base;\n while (tUrl) {\n const tres = await fetch(tUrl, {\n headers: {\n Authorization: \"Basic \" + btoa(API_KEY + \":\"),\n Accept: \"application/json\",\n },\n });\n const tj = await tres.json() as any;\n for (const t of (tj.data ?? [])) {\n const bd = t.buyer_details ?? {};\n const name = bd.name ??\n (`${bd.first_name ?? \"\"} ${bd.last_name ?? \"\"}`).trim();\n const email = bd.email ?? \"\";\n const phone = bd.phone ?? \"\";\n rows.push(\n [esc(evtName), esc(evtDate), esc(name), esc(email), esc(phone)]\n .join(\",\"),\n );\n }\n tUrl = tj.links?.next ?? null;\n }\n }\n return new Response(rows.join(\"\\r\\n\"), {\n headers: {\n \"Content-Type\": \"text/csv; charset=utf-8\",\n \"Content-Disposition\":\n 'attachment; filename=\"mahj-theory-contacts.csv\"',\n },\n });\n } catch (e) {\n return new Response(String(e), { status: 500 });\n }\n }\n\n // Temporary debug: see raw orders API response\n if (url.pathname.endsWith(\"/debug-tickets\")) {\n const eventId = url.searchParams.get(\"event_id\") ?? \"ev_8437039\";\n const dres = await fetch(\n \"https://api.tickettailor.com/v1/orders?event_id=\" + eventId +\n \"&limit=5\",\n {\n headers: {\n Authorization: \"Basic \" + btoa(API_KEY + \":\"),\n Accept: \"application/json\",\n },\n },\n );\n return Response.json(await dres.json());\n }\n\n const now = new Date().toLocaleString(\"en-US\", {\n timeZone: \"America/Los_Angeles\",\n dateStyle: \"long\",\n timeStyle: \"short\",\n });\n\n let events: Event[] = [];\n let errorMsg = \"\";\n\n try {\n if (!API_KEY) {\n throw new Error(\"TICKET_TAILOR_API_KEY environment variable is not set.\");\n }\n const all = await fetchAllEvents();\n const nowTs = Date.now() / 1000;\n // Hide events that have already ended (by end time, falling back to start time),\n // plus drop interest-list events entirely (name contains \"interest list\").\n events = all.filter((e) =>\n !isInterestList(e) && matchesLocation(e) && !hasEnded(e, nowTs)\n );\n // Sort upcoming events by start date (soonest first).\n events.sort((a, b) => (unixTs(a.start) ?? 0) - (unixTs(b.start) ?? 0));\n } catch (e: unknown) {\n errorMsg = e instanceof Error ? e.message : String(e);\n }\n\n // All events in the list have not yet ended (we filtered out ended ones above), so the\n // \"Upcoming\" and \"Total Events\" counts coincide. Kept as a separate value for clarity.\n const upcomingCount =\n events.filter((e) => !hasEnded(e, Date.now() / 1000)).length;\n const totalSignups = events.reduce((s, e) => s + e.total_issued_tickets, 0);\n\n const cards = errorMsg\n ? `

\n Error loading events: ${errorMsg}\n

`\n : events.length === 0\n ? `

\n No events found matching \"${LOCATION_FILTER}\".\n

`\n : events.map(renderEventCard).join(\"\");\n\n const html = `\n\n\n \n \n Mahj Theory Collective — Event Dashboard\n \n\n\n \n

\n 🀄\n

Mahj Theory Collective

Live signup dashboard — refreshes every 60s

\n\n \n ${\n !errorMsg\n ? `

${events.length}

Total Events

${upcomingCount}

Upcoming

${totalSignups}

Total Signups

`\n : \"\"\n }\n

\n \n

\n \n Download Contact List (CSV)\n \n

\n\n\n \n

\n ${cards}\n

\n\n \n

\n Last updated: ${now} PT · \n view source\n

\n\n \n \n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_58":59,"_18":60},["D",1788556205809],"children",[],[35],"34f8e9e6-c202-4aa7-b974-a77c5472b452",["D",1787241591380],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Live signup dashboard for Mahj Theory Collective events","imageUrl","userId","bc241e50-fe61-4f30-8990-c1f7306daafc","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a01fb9-fa62-76fe-a7c2-0e598adc69ac","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":19},"org",{"_11":12,"_109":19,"_110":19,"_71":72,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":149,"_96":150,"_98":151,"_100":53},[145],"files",[145],"counts",{"_135":78,"_136":137,"_138":78,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_18":134},[35],"pulls","branches",1,"forks",{"_142":137,"_144":78},"connections",{"_142":78,"_143":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":14,"_58":146,"_18":147},[],[35],["D",1787241591380],{"_11":12,"_114":19},{"_11":12,"_109":19,"_110":19,"_71":72,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":78,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code