Peoples BANKCORP Online Banking

Peoples BANKCORP Online Banking

\n {error &&

{error}

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

\n setView('signup')}>Create Account | \n setView('reset')}>Forgot Password?\n

\n );\n\n const renderSignup = () => (\n

Create Account

\n {error &&

{error}

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

\n setView('login')}>Back to Login\n

\n );\n\n const renderPasswordReset = () => (\n

Reset Password

\n {error &&

{error}

}\n setEmail(e.target.value)}\n />\n setResetToken(e.target.value)}\n />\n setPassword(e.target.value)}\n />\n setConfirmPassword(e.target.value)}\n />\n \n

\n setView('login')}>Back to Login\n

\n );\n\n const renderTransferFunds = () => (\n

Bank Transfer

\n {error &&

{error}

}\n \n setTransferDetails({\n ...transferDetails, \n accountNumber: e.target.value\n })}\n />\n setTransferDetails({\n ...transferDetails, \n amount: e.target.value\n })}\n />\n setTransferDetails({\n ...transferDetails, \n description: e.target.value\n })}\n />\n \n \n

\n );\n\n const renderDashboard = () => (\n

Peoples BANKCORP Online Banking

Account Balance

${balance.toLocaleString()}.00

\n \n \n \n

\n );\n\n const renderView = () => {\n switch(view) {\n case 'login': return renderLogin();\n case 'signup': return renderSignup();\n case 'reset': return renderPasswordReset();\n case 'dashboard': return renderDashboard();\n case 'transfer': return renderTransferFunds();\n default: return renderLogin();\n }\n };\n\n return (\n

\n {renderView()}\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 = \"People_Bank_Corp\";\n\n // Enhanced users table with password reset token\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n balance REAL DEFAULT 450000.00,\n reset_token TEXT,\n reset_token_expires DATETIME,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Transactions table remains the same as previous implementation\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_transactions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL,\n recipient_bank TEXT NOT NULL,\n account_number TEXT NOT NULL,\n amount REAL NOT NULL,\n description TEXT,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle password reset requests\n if (request.method === 'POST' && request.url.includes('/reset-password')) {\n const body = await request.json();\n \n try {\n // Check if reset token is valid\n const resetCheck = await sqlite.execute(\n `SELECT * FROM ${KEY}_users \n WHERE email = ? AND reset_token = ? \n AND reset_token_expires > CURRENT_TIMESTAMP`, \n [body.email, body.resetToken]\n );\n\n if (resetCheck.rows.length === 0) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Invalid or expired reset token' \n }), { headers: { 'Content-Type': 'application/json' } });\n }\n\n // Update password and clear reset token\n await sqlite.execute(\n `UPDATE ${KEY}_users \n SET password = ?, \n reset_token = NULL, \n reset_token_expires = NULL \n WHERE email = ?`, \n [body.newPassword, body.email]\n );\n\n return new Response(JSON.stringify({ \n success: true, \n message: 'Password reset successful' \n }), { headers: { 'Content-Type': 'application/json' } });\n\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Password reset failed' \n }), { headers: { 'Content-Type': 'application/json' } });\n }\n }\n\n // Handle authentication requests\n if (request.method === 'POST') {\n const body = await request.json();\n \n try {\n switch(body.type) {\n case 'signup':\n await sqlite.execute(\n `INSERT INTO ${KEY}_users (email, password) VALUES (?, ?)`, \n [body.email, body.password]\n );\n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n \n case 'login':\n const user = await sqlite.execute(\n `SELECT * FROM ${KEY}_users WHERE email = ? AND password = ?`, \n [body.email, body.password]\n );\n \n if (user.rows.length > 0) {\n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n } else {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Invalid credentials' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'An error occurred' \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Existing transfer logic remains the same as previous implementation\n if (request.method === 'POST' && request.url.includes('/transfer')) {\n const body = await request.json();\n \n try {\n // Validate transfer\n const amount = parseFloat(body.amount);\n if (isNaN(amount) || amount <= 0) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Invalid transfer amount' \n }), { headers: { 'Content-Type': 'application/json' } });\n }\n\n // Check current balance\n const userCheck = await sqlite.execute(\n `SELECT balance FROM ${KEY}_users WHERE email = ?`, \n [body.email]\n );\n\n if (userCheck.rows[0].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 SET balance = balance - ? WHERE email = ?`, \n [amount, body.email]\n );\n\n // Record transaction\n await sqlite.execute(\n `INSERT INTO ${KEY}_transactions \n (email, recipient_bank, account_number, amount, description) \n VALUES (?, ?, ?, ?, ?)`, \n [\n body.email, \n body.recipientBank, \n body.accountNumber, \n amount, \n body.description\n ]\n );\n\n // Get updated balance\n const updatedUser = await sqlite.execute(\n `SELECT balance FROM ${KEY}_users WHERE email = ?`, \n [body.email]\n );\n\n return new Response(JSON.stringify({ \n success: true, \n newBalance: updatedUser.rows[0].balance \n }), { headers: { 'Content-Type': 'application/json' } });\n\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n message: 'Transfer processing error' \n }), { headers: { 'Content-Type': 'application/json' } });\n }\n }\n\n return new Response(`\n \n \n Peoples BANKCORP Online Banking\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\n// CSS remains the same as previous implementation\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n display: flex;\n justify-content: center;\n align-items: center;\n height: 100vh;\n margin: 0;\n background-color: #e6f2ff;\n}\n\n.banking-app {\n background: white;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n padding: 20px;\n width: 350px;\n border-top: 5px solid #0066cc;\n}\n\n.auth-container input,\n.transfer-container input,\n.transfer-container select {\n width: 100%;\n padding: 10px;\n margin: 10px 0;\n border: 1px solid #0066cc;\n border-radius: 4px;\n}\n\n.auth-container button,\n.transfer-container button {\n width: 100%;\n padding: 10px;\n background-color: #0066cc;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n transition: background-color 0.3s ease;\n margin: 5px 0;\n}\n\n.auth-container button:hover,\n.transfer-container button:hover {\n background-color: #004c99;\n}\n\n.error {\n color: red;\n text-align: center;\n}\n\n.dashboard {\n text-align: center;\n}\n\n.account-summary {\n background-color: #f0f7ff;\n padding: 20px;\n border-radius: 8px;\n border: 1px solid #0066cc;\n}\n\n.actions {\n display: flex;\n justify-content: space-between;\n margin-top: 15px;\n}\n\n.actions button {\n flex: 1;\n margin: 0 5px;\n padding: 10px;\n background-color: #0066cc;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n transition: background-color 0.3s ease;\n}\n\n.actions button:hover {\n background-color: #004c99;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/Smith4544/People_Bank_Corp/code/main.tsx","extension","actionData","errors"]