File manager - Edit - /home/autoph/public_html/pms_v1/mar/confirmMAR.php
Back
<?php include_once("../../../cfg/conn.php"); if(isset($_POST['confirmMAR'])){ $chkReceiver =0; $empSect = 0; //2 $empDept = 0; $empDivM = 0; $empDivG = 0; $empBrnh = 0; $empComp = 0; $empEmail = ""; $empMobile = ""; $myTimeStampExTX = str_replace(" ","",$myTimeStamp); $myTimeStampExTY = str_replace("-","",$myTimeStampExTX); $myTimeStampExT = str_replace(":","",$myTimeStampExTY); $userID = $_POST['userID']; $getMarHeader = $_POST['getMarHeader']; $getEmpRecordID = $_POST['getEmpRecordID']; $txtComment = $_POST['txtComment']; $rateeActionValue = $_POST['rateeActionValue']; $sql = "UPDATE mar_emp_header SET mar_status='CLOSED', `ratee_agreement`='1',`ratee_actionValue`='$rateeActionValue',`ratee_notes` = '$txtComment',`date_confirmed`='$myTimeStamp',`last_action`='Confirmed by employee',`date_modified`='$myTimeStamp' WHERE `id`='$getMarHeader'"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } //E-MAIL INFO $from = "support@autohubgroup.comp"; $subject = "NEW MAR SUBMITTED"; $msgBox = "Good day! New MAR has been submitted for your review and approval. For more details, please login to https://pms.autohub.ph"; $headers = "From:" . $from; //END OF EMAIL INFO //====================================================================== //GET COMPANY ASSIGNMENT $usrGetComp = "SELECT * FROM `pms_employee_data` WHERE `id`='$getEmpRecordID'"; $qComp = mysqli_query($conn,$usrGetComp); while($com=mysqli_fetch_array($qComp)){ $empCompany = $com['comp_id']; } //====================================================================== //====================================================================== $pmsCompOfficers = "SELECT * FROM `pms_officers` WHERE `comp_id`='$empCompany' GROUP BY `pms_officer_id`"; $qPms = mysqli_query($conn,$pmsCompOfficers); while($row=mysqli_fetch_array($qPms)){ $uGetComp = "SELECT * FROM `pms_employee_data` WHERE `id`='$getEmpRecordID'"; $uComp = mysqli_query($conn,$uGetComp); while($ucom=mysqli_fetch_array($uComp)){ $uEmail = $ucom['e-mail']; $uMobile = $ucom['mobile_no']; $uFname = $ucom['first_name']; $uLname = $ucom['last_name']; } $id = $row['id']; $chkReceiver = $row['pms_officer_id']; $myToken = $id ."".$myTimeStampExT; //20230523074312 //###################################### MAIL SENDER####################################################### mail($uEmail,$subject,$msgBox, $headers); //###################################### SMS SENDER ####################################################### $sql = "INSERT INTO pms_inbox ( `id`, `sender_id`, `subject`, `date_time`, `message`, `receiver_id`, `read_unread`, `group_msg_id`) VALUES ('', '$userID', 'New MAR Submitted', '$myTimeStamp', 'New MAR has been submitted', '$chkReceiver', '0', '$myToken')"; if ($conn->query($sql) === TRUE) { } else { } } //====================================================================== //====================================================================== //====================================================================== $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings