1, 'tasydid' => 2, 'keduanya' => 3, 'ghunnah' => 4, 'qalqalah' => 5]; $catId = $catIdMap[$catType] ?? 1; if ($arabic && $latin) { $stmt = $pdo->prepare("INSERT INTO words (category_id, category_type, arabic, html_highlight, latin, arti, normalized, tip, surah_ref, difficulty, audio_url, is_active) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1)"); $stmt->execute([$catId, $catType, $arabic, $arabic, $latin, $arti, $normalized, $tip, $surahRef, $difficulty, $audioUrl ?: null]); $message = "Kata tajwid [{$arabic}] berhasil ditambahkan ke bank soal!"; $messageType = "success"; } else { $message = "Teks Arab dan Latin wajib diisi."; $messageType = "error"; } } // 2. Hapus Kata if (isset($_POST['action_delete_word'])) { $wordId = (int)$_POST['word_id']; if ($wordId > 0) { $stmt = $pdo->prepare("DELETE FROM words WHERE id = ?"); $stmt->execute([$wordId]); $message = "Kata tajwid berhasil dihapus."; $messageType = "success"; } } // 3. Hapus Satu Skor Siswa if (isset($_POST['action_delete_score'])) { $scoreId = (int)$_POST['score_id']; if ($scoreId > 0) { $stmt = $pdo->prepare("DELETE FROM scores WHERE id = ?"); $stmt->execute([$scoreId]); $message = "Data skor siswa ID #{$scoreId} berhasil dihapus."; $messageType = "success"; } } // 4. Reset Seluruh Papan Skor if (isset($_POST['action_reset_all_scores'])) { $pdo->exec("TRUNCATE TABLE scores"); $message = "Seluruh riwayat papan skor santri berhasil dikosongkan!"; $messageType = "success"; } } // Data untuk Tampilan Dashboard $wordsList = []; $scoresList = []; $stats = ['total_words' => 0, 'total_scores' => 0, 'avg_score' => 0, 'max_score' => 0]; if ($isLoggedIn && $pdo) { // Ambil Data Kata $wordsStmt = $pdo->query("SELECT * FROM words ORDER BY id DESC"); $wordsList = $wordsStmt->fetchAll(); // Ambil Data Skor $scoresStmt = $pdo->query("SELECT * FROM scores ORDER BY total_score DESC, created_at DESC LIMIT 100"); $scoresList = $scoresStmt->fetchAll(); // Statistik $wCount = $pdo->query("SELECT COUNT(*) FROM words")->fetchColumn(); $sStats = $pdo->query("SELECT COUNT(*) as cnt, AVG(total_score) as avg_sc, MAX(total_score) as max_sc FROM scores")->fetch(); $stats['total_words'] = (int)$wCount; $stats['total_scores'] = (int)($sStats['cnt'] ?? 0); $stats['avg_score'] = round((float)($sStats['avg_sc'] ?? 0), 1); $stats['max_score'] = (int)($sStats['max_sc'] ?? 0); } ?> Pengelola Soal & Papan Skor BTQ — Guru / Admin
Panel Guru BTQ
Kelola Bank Soal Tajwid & Papan Skor Siswa
🏠 Halaman Siswa 🎙️ Latihan Ucap Keluar

🔐 Masuk Ruang Guru / Admin

Masukkan PIN atau Password untuk mengelola bank soal dan membersihkan papan skor.

Total Kata Soal
Santri Selesai Latihan
Rata-Rata Skor
Skor Tertinggi
➕ Tambah Kosakata Tajwid Baru
📚 Daftar Kosakata Tajwid Aktif ( Kata)
$w): ?>
No Teks Arab Latin & Arti Hukum Tajwid Tips Pelafalan Audio Suara Aksi
Belum ada kata di database. Silakan tambahkan di atas.