function productMatch($woundID, $productID, $patientID) { $admissionID = getLastAdmissionID($patientID); $db = getDBConn(getCurrentUser()); $stmt = $db->prepare("Select Count(*) As Matches from AT_OrderProductWounds where WoundID = :woundID and AdmissionID = :admissionID_1 and OPID IN (Select ID from AT_CMNProducts where ProductID = :productID and admissionID = :admissionID_2)"); $stmt->execute(array(':woundID' => $woundID, ':admissionID_1' => $admissionID, ':productID' => $productID, ':admissionID_2' => $admissionID)); $result = $stmt->fetchColumn(); return $result; }
$orderArray[] = array('New' => $newOrderLink, 'Admission Date' => $date, 'Expiration Date' => $expirationDate, 'Account Number' => $order['PatientNum'], 'Name' => $order['PatientName'], 'DOB' => $order['DOB'], 'Clinic' => $order['CompanyName'], 'Status' => $status, 'Tracking Number' => $trackingLink, 'Shipment Note' => $order['CancellationNote']); } $orderObj = json_encode($orderArray); echo $orderObj; }); /** * * @AJAX Action - Builds array of patient information for all clinics associated with a user * and returns JSON string to be processed by Javascript in the browser * **/ $app->get('/buildPatientTable/:id/', function ($userID) use($app) { $patientArray = array(); $patients = getPatientsByUser($userID); foreach ($patients as $patient) { $admission = getAdmission(getLastAdmissionID($patient['PatientID'])); $newOrderLink = '<a href="/webOrders/new/' . $admission[0]['ClinicID'] . '/' . $patient['PatientID'] . '"><i class="fa fa-edit fa-fw"></i></a>'; $patientArray[] = array('New' => $newOrderLink, 'Patient Name' => $patient['PatientName'], 'DOB' => $patient['PatDOB'], 'Account Number' => $patient['PatientNum'], 'Clinic' => $patient['CompanyName'], 'Patient Number' => $patient['PatientNum']); } $patientObj = json_encode($patientArray); echo $patientObj; }); /** * * @AJAX Action - Verifies an NPI number against our DB, if none found, * verifies the same NPI number against HIPAA Space * Returns JSON string with information about the physician if a match found * **/ $app->get('/verifyNPI/:npi/:clinic/', function ($npi, $clinic) use($app) { $user = getCurrentUser();