Lab results in patient portal Medical Records tab.
authorAjil <ajilpm@zhservices.com>
Thu, 17 Jan 2013 15:22:29 +0000 (17 20:52 +0530)
committerbradymiller <bradymiller@users.sourceforge.net>
Thu, 17 Jan 2013 19:23:45 +0000 (17 11:23 -0800)
Signed-off-by: Ajil <ajilpm@zhservices.com>
myportal/soap_service/server_existingpatient.php
myportal/soap_service/server_side.php

index fa9bd95..960d994 100644 (file)
@@ -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':
index 5c7f317..49a7a8b 100644 (file)
@@ -781,7 +781,7 @@ static  public function batch_despatch($var,$func,$data_credentials){
 
 
   public function getversion($data){
-         return '1.3';
+         return '1.35';
     }