Multi-Currency Finance Platform

\n \n\n",[],[66,112],"0134e6b6-3394-11f0-81c9-9e149126039e","components","f2ece2e3-fd0f-4b6d-a757-369c567693e2",17,["D",1747537121684],[125,126,127],[66,119],{"_36":144,"_13":145,"_39":146,"_41":120,"_42":43,"_44":121,"_46":47,"_48":147,"_17":50,"_51":93,"_52":148,"_54":55,"_56":-5,"_82":149,"_18":150},{"_36":136,"_13":137,"_39":138,"_41":120,"_42":43,"_44":139,"_46":47,"_48":140,"_17":50,"_51":93,"_52":141,"_54":55,"_56":-5,"_82":142,"_18":143},{"_36":128,"_13":129,"_39":130,"_41":120,"_42":43,"_44":131,"_46":47,"_48":132,"_17":50,"_51":93,"_52":133,"_54":55,"_56":-5,"_82":134,"_18":135},"1d932fd4-3394-11f0-8b94-9e149126039e","Dashboard.tsx","1d933092-3394-11f0-8b94-9e149126039e",19,["D",1747537169279],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport Navbar from \"./Navbar.tsx\";\nimport WalletDashboard from \"./WalletDashboard.tsx\";\nimport KYCForm from \"./KYCForm.tsx\";\nimport TransactionHistory from \"./TransactionHistory.tsx\";\nimport SendMoney from \"./SendMoney.tsx\";\nimport CurrencyExchange from \"./CurrencyExchange.tsx\";\nimport TransactionLimits from \"./TransactionLimits.tsx\";\nimport { KYCStatus } from \"../../shared/types.ts\";\n\ninterface DashboardProps {\n token: string;\n onLogout: () => void;\n}\n\nconst Dashboard: React.FC = ({ token, onLogout }) => {\n const [activeTab, setActiveTab] = useState(\"wallets\");\n const [kycStatus, setKycStatus] = useState(\"not_submitted\");\n const [loading, setLoading] = useState(true);\n\n // Fetch KYC status on component mount\n useEffect(() => {\n fetchKYCStatus();\n }, []);\n\n // Fetch KYC status\n const fetchKYCStatus = async () => {\n try {\n setLoading(true);\n const response = await fetch(\"/api/kyc/status\", {\n headers: {\n Authorization: `Bearer ${token}`\n }\n });\n\n if (response.ok) {\n const data = await response.json();\n setKycStatus(data.status);\n }\n } catch (error) {\n console.error(\"Error fetching KYC status:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n // Render the active tab content\n const renderTabContent = () => {\n switch (activeTab) {\n case \"wallets\":\n return ;\n case \"kyc\":\n return ;\n case \"send\":\n return ;\n case \"exchange\":\n return ;\n case \"transactions\":\n return ;\n case \"limits\":\n return ;\n default:\n return ;\n }\n };\n\n if (loading) {\n return (\n

\n Loading...\n

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

\n \n \n

\n {renderTabContent()}\n

\n );\n};\n\nexport default Dashboard;",[],[66,119,129],"10866d42-3394-11f0-a16c-9e149126039e","AuthPage.tsx","10866dec-3394-11f0-a16c-9e149126039e",18,["D",1747537147385],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\ninterface AuthPageProps {\n onLogin: (token: string, userId: string) => void;\n}\n\nconst AuthPage: React.FC = ({ onLogin }) => {\n const [isLogin, setIsLogin] = useState(true);\n const [name, setName] = useState(\"\");\n const [email, setEmail] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(\"\");\n const [loading, setLoading] = useState(false);\n\n // Handle form submission\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n setLoading(true);\n\n try {\n const endpoint = isLogin ? \"/api/login\" : \"/api/register\";\n const payload = isLogin\n ? { email, password }\n : { name, email, password };\n\n const response = await fetch(endpoint, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\"\n },\n body: JSON.stringify(payload)\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || \"Authentication failed\");\n }\n\n if (isLogin) {\n // Login successful\n onLogin(data.token, data.user_id);\n } else {\n // Registration successful, switch to login\n setIsLogin(true);\n setError(\"\");\n setPassword(\"\");\n }\n } catch (error) {\n setError(error.message);\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

\n {isLogin ? \"Sign in to your account\" : \"Create a new account\"}\n

\n {isLogin ? \"Don't have an account? \" : \"Already have an account? \"}\n {\n setIsLogin(!isLogin);\n setError(\"\");\n }}\n className=\"font-medium text-blue-600 hover:text-blue-500\"\n >\n {isLogin ? \"Sign up\" : \"Sign in\"}\n \n

\n \n {error && (\n

\n \n

{error}

\n )}\n \n

\n {!isLogin && (\n

\n \n Full Name\n \n setName(e.target.value)}\n className=\"appearance-none rounded-none relative block w-full px-3 py-2 border border-gray-300 placeholder-gray-500 text-gray-900 rounded-t-md focus:outline-none focus:ring-blue-500 focus:border-blue-500 focus:z-10 sm:text-sm\"\n placeholder=\"Full Name\"\n />\n

\n )}\n

\n \n Email address\n \n setEmail(e.target.value)}\n className={`appearance-none rounded-none relative block w-full px-3 py-2 border border-gray-300 placeholder-gray-500 text-gray-900 ${\n isLogin ? \"rounded-t-md\" : \"\"\n } focus:outline-none focus:ring-blue-500 focus:border-blue-500 focus:z-10 sm:text-sm`}\n placeholder=\"Email address\"\n />\n

\n \n Password\n \n setPassword(e.target.value)}\n className=\"appearance-none rounded-none relative block w-full px-3 py-2 border border-gray-300 placeholder-gray-500 text-gray-900 rounded-b-md focus:outline-none focus:ring-blue-500 focus:border-blue-500 focus:z-10 sm:text-sm\"\n placeholder=\"Password\"\n />\n

\n\n

\n \n {loading ? (\n <>\n \n {isLogin ? \"Signing in...\" : \"Creating account...\"}\n \n ) : (\n <>{isLogin ? \"Sign in\" : \"Sign up\"}\n )}\n \n

\n );\n};\n\nexport default AuthPage;",[],[66,119,137],"0134b83a-3394-11f0-81c9-9e149126039e","App.tsx","0134b934-3394-11f0-81c9-9e149126039e",["D",1747537121684],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { User } from \"../../shared/types.ts\";\nimport AuthPage from \"./AuthPage.tsx\";\nimport Dashboard from \"./Dashboard.tsx\";\n\nconst App: React.FC = () => {\n const [isAuthenticated, setIsAuthenticated] = useState(false);\n const [user, setUser] = useState(null);\n const [token, setToken] = useState(null);\n const [loading, setLoading] = useState(true);\n\n // Check if user is already authenticated\n useEffect(() => {\n const storedToken = localStorage.getItem(\"token\");\n const storedUserId = localStorage.getItem(\"userId\");\n \n if (storedToken && storedUserId) {\n setToken(storedToken);\n setIsAuthenticated(true);\n fetchUserData(storedToken, storedUserId);\n } else {\n setLoading(false);\n }\n }, []);\n\n // Fetch user data\n const fetchUserData = async (authToken: string, userId: string) => {\n try {\n const response = await fetch(`/api/user/${userId}`, {\n headers: {\n Authorization: `Bearer ${authToken}`\n }\n });\n\n if (response.ok) {\n const userData = await response.json();\n setUser(userData);\n } else {\n // Token might be expired or invalid\n handleLogout();\n }\n } catch (error) {\n console.error(\"Error fetching user data:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n // Handle login\n const handleLogin = (authToken: string, userId: string) => {\n localStorage.setItem(\"token\", authToken);\n localStorage.setItem(\"userId\", userId);\n setToken(authToken);\n setIsAuthenticated(true);\n fetchUserData(authToken, userId);\n };\n\n // Handle logout\n const handleLogout = () => {\n localStorage.removeItem(\"token\");\n localStorage.removeItem(\"userId\");\n setToken(null);\n setUser(null);\n setIsAuthenticated(false);\n };\n\n if (loading) {\n return (\n

\n Loading...\n

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

\n {isAuthenticated ? (\n \n ) : (\n \n )}\n

\n );\n};\n\nexport default App;",[],[66,119,145],["D",1747536909321],[154,155,156,157,158],[72],{"_36":265,"_13":266,"_39":267,"_41":73,"_42":43,"_44":74,"_46":47,"_48":268,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":269,"_18":270},{"_36":251,"_13":252,"_39":253,"_41":73,"_42":43,"_44":254,"_46":47,"_48":255,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":256,"_18":257},{"_36":191,"_13":192,"_39":193,"_41":73,"_42":43,"_44":194,"_46":47,"_48":195,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":196,"_18":197},{"_36":167,"_13":168,"_39":169,"_41":73,"_42":43,"_44":170,"_46":47,"_48":171,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":172,"_18":173},{"_36":159,"_13":160,"_39":161,"_41":73,"_42":43,"_44":162,"_46":47,"_48":163,"_17":50,"_51":93,"_52":164,"_54":55,"_56":-5,"_82":165,"_18":166},"ed024990-3393-11f0-8cf6-9e149126039e","index.ts","ed024a26-3393-11f0-8cf6-9e149126039e",14,["D",1747537087801],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { initializeDatabase } from \"./database/schema.ts\";\n\n// Import routes\nimport authRoutes from \"./routes/auth.ts\";\nimport kycRoutes from \"./routes/kyc.ts\";\nimport walletRoutes from \"./routes/wallets.ts\";\nimport transactionRoutes from \"./routes/transactions.ts\";\nimport limitRoutes from \"./routes/limits.ts\";\nimport webhookRoutes from \"./routes/webhooks.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Apply CORS middleware\napp.use(\"*\", cors());\n\n// Initialize database on startup\napp.use(\"*\", async (c, next) => {\n try {\n await initializeDatabase();\n } catch (error) {\n console.error(\"Database initialization error:\", error);\n }\n await next();\n});\n\n// API routes\napp.route(\"/api/register\", authRoutes);\napp.route(\"/api/login\", authRoutes);\napp.route(\"/api/kyc\", kycRoutes);\napp.route(\"/api/wallet\", walletRoutes);\napp.route(\"/api/wallets\", walletRoutes);\napp.route(\"/api/transactions\", transactionRoutes);\napp.route(\"/api/send\", transactionRoutes);\napp.route(\"/api/user\", limitRoutes);\napp.route(\"/api/webhooks\", webhookRoutes);\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 the 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// Catch-all route for SPA\napp.get(\"*\", async c => {\n if (c.req.path.startsWith(\"/api/\")) {\n return c.json({ error: \"API endpoint not found\" }, 404);\n }\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Export the app\nexport default app.fetch;",[],[72,160],"a2c69be2-3393-11f0-a9af-9e149126039e","utils","efe8696e-1190-4469-a672-16ed64313ca8",6,["D",1747536963257],[174,175],[72,168],{"_36":184,"_13":185,"_39":186,"_41":169,"_42":43,"_44":170,"_46":47,"_48":187,"_17":50,"_51":93,"_52":188,"_54":55,"_56":-5,"_82":189,"_18":190},{"_36":176,"_13":177,"_39":178,"_41":169,"_42":43,"_44":179,"_46":47,"_48":180,"_17":50,"_51":93,"_52":181,"_54":55,"_56":-5,"_82":182,"_18":183},"a9b99ecc-3393-11f0-add9-9e149126039e","validators.ts","a9b99f80-3393-11f0-add9-9e149126039e",7,["D",1747536974917],"import { Currency, UserType, LimitType, TransactionType, IDType } from \"../../shared/types.ts\";\nimport { getTransactionLimit } from \"../database/queries.ts\";\n\n// Validate email format\nexport function isValidEmail(email: string): boolean {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return emailRegex.test(email);\n}\n\n// Validate password strength\nexport function isValidPassword(password: string): boolean {\n // At least 8 characters, with at least one letter and one number\n return password.length >= 8 && /[A-Za-z]/.test(password) && /[0-9]/.test(password);\n}\n\n// Validate currency\nexport function isValidCurrency(currency: string): boolean {\n return [\"USD\", \"GBP\", \"NGN\"].includes(currency);\n}\n\n// Validate amount format and value\nexport function isValidAmount(amount: string): boolean {\n // Amount must be a positive number\n const numAmount = parseFloat(amount);\n return !isNaN(numAmount) && numAmount > 0;\n}\n\n// Validate transaction against limits\nexport async function isWithinTransactionLimits(\n userType: UserType,\n amount: string,\n limitType: LimitType\n): Promise {\n const limit = await getTransactionLimit(userType, limitType);\n \n if (!limit) {\n return false;\n }\n \n return parseFloat(amount) <= parseFloat(limit.amount);\n}\n\n// Validate ID type\nexport function isValidIDType(idType: string): boolean {\n return [\"passport\", \"drivers_license\", \"national_id\"].includes(idType);\n}\n\n// Generate a random account number for demo purposes\nexport function generateAccountNumber(): string {\n return Math.floor(1000000000 + Math.random() * 9000000000).toString();\n}\n\n// Get bank name based on currency\nexport function getBankName(currency: Currency): string {\n switch (currency) {\n case \"USD\":\n return \"Wells USD Bank (Demo)\";\n case \"GBP\":\n return \"Barclays GBP Bank (Demo)\";\n case \"NGN\":\n return \"Access NGN Bank (Demo)\";\n default:\n return \"Demo Bank\";\n }\n}",[],[72,168,177],"a2c6969c-3393-11f0-a9af-9e149126039e","exchange-rates.ts","a2c69732-3393-11f0-a9af-9e149126039e",["D",1747536963257],"import { Currency, ExchangeRate } from \"../../shared/types.ts\";\n\n// Simulated exchange rates\n// In a real application, these would be fetched from an external API\nconst exchangeRates: ExchangeRate[] = [\n { from_currency: \"USD\", to_currency: \"GBP\", rate: 0.78 },\n { from_currency: \"USD\", to_currency: \"NGN\", rate: 1400 },\n { from_currency: \"GBP\", to_currency: \"USD\", rate: 1.28 },\n { from_currency: \"GBP\", to_currency: \"NGN\", rate: 1800 },\n { from_currency: \"NGN\", to_currency: \"USD\", rate: 0.00071 },\n { from_currency: \"NGN\", to_currency: \"GBP\", rate: 0.00056 }\n];\n\n// Get exchange rate between two currencies\nexport function getExchangeRate(fromCurrency: Currency, toCurrency: Currency): number {\n // If same currency, rate is 1\n if (fromCurrency === toCurrency) {\n return 1;\n }\n \n // Find the exchange rate\n const rate = exchangeRates.find(\n rate => rate.from_currency === fromCurrency && rate.to_currency === toCurrency\n );\n \n if (!rate) {\n throw new Error(`Exchange rate not found for ${fromCurrency} to ${toCurrency}`);\n }\n \n return rate.rate;\n}\n\n// Convert amount between currencies\nexport function convertCurrency(\n amount: string,\n fromCurrency: Currency,\n toCurrency: Currency\n): string {\n const rate = getExchangeRate(fromCurrency, toCurrency);\n const convertedAmount = parseFloat(amount) * rate;\n \n // Round to 2 decimal places for USD and GBP, 0 decimal places for NGN\n if (toCurrency === \"NGN\") {\n return Math.round(convertedAmount).toString();\n } else {\n return convertedAmount.toFixed(2);\n }\n}\n\n// Format exchange rate for display\nexport function formatExchangeRate(\n fromCurrency: Currency,\n toCurrency: Currency\n): string {\n const rate = getExchangeRate(fromCurrency, toCurrency);\n \n return `1 ${fromCurrency} = ${rate} ${toCurrency}`;\n}",[],[72,168,185],"b2df6c52-3393-11f0-9695-9e149126039e","routes","3db12730-1316-4050-bb23-5a399c00099c",8,["D",1747536990244],[198,199,200,201,202,203],[72,192],{"_36":244,"_13":245,"_39":246,"_41":193,"_42":43,"_44":194,"_46":47,"_48":247,"_17":50,"_51":93,"_52":248,"_54":55,"_56":-5,"_82":249,"_18":250},{"_36":236,"_13":237,"_39":238,"_41":193,"_42":43,"_44":239,"_46":47,"_48":240,"_17":50,"_51":93,"_52":241,"_54":55,"_56":-5,"_82":242,"_18":243},{"_36":228,"_13":229,"_39":230,"_41":193,"_42":43,"_44":231,"_46":47,"_48":232,"_17":50,"_51":93,"_52":233,"_54":55,"_56":-5,"_82":234,"_18":235},{"_36":220,"_13":221,"_39":222,"_41":193,"_42":43,"_44":223,"_46":47,"_48":224,"_17":50,"_51":93,"_52":225,"_54":55,"_56":-5,"_82":226,"_18":227},{"_36":212,"_13":213,"_39":214,"_41":193,"_42":43,"_44":215,"_46":47,"_48":216,"_17":50,"_51":93,"_52":217,"_54":55,"_56":-5,"_82":218,"_18":219},{"_36":204,"_13":205,"_39":206,"_41":193,"_42":43,"_44":207,"_46":47,"_48":208,"_17":50,"_51":93,"_52":209,"_54":55,"_56":-5,"_82":210,"_18":211},"e43404fc-3393-11f0-8dfa-9e149126039e","webhooks.ts","e43405b0-3393-11f0-8dfa-9e149126039e",13,["D",1747537073025],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getWalletById,\n updateWalletBalance,\n createTransaction\n} from \"../database/queries.ts\";\nimport { WebhookEvent, Currency } from \"../../shared/types.ts\";\n\nconst webhookRoutes = new Hono();\n\n// Receive webhook events from BaaS partners (simulated)\nwebhookRoutes.post(\"/receive\", async (c) => {\n try {\n const payload = await c.req.json() as WebhookEvent;\n \n // Validate webhook payload\n if (!payload.event || !payload.currency || !payload.amount || !payload.wallet_id || !payload.user_id) {\n return c.json({ error: \"Invalid webhook payload\" }, 400);\n }\n \n // Process different event types\n switch (payload.event) {\n case \"payment.received\":\n await processPaymentReceived(payload);\n break;\n case \"payment.failed\":\n await processPaymentFailed(payload);\n break;\n case \"account.verified\":\n await processAccountVerified(payload);\n break;\n default:\n return c.json({ error: \"Unsupported event type\" }, 400);\n }\n \n return c.json({ status: \"processed\" });\n } catch (error) {\n console.error(\"Webhook processing error:\", error);\n return c.json({ error: \"Failed to process webhook\" }, 500);\n }\n});\n\n// Process payment received event\nasync function processPaymentReceived(payload: WebhookEvent) {\n // Get the wallet\n const wallet = await getWalletById(payload.wallet_id);\n \n if (!wallet) {\n throw new Error(`Wallet not found: ${payload.wallet_id}`);\n }\n \n // Update wallet balance\n const newBalance = (parseFloat(wallet.balance) + parseFloat(payload.amount)).toFixed(2);\n await updateWalletBalance(wallet.id, newBalance);\n \n // Create transaction record\n await createTransaction(\n payload.user_id,\n \"deposit\",\n payload.currency as Currency,\n payload.amount,\n \"completed\",\n undefined,\n wallet.id\n );\n}\n\n// Process payment failed event\nasync function processPaymentFailed(payload: WebhookEvent) {\n // Create failed transaction record\n await createTransaction(\n payload.user_id,\n \"deposit\",\n payload.currency as Currency,\n payload.amount,\n \"failed\",\n undefined,\n payload.wallet_id\n );\n}\n\n// Process account verified event\nasync function processAccountVerified(payload: WebhookEvent) {\n // In a real application, this would update the user's verification status\n console.log(`Account verified for user: ${payload.user_id}`);\n}\n\nexport default webhookRoutes;",[],[72,192,205],"c79cd030-3393-11f0-be2d-9e149126039e","wallets.ts","c79cd0e4-3393-11f0-be2d-9e149126039e",10,["D",1747537025060],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createWallet, \n getWalletsByUserId, \n getWalletByUserIdAndCurrency,\n updateWalletBalance,\n createTransaction\n} from \"../database/queries.ts\";\nimport { authMiddleware } from \"../middleware/auth.ts\";\nimport { \n isValidCurrency, \n isValidAmount, \n generateAccountNumber, \n getBankName \n} from \"../utils/validators.ts\";\nimport { \n convertCurrency, \n formatExchangeRate \n} from \"../utils/exchange-rates.ts\";\nimport { User, Currency } from \"../../shared/types.ts\";\n\nconst walletRoutes = new Hono();\n\n// Apply authentication middleware to all wallet routes\nwalletRoutes.use(\"*\", authMiddleware);\n\n// Create a new wallet\nwalletRoutes.post(\"/create\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n const { currency } = await c.req.json();\n \n // Validate currency\n if (!currency || !isValidCurrency(currency)) {\n return c.json({ error: \"Invalid currency\" }, 400);\n }\n \n // Check if wallet already exists\n const existingWallet = await getWalletByUserIdAndCurrency(user.id, currency as Currency);\n if (existingWallet) {\n return c.json({ \n error: \"Wallet already exists for this currency\",\n wallet_id: existingWallet.id,\n currency: existingWallet.currency,\n account_number: existingWallet.account_number,\n bank_name: existingWallet.bank_name\n }, 409);\n }\n \n // Generate account number and bank name\n const accountNumber = generateAccountNumber();\n const bankName = getBankName(currency as Currency);\n \n // Create wallet\n const walletId = await createWallet(user.id, currency as Currency, accountNumber, bankName);\n \n return c.json({\n wallet_id: walletId,\n currency,\n account_number: accountNumber,\n bank_name: bankName\n });\n } catch (error) {\n console.error(\"Wallet creation error:\", error);\n return c.json({ error: \"Failed to create wallet\" }, 500);\n }\n});\n\n// Get all wallets\nwalletRoutes.get(\"/\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n \n // Get wallets\n const wallets = await getWalletsByUserId(user.id);\n \n // Format response\n const response = wallets.map(wallet => ({\n currency: wallet.currency,\n balance: wallet.balance\n }));\n \n return c.json(response);\n } catch (error) {\n console.error(\"Get wallets error:\", error);\n return c.json({ error: \"Failed to get wallets\" }, 500);\n }\n});\n\n// Get wallet details\nwalletRoutes.get(\"/details\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n \n // Get wallets\n const wallets = await getWalletsByUserId(user.id);\n \n // Format response with full details\n const response = wallets.map(wallet => ({\n wallet_id: wallet.id,\n currency: wallet.currency,\n balance: wallet.balance,\n account_number: wallet.account_number,\n bank_name: wallet.bank_name,\n created_at: wallet.created_at\n }));\n \n return c.json(response);\n } catch (error) {\n console.error(\"Get wallet details error:\", error);\n return c.json({ error: \"Failed to get wallet details\" }, 500);\n }\n});\n\n// Transfer between wallets (currency exchange)\nwalletRoutes.post(\"/transfer\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n const { from_currency, to_currency, amount } = await c.req.json();\n \n // Validate input\n if (!from_currency || !to_currency || !amount) {\n return c.json({ error: \"From currency, to currency, and amount are required\" }, 400);\n }\n \n if (!isValidCurrency(from_currency) || !isValidCurrency(to_currency)) {\n return c.json({ error: \"Invalid currency\" }, 400);\n }\n \n if (!isValidAmount(amount)) {\n return c.json({ error: \"Invalid amount\" }, 400);\n }\n \n // Get source wallet\n const sourceWallet = await getWalletByUserIdAndCurrency(user.id, from_currency as Currency);\n if (!sourceWallet) {\n return c.json({ error: `You don't have a ${from_currency} wallet` }, 404);\n }\n \n // Check if source wallet has enough balance\n if (parseFloat(sourceWallet.balance) < parseFloat(amount)) {\n return c.json({ error: \"Insufficient balance\" }, 400);\n }\n \n // Get destination wallet\n const destWallet = await getWalletByUserIdAndCurrency(user.id, to_currency as Currency);\n if (!destWallet) {\n return c.json({ error: `You don't have a ${to_currency} wallet` }, 404);\n }\n \n // Convert currency\n const convertedAmount = convertCurrency(\n amount,\n from_currency as Currency,\n to_currency as Currency\n );\n \n // Update source wallet balance\n const newSourceBalance = (parseFloat(sourceWallet.balance) - parseFloat(amount)).toFixed(2);\n await updateWalletBalance(sourceWallet.id, newSourceBalance);\n \n // Update destination wallet balance\n const newDestBalance = (parseFloat(destWallet.balance) + parseFloat(convertedAmount)).toFixed(2);\n await updateWalletBalance(destWallet.id, newDestBalance);\n \n // Create transaction record\n await createTransaction(\n user.id,\n \"exchange\",\n from_currency as Currency,\n amount,\n \"completed\",\n sourceWallet.id,\n destWallet.id\n );\n \n // Get exchange rate for display\n const rateUsed = formatExchangeRate(\n from_currency as Currency,\n to_currency as Currency\n );\n \n // Get updated wallets\n const updatedSourceWallet = await getWalletByUserIdAndCurrency(user.id, from_currency as Currency);\n const updatedDestWallet = await getWalletByUserIdAndCurrency(user.id, to_currency as Currency);\n \n // Create response\n const newBalances: Record = {\n USD: \"0\",\n GBP: \"0\",\n NGN: \"0\"\n };\n \n if (updatedSourceWallet) {\n newBalances[from_currency as Currency] = updatedSourceWallet.balance;\n }\n \n if (updatedDestWallet) {\n newBalances[to_currency as Currency] = updatedDestWallet.balance;\n }\n \n return c.json({\n message: \"Transfer successful\",\n rate_used: rateUsed,\n new_balances: newBalances\n });\n } catch (error) {\n console.error(\"Wallet transfer error:\", error);\n return c.json({ error: \"Failed to transfer between wallets\" }, 500);\n }\n});\n\nexport default walletRoutes;",[],[72,192,213],"d444fed4-3393-11f0-8100-9e149126039e","transactions.ts","d444ff88-3393-11f0-8100-9e149126039e",11,["D",1747537046290],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getTransactionsByUserId,\n createTransaction,\n getUserByEmail,\n getWalletByUserIdAndCurrency,\n updateWalletBalance,\n getTransactionLimit\n} from \"../database/queries.ts\";\nimport { authMiddleware } from \"../middleware/auth.ts\";\nimport { isValidCurrency, isValidAmount } from \"../utils/validators.ts\";\nimport { User, Currency } from \"../../shared/types.ts\";\n\nconst transactionRoutes = new Hono();\n\n// Apply authentication middleware to all transaction routes\ntransactionRoutes.use(\"*\", authMiddleware);\n\n// Get transaction history\ntransactionRoutes.get(\"/\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n \n // Get transactions\n const transactions = await getTransactionsByUserId(user.id);\n \n // Format response\n const response = transactions.map(txn => ({\n txn_id: txn.id,\n type: txn.type,\n currency: txn.currency,\n amount: txn.amount,\n status: txn.status,\n date: new Date(txn.created_at).toISOString().split('T')[0]\n }));\n \n return c.json(response);\n } catch (error) {\n console.error(\"Get transactions error:\", error);\n return c.json({ error: \"Failed to get transactions\" }, 500);\n }\n});\n\n// Send money to another user\ntransactionRoutes.post(\"/send\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n const { to_email, currency, amount } = await c.req.json();\n \n // Validate input\n if (!to_email || !currency || !amount) {\n return c.json({ error: \"Recipient email, currency, and amount are required\" }, 400);\n }\n \n if (!isValidCurrency(currency)) {\n return c.json({ error: \"Invalid currency\" }, 400);\n }\n \n if (!isValidAmount(amount)) {\n return c.json({ error: \"Invalid amount\" }, 400);\n }\n \n // Check if recipient exists\n const recipient = await getUserByEmail(to_email);\n if (!recipient) {\n return c.json({ error: \"Recipient not found\" }, 404);\n }\n \n // Prevent sending to self\n if (recipient.id === user.id) {\n return c.json({ error: \"Cannot send money to yourself\" }, 400);\n }\n \n // Get sender's wallet\n const senderWallet = await getWalletByUserIdAndCurrency(user.id, currency as Currency);\n if (!senderWallet) {\n return c.json({ error: `You don't have a ${currency} wallet` }, 404);\n }\n \n // Check if sender has enough balance\n if (parseFloat(senderWallet.balance) < parseFloat(amount)) {\n return c.json({ error: \"Insufficient balance\" }, 400);\n }\n \n // Check transaction limits\n const singleTxnLimit = await getTransactionLimit(user.user_type, \"single_transaction\");\n if (singleTxnLimit && parseFloat(amount) > parseFloat(singleTxnLimit.amount)) {\n return c.json({ \n error: `Transaction exceeds your single transaction limit of ${singleTxnLimit.amount} ${currency}` \n }, 400);\n }\n \n // Get recipient's wallet\n const recipientWallet = await getWalletByUserIdAndCurrency(recipient.id, currency as Currency);\n if (!recipientWallet) {\n return c.json({ error: `Recipient doesn't have a ${currency} wallet` }, 404);\n }\n \n // Update sender's wallet balance\n const newSenderBalance = (parseFloat(senderWallet.balance) - parseFloat(amount)).toFixed(2);\n await updateWalletBalance(senderWallet.id, newSenderBalance);\n \n // Update recipient's wallet balance\n const newRecipientBalance = (parseFloat(recipientWallet.balance) + parseFloat(amount)).toFixed(2);\n await updateWalletBalance(recipientWallet.id, newRecipientBalance);\n \n // Create transaction record for sender\n const txnId = await createTransaction(\n user.id,\n \"send\",\n currency as Currency,\n amount,\n \"completed\",\n senderWallet.id,\n recipientWallet.id,\n recipient.id\n );\n \n // Create transaction record for recipient\n await createTransaction(\n recipient.id,\n \"receive\",\n currency as Currency,\n amount,\n \"completed\",\n senderWallet.id,\n recipientWallet.id,\n user.id\n );\n \n return c.json({\n message: \"Sent successfully\",\n txn_id: txnId\n });\n } catch (error) {\n console.error(\"Send money error:\", error);\n return c.json({ error: \"Failed to send money\" }, 500);\n }\n});\n\nexport default transactionRoutes;",[],[72,192,221],"dcd077d6-3393-11f0-aa59-9e149126039e","limits.ts","dcd07876-3393-11f0-aa59-9e149126039e",12,["D",1747537060631],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n setTransactionLimit,\n getAllTransactionLimits\n} from \"../database/queries.ts\";\nimport { authMiddleware } from \"../middleware/auth.ts\";\nimport { isValidAmount } from \"../utils/validators.ts\";\nimport { User, UserType, LimitType } from \"../../shared/types.ts\";\n\nconst limitRoutes = new Hono();\n\n// Apply authentication middleware to all limit routes\nlimitRoutes.use(\"*\", authMiddleware);\n\n// Set transaction limit\nlimitRoutes.post(\"/set-limit\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n const { user_type, limit_type, amount } = await c.req.json();\n \n // Only allow admin users to set limits (for demo, we'll allow any verified user)\n if (user.user_type !== \"verified\" && user.user_type !== \"premium\") {\n return c.json({ error: \"Only verified users can set limits\" }, 403);\n }\n \n // Validate input\n if (!user_type || !limit_type || !amount) {\n return c.json({ error: \"User type, limit type, and amount are required\" }, 400);\n }\n \n if (![\"basic\", \"verified\", \"premium\"].includes(user_type)) {\n return c.json({ error: \"Invalid user type\" }, 400);\n }\n \n if (![\"daily_transfer\", \"single_transaction\", \"monthly_transfer\"].includes(limit_type)) {\n return c.json({ error: \"Invalid limit type\" }, 400);\n }\n \n if (!isValidAmount(amount)) {\n return c.json({ error: \"Invalid amount\" }, 400);\n }\n \n // Set the limit\n await setTransactionLimit(\n user_type as UserType,\n limit_type as LimitType,\n amount\n );\n \n return c.json({ message: \"Limit set successfully\" });\n } catch (error) {\n console.error(\"Set limit error:\", error);\n return c.json({ error: \"Failed to set limit\" }, 500);\n }\n});\n\n// Get all transaction limits\nlimitRoutes.get(\"/\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n \n // Get all limits\n const limits = await getAllTransactionLimits();\n \n // Format response\n const response = limits.map(limit => ({\n user_type: limit.user_type,\n limit_type: limit.limit_type,\n amount: limit.amount\n }));\n \n return c.json(response);\n } catch (error) {\n console.error(\"Get limits error:\", error);\n return c.json({ error: \"Failed to get limits\" }, 500);\n }\n});\n\nexport default limitRoutes;",[],[72,192,229],"b96d66dc-3393-11f0-8530-9e149126039e","kyc.ts","b96d6786-3393-11f0-8530-9e149126039e",9,["D",1747537001261],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { submitKYC, getKYCByUserId } from \"../database/queries.ts\";\nimport { authMiddleware } from \"../middleware/auth.ts\";\nimport { isValidIDType } from \"../utils/validators.ts\";\nimport { User } from \"../../shared/types.ts\";\n\nconst kycRoutes = new Hono();\n\n// Apply authentication middleware to all KYC routes\nkycRoutes.use(\"*\", authMiddleware);\n\n// Submit KYC data\nkycRoutes.post(\"/\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n const { full_name, id_type, id_number, photo_url } = await c.req.json();\n \n // Validate input\n if (!full_name || !id_type || !id_number || !photo_url) {\n return c.json({ error: \"All KYC fields are required\" }, 400);\n }\n \n if (!isValidIDType(id_type)) {\n return c.json({ error: \"Invalid ID type\" }, 400);\n }\n \n // Check if KYC already submitted\n const existingKYC = await getKYCByUserId(user.id);\n if (existingKYC) {\n return c.json({ \n error: \"KYC already submitted\", \n status: existingKYC.status \n }, 409);\n }\n \n // Submit KYC\n await submitKYC(user.id, full_name, id_type, id_number, photo_url);\n \n return c.json({ status: \"pending_verification\" });\n } catch (error) {\n console.error(\"KYC submission error:\", error);\n return c.json({ error: \"Failed to submit KYC\" }, 500);\n }\n});\n\n// Get KYC status\nkycRoutes.get(\"/status\", async (c) => {\n try {\n const user = c.get(\"user\") as User;\n \n // Get KYC data\n const kycData = await getKYCByUserId(user.id);\n \n if (!kycData) {\n return c.json({ status: \"not_submitted\" });\n }\n \n return c.json({ \n status: kycData.status,\n submitted_at: kycData.submitted_at,\n verified_at: kycData.verified_at\n });\n } catch (error) {\n console.error(\"KYC status error:\", error);\n return c.json({ error: \"Failed to get KYC status\" }, 500);\n }\n});\n\nexport default kycRoutes;",[],[72,192,237],"b2df3bc4-3393-11f0-9695-9e149126039e","auth.ts","b2df3c5a-3393-11f0-9695-9e149126039e",["D",1747536990244],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createUser, getUserByEmail } from \"../database/queries.ts\";\nimport { generateToken } from \"../middleware/auth.ts\";\nimport { isValidEmail, isValidPassword } from \"../utils/validators.ts\";\nimport { hash, compare } from \"https://esm.sh/bcryptjs@2.4.3\";\n\nconst authRoutes = new Hono();\n\n// Register a new user\nauthRoutes.post(\"/register\", async (c) => {\n try {\n const { name, email, password } = await c.req.json();\n \n // Validate input\n if (!name || !email || !password) {\n return c.json({ error: \"Name, email, and password are required\" }, 400);\n }\n \n if (!isValidEmail(email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n \n if (!isValidPassword(password)) {\n return c.json({ error: \"Password must be at least 8 characters with at least one letter and one number\" }, 400);\n }\n \n // Check if user already exists\n const existingUser = await getUserByEmail(email);\n if (existingUser) {\n return c.json({ error: \"User with this email already exists\" }, 409);\n }\n \n // Hash the password\n const passwordHash = await hash(password, 10);\n \n // Create the user\n const userId = await createUser(name, email, passwordHash);\n \n return c.json({ message: \"User registered\", user_id: userId }, 201);\n } catch (error) {\n console.error(\"Registration error:\", error);\n return c.json({ error: \"Failed to register user\" }, 500);\n }\n});\n\n// Login a user\nauthRoutes.post(\"/login\", async (c) => {\n try {\n const { email, password } = await c.req.json();\n \n // Validate input\n if (!email || !password) {\n return c.json({ error: \"Email and password are required\" }, 400);\n }\n \n // Get the user\n const user = await getUserByEmail(email);\n if (!user) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Verify the password\n const isPasswordValid = await compare(password, user.password_hash);\n if (!isPasswordValid) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Generate a JWT token\n const token = generateToken(user.id);\n \n return c.json({ token, user_id: user.id });\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({ error: \"Failed to login\" }, 500);\n }\n});\n\nexport default authRoutes;",[],[72,192,245],"9b3b32a2-3393-11f0-86a1-9e149126039e","middleware","1638c048-0eaa-4dc4-a2c5-e814b47b8019",5,["D",1747536950599],[258],[72,252],{"_36":259,"_13":245,"_39":260,"_41":253,"_42":43,"_44":254,"_46":47,"_48":261,"_17":50,"_51":93,"_52":262,"_54":55,"_56":-5,"_82":263,"_18":264},"9b3b12a4-3393-11f0-86a1-9e149126039e","9b3b133a-3393-11f0-86a1-9e149126039e",["D",1747536950599],"import { Context, Next } from \"https://esm.sh/hono@3.11.7\";\nimport { getUserById } from \"../database/queries.ts\";\nimport { verify } from \"https://esm.sh/jsonwebtoken@9.0.2\";\n\n// JWT secret key (in production, use environment variable)\nconst JWT_SECRET = \"finance-platform-secret-key\";\n\n// Authentication middleware\nexport async function authMiddleware(c: Context, next: Next) {\n try {\n // Get the authorization header\n const authHeader = c.req.header(\"Authorization\");\n \n if (!authHeader || !authHeader.startsWith(\"Bearer \")) {\n return c.json({ error: \"Unauthorized: No token provided\" }, 401);\n }\n \n // Extract the token\n const token = authHeader.split(\" \")[1];\n \n // Verify the token\n const decoded = verify(token, JWT_SECRET) as { userId: string };\n \n if (!decoded || !decoded.userId) {\n return c.json({ error: \"Unauthorized: Invalid token\" }, 401);\n }\n \n // Get the user from the database\n const user = await getUserById(decoded.userId);\n \n if (!user) {\n return c.json({ error: \"Unauthorized: User not found\" }, 401);\n }\n \n // Set the user in the context\n c.set(\"user\", user);\n \n // Continue to the next middleware or route handler\n await next();\n } catch (error) {\n console.error(\"Authentication error:\", error);\n return c.json({ error: \"Unauthorized: Invalid token\" }, 401);\n }\n}\n\n// Generate JWT token\nexport function generateToken(userId: string): string {\n return sign({ userId }, JWT_SECRET, { expiresIn: \"7d\" });\n}\n\n// Import sign function from jsonwebtoken\nimport { sign } from \"https://esm.sh/jsonwebtoken@9.0.2\";",[],[72,252,245],"82a0a740-3393-11f0-b5d7-9e149126039e","database","b0d94028-941b-4769-bf7a-289fdd01caeb",["D",1747536909321],[271,272],[72,266],{"_36":280,"_13":281,"_39":282,"_41":267,"_42":43,"_44":283,"_46":47,"_48":284,"_17":50,"_51":93,"_52":285,"_54":55,"_56":-5,"_82":286,"_18":287},{"_36":273,"_13":274,"_39":275,"_41":267,"_42":43,"_44":74,"_46":47,"_48":276,"_17":50,"_51":93,"_52":277,"_54":55,"_56":-5,"_82":278,"_18":279},"82a07c98-3393-11f0-b5d7-9e149126039e","schema.ts","82a07d74-3393-11f0-b5d7-9e149126039e",["D",1747536909321],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database tables\nconst USERS_TABLE = \"finance_users\";\nconst WALLETS_TABLE = \"finance_wallets\";\nconst TRANSACTIONS_TABLE = \"finance_transactions\";\nconst KYC_TABLE = \"finance_kyc_data\";\nconst LIMITS_TABLE = \"finance_transaction_limits\";\n\n// Initialize database schema\nexport async function initializeDatabase() {\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 email TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n user_type TEXT NOT NULL DEFAULT 'basic',\n kyc_status TEXT NOT NULL DEFAULT 'not_submitted',\n created_at TEXT NOT NULL\n )\n `);\n\n // Create wallets table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${WALLETS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n currency TEXT NOT NULL,\n balance TEXT NOT NULL DEFAULT '0',\n account_number TEXT NOT NULL,\n bank_name TEXT NOT NULL,\n created_at TEXT NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n UNIQUE (user_id, currency)\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 type TEXT NOT NULL,\n currency TEXT NOT NULL,\n amount TEXT NOT NULL,\n from_wallet_id TEXT,\n to_wallet_id TEXT,\n to_user_id TEXT,\n status TEXT NOT NULL,\n created_at TEXT NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n FOREIGN KEY (from_wallet_id) REFERENCES ${WALLETS_TABLE} (id),\n FOREIGN KEY (to_wallet_id) REFERENCES ${WALLETS_TABLE} (id),\n FOREIGN KEY (to_user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n\n // Create KYC data table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KYC_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n full_name TEXT NOT NULL,\n id_type TEXT NOT NULL,\n id_number TEXT NOT NULL,\n photo_url TEXT NOT NULL,\n status TEXT NOT NULL,\n submitted_at TEXT NOT NULL,\n verified_at TEXT,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n UNIQUE (user_id)\n )\n `);\n\n // Create transaction limits table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${LIMITS_TABLE} (\n id TEXT PRIMARY KEY,\n user_type TEXT NOT NULL,\n limit_type TEXT NOT NULL,\n amount TEXT NOT NULL,\n created_at TEXT NOT NULL,\n UNIQUE (user_type, limit_type)\n )\n `);\n\n // Insert default transaction limits\n const defaultLimits = [\n { user_type: 'basic', limit_type: 'daily_transfer', amount: '1000' },\n { user_type: 'basic', limit_type: 'single_transaction', amount: '500' },\n { user_type: 'basic', limit_type: 'monthly_transfer', amount: '5000' },\n { user_type: 'verified', limit_type: 'daily_transfer', amount: '5000' },\n { user_type: 'verified', limit_type: 'single_transaction', amount: '2000' },\n { user_type: 'verified', limit_type: 'monthly_transfer', amount: '20000' },\n { user_type: 'premium', limit_type: 'daily_transfer', amount: '10000' },\n { user_type: 'premium', limit_type: 'single_transaction', amount: '5000' },\n { user_type: 'premium', limit_type: 'monthly_transfer', amount: '50000' }\n ];\n\n for (const limit of defaultLimits) {\n try {\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${LIMITS_TABLE} (id, user_type, limit_type, amount, created_at)\n VALUES (?, ?, ?, ?, ?)\n `, [\n crypto.randomUUID(),\n limit.user_type,\n limit.limit_type,\n limit.amount,\n new Date().toISOString()\n ]);\n } catch (error) {\n console.error(`Error inserting default limit: ${error}`);\n }\n }\n}\n\n// Export table names\nexport {\n USERS_TABLE,\n WALLETS_TABLE,\n TRANSACTIONS_TABLE,\n KYC_TABLE,\n LIMITS_TABLE\n};",[],[72,266,274],"9555043a-3393-11f0-80b9-9e149126039e","queries.ts","955504e4-3393-11f0-80b9-9e149126039e",4,["D",1747536940703],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport {\n User,\n Wallet,\n Transaction,\n KYCData,\n TransactionLimit,\n Currency,\n UserType,\n LimitType,\n KYCStatus,\n TransactionType,\n TransactionStatus,\n IDType\n} from \"../../shared/types.ts\";\nimport {\n USERS_TABLE,\n WALLETS_TABLE,\n TRANSACTIONS_TABLE,\n KYC_TABLE,\n LIMITS_TABLE\n} from \"./schema.ts\";\n\n// User queries\nexport async function createUser(\n name: string,\n email: string,\n passwordHash: string\n): Promise {\n const userId = crypto.randomUUID();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, name, email, password_hash, user_type, kyc_status, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [userId, name, email, passwordHash, \"basic\", \"not_submitted\", now]\n );\n\n return userId;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE email = ?`,\n [email]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return result.rows[0] as User;\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return result.rows[0] as User;\n}\n\nexport async function updateUserKYCStatus(\n userId: string,\n status: KYCStatus\n): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET kyc_status = ? WHERE id = ?`,\n [status, userId]\n );\n}\n\nexport async function updateUserType(\n userId: string,\n userType: UserType\n): Promise {\n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET user_type = ? WHERE id = ?`,\n [userType, userId]\n );\n}\n\n// Wallet queries\nexport async function createWallet(\n userId: string,\n currency: Currency,\n accountNumber: string,\n bankName: string\n): Promise {\n const walletId = crypto.randomUUID();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${WALLETS_TABLE} (id, user_id, currency, balance, account_number, bank_name, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [walletId, userId, currency, \"0\", accountNumber, bankName, now]\n );\n\n return walletId;\n}\n\nexport async function getWalletsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${WALLETS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n\n return result.rows as Wallet[];\n}\n\nexport async function getWalletByUserIdAndCurrency(\n userId: string,\n currency: Currency\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${WALLETS_TABLE} WHERE user_id = ? AND currency = ?`,\n [userId, currency]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return result.rows[0] as Wallet;\n}\n\nexport async function getWalletById(walletId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${WALLETS_TABLE} WHERE id = ?`,\n [walletId]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return result.rows[0] as Wallet;\n}\n\nexport async function updateWalletBalance(\n walletId: string,\n newBalance: string\n): Promise {\n await sqlite.execute(\n `UPDATE ${WALLETS_TABLE} SET balance = ? WHERE id = ?`,\n [newBalance, walletId]\n );\n}\n\n// Transaction queries\nexport async function createTransaction(\n userId: string,\n type: TransactionType,\n currency: Currency,\n amount: string,\n status: TransactionStatus,\n fromWalletId?: string,\n toWalletId?: string,\n toUserId?: string\n): Promise {\n const transactionId = crypto.randomUUID();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS_TABLE} (id, user_id, type, currency, amount, from_wallet_id, to_wallet_id, to_user_id, status, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [transactionId, userId, type, currency, amount, fromWalletId, toWalletId, toUserId, status, now]\n );\n\n return transactionId;\n}\n\nexport async function getTransactionsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS_TABLE} WHERE user_id = ? OR to_user_id = ? ORDER BY created_at DESC`,\n [userId, userId]\n );\n\n return result.rows as Transaction[];\n}\n\nexport async function getTransactionById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS_TABLE} WHERE id = ?`,\n [id]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return result.rows[0] as Transaction;\n}\n\n// KYC queries\nexport async function submitKYC(\n userId: string,\n fullName: string,\n idType: IDType,\n idNumber: string,\n photoUrl: string\n): Promise {\n const kycId = crypto.randomUUID();\n const now = new Date().toISOString();\n\n await sqlite.execute(\n `INSERT INTO ${KYC_TABLE} (id, user_id, full_name, id_type, id_number, photo_url, status, submitted_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [kycId, userId, fullName, idType, idNumber, photoUrl, \"pending_verification\", now]\n );\n\n // Update user KYC status\n await updateUserKYCStatus(userId, \"pending_verification\");\n\n return kycId;\n}\n\nexport async function getKYCByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${KYC_TABLE} WHERE user_id = ?`,\n [userId]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return result.rows[0] as KYCData;\n}\n\nexport async function updateKYCStatus(\n kycId: string,\n status: KYCStatus\n): Promise {\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `UPDATE ${KYC_TABLE} SET status = ?, verified_at = ? WHERE id = ?`,\n [status, status === \"verified\" ? now : null, kycId]\n );\n\n // Get the user ID for this KYC\n const result = await sqlite.execute(\n `SELECT user_id FROM ${KYC_TABLE} WHERE id = ?`,\n [kycId]\n );\n\n if (result.rows.length > 0) {\n const userId = result.rows[0].user_id;\n \n // Update user KYC status\n await updateUserKYCStatus(userId, status);\n \n // If verified, upgrade user to verified status\n if (status === \"verified\") {\n await updateUserType(userId, \"verified\");\n }\n }\n}\n\n// Transaction limits queries\nexport async function setTransactionLimit(\n userType: UserType,\n limitType: LimitType,\n amount: string\n): Promise {\n const now = new Date().toISOString();\n \n // Check if limit exists\n const existingLimit = await getTransactionLimit(userType, limitType);\n \n if (existingLimit) {\n // Update existing limit\n await sqlite.execute(\n `UPDATE ${LIMITS_TABLE} SET amount = ? WHERE user_type = ? AND limit_type = ?`,\n [amount, userType, limitType]\n );\n } else {\n // Create new limit\n const limitId = crypto.randomUUID();\n \n await sqlite.execute(\n `INSERT INTO ${LIMITS_TABLE} (id, user_type, limit_type, amount, created_at)\n VALUES (?, ?, ?, ?, ?)`,\n [limitId, userType, limitType, amount, now]\n );\n }\n}\n\nexport async function getTransactionLimit(\n userType: UserType,\n limitType: LimitType\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${LIMITS_TABLE} WHERE user_type = ? AND limit_type = ?`,\n [userType, limitType]\n );\n\n if (result.rows.length === 0) {\n return null;\n }\n\n return result.rows[0] as TransactionLimit;\n}\n\nexport async function getAllTransactionLimits(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${LIMITS_TABLE} ORDER BY user_type, limit_type`\n );\n\n return result.rows as TransactionLimit[];\n}",[],[72,266,281],"59edf028-3393-11f0-ac54-9e149126039e",["D",1747536841043],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","180d29bb-29b4-41f4-a984-6297ecbf663d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_340":336},"org",{"_11":12,"_334":-5,"_335":336,"_297":298,"_337":338,"_339":55},"branch",{"_17":131,"_13":16,"_36":43,"_326":288,"_327":-5,"_328":-5,"_329":-5,"_330":-5,"_331":-5,"_332":14,"_333":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":288,"_13":14,"_48":457,"_290":-5,"_291":55,"_292":293,"_294":293,"_295":-5,"_296":-5,"_297":298,"_299":-5,"_300":55,"_301":-5,"_302":-5,"_303":50,"_304":305,"_306":-5,"_307":-5,"_308":-5,"_309":-5,"_310":311,"_312":311,"_313":314,"_315":314,"_316":314,"_317":311,"_318":311,"_319":458,"_321":459,"_323":460,"_325":55},[376,393,400,402],"files",[376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402],"counts",{"_367":50,"_368":45,"_369":50,"_31":370,"_371":372},[359,360,361,362],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_36":71,"_13":72,"_39":73,"_41":-5,"_42":43,"_44":74,"_46":47,"_48":75,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_18":366},{"_36":65,"_13":66,"_39":67,"_41":-5,"_42":43,"_44":68,"_46":47,"_48":69,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_18":365},{"_36":58,"_13":59,"_39":60,"_41":-5,"_42":43,"_44":61,"_46":47,"_48":62,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_18":364},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":24,"_52":53,"_54":55,"_56":-5,"_18":363},[38],[59],[66],[72],"pulls","branches","forks",{"_373":50,"_375":50},"connections",{"_373":50,"_374":50},"count","unfilledCount","emptyCount",{"_36":71,"_13":72,"_39":73,"_41":-5,"_42":43,"_44":74,"_46":47,"_48":151,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":455,"_18":456},{"_36":265,"_13":266,"_39":267,"_41":73,"_42":43,"_44":74,"_46":47,"_48":268,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":453,"_18":454},{"_36":280,"_13":281,"_39":282,"_41":267,"_42":43,"_44":283,"_46":47,"_48":284,"_17":50,"_51":93,"_52":285,"_54":55,"_56":-5,"_82":451,"_18":452},{"_36":273,"_13":274,"_39":275,"_41":267,"_42":43,"_44":74,"_46":47,"_48":276,"_17":50,"_51":93,"_52":277,"_54":55,"_56":-5,"_82":449,"_18":450},{"_36":251,"_13":252,"_39":253,"_41":73,"_42":43,"_44":254,"_46":47,"_48":255,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":447,"_18":448},{"_36":259,"_13":245,"_39":260,"_41":253,"_42":43,"_44":254,"_46":47,"_48":261,"_17":50,"_51":93,"_52":262,"_54":55,"_56":-5,"_82":445,"_18":446},{"_36":191,"_13":192,"_39":193,"_41":73,"_42":43,"_44":194,"_46":47,"_48":195,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":443,"_18":444},{"_36":244,"_13":245,"_39":246,"_41":193,"_42":43,"_44":194,"_46":47,"_48":247,"_17":50,"_51":93,"_52":248,"_54":55,"_56":-5,"_82":441,"_18":442},{"_36":236,"_13":237,"_39":238,"_41":193,"_42":43,"_44":239,"_46":47,"_48":240,"_17":50,"_51":93,"_52":241,"_54":55,"_56":-5,"_82":439,"_18":440},{"_36":228,"_13":229,"_39":230,"_41":193,"_42":43,"_44":231,"_46":47,"_48":232,"_17":50,"_51":93,"_52":233,"_54":55,"_56":-5,"_82":437,"_18":438},{"_36":220,"_13":221,"_39":222,"_41":193,"_42":43,"_44":223,"_46":47,"_48":224,"_17":50,"_51":93,"_52":225,"_54":55,"_56":-5,"_82":435,"_18":436},{"_36":212,"_13":213,"_39":214,"_41":193,"_42":43,"_44":215,"_46":47,"_48":216,"_17":50,"_51":93,"_52":217,"_54":55,"_56":-5,"_82":433,"_18":434},{"_36":204,"_13":205,"_39":206,"_41":193,"_42":43,"_44":207,"_46":47,"_48":208,"_17":50,"_51":93,"_52":209,"_54":55,"_56":-5,"_82":431,"_18":432},{"_36":167,"_13":168,"_39":169,"_41":73,"_42":43,"_44":170,"_46":47,"_48":171,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":429,"_18":430},{"_36":184,"_13":185,"_39":186,"_41":169,"_42":43,"_44":170,"_46":47,"_48":187,"_17":50,"_51":93,"_52":188,"_54":55,"_56":-5,"_82":427,"_18":428},{"_36":176,"_13":177,"_39":178,"_41":169,"_42":43,"_44":179,"_46":47,"_48":180,"_17":50,"_51":93,"_52":181,"_54":55,"_56":-5,"_82":425,"_18":426},{"_36":159,"_13":160,"_39":161,"_41":73,"_42":43,"_44":162,"_46":47,"_48":163,"_17":50,"_51":93,"_52":164,"_54":55,"_56":-5,"_82":423,"_18":424},{"_36":65,"_13":66,"_39":67,"_41":-5,"_42":43,"_44":68,"_46":47,"_48":97,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":421,"_18":422},{"_36":118,"_13":119,"_39":120,"_41":67,"_42":43,"_44":121,"_46":47,"_48":122,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":419,"_18":420},{"_36":144,"_13":145,"_39":146,"_41":120,"_42":43,"_44":121,"_46":47,"_48":147,"_17":50,"_51":93,"_52":148,"_54":55,"_56":-5,"_82":417,"_18":418},{"_36":136,"_13":137,"_39":138,"_41":120,"_42":43,"_44":139,"_46":47,"_48":140,"_17":50,"_51":93,"_52":141,"_54":55,"_56":-5,"_82":415,"_18":416},{"_36":128,"_13":129,"_39":130,"_41":120,"_42":43,"_44":131,"_46":47,"_48":132,"_17":50,"_51":93,"_52":133,"_54":55,"_56":-5,"_82":413,"_18":414},{"_36":111,"_13":112,"_39":113,"_41":67,"_42":43,"_44":68,"_46":47,"_48":114,"_17":50,"_51":24,"_52":115,"_54":55,"_56":-5,"_82":411,"_18":412},{"_36":103,"_13":104,"_39":105,"_41":67,"_42":43,"_44":106,"_46":47,"_48":107,"_17":50,"_51":93,"_52":108,"_54":55,"_56":-5,"_82":409,"_18":410},{"_36":58,"_13":59,"_39":60,"_41":-5,"_42":43,"_44":61,"_46":47,"_48":85,"_17":50,"_51":63,"_52":-5,"_54":55,"_56":-5,"_82":407,"_18":408},{"_36":89,"_13":90,"_39":91,"_41":60,"_42":43,"_44":61,"_46":47,"_48":92,"_17":50,"_51":93,"_52":94,"_54":55,"_56":-5,"_82":405,"_18":406},{"_36":37,"_13":38,"_39":40,"_41":-5,"_42":43,"_44":45,"_46":47,"_48":81,"_17":50,"_51":24,"_52":53,"_54":55,"_56":-5,"_82":403,"_18":404},[],[38],[],[59,90],[401],[59],[],[66,104],[],[66,112],[],[66,119,129],[],[66,119,137],[],[66,119,145],[395,396,397],[66,119],[394,398,399],[66],[],[72,160],[],[72,168,177],[],[72,168,185],[390,391],[72,168],[],[72,192,205],[],[72,192,213],[],[72,192,221],[],[72,192,229],[],[72,192,237],[],[72,192,245],[383,384,385,386,387,388],[72,192],[],[72,252,245],[381],[72,252],[],[72,266,274],[],[72,266,281],[378,379],[72,266],[377,380,382,389,392],[72],["D",1747536841043],{"_11":12,"_340":336},{"_11":12,"_334":-5,"_335":336,"_297":298,"_337":338,"_339":55},{"_17":131,"_13":16,"_36":43,"_326":288,"_327":-5,"_328":-5,"_329":-5,"_330":-5,"_331":-5,"_332":14,"_333":12},"ctx",{"_319":-5,"_356":494,"_495":496,"_497":498,"_499":55,"_500":55,"_501":55,"_502":47,"_503":-5,"_504":-7,"_505":-7,"_506":50,"_507":55,"_508":55,"_509":-5,"_510":55,"_511":55,"_512":55,"_513":-5},"ENV",{"_465":466,"_467":468,"_469":16,"_470":471,"_472":473,"_474":475,"_476":477,"_478":479,"_480":481,"_482":483,"_484":485,"_486":487,"_488":489,"_490":491,"_492":493},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]

Code