<?php 
require_once "../app/headl.php"; 
    
    if (isset($_SESSION['user'])) {
            $user = mysqli_query($conn, "SELECT * FROM `tb_user` WHERE user = '" . $_SESSION['user'] . "'") or die(mysqli_error());
            $u = mysqli_fetch_array($user);
            $users = $u['user'];
            $userid = $u['user'];
            $id_user = $u['cuid'];
            $userID = $u['cuid'];
            $token_id = isset($u['token_id']) ? $u['token_id'] : false;
            $level = isset($u['level']) ? $u['level'] : false;

            $sql_balance = mysqli_query($conn, "SELECT * FROM `tb_balance` WHERE userID = '$userID'") or die(mysqli_error());
            $sb = mysqli_fetch_array($sql_balance);
        ?>
        <body>

        <?php require_once "../app/menul.php" ?>

        <div class="clearfix"></div>
        <style>
            body {
                font-size: 12px;
                color: #FFFFFF;
                background-color: #1b1b1b;
            }

            .btn {
                margin-bottom: 2px;
                font-size: 12px;
                font-weight: bold;
            }

            .container {
                width: 100%;
            }

            .glyphicon {
                margin-right: 5px;
            }

            .no-gutter>[class*='col-'] {
                padding-right: 5px;
                padding-left: 5px;
                padding-top: 5px;
                padding-bottom: 5px;
            }

            .tengahBaris {
                vertical-align: middle;
            }

            table {
                padding-bottom: 0px;
            }

            .panel {
                box-shadow: 0px 3px 5px 0px rgba(0, 0, 0, 0.3);
            }

            input[readonly] {
                background-color: #fff0c4 !important;
                /* any other styles */
            }


            .panel-danger>.panel-heading,
            .panel-warning>.panel-heading,
            .btn-warning {
                color: #000000;
                font-weight: bold;
                border-color: rgba(0, 0, 0, 0.6);
                background-image: -webkit-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
                background-image: -o-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
                background-image: -webkit-gradient(linear, left top, left bottom, from(#eee791), color-stop(60%, #9d8b3d), to(#9f8435));
                background-image: linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
                background-repeat: no-repeat;
                filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff484e55', endColorstr='#ff313539', GradientType=0);
                -webkit-filter: none;
                filter: none
            }

            .btn-warning:hover {
                color: #000000;
                font-weight: bold;
                border-color: rgba(0, 0, 0, 0.6);
                background-image: -webkit-linear-gradient(#d7a001, #d7a001 60%, #d7a001);
                background-image: -o-linear-gradient(#d7a001, #d7a001 60%, #d7a001);
                background-image: -webkit-gradient(linear, left top, left bottom, from(#d7a001), color-stop(60%, #d7a001), to(#d7a001));
                background-image: linear-gradient(#d7a001, #d7a001 60%, #d7a001);
                background-repeat: no-repeat;
            }

            .login {
                color: #000000;
                font-weight: bold;
                border-color: rgba(0, 0, 0, 0.6);
                background-image: -webkit-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
                background-image: -o-linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
                background-image: -webkit-gradient(linear, left top, left bottom, from(#eee791), color-stop(60%, #9d8b3d), to(#9f8435));
                background-image: linear-gradient(#eee791, #9d8b3d 60%, #9f8435);
                background-repeat: no-repeat;
                filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff484e55', endColorstr='#ff313539', GradientType=0);
                -webkit-filter: none;
                filter: none
            }


            .panel-default>.panel-heading {
                color: #ffffff;
                border-color: rgba(0, 0, 0, 0.6)
            }

            .navbar-default {
                background-color: #000000;
                border-color: #2b2e32
            }

            .well {
                background: #111 !important;
            }


            input[readonly] {
                background-color: #eeeecd !important;
                /* any other styles */
            }

            textarea[readonly] {
                background-color: #eeeecd !important;
                /* any other styles */
            }

            .form-control {
                height: 40px !important;
                border-radius: 3px !important;
            }

            .form-control#validasi {
                height: 50px !important;
                border-radius: 3px !important;
            }

            .form-control-login {
                height: 40px !important;
                border-radius: 3px !important;
            }

            .form-control#reg_username,
            #reg_pass,
            #reg_passcon,
            #reg_email,
            #reg_telpon,
            #reg_bank,
            #reg_rek,
            #reg_nama,
            #reg_ref,
            #reg_dari,
            #reg_lain {
                height: 45px !important;
                border-radius: 3px !important;
            }


            textarea {
                height: 100px !important;
                width: 100%;
                padding: 10px;
                border-radius: 5px !important;
            }

            td {
                padding-top: 5px !important;
                padding-bottom: 5px !important;
            }

            .borderbottom {
                border-bottom: 2px solid #c2c2c2;
                border-top: 2px solid #c2c2c2;
            }

            @media (max-width: 1200px) {
                .navbar {
                    background: #32363b;
                }

                .navbar-header {
                    float: none;
                }

                .navbar-left,
                .navbar-right {
                    float: none !important;
                }

                .navbar-toggle {
                    display: block;
                }

                .navbar-collapse {
                    border-top: 1px solid transparent;
                    box-shadow: inset 0 1px 0 rgba(255, 255, 255, 0.1);
                }

                .navbar-fixed-top {
                    top: 0;
                    border-width: 0 0 1px;
                }

                .navbar-collapse.collapse {
                    display: none !important;
                }

                .navbar-nav {
                    float: none !important;
                    margin-top: 7.5px;
                }

                .navbar-nav>li {
                    float: none;
                }

                .navbar-nav>li>a {
                    padding-top: 10px;
                    padding-bottom: 10px;
                }

                .collapse.in {
                    display: block !important;
                }


                @media (min-width: 320px) {

                    /* iPhone SE,6/7/8/X, Galaxy S5,  */
                    .fadein {
                        position: relative;
                        width: 100%;
                        height: 160px;
                    }

                    .fadein img {
                        position: absolute;
                        left: 0;
                        top: 0;
                    }

                }

                @media (min-width: 400px) {

                    /* iPhone 6/7/8 Plus, Pixel 2,Pixel 2 XL,  */
                    .fadein {
                        position: relative;
                        width: 100%;
                        height: 200px;
                    }

                    .fadein img {
                        position: absolute;
                        left: 0;
                        top: 0;
                    }


                }

                @media (min-width: 700px) {

                    /* iPad  */
                    .fadein {
                        position: relative;
                        width: 100%;
                        height: 380px;
                    }

                    .fadein img {
                        position: absolute;
                        left: 0;
                        top: 0;
                    }

                }

                @media (min-width: 1000px) {
                    .fadein {
                        position: relative;
                        width: 100%;
                        height: 480px;
                    }

                    .fadein img {
                        position: absolute;
                        left: 0;
                        top: 0;
                    }

                }

            }

            textarea {
                height: 100px !important;
                width: 100%;
                padding: 10px;
                border-radius: 5px !important;
            }

            .form-control {
                height: 25px !important;
                border-radius: 3px !important;
            }

            td {
                padding-top: 5px !important;
                padding-bottom: 5px !important;
                padding-left: 3px !important;
                padding-right: 3px !important;
            }

            .grabgtab {
                font-weight: bold;
                border-color: rgba(0, 0, 0, 0.6);
                background-image: -webkit-linear-gradient(#1b1b1b, #1b1b1b 60%, #10100e);
                background-image: -o-linear-gradient(#1b1b1b, #1b1b1b 60%, #10100e);
                background-image: -webkit-gradient(linear, left top, left bottom, from(#1b1b1b), color-stop(60%, #1b1b1b), to(#10100e));
                background-image: linear-gradient(#1b1b1b, #1b1b1b 60%, #10100e);
                background-repeat: no-repeat;
                filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#1b1b1b', endColorstr='#10100e', GradientType=0);
                -webkit-filter: none;
                filter: none
            }

            .grabgtabbottom {
                font-weight: bold;
                border-color: rgba(0, 0, 0, 0.6);
                background-image: -webkit-linear-gradient(#3e444c, #1b1b1b 60%, #1b1b1b);
                background-image: -o-linear-gradient(#3e444c, #1b1b1b 60%, #1b1b1b);
                background-image: -webkit-gradient(linear, left top, left bottom, from(#3e444c), color-stop(60%, #1b1b1b), to(#1b1b1b));
                background-image: linear-gradient(#3e444c, #1b1b1b 60%, #1b1b1b);
                background-repeat: no-repeat;
                filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#1b1b1b', endColorstr='#1b1b1b', GradientType=0);
                -webkit-filter: none;
                filter: none
            }

            .abel {
                font-family: 'Abel';
            }
        </style>
        <!-- MAIN TAB -->

        <?php require_once "../app/game.php" ?>

        <div style="height:10px; background-color:#FFF" class="grabgtabbottom"></div>


        <div class="tab-content">

            <div id="dashboard_wrap" class="tab-pane fade in active">
                <div class="row" style="margin-bottom:0px">
                    <div class="col-xs-3" style="padding-right:2px">
                        <a class="btn btn-default btn-block " href="index.php"><span class="glyphicon glyphicon-calendar"></span>Statement</a>
                    </div>
                    <div class="col-xs-3" style="padding-right:1px; padding-left: 1px;">
                        <a class="btn btn-default btn-block active" href="history.php"><span class="glyphicon glyphicon-calendar"></span>History</a>
                    </div>
                    <div class="col-xs-3" style="padding-right:1px; padding-left: 2px;">
                        <a class="btn btn-default btn-block " href="memo.php"><span class="glyphicon glyphicon-edit"></span>Memo<span class="badge badgeTotal" style="margin-left:5px; margin-right:10px; font-size:9px; font-weight:bold"></span></a>
                    </div>
                    <div class="col-xs-3" style="padding-left:2px">
                        <a class="btn btn-default btn-block " href="refferal.php"><span class="glyphicon glyphicon-user"></span>Referal</a>
                    </div>
                </div>
                <div class="row" style="margin-bottom:10px">
                    <div class="col-xs-3" style="padding-right:2px">
                        <a class="btn btn-default btn-block " href="deposit.php"><span class="glyphicon glyphicon-import"></span>Deposit</a>
                    </div>
                    <div class="col-xs-3" style="padding-left:1px; padding-right:1px;">
                        <a class="btn btn-default btn-block " href="withdraw.php"><span class="glyphicon glyphicon-export"></span>Withdraw</a>
                    </div>
                    <div class="col-xs-3" style="padding-left:2px; padding-right:1px">
                        <a class="btn btn-default btn-block " href="rekening.php"><span class="glyphicon glyphicon-briefcase"></span>Rekening<span style="position:absolute; font-size: 10px; margin-top: -8px; margin-left:-85px">⭐</span></a>
                    </div>
                    <div class="col-xs-3" style="padding-left:2px">
                        <a class="btn btn-default btn-block " href="password.php"><span class="glyphicon glyphicon-user"></span>Password</a>
                    </div>
                </div>

                <div id="transaksi">
                    <div class="content" style="margin:0px !important; width:100% !important">
                        <div class="panel panel-danger">
                            <div class="panel-heading"><strong><span class="glyphicon glyphicon-tasks"></span>History Transaksi</strong>
                                <span style="float:right; margin-top:-4px; width:245px; display:inline">
                                    <form class="form-group-sm">
                                        <label style="float:left; margin-top:5px; margin-right:10px;">Filter</label>
                                        <select class="form-control" id="historyfilter" style="width:200px; float:right">
                                            <option value="">Semua</option>
                                            <option value="depowd">Deposit/Withdraw</option>
                                            <option value="log">Login/Logout/Ganti Password</option>
                                            <option value="togel">Transaksi Togel</option>
                                            <option value="pp">Transaksi Pragmatic</option>
                                            <option value="pg">Transaksi PGSoft</option>
                                            <option value="hb">Transaksi Habanero</option>
                                            <option value="jg">Transaksi Joker Gaming</option>
                                            <option value="sg">Transaksi Spade Gaming</option>
                                            <option value="jl">Transaksi JILI</option>
                                            <option value="fs">Transaksi FastSpin</option>
                                            <option value="ps">Transaksi PlayStar</option>
                                            <option value="cq">Transaksi CQ9</option>
                                            <option value="mg">Transaksi Micro Gaming</option>
                                            <option value="ttg">Transaksi TopTrend Gaming</option>
                                            <option value="ppl">Transaksi Pragmatic Live</option>
                                            <option value="ion">Transaksi ION Casino</option>
                                            <option value="evo">Transaksi Evolution</option>
                                            <option value="sx">Transaksi Sexy Gaming</option>
                                            <option value="ab">Transaksi AllBet</option>
                                            <option value="sa">Transaksi SA GAming</option>
                                            <option value="mgl">Transaksi Micro Gaming Live</option>
                                            <option value="og">Transaksi Opus Live</option>
                                            <option value="sbolc">Transaksi SBO Casino</option>
                                            <option value="sb">Transaksi Saba Sport</option>
                                            <option value="sbo">Transaksi SBO Sport</option>
                                            <option value="rtogel">Referal Togel</option>
                                            <option value="rpp">Referal Pragmatic</option>
                                            <option value="rpg">Referal PGSoft</option>
                                            <option value="rhb">Referal Habanero</option>
                                            <option value="rjg">Referal Joker Gaming</option>
                                            <option value="rsg">Referal Spade Gaming</option>
                                            <option value="rjl">Referal JILI</option>
                                            <option value="rfs">Referal FastSpin</option>
                                            <option value="rps">Referal PlayStar</option>
                                            <option value="rcq">Referal CQ9</option>
                                            <option value="rmg">Referal Micro Gaming</option>
                                            <option value="rttg">Referal TopTrend Gaming</option>
                                            <option value="rppl">Referal Pragmatic Live</option>
                                            <option value="rion">Referal ION Casino</option>
                                            <option value="revo">Referal Evolution</option>
                                            <option value="rsx">Referal Sexy Gaming</option>
                                            <option value="rab">Referal AllBet</option>
                                            <option value="rsa">Referal SA GAming</option>
                                            <option value="rmgl">Referal Micro Gaming Live</option>
                                            <option value="rog">Referal Opus Live</option>
                                            <option value="rsbolc">Referal SBO Casino</option>
                                            <option value="rsb">Referal Saba Sport</option>
                                            <option value="rsbo">Referal SBO Sport</option>

                                            <option value="dll">Bonus/Promo/Freebet</option>
                                        </select>
                                    </form>
                                </span>
                            </div>

<div class="panel panel-danger">
    <div class="panel-body">
        <table class="table table-striped table-hover" id="historyTable">
            <thead>
                <tr>
                    <th class="text-center">Tanggal</th>
                    <th class="text-center">Note</th>
                    <th class="text-center">Bet</th>
                    <th class="text-center">Win</th>
                    <th class="text-center">Result</th>
                    <th class="text-center">Provider</th>
                </tr>
            </thead>
            <tbody>
                <?php
                $hasData = false;

                // === 1. History Game ===
                $sql_game = mysqli_query($conn, "SELECT * FROM tb_history_game WHERE userID='$userID' ORDER BY datetime DESC") or die(mysqli_error($conn));
                if(mysqli_num_rows($sql_game) > 0){
                    $hasData = true;
                    while($game = mysqli_fetch_assoc($sql_game)){
                        $statusClass = ($game['result'] == 'Win') ? 'win' : 'lose';
                        echo "<tr>
                            <td align='center'>{$game['datetime']}</td>
                            <td align='center'>{$game['note']}</td>
                            <td align='center'>Rp ".number_format($game['bet'],0,',','.')."</td>
                            <td align='center'>Rp ".number_format($game['win'],0,',','.')."</td>
                            <td align='center' class='{$statusClass}'>{$game['result']}</td>
                            <td align='center'>{$game['provider']}</td>
                        </tr>";
                    }
                }

                // === 2. History Deposit/Withdraw ===
                $sql_trans = mysqli_query($conn, "SELECT * FROM tb_transaksi WHERE userID='$userID' ORDER BY date DESC") or die(mysqli_error($conn));
                if(mysqli_num_rows($sql_trans) > 0){
                    $hasData = true;
                    while($trans = mysqli_fetch_assoc($sql_trans)){
                        switch($trans['status']){
                            case 0: $statusText='Pending'; $statusClass='pending'; break;
                            case 1: $statusText='Bayar';   $statusClass='success'; break;
                            case 2: $statusText='Ditolak'; $statusClass='reject'; break;
                            default:$statusText='Unknown'; $statusClass='unknown'; break;
                        }
                        echo "<tr>
                            <td align='center'>{$trans['date']}</td>
                            <td align='center'>{$trans['transaksi']}</td>
                            <td align='center'>Rp ".number_format($trans['total'],0,',','.')."</td>
                            <td align='center'>-</td>
                            <td align='center' class='{$statusClass}'>{$statusText}</td>
                            <td align='center'>-</td>
                        </tr>";
                    }
                }

                // === 3. Jika tidak ada data ===
                if(!$hasData){
                    echo "<tr><td colspan='6' align='center'>Belum ada transaksi.</td></tr>";
                }
                ?>
            </tbody>
        </table>
    </div>
</div>

<!-- CSS untuk status warna -->
<style>
.win { color:#00ff00; font-weight:bold; }
.lose { color:#ff4444; font-weight:bold; }
.pending { color:#ffc107; font-weight:bold; }
.success { color:#00ff00; font-weight:bold; }
.reject { color:#ff4444; font-weight:bold; }
.unknown { color:#999; }
</style>

<!-- Optional: DataTables -->
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
<script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script>
$(document).ready(function() {
    $('#historyTable').DataTable({
        "order": [[0, "desc"]],
        "pageLength": 25,
        "lengthChange": true,
        "searching": true
    });
});
</script>

    </table>
</div>

</div>
  <script>
// Fungsi load history dengan filter
function loadHistory() {
    var filter = document.getElementById('historyfilter').value;

    fetch('history_ajax.php?filter=' + filter)
        .then(response => response.text())
        .then(data => {
            document.getElementById('historyBody').innerHTML = data;
        });
}

// Event filter
document.getElementById('historyfilter').addEventListener('change', loadHistory);

// Refresh otomatis setiap 3 detik
setInterval(loadHistory, 3000);

// Load pertama kali
loadHistory();
</script>

        <?php require_once "../app/footer.php" ?>

    </body>

    </html>
<?php } else { header("Location: ../login.php"); } ?>
                  