Masuk - Game Kelas Seru

\n \n\n`;\n}",[],[37,283],"d2b1f15c-1b91-4398-8692-3d62ccfb8cbc","hub.ts","08121762-9dc2-11f1-be5f-1607ee4eb77e",288,["D",1787875847780],7,"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}",[],[37,291],["D",1787359193118],[263,264],[37],"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,303],"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,311],["D",1787834717985],[260,261],[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,330,322],"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,330,332],"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,330,37,340],"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,330,37,349],"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,330,37,357],"b092d639-872b-4d98-8f69-32ed57406808",275,["D",1787875548695],[254,255,256],[183,330,37],"402772e7-df7c-46aa-8347-cc1cd2d2a739",269,["D",1787875520823],[253,257,258],[183,330],"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,382,322],"tebak-kata","618e8d51-d593-4336-96f5-4ebf2daa05c2","database","bbaa839e-a4ee-11f1-8106-1607ee4eb77e",382,["D",1788148100794],"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,382,384],"a2e1e3ce-3865-48ab-986c-c48261cd10ed",["D",1788148146895],[],[183,382,37],"aa8d8623-33d6-4123-988e-3dddf33c8204",379,["D",1788147969791],[249,250,251],[183,382],"f0053163-4ffd-4eab-81cf-8bb8be1ce91d","c02f623e-a4e6-11f1-b5c0-1607ee4eb77e","8e9bb8b2-a4e6-11f1-8416-1607ee4eb77e",373,["D",1788145817783],"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\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,408,322],"susun-kata-seru","38ebe854-2aa7-4b66-857b-a69dd399a23b","ba9bfbe8-a4e6-11f1-b210-1607ee4eb77e",371,["D",1788145657576],"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// ===== 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,408,332],"2082f530-c13d-48a1-8c47-3bccc338d0c5","f80f3c56-a4e6-11f1-a861-1607ee4eb77e","a236e54a-a4e6-11f1-a4cb-1607ee4eb77e",346,["D",1788144737733],[],[183,408,37,340],"35562c0c-1f6d-4f21-913c-a8aab38f3e38","f2bf6672-a4e6-11f1-b0df-1607ee4eb77e",344,["D",1788144729722],[],[183,408,37,349],"b3144069-f9c6-4383-b2ad-17a932bdc19e","eb56a71a-a4e6-11f1-a861-1607ee4eb77e",342,["D",1788144718002],[],[183,408,37,357],"8adc6340-5b71-46b1-915b-fe77a09ef1f8",332,["D",1788144594086],[243,244,245],[183,408,37],"83b386e6-15f6-45ea-89cc-afd6c30076b2","04bac70e-a4e7-11f1-b5c0-1607ee4eb77e","aaa388a0-a4e6-11f1-aa84-1607ee4eb77e",374,["D",1788145839269],"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 );\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,408,448,322],"online","9e3c7ba3-b771-4f81-b14a-93500c42b0a2","00c3c0b0-a4e7-11f1-b5fc-1607ee4eb77e",372,["D",1788145673807],"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// 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) {\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 { 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 status: \"menunggu\",\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 // 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 if (pesertaLama) return pesertaLama;\n\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 return data;\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 soalAktif = {\n id: soalMentah.id,\n tipe: soalMentah.tipe,\n pertanyaan: soalMentah.pertanyaan,\n gambar_url: soalMentah.gambar_url,\n poin: soalMentah.poin,\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 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,408,448,332],"4573779c-130a-4c23-aec1-5163f88a2f26","lobi.ts","1608e98c-a4e7-11f1-a08b-1607ee4eb77e","af414bcc-a4e6-11f1-8709-1607ee4eb77e",356,["D",1788144787183],[],[183,408,448,37,457],"5b57145a-38bf-4793-9140-28d33f46c8ca","laporan.ts","195b2bcc-a4e7-11f1-9dce-1607ee4eb77e",358,["D",1788144793229],[],[183,408,448,37,465],"b8ee4639-71ed-417a-933a-1003edeb16d8","kerjakan.ts","1232d156-a4e7-11f1-89e9-1607ee4eb77e",354,["D",1788144780992],[],[183,408,448,37,472],"30a24c2c-fe8e-4158-bb45-055ddd352450","gabung.ts","0e16661e-a4e7-11f1-807d-1607ee4eb77e",352,["D",1788144775003],[],[183,408,448,37,479],"8db7134e-9d67-4e59-a8ed-80d805da317f",336,["D",1788144615609],[236,237,238,239],[183,408,448,37],"49214bd1-0444-45c4-a412-190f6349392f",334,["D",1788144607683],[235,240,241],[183,408,448],"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,408,176,496],"8d0ca5b5-e6c4-4657-8578-f4af54ad6949",367,["D",1788145099997],[233],[183,408,176],"0da6831b-e059-4302-a69a-e5c3daf3fdd4",330,["D",1788144569442],[232,234,242,246,247],[183,408],"58e3ce00-e101-42c1-a373-dc34f78958be","1d8cce16-9dc2-11f1-97c0-1607ee4eb77e","122c696e-9dc2-11f1-a094-1607ee4eb77e",263,["D",1787874326323],4,"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,523,322],"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,523,332],"faa6d125-a493-4294-ad7c-35c7e529086a","9b40a53a-9dc2-11f1-a6c9-1607ee4eb77e","89998a18-9dc2-11f1-8633-1607ee4eb77e",252,["D",1787834971188],5,"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,523,37,340],"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,523,37,349],"6b01bb16-c9a0-4f66-ac34-558a337125e5","8ec04144-9dc2-11f1-a56c-1607ee4eb77e",312,["D",1788082039594],8,"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,523,37,357],"e97daa62-78e9-44b2-97cb-dace918a7ce1",124,["D",1787359432574],[226,227,228],[183,523,37],"7db4471b-95fd-418e-b09c-ea20b8606e40",105,["D",1787359234169],[225,229,230],[183,523],"7c9259cb-ef29-48e3-aefb-c26415743a78","d30dcc3a-a124-11f1-9b62-1607ee4eb77e","b55d2faa-a124-11f1-bd39-1607ee4eb77e",315,["D",1788083703230],"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\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 // Tiap opsi boleh diisi teks, atau cukup gambar saja (opsi teks\n // dikosongkan) — asalkan salah satunya ada.\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 return json(\n await db.upsertSoal(\n bankId,\n body.urutan,\n body.pertanyaan,\n body.opsiA ?? \"\",\n body.opsiB ?? \"\",\n body.opsiC ?? \"\",\n body.opsiD ?? \"\",\n body.jawabanBenar,\n body.poin ?? 10,\n body.gambarUrl,\n body.gambarOpsiA,\n body.gambarOpsiB,\n body.gambarOpsiC,\n body.gambarOpsiD,\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 const hasilJawab = await db.catatJawaban(\n sesiId,\n body.soalIndex,\n body.timId ?? null,\n body.opsiDipilih ?? null,\n !!body.benar,\n body.poinDidapat ?? 0,\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,573,322],"kuis-pilihan-ganda","a3fed364-9f28-430c-b585-15f0f315f329","cc8ee484-a124-11f1-aa00-1607ee4eb77e",314,["D",1788083686316],"import { supabase } from \"../../supabase-client.ts\";\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\nexport async function upsertSoal(\n bankId: string,\n urutan: number,\n pertanyaan: string,\n opsiA: string,\n opsiB: string,\n opsiC: string,\n opsiD: string,\n jawabanBenar: \"a\" | \"b\" | \"c\" | \"d\",\n poin: number,\n gambarUrl?: string | null,\n gambarOpsiA?: string | null,\n gambarOpsiB?: string | null,\n gambarOpsiC?: string | null,\n gambarOpsiD?: string | null,\n) {\n const { data, error } = await supabase\n .from(\"game_quiz_soal\")\n .upsert(\n {\n bank_id: bankId,\n urutan,\n pertanyaan,\n opsi_a: opsiA,\n opsi_b: opsiB,\n opsi_c: opsiC,\n opsi_d: opsiD,\n jawaban_benar: jawabanBenar,\n poin,\n gambar_url: gambarUrl ?? null,\n gambar_opsi_a: gambarOpsiA ?? null,\n gambar_opsi_b: gambarOpsiB ?? null,\n gambar_opsi_c: gambarOpsiC ?? null,\n gambar_opsi_d: gambarOpsiD ?? null,\n },\n { onConflict: \"bank_id,urutan\" },\n )\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(\"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) {\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 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,573,332],"f09b391c-3398-4845-93f2-0a8668abb4eb","f1a5de8a-a124-11f1-9824-1607ee4eb77e","de8fe9bc-a124-11f1-855b-1607ee4eb77e",326,["D",1788086575003],"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,573,37,340],"e239956a-1630-4df9-b4a1-650c36f6e061","ed38a9cc-a124-11f1-bd3f-1607ee4eb77e",325,["D",1788086521838],"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}",[],[183,573,37,349],"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,573,37,357],"8ac6f20c-a813-48d0-9c67-e4748e4994d8",171,["D",1787731521991],[219,220,221],[183,573,37],"73f0756d-1c58-45ab-87cc-08d6a3730be1","d6100252-a126-11f1-9610-1607ee4eb77e","c806af76-a126-11f1-be47-1607ee4eb77e",301,["D",1787888441953],"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 const opsi = [\"a\", \"b\", \"c\", \"d\"].includes(body.opsiDipilih)\n ? body.opsiDipilih\n : null;\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 opsi,\n body.waktuJawabMs ?? 0,\n )\n : await db.catatJawabanPeserta(\n pesertaId,\n body.soalIndex,\n opsi,\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 return null;\n}",[],[183,573,617,322],"olimpiade","7b1efbb2-0092-40f2-abea-73d8d6db22af","d13d78b8-a126-11f1-9d87-1607ee4eb77e",318,["D",1788083778222],10,"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 buatAcakOpsi(jumlahSoal: number): Record {\n const hasil: Record = {};\n for (let i = 0; i < jumlahSoal; i++) {\n hasil[String(i)] = acakArray([\"a\", \"b\", \"c\", \"d\"]);\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 jumlahSoal: number,\n): Promise<{ urutanSoal: number[]; acakOpsi: Record }> {\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(jumlahSoal);\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: teks opsi\n// disusun ulang sesuai peta (peta[0] = huruf kanonis yang tampil\n// di posisi A, dst), plus sertakan `petaOpsi` supaya klien bisa\n// menerjemahkan balik huruf yang diklik -> huruf kanonis saat\n// mengirim jawaban.\nfunction acakSoalUntukTampilan(soal: any, peta: string[]) {\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 id: soal.id,\n pertanyaan: soal.pertanyaan,\n gambar_url: soal.gambar_url,\n opsi_a: opsiAsli[peta[0]],\n opsi_b: opsiAsli[peta[1]],\n opsi_c: opsiAsli[peta[2]],\n opsi_d: opsiAsli[peta[3]],\n gambar_opsi_a: gambarOpsiAsli[peta[0]],\n gambar_opsi_b: gambarOpsiAsli[peta[1]],\n gambar_opsi_c: gambarOpsiAsli[peta[2]],\n gambar_opsi_d: gambarOpsiAsli[peta[3]],\n poin: soal.poin,\n petaOpsi: peta,\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// ===== 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\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(\"id\")\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(jumlahSoal),\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 totalSoal,\n );\n\n const { data: jawabanList, error: jawabanError } = await supabase\n .from(\"game_quiz_peserta_jawaban\")\n .select(\"soal_index, opsi_dipilih\")\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 + huruf yang sesuai di layarnya.\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 peta = acakOpsi[String(j.soal_index)] || [\"a\", \"b\", \"c\", \"d\"];\n jawabanTersimpan[posisi] = hurufTampilDariKanonis(\n peta,\n j.opsi_dipilih,\n );\n }\n\n const soalListAcak = urutanSoal.map((kanonisIdx) =>\n acakSoalUntukTampilan(\n soalList[kanonisIdx],\n acakOpsi[String(kanonisIdx)] || [\"a\", \"b\", \"c\", \"d\"],\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 totalSoal,\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)] || [\"a\", \"b\", \"c\", \"d\"],\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 async function catatJawabanPeserta(\n pesertaId: string,\n soalIndex: number,\n opsiDipilih: \"a\" | \"b\" | \"c\" | \"d\" | null,\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 } = await pastikanUrutanPeserta(\n peserta,\n soalList.length,\n );\n const kanonisIdx = urutanSoal[soalIndex];\n const soal = soalList[kanonisIdx];\n if (!soal) throw new Error(\"Soal tidak ditemukan\");\n\n // opsiDipilih yang dikirim klien sudah diterjemahkan ke huruf KANONIS\n // di sisi tampilan (lihat kerjakan.ts), jadi perbandingan ini tetap\n // memakai kunci jawaban asli dari bank soal.\n const benar = opsiDipilih !== null && opsiDipilih === soal.jawaban_benar;\n const poinDidapat = benar ? soal.poin : 0;\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: opsiDipilih,\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 opsiDipilih: \"a\" | \"b\" | \"c\" | \"d\" | null,\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 } = await pastikanUrutanPeserta(\n peserta,\n soalList.length,\n );\n const kanonisIdx = urutanSoal[soalIndex];\n const soal = soalList[kanonisIdx];\n if (!soal) throw new Error(\"Soal tidak ditemukan\");\n\n const benar = opsiDipilih !== null && opsiDipilih === soal.jawaban_benar;\n const poinDidapat = benar ? soal.poin : 0;\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: opsiDipilih,\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,573,617,332],"02236069-59f7-429f-926e-2aa220e7af0c","riwayat.ts","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,573,617,37,627],"ad4ddb8f-b8a7-4ba8-90cb-ec955d70f5fd","76e9393c-a127-11f1-9e87-1607ee4eb77e",320,["D",1788084783368],9,"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,573,617,37,457],"0114531d-30f3-42b3-ad88-a5bbe022b692","7bcf3af0-a127-11f1-9489-1607ee4eb77e",328,["D",1788140478178],"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,573,617,37,465],"ee7e5828-66e2-4943-9826-62a4d13649fd","72367f94-a127-11f1-b0cc-1607ee4eb77e",327,["D",1788086610226],"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,573,617,37,472],"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,573,617,37,479],"1dff0ab7-bbb0-4106-b0a5-4817970b9020",192,["D",1787732609304],[211,212,213,214,215],[183,573,617,37],"5c7f8555-6b4b-437b-a9cb-add4301036b7",184,["D",1787732341684],[210,216,217],[183,573,617],"6033e0a9-6939-4688-a9fb-489c5046a0d2",163,["D",1787731470891],[209,218,222,223],[183,573],"254300c5-2418-4938-a6e6-72bb6f644b98","ebe3c4c8-9dc1-11f1-a919-1607ee4eb77e","de507bbc-9dc1-11f1-97c0-1607ee4eb77e",260,["D",1787874272880],"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 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({ ...hasilKotak, 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,687,322],"kuis-kotak","3f688a68-ab0c-46cd-a907-4ad334cd5e6c","d70b4c24-9dc1-11f1-8727-1607ee4eb77e",289,["D",1787875984385],"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 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 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,687,332],"ba3db05a-e198-41ed-b9ac-946866e49e81","rekap.ts","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,687,37,696],"b5296ffa-1641-4ee4-b42e-c6a109965db7","5d51443c-9dc2-11f1-b6ab-1607ee4eb77e",290,["D",1787876002720],"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,687,37,340],"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,687,37,357],"49a25ab5-e6b9-4962-bdb2-5945cd9aa072","bank-editor.ts","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,687,37,719],"756d84b6-dcc6-492d-9d3e-624aa0d48694",114,["D",1787359329490],[202,203,204,205],[183,687,37],"8134dfe3-aee3-4e4f-995c-1cb59aea6ef2",92,["D",1787359148187],[201,206,207],[183,687],["D",1787359122388],[200,208,224,231,248,252],[183],["D",1787214292968],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_124":776,"_777":778,"_779":780,"_781":25,"_782":25,"_783":25,"_784":59,"_785":-5,"_786":-7,"_787":-7,"_788":63,"_789":25,"_790":25,"_791":-5,"_792":25,"_793":25,"_794":25,"_795":-5},"ENV",{"_747":748,"_749":750,"_751":87,"_752":753,"_754":755,"_756":757,"_758":759,"_760":761,"_762":763,"_764":765,"_766":767,"_768":769,"_770":771,"_772":773,"_774":775},"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 · v387