From: Ajil <ajilpm@zhservices.com>
Date: Thu, 17 Jan 2013 15:22:29 +0000 (+0530)
Subject: Lab results in patient portal Medical Records tab.
X-Git-Tag: whats-been-changed~454
X-Git-Url: https://repo.or.cz/w/openemr.git/commitdiff_plain/b3336dea758515b6add588c900172a5b49909adc

Lab results in patient portal Medical Records tab.

Signed-off-by: Ajil <ajilpm@zhservices.com>
---

diff --git a/myportal/soap_service/server_existingpatient.php b/myportal/soap_service/server_existingpatient.php
index fa9bd9540..960d994a2 100644
--- a/myportal/soap_service/server_existingpatient.php
+++ b/myportal/soap_service/server_existingpatient.php
@@ -461,6 +461,24 @@ class existingpatient {
                             array_unshift($data[1],$pid);
                             return array($query,$data[1]);
                             break;
+												
+						case 'D5':
+                    $query = "SELECT po.procedure_order_id, po.date_ordered,po.procedure_type_id AS order_type_id, pt1.name AS procedure_name,
+									  ptrc.name AS result_category_name, pt2.procedure_type AS result_type, pt2.procedure_type_id AS result_type_id, pt2.name
+										AS result_name, pt2.units AS result_def_units, pt2.range AS result_def_range, pt2.description AS result_description,
+										lo.title AS units_name, pr.procedure_report_id, pr.date_report, pr.date_collected, pr.specimen_num, pr.report_status,
+										pr.review_status, ps.procedure_result_id, ps.abnormal, ps.result, ps.range, ps.result_status, ps.facility, ps.comments
+										FROM procedure_order AS po LEFT JOIN procedure_type AS pt1 ON pt1.procedure_type_id = po.procedure_type_id LEFT JOIN
+										procedure_type AS ptrc ON ptrc.procedure_type_id = pt1.parent AND ptrc.procedure_type LIKE 'grp%' LEFT JOIN procedure_type
+										AS pt2 ON ((ptrc.procedure_type_id IS NULL AND (pt2.parent = po.procedure_type_id OR pt2.procedure_type_id = po.procedure_type_id))
+										OR (pt2.procedure_type_id IS NOT NULL AND pt2.parent = pt1.procedure_type_id)) AND (pt2.procedure_type LIKE 'res%' OR
+										pt2.procedure_type LIKE 'rec%') LEFT JOIN list_options AS lo ON list_id = 'proc_unit' AND option_id = pt2.units LEFT JOIN
+										procedure_report AS pr ON pr.procedure_order_id = po.procedure_order_id LEFT JOIN procedure_result AS ps ON
+										ps.procedure_report_id = pr.procedure_report_id AND ps.procedure_type_id = pt2.procedure_type_id WHERE po.patient_id = ? 
+										ORDER BY po.date_ordered, po.procedure_order_id, pr.procedure_report_id, ptrc.seq, ptrc.name, ptrc.procedure_type_id,
+									  pt2.seq, pt2.name, pt2.procedure_type_id";
+                            return array($query,array($pid));
+                            break;
             
             //G series for form menu inc
             case 'G1':
diff --git a/myportal/soap_service/server_side.php b/myportal/soap_service/server_side.php
index 5c7f31703..49a7a8b6b 100644
--- a/myportal/soap_service/server_side.php
+++ b/myportal/soap_service/server_side.php
@@ -781,7 +781,7 @@ static  public function batch_despatch($var,$func,$data_credentials){
 
 
   public function getversion($data){
-         return '1.3';
+         return '1.35';
     }