From 9396ce245f4cff992f970bbcbaa4be5e8a9ee444 Mon Sep 17 00:00:00 2001 From: Ken Chapple Date: Wed, 13 Jul 2011 08:49:09 -0700 Subject: [PATCH] Fix for NFQ 0059 added check for procedure code in addition to standard code in lab result --- library/classes/ClinicalTypes/LabResult.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/library/classes/ClinicalTypes/LabResult.php b/library/classes/ClinicalTypes/LabResult.php index ea63dd227..3c2cba6f2 100644 --- a/library/classes/ClinicalTypes/LabResult.php +++ b/library/classes/ClinicalTypes/LabResult.php @@ -42,7 +42,7 @@ class LabResult extends ClinicalType "WHERE procedure_type.procedure_type_id = procedure_order.procedure_type_id " . "AND procedure_order.procedure_order_id = procedure_report.procedure_order_id " . "AND procedure_report.procedure_report_id = procedure_result.procedure_report_id " . - "AND procedure_type.standard_code = ? " . + "AND ( procedure_type.standard_code = ? OR procedure_type.procedure_code = ? ) " . "AND procedure_result.date >= ? " . "AND procedure_result.date < ? " . "AND procedure_order.patient_id = ? "; @@ -53,8 +53,7 @@ class LabResult extends ClinicalType $sql .= "AND procedure_result.result < ? "; } - // TODO should this be ': or '::' - $bindings = array( $codeType.':'.$code, $beginDate, $endDate, $patient->id ); + $bindings = array( $codeType.':'.$code, $code, $beginDate, $endDate, $patient->id ); if ( $range->lowerBound != Range::NEG_INF ) { $bindings []= $range->lowerBound; } -- 2.11.4.GIT