PrepareSchool(SessionSchool(), '', SessionCurSchool()); Warehouse('searchgrade'); Warehouse('searchyear'); if (defined('PRINT_LETTER')) { echo '<TR><TD>Letter Text</TD><TD>'; echo '<TEXTAREA name=letter rows=10 cols=50> Dear __PARENTS__, Your child, __STUDENT__ (__STUDENT_ID__) now has a balance of __BALANCE__. It should be refilled as soon as possible to avoid running out. --Administration </TEXTAREA>'; echo '</TD></TR>'; } echo '<TR><TD colspan=2 align=center>'; Buttons('Find', 'Reset'); echo '</TD></TR>'; echo '</TABLE>'; echo '</FORM>'; PopTable('footer'); } if ($_REQUEST['modfunc'] == 'list') { $_REQUEST['balance_low'] = ereg_replace('[^0-9]', '', $_REQUEST['balance_low']); $_REQUEST['balance_high'] = ereg_replace('[^0-9]', '', $_REQUEST['balance_high']); if ($_REQUEST['balance_low'] > $_REQUEST['balance_high']) { $tmp = $_REQUEST['balance_high']; $_REQUEST['balance_high'] = $_REQUEST['balance_low']; $_REQUEST['balance_low'] = $tmp; } } if ($_REQUEST[modfunc] == 'list' && ($_REQUEST[editor] == 'stubilling' || $_REQUEST[editor] == 'lunch')) {
PopTable('header', 'Advanced'); echo "<FORM name=percentform action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&list_by_day=" . strip_tags(trim($_REQUEST[list_by_day])) . "&day_start=" . strip_tags(trim($_REQUEST[day_start])) . "&day_end=" . strip_tags(trim($_REQUEST[day_end])) . "&month_start=" . strip_tags(trim($_REQUEST[month_start])) . "&month_end=" . strip_tags(trim($_REQUEST[month_end])) . "&year_start=" . strip_tags(trim($_REQUEST[year_start])) . "&year_end=" . strip_tags(trim($_REQUEST[year_end])) . " method=POST>"; echo '<TABLE>'; Search('general_info', $extra['grades']); if (!isset($extra)) { $extra = array(); } Widgets('user', $extra); if ($extra['search']) { echo $extra['search']; } Search('student_fields', is_array($extra['student_fields']) ? $extra['student_fields'] : array()); if (User('PROFILE') == 'admin') { echo '<CENTER><INPUT type=checkbox name=_search_all_schools value=Y' . (Preferences('DEFAULT_ALL_SCHOOLS') == 'Y' ? ' CHECKED' : '') . '><font color=black>Search All Schools</font></CENTER><BR>'; } echo '<CENTER>' . Buttons('Submit') . '</CENTER>'; echo '</FORM>'; PopTable('footer'); } if (!$_REQUEST['modfunc']) { if (!isset($extra)) { $extra = array(); } Widgets('user'); if ($_REQUEST['advanced'] == 'Y') { Widgets('all'); } $extra['WHERE'] .= appendSQL(''); $extra['WHERE'] .= CustomFields('where'); echo "<FORM name=ada_from id=ada_from onSubmit='return formcheck_ada_dates();' action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&list_by_day=" . strip_tags(trim($_REQUEST[list_by_day])) . " method=POST>"; $advanced_link = " <A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=search&list_by_day={$_REQUEST['list_by_day']}&day_start={$_REQUEST['day_start']}&day_end={$_REQUEST['day_end']}&month_start={$_REQUEST['month_start']}&month_end={$_REQUEST['month_end']}&year_start={$_REQUEST['year_start']}&year_end={$_REQUEST['year_end']}>Advanced</A>";
case 'parent': case 'student': echo '<BR>'; PopTable('header', 'Search'); if ($extra['pdf'] != true) { echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&search_modfunc=list&next_modname={$_REQUEST['next_modname']}" . $extra['action'] . " method=POST>"; } else { echo "<FORM action=for_export.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&search_modfunc=list&next_modname={$_REQUEST['next_modname']}" . $extra['action'] . " method=POST target=_blank>"; } echo '<TABLE border=0>'; if ($extra['search']) { echo $extra['search']; } echo '<TR><TD colspan=2 align=center>'; echo '<BR>'; echo Buttons('Submit', 'Reset'); echo '</TD></TR>'; echo '</TABLE>'; echo '</FORM>'; PopTable('footer'); break; } } else { if (!$_REQUEST['next_modname']) { $_REQUEST['next_modname'] = 'Students/Student.php'; } if ($_REQUEST['address_group']) { $extra['SELECT'] .= ',sam.ADDRESS_ID'; if (!($_REQUEST['expanded_view'] == 'true' || $_REQUEST['addr'] || $extra['addr'])) { $extra['FROM'] = " LEFT OUTER JOIN STUDENTS_JOIN_ADDRESS sam ON (sam.STUDENT_ID=ssm.STUDENT_ID AND sam.RESIDENCE='Y')" . $extra['FROM']; }
echo '</TD><TD>'; echo '<TABLE class="width-100p"><TR><TD class="center"><BR />'; if ($extra['search_second_col']) { echo $extra['search_second_col']; } if (User('PROFILE') == 'admin') { //modif Francois: add <label> on checkbox //modif Francois: if only one school, no Search All Schools option if (SchoolInfo('SCHOOLS_NB') > 1) { echo '<label><INPUT type="checkbox" name="_search_all_schools" value="Y"' . (Preferences('DEFAULT_ALL_SCHOOLS') == 'Y' ? ' checked' : '') . '> ' . _('Search All Schools') . '</label><BR />'; } } else { echo '<label><INPUT type="checkbox" name="include_inactive" value="Y"> ' . _('Include Parents of Inactive Students') . '</label><BR />'; } echo '<BR />'; echo Buttons(_('Submit'), _('Reset')); echo '</TD></TR>'; echo '</TABLE>'; if ($extra['second_col']) { echo '<BR /><TABLE>' . $extra['second_col'] . '</TABLE>'; } echo '</TD></TR>'; echo '<TR class="valign-top"><TD><TABLE class="width-100p cellspacing-0 cellpadding-0"><TR><TD>'; if ($_REQUEST['advanced'] == 'Y') { $extra['search'] = ''; StaffWidgets('all', $extra); if ($extra['search']) { echo '<TABLE class="postbox cellpadding-0 cellspacing-0"><TR><TH>'; echo '<H3>' . _('Widgets') . '</H3></TH></TR>'; echo $extra['search']; echo '</TABLE><br />';
function mySearch($type, $extra = '') { global $extra; if ($_REQUEST['search_modfunc'] == 'search_fnc' || !$_REQUEST['search_modfunc']) { echo '<BR>'; PopTable('header', 'Search'); echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&search_modfunc=list&next_modname={$_REQUEST['next_modname']} method=POST>"; echo '<TABLE border=0>'; $RET = DBGet(DBQuery("SELECT STAFF_ID,CONCAT(LAST_NAME,LAST_NAME,', ',FIRST_NAME) AS FULL_NAME FROM STAFF WHERE PROFILE='teacher' AND position('," . UserSchool() . ",' IN SCHOOLS)>0 AND SYEAR='" . UserSyear() . "' ORDER BY FULL_NAME")); echo '<TR><TD align=right width=120>Teacher</TD><TD>'; echo "<SELECT name=teacher_id style='max-width:250;'><OPTION value=''>N/A</OPTION>"; foreach ($RET as $teacher) { echo "<OPTION value={$teacher['STAFF_ID']}>{$teacher['FULL_NAME']}</OPTION>"; } echo '</SELECT>'; echo '</TD></TR>'; $RET = DBGet(DBQuery("SELECT SUBJECT_ID,TITLE FROM COURSE_SUBJECTS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY TITLE")); echo '<TR><TD align=right width=120>Subject</TD><TD>'; echo "<SELECT name=subject_id style='max-width:250;'><OPTION value=''>N/A</OPTION>"; foreach ($RET as $subject) { echo "<OPTION value={$subject['SUBJECT_ID']}>{$subject['TITLE']}</OPTION>"; } echo '</SELECT>'; $RET = DBGet(DBQuery("SELECT PERIOD_ID,TITLE FROM SCHOOL_PERIODS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER")); echo '<TR><TD align=right width=120>Period</TD><TD>'; echo "<SELECT name=period_id style='max-width:250;'><OPTION value=''>N/A</OPTION>"; foreach ($RET as $period) { echo "<OPTION value={$period['PERIOD_ID']}>{$period['TITLE']}</OPTION>"; } echo '</SELECT>'; echo '</TD></TR>'; Widgets('course'); echo $extra['search']; echo '<TR><TD colspan=2 align=center>'; echo '<BR>'; echo Buttons('Submit', 'Reset'); echo '</TD></TR>'; echo '</TABLE>'; echo '</FORM>'; PopTable('footer'); } else { DrawHeader('', $extra['header_right']); DrawHeader($extra['extra_header_left'], $extra['extra_header_right']); if (User('PROFILE') == 'admin') { if ($_REQUEST['teacher_id']) { $where .= " AND cp.TEACHER_ID='{$_REQUEST['teacher_id']}'"; } if ($_REQUEST['first']) { $where .= " AND UPPER(s.FIRST_NAME) LIKE '" . strtoupper($_REQUEST['first']) . "%'"; } if ($_REQUEST['w_course_period_id']) { if ($_REQUEST['w_course_period_id_which'] == 'course') { $where .= " AND cp.COURSE_ID=(SELECT COURSE_ID FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "')"; } else { $where .= " AND cp.COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "'"; } } if ($_REQUEST['subject_id']) { $from .= ",COURSES c"; $where .= " AND c.COURSE_ID=cp.COURSE_ID AND c.SUBJECT_ID='" . $_REQUEST['subject_id'] . "'"; } if ($_REQUEST['period_id']) { $where .= " AND cp.PERIOD_ID='" . $_REQUEST['period_id'] . "'"; } $sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM COURSE_PERIODS cp,SCHOOL_PERIODS sp{$from} WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.SYEAR='" . UserSyear() . "' AND sp.PERIOD_ID=cp.PERIOD_ID{$where}"; } elseif (User('PROFILE') == 'teacher') { $sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM COURSE_PERIODS cp,SCHOOL_PERIODS sp WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.SYEAR='" . UserSyear() . "' AND cp.TEACHER_ID='" . User('STAFF_ID') . "' AND sp.PERIOD_ID=cp.PERIOD_ID"; } else { $sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM COURSE_PERIODS cp,SCHOOL_PERIODS sp,SCHEDULE ss WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND ss.SYEAR='" . UserSyear() . "' AND ss.STUDENT_ID='" . UserStudentID() . "' AND (CURRENT_DATE>=ss.START_DATE AND (ss.END_DATE IS NULL OR CURRENT_DATE<=ss.END_DATE)) AND sp.PERIOD_ID=cp.PERIOD_ID"; } $sql .= ' ORDER BY sp.PERIOD_ID'; $course_periods_RET = DBGet(DBQuery($sql), array('COURSE_PERIOD_ID' => '_makeChooseCheckbox')); $LO_columns = array('COURSE_PERIOD_ID' => '</A><INPUT type=checkbox value=Y name=controller onclick="checkAll(this.form,this.form.controller.checked,\'cp_arr\');"><A>', 'TITLE' => 'Course Period'); ListOutput($course_periods_RET, $LO_columns, 'Course Period', 'Course Periods'); } }
function mySearch($type, $extra = '') { global $extra; if ($_REQUEST['search_modfunc'] == 'search_fnc' || !$_REQUEST['search_modfunc']) { echo '<BR>'; PopTable('header', 'Search'); echo "<FORM action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=" . strip_tags(trim($_REQUEST[modfunc])) . "&search_modfunc=list&next_modname=" . strip_tags(trim($_REQUEST[next_modname])) . " method=POST>"; echo '<TABLE border=0>'; $RET = DBGet(DBQuery('SELECT s.STAFF_ID,CONCAT(s.LAST_NAME,\'' . ',' . '\',s.FIRST_NAME) AS FULL_NAME FROM staff s,staff_school_relationship ssr WHERE s.STAFF_ID=ssr.STAFF_ID AND s.PROFILE=\'' . 'teacher' . '\' AND position(\'' . UserSchool() . '\' IN ssr.SCHOOL_ID)>0 AND ssr.SYEAR=\'' . UserSyear() . '\' ORDER BY FULL_NAME')); echo '<TR><TD align=right width=120>Teacher</TD><TD>'; echo "<SELECT name=teacher_id style='max-width:250;'><OPTION value=''>N/A</OPTION>"; foreach ($RET as $teacher) { echo "<OPTION value={$teacher['STAFF_ID']}>{$teacher['FULL_NAME']}</OPTION>"; } echo '</SELECT>'; echo '</TD></TR>'; $RET = DBGet(DBQuery('SELECT SUBJECT_ID,TITLE FROM course_subjects WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY TITLE')); echo '<TR><TD align=right width=120>Subject</TD><TD>'; echo "<SELECT name=subject_id style='max-width:250;'><OPTION value=''>N/A</OPTION>"; foreach ($RET as $subject) { echo "<OPTION value={$subject['SUBJECT_ID']}>{$subject['TITLE']}</OPTION>"; } echo '</SELECT>'; $RET = DBGet(DBQuery('SELECT PERIOD_ID,TITLE FROM school_periods WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER')); echo '<TR><TD align=right width=120>Period</TD><TD>'; echo "<SELECT name=period_id style='max-width:250;'><OPTION value=''>N/A</OPTION>"; foreach ($RET as $period) { echo "<OPTION value={$period['PERIOD_ID']}>{$period['TITLE']}</OPTION>"; } echo '</SELECT>'; echo '</TD></TR>'; Widgets('course'); echo $extra['search']; echo '<TR><TD colspan=2 align=center>'; echo '<BR>'; echo Buttons('Submit', 'Reset'); echo '</TD></TR>'; echo '</TABLE>'; echo '</FORM>'; PopTable('footer'); } else { DrawHeader('', $extra['header_right']); DrawHeader($extra['extra_header_left'], $extra['extra_header_right']); if (User('PROFILE') == 'admin') { if ($_REQUEST['teacher_id']) { $where .= ' AND cp.TEACHER_ID=\'' . $_REQUEST[teacher_id] . '\''; } if ($_REQUEST['first']) { $where .= ' AND UPPER(s.FIRST_NAME) LIKE \'' . strtoupper($_REQUEST['first']) . '%' . '\''; } if ($_REQUEST['w_course_period_id']) { if ($_REQUEST['w_course_period_id_which'] == 'course') { $where .= ' AND cp.COURSE_ID=(SELECT COURSE_ID FROM course_periods WHERE COURSE_PERIOD_ID=\'' . $_REQUEST['w_course_period_id'] . '\')'; } else { $where .= ' AND cp.COURSE_PERIOD_ID=\'' . $_REQUEST['w_course_period_id'] . '\''; } } if ($_REQUEST['subject_id']) { $from .= ',courses c'; $where .= ' AND c.COURSE_ID=cp.COURSE_ID AND c.SUBJECT_ID=\'' . $_REQUEST['subject_id'] . '\''; } if ($_REQUEST['period_id']) { $where .= " AND cpv.PERIOD_ID='" . $_REQUEST['period_id'] . "'"; } $sql = 'SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM course_periods cp,course_period_var cpv,school_periods sp' . $from . ' WHERE cp.SCHOOL_ID=\'' . UserSchool() . '\' AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND cp.SYEAR=\'' . UserSyear() . '\' AND sp.PERIOD_ID=cpv.PERIOD_ID' . $where . ''; } elseif (User('PROFILE') == 'teacher') { $sql = 'SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM course_periods cp,course_period_var cpv,school_periods sp WHERE cp.SCHOOL_ID=\'' . UserSchool() . '\' AND cp.SYEAR=\'' . UserSyear() . '\' AND cp.TEACHER_ID=\'' . User('STAFF_ID') . '\' AND sp.PERIOD_ID=cpv.PERIOD_ID AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID'; } else { $sql = 'SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM course_periods cp,course_period_var cpv,school_periods sp,schedule ss WHERE cp.SCHOOL_ID=\'' . UserSchool() . '\' AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND ss.SYEAR=\'' . UserSyear() . '\' AND ss.STUDENT_ID=\'' . UserStudentID() . '\' AND (CURRENT_DATE>=ss.START_DATE AND (ss.END_DATE IS NULL OR CURRENT_DATE<=ss.END_DATE)) AND sp.PERIOD_ID=cpv.PERIOD_ID AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID'; } $sql .= ' GROUP BY cp.COURSE_PERIOD_ID ORDER BY sp.PERIOD_ID'; $course_periods_RET = DBGet(DBQuery($sql), array('COURSE_PERIOD_ID' => '_makeChooseCheckbox')); $_SESSION['count_course_periods'] = count($course_periods_RET); $LO_columns = array('COURSE_PERIOD_ID' => '</A><INPUT type=checkbox value=Y name=controller onclick="checkAll(this.form,this.form.controller.checked,\'cp_arr\');"><A>', 'TITLE' => 'Course Period'); ListOutput($course_periods_RET, $LO_columns, 'Course Period', 'Course Periods'); } }
foreach ($RET as $subject) { echo "<OPTION value={$subject['SUBJECT_ID']}>{$subject['TITLE']}</OPTION>"; } echo '</SELECT>'; $RET = DBGet(DBQuery("SELECT PERIOD_ID,TITLE FROM school_periods WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER")); echo '<TR><TD align=right>' . _('Period') . '</TD><TD>'; echo "<SELECT name=period_id style='max-width:250;'><OPTION value=''>N/A</OPTION>"; foreach ($RET as $period) { echo "<meta charset='UTF-8'><OPTION value={$period['PERIOD_ID']}>{$period['TITLE']}</OPTION>"; } echo '</SELECT>'; echo '</TD></TR>'; Widgets('course'); echo '<TR><TD colspan=2 align=center>'; echo '<BR>'; echo Buttons('' . _('Submit') . '', '' . _('Reset') . ''); echo '</TD></TR>'; echo '</TABLE>'; echo '</FORM>'; PopTable('footer'); } } function mySearch($extra) { // echo "<FORM action=Modules.php?modname=$_REQUEST[modname]&modfunc=save&search_modfunc=list&_openSIS_PDF=true onsubmit=document.forms[0].relation.value=document.getElementById(\"relation\").value; method=POST>"; // echo "<FORM name=exp id=exp action=for_export.php?modname=$_REQUEST[modname]&modfunc=save&search_modfunc=list&_openSIS_PDF=true onsubmit=document.forms[0].relation.value=document.getElementById(\"relation\").value; method=POST target=_blank>"; echo "<FORM name=exp id=exp action=for_export.php?modname={$_REQUEST['modname']}&head_html=Teacher+Class+List&modfunc=save&search_modfunc=list&_openSIS_PDF=true onsubmit=document.forms[0].relation.value=document.getElementById(\"relation\").value; method=POST target=_blank>"; echo '<DIV id=fields_div></DIV>'; DrawHeader('', $extra['header_right']); DrawHeader($extra['extra_header_left'], $extra['extra_header_right']); if (User('PROFILE') == 'admin') {
function mySearch($type, $extra = '') { global $extra; if ($_REQUEST['search_modfunc'] == 'search_fnc' || !$_REQUEST['search_modfunc']) { $_SESSION['Search_PHP_SELF'] = PreparePHP_SELF($_SESSION['_REQUEST_vars'], array('bottom_back')); if ($_SESSION['Back_PHP_SELF'] != 'course') { $_SESSION['Back_PHP_SELF'] = 'course'; unset($_SESSION['List_PHP_SELF']); } echo '<script type="text/javascript">parent.help.location.reload();</script>'; echo '<BR />'; PopTable('header', _('Find a Course')); echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=' . $_REQUEST['modfunc'] . '&search_modfunc=list&next_modname=' . $_REQUEST['next_modname'] . '" method="POST">'; echo '<TABLE>'; $RET = DBGet(DBQuery("SELECT STAFF_ID,LAST_NAME||', '||FIRST_NAME AS FULL_NAME FROM STAFF WHERE PROFILE='teacher' AND (SCHOOLS IS NULL OR position('," . UserSchool() . ",' IN SCHOOLS)>0) AND SYEAR='" . UserSyear() . "' ORDER BY FULL_NAME")); echo '<TR><TD style="text-align:right; width:120px:">' . _('Teacher') . '</TD><TD>'; echo '<SELECT name="teacher_id" style="max-width:250;"><OPTION value="">' . _('N/A') . '</OPTION>'; foreach ($RET as $teacher) { echo '<OPTION value="' . $teacher['STAFF_ID'] . '">' . $teacher['FULL_NAME'] . '</OPTION>'; } echo '</SELECT>'; echo '</TD></TR>'; $RET = DBGet(DBQuery("SELECT SUBJECT_ID,TITLE FROM COURSE_SUBJECTS WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY TITLE")); echo '<TR><TD style="text-align:right; width:120px:">' . _('Subject') . '</TD><TD>'; echo '<SELECT name="subject_id" style="max-width:250;"><OPTION value="">' . _('N/A') . '</OPTION>'; foreach ($RET as $subject) { echo '<OPTION value="' . $subject['SUBJECT_ID'] . '">' . $subject['TITLE'] . '</OPTION>'; } echo '</SELECT>'; $RET = DBGet(DBQuery("SELECT PERIOD_ID,TITLE FROM SCHOOL_PERIODS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER")); echo '<TR><TD style="text-align:right; width:120px:">' . _('Period') . '</TD><TD>'; echo "<SELECT name=period_id style='max-width:250;'><OPTION value=''>" . _('N/A') . "</OPTION>"; foreach ($RET as $period) { echo "<OPTION value={$period['PERIOD_ID']}>{$period['TITLE']}</OPTION>"; } echo '</SELECT>'; echo '</TD></TR>'; Widgets('course'); echo $extra['search']; echo '<TR><TD colspan="2" class="center">'; echo '<BR />'; echo Buttons(_('Submit'), _('Reset')); echo '</TD></TR>'; echo '</TABLE>'; echo '</FORM>'; PopTable('footer'); } else { DrawHeader('', $extra['header_right']); DrawHeader($extra['extra_header_left'], $extra['extra_header_right']); if (User('PROFILE') == 'admin') { if ($_REQUEST['teacher_id']) { $where .= " AND cp.TEACHER_ID='{$_REQUEST['teacher_id']}'"; } if ($_REQUEST['first']) { $where .= " AND UPPER(s.FIRST_NAME) LIKE '" . mb_strtoupper($_REQUEST['first']) . "%'"; } if ($_REQUEST['w_course_period_id']) { if ($_REQUEST['w_course_period_id_which'] == 'course') { $where .= " AND cp.COURSE_ID=(SELECT COURSE_ID FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "')"; } else { $where .= " AND cp.COURSE_PERIOD_ID='" . $_REQUEST['w_course_period_id'] . "'"; } } if ($_REQUEST['subject_id']) { $from .= ",COURSES c"; $where .= " AND c.COURSE_ID=cp.COURSE_ID AND c.SUBJECT_ID='" . $_REQUEST['subject_id'] . "'"; } //modif Francois: multiple school periods for a course period if ($_REQUEST['period_id']) { //$where .= " AND cp.PERIOD_ID='".$_REQUEST['period_id']."'"; $where .= " AND cpsp.PERIOD_ID='" . $_REQUEST['period_id'] . "' AND cp.COURSE_PERIOD_ID=cpsp.COURSE_PERIOD_ID"; $from .= ",COURSE_PERIOD_SCHOOL_PERIODS cpsp"; } //$sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM COURSE_PERIODS cp,SCHOOL_PERIODS sp$from WHERE cp.SCHOOL_ID='".UserSchool()."' AND cp.SYEAR='".UserSyear()."' AND sp.PERIOD_ID=cp.PERIOD_ID$where"; $sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE FROM COURSE_PERIODS cp{$from} WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.SYEAR='" . UserSyear() . "'{$where}"; } elseif (User('PROFILE') == 'teacher') { //modif Francois: multiple school periods for a course period //$sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM COURSE_PERIODS cp,SCHOOL_PERIODS sp WHERE cp.SCHOOL_ID='".UserSchool()."' AND cp.SYEAR='".UserSyear()."' AND cp.TEACHER_ID='".User('STAFF_ID')."' AND sp.PERIOD_ID=cp.PERIOD_ID"; $sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE FROM COURSE_PERIODS cp WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.SYEAR='" . UserSyear() . "' AND cp.TEACHER_ID='" . User('STAFF_ID') . "'"; } else { //modif Francois: multiple school periods for a course period //$sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE,sp.ATTENDANCE FROM COURSE_PERIODS cp,SCHOOL_PERIODS sp,SCHEDULE ss WHERE cp.SCHOOL_ID='".UserSchool()."' AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND ss.SYEAR='".UserSyear()."' AND ss.STUDENT_ID='".UserStudentID()."' AND (CURRENT_DATE>=ss.START_DATE AND (ss.END_DATE IS NULL OR CURRENT_DATE<=ss.END_DATE)) AND sp.PERIOD_ID=cp.PERIOD_ID"; $sql = "SELECT cp.COURSE_PERIOD_ID,cp.TITLE FROM COURSE_PERIODS cp,SCHEDULE ss WHERE cp.SCHOOL_ID='" . UserSchool() . "' AND cp.COURSE_PERIOD_ID=ss.COURSE_PERIOD_ID AND ss.SYEAR='" . UserSyear() . "' AND ss.STUDENT_ID='" . UserStudentID() . "' AND (CURRENT_DATE>=ss.START_DATE AND (ss.END_DATE IS NULL OR CURRENT_DATE<=ss.END_DATE))"; } //$sql .= ' ORDER BY sp.PERIOD_ID'; $course_periods_RET = DBGet(DBQuery($sql), array('COURSE_PERIOD_ID' => '_makeChooseCheckbox')); $LO_columns = array('COURSE_PERIOD_ID' => '</A><INPUT type="checkbox" value="Y" name="controller" onclick="checkAll(this.form,this.form.controller.checked,\'cp_arr\');" checked /><A>', 'TITLE' => _('Course Period')); if (!$_REQUEST['LO_save'] && !$extra['suppress_save']) { $_SESSION['List_PHP_SELF'] = PreparePHP_SELF($_SESSION['_REQUEST_vars'], array('bottom_back')); if ($_SESSION['Back_PHP_SELF'] != 'course') { $_SESSION['Back_PHP_SELF'] = 'course'; unset($_SESSION['Search_PHP_SELF']); } echo '<script type="text/javascript">parent.help.location.reload();</script>'; } echo '<INPUT type="hidden" name="relation">'; ListOutput($course_periods_RET, $LO_columns, 'Course Period', 'Course Periods'); } }