Total Teachers
Total Groups
Total Courses
Total Assignments
Unassigned Courses
%
Teacher Utilization
Most Requested Course
preferences
Monthly Assignments
Assignment Trend
Available Teachers & Total Load
-
0
// Assuming Teacher_Profile has fields: Teacher_ID, First_Name, Last_Name, Load_Hours
// and we calculate total assigned hours from Teacher_Course_Assignments joined with Courses (Course_Time)
$query = "SELECT tp.Teacher_ID, tp.First_Name, tp.Last_Name, tp.Load_Hours,tp.User_Img,
(SELECT IFNULL(SUM(c.Course_Time),0)
FROM Teacher_Course_Assignments tca
JOIN Courses c ON tca.Course_ID = c.Course_ID
WHERE tca.Teacher_ID = tp.Teacher_ID) AS AssignedHours
FROM Teacher_Profile tp
WHERE tp.Manager_ID = ?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("s", $Manager_ID);
$stmt->execute();
$result = $stmt->get_result();
while ($teacher = $result->fetch_assoc()) {
$assigned = $teacher['AssignedHours'];
$maxLoad = $teacher['Load_Hours'];
$User_Img = $teacher['User_Img'];
$remaining = $maxLoad - $assigned;
// Only display teachers with remaining load hours greater than zero
if ($remaining > 0) {
?>
-
hrs left Total Load: hrs, Assigned: hrs
close();
?>
Groups Overview
| Group Name | Time Slot | Weekend Class | Start Time | End Time |
|---|---|---|---|---|
| " . htmlspecialchars($row["Group_Name"]) . " | " . htmlspecialchars($row["Time_Slot"]) . " | " . (($row["Weekend_Class"] == 1) ? 'Yes' : 'No') . " | " . htmlspecialchars($row["Time_From"]) . " | " . htmlspecialchars($row["Time_To"]) . " |