110 lines
2.9 KiB
PHP
110 lines
2.9 KiB
PHP
<?php
|
|
|
|
$school_num = 18797;
|
|
$schedule_num = 63533;
|
|
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
db_query("USE hotlunch_20231005");
|
|
|
|
|
|
$concession = db_getVal("SELECT record_num FROM hotlunch_order_header WHERE school_num = $school_num AND schedule_num = $schedule_num AND ordered_by_type = 'Concession'");
|
|
|
|
|
|
$query = "SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND schedule_num = $schedule_num AND ordered_by_type != 'Concession'";
|
|
$results = db_query($query);
|
|
$Orders = array();
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$Orders[] = $row;
|
|
}
|
|
|
|
|
|
$query = "SELECT * FROM hotlunch_order_items WHERE school_num = $school_num AND schedule_num = $schedule_num AND order_num != $concession";
|
|
$results = db_query($query);
|
|
$Items = array();
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$Items[] = $row;
|
|
}
|
|
|
|
|
|
$query = "SELECT * FROM user_account WHERE school_num = $school_num AND schedule_num = $schedule_num AND transaction_type = 'Order'";
|
|
$results = db_query($query);
|
|
$Transactions = array();
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$Transactions[] = $row;
|
|
}
|
|
|
|
|
|
echo("Orders: ".count($Orders)."\n");
|
|
echo("Items: ".count($Items)."\n");
|
|
echo("Transactions: ".count($Transactions)."\n");
|
|
|
|
$x = readline("Continue ");
|
|
|
|
|
|
db_query("USE hotlunch");
|
|
|
|
|
|
$Duplicates = array();
|
|
for ($i = 0; $i < count($Orders); $i++) {
|
|
$row = $Orders[$i];
|
|
$ordered_by_num = $row['ordered_by_num'];
|
|
|
|
$query = "SELECT * FROM hotlunch_order_header WHERE school_num = $school_num AND schedule_num = $schedule_num AND ordered_by_num = $ordered_by_num";
|
|
$r = db_query($query);
|
|
if (db_num_rows($r)) {
|
|
$name = db_getVal("SELECT concat(first_name,' ',last_name) FROM people WHERE record_num = $ordered_by_num");
|
|
echo("DUPLICATE ORDER: $name ($ordered_by_num)\n");
|
|
$Duplicates[] = $ordered_by_num;
|
|
}
|
|
}
|
|
|
|
$x = readline("Continue ");
|
|
|
|
|
|
$oTable = new Table("hotlunch_order_header");
|
|
for ($i = 0; $i < count($Orders); $i++) {
|
|
$row = $Orders[$i];
|
|
|
|
if (count($Duplicates) == 0 || !in_array($row['ordered_by_num'], $Duplicates)) {
|
|
$query = $oTable->BuildInsert($row,'Yes');
|
|
db_query($query);
|
|
echo("$query\n");
|
|
}
|
|
}
|
|
|
|
$x = readline("Continue ");
|
|
|
|
|
|
$iTable = new Table("hotlunch_order_items");
|
|
for ($i = 0; $i < count($Items); $i++) {
|
|
$row = $Items[$i];
|
|
|
|
if (count($Duplicates) == 0 || !in_array($row['ordered_by_num'], $Duplicates)) {
|
|
$query = $iTable->BuildInsert($row,'No');
|
|
db_query($query);
|
|
echo("$query\n");
|
|
}
|
|
}
|
|
|
|
$x = readline("Continue ");
|
|
|
|
|
|
$tTable = new Table("user_account");
|
|
for ($i = 0; $i < count($Transactions); $i++) {
|
|
$row = $Transactions[$i];
|
|
$query = $tTable->BuildInsert($row,'No');
|
|
db_query($query);
|
|
echo("$query\n");
|
|
}
|
|
|
|
|
|
$query = "DELETE FROM user_account WHERE school_num = $school_num AND schedule_num = $schedule_num AND transaction_type = 'TRX Note' AND note LIKE 'Schedule Order Deletion%'";
|
|
db_query($query);
|
|
echo("$query\n");
|
|
|
|
|
|
?>
|