query($sql); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ $j = str_replace('.','_',$data['kode_tindakan']); $trif = $data['tarif']; $adm = $data['tarif']*0.05; $disc = 0; if($kelas == 'P3'){ $sql_check = 'SELECT a.PARENT_NOMR, b.noruang, c.nama, b.nott, c.kelas FROM m_pasien a JOIN t_admission b ON b.nomr = a.PARENT_NOMR JOIN m_ruang c ON c.no = b.noruang WHERE a.NOMR = "'.$nomr.'"'; #$ssql = 'SELECT a.nomr, a.noruang, r.kelas, t.tarif #FROM t_admission a #JOIN m_ruang r ON r.no = a.noruang #JOIN m_tarif2012 t ON t.kelas = r.kelas #WHERE a.nomr = "'.$nomr.'" AND t.kode_gruptindakan = "03.01.01" and a.keluarrs is null'; $sqlparent = $db->query($sql_check); if($sqlparent->numRows() > 0){ $trif = $data['tarif'] * 0.5; $disc = $data['tarif'] - $trif; }else{ echo 'Orang Tua Pasien Tidak Terdaftar'; $trif = $data['tarif']; } } echo ''; } echo '

Nama Tindakan	Tarif	Dokter	Aksi
'.$data['nama_tindakan'].'	'.curformat($trif).'	'; $sqld = $db->query('SELECT DISTINCT NAMADOKTER, KDDOKTER as kddokter FROM m_dokter GROUP BY NAMADOKTER ORDER BY NAMADOKTER ASC'); if($sqld->numRows() > 0){ echo ''; } echo '

'; } }elseif($kode == '03.02'){ $kode_tindakan = '03.02.01'; $kelas = $_REQUEST['kelas']; $profesi = getProfesiDoktor($_REQUEST['dokter']); #$sql = 'select * from m_tarif2012 where kode_gruptindakan = "'.$kode_tindakan.'" and kelas = "'.$kelas.'" and kode_profesi = "'.$profesi.'"'; $sql = 'select * from m_tarif2012 where kode_gruptindakan = "'.$kode_tindakan.'" and kelas = "'.$kelas.'"'; $sql = $db->query($sql); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ $j = str_replace('.','_',$data['kode_tindakan']); #$adm=$data['tarif']*0.05; echo ''; echo ''; } echo '

Nama Tindakan	Tarif	Dokter	Aksi
'.$data['nama_tindakan'].'	'.curformat($data['tarif']).'	'; #$sqld = $db->query('select a.*, b.NAMADOKTER from m_dokter_pengganti a join m_dokter b on b.KDDOKTER = a.kddokter'); $sqld = $db->query('SELECT DISTINCT NAMADOKTER, KDDOKTER as kddokter FROM m_dokter where KDPROFESI = "'.$data['kode_profesi'].'" GROUP BY NAMADOKTER ORDER BY NAMADOKTER ASC'); if($sqld->numRows() > 0){ echo ''; } // echo '

'; } }elseif($kode == '03.03'){ $kelas = $_REQUEST['kelas']; $kode_tindakan = '03.03.01'; $profesi = getProfesiDoktor($_REQUEST['dokter']); $sql = 'select * from m_tarif2012 where kode_gruptindakan = "'.$kode_tindakan.'" and kelas = "'.$kelas.'"'; $sql = $db->query($sql); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ $j = str_replace('.','_',$data['kode_tindakan']); $adm=$data['tarif']*0.05; echo ''; } echo '

Nama Tindakan	Tarif	Dokter	Aksi
'.$data['nama_tindakan'].'	'.curformat($data['tarif']).'	'; #$sqld = $db->query('select a.*, b.NAMADOKTER from m_dokter_pengganti a join m_dokter b on b.KDDOKTER = a.kddokter'); $sqld = $db->query('SELECT DISTINCT NAMADOKTER, KDDOKTER as kddokter FROM m_dokter GROUP BY NAMADOKTER ORDER BY NAMADOKTER ASC'); if($sqld->numRows() > 0){ echo ''; } echo '

'; } }elseif($kode == '03.05'){ $kelas = $_REQUEST['kelas']; echo '

'.$data['nama_tindakan'].'

'; echo '

'; $sql2 = $db->query('select * from m_tarif2012 where kode_gruptindakan = "'.$kode.'"'); $i = 1; foreach($sql2->fetchAll() as $datas){ echo '

'; $sql = 'select * from m_tarif2012 where kode_gruptindakan = "'.$datas['kode_tindakan'].'" and kelas = "'.$kelas.'"'; $sql = $db->query($sql); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ $adm=$data['tarif']*0.05; $j = str_replace('.','_',$data['kode_tindakan']); echo ''; } echo '

Nama Tindakan	Tarif	Dokter	Aksi
'.$data['nama_tindakan'].'	'.curformat($data['tarif']).'	'; $sqld = $db->query('SELECT DISTINCT NAMADOKTER, KDDOKTER as kddokter FROM m_dokter GROUP BY NAMADOKTER ORDER BY NAMADOKTER ASC'); if($sqld->numRows() > 0){ echo ''; } echo '

'; } echo '

'; $i++; } echo '

'; } elseif($kode == 'cari'){ $kelas = $_REQUEST['kelas']; $sql = "SELECT * from m_tarif2012 where status_aktif = '1' and tarif > 0 "; if($_POST['search_op'] == '=') { $sql .= "AND ".$_POST['search_by']." = '".$_POST['search_key']."'"; } elseif($_POST['search_op'] == 'like%') { $sql .= "AND ".$_POST['search_by']." like '".$_POST['search_key']."%'"; } elseif($_POST['search_op'] == '%like%') { $sql .= "AND ".$_POST['search_by']." like '%".$_POST['search_key']."%'"; } elseif($_POST['search_op'] == '%like%') { $sql .= "AND ".$_POST['search_by']." like '%".$_POST['search_key']."'"; } $sql .= " ORDER BY nama_tindakan"; // echo '

'.$sql.'

';exit; $sql = $db->query($sql); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ $j = str_replace('.','_',$data['kode_tindakan']); $trif = $data['tarif']; $adm = $data['tarif']*0.05; $disc = 0; if($kelas == 'P3'){ $sql_check = 'SELECT a.PARENT_NOMR, b.noruang, c.nama, b.nott, c.kelas FROM m_pasien a JOIN t_admission b ON b.nomr = a.PARENT_NOMR JOIN m_ruang c ON c.no = b.noruang WHERE a.NOMR = "'.$nomr.'"'; $sqlparent = $db->query($sql_check); if($sqlparent->numRows() > 0){ $trif = $data['tarif'] * 0.5; $disc = $data['tarif'] - $trif; }else{ echo 'Orang Tua Pasien Tidak Terdaftar'; $trif = $data['tarif']; } } echo ''; } echo '

Nama Tindakan	Tarif	Dokter	Aksi
'.$data['nama_tindakan'].'	'.curformat($trif).'	'; $sqld = $db->query('SELECT DISTINCT NAMADOKTER, KDDOKTER as kddokter FROM m_dokter GROUP BY NAMADOKTER ORDER BY NAMADOKTER ASC'); if($sqld->numRows() > 0){ echo ''; } echo '

'; } } ?>