<?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 {
