<?php include "h.php";$_SESSION['Sc']=@$_POST['cr'];?>

<div align="center" style='margin: 5px;'><h2>STATUS PEMINJAMAN KUNCI</h2>

<?php 
//start 1
$rowsPerPage = 50;
$pageNum = 1;
if(isset($_GET['page'])){
	$pageNum = $_GET['page'];}
	$offset = ($pageNum - 1) * $rowsPerPage; 
//end 1

//start 3
$query   = mysqli_query($paut, "SELECT COUNT(ID) AS numrows FROM pnj, nms, bil WHERE pnj.ids = nms.ids AND pnj.idbil=bil.idbil ORDER BY id DESC");
$row     = mysqli_fetch_array($query);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];

if ($pageNum > 1){
	$page  = $pageNum - 1;
	$prev  = "<a href=\"$self?page=$page\"><font color='#000000'><img src='img/media_buttons_prev.png' height='30' width='30' title='Lihat Paparan Sebelum'></font></a>";
	$first = "<a href=\"$self?page=1\"><font color='#000'><img src='img/media_buttons_first.png' height='30' width='30' title='Lihat Paparan Pertama'></font></a>";} 
else{
	$prev  = '';$first = '';}

if ($pageNum < $maxPage){
	$page = $pageNum + 1;
	$next = "<a href=\"$self?page=$page\"><font color='#000'><img src='img/media_buttons_next.png' height='30' width='30' title='Lihat Paparan Seterusnya'></font></a>";
	$last = "<a href=\"$self?page=$maxPage\"><font color='#000'><img src='img/media_buttons_last.png' height='30' width='30' title='Lihat Paparan Terakhir'></font></a>";}
else{
	$next = '';$last = '';}
	
echo "<div align='right'>" . $first ."&nbsp;". $prev ."&nbsp;". $next ."&nbsp;". $last . "&nbsp;&nbsp;&nbsp;<strong><font color='RED'>$pageNum</font> / <font color='purple'>$maxPage</font></strong></font><br /><br /></div>";
//end 3					
?>

<table class="responsive" width="100%" height="119" border="1" align="center" cellpadding="3" cellspacing="0">
  <tr align="center" valign="middle" bgcolor="#FF3399">
    <td width="40" height="30"><strong>Bil</strong></td>
    <td width="135"><strong>Tarikh/Masa Pinjam</strong></td>
    <td width="135"><strong>Tarikh/Masa Pulang</strong></td>
    <td width="65"><strong>Kod Kunci </strong></td>
    <td width="240"><strong>Nama Bilik/Makmal/Bengkel</strong></td>
    <td width="250"><strong>Nama Peminjam</strong></td>
    <td width="125"><strong>Tujuan Pinjaman</strong></td>
  </tr>
  
  <?php 
  $i=1;
  $m=mysqli_query($paut, "SELECT * FROM pnj, nms, bil WHERE pnj.ids = nms.ids AND pnj.idbil=bil.idbil ORDER BY id DESC LIMIT $offset, $rowsPerPage");
  while($m1=mysqli_fetch_array($m)){
  $BGCOLOR = $i % 2 == 0 ? "#DDDDDD":"FFFFFF";
  ?>
  
  <tr align="center" valign="middle" bgcolor="<?= $BGCOLOR ?>" cellpadding="3" cellspacing="0">
    <td height="33"><?php echo "<font color='#000'>".$i.".</font>";?></td>
    <td><?php echo "<font color='#000'>".$m1['ts']."</font>";?></td>
    <td><?php echo "<font color='#000'>".$m1['tsp']."</font>";?></td>
    <td><?php echo "<font color='#000'>".$m1['Kod']."</font>";?></td>
    <td><?php echo "<font color='#000'>".$m1['Nm']."</font>";?></td>
    <td><a href="psrdet.php?detail=<?php echo $m1['ids'];?>" title="<?php echo "username/katalaluan="."".$m1['un']."/".$m1['nopin'];?>"><?php echo "<font color='#000'>".$m1['Nms']."<BR>(No Telefon: +".$m1['notel'].")</font></a>";?></td>
    <td><?php echo "<font color='#000'>".$m1['Tujuan']."</font>";?></td>
  </tr>
  
  <?php 
  	$i++;
  	//}else{echo "TIADA PEMINJAMAN SETAKAT INI.<br />Semua KUNCI BILIK/MAKMAL/BENGKEL telah dipulangkan.";
	}?>
</table><br />

<?php //start 3
$query   = mysqli_query($paut, "SELECT COUNT(ID) AS numrows FROM pnj, nms, bil WHERE pnj.ids = nms.ids AND pnj.idbil=bil.idbil ORDER BY id DESC");
$row     = mysqli_fetch_array($query);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];

if ($pageNum > 1){
	$page  = $pageNum - 1;
	$prev  = "<a href=\"$self?page=$page\"><font color='#000000'><img src='img/media_buttons_prev.png' height='30' width='30' title='Lihat Paparan Sebelum'></font></a>";
	$first = "<a href=\"$self?page=1\"><font color='#000'><img src='img/media_buttons_first.png' height='30' width='30' title='Lihat Paparan Pertama'></font></a>";} 
else{
	$prev  = '';$first = '';}

if ($pageNum < $maxPage){
	$page = $pageNum + 1;
	$next = "<a href=\"$self?page=$page\"><font color='#000'><img src='img/media_buttons_next.png' height='30' width='30' title='Lihat Paparan Seterusnya'></font></a>";
	$last = "<a href=\"$self?page=$maxPage\"><font color='#000'><img src='img/media_buttons_last.png' height='30' width='30' title='Lihat Paparan Terakhir'></font></a>";}
else{
	$next = '';$last = '';}
	
echo "<br /><br />" . $first ."&nbsp;". $prev ."&nbsp;". $next ."&nbsp;". $last . "<br><br>Halaman: <strong><font color='RED'>$pageNum</font> / <font color='purple'>$maxPage</font></strong></font><br><br>";
//end 3					
?>
</div>

<?php include "f.php";?>

<style>
body{
color: #000;
}

img {
    max-width: 100%;
}
</style>