[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_325":326,"_327":328},"routes/_app.x.$handle.$name",{"_109":108,"_37":50,"_117":95,"_32":111,"_13":14,"_118":-5,"_11":119,"_120":121,"_122":123,"_124":125,"_126":127,"_26":-5,"_128":129,"_130":131,"_132":30,"_133":134,"_135":64,"_136":-5,"_137":-5,"_138":139},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",11,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","2d7ecf92-2fa1-435f-975e-d197ea519597","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/components/Dashboard.tsx","latestPath","fileId","314193e0-51d4-11f1-a219-ee650bb23af1","name","Dashboard.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { WalletIcon, UserIcon, CalendarIcon, AlertIcon, DollarIcon, TargetIcon } from \"./Icons.tsx\";\n\nconst fmt = (n: number) => `RM ${n.toLocaleString(\"en-MY\", { minimumFractionDigits: 2, maximumFractionDigits: 2 })}`;\n\nfunction Card({ children, className = \"\", glow = false }: any) {\n return (\n

\n {children}\n

\n );\n}\n\nfunction StatCard({ icon, label, value, sub, color = \"text-white\" }: any) {\n return (\n \n

{icon}

\n {label}\n

{value}

\n {sub &&

{sub}

}\n \n );\n}\n\nexport function Dashboard({ loans, payments }: { loans: any[]; payments: any[] }) {\n const stats = useMemo(() => {\n const seanLoans = loans.filter((l: any) => l.paidBy === \"Sean\");\n const yamLoans = loans.filter((l: any) => l.paidBy === \"Yam\");\n\n const seanMonthly = seanLoans.reduce((s: number, l: any) => s + l.monthlyPayment, 0);\n const yamMonthly = yamLoans.reduce((s: number, l: any) => s + l.monthlyPayment, 0);\n const totalMonthly = seanMonthly + yamMonthly;\n\n // Loan debt excludes rental\n const seanDebt = seanLoans.filter((l: any) => !l.isRental).reduce((s: number, l: any) => s + l.currentBalance, 0);\n const yamDebt = yamLoans.filter((l: any) => !l.isRental).reduce((s: number, l: any) => s + l.currentBalance, 0);\n const totalDebt = seanDebt + yamDebt;\n\n // Estimated payoff date\n const allNonRental = loans.filter((l: any) => !l.isRental);\n const totalMonthlyNonRental = allNonRental.reduce((s: number, l: any) => s + l.monthlyPayment, 0);\n let monthsToPayoff = totalMonthlyNonRental > 0 ? Math.ceil(totalDebt / totalMonthlyNonRental) : 0;\n const payoffDate = new Date();\n payoffDate.setMonth(payoffDate.getMonth() + monthsToPayoff);\n\n // Due soon alerts (within 5 days)\n const today = new Date();\n const alerts: any[] = [];\n loans.forEach((l: any) => {\n const dueDate = new Date(today.getFullYear(), today.getMonth(), l.paymentDueDay);\n if (dueDate < today) dueDate.setMonth(dueDate.getMonth() + 1);\n const diff = Math.ceil((dueDate.getTime() - today.getTime()) / (1000 * 60 * 60 * 24));\n if (diff <= 5 && diff >= 0 && l.currentBalance > 0) {\n alerts.push({ loan: l, daysLeft: diff, dueDate });\n }\n });\n\n // Milestone celebrations\n const milestones: any[] = [];\n allNonRental.forEach((l: any) => {\n if (l.principal > 0) {\n const pct = (l.totalPaid / l.principal) * 100;\n if (pct >= 100) milestones.push({ loan: l, pct: 100 });\n else if (pct >= 70) milestones.push({ loan: l, pct: 70 });\n }\n });\n\n return { seanMonthly, yamMonthly, totalMonthly, seanDebt, yamDebt, totalDebt, payoffDate, monthsToPayoff, alerts, milestones };\n }, [loans, payments]);\n\n return (\n

\n {/* Alerts */}\n {stats.alerts.length > 0 && (\n

\n {stats.alerts.map((a: any, i: number) => (\n

\n \n

\n ⏰ Payment Due Soon\n \n {a.loan.name} — {fmt(a.loan.monthlyPayment)} due in {a.daysLeft} day{a.daysLeft !== 1 ? \"s\" : \"\"}\n \n

\n ))}\n

\n )}\n\n {/* Milestones */}\n {stats.milestones.length > 0 && (\n

\n {stats.milestones.map((m: any, i: number) => (\n

= 100 ? \"bg-gradient-to-r from-teal-900/50 to-emerald-800/30 border-teal-400/40\" : \"bg-gradient-to-r from-blue-900/40 to-indigo-800/20 border-blue-400/30\"}`}>\n {m.pct >= 100 ? \"🎉🎊🏆\" : \"🎉✨\"}\n = 100 ? \"text-teal-300\" : \"text-blue-300\"}`}>\n {m.pct >= 100 ? \"FULLY PAID OFF!\" : \"70% Milestone!\"}{\" \"}\n \n {m.loan.name} — {m.pct >= 100 ? \"Congratulations! This loan is completely paid off!\" : \"You've paid more than 70% — almost there! Keep going!\"}\n

\n ))}\n

\n )}\n\n {/* Stats Grid */}\n

\n } label=\"Sean's Monthly\" value={fmt(stats.seanMonthly)} sub=\"Including rental\" />\n } label=\"Yam's Monthly\" value={fmt(stats.yamMonthly)} />\n } label=\"Combined Monthly\" value={fmt(stats.totalMonthly)} color=\"text-electric\" sub=\"Total commitments\" />\n } label=\"Sean's Loan Debt\" value={fmt(stats.seanDebt)} sub=\"Excluding rental\" />\n } label=\"Yam's Loan Debt\" value={fmt(stats.yamDebt)} sub=\"Excluding rental\" />\n } label=\"Total Loan Debt\" value={fmt(stats.totalDebt)} color=\"text-teal\" sub={`Est. debt-free by ${stats.payoffDate.toLocaleDateString(\"en-MY\", { month: \"long\", year: \"numeric\" })} (~${stats.monthsToPayoff} months)`} />\n

\n );\n}\n","createdAt",["D",1779010722642],"branchVersion","branchId","defc9c24-51d3-11f1-8889-ee650bb23af1","id","deb47d54-51d3-11f1-8889-ee650bb23af1","financial-tracker",["D",1779010584120],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","94ef5435-553f-4787-a0fb-c0926a04820d","pinnedFileId","019e354b-4058-72f9-b23c-16462c7b2d59","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e34c6-b41c-7572-aff8-b2f2f04c460f","tursoName","deb47d5451d311f18889ee650bb23af1","tursoHostname","deb47d5451d311f18889ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789555877593],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_109":108,"_116":111},"org",{"_109":108,"_110":111,"_112":111,"_19":60,"_113":114,"_115":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":105,"_106":50,"_107":108},"isOwned",28,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",88,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","yamunna","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_48":49,"_37":50,"_43":320,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":321,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":322,"_89":323,"_91":324,"_93":30},"tree",[201,204,214,216,217],"files",[201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217],"counts",{"_191":68,"_192":162,"_193":68,"_194":195,"_196":197},"contents",[151,152,153,154,155],"upstreamProject",{"_48":103,"_37":147,"_57":58,"_59":148,"_54":55,"_87":149},"upstreamBranch",{"_48":98,"_43":140,"_141":142,"_37":95,"_96":103,"_13":143,"_97":-5,"_99":-5,"_144":145,"_52":-5,"_93":30,"_54":55,"_107":146,"_69":105,"_106":147},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789577999&sig=2ab81189fced4fb576e9436da67acbaf730951eef80212e8dc3c2bf0f6be2f57",{"_109":146,"_116":150},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789577999&sig=aa7aec25480c67f41f9650e8445afc21cf1a6c5fd3969752b90fbd3f6a604c46",{"_48":185,"_37":186,"_35":187,"_158":-5,"_46":47,"_45":188,"_160":64,"_43":189,"_13":68,"_39":178,"_41":-5,"_29":30,"_165":-5,"_32":190},{"_48":180,"_37":181,"_35":182,"_158":-5,"_46":47,"_45":162,"_160":64,"_43":183,"_13":68,"_39":178,"_41":-5,"_29":30,"_165":-5,"_32":184},{"_48":173,"_37":174,"_35":175,"_158":-5,"_46":47,"_45":176,"_160":64,"_43":177,"_13":68,"_39":178,"_41":-5,"_29":30,"_165":-5,"_32":179},{"_48":167,"_37":168,"_35":169,"_158":-5,"_46":47,"_45":162,"_160":30,"_43":170,"_13":68,"_39":26,"_41":171,"_29":30,"_165":-5,"_32":172},{"_48":156,"_37":157,"_35":62,"_158":-5,"_46":47,"_45":159,"_160":30,"_43":161,"_13":162,"_39":163,"_41":164,"_29":30,"_165":-5,"_32":166},"04226132-51d4-11f1-8811-ee650bb23af1","index.ts","parentId",7,"latest",["D",1779010646930],1,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport api from \"./backend/routes.ts\";\n\nconst app = new Hono();\n\n// API routes\napp.route(\"/api\", api);\n\n// Serve index.html at the root\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[157],"df052cc2-51d3-11f1-8889-ee650bb23af1","README.md","019e354b-4058-72f9-b23c-11bbeafa2ec0",["D",1779010584120],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types",[168],"e3e017e8-51d3-11f1-bbb6-ee650bb23af1","shared","e3e018ba-51d3-11f1-bbb6-ee650bb23af1",2,["D",1779010592818],"directory",[174],"df052a92-51d3-11f1-8889-ee650bb23af1","frontend","019e354b-4058-72f9-b23c-0d28155a884c",["D",1779010584120],[181],"e3e6c7c8-51d3-11f1-83a1-ee650bb23af1","backend","e3e6c87c-51d3-11f1-83a1-ee650bb23af1",3,["D",1779010592837],[186],"pulls","branches","forks","envVars",{"_198":68,"_200":68},"connections",{"_198":68,"_199":68},"count","unfilledCount","emptyCount",{"_48":185,"_37":186,"_35":187,"_158":-5,"_46":47,"_45":188,"_160":64,"_43":317,"_13":68,"_39":178,"_41":-5,"_29":30,"_165":-5,"_219":318,"_32":319},{"_48":309,"_37":310,"_35":311,"_158":187,"_46":47,"_45":312,"_160":64,"_43":313,"_13":68,"_39":40,"_41":314,"_29":30,"_165":-5,"_219":315,"_32":316},{"_48":301,"_37":302,"_35":303,"_158":187,"_46":47,"_45":304,"_160":30,"_43":305,"_13":68,"_39":40,"_41":306,"_29":30,"_165":-5,"_219":307,"_32":308},{"_48":180,"_37":181,"_35":182,"_158":-5,"_46":47,"_45":162,"_160":64,"_43":298,"_13":68,"_39":178,"_41":-5,"_29":30,"_165":-5,"_219":299,"_32":300},{"_48":294,"_37":267,"_35":261,"_158":182,"_46":47,"_45":162,"_160":64,"_43":295,"_13":68,"_39":178,"_41":-5,"_29":30,"_165":-5,"_219":296,"_32":297},{"_48":287,"_37":288,"_35":289,"_158":261,"_46":47,"_45":162,"_160":30,"_43":290,"_13":68,"_39":40,"_41":291,"_29":30,"_165":-5,"_219":292,"_32":293},{"_48":280,"_37":281,"_35":282,"_158":261,"_46":47,"_45":162,"_160":30,"_43":283,"_13":68,"_39":40,"_41":284,"_29":30,"_165":-5,"_219":285,"_32":286},{"_48":276,"_37":38,"_35":36,"_158":261,"_46":47,"_45":14,"_160":64,"_43":277,"_13":68,"_39":40,"_41":42,"_29":30,"_165":-5,"_219":278,"_32":279},{"_48":268,"_37":269,"_35":270,"_158":261,"_46":47,"_45":271,"_160":64,"_43":272,"_13":68,"_39":40,"_41":273,"_29":30,"_165":-5,"_219":274,"_32":275},{"_48":258,"_37":259,"_35":260,"_158":261,"_46":47,"_45":262,"_160":64,"_43":263,"_13":68,"_39":40,"_41":264,"_29":30,"_165":-5,"_219":265,"_32":266},{"_48":251,"_37":252,"_35":253,"_158":182,"_46":47,"_45":162,"_160":30,"_43":254,"_13":68,"_39":26,"_41":255,"_29":30,"_165":-5,"_219":256,"_32":257},{"_48":243,"_37":244,"_35":245,"_158":182,"_46":47,"_45":246,"_160":64,"_43":247,"_13":162,"_39":26,"_41":248,"_29":30,"_165":-5,"_219":249,"_32":250},{"_48":236,"_37":237,"_35":238,"_158":182,"_46":47,"_45":162,"_160":64,"_43":239,"_13":68,"_39":40,"_41":240,"_29":30,"_165":-5,"_219":241,"_32":242},{"_48":173,"_37":174,"_35":175,"_158":-5,"_46":47,"_45":176,"_160":64,"_43":233,"_13":68,"_39":178,"_41":-5,"_29":30,"_165":-5,"_219":234,"_32":235},{"_48":225,"_37":226,"_35":227,"_158":175,"_46":47,"_45":228,"_160":64,"_43":229,"_13":68,"_39":40,"_41":230,"_29":30,"_165":-5,"_219":231,"_32":232},{"_48":167,"_37":168,"_35":169,"_158":-5,"_46":47,"_45":162,"_160":30,"_43":222,"_13":68,"_39":26,"_41":171,"_29":30,"_165":-5,"_219":223,"_32":224},{"_48":156,"_37":157,"_35":62,"_158":-5,"_46":47,"_45":159,"_160":30,"_43":218,"_13":162,"_39":163,"_41":164,"_29":30,"_165":-5,"_219":220,"_32":221},["D",1779010646930],"children",[],[157],["D",1779010584120],[],[168],"e8eaa762-51d3-11f1-8889-ee650bb23af1","types.ts","e8eaa87a-51d3-11f1-8889-ee650bb23af1",4,["D",1779010601265],"export interface Loan {\n id?: number;\n name: string;\n lender: string;\n lenderOther?: string;\n loanType: string;\n description: string;\n principal: number;\n interestRate: number;\n monthlyPayment: number;\n totalPaid: number;\n currentBalance: number;\n startDate: string;\n endDate: string;\n paymentDueDay: number;\n paidBy: \"Sean\" | \"Yam\";\n isRental: boolean;\n createdAt?: string;\n}\n\nexport interface PaymentRecord {\n id?: number;\n loanId: number;\n month: number; // 1-12\n year: number;\n isPaid: boolean;\n paidBy: \"Sean\" | \"Yam\";\n paidAt?: string;\n}\n\nexport interface Message {\n id?: number;\n author: \"Sean\" | \"Yam\";\n content: string;\n createdAt?: string;\n}\n\nexport const LENDERS = [\n \"Atome\",\n \"Shopee Loan\",\n \"SPayLater\",\n \"GX Bank\",\n \"CIMB\",\n \"PTPTN\",\n \"RHB\",\n \"Public Bank\",\n \"Other\",\n] as const;\n\nexport const LOAN_TYPES = [\n \"Car Loan\",\n \"Personal Loan\",\n \"Student Loan\",\n \"Mobile Loan\",\n \"Buy Now Pay Later\",\n \"Salary Recovery\",\n \"Rental\",\n \"Utility\",\n \"Other\",\n] as const;\n",[],[174,226],["D",1779010592818],[215],[174],"df0525ec-51d3-11f1-8889-ee650bb23af1","index.tsx","019e354b-4058-72f9-b23c-0b897c958766",["D",1779010584120],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[181,237],"0bc47362-51d4-11f1-9d75-ee650bb23af1","index.html","019e354b-4058-72f9-b23c-07070e8c2ee9",8,["D",1779010659735],"\n\n \n \n \n Sean & Yam · Financial Tracker\n \n \n \n \n \n \n \n \n

\n \n \n \n\n",[],[181,244],"df051d40-51d3-11f1-8889-ee650bb23af1","favicon.svg","019e354b-4058-72f9-b23c-000f0dfe3a0f",["D",1779010584120],"\n",[],[181,252],"1076e2fa-51d4-11f1-8811-ee650bb23af1","hooks.ts","1076e3c2-51d4-11f1-8811-ee650bb23af1","019e354b-4058-72f9-b23b-fdf265d1b880",9,["D",1779010667606],"import { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\n\nexport function useApi(url: string, deps: any[] = []) {\n const [data, setData] = useState(null);\n const [loading, setLoading] = useState(true);\n\n const refetch = useCallback(async () => {\n setLoading(true);\n try {\n const res = await fetch(url);\n const json = await res.json();\n setData(json);\n } catch (e) {\n console.error(\"API error:\", e);\n }\n setLoading(false);\n }, [url, ...deps]);\n\n useEffect(() => { refetch(); }, [refetch]);\n\n return { data, loading, refetch };\n}\n\nexport async function apiPost(url: string, body: any) {\n const res = await fetch(url, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n return res.json();\n}\n\nexport async function apiPut(url: string, body: any) {\n const res = await fetch(url, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n return res.json();\n}\n\nexport async function apiDelete(url: string) {\n const res = await fetch(url, { method: \"DELETE\" });\n return res.json();\n}\n",[],[181,267,259],"components","1d33ca94-51d4-11f1-8d38-ee650bb23af1","Icons.tsx","1d33cb34-51d4-11f1-8d38-ee650bb23af1",10,["D",1779010688996],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\n// Simple SVG icon components for the finance app\nexport const Icon = ({ d, size = 18, color = \"currentColor\" }: { d: string; size?: number; color?: string }) => (\n \n);\n\nexport const WalletIcon = () => ;\nexport const ChartIcon = () => ;\nexport const CalendarIcon = () => ;\nexport const UserIcon = () => ;\nexport const PlusIcon = () => ;\nexport const AlertIcon = () => ;\nexport const CheckIcon = () => ;\nexport const XIcon = () => ;\nexport const MessageIcon = () => ;\nexport const TrophyIcon = () => ;\nexport const CalculatorIcon = () => ;\nexport const TrashIcon = () => ;\nexport const EditIcon = () => ;\nexport const DollarIcon = () => ;\nexport const TargetIcon = () => ;\n",[],[181,267,269],"31419322-51d4-11f1-a219-ee650bb23af1",["D",1779010722642],[],[181,267,38],"df050c92-51d3-11f1-8889-ee650bb23af1","Counter.tsx","019e354b-4058-72f9-b23b-f8b86cf4bd32",["D",1779010584120],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[181,267,281],"df04fb1c-51d3-11f1-8889-ee650bb23af1","App.tsx","019e354b-4058-72f9-b23b-f4f7aea91f3e",["D",1779010584120],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[181,267,288],"df05139a-51d3-11f1-8889-ee650bb23af1",["D",1779010584120],[206,207,208,209,210],[181,267],["D",1779010584120],[205,211,212,213],[181],"fd9e4ce0-51d3-11f1-9d75-ee650bb23af1","routes.ts","fd9e4d9e-51d3-11f1-9d75-ee650bb23af1",6,["D",1779010635982],"import { Hono } from \"npm:hono\";\nimport { initDB, sqlite } from \"./db.ts\";\n\nconst api = new Hono();\n\n// Initialize DB on first request\nlet dbReady = false;\napi.use(\"*\", async (_c, next) => {\n if (!dbReady) {\n await initDB();\n dbReady = true;\n }\n await next();\n});\n\n// ── Loans CRUD ──\n\napi.get(\"/loans\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM loans ORDER BY paidBy, name\");\n return c.json(result.rows);\n});\n\napi.post(\"/loans\", async (c) => {\n const loan = await c.req.json();\n const result = await sqlite.execute({\n sql: `INSERT INTO loans (name, lender, lenderOther, loanType, description, principal, interestRate, monthlyPayment, totalPaid, currentBalance, startDate, endDate, paymentDueDay, paidBy, isRental)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n loan.name, loan.lender, loan.lenderOther || \"\", loan.loanType, loan.description || \"\",\n loan.principal, loan.interestRate || 0, loan.monthlyPayment, loan.totalPaid || 0,\n loan.currentBalance, loan.startDate, loan.endDate || \"\", loan.paymentDueDay || 1,\n loan.paidBy, loan.isRental ? 1 : 0,\n ],\n });\n return c.json({ id: result.lastInsertRowid, ...loan }, 201);\n});\n\napi.put(\"/loans/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const loan = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE loans SET name=?, lender=?, lenderOther=?, loanType=?, description=?, principal=?, interestRate=?, monthlyPayment=?, totalPaid=?, currentBalance=?, startDate=?, endDate=?, paymentDueDay=?, paidBy=?, isRental=? WHERE id=?`,\n args: [\n loan.name, loan.lender, loan.lenderOther || \"\", loan.loanType, loan.description || \"\",\n loan.principal, loan.interestRate || 0, loan.monthlyPayment, loan.totalPaid || 0,\n loan.currentBalance, loan.startDate, loan.endDate || \"\", loan.paymentDueDay || 1,\n loan.paidBy, loan.isRental ? 1 : 0, Number(id),\n ],\n });\n return c.json({ id: Number(id), ...loan });\n});\n\napi.delete(\"/loans/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.batch([\n { sql: \"DELETE FROM payment_records WHERE loanId = ?\", args: [Number(id)] },\n { sql: \"DELETE FROM loans WHERE id = ?\", args: [Number(id)] },\n ]);\n return c.json({ ok: true });\n});\n\n// ── Payment Records ──\n\napi.get(\"/payments/:loanId\", async (c) => {\n const loanId = c.req.param(\"loanId\");\n const result = await sqlite.execute({\n sql: \"SELECT * FROM payment_records WHERE loanId = ? ORDER BY year, month\",\n args: [Number(loanId)],\n });\n return c.json(result.rows);\n});\n\napi.post(\"/payments/toggle\", async (c) => {\n const { loanId, month, year, isPaid, paidBy } = await c.req.json();\n\n if (isPaid) {\n await sqlite.execute({\n sql: `INSERT INTO payment_records (loanId, month, year, isPaid, paidBy, paidAt)\n VALUES (?, ?, ?, 1, ?, datetime('now'))\n ON CONFLICT(loanId, month, year) DO UPDATE SET isPaid=1, paidBy=?, paidAt=datetime('now')`,\n args: [loanId, month, year, paidBy, paidBy],\n });\n // Reduce balance\n const loan = await sqlite.execute({ sql: \"SELECT * FROM loans WHERE id = ?\", args: [loanId] });\n if (loan.rows.length > 0) {\n const l = loan.rows[0] as any;\n const newBalance = Math.max(0, l.currentBalance - l.monthlyPayment);\n const newTotalPaid = l.totalPaid + l.monthlyPayment;\n await sqlite.execute({\n sql: \"UPDATE loans SET currentBalance = ?, totalPaid = ? WHERE id = ?\",\n args: [newBalance, newTotalPaid, loanId],\n });\n }\n } else {\n // Check if record exists and was paid\n const existing = await sqlite.execute({\n sql: \"SELECT * FROM payment_records WHERE loanId = ? AND month = ? AND year = ?\",\n args: [loanId, month, year],\n });\n if (existing.rows.length > 0 && (existing.rows[0] as any).isPaid) {\n await sqlite.execute({\n sql: \"UPDATE payment_records SET isPaid = 0, paidAt = NULL WHERE loanId = ? AND month = ? AND year = ?\",\n args: [loanId, month, year],\n });\n // Restore balance\n const loan = await sqlite.execute({ sql: \"SELECT * FROM loans WHERE id = ?\", args: [loanId] });\n if (loan.rows.length > 0) {\n const l = loan.rows[0] as any;\n const newBalance = l.currentBalance + l.monthlyPayment;\n const newTotalPaid = Math.max(0, l.totalPaid - l.monthlyPayment);\n await sqlite.execute({\n sql: \"UPDATE loans SET currentBalance = ?, totalPaid = ? WHERE id = ?\",\n args: [newBalance, newTotalPaid, loanId],\n });\n }\n }\n }\n return c.json({ ok: true });\n});\n\napi.get(\"/payments/all/list\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM payment_records ORDER BY year, month\");\n return c.json(result.rows);\n});\n\n// ── Messages ──\n\napi.get(\"/messages\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM messages ORDER BY createdAt DESC LIMIT 50\");\n return c.json(result.rows);\n});\n\napi.post(\"/messages\", async (c) => {\n const msg = await c.req.json();\n const result = await sqlite.execute({\n sql: \"INSERT INTO messages (author, content) VALUES (?, ?)\",\n args: [msg.author, msg.content],\n });\n return c.json({ id: result.lastInsertRowid, ...msg }, 201);\n});\n\n// ── Dashboard Stats ──\n\napi.get(\"/stats\", async (c) => {\n const loans = await sqlite.execute(\"SELECT * FROM loans ORDER BY paidBy, name\");\n const payments = await sqlite.execute(\"SELECT * FROM payment_records\");\n return c.json({\n loans: loans.rows,\n payments: payments.rows,\n });\n});\n\nexport default api;\n",[],[186,302],"f0a0bc9e-51d3-11f1-9c7f-ee650bb23af1","db.ts","f0a0bd66-51d3-11f1-9c7f-ee650bb23af1",5,["D",1779010614208],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDB() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS loans (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n lender TEXT NOT NULL,\n lenderOther TEXT DEFAULT '',\n loanType TEXT NOT NULL,\n description TEXT DEFAULT '',\n principal REAL NOT NULL,\n interestRate REAL DEFAULT 0,\n monthlyPayment REAL NOT NULL,\n totalPaid REAL DEFAULT 0,\n currentBalance REAL NOT NULL,\n startDate TEXT NOT NULL,\n endDate TEXT DEFAULT '',\n paymentDueDay INTEGER DEFAULT 1,\n paidBy TEXT NOT NULL DEFAULT 'Sean',\n isRental INTEGER DEFAULT 0,\n createdAt TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS payment_records (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n loanId INTEGER NOT NULL,\n month INTEGER NOT NULL,\n year INTEGER NOT NULL,\n isPaid INTEGER DEFAULT 0,\n paidBy TEXT NOT NULL DEFAULT 'Sean',\n paidAt TEXT,\n FOREIGN KEY (loanId) REFERENCES loans(id) ON DELETE CASCADE,\n UNIQUE(loanId, month, year)\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n author TEXT NOT NULL,\n content TEXT NOT NULL,\n createdAt TEXT DEFAULT (datetime('now'))\n )`,\n },\n ]);\n}\n\nexport { sqlite };\n",[],[186,310],["D",1779010592837],[202,203],[186],["D",1779010584120],["D",1789555877593],{"_109":108,"_116":111},{"_109":108,"_110":111,"_112":111,"_19":60,"_113":114,"_115":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":105,"_106":50,"_107":108},"ctx",{"_87":-5,"_137":358,"_359":360,"_361":362,"_363":30,"_364":30,"_365":30,"_366":64,"_367":-5,"_368":-7,"_369":-7,"_370":68,"_371":30,"_372":30,"_373":-5,"_374":30,"_375":30,"_376":30,"_377":-5},"ENV",{"_329":330,"_331":332,"_333":95,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v11