💰 Expense Tracker

Total Expenses: ${totalExpenses.toFixed(2)}

\n\n

\n \n\n

Category Breakdown

\n {Object.entries(categoryTotals).map(([cat, total]) => (\n

\n {cat}\n ${total.toFixed(2)}\n

\n ))}\n

\n\n

Expense History

\n {expenses.map((expense, index) => (\n

\n {expense.description}\n ${expense.amount.toFixed(2)}\n {expense.category}\n

\n ))}\n

\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"carSellingWebsite\";\n const SCHEMA_VERSION = 3;\n\n // Ensure table exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_expenses_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n description TEXT NOT NULL,\n amount REAL NOT NULL,\n category TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle routes\n if (request.method === 'GET' && new URL(request.url).pathname === '/expenses') {\n const expenses = await sqlite.execute(`\n SELECT description, amount, category \n FROM ${KEY}_expenses_${SCHEMA_VERSION} \n ORDER BY created_at DESC \n LIMIT 50\n `);\n return new Response(JSON.stringify(expenses.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.method === 'POST' && new URL(request.url).pathname === '/add-expense') {\n const { description, amount, category } = await request.json();\n \n await sqlite.execute(`\n INSERT INTO ${KEY}_expenses_${SCHEMA_VERSION} \n (description, amount, category) \n VALUES (?, ?, ?)\n `, [description, amount, category]);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Serve HTML\n return new Response(`\n \n \n Expense Tracker\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" },\n });\n}\n\nconst css = `\nbody {\n font-family: system-ui, sans-serif;\n margin: 0;\n padding: 0;\n background-color: #f4f4f4;\n line-height: 1.6;\n}\n\n.expense-tracker {\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n}\n\nheader {\n text-align: center;\n background-color: #007bff;\n color: white;\n padding: 15px;\n border-radius: 5px;\n}\n\n.expense-container {\n display: grid;\n grid-template-columns: 1fr 1fr;\n gap: 20px;\n margin-top: 20px;\n}\n\n.expense-form {\n display: flex;\n flex-direction: column;\n gap: 10px;\n background-color: white;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\n\n.expense-form input,\n.expense-form select {\n padding: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n}\n\n.expense-form button {\n background-color: #28a745;\n color: white;\n border: none;\n padding: 10px;\n border-radius: 4px;\n cursor: pointer;\n}\n\n.category-breakdown,\n.expense-list {\n background-color: white;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\n\n.category-item,\n.expense-item {\n display: flex;\n justify-content: space-between;\n padding: 10px 0;\n border-bottom: 1px solid #f1f1f1;\n}\n\nfooter {\n text-align: center;\n margin-top: 20px;\n color: #666;\n}\n\n@media (max-width: 600px) {\n .expense-container {\n grid-template-columns: 1fr;\n }\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/trivediayush/carSellingWebsite/code/main.tsx","extension","actionData","errors"]