} $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');