Mosaic

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_225":226,"_227":228},"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",9,"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/sheets.ts","latestPath","fileId","db73ee5c-5220-11f1-b037-ee650bb23af1","name","sheets.ts","fileType","script","content","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","createdAt",["D",1779043649922],"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":221,"_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":222,"_78":223,"_80":224,"_82":24},"tree",[160,163,168],"files",[160,161,162,163,164,165,166,167,168],"counts",{"_149":60,"_150":140,"_151":60,"_152":153,"_154":155},"contents",[123,124,125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":143,"_31":144,"_29":145,"_129":-5,"_40":41,"_39":146,"_131":132,"_37":147,"_13":60,"_33":134,"_35":-5,"_23":24,"_135":-5,"_26":148},{"_42":137,"_31":138,"_29":139,"_129":-5,"_40":41,"_39":140,"_131":132,"_37":141,"_13":60,"_33":134,"_35":-5,"_23":24,"_135":-5,"_26":142},{"_42":126,"_31":127,"_29":128,"_129":-5,"_40":41,"_39":130,"_131":132,"_37":133,"_13":60,"_33":134,"_35":-5,"_23":24,"_135":-5,"_26":136},"db1b2d6c-5220-11f1-9b56-ee650bb23af1","shared","db1b2e52-5220-11f1-9b56-ee650bb23af1","parentId",3,"latest",true,["D",1779043649323],"directory","label",[127],"daec5b40-5220-11f1-9b56-ee650bb23af1","frontend","daec5c12-5220-11f1-9b56-ee650bb23af1",1,["D",1779043649042],[138],"db00a618-5220-11f1-8514-ee650bb23af1","backend","db00a708-5220-11f1-8514-ee650bb23af1",2,["D",1779043649179],[144],"pulls","branches","forks","envVars",{"_156":158,"_159":60},"connections",{"_156":60,"_157":60},"count","unfilledCount",4,"emptyCount",{"_42":143,"_31":144,"_29":145,"_129":-5,"_40":41,"_39":146,"_131":132,"_37":218,"_13":60,"_33":134,"_35":-5,"_23":24,"_135":-5,"_170":219,"_26":220},{"_42":210,"_31":211,"_29":212,"_129":145,"_40":41,"_39":213,"_131":24,"_37":214,"_13":60,"_33":34,"_35":215,"_23":24,"_135":-5,"_170":216,"_26":217},{"_42":206,"_31":32,"_29":30,"_129":145,"_40":41,"_39":14,"_131":24,"_37":207,"_13":60,"_33":34,"_35":36,"_23":24,"_135":-5,"_170":208,"_26":209},{"_42":137,"_31":138,"_29":139,"_129":-5,"_40":41,"_39":140,"_131":132,"_37":203,"_13":60,"_33":134,"_35":-5,"_23":24,"_135":-5,"_170":204,"_26":205},{"_42":199,"_31":190,"_29":184,"_129":139,"_40":41,"_39":158,"_131":132,"_37":200,"_13":60,"_33":134,"_35":-5,"_23":24,"_135":-5,"_170":201,"_26":202},{"_42":191,"_31":192,"_29":193,"_129":184,"_40":41,"_39":194,"_131":24,"_37":195,"_13":60,"_33":34,"_35":196,"_23":24,"_135":-5,"_170":197,"_26":198},{"_42":181,"_31":182,"_29":183,"_129":184,"_40":41,"_39":185,"_131":24,"_37":186,"_13":60,"_33":34,"_35":187,"_23":24,"_135":-5,"_170":188,"_26":189},{"_42":173,"_31":174,"_29":175,"_129":139,"_40":41,"_39":176,"_131":132,"_37":177,"_13":60,"_33":20,"_35":178,"_23":24,"_135":-5,"_170":179,"_26":180},{"_42":126,"_31":127,"_29":128,"_129":-5,"_40":41,"_39":130,"_131":132,"_37":169,"_13":60,"_33":134,"_35":-5,"_23":24,"_135":-5,"_170":171,"_26":172},["D",1779043649323],"children",[],[127],"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",[],[138,174],"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",[],[138,190,182],"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",[],[138,190,192],"db30fe58-5220-11f1-90ef-ee650bb23af1",["D",1779043649484],[165,166],[138,190],["D",1779043649042],[164,167],[138],"db73eda8-5220-11f1-b037-ee650bb23af1",["D",1779043649922],[],[144,32],"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",[],[144,211],["D",1779043649179],[161,162],[144],["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":258,"_259":260,"_261":262,"_263":24,"_264":24,"_265":24,"_266":132,"_267":-5,"_268":-7,"_269":-7,"_270":60,"_271":24,"_272":24,"_273":-5,"_274":24,"_275":24,"_276":24,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":84,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"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 · v9