BudgetApp

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_338":339,"_340":341},"routes/_app.x.$handle.$name",{"_97":96,"_32":43,"_105":87,"_27":51,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":26,"_119":120,"_121":26,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_32":43,"_36":44,"_45":-5,"_46":26,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":26},"version",19,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":26},"previous","deleted",true,"deletedHere",false,"path","README.md","latestPath","fileId","c4e28450-af04-11f1-83ee-1607ee4eb77e","name","fileType","content","# BudgetApp\n\nA private household cash-flow web app built with Val Town, TypeScript, React,\nHono and val-scoped Val Town SQLite.\n\nThe dashboard answers what cash exists now, what is still expected or\ncommitted this month, what is protected, and what remains safe to spend.\n\n## MVP features\n\n- Val Town OAuth with owner/family allowlisting\n- accounts and current balances\n- manual income and expenses with edit/delete balance reversal\n- recurring and one-off planned income/expenses\n- mark planned items paid/received\n- protected reserves\n- projected month-end and safe-to-spend dashboard\n- responsive mobile/desktop React UI\n- explicit synthetic demo dataset\n- pure financial calculation tests\n\nAll persisted money uses integer EUR cents. See\n[`docs/financial-semantics.md`](docs/financial-semantics.md) for the exact\ncalculation rules and [`ROADMAP.md`](ROADMAP.md) for deferred imports, Open\nBanking and React Native work.\n\n## Local checks\n\n```sh\nnpm ci\nnpm run check\n```\n\nThe deployed module graph can also be checked with Deno:\n\n```sh\ndeno check --allow-import=esm.town,esm.sh index.ts frontend/index.tsx\n```\n\nNo real financial data, statements or credentials belong in this repository.\n\n## Deployment\n\nGitHub `main` is the source of truth. `.github/workflows/deploy.yml` tests the\napp and runs `vt push` on every push.\n\nInitial setup:\n\n1. Store a val read/write token as the GitHub Actions secret\n `VAL_TOWN_API_KEY`.\n2. Push to `main`. The first workflow run creates the public-code `budget-app`\n val, deploys it and commits its non-secret `.vt/state.json` project identity.\n Financial API routes remain protected by OAuth and owner allowlisting.\n3. Optionally set `BUDGET_APP_ALLOWED_USERS` in the Val Town environment to a\n comma-separated list of additional family Val Town usernames. The val owner\n is always allowed.\n4. Later pushes test and deploy the exact Git revision.\n\nNever edit production code only in the Val Town web editor: the next GitHub\ndeployment intentionally overwrites it.\n","createdAt",["D",1789257044227],"branchVersion","branchId","037d44a6-73d2-4260-bb85-513aa40dbefe","id","bc270bf3-6831-493b-a6bf-e8bca9c639c8","budget-app",["D",1789257041201],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","019bc8c8-8bb9-72ff-96b5-3323d5278042","pinnedFileId","c47a5506-af04-11f1-b536-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019bc8c8-8bba-72f3-b7c5-f4447a4e9cc4","tursoName","bc270bf36831493ba6bfe8bca9c639c8","tursoHostname","bc270bf36831493ba6bfe8bca9c639c8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789458074143],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":53,"_101":102,"_103":26},"branch",{"_13":86,"_32":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"isOwned",40,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","lehmann","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOE1CeERUd200ZFR6UURGWVJMalVQejNuWDMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_41":42,"_32":43,"_36":333,"_45":-5,"_46":26,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":334,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":335,"_81":336,"_83":337,"_85":26},"tree",[212,218,221,224,225,226,227,228,229,230],"files",[212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230],"counts",{"_202":60,"_203":187,"_204":60,"_205":206,"_207":208},"contents",[126,127,128,129,130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":196,"_32":197,"_30":198,"_138":-5,"_39":40,"_38":199,"_140":24,"_36":200,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_27":201},{"_41":190,"_32":191,"_30":192,"_138":-5,"_39":40,"_38":193,"_140":24,"_36":194,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_27":195},{"_41":184,"_32":185,"_30":186,"_138":-5,"_39":40,"_38":187,"_140":24,"_36":188,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_27":189},{"_41":177,"_32":178,"_30":179,"_138":-5,"_39":40,"_38":180,"_140":26,"_36":181,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_27":183},{"_41":170,"_32":171,"_30":172,"_138":-5,"_39":40,"_38":173,"_140":26,"_36":174,"_13":60,"_33":20,"_34":175,"_23":26,"_144":-5,"_27":176},{"_41":163,"_32":164,"_30":165,"_138":-5,"_39":40,"_38":166,"_140":26,"_36":167,"_13":60,"_33":20,"_34":168,"_23":26,"_144":-5,"_27":169},{"_41":160,"_32":28,"_30":31,"_138":-5,"_39":40,"_38":14,"_140":26,"_36":161,"_13":60,"_33":20,"_34":35,"_23":26,"_144":-5,"_27":162},{"_41":153,"_32":154,"_30":155,"_138":-5,"_39":40,"_38":156,"_140":26,"_36":157,"_13":60,"_33":20,"_34":158,"_23":26,"_144":-5,"_27":159},{"_41":146,"_32":147,"_30":148,"_138":-5,"_39":40,"_38":149,"_140":26,"_36":150,"_13":60,"_33":20,"_34":151,"_23":26,"_144":-5,"_27":152},{"_41":136,"_32":137,"_30":55,"_138":-5,"_39":40,"_38":139,"_140":26,"_36":141,"_13":60,"_33":142,"_34":143,"_23":26,"_144":-5,"_27":145},"d442bc46-675c-4505-be41-efd5e455c4d0","index.ts","parentId",7,"latest",["D",1789257043601],"script","import { Hono } from \"npm:hono@4.9.2\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { assertDateOnly, householdDate } from \"./shared/finance.ts\";\nimport { Root } from \"./frontend/root.tsx\";\nimport {\n completePlanned,\n createAccount,\n createPlanned,\n createReserve,\n createTransaction,\n deleteAccount,\n deletePlanned,\n deleteReserve,\n deleteTransaction,\n getAppData,\n seedDemoData,\n updateAccount,\n updatePlanned,\n updateReserve,\n updateTransaction,\n} from \"./server/repository.ts\";\nimport {\n booleanField,\n centsField,\n dateField,\n enumField,\n integerField,\n objectBody,\n optionalString,\n signedCentsField,\n stringField,\n} from \"./server/validation.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.html(Root()));\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal(import.meta.url).links.self.val));\n\napp.get(\"/api/session\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.json({ authenticated: false, authorized: false });\n return c.json({\n authenticated: true,\n authorized: isAuthorized(session.user.username),\n username: session.user.username,\n });\n});\n\napp.use(\"/api/*\", async (c, next) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.json({ error: \"Authentication required\" }, 401);\n if (!isAuthorized(session.user.username)) return c.json({ error: \"This Val Town account is not allowed\" }, 403);\n if (![\"GET\", \"HEAD\", \"OPTIONS\"].includes(c.req.method)) {\n const origin = c.req.header(\"Origin\");\n const expectedOrigin = new URL(c.req.url).origin;\n if (origin !== expectedOrigin || c.req.header(\"X-BudgetApp-Request\") !== \"1\") {\n return c.json({ error: \"Invalid request origin\" }, 403);\n }\n }\n await next();\n});\n\napp.get(\"/api/data\", async (c) => {\n const asOf = c.req.query(\"asOf\") || householdDate();\n assertDateOnly(asOf);\n return c.json(await getAppData(asOf));\n});\n\napp.post(\"/api/accounts\", async (c) => {\n const body = await readBody(c.req.raw);\n await createAccount({\n name: stringField(body, \"name\", 80),\n type: enumField(body, \"type\", [\"checking\", \"savings\", \"cash\"] as const),\n balanceCents: signedCentsField(body, \"balanceCents\"),\n });\n return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/accounts/:id\", async (c) => {\n const body = await readBody(c.req.raw);\n await updateAccount(safeId(c.req.param(\"id\")), {\n name: stringField(body, \"name\", 80),\n type: enumField(body, \"type\", [\"checking\", \"savings\", \"cash\"] as const),\n balanceCents: signedCentsField(body, \"balanceCents\"),\n isActive: booleanField(body, \"isActive\", true),\n });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/accounts/:id\", async (c) => {\n await deleteAccount(safeId(c.req.param(\"id\")));\n return c.body(null, 204);\n});\n\napp.post(\"/api/transactions\", async (c) => {\n const body = await readBody(c.req.raw);\n await createTransaction({\n accountId: safeId(stringField(body, \"accountId\", 64)),\n date: dateField(body, \"date\"),\n amountCents: centsField(body),\n description: stringField(body, \"description\", 160),\n kind: enumField(body, \"kind\", [\"income\", \"expense\"] as const),\n });\n return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/transactions/:id\", async (c) => {\n const body = await readBody(c.req.raw);\n await updateTransaction(safeId(c.req.param(\"id\")), {\n accountId: safeId(stringField(body, \"accountId\", 64)),\n date: dateField(body, \"date\"),\n amountCents: centsField(body),\n description: stringField(body, \"description\", 160),\n kind: enumField(body, \"kind\", [\"income\", \"expense\"] as const),\n });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/transactions/:id\", async (c) => {\n await deleteTransaction(safeId(c.req.param(\"id\")));\n return c.body(null, 204);\n});\n\napp.post(\"/api/planned\", async (c) => {\n const body = await readBody(c.req.raw);\n await createPlanned(plannedInput(body));\n return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/planned/:id\", async (c) => {\n await updatePlanned(safeId(c.req.param(\"id\")), plannedInput(await readBody(c.req.raw)));\n return c.json({ ok: true });\n});\n\napp.post(\"/api/planned/:id/complete\", async (c) => {\n const body = await readBody(c.req.raw);\n const accountId = optionalString(body, \"accountId\", 64);\n await completePlanned(\n safeId(c.req.param(\"id\")),\n dateField(body, \"date\"),\n accountId ? safeId(accountId) : null,\n );\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/planned/:id\", async (c) => {\n await deletePlanned(safeId(c.req.param(\"id\")));\n return c.body(null, 204);\n});\n\napp.post(\"/api/reserves\", async (c) => {\n const body = await readBody(c.req.raw);\n await createReserve({\n name: stringField(body, \"name\", 80),\n amountCents: centsField(body, \"amountCents\", true),\n note: optionalString(body, \"note\", 300) ?? \"\",\n });\n return c.json({ ok: true }, 201);\n});\n\napp.put(\"/api/reserves/:id\", async (c) => {\n const body = await readBody(c.req.raw);\n await updateReserve(safeId(c.req.param(\"id\")), {\n name: stringField(body, \"name\", 80),\n amountCents: centsField(body, \"amountCents\", true),\n note: optionalString(body, \"note\", 300) ?? \"\",\n isActive: booleanField(body, \"isActive\", true),\n });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/reserves/:id\", async (c) => {\n await deleteReserve(safeId(c.req.param(\"id\")));\n return c.body(null, 204);\n});\n\napp.post(\"/api/demo\", async (c) => c.json({ seeded: await seedDemoData() }));\n\napp.notFound((c) => c.json({ error: \"Not found\" }, 404));\napp.onError((error, c) => {\n const status = Number((error as Error & { status?: number }).status) ||\n (/constraint/i.test(error.message) ? 409 : error instanceof SyntaxError ? 400 : 500);\n if (status >= 500) console.error(\"BudgetApp request failed\", error.name, error.message);\n return c.json({ error: status >= 500 ? \"Unexpected server error\" : error.message }, status as 400);\n});\n\nfunction isAuthorized(username: string | null): boolean {\n if (!username) return false;\n const owner = parseVal(import.meta.url).username.toLowerCase();\n const extras = (Deno.env.get(\"BUDGET_APP_ALLOWED_USERS\") ?? \"\")\n .split(\",\")\n .map((value) => value.trim().toLowerCase())\n .filter(Boolean);\n return username.toLowerCase() === owner || extras.includes(username.toLowerCase());\n}\n\nasync function readBody(request: Request): Promise> {\n const length = Number(request.headers.get(\"content-length\") ?? 0);\n if (length > 32_000) throw Object.assign(new Error(\"Request body is too large\"), { status: 413 });\n return objectBody(await request.json());\n}\n\nfunction safeId(value: string): string {\n if (!/^[0-9a-f-]{36}$/i.test(value)) throw new Error(\"Invalid id\");\n return value;\n}\n\nfunction plannedInput(body: Record) {\n const accountId = optionalString(body, \"accountId\", 64);\n const nextDate = dateField(body, \"nextDate\");\n const endDate = optionalString(body, \"endDate\", 10);\n if (endDate) {\n assertDateOnly(endDate);\n if (endDate < nextDate) throw new Error(\"endDate cannot be before nextDate\");\n }\n return {\n accountId: accountId ? safeId(accountId) : null,\n description: stringField(body, \"description\", 160),\n kind: enumField(body, \"kind\", [\"income\", \"expense\"] as const),\n amountCents: centsField(body),\n recurrence: enumField(body, \"recurrence\", [\"once\", \"weekly\", \"monthly\", \"yearly\"] as const),\n intervalCount: integerField(body, \"intervalCount\"),\n nextDate,\n endDate,\n isActive: booleanField(body, \"isActive\", true),\n };\n}\n\nexport default oauthMiddleware(app.fetch);\n","label",[137],"a7f6c204-ac1d-49a6-bed8-b2a2ac066e4e","deno.json","c4748054-af04-11f1-9abb-1607ee4eb77e",6,["D",1789257043582],"{\n \"nodeModulesDir\": \"auto\",\n \"compilerOptions\": {\n \"strict\": true,\n \"noImplicitOverride\": true\n },\n \"imports\": {\n \"hono\": \"npm:hono@4.9.2\"\n },\n \"exclude\": [\"node_modules\", \"tests\"]\n}\n",[147],"174ddeda-73da-4234-80ad-f45d93880e4f","ROADMAP.md","c4ab3cfc-af04-11f1-8508-1607ee4eb77e",13,["D",1789257043906],"# Roadmap\n\n## Next: statement imports\n\n- CSV/XLSX upload validation and configurable column mapping.\n- Deterministic import identity and duplicate preview.\n- Transactional import with import history and row-level errors.\n- Explicit internal-transfer matching and manual transfer entry.\n\n## Later\n\n- Account balance reconciliation workflow.\n- Search and filters for larger transaction histories.\n- Export/backup tools.\n- Regulated EU Open Banking aggregator adapter feeding the same canonical\n transaction pipeline. No direct bank credential handling.\n- Android notification adapter.\n\nReact Native is intentionally deferred until the web workflow is proven.\n",[154],"18060532-8e01-42a3-9fec-5a5083a11fa8",["D",1789257044227],[28],"3549ffc3-16b6-4f37-b6b1-f17dcb8c60c5",".vtignore","c498fea2-af04-11f1-9d2b-1607ee4eb77e",10,["D",1789257043606],".git/\n.github/\nnode_modules/\ntests/\npackage-lock.json\npackage.json\ntsconfig.json\ndocs/\n.env*\n",[164],"1b4af391-9f6e-4cde-9ef9-703eed8aa9ba",".gitignore","c4d39f3a-af04-11f1-bb78-1607ee4eb77e",17,["D",1789257044174],"node_modules/\n.deno/\n.env\n.env.*\n!.env.example\n.vt/*\n!.vt/state.json\ncoverage/\n*.lcov\n*.log\n",[171],"26cb4ec9-894b-4fa0-b14c-c30c524de683","types","c455a42c-af04-11f1-9abb-1607ee4eb77e",4,["D",1789257043375],"directory",[178],"65021267-97d2-46c5-a1f1-8e3430d2e5b8","shared","c42952fa-af04-11f1-83ee-1607ee4eb77e",1,["D",1789257043083],[185],"ccf57a66-c3e0-4a52-9c44-82a68ddbe0ec","server","c448cf40-af04-11f1-9abb-1607ee4eb77e",3,["D",1789257043295],[191],"e62562cf-b974-4924-a7ea-327aaca48cfe","frontend","c43a05aa-af04-11f1-9abb-1607ee4eb77e",2,["D",1789257043196],[197],"pulls","branches","forks","envVars",{"_209":60,"_211":60},"connections",{"_209":60,"_210":60},"count","unfilledCount","emptyCount",{"_41":196,"_32":197,"_30":198,"_138":-5,"_39":40,"_38":199,"_140":24,"_36":330,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_232":331,"_27":332},{"_41":325,"_32":324,"_30":318,"_138":198,"_39":40,"_38":326,"_140":24,"_36":327,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_232":328,"_27":329},{"_41":315,"_32":316,"_30":317,"_138":318,"_39":40,"_38":319,"_140":26,"_36":320,"_13":60,"_33":142,"_34":321,"_23":26,"_144":-5,"_232":322,"_27":323},{"_41":307,"_32":308,"_30":309,"_138":198,"_39":40,"_38":310,"_140":24,"_36":311,"_13":60,"_33":20,"_34":312,"_23":26,"_144":-5,"_232":313,"_27":314},{"_41":299,"_32":300,"_30":301,"_138":198,"_39":40,"_38":302,"_140":24,"_36":303,"_13":60,"_33":142,"_34":304,"_23":26,"_144":-5,"_232":305,"_27":306},{"_41":291,"_32":292,"_30":293,"_138":198,"_39":40,"_38":294,"_140":24,"_36":295,"_13":60,"_33":142,"_34":296,"_23":26,"_144":-5,"_232":297,"_27":298},{"_41":190,"_32":191,"_30":192,"_138":-5,"_39":40,"_38":193,"_140":24,"_36":288,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_232":289,"_27":290},{"_41":280,"_32":281,"_30":282,"_138":192,"_39":40,"_38":283,"_140":26,"_36":284,"_13":60,"_33":142,"_34":285,"_23":26,"_144":-5,"_232":286,"_27":287},{"_41":272,"_32":273,"_30":274,"_138":192,"_39":40,"_38":275,"_140":26,"_36":276,"_13":60,"_33":142,"_34":277,"_23":26,"_144":-5,"_232":278,"_27":279},{"_41":184,"_32":185,"_30":186,"_138":-5,"_39":40,"_38":187,"_140":24,"_36":269,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_232":270,"_27":271},{"_41":261,"_32":262,"_30":263,"_138":186,"_39":40,"_38":264,"_140":24,"_36":265,"_13":60,"_33":142,"_34":266,"_23":26,"_144":-5,"_232":267,"_27":268},{"_41":253,"_32":254,"_30":255,"_138":186,"_39":40,"_38":256,"_140":26,"_36":257,"_13":60,"_33":142,"_34":258,"_23":26,"_144":-5,"_232":259,"_27":260},{"_41":177,"_32":178,"_30":179,"_138":-5,"_39":40,"_38":180,"_140":26,"_36":250,"_13":60,"_33":182,"_34":-5,"_23":26,"_144":-5,"_232":251,"_27":252},{"_41":170,"_32":171,"_30":172,"_138":-5,"_39":40,"_38":173,"_140":26,"_36":247,"_13":60,"_33":20,"_34":175,"_23":26,"_144":-5,"_232":248,"_27":249},{"_41":163,"_32":164,"_30":165,"_138":-5,"_39":40,"_38":166,"_140":26,"_36":244,"_13":60,"_33":20,"_34":168,"_23":26,"_144":-5,"_232":245,"_27":246},{"_41":160,"_32":28,"_30":31,"_138":-5,"_39":40,"_38":14,"_140":26,"_36":241,"_13":60,"_33":20,"_34":35,"_23":26,"_144":-5,"_232":242,"_27":243},{"_41":153,"_32":154,"_30":155,"_138":-5,"_39":40,"_38":156,"_140":26,"_36":238,"_13":60,"_33":20,"_34":158,"_23":26,"_144":-5,"_232":239,"_27":240},{"_41":146,"_32":147,"_30":148,"_138":-5,"_39":40,"_38":149,"_140":26,"_36":235,"_13":60,"_33":20,"_34":151,"_23":26,"_144":-5,"_232":236,"_27":237},{"_41":136,"_32":137,"_30":55,"_138":-5,"_39":40,"_38":139,"_140":26,"_36":231,"_13":60,"_33":142,"_34":143,"_23":26,"_144":-5,"_232":233,"_27":234},["D",1789257043601],"children",[],[137],["D",1789257043582],[],[147],["D",1789257043906],[],[154],["D",1789257044227],[],[28],["D",1789257043606],[],[164],["D",1789257044174],[],[171],["D",1789257043375],[],[178],"7db8a218-3b14-431d-b989-8d885b7c36c0","types.ts","c482b91c-af04-11f1-bb78-1607ee4eb77e",8,["D",1789257043653],"export type AccountType = \"checking\" | \"savings\" | \"cash\";\nexport type TransactionKind = \"income\" | \"expense\" | \"refund\" | \"transfer\";\nexport type TransactionStatus = \"cleared\" | \"pending\";\nexport type Recurrence = \"once\" | \"weekly\" | \"monthly\" | \"yearly\";\nexport type PlannedKind = \"income\" | \"expense\";\n\nexport interface Account {\n id: string;\n name: string;\n type: AccountType;\n currency: string;\n balanceCents: number;\n isActive: boolean;\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface Transaction {\n id: string;\n accountId: string;\n date: string;\n amountCents: number;\n currency: string;\n description: string;\n kind: TransactionKind;\n status: TransactionStatus;\n source: \"manual\" | \"import\" | \"planned\";\n transferGroupId: string | null;\n plannedTransactionId: string | null;\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface PlannedTransaction {\n id: string;\n accountId: string | null;\n description: string;\n kind: PlannedKind;\n amountCents: number;\n currency: string;\n recurrence: Recurrence;\n intervalCount: number;\n nextDate: string;\n endDate: string | null;\n isActive: boolean;\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface Reserve {\n id: string;\n name: string;\n amountCents: number;\n currency: string;\n note: string;\n isActive: boolean;\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface PlannedOccurrence {\n plannedTransactionId: string;\n description: string;\n kind: PlannedKind;\n amountCents: number;\n date: string;\n}\n\nexport interface DashboardSummary {\n asOfDate: string;\n monthStart: string;\n monthEnd: string;\n currentCashCents: number;\n spentThisMonthCents: number;\n remainingIncomeCents: number;\n remainingExpensesCents: number;\n protectedReservesCents: number;\n projectedMonthEndCents: number;\n safeToSpendCents: number;\n upcoming: PlannedOccurrence[];\n}\n\nexport interface AppData {\n dashboard: DashboardSummary;\n accounts: Account[];\n transactions: Transaction[];\n plannedTransactions: PlannedTransaction[];\n reserves: Reserve[];\n}\n",[],[185,254],"b2a40611-5738-4b92-8324-d42002a33263","finance.ts","c4dbe0aa-af04-11f1-800c-1607ee4eb77e",18,["D",1789257043587],"import type {\n Account,\n DashboardSummary,\n PlannedOccurrence,\n PlannedTransaction,\n Reserve,\n Transaction,\n} from \"./types.ts\";\n\nconst DATE_RE = /^\\d{4}-\\d{2}-\\d{2}$/;\n\nexport function assertDateOnly(value: string): void {\n if (!DATE_RE.test(value)) throw new Error(\"Date must use YYYY-MM-DD\");\n const [year, month, day] = value.split(\"-\").map(Number);\n const parsed = new Date(Date.UTC(year, month - 1, day));\n if (\n parsed.getUTCFullYear() !== year ||\n parsed.getUTCMonth() !== month - 1 ||\n parsed.getUTCDate() !== day\n ) throw new Error(\"Date is invalid\");\n}\n\nexport function householdDate(now = new Date(), timeZone = \"Europe/Rome\"): string {\n return new Intl.DateTimeFormat(\"en-CA\", {\n timeZone,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n }).format(now);\n}\n\nexport function monthBounds(date: string): { start: string; end: string } {\n assertDateOnly(date);\n const [year, month] = date.split(\"-\").map(Number);\n return {\n start: `${year}-${String(month).padStart(2, \"0\")}-01`,\n end: formatUtcDate(new Date(Date.UTC(year, month, 0))),\n };\n}\n\nexport function addRecurrence(\n date: string,\n recurrence: PlannedTransaction[\"recurrence\"],\n intervalCount: number,\n): string | null {\n assertDateOnly(date);\n if (recurrence === \"once\") return null;\n if (!Number.isInteger(intervalCount) || intervalCount < 1) throw new Error(\"Interval must be a positive integer\");\n const [year, month, day] = date.split(\"-\").map(Number);\n if (recurrence === \"weekly\") {\n return formatUtcDate(new Date(Date.UTC(year, month - 1, day + 7 * intervalCount)));\n }\n if (recurrence === \"monthly\") {\n const targetMonthStart = new Date(Date.UTC(year, month - 1 + intervalCount, 1));\n const targetYear = targetMonthStart.getUTCFullYear();\n const targetMonth = targetMonthStart.getUTCMonth();\n const lastDay = new Date(Date.UTC(targetYear, targetMonth + 1, 0)).getUTCDate();\n return formatUtcDate(new Date(Date.UTC(targetYear, targetMonth, Math.min(day, lastDay))));\n }\n const targetYear = year + intervalCount;\n const lastDay = new Date(Date.UTC(targetYear, month, 0)).getUTCDate();\n return formatUtcDate(new Date(Date.UTC(targetYear, month - 1, Math.min(day, lastDay))));\n}\n\nexport function occurrencesBetween(\n item: PlannedTransaction,\n fromDate: string,\n toDate: string,\n): PlannedOccurrence[] {\n if (!item.isActive || item.nextDate > toDate || (item.endDate && item.nextDate > item.endDate)) return [];\n const occurrences: PlannedOccurrence[] = [];\n let cursor: string | null = item.nextDate;\n let guard = 0;\n while (cursor && cursor <= toDate && (!item.endDate || cursor <= item.endDate)) {\n if (cursor >= fromDate) {\n occurrences.push({\n plannedTransactionId: item.id,\n description: item.description,\n kind: item.kind,\n amountCents: item.amountCents,\n date: cursor,\n });\n }\n cursor = addRecurrence(cursor, item.recurrence, item.intervalCount);\n if (++guard > 400) throw new Error(\"Recurrence produced too many occurrences\");\n }\n return occurrences;\n}\n\nexport function calculateDashboard(input: {\n asOfDate: string;\n accounts: Account[];\n transactions: Transaction[];\n plannedTransactions: PlannedTransaction[];\n reserves: Reserve[];\n}): DashboardSummary {\n const { start, end } = monthBounds(input.asOfDate);\n const currentCashCents = sum(input.accounts.filter((a) => a.isActive), (a) => a.balanceCents);\n const monthTransactions = input.transactions.filter(\n (t) => t.status === \"cleared\" && t.date >= start && t.date <= input.asOfDate && t.kind !== \"transfer\",\n );\n const grossExpenses = sum(monthTransactions.filter((t) => t.kind === \"expense\"), (t) => Math.abs(t.amountCents));\n const refunds = sum(monthTransactions.filter((t) => t.kind === \"refund\"), (t) => Math.abs(t.amountCents));\n const spentThisMonthCents = Math.max(0, grossExpenses - refunds);\n const upcoming = input.plannedTransactions\n // nextDate is the earliest unpaid occurrence, so overdue items remain\n // committed until explicitly completed rather than disappearing at midnight.\n .flatMap((item) => occurrencesBetween(item, item.nextDate, end))\n .sort((a, b) => a.date.localeCompare(b.date) || a.description.localeCompare(b.description));\n const remainingIncomeCents = sum(upcoming.filter((o) => o.kind === \"income\"), (o) => o.amountCents);\n const remainingExpensesCents = sum(upcoming.filter((o) => o.kind === \"expense\"), (o) => o.amountCents);\n const protectedReservesCents = sum(input.reserves.filter((r) => r.isActive), (r) => r.amountCents);\n const projectedMonthEndCents = currentCashCents + remainingIncomeCents - remainingExpensesCents;\n const safeToSpendCents = projectedMonthEndCents - protectedReservesCents;\n\n return {\n asOfDate: input.asOfDate,\n monthStart: start,\n monthEnd: end,\n currentCashCents,\n spentThisMonthCents,\n remainingIncomeCents,\n remainingExpensesCents,\n protectedReservesCents,\n projectedMonthEndCents,\n safeToSpendCents,\n upcoming,\n };\n}\n\nfunction sum(items: T[], value: (item: T) => number): number {\n return items.reduce((total, item) => total + value(item), 0);\n}\n\nfunction formatUtcDate(date: Date): string {\n return date.toISOString().slice(0, 10);\n}\n",[],[185,262],["D",1789257043083],[222,223],[185],"15c7dd45-3aae-4dc9-82e5-696a5fd727ab","validation.ts","c4bc29f4-af04-11f1-8508-1607ee4eb77e",15,["D",1789257044019],"import { assertDateOnly } from \"../shared/finance.ts\";\n\nexport function objectBody(value: unknown): Record {\n if (!value || typeof value !== \"object\" || Array.isArray(value)) throw new Error(\"A JSON object is required\");\n return value as Record;\n}\n\nexport function stringField(body: Record, key: string, max = 120): string {\n const value = body[key];\n if (typeof value !== \"string\" || !value.trim()) throw new Error(`${key} is required`);\n const normalized = value.trim();\n if (normalized.length > max) throw new Error(`${key} is too long`);\n return normalized;\n}\n\nexport function optionalString(body: Record, key: string, max = 500): string | null {\n const value = body[key];\n if (value == null || value === \"\") return null;\n if (typeof value !== \"string\" || value.length > max) throw new Error(`${key} is invalid`);\n return value.trim();\n}\n\nexport function enumField(body: Record, key: string, allowed: readonly T[]): T {\n const value = body[key];\n if (typeof value !== \"string\" || !allowed.includes(value as T)) throw new Error(`${key} is invalid`);\n return value as T;\n}\n\nexport function centsField(body: Record, key = \"amountCents\", allowZero = false): number {\n const value = body[key];\n if (!Number.isSafeInteger(value) || (allowZero ? (value as number) < 0 : (value as number) <= 0)) {\n throw new Error(`${key} must be a safe integer number of cents${allowZero ? \"\" : \" greater than zero\"}`);\n }\n return value as number;\n}\n\nexport function signedCentsField(body: Record, key: string): number {\n const value = body[key];\n if (!Number.isSafeInteger(value)) throw new Error(`${key} must be a safe integer number of cents`);\n return value as number;\n}\n\nexport function integerField(body: Record, key: string, min = 1): number {\n const value = body[key];\n if (!Number.isSafeInteger(value) || (value as number) < min) throw new Error(`${key} is invalid`);\n return value as number;\n}\n\nexport function dateField(body: Record, key: string): string {\n const value = stringField(body, key, 10);\n assertDateOnly(value);\n return value;\n}\n\nexport function booleanField(body: Record, key: string, fallback: boolean): boolean {\n const value = body[key];\n if (value == null) return fallback;\n if (typeof value !== \"boolean\") throw new Error(`${key} is invalid`);\n return value;\n}\n",[],[191,273],"253ff3d6-e18f-48dc-917c-a7cbb524923b","db.ts","c4b5efd0-af04-11f1-bb78-1607ee4eb77e",14,["D",1789257043989],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const db = sqlite;\n\nlet initialized: Promise | null = null;\n\nexport function ensureSchema(): Promise {\n initialized ??= migrate();\n return initialized;\n}\n\nasync function migrate(): Promise {\n await db.batch([\n `CREATE TABLE IF NOT EXISTS schema_migrations (\n version INTEGER PRIMARY KEY,\n applied_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS accounts (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('checking', 'savings', 'cash')),\n currency TEXT NOT NULL DEFAULT 'EUR',\n balance_cents INTEGER NOT NULL,\n is_active INTEGER NOT NULL DEFAULT 1 CHECK (is_active IN (0, 1)),\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS planned_transactions (\n id TEXT PRIMARY KEY,\n account_id TEXT REFERENCES accounts(id) ON DELETE SET NULL,\n description TEXT NOT NULL,\n kind TEXT NOT NULL CHECK (kind IN ('income', 'expense')),\n amount_cents INTEGER NOT NULL CHECK (amount_cents > 0),\n currency TEXT NOT NULL DEFAULT 'EUR',\n recurrence TEXT NOT NULL CHECK (recurrence IN ('once', 'weekly', 'monthly', 'yearly')),\n interval_count INTEGER NOT NULL DEFAULT 1 CHECK (interval_count > 0),\n next_date TEXT NOT NULL,\n end_date TEXT,\n is_active INTEGER NOT NULL DEFAULT 1 CHECK (is_active IN (0, 1)),\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS transactions (\n id TEXT PRIMARY KEY,\n account_id TEXT NOT NULL REFERENCES accounts(id) ON DELETE RESTRICT,\n date TEXT NOT NULL,\n amount_cents INTEGER NOT NULL CHECK (amount_cents != 0),\n currency TEXT NOT NULL DEFAULT 'EUR',\n description TEXT NOT NULL,\n kind TEXT NOT NULL CHECK (kind IN ('income', 'expense', 'refund', 'transfer')),\n status TEXT NOT NULL CHECK (status IN ('cleared', 'pending')),\n source TEXT NOT NULL CHECK (source IN ('manual', 'import', 'planned')),\n external_id TEXT,\n import_identity TEXT,\n transfer_group_id TEXT,\n planned_transaction_id TEXT REFERENCES planned_transactions(id) ON DELETE SET NULL,\n raw_metadata TEXT,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE UNIQUE INDEX IF NOT EXISTS transactions_import_identity_idx\n ON transactions(import_identity) WHERE import_identity IS NOT NULL`,\n `CREATE INDEX IF NOT EXISTS transactions_date_idx ON transactions(date)`,\n `CREATE TABLE IF NOT EXISTS reserves (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n amount_cents INTEGER NOT NULL CHECK (amount_cents >= 0),\n currency TEXT NOT NULL DEFAULT 'EUR',\n note TEXT NOT NULL DEFAULT '',\n is_active INTEGER NOT NULL DEFAULT 1 CHECK (is_active IN (0, 1)),\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS imports (\n id TEXT PRIMARY KEY,\n filename TEXT NOT NULL,\n status TEXT NOT NULL CHECK (status IN ('processing', 'completed', 'failed')),\n row_count INTEGER NOT NULL DEFAULT 0,\n imported_count INTEGER NOT NULL DEFAULT 0,\n duplicate_count INTEGER NOT NULL DEFAULT 0,\n error_summary TEXT,\n created_at TEXT NOT NULL,\n completed_at TEXT\n )`,\n {\n sql: `INSERT OR IGNORE INTO schema_migrations (version, applied_at) VALUES (?, ?)`,\n args: [1, new Date().toISOString()],\n },\n ]);\n}\n",[],[191,281],["D",1789257043295],[219,220],[191],"1861c029-4d6f-4028-b4c9-d7f27ae9b711","root.tsx","c489761c-af04-11f1-9abb-1607ee4eb77e",9,["D",1789257043718],"/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport function Root() {\n return (\n <>\n {raw(\"\")}\n \n \n \n \n \n \n BudgetApp\n

Diff · v19