alert("Terjadi kesalahan, harap masuk kembali!");
window.location.replace("' . $alamat_admin . 'keluar.php");
';
exit();
}
// --- LOGIKA HITUNG DEPOSIT ---
$deposit = mysqli_query($koneksi, "SELECT SUM(jumlah) AS total_jumlah_deposit FROM tb_deposit where status = 'Sukses'");
$data_deposit = mysqli_fetch_array($deposit);
$total_jumlah_deposit = $data_deposit['total_jumlah_deposit'] ?? 0;
$deposit_hari_ini = mysqli_query($koneksi, "
SELECT COALESCE(SUM(jumlah), 0) AS total_jumlah_deposit
FROM tb_deposit
WHERE status = 'Sukses'
AND DATE(created_at) = CURDATE()
");
$data_deposit_hari_ini = mysqli_fetch_assoc($deposit_hari_ini);
$total_jumlah_deposit_hari_ini = $data_deposit_hari_ini['total_jumlah_deposit'];
// --- LOGIKA HITUNG WITHDRAW ---
$wd_hari_ini = mysqli_query($koneksi, "
SELECT COALESCE(SUM(jumlah), 0) AS total_jumlah_wd
FROM tb_withdraw
WHERE status = 'Sukses'
AND DATE(created_at) = CURDATE()
");
$data_wd_hari_ini = mysqli_fetch_assoc($wd_hari_ini);
$total_jumlah_wd_hari_ini = $data_wd_hari_ini['total_jumlah_wd'];
$withdraw = mysqli_query($koneksi, "SELECT SUM(jumlah) AS total_jumlah_withdraw FROM tb_withdraw where status = 'Sukses'");
$data_withdraw = mysqli_fetch_array($withdraw);
$total_jumlah_withdraw = $data_withdraw['total_jumlah_withdraw'] ?? 0;
// --- LOGIKA DATA ANGGOTA & STAFF ---
$anggota = mysqli_query($koneksi, "SELECT * FROM tb_user");
$jumlah_anggota = mysqli_num_rows($anggota);
$anggotaharini = mysqli_query($koneksi, "SELECT * FROM tb_user WHERE DATE(created_at) = CURDATE()");
$jumlah_anggota_harini = mysqli_num_rows($anggotaharini);
$promosi = mysqli_query($koneksi, "SELECT * FROM promosi");
$jumlah_promosi = mysqli_num_rows($promosi);
$staff = mysqli_query($koneksi, "SELECT * FROM staff");
$jumlah_staff = mysqli_num_rows($staff);
$_SESSION['lastDepositCount'] = $total_jumlah_deposit;
$_SESSION['lastWithdrawCount'] = $total_jumlah_withdraw;
$_SESSION['lastAnggotaCount'] = $jumlah_anggota;
$_SESSION['lastPromosiCount'] = $jumlah_promosi;
$_SESSION['lastStaffCount'] = $jumlah_staff;
// =========================================================================
// AMBIL DATA KONEKSI API AGENT (TOLERAN JIKA SALAH SATU OFFLINE)
// =========================================================================
$balanceAgentRaw = $nx->info_agent();
$balanceAgentsgxRaw = $SGX->info_agent();
$balanceAgent = is_string($balanceAgentRaw) ? json_decode($balanceAgentRaw, true) : $balanceAgentRaw;
$balanceAgentsgx = is_string($balanceAgentsgxRaw) ? json_decode($balanceAgentsgxRaw, true) : $balanceAgentsgxRaw;
// Deteksi kelancaran koneksi masing-masing API
$api_nexus_connected = (isset($balanceAgent['status']) && $balanceAgent['status'] == 1);
$api_sgx_connected = (isset($balanceAgentsgx['status']) && $balanceAgentsgx['status'] == 200);
// Set saldo ke 0 jika API yang bersangkutan tidak merespon/terputus
$balance = $api_nexus_connected ? ($balanceAgent['agent']['balance'] ?? 0) : 0;
$balance2 = $api_sgx_connected ? ($balanceAgentsgx['data']['balance'] ?? 0) : 0;
$formatted_balance = number_format($balance, 0, ',', '.');
$formatted_balance2 = number_format($balance2, 0, ',', '.');
// =========================================================================
?>
Dashboard Admin
Dashboard
Jam
⚠️ INFORMASI API PROVIDER
Halaman tetap dibuka menggunakan jalur API Nexus yang aktif.
• API NEXUS (NXS): TERHUBUNG
• API SGX: TERPUTUS / OFFLINE (Saldo SGX sementara ditampilkan Rp. 0)