56 lines
1.4 KiB
PHP
56 lines
1.4 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$start = 120;
|
|
$query = "SELECT * FROM schools WHERE status IN ('Active','Linked','Special') ORDER BY record_num LIMIT $start,1200";
|
|
$schools = db_query($query);
|
|
|
|
|
|
while ($row = db_fetch_assoc($schools)) {
|
|
extract($row);
|
|
$school_num = $record_num;
|
|
echo("$school_name\n");
|
|
|
|
$query = "SELECT * FROM hotlunch_menu_items WHERE school_num = $school_num AND active = 'N'";
|
|
$items = db_query($query);
|
|
|
|
$num = db_num_rows($items);
|
|
|
|
echo("Items: $num\n");
|
|
|
|
$deleted = 0;
|
|
|
|
while ($row = db_fetch_assoc($items)) {
|
|
extract($row);
|
|
|
|
// db_query("START TRANSACTION");
|
|
|
|
// Check if orders exist for this menu item
|
|
$num = db_getVal("select count(*) from hotlunch_order_items where school_num = $school_num and menu_item_num = $record_num and active != 'N'");
|
|
|
|
if ($num == 0) {
|
|
$deleted++;
|
|
|
|
$query = "DELETE FROM hotlunch_menu_items WHERE record_num = $record_num";
|
|
db_query($query);
|
|
|
|
$query = "delete from hotlunch_menu_products " .
|
|
"where school_num = $school_num " .
|
|
"and menu_item_num = $record_num";
|
|
db_query($query);
|
|
|
|
$query = "delete from hotlunch_order_items " .
|
|
"where school_num = $school_num " .
|
|
"and menu_item_num = $record_num";
|
|
db_query($query);
|
|
}
|
|
|
|
// db_query("COMMIT");
|
|
}
|
|
|
|
echo("Deleted: $deleted\n");
|
|
}
|
|
|
|
?>
|