From b39d8ac4efb8621b9650174e2e306c24d9d04b1d Mon Sep 17 00:00:00 2001
From: bradymiller <bradymiller@users.sourceforge.net>
Date: Thu, 8 Nov 2012 01:55:30 -0800
Subject: [PATCH] Revert "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."

This reverts commit 90871d4ee113b776dac943e6f314e730c02a13f2.
---
 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 f23dc214d..fc6f9704c 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]['OriginalPrescriptionGuid'],$medArray[$i]['ExternalPatientID']));
+    $check=sqlStatement("select * from prescriptions where prescriptionguid=? and patient_id=? and prescriptionguid is not null",array($medArray[$i]['PrescriptionGuid'],$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]['OriginalPrescriptionGuid'], $medArray[$i]['rxcui']));
+        $_SESSION['authUserID'], $medArray[$i]['SiteID'], $medArray[$i]['PrescriptionGuid'], $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]['OriginalPrescriptionGuid'],$medArray[$i]['ExternalPatientID']));
+        $medArray[$i]['SiteID'],$medArray[$i]['rxcui'],$medArray[$i]['PrescriptionGuid'],$medArray[$i]['ExternalPatientID']));
     }
     $result=sqlFetchArray($check);
     if($result['id'])
-- 
2.11.4.GIT