[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_167":168,"_169":170},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":84,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":118,"_119":120,"_121":25,"_122":123,"_124":125,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","019ca819-d039-7649-9fb7-5e0a225ddb3f","name","fileType","http","content","/**\n * Val.town Funktion - Rosa Regiondo Verfuegbarkeitspruefung HANNOVER\n * Basierend auf dem funktionierenden Leipzig-Code\n */\nconst REGIONDO_PUBLIC_KEY = \"ES21766a321231\";\nconst REGIONDO_SECRET_KEY = \"c26308b2c6d102c69212310c4fbcdb98eb250\";\nconst ROSA_API_KEY = \"rosa-hannover-2026-verfuegbarkeit\";\nconst REGIONDO_API_URL = \"https://api.regiondo.com/v1\";\n\nconst RAUM_MAPPING: Record = {\n \"Dungeon\": {\n anzeige: \"Dungeon (Expeditionsraum)\",\n synonyme: [\n \"dungeon\",\n \"expedition\",\n \"expeditionsraum\",\n \"hannover dungeon\",\n \"kerker\",\n \"verlies\",\n \"mittelalter\",\n ],\n },\n \"Zauber\": {\n anzeige: \"Harrys Zauberschule (Zauberraum)\",\n synonyme: [\n \"zauber\",\n \"zauberschule\",\n \"harry\",\n \"harrys zauberschule\",\n \"hzs\",\n \"zauberraum\",\n \"zauberer\",\n ],\n },\n \"Bitcoin\": {\n anzeige: \"Die Bitcoin Verschwoerung (Krimiraum)\",\n synonyme: [\n \"bitcoin\",\n \"krimi\",\n \"krimiraum\",\n \"bitcoin verschwoerung\",\n \"laszlo\",\n \"hacker\",\n ],\n },\n \"Pyramide\": {\n anzeige: \"Escape The Lost Pyramid (VR)\",\n synonyme: [\n \"pyramide\",\n \"lost pyramid\",\n \"pyramid\",\n \"ubisoft pyramide\",\n \"pyramidenraum\",\n ],\n },\n \"Medusa\": {\n anzeige: \"Beyond Medusas Gate (VR)\",\n synonyme: [\n \"medusa\",\n \"medusas gate\",\n \"medusa gate\",\n \"ubisoft medusa\",\n \"medusaraum\",\n ],\n },\n \"Mission Sigma\": {\n anzeige: \"Mission Sigma (VR)\",\n synonyme: [\"sigma\", \"mission sigma\", \"rakete\", \"raketenraum\", \"biowaffe\"],\n },\n \"Jungle Quest\": {\n anzeige: \"Jungle Quest (VR)\",\n synonyme: [\"jungle\", \"jungle quest\", \"dschungel\", \"jungleraum\"],\n },\n \"Weihnachtsraum\": {\n anzeige: \"Christmas (VR)\",\n synonyme: [\n \"weihnachten\",\n \"christmas\",\n \"weihnachtsraum\",\n \"weihnachtsmann\",\n \"xmas\",\n ],\n },\n \"Alice\": {\n anzeige: \"Alice im Wunderland (VR)\",\n synonyme: [\"alice\", \"wunderland\", \"alice im wunderland\", \"wunderlandraum\"],\n },\n \"Dreamhackers\": {\n anzeige: \"Dream Hackers (VR)\",\n synonyme: [\n \"dreamhackers\",\n \"dream hackers\",\n \"traumjaeger\",\n \"traumjaegerraum\",\n \"dream hunter\",\n ],\n },\n \"Escape Worlds\": {\n anzeige: \"Escape The Worlds (VR)\",\n synonyme: [\n \"welten\",\n \"escape worlds\",\n \"escape the worlds\",\n \"weltenraum\",\n \"worlds\",\n ],\n },\n \"The Prison\": {\n anzeige: \"The Prison (VR)\",\n synonyme: [\"the prison\", \"prison\", \"gefaengnisraum\", \"gefaengnis\"],\n },\n \"Erlebniswelten\": {\n anzeige: \"VR Erlebniswelten\",\n synonyme: [\"erlebniswelten\", \"vr erlebniswelten\", \"vr arcade\", \"arcade\"],\n },\n};\n\nconst PRODUKT_ZU_RAUM: Record = {\n \"dungeon\": \"Dungeon\",\n \"expedition\": \"Dungeon\",\n \"expeditionsraum\": \"Dungeon\",\n \"hannover dungeon\": \"Dungeon\",\n \"flucht aus dem dungeon\": \"Dungeon\",\n \"harrys zauberschule\": \"Zauber\",\n \"zauberschule\": \"Zauber\",\n \"zauber\": \"Zauber\",\n \"bitcoin verschwoerung\": \"Bitcoin\",\n \"bitcoin\": \"Bitcoin\",\n \"die bitcoin verschwoerung\": \"Bitcoin\",\n \"escape the lost pyramid\": \"Pyramide\",\n \"lost pyramid\": \"Pyramide\",\n \"pyramide\": \"Pyramide\",\n \"beyond medusa's gate\": \"Medusa\",\n \"beyond medusas gate\": \"Medusa\",\n \"medusa\": \"Medusa\",\n \"mission sigma\": \"Mission Sigma\",\n \"jungle quest\": \"Jungle Quest\",\n \"weihnachtsraum\": \"Weihnachtsraum\",\n \"christmas\": \"Weihnachtsraum\",\n \"alice im wunderland\": \"Alice\",\n \"alice\": \"Alice\",\n \"dream hackers\": \"Dreamhackers\",\n \"dreamhackers\": \"Dreamhackers\",\n \"dreamhacker\": \"Dreamhackers\",\n \"dream hunter\": \"Dreamhackers\",\n \"traumjaeger\": \"Dreamhackers\",\n \"escape the worlds\": \"Escape Worlds\",\n \"escape worlds\": \"Escape Worlds\",\n \"the prison\": \"The Prison\",\n \"vr escape raum\": \"Erlebniswelten\",\n \"vr erlebniswelten\": \"Erlebniswelten\",\n \"erlebniswelten\": \"Erlebniswelten\",\n \"vr simulationsraum\": \"Erlebniswelten\",\n \"vr erlebnisse\": \"Erlebniswelten\",\n \"expeditionsraum\": \"Dungeon\",\n \"zauberraum\": \"Zauber\",\n \"krimiraum\": \"Bitcoin\",\n \"pyramidenraum\": \"Pyramide\",\n \"medusaraum\": \"Medusa\",\n \"raketenraum\": \"Mission Sigma\",\n \"wunderlandraum\": \"Alice\",\n \"jungleraum\": \"Jungle Quest\",\n \"traumjaegerraum\": \"Dreamhackers\",\n \"gefaengnisraum\": \"The Prison\",\n \"weltenraum\": \"Escape Worlds\",\n};\n\nconst RAUM_DAUER: Record = {\n \"Dungeon\": 75,\n \"Zauber\": 75,\n \"Bitcoin\": 75,\n \"Pyramide\": 50,\n \"Medusa\": 50,\n \"Mission Sigma\": 50,\n \"Jungle Quest\": 50,\n \"Weihnachtsraum\": 50,\n \"Alice\": 50,\n \"Dreamhackers\": 50,\n \"Escape Worlds\": 50,\n \"The Prison\": 50,\n \"Erlebniswelten\": 50,\n};\n\nconst KOMBI_DAUER = 90;\n\nconst VR_RAEUME = [\n \"Pyramide\",\n \"Medusa\",\n \"Mission Sigma\",\n \"Jungle Quest\",\n \"Weihnachtsraum\",\n \"Alice\",\n \"Dreamhackers\",\n \"Escape Worlds\",\n \"The Prison\",\n \"Erlebniswelten\",\n];\n\nconst KOMBI_STANDARD: Record = {\n 2: [\"Dungeon\", \"Zauber\"],\n 3: [\"Dungeon\", \"Zauber\", \"Bitcoin\"],\n};\n\nexport default async function (req: Request): Promise {\n try {\n const url = new URL(req.url);\n const params = Object.fromEntries(url.searchParams);\n\n if (params.api_key && params.api_key.trim() !== ROSA_API_KEY) {\n return jsonAntwort({ fehler: \"Zugriff verweigert.\" }, 403);\n }\n\n let datumStr = (params.datum || \"\").trim();\n if (datumStr.includes(\"{{\") || datumStr.includes(\"}}\")) datumStr = \"\";\n if (!datumStr || !/^\\d{4}-\\d{2}-\\d{2}$/.test(datumStr)) {\n return jsonAntwort(\n { fehler: \"Datum im Format JJJJ-MM-TT angeben.\" },\n 400,\n );\n }\n\n let raumFilter = (params.raum || \"\").trim().toLowerCase();\n let gefilterterRaum: string | null = null;\n if (raumFilter.includes(\"{{\") || raumFilter.includes(\"}}\")) raumFilter = \"\";\n if (raumFilter) {\n gefilterterRaum = raumVonSuchwort(raumFilter);\n if (!gefilterterRaum) {\n return jsonAntwort({ fehler: \"Raum nicht gefunden.\" }, 400);\n }\n }\n\n const buchungen = await regiondoBuchungenLaden(datumStr);\n if (buchungen.fehler) {\n return jsonAntwort(\n { fehler: \"Regiondo Fehler: \" + buchungen.fehler },\n 500,\n );\n }\n\n if (params.debug === \"true\") {\n return jsonAntwort({\n debug: true,\n datum: datumStr,\n buchungen: (buchungen.daten || []).map((b: any) => ({\n product_name: b.product_name,\n variation_name: b.variation_name,\n event_date_time: b.event_date_time,\n status: b.status,\n })),\n });\n }\n\n const belegteSlots = belegteZeitfensterErmitteln(\n buchungen.daten || [],\n datumStr,\n );\n\n const now = new Date();\n const bp = Object.fromEntries(\n new Intl.DateTimeFormat(\"de-DE\", {\n timeZone: \"Europe/Berlin\",\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false,\n }).formatToParts(now).map((p) => [p.type, p.value]),\n );\n const heuteBerlin = bp.year + \"-\" + bp.month + \"-\" + bp.day;\n const fruehestStart = datumStr === heuteBerlin\n ? (parseInt(bp.hour) * 60 + parseInt(bp.minute))\n : null;\n\n const ergebnis = verfuegbarkeitErstellen(\n belegteSlots,\n datumStr,\n gefilterterRaum,\n fruehestStart,\n );\n\n return jsonAntwort({\n datum: datumStr,\n abfrage_raum: gefilterterRaum\n ? RAUM_MAPPING[gefilterterRaum].anzeige\n : \"Alle Raeume\",\n ergebnis,\n });\n } catch (err: any) {\n return jsonAntwort({ fehler: \"Interner Fehler: \" + err.message }, 500);\n }\n}\n\nasync function regiondoBuchungenLaden(datumStr: string) {\n const qp = \"date_range=\" + datumStr + \"%2C\" + datumStr +\n \"&date_range_by=date_of_event&limit=200&offset=0\";\n const ts = Date.now();\n const enc = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n enc.encode(REGIONDO_SECRET_KEY),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sig = await crypto.subtle.sign(\n \"HMAC\",\n key,\n enc.encode(ts + REGIONDO_PUBLIC_KEY + qp),\n );\n const hmac = Array.from(new Uint8Array(sig)).map((b) =>\n b.toString(16).padStart(2, \"0\")\n ).join(\"\");\n\n try {\n const r = await fetch(REGIONDO_API_URL + \"/supplier/bookings?\" + qp, {\n method: \"GET\",\n headers: {\n \"X-API-HASH\": hmac,\n \"X-API-TIME\": \"\" + ts,\n \"X-API-ID\": REGIONDO_PUBLIC_KEY,\n },\n });\n if (r.status !== 200) return { fehler: \"HTTP \" + r.status, daten: [] };\n const d = await r.json();\n let items = d.data || d || [];\n if (!Array.isArray(items)) items = [];\n return { daten: items, fehler: null };\n } catch (e: any) {\n return { fehler: e.message, daten: [] };\n }\n}\n\nfunction raumVonSuchwort(suchwort: string): string | null {\n suchwort = suchwort.toLowerCase().trim();\n for (const raum in RAUM_MAPPING) {\n if (raum.toLowerCase() === suchwort) return raum;\n for (const syn of RAUM_MAPPING[raum].synonyme) {\n if (\n syn.toLowerCase() === suchwort || suchwort.includes(syn.toLowerCase())\n ) return raum;\n }\n }\n return null;\n}\n\ntype BelegterSlot = { zeit: string; dauer: number };\n\nfunction belegteZeitfensterErmitteln(\n buchungen: any[],\n datumStr: string,\n): Record {\n const belegt: Record = {};\n function add(raum: string, zeit: string, dauer: number) {\n if (!belegt[raum]) belegt[raum] = [];\n const ex = belegt[raum].find((s) => s.zeit === zeit);\n if (ex) ex.dauer = Math.max(ex.dauer, dauer);\n else belegt[raum].push({ zeit, dauer });\n }\n\n for (const b of buchungen) {\n const st = (b.status || \"\").toLowerCase();\n if (st === \"cancelled\" || st === \"refunded\" || st === \"storniert\") continue;\n const pn = (b.product_name || \"\").toLowerCase(),\n vn = (b.variation_name || \"\").toLowerCase();\n const m = (b.event_date_time || b.date_applied_for || \"\").match(\n /(\\d{2}):(\\d{2})/,\n );\n if (!m) continue;\n const uhr = m[1] + \":\" + m[2];\n\n const istKombi = pn.includes(\"kombi\") || vn.includes(\"kombi\");\n if (istKombi) {\n const gm = pn.match(/(\\d)er/) || vn.match(/(\\d)er/);\n const kg = gm ? parseInt(gm[1]) : 0;\n const res = b.resources || [];\n const found: string[] = [];\n if (Array.isArray(res) && res.length > 0) {\n for (const r of res) {\n const rn = (r.resource_name || \"\").toLowerCase();\n if (rn && PRODUKT_ZU_RAUM[rn]) found.push(PRODUKT_ZU_RAUM[rn]);\n }\n }\n if (found.length === 0) {\n for (const k in PRODUKT_ZU_RAUM) {\n if (vn.includes(k) && !found.includes(PRODUKT_ZU_RAUM[k])) {\n found.push(PRODUKT_ZU_RAUM[k]);\n }\n }\n }\n if (found.length > 0) { for (const r of found) add(r, uhr, KOMBI_DAUER); }\n else if (kg >= 2 && kg <= 3) {\n for (const r of KOMBI_STANDARD[kg] || []) add(r, uhr, KOMBI_DAUER);\n } else for (const r of KOMBI_STANDARD[3] || []) add(r, uhr, KOMBI_DAUER);\n continue;\n }\n\n let rn: string | null = null;\n for (const k in PRODUKT_ZU_RAUM) {\n if (vn.includes(k)) {\n rn = PRODUKT_ZU_RAUM[k];\n break;\n }\n }\n if (!rn) {\n for (const k in PRODUKT_ZU_RAUM) {\n if (pn.includes(k)) {\n rn = PRODUKT_ZU_RAUM[k];\n break;\n }\n }\n }\n if (!rn) continue;\n add(rn, uhr, RAUM_DAUER[rn] || 75);\n }\n\n const vrs: BelegterSlot[] = [];\n for (const vr of VR_RAEUME) {\n for (const s of (belegt[vr] || [])) {\n if (!vrs.find((x) => x.zeit === s.zeit && x.dauer === s.dauer)) {\n vrs.push({ ...s });\n }\n }\n }\n if (vrs.length > 0) {\n for (const vr of VR_RAEUME) {\n for (const s of vrs) {\n if (!belegt[vr]) belegt[vr] = [];\n const ex = belegt[vr].find((x) => x.zeit === s.zeit);\n if (ex) ex.dauer = Math.max(ex.dauer, s.dauer);\n else belegt[vr].push({ ...s });\n }\n }\n }\n return belegt;\n}\n\nfunction verfuegbarkeitErstellen(\n belegteSlots: Record,\n datumStr: string,\n raumFilter: string | null,\n fruehestStart: number | null = null,\n) {\n const VON = 9 * 60, BIS = 21 * 60;\n const start = fruehestStart !== null ? Math.max(VON, fruehestStart) : VON;\n const ergebnis: any[] = [];\n\n for (const raum of (raumFilter ? [raumFilter] : Object.keys(RAUM_MAPPING))) {\n const ri = RAUM_MAPPING[raum];\n if (!ri) continue;\n const mind = RAUM_DAUER[raum] || 75;\n const bz = belegteSlots[raum] || [];\n\n if (bz.length === 0) {\n const rest = BIS - start;\n if (rest < mind) {\n ergebnis.push({\n raum: ri.anzeige,\n status: \"ausgebucht\",\n info: \"Heute keine buchbaren Zeitfenster mehr.\",\n });\n } else {\n ergebnis.push({\n raum: ri.anzeige,\n status: \"frei\",\n info: \"Frei ab \" + mzz(start) + \" Uhr bis 21:00 Uhr.\",\n });\n }\n continue;\n }\n\n const slots = bz.map((s) => {\n const t = s.zeit.split(\":\");\n const st = parseInt(t[0]) * 60 + parseInt(t[1]);\n return { start: st, end: st + s.dauer };\n }).sort((a, b) => a.start - b.start);\n\n const merged: { start: number; end: number }[] = [];\n for (const s of slots) {\n if (merged.length > 0 && s.start < merged[merged.length - 1].end) {\n merged[merged.length - 1].end = Math.max(\n merged[merged.length - 1].end,\n s.end,\n );\n } else merged.push({ ...s });\n }\n\n const ff: string[] = [];\n let cur = start;\n for (const s of merged) {\n if (s.end <= cur) continue;\n if (s.start - cur >= mind) {\n ff.push(mzz(cur) + \"-\" + mzz(s.start) + \" Uhr\");\n }\n cur = Math.max(cur, s.end);\n }\n if (BIS - cur >= mind) ff.push(mzz(cur) + \"-\" + mzz(BIS) + \" Uhr\");\n\n if (ff.length === 0) {\n ergebnis.push({\n raum: ri.anzeige,\n status: \"ausgebucht\",\n info: \"Heute leider vollstaendig ausgebucht.\",\n });\n } else {\n ergebnis.push({\n raum: ri.anzeige,\n status: \"teilweise frei\",\n freie_zeiten: ff,\n info: \"Noch buchbar: \" + ff.join(\", \") + \".\",\n });\n }\n }\n return ergebnis;\n}\n\nfunction mzz(min: number): string {\n const h = Math.floor(min / 60), m = min % 60;\n return (h < 10 ? \"0\" : \"\") + h + \":\" + (m < 10 ? \"0\" : \"\") + m;\n}\n\nfunction jsonAntwort(daten: any, statusCode = 200): Response {\n return new Response(JSON.stringify(daten, null, 2), {\n status: statusCode,\n headers: { \"Content-Type\": \"application/json\" },\n });\n}","/**\n * Val.town Funktion – Rosa Regiondo Verfügbarkeitsprüfung\n * STANDORT: HANNOVER (Escape Hannover)\n *\n * Basiert auf der Leipzig-Vorlage (Stand: 23.02.2026)\n *\n * EINRICHTUNG:\n * 1. Neues Val.town-Projekt erstellen (z.B. \"escape_hannover_verfuegbarkeit\")\n * 2. Diesen Code einfügen\n * 3. TODO-Markierungen prüfen und Regiondo-Keys eintragen\n * 4. URL in Placetel AI eintragen\n */\n\n// ============================================\n// KONFIGURATION – TODO: HANNOVER REGIONDO-KEYS EINTRAGEN\n// ============================================\nconst REGIONDO_PUBLIC_KEY = \"TODO_HANNOVER_PUBLIC_KEY\"; // TODO: Hannover Regiondo Public Key\nconst REGIONDO_SECRET_KEY = \"TODO_HANNOVER_SECRET_KEY\"; // TODO: Hannover Regiondo Secret Key\nconst ROSA_API_KEY = \"rosa-hannover-2026-verfuegbarkeit\";\nconst REGIONDO_API_URL = \"https://api.regiondo.com/v1\";\n\n// ============================================\n// RAUM-ZUORDNUNG (Hannover – 3 analoge + VR)\n// ============================================\nconst RAUM_MAPPING: Record = {\n // 3 Analoge Escape Rooms\n \"Expedition\": {\n anzeige: \"Expeditionsraum (Hannover Dungeon)\",\n synonyme: [\n \"expeditionsraum\",\n \"expedition\",\n \"hannover dungeon\",\n \"dungeon\",\n \"mittelalter\",\n \"kreuzritter\",\n ],\n },\n \"Zauber\": {\n anzeige: \"Zauberschule (Zauberraum)\",\n synonyme: [\n \"zauber\",\n \"zauberschule\",\n \"zauberraum\",\n \"harrys zauberschule\",\n \"harry\",\n ],\n },\n \"Bitcoin\": {\n anzeige: \"Bitcoin Verschwörung (Krimiraum)\",\n synonyme: [\"bitcoin\", \"krimiraum\", \"krimi\", \"bitcoin verschwörung\"],\n },\n // VR Escape Rooms (kein \"Escape Worlds\" in Hannover!)\n \"Pyramide\": {\n anzeige: \"Pyramide (VR)\",\n synonyme: [\"pyramide\", \"pyramidenraum\", \"lost pyramid\"],\n },\n \"Medusa\": { anzeige: \"Medusa (VR)\", synonyme: [\"medusa\", \"medusaraum\"] },\n \"Mission Sigma\": {\n anzeige: \"Mission Sigma (VR)\",\n synonyme: [\"mission sigma\", \"raketenraum\", \"rakete\"],\n },\n \"Jungle Quest\": {\n anzeige: \"Jungle Quest (VR)\",\n synonyme: [\"jungle quest\", \"jungleraum\", \"jungle\", \"dschungel\", \"jungel\"],\n },\n \"Weihnachtsraum\": {\n anzeige: \"Weihnachtsraum (VR)\",\n synonyme: [\"weihnachtsraum\", \"christmas\", \"weihnachten\"],\n },\n \"Alice\": {\n anzeige: \"Alice im Wunderland (VR)\",\n synonyme: [\"alice\", \"wunderland\", \"wunderlandraum\"],\n },\n // KEIN \"Escape Worlds\" (Weltenraum) in Hannover!\n \"Erlebniswelten\": {\n anzeige: \"VR Erlebniswelten\",\n synonyme: [\"erlebniswelten\", \"vr erlebniswelten\", \"vr arcade\", \"arcade\"],\n },\n};\n\n// Zuordnung: Regiondo-Produktnamen/Varianten → interner Raumname\n// TODO: Produktnamen aus Hannover-Regiondo prüfen und ggf. anpassen!\nconst PRODUKT_ZU_RAUM: Record = {\n // Analoge Räume (Hannover-spezifisch)\n \"expedition ins mittelalter\": \"Expedition\",\n \"hannover dungeon\": \"Expedition\",\n \"dungeon\": \"Expedition\",\n \"expeditionsraum\": \"Expedition\",\n \"harrys zauberschule\": \"Zauber\",\n \"zauberschule\": \"Zauber\",\n \"₿itcoin verschwörung\": \"Bitcoin\",\n \"bitcoin verschwörung\": \"Bitcoin\",\n \"bitcoin\": \"Bitcoin\",\n // VR Escape Rooms\n \"escape the lost pyramid\": \"Pyramide\",\n \"lost pyramid\": \"Pyramide\",\n \"pyramide\": \"Pyramide\",\n \"beyond medusa's gate\": \"Medusa\",\n \"beyond medusas gate\": \"Medusa\",\n \"medusa\": \"Medusa\",\n \"mission sigma\": \"Mission Sigma\",\n \"jungle quest\": \"Jungle Quest\",\n \"weihnachtsraum\": \"Weihnachtsraum\",\n \"christmas\": \"Weihnachtsraum\",\n \"alice im wunderland\": \"Alice\",\n \"alice\": \"Alice\",\n \"vr erlebniswelten\": \"Erlebniswelten\",\n \"erlebniswelten\": \"Erlebniswelten\",\n \"vr simulationsraum\": \"Erlebniswelten\",\n \"vr erlebnisse\": \"Erlebniswelten\",\n // KOMBI-Varianten (TODO: aus Hannover-Regiondo prüfen!)\n \"expeditionsraum\": \"Expedition\",\n \"zauberraum\": \"Zauber\",\n \"krimiraum\": \"Bitcoin\",\n \"pyramidenraum\": \"Pyramide\",\n \"medusaraum\": \"Medusa\",\n \"raketenraum\": \"Mission Sigma\",\n \"wunderlandraum\": \"Alice\",\n \"jungleraum\": \"Jungle Quest\",\n};\n\n// Standard-Dauer pro Raum (Einzelbuchung)\nconst RAUM_DAUER: Record = {\n \"Expedition\": 75,\n \"Zauber\": 75,\n \"Bitcoin\": 75,\n \"Pyramide\": 50,\n \"Medusa\": 50,\n \"Mission Sigma\": 50,\n \"Jungle Quest\": 50,\n \"Weihnachtsraum\": 50,\n \"Alice\": 50,\n \"Erlebniswelten\": 50,\n};\n\n// KOMBI-Dauer ist immer 90 Minuten\nconst KOMBI_DAUER = 90;\n\n// ============================================\n// STARTZEITEN-RASTER (aus Regiondo)\n// Analog-Räume: alle 120 Minuten ab 09:00\n// VR-Räume: alle 105 Minuten ab 09:00\n// ============================================\nconst ANALOG_STARTZEITEN = [\n 9 * 60,\n 11 * 60,\n 13 * 60,\n 15 * 60,\n 17 * 60,\n 19 * 60,\n];\nconst VR_STARTZEITEN = [\n 9 * 60,\n 10 * 60 + 45,\n 12 * 60 + 30,\n 14 * 60 + 15,\n 16 * 60,\n 17 * 60 + 45,\n 19 * 60 + 30,\n];\n\n// ============================================\n// VR-RÄUME – teilen sich EINEN physischen Raum!\n// Wenn ein VR-Angebot belegt ist, sind ALLE belegt.\n// ============================================\nconst VR_RAEUME = [\n \"Pyramide\",\n \"Medusa\",\n \"Mission Sigma\",\n \"Jungle Quest\",\n \"Weihnachtsraum\",\n \"Alice\",\n \"Erlebniswelten\",\n // KEIN \"Escape Worlds\", \"The Prison\", \"Zeitdolch\", \"Dreamhackers\" in Hannover\n];\n\n// Hannover: Nur bis 4er Kombi (3 analoge Räume + VR möglich)\nconst KOMBI_STANDARD: Record = {\n 2: [\"Expedition\", \"Zauber\"],\n 3: [\"Expedition\", \"Zauber\", \"Bitcoin\"],\n 4: [\"Expedition\", \"Zauber\", \"Bitcoin\"], // TODO: 4er Kombi mit VR? Prüfen!\n};\n\n// ============================================\n// HAUPTFUNKTION\n// ============================================\nexport default async function (req: Request): Promise {\n try {\n const url = new URL(req.url);\n const params = Object.fromEntries(url.searchParams);\n\n // 1. API-Key prüfen (optional – URL-Hash dient als Zugriffsschutz)\n if (params.api_key && params.api_key.trim() !== ROSA_API_KEY) {\n return jsonAntwort(\n { fehler: \"Zugriff verweigert. Ungültiger API-Key.\" },\n 403,\n );\n }\n\n // 2. Datum prüfen (Placetel-Platzhalter abfangen)\n let datumStr = (params.datum || \"\").trim();\n if (datumStr.includes(\"{{\") || datumStr.includes(\"}}\")) {\n datumStr = \"\";\n }\n if (!datumStr || !/^\\d{4}-\\d{2}-\\d{2}$/.test(datumStr)) {\n return jsonAntwort({\n fehler: \"Bitte ein gültiges Datum im Format JJJJ-MM-TT angeben.\",\n }, 400);\n }\n\n // 3. Optionaler Raumfilter\n let raumFilter = (params.raum || \"\").trim().toLowerCase();\n let gefilterterRaum: string | null = null;\n\n // Placetel-Platzhalter nicht ersetzt → alle Räume anzeigen\n if (raumFilter.includes(\"{{\") || raumFilter.includes(\"}}\")) {\n raumFilter = \"\";\n }\n\n if (raumFilter) {\n gefilterterRaum = raumVonSuchwort(raumFilter);\n if (!gefilterterRaum) {\n return jsonAntwort({\n fehler: `Raum '${raumFilter}' nicht gefunden. Verfügbare Räume: ${\n Object.keys(RAUM_MAPPING).join(\", \")\n }`,\n }, 400);\n }\n }\n\n // 4. Regiondo API abfragen\n const buchungen = await regiondoBuchungenLaden(datumStr);\n if (buchungen.fehler) {\n return jsonAntwort(\n { fehler: \"Regiondo API Fehler: \" + buchungen.fehler },\n 500,\n );\n }\n\n // DEBUG-MODUS: Zeige Rohdaten (ohne Kundendaten!)\n if (params.debug === \"true\") {\n const debugDaten = (buchungen.daten || []).map((b: any) => ({\n product_name: b.product_name,\n variation_name: b.variation_name,\n event_date_time: b.event_date_time,\n status: b.status,\n resources: b.resources || b.resource || b.resource_name ||\n \"nicht vorhanden\",\n tickets: b.tickets\n ? b.tickets.map((t: any) => ({\n name: t.name,\n variation: t.variation_name,\n resource: t.resource,\n }))\n : \"keine\",\n alle_felder: Object.keys(b),\n }));\n return jsonAntwort({\n debug: true,\n datum: datumStr,\n anzahl_buchungen: debugDaten.length,\n buchungen: debugDaten,\n });\n }\n\n // 5. Belegte Zeitfenster ermitteln (KEINE Kundendaten!)\n const belegteSlots = belegteZeitfensterErmitteln(\n buchungen.daten || [],\n datumStr,\n );\n\n // 6. Ergebnis zusammenbauen\n const ergebnis = verfuegbarkeitErstellen(\n belegteSlots,\n datumStr,\n gefilterterRaum,\n );\n\n return jsonAntwort({\n datum: datumStr,\n abfrage_raum: gefilterterRaum\n ? RAUM_MAPPING[gefilterterRaum].anzeige\n : \"Alle Räume\",\n ergebnis: ergebnis,\n });\n } catch (err: any) {\n return jsonAntwort({ fehler: \"Interner Fehler: \" + err.message }, 500);\n }\n}\n\n// ============================================\n// REGIONDO API – HMAC Authentifizierung\n// ============================================\nasync function regiondoBuchungenLaden(datumStr: string) {\n const queryParams =\n `date_range=${datumStr}%2C${datumStr}&date_range_by=date_of_event&limit=200&offset=0`;\n const timestamp = Date.now();\n const requestData = `${timestamp}${REGIONDO_PUBLIC_KEY}${queryParams}`;\n\n // HMAC-SHA256 berechnen\n const encoder = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(REGIONDO_SECRET_KEY),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const signatureBuffer = await crypto.subtle.sign(\n \"HMAC\",\n key,\n encoder.encode(requestData),\n );\n const hmacHex = Array.from(new Uint8Array(signatureBuffer))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n\n const apiUrl = `${REGIONDO_API_URL}/supplier/bookings?${queryParams}`;\n\n try {\n const response = await fetch(apiUrl, {\n method: \"GET\",\n headers: {\n \"X-API-HASH\": hmacHex,\n \"X-API-TIME\": `${timestamp}`,\n \"X-API-ID\": REGIONDO_PUBLIC_KEY,\n },\n });\n\n if (response.status !== 200) {\n return { fehler: `HTTP ${response.status}`, daten: [] };\n }\n\n const apiData = await response.json();\n let items = apiData.data || apiData || [];\n if (!Array.isArray(items)) items = [];\n\n return { daten: items, fehler: null };\n } catch (err: any) {\n return { fehler: err.message, daten: [] };\n }\n}\n\n// ============================================\n// HILFSFUNKTIONEN\n// ============================================\nfunction raumVonSuchwort(suchwort: string): string | null {\n suchwort = suchwort.toLowerCase().trim();\n for (const raum in RAUM_MAPPING) {\n if (raum.toLowerCase() === suchwort) return raum;\n for (const syn of RAUM_MAPPING[raum].synonyme) {\n if (\n syn.toLowerCase() === suchwort || suchwort.includes(syn.toLowerCase())\n ) return raum;\n }\n }\n return null;\n}\n\n// Typ für belegte Zeitfenster mit Dauer\ntype BelegterSlot = { zeit: string; dauer: number };\n\nfunction belegteZeitfensterErmitteln(\n buchungen: any[],\n datumStr: string,\n): Record {\n const belegt: Record = {};\n\n function slotHinzufuegen(raum: string, zeit: string, dauer: number) {\n if (!belegt[raum]) belegt[raum] = [];\n const existing = belegt[raum].find((s) => s.zeit === zeit);\n if (existing) {\n existing.dauer = Math.max(existing.dauer, dauer);\n } else {\n belegt[raum].push({ zeit, dauer });\n }\n }\n\n for (const b of buchungen) {\n const status = (b.status || \"\").toLowerCase();\n if (\n status === \"cancelled\" || status === \"refunded\" || status === \"storniert\"\n ) continue;\n\n const produktName = (b.product_name || \"\").toLowerCase();\n const variationName = (b.variation_name || \"\").toLowerCase();\n\n const eventDateTime = b.event_date_time || b.date_applied_for || \"\";\n const match = eventDateTime.match(/(\\d{2}):(\\d{2})/);\n if (!match) continue;\n const uhrzeit = match[1] + \":\" + match[2];\n\n // KOMBI-ERKENNUNG\n const istKombi = produktName.includes(\"kombi\") ||\n variationName.includes(\"kombi\");\n\n if (istKombi) {\n const groesseMatch = produktName.match(/(\\d)er/) ||\n variationName.match(/(\\d)er/);\n const kombiGroesse = groesseMatch ? parseInt(groesseMatch[1]) : 0;\n\n const resources = b.resources || [];\n const gefundeneRaeume: string[] = [];\n\n if (Array.isArray(resources) && resources.length > 0) {\n for (const res of resources) {\n const resName = (res.resource_name || \"\").toLowerCase();\n if (resName && PRODUKT_ZU_RAUM[resName]) {\n gefundeneRaeume.push(PRODUKT_ZU_RAUM[resName]);\n }\n }\n }\n\n if (gefundeneRaeume.length === 0) {\n for (const key in PRODUKT_ZU_RAUM) {\n if (\n variationName.includes(key) &&\n !gefundeneRaeume.includes(PRODUKT_ZU_RAUM[key])\n ) {\n gefundeneRaeume.push(PRODUKT_ZU_RAUM[key]);\n }\n }\n }\n\n if (gefundeneRaeume.length > 0) {\n for (const raum of gefundeneRaeume) {\n slotHinzufuegen(raum, uhrzeit, KOMBI_DAUER);\n }\n } else if (kombiGroesse >= 2 && kombiGroesse <= 4) {\n const standardRaeume = KOMBI_STANDARD[kombiGroesse] || [];\n for (const kr of standardRaeume) {\n slotHinzufuegen(kr, uhrzeit, KOMBI_DAUER);\n }\n } else {\n // Fallback: Alle 3 analogen Räume blockieren\n for (const kr of KOMBI_STANDARD[3] || []) {\n slotHinzufuegen(kr, uhrzeit, KOMBI_DAUER);\n }\n }\n continue;\n }\n\n // EINZELRAUM-ERKENNUNG\n let raumName: string | null = null;\n\n for (const key in PRODUKT_ZU_RAUM) {\n if (variationName.includes(key)) {\n raumName = PRODUKT_ZU_RAUM[key];\n break;\n }\n }\n if (!raumName) {\n for (const key in PRODUKT_ZU_RAUM) {\n if (produktName.includes(key)) {\n raumName = PRODUKT_ZU_RAUM[key];\n break;\n }\n }\n }\n if (!raumName) continue;\n\n const dauer = RAUM_DAUER[raumName] || 75;\n slotHinzufuegen(raumName, uhrzeit, dauer);\n }\n\n // VR-RÄUME SYNCHRONISIEREN\n const alleVrSlots: BelegterSlot[] = [];\n for (const vrRaum of VR_RAEUME) {\n for (const slot of (belegt[vrRaum] || [])) {\n if (\n !alleVrSlots.find((s) => s.zeit === slot.zeit && s.dauer === slot.dauer)\n ) {\n alleVrSlots.push({ ...slot });\n }\n }\n }\n if (alleVrSlots.length > 0) {\n for (const vrRaum of VR_RAEUME) {\n for (const slot of alleVrSlots) {\n if (!belegt[vrRaum]) belegt[vrRaum] = [];\n const existing = belegt[vrRaum].find((s) => s.zeit === slot.zeit);\n if (existing) {\n existing.dauer = Math.max(existing.dauer, slot.dauer);\n } else {\n belegt[vrRaum].push({ ...slot });\n }\n }\n }\n }\n\n return belegt;\n}\n\nfunction verfuegbarkeitErstellen(\n belegteSlots: Record,\n datumStr: string,\n raumFilter: string | null,\n) {\n const ergebnis: any[] = [];\n const raeume = raumFilter ? [raumFilter] : Object.keys(RAUM_MAPPING);\n\n for (const raum of raeume) {\n const raumInfo = RAUM_MAPPING[raum];\n if (!raumInfo) continue;\n\n const istVR = VR_RAEUME.includes(raum);\n const startzeiten = istVR ? VR_STARTZEITEN : ANALOG_STARTZEITEN;\n const spielDauer = RAUM_DAUER[raum] || 75;\n const belegteZeiten = belegteSlots[raum] || [];\n\n if (belegteZeiten.length === 0) {\n const alleZeiten = startzeiten.map((m) => minZuZeit(m) + \" Uhr\");\n ergebnis.push({\n raum: raumInfo.anzeige,\n status: \"frei\",\n freie_startzeiten: alleZeiten,\n info: \"Verfügbare Startzeiten: \" + alleZeiten.join(\", \"),\n });\n continue;\n }\n\n const slots = belegteZeiten\n .map((s) => {\n const t = s.zeit.split(\":\");\n const start = parseInt(t[0]) * 60 + parseInt(t[1]);\n return { start, end: start + s.dauer };\n })\n .sort((a, b) => a.start - b.start);\n\n const merged: { start: number; end: number }[] = [];\n for (const s of slots) {\n if (merged.length > 0 && s.start < merged[merged.length - 1].end) {\n merged[merged.length - 1].end = Math.max(\n merged[merged.length - 1].end,\n s.end,\n );\n } else merged.push({ ...s });\n }\n\n const freieZeiten: string[] = [];\n for (const gridZeit of startzeiten) {\n const spielEnde = gridZeit + spielDauer;\n let blockiert = false;\n for (const belegung of merged) {\n if (gridZeit < belegung.end && belegung.start < spielEnde) {\n blockiert = true;\n break;\n }\n }\n if (!blockiert) {\n freieZeiten.push(minZuZeit(gridZeit) + \" Uhr\");\n }\n }\n\n if (freieZeiten.length === 0) {\n ergebnis.push({\n raum: raumInfo.anzeige,\n status: \"ausgebucht\",\n info:\n \"Heute leider vollständig ausgebucht – keine freien Startzeiten mehr.\",\n });\n } else {\n ergebnis.push({\n raum: raumInfo.anzeige,\n status: freieZeiten.length === startzeiten.length\n ? \"frei\"\n : \"teilweise frei\",\n freie_startzeiten: freieZeiten,\n info: \"Verfügbare Startzeiten: \" + freieZeiten.join(\", \"),\n });\n }\n }\n return ergebnis;\n}\n\nfunction minZuZeit(min: number): string {\n const h = Math.floor(min / 60);\n const m = min % 60;\n return (h < 10 ? \"0\" : \"\") + h + \":\" + (m < 10 ? \"0\" : \"\") + m;\n}\n\nfunction jsonAntwort(daten: any, statusCode = 200): Response {\n return new Response(JSON.stringify(daten, null, 2), {\n status: statusCode,\n headers: { \"Content-Type\": \"application/json\" },\n });\n}","createdAt",["D",1772453458265],"branchVersion","branchId","83d55cfa-1538-11f1-b9af-42dde27851f2","id","83d152d6-1538-11f1-b9af-42dde27851f2","val_town_verfuegbarkeit_han",["D",1772346789887],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019c87b9-4138-776a-aed4-0bc499a5d82b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c87b9-4138-776a-aed4-0db6eac961d6","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":87,"_88":89,"_90":50,"_91":92,"_93":62,"_94":45,"_95":96},"isOwned",11,"main","projectId","forkedBranchId","cf02a2f0-1047-11f1-b9e4-42dde27851f2","forkedBranchVersion",15,"forkedProjectPrivacy","forkedProjectId","cf01bffc-1047-11f1-b9e4-42dde27851f2","forkedProjectOrgId","projectName","userHandle","escape","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNBMnZmRHpPY253TEl6V3I0eDNwY1JmeU9qMCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":163,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":164,"_78":165,"_80":166,"_82":25},"tree",[158],"files",[158],"counts",{"_146":60,"_147":148,"_149":60,"_150":151,"_152":153},"contents",[138],"upstreamProject",{"_43":92,"_32":136,"_52":-5,"_53":-5,"_49":50,"_76":137},"upstreamBranch",{"_43":87,"_38":130,"_131":132,"_32":84,"_85":92,"_13":133,"_86":-5,"_88":-5,"_134":135,"_47":-5,"_82":25,"_49":50,"_95":96,"_61":62,"_94":136},"emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},["D",1771803602680],"updatedAt",["D",1787904384934],29,"lockfileKey","1787904385110-esm.town_v_escape_val_town_verfuegbarkeit_LPZ@29-main","val_town_verfuegbarkeit_LPZ",{"_97":96,"_104":100},{"_43":139,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_141":25,"_38":142,"_13":143,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":145},"df1f2426-1630-11f1-a39e-42dde27851f2","parentId","latest",["D",1772453458265],4,"label",[28],"pulls","branches",1,"forks","envVars",{"_154":156,"_157":60},"connections",{"_154":60,"_155":60},"count","unfilledCount",3,"emptyCount",{"_43":139,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_141":25,"_38":159,"_13":143,"_33":34,"_35":37,"_24":25,"_144":-5,"_160":161,"_27":162},["D",1772453458265],"children",[],[28],["D",1772346789887],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":87,"_88":89,"_90":50,"_91":92,"_93":62,"_94":45,"_95":96},"ctx",{"_76":-5,"_127":200,"_201":202,"_203":204,"_205":25,"_206":25,"_207":25,"_208":125,"_209":-5,"_210":-7,"_211":-7,"_212":60,"_213":25,"_214":25,"_215":-5,"_216":25,"_217":25,"_218":25,"_219":-5},"ENV",{"_171":172,"_173":174,"_175":84,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v5