235 lines
8.8 KiB
PHP
235 lines
8.8 KiB
PHP
<?php
|
|
$sub = [];
|
|
|
|
if($page_akses['ranap_highcare']) {
|
|
$db_asalpasien = $db->query("SELECT nama_asal from m_asalranap where nama_asal like '%HIGH%'");
|
|
$data_asal = $db_asalpasien->fetchFirst();
|
|
$sub[] = $data_asal['nama_asal'];
|
|
$link = '12highcare';
|
|
}
|
|
|
|
$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."' and a.keluarrs is null ";
|
|
}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 = '".$norm."' ";
|
|
}
|
|
|
|
$nama = "";
|
|
if(array_key_exists('nama', $_GET) && !empty($_GET['nama'])) {
|
|
$nama =$_GET['nama'];
|
|
}
|
|
|
|
if($nama !="") {
|
|
$search = " AND b.nama LIKE '%".$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')";
|
|
|
|
?>
|
|
|
|
<div align="center">
|
|
<div id="frame">
|
|
<div id="frame_title">
|
|
<h5>LIST KUNJUNGAN <?php echo $subsistem; ?></h5></div>
|
|
<div align="right" style="margin:5px;">
|
|
<form name="formsearch" method="get" >
|
|
<input type="hidden" name="link" value="<?php echo $link; ?>" />
|
|
<input type="hidden" name="sub" value="<?php echo $subsistem; ?>" />
|
|
<div class="row">
|
|
<div class="col-md-3 offset-md-6" style="text-align: left">
|
|
<div class="form-group row">
|
|
<label class="col-sm-3 col-form-label" style="text-align:left">No RM </label>
|
|
<div class="col-sm-9">
|
|
<input type="text" name="norm" id="norm" value="<?php if($norm!=""){echo $norm;}?>" class="form-control form-control-sm text" >
|
|
</div>
|
|
</div>
|
|
<div class="form-group row">
|
|
<label class="col-sm-3 col-form-label" style="text-align:left">Nama</label>
|
|
<div class="col-sm-9">
|
|
<input type="text" name="nama" id="nama" value="<?php if($nama!="") {echo $nama; }?>" class="form-control form-control-sm text">
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-3">
|
|
<div class="form-group row">
|
|
<label class="col-sm-3 col-form-label" style="text-align:left">Tanggal </label>
|
|
<div class="col-sm-9">
|
|
<input type="text" name="tgl_kunjungan" id="tgl_pesan" class="datepicker-filter mask-date-filter form-control form-control-sm text" value="<?php if(array_key_exists('tgl_kunjungan', $_REQUEST) && $_REQUEST['tgl_kunjungan'] !=""): echo $_REQUEST['tgl_kunjungan']; else: echo date('Y/m/d'); endif;
|
|
?>" readonly>
|
|
</div>
|
|
<!-- <div class="col-sm-9 offset-sm-3">
|
|
<input type="text" name="tgl_kunjungan2" id="tgl_pesan2" class="datepicker-filter mask-date-filter form-control form-control-sm text" value="<?php if(array_key_exists('tgl_kunjungan2', $_REQUEST) && $_REQUEST['tgl_kunjungan2'] !=""): echo $_REQUEST['tgl_kunjungan2']; else: echo date('Y/m/d'); endif;
|
|
?>" readonly>
|
|
</div> -->
|
|
</div>
|
|
<div class="form-group row">
|
|
<label class="col-sm-3 col-form-label" style="text-align:left">Ruang </label>
|
|
<div class="col-sm-9">
|
|
<?php
|
|
$QRY_RUANG = $db->query("SELECT * FROM m_ruang 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%"');
|
|
?>
|
|
</select>
|
|
</div>
|
|
</div>
|
|
<div class="form-group row">
|
|
<label class="col-sm-3 col-form-label" style="text-align:left"> </label>
|
|
<div class="col-sm-6">
|
|
<input type="submit" value=" C a r i " class="btn btn-sm btn-primary btn-block text"/>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
</form>
|
|
|
|
|
|
<div id="table_search">
|
|
<table class="table table-hover table-bordered table-striped table-sm" width="95%" style="margin:10px;" border="0" cellspacing="1" cellpadding="1">
|
|
<tr align="center" class="bg-success text-light">
|
|
<th>NOMR</th>
|
|
<th>NOBILL</th>
|
|
<th>Nama Pasien</th>
|
|
<th>Alamat Pasien</th>
|
|
<th>Jenis Pembayaran</th>
|
|
<th>Tanggal Masuk RS</th>
|
|
<th>Tanggal Pindah</th>
|
|
<th>Nama Ruang</th>
|
|
<th>No Bed</th>
|
|
<th>Admin</th>
|
|
<th>Status Pasien</th>
|
|
<th>Aksi</th>
|
|
</tr>
|
|
<?php
|
|
if($_SESSION['NIP'] != 'ranap') {
|
|
if($_SESSION['KDDOKTER'] != null) {
|
|
$str_by_ruang = '';
|
|
}
|
|
else if($_SESSION['KDPERAWAT'] != null){
|
|
$str_by_ruang = "and e.kelompok = '".trim($_SESSION['SES_KELRUANG'])."'";
|
|
}
|
|
}
|
|
else {
|
|
$str_by_ruang = '';
|
|
}
|
|
$sql = "SELECT a.id_admission, a.keluarrs, b.nama as namapasien, a.tgl_pindah, a.nomr, b.alamat, a.statusbayar, c.nama as jenisbayar, a.masukrs, a.noruang, e.nama, a.nott, a.icd_masuk, a.NIP, d.jenis_penyakit ,(select nobill from t_billranap where idxdaftar = a.id_admission limit 1) as nobill
|
|
FROM t_admission a
|
|
inner join m_pasien b on a.nomr=b.nomr
|
|
inner join m_carabayar c on a.statusbayar=c.kode
|
|
left join icd d on a.icd_masuk=d.icd_code
|
|
inner join m_ruang e on a.noruang=e.no and e.subsistem = '$subsistem'
|
|
WHERE keluarrs is null ".$search." $str_by_ruang ORDER BY a.nott ASC";
|
|
|
|
$pager = paginate( $sql, 15, 5, "tgl_kunjungan=".$tgl_kunjungan."&ruang=".$ruang."&nama=".$nama."&nomr=".$norm,"index.php?link=12&");
|
|
|
|
$count = 0;
|
|
foreach($pager['list'] as $data) {
|
|
?>
|
|
<tr <?php echo "class =";
|
|
$count++;
|
|
if ($count % 2) {
|
|
echo "tr1"; }
|
|
else {
|
|
echo "tr2";
|
|
}
|
|
?>>
|
|
<td><?php echo $data['nomr'];?></td>
|
|
<td><?php echo $data['nobill'];?></td>
|
|
<td><?php echo $data['namapasien']; ?></td>
|
|
<td><?php echo $data['alamat']; ?></td>
|
|
<td><?php echo $data['jenisbayar']; ?></td>
|
|
<td><?php echo $data['masukrs']; ?></td>
|
|
<td><?php if($data['tgl_pindah']=="0000-00-00"){echo "-";}else{ echo $data['tgl_pindah']; } ?></td>
|
|
<td><?php echo $data['nama']; ?></td>
|
|
<td><?php echo $data['nott']; ?></td>
|
|
<td><?php echo $data['NIP']; ?></td>
|
|
<td><?php
|
|
if($data['keluarrs'] == NULL){
|
|
echo "Belum Pulang";
|
|
}else{
|
|
echo "Sudah Pulang";
|
|
}
|
|
?>
|
|
</td>
|
|
<td>
|
|
<div class="btn-group">
|
|
<?php
|
|
if($data['keluarrs'] == NULL){
|
|
$btn_proses = ($_SESSION['KDUNIT'] != 70) ? '<a href="index.php?link=121&id_admission='.$data['id_admission'].'" class="btn btn-outline-primary btn-sm">Proses</a>' : '<a href="index.php?link=proses_tindakan&rajal_status=0&id_admission='.$data['id_admission'].'" class="btn btn-outline-primary btn-sm">Proses Tindakan</a>';
|
|
$btn_pindah = '<a href="index.php?link=175&indeks='.$data['id_admission'].'&historyback='.$_REQUEST['link'].'" class="btn btn-outline-secondary btn-sm">Pindah</a>';
|
|
$btn_batalpulang = '';
|
|
}else{
|
|
$btn_proses = $btn_pindah = '';
|
|
$btn_batalpulang = '<a href="index.php?link=129z&indeks='.$data['id_admission'].'&no_ruang='.$data['noruang'].'¬t='.$data['nott'].'" class="btn btn-outline-secondary btn-sm" >Batal Pulang</a>';
|
|
|
|
}
|
|
if($_SESSION['KDUNIT'] == 70) {
|
|
echo $btn_proses;
|
|
}
|
|
else {
|
|
echo $btn_proses.$btn_pindah.$btn_batalpulang;
|
|
}
|
|
?>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
<?php } ?>
|
|
|
|
</table>
|
|
</div>
|
|
|
|
<?php
|
|
//Display the full navigation in one go
|
|
echo $pager['nav'];
|
|
?>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<br />
|
|
<?php
|
|
}
|
|
else {
|
|
require_once _DOCROOT_.'error404.php';
|
|
}
|
|
?>
|