[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_733":734,"_735":736},"routes/_app.x.$handle.$name",{"_96":95,"_31":42,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":55,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_40":41,"_31":42,"_35":43,"_44":-5,"_45":24,"_46":47,"_48":47,"_49":-5,"_50":-5,"_18":51,"_52":53,"_54":55,"_56":55,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",163,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":20,"_33":34,"_35":36,"_37":14,"_38":39,"_23":24},"previous","deleted",false,"deletedHere","path","AGENTS.md","latestPath","fileId","9a17109e-3fc2-11f1-be7b-42b51c65c3df","name","fileType","content","# AGENTS\n\n## Project Inventory\n\nThis repository is a Val Town app for managing a school \"Projektwoche\" workflow.\n\nIt has two main user roles:\n\n- Students submit ranked project preferences for each timeslot.\n- Admins manage timeslots and parent-offered projects, inspect submissions, and assign students to projects.\n\nThe live backend is implemented in [backend/index.ts](/Users/chris/fnifs/Projektwoche/backend/index.ts). It uses:\n\n- `Hono` for routing\n- Val Town `sqlite` for persistence\n- `readFile(..., import.meta.url)` to serve static HTML pages from the repo\n\nThere is no separate frontend build step in this repo. The UI is plain HTML/CSS/JS files served directly by the backend.\n\n## Runtime And Hosting\n\n- Host platform: Val Town\n- Local Val Town metadata: [.vt/state.json](/Users/chris/fnifs/Projektwoche/.vt/state.json)\n- Primary backend entrypoint: [backend/index.ts](/Users/chris/fnifs/Projektwoche/backend/index.ts)\n- [main.ts](/Users/chris/fnifs/Projektwoche/main.ts) is currently empty and appears unused\n\nIf you change routes or the HTML filenames, update `readFile(...)` calls and route handlers in `backend/index.ts` together.\n\n## What The App Does\n\n### Domain model\n\n- A \"Projektwoche\" consists of multiple timeslots.\n- Projects are offered by parents; this is represented in the backend via the `offered_by` field on projects.\n- Some projects may span two timeslots. In practice, the app supports this by duplicating or copying a project into multiple timeslots rather than by storing a dedicated multi-slot project entity.\n- Children rank their preferred projects within each timeslot.\n- Admins then assign children to projects, aiming to satisfy the highest-ranked preferences where capacity and constraints allow.\n\n### Student flow\n\n- `GET /` serves [schueler.html](/Users/chris/fnifs/Projektwoche/schueler.html)\n- The page loads active timeslots and their active projects from `GET /api/timeslots`\n- Students submit ranked preferences to `POST /api/responses`\n- Each submission stores one response row per timeslot, linked by a shared `submission_id`\n\n### Admin flow\n\n- `GET /admin` serves [admin.html](/Users/chris/fnifs/Projektwoche/admin.html)\n- Admins can create, edit, activate/deactivate, copy, and delete timeslots and projects\n- Admins can inspect raw response data and export CSV\n- Admins can compute and manually adjust assignments, then save them per timeslot\n- The project-copy workflow is the current mechanism for representing projects that run across more than one timeslot\n\n### Assignment flow\n\nAssignments are a second-stage workflow after students submit preferences:\n\n- [admin-assignments.html](/Users/chris/fnifs/Projektwoche/admin-assignments.html) optimizes assignments for a selected timeslot and allows drag/drop manual correction\n- Saved assignments are stored in the `project_assignments` table\n- [admin-assignments-individual.html](/Users/chris/fnifs/Projektwoche/admin-assignments-individual.html) shows each student’s schedule across timeslots\n- [admin-assignments-by-project.html](/Users/chris/fnifs/Projektwoche/admin-assignments-by-project.html) shows rosters grouped by project\n- The optimizer tries to place children into preferred projects first, but final assignments can be adjusted manually by admins\n\n## File Inventory\n\n- [backend/index.ts](/Users/chris/fnifs/Projektwoche/backend/index.ts): server routes, DB schema, migrations, CSV export, static page serving\n- [schueler.html](/Users/chris/fnifs/Projektwoche/schueler.html): student submission interface\n- [admin.html](/Users/chris/fnifs/Projektwoche/admin.html): admin CRUD page for timeslots and projects\n- [admin-responses.html](/Users/chris/fnifs/Projektwoche/admin-responses.html): grouped submission review and deletion UI\n- [admin-assignments.html](/Users/chris/fnifs/Projektwoche/admin-assignments.html): assignment optimizer and manual adjustment UI\n- [admin-assignments-individual.html](/Users/chris/fnifs/Projektwoche/admin-assignments-individual.html): per-student assignment view\n- [admin-assignments-by-project.html](/Users/chris/fnifs/Projektwoche/admin-assignments-by-project.html): per-project assignment view\n- [assignment.html](/Users/chris/fnifs/Projektwoche/assignment.html): standalone assignment optimizer prototype/tool; it is not served by `backend/index.ts`\n- [README.md](/Users/chris/fnifs/Projektwoche/README.md): partially outdated overview\n\n## API Inventory\n\n### Public routes\n\n- `GET /`\n- `GET /api/timeslots`\n- `POST /api/responses`\n\n### Admin pages\n\n- `GET /admin`\n- `GET /admin/responses`\n- `GET /admin/assignments`\n- `GET /admin/assignments/individual`\n- `GET /admin/assignments/by-project`\n\n### Admin data routes\n\n- `GET /api/debug/data`\n- `GET /api/debug/reset`\n- `POST /api/admin/timeslots`\n- `POST /api/admin/projects`\n- `POST /api/admin/projects/:id/copy`\n- `PUT /api/admin/timeslots/:id`\n- `PUT /api/admin/projects/:id`\n- `DELETE /api/admin/timeslots/:id`\n- `DELETE /api/admin/projects/:id`\n- `DELETE /api/admin/responses/student/:studentName`\n- `DELETE /api/admin/responses/submission/:submissionId`\n- `GET /api/admin/export-csv`\n\n### Assignment routes\n\n- `POST /api/admin/assignments/:timeslotId/save`\n- `POST /api/admin/assignments/:timeslotId/assign`\n- `GET /api/admin/assignments/:timeslotId/load`\n- `DELETE /api/admin/assignments/:timeslotId`\n\n## Database Inventory\n\nTables created in `initDatabase()`:\n\n- `project_timeslots`\n- `project_options`\n- `student_responses`\n- `project_assignments`\n\nImportant schema details:\n\n- `project_options` includes migrated columns `offered_by` and `what_to_bring`\n- `student_responses` stores `submission_id`, so one student submission spans multiple rows\n- `project_assignments` has a uniqueness constraint on `(timeslot_id, student_name)`\n\n## Important Behaviors And Gotchas\n\n- The README no longer reflects the full system. Assignments, `offered_by`, `what_to_bring`, and submission deletion are implemented in code but not fully documented there.\n- There is no auth. All admin pages and admin APIs are publicly reachable if the Val is public.\n- `GET /api/debug/reset` drops tables and reseeds defaults. Treat it as destructive.\n- `GET /api/debug/data` exposes the full data model and is used heavily by the admin pages.\n- The root page injects `window.DYNAMIC_DATA_ENDPOINT` and `window.SUBMIT_ENDPOINT` into `schueler.html` at request time.\n- Default seed data is placeholder content for three Tuesday timeslots and projects A-H.\n- `assignment.html` duplicates assignment logic but is currently separate from the served admin workflow.\n- Two-timeslot projects are currently modeled operationally by copying the same project into multiple timeslots, which means there is no built-in guarantee that those linked entries stay synchronized.\n\n## Editing Guidance\n\nWhen changing this project:\n\n- Keep backend route names and frontend `fetch(...)` calls aligned.\n- Preserve the JSON shapes expected by the HTML pages before refactoring API responses.\n- If you change database columns, update:\n - table creation in `initDatabase()`\n - migration checks in `initDatabase()`\n - CRUD SQL\n - any affected admin or student HTML pages\n- If you introduce first-class support for multi-timeslot projects, review both the submission model and assignment persistence carefully; the current schema is timeslot-centric.\n- If you change how student submissions work, account for the `submission_id` grouping logic used in the admin response pages.\n- If you change assignment persistence, update all three assignment-related HTML pages, not just `admin-assignments.html`.\n\n## Recommended Next Cleanup\n\n- Update [README.md](/Users/chris/fnifs/Projektwoche/README.md) to match the actual current feature set\n- Add auth if this app is intended for real use on a public Val\n- Remove or explicitly document whether [assignment.html](/Users/chris/fnifs/Projektwoche/assignment.html) should remain as a standalone utility\n","createdAt",["D",1777024046330],"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",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":51,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_40":39,"_87":41,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":42,"_94":95},"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",{"_40":41,"_31":42,"_35":728,"_44":-5,"_45":24,"_46":47,"_48":47,"_49":-5,"_50":-5,"_18":51,"_52":53,"_54":55,"_56":55,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":729,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":730,"_80":731,"_82":732,"_84":24},"tree",[274,276,322,324,326,327,328,329,330,331,332,333,334,335,336,337,338],"files",[274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338],"counts",{"_263":59,"_264":171,"_265":266,"_267":268,"_269":270},"contents",[126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_40":257,"_31":258,"_29":259,"_146":-5,"_38":39,"_37":260,"_148":55,"_35":261,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_26":262},{"_40":251,"_31":252,"_29":253,"_146":-5,"_38":39,"_37":254,"_148":55,"_35":255,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_26":256},{"_40":245,"_31":246,"_29":247,"_146":-5,"_38":39,"_37":248,"_148":55,"_35":249,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_26":250},{"_40":238,"_31":239,"_29":240,"_146":-5,"_38":39,"_37":241,"_148":55,"_35":242,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_26":244},{"_40":235,"_31":27,"_29":30,"_146":-5,"_38":39,"_37":14,"_148":55,"_35":236,"_13":59,"_32":20,"_33":34,"_23":24,"_152":-5,"_26":237},{"_40":228,"_31":229,"_29":230,"_146":-5,"_38":39,"_37":231,"_148":55,"_35":232,"_13":59,"_32":20,"_33":233,"_23":24,"_152":-5,"_26":234},{"_40":220,"_31":221,"_29":222,"_146":-5,"_38":39,"_37":223,"_148":55,"_35":224,"_13":225,"_32":20,"_33":226,"_23":24,"_152":-5,"_26":227},{"_40":213,"_31":214,"_29":215,"_146":-5,"_38":39,"_37":216,"_148":55,"_35":217,"_13":202,"_32":20,"_33":218,"_23":24,"_152":-5,"_26":219},{"_40":205,"_31":206,"_29":207,"_146":-5,"_38":39,"_37":208,"_148":55,"_35":209,"_13":210,"_32":20,"_33":211,"_23":24,"_152":-5,"_26":212},{"_40":197,"_31":198,"_29":199,"_146":-5,"_38":39,"_37":200,"_148":55,"_35":201,"_13":202,"_32":20,"_33":203,"_23":24,"_152":-5,"_26":204},{"_40":190,"_31":191,"_29":192,"_146":-5,"_38":39,"_37":193,"_148":55,"_35":194,"_13":171,"_32":20,"_33":195,"_23":24,"_152":-5,"_26":196},{"_40":182,"_31":183,"_29":184,"_146":-5,"_38":39,"_37":185,"_148":24,"_35":186,"_13":187,"_32":20,"_33":188,"_23":24,"_152":-5,"_26":189},{"_40":175,"_31":176,"_29":177,"_146":-5,"_38":39,"_37":178,"_148":55,"_35":179,"_13":171,"_32":20,"_33":180,"_23":24,"_152":-5,"_26":181},{"_40":168,"_31":169,"_29":170,"_146":-5,"_38":39,"_37":171,"_148":55,"_35":172,"_13":59,"_32":173,"_33":105,"_23":24,"_152":-5,"_26":174},{"_40":161,"_31":162,"_29":163,"_146":-5,"_38":39,"_37":164,"_148":24,"_35":165,"_13":59,"_32":20,"_33":166,"_23":24,"_152":-5,"_26":167},{"_40":154,"_31":155,"_29":156,"_146":-5,"_38":39,"_37":157,"_148":55,"_35":158,"_13":59,"_32":20,"_33":159,"_23":24,"_152":-5,"_26":160},{"_40":143,"_31":144,"_29":145,"_146":-5,"_38":39,"_37":147,"_148":55,"_35":149,"_13":150,"_32":20,"_33":151,"_23":24,"_152":-5,"_26":153},"ad198a90-cad4-11f0-9fab-42dde27851f2","schueler.html","b8f786c2-bfbd-11f0-8d12-42dde27851f2","parentId",98,"latest",["D",1764167523429],21,"\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",[144],"99fe4ffa-3fc2-11f1-ad07-42b51c65c3df","parent-proposal.html","99fe509a-3fc2-11f1-ad07-42b51c65c3df",162,["D",1777024046328],"\n\n\n \n \n Weiterleitung...\n\n\n

Zur Eltern-Projektseite

\n\n\n",[155],"99ec3d56-3fc2-11f1-a1c8-42b51c65c3df","parent-project-proposal.html","99ec3dec-3fc2-11f1-a1c8-42b51c65c3df",160,["D",1777024046337],"\n\n\n \n \n Projekt anbieten - Projektwoche\n \n\n\n

Projektwoche · Elternformular

Ein Projekt für die Woche anbieten

\n Du hast eine Idee, die du gern mit einer Gruppe von Kindern umsetzen möchtest? Hier kannst du sie einreichen. Der Vorschlag landet zuerst beim Orga-Team und wird erst nach Prüfung in den Projektplan übernommen.\n

\n Ohne Registrierung\n Ein Formular, kein Passwort, keine extra Hürde.\n

\n Mit Orga-Prüfung\n Ihr markiert nur Verfügbarkeit, die Platzierung machen wir.\n

\n Auch für 2 Zeitslots\n Mehrteilige Projekte werden als zusammenhängender Block verstanden.\n

\n\n \n

\n\n

Elternteil

Kontakt für Rückfragen und Abstimmung mit dem Orga-Team.

\n\n

\n Name *\n \n

\n E-Mail *\n \n

\n\n

\n Telefon\n \n

\n Kind / Bezug zur Schule\n \n

\n\n

Projektidee

Der öffentliche Teil sollte für Kinder und Eltern verständlich formuliert sein.

\n\n

\n Projekttitel *\n \n

\n\n

\n Kurzbeschreibung *\n \n

\n\n

\n Mit-Anbietende / zweite Begleitperson\n \n

\n\n

\n Min. Teilnehmende\n \n

\n Max. Teilnehmende *\n \n

\n Dauer *\n \n

\n\n

\n Hinweis zu 2 Zeitslots\n

\n Dieses Projekt wird als zusammenhängender Block verstanden. Dieselben Kinder nehmen an beiden Zeitslots teil. Später soll die Auswahl im Kinderformular das automatisch berücksichtigen.\n

\n\n

Altersgruppen

Mehrere Gruppen sind möglich, falls das Projekt altersübergreifend geeignet ist.

\n\n

\n \n \n \n Delfine\n Klasse 1-3\n \n \n

\n \n \n \n Drachen\n Klasse 4-6\n \n \n

\n \n \n \n 7/8\n Klasse 7-8\n \n \n

\n \n \n \n 9/10\n Klasse 9-10\n \n \n

\n\n

\n Hinweise zur Altersgruppe\n \n

\n\n

Rahmen & Material

Hier sammeln wir alles, was für die Planung von Raum und Vorbereitung wichtig ist.

\n\n

\n Ort\n

\n \n \n Drinnen\n Tische, Wasser, ruhiger Raum oder andere Innenraumbedingungen.\n \n

\n \n \n Draußen\n Schulhof, Naturgelände oder wetterfeste Kleidung notwendig.\n \n

\n \n \n Egal\n Das Projekt kann flexibel drinnen oder draußen stattfinden.\n \n

\n\n

\n Raum- oder Platzbedarf\n \n

\n Material, das du mitbringst\n \n

\n\n

\n Material, das Kinder mitbringen sollen\n \n

\n Nachricht an das Orga-Team\n \n

\n\n

Verfügbarkeit

Bitte alle Zeitslots markieren, an denen du das Projekt anbieten könntest. Die konkrete Einteilung übernehmen wir später.

\n\n

\n \n \n Dienstag\n 09:00-10:30\n Vormittag · Slot 1\n \n

\n \n \n Dienstag\n 10:45-12:15\n Vormittag · Slot 2\n \n

\n \n \n Dienstag\n 12:45-13:30\n Mittag · Slot 3\n \n

\n \n \n Mittwoch\n 09:00-10:30\n Vormittag · Slot 4\n \n

\n \n \n Mittwoch\n 10:45-12:15\n Vormittag · Slot 5\n \n

\n \n \n Donnerstag\n 09:00-10:30\n Vormittag · Slot 6\n \n

\n\n

\n Diese Version ist noch ein UI-Mock. Der Button speichert nichts dauerhaft, zeigt aber den geplanten Abschlusszustand.\n

\n \n \n

\n\n

Danke, dein Vorschlag ist eingegangen.

\n In der finalen Version würde jetzt eine Bestätigung angezeigt oder ein optionaler Bearbeitungslink erzeugt. Bis dahin dient dieser Zustand nur dazu, die UX zu beurteilen.\n

\n\n

Live-Zusammenfassung

\n Titel\n Noch kein Titel\n

\n Dauer\n 1 Zeitslot\n

\n Altersgruppen\n Noch nicht gewählt\n

\n Teilnehmende\n Noch keine Angabe\n

\n Verfügbarkeit\n Noch keine Zeitslots markiert\n

\n\n

Für die spätere Umsetzung

Diese Seite kann später ohne großes Layout-Risiko an einen neuen API-Endpunkt gehängt werden.
Die verfügbaren Zeitslots sollten dann aus den echten aktiven Slots geladen werden.
Für eine Version ohne Registrierung wäre ein einmaliger Bearbeitungslink optional der beste Kompromiss.

\n\n \n\n\n",[162],"59cdf628-bfbc-11f0-aada-42dde27851f2","main.ts","59cdf6d2-bfbc-11f0-aada-42dde27851f2",1,["D",1762947612985],"script",[169],"a240cb56-caca-11f0-9ac3-42dde27851f2","assignment.html","a4f2892c-c000-11f0-bd5e-42dde27851f2",78,["D",1764163210269],"\n\n\n \n \n Kid-to-Project Assignment Optimizer\n \n \n \n \n\n\n

\n\n \n\n",[176],"ad15b230-cad4-11f0-9124-42dde27851f2","admin.html","8432a232-c003-11f0-890a-42dde27851f2",97,["D",1764167523416],5,"\n\n\n Admin - Projektauswahl\n \n\n\n

Admin Panel - Projektauswahl

\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

View Assignments

View saved assignments in different formats for easy review and printing.

\n Individual View →\n By Project →\n

\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\n \n \n\n \n\n\n",[183],"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",[191],"bab2e0be-cb94-11f0-a637-42dde27851f2","admin-assignments.html","844a41e4-c003-11f0-9532-42dde27851f2",110,["D",1764250009627],7,"\n\n\n Project Assignments - Projektauswahl\n \n\n\n \n\n

Optimization Settings

\n\n Select Timeslot:\n \n\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 \n\n\n",[198],"6b02e30c-cad6-11f0-a2dd-42dde27851f2","admin-assignments-individual.html","2340faa6-cac0-11f0-8e08-42dde27851f2",105,["D",1764168271553],15,"\n\n\n Individual Assignments - Projektauswahl\n \n\n\n \n\n

\n \n \n \n Show expanded view (with project descriptions)\n \n

\n\n

\n Loading assignments...\n

\n\n

\n No assignments found\n

\n\n

\n \n

\n\n \n\n\n",[206],"84ee6ab6-cbbc-11f0-9d32-42dde27851f2","admin-assignments-by-project.html","23393780-cac0-11f0-8a2a-42dde27851f2",111,["D",1764267099289],"\n\n\n Assignments by Project - Projektauswahl\n \n\n\n \n\n

Assignments by Project - All Timeslots

\n\n \n\n

\n\n

Loading assignments...

\n\n \n\n\n",[214],"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",[221],"99e5796c-3fc2-11f1-a196-42b51c65c3df","PARENT_PROJECT_SUBMISSIONS_SPEC.md","99e57a48-3fc2-11f1-a196-42b51c65c3df",159,["D",1777024046324],"# Parent Project Submissions Spec\n\n## Goal\n\nAllow parents to propose Projektwoche projects directly, while keeping admin review lightweight and preserving the current student ranking and assignment workflow.\n\nThis spec does not require implementation yet. It defines the recommended product behavior, data to collect, and likely extension points in the current app.\n\n## Summary\n\nRecommended approach:\n\n- Parents submit project proposals into a separate proposal queue.\n- Admins review proposals with minimal work.\n- Only approved proposals become live projects visible to students.\n- Parents indicate availability, not exact placement.\n- Projects may span multiple consecutive timeslots.\n- A 2-timeslot project means the same children attend both timeslots in order.\n\n## Why Separate Proposals From Live Projects\n\nDo not write parent submissions directly into the live `project_options` table.\n\nReasons:\n\n- Parent submissions will often be incomplete or inconsistent.\n- Admins need to place projects into the timetable based on overall availability.\n- Some projects will need editing before they are suitable for student-facing display.\n- Multi-timeslot projects need scheduling logic before they can be shown to children.\n\nRecommended flow:\n\n1. Parent submits a proposal.\n2. Admin reviews it in a queue.\n3. Admin approves, edits, or rejects it.\n4. Approval creates the actual scheduled project records used by the existing app.\n\n## Parent Submission Data\n\n### Required\n\n- Parent name\n- Email address\n- Project title\n- Short public description\n- Maximum number of children\n- Age suitability\n- Availability across timeslots\n- Project duration in timeslots, default `1`\n\n### Strongly recommended\n\n- Phone number\n- Materials children should bring\n- Indoor / outdoor / either\n- Space or room requirements\n- Materials provided by parent\n- Optional co-facilitator / second adult\n- Notes for admins\n\n### Optional but useful later\n\n- Minimum number of children\n- Setup time needed\n- Cleanup time needed\n- Safety considerations\n- Accessibility notes\n- Whether the project can be repeated for another group\n\n## Proposed Parent-Facing Field Definitions\n\n- `parent_name`: text, required\n- `parent_email`: email, required\n- `parent_phone`: text, optional\n- `project_title`: text, required\n- `project_description`: long text, required\n- `co_facilitators`: text, optional\n- `max_participants`: integer, required\n- `min_participants`: integer, optional\n- `age_group`: enum or multi-select, required\n- `age_group_notes`: text, optional\n- `materials_to_bring`: long text, optional\n- `materials_provided`: long text, optional\n- `location_type`: enum `indoor | outdoor | either`, optional\n- `room_requirements`: long text, optional\n- `availability_timeslot_ids`: list of timeslot ids, required\n- `duration_slots`: integer, required, default `1`\n- `admin_notes_from_parent`: long text, optional\n\n## Age Groups\n\nKeep age groups open-ended.\n\nDo not hardcode only the current school-specific labels yet, because there may be one or two more groups later.\n\nRecommended approach:\n\n- store age groups in configurable data rather than fixed code enums\n- allow multiple selectable age-group options per project if needed\n- preserve an optional free-text note for exceptions or mixed groups\n\nCurrent examples:\n\n- `Delfine` = Klasse 1-3\n- `Drachen` = Klasse 4-6\n- `7/8` = Klasse 7-8\n- `9/10` = Klasse 9-10\n\nPractical consequence:\n\n- the parent form should read age-group options from configurable data\n- the admin review flow should tolerate changes to the age taxonomy without schema rewrites\n\nRecommended configurable structure:\n\n- `id`\n- `label`\n- `min_class`\n- `max_class`\n- `sort_order`\n- `active`\n\nInitial values:\n\n- `delfine`, `Delfine`, `1`, `3`\n- `drachen`, `Drachen`, `4`, `6`\n- `7-8`, `7/8`, `7`, `8`\n- `9-10`, `9/10`, `9`, `10`\n\n## Availability And Scheduling Rules\n\nParents should mark availability only.\n\nAdmins choose the actual scheduled start slot.\n\nRules:\n\n- A proposal can list multiple available timeslots.\n- `duration_slots = 1` means the project occupies one timeslot.\n- `duration_slots = 2` means the project occupies two consecutive timeslots.\n- A 2-slot project is one continuous project for the same children.\n- The second slot is not assigned independently.\n\nValidation rules for duration `2`:\n\n- Only allow approval into a start slot if the next consecutive timeslot exists.\n- Both timeslots must be included in the parent’s availability.\n- Once approved, both slots are reserved together.\n\n## Recommended Data Model\n\nAdd a proposal layer instead of overloading existing tables.\n\n### New table: `project_proposals`\n\nSuggested fields:\n\n- `id`\n- `parent_name`\n- `parent_email`\n- `parent_phone`\n- `project_title`\n- `project_description`\n- `co_facilitators`\n- `max_participants`\n- `min_participants`\n- `age_group`\n- `age_group_notes`\n- `materials_to_bring`\n- `materials_provided`\n- `location_type`\n- `room_requirements`\n- `duration_slots`\n- `admin_notes_from_parent`\n- `review_status`\n- `admin_review_notes`\n- `approved_start_timeslot_id`\n- `created_at`\n- `updated_at`\n\nRecommended `review_status` values:\n\n- `pending`\n- `approved`\n- `rejected`\n- `archived`\n\n### New table: `project_proposal_availability`\n\nSuggested fields:\n\n- `id`\n- `proposal_id`\n- `timeslot_id`\n\nThis normalizes availability rather than storing it as text or JSON.\n\n## How Approved Proposals Become Live Projects\n\nApproval should create scheduled projects in the existing live project model.\n\n### Short-term compatibility approach\n\nKeep the current student and assignment system mostly intact:\n\n- On approval of a 1-slot proposal, create one record in `project_options`.\n- On approval of a 2-slot proposal, create one record per occupied timeslot in `project_options`.\n- Mark those created records as linked to the same underlying proposal.\n\nFor that, add a lightweight linking field to `project_options`, for example:\n\n- `proposal_id`\n- `project_group_id` or `multi_slot_group_id`\n- `slot_index_within_group`\n\nThis keeps backward compatibility while giving the app enough information to treat multi-slot projects as one offering.\n\n### Longer-term cleaner approach\n\nIntroduce a first-class scheduled project entity:\n\n- one scheduled project\n- many occupied timeslots\n- many linked live choices\n\nThis is cleaner, but not required for a first iteration.\n\n## Student Ranking Behavior\n\nThis needs explicit product behavior before implementation.\n\nRecommended behavior:\n\n- A multi-slot project should be shown once, at its start slot.\n- The UI must clearly indicate that it occupies the next slot too.\n- If a child ranks that project, the following slot becomes unavailable for a separate project.\n\nImplication:\n\n- The current response model is timeslot-centric, so multi-slot choices will require either:\n - special submission logic in the student form, or\n - a translation layer that writes linked responses consistently\n\n## Assignment Behavior\n\nFor approved 2-slot projects:\n\n- Assignment must happen as one block.\n- A child assigned to the project in slot 1 is automatically assigned in slot 2.\n- Capacity applies to the full 2-slot block, not independently per slot.\n- Manual reassignment tools must preserve that linkage.\n\nThis is the part most likely to require actual changes to the current assignment UI and persistence.\n\n## Admin Review Workflow\n\nThe review UI should be intentionally small.\n\nRecommended actions on each proposal:\n\n- `Approve`\n- `Edit and approve`\n- `Reject`\n- `Archive`\n\nRecommended review screen columns:\n\n- Parent name\n- Project title\n- Duration\n- Max participants\n- Age group\n- Availability summary\n- Status\n- Quick actions\n\nRecommended approval flow:\n\n1. Admin opens proposal.\n2. Admin chooses a start timeslot from valid available options.\n3. Admin optionally edits display text.\n4. Admin approves.\n5. System creates live project records and links them back to the proposal.\n\n## Minimal Viable Version\n\nPhase 1 should aim for low complexity:\n\n- Parent proposal form\n- Proposal storage\n- Admin review queue\n- Approve into a scheduled live project\n- Support for duration `1` and `2`\n- No parent editing after submission\n- No draft saving\n- No automatic email notifications\n\n## Suggested Phased Rollout\n\n### Phase 1\n\n- Add proposal intake\n- Add review queue\n- Add approval into existing live project structure\n- Support duration `1` and `2`\n\n### Phase 2\n\n- Improve multi-slot student ranking UX\n- Make assignment UI block-aware for linked timeslots\n- Add validation around consecutive-slot occupancy\n\n### Phase 3\n\n- Parent edits after submission\n- Email confirmation\n- Duplicate/repeat project support\n- Better scheduling assistance for admins\n\n## Google Form Alternative\n\nGoogle Forms is viable for intake, but it is weaker as the long-term solution.\n\n### Pros\n\n- Very fast to set up\n- Familiar to parents\n- No implementation needed for the first collection round\n\n### Cons\n\n- Harder to validate structured constraints like multi-slot availability\n- Harder to keep age groups and timeslots in sync with the app\n- Review and approval become manual copy/paste work\n- Multi-slot project logic will live outside the app\n- Changes to available timeslots require form maintenance in two places\n\n### Recommendation\n\nIf you need something immediately for a one-off round, Google Forms is acceptable.\n\nIf you expect this to become part of the regular Projektwoche workflow, build it into the app. The admin review requirement and the need for multi-timeslot scheduling both argue strongly for native support.\n\n## Open Questions\n\n- What is the final label for the age group above `Drachen`?\n- Should one project ever be repeatable with different children in multiple separate slot blocks?\n- Do you want a hard cap on duration at `2`, or should the model allow more later?\n- Should parents see a confirmation summary after submission?\n- Should admin approval create live projects immediately, or leave them inactive by default until published?\n\n## Recommendation\n\nBuild this into the app rather than relying on Google Forms, unless you need a stopgap this week.\n\nThe simplest robust design is:\n\n- separate proposal queue\n- admin approval\n- parent availability, not parent slot choice\n- explicit duration field\n- linked handling for 2-slot projects\n",[229],"9a170fc2-3fc2-11f1-be7b-42b51c65c3df",["D",1777024046330],[27],"8fc44f44-3fc2-11f1-929e-42b51c65c3df","slides","8fc45016-3fc2-11f1-929e-42b51c65c3df",112,["D",1777024029328],"directory",[239],"1b2c0ca0-bfbe-11f0-88ff-42dde27851f2","backend","ae5aeae1-0739-4af5-abf0-3f5a4237bd65",6,["D",1762948366897],[246],"8fed452a-3fc2-11f1-9872-42b51c65c3df",".git","8fed45f2-3fc2-11f1-9872-42b51c65c3df",113,["D",1777024029597],[252],"de6f8f3e-bfc3-11f0-b56f-42dde27851f2",".claude","de6f902e-bfc3-11f0-b56f-42dde27851f2",46,["D",1762950841979],[258],"pulls","branches","forks",3,"envVars",{"_271":59,"_273":59},"connections",{"_271":59,"_272":59},"count","unfilledCount","emptyCount",{"_40":257,"_31":258,"_29":259,"_146":-5,"_38":39,"_37":260,"_148":55,"_35":725,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":726,"_26":727},{"_40":717,"_31":718,"_29":719,"_146":259,"_38":39,"_37":720,"_148":55,"_35":721,"_13":171,"_32":20,"_33":722,"_23":24,"_152":-5,"_340":723,"_26":724},{"_40":251,"_31":252,"_29":253,"_146":-5,"_38":39,"_37":254,"_148":55,"_35":714,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":715,"_26":716},{"_40":707,"_31":708,"_29":709,"_146":253,"_38":39,"_37":710,"_148":55,"_35":711,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":712,"_26":713},{"_40":700,"_31":701,"_29":702,"_146":253,"_38":39,"_37":703,"_148":55,"_35":704,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":705,"_26":706},{"_40":694,"_31":440,"_29":695,"_146":253,"_38":39,"_37":696,"_148":55,"_35":697,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":698,"_26":699},{"_40":689,"_31":682,"_29":684,"_146":253,"_38":39,"_37":690,"_148":55,"_35":691,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":692,"_26":693},{"_40":683,"_31":417,"_29":677,"_146":684,"_38":39,"_37":685,"_148":55,"_35":686,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":687,"_26":688},{"_40":675,"_31":419,"_29":676,"_146":677,"_38":39,"_37":678,"_148":55,"_35":679,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":680,"_26":681},{"_40":670,"_31":438,"_29":433,"_146":253,"_38":39,"_37":671,"_148":55,"_35":672,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":673,"_26":674},{"_40":663,"_31":664,"_29":665,"_146":433,"_38":39,"_37":666,"_148":55,"_35":667,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":668,"_26":669},{"_40":656,"_31":657,"_29":658,"_146":433,"_38":39,"_37":659,"_148":55,"_35":660,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":661,"_26":662},{"_40":649,"_31":650,"_29":651,"_146":433,"_38":39,"_37":652,"_148":55,"_35":653,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":654,"_26":655},{"_40":642,"_31":643,"_29":644,"_146":433,"_38":39,"_37":645,"_148":55,"_35":646,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":647,"_26":648},{"_40":635,"_31":636,"_29":637,"_146":433,"_38":39,"_37":638,"_148":55,"_35":639,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":640,"_26":641},{"_40":628,"_31":629,"_29":630,"_146":433,"_38":39,"_37":631,"_148":55,"_35":632,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":633,"_26":634},{"_40":621,"_31":622,"_29":623,"_146":433,"_38":39,"_37":624,"_148":55,"_35":625,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":626,"_26":627},{"_40":614,"_31":615,"_29":616,"_146":433,"_38":39,"_37":617,"_148":55,"_35":618,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":619,"_26":620},{"_40":607,"_31":608,"_29":609,"_146":433,"_38":39,"_37":610,"_148":55,"_35":611,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":612,"_26":613},{"_40":600,"_31":601,"_29":602,"_146":433,"_38":39,"_37":603,"_148":55,"_35":604,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":605,"_26":606},{"_40":593,"_31":594,"_29":595,"_146":433,"_38":39,"_37":596,"_148":55,"_35":597,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":598,"_26":599},{"_40":586,"_31":587,"_29":588,"_146":433,"_38":39,"_37":589,"_148":55,"_35":590,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":591,"_26":592},{"_40":579,"_31":580,"_29":581,"_146":433,"_38":39,"_37":582,"_148":55,"_35":583,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":584,"_26":585},{"_40":572,"_31":573,"_29":574,"_146":433,"_38":39,"_37":575,"_148":55,"_35":576,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":577,"_26":578},{"_40":565,"_31":566,"_29":567,"_146":433,"_38":39,"_37":568,"_148":55,"_35":569,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":570,"_26":571},{"_40":558,"_31":559,"_29":560,"_146":433,"_38":39,"_37":561,"_148":55,"_35":562,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":563,"_26":564},{"_40":551,"_31":552,"_29":553,"_146":433,"_38":39,"_37":554,"_148":55,"_35":555,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":556,"_26":557},{"_40":544,"_31":545,"_29":546,"_146":433,"_38":39,"_37":547,"_148":55,"_35":548,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":549,"_26":550},{"_40":537,"_31":538,"_29":539,"_146":433,"_38":39,"_37":540,"_148":55,"_35":541,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":542,"_26":543},{"_40":530,"_31":531,"_29":532,"_146":433,"_38":39,"_37":533,"_148":55,"_35":534,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":535,"_26":536},{"_40":523,"_31":524,"_29":525,"_146":433,"_38":39,"_37":526,"_148":55,"_35":527,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":528,"_26":529},{"_40":516,"_31":517,"_29":518,"_146":433,"_38":39,"_37":519,"_148":55,"_35":520,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":521,"_26":522},{"_40":509,"_31":510,"_29":511,"_146":433,"_38":39,"_37":512,"_148":55,"_35":513,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":514,"_26":515},{"_40":502,"_31":503,"_29":504,"_146":433,"_38":39,"_37":505,"_148":55,"_35":506,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":507,"_26":508},{"_40":495,"_31":496,"_29":497,"_146":433,"_38":39,"_37":498,"_148":55,"_35":499,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":500,"_26":501},{"_40":488,"_31":489,"_29":490,"_146":433,"_38":39,"_37":491,"_148":55,"_35":492,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":493,"_26":494},{"_40":481,"_31":482,"_29":483,"_146":433,"_38":39,"_37":484,"_148":55,"_35":485,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":486,"_26":487},{"_40":474,"_31":475,"_29":476,"_146":433,"_38":39,"_37":477,"_148":55,"_35":478,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":479,"_26":480},{"_40":467,"_31":468,"_29":469,"_146":433,"_38":39,"_37":470,"_148":55,"_35":471,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":472,"_26":473},{"_40":460,"_31":461,"_29":462,"_146":433,"_38":39,"_37":463,"_148":55,"_35":464,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":465,"_26":466},{"_40":453,"_31":454,"_29":455,"_146":433,"_38":39,"_37":456,"_148":55,"_35":457,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":458,"_26":459},{"_40":446,"_31":447,"_29":448,"_146":433,"_38":39,"_37":449,"_148":55,"_35":450,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":451,"_26":452},{"_40":439,"_31":440,"_29":441,"_146":433,"_38":39,"_37":442,"_148":55,"_35":443,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":444,"_26":445},{"_40":430,"_31":431,"_29":432,"_146":433,"_38":39,"_37":434,"_148":55,"_35":435,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":436,"_26":437},{"_40":425,"_31":417,"_29":412,"_146":253,"_38":39,"_37":426,"_148":55,"_35":427,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":428,"_26":429},{"_40":418,"_31":419,"_29":420,"_146":412,"_38":39,"_37":421,"_148":55,"_35":422,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":423,"_26":424},{"_40":409,"_31":410,"_29":411,"_146":412,"_38":39,"_37":413,"_148":55,"_35":414,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":415,"_26":416},{"_40":401,"_31":402,"_29":403,"_146":253,"_38":39,"_37":404,"_148":55,"_35":405,"_13":59,"_32":20,"_33":406,"_23":24,"_152":-5,"_340":407,"_26":408},{"_40":245,"_31":246,"_29":247,"_146":-5,"_38":39,"_37":248,"_148":55,"_35":398,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":399,"_26":400},{"_40":389,"_31":390,"_29":53,"_146":247,"_38":39,"_37":391,"_148":24,"_35":392,"_13":393,"_32":394,"_33":395,"_23":24,"_152":-5,"_340":396,"_26":397},{"_40":238,"_31":239,"_29":240,"_146":-5,"_38":39,"_37":241,"_148":55,"_35":386,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":387,"_26":388},{"_40":379,"_31":380,"_29":381,"_146":240,"_38":39,"_37":382,"_148":55,"_35":383,"_13":59,"_32":243,"_33":-5,"_23":24,"_152":-5,"_340":384,"_26":385},{"_40":235,"_31":27,"_29":30,"_146":-5,"_38":39,"_37":14,"_148":55,"_35":376,"_13":59,"_32":20,"_33":34,"_23":24,"_152":-5,"_340":377,"_26":378},{"_40":228,"_31":229,"_29":230,"_146":-5,"_38":39,"_37":231,"_148":55,"_35":373,"_13":59,"_32":20,"_33":233,"_23":24,"_152":-5,"_340":374,"_26":375},{"_40":220,"_31":221,"_29":222,"_146":-5,"_38":39,"_37":223,"_148":55,"_35":370,"_13":225,"_32":20,"_33":226,"_23":24,"_152":-5,"_340":371,"_26":372},{"_40":213,"_31":214,"_29":215,"_146":-5,"_38":39,"_37":216,"_148":55,"_35":367,"_13":202,"_32":20,"_33":218,"_23":24,"_152":-5,"_340":368,"_26":369},{"_40":205,"_31":206,"_29":207,"_146":-5,"_38":39,"_37":208,"_148":55,"_35":364,"_13":210,"_32":20,"_33":211,"_23":24,"_152":-5,"_340":365,"_26":366},{"_40":197,"_31":198,"_29":199,"_146":-5,"_38":39,"_37":200,"_148":55,"_35":361,"_13":202,"_32":20,"_33":203,"_23":24,"_152":-5,"_340":362,"_26":363},{"_40":190,"_31":191,"_29":192,"_146":-5,"_38":39,"_37":193,"_148":55,"_35":358,"_13":171,"_32":20,"_33":195,"_23":24,"_152":-5,"_340":359,"_26":360},{"_40":182,"_31":183,"_29":184,"_146":-5,"_38":39,"_37":185,"_148":24,"_35":355,"_13":187,"_32":20,"_33":188,"_23":24,"_152":-5,"_340":356,"_26":357},{"_40":175,"_31":176,"_29":177,"_146":-5,"_38":39,"_37":178,"_148":55,"_35":352,"_13":171,"_32":20,"_33":180,"_23":24,"_152":-5,"_340":353,"_26":354},{"_40":168,"_31":169,"_29":170,"_146":-5,"_38":39,"_37":171,"_148":55,"_35":349,"_13":59,"_32":173,"_33":105,"_23":24,"_152":-5,"_340":350,"_26":351},{"_40":161,"_31":162,"_29":163,"_146":-5,"_38":39,"_37":164,"_148":24,"_35":346,"_13":59,"_32":20,"_33":166,"_23":24,"_152":-5,"_340":347,"_26":348},{"_40":154,"_31":155,"_29":156,"_146":-5,"_38":39,"_37":157,"_148":55,"_35":343,"_13":59,"_32":20,"_33":159,"_23":24,"_152":-5,"_340":344,"_26":345},{"_40":143,"_31":144,"_29":145,"_146":-5,"_38":39,"_37":147,"_148":55,"_35":339,"_13":150,"_32":20,"_33":151,"_23":24,"_152":-5,"_340":341,"_26":342},["D",1764167523429],"children",[],[144],["D",1777024046328],[],[155],["D",1777024046337],[],[162],["D",1762947612985],[],[169],["D",1764163210269],[],[176],["D",1764167523416],[],[183],["D",1762978267182],[],[191],["D",1764250009627],[],[198],["D",1764168271553],[],[206],["D",1764267099289],[],[214],["D",1762951106108],[],[221],["D",1777024046324],[],[229],["D",1777024046330],[],[27],"9014ac8c-3fc2-11f1-8d92-42b51c65c3df","youtube-dfNdxB4Giyo","9014adae-3fc2-11f1-8d92-42b51c65c3df",114,["D",1777024029852],[],[239,380],["D",1777024029328],[325],[239],"ad1cc8a4-cad4-11f0-aafd-42dde27851f2","index.ts",99,["D",1764167523464],17,"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 offered_by 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 // Check if offered_by column exists, if not add it (migration)\n try {\n const { rows: columns } = await sqlite.execute(`PRAGMA table_info(${PROJECTS_TABLE})`);\n const hasOfferedBy = columns.some(col => col.name === 'offered_by');\n\n if (!hasOfferedBy) {\n console.log('Adding offered_by column to projects table...');\n await sqlite.execute(`ALTER TABLE ${PROJECTS_TABLE} ADD COLUMN offered_by TEXT`);\n console.log('offered_by column added successfully');\n }\n } catch (error) {\n console.error('Error checking/adding offered_by column:', error);\n }\n\n // Check if what_to_bring column exists, if not add it (migration)\n try {\n const { rows: columns } = await sqlite.execute(`PRAGMA table_info(${PROJECTS_TABLE})`);\n const hasWhatToBring = columns.some(col => col.name === 'what_to_bring');\n\n if (!hasWhatToBring) {\n console.log('Adding what_to_bring column to projects table...');\n await sqlite.execute(`ALTER TABLE ${PROJECTS_TABLE} ADD COLUMN what_to_bring TEXT`);\n console.log('what_to_bring column added successfully');\n }\n } catch (error) {\n console.error('Error checking/adding what_to_bring column:', error);\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 offeredBy: p.offered_by,\n maxParticipants: p.max_participants,\n whatToBring: p.what_to_bring\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, offered_by, max_participants, what_to_bring) VALUES (?, ?, ?, ?, ?, ?)`,\n [data.target_timeslot_id, sourceProject.project_name, sourceProject.project_description, sourceProject.offered_by, sourceProject.max_participants, sourceProject.what_to_bring]\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 assignments individual view\napp.get('/admin/assignments/individual', async (c) => {\n const individualHtml = await readFile(\"/admin-assignments-individual.html\", import.meta.url);\n return c.html(individualHtml);\n});\n\n// Admin assignments by project view\napp.get('/admin/assignments/by-project', async (c) => {\n const byProjectHtml = await readFile(\"/admin-assignments-by-project.html\", import.meta.url);\n return c.html(byProjectHtml);\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, offered_by, max_participants, what_to_bring) VALUES (?, ?, ?, ?, ?, ?)`,\n [data.timeslot_id, data.project_name, data.project_description, data.offered_by, data.max_participants, data.what_to_bring]\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 = ?, offered_by = ?, max_participants = ?, what_to_bring = ? WHERE id = ?`,\n [data.timeslot_id, data.project_name, data.project_description, data.offered_by, data.max_participants, data.what_to_bring, 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 // Also delete all assignments for this student\n await sqlite.execute(`DELETE FROM ${ASSIGNMENTS_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.post('/api/admin/assignments/:timeslotId/assign', async (c) => {\n const timeslotId = parseInt(c.req.param('timeslotId'));\n const { studentName, projectName, preferenceRank } = await c.req.json();\n\n try {\n // Delete existing assignment for this student in this timeslot\n await sqlite.execute(\n `DELETE FROM ${ASSIGNMENTS_TABLE} WHERE timeslot_id = ? AND student_name = ?`,\n [timeslotId, studentName]\n );\n\n // Insert new assignment\n await sqlite.execute(\n `INSERT INTO ${ASSIGNMENTS_TABLE} (timeslot_id, student_name, project_name, preference_rank)\n VALUES (?, ?, ?, ?)`,\n [timeslotId, studentName, projectName, preferenceRank]\n );\n\n return c.json({ success: true, message: 'Assignment updated successfully' });\n } catch (error) {\n console.error('Error updating assignment:', 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",[],[246,390],["D",1762948366897],[323],[246],"99f1aba6-3fc2-11f1-9f28-42b51c65c3df","config","99f1ac64-3fc2-11f1-9f28-42b51c65c3df",161,["D",1777024046325],"[core]\n\trepositoryformatversion = 0\n\tfilemode = true\n\tbare = false\n\tlogallrefupdates = true\n\tignorecase = true\n\tprecomposeunicode = true\n",[],[252,402],"999d8080-3fc2-11f1-a196-42b51c65c3df","tags","999d8152-3fc2-11f1-a196-42b51c65c3df","90ee7dea-3fc2-11f1-8deb-42b51c65c3df",157,["D",1777024045852],[],[252,417,410],"refs","997c9cf8-3fc2-11f1-8deb-42b51c65c3df","heads","997c9dc0-3fc2-11f1-8deb-42b51c65c3df",156,["D",1777024045636],[],[252,417,419],"90ee7ba6-3fc2-11f1-8deb-42b51c65c3df",120,["D",1777024031284],[319,320],[252,417],"94fc6db6-3fc2-11f1-a0b4-42b51c65c3df","pack","94fc6e7e-3fc2-11f1-a0b4-42b51c65c3df","90594e6e-3fc2-11f1-b05f-42b51c65c3df",133,["D",1777024038089],[],[252,438,431],"objects","9702793e-3fc2-11f1-ab02-42b51c65c3df","info","970279d4-3fc2-11f1-ab02-42b51c65c3df",142,["D",1777024041485],[],[252,438,440],"98428be0-3fc2-11f1-929e-42b51c65c3df","ff","98428c8a-3fc2-11f1-929e-42b51c65c3df",150,["D",1777024043578],[],[252,438,447],"97f2450e-3fc2-11f1-a912-42b51c65c3df","f7","97f245ea-3fc2-11f1-a912-42b51c65c3df",148,["D",1777024043056],[],[252,438,454],"9821b956-3fc2-11f1-9459-42b51c65c3df","e8","9821ba00-3fc2-11f1-9459-42b51c65c3df",149,["D",1777024043362],[],[252,438,461],"97d3d8f8-3fc2-11f1-9a32-42b51c65c3df","e6","97d3d9b6-3fc2-11f1-9a32-42b51c65c3df",147,["D",1777024042853],[],[252,438,468],"940ed8bc-3fc2-11f1-bd71-42b51c65c3df","d7","940ed970-3fc2-11f1-bd71-42b51c65c3df",128,["D",1777024036532],[],[252,438,475],"97af20da-3fc2-11f1-9f28-42b51c65c3df","d3","97af21ac-3fc2-11f1-9f28-42b51c65c3df",146,["D",1777024042576],[],[252,438,482],"947390ea-3fc2-11f1-ad85-42b51c65c3df","ab","9473918a-3fc2-11f1-ad85-42b51c65c3df",130,["D",1777024037188],[],[252,438,489],"9438eb70-3fc2-11f1-8d92-42b51c65c3df","a2","9438ed78-3fc2-11f1-8d92-42b51c65c3df",129,["D",1777024036776],[],[252,438,496],"913e389e-3fc2-11f1-9f28-42b51c65c3df","92","913e3970-3fc2-11f1-9f28-42b51c65c3df",122,["D",1777024031805],[],[252,438,503],"969e0364-3fc2-11f1-a990-42b51c65c3df","8f","969e040e-3fc2-11f1-a990-42b51c65c3df",139,["D",1777024040826],[],[252,438,510],"99404ff0-3fc2-11f1-9c79-42b51c65c3df","8e","994050a4-3fc2-11f1-9c79-42b51c65c3df",154,["D",1777024045245],[],[252,438,517],"957b3330-3fc2-11f1-be7b-42b51c65c3df","87","957b33da-3fc2-11f1-be7b-42b51c65c3df",137,["D",1777024038922],[],[252,438,524],"986dace4-3fc2-11f1-879b-42b51c65c3df","83","986dadb6-3fc2-11f1-879b-42b51c65c3df",151,["D",1777024043864],[],[252,438,531],"96e42a9c-3fc2-11f1-ab02-42b51c65c3df","81","96e42b64-3fc2-11f1-ab02-42b51c65c3df",141,["D",1777024041286],[],[252,438,538],"93790940-3fc2-11f1-b889-42b51c65c3df","6a","937909fe-3fc2-11f1-b889-42b51c65c3df",124,["D",1777024035548],[],[252,438,545],"9355fc70-3fc2-11f1-a845-42b51c65c3df","68","9355fd4c-3fc2-11f1-a845-42b51c65c3df",123,["D",1777024035320],[],[252,438,552],"93c1ee30-3fc2-11f1-a0b4-42b51c65c3df","67","93c1eeda-3fc2-11f1-a0b4-42b51c65c3df",126,["D",1777024036008],[],[252,438,559],"9786c522-3fc2-11f1-b05f-42b51c65c3df","63","9786c5e0-3fc2-11f1-b05f-42b51c65c3df",145,["D",1777024042351],[],[252,438,566],"9110e0ce-3fc2-11f1-8deb-42b51c65c3df","61","9110e196-3fc2-11f1-8deb-42b51c65c3df",121,["D",1777024031509],[],[252,438,573],"97690104-3fc2-11f1-a1a7-42b51c65c3df","55","976901cc-3fc2-11f1-a1a7-42b51c65c3df",144,["D",1777024042154],[],[252,438,580],"972edd80-3fc2-11f1-9c79-42b51c65c3df","53","972ede48-3fc2-11f1-9c79-42b51c65c3df",143,["D",1777024041772],[],[252,438,587],"94b96f84-3fc2-11f1-b3b7-42b51c65c3df","4e","94b9702e-3fc2-11f1-b3b7-42b51c65c3df",131,["D",1777024037651],[],[252,438,594],"94da8db8-3fc2-11f1-bab5-42b51c65c3df","4b","94da8e8a-3fc2-11f1-bab5-42b51c65c3df",132,["D",1777024037855],[],[252,438,601],"98d1a1cc-3fc2-11f1-9872-42b51c65c3df","49","98d1a28a-3fc2-11f1-9872-42b51c65c3df",152,["D",1777024044510],[],[252,438,608],"9920fede-3fc2-11f1-a196-42b51c65c3df","47","9920ff74-3fc2-11f1-a196-42b51c65c3df",153,["D",1777024045036],[],[252,438,615],"955d2a52-3fc2-11f1-bab5-42b51c65c3df","45","955d2b4c-3fc2-11f1-bab5-42b51c65c3df",136,["D",1777024038716],[],[252,438,622],"95382d24-3fc2-11f1-bc98-42b51c65c3df","42","95382dba-3fc2-11f1-bc98-42b51c65c3df",135,["D",1777024038480],[],[252,438,629],"9399685c-3fc2-11f1-9872-42b51c65c3df","3c","93996910-3fc2-11f1-9872-42b51c65c3df",125,["D",1777024035758],[],[252,438,636],"951b2e54-3fc2-11f1-b3b7-42b51c65c3df","29","951b2fb2-3fc2-11f1-b3b7-42b51c65c3df",134,["D",1777024038292],[],[252,438,643],"96bfecae-3fc2-11f1-a990-42b51c65c3df","21","96bfed62-3fc2-11f1-a990-42b51c65c3df",140,["D",1777024041046],[],[252,438,650],"96111a9e-3fc2-11f1-a0b4-42b51c65c3df","1a","96111b3e-3fc2-11f1-a0b4-42b51c65c3df",138,["D",1777024039839],[],[252,438,657],"93e19de8-3fc2-11f1-b05f-42b51c65c3df","02","93e19eba-3fc2-11f1-b05f-42b51c65c3df",127,["D",1777024036235],[],[252,438,664],"90594da6-3fc2-11f1-b05f-42b51c65c3df",116,["D",1777024030309],[284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317],[252,438],"99bbeeda-3fc2-11f1-b3b7-42b51c65c3df","99bbefac-3fc2-11f1-b3b7-42b51c65c3df","995e61b6-3fc2-11f1-bab5-42b51c65c3df",158,["D",1777024046057],[],[252,682,417,419],"logs","995e60f8-3fc2-11f1-bab5-42b51c65c3df","90a2783c-3fc2-11f1-8deb-42b51c65c3df",155,["D",1777024045442],[282],[252,682,417],"90a2779c-3fc2-11f1-8deb-42b51c65c3df",118,["D",1777024030786],[281],[252,682],"9079ba78-3fc2-11f1-b889-42b51c65c3df","9079bb54-3fc2-11f1-b889-42b51c65c3df",117,["D",1777024030516],[],[252,440],"90c55640-3fc2-11f1-8deb-42b51c65c3df","hooks","90c55758-3fc2-11f1-8deb-42b51c65c3df",119,["D",1777024031014],[],[252,701],"90385dd0-3fc2-11f1-8d93-42b51c65c3df","co.gitup.mac","90385e66-3fc2-11f1-8d93-42b51c65c3df",115,["D",1777024030072],[],[252,708],["D",1777024029597],[277,278,279,280,283,318,321],[252],"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",[],[258,718],["D",1762950841979],[275],[258],["D",1762947612971],["D",1789529498250],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":51,"_100":101,"_102":24},{"_13":85,"_31":86,"_40":39,"_87":41,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":42,"_94":95},"ctx",{"_78":-5,"_123":766,"_767":768,"_769":770,"_771":24,"_772":24,"_773":24,"_774":55,"_775":-5,"_776":-7,"_777":-7,"_778":59,"_779":24,"_780":24,"_781":-5,"_782":24,"_783":24,"_784":24,"_785":-5},"ENV",{"_737":738,"_739":740,"_741":86,"_742":743,"_744":745,"_746":747,"_748":749,"_750":751,"_752":753,"_754":755,"_756":757,"_758":759,"_760":761,"_762":763,"_764":765},"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"]

Projektauswahl

Elternteil

Projektidee

Altersgruppen

Rahmen & Material

Verfügbarkeit

Danke, dein Vorschlag ist eingegangen.

Admin Panel - Projektauswahl

Student Responses

Project Assignments

View Assignments

Timeslots

Add New Timeslot

Projects

Add New Project

Copy Project

Student Responses

Project Assignments

Optimization Settings

Assignment Statistics

Individual Assignments - All Timeslots

Assignments by Project

Diff · v163