MASTER

SAVING...

BERHASIL DIUBAH!

EDITING: get-referral.php#8999

<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);
include '../db/koneksi.php';
session_start();
$username = $_SESSION['username'] ?? '';

if (!$username) {
    echo "<tr><td colspan='10'>Silakan login terlebih dahulu</td></tr>";
    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 "<tr><td colspan='10' style='text-align:center;'>Tidak ada data ditemukan</td></tr>";
    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 "<tr>
        <td>{$u_name}</td>
        <td>{$tgl_depo1}</td>
        <td>Rp " . number_format($depo[0] ?? 0, 0, ',', '.') . "</td>
        <td>Rp " . number_format($depo[1] ?? 0, 0, ',', '.') . "</td>
        <td>Rp " . number_format($depo[2] ?? 0, 0, ',', '.') . "</td>
        <td>Rp " . number_format($depo[3] ?? 0, 0, ',', '.') . "</td>
        <td>Rp " . number_format(array_sum(array_slice($depo, 4)), 0, ',', '.') . "</td>
        <td>0</td>
        <td>0</td>
        <td>" . date('Y-m-d', strtotime($u['created_at'])) . "</td>
    </tr>";
}
?>