Masuk - Game Kelas Seru

\n \n\n`;\n}",[],[168,232],"be96af07-90a4-4ea5-8f24-53d7e8a9ab98","hub.ts","08121762-9dc2-11f1-be5f-1607ee4eb77e",161,["D",1787731346714],5,"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}",[],[168,240],["D",1787359193118],[212,213],[168],"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}",[],[175,260,252],"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}",[],[175,260,262],"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}",[],[175,260,168,270],"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}",[],[175,260,168,280],"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}",[],[175,260,168,288],"e97daa62-78e9-44b2-97cb-dace918a7ce1",124,["D",1787359432574],[206,207,208],[175,260,168],"7db4471b-95fd-418e-b09c-ea20b8606e40",105,["D",1787359234169],[205,209,210],[175,260],"440d1b3c-b63b-4b4b-9953-7bf2c5f64fd6","b55d2faa-a124-11f1-bd39-1607ee4eb77e",["D",1787731495687],[],[175,310,33],"kuis-pilihan-ganda","34806fbf-8374-46da-88e6-b53512eb7cab","cc8ee484-a124-11f1-aa00-1607ee4eb77e",167,["D",1787731492994],[],[175,310,262],"6033e0a9-6939-4688-a9fb-489c5046a0d2",163,["D",1787731470891],[202,203],[175,310],"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}",[],[175,330,252],"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}",[],[175,330,262],"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}",[],[175,330,168,339],"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}",[],[175,330,168,270],"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}",[],[175,330,168,288],"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}",[],[175,330,168,362],"756d84b6-dcc6-492d-9d3e-624aa0d48694",114,["D",1787359329490],[195,196,197,198],[175,330,168],"8134dfe3-aee3-4e4f-995c-1cb59aea6ef2",92,["D",1787359148187],[194,199,200],[175,330],["D",1787359122388],[193,201,204],[175],["D",1787214292968],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":54,"_101":102,"_103":24},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":45,"_94":95},"ctx",{"_78":-5,"_123":419,"_420":421,"_422":423,"_424":24,"_425":24,"_426":24,"_427":58,"_428":-5,"_429":-7,"_430":-7,"_431":62,"_432":24,"_433":24,"_434":-5,"_435":24,"_436":24,"_437":24,"_438":-5},"ENV",{"_390":391,"_392":393,"_394":86,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414,"_415":416,"_417":418},"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 · v168