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

	
	$sql1 = "select * from `user` where kad_pengenalan = '".$_SESSION['kadPengenalan']."' ";
	$result1 = mysqli_query($conn,$sql1);
	$row1 = mysqli_fetch_array($result1);


	if(isset($_POST['pdf'])) {
		pdf();
	}
	else {
	}

?>

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

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

  <title>Sistem Pendaftaran Surat</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">
  <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>  
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>   
  <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.5.0/js/bootstrap-datepicker.js"></script> 
  
  <link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.5.0/css/bootstrap-datepicker.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 
  include 'header.php';
 ?>

  <main id="main" class="main">
	<!--<form class="row g-3" action="UbahsuaiSearch.php" method="post">	
    <div class="pagetitle">
      <h1>Laporan Surat Masuk Mengikut Tarikh & Sesi </h1>
		
		<div class="row mb-3">
		  <label for="inputDate" class="col-sm-2 col-form-label">No.Rujukan:</label>
		  <div class="col-sm-3">				  
			<input type="text" class="date form-control" name="noRujukan" id="noRujukan" >					 
		  </div>
		</div>
		<div class="row mb-3">
		  <label for="inputDate" class="col-sm-2 col-form-label">Tajuk Surat:</label>
		  <div class="col-sm-3">				  
			<input type="text" class="date form-control" name="tajukSurat" id="tajukSurat" >					 
		  </div>
		</div>
		<div class="row mb-3">
		  <label for="inputDate" class="col-sm-2 col-form-label">Nama Pengirim:</label>
		  <div class="col-sm-3">				  
			<input type="text" class="date form-control" name="namaPengirim" id="namaPengirim" >					 
		  </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">
			<div class="card-body">
				<?php
						if(count($_POST)>0)
						{
							$noRujukan=$_POST['noRujukan'];						 
							$tajukSurat=$_POST['tajukSurat'];
							$namaPengirim = $_POST['namaPengirim'];						
							//$noCek = $_POST['noCek'];
				?>
						
				  <!-- Table with stripped rows -->
				  <table class="table datatable">
					<thead>
                  <tr style="font-size:14px;color:black">
                    <th scope="col">#</th>
                    <th scope="col">No. Rujukan Surat</th>
                    <th scope="col">Tarikh Surat</th>
                    <th scope="col">Tarikh Terima Surat</th>
                    <th scope="col">Tajuk</th>
					<th scope="col">Tindakan</th>
					<th scope="col">Bahagian</th>
					<th scope="col">Pengirim</th>
					<th scope="col">Alamat Pengirim</th>	
					<th scope="col">Sesi</th>
					<th scope="col">File</th>
					<th scope="col">Ubahsuai surat</th>
					<th scope="col">Ubahsuai cek</th>
					
                  </tr>
                </thead>
					<tbody style="font-size:12px;color:black">
					<?php
						$query ="SELECT * FROM `surat_masuk` LEFT JOIN `files` ON surat_masuk.id_surat_masuk=files.id_surat_masuk WHERE no_rujukan_surat = '".$noRujukan."' OR tajuk1 = '".$tajukSurat."' OR tajuk2 = '".$tajukSurat."' OR tajuk3 = '".$tajukSurat."' OR nama_pengirim = '".$namaPengirim."'  ";
						$result = mysqli_query($conn,$query);

						$no=0;
						
						while ($row = mysqli_fetch_array($result))
						{
							$no++;
					
					?>
					<tr >
						<th scope="row"><?php echo $no; ?></th>
						<td><?php echo $row["no_rujukan_surat"]; ?></td>
						<td><?php echo date('d-m-Y',strtotime($row['tarikh_surat'])) ?></td>
						<td><?php echo date('d-m-Y',strtotime($row["tarikh_terima_surat"])) ; ?></td>
						<td><?php echo $row["tajuk1"]; echo $row["tajuk2"]; echo $row["tajuk3"]; ?></td>
						
						<td><?php echo $row["tindakan"]; ?></td>
						<td><?php echo $row["bahagian"]; ?></td>
						<td><?php echo $row["nama_pengirim"]; ?></td>
						<td><?php echo $row["alamat1"];echo "&nbsp"; echo $row["alamat2"];echo "&nbsp"; echo $row["alamat3"];?></td>
						
						<td><?php echo $row["sesi"];?></td>
						<?php
						
						if ($row['name'] == "")
						{	
						?>
						<td></td>
						<?php
						}
						else
						{
						
						?>
						<td><a href="uploads/<?php echo $row['name']; ?>" target="_blank"><i class="bi bi-file-earmark-fill"></i></a></td>
						<?php
						}
						?>
						<td><a href="ubahsuaiSurat.php?idSuratMasuk=<?php echo $row["id_surat_masuk"]; ?>"><center><i class="bi bi-pencil"></i></center></a></td>
						<td><a href="ubahsuaiCek.php?idSuratMasuk=<?php echo $row["id_surat_masuk"]; ?>"><center><i class="bi bi-pencil"></i></center></a></td>
						
						
					  </tr>
					  <?php 
						}
						
						}
						else
						{}				
						?>
					</tbody>
					
				  </table>
				  <!-- End Table with stripped rows -->
				</div>
			</div>	
          </div>

        </div>
      </div>

  </main><!-- End #main -->

  <!-- ======= 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>
  
  

</body>

</html>