}
}
}
}
if ($err) {
echo '<font style="color:red"><b>' . $err . '</b></font>';
}
}
DrawBC("" . _('School Setup') . " > " . ProgramTitle());
#echo "Modules.php?modname=$_REQUEST[modname]";
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove' && AllowEdit()) {
$prd_id = paramlib_validation($colmn = PERIOD_ID, $_REQUEST[id]);
$has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM course_periods WHERE PERIOD_ID=\'' . $prd_id . '\''));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt(_('Cannot delete because course periods are created on this period.'));
} else {
if (DeletePrompt_Period(_('period'))) {
DBQuery('DELETE FROM school_periods WHERE PERIOD_ID=\'' . $prd_id . '\'');
unset($_REQUEST['modfunc']);
}
}
}
if ($_REQUEST['modfunc'] != 'remove') {
#$sql = "SELECT PERIOD_ID,TITLE,SHORT_NAME,SORT_ORDER,LENGTH,START_TIME,END_TIME,BLOCK,ATTENDANCE FROM school_periods WHERE SYEAR='".UserSyear()."' AND SCHOOL_ID='".UserSchool()."' ORDER BY SORT_ORDER";
$sql = 'SELECT PERIOD_ID,TITLE,SHORT_NAME,SORT_ORDER,LENGTH,START_TIME,END_TIME,ATTENDANCE,IGNORE_SCHEDULING FROM school_periods WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER';
$QI = DBQuery($sql);
#$periods_RET = DBGet($QI,array('TITLE'=>'_makeTextInput','SHORT_NAME'=>'_makeTextInput','SORT_ORDER'=>'_makeTextInputMod','BLOCK'=>'_makeTextInput','LENGTH'=>'_makeTextInputMod','START_TIME'=>'_makeTimeInput','END_TIME'=>'_makeTimeInputEnd','ATTENDANCE'=>'_makeCheckboxInput'));
#$periods_RET = DBGet($QI,array('TITLE'=>'_makeTextInput','SHORT_NAME'=>'_makeTextInput','SORT_ORDER'=>'_makeTextInputMod','BLOCK'=>'_makeTextInput','LENGTH'=>'LENGTH','START_TIME'=>'_makeTimeInput','END_TIME'=>'_makeTimeInputEnd','ATTENDANCE'=>'_makeCheckboxInput'));
$periods_RET = DBGet($QI, array('TITLE' => '_makeTextInput', 'SHORT_NAME' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInputMod', 'LENGTH' => 'LENGTH', 'START_TIME' => '_makeTimeInput', 'END_TIME' => '_makeTimeInputEnd', 'ATTENDANCE' => '_makeCheckboxInput', 'IGNORE_SCHEDULING' => '_makeCheckboxInput'));
#$columns = array('TITLE'=>'Title','SHORT_NAME'=>'Short Name','SORT_ORDER'=>'Sort Order','START_TIME'=>'Start Time','END_TIME'=>'End Time','LENGTH'=>'Length (minutes)','IGNORE_SCHEDULING'=>'Block','ATTENDANCE'=>'Used for Attendance');
/////For deleting schedule
if ($_REQUEST['del'] == 'true') {
$association_query_reportcard = DBQuery('Select * from student_report_card_grades where student_id=\'' . UserStudentId() . '\' and course_period_id=\'' . $_REQUEST['cp_id'] . '\'');
$association_query_grade = DBQuery('Select * from gradebook_grades where student_id=\'' . UserStudentId() . '\' and course_period_id=\'' . $_REQUEST['cp_id'] . '\' ');
$association_query_attendance = DBQuery('Select * from attendance_period where student_id=\'' . UserStudentId() . '\' and course_period_id=\'' . $_REQUEST['cp_id'] . '\' ');
$schedule_data = DBGet(DBQuery('Select * from schedule where student_id=\'' . UserStudentId() . '\' and course_period_id=\'' . $_REQUEST['cp_id'] . '\' and syear =' . UserSyear() . ' '));
if (mysql_num_rows($association_query_grade) > 0 || mysql_num_rows($association_query_attendance) > 0 || mysql_num_rows($association_query_reportcard) > 0) {
UnableDeletePrompt('Cannot delete because students attendance are already taken.');
unset($_REQUEST['del']);
unset($_REQUEST['c_id']);
} elseif (mysql_num_rows($association_query_grade) > 0) {
UnableDeletePrompt('Cannot delete because assignments grading are already given.');
unset($_REQUEST['del']);
unset($_REQUEST['c_id']);
} elseif (mysql_num_rows($association_query_reportcard) > 0) {
UnableDeletePrompt('Cannot delete because final grade is already given .');
unset($_REQUEST['del']);
unset($_REQUEST['c_id']);
} else {
if (DeletePromptMod('schedule')) {
$schedule_fetch = DBGet(DBQuery('SELECT DROPPED FROM schedule WHERE ID=\'' . $_REQUEST['schedule_id'] . '\''));
$schedule_status = $schedule_fetch[1]['DROPPED'];
$seat_query = DBQuery('SELECT FILLED_SEATS FROM course_periods WHERE COURSE_ID=\'' . $_REQUEST['c_id'] . '\' AND COURSE_PERIOD_ID=\'' . $_REQUEST['cp_id'] . '\' ');
$seat_fetch = DBGet($seat_query);
if ($schedule_status == 'Y') {
$seat_fill = $seat_fetch[1]['FILLED_SEATS'];
}
if ($schedule_status == 'N') {
$seat_fill = $seat_fetch[1]['FILLED_SEATS'] - 1;
}
DBQuery('Delete from schedule where student_id=\'' . UserStudentId() . '\' and course_period_id=\'' . $_REQUEST['cp_id'] . '\' and course_id=\'' . $_REQUEST['c_id'] . '\' and id=\'' . $_REQUEST['schedule_id'] . '\'');
} else {
echo "<font color='red'><b>" . _('Unable to save data, because Special Charecters do not allow in Category Title') . "</b></font>";
}
// possible modification end
}
//if($_REQUEST['modfunc']=='remove')
if (optional_param('modfunc', '', PARAM_ALPHA) == 'remove') {
if ($_REQUEST['id']) {
//$has_assigned_RET=DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM attendance_period WHERE ATTENDANCE_CODE='$_REQUEST[id]'"));
$has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM attendance_period WHERE ATTENDANCE_CODE=\'' . optional_param('id', '', PARAM_INT) . '\''));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
} else {
$has_assigned = 0;
}
if ($has_assigned > 0) {
UnableDeletePrompt('' . _('Cannot delete because attendance codes are associated.') . '');
} else {
if ($_REQUEST['id']) {
if (DeletePromptCommon('attendance code')) {
//DBQuery("DELETE FROM attendance_codes WHERE ID='$_REQUEST[id]'");
DBQuery('DELETE FROM attendance_codes WHERE ID=\'' . optional_param('id', '', PARAM_INT) . '\'');
unset($_REQUEST['modfunc']);
}
} elseif ($_REQUEST['table']) {
if (DeletePromptCommon('category')) {
DBQuery('DELETE FROM attendance_code_categories WHERE ID=\'' . $_REQUEST[table] . '\'');
unset($_REQUEST['modfunc']);
$_REQUEST['table'] = '0';
}
}
}
DrawBC("Students > " . ProgramTitle());
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
$select_enroll = DBGet(DBQuery('SELECT TYPE FROM student_enrollment_codes WHERE ID=\'' . $_REQUEST[id] . '\''));
if ($select_enroll[1][TYPE] != 'Roll' && $select_enroll[1][TYPE] != 'TrnD' && $select_enroll[1][TYPE] != 'TrnE') {
$has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM student_enrollment WHERE ENROLLMENT_CODE=\'' . $_REQUEST[id] . '\''));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt('Cannot delete because enrollment codes are associated.');
} else {
if (DeletePromptMod('enrollment code', $_REQUEST['modname'])) {
DBQuery('DELETE FROM student_enrollment_codes WHERE ID=\'' . $_REQUEST[id] . '\'');
unset($_REQUEST['modfunc']);
}
}
} else {
UnableDeletePrompt('Cannot delete because it is not deletable.');
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = 'SELECT ID,TITLE,SHORT_NAME,TYPE FROM student_enrollment_codes WHERE SYEAR=\'' . UserSyear() . '\' ORDER BY TITLE';
$QI = DBQuery($sql);
$codes_RET = DBGet($QI, array('TITLE' => 'makeTextInput', 'SHORT_NAME' => 'makeTextInput', 'TYPE' => 'makeSelectInput'));
$columns = array('TITLE' => 'Title', 'SHORT_NAME' => 'Short Name', 'TYPE' => 'Type');
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'SHORT_NAME' => makeTextInput('', 'SHORT_NAME'), 'TYPE' => makeSelectInput('', 'TYPE'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID');
echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
ListOutput($codes_RET, $columns, 'Enrollment Code', 'Enrollment Codes', $link);
foreach ($codes_RET as $ci => $cd) {
$id_arr[$cd['ID']] = $cd['ID'];
}
}
}
$sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')';
if ($go) {
DBQuery($sql);
}
}
}
}
DrawBC("Eligibility > " . ProgramTitle());
//if($_REQUEST['modfunc']=='remove')
if (optional_param('modfunc', '', PARAM_NOTAGS) == 'remove') {
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM STUDENT_ELIGIBILITY_ACTIVITIES WHERE ACTIVITY_ID='{$_REQUEST['id']}'"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt('Cannot delete because eligibility activities are associated.');
} else {
if (DeletePrompt('activity')) {
DBQuery("DELETE FROM ELIGIBILITY_ACTIVITIES WHERE ID='{$_REQUEST['id']}'");
unset($_REQUEST['modfunc']);
}
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = "SELECT ID,TITLE,START_DATE,END_DATE FROM ELIGIBILITY_ACTIVITIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY TITLE";
$QI = DBQuery($sql);
$activities_RET = DBGet($QI, array('TITLE' => 'makeTextInput', 'START_DATE' => 'makeDateInput', 'END_DATE' => 'makeDateInput'));
$columns = array('TITLE' => 'Title', 'START_DATE' => 'Begins', 'END_DATE' => 'Ends');
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'START_DATE' => makeDateInput('', 'START_DATE'), 'END_DATE' => makeDateInput('', 'END_DATE'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID');
DBQuery($sql);
}
}
}
}
}
}
}
}
DrawBC("School Setup > " . ProgramTitle());
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
$grd_id = paramlib_validation($colmn = PERIOD_ID, $_REQUEST[id]);
$has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM student_enrollment WHERE GRADE_ID=\'' . $grd_id . '\''));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt('Cannot delete because grade levels are associated.');
} else {
if (DeletePrompt_GradeLevel('grade level')) {
DBQuery("DELETE FROM school_gradelevels WHERE ID='{$grd_id}'");
DBQuery('UPDATE school_gradelevels SET NEXT_GRADE_ID=NUll WHERE NEXT_GRADE_ID=' . $grd_id);
unset($_REQUEST['modfunc']);
}
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = 'SELECT ID,TITLE,SHORT_NAME,SORT_ORDER,NEXT_GRADE_ID FROM school_gradelevels WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER';
$QI = DBQuery($sql);
$LO = DBGet(DBQuery($sql));
$grade_id_arr = array();
foreach ($LO as $ti => $td) {
array_push($grade_id_arr, $td[ID]);
}
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'delete_calendar') {
$colmn = Calender_Id;
$cal_title = paramlib_validation($colmn, $_REQUEST[calendar_id]);
$has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM student_enrollment WHERE CALENDAR_ID=' . $cal_title . ''));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned == 0) {
$has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM course_periods WHERE CALENDAR_ID=' . $cal_title . ''));
$has_assigned_cp = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
}
//$calendar_id = DBGet(DBQuery("SELECT ".db_seq_nextval('CALENDARS_SEQ')." AS CALENDAR_ID ".FROM_DUAL));
if ($has_assigned > 0) {
UnableDeletePrompt('Cannot delete because students are enrolled in this calendar.');
} elseif ($has_assigned_cp > 0) {
UnableDeletePrompt('Cannot delete because course periods are created on this calendar.');
} else {
if (DeletePromptCommon('calendar')) {
DBQuery('DELETE FROM attendance_calendar WHERE CALENDAR_ID=' . $cal_title . '');
DBQuery('DELETE FROM school_calendars WHERE CALENDAR_ID=' . $cal_title . '');
$default_RET = DBGet(DBQuery('SELECT CALENDAR_ID FROM school_calendars WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' AND DEFAULT_CALENDAR=\'Y\''));
if (count($default_RET)) {
$_REQUEST['calendar_id'] = $default_RET[1]['CALENDAR_ID'];
} else {
$calendars_RET = DBGet(DBQuery('SELECT CALENDAR_ID FROM school_calendars WHERE SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
if (count($calendars_RET)) {
$_REQUEST['calendar_id'] = $calendars_RET[1]['CALENDAR_ID'];
} else {
$error = array('There are no calendars yet setup.');
}
}
unset($_REQUEST['assignment_id']);
}*/
unset($_REQUEST['modfunc']);
}
}
if ($_REQUEST['assignment_id']) {
include "classes/db/db.mysqli.class.php";
$stmt = $mysqli->prepare("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM GRADEBOOK_GRADES WHERE assignment_id=" . $_REQUEST['assignment_id']);
#$stmt->bind_param("i",$marking_period_id); //binding name as string
#$marking_period_id = $courses[$key]['MARKING_PERIOD_ID'];
$stmt->execute();
$has_assigned = 0;
$stmt->bind_result($has_assigned);
$stmt->fetch();
if ($has_assigned > 0) {
UnableDeletePrompt('Gradebook Assignment cannot be deleted because it has other associations.');
} else {
if (DeletePromptAssignment($table, $_REQUEST['assignment_type_id'])) {
DBQuery($sql);
DBQuery("DELETE FROM GRADEBOOK_GRADES WHERE assignment_id='{$_REQUEST['assignment_id']}'");
unset($_REQUEST['assignment_id']);
unset($_REQUEST['modfunc']);
}
}
}
}
if (!$_REQUEST['modfunc'] && $course_id) {
// ASSIGNMENT TYPES
$sql = " SELECT distinct gat.ASSIGNMENT_TYPE_ID,gat.TITLE FROM COURSE_DETAILS cd , GRADEBOOK_ASSIGNMENT_TYPES gat where cd.COURSE_ID=gat.COURSE_ID and (cd.TEACHER_ID='" . User('STAFF_ID') . "' OR cd.SECONDARY_TEACHER_ID='" . User('STAFF_ID') . "')AND cd.COURSE_PERIOD_ID='" . $course_period_id . "' ORDER BY TITLE";
$QI = DBQuery($sql);
$types_RET = DBGet($QI);
$cal_title = paramlib_validation($col, $_REQUEST['title']);
DBQuery("INSERT INTO ATTENDANCE_CALENDARS (SYEAR,SCHOOL_ID,TITLE,DEFAULT_CALENDAR) values('" . UserSyear() . "','" . UserSchool() . "','" . $cal_title . "','" . $_REQUEST['default'] . "')");
$_REQUEST['calendar_id'] = $calendar_id;
unset($_REQUEST['modfunc']);
unset($_SESSION['_REQUEST_vars']['modfunc']);
unset($_SESSION['_REQUEST_vars']['weekdays']);
unset($_SESSION['_REQUEST_vars']['title']);
}
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'delete_calendar') {
$colmn = Calender_Id;
$cal_title = paramlib_validation($colmn, $_REQUEST[calendar_id]);
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM STUDENT_ENROLLMENT WHERE CALENDAR_ID='{$cal_title}'"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt('Cannot delete because calendars are associated.');
} else {
if (DeletePrompt('calendar')) {
DBQuery("DELETE FROM ATTENDANCE_CALENDAR WHERE CALENDAR_ID='{$cal_title}'");
DBQuery("DELETE FROM ATTENDANCE_CALENDARS WHERE CALENDAR_ID='{$cal_title}'");
$default_RET = DBGet(DBQuery("SELECT CALENDAR_ID FROM ATTENDANCE_CALENDARS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND DEFAULT_CALENDAR='Y'"));
if (count($default_RET)) {
$_REQUEST['calendar_id'] = $default_RET[1]['CALENDAR_ID'];
} else {
$calendars_RET = DBGet(DBQuery("SELECT CALENDAR_ID FROM ATTENDANCE_CALENDARS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"));
if (count($calendars_RET)) {
$_REQUEST['calendar_id'] = $calendars_RET[1]['CALENDAR_ID'];
} else {
$error = array('There are no calendars yet setup.');
}
}
$go = true;
}
}
$sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')';
if ($go) {
DBQuery($sql);
}
}
}
}
DrawBC("Students > " . ProgramTitle());
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM STUDENT_ENROLLMENT WHERE ENROLLMENT_CODE='{$_REQUEST['id']}'"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt('Cannot delete because enrollment codes are associated.');
} else {
if (DeletePrompt('enrollment code')) {
DBQuery("DELETE FROM STUDENT_ENROLLMENT_CODES WHERE ID='{$_REQUEST['id']}'");
unset($_REQUEST['modfunc']);
}
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = "SELECT ID,TITLE,SHORT_NAME,TYPE FROM STUDENT_ENROLLMENT_CODES WHERE SYEAR='" . UserSyear() . "' ORDER BY TITLE";
$QI = DBQuery($sql);
$codes_RET = DBGet($QI, array('TITLE' => 'makeTextInput', 'SHORT_NAME' => 'makeTextInput', 'TYPE' => 'makeSelectInput'));
$columns = array('TITLE' => 'Title', 'SHORT_NAME' => 'Short Name', 'TYPE' => 'Type');
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'SHORT_NAME' => makeTextInput('', 'SHORT_NAME'), 'TYPE' => makeSelectInput('', 'TYPE'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
// $link['remove']['link'] = "#"." onclick='check_content(\"ajax.php?modname=$_REQUEST[modname]&modfunc=remove\");'";
$sql_up = "update SCHOOL_PERIODS set length = " . $length . " where period_id='{$period_id}' and syear='" . UserSyear() . "' and school_id='" . UserSchool() . "'";
$res_up = mysql_query($sql_up);
# -------------------------------------------------------------------------- #
}
}
}
}
}
DrawBC("School Setup > " . ProgramTitle());
#echo "Modules.php?modname=$_REQUEST[modname]";
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove' && AllowEdit()) {
$prd_id = paramlib_validation($colmn = PERIOD_ID, $_REQUEST[id]);
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM COURSE_PERIODS WHERE PERIOD_ID='{$prd_id}'"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt('Cannot delete because periods are associated.');
} else {
if (DeletePrompt_Period('period')) {
DBQuery("DELETE FROM SCHOOL_PERIODS WHERE PERIOD_ID='{$prd_id}'");
unset($_REQUEST['modfunc']);
}
}
}
if ($_REQUEST['modfunc'] != 'remove') {
#$sql = "SELECT PERIOD_ID,TITLE,SHORT_NAME,SORT_ORDER,LENGTH,START_TIME,END_TIME,BLOCK,ATTENDANCE FROM SCHOOL_PERIODS WHERE SYEAR='".UserSyear()."' AND SCHOOL_ID='".UserSchool()."' ORDER BY SORT_ORDER";
$sql = "SELECT PERIOD_ID,TITLE,SHORT_NAME,SORT_ORDER,LENGTH,START_TIME,END_TIME,ATTENDANCE,IGNORE_SCHEDULING FROM SCHOOL_PERIODS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY SORT_ORDER";
$QI = DBQuery($sql);
#$periods_RET = DBGet($QI,array('TITLE'=>'_makeTextInput','SHORT_NAME'=>'_makeTextInput','SORT_ORDER'=>'_makeTextInputMod','BLOCK'=>'_makeTextInput','LENGTH'=>'_makeTextInputMod','START_TIME'=>'_makeTimeInput','END_TIME'=>'_makeTimeInputEnd','ATTENDANCE'=>'_makeCheckboxInput'));
#$periods_RET = DBGet($QI,array('TITLE'=>'_makeTextInput','SHORT_NAME'=>'_makeTextInput','SORT_ORDER'=>'_makeTextInputMod','BLOCK'=>'_makeTextInput','LENGTH'=>'LENGTH','START_TIME'=>'_makeTimeInput','END_TIME'=>'_makeTimeInputEnd','ATTENDANCE'=>'_makeCheckboxInput'));
$periods_RET = DBGet($QI, array('TITLE' => '_makeTextInput', 'SHORT_NAME' => '_makeTextInput', 'SORT_ORDER' => '_makeTextInputMod', 'LENGTH' => 'LENGTH', 'START_TIME' => '_makeTimeInput', 'END_TIME' => '_makeTimeInputEnd', 'ATTENDANCE' => '_makeCheckboxInput', 'IGNORE_SCHEDULING' => '_makeCheckboxInput'));
#$columns = array('TITLE'=>'Title','SHORT_NAME'=>'Short Name','SORT_ORDER'=>'Sort Order','START_TIME'=>'Start Time','END_TIME'=>'End Time','LENGTH'=>'Length (minutes)','IGNORE_SCHEDULING'=>'Block','ATTENDANCE'=>'Used for Attendance');
unset($_REQUEST['tables']);
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'delete') {
if (clean_param($_REQUEST['id'], PARAM_INT)) {
$sc_cus_fld_column = 'CUSTOM_' . $_REQUEST['id'];
$chk_sch_cus = DBGet(DBQuery('SELECT ' . $sc_cus_fld_column . ' as CUSTOM FROM schools WHERE id=' . UserSchool() . ' and SYEAR=' . UserSyear()));
if ($chk_sch_cus[1]['CUSTOM'] == '') {
if (DeletePromptCommon('school field')) {
$id = clean_param($_REQUEST['id'], PARAM_INT);
DBQuery('DELETE FROM school_custom_fields WHERE ID=\'' . $id . '\'');
DBQuery('ALTER TABLE schools DROP COLUMN CUSTOM_' . $id . '');
$_REQUEST['modfunc'] = '';
unset($_REQUEST['id']);
}
} else {
UnableDeletePrompt('Cannot delete because school fields are associated');
}
}
}
if ($_REQUEST['id'] && $_REQUEST['id'] != 'new') {
$sql = "SELECT CATEGORY_ID,TITLE,TYPE,SELECT_OPTIONS,DEFAULT_SELECTION,SORT_ORDER,REQUIRED,REQUIRED,HIDE FROM school_custom_fields WHERE ID='{$_REQUEST['id']}'";
$RET = DBGet(DBQuery($sql));
$RET = $RET[1];
$title = $RET['TITLE'];
} elseif ($_REQUEST['id'] == 'new') {
$title = 'New School Field';
}
if ($_REQUEST['id'] && !$_REQUEST['modfunc']) {
if ($_REQUEST['id'] != 'new') {
$delete_button = "<INPUT type=button value=Delete class=btn_medium onClick='javascript:window.location=\"Modules.php?modname={$_REQUEST['modname']}&modfunc=delete&id={$_REQUEST['id']}\"'>" . " ";
}
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'delete') {
if ($_REQUEST['id']) {
$id = $_REQUEST['id'];
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(CUSTOM_{$id}) AS TOTAL_ASSIGNED FROM STUDENTS"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
$msg = 'Cannot delete because student fields are associated.';
} else {
if ($_REQUEST['category_id'] == 5) {
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM GOAL"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
$msg = 'Cannot delete because field categories are associated.';
}
}
if ($has_assigned > 0) {
UnableDeletePrompt($msg);
} else {
if ($_REQUEST['id']) {
if (DeletePrompt('student field')) {
$id = $_REQUEST['id'];
DBQuery("DELETE FROM CUSTOM_FIELDS WHERE ID='{$id}'");
DBQuery("ALTER TABLE STUDENTS DROP COLUMN CUSTOM_{$id}");
$_REQUEST['modfunc'] = '';
unset($_REQUEST['id']);
}
} elseif ($_REQUEST['category_id']) {
if (DeletePrompt('student field category and all fields in the category')) {
$fields = DBGet(DBQuery("SELECT ID FROM CUSTOM_FIELDS WHERE SYSTEM_FIELD='N' AND CATEGORY_ID='{$_REQUEST['category_id']}'"));
foreach ($fields as $field) {
DBQuery("DELETE FROM CUSTOM_FIELDS WHERE ID='{$field['ID']}'");
DBQuery("ALTER TABLE STUDENTS DROP COLUMN CUSTOM_{$field['ID']}");
$schedule_data = DBGet(DBQuery('Select * from schedule where student_id=\'' . UserStudentId() . '\' and course_period_id=\'' . $_REQUEST['cp_id'] . '\' and syear =' . UserSyear() . ' '));
echo mysql_num_rows($association_query_reportcard);
//exit;
$a_attn = count(DBGet($association_query_attendance));
$a_grd = count(DBGet($association_query_grade));
$a_rpt = count(DBGet($association_query_reportcard));
if ($a_grd > 0) {
UnableDeletePrompt('Cannot delete because assignments grading are already given.');
unset($_REQUEST['del']);
unset($_REQUEST['c_id']);
} elseif ($a_rpt > 0) {
UnableDeletePrompt('Cannot delete because final grade is already given .');
unset($_REQUEST['del']);
unset($_REQUEST['c_id']);
} elseif ($a_attn > 0 || $a_grd > 0 || $a_rpt > 0) {
UnableDeletePrompt('Cannot delete because students attendance are already taken.');
unset($_REQUEST['del']);
unset($_REQUEST['c_id']);
} else {
if (DeletePromptMod('schedule')) {
$schedule_fetch = DBGet(DBQuery('SELECT DROPPED FROM schedule WHERE ID=\'' . $_REQUEST['schedule_id'] . '\''));
$schedule_status = $schedule_fetch[1]['DROPPED'];
$seat_query = DBQuery('SELECT FILLED_SEATS FROM course_periods WHERE COURSE_ID=\'' . $_REQUEST['c_id'] . '\' AND COURSE_PERIOD_ID=\'' . $_REQUEST['cp_id'] . '\' ');
$seat_fetch = DBGet($seat_query);
if ($schedule_status == 'Y') {
$seat_fill = $seat_fetch[1]['FILLED_SEATS'];
}
if ($schedule_status == 'N') {
$seat_fill = $seat_fetch[1]['FILLED_SEATS'] - 1;
}
DBQuery('Delete from schedule where student_id=\'' . UserStudentId() . '\' and course_period_id=\'' . $_REQUEST['cp_id'] . '\' and course_id=\'' . $_REQUEST['c_id'] . '\' and id=\'' . $_REQUEST['schedule_id'] . '\'');
$name = 'quarter';
$parent_term = 'SEM';
$parent_id = paramlib_validation($column = MARKING_PERIOD_ID, $_REQUEST['semester_id']);
$qrt_id = paramlib_validation($column = MARKING_PERIOD_ID, $_REQUEST[marking_period_id]);
$extra[] = "DELETE FROM SCHOOL_PROGRESS_PERIODS WHERE QUARTER_ID='{$qrt_id}'";
break;
case 'SCHOOL_PROGRESS_PERIODS':
$name = 'progress period';
$parent_term = 'QTR';
$parent_id = paramlib_validation($column = MARKING_PERIOD_ID, $_REQUEST['quarter_id']);
break;
}
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM COURSE_DETAILS WHERE MARKING_PERIOD_ID='" . paramlib_validation($column = MARKING_PERIOD_ID, $_REQUEST[marking_period_id]) . "' OR MARKING_PERIOD_ID IN(SELECT MARKING_PERIOD_ID FROM MARKING_PERIODS WHERE PARENT_ID='" . paramlib_validation($column = MARKING_PERIOD_ID, $_REQUEST[marking_period_id]) . "')"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePrompt('Marking period cannot be deleted because it has other associations.');
} else {
if (DeletePrompt($name)) {
foreach ($extra as $sql) {
DBQuery($sql);
}
DBQuery("DELETE FROM {$table} WHERE MARKING_PERIOD_ID='" . paramlib_validation($column = MARKING_PERIOD_ID, $_REQUEST[marking_period_id]) . "'");
unset($_REQUEST['modfunc']);
$_REQUEST['mp_term'] = $parent_term;
$_REQUEST['marking_period_id'] = $parent_id;
}
}
unset($_SESSION['_REQUEST_vars']['modfunc']);
}
if (!$_REQUEST['modfunc']) {
if ($_REQUEST['marking_period_id'] != 'new') {
