Mosaic

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_255":256,"_257":258},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":52,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":24,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/auth.ts","latestPath","fileId","db856600-5220-11f1-a313-ee650bb23af1","name","auth.ts","fileType","script","content","const GOOGLE_TOKEN_URL = \"https://oauth2.googleapis.com/token\";\nconst SCOPE = \"https://www.googleapis.com/auth/spreadsheets.readonly\";\n\ninterface ServiceAccount {\n client_email: string;\n private_key: string;\n}\n\nfunction base64UrlEncode(data: ArrayBuffer | Uint8Array): string {\n const bytes = data instanceof Uint8Array ? data : new Uint8Array(data);\n let binary = \"\";\n for (const byte of bytes) {\n binary += String.fromCharCode(byte);\n }\n return btoa(binary).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=/g, \"\");\n}\n\nfunction encodeJson(obj: object): string {\n return base64UrlEncode(new TextEncoder().encode(JSON.stringify(obj)));\n}\n\nasync function importPrivateKey(pem: string): Promise {\n const pemContents = pem\n .replace(/-----BEGIN PRIVATE KEY-----/, \"\")\n .replace(/-----END PRIVATE KEY-----/, \"\")\n .replace(/\\s/g, \"\");\n\n const binaryDer = Uint8Array.from(atob(pemContents), (c) => c.charCodeAt(0));\n\n return await crypto.subtle.importKey(\n \"pkcs8\",\n binaryDer.buffer,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n}\n\nexport async function getAccessToken(): Promise {\n const serviceAccountJson = Deno.env.get(\"GOOGLE_SERVICE_ACCOUNT_KEY\");\n if (!serviceAccountJson) throw new Error(\"GOOGLE_SERVICE_ACCOUNT_KEY not set\");\n\n const serviceAccount: ServiceAccount = JSON.parse(serviceAccountJson);\n\n const now = Math.floor(Date.now() / 1000);\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const payload = {\n iss: serviceAccount.client_email,\n scope: SCOPE,\n aud: GOOGLE_TOKEN_URL,\n exp: now + 3600,\n iat: now,\n };\n\n const headerEncoded = encodeJson(header);\n const payloadEncoded = encodeJson(payload);\n const signingInput = `${headerEncoded}.${payloadEncoded}`;\n\n const privateKey = await importPrivateKey(serviceAccount.private_key);\n const signature = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n privateKey,\n new TextEncoder().encode(signingInput),\n );\n\n const jwt = `${signingInput}.${base64UrlEncode(signature)}`;\n\n const response = await fetch(GOOGLE_TOKEN_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n grant_type: \"urn:ietf:params:oauth2:grant-type:jwt-bearer\",\n assertion: jwt,\n }),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Failed to get access token: ${error}`);\n }\n\n const data = await response.json();\n return data.access_token as string;\n}\n","createdAt",["D",1779043650007],"branchVersion","branchId","8683b1e4-521a-11f1-9a2e-ee650bb23af1","id","868311da-521a-11f1-9a2e-ee650bb23af1","mosaic",["D",1779040930455],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","7ed186b0-c78a-4757-a5b0-12c00ac89afa","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","e9195859-3c6b-4b40-bb3e-c11844477fdf","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",34,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shapedlines","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYlc2Q1A2eUFyNEdDeXBud0E0bFJyWlJVUzQifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":251,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":252,"_78":253,"_80":254,"_82":24},"tree",[168,172,178,179],"files",[168,169,170,171,172,173,174,175,176,177,178,179],"counts",{"_157":60,"_158":148,"_159":60,"_160":161,"_162":163},"contents",[123,124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":151,"_31":152,"_29":153,"_130":-5,"_40":41,"_39":154,"_132":133,"_37":155,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":156},{"_42":145,"_31":146,"_29":147,"_130":-5,"_40":41,"_39":148,"_132":133,"_37":149,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_130":-5,"_40":41,"_39":141,"_132":133,"_37":142,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":133,"_37":134,"_13":60,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"db7b6a7e-5220-11f1-83c2-ee650bb23af1","deno.json","db7b6b28-5220-11f1-83c2-ee650bb23af1","parentId",10,"latest",true,["D",1779043649828],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[128],"db1b2d6c-5220-11f1-9b56-ee650bb23af1","shared","db1b2e52-5220-11f1-9b56-ee650bb23af1",3,["D",1779043649323],"directory",[139],"daec5b40-5220-11f1-9b56-ee650bb23af1","frontend","daec5c12-5220-11f1-9b56-ee650bb23af1",1,["D",1779043649042],[146],"db00a618-5220-11f1-8514-ee650bb23af1","backend","db00a708-5220-11f1-8514-ee650bb23af1",2,["D",1779043649179],[152],"pulls","branches","forks","envVars",{"_164":166,"_167":60},"connections",{"_164":60,"_165":60},"count","unfilledCount",4,"emptyCount",{"_42":151,"_31":152,"_29":153,"_130":-5,"_40":41,"_39":154,"_132":133,"_37":248,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_181":249,"_26":250},{"_42":244,"_31":32,"_29":30,"_130":153,"_40":41,"_39":14,"_132":24,"_37":245,"_13":60,"_33":34,"_35":36,"_23":24,"_136":-5,"_181":246,"_26":247},{"_42":236,"_31":237,"_29":238,"_130":153,"_40":41,"_39":239,"_132":24,"_37":240,"_13":60,"_33":34,"_35":241,"_23":24,"_136":-5,"_181":242,"_26":243},{"_42":228,"_31":229,"_29":230,"_130":153,"_40":41,"_39":231,"_132":24,"_37":232,"_13":60,"_33":34,"_35":233,"_23":24,"_136":-5,"_181":234,"_26":235},{"_42":145,"_31":146,"_29":147,"_130":-5,"_40":41,"_39":148,"_132":133,"_37":225,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_181":226,"_26":227},{"_42":221,"_31":212,"_29":206,"_130":147,"_40":41,"_39":166,"_132":133,"_37":222,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_181":223,"_26":224},{"_42":213,"_31":214,"_29":215,"_130":206,"_40":41,"_39":216,"_132":24,"_37":217,"_13":60,"_33":34,"_35":218,"_23":24,"_136":-5,"_181":219,"_26":220},{"_42":203,"_31":204,"_29":205,"_130":206,"_40":41,"_39":207,"_132":24,"_37":208,"_13":60,"_33":34,"_35":209,"_23":24,"_136":-5,"_181":210,"_26":211},{"_42":195,"_31":196,"_29":197,"_130":147,"_40":41,"_39":198,"_132":133,"_37":199,"_13":60,"_33":20,"_35":200,"_23":24,"_136":-5,"_181":201,"_26":202},{"_42":187,"_31":188,"_29":189,"_130":147,"_40":41,"_39":190,"_132":133,"_37":191,"_13":60,"_33":34,"_35":192,"_23":24,"_136":-5,"_181":193,"_26":194},{"_42":138,"_31":139,"_29":140,"_130":-5,"_40":41,"_39":141,"_132":133,"_37":184,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_181":185,"_26":186},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":133,"_37":180,"_13":60,"_33":20,"_35":135,"_23":24,"_136":-5,"_181":182,"_26":183},["D",1779043649828],"children",[],[128],["D",1779043649323],[],[139],"db7ee5d2-5220-11f1-a665-ee650bb23af1","index.tsx","db7ee672-5220-11f1-a665-ee650bb23af1",11,["D",1779043649832],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[146,188],"db4e066a-5220-11f1-9b56-ee650bb23af1","index.html","db4e0714-5220-11f1-9b56-ee650bb23af1",5,["D",1779043649678],"\n\n \n \n \n Mosaic\n \n \n \n \n \n

\n \n \n\n",[],[146,196],"db64a2da-5220-11f1-8be3-ee650bb23af1","MosaicGrid.tsx","db64a3a2-5220-11f1-8be3-ee650bb23af1","db30fef8-5220-11f1-90ef-ee650bb23af1",7,["D",1779043649808],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useMemo } from \"https://esm.sh/react@18.2.0\";\nimport type { DayData } from \"../../shared/types.ts\";\n\nfunction shuffle(arr: T[]): T[] {\n const result = [...arr];\n for (let i = result.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [result[i], result[j]] = [result[j], result[i]];\n }\n return result;\n}\n\nfunction DayColumn({ day }: { day: DayData }) {\n // Shuffle once per mount — different every page load, different per day\n const shuffledColors = useMemo(() => shuffle(day.colors), [day.date]);\n\n return (\n

\n {shuffledColors.map((color, i) => (\n \n ))}\n

\n \n {day.date}\n \n

\n );\n}\n\ninterface MosaicGridProps {\n days: DayData[];\n view: \"7\" | \"28\";\n}\n\nexport function MosaicGrid({ days, view }: MosaicGridProps) {\n if (view === \"7\") {\n return (\n

\n {days.map((day) => (\n \n ))}\n

\n );\n }\n\n // 28-day view: split into 4 rows of 7 (oldest row first, newest last)\n const weeks: DayData[][] = [];\n for (let i = 0; i < days.length; i += 7) {\n weeks.push(days.slice(i, i + 7));\n }\n\n return (\n

\n {weeks.map((week, i) => (\n

\n {week.map((day) => (\n \n ))}\n

\n ))}\n

\n );\n}\n",[],[146,212,204],"components","db5d54f8-5220-11f1-83c2-ee650bb23af1","App.tsx","db5d55ac-5220-11f1-83c2-ee650bb23af1",6,["D",1779043649787],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { MosaicGrid } from \"./MosaicGrid.tsx\";\nimport type { DayData } from \"../../shared/types.ts\";\n\ntype View = \"7\" | \"28\";\n\nexport default function App() {\n const [view, setView] = useState(\"7\");\n const [data, setData] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n setLoading(true);\n setError(null);\n fetch(`/api/colors?days=${view}`)\n .then((r) => {\n if (!r.ok) throw new Error(`HTTP ${r.status}`);\n return r.json();\n })\n .then((d: DayData[]) => {\n setData(d);\n setLoading(false);\n })\n .catch((e: Error) => {\n setError(e.message);\n setLoading(false);\n });\n }, [view]);\n\n return (\n \n {/* View toggle */}\n

\n {([\"7\", \"28\"] as View[]).map((v) => (\n setView(v)}\n style={{\n padding: \"4px 14px\",\n fontSize: \"12px\",\n borderRadius: \"4px\",\n border: view === v ? \"none\" : \"1px solid #2d2d2d\",\n background: view === v ? \"#ffffff\" : \"transparent\",\n color: view === v ? \"#000000\" : \"#555555\",\n cursor: \"pointer\",\n fontFamily: \"monospace\",\n transition: \"all 0.15s\",\n }}\n >\n {v}d\n \n ))}\n

\n\n {/* Content */}\n {loading && (\n

\n loading…\n

\n )}\n {error && (\n

\n {error}\n

\n )}\n {!loading && !error && data.length === 0 && (\n

\n no data\n

\n )}\n {!loading && !error && data.length > 0 && (\n \n )}\n \n );\n}\n",[],[146,212,214],"db30fe58-5220-11f1-90ef-ee650bb23af1",["D",1779043649484],[174,175],[146,212],["D",1779043649042],[173,176,177],[146],"db73eda8-5220-11f1-b037-ee650bb23af1","sheets.ts","db73ee5c-5220-11f1-b037-ee650bb23af1",9,["D",1779043649922],"import { getAccessToken } from \"./auth.ts\";\nimport type { DayData } from \"../shared/types.ts\";\n\ninterface SheetsColor {\n red?: number;\n green?: number;\n blue?: number;\n}\n\nfunction colorToHex(color: SheetsColor): string {\n const r = Math.round((color.red ?? 0) * 255);\n const g = Math.round((color.green ?? 0) * 255);\n const b = Math.round((color.blue ?? 0) * 255);\n return `#${r.toString(16).padStart(2, \"0\")}${g.toString(16).padStart(2, \"0\")}${b.toString(16).padStart(2, \"0\")}`;\n}\n\n// Cells that are white or near-white (no fill / default background) are treated as empty\nfunction isWhiteOrEmpty(color: SheetsColor | undefined): boolean {\n if (!color) return true;\n const r = color.red ?? 1;\n const g = color.green ?? 1;\n const b = color.blue ?? 1;\n return r > 0.95 && g > 0.95 && b > 0.95;\n}\n\nexport async function fetchColorData(): Promise {\n const spreadsheetId = Deno.env.get(\"GOOGLE_SHEET_ID\");\n const tab = Deno.env.get(\"GOOGLE_SHEET_TAB\");\n const range = Deno.env.get(\"GOOGLE_SHEET_RANGE\");\n\n if (!spreadsheetId || !tab || !range) {\n throw new Error(\n \"Missing required env vars: GOOGLE_SHEET_ID, GOOGLE_SHEET_TAB, GOOGLE_SHEET_RANGE\",\n );\n }\n\n const fullRange = `${tab}!${range}`;\n const accessToken = await getAccessToken();\n\n const url = new URL(\n `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}`,\n );\n url.searchParams.set(\"includeGridData\", \"true\");\n url.searchParams.set(\"ranges\", fullRange);\n // Fetch only date labels (row 0) and background colors; no other cell content\n url.searchParams.set(\n \"fields\",\n \"sheets.data.rowData.values(formattedValue,userEnteredFormat.backgroundColor)\",\n );\n\n const response = await fetch(url.toString(), {\n headers: { Authorization: `Bearer ${accessToken}` },\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Sheets API error: ${error}`);\n }\n\n const data = await response.json();\n const rowData: Array<{ values?: Array<{\n formattedValue?: string;\n userEnteredFormat?: { backgroundColor?: SheetsColor };\n }> }> = data.sheets?.[0]?.data?.[0]?.rowData ?? [];\n\n if (rowData.length < 2) return [];\n\n // First row holds date labels; all remaining rows are metrics\n const dateRow = rowData[0]?.values ?? [];\n const metricRows = rowData.slice(1);\n\n const result: DayData[] = [];\n\n for (let col = 0; col < dateRow.length; col++) {\n const dateLabel = dateRow[col]?.formattedValue;\n if (!dateLabel) continue;\n\n const colors: string[] = [];\n for (const row of metricRows) {\n const cell = row?.values?.[col];\n const bg = cell?.userEnteredFormat?.backgroundColor;\n if (!isWhiteOrEmpty(bg)) {\n colors.push(colorToHex(bg!));\n }\n }\n\n // Only include days that have at least one colored cell\n if (colors.length > 0) {\n result.push({ date: dateLabel, colors });\n }\n }\n\n return result;\n}\n",[],[152,229],"db6ea1f4-5220-11f1-90ef-ee650bb23af1","index.ts","db6ea2da-5220-11f1-90ef-ee650bb23af1",8,["D",1779043649824],"import { Hono } from \"https://esm.sh/hono@4.6.3\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { fetchColorData } from \"./sheets.ts\";\n\nconst app = new Hono();\n\napp.onError((err, _c) => {\n throw err;\n});\n\napp.get(\"/api/colors\", async (c) => {\n const days = Math.min(parseInt(c.req.query(\"days\") ?? \"7\", 10), 28);\n const allData = await fetchColorData();\n const recent = allData.slice(-days);\n return c.json(recent);\n});\n\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\nexport default app.fetch;\n",[],[152,237],"db856542-5220-11f1-a313-ee650bb23af1",["D",1779043650007],[],[152,32],["D",1779043649179],[169,170,171],[152],["D",1779040930455],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_120":288,"_289":290,"_291":292,"_293":24,"_294":24,"_295":24,"_296":133,"_297":-5,"_298":-7,"_299":-7,"_300":60,"_301":24,"_302":24,"_303":-5,"_304":24,"_305":24,"_306":24,"_307":-5},"ENV",{"_259":260,"_261":262,"_263":84,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v12