71 lines
1.8 KiB
PHP
71 lines
1.8 KiB
PHP
<?php
|
|
session_start();
|
|
include("core/main.php");
|
|
|
|
|
|
$sql = "SELECT DISTINCT
|
|
t_permintaan_barang.`NO`,
|
|
t_permintaan_barang.NIP,
|
|
m_login.DEPARTEMEN,
|
|
t_permintaan_barang.tglpesan
|
|
FROM
|
|
t_permintaan_barang
|
|
INNER JOIN m_login ON (t_permintaan_barang.NIP = m_login.NIP)
|
|
WHERE t_permintaan_barang.KATEGORY = 'L' AND statusacc = '0'";
|
|
|
|
$qry_order = $db->query($sql);
|
|
$order = $qry_order->fetchAll()[0];
|
|
?>
|
|
<div align="center">
|
|
<div id="frame">
|
|
<div id="frame_title"><h5>LIST DATA PERMINTAAN BARANG</h5></div>
|
|
<div align="right" style="margin:5px;">
|
|
<div id="table_search">
|
|
<table width="95%" style="margin:10px;" border="0" cellspacing="0" cellspading="0" class="tb">
|
|
<tr align="center">
|
|
<th width="15%">NO</th>
|
|
<th>NIP</th>
|
|
<th>NAMA</th>
|
|
<th>POLY</th>
|
|
<th>TGL PESAN</th>
|
|
</tr>
|
|
<?php
|
|
$pager = paginate( $sql, 15, 5, "param1=valu1¶m2=value2");
|
|
|
|
//The paginate() function returns a mysql result set
|
|
|
|
|
|
foreach($pager['list'] as $data) {?>
|
|
<tr <?php echo "class =";
|
|
$count++;
|
|
if ($count % 2) {
|
|
echo "tr1"; }
|
|
else {
|
|
echo "tr2";
|
|
}
|
|
?>>
|
|
<td><a href="index.php?link=91&nobatch=<?php echo $data['NO']; ?>"><?php echo $data['NO'];?></a></td>
|
|
<td><?php echo $data['NIP']; ?></td>
|
|
<td><?php echo $data['NIP']; ?></td>
|
|
<td><?php echo $data['DEPARTEMEN']; ?></td>
|
|
<td><?php echo $data['tglpesan']; ?></td>
|
|
</tr>
|
|
<?php }
|
|
|
|
//Display the full navigation in one go
|
|
echo $pager['nav'];
|
|
?>
|
|
|
|
</table>
|
|
|
|
<?php
|
|
|
|
//Display the full navigation in one go
|
|
echo $pager['nav'];
|
|
?>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<p></p>
|