function sendMessage() { include "dbitcon.php"; //Grab data from the form $msgreply = $_POST['msgreply']; $MsgSubject = $_POST['Subject']; $wid = $_POST['wid']; //Write Message $To = $_POST['MTo']; $CC = $_SESSION['Email']; $senderEmail = $_SESSION['Email']; $MFrom = $senderEmail; $Subject = "" . $MsgSubject . ""; $message = "" . $msgreply . ""; $headers = "From: <*****@*****.**>\r\n"; $headers .= "Reply-To: " . strip_tags($MFrom) . "\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; //Send the Message try { // mail($To, $Subject, $message, $headers); } catch (Exception $e) { error_log("Can't send mail"); } //Store the Message $mid = StoreMessage($To, $CC, $Subject, $message, $MFrom, $wid); //Update Message Status $msgs = "UPDATE Messages SET MStatus = 'Sent' WHERE mid = " . $mid . ""; $updateMessageq = sqlsrv_query($conn, $msgs); }
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); } } }