session_id()) {
// header("Location: index.php");
// exit();
// }
$page = "Novel Covid-19";
require("connect_hosxp.php");
require("date_format.php");
$timezone = "Asia/Bangkok";
if (function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
$today = date("Y-m-d H:i:s");
$vn = base64_decode($_GET['nn']);
if ($vn == "") {
echo "ขออภัย.!! ไม่พบข้อมูล...";
echo " ";
echo "Sorry.!! No Data...";
echo '';
exit();
}
$sql_novel_data1 = "select concat(p.pname,p.fname,' ',p.lname)as pt,p.sex,h.hn,h.lab_order_number,p.birthday,p.cid,p.passport_no,
h.order_date,lo.lab_order_result,d2.name_eng as report_name,d1.name_eng as approv_name,d1.licenseno_samui as approv_lic,d2.licenseno_samui as report_lic ,d1.license_samui_pic as approv_sign,d2.license_samui_pic as report_sign,
h.order_date,h.receive_date,h.report_date,h.report_time,lo.lab_order_result, YEAR( FROM_DAYS( DATEDIFF( NOW( ) , p.birthday ))) as age,d2.position_eng_samui as report_position ,d1.position_eng_samui as approv_position
from lab_head h left outer join lab_order lo on h.lab_order_number=lo.lab_order_number
left outer join patient p on h.hn=p.hn
left outer join patient_eng pe on p.hn=pe.hn
left outer join opduser op on h.reporter_name=op.loginname
left outer join doctor d2 on op.doctorcode=d2.code
left outer join opduser op1 on h.approve_staff=op1.loginname
left outer join doctor d1 on op1.doctorcode=d1.code
where lo.lab_items_code in('1822','1837','1842','1856','1900','2030','2038','2044','1846','2054','2103') and h.vn='$vn' and ( lo.lab_order_result not in(' ') or lo.lab_order_result is not null ) group by h.lab_order_number ,lo.lab_items_code order by lo.lab_items_code";
$result_novel_data1 = mysqli_query($conn1, $sql_novel_data1);
$row_novel_data1 = mysqli_fetch_array($result_novel_data1);
$lab_order_number = $row_novel_data1['lab_order_number'];
//------------- Get Lab Head ID -------------------
$sql_check_lab_head_id = "select universal_head_id from universal_head where universal_form_id='91' and vn='$vn' ";
$result_check_lab_head_id = mysqli_query($conn1, $sql_check_lab_head_id);
$row_check_lab_head_id = mysqli_fetch_array($result_check_lab_head_id);
$lab_head_id = $row_check_lab_head_id['universal_head_id'];
//-----------------------------------------------------
//------------- Lab Result Data 1 -------------------
$lab_result_line_1 = $row_novel_data1['lab_order_result'];
//-----------------------------------------------------
//------------- Lab Result Data 2 -------------------
$sql_result_data_2_1 = "select if(lab_order_result in('Detected','Detectable'),'Target gene = ORF-1ab ที่ Ct = ',null) as lab_result_2_1 from lab_order where lab_order_number='$lab_order_number' ";
$result_result_data_2_1 = mysqli_query($conn1, $sql_result_data_2_1);
$row_result_data_2_1 = mysqli_fetch_array($result_result_data_2_1);
$sql_result_data_2_2 = "select ud.universal_item_value_text as lab_result_2_2 from universal_head uh left outer join universal_detail ud on ud.universal_head_id=uh.universal_head_id where uh.universal_head_id='$lab_head_id' and ud.universal_item_id='2954' ";
$result_result_data_2_2 = mysqli_query($conn1, $sql_result_data_2_2);
$row_result_data_2_2 = mysqli_fetch_array($result_result_data_2_2);
$lab_result_data_2_1 = $row_result_data_2_1['lab_result_2_1'];
$lab_result_data_2_2 = $row_result_data_2_2['lab_result_2_2'];
$lab_result_line_2 = $lab_result_data_2_1 . "" . $lab_result_data_2_2;
//-----------------------------------------------------
//------------- Lab Result Data 3 -------------------
$sql_result_data_3_1 = "select if(lab_order_result in('Detected','Detectable'),'Target gene =N-gene ที่ Ct = ',null) as lab_result_3_1 from lab_order where lab_order_number='$lab_order_number' ";
$result_result_data_3_1 = mysqli_query($conn1, $sql_result_data_3_1);
$row_result_data_3_1 = mysqli_fetch_array($result_result_data_3_1);
$sql_result_data_3_2 = "select ud.universal_item_value_text as lab_result_3_2 from universal_head uh left outer join universal_detail ud on ud.universal_head_id=uh.universal_head_id where uh.universal_head_id='$lab_head_id' and ud.universal_item_id='2955' ";
$result_result_data_3_2 = mysqli_query($conn1, $sql_result_data_3_2);
$row_result_data_3_2 = mysqli_fetch_array($result_result_data_3_2);
$lab_result_data_3_1 = $row_result_data_3_1['lab_result_3_1'];
$lab_result_data_3_2 = $row_result_data_3_2['lab_result_3_2'];
$lab_result_line_3 = $lab_result_data_3_1 . "" . $lab_result_data_3_2;
//-----------------------------------------------------
//------------- Lab Result Data 4 -------------------
$sql_result_data_4 = "select if ( lab_order_result IN ( 'Detected', 'Detectable' ), '(Limit of detection = 200 copies/mL)', NULL ) as lab_result_4 from lab_order where lab_order_number='$lab_order_number' ";
$result_result_data_4 = mysqli_query($conn1, $sql_result_data_4);
$row_result_data_4 = mysqli_fetch_array($result_result_data_4);
$lab_result_data_4 = $row_result_data_4['lab_result_4'];
$lab_result_line_4 = $lab_result_data_4;
//-----------------------------------------------------
?>
HOSxP Web Service ✎ ✉ | <?php echo $page; ?>
FM-LAB-BL-19 Date:02/12/2020
Analysis Report Department of Medical Technology Koh Samui Hospital
61 M.1 T.Angthong Koh Samui Suratthani 84140 Tel: 077-913200 ext. 5010 Fax: 077-421323 E-mail:lab.kohsamui@gmail.com
Sample receipt date :
Date/Time of Analysis Report :
Objective :
Detecting the genetic material of Corona Virus 2019 (SARS-CoV-2)
Title of the test :
Coronavirus 2019 genetic material (SARS-CoV-2) detection by real time RT-PCR technique
Notes : Summary of interpretation of the reagent set ; When detecting ORF-1ab and N-genes at Ct ≤ 40.
Report it as "Detected" which means detected the genetic material of SARS-CoV-2. If Ct > 40 or Ct is not
detected, report it as "Not Detected" which means the genetic material of SARS-CoV-2 is not detected
