/home/techb158/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/Manager/fetch_teachers_by_group_legacy.php (2421B)
prepare("SELECT Time_Slot FROM manager_group_name WHERE Group_ID = ? AND Program_ID = ?");
$stmt->bind_param("ii", $Group_ID, $Program_ID);
$stmt->execute();
$group = $stmt->get_result()->fetch_assoc();
$stmt->close();
if (!$group) {
echo "
";
exit;
}
$groupTimeSlot = trim($group['Time_Slot']);
$timeSlotArray = array_map('trim', explode(',', $groupTimeSlot));
$groupTime = $timeSlotArray[0]; // Use the first slot
// 2. Get all courses for this group
$stmt = $mysqli->prepare("SELECT Course_ID FROM course_group_schedule_main WHERE Group_ID = ? AND Program_ID = ? AND Assigned = 0");
$stmt->bind_param("ii", $Group_ID, $Program_ID);
$stmt->execute();
$courseResults = $stmt->get_result();
$courseIDs = [];
while ($row = $courseResults->fetch_assoc()) {
$courseIDs[] = $row['Course_ID'];
}
$stmt->close();
if (empty($courseIDs)) {
echo "
";
exit;
}
$courseIDList = implode(",", array_map('intval', $courseIDs));
// 3. Get available teachers with preferred course and preferred time slot
$stmt = $mysqli->prepare("
SELECT tp.Teacher_ID, tp.First_Name, tp.Last_Name
FROM teacher_profile tp
WHERE tp.User_Access = 1
AND FIND_IN_SET(?, tp.Time_Slot) > 0
AND EXISTS (
SELECT 1 FROM teacher_course_preferences tcp
WHERE tcp.Teacher_ID = tp.Teacher_ID
AND tcp.Course_ID IN ($courseIDList)
)
ORDER BY tp.First_Name ASC
");
$stmt->bind_param("s", $groupTime);
$stmt->execute();
$teachers = $stmt->get_result();
$options = "";
while ($teacher = $teachers->fetch_assoc()) {
$options .= "
";
}
echo $options ?: "
";
}
?>