<?php
// php/read_bantuan.php
require_once 'koneksi.php';
header('Content-Type: application/json; charset=utf-8');

$kemiskinanId = intval($_GET['kemiskinan_id'] ?? 0);
if (!$kemiskinanId) { echo json_encode([]); exit; }

$esc = fn($v) => mysqli_real_escape_string($conn, (string)$v);

$sql = "SELECT hb.*, m.nama_masjid,
            DATE_FORMAT(hb.tanggal_bantuan, '%d/%m/%Y') AS tanggal_fmt,
            DATE_FORMAT(hb.periode_berikutnya, '%d/%m/%Y') AS periode_fmt,
            CASE WHEN hb.periode_berikutnya IS NOT NULL AND hb.periode_berikutnya <= CURDATE() AND hb.status_penyaluran = 'belum' THEN 1 ELSE 0 END AS jatuh_tempo
        FROM histori_bantuan hb
        LEFT JOIN masjid m ON hb.masjid_id = m.id
        WHERE hb.kemiskinan_id = {$kemiskinanId}
        ORDER BY hb.tanggal_bantuan DESC";

$result = mysqli_query($conn, $sql);
$data = [];
if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        $data[] = $row;
    }
}
echo json_encode($data);
?>