[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","terraclear","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":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":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/terraclear/sy27-dashboards/code/main.tsx","extension","id","dcfeb0e3-4263-4c34-9a89-3c272b2631ac","fileId","29bdcbfe-9d86-11f1-9801-1607ee4eb77e","parentId","branchId","682dc73b-ce03-4bd6-bc9d-1ea55e51846d","branchVersion",122,"latest",true,"createdAt",["D",1789404709338],"version",15,"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",[14],"c9f048c5-e98a-4ba5-b3b5-6f64ac009b82",["D",1787333497510],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","TerraClear SY27 digital dashboards (private, token-gated)","imageUrl","userId","b02b181d-acdd-41c7-966b-7ee33571e414","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0211b-3ceb-71a5-a4e8-34becf953d3e","tursoName","c9f048c5e98a4ba5b3b56f64ac009b82","tursoHostname","c9f048c5e98a4ba5b3b56f64ac009b82-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789510270483],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":101},"org",{"_9":10,"_98":99,"_100":101,"_56":-5,"_102":103,"_104":42},"branch",{"_35":30,"_11":89,"_22":28,"_90":46,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Terraclear","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3fbd6d7f-43ca-409d-22e4-7e3b2a373e00/square512?exp=1789552799&sig=a64e67c26b77fe1b339d125390967a5b286de9ef4c557226112d2e25dcd0d99c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":63,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":89,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"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"]