\n"); $error_message = getLanguageText('ERRORMSG-ACCESS-DENIED'); include "form.messages.php"; return; } // // Process all actions to list and edit records // $naction = ""; if (array_key_exists('schedule_num',$_GET)) $schedule_num = intval($_GET['schedule_num']); if (array_key_exists('schedule_num',$_POST)) $schedule_num = intval($_POST['schedule_num']); $numMenuDates = db_getVal("SELECT count(*) FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num"); $numMenuItems = db_getVal("SELECT count(*) FROM hotlunch_menu_items AS hlmi, hotlunch_menu_dates AS hlmd " . "WHERE hlmd.school_num = $school_num " . "AND hlmd.schedule_num = $schedule_num " . "AND hlmi.menu_num = hlmd.record_num " . "AND item_type = 'Item' " . "AND hlmi.school_num = $school_num"); // Start the template and output buffering startTemplate(); $templatePageTitle = getLanguageText('TEXT-MULTI-MENU-DELIVERY-REPORT'); $selectTitle = getLanguageText('TEXT-MENUS'); $selectName = "menu_num"; $selectSize = $numMenuDates; if ($numMenuDates > 10) $selectSize = 10; $paction = $action; if ($action == "multi-item-delivery") { $templatePageTitle = getLanguageText('TEXT-MULTI-ITEM-DELIVERY-REPORT'); $selectTitle = getLanguageText('TEXT-MENU-ITEMS'); $selectName = "menu_item_num"; $selectSize = $numMenuItems; if ($numMenuItems > 20) $selectSize = 20; } $headerArgs = ""; // Validate the schedule if (!isset($schedule_num)) { echo("
\n"); $error_message = getLanguageText('ERRORMSG-INVALID-SCHEDULE-NUM'); include "form.messages.php"; return; } // Check if this is a valid schedule $query = "select * from hotlunch_schedules " . "where school_num = $school_num " . "and record_num = $schedule_num"; $results = db_query($query); if (db_num_rows($results) == 0) { echo("
\n"); $error_message = getLanguageText('ERRORMSG-INVALID-SCHEDULE'); include "form.messages.php"; return; } $hotlunch_schedule = db_fetch_array($results); // If this is a ScheduleTeam user check if they have permission to access this schedule if (in_array($_SESSION['UserInfo']['type'],array('Schedule Team','Schedule Volunteer'))) { $userNum = $_SESSION['UserInfo']['record_num']; $access = db_getVal("SELECT count(*) FROM hotlunch_schedules_people WHERE school_num = $school_num AND schedule_num = $schedule_num AND user_num = $userNum"); if (!$access || $access == 0) { echo("
\n"); $error_message = getLanguageText('TEXT-NO-ACCESS-TO-SCHEDULE'); include "form.messages.php"; return; } } include "hotlunch_reports.menu.php"; echo("
\n"); if (array_key_exists('naction',$_GET)) $naction = $_GET['naction']; if (array_key_exists('naction',$_POST)) $naction = $_POST['naction']; $school_num = $school_record['record_num']; include "form.messages.php"; // // Display the menu selection // ?>

:	$mtitle\n"); else { echo(" \n"); $query = "SELECT * FROM hotlunch_menu_items " . "WHERE school_num = $school_num " . "AND menu_num = $record_num " . "AND item_type = 'Item' " . "ORDER BY sequence"; $menu_items = db_query($query); while ($row = db_fetch_array($menu_items)) { $record_num = $row['record_num']; $item_title = $row['item_title']; echo(" $item_title\n"); } echo(" \n"); } } ?>
:	0) { $sclasses = ""; while ($row = db_fetch_array($results)) { if (strlen($sclasses)) $sclasses .= ","; $sclasses .= $row['class_num']; } $swhere = "AND record_num IN ($sclasses) "; } // Get set of classes $query = "select * from classes " . "where school_num = $school_num " . $swhere . "order by sequence"; $results = db_query($query); while ($row = db_fetch_array($results)) { $class_num = $row['record_num']; $class_info = getClassInfo($class_num); echo(" $class_info\n"); } $numStaffOrders = db_getVal("SELECT count(*) FROM hotlunch_order_header WHERE school_num = $school_num AND schedule_num = $schedule_num AND ordered_by_type = 'Staff'"); if ($numStaffOrders > 0) { ?>
:
:
:
: