140 lines
6.6 KiB
PHP
140 lines
6.6 KiB
PHP
<?php
|
|
$path = realpath(dirname(__FILE__));
|
|
require_once $path . '/../core/main.php';
|
|
$generator = new \Picqer\Barcode\BarcodeGeneratorPNG();
|
|
|
|
$tanggal_order_start = $_GET['tanggal_order_start'];
|
|
$tanggal_order_end = $_GET['tanggal_order_end'];
|
|
|
|
$time_order_start = $_GET['time_order_start'];
|
|
$time_order_end = $_GET['time_order_end'];
|
|
|
|
$ruang = $_GET['ruang'];
|
|
$norm = $_GET['norm'];
|
|
$operator = $_GET['operator'];
|
|
|
|
$filter = '';
|
|
if (!empty($ruang)) {
|
|
$filter .= "and a.ruang_id = '" . $ruang . "'";
|
|
}
|
|
|
|
if (!empty($norm)) {
|
|
$filter .= " and a.norm = '" . $norm . "'";
|
|
}
|
|
|
|
if (!empty($operator)) {
|
|
$filter .= " and a.operator_id = '" . $operator . "'";
|
|
}
|
|
|
|
$is_time = false;
|
|
if (!empty($time_order_start)){
|
|
$tanggal_order_start = date_create($tanggal_order_start. ' '. $time_order_start);
|
|
$tanggal_order_start = date_format($tanggal_order_start, "Y-m-d H:i:s");
|
|
$is_time = true;
|
|
}
|
|
|
|
if (!empty($time_order_end)){
|
|
$tanggal_order_end = date_create($tanggal_order_end. ' '. $time_order_end);
|
|
$tanggal_order_end = date_format($tanggal_order_end, "Y-m-d H:i:s");
|
|
$is_time = true;
|
|
}
|
|
|
|
//cek display_barcode_poct
|
|
$sql_display = "select var_value from global_var where var_name = 'display_barcode_poct'";
|
|
$display = $db->query($sql_display)->fetchAll();
|
|
|
|
if ($is_time){
|
|
$query = "select a.norm, b.nama as nama_pasien, a.tanggal, a.no_pemeriksaan, d.namadokter as nama_dokter, e.nama as operator, c.nama as ruangan, e.nip, a.created_at, a.cetakan_ke, a.order_number from order_poct a
|
|
join m_pasien b on b.nomr = a.norm
|
|
join m_ruang c on c.no = a.ruang_id
|
|
join m_dokter d on d.kddokter = a.dokter_id
|
|
join m_perawat e on e.idperawat = a.operator_id
|
|
where a.status = 1 and (a.is_valid is null or a.is_valid = 2) and a.tanggal between '" . $tanggal_order_start . "' and '" . $tanggal_order_end . "' $filter
|
|
order by a.norm, a.tanggal ";
|
|
}else{
|
|
$query = "select a.norm, b.nama as nama_pasien, a.tanggal, a.no_pemeriksaan, d.namadokter as nama_dokter, e.nama as operator, c.nama as ruangan, e.nip, a.created_at, a.cetakan_ke, a.order_number from order_poct a
|
|
join m_pasien b on b.nomr = a.norm
|
|
join m_ruang c on c.no = a.ruang_id
|
|
join m_dokter d on d.kddokter = a.dokter_id
|
|
join m_perawat e on e.idperawat = a.operator_id
|
|
where a.status = 1 and (a.is_valid is null or a.is_valid = 2) and to_char(a.tanggal , 'YYYY-MM-DD') between '" . $tanggal_order_start . "' and '" . $tanggal_order_end . "' $filter
|
|
order by a.norm, a.tanggal ";
|
|
}
|
|
|
|
|
|
$tmp_query = $db->query($query);
|
|
$list_orders = $tmp_query->fetchAll();
|
|
|
|
?>
|
|
<table width="100%">
|
|
<tr>
|
|
<td style="text-align: center">
|
|
Data Order POCT <br>
|
|
<span style="font-size: 11px"><?= $tanggal_order_start ?> s/d <?= $tanggal_order_end ?></span>
|
|
</td>
|
|
</tr>
|
|
</table><br>
|
|
|
|
<?php
|
|
$cetak = 0;
|
|
foreach ($list_orders as $item):
|
|
$replace_char1 = str_replace('-', '', $item['nip']);
|
|
$replace_char2 = str_replace('.', '', $replace_char1);
|
|
$count_string = strlen($item['nip']);
|
|
|
|
$cetak = $item['cetakan_ke'] + 1;
|
|
//update is_valid jadi 2 (menunggu)
|
|
$query_order = "UPDATE order_poct set is_valid = '2', cetakan_ke = '$cetak' where no_pemeriksaan = '{$item['no_pemeriksaan']}' and norm = '{$item['norm']}' ";
|
|
$save_order = execute($query_order);
|
|
|
|
$nip = $replace_char2;
|
|
if ($count_string >= 20) {
|
|
$nip = substr($replace_char2, 4);
|
|
}
|
|
?>
|
|
<?php if ($display[0]['var_value'] == 1):?>
|
|
<table style="width: 100%">
|
|
<tr>
|
|
<td>
|
|
<span style="font-size: 12px">Nama Pasien : <?= $item['nama_pasien'] ?></span><br>
|
|
<span style="font-size: 12px">NORM : <?= $item['norm'] ?></span><br>
|
|
<span style="font-size: 12px">No Pemeriksaan : <?= $item['no_pemeriksaan'] ?></span><br>
|
|
<span style="font-size: 12px">Tanggal Pemeriksaan : <?= $item['tanggal'] ?></span><br>
|
|
<span style="font-size: 12px">Nama Petugas : <?= $item['operator'] ?></span><br>
|
|
<span style="font-size: 12px">Cetakan Ke : <?= $cetak ?></span><br>
|
|
</td>
|
|
<td>
|
|
<span style="font-size: 12px">Barcode Data Pemeriksaan</span><br>
|
|
<img src="data:image/png;base64, <?= base64_encode($generator->getBarcode($item['order_number'], $generator::TYPE_CODE_39, 1, 45)) ?>"><br>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<?php else : ?>
|
|
<table style="width: 100%">
|
|
<tr>
|
|
<td>
|
|
<span style="font-size: 12px">Nama Pasien : <?= $item['nama_pasien'] ?></span><br>
|
|
<span style="font-size: 12px">NORM : <?= $item['norm'] ?></span><br>
|
|
<span style="font-size: 12px">No Pemeriksaan : <?= $item['no_pemeriksaan'] ?></span><br>
|
|
<span style="font-size: 12px">Tanggal Pemeriksaan : <?= $item['tanggal'] ?></span><br>
|
|
<span style="font-size: 12px">Nama Petugas : <?= $item['operator'] ?></span><br>
|
|
<span style="font-size: 12px">Cetakan Ke : <?= $cetak ?></span><br>
|
|
</td>
|
|
<td>
|
|
<span style="font-size: 12px">Barcode Petugas Pemeriksa</span><br>
|
|
<img src="data:image/png;base64, <?= base64_encode($generator->getBarcode($nip, $generator::TYPE_CODE_39, 1, 45)) ?>"><br><br>
|
|
<span style="font-size: 12px">Barcode No Pemeriksaan</span><br>
|
|
<img src="data:image/png;base64, <?= base64_encode($generator->getBarcode($item['no_pemeriksaan'], $generator::TYPE_CODE_39, 1, 45)) ?>"><br>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<?php endif; ?>
|
|
|
|
<hr>
|
|
|
|
|
|
<?php endforeach; ?>
|
|
|
|
|
|
|