<?php

/**
 * Code By : Mahiruddin a.k.a Mhrdpy.NET
 * Date Edit : 16 - 12 - 2018
 * Dont Edit Anything If You Don't Know About Script
 * SMM Panel Script - Mhrdpy.NET
 * Demo => https://scriptsmm.web.id/ ( User & Pass : admin )
 * Contact Person :
                => Whatsapp  : 0895 3378 26740
                => Facebook  : Mahir Depay (https://facebook.com/hirpayzzz)
                => Instagram : mahirdpy_   (https://instagram.com/mahirdpy_)
                => Email     : mahirdpy@gmail.com
  __  __ _             _               _   _ ______ _______
 |  \/  | |           | |             | \ | |  ____|__   __|
 | \  / | |__  _ __ __| |_ __  _   _  |  \| | |__     | |
 | |\/| | '_ \| '__/ _` | '_ \| | | | | . ` |  __|    | |
 | |  | | | | | | | (_| | |_) | |_| |_| |\  | |____   | |
 |_|  |_|_| |_|_|  \__,_| .__/ \__, (_)_| \_|______|  |_|
                        | |     __/ |
                        |_|    |___/
**/

session_start();
require("../mainconfig.php");
$page_type = "Top 5 Pengguna";

if (isset($_SESSION['user'])) {
    $sess_username = $_SESSION['user']['username'];
    $check_user = $db->query("SELECT * FROM users WHERE username = '$sess_username'");
    $data_user = $check_user->fetch_array(MYSQLI_ASSOC);
    if ($check_user->num_rows == 0) {
        header("Location: ".$site_config['base_url']."user/logout");
    } else if ($data_user['status'] == "Suspended") {
        header("Location: ".$site_config['base_url']."user/logout");
    }

include("../lib/header.php");
?>

                <div class="row">
                    <div class="col-md-12">
                        <div class="card-box">
                            <h4 class="m-t-0 text-uppercase text-center header-title"><i class="mdi mdi-trophy"></i> Top 5 Pesanan Medsos</h4><hr>
                            <div class="table-responsive">
                                <table class="table table-bordered table-striped table-hover">
                                    <thead>
                                        <tr>
                                            <th>No</th>
                                            <th>Nama</th>
                                            <th>Total Pembelian</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        date(dmy);
                                        $no = 1;
                                        $datak = $db->query("SELECT a.username as users, b.user , SUM(b.price) as total FROM users a INNER JOIN orders b ON a.username = b.user where user = a.username GROUP BY b.user ORDER BY total DESC LIMIT 5");
                                                    while($use = mysqli_fetch_array($datak)){
                                                        if ($no == "1") {
                                                            $label = "success";
                                                        } else if ($no == "2") {
                                                            $label = "info";
                                                        } else if ($no == "3") {
                                                            $label = "warning";
                                                        }
                                                    ?>
                                        <tr class="table-<?php echo $label; ?>">
                                            <th scope="row"><?php echo $no; ?></th>
                                            <td><?php echo $use['users']; ?></td>
                                            <td>Rp <?php echo number_format($use['total'],0,",",".");?></td>
                                        </tr>
                                        <?php $no++; } ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>

<?php
    include("../lib/footer.php");
} else {
    header("Location: ".$site_config['base_url']);
}
?>