echo '<BR /><BR /><BR /><TABLE class="width-100p"><TR><TD style="width:50px;"> </TD><TD>' . $address[1]['MAILING_LABEL'] . '</TD></TR></TABLE><BR />';
$schedule_table = _schedule_table_RET($schedule_table);
ListOutput($schedule_table, $columns_table, 'Period', 'Periods', false, array());
}
} else {
//modif Francois: add Horizontal format option
if (isset($_REQUEST['horizontalFormat'])) {
//echo '<!-- MEDIA SIZE 8.5x11in -->';
$_SESSION['orientation'] = 'landscape';
}
unset($_ROSARIO['DrawHeader']);
DrawHeader(_('Student Schedule'));
DrawHeader(GetSchool(UserSchool()), ProperDate($date));
DrawHeader($RET[$student_id][1]['FULL_NAME'], $RET[$student_id][1]['STUDENT_ID']);
DrawHeader($RET[$student_id][1]['GRADE_ID'], $_REQUEST['mp_id'] ? GetMP($_REQUEST['mp_id']) : '');
$schedule_table = _schedule_table_RET($schedule_table);
ListOutput($schedule_table, $columns_table, 'Period', 'Periods', false, array());
}
echo '<div style="page-break-after: always;"></div>';
}
}
PDFStop($handle);
} else {
BackPrompt(_('No Students were found.'));
}
} else {
BackPrompt(_('You must choose at least one student.'));
}
}
if (empty($_REQUEST['modfunc'])) {
DrawHeader(ProgramTitle());
$schedule_table_days = array('U' => false, 'M' => false, 'T' => false, 'W' => false, 'H' => false, 'F' => false, 'S' => false);
//modif Francois: days display to locale
$days_convert = array('U' => _('Sunday'), 'M' => _('Monday'), 'T' => _('Tuesday'), 'W' => _('Wednesday'), 'H' => _('Thursday'), 'F' => _('Friday'), 'S' => _('Saturday'));
//modif Francois: days numbered
if (SchoolInfo('NUMBER_DAYS_ROTATION') !== null) {
$days_convert = array('U' => _('Day') . ' 7', 'M' => _('Day') . ' 1', 'T' => _('Day') . ' 2', 'W' => _('Day') . ' 3', 'H' => _('Day') . ' 4', 'F' => _('Day') . ' 5', 'S' => _('Day') . ' 6');
}
$schedule_table_RET = DBGet(DBQuery("SELECT cp.ROOM,cp.SHORT_NAME,c.TITLE,sp.TITLE AS SCHOOL_PERIOD,cpsp.DAYS FROM COURSE_PERIODS cp,COURSES c,SCHOOLS s,SCHOOL_PERIODS sp,COURSE_PERIOD_SCHOOL_PERIODS cpsp WHERE cp.COURSE_ID=c.COURSE_ID AND cp.TEACHER_ID='" . UserStaffID() . "' AND cp.SYEAR='" . UserSyear() . "' AND s.ID=cp.SCHOOL_ID AND s.ID='" . UserSchool() . "' AND s.SYEAR=cp.SYEAR AND sp.PERIOD_ID=cpsp.PERIOD_ID AND cpsp.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND cp.MARKING_PERIOD_ID IN ((SELECT MARKING_PERIOD_ID FROM SCHOOL_MARKING_PERIODS WHERE MP='FY' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'), '" . UserMP() . "') AND sp.LENGTH < " . Config('ATTENDANCE_FULL_DAY_MINUTES') / 2 . " ORDER BY sp.SORT_ORDER"), array('TITLE' => 'CourseTitle', 'DAYS' => '_GetDays'), array('SCHOOL_PERIOD'));
//modif Francois: note the "sp.LENGTH < (Config('ATTENDANCE_FULL_DAY_MINUTES') / 2)" condition to remove Full Day and Half Day school periods from the schedule table!
$columns = array('SCHOOL_PERIOD' => _('Periods'));
foreach ($schedule_table_days as $day => $true) {
if ($true) {
$columns[$day] = $days_convert[$day];
}
}
$schedule_table_RET = _schedule_table_RET($schedule_table_RET);
ListOutput($schedule_table_RET, $columns, 'Period', 'Periods', false, array(), array('save' => false));
if ($_REQUEST['_ROSARIO_PDF']) {
$separator = '<div style="page-break-after: always;"></div>';
//modif Francois: vertical format
$separator .= '<!-- MEDIA LANDSCAPE NO -->';
} else {
$separator = '<HR>';
}
}
$_REQUEST['category_id'] = '2';
include 'modules/Users/includes/Other_Info.inc.php';
//modif Francois: add schedule table
function _GetDays($value, $column)
{
global $schedule_table_days;
