Sean & Yam · Financial Tracker

\n \n \n \n\n","label",[181,68],"frontend","pulls","branches","forks","envVars",{"_189":26,"_191":26},"connections",{"_189":26,"_190":26},"count","unfilledCount","emptyCount",{"_33":374,"_13":365,"_66":359,"_43":-5,"_35":36,"_174":217,"_175":96,"_37":375,"_39":26,"_69":245,"_177":-5,"_70":24,"_179":-5,"_220":376,"_17":377},{"_33":366,"_13":367,"_66":368,"_43":359,"_35":36,"_174":369,"_175":96,"_37":370,"_39":26,"_69":237,"_177":371,"_70":24,"_179":-5,"_220":372,"_17":373},{"_33":356,"_13":357,"_66":358,"_43":359,"_35":36,"_174":360,"_175":96,"_37":361,"_39":217,"_69":237,"_177":362,"_70":24,"_179":-5,"_220":363,"_17":364},{"_33":352,"_13":181,"_66":173,"_43":-5,"_35":36,"_174":40,"_175":96,"_37":353,"_39":26,"_69":245,"_177":-5,"_70":24,"_179":-5,"_220":354,"_17":355},{"_33":348,"_13":275,"_66":269,"_43":173,"_35":36,"_174":40,"_175":96,"_37":349,"_39":26,"_69":245,"_177":-5,"_70":24,"_179":-5,"_220":350,"_17":351},{"_33":340,"_13":341,"_66":342,"_43":269,"_35":36,"_174":343,"_175":96,"_37":344,"_39":40,"_69":237,"_177":345,"_70":24,"_179":-5,"_220":346,"_17":347},{"_33":332,"_13":333,"_66":334,"_43":269,"_35":36,"_174":335,"_175":96,"_37":336,"_39":26,"_69":237,"_177":337,"_70":24,"_179":-5,"_220":338,"_17":339},{"_33":324,"_13":325,"_66":326,"_43":269,"_35":36,"_174":327,"_175":96,"_37":328,"_39":26,"_69":237,"_177":329,"_70":24,"_179":-5,"_220":330,"_17":331},{"_33":316,"_13":317,"_66":318,"_43":269,"_35":36,"_174":319,"_175":96,"_37":320,"_39":26,"_69":237,"_177":321,"_70":24,"_179":-5,"_220":322,"_17":323},{"_33":308,"_13":309,"_66":310,"_43":269,"_35":36,"_174":311,"_175":96,"_37":312,"_39":26,"_69":237,"_177":313,"_70":24,"_179":-5,"_220":314,"_17":315},{"_33":300,"_13":301,"_66":302,"_43":269,"_35":36,"_174":303,"_175":96,"_37":304,"_39":26,"_69":237,"_177":305,"_70":24,"_179":-5,"_220":306,"_17":307},{"_33":292,"_13":293,"_66":294,"_43":269,"_35":36,"_174":295,"_175":96,"_37":296,"_39":26,"_69":237,"_177":297,"_70":24,"_179":-5,"_220":298,"_17":299},{"_33":284,"_13":285,"_66":286,"_43":269,"_35":36,"_174":287,"_175":96,"_37":288,"_39":26,"_69":237,"_177":289,"_70":24,"_179":-5,"_220":290,"_17":291},{"_33":276,"_13":277,"_66":278,"_43":269,"_35":36,"_174":279,"_175":96,"_37":280,"_39":26,"_69":237,"_177":281,"_70":24,"_179":-5,"_220":282,"_17":283},{"_33":266,"_13":267,"_66":268,"_43":269,"_35":36,"_174":270,"_175":96,"_37":271,"_39":26,"_69":237,"_177":272,"_70":24,"_179":-5,"_220":273,"_17":274},{"_33":258,"_13":259,"_66":260,"_43":173,"_35":36,"_174":261,"_175":96,"_37":262,"_39":40,"_69":21,"_177":263,"_70":24,"_179":-5,"_220":264,"_17":265},{"_33":172,"_13":68,"_66":67,"_43":173,"_35":36,"_174":76,"_175":96,"_37":255,"_39":40,"_69":21,"_177":178,"_70":24,"_179":-5,"_220":256,"_17":257},{"_33":248,"_13":249,"_66":250,"_43":173,"_35":36,"_174":40,"_175":96,"_37":251,"_39":26,"_69":237,"_177":252,"_70":24,"_179":-5,"_220":253,"_17":254},{"_33":242,"_13":241,"_66":234,"_43":-5,"_35":36,"_174":243,"_175":96,"_37":244,"_39":26,"_69":245,"_177":-5,"_70":24,"_179":-5,"_220":246,"_17":247},{"_33":231,"_13":232,"_66":233,"_43":234,"_35":36,"_174":235,"_175":96,"_37":236,"_39":26,"_69":237,"_177":238,"_70":24,"_179":-5,"_220":239,"_17":240},{"_33":223,"_13":224,"_66":225,"_43":-5,"_35":36,"_174":226,"_175":96,"_37":227,"_39":217,"_69":21,"_177":228,"_70":24,"_179":-5,"_220":229,"_17":230},{"_33":214,"_13":215,"_66":94,"_43":-5,"_35":36,"_174":122,"_175":96,"_37":216,"_39":217,"_69":218,"_177":219,"_70":24,"_179":-5,"_220":221,"_17":222},"ecc0a004-51dc-11f1-b96b-ee650bb23af1","index.ts",["D",1779014473175],3,"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 frontend files with correct content type\napp.get(\"/frontend/*\", async (c) => {\n const path = c.req.path;\n const res = await serveFile(path);\n const newRes = new Response(res.body, res);\n newRes.headers.set(\"Content-Type\", \"application/javascript\");\n return newRes;\n});\n\n// Serve index.html at root\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\"));\n\n// Catch-all\napp.get(\"*\", (c) => serveFile(\"/frontend/index.html\"));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;","children",[],[215],"b5d06c28-51d7-11f1-9fbc-ee650bb23af1","README.md","019e354b-4058-72f9-b23c-11bbeafa2ec0",25,["D",1779012233525],"# 💎 Sean & Yam Financial Tracker\n\nA premium shared financial dashboard for tracking loans, commitments, and debt\nrepayment progress together.\n\n## Features\n\n- **Dashboard** — Monthly commitments per person and combined, total loan debt,\n estimated payoff date\n- **Loan Management** — Full CRUD with lender dropdown, loan type, descriptions,\n and all financial details\n- **12-Month Payment Tracker** — Toggle PAID/UNPAID per month, auto-updates\n balances\n- **Payment Due Alerts** — Warnings when any payment is due within 5 days\n- **Milestone Celebrations** — 🎉 at 70% and 🏆 at 100% paid off\n- **What-If Calculator** — See how extra payments accelerate debt freedom\n- **Message Board** — Leave notes for each other with timestamps\n- **Debt Chart** — Visual bar chart showing projected debt reduction over time\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts (Hono)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| React[\"App.tsx\"]\n React -->|\"fetch /api/*\"| API[\"backend/api.ts\"]\n API -->|read/write| DB[\"SQLite\"]\n```\n\n## Tech Stack\n\n- **Frontend**: React 18 + Twind (Tailwind CSS)\n- **Backend**: Hono on Val Town\n- **Database**: Val Town SQLite\n- **Theme**: Deep navy (#0a0f1e) + electric blue (#3b82f6) + teal (#14b8a6)",[],[224],"e8eaa762-51d3-11f1-8889-ee650bb23af1","types.ts","e8eaa87a-51d3-11f1-8889-ee650bb23af1","e3e018ba-51d3-11f1-bbb6-ee650bb23af1",4,["D",1779010601265],"script","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",[],[241,232],"shared","e3e017e8-51d3-11f1-bbb6-ee650bb23af1",2,["D",1779010592818],"directory",[211],[241],"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,249],["D",1779010659735],[],[181,68],"a86a84fe-51d4-11f1-adba-ee650bb23af1","favicon.svg","019e354b-4058-72f9-b23c-000f0dfe3a0f",20,["D",1779010922523],"\n\n",[],[181,259],"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,275,267],"components","667b8ff2-51d4-11f1-bda7-ee650bb23af1","WhatIfCalculator.tsx","667b90e2-51d4-11f1-bda7-ee650bb23af1",15,["D",1779010811941],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { CalculatorIcon } from \"./Icons.tsx\";\n\nconst fmt = (n: number) => `RM ${n.toLocaleString(\"en-MY\", { minimumFractionDigits: 2, maximumFractionDigits: 2 })}`;\n\nexport function WhatIfCalculator({ loans }: { loans: any[] }) {\n const [extra, setExtra] = useState(\"\");\n\n const results = useMemo(() => {\n const extraAmt = Number(extra) || 0;\n if (extraAmt <= 0) return null;\n\n const nonRental = loans.filter((l: any) => !l.isRental && l.currentBalance > 0);\n const totalBalance = nonRental.reduce((s: number, l: any) => s + l.currentBalance, 0);\n const totalMonthly = nonRental.reduce((s: number, l: any) => s + l.monthlyPayment, 0);\n if (totalMonthly === 0 || totalBalance === 0) return null;\n\n const monthsWithout = Math.ceil(totalBalance / totalMonthly);\n const monthsWith = Math.ceil(totalBalance / (totalMonthly + extraAmt));\n const monthsSaved = monthsWithout - monthsWith;\n\n // Rough interest saved (simplified)\n const avgRate = nonRental.reduce((s: number, l: any) => s + l.interestRate, 0) / (nonRental.length || 1);\n const interestSaved = totalBalance * (avgRate / 100 / 12) * monthsSaved;\n\n const newPayoffDate = new Date();\n newPayoffDate.setMonth(newPayoffDate.getMonth() + monthsWith);\n\n return { monthsWithout, monthsWith, monthsSaved, interestSaved, newPayoffDate };\n }, [extra, loans]);\n\n return (\n

\n 🔮 What-If Calculator\n

See how extra payments speed up your debt freedom!

\n\n

\n Extra Monthly Payment (RM)\n setExtra(e.target.value)}\n className=\"w-full bg-navy-700 text-white rounded-xl px-4 py-3 text-sm border border-navy-600/30 focus:outline-none focus:ring-2 focus:ring-electric/50\"\n />\n

\n\n {results && (\n

⏱ Months Saved

{results.monthsSaved}

{results.monthsWith} instead of {results.monthsWithout} months

💰 Interest Saved

{fmt(results.interestSaved)}

Estimated savings

🎯 New Payoff Date

{results.newPayoffDate.toLocaleDateString(\"en-MY\", { month: \"short\", year: \"numeric\" })}

Debt-free sooner!

\n )}\n

\n );\n}\n",[],[181,275,277],"51296dd6-51d4-11f1-9af0-ee650bb23af1","PaymentTracker.tsx","51296ebc-51d4-11f1-9af0-ee650bb23af1",13,["D",1779010776171],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { CheckIcon, XIcon } from \"./Icons.tsx\";\nimport { apiPost } from \"./hooks.ts\";\n\nconst MONTH_NAMES = [\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\"];\nconst fmt = (n: number) => `RM ${n.toLocaleString(\"en-MY\", { minimumFractionDigits: 2, maximumFractionDigits: 2 })}`;\n\nexport function PaymentTracker({ loans, payments, onUpdate }: { loans: any[]; payments: any[]; onUpdate: () => void }) {\n const [toggling, setToggling] = useState(null);\n const currentYear = new Date().getFullYear();\n const [year, setYear] = useState(currentYear);\n\n const toggle = async (loanId: number, month: number, isPaid: boolean, paidBy: string) => {\n const key = `${loanId}-${month}-${year}`;\n setToggling(key);\n await apiPost(\"/api/payments/toggle\", { loanId, month, year, isPaid: !isPaid, paidBy });\n onUpdate();\n setToggling(null);\n };\n\n if (loans.length === 0) {\n return (\n

\n No loans added yet. Add your first loan above! ☝️\n

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

📅 12-Month Payment Tracker

\n \n {year}\n \n

\n\n {loans.map((loan: any) => {\n const loanPayments = payments.filter((p: any) => p.loanId === loan.id && p.year === year);\n const progress = loan.principal > 0 ? Math.min(100, (loan.totalPaid / loan.principal) * 100) : 0;\n\n return (\n

\n {loan.name}\n ({loan.lender === \"Other\" ? loan.lenderOther : loan.lender})\n {loan.paidBy}\n

\n Balance: {fmt(loan.currentBalance)}\n

\n\n {/* Progress bar */}\n

{progress.toFixed(1)}% paid off

\n\n {/* Month grid */}\n

\n {MONTH_NAMES.map((m, idx) => {\n const monthNum = idx + 1;\n const record = loanPayments.find((p: any) => p.month === monthNum);\n const isPaid = record?.isPaid;\n const key = `${loan.id}-${monthNum}-${year}`;\n const isLoading = toggling === key;\n\n return (\n toggle(loan.id, monthNum, isPaid, loan.paidBy)}\n disabled={isLoading}\n className={`flex flex-col items-center p-2 rounded-xl transition-all cursor-pointer text-xs font-medium border ${\n isPaid\n ? \"bg-teal/10 border-teal/30 text-teal hover:bg-teal/20\"\n : \"bg-navy-700/50 border-navy-600/20 text-blue-400 hover:bg-navy-600/50\"\n } ${isLoading ? \"opacity-50\" : \"\"}`}\n >\n {m}\n {isPaid ? : }\n {isPaid ? \"PAID\" : \"—\"}\n \n );\n })}\n

\n );\n })}\n

\n );\n}\n",[],[181,275,285],"5ac504c2-51d4-11f1-949d-ee650bb23af1","MessageBoard.tsx","5ac505d0-51d4-11f1-949d-ee650bb23af1",14,["D",1779010792289],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { MessageIcon } from \"./Icons.tsx\";\nimport { apiPost } from \"./hooks.ts\";\n\nexport function MessageBoard({ messages, onRefresh }: { messages: any[]; onRefresh: () => void }) {\n const [author, setAuthor] = useState<\"Sean\" | \"Yam\">(\"Sean\");\n const [content, setContent] = useState(\"\");\n const [sending, setSending] = useState(false);\n\n const send = async () => {\n if (!content.trim()) return;\n setSending(true);\n await apiPost(\"/api/messages\", { author, content: content.trim() });\n setContent(\"\");\n onRefresh();\n setSending(false);\n };\n\n const handleKeyDown = (e: any) => {\n if (e.key === \"Enter\" && !e.shiftKey) { e.preventDefault(); send(); }\n };\n\n return (\n

\n 💬 Message Board\n

\n\n {/* Input */}\n

\n setAuthor(e.target.value)}\n className=\"bg-navy-700 text-white rounded-xl px-3 py-3 text-sm border border-navy-600/30 cursor-pointer focus:outline-none focus:ring-2 focus:ring-electric/50\"\n >\n \n \n \n setContent(e.target.value)}\n onKeyDown={handleKeyDown}\n placeholder=\"Leave a note for each other...\"\n className=\"flex-1 bg-navy-700 text-white rounded-xl px-4 py-3 text-sm border border-navy-600/30 focus:outline-none focus:ring-2 focus:ring-electric/50\"\n />\n \n Send\n \n

\n\n {/* Messages */}\n

\n {messages.length === 0 &&

No messages yet. Say hi! 👋

}\n {messages.map((msg: any) => (\n

\n {msg.author[0]}\n

\n {msg.author}\n {new Date(msg.createdAt + \"Z\").toLocaleString(\"en-MY\", { dateStyle: \"medium\", timeStyle: \"short\" })}\n

{msg.content}

\n ))}\n

\n );\n}\n",[],[181,275,293],"824cf9e6-51d4-11f1-be2d-ee650bb23af1","LoanList.tsx","824cfa90-51d4-11f1-be2d-ee650bb23af1",17,["D",1779010858612],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { EditIcon, TrashIcon } from \"./Icons.tsx\";\n\nconst fmt = (n: number) => `RM ${n.toLocaleString(\"en-MY\", { minimumFractionDigits: 2, maximumFractionDigits: 2 })}`;\n\nexport function LoanList({ loans, onEdit, onDelete }: { loans: any[]; onEdit: (l: any) => void; onDelete: (id: number) => void }) {\n if (loans.length === 0) return null;\n\n const seanLoans = loans.filter((l: any) => l.paidBy === \"Sean\");\n const yamLoans = loans.filter((l: any) => l.paidBy === \"Yam\");\n\n const renderGroup = (title: string, items: any[], color: string) => {\n if (items.length === 0) return null;\n return (\n

👤 {title}'s Commitments ({items.length})

\n {items.map((loan: any) => {\n const progress = loan.principal > 0 ? Math.min(100, (loan.totalPaid / loan.principal) * 100) : 0;\n return (\n

\n {loan.name}\n {loan.isRental && RENTAL}\n

\n \n \n

\n\n

Lender: {loan.lender === \"Other\" ? loan.lenderOther : loan.lender}

Type: {loan.loanType}

Monthly: {fmt(loan.monthlyPayment)}

Balance: {fmt(loan.currentBalance)}

Principal: {fmt(loan.principal)}

Interest: {loan.interestRate}%

Due day: {loan.paymentDueDay}th

Paid: {fmt(loan.totalPaid)}

\n\n {loan.description && (\n

\n {loan.description}\n

\n )}\n\n {!loan.isRental && (\n

\n )}\n

\n );\n })}\n

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

💳 All Loans & Commitments

\n {renderGroup(\"Sean\", seanLoans, \"text-blue-300\")}\n {renderGroup(\"Yam\", yamLoans, \"text-teal\")}\n

\n );\n}\n",[],[181,275,301],"42d858be-51d4-11f1-b112-ee650bb23af1","LoanForm.tsx","42d8595e-51d4-11f1-b112-ee650bb23af1",12,["D",1779010752151],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { LENDERS, LOAN_TYPES } from \"../../shared/types.ts\";\nimport { PlusIcon, EditIcon } from \"./Icons.tsx\";\n\nconst inputCls = \"w-full rounded-xl px-4 py-3 text-white text-sm focus:outline-none focus:ring-2 focus:ring-electric/50 transition-all\";\nconst labelCls = \"text-blue-300 text-xs font-semibold uppercase tracking-wider mb-1.5 block\";\nconst selectCls = `${inputCls} appearance-none cursor-pointer`;\n\nexport function LoanForm({ onSubmit, editLoan, onCancel }: { onSubmit: (data: any) => void; editLoan?: any; onCancel?: () => void }) {\n const blank = {\n name: \"\", lender: \"Atome\", lenderOther: \"\", loanType: \"Personal Loan\", description: \"\",\n principal: \"\", interestRate: \"\", monthlyPayment: \"\", totalPaid: \"\", currentBalance: \"\",\n startDate: \"\", endDate: \"\", paymentDueDay: \"1\", paidBy: \"Sean\", isRental: false,\n };\n const [form, setForm] = useState(blank);\n\n useEffect(() => {\n if (editLoan) {\n setForm({\n ...editLoan,\n principal: String(editLoan.principal),\n interestRate: String(editLoan.interestRate),\n monthlyPayment: String(editLoan.monthlyPayment),\n totalPaid: String(editLoan.totalPaid),\n currentBalance: String(editLoan.currentBalance),\n paymentDueDay: String(editLoan.paymentDueDay),\n isRental: Boolean(editLoan.isRental),\n });\n }\n }, [editLoan]);\n\n const set = (key: string) => (e: any) => {\n const val = e.target.type === \"checkbox\" ? e.target.checked : e.target.value;\n setForm((f: any) => ({ ...f, [key]: val }));\n };\n\n const handleSubmit = (e: any) => {\n e.preventDefault();\n onSubmit({\n ...form,\n principal: Number(form.principal) || 0,\n interestRate: Number(form.interestRate) || 0,\n monthlyPayment: Number(form.monthlyPayment) || 0,\n totalPaid: Number(form.totalPaid) || 0,\n currentBalance: Number(form.currentBalance) || 0,\n paymentDueDay: Number(form.paymentDueDay) || 1,\n });\n if (!editLoan) setForm(blank);\n };\n\n return (\n

\n {editLoan ? <> Edit Loan : <> Add New Loan}\n

\n\n

\n 💳 Loan Name\n \n

\n 🏦 Lender\n \n

\n {form.lender === \"Other\" && (\n

\n 🏦 Lender Name\n \n

\n )}\n

\n 📋 Loan Type\n \n

\n 💰 Principal Amount (RM)\n \n

\n 📊 Interest Rate (%)\n \n

\n 📅 Monthly Payment (RM)\n \n

\n ✅ Total Paid So Far (RM)\n \n

\n 📉 Current Balance (RM)\n \n

\n 🗓 Start Date\n \n

\n 🏁 End Date\n \n

\n 📆 Due Day (1-31)\n \n

\n 👤 Paid By\n \n

\n \n \n 🏠 This is rental / utility (not a loan)\n \n

\n\n

\n 📝 Description\n

\n      </div>\n\n      <div className=\"flex gap-3 pt-2\">\n        <button type=\"submit\" className=\"bg-electric hover:bg-blue-600 text-white font-semibold px-8 py-3 rounded-xl transition-all shadow-lg shadow-blue-500/20 cursor-pointer text-sm\">\n          {editLoan ? \"💾 Save Changes\" : \"➕ Add Loan\"}\n        </button>\n        {onCancel && (\n          <button type=\"button\" onClick={onCancel} className=\"bg-navy-700 hover:bg-navy-600 text-blue-300 font-semibold px-6 py-3 rounded-xl transition-all cursor-pointer text-sm\">\n            Cancel\n          </button>\n        )}\n      </div>\n    </form>\n  );\n}\n",[],[181,275,309],"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  <svg width={size} height={size} viewBox=\"0 0 24 24\" fill=\"none\" stroke={color} strokeWidth=\"2\" strokeLinecap=\"round\" strokeLinejoin=\"round\">\n    <path d={d} />\n  </svg>\n);\n\nexport const WalletIcon = () => <Icon d=\"M21 12V7H5a2 2 0 0 1 0-4h14v4M3 5v14a2 2 0 0 0 2 2h16v-5M18 12a1 1 0 1 0 0 2 1 1 0 0 0 0-2z\" />;\nexport const ChartIcon = () => <Icon d=\"M18 20V10M12 20V4M6 20v-6\" />;\nexport const CalendarIcon = () => <Icon d=\"M8 2v4M16 2v4M3 10h18M5 4h14a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2z\" />;\nexport const UserIcon = () => <Icon d=\"M20 21v-2a4 4 0 0 0-4-4H8a4 4 0 0 0-4 4v2M12 3a4 4 0 1 0 0 8 4 4 0 0 0 0-8z\" />;\nexport const PlusIcon = () => <Icon d=\"M12 5v14M5 12h14\" />;\nexport const AlertIcon = () => <Icon d=\"M12 9v4M12 17h.01M10.29 3.86L1.82 18a2 2 0 0 0 1.71 3h16.94a2 2 0 0 0 1.71-3L13.71 3.86a2 2 0 0 0-3.42 0z\" color=\"#f59e0b\" />;\nexport const CheckIcon = () => <Icon d=\"M20 6L9 17l-5-5\" color=\"#14b8a6\" />;\nexport const XIcon = () => <Icon d=\"M18 6L6 18M6 6l12 12\" color=\"#ef4444\" />;\nexport const MessageIcon = () => <Icon d=\"M21 15a2 2 0 0 1-2 2H7l-4 4V5a2 2 0 0 1 2-2h14a2 2 0 0 1 2 2z\" />;\nexport const TrophyIcon = () => <Icon d=\"M6 9H4.5a2.5 2.5 0 0 1 0-5H6M18 9h1.5a2.5 2.5 0 0 0 0-5H18M4 22h16M10 22V9M14 22V9M8 2h8l-1 7H9L8 2z\" color=\"#f59e0b\" />;\nexport const CalculatorIcon = () => <Icon d=\"M4 2h16a2 2 0 0 1 2 2v16a2 2 0 0 1-2 2H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2zM8 10h.01M12 10h.01M16 10h.01M8 14h.01M12 14h.01M16 14h.01M8 18h.01M12 18h.01M16 18h.01\" />;\nexport const TrashIcon = () => <Icon d=\"M3 6h18M19 6v14a2 2 0 0 1-2 2H7a2 2 0 0 1-2-2V6m3 0V4a2 2 0 0 1 2-2h4a2 2 0 0 1 2 2v2\" color=\"#ef4444\" />;\nexport const EditIcon = () => <Icon d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7M18.5 2.5a2.12 2.12 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\" />;\nexport const DollarIcon = () => <Icon d=\"M12 1v22M17 5H9.5a3.5 3.5 0 0 0 0 7h5a3.5 3.5 0 0 1 0 7H6\" color=\"#14b8a6\" />;\nexport const TargetIcon = () => <Icon d=\"M12 2a10 10 0 1 0 0 20 10 10 0 0 0 0-20zM12 6a6 6 0 1 0 0 12 6 6 0 0 0 0-6zM12 10a2 2 0 1 0 0 4 2 2 0 0 0 0-4z\" />;\n",[],[181,275,317],"754b17b4-51d4-11f1-b2ff-ee650bb23af1","DebtChart.tsx","754b1854-51d4-11f1-b2ff-ee650bb23af1",16,["D",1779010836789],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { ChartIcon } from \"./Icons.tsx\";\n\nconst fmt = (n: number) => `RM ${(n / 1000).toFixed(1)}k`;\n\nexport function DebtChart({ loans }: { loans: any[] }) {\n  const chartData = useMemo(() => {\n    const seanLoans = loans.filter((l: any) => l.paidBy === \"Sean\" && !l.isRental);\n    const yamLoans = loans.filter((l: any) => l.paidBy === \"Yam\" && !l.isRental);\n\n    let seanBal = seanLoans.reduce((s: number, l: any) => s + l.currentBalance, 0);\n    let yamBal = yamLoans.reduce((s: number, l: any) => s + l.currentBalance, 0);\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\n    const points: { label: string; sean: number; yam: number }[] = [];\n    const now = new Date();\n\n    for (let i = 0; i <= 36; i += 2) {\n      const d = new Date(now);\n      d.setMonth(d.getMonth() + i);\n      const label = d.toLocaleDateString(\"en-MY\", { month: \"short\", year: \"2-digit\" });\n      points.push({\n        label,\n        sean: Math.max(0, seanBal),\n        yam: Math.max(0, yamBal),\n      });\n      seanBal -= seanMonthly * 2;\n      yamBal -= yamMonthly * 2;\n      if (seanBal <= 0 && yamBal <= 0) break;\n    }\n\n    return points;\n  }, [loans]);\n\n  if (loans.filter((l: any) => !l.isRental).length === 0) {\n    return null;\n  }\n\n  const maxVal = Math.max(...chartData.flatMap((d) => [d.sean, d.yam]), 1);\n  const chartH = 220;\n  const barW = Math.max(12, Math.min(30, 600 / chartData.length / 2.5));\n\n  return (\n    <div className=\"bg-navy-800 rounded-2xl p-5 border border-navy-600/30\">\n      <h3 className=\"text-lg font-bold text-white flex items-center gap-2 mb-2\">\n        <ChartIcon /> 📊 Debt Reduction Timeline\n      </h3>\n      <p className=\"text-blue-300 text-sm mb-4\">Projected balance every 2 months — watch it go to zero! 🎯</p>\n\n      <div className=\"flex items-center gap-6 mb-4 text-xs\">\n        <div className=\"flex items-center gap-2\">\n          <div className=\"w-3 h-3 rounded-sm bg-electric\" />\n          <span className=\"text-blue-300\">Sean</span>\n        </div>\n        <div className=\"flex items-center gap-2\">\n          <div className=\"w-3 h-3 rounded-sm bg-teal\" />\n          <span className=\"text-blue-300\">Yam</span>\n        </div>\n      </div>\n\n      <div className=\"overflow-x-auto\">\n        <div className=\"min-w-[500px]\">\n          {/* Y-axis labels */}\n          <div className=\"flex\">\n            <div className=\"w-16 shrink-0 flex flex-col justify-between text-right pr-2\" style={{ height: chartH }}>\n              <span className=\"text-blue-400/50 text-[10px]\">{fmt(maxVal)}</span>\n              <span className=\"text-blue-400/50 text-[10px]\">{fmt(maxVal / 2)}</span>\n              <span className=\"text-blue-400/50 text-[10px]\">RM 0</span>\n            </div>\n\n            {/* Chart area */}\n            <div className=\"flex-1 border-l border-b border-navy-600/30 relative\" style={{ height: chartH }}>\n              {/* Grid lines */}\n              <div className=\"absolute inset-0\">\n                <div className=\"border-b border-navy-600/15 absolute w-full\" style={{ top: \"25%\" }} />\n                <div className=\"border-b border-navy-600/15 absolute w-full\" style={{ top: \"50%\" }} />\n                <div className=\"border-b border-navy-600/15 absolute w-full\" style={{ top: \"75%\" }} />\n              </div>\n\n              {/* Bars */}\n              <div className=\"absolute inset-0 flex items-end justify-around px-2\">\n                {chartData.map((d, i) => (\n                  <div key={i} className=\"flex flex-col items-center gap-0.5\">\n                    <div className=\"flex items-end gap-0.5\">\n                      <div\n                        className=\"bg-gradient-to-t from-electric to-blue-400 rounded-t-sm transition-all duration-500\"\n                        style={{ width: barW, height: `${(d.sean / maxVal) * (chartH - 30)}px` }}\n                        title={`Sean: RM ${d.sean.toLocaleString()}`}\n                      />\n                      <div\n                        className=\"bg-gradient-to-t from-teal to-emerald-400 rounded-t-sm transition-all duration-500\"\n                        style={{ width: barW, height: `${(d.yam / maxVal) * (chartH - 30)}px` }}\n                        title={`Yam: RM ${d.yam.toLocaleString()}`}\n                      />\n                    </div>\n                  </div>\n                ))}\n              </div>\n            </div>\n          </div>\n\n          {/* X-axis labels */}\n          <div className=\"flex ml-16\">\n            <div className=\"flex-1 flex justify-around\">\n              {chartData.map((d, i) => (\n                <span key={i} className=\"text-blue-400/50 text-[10px] text-center\" style={{ width: barW * 2 + 4 }}>{d.label}</span>\n              ))}\n            </div>\n          </div>\n        </div>\n      </div>\n    </div>\n  );\n}\n",[],[181,275,325],"31419322-51d4-11f1-a219-ee650bb23af1","Dashboard.tsx","314193e0-51d4-11f1-a219-ee650bb23af1",11,["D",1779010722642],"/** @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    <div className={`bg-navy-800 rounded-2xl p-5 border border-navy-600/30 ${glow ? \"shadow-[0_0_30px_rgba(59,130,246,0.08)]\" : \"\"} ${className}`}>\n      {children}\n    </div>\n  );\n}\n\nfunction StatCard({ icon, label, value, sub, color = \"text-white\" }: any) {\n  return (\n    <Card glow>\n      <div className=\"flex items-center gap-3 mb-2\">\n        <div className=\"w-9 h-9 rounded-xl bg-navy-700 flex items-center justify-center\">{icon}</div>\n        <span className=\"text-blue-300 text-sm font-medium\">{label}</span>\n      </div>\n      <div className={`text-2xl sm:text-3xl font-bold ${color} tracking-tight`}>{value}</div>\n      {sub && <div className=\"text-blue-400/60 text-xs mt-1\">{sub}</div>}\n    </Card>\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    <div className=\"space-y-5\">\n      {/* Alerts */}\n      {stats.alerts.length > 0 && (\n        <div className=\"space-y-2\">\n          {stats.alerts.map((a: any, i: number) => (\n            <div key={i} className=\"bg-gradient-to-r from-amber-900/40 to-amber-800/20 border border-amber-500/30 rounded-xl p-4 flex items-center gap-3\">\n              <AlertIcon />\n              <div>\n                <span className=\"text-amber-300 font-semibold\">⏰ Payment Due Soon</span>\n                <span className=\"text-amber-100 ml-2\">\n                  {a.loan.name} — {fmt(a.loan.monthlyPayment)} due in {a.daysLeft} day{a.daysLeft !== 1 ? \"s\" : \"\"}\n                </span>\n              </div>\n            </div>\n          ))}\n        </div>\n      )}\n\n      {/* Milestones */}\n      {stats.milestones.length > 0 && (\n        <div className=\"space-y-2\">\n          {stats.milestones.map((m: any, i: number) => (\n            <div key={i} className={`rounded-xl p-4 border ${m.pct >= 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              <span className=\"text-2xl mr-2\">{m.pct >= 100 ? \"🎉🎊🏆\" : \"🎉✨\"}</span>\n              <span className={`font-bold ${m.pct >= 100 ? \"text-teal-300\" : \"text-blue-300\"}`}>\n                {m.pct >= 100 ? \"FULLY PAID OFF!\" : \"70% Milestone!\"}{\" \"}\n              </span>\n              <span className=\"text-white\">{m.loan.name} — {m.pct >= 100 ? \"Congratulations! This loan is completely paid off!\" : \"You've paid more than 70% — almost there! Keep going!\"}</span>\n            </div>\n          ))}\n        </div>\n      )}\n\n      {/* Stats Grid */}\n      <div className=\"grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-3 gap-4\">\n        <StatCard icon={<UserIcon />} label=\"Sean's Monthly\" value={fmt(stats.seanMonthly)} sub=\"Including rental\" />\n        <StatCard icon={<UserIcon />} label=\"Yam's Monthly\" value={fmt(stats.yamMonthly)} />\n        <StatCard icon={<WalletIcon />} label=\"Combined Monthly\" value={fmt(stats.totalMonthly)} color=\"text-electric\" sub=\"Total commitments\" />\n        <StatCard icon={<DollarIcon />} label=\"Sean's Loan Debt\" value={fmt(stats.seanDebt)} sub=\"Excluding rental\" />\n        <StatCard icon={<DollarIcon />} label=\"Yam's Loan Debt\" value={fmt(stats.yamDebt)} sub=\"Excluding rental\" />\n        <StatCard icon={<TargetIcon />} 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      </div>\n    </div>\n  );\n}\n",[],[181,275,333],"9a75504a-51d4-11f1-b525-ee650bb23af1","App.tsx","019e354b-4058-72f9-b23b-f4f7aea91f3e",18,["D",1779010899129],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useCallback, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { useApi, apiPost, apiPut, apiDelete } from \"./hooks.ts\";\nimport { Dashboard } from \"./Dashboard.tsx\";\nimport { LoanForm } from \"./LoanForm.tsx\";\nimport { LoanList } from \"./LoanList.tsx\";\nimport { PaymentTracker } from \"./PaymentTracker.tsx\";\nimport { MessageBoard } from \"./MessageBoard.tsx\";\nimport { WhatIfCalculator } from \"./WhatIfCalculator.tsx\";\nimport { DebtChart } from \"./DebtChart.tsx\";\n\ntype Tab = \"dashboard\" | \"loans\" | \"payments\" | \"tools\";\n\nexport function App() {\n  const [tab, setTab] = useState<Tab>(\"dashboard\");\n  const [editLoan, setEditLoan] = useState<any>(null);\n  const [showForm, setShowForm] = useState(false);\n\n  const { data: statsData, refetch: refetchStats } = useApi<any>(\"/api/stats\");\n  const { data: messages, refetch: refetchMessages } = useApi<any[]>(\"/api/messages\");\n\n  const loans = statsData?.loans || [];\n  const payments = statsData?.payments || [];\n\n  const refetchAll = useCallback(() => {\n    refetchStats();\n    refetchMessages();\n  }, [refetchStats, refetchMessages]);\n\n  const handleAddLoan = async (data: any) => {\n    if (editLoan) {\n      await apiPut(`/api/loans/${editLoan.id}`, data);\n      setEditLoan(null);\n    } else {\n      await apiPost(\"/api/loans\", data);\n    }\n    setShowForm(false);\n    refetchStats();\n  };\n\n  const handleDeleteLoan = async (id: number) => {\n    await apiDelete(`/api/loans/${id}`);\n    refetchStats();\n  };\n\n  const tabCls = (t: Tab) =>\n    `px-5 py-2.5 rounded-xl font-semibold text-sm transition-all cursor-pointer ${\n      tab === t\n        ? \"bg-electric text-white shadow-lg shadow-blue-500/20\"\n        : \"text-blue-300 hover:bg-navy-700 hover:text-white\"\n    }`;\n\n  return (\n    <div className=\"min-h-screen bg-navy-900 text-white\">\n      {/* Header */}\n      <header className=\"bg-gradient-to-r from-navy-800 to-navy-900 border-b border-navy-600/30 sticky top-0 z-50\">\n        <div className=\"max-w-6xl mx-auto px-4 py-4\">\n          <div className=\"flex flex-col sm:flex-row sm:items-center justify-between gap-3\">\n            <div>\n              <h1 className=\"text-xl sm:text-2xl font-bold bg-gradient-to-r from-white to-blue-300 bg-clip-text text-transparent\">\n                💎 Sean & Yam\n              </h1>\n              <p className=\"text-blue-400/60 text-xs\">Financial Freedom Tracker</p>\n            </div>\n            <nav className=\"flex gap-1 bg-navy-900/50 p-1 rounded-xl border border-navy-600/20 overflow-x-auto\">\n              <button onClick={() => setTab(\"dashboard\")} className={tabCls(\"dashboard\")}>📊 Overview</button>\n              <button onClick={() => setTab(\"loans\")} className={tabCls(\"loans\")}>💳 Loans</button>\n              <button onClick={() => setTab(\"payments\")} className={tabCls(\"payments\")}>📅 Payments</button>\n              <button onClick={() => setTab(\"tools\")} className={tabCls(\"tools\")}>🔧 Tools</button>\n            </nav>\n          </div>\n        </div>\n      </header>\n\n      {/* Content */}\n      <main className=\"max-w-6xl mx-auto px-4 py-6 space-y-6\">\n        {tab === \"dashboard\" && (\n          <>\n            <Dashboard loans={loans} payments={payments} />\n            <DebtChart loans={loans} />\n          </>\n        )}\n\n        {tab === \"loans\" && (\n          <>\n            {!showForm && !editLoan && (\n              <button\n                onClick={() => setShowForm(true)}\n                className=\"bg-electric hover:bg-blue-600 text-white font-semibold px-6 py-3 rounded-xl transition-all shadow-lg shadow-blue-500/20 cursor-pointer flex items-center gap-2\"\n              >\n                ➕ Add New Loan\n              </button>\n            )}\n            {(showForm || editLoan) && (\n              <LoanForm\n                editLoan={editLoan}\n                onSubmit={handleAddLoan}\n                onCancel={() => { setShowForm(false); setEditLoan(null); }}\n              />\n            )}\n            <LoanList loans={loans} onEdit={(l) => { setEditLoan(l); setShowForm(false); }} onDelete={handleDeleteLoan} />\n          </>\n        )}\n\n        {tab === \"payments\" && (\n          <PaymentTracker loans={loans} payments={payments} onUpdate={refetchStats} />\n        )}\n\n        {tab === \"tools\" && (\n          <>\n            <WhatIfCalculator loans={loans} />\n            <MessageBoard messages={messages || []} onRefresh={refetchMessages} />\n          </>\n        )}\n      </main>\n\n      {/* Footer */}\n      <footer className=\"border-t border-navy-600/20 mt-12 py-6 text-center\">\n        <p className=\"text-blue-400/40 text-xs\">\n          Sean & Yam Financial Tracker · Built with 💙 ·{\" \"}\n          <a href=\"/source\" className=\"underline hover:text-blue-300 transition-colors\">View Source</a>\n        </p>\n      </footer>\n    </div>\n  );\n}\n",[],[181,275,341],"df05139a-51d3-11f1-8889-ee650bb23af1",["D",1779010584120],[197,198,199,200,201,202,203,204,205,206],[181,275],"df052a92-51d3-11f1-8889-ee650bb23af1",["D",1779010584120],[196,207,208,209],[181],"fa033d02-51d8-11f1-b021-ee650bb23af1","routes.ts","fd9e4d9e-51d3-11f1-9d75-ee650bb23af1","e3e6c87c-51d3-11f1-83a1-ee650bb23af1",26,["D",1779012777434],"import { Hono } from \"npm:hono\";\nimport { initDB, sqlite } from \"./db.ts\";\n\nconst api = new Hono();\n\n// BigInt serialization fix\nconst sanitize = (data: unknown): unknown =>\n  JSON.parse(\n    JSON.stringify(data, (_, v) => typeof v === \"bigint\" ? Number(v) : v),\n  );\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(\n    \"SELECT * FROM loans ORDER BY paidBy, name\",\n  );\n  return c.json(sanitize(result.rows));\n});\n\napi.post(\"/loans\", async (c) => {\n  const loan = await c.req.json();\n  const result = await sqlite.execute({\n    sql:\n      `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,\n      loan.lender,\n      loan.lenderOther || \"\",\n      loan.loanType,\n      loan.description || \"\",\n      loan.principal,\n      loan.interestRate || 0,\n      loan.monthlyPayment,\n      loan.totalPaid || 0,\n      loan.currentBalance,\n      loan.startDate,\n      loan.endDate || \"\",\n      loan.paymentDueDay || 1,\n      loan.paidBy,\n      loan.isRental ? 1 : 0,\n    ],\n  });\n  return c.json(sanitize({ id: Number(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:\n      `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,\n      loan.lender,\n      loan.lenderOther || \"\",\n      loan.loanType,\n      loan.description || \"\",\n      loan.principal,\n      loan.interestRate || 0,\n      loan.monthlyPayment,\n      loan.totalPaid || 0,\n      loan.currentBalance,\n      loan.startDate,\n      loan.endDate || \"\",\n      loan.paymentDueDay || 1,\n      loan.paidBy,\n      loan.isRental ? 1 : 0,\n      Number(id),\n    ],\n  });\n  return c.json(sanitize({ 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(sanitize(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:\n        `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    const loan = await sqlite.execute({\n      sql: \"SELECT * FROM loans WHERE id = ?\",\n      args: [loanId],\n    });\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    const existing = await sqlite.execute({\n      sql:\n        \"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:\n          \"UPDATE payment_records SET isPaid = 0, paidAt = NULL WHERE loanId = ? AND month = ? AND year = ?\",\n        args: [loanId, month, year],\n      });\n      const loan = await sqlite.execute({\n        sql: \"SELECT * FROM loans WHERE id = ?\",\n        args: [loanId],\n      });\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:\n            \"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(\n    \"SELECT * FROM payment_records ORDER BY year, month\",\n  );\n  return c.json(sanitize(result.rows));\n});\n\n// ── Messages ──\n\napi.get(\"/messages\", async (c) => {\n  const result = await sqlite.execute(\n    \"SELECT * FROM messages ORDER BY createdAt DESC LIMIT 50\",\n  );\n  return c.json(sanitize(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(sanitize({ id: Number(result.lastInsertRowid), ...msg }), 201);\n});\n\n// ── Dashboard Stats ──\n\napi.get(\"/stats\", async (c) => {\n  const loans = await sqlite.execute(\n    \"SELECT * FROM loans ORDER BY paidBy, name\",\n  );\n  const payments = await sqlite.execute(\"SELECT * FROM payment_records\");\n  return c.json(sanitize({\n    loans: loans.rows,\n    payments: payments.rows,\n  }));\n});\n\nexport default api;",[],[365,357],"backend","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",[],[365,367],"e3e6c7c8-51d3-11f1-83a1-ee650bb23af1",["D",1779010592837],[193,194],[365],["D",1779010584120],["D",1789555877593],{"_11":12,"_138":73},{"_11":12,"_134":73,"_72":73,"_30":71,"_135":136,"_137":24},{"_39":122,"_13":16,"_33":36,"_123":84,"_124":63,"_125":126,"_127":88,"_128":129,"_130":131,"_132":14,"_133":12},"ctx",{"_52":-5,"_159":416,"_417":418,"_419":420,"_421":24,"_422":24,"_423":24,"_424":96,"_425":-5,"_426":-7,"_427":-7,"_428":26,"_429":24,"_430":24,"_431":-5,"_432":24,"_433":24,"_434":24,"_435":-5},"ENV",{"_387":388,"_389":390,"_391":16,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415},"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"]
</article></body></html>

History · index.html