ผลแล็บ
- ไม่มีข้อมูลการส่งตรวจทางห้องปฏิบัติการ
';
} else {
$i4 = 0;
$lab_order_list = "";
while ($i4 < $num_rows_lab1) {
$rs_lab1 = $result_lab1 ? mysqli_fetch_array($result_lab1) : [];
if ($lab_order_list == "") {
$lab_order_list = "'" . $rs_lab1["lab_order_number"] . "'";
} else {
$lab_order_list = $lab_order_list . ",'" . $rs_lab1["lab_order_number"] . "'";
}
$i4++;
}
if ($lab_order_list == "") {
$lab_order_list = "0";
}
$sqlLab2 = "select l.*,i.lab_items_name,i.lab_items_unit,i.lab_items_code,i.lab_items_normal_value,e.staff,l.lab_order_number,j.lab_items_sub_group_name,h.order_date from lab_order l left outer join lab_entry_log e on e.lab_order_number=l.lab_order_number left outer join lab_items i on i.lab_items_code=l.lab_items_code left outer join lab_order_image k on k.lab_order_number=l.lab_order_number left outer join lab_items_sub_group j on j.lab_items_sub_group_code = l.lab_items_sub_group_code LEFT OUTER JOIN lab_head h ON h.lab_order_number = l.lab_order_number where l.lab_order_number in ($lab_order_list) and l.lab_order_result <>'' and i.lab_items_code not in ('332','657','1590','1592','1594','1596','1602','1604','1606','1608') order by l.lab_items_sub_group_code, i.display_order ";
mysqli_query($conn1, "SET SESSION sql_mode=''");
$result_lab2 = mysqli_query($conn1, $sqlLab2);
$num_rows_lab2 = $result_lab2 ? mysqli_num_rows($result_lab2) : 0;
if ($num_rows_lab2 == 0) {
echo "
-
ไม่มีรายการผลแล็บ";
} else {
?>
|
ลำดับ
|
วันที่ส่งตรวจ
|
ชื่อการส่งตรวจ
|
ผล
|
ค่าปกติ
|
Sub Group
|
|
|
|
|
[ อ่านผล ] ';
}
} else {
echo "ยังไม่รายงาน";
}
?> |
|
|
-
ไม่มีข้อมูลรายการ x-ray";
} else {
?>
 . ')
';
} ?>