| Silakan login terlebih dahulu | ";
exit;
}
$from_date = $_GET['from_date'] ?? date('Y-m-d');
$end_date = $_GET['end_date'] ?? date('Y-m-d');
$user_q = mysqli_query($koneksi, "SELECT referral FROM tb_user WHERE username = '$username'");
$user_d = mysqli_fetch_assoc($user_q);
$kode_referral = $user_d['referral'] ?? '';
$q = mysqli_query($koneksi, "
SELECT username, created_at
FROM tb_user
WHERE referral = '$username'
AND DATE(created_at) BETWEEN '$from_date' AND '$end_date'
ORDER BY id desc
");
if (mysqli_num_rows($q) == 0) {
echo "
|
Tidak ada data referral ditemukan
|
";
exit;
}
while ($r = mysqli_fetch_assoc($q)) {
$uname = $r['username'];
$bet_q = mysqli_query($koneksi, "SELECT SUM(jumlah) AS total FROM tb_deposit WHERE username = '$uname' and status = 'Sukses'");
$bet_d = mysqli_fetch_assoc($bet_q);
$to_bet = $bet_d['total'] ?? 0;
$bayar_q = mysqli_query($koneksi, "SELECT SUM(jumlah) AS total FROM tb_withdraw WHERE username = '$uname' and status = 'Sukses'");
$bayar_d = mysqli_fetch_assoc($bayar_q);
$to_bayar = $bayar_d['total'] ?? 0;
echo "
| $uname |
Rp " . number_format($to_bet, 0, ',', '.') . " |
Rp " . number_format($to_bayar, 0, ',', '.') . " |
" . date('Y-m-d', strtotime($r['created_at'])) . " |
";
}
?>