29 lines
1.4 KiB
PHP
29 lines
1.4 KiB
PHP
<?php
|
|
require_once __DIR__ . '/auth.php';
|
|
require_login(true);
|
|
|
|
$role = $_SESSION['role'];
|
|
$rows = [];
|
|
if ($role === 'super_admin') {
|
|
$sql = "SELECT p.*, ri.nama_rumah_ibadah FROM program_bantuan p LEFT JOIN rumah_ibadah ri ON ri.id=p.rumah_ibadah_id ORDER BY p.tahun DESC, p.bulan DESC, p.id DESC";
|
|
$res = $koneksi->query($sql);
|
|
while ($row = $res->fetch_assoc()) $rows[] = $row;
|
|
} elseif ($role === 'admin_rumah_ibadah') {
|
|
$ids = get_admin_rumah_ibadah_ids((int)$_SESSION['user_id'], true);
|
|
if (!empty($ids)) {
|
|
$types = '';
|
|
$params = [];
|
|
$in = build_in_condition('p.rumah_ibadah_id', $ids, $types, $params);
|
|
$stmt = $koneksi->prepare("SELECT p.*, ri.nama_rumah_ibadah FROM program_bantuan p LEFT JOIN rumah_ibadah ri ON ri.id=p.rumah_ibadah_id WHERE $in ORDER BY p.tahun DESC, p.bulan DESC, p.id DESC");
|
|
stmt_bind($stmt, $types, $params);
|
|
$rows = fetch_all_stmt($stmt);
|
|
}
|
|
} else {
|
|
$uid = (int) $_SESSION['user_id'];
|
|
$stmt = $koneksi->prepare("SELECT DISTINCT p.*, ri.nama_rumah_ibadah FROM program_bantuan p INNER JOIN penyaluran_bantuan pb ON pb.program_id=p.id INNER JOIN penerima_bantuan pr ON pr.id=pb.penerima_id LEFT JOIN rumah_ibadah ri ON ri.id=p.rumah_ibadah_id WHERE pr.user_id=? ORDER BY p.tahun DESC, p.bulan DESC, p.id DESC");
|
|
$stmt->bind_param('i', $uid);
|
|
$rows = fetch_all_stmt($stmt);
|
|
}
|
|
json_response('ok', 'Program bantuan berhasil diambil.', $rows);
|
|
?>
|