echo "</TR><TR>";
}
}
echo "</TR></TABLE>";
echo "</TD></TR></TABLE>";
echo "</CENTER>";
// +++++++++++++++++++++++++++++++++++++++++++++++++++++++
break;
}
$date1 = $_REQUEST['year__date'] . "-" . $_REQUEST['month__date'] . "-" . $_REQUEST['day__date'];
$mp_id = $_REQUEST['marking_period_id'];
if ($_REQUEST['modfunc'] == 'detail') {
$date = $_REQUEST['date'];
$mp_id = $_REQUEST['marking_period_id'];
$full_day = date('l', strtotime($date));
$day = get_db_day($full_day);
$fy_id = DBGet(DBQuery('SELECT MARKING_PERIOD_ID FROM school_years WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
$fy_id = $fy_id[1]['MARKING_PERIOD_ID'];
$sql = 'SELECT
s.COURSE_ID,s.COURSE_PERIOD_ID,
s.MARKING_PERIOD_ID,s.START_DATE,s.END_DATE,
UNIX_TIMESTAMP(s.START_DATE) AS START_EPOCH,UNIX_TIMESTAMP(s.END_DATE) AS END_EPOCH,sp.PERIOD_ID,CONCAT(sp.START_TIME,\'' . ' - ' . '\',sp.END_TIME) AS TIME_PERIOD,
cpv.PERIOD_ID,cp.MARKING_PERIOD_ID as COURSE_MARKING_PERIOD_ID,cp.MP,sp.SORT_ORDER,
c.TITLE ,cp.COURSE_PERIOD_ID AS PERIOD_PULLDOWN,
s.STUDENT_ID,r.TITLE AS ROOM,cpv.DAYS,SCHEDULER_LOCK
FROM schedule s,courses c,course_periods cp,school_periods sp,course_period_var cpv,rooms r
WHERE
s.COURSE_ID = c.COURSE_ID AND s.COURSE_ID = cp.COURSE_ID
AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID
AND s.COURSE_PERIOD_ID = cp.COURSE_PERIOD_ID
AND r.ROOM_ID=cpv.ROOM_ID
$new_date = $_REQUEST['date1'];
} else {
$new_date = DBDate();
}
$columns = array('PERIOD_TITLE' => 'Period - Teacher', 'MARKING_PERIOD_ID' => 'Term', 'DAYS' => 'Days', 'DURATION' => 'Time', 'ROOM' => 'Room', 'COURSE_TITLE' => 'Course');
$extra['SELECT'] .= ',p_cp.COURSE_PERIOD_ID,p_cp.SCHEDULE_TYPE,c.TITLE AS COURSE_TITLE,p_cp.TITLE AS PERIOD_TITLE,sr.MARKING_PERIOD_ID,\'\' AS DAYS, \'\' AS DURATION,\'\' AS ROOM';
$extra['FROM'] .= ' LEFT OUTER JOIN schedule sr ON (sr.STUDENT_ID=ssm.STUDENT_ID),courses c,course_periods p_cp,course_period_var cpv ';
if ($_REQUEST['include_inactive'] != 'Y') {
if (isset($_REQUEST['date1']) && $_REQUEST['date1'] != '') {
$extra['WHERE'] .= ' AND (p_cp.MARKING_PERIOD_ID IN (' . GetAllMP_mod(GetMPTable(GetMP($_REQUEST['mp_id'], 'TABLE')), $_REQUEST['mp_id']) . ') OR (p_cp.MARKING_PERIOD_ID IS NULL AND p_cp.BEGIN_DATE<=\'' . date('Y-m-d', strtotime($_REQUEST['date1'])) . '\' AND p_cp.END_DATE>=\'' . date('Y-m-d', strtotime($_REQUEST['date1'])) . '\')) ';
} else {
$extra['WHERE'] .= ' AND (p_cp.MARKING_PERIOD_ID IN (' . GetAllMP_mod(GetMPTable(GetMP($_REQUEST['mp_id'], 'TABLE')), $_REQUEST['mp_id']) . ') OR (p_cp.MARKING_PERIOD_ID IS NULL AND p_cp.BEGIN_DATE<=\'' . date('Y-m-d', strtotime($date)) . '\' AND p_cp.END_DATE>=\'' . date('Y-m-d', strtotime($date)) . '\')) ';
}
}
if (isset($_REQUEST['date1']) && $_REQUEST['date1'] != '') {
$extra['WHERE'] .= ' AND POSITION(\'' . get_db_day(date('l', strtotime($_REQUEST['date1']))) . '\' IN cpv.days)>0 AND (cpv.COURSE_PERIOD_DATE=\'' . date('Y-m-d', strtotime($_REQUEST['date1'])) . '\' OR cpv.COURSE_PERIOD_DATE IS NULL)';
}
$extra['WHERE'] .= ' AND ssm.SYEAR=sr.SYEAR AND sr.COURSE_ID=c.COURSE_ID AND sr.COURSE_PERIOD_ID=p_cp.COURSE_PERIOD_ID AND cpv.COURSE_PERIOD_ID=p_cp.COURSE_PERIOD_ID ';
if ($_REQUEST['include_inactive'] != 'Y') {
if (isset($_REQUEST['date1']) && $_REQUEST['date1'] != '') {
$extra['WHERE'] .= ' AND (\'' . date('Y-m-d', strtotime($_REQUEST['date1'])) . '\' BETWEEN sr.START_DATE AND sr.END_DATE OR (sr.END_DATE IS NULL AND sr.START_DATE<=\'' . date('Y-m-d', strtotime($_REQUEST['date1'])) . '\')) ';
} else {
$extra['WHERE'] .= ' AND (\'' . date('Y-m-d', strtotime($date)) . '\' BETWEEN sr.START_DATE AND sr.END_DATE OR (sr.END_DATE IS NULL AND sr.START_DATE<=\'' . date('Y-m-d', strtotime($date)) . '\')) ';
}
}
if ($_REQUEST['mp_id'] && (User('PROFILE_ID') != 0 && User('PROFILE_ID') != 3 && User('PROFILE_ID') != 4)) {
$extra['WHERE'] .= ' AND sr.MARKING_PERIOD_ID=' . $_REQUEST['mp_id'] . '';
} else {
$extra['WHERE'] .= ' AND (sr.MARKING_PERIOD_ID IN (' . GetAllMP_mod(GetMPTable(GetMP($_REQUEST['mp_id'], 'TABLE')), $_REQUEST['mp_id']) . ') or sr.MARKING_PERIOD_ID is NULL)';
}
$extra['functions'] = array('MARKING_PERIOD_ID' => 'GetMP', 'DAYS' => '_makeDays');
