[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_225":226,"_227":228},"routes/_app.x.$handle.$name",{"_100":99,"_32":51,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":-5,"_62":25,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",5,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","backend/middleware/auth.ts","latestPath","fileId","9b3b133a-3393-11f0-86a1-9e149126039e","name","auth.ts","fileType","script","content","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\";","createdAt",["D",1747536950599],"branchVersion","branchId","59ee44ec-3393-11f0-ac54-9e149126039e",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"backend/middleware","1638c048-0eaa-4dc4-a2c5-e814b47b8019","middleware","directory",["D",1747536950599],"id","59edf028-3393-11f0-ac54-9e149126039e","Godino",["D",1747536841043],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","180d29bb-29b4-41f4-a984-6297ecbf663d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_49":42,"_91":50,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":51,"_98":99},"isOwned",19,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","godinoarts","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":221,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":-5,"_62":25,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":222,"_84":223,"_86":224,"_88":25},"tree",[166,172,174],"files",[166,167,168,169,170,171,172,173,174],"counts",{"_156":66,"_157":137,"_158":66,"_159":160,"_161":162},"contents",[130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":150,"_32":151,"_30":152,"_136":-5,"_41":42,"_40":153,"_138":139,"_38":154,"_13":66,"_34":47,"_36":-5,"_24":25,"_142":-5,"_27":155},{"_49":144,"_32":145,"_30":146,"_136":-5,"_41":42,"_40":147,"_138":139,"_38":148,"_13":66,"_34":47,"_36":-5,"_24":25,"_142":-5,"_27":149},{"_49":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":139,"_38":140,"_13":66,"_34":21,"_36":141,"_24":25,"_142":-5,"_27":143},"709cae54-3393-11f0-bf73-9e149126039e","README.md","709caf08-3393-11f0-bf73-9e149126039e","parentId",1,"latest",true,["D",1747536879094],"# Multi-Currency Finance Platform\n\nA web application that simulates a multi-currency finance platform like Cleva or Grey.\n\n## Features\n\n- User registration and login\n- KYC submission and verification\n- Multi-currency wallets (USD, GBP, NGN)\n- Balance checking\n- Currency exchange between wallets\n- Sending money to other users\n- Setting transaction limits\n- Transaction history\n- Webhook listener for external BaaS events\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/ # Database schema and queries\n│ ├── routes/ # API route handlers\n│ ├── middleware/ # Authentication middleware\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/ # React components\n│ ├── pages/ # Page components\n│ ├── index.html # HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Technologies Used\n\n- Backend: Hono.js, SQLite, JWT\n- Frontend: React, TypeScript, TailwindCSS\n- Storage: SQLite database\n\n## API Endpoints\n\n- POST /api/register - Register a new user\n- POST /api/login - Authenticate a user\n- POST /api/kyc - Submit KYC data\n- POST /api/wallet/create - Create a new wallet\n- GET /api/wallets - Get all wallet balances\n- POST /api/wallet/transfer - Transfer between wallets\n- POST /api/send - Send money to another user\n- POST /api/user/set-limit - Set transaction limits\n- GET /api/transactions - Get transaction history\n- POST /api/webhooks/receive - Webhook listener\n\n## Getting Started\n\n1. Visit the application URL\n2. Register a new account\n3. Submit KYC information\n4. Create wallets in different currencies\n5. Start making transactions","label",[134],"78c18514-3393-11f0-aa53-9e149126039e","shared","a1d87646-f6bb-455a-89e1-734b66fc1e21",2,["D",1747536892757],[145],"82a0a57e-3393-11f0-b5d7-9e149126039e","backend","2799b484-6dbe-4a8f-a0f5-752d99f5a6c3",3,["D",1747536909321],[151],"pulls","branches","forks","envVars",{"_163":66,"_165":66},"connections",{"_163":66,"_164":66},"count","unfilledCount","emptyCount",{"_49":150,"_32":151,"_30":152,"_136":-5,"_41":42,"_40":153,"_138":139,"_38":218,"_13":66,"_34":47,"_36":-5,"_24":25,"_142":-5,"_176":219,"_27":220},{"_49":214,"_32":205,"_30":200,"_136":152,"_41":42,"_40":153,"_138":139,"_38":215,"_13":66,"_34":47,"_36":-5,"_24":25,"_142":-5,"_176":216,"_27":217},{"_49":206,"_32":207,"_30":208,"_136":200,"_41":42,"_40":209,"_138":139,"_38":210,"_13":66,"_34":35,"_36":211,"_24":25,"_142":-5,"_176":212,"_27":213},{"_49":197,"_32":198,"_30":199,"_136":200,"_41":42,"_40":153,"_138":139,"_38":201,"_13":66,"_34":35,"_36":202,"_24":25,"_142":-5,"_176":203,"_27":204},{"_49":193,"_32":46,"_30":45,"_136":152,"_41":42,"_40":14,"_138":139,"_38":194,"_13":66,"_34":47,"_36":-5,"_24":25,"_142":-5,"_176":195,"_27":196},{"_49":189,"_32":33,"_30":31,"_136":45,"_41":42,"_40":14,"_138":139,"_38":190,"_13":66,"_34":35,"_36":37,"_24":25,"_142":-5,"_176":191,"_27":192},{"_49":144,"_32":145,"_30":146,"_136":-5,"_41":42,"_40":147,"_138":139,"_38":186,"_13":66,"_34":47,"_36":-5,"_24":25,"_142":-5,"_176":187,"_27":188},{"_49":179,"_32":180,"_30":181,"_136":146,"_41":42,"_40":147,"_138":139,"_38":182,"_13":66,"_34":35,"_36":183,"_24":25,"_142":-5,"_176":184,"_27":185},{"_49":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":139,"_38":175,"_13":66,"_34":21,"_36":141,"_24":25,"_142":-5,"_176":177,"_27":178},["D",1747536879094],"children",[],[134],"78c179c0-3393-11f0-aa53-9e149126039e","types.ts","78c17a88-3393-11f0-aa53-9e149126039e",["D",1747536892757],"// Currency types supported by the platform\nexport type Currency = \"USD\" | \"GBP\" | \"NGN\";\n\n// User types for different tiers\nexport type UserType = \"basic\" | \"verified\" | \"premium\";\n\n// Transaction types\nexport type TransactionType = \"deposit\" | \"withdrawal\" | \"transfer\" | \"exchange\" | \"send\" | \"receive\";\n\n// Transaction status\nexport type TransactionStatus = \"pending\" | \"completed\" | \"failed\";\n\n// KYC status\nexport type KYCStatus = \"not_submitted\" | \"pending_verification\" | \"verified\" | \"rejected\";\n\n// ID types for KYC\nexport type IDType = \"passport\" | \"drivers_license\" | \"national_id\";\n\n// Limit types\nexport type LimitType = \"daily_transfer\" | \"single_transaction\" | \"monthly_transfer\";\n\n// User interface\nexport interface User {\n id: string;\n name: string;\n email: string;\n password_hash: string;\n user_type: UserType;\n kyc_status: KYCStatus;\n created_at: string;\n}\n\n// Wallet interface\nexport interface Wallet {\n id: string;\n user_id: string;\n currency: Currency;\n balance: string;\n account_number: string;\n bank_name: string;\n created_at: string;\n}\n\n// Transaction interface\nexport interface Transaction {\n id: string;\n user_id: string;\n type: TransactionType;\n currency: Currency;\n amount: string;\n from_wallet_id?: string;\n to_wallet_id?: string;\n to_user_id?: string;\n status: TransactionStatus;\n created_at: string;\n}\n\n// KYC data interface\nexport interface KYCData {\n id: string;\n user_id: string;\n full_name: string;\n id_type: IDType;\n id_number: string;\n photo_url: string;\n status: KYCStatus;\n submitted_at: string;\n verified_at?: string;\n}\n\n// Transaction limit interface\nexport interface TransactionLimit {\n id: string;\n user_type: UserType;\n limit_type: LimitType;\n amount: string;\n created_at: string;\n}\n\n// Exchange rate interface\nexport interface ExchangeRate {\n from_currency: Currency;\n to_currency: Currency;\n rate: number;\n}\n\n// Webhook event interface\nexport interface WebhookEvent {\n event: string;\n currency: Currency;\n amount: string;\n wallet_id: string;\n user_id: string;\n timestamp: string;\n}\n\n// API response interfaces\nexport interface RegisterResponse {\n message: string;\n user_id: string;\n}\n\nexport interface LoginResponse {\n token: string;\n user_id: string;\n}\n\nexport interface KYCResponse {\n status: KYCStatus;\n}\n\nexport interface WalletCreateResponse {\n wallet_id: string;\n currency: Currency;\n account_number: string;\n bank_name: string;\n}\n\nexport interface WalletTransferResponse {\n message: string;\n rate_used: string;\n new_balances: Record;\n}\n\nexport interface SendMoneyResponse {\n message: string;\n txn_id: string;\n}\n\nexport interface SetLimitResponse {\n message: string;\n}",[],[145,180],["D",1747536892757],[173],[145],"9b3b12a4-3393-11f0-86a1-9e149126039e",["D",1747536950599],[],[151,46,33],"9b3b32a2-3393-11f0-86a1-9e149126039e",["D",1747536950599],[171],[151,46],"82a07c98-3393-11f0-b5d7-9e149126039e","schema.ts","82a07d74-3393-11f0-b5d7-9e149126039e","b0d94028-941b-4769-bf7a-289fdd01caeb",["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};",[],[151,205,198],"database","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}",[],[151,205,207],"82a0a740-3393-11f0-b5d7-9e149126039e",["D",1747536909321],[168,169],[151,205],["D",1747536909321],[167,170],[151],["D",1747536841043],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":60,"_104":105,"_106":25},{"_13":89,"_32":90,"_49":42,"_91":50,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":51,"_98":99},"ctx",{"_82":-5,"_127":258,"_259":260,"_261":262,"_263":25,"_264":25,"_265":25,"_266":139,"_267":-5,"_268":-7,"_269":-7,"_270":66,"_271":25,"_272":25,"_273":-5,"_274":25,"_275":25,"_276":25,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":90,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"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"]

Diff · v5