query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $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 '';
//}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();
}
?>