/home/techb158/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/Manager/updateteacherunavailability.php (11833B)
prepare("SELECT * FROM teacher_unavailability WHERE Unavailable_ID = ?");
$stmt->bind_param("i", $Unavailable_ID);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows != 1) {
die("Record not found.");
}
$data = $result->fetch_assoc();
$Teacher_ID = $data['Teacher_ID'];
$current_status = $data['status'] ?? 'confirmed';
$stmtTeachers = $mysqli->prepare("SELECT Teacher_ID, First_Name, Last_Name, Email FROM teacher_profile WHERE Teacher_ID = ? AND User_Access = 1 ORDER BY First_Name");
$stmtTeachers->bind_param("i", $Teacher_ID);
$stmtTeachers->execute();
$resultTeachers = $stmtTeachers->get_result();
$teacher = $resultTeachers->fetch_assoc();
$stmtTeachers->close();
$_SESSION['Teacher_ID'] = $Teacher_ID;
$error_msg = '';
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit'])) {
$Teacher_ID = $_SESSION['Teacher_ID'];
$Unavailable_From = $_POST['Unavailable_From'];
$Unavailable_To = $_POST['Unavailable_To'];
$status = $_POST['status'] ?? 'confirmed';
if ($Teacher_ID > 0 && !empty($Unavailable_From) && !empty($Unavailable_To)) {
$stmt = $mysqli->prepare("UPDATE teacher_unavailability SET Teacher_ID = ?, Unavailable_From = ?, Unavailable_To = ?, status = ? WHERE Unavailable_ID = ?");
$stmt->bind_param("isssi", $Teacher_ID, $Unavailable_From, $Unavailable_To, $status, $Unavailable_ID);
if ($stmt->execute()) {
$error_msg = "Updated successfully";
if ($status != $current_status && !empty($teacher['Email'])) {
$action = $status == 'confirmed' ? 'approved' : ($status == 'rejected' ? 'rejected' : 'pending');
$subject = "Unavailability Request " . ucfirst($action);
$message_body = "Dear " . htmlspecialchars($teacher['First_Name'] . ' ' . $teacher['Last_Name'], ENT_QUOTES, 'UTF-8') . ",
";
$message_body .= "Your unavailability request has been
" . $action . " by your manager.
";
if ($status == 'confirmed') {
$message_body .= "The dates you submitted are now marked as unavailable in the system.
";
} elseif ($status == 'rejected') {
$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\nContent-type:text/html;charset=iso-8859-1\r\nFrom: info
\r\n";
@mail($teacher['Email'], $subject, $message, $headers);
}
} else {
$error_msg = "Update failed.";
}
} else {
$error_msg = "Please fill in all fields.";
}
}
?>
Course Management System | Update Teacher Unavailabilit
$(document).ready(function() {
$('#modal-default').modal('show');
});
";
}
include 'main-header-inc.php';
?>