\n \n \n\n",[],[261,263],"cb8bd9d4-3f9b-11f0-8f7f-76b3cceeab13","TransactionList.tsx","cb8bda74-3f9b-11f0-8f7f-76b3cceeab13","a0c00ea2-722f-43f9-9035-4acb784f4400",13,["D",1748859881582],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport TransactionForm from \"./TransactionForm.tsx\";\nimport type { Transaction } from \"../../shared/types.ts\";\nimport { TRANSACTION_CATEGORIES } from \"../../shared/types.ts\";\n\ninterface TransactionListProps {\n transactions: Transaction[];\n onTransactionUpdated: () => void;\n onTransactionDeleted: () => void;\n}\n\nexport default function TransactionList({ \n transactions, \n onTransactionUpdated, \n onTransactionDeleted \n}: TransactionListProps) {\n const [editingTransaction, setEditingTransaction] = useState(null);\n const [filters, setFilters] = useState({\n category: '',\n type: '',\n search: ''\n });\n const [sortBy, setSortBy] = useState<'date' | 'amount' | 'category'>('date');\n const [sortOrder, setSortOrder] = useState<'asc' | 'desc'>('desc');\n\n // Filter and sort transactions\n const filteredTransactions = transactions\n .filter(transaction => {\n const matchesCategory = !filters.category || transaction.category === filters.category;\n const matchesType = !filters.type || transaction.type === filters.type;\n const matchesSearch = !filters.search || \n transaction.description.toLowerCase().includes(filters.search.toLowerCase()) ||\n transaction.category.toLowerCase().includes(filters.search.toLowerCase());\n \n return matchesCategory && matchesType && matchesSearch;\n })\n .sort((a, b) => {\n let comparison = 0;\n \n switch (sortBy) {\n case 'date':\n comparison = new Date(a.date).getTime() - new Date(b.date).getTime();\n break;\n case 'amount':\n comparison = a.amount - b.amount;\n break;\n case 'category':\n comparison = a.category.localeCompare(b.category);\n break;\n }\n \n return sortOrder === 'asc' ? comparison : -comparison;\n });\n\n const handleDelete = async (id: number) => {\n if (!confirm('Are you sure you want to delete this transaction?')) {\n return;\n }\n\n try {\n const response = await fetch(`/api/transactions/${id}`, {\n method: 'DELETE',\n });\n\n const result = await response.json();\n\n if (result.success) {\n onTransactionDeleted();\n } else {\n alert('Failed to delete transaction: ' + result.error);\n }\n } catch (error) {\n alert('Network error while deleting transaction');\n console.error('Error deleting transaction:', error);\n }\n };\n\n const handleEdit = (transaction: Transaction) => {\n setEditingTransaction(transaction);\n };\n\n const handleEditComplete = () => {\n setEditingTransaction(null);\n onTransactionUpdated();\n };\n\n const formatCurrency = (amount: number) => {\n return new Intl.NumberFormat('en-US', {\n style: 'currency',\n currency: 'USD'\n }).format(amount);\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n };\n\n // Calculate totals for filtered transactions\n const totalIncome = filteredTransactions\n .filter(t => t.type === 'income')\n .reduce((sum, t) => sum + t.amount, 0);\n \n const totalExpenses = filteredTransactions\n .filter(t => t.type === 'expense')\n .reduce((sum, t) => sum + t.amount, 0);\n\n if (editingTransaction) {\n return (\n setEditingTransaction(null)}\n />\n );\n }\n\n return (\n

\n {/* Header */}\n

Transactions

\n {filteredTransactions.length} of {transactions.length} transactions\n

\n\n {/* Summary Cards */}\n

\n 💰\n

Total Income

{formatCurrency(totalIncome)}

\n \n

\n 💸\n

Total Expenses

{formatCurrency(totalExpenses)}

\n \n

= 0 \n ? 'bg-blue-50 border-blue-200' \n : 'bg-orange-50 border-orange-200'\n }`}>\n

\n \n {totalIncome - totalExpenses >= 0 ? '📈' : '📉'}\n \n

= 0 ? 'text-blue-800' : 'text-orange-800'\n }`}>\n Net Amount\n

= 0 ? 'text-blue-900' : 'text-orange-900'\n }`}>\n {formatCurrency(totalIncome - totalExpenses)}\n

\n\n {/* Filters and Search */}\n

\n {/* Search */}\n

\n \n Search\n \n setFilters(prev => ({ ...prev, search: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500\"\n />\n

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

\n \n Category\n \n setFilters(prev => ({ ...prev, category: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500\"\n >\n \n {TRANSACTION_CATEGORIES.map((category) => (\n \n ))}\n \n

\n\n {/* Type Filter */}\n

\n \n Type\n \n setFilters(prev => ({ ...prev, type: e.target.value }))}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500\"\n >\n \n \n \n \n

\n\n {/* Sort */}\n

\n \n Sort By\n \n

\n setSortBy(e.target.value as 'date' | 'amount' | 'category')}\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500\"\n >\n \n \n \n \n setSortOrder(prev => prev === 'asc' ? 'desc' : 'asc')}\n className=\"px-3 py-2 border border-gray-300 rounded-lg hover:bg-gray-50\"\n title={`Sort ${sortOrder === 'asc' ? 'Descending' : 'Ascending'}`}\n >\n {sortOrder === 'asc' ? '↑' : '↓'}\n \n

\n\n {/* Transaction List */}\n

\n {filteredTransactions.length === 0 ? (\n

\n 📝\n

No transactions found

\n {transactions.length === 0 \n ? \"Start by adding your first transaction!\"\n : \"Try adjusting your filters to see more transactions.\"\n }\n

\n ) : (\n

\n {filteredTransactions.map((transaction) => (\n \n

\n \n {transaction.category}\n \n \n {formatDate(transaction.date)}\n \n

\n {transaction.description}\n

\n \n

\n {transaction.type === 'income' ? '+' : '-'}{formatCurrency(transaction.amount)}\n

\n \n

\n handleEdit(transaction)}\n className=\"p-2 text-gray-400 hover:text-blue-600 hover:bg-blue-50 rounded-lg\"\n title=\"Edit transaction\"\n >\n ✏️\n \n handleDelete(transaction.id!)}\n className=\"p-2 text-gray-400 hover:text-red-600 hover:bg-red-50 rounded-lg\"\n title=\"Delete transaction\"\n >\n 🗑️\n \n

\n ))}\n

\n )}\n

\n \n );\n}",[],[261,279,271],"components","b1088ecc-3f9b-11f0-bd80-76b3cceeab13","TransactionForm.tsx","b1088f76-3f9b-11f0-bd80-76b3cceeab13",12,["D",1748859837104],"/** @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}",[],[261,279,281],"e3c5c62c-3f9b-11f0-abad-76b3cceeab13","Dashboard.tsx","e3c5c6c2-3f9b-11f0-abad-76b3cceeab13",14,["D",1748859922227],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { SpendingAnalytics } from \"../../shared/types.ts\";\n\ninterface DashboardProps {\n analytics: SpendingAnalytics;\n}\n\nexport default function Dashboard({ analytics }: DashboardProps) {\n const formatCurrency = (amount: number) => {\n return new Intl.NumberFormat('en-US', {\n style: 'currency',\n currency: 'USD'\n }).format(amount);\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric'\n });\n };\n\n const formatMonth = (monthString: string) => {\n const [year, month] = monthString.split('-');\n return new Date(parseInt(year), parseInt(month) - 1).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long'\n });\n };\n\n return (\n

\n {/* Header */}\n

Financial Dashboard

Overview of your spending and income patterns

\n\n {/* Summary Cards */}\n

\n 💰\n

Total Income (30d)

\n {formatCurrency(analytics.summary.totalIncome)}\n

\n \n

\n 💸\n

Total Expenses (30d)

\n {formatCurrency(analytics.summary.totalExpenses)}\n

\n \n

= 0 \n ? 'bg-blue-50 border-blue-200' \n : 'bg-orange-50 border-orange-200'\n }`}>\n

\n \n {analytics.summary.netAmount >= 0 ? '📈' : '📉'}\n \n

= 0 ? 'text-blue-800' : 'text-orange-800'\n }`}>\n Net Amount (30d)\n

= 0 ? 'text-blue-900' : 'text-orange-900'\n }`}>\n {formatCurrency(analytics.summary.netAmount)}\n

\n \n

\n 📊\n

Avg Daily Spending

\n {formatCurrency(analytics.summary.avgDailySpending)}\n

\n\n {/* Charts Row */}\n

\n {/* Daily Spending Chart */}\n

Daily Spending (Last 30 Days)

\n {analytics.dailySpending.slice(0, 10).map((day, index) => {\n const maxAmount = Math.max(...analytics.dailySpending.map(d => d.total_expenses));\n const percentage = maxAmount > 0 ? (day.total_expenses / maxAmount) * 100 : 0;\n \n return (\n

\n {formatDate(day.date)}\n

\n \n {day.total_expenses > 0 && (\n \n {formatCurrency(day.total_expenses)}\n \n )}\n

\n );\n })}\n

\n\n {/* Top Categories */}\n

Top Spending Categories

\n {analytics.topCategories.map((category, index) => (\n

\n {index + 1}\n

{category.category}

\n {category.transaction_count} transaction{category.transaction_count !== 1 ? 's' : ''}\n

\n {formatCurrency(category.total_amount)}\n

\n {category.percentage.toFixed(1)}%\n

\n ))}\n

\n\n {/* Monthly Overview */}\n

Monthly Overview

\n \n \n \n \n \n \n \n \n \n \n \n {analytics.monthlySpending.map((month) => (\n \n \n \n \n \n \n \n ))}\n \n

Month	Income	Expenses	Net	Transactions
\n {formatMonth(month.month)}\n	\n {formatCurrency(month.total_income)}\n	\n {formatCurrency(month.total_expenses)}\n	= 0 ? 'text-blue-600' : 'text-orange-600'\n }`}>\n {formatCurrency(month.net_amount)}\n	\n {month.transaction_count}\n

\n\n {/* Recent Transactions */}\n

Recent Transactions

\n {analytics.recentTransactions.map((transaction) => (\n

\n \n

{transaction.description}

\n {transaction.category} • {formatDate(transaction.date)}\n

\n {transaction.type === 'income' ? '+' : '-'}{formatCurrency(transaction.amount)}\n

\n ))}\n

\n \n );\n}",[],[261,279,289],"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}",[],[261,279,297],"9d8f88e6-3f9b-11f0-b5c3-76b3cceeab13",["D",1748859804429],[212,213,214,215],[261,279],"8b1eefb2-3f9b-11f0-91de-76b3cceeab13",["D",1748859773493],[211,216,217],[261],"f5451434-3f9b-11f0-9421-76b3cceeab13","index.ts",["D",1748859951579],"http","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\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[180,313],"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;",[],[180,328,320],"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;",[],[180,328,330],"73488790-3f9b-11f0-a5b4-76b3cceeab13",["D",1748859733499],[207,208],[180,328],["D",1748859943045],[],[180,99,82],["D",1748859938774],[],[180,99,67],["D",1748859681025],[204,205],[180,99],"54012428-3f9b-11f0-a781-76b3cceeab13",["D",1748859681025],[203,206,209],[180],["D",1748859081381],{"_11":12,"_150":73},{"_11":12,"_146":-5,"_72":73,"_31":71,"_147":148,"_149":30},{"_42":137,"_13":16,"_36":39,"_138":102,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":14,"_145":12},"ctx",{"_55":-5,"_169":391,"_392":393,"_394":395,"_396":30,"_397":30,"_398":30,"_399":24,"_400":-5,"_401":-7,"_402":-7,"_403":26,"_404":30,"_405":30,"_406":-5,"_407":30,"_408":30,"_409":30,"_410":-5},"ENV",{"_362":363,"_364":365,"_366":16,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

History · database