File manager - Edit - /home/autoph/public_html/pms_v1/mar/approveMAR.php
Back
<?php include_once("../../../cfg/conn.php"); if(isset($_POST['approveMAR'])){ $chkReceiver =0; $empMobile = ""; $myTimeStampExTX = str_replace(" ","",$myTimeStamp); $myTimeStampExTY = str_replace("-","",$myTimeStampExTX); $myTimeStampExT = str_replace(":","",$myTimeStampExTY); $userID = $_POST['userID']; $getMarHeader = $_POST['getMarHeader']; $getEmpRecordID = $_POST['getEmpRecordID']; $sql = "UPDATE mar_emp_header SET mar_status='EMP. CONFIMATION', `mar_approved`='1',`mar_approved_by` = '$userID',`mar_approved_date`='$myTimeStamp',`last_action`='Approved by Head',`date_modified`='$myTimeStamp' WHERE `id`='$getMarHeader'"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } //=========================================================================================== //=========================================================================================== //=========================================================================================== //get employees information so we can query the approver based on setup //E-MAIL INFO $from = "support@autohubgroup.comp"; $to=""; $subject = "POSTED MAR"; $msgBox = "Good day! Your MAR has been approved and waiting for your confirmation. For more details, please login to https://pms.autohub.ph"; $headers = "From:" . $from; //END OF EMAIL INFO $qApprover = "SELECT * FROM `pms_employee_data` WHERE `id`='$getEmpRecordID'"; $qApr = mysqli_query($conn,$qApprover); while($row=mysqli_fetch_array($qApr)){ $id = $row['id']; $to = $row['e-mail']; $chkReceiver = $row['id']; $empMobile = $row['mobile_no']; $myToken = $id ."".$myTimeStampExT; //20230523074312 //###################################### MAIL SENDER####################################################### mail($to,$subject,$msgBox, $headers); //###################################### SMS SENDER ####################################################### //$result = itexmoAA($empMobile, $msgBox); //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!"; //} //insert to inbox table $sql = "INSERT INTO pms_inbox ( `id`, `sender_id`, `subject`, `date_time`, `message`, `receiver_id`, `read_unread`, `group_msg_id`) VALUES ('', '$userID', 'MAR for approval', '$myTimeStamp', 'Your MAR has been approved. Waiting for your confirmation', '$chkReceiver', '0', '$myToken')"; if ($conn->query($sql) === TRUE) { } else { } } $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings