From: vinish <vinish@zhservices.com>
Date: Wed, 18 Jul 2012 13:07:25 +0000 (+0530)
Subject: We are using a field PrescriptionGUID, obtained from NewCrop, to check if the prescri... 
X-Git-Tag: whats-been-changed~491
X-Git-Url: https://repo.or.cz/w/openemr.git/commitdiff_plain/90871d4ee113b776dac943e6f314e730c02a13f2

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>
---

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'])