/home/techb158/workloadmatch.com/Teacher/Inc
Edit: /home/techb158/workloadmatch.com/Teacher/Inc/Update_Course_Preference_Secretarial.php (5474B)
$course_id) {
$course_id = intval($_POST['course_id']); // ✅ Ensure proper type
$priority = $_POST['priority'];
//echo json_encode(["status" => "error", "message" => $priority]);
//exit;
// Convert priority to an integer value
if ($priority == "First") {
$priority = 1;
} else if ($priority == "Second") {
$priority = 2;
} else if ($priority == "Third") {
$priority = 3;
} else {
$priority = 0; // Default case
}
//if (!$priority) {
// echo json_encode(["status" => "error", "message" => "Invalid priority value."]);
// exit;
//}
// Check if record exists
$stmt = $mysqli->prepare("
SELECT 1 FROM teacher_course_preferences
WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?
");
$stmt->bind_param("iii", $teacher_id, $program_id, $course_id);
$stmt->execute();
$stmt->store_result();
$exists = $stmt->num_rows > 0;
$stmt->close();
if ($exists) {
// Update existing preference
$update_stmt = $mysqli->prepare("
UPDATE teacher_course_preferences
SET Priority = ?, Date_Time = ?
WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?
");
$update_stmt->bind_param("isiii", $priority, $date_time, $teacher_id, $program_id, $course_id);
$update_stmt->execute();
$update_stmt->close();
echo json_encode(["status" => "success", "message" => "Preferences updated successfully!"]);
} else {
// Insert new preference
$insert_stmt = $mysqli->prepare("
INSERT INTO teacher_course_preferences (Teacher_ID, Program_ID, Course_ID, Priority, Date_Time)
VALUES (?, ?, ?, ?, ?)
");
$insert_stmt->bind_param("iiiis", $teacher_id, $program_id, $course_id, $priority, $date_time);
$insert_stmt->execute();
$insert_stmt->close();
echo json_encode(["status" => "success", "message" => "Preferences saved successfully!"]);
}
$pname = ($priority == 1) ? 'First' : (($priority == 2) ? 'Second' : 'Third');
$cname_q = $mysqli->query("SELECT Course_Name FROM Courses WHERE Course_ID = $course_id");
$cname = $cname_q ? $cname_q->fetch_assoc()['Course_Name'] : 'Course #'.$course_id;
$tp_q = $mysqli->query("SELECT Phone, SMS_Carrier FROM teacher_profile WHERE Teacher_ID = $teacher_id");
if ($tp_q) {
$tp = $tp_q->fetch_assoc();
$tp_phone = $tp['Phone'];
$tp_carrier = $tp['SMS_Carrier'];
if ($tp_carrier > 0 && $tp_phone) {
$gw_q = $mysqli->query("SELECT Gateway FROM sms_gateways WHERE Gateways_ID = $tp_carrier");
if ($gw_q) {
$gw = $gw_q->fetch_assoc();
$sms_addr = $tp_phone . $gw['Gateway'];
$subj = "Course Preference Saved";
$msg = "Your preference for \"$cname\" has been saved as $pname priority.";
@mail($sms_addr, $subj, $msg, "From: info@workloadmatch.com\r\n");
}
}
}
//}
} else {
echo json_encode(["status" => "error", "message" => "No courses selected or missing data."]);
}
// Close database connection
$mysqli->close();
exit;
}else if (isset($_POST['action']) && $_POST['action'] === 'remove_preference' && !empty($_POST['course_id'])) {
$course_id = intval($_POST['course_id']);
$teacher_id = $_SESSION['user_id'];
$program_id = 2;
// Ensure Teacher_ID and Program_ID are properly set
if (!isset($teacher_id, $program_id)) {
echo json_encode(["status" => "error", "message" => "Missing teacher or program ID."]);
exit;
}
// Delete preference from the database
$delete_stmt = $mysqli->prepare("
DELETE FROM teacher_course_preferences
WHERE Teacher_ID = ? AND Program_ID = ? AND Course_ID = ?
");
$delete_stmt->bind_param("iii", $teacher_id, $program_id, $course_id);
$delete_stmt->execute();
$delete_stmt->close();
echo json_encode(["status" => "success", "message" => "Preference removed successfully!"]);
exit;
}