67 lines
1.9 KiB
PHP
67 lines
1.9 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
$hloh = new Table("hotlunch_order_header");
|
|
$hloi = new Table("hotlunch_order_items");
|
|
|
|
$school_num = 19004;
|
|
$prevDB = "hotlunch_20160928";
|
|
|
|
|
|
db_query("USE $prevDB");
|
|
|
|
$ordersPrev = array();
|
|
$query = "SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND ordered_by_num NOT IN (647923,647925,647927,647928)";
|
|
$results = db_query($query);
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$onum = $row['record_num'];
|
|
$ordersPrev[$onum] = $row;
|
|
}
|
|
|
|
|
|
db_query("USE hotlunch");
|
|
foreach ($ordersPrev as $onum => $order) {
|
|
$query = "SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND record_num = $onum";
|
|
$results = db_query($query);
|
|
if (db_num_rows($results) == 0) {
|
|
$insert = 'N';
|
|
|
|
// Check for any current order for person
|
|
$pnum = $order['ordered_by_num'];
|
|
$results = db_query("SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND ordered_by_num = $pnum");
|
|
if (db_num_rows($results) > 0) continue;
|
|
|
|
// $insert = 'Y';
|
|
|
|
$name = db_getVal("SELECT concat(first_name,' ',last_name) FROM people WHERE record_num = $pnum");
|
|
echo("$onum - $pnum - $name\n");
|
|
|
|
if ($insert == 'Y') {
|
|
db_query("USE $prevDB");
|
|
$items = array();
|
|
$query = "SELECT * FROM hotlunch_order_items WHERE school_num = $school_num AND order_num = $onum";
|
|
$results = db_query($query);
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$items[] = $row;
|
|
}
|
|
db_query("USE hotlunch");
|
|
|
|
$query = $hloh->BuildInsert($order);
|
|
db_query($query);
|
|
$onum = db_insert_id();
|
|
|
|
for ($i = 0; $i < count($items); $i++) {
|
|
$item = $items[$i];
|
|
$item['order_num'] = $onum;
|
|
$item['school_num'] = $school_num;
|
|
$query = $hloi->BuildInsert($item);
|
|
db_query($query);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
?>
|