[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_319":320,"_321":322},"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":119,"_120":-5,"_121":-5,"_122":123},"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",19,"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/index.http.ts","latestPath","fileId","ca95f2ae-1203-11f1-a32e-42dde27851f2","name","index.http.ts","fileType","http","content","import { Hono } from \"https://esm.sh/hono@4.4.6\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport {\n getAccounts,\n getTransactions,\n updateTransactionCategory,\n getMonthlySpendByCategory,\n getMonthlyIncome,\n getSyncState,\n setSyncState,\n setAccountExcluded,\n} from \"./database/queries.ts\";\nimport { claimSetupToken } from \"./simplefin.ts\";\nimport { syncTransactions } from \"./sync.cron.ts\";\nimport {\n BUDGET_GROUPS,\n INCOME_TARGET,\n INCOME_CATEGORY,\n TRANSFER_CATEGORIES,\n} from \"../shared/categories.ts\";\nimport type { BudgetSummary } from \"../shared/types.ts\";\n\nconst app = new Hono();\n\napp.onError((err, c) => {\n throw err;\n});\n\n// Run migrations on first request\nlet migrated = false;\napp.use(\"*\", async (_c, next) => {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n await next();\n});\n\n// Static 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// ---------------------------------------------------------------------------\n// Pages\n// ---------------------------------------------------------------------------\n\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n const hasAccess = !!(await getSyncState(\"access_url\"));\n const configScript = ``;\n html = html.replace(\"\", `${configScript}\\n`);\n\n return c.html(html);\n});\n\n// ---------------------------------------------------------------------------\n// SimpleFIN setup\n// ---------------------------------------------------------------------------\n\napp.post(\"/api/simplefin/claim\", async (c) => {\n const setupToken = Deno.env.get(\"SIMPLEFIN_SETUP_TOKEN\");\n if (!setupToken) {\n return c.json({ error: \"SIMPLEFIN_SETUP_TOKEN env var not set\" }, 400);\n }\n\n const existingUrl = await getSyncState(\"access_url\");\n if (existingUrl) {\n return c.json({ error: \"Already connected. Access URL exists.\" }, 409);\n }\n\n const accessUrl = await claimSetupToken(setupToken);\n await setSyncState(\"access_url\", accessUrl);\n return c.json({ ok: true });\n});\n\napp.get(\"/api/simplefin/status\", async (c) => {\n const accessUrl = await getSyncState(\"access_url\");\n const lastSync = await getSyncState(\"last_sync_timestamp\");\n return c.json({\n connected: !!accessUrl,\n lastSync: lastSync ? Number(lastSync) : null,\n });\n});\n\n// ---------------------------------------------------------------------------\n// Sync\n// ---------------------------------------------------------------------------\n\napp.post(\"/api/sync\", async (c) => {\n const result = await syncTransactions();\n return c.json(result);\n});\n\n// ---------------------------------------------------------------------------\n// Accounts\n// ---------------------------------------------------------------------------\n\napp.get(\"/api/accounts\", async (c) => {\n const accounts = await getAccounts();\n return c.json(accounts);\n});\n\napp.patch(\"/api/accounts/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n if (typeof body.excluded === \"boolean\") {\n await setAccountExcluded(id, body.excluded);\n }\n return c.json({ ok: true });\n});\n\n// ---------------------------------------------------------------------------\n// Transactions\n// ---------------------------------------------------------------------------\n\napp.get(\"/api/transactions\", async (c) => {\n const month = c.req.query(\"month\");\n const category = c.req.query(\"category\");\n const search = c.req.query(\"search\");\n const limit = c.req.query(\"limit\") ? Number(c.req.query(\"limit\")) : undefined;\n const offset = c.req.query(\"offset\") ? Number(c.req.query(\"offset\")) : undefined;\n\n const result = await getTransactions({ month, category, search, limit, offset });\n return c.json(result);\n});\n\napp.patch(\"/api/transactions/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const isTransfer = TRANSFER_CATEGORIES.includes(body.category) || false;\n await updateTransactionCategory(id, body.category, isTransfer);\n return c.json({ ok: true });\n});\n\n// ---------------------------------------------------------------------------\n// Budget summary\n// ---------------------------------------------------------------------------\n\napp.get(\"/api/budget/summary\", async (c) => {\n const now = new Date();\n const month = c.req.query(\"month\") ??\n `${now.getFullYear()}-${String(now.getMonth() + 1).padStart(2, \"0\")}`;\n\n const spending = await getMonthlySpendByCategory(month);\n const totalIncome = await getMonthlyIncome(month);\n\n const groups = BUDGET_GROUPS.map((group) => {\n const items = group.items.map((item) => {\n const actual = Math.abs(spending[item.ruleCategory] ?? 0);\n return {\n name: item.name,\n target: item.monthlyTarget,\n actual,\n ruleCategory: item.ruleCategory,\n };\n });\n return {\n name: group.name,\n items,\n totalTarget: items.reduce((s, i) => s + i.target, 0),\n totalActual: items.reduce((s, i) => s + i.actual, 0),\n };\n });\n\n const expenseTarget = groups.reduce((s, g) => s + g.totalTarget, 0);\n const totalExpenses = groups.reduce((s, g) => s + g.totalActual, 0);\n const savings = totalIncome - totalExpenses;\n const savingsRate = totalIncome > 0 ? (savings / totalIncome) * 100 : 0;\n\n const summary: BudgetSummary = {\n month,\n groups,\n totalIncome,\n incomeTarget: INCOME_TARGET,\n totalExpenses,\n expenseTarget,\n savings,\n savingsRate,\n };\n\n return c.json(summary);\n});\n\nexport default app.fetch;\n","createdAt",["D",1771994291778],"branchVersion","branchId","d6000d54-11ff-11f1-b7b3-42dde27851f2","id","d5ffaa26-11ff-11f1-b7b3-42dde27851f2","runway",["D",1771992592978],"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",45,"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":315,"_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":316,"_78":317,"_80":318,"_82":24},"tree",[167,175,184,185],"files",[167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185],"counts",{"_157":60,"_158":148,"_159":60,"_160":161,"_162":163},"contents",[124,125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_42":151,"_31":152,"_29":153,"_131":-5,"_40":41,"_39":154,"_133":119,"_37":155,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":156},{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":119,"_37":149,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":119,"_37":142,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":119,"_37":134,"_13":60,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"ca5bf446-1203-11f1-89fb-42dde27851f2","deno.json","ca5bf504-1203-11f1-89fb-42dde27851f2","parentId",14,"latest",["D",1771994291432],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[129],"c9b62002-1203-11f1-8965-42dde27851f2","shared","c9b62174-1203-11f1-8965-42dde27851f2",3,["D",1771994290349],"directory",[139],"c95f498a-1203-11f1-a32e-42dde27851f2","frontend","c95f4a52-1203-11f1-a32e-42dde27851f2",1,["D",1771994289777],[146],"c97e8fc0-1203-11f1-8965-42dde27851f2","backend","c97e906a-1203-11f1-8965-42dde27851f2",2,["D",1771994289982],[152],"pulls","branches","forks","envVars",{"_164":141,"_166":60},"connections",{"_164":60,"_165":60},"count","unfilledCount","emptyCount",{"_42":151,"_31":152,"_29":153,"_131":-5,"_40":41,"_39":154,"_133":119,"_37":312,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_187":313,"_26":314},{"_42":307,"_31":298,"_29":292,"_131":153,"_40":41,"_39":308,"_133":119,"_37":309,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_187":310,"_26":311},{"_42":299,"_31":300,"_29":301,"_131":292,"_40":41,"_39":302,"_133":24,"_37":303,"_13":60,"_33":206,"_35":304,"_23":24,"_136":-5,"_187":305,"_26":306},{"_42":289,"_31":290,"_29":291,"_131":292,"_40":41,"_39":293,"_133":24,"_37":294,"_13":60,"_33":206,"_35":295,"_23":24,"_136":-5,"_187":296,"_26":297},{"_42":281,"_31":282,"_29":283,"_131":153,"_40":41,"_39":284,"_133":24,"_37":285,"_13":60,"_33":206,"_35":286,"_23":24,"_136":-5,"_187":287,"_26":288},{"_42":277,"_31":32,"_29":30,"_131":153,"_40":41,"_39":14,"_133":24,"_37":278,"_13":60,"_33":34,"_35":36,"_23":24,"_136":-5,"_187":279,"_26":280},{"_42":269,"_31":270,"_29":271,"_131":153,"_40":41,"_39":272,"_133":119,"_37":273,"_13":60,"_33":206,"_35":274,"_23":24,"_136":-5,"_187":275,"_26":276},{"_42":260,"_31":261,"_29":262,"_131":153,"_40":41,"_39":263,"_133":24,"_37":264,"_13":60,"_33":265,"_35":266,"_23":24,"_136":-5,"_187":267,"_26":268},{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_133":119,"_37":257,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_187":258,"_26":259},{"_42":252,"_31":227,"_29":221,"_131":147,"_40":41,"_39":253,"_133":119,"_37":254,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_187":255,"_26":256},{"_42":244,"_31":245,"_29":246,"_131":221,"_40":41,"_39":247,"_133":24,"_37":248,"_13":60,"_33":206,"_35":249,"_23":24,"_136":-5,"_187":250,"_26":251},{"_42":236,"_31":237,"_29":238,"_131":221,"_40":41,"_39":239,"_133":119,"_37":240,"_13":60,"_33":206,"_35":241,"_23":24,"_136":-5,"_187":242,"_26":243},{"_42":228,"_31":229,"_29":230,"_131":221,"_40":41,"_39":231,"_133":24,"_37":232,"_13":60,"_33":206,"_35":233,"_23":24,"_136":-5,"_187":234,"_26":235},{"_42":218,"_31":219,"_29":220,"_131":221,"_40":41,"_39":222,"_133":119,"_37":223,"_13":60,"_33":206,"_35":224,"_23":24,"_136":-5,"_187":225,"_26":226},{"_42":210,"_31":211,"_29":212,"_131":147,"_40":41,"_39":213,"_133":119,"_37":214,"_13":60,"_33":20,"_35":215,"_23":24,"_136":-5,"_187":216,"_26":217},{"_42":201,"_31":202,"_29":203,"_131":147,"_40":41,"_39":204,"_133":119,"_37":205,"_13":60,"_33":206,"_35":207,"_23":24,"_136":-5,"_187":208,"_26":209},{"_42":193,"_31":194,"_29":195,"_131":147,"_40":41,"_39":196,"_133":119,"_37":197,"_13":60,"_33":20,"_35":198,"_23":24,"_136":-5,"_187":199,"_26":200},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_133":119,"_37":190,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_187":191,"_26":192},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":132,"_133":119,"_37":186,"_13":60,"_33":20,"_35":135,"_23":24,"_136":-5,"_187":188,"_26":189},["D",1771994291432],"children",[],[129],["D",1771994290349],[],[139],"ca4d2394-1203-11f1-86a1-42dde27851f2","style.css","ca4d2452-1203-11f1-86a1-42dde27851f2",12,["D",1771994291224],":root {\n --bg-base: #0B0F0E;\n --bg-surface: #141A18;\n --bg-surface-hover: #1A2220;\n --border: #1E2A26;\n --border-subtle: #162220;\n --primary: #34D399;\n --primary-dim: #34D39940;\n --text: #F0FDF4;\n --text-muted: #86EFAC80;\n --text-secondary: #A7C4B8;\n --positive: #34D399;\n --warning: #FBBF24;\n --danger: #F87171;\n --income: #6EE7B7;\n}\n\n* {\n box-sizing: border-box;\n margin: 0;\n padding: 0;\n}\n\nhtml, body {\n background: var(--bg-base);\n color: var(--text);\n font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, sans-serif;\n -webkit-font-smoothing: antialiased;\n min-height: 100vh;\n}\n\n#root {\n max-width: 640px;\n margin: 0 auto;\n padding: 0 16px;\n}\n\n/* Progress bar */\n.progress-track {\n height: 6px;\n background: var(--border);\n border-radius: 3px;\n overflow: hidden;\n}\n\n.progress-fill {\n height: 100%;\n border-radius: 3px;\n transition: width 0.4s ease;\n}\n\n/* Tab bar */\n.tab-bar {\n display: flex;\n gap: 2px;\n background: var(--bg-surface);\n border-radius: 10px;\n padding: 3px;\n margin-bottom: 24px;\n}\n\n.tab-bar button {\n flex: 1;\n padding: 8px 16px;\n border: none;\n border-radius: 8px;\n background: transparent;\n color: var(--text-muted);\n font-size: 14px;\n font-weight: 500;\n cursor: pointer;\n transition: all 0.2s;\n}\n\n.tab-bar button.active {\n background: var(--primary-dim);\n color: var(--primary);\n}\n\n/* Cards */\n.card {\n background: var(--bg-surface);\n border: 1px solid var(--border-subtle);\n border-radius: 12px;\n padding: 16px;\n margin-bottom: 12px;\n}\n\n.card-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n cursor: pointer;\n user-select: none;\n}\n\n/* Badge */\n.badge {\n display: inline-block;\n padding: 2px 8px;\n border-radius: 6px;\n font-size: 11px;\n font-weight: 500;\n background: var(--primary-dim);\n color: var(--primary);\n cursor: pointer;\n transition: background 0.15s;\n}\n\n.badge:hover {\n background: var(--primary);\n color: var(--bg-base);\n}\n\n.badge.empty {\n background: var(--border);\n color: var(--text-muted);\n}\n\n/* Transaction row */\n.tx-row {\n display: flex;\n align-items: center;\n gap: 12px;\n padding: 10px 0;\n border-bottom: 1px solid var(--border-subtle);\n}\n\n.tx-row:last-child {\n border-bottom: none;\n}\n\n/* Modal overlay */\n.modal-overlay {\n position: fixed;\n inset: 0;\n background: rgba(0, 0, 0, 0.7);\n display: flex;\n align-items: flex-end;\n justify-content: center;\n z-index: 50;\n animation: fadeIn 0.15s ease;\n}\n\n.modal-sheet {\n background: var(--bg-surface);\n border: 1px solid var(--border);\n border-radius: 16px 16px 0 0;\n width: 100%;\n max-width: 640px;\n max-height: 70vh;\n overflow-y: auto;\n padding: 20px;\n animation: slideUp 0.2s ease;\n}\n\n.modal-option {\n padding: 12px;\n border-radius: 8px;\n cursor: pointer;\n color: var(--text);\n transition: background 0.15s;\n}\n\n.modal-option:hover {\n background: var(--bg-surface-hover);\n}\n\n.modal-option.selected {\n background: var(--primary-dim);\n color: var(--primary);\n}\n\n@keyframes fadeIn {\n from { opacity: 0; }\n to { opacity: 1; }\n}\n\n@keyframes slideUp {\n from { transform: translateY(100%); }\n to { transform: translateY(0); }\n}\n\n/* Summary row */\n.summary-row {\n display: flex;\n justify-content: space-between;\n align-items: center;\n padding: 6px 0;\n}\n\n/* Setup screen */\n.setup-container {\n display: flex;\n flex-direction: column;\n align-items: center;\n justify-content: center;\n min-height: 60vh;\n gap: 16px;\n text-align: center;\n}\n\n.btn {\n padding: 10px 20px;\n border: none;\n border-radius: 8px;\n font-size: 14px;\n font-weight: 600;\n cursor: pointer;\n transition: all 0.15s;\n}\n\n.btn-primary {\n background: var(--primary);\n color: var(--bg-base);\n}\n\n.btn-primary:hover {\n filter: brightness(1.1);\n}\n\n.btn-primary:disabled {\n opacity: 0.5;\n cursor: not-allowed;\n}\n\n.btn-ghost {\n background: transparent;\n color: var(--text-muted);\n border: 1px solid var(--border);\n}\n\n.btn-ghost:hover {\n border-color: var(--primary);\n color: var(--primary);\n}\n\n/* Spinner */\n.spinner {\n width: 20px;\n height: 20px;\n border: 2px solid var(--border);\n border-top-color: var(--primary);\n border-radius: 50%;\n animation: spin 0.6s linear infinite;\n display: inline-block;\n}\n\n@keyframes spin {\n to { transform: rotate(360deg); }\n}\n\n/* Month selector */\n.month-nav {\n display: flex;\n align-items: center;\n justify-content: center;\n gap: 16px;\n margin-bottom: 20px;\n}\n\n.month-nav button {\n background: none;\n border: none;\n color: var(--text-muted);\n font-size: 20px;\n cursor: pointer;\n padding: 4px 8px;\n border-radius: 6px;\n transition: color 0.15s;\n}\n\n.month-nav button:hover {\n color: var(--primary);\n}\n\n.month-nav span {\n font-size: 16px;\n font-weight: 600;\n min-width: 140px;\n text-align: center;\n}\n\n/* Filter bar */\n.filter-bar {\n display: flex;\n gap: 8px;\n margin-bottom: 16px;\n}\n\n.filter-bar input,\n.filter-bar select {\n flex: 1;\n padding: 8px 12px;\n background: var(--bg-surface);\n border: 1px solid var(--border);\n border-radius: 8px;\n color: var(--text);\n font-size: 13px;\n outline: none;\n transition: border-color 0.15s;\n}\n\n.filter-bar input:focus,\n.filter-bar select:focus {\n border-color: var(--primary);\n}\n\n.filter-bar select option {\n background: var(--bg-surface);\n}\n",[],[146,194],"ca23adfc-1203-11f1-a75d-42dde27851f2","index.tsx","ca23aed8-1203-11f1-a75d-42dde27851f2",7,["D",1771994291053],"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0\";\nimport { App } from \"./components/App.tsx\";\n\nReactDOM.createRoot(document.getElementById(\"root\")!).render();\n",[],[146,202],"ca1f7a98-1203-11f1-8965-42dde27851f2","index.html","ca1f7b60-1203-11f1-8965-42dde27851f2",6,["D",1771994291040],"\n\n\n \n \n \n \n \n Runway\n $\" />\n \n \n \n\n\n

\n \n\n\n",[],[146,211],"ca3ba740-1203-11f1-bb6e-42dde27851f2","Transactions.tsx","ca3ba7fe-1203-11f1-bb6e-42dde27851f2","c9d7d0b2-1203-11f1-aea5-42dde27851f2",10,["D",1771994291187],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { Transaction } from \"../../shared/types.ts\";\nimport { ALL_CATEGORIES } from \"../../shared/categories.ts\";\nimport { CategoryPicker } from \"./CategoryPicker.tsx\";\n\nfunction currentMonth(): string {\n const d = new Date();\n return `${d.getFullYear()}-${String(d.getMonth() + 1).padStart(2, \"0\")}`;\n}\n\nfunction shiftMonth(month: string, delta: number): string {\n const [y, m] = month.split(\"-\").map(Number);\n const d = new Date(y, m - 1 + delta, 1);\n return `${d.getFullYear()}-${String(d.getMonth() + 1).padStart(2, \"0\")}`;\n}\n\nfunction formatMonth(month: string): string {\n const [y, m] = month.split(\"-\").map(Number);\n return new Date(y, m - 1).toLocaleDateString(\"en-US\", { month: \"long\", year: \"numeric\" });\n}\n\nfunction formatDate(ts: number): string {\n return new Date(ts * 1000).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" });\n}\n\nfunction dollars(n: number): string {\n const abs = Math.abs(n);\n const formatted = \"$\" + abs.toLocaleString(\"en-US\", { minimumFractionDigits: 2, maximumFractionDigits: 2 });\n return n < 0 ? `-${formatted}` : formatted;\n}\n\nexport function Transactions() {\n const [month, setMonth] = useState(currentMonth);\n const [category, setCategory] = useState(\"\");\n const [search, setSearch] = useState(\"\");\n const [transactions, setTransactions] = useState([]);\n const [total, setTotal] = useState(0);\n const [loading, setLoading] = useState(true);\n\n const [pickerTx, setPickerTx] = useState(null);\n\n const fetchTx = useCallback(async () => {\n setLoading(true);\n const params = new URLSearchParams();\n params.set(\"month\", month);\n if (category) params.set(\"category\", category);\n if (search) params.set(\"search\", search);\n params.set(\"limit\", \"500\");\n\n const res = await fetch(`/api/transactions?${params}`);\n const data = await res.json();\n setTransactions(data.transactions);\n setTotal(data.total);\n setLoading(false);\n }, [month, category, search]);\n\n useEffect(() => {\n fetchTx();\n }, [fetchTx]);\n\n const handleCategoryUpdate = useCallback(async (newCategory: string) => {\n if (!pickerTx) return;\n await fetch(`/api/transactions/${encodeURIComponent(pickerTx.id)}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ category: newCategory }),\n });\n setPickerTx(null);\n fetchTx();\n }, [pickerTx, fetchTx]);\n\n return (\n

\n \n {formatMonth(month)}\n \n

\n\n

\n setSearch(e.target.value)}\n />\n \n

\n\n

\n {total} transaction{total !== 1 ? \"s\" : \"\"}\n

\n\n {loading ? (\n

\n ) : transactions.length === 0 ? (\n

\n No transactions found\n

\n ) : (\n

\n {transactions.map((tx) => {\n const amount = parseFloat(tx.amount);\n const isIncome = amount > 0;\n return (\n

\n {formatDate(tx.posted)}\n

\n {tx.payee || tx.description}\n

\n {tx.is_transfer && (\n transfer\n )}\n

\n setPickerTx(tx)}\n >\n {tx.category || \"—\"}\n

\n {dollars(amount)}\n

\n );\n })}\n

\n )}\n\n {pickerTx && (\n setPickerTx(null)}\n />\n )}\n \n );\n}\n",[],[146,227,219],"components","ca377076-1203-11f1-a532-42dde27851f2","Dashboard.tsx","ca37713e-1203-11f1-a532-42dde27851f2",9,["D",1771994291180],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport type { BudgetSummary, BudgetSummaryGroup, BudgetSummaryItem } from \"../../shared/types.ts\";\n\nfunction formatMonth(month: string): string {\n const [y, m] = month.split(\"-\").map(Number);\n return new Date(y, m - 1).toLocaleDateString(\"en-US\", { month: \"long\", year: \"numeric\" });\n}\n\nfunction shiftMonth(month: string, delta: number): string {\n const [y, m] = month.split(\"-\").map(Number);\n const d = new Date(y, m - 1 + delta, 1);\n return `${d.getFullYear()}-${String(d.getMonth() + 1).padStart(2, \"0\")}`;\n}\n\nfunction currentMonth(): string {\n const d = new Date();\n return `${d.getFullYear()}-${String(d.getMonth() + 1).padStart(2, \"0\")}`;\n}\n\nfunction dollars(n: number): string {\n return \"$\" + Math.abs(n).toLocaleString(\"en-US\", { minimumFractionDigits: 2, maximumFractionDigits: 2 });\n}\n\nfunction pct(actual: number, target: number): number {\n if (target <= 0) return 0;\n return Math.min((actual / target) * 100, 100);\n}\n\nfunction barColor(actual: number, target: number): string {\n if (target <= 0) return \"var(--primary)\";\n const ratio = actual / target;\n if (ratio > 1) return \"var(--danger)\";\n if (ratio > 0.8) return \"var(--warning)\";\n return \"var(--primary)\";\n}\n\nfunction ProgressBar({ actual, target }: { actual: number; target: number }) {\n return (\n

\n \n

\n );\n}\n\nfunction BudgetItemRow({ item }: { item: BudgetSummaryItem }) {\n const over = item.actual > item.target;\n return (\n

\n {item.name}\n \n {dollars(item.actual)}\n / {dollars(item.target)}\n \n

\n \n

\n );\n}\n\nfunction GroupCard({ group }: { group: BudgetSummaryGroup }) {\n const [expanded, setExpanded] = useState(false);\n const over = group.totalActual > group.totalTarget;\n\n return (\n

setExpanded(!expanded)}>\n

{group.name}

\n {group.items.length} categories\n

\n {dollars(group.totalActual)}\n

/ {dollars(group.totalTarget)}

\n \n {expanded && (\n

\n {group.items.map((item) => (\n \n ))}\n

\n )}\n

\n );\n}\n\nexport function Dashboard() {\n const [month, setMonth] = useState(currentMonth);\n const [summary, setSummary] = useState(null);\n const [loading, setLoading] = useState(true);\n\n const fetchSummary = useCallback(async (m: string) => {\n setLoading(true);\n const res = await fetch(`/api/budget/summary?month=${m}`);\n const data: BudgetSummary = await res.json();\n setSummary(data);\n setLoading(false);\n }, []);\n\n useEffect(() => {\n fetchSummary(month);\n }, [month, fetchSummary]);\n\n const savingsPositive = (summary?.savings ?? 0) >= 0;\n\n return (\n

\n \n {formatMonth(month)}\n \n

\n\n {loading ? (\n

\n ) : summary ? (\n <>\n {/* Top-level summary cards */}\n

Income

{dollars(summary.totalIncome)}

Spent

{dollars(summary.totalExpenses)}

Saved

\n {savingsPositive ? \"\" : \"-\"}{dollars(summary.savings)}\n

\n {summary.savingsRate.toFixed(1)}%\n

\n\n {/* Budget vs target bar */}\n

\n Total Budget\n \n {dollars(summary.totalExpenses)} / {dollars(summary.expenseTarget)}\n \n

\n \n

\n\n {/* Category groups */}\n {summary.groups.map((group) => (\n \n ))}\n \n ) : null}\n

\n );\n}\n",[],[146,227,229],"ca462a4e-1203-11f1-ac8f-42dde27851f2","CategoryPicker.tsx","ca462b34-1203-11f1-ac8f-42dde27851f2",11,["D",1771994291229],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { BudgetGroup } from \"../../shared/types.ts\";\nimport { BUDGET_GROUPS } from \"../../shared/categories.ts\";\n\ninterface Props {\n currentCategory: string;\n onSelect: (category: string) => void;\n onClose: () => void;\n}\n\nconst EXTRA_OPTIONS = [\n { group: \"Other\", items: [\"Other\", \"Uncategorized\", \"Transfer\", \"Income\"] },\n];\n\nexport function CategoryPicker({ currentCategory, onSelect, onClose }: Props) {\n return (\n

e.stopPropagation()}>\n

Set Category

\n \n ✕\n \n

\n\n {BUDGET_GROUPS.map((group: BudgetGroup) => (\n

\n {group.name}\n

\n {group.items.map((item) => (\n onSelect(item.ruleCategory)}\n >\n {item.name}\n

\n ))}\n

\n ))}\n\n {EXTRA_OPTIONS.map((section) => (\n

\n {section.group}\n

\n {section.items.map((cat) => (\n onSelect(cat)}\n >\n {cat}\n

\n ))}\n

\n ))}\n \n \n );\n}\n",[],[146,227,237],"ca3403b4-1203-11f1-ab27-42dde27851f2","App.tsx","ca340454-1203-11f1-ab27-42dde27851f2",8,["D",1771994291174],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { Dashboard } from \"./Dashboard.tsx\";\nimport { Transactions } from \"./Transactions.tsx\";\n\ntype Tab = \"dashboard\" | \"transactions\";\n\nexport function App() {\n const [tab, setTab] = useState(\"dashboard\");\n const [syncing, setSyncing] = useState(false);\n const [refreshKey, setRefreshKey] = useState(0);\n\n const config = (window as any).__RUNWAY_CONFIG__ ?? { connected: false };\n const [connected, setConnected] = useState(config.connected);\n\n const handleClaim = useCallback(async () => {\n setSyncing(true);\n try {\n const res = await fetch(\"/api/simplefin/claim\", { method: \"POST\" });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error);\n setConnected(true);\n // Trigger initial sync after claiming\n await fetch(\"/api/sync\", { method: \"POST\" });\n setRefreshKey((k) => k + 1);\n } catch (err: any) {\n console.error(\"Claim error:\", err.message);\n } finally {\n setSyncing(false);\n }\n }, []);\n\n const handleSync = useCallback(async () => {\n setSyncing(true);\n try {\n await fetch(\"/api/sync\", { method: \"POST\" });\n setRefreshKey((k) => k + 1);\n } finally {\n setSyncing(false);\n }\n }, []);\n\n if (!connected) {\n return (\n

Runway

\n Connect your bank via SimpleFIN to start tracking your budget.\n Set the SIMPLEFIN_SETUP_TOKEN env var first.\n

\n \n

\n );\n }\n\n return (\n

Runway

\n \n

\n\n

\n \n \n

\n\n {tab === \"dashboard\" && }\n {tab === \"transactions\" && }\n

\n );\n}\n",[],[146,227,245],"c9d7cfea-1203-11f1-aea5-42dde27851f2",4,["D",1771994290565],[177,178,179,180],[146,227],["D",1771994289777],[176,181,182,183],[146],"ca674620-1203-11f1-ac8f-42dde27851f2","sync.cron.ts","ca6746e8-1203-11f1-ac8f-42dde27851f2",16,["D",1771994291497],"interval","import { runMigrations } from \"./database/migrations.ts\";\nimport {\n getSyncState,\n setSyncState,\n upsertAccount,\n upsertTransaction,\n getExcludedAccountIds,\n} from \"./database/queries.ts\";\nimport { fetchAccounts, fetchHistorical } from \"./simplefin.ts\";\nimport { categorizeAll } from \"./categorize.ts\";\nimport type { SimpleFINAccountSet } from \"../shared/types.ts\";\n\nconst TWO_YEARS_DAYS = 730;\nconst TWO_DAYS_S = 2 * 24 * 60 * 60;\n\nasync function processAccountSet(\n data: SimpleFINAccountSet,\n excludedIds: Set,\n): Promise<{ accountCount: number; txCount: number }> {\n let accountCount = 0;\n let txCount = 0;\n\n for (const account of data.accounts) {\n if (excludedIds.has(account.id)) continue;\n\n await upsertAccount({\n id: account.id,\n name: account.name,\n org_domain: account.org?.domain ?? \"\",\n currency: account.currency,\n balance: account.balance,\n balance_date: account[\"balance-date\"],\n excluded: false,\n });\n accountCount++;\n\n if (account.transactions) {\n const categorized = categorizeAll(\n account.transactions.map((tx) => ({\n id: tx.id,\n account_id: account.id,\n posted: tx.posted,\n amount: tx.amount,\n description: tx.description,\n notes: tx.extra?.notes as string ?? \"\",\n pending: tx.pending ?? false,\n })),\n );\n\n for (const tx of categorized) {\n await upsertTransaction(tx);\n txCount++;\n }\n }\n }\n\n return { accountCount, txCount };\n}\n\n/**\n * Main sync function. Called by the cron trigger and the manual sync endpoint.\n */\nexport async function syncTransactions(): Promise<{\n accountCount: number;\n txCount: number;\n errors: string[];\n}> {\n await runMigrations();\n\n const accessUrl = await getSyncState(\"access_url\");\n if (!accessUrl) {\n return { accountCount: 0, txCount: 0, errors: [\"No SimpleFIN access URL configured. Claim a setup token first.\"] };\n }\n\n const excludedIds = await getExcludedAccountIds();\n const lastSync = await getSyncState(\"last_sync_timestamp\");\n const allErrors: string[] = [];\n let totalAccounts = 0;\n let totalTx = 0;\n\n if (!lastSync) {\n // Initial sync: fetch historical data in 90-day windows\n const results = await fetchHistorical(accessUrl, TWO_YEARS_DAYS);\n for (const data of results) {\n allErrors.push(...data.errors);\n const { accountCount, txCount } = await processAccountSet(data, excludedIds);\n totalAccounts += accountCount;\n totalTx += txCount;\n }\n } else {\n // Incremental sync: overlap by 2 days for late-posting transactions\n const startDate = Number(lastSync) - TWO_DAYS_S;\n const data = await fetchAccounts(accessUrl, { startDate });\n allErrors.push(...data.errors);\n const { accountCount, txCount } = await processAccountSet(data, excludedIds);\n totalAccounts = accountCount;\n totalTx = txCount;\n }\n\n await setSyncState(\"last_sync_timestamp\", String(Math.floor(Date.now() / 1000)));\n\n return { accountCount: totalAccounts, txCount: totalTx, errors: allErrors };\n}\n\n// Val Town cron trigger entry point\nexport default async function () {\n const result = await syncTransactions();\n console.log(\n `Runway sync complete: ${result.accountCount} accounts, ${result.txCount} transactions` +\n (result.errors.length ? ` | errors: ${result.errors.join(\"; \")}` : \"\"),\n );\n}\n",[],[152,261],"ca905038-1203-11f1-92b7-42dde27851f2","simplefin.ts","ca9050f6-1203-11f1-92b7-42dde27851f2",18,["D",1771994291777],"import type { SimpleFINAccountSet } from \"../shared/types.ts\";\n\n/**\n * Claim a SimpleFIN setup token, returning the access URL.\n * The setup token is base64-encoded; decoding gives a claim URL.\n * POST to that URL returns the access URL (with embedded credentials).\n */\nexport async function claimSetupToken(setupToken: string): Promise {\n const claimUrl = atob(setupToken.trim());\n const response = await fetch(claimUrl, { method: \"POST\" });\n\n if (response.status === 403) {\n throw new Error(\n \"Setup token was already claimed or is invalid. \" +\n \"The token may be compromised — disable it in SimpleFIN Bridge.\",\n );\n }\n if (!response.ok) {\n throw new Error(`Failed to claim token: ${response.status} ${response.statusText}`);\n }\n\n return response.text();\n}\n\n/**\n * Parse an access URL into { baseUrl, username, password }.\n * Access URLs look like: https://user:pass@bridge.simplefin.org/simplefin\n */\nfunction parseAccessUrl(accessUrl: string): { url: string; username: string; password: string } {\n const parsed = new URL(accessUrl);\n const username = parsed.username;\n const password = parsed.password;\n parsed.username = \"\";\n parsed.password = \"\";\n return { url: parsed.toString().replace(/\\/$/, \"\"), username, password };\n}\n\n/**\n * Fetch accounts and transactions from SimpleFIN for a given date range.\n * Date range is limited to 90 days per the API spec.\n */\nexport async function fetchAccounts(\n accessUrl: string,\n opts?: { startDate?: number; endDate?: number },\n): Promise {\n const { url, username, password } = parseAccessUrl(accessUrl);\n const params = new URLSearchParams();\n\n if (opts?.startDate !== undefined) {\n params.set(\"start-date\", String(Math.floor(opts.startDate)));\n }\n if (opts?.endDate !== undefined) {\n params.set(\"end-date\", String(Math.floor(opts.endDate)));\n }\n\n const qs = params.toString();\n const endpoint = `${url}/accounts${qs ? `?${qs}` : \"\"}`;\n\n const response = await fetch(endpoint, {\n headers: {\n Authorization: `Basic ${btoa(`${username}:${password}`)}`,\n },\n });\n\n if (response.status === 403) {\n throw new Error(\"SimpleFIN access revoked or credentials invalid.\");\n }\n if (response.status === 402) {\n throw new Error(\"SimpleFIN subscription payment required.\");\n }\n if (!response.ok) {\n throw new Error(`SimpleFIN error: ${response.status} ${response.statusText}`);\n }\n\n return response.json();\n}\n\nconst NINETY_DAYS_S = 90 * 24 * 60 * 60;\n\n/**\n * Fetch all historical transactions in 90-day windows going back a given\n * number of days from now. Returns all account sets merged.\n */\nexport async function fetchHistorical(\n accessUrl: string,\n daysBack: number,\n): Promise {\n const now = Math.floor(Date.now() / 1000);\n const earliest = now - daysBack * 24 * 60 * 60;\n const results: SimpleFINAccountSet[] = [];\n\n let windowEnd = now;\n while (windowEnd > earliest) {\n const windowStart = Math.max(windowEnd - NINETY_DAYS_S, earliest);\n const data = await fetchAccounts(accessUrl, {\n startDate: windowStart,\n endDate: windowEnd,\n });\n results.push(data);\n windowEnd = windowStart;\n }\n\n return results;\n}\n",[],[152,270],"ca95f218-1203-11f1-a32e-42dde27851f2",["D",1771994291778],[],[152,32],"ca6b2466-1203-11f1-9a25-42dde27851f2","categorize.ts","ca6b24fc-1203-11f1-9a25-42dde27851f2",17,["D",1771994291494],"import type { CategoryRule, Transaction } from \"../shared/types.ts\";\nimport {\n PAYEE_RENAME_RULES,\n CATEGORY_RULES,\n TRANSFER_CATEGORIES,\n TRANSFER_PAYEES,\n} from \"../shared/categories.ts\";\n\nfunction matchesRule(\n rule: CategoryRule,\n payee: string,\n notes: string,\n): boolean {\n const payeeLower = payee.toLowerCase();\n const notesLower = notes.toLowerCase();\n // OR logic: any condition matching is sufficient\n return rule.conditions.some((cond) => {\n const value = cond.field === \"payee\" ? payeeLower : notesLower;\n return value.includes(cond.contains.toLowerCase());\n });\n}\n\n/**\n * Apply auto-categorization rules to a transaction.\n * Modifies payee, category, and is_transfer fields.\n * Does NOT touch transactions with category_source === 'manual'.\n */\nexport function categorizeTransaction(tx: {\n description: string;\n payee: string;\n notes: string;\n category: string;\n category_source: string;\n is_transfer: boolean;\n}): { payee: string; category: string; category_source: string; is_transfer: boolean } {\n let payee = tx.payee || tx.description;\n let category = tx.category;\n let categorySource = tx.category_source;\n let isTransfer = tx.is_transfer;\n\n if (categorySource === \"manual\") {\n return { payee, category, category_source: categorySource, is_transfer: isTransfer };\n }\n\n // Phase 1: payee renaming (first match wins)\n for (const rule of PAYEE_RENAME_RULES) {\n if (matchesRule(rule, payee, tx.notes)) {\n if (rule.action.setPayee) {\n payee = rule.action.setPayee;\n }\n break;\n }\n }\n\n // Phase 2: category assignment (last match wins)\n for (const rule of CATEGORY_RULES) {\n if (matchesRule(rule, payee, tx.notes)) {\n if (rule.action.setCategory) {\n category = rule.action.setCategory;\n categorySource = \"auto\";\n }\n }\n }\n\n // Phase 3: detect transfers\n isTransfer =\n TRANSFER_CATEGORIES.includes(category) || TRANSFER_PAYEES.includes(payee);\n\n return { payee, category, category_source: categorySource, is_transfer: isTransfer };\n}\n\n/**\n * Apply categorization to a batch of raw transaction data and return\n * fully-formed Transaction objects.\n */\nexport function categorizeAll(\n rawTransactions: Array<{\n id: string;\n account_id: string;\n posted: number;\n amount: string;\n description: string;\n notes: string;\n pending: boolean;\n }>,\n): Transaction[] {\n return rawTransactions.map((raw) => {\n const result = categorizeTransaction({\n description: raw.description,\n payee: raw.description,\n notes: raw.notes,\n category: \"\",\n category_source: \"\",\n is_transfer: false,\n });\n\n return {\n id: raw.id,\n account_id: raw.account_id,\n posted: raw.posted,\n amount: raw.amount,\n description: raw.description,\n payee: result.payee,\n notes: raw.notes,\n category: result.category,\n category_source: result.category_source as Transaction[\"category_source\"],\n is_transfer: result.is_transfer,\n pending: raw.pending,\n };\n });\n}\n",[],[152,282],"ca57533c-1203-11f1-9a25-42dde27851f2","queries.ts","ca57540e-1203-11f1-9a25-42dde27851f2","ca044fac-1203-11f1-bfb6-42dde27851f2",13,["D",1771994291403],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Account, Transaction } from \"../../shared/types.ts\";\n\nconst ACCOUNTS = \"runway_accounts\";\nconst TRANSACTIONS = \"runway_transactions\";\nconst SYNC_STATE = \"runway_sync_state\";\n\n// ---------------------------------------------------------------------------\n// Sync state\n// ---------------------------------------------------------------------------\n\nexport async function getSyncState(key: string): Promise {\n const result = await sqlite.execute(\n `SELECT value FROM ${SYNC_STATE} WHERE key = ?`,\n [key],\n );\n return result.rows.length > 0 ? String(result.rows[0][0]) : null;\n}\n\nexport async function setSyncState(key: string, value: string): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${SYNC_STATE} (key, value) VALUES (?, ?)`,\n [key, value],\n );\n}\n\n// ---------------------------------------------------------------------------\n// Accounts\n// ---------------------------------------------------------------------------\n\nexport async function upsertAccount(account: Account): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${ACCOUNTS}\n (id, name, org_domain, currency, balance, balance_date, excluded)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [\n account.id,\n account.name,\n account.org_domain,\n account.currency,\n account.balance,\n account.balance_date,\n account.excluded ? 1 : 0,\n ],\n );\n}\n\nexport async function getAccounts(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${ACCOUNTS} ORDER BY name`);\n return result.rows.map((row) => ({\n id: String(row[0]),\n name: String(row[1]),\n org_domain: String(row[2]),\n currency: String(row[3]),\n balance: String(row[4]),\n balance_date: Number(row[5]),\n excluded: Boolean(row[6]),\n }));\n}\n\nexport async function setAccountExcluded(id: string, excluded: boolean): Promise {\n await sqlite.execute(\n `UPDATE ${ACCOUNTS} SET excluded = ? WHERE id = ?`,\n [excluded ? 1 : 0, id],\n );\n}\n\nexport async function getExcludedAccountIds(): Promise> {\n const result = await sqlite.execute(\n `SELECT id FROM ${ACCOUNTS} WHERE excluded = 1`,\n );\n return new Set(result.rows.map((row) => String(row[0])));\n}\n\n// ---------------------------------------------------------------------------\n// Transactions\n// ---------------------------------------------------------------------------\n\nexport async function upsertTransaction(tx: Transaction): Promise {\n await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS}\n (id, account_id, posted, amount, description, payee, notes, category, category_source, is_transfer, pending)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET\n account_id = excluded.account_id,\n posted = excluded.posted,\n amount = excluded.amount,\n description = excluded.description,\n payee = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN ${TRANSACTIONS}.payee ELSE excluded.payee END,\n notes = excluded.notes,\n category = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN ${TRANSACTIONS}.category ELSE excluded.category END,\n category_source = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN 'manual' ELSE excluded.category_source END,\n is_transfer = CASE WHEN ${TRANSACTIONS}.category_source = 'manual' THEN ${TRANSACTIONS}.is_transfer ELSE excluded.is_transfer END,\n pending = excluded.pending`,\n [\n tx.id,\n tx.account_id,\n tx.posted,\n tx.amount,\n tx.description,\n tx.payee,\n tx.notes,\n tx.category,\n tx.category_source,\n tx.is_transfer ? 1 : 0,\n tx.pending ? 1 : 0,\n ],\n );\n}\n\nfunction rowToTransaction(row: any[]): Transaction {\n return {\n id: String(row[0]),\n account_id: String(row[1]),\n posted: Number(row[2]),\n amount: String(row[3]),\n description: String(row[4]),\n payee: String(row[5]),\n notes: String(row[6]),\n category: String(row[7]),\n category_source: String(row[8]) as Transaction[\"category_source\"],\n is_transfer: Boolean(row[9]),\n pending: Boolean(row[10]),\n };\n}\n\nexport async function getTransactions(opts: {\n month?: string;\n category?: string;\n search?: string;\n limit?: number;\n offset?: number;\n}): Promise<{ transactions: Transaction[]; total: number }> {\n const conditions: string[] = [];\n const params: any[] = [];\n\n if (opts.month) {\n const [year, month] = opts.month.split(\"-\").map(Number);\n const start = new Date(year, month - 1, 1).getTime() / 1000;\n const end = new Date(year, month, 1).getTime() / 1000;\n conditions.push(\"posted >= ? AND posted < ?\");\n params.push(start, end);\n }\n\n if (opts.category) {\n conditions.push(\"category = ?\");\n params.push(opts.category);\n }\n\n if (opts.search) {\n conditions.push(\"(payee LIKE ? OR description LIKE ?)\");\n const term = `%${opts.search}%`;\n params.push(term, term);\n }\n\n const where = conditions.length > 0 ? `WHERE ${conditions.join(\" AND \")}` : \"\";\n\n const countResult = await sqlite.execute(\n `SELECT COUNT(*) FROM ${TRANSACTIONS} ${where}`,\n params,\n );\n const total = Number(countResult.rows[0][0]);\n\n const limit = opts.limit ?? 200;\n const offset = opts.offset ?? 0;\n const dataResult = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS} ${where} ORDER BY posted DESC LIMIT ? OFFSET ?`,\n [...params, limit, offset],\n );\n\n return {\n transactions: dataResult.rows.map(rowToTransaction),\n total,\n };\n}\n\nexport async function updateTransactionCategory(\n id: string,\n category: string,\n isTransfer: boolean,\n): Promise {\n await sqlite.execute(\n `UPDATE ${TRANSACTIONS} SET category = ?, category_source = 'manual', is_transfer = ? WHERE id = ?`,\n [category, isTransfer ? 1 : 0, id],\n );\n}\n\nexport async function getMonthlySpendByCategory(month: string): Promise> {\n const [year, m] = month.split(\"-\").map(Number);\n const start = new Date(year, m - 1, 1).getTime() / 1000;\n const end = new Date(year, m, 1).getTime() / 1000;\n\n const result = await sqlite.execute(\n `SELECT category, SUM(CAST(amount AS REAL)) as total\n FROM ${TRANSACTIONS}\n WHERE posted >= ? AND posted < ? AND is_transfer = 0\n GROUP BY category`,\n [start, end],\n );\n\n const spending: Record = {};\n for (const row of result.rows) {\n spending[String(row[0])] = Number(row[1]);\n }\n return spending;\n}\n\nexport async function getMonthlyIncome(month: string): Promise {\n const [year, m] = month.split(\"-\").map(Number);\n const start = new Date(year, m - 1, 1).getTime() / 1000;\n const end = new Date(year, m, 1).getTime() / 1000;\n\n const result = await sqlite.execute(\n `SELECT SUM(CAST(amount AS REAL))\n FROM ${TRANSACTIONS}\n WHERE posted >= ? AND posted < ? AND category = 'Income'`,\n [start, end],\n );\n\n return result.rows[0][0] ? Number(result.rows[0][0]) : 0;\n}\n",[],[152,298,290],"database","ca63fca4-1203-11f1-8b72-42dde27851f2","migrations.ts","ca63fd4e-1203-11f1-8b72-42dde27851f2",15,["D",1771994291490],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst ACCOUNTS_TABLE = \"runway_accounts\";\nconst TRANSACTIONS_TABLE = \"runway_transactions\";\nconst SYNC_STATE_TABLE = \"runway_sync_state\";\n\nexport async function runMigrations() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ACCOUNTS_TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n org_domain TEXT NOT NULL DEFAULT '',\n currency TEXT NOT NULL DEFAULT 'USD',\n balance TEXT NOT NULL DEFAULT '0',\n balance_date INTEGER NOT NULL DEFAULT 0,\n excluded INTEGER NOT NULL DEFAULT 0\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TRANSACTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n account_id TEXT NOT NULL,\n posted INTEGER NOT NULL,\n amount TEXT NOT NULL,\n description TEXT NOT NULL DEFAULT '',\n payee TEXT NOT NULL DEFAULT '',\n notes TEXT NOT NULL DEFAULT '',\n category TEXT NOT NULL DEFAULT '',\n category_source TEXT NOT NULL DEFAULT '',\n is_transfer INTEGER NOT NULL DEFAULT 0,\n pending INTEGER NOT NULL DEFAULT 0\n )`);\n\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_transactions_posted\n ON ${TRANSACTIONS_TABLE} (posted)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_transactions_category\n ON ${TRANSACTIONS_TABLE} (category)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_transactions_account\n ON ${TRANSACTIONS_TABLE} (account_id)`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SYNC_STATE_TABLE} (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`);\n}\n",[],[152,298,300],"ca044f0c-1203-11f1-bfb6-42dde27851f2",5,["D",1771994290859],[169,170],[152,298],["D",1771994289982],[168,171,172,173,174],[152],["D",1771992592978],{"_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,"_121":352,"_353":354,"_355":356,"_357":24,"_358":24,"_359":24,"_360":119,"_361":-5,"_362":-7,"_363":-7,"_364":60,"_365":24,"_366":24,"_367":-5,"_368":24,"_369":24,"_370":24,"_371":-5},"ENV",{"_323":324,"_325":326,"_327":84,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v19