230 lines
9.1 KiB
PHP
230 lines
9.1 KiB
PHP
<?php
|
|
$sub = [];
|
|
|
|
if($page_akses['ranap_reguler']) {
|
|
$db_asalpasien = $db->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')";
|
|
|
|
?>
|
|
|
|
<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-default mask-date-default 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 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%"');
|
|
?>
|
|
</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'])."'";
|
|
$str_by_ruang = "";
|
|
}
|
|
}
|
|
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,e.kelas, a.nott, a.icd_masuk, a.NIP, d.jenis_penyakit,(select nobill from t_billranap where idxdaftar = a.id_admission limit 1) as nobill,case when a.keluarrs is not null then 'Close Billing' when r.statuspulang is not null then 'Pulang' when r.statuspulang is null then 'Belum Pulang' end as statuspulang
|
|
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
|
|
left join t_resumepulang r on a.id_admission = r.idadmission
|
|
WHERE r.statuspulang 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&sub=".$subsistem."&");
|
|
|
|
$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'].' '.$data['kelas']; ?></td>
|
|
<td><?php echo $data['nott']; ?></td>
|
|
<td><?php echo $data['NIP']; ?></td>
|
|
<td><?php echo $data['statuspulang']; ?>
|
|
</td>
|
|
<td>
|
|
<div class="btn-group">
|
|
<?php
|
|
if($data['statuspulang'] == 'Belum Pulang' || $data['statuspulang'] == 'Close Billing'){
|
|
$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='.$link.'&sub='.$subsistem.'" 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';
|
|
}
|
|
?>
|