🏦 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}",["D",1739807558228],"version",5,"currentUserHasLiked","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_96":97,"_101":102},"forkedVal","interval","description","@jsxImportSource https://esm.sh/react@18.2.0","latestEvaluation","slug","Sm202020/harmoniousMaroonFlyingfish","versions",[160,164,168,172,175,178],{"_98":161,"_142":143,"_162":163},["D",1739807558228],"n","1",{"_98":165,"_142":166,"_162":167},["D",1739807415321],4,"2",{"_98":169,"_142":170,"_162":171},["D",1739806422097],3,"3",{"_98":173,"_142":90,"_162":174},["D",1739806294174],"4",{"_98":176,"_142":110,"_162":177},["D",1739806089105],"5",{"_98":179,"_142":31,"_162":180},["D",1739806004418],"6","hasNext","filters",{"_184":185,"_186":187,"_131":132},"sort","newest","type","all","routes/_app","actionData","errors"]