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