<?php include('session.php');
require_once($_SERVER['DOCUMENT_ROOT'] . '/classes/class.nexusggr.php');

  ?>

<!DOCTYPE html>

<html lang="en" class="light-style layout-navbar-fixed layout-menu-fixed" dir="ltr" data-theme="theme-default"
  data-assets-path="<?php echo $urlweb; ?>/assets/" data-template="vertical-menu-template">

<head>
  <meta charset="utf-8" />
  <meta name="viewport"
    content="width=device-width, initial-scale=1.0, user-scalable=no, minimum-scale=1.0, maximum-scale=1.0" />

  <title><?php echo $s0['instansi']; ?></title>
  <meta name="description" content="">
  <meta name="keywords" content="">
  <meta name="resource-type" content="document" />
  <meta http-equiv="content-type" content="text/html; charset=US-ASCII" />
  <meta http-equiv="content-language" content="en-us" />
  <meta name="author" content="Arie Budi" />
  <meta name="contact" content="ariebudi.com" />
  <meta name="copyright" content="Copyright (c) ariebudi.com. All Rights Reserved." />
  <meta name="robots" content="index, nofollow">

  <!-- Favicon -->
  <link rel="icon" type="image/x-icon" href="<?php echo $urlwebs; ?>/upload/favicon.png" />

  <!-- Fonts -->
  <link rel="preconnect" href="https://fonts.googleapis.com" />
  <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />
  <link
    href="https://fonts.googleapis.com/css2?family=Public+Sans:ital,wght@0,300;0,400;0,500;0,600;0,700;1,300;1,400;1,500;1,600;1,700&display=swap"
    rel="stylesheet" />

  <!-- Icons -->
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/fonts/fontawesome.css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/fonts/tabler-icons.css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/fonts/flag-icons.css" />

  <!-- Core CSS -->
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/css/rtl/core.css"
    class="template-customizer-core-css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/css/rtl/theme-default.css"
    class="template-customizer-theme-css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/css/demo.css" />

  <!-- Vendors CSS -->
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/libs/node-waves/node-waves.css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/libs/typeahead-js/typeahead.css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/libs/apex-charts/apex-charts.css" />
  <link rel="stylesheet" href="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-bs5/datatables.bootstrap5.css" />
  <link rel="stylesheet"
    href="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-responsive-bs5/responsive.bootstrap5.css" />
  <link rel="stylesheet"
    href="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-buttons-bs5/buttons.bootstrap5.css" />

  <!-- Page CSS -->

  <!-- Helpers -->
  <script src="<?php echo $urlweb; ?>/assets/vendor/js/helpers.js"></script>

  <!--! Template customizer & Theme config files MUST be included after core stylesheets and helpers.js in the <head> section -->
  <!--? Template customizer: To hide customizer set displayCustomizer value false in config.js.  -->
  <script src="<?php echo $urlweb; ?>/assets/vendor/js/template-customizer.js"></script>
  <!--? Config:  Mandatory theme config file contain global vars & default theme options, Set your preferred theme option in this file.  -->
  <script src="<?php echo $urlweb; ?>/assets/js/config.js"></script>
</head>

<body style="background-color: maroon; color: white;">
    <style>
      /* CSS tambahan */
      body {
        background-color: maroon;
        color: white;
      }

      /* Agar teks dalam card, navbar, form, dan tombol tetap selaras */
      .navbar, 
      .card, 
      .content-wrapper {
        background-color: maroon !important;
        color: white !important;
      }

      /* Label dan teks input */
      label, 
      h4, 
      .form-label, 
      .fw-bold, 
      .text-muted {
        color: white !important;
      }

      /* Input dan file upload box agar kontras di atas maroon */
      input.form-control, 
      select.form-control, 
      textarea.form-control {
        background-color: #6d0f0f;
        border: 1px solid #b52c2c;
        color: white;
      }

      input.form-control::placeholder {
        color: #f0dcdc;
      }

      /* Tombol utama tetap kontras */
      .btn-primary {
        background-color: #b52c2c;
        border-color: #b52c2c;
        color: white;
      }

      .btn-primary:hover {
        background-color: #8c1f1f;
        border-color: #8c1f1f;
      }

      .btn-light {
        background-color: #ffffff;
        color: maroon;
      }

      .alert {
        background-color: #8c1f1f;
        border-color: #b52c2c;
        color: white;
      }
    </style>
  <!-- Layout wrapper -->
  <div class="layout-wrapper layout-content-navbar">
    <div class="layout-container">
      <!-- Menu -->

      <?php include('sidebar.php'); ?>
      <!-- / Menu -->

      <!-- Layout container -->
      <div class="layout-page">
        <!-- Navbar -->

        <nav
          class="layout-navbar container-xxl navbar navbar-expand-xl navbar-detached align-items-center bg-navbar-theme"
          id="layout-navbar">
          <div class="layout-menu-toggle navbar-nav align-items-xl-center me-3 me-xl-0 d-xl-none">
            <a class="nav-item nav-link px-0 me-xl-4" href="javascript:void(0)">
              <i class="ti ti-menu-2 ti-sm"></i>
            </a>
          </div>

          <div class="navbar-nav-right d-flex align-items-center" id="navbar-collapse">
            <?php include('top-menu.php'); ?>
          </div>

          <!-- Search Small Screens -->
          <div class="navbar-search-wrapper search-input-wrapper d-none">
            <input type="text" class="form-control search-input container-xxl border-0" placeholder="Search..."
              aria-label="Search..." />
            <i class="ti ti-x ti-sm search-toggler cursor-pointer"></i>
          </div>
        </nav>

        <!-- / Navbar -->

        <!-- Content wrapper -->
        <div class="content-wrapper">
          <!-- Content -->

          <div class="container-xxl flex-grow-1 container-p-y">
            <div class="row">
                
<?php
error_reporting(0); // nonaktifkan warning

$today = date('Y-m');

// ===== Total Deposit =====
$sql_deposit = mysqli_query($conn, "
    SELECT COALESCE(SUM(total),0) as deposit 
    FROM tb_transaksi 
    WHERE status = 1 AND jenis = 1 AND DATE_FORMAT(date,'%Y-%m') = '$today'
") or die(mysqli_error($conn));
$deposit = mysqli_fetch_assoc($sql_deposit);

// ===== Total Withdraw =====
$sql_withdraw = mysqli_query($conn, "
    SELECT COALESCE(SUM(total),0) as withdraw 
    FROM tb_transaksi 
    WHERE status = 1 AND jenis = 2 AND DATE_FORMAT(date,'%Y-%m') = '$today'
") or die(mysqli_error($conn));
$withdraw = mysqli_fetch_assoc($sql_withdraw);

// ===== Total Member =====
$sql_member = mysqli_query($conn, "
    SELECT COUNT(*) as total_member 
    FROM tb_user 
    WHERE status = 1 AND level = 'user'
") or die(mysqli_error($conn));
$member = mysqli_fetch_assoc($sql_member);

// ===== Total Visitor =====
$sql_visitor = mysqli_query($conn, "
    SELECT COALESCE(SUM(hits),0) as visitor 
    FROM tb_stat
") or die(mysqli_error($conn));
$visitor = mysqli_fetch_assoc($sql_visitor);

$act = $FLASHERDEV->money_info();
$balance = $act['agent']['balance'];
$status_api = $act['msg'];
// Gabungkan semua data

?>

<style>
/* Animasi masuk */
.fade-in {
  animation: fadeInUp 0.8s ease-in-out;
}

@keyframes fadeInUp {
  0% { opacity: 0; transform: translateY(20px); }
  100% { opacity: 1; transform: translateY(0); }
}

/* Card styling */
.card {
  border: none;
  border-radius: 15px;
  box-shadow: 0 4px 20px rgba(0, 0, 0, 0.08);
  transition: all 0.3s ease;
  background: linear-gradient(145deg, #ffffff, #f3f6ff);
}

.card:hover {
  transform: translateY(-5px);
  box-shadow: 0 6px 25px rgba(0, 0, 0, 0.15);
}

/* Badge styling */
.badge {
  box-shadow: 0 3px 10px rgba(0,0,0,0.1);
}

/* Title and subtitle */
.card-info h5 {
  font-weight: 700;
  color: #343a40;
}

.card-info small {
  color: #6c757d;
  font-size: 0.85rem;
}

/* Gradient background for revenue card */
.revenue-card {
  background: linear-gradient(135deg, #007bff 0%, #6610f2 100%);
  color: white;
}

/* Progress bar customization */
.progress {
  height: 6px;
  border-radius: 5px;
  background-color: rgba(255,255,255,0.2);
}

.progress-bar {
  border-radius: 5px;
}
</style>

<div class="container-xxl flex-grow-1 container-p-y fade-in">
  <div class="row g-4">
    <!-- Total Member -->
    <div class="col-xl-3 col-lg-6 col-md-6 col-12">
      <div class="card text-center">
        <div class="card-body d-flex align-items-center">
          <div class="badge rounded-pill bg-label-info me-3 p-3">
            <i class="ti ti-users fs-4"></i>
          </div>
          <div class="card-info text-start">
            <h5 id="member_count"><?= number_format($member['total_member']); ?></h5>
            <small>Total Member</small>
          </div>
        </div>
      </div>
    </div>

    <!-- Total Deposit -->
    <div class="col-xl-3 col-lg-6 col-md-6 col-12">
      <div class="card text-center">
        <div class="card-body d-flex align-items-center">
          <div class="badge rounded-pill bg-label-success me-3 p-3">
            <i class="ti ti-shopping-cart fs-4"></i>
          </div>
          <div class="card-info text-start">
            <h5 id="deposit_count">Rp. <?= number_format($deposit['deposit']); ?></h5>
            <small>Total Deposit (Bulan Ini)</small>
          </div>
        </div>
      </div>
    </div>

    <!-- Total Withdraw -->
    <div class="col-xl-3 col-lg-6 col-md-6 col-12">
      <div class="card text-center">
        <div class="card-body d-flex align-items-center">
          <div class="badge rounded-pill bg-label-danger me-3 p-3">
            <i class="ti ti-chart-pie-2 fs-4"></i>
          </div>
          <div class="card-info text-start">
            <h5 id="withdraw_count">Rp. <?= number_format($withdraw['withdraw']); ?></h5>
            <small>Total Withdraw (Bulan Ini)</small>
          </div>
        </div>
      </div>
    </div>

    <!-- Total Visitor -->
    <div class="col-xl-3 col-lg-6 col-md-6 col-12">
      <div class="card text-center">
        <div class="card-body d-flex align-items-center">
          <div class="badge rounded-pill bg-label-primary me-3 p-3">
            <i class="ti ti-eye fs-4"></i>
          </div>
          <div class="card-info text-start">
            <h5 id="visitor_count"><?= number_format($visitor['visitor']); ?></h5>
            <small>Total Visitor</small>
          </div>
        </div>
      </div>
    </div>
  </div>

  <<div class="row section-gap">
    <div class="col-lg-6 col-md-12">
      <div class="card">
    <div class="card-body d-flex align-items-center justify-content-between">
          <div class="d-flex align-items-center">
            <div class="badge rounded-pill bg-label-success me-3 p-3">
              <i class="ti ti-currency-dollar fs-4"></i>
            </div>
            <div class="card-info text-start">
              <h5 class="mb-1"><?= number_format($balance); ?></h5>
              <small>Coin Available</small>
            </div>
          </div>
          <div>
            <span class="badge bg-label-info p-2 px-3 fs-6">
              Status API: <?= $act['msg']; ?>
            </span>
        </div>
      </div>
    </div>
  </div>
    <!-- Revenue Report -->
    <div class="col-lg-6 col-md-12" styl="position: relative; top: -15px;">
      <div class="card" style="position: relative; top: 15px;">
        <div class="card-header d-flex justify-content-between align-items-center border-0 pb-0">
          <div>
            <h5 class="mb-0 fw-bold">Laporan Keuangan</h5>
            <small class="text-muted">Penghasilan Dalam 1 Bulan</small>
          </div>
        </div>
        <div class="card-body">
          <h2 class="fw-bold mb-3 text-success">Rp. <?= number_format($s1['deposit']); ?></h2>

          <div class="border rounded p-3 bg-light">
            <div class="row">
              <div class="col-md-6 mb-3">
                <div class="d-flex align-items-center mb-2">
                  <div class="badge bg-label-primary p-2 me-2">
                    <i class="ti ti-currency-dollar"></i>
                  </div>
                  <h6 class="mb-0">Total Deposit</h6>
                </div>
                <h5>Rp. <?= number_format($s1['deposit']); ?></h5>
                <div class="progress">
                  <div class="progress-bar bg-primary" style="width: 65%"></div>
                </div>
              </div>

              <div class="col-md-6">
                <div class="d-flex align-items-center mb-2">
                  <div class="badge bg-label-info p-2 me-2">
                    <i class="ti ti-chart-pie-2"></i>
                  </div>
                  <h6 class="mb-0">Total Withdraw</h6>
                </div>
                <h5>Rp. <?= number_format($s2['withdraw']); ?></h5>
                <div class="progress">
                  <div class="progress-bar bg-info" style="width: 50%"></div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div><!-- end card -->
    </div>
  </div>
</div>
</div>
              <!--/ Revenue Report -->

              <!-- Popular Product -->
              <div class="col-md-12 col-xl-12 mb-4">
                <div class="card h-100">
                  <div class="card-header d-flex justify-content-between">
                    <div class="card-title m-0 me-2">
                      <h5 class="m-0 me-2">Pembayaran Terakhir</h5>
                      <small class="text-muted">Total Deposit</small>
                    </div>
                  </div>
                  <div class="card-body">
                    <div class="table-responsive">
                      <table class="table table-bordered table-hover">
                        <thead>
                          <tr class="bg-info text-white">
                            <th class="text-center" style="vertical-align: middle;">#</th>
                            <th class="text-center" style="vertical-align: middle;">TrxID</th>
                            <th class="text-center" style="vertical-align: middle;">Date</th>
                            <th class="text-center" style="vertical-align: middle;">Username</th>
                            <th class="text-center" style="vertical-align: middle;">Payment Method</th>
                            <th class="text-center" style="vertical-align: middle;">Payment From</th>
                            <th class="text-center" style="vertical-align: middle;">Amount</th>
                            <th class="text-center" style="vertical-align: middle;">Note</th>
                            <th class="text-center" style="vertical-align: middle;">Status</th>
                            <th class="text-center" style="vertical-align: middle;">Aksi</th>
                          </tr>
                        </thead>
                        <tbody>
                          <?php
                          $sql_1 = mysqli_query($conn, "SELECT * FROM `tb_transaksi` WHERE jenis = 1 AND status = 0 ORDER BY cuid DESC LIMIT 10") or die(mysqli_error());
                          $no = 0;
                          while ($s1 = mysqli_fetch_array($sql_1)) {
                            $no++;
                            $metode = $s1['metode'];
                            $pay_from = $s1['pay_from'];
                            $IDuser = $s1['userID'];
                            $sql_2 = mysqli_query($conn, "SELECT * FROM `tb_user` WHERE cuid = '$IDuser'") or die(mysqli_error());
                            $s2 = mysqli_fetch_array($sql_2);
                            $sql_3 = mysqli_query($conn, "SELECT * FROM `tb_bank` WHERE cuid = '$metode'") or die(mysqli_error());
                            $s3 = mysqli_fetch_array($sql_3);
                            $sql_4 = mysqli_query($conn, "SELECT * FROM `tb_bank` WHERE cuid = '$pay_from'") or die(mysqli_error());
                            $s4 = mysqli_fetch_array($sql_4);
                            ?>
                            <tr>
                              <td class="text-center" style="vertical-align: middle; font-size: 14px;"><?php echo $no; ?>
                              </td>
                              <td class="text-left" style="vertical-align: middle; white-space: normal; font-size: 14px;">
                                <?php echo $s1['kd_transaksi']; ?>
                              </td>
                              <td class="text-center"
                                style="vertical-align: middle; white-space: normal; font-size: 14px;">
                                <?php echo date('Y-m-d', strtotime($s1['date'])); ?><br><?php echo date('H:i:s', strtotime($s1['date'])); ?>
                              </td>
                              <td class="text-center"
                                style="vertical-align: middle; white-space: normal; font-size: 14px;">
                                <?php echo $s2['user']; ?>
                              </td>
                              <td class="text-center"
                                style="vertical-align: middle; white-space: normal; font-size: 14px;">
                                <?php if ($s1['metode'] == 0) {
                                  echo 'By Sistem';
                                } else {
                                  echo $s3['akun'];
                                } ?>
                              </td>
                              <td class="text-center"
                                style="vertical-align: middle; white-space: normal; font-size: 14px;">
                                <?php if ($s1['pay_from'] == 0) {
                                  echo 'By Sistem';
                                } else {
                                  echo $s4['akun'];
                                } ?>
                              </td>
                              <td class="text-right"
                                style="vertical-align: middle; white-space: normal; font-size: 14px; text-align: right;">
                                <?php echo number_format($s1['total']); ?>
                              </td>
                              <td class="text-center"
                                style="vertical-align: middle; white-space: normal; font-size: 14px;">
                                <?php echo $s1['note']; ?>
                              </td>
                              <td class="text-center"
                                style="vertical-align: middle; white-space: normal; font-size: 14px;">
                                <?php
                                if ($s1['status'] == 0) {
                                  echo '
                                        <span class="badge-dot">
                                          <i class="bg-warning"></i> PENDING
                                        </span>
                                      ';
                                } else if ($s1['status'] == 1) {
                                  echo '
                                        <span class="badge-dot">
                                          <i class="bg-success"></i> PAID
                                        </span>
                                      ';
                                } else {
                                  echo '
                                        <span class="badge-dot">
                                          <i class="bg-danger"></i> REJECT
                                        </span>
                                      ';
                                }
                                ?>
                              </td>
                              <td class="text-center"
                                style="vertical-align: middle; white-space: nowrap; font-size: 14px;">
                                <?php if ($s1['status'] == 0) { ?>
                                  <a href="<?php echo $urlweb; ?>/function/proses_topup.php?cuid=<?php echo $s1['cuid']; ?>"
                                    class="btn btn-primary btn-sm">Proses</a>
                                  <a href="<?php echo $urlweb; ?>/function/reject_topup.php?cuid=<?php echo $s1['cuid']; ?>"
                                    class="btn btn-danger btn-sm"
                                    onclick="return confirm('Are you sure want to Reject this Transaction?');">Reject</a>
                                <?php } else { ?>
                                  <a href="#" class="btn btn-success btn-sm">Selesai</a>
                                <?php } ?>
                              </td>
                            </tr>
                          <?php } ?>
                        </tbody>
                      </table>
                    </div>
                  </div>
                </div>
              </div>
              <div id="notifArea"></div>
              
     <audio id="notifSound">
  <source src="/ayah.mp3" type="audio/mpeg">
</audio>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

            </div>
          </div>
          <!-- / Content -->

          <!-- Footer -->
          <footer class="content-footer footer bg-footer-theme">
            <div class="container-xxl">
              <div
                class="footer-container d-flex align-items-center justify-content-between py-2 flex-md-row flex-column">
                <div>
                  ©
                  <script>
                    document.write(new Date().getFullYear());
                  </script>
                  , <?php echo $s0['instansi']; ?> All Rights Reserved.
                </div>
              </div>
            </div>
          </footer>
          <!-- / Footer -->

          <div class="content-backdrop fade"></div>
        </div>
        <!-- Content wrapper -->
      </div>
      <!-- / Layout page -->
    </div>

    <!-- Overlay -->
    <div class="layout-overlay layout-menu-toggle"></div>

    <!-- Drag Target Area To SlideIn Menu On Small Screens -->
    <div class="drag-target"></div>
  </div>
  <!-- / Layout wrapper -->

  <!-- Core JS -->
  <!-- build:js assets/vendor/js/core.js -->
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/jquery/jquery.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/popper/popper.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/js/bootstrap.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/node-waves/node-waves.js"></script>

  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/hammer/hammer.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/i18n/i18n.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/typeahead-js/typeahead.js"></script>

  <script src="<?php echo $urlweb; ?>/assets/vendor/js/menu.js"></script>
  <!-- endbuild -->

  <!-- Vendors JS -->
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/apex-charts/apexcharts.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables/jquery.dataTables.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-bs5/datatables-bootstrap5.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-responsive/datatables.responsive.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-responsive-bs5/responsive.bootstrap5.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-buttons/datatables-buttons.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-buttons-bs5/buttons.bootstrap5.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-buttons/buttons.html5.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/vendor/libs/datatables-buttons/buttons.print.js"></script>

  <!-- Main JS -->
  <script src="<?php echo $urlweb; ?>/assets/js/main.js"></script>
  <script src="<?php echo $urlweb; ?>/assets/js/dashboards-analytics.js"></script>
  <script>
    $(document).ready(function () {
      setInterval(function () {
        $('#getNotif').load('<?php echo $urlweb; ?>/getNotif.php');
      }, 1000);
    });
    
let sound = document.getElementById("notifSound");

// Fungsi play & stop suara
function playSound() {
    sound.play().catch(()=>{});
}
function stopSound() {
    sound.pause();
    sound.currentTime = 0;
}

setInterval(function(){
    $.get("getNotif.php", function(data){
        $(data).each(function(){
            var $notif = $(this);
            var id = $notif.attr('id');
            if( id && $('#'+id).length === 0 ){
                $("#notifArea").prepend($notif);
                playSound(); // putar suara setiap notif baru
            }
        });
    });
}, 5000);

// Event delegation tombol Buka Deposit
$(document).on('click', '.bukaDeposit', function(){
    stopSound();
    let id = $(this).data('id');
    window.location.href = "<?php echo $urlweb ?>/request_depo.php?id=" + id;
});

// Event delegation tombol Buka Withdraw
$(document).on('click', '.bukaWithdraw', function(){
    stopSound();
    let id = $(this).data('id');
    window.location.href = "<?php echo $urlweb ?>/request_wd.php?id=" + id;
});

// Tutup notifikasi
$(document).on('click', '.btn-close', function(){
    stopSound();
});

  </script>
</body>

</html>