query("SELECT a.nobill,a.nomr,a.idxdaftar,a.kodetarif,t.uraian_tarif,a.idxbill,a.tarifrs,b.kdpoly as kode_tempat,c.nama,c.alamat,c.notelp,d.nama as tempat_layanan,1 as st_rajal, case when r.idxrestitusi is not null then 1 else 0 end as st_restitusi from
t_billrajal a
join t_bayarrajal aa on a.idxbill = aa.idxbill
JOIN t_pendaftaran b on a.idxdaftar = b.idxdaftar
join m_pasien c on a.nomr = c.nomr
join m_ruang d on b.kdpoly = d.no
join m_tarif_rs t on a.kodetarif = t.kode_tarif
left join t_billrestitusi r on a.idxbill = r.idxbill_rajal and r.sistem = 'IRJA'
where a.nobill = '$nobill' and b.status = 0 and aa.lunas = 1
UNION
SELECT a.nobill,a.nomr,a.idxdaftar,a.kodetarif,t.uraian_tarif,a.idxbill,a.tarifrs,b.noruang as kode_tempat,c.nama,c.alamat,c.notelp,d.nama as tempat_layanan,0 as st_rajal, case when r.idxrestitusi is not null then 1 else 0 end as st_restitusi from
t_billranap a
join t_bayarranap aa on a.idxbill = aa.idxbill
JOIN t_admission b on a.idxdaftar = b.id_admission
join m_pasien c on a.nomr = c.nomr
join m_ruang d on b.noruang = d.no
join m_tarif_rs t on a.kodetarif = t.kode_tarif
left join t_billrestitusi r on a.idxbill = r.idxbill_ranap and r.sistem = 'IRNA'
where a.nobill = '$nobill' and b.keluarrs is not null and aa.lunas = 1
");
if($tmp_identitas->numRows() > 0)
{
$arr_pasien = [];
$i = 0;
$html_tindakan = '';
foreach($tmp_identitas->fetchAll() as $row) {
if($i == 0) {
$arr_pasien = $row;
}
$cb_restitusi = ($row['st_restitusi'] == 1) ? '' : '';
$hidden_form = '';
$html_tindakan .= '