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;