[{"_1":2,"_172":-5,"_173":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e3ca0a77ab07ff2ce3097208ffd6aa0e378d3c47","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_169":170,"_171":-5},"handle","valeriewwong","name","designreview","path","backend/server.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","da32e45e-6738-11f0-bd63-0224a6c84d84","createdAt",["D",1753215432501],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","9f4e8f80-6717-11f0-afb9-ab0c248f84a1","pinnedFileId","pinPreview","screenshotVersion","likeCount","9f4eb690-6717-11f0-afb9-ab0c248f84a1","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMwRW1ZU2xlSzVZQ2J1RWJ3T29RbFhMM1ZXTSJ9","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",454,"da334e44-6738-11f0-bd63-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":135,"_156":157,"_103":158,"_134":159,"_160":161,"_162":163,"_164":20,"_165":166,"_97":167},"23345044-72dc-11f0-a6aa-0224a6c84d84","server.ts","fileId","63e9b1aa-677a-11f0-b768-0224a6c84d84","parentId","5e24014e-677a-11f0-a5a8-0224a6c84d84","branchId","branchVersion","latest",true,["D",1754495025736],129,"fileType","http","content","import { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { cors } from \"npm:hono/cors\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst app = new Hono();\n\n// Design review session constants - Updated to match actual schedule\nconst REVIEW_SESSIONS = {\n 1: {\n name: \"AX/Workflows/Insights/AI\",\n day: \"Tuesday\",\n time: \"2:30-4:30pm\",\n timezone: \"Europe/Paris\",\n pods: [\"AX\", \"Workflows\", \"Insights\", \"AI\"]\n },\n 2: {\n name: \"Search/Activation/Tel/Bots\",\n day: \"Tuesday\", \n time: \"10-11am\",\n timezone: \"America/Los_Angeles\",\n pods: [\"Search\", \"Activation\", \"Tel\", \"Bots\"]\n },\n 3: {\n name: \"CPX/DS/DP/Integrations\",\n day: \"Tuesday\",\n time: \"1-2pm\", \n timezone: \"America/Los_Angeles\",\n pods: [\"CPX\", \"DS\", \"DP\", \"Integrations\"]\n }\n} as const;\n\n// Initialize database and create tables\nasync function initDatabase() {\n // Create design_reviews table with UTC timestamps\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS design_reviews_v2 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n session_id INTEGER NOT NULL CHECK (session_id BETWEEN 1 AND 3),\n start_timestamp INTEGER NOT NULL,\n duration INTEGER NOT NULL CHECK (duration IN (15, 30)),\n status TEXT NOT NULL DEFAULT 'available' CHECK (status IN ('available', 'booked')),\n designer_name TEXT,\n topic TEXT,\n review_type TEXT CHECK (review_type IN ('shareout', 'brainstorm', 'system_feedback', 'ux_ui_feedback')),\n xfn_partners TEXT,\n booking_duration INTEGER DEFAULT 15,\n is_primary_slot BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n \n // Create waitlist table for slots\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS slot_waitlist_v2 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n slot_id INTEGER NOT NULL,\n designer_name TEXT NOT NULL,\n topic TEXT NOT NULL,\n review_type TEXT NOT NULL CHECK (review_type IN ('shareout', 'brainstorm', 'system_feedback', 'ux_ui_feedback')),\n xfn_partners TEXT,\n position INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (slot_id) REFERENCES design_reviews_v2 (id)\n )\n `);\n\n // Create index for faster queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_session_timestamp_status \n ON design_reviews_v2 (session_id, start_timestamp, status)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_waitlist_slot_position_v2\n ON slot_waitlist_v2 (slot_id, position)\n `);\n\n // Create unique index to prevent duplicate slots\n await sqlite.execute(`\n CREATE UNIQUE INDEX IF NOT EXISTS idx_unique_slot_v2\n ON design_reviews_v2 (session_id, start_timestamp)\n `);\n \n // Migrate data from old table if it exists and new table is empty\n await migrateToNewSchema();\n}\n\nasync function migrateToNewSchema() {\n try {\n // Check if old table exists and new table is empty\n const oldTableCheck = await sqlite.execute(`\n SELECT name FROM sqlite_master WHERE type='table' AND name='design_reviews'\n `);\n \n if (oldTableCheck.rows.length === 0) {\n console.log('No old table to migrate from');\n return;\n }\n \n const newTableCount = await sqlite.execute(`\n SELECT COUNT(*) as count FROM design_reviews_v2\n `);\n \n if ((newTableCount.rows[0].count as number) > 0) {\n console.log('New table already has data, skipping migration');\n return;\n }\n \n console.log('Migrating data from old schema to new schema...');\n \n // Migrate design_reviews data\n const oldSlots = await sqlite.execute(`\n SELECT * FROM design_reviews ORDER BY id\n `);\n \n for (const slot of oldSlots.rows) {\n // Convert date + start_time to UTC timestamp\n const dateStr = slot.date as string;\n const timeStr = slot.start_time as string;\n const [hours, minutes] = timeStr.split(':').map(Number);\n \n // Create a Date object and convert to timestamp\n const slotDate = new Date(`${dateStr}T${hours.toString().padStart(2, '0')}:${minutes.toString().padStart(2, '0')}:00.000Z`);\n const timestamp = slotDate.getTime();\n \n await sqlite.execute(`\n INSERT INTO design_reviews_v2 \n (session_id, start_timestamp, duration, status, designer_name, topic, review_type, \n xfn_partners, booking_duration, is_primary_slot, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n slot.session_id as number,\n timestamp,\n slot.duration as number,\n slot.status as string,\n slot.designer_name as string | null,\n slot.topic as string | null,\n slot.review_type as string | null,\n slot.xfn_partners as string | null,\n (slot.booking_duration as number) || 15,\n slot.is_primary_slot !== undefined ? (slot.is_primary_slot as number) : 1,\n slot.created_at as string,\n slot.updated_at as string\n ]);\n }\n \n // Migrate waitlist data if exists\n const waitlistCheck = await sqlite.execute(`\n SELECT name FROM sqlite_master WHERE type='table' AND name='slot_waitlist'\n `);\n \n if (waitlistCheck.rows.length > 0) {\n const oldWaitlist = await sqlite.execute(`\n SELECT * FROM slot_waitlist ORDER BY id\n `);\n \n for (const entry of oldWaitlist.rows) {\n // Map old slot_id to new slot_id\n const newSlot = await sqlite.execute(`\n SELECT id FROM design_reviews_v2 \n WHERE session_id = (SELECT session_id FROM design_reviews WHERE id = ?)\n AND start_timestamp = (\n SELECT strftime('%s', date || 'T' || start_time || ':00.000Z') * 1000\n FROM design_reviews WHERE id = ?\n )\n `, [entry.slot_id as number, entry.slot_id as number]);\n \n if (newSlot.rows.length > 0) {\n await sqlite.execute(`\n INSERT INTO slot_waitlist_v2 \n (slot_id, designer_name, topic, review_type, xfn_partners, position, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n newSlot.rows[0].id as number,\n entry.designer_name as string,\n entry.topic as string,\n entry.review_type as string,\n entry.xfn_partners as string | null,\n entry.position as number,\n entry.created_at as string\n ]);\n }\n }\n }\n \n console.log(`Migration completed: ${oldSlots.rows.length} slots migrated`);\n } catch (error) {\n console.error('Migration failed:', error);\n throw error;\n }\n}\n\n\n// Database functions\nasync function getAllSlots(sessionId: number, timestamp: number) {\n // Get all slots for a specific session on a specific day (matching the date part of the timestamp)\n const dayStart = new Date(timestamp);\n dayStart.setUTCHours(0, 0, 0, 0);\n const dayEnd = new Date(timestamp);\n dayEnd.setUTCHours(23, 59, 59, 999);\n \n return await sqlite.execute(\n `SELECT dr.*, \n (SELECT COUNT(*) FROM slot_waitlist_v2 sw WHERE sw.slot_id = dr.id) as waitlist_count\n FROM design_reviews_v2 dr\n WHERE dr.session_id = ? \n AND dr.start_timestamp >= ? \n AND dr.start_timestamp <= ?\n ORDER BY dr.start_timestamp`,\n [sessionId, dayStart.getTime(), dayEnd.getTime()]\n );\n}\n\nasync function bookSlot(\n id: number,\n designerName: string,\n topic: string,\n reviewType: string,\n xfnPartners?: string\n) {\n // First check if the slot is still available\n const availabilityCheck = await sqlite.execute(\n `SELECT id, session_id, start_timestamp, status, designer_name FROM design_reviews_v2 WHERE id = ?`,\n [id]\n );\n \n if (availabilityCheck.rows.length === 0) {\n return { \n success: false, \n error: \"SLOT_NOT_FOUND\",\n message: \"This slot could not be found.\"\n };\n }\n \n const slot = availabilityCheck.rows[0];\n if (slot.status === 'booked') {\n // Slot was just booked by someone else - find alternative\n const alternatives = await findAlternativeSlots(Number(slot.session_id), Number(slot.start_timestamp));\n return {\n success: false,\n error: \"SLOT_JUST_BOOKED\",\n message: \"This slot was just booked by another designer while you were filling out the form.\",\n currentBooker: slot.designer_name,\n alternatives\n };\n }\n \n // Attempt to book the slot atomically\n const result = await sqlite.execute(\n `UPDATE design_reviews_v2 \n SET status = 'booked', designer_name = ?, topic = ?, review_type = ?, \n xfn_partners = ?, booking_duration = 15, is_primary_slot = 1, updated_at = CURRENT_TIMESTAMP\n WHERE id = ? AND status = 'available'`,\n [designerName, topic, reviewType, xfnPartners || null, id]\n );\n \n // Check if the update was successful\n if (result.rowsAffected === 0) {\n // Race condition occurred - slot was booked between our check and update\n const conflictCheck = await sqlite.execute(\n `SELECT designer_name FROM design_reviews_v2 WHERE id = ? AND status = 'booked'`,\n [id]\n );\n \n const alternatives = await findAlternativeSlots(Number(slot.session_id), Number(slot.start_timestamp));\n return {\n success: false,\n error: \"CONCURRENT_BOOKING_CONFLICT\",\n message: \"Another designer booked this slot at the exact same time. We've found some alternatives for you.\",\n currentBooker: conflictCheck.rows[0]?.designer_name,\n alternatives\n };\n }\n \n return { \n success: true,\n message: \"Slot booked successfully!\"\n };\n}\n\n// Find alternative available slots in the same session\nasync function findAlternativeSlots(sessionId: number, originalTimestamp: number) {\n const alternatives = await sqlite.execute(\n `SELECT id, start_timestamp, duration \n FROM design_reviews_v2 \n WHERE session_id = ? AND status = 'available'\n ORDER BY ABS(start_timestamp - ?) ASC\n LIMIT 3`,\n [sessionId, originalTimestamp]\n );\n \n return alternatives.rows.map(slot => ({\n id: slot.id,\n timestamp: slot.start_timestamp,\n duration: slot.duration\n }));\n}\n\nasync function bookConsecutiveSlots(\n startSlotId: number,\n duration: number, // duration in minutes (15, 30, 45, 60)\n designerName: string,\n topic: string,\n reviewType: string,\n xfnPartners?: string\n) {\n const slotsNeeded = duration / 15; // how many 15-minute slots needed\n \n // Get the start slot details\n const startSlotResult = await sqlite.execute(\n `SELECT session_id, start_timestamp, status FROM design_reviews_v2 WHERE id = ?`,\n [startSlotId]\n );\n \n if (startSlotResult.rows.length === 0) {\n return { success: false, error: \"Start slot not found\" };\n }\n \n const startSlot = startSlotResult.rows[0];\n if (startSlot.status !== 'available') {\n return { success: false, error: \"Start slot is not available\" };\n }\n \n // Calculate the time slots needed\n const startTimestamp = startSlot.start_timestamp as number;\n const consecutiveSlotIds = [startSlotId];\n \n // Find consecutive slots\n for (let i = 1; i < slotsNeeded; i++) {\n const nextTimestamp = startTimestamp + (i * 15 * 60 * 1000); // Add 15 minutes in milliseconds\n \n const nextSlotResult = await sqlite.execute(\n `SELECT id, status FROM design_reviews_v2 \n WHERE session_id = ? AND start_timestamp = ? AND status = 'available'`,\n [startSlot.session_id as number, nextTimestamp]\n );\n \n if (nextSlotResult.rows.length === 0) {\n const nextTime = new Date(nextTimestamp).toISOString();\n return { \n success: false, \n error: `Consecutive slot at ${nextTime} is not available` \n };\n }\n \n consecutiveSlotIds.push(nextSlotResult.rows[0].id as number);\n }\n \n // Book all consecutive slots with proper duration tracking\n const bookingResults = [];\n for (let i = 0; i < consecutiveSlotIds.length; i++) {\n const slotId = consecutiveSlotIds[i];\n const isPrimary = i === 0; // First slot is primary\n \n // Book the individual slot with proper duration and primary slot marking\n const _result = await sqlite.execute(\n `UPDATE design_reviews_v2 \n SET status = 'booked', designer_name = ?, topic = ?, review_type = ?, \n xfn_partners = ?, booking_duration = ?, is_primary_slot = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ? AND status = 'available'`,\n [designerName, topic, reviewType, xfnPartners || null, duration, isPrimary ? 1 : 0, slotId]\n );\n \n // Check if the booking was successful\n const check = await sqlite.execute(\n `SELECT id FROM design_reviews_v2 WHERE id = ? AND status = 'booked'`,\n [slotId]\n );\n \n const success = check.rows.length > 0;\n bookingResults.push({ success });\n \n if (!success) {\n // If any booking fails, we need to rollback previous bookings\n for (let j = 0; j < i; j++) {\n await cancelBooking(consecutiveSlotIds[j]);\n }\n return { success: false, error: \"Failed to book all consecutive slots\" };\n }\n }\n \n return { \n success: true, \n bookedSlots: consecutiveSlotIds,\n message: `Successfully booked ${slotsNeeded} consecutive slots (${duration} minutes)`\n };\n}\n\nasync function getRelatedSlots(slotId: number) {\n try {\n console.log(`[DEBUG] Getting related slots for slot ID: ${slotId}`);\n \n // Get the base slot information\n const baseSlot = await sqlite.execute(\n `SELECT session_id, start_timestamp, designer_name, booking_duration FROM design_reviews_v2 \n WHERE id = ? AND status = 'booked'`,\n [slotId]\n );\n \n if (baseSlot.rows.length === 0) {\n console.log(`[DEBUG] No booked slot found for ID: ${slotId}`);\n return [];\n }\n \n const slot = baseSlot.rows[0];\n const bookingDuration = (slot.booking_duration as number) || 15;\n \n console.log(`[DEBUG] Slot ${slotId} has booking_duration: ${bookingDuration}`);\n \n if (bookingDuration <= 15) {\n // Single slot booking\n console.log(`[DEBUG] Single slot booking detected`);\n return [{\n id: slotId,\n start_timestamp: slot.start_timestamp as number,\n duration: 15\n }];\n }\n \n // Multi-slot booking - find all consecutive slots with same designer and session\n console.log(`[DEBUG] Multi-slot booking detected, looking for ${bookingDuration / 15} consecutive slots`);\n const startTimestamp = slot.start_timestamp as number;\n const slotsNeeded = bookingDuration / 15;\n const relatedSlots = [];\n \n for (let i = 0; i < slotsNeeded; i++) {\n const timestamp = startTimestamp + (i * 15 * 60 * 1000); // Add 15 minutes in milliseconds\n \n const relatedSlot = await sqlite.execute(\n `SELECT id, start_timestamp FROM design_reviews_v2 \n WHERE session_id = ? AND start_timestamp = ? AND designer_name = ? AND status = 'booked'`,\n [slot.session_id as number, timestamp, slot.designer_name as string]\n );\n \n if (relatedSlot.rows.length > 0) {\n const timeStr = new Date(timestamp).toISOString();\n console.log(`[DEBUG] Found related slot: ${relatedSlot.rows[0].id} at ${timeStr}`);\n relatedSlots.push({\n id: relatedSlot.rows[0].id as number,\n start_timestamp: timestamp,\n duration: 15\n });\n }\n }\n \n console.log(`[DEBUG] Returning ${relatedSlots.length} related slots`);\n return relatedSlots;\n } catch (error) {\n console.error(`[ERROR] Failed to get related slots for ${slotId}:`, error);\n return [];\n }\n}\n\nasync function cancelSpecificSlots(slotIds: number[]) {\n try {\n console.log(`[DEBUG] Attempting to cancel specific slots: ${slotIds.join(', ')}`);\n \n if (!Array.isArray(slotIds) || slotIds.length === 0) {\n return { success: false, error: \"No slots specified for cancellation\" };\n }\n \n // Cancel each specified slot\n for (const slotId of slotIds) {\n await sqlite.execute(\n `UPDATE design_reviews_v2 \n SET status = 'available', \n designer_name = NULL, \n topic = NULL, \n review_type = NULL, \n xfn_partners = NULL, \n booking_duration = 15,\n is_primary_slot = 1,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n [slotId]\n );\n \n // Try to assign from waitlist for each cancelled slot\n try {\n await assignFromWaitlist(slotId);\n } catch (waitlistError) {\n console.warn(`[DEBUG] Waitlist assignment failed for slot ${slotId}:`, waitlistError);\n }\n }\n \n console.log(`[DEBUG] Successfully cancelled slots: ${slotIds.join(', ')}`);\n return { success: true, cancelledSlots: slotIds };\n } catch (error) {\n console.error(`[ERROR] Failed to cancel specific slots:`, error);\n return { success: false, error: `Database error: ${error.message}` };\n }\n}\n\nasync function cancelBooking(id: number) {\n try {\n console.log(`[DEBUG] Attempting to cancel booking for slot ID: ${id}`);\n \n // Get all related slots in this booking\n const relatedSlots = await getRelatedSlots(id);\n \n if (relatedSlots.length === 0) {\n console.log(`[DEBUG] Slot ${id} not found or not booked`);\n return { success: false, error: \"Slot not found or not currently booked\" };\n }\n \n // Cancel all related slots\n const slotIds = relatedSlots.map(slot => slot.id);\n return await cancelSpecificSlots(slotIds);\n } catch (error) {\n console.error(`[ERROR] Failed to cancel booking for slot ${id}:`, error);\n return { success: false, error: `Database error: ${error.message}` };\n }\n}\n\nasync function joinWaitlist(\n slotId: number,\n designerName: string,\n topic: string,\n reviewType: string,\n xfnPartners?: string\n) {\n // Get next position in waitlist\n const positionResult = await sqlite.execute(\n `SELECT COALESCE(MAX(position), 0) + 1 as next_position \n FROM slot_waitlist_v2 WHERE slot_id = ?`,\n [slotId]\n );\n \n const nextPosition = (positionResult.rows[0]?.next_position as number) || 1;\n \n // Add to waitlist\n const result = await sqlite.execute(\n `INSERT INTO slot_waitlist_v2 (slot_id, designer_name, topic, review_type, xfn_partners, position)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [slotId, designerName, topic, reviewType, xfnPartners || null, nextPosition]\n );\n \n return { success: result.rows.length >= 0, position: nextPosition };\n}\n\nasync function assignFromWaitlist(slotId: number) {\n // Get first person in waitlist\n const waitlistResult = await sqlite.execute(\n `SELECT * FROM slot_waitlist_v2 \n WHERE slot_id = ? \n ORDER BY position ASC \n LIMIT 1`,\n [slotId]\n );\n \n if (waitlistResult.rows.length === 0) {\n return { success: false, message: \"No one on waitlist\" };\n }\n \n const waitlistEntry = waitlistResult.rows[0];\n \n // Book the slot for this person\n const bookResult = await bookSlot(\n slotId,\n waitlistEntry.designer_name as string,\n waitlistEntry.topic as string,\n waitlistEntry.review_type as string,\n waitlistEntry.xfn_partners as string\n );\n \n if (bookResult.success) {\n // Remove from waitlist\n await sqlite.execute(\n `DELETE FROM slot_waitlist_v2 WHERE id = ?`,\n [waitlistEntry.id as number]\n );\n \n // Update positions for remaining waitlist entries\n await sqlite.execute(\n `UPDATE slot_waitlist_v2 \n SET position = position - 1 \n WHERE slot_id = ? AND position > ?`,\n [slotId, waitlistEntry.position as number]\n );\n \n return { \n success: true, \n assignedTo: waitlistEntry.designer_name as string,\n message: `Slot assigned to ${waitlistEntry.designer_name}`\n };\n }\n \n return { success: false, message: \"Failed to assign slot\" };\n}\n\nasync function getWaitlistPosition(slotId: number, designerName: string) {\n const result = await sqlite.execute(\n `SELECT position FROM slot_waitlist_v2 \n WHERE slot_id = ? AND designer_name = ?`,\n [slotId, designerName]\n );\n \n return (result.rows[0]?.position as number) || null;\n}\n\nasync function createAvailableSlots(sessionId: number, _baseTimestamp: number, slots: Array<{startTimestamp: number, duration: number}>) {\n for (const slot of slots) {\n try {\n await sqlite.execute(\n `INSERT INTO design_reviews_v2 (session_id, start_timestamp, duration, status)\n VALUES (?, ?, ?, 'available')`,\n [sessionId, slot.startTimestamp, slot.duration]\n );\n } catch (error) {\n // If it's a unique constraint violation, skip this slot (it already exists)\n if (error.message && error.message.includes('UNIQUE constraint failed')) {\n console.log(`Slot already exists: session ${sessionId}, timestamp ${slot.startTimestamp}`);\n continue;\n }\n // Re-throw other errors\n throw error;\n }\n }\n}\n\n// Helper functions\nfunction _getNextTuesday(fromDate?: Date): string {\n const date = fromDate || new Date();\n const dayOfWeek = date.getDay();\n const daysUntilTuesday = (2 - dayOfWeek + 7) % 7 || 7;\n const nextTuesday = new Date(date);\n nextTuesday.setDate(date.getDate() + daysUntilTuesday);\n return nextTuesday.toISOString().split('T')[0];\n}\n\n\nfunction _parseTimeToMinutes(timeStr: string): number {\n const [hours, minutes] = timeStr.split(':').map(Number);\n return hours * 60 + minutes;\n}\n\nfunction _minutesToTimeString(minutes: number): string {\n const hours = Math.floor(minutes / 60);\n const mins = minutes % 60;\n return `${hours.toString().padStart(2, '0')}:${mins.toString().padStart(2, '0')}`;\n}\n\nasync function generateSlotsForSession(sessionId: number, dayTimestamp: number) {\n if (sessionId < 1 || sessionId > 3) {\n throw new Error('Invalid session ID. Must be between 1 and 3.');\n }\n\n // Get the date part from the timestamp\n const dayDate = new Date(dayTimestamp);\n dayDate.setUTCHours(0, 0, 0, 0);\n \n // Parse the time range for each session (in UTC hours)\n let startHour: number;\n let startMinute: number;\n let endHour: number;\n let endMinute: number;\n \n switch (sessionId) {\n case 1: // 2:30-4:30pm Paris (12:30-14:30 UTC)\n startHour = 12; startMinute = 30;\n endHour = 14; endMinute = 30;\n break;\n case 2: // 10-11am PT (17:00-18:00 UTC)\n startHour = 17; startMinute = 0;\n endHour = 18; endMinute = 0;\n break;\n case 3: // 1-2pm PT (20:00-21:00 UTC)\n startHour = 20; startMinute = 0;\n endHour = 21; endMinute = 0;\n break;\n default:\n throw new Error('Invalid session ID');\n }\n\n // Generate 15-minute slots with UTC timestamps\n const slots = [];\n \n // Create explicit UTC dates to avoid timezone issues\n const baseDate = new Date(dayTimestamp);\n const year = baseDate.getUTCFullYear();\n const month = baseDate.getUTCMonth();\n const day = baseDate.getUTCDate();\n \n const startTimestamp = new Date(Date.UTC(year, month, day, startHour, startMinute, 0, 0));\n const endTimestamp = new Date(Date.UTC(year, month, day, endHour, endMinute, 0, 0));\n \n \n for (let timestamp = startTimestamp.getTime(); timestamp < endTimestamp.getTime(); timestamp += 15 * 60 * 1000) {\n slots.push({\n startTimestamp: timestamp,\n duration: 15\n });\n }\n\n // Clear any existing slots for this session on this day first\n const dayStart = new Date(Date.UTC(year, month, day, 0, 0, 0, 0));\n const dayEnd = new Date(Date.UTC(year, month, day, 23, 59, 59, 999));\n \n await sqlite.execute(\n `DELETE FROM design_reviews_v2 WHERE session_id = ? AND start_timestamp >= ? AND start_timestamp <= ?`,\n [sessionId, dayStart.getTime(), dayEnd.getTime()]\n );\n\n // Insert the new slots\n await createAvailableSlots(sessionId, dayTimestamp, slots);\n \n return slots;\n}\n\nasync function generateSlotsForAllSessions() {\n const results = [];\n const today = new Date();\n \n // Generate slots for next 2 weeks of Tuesdays\n for (let i = 0; i < 14; i++) {\n const checkDate = new Date(today);\n checkDate.setUTCDate(today.getUTCDate() + i);\n checkDate.setUTCHours(0, 0, 0, 0);\n const dayOfWeek = checkDate.getUTCDay();\n const timestamp = checkDate.getTime();\n \n if (dayOfWeek === 2) { // Tuesday - Sessions 1, 2, 3\n for (const sessionId of [1, 2, 3]) {\n const slots = await generateSlotsForSession(sessionId, timestamp);\n results.push({ sessionId, timestamp, slotsCreated: slots.length });\n }\n }\n }\n \n return results;\n}\n\n\n// Track if initialization has been completed\nlet isInitialized = false;\n\n// Lazy initialization - only run when API endpoints are accessed\nasync function ensureInitialized() {\n if (isInitialized) {\n return; // Skip if already initialized\n }\n \n try {\n console.log('Initializing database on first API request...');\n await initDatabase();\n \n // Check if we need to generate slots for upcoming dates\n const today = new Date();\n let needsGeneration = false;\n \n // Check the next few Tuesdays\n for (let i = 0; i < 14 && !needsGeneration; i++) {\n const checkDate = new Date(today);\n checkDate.setUTCDate(today.getUTCDate() + i);\n checkDate.setUTCHours(0, 0, 0, 0);\n const dayOfWeek = checkDate.getUTCDay();\n const timestamp = checkDate.getTime();\n \n if (dayOfWeek === 2) { // Tuesday\n const tuesdaySlots = await getAllSlots(1, timestamp);\n if (tuesdaySlots.rows.length === 0) {\n needsGeneration = true;\n }\n }\n }\n \n if (needsGeneration) {\n console.log('Missing slots found, generating for next 2 weeks...');\n await generateSlotsForAllSessions();\n console.log('Slots generated successfully');\n } else {\n console.log('All slots already exist for next 2 weeks');\n }\n \n isInitialized = true;\n console.log('Database initialization complete');\n } catch (error) {\n console.error('Error initializing database:', error);\n throw error;\n }\n}\n\n// Enable CORS for API requests\napp.use(\"/api/*\", cors());\n\n// Serve index.html at the root /\napp.get(\"/\", (_c) => {\n console.log(`[DEBUG] Serving index.html`);\n return serveFile(\"frontend/index.html\", import.meta.url);\n});\n\n// Serve all /frontend files\napp.get(\"/frontend/*\", c => {\n // Extract the filename from the path\n const filename = c.req.path.replace('/frontend/', '');\n const filepath = `frontend/${filename}`;\n console.log(`[DEBUG] Serving frontend file: ${c.req.path} -> ${filepath}`);\n return serveFile(filepath, import.meta.url);\n});\n\n// API routes\napp.get(\"/api/health\", (c) => {\n return c.json({ status: \"ok\", timestamp: new Date().toISOString() });\n});\n\n// Get all review sessions info\napp.get(\"/api/sessions\", (c) => {\n return c.json(REVIEW_SESSIONS);\n});\n\n// Debug endpoint to fix timezone bug by regenerating all slots\napp.post(\"/api/debug/regenerate-slots\", async (c) => {\n try {\n console.log('🔧 DEBUG: Regenerating all slots with corrected UTC times...');\n \n // Clear all existing slots\n await sqlite.execute(`DELETE FROM design_reviews_v2`);\n console.log('🗑️ Cleared all existing slots');\n \n // Regenerate slots for next 4 weeks of Tuesdays\n const results = [];\n const today = new Date();\n \n for (let i = 0; i < 28; i++) {\n const checkDate = new Date(today);\n checkDate.setUTCDate(today.getUTCDate() + i);\n checkDate.setUTCHours(0, 0, 0, 0);\n const dayOfWeek = checkDate.getUTCDay();\n const timestamp = checkDate.getTime();\n \n if (dayOfWeek === 2) { // Tuesday\n for (const sessionId of [1, 2, 3]) {\n console.log(`🔄 Regenerating Session ${sessionId} for ${checkDate.toISOString().split('T')[0]}`);\n const slots = await generateSlotsForSession(sessionId, timestamp);\n results.push({ \n sessionId, \n date: checkDate.toISOString().split('T')[0],\n timestamp, \n slotsCreated: slots.length,\n firstSlotTime: slots.length > 0 ? new Date(slots[0].startTimestamp).toISOString() : null\n });\n }\n }\n }\n \n console.log('✅ Slot regeneration complete');\n return c.json({ \n success: true, \n message: 'All slots regenerated with corrected UTC times',\n results \n });\n } catch (error) {\n console.error('❌ Error regenerating slots:', error);\n return c.json({ \n success: false, \n error: error.message \n }, 500);\n }\n});\n\n// Check consecutive slot availability\napp.get(\"/api/slots/:slotId/consecutive\", async (c) => {\n const slotId = parseInt(c.req.param(\"slotId\"));\n const duration = parseInt(c.req.query(\"duration\") || \"15\");\n \n if (isNaN(slotId) || isNaN(duration)) {\n return c.json({ error: \"Invalid slot ID or duration\" }, 400);\n }\n \n const validDurations = [15, 30, 45, 60];\n if (!validDurations.includes(duration)) {\n return c.json({ \n error: \"Invalid duration. Must be one of: \" + validDurations.join(\", \") + \" minutes\" \n }, 400);\n }\n \n try {\n const slotsNeeded = duration / 15;\n \n // Get the start slot details\n const startSlotResult = await sqlite.execute(\n `SELECT session_id, start_timestamp, status FROM design_reviews_v2 WHERE id = ?`,\n [slotId]\n );\n \n if (startSlotResult.rows.length === 0) {\n return c.json({ available: false, error: \"Start slot not found\" });\n }\n \n const startSlot = startSlotResult.rows[0];\n if (startSlot.status !== 'available') {\n return c.json({ available: false, error: \"Start slot is not available\" });\n }\n \n // Check if all consecutive slots are available\n const startTimestamp = startSlot.start_timestamp as number;\n const consecutiveSlots = [{ id: slotId, time: new Date(startTimestamp).toISOString() }];\n \n for (let i = 1; i < slotsNeeded; i++) {\n const nextTimestamp = startTimestamp + (i * 15 * 60 * 1000); // Add 15 minutes in milliseconds\n \n const nextSlotResult = await sqlite.execute(\n `SELECT id, status FROM design_reviews_v2 \n WHERE session_id = ? AND start_timestamp = ?`,\n [startSlot.session_id as number, nextTimestamp]\n );\n \n if (nextSlotResult.rows.length === 0 || nextSlotResult.rows[0].status !== 'available') {\n const nextTime = new Date(nextTimestamp).toISOString();\n return c.json({ \n available: false, \n error: `Consecutive slot at ${nextTime} is not available`,\n availableSlots: consecutiveSlots\n });\n }\n \n consecutiveSlots.push({ \n id: nextSlotResult.rows[0].id as number, \n time: new Date(nextTimestamp).toISOString()\n });\n }\n \n return c.json({ \n available: true, \n consecutiveSlots,\n duration,\n message: `${slotsNeeded} consecutive slots available`\n });\n } catch (_error) {\n return c.json({ error: \"Failed to check consecutive availability\" }, 500);\n }\n});\n\n// Get slots for a specific session and timestamp\napp.get(\"/api/sessions/:sessionId/slots\", async (c) => {\n await ensureInitialized();\n \n const sessionId = parseInt(c.req.param(\"sessionId\"));\n const timestamp = c.req.query(\"timestamp\");\n \n if (!timestamp) {\n return c.json({ error: \"timestamp parameter is required\" }, 400);\n }\n \n const timestampNum = parseInt(timestamp);\n if (isNaN(timestampNum)) {\n return c.json({ error: \"Invalid timestamp format\" }, 400);\n }\n \n if (sessionId < 1 || sessionId > 3) {\n return c.json({ error: \"Invalid session ID\" }, 400);\n }\n \n try {\n // First, try to get existing slots\n let slots = await getAllSlots(sessionId, timestampNum);\n \n // If no slots exist for this timestamp, generate them\n if (!slots.rows || slots.rows.length === 0) {\n console.log(`No slots found for session ${sessionId} on timestamp ${timestampNum}, generating...`);\n \n // Validate that the timestamp is a valid session day\n const requestDate = new Date(timestampNum);\n const dayOfWeek = requestDate.getUTCDay();\n \n // Check if this is a valid session day\n const isValidTuesday = dayOfWeek === 2 && [1, 2, 3].includes(sessionId);\n \n if (isValidTuesday) {\n // Generate slots for this session and timestamp\n await generateSlotsForSession(sessionId, timestampNum);\n // Fetch the newly created slots\n slots = await getAllSlots(sessionId, timestampNum);\n console.log(`Generated ${slots.rows?.length || 0} slots for session ${sessionId} on timestamp ${timestampNum}`);\n } else {\n console.log(`Invalid session day: session ${sessionId} on timestamp ${timestampNum} (day ${dayOfWeek})`);\n }\n }\n \n return c.json({ session: REVIEW_SESSIONS[sessionId], slots: slots.rows || [] });\n } catch (error) {\n console.error(`Error fetching/generating slots for session ${sessionId} on timestamp ${timestampNum}:`, error);\n return c.json({ error: \"Failed to fetch slots\" }, 500);\n }\n});\n\n// Alternative endpoint format - GET /api/slots?session_id=X×tamp=123456\napp.get(\"/api/slots\", async (c) => {\n await ensureInitialized();\n \n const sessionId = c.req.query(\"session_id\");\n const timestamp = c.req.query(\"timestamp\");\n \n if (!sessionId || !timestamp) {\n return c.json({ \n error: \"Missing required parameters: session_id and timestamp\" \n }, 400);\n }\n \n const sessionIdNum = parseInt(sessionId);\n if (isNaN(sessionIdNum) || sessionIdNum < 1 || sessionIdNum > 3) {\n return c.json({ \n error: \"Invalid session_id. Must be between 1 and 3.\" \n }, 400);\n }\n \n const timestampNum = parseInt(timestamp);\n if (isNaN(timestampNum)) {\n return c.json({ error: \"Invalid timestamp format\" }, 400);\n }\n \n try {\n // First, try to get existing slots\n let slots = await getAllSlots(sessionIdNum, timestampNum);\n \n // If no slots exist for this timestamp, generate them\n if (!slots.rows || slots.rows.length === 0) {\n console.log(`No slots found for session ${sessionIdNum} on timestamp ${timestampNum}, generating...`);\n \n // Validate that the timestamp is a valid session day\n const requestDate = new Date(timestampNum);\n const dayOfWeek = requestDate.getUTCDay();\n \n // Check if this is a valid session day\n const isValidTuesday = dayOfWeek === 2 && [1, 2, 3].includes(sessionIdNum);\n \n if (isValidTuesday) {\n // Generate slots for this session and timestamp\n await generateSlotsForSession(sessionIdNum, timestampNum);\n // Fetch the newly created slots\n slots = await getAllSlots(sessionIdNum, timestampNum);\n console.log(`Generated ${slots.rows?.length || 0} slots for session ${sessionIdNum} on timestamp ${timestampNum}`);\n } else {\n console.log(`Invalid session day: session ${sessionIdNum} on timestamp ${timestampNum} (day ${dayOfWeek})`);\n }\n }\n \n return c.json({ \n success: true,\n session_id: sessionIdNum,\n timestamp: timestampNum,\n slots: slots.rows || []\n });\n } catch (error) {\n console.error(\"Error fetching slots:\", error);\n return c.json({ \n error: \"Failed to fetch slots\" \n }, 500);\n }\n});\n\n// Book a slot (with optional duration for consecutive slots)\napp.post(\"/api/slots/:slotId/book\", async (c) => {\n await ensureInitialized();\n const slotId = parseInt(c.req.param(\"slotId\"));\n const body = await c.req.json();\n \n // Support both naming conventions\n const designerName = body.designerName || body.designer_name;\n const topic = body.topic;\n const reviewType = body.reviewType || body.review_type;\n const xfnPartners = body.xfnPartners || body.xfn_partners;\n const duration = body.duration || 15; // default to 15 minutes\n\n console.log(`[DEBUG] POST /api/slots/${slotId}/book - Received booking request:`, {\n slotId, designerName, topic, reviewType, duration\n });\n \n if (!designerName || !topic || !reviewType) {\n return c.json({ \n error: \"Missing required fields: designerName/designer_name, topic, reviewType/review_type\" \n }, 400);\n }\n \n const validReviewTypes = [\"shareout\", \"brainstorm\", \"system_feedback\", \"ux_ui_feedback\"];\n if (!validReviewTypes.includes(reviewType)) {\n return c.json({ \n error: \"Invalid review type. Must be one of: \" + validReviewTypes.join(\", \") \n }, 400);\n }\n \n const validDurations = [15, 30, 45, 60];\n if (!validDurations.includes(duration)) {\n return c.json({ \n error: \"Invalid duration. Must be one of: \" + validDurations.join(\", \") + \" minutes\" \n }, 400);\n }\n \n try {\n let result;\n if (duration === 15) {\n // Single slot booking\n console.log(`[DEBUG] Booking single slot (15 minutes)`);\n result = await bookSlot(slotId, designerName, topic, reviewType, xfnPartners);\n if (!result.success) {\n // Handle different types of booking conflicts with specific error codes\n const statusCode = result.error === \"SLOT_NOT_FOUND\" ? 404 : 409; // 409 = Conflict\n return c.json({ \n error: result.error,\n message: result.message,\n currentBooker: result.currentBooker,\n alternatives: result.alternatives\n }, statusCode);\n }\n } else {\n // Consecutive slots booking\n console.log(`[DEBUG] Booking consecutive slots (${duration} minutes)`);\n result = await bookConsecutiveSlots(slotId, duration, designerName, topic, reviewType, xfnPartners);\n if (!result.success) {\n return c.json({ error: result.error || \"Failed to book consecutive slots\" }, 400);\n }\n }\n \n console.log(`[DEBUG] Booking result:`, result);\n \n return c.json({ \n success: true, \n message: result.message || \"Slot booked successfully\",\n bookedSlots: result.bookedSlots || [slotId]\n });\n } catch (_error) {\n return c.json({ error: \"Failed to book slot\" }, 500);\n }\n});\n\n// Get related slots for a booking (to show in cancellation modal)\napp.get(\"/api/slots/:slotId/related\", async (c) => {\n const slotId = parseInt(c.req.param(\"slotId\"));\n \n console.log(`[DEBUG] GET /api/slots/${slotId}/related - Getting related slots`);\n \n if (isNaN(slotId)) {\n return c.json({ error: \"Invalid slot ID\" }, 400);\n }\n \n try {\n const relatedSlots = await getRelatedSlots(slotId);\n console.log(`[DEBUG] Found ${relatedSlots.length} related slots for slot ${slotId}`);\n return c.json({ success: true, slots: relatedSlots });\n } catch (error) {\n console.error(`[ERROR] Failed to get related slots:`, error);\n return c.json({ error: \"Failed to get related slots\" }, 500);\n }\n});\n\n// Cancel specific slots (partial cancellation)\napp.post(\"/api/slots/cancel-partial\", async (c) => {\n const body = await c.req.json();\n const slotIds = body.slotIds;\n \n console.log(`[DEBUG] POST /api/slots/cancel-partial - Received request for slots: ${slotIds}`);\n \n if (!Array.isArray(slotIds) || slotIds.length === 0) {\n return c.json({ error: \"Invalid slot IDs array\" }, 400);\n }\n \n // Validate all slot IDs are numbers\n const validSlotIds = slotIds.filter(id => !isNaN(parseInt(id))).map(id => parseInt(id));\n if (validSlotIds.length !== slotIds.length) {\n return c.json({ error: \"All slot IDs must be valid numbers\" }, 400);\n }\n \n try {\n const result = await cancelSpecificSlots(validSlotIds);\n \n if (!result.success) {\n return c.json({ error: result.error || \"Failed to cancel slots\" }, 500);\n }\n \n return c.json({ \n success: true, \n message: `Successfully cancelled ${validSlotIds.length} slot(s)`,\n cancelledSlots: result.cancelledSlots\n });\n } catch (error) {\n console.error(`[ERROR] Exception in partial cancel endpoint:`, error);\n return c.json({ \n error: \"Failed to cancel slots\", \n details: error.message \n }, 500);\n }\n});\n\n// Cancel a booking (DELETE endpoint) - full cancellation\napp.delete(\"/api/slots/:slotId/cancel\", async (c) => {\n await ensureInitialized();\n \n const slotId = parseInt(c.req.param(\"slotId\"));\n \n console.log(`[DEBUG] DELETE /api/slots/${slotId}/cancel - Received cancellation request`);\n \n if (isNaN(slotId)) {\n console.log(`[DEBUG] Invalid slot ID provided: ${c.req.param(\"slotId\")}`);\n return c.json({ error: \"Invalid slot ID\" }, 400);\n }\n \n try {\n console.log(`[DEBUG] Calling cancelBooking for slot ${slotId}`);\n const result = await cancelBooking(slotId);\n \n if (!result.success) {\n console.log(`[DEBUG] Cancellation failed: ${result.error || 'Unknown error'}`);\n return c.json({ error: result.error || \"Slot not found or not currently booked\" }, 404);\n }\n \n console.log(`[DEBUG] Cancellation successful for slot ${slotId}`);\n return c.json({ success: true, message: \"Booking cancelled successfully\" });\n } catch (error) {\n console.error(`[ERROR] Exception in DELETE cancel endpoint:`, error);\n return c.json({ \n error: \"Failed to cancel booking\", \n details: error.message \n }, 500);\n }\n});\n\n// Cancel booking with designer name verification (POST endpoint for form data)\napp.post(\"/api/slots/:slotId/cancel\", async (c) => {\n const slotId = parseInt(c.req.param(\"slotId\"));\n const body = await c.req.json();\n const designerName = body.designerName || body.designer_name;\n \n if (isNaN(slotId)) {\n return c.json({ error: \"Invalid slot ID\" }, 400);\n }\n \n if (!designerName) {\n return c.json({ error: \"Designer name is required for verification\" }, 400);\n }\n \n try {\n // First verify the designer name matches\n const slot = await sqlite.execute(\n `SELECT designer_name FROM design_reviews_v2 WHERE id = ? AND status = 'booked'`,\n [slotId]\n );\n \n if (slot.rows.length === 0) {\n return c.json({ error: \"Slot not found or not currently booked\" }, 404);\n }\n \n const bookedDesigner = slot.rows[0].designer_name;\n if (bookedDesigner !== designerName) {\n return c.json({ error: \"Only the designer who booked this slot can cancel it\" }, 403);\n }\n \n // Cancel the booking\n const result = await cancelBooking(slotId);\n if (!result.success) {\n return c.json({ error: \"Failed to cancel booking\" }, 500);\n }\n \n return c.json({ success: true, message: \"Booking cancelled successfully\" });\n } catch (_error) {\n return c.json({ error: \"Failed to cancel booking\" }, 500);\n }\n});\n\n// Join waitlist for a slot\napp.post(\"/api/slots/:slotId/waitlist\", async (c) => {\n const slotId = parseInt(c.req.param(\"slotId\"));\n const body = await c.req.json();\n \n // Support both naming conventions\n const designerName = body.designerName || body.designer_name;\n const topic = body.topic;\n const reviewType = body.reviewType || body.review_type;\n const xfnPartners = body.xfnPartners || body.xfn_partners;\n \n if (isNaN(slotId)) {\n return c.json({ error: \"Invalid slot ID\" }, 400);\n }\n \n if (!designerName || !topic || !reviewType) {\n return c.json({ \n error: \"Missing required fields: designerName/designer_name, topic, reviewType/review_type\" \n }, 400);\n }\n \n const validReviewTypes = [\"shareout\", \"brainstorm\", \"system_feedback\", \"ux_ui_feedback\"];\n if (!validReviewTypes.includes(reviewType)) {\n return c.json({ \n error: \"Invalid review type. Must be one of: \" + validReviewTypes.join(\", \") \n }, 400);\n }\n \n try {\n // Check if slot is actually booked\n const slotCheck = await sqlite.execute(\n `SELECT status FROM design_reviews_v2 WHERE id = ?`,\n [slotId]\n );\n \n if (slotCheck.rows.length === 0) {\n return c.json({ error: \"Slot not found\" }, 404);\n }\n \n if (slotCheck.rows[0].status !== 'booked') {\n return c.json({ error: \"Slot is available - book it directly instead of joining waitlist\" }, 400);\n }\n \n // Check if user is already on waitlist\n const existingPosition = await getWaitlistPosition(slotId, designerName);\n if (existingPosition) {\n return c.json({ \n message: `Already on waitlist at position ${existingPosition}`,\n position: existingPosition \n });\n }\n \n const result = await joinWaitlist(slotId, designerName, topic, reviewType, xfnPartners);\n if (result.success) {\n return c.json({ \n success: true, \n message: `Added to waitlist at position ${result.position}`,\n position: result.position \n });\n } else {\n return c.json({ error: \"Failed to join waitlist\" }, 500);\n }\n } catch (_error) {\n return c.json({ error: \"Failed to join waitlist\" }, 500);\n }\n});\n\n// Get waitlist position for a user\napp.get(\"/api/slots/:slotId/waitlist/:designerName\", async (c) => {\n const slotId = parseInt(c.req.param(\"slotId\"));\n const designerName = c.req.param(\"designerName\");\n \n if (isNaN(slotId)) {\n return c.json({ error: \"Invalid slot ID\" }, 400);\n }\n \n try {\n const position = await getWaitlistPosition(slotId, designerName);\n if (position) {\n return c.json({ position, inWaitlist: true });\n } else {\n return c.json({ position: null, inWaitlist: false });\n }\n } catch (_error) {\n return c.json({ error: \"Failed to check waitlist position\" }, 500);\n }\n});\n\n\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err, _c) => {\n throw err;\n});\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;","deleted","label","frontdesignreview",[168,149],"backend","permalink","https://www.val.town/x/valeriewwong/designreview/code/backend/server.ts","extension","actionData","errors"]