alert("Terjadi kesalahan, harap masuk kembali!");
window.location.replace("' . $alamat_admin . 'keluar.php");
';
}
// Query untuk mendapatkan data jumlah deposit
$deposit = mysqli_query($koneksi, "SELECT SUM(jumlah_deposit) AS total_jumlah_deposit FROM deposit");
$data_deposit = mysqli_fetch_array($deposit);
$total_jumlah_deposit = $data_deposit['total_jumlah_deposit'];
if ($total_jumlah_deposit == 0) {
$total_jumlah_deposit = 0;
}
// Query untuk mendapatkan data jumlah withdraw
$withdraw = mysqli_query($koneksi, "SELECT SUM(jumlah_withdraw) AS total_jumlah_withdraw FROM withdraw");
$data_withdraw = mysqli_fetch_array($withdraw);
$total_jumlah_withdraw = $data_withdraw['total_jumlah_withdraw'];
if ($total_jumlah_withdraw == 0) {
$total_jumlah_withdraw = 0;
}
// Query untuk mendapatkan jumlah anggota
$anggota = mysqli_query($koneksi, "SELECT * FROM anggota");
$jumlah_anggota = mysqli_num_rows($anggota);
// Query untuk mendapatkan jumlah promosi
$promosi = mysqli_query($koneksi, "SELECT * FROM promosi");
$jumlah_promosi = mysqli_num_rows($promosi);
// Query untuk mendapatkan jumlah staff
$staff = mysqli_query($koneksi, "SELECT * FROM staff");
$jumlah_staff = mysqli_num_rows($staff);
// Simpan jumlah saat ini ke dalam session
$_SESSION['lastDepositCount'] = $total_jumlah_deposit;
$_SESSION['lastWithdrawCount'] = $total_jumlah_withdraw;
$_SESSION['lastAnggotaCount'] = $jumlah_anggota;
$_SESSION['lastPromosiCount'] = $jumlah_promosi;
$_SESSION['lastStaffCount'] = $jumlah_staff;
?>
Dasbor
Jam
Deposit
Withdraw
Anggota
Promosi
Staff
Queued Deposit
No.
Kode
UserName
Tujuan
Bonus
Jumlah
Tanggal
Status
Aksi
Queued Withdraw
No.
Kode
Username
Jumlah
Tanggal
Status
Aksi
0) {
// Tampilkan data withdraw
while ($data_withdraw = mysqli_fetch_assoc($query_withdraw_diproses)) {
$id_withdraw = $data_withdraw['id_withdraw'];
$id_anggota_withdraw = $data_withdraw['id_anggota_withdraw'];
$kode_withdraw = $data_withdraw['kode_withdraw'];
$tujuan_withdraw = $data_withdraw['tujuan_withdraw'];
$jumlah_withdraw = $data_withdraw['jumlah_withdraw'];
$tanggal_withdraw = $data_withdraw['tanggal_withdraw'];
$status_withdraw = $data_withdraw['status_withdraw'];
// Ambil nama pengguna anggota withdraw
$anggota_withdraw = mysqli_query($koneksi, "SELECT * FROM anggota WHERE id_anggota = '$id_anggota_withdraw'");
if (!$anggota_withdraw) {
die("Query failed: " . mysqli_error($koneksi));
}
if (mysqli_num_rows($anggota_withdraw) == 0) {
$nama_pengguna_anggota_withdraw = "Data anggota tidak ada atau telah dihapus";
} else {
$data_anggota_withdraw = mysqli_fetch_assoc($anggota_withdraw);
$nama_pengguna_anggota_withdraw = $data_anggota_withdraw['nama_pengguna_anggota'];
}
// Tentukan kelas status untuk warna latar belakang
switch ($status_withdraw) {
case 'diproses':
$status_class = 'text-warning';
break;
case 'dibatalkan':
$status_class = 'text-danger';
break;
case 'disetujui':
$status_class = 'text-success';
break;
default:
$status_class = '';
break;
}
?>