query("
SELECT
(SELECT COUNT(*) FROM penduduk WHERE status_ekonomi='miskin' AND status_hidup='hidup') AS miskin,
(SELECT COUNT(*) FROM penduduk WHERE status_ekonomi='rentan' AND status_hidup='hidup') AS rentan,
(SELECT COUNT(*) FROM penduduk WHERE status_hidup='hidup') AS total_pddk,
(SELECT COUNT(*) FROM keluarga) AS total_kk,
(SELECT COUNT(*) FROM rumah_ibadah) AS total_ri,
(SELECT COUNT(*) FROM laporan WHERE status='pending') AS laporan_pending,
(SELECT COUNT(*) FROM laporan WHERE tingkat_urgensi='darurat' AND status NOT IN ('selesai','ditolak')) AS laporan_darurat,
(SELECT COUNT(*) FROM histori_bantuan WHERE MONTH(tanggal)=MONTH(CURDATE()) AND YEAR(tanggal)=YEAR(CURDATE()) AND status_penyaluran='disalurkan') AS bantuan_bulan,
(SELECT COUNT(*) FROM penduduk WHERE status_hidup='hidup' AND status_ekonomi IN ('miskin','rentan')
AND NOT EXISTS(SELECT 1 FROM histori_bantuan hb WHERE hb.nik=penduduk.nik AND hb.status_penyaluran='disalurkan')
) AS belum_dibantu
")->fetch();
} catch(Exception $e) {}
// Laporan terbaru
$laporan_terbaru = [];
try {
$laporan_terbaru = $pdo->query("
SELECT l.id, l.tingkat_urgensi, l.kategori, l.status, l.created_at,
l.nama_pelapor, p.nama_lengkap AS nama_terdampak
FROM laporan l
LEFT JOIN penduduk p ON p.nik = l.nik_terdampak
ORDER BY
CASE l.tingkat_urgensi WHEN 'darurat' THEN 1 WHEN 'tinggi' THEN 2 ELSE 3 END,
l.created_at DESC
LIMIT 8
")->fetchAll();
} catch(Exception $e) {}
// Prioritas belum dibantu
$prioritas = [];
try {
$prioritas = $pdo->query("
SELECT p.nik, p.nama_lengkap, p.status_ekonomi, p.kondisi_kesehatan,
p.alamat, k.no_kk, ri.nama AS nama_ri
FROM penduduk p
LEFT JOIN keluarga k ON k.id=p.id_keluarga
LEFT JOIN rumah_ibadah ri ON ri.id=k.rumah_ibadah_id
WHERE p.status_hidup='hidup'
AND p.status_ekonomi='miskin'
AND p.kondisi_kesehatan IN ('sakit_parah','disabilitas')
AND NOT EXISTS(SELECT 1 FROM histori_bantuan hb WHERE hb.nik=p.nik AND hb.status_penyaluran='disalurkan')
ORDER BY CASE p.kondisi_kesehatan WHEN 'sakit_parah' THEN 1 ELSE 2 END
LIMIT 5
")->fetchAll();
} catch(Exception $e) {}
render_header('Dashboard');
?>
📊 Dashboard Monitoring
Warga Miskin
Warga Rentan
Total KK
Bantuan Bulan Ini
Laporan Pending
Belum Pernah Dibantu
0): ?>
🚨
LAPORAN DARURAT belum ditangani!
Segera tindak lanjuti laporan kondisi darurat dari masyarakat.