<?php
include '../connect.php';
session_start();

	date_default_timezone_set("Asia/Kuala_Lumpur");			
	$date=date('Y-m-d');
	$time=date('H:i:sa');

	$sql = "SELECT tempahan_kenderaan.tempahanID, tempahan_kenderaan.kad_pengenalan, tempahan_kenderaan.tarikhDestinasiDari, tempahan_kenderaan.tarikhDestinasiHingga, tempahan_kenderaan.masaDari, tempahan_kenderaan.masaHingga,
			tempahan_kenderaan.destinasi, tempahan_kenderaan.pemanduID, tempahan_kenderaan.kenderaanID,tempahan_kenderaan.nama_penumpang,tempahan_kenderaan.status,tempahan_kenderaan.catatan, user.kad_pengenalan, user.nama_user 
			FROM tempahan_kenderaan JOIN user ON tempahan_kenderaan.kad_pengenalan=user.kad_pengenalan WHERE tempahan_kenderaan.kad_pengenalan='".$_SESSION['kadPengenalan']."' AND tempahan_kenderaan.tarikhDestinasiHingga>= '".$date."' ";
	$result = mysqli_query($conn,$sql);
	
	$sql1 ="SELECT nama_user, peranan_user FROM user WHERE kad_pengenalan='".$_SESSION['kadPengenalan']."'";
	$result1 = mysqli_query($conn,$sql1);
	$row1 = mysqli_fetch_array($result1);
	

?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta content="width=device-width, initial-scale=1.0" name="viewport">

  <title>Sistem Tempahan</title>
  <meta content="" name="description">
  <meta content="" name="keywords">

  <!-- Favicons -->
  <link href="../assets/img/logo_tab.png" rel="icon">

  <!-- Google Fonts -->
  <link href="https://fonts.gstatic.com" rel="preconnect">
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Nunito:300,300i,400,400i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">

  <!-- Vendor CSS Files -->
  <link href="../assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="../assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
  <link href="../assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <link href="../assets/vendor/quill/quill.snow.css" rel="stylesheet">
  <link href="../assets/vendor/quill/quill.bubble.css" rel="stylesheet">
  <link href="../assets/vendor/remixicon/remixicon.css" rel="stylesheet">
  <link href="../assets/vendor/simple-datatables/style.css" rel="stylesheet">

  <!-- Template Main CSS File -->
  <link href="../assets/css/style.css" rel="stylesheet">
  
  <!-- Script logout -->
  <script type="text/javascript" src="../internalPage/logoutConfirmation.js"></script>

  
  <!-- =======================================================
  * Template Name: NiceAdmin - v2.2.0
  * Template URL: https://bootstrapmade.com/nice-admin-bootstrap-admin-html-template/
  * Author: BootstrapMade.com
  * License: https://bootstrapmade.com/license/
  ======================================================== -->
</head>

<body>

  <?php 
  if($row1['peranan_user']=='USER')
  {
	  include 'header.html';
  }
  else
  {
	  include 'headerAdmin.html';
  }
  ?>

	<?php
	if($row1['peranan_user']!='SUPER ADMIN')
	{
	?>
	<main id="main" class="main" >
	    <div class="alert alert-danger bg-danger text-light border-0 alert-dismissible fade show" role="alert">
			Anda tidak mempunyai akses untuk menu ini!
		</div>
	</main>
	<?php 
	}
	else
	{
	?>
	<main id="main" class="main" >
	<form class="row g-3" action="transaksiLog.php" method="post" >	
    <div class="pagetitle">
      <h1>Transaksi Log Pengguna</h1><br>
		
		<div class="row mb-3">
		  <label for="inputDate" class="col-sm-2 col-form-label">Tarikh mula transaksi</label>
		  <div class="col-sm-3">
			<input type="date"  class="form-control" name="tarikh" id="tarikh" data-date-format="dd-mm-yy">
			<div class="invalid-feedback">Sila masukkan tarikh mula.</div>
		  </div>
		</div>
		<div class="row mb-3">
		  <label for="inputDate" class="col-sm-2 col-form-label">Hingga</label>
		  <div class="col-sm-3">
			<input type="date"  class="form-control" name="tarikh1" id="tarikh1" data-date-format="dd-mm-yy">
			<div class="invalid-feedback">Sila tarikh hingga.</div>
		  </div>
		</div>
		<button type="submit" class="btn btn-primary">Cari</button>
		<button type="reset" class="btn btn-secondary">Reset</button>
		
	</form>
    </div><!-- End Page Title -->
		
      <div class="row">
        <div class="col-lg-12">
		
          <div class="card" style="overflow:scroll">			  
				
				<?php
						if(count($_POST)>0)
						{
							$tarikh=$_POST['tarikh'];	
							$tarikh1 =$_POST['tarikh1'];
														
							$query="SELECT * FROM `audit_trail`	
							WHERE `tarikh` BETWEEN '$tarikh' AND '$tarikh1';";
							$result= mysqli_query($conn,$query);
				?>

				  <!-- Table with stripped rows -->
				  <table class="table datatable">
					<thead>
					  <tr style="font-size:14px;color:black">
						<th scope="col">BIL</th>
						<th scope="col">KAD PENGENALAN</th>
						<th scope="col">TARIKH</th>
						<th scope="col">MASA</th>
						<th scope="col">OPERASI</th>														
						<th scope="col">CATATAN</th>
					  </tr>
					</thead>
					<tbody style="font-size:12px;color:black">
				<?php
				
					$no=0;
					
					while ($row = mysqli_fetch_array($result))
					{
						$no++;
						
						
				
				?>
                  <tr >
                    <th scope="row"><?php echo $no; ?></th>
					<td><?php echo $row["kad_pengenalan"];?></td>
                    <td><?php echo date("d-m-Y", strtotime($row['tarikh'])); ?></td>
                    <td><?php echo $row["masa"]; ?></td>
                    <td><?php echo $row["operasi"]; ?></td>										
					<td><?php echo $row["catatan"]; ?></td>
                  </tr>
				  <?php
					}
					
				?>
                </tbody>
              </table>
			  <?php
						}
			  else
			  {
			  ?>
			   <table class="table datatable">
					<thead>
					  <tr style="font-size:14px;color:black">
						<th scope="col">BIL</th>
						<th scope="col">KAD PENGENALAN</th>
						<th scope="col">TARIKH</th>
						<th scope="col">MASA</th>
						<th scope="col">OPERASI</th>														
						<th scope="col">CATATAN</th>
					  </tr>
					</thead>
					<tbody style="font-size:12px;color:black">
				<?php
				
					$no=0;
					$query1="SELECT * FROM `audit_trail`;";
							$result1= mysqli_query($conn,$query1);
					
					while ($row1 = mysqli_fetch_array($result1))
					{
						$no++;
						
						
				
				?>
                  <tr >
                    <th scope="row"><?php echo $no; ?></th>
					<td><?php echo $row1["kad_pengenalan"];?></td>
                    <td><?php echo date("d-m-Y", strtotime($row1['tarikh'])); ?></td>
                    <td><?php echo $row1["masa"]; ?></td>
                    <td><?php echo $row1["operasi"]; ?></td>										
					<td><?php echo $row1["catatan"]; ?></td>
                  </tr>
				  <?php
					}
					}
				?>
                </tbody>
              </table>
			</div>	
          </div>

        </div>
      </div>

  </main><!-- End #main -->
	<?php
	}
	?>
  <!-- ======= Footer ======= -->
  <footer id="footer" class="footer">
    <div class="copyright">
      &copy; Copyright <strong><span>Majlis Agama Islam Negeri Pulau Pinang @ 2022</span></strong>.
    </div>
  </footer><!-- End Footer -->

  <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>

   <!-- Vendor JS Files -->
  <script src="../assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="../assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="../assets/vendor/chart.js/chart.min.js"></script>
  <script src="../assets/vendor/echarts/echarts.min.js"></script>
  <script src="../assets/vendor/quill/quill.min.js"></script>
  <script src="../assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="../assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="../assets/vendor/php-email-form/validate.js"></script>

  <!-- Template Main JS File -->
  <script src="../assets/js/main.js"></script>
  

  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>
  
 

</body>

</html>