Laporan Latihan - Game Kelas Seru

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_496":497,"_498":499},"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",234,"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-pilihan-ganda/olimpiade/views/laporan.ts","latestPath","fileId","7bcf3af0-a127-11f1-9489-1607ee4eb77e","name","laporan.ts","fileType","script","content","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}","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}","createdAt",["D",1787790993148],"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":492,"_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":493,"_82":494,"_84":495,"_86":25},"tree",[194,226,229,230,231,232],"files",[194,195,196,197,198,199,200,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],"counts",{"_183":64,"_184":181,"_185":64,"_186":187,"_188":189},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":176,"_32":177,"_30":178,"_137":-5,"_42":43,"_41":179,"_139":60,"_39":180,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_27":182},{"_44":169,"_32":170,"_30":171,"_137":-5,"_42":43,"_41":172,"_139":60,"_39":173,"_13":141,"_34":174,"_36":-5,"_24":25,"_143":-5,"_27":175},{"_44":162,"_32":163,"_30":164,"_137":-5,"_42":43,"_41":165,"_139":60,"_39":166,"_13":141,"_34":35,"_36":167,"_24":25,"_143":-5,"_27":168},{"_44":154,"_32":155,"_30":156,"_137":-5,"_42":43,"_41":157,"_139":60,"_39":158,"_13":159,"_34":35,"_36":160,"_24":25,"_143":-5,"_27":161},{"_44":145,"_32":146,"_30":58,"_137":-5,"_42":43,"_41":147,"_139":25,"_39":148,"_13":149,"_34":150,"_36":151,"_24":25,"_143":152,"_27":153},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":60,"_39":140,"_13":141,"_34":35,"_36":142,"_24":25,"_143":-5,"_27":144},"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",[135],"cc704be3-b9e2-4f19-813f-b8c539ee0618","main.ts",201,["D",1787732677441],13,"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 { 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(req, method, path);\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 // ===== 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",[146],"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}",[155],"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}",[163],"a5f01678-8f40-4754-b592-9c087f0f18f5","views","f6179b4a-9dc1-11f1-865b-1607ee4eb77e",99,["D",1787359193118],"directory",[170],"141224d9-eabb-4789-92d4-2063be919ce1","games","d12ebe6c-9dc1-11f1-8450-1607ee4eb77e",88,["D",1787359122388],1,[177],"pulls","branches","forks","envVars",{"_190":192,"_193":64},"connections",{"_190":64,"_191":64},"count","unfilledCount",6,"emptyCount",{"_44":176,"_32":177,"_30":178,"_137":-5,"_42":43,"_41":179,"_139":60,"_39":489,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":490,"_27":491},{"_44":484,"_32":440,"_30":434,"_137":178,"_42":43,"_41":485,"_139":60,"_39":486,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":487,"_27":488},{"_44":479,"_32":170,"_30":451,"_137":434,"_42":43,"_41":480,"_139":60,"_39":481,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":482,"_27":483},{"_44":471,"_32":472,"_30":473,"_137":451,"_42":43,"_41":474,"_139":25,"_39":475,"_13":159,"_34":35,"_36":476,"_24":25,"_143":-5,"_234":477,"_27":478},{"_44":464,"_32":302,"_30":465,"_137":451,"_42":43,"_41":466,"_139":25,"_39":467,"_13":159,"_34":35,"_36":468,"_24":25,"_143":-5,"_234":469,"_27":470},{"_44":457,"_32":284,"_30":458,"_137":451,"_42":43,"_41":459,"_139":25,"_39":460,"_13":159,"_34":35,"_36":461,"_24":25,"_143":-5,"_234":462,"_27":463},{"_44":448,"_32":449,"_30":450,"_137":451,"_42":43,"_41":452,"_139":25,"_39":453,"_13":159,"_34":35,"_36":454,"_24":25,"_143":-5,"_234":455,"_27":456},{"_44":441,"_32":276,"_30":442,"_137":434,"_42":43,"_41":443,"_139":25,"_39":444,"_13":159,"_34":35,"_36":445,"_24":25,"_143":-5,"_234":446,"_27":447},{"_44":432,"_32":266,"_30":433,"_137":434,"_42":43,"_41":435,"_139":25,"_39":436,"_13":141,"_34":35,"_36":437,"_24":25,"_143":-5,"_234":438,"_27":439},{"_44":427,"_32":327,"_30":321,"_137":178,"_42":43,"_41":428,"_139":60,"_39":429,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":430,"_27":431},{"_44":422,"_32":370,"_30":364,"_137":321,"_42":43,"_41":423,"_139":60,"_39":424,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":425,"_27":426},{"_44":417,"_32":170,"_30":381,"_137":364,"_42":43,"_41":418,"_139":60,"_39":419,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":420,"_27":421},{"_44":409,"_32":410,"_30":411,"_137":381,"_42":43,"_41":412,"_139":25,"_39":413,"_13":289,"_34":35,"_36":414,"_24":25,"_143":-5,"_234":415,"_27":416},{"_44":400,"_32":401,"_30":402,"_137":381,"_42":43,"_41":403,"_139":25,"_39":404,"_13":405,"_34":35,"_36":406,"_24":25,"_143":-5,"_234":407,"_27":408},{"_44":396,"_32":33,"_30":31,"_137":381,"_42":43,"_41":14,"_139":25,"_39":397,"_13":289,"_34":35,"_36":38,"_24":25,"_143":-5,"_234":398,"_27":399},{"_44":387,"_32":388,"_30":389,"_137":381,"_42":43,"_41":390,"_139":25,"_39":391,"_13":392,"_34":35,"_36":393,"_24":25,"_143":-5,"_234":394,"_27":395},{"_44":378,"_32":379,"_30":380,"_137":381,"_42":43,"_41":382,"_139":25,"_39":383,"_13":159,"_34":35,"_36":384,"_24":25,"_143":-5,"_234":385,"_27":386},{"_44":371,"_32":276,"_30":372,"_137":364,"_42":43,"_41":373,"_139":25,"_39":374,"_13":192,"_34":35,"_36":375,"_24":25,"_143":-5,"_234":376,"_27":377},{"_44":362,"_32":266,"_30":363,"_137":364,"_42":43,"_41":365,"_139":25,"_39":366,"_13":289,"_34":35,"_36":367,"_24":25,"_143":-5,"_234":368,"_27":369},{"_44":357,"_32":170,"_30":337,"_137":321,"_42":43,"_41":358,"_139":60,"_39":359,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":360,"_27":361},{"_44":350,"_32":302,"_30":351,"_137":337,"_42":43,"_41":352,"_139":25,"_39":353,"_13":192,"_34":35,"_36":354,"_24":25,"_143":-5,"_234":355,"_27":356},{"_44":343,"_32":294,"_30":344,"_137":337,"_42":43,"_41":345,"_139":25,"_39":346,"_13":141,"_34":35,"_36":347,"_24":25,"_143":-5,"_234":348,"_27":349},{"_44":335,"_32":284,"_30":336,"_137":337,"_42":43,"_41":338,"_139":25,"_39":339,"_13":141,"_34":35,"_36":340,"_24":25,"_143":-5,"_234":341,"_27":342},{"_44":328,"_32":276,"_30":329,"_137":321,"_42":43,"_41":330,"_139":25,"_39":331,"_13":141,"_34":35,"_36":332,"_24":25,"_143":-5,"_234":333,"_27":334},{"_44":319,"_32":266,"_30":320,"_137":321,"_42":43,"_41":322,"_139":25,"_39":323,"_13":141,"_34":35,"_36":324,"_24":25,"_143":-5,"_234":325,"_27":326},{"_44":314,"_32":274,"_30":268,"_137":178,"_42":43,"_41":315,"_139":60,"_39":316,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":317,"_27":318},{"_44":309,"_32":170,"_30":286,"_137":268,"_42":43,"_41":310,"_139":60,"_39":311,"_13":181,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":312,"_27":313},{"_44":301,"_32":302,"_30":303,"_137":286,"_42":43,"_41":304,"_139":25,"_39":305,"_13":159,"_34":35,"_36":306,"_24":25,"_143":-5,"_234":307,"_27":308},{"_44":293,"_32":294,"_30":295,"_137":286,"_42":43,"_41":296,"_139":60,"_39":297,"_13":159,"_34":35,"_36":298,"_24":25,"_143":-5,"_234":299,"_27":300},{"_44":283,"_32":284,"_30":285,"_137":286,"_42":43,"_41":287,"_139":25,"_39":288,"_13":289,"_34":35,"_36":290,"_24":25,"_143":-5,"_234":291,"_27":292},{"_44":275,"_32":276,"_30":277,"_137":268,"_42":43,"_41":278,"_139":25,"_39":279,"_13":141,"_34":35,"_36":280,"_24":25,"_143":-5,"_234":281,"_27":282},{"_44":265,"_32":266,"_30":267,"_137":268,"_42":43,"_41":269,"_139":25,"_39":270,"_13":141,"_34":35,"_36":271,"_24":25,"_143":-5,"_234":272,"_27":273},{"_44":169,"_32":170,"_30":171,"_137":-5,"_42":43,"_41":172,"_139":60,"_39":262,"_13":141,"_34":174,"_36":-5,"_24":25,"_143":-5,"_234":263,"_27":264},{"_44":254,"_32":255,"_30":256,"_137":171,"_42":43,"_41":257,"_139":25,"_39":258,"_13":192,"_34":35,"_36":259,"_24":25,"_143":-5,"_234":260,"_27":261},{"_44":246,"_32":247,"_30":248,"_137":171,"_42":43,"_41":249,"_139":25,"_39":250,"_13":141,"_34":35,"_36":251,"_24":25,"_143":-5,"_234":252,"_27":253},{"_44":162,"_32":163,"_30":164,"_137":-5,"_42":43,"_41":165,"_139":60,"_39":243,"_13":141,"_34":35,"_36":167,"_24":25,"_143":-5,"_234":244,"_27":245},{"_44":154,"_32":155,"_30":156,"_137":-5,"_42":43,"_41":157,"_139":60,"_39":240,"_13":159,"_34":35,"_36":160,"_24":25,"_143":-5,"_234":241,"_27":242},{"_44":145,"_32":146,"_30":58,"_137":-5,"_42":43,"_41":147,"_139":25,"_39":237,"_13":149,"_34":150,"_36":151,"_24":25,"_143":152,"_234":238,"_27":239},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":60,"_39":233,"_13":141,"_34":35,"_36":142,"_24":25,"_143":-5,"_234":235,"_27":236},["D",1787359474898],"children",[],[135],["D",1787732677441],[],[146],["D",1787359509276],[],[155],["D",1787215541674],[],[163],"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}",[],[170,247],"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}",[],[170,255],["D",1787359193118],[227,228],[170],"a398d47f-a66f-4db4-b2e6-d0cfda0604a4","router.ts","1d8cce16-9dc2-11f1-97c0-1607ee4eb77e","122c696e-9dc2-11f1-a094-1607ee4eb77e",146,["D",1787359722428],"import * as db from \"./database.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 ),\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 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(\"/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}",[],[177,274,266],"roda-putar","3468f62a-69ff-4b57-acce-76bf728fbbdc","database.ts","196e2c44-9dc2-11f1-b5b4-1607ee4eb77e",145,["D",1787359710783],"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) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"roda_sesi\")\n .insert({ bank_id: bankId, guru_id: guruId, nama_sesi: namaSesi, kelas })\n .select()\n .single();\n if (sesiError) throw sesiError;\n\n const timRows = timList.map((t, i) => ({\n sesi_id: sesi.id,\n nama_tim: t.nama,\n warna: t.warna,\n urutan: i + 1,\n }));\n const { data: timData, error: timError } = await supabase.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// ===== 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}",[],[177,274,276],"96f8658f-9d27-4802-8e90-13f6fc67dca9","play.ts","9b40a53a-9dc2-11f1-a6c9-1607ee4eb77e","89998a18-9dc2-11f1-8633-1607ee4eb77e",159,["D",1787363095177],4,"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}",[],[177,274,170,284],"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}",[],[177,274,170,294],"2f247fbb-8c0e-498f-9b65-2615302edf9b","dashboard.ts","8ec04144-9dc2-11f1-a56c-1607ee4eb77e",157,["D",1787363058539],"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}",[],[177,274,170,302],"e97daa62-78e9-44b2-97cb-dace918a7ce1",124,["D",1787359432574],[221,222,223],[177,274,170],"7db4471b-95fd-418e-b09c-ea20b8606e40",105,["D",1787359234169],[220,224,225],[177,274],"ed31d6f1-4a18-44d5-bba3-456891980328","d30dcc3a-a124-11f1-9b62-1607ee4eb77e","b55d2faa-a124-11f1-bd39-1607ee4eb77e",179,["D",1787731583867],"import * as db from \"./database.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/editor.ts\";\nimport { renderGamePlay } from \"./views/play.ts\";\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\nfunction html(content: string) {\n return new Response(content, { headers: { \"content-type\": \"text/html\" } });\n}\n\nexport async function 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 ),\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 return json(\n 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 } 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}",[],[177,327,266],"kuis-pilihan-ganda","dce2ad32-1ead-4e9d-8290-d222a6d7149f","cc8ee484-a124-11f1-aa00-1607ee4eb77e",178,["D",1787731570495],"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) {\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 })\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\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}",[],[177,327,276],"54df5d56-9ec1-4983-b1ce-d02a14b2b02f","f1a5de8a-a124-11f1-9824-1607ee4eb77e","de8fe9bc-a124-11f1-855b-1607ee4eb77e",182,["D",1787731649500],"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}",[],[177,327,170,284],"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}",[],[177,327,170,294],"e837b981-9098-44d6-8d77-732efc06c30b","e79ea48a-a124-11f1-9b62-1607ee4eb77e",230,["D",1787790684834],"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}",[],[177,327,170,302],"8ac6f20c-a813-48d0-9c67-e4748e4994d8",171,["D",1787731521991],[214,215,216],[177,327,170],"d4805971-2018-4197-b81e-24c3de19db20","d6100252-a126-11f1-9610-1607ee4eb77e","c806af76-a126-11f1-be47-1607ee4eb77e",227,["D",1787789991879],"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 const sesi = await db.createSesiPin(\n body.bankId,\n guruId,\n body.namaSesi,\n body.kelas,\n modeWaktu,\n waktuPerSoalDetik,\n waktuTotalMenit,\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 return null;\n}",[],[177,327,370,266],"olimpiade","3c14ca1f-6ebd-4b69-b172-9b8f7c9f15d8","d13d78b8-a126-11f1-9d87-1607ee4eb77e",226,["D",1787789973922],"import { supabase } from \"../../../supabase-client.ts\";\n\nfunction generatePin(): string {\n return String(Math.floor(100000 + Math.random() * 900000));\n}\n\n// Supabase kadang mengembalikan timestamp TANPA penanda zona (kolom \"timestamp\"\n// tanpa time zone, bukan \"timestamptz\"). Tanpa \"Z\"/offset di akhir string, JS\n// menafsirkannya sebagai waktu LOKAL server, bukan UTC — bisa meleset berjam-jam\n// dan membuat deadline dianggap sudah lewat padahal sesi baru saja dimulai.\n// Paksa selalu dibaca sebagai UTC kalau belum ada penanda zona.\nfunction msUtc(waktuIso: string): number {\n const adaZona = /Z$|[+-]\\d\\d:?\\d\\d$/.test(waktuIso);\n return new Date(adaZona ? waktuIso : waktuIso + \"Z\").getTime();\n}\n\n// ============================================================\n// 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) {\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 })\n .select()\n .single();\n if (error) throw error;\n return data;\n }\n throw new Error(\"Gagal membuat PIN unik, coba lagi.\");\n}\n\nexport async function 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 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\")\n .eq(\"id\", sesiPinId)\n .single();\n if (sesiError) throw sesiError;\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}",[],[177,327,370,276],"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}",[],[177,327,370,170,379],"71ae8538-4178-4d81-a46a-e29fe42702be","lobi.ts","76e9393c-a127-11f1-9e87-1607ee4eb77e",232,["D",1787790717581],5,"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}",[],[177,327,370,170,388],"41c5df31-f232-4b91-9a3a-4b0cf7c59888",["D",1787790993148],[],[177,327,370,170,33],"bb83ba6d-9021-4c93-8422-49957edba918","kerjakan.ts","72367f94-a127-11f1-b0cc-1607ee4eb77e",221,["D",1787789185428],7,"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}",[],[177,327,370,170,401],"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}",[],[177,327,370,170,410],"1dff0ab7-bbb0-4106-b0a5-4817970b9020",192,["D",1787732609304],[206,207,208,209,210],[177,327,370,170],"5c7f8555-6b4b-437b-a9cb-add4301036b7",184,["D",1787732341684],[205,211,212],[177,327,370],"6033e0a9-6939-4688-a9fb-489c5046a0d2",163,["D",1787731470891],[204,213,217,218],[177,327],"23391cfc-cc8f-4c67-8144-fe54c9aea795","ebe3c4c8-9dc1-11f1-a919-1607ee4eb77e","de507bbc-9dc1-11f1-97c0-1607ee4eb77e",138,["D",1787359607480],"import * as db from \"./database.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 ),\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 return json(\n await db.bukaKotak(\n sesiId,\n body.nomorKotak,\n body.timId ?? null,\n !!body.benar,\n body.poinDidapat ?? 0,\n ),\n );\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}",[],[177,440,266],"kuis-kotak","a8601f65-63ab-4eac-ac18-d25190386697","d70b4c24-9dc1-11f1-8727-1607ee4eb77e",137,["D",1787359595676],"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) {\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 })\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// ===== 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}",[],[177,440,276],"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}",[],[177,440,170,449],"3c3f3f81-ed2e-487b-9e80-548e80a5ac81","5d51443c-9dc2-11f1-b6ab-1607ee4eb77e",155,["D",1787363007980],"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}",[],[177,440,170,284],"f3a38356-caec-446f-bab0-c96aa8f01b7f","52c55b98-9dc2-11f1-b3e3-1607ee4eb77e",153,["D",1787362964340],"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}",[],[177,440,170,302],"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}",[],[177,440,170,472],"756d84b6-dcc6-492d-9d3e-624aa0d48694",114,["D",1787359329490],[197,198,199,200],[177,440,170],"8134dfe3-aee3-4e4f-995c-1cb59aea6ef2",92,["D",1787359148187],[196,201,202],[177,440],["D",1787359122388],[195,203,219],[177],["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":529,"_530":531,"_532":533,"_534":25,"_535":25,"_536":25,"_537":60,"_538":-5,"_539":-7,"_540":-7,"_541":64,"_542":25,"_543":25,"_544":-5,"_545":25,"_546":25,"_547":25,"_548":-5},"ENV",{"_500":501,"_502":503,"_504":88,"_505":506,"_507":508,"_509":510,"_511":512,"_513":514,"_515":516,"_517":518,"_519":520,"_521":522,"_523":524,"_525":526,"_527":528},"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 · v234