MASTER

SAVING...

BERHASIL DIUBAH!

EDITING: refferal.php##

<div class="page-breadcrumb">
    <div class="row">
        <div class="col-5 align-self-center">
            <h4 class="page-title">Referral</h4>
        </div>
        <div class="col-7 align-self-center">
            <div class="d-flex align-items-center justify-content-end">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="#">Daftar Referral</a></li>
                        <li class="breadcrumb-item active" aria-current="page">Menu Referral</li>
                    </ol>
                </nav>
            </div>
        </div>
    </div>
</div>

<div class="container-fluid">
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-body">
                    <h4 class="card-title">Daftar Referral</h4>
                </div>
                <div class="table-responsive">
                    <table id="zero_config" class="table table-striped table-bordered">
                        <thead>
                            <tr>
                                <th scope="col">#</th>
                                <th scope="col">Id Referral</th>
                                <th scope="col">Id Downline</th>
                                <th scope="col">Deposit Downline</th>
                                <th scope="col">Join Date</th> 
                                <th scope="col">Aksi</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            // Menggunakan path yang dikoreksi
                            include_once __DIR__ . "/../../../../function/connect.php";

if (!$koneksi) {
                                die("Connection failed: " . mysqli_connect_error());
                            }

// Query dengan JOIN untuk mendapatkan tanggal daftar dari tabel users
                            $query = mysqli_query($koneksi, "SELECT r.*, u.date_created 
                                                            FROM tb_refferal r 
                                                            LEFT JOIN users u ON r.id_user = u.id");
                            
                            if (!$query) {
                                die("Query failed: " . mysqli_error($koneksi));
                            }

$no = 1;
                            while ($data = mysqli_fetch_array($query)) {
                                $id_user = $data['id_user'];

// Hitung total deposit
                                $query2 = mysqli_query($koneksi, "SELECT SUM(total) as total FROM tb_transaksi WHERE transaksi = 'Top Up' AND status = 'Sukses' AND id_user = '$id_user'");
                                $cek = mysqli_fetch_array($query2);
                                $total = $cek['total'] ? $cek['total'] : 0;
                                ?>
                                
                                <tr>
                                    <th scope="row"><?php echo $no++; ?></th>
                                    <td><?php echo htmlspecialchars($data['user_refferal']); ?></td>
                                    <td><?php echo htmlspecialchars($data['id_user']); ?></td>
                                    <td><?php echo number_format($total); ?></td>
                                    <td><?php echo $data['date_created']; ?></td>
                                    <td>
                                        <a href="hapus_referral.php?id=<?php echo $data['id']; ?>" 
                                           class="btn btn-danger btn-sm" 
                                           onclick="return confirm('Yakin ingin menghapus data ini?')">
                                           Hapus
                                        </a>
                                    </td>
                                </tr>
                                <?php
                            }
                            ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>