Attendance System

\n\n {/* Error Message Display */}\n {errorMessage && (\n

\n {errorMessage}\n

\n )}\n\n {/* Camera Section */}\n

\n\n {/* Form Section */}\n

\n \n\n \n\n {\n setName(e.target.value);\n saveToLocalStorage();\n }}\n className=\"w-full border p-2 rounded\"\n />\n\n

\n \n

\n\n {/* Admin Dashboard Link */}\n

\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n // Import SQLite dynamically\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"Attendence\";\n\n // Ensure attendance table exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_attendance (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n company TEXT NOT NULL,\n amt_type TEXT NOT NULL,\n photo_data TEXT NOT NULL,\n latitude REAL NOT NULL,\n longitude REAL NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Server-side route handling\n if (request.method === 'POST' && new URL(request.url).pathname === '/submit-attendance') {\n try {\n const attendanceData = await request.json();\n \n // Insert attendance record\n await sqlite.execute(`\n INSERT INTO ${KEY}_attendance \n (name, company, amt_type, photo_data, latitude, longitude) \n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n attendanceData.name,\n attendanceData.company,\n attendanceData.amtType,\n attendanceData.photoData,\n attendanceData.location.latitude,\n attendanceData.location.longitude\n ]);\n \n return new Response(JSON.stringify({ \n success: true, \n message: 'Attendance recorded successfully' \n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n return new Response(JSON.stringify({ \n success: false, \n error: 'Invalid data submission' \n }), {\n status: 400,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n // Admin dashboard route with advanced features\n if (new URL(request.url).pathname === '/admin-dashboard') {\n // Get query parameters for filtering\n const url = new URL(request.url);\n const selectedDate = url.searchParams.get('date') || new Date().toISOString().split('T')[0];\n\n // Fetch attendance records for the selected date\n const attendanceRecords = await sqlite.execute(`\n SELECT * FROM ${KEY}_attendance \n WHERE date(timestamp) = ?\n ORDER BY timestamp DESC\n `, [selectedDate]);\n\n // Calculate attendance summary\n const companySummary = await sqlite.execute(`\n SELECT company, COUNT(*) as total_attendance \n FROM ${KEY}_attendance \n WHERE date(timestamp) = ?\n GROUP BY company\n `, [selectedDate]);\n\n // Generate HTML for admin dashboard\n const dashboardHtml = `\n \n \n Admin Dashboard\n \n \n \n \n

Attendance Management System

\n \n \n\n

Attendance Summary (${selectedDate})

\n ${companySummary.rows.map(summary => `\n

\n ${summary.company}: ${summary.total_attendance} Attendees\n

\n `).join('')}\n

\n Total Attendance: ${attendanceRecords.rows.length}\n

\n\n

Detailed Attendance Records

\n \n \n \n \n \n \n \n \n \n \n \n ${attendanceRecords.rows.map(record => `\n \n \n \n \n \n \n \n `).join('')}\n \n

Name	Company	AMT Type	Time	Photo
${record.name}	${record.company}	${record.amt_type}	${new Date(record.timestamp).toLocaleTimeString()}	\n \n

\n\n

\n Back to Attendance\n

\n \n \n `;\n\n return new Response(dashboardHtml, {\n headers: { 'Content-Type': 'text/html' }\n });\n }\n\n // Serve main HTML\n return new Response(`\n \n \n Attendance System\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/nirwan/Attendence/code/main.tsx","extension","actionData","errors"]