Hi

\"\n});\n```\n\n## Val Town Utility Functions\n\nVal Town provides several utility functions to help with common project tasks.\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport { parseProject, readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n\n#### **serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n```\n\n#### **readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n#### **listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n#### **parseProject** - Extract information about the current project from import.meta.url\n\nThis is useful for including info for linking back to a val, ie in \"view source\" urls:\n\n```ts\nconst projectVal = parseProject(import.meta.url);\nconsole.log(projectVal.username); // Owner of the project\nconsole.log(projectVal.name); // Project name\nconsole.log(projectVal.version); // Version number\nconsole.log(projectVal.branch); // Branch name\nconsole.log(projectVal.links.self.project); // URL to the project page\n```\n\nHowever, it's *extremely importing* to note that `parseProject` and other Standard Library utilities ONLY RUN ON THE SERVER.\nIf you need access to this data on the client, run it in the server and pass it to the client by splicing it into the HTML page\nor by making an API request for it.\n\n## Val Town Platform Specifics\n\n- **Redirects:** Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})` instead of `Response.redirect` which is broken\n- **Images:** Avoid external images or base64 images. Use emojis, unicode symbols, or icon fonts/libraries instead\n- **AI Image:** To inline generate an AI image use: `

`\n- **Storage:** DO NOT use the Deno KV module for storage\n- **Browser APIs:** DO NOT use the `alert()`, `prompt()`, or `confirm()` methods\n- **Weather Data:** Use open-meteo for weather data (doesn't require API keys) unless otherwise specified\n- **View Source:** Add a view source link by importing & using `import.meta.url.replace(\"ems.sh\", \"val.town)\"` (or passing this data to the client) and include `target=\"_top\"` attribute\n- **Error Debugging:** Add `` to HTML to capture client-side errors\n- **Error Handling:** Only use try...catch when there's a clear local resolution; Avoid catches that merely log or return 500s. Let errors bubble up with full context\n- **Environment Variables:** Use `Deno.env.get('keyname')` when you need to, but generally prefer APIs that don't require keys\n- **Imports:** Use `https://esm.sh` for npm and Deno dependencies to ensure compatibility on server and browser\n- **Storage Strategy:** Only use backend storage if explicitly required; prefer simple static client-side sites\n- **React Configuration:** When using React libraries, pin versions with `?deps=react@18.2.0,react-dom@18.2.0` and start the file with `/** @jsxImportSource https://esm.sh/react@18.2.0 */`\n- Ensure all React dependencies and sub-dependencies are pinned to the same version\n- **Styling:** Default to using TailwindCSS via `` unless otherwise specified\n\n## Project Structure and Design Patterns\n\n### Recommended Directory Structure\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ │ └── README.md\n│ └── routes/ # Route modules\n│ ├── [route].ts\n│ └── static.ts # Static file serving\n│ ├── index.ts # Main entry point\n│ └── README.md\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ └── [Component].tsx\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ ├── README.md\n│ └── style.css\n├── README.md\n└── shared/\n ├── README.md\n └── utils.ts # Shared types and functions\n```\n\n### Backend (Hono) Best Practices\n\n- Hono is the recommended API framework\n- Main entry point should be `backend/index.ts`\n- **Static asset serving:** Use the utility functions to read and serve project files:\n ```ts\n import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n \n // serve all files in frontend/ and shared/\n app.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n app.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n \n // For index.html, often you'll want to bootstrap with initial data\n app.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject data to avoid extra round-trips\n const initialData = await fetchInitialData();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n });\n ```\n- Create RESTful API routes for CRUD operations\n- Always include this snippet at the top-level Hono app to re-throwing errors to see full stack traces:\n ```ts\n // Unwrap Hono errors to see original error details\n app.onError((err, c) => {\n throw err;\n });\n ```\n\n### Database Patterns\n- Run migrations on startup or comment out for performance\n- Change table names when modifying schemas rather than altering\n- Export clear query functions with proper TypeScript typing\n\n## Common Gotchas and Solutions\n\n1. **Environment Limitations:** \n - Val Town runs on Deno in a serverless context, not Node.js\n - Code in `shared/` must work in both frontend and backend environments\n - Cannot use `Deno` keyword in shared code\n - Use `https://esm.sh` for imports that work in both environments\n\n2. **SQLite Peculiarities:**\n - Limited support for ALTER TABLE operations\n - Create new tables with updated schemas and copy data when needed\n - Always run table creation before querying\n\n3. **React Configuration:**\n - All React dependencies must be pinned to 18.2.0\n - Always include `@jsxImportSource https://esm.sh/react@18.2.0` at the top of React files\n - Rendering issues often come from mismatched React versions\n\n4. **File Handling:**\n - Val Town only supports text files, not binary\n - Use the provided utilities to read files across branches and forks\n - For files in the project, use `readFile` helpers\n\n5. **API Design:**\n - `fetch` handler is the entry point for HTTP vals\n - Run the Hono app with `export default app.fetch // This is the entry point for HTTP vals`\n\n",[],[117],"74cbf226-3a47-11f1-8fc5-42b51c65c3df",".vtignore","019d9af7-6e51-7719-b62a-2dc93465788f",["D",1776421400152],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor\n\nassets\n/assets\n",[],[124],["D",1776421400152],[133],[19],{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":134,"_17":34,"_73":74,"_75":76,"_77":52,"_78":-5,"_99":135,"_18":136},["D",1776421400152],[],[19,61],"74cbeaba-3a47-11f1-8fc5-42b51c65c3df","frontend","019d9af7-6e51-7719-b62a-23b3ecbb6e2e",["D",1776421400152],[143,144,145,146,147],[138],{"_36":176,"_13":177,"_62":178,"_64":139,"_66":67,"_68":69,"_70":71,"_38":179,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":180,"_18":181},{"_36":169,"_13":170,"_62":171,"_64":139,"_66":67,"_68":69,"_70":71,"_38":172,"_17":34,"_73":24,"_75":173,"_77":52,"_78":-5,"_99":174,"_18":175},{"_36":162,"_13":163,"_62":164,"_64":139,"_66":67,"_68":69,"_70":71,"_38":165,"_17":34,"_73":74,"_75":166,"_77":52,"_78":-5,"_99":167,"_18":168},{"_36":155,"_13":156,"_62":157,"_64":139,"_66":67,"_68":69,"_70":71,"_38":158,"_17":34,"_73":24,"_75":159,"_77":52,"_78":-5,"_99":160,"_18":161},{"_36":148,"_13":149,"_62":150,"_64":139,"_66":67,"_68":69,"_70":71,"_38":151,"_17":34,"_73":74,"_75":152,"_77":52,"_78":-5,"_99":153,"_18":154},"74cbe1b4-3a47-11f1-8fc5-42b51c65c3df","sw.js","019d9af7-6e51-7719-b62a-1d4660a09a7a",["D",1776421400152],"// boymath service worker\n// Caches the app shell so it loads instantly and works offline.\n\nconst CACHE = \"boymath-v1\";\n\n// Pre-cache the app shell on install\nself.addEventListener(\"install\", (e) => {\n e.waitUntil(\n caches.open(CACHE).then((cache) => cache.add(\"/\"))\n );\n self.skipWaiting();\n});\n\n// Remove old caches on activate\nself.addEventListener(\"activate\", (e) => {\n e.waitUntil(\n caches.keys().then((keys) =>\n Promise.all(keys.filter((k) => k !== CACHE).map((k) => caches.delete(k)))\n )\n );\n self.clients.claim();\n});\n\nself.addEventListener(\"fetch\", (e) => {\n const url = new URL(e.request.url);\n\n // Let API calls go straight to the network; fail gracefully offline\n if (url.pathname.startsWith(\"/api/\")) {\n e.respondWith(\n fetch(e.request).catch(\n () =>\n new Response(JSON.stringify({ error: \"offline\" }), {\n status: 503,\n headers: { \"Content-Type\": \"application/json\" },\n })\n )\n );\n return;\n }\n\n // For page navigations: network first, fall back to cached shell\n if (e.request.mode === \"navigate\") {\n e.respondWith(\n fetch(e.request)\n .then((res) => {\n // Update the cache with the fresh shell\n const clone = res.clone();\n caches.open(CACHE).then((c) => c.put(\"/\", clone));\n return res;\n })\n .catch(() => caches.match(\"/\"))\n );\n return;\n }\n\n // For all other requests: cache first, then network\n e.respondWith(\n caches.match(e.request).then(\n (cached) =>\n cached ||\n fetch(e.request).then((res) => {\n if (res.ok) {\n const clone = res.clone();\n caches.open(CACHE).then((c) => c.put(e.request, clone));\n }\n return res;\n })\n )\n );\n});\n",[],[138,149],"74cbdcbe-3a47-11f1-8fc5-42b51c65c3df","manifest.json","019d9af7-6e51-7719-b62a-1ae8170b8134",["D",1776421400152],"{\n \"name\": \"boymath\",\n \"short_name\": \"boymath\",\n \"description\": \"Track your daily savings\",\n \"start_url\": \"/\",\n \"display\": \"standalone\",\n \"background_color\": \"#ffffff\",\n \"theme_color\": \"#ffffff\",\n \"orientation\": \"portrait-primary\",\n \"icons\": [\n {\n \"src\": \"https://i.imgur.com/VbFkf2o.png\",\n \"sizes\": \"192x192\",\n \"type\": \"image/png\",\n \"purpose\": \"any\"\n },\n {\n \"src\": \"https://i.imgur.com/MlRJetm.png\",\n \"sizes\": \"512x512\",\n \"type\": \"image/png\",\n \"purpose\": \"maskable\"\n }\n ]\n}\n",[],[138,156],"74cbd99e-3a47-11f1-8fc5-42b51c65c3df","index.tsx","019d9af7-6e51-7719-b62a-17c914b36090",["D",1776421400152],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst container = document.getElementById(\"root\")!;\nconst root = createRoot(container);\nroot.render();\n",[],[138,163],"74cbca30-3a47-11f1-8fc5-42b51c65c3df","index.html","019d9af7-6e51-7719-b62a-10b614141bf4",["D",1776421400152],"\n\n \n \n \n boymath\n\n \n \n\n \n \n \n \n \n\n \n \n\n \n \n \n \n

\n \n \n \n \n\n",[],[138,170],"74cbc4f4-3a47-11f1-8fc5-42b51c65c3df","components","019d9af7-6e51-7719-b62a-0eeea4346e26",["D",1776421400152],[182,183,184,185,186],[138,177],{"_36":217,"_13":218,"_62":219,"_64":178,"_66":67,"_68":69,"_70":71,"_38":220,"_17":34,"_73":74,"_75":221,"_77":52,"_78":-5,"_99":222,"_18":223},{"_36":209,"_13":210,"_62":211,"_64":178,"_66":67,"_68":212,"_70":71,"_38":213,"_17":34,"_73":74,"_75":214,"_77":52,"_78":-5,"_99":215,"_18":216},{"_36":202,"_13":203,"_62":204,"_64":178,"_66":67,"_68":32,"_70":71,"_38":205,"_17":69,"_73":74,"_75":206,"_77":52,"_78":-5,"_99":207,"_18":208},{"_36":195,"_13":196,"_62":197,"_64":178,"_66":67,"_68":69,"_70":71,"_38":198,"_17":34,"_73":74,"_75":199,"_77":52,"_78":-5,"_99":200,"_18":201},{"_36":187,"_13":188,"_62":189,"_64":178,"_66":67,"_68":190,"_70":71,"_38":191,"_17":69,"_73":74,"_75":192,"_77":52,"_78":-5,"_99":193,"_18":194},"980ebc62-3a49-11f1-aad6-42b51c65c3df","MainPage.tsx","019d9af7-6e51-7719-b62a-0a66c0ee98fc",2,["D",1776422318318],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useRef } from \"https://esm.sh/react@18.2.0\";\nimport CoinExplosion from \"./CoinExplosion.tsx\";\nimport CoinCanvas from \"./CoinCanvas.tsx\";\n\ntype Mode = \"none\" | \"inputs\" | \"direct\" | \"buttons\";\n\nconst PRESET_BUTTONS: { label: string; cents: number }[] = [\n { label: \"$1\", cents: 100 },\n { label: \"$2\", cents: 200 },\n { label: \"$3\", cents: 300 },\n { label: \"$4\", cents: 400 },\n { label: \"5¢\", cents: 5 },\n { label: \"10¢\", cents: 10 },\n { label: \"20¢\", cents: 20 },\n { label: \"50¢\", cents: 50 },\n];\n\n// Raw digit string treated as cents: \"300\" → 300 cents → $3.00\nfunction centsFromDigits(digits: string): number {\n return parseInt(digits.replace(/\\D/g, \"\") || \"0\", 10);\n}\n\nfunction formatCents(cents: number): string {\n const abs = Math.abs(cents);\n const sign = cents < 0 ? \"-\" : \"\";\n return `${sign}$${(abs / 100).toFixed(2)}`;\n}\n\nconst FONT = '-apple-system, BlinkMacSystemFont, \"SF Pro Display\", \"Helvetica Neue\", sans-serif';\n\ninterface Props {\n onHistory: () => void;\n}\n\nexport default function MainPage({ onHistory }: Props) {\n const [mode, setMode] = useState(\"none\");\n const [input1Digits, setInput1Digits] = useState(\"\");\n const [input2Digits, setInput2Digits] = useState(\"\");\n const [directDigits, setDirectDigits] = useState(\"\");\n const [buttonCents, setButtonCents] = useState(0);\n const [explosion, setExplosion] = useState<{ x: number; y: number; imageUrl: string } | null>(null);\n\n const submitRef = useRef(null);\n const directInputRef = useRef(null);\n\n // Compute the displayed amount based on the active mode\n let amountCents = 0;\n if (mode === \"inputs\") {\n amountCents = centsFromDigits(input1Digits) - centsFromDigits(input2Digits);\n } else if (mode === \"direct\") {\n amountCents = centsFromDigits(directDigits);\n } else if (mode === \"buttons\") {\n amountCents = buttonCents;\n }\n\n const isNegative = amountCents < 0;\n const canSubmit = amountCents > 0;\n\n const resetAll = () => {\n setMode(\"none\");\n setInput1Digits(\"\");\n setInput2Digits(\"\");\n setDirectDigits(\"\");\n setButtonCents(0);\n };\n\n const handleInput1Change = (e: React.ChangeEvent) => {\n const digits = e.target.value.replace(/\\D/g, \"\");\n setInput1Digits(digits);\n if (mode !== \"inputs\") {\n setMode(\"inputs\");\n setDirectDigits(\"\");\n setButtonCents(0);\n }\n };\n\n const handleInput2Change = (e: React.ChangeEvent) => {\n const digits = e.target.value.replace(/\\D/g, \"\");\n setInput2Digits(digits);\n if (mode !== \"inputs\") {\n setMode(\"inputs\");\n setDirectDigits(\"\");\n setButtonCents(0);\n }\n };\n\n const handleInput1Focus = () => {\n if (mode !== \"inputs\") {\n setMode(\"inputs\");\n setDirectDigits(\"\");\n setButtonCents(0);\n }\n };\n\n const handleInput2Focus = () => {\n if (mode !== \"inputs\") {\n setMode(\"inputs\");\n setDirectDigits(\"\");\n setButtonCents(0);\n }\n };\n\n const handleDirectChange = (e: React.ChangeEvent) => {\n const digits = e.target.value.replace(/\\D/g, \"\");\n setDirectDigits(digits);\n };\n\n const handleAmountSavedClick = () => {\n setMode(\"direct\");\n setInput1Digits(\"\");\n setInput2Digits(\"\");\n setButtonCents(0);\n setDirectDigits(\"\");\n setTimeout(() => directInputRef.current?.focus(), 0);\n };\n\n const handleButtonPress = (cents: number) => {\n if (mode === \"buttons\") {\n setButtonCents((prev) => prev + cents);\n } else {\n setMode(\"buttons\");\n setInput1Digits(\"\");\n setInput2Digits(\"\");\n setDirectDigits(\"\");\n setButtonCents(cents);\n }\n };\n\n const handleSubmit = async () => {\n if (!canSubmit) return;\n try {\n const resp = await fetch(\"/api/savings\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ amount_cents: amountCents }),\n });\n if (resp.ok) {\n const rect = submitRef.current?.getBoundingClientRect();\n const capturedImageUrl = coinImageUrl;\n if (rect) {\n setExplosion({\n x: rect.left + rect.width / 2,\n y: rect.top + rect.height / 2,\n imageUrl: capturedImageUrl,\n });\n }\n resetAll();\n }\n } catch (err) {\n console.error(\"Failed to save:\", err);\n }\n };\n\n // Colors\n const bgColor = isNegative ? \"#ef4444\" : \"#ffffff\";\n const textColor = isNegative ? \"#ffffff\" : \"#000000\";\n const dividerColor = isNegative ? \"rgba(255,255,255,0.4)\" : \"#000000\";\n const coinImageUrl = isNegative\n ? \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e5cc027-0802-4ec0-e93e-92d625d3ab00/public\"\n : canSubmit\n ? \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/080dd1f7-c03c-4691-34f6-39e8410c2200/public\"\n : \"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/a1c8fc2f-cd18-4300-ec65-35c1cb3b5900/public\";\n\n return (\n \n {/* ── Input row: minus sign + two stacked inputs ── */}\n \n {/* Minus sign, vertically centered between the two inputs */}\n \n −\n \n\n {/* Inputs stacked */}\n

\n {/* Input 1: would-have-spent */}\n \n {/* Input 2: actually-spent */}\n \n

\n \n\n {/* ── Solid divider line ── */}\n \n\n {/* ── Amount Saved display / direct input ── */}\n \n {mode === \"direct\" ? (\n \n ) : (\n \n {formatCents(amountCents)}\n \n )}\n \n\n {/* ── Submit button (3D coin) ── */}\n

\n \n

\n\n {/* ── Dashed divider ── */}\n

\n\n {/* ── Preset buttons (2 rows × 4) ── */}\n \n {PRESET_BUTTONS.map(({ label, cents }) => (\n handleButtonPress(cents)}\n style={{\n aspectRatio: \"1\",\n borderRadius: \"50%\",\n backgroundColor: \"#FFCF48\",\n border: \"none\",\n cursor: \"pointer\",\n fontSize: \"clamp(16px, 6vw, 26px)\",\n fontWeight: 300,\n fontFamily: FONT,\n display: \"flex\",\n alignItems: \"center\",\n justifyContent: \"center\",\n color: \"#000000\",\n }}\n >\n {label}\n \n ))}\n

\n\n {/* ── Dashed divider ── */}\n

\n\n {/* ── History icon (bottom right) ── */}\n \n \n {/* Increasing bars icon matching Figma vector */}\n \n \n

\n\n {/* ── Coin explosion overlay ── */}\n {explosion && (\n setExplosion(null)}\n />\n )}\n \n );\n}\n",[],[138,177,188],"74cb5cee-3a47-11f1-8fc5-42b51c65c3df","HistoryPage.tsx","019d9af7-6e51-7719-b62a-05b64fb90c4e",["D",1776421400152],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { ChartDataPoint } from \"../../shared/types.ts\";\n\ntype Period = \"day\" | \"week\" | \"month\";\n\nconst PERIODS: { label: string; value: Period }[] = [\n { label: \"1 Day\", value: \"day\" },\n { label: \"1 Week\", value: \"week\" },\n { label: \"1 Month\", value: \"month\" },\n];\n\nconst FONT = '-apple-system, BlinkMacSystemFont, \"SF Pro Display\", \"Helvetica Neue\", sans-serif';\n\nfunction formatCents(cents: number): string {\n return `$${(cents / 100).toFixed(2)}`;\n}\n\n// \"2026-04-16\" → \"4/16\"\nfunction formatShortDate(dateStr: string): string {\n const parts = dateStr.split(\"-\");\n return `${parseInt(parts[1])}/${parseInt(parts[2])}`;\n}\n\n// ── Inline SVG chart: bars (daily total) + dashed line (7-day rolling avg) ──\nfunction SavingsChart({ data }: { data: ChartDataPoint[] }) {\n const containerRef = useRef(null);\n const [width, setWidth] = useState(358);\n\n useEffect(() => {\n if (!containerRef.current) return;\n const observer = new ResizeObserver((entries) => {\n setWidth(entries[0].contentRect.width);\n });\n observer.observe(containerRef.current);\n setWidth(containerRef.current.clientWidth);\n return () => observer.disconnect();\n }, []);\n\n const PAD_TOP = 12;\n const PAD_BOTTOM = 28; // room for x-axis labels\n const PAD_LEFT = 38; // room for y-axis labels\n const PAD_RIGHT = 8;\n const HEIGHT = 200;\n\n const chartW = width - PAD_LEFT - PAD_RIGHT;\n const chartH = HEIGHT - PAD_TOP - PAD_BOTTOM;\n\n const maxValue = Math.max(...data.map((d) => Math.max(d.total_cents, d.rolling_avg_cents)), 1);\n\n const n = data.length;\n const barMaxWidth = Math.min(28, (chartW / n) * 0.65);\n\n // Pixel x-center for data point i\n const xOf = (i: number) =>\n PAD_LEFT + (n === 1 ? chartW / 2 : (i / (n - 1)) * chartW);\n\n // Pixel y for a value\n const yOf = (v: number) =>\n PAD_TOP + chartH - (v / maxValue) * chartH;\n\n // Y-axis tick values (3 ticks: 0, half, max rounded up)\n const yTicks = [0, Math.round(maxValue / 2), maxValue];\n\n // X-axis: show labels at most every ~60px to avoid crowding\n const xLabelEvery = Math.max(1, Math.round(60 / (chartW / n)));\n\n // Build polyline points for the rolling average line\n const linePoints = data\n .map((d, i) => `${xOf(i)},${yOf(d.rolling_avg_cents)}`)\n .join(\" \");\n\n return (\n

\n \n {/* Horizontal grid lines at each y-tick */}\n {yTicks.map((v) => (\n \n ))}\n\n {/* Y-axis labels */}\n {yTicks.map((v) => (\n \n ${(v / 100).toFixed(0)}\n \n ))}\n\n {/* Bars */}\n {data.map((d, i) => {\n const barH = (d.total_cents / maxValue) * chartH;\n return (\n \n );\n })}\n\n {/* Rolling average line */}\n \n\n {/* Rolling average dots */}\n {data.map((d, i) => (\n \n ))}\n\n {/* X-axis labels */}\n {data.map((d, i) => {\n if (i % xLabelEvery !== 0 && i !== n - 1) return null;\n return (\n \n {formatShortDate(d.day)}\n \n );\n })}\n \n

\n );\n}\n\ninterface Props {\n onBack: () => void;\n}\n\nexport default function HistoryPage({ onBack }: Props) {\n const [period, setPeriod] = useState(\"week\");\n const [totalCents, setTotalCents] = useState(0);\n const [chartData, setChartData] = useState([]);\n const [loadingTotal, setLoadingTotal] = useState(true);\n const [loadingChart, setLoadingChart] = useState(true);\n\n useEffect(() => {\n fetchTotal(period);\n }, [period]);\n\n useEffect(() => {\n fetchChart();\n }, []);\n\n const fetchTotal = async (p: Period) => {\n setLoadingTotal(true);\n try {\n const resp = await fetch(`/api/savings?period=${p}`);\n const data = await resp.json();\n setTotalCents(data.total_cents ?? 0);\n } catch (err) {\n console.error(\"Failed to fetch savings:\", err);\n } finally {\n setLoadingTotal(false);\n }\n };\n\n const fetchChart = async () => {\n setLoadingChart(true);\n try {\n const resp = await fetch(\"/api/savings/chart\");\n const data = await resp.json();\n setChartData(data.days ?? []);\n } catch (err) {\n console.error(\"Failed to fetch chart:\", err);\n } finally {\n setLoadingChart(false);\n }\n };\n\n return (\n \n {/* ── Header: back button ── */}\n \n \n ←\n \n \n\n {/* ── Period selector pills ── */}\n

\n {PERIODS.map(({ label, value }) => (\n setPeriod(value)}\n style={{\n flex: 1,\n padding: \"10px 0\",\n borderRadius: \"50px\",\n border: \"none\",\n cursor: \"pointer\",\n fontSize: \"15px\",\n fontWeight: period === value ? 500 : 300,\n fontFamily: FONT,\n backgroundColor: period === value ? \"#FFCF48\" : \"#f3f4f6\",\n color: \"#000000\",\n transition: \"background-color 0.15s ease\",\n }}\n >\n {label}\n \n ))}\n

\n\n {/* ── Dashed divider ── */}\n

\n\n {/* ── Total saved display ── */}\n \n \n Total Saved\n

\n \n {formatCents(totalCents)}\n \n \n\n {/* ── Dashed divider ── */}\n

\n\n {/* ── Chart ── */}\n

\n \n Last 30 Days\n

\n\n {loadingChart ? (\n \n Loading…\n

\n ) : chartData.length === 0 ? (\n \n No data yet — start saving!\n \n ) : (\n \n )}\n\n {/* Legend */}\n {chartData.length > 0 && (\n \n

\n \n Daily total\n

\n \n 7-day avg\n

\n \n )}\n \n \n );\n}\n",[],[138,177,196],"9813a402-3a49-11f1-bb54-42b51c65c3df","CoinExplosion.tsx","019d9af7-6e51-7719-b62a-03e3ac7bb49c",["D",1776422318317],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState, useRef } from \"https://esm.sh/react@18.2.0\";\n\ninterface CoinExplosionProps {\n x: number;\n y: number;\n imageUrl: string;\n onDone: () => void;\n}\n\ninterface Coin {\n id: number;\n tx: number;\n ty: number;\n delay: number;\n size: number;\n}\n\nexport default function CoinExplosion({ x, y, imageUrl, onDone }: CoinExplosionProps) {\n const coinRefs = useRef<(HTMLDivElement | null)[]>([]);\n\n const [coins] = useState(() =>\n Array.from({ length: 20 }, (_, i) => {\n const angle = (360 / 20) * i + (Math.random() * 18 - 9);\n const distance = 80 + Math.random() * 120;\n const rad = (angle * Math.PI) / 180;\n return {\n id: i,\n tx: Math.cos(rad) * distance,\n ty: Math.sin(rad) * distance,\n delay: Math.random() * 80,\n size: 20 + Math.floor(Math.random() * 16),\n };\n })\n );\n\n useEffect(() => {\n // Animate each coin using the Web Animations API for precise per-coin control\n coinRefs.current.forEach((el, i) => {\n if (!el) return;\n const coin = coins[i];\n el.animate(\n [\n {\n transform: \"translate(-50%, -50%) scale(0.3)\",\n opacity: \"1\",\n },\n {\n transform: `translate(calc(-50% + ${coin.tx}px), calc(-50% + ${coin.ty}px)) scale(1.2)`,\n opacity: \"0\",\n },\n ],\n {\n duration: 800,\n delay: coin.delay,\n easing: \"ease-out\",\n fill: \"forwards\",\n },\n );\n });\n\n const timer = setTimeout(onDone, 1000);\n return () => clearTimeout(timer);\n }, []);\n\n return (\n \n {coins.map((coin, i) => (\n {\n coinRefs.current[i] = el;\n }}\n style={{\n position: \"absolute\",\n width: coin.size,\n height: coin.size,\n transform: \"translate(-50%, -50%)\",\n willChange: \"transform, opacity\",\n userSelect: \"none\",\n }}\n >\n

\n \n ))}\n \n );\n}\n",[],[138,177,203],"981b40e0-3a49-11f1-b477-42b51c65c3df","CoinCanvas.tsx","981b4180-3a49-11f1-b477-42b51c65c3df",4,["D",1776422318330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport * as THREE from \"https://esm.sh/three@0.170.0\";\n\ntype CoinState = \"gold\" | \"grey\" | \"red\";\n\ninterface CoinCanvasProps {\n textureUrl: string;\n coinState: CoinState;\n size?: number;\n onTap?: () => void;\n disabled?: boolean;\n}\n\nconst EDGE_COLORS: Record = {\n gold: 0xd4af37,\n grey: 0x9e9e9e,\n red: 0xcc4444,\n};\n\ninterface SceneState {\n renderer: THREE.WebGLRenderer;\n scene: THREE.Scene;\n camera: THREE.PerspectiveCamera;\n coin: THREE.Mesh;\n faceMat: THREE.MeshStandardMaterial;\n sideMat: THREE.MeshStandardMaterial;\n geometry: THREE.CylinderGeometry;\n pointerDown: boolean;\n lastX: number;\n lastY: number;\n lastMoveTime: number;\n velocityX: number;\n velocityY: number;\n totalMove: number;\n angVelocity: number;\n spinAxisX: number;\n spinAxisY: number;\n frameId: number;\n}\n\nexport default function CoinCanvas({\n textureUrl,\n coinState,\n size = 200,\n onTap,\n disabled,\n}: CoinCanvasProps) {\n const mountRef = useRef(null);\n const sceneRef = useRef(null);\n const disabledRef = useRef(disabled);\n const onTapRef = useRef(onTap);\n\n // Keep refs in sync with latest props without re-running main effect\n disabledRef.current = disabled;\n onTapRef.current = onTap;\n\n // Main Three.js init — runs once on mount\n useEffect(() => {\n const mount = mountRef.current;\n if (!mount) return;\n\n const scene = new THREE.Scene();\n const camera = new THREE.PerspectiveCamera(45, 1, 0.1, 100);\n camera.position.z = 2.8;\n\n const renderer = new THREE.WebGLRenderer({ alpha: true, antialias: true });\n renderer.setSize(size, size);\n renderer.setPixelRatio(Math.min(window.devicePixelRatio, 2));\n mount.appendChild(renderer.domElement);\n\n scene.add(new THREE.AmbientLight(0xffffff, 0.7));\n const dirLight = new THREE.DirectionalLight(0xffffff, 0.8);\n dirLight.position.set(1, 2, 3);\n scene.add(dirLight);\n\n const geometry = new THREE.CylinderGeometry(1, 1, 0.1, 64);\n\n const sideMat = new THREE.MeshStandardMaterial({\n color: EDGE_COLORS[coinState],\n metalness: 0.6,\n roughness: 0.3,\n });\n const faceMat = new THREE.MeshStandardMaterial({\n metalness: 0.2,\n roughness: 0.5,\n });\n\n // Load initial texture\n const loader = new THREE.TextureLoader();\n loader.crossOrigin = \"anonymous\";\n loader.load(textureUrl, (tex) => {\n tex.colorSpace = THREE.SRGBColorSpace;\n faceMat.map = tex;\n faceMat.needsUpdate = true;\n });\n\n // groups: 0=side, 1=top cap, 2=bottom cap\n const coin = new THREE.Mesh(geometry, [sideMat, faceMat, faceMat]);\n // Rotate so flat cap faces the camera (cap normal: +Y → +Z)\n coin.rotation.x = Math.PI / 2;\n scene.add(coin);\n\n const s: SceneState = {\n renderer,\n scene,\n camera,\n coin,\n faceMat,\n sideMat,\n geometry,\n pointerDown: false,\n lastX: 0,\n lastY: 0,\n lastMoveTime: 0,\n velocityX: 0,\n velocityY: 0,\n totalMove: 0,\n angVelocity: 0,\n spinAxisX: 0,\n spinAxisY: 1,\n frameId: 0,\n };\n sceneRef.current = s;\n\n // Pointer handlers\n const onPointerDown = (e: PointerEvent) => {\n s.pointerDown = true;\n s.lastX = e.clientX;\n s.lastY = e.clientY;\n s.lastMoveTime = performance.now();\n s.velocityX = 0;\n s.velocityY = 0;\n s.totalMove = 0;\n s.angVelocity = 0;\n renderer.domElement.setPointerCapture(e.pointerId);\n e.preventDefault();\n };\n\n const onPointerMove = (e: PointerEvent) => {\n if (!s.pointerDown) return;\n const dx = e.clientX - s.lastX;\n const dy = e.clientY - s.lastY;\n const now = performance.now();\n const dt = Math.max(now - s.lastMoveTime, 1);\n\n s.velocityX = dx / dt;\n s.velocityY = dy / dt;\n s.lastX = e.clientX;\n s.lastY = e.clientY;\n s.lastMoveTime = now;\n s.totalMove += Math.sqrt(dx * dx + dy * dy);\n\n const len = Math.sqrt(dx * dx + dy * dy);\n if (len > 0) {\n // Axis perpendicular to swipe direction (cross product of screen-swipe with face normal)\n const ax = -dy / len;\n const ay = -dx / len;\n const axis = new THREE.Vector3(ax, ay, 0);\n s.coin.rotateOnWorldAxis(axis, len * 0.03);\n }\n };\n\n const onPointerUp = (e: PointerEvent) => {\n if (!s.pointerDown) return;\n s.pointerDown = false;\n\n if (s.totalMove < 8) {\n if (!disabledRef.current && onTapRef.current) onTapRef.current();\n return;\n }\n\n // Apply momentum from release velocity\n const speed = Math.sqrt(s.velocityX * s.velocityX + s.velocityY * s.velocityY);\n if (speed > 0) {\n s.spinAxisX = -s.velocityY / speed;\n s.spinAxisY = -s.velocityX / speed;\n s.angVelocity = speed * 20;\n }\n };\n\n renderer.domElement.addEventListener(\"pointerdown\", onPointerDown);\n renderer.domElement.addEventListener(\"pointermove\", onPointerMove);\n renderer.domElement.addEventListener(\"pointerup\", onPointerUp);\n renderer.domElement.addEventListener(\"pointercancel\", onPointerUp);\n\n // Animation loop\n let lastTime = performance.now();\n const animate = () => {\n s.frameId = requestAnimationFrame(animate);\n const now = performance.now();\n const dt = Math.min((now - lastTime) / 1000, 0.05);\n lastTime = now;\n\n if (!s.pointerDown && s.angVelocity > 0.0005) {\n const axis = new THREE.Vector3(s.spinAxisX, s.spinAxisY, 0);\n s.coin.rotateOnWorldAxis(axis, s.angVelocity * dt);\n s.angVelocity *= Math.pow(0.94, dt * 60);\n }\n\n renderer.render(scene, camera);\n };\n animate();\n\n return () => {\n cancelAnimationFrame(s.frameId);\n renderer.domElement.removeEventListener(\"pointerdown\", onPointerDown);\n renderer.domElement.removeEventListener(\"pointermove\", onPointerMove);\n renderer.domElement.removeEventListener(\"pointerup\", onPointerUp);\n renderer.domElement.removeEventListener(\"pointercancel\", onPointerUp);\n if (mount.contains(renderer.domElement)) mount.removeChild(renderer.domElement);\n faceMat.map?.dispose();\n faceMat.dispose();\n sideMat.dispose();\n geometry.dispose();\n renderer.dispose();\n sceneRef.current = null;\n };\n }, []); // eslint-disable-line react-hooks/exhaustive-deps\n\n // Swap texture and edge color when coin state changes\n useEffect(() => {\n const s = sceneRef.current;\n if (!s) return;\n\n s.sideMat.color.set(EDGE_COLORS[coinState]);\n s.sideMat.needsUpdate = true;\n\n const loader = new THREE.TextureLoader();\n loader.crossOrigin = \"anonymous\";\n const oldTex = s.faceMat.map;\n loader.load(textureUrl, (tex) => {\n tex.colorSpace = THREE.SRGBColorSpace;\n s.faceMat.map = tex;\n s.faceMat.needsUpdate = true;\n oldTex?.dispose();\n });\n }, [textureUrl, coinState]);\n\n return (\n \n );\n}\n",[],[138,177,210],"74cb4c68-3a47-11f1-8fc5-42b51c65c3df","App.tsx","019d9af7-6e51-7719-b629-fc2050fca7f0",["D",1776421400152],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport MainPage from \"./MainPage.tsx\";\nimport HistoryPage from \"./HistoryPage.tsx\";\n\ntype Page = \"main\" | \"history\";\n\nfunction getPageFromHash(): Page {\n return window.location.hash === \"#/history\" ? \"history\" : \"main\";\n}\n\nexport default function App() {\n const [page, setPage] = useState(getPageFromHash);\n\n useEffect(() => {\n const handleHashChange = () => setPage(getPageFromHash());\n window.addEventListener(\"hashchange\", handleHashChange);\n return () => window.removeEventListener(\"hashchange\", handleHashChange);\n }, []);\n\n const navigate = (to: Page) => {\n window.location.hash = to === \"history\" ? \"#/history\" : \"#/\";\n setPage(to);\n };\n\n if (page === \"history\") {\n return navigate(\"main\")} />;\n }\n return navigate(\"history\")} />;\n}\n",[],[138,177,218],"74cb4af6-3a47-11f1-8fc5-42b51c65c3df","backend","019d9af7-6e51-7719-b629-fad43391d57c",["D",1776421400152],[230,231,232],[225],{"_36":263,"_13":264,"_62":265,"_64":226,"_66":67,"_68":69,"_70":71,"_38":266,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":267,"_18":268},{"_36":241,"_13":242,"_62":243,"_64":226,"_66":67,"_68":69,"_70":71,"_38":244,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":245,"_18":246},{"_36":233,"_13":234,"_62":235,"_64":226,"_66":67,"_68":69,"_70":71,"_38":236,"_17":34,"_73":237,"_75":238,"_77":52,"_78":-5,"_99":239,"_18":240},"74cb4006-3a47-11f1-8fc5-42b51c65c3df","index.ts","019d9af7-6e51-7719-b629-f7982f06b5ed",["D",1776421400152],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport savingsRoutes from \"./routes/savings.ts\";\nimport { generateIconPng } from \"./routes/icon.ts\";\n\nawait runMigrations();\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// API routes\napp.route(\"/api/savings\", savingsRoutes);\n\n// Serve transpiled frontend and shared source files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// PWA root-level files\napp.get(\"/manifest.json\", async (c) => {\n const json = await readFile(\"/frontend/manifest.json\", import.meta.url);\n return c.body(json, 200, { \"Content-Type\": \"application/manifest+json\" });\n});\n// PNG icon generated on-the-fly (iOS requires PNG, not SVG, for apple-touch-icon)\napp.get(\"/icon.png\", async (c) => {\n const sizeParam = c.req.query(\"size\");\n const size = sizeParam === \"512\" ? 512 : 192;\n const png = await generateIconPng(size);\n return c.body(png, 200, {\n \"Content-Type\": \"image/png\",\n \"Cache-Control\": \"public, max-age=604800, immutable\",\n });\n});\napp.get(\"/sw.js\", async (c) => {\n const js = await readFile(\"/frontend/sw.js\", import.meta.url);\n return c.body(js, 200, {\n \"Content-Type\": \"application/javascript\",\n \"Service-Worker-Allowed\": \"/\",\n });\n});\n\n// Serve index.html for all other routes (hash-based SPA routing)\napp.get(\"*\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;\n",[],[225,234],"74cb3e94-3a47-11f1-8fc5-42b51c65c3df","routes","019d9af7-6e51-7719-b629-f31d41cc66b4",["D",1776421400152],[247,248],[225,242],{"_36":256,"_13":257,"_62":258,"_64":243,"_66":67,"_68":69,"_70":71,"_38":259,"_17":34,"_73":74,"_75":260,"_77":52,"_78":-5,"_99":261,"_18":262},{"_36":249,"_13":250,"_62":251,"_64":243,"_66":67,"_68":69,"_70":71,"_38":252,"_17":34,"_73":74,"_75":253,"_77":52,"_78":-5,"_99":254,"_18":255},"74cb378c-3a47-11f1-8fc5-42b51c65c3df","savings.ts","019d9af7-6e51-7719-b629-efdcf4fea61a",["D",1776421400152],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { insertSaving, getSavings, getDailyChart } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n const body = await c.req.json<{ amount_cents: number }>();\n if (\n typeof body.amount_cents !== \"number\" ||\n body.amount_cents <= 0 ||\n !Number.isInteger(body.amount_cents)\n ) {\n return c.json({ error: \"amount_cents must be a positive integer\" }, 400);\n }\n const record = await insertSaving(body.amount_cents);\n return c.json(record, 201);\n});\n\n// /chart must come before / GET to avoid route conflicts\napp.get(\"/chart\", async (c) => {\n const days = await getDailyChart();\n return c.json({ days });\n});\n\napp.get(\"/\", async (c) => {\n const period = (c.req.query(\"period\") ?? \"week\") as \"day\" | \"week\" | \"month\";\n if (![\"day\", \"week\", \"month\"].includes(period)) {\n return c.json({ error: \"period must be day, week, or month\" }, 400);\n }\n const data = await getSavings(period);\n return c.json(data);\n});\n\nexport default app;\n",[],[225,242,250],"74cb23be-3a47-11f1-8fc5-42b51c65c3df","icon.ts","019d9af7-6e51-7719-b629-e881758ee53c",["D",1776421400152],"/**\n * Generates a solid-color PNG icon for the PWA.\n * Uses only built-in Deno/Web APIs — no external libraries.\n * iOS ignores SVG for apple-touch-icon, so we need a real PNG.\n *\n * Icon color: #FFCF48 (the app's yellow) → RGB (255, 207, 72)\n */\n\nconst ICON_R = 255;\nconst ICON_G = 207;\nconst ICON_B = 72;\n\n// --- CRC32 (required by the PNG spec for each chunk) ---\n\nconst CRC_TABLE = (() => {\n const t = new Uint32Array(256);\n for (let i = 0; i < 256; i++) {\n let c = i;\n for (let j = 0; j < 8; j++) c = c & 1 ? (0xedb88320 ^ (c >>> 1)) : (c >>> 1);\n t[i] = c;\n }\n return t;\n})();\n\nfunction crc32(data: Uint8Array): number {\n let crc = 0xffffffff;\n for (const byte of data) crc = CRC_TABLE[(crc ^ byte) & 0xff] ^ (crc >>> 8);\n return (crc ^ 0xffffffff) >>> 0;\n}\n\n// --- PNG chunk builder ---\n\nfunction pngChunk(type: string, data: Uint8Array): Uint8Array {\n const typeBytes = new TextEncoder().encode(type);\n const out = new Uint8Array(12 + data.length);\n const view = new DataView(out.buffer);\n view.setUint32(0, data.length); // chunk length\n out.set(typeBytes, 4); // chunk type\n out.set(data, 8); // chunk data\n const crcInput = new Uint8Array(4 + data.length);\n crcInput.set(typeBytes);\n crcInput.set(data, 4);\n view.setUint32(8 + data.length, crc32(crcInput)); // CRC\n return out;\n}\n\nfunction concat(arrays: Uint8Array[]): Uint8Array {\n const total = arrays.reduce((s, a) => s + a.length, 0);\n const out = new Uint8Array(total);\n let off = 0;\n for (const a of arrays) { out.set(a, off); off += a.length; }\n return out;\n}\n\n// --- zlib compression (required for PNG IDAT) ---\n\nasync function zlibCompress(data: Uint8Array): Promise {\n // \"deflate\" = RFC 1950 (zlib wrapper), which is what PNG IDAT requires\n const cs = new CompressionStream(\"deflate\");\n const writer = cs.writable.getWriter();\n await writer.write(data);\n await writer.close();\n const chunks: Uint8Array[] = [];\n const reader = cs.readable.getReader();\n while (true) {\n const { done, value } = await reader.read();\n if (done) break;\n chunks.push(value as Uint8Array);\n }\n return concat(chunks);\n}\n\n// --- Public API ---\n\nexport async function generateIconPng(size: number): Promise {\n // PNG signature\n const sig = new Uint8Array([137, 80, 78, 71, 13, 10, 26, 10]);\n\n // IHDR: width, height, bit-depth=8, color-type=2 (RGB), rest zeros\n const ihdr = new Uint8Array(13);\n const ihdrV = new DataView(ihdr.buffer);\n ihdrV.setUint32(0, size); // width\n ihdrV.setUint32(4, size); // height\n ihdr[8] = 8; // bit depth: 8 bits per channel\n ihdr[9] = 2; // color type: RGB (no alpha)\n\n // Raw image data: one filter byte (0 = None) per row, then RGB per pixel\n const rowLen = 1 + size * 3;\n const raw = new Uint8Array(size * rowLen);\n for (let y = 0; y < size; y++) {\n const base = y * rowLen;\n // raw[base] = 0 already (filter type None)\n for (let x = 0; x < size; x++) {\n raw[base + 1 + x * 3] = ICON_R;\n raw[base + 1 + x * 3 + 1] = ICON_G;\n raw[base + 1 + x * 3 + 2] = ICON_B;\n }\n }\n\n const compressed = await zlibCompress(raw);\n\n return concat([\n sig,\n pngChunk(\"IHDR\", ihdr),\n pngChunk(\"IDAT\", compressed),\n pngChunk(\"IEND\", new Uint8Array(0)),\n ]);\n}\n",[],[225,242,257],"74cb2274-3a47-11f1-8fc5-42b51c65c3df","database","019d9af7-6e51-7719-b629-e5e9083e5883",["D",1776421400152],[269,270],[225,264],{"_36":278,"_13":279,"_62":280,"_64":265,"_66":67,"_68":69,"_70":71,"_38":281,"_17":34,"_73":74,"_75":282,"_77":52,"_78":-5,"_99":283,"_18":284},{"_36":271,"_13":272,"_62":273,"_64":265,"_66":67,"_68":69,"_70":71,"_38":274,"_17":34,"_73":74,"_75":275,"_77":52,"_78":-5,"_99":276,"_18":277},"74cb1374-3a47-11f1-8fc5-42b51c65c3df","queries.ts","019d9af7-6e51-7719-b629-e1e804041362",["D",1776421400152],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { SavingsRecord, ChartDataPoint } from \"../../shared/types.ts\";\n\nconst TABLE = \"boymath_savings_1\";\n\nexport async function insertSaving(amount_cents: number): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE} (amount_cents) VALUES (?) RETURNING id, amount_cents, recorded_at`,\n [amount_cents],\n );\n const row = result.rows[0] as unknown as {\n id: number | bigint;\n amount_cents: number | bigint;\n recorded_at: string;\n };\n return {\n id: Number(row.id),\n amount_cents: Number(row.amount_cents),\n recorded_at: row.recorded_at,\n };\n}\n\nexport async function getSavings(\n period: \"day\" | \"week\" | \"month\",\n): Promise<{ total_cents: number; records: SavingsRecord[] }> {\n const intervalMap = {\n day: \"-1 day\",\n week: \"-7 days\",\n month: \"-30 days\",\n };\n const result = await sqlite.execute(\n `SELECT id, amount_cents, recorded_at\n FROM ${TABLE}\n WHERE recorded_at >= datetime('now', ?)\n ORDER BY recorded_at DESC`,\n [intervalMap[period]],\n );\n const records: SavingsRecord[] = (\n result.rows as unknown as Array<{\n id: number | bigint;\n amount_cents: number | bigint;\n recorded_at: string;\n }>\n ).map((row) => ({\n id: Number(row.id),\n amount_cents: Number(row.amount_cents),\n recorded_at: row.recorded_at,\n }));\n const total_cents = records.reduce((sum, r) => sum + r.amount_cents, 0);\n return { total_cents, records };\n}\n\nexport async function getDailyChart(): Promise {\n const result = await sqlite.execute(`\n SELECT date(recorded_at) as day, SUM(amount_cents) as total_cents\n FROM ${TABLE}\n WHERE recorded_at >= date('now', '-30 days')\n GROUP BY date(recorded_at)\n ORDER BY day ASC\n `);\n\n const rawDays = (\n result.rows as unknown as Array<{ day: string; total_cents: number | bigint }>\n ).map((r) => ({\n day: r.day,\n total_cents: Number(r.total_cents),\n }));\n\n // Compute 7-day rolling average over the days that have data\n return rawDays.map((row, i) => {\n const window = rawDays.slice(Math.max(0, i - 6), i + 1);\n const avg = window.reduce((sum, d) => sum + d.total_cents, 0) / window.length;\n return {\n day: row.day,\n total_cents: row.total_cents,\n rolling_avg_cents: Math.round(avg),\n };\n });\n}\n",[],[225,264,272],"74cb0e1a-3a47-11f1-8fc5-42b51c65c3df","migrations.ts","019d9af7-6e51-7719-b629-dc5b0c47c0c1",["D",1776421400152],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS boymath_savings_1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n amount_cents INTEGER NOT NULL,\n recorded_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n",[],[225,264,279],"74cb0c94-3a47-11f1-8fc5-42b51c65c3df","assets","019d9af7-6e51-7719-b629-d87bacf14cb8",["D",1776421400152],[],[286],"74cb0a96-3a47-11f1-8fc5-42b51c65c3df",".claude","019d9af7-6e51-7719-b629-d44482c69526",["D",1776421400152],[297],[292],{"_36":298,"_13":299,"_62":300,"_64":293,"_66":67,"_68":69,"_70":71,"_38":301,"_17":34,"_73":24,"_75":302,"_77":52,"_78":-5,"_99":303,"_18":304},"74caec96-3a47-11f1-8fc5-42b51c65c3df","settings.local.json","019d9af7-6e51-7719-b629-d131c1bb0ec5",["D",1776421400152],"{\n \"permissions\": {\n \"allow\": [\n \"mcp__plugin_discord_discord__reply\",\n \"mcp__figma__get_design_context\",\n \"WebFetch(domain:docs.val.town)\"\n ]\n }\n}\n",[],[292,299],["D",1776338448663],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","019a1633-2013-759e-8afb-72b87d8e75e3","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","51d7ce64398611f1b93b42b51c65c3df","tursoHostname","51d7ce64398611f1b93b42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789506093912],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_348":344},"org",{"_11":12,"_342":-5,"_343":344,"_310":311,"_345":346,"_347":52},"branch",{"_17":212,"_13":16,"_36":67,"_43":44,"_46":37,"_47":45,"_339":54,"_340":44,"_341":57,"_58":14,"_55":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/f5d90c6c-8ea7-493d-4a3e-abb94ff90b00/square512?exp=1789563599&sig=15a658248aadc3dcc9ab82cb08a4374c5bb3200a92ad455abdccab1299fe23e8","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":44,"_13":14,"_38":471,"_50":-5,"_306":52,"_53":54,"_307":54,"_308":-5,"_309":-5,"_310":311,"_312":-5,"_313":52,"_314":-5,"_315":-5,"_316":34,"_56":57,"_317":318,"_319":320,"_321":472,"_323":-5,"_324":325,"_326":325,"_327":328,"_329":328,"_330":328,"_331":325,"_332":325,"_333":473,"_335":474,"_337":475,"_51":52},[384,386,387,395,406,408,409,410,411,412],"files",[384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412],"counts",{"_375":34,"_376":190,"_377":34,"_35":378,"_379":380},[373],{"_36":80,"_66":67,"_62":65,"_13":19,"_75":-5,"_73":82,"_17":34,"_64":-5,"_38":371,"_68":69,"_78":-5,"_18":372},"upstreamProject","upstreamBranch",{"_36":37,"_38":369,"_40":370,"_13":42,"_43":44,"_17":45,"_46":-5,"_47":-5,"_48":49,"_50":-5,"_51":52,"_53":54,"_55":12,"_56":57,"_58":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1776338448663],["D",1776411679206],["D",1776421400152],[19],{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":72,"_17":34,"_73":74,"_75":76,"_77":52,"_78":-5,"_18":374},[19,61],"pulls","branches","forks",{"_381":34,"_383":34},"connections",{"_381":34,"_382":34},"count","unfilledCount","emptyCount",{"_36":291,"_13":292,"_62":293,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":294,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":469,"_18":470},{"_36":298,"_13":299,"_62":300,"_64":293,"_66":67,"_68":69,"_70":71,"_38":301,"_17":34,"_73":24,"_75":302,"_77":52,"_78":-5,"_99":467,"_18":468},{"_36":285,"_13":286,"_62":287,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":288,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":465,"_18":466},{"_36":224,"_13":225,"_62":226,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":227,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":463,"_18":464},{"_36":263,"_13":264,"_62":265,"_64":226,"_66":67,"_68":69,"_70":71,"_38":266,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":461,"_18":462},{"_36":278,"_13":279,"_62":280,"_64":265,"_66":67,"_68":69,"_70":71,"_38":281,"_17":34,"_73":74,"_75":282,"_77":52,"_78":-5,"_99":459,"_18":460},{"_36":271,"_13":272,"_62":273,"_64":265,"_66":67,"_68":69,"_70":71,"_38":274,"_17":34,"_73":74,"_75":275,"_77":52,"_78":-5,"_99":457,"_18":458},{"_36":241,"_13":242,"_62":243,"_64":226,"_66":67,"_68":69,"_70":71,"_38":244,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":455,"_18":456},{"_36":256,"_13":257,"_62":258,"_64":243,"_66":67,"_68":69,"_70":71,"_38":259,"_17":34,"_73":74,"_75":260,"_77":52,"_78":-5,"_99":453,"_18":454},{"_36":249,"_13":250,"_62":251,"_64":243,"_66":67,"_68":69,"_70":71,"_38":252,"_17":34,"_73":74,"_75":253,"_77":52,"_78":-5,"_99":451,"_18":452},{"_36":233,"_13":234,"_62":235,"_64":226,"_66":67,"_68":69,"_70":71,"_38":236,"_17":34,"_73":237,"_75":238,"_77":52,"_78":-5,"_99":449,"_18":450},{"_36":137,"_13":138,"_62":139,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":140,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":447,"_18":448},{"_36":176,"_13":177,"_62":178,"_64":139,"_66":67,"_68":69,"_70":71,"_38":179,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":445,"_18":446},{"_36":217,"_13":218,"_62":219,"_64":178,"_66":67,"_68":69,"_70":71,"_38":220,"_17":34,"_73":74,"_75":221,"_77":52,"_78":-5,"_99":443,"_18":444},{"_36":209,"_13":210,"_62":211,"_64":178,"_66":67,"_68":212,"_70":71,"_38":213,"_17":34,"_73":74,"_75":214,"_77":52,"_78":-5,"_99":441,"_18":442},{"_36":202,"_13":203,"_62":204,"_64":178,"_66":67,"_68":32,"_70":71,"_38":205,"_17":69,"_73":74,"_75":206,"_77":52,"_78":-5,"_99":439,"_18":440},{"_36":195,"_13":196,"_62":197,"_64":178,"_66":67,"_68":69,"_70":71,"_38":198,"_17":34,"_73":74,"_75":199,"_77":52,"_78":-5,"_99":437,"_18":438},{"_36":187,"_13":188,"_62":189,"_64":178,"_66":67,"_68":190,"_70":71,"_38":191,"_17":69,"_73":74,"_75":192,"_77":52,"_78":-5,"_99":435,"_18":436},{"_36":169,"_13":170,"_62":171,"_64":139,"_66":67,"_68":69,"_70":71,"_38":172,"_17":34,"_73":24,"_75":173,"_77":52,"_78":-5,"_99":433,"_18":434},{"_36":162,"_13":163,"_62":164,"_64":139,"_66":67,"_68":69,"_70":71,"_38":165,"_17":34,"_73":74,"_75":166,"_77":52,"_78":-5,"_99":431,"_18":432},{"_36":155,"_13":156,"_62":157,"_64":139,"_66":67,"_68":69,"_70":71,"_38":158,"_17":34,"_73":24,"_75":159,"_77":52,"_78":-5,"_99":429,"_18":430},{"_36":148,"_13":149,"_62":150,"_64":139,"_66":67,"_68":69,"_70":71,"_38":151,"_17":34,"_73":74,"_75":152,"_77":52,"_78":-5,"_99":427,"_18":428},{"_36":80,"_13":19,"_62":65,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":130,"_17":34,"_73":82,"_75":-5,"_77":52,"_78":-5,"_99":425,"_18":426},{"_36":60,"_13":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_38":134,"_17":34,"_73":74,"_75":76,"_77":52,"_78":-5,"_99":423,"_18":424},{"_36":123,"_13":124,"_62":125,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":126,"_17":34,"_73":24,"_75":127,"_77":52,"_78":-5,"_99":421,"_18":422},{"_36":116,"_13":117,"_62":118,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":119,"_17":34,"_73":24,"_75":120,"_77":52,"_78":-5,"_99":419,"_18":420},{"_36":109,"_13":110,"_62":111,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":112,"_17":34,"_73":24,"_75":113,"_77":52,"_78":-5,"_99":417,"_18":418},{"_36":102,"_13":103,"_62":104,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":105,"_17":34,"_73":24,"_75":106,"_77":52,"_78":-5,"_99":415,"_18":416},{"_36":94,"_13":95,"_62":96,"_64":-5,"_66":67,"_68":69,"_70":71,"_38":97,"_17":34,"_73":24,"_75":98,"_77":52,"_78":-5,"_99":413,"_18":414},[],[95],[],[103],[],[110],[],[117],[],[124],[],[19,61],[407],[19],[],[138,149],[],[138,156],[],[138,163],[],[138,170],[],[138,177,188],[],[138,177,196],[],[138,177,203],[],[138,177,210],[],[138,177,218],[397,398,399,400,401],[138,177],[396,402,403,404,405],[138],[],[225,234],[],[225,242,250],[],[225,242,257],[392,393],[225,242],[],[225,264,272],[],[225,264,279],[389,390],[225,264],[388,391,394],[225],[],[286],[],[292,299],[385],[292],["D",1776338448663],["D",1789506093912],{"_11":12,"_348":344},{"_11":12,"_342":-5,"_343":344,"_310":311,"_345":346,"_347":52},{"_17":212,"_13":16,"_36":67,"_43":44,"_46":37,"_47":45,"_339":54,"_340":44,"_341":57,"_58":14,"_55":12},"ctx",{"_333":-5,"_366":509,"_510":511,"_512":513,"_514":52,"_515":52,"_516":52,"_517":71,"_518":-5,"_519":-7,"_520":-7,"_521":34,"_522":52,"_523":52,"_524":-5,"_525":52,"_526":52,"_527":52,"_528":-5},"ENV",{"_480":481,"_482":483,"_484":42,"_485":486,"_487":488,"_489":490,"_491":492,"_493":494,"_495":496,"_497":498,"_499":500,"_501":502,"_503":504,"_505":506,"_507":508},"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"]