-- =====================================================
-- FIX ALFA ROLLBACK SCRIPT
-- Tanggal: 2026-01-12
-- Tujuan: Menghapus record ALFA yang salah terekap
-- =====================================================
-- 
-- INSTRUKSI:
-- 1. Jalankan STEP 1 dulu untuk melihat data yang akan dihapus
-- 2. Verifikasi outputnya benar (hanya record bukan XII-B)
-- 3. Jalankan STEP 2 untuk menghapus data
-- 4. Jalankan STEP 3 untuk verifikasi hasil
-- =====================================================

-- =====================================================
-- STEP 1: PREVIEW - Lihat data yang akan dihapus
-- Jalankan query ini PERTAMA untuk memastikan data benar
-- =====================================================
SELECT 
    class_name AS 'Kelas',
    COUNT(*) AS 'Jumlah Siswa'
FROM attendance 
WHERE date_str = '2026-01-12' 
  AND status = 'ALFA' 
  AND ai_verification = 'Otomatis dari Sistem'
  AND class_name != 'XII-B'
GROUP BY class_name
ORDER BY class_name;

-- =====================================================
-- STEP 2: HAPUS DATA - Jalankan setelah preview benar
-- =====================================================
DELETE FROM attendance 
WHERE date_str = '2026-01-12' 
  AND status = 'ALFA' 
  AND ai_verification = 'Otomatis dari Sistem'
  AND class_name != 'XII-B';

-- =====================================================
-- STEP 3: VERIFIKASI - Pastikan hanya XII-B tersisa
-- =====================================================
SELECT 
    class_name AS 'Kelas',
    COUNT(*) AS 'Jumlah ALFA Tersisa'
FROM attendance 
WHERE date_str = '2026-01-12' 
  AND status = 'ALFA'
GROUP BY class_name
ORDER BY class_name;