function generateClassForm()
{
echo "<form method=\"GET\" action=\"classes.php\">";
// Radio buttons to choose what to search for
makeRadioButtons("selectMode", array("className", "repeatedOn", "instructor.name"));
echo " ";
// Allow user to type in a string to compare to
makeTextInput("select", "Search...");
// Choose which attributes to project from query
echo "<br>Display:";
makeCheckbox("activity_ID", 1);
echo "Activity ID";
makeCheckbox("name", 1);
echo "Name";
makeCheckbox("day", 1);
echo "Start Date";
makeCheckbox("start_time", 1, TRUE);
echo "Start Time";
makeCheckbox("end_time", 1, TRUE);
echo "End Time";
makeCheckbox("repeatedOn", 1);
echo "Repeats On";
makeCheckbox("NumOfSessions", 1);
echo "#ofSessions";
makeCheckbox("roomNum", 1);
echo "Room";
makeCheckbox("maxSize", 1);
echo "Max Size";
makeCheckbox("price", 1);
echo "Price";
makeCheckbox("teaches.name", 1);
echo "Instructor";
echo "<br>";
echo "<input class=\"pure-button\"type=\"submit\" value=\"Filter\"></form>";
}
$functions += array('GRADE_SCALE_ID' => 'makeGradesInput');
$LO_columns += array('GRADE_SCALE_ID' => 'Grade Scale');
}
$link['add']['html'] = array('TITLE' => makeGradesInput('', 'TITLE'), 'BREAK_OFF' => makeGradesInput('', 'BREAK_OFF'), 'GPA_VALUE' => makeGradesInput('', 'GPA_VALUE'), 'SORT_ORDER' => makeGradesInput('', 'SORT_ORDER'), 'COMMENT' => makeGradesInput('', 'COMMENT'));
$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'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
}
} else {
//BJJ modifications to $functions array and $LO_columns array to handle scale value GP_SCALE
$sql = 'SELECT * FROM REPORT_CARD_GRADE_SCALES WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER,ID';
$functions = array('TITLE' => 'makeTextInput', 'GP_SCALE' => 'makeTextInput', 'COMMENT' => 'makeTextInput', 'SORT_ORDER' => 'makeTextInput');
$LO_columns = array('TITLE' => 'Gradescale', 'GP_SCALE' => 'Scale Value', 'COMMENT' => 'Comment', 'SORT_ORDER' => 'Sort Order');
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'), 'COMMENT' => makeTextInput('', 'COMMENT'), '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('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
}
$LO_ret = DBGet(DBQuery($sql), $functions);
echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&tab_id={$_REQUEST['tab_id']} method=POST>";
#DrawHeader('',SubmitButton('Save'));
echo '<BR>';
echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}") . '</CENTER>';
PopTable_wo_header('header');
ListOutputMod($LO_ret, $LO_columns, '', '', $link, array(), array('count' => false, 'download' => false, 'search' => false));
echo '<BR>';
echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_grade_grade();"') . '</CENTER>';
PopTable('footer');
} else {
if (DeletePromptMod('enrollment code', $_REQUEST['modname'])) {
DBQuery('DELETE FROM student_enrollment_codes WHERE ID=\'' . $_REQUEST[id] . '\'');
unset($_REQUEST['modfunc']);
}
}
} else {
UnableDeletePrompt('Cannot delete because it is not deletable.');
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = 'SELECT ID,TITLE,SHORT_NAME,TYPE FROM student_enrollment_codes WHERE SYEAR=\'' . UserSyear() . '\' ORDER BY TITLE';
$QI = DBQuery($sql);
$codes_RET = DBGet($QI, array('TITLE' => 'makeTextInput', 'SHORT_NAME' => 'makeTextInput', 'TYPE' => 'makeSelectInput'));
$columns = array('TITLE' => 'Title', 'SHORT_NAME' => 'Short Name', 'TYPE' => 'Type');
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'SHORT_NAME' => makeTextInput('', 'SHORT_NAME'), 'TYPE' => makeSelectInput('', 'TYPE'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID');
echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
ListOutput($codes_RET, $columns, 'Enrollment Code', 'Enrollment Codes', $link);
foreach ($codes_RET as $ci => $cd) {
$id_arr[$cd['ID']] = $cd['ID'];
}
if (count($id_arr) > 0) {
$id_arr = implode(',', $id_arr);
} else {
$id_arr = 0;
}
echo '<input type=hidden id=id_arr value="' . $id_arr . '" />';
echo '<br /><CENTER>' . SubmitButton('Save', '', 'class=btn_medium onClick=formcheck_enrollment_code();') . '</CENTER>';
echo '</FORM>';
// 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);
echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&course_id={$_REQUEST['course_id']}&tab_id={$_REQUEST['tab_id']} method=POST>";
DrawHeaderHome($course_select, SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_grade_comment();"'));
#echo '<BR>';
echo '<style type="text/css">#div_margin { margin-top:-20px; _margin-top:-1px; }</style>';
echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&course_id={$_REQUEST['course_id']}&tab_id={$_REQUEST['tab_id']}") . '</CENTER>';
echo '<div id="div_margin">';
PopTable_wo_header('header');
echo "<table width=300px height=120px><tr><td>";
//hack for an empty poptable
ListOutputMod($LO_ret, $LO_columns, '', '', $link, array(), array('count' => false, 'download' => false, 'search' => false));
}
unset($_REQUEST['modfunc']);
}
if ($_REQUEST['modfunc'] == 'remove') {
if (DeletePromptX('History Marking Period')) {
DBQuery('DELETE FROM history_marking_periods WHERE MARKING_PERIOD_ID=\'' . $_REQUEST['id'] . '\'');
}
}
if (!$_REQUEST['modfunc']) {
echo "<FORM action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=update&tab_id=" . strip_tags(trim($_REQUEST[tab_id])) . "&mp_id={$mp_id} method=POST>";
DrawHeader('', SubmitButton('Save', '', 'class=btn_medium'));
echo '<BR>';
$sql = 'SELECT * FROM history_marking_periods WHERE SCHOOL_ID = ' . UserSchool() . ' ORDER BY POST_END_DATE';
$functions = array('MP_TYPE' => 'makeSelectInput', 'NAME' => 'makeTextInput', 'POST_END_DATE' => 'makeDateInput', 'SYEAR' => 'makeSchoolYearSelectInput');
$LO_columns = array('MP_TYPE' => 'Type', 'NAME' => 'Name', 'POST_END_DATE' => 'Grade Post Date', 'SYEAR' => 'School Year');
$link['add']['html'] = array('MP_TYPE' => makeSelectInput('', 'MP_TYPE'), 'NAME' => makeTextInput('', 'NAME'), 'POST_END_DATE' => makeDateInput('', 'POST_END_DATE'), 'SYEAR' => makeSchoolYearSelectInput('', 'SYEAR'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
//&mp_id=$mp_id";
$link['remove']['variables'] = array('id' => 'MARKING_PERIOD_ID');
$link['add']['html']['remove'] = button('add');
$LO_ret = DBGet(DBQuery($sql), $functions);
ListOutput($LO_ret, $LO_columns, 'History Marking Period', 'History Marking Periods', $link, array(), array('count' => true, 'download' => false, 'search' => false));
echo '<CENTER>';
echo SubmitButton('Save', '', 'class=btn_medium') . '</CENTER>';
echo '</FORM>';
}
function makeTextInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['MARKING_PERIOD_ID']) {
$id = $THIS_RET['MARKING_PERIOD_ID'];
unset($_REQUEST['modfunc']);
}
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = 'SELECT ID,TITLE,SHORT_NAME,SORT_ORDER,NEXT_GRADE_ID FROM school_gradelevels WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER';
$QI = DBQuery($sql);
$LO = DBGet(DBQuery($sql));
$grade_id_arr = array();
foreach ($LO as $ti => $td) {
array_push($grade_id_arr, $td[ID]);
}
$grade_id = implode(',', $grade_id_arr);
$grades_RET = DBGet($QI, array('TITLE' => 'makeTextInput', 'SHORT_NAME' => 'makeTextInput', 'SORT_ORDER' => 'makeTextInput', 'NEXT_GRADE_ID' => 'makeGradeInput'));
$columns = array('TITLE' => 'Title', 'SHORT_NAME' => 'Short Name', 'SORT_ORDER' => 'Sort Order', 'NEXT_GRADE_ID' => 'Next Grade');
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'SHORT_NAME' => makeTextInput('', 'SHORT_NAME'), 'SORT_ORDER' => makeTextInputMod2('', 'SORT_ORDER'), 'NEXT_GRADE_ID' => makeGradeInput('', 'NEXT_GRADE_ID'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID');
if ($err_msg) {
echo "<b style='color:red'>" . $err_msg . "</b>";
unset($err_msg);
}
echo "<FORM name=F1 id=F1 action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=update method=POST>";
echo '<input type="hidden" name="h1" id="h1" value="' . $grade_id . '">';
ListOutput($grades_RET, $columns, 'Grade Level', 'Grade Levels', $link, true, array('search' => false));
if (AllowEdit()) {
echo '<br><CENTER><INPUT class="btn_medium" type=submit value=Save onclick="formcheck_school_setup_grade_levels();"></CENTER>';
}
echo '</FORM>';
}
function makeTextInput($value, $name)
}
}
}
DrawHeader(ProgramTitle());
if ($_REQUEST['modfunc'] == 'remove') {
if (DeletePrompt(_('Activity'))) {
DBQuery("DELETE FROM ELIGIBILITY_ACTIVITIES WHERE ID='{$_REQUEST['id']}'");
unset($_REQUEST['modfunc']);
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = "SELECT ID,TITLE,START_DATE,END_DATE FROM ELIGIBILITY_ACTIVITIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' ORDER BY TITLE";
$QI = DBQuery($sql);
$activities_RET = DBGet($QI, array('TITLE' => 'makeTextInput', 'START_DATE' => 'makeDateInput', 'END_DATE' => 'makeDateInput'));
$columns = array('TITLE' => _('Title'), 'START_DATE' => _('Begins'), 'END_DATE' => _('Ends'));
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'START_DATE' => makeDateInput('', 'START_DATE'), 'END_DATE' => makeDateInput('', 'END_DATE'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => 'ID');
echo '<FORM action="Modules.php?modname=' . $_REQUEST[modname] . '&modfunc=update" method="POST">';
DrawHeader('', SubmitButton(_('Save')));
ListOutput($activities_RET, $columns, 'Activity', 'Activities', $link);
echo '<span class="center">' . SubmitButton(_('Save')) . '</span>';
echo '</FORM>';
}
function makeTextInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
$get_schoolid = DBGet(DBQuery("SELECT title FROM schools WHERE id = {$get_schoolid['1']}[school_id]"));
$school_name = $get_schoolid[1]['title'];
}
}
echo '<tr> <td >Grade Level:</td><td>' . $sms_grade_level . '</td>
<tr> <td >Select Marking Period:</td><td>' . $mpselect . '</td></tr>
<tr> <td >School Name:</td><td>' . TextInput($school_name, "SCHOOL_NAME", "", 'size=35 class=cell_floating') . '</td>
</tr></table>';
$sql = 'SELECT ID,COURSE_CODE,COURSE_TITLE,GRADE_PERCENT,GRADE_LETTER,
IF(ISNULL(UNWEIGHTED_GP), WEIGHTED_GP,UNWEIGHTED_GP ) AS GP,WEIGHTED_GP as WEIGHTED_GP,
GP_SCALE,GPA_CAL,CREDIT_ATTEMPTED,CREDIT_EARNED,CREDIT_CATEGORY
FROM student_report_card_grades WHERE STUDENT_ID = ' . $student_id . ' AND COURSE_PERIOD_ID IS NULL AND MARKING_PERIOD_ID = ' . $mp_id . ' ORDER BY ID';
//build forms based on tab selected
$functions = array('COURSE_CODE' => 'makeTextInput', 'COURSE_TITLE' => 'makeTextInput', 'GRADE_PERCENT' => 'makeTextInput', 'GRADE_LETTER' => 'makeTextInput', 'GP' => 'makeTextInput', 'WEIGHTED_GP' => 'makeCheckboxInput', 'GP_SCALE' => 'makeTextInput', 'GPA_CAL' => 'makeCheckboxInput', 'CREDIT_ATTEMPTED' => 'makeTextInput', 'CREDIT_EARNED' => 'makeTextInput');
$LO_columns = array('COURSE_CODE' => 'Code', 'COURSE_TITLE' => 'Course Name', 'GRADE_PERCENT' => 'Percentage', 'GRADE_LETTER' => 'Letter Grade', 'GP' => 'GP Value', 'GPA_CAL' => 'Calculate GPA', 'WEIGHTED_GP' => 'Weighted GP', 'GP_SCALE' => 'Grade Scale', 'CREDIT_ATTEMPTED' => 'Credit Attempted', 'CREDIT_EARNED' => 'Credit Earned');
$link['add']['html'] = array('COURSE_CODE' => makeTextInput('', 'COURSE_CODE'), 'COURSE_TITLE' => makeTextInput('', 'COURSE_TITLE'), 'GRADE_PERCENT' => makeTextInput('', 'GRADE_PERCENT'), 'GRADE_LETTER' => makeTextInput('', 'GRADE_LETTER'), 'GP' => makeTextInput('', 'GP'), 'WEIGHTED_GP' => makeCheckboxInput('', 'WEIGHTED_GP'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'), 'GPA_CAL' => makeCheckboxInput('', 'GPA_CAL'), 'CREDIT_ATTEMPTED' => makeTextInput('', 'CREDIT_ATTEMPTED'), 'CREDIT_EARNED' => makeTextInput('', 'CREDIT_EARNED'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&mp_id={$mp_id}";
$link['remove']['variables'] = array('id' => 'ID');
$link['add']['html']['remove'] = button('add');
if ($mp_id) {
$LO_ret = DBGet(DBQuery($sql), $functions);
echo '<div style="width:820px; overflow:auto; overflow-x:scroll; padding-bottom:8px;">';
ListOutput($LO_ret, $LO_columns, '', '', $link, array(), array('count' => true, 'download' => true, 'search' => true));
echo '</div>';
}
}
echo '<CENTER>';
echo SubmitButton('Save', 'S1', 'class=btn_medium') . '</CENTER>';
echo '</FORM>';
}
}
if (User('PROFILE') == 'admin' || User('PROFILE') == 'teacher') {
$LO_columns = array('DESCRIPTION' => _('Item Description'), 'SHORT_NAME' => _('Short Name'), 'ICON' => _('Icon'), 'SORT_ORDER' => _('Sort Order'), 'PRICE' => _('Student Price'), 'PRICE_REDUCED' => _('Reduced Price'), 'PRICE_FREE' => _('Free Price'), 'PRICE_STAFF' => _('Staff Price'));
} else {
$LO_columns = array('DESCRIPTION' => _('Item Description'), 'SHORT_NAME' => _('Short Name'), 'ICON' => _('Icon'), 'PRICE' => _('Student Price'));
if (UserStudentID()) {
$discount = DBGet(DBQuery('SELECT DISCOUNT FROM FOOD_SERVICE_STUDENT_ACCOUNTS WHERE STUDENT_ID=' . UserStudentID()));
$discount = $discount[1]['DISCOUNT'];
if ($discount == 'Reduced') {
$LO_columns += array('PRICE_REDUCED' => _('Reduced Price'));
} elseif ($discount == 'Free') {
$LO_columns += array('PRICE_FREE' => _('Free Price'));
}
}
$LO_columns += array('PRICE_STAFF' => _('Staff Price'));
}
$link['add']['html'] = array('DESCRIPTION' => makeTextInput('', 'DESCRIPTION'), 'SHORT_NAME' => makeTextInput('', 'SHORT_NAME'), 'ICON' => makeSelectInput('', 'ICON'), 'SORT_ORDER' => makeTextInput('', 'SORT_ORDER'), 'PRICE' => makeTextInput('', 'PRICE'), 'PRICE_REDUCED' => makeTextInput('', 'PRICE_REDUCED'), 'PRICE_FREE' => makeTextInput('', 'PRICE_FREE'), 'PRICE_STAFF' => makeTextInput('', 'PRICE_STAFF'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id={$_REQUEST['tab_id']}";
$link['remove']['variables'] = array('item_id' => 'ITEM_ID');
$link['add']['html']['remove'] = button('add');
$tabs[] = array('title' => button('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
$singular = _('Meal Item');
$plural = _('Meal Items');
}
$LO_ret = DBGet(DBQuery($sql), $functions);
//echo '<pre>'; var_dump($LO_ret); echo '</pre>';
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&tab_id={$_REQUEST['tab_id']} method=POST>";
DrawHeader('', SubmitButton(_('Save')));
echo '<BR>';
$extra = array('save' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}"));
ListOutput($LO_ret, $LO_columns, $singular, $plural, $link, array(), $extra);
echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
$tabs[] = array('title' => 'grades', 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=grades&mp_id={$mp_id}");
$tabs[] = array('title' => 'Credits', 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=credits&mp_id={$mp_id}");
echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$tab_id}&mp_id={$mp_id}") . '</CENTER>';
$sql = 'SELECT ID,COURSE_TITLE,GRADE_PERCENT,GRADE_LETTER,
IF(ISNULL(UNWEIGHTED_GP), WEIGHTED_GP,UNWEIGHTED_GP ) AS GP,WEIGHTED_GP as WEIGHTED_GP,
GP_SCALE,CREDIT_ATTEMPTED,CREDIT_EARNED,CREDIT_CATEGORY
FROM student_report_card_grades WHERE STUDENT_ID = ' . $student_id . ' AND MARKING_PERIOD_ID = ' . $mp_id . ' ORDER BY ID';
//build forms based on tab selected
if ($_REQUEST['tab_id'] == 'grades' || $_REQUEST['tab_id'] == '') {
$functions = array('COURSE_TITLE' => 'makeTextInput', 'GRADE_PERCENT' => 'makeTextInput', 'GRADE_LETTER' => 'makeTextInput', 'GP' => 'makeTextInput', 'WEIGHTED_GP' => 'makeCheckboxInput', 'GP_SCALE' => 'makeTextInput');
$LO_columns = array('COURSE_TITLE' => 'Course Name', 'GRADE_PERCENT' => 'Percentage', 'GRADE_LETTER' => 'Letter Grade', 'GP' => 'GP Value', 'WEIGHTED_GP' => 'Weighted GP', 'GP_SCALE' => 'Grade Scale');
$link['add']['html'] = array('COURSE_TITLE' => makeTextInput('', 'COURSE_TITLE'), 'GRADE_PERCENT' => makeTextInput('', 'GRADE_PERCENT'), 'GRADE_LETTER' => makeTextInput('', 'GRADE_LETTER'), 'GP' => makeTextInput('', 'GP'), 'WEIGHTED_GP' => makeCheckboxInput('', 'WEIGHTED_GP'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'));
} else {
$functions = array('COURSE_TITLE' => 'makeTextInput', 'CREDIT_ATTEMPTED' => 'makeTextInput', 'CREDIT_EARNED' => 'makeTextInput', 'CREDIT_CATEGORY' => 'makeTextInput');
$LO_columns = array('COURSE_TITLE' => 'Course Name', 'CREDIT_ATTEMPTED' => 'Credit Attempted', 'CREDIT_EARNED' => 'Credit Earned', 'CREDIT_CATEGORY' => 'Credit Category');
$link['add']['html'] = array('COURSE_TITLE' => makeTextInput('', 'COURSE_TITLE'), 'CREDIT_ATTEMPTED' => makeTextInput('', 'CREDIT_ATTEMPTED'), 'CREDIT_EARNED' => makeTextInput('', 'CREDIT_EARNED'), 'CREDIT_CATEGORY' => makeTextInput('', 'CREDIT_CATEGORY'));
}
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&mp_id={$mp_id}";
$link['remove']['variables'] = array('id' => 'ID');
$link['add']['html']['remove'] = button('add');
$LO_ret = DBGet(DBQuery($sql), $functions);
echo '<div id="div_margin">';
PopTable_wo_header('header');
echo '</div>';
ListOutput($LO_ret, $LO_columns, '', '', $link, array(), array('count' => true, 'download' => true, 'search' => true));
PopTable('footer');
}
echo '<CENTER>';
if (!$LO_ret) {
echo SubmitButton('Remove Marking Period', 'removemp', 'class=btn_large');
echo ' ';
$LO_columns += array('GRADE_SCALE_ID' => _('Grade Scale'));
}
$link['add']['html'] = array('TITLE' => makeGradesInput('', 'TITLE'), 'BREAK_OFF' => makeGradesInput('', 'BREAK_OFF'), 'GPA_VALUE' => makeGradesInput('', 'GPA_VALUE'), 'UNWEIGHTED_GP' => makeGradesInput('', 'UNWEIGHTED_GP'), 'SORT_ORDER' => makeGradesInput('', 'SORT_ORDER'), 'COMMENT' => makeGradesInput('', 'COMMENT'));
$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'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
}
$singular = 'Grade';
$plural = 'Grades';
} else {
$sql = 'SELECT * FROM REPORT_CARD_GRADE_SCALES WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER,ID';
$functions = array('TITLE' => 'makeTextInput', 'GP_SCALE' => 'makeTextInput', 'COMMENT' => 'makeTextInput', 'HHR_GPA_VALUE' => 'makeGradesInput', 'HR_GPA_VALUE' => 'makeGradesInput', 'SORT_ORDER' => 'makeTextInput');
$LO_columns = array('TITLE' => _('Gradescale'), 'GP_SCALE' => _('Scale Value'), 'COMMENT' => _('Comment'), 'HHR_GPA_VALUE' => _('High Honor Roll GPA Min'), 'HR_GPA_VALUE' => _('Honor Roll GPA Min'), 'SORT_ORDER' => _('Sort Order'));
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'), 'COMMENT' => makeTextInput('', 'COMMENT'), 'HHR_GPA_VALUE' => makeGradesInput('', 'HHR_GPA_VALUE'), 'HR_GPA_VALUE' => makeGradesInput('', '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('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
$singular = 'Grade Scale';
$plural = 'Grade 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>';
$LO_options = array('save' => false, 'search' => false, 'header' => WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}"));
ListOutput($LO_ret, $LO_columns, $singular, $plural, $link, array(), $LO_options);
echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
echo '</FORM>';
$functions += array('GRADE_SCALE_ID' => 'makeGradesInput');
$LO_columns += array('GRADE_SCALE_ID' => 'Grade Scale');
}
$link['add']['html'] = array('TITLE' => makeGradesInput('', 'TITLE'), 'BREAK_OFF' => makeGradesInput('', 'BREAK_OFF'), 'GPA_VALUE' => makeGradesInput('', 'GPA_VALUE'), 'UNWEIGHTED_GP' => makeGradesInput('', 'UNWEIGHTED_GP'), 'SORT_ORDER' => makeGradesInput('', 'SORT_ORDER'), 'COMMENT' => makeGradesInput('', 'COMMENT'));
$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'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
}
} else {
//BJJ modifications to $functions array and $LO_columns array to handle scale value GP_SCALE
$sql = 'SELECT * FROM report_card_grade_scales WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ORDER BY SORT_ORDER,ID';
$functions = array('TITLE' => 'makeTextInput', 'GP_SCALE' => 'makeTextInput', 'COMMENT' => 'makeTextInput', 'GPA_CAL' => 'makeCheckInput', 'STANDARD_GRADE_SCALE' => 'makeCheckboxInput', 'SORT_ORDER' => 'makeTextInput');
$LO_columns = array('TITLE' => 'Gradescale', 'GP_SCALE' => 'Scale Value', 'COMMENT' => 'Comment', 'GPA_CAL' => 'Calculate GPA', 'STANDARD_GRADE_SCALE' => 'Use as Standard Grade Scale', 'SORT_ORDER' => 'Sort Order');
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'GP_SCALE' => makeTextInput('', 'GP_SCALE'), 'COMMENT' => makeTextInput('', 'COMMENT'), 'GPA_CAL' => makeCheckInput('', 'GPA_CAL'), 'STANDARD_GRADE_SCALE' => makeCheckboxInput('', 'STANDARD_GRADE_SCALE'), '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('white_add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new");
}
$LO_ret = DBGet(DBQuery($sql), $functions);
echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update&tab_id={$_REQUEST['tab_id']} method=POST>";
#DrawHeader('',SubmitButton('Save'));
echo '<BR>';
echo '<style type="text/css">#div_margin { margin-top:-20px; _margin-top:-1px; }</style>';
echo '<CENTER>' . WrapTabs($tabs, "Modules.php?modname={$_REQUEST['modname']}&tab_id={$_REQUEST['tab_id']}") . '</CENTER>';
echo '<div id="div_margin">';
PopTable_wo_header('header');
ListOutputMod($LO_ret, $LO_columns, '', '', $link, array(), array('count' => false, 'download' => false, 'search' => false));
echo '<BR>';
$sql .= $column . '=\'' . str_replace("\\'", "'", trim($column_value)) . '\',';
} else {
$sql .= $column . '=NULL ,';
}
}
$sql = substr($sql, 0, -1) . ' WHERE ID=\'' . $id . '\'';
DBQuery($sql);
}
}
} elseif (clean_param($_REQUEST['modfunc'], PARAM_ALPHAMOD) == 'remove') {
DBQuery("DELETE FROM effort_grade_scales WHERE ID='{$_REQUEST['id']}'");
}
$sql = 'SELECT * FROM effort_grade_scales WHERE SCHOOL_ID=\'' . UserSchool() . '\' AND SYEAR=\'' . UserSyear() . '\' ';
$functions = array('VALUE' => 'makeTextInput', 'COMMENT' => 'makeTextInput', 'SORT_ORDER' => 'makeTextInput');
$LO_columns = array('VALUE' => 'Value', 'COMMENT' => 'Comment', 'SORT_ORDER' => 'Sort Order');
$link['add']['html'] = array('VALUE' => makeTextInput('', 'VALUE'), 'COMMENT' => makeTextInput('', 'COMMENT'), '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');
$LO_ret = DBGet(DBQuery($sql), $functions);
echo "<FORM name=F1 id=F1 action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
echo '<BR>';
PopTable_wo_header('header');
ListOutputMod($LO_ret, $LO_columns, '', '', $link, array(), array('count' => false, 'download' => false, 'search' => false));
echo '<BR>';
echo '<CENTER>' . SubmitButton('Save', '', 'class=btn_medium onclick="formcheck_grade_grade();"') . '</CENTER>';
PopTable('footer');
echo '</FORM>';
function makeTextInput($value, $name)
{
global $THIS_RET;
}
}
}
DrawHeader(ProgramTitle());
if ($_REQUEST['modfunc'] == 'remove') {
if (DeletePrompt('enrollment code')) {
DBQuery("DELETE FROM STUDENT_ENROLLMENT_CODES WHERE ID='{$_REQUEST['id']}'");
unset($_REQUEST['modfunc']);
}
}
if ($_REQUEST['modfunc'] != 'remove') {
$sql = "SELECT ID,TITLE,SHORT_NAME,TYPE,DEFAULT_CODE,SORT_ORDER FROM STUDENT_ENROLLMENT_CODES WHERE SYEAR='" . UserSyear() . "' ORDER BY SORT_ORDER,TITLE";
$QI = DBQuery($sql);
$codes_RET = DBGet($QI, array('TITLE' => 'makeTextInput', 'SHORT_NAME' => 'makeTextInput', 'TYPE' => 'makeSelectInput', 'DEFAULT_CODE' => 'makeCheckBoxInput', 'SORT_ORDER' => 'makeTextInput'));
$columns = array('TITLE' => _('Title'), 'SHORT_NAME' => _('Short Name'), 'TYPE' => _('Type'), 'DEFAULT_CODE' => _('Rollover Default'), 'SORT_ORDER' => _('Sort Order'));
$link['add']['html'] = array('TITLE' => makeTextInput('', 'TITLE'), 'SHORT_NAME' => makeTextInput('', 'SHORT_NAME'), 'TYPE' => makeSelectInput('', 'TYPE'), 'DEFAULT_CODE' => makeCheckBoxInput('', 'DEFAULT_CODE'), 'SORT_ORDER' => makeTextInput('', 'SORT_ORDER'));
$link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove";
$link['remove']['variables'] = array('id' => _('ID'));
echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update method=POST>";
DrawHeader('', SubmitButton(_('Save')));
ListOutput($codes_RET, $columns, _('Enrollment Code'), _('Enrollment Codes'), $link);
echo '<CENTER>' . SubmitButton(_('Save')) . '</CENTER>';
echo '</FORM>';
}
function makeTextInput($value, $name)
{
global $THIS_RET;
if ($THIS_RET['ID']) {
$id = $THIS_RET['ID'];
} else {
$id = 'new';
