Rekap Skor - Game Kelas Seru

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_96":95,"_32":45,"_105":86,"_27":53,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",35,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","d6b97946-9c70-11f1-8f5e-1607ee4eb77e","name","fileType","http","content","import { verifySession } from \"./auth.ts\"; // sesuaikan path/nama sesuai auth.ts yang sudah ada\nimport * as db from \"./database.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/bank-editor.ts\";\nimport { renderGamePlay } from \"./views/game-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}\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 const session = await verifySession(req);\n if (!session) {\n return new Response(\"Unauthorized. Silakan login dulu.\", { status: 401 });\n }\n const guruId = session.guruId;\n\n // ===== HALAMAN (HTML) =====\n if (method === \"GET\" && path === \"/\") {\n return new Response(await renderDashboard(guruId), { headers: { \"content-type\": \"text/html\" } });\n }\n if (method === \"GET\" && path.startsWith(\"/bank/\") && path.endsWith(\"/edit\")) {\n const bankId = path.split(\"/\")[2];\n return new Response(await renderBankEditor(bankId), { headers: { \"content-type\": \"text/html\" } });\n }\n if (method === \"GET\" && path.startsWith(\"/main/\")) {\n const sesiId = path.split(\"/\")[2];\n return new Response(await renderGamePlay(sesiId), { headers: { \"content-type\": \"text/html\" } });\n }\n if (method === \"GET\" && path === \"/rekap\") {\n return new Response(await renderRekap(guruId), { headers: { \"content-type\": \"text/html\" } });\n }\n\n // ===== API: BANK SOAL =====\n if (method === \"GET\" && path === \"/api/bank\") {\n return json(await db.getBankSoalList(guruId));\n }\n if (method === \"POST\" && path === \"/api/bank\") {\n const body = await req.json();\n return json(await db.createBankSoal(guruId, body.namaBank, body.mapel, body.kelas));\n }\n if (method === \"DELETE\" && path.startsWith(\"/api/bank/\")) {\n const bankId = path.split(\"/\")[3];\n await db.deleteBankSoal(bankId);\n return json({ ok: true });\n }\n\n // ===== API: SOAL =====\n if (method === \"GET\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")) {\n const bankId = path.split(\"/\")[3];\n return json(await db.getSoalByBank(bankId));\n }\n if (method === \"POST\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")) {\n const bankId = path.split(\"/\")[3];\n const body = await req.json();\n return json(\n await db.upsertSoal(bankId, body.nomorKotak, body.pertanyaan, body.jawaban, body.poin, body.gambarUrl),\n );\n }\n\n // ===== API: SESI =====\n if (method === \"POST\" && path === \"/api/sesi\") {\n const body = await req.json();\n return json(\n await db.createSesi(body.bankId, guruId, body.namaSesi, body.kelas, body.modePembukaan, body.timList),\n );\n }\n if (method === \"GET\" && path.startsWith(\"/api/sesi/\")) {\n const sesiId = path.split(\"/\")[3];\n return json(await db.getSesiDetail(sesiId));\n }\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/kotak\")) {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n return json(await db.bukaKotak(sesiId, body.nomorKotak, body.timId, body.benar, body.poinDidapat));\n }\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/giliran\")) {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n await db.updateGiliran(sesiId, body.giliranBaru);\n return json({ ok: true });\n }\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/selesai\")) {\n const sesiId = path.split(\"/\")[3];\n await db.selesaikanSesi(sesiId);\n return json({ ok: true });\n }\n\n // ===== API: REKAP =====\n if (method === \"GET\" && path === \"/api/rekap\") {\n const kelas = url.searchParams.get(\"kelas\") ?? undefined;\n return json(await db.getRekapByKelas(guruId, kelas));\n }\n\n return new Response(\"Not found\", { status: 404 });\n}","import {\n verifySession,\n createSessionToken,\n hashPassword,\n generateSalt,\n sessionCookie,\n clearSessionCookie,\n} from \"./auth.ts\";\nimport * as db from \"./database.ts\";\nimport { renderLogin } from \"./views/login.ts\";\nimport { renderDashboard } from \"./views/dashboard.ts\";\nimport { renderBankEditor } from \"./views/bank-editor.ts\";\nimport { renderGamePlay } from \"./views/game-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}\n\nfunction html(content: string, extraHeaders: Record = {}) {\n return new Response(content, {\n headers: { \"content-type\": \"text/html\", ...extraHeaders },\n });\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 ROUTES (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 db.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 db.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 db.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 // ===== 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, { status: 302, headers: { location: \"/login\" } });\n }\n return json({ error: \"Unauthorized\" }, 401);\n }\n const guruId = session.guruId;\n\n // ============================================================\n // ===== HALAMAN (HTML) =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/\") {\n return html(await renderDashboard(guruId));\n }\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\n if (method === \"GET\" && path.startsWith(\"/main/\")) {\n const sesiId = path.split(\"/\")[2];\n return html(await renderGamePlay(sesiId));\n }\n\n if (method === \"GET\" && path === \"/rekap\") {\n return html(await renderRekap(guruId));\n }\n\n // ============================================================\n // ===== API: BANK SOAL =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/api/bank\") {\n try {\n const data = await db.getBankSoalList(guruId);\n return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path === \"/api/bank\") {\n try {\n const body = await req.json();\n if (!body.namaBank) return json({ error: \"Nama bank soal wajib diisi\" }, 400);\n const data = await db.createBankSoal(guruId, body.namaBank, body.mapel, body.kelas);\n return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"DELETE\" && path.startsWith(\"/api/bank/\") && path.split(\"/\").length === 4) {\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 // ============================================================\n // ===== API: SOAL (16 per bank) =====\n // ============================================================\n\n if (method === \"GET\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")) {\n try {\n const bankId = path.split(\"/\")[3];\n const data = await db.getSoalByBank(bankId);\n return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/bank/\") && path.endsWith(\"/soal\")) {\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 const data = await db.upsertSoal(\n bankId,\n body.nomorKotak,\n body.pertanyaan,\n body.jawaban,\n body.poin ?? 10,\n body.gambarUrl,\n );\n return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== API: SESI GAME =====\n // ============================================================\n\n if (method === \"POST\" && path === \"/api/sesi\") {\n try {\n const body = await req.json();\n if (!body.bankId || !body.namaSesi || !Array.isArray(body.timList) || body.timList.length !== 4) {\n return json({ error: \"Data sesi tidak lengkap (perlu bankId, namaSesi, dan 4 tim)\" }, 400);\n }\n const data = 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 return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"GET\" && path.startsWith(\"/api/sesi/\") && path.split(\"/\").length === 4) {\n try {\n const sesiId = path.split(\"/\")[3];\n const data = await db.getSesiDetail(sesiId);\n return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/kotak\")) {\n try {\n const sesiId = path.split(\"/\")[3];\n const body = await req.json();\n if (!body.nomorKotak) return json({ error: \"Nomor kotak wajib diisi\" }, 400);\n const data = await db.bukaKotak(\n sesiId,\n body.nomorKotak,\n body.timId ?? null,\n !!body.benar,\n body.poinDidapat ?? 0,\n );\n return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/giliran\")) {\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\n if (method === \"POST\" && path.startsWith(\"/api/sesi/\") && path.endsWith(\"/selesai\")) {\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 // ============================================================\n // ===== API: REKAP =====\n // ============================================================\n\n if (method === \"GET\" && path === \"/api/rekap\") {\n try {\n const kelas = url.searchParams.get(\"kelas\") ?? undefined;\n const data = await db.getRekapByKelas(guruId, kelas);\n return json(data);\n } catch (e) {\n return json({ error: (e as Error).message }, 500);\n }\n }\n\n // ============================================================\n // ===== 404 =====\n // ============================================================\n\n return new Response(\"Not found\", { status: 404 });\n}","createdAt",["D",1787215751072],"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","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",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"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",{"_43":44,"_32":45,"_38":235,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":236,"_80":237,"_82":238,"_84":25},"tree",[173,179,180,181],"files",[173,174,175,176,177,178,179,180,181],"counts",{"_163":62,"_164":160,"_165":62,"_166":167,"_168":169},"contents",[126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":155,"_32":156,"_30":157,"_131":-5,"_41":42,"_40":158,"_132":25,"_38":159,"_13":160,"_33":161,"_35":-5,"_24":25,"_135":-5,"_27":162},{"_43":147,"_32":148,"_30":149,"_131":-5,"_41":42,"_40":150,"_132":58,"_38":151,"_13":152,"_33":144,"_35":153,"_24":25,"_135":-5,"_27":154},{"_43":138,"_32":139,"_30":140,"_131":-5,"_41":42,"_40":141,"_132":25,"_38":142,"_13":143,"_33":144,"_35":145,"_24":25,"_135":-5,"_27":146},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":136,"_27":137},"0c872e06-4100-4654-a23e-d7ac44acccc2","parentId","latest",["D",1787215751072],6,"label","gameskelas",[28],"46d127e8-2f45-424b-896a-e49e0cc1dd75","database.ts","9e39efba-9c70-11f1-919b-1607ee4eb77e",28,["D",1787215564676],3,"script","import { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nconst supabase = createClient(\n Deno.env.get(\"SUPABASE_URL\")!,\n Deno.env.get(\"SUPABASE_SERVICE_KEY\")!,\n);\n\n// ===== BANK SOAL =====\n\nexport async function getBankSoalList(guruId: string) {\n const { data, error } = await supabase\n .from(\"game_bank_soal\")\n .select(\"*\")\n .eq(\"guru_id\", guruId)\n .order(\"created_at\", { ascending: false });\n if (error) throw error;\n return data;\n}\n\nexport async function createBankSoal(guruId: string, namaBank: string, mapel: string, kelas: string) {\n const { data, error } = await supabase\n .from(\"game_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 deleteBankSoal(bankId: string) {\n const { error } = await supabase.from(\"game_bank_soal\").delete().eq(\"id\", bankId);\n if (error) throw error;\n}\n\n// ===== SOAL (16 per bank) =====\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(bankId: string, nomorKotak: number, pertanyaan: string, jawaban: string, poin: number, gambarUrl?: string) {\n const { data, error } = await supabase\n .from(\"game_soal\")\n .upsert(\n { bank_id: bankId, nomor_kotak: nomorKotak, pertanyaan, jawaban, poin, gambar_url: gambarUrl ?? null },\n { onConflict: \"bank_id,nomor_kotak\" },\n )\n .select()\n .single();\n if (error) throw error;\n return data;\n}\n\n// ===== SESI GAME =====\n\nexport async function createSesi(bankId: string, guruId: string, namaSesi: string, kelas: string, modePembukaan: \"bebas\" | \"urut\", timList: { nama: string; warna: string }[]) {\n const { data: sesi, error: sesiError } = await supabase\n .from(\"game_sesi\")\n .insert({ bank_id: bankId, guru_id: guruId, nama_sesi: namaSesi, kelas, mode_pembukaan: modePembukaan })\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\").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\").select(\"*\").eq(\"id\", sesiId).single();\n if (sesiError) throw sesiError;\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 { sesi, soal, tim, kotakTerpakai };\n}\n\nexport async function bukaKotak(sesiId: string, nomorKotak: number, timId: string | null, benar: boolean, poinDidapat: number) {\n const { data, error } = await supabase\n .from(\"game_kotak_terpakai\")\n .insert({ sesi_id: sesiId, nomor_kotak: nomorKotak, tim_menjawab_id: timId, benar, poin_didapat: poinDidapat })\n .select()\n .single();\n if (error) throw error;\n\n if (timId && benar) {\n const { error: skorError } = await supabase.rpc(\"increment_skor_tim\", { tim_id: timId, jumlah: poinDidapat });\n if (skorError) {\n // fallback jika belum ada RPC function, update manual\n const { data: timSekarang } = await supabase.from(\"game_tim\").select(\"skor\").eq(\"id\", timId).single();\n await supabase.from(\"game_tim\").update({ skor: (timSekarang?.skor ?? 0) + poinDidapat }).eq(\"id\", timId);\n }\n }\n\n return data;\n}\n\nexport async function updateGiliran(sesiId: string, giliranBaru: number) {\n const { error } = await supabase.from(\"game_sesi\").update({ giliran_tim_index: giliranBaru }).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}\nexport async function getGuruByEmail(email: string) {\n const { data, error } = await supabase.from(\"game_guru\").select(\"*\").eq(\"email\", email).maybeSingle();\n if (error) throw error;\n return data;\n}\n\nexport async function createGuru(email: string, passwordHash: string, salt: string, nama: string) {\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}",[139],"34e0f9f7-2329-4657-a5ca-cb990c59951d","auth.ts","6e8ebe28-9c73-11f1-a8b3-1607ee4eb77e",27,["D",1787215541674],2,"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}",[148],"7b44ad0f-b022-46e7-9020-70a0fff5a3e5","views","db30d974-9c70-11f1-99e7-1607ee4eb77e",7,["D",1787214400525],1,"directory",[156],"pulls","branches","forks","envVars",{"_170":134,"_172":62},"connections",{"_170":62,"_171":62},"count","unfilledCount","emptyCount",{"_43":155,"_32":156,"_30":157,"_131":-5,"_41":42,"_40":158,"_132":25,"_38":232,"_13":160,"_33":161,"_35":-5,"_24":25,"_135":-5,"_183":233,"_27":234},{"_43":224,"_32":225,"_30":226,"_131":157,"_41":42,"_40":227,"_132":25,"_38":228,"_13":143,"_33":144,"_35":229,"_24":25,"_135":-5,"_183":230,"_27":231},{"_43":216,"_32":217,"_30":218,"_131":157,"_41":42,"_40":219,"_132":25,"_38":220,"_13":152,"_33":144,"_35":221,"_24":25,"_135":-5,"_183":222,"_27":223},{"_43":208,"_32":209,"_30":210,"_131":157,"_41":42,"_40":211,"_132":25,"_38":212,"_13":152,"_33":144,"_35":213,"_24":25,"_135":-5,"_183":214,"_27":215},{"_43":200,"_32":201,"_30":202,"_131":157,"_41":42,"_40":203,"_132":25,"_38":204,"_13":143,"_33":144,"_35":205,"_24":25,"_135":-5,"_183":206,"_27":207},{"_43":192,"_32":193,"_30":194,"_131":157,"_41":42,"_40":195,"_132":25,"_38":196,"_13":152,"_33":144,"_35":197,"_24":25,"_135":-5,"_183":198,"_27":199},{"_43":147,"_32":148,"_30":149,"_131":-5,"_41":42,"_40":150,"_132":58,"_38":189,"_13":152,"_33":144,"_35":153,"_24":25,"_135":-5,"_183":190,"_27":191},{"_43":138,"_32":139,"_30":140,"_131":-5,"_41":42,"_40":141,"_132":25,"_38":186,"_13":143,"_33":144,"_35":145,"_24":25,"_135":-5,"_183":187,"_27":188},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":182,"_13":134,"_33":34,"_35":37,"_24":25,"_135":136,"_183":184,"_27":185},["D",1787215751072],"children",[],[28],["D",1787215564676],[],[139],["D",1787215541674],[],[148],"194159eb-a381-4f70-a185-f0d997367b26","rekap.ts","f2b705d2-9c70-11f1-9871-1607ee4eb77e",23,["D",1787214998098],"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}",[],[156,193],"fb5801af-5909-47c4-a5a2-ea9a0262a199","login.ts","99378a2e-9c73-11f1-8a8f-1607ee4eb77e",32,["D",1787215599881],"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}",[],[156,201],"77adee0b-b89c-481e-bd68-0b1d94909a6d","game-play.ts","ebc62988-9c70-11f1-9d7c-1607ee4eb77e",22,["D",1787214983658],"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}",[],[156,209],"1ef22419-f84e-445d-a5a6-e90bc344a6c5","dashboard.ts","e0ade338-9c70-11f1-8f5e-1607ee4eb77e",20,["D",1787214938905],"export async function renderDashboard(guruId: string): Promise {\n return `\n\n\n \n \n Game Kelas Seru\n \n \n \n \n \n \n\n\n

\n \n\n`;\n}",[],[156,217],"3a0c2789-8b61-4e04-99aa-73741f48ae4b","bank-editor.ts","e6d321b0-9c70-11f1-aa3d-1607ee4eb77e",21,["D",1787214956879],"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}",[],[156,225],["D",1787214400525],[174,175,176,177,178],[156],["D",1787214292968],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":272,"_273":274,"_275":276,"_277":25,"_278":25,"_279":25,"_280":58,"_281":-5,"_282":-7,"_283":-7,"_284":62,"_285":25,"_286":25,"_287":-5,"_288":25,"_289":25,"_290":25,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":86,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v35