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();
