🛡️ 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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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`;","createdAt",["D",1736693931561],"version",34,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","devansh_bansal","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJyUW5ram53WG84MDZqS2JHUER2Rm9ZRlhMMiJ9","forkedVal","interval","slug","devansh_bansal/tenaciousCoffeeSpoonbill","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[142,145,149,153,157,161,165,169,173,177,181,185,189,193,197,201,205,209,213,217,221,225,229,233,237,241,245,249,253,257,261,265,269,272,275],{"_118":119,"_143":-5,"_116":144,"_113":111},"prId",["D",1736693931561],{"_118":146,"_143":-5,"_116":147,"_113":148},33,["D",1736533325304],"cb770338-cf7f-11ef-ae1e-e6cdfca9ef9f",{"_118":150,"_143":-5,"_116":151,"_113":152},32,["D",1736533116649],"4f1a0858-cf7f-11ef-8c2d-e6cdfca9ef9f",{"_118":154,"_143":-5,"_116":155,"_113":156},31,["D",1736532768691],"7fb2d7f2-cf7e-11ef-9dbf-e6cdfca9ef9f",{"_118":158,"_143":-5,"_116":159,"_113":160},30,["D",1736532753876],"76de7c30-cf7e-11ef-a771-e6cdfca9ef9f",{"_118":162,"_143":-5,"_116":163,"_113":164},29,["D",1736532739933],"6e8e6cfc-cf7e-11ef-a55b-e6cdfca9ef9f",{"_118":166,"_143":-5,"_116":167,"_113":168},28,["D",1736532726536],"66924870-cf7e-11ef-a771-e6cdfca9ef9f",{"_118":170,"_143":-5,"_116":171,"_113":172},27,["D",1736532686152],"4e824b9a-cf7e-11ef-975e-e6cdfca9ef9f",{"_118":174,"_143":-5,"_116":175,"_113":176},26,["D",1736532584031],"11a4bf32-cf7e-11ef-9c13-e6cdfca9ef9f",{"_118":178,"_143":-5,"_116":179,"_113":180},25,["D",1736532461729],"c8bbe5c0-cf7d-11ef-8b80-e6cdfca9ef9f",{"_118":182,"_143":-5,"_116":183,"_113":184},24,["D",1736532359778],"8bf89b7e-cf7d-11ef-894f-e6cdfca9ef9f",{"_118":186,"_143":-5,"_116":187,"_113":188},23,["D",1736532312309],"6fad11a2-cf7d-11ef-a01f-e6cdfca9ef9f",{"_118":190,"_143":-5,"_116":191,"_113":192},22,["D",1736532236559],"428aab6c-cf7d-11ef-b547-e6cdfca9ef9f",{"_118":194,"_143":-5,"_116":195,"_113":196},21,["D",1736532199296],"2c4ff532-cf7d-11ef-9e62-e6cdfca9ef9f",{"_118":198,"_143":-5,"_116":199,"_113":200},20,["D",1736532139019],"0863270c-cf7d-11ef-9b01-e6cdfca9ef9f",{"_118":202,"_143":-5,"_116":203,"_113":204},19,["D",1736532069235],"dee5bb42-cf7c-11ef-a01f-e6cdfca9ef9f",{"_118":206,"_143":-5,"_116":207,"_113":208},18,["D",1736532037025],"cb9ab7ea-cf7c-11ef-91bb-e6cdfca9ef9f",{"_118":210,"_143":-5,"_116":211,"_113":212},17,["D",1736531988804],"aed9824e-cf7c-11ef-83a4-e6cdfca9ef9f",{"_118":214,"_143":-5,"_116":215,"_113":216},16,["D",1736531914564],"829c79c0-cf7c-11ef-9fd4-e6cdfca9ef9f",{"_118":218,"_143":-5,"_116":219,"_113":220},15,["D",1736531629002],"d8642476-cf7b-11ef-9c38-e6cdfca9ef9f",{"_118":222,"_143":-5,"_116":223,"_113":224},14,["D",1736531595313],"c4505932-cf7b-11ef-a6ad-e6cdfca9ef9f",{"_118":226,"_143":-5,"_116":227,"_113":228},13,["D",1736531540668],"a3be4eb8-cf7b-11ef-9fd4-e6cdfca9ef9f",{"_118":230,"_143":-5,"_116":231,"_113":232},12,["D",1736531496241],"8942445e-cf7b-11ef-a97d-e6cdfca9ef9f",{"_118":234,"_143":-5,"_116":235,"_113":236},11,["D",1736531424595],"5e8e1f3a-cf7b-11ef-8f9a-e6cdfca9ef9f",{"_118":238,"_143":-5,"_116":239,"_113":240},10,["D",1736531250469],"f6c54e5a-cf7a-11ef-a95f-e6cdfca9ef9f",{"_118":242,"_143":-5,"_116":243,"_113":244},9,["D",1736531122777],"aaa821be-cf7a-11ef-beb8-e6cdfca9ef9f",{"_118":246,"_143":-5,"_116":247,"_113":248},8,["D",1736530958100],"48826508-cf7a-11ef-add8-e6cdfca9ef9f",{"_118":250,"_143":-5,"_116":251,"_113":252},7,["D",1736530752166],"cdcc81a4-cf79-11ef-9043-e6cdfca9ef9f",{"_118":254,"_143":-5,"_116":255,"_113":256},6,["D",1736530554566],"57fb0b44-cf79-11ef-b955-e6cdfca9ef9f",{"_118":258,"_143":-5,"_116":259,"_113":260},5,["D",1736530349948],"de04e29c-cf78-11ef-8ba4-e6cdfca9ef9f",{"_118":262,"_143":-5,"_116":263,"_113":264},4,["D",1736530117809],"53a6d042-cf78-11ef-8603-e6cdfca9ef9f",{"_118":266,"_143":-5,"_116":267,"_113":268},3,["D",1736530019977],"195e2e08-cf78-11ef-802f-e6cdfca9ef9f",{"_118":91,"_143":-5,"_116":270,"_113":271},["D",1736503873319],"38b6d85a-cf3b-11ef-bcac-e6cdfca9ef9f",{"_118":125,"_143":-5,"_116":273,"_113":274},["D",1736503361062],"07633786-cf3a-11ef-a3c4-e6cdfca9ef9f",{"_118":32,"_143":-5,"_116":276,"_113":277},["D",1736503153322],"8b91d7f2-cf39-11ef-8f89-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_94":285,"_286":287,"_95":288},"single","redirect","/v/devansh_bansal/tenaciousCoffeeSpoonbill/versions",{"_113":160,"_114":289,"_118":158,"_116":290,"_291":100,"_101":102,"_108":109,"_130":131,"_11":97,"_292":-5,"_293":-5,"_294":-5,"_282":26,"_136":137},"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction App() {\n const [view, setView] = useState('login');\n const [username, setUsername] = useState('');\n const [password, setPassword] = useState('');\n const [fullName, setFullName] = useState('');\n const [attendanceList, setAttendanceList] = useState([]);\n const [monthlyStats, setMonthlyStats] = useState(null);\n const [currentUser, setCurrentUser] = useState(null);\n const [userRegistrationList, setUserRegistrationList] = useState([]);\n const [dateWiseAttendance, setDateWiseAttendance] = useState([]);\n const [selectedDate, setSelectedDate] = useState(new Date().toISOString().split('T')[0]);\n const [adminView, setAdminView] = useState('user-list');\n\n const handleRegistration = async (e) => {\n e.preventDefault();\n try {\n const response = await fetch('/register', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n fullName, \n username, \n password,\n registrationDate: new Date().toISOString().split('T')[0]\n })\n });\n const result = await response.json();\n if (result.success) {\n alert('Registration successful! Please login.');\n setView('login');\n } else {\n alert(result.message);\n }\n } catch (error) {\n alert('Registration failed. Please try again.');\n }\n };\n\n const handleLogin = async (e) => {\n e.preventDefault();\n \n // Special handling for admin login\n if (username === 'admin' && password === 'admin') {\n setCurrentUser({ username: 'admin', fullName: 'Admin' });\n setView('admin-dashboard');\n await fetchUserRegistrationList();\n await fetchDateWiseAttendance(selectedDate);\n return;\n }\n\n try {\n const response = await fetch('/login', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ username, password })\n });\n const result = await response.json();\n if (result.success) {\n setCurrentUser(result.user);\n setView('attendance');\n await fetchAttendanceList();\n await fetchMonthlyStats();\n } else {\n alert(result.message);\n }\n } catch (error) {\n alert('Login failed. Please try again.');\n }\n };\n\n const markAttendance = async (status) => {\n try {\n const response = await fetch('/mark-attendance', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ \n username: currentUser.username, \n status, \n date: new Date().toISOString().split('T')[0],\n time: new Date().toLocaleTimeString() \n })\n });\n const result = await response.json();\n if (result.success) {\n await fetchAttendanceList();\n await fetchMonthlyStats();\n alert(`Attendance marked as ${status}`);\n } else {\n alert(result.message);\n }\n } catch (error) {\n alert('Failed to mark attendance. Please try again.');\n }\n };\n\n const fetchAttendanceList = async () => {\n try {\n const response = await fetch('/attendance-list');\n const list = await response.json();\n setAttendanceList(list);\n } catch (error) {\n console.error('Failed to fetch attendance list');\n }\n };\n\n const fetchMonthlyStats = async () => {\n try {\n const response = await fetch('/monthly-stats');\n const stats = await response.json();\n setMonthlyStats(stats);\n } catch (error) {\n console.error('Failed to fetch monthly stats');\n }\n };\n\n const fetchUserRegistrationList = async () => {\n try {\n const response = await fetch('/user-registration-list');\n const list = await response.json();\n setUserRegistrationList(list);\n } catch (error) {\n console.error('Failed to fetch user registration list');\n }\n };\n\n const fetchDateWiseAttendance = async (date) => {\n try {\n const response = await fetch(`/date-wise-attendance?date=${date}`);\n const list = await response.json();\n setDateWiseAttendance(list);\n } catch (error) {\n console.error('Failed to fetch date-wise attendance');\n }\n };\n\n const deleteUser = async (username) => {\n try {\n const response = await fetch('/delete-user', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ username })\n });\n const result = await response.json();\n if (result.success) {\n await fetchUserRegistrationList();\n alert('User deleted successfully');\n } else {\n alert(result.message);\n }\n } catch (error) {\n alert('Failed to delete user. Please try again.');\n }\n };\n\n const handleLogout = () => {\n setCurrentUser(null);\n setView('login');\n };\n\n const renderAdminDashboard = () => {\n return (\n

🛡️ Admin Dashboard

\n \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 \n )}\n\n {view === 'register' && (\n \n )}\n\n {view === 'attendance' && currentUser && (\n

Welcome, {currentUser.fullName}

\n \n {monthlyStats && (\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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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(JSON.stringify({ \n success: false, \n message: 'Username already exists' \n }), { \n headers: { 'Content-Type': 'application/json' } \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(JSON.stringify({ \n success: true, \n user: result.rows[0] \n }), { \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\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(JSON.stringify({ \n success: false, \n message: 'Attendance already marked for today' \n }), { \n headers: { 'Content-Type': 'application/json' } \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 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 `, [formattedFirstDay, formattedLastDay]);\n\n const stats = statsResult.rows[0];\n const attendancePercentage = (stats.presentDays / stats.totalWorkingDays) * 100 || 0;\n\n return new Response(JSON.stringify({\n totalWorkingDays: stats.totalWorkingDays,\n presentDays: stats.presentDays,\n absentDays: stats.absentDays,\n attendancePercentage\n }), { \n headers: { 'Content-Type': 'application/json' } \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 Police HQ Attendance\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\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`;",["D",1736532753876],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

tenaciousCoffeeSpoonbill

Version 30