query($myquery); $userdata = $get->fetchAll()[0]; $dokter = 'SELECT distinct b.kddokter, b.namadokter, b.tgl_akhir_sip,b.kdpoly, b.kdsmf, b.kdprofesi FROM m_dokter b WHERE b.aktif = 1'; $tmp_dokter = $db->query($dokter); $arr_dokter = $arr_dokter_ppds = $arr_smf = []; if ($tmp_dokter->numRows() > 0) { foreach ($tmp_dokter->fetchAll() as $d) { $tgl_SIP = new Datetime($d['tgl_akhir_sip']); $tgl_sekarang = new Datetime(date('Y-m-d')); $arr_smf[$d['kddokter']] = $d['kdsmf']; if ($d['tgl_akhir_sip'] > '0000-00-00' || $d['tgl_akhir_sip'] > '0001-01-01') { if ($tgl_sekarang <= $tgl_SIP) { $arr_dokter[$d['kddokter']] = $d['namadokter']; } } if ($d['kdprofesi'] == 0) { $arr_dokter_ppds[$d['namadokter']] = $d['namadokter']; } } } echo $datetimepicker_css; echo $datetimepicker_js; $perawat = "select idperawat, nip, unit_kerja, nama from m_perawat where aktif = 1 is not null"; $tmp_perawat = $db->query($perawat); $arr_perawat = []; if ($tmp_perawat->numRows() > 0) { $arr_perawat[] = '-'; foreach ($tmp_perawat->fetchAll() as $item) { $arr_perawat[$item['idperawat']] = $item['nama']; } } $select_operator = ''; if (!empty($_SESSION['KDPERAWAT'])) { $select_operator = $_SESSION['KDPERAWAT']; } $order_poct = "select a.id, a.jenis_pemeriksaan, a.pemeriksaan, a.tarif_rs_id, b.kode_tarif, b.jumlah from order_poct_list a join m_tarif_rs b on a.tarif_rs_id = b.id_tarif where a.aktif = 1"; $tmp_poct = $db->query($order_poct); $arr_pemeriksaan = []; if ($tmp_poct->numRows() > 0) { foreach ($tmp_poct->fetchAll() as $item) { $arr_pemeriksaan[$item['jenis_pemeriksaan']]['pemeriksaan'][$item['id']]['id'] = $item['id']; $arr_pemeriksaan[$item['jenis_pemeriksaan']]['pemeriksaan'][$item['id']]['jenis'] = $item['jenis_pemeriksaan']; $arr_pemeriksaan[$item['jenis_pemeriksaan']]['pemeriksaan'][$item['id']]['pemeriksaan'] = $item['pemeriksaan']; $arr_pemeriksaan[$item['jenis_pemeriksaan']]['pemeriksaan'][$item['id']]['harga'] = $item['jumlah']; $arr_pemeriksaan[$item['jenis_pemeriksaan']]['pemeriksaan'][$item['id']]['kode_tarif'] = $item['kode_tarif']; $arr_pemeriksaan[$item['jenis_pemeriksaan']]['pemeriksaan'][$item['id']]['tarif_rs_id'] = $item['tarif_rs_id']; } } $datenow = date('Y-m-d'); $max_pemeriksaan = "select max(no_pemeriksaan) as code from order_poct where norm = '" . $userdata['nomr'] . "' "; $tmp_poct = $db->query($max_pemeriksaan); $max_number = $tmp_poct->fetchAll()[0]; $tanggal = date_create_from_format('Y-m-d', $datenow); //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 (!empty($max_number['code'])) { $substr = (int)substr($max_number['code'], 16, 4) + 1; if ($display[0]['var_value'] == 1) { $code = date("His") . $userdata['nomr'] . date_format($tanggal, 'Ymd') . sprintf('%04d', $substr); } else { $code = $userdata['nomr'] . date_format($tanggal, 'Ymd') . sprintf('%04d', $substr); } } else { if ($display[0]['var_value'] == 1) { $code = date("His") . $userdata['nomr'] . date_format($tanggal, 'Ymd') . '0001'; } else { $code = $userdata['nomr'] . date_format($tanggal, 'Ymd') . '0001'; } } $list_order_poct = "select a.id, a.norm, a.operator_id, b.nip, b.nama, a.dokter_id, c.namadokter, a.no_pemeriksaan, a.tanggal, a.total_order, a.created_at, a.is_valid from order_poct a join m_perawat b on b.idperawat = a.operator_id join m_dokter c on c.kddokter = a.dokter_id where norm = '" . $userdata['nomr'] . "' and a.status = 1 and a.idxdaftar = '" . $userdata['id_admission'] . "' order by a.tanggal desc"; $tmp_list_poct = $db->query($list_order_poct); $list_poct = $tmp_list_poct->fetchAll(); $env = $_ENV['APP_ENV']; $arr_validasi_poct = []; if ($env != 'local') { $db_pec = new SQLServerDb($_ENV['PEC_DB_USER'], $_ENV['PEC_DB_PASS'], $_ENV['PEC_DB_NAME'], $_ENV['PEC_DB_HOST']); global $db_pec; global $db; $arr_validasi_poct = $db_pec->get_results("SELECT p.ID as p_id,p.Lab_PatientID as nomr, convert(varchar, r.TestEndDate, 20) as tanggal 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 r.RValue <> '' and p.Lab_PatientID = '{$userdata['nomr']}' order by r.TestEndDate desc ", 'array'); } $arr_list_poct = []; foreach ($list_poct as $ind => $item) { $arr_list_poct[$item['id']]['id'] = $item['id']; $arr_list_poct[$item['id']]['no_pemeriksaan'] = $item['no_pemeriksaan']; $arr_list_poct[$item['id']]['created_at'] = $item['created_at']; $arr_list_poct[$item['id']]['tanggal'] = $item['tanggal']; $arr_list_poct[$item['id']]['nama'] = $item['nama']; $arr_list_poct[$item['id']]['nip'] = $item['nip']; $arr_list_poct[$item['id']]['namadokter'] = $item['namadokter']; $arr_list_poct[$item['id']]['total_order'] = $item['total_order']; $arr_list_poct[$item['id']]['is_valid'] = $item['is_valid']; $arr_list_poct[$item['id']]['order_batal'] = isset($arr_validasi_poct[$ind]) ? (date('Y-m-d', strtotime($arr_validasi_poct[$ind]['tanggal'])) == $item['tanggal']) ? 1 : 0 : 0; } ?>