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(); ?>
|
Data Order POCT = $tanggal_order_start ?> s/d = $tanggal_order_end ?> |
|
Nama Pasien : = $item['nama_pasien'] ?> NORM : = $item['norm'] ?> No Pemeriksaan : = $item['no_pemeriksaan'] ?> Tanggal Pemeriksaan : = $item['tanggal'] ?> Nama Petugas : = $item['operator'] ?> Cetakan Ke : = $cetak ?> |
Barcode Data Pemeriksaan |
|
Nama Pasien : = $item['nama_pasien'] ?> NORM : = $item['norm'] ?> No Pemeriksaan : = $item['no_pemeriksaan'] ?> Tanggal Pemeriksaan : = $item['tanggal'] ?> Nama Petugas : = $item['operator'] ?> Cetakan Ke : = $cetak ?> |
Barcode Petugas Pemeriksa Barcode No Pemeriksaan |