215 lines
8.7 KiB
PHP
215 lines
8.7 KiB
PHP
<?php
|
|
require_once '../core/main.php';
|
|
|
|
if (array_key_exists('filter', $_REQUEST) && $_REQUEST['filter']) {
|
|
$tgl_awal = $_REQUEST['tgl_awal'];
|
|
$tgl_akhir = $_REQUEST['tgl_akhir'];
|
|
$norm = $_REQUEST['nomr'];
|
|
|
|
if ($tgl_awal != '' && $tgl_akhir == '') {
|
|
$where_tgl = " and date(tgl) >= '{$tgl_awal}'";
|
|
} elseif ($tgl_awal == '' && $tgl_akhir != '') {
|
|
$where_tgl = " and date(tgl) <= '{$tgl_akhir}'";
|
|
} elseif ($tgl_awal != '' && $tgl_akhir != '') {
|
|
$where_tgl = " and date(tgl) between '{$tgl_awal}' and '{$tgl_akhir}'";
|
|
}
|
|
|
|
$query_hist = "SELECT a.*,case when (a.perawat <> 0 ) then b.NAMA when a.kddokter is not null then c.NAMADOKTER end as nama_ppa,d.nama_ppa as jenis_ppa
|
|
FROM t_detail_diagnosakep a
|
|
left join m_perawat b on a.perawat = b.IDPERAWAT
|
|
left join m_dokter c on a.kddokter = c.KDDOKTER
|
|
left join m_ppa d on a.kategori = d.id_ppa
|
|
WHERE (a.nomr = '" . $norm . "')
|
|
ORDER BY a.tgl";
|
|
|
|
$query_hist_filter = "SELECT a.*,case when (a.perawat <> 0 ) then b.NAMA when a.kddokter is not null then c.NAMADOKTER end as nama_ppa,d.nama_ppa as jenis_ppa
|
|
FROM t_detail_diagnosakep a
|
|
left join m_perawat b on a.perawat = b.IDPERAWAT
|
|
left join m_dokter c on a.kddokter = c.KDDOKTER
|
|
left join m_ppa d on a.kategori = d.id_ppa
|
|
WHERE (a.nomr = '" . $norm . "') $where_tgl
|
|
ORDER BY a.tgl";
|
|
|
|
$tmp_hist_all = $db->query($query_hist);
|
|
$tmp_hist_filter = $db->query($query_hist_filter);
|
|
$html = '';
|
|
if ($tmp_hist_filter->numRows() > 0) {
|
|
$no = 1;
|
|
$flag_dokter = '';
|
|
foreach ($tmp_hist_filter->fetchAll() as $row) {
|
|
|
|
$arr_data[] = [
|
|
'id_detail_diagnosakep' => $row['id_detail_diagnosakep'],
|
|
'no' => $no,
|
|
'tgl' => datetime_to_id($row['tgl']),
|
|
'jenis_ppa' => $row['jenis_ppa'],
|
|
'nama_ppa' => $row['nama_ppa'],
|
|
'soap' => (($row['jenis_ppa'] != 'Gizi') ? 'S : ' . $row['evaluasi_s'] . '<hr>O : ' . $row['evaluasi_o'] . '<hr>A : ' . $row['evaluasi_a'] . '<hr>P : ' . $row['evaluasi_p'] . '<br>' : 'A : ' . $row['evaluasi_s'] . '<hr>D : ' . $row['evaluasi_o'] . '<hr>I : ' . $row['evaluasi_a'] . '<hr>ME : ' . $row['evaluasi_p'] . '<br>'),
|
|
'review' => $row['review'],
|
|
];
|
|
$no++;
|
|
}
|
|
}
|
|
|
|
$output = array(
|
|
"draw" => intval($_GET['draw']),
|
|
"recordsTotal" => $tmp_hist_all->numRows(),
|
|
"recordsFiltered" => $tmp_hist_filter->numRows(),
|
|
"data" => $arr_data
|
|
);
|
|
|
|
echo json_encode($output);
|
|
exit;
|
|
} else {
|
|
$norm = $_REQUEST['nomr'];
|
|
$idxdaftar = $_REQUEST['idxdaftar'];
|
|
$rajal = $_REQUEST['rajal_status'];
|
|
$id_table = $_REQUEST['tbl_id'];
|
|
$query_hist = "SELECT a.*,case when (a.perawat <> 0 ) then b.NAMA when a.kddokter is not null then c.NAMADOKTER end as nama_ppa,d.nama_ppa as jenis_ppa ,e.rolename
|
|
FROM t_detail_diagnosakep a
|
|
left join m_perawat b on a.perawat = b.IDPERAWAT
|
|
left join m_dokter c on a.kddokter = c.KDDOKTER
|
|
left join m_ppa d on a.kategori = d.id_ppa
|
|
left join user_roles e on a.role_petugas = e.roleid
|
|
WHERE (a.nomr = '" . $norm . "') and idxrajal isnull
|
|
ORDER BY a.tgl desc";
|
|
|
|
$tmp_hist = $db->query($query_hist);
|
|
$html = '<style>
|
|
td.details-control {
|
|
text-align:center;
|
|
color:forestgreen;
|
|
cursor: pointer;
|
|
}
|
|
tr.shown td.details-control {
|
|
text-align:center;
|
|
color:red;
|
|
}
|
|
</style>
|
|
<div class="form-group row">
|
|
<label class="col-sm-1">Tgl Awal</label><div class="col-sm-2">
|
|
<input type="text" id="tgl_awal" class="datepicker-default mask-date-default form-control form-control-sm" value="' . date('Y-m-d') . '">
|
|
</div>
|
|
</div>
|
|
<div class="form-group row">
|
|
<label class="col-sm-1">Tgl Akhir</label><div class="col-sm-2">
|
|
<input type="text" id="tgl_akhir" class="datepicker-default mask-date-default form-control form-control-sm" value="' . date('Y-m-d') . '">
|
|
</div>
|
|
<div class="col-sm-2"><button type="button" class="btn btn-primary btn-sm" id="btn_filter_cprj">Cari</button></div>
|
|
</div>
|
|
<table class="table table-bordered table-striped table-sm" id="' . $id_table . '" style="width:100%"><thead>
|
|
<tr class="bg-primary text-white">
|
|
<th style="width:2%">No</th>
|
|
<th style="width:15%">Tanggal Jam</th>
|
|
<th style="width:15%">PPA</th>
|
|
<th style="width:30%">Hasil Asesmen Pasien dan Pemberian Pelayanan</th>
|
|
<th style="width:20%">Instruksi PPA Termasuk Pasca Bedah</th>
|
|
<th style="width:5%">Review & Verifikasi DPJP</th>
|
|
</tr></thead><tbody>';
|
|
if ($tmp_hist->numRows() > 0) {
|
|
$no = 1;
|
|
$flag_dokter = '';
|
|
foreach ($tmp_hist->fetchAll() as $row) {
|
|
// echo "<pre>";
|
|
// var_dump($row);
|
|
// echo "</pre>";
|
|
// $status_class = ($row['status_acc'] == 2) ? 'style="text-decoration:line-through"' : '';
|
|
$html .= '<tr>
|
|
<td class="text-center">' . $no . '</td>
|
|
<td>' . datetime_to_id($row['tgl']) . '</td>
|
|
<td>' . $row['nama_ppa'] . ' / ' . $row['jenis_ppa'] . ' / ' . $row['rolename'] . '</td>
|
|
<td>' . (($row['jenis_ppa'] != 'Gizi') ? 'S : ' . $row['evaluasi_s'] . '<hr>O : ' . $row['evaluasi_o'] . '<hr>A : ' . $row['evaluasi_a'] . '<hr>P : ' . $row['evaluasi_p'] . '<br>' : 'A : ' . $row['evaluasi_s'] . '<hr>D : ' . $row['evaluasi_o'] . '<hr>I : ' . $row['evaluasi_a'] . '<hr>ME : ' . $row['evaluasi_p'] . '<br>') . '</td>
|
|
<td>' . $row['implementasi'] . '</td>
|
|
<td>' . $row['review'] . '</td>
|
|
</tr>';
|
|
$no++;
|
|
}
|
|
}
|
|
|
|
$html .= '</tbody></table>';
|
|
|
|
echo $datatable_css . $datatable_bootstrap4_css . $datepicker_css;
|
|
echo '<style>
|
|
#tbl_hist_cprj_wrapper .dataTables_filter {
|
|
text-align:left !mportant;
|
|
}</style>';
|
|
echo $datatable_js . $datatable_bootstrap4_js . $datepicker_js . $datepicker_id_js . '
|
|
<script src="' . _LIB_ . 'DataTables/FixedHeader-3.1.4/js/dataTables.fixedHeader.min.js"></script>
|
|
<script src="' . _LIB_ . 'typing.js"></script>
|
|
<script src="' . _LIB_ . 'Inputmask/dist/min/jquery.inputmask.bundle.min.js"></script>';
|
|
echo '<script>
|
|
$(".mask-date-default").inputmask("9999-99-99");
|
|
$(".datepicker-default").datepicker({"format":"yyyy-mm-dd","language":"id","endDate":"0d"});
|
|
|
|
function draw_hist_table() {
|
|
' . $id_table . ' = $("#' . $id_table . '").DataTable({
|
|
"orderCellsTop": true,
|
|
"dom" : "<\'row text-left\'<\'col-sm-3 col-md-3 \'f><\'col-sm-6 col-md-6\'><\'col-sm-3 col-md-3\'l>>" +
|
|
"<\'row\'<\'col-md-12\'tr>>" +
|
|
"<\'row\'<\'col-sm-6 col-md-6\'i><\'col-sm-6 col-md-6\'p>>",
|
|
"ordering" : true,
|
|
"columnDefs": [
|
|
{ "name": "no", "targets": 0, searchable : false, orderable : true },
|
|
{ "name": "tgl", "targets": 1, searchable : true, orderable : true },
|
|
{ "name": "namappa", "targets": 1, searchable : false, orderable : false },
|
|
{ "name": "soap", "targets": 3, searchable : false, orderable : false },
|
|
{ "name": "review", "targets": 4, searchable : false, orderable : false },
|
|
],
|
|
"language":{
|
|
"decimal": ",",
|
|
"emptyTable": "Tidak terdapat data",
|
|
"info": "Menampilkan _START_ s/d _END_ dari _TOTAL_ data",
|
|
"infoEmpty": "Data kosong",
|
|
"infoFiltered": "(difilter dari _MAX_ total data)",
|
|
"infoPostFix": "",
|
|
"thousands": ".",
|
|
"lengthMenu": "Tampilkan _MENU_ data",
|
|
"loadingRecords": "Menunggu...",
|
|
"processing": "Memproses...",
|
|
"search": "Pencarian :",
|
|
"zeroRecords": "Tidak ditemukan data yang cocok",
|
|
"paginate": {
|
|
"first": "⇤",
|
|
"last": "⇥",
|
|
"next": "»",
|
|
"previous": "«"
|
|
},
|
|
"aria": {
|
|
"sortAscending": ": activate to sort column ascending",
|
|
"sortDescending": ": activate to sort column descending"
|
|
}
|
|
}
|
|
});
|
|
|
|
|
|
return ' . $id_table . ';
|
|
}
|
|
$(document).ready(function(){
|
|
|
|
' . $id_table . ' = draw_hist_table();
|
|
|
|
$("#btn_filter_cprj").click(function(){
|
|
tgl_awal = $("#tgl_awal").val();
|
|
tgl_akhir = $("#tgl_akhir").val();
|
|
$.post("' . _BASE_ . 'rajal/history_cprj.php?filter=1&' . http_build_query($_REQUEST) . '",{tgl_awal,tgl_akhir},function(data){
|
|
' . $id_table . '.destroy();
|
|
$("#' . $id_table . ' tbody").html("");
|
|
$.each(data.data,function(k,v){
|
|
|
|
$("#' . $id_table . ' tbody").append("<tr>"+
|
|
"<td>"+v.no+"</td>"+
|
|
"<td>"+v.tgl+"</td>"+
|
|
"<td>"+v.nama_ppa+" / "+v.jenis_ppa+"</td>"+
|
|
"<td>"+v.soap+"</td>"+
|
|
"<td>"+v.review+"</td>"+
|
|
"</tr>");
|
|
});
|
|
draw_hist_table();
|
|
},"json");
|
|
/*' . $id_table . '.serverSide = true;
|
|
' . $id_table . '.ajax.url("' . _BASE_ . 'rajal/history_cprj.php?filter=1&' . http_build_query($_REQUEST) . '&tgl_awal="+tgl_awal+"&tgl_akhir="+tgl_akhir).load();*/
|
|
});
|
|
});
|
|
</script>';
|
|
echo $html;
|
|
} |