From a44826b2458d0fed0428d821d944e6bb87def7ef Mon Sep 17 00:00:00 2001 From: bradymiller Date: Sat, 23 Jan 2010 10:22:58 +0000 Subject: [PATCH] Fix drug name search to work in a broader sense --- interface/reports/prescriptions_report.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/interface/reports/prescriptions_report.php b/interface/reports/prescriptions_report.php index dd1795297..e9882fdf5 100644 --- a/interface/reports/prescriptions_report.php +++ b/interface/reports/prescriptions_report.php @@ -8,7 +8,9 @@ // This report lists prescriptions and their dispensations according // to various input selection criteria. - + // + // Fix drug name search to work in a broader sense - tony@mi-squared.com 2010 + require_once("../globals.php"); require_once("$srcdir/patient.inc"); require_once("$srcdir/options.inc.php"); @@ -197,7 +199,7 @@ "r.date_modified <= '$form_to_date'"; //if ($form_patient_id) $where .= " AND r.patient_id = '$form_patient_id'"; if ($form_patient_id) $where .= " AND p.pubpid = '$form_patient_id'"; - if ($form_drug_name ) $where .= " AND d.name LIKE '$form_drug_name'"; + if ($form_drug_name ) $where .= " AND (d.name LIKE '$form_drug_name' OR r.drug LIKE '$form_drug_name')"; if ($form_lot_number) $where .= " AND i.lot_number LIKE '$form_lot_number'"; $query = "SELECT r.id, r.patient_id, " . -- 2.11.4.GIT