\n \n\n",[18,66],"a2906db8-3fac-11f0-8fc3-76b3cceeab13",["D",1748867114268],[18,90],"pulls","branches",1,"forks","envVars",{"_192":26,"_194":26},"connections",{"_192":26,"_193":26},"count","unfilledCount","emptyCount",{"_35":368,"_13":307,"_64":301,"_45":-5,"_37":38,"_164":359,"_165":24,"_39":369,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_223":370,"_17":371},{"_35":364,"_13":355,"_64":349,"_45":301,"_37":38,"_164":359,"_165":24,"_39":365,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_223":366,"_17":367},{"_35":356,"_13":357,"_64":358,"_45":349,"_37":38,"_164":359,"_165":24,"_39":360,"_41":26,"_67":81,"_167":361,"_68":30,"_168":-5,"_223":362,"_17":363},{"_35":346,"_13":347,"_64":348,"_45":349,"_37":38,"_164":350,"_165":24,"_39":351,"_41":26,"_67":81,"_167":352,"_68":30,"_168":-5,"_223":353,"_17":354},{"_35":342,"_13":317,"_64":311,"_45":301,"_37":38,"_164":329,"_165":24,"_39":343,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_223":344,"_17":345},{"_35":334,"_13":335,"_64":336,"_45":311,"_37":38,"_164":337,"_165":24,"_39":338,"_41":26,"_67":81,"_167":339,"_68":30,"_168":-5,"_223":340,"_17":341},{"_35":326,"_13":327,"_64":328,"_45":311,"_37":38,"_164":329,"_165":24,"_39":330,"_41":26,"_67":81,"_167":331,"_68":30,"_168":-5,"_223":332,"_17":333},{"_35":318,"_13":319,"_64":320,"_45":311,"_37":38,"_164":321,"_165":24,"_39":322,"_41":26,"_67":81,"_167":323,"_68":30,"_168":-5,"_223":324,"_17":325},{"_35":308,"_13":309,"_64":310,"_45":311,"_37":38,"_164":312,"_165":24,"_39":313,"_41":26,"_67":81,"_167":314,"_68":30,"_168":-5,"_223":315,"_17":316},{"_35":299,"_13":300,"_64":104,"_45":301,"_37":38,"_164":128,"_165":24,"_39":302,"_41":230,"_67":303,"_167":304,"_68":30,"_168":-5,"_223":305,"_17":306},{"_35":163,"_13":18,"_64":92,"_45":-5,"_37":38,"_164":42,"_165":24,"_39":296,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_223":297,"_17":298},{"_35":181,"_13":90,"_64":89,"_45":92,"_37":38,"_164":84,"_165":24,"_39":293,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_223":294,"_17":295},{"_35":286,"_13":287,"_64":288,"_45":89,"_37":38,"_164":84,"_165":24,"_39":289,"_41":26,"_67":81,"_167":290,"_68":30,"_168":-5,"_223":291,"_17":292},{"_35":278,"_13":279,"_64":280,"_45":89,"_37":38,"_164":281,"_165":24,"_39":282,"_41":26,"_67":81,"_167":283,"_68":30,"_168":-5,"_223":284,"_17":285},{"_35":270,"_13":271,"_64":272,"_45":89,"_37":38,"_164":273,"_165":24,"_39":274,"_41":26,"_67":81,"_167":275,"_68":30,"_168":-5,"_223":276,"_17":277},{"_35":262,"_13":263,"_64":264,"_45":89,"_37":38,"_164":265,"_165":24,"_39":266,"_41":26,"_67":81,"_167":267,"_68":30,"_168":-5,"_223":268,"_17":269},{"_35":254,"_13":255,"_64":256,"_45":89,"_37":38,"_164":257,"_165":24,"_39":258,"_41":26,"_67":81,"_167":259,"_68":30,"_168":-5,"_223":260,"_17":261},{"_35":246,"_13":247,"_64":248,"_45":89,"_37":38,"_164":249,"_165":24,"_39":250,"_41":26,"_67":81,"_167":251,"_68":30,"_168":-5,"_223":252,"_17":253},{"_35":177,"_13":66,"_64":65,"_45":92,"_37":38,"_164":42,"_165":24,"_39":243,"_41":26,"_67":21,"_167":179,"_68":30,"_168":-5,"_223":244,"_17":245},{"_35":173,"_13":80,"_64":79,"_45":92,"_37":38,"_164":74,"_165":24,"_39":240,"_41":26,"_67":81,"_167":175,"_68":30,"_168":-5,"_223":241,"_17":242},{"_35":236,"_13":235,"_64":229,"_45":-5,"_37":38,"_164":230,"_165":24,"_39":237,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_223":238,"_17":239},{"_35":226,"_13":227,"_64":228,"_45":229,"_37":38,"_164":230,"_165":24,"_39":231,"_41":26,"_67":81,"_167":232,"_68":30,"_168":-5,"_223":233,"_17":234},{"_35":218,"_13":219,"_64":220,"_45":-5,"_37":38,"_164":186,"_165":24,"_39":221,"_41":26,"_67":21,"_167":222,"_68":30,"_168":-5,"_223":224,"_17":225},"5412ef26-3fac-11f0-bb1f-76b3cceeab13","README.md","5412eff8-3fac-11f0-bb1f-76b3cceeab13",["D",1748866982585],"# Rental Property Management App\n\nA comprehensive web application for managing rental properties, tracking rent payments, maintenance costs, staff payments, and taxes.\n\n## Features\n\n- **Rent Payments**: Track tenant payments, due dates, and payment history\n- **Maintenance Costs**: Log and categorize property maintenance expenses\n- **Staff Payments**: Manage payments to contractors, cleaners, and other staff\n- **Tax Management**: Track tax-deductible expenses and generate reports\n- **Financial Dashboard**: Overview of income, expenses, and profitability\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│ │ ├── payments.ts # Rent payment endpoints\n│ │ ├── maintenance.ts # Maintenance cost endpoints\n│ │ ├── staff.ts # Staff payment endpoints\n│ │ └── taxes.ts # Tax-related endpoints\n│ └── index.ts # Main API server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── Dashboard.tsx # Financial overview dashboard\n│ │ ├── RentPayments.tsx # Rent payment management\n│ │ ├── Maintenance.tsx # Maintenance cost tracking\n│ │ ├── StaffPayments.tsx# Staff payment management\n│ │ └── TaxReports.tsx # Tax reporting and analytics\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript interfaces\n```\n\n## Getting Started\n\n1. The app will automatically set up the database on first run\n2. Navigate to the main page to access the dashboard\n3. Use the navigation to switch between different management sections\n\n## Database Schema\n\n- **tenants**: Tenant information and lease details\n- **rent_payments**: Rent payment records\n- **maintenance_costs**: Property maintenance expenses\n- **staff_payments**: Payments to staff and contractors\n- **tax_categories**: Tax-deductible expense categories","children",[],[219],"5a36bd56-3fac-11f0-8185-76b3cceeab13","types.ts","5a36be00-3fac-11f0-8185-76b3cceeab13","7a0d0a80-27d3-4b8e-b4f0-a0f9b6579a12",2,["D",1748866992886],"// Shared TypeScript interfaces for the rental property management app\n\nexport interface Tenant {\n id: number;\n name: string;\n email: string;\n phone: string;\n unit: string;\n lease_start: string;\n lease_end: string;\n monthly_rent: number;\n security_deposit: number;\n created_at: string;\n}\n\nexport interface RentPayment {\n id: number;\n tenant_id: number;\n tenant_name?: string;\n amount: number;\n due_date: string;\n paid_date: string | null;\n payment_method: string;\n notes: string;\n status: 'pending' | 'paid' | 'late' | 'partial';\n created_at: string;\n}\n\nexport interface MaintenanceCost {\n id: number;\n description: string;\n category: string;\n amount: number;\n date: string;\n vendor: string;\n unit: string;\n receipt_url: string;\n tax_deductible: boolean;\n created_at: string;\n}\n\nexport interface StaffPayment {\n id: number;\n staff_name: string;\n role: string;\n amount: number;\n payment_date: string;\n payment_type: 'hourly' | 'fixed' | 'commission';\n hours_worked: number | null;\n hourly_rate: number | null;\n description: string;\n tax_form_type: string; // 1099, W2, etc.\n created_at: string;\n}\n\nexport interface TaxCategory {\n id: number;\n name: string;\n description: string;\n deductible_percentage: number;\n}\n\nexport interface FinancialSummary {\n total_rent_collected: number;\n total_maintenance_costs: number;\n total_staff_payments: number;\n net_income: number;\n tax_deductible_expenses: number;\n pending_rent: number;\n}\n\nexport interface MonthlyReport {\n month: string;\n year: number;\n rent_income: number;\n maintenance_expenses: number;\n staff_expenses: number;\n net_profit: number;\n tax_deductions: number;\n}",[],[235,227],"shared","5a36c314-3fac-11f0-8185-76b3cceeab13",["D",1748866992886],[216],[235],["D",1748867098417],[],[18,80],["D",1748867091716],[],[18,66],"33e7a1e6-3fad-11f0-b1c7-76b3cceeab13","TaxReports.tsx","33e7a2a4-3fad-11f0-b1c7-76b3cceeab13",17,["D",1748867358113],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { MonthlyReport, TaxCategory } from \"../../shared/types.ts\";\n\nexport default function TaxReports() {\n const [monthlyReports, setMonthlyReports] = useState([]);\n const [taxCategories, setTaxCategories] = useState([]);\n const [selectedYear, setSelectedYear] = useState(new Date().getFullYear());\n const [loading, setLoading] = useState(true);\n\n const months = [\n 'January', 'February', 'March', 'April', 'May', 'June',\n 'July', 'August', 'September', 'October', 'November', 'December'\n ];\n\n useEffect(() => {\n fetchData();\n }, [selectedYear]);\n\n const fetchData = async () => {\n setLoading(true);\n try {\n const [reportsRes, categoriesRes] = await Promise.all([\n fetch(`/api/taxes/reports/${selectedYear}`),\n fetch('/api/taxes/categories')\n ]);\n \n const reportsData = await reportsRes.json();\n const categoriesData = await categoriesRes.json();\n \n setMonthlyReports(reportsData);\n setTaxCategories(categoriesData);\n } catch (error) {\n console.error('Error fetching tax data:', error);\n } finally {\n setLoading(false);\n }\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 getYearlyTotals = () => {\n return monthlyReports.reduce((totals, report) => ({\n rent_income: totals.rent_income + report.rent_income,\n maintenance_expenses: totals.maintenance_expenses + report.maintenance_expenses,\n staff_expenses: totals.staff_expenses + report.staff_expenses,\n net_profit: totals.net_profit + report.net_profit,\n tax_deductions: totals.tax_deductions + report.tax_deductions\n }), {\n rent_income: 0,\n maintenance_expenses: 0,\n staff_expenses: 0,\n net_profit: 0,\n tax_deductions: 0\n });\n };\n\n const generateTaxSummary = () => {\n const yearlyTotals = getYearlyTotals();\n const taxableIncome = yearlyTotals.rent_income - yearlyTotals.tax_deductions;\n \n return {\n grossIncome: yearlyTotals.rent_income,\n totalDeductions: yearlyTotals.tax_deductions,\n taxableIncome: taxableIncome,\n netProfit: yearlyTotals.net_profit,\n deductionRate: yearlyTotals.rent_income > 0 ? (yearlyTotals.tax_deductions / yearlyTotals.rent_income) * 100 : 0\n };\n };\n\n const exportToCSV = () => {\n const headers = ['Month', 'Rent Income', 'Maintenance Expenses', 'Staff Expenses', 'Net Profit', 'Tax Deductions'];\n const csvContent = [\n headers.join(','),\n ...monthlyReports.map(report => [\n months[parseInt(report.month) - 1],\n report.rent_income,\n report.maintenance_expenses,\n report.staff_expenses,\n report.net_profit,\n report.tax_deductions\n ].join(','))\n ].join('\\n');\n\n const blob = new Blob([csvContent], { type: 'text/csv' });\n const url = window.URL.createObjectURL(blob);\n const a = document.createElement('a');\n a.href = url;\n a.download = `rental-property-report-${selectedYear}.csv`;\n a.click();\n window.URL.revokeObjectURL(url);\n };\n\n const yearlyTotals = getYearlyTotals();\n const taxSummary = generateTaxSummary();\n\n if (loading) {\n return

Loading tax reports...

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

\n {/* Header */}\n

\n Tax Reports\n

\n Financial reports and tax deduction summaries\n

\n \n \n

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

{formatCurrency(taxSummary.grossIncome)}

Gross Rental Income

{formatCurrency(taxSummary.totalDeductions)}

Total Deductions

{formatCurrency(taxSummary.taxableIncome)}

Taxable Income

{taxSummary.deductionRate.toFixed(1)}%

Deduction Rate

\n\n {/* Tax Categories */}\n

Tax-Deductible Categories

\n {taxCategories.map((category) => (\n

{category.name}

{category.description}

\n {category.deductible_percentage}% deductible\n

\n ))}\n

\n\n {/* Monthly Reports Table */}\n

Monthly Financial Report - {selectedYear}

\n \n \n \n \n \n \n \n \n \n \n \n \n {monthlyReports.map((report) => (\n \n \n \n \n \n \n \n \n ))}\n {/* Totals Row */}\n \n \n \n \n \n \n \n \n \n

\n Month\n	\n Rent Income\n	\n Maintenance\n	\n Staff Payments\n	\n Net Profit\n	\n Tax Deductions\n
\n {months[parseInt(report.month) - 1]}\n	\n {formatCurrency(report.rent_income)}\n	\n {formatCurrency(report.maintenance_expenses)}\n	\n {formatCurrency(report.staff_expenses)}\n	= 0 ? 'text-green-600' : 'text-red-600'\n }`}>\n {formatCurrency(report.net_profit)}\n	\n {formatCurrency(report.tax_deductions)}\n
\n TOTAL\n	\n {formatCurrency(yearlyTotals.rent_income)}\n	\n {formatCurrency(yearlyTotals.maintenance_expenses)}\n	\n {formatCurrency(yearlyTotals.staff_expenses)}\n	= 0 ? 'text-green-600' : 'text-red-600'\n }`}>\n {formatCurrency(yearlyTotals.net_profit)}\n	\n {formatCurrency(yearlyTotals.tax_deductions)}\n

\n\n {/* Tax Planning Tips */}\n

💡 Tax Planning Tips

Maximize Deductions

• Keep detailed records of all maintenance expenses
• Track mileage for property-related travel
• Document professional service fees
• Consider depreciation on property improvements

Record Keeping

• Save all receipts and invoices
• Maintain separate business bank accounts
• Document the business purpose of expenses
• Keep records for at least 3-7 years

\n Disclaimer: This report is for informational purposes only. \n Consult with a qualified tax professional for specific tax advice and compliance requirements.\n

\n );\n}",[],[18,90,247],"160f4cc8-3fad-11f0-93a4-76b3cceeab13","StaffPayments.tsx","160f4d90-3fad-11f0-93a4-76b3cceeab13",16,["D",1748867308040],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { StaffPayment } from \"../../shared/types.ts\";\n\nexport default function StaffPayments() {\n const [payments, setPayments] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showAddPayment, setShowAddPayment] = useState(false);\n\n const roles = [\n 'Property Manager',\n 'Maintenance Technician',\n 'Cleaner',\n 'Landscaper',\n 'Security Guard',\n 'Contractor',\n 'Accountant',\n 'Lawyer',\n 'Real Estate Agent',\n 'Other'\n ];\n\n const taxFormTypes = [\n '1099-NEC',\n '1099-MISC',\n 'W-2',\n 'W-9',\n 'Other'\n ];\n\n useEffect(() => {\n fetchPayments();\n }, []);\n\n const fetchPayments = async () => {\n try {\n const response = await fetch('/api/staff');\n const data = await response.json();\n setPayments(data);\n } catch (error) {\n console.error('Error fetching staff payments:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleAddPayment = async (e: React.FormEvent) => {\n e.preventDefault();\n const form = e.target as HTMLFormElement;\n const formData = new FormData(form);\n \n const paymentType = formData.get('payment_type') as string;\n const hoursWorked = paymentType === 'hourly' ? parseFloat(formData.get('hours_worked') as string) : null;\n const hourlyRate = paymentType === 'hourly' ? parseFloat(formData.get('hourly_rate') as string) : null;\n const amount = paymentType === 'hourly' && hoursWorked && hourlyRate \n ? hoursWorked * hourlyRate \n : parseFloat(formData.get('amount') as string);\n\n const payment = {\n staff_name: formData.get('staff_name') as string,\n role: formData.get('role') as string,\n amount: amount,\n payment_date: formData.get('payment_date') as string,\n payment_type: paymentType,\n hours_worked: hoursWorked,\n hourly_rate: hourlyRate,\n description: formData.get('description') as string,\n tax_form_type: formData.get('tax_form_type') as string\n };\n\n try {\n const response = await fetch('/api/staff', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(payment)\n });\n\n if (response.ok) {\n setShowAddPayment(false);\n form.reset();\n fetchPayments();\n }\n } catch (error) {\n console.error('Error adding staff payment:', error);\n }\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();\n };\n\n const getStaffSummary = () => {\n const summary: { [key: string]: { total: number; count: number } } = {};\n payments.forEach(payment => {\n if (!summary[payment.staff_name]) {\n summary[payment.staff_name] = { total: 0, count: 0 };\n }\n summary[payment.staff_name].total += payment.amount;\n summary[payment.staff_name].count += 1;\n });\n return summary;\n };\n\n const getRoleSummary = () => {\n const summary: { [key: string]: number } = {};\n payments.forEach(payment => {\n summary[payment.role] = (summary[payment.role] || 0) + payment.amount;\n });\n return summary;\n };\n\n const totalPayments = payments.reduce((sum, payment) => sum + payment.amount, 0);\n const staffSummary = getStaffSummary();\n const roleSummary = getRoleSummary();\n\n if (loading) {\n return

Loading staff payments...

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

\n {/* Header */}\n

\n Staff Payments\n

\n Manage payments to contractors, employees, and service providers\n

\n setShowAddPayment(true)}\n className=\"btn-primary\"\n >\n 👥 Record Payment\n \n

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

{formatCurrency(totalPayments)}

Total Staff Payments

{Object.keys(staffSummary).length}

Active Staff Members

{payments.length}

Total Payments

\n\n {/* Summary Breakdowns */}\n

Payments by Staff Member

\n {Object.entries(staffSummary)\n .sort(([,a], [,b]) => b.total - a.total)\n .slice(0, 8)\n .map(([name, data]) => (\n

{name}

{data.count} payments

\n {formatCurrency(data.total)}\n

\n ))}\n

\n\n

Payments by Role

\n {Object.entries(roleSummary)\n .sort(([,a], [,b]) => b - a)\n .slice(0, 8)\n .map(([role, total]) => (\n

\n {role}\n {formatCurrency(total)}\n

\n ))}\n

\n\n {/* Staff Payments Table */}\n

Payment Records

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {payments.map((payment) => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

\n Staff Member\n	\n Role\n	\n Amount\n	\n Payment Date\n	\n Type\n	\n Tax Form\n	\n Description\n
\n {payment.staff_name}\n	\n \n {payment.role}\n \n	\n {formatCurrency(payment.amount)}\n {payment.payment_type === 'hourly' && payment.hours_worked && payment.hourly_rate && (\n \n {payment.hours_worked}h × {formatCurrency(payment.hourly_rate)}\n \n )}\n	\n {formatDate(payment.payment_date)}\n	\n \n {payment.payment_type}\n \n	\n {payment.tax_form_type}\n	\n {payment.description \|\| '-'}\n

\n\n {/* Add Staff Payment Modal */}\n {showAddPayment && (\n

Record Staff Payment

\n Staff Member Name\n \n

\n Role\n \n

\n Payment Type\n \n

\n Hours Worked\n \n

\n Hourly Rate\n \n

\n Amount\n \n

\n Payment Date\n \n

\n Tax Form Type\n \n

\n Description\n \n

\n setShowAddPayment(false)}\n className=\"btn-secondary\"\n >\n Cancel\n \n \n

\n )}\n

\n );\n}",[],[18,90,255],"d83f3250-3fac-11f0-ac6b-76b3cceeab13","RentPayments.tsx","d83f361a-3fac-11f0-ac6b-76b3cceeab13",14,["D",1748867204335],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { RentPayment, Tenant } from \"../../shared/types.ts\";\n\nexport default function RentPayments() {\n const [payments, setPayments] = useState([]);\n const [tenants, setTenants] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showAddPayment, setShowAddPayment] = useState(false);\n const [showAddTenant, setShowAddTenant] = useState(false);\n\n useEffect(() => {\n fetchData();\n }, []);\n\n const fetchData = async () => {\n try {\n const [paymentsRes, tenantsRes] = await Promise.all([\n fetch('/api/payments'),\n fetch('/api/payments/tenants')\n ]);\n \n const paymentsData = await paymentsRes.json();\n const tenantsData = await tenantsRes.json();\n \n setPayments(paymentsData);\n setTenants(tenantsData);\n } catch (error) {\n console.error('Error fetching data:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleAddPayment = async (e: React.FormEvent) => {\n e.preventDefault();\n const form = e.target as HTMLFormElement;\n const formData = new FormData(form);\n \n const payment = {\n tenant_id: parseInt(formData.get('tenant_id') as string),\n amount: parseFloat(formData.get('amount') as string),\n due_date: formData.get('due_date') as string,\n paid_date: formData.get('paid_date') as string || null,\n payment_method: formData.get('payment_method') as string,\n notes: formData.get('notes') as string,\n status: formData.get('status') as string\n };\n\n try {\n const response = await fetch('/api/payments', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(payment)\n });\n\n if (response.ok) {\n setShowAddPayment(false);\n form.reset();\n fetchData();\n }\n } catch (error) {\n console.error('Error adding payment:', error);\n }\n };\n\n const handleAddTenant = async (e: React.FormEvent) => {\n e.preventDefault();\n const form = e.target as HTMLFormElement;\n const formData = new FormData(form);\n \n const tenant = {\n name: formData.get('name') as string,\n email: formData.get('email') as string,\n phone: formData.get('phone') as string,\n unit: formData.get('unit') as string,\n lease_start: formData.get('lease_start') as string,\n lease_end: formData.get('lease_end') as string,\n monthly_rent: parseFloat(formData.get('monthly_rent') as string),\n security_deposit: parseFloat(formData.get('security_deposit') as string) || 0\n };\n\n try {\n const response = await fetch('/api/payments/tenants', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(tenant)\n });\n\n if (response.ok) {\n setShowAddTenant(false);\n form.reset();\n fetchData();\n }\n } catch (error) {\n console.error('Error adding tenant:', error);\n }\n };\n\n const updatePaymentStatus = async (paymentId: number, status: string, paidDate?: string) => {\n try {\n const updates: any = { status };\n if (paidDate) updates.paid_date = paidDate;\n\n const response = await fetch(`/api/payments/${paymentId}`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(updates)\n });\n\n if (response.ok) {\n fetchData();\n }\n } catch (error) {\n console.error('Error updating payment:', error);\n }\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();\n };\n\n const getStatusBadge = (status: string) => {\n const statusClasses = {\n pending: 'status-pending',\n paid: 'status-paid',\n late: 'status-late',\n partial: 'status-partial'\n };\n return statusClasses[status as keyof typeof statusClasses] || 'status-pending';\n };\n\n if (loading) {\n return

Loading rent payments...

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

\n {/* Header */}\n

\n Rent Payments\n

\n Manage tenant payments and track rent collection\n

\n setShowAddTenant(true)}\n className=\"btn-secondary\"\n >\n 👤 Add Tenant\n \n setShowAddPayment(true)}\n className=\"btn-primary\"\n >\n 💳 Record Payment\n \n

\n\n {/* Tenants Summary */}\n

{tenants.length}

Total Tenants

\n {payments.filter(p => p.status === 'paid').length}\n

Payments Received

\n {payments.filter(p => p.status === 'pending' || p.status === 'late').length}\n

Pending Payments

\n\n {/* Payments Table */}\n

Recent Payments

\n \n \n \n \n \n \n \n \n \n \n \n \n {payments.map((payment) => (\n \n \n \n \n \n \n \n \n ))}\n \n

\n Tenant\n	\n Amount\n	\n Due Date\n	\n Paid Date\n	\n Status\n	\n Actions\n
\n {payment.tenant_name}\n	\n {formatCurrency(payment.amount)}\n	\n {formatDate(payment.due_date)}\n	\n {payment.paid_date ? formatDate(payment.paid_date) : '-'}\n	\n \n {payment.status}\n \n	\n {payment.status !== 'paid' && (\n updatePaymentStatus(payment.id, 'paid', new Date().toISOString().split('T')[0])}\n className=\"text-green-600 hover:text-green-900 mr-3\"\n >\n Mark Paid\n \n )}\n

\n\n {/* Add Payment Modal */}\n {showAddPayment && (\n

Record New Payment

\n Tenant\n \n

\n Amount\n \n

\n Due Date\n \n

\n Paid Date (optional)\n \n

\n Payment Method\n \n

\n Status\n \n

\n Notes\n \n

\n setShowAddPayment(false)}\n className=\"btn-secondary\"\n >\n Cancel\n \n \n

\n )}\n\n {/* Add Tenant Modal */}\n {showAddTenant && (\n

Add New Tenant

\n Name\n \n

\n Email\n \n

\n Phone\n \n

\n Unit\n \n

\n Lease Start\n \n

\n Lease End\n \n

\n Monthly Rent\n \n

\n Security Deposit\n \n

\n setShowAddTenant(false)}\n className=\"btn-secondary\"\n >\n Cancel\n \n \n

\n )}\n

\n );\n}",[],[18,90,263],"f4bb8a8c-3fac-11f0-a125-76b3cceeab13","Maintenance.tsx","f4bb8b68-3fac-11f0-a125-76b3cceeab13",15,["D",1748867252126],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { MaintenanceCost } from \"../../shared/types.ts\";\n\nexport default function Maintenance() {\n const [costs, setCosts] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showAddCost, setShowAddCost] = useState(false);\n\n const categories = [\n 'Plumbing',\n 'Electrical',\n 'HVAC',\n 'Appliances',\n 'Flooring',\n 'Painting',\n 'Landscaping',\n 'Cleaning',\n 'Security',\n 'General Repairs',\n 'Emergency',\n 'Other'\n ];\n\n useEffect(() => {\n fetchCosts();\n }, []);\n\n const fetchCosts = async () => {\n try {\n const response = await fetch('/api/maintenance');\n const data = await response.json();\n setCosts(data);\n } catch (error) {\n console.error('Error fetching maintenance costs:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleAddCost = async (e: React.FormEvent) => {\n e.preventDefault();\n const form = e.target as HTMLFormElement;\n const formData = new FormData(form);\n \n const cost = {\n description: formData.get('description') as string,\n category: formData.get('category') as string,\n amount: parseFloat(formData.get('amount') as string),\n date: formData.get('date') as string,\n vendor: formData.get('vendor') as string,\n unit: formData.get('unit') as string,\n receipt_url: formData.get('receipt_url') as string,\n tax_deductible: formData.get('tax_deductible') === 'on'\n };\n\n try {\n const response = await fetch('/api/maintenance', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(cost)\n });\n\n if (response.ok) {\n setShowAddCost(false);\n form.reset();\n fetchCosts();\n }\n } catch (error) {\n console.error('Error adding maintenance cost:', error);\n }\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();\n };\n\n const getTotalByCategory = () => {\n const totals: { [key: string]: number } = {};\n costs.forEach(cost => {\n totals[cost.category] = (totals[cost.category] || 0) + cost.amount;\n });\n return totals;\n };\n\n const totalCosts = costs.reduce((sum, cost) => sum + cost.amount, 0);\n const taxDeductibleTotal = costs.filter(cost => cost.tax_deductible).reduce((sum, cost) => sum + cost.amount, 0);\n const categoryTotals = getTotalByCategory();\n\n if (loading) {\n return

Loading maintenance costs...

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

\n {/* Header */}\n

\n Maintenance Costs\n

\n Track property maintenance expenses and repairs\n

\n setShowAddCost(true)}\n className=\"btn-primary\"\n >\n 🔧 Add Maintenance Cost\n \n

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

{formatCurrency(totalCosts)}

Total Maintenance Costs

{formatCurrency(taxDeductibleTotal)}

Tax Deductible

{costs.length}

Total Records

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

Costs by Category

\n {Object.entries(categoryTotals)\n .sort(([,a], [,b]) => b - a)\n .slice(0, 8)\n .map(([category, total]) => (\n

\n {category}\n {formatCurrency(total)}\n

\n ))}\n

\n\n

Recent Activity

\n {costs.slice(0, 5).map((cost) => (\n

{cost.description}

{cost.category} • {formatDate(cost.date)}

{formatCurrency(cost.amount)}

\n ))}\n

\n\n {/* Maintenance Costs Table */}\n

All Maintenance Records

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {costs.map((cost) => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

\n Description\n	\n Category\n	\n Amount\n	\n Date\n	\n Vendor\n	\n Unit\n	\n Tax Deductible\n
\n {cost.description} \n	\n \n {cost.category}\n \n	\n {formatCurrency(cost.amount)}\n	\n {formatDate(cost.date)}\n	\n {cost.vendor \|\| '-'}\n	\n {cost.unit \|\| 'All'}\n	\n {cost.tax_deductible ? (\n ✓ Yes\n ) : (\n ✗ No\n )}\n

\n\n {/* Add Maintenance Cost Modal */}\n {showAddCost && (\n

Add Maintenance Cost

\n Description\n \n

\n Category\n \n

\n Amount\n \n

\n Date\n \n

\n Vendor/Contractor\n \n

\n Unit (optional)\n \n

\n Receipt URL (optional)\n \n

\n \n \n Tax deductible expense\n \n

\n setShowAddCost(false)}\n className=\"btn-secondary\"\n >\n Cancel\n \n \n

\n )}\n

\n );\n}",[],[18,90,271],"b88e6e26-3fac-11f0-8fc3-76b3cceeab13","Dashboard.tsx","b88e6ef8-3fac-11f0-8fc3-76b3cceeab13",13,["D",1748867151166],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { FinancialSummary } from \"../../shared/types.ts\";\n\nexport default function Dashboard() {\n const [summary, setSummary] = useState(null);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n // Try to get initial data from window, otherwise fetch\n const initialData = (window as any).__INITIAL_DATA__;\n if (initialData) {\n setSummary(initialData);\n setLoading(false);\n } else {\n fetchSummary();\n }\n }, []);\n\n const fetchSummary = async () => {\n try {\n const response = await fetch('/api/taxes/summary');\n const data = await response.json();\n setSummary(data);\n } catch (error) {\n console.error('Error fetching financial summary:', error);\n } finally {\n setLoading(false);\n }\n };\n\n if (loading) {\n return (\n

Loading dashboard...

\n );\n }\n\n if (!summary) {\n return (\n

Error loading financial data

\n );\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 profitMargin = summary.total_rent_collected > 0 \n ? ((summary.net_income / summary.total_rent_collected) * 100).toFixed(1)\n : '0';\n\n return (\n

\n {/* Page Header */}\n

\n Financial Dashboard\n

\n Overview of your rental property finances\n

\n \n 🔄 Refresh Data\n \n

\n\n {/* Key Metrics Cards */}\n

\n {/* Total Rent Collected */}\n

💰

\n Total Rent Collected\n: \n {formatCurrency(summary.total_rent_collected)}\n

\n\n {/* Net Income */}\n

📈

\n Net Income\n: = 0 ? 'text-green-600' : 'text-red-600'}`}>\n {formatCurrency(summary.net_income)}\n

\n\n {/* Pending Rent */}\n

⏰

\n Pending Rent\n: \n {formatCurrency(summary.pending_rent)}\n

\n\n {/* Tax Deductions */}\n

📋

\n Tax Deductions\n: \n {formatCurrency(summary.tax_deductible_expenses)}\n

\n\n {/* Expense Breakdown */}\n

\n {/* Expenses Overview */}\n

Expense Breakdown

\n Maintenance Costs\n {formatCurrency(summary.total_maintenance_costs)}\n

\n Staff Payments\n {formatCurrency(summary.total_staff_payments)}\n

\n Total Expenses\n \n {formatCurrency(summary.total_maintenance_costs + summary.total_staff_payments)}\n \n

\n\n {/* Performance Metrics */}\n

Performance Metrics

\n Profit Margin\n = 0 ? 'text-green-600' : 'text-red-600'}`}>\n {profitMargin}%\n \n

\n Expense Ratio\n \n {summary.total_rent_collected > 0 \n ? (((summary.total_maintenance_costs + summary.total_staff_payments) / summary.total_rent_collected) * 100).toFixed(1)\n : '0'\n }%\n \n

\n Collection Rate\n \n {(summary.total_rent_collected + summary.pending_rent) > 0\n ? ((summary.total_rent_collected / (summary.total_rent_collected + summary.pending_rent)) * 100).toFixed(1)\n : '100'\n }%\n \n

\n\n {/* Quick Actions */}\n

Quick Actions

\n \n \n \n \n

\n );\n}",[],[18,90,279],"a2906200-3fac-11f0-8fc3-76b3cceeab13","App.tsx","a29062dc-3fac-11f0-8fc3-76b3cceeab13",["D",1748867114268],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport RentPayments from \"./RentPayments.tsx\";\nimport Maintenance from \"./Maintenance.tsx\";\nimport StaffPayments from \"./StaffPayments.tsx\";\nimport TaxReports from \"./TaxReports.tsx\";\n\ntype ActiveTab = 'dashboard' | 'rent' | 'maintenance' | 'staff' | 'taxes';\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState('dashboard');\n\n const tabs = [\n { id: 'dashboard', label: '📊 Dashboard', icon: '📊' },\n { id: 'rent', label: '🏠 Rent Payments', icon: '🏠' },\n { id: 'maintenance', label: '🔧 Maintenance', icon: '🔧' },\n { id: 'staff', label: '👥 Staff Payments', icon: '👥' },\n { id: 'taxes', label: '📋 Tax Reports', icon: '📋' }\n ];\n\n const renderContent = () => {\n switch (activeTab) {\n case 'dashboard':\n return ;\n case 'rent':\n return ;\n case 'maintenance':\n return ;\n case 'staff':\n return ;\n case 'taxes':\n return ;\n default:\n return ;\n }\n };\n\n return (\n

\n {/* Header */}\n

🏢 Property Manager

\n Rental Property Management System\n

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

\n {tabs.map((tab) => (\n setActiveTab(tab.id as ActiveTab)}\n className={`py-4 px-1 border-b-2 font-medium text-sm transition-colors ${\n activeTab === tab.id\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n {tab.label}\n \n ))}\n

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

\n {renderContent()}\n

\n );\n}",[],[18,90,287],["D",1748867114268],[207,208,209,210,211,212],[18,90],["D",1748867091716],[206,213,214],[18],"3cf4d538-3fad-11f0-a377-76b3cceeab13","index.ts","1b730b5d-cfd5-4777-ad8d-086d3833bce8",["D",1748867373293],"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 { getFinancialSummary } from \"./database/queries.ts\";\n\nimport payments from \"./routes/payments.ts\";\nimport maintenance from \"./routes/maintenance.ts\";\nimport staff from \"./routes/staff.ts\";\nimport taxes from \"./routes/taxes.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/payments\", payments);\napp.route(\"/api/maintenance\", maintenance);\napp.route(\"/api/staff\", staff);\napp.route(\"/api/taxes\", taxes);\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 page with initial data\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial financial summary to avoid extra round-trip\n const initialData = await getFinancialSummary();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\nexport default app.fetch;",[],[307,300],"backend","877ddfec-3fac-11f0-ab96-76b3cceeab13","taxes.ts","877de0be-3fac-11f0-ab96-76b3cceeab13","13363509-fb03-4247-828f-eb97b9946cda",8,["D",1748867068852],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getAllTaxCategories, \n getFinancialSummary, \n getMonthlyReports \n} from \"../database/queries.ts\";\n\nconst taxes = new Hono();\n\n// Get all tax categories\ntaxes.get(\"/categories\", async (c) => {\n try {\n const categories = await getAllTaxCategories();\n return c.json(categories);\n } catch (error) {\n console.error(\"Error fetching tax categories:\", error);\n return c.json({ error: \"Failed to fetch tax categories\" }, 500);\n }\n});\n\n// Get financial summary\ntaxes.get(\"/summary\", async (c) => {\n try {\n const summary = await getFinancialSummary();\n return c.json(summary);\n } catch (error) {\n console.error(\"Error fetching financial summary:\", error);\n return c.json({ error: \"Failed to fetch financial summary\" }, 500);\n }\n});\n\n// Get monthly reports\ntaxes.get(\"/reports/:year\", async (c) => {\n try {\n const year = parseInt(c.req.param(\"year\"));\n const reports = await getMonthlyReports(year);\n return c.json(reports);\n } catch (error) {\n console.error(\"Error fetching monthly reports:\", error);\n return c.json({ error: \"Failed to fetch monthly reports\" }, 500);\n }\n});\n\nexport default taxes;",[],[307,317,309],"routes","8322b4ea-3fac-11f0-9459-76b3cceeab13","staff.ts","8322b594-3fac-11f0-9459-76b3cceeab13",7,["D",1748867061541],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllStaffPayments, createStaffPayment } from \"../database/queries.ts\";\n\nconst staff = new Hono();\n\n// Get all staff payments\nstaff.get(\"/\", async (c) => {\n try {\n const payments = await getAllStaffPayments();\n return c.json(payments);\n } catch (error) {\n console.error(\"Error fetching staff payments:\", error);\n return c.json({ error: \"Failed to fetch staff payments\" }, 500);\n }\n});\n\n// Create new staff payment\nstaff.post(\"/\", async (c) => {\n try {\n const payment = await c.req.json();\n const id = await createStaffPayment(payment);\n return c.json({ id, message: \"Staff payment created successfully\" });\n } catch (error) {\n console.error(\"Error creating staff payment:\", error);\n return c.json({ error: \"Failed to create staff payment\" }, 500);\n }\n});\n\nexport default staff;",[],[307,317,319],"7c1e81ec-3fac-11f0-bc9d-76b3cceeab13","payments.ts","7c1e82d2-3fac-11f0-bc9d-76b3cceeab13",5,["D",1748867049768],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getAllRentPayments, \n createRentPayment, \n updateRentPayment,\n getAllTenants,\n createTenant\n} from \"../database/queries.ts\";\n\nconst payments = new Hono();\n\n// Get all rent payments\npayments.get(\"/\", async (c) => {\n try {\n const payments = await getAllRentPayments();\n return c.json(payments);\n } catch (error) {\n console.error(\"Error fetching rent payments:\", error);\n return c.json({ error: \"Failed to fetch rent payments\" }, 500);\n }\n});\n\n// Create new rent payment\npayments.post(\"/\", async (c) => {\n try {\n const payment = await c.req.json();\n const id = await createRentPayment(payment);\n return c.json({ id, message: \"Rent payment created successfully\" });\n } catch (error) {\n console.error(\"Error creating rent payment:\", error);\n return c.json({ error: \"Failed to create rent payment\" }, 500);\n }\n});\n\n// Update rent payment\npayments.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const updates = await c.req.json();\n await updateRentPayment(id, updates);\n return c.json({ message: \"Rent payment updated successfully\" });\n } catch (error) {\n console.error(\"Error updating rent payment:\", error);\n return c.json({ error: \"Failed to update rent payment\" }, 500);\n }\n});\n\n// Get all tenants\npayments.get(\"/tenants\", async (c) => {\n try {\n const tenants = await getAllTenants();\n return c.json(tenants);\n } catch (error) {\n console.error(\"Error fetching tenants:\", error);\n return c.json({ error: \"Failed to fetch tenants\" }, 500);\n }\n});\n\n// Create new tenant\npayments.post(\"/tenants\", async (c) => {\n try {\n const tenant = await c.req.json();\n const id = await createTenant(tenant);\n return c.json({ id, message: \"Tenant created successfully\" });\n } catch (error) {\n console.error(\"Error creating tenant:\", error);\n return c.json({ error: \"Failed to create tenant\" }, 500);\n }\n});\n\nexport default payments;",[],[307,317,327],"7fb7faae-3fac-11f0-9141-76b3cceeab13","maintenance.ts","7fb7fc7a-3fac-11f0-9141-76b3cceeab13",6,["D",1748867055809],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllMaintenanceCosts, createMaintenanceCost } from \"../database/queries.ts\";\n\nconst maintenance = new Hono();\n\n// Get all maintenance costs\nmaintenance.get(\"/\", async (c) => {\n try {\n const costs = await getAllMaintenanceCosts();\n return c.json(costs);\n } catch (error) {\n console.error(\"Error fetching maintenance costs:\", error);\n return c.json({ error: \"Failed to fetch maintenance costs\" }, 500);\n }\n});\n\n// Create new maintenance cost\nmaintenance.post(\"/\", async (c) => {\n try {\n const cost = await c.req.json();\n const id = await createMaintenanceCost(cost);\n return c.json({ id, message: \"Maintenance cost created successfully\" });\n } catch (error) {\n console.error(\"Error creating maintenance cost:\", error);\n return c.json({ error: \"Failed to create maintenance cost\" }, 500);\n }\n});\n\nexport default maintenance;",[],[307,317,335],"7c1e9254-3fac-11f0-bc9d-76b3cceeab13",["D",1748867049768],[200,201,202,203],[307,317],"75e2edb8-3fac-11f0-8185-76b3cceeab13","queries.ts","75e2ee58-3fac-11f0-8185-76b3cceeab13","e1d1b0f1-3887-4e65-a63a-f5f85db4535b",4,["D",1748867039315],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { \n Tenant, \n RentPayment, \n MaintenanceCost, \n StaffPayment, \n TaxCategory, \n FinancialSummary,\n MonthlyReport \n} from \"../../shared/types.ts\";\n\n// Tenant queries\nexport async function getAllTenants(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM tenants ORDER BY unit\");\n return result.rows as Tenant[];\n}\n\nexport async function createTenant(tenant: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO tenants (name, email, phone, unit, lease_start, lease_end, monthly_rent, security_deposit)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [tenant.name, tenant.email, tenant.phone, tenant.unit, tenant.lease_start, tenant.lease_end, tenant.monthly_rent, tenant.security_deposit]);\n return result.lastInsertRowId as number;\n}\n\n// Rent payment queries\nexport async function getAllRentPayments(): Promise {\n const result = await sqlite.execute(`\n SELECT rp.*, t.name as tenant_name \n FROM rent_payments rp \n JOIN tenants t ON rp.tenant_id = t.id \n ORDER BY rp.due_date DESC\n `);\n return result.rows as RentPayment[];\n}\n\nexport async function createRentPayment(payment: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO rent_payments (tenant_id, amount, due_date, paid_date, payment_method, notes, status)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [payment.tenant_id, payment.amount, payment.due_date, payment.paid_date, payment.payment_method, payment.notes, payment.status]);\n return result.lastInsertRowId as number;\n}\n\nexport async function updateRentPayment(id: number, updates: Partial): Promise {\n const fields = Object.keys(updates).filter(key => key !== 'id' && key !== 'created_at' && key !== 'tenant_name');\n const setClause = fields.map(field => `${field} = ?`).join(', ');\n const values = fields.map(field => updates[field as keyof RentPayment]);\n \n await sqlite.execute(`UPDATE rent_payments SET ${setClause} WHERE id = ?`, [...values, id]);\n}\n\n// Maintenance cost queries\nexport async function getAllMaintenanceCosts(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM maintenance_costs ORDER BY date DESC\");\n return result.rows as MaintenanceCost[];\n}\n\nexport async function createMaintenanceCost(cost: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO maintenance_costs (description, category, amount, date, vendor, unit, receipt_url, tax_deductible)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [cost.description, cost.category, cost.amount, cost.date, cost.vendor, cost.unit, cost.receipt_url, cost.tax_deductible]);\n return result.lastInsertRowId as number;\n}\n\n// Staff payment queries\nexport async function getAllStaffPayments(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM staff_payments ORDER BY payment_date DESC\");\n return result.rows as StaffPayment[];\n}\n\nexport async function createStaffPayment(payment: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO staff_payments (staff_name, role, amount, payment_date, payment_type, hours_worked, hourly_rate, description, tax_form_type)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [payment.staff_name, payment.role, payment.amount, payment.payment_date, payment.payment_type, payment.hours_worked, payment.hourly_rate, payment.description, payment.tax_form_type]);\n return result.lastInsertRowId as number;\n}\n\n// Tax category queries\nexport async function getAllTaxCategories(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM tax_categories ORDER BY name\");\n return result.rows as TaxCategory[];\n}\n\n// Financial summary queries\nexport async function getFinancialSummary(): Promise {\n const [rentResult, maintenanceResult, staffResult, pendingResult, taxResult] = await Promise.all([\n sqlite.execute(\"SELECT COALESCE(SUM(amount), 0) as total FROM rent_payments WHERE status = 'paid'\"),\n sqlite.execute(\"SELECT COALESCE(SUM(amount), 0) as total FROM maintenance_costs\"),\n sqlite.execute(\"SELECT COALESCE(SUM(amount), 0) as total FROM staff_payments\"),\n sqlite.execute(\"SELECT COALESCE(SUM(amount), 0) as total FROM rent_payments WHERE status IN ('pending', 'late')\"),\n sqlite.execute(\"SELECT COALESCE(SUM(amount), 0) as total FROM maintenance_costs WHERE tax_deductible = 1\")\n ]);\n\n const totalRentCollected = (rentResult.rows[0] as any).total;\n const totalMaintenanceCosts = (maintenanceResult.rows[0] as any).total;\n const totalStaffPayments = (staffResult.rows[0] as any).total;\n const pendingRent = (pendingResult.rows[0] as any).total;\n const taxDeductibleExpenses = (taxResult.rows[0] as any).total + totalStaffPayments;\n\n return {\n total_rent_collected: totalRentCollected,\n total_maintenance_costs: totalMaintenanceCosts,\n total_staff_payments: totalStaffPayments,\n net_income: totalRentCollected - totalMaintenanceCosts - totalStaffPayments,\n tax_deductible_expenses: taxDeductibleExpenses,\n pending_rent: pendingRent\n };\n}\n\n// Monthly report queries\nexport async function getMonthlyReports(year: number): Promise {\n const result = await sqlite.execute(`\n WITH months AS (\n SELECT 1 as month UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION \n SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION \n SELECT 9 UNION SELECT 10 UNION SELECT 11 UNION SELECT 12\n ),\n rent_income AS (\n SELECT \n strftime('%m', paid_date) as month,\n COALESCE(SUM(amount), 0) as income\n FROM rent_payments \n WHERE strftime('%Y', paid_date) = ? AND status = 'paid'\n GROUP BY strftime('%m', paid_date)\n ),\n maintenance_expenses AS (\n SELECT \n strftime('%m', date) as month,\n COALESCE(SUM(amount), 0) as expenses\n FROM maintenance_costs \n WHERE strftime('%Y', date) = ?\n GROUP BY strftime('%m', date)\n ),\n staff_expenses AS (\n SELECT \n strftime('%m', payment_date) as month,\n COALESCE(SUM(amount), 0) as expenses\n FROM staff_payments \n WHERE strftime('%Y', payment_date) = ?\n GROUP BY strftime('%m', payment_date)\n ),\n tax_deductions AS (\n SELECT \n strftime('%m', date) as month,\n COALESCE(SUM(amount), 0) as deductions\n FROM maintenance_costs \n WHERE strftime('%Y', date) = ? AND tax_deductible = 1\n GROUP BY strftime('%m', date)\n )\n SELECT \n printf('%02d', m.month) as month,\n ? as year,\n COALESCE(ri.income, 0) as rent_income,\n COALESCE(me.expenses, 0) as maintenance_expenses,\n COALESCE(se.expenses, 0) as staff_expenses,\n COALESCE(ri.income, 0) - COALESCE(me.expenses, 0) - COALESCE(se.expenses, 0) as net_profit,\n COALESCE(td.deductions, 0) + COALESCE(se.expenses, 0) as tax_deductions\n FROM months m\n LEFT JOIN rent_income ri ON printf('%02d', m.month) = ri.month\n LEFT JOIN maintenance_expenses me ON printf('%02d', m.month) = me.month\n LEFT JOIN staff_expenses se ON printf('%02d', m.month) = se.month\n LEFT JOIN tax_deductions td ON printf('%02d', m.month) = td.month\n ORDER BY m.month\n `, [year.toString(), year.toString(), year.toString(), year.toString(), year]);\n\n return result.rows as MonthlyReport[];\n}",[],[307,355,347],"database","63b0cab6-3fac-11f0-be38-76b3cceeab13","migrations.ts","63b0cc6e-3fac-11f0-be38-76b3cceeab13",3,["D",1748867008786],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function runMigrations() {\n console.log(\"Running database migrations...\");\n\n // Tenants table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS tenants (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n phone TEXT,\n unit TEXT NOT NULL,\n lease_start DATE NOT NULL,\n lease_end DATE NOT NULL,\n monthly_rent DECIMAL(10,2) NOT NULL,\n security_deposit DECIMAL(10,2) DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Rent payments table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS rent_payments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n tenant_id INTEGER NOT NULL,\n amount DECIMAL(10,2) NOT NULL,\n due_date DATE NOT NULL,\n paid_date DATE,\n payment_method TEXT DEFAULT 'check',\n notes TEXT,\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'paid', 'late', 'partial')),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (tenant_id) REFERENCES tenants(id)\n )\n `);\n\n // Maintenance costs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS maintenance_costs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n description TEXT NOT NULL,\n category TEXT NOT NULL,\n amount DECIMAL(10,2) NOT NULL,\n date DATE NOT NULL,\n vendor TEXT,\n unit TEXT,\n receipt_url TEXT,\n tax_deductible BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Staff payments table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS staff_payments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n staff_name TEXT NOT NULL,\n role TEXT NOT NULL,\n amount DECIMAL(10,2) NOT NULL,\n payment_date DATE NOT NULL,\n payment_type TEXT DEFAULT 'fixed' CHECK (payment_type IN ('hourly', 'fixed', 'commission')),\n hours_worked DECIMAL(5,2),\n hourly_rate DECIMAL(10,2),\n description TEXT,\n tax_form_type TEXT DEFAULT '1099',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Tax categories table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS tax_categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT UNIQUE NOT NULL,\n description TEXT,\n deductible_percentage DECIMAL(5,2) DEFAULT 100.00\n )\n `);\n\n // Insert default tax categories\n await sqlite.execute(`\n INSERT OR IGNORE INTO tax_categories (name, description, deductible_percentage) VALUES\n ('Repairs & Maintenance', 'Property repairs and maintenance costs', 100.00),\n ('Property Management', 'Property management fees and services', 100.00),\n ('Insurance', 'Property insurance premiums', 100.00),\n ('Utilities', 'Utilities paid by landlord', 100.00),\n ('Advertising', 'Costs to advertise rental property', 100.00),\n ('Legal & Professional', 'Legal and professional service fees', 100.00),\n ('Depreciation', 'Property depreciation expenses', 100.00),\n ('Travel', 'Travel expenses for property management', 100.00)\n `);\n\n console.log(\"Database migrations completed successfully!\");\n}",[],[307,355,357],"63b0d740-3fac-11f0-be38-76b3cceeab13",["D",1748867008786],[197,198],[307,355],"63b0d5b0-3fac-11f0-be38-76b3cceeab13",["D",1748867008786],[196,199,204],[307],["D",1748866829842],{"_11":12,"_141":71},{"_11":12,"_137":-5,"_70":71,"_31":69,"_138":139,"_140":30},{"_41":128,"_13":16,"_35":38,"_129":94,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":14,"_136":12},"ctx",{"_54":-5,"_160":409,"_410":411,"_412":413,"_414":30,"_415":30,"_416":30,"_417":24,"_418":-5,"_419":-7,"_420":-7,"_421":26,"_422":30,"_423":30,"_424":-5,"_425":30,"_426":30,"_427":30,"_428":-5},"ENV",{"_380":381,"_382":383,"_384":16,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408},"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 · frontend