/home/techb158/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/Manager/duplicate_assignment_report.php (9423B)
prepare("SELECT DISTINCT YEAR(Start_Date) AS Yr, MONTH(Start_Date) AS Mo FROM teacher_course_assignments WHERE Teacher_ID IN (SELECT Teacher_ID FROM teacher_profile WHERE Manager_ID = ?) ORDER BY Start_Date DESC");
$stmt->bind_param("s", $Manager_ID);
$stmt->execute();
$res = $stmt->get_result();
while ($row = $res->fetch_assoc()) {
$sy = (int)$row['Yr'];
$mo = (int)$row['Mo'];
$semYear = ($mo >= 8) ? $sy : $sy - 1;
if (!in_array($semYear, $semesterYears)) {
$semesterYears[] = $semYear;
}
}
$stmt->close();
$semesterYear = !empty($semesterYears) ? $semesterYears[0] : $currentYear;
?>
Course Management System | Duplicate Assignment Report
| Teachers |
Course |
Group |
Program |
Time Slots |
Start Date |
End Date |
Duplicates |
| Select a program to view duplicate assignments. |
| Teachers |
Course |
Group |
Program |
Time Slots |
Start Date |
End Date |
Duplicates |