130 lines
5.5 KiB
PHP
130 lines
5.5 KiB
PHP
<?php
|
|
if (!session_id()) {
|
|
session_start();
|
|
}
|
|
|
|
require_once 'main.php';
|
|
require_once('SQLServerDb.php');
|
|
|
|
$db_pec = new SQLServerDb(
|
|
$_ENV['PEC_DB_USER'],
|
|
$_ENV['PEC_DB_PASS'],
|
|
$_ENV['PEC_DB_NAME'],
|
|
$_ENV['PEC_DB_HOST']
|
|
);
|
|
$post = $_REQUEST;
|
|
|
|
if (array_key_exists('rekap_poct', $post) && $post['rekap_poct'] == true) {
|
|
global $db_pec;
|
|
global $db;
|
|
|
|
$is_time= false;
|
|
if(!empty($post['time_order_start']) && !empty($post['time_order_end'])){
|
|
$date_start = date_create($post['tanggal_order_start'] .' '. $post['time_order_start']);
|
|
$date_start = date_format($date_start, "Y-m-d H:i:s");
|
|
|
|
$date_end = date_create($post['tanggal_order_start'] .' '. $post['time_order_end']);
|
|
$date_end = date_format($date_end, "Y-m-d H:i:s");
|
|
|
|
$is_time = true;
|
|
}
|
|
|
|
if($is_time){
|
|
$tmp_list_trans = $db_pec->get_results("SELECT p.ID as p_id,p.Lab_PatientID as nomr,p.Location as ruang,r.ID as r_id,r.UnivTestName as DN,r.RValue as rvalue,
|
|
r.Unit as unit,r.ANormalFlag as normalflah,convert(varchar, r.TestEndDate, 20) as specimen_dttm,op.FirstName,op.LastName, convert(varchar, p.lastUpdDatetime, 20) as lastUpdDatetime, r.InstrSectionID
|
|
from Patient as p
|
|
left join Result as r on p.ID = r._PID
|
|
left join Operator as op on r.OperatiorID = op.OperatorID
|
|
where convert(datetime,r.TestEndDate) between CONVERT(datetime, '".$date_start."' ) and CONVERT(datetime, '".$date_end."')
|
|
order by r.TestEndDate, p.Lab_PatientID desc", 'array');
|
|
}else{
|
|
$tmp_list_trans = $db_pec->get_results("SELECT p.ID as p_id,p.Lab_PatientID as nomr,p.Location as ruang,r.ID as r_id,r.UnivTestName as DN,r.RValue as rvalue,
|
|
r.Unit as unit,r.ANormalFlag as normalflah,convert(varchar, r.TestEndDate, 20) as specimen_dttm,op.FirstName,op.LastName, convert(varchar, p.lastUpdDatetime, 20) as lastUpdDatetime, r.InstrSectionID
|
|
from Patient as p
|
|
left join Result as r on p.ID = r._PID
|
|
left join Operator as op on r.OperatiorID = op.OperatorID
|
|
where convert(date,r.TestEndDate) = '".$date_start."'
|
|
order by r.TestEndDate, p.Lab_PatientID desc", 'array');
|
|
}
|
|
|
|
$arr_pasien = [];
|
|
if(count($tmp_list_trans) > 0){
|
|
$no = 1;
|
|
foreach($tmp_list_trans as $ind => $list){
|
|
$is_data = false;
|
|
$data_poct = '';
|
|
if(strlen($list['nomr']) > 10){
|
|
|
|
if(strlen($list['nomr']) == 20){
|
|
$order_poct_sql = $db->query("SELECT order_poct.*,m_pasien.nama as nama_pasien, m_ruang.nama as ruangan, m_ruang.no as kode_ruangan, m_perawat.nama as operator, m_pasien.tgllahir as tgl_lahir from order_poct
|
|
join m_pasien on m_pasien.nomr = order_poct.norm
|
|
join m_ruang on m_ruang.no = order_poct.ruang_id
|
|
join m_perawat on m_perawat.idperawat = order_poct.operator_id
|
|
where no_pemeriksaan = '{$list['nomr']}'
|
|
--and (is_valid = 2 or is_valid = 0 or is_valid is null)
|
|
");
|
|
}else{
|
|
$order_poct_sql = $db->query("SELECT order_poct.*,m_pasien.nama as nama_pasien, m_ruang.nama as ruangan, m_ruang.no as kode_ruangan, m_perawat.nama as operator, m_pasien.tgllahir as tgl_lahir from order_poct
|
|
join m_pasien on m_pasien.nomr = order_poct.norm
|
|
join m_ruang on m_ruang.no = order_poct.ruang_id
|
|
join m_perawat on m_perawat.idperawat = order_poct.operator_id
|
|
where upper(order_number) = '{$list['nomr']}'
|
|
--and (is_valid = 2 or is_valid = 0 or is_valid is null)
|
|
");
|
|
}
|
|
$order_poct = $order_poct_sql->fetchAll()[0];
|
|
if(!empty($order_poct)){
|
|
$is_data = true;
|
|
$data_poct = $order_poct;
|
|
}
|
|
}
|
|
|
|
$arr_pasien[$ind]['no'] = $no++;
|
|
$arr_pasien[$ind]['nomr'] = ($is_data) ? $data_poct['norm'] : $list['nomr'];
|
|
$arr_pasien[$ind]['nama_pasien'] = ($is_data) ? $data_poct['nama_pasien'] : '';
|
|
$arr_pasien[$ind]['no_billing'] = ($is_data) ? $data_poct['no_billing'] : '' ;
|
|
$arr_pasien[$ind]['date'] = $list['specimen_dttm'];
|
|
$arr_pasien[$ind]['InstrSectionID'] = $list['InstrSectionID'];
|
|
$arr_pasien[$ind]['ruang'] = $list['ruang'];
|
|
$arr_pasien[$ind]['hasil'] = $list['rvalue'];
|
|
$arr_pasien[$ind]['unit'] = $list['unit'];
|
|
$arr_pasien[$ind]['data_order'] = ($is_data) ? "ADA" :"TIDAK";
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
?>
|
|
|
|
<div class="row">
|
|
<div class="col-md-12">
|
|
<table class="table table-striped">
|
|
<tr>
|
|
<td>No</td>
|
|
<td>Norm</td>
|
|
<td>Nama</td>
|
|
<td>No Billing</td>
|
|
<td>Tanggal Pemeriksaan</td>
|
|
<td>Analyser</td>
|
|
<td>Hasil</td>
|
|
<td>Ruangan</td>
|
|
<td>Order</td>
|
|
</tr>
|
|
<?php
|
|
$no = 1;
|
|
foreach($arr_pasien as $ind => $item) : ?>
|
|
<tr>
|
|
<td><?= $no++ ?></td>
|
|
<td><?= $item['nomr'] ?></td>
|
|
<td><?= $item['nama_pasien'] ?></td>
|
|
<td><?= $item['no_billing'] ?></td>
|
|
<td><?= $item['date'] ?></td>
|
|
<td><?= $item['InstrSectionID'] ?></td>
|
|
<td><?= $item['hasil'] .' ' . $item['unit'] ?></td>
|
|
<td><?= $item['ruang'] ?></td>
|
|
<td><?= $item['data_order'] ?></td>
|
|
</tr>
|
|
<?php endforeach ?>
|
|
</table>
|
|
</div>
|
|
</div>
|