🛡️ Admin Dashboard

\n setAdminView(\"user-list\")}\n style={{\n marginRight: \"10px\",\n backgroundColor: adminView === \"user-list\" ? \"#007bff\" : \"#6c757d\",\n color: \"white\",\n border: \"none\",\n padding: \"10px\",\n borderRadius: \"4px\",\n }}\n >\n 👥 User List\n \n setAdminView(\"attendance-report\")}\n style={{\n backgroundColor: adminView === \"attendance-report\" ? \"#007bff\" : \"#6c757d\",\n color: \"white\",\n border: \"none\",\n padding: \"10px\",\n borderRadius: \"4px\",\n }}\n >\n 📋 Attendance Report\n \n

\n\n {adminView === \"user-list\" && (\n

User Registration List

\n \n \n \n \n \n \n \n \n \n \n {userRegistrationList.map((user, index) => (\n \n \n \n \n \n \n ))}\n \n

Full Name	Username	Registration Date	Action
{user.fullName}	{user.username}	{user.registrationDate}	\n \n

\n )}\n\n {adminView === \"attendance-report\" && (\n

Date-wise Attendance

\n {\n setSelectedDate(e.target.value);\n fetchDateWiseAttendance(e.target.value);\n }}\n style={{ marginBottom: \"15px\" }}\n />\n

\n Total Users: {dateWiseAttendance.length}\n

\n Present: {dateWiseAttendance.filter(entry => entry.status === \"Present\").length}\n | Absent: {dateWiseAttendance.filter(entry => entry.status === \"Absent\").length}\n

\n \n \n \n \n \n \n \n \n \n {dateWiseAttendance.map((entry, index) => (\n \n \n \n \n \n ))}\n \n

Name	Status	Time
{entry.fullName}	{entry.status}	{entry.time}

\n )}\n\n \n

\n );\n };\n\n return (\n

🚔 Police HQ Attendance System

\n\n {view === \"login\" && (\n

Login

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

setView(\"register\")}>\n New? Register here\n

\n \n )}\n\n {view === \"register\" && (\n

Register

\n setFullName(e.target.value)}\n required\n />\n setUsername(e.target.value)}\n required\n />\n setPassword(e.target.value)}\n required\n />\n \n

setView(\"login\")}>\n Already registered? Login\n

\n \n )}\n\n {view === \"attendance\" && currentUser && (\n

Welcome, {currentUser.fullName}

\n\n {monthlyStats && (\n \n

Monthly Attendance Summary

📅 Total Working Days: {monthlyStats.totalWorkingDays}

✅ Present Days: {monthlyStats.presentDays}

❌ Absent Days: {monthlyStats.absentDays}

📊 Attendance Percentage: {monthlyStats.attendancePercentage.toFixed(2)}%

\n )}\n\n

Mark Today's Attendance

\n \n \n

Daily Attendance List

\n \n \n \n \n \n \n \n \n \n \n {attendanceList.map((entry, index) => (\n \n \n \n \n \n \n ))}\n \n

Name	Status	Date	Time
{entry.fullName}	{entry.status}	{entry.date}	{entry.time}

\n \n

\n )}\n\n {view === \"admin-dashboard\" && renderAdminDashboard()}\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 = \"tenaciousCoffeeSpoonbill\";\n const SCHEMA_VERSION = 7;\n\n // Create Users Table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n fullName TEXT NOT NULL,\n username TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n registrationDate TEXT NOT NULL\n )\n `);\n\n // Create Attendance Table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_attendance_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n fullName TEXT NOT NULL,\n status TEXT NOT NULL,\n date TEXT NOT NULL,\n time TEXT NOT NULL,\n UNIQUE(username, date)\n )\n `);\n\n // Handle POST Requests\n if (request.method === \"POST\") {\n const body = await request.json();\n\n // User Registration\n if (request.url.includes(\"/register\")) {\n try {\n await sqlite.execute(\n `INSERT INTO ${KEY}_users_${SCHEMA_VERSION} \n (fullName, username, password, registrationDate) \n VALUES (?, ?, ?, ?)`,\n [body.fullName, body.username, body.password, body.registrationDate],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n return new Response(\n JSON.stringify({\n success: false,\n message: \"Username already exists\",\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n // User Login\n if (request.url.includes(\"/login\")) {\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_users_${SCHEMA_VERSION} \n WHERE username = ? AND password = ?`,\n [body.username, body.password],\n );\n\n if (result.rows.length > 0) {\n return new Response(\n JSON.stringify({\n success: true,\n user: result.rows[0],\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n } else {\n return new Response(\n JSON.stringify({\n success: false,\n message: \"Invalid credentials\",\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n // Mark Attendance\n if (request.url.includes(\"/mark-attendance\")) {\n try {\n const user = await sqlite.execute(\n `SELECT fullName FROM ${KEY}_users_${SCHEMA_VERSION} \n WHERE username = ?`,\n [body.username],\n );\n\n await sqlite.execute(\n `INSERT INTO ${KEY}_attendance_${SCHEMA_VERSION} \n (username, fullName, status, date, time) \n VALUES (?, ?, ?, ?, ?)`,\n [body.username, user.rows[0].fullName, body.status, body.date, body.time],\n );\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n return new Response(\n JSON.stringify({\n success: false,\n message: \"Attendance already marked for today\",\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n // Delete User\n if (request.url.includes(\"/delete-user\")) {\n await sqlite.execute(\n `DELETE FROM ${KEY}_users_${SCHEMA_VERSION} WHERE username = ?`,\n [body.username],\n );\n\n await sqlite.execute(\n `DELETE FROM ${KEY}_attendance_${SCHEMA_VERSION} WHERE username = ?`,\n [body.username],\n );\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n // Fetch User Registration List\n if (request.url.includes(\"/user-registration-list\")) {\n const result = await sqlite.execute(\n `SELECT fullName, username, registrationDate \n FROM ${KEY}_users_${SCHEMA_VERSION} \n WHERE username != 'admin' \n ORDER BY registrationDate DESC`,\n );\n\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Fetch Date-wise Attendance\n if (request.url.includes(\"/date-wise-attendance\")) {\n const url = new URL(request.url);\n const date = url.searchParams.get(\"date\");\n\n const result = await sqlite.execute(\n `SELECT fullName, status, time \n FROM ${KEY}_attendance_${SCHEMA_VERSION} \n WHERE date = ? \n ORDER BY time`,\n [date],\n );\n\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Fetch Monthly Stats\n if (request.url.includes(\"/monthly-stats\")) {\n const currentDate = new Date();\n const firstDayOfMonth = new Date(currentDate.getFullYear(), currentDate.getMonth(), 1);\n const lastDayOfMonth = new Date(currentDate.getFullYear(), currentDate.getMonth() + 1, 0);\n\n const formattedFirstDay = firstDayOfMonth.toISOString().split(\"T\")[0];\n const formattedLastDay = lastDayOfMonth.toISOString().split(\"T\")[0];\n\n const statsResult = await sqlite.execute(\n `\n SELECT \n COUNT(DISTINCT date) as totalWorkingDays,\n SUM(CASE WHEN status = 'Present' THEN 1 ELSE 0 END) as presentDays,\n SUM(CASE WHEN status = 'Absent' THEN 1 ELSE 0 END) as absentDays\n FROM ${KEY}_attendance_${SCHEMA_VERSION}\n WHERE date BETWEEN ? AND ?\n `,\n [formattedFirstDay, formattedLastDay],\n );\n\n const stats = statsResult.rows[0];\n const attendancePercentage = (stats.presentDays / stats.totalWorkingDays) * 100 || 0;\n\n return new Response(\n JSON.stringify({\n totalWorkingDays: stats.totalWorkingDays,\n presentDays: stats.presentDays,\n absentDays: stats.absentDays,\n attendancePercentage,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Fetch Attendance List\n if (request.url.includes(\"/attendance-list\")) {\n const result = await sqlite.execute(\n `SELECT DISTINCT fullName, status, date, time \n FROM ${KEY}_attendance_${SCHEMA_VERSION} \n WHERE date = ? \n ORDER BY time`,\n [new Date().toISOString().split(\"T\")[0]],\n );\n\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Serve HTML\n return new Response(\n `\n \n \n Police HQ Attendance\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\nbody { \n font-family: Arial, sans-serif; \n background-color: #f4f4f4; \n margin: 0; \n padding: 20px; \n}\nform {\n background: white;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\ninput {\n width: 100%;\n padding: 10px;\n margin: 10px 0;\n border: 1px solid #ddd;\n border-radius: 4px;\n}\nbutton {\n width: 100%;\n padding: 10px;\n background-color: #007bff;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n margin: 10px 0;\n}\ntable {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n}\nth, td {\n border: 1px solid #ddd;\n padding: 8px;\n text-align: left;\n}\n`;","deleted","subdomain",[102],"permalink","https://www.val.town/x/devansh_bansal/tenaciousCoffeeSpoonbill/code/main.tsx","extension","routes/embed","actionData","errors"]