Masuk - Game Kelas Seru

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_517":518,"_519":520},"routes/_app.x.$handle.$name",{"_98":97,"_32":46,"_107":88,"_27":54,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":60,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",260,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","games/kuis-kotak/router.ts","latestPath","fileId","ebe3c4c8-9dc1-11f1-a919-1607ee4eb77e","name","router.ts","fileType","script","content","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 !!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/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 if (sesiSekarang.sesi.power_up_aktif) {\n hasilKejutan = kejutan.rollKejutanSkor(\n sesiSekarang.tim,\n body.timId,\n body.poinDidapat ?? 0,\n );\n if (hasilKejutan) {\n await db.terapkanKejutanSkor(hasilKejutan.timUpdates);\n }\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}","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}","createdAt",["D",1787874272880],"branchVersion","branchId","bd2fe270-08f5-4680-8e93-d0b723d2f35b","id","a8f6ac52-3919-4075-bb42-dbbec1ede301","games_edukatif",["D",1787214292968],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","992961c3-d853-4f33-891e-6befa08ebdea","pinnedFileId","d6b97946-9c70-11f1-8f5e-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e816c-8138-77ee-90fb-c8d9a829576f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":56,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"isOwned",939,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","thesleepyholic","handle","displayName","The Sleepy Holic","avatar","https://lh3.googleusercontent.com/a/ACg8ocKWNutdQNCKQpzm17_HQMSp-JDJOlBElSxJRU2c9jv12VMyENZs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_32":46,"_39":513,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":514,"_82":515,"_84":516,"_86":25},"tree",[201,233,235,238,239,240,241],"files",[201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241],"counts",{"_190":64,"_191":182,"_192":64,"_193":194,"_195":196},"contents",[128,129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":184,"_32":185,"_30":186,"_138":-5,"_42":43,"_41":187,"_140":60,"_39":188,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_27":189},{"_44":177,"_32":178,"_30":179,"_138":-5,"_42":43,"_41":180,"_140":60,"_39":181,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_27":183},{"_44":170,"_32":171,"_30":172,"_138":-5,"_42":43,"_41":173,"_140":60,"_39":174,"_13":142,"_34":175,"_36":-5,"_24":25,"_144":-5,"_27":176},{"_44":163,"_32":164,"_30":165,"_138":-5,"_42":43,"_41":166,"_140":60,"_39":167,"_13":142,"_34":35,"_36":168,"_24":25,"_144":-5,"_27":169},{"_44":155,"_32":156,"_30":157,"_138":-5,"_42":43,"_41":158,"_140":60,"_39":159,"_13":160,"_34":35,"_36":161,"_24":25,"_144":-5,"_27":162},{"_44":146,"_32":147,"_30":58,"_138":-5,"_42":43,"_41":148,"_140":25,"_39":149,"_13":150,"_34":151,"_36":152,"_24":25,"_144":153,"_27":154},{"_44":135,"_32":136,"_30":137,"_138":-5,"_42":43,"_41":139,"_140":60,"_39":141,"_13":142,"_34":35,"_36":143,"_24":25,"_144":-5,"_27":145},"23eaec3a-e2a3-4937-8b98-a83fd1156545","supabase-client.ts","36281b06-9dc2-11f1-b7b0-1607ee4eb77e","parentId",131,"latest",["D",1787359474898],2,"import { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nexport const supabase = createClient(\n Deno.env.get(\"SUPABASE_URL\")!,\n Deno.env.get(\"SUPABASE_SERVICE_KEY\")!,\n);","label",[136],"0a3e6cb7-9678-4893-be23-873c6f8add37","main.ts",258,["D",1787874227083],14,"http","import {\n clearSessionCookie,\n createSessionToken,\n generateSalt,\n hashPassword,\n sessionCookie,\n verifySession,\n} from \"./auth.ts\";\nimport * as dbCore from \"./db-core.ts\";\nimport * as kejutan from \"./lib/powerups.ts\";\nimport { renderLogin } from \"./views/login.ts\";\nimport { renderHub } from \"./views/hub.ts\";\nimport { handleKuisKotak } from \"./games/kuis-kotak/router.ts\";\nimport { handleRodaPutar } from \"./games/roda-putar/router.ts\";\nimport { handleKuisPilihanGanda } from \"./games/kuis-pilihan-ganda/router.ts\";\nimport {\n handleOlimpiadeGuru,\n handleOlimpiadePublic,\n} from \"./games/kuis-pilihan-ganda/olimpiade/router.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}\n\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n const method = req.method;\n\n // ============================================================\n // ===== AUTH (shared, tidak butuh session) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/login\") {\n return html(await renderLogin());\n }\n\n if (method === \"POST\" && path === \"/api/register\") {\n try {\n const body = await req.json();\n if (!body.email || !body.password || !body.nama) {\n return json({ error: \"Nama, email, dan password wajib diisi\" }, 400);\n }\n if (body.password.length < 6) {\n return json({ error: \"Password minimal 6 karakter\" }, 400);\n }\n const existing = await dbCore.getGuruByEmail(body.email);\n if (existing) {\n return json({ error: \"Email sudah terdaftar\" }, 400);\n }\n const salt = generateSalt();\n const hash = await hashPassword(body.password, salt);\n const guru = await dbCore.createGuru(body.email, hash, salt, body.nama);\n const token = await createSessionToken(guru.id, guru.nama);\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: {\n \"content-type\": \"application/json\",\n \"set-cookie\": sessionCookie(token),\n },\n });\n } catch (e) {\n return json({ error: \"Gagal mendaftar: \" + (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path === \"/api/login\") {\n try {\n const body = await req.json();\n if (!body.email || !body.password) {\n return json({ error: \"Email dan password wajib diisi\" }, 400);\n }\n const guru = await dbCore.getGuruByEmail(body.email);\n if (!guru) {\n return json({ error: \"Email atau password salah\" }, 401);\n }\n const hash = await hashPassword(body.password, guru.salt);\n if (hash !== guru.password_hash) {\n return json({ error: \"Email atau password salah\" }, 401);\n }\n const token = await createSessionToken(guru.id, guru.nama);\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: {\n \"content-type\": \"application/json\",\n \"set-cookie\": sessionCookie(token),\n },\n });\n } catch (e) {\n return json({ error: \"Gagal masuk: \" + (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path === \"/api/logout\") {\n return new Response(JSON.stringify({ ok: true }), {\n status: 200,\n headers: {\n \"content-type\": \"application/json\",\n \"set-cookie\": clearSessionCookie(),\n },\n });\n }\n\n // ============================================================\n // ===== RUTE PUBLIK LATIHAN OLIMPIADE (siswa, tanpa akun) =====\n // Harus dicek sebelum verifySession karena siswa tidak login.\n // ============================================================\n\n const olimpiadePublicResponse = await handleOlimpiadePublic(\n req,\n method,\n path,\n );\n if (olimpiadePublicResponse) return olimpiadePublicResponse;\n\n // ============================================================\n // ===== CEK SESSION UNTUK SEMUA ROUTE LAIN =====\n // ============================================================\n\n const session = await verifySession(req);\n if (!session) {\n if (method === \"GET\" && !path.startsWith(\"/api/\")) {\n return new Response(null, {\n status: 302,\n headers: { location: \"/login\" },\n });\n }\n return json({ error: \"Unauthorized\" }, 401);\n }\n const guruId = session.guruId;\n const namaGuru = session.nama;\n\n // ============================================================\n // ===== HUB (shared) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/\") {\n return html(await renderHub(guruId, namaGuru));\n }\n\n // ============================================================\n // ===== KATALOG POWER-UP (shared, dipakai Kuis Kotak, Roda\n // Putar, dan Kuis Pilihan Ganda saat guru memilih kejutan skor) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/api/powerups/daftar\") {\n return json(kejutan.getKatalogKejutan());\n }\n\n // ============================================================\n // ===== DELEGASI KE MODUL GAME =====\n // Setiap modul mengembalikan Response kalau route-nya cocok,\n // atau null kalau bukan urusannya — lalu diteruskan ke modul berikutnya.\n // ============================================================\n\n const kuisKotakResponse = await handleKuisKotak(\n req,\n method,\n path,\n guruId,\n namaGuru,\n );\n if (kuisKotakResponse) return kuisKotakResponse;\n\n const rodaPutarResponse = await handleRodaPutar(\n req,\n method,\n path,\n guruId,\n namaGuru,\n );\n if (rodaPutarResponse) return rodaPutarResponse;\n\n const kuisPilihanGandaResponse = await handleKuisPilihanGanda(\n req,\n method,\n path,\n guruId,\n namaGuru,\n );\n if (kuisPilihanGandaResponse) return kuisPilihanGandaResponse;\n\n const olimpiadeGuruResponse = await handleOlimpiadeGuru(\n req,\n method,\n path,\n guruId,\n namaGuru,\n );\n if (olimpiadeGuruResponse) return olimpiadeGuruResponse;\n\n // ============================================================\n // ===== 404 =====\n // ============================================================\n\n return new Response(\"Not found\", { status: 404 });\n}","gameskelas",[147],"173e9b66-f9c2-4d94-9bab-a0eca131bb9d","db-core.ts","b3904b78-9dc1-11f1-986c-1607ee4eb77e",132,["D",1787359509276],3,"import { supabase } from \"./supabase-client.ts\";\n\nexport async function getGuruByEmail(email: string) {\n const { data, error } = await supabase.from(\"game_guru\").select(\"*\").eq(\n \"email\",\n email,\n ).maybeSingle();\n if (error) throw error;\n return data;\n}\n\nexport async function createGuru(\n email: string,\n passwordHash: string,\n salt: string,\n nama: string,\n) {\n const { data, error } = await supabase\n .from(\"game_guru\")\n .insert({ email, password_hash: passwordHash, salt, nama })\n .select()\n .single();\n if (error) throw error;\n return data;\n}",[156],"34e0f9f7-2329-4657-a5ca-cb990c59951d","auth.ts","6e8ebe28-9c73-11f1-a8b3-1607ee4eb77e",27,["D",1787215541674],"const SESSION_SECRET = Deno.env.get(\"SESSION_SECRET\") || \"\";\nconst SESSION_MAX_AGE_MS = 1000 * 60 * 60 * 24 * 30; // 30 hari\n\nif (!SESSION_SECRET) {\n console.warn(\"PERINGATAN: SESSION_SECRET belum di-set di environment variables!\");\n}\n\nfunction toHex(buffer: ArrayBuffer): string {\n return Array.from(new Uint8Array(buffer)).map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nasync function hmac(data: string): Promise {\n const key = await crypto.subtle.importKey(\n \"raw\",\n new TextEncoder().encode(SESSION_SECRET),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sig = await crypto.subtle.sign(\"HMAC\", key, new TextEncoder().encode(data));\n return toHex(sig);\n}\n\nexport async function createSessionToken(guruId: string, nama: string): Promise {\n const payload = JSON.stringify({ guruId, nama, exp: Date.now() + SESSION_MAX_AGE_MS });\n const payloadB64 = btoa(payload);\n const sig = await hmac(payloadB64);\n return `${payloadB64}.${sig}`;\n}\n\nexport async function verifySession(req: Request): Promise<{ guruId: string; nama: string } | null> {\n const cookieHeader = req.headers.get(\"cookie\") || \"\";\n const match = cookieHeader.match(/session=([^;]+)/);\n if (!match) return null;\n const token = decodeURIComponent(match[1]);\n const [payloadB64, sig] = token.split(\".\");\n if (!payloadB64 || !sig) return null;\n const expectedSig = await hmac(payloadB64);\n if (expectedSig !== sig) return null;\n try {\n const payload = JSON.parse(atob(payloadB64));\n if (payload.exp < Date.now()) return null;\n return { guruId: payload.guruId, nama: payload.nama };\n } catch {\n return null;\n }\n}\n\nexport async function hashPassword(password: string, salt: string): Promise {\n const data = new TextEncoder().encode(password + \":\" + salt);\n const hashBuffer = await crypto.subtle.digest(\"SHA-256\", data);\n return toHex(hashBuffer);\n}\n\nexport function generateSalt(): string {\n const bytes = crypto.getRandomValues(new Uint8Array(16));\n return toHex(bytes.buffer);\n}\n\nexport function sessionCookie(token: string): string {\n const maxAgeSec = Math.floor(SESSION_MAX_AGE_MS / 1000);\n return `session=${encodeURIComponent(token)}; Path=/; HttpOnly; SameSite=Lax; Max-Age=${maxAgeSec}`;\n}\n\nexport function clearSessionCookie(): string {\n return `session=; Path=/; HttpOnly; SameSite=Lax; Max-Age=0`;\n}",[164],"a5f01678-8f40-4754-b592-9c087f0f18f5","views","f6179b4a-9dc1-11f1-865b-1607ee4eb77e",99,["D",1787359193118],"directory",[171],"2710b7a3-610c-4846-a6e8-4fc4eff49d13","lib","25c568ac-a215-11f1-a799-1607ee4eb77e",241,["D",1787834717985],1,[178],"141224d9-eabb-4789-92d4-2063be919ce1","games","d12ebe6c-9dc1-11f1-8450-1607ee4eb77e",88,["D",1787359122388],[185],"pulls","branches","forks","envVars",{"_197":199,"_200":64},"connections",{"_197":64,"_198":64},"count","unfilledCount",6,"emptyCount",{"_44":184,"_32":185,"_30":186,"_138":-5,"_42":43,"_41":187,"_140":60,"_39":510,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":511,"_27":512},{"_44":505,"_32":461,"_30":457,"_138":186,"_42":43,"_41":506,"_140":60,"_39":507,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":508,"_27":509},{"_44":500,"_32":171,"_30":472,"_138":457,"_42":43,"_41":501,"_140":60,"_39":502,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":503,"_27":504},{"_44":492,"_32":493,"_30":494,"_138":472,"_42":43,"_41":495,"_140":25,"_39":496,"_13":160,"_34":35,"_36":497,"_24":25,"_144":-5,"_243":498,"_27":499},{"_44":485,"_32":321,"_30":486,"_138":472,"_42":43,"_41":487,"_140":25,"_39":488,"_13":325,"_34":35,"_36":489,"_24":25,"_144":-5,"_243":490,"_27":491},{"_44":478,"_32":303,"_30":479,"_138":472,"_42":43,"_41":480,"_140":25,"_39":481,"_13":325,"_34":35,"_36":482,"_24":25,"_144":-5,"_243":483,"_27":484},{"_44":469,"_32":470,"_30":471,"_138":472,"_42":43,"_41":473,"_140":25,"_39":474,"_13":160,"_34":35,"_36":475,"_24":25,"_144":-5,"_243":476,"_27":477},{"_44":462,"_32":295,"_30":463,"_138":457,"_42":43,"_41":464,"_140":25,"_39":465,"_13":308,"_34":35,"_36":466,"_24":25,"_144":-5,"_243":467,"_27":468},{"_44":456,"_32":33,"_30":31,"_138":457,"_42":43,"_41":14,"_140":25,"_39":458,"_13":325,"_34":35,"_36":38,"_24":25,"_144":-5,"_243":459,"_27":460},{"_44":451,"_32":347,"_30":341,"_138":186,"_42":43,"_41":452,"_140":60,"_39":453,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":454,"_27":455},{"_44":446,"_32":391,"_30":385,"_138":341,"_42":43,"_41":447,"_140":60,"_39":448,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":449,"_27":450},{"_44":441,"_32":171,"_30":403,"_138":385,"_42":43,"_41":442,"_140":60,"_39":443,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":444,"_27":445},{"_44":433,"_32":434,"_30":435,"_138":403,"_42":43,"_41":436,"_140":25,"_39":437,"_13":325,"_34":35,"_36":438,"_24":25,"_144":-5,"_243":439,"_27":440},{"_44":425,"_32":426,"_30":427,"_138":403,"_42":43,"_41":428,"_140":25,"_39":429,"_13":396,"_34":35,"_36":430,"_24":25,"_144":-5,"_243":431,"_27":432},{"_44":417,"_32":418,"_30":419,"_138":403,"_42":43,"_41":420,"_140":25,"_39":421,"_13":308,"_34":35,"_36":422,"_24":25,"_144":-5,"_243":423,"_27":424},{"_44":409,"_32":410,"_30":411,"_138":403,"_42":43,"_41":412,"_140":25,"_39":413,"_13":199,"_34":35,"_36":414,"_24":25,"_144":-5,"_243":415,"_27":416},{"_44":400,"_32":401,"_30":402,"_138":403,"_42":43,"_41":404,"_140":25,"_39":405,"_13":160,"_34":35,"_36":406,"_24":25,"_144":-5,"_243":407,"_27":408},{"_44":392,"_32":295,"_30":393,"_138":385,"_42":43,"_41":394,"_140":25,"_39":395,"_13":396,"_34":35,"_36":397,"_24":25,"_144":-5,"_243":398,"_27":399},{"_44":383,"_32":33,"_30":384,"_138":385,"_42":43,"_41":386,"_140":25,"_39":387,"_13":308,"_34":35,"_36":388,"_24":25,"_144":-5,"_243":389,"_27":390},{"_44":378,"_32":171,"_30":357,"_138":341,"_42":43,"_41":379,"_140":60,"_39":380,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":381,"_27":382},{"_44":370,"_32":321,"_30":371,"_138":357,"_42":43,"_41":372,"_140":25,"_39":373,"_13":374,"_34":35,"_36":375,"_24":25,"_144":-5,"_243":376,"_27":377},{"_44":363,"_32":313,"_30":364,"_138":357,"_42":43,"_41":365,"_140":25,"_39":366,"_13":142,"_34":35,"_36":367,"_24":25,"_144":-5,"_243":368,"_27":369},{"_44":355,"_32":303,"_30":356,"_138":357,"_42":43,"_41":358,"_140":25,"_39":359,"_13":160,"_34":35,"_36":360,"_24":25,"_144":-5,"_243":361,"_27":362},{"_44":348,"_32":295,"_30":349,"_138":341,"_42":43,"_41":350,"_140":25,"_39":351,"_13":160,"_34":35,"_36":352,"_24":25,"_144":-5,"_243":353,"_27":354},{"_44":339,"_32":33,"_30":340,"_138":341,"_42":43,"_41":342,"_140":25,"_39":343,"_13":160,"_34":35,"_36":344,"_24":25,"_144":-5,"_243":345,"_27":346},{"_44":334,"_32":293,"_30":287,"_138":186,"_42":43,"_41":335,"_140":60,"_39":336,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":337,"_27":338},{"_44":329,"_32":171,"_30":305,"_138":287,"_42":43,"_41":330,"_140":60,"_39":331,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":332,"_27":333},{"_44":320,"_32":321,"_30":322,"_138":305,"_42":43,"_41":323,"_140":25,"_39":324,"_13":325,"_34":35,"_36":326,"_24":25,"_144":-5,"_243":327,"_27":328},{"_44":312,"_32":313,"_30":314,"_138":305,"_42":43,"_41":315,"_140":60,"_39":316,"_13":160,"_34":35,"_36":317,"_24":25,"_144":-5,"_243":318,"_27":319},{"_44":302,"_32":303,"_30":304,"_138":305,"_42":43,"_41":306,"_140":60,"_39":307,"_13":308,"_34":35,"_36":309,"_24":25,"_144":-5,"_243":310,"_27":311},{"_44":294,"_32":295,"_30":296,"_138":287,"_42":43,"_41":297,"_140":25,"_39":298,"_13":160,"_34":35,"_36":299,"_24":25,"_144":-5,"_243":300,"_27":301},{"_44":285,"_32":33,"_30":286,"_138":287,"_42":43,"_41":288,"_140":25,"_39":289,"_13":160,"_34":35,"_36":290,"_24":25,"_144":-5,"_243":291,"_27":292},{"_44":177,"_32":178,"_30":179,"_138":-5,"_42":43,"_41":180,"_140":60,"_39":282,"_13":182,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":283,"_27":284},{"_44":274,"_32":275,"_30":276,"_138":179,"_42":43,"_41":277,"_140":60,"_39":278,"_13":160,"_34":35,"_36":279,"_24":25,"_144":-5,"_243":280,"_27":281},{"_44":170,"_32":171,"_30":172,"_138":-5,"_42":43,"_41":173,"_140":60,"_39":271,"_13":142,"_34":175,"_36":-5,"_24":25,"_144":-5,"_243":272,"_27":273},{"_44":263,"_32":264,"_30":265,"_138":172,"_42":43,"_41":266,"_140":25,"_39":267,"_13":199,"_34":35,"_36":268,"_24":25,"_144":-5,"_243":269,"_27":270},{"_44":255,"_32":256,"_30":257,"_138":172,"_42":43,"_41":258,"_140":25,"_39":259,"_13":142,"_34":35,"_36":260,"_24":25,"_144":-5,"_243":261,"_27":262},{"_44":163,"_32":164,"_30":165,"_138":-5,"_42":43,"_41":166,"_140":60,"_39":252,"_13":142,"_34":35,"_36":168,"_24":25,"_144":-5,"_243":253,"_27":254},{"_44":155,"_32":156,"_30":157,"_138":-5,"_42":43,"_41":158,"_140":60,"_39":249,"_13":160,"_34":35,"_36":161,"_24":25,"_144":-5,"_243":250,"_27":251},{"_44":146,"_32":147,"_30":58,"_138":-5,"_42":43,"_41":148,"_140":25,"_39":246,"_13":150,"_34":151,"_36":152,"_24":25,"_144":153,"_243":247,"_27":248},{"_44":135,"_32":136,"_30":137,"_138":-5,"_42":43,"_41":139,"_140":60,"_39":242,"_13":142,"_34":35,"_36":143,"_24":25,"_144":-5,"_243":244,"_27":245},["D",1787359474898],"children",[],[136],["D",1787874227083],[],[147],["D",1787359509276],[],[156],["D",1787215541674],[],[164],"15bc6465-17c0-47e8-860b-7f7e1f2e07ae","login.ts","0322fa6e-9dc2-11f1-8479-1607ee4eb77e",135,["D",1787359562689],"export async function renderLogin(errorMsg?: string): Promise {\n return `\n\n\n \n \n Masuk - Game Kelas Seru\n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[171,256],"e489f6ff-4d45-491d-b3ff-8119c3cbc1ef","hub.ts","08121762-9dc2-11f1-be5f-1607ee4eb77e",229,["D",1787790426639],"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}",[],[171,264],["D",1787359193118],[236,237],[171],"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}",[],[178,275],["D",1787834717985],[234],[178],"c0173aa1-7aa5-4e9f-9a78-769aab07834a","1d8cce16-9dc2-11f1-97c0-1607ee4eb77e","122c696e-9dc2-11f1-a094-1607ee4eb77e",250,["D",1787834942996],"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 !!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/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 if (sesiSekarang.sesi.power_up_aktif) {\n hasilKejutan = kejutan.rollKejutanSkor(\n sesiSekarang.tim,\n body.timId,\n body.poinDidapat ?? 0,\n );\n if (hasilKejutan) {\n await db.terapkanKejutanSkor(hasilKejutan.timUpdates);\n }\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}",[],[185,293,33],"roda-putar","9507c98d-daa1-4cae-8b2c-f02109031950","database.ts","196e2c44-9dc2-11f1-b5b4-1607ee4eb77e",249,["D",1787834927328],"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 powerUpAktif: boolean = false,\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: 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 }));\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}",[],[185,293,295],"faa6d125-a493-4294-ad7c-35c7e529086a","play.ts","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}",[],[185,293,171,303],"1567cb87-a8cd-41f9-9d93-d3ceb6de25fa","editor.ts","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}",[],[185,293,171,313],"264d4fa8-7556-4d41-99f6-01e125151001","dashboard.ts","8ec04144-9dc2-11f1-a56c-1607ee4eb77e",251,["D",1787834958182],4,"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}",[],[185,293,171,321],"e97daa62-78e9-44b2-97cb-dace918a7ce1",124,["D",1787359432574],[228,229,230],[185,293,171],"7db4471b-95fd-418e-b09c-ea20b8606e40",105,["D",1787359234169],[227,231,232],[185,293],"d459df6e-214e-4d0a-b0b5-0b8d702626ae","d30dcc3a-a124-11f1-9b62-1607ee4eb77e","b55d2faa-a124-11f1-bd39-1607ee4eb77e",254,["D",1787835013138],"import * as db from \"./database.ts\";\nimport * as kejutan from \"../../lib/powerups.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: 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 if (\n !body.opsiA || !body.opsiB || !body.opsiC || !body.opsiD ||\n ![\"a\", \"b\", \"c\", \"d\"].includes(body.jawabanBenar)\n ) {\n return json({\n error: \"4 opsi jawaban 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 ),\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 !!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/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 if (sesiSekarang.sesi.power_up_aktif) {\n hasilKejutan = kejutan.rollKejutanSkor(\n sesiSekarang.tim,\n body.timId,\n body.poinDidapat ?? 0,\n );\n if (hasilKejutan) {\n await db.terapkanKejutanSkor(hasilKejutan.timUpdates);\n }\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}",[],[185,347,33],"kuis-pilihan-ganda","a45aea21-8a11-4380-b4e2-eaa60f9266cd","cc8ee484-a124-11f1-aa00-1607ee4eb77e",253,["D",1787834998660],"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,\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 },\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 powerUpAktif: boolean = false,\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: 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 }));\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}",[],[185,347,295],"83c8f0c4-f0d1-4235-a090-24b4783f4614","f1a5de8a-a124-11f1-9824-1607ee4eb77e","de8fe9bc-a124-11f1-855b-1607ee4eb77e",256,["D",1787835048186],"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}",[],[185,347,171,303],"e513eaf9-7e5a-4432-8010-bbcee7c79bfb","ed38a9cc-a124-11f1-bd3f-1607ee4eb77e",181,["D",1787731635616],"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}",[],[185,347,171,313],"429b21e2-61c7-4f19-ac49-a3fecea4f655","e79ea48a-a124-11f1-9b62-1607ee4eb77e",255,["D",1787835030542],8,"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}",[],[185,347,171,321],"8ac6f20c-a813-48d0-9c67-e4748e4994d8",171,["D",1787731521991],[221,222,223],[185,347,171],"8be5df36-073e-48f6-9e91-f16f761e1bee","d6100252-a126-11f1-9610-1607ee4eb77e","c806af76-a126-11f1-be47-1607ee4eb77e",236,["D",1787813452853],"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\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 );\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 === \"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}",[],[185,347,391,33],"olimpiade","465fedc7-298b-4442-9a01-f70e1016c288","d13d78b8-a126-11f1-9d87-1607ee4eb77e",235,["D",1787813433389],7,"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// 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 return {\n id: soal.id,\n pertanyaan: soal.pertanyaan,\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 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) {\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 { 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 })\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 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 = msUtc(sesi.dibuka_at) +\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 msUtc(sesi.dibuka_at) + 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() >= msUtc(sesi.dibuka_at) + 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\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}",[],[185,347,391,295],"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}",[],[185,347,391,171,401],"2d9ef2aa-df8f-4108-97ff-1fc6ac9a2392","lobi.ts","76e9393c-a127-11f1-9e87-1607ee4eb77e",237,["D",1787813470683],"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}",[],[185,347,391,171,410],"f1415293-6617-4b11-ba10-3c395671c06a","laporan.ts","7bcf3af0-a127-11f1-9489-1607ee4eb77e",238,["D",1787813485486],"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}",[],[185,347,391,171,418],"bb83ba6d-9021-4c93-8422-49957edba918","kerjakan.ts","72367f94-a127-11f1-b0cc-1607ee4eb77e",221,["D",1787789185428],"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}",[],[185,347,391,171,426],"4f908151-3dba-4b47-9d1b-3e4054025a3a","gabung.ts","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}",[],[185,347,391,171,434],"1dff0ab7-bbb0-4106-b0a5-4817970b9020",192,["D",1787732609304],[213,214,215,216,217],[185,347,391,171],"5c7f8555-6b4b-437b-a9cb-add4301036b7",184,["D",1787732341684],[212,218,219],[185,347,391],"6033e0a9-6939-4688-a9fb-489c5046a0d2",163,["D",1787731470891],[211,220,224,225],[185,347],"254300c5-2418-4938-a6e6-72bb6f644b98","de507bbc-9dc1-11f1-97c0-1607ee4eb77e",["D",1787874272880],[],[185,461,33],"kuis-kotak","7af4e24f-e85e-4c37-a52a-af622f85f53d","d70b4c24-9dc1-11f1-8727-1607ee4eb77e",259,["D",1787874252677],"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_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: 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 })\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}",[],[185,461,295],"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}",[],[185,461,171,470],"37e94bc3-792e-4fa5-b2d1-c09894c2b301","5d51443c-9dc2-11f1-b6ab-1607ee4eb77e",248,["D",1787834883887],"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}",[],[185,461,171,303],"64805f04-9da4-4aa0-8140-de396d65544d","52c55b98-9dc2-11f1-b3e3-1607ee4eb77e",247,["D",1787834863327],"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}",[],[185,461,171,321],"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}",[],[185,461,171,493],"756d84b6-dcc6-492d-9d3e-624aa0d48694",114,["D",1787359329490],[204,205,206,207],[185,461,171],"8134dfe3-aee3-4e4f-995c-1cb59aea6ef2",92,["D",1787359148187],[203,208,209],[185,461],["D",1787359122388],[202,210,226],[185],["D",1787214292968],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":56,"_103":104,"_105":25},{"_13":87,"_32":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"ctx",{"_80":-5,"_125":550,"_551":552,"_553":554,"_555":25,"_556":25,"_557":25,"_558":60,"_559":-5,"_560":-7,"_561":-7,"_562":64,"_563":25,"_564":25,"_565":-5,"_566":25,"_567":25,"_568":25,"_569":-5},"ENV",{"_521":522,"_523":524,"_525":88,"_526":527,"_528":529,"_530":531,"_532":533,"_534":535,"_536":537,"_538":539,"_540":541,"_542":543,"_544":545,"_546":547,"_548":549},"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 · v260