foreach ($course_list as $c) {
$num_students = $model->fetchCountStudents(array('Exam'), $c['code'], $c['section'], $selected_semester);
$count_professor_requests = $model->fetchCountProfessorRequests($c['code'], $c['section'], $selected_semester, $c['teaching_method']);
//Processing for quick stat 1 and quick stat 3
$quick_stat_1_changed = false;
$quick_stat_3_changed = false;
if ($count_professor_requests > 0) {
//If requests do exist, get each of these requests
$course_requests = $model->fetchDataProfessorRequests($c['code'], $c['section'], $selected_semester, $c['teaching_method']);
if (!(FACULTY_ALERTS_SHOW_ONLY_FOR_NOE_TEACH_METHODS && !in_array($c['teaching_method'], $noe_teach_methods))) {
foreach ($course_requests as $cr) {
//Quick stat 1: For each request, check if the exam is 48 hours to 72 hours away
$exam_range_to_consider = unserialize(FACULTY_ALERTS_CONSIDER_EXAM_RANGE_DAYS_BEFORE_EXAM);
if (time() > \Ventus\Utilities\Functions::findNextBusinessDay(strtotime(date('Y-m-d ', strtotime($cr['exam_date'])) . FACULTY_EXAM_MODIFICATIONS_BLOCK_AFTER_TIME), -1 * $exam_range_to_consider['days_before_exam_start']) && time() < \Ventus\Utilities\Functions::findNextBusinessDay(strtotime(date('Y-m-d ', strtotime($cr['exam_date'])) . FACULTY_EXAM_MODIFICATIONS_BLOCK_AFTER_TIME), -1 * $exam_range_to_consider['days_before_exam_end'])) {
//If it is, check if that request already has an exam file uploaded
if (!$noes->checkIfFileExistsForNOE($cr['exam_request_id']) && !$noes->checkIfDocumentReceived($cr['exam_request_id']) && $model->fetchCountStudentsConfirmedAtAS($cr['exam_request_id']) > 0 && (int) $num_students > 0) {
$quick_stat_1_changed = true;
$count_exams_due_48_hours++;
}
}
//Quick stat 3: For each request that is in the future, check if a file exists but a control sheet doesnt
if (time() < strtotime($cr['exam_date']) && $noes->checkIfFileExistsForNOE($cr['exam_request_id']) && !$noes->checkIfNoeHasControlSheet($cr['exam_request_id'])) {
$quick_stat_3_changed = true;
$count_files_no_control_sheet++;
}
}
}
}
//Processing for quick stat 2: Get all courses that have students in them but are missing exam requests
$quick_stat_2_changed = false;
if ($count_professor_requests <= 0 && $num_students > 0) {