Support Case Login

\n \n \n \n \n \n Title\n Description\n Actions\n \n \n \n {cases.map((supportCase) => (\n \n {supportCase.title}\n {supportCase.description}\n \n \n \n \n \n ))}\n \n

\n \n\n \n

\n );\n}\n\nfunction client() {\n const root = document.getElementById('root');\n const path = window.location.pathname;\n\n createRoot(root).render(\n path === '/login' ? : \n );\n}\n\nif (typeof document !== 'undefined') client();\n\n// Server-side logic\nexport default async function server(request: Request): Promise {\n const { pathname } = new URL(request.url);\n \n // Initialize database\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE,\n password TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_support_cases (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT,\n description TEXT,\n user_id INTEGER,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Seed initial user if not exists\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${KEY}_users (email, password) \n VALUES ('admin@example.com', 'password123')\n `);\n\n // Authentication endpoint\n if (pathname === '/login' && request.method === 'POST') {\n const { email, password } = await request.json();\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_users WHERE email = ? AND password = ?`, \n [email, password]\n );\n\n if (result.rows.length > 0) {\n const token = generateToken(result.rows[0].id);\n return Response.json({ token });\n }\n return Response.json({ error: 'Invalid credentials' }, { status: 401 });\n }\n\n // Serve HTML for different routes\n if (pathname === '/login') {\n return new Response(`\n \n \n Support Case Login\n \n \n \n

\n \n \n \n `, { headers: { 'Content-Type': 'text/html' } });\n }\n\n if (pathname === '/cases') {\n return new Response(`\n \n \n Support Cases\n \n \n \n

\n \n \n \n `, { headers: { 'Content-Type': 'text/html' } });\n }\n\n // Fallback response\n return Response.json({ message: 'Welcome to Support Case Management' });\n}\n\n// Simulated backend functions (would typically be actual API calls)\nasync function fetchSupportCases(token) {\n const userId = verifyToken(token);\n if (!userId) throw new Error('Unauthorized');\n\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_support_cases WHERE user_id = ?\n `, [userId]);\n\n return result.rows;\n}\n\nasync function createSupportCase(token, caseData) {\n const userId = verifyToken(token);\n if (!userId) throw new Error('Unauthorized');\n\n await sqlite.execute(`\n INSERT INTO ${KEY}_support_cases (title, description, user_id) \n VALUES (?, ?, ?)\n `, [caseData.title, caseData.description, userId]);\n\n return { success: true };\n}\n\nasync function updateSupportCase(token, caseId, caseData) {\n const userId = verifyToken(token);\n if (!userId) throw new Error('Unauthorized');\n\n await sqlite.execute(`\n UPDATE ${KEY}_support_cases \n SET title = ?, description = ? \n WHERE id = ? AND user_id = ?\n `, [caseData.title, caseData.description, caseId, userId]);\n\n return { success: true };\n}\n\nasync function deleteCase(caseId) {\n await sqlite.execute(`\n DELETE FROM ${KEY}_support_cases WHERE id = ?\n `, [caseId]);\n\n return { success: true };\n}","deleted","label",[98],"permalink","https://www.val.town/x/beekay/Support_application/code/main.tsx","extension","actionData","errors"]