}
}
$table .= '</TD>
</TR>
<TR>
<TD colspan="2" class="center"><span style="color:gray">' . sprintf(_('GPA based on a scale of %d'), $SCALE_RET[1]['REPORTING_GP_SCALE']) . '</span></TD>
</TR>' . '</TABLE></TD><TD style="width:350px;">' . _('GPA calculation modifies existing records.') . '<BR /><BR />' . _('Weighted and unweighted GPA is calculated by dividing the weighted and unweighted grade points configured for each letter grade (assigned in the Report Card Codes setup program) by the base grading scale specified in the school setup.') . ' </TD></TR></TABLE>';
$go = Prompt(_('GPA Calculation'), _('Calculate GPA and Class Rank'), $table);
if ($go) {
//modif Francois: waiting message
echo '<BR />';
PopTable('header', _('Calculating GPA and class rank'));
echo '<span class="center"><DIV id="statusDIV"><IMG SRC="assets/spinning.gif"> ' . _('Calculating ...') . ' </DIV></span>';
PopTable('footer');
ob_flush();
flush();
//modif Francois: no time limit for this script!
set_time_limit(0);
DBQuery("SELECT calc_cum_gpa_mp('" . $_REQUEST['marking_period_id'] . "')");
DBQuery("SELECT set_class_rank_mp('" . $_REQUEST['marking_period_id'] . "')");
//modif Francois: remove STUDENT_GPA_CALCULATED table
//DBQuery("UPDATE STUDENT_GPA_CALCULATED SET CLASS_RANK='$rank' WHERE STUDENT_ID='$student[STUDENT_ID]' AND MARKING_PERIOD_ID='".$_REQUEST['marking_period_id']."'");
unset($_REQUEST['delete_ok']);
//modif Francois: ending message
//modif Francois: bugfix addHTML is not defined
//echo '<script type="text/javascript">addHTML("'.str_replace('"','\"','<IMG SRC="assets/check.png" class="alignImg" /> '.str_replace(array("'",'"'),array(''','”'),sprintf(_('GPA and class rank for %s has been calculated.'),GetMP($_REQUEST['marking_period_id'])))).'","statusDIV",true);';
echo '<script type="text/javascript">document.getElementById("statusDIV").innerHTML = "' . str_replace('"', '\\"', '<IMG SRC="assets/check.png" class="alignImg" /> ' . str_replace(array("'", '"'), array(''', '”'), sprintf(_('GPA and class rank for %s has been calculated.'), GetMP($_REQUEST['marking_period_id'])))) . '";';
echo '</script>';
ob_end_flush();
Prompt(_('GPA Calculation'), _('Calculate GPA and Class Rank'), $table);
}
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#**************************************************************************
DrawBC("Users >> " . ProgramTitle());
include 'Menu.php';
if ($_REQUEST['profile_id'] != '') {
$exceptions_RET = DBGet(DBQuery("SELECT PROFILE_ID,MODNAME,CAN_USE,CAN_EDIT FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='{$_REQUEST['profile_id']}'"), array(), array('MODNAME'));
$profile_RET = DBGet(DBQuery("SELECT PROFILE FROM USER_PROFILES WHERE ID='{$_REQUEST['profile_id']}'"));
$xprofile = $profile_RET[1]['PROFILE'];
if ($xprofile == 'student') {
$xprofile = 'parent';
unset($menu['Users']);
}
}
if ($_REQUEST['modfunc'] == 'delete' && AllowEdit()) {
$profile_RET = DBGet(DBQuery("SELECT TITLE FROM USER_PROFILES WHERE ID='{$_REQUEST['profile_id']}'"));
if (Prompt('Confirm Delete', 'Are you sure you want to delete the user profile <i>' . $profile_RET[1]['TITLE'] . '</i>?', 'Users of that profile will retain their permissions as a custom set which can be modified on a per-user basis through the User Permissions program.')) {
DBQuery("DELETE FROM USER_PROFILES WHERE ID='" . $_REQUEST['profile_id'] . "'");
DBQuery("DELETE FROM STAFF_EXCEPTIONS WHERE USER_ID IN (SELECT STAFF_ID FROM STAFF WHERE PROFILE_ID='" . $_REQUEST['profile_id'] . "')");
DBQuery("INSERT INTO STAFF_EXCEPTIONS (USER_ID,MODNAME,CAN_USE,CAN_EDIT) SELECT s.STAFF_ID,e.MODNAME,e.CAN_USE,e.CAN_EDIT FROM STAFF s,PROFILE_EXCEPTIONS e WHERE s.PROFILE_ID='{$_REQUEST['profile_id']}' AND s.PROFILE_ID=e.PROFILE_ID");
DBQuery("DELETE FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='" . $_REQUEST['profile_id'] . "'");
unset($_REQUEST['modfunc']);
unset($_REQUEST['profile_id']);
}
}
if ($_REQUEST['modfunc'] == 'update' && AllowEdit() && !$_REQUEST['new_profile_title']) {
$tmp_menu = $menuprof;
$categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM STUDENT_FIELD_CATEGORIES"));
foreach ($categories_RET as $category) {
$file = 'Students/Student.php&category_id=' . $category['ID'];
$tmp_menu['Students'][$xprofile][$file] = ' › ' . $category['TITLE'];
}
<?php
DrawHeader(ProgramTitle());
$message = '<TABLE><TR><TD colspan=7 align=center>From' . PrepareDate(DBDate(), '_min') . ' to ' . PrepareDate(DBDate(), '_max') . '</TD></TR></TABLE>';
if (Prompt('Confirm', 'When do you want to recalculate the daily attendance?', $message)) {
$current_RET = DBGet(DBQuery("SELECT DISTINCT to_char(SCHOOL_DATE,'dd-MON-yy') as SCHOOL_DATE FROM ATTENDANCE_CALENDAR WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "'"), array(), array('SCHOOL_DATE'));
$students_RET = GetStuList();
$begin = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_min'], 'to_num'), $_REQUEST['day_min'] * 1, $_REQUEST['year_min']) + 43200;
$end = mktime(0, 0, 0, MonthNWSwitch($_REQUEST['month_max'], 'to_num'), $_REQUEST['day_max'] * 1, $_REQUEST['year_max']) + 43200;
for ($i = $begin; $i <= $end; $i += 86400) {
if ($current_RET[strtoupper(date('d-M-y', $i))]) {
foreach ($students_RET as $student) {
UpdateAttendanceDaily($student['STUDENT_ID'], date('d-M-y', $i));
}
}
}
unset($_REQUEST['modfunc']);
DrawHeader('<IMG SRC=assets/check.gif> ' . _('The Daily Attendance for that timeframe has been recalculated.'));
}
<?php
$tables = array('SCHOOL_PERIODS' => _('School Periods'), 'SCHOOL_MARKING_PERIODS' => _('Marking Periods'), 'REPORT_CARD_GRADES' => _('Report Card Grade Codes'), 'REPORT_CARD_COMMENTS' => _('Report Card Comment Codes'), 'ELIGIBILITY_ACTIVITIES' => _('Eligibility Activity Codes'), 'ATTENDANCE_CODES' => _('Attendance Codes'), 'SCHOOL_GRADELEVELS' => _('Grade Levels'));
$table_list = '<TABLE align=left>';
foreach ($tables as $table => $name) {
$table_list .= '<TR><TD><INPUT type=checkbox value=Y name=tables[' . $table . '] CHECKED></TD><TD>' . $name . '</TD></TR>';
}
$table_list .= '</TABLE></CENTER><BR><small>' . _('New School\'s Title') . '</small> <INPUT type=text name=title value="' . _('New School') . '"><CENTER>';
DrawHeader(ProgramTitle());
if (Prompt(_('Confirm Copy School'), sprintf(_('Are you sure you want to copy the data for %s to a new school?'), GetSchool(UserSchool())), $table_list)) {
if (count($_REQUEST['tables'])) {
$id = DBGet(DBQuery("SELECT " . db_seq_nextval('SCHOOLS_SEQ') . " AS ID" . FROM_DUAL));
$id = $id[1]['ID'];
DBQuery("INSERT INTO SCHOOLS (ID,SYEAR,TITLE) values('{$id}','" . UserSyear() . "','" . str_replace("\\'", "''", $_REQUEST['title']) . "')");
DBQuery("UPDATE STAFF SET SCHOOLS=rtrim(SCHOOLS,',')||',{$id},' WHERE STAFF_ID='" . User('STAFF_ID') . "' AND SCHOOLS IS NOT NULL");
foreach ($_REQUEST['tables'] as $table => $value) {
_rollover($table);
}
}
echo '<FORM action=Modules.php?modname=' . $_REQUEST['modname'] . ' method=POST>';
echo '<script language=JavaScript>parent.side.location="' . $_SESSION['Side_PHP_SELF'] . '?modcat="+parent.side.document.forms[0].modcat.value;</script>';
DrawHeader('<IMG SRC=assets/check.gif>' . sprintf(_('The data have been copied to a new school called "%s".'), $_REQUEST['title']), '<INPUT type=submit value="' . _('OK') . '>"');
echo '</FORM>';
unset($_SESSION['_REQUEST_vars']['tables']);
unset($_SESSION['_REQUEST_vars']['delete_ok']);
}
function _rollover($table)
{
global $id;
switch ($table) {
case 'SCHOOL_PERIODS':
DBQuery("SELECT SET_CLASS_RANK_MP('" . $_REQUEST['marking_period_id'] . "')");
//DBQuery("DELETE FROM STUDENT_GPA_CALCULATED WHERE MARKING_PERIOD_ID='".$_REQUEST['marking_period_id']."'");
// DBQuery("INSERT INTO STUDENT_GPA_CALCULATED
// (STUDENT_ID,MARKING_PERIOD_ID,WEIGHTED_GPA,GPA)
// SELECT sgr.STUDENT_ID,sgr.MARKING_PERIOD_ID,sgr.GPA_POINTS_WEIGHTED/sgr.DIVISOR/'$_REQUEST[weight]',
// sgr.GPA_POINTS/sgr.DIVISOR FROM STUDENT_GPA_RUNNING sgr,STUDENT_ENROLLMENT ssm
// WHERE
// sgr.STUDENT_ID=ssm.STUDENT_ID AND (('".DBDate()."' BETWEEN ssm.START_DATE AND ssm.END_DATE OR ssm.END_DATE IS NULL) AND '".DBDate()."'>=ssm.START_DATE)
// AND ssm.SYEAR='".UserSyear()."' AND sgr.MARKING_PERIOD_ID='".$_REQUEST['marking_period_id']."' AND ssm.SCHOOL_ID='".UserSchool()."'
// ");
// $gpa_RET = DBGet(DBQuery("SELECT sgc.STUDENT_ID,ssm.GRADE_ID,sgc.$_REQUEST[rank] AS CUM_GPA FROM STUDENT_GPA_CALCULATED sgc,STUDENT_ENROLLMENT ssm WHERE sgc.STUDENT_ID=ssm.STUDENT_ID AND ssm.SCHOOL_ID='".UserSchool()."' AND ssm.SYEAR='".UserSyear()."' AND (('".DBDate()."' BETWEEN ssm.START_DATE AND ssm.END_DATE OR ssm.END_DATE IS NULL) AND '".DBDate()."'>=ssm.START_DATE) ORDER BY sgc.$_REQUEST[rank] DESC"),array(),array('GRADE_ID'));
// if(count($gpa_RET))
// {
// foreach($gpa_RET as $grade)
// {
// $i = 0;
// foreach($grade as $student)
// {
// $i++;
// if($prev_gpa!=$student['CUM_GPA'])
// $rank = $i;
//
// DBQuery("UPDATE STUDENT_GPA_CALCULATED SET CLASS_RANK='$rank' WHERE STUDENT_ID='$student[STUDENT_ID]' AND MARKING_PERIOD_ID='".$_REQUEST['marking_period_id']."'");
// $prev_gpa = $student['CUM_GPA'];
// }
// }
// }
unset($_REQUEST['delete_ok']);
DrawHeader('<table><tr><td><IMG SRC=assets/check.gif></td><td>GPA and class rank for ' . GetMP($_REQUEST['marking_period_id']) . ' has been calculated.</td></tr></table>');
Prompt('GPA Calculation', 'Calculate GPA and Class Rank', $table);
}
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#**************************************************************************
DrawBC("Gradebook > " . ProgramTitle());
$mps = GetAllMP('PRO', UserMP());
$mps = explode(',', str_replace("'", '', $mps));
$message = '<TABLE><TR><TD colspan=7 align=center>';
foreach ($mps as $mp) {
if ($mp && $mp != '0') {
$message .= '<INPUT type=radio name=marking_period_id value=' . $mp . ($mp == UserMP() ? ' CHECKED' : '') . '>' . GetMP($mp) . '<BR>';
}
}
$message .= '</TD></TR></TABLE>';
$go = Prompt('Confirm', 'When do you want to recalculate the running GPA numbers?', $message);
// Ritwik
if ($go) {
$students_RET = GetStuList($extra);
DBQuery("SELECT calc_cum_gpa_mp('" . $_REQUEST['marking_period_id'] . "')");
// Ritwik
DBQuery("SELECT set_class_rank_mp('" . $_REQUEST['marking_period_id'] . "')");
// Ritwik
unset($_REQUEST['modfunc']);
DrawHeader('<IMG SRC=assets/check.gif> The grades for ' . GetMP($_REQUEST['marking_period_id']) . ' has been recalculated.');
// Ritwik
Prompt('Confirm', 'When do you want to recalculate the running GPA numbers?', $message);
}
if (strpos($existing['DAYS'], $i) !== false) {
$days_conflict = true;
break 2;
}
}
}
}
if ($days_conflict) {
$warnings[] = 'There is already a course scheduled in that period.';
}
if (!$warnings) {
DBQuery("INSERT INTO SCHEDULE (SYEAR,SCHOOL_ID,STUDENT_ID,START_DATE,COURSE_ID,COURSE_PERIOD_ID,MP,MARKING_PERIOD_ID) values('" . UserSyear() . "','" . UserSchool() . "','" . UserStudentID() . "','" . $date . "','" . $_REQUEST['course_id'] . "','" . $_REQUEST['course_period_id'] . "','" . $mp_RET[1]['MP'] . "','" . $mp_RET[1]['MARKING_PERIOD_ID'] . "')");
DBQuery("UPDATE COURSE_PERIODS SET FILLED_SEATS=FILLED_SEATS+1 WHERE COURSE_PERIOD_ID='" . $_REQUEST['course_period_id'] . "'");
echo "<script language=javascript>opener.document.location = 'Modules.php?modname=" . $_REQUEST['modname'] . "&time=" . time() . "'; window.close();</script>";
} elseif ($warnings) {
if (Prompt('Confirm', 'There is a conflict. Are you sure you want to add this section?', ErrorMessage($warnings, 'note'))) {
DBQuery("INSERT INTO SCHEDULE (SYEAR,SCHOOL_ID,STUDENT_ID,START_DATE,COURSE_ID,COURSE_PERIOD_ID,MP,MARKING_PERIOD_ID) values('" . UserSyear() . "','" . UserSchool() . "','" . UserStudentID() . "','" . $date . "','" . $_REQUEST['course_id'] . "','" . $_REQUEST['course_period_id'] . "','" . $mp_RET[1]['MP'] . "','" . $mp_RET[1]['MARKING_PERIOD_ID'] . "')");
DBQuery("UPDATE COURSE_PERIODS SET FILLED_SEATS=FILLED_SEATS+1 WHERE COURSE_PERIOD_ID='" . $_REQUEST['course_period_id'] . "'");
echo "<script language=javascript>opener.document.location = 'Modules.php?modname=" . $_REQUEST['modname'] . "&time=" . time() . "'; window.close();</script>";
}
}
}
}
function _makeTitle($value, $column = '')
{
global $_CENTRE, $THIS_RET;
return $value;
//.' - '.$THIS_RET['COURSE_WEIGHT'];
}
function _makeLock($value, $column)
{
foreach (_str_split($mp_RET[1]['DAYS']) as $i) {
if (mb_strpos($existing['DAYS'], $i) !== false) {
$days_conflict = true;
break 2;
}
}
}
}
if ($days_conflict) {
$warnings[] = _('There is already a course scheduled in that period.');
}
if (!$warnings) {
DBQuery("INSERT INTO SCHEDULE (SYEAR,SCHOOL_ID,STUDENT_ID,START_DATE,COURSE_ID,COURSE_PERIOD_ID,MP,MARKING_PERIOD_ID) values('" . UserSyear() . "','" . UserSchool() . "','" . UserStudentID() . "','" . $date . "','" . $_REQUEST['course_id'] . "','" . $_REQUEST['course_period_id'] . "','" . $mp_RET[1]['MP'] . "','" . $mp_RET[1]['MARKING_PERIOD_ID'] . "')");
echo '<script type="text/javascript">opener.document.location="Modules.php?modname=' . $_REQUEST['modname'] . '&year_date=' . $_REQUEST['year_date'] . '&month_date=' . $_REQUEST['month_date'] . '&day_date=' . $_REQUEST['day_date'] . '&time=' . time() . '"; window.close();</script>';
} elseif ($warnings) {
if (Prompt(_('Confirm'), _('There is a conflict.') . ' ' . _('Are you sure you want to add this section?'), ErrorMessage($warnings, 'note'))) {
DBQuery("INSERT INTO SCHEDULE (SYEAR,SCHOOL_ID,STUDENT_ID,START_DATE,COURSE_ID,COURSE_PERIOD_ID,MP,MARKING_PERIOD_ID) values('" . UserSyear() . "','" . UserSchool() . "','" . UserStudentID() . "','" . $date . "','" . $_REQUEST['course_id'] . "','" . $_REQUEST['course_period_id'] . "','" . $mp_RET[1]['MP'] . "','" . $mp_RET[1]['MARKING_PERIOD_ID'] . "')");
echo '<script type="text/javascript">opener.document.location="Modules.php?modname=' . $_REQUEST['modname'] . '&year_date=' . $_REQUEST['year_date'] . '&month_date=' . $_REQUEST['month_date'] . '&day_date=' . $_REQUEST['day_date'] . '&time=' . time() . '"; window.close();</script>';
}
}
}
}
function _makeTitle($value, $column)
{
global $THIS_RET;
//modif Francois: add subject areas
return CourseTitle($value);
}
function _makeLock($value, $column)
{
global $THIS_RET;
if ($_REQUEST['calendar_id'] && $title['CALENDAR_ID'] == $_REQUEST['calendar_id']) {
$message .= '<OPTION value="' . $title['CALENDAR_ID'] . '" selected>' . $title['TITLE'] . (AllowEdit() && $title['DEFAULT_CALENDAR'] == 'Y' ? ' (' . _('Default') . ')' : '');
$default_id = $id;
$prompt = $title['TITLE'];
} else {
$message .= '<OPTION value="' . $title['CALENDAR_ID'] . '">' . ($title['SCHOOL_ID'] != UserSchool() ? $title['SCHOOL_TITLE'] . ':' : '') . $title['TITLE'] . (AllowEdit() && $title['DEFAULT_CALENDAR'] == 'Y' ? ' (' . _('Default') . ')' : '');
}
}
$message .= '</SELECT>';
//modif Francois: add <label> on checkbox
$message = '<TABLE><TR><TD colspan="7" class="center"><table><tr><td>' . NoInput('<INPUT type="text" name="title"' . ($_REQUEST['calendar_id'] ? ' value="' . $title_RET[$default_id]['TITLE'] . '"' : '') . '>', _('Title')) . '</td><td><label>' . NoInput('<INPUT type="checkbox" name="default" value="Y"' . ($_REQUEST['calendar_id'] && $title_RET[$default_id]['DEFAULT_CALENDAR'] == 'Y' ? ' checked' : '') . '>') . ' ' . _('Default Calendar for this School') . '</label></td><td>' . NoInput($message, _('Copy Calendar')) . '</td></tr></table></TD></TR>';
$message .= '<TR><TD colspan="7" class="center"><table><tr><td>' . _('From') . ' ' . NoInput(PrepareDate($_REQUEST['calendar_id'] && $title_RET[$default_id]['START_DATE'] ? $title_RET[$default_id]['START_DATE'] : $fy_RET['START_DATE'], '_min')) . '</td><td>' . _('To') . ' ' . NoInput(PrepareDate($_REQUEST['calendar_id'] && $title_RET[$default_id]['END_DATE'] ? $title_RET[$default_id]['END_DATE'] : $fy_RET['END_DATE'], '_max')) . '</td></tr></table></TD></TR>';
$message .= '<TR><TD><label>' . NoInput('<INPUT type="checkbox" value="Y" name="weekdays[0]"' . ($_REQUEST['calendar_id'] ? ' checked' : '') . '>') . ' ' . _('Sunday') . '</label></TD><TD><label>' . NoInput('<INPUT type="checkbox" value="Y" name="weekdays[1]" checked />') . ' ' . _('Monday') . '</label></TD><TD><label>' . NoInput('<INPUT type="checkbox" value="Y" name="weekdays[2]" checked />') . ' ' . _('Tuesday') . '</label></TD><TD><label>' . NoInput('<INPUT type="checkbox" value="Y" name="weekdays[3]" checked />') . ' ' . _('Wednesday') . '</label></TD><TD><label>' . NoInput('<INPUT type="checkbox" value="Y" name="weekdays[4]" checked />') . ' ' . _('Thursday') . '</label></TD><TD><label>' . NoInput('<INPUT type="checkbox" value="Y" name="weekdays[5]" checked />') . ' ' . _('Friday') . '<label></TD><TD><label>' . NoInput('<INPUT type="checkbox" value="Y" name="weekdays[6]"' . ($_REQUEST['calendar_id'] ? ' checked' : '') . '>') . ' ' . _('Saturday') . '</label></TD></TR>';
$message .= '<TR><TD colspan="7" class="center"><table><tr><td>' . NoInput('<INPUT type="text" name="minutes" size="3" maxlength="3">', _('Minutes')) . '</td><td><span class="legend-gray">(' . ($_REQUEST['calendar_id'] ? _('Default is Full Day if Copy Calendar is N/A.') . '<BR />' . _('Otherwise Default is minutes from the Copy Calendar') : _('Default is Full Day')) . ')</span></td></tr></table></TD></TR>';
$message .= '</TABLE>';
if (Prompt($_REQUEST['calendar_id'] ? sprintf(_('Recreate %s calendar'), $prompt) : _('Create new calendar'), '', $message)) {
if ($_REQUEST['calendar_id']) {
$calendar_id = $_REQUEST['calendar_id'];
} else {
$calendar_id = DBGet(DBQuery("SELECT " . db_seq_nextval('CALENDARS_SEQ') . " AS CALENDAR_ID " . FROM_DUAL));
$calendar_id = $calendar_id[1]['CALENDAR_ID'];
}
if ($_REQUEST['default']) {
DBQuery("UPDATE ATTENDANCE_CALENDARS SET DEFAULT_CALENDAR=NULL WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'");
}
if ($_REQUEST['calendar_id']) {
DBQuery("UPDATE ATTENDANCE_CALENDARS SET TITLE='" . $_REQUEST['title'] . "',DEFAULT_CALENDAR='" . $_REQUEST['default'] . "' WHERE CALENDAR_ID='" . $calendar_id . "'");
} else {
DBQuery("INSERT INTO ATTENDANCE_CALENDARS (CALENDAR_ID,SYEAR,SCHOOL_ID,TITLE,DEFAULT_CALENDAR) values('" . $calendar_id . "','" . UserSyear() . "','" . UserSchool() . "','" . $_REQUEST['title'] . "','" . $_REQUEST['default'] . "')");
}
if ($_REQUEST['copy_id']) {
DrawHeader(ProgramTitle());
include 'Menu.php';
if ($_REQUEST['profile_id'] != '') {
$exceptions_RET = DBGet(DBQuery("SELECT PROFILE_ID,MODNAME,CAN_USE,CAN_EDIT FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='{$_REQUEST['profile_id']}'"), array(), array('MODNAME'));
$profile_RET = DBGet(DBQuery("SELECT PROFILE FROM USER_PROFILES WHERE ID='{$_REQUEST['profile_id']}'"));
$xprofile = $profile_RET[1]['PROFILE'];
if ($xprofile == 'student') {
$xprofile = 'parent';
//modif Francois: enable password change for students
//unset($menu['Users']);
unset($menu['Users']['parent']['Users/User.php']);
}
}
if ($_REQUEST['modfunc'] == 'delete' && AllowEdit()) {
$profile_RET = DBGet(DBQuery("SELECT TITLE FROM USER_PROFILES WHERE ID='{$_REQUEST['profile_id']}'"));
if (Prompt(_('Confirm Delete'), sprintf(_('Are you sure you want to delete the user profile <i>%s</i>?'), $profile_RET[1]['TITLE']), sprintf(_('Users of that profile will retain their permissions as a custom set which can be modified on a per-user basis through %s.'), _('User Permissions')))) {
DBQuery("DELETE FROM USER_PROFILES WHERE ID='" . $_REQUEST['profile_id'] . "'");
DBQuery("DELETE FROM STAFF_EXCEPTIONS WHERE USER_ID IN (SELECT STAFF_ID FROM STAFF WHERE PROFILE_ID='" . $_REQUEST['profile_id'] . "')");
DBQuery("INSERT INTO STAFF_EXCEPTIONS (USER_ID,MODNAME,CAN_USE,CAN_EDIT) SELECT s.STAFF_ID,e.MODNAME,e.CAN_USE,e.CAN_EDIT FROM STAFF s,PROFILE_EXCEPTIONS e WHERE s.PROFILE_ID='{$_REQUEST['profile_id']}' AND s.PROFILE_ID=e.PROFILE_ID");
DBQuery("DELETE FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='" . $_REQUEST['profile_id'] . "'");
unset($_REQUEST['modfunc']);
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_REQUEST['profile_id']);
unset($_SESSION['_REQUEST_vars']['profile_id']);
}
}
if ($_REQUEST['modfunc'] == 'update' && !$_REQUEST['new_profile_title'] && AllowEdit()) {
$tmp_menu = $menu;
$categories_RET = DBGet(DBQuery("SELECT ID,TITLE FROM STUDENT_FIELD_CATEGORIES"));
foreach ($categories_RET as $category) {
$file = 'Students/Student.php&category_id=' . $category['ID'];
if ($table != 'FOOD_SERVICE_STAFF_ACCOUNTS') {
$exists_RET[$table] = DBGet(DBQuery("SELECT count(*) AS COUNT FROM {$table} WHERE SYEAR='{$next_syear}'" . (!$no_school_tables[$table] ? " AND SCHOOL_ID='" . UserSchool() . "'" : '')));
} else {
$exists_RET['FOOD_SERVICE_STAFF_ACCOUNTS'] = DBGet(DBQuery("SELECT count(*) AS COUNT FROM STAFF WHERE SYEAR='{$next_syear}' AND exists(SELECT * FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=STAFF.STAFF_ID)"));
}
if ($exists_RET[$table][1]['COUNT'] > 0) {
//modif Francois: add <label> on checkbox
$table_list .= '<TR><TD><label><INPUT type="checkbox" value="Y" name="tables[' . $table . ']"><span style="color:grey"> ' . $name . ' (' . $exists_RET[$table][1]['COUNT'] . ')</span></label></TD></TR>';
} else {
$table_list .= '<TR><TD><label><INPUT type="checkbox" value="Y" name="tables[' . $table . ']" checked /> ' . $name . '</label></TD></TR>';
}
}
$table_list .= '</TABLE><BR />' . '* ' . _('You <i>must</i> roll users, school periods, marking periods, calendars, attendance codes, and report card codes at the same time or before rolling courses.') . '<BR /><BR />* ' . _('You <i>must</i> roll enrollment codes at the same time or before rolling students.') . '<BR /><BR />* ' . _('You <i>must</i> roll courses at the same time or before rolling report card comments.') . '<BR /><BR />' . _('Greyed items have already have data in the next school year (They might have been rolled).') . '<BR /><BR />' . _('Rolling greyed items will delete already existing data in the next school year.');
DrawHeader(ProgramTitle());
//modif Francois: school year over one/two calendar years format
if (Prompt(_('Confirm') . ' ' . _('Rollover'), sprintf(_('Are you sure you want to roll the data for %s to the next school year?'), FormatSyear(UserSyear(), Config('SCHOOL_SYEAR_OVER_2_YEARS'))), $table_list)) {
if ($_REQUEST['tables']['COURSES'] && (!$_REQUEST['tables']['STAFF'] && $exists_RET['STAFF'][1]['COUNT'] < 1 || !$_REQUEST['tables']['SCHOOL_PERIODS'] && $exists_RET['SCHOOL_PERIODS'][1]['COUNT'] < 1 || !$_REQUEST['tables']['SCHOOL_MARKING_PERIODS'] && $exists_RET['SCHOOL_MARKING_PERIODS'][1]['COUNT'] < 1 || !$_REQUEST['tables']['ATTENDANCE_CALENDARS'] && $exists_RET['ATTENDANCE_CALENDARS'][1]['COUNT'] < 1 || !$_REQUEST['tables']['REPORT_CARD_GRADES'] && $exists_RET['REPORT_CARD_GRADES'][1]['COUNT'] < 1)) {
BackPrompt(_('You <i>must</i> roll users, school periods, marking periods, calendars, and report card codes at the same time or before rolling courses.'));
}
if ($_REQUEST['tables']['REPORT_CARD_COMMENTS'] && (!$_REQUEST['tables']['COURSES'] && $exists_RET['COURSES'][1]['COUNT'] < 1)) {
BackPrompt(_('You <i>must</i> roll courses at the same time or before rolling report card comments.'));
}
if (count($_REQUEST['tables'])) {
foreach ($_REQUEST['tables'] as $table => $value) {
//if($exists_RET[$table][1]['COUNT']>0)
// DBQuery("DELETE FROM $table WHERE SYEAR='".$next_syear."'".(!$no_school_tables[$table]?" AND SCHOOL_ID='".UserSchool()."'":''));
Rollover($table);
}
}
echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '" method="POST">';
// DrawHeader('<IMG SRC=assets/check.png>'._('The data have been rolled.'),'<INPUT type=submit value="'._('OK').'">');
$table_list = '<TABLE align=left>';
foreach ($tables as $table => $name) {
if ($table != 'FOOD_SERVICE_STAFF_ACCOUNTS') {
$exists_RET[$table] = DBGet(DBQuery("SELECT count(*) AS COUNT FROM {$table} WHERE SYEAR='{$next_syear}'" . (!$no_school_tables[$table] ? " AND SCHOOL_ID='" . UserSchool() . "'" : '')));
} else {
$exists_RET['FOOD_SERVICE_STAFF_ACCOUNTS'] = DBGet(DBQuery("SELECT count(*) AS COUNT FROM STAFF WHERE SYEAR='{$next_syear}' AND exists(SELECT * FROM FOOD_SERVICE_STAFF_ACCOUNTS WHERE STAFF_ID=STAFF.STAFF_ID)"));
}
if ($exists_RET[$table][1]['COUNT'] > 0) {
$table_list .= '<TR><TD><INPUT type=checkbox value=Y name=tables[' . $table . ']></TD><TD><font color=grey>' . $name . ' (' . $exists_RET[$table][1]['COUNT'] . ')</font></TD></TR>';
} else {
$table_list .= '<TR><TD><INPUT type=checkbox value=Y name=tables[' . $table . '] CHECKED></TD><TD>' . $name . '</TD></TR>';
}
}
$table_list .= '</TABLE></CENTER><BR><small>' . '* ' . _('You <i>must</i> roll users, school periods, marking periods, calendars, attendance codes, and report card codes at the same time or before rolling courses.') . '<BR><BR>* ' . _('You <i>must</i> roll enrollment codes at the same time or before rolling students.') . '<BR><BR>* ' . _('You <i>must</i> roll courses at the same time or before rolling report card comments.') . '<BR><BR>' . _('Greyed items have already have data in the next school year (They might have been rolled).') . '<BR><BR>' . _('Rolling greyed items will delete already existing data in the next school year.') . '</small><CENTER>';
DrawHeader(ProgramTitle());
if (Prompt('Confirm Rollover', sprintf(_('Are you sure you want to roll the data for %d-%d to the next school year?'), UserSyear(), UserSyear() + 1), $table_list)) {
if ($_REQUEST['tables']['COURSES'] && (!$_REQUEST['tables']['STAFF'] && $exists_RET['STAFF'][1]['COUNT'] < 1 || !$_REQUEST['tables']['SCHOOL_PERIODS'] && $exists_RET['SCHOOL_PERIODS'][1]['COUNT'] < 1 || !$_REQUEST['tables']['SCHOOL_MARKING_PERIODS'] && $exists_RET['SCHOOL_MARKING_PERIODS'][1]['COUNT'] < 1 || !$_REQUEST['tables']['ATTENDANCE_CALENDARS'] && $exists_RET['ATTENDANCE_CALENDARS'][1]['COUNT'] < 1 || !$_REQUEST['tables']['REPORT_CARD_GRADES'] && $exists_RET['REPORT_CARD_GRADES'][1]['COUNT'] < 1)) {
BackPrompt(_('You <i>must</i> roll users, school periods, marking periods, calendars, and report card codes at the same time or before rolling courses.'));
}
if ($_REQUEST['tables']['REPORT_CARD_COMMENTS'] && (!$_REQUEST['tables']['COURSES'] && $exists_RET['COURSES'][1]['COUNT'] < 1)) {
BackPrompt(_('You <i>must</i> roll courses at the same time or before rolling report card comments.'));
}
if (count($_REQUEST['tables'])) {
foreach ($_REQUEST['tables'] as $table => $value) {
//if($exists_RET[$table][1]['COUNT']>0)
// DBQuery("DELETE FROM $table WHERE SYEAR='".$next_syear."'".(!$no_school_tables[$table]?" AND SCHOOL_ID='".UserSchool()."'":''));
Rollover($table);
}
}
echo '<FORM action=Modules.php?modname=' . $_REQUEST['modname'] . ' method=POST>';
DrawHeader('<IMG SRC=assets/check.gif>' . _('The data have been rolled.'), '<INPUT type=submit value="' . _('OK') . '">');
