alert("User referral tidak ditemukan!"); window.location.replace("referral.php");';
exit;
}
$q_upline = mysqli_query($koneksi, "SELECT username FROM tb_user WHERE referral = '$upline' LIMIT 1");
$data_upline = mysqli_fetch_assoc($q_upline);
$nama_upline = $data_upline ? $data_upline['username'] : $upline;
// Ambil semua downline
$downline_query = mysqli_query($koneksi, "SELECT id, username, created_at, claimed FROM tb_user WHERE referral = '$upline'");
?>
| # |
Nama Pengguna |
Tgl Daftar |
Deposit Pertama |
Aksi |
0) {
$nomor = 1;
while ($data = mysqli_fetch_array($downline_query)) {
$id_anggota = $data['id'];
$nama_pengguna = $data['username'];
// Hitung total deposit downline ini
$deposit_query = mysqli_query($koneksi, "
SELECT SUM(jumlah) AS total_deposit
FROM tb_deposit
WHERE username = '$nama_pengguna'
AND status = 'Sukses'
");
$deposit_data = mysqli_fetch_array($deposit_query);
$total_deposit = $deposit_data['total_deposit'] ? $deposit_data['total_deposit'] : 0;
// Turnover (10% dari deposit)
$total_turnover = $total_deposit * 0.10;
// Total referral si downline ini
$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_pertama_query = mysqli_query($koneksi, "
SELECT * FROM tb_deposit
WHERE username = '$nama_pengguna'
ORDER BY id ASC
LIMIT 1
");
$depo_pertama_data = mysqli_fetch_array($depo_pertama_query);
if ($depo_pertama_data && isset($depo_pertama_data['jumlah'])) {
$depo_pertama = $depo_pertama_data['jumlah'];
} else {
$depo_pertama = 0;
}
$tgl_q = mysqli_query($koneksi, "
SELECT * from tb_user
WHERE username = '$nama_pengguna' limit 1
");
$tg_q_data = mysqli_fetch_array($tgl_q);
$tgl = date("d-m-Y H:i", strtotime($tg_q_data['created_at']));
$claimed = $tg_q_data['claimed'];
?>
|
|
|
Rp |
Dicairkan
|