CashStash - Gen Z Budgeting App

\n \n \n \n\n",[],[147,200],["D",1747495675266],[176,177],[147],"79f1d8d6-3333-11f0-9159-9e149126039e","index.ts",6,["D",1747495663069],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { setupDatabase } from \"./database/migrations.ts\";\nimport { \n createUser, \n getUserById, \n createEnvelope, \n updateEnvelopeAmount,\n addTransactions,\n assignTransactionToEnvelope,\n checkFullAllocation\n} from \"./database/queries.ts\";\nimport { parseCSV } from \"./parsers/csv-parser.ts\";\nimport type { CSVMapping } from \"../shared/types.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// Enable CORS\napp.use(\"/*\", cors());\n\n// Initialize database on startup\napp.use(\"*\", async (c, next) => {\n await setupDatabase();\n await next();\n});\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 index.html for root path\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// API Routes\nconst api = new Hono();\n\n// User endpoints\napi.post(\"/users\", async c => {\n const { name } = await c.req.json();\n \n if (!name) {\n return c.json({ error: \"Name is required\" }, 400);\n }\n \n const user = await createUser(name);\n return c.json(user);\n});\n\napi.get(\"/users/:id\", async c => {\n const userId = c.req.param(\"id\");\n const user = await getUserById(userId);\n \n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n return c.json(user);\n});\n\n// Envelope endpoints\napi.post(\"/users/:userId/envelopes\", async c => {\n const userId = c.req.param(\"userId\");\n const { name, icon, color, budget } = await c.req.json();\n \n if (!name || !icon || !color) {\n return c.json({ error: \"Name, icon, and color are required\" }, 400);\n }\n \n const envelope = await createEnvelope(userId, name, icon, color, budget || 0);\n return c.json(envelope);\n});\n\napi.put(\"/users/:userId/envelopes/:envelopeId/allocate\", async c => {\n const userId = c.req.param(\"userId\");\n const envelopeId = c.req.param(\"envelopeId\");\n const { amount } = await c.req.json();\n \n if (typeof amount !== \"number\") {\n return c.json({ error: \"Amount must be a number\" }, 400);\n }\n \n const user = await getUserById(userId);\n \n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n const envelope = user.envelopes.find(e => e.id === envelopeId);\n \n if (!envelope) {\n return c.json({ error: \"Envelope not found\" }, 404);\n }\n \n // Calculate new amounts\n const newEnvelopeAmount = envelope.current + amount;\n const newUnallocated = user.unallocated - amount;\n \n if (newUnallocated < 0) {\n return c.json({ error: \"Not enough unallocated funds\" }, 400);\n }\n \n // Update envelope amount\n await updateEnvelopeAmount(envelopeId, newEnvelopeAmount);\n \n // Update user's unallocated amount\n await updateUserBalance(userId, user.totalBalance, newUnallocated);\n \n // Check if all money is now allocated\n await checkFullAllocation(userId);\n \n // Get updated user data\n const updatedUser = await getUserById(userId);\n return c.json(updatedUser);\n});\n\n// Transaction endpoints\napi.post(\"/users/:userId/transactions/import\", async c => {\n const userId = c.req.param(\"userId\");\n const { csvContent, mapping } = await c.req.json();\n \n if (!csvContent || !mapping) {\n return c.json({ error: \"CSV content and mapping are required\" }, 400);\n }\n \n const parseResult = parseCSV(csvContent, mapping as CSVMapping);\n \n if (!parseResult.success) {\n return c.json({ error: parseResult.error }, 400);\n }\n \n const transactions = await addTransactions(userId, parseResult.transactions!);\n \n // Get updated user data\n const updatedUser = await getUserById(userId);\n return c.json({\n transactions,\n user: updatedUser\n });\n});\n\napi.put(\"/users/:userId/transactions/:transactionId/assign\", async c => {\n const userId = c.req.param(\"userId\");\n const transactionId = c.req.param(\"transactionId\");\n const { envelopeId } = await c.req.json();\n \n if (!envelopeId) {\n return c.json({ error: \"Envelope ID is required\" }, 400);\n }\n \n await assignTransactionToEnvelope(transactionId, envelopeId);\n \n // Get updated user data\n const updatedUser = await getUserById(userId);\n return c.json(updatedUser);\n});\n\n// Mount API routes\napp.route(\"/api\", api);\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[153,210],"6c6a77a4-3333-11f0-bdd9-9e149126039e","csv-parser.ts","6c6a789e-3333-11f0-bdd9-9e149126039e","ec6a724f-8379-4725-a91f-7b9a0aa137a8",5,["D",1747495640370],"import type { Transaction, CSVMapping, CSVParseResult } from \"../../shared/types.ts\";\n\n/**\n * Parse a CSV bank statement into transactions\n * \n * @param csvContent The raw CSV content as a string\n * @param mapping Configuration for mapping CSV columns to transaction fields\n * @returns Parsed transactions or error\n */\nexport function parseCSV(csvContent: string, mapping: CSVMapping): CSVParseResult {\n try {\n // Split the CSV into lines\n const lines = csvContent.split(/\\r?\\n/).filter(line => line.trim() !== \"\");\n \n if (lines.length < 2) {\n return { \n success: false, \n error: \"CSV file must contain a header row and at least one data row\" \n };\n }\n \n // Extract header row and find column indices\n const headers = parseCSVRow(lines[0]);\n const dateIndex = headers.indexOf(mapping.date);\n const descriptionIndex = headers.indexOf(mapping.description);\n const amountIndex = headers.indexOf(mapping.amount);\n const typeIndex = mapping.type ? headers.indexOf(mapping.type) : -1;\n \n // Validate required columns exist\n if (dateIndex === -1 || descriptionIndex === -1 || amountIndex === -1) {\n return { \n success: false, \n error: \"Required columns not found in CSV. Please check your mapping configuration.\" \n };\n }\n \n // Parse data rows\n const transactions: Transaction[] = [];\n \n for (let i = 1; i < lines.length; i++) {\n const row = parseCSVRow(lines[i]);\n \n if (row.length <= Math.max(dateIndex, descriptionIndex, amountIndex)) {\n continue; // Skip rows that don't have enough columns\n }\n \n let amount = parseFloat(row[amountIndex].replace(/[^\\d.-]/g, \"\"));\n \n // Handle debit/credit indicator if present\n if (typeIndex !== -1) {\n const type = row[typeIndex].toLowerCase();\n if (type.includes(\"debit\") || type.includes(\"withdrawal\") || type.includes(\"payment\")) {\n amount = -Math.abs(amount);\n }\n }\n \n // Skip rows with invalid amounts\n if (isNaN(amount)) {\n continue;\n }\n \n transactions.push({\n id: crypto.randomUUID(),\n date: formatDate(row[dateIndex]),\n description: row[descriptionIndex],\n amount,\n processed: false\n });\n }\n \n if (transactions.length === 0) {\n return { \n success: false, \n error: \"No valid transactions found in the CSV file\" \n };\n }\n \n return {\n success: true,\n transactions\n };\n \n } catch (error) {\n return {\n success: false,\n error: `Failed to parse CSV: ${error.message}`\n };\n }\n}\n\n/**\n * Parse a CSV row into an array of values, handling quoted values correctly\n */\nfunction parseCSVRow(row: string): string[] {\n const result: string[] = [];\n let current = \"\";\n let inQuotes = false;\n \n for (let i = 0; i < row.length; i++) {\n const char = row[i];\n \n if (char === '\"') {\n // Toggle quote state\n inQuotes = !inQuotes;\n } else if (char === ',' && !inQuotes) {\n // End of field\n result.push(current);\n current = \"\";\n } else {\n current += char;\n }\n }\n \n // Add the last field\n result.push(current);\n \n return result;\n}\n\n/**\n * Try to format a date string into a consistent format (YYYY-MM-DD)\n */\nfunction formatDate(dateStr: string): string {\n // Try to parse the date\n const date = new Date(dateStr);\n \n if (!isNaN(date.getTime())) {\n return date.toISOString().split('T')[0];\n }\n \n // If standard parsing fails, try common formats\n // MM/DD/YYYY\n const mmddyyyy = /(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})/.exec(dateStr);\n if (mmddyyyy) {\n const [_, month, day, year] = mmddyyyy;\n return `${year}-${month.padStart(2, '0')}-${day.padStart(2, '0')}`;\n }\n \n // DD/MM/YYYY\n const ddmmyyyy = /(\\d{1,2})\\/(\\d{1,2})\\/(\\d{4})/.exec(dateStr);\n if (ddmmyyyy) {\n const [_, day, month, year] = ddmmyyyy;\n return `${year}-${month.padStart(2, '0')}-${day.padStart(2, '0')}`;\n }\n \n // Return original if we can't parse it\n return dateStr;\n}",[],[153,225,217],"parsers","6c6a8ba4-3333-11f0-bdd9-9e149126039e",["D",1747495640370],[173],[153,225],"6156eb54-3333-11f0-9159-9e149126039e","queries.ts","6156ec1c-3333-11f0-9159-9e149126039e","46d8a173-1fde-43f0-a791-9483ac3b7f95",4,["D",1747495621787],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { \n USERS_TABLE, \n ENVELOPES_TABLE, \n TRANSACTIONS_TABLE, \n ACHIEVEMENTS_TABLE \n} from \"./migrations.ts\";\nimport type { User, Envelope, Transaction, Achievement } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(name: string): Promise {\n const userId = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, name, total_balance, unallocated) VALUES (?, ?, 0, 0)`,\n [userId, name]\n );\n \n // Create default achievements for the user\n const defaultAchievements = [\n {\n id: \"first_budget\",\n name: \"Budget Beginner\",\n description: \"Created your first budget envelope\",\n icon: \"🏆\"\n },\n {\n id: \"full_allocation\",\n name: \"Money Master\",\n description: \"Allocated 100% of your money to envelopes\",\n icon: \"💰\"\n },\n {\n id: \"saving_streak\",\n name: \"Saving Superstar\",\n description: \"Saved money for 3 weeks in a row\",\n icon: \"⭐\"\n },\n {\n id: \"csv_import\",\n name: \"Data Wizard\",\n description: \"Successfully imported your first bank statement\",\n icon: \"📊\"\n }\n ];\n \n for (const achievement of defaultAchievements) {\n await sqlite.execute(\n `INSERT INTO ${ACHIEVEMENTS_TABLE} (id, user_id, name, description, icon, unlocked) \n VALUES (?, ?, ?, ?, ?, 0)`,\n [achievement.id, userId, achievement.name, achievement.description, achievement.icon]\n );\n }\n \n return getUserById(userId);\n}\n\nexport async function getUserById(userId: string): Promise {\n const userResult = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE id = ?`,\n [userId]\n );\n \n if (userResult.rows.length === 0) {\n return null;\n }\n \n const user = userResult.rows[0];\n \n // Get envelopes\n const envelopes = await getEnvelopesByUserId(userId);\n \n // Get transactions\n const transactions = await getTransactionsByUserId(userId);\n \n // Get achievements\n const achievements = await getAchievementsByUserId(userId);\n \n return {\n id: user.id,\n name: user.name,\n totalBalance: user.total_balance,\n unallocated: user.unallocated,\n envelopes,\n transactions,\n achievements\n };\n}\n\nexport async function updateUserBalance(userId: string, totalBalance: number, unallocated: number): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET total_balance = ?, unallocated = ? WHERE id = ?`,\n [totalBalance, unallocated, userId]\n );\n}\n\n// Envelope queries\nexport async function createEnvelope(\n userId: string, \n name: string, \n icon: string, \n color: string, \n budget: number = 0\n): Promise {\n const envelopeId = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${ENVELOPES_TABLE} (id, user_id, name, icon, color, budget, current) \n VALUES (?, ?, ?, ?, ?, ?, 0)`,\n [envelopeId, userId, name, icon, color, budget]\n );\n \n // Check for first budget achievement\n await checkAndUnlockAchievement(userId, \"first_budget\");\n \n return {\n id: envelopeId,\n name,\n icon,\n color,\n budget,\n current: 0\n };\n}\n\nexport async function getEnvelopesByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ENVELOPES_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n name: row.name,\n icon: row.icon,\n color: row.color,\n budget: row.budget,\n current: row.current\n }));\n}\n\nexport async function updateEnvelopeAmount(envelopeId: string, amount: number): Promise {\n await sqlite.execute(\n `UPDATE ${ENVELOPES_TABLE} SET current = ? WHERE id = ?`,\n [amount, envelopeId]\n );\n}\n\n// Transaction queries\nexport async function addTransactions(\n userId: string, \n transactions: Omit[]\n): Promise {\n const createdTransactions: Transaction[] = [];\n \n for (const transaction of transactions) {\n const transactionId = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS_TABLE} (id, user_id, date, description, amount, category, processed) \n VALUES (?, ?, ?, ?, ?, ?, 0)`,\n [transactionId, userId, transaction.date, transaction.description, transaction.amount, transaction.category || null]\n );\n \n createdTransactions.push({\n id: transactionId,\n date: transaction.date,\n description: transaction.description,\n amount: transaction.amount,\n category: transaction.category,\n processed: false\n });\n }\n \n // Check for CSV import achievement\n if (createdTransactions.length > 0) {\n await checkAndUnlockAchievement(userId, \"csv_import\");\n }\n \n // Update user's total balance\n const totalAmount = transactions.reduce((sum, t) => sum + t.amount, 0);\n const user = await getUserById(userId);\n \n if (user) {\n const newTotal = user.totalBalance + totalAmount;\n const newUnallocated = user.unallocated + totalAmount;\n await updateUserBalance(userId, newTotal, newUnallocated);\n }\n \n return createdTransactions;\n}\n\nexport async function getTransactionsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS_TABLE} WHERE user_id = ? ORDER BY date DESC`,\n [userId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n date: row.date,\n description: row.description,\n amount: row.amount,\n category: row.category,\n processed: Boolean(row.processed)\n }));\n}\n\nexport async function assignTransactionToEnvelope(\n transactionId: string, \n envelopeId: string\n): Promise {\n await sqlite.execute(\n `UPDATE ${TRANSACTIONS_TABLE} SET envelope_id = ?, processed = 1 WHERE id = ?`,\n [envelopeId, transactionId]\n );\n}\n\n// Achievement queries\nexport async function getAchievementsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ACHIEVEMENTS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n icon: row.icon,\n unlocked: Boolean(row.unlocked),\n unlockedDate: row.unlocked_date\n }));\n}\n\nexport async function checkAndUnlockAchievement(userId: string, achievementId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ACHIEVEMENTS_TABLE} WHERE user_id = ? AND id = ?`,\n [userId, achievementId]\n );\n \n if (result.rows.length === 0 || result.rows[0].unlocked) {\n return false;\n }\n \n await sqlite.execute(\n `UPDATE ${ACHIEVEMENTS_TABLE} SET unlocked = 1, unlocked_date = CURRENT_TIMESTAMP WHERE user_id = ? AND id = ?`,\n [userId, achievementId]\n );\n \n return true;\n}\n\n// Check if all money is allocated (for achievement)\nexport async function checkFullAllocation(userId: string): Promise {\n const user = await getUserById(userId);\n \n if (user && user.unallocated === 0 && user.totalBalance > 0) {\n await checkAndUnlockAchievement(userId, \"full_allocation\");\n }\n}",[],[153,239,231],"database","50baf5f6-3333-11f0-bd48-9e149126039e","migrations.ts","50baf6be-3333-11f0-bd48-9e149126039e",["D",1747495593922],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const USERS_TABLE = \"cash_stash_users\";\nexport const ENVELOPES_TABLE = \"cash_stash_envelopes\";\nexport const TRANSACTIONS_TABLE = \"cash_stash_transactions\";\nexport const ACHIEVEMENTS_TABLE = \"cash_stash_achievements\";\n\nexport async function setupDatabase() {\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n total_balance REAL DEFAULT 0,\n unallocated REAL DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create envelopes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ENVELOPES_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n icon TEXT NOT NULL,\n color TEXT NOT NULL,\n budget REAL DEFAULT 0,\n current REAL DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Create transactions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TRANSACTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n date TEXT NOT NULL,\n description TEXT NOT NULL,\n amount REAL NOT NULL,\n category TEXT,\n envelope_id TEXT,\n processed INTEGER DEFAULT 0,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id),\n FOREIGN KEY (envelope_id) REFERENCES ${ENVELOPES_TABLE}(id)\n )\n `);\n\n // Create achievements table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ACHIEVEMENTS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n icon TEXT NOT NULL,\n unlocked INTEGER DEFAULT 0,\n unlocked_date TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Create default achievements\n await createDefaultAchievements();\n}\n\nasync function createDefaultAchievements() {\n const defaultAchievements = [\n {\n id: \"first_budget\",\n name: \"Budget Beginner\",\n description: \"Created your first budget envelope\",\n icon: \"🏆\"\n },\n {\n id: \"full_allocation\",\n name: \"Money Master\",\n description: \"Allocated 100% of your money to envelopes\",\n icon: \"💰\"\n },\n {\n id: \"saving_streak\",\n name: \"Saving Superstar\",\n description: \"Saved money for 3 weeks in a row\",\n icon: \"⭐\"\n },\n {\n id: \"csv_import\",\n name: \"Data Wizard\",\n description: \"Successfully imported your first bank statement\",\n icon: \"📊\"\n }\n ];\n \n // We don't insert these directly as they need to be associated with users\n // They'll be created when a new user is created\n}",[],[153,239,241],"50bb03ac-3333-11f0-bd48-9e149126039e",["D",1747495593922],[170,171],[153,239],["D",1747495593922],[169,172,174],[153],["D",1747495480497],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":291,"_292":293,"_294":295,"_296":24,"_297":24,"_298":24,"_299":57,"_300":-5,"_301":-7,"_302":-7,"_303":61,"_304":24,"_305":24,"_306":-5,"_307":24,"_308":24,"_309":24,"_310":-5},"ENV",{"_262":263,"_264":265,"_266":85,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290},"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"]

Diff · v8