$query_string = "SELECT s.specimen_id FROM specimen s, test t, patient p " . "WHERE s.specimen_id=t.specimen_id " . "AND t.result = '' " . "AND s.patient_id=p.patient_id " . "AND p.name LIKE '{$attrib_value}' LIMIT {$offset},{$result_cap}";
} else {
$query_string = "SELECT s.specimen_id FROM specimen s, test t, patient p " . "WHERE s.specimen_id=t.specimen_id " . "AND t.result = '' " . "AND s.patient_id=p.patient_id " . "AND p.name LIKE '{$attrib_value}' AND test_type_id IN\r\n\t\t\t\t\t(SELECT test_type_id FROM test_type WHERE test_category_id={$lab_section}) LIMIT {$offset},{$result_cap}";
}
} else {
if ($attrib_type == 3) {
# Search by patient daily number
if ($lab_section == 0) {
$query_string = "SELECT specimen_id FROM specimen " . "WHERE daily_num LIKE '%-{$attrib_value}' " . "AND ( status_code_id=" . Specimen::$STATUS_PENDING . " " . "OR status_code_id=" . Specimen::$STATUS_REFERRED . " ) " . "ORDER BY date_collected DESC LIMIT {$offset},{$result_cap}";
} else {
$query_string = "SELECT s.specimen_id FROM specimen s, test t WHERE s.specimen_id = t.specimen_id AND " . "daily_num LIKE '%-{$attrib_value}'" . "AND ( status_code_id=" . Specimen::$STATUS_PENDING . " " . "OR status_code_id=" . Specimen::$STATUS_REFERRED . " ) AND t.test_type_id IN\r\n\t\t\t\t\t(SELECT test_type_id FROM test_type WHERE test_category_id={$lab_section})" . "ORDER BY date_collected DESC LIMIT {$offset},{$result_cap}";
}
} else {
if ($attrib_type == 9) {
# Search by patient specimen id
$decoded = decodeSpecimenBarcode($attrib_value);
if ($lab_section == 0) {
$query_string = "SELECT specimen_id FROM specimen " . "WHERE specimen_id = {$decoded['1']} " . "AND ( status_code_id=" . Specimen::$STATUS_PENDING . " " . "OR status_code_id=" . Specimen::$STATUS_REFERRED . " ) " . "ORDER BY date_collected DESC LIMIT {$offset},{$result_cap}";
} else {
$query_string = "SELECT specimen_id FROM specimen " . "WHERE specimen_id = {$decoded['1']} " . "AND ( status_code_id=" . Specimen::$STATUS_PENDING . " " . "OR status_code_id=" . Specimen::$STATUS_REFERRED . " ) " . "ORDER BY date_collected DESC LIMIT {$offset},{$result_cap}";
}
}
}
}
}
}
$resultset = query_associative_all($query_string, $row_count);
if (count($resultset) == 0 || $resultset == null) {
?>
<div class='sidetip_nopos'>
<?php
function getSpecimenFromBarcode($specimen_code)
{
$pieces = decodeSpecimenBarcode($specimen_code);
$specimen_id = $pieces[1];
$patientClass = new Patient();
$patient = $patientClass->getById($patient_id);
return $patient;
}