alert("Terjadi kesalahan, harap masuk kembali!");
window.location.replace("'.$alamat_admin.'keluar.php");
';
exit;
}
// Ambil semua anggota
$anggota_query = mysqli_query($koneksi, "
SELECT *
FROM tb_user where referral = ''
");
$all= mysqli_query($koneksi, "select * from tb_user")
?>
| # |
ID Anggota |
Nama Pengguna |
Turnover Reff |
Total Depo Sukses |
Total Referral |
Aksi |
0) {
$no = 1;
while ($data_anggota = mysqli_fetch_array($anggota_query)) {
$id_anggota = $data_anggota['id'];
$nama_pengguna = $data_anggota['username'];
$nm = $data_anggota['username'];
$upline = $data_anggota['username'];
// Total deposit reff
$deposit_query = mysqli_query($koneksi, "
SELECT SUM(d.jumlah) AS total_deposit
FROM tb_deposit d
JOIN tb_user a ON d.username = a.username
WHERE a.referral = '$nm' AND d.status = 'Sukses'
");
$deposit_data = mysqli_fetch_array($deposit_query);
$total_deposit = $deposit_data['total_deposit'] ? $deposit_data['total_deposit'] : 0;
// Total turnover = 10% dari deposit reff
$total_turnover = $total_deposit * 0.10;
// Total referral (jumlah downline langsung)
$referral_query = mysqli_query($koneksi, "
SELECT COUNT(*) AS total_referral
FROM tb_user
WHERE referral = '$nama_pengguna'
");
$referral_data = mysqli_fetch_array($referral_query);
$total_referral = $referral_data['total_referral'];
// $depo_sukses_query= mysqli_query($koneksi, "select count(*) as total_sukses from deposit where status_deposit='disetujui'");
$depo_sukses_query = mysqli_query($koneksi, "
SELECT COUNT(*) AS total_sukses
FROM tb_deposit d
JOIN tb_user a ON d.username = a.username
WHERE d.status = 'Sukses'
AND a.referral = '$nama_pengguna'
");
$sukses_data = mysqli_fetch_array($depo_sukses_query);
$total_sukses = $sukses_data['total_sukses'];
?>
|
|
|
|
ID
|
ID
|
Lihat Downline
|