[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_410":411,"_412":413},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_305":-5,"_20":306,"_22":307,"_308":309,"_310":311,"_26":312,"_24":313,"_314":-5,"_315":-5,"_316":55,"_317":318,"_319":46,"_320":-5,"_321":-5,"_322":323},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","pmaxx","name","untitled-8939","branchName","main","version","path","backend/parsers","project",{"_34":252,"_13":14,"_47":253,"_254":-5,"_255":55,"_256":257,"_258":257,"_259":-5,"_260":-5,"_261":262,"_263":215,"_264":46,"_265":46,"_266":-5,"_267":49,"_268":269,"_270":-5,"_271":-5,"_272":-5,"_273":-5,"_274":275,"_276":275,"_277":278,"_279":278,"_280":278,"_281":275,"_282":275,"_283":284,"_285":286,"_287":288,"_289":55},"tree",[65,66,67,68],"file",{"_34":60,"_41":42,"_37":40,"_13":59,"_52":-5,"_50":61,"_17":49,"_39":62,"_47":63,"_43":44,"_56":-5,"_18":64},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","6c6a77a4-3333-11f0-bdd9-9e149126039e","csv-parser.ts","fileId","6c6a789e-3333-11f0-bdd9-9e149126039e","parentId","ec6a724f-8379-4725-a91f-7b9a0aa137a8","branchId","0d1fb8ae-3333-11f0-9f41-9e149126039e","branchVersion",5,"latest",true,"createdAt",["D",1747495640370],0,"fileType","script","content","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}","deleted",false,"label",[58,59,36],"backend","parsers","6c6a8ba4-3333-11f0-bdd9-9e149126039e","directory","528cc487-fcec-4277-b618-4026997f6154",["D",1747495640370],[58,59],{"_34":205,"_13":58,"_37":62,"_39":-5,"_41":42,"_43":206,"_45":46,"_47":207,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":208,"_18":209},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":98,"_18":99},{"_34":78,"_13":79,"_37":80,"_39":-5,"_41":42,"_43":81,"_45":46,"_47":82,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":83,"_18":84},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":49,"_50":24,"_52":74,"_54":55,"_56":-5,"_75":76,"_18":77},"4599a884-3333-11f0-ace2-9e149126039e","README.md","4599a94c-3333-11f0-ace2-9e149126039e",1,["D",1747495575248],"# CashStash - Gen Z Cash Stuffing Budget App\n\nA modern, animated budgeting app that makes financial management fun through a digital \"cash stuffing\" approach.\n\n## What is Cash Stuffing?\n\nCash stuffing is a budgeting method where you allocate your income into different categories (envelopes) to control spending. CashStash brings this concept to digital life with animations and game-like elements.\n\n## Features\n\n- 💸 **CSV Bank Import**: Upload your bank statements to automatically import transactions\n- 🎮 **Game-like Interface**: Drag and drop money into different envelopes\n- ✨ **Animated Feedback**: Visual rewards when you save money or stick to your budget\n- 📊 **Budget Tracking**: See where your money is going with intuitive visualizations\n- 🏆 **Achievement System**: Earn badges and rewards for good financial habits\n\n## Tech Stack\n\n- Frontend: React with animations\n- Backend: TypeScript with SQLite storage\n- Data: CSV parsing for bank statements\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/ # SQLite database setup and queries\n│ ├── parsers/ # CSV parsing logic\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/ # React components\n│ ├── animations/ # Animation utilities\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. Upload a CSV bank statement\n2. Create your budget envelopes\n3. Start stuffing cash into your envelopes\n4. Track your spending and saving progress","children",[],[70],"492bd616-3333-11f0-9a57-9e149126039e","shared","556b8a7e-5d01-45eb-a89a-71bd78dd1081",2,["D",1747495581239],[85],[79],{"_34":86,"_13":87,"_37":88,"_39":80,"_41":42,"_43":81,"_45":46,"_47":89,"_17":49,"_50":51,"_52":90,"_54":55,"_56":-5,"_75":91,"_18":92},"492bcfe0-3333-11f0-9a57-9e149126039e","types.ts","492bd09e-3333-11f0-9a57-9e149126039e",["D",1747495581239],"// Shared types for both frontend and backend\n\nexport interface Transaction {\n id: string;\n date: string;\n description: string;\n amount: number;\n category?: string;\n processed: boolean;\n}\n\nexport interface Envelope {\n id: string;\n name: string;\n icon: string;\n color: string;\n budget: number;\n current: number;\n}\n\nexport interface User {\n id: string;\n name: string;\n totalBalance: number;\n unallocated: number;\n envelopes: Envelope[];\n transactions: Transaction[];\n achievements: Achievement[];\n}\n\nexport interface Achievement {\n id: string;\n name: string;\n description: string;\n icon: string;\n unlocked: boolean;\n unlockedDate?: string;\n}\n\nexport interface CSVParseResult {\n success: boolean;\n transactions?: Transaction[];\n error?: string;\n}\n\n// CSV mapping configuration\nexport interface CSVMapping {\n date: string;\n description: string;\n amount: string;\n type?: string; // debit/credit indicator column if needed\n balance?: string;\n}",[],[79,87],"8137279a-3333-11f0-8460-9e149126039e","frontend","9f01d830-a6a8-41e2-a814-ee483bd68d19",7,["D",1747495675266],[100,101,102],[94],{"_34":118,"_13":119,"_37":120,"_39":95,"_41":42,"_43":121,"_45":46,"_47":122,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":123,"_18":124},{"_34":111,"_13":112,"_37":113,"_39":95,"_41":42,"_43":96,"_45":46,"_47":114,"_17":49,"_50":24,"_52":115,"_54":55,"_56":-5,"_75":116,"_18":117},{"_34":103,"_13":104,"_37":105,"_39":95,"_41":42,"_43":106,"_45":46,"_47":107,"_17":49,"_50":51,"_52":108,"_54":55,"_56":-5,"_75":109,"_18":110},"83e89f14-3333-11f0-b638-9e149126039e","index.tsx","83e89fbe-3333-11f0-b638-9e149126039e",8,["D",1747495679785],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\n// Create a root\nconst rootElement = document.getElementById(\"root\");\nif (!rootElement) throw new Error(\"Root element not found\");\n\nconst root = createRoot(rootElement);\nroot.render();",[],[94,104],"81371d2c-3333-11f0-8460-9e149126039e","index.html","81371dfe-3333-11f0-8460-9e149126039e",["D",1747495675266],"\n\n\n \n \n CashStash - Gen Z Budgeting App\n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n \n \n\n",[],[94,112],"9334ae5e-3333-11f0-a2ac-9e149126039e","components","602c15ba-76a9-4b69-9abd-cf0195891bfe",9,["D",1747495705444],[125,126,127,128,129,130,131,132,133],[94,119],{"_34":197,"_13":198,"_37":199,"_39":120,"_41":42,"_43":200,"_45":46,"_47":201,"_17":49,"_50":51,"_52":202,"_54":55,"_56":-5,"_75":203,"_18":204},{"_34":189,"_13":190,"_37":191,"_39":120,"_41":42,"_43":192,"_45":46,"_47":193,"_17":49,"_50":51,"_52":194,"_54":55,"_56":-5,"_75":195,"_18":196},{"_34":182,"_13":183,"_37":184,"_39":120,"_41":42,"_43":121,"_45":46,"_47":185,"_17":49,"_50":51,"_52":186,"_54":55,"_56":-5,"_75":187,"_18":188},{"_34":174,"_13":175,"_37":176,"_39":120,"_41":42,"_43":177,"_45":46,"_47":178,"_17":49,"_50":51,"_52":179,"_54":55,"_56":-5,"_75":180,"_18":181},{"_34":166,"_13":167,"_37":168,"_39":120,"_41":42,"_43":169,"_45":46,"_47":170,"_17":49,"_50":51,"_52":171,"_54":55,"_56":-5,"_75":172,"_18":173},{"_34":158,"_13":159,"_37":160,"_39":120,"_41":42,"_43":161,"_45":46,"_47":162,"_17":49,"_50":51,"_52":163,"_54":55,"_56":-5,"_75":164,"_18":165},{"_34":150,"_13":151,"_37":152,"_39":120,"_41":42,"_43":153,"_45":46,"_47":154,"_17":49,"_50":51,"_52":155,"_54":55,"_56":-5,"_75":156,"_18":157},{"_34":142,"_13":143,"_37":144,"_39":120,"_41":42,"_43":145,"_45":46,"_47":146,"_17":49,"_50":51,"_52":147,"_54":55,"_56":-5,"_75":148,"_18":149},{"_34":134,"_13":135,"_37":136,"_39":120,"_41":42,"_43":137,"_45":46,"_47":138,"_17":49,"_50":51,"_52":139,"_54":55,"_56":-5,"_75":140,"_18":141},"cc27e53c-3333-11f0-8536-9e149126039e","TransactionList.tsx","cc27e5f0-3333-11f0-8536-9e149126039e",13,["D",1747495800996],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Transaction, Envelope } from \"../../shared/types.ts\";\n\ninterface TransactionListProps {\n transactions: Transaction[];\n envelopes: Envelope[];\n onAssign: (transactionId: string, envelopeId: string) => void;\n}\n\nconst TransactionList: React.FC = ({ \n transactions, \n envelopes,\n onAssign\n}) => {\n const [selectedTransaction, setSelectedTransaction] = useState(null);\n \n if (transactions.length === 0) {\n return (\n

📊

No transactions yet

\n Import your bank statement to see transactions\n

\n );\n }\n \n // Group transactions by date\n const groupedTransactions: Record = {};\n \n transactions.forEach(transaction => {\n const date = new Date(transaction.date).toLocaleDateString();\n if (!groupedTransactions[date]) {\n groupedTransactions[date] = [];\n }\n groupedTransactions[date].push(transaction);\n });\n \n // Sort dates in descending order\n const sortedDates = Object.keys(groupedTransactions).sort((a, b) => {\n return new Date(b).getTime() - new Date(a).getTime();\n });\n \n const handleAssign = (transactionId: string, envelopeId: string) => {\n onAssign(transactionId, envelopeId);\n setSelectedTransaction(null);\n };\n \n return (\n

\n {sortedDates.map(date => (\n

{date}

\n {groupedTransactions[date].map(transaction => (\n

{transaction.description}

\n {transaction.processed ? (\n \n Assigned to {envelopes.find(e => e.id === transaction.category)?.name}\n \n ) : (\n Unassigned\n )}\n

= 0 ? 'text-green-600' : 'text-red-600'}`}>\n {transaction.amount >= 0 ? '+' : ''}{transaction.amount.toFixed(2)}\n

\n \n {/* Envelope selection */}\n {selectedTransaction === transaction.id && !transaction.processed && (\n

Assign to envelope:

\n {envelopes.map(envelope => (\n handleAssign(transaction.id, envelope.id)}\n >\n {envelope.icon}\n {envelope.name}\n \n ))}\n

\n )}\n \n {/* Action buttons */}\n {!transaction.processed && (\n

\n setSelectedTransaction(\n selectedTransaction === transaction.id ? null : transaction.id\n )}\n >\n {selectedTransaction === transaction.id ? 'Cancel' : 'Assign to Envelope'}\n \n

\n )}\n

\n ))}\n

\n );\n};\n\nexport default TransactionList;",[],[94,119,135],"9fce5a0c-3333-11f0-9a57-9e149126039e","Onboarding.tsx","9fce5c0a-3333-11f0-9a57-9e149126039e",10,["D",1747495726590],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface OnboardingProps {\n onCreateUser: (name: string) => void;\n}\n\nconst Onboarding: React.FC = ({ onCreateUser }) => {\n const [name, setName] = useState(\"\");\n const [step, setStep] = useState(0);\n \n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (name.trim()) {\n onCreateUser(name);\n }\n };\n \n const steps = [\n // Step 1: Welcome\n

Welcome to CashStash! 💰

The fun way to manage your money with digital cash stuffing

\n {[\"💸\", \"🏦\", \"💰\", \"💵\", \"🤑\", \"💎\"].map((emoji, i) => (\n

\n {emoji}\n

\n ))}\n

\n \n

,\n \n // Step 2: What is cash stuffing\n

What is Cash Stuffing? 📝

\n Cash stuffing is a budgeting method where you divide your money into different categories or \"envelopes.\"\n

\n 🏠\n

Rent

\n 🍔\n

Food

\n 🎮\n

Fun

\n With CashStash, you'll create digital envelopes and drag money into them to stay on budget!\n

\n \n

,\n \n // Step 3: Create account\n

Create Your Account

\n ];\n \n return (\n

\n {steps[step]}\n

\n );\n};\n\nexport default Onboarding;",[],[94,119,143],"c0928254-3333-11f0-9cce-9e149126039e","EnvelopeList.tsx","c0928312-3333-11f0-9cce-9e149126039e",12,["D",1747495781562],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Envelope } from \"../../shared/types.ts\";\n\ninterface EnvelopeListProps {\n envelopes: Envelope[];\n onDrop: (envelopeId: string) => void;\n isDragging: boolean;\n}\n\nconst EnvelopeList: React.FC = ({ envelopes, onDrop, isDragging }) => {\n if (envelopes.length === 0) {\n return (\n

📝

No envelopes yet

\n Create your first envelope to start budgeting\n

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

\n {envelopes.map(envelope => (\n {\n e.preventDefault();\n e.currentTarget.classList.add('border-green-500');\n }}\n onDragLeave={(e) => {\n e.currentTarget.classList.remove('border-green-500');\n }}\n onDrop={(e) => {\n e.preventDefault();\n e.currentTarget.classList.remove('border-green-500');\n onDrop(envelope.id);\n }}\n >\n

\n {envelope.icon}\n

{envelope.name}

\n \n

\n Current\n Budget\n

\n ${envelope.current.toFixed(2)}\n ${envelope.budget.toFixed(2)}\n

\n \n {/* Progress bar */}\n {envelope.budget > 0 && (\n

\n {Math.round((envelope.current / envelope.budget) * 100)}%\n

\n )}\n

\n ))}\n \n );\n};\n\nexport default EnvelopeList;",[],[94,119,151],"b734607e-3333-11f0-a7de-9e149126039e","Dashboard.tsx","b7346146-3333-11f0-a7de-9e149126039e",11,["D",1747495765845],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Envelope, Transaction } from \"../../shared/types.ts\";\nimport EnvelopeList from \"./EnvelopeList.tsx\";\nimport TransactionList from \"./TransactionList.tsx\";\nimport CreateEnvelopeModal from \"./CreateEnvelopeModal.tsx\";\nimport AchievementsList from \"./AchievementsList.tsx\";\n\ninterface DashboardProps {\n user: User;\n onCreateEnvelope: (name: string, icon: string, color: string, budget: number) => void;\n onAllocateMoney: (envelopeId: string, amount: number) => void;\n onImportCSV: () => void;\n onAssignTransaction: (transactionId: string, envelopeId: string) => void;\n}\n\nconst Dashboard: React.FC = ({ \n user, \n onCreateEnvelope, \n onAllocateMoney,\n onImportCSV,\n onAssignTransaction\n}) => {\n const [showCreateModal, setShowCreateModal] = useState(false);\n const [activeTab, setActiveTab] = useState<'envelopes' | 'transactions' | 'achievements'>('envelopes');\n const [dragAmount, setDragAmount] = useState(null);\n const dragGhostRef = useRef(null);\n \n // Create confetti effect\n const createConfetti = () => {\n const container = document.body;\n const confettiCount = 50;\n const colors = ['#f44336', '#e91e63', '#9c27b0', '#673ab7', '#3f51b5', '#2196f3', '#03a9f4', '#00bcd4', '#009688', '#4CAF50', '#8BC34A', '#CDDC39', '#FFEB3B', '#FFC107', '#FF9800', '#FF5722'];\n \n for (let i = 0; i < confettiCount; i++) {\n const confetti = document.createElement('div');\n confetti.className = 'confetti';\n confetti.style.left = `${Math.random() * 100}%`;\n confetti.style.backgroundColor = colors[Math.floor(Math.random() * colors.length)];\n confetti.style.width = `${Math.random() * 10 + 5}px`;\n confetti.style.height = `${Math.random() * 10 + 5}px`;\n confetti.style.animationDuration = `${Math.random() * 3 + 2}s`;\n container.appendChild(confetti);\n \n // Remove confetti after animation\n setTimeout(() => {\n confetti.remove();\n }, 5000);\n }\n };\n \n // Handle money drag start\n const handleDragStart = (amount: number) => {\n setDragAmount(amount);\n \n // Create drag ghost element\n if (!dragGhostRef.current) {\n const ghost = document.createElement('div');\n ghost.className = 'drag-ghost';\n ghost.innerHTML = `

$${amount}

`;\n document.body.appendChild(ghost);\n dragGhostRef.current = ghost;\n } else {\n dragGhostRef.current.innerHTML = `

$${amount}

`;\n }\n \n // Update ghost position on mouse move\n const handleMouseMove = (e: MouseEvent) => {\n if (dragGhostRef.current) {\n dragGhostRef.current.style.left = `${e.clientX}px`;\n dragGhostRef.current.style.top = `${e.clientY}px`;\n }\n };\n \n document.addEventListener('mousemove', handleMouseMove);\n \n // Clean up on drag end\n const handleDragEnd = () => {\n document.removeEventListener('mousemove', handleMouseMove);\n document.removeEventListener('mouseup', handleDragEnd);\n \n if (dragGhostRef.current) {\n dragGhostRef.current.remove();\n dragGhostRef.current = null;\n }\n \n setDragAmount(null);\n };\n \n document.addEventListener('mouseup', handleDragEnd);\n };\n \n // Handle dropping money into an envelope\n const handleMoneyDrop = (envelopeId: string) => {\n if (dragAmount && dragAmount > 0) {\n onAllocateMoney(envelopeId, dragAmount);\n createConfetti();\n }\n };\n \n return (\n

\n {/* Header */}\n

CashStash

\n \n BETA\n \n

\n Hello, {user.name}\n

\n \n

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

\n {/* Balance Card */}\n

Total Balance

${user.totalBalance.toFixed(2)}

Allocated

\n ${(user.totalBalance - user.unallocated).toFixed(2)}\n

Unallocated

${user.unallocated.toFixed(2)}

\n \n {/* Money to Drag */}\n {activeTab === 'envelopes' && user.unallocated > 0 && (\n

Drag Money to Envelopes

\n {[5, 10, 20, 50, 100].map(amount => (\n user.unallocated >= amount && (\n handleDragStart(amount)}\n onMouseDown={() => handleDragStart(amount)}\n >\n ${amount}\n

\n )\n ))}\n {user.unallocated > 0 && (\n handleDragStart(user.unallocated)}\n onMouseDown={() => handleDragStart(user.unallocated)}\n >\n ${user.unallocated.toFixed(2)}\n

\n )}\n

\n \n )}\n \n {/* Tabs */}\n

\n setActiveTab('envelopes')}\n >\n Envelopes\n \n setActiveTab('transactions')}\n >\n Transactions\n \n setActiveTab('achievements')}\n >\n Achievements\n \n

\n \n

\n {activeTab === 'envelopes' && (\n <>\n

Your Envelopes

\n setShowCreateModal(true)}\n className=\"bg-blue-500 text-white px-4 py-2 rounded-lg text-sm font-medium hover:bg-blue-600 transition-colors\"\n >\n Create Envelope\n \n

\n \n \n )}\n \n {activeTab === 'transactions' && (\n <>\n

Recent Transactions

\n \n \n )}\n \n {activeTab === 'achievements' && (\n <>\n

Your Achievements

\n \n \n )}\n

\n \n \n {/* Create Envelope Modal */}\n {showCreateModal && (\n setShowCreateModal(false)}\n onCreate={onCreateEnvelope}\n />\n )}\n \n );\n};\n\nexport default Dashboard;",[],[94,119,159],"dbf2ca54-3333-11f0-8218-9e149126039e","CreateEnvelopeModal.tsx","dbf2cb08-3333-11f0-8218-9e149126039e",14,["D",1747495827471],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface CreateEnvelopeModalProps {\n onClose: () => void;\n onCreate: (name: string, icon: string, color: string, budget: number) => void;\n}\n\nconst CreateEnvelopeModal: React.FC = ({ onClose, onCreate }) => {\n const [name, setName] = useState(\"\");\n const [icon, setIcon] = useState(\"💰\");\n const [color, setColor] = useState(\"#3B82F6\"); // Default blue\n const [budget, setBudget] = useState(\"\");\n \n const icons = [\"💰\", \"🏠\", \"🍔\", \"🚗\", \"💊\", \"👕\", \"✈️\", \"🎮\", \"📚\", \"🎬\", \"🎵\", \"🎁\", \"💄\", \"🐶\", \"🏋️\", \"💻\"];\n \n const colors = [\n \"#3B82F6\", // blue\n \"#EF4444\", // red\n \"#10B981\", // green\n \"#F59E0B\", // amber\n \"#8B5CF6\", // purple\n \"#EC4899\", // pink\n \"#6366F1\", // indigo\n \"#14B8A6\", // teal\n \"#F97316\", // orange\n \"#06B6D4\", // cyan\n ];\n \n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (name.trim()) {\n onCreate(name, icon, color, budget ? parseFloat(budget) : 0);\n onClose();\n }\n };\n \n return (\n

Create Envelope

\n \n

\n {/* Name */}\n

\n \n Envelope Name\n \n setName(e.target.value)}\n className=\"w-full px-4 py-3 rounded-lg border border-gray-300 focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"e.g., Rent, Groceries, Fun\"\n required\n />\n

\n \n {/* Icon */}\n

\n \n Choose an Icon\n \n

\n {icons.map((emoji) => (\n setIcon(emoji)}\n >\n {emoji}\n \n ))}\n

\n \n {/* Color */}\n

\n \n Choose a Color\n \n

\n {colors.map((clr) => (\n setColor(clr)}\n >\n ))}\n

\n \n {/* Budget */}\n

\n \n Monthly Budget (optional)\n \n

\n $\n

\n setBudget(e.target.value)}\n className=\"w-full pl-8 px-4 py-3 rounded-lg border border-gray-300 focus:outline-none focus:ring-2 focus:ring-blue-500\"\n placeholder=\"0.00\"\n min=\"0\"\n step=\"0.01\"\n />\n

\n \n {/* Preview */}\n

\n \n Preview\n \n

\n {icon}\n

{name || \"Envelope Name\"}

\n $0.00\n ${budget ? parseFloat(budget).toFixed(2) : \"0.00\"}\n

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

\n \n Cancel\n \n \n Create Envelope\n \n

\n );\n};\n\nexport default CreateEnvelopeModal;",[],[94,119,167],"f662757e-3333-11f0-9bd3-9e149126039e","CSVImport.tsx","f662763c-3333-11f0-9bd3-9e149126039e",15,["D",1747495871835],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { CSVMapping } from \"../../shared/types.ts\";\n\ninterface CSVImportProps {\n onImport: (csvContent: string, mapping: CSVMapping) => void;\n onCancel: () => void;\n}\n\nconst CSVImport: React.FC = ({ onImport, onCancel }) => {\n const [csvContent, setCsvContent] = useState(\"\");\n const [headers, setHeaders] = useState([]);\n const [mapping, setMapping] = useState({\n date: \"\",\n description: \"\",\n amount: \"\",\n type: \"\"\n });\n const [step, setStep] = useState(1);\n const [error, setError] = useState(\"\");\n \n // Handle file upload\n const handleFileUpload = (e: React.ChangeEvent) => {\n const file = e.target.files?.[0];\n if (!file) return;\n \n const reader = new FileReader();\n reader.onload = (event) => {\n const content = event.target?.result as string;\n setCsvContent(content);\n \n // Extract headers\n const lines = content.split(/\\r?\\n/);\n if (lines.length > 0) {\n const headerLine = lines[0];\n const extractedHeaders = parseCSVRow(headerLine);\n setHeaders(extractedHeaders);\n }\n \n setStep(2);\n };\n reader.readAsText(file);\n };\n \n // Parse CSV row\n const 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 inQuotes = !inQuotes;\n } else if (char === ',' && !inQuotes) {\n result.push(current);\n current = \"\";\n } else {\n current += char;\n }\n }\n \n result.push(current);\n return result;\n };\n \n // Handle mapping change\n const handleMappingChange = (field: keyof CSVMapping, value: string) => {\n setMapping(prev => ({ ...prev, [field]: value }));\n };\n \n // Handle import\n const handleImport = () => {\n // Validate required fields\n if (!mapping.date || !mapping.description || !mapping.amount) {\n setError(\"Date, Description, and Amount fields are required\");\n return;\n }\n \n onImport(csvContent, mapping);\n };\n \n // Preview CSV data\n const renderPreview = () => {\n const lines = csvContent.split(/\\r?\\n/).slice(0, 6); // Show first 5 rows + header\n \n return (\n

\n \n \n \n {headers.map((header, index) => (\n \n {header}\n \n ))}\n \n \n \n {lines.slice(1).map((line, rowIndex) => (\n \n {parseCSVRow(line).map((cell, cellIndex) => (\n \n {cell}\n \n ))}\n \n ))}\n \n

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

Import Bank Statement

\n \n

\n \n {/* Step indicator */}\n

= 1 ? 'text-blue-600' : 'text-gray-400'}`}>\n

= 1 ? 'bg-blue-100 text-blue-600' : 'bg-gray-100 text-gray-400'\n }`}>\n 1\n

Upload CSV

= 2 ? 'text-blue-600' : 'text-gray-400'}`}>\n

= 2 ? 'bg-blue-100 text-blue-600' : 'bg-gray-100 text-gray-400'\n }`}>\n 2\n

Map Columns

= 3 ? 'text-blue-600' : 'text-gray-400'}`}>\n

= 3 ? 'bg-blue-100 text-blue-600' : 'bg-gray-100 text-gray-400'\n }`}>\n 3\n

Import

\n \n {error && (\n

\n {error}\n

\n )}\n \n {step === 1 && (\n

📊

Upload your bank statement CSV

\n We'll help you map the columns to import your transactions\n

\n \n Select CSV File\n \n \n

\n )}\n \n {step === 2 && (\n

Map Your CSV Columns

\n Tell us which columns contain your transaction data\n

\n \n

\n \n Date Column *\n \n handleMappingChange(\"date\", e.target.value)}\n className=\"w-full px-4 py-2 rounded-lg border border-gray-300 focus:outline-none focus:ring-2 focus:ring-blue-500\"\n required\n >\n \n {headers.map((header, index) => (\n \n ))}\n \n

\n \n

\n \n Description Column *\n \n handleMappingChange(\"description\", e.target.value)}\n className=\"w-full px-4 py-2 rounded-lg border border-gray-300 focus:outline-none focus:ring-2 focus:ring-blue-500\"\n required\n >\n \n {headers.map((header, index) => (\n \n ))}\n \n

\n \n

\n \n Amount Column *\n \n handleMappingChange(\"amount\", e.target.value)}\n className=\"w-full px-4 py-2 rounded-lg border border-gray-300 focus:outline-none focus:ring-2 focus:ring-blue-500\"\n required\n >\n \n {headers.map((header, index) => (\n \n ))}\n \n

\n \n

\n \n Transaction Type Column (optional)\n \n handleMappingChange(\"type\", e.target.value)}\n className=\"w-full px-4 py-2 rounded-lg border border-gray-300 focus:outline-none focus:ring-2 focus:ring-blue-500\"\n >\n \n {headers.map((header, index) => (\n \n ))}\n \n

\n Use this if your CSV has a column indicating debit/credit\n

\n \n

Preview

\n {renderPreview()}\n

\n \n

\n setStep(1)}\n className=\"px-4 py-2 text-gray-700 font-medium\"\n >\n Back\n \n {\n if (!mapping.date || !mapping.description || !mapping.amount) {\n setError(\"Date, Description, and Amount fields are required\");\n return;\n }\n setError(\"\");\n setStep(3);\n }}\n className=\"px-6 py-2 bg-blue-500 text-white rounded-lg font-medium hover:bg-blue-600 transition-colors\"\n >\n Continue\n \n

\n )}\n \n {step === 3 && (\n

🎉

Ready to Import

\n We'll import your transactions using the following mapping:\n

\n \n

Date: {mapping.date}

Description: {mapping.description}

Amount: {mapping.amount}

\n {mapping.type &&

Type: {mapping.type}

}\n

\n \n

\n setStep(2)}\n className=\"px-4 py-2 text-gray-700 font-medium mr-4\"\n >\n Back\n \n \n Import Transactions\n \n

\n )}\n

\n );\n};\n\nexport default CSVImport;",[],[94,119,175],"93349f86-3333-11f0-a2ac-9e149126039e","App.tsx","9334a01c-3333-11f0-a2ac-9e149126039e",["D",1747495705444],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Envelope, Transaction, Achievement } from \"../../shared/types.ts\";\nimport Onboarding from \"./Onboarding.tsx\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport CSVImport from \"./CSVImport.tsx\";\nimport AchievementNotification from \"./AchievementNotification.tsx\";\n\nconst API_BASE_URL = \"/api\";\n\nconst App: React.FC = () => {\n const [user, setUser] = useState(null);\n const [loading, setLoading] = useState(true);\n const [showImport, setShowImport] = useState(false);\n const [newAchievement, setNewAchievement] = useState(null);\n \n // Check for user in localStorage on initial load\n useEffect(() => {\n const userId = localStorage.getItem(\"cashStashUserId\");\n if (userId) {\n fetchUser(userId);\n } else {\n setLoading(false);\n }\n }, []);\n \n // Watch for new achievements\n useEffect(() => {\n if (user && user.achievements) {\n const unlockedToday = user.achievements.find(a => {\n if (!a.unlocked || !a.unlockedDate) return false;\n const unlockDate = new Date(a.unlockedDate).toDateString();\n const today = new Date().toDateString();\n return unlockDate === today;\n });\n \n if (unlockedToday && !newAchievement) {\n setNewAchievement(unlockedToday);\n // Clear notification after 5 seconds\n setTimeout(() => setNewAchievement(null), 5000);\n }\n }\n }, [user]);\n \n const fetchUser = async (userId: string) => {\n try {\n setLoading(true);\n const response = await fetch(`${API_BASE_URL}/users/${userId}`);\n \n if (!response.ok) {\n throw new Error(\"Failed to fetch user\");\n }\n \n const userData = await response.json();\n setUser(userData);\n localStorage.setItem(\"cashStashUserId\", userId);\n } catch (error) {\n console.error(\"Error fetching user:\", error);\n localStorage.removeItem(\"cashStashUserId\");\n } finally {\n setLoading(false);\n }\n };\n \n const createUser = async (name: string) => {\n try {\n setLoading(true);\n const response = await fetch(`${API_BASE_URL}/users`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ name }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to create user\");\n }\n \n const userData = await response.json();\n setUser(userData);\n localStorage.setItem(\"cashStashUserId\", userData.id);\n } catch (error) {\n console.error(\"Error creating user:\", error);\n } finally {\n setLoading(false);\n }\n };\n \n const createEnvelope = async (name: string, icon: string, color: string, budget: number) => {\n if (!user) return;\n \n try {\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/envelopes`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ name, icon, color, budget }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to create envelope\");\n }\n \n // Refresh user data\n fetchUser(user.id);\n } catch (error) {\n console.error(\"Error creating envelope:\", error);\n }\n };\n \n const allocateMoney = async (envelopeId: string, amount: number) => {\n if (!user) return;\n \n try {\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/envelopes/${envelopeId}/allocate`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ amount }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to allocate money\");\n }\n \n const updatedUser = await response.json();\n setUser(updatedUser);\n } catch (error) {\n console.error(\"Error allocating money:\", error);\n }\n };\n \n const importTransactions = async (csvContent: string, mapping: any) => {\n if (!user) return;\n \n try {\n setLoading(true);\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/transactions/import`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ csvContent, mapping }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to import transactions\");\n }\n \n const data = await response.json();\n setUser(data.user);\n setShowImport(false);\n } catch (error) {\n console.error(\"Error importing transactions:\", error);\n } finally {\n setLoading(false);\n }\n };\n \n const assignTransaction = async (transactionId: string, envelopeId: string) => {\n if (!user) return;\n \n try {\n const response = await fetch(`${API_BASE_URL}/users/${user.id}/transactions/${transactionId}/assign`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ envelopeId }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to assign transaction\");\n }\n \n const updatedUser = await response.json();\n setUser(updatedUser);\n } catch (error) {\n console.error(\"Error assigning transaction:\", error);\n }\n };\n \n if (loading) {\n return (\n

💰

Loading CashStash...

Counting your money...

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

\n {newAchievement && (\n \n )}\n \n {showImport ? (\n setShowImport(false)} \n />\n ) : (\n setShowImport(true)}\n onAssignTransaction={assignTransaction}\n />\n )}\n

\n );\n};\n\nexport default App;",[],[94,119,183],"fccfbc8c-3333-11f0-a4ac-9e149126039e","AchievementsList.tsx","fccfbd40-3333-11f0-a4ac-9e149126039e",16,["D",1747495882627],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Achievement } from \"../../shared/types.ts\";\n\ninterface AchievementsListProps {\n achievements: Achievement[];\n}\n\nconst AchievementsList: React.FC = ({ achievements }) => {\n // Sort achievements: unlocked first, then by name\n const sortedAchievements = [...achievements].sort((a, b) => {\n if (a.unlocked && !b.unlocked) return -1;\n if (!a.unlocked && b.unlocked) return 1;\n return a.name.localeCompare(b.name);\n });\n \n return (\n

\n {sortedAchievements.map(achievement => (\n \n

{achievement.icon}

{achievement.name}

{achievement.description}

\n {achievement.unlocked && achievement.unlockedDate && (\n

\n Unlocked on {new Date(achievement.unlockedDate).toLocaleDateString()}\n

\n )}\n

\n ))}\n \n );\n};\n\nexport default AchievementsList;",[],[94,119,190],"04318938-3334-11f0-92e1-9e149126039e","AchievementNotification.tsx","043189ec-3334-11f0-92e1-9e149126039e",17,["D",1747495895010],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Achievement } from \"../../shared/types.ts\";\n\ninterface AchievementNotificationProps {\n achievement: Achievement;\n}\n\nconst AchievementNotification: React.FC = ({ achievement }) => {\n useEffect(() => {\n // Create confetti effect\n const container = document.body;\n const confettiCount = 30;\n const colors = ['#f44336', '#e91e63', '#9c27b0', '#673ab7', '#3f51b5', '#2196f3', '#03a9f4', '#00bcd4', '#009688', '#4CAF50', '#8BC34A', '#CDDC39', '#FFEB3B', '#FFC107', '#FF9800', '#FF5722'];\n \n for (let i = 0; i < confettiCount; i++) {\n const confetti = document.createElement('div');\n confetti.className = 'confetti';\n confetti.style.left = `${Math.random() * 100}%`;\n confetti.style.backgroundColor = colors[Math.floor(Math.random() * colors.length)];\n confetti.style.width = `${Math.random() * 10 + 5}px`;\n confetti.style.height = `${Math.random() * 10 + 5}px`;\n confetti.style.animationDuration = `${Math.random() * 3 + 2}s`;\n container.appendChild(confetti);\n \n // Remove confetti after animation\n setTimeout(() => {\n confetti.remove();\n }, 5000);\n }\n }, []);\n \n return (\n

\n {achievement.icon}\n

Achievement Unlocked!

{achievement.name}

{achievement.description}

\n );\n};\n\nexport default AchievementNotification;",[],[94,119,198],"50bb0172-3333-11f0-bd48-9e149126039e",3,["D",1747495593922],[210,211,212],[58],{"_34":229,"_13":230,"_37":231,"_39":62,"_41":42,"_43":206,"_45":46,"_47":232,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":233,"_18":234},{"_34":60,"_13":59,"_37":40,"_39":62,"_41":42,"_43":44,"_45":46,"_47":222,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":223,"_18":224},{"_34":213,"_13":214,"_37":215,"_39":62,"_41":42,"_43":216,"_45":46,"_47":217,"_17":72,"_50":218,"_52":219,"_54":55,"_56":-5,"_75":220,"_18":221},"06c3d8cc-3334-11f0-a4ac-9e149126039e","index.ts","79f1d980-3333-11f0-9159-9e149126039e",18,["D",1747495899324],"http","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;",[],[58,214],["D",1747495640370],[225],[58,59],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":226,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_75":227,"_18":228},["D",1747495640370],[],[58,59,36],"50bb03ac-3333-11f0-bd48-9e149126039e","database","46d8a173-1fde-43f0-a791-9483ac3b7f95",["D",1747495593922],[235,236],[58,230],{"_34":245,"_13":246,"_37":247,"_39":231,"_41":42,"_43":206,"_45":46,"_47":248,"_17":49,"_50":51,"_52":249,"_54":55,"_56":-5,"_75":250,"_18":251},{"_34":237,"_13":238,"_37":239,"_39":231,"_41":42,"_43":240,"_45":46,"_47":241,"_17":49,"_50":51,"_52":242,"_54":55,"_56":-5,"_75":243,"_18":244},"6156eb54-3333-11f0-9159-9e149126039e","queries.ts","6156ec1c-3333-11f0-9159-9e149126039e",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}",[],[58,230,238],"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}",[],[58,230,246],"0d1f68f4-3333-11f0-9f41-9e149126039e",["D",1747495480497],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","aba6df40-31bf-11f0-ac4e-e3462f58c9c4","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","b516df03-1afb-4b4c-b24c-661c4fbc488b","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_304":300},"org",{"_11":12,"_298":-5,"_299":300,"_261":262,"_301":302,"_303":55},"branch",{"_17":216,"_13":16,"_34":42,"_290":252,"_291":-5,"_292":-5,"_293":-5,"_294":-5,"_295":-5,"_296":14,"_297":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4OTJSTExldk5KVEZQd2w4Qm9KVVNuTERuUCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":252,"_13":14,"_47":406,"_254":-5,"_255":55,"_256":257,"_258":257,"_259":-5,"_260":-5,"_261":262,"_263":215,"_264":46,"_265":46,"_266":-5,"_267":49,"_268":269,"_270":-5,"_271":-5,"_272":-5,"_273":-5,"_274":275,"_276":275,"_277":278,"_279":278,"_280":278,"_281":275,"_282":275,"_283":407,"_285":408,"_287":409,"_289":55},[337,344,357,359],"files",[337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359],"counts",{"_328":49,"_329":72,"_330":49,"_32":331,"_332":333},[326],{"_34":60,"_13":59,"_37":40,"_39":62,"_41":42,"_43":44,"_45":46,"_47":324,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_18":325},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1747495640370],[58,59],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":327},[58,59,36],"pulls","branches","forks",{"_334":49,"_336":49},"connections",{"_334":49,"_335":49},"count","unfilledCount","emptyCount",{"_34":205,"_13":58,"_37":62,"_39":-5,"_41":42,"_43":206,"_45":46,"_47":207,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":404,"_18":405},{"_34":229,"_13":230,"_37":231,"_39":62,"_41":42,"_43":206,"_45":46,"_47":232,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":402,"_18":403},{"_34":245,"_13":246,"_37":247,"_39":231,"_41":42,"_43":206,"_45":46,"_47":248,"_17":49,"_50":51,"_52":249,"_54":55,"_56":-5,"_75":400,"_18":401},{"_34":237,"_13":238,"_37":239,"_39":231,"_41":42,"_43":240,"_45":46,"_47":241,"_17":49,"_50":51,"_52":242,"_54":55,"_56":-5,"_75":398,"_18":399},{"_34":60,"_13":59,"_37":40,"_39":62,"_41":42,"_43":44,"_45":46,"_47":222,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":396,"_18":397},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":226,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_75":394,"_18":395},{"_34":213,"_13":214,"_37":215,"_39":62,"_41":42,"_43":216,"_45":46,"_47":217,"_17":72,"_50":218,"_52":219,"_54":55,"_56":-5,"_75":392,"_18":393},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":390,"_18":391},{"_34":118,"_13":119,"_37":120,"_39":95,"_41":42,"_43":121,"_45":46,"_47":122,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":388,"_18":389},{"_34":197,"_13":198,"_37":199,"_39":120,"_41":42,"_43":200,"_45":46,"_47":201,"_17":49,"_50":51,"_52":202,"_54":55,"_56":-5,"_75":386,"_18":387},{"_34":189,"_13":190,"_37":191,"_39":120,"_41":42,"_43":192,"_45":46,"_47":193,"_17":49,"_50":51,"_52":194,"_54":55,"_56":-5,"_75":384,"_18":385},{"_34":182,"_13":183,"_37":184,"_39":120,"_41":42,"_43":121,"_45":46,"_47":185,"_17":49,"_50":51,"_52":186,"_54":55,"_56":-5,"_75":382,"_18":383},{"_34":174,"_13":175,"_37":176,"_39":120,"_41":42,"_43":177,"_45":46,"_47":178,"_17":49,"_50":51,"_52":179,"_54":55,"_56":-5,"_75":380,"_18":381},{"_34":166,"_13":167,"_37":168,"_39":120,"_41":42,"_43":169,"_45":46,"_47":170,"_17":49,"_50":51,"_52":171,"_54":55,"_56":-5,"_75":378,"_18":379},{"_34":158,"_13":159,"_37":160,"_39":120,"_41":42,"_43":161,"_45":46,"_47":162,"_17":49,"_50":51,"_52":163,"_54":55,"_56":-5,"_75":376,"_18":377},{"_34":150,"_13":151,"_37":152,"_39":120,"_41":42,"_43":153,"_45":46,"_47":154,"_17":49,"_50":51,"_52":155,"_54":55,"_56":-5,"_75":374,"_18":375},{"_34":142,"_13":143,"_37":144,"_39":120,"_41":42,"_43":145,"_45":46,"_47":146,"_17":49,"_50":51,"_52":147,"_54":55,"_56":-5,"_75":372,"_18":373},{"_34":134,"_13":135,"_37":136,"_39":120,"_41":42,"_43":137,"_45":46,"_47":138,"_17":49,"_50":51,"_52":139,"_54":55,"_56":-5,"_75":370,"_18":371},{"_34":111,"_13":112,"_37":113,"_39":95,"_41":42,"_43":96,"_45":46,"_47":114,"_17":49,"_50":24,"_52":115,"_54":55,"_56":-5,"_75":368,"_18":369},{"_34":103,"_13":104,"_37":105,"_39":95,"_41":42,"_43":106,"_45":46,"_47":107,"_17":49,"_50":51,"_52":108,"_54":55,"_56":-5,"_75":366,"_18":367},{"_34":78,"_13":79,"_37":80,"_39":-5,"_41":42,"_43":81,"_45":46,"_47":82,"_17":49,"_50":61,"_52":-5,"_54":55,"_56":-5,"_75":364,"_18":365},{"_34":86,"_13":87,"_37":88,"_39":80,"_41":42,"_43":81,"_45":46,"_47":89,"_17":49,"_50":51,"_52":90,"_54":55,"_56":-5,"_75":362,"_18":363},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":49,"_50":24,"_52":74,"_54":55,"_56":-5,"_75":360,"_18":361},[],[70],[],[79,87],[358],[79],[],[94,104],[],[94,112],[],[94,119,135],[],[94,119,143],[],[94,119,151],[],[94,119,159],[],[94,119,167],[],[94,119,175],[],[94,119,183],[],[94,119,190],[],[94,119,198],[346,347,348,349,350,351,352,353,354],[94,119],[345,355,356],[94],[],[58,214],[],[58,59,36],[342],[58,59],[],[58,230,238],[],[58,230,246],[339,340],[58,230],[338,341,343],[58],["D",1747495480497],{"_11":12,"_304":300},{"_11":12,"_298":-5,"_299":300,"_261":262,"_301":302,"_303":55},{"_17":216,"_13":16,"_34":42,"_290":252,"_291":-5,"_292":-5,"_293":-5,"_294":-5,"_295":-5,"_296":14,"_297":12},"ctx",{"_283":-5,"_321":443,"_444":445,"_446":447,"_448":55,"_449":55,"_450":55,"_451":46,"_452":-5,"_453":-7,"_454":-7,"_455":49,"_456":55,"_457":55,"_458":-5,"_459":55,"_460":55,"_461":55,"_462":-5},"ENV",{"_414":415,"_416":417,"_418":16,"_419":420,"_421":422,"_423":424,"_425":426,"_427":428,"_429":430,"_431":432,"_433":434,"_435":436,"_437":438,"_439":440,"_441":442},"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"]