Masuk - Game Kelas Seru

\n \n\n`;\n}",[],[169,295],"09ba6577-b473-49aa-9a81-e42b22b80d3a","hub.ts","08121762-9dc2-11f1-be5f-1607ee4eb77e",428,["D",1788163490185],9,"export async function renderHub(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Game Kelas Seru\n \n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[169,303],["D",1787359193118],[275,276],[169],"ca437af3-dec9-49ed-93c8-a315c66a8e7a","powerups.ts","30adae82-a215-11f1-a957-1607ee4eb77e",257,["D",1787874197716],"// ============================================================\n// KEJUTAN SKOR — Mesin Power-Up Acak untuk Semua Game\n// Dipakai oleh: Kuis Kotak, Roda Putar, Kuis Pilihan Ganda.\n// Modul ini murni backend (dipanggil dari router.ts tiap game),\n// jadi logikanya cukup ditulis SEKALI dan konsisten di semua game.\n// Hanya aktif kalau guru menyalakan opsi \"Kejutan Skor Acak\" di sesi.\n// ============================================================\n\nexport interface TimSkor {\n id: string;\n nama_tim: string;\n skor: number;\n}\n\nexport interface HasilKejutan {\n kode: string;\n nama: string;\n emoji: string;\n pesan: string;\n timUpdates: { id: string; skorBaru: number }[];\n}\n\nexport interface KatalogKejutan {\n kode: string;\n nama: string;\n emoji: string;\n kategori: \"mandiri\" | \"antar-tim\" | \"posisi\";\n}\n\ninterface DefinisiKejutan {\n kode: string;\n nama: string;\n emoji: string;\n kategori: \"mandiri\" | \"antar-tim\" | \"posisi\";\n jalankan: (\n timList: TimSkor[],\n timPembukaId: string,\n poinRonde: number,\n ) => HasilKejutan;\n}\n\n// Peluang munculnya kejutan setiap kali sebuah tim menjawab BENAR.\nexport const PELUANG_KEJUTAN = 0.25;\n\nfunction acak(min: number, max: number): number {\n return Math.floor(Math.random() * (max - min + 1)) + min;\n}\nfunction pilihAcak(arr: T[]): T | null {\n if (arr.length === 0) return null;\n return arr[Math.floor(Math.random() * arr.length)];\n}\nfunction timLawan(timList: TimSkor[], kecualiId: string): TimSkor[] {\n return timList.filter((t) => t.id !== kecualiId);\n}\nfunction timTerunggul(timList: TimSkor[]): TimSkor {\n return [...timList].sort((a, b) => b.skor - a.skor)[0];\n}\nfunction timTerbuncit(timList: TimSkor[]): TimSkor {\n return [...timList].sort((a, b) => a.skor - b.skor)[0];\n}\nfunction kejutanBatal(\n def: { kode: string; nama: string; emoji: string },\n tim: TimSkor,\n): HasilKejutan {\n return {\n kode: def.kode,\n nama: def.nama,\n emoji: def.emoji,\n pesan: `${def.nama} muncul tapi tidak ada tim lawan, jadi dibatalkan.`,\n timUpdates: [{ id: tim.id, skorBaru: tim.skor }],\n };\n}\n\nexport const DAFTAR_KEJUTAN: DefinisiKejutan[] = [\n // ===================== 1. MANIPULASI POIN MANDIRI =====================\n {\n kode: \"harta_karun\",\n nama: \"Harta Karun\",\n emoji: \"\\ud83d\\udcb0\",\n kategori: \"mandiri\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n return {\n kode: \"harta_karun\",\n nama: \"Harta Karun\",\n emoji: \"\\ud83d\\udcb0\",\n pesan: `${tim.nama_tim} menemukan Harta Karun! +50 poin!`,\n timUpdates: [{ id: tim.id, skorBaru: tim.skor + 50 }],\n };\n },\n },\n {\n kode: \"kado_misteri\",\n nama: \"Kado Misteri\",\n emoji: \"\\ud83c\\udf81\",\n kategori: \"mandiri\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const bonus = acak(5, 25);\n return {\n kode: \"kado_misteri\",\n nama: \"Kado Misteri\",\n emoji: \"\\ud83c\\udf81\",\n pesan: `${tim.nama_tim} membuka Kado Misteri! +${bonus} poin!`,\n timUpdates: [{ id: tim.id, skorBaru: tim.skor + bonus }],\n };\n },\n },\n {\n kode: \"ledakan_apes\",\n nama: \"Ledakan Apes\",\n emoji: \"\\ud83d\\udca5\",\n kategori: \"mandiri\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n return {\n kode: \"ledakan_apes\",\n nama: \"Ledakan Apes\",\n emoji: \"\\ud83d\\udca5\",\n pesan: `Dor! ${tim.nama_tim} kena Ledakan Apes! -50 poin!`,\n timUpdates: [{ id: tim.id, skorBaru: tim.skor - 50 }],\n };\n },\n },\n {\n kode: \"zonk_kecil\",\n nama: \"Zonk Kecil\",\n emoji: \"\\ud83c\\udf29\\ufe0f\",\n kategori: \"mandiri\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const kurang = acak(5, 25);\n return {\n kode: \"zonk_kecil\",\n nama: \"Zonk Kecil\",\n emoji: \"\\ud83c\\udf29\\ufe0f\",\n pesan: `Yah, ${tim.nama_tim} kena Zonk Kecil! -${kurang} poin!`,\n timUpdates: [{ id: tim.id, skorBaru: tim.skor - kurang }],\n };\n },\n },\n {\n kode: \"jebakan_betmen\",\n nama: \"Jebakan Betmen\",\n emoji: \"\\ud83d\\udd73\\ufe0f\",\n kategori: \"mandiri\",\n jalankan(timList, timPembukaId, poinRonde) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n // Poin ronde ini dibatalkan (dikembalikan seperti sebelum ronde berjalan).\n return {\n kode: \"jebakan_betmen\",\n nama: \"Jebakan Betmen\",\n emoji: \"\\ud83d\\udd73\\ufe0f\",\n pesan: `${tim.nama_tim} masuk Jebakan Betmen! Poin ronde ini batal.`,\n timUpdates: [{ id: tim.id, skorBaru: tim.skor - poinRonde }],\n };\n },\n },\n {\n kode: \"bintang_ganda\",\n nama: \"Bintang Ganda\",\n emoji: \"\\u2b50\",\n kategori: \"mandiri\",\n jalankan(timList, timPembukaId, poinRonde) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n return {\n kode: \"bintang_ganda\",\n nama: \"Bintang Ganda\",\n emoji: \"\\u2b50\",\n pesan:\n `${tim.nama_tim} dapat Bintang Ganda! Poin ronde ini digandakan (+${poinRonde})!`,\n timUpdates: [{ id: tim.id, skorBaru: tim.skor + poinRonde }],\n };\n },\n },\n\n // =============== 2. INTERAKSI & TRANSFER POIN ANTAR-TIM ===============\n {\n kode: \"sedot_poin\",\n nama: \"Sedot Poin\",\n emoji: \"\\ud83e\\udde7\",\n kategori: \"antar-tim\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const lawan = pilihAcak(timLawan(timList, timPembukaId));\n if (!lawan) {\n return kejutanBatal(\n { kode: \"sedot_poin\", nama: \"Sedot Poin\", emoji: \"\\ud83e\\udde7\" },\n tim,\n );\n }\n const jumlah = acak(10, 30);\n return {\n kode: \"sedot_poin\",\n nama: \"Sedot Poin\",\n emoji: \"\\ud83e\\udde7\",\n pesan:\n `${tim.nama_tim} menyedot ${jumlah} poin dari ${lawan.nama_tim}!`,\n timUpdates: [\n { id: tim.id, skorBaru: tim.skor + jumlah },\n { id: lawan.id, skorBaru: lawan.skor - jumlah },\n ],\n };\n },\n },\n {\n kode: \"peri_nakal\",\n nama: \"Peri Nakal\",\n emoji: \"\\ud83e\\uddda\",\n kategori: \"antar-tim\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const lawanList = timLawan(timList, timPembukaId);\n if (lawanList.length === 0) {\n return kejutanBatal(\n { kode: \"peri_nakal\", nama: \"Peri Nakal\", emoji: \"\\ud83e\\uddda\" },\n tim,\n );\n }\n const target = timTerunggul(lawanList);\n const jumlah = acak(10, 30);\n return {\n kode: \"peri_nakal\",\n nama: \"Peri Nakal\",\n emoji: \"\\ud83e\\uddda\",\n pesan:\n `Peri Nakal mencuri ${jumlah} poin milik ${target.nama_tim} (tim terdepan) untuk ${tim.nama_tim}!`,\n timUpdates: [\n { id: tim.id, skorBaru: tim.skor + jumlah },\n { id: target.id, skorBaru: target.skor - jumlah },\n ],\n };\n },\n },\n {\n kode: \"hiu_lapar\",\n nama: \"Hiu Lapar\",\n emoji: \"\\ud83e\\udd88\",\n kategori: \"antar-tim\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const target = pilihAcak(timLawan(timList, timPembukaId));\n if (!target) {\n return kejutanBatal(\n { kode: \"hiu_lapar\", nama: \"Hiu Lapar\", emoji: \"\\ud83e\\udd88\" },\n tim,\n );\n }\n const kurang = acak(15, 40);\n return {\n kode: \"hiu_lapar\",\n nama: \"Hiu Lapar\",\n emoji: \"\\ud83e\\udd88\",\n pesan:\n `Hiu Lapar menggigit skor ${target.nama_tim}! -${kurang} poin (tidak untuk siapa-siapa).`,\n timUpdates: [{ id: target.id, skorBaru: target.skor - kurang }],\n };\n },\n },\n {\n kode: \"pelampung_solidaritas\",\n nama: \"Pelampung Solidaritas\",\n emoji: \"\\ud83d\\udedf\",\n kategori: \"antar-tim\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const lawanList = timLawan(timList, timPembukaId);\n if (lawanList.length === 0) {\n return kejutanBatal({\n kode: \"pelampung_solidaritas\",\n nama: \"Pelampung Solidaritas\",\n emoji: \"\\ud83d\\udedf\",\n }, tim);\n }\n const target = timTerbuncit(lawanList);\n const jumlah = acak(5, 20);\n return {\n kode: \"pelampung_solidaritas\",\n nama: \"Pelampung Solidaritas\",\n emoji: \"\\ud83d\\udedf\",\n pesan:\n `${tim.nama_tim} melempar Pelampung Solidaritas ke ${target.nama_tim} (juru kunci): +${jumlah} poin untuk mereka!`,\n timUpdates: [\n { id: tim.id, skorBaru: tim.skor - jumlah },\n { id: target.id, skorBaru: target.skor + jumlah },\n ],\n };\n },\n },\n {\n kode: \"kado_persahabatan\",\n nama: \"Kado Persahabatan\",\n emoji: \"\\ud83c\\udf97\\ufe0f\",\n kategori: \"antar-tim\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const target = pilihAcak(timLawan(timList, timPembukaId));\n if (!target) {\n return kejutanBatal({\n kode: \"kado_persahabatan\",\n nama: \"Kado Persahabatan\",\n emoji: \"\\ud83c\\udf97\\ufe0f\",\n }, tim);\n }\n const jumlah = 15;\n return {\n kode: \"kado_persahabatan\",\n nama: \"Kado Persahabatan\",\n emoji: \"\\ud83c\\udf97\\ufe0f\",\n pesan:\n `${tim.nama_tim} memberi Kado Persahabatan ${jumlah} poin ke ${target.nama_tim}!`,\n timUpdates: [\n { id: tim.id, skorBaru: tim.skor - jumlah },\n { id: target.id, skorBaru: target.skor + jumlah },\n ],\n };\n },\n },\n {\n kode: \"berbagi_berkah\",\n nama: \"Berbagi Berkah\",\n emoji: \"\\u2764\\ufe0f\",\n kategori: \"antar-tim\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const target = pilihAcak(timLawan(timList, timPembukaId));\n if (!target) {\n return kejutanBatal(\n {\n kode: \"berbagi_berkah\",\n nama: \"Berbagi Berkah\",\n emoji: \"\\u2764\\ufe0f\",\n },\n tim,\n );\n }\n const jumlah = Math.max(1, Math.round(Math.max(tim.skor, 0) * 0.1));\n return {\n kode: \"berbagi_berkah\",\n nama: \"Berbagi Berkah\",\n emoji: \"\\u2764\\ufe0f\",\n pesan:\n `${tim.nama_tim} berbagi berkah ${jumlah} poin (10% skornya) ke ${target.nama_tim}!`,\n timUpdates: [\n { id: tim.id, skorBaru: tim.skor - jumlah },\n { id: target.id, skorBaru: target.skor + jumlah },\n ],\n };\n },\n },\n {\n kode: \"jungkat_jungkit\",\n nama: \"Jungkat-Jungkit Skor\",\n emoji: \"\\u2696\\ufe0f\",\n kategori: \"antar-tim\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const target = pilihAcak(timLawan(timList, timPembukaId));\n if (!target) {\n return kejutanBatal({\n kode: \"jungkat_jungkit\",\n nama: \"Jungkat-Jungkit Skor\",\n emoji: \"\\u2696\\ufe0f\",\n }, tim);\n }\n return {\n kode: \"jungkat_jungkit\",\n nama: \"Jungkat-Jungkit Skor\",\n emoji: \"\\u2696\\ufe0f\",\n pesan:\n `Jungkat-Jungkit! Skor ${tim.nama_tim} dan ${target.nama_tim} tertukar!`,\n timUpdates: [\n { id: tim.id, skorBaru: target.skor },\n { id: target.id, skorBaru: tim.skor },\n ],\n };\n },\n },\n\n // =============== 3. PENGUBAH POSISI & DRAMA KELAS ===============\n {\n kode: \"roket_juara\",\n nama: \"Roket Juara\",\n emoji: \"\\ud83d\\ude80\",\n kategori: \"posisi\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const lain = timLawan(timList, timPembukaId);\n const puncak = lain.length\n ? Math.max(...lain.map((t) => t.skor))\n : tim.skor;\n return {\n kode: \"roket_juara\",\n nama: \"Roket Juara\",\n emoji: \"\\ud83d\\ude80\",\n pesan: `${tim.nama_tim} meluncur naik ke posisi PERTAMA!`,\n timUpdates: [{ id: tim.id, skorBaru: puncak + 10 }],\n };\n },\n },\n {\n kode: \"kulit_pisang\",\n nama: \"Kulit Pisang\",\n emoji: \"\\ud83c\\udf4c\",\n kategori: \"posisi\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n const lain = timLawan(timList, timPembukaId);\n const dasar = lain.length\n ? Math.min(...lain.map((t) => t.skor))\n : tim.skor;\n return {\n kode: \"kulit_pisang\",\n nama: \"Kulit Pisang\",\n emoji: \"\\ud83c\\udf4c\",\n pesan:\n `Aduh! ${tim.nama_tim} terpeleset Kulit Pisang ke posisi PALING BAWAH!`,\n timUpdates: [{ id: tim.id, skorBaru: dasar - 10 }],\n };\n },\n },\n {\n kode: \"wabah_nol\",\n nama: \"Wabah Nol\",\n emoji: \"\\ud83e\\udda0\",\n kategori: \"posisi\",\n jalankan(timList) {\n return {\n kode: \"wabah_nol\",\n nama: \"Wabah Nol\",\n emoji: \"\\ud83e\\udda0\",\n pesan: `Wabah Nol menyebar! Skor SEMUA tim direset ke 0!`,\n timUpdates: timList.map((t) => ({ id: t.id, skorBaru: 0 })),\n };\n },\n },\n {\n kode: \"penghapus_ajaib\",\n nama: \"Penghapus Ajaib\",\n emoji: \"\\ud83e\\uddfd\",\n kategori: \"posisi\",\n jalankan(timList, timPembukaId) {\n const tim = timList.find((t) => t.id === timPembukaId)!;\n return {\n kode: \"penghapus_ajaib\",\n nama: \"Penghapus Ajaib\",\n emoji: \"\\ud83e\\uddfd\",\n pesan:\n `${tim.nama_tim} kena Penghapus Ajaib! Skornya sendiri direset ke 0.`,\n timUpdates: [{ id: tim.id, skorBaru: 0 }],\n };\n },\n },\n];\n\n/**\n * Daftar katalog kejutan (tanpa logika `jalankan`) — dipakai untuk\n * menampilkan checklist pilihan ke guru di halaman \"Mulai Sesi\".\n */\nexport function getKatalogKejutan(): KatalogKejutan[] {\n return DAFTAR_KEJUTAN.map(({ kode, nama, emoji, kategori }) => ({\n kode,\n nama,\n emoji,\n kategori,\n }));\n}\n\n/**\n * Tentukan daftar kode kejutan yang boleh muncul untuk sebuah sesi,\n * berdasarkan data sesi dari database.\n * - Kalau `power_up_daftar` sudah tersimpan (array, termasuk array\n * kosong), itu yang jadi acuan — hasil pilihan checklist guru.\n * - Kalau belum ada (sesi lama sebelum fitur checklist ini ada),\n * jatuh balik ke saklar lama `power_up_aktif`: true berarti semua\n * kejutan boleh muncul (perilaku lama), false/kosong berarti mati.\n */\nexport function daftarAktifDariSesi(\n sesi: { power_up_aktif?: boolean; power_up_daftar?: string[] | null },\n): string[] | null {\n if (Array.isArray(sesi.power_up_daftar)) return sesi.power_up_daftar;\n return sesi.power_up_aktif ? null : [];\n}\n\n/**\n * Coba munculkan satu kejutan skor acak untuk tim yang baru saja\n * menjawab BENAR. Kembalikan `null` kalau kejutan tidak muncul\n * (sesuai PELUANG_KEJUTAN) atau kalau tim tidak ditemukan.\n * poinRonde = poin yang baru saja didapat tim itu di ronde ini.\n * daftarAktif = daftar kode kejutan yang boleh dipilih untuk sesi ini.\n * - `null`/`undefined` = semua kejutan boleh muncul.\n * - array kosong `[]` = tidak ada yang boleh muncul (mati total).\n * - array berisi kode = hanya diundi dari kode-kode itu saja.\n */\nexport function rollKejutanSkor(\n timList: TimSkor[],\n timPembukaId: string,\n poinRonde: number,\n daftarAktif?: string[] | null,\n): HasilKejutan | null {\n if (Array.isArray(daftarAktif) && daftarAktif.length === 0) return null;\n if (Math.random() > PELUANG_KEJUTAN) return null;\n const tim = timList.find((t) => t.id === timPembukaId);\n if (!tim) return null;\n const kandidat = Array.isArray(daftarAktif) && daftarAktif.length > 0\n ? DAFTAR_KEJUTAN.filter((d) => daftarAktif.includes(d.kode))\n : DAFTAR_KEJUTAN;\n const def = pilihAcak(kandidat);\n if (!def) return null;\n return def.jalankan(timList, timPembukaId, poinRonde);\n}",[],[176,315],"88d5008f-d9fc-4c3c-83da-30a776b6269f","cloudinary.ts","5c8ad3fc-a33e-11f1-ac82-1607ee4eb77e",306,["D",1787962391207],"// ============================================================\n// CLOUDINARY — Signed Upload Helper\n// ------------------------------------------------------------\n// Dipakai supaya guru bisa upload gambar (soal/opsi jawaban)\n// langsung dari browser ke Cloudinary, TANPA API Secret pernah\n// terkirim ke browser. Alurnya:\n// 1. Browser minta \"tanda tangan\" ke server kita (endpoint ini).\n// 2. Server hitung signature pakai API Secret (rahasia, cuma di\n// server) + timestamp + folder tujuan.\n// 3. Browser pakai signature itu untuk upload LANGSUNG ke\n// Cloudinary (server kita tidak ikut menyimpan file-nya).\n//\n// Folder diberi awalan \"game-kelas-seru/\" supaya aman dipakai\n// berbarengan dengan aplikasi lain yang berbagi akun Cloudinary\n// yang sama — tidak akan tercampur.\n// ============================================================\n\nfunction keHex(buffer: ArrayBuffer): string {\n return Array.from(new Uint8Array(buffer))\n .map((b) => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n}\n\nexport async function buatSignatureUpload(subFolder: string) {\n const apiKey = Deno.env.get(\"CLOUDINARY_API_KEY\");\n const apiSecret = Deno.env.get(\"CLOUDINARY_API_SECRET\");\n const cloudName = Deno.env.get(\"CLOUDINARY_CLOUD_NAME\");\n if (!apiKey || !apiSecret || !cloudName) {\n throw new Error(\n \"Konfigurasi Cloudinary belum lengkap. Pastikan CLOUDINARY_CLOUD_NAME, CLOUDINARY_API_KEY, dan CLOUDINARY_API_SECRET sudah diisi di Environment Variables Val Town.\",\n );\n }\n\n const folder = \"game-kelas-seru/\" + subFolder;\n const timestamp = Math.floor(Date.now() / 1000);\n\n // Aturan Cloudinary: parameter yang ditandatangani harus diurutkan\n // alfabetis berdasar nama key, digabung \"key=value&key=value\", lalu\n // API Secret ditempel di paling akhir SEBELUM di-hash SHA-1.\n const paramsUntukTandaTangan = `folder=${folder}×tamp=${timestamp}`;\n const stringUntukHash = paramsUntukTandaTangan + apiSecret;\n const digest = await crypto.subtle.digest(\n \"SHA-1\",\n new TextEncoder().encode(stringUntukHash),\n );\n const signature = keHex(digest);\n\n return { timestamp, signature, apiKey, cloudName, folder };\n}",[],[176,323],["D",1787834717985],[272,273],[176],"9d029695-a3c8-4319-b1eb-b7f28ccabcd9","router.ts","325b3c86-a274-11f1-be50-1607ee4eb77e","24425530-a274-11f1-a13c-1607ee4eb77e",283,["D",1787875769092],"import * as db from \"./database.ts\";\nimport * as kejutan from \"../../lib/powerups.ts\";\nimport { renderUlarDashboard } from \"./views/dashboard.ts\";\nimport { renderUlarEditor } from \"./views/editor.ts\";\nimport { renderUlarPlay } from \"./views/play.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport async function handleUlarTangga(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n namaGuru: string,\n): Promise {\n // ===== HALAMAN =====\n if (method === \"GET\" && path === \"/ular-tangga\") {\n return html(await renderUlarDashboard(guruId, namaGuru));\n }\n if (\n method === \"GET\" && path.startsWith(\"/ular-bank/\") && path.endsWith(\"/edit\")\n ) {\n const bankId = path.split(\"/\")[2];\n return html(await renderUlarEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/ular-main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderUlarPlay(sesiId));\n }\n\n // ===== API: BANK SOAL =====\n if (method === \"GET\" && path === \"/api/ular/bank\") {\n try {\n return json(await db.getUlarBankList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"POST\" && path === \"/api/ular/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) {\n return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n }\n return json(\n await db.createUlarBank(guruId, body.namaBank, body.mapel, body.kelas),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/ular/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n await db.deleteUlarBank(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SOAL =====\n if (\n method === \"GET\" && path.startsWith(\"/api/ular/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getUlarSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/ular/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.pertanyaan) {\n return json({ error: \"Pertanyaan wajib diisi\" }, 400);\n }\n return json(await db.addUlarSoal(bankId, body.pertanyaan, body.jawaban));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"PUT\" && path.startsWith(\"/api/ular/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.pertanyaan) {\n return json({ error: \"Pertanyaan wajib diisi\" }, 400);\n }\n return json(\n await db.updateUlarSoal(soalId, body.pertanyaan, body.jawaban),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"DELETE\" && path.startsWith(\"/api/ular/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n await db.deleteUlarSoal(soalId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SESI =====\n if (method === \"POST\" && path === \"/api/ular/sesi\") {\n try {\n const body = await req.json();\n if (\n !body.bankId || !body.namaSesi || !Array.isArray(body.timList) ||\n body.timList.length < 1 || body.timList.length > 8\n ) {\n return json({\n error:\n \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-8 tim)\",\n }, 400);\n }\n return json(\n await db.createUlarSesi(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.timList,\n !!body.powerUpAktif,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/ular/sesi/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getUlarSesiDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/ular/sesi/\") &&\n path.endsWith(\"/langkah\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.timId || !body.dadu) {\n return json({ error: \"Tim dan mata dadu wajib diisi\" }, 400);\n }\n const hasilLangkah = await db.catatLangkah(\n sesiId,\n body.timId,\n body.soalId ?? null,\n body.dadu,\n !!body.benar,\n );\n\n let hasilKejutan = null;\n if (\n body.benar && hasilLangkah.event !== \"menang\" &&\n hasilLangkah.event !== \"mentok\"\n ) {\n const sesiSekarang = await db.getUlarSesiDetail(sesiId);\n if (sesiSekarang.sesi.power_up_aktif) {\n // \"posisi\" bidak diperlakukan sebagai \"skor\" untuk mesin kejutan\n // yang sama dipakai game lain (Kuis Kotak, Roda Putar, dst).\n const timSebagaiSkor = sesiSekarang.tim.map((t: any) => ({\n id: t.id,\n nama_tim: t.nama_tim,\n skor: t.posisi,\n }));\n hasilKejutan = kejutan.rollKejutanSkor(\n timSebagaiSkor,\n body.timId,\n body.dadu,\n );\n if (hasilKejutan) {\n await db.terapkanKejutanPosisi(hasilKejutan.timUpdates);\n // Kalau kejutan mendorong pas ke kotak 100, itu sah menang juga.\n const timTerbaru = await db.getUlarSesiDetail(sesiId);\n const timId = hasilKejutan.timUpdates.find((\n u: { id: string; skorBaru: number },\n ) => u.skorBaru >= 100)?.id;\n if (timId) {\n const menang = timTerbaru.tim.find((t: any) =>\n t.id === timId && t.posisi === 100\n );\n if (menang) hasilLangkah.event = \"menang\";\n }\n }\n }\n }\n\n return json({ ...hasilLangkah, kejutan: hasilKejutan });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/ular/sesi/\") &&\n path.endsWith(\"/giliran\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n await db.updateUlarGiliran(sesiId, body.giliranBaru ?? 0);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/ular/sesi/\") &&\n path.endsWith(\"/selesai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json().catch(() => ({}));\n await db.selesaikanUlarSesi(sesiId, body.pemenangTimId ?? null);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,342,334],"ular-tangga","9665f3ee-c0d0-4f97-a130-577743b644b4","database.ts","2d9cda56-a274-11f1-8a75-1607ee4eb77e",282,["D",1787875755816],"import { supabase } from \"../../supabase-client.ts\";\n\n// ============================================================\n// PAPAN ULAR TANGGA — 10x10 (kotak 1-100), dipakai server (logika\n// resmi gerak bidak) & diduplikasi di play.ts (render papan).\n// Kalau salah satu diubah, ubah juga yang satu lagi supaya sinkron.\n// ============================================================\nexport const TANGGA: Record = {\n 2: 38,\n 7: 14,\n 8: 31,\n 15: 26,\n 21: 42,\n 28: 84,\n 36: 44,\n 51: 67,\n 71: 91,\n 78: 98,\n};\nexport const ULAR: Record = {\n 16: 6,\n 46: 25,\n 49: 11,\n 62: 19,\n 64: 60,\n 74: 53,\n 89: 68,\n 92: 88,\n 95: 75,\n 99: 80,\n};\n\n// ===== BANK SOAL =====\n\nexport async function getUlarBankList(guruId: string) {\n const { data, error } = await supabase\n .from(\"ular_bank_soal\")\n .select(\"*, ular_soal(count)\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function createUlarBank(\n guruId: string,\n namaBank: string,\n mapel: string,\n kelas: string,\n) {\n const { data, error } = await supabase\n .from(\"ular_bank_soal\")\n .insert({ guru_id: guruId, nama_bank: namaBank, mapel, kelas })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteUlarBank(bankId: string) {\n const { error } = await supabase.from(\"ular_bank_soal\").delete().eq(\n \"id\",\n bankId,\n );\n if (error) throw error;\n}\n\n// ===== SOAL =====\n\nexport async function getUlarSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"ular_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"created_at\");\n if (error) throw error;\n return data;\n}\n\nexport async function addUlarSoal(\n bankId: string,\n pertanyaan: string,\n jawaban: string,\n) {\n const { data, error } = await supabase\n .from(\"ular_soal\")\n .insert({ bank_id: bankId, pertanyaan, jawaban })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function updateUlarSoal(\n soalId: string,\n pertanyaan: string,\n jawaban: string,\n) {\n const { data, error } = await supabase\n .from(\"ular_soal\")\n .update({ pertanyaan, jawaban })\n .eq(\"id\", soalId)\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteUlarSoal(soalId: string) {\n const { error } = await supabase.from(\"ular_soal\").delete().eq(\n \"id\",\n soalId,\n );\n if (error) throw error;\n}\n\n// ===== SESI =====\n\nexport async function createUlarSesi(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n timList: { nama: string; warna: string }[],\n powerUpAktif = false,\n) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"ular_sesi\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n power_up_aktif: powerUpAktif,\n })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n posisi: 1,\n }));\n const { data: timData, error: timError } = await supabase.from(\"ular_tim\")\n .insert(timRows).select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nexport async function getUlarSesiDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase.from(\"ular_sesi\")\n .select(\"*\").eq(\"id\", sesiId).single();\n if (sesiError) throw sesiError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"ular_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id);\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"ular_tim\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const { data: soalTerpakai, error: terpakaiError } = await supabase\n .from(\"ular_soal_terpakai\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId);\n if (terpakaiError) throw terpakaiError;\n\n return { sesi, soal, tim, soalTerpakai };\n}\n\n// Jalankan satu langkah bidak: kalau benar, maju sesuai mata dadu (harus\n// pas 100, tidak boleh lewat), lalu kena efek tangga/ular kalau berhenti\n// di kotaknya. Kalau salah, bidak tidak bergerak sama sekali.\nexport async function catatLangkah(\n sesiId: string,\n timId: string,\n soalId: string | null,\n dadu: number,\n benar: boolean,\n) {\n const { data: tim, error: timError } = await supabase\n .from(\"ular_tim\")\n .select(\"*\")\n .eq(\"id\", timId)\n .single();\n if (timError) throw timError;\n\n const posisiSebelum = tim.posisi;\n let posisiSesudah = posisiSebelum;\n let event: \"tangga\" | \"ular\" | \"menang\" | \"mentok\" | \"diam\" = \"diam\";\n\n if (benar) {\n const target = posisiSebelum + dadu;\n if (target > 100) {\n event = \"mentok\"; // harus pas 100, kalau lewat tidak jalan\n } else {\n posisiSesudah = target;\n if (TANGGA[posisiSesudah]) {\n posisiSesudah = TANGGA[posisiSesudah];\n event = \"tangga\";\n } else if (ULAR[posisiSesudah]) {\n posisiSesudah = ULAR[posisiSesudah];\n event = \"ular\";\n }\n if (posisiSesudah === 100) event = \"menang\";\n }\n }\n\n const { error: soalTerpakaiError } = await supabase\n .from(\"ular_soal_terpakai\")\n .insert({\n sesi_id: sesiId,\n soal_id: soalId,\n tim_menjawab_id: timId,\n benar,\n dadu,\n posisi_sebelum: posisiSebelum,\n posisi_sesudah: posisiSesudah,\n });\n if (soalTerpakaiError) throw soalTerpakaiError;\n\n const { error: updateError } = await supabase\n .from(\"ular_tim\")\n .update({\n posisi: posisiSesudah,\n soal_benar: tim.soal_benar + (benar ? 1 : 0),\n soal_salah: tim.soal_salah + (benar ? 0 : 1),\n })\n .eq(\"id\", timId);\n if (updateError) throw updateError;\n\n return { posisiSebelum, posisiSesudah, event };\n}\n\nexport async function updateUlarGiliran(sesiId: string, giliranBaru: number) {\n const { error } = await supabase.from(\"ular_sesi\").update({\n giliran_tim_index: giliranBaru,\n }).eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function selesaikanUlarSesi(\n sesiId: string,\n pemenangTimId: string | null,\n) {\n const { error } = await supabase\n .from(\"ular_sesi\")\n .update({\n status: \"selesai\",\n pemenang_tim_id: pemenangTimId,\n selesai_at: new Date().toISOString(),\n })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\n// ===== KEJUTAN POSISI (POWER-UP, pakai mesin lib/powerups.ts) =====\n// Posisi bidak (1-100) diperlakukan sebagai \"skor\" untuk mesin kejutan\n// yang sama dipakai game lain, lalu hasilnya dijepit ke rentang 1-100.\n\nexport async function terapkanKejutanPosisi(\n updates: { id: string; skorBaru: number }[],\n) {\n for (const u of updates) {\n const posisiBaru = Math.max(1, Math.min(100, Math.round(u.skorBaru)));\n const { error } = await supabase.from(\"ular_tim\").update({\n posisi: posisiBaru,\n }).eq(\"id\", u.id);\n if (error) throw error;\n }\n}\n\n// ===== REKAP =====\n\nexport async function getRekapUlarByKelas(guruId: string, kelas?: string) {\n let query = supabase\n .from(\"ular_sesi\")\n .select(\"*, ular_tim(*)\")\n .eq(\"guru_id\", guruId)\n .eq(\"status\", \"selesai\")\n .order(\"created_at\", { ascending: false });\n if (kelas) query = query.eq(\"kelas\", kelas);\n\n const { data, error } = await query;\n if (error) throw error;\n return data;\n}",[],[183,342,344],"03555953-0da9-4b23-b23e-86204ecdac52","play.ts","45c150c6-a274-11f1-9f51-1607ee4eb77e","36d1f192-a274-11f1-b47b-1607ee4eb77e",286,["D",1787875808539],"export async function renderUlarPlay(sesiId: string): Promise {\n return `\n\n\n \n \n Main - Ular Tangga Kuis\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,342,169,352],"2556532d-f189-4f1a-8c98-ba62ef6b687c","editor.ts","418f813a-a274-11f1-ab39-1607ee4eb77e",285,["D",1787875795194],"export async function renderUlarEditor(bankId: string): Promise {\n return `\n\n\n \n \n Edit Soal Ular Tangga - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,342,169,361],"b0f3b41f-b260-4e18-9a24-9b74f816bff6","dashboard.ts","3bf77390-a274-11f1-9f51-1607ee4eb77e",284,["D",1787875783322],"export async function renderUlarDashboard(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Ular Tangga Kuis - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,342,169,369],"b092d639-872b-4d98-8f69-32ed57406808",275,["D",1787875548695],[266,267,268],[183,342,169],"402772e7-df7c-46aa-8347-cc1cd2d2a739",269,["D",1787875520823],[265,269,270],[183,342],"371f027a-baf6-41b2-b97b-094e5d822147","d0f8e998-a4ee-11f1-b4ec-1607ee4eb77e","78fa5416-a4ee-11f1-81a6-1607ee4eb77e",385,["D",1788148131196],"import * as db from \"./database.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/bank-editor.ts\";\nimport { renderKontrol } from \"./views/kontrol.ts\";\nimport { renderLayar } from \"./views/layar.ts\";\nimport { renderRekap } from \"./views/rekap.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport async function handleTebakKata(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n namaGuru: string,\n): Promise {\n // ===== HALAMAN =====\n if (method === \"GET\" && path === \"/tebak-kata\") {\n return html(await renderDashboard(guruId, namaGuru));\n }\n if (\n method === \"GET\" && path.startsWith(\"/tebak-bank/\") &&\n path.endsWith(\"/edit\")\n ) {\n const bankId = path.split(\"/\")[2];\n return html(await renderBankEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/tebak-main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderKontrol(sesiId));\n }\n if (method === \"GET\" && path.startsWith(\"/tebak-layar/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderLayar(sesiId));\n }\n if (method === \"GET\" && path === \"/tebak-rekap\") {\n return html(await renderRekap(guruId));\n }\n\n // ===== API: BANK SOAL =====\n if (method === \"GET\" && path === \"/api/tebak/bank\") {\n try {\n return json(await db.getBankList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/tebak/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getBankById(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"POST\" && path === \"/api/tebak/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) {\n return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n }\n return json(\n await db.createBank(guruId, body.namaBank, body.mapel, body.kelas),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/tebak/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n await db.deleteBank(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SOAL (kata + 3 petunjuk) =====\n if (\n method === \"GET\" && path.startsWith(\"/api/tebak/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.kata || !String(body.kata).trim()) {\n return json({ error: \"Kata jawaban wajib diisi\" }, 400);\n }\n return json(\n await db.tambahSoal(\n bankId,\n body.kata,\n body.petunjuk1,\n body.petunjuk2,\n body.petunjuk3,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"PUT\" && path.startsWith(\"/api/tebak/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.kata || !String(body.kata).trim()) {\n return json({ error: \"Kata jawaban wajib diisi\" }, 400);\n }\n return json(\n await db.updateSoal(\n soalId,\n body.kata,\n body.petunjuk1,\n body.petunjuk2,\n body.petunjuk3,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"DELETE\" && path.startsWith(\"/api/tebak/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n await db.deleteSoal(soalId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SESI =====\n if (method === \"POST\" && path === \"/api/tebak/sesi\") {\n try {\n const body = await req.json();\n if (\n !body.bankId || !body.namaSesi || !Array.isArray(body.timList) ||\n body.timList.length < 1 || body.timList.length > 10\n ) {\n return json({\n error:\n \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-10 tim)\",\n }, 400);\n }\n return json(\n await db.createSesi(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.timList,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/guru\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getSesiDetailGuru(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/layar\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getSesiDetailLayar(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/clue\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n const level = Number(body.level) || 0;\n if (level < 1 || level > 3) {\n return json({ error: \"Level clue harus 1, 2, atau 3\" }, 400);\n }\n await db.bukaClue(sesiId, level);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/tim-pilih\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n await db.pilihTim(sesiId, body.timId ?? null);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/salah\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.catatSalah(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/benar\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.timId) return json({ error: \"Tim wajib dipilih\" }, 400);\n return json(await db.catatBenar(sesiId, body.timId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/hangus\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.catatHangus(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/lanjut\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.lanjutKata(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/tebak/sesi/\") &&\n path.endsWith(\"/selesai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.selesaikanSesi(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: REKAP =====\n if (method === \"GET\" && path === \"/api/tebak/rekap\") {\n try {\n const url = new URL(req.url);\n const kelas = url.searchParams.get(\"kelas\") ?? undefined;\n return json(await db.getRekapByKelas(guruId, kelas));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,394,334],"tebak-kata","242541c6-ddcf-4634-9265-57451b0f8d4f","bbaa839e-a4ee-11f1-8106-1607ee4eb77e",413,["D",1788160062714],"import { supabase } from \"../../supabase-client.ts\";\n\n// ===== KONSTANTA SKOR (lihat juga: lib skor di sini dipakai router & views) =====\nexport const POIN_DASAR = 100;\nexport const PENALTI_SALAH = 15;\nexport const POIN_LANTAI = 25;\n\nfunction acakArray(arr: T[]): T[] {\n const hasil = [...arr];\n for (let i = hasil.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [hasil[i], hasil[j]] = [hasil[j], hasil[i]];\n }\n return hasil;\n}\n\n// Indeks karakter di `kata` yang merupakan huruf/angka yang bisa \"ditutup\"\n// jadi kotak `_`. Spasi & tanda baca selalu tampil apa adanya.\nfunction slotHurufIndex(kata: string): number[] {\n const idx: number[] = [];\n for (let i = 0; i < kata.length; i++) {\n if (/[A-Za-z0-9]/.test(kata[i])) idx.push(i);\n }\n return idx;\n}\n\nfunction hitungPoin(jumlahSalah: number): number {\n return Math.max(POIN_LANTAI, POIN_DASAR - PENALTI_SALAH * jumlahSalah);\n}\n\n// ===== BANK SOAL =====\n\nexport async function getBankList(guruId: string) {\n const { data, error } = await supabase\n .from(\"tebak_bank_soal\")\n .select(\"*, tebak_soal(count)\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function getBankById(bankId: string) {\n const { data, error } = await supabase\n .from(\"tebak_bank_soal\")\n .select(\"*\")\n .eq(\"id\", bankId)\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function createBank(\n guruId: string,\n namaBank: string,\n mapel: string,\n kelas: string,\n) {\n const { data, error } = await supabase\n .from(\"tebak_bank_soal\")\n .insert({ guru_id: guruId, nama_bank: namaBank, mapel, kelas })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteBank(bankId: string) {\n const { error } = await supabase.from(\"tebak_bank_soal\").delete().eq(\n \"id\",\n bankId,\n );\n if (error) throw error;\n}\n\n// ===== SOAL (kata + 3 petunjuk) =====\n\nexport async function getSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"tebak_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"urutan\");\n if (error) throw error;\n return data;\n}\n\nexport async function tambahSoal(\n bankId: string,\n kata: string,\n petunjuk1: string,\n petunjuk2: string,\n petunjuk3: string,\n) {\n const { data: existing, error: existingError } = await supabase\n .from(\"tebak_soal\")\n .select(\"urutan\")\n .eq(\"bank_id\", bankId)\n .order(\"urutan\", { ascending: false })\n .limit(1);\n if (existingError) throw existingError;\n const urutanBaru = (existing?.[0]?.urutan ?? 0) + 1;\n\n const { data, error } = await supabase\n .from(\"tebak_soal\")\n .insert({\n bank_id: bankId,\n urutan: urutanBaru,\n kata: kata.trim(),\n petunjuk_1: petunjuk1 ?? null,\n petunjuk_2: petunjuk2 ?? null,\n petunjuk_3: petunjuk3 ?? null,\n })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function updateSoal(\n soalId: string,\n kata: string,\n petunjuk1: string,\n petunjuk2: string,\n petunjuk3: string,\n) {\n const { data, error } = await supabase\n .from(\"tebak_soal\")\n .update({\n kata: kata.trim(),\n petunjuk_1: petunjuk1 ?? null,\n petunjuk_2: petunjuk2 ?? null,\n petunjuk_3: petunjuk3 ?? null,\n })\n .eq(\"id\", soalId)\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteSoal(soalId: string) {\n const { error } = await supabase.from(\"tebak_soal\").delete().eq(\n \"id\",\n soalId,\n );\n if (error) throw error;\n}\n\n// ===== SESI =====\n\nexport async function createSesi(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n timList: { nama: string; warna: string }[],\n) {\n const { data: soalList, error: soalError } = await supabase\n .from(\"tebak_soal\")\n .select(\"urutan\")\n .eq(\"bank_id\", bankId)\n .order(\"urutan\");\n if (soalError) throw soalError;\n if (!soalList || soalList.length === 0) {\n throw new Error(\"Bank soal ini belum punya kata sama sekali\");\n }\n\n const urutanAcak = acakArray(soalList.map((s) => s.urutan));\n\n const { data: sesi, error: sesiError } = await supabase\n .from(\"tebak_sesi\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n urutan_acak: urutanAcak,\n kata_index: 0,\n clue_level: 0,\n huruf_terbuka: [],\n potensi_poin: POIN_DASAR,\n status_kata: \"main\",\n })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase\n .from(\"tebak_tim\")\n .insert(timRows)\n .select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nasync function ambilKonteksSesi(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"tebak_sesi\")\n .select(\"*\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: soalList, error: soalError } = await supabase\n .from(\"tebak_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"tebak_tim\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const urutanAktif = sesi.urutan_acak[sesi.kata_index] ?? null;\n const soalAktif = urutanAktif\n ? soalList.find((s) => s.urutan === urutanAktif) ?? null\n : null;\n\n return { sesi, soalList, tim, soalAktif };\n}\n\n// Detail LENGKAP untuk Panel Kontrol Guru — termasuk jawaban & semua petunjuk.\n// JANGAN dipakai untuk Tampilan Proyektor (lihat getSesiDetailLayar).\nexport async function getSesiDetailGuru(sesiId: string) {\n const { sesi, soalList, tim, soalAktif } = await ambilKonteksSesi(sesiId);\n return {\n sesi,\n tim,\n soalAktif,\n totalKata: sesi.urutan_acak.length,\n kataKe: sesi.kata_index + 1,\n };\n}\n\n// Detail TERSARING untuk Tampilan Proyektor (Siswa) — huruf yang belum\n// terbuka & petunjuk yang belum dibuka TIDAK ikut terkirim, supaya jawaban\n// tidak bisa \"diintip\" lewat network tab di layar proyektor.\nexport async function getSesiDetailLayar(sesiId: string) {\n const { sesi, tim, soalAktif } = await ambilKonteksSesi(sesiId);\n\n let kotakHuruf: { tampil: string | null; slot: boolean }[] = [];\n let petunjukTerbuka: string[] = [];\n let poinDidapatKataIni = 0;\n\n if (soalAktif) {\n const kata = soalAktif.kata;\n const semuaTerbuka = sesi.status_kata !== \"main\";\n const hurufTerbuka: number[] = sesi.huruf_terbuka || [];\n kotakHuruf = kata.split(\"\").map((ch: string, i: number) => {\n const isSlot = /[A-Za-z0-9]/.test(ch);\n if (!isSlot) return { tampil: ch, slot: false };\n const terbuka = semuaTerbuka || hurufTerbuka.includes(i);\n return { tampil: terbuka ? ch.toUpperCase() : null, slot: true };\n });\n\n const semuaPetunjuk = [\n soalAktif.petunjuk_1,\n soalAktif.petunjuk_2,\n soalAktif.petunjuk_3,\n ];\n petunjukTerbuka = semuaPetunjuk\n .slice(0, sesi.clue_level)\n .filter((p): p is string => !!p);\n\n if (sesi.status_kata === \"benar\") poinDidapatKataIni = sesi.potensi_poin;\n }\n\n return {\n sesi: {\n id: sesi.id,\n nama_sesi: sesi.nama_sesi,\n status: sesi.status,\n status_kata: sesi.status_kata,\n potensi_poin: sesi.potensi_poin,\n clue_level: sesi.clue_level,\n tim_terpilih_id: sesi.tim_terpilih_id,\n tim_terakhir_id: sesi.tim_terakhir_id,\n },\n tim,\n kotakHuruf,\n petunjukTerbuka,\n poinDidapatKataIni,\n totalKata: sesi.urutan_acak.length,\n kataKe: sesi.kata_index + 1,\n };\n}\n\nexport async function bukaClue(sesiId: string, level: number) {\n const { data: sesiSekarang, error: e1 } = await supabase\n .from(\"tebak_sesi\")\n .select(\"clue_level\")\n .eq(\"id\", sesiId)\n .single();\n if (e1) throw e1;\n const levelBaru = Math.max(sesiSekarang.clue_level, Math.min(3, level));\n const { error } = await supabase\n .from(\"tebak_sesi\")\n .update({ clue_level: levelBaru })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function pilihTim(sesiId: string, timId: string | null) {\n const { error } = await supabase\n .from(\"tebak_sesi\")\n .update({ tim_terpilih_id: timId })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\n// Guru menekan [ Salah (Buka 1 Huruf) ] — buka 1 huruf acak yang masih\n// tertutup, dan potensi poin turun (dengan nilai lantai).\nexport async function catatSalah(sesiId: string) {\n const { sesi, soalAktif } = await ambilKonteksSesi(sesiId);\n if (!soalAktif) throw new Error(\"Tidak ada kata aktif\");\n\n const hurufTerbuka: number[] = [...(sesi.huruf_terbuka || [])];\n const slotTersedia = slotHurufIndex(soalAktif.kata);\n const slotTertutup = slotTersedia.filter((i) => !hurufTerbuka.includes(i));\n if (slotTertutup.length > 0) {\n const pilih =\n slotTertutup[Math.floor(Math.random() * slotTertutup.length)];\n hurufTerbuka.push(pilih);\n }\n\n const jumlahSalahBaru = hurufTerbuka.length;\n const poinBaru = hitungPoin(jumlahSalahBaru);\n\n const { error } = await supabase\n .from(\"tebak_sesi\")\n .update({ huruf_terbuka: hurufTerbuka, potensi_poin: poinBaru })\n .eq(\"id\", sesiId);\n if (error) throw error;\n\n return { hurufTerbuka, potensiPoin: poinBaru };\n}\n\n// Guru menekan [ Benar ] — tambah sisa poin ke tim terpilih & buka seluruh kata.\nexport async function catatBenar(sesiId: string, timId: string) {\n const { sesi, soalAktif } = await ambilKonteksSesi(sesiId);\n if (!soalAktif) throw new Error(\"Tidak ada kata aktif\");\n\n const { data: timSekarang, error: timGetError } = await supabase\n .from(\"tebak_tim\")\n .select(\"skor\")\n .eq(\"id\", timId)\n .single();\n if (timGetError) throw timGetError;\n\n const { error: timUpdateError } = await supabase\n .from(\"tebak_tim\")\n .update({ skor: (timSekarang?.skor ?? 0) + sesi.potensi_poin })\n .eq(\"id\", timId);\n if (timUpdateError) throw timUpdateError;\n\n const { error: sesiError } = await supabase\n .from(\"tebak_sesi\")\n .update({ status_kata: \"benar\", tim_terakhir_id: timId })\n .eq(\"id\", sesiId);\n if (sesiError) throw sesiError;\n\n const { error: logError } = await supabase.from(\"tebak_log\").insert({\n sesi_id: sesiId,\n soal_urutan: soalAktif.urutan,\n tim_id: timId,\n benar: true,\n poin_didapat: sesi.potensi_poin,\n });\n if (logError) throw logError;\n\n return { poinDidapat: sesi.potensi_poin };\n}\n\n// Guru menekan [ Hangus / Buka Kata ] — buka kata tanpa ada tim yang dapat poin.\nexport async function catatHangus(sesiId: string) {\n const { soalAktif } = await ambilKonteksSesi(sesiId);\n if (!soalAktif) throw new Error(\"Tidak ada kata aktif\");\n\n const { error: sesiError } = await supabase\n .from(\"tebak_sesi\")\n .update({ status_kata: \"hangus\", tim_terakhir_id: null })\n .eq(\"id\", sesiId);\n if (sesiError) throw sesiError;\n\n const { error: logError } = await supabase.from(\"tebak_log\").insert({\n sesi_id: sesiId,\n soal_urutan: soalAktif.urutan,\n tim_id: null,\n benar: false,\n poin_didapat: 0,\n });\n if (logError) throw logError;\n}\n\n// Lanjut ke kata berikutnya. Kalau ini kata terakhir, sesi otomatis\n// ditandai selesai.\nexport async function lanjutKata(sesiId: string) {\n const { sesi } = await ambilKonteksSesi(sesiId);\n const indexBaru = sesi.kata_index + 1;\n\n if (indexBaru >= sesi.urutan_acak.length) {\n const { error } = await supabase\n .from(\"tebak_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n return { selesai: true };\n }\n\n const { error } = await supabase\n .from(\"tebak_sesi\")\n .update({\n kata_index: indexBaru,\n clue_level: 0,\n huruf_terbuka: [],\n potensi_poin: POIN_DASAR,\n status_kata: \"main\",\n tim_terpilih_id: null,\n tim_terakhir_id: null,\n })\n .eq(\"id\", sesiId);\n if (error) throw error;\n return { selesai: false };\n}\n\nexport async function selesaikanSesi(sesiId: string) {\n const { error } = await supabase\n .from(\"tebak_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\n// ===== REKAP =====\n\nexport async function getRekapByKelas(guruId: string, kelas?: string) {\n let query = supabase\n .from(\"tebak_sesi\")\n .select(\"*, tebak_tim(*)\")\n .eq(\"guru_id\", guruId)\n .eq(\"status\", \"selesai\")\n .order(\"tanggal\", { ascending: false });\n if (kelas) query = query.eq(\"kelas\", kelas);\n\n const { data, error } = await query;\n if (error) throw error;\n return data;\n}",[],[183,394,344],"8e62e666-7e50-46db-8b8f-eaaf922f55c6","rekap.ts","2e2a2c44-a4ef-11f1-9ae2-1607ee4eb77e","e845f46a-a4ee-11f1-8841-1607ee4eb77e",415,["D",1788160418417],"export async function renderRekap(guruId: string): Promise {\n return `\n\n\n \n \n Rekap Skor - Tebak Kata Berlomba\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,394,169,403],"8986a5f0-327d-4104-9933-1ad994ee4a76","layar.ts","1f31d4da-a4ef-11f1-b1af-1607ee4eb77e",399,["D",1788148255175],"export async function renderLayar(sesiId: string): Promise {\n return `\n\n\n \n \n Tebak Kata Berlomba - Layar\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,394,169,412],"8366a362-ac47-4e75-b268-a98f70d10ef1","kontrol.ts","13d0fa6c-a4ef-11f1-9b38-1607ee4eb77e",396,["D",1788148232405],"export async function renderKontrol(sesiId: string): Promise {\n return `\n\n\n \n \n Panel Kontrol - Tebak Kata Berlomba\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,394,169,420],"2b3aee39-6b28-4754-8a50-b28803b0927e","f3878884-a4ee-11f1-9642-1607ee4eb77e",390,["D",1788148177144],"export async function renderDashboard(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Tebak Kata Berlomba - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,394,169,369],"5e75760f-1894-47c1-81bd-7c5b0cdc889d","bank-editor.ts","00a31a88-a4ef-11f1-819d-1607ee4eb77e",393,["D",1788148212733],"export async function renderBankEditor(bankId: string): Promise {\n return `\n\n\n \n \n Edit Kata - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,394,169,435],"a2e1e3ce-3865-48ab-986c-c48261cd10ed",387,["D",1788148146895],[257,258,259,260,261],[183,394,169],"aa8d8623-33d6-4123-988e-3dddf33c8204",379,["D",1788147969791],[256,262,263],[183,394],"35e714ad-7c9b-43d4-bf03-13937de22312","c02f623e-a4e6-11f1-b5c0-1607ee4eb77e","8e9bb8b2-a4e6-11f1-8416-1607ee4eb77e",439,["D",1788219104078],4,"import * as db from \"./database.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/editor.ts\";\nimport { renderGamePlay } from \"./views/play.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport async function handleSusunKataSeru(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n namaGuru: string,\n): Promise {\n // ===== HALAMAN =====\n if (method === \"GET\" && path === \"/susun-kata\") {\n return html(await renderDashboard(guruId, namaGuru));\n }\n if (\n method === \"GET\" && path.startsWith(\"/sk-bank/\") && path.endsWith(\"/edit\")\n ) {\n const bankId = path.split(\"/\")[2];\n return html(await renderBankEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/sk-main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderGamePlay(sesiId));\n }\n\n // ===== API: BANK SOAL =====\n if (method === \"GET\" && path === \"/api/sk/bank\") {\n try {\n return json(await db.getBankSoalList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/sk/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getBankSoalById(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"POST\" && path === \"/api/sk/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) {\n return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n }\n return json(\n await db.createBankSoal(guruId, body.namaBank, body.mapel, body.kelas),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/sk/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n await db.deleteBankSoal(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SOAL (3 tipe campur: susun_kalimat / scrabble / pilih_kata) =====\n if (\n method === \"GET\" && path.startsWith(\"/api/sk/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.urutan || !body.tipe || !body.data) {\n return json({\n error: \"Urutan, tipe soal, dan data soal wajib diisi\",\n }, 400);\n }\n if (![\"susun_kalimat\", \"scrabble\", \"pilih_kata\"].includes(body.tipe)) {\n return json({ error: \"Tipe soal tidak dikenali\" }, 400);\n }\n return json(\n await db.upsertSoal(\n bankId,\n body.urutan,\n body.tipe,\n body.pertanyaan ?? null,\n body.data,\n body.poin ?? 10,\n body.gambarUrl,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/sk/soal/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const soalId = path.split(\"/\")[4];\n await db.deleteSoal(soalId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n // Tukar urutan soal (guru pindahkan soal naik/turun di editor).\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/soal/\") &&\n path.endsWith(\"/pindah\")\n ) {\n try {\n const soalId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.bankId) {\n return json({ error: \"bankId wajib diisi\" }, 400);\n }\n const arah = body.arah === \"naik\" ? \"naik\" : \"turun\";\n return json(await db.tukarUrutanSoal(body.bankId, soalId, arah));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n // Simpan urutan lengkap hasil drag-and-drop di editor.\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/bank/\") &&\n path.endsWith(\"/soal-urutan\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n const body = await req.json();\n if (!Array.isArray(body.urutanBaru)) {\n return json({ error: \"urutanBaru wajib berupa array id soal\" }, 400);\n }\n return json(await db.reorderSoal(bankId, body.urutanBaru));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SESI OFFLINE (single-screen, gantian tim) =====\n if (method === \"POST\" && path === \"/api/sk/sesi\") {\n try {\n const body = await req.json();\n if (\n !body.bankId || !body.namaSesi || !Array.isArray(body.timList) ||\n body.timList.length < 1 || body.timList.length > 20\n ) {\n return json({\n error:\n \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-20 tim)\",\n }, 400);\n }\n return json(\n await db.createSesiOffline(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.timList,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/sk/sesi/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getSesiOfflineDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/sesi/\") &&\n path.endsWith(\"/jawab\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n if (typeof body.soalIndex !== \"number\") {\n return json({ error: \"soalIndex wajib diisi\" }, 400);\n }\n // Grading sudah dilakukan di client (guru pegang device tunggal,\n // sama pola dengan Kuis Pilihan Ganda offline) — server di sini\n // hanya mencatat hasil & mengakumulasi skor tim.\n const hasilJawab = await db.catatJawabanOffline(\n sesiId,\n body.soalIndex,\n body.timId ?? null,\n body.jawabanDiberikan ?? null,\n !!body.benar,\n body.poinDidapat ?? 0,\n );\n return json(hasilJawab);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/sesi/\") &&\n path.endsWith(\"/lanjut\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n await db.lanjutSoalOffline(\n sesiId,\n body.soalKeBaru ?? 0,\n body.giliranTimBaru ?? 0,\n );\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/sesi/\") &&\n path.endsWith(\"/selesai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.selesaikanSesiOffline(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,461,334],"susun-kata-seru","5b2617a6-12ac-476b-b2a5-f33ffc4ddd7a","ba9bfbe8-a4e6-11f1-b210-1607ee4eb77e",438,["D",1788219084482],"import { supabase } from \"../../supabase-client.ts\";\nimport { type TipeSoal, validasiDataSoal } from \"./lib/grading.ts\";\n\n// ===== BANK SOAL =====\n\nexport async function getBankSoalList(guruId: string) {\n const { data, error } = await supabase\n .from(\"susun_kata_bank\")\n .select(\"*, susun_kata_soal(count)\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return (data || []).map((b: any) => ({\n ...b,\n jumlahSoal: b.susun_kata_soal?.[0]?.count ?? 0,\n }));\n}\n\nexport async function getBankSoalById(bankId: string) {\n const { data, error } = await supabase\n .from(\"susun_kata_bank\")\n .select(\"*\")\n .eq(\"id\", bankId)\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function createBankSoal(\n guruId: string,\n namaBank: string,\n mapel: string,\n kelas: string,\n) {\n const { data, error } = await supabase\n .from(\"susun_kata_bank\")\n .insert({ guru_id: guruId, nama_bank: namaBank, mapel, kelas })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteBankSoal(bankId: string) {\n const { error } = await supabase.from(\"susun_kata_bank\").delete().eq(\n \"id\",\n bankId,\n );\n if (error) throw error;\n}\n\n// ===== SOAL (3 tipe campur dalam 1 bank) =====\n\nexport async function getSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"urutan\");\n if (error) throw error;\n return data;\n}\n\nexport async function upsertSoal(\n bankId: string,\n urutan: number,\n tipe: TipeSoal,\n pertanyaan: string | null,\n data: unknown,\n poin: number,\n gambarUrl?: string | null,\n) {\n // Validasi bentuk `data` sebelum disimpan supaya soal rusak tidak\n // pernah lolos ke bank (baru ketahuan pas dimainkan siswa).\n validasiDataSoal(tipe, data);\n\n const { data: hasil, error } = await supabase\n .from(\"susun_kata_soal\")\n .upsert(\n {\n bank_id: bankId,\n urutan,\n tipe,\n pertanyaan: pertanyaan ?? null,\n data,\n poin,\n gambar_url: gambarUrl ?? null,\n },\n { onConflict: \"bank_id,urutan\" },\n )\n .select()\n .single();\n if (error) throw error;\n return hasil;\n}\n\nexport async function deleteSoal(soalId: string) {\n const { error } = await supabase.from(\"susun_kata_soal\").delete().eq(\n \"id\",\n soalId,\n );\n if (error) throw error;\n}\n\n// Tukar urutan 1 soal dengan tetangganya (naik = tukar dengan soal\n// sebelumnya, turun = tukar dengan soal sesudahnya). Dilakukan lewat\n// nilai sementara (urutan = -1) supaya tidak pernah bentrok dengan\n// unique constraint (bank_id, urutan) — kalau ditukar langsung dalam\n// 2 update saja, update pertama bisa gagal karena urutan tujuan masih\n// dipakai soal lain (constraint dicek per statement, bukan per\n// transaksi, karena tiap panggilan Supabase adalah request terpisah).\nexport async function tukarUrutanSoal(\n bankId: string,\n soalId: string,\n arah: \"naik\" | \"turun\",\n): Promise {\n const { data: daftar, error: daftarError } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"id, urutan\")\n .eq(\"bank_id\", bankId)\n .order(\"urutan\");\n if (daftarError) throw daftarError;\n\n const idx = (daftar || []).findIndex((s: any) => s.id === soalId);\n if (idx === -1) {\n throw new Error(\"Soal tidak ditemukan di bank soal ini\");\n }\n const idxLawan = arah === \"naik\" ? idx - 1 : idx + 1;\n if (idxLawan < 0 || idxLawan >= (daftar as any[]).length) {\n // Sudah di posisi paling atas/bawah, tidak ada yang bisa ditukar.\n return await getSoalByBank(bankId);\n }\n\n const a = (daftar as any[])[idx];\n const b = (daftar as any[])[idxLawan];\n const URUTAN_SEMENTARA = -1;\n\n const { error: e1 } = await supabase\n .from(\"susun_kata_soal\")\n .update({ urutan: URUTAN_SEMENTARA })\n .eq(\"id\", a.id);\n if (e1) throw e1;\n\n const { error: e2 } = await supabase\n .from(\"susun_kata_soal\")\n .update({ urutan: a.urutan })\n .eq(\"id\", b.id);\n if (e2) throw e2;\n\n const { error: e3 } = await supabase\n .from(\"susun_kata_soal\")\n .update({ urutan: b.urutan })\n .eq(\"id\", a.id);\n if (e3) throw e3;\n\n return await getSoalByBank(bankId);\n}\n\n// Simpan urutan LENGKAP hasil drag-and-drop di editor (bukan cuma tukar\n// 1-1 seperti tukarUrutanSoal). `urutanBaru` = array id soal, sudah\n// dalam urutan tampil yang diinginkan guru.\n//\n// Dilakukan 2 fase supaya tidak pernah bentrok dengan unique constraint\n// (bank_id, urutan): fase 1 geser semua ke nilai negatif unik dulu\n// (aman, tidak akan pernah dipakai soal lain), baru fase 2 set ke\n// urutan final 1..n sesuai posisi barunya.\nexport async function reorderSoal(\n bankId: string,\n urutanBaru: string[],\n): Promise {\n const { data: daftar, error: daftarError } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"id\")\n .eq(\"bank_id\", bankId);\n if (daftarError) throw daftarError;\n\n const idValid = new Set((daftar || []).map((s: any) => s.id));\n if (\n urutanBaru.length !== idValid.size ||\n !urutanBaru.every((id) => idValid.has(id))\n ) {\n throw new Error(\n \"Daftar urutan baru tidak cocok dengan soal yang ada di bank ini\",\n );\n }\n\n for (let i = 0; i < urutanBaru.length; i++) {\n const { error } = await supabase\n .from(\"susun_kata_soal\")\n .update({ urutan: -(i + 1) })\n .eq(\"id\", urutanBaru[i]);\n if (error) throw error;\n }\n for (let i = 0; i < urutanBaru.length; i++) {\n const { error } = await supabase\n .from(\"susun_kata_soal\")\n .update({ urutan: i + 1 })\n .eq(\"id\", urutanBaru[i]);\n if (error) throw error;\n }\n\n return await getSoalByBank(bankId);\n}\n\n// ===== SESI OFFLINE (single-screen, gantian tim) =====\n// Grading dilakukan di CLIENT (guru pegang device tunggal, sama pola\n// dengan Kuis Pilihan Ganda offline) — server di sini hanya mencatat\n// hasil yang sudah dinilai dan mengakumulasi skor tim.\n\nexport async function createSesiOffline(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n timList: { nama: string; warna: string }[],\n) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_offline\")\n .insert({ bank_id: bankId, guru_id: guruId, nama_sesi: namaSesi, kelas })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase\n .from(\"susun_kata_tim_offline\")\n .insert(timRows)\n .select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nexport async function getSesiOfflineDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_offline\")\n .select(\"*\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"susun_kata_tim_offline\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const { data: jawaban, error: jawabanError } = await supabase\n .from(\"susun_kata_jawaban_offline\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId);\n if (jawabanError) throw jawabanError;\n\n return { sesi, soal, tim, jawaban };\n}\n\nexport async function catatJawabanOffline(\n sesiId: string,\n soalIndex: number,\n timId: string | null,\n jawabanDiberikan: unknown,\n benar: boolean,\n poinDidapat: number,\n) {\n const { data, error } = await supabase\n .from(\"susun_kata_jawaban_offline\")\n .insert({\n sesi_id: sesiId,\n soal_index: soalIndex,\n tim_id: timId,\n jawaban_diberikan: jawabanDiberikan,\n benar,\n poin_didapat: poinDidapat,\n })\n .select()\n .single();\n if (error) throw error;\n\n if (timId && benar) {\n const { data: timSekarang } = await supabase\n .from(\"susun_kata_tim_offline\")\n .select(\"skor\")\n .eq(\"id\", timId)\n .single();\n await supabase.from(\"susun_kata_tim_offline\").update({\n skor: (timSekarang?.skor ?? 0) + poinDidapat,\n }).eq(\"id\", timId);\n }\n\n return data;\n}\n\nexport async function lanjutSoalOffline(\n sesiId: string,\n soalKeBaru: number,\n giliranTimBaru: number,\n) {\n const { error } = await supabase.from(\"susun_kata_sesi_offline\").update({\n soal_ke: soalKeBaru,\n giliran_tim_index: giliranTimBaru,\n }).eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function selesaikanSesiOffline(sesiId: string) {\n const { error } = await supabase\n .from(\"susun_kata_sesi_offline\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}",[],[183,461,344],"5494267f-864c-4954-a876-58e41a4da1a5","f80f3c56-a4e6-11f1-a861-1607ee4eb77e","a236e54a-a4e6-11f1-a4cb-1607ee4eb77e",456,["D",1788243810547],5,"export async function renderGamePlay(sesiId: string): Promise {\n return `\n\n\n \n \n Main - Susun Kata Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,169,352],"0b5cbba8-bd7f-4c7a-9a2c-f5b1aa19a64e","f2bf6672-a4e6-11f1-b0df-1607ee4eb77e",474,["D",1788328618788],"export async function renderBankEditor(bankId: string): Promise {\n return `\n\n\n \n \n Edit Bank Soal - Susun Kata Seru\n \n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,169,361],"0f38fb98-c988-4ffc-9bea-50753751997b","eb56a71a-a4e6-11f1-a861-1607ee4eb77e",454,["D",1788243783008],"export async function renderDashboard(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Susun Kata Seru - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,169,369],"8adc6340-5b71-46b1-915b-fe77a09ef1f8",332,["D",1788144594086],[250,251,252],[183,461,169],"d9b01258-c595-4e04-958d-9605819b5515","04bac70e-a4e7-11f1-b5c0-1607ee4eb77e","aaa388a0-a4e6-11f1-aa84-1607ee4eb77e",444,["D",1788222629202],"import * as db from \"./database.ts\";\nimport { renderGabung } from \"./views/gabung.ts\";\nimport { renderKerjakan } from \"./views/kerjakan.ts\";\nimport { renderLobi } from \"./views/lobi.ts\";\nimport { renderLaporan } from \"./views/laporan.ts\";\nimport { renderRiwayat } from \"./views/riwayat.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\n// ============================================================\n// RUTE PUBLIK — dipanggil SEBELUM cek session di main.ts.\n// Ini yang diakses siswa dari HP masing-masing, tanpa akun.\n// ============================================================\nexport async function handleSusunKataOnlinePublic(\n req: Request,\n method: string,\n path: string,\n): Promise {\n if (method === \"GET\" && path === \"/sk-gabung\") {\n return html(await renderGabung());\n }\n if (method === \"GET\" && path.startsWith(\"/sk-kerjakan/\")) {\n const pesertaId = path.split(\"/\")[2];\n return html(await renderKerjakan(pesertaId));\n }\n\n if (method === \"POST\" && path === \"/api/sk/online/gabung\") {\n try {\n const body = await req.json();\n const pin = String(body.pin || \"\").trim();\n if (!/^\\d{6}$/.test(pin)) {\n return json({ error: \"PIN harus 6 digit angka\" }, 400);\n }\n const sesi = await db.cariSesiByPin(pin);\n if (!sesi) {\n return json(\n { error: \"PIN tidak ditemukan atau sesi sudah selesai\" },\n 404,\n );\n }\n return json({\n sesiId: sesi.id,\n namaSesi: sesi.nama_sesi,\n status: sesi.status,\n });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/online/sesi-pin/\") &&\n path.endsWith(\"/peserta\")\n ) {\n try {\n const sesiId = path.split(\"/\")[5];\n const body = await req.json();\n const nama = String(body.namaPeserta || \"\").trim();\n if (!nama) return json({ error: \"Nama wajib diisi\" }, 400);\n if (nama.length > 40) {\n return json({ error: \"Nama maksimal 40 karakter\" }, 400);\n }\n const peserta = await db.daftarPeserta(sesiId, nama);\n return json({ pesertaId: peserta.id });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"GET\" && path.startsWith(\"/api/sk/online/peserta/\") &&\n path.endsWith(\"/state\")\n ) {\n try {\n const pesertaId = path.split(\"/\")[5];\n return json(await db.getPesertaState(pesertaId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/online/peserta/\") &&\n path.endsWith(\"/jawab\")\n ) {\n try {\n const pesertaId = path.split(\"/\")[5];\n const body = await req.json();\n if (typeof body.soalIndex !== \"number\") {\n return json({ error: \"soalIndex wajib diisi\" }, 400);\n }\n // jawabanTampilan: array of number (susun_kalimat/scrabble) atau\n // number tunggal (pilih_kata) — index ke ARRAY `pool` yang\n // dikirim server di getPesertaState, BUKAN index kanonis.\n // Server yang menerjemahkan & menilai (lihat online/database.ts).\n const hasil = await db.catatJawabanPeserta(\n pesertaId,\n body.soalIndex,\n body.jawabanTampilan ?? null,\n body.waktuJawabMs ?? 0,\n );\n return json(hasil);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}\n\n// ============================================================\n// RUTE GURU — dipanggil SESUDAH cek session, sama seperti\n// router game lain (butuh login).\n// ============================================================\nexport async function handleSusunKataOnlineGuru(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n _namaGuru: string,\n): Promise {\n if (\n method === \"GET\" && path.startsWith(\"/sk-online/\") &&\n path.endsWith(\"/lobi\")\n ) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderLobi(sesiId));\n }\n if (\n method === \"GET\" && path.startsWith(\"/sk-online/\") &&\n path.endsWith(\"/laporan\")\n ) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderLaporan(sesiId));\n }\n if (\n method === \"GET\" && path.startsWith(\"/sk-online/riwayat/\") &&\n path.split(\"/\").length === 4\n ) {\n const bankId = path.split(\"/\")[3];\n return html(await renderRiwayat(bankId));\n }\n\n if (method === \"POST\" && path === \"/api/sk/online\") {\n try {\n const body = await req.json();\n if (!body.bankId || !body.namaSesi) {\n return json({ error: \"bankId dan namaSesi wajib diisi\" }, 400);\n }\n const sesi = await db.createSesiPin(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.modeMulai,\n );\n return json(sesi);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"GET\" && path.startsWith(\"/api/sk/online/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getSesiPinDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"DELETE\" && path.startsWith(\"/api/sk/online/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.hapusSesiPin(sesiId, guruId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"DELETE\" && path.startsWith(\"/api/sk/online/peserta/\") &&\n path.split(\"/\").length === 6\n ) {\n try {\n const pesertaId = path.split(\"/\")[5];\n await db.hapusPeserta(pesertaId, guruId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"GET\" && path.startsWith(\"/api/sk/online/riwayat/\")) {\n try {\n const bankId = path.split(\"/\")[5];\n return json(await db.getRiwayatOnline(bankId, guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/online/\") &&\n path.endsWith(\"/mulai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.mulaiSesiPin(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"GET\" && path.startsWith(\"/api/sk/online/\") &&\n path.endsWith(\"/laporan\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getLaporan(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/sk/online/\") &&\n path.endsWith(\"/akhiri\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.akhiriSesiPin(sesiId, guruId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,461,505,334],"online","9c937d41-99a6-4f17-b7d0-6af14f8d79d9","00c3c0b0-a4e7-11f1-b5fc-1607ee4eb77e",446,["D",1788223303534],"import { supabase } from \"../../../supabase-client.ts\";\nimport { buatUrutanPool, nilaiJawaban, type TipeSoal } from \"../lib/grading.ts\";\n\nfunction generatePin(): string {\n return String(Math.floor(100000 + Math.random() * 900000));\n}\n\n// Supabase kadang mengembalikan timestamp TANPA penanda zona. Paksa\n// selalu dibaca sebagai UTC kalau belum ada penanda zona — pola sama\n// seperti di olimpiade Kuis Pilihan Ganda, supaya tidak salah hitung\n// deadline karena selisih UTC vs waktu lokal server.\nfunction msUtc(waktuIso: string): number {\n const adaZona = /Z$|[+-]\\d\\d:?\\d\\d$/.test(waktuIso);\n return new Date(adaZona ? waktuIso : waktuIso + \"Z\").getTime();\n}\n\n// ============================================================\n// CATATAN soal bug \"peserta ke-40+ langsung selesai\" di olimpiade\n// Kuis Pilihan Ganda: itu terjadi karena mode waktu \"per_game\" di\n// sana menghitung deadline SAMA untuk semua peserta dari sesi.dibuka_at,\n// jadi peserta yang baru dapat ID setelah deadline global lewat langsung\n// dianggap \"waktu habis\". Susun Kata Seru online TIDAK punya fitur batas\n// waktu total (tidak ada mode_waktu/waktu_total_menit/waktu_per_soal_detik),\n// jadi mekanisme penyebab bug itu tidak ada di sini — peserta baru selesai\n// kalau memang sudah menjawab semua soal (lihat catatJawabanPeserta). Yang\n// tetap diselaraskan dari pola olimpiade: mode \"otomatis\" sekarang\n// menandai sesi \"berjalan\" & mengisi dibuka_at SAAT PIN dibuat (lihat\n// createSesiPin), bukan menunggu siswa pertama gabung — supaya konsisten\n// walau banyak siswa submit nama hampir bersamaan.\n// ============================================================\n\n// Pastikan peserta punya urutan pool acak untuk soal_index tertentu.\n// Dibuat sekali & disimpan supaya tidak berubah-ubah tiap polling\n// (kerjakan.ts polling state tiap ~1.5 detik) tapi tetap beda-beda\n// antar peserta (anti-nyontek posisi hafalan dari layar teman).\nasync function pastikanUrutanPool(\n peserta: any,\n soalIndex: number,\n tipe: TipeSoal,\n data: unknown,\n): Promise {\n const kunci = String(soalIndex);\n const sudahAda = peserta.acak_urutan?.[kunci];\n if (Array.isArray(sudahAda)) return sudahAda;\n\n const urutanBaru = buatUrutanPool(tipe, data);\n const acakUrutanBaru = {\n ...(peserta.acak_urutan || {}),\n [kunci]: urutanBaru,\n };\n await supabase\n .from(\"susun_kata_peserta\")\n .update({ acak_urutan: acakUrutanBaru })\n .eq(\"id\", peserta.id);\n peserta.acak_urutan = acakUrutanBaru;\n return urutanBaru;\n}\n\n// ===== SESI PIN (guru) =====\n\nexport async function createSesiPin(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n modeMulai?: string,\n) {\n const modeMulaiValid = modeMulai === \"otomatis\" ? \"otomatis\" : \"manual\";\n for (let attempt = 0; attempt < 5; attempt++) {\n const pin = generatePin();\n const { data: bentrok } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"id\")\n .eq(\"pin\", pin)\n .neq(\"status\", \"selesai\")\n .maybeSingle();\n if (bentrok) continue;\n\n const otomatis = modeMulaiValid === \"otomatis\";\n const { data, error } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n pin,\n mode_mulai: modeMulaiValid,\n // Pola sama seperti olimpiade Kuis Pilihan Ganda: mode \"otomatis\"\n // langsung ditandai \"berjalan\" & dibuka_at diisi SAAT PIN dibuat,\n // bukan menunggu request gabung siswa pertama. Kalau ditunda\n // sampai siswa pertama gabung, banyak siswa yang submit nama\n // hampir bersamaan (kelas besar) bisa memicu beberapa request\n // \"mulai\" yang berebutan menulis dibuka_at secara terpisah —\n // tidak konsisten kalau nanti dibuka_at dipakai untuk hitung\n // durasi/waktu sesi.\n status: otomatis ? \"berjalan\" : \"menunggu\",\n dibuka_at: otomatis ? new Date().toISOString() : null,\n })\n .select()\n .single();\n if (error) throw error;\n return data;\n }\n throw new Error(\"Gagal membuat PIN unik, coba lagi.\");\n}\n\nexport async function mulaiSesiPin(sesiId: string) {\n const { error } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .update({ status: \"berjalan\", dibuka_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function akhiriSesiPin(sesiId: string, guruId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"id\")\n .eq(\"id\", sesiId)\n .eq(\"guru_id\", guruId)\n .maybeSingle();\n if (sesiError) throw sesiError;\n if (!sesi) throw new Error(\"Sesi tidak ditemukan atau bukan milik kamu\");\n\n const { error: sesiUpdateError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .update({ status: \"selesai\" })\n .eq(\"id\", sesiId)\n .neq(\"status\", \"selesai\");\n if (sesiUpdateError) throw sesiUpdateError;\n\n const { error: pesertaUpdateError } = await supabase\n .from(\"susun_kata_peserta\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"sesi_pin_id\", sesiId)\n .neq(\"status\", \"selesai\");\n if (pesertaUpdateError) throw pesertaUpdateError;\n\n return { ok: true };\n}\n\nexport async function getSesiPinDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"*\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"susun_kata_peserta\")\n .select(\"*\")\n .eq(\"sesi_pin_id\", sesiId)\n .order(\"joined_at\");\n if (pesertaError) throw pesertaError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"id\")\n .eq(\"bank_id\", sesi.bank_id);\n if (soalError) throw soalError;\n\n return { sesi, peserta, totalSoal: soal.length };\n}\n\nexport async function getLaporan(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"*\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"susun_kata_peserta\")\n .select(\"*, susun_kata_jawaban_peserta(*)\")\n .eq(\"sesi_pin_id\", sesiId)\n .order(\"skor\", { ascending: false });\n if (pesertaError) throw pesertaError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n return { sesi, peserta, soal };\n}\n\nexport async function getRiwayatOnline(bankId: string, guruId: string) {\n const { data, error } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"*, susun_kata_peserta(count)\")\n .eq(\"bank_id\", bankId)\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n\n return (data || []).map((s: any) => ({\n id: s.id,\n nama_sesi: s.nama_sesi,\n kelas: s.kelas,\n pin: s.pin,\n status: s.status,\n created_at: s.created_at,\n jumlahPeserta: s.susun_kata_peserta?.[0]?.count ?? 0,\n }));\n}\n\nexport async function hapusSesiPin(sesiId: string, guruId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"id\")\n .eq(\"id\", sesiId)\n .eq(\"guru_id\", guruId)\n .maybeSingle();\n if (sesiError) throw sesiError;\n if (!sesi) throw new Error(\"Riwayat tidak ditemukan atau bukan milik kamu\");\n\n const { data: pesertaList, error: pesertaListError } = await supabase\n .from(\"susun_kata_peserta\")\n .select(\"id\")\n .eq(\"sesi_pin_id\", sesiId);\n if (pesertaListError) throw pesertaListError;\n\n const pesertaIds = (pesertaList || []).map((p: any) => p.id);\n if (pesertaIds.length > 0) {\n const { error: jawabDelError } = await supabase\n .from(\"susun_kata_jawaban_peserta\")\n .delete()\n .in(\"peserta_id\", pesertaIds);\n if (jawabDelError) throw jawabDelError;\n }\n\n const { error: pesertaDelError } = await supabase\n .from(\"susun_kata_peserta\")\n .delete()\n .eq(\"sesi_pin_id\", sesiId);\n if (pesertaDelError) throw pesertaDelError;\n\n const { error: sesiDelError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .delete()\n .eq(\"id\", sesiId);\n if (sesiDelError) throw sesiDelError;\n\n return { ok: true };\n}\n\n// Hapus 1 peserta (dipakai guru di lobi untuk bersihkan entri dobel).\nexport async function hapusPeserta(pesertaId: string, guruId: string) {\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"susun_kata_peserta\")\n .select(\"id, susun_kata_sesi_pin(guru_id)\")\n .eq(\"id\", pesertaId)\n .maybeSingle();\n if (pesertaError) throw pesertaError;\n if (!peserta || peserta.susun_kata_sesi_pin?.guru_id !== guruId) {\n throw new Error(\"Peserta tidak ditemukan atau bukan milik sesi kamu\");\n }\n\n await supabase.from(\"susun_kata_jawaban_peserta\").delete().eq(\n \"peserta_id\",\n pesertaId,\n );\n await supabase.from(\"susun_kata_peserta\").delete().eq(\"id\", pesertaId);\n\n return { ok: true };\n}\n\n// ===== SISI SISWA (publik, tanpa login, akses via PIN) =====\n\nexport async function cariSesiByPin(pin: string) {\n const { data, error } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"*\")\n .eq(\"pin\", pin)\n .neq(\"status\", \"selesai\")\n .maybeSingle();\n if (error) throw error;\n return data;\n}\n\nexport async function daftarPeserta(sesiPinId: string, namaPeserta: string) {\n // Ambil dulu status & mode_mulai sesi — dipakai di bawah untuk cek\n // apakah sesi perlu langsung dimulai otomatis.\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"id, status, mode_mulai\")\n .eq(\"id\", sesiPinId)\n .single();\n if (sesiError) throw sesiError;\n\n // Lanjutkan peserta lama kalau nama persis sama (case-insensitive) —\n // supaya refresh/keluar tidak mengulang dari soal 1. Pola sama\n // dengan olimpiade Kuis Pilihan Ganda.\n const { data: pesertaLama, error: pesertaLamaError } = await supabase\n .from(\"susun_kata_peserta\")\n .select(\"id\")\n .eq(\"sesi_pin_id\", sesiPinId)\n .ilike(\"nama_peserta\", namaPeserta)\n .order(\"joined_at\", { ascending: false })\n .limit(1)\n .maybeSingle();\n if (pesertaLamaError) throw pesertaLamaError;\n\n let peserta = pesertaLama;\n if (!peserta) {\n const { data, error } = await supabase\n .from(\"susun_kata_peserta\")\n .insert({ sesi_pin_id: sesiPinId, nama_peserta: namaPeserta })\n .select()\n .single();\n if (error) throw error;\n peserta = data;\n }\n\n // Mode otomatis: begitu ada siswa yang selesai isi nama & klik\n // \"Gabung Main!\" sementara sesi masih menunggu, sesi langsung\n // dimulai untuk SEMUA peserta (termasuk yang sudah gabung lebih\n // dulu) — guru tidak perlu menekan \"Mulai Latihan\" di lobi.\n if (sesi.mode_mulai === \"otomatis\" && sesi.status === \"menunggu\") {\n await mulaiSesiPin(sesiPinId);\n }\n\n return peserta;\n}\n\n// State yang dikirim ke layar siswa: soal aktif SUDAH diacak urutan\n// pool-nya khusus untuk peserta ini, plus `urutanPool` supaya klien\n// tahu index pool mana yang mengisi tiap kartu yang ditampilkan\n// (dipakai untuk menerjemahkan balik posisi tampilan -> index kanonis\n// saat siswa mengirim jawaban).\nexport async function getPesertaState(pesertaId: string) {\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"susun_kata_peserta\")\n .select(\"*\")\n .eq(\"id\", pesertaId)\n .single();\n if (pesertaError) throw pesertaError;\n\n const { data: sesi, error: sesiError } = await supabase\n .from(\"susun_kata_sesi_pin\")\n .select(\"*\")\n .eq(\"id\", peserta.sesi_pin_id)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: soalList, error: soalError } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n const totalSoal = soalList.length;\n const soalMentah = soalList[peserta.soal_ke] ?? null;\n\n let soalAktif = null;\n if (soalMentah) {\n const urutanPool = await pastikanUrutanPool(\n peserta,\n peserta.soal_ke,\n soalMentah.tipe,\n soalMentah.data,\n );\n // Jumlah kotak jawaban yang harus diisi siswa — dikirim TANPA\n // membocorkan kunci jawaban aslinya (cuma jumlahnya, bukan isinya).\n const jumlahSlot = soalMentah.tipe === \"pilih_kata\"\n ? 1\n : soalMentah.tipe === \"scrabble\"\n ? soalMentah.data.jawaban.length\n : soalMentah.data.jawaban.length;\n soalAktif = {\n id: soalMentah.id,\n tipe: soalMentah.tipe,\n pertanyaan: soalMentah.pertanyaan,\n gambar_url: soalMentah.gambar_url,\n poin: soalMentah.poin,\n jumlahSlot,\n // Pool yang sudah diacak untuk ditampilkan; klien mengirim\n // balik pilihan sebagai index ke ARRAY INI (bukan index kanonis).\n pool: urutanPool.map((idxKanonis) => {\n if (soalMentah.tipe === \"pilih_kata\") {\n return soalMentah.data.pilihan[idxKanonis];\n }\n if (soalMentah.tipe === \"scrabble\") {\n return soalMentah.data.huruf[idxKanonis];\n }\n return soalMentah.data.potongan[idxKanonis];\n }),\n urutanPool, // peta posisi-tampilan -> index kanonis\n };\n }\n\n return {\n namaPeserta: peserta.nama_peserta,\n statusPeserta: peserta.status,\n statusSesi: sesi.status,\n namaSesi: sesi.nama_sesi,\n soalKe: peserta.soal_ke,\n totalSoal,\n skor: peserta.skor,\n soalAktif,\n };\n}\n\n// jawabanTampilan: index/array index ke ARRAY `pool` yang dikirim ke\n// klien (bukan index kanonis) — server yang menerjemahkan balik ke\n// kanonis pakai `urutanPool` tersimpan, lalu menilai pakai grading.ts.\nexport async function catatJawabanPeserta(\n pesertaId: string,\n soalIndex: number,\n jawabanTampilan: unknown,\n waktuJawabMs: number,\n) {\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"susun_kata_peserta\")\n .select(\"*, susun_kata_sesi_pin(bank_id)\")\n .eq(\"id\", pesertaId)\n .single();\n if (pesertaError) throw pesertaError;\n\n if (soalIndex !== peserta.soal_ke) {\n // Sudah tercatat / tidak sinkron — abaikan supaya tidak dobel-hitung.\n return { ok: true, selesai: peserta.status === \"selesai\" };\n }\n\n const { data: soalList, error: soalError } = await supabase\n .from(\"susun_kata_soal\")\n .select(\"*\")\n .eq(\"bank_id\", peserta.susun_kata_sesi_pin.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n const soal = soalList[soalIndex];\n if (!soal) throw new Error(\"Soal tidak ditemukan\");\n\n const urutanPool = await pastikanUrutanPool(\n peserta,\n soalIndex,\n soal.tipe,\n soal.data,\n );\n\n // Terjemahkan index-tampilan -> index kanonis sebelum dinilai.\n const jawabanKanonis = Array.isArray(jawabanTampilan)\n ? jawabanTampilan.map((posisiTampil: number) => urutanPool[posisiTampil])\n : typeof jawabanTampilan === \"number\"\n ? urutanPool[jawabanTampilan]\n : null;\n\n const benar = jawabanKanonis !== null &&\n nilaiJawaban(soal.tipe as TipeSoal, soal.data, jawabanKanonis);\n const poinDidapat = benar ? soal.poin : 0;\n\n const { error: jawabError } = await supabase\n .from(\"susun_kata_jawaban_peserta\")\n .insert({\n peserta_id: pesertaId,\n soal_index: soalIndex,\n jawaban_diberikan: jawabanKanonis,\n benar,\n poin_didapat: poinDidapat,\n waktu_jawab_ms: waktuJawabMs,\n });\n if (jawabError) throw jawabError;\n\n const soalKeBaru = peserta.soal_ke + 1;\n const selesai = soalKeBaru >= soalList.length;\n\n const { error: updateError } = await supabase\n .from(\"susun_kata_peserta\")\n .update({\n soal_ke: soalKeBaru,\n skor: peserta.skor + poinDidapat,\n status: selesai ? \"selesai\" : \"mengerjakan\",\n selesai_at: selesai ? new Date().toISOString() : null,\n })\n .eq(\"id\", pesertaId);\n if (updateError) throw updateError;\n\n return { ok: true, selesai, benar, poinDidapat };\n}",[],[183,461,505,344],"04053dc2-b7a7-460f-b306-f98054793822","riwayat.ts","81e921ce-a511-11f1-935e-1607ee4eb77e","af414bcc-a4e6-11f1-8709-1607ee4eb77e",460,["D",1788243877180],"export async function renderRiwayat(bankId: string): Promise {\n return `\n\n\n \n \n Riwayat - Susun Kata Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,505,169,514],"b4850b9d-3569-4a53-af8f-f258a56d63a7","lobi.ts","1608e98c-a4e7-11f1-a08b-1607ee4eb77e",476,["D",1788329845632],8,"export async function renderLobi(sesiId: string): Promise {\n return `\n\n\n \n \n Lobi - Susun Kata Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,505,169,523],"21fe1a47-b462-47a5-8f22-623ff3b3be48","laporan.ts","195b2bcc-a4e7-11f1-9dce-1607ee4eb77e",466,["D",1788306506493],"export async function renderLaporan(sesiId: string): Promise {\n return `\n\n\n \n \n Laporan - Susun Kata Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,505,169,532],"02d0624b-ebfe-4ad7-b93a-911857382dae","kerjakan.ts","1232d156-a4e7-11f1-89e9-1607ee4eb77e",457,["D",1788243836486],"export async function renderKerjakan(pesertaId: string): Promise {\n return `\n\n\n \n \n Kerjakan - Susun Kata Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,505,169,540],"ef8f6e89-0c9d-48ba-8967-99fd60342442","gabung.ts","0e16661e-a4e7-11f1-807d-1607ee4eb77e",437,["D",1788166748611],"export async function renderGabung(): Promise {\n return `\n\n\n \n \n Gabung - Susun Kata Seru\n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,461,505,169,548],"8db7134e-9d67-4e59-a8ed-80d805da317f",336,["D",1788144615609],[242,243,244,245,246],[183,461,505,169],"49214bd1-0444-45c4-a412-190f6349392f",334,["D",1788144607683],[241,247,248],[183,461,505],"1abb3cd4-7799-4c45-b168-077b76c68fd3","grading.ts","d4973b88-a4e7-11f1-a861-1607ee4eb77e","cec8a12e-a4e7-11f1-802e-1607ee4eb77e",370,["D",1788145236277],"// ============================================================\n// PENILAIAN JAWABAN — dipakai server (wajib untuk mode online,\n// karena siswa pegang device sendiri sehingga hasil dari client\n// TIDAK BOLEH dipercaya begitu saja).\n//\n// Untuk mode OFFLINE, guru yang pegang device tunggal (single-screen,\n// gantian tim) — sama seperti pola Kuis Pilihan Ganda offline,\n// grading dilakukan di client lalu dikirim ke server apa adanya.\n// Logika di bawah ini SENGAJA disamakan persis dengan logika JS\n// yang dipakai di client (play.ts / kerjakan.ts) — kalau salah satu\n// diubah, ubah juga yang satu lagi supaya hasil skor konsisten.\n// ============================================================\n\nexport type TipeSoal = \"susun_kalimat\" | \"scrabble\" | \"pilih_kata\";\n\nexport interface DataSusunKalimat {\n potongan: string[]; // semua kata yang ditampilkan di pool (jawaban + pengecoh)\n jawaban: number[]; // urutan index ke `potongan` yang membentuk kalimat benar\n}\n\nexport interface DataScrabble {\n huruf: string[]; // semua huruf di pool (jawaban + pengecoh)\n jawaban: string; // kata kunci jawaban\n}\n\nexport interface DataPilihKata {\n pilihan: string[]; // 4 kartu kata\n jawabanIndex: number; // index kartu yang benar\n}\n\n// jawabanDiberikan:\n// - susun_kalimat & scrabble: array of number (index ke pool, sesuai urutan slot diisi siswa)\n// - pilih_kata: number tunggal (index kartu yang ditaruh siswa di slot jawaban), atau null kalau belum dijawab\nexport function nilaiJawaban(\n tipe: TipeSoal,\n data: unknown,\n jawabanDiberikan: unknown,\n): boolean {\n if (tipe === \"susun_kalimat\") {\n const d = data as DataSusunKalimat;\n const kunci = Array.isArray(d?.jawaban) ? d.jawaban : [];\n const diberikan = Array.isArray(jawabanDiberikan) ? jawabanDiberikan : [];\n if (diberikan.length !== kunci.length || kunci.length === 0) return false;\n return diberikan.every((idx, i) => idx === kunci[i]);\n }\n\n if (tipe === \"scrabble\") {\n const d = data as DataScrabble;\n const huruf = Array.isArray(d?.huruf) ? d.huruf : [];\n const kunci = String(d?.jawaban ?? \"\").trim().toLowerCase();\n const diberikan = Array.isArray(jawabanDiberikan) ? jawabanDiberikan : [];\n if (kunci.length === 0 || diberikan.length !== kunci.length) return false;\n const kataTersusun = diberikan.map((idx: number) => huruf[idx] ?? \"\")\n .join(\"\").toLowerCase();\n return kataTersusun === kunci;\n }\n\n if (tipe === \"pilih_kata\") {\n const d = data as DataPilihKata;\n if (typeof jawabanDiberikan !== \"number\") return false;\n return jawabanDiberikan === d?.jawabanIndex;\n }\n\n return false;\n}\n\n// Validasi bentuk `data` soal sebelum disimpan dari editor guru.\n// Melempar Error dengan pesan berbahasa Indonesia yang bisa langsung\n// ditampilkan ke guru kalau ada kolom yang belum lengkap/rusak.\nexport function validasiDataSoal(tipe: TipeSoal, data: unknown): void {\n if (tipe === \"susun_kalimat\") {\n const d = data as DataSusunKalimat;\n if (!Array.isArray(d?.potongan) || d.potongan.length < 2) {\n throw new Error(\"Susun Kalimat butuh minimal 2 potongan kata\");\n }\n if (!Array.isArray(d?.jawaban) || d.jawaban.length === 0) {\n throw new Error(\"Susun Kalimat butuh urutan kunci jawaban\");\n }\n const luarJangkauan = d.jawaban.some((idx) =>\n idx < 0 || idx >= d.potongan.length\n );\n if (luarJangkauan) {\n throw new Error(\n \"Kunci jawaban Susun Kalimat mengacu ke potongan yang tidak ada\",\n );\n }\n return;\n }\n\n if (tipe === \"scrabble\") {\n const d = data as DataScrabble;\n if (!Array.isArray(d?.huruf) || d.huruf.length < 2) {\n throw new Error(\"Scrabble butuh minimal 2 huruf di pool\");\n }\n const kunci = String(d?.jawaban ?? \"\").trim();\n if (kunci.length === 0) {\n throw new Error(\"Scrabble butuh kata kunci jawaban\");\n }\n return;\n }\n\n if (tipe === \"pilih_kata\") {\n const d = data as DataPilihKata;\n if (!Array.isArray(d?.pilihan) || d.pilihan.length !== 4) {\n throw new Error(\"Pilih Kata butuh tepat 4 kartu pilihan\");\n }\n if (\n typeof d?.jawabanIndex !== \"number\" || d.jawabanIndex < 0 ||\n d.jawabanIndex > 3\n ) {\n throw new Error(\n \"Pilih Kata butuh kunci jawaban (salah satu dari 4 kartu)\",\n );\n }\n return;\n }\n\n throw new Error(\"Tipe soal tidak dikenali: \" + tipe);\n}\n\nfunction acakArray(arr: T[]): T[] {\n const hasil = [...arr];\n for (let i = hasil.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [hasil[i], hasil[j]] = [hasil[j], hasil[i]];\n }\n return hasil;\n}\n\n// Urutan acak pool (potongan kalimat / huruf scrabble / kartu pilih-kata)\n// untuk ditampilkan ke SATU peserta tertentu di mode online. Disimpan\n// server-side per peserta+soal supaya tidak berubah-ubah tiap polling,\n// tapi berbeda-beda antar peserta (anti-nyontek posisi hafalan).\nexport function buatUrutanPool(tipe: TipeSoal, data: unknown): number[] {\n const panjang = tipe === \"pilih_kata\"\n ? ((data as DataPilihKata)?.pilihan?.length ?? 4)\n : tipe === \"scrabble\"\n ? ((data as DataScrabble)?.huruf?.length ?? 0)\n : ((data as DataSusunKalimat)?.potongan?.length ?? 0);\n return acakArray(Array.from({ length: panjang }, (_, i) => i));\n}",[],[183,461,176,566],"8d0ca5b5-e6c4-4657-8578-f4af54ad6949",367,["D",1788145099997],[239],[183,461,176],"0da6831b-e059-4302-a69a-e5c3daf3fdd4",330,["D",1788144569442],[238,240,249,253,254],[183,461],"58e3ce00-e101-42c1-a373-dc34f78958be","1d8cce16-9dc2-11f1-97c0-1607ee4eb77e","122c696e-9dc2-11f1-a094-1607ee4eb77e",263,["D",1787874326323],"import * as db from \"./database.ts\";\nimport * as kejutan from \"../../lib/powerups.ts\";\nimport { renderRodaDashboard } from \"./views/dashboard.ts\";\nimport { renderRodaEditor } from \"./views/editor.ts\";\nimport { renderRodaPlay } from \"./views/play.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport async function handleRodaPutar(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n namaGuru: string,\n): Promise {\n // ===== HALAMAN =====\n if (method === \"GET\" && path === \"/roda-putar\") {\n return html(await renderRodaDashboard(guruId, namaGuru));\n }\n if (\n method === \"GET\" && path.startsWith(\"/roda-bank/\") && path.endsWith(\"/edit\")\n ) {\n const bankId = path.split(\"/\")[2];\n return html(await renderRodaEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/roda-main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderRodaPlay(sesiId));\n }\n\n // ===== API: BANK SOAL =====\n if (method === \"GET\" && path === \"/api/roda/bank\") {\n try {\n return json(await db.getRodaBankList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"POST\" && path === \"/api/roda/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) {\n return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n }\n return json(\n await db.createRodaBank(guruId, body.namaBank, body.mapel, body.kelas),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/roda/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n await db.deleteRodaBank(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SOAL =====\n if (\n method === \"GET\" && path.startsWith(\"/api/roda/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getRodaSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/roda/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.pertanyaan) {\n return json({ error: \"Pertanyaan wajib diisi\" }, 400);\n }\n return json(await db.addRodaSoal(bankId, body.pertanyaan, body.jawaban));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"PUT\" && path.startsWith(\"/api/roda/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.pertanyaan) {\n return json({ error: \"Pertanyaan wajib diisi\" }, 400);\n }\n return json(\n await db.updateRodaSoal(soalId, body.pertanyaan, body.jawaban),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"DELETE\" && path.startsWith(\"/api/roda/soal/\")) {\n try {\n const soalId = path.split(\"/\")[4];\n await db.deleteRodaSoal(soalId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SESI =====\n if (method === \"POST\" && path === \"/api/roda/sesi\") {\n try {\n const body = await req.json();\n if (\n !body.bankId || !body.namaSesi || !Array.isArray(body.timList) ||\n body.timList.length < 1 || body.timList.length > 20\n ) {\n return json({\n error:\n \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-20 tim)\",\n }, 400);\n }\n return json(\n await db.createRodaSesi(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.timList,\n Array.isArray(body.powerUpDaftar) ? body.powerUpDaftar : null,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/roda/sesi/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getRodaSesiDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/roda/sesi/\") &&\n path.endsWith(\"/putaran\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.timId) return json({ error: \"Tim wajib diisi\" }, 400);\n await db.catatPutaran(\n sesiId,\n body.soalId ?? null,\n body.timId,\n !!body.benar,\n body.poinDidapat ?? 0,\n body.segmen ?? \"\",\n );\n\n let hasilKejutan = null;\n if (body.benar && body.timId) {\n const sesiSekarang = await db.getRodaSesiDetail(sesiId);\n hasilKejutan = kejutan.rollKejutanSkor(\n sesiSekarang.tim,\n body.timId,\n body.poinDidapat ?? 0,\n kejutan.daftarAktifDariSesi(sesiSekarang.sesi),\n );\n if (hasilKejutan) {\n await db.terapkanKejutanSkor(hasilKejutan.timUpdates);\n }\n }\n\n return json({ ok: true, kejutan: hasilKejutan });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/roda/sesi/\") &&\n path.endsWith(\"/giliran\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n await db.updateRodaGiliran(sesiId, body.giliranBaru ?? 0);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/roda/sesi/\") &&\n path.endsWith(\"/selesai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.selesaikanRodaSesi(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,592,334],"roda-putar","696401b8-b245-48e1-bd7a-4d6679c2023f","196e2c44-9dc2-11f1-b5b4-1607ee4eb77e",262,["D",1787874311510],"import { supabase } from \"../../supabase-client.ts\";\n\n// ===== BANK SOAL =====\n\nexport async function getRodaBankList(guruId: string) {\n const { data, error } = await supabase\n .from(\"roda_bank_soal\")\n .select(\"*, roda_soal(count)\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function createRodaBank(\n guruId: string,\n namaBank: string,\n mapel: string,\n kelas: string,\n) {\n const { data, error } = await supabase\n .from(\"roda_bank_soal\")\n .insert({ guru_id: guruId, nama_bank: namaBank, mapel, kelas })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteRodaBank(bankId: string) {\n const { error } = await supabase.from(\"roda_bank_soal\").delete().eq(\n \"id\",\n bankId,\n );\n if (error) throw error;\n}\n\n// ===== SOAL =====\n\nexport async function getRodaSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"roda_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"created_at\");\n if (error) throw error;\n return data;\n}\n\nexport async function addRodaSoal(\n bankId: string,\n pertanyaan: string,\n jawaban: string,\n) {\n const { data, error } = await supabase\n .from(\"roda_soal\")\n .insert({ bank_id: bankId, pertanyaan, jawaban })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function updateRodaSoal(\n soalId: string,\n pertanyaan: string,\n jawaban: string,\n) {\n const { data, error } = await supabase\n .from(\"roda_soal\")\n .update({ pertanyaan, jawaban })\n .eq(\"id\", soalId)\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteRodaSoal(soalId: string) {\n const { error } = await supabase.from(\"roda_soal\").delete().eq(\"id\", soalId);\n if (error) throw error;\n}\n\n// ===== SESI =====\n\nexport async function createRodaSesi(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n timList: { nama: string; warna: string }[],\n powerUpDaftar: string[] | null = null,\n) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"roda_sesi\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n power_up_aktif: !!(powerUpDaftar && powerUpDaftar.length > 0),\n power_up_daftar: powerUpDaftar,\n })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase.from(\"roda_tim\")\n .insert(timRows).select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nexport async function getRodaSesiDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase.from(\"roda_sesi\")\n .select(\"*\").eq(\"id\", sesiId).single();\n if (sesiError) throw sesiError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"roda_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id);\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"roda_tim\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const { data: soalTerpakai, error: terpakaiError } = await supabase\n .from(\"roda_soal_terpakai\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId);\n if (terpakaiError) throw terpakaiError;\n\n return { sesi, soal, tim, soalTerpakai };\n}\n\nexport async function catatPutaran(\n sesiId: string,\n soalId: string | null,\n timId: string,\n benar: boolean,\n poinDidapat: number,\n segmen: string,\n) {\n if (soalId) {\n const { error } = await supabase\n .from(\"roda_soal_terpakai\")\n .insert({\n sesi_id: sesiId,\n soal_id: soalId,\n tim_menjawab_id: timId,\n benar,\n poin_didapat: poinDidapat,\n segmen,\n });\n if (error) throw error;\n }\n\n if (timId && benar && poinDidapat > 0) {\n const { data: timSekarang } = await supabase.from(\"roda_tim\").select(\"skor\")\n .eq(\"id\", timId).single();\n await supabase.from(\"roda_tim\").update({\n skor: (timSekarang?.skor ?? 0) + poinDidapat,\n }).eq(\"id\", timId);\n }\n}\n\nexport async function updateRodaGiliran(sesiId: string, giliranBaru: number) {\n const { error } = await supabase.from(\"roda_sesi\").update({\n giliran_tim_index: giliranBaru,\n }).eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function selesaikanRodaSesi(sesiId: string) {\n const { error } = await supabase\n .from(\"roda_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\n// ===== KEJUTAN SKOR (POWER-UP) =====\n\nexport async function terapkanKejutanSkor(\n updates: { id: string; skorBaru: number }[],\n) {\n for (const u of updates) {\n const { error } = await supabase.from(\"roda_tim\").update({\n skor: u.skorBaru,\n }).eq(\"id\", u.id);\n if (error) throw error;\n }\n}\n\n// ===== REKAP =====\n\nexport async function getRekapRodaByKelas(guruId: string, kelas?: string) {\n let query = supabase\n .from(\"roda_sesi\")\n .select(\"*, roda_tim(*)\")\n .eq(\"guru_id\", guruId)\n .eq(\"status\", \"selesai\")\n .order(\"tanggal\", { ascending: false });\n if (kelas) query = query.eq(\"kelas\", kelas);\n\n const { data, error } = await query;\n if (error) throw error;\n return data;\n}",[],[183,592,344],"faa6d125-a493-4294-ad7c-35c7e529086a","9b40a53a-9dc2-11f1-a6c9-1607ee4eb77e","89998a18-9dc2-11f1-8633-1607ee4eb77e",252,["D",1787834971188],"export async function renderRodaPlay(sesiId: string): Promise {\n return `\n\n\n \n \n Main - Roda Putar Untung\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,592,169,352],"1567cb87-a8cd-41f9-9d93-d3ceb6de25fa","9345ab5a-9dc2-11f1-b3e3-1607ee4eb77e",158,["D",1787363080266],"export async function renderRodaEditor(bankId: string): Promise {\n return `\n\n\n \n \n Edit Soal Roda - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,592,169,361],"6b01bb16-c9a0-4f66-ac34-558a337125e5","8ec04144-9dc2-11f1-a56c-1607ee4eb77e",312,["D",1788082039594],"export async function renderRodaDashboard(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Roda Putar Untung - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,592,169,369],"e97daa62-78e9-44b2-97cb-dace918a7ce1",124,["D",1787359432574],[232,233,234],[183,592,169],"7db4471b-95fd-418e-b09c-ea20b8606e40",105,["D",1787359234169],[231,235,236],[183,592],"eebcafcb-05d6-4b2c-b5d2-8387d31dafae","d30dcc3a-a124-11f1-9b62-1607ee4eb77e","b55d2faa-a124-11f1-bd39-1607ee4eb77e",481,["D",1788331465481],7,"import * as db from \"./database.ts\";\nimport * as kejutan from \"../../lib/powerups.ts\";\nimport { buatSignatureUpload } from \"../../lib/cloudinary.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/editor.ts\";\nimport { renderGamePlay } from \"./views/play.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nconst TIPE_VALID = [\"pilihan_ganda\", \"benar_salah\", \"mencocokkan\"];\n\nexport async function handleKuisPilihanGanda(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n namaGuru: string,\n): Promise {\n // ===== HALAMAN =====\n if (method === \"GET\" && path === \"/kuis-pg\") {\n return html(await renderDashboard(guruId, namaGuru));\n }\n if (\n method === \"GET\" && path.startsWith(\"/pg-bank/\") && path.endsWith(\"/edit\")\n ) {\n const bankId = path.split(\"/\")[2];\n return html(await renderBankEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/pg-main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderGamePlay(sesiId));\n }\n\n // ===== API: BANK SOAL =====\n if (method === \"GET\" && path === \"/api/pg/bank\") {\n try {\n return json(await db.getBankSoalList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/pg/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getBankSoalById(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"POST\" && path === \"/api/pg/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) {\n return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n }\n return json(\n await db.createBankSoal(guruId, body.namaBank, body.mapel, body.kelas),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/pg/bank/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n await db.deleteBankSoal(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: UPLOAD GAMBAR (Cloudinary signed upload) =====\n if (method === \"POST\" && path === \"/api/pg/upload-signature\") {\n try {\n return json(await buatSignatureUpload(\"kuis-pg\"));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SOAL =====\n if (\n method === \"GET\" && path.startsWith(\"/api/pg/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n return json(await db.getSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/bank/\") &&\n path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.urutan || !body.pertanyaan) {\n return json({ error: \"Urutan dan pertanyaan wajib diisi\" }, 400);\n }\n\n const tipeSoal = TIPE_VALID.includes(body.tipeSoal)\n ? body.tipeSoal\n : \"pilihan_ganda\";\n\n if (tipeSoal === \"pilihan_ganda\") {\n const opsiTerisi = (teks: unknown, gambar: unknown) =>\n (typeof teks === \"string\" && teks.trim().length > 0) ||\n (typeof gambar === \"string\" && gambar.trim().length > 0);\n if (\n !opsiTerisi(body.opsiA, body.gambarOpsiA) ||\n !opsiTerisi(body.opsiB, body.gambarOpsiB) ||\n !opsiTerisi(body.opsiC, body.gambarOpsiC) ||\n !opsiTerisi(body.opsiD, body.gambarOpsiD) ||\n ![\"a\", \"b\", \"c\", \"d\"].includes(body.jawabanBenar)\n ) {\n return json({\n error:\n \"4 opsi jawaban (teks atau gambar) dan penanda jawaban benar wajib diisi\",\n }, 400);\n }\n } else if (tipeSoal === \"benar_salah\") {\n if (typeof body.jawabanBenarBs !== \"boolean\") {\n return json({\n error: \"Tandai jawaban yang benar (Benar atau Salah)\",\n }, 400);\n }\n } else if (tipeSoal === \"mencocokkan\") {\n const pasangan = Array.isArray(body.pasangan) ? body.pasangan : [];\n if (pasangan.length < 2) {\n return json({\n error: \"Soal mencocokkan minimal butuh 2 pasangan\",\n }, 400);\n }\n const semuaTerisi = pasangan.every((p: any) =>\n typeof p?.kiri === \"string\" && p.kiri.trim().length > 0 &&\n typeof p?.kanan === \"string\" && p.kanan.trim().length > 0\n );\n if (!semuaTerisi) {\n return json({\n error: \"Semua pasangan (kiri & kanan) wajib diisi\",\n }, 400);\n }\n }\n\n return json(\n await db.upsertSoal(bankId, body.urutan, {\n tipeSoal,\n pertanyaan: body.pertanyaan,\n poin: body.poin ?? 10,\n gambarUrl: body.gambarUrl,\n opsiA: body.opsiA ?? \"\",\n opsiB: body.opsiB ?? \"\",\n opsiC: body.opsiC ?? \"\",\n opsiD: body.opsiD ?? \"\",\n jawabanBenar: body.jawabanBenar,\n gambarOpsiA: body.gambarOpsiA,\n gambarOpsiB: body.gambarOpsiB,\n gambarOpsiC: body.gambarOpsiC,\n gambarOpsiD: body.gambarOpsiD,\n jawabanBenarBs: body.jawabanBenarBs,\n pasangan: body.pasangan,\n }),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/pg/soal/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const soalId = path.split(\"/\")[4];\n await db.deleteSoal(soalId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SESI =====\n if (method === \"POST\" && path === \"/api/pg/sesi\") {\n try {\n const body = await req.json();\n if (\n !body.bankId || !body.namaSesi || !Array.isArray(body.timList) ||\n body.timList.length < 1 || body.timList.length > 20\n ) {\n return json({\n error:\n \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-20 tim)\",\n }, 400);\n }\n return json(\n await db.createSesi(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.modeGiliran === \"rebutan\" ? \"rebutan\" : \"urut\",\n body.timList,\n Array.isArray(body.powerUpDaftar) ? body.powerUpDaftar : null,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/pg/sesi/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getSesiDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/sesi/\") &&\n path.endsWith(\"/jawab\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n if (typeof body.soalIndex !== \"number\") {\n return json({ error: \"soalIndex wajib diisi\" }, 400);\n }\n // opsiDipilih (huruf a-d) hanya relevan untuk pilihan ganda; untuk\n // tipe lain (benar_salah, mencocokkan) jawaban lengkapnya disimpan\n // di jawabanJson, opsiDipilih dibiarkan null.\n const opsiDipilih = [\"a\", \"b\", \"c\", \"d\"].includes(body.opsiDipilih)\n ? body.opsiDipilih\n : null;\n const hasilJawab = await db.catatJawaban(\n sesiId,\n body.soalIndex,\n body.timId ?? null,\n opsiDipilih,\n !!body.benar,\n body.poinDidapat ?? 0,\n body.jawabanJson ?? null,\n );\n\n let hasilKejutan = null;\n if (body.benar && body.timId) {\n const sesiSekarang = await db.getSesiDetail(sesiId);\n hasilKejutan = kejutan.rollKejutanSkor(\n sesiSekarang.tim,\n body.timId,\n body.poinDidapat ?? 0,\n kejutan.daftarAktifDariSesi(sesiSekarang.sesi),\n );\n if (hasilKejutan) {\n await db.terapkanKejutanSkor(hasilKejutan.timUpdates);\n }\n }\n\n return json({ ...hasilJawab, kejutan: hasilKejutan });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/sesi/\") &&\n path.endsWith(\"/lanjut\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n await db.lanjutSoal(\n sesiId,\n body.soalKeBaru ?? 0,\n body.giliranTimBaru ?? 0,\n );\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/sesi/\") &&\n path.endsWith(\"/selesai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.selesaikanSesi(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,641,334],"kuis-pilihan-ganda","46de5430-97d0-405f-9c23-9c373d13d173","cc8ee484-a124-11f1-aa00-1607ee4eb77e",480,["D",1788331447247],"import { supabase } from \"../../supabase-client.ts\";\n\nexport type TipeSoal = \"pilihan_ganda\" | \"benar_salah\" | \"mencocokkan\";\n\nexport interface PasanganMencocokkan {\n kiri: string;\n kanan: string;\n}\n\n// ===== BANK SOAL =====\n\nexport async function getBankSoalList(guruId: string) {\n const { data, error } = await supabase\n .from(\"game_quiz_bank\")\n .select(\"*\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function getBankSoalById(bankId: string) {\n const { data, error } = await supabase.from(\"game_quiz_bank\").select(\"*\")\n .eq(\"id\", bankId).single();\n if (error) throw error;\n return data;\n}\n\nexport async function createBankSoal(\n guruId: string,\n namaBank: string,\n mapel: string,\n kelas: string,\n) {\n const { data, error } = await supabase\n .from(\"game_quiz_bank\")\n .insert({ guru_id: guruId, nama_bank: namaBank, mapel, kelas })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteBankSoal(bankId: string) {\n const { error } = await supabase.from(\"game_quiz_bank\").delete().eq(\n \"id\",\n bankId,\n );\n if (error) throw error;\n}\n\n// ===== SOAL =====\n\nexport async function getSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"urutan\");\n if (error) throw error;\n return data;\n}\n\n// Data soal generik untuk ke-3 tipe. Field yang tidak relevan dengan\n// tipeSoal boleh diabaikan/kosong — validasi per tipe dilakukan di\n// router.ts sebelum function ini dipanggil.\nexport interface DataSoal {\n tipeSoal: TipeSoal;\n pertanyaan: string;\n poin: number;\n gambarUrl?: string | null;\n // ----- pilihan_ganda -----\n opsiA?: string;\n opsiB?: string;\n opsiC?: string;\n opsiD?: string;\n jawabanBenar?: \"a\" | \"b\" | \"c\" | \"d\";\n gambarOpsiA?: string | null;\n gambarOpsiB?: string | null;\n gambarOpsiC?: string | null;\n gambarOpsiD?: string | null;\n // ----- benar_salah -----\n jawabanBenarBs?: boolean;\n // ----- mencocokkan -----\n pasangan?: PasanganMencocokkan[];\n}\n\nexport async function upsertSoal(\n bankId: string,\n urutan: number,\n data: DataSoal,\n) {\n const { data: row, error } = await supabase\n .from(\"game_quiz_soal\")\n .upsert(\n {\n bank_id: bankId,\n urutan,\n tipe_soal: data.tipeSoal,\n pertanyaan: data.pertanyaan,\n poin: data.poin,\n gambar_url: data.gambarUrl ?? null,\n // Kolom pilihan ganda dikosongkan kalau tipe soalnya bukan PG,\n // supaya tidak menyisakan data basi dari edit tipe sebelumnya.\n opsi_a: data.tipeSoal === \"pilihan_ganda\" ? (data.opsiA ?? \"\") : \"\",\n opsi_b: data.tipeSoal === \"pilihan_ganda\" ? (data.opsiB ?? \"\") : \"\",\n opsi_c: data.tipeSoal === \"pilihan_ganda\" ? (data.opsiC ?? \"\") : \"\",\n opsi_d: data.tipeSoal === \"pilihan_ganda\" ? (data.opsiD ?? \"\") : \"\",\n jawaban_benar: data.tipeSoal === \"pilihan_ganda\"\n ? (data.jawabanBenar ?? null)\n : null,\n gambar_opsi_a: data.tipeSoal === \"pilihan_ganda\"\n ? (data.gambarOpsiA ?? null)\n : null,\n gambar_opsi_b: data.tipeSoal === \"pilihan_ganda\"\n ? (data.gambarOpsiB ?? null)\n : null,\n gambar_opsi_c: data.tipeSoal === \"pilihan_ganda\"\n ? (data.gambarOpsiC ?? null)\n : null,\n gambar_opsi_d: data.tipeSoal === \"pilihan_ganda\"\n ? (data.gambarOpsiD ?? null)\n : null,\n jawaban_benar_bs: data.tipeSoal === \"benar_salah\"\n ? (data.jawabanBenarBs ?? null)\n : null,\n pasangan_mencocokkan: data.tipeSoal === \"mencocokkan\"\n ? (data.pasangan ?? [])\n : null,\n },\n { onConflict: \"bank_id,urutan\" },\n )\n .select()\n .single();\n if (error) throw error;\n return row;\n}\n\nexport async function deleteSoal(soalId: string) {\n const { error } = await supabase.from(\"game_quiz_soal\").delete().eq(\n \"id\",\n soalId,\n );\n if (error) throw error;\n}\n\n// ===== SESI =====\n\nexport async function createSesi(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n modeGiliran: \"urut\" | \"rebutan\",\n timList: { nama: string; warna: string }[],\n powerUpDaftar: string[] | null = null,\n) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n mode_giliran: modeGiliran,\n power_up_aktif: !!(powerUpDaftar && powerUpDaftar.length > 0),\n power_up_daftar: powerUpDaftar,\n })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase\n .from(\"game_quiz_tim\")\n .insert(timRows)\n .select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nexport async function getSesiDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi\")\n .select(\"*\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"game_quiz_tim\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const { data: jawaban, error: jawabanError } = await supabase\n .from(\"game_quiz_jawaban\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId);\n if (jawabanError) throw jawabanError;\n\n return { sesi, soal, tim, jawaban };\n}\n\nexport async function catatJawaban(\n sesiId: string,\n soalIndex: number,\n timId: string | null,\n opsiDipilih: \"a\" | \"b\" | \"c\" | \"d\" | null,\n benar: boolean,\n poinDidapat: number,\n jawabanJson: unknown = null,\n) {\n const { data, error } = await supabase\n .from(\"game_quiz_jawaban\")\n .insert({\n sesi_id: sesiId,\n soal_index: soalIndex,\n tim_id: timId,\n opsi_dipilih: opsiDipilih,\n jawaban_json: jawabanJson,\n benar,\n poin_didapat: poinDidapat,\n })\n .select()\n .single();\n if (error) throw error;\n\n if (timId && benar) {\n const { data: timSekarang } = await supabase.from(\"game_quiz_tim\").select(\n \"skor\",\n ).eq(\"id\", timId).single();\n await supabase.from(\"game_quiz_tim\").update({\n skor: (timSekarang?.skor ?? 0) + poinDidapat,\n }).eq(\"id\", timId);\n }\n\n return data;\n}\n\n// ===== KEJUTAN SKOR (POWER-UP) =====\n\nexport async function terapkanKejutanSkor(\n updates: { id: string; skorBaru: number }[],\n) {\n for (const u of updates) {\n const { error } = await supabase.from(\"game_quiz_tim\").update({\n skor: u.skorBaru,\n }).eq(\"id\", u.id);\n if (error) throw error;\n }\n}\n\nexport async function lanjutSoal(\n sesiId: string,\n soalKeBaru: number,\n giliranTimBaru: number,\n) {\n const { error } = await supabase.from(\"game_quiz_sesi\").update({\n soal_ke: soalKeBaru,\n giliran_tim_index: giliranTimBaru,\n }).eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function selesaikanSesi(sesiId: string) {\n const { error } = await supabase\n .from(\"game_quiz_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}",[],[183,641,344],"e6b0d167-791c-41de-9f91-b6939bf547ed","f1a5de8a-a124-11f1-9824-1607ee4eb77e","de8fe9bc-a124-11f1-855b-1607ee4eb77e",490,["D",1788392277978],"export async function renderGamePlay(sesiId: string): Promise {\n return `\n\n\n \n \n Main Kuis - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,169,352],"35813ccb-781d-4c65-bfba-ffec106cd73c","ed38a9cc-a124-11f1-bd3f-1607ee4eb77e",489,["D",1788392254419],12,"export async function renderBankEditor(bankId: string): Promise {\n return `\n\n\n \n \n Edit Bank Soal Kuis - Game Kelas Seru\n \n \n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,169,361],"a9d5513b-6b21-456a-bd01-40ff6370bf02","e79ea48a-a124-11f1-9b62-1607ee4eb77e",313,["D",1788082214281],14,"export async function renderDashboard(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Kuis Pilihan Ganda - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,169,369],"8ac6f20c-a813-48d0-9c67-e4748e4994d8",171,["D",1787731521991],[225,226,227],[183,641,169],"edb89455-16d8-4436-944e-edcddacf9f42","d6100252-a126-11f1-9610-1607ee4eb77e","c806af76-a126-11f1-be47-1607ee4eb77e",484,["D",1788331546183],"import * as db from \"./database.ts\";\nimport { renderGabung } from \"./views/gabung.ts\";\nimport { renderKerjakan } from \"./views/kerjakan.ts\";\nimport { renderLobi } from \"./views/lobi.ts\";\nimport { renderLaporan } from \"./views/laporan.ts\";\nimport { renderRiwayat } from \"./views/riwayat.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\n// ============================================================\n// RUTE PUBLIK — dipanggil SEBELUM cek session di main.ts.\n// Ini yang diakses siswa dari HP masing-masing, tanpa akun.\n// ============================================================\nexport async function handleOlimpiadePublic(\n req: Request,\n method: string,\n path: string,\n): Promise {\n if (method === \"GET\" && path === \"/gabung\") {\n return html(await renderGabung());\n }\n if (method === \"GET\" && path.startsWith(\"/kerjakan/\")) {\n const pesertaId = path.split(\"/\")[2];\n return html(await renderKerjakan(pesertaId));\n }\n\n if (method === \"POST\" && path === \"/api/pg/gabung\") {\n try {\n const body = await req.json();\n const pin = String(body.pin || \"\").trim();\n if (!/^\\d{6}$/.test(pin)) {\n return json({ error: \"PIN harus 6 digit angka\" }, 400);\n }\n const sesi = await db.cariSesiByPin(pin);\n if (!sesi) {\n return json(\n { error: \"PIN tidak ditemukan atau sesi sudah selesai\" },\n 404,\n );\n }\n return json({\n sesiId: sesi.id,\n namaSesi: sesi.nama_sesi,\n status: sesi.status,\n });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/sesi-pin/\") &&\n path.endsWith(\"/peserta\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n const nama = String(body.namaPeserta || \"\").trim();\n if (!nama) return json({ error: \"Nama wajib diisi\" }, 400);\n if (nama.length > 40) {\n return json({ error: \"Nama maksimal 40 karakter\" }, 400);\n }\n const peserta = await db.daftarPeserta(sesiId, nama);\n return json({ pesertaId: peserta.id });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"GET\" && path.startsWith(\"/api/pg/peserta/\") &&\n path.endsWith(\"/state\")\n ) {\n try {\n const pesertaId = path.split(\"/\")[4];\n return json(await db.getPesertaState(pesertaId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/peserta/\") &&\n path.endsWith(\"/jawab\")\n ) {\n try {\n const pesertaId = path.split(\"/\")[4];\n const body = await req.json();\n if (typeof body.soalIndex !== \"number\") {\n return json({ error: \"soalIndex wajib diisi\" }, 400);\n }\n // Field yang relevan tergantung tipe soal (server yang menentukan\n // tipe sebenarnya dari database, field lain di luar tipe itu\n // otomatis diabaikan saat grading — lihat gradeJawaban).\n const jawabanInput = {\n opsiDipilih: [\"a\", \"b\", \"c\", \"d\"].includes(body.opsiDipilih)\n ? body.opsiDipilih\n : null,\n jawabanBs: typeof body.jawabanBs === \"boolean\" ? body.jawabanBs : null,\n pasanganDipilih: Array.isArray(body.pasanganDipilih)\n ? body.pasanganDipilih\n : null,\n };\n const modeWaktu = body.modeWaktu === \"per_game\" ? \"per_game\" : \"per_soal\";\n const hasil = modeWaktu === \"per_game\"\n ? await db.simpanJawabanPesertaGame(\n pesertaId,\n body.soalIndex,\n jawabanInput,\n body.waktuJawabMs ?? 0,\n )\n : await db.catatJawabanPeserta(\n pesertaId,\n body.soalIndex,\n jawabanInput,\n body.waktuJawabMs ?? 0,\n );\n return json(hasil);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/peserta/\") &&\n path.endsWith(\"/pindah\")\n ) {\n try {\n const pesertaId = path.split(\"/\")[4];\n const body = await req.json();\n if (typeof body.soalKe !== \"number\") {\n return json({ error: \"soalKe wajib diisi\" }, 400);\n }\n const hasil = await db.pindahSoalPesertaGame(pesertaId, body.soalKe);\n return json(hasil);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/peserta/\") &&\n path.endsWith(\"/selesai\")\n ) {\n try {\n const pesertaId = path.split(\"/\")[4];\n const hasil = await db.selesaikanPesertaGame(pesertaId);\n return json(hasil);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}\n\n// ============================================================\n// RUTE GURU — dipanggil SESUDAH cek session, sama seperti\n// router game lain (butuh login).\n// ============================================================\nexport async function handleOlimpiadeGuru(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n _namaGuru: string,\n): Promise {\n if (\n method === \"GET\" && path.startsWith(\"/pg-olimpiade/\") &&\n path.endsWith(\"/lobi\")\n ) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderLobi(sesiId));\n }\n if (\n method === \"GET\" && path.startsWith(\"/pg-olimpiade/\") &&\n path.endsWith(\"/laporan\")\n ) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderLaporan(sesiId));\n }\n if (\n method === \"GET\" && path.startsWith(\"/pg-olimpiade/riwayat/\") &&\n path.split(\"/\").length === 4\n ) {\n const bankId = path.split(\"/\")[3];\n return html(await renderRiwayat(bankId));\n }\n\n if (method === \"POST\" && path === \"/api/pg/olimpiade\") {\n try {\n const body = await req.json();\n if (!body.bankId || !body.namaSesi) {\n return json({ error: \"bankId dan namaSesi wajib diisi\" }, 400);\n }\n const modeWaktu = body.modeWaktu === \"per_game\" ? \"per_game\" : \"per_soal\";\n const modeMulai = body.modeMulai === \"otomatis\" ? \"otomatis\" : \"manual\";\n\n let waktuPerSoalDetik: number | null = null;\n let waktuTotalMenit: number | null = null;\n\n if (modeWaktu === \"per_soal\") {\n waktuPerSoalDetik = Number(body.waktuPerSoalDetik) || 30;\n if (waktuPerSoalDetik < 5 || waktuPerSoalDetik > 300) {\n return json(\n { error: \"Waktu per soal harus antara 5-300 detik\" },\n 400,\n );\n }\n } else {\n waktuTotalMenit = Number(body.waktuTotalMenit) || 60;\n if (waktuTotalMenit < 1 || waktuTotalMenit > 480) {\n return json(\n { error: \"Waktu total harus antara 1-480 menit\" },\n 400,\n );\n }\n }\n\n // ===== Jendela \"kuis dibuka dari - sampai\", maksimal 30 hari =====\n if (!body.dibukaMulai || !body.dibukaSelesai) {\n return json(\n { error: \"Kuis dibuka mulai dan sampai kapan wajib diisi\" },\n 400,\n );\n }\n const bukaMulaiMs = new Date(body.dibukaMulai).getTime();\n const bukaSelesaiMs = new Date(body.dibukaSelesai).getTime();\n if (isNaN(bukaMulaiMs) || isNaN(bukaSelesaiMs)) {\n return json({ error: \"Format tanggal buka kuis tidak valid\" }, 400);\n }\n if (bukaSelesaiMs <= bukaMulaiMs) {\n return json(\n { error: \"Waktu 'sampai' harus setelah waktu 'mulai'\" },\n 400,\n );\n }\n const MAKS_JENDELA_MS = 30 * 24 * 60 * 60 * 1000; // 30 hari\n if (bukaSelesaiMs - bukaMulaiMs > MAKS_JENDELA_MS) {\n return json(\n { error: \"Kuis maksimal bisa dibuka selama 30 hari\" },\n 400,\n );\n }\n\n const sesi = await db.createSesiPin(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n modeWaktu,\n waktuPerSoalDetik,\n waktuTotalMenit,\n new Date(bukaMulaiMs).toISOString(),\n new Date(bukaSelesaiMs).toISOString(),\n modeMulai,\n );\n return json(sesi);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"GET\" && path.startsWith(\"/api/pg/olimpiade/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getSesiPinDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"DELETE\" && path.startsWith(\"/api/pg/olimpiade/\") &&\n path.split(\"/\").length === 5\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.hapusSesiPin(sesiId, guruId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"DELETE\" && path.startsWith(\"/api/pg/olimpiade/peserta/\") &&\n path.split(\"/\").length === 6\n ) {\n try {\n const pesertaId = path.split(\"/\")[5];\n await db.hapusPeserta(pesertaId, guruId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"GET\" && path.startsWith(\"/api/pg/olimpiade/riwayat/\")\n ) {\n try {\n const bankId = path.split(\"/\")[5];\n return json(await db.getRiwayatOlimpiade(bankId, guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/olimpiade/\") &&\n path.endsWith(\"/mulai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.mulaiSesiPin(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"GET\" && path.startsWith(\"/api/pg/olimpiade/\") &&\n path.endsWith(\"/laporan\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n return json(await db.getLaporan(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/olimpiade/\") &&\n path.endsWith(\"/akhiri\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n await db.akhiriSesiPin(sesiId, guruId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (\n method === \"POST\" && path.startsWith(\"/api/pg/olimpiade/\") &&\n path.endsWith(\"/buka-kembali\")\n ) {\n try {\n const sesiId = path.split(\"/\")[4];\n const body = await req.json();\n if (!body.dibukaSelesaiBaru) {\n return json({ error: \"Waktu tutup baru wajib diisi\" }, 400);\n }\n const waktuBaruMs = new Date(body.dibukaSelesaiBaru).getTime();\n if (isNaN(waktuBaruMs)) {\n return json({ error: \"Format tanggal tidak valid\" }, 400);\n }\n if (waktuBaruMs <= Date.now()) {\n return json(\n { error: \"Waktu tutup baru harus di masa depan\" },\n 400,\n );\n }\n await db.bukaKembaliSesiPin(\n sesiId,\n guruId,\n new Date(waktuBaruMs).toISOString(),\n );\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,641,686,334],"olimpiade","261f8041-a439-40e9-888f-b960fcbc1ae8","d13d78b8-a126-11f1-9d87-1607ee4eb77e",492,["D",1788392344508],13,"import { supabase } from \"../../../supabase-client.ts\";\n\nfunction generatePin(): string {\n return String(Math.floor(100000 + Math.random() * 900000));\n}\n\n// Supabase kadang mengembalikan timestamp TANPA penanda zona (kolom \"timestamp\"\n// tanpa time zone, bukan \"timestamptz\"). Tanpa \"Z\"/offset di akhir string, JS\n// menafsirkannya sebagai waktu LOKAL server, bukan UTC — bisa meleset berjam-jam\n// dan membuat deadline dianggap sudah lewat padahal sesi baru saja dimulai.\n// Paksa selalu dibaca sebagai UTC kalau belum ada penanda zona.\nfunction msUtc(waktuIso: string): number {\n const adaZona = /Z$|[+-]\\d\\d:?\\d\\d$/.test(waktuIso);\n return new Date(adaZona ? waktuIso : waktuIso + \"Z\").getTime();\n}\n\n// ============================================================\n// PERBAIKAN BUG \"peserta ke-40+ langsung selesai tanpa lihat soal\"\n// ------------------------------------------------------------\n// Sebelumnya deadline mode \"per_game\" SELALU dihitung dari\n// sesi.dibuka_at (waktu sesi mulai/dibuat), sama untuk SEMUA peserta.\n// Kalau proses satu per satu peserta join makan waktu lama (kelas\n// besar, 40+ siswa antre isi PIN & nama), peserta yang baru gabung\n// belakangan bisa saja baru dapat ID setelah deadline global itu\n// SUDAH lewat -> begitu buka halaman kerjakan, sistem langsung\n// menganggap waktu habis dan menandai \"selesai\" tanpa sempat\n// menampilkan satu soal pun.\n//\n// Perbaikan: waktu mulai hitung mundur untuk peserta tertentu adalah\n// yang PALING BELAKANGAN antara waktu sesi mulai (dibuka_at) dan\n// waktu peserta itu sendiri join (joined_at). Peserta yang sudah\n// menunggu di lobi sebelum sesi dimulai tetap mulai bareng-bareng\n// dari dibuka_at (tidak berubah). Peserta yang baru gabung SETELAH\n// sesi berjalan (termasuk mode \"otomatis\" yang langsung berjalan\n// sejak dibuat) mendapat jatah waktu penuh dihitung dari saat dia\n// sendiri join, bukan ikut-ikutan deadline global yang sudah lewat.\n// ============================================================\nfunction hitungMulaiWaktuMs(sesi: any, peserta: any): number {\n const mulaiSesiMs = msUtc(sesi.dibuka_at);\n const gabungPesertaMs = msUtc(peserta.joined_at);\n return Math.max(mulaiSesiMs, gabungPesertaMs);\n}\n\n// Cek apakah sekarang berada di dalam jendela waktu \"dibuka\" sesi (kolom\n// dibuka_mulai / dibuka_selesai). Dipakai di sisi siswa (cariSesiByPin &\n// daftarPeserta) supaya PIN tidak bisa dipakai sebelum/sesudah jadwal yang\n// guru tentukan, walau statusnya masih \"menunggu\"/\"berjalan\".\nfunction cekJendelaWaktuSesi(sesi: any): string | null {\n if (sesi.dibuka_mulai && Date.now() < msUtc(sesi.dibuka_mulai)) {\n return \"Kuis belum dibuka. Kuis ini baru bisa diikuti mulai \" +\n new Date(sesi.dibuka_mulai).toLocaleString(\"id-ID\");\n }\n if (sesi.dibuka_selesai && Date.now() > msUtc(sesi.dibuka_selesai)) {\n return \"Kuis sudah ditutup dan tidak bisa diikuti lagi.\";\n }\n return null;\n}\n\n// ============================================================\n// ACAK SOAL & OPSI PER PESERTA\n// ------------------------------------------------------------\n// Tiap peserta (device) mendapat:\n// - urutanSoal: urutan tampil soal, berisi index KANONIS (index\n// soal sesuai urutan asli di bank soal, 0..n-1) diacak per peserta.\n// - acakOpsi: untuk tiap soal (dikunci per index kanonis), urutan\n// 4 huruf kanonis (a/b/c/d) yang menentukan opsi apa yang tampil\n// di posisi tombol A/B/C/D di layar peserta itu. Karena posisi\n// jawaban benar ikut diacak di dalam array ini, kunci jawaban\n// otomatis \"berpindah\" (misal jadi tampil di D) secara acak dan\n// berbeda-beda antar device.\n//\n// PENTING: skor & kunci jawaban tetap dicocokkan memakai huruf\n// KANONIS (sesuai bank soal asli) — bukan huruf yang tampil di\n// layar. Begitu juga soal_index yang disimpan ke tabel jawaban\n// selalu index kanonis, supaya laporan guru (\"Soal 1\", \"Soal 2\",\n// dst, jawaban \"A/B/C/D\") tetap match dengan kunci jawaban asli di\n// bank soal, walau urutan & huruf yang dilihat tiap siswa berbeda.\n// ============================================================\n\nfunction acakArray(arr: T[]): T[] {\n const hasil = [...arr];\n for (let i = hasil.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [hasil[i], hasil[j]] = [hasil[j], hasil[i]];\n }\n return hasil;\n}\n\nfunction buatUrutanSoal(jumlahSoal: number): number[] {\n return acakArray(Array.from({ length: jumlahSoal }, (_, i) => i));\n}\n\nfunction tipeSoalDari(soal: any): string {\n return soal?.tipe_soal || \"pilihan_ganda\";\n}\n\n// Bentuk \"peta acak\" per soal tergantung tipenya:\n// - pilihan_ganda: permutasi 4 huruf [\"a\",\"b\",\"c\",\"d\"] (perilaku lama).\n// - mencocokkan: permutasi index kanonis pasangan (0..n-1), dipakai\n// untuk mengacak urutan tampil kolom KANAN saja (kolom kiri tetap\n// urut). Peta ini TIDAK pernah dikirim ke klien (lihat\n// acakSoalUntukTampilan) karena posisi asli = jawaban benarnya\n// sendiri (kiri[i] berpasangan dengan kanan[i]) — kalau peta\n// dikirim mentah-mentah ke klien, itu sama saja membocorkan kunci\n// jawaban.\n// - benar_salah: tidak butuh pengacakan (cuma 1 bit informasi),\n// petanya array kosong.\nfunction buatAcakOpsi(soalList: any[]): Record {\n const hasil: Record = {};\n soalList.forEach((soal, i) => {\n const tipe = tipeSoalDari(soal);\n if (tipe === \"mencocokkan\") {\n const n = (soal.pasangan_mencocokkan || []).length;\n hasil[String(i)] = acakArray(Array.from({ length: n }, (_, k) => k));\n } else if (tipe === \"benar_salah\") {\n hasil[String(i)] = [];\n } else {\n hasil[String(i)] = acakArray([\"a\", \"b\", \"c\", \"d\"]);\n }\n });\n return hasil;\n}\n\n// Pastikan peserta punya urutanSoal/acakOpsi yang valid (panjangnya\n// sesuai jumlah soal saat ini). Kalau belum ada (peserta lama /\n// belum sempat tersimpan), buat baru & simpan sekali supaya\n// konsisten di request-request berikutnya (state di-poll tiap 1.5 detik).\nasync function pastikanUrutanPeserta(\n peserta: any,\n soalList: any[],\n): Promise<{ urutanSoal: number[]; acakOpsi: Record }> {\n const jumlahSoal = soalList.length;\n const urutanValid = Array.isArray(peserta.urutan_soal) &&\n peserta.urutan_soal.length === jumlahSoal;\n const acakValid = peserta.acak_opsi &&\n typeof peserta.acak_opsi === \"object\" &&\n Object.keys(peserta.acak_opsi).length === jumlahSoal;\n\n if (urutanValid && acakValid) {\n return { urutanSoal: peserta.urutan_soal, acakOpsi: peserta.acak_opsi };\n }\n\n const urutanSoal = buatUrutanSoal(jumlahSoal);\n const acakOpsi = buatAcakOpsi(soalList);\n await supabase\n .from(\"game_quiz_peserta\")\n .update({ urutan_soal: urutanSoal, acak_opsi: acakOpsi })\n .eq(\"id\", peserta.id);\n return { urutanSoal, acakOpsi };\n}\n\n// Susun 1 soal untuk ditampilkan ke peserta tertentu. PENTING: kunci\n// jawaban (jawaban_benar / jawaban_benar_bs) dan peta pengacakan\n// kolom kanan pada soal mencocokkan TIDAK PERNAH disertakan di objek\n// yang dikembalikan — semuanya cuma dipakai server-side saat\n// menggradenya (lihat catatJawabanPeserta / simpanJawabanPesertaGame).\nfunction acakSoalUntukTampilan(soal: any, peta: any) {\n const tipe = tipeSoalDari(soal);\n const dasar = {\n id: soal.id,\n tipe_soal: tipe,\n pertanyaan: soal.pertanyaan,\n gambar_url: soal.gambar_url,\n poin: soal.poin,\n };\n\n if (tipe === \"benar_salah\") {\n return dasar;\n }\n\n if (tipe === \"mencocokkan\") {\n const pairs = soal.pasangan_mencocokkan || [];\n const petaKanan: number[] = Array.isArray(peta) && peta.length === pairs.length\n ? peta\n : pairs.map((_: unknown, i: number) => i);\n return {\n ...dasar,\n kiri: pairs.map((p: any) => p.kiri),\n kiriGambar: pairs.map((p: any) => p.kiriGambar ?? null),\n // Kolom kanan dikirim sudah teracak TANPA info mapping — klien\n // cuma tahu \"posisi tampil ke berapa\", bukan index kanonisnya.\n kanan: petaKanan.map((asliIdx) => pairs[asliIdx]?.kanan),\n kananGambar: petaKanan.map((asliIdx) => pairs[asliIdx]?.kananGambar ?? null),\n };\n }\n\n // pilihan_ganda (default, termasuk soal lama tanpa tipe_soal)\n const petaHuruf: string[] = Array.isArray(peta) && peta.length === 4\n ? peta\n : [\"a\", \"b\", \"c\", \"d\"];\n const opsiAsli: Record = {\n a: soal.opsi_a,\n b: soal.opsi_b,\n c: soal.opsi_c,\n d: soal.opsi_d,\n };\n const gambarOpsiAsli: Record = {\n a: soal.gambar_opsi_a,\n b: soal.gambar_opsi_b,\n c: soal.gambar_opsi_c,\n d: soal.gambar_opsi_d,\n };\n return {\n ...dasar,\n opsi_a: opsiAsli[petaHuruf[0]],\n opsi_b: opsiAsli[petaHuruf[1]],\n opsi_c: opsiAsli[petaHuruf[2]],\n opsi_d: opsiAsli[petaHuruf[3]],\n gambar_opsi_a: gambarOpsiAsli[petaHuruf[0]],\n gambar_opsi_b: gambarOpsiAsli[petaHuruf[1]],\n gambar_opsi_c: gambarOpsiAsli[petaHuruf[2]],\n gambar_opsi_d: gambarOpsiAsli[petaHuruf[3]],\n petaOpsi: petaHuruf,\n };\n}\n\n// Untuk mengisi ulang jawaban tersimpan (mode per_game) dengan huruf\n// TAMPILAN yang sesuai untuk peserta ini (kebalikan dari petaOpsi).\nfunction hurufTampilDariKanonis(\n peta: string[],\n hurufKanonis: string | null,\n): string | null {\n if (!hurufKanonis) return null;\n const idx = peta.indexOf(hurufKanonis);\n return idx === -1 ? null : [\"a\", \"b\", \"c\", \"d\"][idx];\n}\n\n// Grading generik untuk 1 jawaban, dipakai baik mode per_soal maupun\n// per_game. `jawabanInput` berisi field yang relevan tergantung tipe\n// soal (field lain diabaikan). `peta` = acak_opsi milik peserta untuk\n// soal ini (dipakai untuk menerjemahkan posisi tampil -> kanonis\n// sebelum dicocokkan dengan kunci jawaban asli).\nfunction gradeJawaban(\n soal: any,\n jawabanInput: {\n opsiDipilih?: \"a\" | \"b\" | \"c\" | \"d\" | null;\n jawabanBs?: boolean | null;\n pasanganDipilih?: { kiriIndex: number; kananPos: number }[] | null;\n },\n peta: any,\n): { benar: boolean; poinDidapat: number; jawabanJson: unknown } {\n const tipe = tipeSoalDari(soal);\n\n if (tipe === \"benar_salah\") {\n const dipilih = typeof jawabanInput.jawabanBs === \"boolean\"\n ? jawabanInput.jawabanBs\n : null;\n const benar = dipilih !== null && dipilih === soal.jawaban_benar_bs;\n return {\n benar,\n poinDidapat: benar ? soal.poin : 0,\n jawabanJson: { tipe: \"benar_salah\", dipilih },\n };\n }\n\n if (tipe === \"mencocokkan\") {\n const pairs = soal.pasangan_mencocokkan || [];\n const petaKanan: number[] = Array.isArray(peta) && peta.length === pairs.length\n ? peta\n : pairs.map((_: unknown, i: number) => i);\n const input = Array.isArray(jawabanInput.pasanganDipilih)\n ? jawabanInput.pasanganDipilih\n : [];\n // Terjemahkan posisi tampil (kananPos) -> index kanonis, lalu\n // cocokkan dengan kiriIndex (kiri selalu tampil kanonis / tidak\n // diacak).\n const pasanganKanonis: (number | null)[] = pairs.map(() => null);\n for (const p of input) {\n if (\n typeof p?.kiriIndex !== \"number\" || typeof p?.kananPos !== \"number\"\n ) continue;\n const kananAsli = petaKanan[p.kananPos];\n if (kananAsli === undefined) continue;\n if (p.kiriIndex >= 0 && p.kiriIndex < pasanganKanonis.length) {\n pasanganKanonis[p.kiriIndex] = kananAsli;\n }\n }\n const jumlahTotal = pairs.length;\n const jumlahBenar = pasanganKanonis.filter((v, i) => v === i).length;\n const benar = jumlahTotal > 0 && jumlahBenar === jumlahTotal;\n return {\n benar,\n poinDidapat: benar ? soal.poin : 0,\n jawabanJson: {\n tipe: \"mencocokkan\",\n pasangan: pasanganKanonis,\n jumlahBenar,\n jumlahTotal,\n },\n };\n }\n\n // pilihan_ganda (default)\n const opsiDipilih = jawabanInput.opsiDipilih ?? null;\n const benar = opsiDipilih !== null && opsiDipilih === soal.jawaban_benar;\n return {\n benar,\n poinDidapat: benar ? soal.poin : 0,\n jawabanJson: null,\n };\n}\n\n// ===== SESI PIN (guru) =====\n\nexport async function createSesiPin(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n modeWaktu: \"per_soal\" | \"per_game\",\n waktuPerSoalDetik: number | null,\n waktuTotalMenit: number | null,\n bukaMulai: string,\n bukaSelesai: string,\n modeMulai: \"manual\" | \"otomatis\" = \"manual\",\n) {\n for (let attempt = 0; attempt < 5; attempt++) {\n const pin = generatePin();\n const { data: bentrok } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"id\")\n .eq(\"pin\", pin)\n .neq(\"status\", \"selesai\")\n .maybeSingle();\n if (bentrok) continue;\n\n const otomatis = modeMulai === \"otomatis\";\n const { data, error } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n pin,\n mode_waktu: modeWaktu,\n waktu_per_soal_detik: waktuPerSoalDetik,\n waktu_total_menit: waktuTotalMenit,\n dibuka_mulai: bukaMulai,\n dibuka_selesai: bukaSelesai,\n mode_mulai: modeMulai,\n // Mode \"otomatis\": sesi langsung aktif saat PIN dibuat, siswa\n // yang gabung tidak perlu menunggu guru menekan \"Mulai\" di Lobi.\n status: otomatis ? \"berjalan\" : \"menunggu\",\n dibuka_at: otomatis ? new Date().toISOString() : null,\n })\n .select()\n .single();\n if (error) throw error;\n return data;\n }\n throw new Error(\"Gagal membuat PIN unik, coba lagi.\");\n}\n\n// Guru mengakhiri sesi secara manual (sebelum waktu habis / sebelum semua\n// peserta selesai). Sesi dipatok \"selesai\" dan semua peserta yang masih\n// berjalan ikut ditandai selesai supaya laporan & layar siswa konsisten.\nexport async function akhiriSesiPin(sesiId: string, guruId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"id\")\n .eq(\"id\", sesiId)\n .eq(\"guru_id\", guruId)\n .maybeSingle();\n if (sesiError) throw sesiError;\n if (!sesi) {\n throw new Error(\"Sesi tidak ditemukan atau bukan milik kamu\");\n }\n\n const { error: sesiUpdateError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .update({ status: \"selesai\" })\n .eq(\"id\", sesiId)\n .neq(\"status\", \"selesai\");\n if (sesiUpdateError) throw sesiUpdateError;\n\n const { error: pesertaUpdateError } = await supabase\n .from(\"game_quiz_peserta\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"sesi_pin_id\", sesiId)\n .neq(\"status\", \"selesai\");\n if (pesertaUpdateError) throw pesertaUpdateError;\n\n return { ok: true };\n}\n\n// Guru membuka kembali sesi yang jendela waktunya sudah lewat (atau yang\n// sudah diakhiri manual), supaya siswa yang belum sempat mengerjakan masih\n// bisa gabung pakai PIN yang sama. Dipakai kalau, misalnya, jendela \"dibuka\n// dari - sampai\" sudah lewat tapi ternyata masih ada anak yang belum\n// mengerjakan.\n// - dibuka_selesai diperpanjang ke waktu baru yang guru tentukan.\n// - Kalau sesi tadinya sudah berstatus \"selesai\" (baik karena jendela lewat\n// atau karena guru menekan \"Akhiri Latihan\"), status dikembalikan jadi\n// \"berjalan\" supaya siswa baru bisa masuk lagi. Peserta yang sebelumnya\n// sudah tercatat \"selesai\" TIDAK diubah/direset — hanya soal akses siswa\n// yang belum join yang dibuka lagi.\nexport async function bukaKembaliSesiPin(\n sesiId: string,\n guruId: string,\n dibukaSelesaiBaru: string,\n) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"id, status\")\n .eq(\"id\", sesiId)\n .eq(\"guru_id\", guruId)\n .maybeSingle();\n if (sesiError) throw sesiError;\n if (!sesi) {\n throw new Error(\"Sesi tidak ditemukan atau bukan milik kamu\");\n }\n\n const { error: updateError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .update({\n dibuka_selesai: dibukaSelesaiBaru,\n status: sesi.status === \"selesai\" ? \"berjalan\" : sesi.status,\n })\n .eq(\"id\", sesiId);\n if (updateError) throw updateError;\n\n return { ok: true };\n}\n\nexport async function getSesiPinDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"*\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\"*\")\n .eq(\"sesi_pin_id\", sesiId)\n .order(\"joined_at\");\n if (pesertaError) throw pesertaError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"id\")\n .eq(\"bank_id\", sesi.bank_id);\n if (soalError) throw soalError;\n\n return { sesi, peserta, totalSoal: soal.length };\n}\n\nexport async function mulaiSesiPin(sesiId: string) {\n const { error } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .update({ status: \"berjalan\", dibuka_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function getLaporan(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"*\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\"*, game_quiz_peserta_jawaban(*)\")\n .eq(\"sesi_pin_id\", sesiId)\n .order(\"skor\", { ascending: false });\n if (pesertaError) throw pesertaError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n // soal_index yang tersimpan di jawaban peserta selalu index KANONIS\n // (sesuai urutan asli bank soal), jadi laporan ini otomatis tetap\n // benar walau tiap peserta melihat urutan & huruf opsi yang beda-beda.\n return { sesi, peserta, soal };\n}\n\n// ===== SISI SISWA (publik, tanpa login) =====\n\nexport async function cariSesiByPin(pin: string) {\n const { data, error } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"*\")\n .eq(\"pin\", pin)\n .neq(\"status\", \"selesai\")\n .maybeSingle();\n if (error) throw error;\n if (data) {\n const pesanJendela = cekJendelaWaktuSesi(data);\n if (pesanJendela) throw new Error(pesanJendela);\n }\n return data;\n}\n\nexport async function daftarPeserta(sesiPinId: string, namaPeserta: string) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"bank_id, dibuka_mulai, dibuka_selesai\")\n .eq(\"id\", sesiPinId)\n .single();\n if (sesiError) throw sesiError;\n\n const pesanJendela = cekJendelaWaktuSesi(sesi);\n if (pesanJendela) throw new Error(pesanJendela);\n\n // ============================================================\n // LANJUTKAN PESERTA LAMA KALAU NAMA SAMA (case-insensitive)\n // ------------------------------------------------------------\n // Supaya peserta yang tidak sengaja keluar/refresh/ganti tab tidak\n // perlu mengulang kuis dari soal 1, kalau nama yang dimasukkan\n // persis sama dengan peserta yang SUDAH pernah join sesi PIN ini,\n // kembalikan ID peserta lama itu (progres & jawaban sebelumnya\n // otomatis lanjut) alih-alih membuat baris peserta baru.\n // Catatan: kalau memang ada 2 siswa berbeda dengan nama sama persis,\n // guru bisa memisahkan mereka lewat fitur \"hapus peserta\" di lobi\n // supaya siswa kedua membuat entri baru saat join ulang.\n // ============================================================\n const { data: pesertaLama, error: pesertaLamaError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\"id\")\n .eq(\"sesi_pin_id\", sesiPinId)\n .ilike(\"nama_peserta\", namaPeserta)\n .order(\"joined_at\", { ascending: false })\n .limit(1)\n .maybeSingle();\n if (pesertaLamaError) throw pesertaLamaError;\n if (pesertaLama) return pesertaLama;\n\n const { data: soalList, error: soalError } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"tipe_soal, pasangan_mencocokkan\")\n .eq(\"bank_id\", sesi.bank_id);\n if (soalError) throw soalError;\n\n const jumlahSoal = soalList.length;\n\n const { data, error } = await supabase\n .from(\"game_quiz_peserta\")\n .insert({\n sesi_pin_id: sesiPinId,\n nama_peserta: namaPeserta,\n // Diacak sekali di sini, saat peserta gabung, supaya setiap\n // device (walau join dengan nama yang sama sekalipun) dapat\n // urutan soal & posisi opsi jawaban yang berbeda-beda.\n urutan_soal: buatUrutanSoal(jumlahSoal),\n acak_opsi: buatAcakOpsi(soalList),\n })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function getPesertaState(pesertaId: string) {\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\"*\")\n .eq(\"id\", pesertaId)\n .single();\n if (pesertaError) throw pesertaError;\n\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"*\")\n .eq(\"id\", peserta.sesi_pin_id)\n .single();\n if (sesiError) throw sesiError;\n\n const { data: soalList, error: soalError } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n const totalSoal = soalList.length;\n const modeWaktu = sesi.mode_waktu || \"per_soal\";\n\n // ===== MODE PER PERMAINAN (waktu total, urut tapi bisa balik & ubah) =====\n if (modeWaktu === \"per_game\") {\n // Cek batas waktu total sudah lewat atau belum -> auto-selesaikan.\n if (\n peserta.status !== \"selesai\" && sesi.status === \"berjalan\" &&\n sesi.dibuka_at && sesi.waktu_total_menit\n ) {\n const deadline = hitungMulaiWaktuMs(sesi, peserta) +\n sesi.waktu_total_menit * 60000;\n if (Date.now() >= deadline) {\n await selesaikanPesertaGame(pesertaId);\n peserta.status = \"selesai\";\n }\n }\n\n const { urutanSoal, acakOpsi } = await pastikanUrutanPeserta(\n peserta,\n soalList,\n );\n\n const { data: jawabanList, error: jawabanError } = await supabase\n .from(\"game_quiz_peserta_jawaban\")\n .select(\"soal_index, opsi_dipilih, jawaban_json\")\n .eq(\"peserta_id\", pesertaId);\n if (jawabanError) throw jawabanError;\n\n // soal_index di tabel jawaban = index KANONIS. Terjemahkan ke\n // posisi tampil peserta ini + bentuk yang sesuai untuk layarnya\n // (huruf untuk PG, boolean untuk benar/salah, daftar pasangan\n // versi posisi-tampil untuk mencocokkan).\n const posisiDariKanonis: Record = {};\n urutanSoal.forEach((kanonisIdx, posisi) => {\n posisiDariKanonis[kanonisIdx] = posisi;\n });\n\n const jawabanTersimpan: Record = {};\n for (const j of jawabanList) {\n const posisi = posisiDariKanonis[j.soal_index];\n if (posisi === undefined) continue;\n const soalIni = soalList[j.soal_index];\n const tipeIni = tipeSoalDari(soalIni);\n const peta = acakOpsi[String(j.soal_index)];\n\n if (tipeIni === \"benar_salah\") {\n jawabanTersimpan[posisi] = (j.jawaban_json as any)?.dipilih ?? null;\n } else if (tipeIni === \"mencocokkan\") {\n const pasanganKanonis = (j.jawaban_json as any)?.pasangan || [];\n const petaKanan: number[] = Array.isArray(peta) ? peta as number[] : [];\n // Balikkan index kanonis -> posisi tampil (kebalikan peta).\n jawabanTersimpan[posisi] = pasanganKanonis.map(\n (kananAsli: number | null, kiriIndex: number) => ({\n kiriIndex,\n kananPos: kananAsli === null ? null : petaKanan.indexOf(kananAsli),\n }),\n );\n } else {\n const petaHuruf = Array.isArray(peta) ? peta as string[] : [\"a\", \"b\", \"c\", \"d\"];\n jawabanTersimpan[posisi] = hurufTampilDariKanonis(\n petaHuruf,\n j.opsi_dipilih,\n );\n }\n }\n\n const soalListAcak = urutanSoal.map((kanonisIdx) =>\n acakSoalUntukTampilan(\n soalList[kanonisIdx],\n acakOpsi[String(kanonisIdx)],\n )\n );\n\n const deadlineAt = sesi.dibuka_at && sesi.waktu_total_menit\n ? new Date(\n hitungMulaiWaktuMs(sesi, peserta) + sesi.waktu_total_menit * 60000,\n ).toISOString()\n : null;\n\n return {\n namaPeserta: peserta.nama_peserta,\n statusPeserta: peserta.status,\n statusSesi: sesi.status,\n namaSesi: sesi.nama_sesi,\n modeWaktu: \"per_game\",\n waktuTotalMenit: sesi.waktu_total_menit,\n deadlineAt,\n soalKe: peserta.soal_ke,\n totalSoal,\n soalList: soalListAcak,\n jawabanTersimpan,\n };\n }\n\n // ===== MODE PER SOAL (perilaku lama, ditambah acak urutan+opsi) =====\n const { urutanSoal, acakOpsi } = await pastikanUrutanPeserta(\n peserta,\n soalList,\n );\n const kanonisIdx = urutanSoal[peserta.soal_ke];\n const soalMentah = kanonisIdx !== undefined ? soalList[kanonisIdx] : null;\n const soalAktif = soalMentah\n ? acakSoalUntukTampilan(\n soalMentah,\n acakOpsi[String(kanonisIdx)],\n )\n : null;\n\n return {\n namaPeserta: peserta.nama_peserta,\n statusPeserta: peserta.status,\n statusSesi: sesi.status,\n namaSesi: sesi.nama_sesi,\n modeWaktu: \"per_soal\",\n waktuPerSoalDetik: sesi.waktu_per_soal_detik,\n soalKe: peserta.soal_ke,\n totalSoal,\n soalAktif,\n };\n}\n\nexport interface JawabanInput {\n opsiDipilih?: \"a\" | \"b\" | \"c\" | \"d\" | null;\n jawabanBs?: boolean | null;\n pasanganDipilih?: { kiriIndex: number; kananPos: number }[] | null;\n}\n\nexport async function catatJawabanPeserta(\n pesertaId: string,\n soalIndex: number,\n jawabanInput: JawabanInput,\n waktuJawabMs: number,\n) {\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\"*, game_quiz_sesi_pin(bank_id)\")\n .eq(\"id\", pesertaId)\n .single();\n if (pesertaError) throw pesertaError;\n\n if (soalIndex !== peserta.soal_ke) {\n // Sudah tercatat / tidak sinkron — abaikan supaya tidak dobel-hitung.\n return { ok: true, selesai: peserta.status === \"selesai\" };\n }\n\n const { data: soalList, error: soalError } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"*\")\n .eq(\"bank_id\", peserta.game_quiz_sesi_pin.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n // soalIndex dari klien = posisi tampil peserta ini, bukan index asli.\n // Terjemahkan ke index kanonis pakai urutan acak milik peserta.\n const { urutanSoal, acakOpsi } = await pastikanUrutanPeserta(\n peserta,\n soalList,\n );\n const kanonisIdx = urutanSoal[soalIndex];\n const soal = soalList[kanonisIdx];\n if (!soal) throw new Error(\"Soal tidak ditemukan\");\n\n // opsiDipilih (untuk PG) yang dikirim klien sudah diterjemahkan ke\n // huruf KANONIS di sisi tampilan (lihat kerjakan.ts). Untuk tipe\n // lain, penerjemahan posisi->kanonis dilakukan di gradeJawaban\n // memakai peta acak_opsi milik peserta.\n const { benar, poinDidapat, jawabanJson } = gradeJawaban(\n soal,\n jawabanInput,\n acakOpsi[String(kanonisIdx)],\n );\n\n const { error: jawabError } = await supabase\n .from(\"game_quiz_peserta_jawaban\")\n .insert({\n peserta_id: pesertaId,\n soal_index: kanonisIdx,\n opsi_dipilih: jawabanInput.opsiDipilih ?? null,\n jawaban_json: jawabanJson,\n benar,\n poin_didapat: poinDidapat,\n waktu_jawab_ms: waktuJawabMs,\n });\n if (jawabError) throw jawabError;\n\n const soalKeBaru = peserta.soal_ke + 1;\n const selesai = soalKeBaru >= soalList.length;\n\n const { error: updateError } = await supabase\n .from(\"game_quiz_peserta\")\n .update({\n soal_ke: soalKeBaru,\n skor: peserta.skor + poinDidapat,\n status: selesai ? \"selesai\" : \"mengerjakan\",\n selesai_at: selesai ? new Date().toISOString() : null,\n })\n .eq(\"id\", pesertaId);\n if (updateError) throw updateError;\n\n return { ok: true, selesai };\n}\n\n// ===== MODE PER PERMAINAN: jawaban bisa diubah, urutan bebas maju-mundur =====\n\nexport async function simpanJawabanPesertaGame(\n pesertaId: string,\n soalIndex: number,\n jawabanInput: JawabanInput,\n waktuJawabMs: number,\n) {\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\n \"*, game_quiz_sesi_pin(bank_id, status, dibuka_at, waktu_total_menit)\",\n )\n .eq(\"id\", pesertaId)\n .single();\n if (pesertaError) throw pesertaError;\n\n if (peserta.status === \"selesai\") {\n return { ok: true, selesai: true };\n }\n\n const sesi = peserta.game_quiz_sesi_pin;\n if (\n sesi.status === \"berjalan\" && sesi.dibuka_at && sesi.waktu_total_menit &&\n Date.now() >=\n hitungMulaiWaktuMs(sesi, peserta) + sesi.waktu_total_menit * 60000\n ) {\n await selesaikanPesertaGame(pesertaId);\n return { ok: true, selesai: true };\n }\n\n const { data: soalList, error: soalError } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"urutan\");\n if (soalError) throw soalError;\n\n // soalIndex dari klien = posisi tampil peserta ini. Terjemahkan ke\n // index kanonis pakai urutan acak milik peserta.\n const { urutanSoal, acakOpsi } = await pastikanUrutanPeserta(\n peserta,\n soalList,\n );\n const kanonisIdx = urutanSoal[soalIndex];\n const soal = soalList[kanonisIdx];\n if (!soal) throw new Error(\"Soal tidak ditemukan\");\n\n const { benar, poinDidapat, jawabanJson } = gradeJawaban(\n soal,\n jawabanInput,\n acakOpsi[String(kanonisIdx)],\n );\n\n const { error: jawabError } = await supabase\n .from(\"game_quiz_peserta_jawaban\")\n .upsert(\n {\n peserta_id: pesertaId,\n soal_index: kanonisIdx,\n opsi_dipilih: jawabanInput.opsiDipilih ?? null,\n jawaban_json: jawabanJson,\n benar,\n poin_didapat: poinDidapat,\n waktu_jawab_ms: waktuJawabMs,\n },\n { onConflict: \"peserta_id,soal_index\" },\n );\n if (jawabError) throw jawabError;\n\n const { data: semuaJawaban, error: sumError } = await supabase\n .from(\"game_quiz_peserta_jawaban\")\n .select(\"poin_didapat\")\n .eq(\"peserta_id\", pesertaId);\n if (sumError) throw sumError;\n const skorBaru = semuaJawaban.reduce((s, j) => s + (j.poin_didapat || 0), 0);\n\n const soalKeBaru = Math.max(peserta.soal_ke, soalIndex);\n const { error: updateError } = await supabase\n .from(\"game_quiz_peserta\")\n .update({ skor: skorBaru, soal_ke: soalKeBaru, status: \"mengerjakan\" })\n .eq(\"id\", pesertaId);\n if (updateError) throw updateError;\n\n return { ok: true, selesai: false };\n}\n\nexport async function pindahSoalPesertaGame(pesertaId: string, soalKe: number) {\n const { error } = await supabase\n .from(\"game_quiz_peserta\")\n .update({ soal_ke: soalKe })\n .eq(\"id\", pesertaId)\n .neq(\"status\", \"selesai\");\n if (error) throw error;\n return { ok: true };\n}\n\nexport async function selesaikanPesertaGame(pesertaId: string) {\n const { error } = await supabase\n .from(\"game_quiz_peserta\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", pesertaId)\n .neq(\"status\", \"selesai\");\n if (error) throw error;\n return { ok: true };\n}\n\n// ===== RIWAYAT SESI (guru) =====\n\nexport async function getRiwayatOlimpiade(bankId: string, guruId: string) {\n const { data, error } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"*, game_quiz_peserta(count)\")\n .eq(\"bank_id\", bankId)\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n\n return (data || []).map((s: any) => ({\n id: s.id,\n nama_sesi: s.nama_sesi,\n kelas: s.kelas,\n pin: s.pin,\n status: s.status,\n mode_waktu: s.mode_waktu,\n created_at: s.created_at,\n jumlahPeserta: s.game_quiz_peserta?.[0]?.count ?? 0,\n }));\n}\n\n// Hapus satu peserta dari sesi PIN (dipakai guru di lobi, misalnya untuk\n// membersihkan entri dobel saat \"room\" sudah penuh sebelum siswa yang\n// sama join ulang dengan nama persis sama untuk melanjutkan).\nexport async function hapusPeserta(pesertaId: string, guruId: string) {\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\"id, game_quiz_sesi_pin(guru_id)\")\n .eq(\"id\", pesertaId)\n .maybeSingle();\n if (pesertaError) throw pesertaError;\n if (!peserta || peserta.game_quiz_sesi_pin?.guru_id !== guruId) {\n throw new Error(\"Peserta tidak ditemukan atau bukan milik sesi kamu\");\n }\n\n const { error: jawabDelError } = await supabase\n .from(\"game_quiz_peserta_jawaban\")\n .delete()\n .eq(\"peserta_id\", pesertaId);\n if (jawabDelError) throw jawabDelError;\n\n const { error: pesertaDelError } = await supabase\n .from(\"game_quiz_peserta\")\n .delete()\n .eq(\"id\", pesertaId);\n if (pesertaDelError) throw pesertaDelError;\n\n return { ok: true };\n}\n\nexport async function hapusSesiPin(sesiId: string, guruId: string) {\n // Pastikan sesi ini benar milik guru yang minta hapus.\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .select(\"id\")\n .eq(\"id\", sesiId)\n .eq(\"guru_id\", guruId)\n .maybeSingle();\n if (sesiError) throw sesiError;\n if (!sesi) {\n throw new Error(\"Riwayat tidak ditemukan atau bukan milik kamu\");\n }\n\n // Hapus manual berurutan (jawaban -> peserta -> sesi) supaya tidak\n // menyisakan data yatim walau tabel belum di-setup ON DELETE CASCADE.\n const { data: pesertaList, error: pesertaListError } = await supabase\n .from(\"game_quiz_peserta\")\n .select(\"id\")\n .eq(\"sesi_pin_id\", sesiId);\n if (pesertaListError) throw pesertaListError;\n\n const pesertaIds = (pesertaList || []).map((p: any) => p.id);\n if (pesertaIds.length > 0) {\n const { error: jawabDelError } = await supabase\n .from(\"game_quiz_peserta_jawaban\")\n .delete()\n .in(\"peserta_id\", pesertaIds);\n if (jawabDelError) throw jawabDelError;\n }\n\n const { error: pesertaDelError } = await supabase\n .from(\"game_quiz_peserta\")\n .delete()\n .eq(\"sesi_pin_id\", sesiId);\n if (pesertaDelError) throw pesertaDelError;\n\n const { error: sesiDelError } = await supabase\n .from(\"game_quiz_sesi_pin\")\n .delete()\n .eq(\"id\", sesiId);\n if (sesiDelError) throw sesiDelError;\n\n return { ok: true };\n}",[],[183,641,686,344],"02236069-59f7-429f-926e-2aa220e7af0c","e635d004-a1ac-11f1-b2aa-1607ee4eb77e","673cb216-a127-11f1-9489-1607ee4eb77e",233,["D",1787790732089],"export async function renderRiwayat(bankId: string): Promise {\n return `\n\n\n \n \n Riwayat Mode Online - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,686,169,514],"abbd1e78-dcf0-4492-8093-41b62603b7bc","76e9393c-a127-11f1-9e87-1607ee4eb77e",475,["D",1788329824803],"export async function renderLobi(sesiId: string): Promise {\n return `\n\n\n \n \n Lobi Latihan - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,686,169,523],"885aad6e-37f3-4803-a949-55502fb9f29e","7bcf3af0-a127-11f1-9489-1607ee4eb77e",479,["D",1788331420506],"export async function renderLaporan(sesiId: string): Promise {\n return `\n\n\n \n \n Laporan Latihan - Game Kelas Seru\n \n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,686,169,532],"d49a1e29-ae7b-4aad-8844-f4b78d92ea50","72367f94-a127-11f1-b0cc-1607ee4eb77e",491,["D",1788392306681],"export async function renderKerjakan(pesertaId: string): Promise {\n return `\n\n\n \n \n Mengerjakan - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,686,169,540],"4f908151-3dba-4b47-9d1b-3e4054025a3a","6cf86696-a127-11f1-909e-1607ee4eb77e",231,["D",1787790702611],"export async function renderGabung(): Promise {\n return `\n\n\n \n \n Gabung Latihan - Game Kelas Seru\n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,641,686,169,548],"1dff0ab7-bbb0-4106-b0a5-4817970b9020",192,["D",1787732609304],[217,218,219,220,221],[183,641,686,169],"5c7f8555-6b4b-437b-a9cb-add4301036b7",184,["D",1787732341684],[216,222,223],[183,641,686],"6033e0a9-6939-4688-a9fb-489c5046a0d2",163,["D",1787731470891],[215,224,228,229],[183,641],"0581edd3-8663-43dd-b5ea-6507280c9db5","ebe3c4c8-9dc1-11f1-a919-1607ee4eb77e","de507bbc-9dc1-11f1-97c0-1607ee4eb77e",409,["D",1788159448514],"import * as db from \"./database.ts\";\nimport * as kejutan from \"../../lib/powerups.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/bank-editor.ts\";\nimport { renderGamePlay } from \"./views/play.ts\";\nimport { renderRekap } from \"./views/rekap.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport async function handleKuisKotak(\n req: Request,\n method: string,\n path: string,\n guruId: string,\n namaGuru: string,\n): Promise {\n // ===== HALAMAN =====\n if (method === \"GET\" && path === \"/kuis-kotak\") {\n return html(await renderDashboard(guruId, namaGuru));\n }\n if (method === \"GET\" && path.startsWith(\"/bank/\") && path.endsWith(\"/edit\")) {\n const bankId = path.split(\"/\")[2];\n return html(await renderBankEditor(bankId));\n }\n if (method === \"GET\" && path.startsWith(\"/main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderGamePlay(sesiId));\n }\n if (method === \"GET\" && path === \"/rekap\") {\n return html(await renderRekap(guruId));\n }\n\n // ===== API: BANK SOAL =====\n if (method === \"GET\" && path === \"/api/bank\") {\n try {\n return json(await db.getBankSoalList(guruId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/bank/\") &&\n path.split(\"/\").length === 4\n ) {\n try {\n const bankId = path.split(\"/\")[3];\n return json(await db.getBankSoalById(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (method === \"POST\" && path === \"/api/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) {\n return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n }\n const jumlahKotak = Number(body.jumlahKotak) || 16;\n if (jumlahKotak < 4 || jumlahKotak > 100) {\n return json({ error: \"Jumlah kotak harus antara 4 sampai 100\" }, 400);\n }\n return json(\n await db.createBankSoal(\n guruId,\n body.namaBank,\n body.mapel,\n body.kelas,\n jumlahKotak,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"DELETE\" && path.startsWith(\"/api/bank/\") &&\n path.split(\"/\").length === 4\n ) {\n try {\n const bankId = path.split(\"/\")[3];\n await db.deleteBankSoal(bankId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SOAL =====\n if (\n method === \"GET\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[3];\n return json(await db.getSoalByBank(bankId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")\n ) {\n try {\n const bankId = path.split(\"/\")[3];\n const body = await req.json();\n if (!body.nomorKotak || !body.pertanyaan) {\n return json({ error: \"Nomor kotak dan pertanyaan wajib diisi\" }, 400);\n }\n return json(\n await db.upsertSoal(\n bankId,\n body.nomorKotak,\n body.pertanyaan,\n body.jawaban,\n body.poin ?? 10,\n body.gambarUrl,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: SESI =====\n if (method === \"POST\" && path === \"/api/sesi\") {\n try {\n const body = await req.json();\n if (\n !body.bankId || !body.namaSesi || !Array.isArray(body.timList) ||\n body.timList.length < 1 || body.timList.length > 20\n ) {\n return json({\n error:\n \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 1-20 tim)\",\n }, 400);\n }\n return json(\n await db.createSesi(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n body.modePembukaan === \"urut\" ? \"urut\" : \"bebas\",\n body.timList,\n Array.isArray(body.powerUpDaftar) ? body.powerUpDaftar : null,\n ),\n );\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"GET\" && path.startsWith(\"/api/sesi/\") &&\n path.split(\"/\").length === 4\n ) {\n try {\n const sesiId = path.split(\"/\")[3];\n return json(await db.getSesiDetail(sesiId));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sesi/\") &&\n path.endsWith(\"/kotak\")\n ) {\n try {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n if (!body.nomorKotak) {\n return json({ error: \"Nomor kotak wajib diisi\" }, 400);\n }\n const hasilKotak = await db.bukaKotak(\n sesiId,\n body.nomorKotak,\n body.timId ?? null,\n !!body.benar,\n body.poinDidapat ?? 0,\n );\n\n return json({ ...hasilKotak, kejutan: null });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sesi/\") &&\n path.endsWith(\"/kotak-powerup\")\n ) {\n try {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n if (!body.nomorKotak || !body.timId) {\n return json({ error: \"Nomor kotak dan tim wajib diisi\" }, 400);\n }\n\n const sesiSekarang = await db.getSesiDetail(sesiId);\n const daftarKotakKejutan = sesiSekarang.sesi.power_up_kotak || [];\n const assign = daftarKotakKejutan.find(\n (k: { nomorTampil: number; kode: string }) =>\n k.nomorTampil === body.nomorKotak,\n );\n if (!assign) {\n return json({ error: \"Kotak ini bukan kotak kejutan\" }, 400);\n }\n\n // Tandai kotak sebagai terpakai (tanpa nilai benar/salah biasa —\n // poin yang berubah nanti murni dari efek kejutannya).\n await db.bukaKotak(sesiId, body.nomorKotak, body.timId, false, 0);\n\n const def = kejutan.DAFTAR_KEJUTAN.find((d) => d.kode === assign.kode);\n if (!def) return json({ error: \"Kejutan tidak dikenali\" }, 500);\n\n // Pakai poin soal asli di baliknya (kalau ada) sebagai basis untuk\n // efek seperti Bintang Ganda / Jebakan Betmen, supaya tetap terasa\n // berarti walau kotak ini tidak menampilkan pertanyaan sama sekali.\n const nomorAsli = sesiSekarang.sesi.kotak_acak?.[body.nomorKotak - 1] ??\n body.nomorKotak;\n const soalAsli = sesiSekarang.soal.find((s: { nomor_kotak: number }) =>\n s.nomor_kotak === nomorAsli\n );\n const poinDasar = soalAsli?.poin ?? 10;\n\n const hasilKejutan = def.jalankan(\n sesiSekarang.tim,\n body.timId,\n poinDasar,\n );\n await db.terapkanKejutanSkor(hasilKejutan.timUpdates);\n\n return json({ ok: true, kejutan: hasilKejutan });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sesi/\") &&\n path.endsWith(\"/giliran\")\n ) {\n try {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n await db.updateGiliran(sesiId, body.giliranBaru ?? 0);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n if (\n method === \"POST\" && path.startsWith(\"/api/sesi/\") &&\n path.endsWith(\"/selesai\")\n ) {\n try {\n const sesiId = path.split(\"/\")[3];\n await db.selesaikanSesi(sesiId);\n return json({ ok: true });\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ===== API: REKAP =====\n if (method === \"GET\" && path === \"/api/rekap\") {\n try {\n const url = new URL(req.url);\n const kelas = url.searchParams.get(\"kelas\") ?? undefined;\n return json(await db.getRekapByKelas(guruId, kelas));\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n return null;\n}",[],[183,754,334],"kuis-kotak","293fa60f-f4aa-41e7-9984-b84888fd9d40","d70b4c24-9dc1-11f1-8727-1607ee4eb77e",408,["D",1788159419430],"import { supabase } from \"../../supabase-client.ts\";\n\n// Fisher-Yates — dipakai untuk mengacak urutan soal di balik nomor kotak\n// yang tampil ke pemain, supaya \"soal nomor 1\" tidak selalu ada di\n// \"Kotak #1\", tapi tetap konsisten selama 1 sesi berlangsung.\nfunction acakArray(arr: T[]): T[] {\n const hasil = [...arr];\n for (let i = hasil.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [hasil[i], hasil[j]] = [hasil[j], hasil[i]];\n }\n return hasil;\n}\n\n// ===== BANK SOAL =====\n\nexport async function getBankSoalList(guruId: string) {\n const { data, error } = await supabase\n .from(\"game_bank_soal\")\n .select(\"*\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function getBankSoalById(bankId: string) {\n const { data, error } = await supabase.from(\"game_bank_soal\").select(\"*\").eq(\n \"id\",\n bankId,\n ).single();\n if (error) throw error;\n return data;\n}\n\nexport async function createBankSoal(\n guruId: string,\n namaBank: string,\n mapel: string,\n kelas: string,\n jumlahKotak: number,\n) {\n const { data, error } = await supabase\n .from(\"game_bank_soal\")\n .insert({\n guru_id: guruId,\n nama_bank: namaBank,\n mapel,\n kelas,\n jumlah_kotak: jumlahKotak,\n })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function deleteBankSoal(bankId: string) {\n const { error } = await supabase.from(\"game_bank_soal\").delete().eq(\n \"id\",\n bankId,\n );\n if (error) throw error;\n}\n\n// ===== SOAL =====\n\nexport async function getSoalByBank(bankId: string) {\n const { data, error } = await supabase\n .from(\"game_soal\")\n .select(\"*\")\n .eq(\"bank_id\", bankId)\n .order(\"nomor_kotak\");\n if (error) throw error;\n return data;\n}\n\nexport async function upsertSoal(\n bankId: string,\n nomorKotak: number,\n pertanyaan: string,\n jawaban: string,\n poin: number,\n gambarUrl?: string,\n) {\n const { data, error } = await supabase\n .from(\"game_soal\")\n .upsert(\n {\n bank_id: bankId,\n nomor_kotak: nomorKotak,\n pertanyaan,\n jawaban,\n poin,\n gambar_url: gambarUrl ?? null,\n },\n { onConflict: \"bank_id,nomor_kotak\" },\n )\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\n// ===== SESI =====\n\nexport async function createSesi(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n modePembukaan: \"bebas\" | \"urut\",\n timList: { nama: string; warna: string }[],\n powerUpDaftar: string[] | null = null,\n) {\n const { data: bank, error: bankError } = await supabase\n .from(\"game_bank_soal\")\n .select(\"jumlah_kotak\")\n .eq(\"id\", bankId)\n .single();\n if (bankError) throw bankError;\n\n const jumlahKotak = bank?.jumlah_kotak ?? 16;\n // Pemetaan \"kotak tampil ke-N -> soal asli nomor_kotak berapa\", diacak\n // sekali saat sesi dibuat, lalu disimpan supaya tetap sama sepanjang\n // sesi ini berjalan (tidak berubah-ubah tiap refresh halaman).\n const kotakAcak = acakArray(\n Array.from({ length: jumlahKotak }, (_, i) => i + 1),\n );\n\n // Kotak Kejutan (Baamboozle-style): kalau guru memilih N jenis kejutan,\n // maka N kotak (dari jumlah kotak yang ada) DIGANTI jadi kotak kejutan\n // — begitu dibuka, langsung muncul efeknya, TANPA menampilkan soal.\n // Satu kotak = satu jenis kejutan (tidak ada yang dobel), posisinya\n // diacak dan dirahasiakan (kotak terlihat sama seperti kotak biasa\n // sampai dibuka, supaya tetap jadi kejutan).\n const powerUpKotak: { nomorTampil: number; kode: string }[] = [];\n if (powerUpDaftar && powerUpDaftar.length > 0) {\n const posisiUntukKejutan = acakArray(\n Array.from({ length: jumlahKotak }, (_, i) => i + 1),\n );\n const kodeKejutanAcak = acakArray(powerUpDaftar);\n const jumlahKotakKejutan = Math.min(kodeKejutanAcak.length, jumlahKotak);\n for (let i = 0; i < jumlahKotakKejutan; i++) {\n powerUpKotak.push({\n nomorTampil: posisiUntukKejutan[i],\n kode: kodeKejutanAcak[i],\n });\n }\n }\n\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_sesi\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n mode_pembukaan: modePembukaan,\n power_up_aktif: !!(powerUpDaftar && powerUpDaftar.length > 0),\n power_up_daftar: powerUpDaftar,\n power_up_kotak: powerUpKotak,\n kotak_acak: kotakAcak,\n })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase.from(\"game_tim\")\n .insert(timRows).select();\n if (timError) throw timError;\n\n return { sesi, tim: timData };\n}\n\nexport async function getSesiDetail(sesiId: string) {\n const { data: sesi, error: sesiError } = await supabase.from(\"game_sesi\")\n .select(\"*\").eq(\"id\", sesiId).single();\n if (sesiError) throw sesiError;\n\n const { data: bank, error: bankError } = await supabase\n .from(\"game_bank_soal\")\n .select(\"jumlah_kotak\")\n .eq(\"id\", sesi.bank_id)\n .single();\n if (bankError) throw bankError;\n\n const { data: soal, error: soalError } = await supabase\n .from(\"game_soal\")\n .select(\"*\")\n .eq(\"bank_id\", sesi.bank_id)\n .order(\"nomor_kotak\");\n if (soalError) throw soalError;\n\n const { data: tim, error: timError } = await supabase\n .from(\"game_tim\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId)\n .order(\"urutan\");\n if (timError) throw timError;\n\n const { data: kotakTerpakai, error: kotakError } = await supabase\n .from(\"game_kotak_terpakai\")\n .select(\"*\")\n .eq(\"sesi_id\", sesiId);\n if (kotakError) throw kotakError;\n\n return {\n sesi,\n soal,\n tim,\n kotakTerpakai,\n jumlahKotak: bank?.jumlah_kotak ?? 16,\n };\n}\n\nexport async function bukaKotak(\n sesiId: string,\n nomorKotak: number,\n timId: string | null,\n benar: boolean,\n poinDidapat: number,\n) {\n const { data, error } = await supabase\n .from(\"game_kotak_terpakai\")\n .insert({\n sesi_id: sesiId,\n nomor_kotak: nomorKotak,\n tim_menjawab_id: timId,\n benar,\n poin_didapat: poinDidapat,\n })\n .select()\n .single();\n if (error) throw error;\n\n if (timId && benar) {\n const { data: timSekarang } = await supabase.from(\"game_tim\").select(\"skor\")\n .eq(\"id\", timId).single();\n await supabase.from(\"game_tim\").update({\n skor: (timSekarang?.skor ?? 0) + poinDidapat,\n }).eq(\"id\", timId);\n }\n\n return data;\n}\n\nexport async function updateGiliran(sesiId: string, giliranBaru: number) {\n const { error } = await supabase.from(\"game_sesi\").update({\n giliran_tim_index: giliranBaru,\n }).eq(\"id\", sesiId);\n if (error) throw error;\n}\n\nexport async function selesaikanSesi(sesiId: string) {\n const { error } = await supabase\n .from(\"game_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId);\n if (error) throw error;\n}\n\n// ===== KEJUTAN SKOR (POWER-UP) =====\n\nexport async function terapkanKejutanSkor(\n updates: { id: string; skorBaru: number }[],\n) {\n for (const u of updates) {\n const { error } = await supabase.from(\"game_tim\").update({\n skor: u.skorBaru,\n }).eq(\"id\", u.id);\n if (error) throw error;\n }\n}\n\n// ===== REKAP =====\n\nexport async function getRekapByKelas(guruId: string, kelas?: string) {\n let query = supabase\n .from(\"game_sesi\")\n .select(\"*, game_tim(*)\")\n .eq(\"guru_id\", guruId)\n .eq(\"status\", \"selesai\")\n .order(\"tanggal\", { ascending: false });\n if (kelas) query = query.eq(\"kelas\", kelas);\n\n const { data, error } = await query;\n if (error) throw error;\n return data;\n}",[],[183,754,344],"ba3db05a-e198-41ed-b9ac-946866e49e81","766d7936-9dc2-11f1-8bb9-1607ee4eb77e","494a7346-9dc2-11f1-ad17-1607ee4eb77e",156,["D",1787363031922],"export async function renderRekap(guruId: string): Promise {\n return `\n\n\n \n \n Rekap Skor - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,754,169,403],"5b4b9094-a0c9-4d0b-be61-1084d93c106c","5d51443c-9dc2-11f1-b6ab-1607ee4eb77e",406,["D",1788159289501],"export async function renderGamePlay(sesiId: string): Promise {\n return `\n\n\n \n \n Main - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,754,169,352],"67e20163-019e-4ff6-a7c9-e21ac435176f","52c55b98-9dc2-11f1-b3e3-1607ee4eb77e",311,["D",1788081827281],"export async function renderDashboard(\n guruId: string,\n namaGuru: string,\n): Promise {\n return `\n\n\n \n \n Kuis Kotak - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,754,169,369],"49a25ab5-e6b9-4962-bdb2-5945cd9aa072","586491ae-9dc2-11f1-af7c-1607ee4eb77e",154,["D",1787362985613],"export async function renderBankEditor(bankId: string): Promise {\n return `\n\n\n \n \n Edit Bank Soal - Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[183,754,169,435],"756d84b6-dcc6-492d-9d3e-624aa0d48694",114,["D",1787359329490],[208,209,210,211],[183,754,169],"8134dfe3-aee3-4e4f-995c-1cb59aea6ef2",92,["D",1787359148187],[207,212,213],[183,754],"f642c42f-f6de-443d-b115-1a7f435ebd11","1d20a07e-a763-11f1-835a-1607ee4eb77e",["D",1788418066885],[],[183,806,33],"kafe-seru","5c4f8e65-8f0d-46b9-a79f-385a5adf7b06","konten.ts","4396c350-a763-11f1-898d-1607ee4eb77e",503,["D",1788418038579],"// ============================================================\n// Konten permainan \"Kafe Seru\" — bahan, menu (resep), dan\n// upgrade. Sengaja hardcode (bukan dari database) supaya game\n// ini simpel dipakai guru: tinggal pilih bank soal, tanpa perlu\n// desain menu kafe sendiri. Dipakai bersama oleh sisi guru\n// (laporan) dan sisi siswa (gameplay), makanya ditaruh di modul\n// terpisah alih-alih ditulis dua kali.\n// ============================================================\n\nexport interface Bahan {\n key: string;\n nama: string;\n harga: number;\n emoji: string;\n}\n\nexport interface Menu {\n key: string;\n nama: string;\n resep: Record;\n hargaJual: number;\n emoji: string;\n defaultUnlocked: boolean;\n}\n\nexport interface Upgrade {\n key: string;\n nama: string;\n deskripsi: string;\n hargaBertingkat: number[]; // harga beli ke-1, ke-2, dst. Kalau cuma 1 elemen = beli sekali.\n emoji: string;\n}\n\nexport const BAHAN: Bahan[] = [\n { key: \"roti\", nama: \"Roti\", harga: 5, emoji: \"🍞\" },\n { key: \"telur\", nama: \"Telur\", harga: 8, emoji: \"🥚\" },\n { key: \"sayur\", nama: \"Sayur\", harga: 6, emoji: \"🥬\" },\n { key: \"daging\", nama: \"Daging\", harga: 15, emoji: \"🥩\" },\n];\n\nexport const MENU: Menu[] = [\n {\n key: \"roti_bakar\",\n nama: \"Roti Bakar\",\n resep: { roti: 1, telur: 1 },\n hargaJual: 20,\n emoji: \"🍳\",\n defaultUnlocked: true,\n },\n {\n key: \"sandwich\",\n nama: \"Sandwich Sayur\",\n resep: { roti: 2, sayur: 1 },\n hargaJual: 28,\n emoji: \"🥪\",\n defaultUnlocked: true,\n },\n {\n key: \"burger\",\n nama: \"Burger Daging\",\n resep: { roti: 1, daging: 1, sayur: 1 },\n hargaJual: 45,\n emoji: \"🍔\",\n defaultUnlocked: true,\n },\n {\n key: \"deluxe\",\n nama: \"Spesial Deluxe\",\n resep: { roti: 2, daging: 1, telur: 1, sayur: 1 },\n hargaJual: 70,\n emoji: \"🍱\",\n defaultUnlocked: false,\n },\n];\n\nexport const UPGRADE: Upgrade[] = [\n {\n key: \"slot_pelanggan\",\n nama: \"Rak Meja Tambahan\",\n deskripsi: \"+1 pelanggan bisa dilayani sekaligus (maks 5).\",\n hargaBertingkat: [80, 140, 220],\n emoji: \"🪑\",\n },\n {\n key: \"menu_spesial\",\n nama: \"Buka Menu Spesial Deluxe\",\n deskripsi: \"Unlock menu Spesial Deluxe yang untungnya paling besar.\",\n hargaBertingkat: [150],\n emoji: \"🍱\",\n },\n {\n key: \"diskon_bahan\",\n nama: \"Langganan Grosir\",\n deskripsi: \"Harga semua bahan lebih murah 20% selamanya.\",\n hargaBertingkat: [120],\n emoji: \"🏷️\",\n },\n];\n\nexport const UANG_AWAL = 20;\nexport const SLOT_PELANGGAN_AWAL = 2;\nexport const SLOT_PELANGGAN_MAKS = 5;\nexport const BATAS_WAKTU_PELANGGAN_DETIK = 30;\n\nexport function cariBahan(key: string): Bahan | undefined {\n return BAHAN.find((b) => b.key === key);\n}\nexport function cariMenu(key: string): Menu | undefined {\n return MENU.find((m) => m.key === key);\n}\nexport function cariUpgrade(key: string): Upgrade | undefined {\n return UPGRADE.find((u) => u.key === key);\n}\n\n// Harga bahan setelah diskon (dibulatkan ke atas, minimal 1).\nexport function hargaBahanSetelahDiskon(\n bahan: Bahan,\n diskonPersen: number,\n): number {\n const harga = Math.round(bahan.harga * (1 - diskonPersen / 100));\n return Math.max(1, harga);\n}",[],[183,806,808],"8fd1f270-7472-439c-9b9a-42fa051d44a3","51f94d78-a763-11f1-b7f7-1607ee4eb77e",506,["D",1788418057319],"import { supabase } from \"../../supabase-client.ts\";\n\nfunction generatePin(): string {\n return String(Math.floor(100000 + Math.random() * 900000));\n}\n\n// Cari PIN 6 digit yang tidak dipakai sesi lain yang MASIH aktif\n// (menunggu/berlangsung) — sesi yang sudah selesai boleh PIN-nya\n// dipakai ulang.\nasync function generatePinUnik(): Promise {\n for (let percobaan = 0; percobaan < 20; percobaan++) {\n const pin = generatePin();\n const { data, error } = await supabase\n .from(\"game_kafe_sesi\")\n .select(\"id\")\n .eq(\"pin\", pin)\n .in(\"status\", [\"menunggu\", \"berlangsung\"])\n .maybeSingle();\n if (error) throw error;\n if (!data) return pin;\n }\n throw new Error(\"Gagal membuat PIN unik, coba lagi.\");\n}\n\n// Daftar bank soal milik guru ini (dipakai dashboard Kafe Seru untuk\n// dropdown pilih bank soal — sengaja query langsung ke tabel bank\n// soal Kuis Pilihan Ganda, bukan lewat modul itu, supaya kedua game\n// tetap independen satu sama lain).\nexport async function getBankSoalGuru(guruId: string) {\n const { data, error } = await supabase\n .from(\"game_quiz_bank\")\n .select(\"id, nama_bank, mapel, kelas\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function getJumlahSoalBank(bankId: string): Promise {\n const { count, error } = await supabase\n .from(\"game_quiz_soal\")\n .select(\"id\", { count: \"exact\", head: true })\n .eq(\"bank_id\", bankId)\n .not(\"pertanyaan\", \"is\", null);\n if (error) throw error;\n return count ?? 0;\n}\n\nexport async function getRiwayatSesi(guruId: string) {\n const { data, error } = await supabase\n .from(\"game_kafe_sesi\")\n .select(\"*, game_quiz_bank(nama_bank)\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false })\n .limit(30);\n if (error) throw error;\n return data;\n}\n\nexport async function createSesiKafe(\n bankId: string,\n guruId: string,\n namaSesi: string,\n kelas: string,\n waktuTotalMenit: number,\n) {\n const pin = await generatePinUnik();\n const { data, error } = await supabase\n .from(\"game_kafe_sesi\")\n .insert({\n bank_id: bankId,\n guru_id: guruId,\n nama_sesi: namaSesi,\n kelas,\n pin,\n waktu_total_menit: waktuTotalMenit,\n })\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\n// Kalau sesi masih berstatus \"berlangsung\" tapi waktu totalnya sudah\n// lewat, otomatis tandai selesai. Dipanggil setiap kali detail sesi\n// diambil (baik oleh guru maupun — di modul online — oleh siswa)\n// supaya status tidak pernah \"nyangkut\" berlangsung selamanya walau\n// tidak ada yang mengklik apa pun setelah waktu habis.\nasync function pastikanSesiTerkini(sesi: any) {\n if (sesi.status !== \"berlangsung\" || !sesi.mulai_at) return sesi;\n const berakhirMs = new Date(sesi.mulai_at).getTime() +\n sesi.waktu_total_menit * 60_000;\n if (Date.now() < berakhirMs) return sesi;\n const { data, error } = await supabase\n .from(\"game_kafe_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesi.id)\n .eq(\"status\", \"berlangsung\")\n .select(\"*, game_quiz_bank(nama_bank)\")\n .maybeSingle();\n if (error) throw error;\n return data ?? { ...sesi, status: \"selesai\" };\n}\n\nexport async function getSesiDetail(sesiId: string) {\n const { data: sesiMentah, error: sesiError } = await supabase\n .from(\"game_kafe_sesi\")\n .select(\"*, game_quiz_bank(nama_bank)\")\n .eq(\"id\", sesiId)\n .single();\n if (sesiError) throw sesiError;\n const sesi = await pastikanSesiTerkini(sesiMentah);\n\n const { data: peserta, error: pesertaError } = await supabase\n .from(\"game_kafe_peserta\")\n .select(\n \"id, nama_peserta, uang, jumlah_soal_benar, jumlah_soal_salah, jumlah_pelanggan_dilayani, status, joined_at\",\n )\n .eq(\"sesi_id\", sesiId)\n .order(\"uang\", { ascending: false });\n if (pesertaError) throw pesertaError;\n\n return { sesi, peserta };\n}\n\n// Guru menekan \"Mulai Permainan\" di lobi: kunci status jadi\n// berlangsung & catat waktu mulai (dipakai semua peserta untuk\n// menghitung mundur waktu sesi bersama-sama).\nexport async function mulaiSesi(sesiId: string) {\n const { data, error } = await supabase\n .from(\"game_kafe_sesi\")\n .update({ status: \"berlangsung\", mulai_at: new Date().toISOString() })\n .eq(\"id\", sesiId)\n .eq(\"status\", \"menunggu\") // jaga-jaga double click / dua tab guru\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\nexport async function selesaikanSesi(sesiId: string) {\n const { error } = await supabase\n .from(\"game_kafe_sesi\")\n .update({ status: \"selesai\", selesai_at: new Date().toISOString() })\n .eq(\"id\", sesiId)\n .neq(\"status\", \"selesai\");\n if (error) throw error;\n}\n\nexport async function hapusSesi(sesiId: string, guruId: string) {\n const { error } = await supabase\n .from(\"game_kafe_sesi\")\n .delete()\n .eq(\"id\", sesiId)\n .eq(\"guru_id\", guruId);\n if (error) throw error;\n}",[],[183,806,344],"7679921a-a387-4647-bfc2-9f8d209899e3","2627cd8c-a763-11f1-9ba8-1607ee4eb77e",496,["D",1788417976284],[],[183,806,169],"ecb136d8-4009-45b4-a809-a751fd85f33e","2c15abba-a763-11f1-a2f9-1607ee4eb77e",500,["D",1788418010555],[],[183,806,505],"f3009933-275e-4d36-9d2c-7169d60361dc",494,["D",1788417962235],[201,202,203,204,205],[183,806],["D",1787359122388],[200,206,214,230,237,255,264],[183],["D",1787214292968],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":54,"_101":102,"_103":24},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":879,"_880":881,"_882":883,"_884":24,"_885":24,"_886":24,"_887":58,"_888":-5,"_889":-7,"_890":-7,"_891":62,"_892":24,"_893":24,"_894":-5,"_895":24,"_896":24,"_897":24,"_898":-5},"ENV",{"_850":851,"_852":853,"_854":86,"_855":856,"_857":858,"_859":860,"_861":862,"_863":864,"_865":866,"_867":868,"_869":870,"_871":872,"_873":874,"_875":876,"_877":878},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v507