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;
