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/fetch_teacher_prefrence_courses.php (1887B)

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

$teacherID = intval($_POST['Teacher_ID'] ?? 0);
$programID = intval($_POST['Program_ID'] ?? 0);
if (!$teacherID || !$programID) { echo '<tr><td colspan="3" class="text-center text-muted">Select a teacher</td></tr>'; exit; }

$query = "SELECT c.Course_ID, c.Course_Name, 
    (SELECT tcp.Priority FROM teacher_course_preferences tcp WHERE tcp.Teacher_ID = ? AND tcp.Course_ID = c.Course_ID AND tcp.Program_ID = ?) as Priority
    FROM Courses c WHERE c.Program_ID = ? ORDER BY c.Course_ID";
$stmt = $mysqli->prepare($query);
$stmt->bind_param('iii', $teacherID, $programID, $programID);
$stmt->execute();
$res = $stmt->get_result();

$i = 1;
$html = '';
while ($row = $res->fetch_assoc()) {
    $checked = $row['Priority'] ? 'checked' : '';
    $disabled = $row['Priority'] ? '' : 'disabled';
    $firstSel = $row['Priority'] == 1 ? 'btn-primary' : 'btn-default';
    $secondSel = $row['Priority'] == 2 ? 'btn-primary' : 'btn-default';
    $html .= '<tr>
        <td><input type="checkbox" class="minimal crs-chk" data-i="'.$i.'" name="Course_ID[]" '.$checked.' value="'.$row["Course_ID"].'"></td>
        <td>'.htmlspecialchars($row["Course_Name"]).'</td>
        <td class="center">
            <div class="btn-group btn-group-sm">
                <button type="button" class="btn '.$firstSel.' prv-btn" data-p="1" data-i="'.$i.'" '.$disabled.'><b>First</b></button>
                <button type="button" class="btn '.$secondSel.' prv-btn" data-p="2" data-i="'.$i.'" '.$disabled.'><b>Second</b></button>
            </div>
            <i class="fa fa-spinner fa-spin loading-icon" id="load'.$i.'" style="display:none;margin-left:5px"></i>
        </td>
    </tr>';
    $i++;
}
echo $html;
?>

Select a teacher'; exit; } $query = "SELECT c.Course_ID, c.Course_Name, (SELECT tcp.Priority FROM teacher_course_preferences tcp WHERE tcp.Teacher_ID = ? AND tcp.Course_ID = c.Course_ID AND tcp.Program_ID = ?) as Priority FROM Courses c WHERE c.Program_ID = ? ORDER BY c.Course_ID"; $stmt = $mysqli->prepare($query); $stmt->bind_param('iii', $teacherID, $programID, $programID); $stmt->execute(); $res = $stmt->get_result(); $i = 1; $html = ''; while ($row = $res->fetch_assoc()) { $checked = $row['Priority'] ? 'checked' : ''; $disabled = $row['Priority'] ? '' : 'disabled'; $firstSel = $row['Priority'] == 1 ? 'btn-primary' : 'btn-default'; $secondSel = $row['Priority'] == 2 ? 'btn-primary' : 'btn-default'; $html .= ' '.htmlspecialchars($row["Course_Name"]).'

'; $i++; } echo $html; ?>