Mr.Haruna
41 lines
1.6 KiB
PHP
41 lines
1.6 KiB
PHP
<?php
|
|
/**
|
|
* api/komparatif.php — Indikator komparatif antar kelurahan (KF-31).
|
|
* GET → labels + dataset: persentase_miskin, cakupan_bantuan, jumlah_miskin, persen_verifikasi.
|
|
*/
|
|
require_once __DIR__ . '/../config/db.php';
|
|
require_once __DIR__ . '/helpers.php';
|
|
|
|
$pdo = Database::getConnection();
|
|
requireApiAnyRole(['operator', 'pimpinan']);
|
|
if ($_SERVER['REQUEST_METHOD'] !== 'GET') sendError('Method not allowed', 405);
|
|
|
|
$rows = $pdo->query("
|
|
SELECT w.nama, w.jumlah_penduduk,
|
|
COUNT(DISTINCT wm.id) AS miskin,
|
|
COUNT(DISTINCT CASE WHEN bs.id IS NOT NULL THEN wm.id END) AS dibantu,
|
|
COUNT(DISTINCT CASE WHEN wm.status_verifikasi='terverifikasi' THEN wm.id END) AS terverif
|
|
FROM wilayah w
|
|
LEFT JOIN warga_miskin wm ON ST_Contains(w.geom, wm.geom)
|
|
LEFT JOIN bantuan_sosial bs ON bs.warga_id = wm.id AND bs.is_aktif=1
|
|
GROUP BY w.id ORDER BY w.nama
|
|
")->fetchAll();
|
|
|
|
$labels = []; $persenMiskin = []; $cakupan = []; $jumlahMiskin = []; $persenVerif = [];
|
|
foreach ($rows as $r) {
|
|
$miskin = (int)$r['miskin']; $penduduk = (int)$r['jumlah_penduduk'];
|
|
$labels[] = $r['nama'];
|
|
$persenMiskin[] = $penduduk > 0 ? round($miskin / $penduduk * 100, 2) : 0;
|
|
$cakupan[] = $miskin > 0 ? round($r['dibantu'] / $miskin * 100, 1) : 0;
|
|
$jumlahMiskin[] = $miskin;
|
|
$persenVerif[] = $miskin > 0 ? round($r['terverif'] / $miskin * 100, 1) : 0;
|
|
}
|
|
|
|
sendSuccess([
|
|
'labels' => $labels,
|
|
'persentase_miskin' => $persenMiskin,
|
|
'cakupan_bantuan' => $cakupan,
|
|
'jumlah_miskin' => $jumlahMiskin,
|
|
'persen_verifikasi' => $persenVerif,
|
|
], 'Komparatif Wilayah');
|