<?php 
include 'connect.php';

session_start();

	$kadPengenalan=$_GET["kadPengenalan"];
	
	$sql = "SELECT * FROM `user` WHERE status !=''";
	$result = mysqli_query($conn,$sql);
	
	$sql2 = "SELECT * FROM `user` WHERE status=''";
	$result2 = mysqli_query($conn,$sql2);
	
	$sql3 = "SELECT * FROM `user` WHERE kad_pengenalan='".$kadPengenalan."'";
	$result3 = mysqli_query($conn,$sql3);
	$row3 = mysqli_fetch_array($result3);
?>

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

  <!-- 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';
  ?>
	
	<?php
	if($row3['peranan_user']!='SUPER ADMIN')
	{
	?>
	<main id="main" class="main" ></main>
	<?php 
	}
	else
	{
	?>
  <main id="main" class="main" style="margin-top:25px">
    <section class="section">
      <div class="row">
              <h5 class="card-title"></h5>
			  <div class="col-12">
              <div class="card recent-sales">
                <div class="card-body">
                  <h5 class="card-title">Permohonan Pendaftaran Baru</span></h5>
				<form class="row g-3" action="internalPage/insertApprove.php" method="post" >
                  <table class="table table-borderless datatable">
                    <thead>
                      <tr>
                        <th scope="col">No.</th>
                        <th scope="col">Nama</th>
						<th scope="col">Bahagian</th>
                        <th scope="col">Peranan</th>
                        <th scope="col">Tindakan</th>
						<th scope="col"></th>
						
                      </tr>
                    </thead>
                    <tbody>
					<?php
							
						$no=0;
						
						while ($row2 = mysqli_fetch_array($result2))
						{
							$no++;					
					?>
					
                      <tr>
					  
                        <th scope="row"><?php echo $no; ?></th>
                        <td><?php echo $row2["nama_user"]; ?></td>
						<td><?php echo $row2["bahagian"]; ?></td>
                        <td>
						<select  aria-label="Default select example" name="peranan" id="peranan">
							  <option value="<?php echo $row2["peranan_user"]; ?>" ><?php echo $row2["peranan_user"]; ?></option>
							  <option value="TIADA PERANAN" >TIADA PERANAN</option>
							  <option value="SUPER ADMIN" >SUPER ADMIN</option>
							  <option value="ADMIN" >ADMIN</option>
							  <option value="KB/KU" >KB/KU</option>
							  <option value="USER" >USER</option>
							</select>
						</td>
									
                        <td>
							<select  aria-label="Default select example" name="status" id="status">
							  <option value="APPROVED" >APPROVED</option>
							  <option value="REJECTED" >REJECTED</option>
							</select>
							<input type="text" id="kadPengenalan" name="kadPengenalan" value="<?php echo $row2["kad_pengenalan"]; ?>" hidden />	
						</td>
						
						<td><button type="submit" class="btn btn-primary"><i class="bi bi-check-square-fill"></i></button></td>
						
						<!--<td><a href="internalPage/insertApprove.php">send</a><td>-->
                       <td></td>
					  </tr>
					 
                      <?php
						}
						
					?>	
                    </tbody>
                  </table>
				</form>
                </div>

              </div>
            </div><!-- End Recent Sales -->   
        </div>
      </div>
    </section>

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

<main id="main" class="main" style="margin-top:25px">
    <section class="section">
      <div class="row">
              <h5 class="card-title"></h5>
			  <div class="col-12">
              <div class="card recent-sales">
                <div class="card-body">
                  <h5 class="card-title">Senarai Pengguna</span></h5>

                  <table class="table table-borderless datatable">
                    <thead>
                      <tr>
                        <th scope="col">No.</th>
                        <th scope="col">Nama</th>
						<th scope="col">Bahagian</th>
                        <th scope="col">Peranan</th>
                        <th scope="col">Status</th>
                        <th scope="col"></th>
                      </tr>
                    </thead>
                    <tbody>
						<?php
								
							$no=0;
							
							while ($row = mysqli_fetch_array($result))
							{
								$no++;					
						?>
                      <tr>
                        <th scope="row"><?php echo $no; ?></th>
                        <td><?php echo $row["nama_user"]; ?></td>
						<td><?php echo $row["bahagian"]; ?></td>
                        <td><?php echo $row["peranan_user"]; ?></td>
                        <?php
						if($row["status"]=="APPROVED")
						{
						?>
                        <td><span class="badge bg-success">Approved</span></td>
						<?php
						}
						else
						{
						?>
						<td><span class="badge bg-danger">Rejected</span></td>
						<?php
						}
						?>
						<td><a href="internalPage/deleteUser.php?kadPengenalan=<?php echo $row["kad_pengenalan"];?>" onclick="return confirm_alert(this);">
							  <i class="bi bi-trash"></i>
							  
							</a>
						</td>
                      </tr>
                      <?php
						}
						
					?>	
                    </tbody>
                  </table>

                </div>

              </div>
            </div><!-- End Recent Sales -->   
        </div>
      </div>
    </section>

  </main><!-- End #main -->
	<?php
	}
	?>
  <!-- ======= Footer ======= -->
  <footer id="footer" class="footer">
    <div class="copyright">
      &copy; Copyright <strong><span>Majlis Agama Islam Negeri Pulau Pinang @ 2022 <?php echo $kadPengenalan ?></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>
  <script src="jquery.min.js"></script> 
  <script>

	//alert on delete
	function confirm_alert(node) {
		return confirm("Anda pasti untuk padam pengguna ini? Tekan OK untuk teruskan atau CANCEL untuk batal.");
	}
	</script>

</body>

</html>