[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_166":167,"_168":169},"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",4,"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","import { createHmac } from \"node:crypto\";\n\n// ── Konfiguration ───────────────────────────────────────────\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\n// ── Raum-Zuordnungen ────────────────────────────────────────\n// Jeder Schlüssel ist der interne Name; \"anzeige\" = Anzeigename,\n// \"synonyme\" = Begriffe, die Kunden am Telefon verwenden könnten.\n\nconst RAUM_MAPPING: Record = {\n Dungeon: {\n anzeige: \"Hannover Dungeon (Expeditionsraum)\",\n synonyme: [\n \"dungeon\",\n \"mittelalter\",\n \"expedition\",\n \"expeditionsraum\",\n \"hannover dungeon\",\n \"kerker\",\n \"verlies\",\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 Verschwörung (Krimiraum)\",\n synonyme: [\n \"bitcoin\",\n \"krimi\",\n \"krimiraum\",\n \"bitcoin verschwörung\",\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 Medusa's Gate (VR)\",\n synonyme: [\n \"medusa\",\n \"medusas gate\",\n \"medusa gate\",\n \"ubisoft medusa\",\n \"medusaraum\",\n ],\n },\n Sigma: {\n anzeige: \"Mission Sigma (VR)\",\n synonyme: [\n \"sigma\",\n \"mission sigma\",\n \"rakete\",\n \"raketenraum\",\n \"biowaffe\",\n ],\n },\n Jungle: {\n anzeige: \"Jungle Quest (VR)\",\n synonyme: [\n \"jungle\",\n \"jungle quest\",\n \"dschungel\",\n \"jungleraum\",\n ],\n },\n Weihnachten: {\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: [\n \"alice\",\n \"wunderland\",\n \"alice im wunderland\",\n \"wunderlandraum\",\n ],\n },\n Welten: {\n anzeige: \"Escape the Worlds (VR)\",\n synonyme: [\n \"welten\",\n \"escape worlds\",\n \"escape the worlds\",\n \"weltenraum\",\n \"worlds\",\n ],\n },\n Dream: {\n anzeige: \"Dream Hackers (VR)\",\n synonyme: [\n \"dream\",\n \"dream hackers\",\n \"traumjäger\",\n \"traumjägerraum\",\n \"träume\",\n ],\n },\n Prison: {\n anzeige: \"The Prison (VR)\",\n synonyme: [\n \"prison\",\n \"the prison\",\n \"gefängnis\",\n \"gefängnisraum\",\n \"knast\",\n ],\n },\n Arcade: {\n anzeige: \"VR Erlebniswelten (Arcade)\",\n synonyme: [\n \"arcade\",\n \"erlebniswelten\",\n \"vr arcade\",\n \"vr erlebniswelten\",\n \"beat saber\",\n \"elven assassin\",\n ],\n },\n};\n\n// Regiondo-Produktnamen → interner Raumschlüssel\nconst PRODUKT_ZU_RAUM: Record = {\n Dungeon: \"Dungeon\",\n \"Hannover Dungeon\": \"Dungeon\",\n \"Expedition ins Mittelalter\": \"Dungeon\",\n Expedition: \"Dungeon\",\n \"Harrys Zauberschule\": \"Zauber\",\n Zauberschule: \"Zauber\",\n Zauber: \"Zauber\",\n \"Die Bitcoin Verschwörung\": \"Bitcoin\",\n Bitcoin: \"Bitcoin\",\n \"Bitcoin Verschwörung\": \"Bitcoin\",\n \"Escape The Lost Pyramid\": \"Pyramide\",\n Pyramide: \"Pyramide\",\n \"Beyond Medusa's Gate\": \"Medusa\",\n Medusa: \"Medusa\",\n \"Mission Sigma\": \"Sigma\",\n Sigma: \"Sigma\",\n \"Jungle Quest\": \"Jungle\",\n Jungle: \"Jungle\",\n Christmas: \"Weihnachten\",\n Weihnachten: \"Weihnachten\",\n Alice: \"Alice\",\n \"Alice im Wunderland\": \"Alice\",\n \"Escape the Worlds\": \"Welten\",\n \"Escape Worlds\": \"Welten\",\n Welten: \"Welten\",\n \"Dream Hackers\": \"Dream\",\n Dream: \"Dream\",\n \"The Prison\": \"Prison\",\n Prison: \"Prison\",\n \"VR Erlebniswelten\": \"Arcade\",\n Arcade: \"Arcade\",\n};\n\n// Spieldauer je Raum in Minuten (analog 75, VR 50 wegen Einweisung)\nconst RAUM_DAUER: Record = {\n Dungeon: 75,\n Zauber: 75,\n Bitcoin: 75,\n Pyramide: 50,\n Medusa: 50,\n Sigma: 50,\n Jungle: 50,\n Weihnachten: 50,\n Alice: 50,\n Welten: 50,\n Dream: 50,\n Prison: 50,\n Arcade: 50,\n};\n\n// Kombi-Modus: Standard-Raumkombinationen nach Raumanzahl\nconst KOMBI_STANDARD: Record = {\n 2: [\"Zauber\", \"Dungeon\"],\n 3: [\"Zauber\", \"Dungeon\", \"Bitcoin\"],\n};\n\n// Alle VR-Räume teilen sich eine VR-Station →\n// wenn einer belegt ist, sind alle blockiert.\nconst VR_RAEUME = [\n \"Pyramide\",\n \"Medusa\",\n \"Sigma\",\n \"Jungle\",\n \"Weihnachten\",\n \"Alice\",\n \"Welten\",\n \"Dream\",\n \"Prison\",\n \"Arcade\",\n];\n\n// ── Hauptfunktion (HTTP-Handler) ────────────────────────────\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const params = url.searchParams;\n\n // Parameter prüfen\n const apiKey = params.get(\"api_key\");\n if (apiKey !== ROSA_API_KEY) {\n return jsonAntwort({ fehler: \"Ungültiger API-Schlüssel\" }, 403);\n }\n\n const datum = params.get(\"datum\"); // YYYY-MM-DD\n if (!datum || !/^\\d{4}-\\d{2}-\\d{2}$/.test(datum)) {\n return jsonAntwort(\n { fehler: \"Parameter 'datum' fehlt oder ungültig (YYYY-MM-DD)\" },\n 400,\n );\n }\n\n const raumParam = params.get(\"raum\"); // optional\n const kombiParam = params.get(\"kombi\"); // optional: Anzahl Räume\n\n // Buchungen von Regiondo laden\n const buchungen = await regiondoBuchungenLaden(datum);\n if (buchungen === null) {\n return jsonAntwort(\n { fehler: \"Regiondo-API nicht erreichbar\" },\n 502,\n );\n }\n\n // Belegte Zeitfenster ermitteln\n const belegt = belegteZeitfensterErmitteln(buchungen);\n\n // Verfügbarkeit berechnen\n let ergebnis: any;\n if (kombiParam) {\n const anzahl = parseInt(kombiParam, 10);\n const raeume = KOMBI_STANDARD[anzahl];\n if (!raeume) {\n return jsonAntwort(\n {\n fehler: `Kombi mit ${anzahl} Räumen nicht verfügbar. Möglich: ${\n Object.keys(KOMBI_STANDARD).join(\", \")\n }`,\n },\n 400,\n );\n }\n ergebnis = verfuegbarkeitErstellen(raeume, belegt, datum, true);\n } else if (raumParam) {\n const raum = raumVonSuchwort(raumParam);\n if (!raum) {\n return jsonAntwort(\n {\n fehler: `Raum \"${raumParam}\" nicht gefunden`,\n verfuegbare_raeume: Object.keys(RAUM_MAPPING),\n },\n 404,\n );\n }\n ergebnis = verfuegbarkeitErstellen([raum], belegt, datum, false);\n } else {\n // Alle Räume\n ergebnis = verfuegbarkeitErstellen(\n Object.keys(RAUM_MAPPING),\n belegt,\n datum,\n false,\n );\n }\n\n return jsonAntwort({ datum, ...ergebnis });\n}\n\n// ── Regiondo-Buchungen laden ────────────────────────────────\nasync function regiondoBuchungenLaden(datum: string) {\n const queryParams =\n `date_range=${datum}%2C${datum}&date_range_by=date_of_event&limit=200&offset=0`;\n const zeitstempel = Date.now().toString();\n\n const signaturDaten = zeitstempel + REGIONDO_PUBLIC_KEY + queryParams;\n const signatur = createHmac(\"sha256\", REGIONDO_SECRET_KEY)\n .update(signaturDaten)\n .digest(\"hex\");\n\n try {\n const antwort = await fetch(\n `${REGIONDO_API_URL}/supplier/bookings?${queryParams}`,\n {\n headers: {\n \"X-API-ID\": REGIONDO_PUBLIC_KEY,\n \"X-API-TIME\": zeitstempel,\n \"X-API-HASH\": signatur,\n Accept: \"application/json\",\n },\n },\n );\n if (!antwort.ok) return null;\n const daten = await antwort.json();\n return Array.isArray(daten) ? daten : daten.data ?? [];\n } catch {\n return null;\n }\n}\n\n// ── Raum anhand eines Suchworts finden ──────────────────────\nfunction raumVonSuchwort(suchwort: string): string | null {\n const s = suchwort.toLowerCase().trim();\n // Exakter Schlüssel?\n if (RAUM_MAPPING[suchwort]) return suchwort;\n // Synonym-Suche\n for (const [schluessel, info] of Object.entries(RAUM_MAPPING)) {\n if (\n info.synonyme.some((syn) => s.includes(syn) || syn.includes(s))\n ) {\n return schluessel;\n }\n }\n return null;\n}\n\n// ── Belegte Zeitfenster aus Buchungen ermitteln ─────────────\nfunction belegteZeitfensterErmitteln(\n buchungen: any[],\n): Record {\n const belegt: Record = {};\n\n for (const b of buchungen) {\n const status = (b.status ?? \"\").toLowerCase();\n if (status === \"canceled\" || status === \"cancelled\") continue;\n\n const produktName = b.product_name ?? b.productName ?? \"\";\n let raum = PRODUKT_ZU_RAUM[produktName] ?? null;\n\n // Falls nicht direkt gefunden → Teilstring-Suche\n if (!raum) {\n for (const [pName, rName] of Object.entries(PRODUKT_ZU_RAUM)) {\n if (produktName.includes(pName)) {\n raum = rName;\n break;\n }\n }\n }\n if (!raum) continue;\n\n // Startzeit parsen\n const startStr = b.start_date ?? b.startDate ?? b.date ?? \"\";\n const startMatch = startStr.match(/(\\d{2}):(\\d{2})/);\n if (!startMatch) continue;\n const startMin = parseInt(startMatch[1]) * 60 + parseInt(startMatch[2]);\n const dauer = RAUM_DAUER[raum] ?? 60;\n\n const slot = { von: startMin, bis: startMin + dauer };\n\n // Raum belegen\n if (!belegt[raum]) belegt[raum] = [];\n belegt[raum].push(slot);\n\n // VR-Räume blockieren sich gegenseitig\n if (VR_RAEUME.includes(raum)) {\n for (const vr of VR_RAEUME) {\n if (vr !== raum) {\n if (!belegt[vr]) belegt[vr] = [];\n belegt[vr].push(slot);\n }\n }\n }\n\n // Kombi-Buchungen: mehrere Räume gleichzeitig\n const kombiMatch = produktName.match(/(\\d)er[\\s-]?Kombi/i);\n if (kombiMatch) {\n const anz = parseInt(kombiMatch[1]);\n const kombiRaeume = KOMBI_STANDARD[anz];\n if (kombiRaeume) {\n for (const kr of kombiRaeume) {\n if (kr !== raum) {\n if (!belegt[kr]) belegt[kr] = [];\n belegt[kr].push(slot);\n }\n }\n }\n }\n }\n return belegt;\n}\n\n// ── Verfügbarkeit berechnen ─────────────────────────────────\nfunction verfuegbarkeitErstellen(\n raeume: string[],\n belegt: Record,\n datum: string,\n istKombi: boolean,\n) {\n const OEFFNUNG = 9 * 60; // 09:00\n const SCHLIESSUNG = 21 * 60; // 21:00\n\n const jetzt = new Date();\n const heute = `${jetzt.getFullYear()}-${\n String(jetzt.getMonth() + 1).padStart(2, \"0\")\n }-${String(jetzt.getDate()).padStart(2, \"0\")}`;\n const istHeute = datum === heute;\n const aktuelleMinute = istHeute\n ? jetzt.getHours() * 60 + jetzt.getMinutes()\n : 0;\n\n const ergebnis: Record = {};\n\n if (istKombi) {\n // Kombi: gemeinsame freie Fenster für alle Räume\n const dauer = Math.max(...raeume.map((r) => RAUM_DAUER[r] ?? 60));\n let start = OEFFNUNG;\n const fenster: string[] = [];\n\n while (start + dauer <= SCHLIESSUNG) {\n if (istHeute && start < aktuelleMinute + 30) {\n start += 15;\n continue;\n }\n const alleFrei = raeume.every((r) => {\n const slots = belegt[r] ?? [];\n return !slots.some(\n (s) => start < s.bis && start + dauer > s.von,\n );\n });\n if (alleFrei) fenster.push(`${mzz(start)}–${mzz(start + dauer)}`);\n start += 15;\n }\n\n ergebnis.kombi = {\n raeume: raeume.map((r) => RAUM_MAPPING[r]?.anzeige ?? r),\n freie_fenster: fenster,\n };\n } else {\n for (const raum of raeume) {\n const dauer = RAUM_DAUER[raum] ?? 60;\n let start = OEFFNUNG;\n const fenster: string[] = [];\n\n while (start + dauer <= SCHLIESSUNG) {\n if (istHeute && start < aktuelleMinute + 30) {\n start += 15;\n continue;\n }\n const slots = belegt[raum] ?? [];\n const frei = !slots.some(\n (s) => start < s.bis && start + dauer > s.von,\n );\n if (frei) fenster.push(`${mzz(start)}–${mzz(start + dauer)}`);\n start += 15;\n }\n\n ergebnis[raum] = {\n anzeige: RAUM_MAPPING[raum]?.anzeige ?? raum,\n dauer_minuten: dauer,\n freie_fenster: fenster,\n };\n }\n }\n\n return { verfuegbarkeit: ergebnis };\n}\n\n// ── Hilfsfunktionen ─────────────────────────────────────────\nfunction mzz(minuten: number): string {\n const h = Math.floor(minuten / 60);\n const m = minuten % 60;\n return `${String(h).padStart(2, \"0\")}:${String(m).padStart(2, \"0\")}`;\n}\n\nfunction jsonAntwort(daten: any, status = 200): Response {\n return new Response(JSON.stringify(daten, null, 2), {\n status,\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}","/**\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}","createdAt",["D",1772393867820],"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":162,"_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":163,"_78":164,"_80":165,"_82":25},"tree",[157],"files",[157],"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},"207c5c94-15a6-11f1-89b7-42dde27851f2","parentId","latest",["D",1772393867820],3,"label",[28],"pulls","branches",1,"forks","envVars",{"_154":143,"_156":60},"connections",{"_154":60,"_155":60},"count","unfilledCount","emptyCount",{"_43":139,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_141":25,"_38":158,"_13":143,"_33":34,"_35":37,"_24":25,"_144":-5,"_159":160,"_27":161},["D",1772393867820],"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":199,"_200":201,"_202":203,"_204":25,"_205":25,"_206":25,"_207":125,"_208":-5,"_209":-7,"_210":-7,"_211":60,"_212":25,"_213":25,"_214":-5,"_215":25,"_216":25,"_217":25,"_218":-5},"ENV",{"_170":171,"_172":173,"_174":84,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198},"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 · v4