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