63 lines
2.4 KiB
PHP
63 lines
2.4 KiB
PHP
<?php
|
|
include("core/main.php");
|
|
|
|
?>
|
|
|
|
<div align="center">
|
|
<div id="frame" style="width:80%;">
|
|
<div id="frame_title">
|
|
<h5>DETIL PENDAPATAN</h5></div>
|
|
<div align="right" style="margin:5px;">
|
|
|
|
<div id="table_search">
|
|
<table width="95%" border="0" class="tb" cellspacing="0" cellspading="0">
|
|
<tr align="center">
|
|
<th width="11%">NOMR</th>
|
|
<th width="26%">NAMA</th>
|
|
<th width="18%">BESAR UANG</th>
|
|
<!--<th width="17%">TBP</th>-->
|
|
<th width="28%">RETRIBUSI</th>
|
|
</tr>
|
|
<?php
|
|
|
|
$sql = "SELECT a.NOMR, c.NAMA, a.kodetarif,b.NAMA_JASA, a.IDXDAFTAR, d.TBP, a.TARIFRS * a.QTY AS TARIFRS, e.nama AS ruang
|
|
FROM t_billranap a, m_tarif b, m_pasien c, t_bayarranap d, m_ruang e, t_admission f
|
|
WHERE a.shift='$shift' AND d.TGLBAYAR='$tglbayar' and a.kodetarif=b.kode AND a.nomr=c.nomr and a.idxdaftar=d.idxdaftar AND d.nobill=a.nobill AND e.no=f.noruang AND d.idxdaftar=f.id_admission ";
|
|
|
|
$pager = paginate( $sql, 15, 5, "param1=valu1¶m2=value2");
|
|
|
|
//The paginate() function returns a mysql result set
|
|
|
|
|
|
foreach($pager['list'] as $data) {?>
|
|
<tr align="center" <?php echo "class =";
|
|
$count++;
|
|
if ($count % 2) {
|
|
echo "tr1"; }
|
|
else {
|
|
echo "tr2";
|
|
}
|
|
?>>
|
|
<td><strong><?php echo $data['NOMR'];?></strong></td>
|
|
<td><a href="index.php?link=32rd&idxb=<?=$data['IDXDAFTAR']?>"><?php echo $data['NAMA'];?></a></td>
|
|
<td align="right"><?php echo "Rp. ".number_format($data['TARIFRS'], 0).",00";?></td>
|
|
<!--<td><?php echo $data['TBP']; ?></td>-->
|
|
<td align="left"><?php echo $data['NAMA_JASA'];?></td>
|
|
</tr>
|
|
<?php } ?>
|
|
</table>
|
|
<?php
|
|
|
|
//Display the full navigation in one go
|
|
echo $pager['nav'];
|
|
?>
|
|
<form action="gudang/excelexport.php" enctype="multipart/form-data" method="post">
|
|
<input type="hidden" value="<?php echo $sql; ?>" name="query" />
|
|
<input type="hidden" value="<?php echo "DetilPendapatanRanap"; ?>" name="header" />
|
|
<input type="hidden" value="<?php echo "DetilPendapatanRanap"; ?>" name="filename" />
|
|
<input type="submit" value="Export To Excel" class="text"/>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|