query("SELECT nama_asal from m_asalranap where nama_asal like '%REGULER%'"); $data_asal = $db_asalpasien->fetchFirst(); $sub[] = $data_asal['nama_asal']; $link = '12'; } $tgl_kunjungan = ""; if(array_key_exists('tgl_kunjungan', $_GET) && !empty($_GET['tgl_kunjungan'])) { $tgl_kunjungan =$_GET['tgl_kunjungan']; } $tgl_kunjungan2 = ""; if(array_key_exists('tgl_kunjungan2', $_GET) && !empty($_GET['tgl_kunjungan2'])) { $tgl_kunjungan2 =$_GET['tgl_kunjungan2']; } $search = ""; if($tgl_kunjungan !="") { $search = " AND DATE(a.masukrs) <= '".$tgl_kunjungan."' "; }else { // $search = " DATE(a.masukrs) = '".date('Y-m-d')."'"; } $ruang = ""; if(array_key_exists('ruang', $_GET) && !empty($_GET['ruang'])) { $ruang = $_GET['ruang']; if($ruang !="-Pilih Ruang-") { $search .= " AND a.noruang ='".$ruang."' "; } } $norm = ""; if(array_key_exists('norm', $_GET) && !empty($_GET['norm'])) { $norm =$_GET['norm']; } if($norm !="") { $search .= " AND b.nomr = '".$db->escape($norm)."' "; } $nama = ""; if(array_key_exists('nama', $_GET) && !empty($_GET['nama'])) { $nama =$_GET['nama']; } if($nama !="") { $search = " AND b.nama ILIKE '%".$db->escape($nama)."%' "; } if(array_key_exists('sub', $_REQUEST) && $_REQUEST['sub'] != ''){ $subsistem = $_REQUEST['sub']; } if($subsistem != '' && in_array($subsistem, $sub)) { // $search .= " and a.st_asal_masuk in ('$subsistem')"; ?>
LIST KUNJUNGAN
" class="form-control form-control-sm text" >
" class="form-control form-control-sm text">
" readonly>
query("SELECT * FROM m_ruang where st_aktif = 1 ORDER BY no ASC"); $arr_ruang[''] = '-- Pilih Ruang --'; foreach($QRY_RUANG->fetchAll() as $r) { $arr_ruang[$r['no']] = $r['nama'].' - '.$r['kelas']; } echo form_dropdown('ruang',$arr_ruang,$_GET['ruang'],'class="form-control" style="width:100%"'); ?>