if ($_REQUEST['tab_id'] != 'new') { $items_RET = DBGet(DBQuery('SELECT ITEM_ID,DESCRIPTION FROM FOOD_SERVICE_ITEMS WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER')); $items_select = array(); foreach ($items_RET as $item) { $items_select += array($item['ITEM_ID'] => $item['DESCRIPTION']); } $categories_RET = DBGet(DBQuery('SELECT CATEGORY_ID,TITLE FROM FOOD_SERVICE_CATEGORIES WHERE MENU_ID=\'' . $_REQUEST['tab_id'] . '\' ORDER BY SORT_ORDER')); $categories_select = array(); foreach ($categories_RET as $category) { $categories_select += array($category['CATEGORY_ID'] => $category['TITLE']); } //$sql = 'SELECT *,(SELECT \'<IMG src='.$FS_IconsPath.'/\'||ICON||\' height=30>\' FROM FOOD_SERVICE_ITEMS WHERE ITEM_ID=fsmi.ITEM_ID) AS SHORT_NAME FROM FOOD_SERVICE_MENU_ITEMS fsmi WHERE MENU_ID=\''.$_REQUEST['tab_id'].'\' ORDER BY (SELECT SORT_ORDER FROM FOOD_SERVICE_CATEGORIES WHERE CATEGORY_ID=fsmi.CATEGORY_ID),SORT_ORDER'; $sql = 'SELECT *,(SELECT ICON FROM FOOD_SERVICE_ITEMS WHERE ITEM_ID=fsmi.ITEM_ID) AS ICON FROM FOOD_SERVICE_MENU_ITEMS fsmi WHERE MENU_ID=\'' . $_REQUEST['tab_id'] . '\' ORDER BY (SELECT SORT_ORDER FROM FOOD_SERVICE_CATEGORIES WHERE CATEGORY_ID=fsmi.CATEGORY_ID),SORT_ORDER'; $functions = array('ITEM_ID' => 'makeSelectInput', 'ICON' => 'makeIcon', 'CATEGORY_ID' => 'makeSelectInput', 'DOES_COUNT' => 'makeCheckboxInput', 'SORT_ORDER' => 'makeTextInput'); $LO_columns = array('ITEM_ID' => _('Menu Item'), 'ICON' => _('Icon'), 'CATEGORY_ID' => _('Category'), 'DOES_COUNT' => _('Include in Counts'), 'SORT_ORDER' => _('Sort Order')); $link['add']['html'] = array('ITEM_ID' => makeSelectInput('', 'ITEM_ID'), 'CATEGORY_ID' => makeSelectInput('', 'CATEGORY_ID'), 'DOES_COUNT' => makeCheckboxInput('', 'DOES_COUNT'), 'SORT_ORDER' => makeTextInput('', 'SORT_ORDER')); $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=remove&tab_id={$_REQUEST['tab_id']}"; $link['remove']['variables'] = array('menu_item_id' => 'MENU_ITEM_ID'); $link['add']['html']['remove'] = button('add'); $tabs[] = array('title' => button('add'), 'link' => "Modules.php?modname={$_REQUEST['modname']}&tab_id=new"); $singular = $menus_RET[$_REQUEST['tab_id']][1]['TITLE'] . ' Item'; $plural = $singular . 's'; } else { $icons_select = get_icons_select($FS_IconsPath); $sql = 'SELECT * FROM FOOD_SERVICE_ITEMS fsmi WHERE SCHOOL_ID=\'' . UserSchool() . '\' ORDER BY SORT_ORDER'; $functions = array('DESCRIPTION' => 'makeTextInput', 'SHORT_NAME' => 'makeTextInput', 'ICON' => 'makeSelectInput', 'SORT_ORDER' => 'makeTextInput', 'PRICE' => 'makeTextInput', 'PRICE_REDUCED' => 'makeTextInput', 'PRICE_FREE' => 'makeTextInput', 'PRICE_STAFF' => 'makeTextInput'); 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()) {
} } else { echo '<tr><td align=right width=50% valign=top>Grade:</td><td width=50% valign=top>' . $sms_grade_level . '</td></tr><tr><td class=clear></td></tr></table>'; $tabs = array(); $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'); }
$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>'; } }
$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>';