$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']) {
