[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_281":282,"_283":284},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":52,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":24,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",15,"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/database/migrations.ts","latestPath","fileId","ca63fd4e-1203-11f1-8b72-42dde27851f2","name","migrations.ts","fileType","script","content","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","createdAt",["D",1771994291490],"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":277,"_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":278,"_78":279,"_80":280,"_82":24},"tree",[167,171,180,181],"files",[167,168,169,170,171,172,173,174,175,176,177,178,179,180,181],"counts",{"_157":60,"_158":148,"_159":60,"_160":161,"_162":163},"contents",[123,124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":151,"_31":152,"_29":153,"_130":-5,"_40":41,"_39":154,"_132":133,"_37":155,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":156},{"_42":145,"_31":146,"_29":147,"_130":-5,"_40":41,"_39":148,"_132":133,"_37":149,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_130":-5,"_40":41,"_39":141,"_132":133,"_37":142,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":133,"_37":134,"_13":60,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"ca5bf446-1203-11f1-89fb-42dde27851f2","deno.json","ca5bf504-1203-11f1-89fb-42dde27851f2","parentId",14,"latest",true,["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",[128],"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,"_130":-5,"_40":41,"_39":154,"_132":133,"_37":274,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_183":275,"_26":276},{"_42":269,"_31":264,"_29":258,"_130":153,"_40":41,"_39":270,"_132":133,"_37":271,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_183":272,"_26":273},{"_42":265,"_31":32,"_29":30,"_130":258,"_40":41,"_39":14,"_132":24,"_37":266,"_13":60,"_33":34,"_35":36,"_23":24,"_136":-5,"_183":267,"_26":268},{"_42":255,"_31":256,"_29":257,"_130":258,"_40":41,"_39":259,"_132":24,"_37":260,"_13":60,"_33":34,"_35":261,"_23":24,"_136":-5,"_183":262,"_26":263},{"_42":145,"_31":146,"_29":147,"_130":-5,"_40":41,"_39":148,"_132":133,"_37":252,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_183":253,"_26":254},{"_42":247,"_31":222,"_29":216,"_130":147,"_40":41,"_39":248,"_132":133,"_37":249,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_183":250,"_26":251},{"_42":239,"_31":240,"_29":241,"_130":216,"_40":41,"_39":242,"_132":24,"_37":243,"_13":60,"_33":34,"_35":244,"_23":24,"_136":-5,"_183":245,"_26":246},{"_42":231,"_31":232,"_29":233,"_130":216,"_40":41,"_39":234,"_132":133,"_37":235,"_13":60,"_33":34,"_35":236,"_23":24,"_136":-5,"_183":237,"_26":238},{"_42":223,"_31":224,"_29":225,"_130":216,"_40":41,"_39":226,"_132":24,"_37":227,"_13":60,"_33":34,"_35":228,"_23":24,"_136":-5,"_183":229,"_26":230},{"_42":213,"_31":214,"_29":215,"_130":216,"_40":41,"_39":217,"_132":133,"_37":218,"_13":60,"_33":34,"_35":219,"_23":24,"_136":-5,"_183":220,"_26":221},{"_42":205,"_31":206,"_29":207,"_130":147,"_40":41,"_39":208,"_132":133,"_37":209,"_13":60,"_33":20,"_35":210,"_23":24,"_136":-5,"_183":211,"_26":212},{"_42":197,"_31":198,"_29":199,"_130":147,"_40":41,"_39":200,"_132":133,"_37":201,"_13":60,"_33":34,"_35":202,"_23":24,"_136":-5,"_183":203,"_26":204},{"_42":189,"_31":190,"_29":191,"_130":147,"_40":41,"_39":192,"_132":133,"_37":193,"_13":60,"_33":20,"_35":194,"_23":24,"_136":-5,"_183":195,"_26":196},{"_42":138,"_31":139,"_29":140,"_130":-5,"_40":41,"_39":141,"_132":133,"_37":186,"_13":60,"_33":143,"_35":-5,"_23":24,"_136":-5,"_183":187,"_26":188},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":133,"_37":182,"_13":60,"_33":20,"_35":135,"_23":24,"_136":-5,"_183":184,"_26":185},["D",1771994291432],"children",[],[128],["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,190],"ca23adfc-1203-11f1-a75d-42dde27851f2","index.tsx","ca23aed8-1203-11f1-a75d-42dde27851f2",7,["D",1771994291053],"/** @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,198],"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,206],"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,222,214],"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,222,224],"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,222,232],"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,222,240],"c9d7cfea-1203-11f1-aea5-42dde27851f2",4,["D",1771994290565],[173,174,175,176],[146,222],["D",1771994289777],[172,177,178,179],[146],"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,264,256],"database","ca63fca4-1203-11f1-8b72-42dde27851f2",["D",1771994291490],[],[152,264,32],"ca044f0c-1203-11f1-bfb6-42dde27851f2",5,["D",1771994290859],[169,170],[152,264],["D",1771994289982],[168],[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,"_120":314,"_315":316,"_317":318,"_319":24,"_320":24,"_321":24,"_322":133,"_323":-5,"_324":-7,"_325":-7,"_326":60,"_327":24,"_328":24,"_329":-5,"_330":24,"_331":24,"_332":24,"_333":-5},"ENV",{"_285":286,"_287":288,"_289":84,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v15