🏦 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":110,"_113":114,"_117":118,"_115":181,"_182":99,"_100":101,"_107":108,"_129":130,"_11":96,"_183":-5,"_184":-5,"_185":-5,"_174":26,"_135":136},["D",1739807558228],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

harmoniousMaroonFlyingfish

Version 5