/home/techb158/workloadmatch.com/Manager
Edit: /home/techb158/workloadmatch.com/Manager/dashboard.php (21103B)
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;
// Total Teachers
$stmt = $mysqli->prepare("SELECT COUNT(*) FROM teacher_profile WHERE Manager_ID = ?");
$stmt->bind_param("s", $Manager_ID);
$stmt->execute();
$stmt->bind_result($totalTeachers);
$stmt->fetch();
$stmt->close();
// Accounting Groups
$stmt = $mysqli->prepare("SELECT COUNT(*) FROM manager_group_name WHERE Manager_ID = ? AND Program_ID = 1");
$stmt->bind_param("s", $Manager_ID);
$stmt->execute();
$stmt->bind_result($acctGroups);
$stmt->fetch();
$stmt->close();
// Secretarial Groups
$stmt = $mysqli->prepare("SELECT COUNT(*) FROM manager_group_name WHERE Manager_ID = ? AND Program_ID = 2");
$stmt->bind_param("s", $Manager_ID);
$stmt->execute();
$stmt->bind_result($secGroups);
$stmt->fetch();
$stmt->close();
// Accounting Courses
$stmt = $mysqli->prepare("SELECT COUNT(*) FROM Courses WHERE Program_ID = 1");
$stmt->execute();
$stmt->bind_result($acctCourses);
$stmt->fetch();
$stmt->close();
// Secretarial Courses
$stmt = $mysqli->prepare("SELECT COUNT(*) FROM Courses WHERE Program_ID = 2");
$stmt->execute();
$stmt->bind_result($secCourses);
$stmt->fetch();
$stmt->close();
?>
Course Management System | Dashboard
Notice: " . htmlspecialchars($_SESSION['role_notice']) . "
";
unset($_SESSION['role_notice']);
}
include 'main-header-inc.php';
?>