} if ($_REQUEST['tab_id'] != '0' && $_REQUEST['tab_id'] != 'new') { $_REQUEST['tab_id'] = $_REQUEST['course_id']; } $course_RET = DBGet(DBQuery("SELECT TITLE FROM COURSES WHERE COURSE_ID='{$_REQUEST['course_id']}'")); $tabs = array(1 => array('title' => $course_RET[1]['TITLE'], 'link' => "Modules.php?modname={$_REQUEST['modname']}&course_id={$_REQUEST['course_id']}&tab_id={$_REQUEST['course_id']}"), 2 => array('title' => 'All Courses', 'link' => "Modules.php?modname={$_REQUEST['modname']}&course_id={$_REQUEST['course_id']}&tab_id=0"), 3 => array('title' => 'General', 'link' => "Modules.php?modname={$_REQUEST['modname']}&course_id={$_REQUEST['course_id']}&tab_id=new")); if ($_REQUEST['tab_id'] != 'new') { if ($_REQUEST['tab_id']) { $sql = 'SELECT * FROM REPORT_CARD_COMMENTS WHERE COURSE_ID=\'' . $_REQUEST['tab_id'] . '\' ORDER BY SORT_ORDER'; } else { // need to be more specific since course_period_id=0 is not unique $sql = 'SELECT * FROM REPORT_CARD_COMMENTS WHERE COURSE_ID=\'' . $_REQUEST['tab_id'] . '\' AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'; } $functions = array('TITLE' => 'makeCommentsInput', 'SORT_ORDER' => 'makeCommentsInput'); $LO_columns = array('TITLE' => 'Comment', 'SORT_ORDER' => 'Sort Order'); $link['add']['html'] = array('TITLE' => makeCommentsInput('', 'TITLE'), 'SORT_ORDER' => makeCommentsInput('', 'SORT_ORDER')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&table=REPORT_CARD_GRADES"; $link['remove']['variables'] = array('id' => 'ID'); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id={$_REQUEST['tab_id']}"; $link['remove']['variables'] = array('id' => 'ID'); $link['add']['html']['remove'] = button('add'); } else { $sql = 'SELECT * FROM REPORT_CARD_COMMENTS WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' AND COURSE_ID IS NULL ORDER BY SORT_ORDER'; $functions = array('SORT_ORDER' => 'makeTextInput', 'TITLE' => 'makeTextInput'); $LO_columns = array('SORT_ORDER' => 'ID', 'TITLE' => 'Comment'); $link['add']['html'] = array('SORT_ORDER' => makeTextInput('', 'SORT_ORDER'), 'TITLE' => makeTextInput('', 'TITLE')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id=new"; $link['remove']['variables'] = array('id' => 'ID'); $link['add']['html']['remove'] = button('add'); } $LO_ret = DBGet(DBQuery($sql), $functions);
$functions += array('SCALE_ID' => 'makeCommentsInput'); $LO_columns += array('SCALE_ID' => _('Comment Scale')); } $link['add']['html'] = array('TITLE' => makeCommentsInput('', 'TITLE'), 'SHORT_NAME' => makeCommentsInput('', 'SHORT_NAME'), 'COMMENT' => makeCommentsInput('', 'COMMENT'), 'SORT_ORDER' => makeCommentsInput('', 'SORT_ORDER')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id={$_REQUEST['tab_id']}"; $link['remove']['variables'] = array('id' => _('ID')); $link['add']['html']['remove'] = button('add'); if (User('PROFILE') == 'admin') { $tabs[] = array('title' => button('add', '', '', 14), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new"); } $subject = 'Codes'; } else { $sql = 'SELECT * FROM REPORT_CARD_COMMENT_CODE_SCALES WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER,ID'; $functions = array('TITLE' => 'makeTextInput', 'COMMENT' => 'makeTextInput', 'SORT_ORDER' => 'makeTextInput'); $LO_columns = array('TITLE' => _('Comment Scale'), 'COMMENT' => _('Comment'), 'SORT_ORDER' => _('Sort Order')); $link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'COMMENT' => makeTextInput('', 'COMMENT'), 'HHR_GPA_VALUE' => makeCommentsInput('', 'HHR_GPA_VALUE'), 'HR_GPA_VALUE' => makeCommentsInput('', 'HR_GPA_VALUE'), 'SORT_ORDER' => makeTextInput('', 'SORT_ORDER')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id=new"; $link['remove']['variables'] = array('id' => _('ID')); $link['add']['html']['remove'] = button('add'); $tabs[] = array('title' => button('add', '', '', 14), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new"); $subject = 'Comment Code Scales'; } $LO_ret = DBGet(DBQuery($sql), $functions); echo '<FORM action="Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=update&tab_id=' . $_REQUEST['tab_id'] . '" method="POST">'; DrawHeader('', SubmitButton(_('Save'))); echo '<BR />'; //modif Francois: fix SQL bug invalid sort order if (isset($error)) { echo $error; } $LO_options = array('save' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}"));