'BATAL'
UNION ALL
";
$sql_billanak = "
SELECT l.lunas, d.uraian_tarif as nama_jasa, b.idxdaftar, b.tarifrs,b.qty
FROM t_billrajal b
left join t_pendaftaran c on c.idxdaftar=b.idxdaftar
left join m_tarif_rs d on b.kodetarif = d.kode_tarif
left join t_admission e on e.nomr=b.nomr
left join m_statuskeluar k on c.status=k.status
left join t_bayarrajal l on l.idxbill=b.idxbill
left join m_pasien x on b.nomr = x.nomr
WHERE x.PARENT_NOMR='{$_REQUEST['nomr']}'
UNION ALL";
// sql get kunjungan poliklinik
$sql = '';
$tmp_sql = $db->query("SELECT kdpoly from t_pendaftaran where idxdaftar = {$_REQUEST['idx']}");
$dt_kunjungan = $tmp_sql->fetchFirst();
if($dt_kunjungan['kdpoly'] == $_SESSION['poli_igd']) {
$sql .= $sql_billrajal;
}
$sql .= "SELECT distinct b.idxbill,b.tanggal,b.nobill,b.nonota,l.lunas ,d.kode_tarif,case when b.kodetarif in ('DEPOSIT','IURBEA') then b.kodetarif else d.uraian_tarif end as nama_jasa, b.idxdaftar, b.tarifrs,b.qty
FROM t_billranap b
left join m_tarif_rs d on b.kodetarif = d.kode_tarif
left join t_admission e on e.nomr=b.nomr
left join t_bayarranap l on l.idxbill=b.idxbill
WHERE b.idxdaftar={$_REQUEST['idx']} and b.kodetarif not in ('DEPOSIT') and tarifrs > 0 and b.status <> 'BATAL'
ORDER BY nonota
";
$total = 0;
$no = 1;
$tot = 0;
$qry = $db->query($sql);
foreach($qry->fetchAll() as $data) {
$tot = $tot + ( $data['qty'] * $data['tarifrs']);
?>