<?php include('session.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">
              <h4 class="fw-bold py-3 mb-4">
                <span class="text-muted fw-light">Transaction /</span> Transaction History

              </h4>

              <!-- Invoice List Table -->
              <?php
                  error_reporting(0);
                  if(isset($_GET['submit'])){
                    $today = $_GET['tahun'].'-'.$_GET['bulan'];
                  }
                  else {
                    $today = date('Y-m');
                  }
                  
              ?>
              <div class="card mb-3">
                <div class="card-body">
                   <form role="form" class="form-group" method="get" action="">
                        <div class="row">
                          <div class="col-sm-3">
                            <select name="tahun" id="tahunis" class="form-control select2-example" style="height: 40px!important;" required>
                              <option value="">Pilih Tahun </option>
                              <?php
                                for($i=2022;$i<=date('Y');$i++){
                              ?>
                              <option value="<?php echo $i; ?>"> <?php echo $i; ?> </option>
                              <?php } ?>
                            </select>
                          </div>
                          <div class="col-sm-3">
                            <select name="bulan" id="bulanis" class="form-control select2-example" style="height: 40px!important;" required>
                              <option value="">Pilih Bulan </option>
                              <?php
                                for($i=0;$i<12;$i++){
                                  $a = $i+1;
                                  $aa = strlen($a);
                                  if($aa == 1){
                                    $bulans = '0'.$a;
                                  }
                                  else {
                                    $bulans = $a;
                                  }
                              ?>
                              <option value="<?php echo $bulans; ?>"> <?php echo $bulan[$i]; ?> </option>
                              <?php } ?>
                            </select>
                          </div>
                          <div class="col-sm-3">
                            <button type="submit" name="submit" value="submit" class="btn btn-primary btn-block w-100">Filter Data</button>
                          </div>
                          <div class="col-sm-3">
                            <a href="<?php echo $urlweb; ?>/export/export_transaksi.php?periode=<?php echo $today; ?>" class="btn btn-success btn-block w-100">Download Excel</a>
                          </div>
                        </div>
                    </form>
                </div>
              </div>
                  
              <div class="card">
                <div class="card-datatable table-responsive">
                  <table class="invoice-list-table table border-top">
                    <thead>
                      <tr class="bg-info">
                        <th class="text-center" style="vertical-align: middle;">#</th>
                        <th class="text-center" style="vertical-align: middle;">Date</th>
                        <th class="text-center" style="vertical-align: middle;">Top Up</th>
                        <th class="text-center" style="vertical-align: middle;">Withdraw</th>
                        <th class="text-center" style="vertical-align: middle;">Margin</th>
                        <th class="text-center" style="vertical-align: middle;">Status</th>
                      </tr>
                    </thead>
                    <tbody>
                      <?php
                        $totalDepo = 0;
                        $totalWd = 0;
                        for($i=1;$i<=31;$i++){
                            $a = strlen($i);
                            if($a == 1){
                                $ii = '0'.$i;
                            }
                            else {
                                $ii = $i;
                            }
                            $tanggal = $today.'-'.$ii;
                      ?>
                      <tr>
                        <td class="text-center" style="vertical-align: middle; font-size: 14px; color: white;"><?php echo $i; ?></td>
                        <td class="text-center" style="vertical-align: middle; white-space: normal; font-size: 14px; color: white;"><?php echo $tanggal; ?></td>
                        <td class="text-right" style="vertical-align: middle; white-space: normal; font-size: 14px; text-align: right; color: white;">
                            <?php
                                $getDepo = mysqli_query($conn,"SELECT SUM(total) as totalDepo FROM `tb_transaksi` WHERE date LIKE '$tanggal%' AND jenis = 1 AND status = 1") or die(mysqli_error());
                                $gd = mysqli_fetch_array($getDepo);
                                $totalDepo += $gd['totalDepo'];
                                if($gd['totalDepo'] == 0){
                                    echo '0';
                                }
                                else {
                                    echo number_format($gd['totalDepo']);
                                }
                            ?>
                        </td>
                        <td class="text-right" style="vertical-align: middle; white-space: normal; font-size: 14px; text-align: right; color: white;">
                            <?php
                                $getWd = mysqli_query($conn,"SELECT SUM(total) as totalDepo FROM `tb_transaksi` WHERE date LIKE '$tanggal%' AND jenis = 2 AND status = 1") or die(mysqli_error());
                                $gw = mysqli_fetch_array($getWd);
                                $totalWd += $gw['totalDepo'];
                                if($gw['totalDepo'] == 0){
                                    echo '0';
                                }
                                else {
                                    echo number_format($gw['totalDepo']);
                                }
                            ?>
                        </td>
                        <td class="text-right" style="vertical-align: middle; white-space: normal; font-size: 14px; text-align: right; color: white;">
                            <?php
                                $margin = $gd['totalDepo'] - $gw['totalDepo'];
                                if($margin < 0){
                                    echo '<span class="text-danger">'.number_format($margin).'</span>';
                                }
                                else if($margin == 0){
                                    echo '<span class="text-dark">'.number_format($margin).'</span>';
                                }
                                else {
                                    echo '<span class="text-success">'.number_format($margin).'</span>';
                                }
                            ?>
                        </td>
                        <td class="text-center" style="vertical-align: middle; white-space: normal; font-size: 14px; color: white;"><?php if($gd['totalDepo'] < $gw['totalDepo']) { echo '<button class="btn btn-danger btn-sm">Rungkad</button>'; } else if($gd['totalDepo'] > $gw['totalDepo']) { echo '<button class="btn btn-success btn-sm">Cuan</button>'; } else { echo ''; } ?></td>
                      </tr>
                      <?php } ?>
                    </tbody>
                    <tfoot>
                      <tr class="<?php if($totalDepo < $totalWd) { echo 'bg-danger'; } else { echo 'bg-success'; } ?> text-white">
                        <th class="text-center" style="vertical-align: middle; color: white;"></th>
                        <th class="text-center" style="vertical-align: middle; color: white;"></th>
                        <th class="text-right" style="vertical-align: middle; text-align: right; color: white;">
                            <?php
                                if($totalDepo == 0){
                                    echo '0';
                                }
                                else {
                                    echo number_format($totalDepo);
                                }
                            ?>
                        </th>
                        <th class="text-right" style="vertical-align: middle; text-align: right; color: white;">
                            <?php
                                if($totalWd == 0){
                                    echo '0';
                                }
                                else {
                                    echo number_format($totalWd);
                                }
                            ?>
                        </th>
                        <th class="text-right" style="vertical-align: middle; text-align: right; color: white;">
                            <?php
                                $margine = $totalDepo - $totalWd;
                                echo number_format($margine);
                            ?>
                        </th>
                        <th class="text-center" style="vertical-align: middle;"><?php if($totalDepo < $totalWd) { echo 'Rungkad'; } else { echo 'Cuan'; } ?></th>
                      </tr>
                    </tfoot>
                  </table>
                </div>
              </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>
    $(document).ready(function() {
      //Default data table
      $('#default-datatable').DataTable();
      setInterval(function () {
        $('#countChat').load('<?php echo $urlweb; ?>/countChat.php');
      }, 1000);
        setInterval(function () {
          $('#getNotif').load('<?php echo $urlweb; ?>/getNotif.php');
        }, 1000);
    });
  </script>
  </body>
</html>
