// Header CORS & JSON
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET, POST, OPTIONS");
header("Access-Control-Allow-Headers: Content-Type, Authorization, X-Requested-With");
header("Content-Type: application/json; charset=UTF-8");

if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    http_response_code(200);
    exit();
}

// Koneksi ke Database MySQL
$host = "localhost";
$user = "USERNAME_DB_KAMU";  // Sesuaikan dengan username DB cPanel kamu
$pass = "PASSWORD_DB_KAMU";  // Sesuaikan dengan password DB cPanel kamu
$db   = "NAMA_DB_KAMU";      // Sesuaikan dengan nama DB cPanel kamu

$conn = new mysqli($host, $user, $pass, $db);

if ($conn->connect_error) {
    http_response_code(500);
    echo json_encode(["status" => "error", "message" => "Koneksi gagal: " . $conn->connect_error]);
    exit();
}

// Query Ambil Semua Data Anggota
$sql = "SELECT * FROM anggota ORDER BY id ASC";
$result = $conn->query($sql);

$data = array();

if ($result && $result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $row['id']                = (int)$row['id'];
        $row['statusAktif']       = (int)$row['statusAktif'];
        $row['uang_kas']          = (float)($row['uang_kas'] ?? 0);
        $row['iuran_aniv']        = (float)($row['iuran_aniv'] ?? 0);
        $row['harga_barang']      = (float)($row['harga_barang'] ?? 0);
        $row['total_cicilan']     = (float)($row['total_cicilan'] ?? 0);
        $row['sisa_cicilan']      = (float)($row['sisa_cicilan'] ?? 0);
        $row['lamaCicilan']       = (int)($row['lamaCicilan'] ?? 0);
        $row['cicilan_per_bulan'] = (float)($row['cicilan_per_bulan'] ?? 0);

        $data[] = $row;
    }
}

echo json_encode([
    "status" => "success",
    "total"  => count($data),
    "data"   => $data
], JSON_UNESCAPED_UNICODE | JSON_NUMERIC_CHECK);

$conn->close();
?>