query($sql);
$jml_data = $qry->numRows();
$all_data_bill = $qry->fetchAll();
}
elseif($_REQUEST['by'] == 'ranap') {
$q_pasien = 'SELECT distinct a.nomr, b.nama, b.alamat, b.jeniskelamin, b.tgllahir, b.parent_nomr, c.statusbayar, e.nama as carabayar, c.noruang, d.nama as nama_poly, c.nott, a.nobill, (select sum(tarifrs * qty) from t_billranap where nobill = a.nobill and t_billranap.status <> \'BATAL\') as tottarifrs, (select sum(discount) from t_bayarranap where nobill = a.nobill) as discount, (select sum(coalesce(costsharing_pelayanan,0)+coalesce(costsharing_anastesi,0)+coalesce(costsharing_sarana,0)) as total from t_billranap where nobill = a.nobill and t_billranap.status <> \'BATAL\') as totcostsharing, (select sum(deposit) from t_deposit where t_deposit.nobill::integer = a.nobill and t_deposit.st_batal is null group by nobill) as deposit, c.masukrs, d.kelas, c.keluarrs, c.tgl_pindah, d.idx_ruang,t.uraian_tarif
FROM t_billranap a
JOIN m_pasien b ON a.nomr = b.nomr
JOIN t_admission c ON a.IDXDAFTAR = c.id_admission
JOIN m_ruang d ON c.noruang = d.no
JOIN m_carabayar e ON c.statusbayar = e.KODE
JOIN t_bayarranap f ON a.idxbill = f.idxbill
LEFT JOIN m_tarif_rs t on a.kodetarif = t.kode_tarif
WHERE a.IDXDAFTAR = '.$_REQUEST['idxb'].' and a.NOBILL = '.$_REQUEST['nobill'].' and a.STATUS!=\'BATAL\'';
if(array_key_exists('nonota',$_REQUEST) && $_REQUEST['nonota'] != '') {
$where_nonota = " and b.nonota = '{$_REQUEST['nonota']}'";
}
$sql = "SELECT distinct a.uraian_tarif as nama_jasa, b.nonota, b.idxbill, b.carabayar as kdcarabayar, h.status as st_bayar,h.st_carabayar, h.kd_penjamin, b.idxbill, b.tanggal, b.qty, c.nama as carabayar, b.nobill,b.idxdaftar,a.kode_tarif, cb.nama_cara_bayar, p.nama_penjamin, b.status_verifikasi, h.jmbayar, h.tglbayar, b.status,tp.jml_piutang, tp.st_piutang,b.tarifrs,b.jasa_sarana,b.jasa_pelayanan,b.jasa_anastesi
FROM t_billranap b
JOIN t_bayarranap h on b.IDXBILL = h.IDXBILL
JOIN m_carabayar c on c.KODE = b.CARABAYAR
LEFT JOIN m_tarif_rs a on a.kode_tarif=b.KODETARIF
LEFT JOIN m_cara_bayar cb on cb.id_cara_bayar = h.st_carabayar
LEFT JOIN m_penjamin p on p.id_penjamin = h.kd_penjamin
LEFT JOIN ( select idxbill, count(id_piutang) as jml_piutang, st_piutang from t_piutang where nobilling = '{$_REQUEST['nobill']}' and st_billing = 'IRNA' and st_piutang is null group by idxbill,st_billing,st_piutang) tp on b.idxbill = tp.idxbill
WHERE b.idxdaftar='{$_REQUEST['idxb']}' and b.nobill='{$_REQUEST['nobill']}' $where_nonota and h.STATUS !='BATAL' and b.tarifrs > 0
ORDER BY b.nonota desc";
$qry = $db->query($sql);
$jml_data = $qry->numRows();
$all_data_bill = $qry->fetchAll();
}
elseif($_REQUEST['by'] == 'nonreg') {
$q_pasien = 'SELECT distinct a.no_nonreg as nomr, b.nama, b.alamat, null as jeniskelamin, null as tgllahir, b.carabayar as statusbayar, e.nama as carabayar, d.nama as nama_poly, a.nobill, b.tgl_entri as masukrs, b.tgl_entri as keluarrs, t.uraian_tarif
FROM t_billnonreg a
JOIN m_nonreg b ON a.no_nonreg = b.no_nonreg
JOIN m_ruang d ON b.ruang = d.no
JOIN m_carabayar e ON b.carabayar = e.KODE
JOIN t_bayarnonreg f ON a.idxbill = f.idxbill
LEFT JOIN m_tarif_rs t on a.kodetarif = t.kode_tarif
WHERE a.idx_nonreg = '.$_REQUEST['idx_nonreg'].' and a.NOBILL = '.$_REQUEST['nobill'].' and a.STATUS!=\'BATAL\'';
if(array_key_exists('nonota',$_REQUEST) && $_REQUEST['nonota'] != '') {
$where_nonota = " and b.nonota = '{$_REQUEST['nonota']}'";
}
$sql = "SELECT distinct a.uraian_tarif as nama_jasa, b.nonota, b.idxbill, b.carabayar as kdcarabayar, h.status as st_bayar,h.st_carabayar, h.kd_penjamin, b.idxbill, b.tanggal, b.qty, c.nama as carabayar, b.nobill,b.idx_nonreg as idxdaftar,a.kode_tarif, cb.nama_cara_bayar, p.nama_penjamin, b.status_verifikasi, h.jmbayar, h.tglbayar, b.status,tp.jml_piutang, tp.st_piutang,b.tarifrs,b.jasa_sarana,b.jasa_pelayanan,b.jasa_anastesi
FROM t_billnonreg b
JOIN t_bayarnonreg h on b.IDXBILL = h.IDXBILL
JOIN m_carabayar c on c.KODE = b.CARABAYAR
LEFT JOIN m_tarif_rs a on a.kode_tarif=b.KODETARIF
LEFT JOIN m_cara_bayar cb on cb.id_cara_bayar = h.st_carabayar
LEFT JOIN m_penjamin p on p.id_penjamin = h.kd_penjamin
LEFT JOIN ( select idxbill, count(id_piutang) as jml_piutang, st_piutang from t_piutang where nobilling = '{$_REQUEST['nobill']}' and st_billing = 'NONREG' and st_piutang is null group by idxbill,st_billing,st_piutang) tp on b.idxbill = tp.idxbill
WHERE b.idx_nonreg='{$_REQUEST['idx_nonreg']}' and b.nobill='{$_REQUEST['nobill']}' $where_nonota and h.STATUS !='BATAL' and b.tarifrs > 0
ORDER BY b.nonota desc";
$qry = $db->query($sql);
$jml_data = $qry->numRows();
$all_data_bill = $qry->fetchAll();
}
$get = $db->query($q_pasien);
$userdata = $get->fetchFirst();
$ss = $db->query('SELECT * FROM m_shift order by idshift ASC');
$arr_shift = array(''=>'Pilih Shift');
foreach($ss->fetchAll() as $ds){
$arr_shift[$ds['idshift']] = $ds['nama_shift'];
}
$m_cara_bayar = $db->query('SELECT * FROM m_cara_bayar');
$arr_cara_bayar = array(''=>'Pilih');
foreach($m_cara_bayar->fetchAll() as $ds){
$arr_cara_bayar[$ds['id_cara_bayar']] = $ds['nama_cara_bayar'];
}
$m_penjamin = $db->query('SELECT * FROM m_penjamin where aktif = 1::bit order by id_penjamin');
$arr_penjamin = array();
foreach($m_penjamin->fetchAll() as $ds){
$arr_penjamin[$ds['id_penjamin']] = trim($ds['nama_penjamin']);
}
$tgl_masuk = new DateTime(datetime_to_date_en($userdata['masukrs']));
$tgl_pulang = new DateTime(datetime_to_date_en($userdata['keluarrs']));
$tgl_pulang->add(new DateInterval('P1D'));
$selisih = $tgl_pulang->diff($tgl_masuk);
$jumlah_hari_rawat = $selisih->format("%a");
$a = ($userdata['tgllahir'] != null) ? datediff($userdata['tgllahir'], date("Y-m-d")) : ['years'=>'','months'=>'','days'=>''];
$view = $calculator_css.'