[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_304":305,"_306":307},"routes/_app.x.$handle.$name",{"_96":95,"_31":44,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":24,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/TransactionForm.tsx","latestPath","fileId","b1088f76-3f9b-11f0-bd80-76b3cceeab13","name","TransactionForm.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Transaction, TransactionCategory } from \"../../shared/types.ts\";\nimport { TRANSACTION_CATEGORIES } from \"../../shared/types.ts\";\n\ninterface TransactionFormProps {\n onTransactionCreated: (transaction: Transaction) => void;\n editTransaction?: Transaction;\n onCancel?: () => void;\n}\n\nexport default function TransactionForm({ \n onTransactionCreated, \n editTransaction, \n onCancel \n}: TransactionFormProps) {\n const [formData, setFormData] = useState({\n amount: editTransaction?.amount?.toString() || '',\n description: editTransaction?.description || '',\n category: editTransaction?.category || '',\n date: editTransaction?.date || new Date().toISOString().split('T')[0],\n type: editTransaction?.type || 'expense' as 'income' | 'expense'\n });\n \n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError(null);\n\n try {\n // Validate form\n if (!formData.amount || !formData.description || !formData.category || !formData.date) {\n setError('Please fill in all required fields');\n setLoading(false);\n return;\n }\n\n const amount = parseFloat(formData.amount);\n if (isNaN(amount) || amount <= 0) {\n setError('Please enter a valid positive amount');\n setLoading(false);\n return;\n }\n\n const transactionData = {\n amount,\n description: formData.description.trim(),\n category: formData.category,\n date: formData.date,\n type: formData.type\n };\n\n const url = editTransaction \n ? `/api/transactions/${editTransaction.id}`\n : '/api/transactions';\n \n const method = editTransaction ? 'PUT' : 'POST';\n\n const response = await fetch(url, {\n method,\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(transactionData),\n });\n\n const result = await response.json();\n\n if (result.success) {\n onTransactionCreated(result.data);\n \n // Reset form if creating new transaction\n if (!editTransaction) {\n setFormData({\n amount: '',\n description: '',\n category: '',\n date: new Date().toISOString().split('T')[0],\n type: 'expense'\n });\n }\n } else {\n setError(result.error || 'Failed to save transaction');\n }\n } catch (err) {\n setError('Network error. Please try again.');\n console.error('Error saving transaction:', err);\n } finally {\n setLoading(false);\n }\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value\n }));\n };\n\n return (\n

\n {editTransaction ? 'Edit Transaction' : 'Add New Transaction'}\n

\n {onCancel && (\n \n ✕\n \n )}\n

\n\n {error && (\n

{error}

\n )}\n\n

\n {/* Transaction Type */}\n

\n \n Transaction Type *\n \n

\n \n \n 💸 Expense\n \n \n \n 💰 Income\n \n

\n\n {/* Amount */}\n

\n \n Amount * ($)\n \n \n

\n\n {/* Description */}\n

\n \n Description *\n \n \n

\n\n {/* Category */}\n

\n \n Category *\n \n \n \n {TRANSACTION_CATEGORIES.map((category) => (\n \n ))}\n \n

\n\n {/* Date */}\n

\n \n Date *\n \n \n

\n\n {/* Submit Button */}\n

\n \n {loading ? (\n \n

\n {editTransaction ? 'Updating...' : 'Adding...'}\n \n ) : (\n editTransaction ? 'Update Transaction' : 'Add Transaction'\n )}\n \n \n {onCancel && (\n \n Cancel\n \n )}\n

\n );\n}","createdAt",["D",1748859837104],"branchVersion","branchId","ee965b9a-3f99-11f0-84ee-76b3cceeab13","id","ee95f830-3f99-11f0-84ee-76b3cceeab13","F_manager",["D",1748859081381],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Finance management","imageUrl","cf586bb0-3f99-11f0-b6e9-ab0b2f88b858","pinnedFileId","84a22974-3f9b-11f0-813c-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","cba1efe5-a7c5-4806-b46b-7b13848b27c5","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Dev_J","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d3BTOW15cjllRmJmVWdiSEZ1RThzZ2NrbSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":300,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":301,"_80":302,"_82":303,"_84":24},"tree",[176,184,190,192,193],"files",[176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193],"counts",{"_166":62,"_167":135,"_168":62,"_169":170,"_171":172},"contents",[126,127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":160,"_31":161,"_29":162,"_134":-5,"_40":41,"_39":163,"_136":58,"_37":164,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_26":165},{"_42":154,"_31":155,"_29":156,"_134":-5,"_40":41,"_39":157,"_136":58,"_37":158,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_26":159},{"_42":147,"_31":148,"_29":149,"_134":-5,"_40":41,"_39":150,"_136":58,"_37":151,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_26":153},{"_42":140,"_31":141,"_29":142,"_134":-5,"_40":41,"_39":143,"_136":58,"_37":144,"_13":62,"_33":20,"_35":145,"_23":24,"_138":-5,"_26":146},{"_42":131,"_31":132,"_29":133,"_134":-5,"_40":41,"_39":135,"_136":58,"_37":137,"_13":62,"_33":34,"_35":105,"_23":24,"_138":-5,"_26":139},"ee98207e-3f99-11f0-84ee-76b3cceeab13","main.tsx","ee98210a-3f99-11f0-84ee-76b3cceeab13","parentId",1,"latest",["D",1748859081392],"label",[132],"4b6881c6-3f9b-11f0-8361-76b3cceeab13","README.md","4b68825c-3f9b-11f0-8361-76b3cceeab13",2,["D",1748859666601],"# Finance Management System\n\nA comprehensive finance tracking application that helps you monitor transactions and analyze spending patterns.\n\n## Features\n\n- **Transaction Management**: Add, edit, and delete financial transactions\n- **Category Tracking**: Organize transactions by categories (Food, Transportation, Entertainment, etc.)\n- **Spending Analysis**: View daily and monthly spending summaries\n- **Visual Dashboard**: Charts and graphs to visualize spending patterns\n- **Search & Filter**: Find transactions by date, category, or amount\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── transactions.ts # Transaction CRUD operations\n│ │ └── analytics.ts # Spending analysis endpoints\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── TransactionForm.tsx\n│ │ ├── TransactionList.tsx\n│ │ └── Dashboard.tsx\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript interfaces\n```\n\n## API Endpoints\n\n- `GET /api/transactions` - Get all transactions\n- `POST /api/transactions` - Create new transaction\n- `PUT /api/transactions/:id` - Update transaction\n- `DELETE /api/transactions/:id` - Delete transaction\n- `GET /api/analytics/daily` - Get daily spending summary\n- `GET /api/analytics/monthly` - Get monthly spending summary\n\n## Getting Started\n\n1. The system automatically sets up the database on first run\n2. Navigate to the main page to start adding transactions\n3. Use the dashboard to view spending analytics\n\n## Technology Stack\n\n- **Backend**: Hono.js with SQLite database\n- **Frontend**: React with TypeScript\n- **Styling**: TailwindCSS\n- **Charts**: Chart.js for data visualization",[141],"4ffeb1d8-3f9b-11f0-b0ac-76b3cceeab13","shared","2884db5c-ed22-48f7-b2c6-847f65f2b104",3,["D",1748859674298],"directory",[148],"8b1eefb2-3f9b-11f0-91de-76b3cceeab13","frontend","2236583a-50e1-4fc9-aecf-6f8416a223ed",9,["D",1748859773493],[155],"54012428-3f9b-11f0-a781-76b3cceeab13","backend","e09e9a67-ed4f-40ea-b4a5-378a36065b70",4,["D",1748859681025],[161],"pulls","branches","forks","envVars",{"_173":62,"_175":62},"connections",{"_173":62,"_174":62},"count","unfilledCount","emptyCount",{"_42":160,"_31":161,"_29":162,"_134":-5,"_40":41,"_39":163,"_136":58,"_37":297,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_195":298,"_26":299},{"_42":293,"_31":285,"_29":279,"_134":162,"_40":41,"_39":163,"_136":58,"_37":294,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_195":295,"_26":296},{"_42":286,"_31":287,"_29":288,"_134":279,"_40":41,"_39":163,"_136":24,"_37":289,"_13":62,"_33":34,"_35":290,"_23":24,"_138":-5,"_195":291,"_26":292},{"_42":276,"_31":277,"_29":278,"_134":279,"_40":41,"_39":280,"_136":24,"_37":281,"_13":62,"_33":34,"_35":282,"_23":24,"_138":-5,"_195":283,"_26":284},{"_42":272,"_31":263,"_29":257,"_134":162,"_40":41,"_39":258,"_136":58,"_37":273,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_195":274,"_26":275},{"_42":264,"_31":265,"_29":266,"_134":257,"_40":41,"_39":267,"_136":58,"_37":268,"_13":62,"_33":34,"_35":269,"_23":24,"_138":-5,"_195":270,"_26":271},{"_42":254,"_31":255,"_29":256,"_134":257,"_40":41,"_39":258,"_136":58,"_37":259,"_13":62,"_33":34,"_35":260,"_23":24,"_138":-5,"_195":261,"_26":262},{"_42":247,"_31":248,"_29":56,"_134":162,"_40":41,"_39":249,"_136":24,"_37":250,"_13":62,"_33":34,"_35":251,"_23":24,"_138":-5,"_195":252,"_26":253},{"_42":154,"_31":155,"_29":156,"_134":-5,"_40":41,"_39":157,"_136":58,"_37":244,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_195":245,"_26":246},{"_42":240,"_31":231,"_29":227,"_134":156,"_40":41,"_39":235,"_136":58,"_37":241,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_195":242,"_26":243},{"_42":232,"_31":233,"_29":234,"_134":227,"_40":41,"_39":235,"_136":58,"_37":236,"_13":62,"_33":34,"_35":237,"_23":24,"_138":-5,"_195":238,"_26":239},{"_42":226,"_31":32,"_29":30,"_134":227,"_40":41,"_39":14,"_136":58,"_37":228,"_13":62,"_33":34,"_35":36,"_23":24,"_138":-5,"_195":229,"_26":230},{"_42":219,"_31":220,"_29":221,"_134":156,"_40":41,"_39":157,"_136":58,"_37":222,"_13":62,"_33":20,"_35":223,"_23":24,"_138":-5,"_195":224,"_26":225},{"_42":211,"_31":212,"_29":213,"_134":156,"_40":41,"_39":214,"_136":58,"_37":215,"_13":62,"_33":34,"_35":216,"_23":24,"_138":-5,"_195":217,"_26":218},{"_42":147,"_31":148,"_29":149,"_134":-5,"_40":41,"_39":150,"_136":58,"_37":208,"_13":62,"_33":152,"_35":-5,"_23":24,"_138":-5,"_195":209,"_26":210},{"_42":201,"_31":202,"_29":203,"_134":149,"_40":41,"_39":150,"_136":58,"_37":204,"_13":62,"_33":34,"_35":205,"_23":24,"_138":-5,"_195":206,"_26":207},{"_42":140,"_31":141,"_29":142,"_134":-5,"_40":41,"_39":143,"_136":58,"_37":198,"_13":62,"_33":20,"_35":145,"_23":24,"_138":-5,"_195":199,"_26":200},{"_42":131,"_31":132,"_29":133,"_134":-5,"_40":41,"_39":135,"_136":58,"_37":194,"_13":62,"_33":34,"_35":105,"_23":24,"_138":-5,"_195":196,"_26":197},["D",1748859081392],"children",[],[132],["D",1748859666601],[],[141],"4ffeaa26-3f9b-11f0-b0ac-76b3cceeab13","types.ts","4ffeab0c-3f9b-11f0-b0ac-76b3cceeab13",["D",1748859674298],"// Shared types for the finance management system\n\nexport interface Transaction {\n id?: number;\n amount: number;\n description: string;\n category: string;\n date: string; // ISO date string\n type: 'income' | 'expense';\n created_at?: string;\n updated_at?: string;\n}\n\nexport interface DailySpending {\n date: string;\n total_income: number;\n total_expenses: number;\n net_amount: number;\n transaction_count: number;\n}\n\nexport interface MonthlySpending {\n month: string; // YYYY-MM format\n total_income: number;\n total_expenses: number;\n net_amount: number;\n transaction_count: number;\n categories: CategorySpending[];\n}\n\nexport interface CategorySpending {\n category: string;\n total_amount: number;\n transaction_count: number;\n percentage: number;\n}\n\nexport interface SpendingAnalytics {\n daily: DailySpending[];\n monthly: MonthlySpending[];\n topCategories: CategorySpending[];\n recentTransactions: Transaction[];\n}\n\nexport const TRANSACTION_CATEGORIES = [\n 'Food & Dining',\n 'Transportation',\n 'Shopping',\n 'Entertainment',\n 'Bills & Utilities',\n 'Healthcare',\n 'Education',\n 'Travel',\n 'Income',\n 'Investment',\n 'Other'\n] as const;\n\nexport type TransactionCategory = typeof TRANSACTION_CATEGORIES[number];",[],[148,202],["D",1748859674298],[191],[148],"8dd3e03c-3f9b-11f0-ba65-76b3cceeab13","index.tsx","8dd3e104-3f9b-11f0-ba65-76b3cceeab13",10,["D",1748859778036],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"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 = createRoot(document.getElementById('root')!);\nroot.render();",[],[155,212],"8b1ee116-3f9b-11f0-91de-76b3cceeab13","index.html","8b1ee1c0-3f9b-11f0-91de-76b3cceeab13",["D",1748859773493],"\n\n\n \n \n Finance Manager\n \n \n 💰\">\n \n\n\n

\n \n \n\n",[],[155,220],"b1088ecc-3f9b-11f0-bd80-76b3cceeab13","a0c00ea2-722f-43f9-9035-4acb784f4400",["D",1748859837104],[],[155,231,32],"components","9d8f6fd2-3f9b-11f0-b5c3-76b3cceeab13","App.tsx","9d8f707c-3f9b-11f0-b5c3-76b3cceeab13",11,["D",1748859804429],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport TransactionForm from \"./TransactionForm.tsx\";\nimport TransactionList from \"./TransactionList.tsx\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport type { Transaction, SpendingAnalytics } from \"../../shared/types.ts\";\n\ntype TabType = 'dashboard' | 'transactions' | 'add';\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState('dashboard');\n const [transactions, setTransactions] = useState([]);\n const [analytics, setAnalytics] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n // Fetch transactions\n const fetchTransactions = async () => {\n try {\n const response = await fetch('/api/transactions');\n const result = await response.json();\n \n if (result.success) {\n setTransactions(result.data);\n } else {\n setError(result.error || 'Failed to fetch transactions');\n }\n } catch (err) {\n setError('Network error while fetching transactions');\n console.error('Error fetching transactions:', err);\n }\n };\n\n // Fetch analytics data\n const fetchAnalytics = async () => {\n try {\n const response = await fetch('/api/analytics/dashboard');\n const result = await response.json();\n \n if (result.success) {\n setAnalytics(result.data);\n } else {\n setError(result.error || 'Failed to fetch analytics');\n }\n } catch (err) {\n setError('Network error while fetching analytics');\n console.error('Error fetching analytics:', err);\n }\n };\n\n // Load initial data\n useEffect(() => {\n const loadData = async () => {\n setLoading(true);\n setError(null);\n \n await Promise.all([\n fetchTransactions(),\n fetchAnalytics()\n ]);\n \n setLoading(false);\n };\n\n loadData();\n }, []);\n\n // Handle transaction creation\n const handleTransactionCreated = async (transaction: Transaction) => {\n await fetchTransactions();\n await fetchAnalytics();\n setActiveTab('transactions');\n };\n\n // Handle transaction update\n const handleTransactionUpdated = async () => {\n await fetchTransactions();\n await fetchAnalytics();\n };\n\n // Handle transaction deletion\n const handleTransactionDeleted = async () => {\n await fetchTransactions();\n await fetchAnalytics();\n };\n\n if (loading) {\n return (\n

Loading your financial data...

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

\n {/* Header */}\n

\n 💰\n

Finance Manager

\n \n {/* Navigation */}\n

\n {[\n { id: 'dashboard', label: 'Dashboard', icon: '📊' },\n { id: 'transactions', label: 'Transactions', icon: '📝' },\n { id: 'add', label: 'Add Transaction', icon: '➕' }\n ].map((tab) => (\n setActiveTab(tab.id as TabType)}\n className={`px-4 py-2 rounded-lg text-sm font-medium transition-colors ${\n activeTab === tab.id\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-600 hover:text-gray-900 hover:bg-gray-100'\n }`}\n >\n {tab.icon}\n {tab.label}\n \n ))}\n

\n\n {/* Error Display */}\n {error && (\n

\n ⚠️\n

Error

{error}

\n {\n setError(null);\n window.location.reload();\n }}\n className=\"text-sm text-red-600 underline mt-2 hover:text-red-800\"\n >\n Try again\n \n

\n )}\n\n {/* Main Content */}\n

\n {activeTab === 'dashboard' && analytics && (\n \n )}\n \n {activeTab === 'transactions' && (\n \n )}\n \n {activeTab === 'add' && (\n \n )}\n

\n\n {/* Footer */}\n \n

\n );\n}",[],[155,231,233],"9d8f88e6-3f9b-11f0-b5c3-76b3cceeab13",["D",1748859804429],[186,187],[155,231],["D",1748859773493],[185,188,189],[155],"84a228ca-3f9b-11f0-813c-76b3cceeab13","index.ts",8,["D",1748859762612],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport transactions from \"./routes/transactions.ts\";\nimport analytics from \"./routes/analytics.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait runMigrations();\n\n// API routes\napp.route(\"/api/transactions\", transactions);\napp.route(\"/api/analytics\", analytics);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main application\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// Health check endpoint\napp.get(\"/health\", (c) => {\n return c.json({\n status: \"healthy\",\n timestamp: new Date().toISOString(),\n service: \"finance-management-system\"\n });\n});\n\n// 404 handler\napp.notFound((c) => {\n return c.json({\n success: false,\n error: \"Endpoint not found\"\n }, 404);\n});\n\nexport default app;",[],[161,248],"73487a98-3f9b-11f0-a5b4-76b3cceeab13","transactions.ts","73487b38-3f9b-11f0-a5b4-76b3cceeab13","f28689ca-bfc7-4d73-9fac-115a555384df",6,["D",1748859733499],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { TransactionQueries } from \"../database/queries.ts\";\nimport type { Transaction } from \"../../shared/types.ts\";\n\nconst transactions = new Hono();\n\n// Get all transactions with optional filters\ntransactions.get(\"/\", async (c) => {\n try {\n const category = c.req.query(\"category\");\n const type = c.req.query(\"type\") as 'income' | 'expense' | undefined;\n const startDate = c.req.query(\"startDate\");\n const endDate = c.req.query(\"endDate\");\n const limitStr = c.req.query(\"limit\");\n const limit = limitStr ? parseInt(limitStr) : undefined;\n\n const filters = {\n ...(category && { category }),\n ...(type && { type }),\n ...(startDate && { startDate }),\n ...(endDate && { endDate }),\n ...(limit && { limit })\n };\n\n const transactionList = await TransactionQueries.getAll(Object.keys(filters).length > 0 ? filters : undefined);\n \n return c.json({\n success: true,\n data: transactionList,\n count: transactionList.length\n });\n } catch (error) {\n console.error(\"Error fetching transactions:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch transactions\"\n }, 500);\n }\n});\n\n// Get transaction by ID\ntransactions.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid transaction ID\"\n }, 400);\n }\n\n const transaction = await TransactionQueries.getById(id);\n if (!transaction) {\n return c.json({\n success: false,\n error: \"Transaction not found\"\n }, 404);\n }\n\n return c.json({\n success: true,\n data: transaction\n });\n } catch (error) {\n console.error(\"Error fetching transaction:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch transaction\"\n }, 500);\n }\n});\n\n// Create new transaction\ntransactions.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n const { amount, description, category, date, type } = body;\n \n if (!amount || !description || !category || !date || !type) {\n return c.json({\n success: false,\n error: \"Missing required fields: amount, description, category, date, type\"\n }, 400);\n }\n\n if (typeof amount !== 'number' || amount <= 0) {\n return c.json({\n success: false,\n error: \"Amount must be a positive number\"\n }, 400);\n }\n\n if (!['income', 'expense'].includes(type)) {\n return c.json({\n success: false,\n error: \"Type must be either 'income' or 'expense'\"\n }, 400);\n }\n\n // Validate date format\n if (isNaN(Date.parse(date))) {\n return c.json({\n success: false,\n error: \"Invalid date format\"\n }, 400);\n }\n\n const transactionData: Omit = {\n amount: parseFloat(amount),\n description: description.trim(),\n category: category.trim(),\n date,\n type\n };\n\n const newTransaction = await TransactionQueries.create(transactionData);\n \n return c.json({\n success: true,\n data: newTransaction,\n message: \"Transaction created successfully\"\n }, 201);\n } catch (error) {\n console.error(\"Error creating transaction:\", error);\n return c.json({\n success: false,\n error: \"Failed to create transaction\"\n }, 500);\n }\n});\n\n// Update transaction\ntransactions.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid transaction ID\"\n }, 400);\n }\n\n const body = await c.req.json();\n const updates: Partial> = {};\n\n // Validate and prepare updates\n if (body.amount !== undefined) {\n if (typeof body.amount !== 'number' || body.amount <= 0) {\n return c.json({\n success: false,\n error: \"Amount must be a positive number\"\n }, 400);\n }\n updates.amount = parseFloat(body.amount);\n }\n\n if (body.description !== undefined) {\n updates.description = body.description.trim();\n }\n\n if (body.category !== undefined) {\n updates.category = body.category.trim();\n }\n\n if (body.date !== undefined) {\n if (isNaN(Date.parse(body.date))) {\n return c.json({\n success: false,\n error: \"Invalid date format\"\n }, 400);\n }\n updates.date = body.date;\n }\n\n if (body.type !== undefined) {\n if (!['income', 'expense'].includes(body.type)) {\n return c.json({\n success: false,\n error: \"Type must be either 'income' or 'expense'\"\n }, 400);\n }\n updates.type = body.type;\n }\n\n if (Object.keys(updates).length === 0) {\n return c.json({\n success: false,\n error: \"No valid fields to update\"\n }, 400);\n }\n\n const updatedTransaction = await TransactionQueries.update(id, updates);\n \n return c.json({\n success: true,\n data: updatedTransaction,\n message: \"Transaction updated successfully\"\n });\n } catch (error) {\n console.error(\"Error updating transaction:\", error);\n if (error.message === \"Transaction not found\") {\n return c.json({\n success: false,\n error: \"Transaction not found\"\n }, 404);\n }\n return c.json({\n success: false,\n error: \"Failed to update transaction\"\n }, 500);\n }\n});\n\n// Delete transaction\ntransactions.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid transaction ID\"\n }, 400);\n }\n\n const deleted = await TransactionQueries.delete(id);\n if (!deleted) {\n return c.json({\n success: false,\n error: \"Transaction not found\"\n }, 404);\n }\n\n return c.json({\n success: true,\n message: \"Transaction deleted successfully\"\n });\n } catch (error) {\n console.error(\"Error deleting transaction:\", error);\n return c.json({\n success: false,\n error: \"Failed to delete transaction\"\n }, 500);\n }\n});\n\nexport default transactions;",[],[161,263,255],"routes","7e0c5af8-3f9b-11f0-89c4-76b3cceeab13","analytics.ts","7e0c5bd4-3f9b-11f0-89c4-76b3cceeab13",7,["D",1748859751562],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { TransactionQueries } from \"../database/queries.ts\";\n\nconst analytics = new Hono();\n\n// Get daily spending summary\nanalytics.get(\"/daily\", async (c) => {\n try {\n const startDate = c.req.query(\"startDate\");\n const endDate = c.req.query(\"endDate\");\n\n const dailySpending = await TransactionQueries.getDailySpending(startDate, endDate);\n \n return c.json({\n success: true,\n data: dailySpending,\n count: dailySpending.length\n });\n } catch (error) {\n console.error(\"Error fetching daily spending:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch daily spending data\"\n }, 500);\n }\n});\n\n// Get monthly spending summary\nanalytics.get(\"/monthly\", async (c) => {\n try {\n const monthlySpending = await TransactionQueries.getMonthlySpending();\n \n return c.json({\n success: true,\n data: monthlySpending,\n count: monthlySpending.length\n });\n } catch (error) {\n console.error(\"Error fetching monthly spending:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch monthly spending data\"\n }, 500);\n }\n});\n\n// Get top spending categories\nanalytics.get(\"/categories\", async (c) => {\n try {\n const limitStr = c.req.query(\"limit\");\n const limit = limitStr ? parseInt(limitStr) : 10;\n\n if (isNaN(limit) || limit <= 0) {\n return c.json({\n success: false,\n error: \"Limit must be a positive number\"\n }, 400);\n }\n\n const topCategories = await TransactionQueries.getTopCategories(limit);\n \n return c.json({\n success: true,\n data: topCategories,\n count: topCategories.length\n });\n } catch (error) {\n console.error(\"Error fetching top categories:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch category data\"\n }, 500);\n }\n});\n\n// Get comprehensive analytics dashboard data\nanalytics.get(\"/dashboard\", async (c) => {\n try {\n const last30Days = new Date();\n last30Days.setDate(last30Days.getDate() - 30);\n const startDate = last30Days.toISOString().split('T')[0];\n\n const [dailySpending, monthlySpending, topCategories, recentTransactions] = await Promise.all([\n TransactionQueries.getDailySpending(startDate),\n TransactionQueries.getMonthlySpending(),\n TransactionQueries.getTopCategories(5),\n TransactionQueries.getAll({ limit: 10 })\n ]);\n\n // Calculate summary statistics\n const totalIncome = dailySpending.reduce((sum, day) => sum + day.total_income, 0);\n const totalExpenses = dailySpending.reduce((sum, day) => sum + day.total_expenses, 0);\n const netAmount = totalIncome - totalExpenses;\n const avgDailySpending = dailySpending.length > 0 ? totalExpenses / dailySpending.length : 0;\n\n const summary = {\n totalIncome,\n totalExpenses,\n netAmount,\n avgDailySpending,\n transactionCount: recentTransactions.length\n };\n\n return c.json({\n success: true,\n data: {\n summary,\n dailySpending,\n monthlySpending: monthlySpending.slice(0, 6), // Last 6 months\n topCategories,\n recentTransactions\n }\n });\n } catch (error) {\n console.error(\"Error fetching dashboard data:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch dashboard data\"\n }, 500);\n }\n});\n\nexport default analytics;",[],[161,263,265],"73488790-3f9b-11f0-a5b4-76b3cceeab13",["D",1748859733499],[181,182],[161,263],"638b748e-3f9b-11f0-9db8-76b3cceeab13","queries.ts","638b752e-3f9b-11f0-9db8-76b3cceeab13","c63bf7c1-69d3-4cd4-9e23-5ae893683059",5,["D",1748859707098],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TRANSACTIONS_TABLE } from \"./migrations.ts\";\nimport type { Transaction, DailySpending, MonthlySpending, CategorySpending } from \"../../shared/types.ts\";\n\nexport class TransactionQueries {\n // Get all transactions with optional filters\n static async getAll(filters?: {\n category?: string;\n type?: 'income' | 'expense';\n startDate?: string;\n endDate?: string;\n limit?: number;\n }): Promise {\n let query = `SELECT * FROM ${TRANSACTIONS_TABLE}`;\n const params: any[] = [];\n const conditions: string[] = [];\n\n if (filters?.category) {\n conditions.push('category = ?');\n params.push(filters.category);\n }\n\n if (filters?.type) {\n conditions.push('type = ?');\n params.push(filters.type);\n }\n\n if (filters?.startDate) {\n conditions.push('date >= ?');\n params.push(filters.startDate);\n }\n\n if (filters?.endDate) {\n conditions.push('date <= ?');\n params.push(filters.endDate);\n }\n\n if (conditions.length > 0) {\n query += ' WHERE ' + conditions.join(' AND ');\n }\n\n query += ' ORDER BY date DESC, created_at DESC';\n\n if (filters?.limit) {\n query += ' LIMIT ?';\n params.push(filters.limit);\n }\n\n const result = await sqlite.execute(query, params);\n return result.rows as Transaction[];\n }\n\n // Get transaction by ID\n static async getById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rows[0] as Transaction || null;\n }\n\n // Create new transaction\n static async create(transaction: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS_TABLE} (amount, description, category, date, type)\n VALUES (?, ?, ?, ?, ?)`,\n [transaction.amount, transaction.description, transaction.category, transaction.date, transaction.type]\n );\n\n const newTransaction = await this.getById(result.lastInsertRowId!);\n if (!newTransaction) {\n throw new Error('Failed to create transaction');\n }\n return newTransaction;\n }\n\n // Update transaction\n static async update(id: number, updates: Partial>): Promise {\n const fields: string[] = [];\n const params: any[] = [];\n\n Object.entries(updates).forEach(([key, value]) => {\n if (value !== undefined) {\n fields.push(`${key} = ?`);\n params.push(value);\n }\n });\n\n if (fields.length === 0) {\n throw new Error('No fields to update');\n }\n\n fields.push('updated_at = CURRENT_TIMESTAMP');\n params.push(id);\n\n await sqlite.execute(\n `UPDATE ${TRANSACTIONS_TABLE} SET ${fields.join(', ')} WHERE id = ?`,\n params\n );\n\n const updatedTransaction = await this.getById(id);\n if (!updatedTransaction) {\n throw new Error('Transaction not found');\n }\n return updatedTransaction;\n }\n\n // Delete transaction\n static async delete(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TRANSACTIONS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.changes > 0;\n }\n\n // Get daily spending summary\n static async getDailySpending(startDate?: string, endDate?: string): Promise {\n let query = `\n SELECT \n date,\n SUM(CASE WHEN type = 'income' THEN amount ELSE 0 END) as total_income,\n SUM(CASE WHEN type = 'expense' THEN amount ELSE 0 END) as total_expenses,\n SUM(CASE WHEN type = 'income' THEN amount ELSE -amount END) as net_amount,\n COUNT(*) as transaction_count\n FROM ${TRANSACTIONS_TABLE}\n `;\n \n const params: string[] = [];\n const conditions: string[] = [];\n\n if (startDate) {\n conditions.push('date >= ?');\n params.push(startDate);\n }\n\n if (endDate) {\n conditions.push('date <= ?');\n params.push(endDate);\n }\n\n if (conditions.length > 0) {\n query += ' WHERE ' + conditions.join(' AND ');\n }\n\n query += ' GROUP BY date ORDER BY date DESC';\n\n const result = await sqlite.execute(query, params);\n return result.rows as DailySpending[];\n }\n\n // Get monthly spending summary\n static async getMonthlySpending(): Promise {\n const query = `\n SELECT \n strftime('%Y-%m', date) as month,\n SUM(CASE WHEN type = 'income' THEN amount ELSE 0 END) as total_income,\n SUM(CASE WHEN type = 'expense' THEN amount ELSE 0 END) as total_expenses,\n SUM(CASE WHEN type = 'income' THEN amount ELSE -amount END) as net_amount,\n COUNT(*) as transaction_count\n FROM ${TRANSACTIONS_TABLE}\n GROUP BY strftime('%Y-%m', date)\n ORDER BY month DESC\n `;\n\n const result = await sqlite.execute(query);\n const monthlyData = result.rows as Omit[];\n\n // Get category breakdown for each month\n const monthlySpending: MonthlySpending[] = [];\n for (const month of monthlyData) {\n const categories = await this.getCategorySpendingForMonth(month.month);\n monthlySpending.push({\n ...month,\n categories\n });\n }\n\n return monthlySpending;\n }\n\n // Get category spending for a specific month\n static async getCategorySpendingForMonth(month: string): Promise {\n const query = `\n SELECT \n category,\n SUM(amount) as total_amount,\n COUNT(*) as transaction_count\n FROM ${TRANSACTIONS_TABLE}\n WHERE strftime('%Y-%m', date) = ? AND type = 'expense'\n GROUP BY category\n ORDER BY total_amount DESC\n `;\n\n const result = await sqlite.execute(query, [month]);\n const categories = result.rows as Omit[];\n\n // Calculate percentages\n const totalExpenses = categories.reduce((sum, cat) => sum + cat.total_amount, 0);\n \n return categories.map(cat => ({\n ...cat,\n percentage: totalExpenses > 0 ? (cat.total_amount / totalExpenses) * 100 : 0\n }));\n }\n\n // Get top spending categories overall\n static async getTopCategories(limit: number = 10): Promise {\n const query = `\n SELECT \n category,\n SUM(amount) as total_amount,\n COUNT(*) as transaction_count\n FROM ${TRANSACTIONS_TABLE}\n WHERE type = 'expense'\n GROUP BY category\n ORDER BY total_amount DESC\n LIMIT ?\n `;\n\n const result = await sqlite.execute(query, [limit]);\n const categories = result.rows as Omit[];\n\n // Calculate percentages\n const totalExpenses = categories.reduce((sum, cat) => sum + cat.total_amount, 0);\n \n return categories.map(cat => ({\n ...cat,\n percentage: totalExpenses > 0 ? (cat.total_amount / totalExpenses) * 100 : 0\n }));\n }\n}",[],[161,285,277],"database","54011b68-3f9b-11f0-a781-76b3cceeab13","migrations.ts","54011c58-3f9b-11f0-a781-76b3cceeab13",["D",1748859681025],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TRANSACTIONS_TABLE = 'finance_transactions_v1';\n\nexport async function runMigrations() {\n console.log('Running database migrations...');\n \n // Create transactions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TRANSACTIONS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n amount REAL NOT NULL,\n description TEXT NOT NULL,\n category TEXT NOT NULL,\n date TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('income', 'expense')),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create index for faster queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_transactions_date \n ON ${TRANSACTIONS_TABLE}(date)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_transactions_category \n ON ${TRANSACTIONS_TABLE}(category)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_transactions_type \n ON ${TRANSACTIONS_TABLE}(type)\n `);\n\n console.log('Database migrations completed successfully');\n}\n\nexport { TRANSACTIONS_TABLE };",[],[161,285,287],"5401266c-3f9b-11f0-a781-76b3cceeab13",["D",1748859681025],[178,179],[161,285],["D",1748859681025],[177,180,183],[161],["D",1748859081381],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":337,"_338":339,"_340":341,"_342":24,"_343":24,"_344":24,"_345":58,"_346":-5,"_347":-7,"_348":-7,"_349":62,"_350":24,"_351":24,"_352":-5,"_353":24,"_354":24,"_355":24,"_356":-5},"ENV",{"_308":309,"_310":311,"_312":86,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v12