<?php 
session_start();
error_reporting(0);

$id_login = $_SESSION['id'];
$extplayer = $_SESSION['extplayer'];

if (isset($_POST['submit'])) {
    $bank = $_POST['bank'];
    $jumlah = $_POST['jumlah'];
    $keterangan = "Withdraw";
    $tanggal = date('Y-m-d H:i:s');

    // Ambil nilai minimal penarikan dari tabel web
    $query99 = mysqli_query($koneksi, "SELECT * FROM tb_web");
    $cek_wd = mysqli_fetch_array($query99);
    $wd = $cek_wd['min_wd'];

    // Periksa apakah ada proses withdraw yang masih berjalan
    $cek = mysqli_query($koneksi, "SELECT * FROM tb_transaksi WHERE id_user = '$extplayer' AND transaksi = 'Withdraw' AND status IN ('Pending', 'Belum Bayar')");
    $hitung = mysqli_num_rows($cek);

    if ($hitung == 0) {
        $q = mysqli_query($koneksi, "SELECT * FROM tb_saldo WHERE id_user = '$extplayer'");
        $c = mysqli_fetch_array($q);
        $ac = $c['active'];

        if ($ac < $jumlah) {
            ?>
            <script type="text/javascript">
                alert('Saldo Anda Tidak Mencukupi Untuk Melakukan Withdraw');
                window.location = '?page=withdraw';
            </script>
            <?php
        } elseif ($jumlah < $wd) { // Periksa apakah jumlah penarikan kurang dari nilai minimal penarikan
            ?>
            <script type="text/javascript">
                alert('Withdraw minimal <?php echo $wd ?> Ya');
                window.location = '?page=withdraw';
            </script>
            <?php
        } else {
            // Lanjutkan proses penarikan jika tidak ada masalah

            // Cek apakah pengguna memiliki bonus dan memenuhi syarat untuk penarikan
            $query = mysqli_query($koneksi, "SELECT * FROM tb_turnover WHERE id_user = '$extplayer'");
            $cek_turn = mysqli_num_rows($query);
            $cek = mysqli_fetch_array($query);

            $id_bonus = $cek['id_bonus'];
            if ($cek_turn == 1) {
                $query1 = mysqli_query($koneksi, "SELECT * FROM tb_bonus WHERE id = '$id_bonus'");
                $cek_bonus = mysqli_fetch_array($query1);	

                $bonus = $cek_bonus['bonus'];
                $turn = $cek_bonus['turnover'];

                $query2 = mysqli_query($koneksi, "SELECT * FROM tb_saldo WHERE id_user = '$extplayer'");
                $cek_saldo = mysqli_num_rows($query2);
                $c = mysqli_fetch_array($query2);

                $saldo = $c['active'];
                $hitung = $bonus * $turn;

                if ($saldo < $hitung) {
                    ?>
                    <script type="text/javascript">
                        alert('Maaf Anda Belum Mencapai Nominal Kemenangan Yang Sudah Ditentukan, Silhakan Hubungi Admin Jika Ingin Menghapus Bonus Yang Ada');
                        window.location = "?page=withdraw";
                    </script>
                    <?php
                } else {
                    // Lakukan penarikan
                    $query = mysqli_query($koneksi, "INSERT INTO tb_transaksi(id,gambar,tanggal,transaksi,total,dari_bank,metode,bonus,keterangan,status,id_user) VALUES (NULL, '', '$tanggal','Withdraw','$jumlah','$bank','','','$keterangan','Pending','$extplayer')");	

                    $updateBalance = mysqli_query($koneksi, "UPDATE `tb_saldo` SET `active` = active - '$jumlah', `pending` = pending + '$jumlah' WHERE id_user = '$extplayer'") or die(mysqli_error());

                    if ($query) {
                        ?>
                        <script type="text/javascript">
                            alert('Selamat Anda Berhasil Withdraw, Silahkan Menunggu Admin Mengkonfirmasi Tagihan Anda');
                            window.location = "?page=withdraw";
                        </script>
                        <?php
                    }
                }
            } else {
                // Lakukan penarikan tanpa syarat bonus
                $query = mysqli_query($koneksi, "INSERT INTO tb_transaksi(id,gambar,tanggal,transaksi,total,dari_bank,metode,bonus,keterangan,status,id_user) VALUES (NULL, '', '$tanggal','Withdraw','$jumlah','$bank','','','$keterangan','Pending','$extplayer')");	

                $updateBalance = mysqli_query($koneksi, "UPDATE `tb_saldo` SET `active` = active - '$jumlah', `pending` = pending + '$jumlah' WHERE id_user = '$extplayer'") or die(mysqli_error());
                if ($query) {
                    ?>
                    <script type="text/javascript">
                        alert('Selamat Anda Berhasil Withdraw, Silahkan Menunggu Admin Mengkonfirmasi Tagihan Anda');
                        window.location = "?page=withdraw";
                    </script>
                    <?php
                }
            }
        }
    } else {
        ?>
        <script type="text/javascript">
            alert('Anda Masih Memiliki Proses Withdraw Yang Belum Selesai');
            window.location = "?page=withdraw";
        </script>
        <?php
    }
}
?>
