<?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);
?>