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');