Projektauswahl

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

\n\n \n

\n\n \n \n","label",[141],"59cdf628-bfbc-11f0-aada-42dde27851f2","main.ts","59cdf6d2-bfbc-11f0-aada-42dde27851f2",1,["D",1762947612985],"script",[152],"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",[159],"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",[166],"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",[174],"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",[181],"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",[189],"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",[197],"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",[204],"8fc44f44-3fc2-11f1-929e-42b51c65c3df","slides","8fc45016-3fc2-11f1-929e-42b51c65c3df",112,["D",1777024029328],[212],"1b2c0ca0-bfbe-11f0-88ff-42dde27851f2","backend","ae5aeae1-0739-4af5-abf0-3f5a4237bd65",6,["D",1762948366897],[218],"8fed452a-3fc2-11f1-9872-42b51c65c3df",".git","8fed45f2-3fc2-11f1-9872-42b51c65c3df",113,["D",1777024029597],[224],"de6f8f3e-bfc3-11f0-b56f-42dde27851f2",".claude","de6f902e-bfc3-11f0-b56f-42dde27851f2",46,["D",1762950841979],[230],"pulls","branches","forks",3,"envVars",{"_243":60,"_245":60},"connections",{"_243":60,"_244":60},"count","unfilledCount","emptyCount",{"_41":229,"_31":230,"_29":231,"_143":-5,"_39":40,"_38":232,"_145":56,"_36":591,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":592,"_26":593},{"_41":583,"_31":584,"_29":585,"_143":231,"_39":40,"_38":586,"_145":56,"_36":587,"_13":154,"_33":20,"_35":588,"_23":24,"_149":-5,"_297":589,"_26":590},{"_41":223,"_31":224,"_29":225,"_143":-5,"_39":40,"_38":226,"_145":56,"_36":580,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":581,"_26":582},{"_41":573,"_31":574,"_29":575,"_143":225,"_39":40,"_38":576,"_145":56,"_36":577,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":578,"_26":579},{"_41":566,"_31":567,"_29":568,"_143":225,"_39":40,"_38":569,"_145":56,"_36":570,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":571,"_26":572},{"_41":560,"_31":363,"_29":561,"_143":225,"_39":40,"_38":562,"_145":56,"_36":563,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":564,"_26":565},{"_41":553,"_31":554,"_29":555,"_143":225,"_39":40,"_38":556,"_145":56,"_36":557,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":558,"_26":559},{"_41":548,"_31":361,"_29":356,"_143":225,"_39":40,"_38":549,"_145":56,"_36":550,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":551,"_26":552},{"_41":541,"_31":542,"_29":543,"_143":356,"_39":40,"_38":544,"_145":56,"_36":545,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":546,"_26":547},{"_41":534,"_31":535,"_29":536,"_143":356,"_39":40,"_38":537,"_145":56,"_36":538,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":539,"_26":540},{"_41":527,"_31":528,"_29":529,"_143":356,"_39":40,"_38":530,"_145":56,"_36":531,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":532,"_26":533},{"_41":520,"_31":521,"_29":522,"_143":356,"_39":40,"_38":523,"_145":56,"_36":524,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":525,"_26":526},{"_41":513,"_31":514,"_29":515,"_143":356,"_39":40,"_38":516,"_145":56,"_36":517,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":518,"_26":519},{"_41":506,"_31":507,"_29":508,"_143":356,"_39":40,"_38":509,"_145":56,"_36":510,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":511,"_26":512},{"_41":499,"_31":500,"_29":501,"_143":356,"_39":40,"_38":502,"_145":56,"_36":503,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":504,"_26":505},{"_41":492,"_31":493,"_29":494,"_143":356,"_39":40,"_38":495,"_145":56,"_36":496,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":497,"_26":498},{"_41":485,"_31":486,"_29":487,"_143":356,"_39":40,"_38":488,"_145":56,"_36":489,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":490,"_26":491},{"_41":478,"_31":479,"_29":480,"_143":356,"_39":40,"_38":481,"_145":56,"_36":482,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":483,"_26":484},{"_41":471,"_31":472,"_29":473,"_143":356,"_39":40,"_38":474,"_145":56,"_36":475,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":476,"_26":477},{"_41":464,"_31":465,"_29":466,"_143":356,"_39":40,"_38":467,"_145":56,"_36":468,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":469,"_26":470},{"_41":457,"_31":458,"_29":459,"_143":356,"_39":40,"_38":460,"_145":56,"_36":461,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":462,"_26":463},{"_41":450,"_31":451,"_29":452,"_143":356,"_39":40,"_38":453,"_145":56,"_36":454,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":455,"_26":456},{"_41":443,"_31":444,"_29":445,"_143":356,"_39":40,"_38":446,"_145":56,"_36":447,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":448,"_26":449},{"_41":436,"_31":437,"_29":438,"_143":356,"_39":40,"_38":439,"_145":56,"_36":440,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":441,"_26":442},{"_41":429,"_31":430,"_29":431,"_143":356,"_39":40,"_38":432,"_145":56,"_36":433,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":434,"_26":435},{"_41":422,"_31":423,"_29":424,"_143":356,"_39":40,"_38":425,"_145":56,"_36":426,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":427,"_26":428},{"_41":415,"_31":416,"_29":417,"_143":356,"_39":40,"_38":418,"_145":56,"_36":419,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":420,"_26":421},{"_41":408,"_31":409,"_29":410,"_143":356,"_39":40,"_38":411,"_145":56,"_36":412,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":413,"_26":414},{"_41":401,"_31":402,"_29":403,"_143":356,"_39":40,"_38":404,"_145":56,"_36":405,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":406,"_26":407},{"_41":394,"_31":395,"_29":396,"_143":356,"_39":40,"_38":397,"_145":56,"_36":398,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":399,"_26":400},{"_41":387,"_31":388,"_29":389,"_143":356,"_39":40,"_38":390,"_145":56,"_36":391,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":392,"_26":393},{"_41":380,"_31":381,"_29":382,"_143":356,"_39":40,"_38":383,"_145":56,"_36":384,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":385,"_26":386},{"_41":373,"_31":374,"_29":375,"_143":356,"_39":40,"_38":376,"_145":56,"_36":377,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":378,"_26":379},{"_41":369,"_31":32,"_29":30,"_143":356,"_39":40,"_38":14,"_145":56,"_36":370,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":371,"_26":372},{"_41":362,"_31":363,"_29":364,"_143":356,"_39":40,"_38":365,"_145":56,"_36":366,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":367,"_26":368},{"_41":353,"_31":354,"_29":355,"_143":356,"_39":40,"_38":357,"_145":56,"_36":358,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":359,"_26":360},{"_41":346,"_31":347,"_29":348,"_143":225,"_39":40,"_38":349,"_145":56,"_36":350,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":351,"_26":352},{"_41":217,"_31":218,"_29":219,"_143":-5,"_39":40,"_38":220,"_145":56,"_36":343,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":344,"_26":345},{"_41":334,"_31":335,"_29":54,"_143":219,"_39":40,"_38":336,"_145":24,"_36":337,"_13":338,"_33":339,"_35":340,"_23":24,"_149":-5,"_297":341,"_26":342},{"_41":211,"_31":212,"_29":213,"_143":-5,"_39":40,"_38":214,"_145":56,"_36":331,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":332,"_26":333},{"_41":324,"_31":325,"_29":326,"_143":213,"_39":40,"_38":327,"_145":56,"_36":328,"_13":60,"_33":34,"_35":-5,"_23":24,"_149":-5,"_297":329,"_26":330},{"_41":203,"_31":204,"_29":205,"_143":-5,"_39":40,"_38":206,"_145":56,"_36":321,"_13":208,"_33":20,"_35":209,"_23":24,"_149":-5,"_297":322,"_26":323},{"_41":196,"_31":197,"_29":198,"_143":-5,"_39":40,"_38":199,"_145":56,"_36":318,"_13":185,"_33":20,"_35":201,"_23":24,"_149":-5,"_297":319,"_26":320},{"_41":188,"_31":189,"_29":190,"_143":-5,"_39":40,"_38":191,"_145":56,"_36":315,"_13":193,"_33":20,"_35":194,"_23":24,"_149":-5,"_297":316,"_26":317},{"_41":180,"_31":181,"_29":182,"_143":-5,"_39":40,"_38":183,"_145":56,"_36":312,"_13":185,"_33":20,"_35":186,"_23":24,"_149":-5,"_297":313,"_26":314},{"_41":173,"_31":174,"_29":175,"_143":-5,"_39":40,"_38":176,"_145":56,"_36":309,"_13":154,"_33":20,"_35":178,"_23":24,"_149":-5,"_297":310,"_26":311},{"_41":165,"_31":166,"_29":167,"_143":-5,"_39":40,"_38":168,"_145":24,"_36":306,"_13":170,"_33":20,"_35":171,"_23":24,"_149":-5,"_297":307,"_26":308},{"_41":158,"_31":159,"_29":160,"_143":-5,"_39":40,"_38":161,"_145":56,"_36":303,"_13":154,"_33":20,"_35":163,"_23":24,"_149":-5,"_297":304,"_26":305},{"_41":151,"_31":152,"_29":153,"_143":-5,"_39":40,"_38":154,"_145":56,"_36":300,"_13":60,"_33":156,"_35":106,"_23":24,"_149":-5,"_297":301,"_26":302},{"_41":140,"_31":141,"_29":142,"_143":-5,"_39":40,"_38":144,"_145":56,"_36":296,"_13":147,"_33":20,"_35":148,"_23":24,"_149":-5,"_297":298,"_26":299},["D",1764167523429],"children",[],[141],["D",1762947612985],[],[152],["D",1764163210269],[],[159],["D",1764167523416],[],[166],["D",1762978267182],[],[174],["D",1764250009627],[],[181],["D",1764168271553],[],[189],["D",1764267099289],[],[197],["D",1762951106108],[],[204],"9014ac8c-3fc2-11f1-8d92-42b51c65c3df","youtube-dfNdxB4Giyo","9014adae-3fc2-11f1-8d92-42b51c65c3df",114,["D",1777024029852],[],[212,325],["D",1777024029328],[286],[212],"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",[],[218,335],["D",1762948366897],[284],[218],"90ee7ba6-3fc2-11f1-8deb-42b51c65c3df","refs","90ee7dea-3fc2-11f1-8deb-42b51c65c3df",120,["D",1777024031284],[],[224,347],"94fc6db6-3fc2-11f1-a0b4-42b51c65c3df","pack","94fc6e7e-3fc2-11f1-a0b4-42b51c65c3df","90594e6e-3fc2-11f1-b05f-42b51c65c3df",133,["D",1777024038089],[],[224,361,354],"objects","9702793e-3fc2-11f1-ab02-42b51c65c3df","info","970279d4-3fc2-11f1-ab02-42b51c65c3df",142,["D",1777024041485],[],[224,361,363],"97f2450e-3fc2-11f1-a912-42b51c65c3df",["D",1777024043056],[],[224,361,32],"97d3d8f8-3fc2-11f1-9a32-42b51c65c3df","e6","97d3d9b6-3fc2-11f1-9a32-42b51c65c3df",147,["D",1777024042853],[],[224,361,374],"940ed8bc-3fc2-11f1-bd71-42b51c65c3df","d7","940ed970-3fc2-11f1-bd71-42b51c65c3df",128,["D",1777024036532],[],[224,361,381],"97af20da-3fc2-11f1-9f28-42b51c65c3df","d3","97af21ac-3fc2-11f1-9f28-42b51c65c3df",146,["D",1777024042576],[],[224,361,388],"947390ea-3fc2-11f1-ad85-42b51c65c3df","ab","9473918a-3fc2-11f1-ad85-42b51c65c3df",130,["D",1777024037188],[],[224,361,395],"9438eb70-3fc2-11f1-8d92-42b51c65c3df","a2","9438ed78-3fc2-11f1-8d92-42b51c65c3df",129,["D",1777024036776],[],[224,361,402],"913e389e-3fc2-11f1-9f28-42b51c65c3df","92","913e3970-3fc2-11f1-9f28-42b51c65c3df",122,["D",1777024031805],[],[224,361,409],"969e0364-3fc2-11f1-a990-42b51c65c3df","8f","969e040e-3fc2-11f1-a990-42b51c65c3df",139,["D",1777024040826],[],[224,361,416],"957b3330-3fc2-11f1-be7b-42b51c65c3df","87","957b33da-3fc2-11f1-be7b-42b51c65c3df",137,["D",1777024038922],[],[224,361,423],"96e42a9c-3fc2-11f1-ab02-42b51c65c3df","81","96e42b64-3fc2-11f1-ab02-42b51c65c3df",141,["D",1777024041286],[],[224,361,430],"93790940-3fc2-11f1-b889-42b51c65c3df","6a","937909fe-3fc2-11f1-b889-42b51c65c3df",124,["D",1777024035548],[],[224,361,437],"9355fc70-3fc2-11f1-a845-42b51c65c3df","68","9355fd4c-3fc2-11f1-a845-42b51c65c3df",123,["D",1777024035320],[],[224,361,444],"93c1ee30-3fc2-11f1-a0b4-42b51c65c3df","67","93c1eeda-3fc2-11f1-a0b4-42b51c65c3df",126,["D",1777024036008],[],[224,361,451],"9786c522-3fc2-11f1-b05f-42b51c65c3df","63","9786c5e0-3fc2-11f1-b05f-42b51c65c3df",145,["D",1777024042351],[],[224,361,458],"9110e0ce-3fc2-11f1-8deb-42b51c65c3df","61","9110e196-3fc2-11f1-8deb-42b51c65c3df",121,["D",1777024031509],[],[224,361,465],"97690104-3fc2-11f1-a1a7-42b51c65c3df","55","976901cc-3fc2-11f1-a1a7-42b51c65c3df",144,["D",1777024042154],[],[224,361,472],"972edd80-3fc2-11f1-9c79-42b51c65c3df","53","972ede48-3fc2-11f1-9c79-42b51c65c3df",143,["D",1777024041772],[],[224,361,479],"94b96f84-3fc2-11f1-b3b7-42b51c65c3df","4e","94b9702e-3fc2-11f1-b3b7-42b51c65c3df",131,["D",1777024037651],[],[224,361,486],"94da8db8-3fc2-11f1-bab5-42b51c65c3df","4b","94da8e8a-3fc2-11f1-bab5-42b51c65c3df",132,["D",1777024037855],[],[224,361,493],"955d2a52-3fc2-11f1-bab5-42b51c65c3df","45","955d2b4c-3fc2-11f1-bab5-42b51c65c3df",136,["D",1777024038716],[],[224,361,500],"95382d24-3fc2-11f1-bc98-42b51c65c3df","42","95382dba-3fc2-11f1-bc98-42b51c65c3df",135,["D",1777024038480],[],[224,361,507],"9399685c-3fc2-11f1-9872-42b51c65c3df","3c","93996910-3fc2-11f1-9872-42b51c65c3df",125,["D",1777024035758],[],[224,361,514],"951b2e54-3fc2-11f1-b3b7-42b51c65c3df","29","951b2fb2-3fc2-11f1-b3b7-42b51c65c3df",134,["D",1777024038292],[],[224,361,521],"96bfecae-3fc2-11f1-a990-42b51c65c3df","21","96bfed62-3fc2-11f1-a990-42b51c65c3df",140,["D",1777024041046],[],[224,361,528],"96111a9e-3fc2-11f1-a0b4-42b51c65c3df","1a","96111b3e-3fc2-11f1-a0b4-42b51c65c3df",138,["D",1777024039839],[],[224,361,535],"93e19de8-3fc2-11f1-b05f-42b51c65c3df","02","93e19eba-3fc2-11f1-b05f-42b51c65c3df",127,["D",1777024036235],[],[224,361,542],"90594da6-3fc2-11f1-b05f-42b51c65c3df",116,["D",1777024030309],[254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281],[224,361],"90a2779c-3fc2-11f1-8deb-42b51c65c3df","logs","90a2783c-3fc2-11f1-8deb-42b51c65c3df",118,["D",1777024030786],[],[224,554],"9079ba78-3fc2-11f1-b889-42b51c65c3df","9079bb54-3fc2-11f1-b889-42b51c65c3df",117,["D",1777024030516],[],[224,363],"90c55640-3fc2-11f1-8deb-42b51c65c3df","hooks","90c55758-3fc2-11f1-8deb-42b51c65c3df",119,["D",1777024031014],[],[224,567],"90385dd0-3fc2-11f1-8d93-42b51c65c3df","co.gitup.mac","90385e66-3fc2-11f1-8d93-42b51c65c3df",115,["D",1777024030072],[],[224,574],["D",1777024029597],[249,250,251,252,253,282],[224],"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",[],[230,584],["D",1762950841979],[247],[230],["D",1762947612971],["D",1789529498250],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":52,"_101":102,"_103":24},{"_13":86,"_31":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"ctx",{"_79":-5,"_124":632,"_633":634,"_635":636,"_637":24,"_638":24,"_639":24,"_640":56,"_641":-5,"_642":-7,"_643":-7,"_644":60,"_645":24,"_646":24,"_647":-5,"_648":24,"_649":24,"_650":24,"_651":-5},"ENV",{"_603":604,"_605":606,"_607":87,"_608":609,"_610":611,"_612":613,"_614":615,"_616":617,"_618":619,"_620":621,"_622":623,"_624":625,"_626":627,"_628":629,"_630":631},"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

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 · v148