[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_213":214,"_215":216},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":88,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":26,"_121":122,"_123":24,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":26,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":24,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":26},"version",34,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_23":26},"previous","deleted",true,"deletedHere",false,"path","backend/index_new.ts","latestPath","fileId","9f1fb4c8-bfc1-11f0-a8c4-42dde27851f2","name","index_new.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Database setup\nconst TIMESLOTS_TABLE = 'project_timeslots';\nconst PROJECTS_TABLE = 'project_options';\nconst RESPONSES_TABLE = 'student_responses';\n\n// Initialize database tables\nasync function initDatabase() {\n // Create timeslots table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TIMESLOTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n time_description TEXT NOT NULL,\n order_index INTEGER NOT NULL,\n active BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create projects table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${PROJECTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timeslot_id INTEGER,\n project_name TEXT NOT NULL,\n project_description TEXT,\n max_participants INTEGER DEFAULT NULL,\n active BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (timeslot_id) REFERENCES ${TIMESLOTS_TABLE} (id)\n )`);\n\n // Create responses table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${RESPONSES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_name TEXT NOT NULL,\n timeslot_id INTEGER,\n first_choice TEXT,\n second_choice TEXT,\n third_choice TEXT,\n submitted_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (timeslot_id) REFERENCES ${TIMESLOTS_TABLE} (id)\n )`);\n\n // Insert default data if tables are empty\n const { rows: timeslotCount } = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TIMESLOTS_TABLE}`);\n if (timeslotCount[0].count === 0) {\n await insertDefaultData();\n }\n}\n\nasync function insertDefaultData() {\n // Insert default timeslots\n const timeslots = [\n { title: \"1. Dienstag 9:00-10:30 Uhr\", time_description: \"Dienstag 9:00-10:30 Uhr\", order_index: 1 },\n { title: \"2. Dienstag 10:45-12:15 Uhr\", time_description: \"Dienstag 10:45-12:15 Uhr\", order_index: 2 },\n { title: \"3. Dienstag 12:45-13:30 Uhr\", time_description: \"Dienstag 12:45-13:30 Uhr\", order_index: 3 }\n ];\n\n for (const timeslot of timeslots) {\n await sqlite.execute(\n `INSERT INTO ${TIMESLOTS_TABLE} (title, time_description, order_index) VALUES (?, ?, ?)`,\n [timeslot.title, timeslot.time_description, timeslot.order_index]\n );\n \n // Get the timeslot ID by querying back\n const { rows: insertedTimeslot } = await sqlite.execute(\n `SELECT id FROM ${TIMESLOTS_TABLE} WHERE title = ? AND order_index = ?`,\n [timeslot.title, timeslot.order_index]\n );\n \n const timeslotId = insertedTimeslot[0].id;\n console.log(`Inserted timeslot with ID: ${timeslotId}`);\n \n // Insert default projects for each timeslot\n const projects = ['Projekt A', 'Projekt B', 'Projekt C', 'Projekt D', 'Projekt E', 'Projekt F', 'Projekt G', 'Projekt H'];\n \n for (const projectName of projects) {\n await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name) VALUES (?, ?)`,\n [timeslotId, projectName]\n );\n console.log(`Inserted project ${projectName} for timeslot ${timeslotId}`);\n }\n }\n}\n\n// API Routes\napp.get('/api/debug/reset', async (c) => {\n // Drop and recreate tables\n await sqlite.execute(`DROP TABLE IF EXISTS ${RESPONSES_TABLE}`);\n await sqlite.execute(`DROP TABLE IF EXISTS ${PROJECTS_TABLE}`);\n await sqlite.execute(`DROP TABLE IF EXISTS ${TIMESLOTS_TABLE}`);\n \n await initDatabase();\n return c.json({ message: 'Database reset complete' });\n});\n\napp.get('/api/debug/data', async (c) => {\n const { rows: timeslots } = await sqlite.execute(`SELECT * FROM ${TIMESLOTS_TABLE}`);\n const { rows: projects } = await sqlite.execute(`SELECT * FROM ${PROJECTS_TABLE}`);\n const { rows: responses } = await sqlite.execute(`SELECT * FROM ${RESPONSES_TABLE}`);\n \n return c.json({ timeslots, projects, responses });\n});\n\napp.get('/api/timeslots', async (c) => {\n const { rows: timeslots } = await sqlite.execute(\n `SELECT * FROM ${TIMESLOTS_TABLE} WHERE active = 1 ORDER BY order_index`\n );\n\n const timelotData = [];\n \n for (const timeslot of timeslots) {\n const { rows: projects } = await sqlite.execute(\n `SELECT * FROM ${PROJECTS_TABLE} WHERE timeslot_id = ? AND active = 1`,\n [timeslot.id]\n );\n \n timelotData.push({\n id: timeslot.id,\n title: timeslot.title,\n timeDescription: timeslot.time_description,\n orderIndex: timeslot.order_index,\n projects: projects.map(p => ({\n id: p.id,\n name: p.project_name,\n description: p.project_description,\n maxParticipants: p.max_participants\n }))\n });\n }\n\n return c.json(timelotData);\n});\n\napp.post('/api/responses', async (c) => {\n const data = await c.req.json();\n \n // Validate required fields\n if (!data.name || !data.responses || !Array.isArray(data.responses)) {\n return c.json({ error: 'Invalid data format' }, 400);\n }\n\n try {\n // Insert each response\n for (const response of data.responses) {\n if (response.rankings && response.rankings.length >= 3) {\n // Find timeslot ID by title\n const { rows: timeslots } = await sqlite.execute(\n `SELECT id FROM ${TIMESLOTS_TABLE} WHERE title = ?`,\n [response.question]\n );\n \n if (timeslots.length > 0) {\n await sqlite.execute(\n `INSERT INTO ${RESPONSES_TABLE} (student_name, timeslot_id, first_choice, second_choice, third_choice) \n VALUES (?, ?, ?, ?, ?)`,\n [\n data.name,\n timeslots[0].id,\n response.rankings[0] || null,\n response.rankings[1] || null,\n response.rankings[2] || null\n ]\n );\n }\n }\n }\n\n return c.json({ success: true, message: 'Responses saved successfully' });\n } catch (error) {\n console.error('Error saving responses:', error);\n return c.json({ error: 'Failed to save responses' }, 500);\n }\n});\n\n// Copy project API endpoint\napp.post('/api/admin/projects/:id/copy', async (c) => {\n const sourceId = c.req.param('id');\n const data = await c.req.json();\n \n try {\n // Get the source project\n const { rows: sourceProjects } = await sqlite.execute(\n `SELECT * FROM ${PROJECTS_TABLE} WHERE id = ?`,\n [sourceId]\n );\n \n if (sourceProjects.length === 0) {\n return c.json({ error: 'Source project not found' }, 404);\n }\n \n const sourceProject = sourceProjects[0];\n \n // Insert the copied project\n await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name, project_description, max_participants) VALUES (?, ?, ?, ?)`,\n [data.target_timeslot_id, sourceProject.project_name, sourceProject.project_description, sourceProject.max_participants]\n );\n \n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\n// Admin routes for managing timeslots and projects\napp.get('/admin', async (c) => {\n const adminHtml = `\n \n \n \n Admin - Projektauswahl\n \n \n \n

Admin Panel - Projektauswahl

\n \n

Timeslots

Add New Timeslot

\n \n \n \n \n

\n\n

Projects

Add New Project

\n \n \n \n \n \n

\n\n

Student Responses

\n \n

\n\n \n \n\n \n \n \n `;\n \n return c.html(adminHtml);\n});\n\n// Admin API routes\napp.post('/api/admin/timeslots', async (c) => {\n const data = await c.req.json();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${TIMESLOTS_TABLE} (title, time_description, order_index) VALUES (?, ?, ?)`,\n [data.title, data.time_description, data.order_index]\n );\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.post('/api/admin/projects', async (c) => {\n const data = await c.req.json();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name, project_description, max_participants) VALUES (?, ?, ?, ?)`,\n [data.timeslot_id, data.project_name, data.project_description, data.max_participants]\n );\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.put('/api/admin/timeslots/:id', async (c) => {\n const id = c.req.param('id');\n const data = await c.req.json();\n \n try {\n if (data.updateAll) {\n // Update all fields\n await sqlite.execute(\n `UPDATE ${TIMESLOTS_TABLE} SET title = ?, time_description = ?, order_index = ? WHERE id = ?`,\n [data.title, data.time_description, data.order_index, id]\n );\n } else {\n // Update only active status (existing functionality)\n await sqlite.execute(\n `UPDATE ${TIMESLOTS_TABLE} SET active = ? WHERE id = ?`,\n [data.active ? 1 : 0, id]\n );\n }\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.put('/api/admin/projects/:id', async (c) => {\n const id = c.req.param('id');\n const data = await c.req.json();\n \n try {\n if (data.updateAll) {\n // Update all fields\n await sqlite.execute(\n `UPDATE ${PROJECTS_TABLE} SET timeslot_id = ?, project_name = ?, project_description = ?, max_participants = ? WHERE id = ?`,\n [data.timeslot_id, data.project_name, data.project_description, data.max_participants, id]\n );\n } else {\n // Update only active status (existing functionality)\n await sqlite.execute(\n `UPDATE ${PROJECTS_TABLE} SET active = ? WHERE id = ?`,\n [data.active ? 1 : 0, id]\n );\n }\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.delete('/api/admin/timeslots/:id', async (c) => {\n const id = c.req.param('id');\n \n try {\n // Delete associated responses and projects first\n await sqlite.execute(`DELETE FROM ${RESPONSES_TABLE} WHERE timeslot_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM ${PROJECTS_TABLE} WHERE timeslot_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM ${TIMESLOTS_TABLE} WHERE id = ?`, [id]);\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.delete('/api/admin/projects/:id', async (c) => {\n const id = c.req.param('id');\n \n try {\n await sqlite.execute(`DELETE FROM ${PROJECTS_TABLE} WHERE id = ?`, [id]);\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.get('/api/admin/export-csv', async (c) => {\n try {\n const { rows: responses } = await sqlite.execute(`\n SELECT r.*, t.title as timeslot_title \n FROM ${RESPONSES_TABLE} r \n LEFT JOIN ${TIMESLOTS_TABLE} t ON r.timeslot_id = t.id \n ORDER BY r.submitted_at DESC\n `);\n \n let csv = 'Student Name,Timeslot,First Choice,Second Choice,Third Choice,Submitted At\\\\n';\n \n responses.forEach(r => {\n csv += `\"${r.student_name}\",\"${r.timeslot_title || ''}\",\"${r.first_choice || ''}\",\"${r.second_choice || ''}\",\"${r.third_choice || ''}\",\"${r.submitted_at}\"\\\\n`;\n });\n \n return new Response(csv, {\n headers: {\n 'Content-Type': 'text/csv',\n 'Content-Disposition': 'attachment; filename=\"project_responses.csv\"'\n }\n });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\n// Serve the main HTML file\napp.get('/', async (c) => {\n let html = await readFile(\"/schueler.html\", import.meta.url);\n \n // Inject the API endpoint for dynamic loading\n const scriptInjection = `\n \n `;\n \n html = html.replace('', `${scriptInjection}`);\n return c.html(html);\n});\n\n// Initialize database on startup\nawait initDatabase();\n\nexport default app.fetch;","createdAt",["D",1762949876767],"branchVersion","branchId","59cc29d8-bfbc-11f0-aada-42dde27851f2","id","59cbb624-bfbc-11f0-aada-42dde27851f2","Projektwoche",["D",1762947612971],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","2c69940e-198d-46d6-824e-0d8c150b63e9","pinnedFileId","e6d56768-bfc1-11f0-974b-42dde27851f2","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","917c516d-7013-4878-8604-9bac537fcbe3","tursoName","59cbb624bfbc11f0aada42dde27851f2","tursoHostname","59cbb624bfbc11f0aada42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789529498250],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":26},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",210,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","chriseidhof","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yckc5VFZOUXljZTRkWjJ6T2lPUVRseEtYa3YifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":208,"_47":-5,"_48":26,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":24,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":209,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":210,"_82":211,"_84":212,"_86":26},"tree",[175,178,179,180],"files",[175,176,177,178,179,180],"counts",{"_164":61,"_165":146,"_166":167,"_168":169,"_170":171},"contents",[128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":157,"_32":158,"_30":159,"_135":-5,"_41":42,"_40":160,"_137":24,"_38":161,"_13":61,"_34":162,"_36":-5,"_23":26,"_141":-5,"_27":163},{"_43":149,"_32":150,"_30":151,"_135":-5,"_41":42,"_40":152,"_137":26,"_38":153,"_13":154,"_34":20,"_36":155,"_23":26,"_141":-5,"_27":156},{"_43":143,"_32":144,"_30":145,"_135":-5,"_41":42,"_40":146,"_137":24,"_38":147,"_13":61,"_34":35,"_36":107,"_23":26,"_141":-5,"_27":148},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":26,"_38":138,"_13":139,"_34":20,"_36":140,"_23":26,"_141":-5,"_27":142},"41ccc4aa-bfc1-11f0-888b-42dde27851f2","schueler.html","b8f786c2-bfbd-11f0-8d12-42dde27851f2","parentId",32,"latest",["D",1762949720193],16,"\n\n \n \n \n Projektauswahl\n \n \n \n

Projektauswahl

Wähle deine Top 3 Favoriten für jede Zeitspanne

\n\n \n

\n\n \n \n","label",[133],"59cdf628-bfbc-11f0-aada-42dde27851f2","main.ts","59cdf6d2-bfbc-11f0-aada-42dde27851f2",1,["D",1762947612985],[144],"1ffecdce-bfc0-11f0-972b-42dde27851f2","README.md","8af0b694-bfbe-11f0-a116-42dde27851f2",20,["D",1762949233946],2,"# Projektauswahl System\n\nA dynamic project selection system where students can rank their preferences for different time slots with a comprehensive admin interface for management.\n\n## Features\n\n- **Dynamic Data Management**: Timeslots and projects are stored in SQLite database\n- **Student Interface**: Drag-and-drop interface for ranking project preferences\n- **Advanced Admin Panel**: Web-based interface with inline editing capabilities\n- **Data Export**: CSV export of student responses\n- **Responsive Design**: Works on desktop and mobile devices\n\n## Structure\n\n```\n├── backend/\n│ └── index.ts # Main backend with API routes and admin panel\n├── schueler.html # Student-facing form (dynamically loads data)\n└── README.md # This file\n```\n\n## Usage\n\n### Student Interface\n- Visit the main page to fill out project preferences\n- Enter your name and drag projects to rank them for each timeslot\n- Submit to save responses to database\n\n### Admin Interface\n- Visit `/admin` to manage the system\n- **Inline Editing**: Click \"Edit\" on any timeslot or project to modify it directly in the table\n - Edit timeslot titles, descriptions, and order\n - Edit project names, descriptions, and reassign to different timeslots\n - Visual feedback with highlighted rows during editing\n - Save/Cancel options for each edit operation\n- **Bulk Operations**: Add new timeslots and projects using the forms\n- **Status Management**: Activate/deactivate timeslots and projects\n- **Data Management**: View all student responses and export as CSV\n- **Safe Deletion**: Delete items with confirmation dialogs\n\n## API Endpoints\n\n### Public Endpoints\n- `GET /` - Student form\n- `GET /api/timeslots` - Get all active timeslots with projects\n- `POST /api/responses` - Submit student responses\n\n### Admin Endpoints\n- `GET /admin` - Admin panel interface with inline editing\n- `GET /api/debug/data` - View all database data\n- `GET /api/debug/reset` - Reset database (development only)\n- `POST /api/admin/timeslots` - Add new timeslot\n- `POST /api/admin/projects` - Add new project\n- `PUT /api/admin/timeslots/:id` - Update timeslot (supports full updates and status toggle)\n- `PUT /api/admin/projects/:id` - Update project (supports full updates and status toggle)\n- `DELETE /api/admin/timeslots/:id` - Delete timeslot (cascades to projects and responses)\n- `DELETE /api/admin/projects/:id` - Delete project\n- `GET /api/admin/export-csv` - Export responses as CSV\n\n## Database Schema\n\n### Timeslots Table\n- `id` - Primary key\n- `title` - Display title (e.g., \"1. Dienstag 9:00-10:30 Uhr\")\n- `time_description` - Time description\n- `order_index` - Display order\n- `active` - Whether timeslot is active\n- `created_at` - Creation timestamp\n\n### Projects Table\n- `id` - Primary key\n- `timeslot_id` - Foreign key to timeslots\n- `project_name` - Project name\n- `project_description` - Optional description\n- `active` - Whether project is active\n- `created_at` - Creation timestamp\n\n### Responses Table\n- `id` - Primary key\n- `student_name` - Student's name\n- `timeslot_id` - Foreign key to timeslots\n- `first_choice` - First preference\n- `second_choice` - Second preference\n- `third_choice` - Third preference\n- `submitted_at` - Submission timestamp\n\n## Admin Panel Features\n\n### Inline Editing\n- **Timeslots**: Edit title, description, and order index directly in the table\n- **Projects**: Edit name, description, and reassign to different timeslots\n- **Visual Feedback**: Rows highlight in yellow during edit mode\n- **State Management**: Only one item can be edited at a time\n- **Validation**: Form validation before saving changes\n\n### User Interface\n- **Color-coded Buttons**:\n - 🔵 Edit (Blue) - Start inline editing\n - 🟢 Save (Green) - Confirm changes\n - ⚫ Cancel (Gray) - Discard changes\n - 🟡 Toggle (Yellow) - Activate/Deactivate\n - 🔴 Delete (Red) - Remove item\n- **Responsive Tables**: Optimized for both desktop and mobile viewing\n- **Real-time Updates**: Changes reflect immediately after saving\n\n### Data Management\n- **Export Functionality**: Download all student responses as CSV\n- **Bulk Operations**: Add multiple items using the forms\n- **Safe Deletion**: Confirmation dialogs prevent accidental deletions\n- **Cascade Operations**: Deleting timeslots removes associated projects and responses\n\n## Default Data\n\nThe system initializes with:\n- 3 timeslots (Tuesday morning sessions)\n- 8 projects (Projekt A through H) for each timeslot\n\n## Customization\n\nYou can customize the system by:\n1. **Using the Admin Panel**: \n - Inline edit existing timeslots and projects\n - Add new timeslots and projects via forms\n - Activate/deactivate items as needed\n2. **Styling Changes**: Modify the CSS in `schueler.html` for student interface styling\n3. **Database Schema**: Update the schema in `backend/index.ts` for additional fields\n4. **Admin Interface**: Customize the admin panel styling and functionality\n\n## Development\n\n### Database Reset\nTo reset the database during development:\n```\nGET /api/debug/reset\n```\nThis will drop all tables and recreate them with default data.\n\n### Debugging\n- Use `/api/debug/data` to view all database contents\n- Check browser console for client-side errors\n- Server logs show database operations and API calls\n\n## Security Notes\n\n- No authentication is currently implemented on admin endpoints\n- Consider adding authentication for production use\n- All admin functions are accessible via `/admin` URL\n- Database operations include proper error handling and validation",[150],"1b2c0ca0-bfbe-11f0-88ff-42dde27851f2","backend","ae5aeae1-0739-4af5-abf0-3f5a4237bd65",6,["D",1762948366897],"directory",[158],"pulls","branches","forks",3,"envVars",{"_172":61,"_174":61},"connections",{"_172":61,"_173":61},"count","unfilledCount","emptyCount",{"_43":157,"_32":158,"_30":159,"_135":-5,"_41":42,"_40":160,"_137":24,"_38":205,"_13":61,"_34":162,"_36":-5,"_23":26,"_141":-5,"_182":206,"_27":207},{"_43":195,"_32":196,"_30":197,"_135":159,"_41":42,"_40":198,"_137":26,"_38":199,"_13":200,"_34":201,"_36":202,"_23":26,"_141":-5,"_182":203,"_27":204},{"_43":191,"_32":33,"_30":31,"_135":159,"_41":42,"_40":14,"_137":26,"_38":192,"_13":61,"_34":35,"_36":37,"_23":26,"_141":-5,"_182":193,"_27":194},{"_43":149,"_32":150,"_30":151,"_135":-5,"_41":42,"_40":152,"_137":26,"_38":188,"_13":154,"_34":20,"_36":155,"_23":26,"_141":-5,"_182":189,"_27":190},{"_43":143,"_32":144,"_30":145,"_135":-5,"_41":42,"_40":146,"_137":24,"_38":185,"_13":61,"_34":35,"_36":107,"_23":26,"_141":-5,"_182":186,"_27":187},{"_43":132,"_32":133,"_30":134,"_135":-5,"_41":42,"_40":136,"_137":26,"_38":181,"_13":139,"_34":20,"_36":140,"_23":26,"_141":-5,"_182":183,"_27":184},["D",1762949720193],"children",[],[133],["D",1762947612985],[],[144],["D",1762949233946],[],[150],"9f1fb3c4-bfc1-11f0-a8c4-42dde27851f2",["D",1762949876767],[],[158,33],"481b76b2-bfc1-11f0-a1b1-42dde27851f2","index.ts","1b2bf742-bfbe-11f0-88ff-42dde27851f2",33,["D",1762949730773],11,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Database setup\nconst TIMESLOTS_TABLE = 'project_timeslots';\nconst PROJECTS_TABLE = 'project_options';\nconst RESPONSES_TABLE = 'student_responses';\n\n// Initialize database tables\nasync function initDatabase() {\n // Create timeslots table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TIMESLOTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n time_description TEXT NOT NULL,\n order_index INTEGER NOT NULL,\n active BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create projects table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${PROJECTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timeslot_id INTEGER,\n project_name TEXT NOT NULL,\n project_description TEXT,\n max_participants INTEGER DEFAULT NULL,\n active BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (timeslot_id) REFERENCES ${TIMESLOTS_TABLE} (id)\n )`);\n\n // Create responses table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${RESPONSES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_name TEXT NOT NULL,\n timeslot_id INTEGER,\n first_choice TEXT,\n second_choice TEXT,\n third_choice TEXT,\n submitted_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (timeslot_id) REFERENCES ${TIMESLOTS_TABLE} (id)\n )`);\n\n // Insert default data if tables are empty\n const { rows: timeslotCount } = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TIMESLOTS_TABLE}`);\n if (timeslotCount[0].count === 0) {\n await insertDefaultData();\n }\n}\n\nasync function insertDefaultData() {\n // Insert default timeslots\n const timeslots = [\n { title: \"1. Dienstag 9:00-10:30 Uhr\", time_description: \"Dienstag 9:00-10:30 Uhr\", order_index: 1 },\n { title: \"2. Dienstag 10:45-12:15 Uhr\", time_description: \"Dienstag 10:45-12:15 Uhr\", order_index: 2 },\n { title: \"3. Dienstag 12:45-13:30 Uhr\", time_description: \"Dienstag 12:45-13:30 Uhr\", order_index: 3 }\n ];\n\n for (const timeslot of timeslots) {\n await sqlite.execute(\n `INSERT INTO ${TIMESLOTS_TABLE} (title, time_description, order_index) VALUES (?, ?, ?)`,\n [timeslot.title, timeslot.time_description, timeslot.order_index]\n );\n \n // Get the timeslot ID by querying back\n const { rows: insertedTimeslot } = await sqlite.execute(\n `SELECT id FROM ${TIMESLOTS_TABLE} WHERE title = ? AND order_index = ?`,\n [timeslot.title, timeslot.order_index]\n );\n \n const timeslotId = insertedTimeslot[0].id;\n console.log(`Inserted timeslot with ID: ${timeslotId}`);\n \n // Insert default projects for each timeslot\n const projects = ['Projekt A', 'Projekt B', 'Projekt C', 'Projekt D', 'Projekt E', 'Projekt F', 'Projekt G', 'Projekt H'];\n \n for (const projectName of projects) {\n await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name) VALUES (?, ?)`,\n [timeslotId, projectName]\n );\n console.log(`Inserted project ${projectName} for timeslot ${timeslotId}`);\n }\n }\n}\n\n// API Routes\napp.get('/api/debug/reset', async (c) => {\n // Drop and recreate tables\n await sqlite.execute(`DROP TABLE IF EXISTS ${RESPONSES_TABLE}`);\n await sqlite.execute(`DROP TABLE IF EXISTS ${PROJECTS_TABLE}`);\n await sqlite.execute(`DROP TABLE IF EXISTS ${TIMESLOTS_TABLE}`);\n \n await initDatabase();\n return c.json({ message: 'Database reset complete' });\n});\n\napp.get('/api/debug/data', async (c) => {\n const { rows: timeslots } = await sqlite.execute(`SELECT * FROM ${TIMESLOTS_TABLE}`);\n const { rows: projects } = await sqlite.execute(`SELECT * FROM ${PROJECTS_TABLE}`);\n const { rows: responses } = await sqlite.execute(`SELECT * FROM ${RESPONSES_TABLE}`);\n \n return c.json({ timeslots, projects, responses });\n});\n\napp.get('/api/timeslots', async (c) => {\n const { rows: timeslots } = await sqlite.execute(\n `SELECT * FROM ${TIMESLOTS_TABLE} WHERE active = 1 ORDER BY order_index`\n );\n\n const timelotData = [];\n \n for (const timeslot of timeslots) {\n const { rows: projects } = await sqlite.execute(\n `SELECT * FROM ${PROJECTS_TABLE} WHERE timeslot_id = ? AND active = 1`,\n [timeslot.id]\n );\n \n timelotData.push({\n id: timeslot.id,\n title: timeslot.title,\n timeDescription: timeslot.time_description,\n orderIndex: timeslot.order_index,\n projects: projects.map(p => ({\n id: p.id,\n name: p.project_name,\n description: p.project_description,\n maxParticipants: p.max_participants\n }))\n });\n }\n\n return c.json(timelotData);\n});\n\napp.post('/api/responses', async (c) => {\n const data = await c.req.json();\n \n // Validate required fields\n if (!data.name || !data.responses || !Array.isArray(data.responses)) {\n return c.json({ error: 'Invalid data format' }, 400);\n }\n\n try {\n // Insert each response\n for (const response of data.responses) {\n if (response.rankings && response.rankings.length >= 3) {\n // Find timeslot ID by title\n const { rows: timeslots } = await sqlite.execute(\n `SELECT id FROM ${TIMESLOTS_TABLE} WHERE title = ?`,\n [response.question]\n );\n \n if (timeslots.length > 0) {\n await sqlite.execute(\n `INSERT INTO ${RESPONSES_TABLE} (student_name, timeslot_id, first_choice, second_choice, third_choice) \n VALUES (?, ?, ?, ?, ?)`,\n [\n data.name,\n timeslots[0].id,\n response.rankings[0] || null,\n response.rankings[1] || null,\n response.rankings[2] || null\n ]\n );\n }\n }\n }\n\n return c.json({ success: true, message: 'Responses saved successfully' });\n } catch (error) {\n console.error('Error saving responses:', error);\n return c.json({ error: 'Failed to save responses' }, 500);\n }\n});\n\n// Admin routes for managing timeslots and projects\napp.get('/admin', async (c) => {\n const adminHtml = `\n \n \n \n Admin - Projektauswahl\n \n \n \n

Admin Panel - Projektauswahl

\n \n

Timeslots

Add New Timeslot

\n \n \n \n \n

\n\n

Projects

Add New Project

\n \n \n \n \n

\n\n

Student Responses

\n \n

\n\n \n \n \n `;\n \n return c.html(adminHtml);\n});\n\n// Admin API routes\napp.post('/api/admin/timeslots', async (c) => {\n const data = await c.req.json();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${TIMESLOTS_TABLE} (title, time_description, order_index) VALUES (?, ?, ?)`,\n [data.title, data.time_description, data.order_index]\n );\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.post('/api/admin/projects', async (c) => {\n const data = await c.req.json();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name, project_description) VALUES (?, ?, ?)`,\n [data.timeslot_id, data.project_name, data.project_description]\n );\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.put('/api/admin/timeslots/:id', async (c) => {\n const id = c.req.param('id');\n const data = await c.req.json();\n \n try {\n if (data.updateAll) {\n // Update all fields\n await sqlite.execute(\n `UPDATE ${TIMESLOTS_TABLE} SET title = ?, time_description = ?, order_index = ? WHERE id = ?`,\n [data.title, data.time_description, data.order_index, id]\n );\n } else {\n // Update only active status (existing functionality)\n await sqlite.execute(\n `UPDATE ${TIMESLOTS_TABLE} SET active = ? WHERE id = ?`,\n [data.active ? 1 : 0, id]\n );\n }\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.put('/api/admin/projects/:id', async (c) => {\n const id = c.req.param('id');\n const data = await c.req.json();\n \n try {\n if (data.updateAll) {\n // Update all fields\n await sqlite.execute(\n `UPDATE ${PROJECTS_TABLE} SET timeslot_id = ?, project_name = ?, project_description = ? WHERE id = ?`,\n [data.timeslot_id, data.project_name, data.project_description, id]\n );\n } else {\n // Update only active status (existing functionality)\n await sqlite.execute(\n `UPDATE ${PROJECTS_TABLE} SET active = ? WHERE id = ?`,\n [data.active ? 1 : 0, id]\n );\n }\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.delete('/api/admin/timeslots/:id', async (c) => {\n const id = c.req.param('id');\n \n try {\n // Delete associated responses and projects first\n await sqlite.execute(`DELETE FROM ${RESPONSES_TABLE} WHERE timeslot_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM ${PROJECTS_TABLE} WHERE timeslot_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM ${TIMESLOTS_TABLE} WHERE id = ?`, [id]);\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.delete('/api/admin/projects/:id', async (c) => {\n const id = c.req.param('id');\n \n try {\n await sqlite.execute(`DELETE FROM ${PROJECTS_TABLE} WHERE id = ?`, [id]);\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.get('/api/admin/export-csv', async (c) => {\n try {\n const { rows: responses } = await sqlite.execute(`\n SELECT r.*, t.title as timeslot_title \n FROM ${RESPONSES_TABLE} r \n LEFT JOIN ${TIMESLOTS_TABLE} t ON r.timeslot_id = t.id \n ORDER BY r.submitted_at DESC\n `);\n \n let csv = 'Student Name,Timeslot,First Choice,Second Choice,Third Choice,Submitted At\\n';\n \n responses.forEach(r => {\n csv += `\"${r.student_name}\",\"${r.timeslot_title || ''}\",\"${r.first_choice || ''}\",\"${r.second_choice || ''}\",\"${r.third_choice || ''}\",\"${r.submitted_at}\"\\n`;\n });\n \n return new Response(csv, {\n headers: {\n 'Content-Type': 'text/csv',\n 'Content-Disposition': 'attachment; filename=\"project_responses.csv\"'\n }\n });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\n// Serve the main HTML file\napp.get('/', async (c) => {\n let html = await readFile(\"/schueler.html\", import.meta.url);\n \n // Inject the API endpoint for dynamic loading\n const scriptInjection = `\n \n `;\n \n html = html.replace('', `${scriptInjection}`);\n return c.html(html);\n});\n\n// Initialize database on startup\nawait initDatabase();\n\nexport default app.fetch;",[],[158,196],["D",1762948366897],[176,177],[158],["D",1762947612971],["D",1789529498250],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":26},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_125":246,"_247":248,"_249":250,"_251":26,"_252":26,"_253":26,"_254":24,"_255":-5,"_256":-7,"_257":-7,"_258":61,"_259":26,"_260":26,"_261":-5,"_262":26,"_263":26,"_264":26,"_265":-5},"ENV",{"_217":218,"_219":220,"_221":88,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Admin Panel - Projektauswahl

Timeslots

Add New Timeslot

Projects

Add New Project

Student Responses

Copy Project

Projektauswahl

Admin Panel - Projektauswahl

Timeslots

Add New Timeslot

Projects

Add New Project

Student Responses

Diff · v34