alert("Terjadi kesalahan, harap masuk kembali!"); window.location.replace("' . $alamat_admin . 'keluar.php"); '; } $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']; if ($total_jumlah_deposit == 0) { $total_jumlah_deposit = 0; } //date_default_timezone_set('Asia/Jakarta'); $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']; $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']; /*echo "Waktu PHP: " . date('Y-m-d H:i:s'); $cek_waktu_mysql = mysqli_query($koneksi, "SELECT NOW() AS waktu_mysql"); $row = mysqli_fetch_assoc($cek_waktu_mysql); echo "Waktu MySQL: " . $row['waktu_mysql'];*/ // Query untuk mendapatkan data jumlah withdraw $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']; if ($total_jumlah_withdraw == 0) { $total_jumlah_withdraw = 0; } $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; $balanceAgent = $nx->info_agent(); $balanceAgentsgx = $SGX->info_agent(); if (is_string($balanceAgent)) { $balanceAgent = json_decode($balanceAgent, true); $balanceAgentsgx = json_decode($balanceAgentsgx, true); } if ($balanceAgent && isset($balanceAgent['status']) && $balanceAgent['status'] == 1) { $balance = isset($balanceAgent['agent']['balance']) ? $balanceAgent['agent']['balance'] : 0; // Cek jika 'agent_balance' ada $balance2 = isset($balanceAgentsgx['data']['balance']) ? $balanceAgentsgx['data']['balance'] : 0; // Cek jika 'agent_balance' ada $currency = isset($balanceAgent['currency']) ? $balanceAgent['currency'] : 'IDR'; // Default 'IDR' jika 'currency' tidak ada $currency_symbol = ($currency === 'IDR') ? 'Rp. ' : ''; // Jika currency = 'IDR', simbolnya 'Rp.' $formatted_balance = number_format($balance, 0, ',', '.'); $formatted_balance2 = number_format($balance2, 0, ',', '.'); //echo $currency_symbol . $formatted_balance; // Misalnya: Rp. 6.273.975 } else { // Menangani error jika data tidak valid echo 'Error fetching balance or invalid status.'; } ?>

Dashboard

Jam

info_agent(), true); $sgx = json_decode($SGX->info_agent(), true); if ((int)$nx['status'] !== 1 || (int)$sgx['status'] !== 200): ?>

Peringatan

Harap koneksikan kedua API terlebih dahulu - UVGAMING

Anggota Hari ini

Rp.

Agent Balance (NXS)

Rp.

Agent Balance (SGX)

Total Deposit Hari ini

Total withdraw hari ini

Total Deposit keseluruhan

Total Withdraw keselurhan

Anggota

Promosi

Staff

Queued Deposit

No.	Kode	UserName	Asal	Tujuan	Bonus	Jumlah	Tanggal	Status	Aksi

Queued Withdraw

0) { // Tampilkan data withdraw while ($data_withdraw = mysqli_fetch_assoc($query_withdraw_diproses)) { $id_withdraw = $data_withdraw['id']; $id_anggota_withdraw = $data_withdraw['extplayer']; $kode_withdraw = $data_withdraw['ref']; $tujuan_withdraw = $data_withdraw['bank_asal']; $jumlah_withdraw = $data_withdraw['jumlah']; $tanggal_withdraw = $data_withdraw['created_at']; $status_withdraw = $data_withdraw['status']; // Ambil nama pengguna anggota withdraw $anggota_withdraw = mysqli_query($koneksi, "SELECT * FROM tb_user WHERE extplayer = '$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['username']; } // Tentukan kelas status untuk warna latar belakang switch ($status_withdraw) { case 'Pending': $status_class = 'text-warning'; break; case 'Rejected': $status_class = 'text-danger'; break; case 'Sukses': $status_class = 'text-success'; break; default: $status_class = ''; break; } ?>

No.	Kode	Username	Tujuan	Jumlah	Tanggal	Status	Aksi