query('select * from m_dokter_jaga where kdpoly = '.$kdpoly); if($sql->numRows() > 0){ $update = $db->query('update m_dokter_jaga set kddokter = '.$kddokter.' where kdpoly ='.$kdpoly); }else{ $insert = $db->query('insert into m_dokter_jaga '.bind_sql(['kdpoly'=>$kdpoly,'kddokter'=>$kddokter])); } } if(array_key_exists('load_dokterjaga', $_REQUEST) && $_REQUEST['load_dokterjaga'] != ''){ $kdpoly = $_REQUEST['kdpoly']; $sql = $db->query('SELECT a.kddokter as kddokter, b.namadokter, b.tgl_akhir_sip from m_dokter_jaga a join m_dokter b on a.KDDOKTER = b.kddokter where a.kdpoly = \''.$kdpoly.'\' and b.aktif = 1'); if(!$sql) { echo 'Terjadi kesalahan pada sistem'; } else { if($sql->numRows() > 0){ $arr_dokter = [''=>'Pilih Dokter']; foreach($sql->fetchAll() as $data) { $tgl_SIP = new Datetime($data['tgl_akhir_sip']); $tgl_sekarang = new Datetime(date('Y-m-d')); if($d['tgl_akhir_sip'] > '0000-00-00'){ if($tgl_sekarang <= $tgl_SIP) { $arr_dokter[$data['kddokter']] = $data['namadokter']; } } else { $arr_dokter[$data['kddokter']] = $data['namadokter']; } } echo form_dropdown('DOKTERJAGA',$arr_dokter,'','class="form-control"'); }else{ echo 'Tidak ada dokter jaga di poli tersebut'; } } } if(array_key_exists('load_dokterjaga_v2', $_REQUEST) && $_REQUEST['load_dokterjaga_v2'] != ''){ $kdpoly = $_REQUEST['kdpoly']; $sql = $db->query('SELECT a.kddokter as kddokter, b.namadokter, b.tgl_akhir_sip from m_dokter_jaga a join m_dokter b on a.KDDOKTER = b.kddokter where a.kdpoly = \''.$kdpoly.'\' and b.aktif = 1'); if(!$sql) { echo 'Terjadi kesalahan pada sistem'; } else { if($sql->numRows() > 0){ foreach($sql->fetchAll() as $data) { $tgl_SIP = new Datetime($data['tgl_akhir_sip']); $tgl_sekarang = new Datetime(date('Y-m-d')); if($d['tgl_akhir_sip'] > '0000-00-00'){ if($tgl_sekarang <= $tgl_SIP) { $arr_dokter[$data['kddokter']] = $data['namadokter']; } } else { $arr_dokter[$data['kddokter']] = $data['namadokter']; } } echo form_dropdown('input[kddokter]',$arr_dokter,'','class="form-control" id="kddokter"'); }else{ echo 'Tidak ada dokter jaga di poli tersebut'; } } } if(array_key_exists('load_payplan', $_REQUEST) && $_REQUEST['load_payplan'] != ''){ $payplan = $_REQUEST['payplan']; $sql = $db->query('select KODE, NAMA from m_carabayar where KODE > 1'); if($sql->numRows() > 0){ #$data = $sql->fetchAll()[0]; echo ''; }else{ echo '-'; } } # INSERT DOKTER JAGA BARU if(array_key_exists('adddokterjaga', $_REQUEST) && $_REQUEST['adddokterjaga'] != ''){ $poly = $_REQUEST['poly']; $dokter = $_REQUEST['dokter']; $q = $db->query('select * from m_dokter_jaga where kdpoly = "'.$poly.'" AND kddokter ="'.$dokter.'"'); if($q->numRows() > 0): echo 'error'; else: $sql = execute('insert into m_dokter_jaga '.bind_sql(['kdpoly'=>$poly,'kddokter'=>$dokter])); endif; } # LOAD LIST DOKTER JAGA if(array_key_exists('loaddokterjaga', $_REQUEST) && $_REQUEST['loaddokterjaga'] != ''){ $kdpoly = $_GET['loaddokterjaga']; $sql = $db->query("SELECT a.kdpoly,a.kddokter,a.id,b.NAMADOKTER from m_dokter_jaga a join m_dokter b on b.KDDOKTER = a.kddokter where a.kdpoly = '$kdpoly'"); #$sql = $db->query('select kdpoly,kddokter,NAMADOKTER from m_dokter where kdpoly = '.$kdpoly); if($sql->numRows() > 0){ echo ''; foreach($sql->fetchAll() as $data){ echo '

'.$data['NAMADOKTER'].'

Hapus
'; } } } # HAPUS DOKTER JGA if(array_key_exists('removedokterjaga', $_REQUEST) && $_REQUEST['removedokterjaga'] == true){ execute('delete from m_dokter_jaga where id = "'.$_REQUEST['id'].'"'); } if(array_key_exists('rem_tindakanlab', $_REQUEST) && $_REQUEST['rem_tindakanlab'] == 'true'){ $jenis = $_REQUEST['cito_status']; if($jenis == "c"){ $faktor = 1.25; }else{ $faktor = 1; } $db->query('DELETE FROM tmp_orderpenunjang where kode_tindakan = "'.$_REQUEST['kd_tindakan'].'" AND ip = "'.getRealIpAddr().'"'); $sql = $db->query('select a.nama_tindakan, a.qty, a.tarif from tmp_orderpenunjang a where a.ip = "'.getRealIpAddr().'"'); if($sql->numRows() > 0){ $t = 0; echo ''; echo ''; foreach($sql->fetchAll() as $data){ $t = $t + $data['tarif'] * $faktor; echo ''; } echo ''; echo '

Nama Pemeriksaan	Qty	Tarif
'.$data['nama_tindakan'].'	'.$data['qty'].'	'.format_uang($data['tarif'] * $faktor).'
Total		'.format_uang($t).'

'; } } if(array_key_exists('view_detail_bill', $_REQUEST) && $_REQUEST['view_detail_bill'] == 'true'){ $is_batal = (array_key_exists('page_akses', $_REQUEST)) ? $_REQUEST['page_akses']['d'] : null; if($_REQUEST['kode_tarif'] == 'DFAR'){ $sql = $db->query('SELECT a.*, CASE WHEN SUBSTR(a.kode_obat,1,1) = "R" AND LENGTH(a.kode_obat) = 3 THEN "RACIKAN "+SUBSTR(a.kode_obat,2,2) ELSE ( SELECT c.Nama FROM tmlogbarang c WHERE a.kode_obat = c.Kode ) END AS nama_obat FROM t_billobat_rajal a where a.nobill = "'.$_REQUEST['nobill'].'"'); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ echo ''; } echo '

Nama Pemeriksaan	Qty	Tarif
'.$data['nama_obat'].'	'.$data['qty'].'	'.format_uang($data['harga']).'

'; } }else{ $sql = $db->query('select a.*,b.* from t_billrajal a inner join m_tarif_rs b on b.kode_tarif = a.KODETARIF where a.nobill = "'.$_REQUEST['nobill'].'" and a.KODETARIF not like "DFAR"'); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ ?> '; } } } ?> query('SELECT * from m_pasien where nomr = \''.$_REQUEST['nomr'].'\''); $data = $sql->fetchFirst(); $data = implode('|',$data); echo $data; } if(array_key_exists('form_edit_pembayaran', $_REQUEST) && $_REQUEST['form_edit_pembayaran'] == 'true'){ $sql = $db->query('select * from m_carabayar order by ORDERS'); echo ''; } if(array_key_exists('load_kota', $_REQUEST) && $_REQUEST['load_kota'] != ''){ $kdprov = $_REQUEST['kdprov']; if($kdprov != null){ $sql = $db->query('SELECT * from m_kota where idprovinsi = \''.$kdprov.'\' order by idkota ASC'); if($sql->numRows() > 0){ echo ''; }else{ echo 'Tidak ada kota di provinsi tersebut'; } } else { echo ''; } } if(array_key_exists('load_kecamatan', $_REQUEST) && $_REQUEST['load_kecamatan'] != ''){ $kdkota = $_REQUEST['kdkota']; if($kdkota != null){ $sql = $db->query('SELECT * from m_kecamatan where idkota = '.$kdkota.' order by idkecamatan ASC'); if($sql->numRows() > 0){ echo ''; }else{ echo 'Tidak ada kecamatan di kota tersebut'; } } else { echo ''; } } if(array_key_exists('load_kelurahan', $_REQUEST) && $_REQUEST['load_kelurahan'] != ''){ $kdkecamatan = $_REQUEST['kdkecamatan']; if($kdkecamatan != null){ $sql = $db->query('SELECT * from m_kelurahan where idkecamatan = \''.$kdkecamatan.'\' order by idkelurahan ASC'); if($sql->numRows() > 0){ echo ''; }else{ echo 'Tidak ada kelurahan di kecamatan tersebut'; } } else { echo ''; } } if(array_key_exists('dokterpraktek', $_REQUEST) && $_REQUEST['dokterpraktek'] != ''){ $kdpoly = $_REQUEST['kdpoly']; $kddokter = $_REQUEST['kddokter']; $kddokter2 = $_REQUEST['kddokter2']; $sql = $db->query('select * from m_dokter_praktek where kdpoly = '.$kdpoly); if($sql->numRows() > 0){ $update = $db->query('update m_dokter_praktek set kddokter = '.$kddokter.' where kdpoly ='.$kdpoly); }else{ $insert = $db->query('insert into m_dokter_praktek '.bind_sql(['kdpoly'=>$kdpoly,'kddokter'=>$kddokter])); } } if(array_key_exists('dokterjaga', $_REQUEST) && $_REQUEST['add_dokterprak'] != ''){ $poly = $_REQUEST['poly']; $dokter = $_REQUEST['dokter']; $jadwal = $_REQUEST['jadwal']; $start = $_REQUEST['start']; $end = $_REQUEST['end']; $q = $db->query('select * from m_dokter_praktek where KDPOLY = "'.$poly.'" AND KDDOKTER ="'.$dokter.'" AND JADWAL ="'.$jadwal.'"'); if($q->numRows() > 0): echo 'error'; else: $sql = $db->query('insert into m_dokter_praktek '.bind_sql(['kdpoly'=>$poly,'kddokter'=>$dokter,'jadwal'=>$jadwal,'dari_jam'=>$start,'sampai_jam'=>$end])); endif; } if(array_key_exists('loaddokter', $_REQUEST) && $_REQUEST['loaddokter'] != ''){ global $db; $kdpoly = $_GET['loaddokter']; $sql = $db->query('SELECT a.kdpoly,a.kddokter,a.id, b.NAMADOKTER from m_dokter_prakter a join m_dokter b on b.KDDOKTER = a.kddokter where a.kdpoly = '.$kdpoly); if($sql->numRows() > 0){ echo ''; foreach($sql->fetchAll() as $data){ echo '

'.$data['NAMADOKTER'].'

'; } } } if(array_key_exists('removedokter', $_REQUEST) && $_REQUEST['removedokter'] == true){ $db->query('delete from m_dokter_praktek where id = "'.$_REQUEST[id].'"'); } if(array_key_exists('editdokter', $_REQUEST) && $_REQUEST['editdokter'] == true){ // $db->query('update m_dokter_praktek set kddokter = '.$kddokter.' where kdpoly ='.$kdpoly); //$db->query('update m_dokter_praktek set id = "'.$_REQUEST[id].'"'); $kode = $_REQUEST['kode']; $poly = $_REQUEST['poly']; $dokter = $_REQUEST['dokter']; $jadwal = $_REQUEST['jadwal']; $start = $_REQUEST['start']; $end = $_REQUEST['end']; $q = $db->query('select * from m_dokter_praktek where KDPOLY = "'.$poly.'" AND KDDOKTER ="'.$dokter.'" AND JADWAL ="'.$jadwal.'" and id not in '.$kode); if($q->numRows() > 0): echo 'error'; else: $sql = $db->query('update m_dokter_praktek set kdpoly = "'.$poly.'", kddokter = "'.$dokter.'", jadwal = "'.$jadwal.'", dari_jam = "'.$start.'", sampai_jam = "'.$end.'" where id = "'.$kode.'"'); endif; } if(array_key_exists('load_diagnosis', $_REQUEST) && $_REQUEST['load_diagnosis'] != ''){ $iddomain = $_REQUEST['iddomain']; $sql = $db->query('select * from m_diagnosis_kep where id_domain = "'.$iddomain.'" order by id_diagnosis ASC'); if($sql->numRows() > 0){ echo ''; }else{ echo 'Tidak ada diagnosis di domain tersebut'; } } if(array_key_exists('load_sub_var1', $_REQUEST) && $_REQUEST['load_sub_var1'] != ''){ $id_diagnosis = $_REQUEST['id_diagnosis']; $sql = $db->query('select * from m_sub_var1_diagnosa_kep where id_diagnosis = "'.$id_diagnosis.'" order by id_sub_var1 ASC'); if($sql->numRows() > 0){ //$val_1 = split(",",$data['sub_var1']); $i = 0; foreach($sql->fetchAll() as $ds){ echo ' '.$ds['nama_sub_var1'].'
'; } }else{ echo 'Tidak ada daftar gejala - batasan karakteristik di diagnosis tersebut'; } } if(array_key_exists('load_sub_var2', $_REQUEST) && $_REQUEST['load_sub_var2'] != ''){ $id_diagnosis = $_REQUEST['id_diagnosis']; $sql = $db->query('select * from m_sub_var2_diagnosa_kep where id_diagnosis = "'.$id_diagnosis.'" order by id_sub_var2 ASC'); if($sql->numRows() > 0){ //$val_2 = split(",",$data['sub_var2']); $i = 0; foreach($sql->fetchAll() as $ds){ echo ' '.$ds['nama_sub_var2'].'
'; } }else{ echo 'Tidak ada daftar etiologi - faktor resiko di diagnosis tersebut'; } } if(array_key_exists('load_sub_var3', $_REQUEST) && $_REQUEST['load_sub_var3'] != ''){ $id_diagnosis = $_REQUEST['id_diagnosis']; $sql = $db->query('select * from m_sub_var3_diagnosa_kep where id_diagnosis = "'.$id_diagnosis.'" order by id_sub_var3 ASC'); if($sql->numRows() > 0){ //$val_3 = split(",",$data['sub_var3']); $i = 0; foreach($sql->fetchAll() as $ds){ echo ' '.$ds['nama_sub_var3'].'
'; } }else{ echo 'Tidak ada daftar tujuan - outcome (NOC) di diagnosis tersebut'; } } if(array_key_exists('load_sub_var4', $_REQUEST) && $_REQUEST['load_sub_var4'] != ''){ $id_diagnosis = $_REQUEST['id_diagnosis']; $sql = $db->query('select * from m_sub_var4_diagnosa_kep where id_diagnosis = "'.$id_diagnosis.'" order by id_sub_var4 ASC'); if($sql->numRows() > 0){ //$val_4 = split(",",$data['sub_var4']); $i = 0; foreach($sql->fetchAll() as $ds){ echo ' '.$ds['nama_sub_var4'].'
'; } }else{ echo 'Tidak ada daftar intervensi (NIC) di diagnosis tersebut'; } }

Nama Pemeriksaan	Qty	Tarif
			svn= class="btn btn-outline-danger btn-sm cancel_btn" />