🏦 Access Bank

\n {!isLoggedIn ? (\n !isSignup ? (\n \n ) : (\n

\n setSignupData({...signupData, name: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, email: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, newUsername: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, newPassword: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, confirmPassword: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, routingNumber: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, accountNumber: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, ssn: e.target.value})}\n required\n style={inputStyle}\n />\n setSignupData({...signupData, dlNumber: e.target.value})}\n required\n style={inputStyle}\n />\n \n

setIsSignup(false)} \n style={{ \n textAlign: 'center', \n color: '#4CAF50', \n cursor: 'pointer',\n marginTop: '10px'\n }}\n >\n Already have an account? Login\n

\n {error &&

{error}

}\n

\n )\n ) : (\n

Welcome, {accountDetails.name} 👋

Account Number: {accountDetails.accountNumber}

Balance: 💰 ${accountDetails.balance.toFixed(2)}

\n {!isTransferMode ? (\n

\n \n \n

\n ) : (\n

\n setTransferData({...transferData, recipientAccountNumber: e.target.value})}\n required\n style={inputStyle}\n />\n setTransferData({...transferData, amount: e.target.value})}\n min=\"700\"\n required\n style={inputStyle}\n />\n \n \n

\n )}\n {error &&

{error}

}\n

\n )}\n \n View Source\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 4;\n\n // Initialize database with additional fields\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n username TEXT PRIMARY KEY,\n password TEXT NOT NULL,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n routing_number TEXT NOT NULL,\n account_number TEXT NOT NULL,\n ssn TEXT NOT NULL,\n dl_number TEXT NOT NULL,\n balance REAL NOT NULL\n )\n `);\n\n // Create transfer history table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_transfers_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n sender_account TEXT NOT NULL,\n recipient_account TEXT NOT NULL,\n amount REAL NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Seed some initial users if not exists\n const users = await sqlite.execute(`SELECT * FROM ${KEY}_users_${SCHEMA_VERSION}`);\n if (users.rows.length === 0) {\n await sqlite.execute(`\n INSERT INTO ${KEY}_users_${SCHEMA_VERSION} \n (username, password, name, email, routing_number, account_number, ssn, dl_number, balance) VALUES \n ('john', 'pass123', 'John Doe', 'john@example.com', '123456789', '1234567890', '123-45-6789', 'DL12345', 5000.00),\n ('jane', 'pass456', 'Jane Smith', 'jane@example.com', '987654321', '0987654321', '987-65-4321', 'DL54321', 7500.50)\n `);\n }\n\n if (request.method === \"POST\") {\n const body = await request.json();\n\n if (request.url.includes(\"/login\")) {\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE username = ? AND password = ?`, \n [body.username, body.password]\n );\n\n if (result.rows.length > 0) {\n return new Response(JSON.stringify({\n success: true,\n account: {\n name: result.rows[0].name,\n accountNumber: result.rows[0].account_number,\n balance: result.rows[0].balance\n }\n }), { headers: { \"Content-Type\": \"application/json\" } });\n } else {\n return new Response(JSON.stringify({ \n success: false, \n message: \"Invalid credentials\" \n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n }\n\n if (request.url.includes(\"/transfer\")) {\n // Validate transfer amount\n const amount = parseFloat(body.amount);\n if (amount < 700) {\n return new Response(JSON.stringify({ \n success: false, \n message: \"Minimum transfer amount is $700\" \n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n // Find sender's account details\n const senderResult = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE account_number = ?`, \n [body.senderAccountNumber]\n );\n\n // Find recipient's account details\n const recipientResult = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE account_number = ?`, \n [body.recipientAccountNumber]\n );\n\n if (senderResult.rows.length === 0) {\n return new Response(JSON.stringify({ \n success: false, \n message: \"Sender account not found\" \n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n if (recipientResult.rows.length === 0) {\n return new Response(JSON.stringify({ \n success: false, \n message: \"Recipient account not found\" \n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n const sender = senderResult.rows[0];\n const recipient = recipientResult.rows[0];\n\n // Check sufficient balance\n if (sender.balance < amount) {\n return new Response(JSON.stringify({ \n success: false, \n message: \"Insufficient funds\" \n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n // Perform transfer\n await sqlite.execute(`\n UPDATE ${KEY}_users_${SCHEMA_VERSION} \n SET balance = balance - ? \n WHERE account_number = ?\n `, [amount, sender.account_number]);\n\n await sqlite.execute(`\n UPDATE ${KEY}_users_${SCHEMA_VERSION} \n SET balance = balance + ? \n WHERE account_number = ?\n `, [amount, recipient.account_number]);\n\n // Record transfer in history\n await sqlite.execute(`\n INSERT INTO ${KEY}_transfers_${SCHEMA_VERSION} \n (sender_account, recipient_account, amount) \n VALUES (?, ?, ?)\n `, [sender.account_number, recipient.account_number, amount]);\n\n // Fetch updated sender account details\n const updatedSenderResult = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE account_number = ?`, \n [sender.account_number]\n );\n\n return new Response(JSON.stringify({\n success: true,\n updatedAccount: {\n name: updatedSenderResult.rows[0].name,\n accountNumber: updatedSenderResult.rows[0].account_number,\n balance: updatedSenderResult.rows[0].balance\n }\n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n if (request.url.includes(\"/signup\")) {\n // Check if username already exists\n const existingUser = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} WHERE username = ?`, \n [body.username]\n );\n\n if (existingUser.rows.length > 0) {\n return new Response(JSON.stringify({ \n success: false, \n message: \"Username already exists\" \n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n // Insert new user with additional information\n await sqlite.execute(\n `INSERT INTO ${KEY}_users_${SCHEMA_VERSION} \n (username, password, name, email, routing_number, account_number, ssn, dl_number, balance) VALUES \n (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n body.username, \n body.password, \n body.name, \n body.email,\n body.routingNumber,\n body.accountNumber,\n body.ssn,\n body.dlNumber,\n 1000.00\n ]\n );\n\n return new Response(JSON.stringify({\n success: true,\n account: {\n name: body.name,\n accountNumber: body.accountNumber,\n balance: 1000.00\n }\n }), { headers: { \"Content-Type\": \"application/json\" } });\n }\n }\n\n return new Response(`\n \n \n Access Bank\n \n \n \n

\n \n \n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n}","createdAt",["D",1739807558228],"version",5,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","Sm202020","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydDlwRG5KQnB2QzNEZ3R2bEtVRTlhbXFKZ3QifQ","forkedVal","interval","slug","Sm202020/harmoniousMaroonFlyingfish","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[141,144,148,152,155,158],{"_117":118,"_142":-5,"_115":143,"_112":110},"prId",["D",1739807558228],{"_117":145,"_142":-5,"_115":146,"_112":147},4,["D",1739807415321],"e130e704-ed46-11ef-8a49-e6cdfca9ef9f",{"_117":149,"_142":-5,"_115":150,"_112":151},3,["D",1739806422097],"912f1ee4-ed44-11ef-960b-e6cdfca9ef9f",{"_117":90,"_142":-5,"_115":153,"_112":154},["D",1739806294174],"44ef5dbe-ed44-11ef-9d46-e6cdfca9ef9f",{"_117":124,"_142":-5,"_115":156,"_112":157},["D",1739806089105],"cab54680-ed43-11ef-9c4b-e6cdfca9ef9f",{"_117":31,"_142":-5,"_115":159,"_112":160},["D",1739806004418],"983a18fc-ed43-11ef-a97a-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[165],{"_112":166,"_167":168,"_115":169,"_170":-5,"_171":26,"_172":26,"_20":173},"1c44d02a-ed48-11ef-a1d6-e6cdfca9ef9f","body","An amazing banking app",["D",1739807943946],"updatedAt","canDelete","canEdit",{"_129":130,"_131":132},"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":177,"_178":179,"_94":180},"single","redirect","/v/Sm202020/harmoniousMaroonFlyingfish/versions",{"_112":154,"_113":181,"_117":90,"_115":182,"_183":99,"_100":101,"_107":108,"_129":130,"_11":96,"_184":-5,"_185":-5,"_186":-5,"_174":26,"_135":136},"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction App() {\n const [isLoggedIn, setIsLoggedIn] = useState(false);\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [accountDetails, setAccountDetails] = useState(null);\n const [error, setError] = useState(\"\");\n const [isSignup, setIsSignup] = useState(false);\n const [signupData, setSignupData] = useState({\n name: \"\",\n newUsername: \"\",\n newPassword: \"\",\n confirmPassword: \"\",\n routingNumber: \"\",\n accountNumber: \"\",\n ssn: \"\",\n dlNumber: \"\",\n email: \"\"\n });\n\n const validateSSN = (ssn) => {\n // Basic SSN validation (9 digits, allows formatting)\n const ssnRegex = /^(?!000|666)\\d{3}-?(?!00)\\d{2}-?(?!0000)\\d{4}$/;\n return ssnRegex.test(ssn.replace(/[-\\s]/g, ''));\n };\n\n const validateDLNumber = (dlNumber) => {\n // Basic Driver's License validation (alphanumeric, varies by state)\n const dlRegex = /^[A-Z0-9]{6,10}$/i;\n return dlRegex.test(dlNumber);\n };\n\n const validateRoutingNumber = (routingNumber) => {\n // Basic routing number validation (9 digits)\n const routingRegex = /^\\d{9}$/;\n return routingRegex.test(routingNumber);\n };\n\n const handleLogin = async (e) => {\n e.preventDefault();\n try {\n const response = await fetch(\"/login\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ username, password })\n });\n const data = await response.json();\n \n if (data.success) {\n setIsLoggedIn(true);\n setAccountDetails(data.account);\n setError(\"\");\n } else {\n setError(data.message);\n }\n } catch (err) {\n setError(\"Login failed. Please try again.\");\n }\n };\n\n const handleSignup = async (e) => {\n e.preventDefault();\n \n // Comprehensive validation\n if (signupData.newPassword !== signupData.confirmPassword) {\n setError(\"Passwords do not match\");\n return;\n }\n\n if (!validateSSN(signupData.ssn)) {\n setError(\"Invalid Social Security Number\");\n return;\n }\n\n if (!validateDLNumber(signupData.dlNumber)) {\n setError(\"Invalid Driver's License Number\");\n return;\n }\n\n if (!validateRoutingNumber(signupData.routingNumber)) {\n setError(\"Invalid Routing Number\");\n return;\n }\n\n try {\n const response = await fetch(\"/signup\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n name: signupData.name,\n username: signupData.newUsername,\n password: signupData.newPassword,\n routingNumber: signupData.routingNumber,\n accountNumber: signupData.accountNumber,\n ssn: signupData.ssn,\n dlNumber: signupData.dlNumber,\n email: signupData.email\n })\n });\n const data = await response.json();\n \n if (data.success) {\n setIsLoggedIn(true);\n setAccountDetails(data.account);\n setError(\"\");\n } else {\n setError(data.message);\n }\n } catch (err) {\n setError(\"Signup failed. Please try again.\");\n }\n };\n\n const handleLogout = () => {\n setIsLoggedIn(false);\n setAccountDetails(null);\n setUsername(\"\");\n setPassword(\"\");\n };\n\n const inputStyle = { \n width: '100%', \n padding: '10px', \n margin: '10px 0',\n border: '1px solid #ddd',\n borderRadius: '4px'\n };\n\n const buttonStyle = { \n width: '100%', \n padding: '10px', \n backgroundColor: '#4CAF50', \n color: 'white', \n border: 'none',\n borderRadius: '4px',\n cursor: 'pointer'\n };\n\n return (\n

🏦 Access Bank

\n {!isLoggedIn ? (\n !isSignup ? (\n \n ) : (\n

setIsSignup(false)} \n style={{ \n textAlign: 'center', \n color: '#4CAF50', \n cursor: 'pointer',\n marginTop: '10px'\n }}\n >\n Already have an account? Login\n

\n {error &&

{error}

}\n

\n )\n ) : (\n

Welcome, {accountDetails.name} 👋

Account Number: {accountDetails.accountNumber}

Balance: 💰 ${accountDetails.balance.toFixed(2)}

\n \n

\n )}\n \n View Source\n \n

\n \n \n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n}",["D",1739806294174],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

harmoniousMaroonFlyingfish

Version 2