/home/techb158/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/Manager/save_teacher_preference.php (2216B)
'error', 'message' => ''];
$action = $_POST['action'] ?? '';
$teacherID = intval($_POST['teacher_id'] ?? 0);
$courseID = intval($_POST['course_id'] ?? 0);
$programID = intval($_POST['program_id'] ?? 0);
if (!isset($_SESSION['user_id']) || !$teacherID || !$courseID || !$programID) {
$response['message'] = 'Invalid parameters';
echo json_encode($response); exit;
}
if ($action === 'save_preferences') {
$priority = intval($_POST['priority'] ?? 0);
if ($priority < 1 || $priority > 2) {
$response['message'] = 'Invalid priority';
echo json_encode($response); exit;
}
$now = date('Y-m-d H:i:s');
$chk = $mysqli->prepare("SELECT T_C_P_ID FROM teacher_course_preferences WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?");
$chk->bind_param("iii", $teacherID, $programID, $courseID);
$chk->execute();
$chk->store_result();
if ($chk->num_rows > 0) {
$upd = $mysqli->prepare("UPDATE teacher_course_preferences SET Priority = ?, Date_Time = ? WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?");
$upd->bind_param("isiii", $priority, $now, $teacherID, $programID, $courseID);
$upd->execute();
$upd->close();
} else {
$ins = $mysqli->prepare("INSERT INTO teacher_course_preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time) VALUES (?, ?, ?, ?, ?)");
$ins->bind_param("iiiis", $teacherID, $programID, $courseID, $priority, $now);
$ins->execute();
$ins->close();
}
$chk->close();
$response['status'] = 'success';
$response['message'] = 'Preference saved';
} elseif ($action === 'remove_preference') {
$del = $mysqli->prepare("DELETE FROM teacher_course_preferences WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?");
$del->bind_param("iii", $teacherID, $programID, $courseID);
$del->execute();
$del->close();
$response['status'] = 'success';
$response['message'] = 'Preference removed';
}
echo json_encode($response);
?>