<?php
if(!isAdmin()){
    header("Location: /404");
    exit();
}
?>
<div class="container" style="margin-top: 70px;">
        <div class="rows">
            <div class="col-md-12">
                <div class="btn-group btn-breadcrumb btn-breadcrumb" style="margin-bottom: 20px;">
                    <a href="javascript:;" class="btn btn-danger"><i class="glyphicon glyphicon-home"></i></a>
                    <a href="/admin/" class="btn btn-default">Trang Chủ</a>
                    <a href="javascript:;" class="btn btn-default" disabled="">Hoạt động gần đây</a>
                </div>
            </div>
        </div>

        <div class="rows">

            <div class="col-lg-12">
                <div class="panel panel-default">
                    <div class="panel-heading"><i class="fas fa-history"></i> Lịch Sử Mua Robux</div>
                    <div class="table-responsive">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>Tài Khoản</th>
                                    <th>Tên tài khoản</th>
                                    <th>Số Tiền Nạp</th>
                                    <th>Số Coin</th>
                                    <th>Thời Gian</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $current_page = isset($_GET['p']) ? $_GET['p'] : "1";
                                if ($current_page < 1) {
                                    $current_page = 1;
                                }
                                if (!is_numeric($current_page)) {
                                    $current_page = 1;
                                }
                                $limit = 10;
                                $offset = ($current_page-1) * $limit;
                                $system->query("SELECT * FROM `transaction_buy`");
                                $total_page = ceil($system->num_rows()/$limit);
                                $system->query("SELECT * FROM `transaction_buy` ORDER BY id DESC LIMIT $offset,$limit");
                                if($system->num_rows()>0){
                                    while ($transaction_rb = $system->fetch()) {
                                        if($transaction_rb['status']==0){
                                            $transaction_rb['status'] = '<span class="text-success">Thành Công</span>';
                                        }
                                        ?>
                                        <tr>
                                            <td scope="col"><?=$transaction_rb['id']?></td>
                                            <td scope="col"><?=$transaction_rb['username']?></td>
                                            <td scope="col">$ <?=number_format($transaction_rb['sotien'])?></td>
                                            <td scope="col"><?=$transaction_rb['userId']?></td>
                                            <td scope="col"><?=$transaction_rb['coin']?></td>
                                            <td scope="col"><?=convert_time($transaction_rb['time'])?></td>
                                        </tr>
                                        <?php
                                    }
                                }else{
                                    ?>
                                    <tr>
                                        <td colspan="5">Không Có Dữ Liệu :D</td>
                                    </tr>
                                    <?php
                                }
                                ?>
                            </tbody>
                        </table>
                    </div>
                </div>