$assoc_t = 'progress periods '; } else { $assoc_t = 'progress period'; } } else { $get_assoc_rltns = DBGet(DBQuery('SELECT distinct MP_TYPE,COUNT(1) as TYPE_COUNT FROM marking_periods WHERE PARENT_ID=' . $_REQUEST['marking_period_id'])); foreach ($get_assoc_rltns as $gai => $gad) { if ($gad['TYPE_COUNT'] > 1) { $assoc_t[] = $gad['MP_TYPE'] . 's'; } else { $assoc_t[] = $gad['MP_TYPE']; } } $assoc_t = implode(',', $assoc_t); } UnableDeletePromptMod('Marking period cannot be deleted because it has associtation with ' . $assoc_t . '.'); } else { if (DeletePromptMod($name, $queryString)) { 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; $table = $parent_table; } } } unset($_SESSION['_REQUEST_vars']['modfunc']); }
if ($go) { DBQuery($sql); } } } } } } DrawBC("School Setup > " . ProgramTitle()); if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove' && AllowEdit()) { $room_id = paramlib_validation($colmn = PERIOD_ID, $_REQUEST[id]); $has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM course_period_var WHERE room_id='{$room_id}'")); $has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED']; if ($has_assigned > 0) { $qs = 'Modules.php?modname=schoolsetup/Rooms.php'; UnableDeletePromptMod('Cannot delete because room are associated.', 'delete', $qs); } else { $qs = 'Modules.php?modname=schoolsetup/Rooms.php'; if (DeletePromptMod('room', $qs)) { DBQuery("DELETE FROM rooms WHERE room_id='{$room_id}'"); unset($_REQUEST['modfunc']); } } } if ($_REQUEST['modfunc'] != 'remove') { $sql = "SELECT ROOM_ID,TITLE,TITLE as NAME,CAPACITY,DESCRIPTION,SORT_ORDER FROM rooms WHERE school_id='" . UserSchool() . "' ORDER BY sort_order"; $QI = DBQuery($sql); $LO = DBGet(DBQuery($sql)); $room_id_arr = array(); foreach ($LO as $ti => $td) { array_push($room_id_arr, $td[ROOM_ID]);
if ($has_assigned > 0) { UnableDeletePromptMod('Cannot delete becauses this people field is associated.'); } else { if (DeletePromptMod('staff field')) { $id = clean_param($_REQUEST['id'], PARAM_INT); DBQuery('DELETE FROM people_fields WHERE ID=\'' . $id . '\''); DBQuery('ALTER TABLE people DROP COLUMN CUSTOM_' . $id . ''); $_REQUEST['modfunc'] = ''; unset($_REQUEST['id']); } } } elseif (clean_param($_REQUEST['category_id'], PARAM_INT)) { $has_assigned_RET = DBGet(DBQuery('SELECT COUNT(*) AS TOTAL_ASSIGNED FROM people_fields WHERE CATEGORY_ID=\'' . $_REQUEST['category_id'] . '\'')); $has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED']; if ($has_assigned > 0) { UnableDeletePromptMod('Cannot delete becauses this people field category is associated.'); } else { if (DeletePromptMod('staff field category and all fields in the category')) { $fields = DBGet(DBQuery('SELECT ID FROM people_fields WHERE CATEGORY_ID=\'' . $_REQUEST[category_id] . '\'')); foreach ($fields as $field) { DBQuery('DELETE FROM people_fields WHERE ID=\'' . $field[ID] . '\''); DBQuery('ALTER TABLE people DROP COLUMN CUSTOM_' . $field[ID] . ''); } DBQuery('DELETE FROM people_field_categories WHERE ID=\'' . $_REQUEST[category_id] . '\''); // remove from profiles and permissions DBQuery('DELETE FROM profile_exceptions WHERE MODNAME=\'users/User/Student.php&category_id=' . $_REQUEST[category_id] . '\''); $_REQUEST['modfunc'] = ''; unset($_REQUEST['category_id']); } } }
} } } else { $table = 'assignment'; // } // 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) { UnableDeletePromptMod(_('Gradebook Assignment cannot be deleted because grade was given for this assignment.'), '', 'modfunc=&assignment_type_id=' . $_REQUEST['assignment_type_id'] . '&assignment_id=' . $_REQUEST['assignment_id']); } else { if (DeletePromptAssignment($table, $_REQUEST['assignment_type_id'])) { DBQuery('DELETE FROM gradebook_grades WHERE assignment_id=\'' . $_REQUEST['assignment_id'] . '\''); DBQuery('DELETE FROM gradebook_assignments WHERE assignment_id=\'' . $_REQUEST['assignment_id'] . '\''); unset($_REQUEST['assignment_id']); unset($_REQUEST['modfunc']); } } } } unset($_SESSION['_REQUEST_vars']['modfunc']); } if (!$_REQUEST['modfunc'] && $course_id) { // ASSIGNMENT TYPES $sql = ' SELECT ASSIGNMENT_TYPE_ID,TITLE
$queryString = 'category_id=' . $_REQUEST['category_id']; UnableDeletePromptMod($msg, '', $queryString); } else { if ($_REQUEST['id']) { if (DeletePromptCommon('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 ($deletable_category == FALSE) { $msg = 'Cannot delete because student fields are associated.'; $queryString = 'category_id=' . $_REQUEST['category_id']; UnableDeletePromptMod($msg, '', $queryString); } elseif (DeletePromptCommon('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']}"); } DBQuery("DELETE FROM student_field_categories WHERE ID='{$_REQUEST['category_id']}'"); // remove from profiles and permissions DBQuery("DELETE FROM profile_exceptions WHERE MODNAME='students/Student.php&category_id={$_REQUEST['category_id']}'"); $_REQUEST['modfunc'] = ''; unset($_REQUEST['category_id']); } } } }
$parent_table = 'school_semesters'; $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']); $parent_table = 'school_quarters'; 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']; $queryString = "mp_term={$_REQUEST['mp_term']}&year_id={$_REQUEST['year_id']}&semester_id={$_REQUEST['semester_id']}&marking_period_id={$_REQUEST['marking_period_id']}"; if ($has_assigned > 0) { UnableDeletePromptMod(_('Marking period cannot be deleted because course periods are created on this marking period.'), '', $queryString); } else { if (DeletePromptMod($name, $queryString)) { 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; $table = $parent_table; } } unset($_SESSION['_REQUEST_vars']['modfunc']); } if (!$_REQUEST['modfunc']) {