} else { $query_string = "SELECT count(s.specimen_id) as val 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(SELECT test_type_id FROM test_type WHERE test_category_id={$lab_section}) AND s.specimen_id NOT IN (select r_id from removal_record where category='specimen' AND status=1) "; } } else { if ($attrib_type == 9) { $decoded = decodeSpecimenBarcode($attrib_value); # Search by patient specimen id if ($lab_section == 0) { $query_string = "SELECT count(specimen_id) as val FROM specimen " . "WHERE specimen_id = {$decoded['1']} " . "AND ( status_code_id=" . Specimen::$STATUS_PENDING . " " . "OR status_code_id=" . Specimen::$STATUS_REFERRED . " ) AND specimen_id NOT IN (select r_id from removal_record where category='specimen' AND status=1) " . "ORDER BY date_collected DESC LIMIT 0,{$rcap}"; } else { $query_string = "SELECT count(s.specimen_id) as val FROM specimen s, test t " . "WHERE s.specimen_id = {$decoded['1']} AND s.specimen_id = t.specimen_id " . "AND ( s.status_code_id=" . Specimen::$STATUS_PENDING . " " . "OR s.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}) " . "AND specimen_id NOT IN (select r_id from removal_record where category='specimen' AND status=1) " . "ORDER BY date_collected DESC LIMIT 0,{$rcap}"; } } else { if ($attrib_type == 10) { # Search by patient specimen id $decoded = decodePatientBarcode($attrib_value); if ($lab_section == 0) { $query_string = "SELECT count(s.specimen_id) as val FROM specimen s, test t, patient p " . "WHERE p.patient_id=s.patient_id " . "AND p.surr_id='{$decoded['1']}'" . "AND s.specimen_id=t.specimen_id " . "AND s.specimen_id NOT IN (select r_id from removal_record where category='specimen') "; } else { $query_string = "SELECT count(s.specimen_id) as val FROM specimen s, test t, patient p " . "WHERE p.patient_id=s.patient_id " . "AND p.surr_id='{$attrib_value}'" . "AND s.specimen_id=t.specimen_id " . "AND test_type_id IN\r\n \t\t\t\t\t\t\t(SELECT test_type_id FROM test_type WHERE test_category_id={$lab_section}) AND s.specimen_id NOT IN (select r_id from removal_record where category='specimen' AND status=1) LIMIT 0,{$rcap} "; } } } } } } //echo $query_string; $resultset = query_associative_one($query_string); $count = $resultset['val']; //echo $query_string; echo $count;
function getPatientFromBarcode($patient_code) { $pieces = decodePatientBarcode($patient_code); $patient_id = $pieces[1]; $patientClass = new Patient(); $patient = $patientClass->getById($patient_id); return $patient; }