navigate(\"dashboard\")}>\n 💰\n CashMemo\n

\n\n \n\n

\n \n \n \n \n

\n \n \n \n

\n\n

\n {renderPage()}\n

\n\n \n

\n );\n}\n",[18,83],"40720708-5357-11f1-a1cf-ee650bb23af1",["D",1779176963357],[18,67],"pulls","branches",1,"forks","envVars",{"_198":26,"_200":26},"connections",{"_198":26,"_199":26},"count","unfilledCount","emptyCount",{"_35":333,"_13":324,"_65":318,"_45":-5,"_37":38,"_170":319,"_171":24,"_39":334,"_41":26,"_68":69,"_173":-5,"_70":30,"_174":-5,"_224":335,"_17":336},{"_35":325,"_13":326,"_65":327,"_45":318,"_37":38,"_170":328,"_171":24,"_39":329,"_41":26,"_68":84,"_173":330,"_70":30,"_174":-5,"_224":331,"_17":332},{"_35":315,"_13":316,"_65":317,"_45":318,"_37":38,"_170":319,"_171":24,"_39":320,"_41":26,"_68":84,"_173":321,"_70":30,"_174":-5,"_224":322,"_17":323},{"_35":169,"_13":18,"_65":94,"_45":-5,"_37":38,"_170":42,"_171":24,"_39":312,"_41":26,"_68":69,"_173":-5,"_70":30,"_174":-5,"_224":313,"_17":314},{"_35":187,"_13":67,"_65":66,"_45":94,"_37":38,"_170":42,"_171":24,"_39":309,"_41":26,"_68":69,"_173":-5,"_70":30,"_174":-5,"_224":310,"_17":311},{"_35":301,"_13":302,"_65":303,"_45":66,"_37":38,"_170":304,"_171":24,"_39":305,"_41":26,"_68":84,"_173":306,"_70":30,"_174":-5,"_224":307,"_17":308},{"_35":293,"_13":294,"_65":295,"_45":66,"_37":38,"_170":296,"_171":24,"_39":297,"_41":26,"_68":84,"_173":298,"_70":30,"_174":-5,"_224":299,"_17":300},{"_35":285,"_13":286,"_65":287,"_45":66,"_37":38,"_170":288,"_171":24,"_39":289,"_41":26,"_68":84,"_173":290,"_70":30,"_174":-5,"_224":291,"_17":292},{"_35":278,"_13":279,"_65":280,"_45":66,"_37":38,"_170":42,"_171":24,"_39":281,"_41":26,"_68":84,"_173":282,"_70":30,"_174":-5,"_224":283,"_17":284},{"_35":270,"_13":271,"_65":272,"_45":66,"_37":38,"_170":273,"_171":24,"_39":274,"_41":26,"_68":84,"_173":275,"_70":30,"_174":-5,"_224":276,"_17":277},{"_35":262,"_13":263,"_65":264,"_45":66,"_37":38,"_170":265,"_171":24,"_39":266,"_41":26,"_68":84,"_173":267,"_70":30,"_174":-5,"_224":268,"_17":269},{"_35":254,"_13":255,"_65":256,"_45":66,"_37":38,"_170":257,"_171":24,"_39":258,"_41":26,"_68":84,"_173":259,"_70":30,"_174":-5,"_224":260,"_17":261},{"_35":183,"_13":83,"_65":82,"_45":94,"_37":38,"_170":76,"_171":24,"_39":251,"_41":26,"_68":84,"_173":185,"_70":30,"_174":-5,"_224":252,"_17":253},{"_35":179,"_13":93,"_65":92,"_45":94,"_37":38,"_170":87,"_171":24,"_39":248,"_41":26,"_68":21,"_173":181,"_70":30,"_174":-5,"_224":249,"_17":250},{"_35":244,"_13":236,"_65":230,"_45":-5,"_37":38,"_170":192,"_171":24,"_39":245,"_41":26,"_68":69,"_173":-5,"_70":30,"_174":-5,"_224":246,"_17":247},{"_35":237,"_13":238,"_65":239,"_45":230,"_37":38,"_170":192,"_171":24,"_39":240,"_41":26,"_68":84,"_173":241,"_70":30,"_174":-5,"_224":242,"_17":243},{"_35":227,"_13":228,"_65":229,"_45":230,"_37":38,"_170":231,"_171":24,"_39":232,"_41":26,"_68":84,"_173":233,"_70":30,"_174":-5,"_224":234,"_17":235},{"_35":219,"_13":220,"_65":107,"_45":-5,"_37":38,"_170":131,"_171":24,"_39":221,"_41":26,"_68":222,"_173":223,"_70":30,"_174":-5,"_224":225,"_17":226},"e1e13a50-5357-11f1-bbba-ee650bb23af1","index.tsx",["D",1779177234200],"http","import { Hono } from \"npm:hono@4\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport api from \"./backend/api.ts\";\n\nconst app = new Hono();\n\napp.onError((err) => Promise.reject(err));\n\n// API routes\napp.route(\"/api\", api);\n\n// Source link\napp.get(\"/source\", (c) => {\n const val = parseVal(import.meta.url);\n return c.redirect(val.links.self.val);\n});\n\n// Serve CSS\napp.get(\"/styles.css\", (c) => serveFile(\"./frontend/styles.css\", import.meta.url));\n\n// SPA entry\napp.get(\"*\", (c) => {\n const html = `\n\n\n \n \n CashMemo — Cash Record Management\n 💰\"/>\n \n \n \n\n\n

\n \n\n`;\n return new Response(html, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n});\n\nexport default app.fetch;\n","children",[],[220],"08d3064e-5357-11f1-8afd-ee650bb23af1","utils.ts","08d3070c-5357-11f1-8afd-ee650bb23af1","94294912-1b8d-4f7a-9a1c-2009c240a3d7",2,["D",1779176870024],"// Amount to words converter - Lakhs/Crores aware (Indian numbering system)\n\nconst ones = [\n \"\", \"One\", \"Two\", \"Three\", \"Four\", \"Five\", \"Six\", \"Seven\", \"Eight\", \"Nine\",\n \"Ten\", \"Eleven\", \"Twelve\", \"Thirteen\", \"Fourteen\", \"Fifteen\", \"Sixteen\",\n \"Seventeen\", \"Eighteen\", \"Nineteen\"\n];\nconst tens = [\"\", \"\", \"Twenty\", \"Thirty\", \"Forty\", \"Fifty\", \"Sixty\", \"Seventy\", \"Eighty\", \"Ninety\"];\n\nfunction twoDigitWords(n: number): string {\n if (n < 20) return ones[n];\n return tens[Math.floor(n / 10)] + (n % 10 ? \" \" + ones[n % 10] : \"\");\n}\n\nfunction threeDigitWords(n: number): string {\n if (n >= 100) {\n return ones[Math.floor(n / 100)] + \" Hundred\" + (n % 100 ? \" and \" + twoDigitWords(n % 100) : \"\");\n }\n return twoDigitWords(n);\n}\n\nexport function amountToWords(amount: number): string {\n if (amount === 0) return \"Zero Rupees Only\";\n if (amount < 0) return \"Minus \" + amountToWords(-amount);\n\n const intPart = Math.floor(amount);\n const paisePart = Math.round((amount - intPart) * 100);\n\n let words = \"\";\n let remaining = intPart;\n\n // Crores (1,00,00,000)\n if (remaining >= 10000000) {\n const crores = Math.floor(remaining / 10000000);\n words += threeDigitWords(crores) + \" Crore \";\n remaining %= 10000000;\n }\n\n // Lakhs (1,00,000)\n if (remaining >= 100000) {\n const lakhs = Math.floor(remaining / 100000);\n words += twoDigitWords(lakhs) + \" Lakh \";\n remaining %= 100000;\n }\n\n // Thousands (1,000)\n if (remaining >= 1000) {\n const thousands = Math.floor(remaining / 1000);\n words += twoDigitWords(thousands) + \" Thousand \";\n remaining %= 1000;\n }\n\n // Hundreds and below\n if (remaining > 0) {\n words += threeDigitWords(remaining);\n }\n\n words = words.trim() + \" Rupees\";\n\n if (paisePart > 0) {\n words += \" and \" + twoDigitWords(paisePart) + \" Paise\";\n }\n\n return words + \" Only\";\n}\n\nexport function formatIndianCurrency(amount: number): string {\n const isNeg = amount < 0;\n const abs = Math.abs(amount);\n const [intPart, decPart] = abs.toFixed(2).split(\".\");\n\n let formatted = \"\";\n const digits = intPart.split(\"\").reverse();\n for (let i = 0; i < digits.length; i++) {\n if (i === 3 || (i > 3 && (i - 3) % 2 === 0)) formatted = \",\" + formatted;\n formatted = digits[i] + formatted;\n }\n\n return (isNeg ? \"-\" : \"\") + \"₹\" + formatted + \".\" + decPart;\n}\n\nexport function generateVoucherNumber(type: \"cash_in\" | \"cash_out\"): string {\n const prefix = type === \"cash_in\" ? \"CI\" : \"CO\";\n const date = new Date();\n const y = date.getFullYear().toString().slice(-2);\n const m = (date.getMonth() + 1).toString().padStart(2, \"0\");\n const d = date.getDate().toString().padStart(2, \"0\");\n const rand = Math.floor(Math.random() * 9000 + 1000);\n return `${prefix}-${y}${m}${d}-${rand}`;\n}\n\nexport function isOverdue(deadline: string): boolean {\n if (!deadline) return false;\n return new Date(deadline) < new Date();\n}\n\nexport function daysUntilDeadline(deadline: string): number {\n if (!deadline) return Infinity;\n const diff = new Date(deadline).getTime() - Date.now();\n return Math.ceil(diff / (1000 * 60 * 60 * 24));\n}\n",[],[236,228],"shared","ff8ba762-5356-11f1-8ab1-ee650bb23af1","types.ts","ff8ba866-5356-11f1-8ab1-ee650bb23af1",["D",1779176854472],"// Shared types for Cash Memo App\n\nexport type TransactionType = \"cash_in\" | \"cash_out\";\nexport type PaymentType = \"cash\" | \"upi\" | \"bank_transfer\" | \"cheque\";\nexport type EntryStatus = \"draft\" | \"active\" | \"settled\" | \"cancelled\";\n\nexport interface Person {\n id?: number;\n name: string;\n fatherOrCompany: string;\n mobile: string;\n altMobile: string;\n address: string;\n idProofType: string;\n idProofNumber: string;\n}\n\nexport interface Transaction {\n id?: number;\n voucherNumber: string;\n type: TransactionType;\n status: EntryStatus;\n date: string;\n time: string;\n personName: string;\n fatherOrCompany: string;\n mobile: string;\n altMobile: string;\n address: string;\n idProofType: string;\n idProofNumber: string;\n amount: number;\n amountInWords: string;\n paymentType: PaymentType;\n purpose: string;\n givenBy: string;\n receivedBy: string;\n notes: string;\n terms: string;\n settlementDeadline: string;\n customMessage: string;\n itemDescription: string;\n referenceNumber: string;\n approvalDetails: string;\n witnessName: string;\n witnessSignature: string;\n signature: string;\n category: string;\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface DashboardStats {\n totalCashIn: number;\n totalCashOut: number;\n netBalance: number;\n pendingSettlements: number;\n todayIn: number;\n todayOut: number;\n monthIn: number;\n monthOut: number;\n overdueCount: number;\n}\n\nexport interface LedgerEntry {\n personName: string;\n totalIn: number;\n totalOut: number;\n balance: number;\n pendingCount: number;\n lastTransaction: string;\n}\n\nexport interface ExportData {\n version: string;\n exportDate: string;\n transactions: Transaction[];\n persons: Person[];\n}\n",[],[236,238],"ff8bc300-5356-11f1-8ab1-ee650bb23af1",["D",1779176854472],[216,217],[236],["D",1779177222469],[],[18,93],["D",1779177153240],[],[18,83],"90e1a536-5357-11f1-acac-ee650bb23af1","VoucherPreview.tsx","90e1a5ea-5357-11f1-acac-ee650bb23af1",9,["D",1779177098305],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Transaction } from \"../../shared/types.ts\";\n\nfunction fmt(n: number) {\n const abs = Math.abs(n);\n const [i, d] = abs.toFixed(2).split(\".\");\n const digs = i.split(\"\").reverse();\n let f = \"\";\n for (let j = 0; j < digs.length; j++) {\n if (j === 3 || (j > 3 && (j - 3) % 2 === 0)) f = \",\" + f;\n f = digs[j] + f;\n }\n return \"₹\" + f + \".\" + d;\n}\n\ninterface Props {\n id: number;\n onBack: () => void;\n onEdit: (id: number) => void;\n}\n\nexport function VoucherPreview({ id, onBack, onEdit }: Props) {\n const [tx, setTx] = useState(null);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetch(`/api/transactions/${id}`).then(r => r.json()).then(d => { setTx(d); setLoading(false); });\n }, [id]);\n\n if (loading || !tx) return

Loading voucher...

;\n\n const isOverdue = tx.status === \"active\" && tx.settlementDeadline && new Date(tx.settlementDeadline) < new Date();\n\n const printVoucher = () => {\n const printWindow = window.open(\"\", \"_blank\");\n if (!printWindow) return;\n printWindow.document.write(`Voucher ${tx.voucherNumber}\n \n

\n \n ${isOverdue ? '

⚠️ OVERDUE - Past settlement deadline

' : \"\"}\n

Voucher No: ${tx.voucherNumber}

Date: ${tx.date} ${tx.time}

Person: ${tx.personName}

Father/Company: ${tx.fatherOrCompany || \"—\"}

Mobile: ${tx.mobile || \"—\"}

Address: ${tx.address || \"—\"}

ID Proof: ${tx.idProofType ? tx.idProofType + \" - \" + tx.idProofNumber : \"—\"}

Payment Mode: ${tx.paymentType?.replace(\"_\", \" \").toUpperCase()}

Purpose: ${tx.purpose || \"—\"}

Given By: ${tx.givenBy || \"—\"}

Received By: ${tx.receivedBy || \"—\"}

Status: ${tx.status.toUpperCase()}

\n ${tx.settlementDeadline ? `

Deadline: ${tx.settlementDeadline}

` : \"\"}\n ${tx.referenceNumber ? `

Ref No: ${tx.referenceNumber}

` : \"\"}\n

${fmt(tx.amount)}

${tx.amountInWords}

\n ${tx.itemDescription ? `

Items/Services: ${tx.itemDescription}

` : \"\"}\n ${tx.notes ? `

Notes: ${tx.notes}

` : \"\"}\n ${tx.terms ? `

Terms: ${tx.terms}

` : \"\"}\n ${tx.customMessage ? `

Message: ${tx.customMessage}

` : \"\"}\n ${tx.witnessName ? `

Witness: ${tx.witnessName}

` : \"\"}\n

\n ${tx.signature ? ` $\"Signature\"/$ ` : \"

\"}\n

${tx.type === \"cash_out\" ? \"Receiver\" : \"Giver\"}'s Signature

\n ${tx.witnessSignature ? ` $\"Witness\"/$ ` : \"

\"}\n

Authorized Signature

\n \n

\n \n `);\n printWindow.document.close();\n };\n\n return (\n

🧾 Voucher Preview

\n \n \n \n

\n\n

CASH MEMO / VOUCHER

Receipt & Acknowledgement

\n \n {tx.type === \"cash_in\" ? \"💰 CASH RECEIVED\" : \"💸 CASH PAID\"}\n \n \n {tx.status === \"draft\" ? \"📝 DRAFT\" : tx.status.toUpperCase()}\n \n

\n\n {isOverdue && (\n

⚠️ OVERDUE — This transaction is past its settlement deadline ({tx.settlementDeadline})

\n )}\n\n

Voucher No{tx.voucherNumber}

Date & Time{tx.date} {tx.time}

Person{tx.personName}

Father/Company{tx.fatherOrCompany || \"—\"}

Mobile{tx.mobile || \"—\"} {tx.altMobile ? `/ ${tx.altMobile}` : \"\"}

Address{tx.address || \"—\"}

ID Proof{tx.idProofType ? `${tx.idProofType}: ${tx.idProofNumber}` : \"—\"}

Payment Mode{tx.paymentType?.replace(\"_\", \" \")}

Purpose{tx.purpose || \"—\"}

Category{tx.category}

Given By{tx.givenBy || \"—\"}

Received By{tx.receivedBy || \"—\"}

\n {tx.settlementDeadline &&

Settlement Deadline{tx.settlementDeadline}

}\n {tx.referenceNumber &&

Reference No{tx.referenceNumber}

}\n {tx.approvalDetails &&

Approval{tx.approvalDetails}

}\n {tx.witnessName &&

Witness{tx.witnessName}

}\n

\n\n

{fmt(tx.amount)}

{tx.amountInWords}

\n\n {tx.itemDescription &&

Items/Services: {tx.itemDescription}

}\n {tx.notes &&

Notes: {tx.notes}

}\n {tx.terms &&

Terms & Conditions: {tx.terms}

}\n {tx.customMessage &&

Message: {tx.customMessage}

}\n\n

\n {tx.signature && $\"Signature\"$ }\n

{tx.type === \"cash_out\" ? \"Receiver\" : \"Giver\"}'s Signature

\n {tx.witnessSignature && $\"Witness\"$ }\n

Authorized Signature

\n );\n}\n",[],[18,67,255],"77f53e0c-5357-11f1-ba2a-ee650bb23af1","TransactionList.tsx","77f53ea2-5357-11f1-ba2a-ee650bb23af1",8,["D",1779177056494],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Transaction } from \"../../shared/types.ts\";\n\nfunction fmt(n: number) {\n const abs = Math.abs(n);\n const [i, d] = abs.toFixed(2).split(\".\");\n const digs = i.split(\"\").reverse();\n let f = \"\";\n for (let j = 0; j < digs.length; j++) {\n if (j === 3 || (j > 3 && (j - 3) % 2 === 0)) f = \",\" + f;\n f = digs[j] + f;\n }\n return (n < 0 ? \"-\" : \"\") + \"₹\" + f + \".\" + d;\n}\n\ninterface Props {\n onEdit: (id: number) => void;\n onView: (id: number) => void;\n onNavigate: (page: string) => void;\n filterStatus?: string;\n}\n\nexport function TransactionList({ onEdit, onView, onNavigate, filterStatus }: Props) {\n const [items, setItems] = useState([]);\n const [search, setSearch] = useState(\"\");\n const [typeFilter, setTypeFilter] = useState(\"\");\n const [statusFilter, setStatusFilter] = useState(filterStatus || \"\");\n const [loading, setLoading] = useState(true);\n\n const load = () => {\n setLoading(true);\n const params = new URLSearchParams();\n if (search) params.set(\"search\", search);\n if (typeFilter) params.set(\"type\", typeFilter);\n if (statusFilter) params.set(\"status\", statusFilter);\n fetch(`/api/transactions?${params}`).then(r => r.json()).then(d => { setItems(d); setLoading(false); });\n };\n\n useEffect(() => { load(); }, [typeFilter, statusFilter]);\n\n const isOverdue = (t: any) =>\n t.status === \"active\" && t.settlementDeadline && new Date(t.settlementDeadline) < new Date();\n\n const handleDelete = async (id: number) => {\n if (!confirm(\"Are you sure you want to delete this transaction?\")) return;\n await fetch(`/api/transactions/${id}`, { method: \"DELETE\" });\n load();\n };\n\n const handleSettle = async (id: number) => {\n await fetch(`/api/transactions/${id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status: \"settled\" })\n });\n load();\n };\n\n // Count by status\n const draftCount = items.filter(t => (t as any).status === \"draft\").length;\n const activeCount = items.filter(t => (t as any).status === \"active\").length;\n const settledCount = items.filter(t => (t as any).status === \"settled\").length;\n const overdueCount = items.filter(t => isOverdue(t)).length;\n\n return (\n

📋 Transactions

\n \n \n

\n\n {/* Status pills */}\n

\n \n \n \n \n

\n\n {/* Search/filters bar */}\n

\n setSearch(e.target.value)}\n onKeyDown={e => e.key === \"Enter\" && load()}\n className=\"form-input\"\n />\n \n

\n \n

\n\n {loading ?

: (\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {items.length === 0 && (\n \n )}\n {items.map((t: any) => (\n \n \n \n \n \n \n \n \n \n \n \n ))}\n \n

Voucher	Date	Person	Type	Amount	Payment	Status	Deadline	Actions
No transactions found
{t.voucherNumber}	{t.date}	\n {t.personName} \n {t.fatherOrCompany && {t.fatherOrCompany}}\n	\n \n {t.type === \"cash_in\" ? \"↓ In\" : \"↑ Out\"}\n \n	\n {fmt(t.amount)}\n {t.amountInWords} \n	{t.paymentType?.replace(\"_\", \" \")}	\n \n {t.status === \"draft\" ? \"📝 \" : \"\"}{t.status}\n \n	\n {t.settlementDeadline ? (\n \n {t.settlementDeadline}\n {isOverdue(t) && 🔴 OVERDUE }\n \n ) : \"—\"}\n	\n \n \n {t.status === \"active\" && (\n \n )}\n \n

\n )}\n

\n );\n}\n",[],[18,67,263],"6745ee30-5357-11f1-b178-ee650bb23af1","TransactionForm.tsx","6745eef8-5357-11f1-b178-ee650bb23af1",7,["D",1779177028500],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { SignaturePad } from \"./SignaturePad.tsx\";\nimport { amountToWords, generateVoucherNumber } from \"../../shared/utils.ts\";\nimport type { Transaction, Person } from \"../../shared/types.ts\";\n\ninterface Props {\n type: \"cash_in\" | \"cash_out\";\n editId?: number | null;\n onSave: () => void;\n onCancel: () => void;\n}\n\nconst defaultForm = (type: \"cash_in\" | \"cash_out\") => ({\n voucherNumber: generateVoucherNumber(type),\n type,\n status: \"active\" as const,\n date: new Date().toISOString().split(\"T\")[0],\n time: new Date().toTimeString().slice(0, 5),\n personName: \"\",\n fatherOrCompany: \"\",\n mobile: \"\",\n altMobile: \"\",\n address: \"\",\n idProofType: \"\",\n idProofNumber: \"\",\n amount: 0,\n amountInWords: \"\",\n paymentType: \"cash\" as const,\n purpose: \"\",\n givenBy: type === \"cash_out\" ? \"Myself\" : \"\",\n receivedBy: type === \"cash_in\" ? \"Myself\" : \"\",\n notes: \"\",\n terms: \"\",\n settlementDeadline: \"\",\n customMessage: \"\",\n itemDescription: \"\",\n referenceNumber: \"\",\n approvalDetails: \"\",\n witnessName: \"\",\n witnessSignature: \"\",\n signature: \"\",\n category: \"general\",\n});\n\nexport function TransactionForm({ type, editId, onSave, onCancel }: Props) {\n const [form, setForm] = useState(defaultForm(type));\n const [suggestions, setSuggestions] = useState([]);\n const [showSuggestions, setShowSuggestions] = useState(false);\n const [showAckDetails, setShowAckDetails] = useState(false);\n const [saving, setSaving] = useState(false);\n\n useEffect(() => {\n if (editId) {\n fetch(`/api/transactions/${editId}`).then(r => r.json()).then(data => {\n setForm(data);\n });\n }\n }, [editId]);\n\n const updateField = (field: string, value: any) => {\n setForm(prev => {\n const next = { ...prev, [field]: value };\n if (field === \"amount\") {\n next.amountInWords = value > 0 ? amountToWords(Number(value)) : \"\";\n }\n return next;\n });\n };\n\n // Person auto-fill - pulls ALL stored details\n const searchPersons = useCallback(async (q: string) => {\n if (q.length < 1) { setSuggestions([]); return; }\n const res = await fetch(`/api/persons?q=${encodeURIComponent(q)}`);\n const data = await res.json();\n setSuggestions(data);\n setShowSuggestions(data.length > 0);\n }, []);\n\n const selectPerson = (p: Person) => {\n setForm(prev => ({\n ...prev,\n personName: p.name,\n fatherOrCompany: p.fatherOrCompany || prev.fatherOrCompany,\n mobile: p.mobile || prev.mobile,\n altMobile: p.altMobile || prev.altMobile,\n address: p.address || prev.address,\n idProofType: p.idProofType || prev.idProofType,\n idProofNumber: p.idProofNumber || prev.idProofNumber,\n }));\n setShowSuggestions(false);\n };\n\n const handleSubmit = async (status: string) => {\n if (!form.personName || !form.amount) {\n alert(\"Person name and amount are required!\");\n return;\n }\n setSaving(true);\n const payload = { ...form, status };\n\n try {\n const url = editId ? `/api/transactions/${editId}` : \"/api/transactions\";\n const method = editId ? \"PUT\" : \"POST\";\n const res = await fetch(url, { method, headers: { \"Content-Type\": \"application/json\" }, body: JSON.stringify(payload) });\n if (res.ok) onSave();\n else alert(\"Error saving transaction\");\n } finally {\n setSaving(false);\n }\n };\n\n return (\n

{editId ? \"Edit\" : \"New\"} {type === \"cash_in\" ? \"💰 Cash In\" : \"💸 Cash Out\"}

\n \n

\n\n

\n {/* Basic Info */}\n

📋 Basic Information

\n Voucher Number\n updateField(\"voucherNumber\", e.target.value)} className=\"form-input mono\" />\n

\n Date\n updateField(\"date\", e.target.value)} className=\"form-input\" />\n

\n Time\n updateField(\"time\", e.target.value)} className=\"form-input\" />\n

\n Category\n \n

\n\n {/* Person Details */}\n

👤 Person Details

\n Person Name *\n { updateField(\"personName\", e.target.value); searchPersons(e.target.value); }}\n onFocus={() => form.personName && searchPersons(form.personName)}\n onBlur={() => setTimeout(() => setShowSuggestions(false), 200)}\n placeholder=\"Start typing to auto-fill...\"\n className=\"form-input\"\n />\n {showSuggestions && (\n

\n {suggestions.map((p, i) => (\n

selectPerson(p)}>\n {p.name}\n {p.fatherOrCompany} • {p.mobile} • {p.address}\n

\n ))}\n

\n )}\n

\n Father/Company Name\n updateField(\"fatherOrCompany\", e.target.value)} className=\"form-input\" />\n

\n Mobile\n updateField(\"mobile\", e.target.value)} className=\"form-input\" type=\"tel\" />\n

\n Alt. Mobile\n updateField(\"altMobile\", e.target.value)} className=\"form-input\" type=\"tel\" />\n

\n Address\n updateField(\"address\", e.target.value)} className=\"form-input\" />\n

\n ID Proof Type\n \n

\n ID Proof Number\n updateField(\"idProofNumber\", e.target.value)} className=\"form-input\" />\n

\n\n {/* Payment Details */}\n

💵 Payment Details

\n Amount (₹) *\n updateField(\"amount\", parseFloat(e.target.value) || 0)}\n className=\"form-input amount-input\"\n placeholder=\"0.00\"\n min=\"0\"\n step=\"0.01\"\n />\n

\n Amount in Words\n

{form.amountInWords || \"—\"}

\n Payment Type\n \n

\n Purpose / Reason\n updateField(\"purpose\", e.target.value)} className=\"form-input\" placeholder=\"What is this payment for?\" />\n

\n Given By\n updateField(\"givenBy\", e.target.value)} className=\"form-input\" />\n

\n Received By\n updateField(\"receivedBy\", e.target.value)} className=\"form-input\" />\n

\n Settlement Deadline\n updateField(\"settlementDeadline\", e.target.value)} className=\"form-input\" />\n

\n Notes / Remarks\n

updateField(\"notes\", e.target.value)} className=\"form-input\" rows={2} />\n            </div>\n          </div>\n        </div>\n\n        {/* Acknowledgement Details (collapsible) */}\n        <div className=\"form-section\">\n          <h3 className=\"collapsible\" onClick={() => setShowAckDetails(!showAckDetails)}>\n            📝 Acknowledgement Details {showAckDetails ? \"▼\" : \"▶\"}\n          </h3>\n          {showAckDetails && (\n            <div className=\"form-grid\">\n              <div className=\"form-group form-group-wide\">\n                <label>Terms & Conditions</label>\n                <textarea value={form.terms} onChange={e => updateField(\"terms\", e.target.value)} className=\"form-input\" rows={2} />\n              </div>\n              <div className=\"form-group form-group-wide\">\n                <label>Custom Message</label>\n                <textarea value={form.customMessage} onChange={e => updateField(\"customMessage\", e.target.value)} className=\"form-input\" rows={2} />\n              </div>\n              <div className=\"form-group form-group-wide\">\n                <label>Item/Service Description</label>\n                <textarea value={form.itemDescription} onChange={e => updateField(\"itemDescription\", e.target.value)} className=\"form-input\" rows={2} />\n              </div>\n              <div className=\"form-group\">\n                <label>Reference Number</label>\n                <input value={form.referenceNumber} onChange={e => updateField(\"referenceNumber\", e.target.value)} className=\"form-input\" />\n              </div>\n              <div className=\"form-group\">\n                <label>Approval Details</label>\n                <input value={form.approvalDetails} onChange={e => updateField(\"approvalDetails\", e.target.value)} className=\"form-input\" />\n              </div>\n              <div className=\"form-group\">\n                <label>Witness Name</label>\n                <input value={form.witnessName} onChange={e => updateField(\"witnessName\", e.target.value)} className=\"form-input\" />\n              </div>\n            </div>\n          )}\n        </div>\n\n        {/* Signatures */}\n        <div className=\"form-section\">\n          <h3>✍️ Signatures</h3>\n          <div className=\"signatures-grid\">\n            <SignaturePad\n              value={form.signature}\n              onChange={(v) => updateField(\"signature\", v)}\n              label={type === \"cash_out\" ? \"Receiver's Signature\" : \"Giver's Signature\"}\n            />\n            {showAckDetails && (\n              <SignaturePad\n                value={form.witnessSignature}\n                onChange={(v) => updateField(\"witnessSignature\", v)}\n                label=\"Witness Signature\"\n              />\n            )}\n          </div>\n        </div>\n\n        {/* Actions */}\n        <div className=\"form-actions\">\n          <button className=\"btn btn-outline\" onClick={onCancel} disabled={saving}>Cancel</button>\n          <button className=\"btn btn-warning\" onClick={() => handleSubmit(\"draft\")} disabled={saving}>\n            💾 Save as Draft\n          </button>\n          <button className=\"btn btn-primary\" onClick={() => handleSubmit(\"active\")} disabled={saving}>\n            {saving ? \"Saving...\" : \"✅ Save & Create\"}\n          </button>\n        </div>\n      </div>\n    </div>\n  );\n}\n",[],[18,67,271],"4071e048-5357-11f1-a1cf-ee650bb23af1","SignaturePad.tsx","4071e138-5357-11f1-a1cf-ee650bb23af1",["D",1779176963357],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useRef, useEffect, useState, useCallback } from \"https://esm.sh/react@18.2.0\";\n\ninterface Props {\n  value: string;\n  onChange: (dataUrl: string) => void;\n  label?: string;\n  width?: number;\n  height?: number;\n}\n\nexport function SignaturePad({ value, onChange, label = \"Signature\", width = 400, height = 150 }: Props) {\n  const canvasRef = useRef<HTMLCanvasElement>(null);\n  const [isDrawing, setIsDrawing] = useState(false);\n\n  useEffect(() => {\n    const canvas = canvasRef.current;\n    if (!canvas) return;\n    const ctx = canvas.getContext(\"2d\");\n    if (!ctx) return;\n\n    if (value) {\n      const img = new Image();\n      img.onload = () => {\n        ctx.clearRect(0, 0, canvas.width, canvas.height);\n        ctx.drawImage(img, 0, 0);\n      };\n      img.src = value;\n    } else {\n      ctx.clearRect(0, 0, canvas.width, canvas.height);\n    }\n  }, []);\n\n  const getPos = useCallback((e: React.TouchEvent | React.MouseEvent) => {\n    const canvas = canvasRef.current!;\n    const rect = canvas.getBoundingClientRect();\n    const scaleX = canvas.width / rect.width;\n    const scaleY = canvas.height / rect.height;\n    if (\"touches\" in e) {\n      return {\n        x: (e.touches[0].clientX - rect.left) * scaleX,\n        y: (e.touches[0].clientY - rect.top) * scaleY\n      };\n    }\n    return {\n      x: ((e as React.MouseEvent).clientX - rect.left) * scaleX,\n      y: ((e as React.MouseEvent).clientY - rect.top) * scaleY\n    };\n  }, []);\n\n  const startDraw = useCallback((e: any) => {\n    e.preventDefault();\n    const canvas = canvasRef.current;\n    if (!canvas) return;\n    const ctx = canvas.getContext(\"2d\")!;\n    const pos = getPos(e);\n    ctx.beginPath();\n    ctx.moveTo(pos.x, pos.y);\n    ctx.strokeStyle = \"#1a1a2e\";\n    ctx.lineWidth = 2;\n    ctx.lineCap = \"round\";\n    setIsDrawing(true);\n  }, [getPos]);\n\n  const draw = useCallback((e: any) => {\n    if (!isDrawing) return;\n    e.preventDefault();\n    const canvas = canvasRef.current;\n    if (!canvas) return;\n    const ctx = canvas.getContext(\"2d\")!;\n    const pos = getPos(e);\n    ctx.lineTo(pos.x, pos.y);\n    ctx.stroke();\n  }, [isDrawing, getPos]);\n\n  const endDraw = useCallback(() => {\n    setIsDrawing(false);\n    const canvas = canvasRef.current;\n    if (canvas) onChange(canvas.toDataURL());\n  }, [onChange]);\n\n  const clear = () => {\n    const canvas = canvasRef.current;\n    if (!canvas) return;\n    const ctx = canvas.getContext(\"2d\")!;\n    ctx.clearRect(0, 0, canvas.width, canvas.height);\n    onChange(\"\");\n  };\n\n  return (\n    <div className=\"sig-pad\">\n      <label className=\"form-label\">{label}</label>\n      <canvas\n        ref={canvasRef}\n        width={width}\n        height={height}\n        onMouseDown={startDraw}\n        onMouseMove={draw}\n        onMouseUp={endDraw}\n        onMouseLeave={endDraw}\n        onTouchStart={startDraw}\n        onTouchMove={draw}\n        onTouchEnd={endDraw}\n        style={{\n          border: \"2px dashed #cbd5e1\",\n          borderRadius: \"8px\",\n          width: \"100%\",\n          maxWidth: width,\n          height: \"auto\",\n          aspectRatio: `${width}/${height}`,\n          cursor: \"crosshair\",\n          touchAction: \"none\",\n          background: \"#fafbfc\"\n        }}\n      />\n      <button type=\"button\" onClick={clear} className=\"btn btn-sm btn-outline\" style={{ marginTop: 4 }}>\n        Clear {label}\n      </button>\n    </div>\n  );\n}\n",[],[18,67,279],"9c832838-5357-11f1-a3a3-ee650bb23af1","Ledger.tsx","9c832928-5357-11f1-a3a3-ee650bb23af1",10,["D",1779177117820],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { LedgerEntry, Transaction } from \"../../shared/types.ts\";\n\nfunction fmt(n: number) {\n  const abs = Math.abs(n);\n  const [i, d] = abs.toFixed(2).split(\".\");\n  const digs = i.split(\"\").reverse();\n  let f = \"\";\n  for (let j = 0; j < digs.length; j++) {\n    if (j === 3 || (j > 3 && (j - 3) % 2 === 0)) f = \",\" + f;\n    f = digs[j] + f;\n  }\n  return (n < 0 ? \"-\" : \"\") + \"₹\" + f + \".\" + d;\n}\n\ninterface Props {\n  onViewTransaction: (id: number) => void;\n}\n\nexport function Ledger({ onViewTransaction }: Props) {\n  const [ledger, setLedger] = useState<LedgerEntry[]>([]);\n  const [detail, setDetail] = useState<{ name: string; transactions: any[] } | null>(null);\n  const [loading, setLoading] = useState(true);\n\n  useEffect(() => {\n    fetch(\"/api/ledger\").then(r => r.json()).then(d => { setLedger(d); setLoading(false); });\n  }, []);\n\n  const viewPerson = async (name: string) => {\n    const res = await fetch(`/api/ledger/${encodeURIComponent(name)}`);\n    const txs = await res.json();\n    setDetail({ name, transactions: txs });\n  };\n\n  if (detail) {\n    const isOverdue = (t: any) =>\n      t.status === \"active\" && t.settlementDeadline && new Date(t.settlementDeadline) < new Date();\n\n    return (\n      <div className=\"ledger-page\">\n        <div className=\"page-header\">\n          <h1>📒 {detail.name}'s Ledger</h1>\n          <button className=\"btn btn-outline\" onClick={() => setDetail(null)}>← Back to Ledger</button>\n        </div>\n        <div className=\"table-wrap\">\n          <table className=\"data-table\">\n            <thead>\n              <tr>\n                <th>Voucher</th>\n                <th>Date</th>\n                <th>Type</th>\n                <th>Amount</th>\n                <th>Purpose</th>\n                <th>Status</th>\n                <th>Deadline</th>\n                <th></th>\n              </tr>\n            </thead>\n            <tbody>\n              {detail.transactions.map((t: any) => (\n                <tr key={t.id} className={isOverdue(t) ? \"row-overdue\" : \"\"}>\n                  <td className=\"mono\">{t.voucherNumber}</td>\n                  <td>{t.date}</td>\n                  <td>\n                    <span className={`badge ${t.type === \"cash_in\" ? \"badge-green\" : \"badge-red\"}`}>\n                      {t.type === \"cash_in\" ? \"↓ In\" : \"↑ Out\"}\n                    </span>\n                  </td>\n                  <td className={t.type === \"cash_in\" ? \"text-green\" : \"text-red\"}>{fmt(t.amount)}</td>\n                  <td>{t.purpose}</td>\n                  <td>\n                    <span className={`badge badge-${t.status === \"draft\" ? \"yellow\" : t.status === \"settled\" ? \"blue\" : \"green\"}`}>\n                      {t.status === \"draft\" ? \"📝 \" : \"\"}{t.status}\n                    </span>\n                  </td>\n                  <td className={isOverdue(t) ? \"text-overdue\" : \"\"}>\n                    {t.settlementDeadline || \"—\"}\n                    {isOverdue(t) && <span className=\"overdue-badge\">OVERDUE</span>}\n                  </td>\n                  <td><button className=\"btn-icon\" onClick={() => onViewTransaction(t.id)}>👁️</button></td>\n                </tr>\n              ))}\n            </tbody>\n          </table>\n        </div>\n      </div>\n    );\n  }\n\n  return (\n    <div className=\"ledger-page\">\n      <div className=\"page-header\">\n        <h1>📒 Person Ledger</h1>\n      </div>\n\n      {loading ? <div className=\"loading\">Loading...</div> : (\n        <div className=\"table-wrap\">\n          <table className=\"data-table\">\n            <thead>\n              <tr>\n                <th>Person</th>\n                <th>Total In</th>\n                <th>Total Out</th>\n                <th>Balance</th>\n                <th>Pending</th>\n                <th>Last Txn</th>\n                <th></th>\n              </tr>\n            </thead>\n            <tbody>\n              {ledger.map((l, i) => (\n                <tr key={i}>\n                  <td><strong>{l.personName}</strong></td>\n                  <td className=\"text-green\">{fmt(l.totalIn)}</td>\n                  <td className=\"text-red\">{fmt(l.totalOut)}</td>\n                  <td className={l.balance >= 0 ? \"text-green\" : \"text-red\"}>\n                    <strong>{fmt(l.balance)}</strong>\n                  </td>\n                  <td>\n                    {l.pendingCount > 0 ? (\n                      <span className=\"badge badge-yellow\">{l.pendingCount} pending</span>\n                    ) : (\n                      <span className=\"badge badge-gray\">None</span>\n                    )}\n                  </td>\n                  <td>{l.lastTransaction}</td>\n                  <td>\n                    <button className=\"btn btn-outline btn-sm\" onClick={() => viewPerson(l.personName)}>\n                      View Details →\n                    </button>\n                  </td>\n                </tr>\n              ))}\n            </tbody>\n          </table>\n        </div>\n      )}\n    </div>\n  );\n}\n",[],[18,67,286],"a87523d0-5357-11f1-aab8-ee650bb23af1","DataManager.tsx","a875247a-5357-11f1-aab8-ee650bb23af1",11,["D",1779177137862],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef } from \"https://esm.sh/react@18.2.0\";\n\nexport function DataManager() {\n  const [status, setStatus] = useState(\"\");\n  const [loading, setLoading] = useState(false);\n  const fileRef = useRef<HTMLInputElement>(null);\n\n  const handleExport = async () => {\n    setLoading(true);\n    setStatus(\"Exporting...\");\n    try {\n      const res = await fetch(\"/api/export\");\n      const data = await res.json();\n      const blob = new Blob([JSON.stringify(data, null, 2)], { type: \"application/json\" });\n      const url = URL.createObjectURL(blob);\n      const a = document.createElement(\"a\");\n      a.href = url;\n      a.download = `cash-memo-backup-${new Date().toISOString().split(\"T\")[0]}.json`;\n      a.click();\n      URL.revokeObjectURL(url);\n      setStatus(`✅ Exported ${data.transactions.length} transactions and ${data.persons.length} persons`);\n    } catch (e) {\n      setStatus(\"❌ Export failed: \" + (e as Error).message);\n    }\n    setLoading(false);\n  };\n\n  const handleImport = async (e: React.ChangeEvent<HTMLInputElement>) => {\n    const file = e.target.files?.[0];\n    if (!file) return;\n\n    setLoading(true);\n    setStatus(\"Importing...\");\n    try {\n      const text = await file.text();\n      const data = JSON.parse(text);\n\n      if (!data.version || !data.transactions) {\n        setStatus(\"❌ Invalid backup file format\");\n        setLoading(false);\n        return;\n      }\n\n      if (!confirm(`This will replace ALL current data with ${data.transactions.length} transactions and ${(data.persons || []).length} persons from backup. Are you sure?`)) {\n        setStatus(\"Import cancelled\");\n        setLoading(false);\n        return;\n      }\n\n      const res = await fetch(\"/api/import\", {\n        method: \"POST\",\n        headers: { \"Content-Type\": \"application/json\" },\n        body: JSON.stringify(data)\n      });\n\n      const result = await res.json();\n      if (result.success) {\n        setStatus(`✅ Successfully imported ${result.imported} transactions. Refresh the page to see changes.`);\n      } else {\n        setStatus(\"❌ Import failed: \" + (result.error || \"Unknown error\"));\n      }\n    } catch (err) {\n      setStatus(\"❌ Import failed: \" + (err as Error).message);\n    }\n    setLoading(false);\n    if (fileRef.current) fileRef.current.value = \"\";\n  };\n\n  const handleExportCSV = async () => {\n    setLoading(true);\n    setStatus(\"Exporting CSV...\");\n    try {\n      const res = await fetch(\"/api/transactions\");\n      const txs = await res.json();\n\n      const headers = [\"Voucher\", \"Type\", \"Status\", \"Date\", \"Time\", \"Person\", \"Father/Company\", \"Mobile\", \"Amount\", \"Amount In Words\", \"Payment Type\", \"Purpose\", \"Given By\", \"Received By\", \"Notes\", \"Settlement Deadline\", \"Category\"];\n      const rows = txs.map((t: any) => [\n        t.voucherNumber, t.type, t.status, t.date, t.time, t.personName,\n        t.fatherOrCompany, t.mobile, t.amount, t.amountInWords,\n        t.paymentType, t.purpose, t.givenBy, t.receivedBy, t.notes,\n        t.settlementDeadline, t.category\n      ].map((v: any) => `\"${String(v || \"\").replace(/\"/g, '\"\"')}\"`).join(\",\"));\n\n      const csv = [headers.join(\",\"), ...rows].join(\"\\n\");\n      const blob = new Blob([csv], { type: \"text/csv\" });\n      const url = URL.createObjectURL(blob);\n      const a = document.createElement(\"a\");\n      a.href = url;\n      a.download = `cash-memo-export-${new Date().toISOString().split(\"T\")[0]}.csv`;\n      a.click();\n      URL.revokeObjectURL(url);\n      setStatus(`✅ Exported ${txs.length} transactions as CSV`);\n    } catch (e) {\n      setStatus(\"❌ CSV export failed\");\n    }\n    setLoading(false);\n  };\n\n  return (\n    <div className=\"data-manager-page\">\n      <div className=\"page-header\">\n        <h1>💾 Data Import / Export</h1>\n      </div>\n\n      <div className=\"data-cards\">\n        <div className=\"data-card\">\n          <h3>📤 Export Data</h3>\n          <p>Download a full backup of all your transactions and person records as JSON. This file can be re-imported later.</p>\n          <button className=\"btn btn-primary\" onClick={handleExport} disabled={loading}>\n            📥 Download JSON Backup\n          </button>\n        </div>\n\n        <div className=\"data-card\">\n          <h3>📊 Export CSV</h3>\n          <p>Download transactions as a CSV file that can be opened in Excel, Google Sheets, or any spreadsheet app.</p>\n          <button className=\"btn btn-success\" onClick={handleExportCSV} disabled={loading}>\n            📊 Download CSV\n          </button>\n        </div>\n\n        <div className=\"data-card\">\n          <h3>📥 Import Data</h3>\n          <p>Restore from a JSON backup file. <strong>Warning:</strong> This will replace all current data.</p>\n          <input\n            type=\"file\"\n            accept=\".json\"\n            onChange={handleImport}\n            ref={fileRef}\n            className=\"form-input\"\n            disabled={loading}\n          />\n        </div>\n      </div>\n\n      {status && (\n        <div className={`status-message ${status.startsWith(\"✅\") ? \"status-success\" : status.startsWith(\"❌\") ? \"status-error\" : \"status-info\"}`}>\n          {status}\n        </div>\n      )}\n    </div>\n  );\n}\n",[],[18,67,294],"4e03cf0a-5357-11f1-9605-ee650bb23af1","Dashboard.tsx","4e03cfd2-5357-11f1-9605-ee650bb23af1",6,["D",1779176986120],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { DashboardStats, Transaction } from \"../../shared/types.ts\";\n\nfunction formatCurrency(n: number) {\n  const abs = Math.abs(n);\n  const [intPart, dec] = abs.toFixed(2).split(\".\");\n  const digits = intPart.split(\"\").reverse();\n  let f = \"\";\n  for (let i = 0; i < digits.length; i++) {\n    if (i === 3 || (i > 3 && (i - 3) % 2 === 0)) f = \",\" + f;\n    f = digits[i] + f;\n  }\n  return (n < 0 ? \"-\" : \"\") + \"₹\" + f + \".\" + dec;\n}\n\ninterface Props {\n  onNavigate: (page: string) => void;\n}\n\nexport function Dashboard({ onNavigate }: Props) {\n  const [stats, setStats] = useState<DashboardStats | null>(null);\n  const [recent, setRecent] = useState<Transaction[]>([]);\n  const [loading, setLoading] = useState(true);\n\n  useEffect(() => {\n    Promise.all([\n      fetch(\"/api/stats\").then(r => r.json()),\n      fetch(\"/api/transactions\").then(r => r.json())\n    ]).then(([s, t]) => {\n      setStats(s);\n      setRecent(t.slice(0, 8));\n      setLoading(false);\n    });\n  }, []);\n\n  if (loading || !stats) return <div className=\"loading\">Loading dashboard...</div>;\n\n  const isOverdue = (t: Transaction) =>\n    t.status === \"active\" && t.settlementDeadline && new Date(t.settlementDeadline) < new Date();\n\n  return (\n    <div className=\"dashboard\">\n      <div className=\"page-header\">\n        <h1>📊 Dashboard</h1>\n        <div className=\"header-actions\">\n          <button className=\"btn btn-success\" onClick={() => onNavigate(\"new-cash-in\")}>+ Cash In</button>\n          <button className=\"btn btn-danger\" onClick={() => onNavigate(\"new-cash-out\")}>+ Cash Out</button>\n        </div>\n      </div>\n\n      <div className=\"stats-grid\">\n        <div className=\"stat-card stat-green\">\n          <div className=\"stat-icon\">💰</div>\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Total Cash In</span>\n            <span className=\"stat-value\">{formatCurrency(stats.totalCashIn)}</span>\n          </div>\n        </div>\n        <div className=\"stat-card stat-red\">\n          <div className=\"stat-icon\">💸</div>\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Total Cash Out</span>\n            <span className=\"stat-value\">{formatCurrency(stats.totalCashOut)}</span>\n          </div>\n        </div>\n        <div className={`stat-card ${stats.netBalance >= 0 ? \"stat-blue\" : \"stat-orange\"}`}>\n          <div className=\"stat-icon\">📈</div>\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Net Balance</span>\n            <span className=\"stat-value\">{formatCurrency(stats.netBalance)}</span>\n          </div>\n        </div>\n        <div className={`stat-card ${stats.overdueCount > 0 ? \"stat-overdue\" : \"stat-gray\"}`}>\n          <div className=\"stat-icon\">⚠️</div>\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Overdue</span>\n            <span className=\"stat-value\">{stats.overdueCount}</span>\n          </div>\n        </div>\n      </div>\n\n      <div className=\"stats-grid stats-grid-small\">\n        <div className=\"stat-card stat-green-light\">\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Today In</span>\n            <span className=\"stat-value-sm\">{formatCurrency(stats.todayIn)}</span>\n          </div>\n        </div>\n        <div className=\"stat-card stat-red-light\">\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Today Out</span>\n            <span className=\"stat-value-sm\">{formatCurrency(stats.todayOut)}</span>\n          </div>\n        </div>\n        <div className=\"stat-card stat-green-light\">\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Month In</span>\n            <span className=\"stat-value-sm\">{formatCurrency(stats.monthIn)}</span>\n          </div>\n        </div>\n        <div className=\"stat-card stat-red-light\">\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Month Out</span>\n            <span className=\"stat-value-sm\">{formatCurrency(stats.monthOut)}</span>\n          </div>\n        </div>\n        <div className=\"stat-card stat-yellow\">\n          <div className=\"stat-info\">\n            <span className=\"stat-label\">Pending Settlements</span>\n            <span className=\"stat-value-sm\">{stats.pendingSettlements}</span>\n          </div>\n        </div>\n      </div>\n\n      <div className=\"section\">\n        <div className=\"section-header\">\n          <h2>Recent Transactions</h2>\n          <button className=\"btn btn-outline btn-sm\" onClick={() => onNavigate(\"transactions\")}>View All →</button>\n        </div>\n        <div className=\"table-wrap\">\n          <table className=\"data-table\">\n            <thead>\n              <tr>\n                <th>Voucher</th>\n                <th>Date</th>\n                <th>Person</th>\n                <th>Type</th>\n                <th>Amount</th>\n                <th>Status</th>\n                <th>Deadline</th>\n              </tr>\n            </thead>\n            <tbody>\n              {recent.map((t: any) => (\n                <tr key={t.id} className={isOverdue(t) ? \"row-overdue\" : \"\"}>\n                  <td className=\"mono\">{t.voucherNumber}</td>\n                  <td>{t.date}</td>\n                  <td>{t.personName}</td>\n                  <td>\n                    <span className={`badge ${t.type === \"cash_in\" ? \"badge-green\" : \"badge-red\"}`}>\n                      {t.type === \"cash_in\" ? \"↓ In\" : \"↑ Out\"}\n                    </span>\n                  </td>\n                  <td className={t.type === \"cash_in\" ? \"text-green\" : \"text-red\"}>\n                    {formatCurrency(t.amount)}\n                  </td>\n                  <td>\n                    <span className={`badge badge-${t.status === \"draft\" ? \"yellow\" : t.status === \"settled\" ? \"blue\" : t.status === \"active\" ? \"green\" : \"gray\"}`}>\n                      {t.status}\n                    </span>\n                  </td>\n                  <td className={isOverdue(t) ? \"text-overdue\" : \"\"}>\n                    {t.settlementDeadline ? (\n                      <>\n                        {t.settlementDeadline}\n                        {isOverdue(t) && <span className=\"overdue-badge\">OVERDUE</span>}\n                      </>\n                    ) : \"—\"}\n                  </td>\n                </tr>\n              ))}\n            </tbody>\n          </table>\n        </div>\n      </div>\n    </div>\n  );\n}\n",[],[18,67,302],["D",1779176963357],[206,207,208,209,210,211,212],[18,67],["D",1779176963357],[205,213,214],[18],"1f076d60-5357-11f1-8ab1-ee650bb23af1","db.ts","1f076e1e-5357-11f1-8ab1-ee650bb23af1","4ffe1f4b-2aaf-472d-9bc5-2c7444df8202",3,["D",1779176907293],"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 persons (\n        id INTEGER PRIMARY KEY AUTOINCREMENT,\n        name TEXT NOT NULL,\n        fatherOrCompany TEXT DEFAULT '',\n        mobile TEXT DEFAULT '',\n        altMobile TEXT DEFAULT '',\n        address TEXT DEFAULT '',\n        idProofType TEXT DEFAULT '',\n        idProofNumber TEXT DEFAULT '',\n        createdAt TEXT DEFAULT (datetime('now')),\n        UNIQUE(name, mobile)\n      )`\n    },\n    {\n      sql: `CREATE TABLE IF NOT EXISTS transactions (\n        id INTEGER PRIMARY KEY AUTOINCREMENT,\n        voucherNumber TEXT UNIQUE NOT NULL,\n        type TEXT NOT NULL CHECK(type IN ('cash_in','cash_out')),\n        status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('draft','active','settled','cancelled')),\n        date TEXT NOT NULL,\n        time TEXT NOT NULL,\n        personName TEXT NOT NULL,\n        fatherOrCompany TEXT DEFAULT '',\n        mobile TEXT DEFAULT '',\n        altMobile TEXT DEFAULT '',\n        address TEXT DEFAULT '',\n        idProofType TEXT DEFAULT '',\n        idProofNumber TEXT DEFAULT '',\n        amount REAL NOT NULL,\n        amountInWords TEXT DEFAULT '',\n        paymentType TEXT DEFAULT 'cash',\n        purpose TEXT DEFAULT '',\n        givenBy TEXT DEFAULT '',\n        receivedBy TEXT DEFAULT '',\n        notes TEXT DEFAULT '',\n        terms TEXT DEFAULT '',\n        settlementDeadline TEXT DEFAULT '',\n        customMessage TEXT DEFAULT '',\n        itemDescription TEXT DEFAULT '',\n        referenceNumber TEXT DEFAULT '',\n        approvalDetails TEXT DEFAULT '',\n        witnessName TEXT DEFAULT '',\n        witnessSignature TEXT DEFAULT '',\n        signature TEXT DEFAULT '',\n        category TEXT DEFAULT 'general',\n        createdAt TEXT DEFAULT (datetime('now')),\n        updatedAt TEXT DEFAULT (datetime('now'))\n      )`\n    }\n  ]);\n}\n\nexport async function seedData() {\n  // Check if data already exists\n  const existing = await sqlite.execute(\"SELECT COUNT(*) as cnt FROM transactions\");\n  if ((existing.rows[0] as any).cnt > 0) return;\n\n  const now = new Date();\n  const today = now.toISOString().split(\"T\")[0];\n  const yesterday = new Date(now.getTime() - 86400000).toISOString().split(\"T\")[0];\n  const lastWeek = new Date(now.getTime() - 7 * 86400000).toISOString().split(\"T\")[0];\n  const twoWeeksAgo = new Date(now.getTime() - 14 * 86400000).toISOString().split(\"T\")[0];\n  const pastDeadline = new Date(now.getTime() - 3 * 86400000).toISOString().split(\"T\")[0];\n  const futureDeadline = new Date(now.getTime() + 7 * 86400000).toISOString().split(\"T\")[0];\n\n  // Seed persons\n  await sqlite.batch([\n    {\n      sql: `INSERT OR IGNORE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber)\n            VALUES (?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"Abdul Khan\", \"Khan Enterprises\", \"9876543210\", \"9876543211\", \"45 Market Road, Delhi\", \"Aadhaar\", \"1234-5678-9012\"]\n    },\n    {\n      sql: `INSERT OR IGNORE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber)\n            VALUES (?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"Priya Sharma\", \"Rajesh Sharma\", \"8765432109\", \"\", \"12 MG Road, Mumbai\", \"PAN\", \"ABCPS1234K\"]\n    },\n    {\n      sql: `INSERT OR IGNORE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber)\n            VALUES (?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"Vikram Singh\", \"Singh & Sons Trading\", \"7654321098\", \"7654321099\", \"78 Civil Lines, Jaipur\", \"Voter ID\", \"XYZ1234567\"]\n    },\n    {\n      sql: `INSERT OR IGNORE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber)\n            VALUES (?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"Meena Devi\", \"Suresh Kumar\", \"6543210987\", \"\", \"23 Station Road, Lucknow\", \"Aadhaar\", \"9876-5432-1098\"]\n    },\n    {\n      sql: `INSERT OR IGNORE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber)\n            VALUES (?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"Rajan Patel\", \"Patel Brothers\", \"9988776655\", \"9988776656\", \"56 Ring Road, Ahmedabad\", \"PAN\", \"DEFPP5678L\"]\n    }\n  ]);\n\n  // Seed transactions - mix of types, statuses, overdue, etc.\n  await sqlite.batch([\n    // Active cash out - OVERDUE (past deadline, not settled)\n    {\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, terms, settlementDeadline, category)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"CO-260505-1001\", \"cash_out\", \"active\", twoWeeksAgo, \"10:30\", \"Abdul Khan\", \"Khan Enterprises\", \"9876543210\", \"9876543211\", \"45 Market Road, Delhi\", \"Aadhaar\", \"1234-5678-9012\", 25000, \"Twenty Five Thousand Rupees Only\", \"cash\", \"Office renovation materials\", \"Myself\", \"Abdul Khan\", \"For purchasing tiles and paint\", \"Amount to be settled within 7 days\", pastDeadline, \"office\"]\n    },\n    // Active cash in\n    {\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, address, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, settlementDeadline, category)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"CI-260510-2001\", \"cash_in\", \"active\", lastWeek, \"14:00\", \"Priya Sharma\", \"Rajesh Sharma\", \"8765432109\", \"12 MG Road, Mumbai\", 50000, \"Fifty Thousand Rupees Only\", \"upi\", \"Rent payment for May 2026\", \"Priya Sharma\", \"Myself\", \"Monthly rent received\", futureDeadline, \"rent\"]\n    },\n    // Settled transaction\n    {\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, address, idProofType, idProofNumber, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, category)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"CO-260501-3001\", \"cash_out\", \"settled\", twoWeeksAgo, \"09:00\", \"Vikram Singh\", \"Singh & Sons Trading\", \"7654321098\", \"78 Civil Lines, Jaipur\", \"Voter ID\", \"XYZ1234567\", 15000, \"Fifteen Thousand Rupees Only\", \"cash\", \"Purchase of stationery supplies\", \"Myself\", \"Vikram Singh\", \"Bulk order for office\", \"supplies\"]\n    },\n    // Draft transaction\n    {\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, address, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, terms, settlementDeadline, category)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"CO-260519-4001\", \"cash_out\", \"draft\", today, \"11:00\", \"Meena Devi\", \"Suresh Kumar\", \"6543210987\", \"23 Station Road, Lucknow\", 8500, \"Eight Thousand Five Hundred Rupees Only\", \"cash\", \"Advance for catering services\", \"Myself\", \"Meena Devi\", \"Draft - pending approval\", \"Settlement after event completion\", futureDeadline, \"services\"]\n    },\n    // Another cash in - today\n    {\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, category)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"CI-260519-5001\", \"cash_in\", \"active\", today, \"09:30\", \"Rajan Patel\", \"Patel Brothers\", \"9988776655\", \"9988776656\", \"56 Ring Road, Ahmedabad\", \"PAN\", \"DEFPP5678L\", 125000, \"One Lakh Twenty Five Thousand Rupees Only\", \"bank_transfer\", \"Payment for goods delivered\", \"Rajan Patel\", \"Myself\", \"Invoice #INV-2026-0456\", \"sales\"]\n    },\n    // Cash out - pending, with future deadline\n    {\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, address, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, settlementDeadline, category)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"CO-260518-6001\", \"cash_out\", \"active\", yesterday, \"16:00\", \"Priya Sharma\", \"Rajesh Sharma\", \"8765432109\", \"12 MG Road, Mumbai\", 12000, \"Twelve Thousand Rupees Only\", \"cheque\", \"Security deposit refund\", \"Myself\", \"Priya Sharma\", \"Cheque #456789\", futureDeadline, \"deposits\"]\n    },\n    // Another overdue\n    {\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, address, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, settlementDeadline, category)\n            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n      args: [\"CO-260505-7001\", \"cash_out\", \"active\", twoWeeksAgo, \"13:00\", \"Vikram Singh\", \"Singh & Sons Trading\", \"7654321098\", \"78 Civil Lines, Jaipur\", 35000, \"Thirty Five Thousand Rupees Only\", \"cash\", \"Advance for marble supply\", \"Myself\", \"Vikram Singh\", \"Pending delivery\", pastDeadline, \"materials\"]\n    }\n  ]);\n}\n\nexport { sqlite };\n",[],[324,316],"backend","377662d4-5357-11f1-a1cf-ee650bb23af1","api.ts","37766388-5357-11f1-a1cf-ee650bb23af1",4,["D",1779176947540],"import { Hono } from \"npm:hono@4\";\nimport { sqlite, initDB, seedData } from \"./db.ts\";\nimport type { Transaction, DashboardStats, LedgerEntry, ExportData } from \"../shared/types.ts\";\n\nconst api = new Hono();\n\n// Initialize DB and seed on first request\nlet initialized = false;\napi.use(\"*\", async (c, next) => {\n  if (!initialized) {\n    await initDB();\n    await seedData();\n    initialized = true;\n  }\n  await next();\n});\n\n// Dashboard stats\napi.get(\"/stats\", async (c) => {\n  const today = new Date().toISOString().split(\"T\")[0];\n  const monthStart = today.slice(0, 7) + \"-01\";\n\n  const results = await sqlite.batch([\n    { sql: \"SELECT COALESCE(SUM(amount),0) as total FROM transactions WHERE type='cash_in' AND status IN ('active','settled')\" },\n    { sql: \"SELECT COALESCE(SUM(amount),0) as total FROM transactions WHERE type='cash_out' AND status IN ('active','settled')\" },\n    { sql: \"SELECT COUNT(*) as cnt FROM transactions WHERE status='active' AND settlementDeadline != '' AND settlementDeadline < ?\", args: [today] },\n    { sql: \"SELECT COALESCE(SUM(amount),0) as total FROM transactions WHERE type='cash_in' AND status IN ('active','settled') AND date = ?\", args: [today] },\n    { sql: \"SELECT COALESCE(SUM(amount),0) as total FROM transactions WHERE type='cash_out' AND status IN ('active','settled') AND date = ?\", args: [today] },\n    { sql: \"SELECT COALESCE(SUM(amount),0) as total FROM transactions WHERE type='cash_in' AND status IN ('active','settled') AND date >= ?\", args: [monthStart] },\n    { sql: \"SELECT COALESCE(SUM(amount),0) as total FROM transactions WHERE type='cash_out' AND status IN ('active','settled') AND date >= ?\", args: [monthStart] },\n    { sql: \"SELECT COUNT(*) as cnt FROM transactions WHERE status='active' AND settlementDeadline != ''\" },\n  ]);\n\n  const totalIn = (results[0].rows[0] as any).total;\n  const totalOut = (results[1].rows[0] as any).total;\n\n  const stats: DashboardStats = {\n    totalCashIn: totalIn,\n    totalCashOut: totalOut,\n    netBalance: totalIn - totalOut,\n    overdueCount: (results[2].rows[0] as any).cnt,\n    todayIn: (results[3].rows[0] as any).total,\n    todayOut: (results[4].rows[0] as any).total,\n    monthIn: (results[5].rows[0] as any).total,\n    monthOut: (results[6].rows[0] as any).total,\n    pendingSettlements: (results[7].rows[0] as any).cnt,\n  };\n\n  return c.json(stats);\n});\n\n// List transactions with filters\napi.get(\"/transactions\", async (c) => {\n  const { type, status, search, dateFrom, dateTo, person, category } = c.req.query();\n  let sql = \"SELECT * FROM transactions WHERE 1=1\";\n  const args: any[] = [];\n\n  if (type) { sql += \" AND type = ?\"; args.push(type); }\n  if (status) { sql += \" AND status = ?\"; args.push(status); }\n  if (dateFrom) { sql += \" AND date >= ?\"; args.push(dateFrom); }\n  if (dateTo) { sql += \" AND date <= ?\"; args.push(dateTo); }\n  if (person) { sql += \" AND personName LIKE ?\"; args.push(`%${person}%`); }\n  if (category) { sql += \" AND category = ?\"; args.push(category); }\n  if (search) {\n    sql += \" AND (personName LIKE ? OR voucherNumber LIKE ? OR purpose LIKE ? OR CAST(amount AS TEXT) LIKE ?)\";\n    const s = `%${search}%`;\n    args.push(s, s, s, s);\n  }\n\n  sql += \" ORDER BY date DESC, time DESC\";\n  const result = await sqlite.execute({ sql, args });\n  return c.json(result.rows);\n});\n\n// Get single transaction\napi.get(\"/transactions/:id\", async (c) => {\n  const id = c.req.param(\"id\");\n  const result = await sqlite.execute({ sql: \"SELECT * FROM transactions WHERE id = ?\", args: [id] });\n  if (result.rows.length === 0) return c.json({ error: \"Not found\" }, 404);\n  return c.json(result.rows[0]);\n});\n\n// Create transaction\napi.post(\"/transactions\", async (c) => {\n  const body = await c.req.json();\n  const sql = `INSERT INTO transactions (\n    voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, altMobile,\n    address, idProofType, idProofNumber, amount, amountInWords, paymentType, purpose,\n    givenBy, receivedBy, notes, terms, settlementDeadline, customMessage, itemDescription,\n    referenceNumber, approvalDetails, witnessName, witnessSignature, signature, category\n  ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`;\n\n  const args = [\n    body.voucherNumber, body.type, body.status || \"active\", body.date, body.time,\n    body.personName, body.fatherOrCompany || \"\", body.mobile || \"\", body.altMobile || \"\",\n    body.address || \"\", body.idProofType || \"\", body.idProofNumber || \"\",\n    body.amount, body.amountInWords || \"\", body.paymentType || \"cash\",\n    body.purpose || \"\", body.givenBy || \"\", body.receivedBy || \"\",\n    body.notes || \"\", body.terms || \"\", body.settlementDeadline || \"\",\n    body.customMessage || \"\", body.itemDescription || \"\", body.referenceNumber || \"\",\n    body.approvalDetails || \"\", body.witnessName || \"\", body.witnessSignature || \"\",\n    body.signature || \"\", body.category || \"general\"\n  ];\n\n  const result = await sqlite.execute({ sql, args });\n\n  // Upsert person\n  if (body.personName) {\n    await sqlite.execute({\n      sql: `INSERT OR REPLACE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber)\n            VALUES (?, ?, ?, ?, ?, ?, ?)`,\n      args: [body.personName, body.fatherOrCompany || \"\", body.mobile || \"\", body.altMobile || \"\", body.address || \"\", body.idProofType || \"\", body.idProofNumber || \"\"]\n    });\n  }\n\n  return c.json({ success: true, id: result.lastInsertRowid });\n});\n\n// Update transaction\napi.put(\"/transactions/:id\", async (c) => {\n  const id = c.req.param(\"id\");\n  const body = await c.req.json();\n\n  const fields = Object.keys(body).filter(k => k !== \"id\").map(k => `${k} = ?`).join(\", \");\n  const values = Object.keys(body).filter(k => k !== \"id\").map(k => body[k]);\n  values.push(id);\n\n  await sqlite.execute({ sql: `UPDATE transactions SET ${fields}, updatedAt = datetime('now') WHERE id = ?`, args: values });\n\n  // Update person record if person details changed\n  if (body.personName) {\n    await sqlite.execute({\n      sql: `INSERT OR REPLACE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber)\n            VALUES (?, ?, ?, ?, ?, ?, ?)`,\n      args: [body.personName, body.fatherOrCompany || \"\", body.mobile || \"\", body.altMobile || \"\", body.address || \"\", body.idProofType || \"\", body.idProofNumber || \"\"]\n    });\n  }\n\n  return c.json({ success: true });\n});\n\n// Delete transaction\napi.delete(\"/transactions/:id\", async (c) => {\n  const id = c.req.param(\"id\");\n  await sqlite.execute({ sql: \"DELETE FROM transactions WHERE id = ?\", args: [id] });\n  return c.json({ success: true });\n});\n\n// Persons autocomplete\napi.get(\"/persons\", async (c) => {\n  const q = c.req.query(\"q\") || \"\";\n  let result;\n  if (q) {\n    result = await sqlite.execute({\n      sql: \"SELECT * FROM persons WHERE name LIKE ? ORDER BY name LIMIT 20\",\n      args: [`%${q}%`]\n    });\n  } else {\n    result = await sqlite.execute(\"SELECT * FROM persons ORDER BY name LIMIT 50\");\n  }\n  return c.json(result.rows);\n});\n\n// Ledger - person-wise summary\napi.get(\"/ledger\", async (c) => {\n  const result = await sqlite.execute(`\n    SELECT\n      personName,\n      COALESCE(SUM(CASE WHEN type='cash_in' AND status IN ('active','settled') THEN amount ELSE 0 END), 0) as totalIn,\n      COALESCE(SUM(CASE WHEN type='cash_out' AND status IN ('active','settled') THEN amount ELSE 0 END), 0) as totalOut,\n      COUNT(CASE WHEN status='active' AND settlementDeadline != '' THEN 1 END) as pendingCount,\n      MAX(date) as lastTransaction\n    FROM transactions\n    WHERE status != 'cancelled'\n    GROUP BY personName\n    ORDER BY lastTransaction DESC\n  `);\n\n  const ledger: LedgerEntry[] = result.rows.map((r: any) => ({\n    personName: r.personName,\n    totalIn: r.totalIn,\n    totalOut: r.totalOut,\n    balance: r.totalIn - r.totalOut,\n    pendingCount: r.pendingCount,\n    lastTransaction: r.lastTransaction,\n  }));\n\n  return c.json(ledger);\n});\n\n// Person ledger detail\napi.get(\"/ledger/:name\", async (c) => {\n  const name = decodeURIComponent(c.req.param(\"name\"));\n  const result = await sqlite.execute({\n    sql: \"SELECT * FROM transactions WHERE personName = ? AND status != 'cancelled' ORDER BY date DESC, time DESC\",\n    args: [name]\n  });\n  return c.json(result.rows);\n});\n\n// Export all data\napi.get(\"/export\", async (c) => {\n  const [txResult, personResult] = await sqlite.batch([\n    { sql: \"SELECT * FROM transactions ORDER BY date DESC\" },\n    { sql: \"SELECT * FROM persons ORDER BY name\" }\n  ]);\n\n  const data: ExportData = {\n    version: \"1.0\",\n    exportDate: new Date().toISOString(),\n    transactions: txResult.rows as any,\n    persons: personResult.rows as any,\n  };\n\n  return c.json(data);\n});\n\n// Import data\napi.post(\"/import\", async (c) => {\n  const data: ExportData = await c.req.json();\n\n  if (!data.version || !data.transactions) {\n    return c.json({ error: \"Invalid import data\" }, 400);\n  }\n\n  // Clear existing and reimport\n  await sqlite.batch([\n    { sql: \"DELETE FROM transactions\" },\n    { sql: \"DELETE FROM persons\" }\n  ]);\n\n  for (const p of data.persons || []) {\n    await sqlite.execute({\n      sql: `INSERT OR IGNORE INTO persons (name, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber) VALUES (?,?,?,?,?,?,?)`,\n      args: [p.name, p.fatherOrCompany || \"\", p.mobile || \"\", p.altMobile || \"\", p.address || \"\", p.idProofType || \"\", p.idProofNumber || \"\"]\n    });\n  }\n\n  for (const t of data.transactions) {\n    await sqlite.execute({\n      sql: `INSERT INTO transactions (voucherNumber, type, status, date, time, personName, fatherOrCompany, mobile, altMobile, address, idProofType, idProofNumber, amount, amountInWords, paymentType, purpose, givenBy, receivedBy, notes, terms, settlementDeadline, customMessage, itemDescription, referenceNumber, approvalDetails, witnessName, witnessSignature, signature, category, createdAt, updatedAt)\n            VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n      args: [\n        t.voucherNumber, t.type, t.status, t.date, t.time, t.personName,\n        t.fatherOrCompany || \"\", t.mobile || \"\", t.altMobile || \"\", t.address || \"\",\n        t.idProofType || \"\", t.idProofNumber || \"\", t.amount, t.amountInWords || \"\",\n        t.paymentType || \"cash\", t.purpose || \"\", t.givenBy || \"\", t.receivedBy || \"\",\n        t.notes || \"\", t.terms || \"\", t.settlementDeadline || \"\", t.customMessage || \"\",\n        t.itemDescription || \"\", t.referenceNumber || \"\", t.approvalDetails || \"\",\n        t.witnessName || \"\", t.witnessSignature || \"\", t.signature || \"\",\n        t.category || \"general\", t.createdAt || new Date().toISOString(), t.updatedAt || new Date().toISOString()\n      ]\n    });\n  }\n\n  return c.json({ success: true, imported: data.transactions.length });\n});\n\n// Categories\napi.get(\"/categories\", async (c) => {\n  const result = await sqlite.execute(\"SELECT DISTINCT category FROM transactions WHERE category != '' ORDER BY category\");\n  return c.json(result.rows.map((r: any) => r.category));\n});\n\nexport default api;\n",[],[324,326],"1f07a258-5357-11f1-8ab1-ee650bb23af1",["D",1779176907293],[202,203],[324],["D",1779176842034],{"_11":12,"_144":73},{"_11":12,"_140":73,"_72":73,"_31":71,"_141":142,"_143":30},{"_41":131,"_13":16,"_35":38,"_132":96,"_133":-5,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":14,"_139":12},"ctx",{"_55":-5,"_163":374,"_375":376,"_377":378,"_379":30,"_380":30,"_381":30,"_382":24,"_383":-5,"_384":-7,"_385":-7,"_386":26,"_387":30,"_388":30,"_389":-5,"_390":30,"_391":30,"_392":30,"_393":-5},"ENV",{"_345":346,"_347":348,"_349":16,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373},"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"]
</article></body></html>

History · frontend