File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_saveOverrideApproval.php

Back
<?php include_once 'core/init.php'; $myUid= $_GET['uid']; if(isset($_POST['done'])){ $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $myoverrideNotes = mysql_escape_string($_POST['myoverrideNotes']); $senderID = mysql_escape_string($_POST['senderID']); $itemID = mysql_escape_string($_POST['itemID']); $overEMPExecutiveID = mysql_escape_string($_POST['overEMPExecutiveID']); $overEMPMobile = mysql_escape_string($_POST['overEMPMobile']); $overEMPID = mysql_escape_string($_POST['overEMPID']); $getPRFHeader = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$getPRFHeader'"),0); $chkAuthID = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_validate_links` WHERE `sms_link` like '%xcom%' AND `item_id`='$itemID' AND `uid`='$overEMPExecutiveID' AND `po_code`='$getPRFHeader' AND `completed`=0"),0); if($chkAuthID == 1){ mysql_query("INSERT INTO prf_overriderequest(item_id,requesting_officer_id,override_emp_id,requested_by,notes) VALUES('{$itemID}','{$overEMPExecutiveID}','{$myUid}','{$myUid}','{$myoverrideNotes}')"); mysql_query("UPDATE `prf_validate_links` SET `override_notes`='$myoverrideNotes',`completed`=0 WHERE `item_id`='$itemID' AND `po_code` ='$getPRFHeader' AND `uid`='$overEMPExecutiveID'"); $getLink = mysql_result(mysql_query("SELECT `sms_link` FROM `prf_validate_links` WHERE `sms_link` like '%xcom%' AND `item_id`='$itemID' AND `uid`='$overEMPExecutiveID' AND `po_code`='$getPRFHeader'"),0); $SMSMessage = "Override Approval Request. \n\nPRF#:".$getPRFHeader." \n\n". $getLink; $empFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$overEMPID'"),0); $empEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$overEMPID'"),0); $itemIDesc = mysql_result(mysql_query("SELECT `item_description` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $result = itexmoAA($overEMPMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo '<script>alert("No response from SMS server. SMS failed to send")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; } else{ //echo "Error Num ". $result . " was encountered!"; } //####################################################################### //echo "Request has been sent."; echo '<script>alert("Request has been sent to assigned officer.")</script>'; //####################################################################### }else{ //####################################################################### echo '<script>alert("Invalid request: Override Approval Request only applies to item concerning the company president.")</script>'; //####################################################################### } //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### $from = "procurement@autohubgroup.com"; $to = $empEmail; $subject = "APPROVAL OVERRIDE REQUEST"; $msgBox = "Hi ".$empFName."! New request for canvass approval override has been sent to you for your action. PRF#".$getPRFHeader." Requested item: ".$itemIDesc.". Just click or copy/paste the link below to access the record. ".$getLink; $headers = "From:" . $from; mail($to,$subject,$msgBox, $headers); //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings