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 |
Tgl Depo Terakhir |
Depo Pertama |
Riwayat Depo |
Aksi |
0) {
$nomor = 1;
while ($data = mysqli_fetch_array($downline_query)) {
$id_anggota = $data['id'];
$nama_pengguna = $data['username'];
// 1. Ambil Depo Pertama
$depo_pertama_query = mysqli_query($koneksi, "SELECT jumlah FROM tb_deposit WHERE username = '$nama_pengguna' ORDER BY id ASC LIMIT 1");
$depo_pertama_data = mysqli_fetch_array($depo_pertama_query);
$depo_pertama = $depo_pertama_data ? $depo_pertama_data['jumlah'] : 0;
// 2. Ambil Tgl Depo Terakhir menggunakan created_at
$tgl_depo_query = mysqli_query($koneksi, "
SELECT MAX(created_at) as tgl_terakhir
FROM tb_deposit
WHERE username = '$nama_pengguna'
AND status = 'Sukses'
");
$tgl_depo_data = mysqli_fetch_array($tgl_depo_query);
$tgl_depo_terakhir = $tgl_depo_data['tgl_terakhir'] ? date("d-m-Y H:i", strtotime($tgl_depo_data['tgl_terakhir'])) : '-';
$tgl_daftar = date("d-m-Y H:i", strtotime($data['created_at']));
$claimed = $data['claimed'];
?>
|
|
|
|
Rp |
|
Dicairkan
|