42 lines
1.7 KiB
PHP
42 lines
1.7 KiB
PHP
<?php
|
|
include "db.php";
|
|
|
|
$school_num = 82;
|
|
$schedule_num = 762;
|
|
|
|
$menu_dates = db_query("SELECT * FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num ORDER BY sequence,menu_date");
|
|
|
|
while ($row = db_fetch_array($menu_dates)) {
|
|
extract($row);
|
|
$menu_num = $record_num;
|
|
|
|
// If this is not a linked menu check if it is a parent to other menus
|
|
if ($menu_link == 'No') {
|
|
$linked_menus = db_query("SELECT * FROM hotlunch_menu_dates WHERE school_num = $school_num AND schedule_num = $schedule_num AND source_menu = $menu_num ORDER BY sequence,menu_date");
|
|
$num_linked = db_num_rows($linked_menus);
|
|
echo("Current Menu: $menu_title - $menu_date Source to $num_linked menus\n");
|
|
|
|
// Check the menu items
|
|
$menu_items = db_query("SELECT * FROM hotlunch_menu_items WHERE school_num = $school_num AND menu_num = $menu_num AND active != 'N'");
|
|
while ($row = db_fetch_array($menu_items)) {
|
|
extract($row);
|
|
$item_num = $record_num;
|
|
$results = db_query("SELECT * FROM hotlunch_menu_items WHERE school_num = $school_num AND source_item = $item_num AND active != 'N'");
|
|
$num_items = db_num_rows($results);
|
|
echo(" - $item_title source for $num_items\n");
|
|
}
|
|
|
|
echo("\n");
|
|
}
|
|
|
|
// If this is a linked menu then make sure it's parent exists
|
|
if ($menu_link != 'No') {
|
|
$results = db_query("SELECT * FROM hotlunch_menu_dates WHERE school_num = $school_num AND record_num = $source_menu");
|
|
if (db_num_rows($results) == 0) {
|
|
echo("ERROR: Source Menu Not Found - Current Menu: $menu_title - $menu_date\n");
|
|
echo("\n");
|
|
}
|
|
}
|
|
}
|
|
?>
|