-
-
0) { ?>
-
-
-
- ->>
- ->>
$cutoff");
if ($numMessageEntries > 0) {
?>
0) { ?>
- ->>
0) { ?>
- ->>
0) { ?>
- ->>
- ->>
- ->>
0) { ?>
- ->>
0) { ?>
- ->>
0) { ?>
0) { ?>
-
-
-
-
-
= '$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
$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)) {
echo("
\n");
$maxLength = 30;
while ($row = db_fetch_array($schedules)) {
$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'];
// if ($_SESSION['UserInfo']['type'] == 'SuperUser') $name .= " $snum";
echo(" - $name
\n");
}
echo("
\n");
}
?>
0) { ?>
-
-