29 lines
980 B
PHP
29 lines
980 B
PHP
<?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);
|
|
?>
|