<?php
include_once __DIR__ . "/../../../../function/connect.php";

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

// Proses hapus
if (isset($_GET['hapus']) && !empty($_GET['hapus'])) {
    $id_hapus = intval($_GET['hapus']); // lebih aman pakai intval

    // Cek dulu apakah data ada
    $cek = mysqli_query($koneksi, "SELECT * FROM tb_refferal WHERE id = '$id_hapus'");
    
    if (mysqli_num_rows($cek) > 0) {
        $sql_hapus = mysqli_query($koneksi, "DELETE FROM tb_refferal WHERE id = '$id_hapus'");

        if ($sql_hapus) {
            echo "<script>alert('Data berhasil dihapus'); window.location='index.php?page=refferal';</script>";
            exit;
        } else {
            echo "<script>alert('Gagal hapus: " . mysqli_error($koneksi) . "');</script>";
        }
    } else {
        echo "<script>alert('Data tidak ditemukan');</script>";
    }
}
?>
<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

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

            $query = mysqli_query($koneksi, "SELECT * FROM tb_refferal");
            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="?page=refferal&hapus=<?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>