} } if (!$_REQUEST[modfunc]) { // LIST if ($note) { echo '<TABLE width=100%><TR><TD bgcolor=#E8E8E9><font size=-1>'; ErrorMessage($note, 'note'); echo '</font></TD></TR></TABLE>'; } echo "<FORM action=Modules.php?modname={$_REQUEST['modname']}&modfunc=update METHOD=POST>"; $functions = array('AMOUNT' => 'Currency', 'ACCOUNT_ID' => 'getAccount', 'DUE_DATE' => 'ProperDate', 'SYEAR' => 'DispYear', 'SCHOOL' => 'GetSchool', 'GRADE' => 'GetGrade'); $RET = DBGet(DBQuery('SELECT DISTINCT sb.ID,sb.TITLE,sb.AMOUNT, to_char(sb.DUE_DATE,\'dd-MON-yy\') as DUE_DATE,sb.SYEAR,sb.SCHOOL,sb.GRADE,sb.ACCOUNT_ID FROM STU_BILLING_DEFINED_FEES sb ORDER BY sb.TITLE'), $functions); $columns = array('TITLE' => 'Title', 'AMOUNT' => 'Amount', 'ACCOUNT_ID' => 'Account', 'DUE_DATE' => 'Due Date', 'SYEAR' => 'School Year', 'SCHOOL' => 'School', 'GRADE' => 'Grade'); $link[add][html] = array('TITLE' => makeTitleInput(), 'AMOUNT' => makeAmountInput(), 'ACCOUNT_ID' => makeAccountInput(), 'DUE_DATE' => makeDateInput(), 'SYEAR' => makeSyearInput(), 'SCHOOL' => makeSchoolInput(), 'GRADE' => makeGradeInput(), 'remove' => button('add')); $link[remove] = array('link' => "Modules.php?modname={$_REQUEST['modname']}&modfunc=delete", 'variables' => array('id' => 'ID')); $_REQUEST[modfunc] = 'list'; unset($_REQUEST[modfunc]); ListOutput($RET, $columns, 'Pre-Defined Fee', 'Pre-Defined Fees', $link); echo '<center><input type=submit class=btn_medium value=Save></center>'; } // -- END LIST function makeTitleInput($value = '') { return "<INPUT type=text name=title maxlength=30 size=10 value='{$value}'>"; } function makeAmountInput($value = '') { return "<INPUT type=text name=amount maxlength=10 size=6 " . ($value ? "value=" . Currency($value) : '') . '>'; }
foreach ($foods_RET as $category_id => $food) { echo '<TD valign=top>'; echo '<center><table><tr><td>' . "<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=delete_category&id={$category_id}&user_school=" . UserSchool() . ">\n\t\t\t\t\t\t<IMG SRC=assets/remove_button.gif></A></td>\n\t\t\t\t\t\t<td><b>" . makeCategoryInput($categories_RET[$category_id][1]['TITLE'], $category_id) . '</b></td></tr></table></center>'; $link['remove']['link'] = "Modules.php?modname={$_REQUEST['modname']}&modfunc=delete&user_school=" . UserSchool(); $link['remove']['variables'] = array('id' => 'ID'); $link['add']['html'] = array('TITLE' => makeTitleInput('', $category_id), 'PRICE' => makePriceInput('', $category_id), 'FREE_PRICE' => makeFPriceInput('', $category_id), 'REDUCED_PRICE' => makeRPriceInput('', $category_id), 'BUTTON' => makeButtonInput('', $category_id)); ListOutput($food, array('TITLE' => 'Name', 'BUTTON' => 'Key', 'PRICE' => 'Price', 'REDUCED_PRICE' => 'Reduced Price', 'FREE_PRICE' => 'Free Price'), '', '', $link, array(), array('save' => false)); echo '</TD>'; } } if (count($categories_RET)) { foreach ($categories_RET as $category_id => $value) { if (!count($foods_RET[$category_id])) { echo '<TD valign=top>'; echo '<center><table><tr><td>' . "<A HREF=Modules.php?modname={$_REQUEST['modname']}&modfunc=delete_category&id={$category_id}&user_school=" . UserSchool() . ">\n\t\t\t\t\t\t\t<IMG SRC=assets/remove_button.gif></A></td>\n\t\t\t\t\t\t\t<td><b>" . makeCategoryInput($categories_RET[$category_id][1]['TITLE'], $category_id) . '</b></td></tr></table></center>'; $link[add][html] = array('TITLE' => makeTitleInput('', $category_id), 'PRICE' => makePriceInput('', $category_id), 'FREE_PRICE' => makeFPriceInput('', $category_id), 'REDUCED_PRICE' => makeRPriceInput('', $category_id), 'BUTTON' => makeButtonInput('', $category_id)); ListOutput(array(), array('TITLE' => 'Name', 'BUTTON' => 'Key', 'PRICE' => 'Price', 'REDUCED_PRICE' => 'Reduced Price', 'FREE_PRICE' => 'Free Price'), '', '', $link, array(), array('save' => false)); echo '</TD>'; } } } echo '<TD valign=top>'; echo '<table><TR><TD><IMG SRC=assets/add_button.gif></TD><TD><INPUT type=text size=20 name=new_category_title value="New Category"></TD></TR></TABLE>'; echo '</TD>'; echo '</TR>'; echo '<TR><TD colspan=' . (count($categories_RET) * 2 + 1) . ' align=center>'; echo '<INPUT type=submit value="Save the Menu">'; echo '</TD></TR>'; echo '</TABLE>'; echo '</FORM>'; echo "</TD></TR></TABLE></CENTER>";