AND s.SYEAR=\'' . UserSyear() . '\' AND s.SCHOOL_ID = \'' . UserSchool() . '\' AND (cpv.COURSE_PERIOD_DATE=\'' . date('Y-m-d', strtotime($date)) . '\' OR cpv.COURSE_PERIOD_DATE IS NULL) AND (\'' . date('Y-m-d', strtotime($date)) . '\' BETWEEN s.START_DATE AND s.END_DATE OR (s.END_DATE IS NULL AND s.START_DATE<=\'' . date('Y-m-d', strtotime($date)) . '\')) AND s.MARKING_PERIOD_ID IN (' . GetAllMP(GetMPTable(GetMP($mp_id, 'TABLE')), $mp_id) . ') ORDER BY sp.SORT_ORDER,s.MARKING_PERIOD_ID'; $QI = DBQuery($sql); $schedule_RET = DBGet($QI, array('TIME_PERIOD' => '_makeTimePeriod', 'TITLE' => '_makeTitle', 'PERIOD_PULLDOWN' => '_makePeriodSelect', 'COURSE_MARKING_PERIOD_ID' => '_makeMPSelect')); $columns = array('TIME_PERIOD' => 'Period', 'TITLE' => 'Course', 'PERIOD_PULLDOWN' => 'Period - Teacher', 'ROOM' => 'Room', 'DAYS' => 'Days of Week', 'COURSE_MARKING_PERIOD_ID' => 'Term'); } if ($_REQUEST['view_mode'] != 'month_view') { ListOutput($schedule_RET, $columns, 'Course', 'Courses', $link); if ($_REQUEST['modfunc'] == 'detail') { echo '<br /><div align="center"><input type="button" class=btn_medium value="Close" onclick="window.close();"></div>'; } } if ($schedule_RET && $_REQUEST['view_mode'] == 'day_view') { DrawHeader("<table><tr><td> </td><td>" . ProgramLinkforExport('scheduling/PrintSchedules.php', '<img src=assets/print.png>', '&modfunc=save&st_arr[]=' . UserStudentID() . '&mp_id=' . $mp_id . '&date1=' . $date1 . '&include_inactive=' . $_REQUEST['include_inactive'] . '&_openSIS_PDF=true target=_blank') . "</td><td>" . ProgramLinkforExport('scheduling/PrintSchedules.php', 'Print Schedule', '&modfunc=save&st_arr[]=' . UserStudentID() . '&mp_id=' . $mp_id . '&include_inactive=' . $_REQUEST['include_inactive'] . '&date1=' . $date1 . '&_openSIS_PDF=true target=_blank') . "</td></tr></table>"); } echo '</FORM>'; unset($_REQUEST['view_mode']); } //==============================================Function start============================================ function _makeTitle($value, $column = '') { global $_openSIS, $THIS_RET; return $value; } function _makeLock($value, $column) { global $THIS_RET; if ($value == 'Y') { $img = 'locked';
$columns = array('TITLE' => 'Course', 'PERIOD_PULLDOWN' => 'Period - Teacher', 'ROOM' => 'Room', 'DAYS' => 'Days of Week', 'COURSE_MARKING_PERIOD_ID' => 'Term', 'SCHEDULER_LOCK' => '<IMG SRC=assets/locked.gif border=0>', 'START_DATE' => 'Enrolled', 'END_DATE' => 'Dropped'); $days_RET = DBGet(DBQuery("SELECT DISTINCT DAYS FROM COURSE_PERIODS")); if (count($days_RET) == 1) { unset($columns['DAYS']); } if ($_REQUEST['_CENTRE_PDF']) { unset($columns['SCHEDULER_LOCK']); } VerifySchedule($schedule_RET); ListOutput($schedule_RET, $columns, 'Course', 'Courses', $link); if (!$schedule_RET) { echo ''; } else { #DrawHeader(ProgramLink('Scheduling/PrintSchedules.php','Print Schedule','&modfunc=save&st_arr[]='.UserStudentID().'&_CENTRE_PDF=true')); if (User('PROFILE') != 'student') { DrawHeader("<table><tr><td> </td><td>" . ProgramLinkforExport('Scheduling/PrintSchedules.php', '<img src=assets/print.png>', '&modfunc=save&st_arr[]=' . UserStudentID() . '&_CENTRE_PDF=true target=_blank') . "</td><td>" . ProgramLinkforExport('Scheduling/PrintSchedules.php', 'Print Schedule', '&modfunc=save&st_arr[]=' . UserStudentID() . '&_CENTRE_PDF=true target=_blank') . "</td></tr></table>"); } echo '<BR><CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick=\'formload_ajax("modify");\'') . '</CENTER>'; } echo '</FORM>'; echo "<div class=break></div>"; if (AllowEdit()) { unset($_REQUEST); $_REQUEST['modname'] = 'Scheduling/Schedule.php'; $_REQUEST['stuid'] = UserStudentID(); $_REQUEST['search_modfunc'] = 'list'; //$extra['link']['FULL_NAME']['link'] = "Modules.php?modname=$_REQUEST[modname]&modfunc=choose_course"; //$extra['link']['FULL_NAME']['link'] = "#"." onclick='check_content(\"ajax.php?modname=$_REQUEST[modname]&modfunc=$_REQUEST[modfunc]\");'"; $extra['link']['FULL_NAME']['link'] = 'Modules.php?modname=Scheduling/Requests.php'; $extra['link']['FULL_NAME']['variables'] = array('subject_id' => 'SUBJECT_ID', 'course_id' => 'COURSE_ID'); //$extra['link']['FULL_NAME']['js'] = true;