[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_273":274,"_275":276},"routes/_app.x.$handle.$name",{"_98":97,"_32":44,"_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":25,"_121":122,"_123":57,"_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",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_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":25},"version",68,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","schueler.html","latestPath","fileId","b8f786c2-bfbd-11f0-8d12-42dde27851f2","name","fileType","content","\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","\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","createdAt",["D",1763025761481],"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",true,"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":53,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_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",{"_42":43,"_32":44,"_37":268,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":269,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":270,"_82":271,"_84":272,"_86":25},"tree",[212,214,216,217,218,219,220,221,222],"files",[212,213,214,215,216,217,218,219,220,221,222],"counts",{"_201":61,"_202":147,"_203":204,"_205":206,"_207":208},"contents",[128,129,130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":195,"_32":196,"_30":197,"_138":-5,"_40":41,"_39":198,"_139":57,"_37":199,"_13":61,"_33":193,"_34":-5,"_24":25,"_142":-5,"_27":200},{"_42":188,"_32":189,"_30":190,"_138":-5,"_40":41,"_39":191,"_139":57,"_37":192,"_13":61,"_33":193,"_34":-5,"_24":25,"_142":-5,"_27":194},{"_42":180,"_32":181,"_30":182,"_138":-5,"_40":41,"_39":183,"_139":57,"_37":184,"_13":185,"_33":20,"_34":186,"_24":25,"_142":-5,"_27":187},{"_42":173,"_32":174,"_30":175,"_138":-5,"_40":41,"_39":176,"_139":25,"_37":177,"_13":147,"_33":20,"_34":178,"_24":25,"_142":-5,"_27":179},{"_42":166,"_32":167,"_30":168,"_138":-5,"_40":41,"_39":169,"_139":57,"_37":170,"_13":147,"_33":20,"_34":171,"_24":25,"_142":-5,"_27":172},{"_42":158,"_32":159,"_30":160,"_138":-5,"_40":41,"_39":161,"_139":25,"_37":162,"_13":163,"_33":20,"_34":164,"_24":25,"_142":-5,"_27":165},{"_42":151,"_32":152,"_30":153,"_138":-5,"_40":41,"_39":154,"_139":25,"_37":155,"_13":61,"_33":20,"_34":156,"_24":25,"_142":-5,"_27":157},{"_42":144,"_32":145,"_30":146,"_138":-5,"_40":41,"_39":147,"_139":57,"_37":148,"_13":61,"_33":149,"_34":107,"_24":25,"_142":-5,"_27":150},{"_42":137,"_32":28,"_30":31,"_138":-5,"_40":41,"_39":14,"_139":25,"_37":140,"_13":141,"_33":20,"_34":36,"_24":25,"_142":-5,"_27":143},"4df11ebe-c072-11f0-a6b5-42dde27851f2","parentId","latest",["D",1763025761481],18,"label",[28],"59cdf628-bfbc-11f0-aada-42dde27851f2","main.ts","59cdf6d2-bfbc-11f0-aada-42dde27851f2",1,["D",1762947612985],"script",[145],"a4f2883c-c000-11f0-bd5e-42dde27851f2","assignment.html","a4f2892c-c000-11f0-bd5e-42dde27851f2",55,["D",1762976944813],"\n\n\n \n \n Kid-to-Project Assignment Optimizer\n \n \n \n \n\n\n

\n\n \n\n",[152],"4decb0ae-c072-11f0-87f5-42dde27851f2","admin.html","8432a232-c003-11f0-890a-42dde27851f2",67,["D",1763025761452],2,"\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\n

Student Responses

View and manage all student responses on a dedicated page with advanced filtering and sorting.

\n View Student Responses →\n

\n\n

Project Assignments

View students grouped by their #1 project choices and assign students to projects.

\n Manage Assignments →\n

\n\n \n \n\n \n\n\n",[159],"b927a62c-c003-11f0-a3bd-42dde27851f2","admin-responses.html","842d3608-c003-11f0-9532-42dde27851f2",65,["D",1762978267182],"\n\n\n Student Responses - Projektauswahl\n \n\n\n \n\n

Total Submissions

Unique Students

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

\n\n \n\n\n",[167],"b92d7d86-c003-11f0-a331-42dde27851f2","admin-assignments.html","844a41e4-c003-11f0-9532-42dde27851f2",66,["D",1762978267184],"\n\n\n Project Assignments - Projektauswahl\n \n\n\n \n\n

Optimization Settings

\n\n Select Timeslot:\n \n\n Preference Weights:\n

\n 1st Choice Weight\n \n

\n 2nd Choice Weight\n \n

\n 3rd Choice Weight\n \n

\n\n \n\n

\n \n \n \n

\n\n

\n 💡 Tip: After optimization, you can drag and drop students between projects to manually adjust assignments.\n

\n\n

Assignment Statistics

Total Score

1st Choice

2nd Choice

3rd Choice

Not Preferred

\n\n

Select a timeslot and click \"Optimize Assignment\" to see results

\n\n \n\n\n",[174],"7bdeaf2a-bfc4-11f0-afca-42dde27851f2","README.md","8af0b694-bfbe-11f0-a116-42dde27851f2",50,["D",1762951106108],9,"# 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 /admin/responses` - View student responses grouped by student\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- `POST /api/admin/projects/:id/copy` - Copy project to different timeslot\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- `DELETE /api/admin/responses/student/:studentName` - Delete all responses for a specific student\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- `max_participants` - Maximum number of participants (optional)\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, max participants, 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 - 🔵 Copy (Cyan) - Copy project to another timeslot\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- **Student Response Grouping**: View all responses grouped by student at `/admin/responses`\n- **Student Response Deletion**: Delete all responses for a specific student with one click\n- **Export Functionality**: Download all student responses as CSV\n- **Copy Projects**: Easily duplicate projects across different timeslots\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",[181],"1b2c0ca0-bfbe-11f0-88ff-42dde27851f2","backend","ae5aeae1-0739-4af5-abf0-3f5a4237bd65",6,["D",1762948366897],"directory",[189],"de6f8f3e-bfc3-11f0-b56f-42dde27851f2",".claude","de6f902e-bfc3-11f0-b56f-42dde27851f2",46,["D",1762950841979],[196],"pulls","branches","forks",3,"envVars",{"_209":61,"_211":61},"connections",{"_209":61,"_210":61},"count","unfilledCount","emptyCount",{"_42":195,"_32":196,"_30":197,"_138":-5,"_40":41,"_39":198,"_139":57,"_37":265,"_13":61,"_33":193,"_34":-5,"_24":25,"_142":-5,"_224":266,"_27":267},{"_42":257,"_32":258,"_30":259,"_138":197,"_40":41,"_39":260,"_139":57,"_37":261,"_13":147,"_33":20,"_34":262,"_24":25,"_142":-5,"_224":263,"_27":264},{"_42":188,"_32":189,"_30":190,"_138":-5,"_40":41,"_39":191,"_139":57,"_37":254,"_13":61,"_33":193,"_34":-5,"_24":25,"_142":-5,"_224":255,"_27":256},{"_42":245,"_32":246,"_30":55,"_138":190,"_40":41,"_39":247,"_139":25,"_37":248,"_13":249,"_33":250,"_34":251,"_24":25,"_142":-5,"_224":252,"_27":253},{"_42":180,"_32":181,"_30":182,"_138":-5,"_40":41,"_39":183,"_139":57,"_37":242,"_13":185,"_33":20,"_34":186,"_24":25,"_142":-5,"_224":243,"_27":244},{"_42":173,"_32":174,"_30":175,"_138":-5,"_40":41,"_39":176,"_139":25,"_37":239,"_13":147,"_33":20,"_34":178,"_24":25,"_142":-5,"_224":240,"_27":241},{"_42":166,"_32":167,"_30":168,"_138":-5,"_40":41,"_39":169,"_139":57,"_37":236,"_13":147,"_33":20,"_34":171,"_24":25,"_142":-5,"_224":237,"_27":238},{"_42":158,"_32":159,"_30":160,"_138":-5,"_40":41,"_39":161,"_139":25,"_37":233,"_13":163,"_33":20,"_34":164,"_24":25,"_142":-5,"_224":234,"_27":235},{"_42":151,"_32":152,"_30":153,"_138":-5,"_40":41,"_39":154,"_139":25,"_37":230,"_13":61,"_33":20,"_34":156,"_24":25,"_142":-5,"_224":231,"_27":232},{"_42":144,"_32":145,"_30":146,"_138":-5,"_40":41,"_39":147,"_139":57,"_37":227,"_13":61,"_33":149,"_34":107,"_24":25,"_142":-5,"_224":228,"_27":229},{"_42":137,"_32":28,"_30":31,"_138":-5,"_40":41,"_39":14,"_139":25,"_37":223,"_13":141,"_33":20,"_34":36,"_24":25,"_142":-5,"_224":225,"_27":226},["D",1763025761481],"children",[],[28],["D",1762947612985],[],[145],["D",1762976944813],[],[152],["D",1763025761452],[],[159],["D",1762978267182],[],[167],["D",1762978267184],[],[174],["D",1762951106108],[],[181],"84374120-c003-11f0-aa23-42dde27851f2","index.ts",61,["D",1762978178370],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';\nconst ASSIGNMENTS_TABLE = 'project_assignments';\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 submission_id TEXT NOT NULL,\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 // Create assignments table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ASSIGNMENTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timeslot_id INTEGER NOT NULL,\n student_name TEXT NOT NULL,\n project_name TEXT NOT NULL,\n preference_rank INTEGER,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (timeslot_id) REFERENCES ${TIMESLOTS_TABLE} (id),\n UNIQUE(timeslot_id, student_name)\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 // Generate submission ID if not provided\n const submissionId = data.submissionId || crypto.randomUUID();\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} (submission_id, student_name, timeslot_id, first_choice, second_choice, third_choice)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n submissionId,\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', submissionId });\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 = await readFile(\"/admin.html\", import.meta.url);\n return c.html(adminHtml);\n});\n\n// Admin responses page - separate page for viewing student responses\napp.get('/admin/responses', async (c) => {\n const responsesHtml = await readFile(\"/admin-responses.html\", import.meta.url);\n return c.html(responsesHtml);\n});\n\n// Admin assignments page - for assigning students to projects\napp.get('/admin/assignments', async (c) => {\n const assignmentsHtml = await readFile(\"/admin-assignments.html\", import.meta.url);\n return c.html(assignmentsHtml);\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/responses/student/:studentName', async (c) => {\n const studentName = decodeURIComponent(c.req.param('studentName'));\n\n try {\n // Delete all responses for this student\n await sqlite.execute(`DELETE FROM ${RESPONSES_TABLE} WHERE student_name = ?`, [studentName]);\n return c.json({ success: true });\n } catch (error) {\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.delete('/api/admin/responses/submission/:submissionId', async (c) => {\n const submissionId = decodeURIComponent(c.req.param('submissionId'));\n\n try {\n // Delete all responses for this submission\n await sqlite.execute(`DELETE FROM ${RESPONSES_TABLE} WHERE submission_id = ?`, [submissionId]);\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\n// API endpoints for assignments\napp.post('/api/admin/assignments/:timeslotId/save', async (c) => {\n const timeslotId = parseInt(c.req.param('timeslotId'));\n const { assignments } = await c.req.json();\n\n try {\n // Delete existing assignments for this timeslot\n await sqlite.execute(\n `DELETE FROM ${ASSIGNMENTS_TABLE} WHERE timeslot_id = ?`,\n [timeslotId]\n );\n\n // Insert new assignments\n for (const assignment of assignments) {\n await sqlite.execute(\n `INSERT INTO ${ASSIGNMENTS_TABLE} (timeslot_id, student_name, project_name, preference_rank)\n VALUES (?, ?, ?, ?)`,\n [timeslotId, assignment.studentName, assignment.projectName, assignment.preferenceRank]\n );\n }\n\n return c.json({ success: true, message: 'Assignments saved successfully' });\n } catch (error) {\n console.error('Error saving assignments:', error);\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.get('/api/admin/assignments/:timeslotId/load', async (c) => {\n const timeslotId = parseInt(c.req.param('timeslotId'));\n\n try {\n const { rows: assignments } = await sqlite.execute(\n `SELECT student_name, project_name, preference_rank, updated_at\n FROM ${ASSIGNMENTS_TABLE}\n WHERE timeslot_id = ?`,\n [timeslotId]\n );\n\n return c.json({\n success: true,\n assignments: assignments.map(a => ({\n studentName: a.student_name,\n projectName: a.project_name,\n preferenceRank: a.preference_rank,\n updatedAt: a.updated_at\n }))\n });\n } catch (error) {\n console.error('Error loading assignments:', error);\n return c.json({ error: error.message }, 500);\n }\n});\n\napp.delete('/api/admin/assignments/:timeslotId', async (c) => {\n const timeslotId = parseInt(c.req.param('timeslotId'));\n\n try {\n await sqlite.execute(\n `DELETE FROM ${ASSIGNMENTS_TABLE} WHERE timeslot_id = ?`,\n [timeslotId]\n );\n\n return c.json({ success: true, message: 'Assignments deleted successfully' });\n } catch (error) {\n console.error('Error deleting assignments:', 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, r.submission_id\n `);\n\n // Helper function to escape CSV values according to RFC 4180\n function escapeCsvValue(value) {\n if (value == null || value === '') return '';\n\n const stringValue = String(value);\n\n // Prevent CSV injection by prefixing dangerous characters with a single quote\n if (/^[=+\\-@]/.test(stringValue)) {\n return `\"'${stringValue.replace(/\"/g, '\"\"')}\"`;\n }\n\n // If value contains quotes, commas, or newlines, it must be quoted and quotes must be doubled\n if (stringValue.includes('\"')) {\n return `\"${stringValue.replace(/\"/g, '\"\"')}\"`;\n }\n\n if (stringValue.includes(',') || stringValue.includes('\\n') || stringValue.includes('\\r')) {\n return `\"${stringValue}\"`;\n }\n\n return stringValue;\n }\n\n let csv = 'Submission ID,Student Name,Timeslot,First Choice,Second Choice,Third Choice,Submitted At\\n';\n\n responses.forEach(r => {\n const row = [\n r.submission_id || '',\n r.student_name,\n r.timeslot_title || '',\n r.first_choice || '',\n r.second_choice || '',\n r.third_choice || '',\n r.submitted_at\n ].map(escapeCsvValue).join(',');\n\n csv += row + '\\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;\n",[],[189,246],["D",1762948366897],[215],[189],"843b2524-c003-11f0-a38b-42dde27851f2","settings.local.json","de9c7c60-bfc3-11f0-b56f-42dde27851f2",62,["D",1762978178397],"{\n \"permissions\": {\n \"allow\": [\n \"Bash(npm run dev:*)\",\n \"Bash(/Users/chris/fnifs/Projektwoche/backend/index_clean.ts)\"\n ],\n \"deny\": [],\n \"ask\": []\n }\n}\n",[],[196,258],["D",1762950841979],[213],[196],["D",1762947612971],["D",1789529498250],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":25},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_125":306,"_307":308,"_309":310,"_311":25,"_312":25,"_313":25,"_314":57,"_315":-5,"_316":-7,"_317":-7,"_318":61,"_319":25,"_320":25,"_321":-5,"_322":25,"_323":25,"_324":25,"_325":-5},"ENV",{"_277":278,"_279":280,"_281":88,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305},"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"]

Diff · v68