Silakan login terlebih dahulu"; exit; } $from_date = $_GET['from_date'] ?? date('Y-m-d'); $end_date = $_GET['end_date'] ?? date('Y-m-d'); // Menggunakan LEFT JOIN untuk mengambil data deposit dan withdraw sekaligus $query = " SELECT u.username, u.created_at, SUM(DISTINCT d.jumlah) AS total_deposit, SUM(DISTINCT w.jumlah) AS total_withdraw FROM tb_user u LEFT JOIN tb_deposit d ON u.username = d.username AND d.status = 'Sukses' LEFT JOIN tb_withdraw w ON u.username = w.username AND w.status = 'Sukses' WHERE u.referral = '$username' AND DATE(u.created_at) BETWEEN '$from_date' AND '$end_date' GROUP BY u.username, u.created_at ORDER BY u.id DESC "; $q = mysqli_query($koneksi, $query); if (mysqli_num_rows($q) == 0) { echo " Tidak ada data referral ditemukan "; exit; } while ($r = mysqli_fetch_assoc($q)) { echo " {$r['username']} Rp " . number_format($r['total_deposit'] ?? 0, 0, ',', '.') . " Rp " . number_format($r['total_deposit'] ?? 0, 0, ',', '.') . " Rp " . number_format($r['total_withdraw'] ?? 0, 0, ',', '.') . " " . date('Y-m-d', strtotime($r['created_at'])) . " "; } ?>