$calendars_RET = DBGet(DBQuery('SELECT CALENDAR_ID,TITLE FROM school_calendars WHERE SYEAR=\'' . UserSyear() . '\' ' . ($_REQUEST['_search_all_schools'] != 'Y' ? ' AND SCHOOL_ID=\'' . UserSchool() . '\'' : '')), array(), array('CALENDAR_ID'));
$extra['WHERE'] .= ' GROUP BY ssm.GRADE_ID,ssm.CALENDAR_ID';
$days_arr = array();
$date_arr = array();
$days_possible = array();
$days_possible_day = array();
$starting_date = strtotime($start_date_mod);
$ending_date = strtotime($end_date_mod);
for ($i = $starting_date; $i <= $ending_date; $i = $i + 86400) {
foreach ($calendars_RET as $ci => $cd) {
$check_day = DBGet(DBQuery('SELECT COUNT(1) as EX FROM attendance_calendar WHERE ' . ($_REQUEST['_search_all_schools'] != 'Y' ? 'SCHOOL_ID=\'' . UserSchool() . '\' AND ' : '') . ' SYEAR=' . UserSyear() . ' AND SCHOOL_DATE=\'' . date('Y-m-d', $i) . '\' '));
if ($check_day[1]['EX'] > 0) {
$days_arr[$cd[1]['CALENDAR_ID']][] = DaySname(date('l', $i));
$date_arr[$cd[1]['CALENDAR_ID']][] = date('Y-m-d', $i);
$days_possible[date('Y-m-d', $i)] = date('Y-m-d', $i);
$days_possible_day[date('Y-m-d', $i)] = DaySname(date('l', $i));
}
}
}
$present_ids = DBGet(DBQuery('SELECT GROUP_CONCAT(ID) AS PRESENT FROM attendance_codes WHERE ' . ($_REQUEST['_search_all_schools'] != 'Y' ? 'SCHOOL_ID=\'' . UserSchool() . '\' AND ' : '') . ' SYEAR=' . UserSyear() . ' AND STATE_CODE=\'P\' '));
$present_ids = $present_ids[1]['PRESENT'];
$absent_ids = DBGet(DBQuery('SELECT GROUP_CONCAT(ID) AS ABSENT FROM attendance_codes WHERE ' . ($_REQUEST['_search_all_schools'] != 'Y' ? 'SCHOOL_ID=\'' . UserSchool() . '\' AND ' : '') . ' SYEAR=' . UserSyear() . ' AND STATE_CODE=\'A\' '));
$absent_ids = $absent_ids[1]['ABSENT'];
$others_ids = DBGet(DBQuery('SELECT GROUP_CONCAT(ID) AS ABSENT FROM attendance_codes WHERE ' . ($_REQUEST['_search_all_schools'] != 'Y' ? 'SCHOOL_ID=\'' . UserSchool() . '\' AND ' : '') . ' SYEAR=' . UserSyear() . ' AND STATE_CODE=\'H\' '));
$others_ids = $others_ids[1]['ABSENT'];
$last_sum = array();
$search_stu = '';
if ($_REQUEST['last'] != '' || $_REQUEST['first'] != '' || $_REQUEST['stuid'] != '' || $_REQUEST['altid'] != '') {
$stu_q = 'SELECT GROUP_CONCAT(STUDENT_ID) as STUDENT_ID FROM students WHERE ';
$stu_q .= $_REQUEST['last'] != '' ? ' LAST_NAME=\'' . $_REQUEST['last'] . '\' OR ' : '';
$stu_q .= $_REQUEST['first'] != '' ? ' FIRST_NAME=\'' . $_REQUEST['first'] . '\' OR ' : '';
$schedule_RET[$rdi]['DURATION'] = $get_det[1]['DURATION'];
$schedule_RET[$rdi]['ROOM'] = $get_det[1]['ROOM'];
$schedule_RET[$rdi]['PERIOD'] = $get_det[1]['PERIOD'];
if ($schedule_RET[$rdi]['MARKING_PERIOD_ID'] == 'Custom') {
$schedule_RET[$rdi]['MARKING_PERIOD_ID'] = date('M/d/Y', strtotime($cp_info[1]['BEGIN_DATE'])) . ' to ' . date('M/d/Y', strtotime($cp_info[1]['END_DATE']));
}
} else {
$temp_days = array();
$temp_duration = array();
$temp_room = array();
$temp_period = array();
foreach ($get_det as $gi => $gd) {
if ($rdd['SCHEDULE_TYPE'] == 'VARIABLE') {
$temp_days[$gd['DAYS']] = $gd['DAYS'];
} elseif ($rdd['SCHEDULE_TYPE'] == 'BLOCKED') {
$temp_days[$gd['DAYS']] = DaySname(date('l', $gd['COURSE_PERIOD_DATE']));
}
$temp_period[$gd['PERIOD']] = $gd['PERIOD'];
$temp_duration[$gd['DURATION']] = $gd['DURATION'];
$temp_room[$gd['ROOM']] = $gd['ROOM'];
}
$schedule_RET[$rdi]['DAYS'] = _makeDays(implode('', $temp_days));
$schedule_RET[$rdi]['DURATION'] = implode(',', $temp_duration);
$schedule_RET[$rdi]['ROOM'] = implode(',', $temp_room);
$schedule_RET[$rdi]['PERIOD'] = implode(',', $temp_period);
if ($schedule_RET[$rdi]['MARKING_PERIOD_ID'] == 'Custom') {
$schedule_RET[$rdi]['MARKING_PERIOD_ID'] = date('M/d/Y', strtotime($cp_info[1]['BEGIN_DATE'])) . ' to ' . date('M/d/Y', strtotime($cp_info[1]['END_DATE']));
}
}
}
ListOutput($schedule_RET, array('COURSE' => 'Course', 'PERIOD' => 'Period', 'DAYS' => 'Days', 'DURATION' => 'Time', 'ROOM' => 'Room', 'MARKING_PERIOD_ID' => 'Marking Period'), 'Course', 'Courses');
