\r\n \r\n \r\n

\r\n

${totalSubmissions}

\r\n

Total Quiz Submissions

\r\n

\r\n \r\n

\r\n ← Back to Quiz\r\n \r\n \r\n

\r\n \r\n ${submissions.length > 0 ? `\r\n

\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n ${submissions.map(row => {\r\n const id = row[0];\r\n const email = row[1];\r\n const primaryArchetype = row[2];\r\n const secondaryArchetype = row[3];\r\n const userSelectedArchetype = row[4];\r\n const completionTime = row[5];\r\n const timestamp = row[6];\r\n \r\n return `\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n `;\r\n }).join('')}\r\n \r\n

ID	Email	Quiz Result	User Selected	Completion Time	Date	Actions
${id}	${email}	${primaryArchetype}	${userSelectedArchetype ? `${userSelectedArchetype}` : 'Not selected'}	${completionTime ? Math.round(Number(completionTime) / 1000) + 's' : 'N/A'}	${timestamp ? new Date(String(timestamp)).toLocaleString() : 'N/A'}	\r\n \r\n

\r\n

\r\n ` : `\r\n

\r\n

No submissions found

\r\n

No quiz submissions in the database yet.

\r\n

\r\n `}\r\n

\r\n

\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n `;\r\n \r\n return c.html(html);\r\n \r\n } catch (error) {\r\n console.error(\"Admin dashboard error:\", error);\r\n return c.html(`\r\n \r\n \r\n Admin Dashboard - Error\r\n \r\n \r\n \r\n \r\n

⚠️ Admin Dashboard Error

\r\n

\r\n Error: ${error.message}\r\n

\r\n ← Back to Quiz\r\n \r\n \r\n `, 500);\r\n }\r\n});\r\n\r\n// API endpoint to get individual submission details\r\napp.get(\"/api/submission/:id\", async c => {\r\n try {\r\n const id = c.req.param('id');\r\n \r\n const result = await sqlite.execute({\r\n sql: `SELECT \r\n id, email, primary_archetype, secondary_archetype, user_selected_archetype,\r\n breakdown, answers, timestamp, completion_time, insights, user_agent, ip_hash,\r\n session_id, quiz_version, personality_complexity_score, response_consistency_score\r\n FROM ${TABLE_NAME} WHERE id = ?`,\r\n args: [parseInt(id)]\r\n });\r\n \r\n if (result.rows && result.rows.length > 0) {\r\n const row = result.rows[0];\r\n const submission = {\r\n id: row[0],\r\n email: row[1],\r\n primary_archetype: row[2],\r\n secondary_archetype: row[3],\r\n user_selected_archetype: row[4],\r\n breakdown: row[5],\r\n answers: row[6],\r\n timestamp: row[7],\r\n completion_time: row[8],\r\n insights: row[9],\r\n user_agent: row[10],\r\n ip_hash: row[11],\r\n session_id: row[12],\r\n quiz_version: row[13],\r\n personality_complexity_score: row[14],\r\n response_consistency_score: row[15]\r\n };\r\n \r\n return c.json({\r\n success: true,\r\n submission\r\n });\r\n } else {\r\n return c.json({\r\n success: false,\r\n error: 'Submission not found'\r\n }, 404, {\r\n 'Access-Control-Allow-Origin': '*',\r\n 'Access-Control-Allow-Methods': 'DELETE, GET, POST, PUT',\r\n 'Access-Control-Allow-Headers': 'Content-Type'\r\n });\r\n }\r\n } catch (error) {\r\n return c.json({\r\n success: false,\r\n error: error.message\r\n }, 500);\r\n }\r\n});\r\n\r\n// Test endpoint to insert sample data\r\napp.get(\"/api/test-data\", async c => {\r\n try {\r\n const testEmail = `test-${Date.now()}@example.com`;\r\n \r\n const result = await insertQuizSubmission({\r\n email: testEmail,\r\n primaryArchetype: \"The Visionary\",\r\n secondaryArchetype: \"The Nurturer\",\r\n breakdown: {\"The Visionary\": 75, \"The Nurturer\": 25},\r\n answers: [1,2,3,4,5],\r\n completionTime: 45000,\r\n insights: {},\r\n userAgent: \"test-browser\",\r\n ipHash: \"test-hash\",\r\n personalityComplexityScore: 0.85,\r\n responseConsistencyScore: 0.92\r\n });\r\n \r\n return c.json({\r\n success: true,\r\n message: \"Test data inserted successfully\",\r\n testEmail,\r\n result\r\n });\r\n } catch (error) {\r\n return c.json({\r\n success: false,\r\n error: error.message\r\n }, 500);\r\n }\r\n});\r\n\r\n// CORS preflight handler\r\napp.options(\"/api/submission/:id\", async c => {\r\n return c.text('', 200, {\r\n 'Access-Control-Allow-Origin': '*',\r\n 'Access-Control-Allow-Methods': 'DELETE, GET, POST, PUT',\r\n 'Access-Control-Allow-Headers': 'Content-Type'\r\n });\r\n});\r\n\r\n// API endpoint to delete a submission\r\napp.delete(\"/api/submission/:id\", async c => {\r\n try {\r\n const id = c.req.param('id');\r\n console.log('Delete API called with ID:', id);\r\n console.log('Table name:', TABLE_NAME);\r\n \r\n if (!id || isNaN(Number(id))) {\r\n console.log('Invalid ID provided:', id);\r\n return c.json({\r\n success: false,\r\n error: 'Invalid submission ID'\r\n }, 400, {\r\n 'Access-Control-Allow-Origin': '*',\r\n 'Access-Control-Allow-Methods': 'DELETE, GET, POST, PUT',\r\n 'Access-Control-Allow-Headers': 'Content-Type'\r\n });\r\n }\r\n \r\n // First check if the submission exists\r\n const checkResult = await sqlite.execute({\r\n sql: `SELECT id FROM ${TABLE_NAME} WHERE id = ?`,\r\n args: [Number(id)]\r\n });\r\n \r\n console.log('Check result:', checkResult);\r\n \r\n if (!checkResult.rows || checkResult.rows.length === 0) {\r\n console.log('Submission not found with ID:', id);\r\n return c.json({\r\n success: false,\r\n error: 'Submission not found'\r\n }, 404);\r\n }\r\n \r\n // Delete the submission\r\n const deleteResult = await sqlite.execute({\r\n sql: `DELETE FROM ${TABLE_NAME} WHERE id = ?`,\r\n args: [Number(id)]\r\n });\r\n \r\n console.log('Delete result:', deleteResult);\r\n \r\n return c.json({\r\n success: true,\r\n message: 'Submission deleted successfully'\r\n }, 200, {\r\n 'Access-Control-Allow-Origin': '*',\r\n 'Access-Control-Allow-Methods': 'DELETE, GET, POST, PUT',\r\n 'Access-Control-Allow-Headers': 'Content-Type'\r\n });\r\n \r\n } catch (error) {\r\n console.error('Delete error:', error);\r\n return c.json({\r\n success: false,\r\n error: error.message\r\n }, 500, {\r\n 'Access-Control-Allow-Origin': '*',\r\n 'Access-Control-Allow-Methods': 'DELETE, GET, POST, PUT',\r\n 'Access-Control-Allow-Headers': 'Content-Type'\r\n });\r\n }\r\n});\r\n\r\nexport default app.fetch; ","deleted","label",[98],"permalink","https://www.val.town/x/all/ssscQuiz/code/admin.http.ts","extension","actionData","errors"]

🎯 Admin Dashboard

No submissions found

Quiz Submission Details

⚠️ Admin Dashboard Error