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';