<?php DrawHeader(ProgramTitle()); echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '" method="POST">'; if ($_REQUEST['modfunc'] != 'students') { DrawHeader('<label>' . CheckBoxOnclick('include_child_mps') . ' ' . _('Show Child Marking Period Details') . '</label>'); } if ($_REQUEST['subject_id']) { $RET = DBGet(DBQuery("SELECT TITLE FROM COURSE_SUBJECTS WHERE SUBJECT_ID='" . $_REQUEST['subject_id'] . "'")); //modif Francois: add translation $header .= '<A HREF="Modules.php?modname=' . $_REQUEST['modname'] . '&include_child_mps=' . $_REQUEST['include_child_mps'] . '">' . _('Top') . '</A> › <A HREF="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=courses&subject_id=' . $_REQUEST['subject_id'] . '&include_child_mps=' . $_REQUEST['include_child_mps'] . '">' . $RET[1]['TITLE'] . '</A>'; if ($_REQUEST['course_id']) { $header2 = '<A HREF="Modules.php?modname=' . $_REQUEST['modname'] . '&subject_id=' . $_REQUEST['subject_id'] . '&course_id=' . $_REQUEST['course_id']; $location = 'courses'; $RET = DBGet(DBQuery("SELECT TITLE FROM COURSES WHERE COURSE_ID='" . $_REQUEST['course_id'] . "'")); $header .= ' › <A HREF="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=students&subject_id=' . $_REQUEST['subject_id'] . '&course_id=' . $_REQUEST['course_id'] . '&include_child_mps=' . $_REQUEST['include_child_mps'] . '">' . $RET[1]['TITLE'] . '</A>'; $header2 .= '&students=' . $location . '&modfunc=students&include_child_mps=' . $_REQUEST['include_child_mps'] . '">' . _('List Students') . '</A> | ' . $header2 . '&unscheduled=true&students=' . $location . '&modfunc=students&include_child_mps=' . $_REQUEST['include_child_mps'] . '">' . _('List Unscheduled Students') . '</A>'; DrawHeader($header, $header2); } else { DrawHeader($header); } } echo '</FORM>'; $LO_options = array('save' => false, 'search' => false, 'print' => false); echo '<TABLE><TR>'; // SUBJECTS ---- if (!$_REQUEST['modfunc'] || $_REQUEST['modfunc'] == 'courses' && $_REQUEST['students'] != 'courses') { $QI = DBQuery("SELECT s.SUBJECT_ID,s.TITLE FROM COURSE_SUBJECTS s WHERE s.SYEAR='" . UserSyear() . "' AND s.SCHOOL_ID='" . UserSchool() . "' ORDER BY s.SORT_ORDER,s.TITLE"); $RET = DBGet($QI); if (count($RET) && $_REQUEST['subject_id']) { foreach ($RET as $key => $value) {
$extra['SELECT'] .= ",coalesce(fssa.STATUS,'" . _('Active') . "') AS STATUS"; $extra['SELECT'] .= ",(SELECT BALANCE FROM FOOD_SERVICE_ACCOUNTS WHERE ACCOUNT_ID=fssa.ACCOUNT_ID) AS BALANCE"; if (!mb_strpos($extra['FROM'], 'fssa')) { $extra['FROM'] .= ",FOOD_SERVICE_STUDENT_ACCOUNTS fssa"; $extra['WHERE'] .= " AND fssa.STUDENT_ID=s.STUDENT_ID"; } $extra['functions'] += array('BALANCE' => 'red'); $extra['columns_after'] = array('BALANCE' => _('Balance'), 'STATUS' => _('Status')); Search('student_id', $extra); if (!$_REQUEST['modfunc'] && UserStudentID()) { $student = DBGet(DBQuery("SELECT s.STUDENT_ID,s.FIRST_NAME||' '||s.LAST_NAME AS FULL_NAME,fssa.ACCOUNT_ID,fssa.STATUS,fssa.DISCOUNT,fssa.BARCODE,(SELECT BALANCE FROM FOOD_SERVICE_ACCOUNTS WHERE ACCOUNT_ID=fssa.ACCOUNT_ID) AS BALANCE FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE s.STUDENT_ID='" . UserStudentID() . "' AND fssa.STUDENT_ID=s.STUDENT_ID")); $student = $student[1]; // find other students associated with the same account $xstudents = DBGet(DBQuery("SELECT s.STUDENT_ID,s.FIRST_NAME||' '||s.LAST_NAME AS FULL_NAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE fssa.ACCOUNT_ID='" . $student['ACCOUNT_ID'] . "' AND s.STUDENT_ID=fssa.STUDENT_ID AND s.STUDENT_ID!='" . UserStudentID() . "'" . ($_REQUEST['include_inactive'] ? '' : " AND exists(SELECT '' FROM STUDENT_ENROLLMENT WHERE STUDENT_ID=s.STUDENT_ID AND SYEAR='" . UserSyear() . "' AND (START_DATE<=CURRENT_DATE AND (END_DATE IS NULL OR CURRENT_DATE<=END_DATE)))"))); echo '<FORM action="Modules.php?modname=' . $_REQUEST[modname] . '&modfunc=update" method="POST">'; DrawHeader('<label>' . CheckBoxOnclick('include_inactive') . ' ' . _('Include Inactive Students in Shared Account') . '</label>', SubmitButton(_('Save'))); echo '<BR />'; //modif Francois: fix SQL bug invalid numeric data if (isset($error)) { echo $error; } PopTable('header', _('Account Information'), 'width="100%"'); echo '<TABLE class="width-100p">'; echo '<TR>'; echo '<TD class="valign-top">'; echo '<TABLE class="width-100p"><TR>'; echo '<TD class="valign-top">' . NoInput($student['FULL_NAME'], '<b>' . $student['STUDENT_ID'] . '</b>') . '</TD>'; echo '<TD class="valign-top">' . NoInput(red($student['BALANCE']), _('Balance')) . '</TD>'; echo '</TR></TABLE>'; echo '</TD></TR></TABLE>'; echo '<HR>';
} } $extra['SELECT'] .= ",'' AS COMMENTS,'' AS COMMENT"; $extra['functions'] += array('COMMENT' => '_makeComment'); $extra['MP'] = UserMP(); $extra['DATE'] = GetMP($_REQUEST['mp'], 'END_DATE'); $stu_RET = GetStuList($extra); echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}" . (count($categories_RET) && GetMP($_REQUEST['mp'], 'DOES_COMMENTS') == 'Y' ? "&tab_id={$_REQUEST['tab_id']}" : '') . " method=POST>"; if (!$_REQUEST['_CENTRE_PDF']) { if (count($commentsB_RET)) { foreach ($commentsB_RET as $comment) { $tipmessage .= $comment[1]['SORT_ORDER'] . ' - ' . str_replace("'", '´', $comment[1]['TITLE']) . '<BR>'; } $tipmessage = button('comment', 'Comment Codes', '# onClick=\'stm(["Report Card Comments","' . $tipmessage . '"],["white","#333366","","","",,"black","#e8e8ff","","","",,,,2,"#333366",2,,,,,"",5,3,50,50]);\'', ''); } DrawHeader($mps_select, SubmitButton(_('Save')), CheckBoxOnclick('include_inactive') . _('Include Inactive Students')); DrawHeader(($current_completed ? '<FONT COLOR=green>' . _('These grades are complete.') . '</FONT>' : '<FONT COLOR=red>' . _('These grades are NOT complete.') . '</FONT>') . (AllowEdit() ? ' | <FONT COLOR=green>You can edit these grades</FONT>' : ' | <FONT COLOR=red>You can not edit these grades</FONT>')); if (AllowEdit()) { if (substr($_REQUEST['mp'], 0, 1) != 'E') { $gb_header .= "<A HREF=Modules.php?modname={$_REQUEST['modname']}&include_inactive={$_REQUEST['include_inactive']}&modfunc=gradebook&mp={$_REQUEST['mp']}>Get Gradebook Grades</A>"; $prev_mp = DBGet(DBQuery("SELECT MARKING_PERIOD_ID,TITLE,START_DATE FROM SCHOOL_MARKING_PERIODS WHERE MP='" . GetMP($_REQUEST['mp'], 'MP') . "' AND SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' AND START_DATE<'" . GetMP($_REQUEST['mp'], 'START_DATE') . "' ORDER BY START_DATE DESC LIMIT 1")); $prev_mp = $prev_mp[1]; if ($prev_mp) { $gb_header .= " | <A HREF=Modules.php?modname={$_REQUEST['modname']}&include_inactive={$_REQUEST['include_inactive']}&modfunc=grades&tab_id={$_REQUEST['tab_id']}&mp={$_REQUEST['mp']}&prev_mp={$prev_mp['MARKING_PERIOD_ID']}>Get {$prev_mp['TITLE']} Grades</A>"; $gb_header .= " | <A HREF=Modules.php?modname={$_REQUEST['modname']}&include_inactive={$_REQUEST['include_inactive']}&modfunc=comments&tab_id={$_REQUEST['tab_id']}&mp={$_REQUEST['mp']}&prev_mp={$prev_mp['MARKING_PERIOD_ID']}>Get {$prev_mp['TITLE']} Comments</A>"; } $gb_header .= ' | '; } $gb_header .= "<A HREF=Modules.php?modname={$_REQUEST['modname']}&include_inactive={$_REQUEST['include_inactive']}&modfunc=clearall&tab_id={$_REQUEST['tab_id']}&mp={$_REQUEST['mp']}>Clear All</A>"; } DrawHeader($gb_header, $tipmessage);
<?php if ($_REQUEST['modname'] != 'Scheduling/Schedule.php' && $_REQUEST['modname'] != 'Scheduling/Scheduler.php') { function calcSeats0($period) { $mp = $period['MARKING_PERIOD_ID']; $seats = DBGet(DBQuery("SELECT max((SELECT count(1) FROM SCHEDULE ss JOIN STUDENT_ENROLLMENT sem ON (sem.STUDENT_ID=ss.STUDENT_ID AND sem.SYEAR=ss.SYEAR) WHERE ss.COURSE_PERIOD_ID='{$period['COURSE_PERIOD_ID']}' AND (ss.MARKING_PERIOD_ID='{$mp}' OR ss.MARKING_PERIOD_ID IN (" . GetAllMP(GetMP($mp, 'MP'), $mp) . ")) AND (ac.SCHOOL_DATE>=ss.START_DATE AND (ss.END_DATE IS NULL OR ac.SCHOOL_DATE<=ss.END_DATE)) AND (ac.SCHOOL_DATE>=sem.START_DATE AND (sem.END_DATE IS NULL OR ac.SCHOOL_DATE<=sem.END_DATE)))) AS FILLED_SEATS FROM ATTENDANCE_CALENDAR ac WHERE ac.CALENDAR_ID='{$period['CALENDAR_ID']}' AND ac.SCHOOL_DATE BETWEEN " . db_case(array("(CURRENT_DATE>'" . GetMP($mp, 'END_DATE') . "')", 'TRUE', "'" . GetMP($mp, 'START_DATE') . "'", 'CURRENT_DATE')) . " AND '" . GetMP($mp, 'END_DATE') . "'")); return $seats[1]['FILLED_SEATS']; } } if ($_REQUEST['modname'] == 'Scheduling/UnfilledRequests.php') { DrawHeader(ProgramTitle()); if ($_REQUEST['search_modfunc'] == 'list') { echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=modify METHOD=POST>"; DrawHeader(CheckBoxOnclick('include_seats') . _('Show Available Seats')); echo '</FORM>'; } } else { $extra['suppress_save'] = $extra['NoSearchTerms'] = true; } $extra['SELECT'] = ',s.CUSTOM_200000000,c.TITLE AS COURSE,sr.SUBJECT_ID,sr.COURSE_ID,sr.WITH_TEACHER_ID,sr.NOT_TEACHER_ID,sr.WITH_PERIOD_ID,sr.NOT_PERIOD_ID,\'0\' AS AVAILABLE_SEATS,(SELECT count(*) AS SECTIONS FROM COURSE_PERIODS cp WHERE cp.COURSE_ID=sr.COURSE_ID AND (cp.GENDER_RESTRICTION=\'N\' OR cp.GENDER_RESTRICTION=substring(s.CUSTOM_200000000,1,1)) AND (sr.WITH_TEACHER_ID IS NULL OR sr.WITH_TEACHER_ID=cp.TEACHER_ID) AND (sr.NOT_TEACHER_ID IS NULL OR sr.NOT_TEACHER_ID!=cp.TEACHER_ID) AND (sr.WITH_PERIOD_ID IS NULL OR sr.WITH_PERIOD_ID=cp.PERIOD_ID) AND (sr.NOT_PERIOD_ID IS NULL OR sr.NOT_PERIOD_ID!=cp.PERIOD_ID)) AS SECTIONS '; $extra['FROM'] = ',SCHEDULE_REQUESTS sr,COURSES c'; $extra['WHERE'] = ' AND sr.STUDENT_ID=ssm.STUDENT_ID AND sr.SYEAR=ssm.SYEAR AND sr.SCHOOL_ID=ssm.SCHOOL_ID AND sr.COURSE_ID=c.COURSE_ID AND NOT EXISTS (SELECT \'\' FROM SCHEDULE s WHERE s.STUDENT_ID=sr.STUDENT_ID AND s.COURSE_ID=sr.COURSE_ID)'; $extra['functions'] = array('WITH_TEACHER_ID' => '_makeTeacher', 'WITH_PERIOD_ID' => '_makePeriod'); if ($_REQUEST['include_seats']) { $extra['functions'] += array('AVAILABLE_SEATS' => 'CalcSeats'); } $extra['columns_after'] = array('COURSE' => _('Request')); if ($_REQUEST['include_seats']) { $extra['columns_after'] += array('AVAILABLE_SEATS' => _('Available Seats')); }
<?php DrawHeader(_('Gradebook') . ' - ' . ProgramTitle()); $max_allowed = Preferences('ANOMALOUS_MAX', 'Gradebook') / 100; echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '" method="POST">'; DrawHeader('<label>' . CheckBoxOnclick('include_all_courses') . ' ' . _('Include All Courses') . '</label>', '', ' <label>' . CheckBoxOnclick('include_inactive') . ' ' . _('Include Inactive Students') . '</label>'); if (!$_REQUEST['missing'] && !$_REQUEST['negative'] && !$_REQUEST['max_allowed']) { $_REQUEST['missing'] = $_REQUEST['negative'] = $_REQUEST['max_allowed'] = 'Y'; } DrawHeader(Localize('colon', _('Include')) . ' <label>' . CheckBoxOnclick('missing') . ' ' . _('Missing Grades') . '</label> <label>' . CheckBoxOnclick('negative') . ' ' . _('Excused and Negative Grades') . '</label> <label>' . CheckBoxOnclick('max_allowed') . ' ' . sprintf(_('Exceed %d%% and Extra Credit Grades'), $max_allowed * 100) . '</label>'); echo '</FORM>'; if ($_REQUEST['student_id']) { if ($_REQUEST['student_id'] != $_SESSION['student_id']) { $_SESSION['student_id'] = $_REQUEST['student_id']; if ($_REQUEST['period'] && $_REQUEST['period'] != $_SESSION['UserCoursePeriod']) { $_SESSION['UserCoursePeriod'] = $_REQUEST['period']; } echo '<script type="text/javascript">parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>'; } } else { if ($_SESSION['student_id']) { unset($_SESSION['student_id']); if ($_REQUEST['period'] && $_REQUEST['period'] != $_SESSION['UserCoursePeriod']) { $_SESSION['UserCoursePeriod'] = $_REQUEST['period']; } echo '<script type="text/javascript">parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>'; } } if ($_REQUEST['period']) { if ($_REQUEST['period'] != $_SESSION['UserCoursePeriod']) { $_SESSION['UserCoursePeriod'] = $_REQUEST['period'];
if (Preferences('WEIGHT', 'Gradebook') == 'Y') { $LO_columns += array('FINAL_GRADE_PERCENT' => _('Percent')); } $LO_columns += array('SORT_ORDER' => _('Sort Order'), 'COLOR' => _('Color')); $link['add']['html'] = array('TITLE' => _makeTypeInput('', 'TITLE'), 'SORT_ORDER' => _makeTypeInput('', 'SORT_ORDER'), 'COLOR' => _makeColorInput('', 'COLOR')); if (Preferences('WEIGHT', 'Gradebook') == 'Y') { $link['add']['html']['FINAL_GRADE_PERCENT'] = _makeTypeInput('', 'FINAL_GRADE_PERCENT'); } $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id=new&allow_edit={$_REQUEST['allow_edit']}"; $link['remove']['variables'] = array('id' => 'ASSIGNMENT_TYPE_ID'); $link['add']['html']['remove'] = button('add'); $tabs[] = array('title' => button('add', '', '', 14), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new&allow_edit={$_REQUEST['allow_edit']}"); $subject = 'Assignmemt Types'; } echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=update&tab_id=' . $_REQUEST['tab_id'] . '" method="POST">'; DrawHeader('<label>' . CheckBoxOnclick('allow_edit') . ' ' . _('Edit') . '</label>', SubmitButton(_('Save'))); echo '<BR />'; $LO_options = array('save' => false, 'search' => false, 'header_color' => $types_RET[$_REQUEST['tab_id']][1]['COLOR'], 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}&allow_edit={$_REQUEST['allow_edit']}")); if ($subject == 'Assignments') { ListOutput($LO_ret, $LO_columns, 'Assignment', 'Assignments', $link, array(), $LO_options); } else { ListOutput($LO_ret, $LO_columns, 'Assignment Type', 'Assignment Types', $link, array(), $LO_options); } echo '<span class="center">' . SubmitButton(_('Save')) . '</span>'; echo '</FORM>'; } function _makeAssnInput($value, $name) { global $THIS_RET, $type_options; if ($THIS_RET['ASSIGNMENT_ID']) { $id = $THIS_RET['ASSIGNMENT_ID'];
DBQuery("DELETE FROM STUDENT_REPORT_CARD_GRADES WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "'"); DBQuery("DELETE FROM STUDENT_REPORT_CARD_COMMENTS WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "'"); DBQuery("DELETE FROM ATTENDANCE_PERIOD WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "'"); } else { DBQuery("DELETE FROM ATTENDANCE_PERIOD WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "' AND (" . ($columns['START_DATE'] ? "SCHOOL_DATE<'" . $columns['START_DATE'] . "'" : 'FALSE') . ' OR ' . ($columns['END_DATE'] ? "SCHOOL_DATE>'" . $columns['END_DATE'] . "'" : 'FALSE') . ")"); } } } } unset($_SESSION['_REQUEST_vars']['schedule']); unset($_REQUEST['schedule']); } if (UserStudentID() && $_REQUEST['modfunc'] != 'choose_course') { echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=modify" METHOD="POST">'; //modif Francois: add label on checkbox DrawHeader(PrepareDate($date, '_date', false, array('submit' => true)) . ' ' . '<label>' . CheckBoxOnclick('include_inactive') . ' ' . _('Include Inactive Courses') . (AllowEdit() ? '</label> <label>' . CheckBoxOnclick('include_seats') . ' ' . _('Show Available Seats') . '</label>' : ''), SubmitButton(_('Save'))); //modif Francois: remove ProgramLink function //DrawHeader(ProgramLink('Scheduling/PrintSchedules.php',_('Print Schedule'),'&modfunc=save&st_arr[]='.UserStudentID().'&_ROSARIO_PDF=true')); //modif Francois: add Horizontal format option $printSchedulesLinkhref = 'Modules.php?modname=Scheduling/PrintSchedules.php&modfunc=save&st_arr[]=' . UserStudentID() . '&_ROSARIO_PDF=true&schedule_table=Yes'; ?> <script type="text/javascript"> function horizontalFormatSwitch() { if (document.getElementById("horizontalFormat").checked==true) document.getElementById("printSchedulesLink").href=document.getElementById("printSchedulesLink").href+'&horizontalFormat'; else document.getElementById("printSchedulesLink").href=document.getElementById("printSchedulesLink").href.replace('&horizontalFormat',''); } </script> <?php
<?php DrawHeader(ProgramTitle()); echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>"; if ($_REQUEST['modfunc'] != 'students') { DrawHeader(CheckBoxOnclick('include_child_mps') . _('Show Child Marking Period Details')); } if ($_REQUEST['subject_id']) { $RET = DBGet(DBQuery("SELECT TITLE FROM COURSE_SUBJECTS WHERE SUBJECT_ID='" . $_REQUEST['subject_id'] . "'")); $header .= "<A HREF=Modules.php?modname={$_REQUEST['modname']}&include_child_mps={$_REQUEST['include_child_mps']}>Top</A> >> <A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=courses&subject_id={$_REQUEST['subject_id']}&include_child_mps={$_REQUEST['include_child_mps']}>" . $RET[1]['TITLE'] . '</A>'; if ($_REQUEST['course_id']) { $header2 = "<A HREF=Modules.php?modname={$_REQUEST['modname']}&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']}"; $location = 'courses'; $RET = DBGet(DBQuery("SELECT TITLE FROM COURSES WHERE COURSE_ID='" . $_REQUEST['course_id'] . "'")); $header .= " >> <A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=students&subject_id={$_REQUEST['subject_id']}&course_id={$_REQUEST['course_id']}&include_child_mps={$_REQUEST['include_child_mps']}>" . $RET[1]['TITLE'] . '</A>'; $header2 .= "&students={$location}&modfunc=students&include_child_mps={$_REQUEST['include_child_mps']}>" . _('List Students') . "</A> || " . $header2 . "&unscheduled=true&students={$location}&modfunc=students&include_child_mps={$_REQUEST['include_child_mps']}>" . _('List Unscheduled Students') . "</A>"; DrawHeader($header, $header2); } else { DrawHeader($header); } } echo '</FORM>'; $LO_options = array('save' => false, 'search' => false, 'print' => false); echo '<TABLE><TR>'; // SUBJECTS ---- if (!$_REQUEST['modfunc'] || $_REQUEST['modfunc'] == 'courses' && $_REQUEST['students'] != 'courses') { $QI = DBQuery("SELECT s.SUBJECT_ID,s.TITLE FROM COURSE_SUBJECTS s WHERE s.SYEAR='" . UserSyear() . "' AND s.SCHOOL_ID='" . UserSchool() . "' ORDER BY s.SORT_ORDER,s.TITLE"); $RET = DBGet($QI); if (count($RET) && $_REQUEST['subject_id']) { foreach ($RET as $key => $value) { if ($value['SUBJECT_ID'] == $_REQUEST['subject_id']) {
$link = array('TITLE' => array('link' => "Modules.php?modname={$_REQUEST['modname']}" . ($do_stats ? "&do_stats={$_REQUEST['do_stats']}" : ''), 'variables' => array('id' => 'ID'))); ListOutput($LO_ret, $LO_columns, 'Course', 'Courses', $link, array(), array('center' => false, 'save' => false, 'search' => false)); } else { DrawHeader(_('There are no grades available for this student.')); } } else { if ($_REQUEST['id'] == 'all') { //modif Francois: add translation DrawHeader(_('All Courses'), ''); } else { $courses_RET = array($_REQUEST['id'] => $courses_RET[$_REQUEST['id']]); DrawHeader('<B>' . $courses_RET[$_REQUEST['id']][1]['COURSE_TITLE'] . '</B> - ' . mb_substr($courses_RET[$_REQUEST['id']][1]['TITLE'], mb_strrpos(str_replace(' - ', ' ^ ', $courses_RET[$_REQUEST['id']][1]['TITLE']), '^') + 2), '<A HREF="Modules.php?modname=' . $_REQUEST['modname'] . ($do_stats ? '&do_stats=' . $_REQUEST['do_stats'] : '') . '">' . _('Back to Totals') . '</A>'); } if ($do_stats) { //modif Francois: add label on checkbox DrawHeader('', '<label>' . CheckBoxOnclick('do_stats') . ' ' . _('Include Anonymous Statistics') . '</label>'); } //echo '<pre>'; var_dump($courses_RET); echo '</pre>'; foreach ($courses_RET as $course_period_id => $course) { $course = $course[1]; $staff_id = $course['STAFF_ID']; if (!$programconfig[$staff_id]) { $config_RET = DBGet(DBQuery("SELECT TITLE,VALUE FROM PROGRAM_USER_CONFIG WHERE USER_ID='{$staff_id}' AND PROGRAM='Gradebook'"), array(), array('TITLE')); if (count($config_RET)) { foreach ($config_RET as $title => $value) { $programconfig[$staff_id][$title] = $value[1]['VALUE']; } } else { $programconfig[$staff_id] = true; } }
} unset($LO_ret[0]); $link = array('TITLE' => array('link' => "Modules.php?modname={$_REQUEST['modname']}" . ($do_stats ? "&do_stats={$_REQUEST['do_stats']}" : ''), 'variables' => array('id' => 'ID'))); ListOutput($LO_ret, $LO_columns, _('Course'), _('Courses'), $link, array(), array('center' => false, 'save' => false, 'search' => false)); } else { DrawHeader(_('There are no grades available for this student.')); } } else { if ($_REQUEST['id'] == 'all') { DrawHeader('All Courses', ''); } else { $courses_RET = array($_REQUEST['id'] => $courses_RET[$_REQUEST['id']]); DrawHeader('<B>' . $courses_RET[$_REQUEST['id']][1]['COURSE_TITLE'] . '</B> - ' . substr($courses_RET[$_REQUEST['id']][1]['TITLE'], strrpos(str_replace(' - ', ' ^ ', $courses_RET[$_REQUEST['id']][1]['TITLE']), '^') + 2), "<A HREF=Modules.php?modname={$_REQUEST['modname']}" . ($do_stats ? "&do_stats={$_REQUEST['do_stats']}" : '') . ">Back to Totals</A>"); } if ($do_stats) { DrawHeader('', CheckBoxOnclick('do_stats') . _('Include Anonymous Statistics')); } //echo '<pre>'; var_dump($courses_RET); echo '</pre>'; foreach ($courses_RET as $course_period_id => $course) { $course = $course[1]; $staff_id = $course['STAFF_ID']; if (!$programconfig[$staff_id]) { $config_RET = DBGet(DBQuery("SELECT TITLE,VALUE FROM PROGRAM_USER_CONFIG WHERE USER_ID='{$staff_id}' AND PROGRAM='Gradebook'"), array(), array('TITLE')); if (count($config_RET)) { foreach ($config_RET as $title => $value) { $programconfig[$staff_id][$title] = $value[1]['VALUE']; } } else { $programconfig[$staff_id] = true; } }
} $type_select .= '</SELECT>'; $assignment_select = '<SELECT name=assignment_id onchange="document.location.href=\'Modules.php?modname=' . $_REQUEST['modname'] . '&include_inactive=' . $_REQUEST['include_inactive'] . '&include_all=' . $_REQUEST['include_all'] . '&type_id=' . $_REQUEST['type_id'] . '&assignment_id=\'+this.options[selectedIndex].value"><OPTION value="">Totals</OPTION><OPTION value="all"' . ($_REQUEST['assignment_id'] == 'all' && !UserStudentID() ? ' SELECTED' : '') . '>All</OPTION>'; if (UserStudentID() && $_REQUEST['assignment_id'] == 'all') { $assignment_select .= '<OPTION value="all" SELECTED>' . $stu_RET[1]['FULL_NAME'] . '</OPTION>'; } foreach ($assignments_RET as $id => $assignment) { $assignment_select .= '<OPTION value=' . $id . ($_REQUEST['assignment_id'] == $id ? ' SELECTED' : '') . '>' . ($_REQUEST['type_id'] ? '' : $types_RET[$assignment[1]['ASSIGNMENT_TYPE_ID']][1]['TITLE'] . ' - ') . $assignment[1]['TITLE'] . '</OPTION>'; } $assignment_select .= '</SELECT>'; echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&student_id=" . UserStudentID() . " method=POST>"; $tabs = array(array('title' => _('All'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&type_id=" . ($_REQUEST['assignment_id'] == 'all' ? '&assignment_id=all' : '') . (UserStudentID() ? '&student_id=' . UserStudentID() : '') . "&include_inactive={$_REQUEST['include_inactive']}&include_all={$_REQUEST['include_all']}")); foreach ($types_RET as $id => $type) { $tabs[] = array('title' => $type[1]['TITLE'] . ($programconfig[User('STAFF_ID')]['WEIGHT'] == 'Y' ? '|' . number_format(100 * $type[1]['FINAL_GRADE_PERCENT'], 0) . '%' : ''), 'link' => "Modules.php?modname={$_REQUEST['modname']}&type_id={$id}" . ($_REQUEST['assignment_id'] == 'all' ? '&assignment_id=all' : '') . (UserStudentID() ? '&student_id=' . UserStudentID() : '') . "&include_inactive={$_REQUEST['include_inactive']}&include_all={$_REQUEST['include_all']}") + ($type[1]['COLOR'] ? array('color' => $type[1]['COLOR']) : array()); } DrawHeader($type_select . $assignment_select, $_REQUEST['assignment_id'] ? SubmitButton(_('Save')) : '', CheckBoxOnclick('include_inactive') . _('Include Inactive Students') . ' ' . CheckBoxOnclick('include_all') . _('Include Inactive Assignments')); if ($_REQUEST['assignment_id'] && $_REQUEST['assignment_id'] != 'all') { $assigned_date = $assignments_RET[$_REQUEST['assignment_id']][1]['ASSIGNED_DATE']; $due_date = $assignments_RET[$_REQUEST['assignment_id']][1]['DUE_DATE']; $due = $assignments_RET[$_REQUEST['assignment_id']][1]['DUE']; DrawHeader('<b>' . Localize('colon', _('Assigned Date')) . '</b> ' . ($assigned_date ? ProperDate($assigned_date) : 'n/a') . ', <b>' . Localize('colon', _('Due Date')) . '</b> ' . ($due_date ? ProperDate($due_date) : _('n/a')) . ($due ? ' - <b>' . _('Assignment is Due') . '</b>' : '')); } if ($_REQUEST['type_id'] && $types_RET[$_REQUEST['type_id']][1]['COLOR']) { $LO_options['header_color'] = $types_RET[$_REQUEST['type_id']][1]['COLOR']; } if (!UserStudentID() && $_REQUEST['assignment_id'] == 'all') { $LO_options['yscroll'] = true; } $LO_options['header'] = WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&type_id=" . ($_REQUEST['type_id'] ? $_REQUEST['type_id'] : ($_REQUEST['assignment_id'] && $_REQUEST['assignment_id'] != 'all' ? $assignments_RET[$_REQUEST['assignment_id']][1]['ASSIGNMENT_TYPE_ID'] : '')) . ($_REQUEST['assignment_id'] == 'all' ? '&assignment_id=all' : '') . (UserStudentID() ? '&student_id=' . UserStudentID() : '') . "&include_inactive={$_REQUEST['include_inactive']}&include_all={$_REQUEST['include_all']}"); ListOutput($stu_RET, $LO_columns, $item, $items, $link, array(), $LO_options); echo $_REQUEST['assignment_id'] ? '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>' : '';
DBQuery("DELETE FROM GRADEBOOK_GRADES WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "'"); DBQuery("DELETE FROM STUDENT_REPORT_CARD_GRADES WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "'"); DBQuery("DELETE FROM STUDENT_REPORT_CARD_COMMENTS WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "'"); DBQuery("DELETE FROM ATTENDANCE_PERIOD WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "'"); } else { DBQuery("DELETE FROM ATTENDANCE_PERIOD WHERE STUDENT_ID='" . UserStudentID() . "' AND COURSE_PERIOD_ID='" . $course_period_id . "' AND (" . ($columns['START_DATE'] ? "SCHOOL_DATE<'" . $columns['START_DATE'] . "'" : 'FALSE') . ' OR ' . ($columns['END_DATE'] ? "SCHOOL_DATE>'" . $columns['END_DATE'] . "'" : 'FALSE') . ")"); } } } } unset($_SESSION['_REQUEST_vars']['schedule']); unset($_REQUEST['schedule']); } if (UserStudentID() && $_REQUEST['modfunc'] != 'choose_course') { echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=modify METHOD=POST>"; DrawHeader(PrepareDate($date, '_date', false, array('submit' => true)) . ' ' . CheckBoxOnclick('include_inactive') . _('Include Inactive Courses') . (AllowEdit() ? ' ' . CheckBoxOnclick('include_seats') . _('Show Open Seats') : ''), SubmitButton(_('Save'))); DrawHeader(ProgramLink('Scheduling/PrintSchedules.php', _('Print Schedule'), '&modfunc=save&st_arr[]=' . UserStudentID() . '&_CENTRE_PDF=true')); /* $schedule_fields_RET = DBGet(DBQuery("SELECT cf.TITLE,s.CUSTOM_71 FROM CUSTOM_FIELDS cf,STUDENTS s WHERE s.STUDENT_ID='".UserStudentID()."' AND cf.ID='71'")); if($schedule_fields_RET[1]['TITLE']=='Team') DrawHeader('<font color=gray><b>'.$schedule_fields_RET[1]['TITLE'].': </b></font>'.$schedule_fields_RET[1]['CUSTOM_71']); */ // get the fy marking period id, there should be exactly one fy marking period $fy_id = DBGet(DBQuery("SELECT MARKING_PERIOD_ID FROM SCHOOL_MARKING_PERIODS WHERE MP='FY' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'")); $fy_id = $fy_id[1]['MARKING_PERIOD_ID']; $sql = "SELECT\n\t\t\t\ts.COURSE_ID,s.COURSE_PERIOD_ID,\n\t\t\t\ts.MARKING_PERIOD_ID,s.START_DATE,s.END_DATE,\n\t\t\t\textract(EPOCH FROM s.START_DATE) AS START_EPOCH,extract(EPOCH FROM s.END_DATE) AS END_EPOCH,sp.PERIOD_ID,\n\t\t\t\tcp.PERIOD_ID,cp.MARKING_PERIOD_ID AS COURSE_MARKING_PERIOD_ID,cp.MP,cp.CALENDAR_ID,cp.TOTAL_SEATS,\n\t\t\t\tc.TITLE,cp.COURSE_PERIOD_ID AS PERIOD_PULLDOWN,\n\t\t\t\ts.STUDENT_ID,ROOM,DAYS,SCHEDULER_LOCK\n\t\t\tFROM SCHEDULE s,COURSES c,COURSE_PERIODS cp,SCHOOL_PERIODS sp\n\t\t\tWHERE\n\t\t\t\ts.COURSE_ID = c.COURSE_ID AND s.COURSE_ID = cp.COURSE_ID\n\t\t\t\tAND s.COURSE_PERIOD_ID = cp.COURSE_PERIOD_ID\n\t\t\t\tAND s.SCHOOL_ID = sp.SCHOOL_ID AND s.SYEAR = c.SYEAR AND sp.PERIOD_ID = cp.PERIOD_ID\n\t\t\t\tAND s.STUDENT_ID='" . UserStudentID() . "'\n\t\t\t\tAND s.SYEAR='" . UserSyear() . "'\n\t\t\t\tAND s.SCHOOL_ID = '" . UserSchool() . "'"; if ($_REQUEST['include_inactive'] != 'Y') { $sql .= " AND ('" . $date . "' BETWEEN s.START_DATE AND s.END_DATE OR (s.END_DATE IS NULL AND s.START_DATE<='" . $date . "')) "; } $sql .= " ORDER BY sp.SORT_ORDER,s.MARKING_PERIOD_ID"; $QI = DBQuery($sql);
DrawHeader($title, $delete_button . SubmitButton(_('Save'))); $header .= '<TABLE cellpadding=3 bgcolor=#F0F0F1 width=100%>'; $header .= '<TR>'; $header .= '<TD>' . TextInput($RET['TITLE'], 'tables[COURSE_SUBJECTS][' . $_REQUEST['subject_id'] . '][TITLE]', _('Title')) . '</TD>'; $header .= '<TD>' . TextInput($RET['SORT_ORDER'], 'tables[COURSE_SUBJECTS][' . $_REQUEST['subject_id'] . '][SORT_ORDER]', _('Sort Order')) . '</TD>'; $header .= '</TR>'; $header .= '</TABLE>'; DrawHeader($header); echo '</FORM>'; } } // DISPLAY THE MENU if ($_REQUEST['modfunc'] == 'choose_course') { if ($_REQUEST['modname'] == 'Scheduling/Schedule.php') { echo "<FORM action=Modules.php?modname={$_REQUEST['modname']} method=POST>"; DrawHeader(_('Choose a ') . ($_REQUEST['last_year'] == 'true' ? _('Last Year ') : '') . ($_REQUEST['subject_id'] ? $_REQUEST['course_id'] ? _('Course Period') : _('Course') : _('Subject')), _('Enrollment Date ') . PrepareDate($date, '_date', false, array('submit' => true)), CheckBoxOnclick('include_child_mps') . _('Offer Enrollment in Child Marking Periods')); echo '</FORM>'; } else { DrawHeader(_('Choose a ') . ($_REQUEST['last_year'] == 'true' ? _('Last Year ') : '') . ($_REQUEST['subject_id'] ? $_REQUEST['course_id'] ? _('Course Period') : _('Course') : _('Subject'))); } } elseif (!$_REQUEST['subject_id']) { DrawHeader(_('Courses')); } DrawHeader('', "<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc={$_REQUEST['modfunc']}&course_modfunc=search&last_year={$_REQUEST['last_year']}" . ($_REQUEST['modfunc'] == 'choose_course' && $_REQUEST['modname'] == 'Scheduling/Schedule.php' ? "&include_child_mps={$_REQUEST['include_child_mps']}&year_date={$_REQUEST['year_date']}&month_date={$_REQUEST['month_date']}&day_date={$_REQUEST['day_date']}" : '') . ">" . _('Search') . "</A>"); echo '<TABLE><TR>'; if (count($subjects_RET)) { if ($_REQUEST['subject_id']) { foreach ($subjects_RET as $key => $value) { if ($value['SUBJECT_ID'] == $_REQUEST['subject_id']) { $subjects_RET[$key]['row_color'] = Preferences('HIGHLIGHT'); }
<?php if ($_REQUEST['modname'] != 'Scheduling/Schedule.php' && $_REQUEST['modname'] != 'Scheduling/Scheduler.php') { function calcSeats0($period) { $mp = $period['MARKING_PERIOD_ID']; $seats = DBGet(DBQuery("SELECT max((SELECT count(1) FROM SCHEDULE ss JOIN STUDENT_ENROLLMENT sem ON (sem.STUDENT_ID=ss.STUDENT_ID AND sem.SYEAR=ss.SYEAR) WHERE ss.COURSE_PERIOD_ID='{$period['COURSE_PERIOD_ID']}' AND (ss.MARKING_PERIOD_ID='{$mp}' OR ss.MARKING_PERIOD_ID IN (" . GetAllMP(GetMP($mp, 'MP'), $mp) . ")) AND (ac.SCHOOL_DATE>=ss.START_DATE AND (ss.END_DATE IS NULL OR ac.SCHOOL_DATE<=ss.END_DATE)) AND (ac.SCHOOL_DATE>=sem.START_DATE AND (sem.END_DATE IS NULL OR ac.SCHOOL_DATE<=sem.END_DATE)))) AS FILLED_SEATS FROM ATTENDANCE_CALENDAR ac WHERE ac.CALENDAR_ID='{$period['CALENDAR_ID']}' AND ac.SCHOOL_DATE BETWEEN " . db_case(array("(CURRENT_DATE>'" . GetMP($mp, 'END_DATE') . "')", 'TRUE', "'" . GetMP($mp, 'START_DATE') . "'", 'CURRENT_DATE')) . " AND '" . GetMP($mp, 'END_DATE') . "'")); return $seats[1]['FILLED_SEATS']; } } if ($_REQUEST['modname'] == 'Scheduling/UnfilledRequests.php') { DrawHeader(ProgramTitle()); if ($_REQUEST['search_modfunc'] == 'list') { echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=modify" METHOD="POST">'; DrawHeader('<label>' . CheckBoxOnclick('include_seats') . ' ' . _('Show Available Seats') . '</label>'); echo '</FORM>'; } } else { $extra['suppress_save'] = $extra['NoSearchTerms'] = true; } //modif Francois: multiple school periods for a course period /*$extra['SELECT'] = ',s.CUSTOM_200000000,c.TITLE AS COURSE,sr.SUBJECT_ID,sr.COURSE_ID,sr.WITH_TEACHER_ID,sr.NOT_TEACHER_ID,sr.WITH_PERIOD_ID,sr.NOT_PERIOD_ID,\'0\' AS AVAILABLE_SEATS,(SELECT count(*) AS SECTIONS FROM COURSE_PERIODS cp WHERE cp.COURSE_ID=sr.COURSE_ID AND (cp.GENDER_RESTRICTION=\'N\' OR cp.GENDER_RESTRICTION=substring(s.CUSTOM_200000000,1,1)) AND (sr.WITH_TEACHER_ID IS NULL OR sr.WITH_TEACHER_ID=cp.TEACHER_ID) AND (sr.NOT_TEACHER_ID IS NULL OR sr.NOT_TEACHER_ID!=cp.TEACHER_ID) AND (sr.WITH_PERIOD_ID IS NULL OR sr.WITH_PERIOD_ID=cp.PERIOD_ID) AND (sr.NOT_PERIOD_ID IS NULL OR sr.NOT_PERIOD_ID!=cp.PERIOD_ID)) AS SECTIONS ';*/ $extra['SELECT'] = ',s.CUSTOM_200000000,c.TITLE AS COURSE,sr.SUBJECT_ID,sr.COURSE_ID,sr.WITH_TEACHER_ID,sr.NOT_TEACHER_ID,sr.WITH_PERIOD_ID,sr.NOT_PERIOD_ID,\'0\' AS AVAILABLE_SEATS,(SELECT count(*) AS SECTIONS FROM COURSE_PERIODS cp WHERE cp.COURSE_ID=sr.COURSE_ID AND (cp.GENDER_RESTRICTION=\'N\' OR cp.GENDER_RESTRICTION=substring(s.CUSTOM_200000000,1,1)) AND (sr.WITH_TEACHER_ID IS NULL OR sr.WITH_TEACHER_ID=cp.TEACHER_ID) AND (sr.NOT_TEACHER_ID IS NULL OR sr.NOT_TEACHER_ID!=cp.TEACHER_ID)) AS SECTIONS '; //$extra['FROM'] = ',SCHEDULE_REQUESTS sr,COURSES c'; $extra['FROM'] = ',SCHEDULE_REQUESTS sr,COURSES c'; //$extra['WHERE'] = ' AND sr.STUDENT_ID=ssm.STUDENT_ID AND sr.SYEAR=ssm.SYEAR AND sr.SCHOOL_ID=ssm.SCHOOL_ID AND sr.COURSE_ID=c.COURSE_ID AND NOT EXISTS (SELECT \'\' FROM SCHEDULE s WHERE s.STUDENT_ID=sr.STUDENT_ID AND s.COURSE_ID=sr.COURSE_ID)'; $extra['WHERE'] = ' AND sr.STUDENT_ID=ssm.STUDENT_ID AND sr.SYEAR=ssm.SYEAR AND sr.SCHOOL_ID=ssm.SCHOOL_ID AND sr.COURSE_ID=c.COURSE_ID AND NOT EXISTS (SELECT \'\' FROM SCHEDULE s WHERE s.STUDENT_ID=sr.STUDENT_ID AND s.COURSE_ID=sr.COURSE_ID)'; $extra['functions'] = array('WITH_TEACHER_ID' => '_makeTeacher', 'WITH_PERIOD_ID' => '_makePeriod'); if ($_REQUEST['include_seats']) { $extra['functions'] += array('AVAILABLE_SEATS' => 'CalcSeats'); }
$extra['SELECT'] .= ",coalesce(fssa.STATUS,'Active') AS STATUS"; $extra['SELECT'] .= ",(SELECT BALANCE FROM FOOD_SERVICE_ACCOUNTS WHERE ACCOUNT_ID=fssa.ACCOUNT_ID) AS BALANCE"; if (!strpos($extra['FROM'], 'fssa')) { $extra['FROM'] .= ",FOOD_SERVICE_STUDENT_ACCOUNTS fssa"; $extra['WHERE'] .= " AND fssa.STUDENT_ID=s.STUDENT_ID"; } $extra['functions'] += array('BALANCE' => 'red'); $extra['columns_after'] = array('BALANCE' => 'Balance', 'STATUS' => 'Status'); Search('student_id', $extra); if (!$_REQUEST['modfunc'] && UserStudentID()) { $student = DBGet(DBQuery("SELECT s.STUDENT_ID," . (Preferences('NAME') == 'Common' ? 'coalesce(s.CUSTOM_200000002,s.FIRST_NAME)' : 's.FIRST_NAME') . "||' '||s.LAST_NAME AS FULL_NAME,fssa.ACCOUNT_ID,fssa.STATUS,fssa.DISCOUNT,fssa.BARCODE,(SELECT BALANCE FROM FOOD_SERVICE_ACCOUNTS WHERE ACCOUNT_ID=fssa.ACCOUNT_ID) AS BALANCE FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE s.STUDENT_ID='" . UserStudentID() . "' AND fssa.STUDENT_ID=s.STUDENT_ID")); $student = $student[1]; // find other students associated with the same account $xstudents = DBGet(DBQuery("SELECT s.STUDENT_ID," . (Preferences('NAME') == 'Common' ? 'coalesce(s.CUSTOM_200000002,s.FIRST_NAME)' : 's.FIRST_NAME') . "||' '||s.LAST_NAME AS FULL_NAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fssa WHERE fssa.ACCOUNT_ID='" . $student['ACCOUNT_ID'] . "' AND s.STUDENT_ID=fssa.STUDENT_ID AND s.STUDENT_ID!='" . UserStudentID() . "'" . ($_REQUEST['include_inactive'] ? '' : " AND exists(SELECT '' FROM STUDENT_ENROLLMENT WHERE STUDENT_ID=s.STUDENT_ID AND SYEAR='" . UserSyear() . "' AND (START_DATE<=CURRENT_DATE AND (END_DATE IS NULL OR CURRENT_DATE<=END_DATE)))"))); echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>"; DrawHeader(CheckBoxOnclick('include_inactive') . _('Include Inactive Students in Shared Account'), SubmitButton(_('Save'))); echo '<BR>'; PopTable('header', _('Account Information'), 'width=100%'); echo '<TABLE width=100%>'; echo '<TR>'; echo '<TD valign=top>'; echo '<TABLE width=100%><TR>'; echo '<TD valign=top>' . NoInput($student['FULL_NAME'], '<b>' . $student['STUDENT_ID'] . '</b>') . '</TD>'; echo '<TD valign=top>' . NoInput(red($student['BALANCE']), _('Balance')) . '</TD>'; echo '</TR></TABLE>'; echo '</TD></TR></TABLE>'; echo '<HR>'; echo '<TABLE width=100% border=0 cellpadding=0 cellspacing=0>'; echo '<TR><TD valign=top>'; echo '<TABLE border=0 cellpadding=6 width=100%>'; echo '<TR>';
if (Preferences('WEIGHT', 'Gradebook') == 'Y') { $LO_columns += array('FINAL_GRADE_PERCENT' => _('Percent')); } $LO_columns += array('SORT_ORDER' => _('Sort Order'), 'COLOR' => _('Color')); $link['add']['html'] = array('TITLE' => _makeTypeInput('', 'TITLE'), 'SORT_ORDER' => _makeTypeInput('', 'SORT_ORDER'), 'COLOR' => _makeColorInput('', 'COLOR')); if (Preferences('WEIGHT', 'Gradebook') == 'Y') { $link['add']['html']['FINAL_GRADE_PERCENT'] = _makeTypeInput('', 'FINAL_GRADE_PERCENT'); } $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id=new&allow_edit={$_REQUEST['allow_edit']}"; $link['remove']['variables'] = array('id' => 'ASSIGNMENT_TYPE_ID'); $link['add']['html']['remove'] = button('add'); $tabs[] = array('title' => button('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new&allow_edit={$_REQUEST['allow_edit']}"); $subject = 'Assignmemt Types'; } echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&tab_id={$_REQUEST['tab_id']} method=POST>"; DrawHeader(CheckBoxOnclick('allow_edit') . ' ' . _('Edit'), SubmitButton(_('Save'))); echo '<BR>'; $LO_options = array('save' => false, 'search' => false, 'header_color' => $types_RET[$_REQUEST['tab_id']][1]['COLOR'], 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}&allow_edit={$_REQUEST['allow_edit']}")); if ($subject == 'Assignments') { ListOutput($LO_ret, $LO_columns, _('Assignment'), _('Assignments'), $link, array(), $LO_options); } else { ListOutput($LO_ret, $LO_columns, _('Assignment Type'), _('Assignment Types'), $link, array(), $LO_options); } echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>'; echo '</FORM>'; } function _makeAssnInput($value, $name) { global $THIS_RET, $type_options; if ($THIS_RET['ASSIGNMENT_ID']) { $id = $THIS_RET['ASSIGNMENT_ID'];
$type_select .= '</SELECT>'; $assignment_select = '<SELECT name=assignment_id onchange="document.location.href=\'Modules.php?modname=' . $_REQUEST['modname'] . '&include_inactive=' . $_REQUEST['include_inactive'] . '&include_all=' . $_REQUEST['include_all'] . '&type_id=' . $_REQUEST['type_id'] . '&assignment_id=\'+this.options[selectedIndex].value"><OPTION value="">' . _('Totals') . '</OPTION><OPTION value="all"' . ($_REQUEST['assignment_id'] == 'all' && !UserStudentID() ? ' SELECTED="SELECTED"' : '') . '>' . _('All') . '</OPTION>'; if (UserStudentID() && $_REQUEST['assignment_id'] == 'all') { $assignment_select .= '<OPTION value="all" SELECTED="SELECTED">' . $stu_RET[1]['FULL_NAME'] . '</OPTION>'; } foreach ($assignments_RET as $id => $assignment) { $assignment_select .= '<OPTION value="' . $id . '"' . ($_REQUEST['assignment_id'] == $id ? ' SELECTED="SELECTED"' : '') . '>' . ($_REQUEST['type_id'] ? '' : $types_RET[$assignment[1]['ASSIGNMENT_TYPE_ID']][1]['TITLE'] . ' - ') . $assignment[1]['TITLE'] . '</OPTION>'; } $assignment_select .= '</SELECT>'; echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&student_id=' . UserStudentID() . '" method="POST">'; $tabs = array(array('title' => _('All'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&type_id=" . ($_REQUEST['assignment_id'] == 'all' ? '&assignment_id=all' : '') . (UserStudentID() ? '&student_id=' . UserStudentID() : '') . "&include_inactive={$_REQUEST['include_inactive']}&include_all={$_REQUEST['include_all']}")); foreach ($types_RET as $id => $type) { $tabs[] = array('title' => $type[1]['TITLE'] . ($programconfig[User('STAFF_ID')]['WEIGHT'] == 'Y' ? '|' . number_format(100 * $type[1]['FINAL_GRADE_PERCENT'], 0) . '%' : ''), 'link' => "Modules.php?modname={$_REQUEST['modname']}&type_id={$id}" . ($_REQUEST['assignment_id'] == 'all' ? '&assignment_id=all' : '') . (UserStudentID() ? '&student_id=' . UserStudentID() : '') . "&include_inactive={$_REQUEST['include_inactive']}&include_all={$_REQUEST['include_all']}") + ($type[1]['COLOR'] ? array('color' => $type[1]['COLOR']) : array()); } //modif Francois: add label on checkbox DrawHeader($type_select . $assignment_select, $_REQUEST['assignment_id'] ? SubmitButton(_('Save')) : '', '<label>' . CheckBoxOnclick('include_inactive') . ' ' . _('Include Inactive Students') . '</label> <label>' . CheckBoxOnclick('include_all') . ' ' . _('Include Inactive Assignments') . '</label>'); if ($_REQUEST['assignment_id'] && $_REQUEST['assignment_id'] != 'all') { $assigned_date = $assignments_RET[$_REQUEST['assignment_id']][1]['ASSIGNED_DATE']; $due_date = $assignments_RET[$_REQUEST['assignment_id']][1]['DUE_DATE']; $due = $assignments_RET[$_REQUEST['assignment_id']][1]['DUE']; DrawHeader('<b>' . Localize('colon', _('Assigned Date')) . '</b> ' . ($assigned_date ? ProperDate($assigned_date) : _('N/A')) . ', <b>' . Localize('colon', _('Due Date')) . '</b> ' . ($due_date ? ProperDate($due_date) : _('N/A')) . ($due ? ' - <b>' . _('Assignment is Due') . '</b>' : '')); } if ($_REQUEST['type_id'] && $types_RET[$_REQUEST['type_id']][1]['COLOR']) { $LO_options['header_color'] = $types_RET[$_REQUEST['type_id']][1]['COLOR']; } if (!UserStudentID() && $_REQUEST['assignment_id'] == 'all') { $LO_options['yscroll'] = true; } $LO_options['header'] = WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&type_id=" . ($_REQUEST['type_id'] ? $_REQUEST['type_id'] : ($_REQUEST['assignment_id'] && $_REQUEST['assignment_id'] != 'all' ? $assignments_RET[$_REQUEST['assignment_id']][1]['ASSIGNMENT_TYPE_ID'] : '')) . ($_REQUEST['assignment_id'] == 'all' ? '&assignment_id=all' : '') . (UserStudentID() ? '&student_id=' . UserStudentID() : '') . "&include_inactive={$_REQUEST['include_inactive']}&include_all={$_REQUEST['include_all']}"); ListOutput($stu_RET, $LO_columns, $item, $items, $link, array(), $LO_options); echo $_REQUEST['assignment_id'] ? '<span class="center">' . SubmitButton(_('Save')) . '</span>' : '';
$types += array($menu['TITLE'] => array('DESCRIPTION' => $menu['TITLE'], 'COUNT' => 0, 'AMOUNT' => 0, 'ITEMS' => $items)); } $type_select = _('Type') . '<SELECT name=type_select><OPTION value=\'\'>' . _('Not Specified') . '</OPTION>'; foreach ($types as $short_name => $type) { $type_select .= '<OPTION value=' . $short_name . ($_REQUEST['type_select'] == $short_name ? ' SELECTED' : '') . '>' . $type['DESCRIPTION'] . '</OPTION>'; } $type_select .= '</SELECT>'; $staff_RET = DBGet(DBquery('SELECT STAFF_ID,FIRST_NAME||\' \'||LAST_NAME AS FULL_NAME FROM STAFF WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOLS LIKE \'%,' . UserSchool() . ',%\' AND PROFILE=\'admin\' ORDER BY LAST_NAME')); $staff_select = _('User') . '<SELECT name=staff_select><OPTION value=\'\'>' . _('Not Specified') . '</OPTION>'; foreach ($staff_RET as $staff) { $staff_select .= '<OPTION value=' . $staff['STAFF_ID'] . ($_REQUEST['staff_select'] == $staff['STAFF_ID'] ? ' SELECTED' : '') . '>' . $staff['FULL_NAME'] . '</OPTION>'; } $staff_select .= '</SELECT>'; $PHP_tmp_SELF = PreparePHP_SELF(); echo "<FORM action={$PHP_tmp_SELF} method=POST>"; DrawHeader(PrepareDate($date, '_date') . ' : ' . $type_select . ' : ' . $staff_select . ' : <INPUT type=submit value=' . _('Go') . '>', CheckBoxOnclick('by_name') . _('Sort by Name')); echo '</FORM>'; if ($_REQUEST['type_select']) { $where = "AND fst.SHORT_NAME='" . $_REQUEST['type_select'] . "' "; } if ($_REQUEST['staff_select']) { $where = "AND fst.SELLER_ID='" . $_REQUEST['staff_select'] . "' "; } if ($_REQUEST['detailed_view'] != 'true') { DrawHeader("<A HREF=" . PreparePHP_SELF($_REQUEST, array(), array('detailed_view' => 'true')) . '>' . _('Detailed View') . '</A>'); } else { DrawHeader("<A HREF=" . PreparePHP_SELF($_REQUEST, array(), array('detailed_view' => 'false')) . '>' . _('Original View') . '</A>'); } include 'modules/Food_Service/' . ($_REQUEST['type'] == 'staff' ? 'Users' : 'Students') . '/ActivityReport.php'; //echo '<pre>'; var_dump($RET); echo '</pre>'; //echo '<pre>'; var_dump($types); echo '</pre>';
echo '<FORM name="student" action="Modules.php?modname=' . $_REQUEST['modname'] . '&include=' . $_REQUEST['include'] . '&modfunc=update" method="POST">'; } if ($_REQUEST['student_id'] != 'new') { $name = $student['FIRST_NAME'] . ' ' . $student['MIDDLE_NAME'] . ' ' . $student['LAST_NAME'] . ' ' . $student['NAME_SUFFIX'] . ' - ' . $student['STUDENT_ID']; } DrawHeader($name, SubmitButton(_('Save'))); //modif Francois: Moodle integrator //propose to create student in Moodle: if 1) this is a creation, 2) this is an already created student but not in Moodle yet if (MOODLE_INTEGRATOR && AllowEdit()) { //2) verifiy if the student is in Moodle: $old_student_in_moodle = false; if (!empty($student['STUDENT_ID'])) { $old_student_in_moodle = DBGet(DBQuery("SELECT 1 FROM moodlexrosario WHERE rosario_id='" . $student['STUDENT_ID'] . "' AND \"column\"='student_id'")); } if ($_REQUEST['student_id'] == 'new' || !$old_student_in_moodle) { DrawHeader('<label>' . CheckBoxOnclick('moodle_create_student') . ' ' . _('Create Student in Moodle') . '</label>'); } } foreach ($categories_RET as $category) { if ($can_use_RET['Students/Student.php&category_id=' . $category['ID']]) { if ($category['ID'] == '1') { $include = 'General_Info'; } elseif ($category['ID'] == '3') { $include = 'Address'; } elseif ($category['ID'] == '2') { $include = 'Medical'; } elseif ($category['ID'] == '4') { $include = 'Comments'; } elseif ($category['INCLUDE']) { $include = $category['INCLUDE']; } else {