From 90871d4ee113b776dac943e6f314e730c02a13f2 Mon Sep 17 00:00:00 2001
From: vinish <vinish@zhservices.com>
Date: Wed, 18 Jul 2012 18:37:25 +0530
Subject: [PATCH] We are using a field PrescriptionGUID, obtained from NewCrop,
 to check if the prescription pulled from NewCrop already exist in OpenEMR and
 decide whether to perform updation or insertion to OpenEMR. But in NewCrop,
 while editing a prescription, the PrescriptionGUID changes each time it is
 saved. To solve the issue, we have another field OriginalPrescriptionGUID,
 which is set when the prescription is created for the first time and remains
 the same even after editing. We can use this field OriginalPrescriptionGUID
 to check the existence of a prescription, pulled from NewCrop, in OpenEMR.

Signed-off-by: vinish <vinish@zhservices.com>
---
 interface/soap_functions/soap_patientfullmedication.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/interface/soap_functions/soap_patientfullmedication.php b/interface/soap_functions/soap_patientfullmedication.php
index fc6f9704c..f23dc214d 100644
--- a/interface/soap_functions/soap_patientfullmedication.php
+++ b/interface/soap_functions/soap_patientfullmedication.php
@@ -139,7 +139,7 @@ for($i=0;$i<sizeof($medArray);$i++)
     }                
     }
     
-    $check=sqlStatement("select * from prescriptions where prescriptionguid=? and patient_id=? and prescriptionguid is not null",array($medArray[$i]['PrescriptionGuid'],$medArray[$i]['ExternalPatientID']));
+    $check=sqlStatement("select * from prescriptions where prescriptionguid=? and patient_id=? and prescriptionguid is not null",array($medArray[$i]['OriginalPrescriptionGuid'],$medArray[$i]['ExternalPatientID']));
     $prescription_id='';
     if(sqlNumRows($check)==0)
     {        
@@ -153,7 +153,7 @@ for($i=0;$i<sizeof($medArray);$i++)
         array($medArray[$i]['ExternalPatientID'], $provider['id'],$encounter, substr($medArray[$i]['PrescriptionDate'],0,10), $medArray[$i]['DrugName'],
         $medArray[$i]['DrugID'], $medArray[$i]['DrugInfo'], $rin['option_id'], $medArray[$i]['DosageNumberDescription'], number($medArray[$i]['Strength']), $runit['option_id'],
         $rroute['option_id'], $rint['option_id'], $medArray[$i]['Refills'], $medArray[$i]['PrescriptionNotes'], 
-        $_SESSION['authUserID'], $medArray[$i]['SiteID'], $medArray[$i]['PrescriptionGuid'], $medArray[$i]['rxcui']));
+        $_SESSION['authUserID'], $medArray[$i]['SiteID'], $medArray[$i]['OriginalPrescriptionGuid'], $medArray[$i]['rxcui']));
         $j++;
     }
     else
@@ -165,7 +165,7 @@ for($i=0;$i<sizeof($medArray);$i++)
         ",array($provider['id'],$medArray[$i]['DrugName'],$medArray[$i]['DrugID'],$medArray[$i]['DrugInfo'],$rin['option_id'],$medArray[$i]['DosageNumberDescription'],
         number($medArray[$i]['Strength']),$runit['option_id'],$rroute['option_id'],$rint['option_id'],$medArray[$i]['Refills'],
         $medArray[$i]['PrescriptionNotes'],$_SESSION['authUserID'],
-        $medArray[$i]['SiteID'],$medArray[$i]['rxcui'],$medArray[$i]['PrescriptionGuid'],$medArray[$i]['ExternalPatientID']));
+        $medArray[$i]['SiteID'],$medArray[$i]['rxcui'],$medArray[$i]['OriginalPrescriptionGuid'],$medArray[$i]['ExternalPatientID']));
     }
     $result=sqlFetchArray($check);
     if($result['id'])
-- 
2.11.4.GIT