44 lines
1.1 KiB
PHP
44 lines
1.1 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
db_query("USE hotlunch_20220927");
|
|
|
|
$OrderHeaders = array();
|
|
|
|
$query = "SELECT * FROM hotlunch_order_header WHERE ordered_by_type = 'Concession'";
|
|
$orders = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($orders)) {
|
|
if ($row['added_date'] == '0000-00-00') $row['added_date'] = '2020-01-01';
|
|
$OrderHeaders[] = $row;
|
|
}
|
|
|
|
|
|
db_query("USE hotlunch");
|
|
$hlohTable = new Table("hotlunch_order_header");
|
|
|
|
for ($i = 0; $i < count($OrderHeaders); $i++) {
|
|
$row = $OrderHeaders[$i];
|
|
|
|
$snum = $row['school_num'];
|
|
$onum = $row['record_num'];
|
|
|
|
$query = "SELECT count(*) FROM hotlunch_order_header WHERE school_num = $snum AND record_num = $onum";
|
|
$numOrders = db_getVal($query);
|
|
|
|
if ($numOrders == 0) {
|
|
$query = "SELECT count(*) FROM hotlunch_order_items WHERE school_num = $snum AND order_num = $onum AND ordered_by_type = 'Concession'";
|
|
$nItems = db_getVal($query);
|
|
|
|
if ($nItems > 0) {
|
|
$query = $hlohTable->BuildInsert($row,'Yes');
|
|
echo("$query\n");
|
|
db_query($query);
|
|
}
|
|
}
|
|
}
|
|
|
|
?>
|