[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","amandaturcotte","name","sy27-dashboards","path","main.tsx","project",{"_22":46,"_11":12,"_33":47,"_48":-5,"_49":42,"_50":51,"_52":51,"_53":54,"_55":-5,"_56":57,"_58":25,"_59":32,"_60":-5,"_61":-5,"_62":36,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_13":45},"permalink","https://www.val.town/x/amandaturcotte/sy27-dashboards/code/main.tsx","extension","id","9ddaf4cd-0427-4bad-b354-3ad5fa8dec82","fileId","01a0a0e6-ca6a-7155-8c8c-e914e39c5f4f","parentId","branchId","5d8f69bf-1ba1-4ed5-92f2-5c26065c0e56","branchVersion",1,"latest",true,"createdAt",["D",1789405874619],"version",0,"fileType","http","content","/**\n * TerraClear dashboards — access gate + index.\n *\n * TO ADD A DASHBOARD: publish its gzipped HTML to a blob named `gz:`, then add\n * one line to DASHBOARDS below. Routing, login, per-dashboard access, the index page\n * and the audit log are all derived from that table — nothing else to touch.\n *\n * PREVIEW / STAGING (permanent — do not remove): `preview-amanda` and `preview-share`\n * are owner-only staging copies of the two live dashboards, served from\n * `gz:preview:amanda` / `gz:preview:share`. Any session that wants to show Amanda a\n * dashboard change before it goes live publishes to those blobs instead of the live\n * ones — no code change, no new route, no new val. Preview blobs are deliberately\n * NOT refreshed by the twice-daily job and are NOT watched by the staleness watchdog.\n * Full recipe: project doc `claude/sy27-build/PREVIEW_STAGING.md`.\n *\n * Humans log in with Val Town. Machines (the refresh pipeline) pass ?k=\n * and skip OAuth entirely, so a broken login flow can never block publishing.\n *\n * Dashboard HTML lives in blobs; this file only decides who may see what.\n *\n * redeploy-nudge 2026-09-14 (force HTTP endpoint re-registration after platform 404 outage)\n */\nimport { Hono } from \"npm:hono\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport {\n getOAuthUserData,\n oauthMiddleware,\n} from \"https://esm.town/v/std/oauth/middleware.ts\";\n\ntype Access = \"owner\" | \"team\" | \"list\";\ninterface Dash {\n blob: string;\n label: string;\n note?: string;\n access: Access;\n /** Only for access:\"list\" — specific people, who must still be on an allowed domain. */\n emails?: string[];\n /** Staging copy: owner-only, badged in the index, never touched by the refresh job. */\n preview?: boolean;\n}\n\n/** route key -> dashboard. The owner always sees every entry. */\nconst DASHBOARDS: Record = {\n amanda: {\n blob: \"gz:amanda\",\n label: \"Digital Performance — Amanda\",\n note: \"All modules, including Auto-MQL quality and budget pacing.\",\n access: \"owner\",\n },\n share: {\n blob: \"gz:share\",\n label: \"Digital Performance — Team\",\n note: \"Funnel, channels, spend, acres. Same numbers as the full view.\",\n access: \"team\",\n },\n // ---- PERMANENT STAGING SLOTS (owner-only). See PREVIEW_STAGING.md. ----\n // Publish a candidate build to gz:preview: and it shows up here. Nothing\n // else in this file needs to change, ever, for a new experiment.\n \"preview-amanda\": {\n blob: \"gz:preview:amanda\",\n label: \"PREVIEW — Amanda (staging)\",\n note: \"Candidate build of the full view. Not live. Data may be held.\",\n access: \"owner\",\n preview: true,\n },\n \"preview-share\": {\n blob: \"gz:preview:share\",\n label: \"PREVIEW — Team (staging)\",\n note: \"Candidate build of the team view. Not live. Data may be held.\",\n access: \"owner\",\n preview: true,\n },\n\n // Example of a dashboard for named people only:\n // acres: {\n // blob: \"gz:acres\",\n // label: \"Acres & Delivery\",\n // note: \"Committed vs delivered by cohort.\",\n // access: \"list\",\n // emails: [\"derek.sahr@terraclear.com\", \"laura@spinutech.com\"],\n // },\n};\n\nconst TOKEN = Deno.env.get(\"DASH_TOKEN\") || \"\";\nconst OWNER = (Deno.env.get(\"OWNER_EMAIL\") || \"\").trim().toLowerCase();\nconst ALLOWED_DOMAINS = [\"terraclear.com\", \"spinutech.com\"];\n\nconst blocked = () =>\n new Set(\n (Deno.env.get(\"BLOCKED_EMAILS\") || \"\")\n .toLowerCase()\n .split(\",\")\n .map((s) => s.trim())\n .filter(Boolean),\n );\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS access_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ts TEXT NOT NULL,\n email TEXT,\n username TEXT,\n route TEXT,\n verdict TEXT,\n allowed INTEGER\n)`);\n\n/** owner | team | blocked | off-domain | no-email */\nfunction decide(email: string): string {\n const e = (email || \"\").trim().toLowerCase();\n if (!e) return \"no-email\";\n if (blocked().has(e)) return \"blocked\";\n if (e === OWNER) return \"owner\";\n const domain = e.split(\"@\")[1] || \"\";\n return ALLOWED_DOMAINS.includes(domain) ? \"team\" : \"off-domain\";\n}\n\ninterface Viewer {\n machine: boolean;\n email: string;\n username: string | null;\n verdict: string;\n}\n\n/** Resolve the viewer once: machine token, or an OAuth session. */\nasync function viewer(c: any): Promise {\n if (TOKEN && c.req.query(\"k\") === TOKEN) {\n return { machine: true, email: \"\", username: null, verdict: \"token\" };\n }\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return null;\n const email = session.user.email || \"\";\n return {\n machine: false,\n email,\n username: session.user.username,\n verdict: decide(email),\n };\n}\n\nfunction canSee(key: string, v: Viewer): boolean {\n const d = DASHBOARDS[key];\n if (!d) return false;\n if (v.machine) return true;\n if (v.verdict === \"owner\") return true; // owner sees everything\n if (v.verdict !== \"team\") return false; // must be on an allowed domain\n if (d.access === \"owner\") return false;\n if (d.access === \"team\") return true;\n return (d.emails || []).some((e) => e.toLowerCase() === v.email.toLowerCase());\n}\n\nasync function log(v: Viewer, route: string, allowed: boolean) {\n try {\n await sqlite.execute({\n sql:\n \"INSERT INTO access_log (ts, email, username, route, verdict, allowed) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [\n new Date().toISOString(),\n v.email || null,\n v.username || null,\n route,\n v.verdict,\n allowed ? 1 : 0,\n ],\n });\n } catch (_e) {\n // Never let logging break a page view.\n }\n}\n\nasync function serveGz(key: string): Promise {\n const d = DASHBOARDS[key];\n let res: Response | null = null;\n try {\n res = await blob.get(d.blob);\n } catch (_e) {\n res = null;\n }\n // An empty staging slot is a normal state, not an error — say so plainly instead\n // of throwing, so a preview route is always safe to click.\n if (!res || res.ok === false || !res.body) return missingBlob(key);\n let html: string;\n try {\n html = await new Response(\n res.body.pipeThrough(new DecompressionStream(\"gzip\")),\n ).text();\n } catch (_e) {\n // Present but not valid gzip — a half-finished upload. Same handling as empty.\n return missingBlob(key);\n }\n return new Response(html, {\n status: 200,\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n}\n\nconst esc = (s: string) =>\n String(s ?? \"\").replace(\n /[&<>\"]/g,\n (ch) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" }[ch]!),\n );\n\nconst page = (title: string, body: string) =>\n `\n${esc(title)}\n\n${body}`;\n\n/**\n * Blob has nothing in it. For a staging slot that's expected (nobody has published a\n * candidate yet) — 200 and an explanation. For a live dashboard it's a real fault — 503,\n * so monitoring and a human both notice.\n */\nfunction missingBlob(key: string): Response {\n const d = DASHBOARDS[key];\n if (d.preview) {\n return new Response(\n page(\n \"Nothing staged\",\n `

Nothing staged here yet

${esc(d.label)} · ${esc(d.blob)}

This is a permanent staging slot. It's empty until a session publishes a candidate\nbuild to it — ask for a preview and it will appear here, with a banner across the top\nshowing when it was built and how fresh its data is.

The live dashboards are unaffected by anything that happens on this page.

← Dashboards

`,\n ),\n { status: 200, headers: { \"content-type\": \"text/html; charset=utf-8\" } },\n );\n }\n return new Response(\n page(\n \"Unavailable\",\n `

Dashboard unavailable

${esc(d.label)} · ${esc(d.blob)} is empty or unreadable.

This is a fault, not an access problem — the refresh job has not written this blob.\nCheck the most recent run before trusting anything else on this site.

← Dashboards

`,\n ),\n { status: 503, headers: { \"content-type\": \"text/html; charset=utf-8\" } },\n );\n}\n\nconst signedInFoot = (v: Viewer, extra = \"\") =>\n `

Signed in as ${esc(v.email)}${extra}\n

`;\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// Open health check — no data behind it.\napp.get(\"/health\", (c) => c.text(\"ok\"));\n\nconst denied = (c: any, v: Viewer) =>\n c.html(\n page(\n \"No access\",\n `

No access

You're signed in as ${\n esc(v.email || \"an account with no email address\")\n }${v.verdict === \"blocked\" ? \", which has been blocked\" : \"\"}.

These dashboards are limited to TerraClear and Spinutech accounts. If you have a\nwork email, sign out and sign back in with it.

\n`,\n ),\n 403,\n );\n\n// Index — the one link worth distributing. Also where OAuth lands after login.\napp.get(\"/\", async (c) => {\n const v = await viewer(c);\n if (!v) return c.redirect(\"/auth/login\");\n if (v.machine) return c.text(\"ok\");\n const keys = Object.keys(DASHBOARDS).filter((k) => canSee(k, v));\n await log(v, \"/\", keys.length > 0);\n if (!keys.length) return denied(c, v);\n const cards = keys\n .map(\n (k) =>\n `

${\n esc(DASHBOARDS[k].label)\n }${DASHBOARDS[k].preview ? 'preview' : \"\"}

${\n DASHBOARDS[k].note ? `

${esc(DASHBOARDS[k].note!)}

` : \"\"\n }`,\n )\n .join(\"\");\n const extra = v.verdict === \"owner\"\n ? `Access log`\n : \"\";\n return c.html(\n page(\n \"TerraClear dashboards\",\n `

TerraClear dashboards

${keys.length} view${keys.length === 1 ? \"\" : \"s\"} available to you.

\n${cards}${signedInFoot(v, extra)}`,\n ),\n );\n});\n\n// One route per dashboard, generated from the table.\nfor (const key of Object.keys(DASHBOARDS)) {\n app.get(\"/\" + key, async (c) => {\n const v = await viewer(c);\n if (!v) return c.redirect(\"/auth/login\");\n if (v.machine) return serveGz(key);\n const ok = canSee(key, v);\n await log(v, \"/\" + key, ok);\n if (ok) return serveGz(key);\n // Don't confirm what exists — send them to their own index instead.\n return v.verdict === \"team\" ? c.redirect(\"/\") : denied(c, v);\n });\n}\n\n// Access log — owner only.\napp.get(\"/who\", async (c) => {\n const v = await viewer(c);\n if (!v) return c.redirect(\"/auth/login\");\n // Owner only — deliberately not reachable with the machine token either.\n if (v.verdict !== \"owner\") return c.notFound();\n const { rows } = await sqlite.execute(\n \"SELECT ts, email, username, route, verdict, allowed FROM access_log ORDER BY id DESC LIMIT 200\",\n );\n const body = rows.length\n ? `` +\n rows\n .map(\n (r: any) =>\n `${r.allowed ? \"allowed\" : \"denied · \" + esc(r.verdict)}`,\n )\n .join(\"\") + \"

When (UTC)	Email	Val Town	Route	Result
${esc(String(r.ts).replace(\"T\", \" \").slice(0, 19))}	${\n esc(r.email ?? \"—\")\n }	${esc(r.username ?? \"—\")}	${esc(r.route)}

\"\n : \"

No sign-ins recorded yet.

\";\n return c.html(\n page(\n \"Access log\",\n `

Access log

Most recent 200 human views. Pipeline requests aren't logged.

\n${body}

← Dashboards

`,\n ),\n );\n});\n\napp.notFound((c) => c.html(page(\"Not found\", `

Not found

`), 404));\n\nexport default oauthMiddleware(app.fetch);\n","deleted",false,"label","terraclear-sy27-live",[14],"ed4a5b8d-823e-4726-a80a-303d51523967",["D",1789405874619],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","TerraClear SY27 digital dashboards (login-gated)","imageUrl","userId","b02b181d-acdd-41c7-966b-7ee33571e414","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a0211a-9176-7708-a613-5932b641a5a0","tursoName","ed4a5b8d823e4726a80a303d51523967","tursoHostname","ed4a5b8d823e4726a80a303d51523967-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494690166],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":104},"org",{"_9":10,"_101":102,"_103":104,"_56":57,"_105":106,"_107":42},"branch",{"_35":30,"_11":88,"_22":28,"_89":46,"_90":91,"_92":93,"_94":51,"_95":96,"_97":98,"_99":12,"_100":10},"isOwned","main","projectId","forkedBranchId","682dc73b-ce03-4bd6-bc9d-1ea55e51846d","forkedBranchVersion",122,"forkedProjectPrivacy","forkedProjectId","c9f048c5-e98a-4ba5-b3b5-6f64ac009b82","forkedProjectOrgId","01a0211b-3ceb-71a5-a4e8-34becf953d3e","projectName","userHandle","displayName","Amanda Turcotte","avatar","https://lh3.googleusercontent.com/a/ACg8ocLsqHPyMlLIj9bNFM_bUg-snI-IECHSmcI9z7SPXwmY8udGUA=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_142":143,"_144":145,"_146":147,"_148":42,"_149":42,"_150":42,"_151":32,"_152":-5,"_153":-7,"_154":-7,"_155":36,"_156":42,"_157":42,"_158":-5,"_159":42,"_160":42,"_161":42,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":88,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]