/home/techb158/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/Manager/approve_teacher_absence.php (2230B)
prepare("UPDATE teacher_absences SET status = ? WHERE Absence_ID = ?");
if (!$stmt) {
echo "Database error.";
exit;
}
$stmt->bind_param("si", $newStatus, $Absence_ID);
if (!$stmt->execute()) {
echo "Could not update status.";
$stmt->close();
exit;
}
$stmt->close();
// Send email notification to the teacher
if (!empty($teacher_email)) {
$subject = "Absence Request " . ucfirst($action) . "d";
if ($action == 'approve') {
$message_body = "Dear " . htmlspecialchars($teacher_name, ENT_QUOTES, 'UTF-8') . ",
";
$message_body .= "Your absence/leave request has been
approved by your manager.
";
$message_body .= "The dates you submitted are now marked as absent in the system.
";
$message_body .= "Thank you.
Course Management System";
} else {
$message_body = "Dear " . htmlspecialchars($teacher_name, ENT_QUOTES, 'UTF-8') . ",
";
$message_body .= "Your absence/leave request has been
rejected by your manager.
";
$message_body .= "Please contact your manager for more details.
";
$message_body .= "Thank you.
Course Management System";
}
$message = '
' . $subject . '' . $message_body . '';
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$headers .= 'From: info
' . "\r\n";
@mail($teacher_email, $subject, $message, $headers);
}
echo "success";
?>