$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');