= '$today' " .
"and hlmd.schedule_num = hls.record_num " .
"and hls.status in ('Pending','Active') " .
"GROUP BY 1";
$menudates = db_query($query);
$mDateSchedules = "";
while ($row = db_fetch_array($menudates)) {
if (strlen($mDateSchedules)) $mDateSchedules .= ",";
$mDateSchedules .= $row['schedule_num'];
}
if (strlen($mDateSchedules)) $mDateSchedules = "OR record_num IN ($mDateSchedules)";
// Get set of active schedules defined
$currSchedules = array();
$query = "select * from hotlunch_schedules " .
"where school_num = $school_num " .
"and status in ('Pending','Active') " .
"and (schedule_end_date >= '$today' OR end_order_datetime >= '$now' $mDateSchedules) " .
"order by $scheduleSortOrder";
$schedules = db_query($query);
if (db_num_rows($schedules)) {
$maxLength = 30;
while ($row = db_fetch_array($schedules)) {
$entry = array();
$name = $row['schedule_name'];
if (strlen($name) > $maxLength) {
$words = explode(' ',$name);
$name = $words[0];
for ($i = 1; $i < count($words); $i++) {
if (strlen($name) + strlen($words[$i]) + 1 > $maxLength) break;
$name .= ' ' . $words[$i];
}
$name .= "...";
}
$snum = $row['record_num'];
$entry['name'] = $name;
$entry['snum'] = $snum;
$currSchedules[] = $entry;
}
}
$doc_path = sprintf("%08d",$school_num);
$output_dir = "files/$doc_path/uploads/";
$secureUpload = false;
if (is_dir($output_dir)) $secureUpload = true;
$sOrdersDisplayed = 'N';
?>
-
-
0) { ?>
-
-
- ->>
0 && $school_record['participant_grouping'] != 'None') { ?>
-
- ->>
$cutoff");
if ($numMessageEntries > 0) {
?>
0) { ?>
- ->>
0) { ?>
- ->>
0) { ?>
- ->>
- ->>
- ->>
0) { ?>
- ->>
0) { ?>
- ->>
0) { ?>
0) { ?>
-
-
0) {
echo("
\n");
for ($i = 0; $i < count($currSchedules); $i++) {
$entry = $currSchedules[$i];
extract($entry);
echo(" - $name
\n");
}
echo("
\n");
}
?>
0) { ?>
\n"); if ($numSuppliers > 0 && $sOrdersDisplayed == 'N') { ?>