function OEMeditUpdateWorkflow($WFStatus, $Response, $wid, $oemrecordid, $ReasonNo, $srid)
{
//Connect to database
$serverName = "SQL\\SERVER";
$connectionOptions = array("UID" => "coms_db_user", "PWD" => "xxxx", "Database" => "COMS_UAT_VA_TEST");
$conn = sqlsrv_connect($serverName, $connectionOptions);
//Get Patient ID
$psql = "SELECT Patient_ID from Master_Template where Template_ID = '{$oemrecordid}'";
$pid = sqlsrv_query($conn, $psql);
while ($row = sqlsrv_fetch_array($pid, SQLSRV_FETCH_ASSOC)) {
$Patient_ID = $row['Patient_ID'];
}
//Get Patient's Name from Patient Table
$pname = "SELECT First_Name,Last_Name FROM Patient WHERE Patient_ID = '{$Patient_ID}'";
$piname = sqlsrv_query($conn, $pname);
while ($row = sqlsrv_fetch_array($piname, SQLSRV_FETCH_ASSOC)) {
$FirstName = $row['First_Name'];
$LastName = $row['Last_Name'];
}
//Get Sender of Change Email Address from Roles Table
$tsql = "SELECT * FROM Roles WHERE rid = '{$srid}'";
$getemail = sqlsrv_query($conn, $tsql);
while ($row = sqlsrv_fetch_array($getemail, SQLSRV_FETCH_ASSOC)) {
$PharmEmail = $row['Email'];
}
if ($WFStatus == "Update") {
if ($Response == "Approved") {
//Write Message
$To = $PharmEmail;
//$To = "*****@*****.**";
$CC = $_SESSION['Email'];
$senderEmail = $_SESSION['Email'];
$MFrom = $senderEmail;
//$Subject = "Order Change Approved for Patient ".$FirstName." ".$LastName.", Workflow ID: ".$wid."";
$Subject = "Order Change Approved for Patient " . $FirstName . " " . $LastName . "";
$message = "<html><body>Order Change Approved (Workflow ID: " . $wid . ")<br><br> </body></html>";
$headers = "From: <*****@*****.**>\r\n";
//$headers .= "Reply-To: <*****@*****.**>\r\n";
$headers .= "Reply-To: " . strip_tags($MFrom) . "\r\n";
//$headers .= "CC: sean.cassidy@dbitmail.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
try {
// mail($To, $Subject, $message, $headers);
} catch (Exception $e) {
error_log("Can't send mail");
}
//Store Message
StoreMessage($To, $CC, $Subject, $message, $MFrom, $wid);
//Write Workflow History
WFHistory($wid, $ReasonNo, $WFStatus, $Response);
} elseif ($Response == "NotApproved") {
//Write Message
$To = $PharmEmail;
//$To = "*****@*****.**";
$CC = $_SESSION['Email'];
$senderEmail = $_SESSION['Email'];
$MFrom = $senderEmail;
$Subject = "Order Change Not Approved for Patient " . $FirstName . " " . $LastName . ", Workflow ID: " . $wid . "";
$message = "<html><body>Order Change Not Approved (Workflow ID: " . $wid . ")<br><br> </body></html>";
$headers = "From: <*****@*****.**>\r\n";
//$headers .= "Reply-To: <*****@*****.**>\r\n";
$headers .= "Reply-To: " . strip_tags($MFrom) . "\r\n";
//$headers .= "CC: sean.cassidy@dbitmail.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
try {
// mail($To, $Subject, $message, $headers);
} catch (Exception $e) {
error_log("Can't send mail");
}
//Store Message
StoreMessage($To, $CC, $Subject, $message, $MFrom, $wid);
//Write Workflow History
WFHistory($wid, $ReasonNo, $WFStatus, $Response);
}
}
// Close the connection.
//sqlsrv_close($conn);
}
<?php
include "session.php";
include "workflow.php";
$wid = $_GET['wid'];
$srid = $_GET['srid'];
$Response = $_GET['Response'];
$ReasonNo = $_GET['ReasonNo'];
$oemrecordid = $_GET['oemrecordid'];
$WFStatus = "Update";
echo "<link rel='stylesheet' type='text/css' href='js/UAT_18June2012/COMS.css'>";
echo "<table align='center'>";
echo "<tr><td> </td></tr>";
echo "<tr><td>Update Workflow</td></tr>";
WFHistory($wid, $ReasonNo, $WFStatus, $Response);
if ($ReasonNo == 4 || $ReasonNo == 5 || $ReasonNo == 6 || $ReasonNo == 7 || $ReasonNo == 8 || $ReasonNo == 9 || $ReasonNo == 10 || $ReasonNo == 11) {
echo "<tr><td><br>Show Changes<br><br></td></tr>";
echo "<tr><td><a href='WorkflowUpdate.php?Response=Approved&wid=" . $wid . "&oemrecordid=" . $oemrecordid . "&WFStatus=" . $WFStatus . "&ReasonNo=" . $ReasonNo . "&srid=" . $srid . "'>Approved</a> or <a href='WorkflowUpdate.php?Response=NotApproved&wid=" . $wid . "&oemrecordid=" . $oemrecordid . "&WFStatus=" . $WFStatus . "&ReasonNo=" . $ReasonNo . "&srid=" . $srid . "'>Not Approved</a><br></td></tr>";
echo "<tr><td> </td></tr>";
echo "<tr><td>You have marked your response as <b>" . $Response . "</b>.<br></td></tr>";
if ($Response != "Received") {
OEMeditUpdateWorkflow($WFStatus, $Response, $wid, $oemrecordid, $ReasonNo, $srid);
echo "<tr><td>The order has been updated and the sender has been notifed.</td></tr>";
}
}
echo "</table>";
function OEMeditUpdateWorkflow($WFStatus, $Response, $wid, $oemrecordid, $ReasonNo, $srid)
{
//Get body for Message and workflow NoSteps
$wfinfo = "SELECT * FROM Workflows WHERE ReasonNo = '{$ReasonNo}'";
$wfi = $this->query($wfinfo);
foreach ($wfi as $row) {
$Body = $row['Body'];
$NoSteps = $row['NoSteps'];
}
//Get Patient ID
$psql = "SELECT Patient_ID from Master_Template where Template_ID = '{$oemrecordid}'";
$pid = $this->query($psql);
foreach ($pid as $row) {
$Patient_ID = $row['Patient_ID'];
}
//Get Patient's Name from Patient Table
$pname = "SELECT First_Name,Last_Name FROM Patient WHERE Patient_ID = '{$Patient_ID}'";
$piname = $this->query($pname);
foreach ($piname as $row) {
$FirstName = $row['First_Name'];
$LastName = $row['Last_Name'];
}
//Get Sender of Change Email Address from Roles Table
$tsql = "SELECT * FROM Roles WHERE rid = '{$srid}'";
$getemail = $this->query($tsql);
foreach ($getemail as $row) {
$PharmEmail = $row['Email'];
}
if ($WFStatus == "Update") {
if ($Response == "Approved") {
//Write Message
$To = $PharmEmail;
//$To = "*****@*****.**";
$CC = $_SESSION['Email'];
$senderEmail = $_SESSION['Email'];
$MFrom = $senderEmail;
//$Subject = "Order Change Approved for Patient " . $FirstName . " " . $LastName . ", Workflow ID: " . $wid . "";
$Subject = "Order Change Approved for Patient " . $FirstName . " " . $LastName . "";
$message = "<html><body>Order Change Approved (Workflow ID: " . $wid . ")<br><br> </body></html>";
$headers = "From: <*****@*****.**>\r\n";
//$headers .= "Reply-To: <*****@*****.**>\r\n";
$headers .= "Reply-To: " . strip_tags($MFrom) . "\r\n";
//$headers .= "CC: sean.cassidy@dbitmail.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
mail($To, $Subject, $message, $headers);
//Store Message
StoreMessage($To, $CC, $Subject, $message, $MFrom, $wid);
//Write Workflow History
WFHistory($wid, $ReasonNo, $WFStatus, $Response);
} elseif ($Response == "NotApproved") {
//Write Message
$To = $PharmEmail;
//$To = "*****@*****.**";
$CC = $_SESSION['Email'];
$senderEmail = $_SESSION['Email'];
$MFrom = $senderEmail;
//$Subject = "Order Change Not Approved for Patient " . $FirstName . " " . $LastName . ", Workflow ID: " . $wid . "";
$Subject = "Order Change Not Approved for Patient " . $FirstName . " " . $LastName . "";
$message = "<html><body>Order Change Not Approved (Workflow ID: " . $wid . ")<br><br> </body></html>";
$headers = "From: <*****@*****.**>\r\n";
//$headers .= "Reply-To: <*****@*****.**>\r\n";
$headers .= "Reply-To: " . strip_tags($MFrom) . "\r\n";
//$headers .= "CC: sean.cassidy@dbitmail.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
mail($To, $Subject, $message, $headers);
//Store Message
StoreMessage($To, $CC, $Subject, $message, $MFrom, $wid);
//Write Workflow History
WFHistory($wid, $ReasonNo, $WFStatus, $Response);
}
}
}
