Silakan login terlebih dahulu"; exit; } $from_date = $_GET['from_date'] ?? date('Y-m-d'); $end_date = $_GET['end_date'] ?? date('Y-m-d'); // 1. Ambil member referral $sql_user = "SELECT username, created_at FROM tb_user WHERE referral = '$username' AND DATE(created_at) BETWEEN '$from_date' AND '$end_date' ORDER BY id DESC"; $q_user = mysqli_query($koneksi, $sql_user); if (!$q_user) { die("Error Query User: " . mysqli_error($koneksi)); // Debugging: Jika ada error SQL, akan muncul di sini } if (mysqli_num_rows($q_user) == 0) { echo "Tidak ada data ditemukan"; exit; } while ($u = mysqli_fetch_assoc($q_user)) { $u_name = $u['username']; // 2. Ambil deposit (Pastikan nama tabel 'tb_deposit' dan kolom 'username', 'jumlah', 'tanggal' benar) $sql_depo = "SELECT jumlah, tanggal FROM tb_deposit WHERE username = '$u_name' AND status = 'Sukses' ORDER BY tanggal ASC"; $q_depo = mysqli_query($koneksi, $sql_depo); $depo = []; $tgl_depo1 = '-'; if ($q_depo) { while ($d = mysqli_fetch_assoc($q_depo)) { $depo[] = $d['jumlah']; if(count($depo) == 1) $tgl_depo1 = $d['tanggal']; } } // 3. Tampilan Baris echo " {$u_name} {$tgl_depo1} Rp " . number_format($depo[0] ?? 0, 0, ',', '.') . " Rp " . number_format($depo[1] ?? 0, 0, ',', '.') . " Rp " . number_format($depo[2] ?? 0, 0, ',', '.') . " Rp " . number_format($depo[3] ?? 0, 0, ',', '.') . " Rp " . number_format(array_sum(array_slice($depo, 4)), 0, ',', '.') . " 0 0 " . date('Y-m-d', strtotime($u['created_at'])) . " "; } ?>