}
$sql .= '(' . substr($fields, 0, -1) . ') values( ' . substr($values, 0, -1) . ' )';
if ($go) {
DBQuery($sql);
}
}
}
}
}
unset($_REQUEST['modfunc']);
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM STUDENT_REPORT_CARD_COMMENTS WHERE REPORT_CARD_COMMENT_ID='{$_REQUEST['id']}'"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePromptX('Cannot delete because report card comments are associated.');
} else {
if ($_REQUEST['tab_id'] != 'new') {
if (DeletePromptX('Report Card Comment')) {
DBQuery("DELETE FROM REPORT_CARD_COMMENTS WHERE ID='{$_REQUEST['id']}'");
}
} else {
if (DeletePromptX('Report Card Comment')) {
DBQuery("DELETE FROM REPORT_CARD_COMMENTS WHERE ID='{$_REQUEST['id']}'");
}
}
}
}
if (!$_REQUEST['modfunc']) {
if (User('PROFILE') == 'admin') {
$courses_RET = DBGet(DBQuery("SELECT TITLE,COURSE_ID FROM COURSES WHERE SCHOOL_ID='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' AND COURSE_ID IN (SELECT DISTINCT COURSE_ID FROM COURSE_PERIODS WHERE GRADE_SCALE_ID IS NOT NULL) ORDER BY TITLE"));
}
}
}
}
unset($_REQUEST['modfunc']);
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
if ($_REQUEST['tab_id'] != 'new') {
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM STUDENT_REPORT_CARD_GRADES WHERE REPORT_CARD_GRADE_ID='{$_REQUEST['id']}'"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
} else {
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM STUDENT_REPORT_CARD_GRADES WHERE REPORT_CARD_GRADE_ID IN ( SELECT ID FROM REPORT_CARD_GRADES WHERE GRADE_SCALE_ID ='{$_REQUEST['id']}')"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
}
if ($has_assigned > 0) {
UnableDeletePromptX('Cannot delete because student grades are associated.');
} else {
if ($_REQUEST['tab_id'] != 'new') {
if (DeletePromptX('Report Card Grade')) {
DBQuery("DELETE FROM REPORT_CARD_GRADES WHERE ID='{$_REQUEST['id']}'");
}
} else {
if (DeletePromptX('Report Card Grading Scale')) {
DBQuery("DELETE FROM REPORT_CARD_GRADES WHERE GRADE_SCALE_ID='{$_REQUEST['id']}'");
DBQuery("DELETE FROM REPORT_CARD_GRADE_SCALES WHERE ID='{$_REQUEST['id']}'");
unset($_SESSION['GR_scale_id']);
}
}
}
}
if (!$_REQUEST['modfunc']) {
}
}
$sql .= '(' . substr($fields, 0, -1) . ') values(' . substr($values, 0, -1) . ')';
if ($go) {
DBQuery($sql);
}
}
}
}
unset($_REQUEST['modfunc']);
}
if (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
$has_assigned_RET = DBGet(DBQuery("SELECT COUNT(*) AS TOTAL_ASSIGNED FROM student_standards WHERE grade_id={$_REQUEST['id']}"));
$has_assigned = $has_assigned_RET[1]['TOTAL_ASSIGNED'];
if ($has_assigned > 0) {
UnableDeletePromptX('Cannot delete because standard grade is associated.');
} else {
if (DeletePromptX('Standard Grade')) {
DBQuery("DELETE FROM standard_grades WHERE ID='{$_REQUEST['id']}'");
unset($_SESSION['GR_scale_id']);
}
}
}
if (!$_REQUEST['modfunc']) {
$sql = "SELECT ID,GRADE,DESCRIPTION,SORT_ORDER FROM standard_grades WHERE school_id='" . UserSchool() . "' AND SYEAR='" . UserSyear() . "' ORDER BY sort_order,grade";
$functions = array('GRADE' => '_makeTextInput', 'DESCRIPTION' => '_makeTextInput', 'SORT_ORDER' => '_makeIntInput');
$LO_columns = array('GRADE' => 'Grade', 'DESCRIPTION' => 'Description', 'SORT_ORDER' => 'Order');
$link['add']['html'] = array('GRADE' => _makeTextInput('', 'GRADE'), 'DESCRIPTION' => _makeTextInput('', 'DESCRIPTION'), 'SORT_ORDER' => _makeTextInput('', 'SORT_ORDER'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID');
$link['add']['html']['remove'] = button('add');
