GodinoMawa Bank

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_380":381,"_382":383},"routes/_app.x.$handle.$name",{"_93":92,"_31":44,"_101":83,"_26":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":24,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":76,"_77":78,"_79":80,"_81":24},"version",20,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/auth/Register.tsx","latestPath","fileId","c2968910-34e1-11f0-8250-9e149126039e","name","Register.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"https://esm.sh/react-router-dom@6.20.1?deps=react@18.2.0\";\nimport { useAuth } from \"./AuthContext.tsx\";\nimport { Loader } from \"../common/Loader.tsx\";\nimport { isValidEmail, isStrongPassword } from \"../../../shared/utils.ts\";\n\nexport const Register = () => {\n const { register } = useAuth();\n const [fullName, setFullName] = useState(\"\");\n const [email, setEmail] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [confirmPassword, setConfirmPassword] = useState(\"\");\n const [error, setError] = useState(\"\");\n const [loading, setLoading] = useState(false);\n \n const validateForm = () => {\n if (!fullName || !email || !password || !confirmPassword) {\n setError(\"All fields are required\");\n return false;\n }\n \n if (!isValidEmail(email)) {\n setError(\"Please enter a valid email address\");\n return false;\n }\n \n if (!isStrongPassword(password)) {\n setError(\"Password must be at least 8 characters long\");\n return false;\n }\n \n if (password !== confirmPassword) {\n setError(\"Passwords do not match\");\n return false;\n }\n \n return true;\n };\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n \n if (!validateForm()) {\n return;\n }\n \n setLoading(true);\n \n try {\n await register(fullName, email, password);\n } catch (err: any) {\n setError(err.message || \"Failed to register. Please try again.\");\n } finally {\n setLoading(false);\n }\n };\n \n return (\n

\n GM\n

\n GodinoMawa Bank\n

\n Create your account\n

\n \n

\n {error && (\n

\n {error}\n

\n )}\n \n

\n Full Name\n setFullName(e.target.value)}\n />\n

\n Email address\n setEmail(e.target.value)}\n />\n

\n Password\n setPassword(e.target.value)}\n />\n

\n Confirm Password\n setConfirmPassword(e.target.value)}\n />\n

\n \n

\n \n {loading ? : \"Register\"}\n \n

\n \n

\n Already have an account?{\" \"}\n \n Sign in\n \n

\n );\n};","createdAt",["D",1747680468536],"branchVersion","branchId","623b2c68-34de-11f0-a72c-9e149126039e","id","623af928-34de-11f0-a72c-9e149126039e","untitled-682",["D",1747679018388],"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",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},"branch",{"_13":82,"_31":83,"_42":41,"_84":43,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":44,"_91":92},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","godinoarts","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":376,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":377,"_77":378,"_79":379,"_81":24},"tree",[167,179,190,193],"files",[167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193],"counts",{"_157":59,"_158":131,"_159":59,"_160":161,"_162":163},"contents",[123,124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":151,"_31":152,"_29":153,"_130":-5,"_40":41,"_39":154,"_132":133,"_37":155,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":156},{"_42":145,"_31":146,"_29":147,"_130":-5,"_40":41,"_39":148,"_132":133,"_37":149,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_130":-5,"_40":41,"_39":141,"_132":133,"_37":142,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":133,"_37":134,"_13":59,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"2c00934e-34df-11f0-9f57-9e149126039e","README.md","2c009420-34df-11f0-9f57-9e149126039e","parentId",1,"latest",true,["D",1747679356902],"# GodinoMawa Bank (GM)\n\nA fully functional digital banking application with multi-currency support, KYC verification, and real-time transactions.\n\n## Features\n\n- User authentication (register/login)\n- KYC submission with live camera and document upload\n- Multi-currency wallets (USD, GBP, NGN, EUR)\n- View bank details for each currency\n- Send and receive funds between wallets\n- Currency exchange\n- Transaction limits\n- Transaction history\n- Live support chat and email system\n- Admin webhook simulation for incoming transactions\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ ├── queries.ts # DB query functions\n│ ├── routes/ # Route modules\n│ │ ├── auth.ts # Authentication routes\n│ │ ├── kyc.ts # KYC verification routes\n│ │ ├── wallet.ts # Wallet management routes\n│ │ ├── transaction.ts # Transaction routes\n│ │ ├── support.ts # Support chat routes\n│ │ └── webhook.ts # Webhook simulation\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx\n│ │ ├── auth/ # Authentication components\n│ │ ├── kyc/ # KYC components\n│ │ ├── wallet/ # Wallet components\n│ │ ├── transaction/ # Transaction components\n│ │ └── support/ # Support chat components\n│ ├── pages/ # Page components\n│ ├── favicon.svg\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend JS entry point\n│ └── style.css\n└── shared/\n ├── types.ts # Shared type definitions\n └── utils.ts # Shared utility functions\n```\n\n## Tech Stack\n\n- **Backend**: Hono (TypeScript)\n- **Database**: SQLite\n- **Frontend**: React, TailwindCSS\n- **Authentication**: JWT\n- **Storage**: Val Town blob storage\n\n## Getting Started\n\nAccess the application at the provided HTTP endpoint.","label",[128],"5961346a-34df-11f0-b1a5-9e149126039e","shared","9f4e0aa7-01da-45f1-a4e4-e1f7c1456e8e",4,["D",1747679433031],"directory",[139],"3c35fee6-34e1-11f0-8a92-9e149126039e","frontend","24878ec7-1b87-4279-9d96-6c0b32f468c1",13,["D",1747680243082],[146],"3683befe-34df-11f0-9fa9-9e149126039e","backend","3c713c03-5820-4fc0-80b9-8ae54bd02595",2,["D",1747679374537],[152],"pulls","branches","forks","envVars",{"_164":59,"_166":59},"connections",{"_164":59,"_165":59},"count","unfilledCount","emptyCount",{"_42":151,"_31":152,"_29":153,"_130":-5,"_40":41,"_39":154,"_132":133,"_37":373,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_195":374,"_26":375},{"_42":369,"_31":361,"_29":355,"_130":153,"_40":41,"_39":154,"_132":133,"_37":370,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_195":371,"_26":372},{"_42":362,"_31":363,"_29":364,"_130":355,"_40":41,"_39":154,"_132":133,"_37":365,"_13":59,"_33":34,"_35":366,"_23":24,"_136":-5,"_195":367,"_26":368},{"_42":352,"_31":353,"_29":354,"_130":355,"_40":41,"_39":356,"_132":133,"_37":357,"_13":59,"_33":34,"_35":358,"_23":24,"_136":-5,"_195":359,"_26":360},{"_42":348,"_31":307,"_29":301,"_130":153,"_40":41,"_39":343,"_132":133,"_37":349,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_195":350,"_26":351},{"_42":340,"_31":341,"_29":342,"_130":301,"_40":41,"_39":343,"_132":133,"_37":344,"_13":59,"_33":34,"_35":345,"_23":24,"_136":-5,"_195":346,"_26":347},{"_42":332,"_31":333,"_29":334,"_130":301,"_40":41,"_39":335,"_132":133,"_37":336,"_13":59,"_33":34,"_35":337,"_23":24,"_136":-5,"_195":338,"_26":339},{"_42":324,"_31":325,"_29":326,"_130":301,"_40":41,"_39":327,"_132":133,"_37":328,"_13":59,"_33":34,"_35":329,"_23":24,"_136":-5,"_195":330,"_26":331},{"_42":316,"_31":317,"_29":318,"_130":301,"_40":41,"_39":319,"_132":133,"_37":320,"_13":59,"_33":34,"_35":321,"_23":24,"_136":-5,"_195":322,"_26":323},{"_42":308,"_31":309,"_29":310,"_130":301,"_40":41,"_39":311,"_132":133,"_37":312,"_13":59,"_33":34,"_35":313,"_23":24,"_136":-5,"_195":314,"_26":315},{"_42":298,"_31":299,"_29":300,"_130":301,"_40":41,"_39":302,"_132":133,"_37":303,"_13":59,"_33":34,"_35":304,"_23":24,"_136":-5,"_195":305,"_26":306},{"_42":290,"_31":291,"_29":292,"_130":153,"_40":41,"_39":293,"_132":133,"_37":294,"_13":59,"_33":34,"_35":295,"_23":24,"_136":-5,"_195":296,"_26":297},{"_42":145,"_31":146,"_29":147,"_130":-5,"_40":41,"_39":148,"_132":133,"_37":287,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_195":288,"_26":289},{"_42":283,"_31":256,"_29":250,"_130":147,"_40":41,"_39":251,"_132":133,"_37":284,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_195":285,"_26":286},{"_42":279,"_31":262,"_29":258,"_130":250,"_40":41,"_39":274,"_132":133,"_37":280,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_195":281,"_26":282},{"_42":271,"_31":272,"_29":273,"_130":258,"_40":41,"_39":274,"_132":133,"_37":275,"_13":59,"_33":34,"_35":276,"_23":24,"_136":-5,"_195":277,"_26":278},{"_42":263,"_31":264,"_29":265,"_130":258,"_40":41,"_39":266,"_132":133,"_37":267,"_13":59,"_33":34,"_35":268,"_23":24,"_136":-5,"_195":269,"_26":270},{"_42":257,"_31":32,"_29":30,"_130":258,"_40":41,"_39":14,"_132":133,"_37":259,"_13":59,"_33":34,"_35":36,"_23":24,"_136":-5,"_195":260,"_26":261},{"_42":247,"_31":248,"_29":249,"_130":250,"_40":41,"_39":251,"_132":133,"_37":252,"_13":59,"_33":34,"_35":253,"_23":24,"_136":-5,"_195":254,"_26":255},{"_42":239,"_31":240,"_29":241,"_130":147,"_40":41,"_39":242,"_132":133,"_37":243,"_13":59,"_33":20,"_35":244,"_23":24,"_136":-5,"_195":245,"_26":246},{"_42":232,"_31":233,"_29":234,"_130":147,"_40":41,"_39":148,"_132":133,"_37":235,"_13":59,"_33":20,"_35":236,"_23":24,"_136":-5,"_195":237,"_26":238},{"_42":224,"_31":225,"_29":226,"_130":147,"_40":41,"_39":227,"_132":133,"_37":228,"_13":59,"_33":34,"_35":229,"_23":24,"_136":-5,"_195":230,"_26":231},{"_42":216,"_31":217,"_29":218,"_130":147,"_40":41,"_39":219,"_132":133,"_37":220,"_13":59,"_33":20,"_35":221,"_23":24,"_136":-5,"_195":222,"_26":223},{"_42":138,"_31":139,"_29":140,"_130":-5,"_40":41,"_39":141,"_132":133,"_37":213,"_13":59,"_33":143,"_35":-5,"_23":24,"_136":-5,"_195":214,"_26":215},{"_42":206,"_31":207,"_29":208,"_130":140,"_40":41,"_39":141,"_132":133,"_37":209,"_13":59,"_33":34,"_35":210,"_23":24,"_136":-5,"_195":211,"_26":212},{"_42":198,"_31":199,"_29":200,"_130":140,"_40":41,"_39":201,"_132":133,"_37":202,"_13":59,"_33":34,"_35":203,"_23":24,"_136":-5,"_195":204,"_26":205},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":133,"_37":194,"_13":59,"_33":20,"_35":135,"_23":24,"_136":-5,"_195":196,"_26":197},["D",1747679356902],"children",[],[128],"6735a044-34df-11f0-89c1-9e149126039e","utils.ts","6735a0e4-34df-11f0-89c1-9e149126039e",5,["D",1747679456235],"import { Currency, ExchangeRate } from \"./types.ts\";\n\n// Generate a random account number (for simulation purposes)\nexport function generateAccountNumber(): string {\n return Math.floor(10000000 + Math.random() * 90000000).toString();\n}\n\n// Generate a random sort code (for GBP accounts)\nexport function generateSortCode(): string {\n const part1 = Math.floor(10 + Math.random() * 90).toString();\n const part2 = Math.floor(10 + Math.random() * 90).toString();\n const part3 = Math.floor(10 + Math.random() * 90).toString();\n return `${part1}-${part2}-${part3}`;\n}\n\n// Generate a random routing number (for USD accounts)\nexport function generateRoutingNumber(): string {\n return Math.floor(100000000 + Math.random() * 900000000).toString();\n}\n\n// Generate a random IBAN (for EUR accounts)\nexport function generateIBAN(): string {\n const country = \"DE\";\n const checksum = Math.floor(10 + Math.random() * 90).toString();\n const bankCode = Math.floor(10000000 + Math.random() * 90000000).toString();\n const accountNumber = Math.floor(1000000000 + Math.random() * 9000000000).toString();\n return `${country}${checksum}${bankCode}${accountNumber}`;\n}\n\n// Generate a random BIC (for EUR accounts)\nexport function generateBIC(): string {\n const bankCode = \"GMBANK\";\n const countryCode = \"DE\";\n const locationCode = \"BE\";\n const branchCode = \"XXX\";\n return `${bankCode}${countryCode}${locationCode}${branchCode}`;\n}\n\n// Generate a random NUBAN (for NGN accounts)\nexport function generateNUBAN(): string {\n return Math.floor(1000000000 + Math.random() * 9000000000).toString();\n}\n\n// Get bank details based on currency\nexport function getBankDetailsByCurrency(currency: Currency): Record {\n switch (currency) {\n case \"USD\":\n return {\n bank_name: \"GodinoMawa Bank USA\",\n account_number: generateAccountNumber(),\n routing_number: generateRoutingNumber(),\n };\n case \"GBP\":\n return {\n bank_name: \"GodinoMawa Bank UK\",\n account_number: generateAccountNumber(),\n sort_code: generateSortCode(),\n };\n case \"EUR\":\n return {\n bank_name: \"GodinoMawa Bank EU\",\n iban: generateIBAN(),\n bic: generateBIC(),\n };\n case \"NGN\":\n return {\n bank_name: \"GodinoMawa Bank Nigeria\",\n account_number: generateAccountNumber(),\n nuban: generateNUBAN(),\n };\n default:\n throw new Error(`Unsupported currency: ${currency}`);\n }\n}\n\n// Format currency amount\nexport function formatCurrency(amount: number, currency: Currency): string {\n const formatter = new Intl.NumberFormat(\"en-US\", {\n style: \"currency\",\n currency,\n minimumFractionDigits: 2,\n });\n \n return formatter.format(amount);\n}\n\n// Exchange rates (fixed for simulation)\nconst exchangeRates: ExchangeRate[] = [\n { from: \"USD\", to: \"GBP\", rate: 0.78 },\n { from: \"USD\", to: \"EUR\", rate: 0.92 },\n { from: \"USD\", to: \"NGN\", rate: 1550 },\n { from: \"GBP\", to: \"USD\", rate: 1.28 },\n { from: \"GBP\", to: \"EUR\", rate: 1.18 },\n { from: \"GBP\", to: \"NGN\", rate: 1980 },\n { from: \"EUR\", to: \"USD\", rate: 1.09 },\n { from: \"EUR\", to: \"GBP\", rate: 0.85 },\n { from: \"EUR\", to: \"NGN\", rate: 1680 },\n { from: \"NGN\", to: \"USD\", rate: 0.00065 },\n { from: \"NGN\", to: \"GBP\", rate: 0.00051 },\n { from: \"NGN\", to: \"EUR\", rate: 0.00060 },\n];\n\n// Get exchange rate between two currencies\nexport function getExchangeRate(fromCurrency: Currency, toCurrency: Currency): number {\n if (fromCurrency === toCurrency) {\n return 1;\n }\n \n const rate = exchangeRates.find(r => r.from === fromCurrency && r.to === toCurrency);\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(amount: number, fromCurrency: Currency, toCurrency: Currency): number {\n const rate = getExchangeRate(fromCurrency, toCurrency);\n return amount * rate;\n}\n\n// Calculate transaction fee (simplified for demo)\nexport function calculateTransactionFee(amount: number, transactionType: string): number {\n switch (transactionType) {\n case \"transfer\":\n return amount * 0.01; // 1% fee for transfers\n case \"exchange\":\n return amount * 0.02; // 2% fee for currency exchange\n default:\n return 0;\n }\n}\n\n// Generate a transaction reference\nexport function generateTransactionReference(): string {\n const prefix = \"GM\";\n const timestamp = Date.now().toString().slice(-6);\n const random = Math.floor(1000 + Math.random() * 9000).toString();\n return `${prefix}${timestamp}${random}`;\n}\n\n// Format date\nexport function formatDate(timestamp: number): string {\n return new Date(timestamp).toLocaleString();\n}\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 isStrongPassword(password: string): boolean {\n return password.length >= 8;\n}\n\n// Check if names match (case insensitive)\nexport function doNamesMatch(name1: string, name2: string): boolean {\n return name1.toLowerCase().trim() === name2.toLowerCase().trim();\n}",[],[139,199],"5960ffe0-34df-11f0-b1a5-9e149126039e","types.ts","596100d0-34df-11f0-b1a5-9e149126039e",["D",1747679433031],"// User types\nexport interface User {\n id: string;\n email: string;\n password_hash: string;\n full_name: string;\n created_at: number;\n updated_at: number;\n kyc_verified: boolean;\n is_admin: boolean;\n}\n\nexport interface UserRegistration {\n email: string;\n password: string;\n full_name: string;\n}\n\nexport interface UserLogin {\n email: string;\n password: string;\n}\n\nexport interface AuthResponse {\n token: string;\n user: Omit;\n}\n\n// KYC types\nexport type IdType = 'passport' | 'national_id' | 'drivers_license' | 'nin';\n\nexport interface KycSubmission {\n id: string;\n user_id: string;\n full_name: string;\n id_type: IdType;\n id_number: string;\n document_url: string;\n selfie_url: string;\n status: 'pending' | 'approved' | 'rejected';\n submitted_at: number;\n verified_at: number | null;\n}\n\nexport interface KycSubmissionRequest {\n full_name: string;\n id_type: IdType;\n id_number: string;\n document_url: string;\n selfie_url: string;\n}\n\n// Currency types\nexport type Currency = 'USD' | 'GBP' | 'NGN' | 'EUR';\n\n// Wallet types\nexport interface Wallet {\n id: string;\n user_id: string;\n currency: Currency;\n balance: number;\n account_number: string;\n bank_name?: string;\n routing_number?: string;\n sort_code?: string;\n iban?: string;\n bic?: string;\n nuban?: string;\n created_at: number;\n updated_at: number;\n}\n\nexport interface WalletCreationRequest {\n currency: Currency;\n}\n\n// Transaction types\nexport type TransactionType = 'deposit' | 'withdrawal' | 'transfer' | 'exchange';\nexport type TransactionStatus = 'pending' | 'completed' | 'failed';\n\nexport interface Transaction {\n id: string;\n user_id: string;\n transaction_type: TransactionType;\n from_wallet_id?: string;\n to_wallet_id?: string;\n from_currency?: Currency;\n to_currency?: Currency;\n amount: number;\n fee: number;\n exchange_rate?: number;\n status: TransactionStatus;\n reference?: string;\n description?: string;\n created_at: number;\n updated_at: number;\n}\n\nexport interface TransferRequest {\n from_currency: Currency;\n to_currency: Currency;\n amount: number;\n description?: string;\n}\n\nexport interface SendMoneyRequest {\n to_email: string;\n currency: Currency;\n amount: number;\n description?: string;\n}\n\n// Transaction limits\nexport type LimitType = 'daily_transfer' | 'single_transfer' | 'daily_withdrawal' | 'single_withdrawal';\n\nexport interface TransactionLimit {\n id: string;\n user_id: string;\n limit_type: LimitType;\n currency: Currency;\n amount: number;\n created_at: number;\n updated_at: number;\n}\n\nexport interface SetLimitRequest {\n limit_type: LimitType;\n currency: Currency;\n amount: number;\n}\n\n// Support chat types\nexport interface SupportChat {\n id: string;\n user_id: string;\n status: 'open' | 'closed';\n created_at: number;\n updated_at: number;\n}\n\nexport interface SupportMessage {\n id: string;\n chat_id: string;\n sender_type: 'user' | 'support';\n sender_id: string;\n message: string;\n created_at: number;\n}\n\nexport interface SendMessageRequest {\n chat_id: string;\n message: string;\n}\n\n// Webhook types\nexport interface WebhookEvent {\n event: string;\n currency: Currency;\n amount: string;\n wallet_id: string;\n user_id: string;\n}\n\n// Exchange rates\nexport interface ExchangeRate {\n from: Currency;\n to: Currency;\n rate: number;\n}",[],[139,207],["D",1747679433031],[191,192],[139],"4f1ac988-34e1-11f0-a089-9e149126039e","style.css","4f1aca5a-34e1-11f0-a089-9e149126039e",14,["D",1747680274787],":root {\n --primary-color: #0a2463; /* Navy Blue */\n --secondary-color: #ffd700; /* Yellow */\n --accent-color: #f8f9fa; /* Light Grey */\n --text-color: #333333;\n --error-color: #dc3545;\n --success-color: #28a745;\n --warning-color: #ffc107;\n --info-color: #17a2b8;\n}\n\nbody {\n font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n color: var(--text-color);\n margin: 0;\n padding: 0;\n}\n\n/* Custom button styles */\n.btn-primary {\n background-color: var(--primary-color);\n color: white;\n transition: all 0.3s ease;\n}\n\n.btn-primary:hover {\n background-color: #051a4d;\n}\n\n.btn-secondary {\n background-color: var(--secondary-color);\n color: var(--primary-color);\n transition: all 0.3s ease;\n}\n\n.btn-secondary:hover {\n background-color: #e6c200;\n}\n\n/* Card styles */\n.card {\n border-radius: 0.5rem;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n transition: transform 0.3s ease, box-shadow 0.3s ease;\n}\n\n.card:hover {\n transform: translateY(-5px);\n box-shadow: 0 10px 15px rgba(0, 0, 0, 0.1);\n}\n\n/* Wallet card styles */\n.wallet-card {\n background: linear-gradient(135deg, var(--primary-color) 0%, #1a3a8f 100%);\n color: white;\n border-radius: 1rem;\n overflow: hidden;\n position: relative;\n}\n\n.wallet-card::before {\n content: '';\n position: absolute;\n top: -50%;\n left: -50%;\n width: 200%;\n height: 200%;\n background: radial-gradient(circle, rgba(255,255,255,0.1) 0%, rgba(255,255,255,0) 70%);\n opacity: 0.3;\n}\n\n.wallet-card.usd {\n background: linear-gradient(135deg, #0a2463 0%, #1a3a8f 100%);\n}\n\n.wallet-card.gbp {\n background: linear-gradient(135deg, #1a3a8f 0%, #2a4aaf 100%);\n}\n\n.wallet-card.eur {\n background: linear-gradient(135deg, #2a4aaf 0%, #3a5acf 100%);\n}\n\n.wallet-card.ngn {\n background: linear-gradient(135deg, #3a5acf 0%, #4a6aef 100%);\n}\n\n/* Form styles */\n.form-control {\n border: 1px solid #ced4da;\n border-radius: 0.25rem;\n padding: 0.5rem 0.75rem;\n transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out;\n}\n\n.form-control:focus {\n border-color: var(--primary-color);\n box-shadow: 0 0 0 0.2rem rgba(10, 36, 99, 0.25);\n outline: none;\n}\n\n/* Support chat styles */\n.chat-container {\n height: 400px;\n overflow-y: auto;\n}\n\n.chat-message {\n margin-bottom: 1rem;\n padding: 0.75rem;\n border-radius: 1rem;\n max-width: 80%;\n}\n\n.chat-message.user {\n background-color: var(--primary-color);\n color: white;\n margin-left: auto;\n border-bottom-right-radius: 0;\n}\n\n.chat-message.support {\n background-color: #e9ecef;\n color: var(--text-color);\n margin-right: auto;\n border-bottom-left-radius: 0;\n}\n\n/* Support chat button */\n.support-chat-button {\n position: fixed;\n bottom: 2rem;\n right: 2rem;\n width: 3.5rem;\n height: 3.5rem;\n border-radius: 50%;\n background-color: var(--primary-color);\n color: white;\n display: flex;\n align-items: center;\n justify-content: center;\n cursor: pointer;\n box-shadow: 0 4px 10px rgba(0, 0, 0, 0.2);\n z-index: 1000;\n transition: all 0.3s ease;\n}\n\n.support-chat-button:hover {\n transform: scale(1.1);\n}\n\n/* Support chat panel */\n.support-chat-panel {\n position: fixed;\n bottom: 0;\n right: 0;\n width: 350px;\n height: 500px;\n background-color: white;\n border-top-left-radius: 1rem;\n box-shadow: -5px -5px 15px rgba(0, 0, 0, 0.1);\n z-index: 1001;\n display: flex;\n flex-direction: column;\n transition: transform 0.3s ease;\n}\n\n.support-chat-panel.hidden {\n transform: translateX(100%);\n}\n\n/* Loading spinner */\n.spinner {\n border: 4px solid rgba(0, 0, 0, 0.1);\n border-radius: 50%;\n border-top: 4px solid var(--primary-color);\n width: 24px;\n height: 24px;\n animation: spin 1s linear infinite;\n}\n\n@keyframes spin {\n 0% { transform: rotate(0deg); }\n 100% { transform: rotate(360deg); }\n}\n\n/* Camera styles */\n.camera-container {\n position: relative;\n width: 100%;\n max-width: 500px;\n margin: 0 auto;\n}\n\n.camera-feed {\n width: 100%;\n border-radius: 0.5rem;\n overflow: hidden;\n}\n\n.camera-controls {\n display: flex;\n justify-content: center;\n margin-top: 1rem;\n}\n\n.camera-button {\n width: 3rem;\n height: 3rem;\n border-radius: 50%;\n background-color: white;\n border: 2px solid var(--primary-color);\n display: flex;\n align-items: center;\n justify-content: center;\n cursor: pointer;\n transition: all 0.3s ease;\n}\n\n.camera-button:hover {\n background-color: var(--primary-color);\n color: white;\n}\n\n/* Transaction history styles */\n.transaction-item {\n border-left: 4px solid transparent;\n transition: all 0.3s ease;\n}\n\n.transaction-item:hover {\n background-color: rgba(10, 36, 99, 0.05);\n}\n\n.transaction-item.deposit {\n border-left-color: var(--success-color);\n}\n\n.transaction-item.withdrawal {\n border-left-color: var(--error-color);\n}\n\n.transaction-item.transfer {\n border-left-color: var(--info-color);\n}\n\n.transaction-item.exchange {\n border-left-color: var(--warning-color);\n}\n\n/* Responsive styles */\n@media (max-width: 768px) {\n .support-chat-panel {\n width: 100%;\n height: 100%;\n border-radius: 0;\n }\n \n .wallet-card {\n margin-bottom: 1rem;\n }\n}",[],[146,217],"5873f3ec-34e1-11f0-8463-9e149126039e","index.tsx","5873f4c8-34e1-11f0-8463-9e149126039e",16,["D",1747680290471],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\n// Create root and render app\nconst root = ReactDOM.createRoot(document.getElementById(\"root\") as HTMLElement);\nroot.render(\n \n \n \n);",[],[146,225],"3c35ded4-34e1-11f0-8a92-9e149126039e","index.html","3c35dfc4-34e1-11f0-8a92-9e149126039e",["D",1747680243082],"\n\n\n \n \n GodinoMawa Bank\n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n \n \n\n",[],[146,233],"537f8356-34e1-11f0-9c01-9e149126039e","favicon.svg","537f841e-34e1-11f0-9c01-9e149126039e",15,["D",1747680282157],"",[],[146,240],"640d5658-34e1-11f0-a0fa-9e149126039e","App.tsx","640d572a-34e1-11f0-a0fa-9e149126039e","d00539a3-553f-470e-a127-ee4f831d08c6",17,["D",1747680309931],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { BrowserRouter as Router, Routes, Route, Navigate } from \"https://esm.sh/react-router-dom@6.20.1?deps=react@18.2.0\";\nimport { AuthProvider, useAuth } from \"./auth/AuthContext.tsx\";\nimport { Login } from \"./auth/Login.tsx\";\nimport { Register } from \"./auth/Register.tsx\";\nimport { Dashboard } from \"./dashboard/Dashboard.tsx\";\nimport { KycVerification } from \"./kyc/KycVerification.tsx\";\nimport { Wallets } from \"./wallet/Wallets.tsx\";\nimport { WalletDetails } from \"./wallet/WalletDetails.tsx\";\nimport { Transfer } from \"./transaction/Transfer.tsx\";\nimport { SendMoney } from \"./transaction/SendMoney.tsx\";\nimport { TransactionHistory } from \"./transaction/TransactionHistory.tsx\";\nimport { TransactionLimits } from \"./transaction/TransactionLimits.tsx\";\nimport { SupportChat } from \"./support/SupportChat.tsx\";\nimport { Navbar } from \"./layout/Navbar.tsx\";\nimport { Footer } from \"./layout/Footer.tsx\";\nimport { SupportButton } from \"./support/SupportButton.tsx\";\nimport { Loader } from \"./common/Loader.tsx\";\n\n// Protected route component\nconst ProtectedRoute = ({ children }: { children: React.ReactNode }) => {\n const { isAuthenticated, loading } = useAuth();\n \n if (loading) {\n return ;\n }\n \n if (!isAuthenticated) {\n return ;\n }\n \n return <>{children};\n};\n\n// KYC required route component\nconst KycRequiredRoute = ({ children }: { children: React.ReactNode }) => {\n const { user, loading } = useAuth();\n \n if (loading) {\n return ;\n }\n \n if (!user?.kyc_verified) {\n return ;\n }\n \n return <>{children};\n};\n\n// Main App component\nexport const App = () => {\n return (\n \n \n \n \n \n );\n};\n\n// App content component\nconst AppContent = () => {\n const { isAuthenticated, user } = useAuth();\n const [isSupportChatOpen, setIsSupportChatOpen] = useState(false);\n \n return (\n

\n {isAuthenticated && }\n \n

\n \n {/* Public routes */}\n : } />\n : } />\n \n {/* Protected routes */}\n \n \n \n } />\n \n \n {user?.kyc_verified ? : }\n \n } />\n \n \n \n \n \n \n } />\n \n \n \n \n \n \n } />\n \n \n \n \n \n \n } />\n \n \n \n \n \n \n } />\n \n \n \n \n \n \n } />\n \n \n \n \n \n \n } />\n \n {/* Default route */}\n } />\n \n

\n \n {isAuthenticated && (\n <>\n setIsSupportChatOpen(true)} />\n setIsSupportChatOpen(false)} />\n

\n );\n};",[],[146,256,248],"components","c2968866-34e1-11f0-8250-9e149126039e","1d2fb0ab-cc07-47d0-a90a-cd156afbe0d0",["D",1747680468536],[],[146,256,262,32],"auth","b2eaa6ae-34e1-11f0-ac2d-9e149126039e","Login.tsx","b2eaa762-34e1-11f0-ac2d-9e149126039e",19,["D",1747680442244],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"https://esm.sh/react-router-dom@6.20.1?deps=react@18.2.0\";\nimport { useAuth } from \"./AuthContext.tsx\";\nimport { Loader } from \"../common/Loader.tsx\";\n\nexport const Login = () => {\n const { login } = useAuth();\n const [email, setEmail] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(\"\");\n const [loading, setLoading] = useState(false);\n \n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n setLoading(true);\n \n try {\n await login(email, password);\n } catch (err: any) {\n setError(err.message || \"Failed to login. Please check your credentials.\");\n } finally {\n setLoading(false);\n }\n };\n \n return (\n

\n GM\n

\n GodinoMawa Bank\n

\n Sign in to your account\n

\n \n \n

\n );\n};",[],[146,256,262,264],"a7237ecc-34e1-11f0-85ab-9e149126039e","AuthContext.tsx","a7237f9e-34e1-11f0-85ab-9e149126039e",18,["D",1747680422482],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { createContext, useState, useContext, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { AuthResponse } from \"../../../shared/types.ts\";\n\n// Define Auth Context types\ninterface AuthContextType {\n user: any | null;\n token: string | null;\n isAuthenticated: boolean;\n loading: boolean;\n login: (email: string, password: string) => Promise;\n register: (fullName: string, email: string, password: string) => Promise;\n logout: () => void;\n refreshUser: () => Promise;\n}\n\n// Create Auth Context\nconst AuthContext = createContext({\n user: null,\n token: null,\n isAuthenticated: false,\n loading: true,\n login: async () => {},\n register: async () => {},\n logout: () => {},\n refreshUser: async () => {}\n});\n\n// Auth Provider Component\nexport const AuthProvider = ({ children }: { children: React.ReactNode }) => {\n const [user, setUser] = useState(null);\n const [token, setToken] = useState(null);\n const [loading, setLoading] = useState(true);\n \n // Check for existing auth on mount\n useEffect(() => {\n const storedToken = localStorage.getItem(\"gm_token\");\n if (storedToken) {\n setToken(storedToken);\n fetchCurrentUser(storedToken);\n } else {\n setLoading(false);\n }\n }, []);\n \n // Fetch current user data\n const fetchCurrentUser = async (authToken: string) => {\n try {\n const response = await fetch(\"/api/auth/me\", {\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 invalid or expired\n logout();\n }\n } catch (error) {\n console.error(\"Error fetching user data:\", error);\n logout();\n } finally {\n setLoading(false);\n }\n };\n \n // Login function\n const login = async (email: string, password: string) => {\n setLoading(true);\n try {\n const response = await fetch(\"/api/auth/login\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\"\n },\n body: JSON.stringify({ email, password })\n });\n \n if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || \"Login failed\");\n }\n \n const data: AuthResponse = await response.json();\n setToken(data.token);\n setUser(data.user);\n localStorage.setItem(\"gm_token\", data.token);\n } catch (error) {\n console.error(\"Login error:\", error);\n throw error;\n } finally {\n setLoading(false);\n }\n };\n \n // Register function\n const register = async (full_name: string, email: string, password: string) => {\n setLoading(true);\n try {\n const response = await fetch(\"/api/auth/register\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\"\n },\n body: JSON.stringify({ full_name, email, password })\n });\n \n if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || \"Registration failed\");\n }\n \n const data: AuthResponse = await response.json();\n setToken(data.token);\n setUser(data.user);\n localStorage.setItem(\"gm_token\", data.token);\n } catch (error) {\n console.error(\"Registration error:\", error);\n throw error;\n } finally {\n setLoading(false);\n }\n };\n \n // Logout function\n const logout = () => {\n setUser(null);\n setToken(null);\n localStorage.removeItem(\"gm_token\");\n };\n \n // Refresh user data\n const refreshUser = async () => {\n if (!token) return;\n \n try {\n const response = await fetch(\"/api/auth/me\", {\n headers: {\n \"Authorization\": `Bearer ${token}`\n }\n });\n \n if (response.ok) {\n const userData = await response.json();\n setUser(userData);\n } else {\n // Token invalid or expired\n logout();\n }\n } catch (error) {\n console.error(\"Error refreshing user data:\", error);\n }\n };\n \n return (\n \n {children}\n \n );\n};\n\n// Custom hook to use Auth Context\nexport const useAuth = () => useContext(AuthContext);",[],[146,256,262,272],"a723a028-34e1-11f0-85ab-9e149126039e",["D",1747680422482],[182,183,184],[146,256,262],"640d7d7c-34e1-11f0-a0fa-9e149126039e",["D",1747680309931],[181,185],[146,256],["D",1747680243082],[180,186,187,188,189],[146],"37df2eda-34e1-11f0-8bcd-9e149126039e","index.ts","37df2fa2-34e1-11f0-8bcd-9e149126039e",12,["D",1747680235809],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware/cors\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport auth from \"./routes/auth.ts\";\nimport kyc from \"./routes/kyc.ts\";\nimport wallet from \"./routes/wallet.ts\";\nimport transaction from \"./routes/transaction.ts\";\nimport support from \"./routes/support.ts\";\nimport webhook from \"./routes/webhook.ts\";\n\n// Create a new Hono 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// Run database migrations\napp.use(\"*\", async (c, next) => {\n try {\n await runMigrations();\n } catch (error) {\n console.error(\"Migration error:\", error);\n }\n return next();\n});\n\n// API routes\napp.route(\"/api/auth\", auth);\napp.route(\"/api/kyc\", kyc);\napp.route(\"/api/wallet\", wallet);\napp.route(\"/api/transaction\", transaction);\napp.route(\"/api/support\", support);\napp.route(\"/api/webhook\", webhook);\n\n// Serve frontend 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 all other routes\napp.get(\"*\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Add error catching script\n html = html.replace(\"\", ``);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index.html:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\n// Export the app\nexport default app.fetch;",[],[152,291],"30a200d4-34e1-11f0-a82f-9e149126039e","webhook.ts","30a201b0-34e1-11f0-a82f-9e149126039e","34cf6489-9836-40ac-a1f9-014164a4af53",11,["D",1747680223664],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getWalletById, \n updateWalletBalance, \n createTransaction \n} from \"../database/queries.ts\";\nimport { WebhookEvent } from \"../../shared/types.ts\";\nimport { generateTransactionReference } from \"../../shared/utils.ts\";\n\n// Create a new Hono app for webhook routes\nconst webhook = new Hono();\n\n// Simulate incoming payment webhook\nwebhook.post(\"/receive\", async (c) => {\n try {\n const data = await c.req.json() as WebhookEvent;\n \n // Validate input\n if (!data.event || !data.currency || !data.amount || !data.wallet_id || !data.user_id) {\n return c.json({ error: \"All webhook fields are required\" }, 400);\n }\n \n // Check if event type is supported\n if (data.event !== \"payment.received\") {\n return c.json({ error: \"Unsupported event type\" }, 400);\n }\n \n // Get wallet\n const wallet = await getWalletById(data.wallet_id);\n if (!wallet) {\n return c.json({ error: \"Wallet not found\" }, 404);\n }\n \n // Check if wallet belongs to user\n if (wallet.user_id !== data.user_id) {\n return c.json({ error: \"Wallet does not belong to user\" }, 403);\n }\n \n // Parse amount\n const amount = parseFloat(data.amount);\n if (isNaN(amount) || amount <= 0) {\n return c.json({ error: \"Invalid amount\" }, 400);\n }\n \n // Generate transaction reference\n const reference = generateTransactionReference();\n \n // Create transaction record\n const transaction = await createTransaction({\n user_id: data.user_id,\n transaction_type: \"deposit\",\n to_wallet_id: data.wallet_id,\n to_currency: data.currency,\n amount,\n fee: 0,\n status: \"completed\",\n reference,\n description: \"External deposit\"\n });\n \n // Update wallet balance\n const newBalance = wallet.balance + amount;\n await updateWalletBalance(data.wallet_id, newBalance);\n \n return c.json({ \n message: \"Payment received successfully\", \n transaction,\n new_balance: newBalance\n });\n } catch (error) {\n console.error(\"Webhook error:\", error);\n return c.json({ error: \"Failed to process webhook\" }, 500);\n }\n});\n\n// Admin endpoint to simulate incoming payment\nwebhook.post(\"/admin/simulate-payment\", async (c) => {\n try {\n const data = await c.req.json();\n \n // Validate input\n if (!data.wallet_id || !data.amount || !data.currency) {\n return c.json({ error: \"Wallet ID, amount, and currency are required\" }, 400);\n }\n \n // Get wallet\n const wallet = await getWalletById(data.wallet_id);\n if (!wallet) {\n return c.json({ error: \"Wallet not found\" }, 404);\n }\n \n // Parse amount\n const amount = parseFloat(data.amount);\n if (isNaN(amount) || amount <= 0) {\n return c.json({ error: \"Invalid amount\" }, 400);\n }\n \n // Create webhook event\n const webhookEvent: WebhookEvent = {\n event: \"payment.received\",\n currency: data.currency,\n amount: amount.toString(),\n wallet_id: data.wallet_id,\n user_id: wallet.user_id\n };\n \n // Call webhook endpoint\n const response = await fetch(`${c.req.url.split(\"/admin\")[0]}/receive`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\"\n },\n body: JSON.stringify(webhookEvent)\n });\n \n const result = await response.json();\n \n return c.json(result);\n } catch (error) {\n console.error(\"Simulate payment error:\", error);\n return c.json({ error: \"Failed to simulate payment\" }, 500);\n }\n});\n\nexport default webhook;",[],[152,307,299],"routes","9cc9314e-34df-11f0-bdeb-9e149126039e","wallet.ts","9cc93234-34df-11f0-bdeb-9e149126039e",8,["D",1747679546117],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { authMiddleware } from \"./auth.ts\";\nimport { \n createWallet, \n getWalletsByUserId, \n getWalletByUserIdAndCurrency,\n getUserById\n} from \"../database/queries.ts\";\nimport { WalletCreationRequest, Currency } from \"../../shared/types.ts\";\nimport { getBankDetailsByCurrency } from \"../../shared/utils.ts\";\n\n// Create a new Hono app for wallet routes\nconst wallet = new Hono();\n\n// Apply auth middleware to all routes\nwallet.use(\"*\", authMiddleware());\n\n// Create a new wallet\nwallet.post(\"/create\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const data = await c.req.json() as WalletCreationRequest;\n \n // Validate input\n if (!data.currency) {\n return c.json({ error: \"Currency is required\" }, 400);\n }\n \n // Check if currency is supported\n const supportedCurrencies: Currency[] = [\"USD\", \"GBP\", \"NGN\", \"EUR\"];\n if (!supportedCurrencies.includes(data.currency)) {\n return c.json({ error: \"Unsupported currency\" }, 400);\n }\n \n // Check if user is KYC verified\n const user = await getUserById(userId);\n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n if (!user.kyc_verified) {\n return c.json({ error: \"KYC verification required to create wallets\" }, 403);\n }\n \n // Check if wallet already exists\n const existingWallet = await getWalletByUserIdAndCurrency(userId, data.currency);\n if (existingWallet) {\n return c.json({ error: `${data.currency} wallet already exists`, wallet: existingWallet }, 409);\n }\n \n // Get bank details based on currency\n const bankDetails = getBankDetailsByCurrency(data.currency);\n \n // Create wallet\n const newWallet = await createWallet({\n user_id: userId,\n currency: data.currency,\n balance: 0,\n account_number: bankDetails.account_number,\n bank_name: bankDetails.bank_name,\n routing_number: bankDetails.routing_number,\n sort_code: bankDetails.sort_code,\n iban: bankDetails.iban,\n bic: bankDetails.bic,\n nuban: bankDetails.nuban\n });\n \n return c.json({ \n message: `${data.currency} wallet created successfully`, \n wallet: newWallet \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\nwallet.get(\"/all\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get wallets\n const wallets = await getWalletsByUserId(userId);\n \n return c.json({ wallets });\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 by currency\nwallet.get(\"/:currency\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const currency = c.req.param(\"currency\") as Currency;\n \n // Check if currency is supported\n const supportedCurrencies: Currency[] = [\"USD\", \"GBP\", \"NGN\", \"EUR\"];\n if (!supportedCurrencies.includes(currency)) {\n return c.json({ error: \"Unsupported currency\" }, 400);\n }\n \n // Get wallet\n const wallet = await getWalletByUserIdAndCurrency(userId, currency);\n if (!wallet) {\n return c.json({ error: `${currency} wallet not found` }, 404);\n }\n \n return c.json({ wallet });\n } catch (error) {\n console.error(\"Get wallet error:\", error);\n return c.json({ error: \"Failed to get wallet\" }, 500);\n }\n});\n\n// Create all wallets (USD, GBP, NGN, EUR)\nwallet.post(\"/create-all\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Check if user is KYC verified\n const user = await getUserById(userId);\n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n if (!user.kyc_verified) {\n return c.json({ error: \"KYC verification required to create wallets\" }, 403);\n }\n \n const currencies: Currency[] = [\"USD\", \"GBP\", \"NGN\", \"EUR\"];\n const createdWallets = [];\n const existingWallets = [];\n \n // Create wallets for each currency\n for (const currency of currencies) {\n // Check if wallet already exists\n const existingWallet = await getWalletByUserIdAndCurrency(userId, currency);\n if (existingWallet) {\n existingWallets.push(existingWallet);\n continue;\n }\n \n // Get bank details based on currency\n const bankDetails = getBankDetailsByCurrency(currency);\n \n // Create wallet\n const newWallet = await createWallet({\n user_id: userId,\n currency,\n balance: 0,\n account_number: bankDetails.account_number,\n bank_name: bankDetails.bank_name,\n routing_number: bankDetails.routing_number,\n sort_code: bankDetails.sort_code,\n iban: bankDetails.iban,\n bic: bankDetails.bic,\n nuban: bankDetails.nuban\n });\n \n createdWallets.push(newWallet);\n }\n \n return c.json({ \n message: \"Wallets created successfully\", \n created: createdWallets,\n existing: existingWallets\n });\n } catch (error) {\n console.error(\"Create all wallets error:\", error);\n return c.json({ error: \"Failed to create wallets\" }, 500);\n }\n});\n\nexport default wallet;",[],[152,307,309],"b3f66436-34df-11f0-89ae-9e149126039e","transaction.ts","b3f664e0-34df-11f0-89ae-9e149126039e",9,["D",1747679585003],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { authMiddleware } from \"./auth.ts\";\nimport { \n getWalletByUserIdAndCurrency,\n getUserByEmail,\n updateWalletBalance,\n createTransaction,\n getTransactionsByUserId,\n setTransactionLimit,\n getTransactionLimitByTypeAndCurrency,\n getTransactionLimitsByUserId\n} from \"../database/queries.ts\";\nimport { \n TransferRequest, \n SendMoneyRequest, \n SetLimitRequest,\n Currency\n} from \"../../shared/types.ts\";\nimport { \n convertCurrency, \n calculateTransactionFee, \n generateTransactionReference \n} from \"../../shared/utils.ts\";\n\n// Create a new Hono app for transaction routes\nconst transaction = new Hono();\n\n// Apply auth middleware to all routes\ntransaction.use(\"*\", authMiddleware());\n\n// Transfer between own wallets (currency exchange)\ntransaction.post(\"/transfer\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const data = await c.req.json() as TransferRequest;\n \n // Validate input\n if (!data.from_currency || !data.to_currency || !data.amount) {\n return c.json({ error: \"From currency, to currency, and amount are required\" }, 400);\n }\n \n if (data.amount <= 0) {\n return c.json({ error: \"Amount must be greater than zero\" }, 400);\n }\n \n // Check if currencies are the same\n if (data.from_currency === data.to_currency) {\n return c.json({ error: \"From and to currencies must be different\" }, 400);\n }\n \n // Get source wallet\n const sourceWallet = await getWalletByUserIdAndCurrency(userId, data.from_currency);\n if (!sourceWallet) {\n return c.json({ error: `${data.from_currency} wallet not found` }, 404);\n }\n \n // Get destination wallet\n const destWallet = await getWalletByUserIdAndCurrency(userId, data.to_currency);\n if (!destWallet) {\n return c.json({ error: `${data.to_currency} wallet not found` }, 404);\n }\n \n // Check if source wallet has enough balance\n if (sourceWallet.balance < data.amount) {\n return c.json({ error: \"Insufficient balance\" }, 400);\n }\n \n // Check transaction limits\n const singleTransferLimit = await getTransactionLimitByTypeAndCurrency(\n userId, \n \"single_transfer\", \n data.from_currency\n );\n \n if (singleTransferLimit && data.amount > singleTransferLimit.amount) {\n return c.json({ \n error: `Amount exceeds your single transfer limit of ${singleTransferLimit.amount} ${data.from_currency}` \n }, 400);\n }\n \n // Calculate fee\n const fee = calculateTransactionFee(data.amount, \"exchange\");\n \n // Calculate exchange rate and converted amount\n const exchangeRate = convertCurrency(1, data.from_currency, data.to_currency);\n const convertedAmount = convertCurrency(data.amount - fee, data.from_currency, data.to_currency);\n \n // Generate transaction reference\n const reference = generateTransactionReference();\n \n // Create transaction record\n const transaction = await createTransaction({\n user_id: userId,\n transaction_type: \"exchange\",\n from_wallet_id: sourceWallet.id,\n to_wallet_id: destWallet.id,\n from_currency: data.from_currency,\n to_currency: data.to_currency,\n amount: data.amount,\n fee,\n exchange_rate: exchangeRate,\n status: \"completed\",\n reference,\n description: data.description || `Exchange from ${data.from_currency} to ${data.to_currency}`\n });\n \n // Update wallet balances\n await updateWalletBalance(sourceWallet.id, sourceWallet.balance - data.amount);\n await updateWalletBalance(destWallet.id, destWallet.balance + convertedAmount);\n \n // Get updated wallets\n const updatedSourceWallet = await getWalletByUserIdAndCurrency(userId, data.from_currency);\n const updatedDestWallet = await getWalletByUserIdAndCurrency(userId, data.to_currency);\n \n return c.json({ \n message: \"Transfer completed successfully\", \n transaction,\n source_wallet: updatedSourceWallet,\n destination_wallet: updatedDestWallet,\n exchange_rate: exchangeRate,\n converted_amount: convertedAmount,\n fee\n });\n } catch (error) {\n console.error(\"Transfer error:\", error);\n return c.json({ error: \"Failed to complete transfer\" }, 500);\n }\n});\n\n// Send money to another user\ntransaction.post(\"/send\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const data = await c.req.json() as SendMoneyRequest;\n \n // Validate input\n if (!data.to_email || !data.currency || !data.amount) {\n return c.json({ error: \"Recipient email, currency, and amount are required\" }, 400);\n }\n \n if (data.amount <= 0) {\n return c.json({ error: \"Amount must be greater than zero\" }, 400);\n }\n \n // Check if recipient exists\n const recipient = await getUserByEmail(data.to_email);\n if (!recipient) {\n return c.json({ error: \"Recipient not found\" }, 404);\n }\n \n // Check if sending to self\n if (recipient.id === userId) {\n return c.json({ error: \"Cannot send money to yourself\" }, 400);\n }\n \n // Get sender wallet\n const senderWallet = await getWalletByUserIdAndCurrency(userId, data.currency);\n if (!senderWallet) {\n return c.json({ error: `${data.currency} wallet not found` }, 404);\n }\n \n // Get recipient wallet\n const recipientWallet = await getWalletByUserIdAndCurrency(recipient.id, data.currency);\n if (!recipientWallet) {\n return c.json({ error: `Recipient does not have a ${data.currency} wallet` }, 404);\n }\n \n // Check if sender wallet has enough balance\n if (senderWallet.balance < data.amount) {\n return c.json({ error: \"Insufficient balance\" }, 400);\n }\n \n // Check transaction limits\n const singleTransferLimit = await getTransactionLimitByTypeAndCurrency(\n userId, \n \"single_transfer\", \n data.currency\n );\n \n if (singleTransferLimit && data.amount > singleTransferLimit.amount) {\n return c.json({ \n error: `Amount exceeds your single transfer limit of ${singleTransferLimit.amount} ${data.currency}` \n }, 400);\n }\n \n // Calculate fee\n const fee = calculateTransactionFee(data.amount, \"transfer\");\n \n // Generate transaction reference\n const reference = generateTransactionReference();\n \n // Create transaction record for sender\n const senderTransaction = await createTransaction({\n user_id: userId,\n transaction_type: \"transfer\",\n from_wallet_id: senderWallet.id,\n to_wallet_id: recipientWallet.id,\n from_currency: data.currency,\n to_currency: data.currency,\n amount: data.amount,\n fee,\n status: \"completed\",\n reference,\n description: data.description || `Transfer to ${recipient.email}`\n });\n \n // Create transaction record for recipient\n const recipientTransaction = await createTransaction({\n user_id: recipient.id,\n transaction_type: \"deposit\",\n from_wallet_id: senderWallet.id,\n to_wallet_id: recipientWallet.id,\n from_currency: data.currency,\n to_currency: data.currency,\n amount: data.amount - fee,\n fee: 0,\n status: \"completed\",\n reference,\n description: `Received from ${payload.email}`\n });\n \n // Update wallet balances\n await updateWalletBalance(senderWallet.id, senderWallet.balance - data.amount);\n await updateWalletBalance(recipientWallet.id, recipientWallet.balance + (data.amount - fee));\n \n // Get updated sender wallet\n const updatedSenderWallet = await getWalletByUserIdAndCurrency(userId, data.currency);\n \n return c.json({ \n message: \"Transfer completed successfully\", \n transaction: senderTransaction,\n wallet: updatedSenderWallet,\n fee\n });\n } catch (error) {\n console.error(\"Send money error:\", error);\n return c.json({ error: \"Failed to send money\" }, 500);\n }\n});\n\n// Get transaction history\ntransaction.get(\"/history\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get query parameters\n const limit = parseInt(c.req.query(\"limit\") || \"50\");\n const offset = parseInt(c.req.query(\"offset\") || \"0\");\n \n // Get transactions\n const transactions = await getTransactionsByUserId(userId, limit, offset);\n \n return c.json({ transactions });\n } catch (error) {\n console.error(\"Get transaction history error:\", error);\n return c.json({ error: \"Failed to get transaction history\" }, 500);\n }\n});\n\n// Set transaction limit\ntransaction.post(\"/set-limit\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const data = await c.req.json() as SetLimitRequest;\n \n // Validate input\n if (!data.limit_type || !data.currency || data.amount === undefined) {\n return c.json({ error: \"Limit type, currency, and amount are required\" }, 400);\n }\n \n if (data.amount < 0) {\n return c.json({ error: \"Amount must be greater than or equal to zero\" }, 400);\n }\n \n // Check if currency is supported\n const supportedCurrencies: Currency[] = [\"USD\", \"GBP\", \"NGN\", \"EUR\"];\n if (!supportedCurrencies.includes(data.currency)) {\n return c.json({ error: \"Unsupported currency\" }, 400);\n }\n \n // Check if limit type is supported\n const supportedLimitTypes = [\"daily_transfer\", \"single_transfer\", \"daily_withdrawal\", \"single_withdrawal\"];\n if (!supportedLimitTypes.includes(data.limit_type)) {\n return c.json({ error: \"Unsupported limit type\" }, 400);\n }\n \n // Set transaction limit\n const limit = await setTransactionLimit({\n user_id: userId,\n limit_type: data.limit_type,\n currency: data.currency,\n amount: data.amount\n });\n \n return c.json({ \n message: \"Transaction limit set successfully\", \n limit \n });\n } catch (error) {\n console.error(\"Set transaction limit error:\", error);\n return c.json({ error: \"Failed to set transaction limit\" }, 500);\n }\n});\n\n// Get transaction limits\ntransaction.get(\"/limits\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get transaction limits\n const limits = await getTransactionLimitsByUserId(userId);\n \n return c.json({ limits });\n } catch (error) {\n console.error(\"Get transaction limits error:\", error);\n return c.json({ error: \"Failed to get transaction limits\" }, 500);\n }\n});\n\nexport default transaction;",[],[152,307,317],"c7ae5f38-34df-11f0-b85a-9e149126039e","support.ts","c7ae6000-34df-11f0-b85a-9e149126039e",10,["D",1747679618082],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { authMiddleware } from \"./auth.ts\";\nimport { \n createSupportChat, \n getSupportChatsByUserId, \n updateSupportChatStatus,\n createSupportMessage,\n getSupportMessagesByChatId\n} from \"../database/queries.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { SendMessageRequest } from \"../../shared/types.ts\";\n\n// Create a new Hono app for support routes\nconst support = new Hono();\n\n// Apply auth middleware to all routes\nsupport.use(\"*\", authMiddleware());\n\n// Create a new support chat\nsupport.post(\"/chat\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Create support chat\n const chat = await createSupportChat(userId);\n \n // Create initial system message\n await createSupportMessage({\n chat_id: chat.id,\n sender_type: \"support\",\n sender_id: \"system\",\n message: \"Welcome to GodinoMawa Bank support! How can we help you today?\"\n });\n \n return c.json({ \n message: \"Support chat created successfully\", \n chat \n });\n } catch (error) {\n console.error(\"Create support chat error:\", error);\n return c.json({ error: \"Failed to create support chat\" }, 500);\n }\n});\n\n// Get all support chats\nsupport.get(\"/chats\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get support chats\n const chats = await getSupportChatsByUserId(userId);\n \n return c.json({ chats });\n } catch (error) {\n console.error(\"Get support chats error:\", error);\n return c.json({ error: \"Failed to get support chats\" }, 500);\n }\n});\n\n// Close support chat\nsupport.post(\"/chat/:id/close\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const chatId = c.req.param(\"id\");\n \n // Update chat status\n await updateSupportChatStatus(chatId, \"closed\");\n \n return c.json({ \n message: \"Support chat closed successfully\" \n });\n } catch (error) {\n console.error(\"Close support chat error:\", error);\n return c.json({ error: \"Failed to close support chat\" }, 500);\n }\n});\n\n// Send message in support chat\nsupport.post(\"/chat/:id/message\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const chatId = c.req.param(\"id\");\n const data = await c.req.json() as SendMessageRequest;\n \n // Validate input\n if (!data.message) {\n return c.json({ error: \"Message is required\" }, 400);\n }\n \n // Create message\n const message = await createSupportMessage({\n chat_id: chatId,\n sender_type: \"user\",\n sender_id: userId,\n message: data.message\n });\n \n // Simulate support agent response after 2 seconds\n setTimeout(async () => {\n await createSupportMessage({\n chat_id: chatId,\n sender_type: \"support\",\n sender_id: \"agent\",\n message: getAutomatedResponse(data.message)\n });\n }, 2000);\n \n return c.json({ \n message: \"Message sent successfully\", \n chat_message: message \n });\n } catch (error) {\n console.error(\"Send message error:\", error);\n return c.json({ error: \"Failed to send message\" }, 500);\n }\n});\n\n// Get messages in support chat\nsupport.get(\"/chat/:id/messages\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const chatId = c.req.param(\"id\");\n \n // Get messages\n const messages = await getSupportMessagesByChatId(chatId);\n \n return c.json({ messages });\n } catch (error) {\n console.error(\"Get messages error:\", error);\n return c.json({ error: \"Failed to get messages\" }, 500);\n }\n});\n\n// Send support email\nsupport.post(\"/email\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const data = await c.req.json();\n \n // Validate input\n if (!data.subject || !data.message) {\n return c.json({ error: \"Subject and message are required\" }, 400);\n }\n \n // Send email (in a real app, this would send to support team)\n await email({\n subject: `Support Request: ${data.subject}`,\n text: `From: ${payload.email}\\n\\n${data.message}`,\n html: `

From: ${payload.email}

${data.message}

`\n });\n \n return c.json({ \n message: \"Support email sent successfully\" \n });\n } catch (error) {\n console.error(\"Send support email error:\", error);\n return c.json({ error: \"Failed to send support email\" }, 500);\n }\n});\n\n// Helper function to generate automated responses\nfunction getAutomatedResponse(message: string): string {\n const lowerMessage = message.toLowerCase();\n \n if (lowerMessage.includes(\"hello\") || lowerMessage.includes(\"hi\")) {\n return \"Hello! How can I assist you with your GodinoMawa Bank account today?\";\n } else if (lowerMessage.includes(\"account\") || lowerMessage.includes(\"wallet\")) {\n return \"For account or wallet inquiries, please provide your account number or wallet currency, and I'll be happy to assist you further.\";\n } else if (lowerMessage.includes(\"transfer\") || lowerMessage.includes(\"send money\")) {\n return \"To make a transfer, go to the 'Transfer' section in your dashboard. You can transfer between your own wallets or send money to other GodinoMawa Bank users.\";\n } else if (lowerMessage.includes(\"exchange\") || lowerMessage.includes(\"convert\")) {\n return \"Currency exchange is available in the 'Transfer' section. You can convert between USD, GBP, EUR, and NGN at competitive rates.\";\n } else if (lowerMessage.includes(\"kyc\") || lowerMessage.includes(\"verification\")) {\n return \"KYC verification is required to use all features of GodinoMawa Bank. You can complete your verification in the 'KYC' section of your account.\";\n } else if (lowerMessage.includes(\"limit\") || lowerMessage.includes(\"restriction\")) {\n return \"You can set and manage your transaction limits in the 'Settings' section of your account.\";\n } else if (lowerMessage.includes(\"thank\")) {\n return \"You're welcome! Is there anything else I can help you with today?\";\n } else {\n return \"Thank you for your message. Our support team will review it and get back to you shortly. Is there anything else you'd like to know?\";\n }\n}\n\nexport default support;",[],[152,307,325],"8e5ba150-34df-11f0-af58-9e149126039e","kyc.ts","8e5ba1fa-34df-11f0-af58-9e149126039e",7,["D",1747679521911],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { authMiddleware } from \"./auth.ts\";\nimport { createKycSubmission, getKycSubmissionByUserId, updateKycStatus } from \"../database/queries.ts\";\nimport { KycSubmissionRequest } from \"../../shared/types.ts\";\nimport { doNamesMatch } from \"../../shared/utils.ts\";\n\n// Create a new Hono app for KYC routes\nconst kyc = new Hono();\n\n// Apply auth middleware to all routes\nkyc.use(\"*\", authMiddleware());\n\n// Submit KYC\nkyc.post(\"/submit\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n const data = await c.req.json() as KycSubmissionRequest;\n \n // Validate input\n if (!data.full_name || !data.id_type || !data.id_number || !data.document_url || !data.selfie_url) {\n return c.json({ error: \"All KYC fields are required\" }, 400);\n }\n \n // Check if KYC already submitted\n const existingKyc = await getKycSubmissionByUserId(userId);\n if (existingKyc) {\n return c.json({ \n error: \"KYC already submitted\", \n status: existingKyc.status \n }, 409);\n }\n \n // Check if name matches the name provided during registration\n if (!doNamesMatch(data.full_name, payload.name)) {\n return c.json({ error: \"Name does not match the name on your account\" }, 400);\n }\n \n // Create KYC submission\n const kycSubmission = await createKycSubmission({\n user_id: userId,\n full_name: data.full_name,\n id_type: data.id_type,\n id_number: data.id_number,\n document_url: data.document_url,\n selfie_url: data.selfie_url\n });\n \n // For demo purposes, automatically approve KYC after 5 seconds\n setTimeout(async () => {\n await updateKycStatus(kycSubmission.id, \"approved\");\n console.log(`KYC approved for user ${userId}`);\n }, 5000);\n \n return c.json({ \n message: \"KYC submitted successfully\", \n kyc: kycSubmission \n });\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\nkyc.get(\"/status\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get KYC submission\n const kycSubmission = await getKycSubmissionByUserId(userId);\n if (!kycSubmission) {\n return c.json({ status: \"not_submitted\" });\n }\n \n return c.json({ \n status: kycSubmission.status,\n submitted_at: kycSubmission.submitted_at,\n verified_at: kycSubmission.verified_at\n });\n } catch (error) {\n console.error(\"Get KYC status error:\", error);\n return c.json({ error: \"Failed to get KYC status\" }, 500);\n }\n});\n\n// Upload document image\nkyc.post(\"/upload-document\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get form data\n const formData = await c.req.formData();\n const file = formData.get(\"document\") as File;\n \n if (!file) {\n return c.json({ error: \"No document file provided\" }, 400);\n }\n \n // Read file as base64\n const arrayBuffer = await file.arrayBuffer();\n const base64 = btoa(String.fromCharCode(...new Uint8Array(arrayBuffer)));\n const dataUrl = `data:${file.type};base64,${base64}`;\n \n // Store in blob storage\n const documentKey = `kyc_document_${userId}_${Date.now()}`;\n await blob.set(documentKey, dataUrl);\n \n return c.json({ \n message: \"Document uploaded successfully\", \n document_url: documentKey \n });\n } catch (error) {\n console.error(\"Document upload error:\", error);\n return c.json({ error: \"Failed to upload document\" }, 500);\n }\n});\n\n// Upload selfie image\nkyc.post(\"/upload-selfie\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get form data\n const formData = await c.req.formData();\n const file = formData.get(\"selfie\") as File;\n \n if (!file) {\n return c.json({ error: \"No selfie file provided\" }, 400);\n }\n \n // Read file as base64\n const arrayBuffer = await file.arrayBuffer();\n const base64 = btoa(String.fromCharCode(...new Uint8Array(arrayBuffer)));\n const dataUrl = `data:${file.type};base64,${base64}`;\n \n // Store in blob storage\n const selfieKey = `kyc_selfie_${userId}_${Date.now()}`;\n await blob.set(selfieKey, dataUrl);\n \n return c.json({ \n message: \"Selfie uploaded successfully\", \n selfie_url: selfieKey \n });\n } catch (error) {\n console.error(\"Selfie upload error:\", error);\n return c.json({ error: \"Failed to upload selfie\" }, 500);\n }\n});\n\n// Get document or selfie image\nkyc.get(\"/image/:key\", async (c) => {\n try {\n const key = c.req.param(\"key\");\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Verify that the key belongs to the user\n if (!key.includes(userId)) {\n return c.json({ error: \"Unauthorized access to image\" }, 403);\n }\n \n // Get image from blob storage\n const image = await blob.get(key);\n if (!image) {\n return c.json({ error: \"Image not found\" }, 404);\n }\n \n // Extract content type from data URL\n const contentType = image.split(\";\")[0].split(\":\")[1];\n \n // Return image\n return new Response(image, {\n headers: {\n \"Content-Type\": contentType\n }\n });\n } catch (error) {\n console.error(\"Get image error:\", error);\n return c.json({ error: \"Failed to get image\" }, 500);\n }\n});\n\nexport default kyc;",[],[152,307,333],"753d522c-34df-11f0-9f57-9e149126039e","auth.ts","753d52ea-34df-11f0-9f57-9e149126039e",6,["D",1747679479773],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/middleware/jwt\";\nimport { createUser, getUserByEmail, getUserById } from \"../database/queries.ts\";\nimport { User, UserRegistration, UserLogin, AuthResponse } from \"../../shared/types.ts\";\nimport { isValidEmail, isStrongPassword } from \"../../shared/utils.ts\";\n\n// Create a new Hono app for auth routes\nconst auth = new Hono();\n\n// Secret key for JWT\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"gm_bank_secret_key\";\n\n// Register a new user\nauth.post(\"/register\", async (c) => {\n try {\n const data = await c.req.json() as UserRegistration;\n \n // Validate input\n if (!data.email || !data.password || !data.full_name) {\n return c.json({ error: \"Email, password, and full name are required\" }, 400);\n }\n \n // Validate email format\n if (!isValidEmail(data.email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n \n // Validate password strength\n if (!isStrongPassword(data.password)) {\n return c.json({ error: \"Password must be at least 8 characters long\" }, 400);\n }\n \n // Check if user already exists\n const existingUser = await getUserByEmail(data.email);\n if (existingUser) {\n return c.json({ error: \"Email already registered\" }, 409);\n }\n \n // Hash password (in a real app, use a proper password hashing library)\n const encoder = new TextEncoder();\n const passwordData = encoder.encode(data.password);\n const hashBuffer = await crypto.subtle.digest(\"SHA-256\", passwordData);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n const passwordHash = hashArray.map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n \n // Create user\n const newUser = await createUser({\n email: data.email,\n password_hash: passwordHash,\n full_name: data.full_name,\n created_at: Date.now(),\n updated_at: Date.now(),\n kyc_verified: false,\n is_admin: false\n });\n \n // Generate JWT token\n const token = await generateToken(newUser);\n \n // Return user data (excluding password hash)\n const { password_hash, ...userWithoutPassword } = newUser;\n \n return c.json({ token, user: userWithoutPassword } as AuthResponse);\n } catch (error) {\n console.error(\"Registration error:\", error);\n return c.json({ error: \"Failed to register user\" }, 500);\n }\n});\n\n// Login user\nauth.post(\"/login\", async (c) => {\n try {\n const data = await c.req.json() as UserLogin;\n \n // Validate input\n if (!data.email || !data.password) {\n return c.json({ error: \"Email and password are required\" }, 400);\n }\n \n // Get user by email\n const user = await getUserByEmail(data.email);\n if (!user) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Hash password and compare\n const encoder = new TextEncoder();\n const passwordData = encoder.encode(data.password);\n const hashBuffer = await crypto.subtle.digest(\"SHA-256\", passwordData);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n const passwordHash = hashArray.map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n \n // Check if password matches\n if (user.password_hash !== passwordHash) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Generate JWT token\n const token = await generateToken(user);\n \n // Return user data (excluding password hash)\n const { password_hash, ...userWithoutPassword } = user;\n \n return c.json({ token, user: userWithoutPassword } as AuthResponse);\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({ error: \"Failed to login\" }, 500);\n }\n});\n\n// Get current user\nauth.get(\"/me\", jwt({ secret: JWT_SECRET }), async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const userId = payload.sub;\n \n // Get user by ID\n const user = await getUserById(userId);\n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n // Return user data (excluding password hash)\n const { password_hash, ...userWithoutPassword } = user;\n \n return c.json(userWithoutPassword);\n } catch (error) {\n console.error(\"Get user error:\", error);\n return c.json({ error: \"Failed to get user\" }, 500);\n }\n});\n\n// Generate JWT token\nasync function generateToken(user: User): Promise {\n const payload = {\n sub: user.id,\n email: user.email,\n name: user.full_name,\n admin: user.is_admin,\n exp: Math.floor(Date.now() / 1000) + 60 * 60 * 24 // 24 hours\n };\n \n // Create JWT token\n const encoder = new TextEncoder();\n const secretKey = encoder.encode(JWT_SECRET);\n const key = await crypto.subtle.importKey(\n \"raw\",\n secretKey,\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"]\n );\n \n const header = encoder.encode(JSON.stringify({ alg: \"HS256\", typ: \"JWT\" }));\n const encodedHeader = btoa(String.fromCharCode(...new Uint8Array(header))).replace(/=/g, \"\");\n \n const encodedPayload = btoa(JSON.stringify(payload)).replace(/=/g, \"\");\n \n const signature = await crypto.subtle.sign(\n \"HMAC\",\n key,\n encoder.encode(`${encodedHeader}.${encodedPayload}`)\n );\n \n const encodedSignature = btoa(String.fromCharCode(...new Uint8Array(signature))).replace(/=/g, \"\");\n \n return `${encodedHeader}.${encodedPayload}.${encodedSignature}`;\n}\n\n// Middleware to verify JWT token\nexport function authMiddleware() {\n return jwt({ secret: JWT_SECRET });\n}\n\nexport default auth;",[],[152,307,341],"753d7cca-34df-11f0-9f57-9e149126039e",["D",1747679479773],[172,173,174,175,176,177],[152,307],"4ef72124-34df-11f0-acaa-9e149126039e","queries.ts","4ef721d8-34df-11f0-acaa-9e149126039e","02f24975-7d7f-4c55-9bd4-d7d1215bdee1",3,["D",1747679415560],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { \n USERS_TABLE, \n KYC_TABLE, \n WALLETS_TABLE, \n TRANSACTIONS_TABLE,\n TRANSACTION_LIMITS_TABLE,\n SUPPORT_CHATS_TABLE,\n SUPPORT_MESSAGES_TABLE\n} from \"./migrations.ts\";\nimport { \n User, \n KycSubmission, \n Wallet, \n Transaction,\n TransactionLimit,\n SupportChat,\n SupportMessage,\n Currency\n} from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (id, email, password_hash, full_name, created_at, updated_at, kyc_verified, is_admin)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [id, user.email, user.password_hash, user.full_name, now, now, user.kyc_verified || false, user.is_admin || false]\n );\n \n return { id, ...user, created_at: now, updated_at: now };\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(userId: string, verified: boolean): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET kyc_verified = ?, updated_at = ? WHERE id = ?`,\n [verified, now, userId]\n );\n}\n\n// KYC queries\nexport async function createKycSubmission(kyc: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n const status = \"pending\";\n \n await sqlite.execute(\n `INSERT INTO ${KYC_TABLE} (id, user_id, full_name, id_type, id_number, document_url, selfie_url, status, submitted_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [id, kyc.user_id, kyc.full_name, kyc.id_type, kyc.id_number, kyc.document_url, kyc.selfie_url, status, now]\n );\n \n return { id, ...kyc, status, submitted_at: now, verified_at: null };\n}\n\nexport async function getKycSubmissionByUserId(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 KycSubmission;\n}\n\nexport async function updateKycStatus(kycId: string, status: string): Promise {\n const now = Date.now();\n const verified_at = status === \"approved\" ? now : null;\n \n await sqlite.execute(\n `UPDATE ${KYC_TABLE} SET status = ?, verified_at = ? WHERE id = ?`,\n [status, verified_at, kycId]\n );\n \n if (status === \"approved\") {\n const kyc = await getKycById(kycId);\n if (kyc) {\n await updateUserKycStatus(kyc.user_id, true);\n }\n }\n}\n\nexport async function getKycById(kycId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${KYC_TABLE} WHERE id = ?`,\n [kycId]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as KycSubmission;\n}\n\n// Wallet queries\nexport async function createWallet(wallet: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${WALLETS_TABLE} (\n id, user_id, currency, balance, account_number, bank_name, routing_number, \n sort_code, iban, bic, nuban, created_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, wallet.user_id, wallet.currency, wallet.balance || 0, wallet.account_number,\n wallet.bank_name, wallet.routing_number, wallet.sort_code, wallet.iban,\n wallet.bic, wallet.nuban, now, now\n ]\n );\n \n return { id, ...wallet, created_at: now, updated_at: now };\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(userId: string, currency: Currency): 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(walletId: string, newBalance: number): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${WALLETS_TABLE} SET balance = ?, updated_at = ? WHERE id = ?`,\n [newBalance, now, walletId]\n );\n}\n\n// Transaction queries\nexport async function createTransaction(transaction: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${TRANSACTIONS_TABLE} (\n id, user_id, transaction_type, from_wallet_id, to_wallet_id, from_currency, to_currency,\n amount, fee, exchange_rate, status, reference, description, created_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n id, transaction.user_id, transaction.transaction_type, transaction.from_wallet_id,\n transaction.to_wallet_id, transaction.from_currency, transaction.to_currency,\n transaction.amount, transaction.fee || 0, transaction.exchange_rate,\n transaction.status, transaction.reference, transaction.description, now, now\n ]\n );\n \n return { id, ...transaction, created_at: now, updated_at: now };\n}\n\nexport async function getTransactionsByUserId(userId: string, limit = 50, offset = 0): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTIONS_TABLE} WHERE user_id = ? ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [userId, limit, offset]\n );\n \n return result.rows as Transaction[];\n}\n\nexport async function updateTransactionStatus(transactionId: string, status: string): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${TRANSACTIONS_TABLE} SET status = ?, updated_at = ? WHERE id = ?`,\n [status, now, transactionId]\n );\n}\n\n// Transaction limits queries\nexport async function setTransactionLimit(limit: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n // Check if limit already exists\n const existingLimit = await getTransactionLimitByTypeAndCurrency(limit.user_id, limit.limit_type, limit.currency);\n \n if (existingLimit) {\n // Update existing limit\n await sqlite.execute(\n `UPDATE ${TRANSACTION_LIMITS_TABLE} SET amount = ?, updated_at = ? WHERE id = ?`,\n [limit.amount, now, existingLimit.id]\n );\n \n return { ...existingLimit, amount: limit.amount, updated_at: now };\n } else {\n // Create new limit\n await sqlite.execute(\n `INSERT INTO ${TRANSACTION_LIMITS_TABLE} (id, user_id, limit_type, currency, amount, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [id, limit.user_id, limit.limit_type, limit.currency, limit.amount, now, now]\n );\n \n return { id, ...limit, created_at: now, updated_at: now };\n }\n}\n\nexport async function getTransactionLimitByTypeAndCurrency(\n userId: string, \n limitType: string, \n currency: Currency\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTION_LIMITS_TABLE} WHERE user_id = ? AND limit_type = ? AND currency = ?`,\n [userId, limitType, currency]\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 getTransactionLimitsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TRANSACTION_LIMITS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n return result.rows as TransactionLimit[];\n}\n\n// Support chat queries\nexport async function createSupportChat(userId: string): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n const status = \"open\";\n \n await sqlite.execute(\n `INSERT INTO ${SUPPORT_CHATS_TABLE} (id, user_id, status, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?)`,\n [id, userId, status, now, now]\n );\n \n return { id, user_id: userId, status, created_at: now, updated_at: now };\n}\n\nexport async function getSupportChatsByUserId(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SUPPORT_CHATS_TABLE} WHERE user_id = ? ORDER BY updated_at DESC`,\n [userId]\n );\n \n return result.rows as SupportChat[];\n}\n\nexport async function updateSupportChatStatus(chatId: string, status: string): Promise {\n const now = Date.now();\n \n await sqlite.execute(\n `UPDATE ${SUPPORT_CHATS_TABLE} SET status = ?, updated_at = ? WHERE id = ?`,\n [status, now, chatId]\n );\n}\n\n// Support message queries\nexport async function createSupportMessage(message: Omit): Promise {\n const id = crypto.randomUUID();\n const now = Date.now();\n \n await sqlite.execute(\n `INSERT INTO ${SUPPORT_MESSAGES_TABLE} (id, chat_id, sender_type, sender_id, message, created_at)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [id, message.chat_id, message.sender_type, message.sender_id, message.message, now]\n );\n \n // Update chat updated_at timestamp\n await sqlite.execute(\n `UPDATE ${SUPPORT_CHATS_TABLE} SET updated_at = ? WHERE id = ?`,\n [now, message.chat_id]\n );\n \n return { id, ...message, created_at: now };\n}\n\nexport async function getSupportMessagesByChatId(chatId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SUPPORT_MESSAGES_TABLE} WHERE chat_id = ? ORDER BY created_at ASC`,\n [chatId]\n );\n \n return result.rows as SupportMessage[];\n}",[],[152,361,353],"database","368386d2-34df-11f0-9fa9-9e149126039e","migrations.ts","36838786-34df-11f0-9fa9-9e149126039e",["D",1747679374537],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning to allow schema changes\nexport const USERS_TABLE = \"gm_users_v1\";\nexport const KYC_TABLE = \"gm_kyc_v1\";\nexport const WALLETS_TABLE = \"gm_wallets_v1\";\nexport const TRANSACTIONS_TABLE = \"gm_transactions_v1\";\nexport const TRANSACTION_LIMITS_TABLE = \"gm_transaction_limits_v1\";\nexport const SUPPORT_CHATS_TABLE = \"gm_support_chats_v1\";\nexport const SUPPORT_MESSAGES_TABLE = \"gm_support_messages_v1\";\n\n// Run all migrations\nexport async function runMigrations() {\n await createUsersTable();\n await createKycTable();\n await createWalletsTable();\n await createTransactionsTable();\n await createTransactionLimitsTable();\n await createSupportChatsTable();\n await createSupportMessagesTable();\n}\n\n// Create users table\nasync function createUsersTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n email TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n full_name TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n kyc_verified BOOLEAN DEFAULT FALSE,\n is_admin BOOLEAN DEFAULT FALSE\n )\n `);\n}\n\n// Create KYC table\nasync function createKycTable() {\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 document_url TEXT NOT NULL,\n selfie_url TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending',\n submitted_at INTEGER NOT NULL,\n verified_at INTEGER,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n}\n\n// Create wallets table\nasync function createWalletsTable() {\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 REAL NOT NULL DEFAULT 0,\n account_number TEXT NOT NULL,\n bank_name TEXT,\n routing_number TEXT,\n sort_code TEXT,\n iban TEXT,\n bic TEXT,\n nuban TEXT,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n UNIQUE(user_id, currency)\n )\n `);\n}\n\n// Create transactions table\nasync function createTransactionsTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TRANSACTIONS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n transaction_type TEXT NOT NULL,\n from_wallet_id TEXT,\n to_wallet_id TEXT,\n from_currency TEXT,\n to_currency TEXT,\n amount REAL NOT NULL,\n fee REAL NOT NULL DEFAULT 0,\n exchange_rate REAL,\n status TEXT NOT NULL,\n reference TEXT,\n description TEXT,\n created_at INTEGER NOT NULL,\n updated_at INTEGER 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 )\n `);\n}\n\n// Create transaction limits table\nasync function createTransactionLimitsTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TRANSACTION_LIMITS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n limit_type TEXT NOT NULL,\n currency TEXT NOT NULL,\n amount REAL NOT NULL,\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id),\n UNIQUE(user_id, limit_type, currency)\n )\n `);\n}\n\n// Create support chats table\nasync function createSupportChatsTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SUPPORT_CHATS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'open',\n created_at INTEGER NOT NULL,\n updated_at INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE} (id)\n )\n `);\n}\n\n// Create support messages table\nasync function createSupportMessagesTable() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SUPPORT_MESSAGES_TABLE} (\n id TEXT PRIMARY KEY,\n chat_id TEXT NOT NULL,\n sender_type TEXT NOT NULL,\n sender_id TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n FOREIGN KEY (chat_id) REFERENCES ${SUPPORT_CHATS_TABLE} (id)\n )\n `);\n}",[],[152,361,363],"3683c098-34df-11f0-9fa9-9e149126039e",["D",1747679374537],[169,170],[152,361],["D",1747679374537],[168,171,178],[152],["D",1747679018388],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},{"_13":82,"_31":83,"_42":41,"_84":43,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":44,"_91":92},"ctx",{"_75":-5,"_120":413,"_414":415,"_416":417,"_418":24,"_419":24,"_420":24,"_421":133,"_422":-5,"_423":-7,"_424":-7,"_425":59,"_426":24,"_427":24,"_428":-5,"_429":24,"_430":24,"_431":24,"_432":-5},"ENV",{"_384":385,"_386":387,"_388":83,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","81405aa0531e90dfbb71a5bf473aaa0cf4c8702f","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 · v20