<?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> Riwayat Deposit

              </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">
                            
                          </div>
                        </div>
                    </form>
                </div>
              </div>
                  
              <div class="card">
                <div class="card-datatable table-responsive">
                  <table id="default-datatable" 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;">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;">Status</th>
                      </tr>
                    </thead>
                    <tbody>
                      <?php
                        $sql_1 = mysqli_query($conn,"SELECT * FROM `tb_transaksi` WHERE jenis = 1 AND `date` LIKE '$today%' ORDER BY cuid DESC") 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; color: white;"><?php echo $no; ?></td>
                        <td class="text-left" style="vertical-align: middle; white-space: normal; font-size: 14px; color: white;"><?php echo $s1['kd_transaksi']; ?></td>
                        <td class="text-center" style="vertical-align: middle; white-space: normal; font-size: 14px; color: white;"><?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; color: white;"><?php echo $s2['user']; ?></td>
                        <td class="text-center" style="vertical-align: middle; white-space: normal; font-size: 14px; color: white;"><?php if($s1['metode'] == 0) { echo 'Sistem'; } else { echo $s3['akun']; } ?></td>
                        <td class="text-center" style="vertical-align: middle; white-space: normal; font-size: 14px; color: white;"><?php if($s1['pay_from'] == 0) { echo 'Sistem'; } else { echo $s4['akun']; } ?></td>
                        <td class="text-right" style="vertical-align: middle; white-space: normal; font-size: 14px; text-align: right; color: white;"><?php echo number_format($s1['total']); ?></td>
                        <td class="text-center" style="vertical-align: middle; white-space: normal; font-size: 14px; color: white;">
                          <?php
                            if($s1['status'] == 1){
                              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>
                      </tr>
                      <?php } ?>
                    </tbody>
                  </table>
              </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>
