FM / Master

/home/techb158/workloadmatch.com/Master/

/home/techb158/workloadmatch.com/Master

Name	Size	Mode	Actions
addgroup.php	6908	0644	edit dl rm
addmanager.php	14495	0644	edit dl rm
adduser.php	11148	0644	edit dl rm
assign_teacher_manual.php	3879	0644	edit dl rm
chat.php	16850	0644	edit dl rm
dashboard.php	13677	0644	edit dl rm
fetch_teacher_prefrence_courses.php	1887	0644	edit dl rm
inc.php	551	0644	edit dl rm
Lockup_to_Assign.php	3662	0644	edit dl rm
main-header-inc.php	1276	0644	edit dl rm
main-header.php	15374	0644	edit dl rm
preference_accounting.php	9416	0644	edit dl rm
preference_secretarial.php	9416	0644	edit dl rm
profile.php	17094	0644	edit dl rm
profile_bak.php.disabled	3195	0644	edit dl rm
save_teacher_preference.php	2107	0644	edit dl rm
set_manager.php	1305	0644	edit dl rm
teacher_absence.php	305	0644	edit dl rm
teacher_preference.php	3798	0644	edit dl rm
teacher_preference_by_course.php	3833	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/Master/save_teacher_preference.php (2107B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';
sec_session_start();
require_role($mysqli, 'master_profile');

$response = ['status' => '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';
} 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';
}
echo json_encode($response);
?>

'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'; } 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'; } echo json_encode($response); ?>