function retrieveOrder($resultT, $db)
{
$row = $resultT->FetchRow();
$name = $row['name'];
$customerId = $row['customerId'];
$phone = htmlentities($_GET['phone'], ENT_QUOTES);
//BRIDGE TABLE
$query1 = "select * from customerToOrder where customerId ='{$customerId}'";
$result1 = $db->Execute($query1);
if (!$result1) {
printError();
return;
}
//PIZZA ORDER TABLE
$row1 = $result1->FetchRow();
$orderId = $row1['orderId'];
$query2 = "select * from pizzaOrder where orderId ='{$orderId}'";
$result2 = $db->Execute($query2);
if (!$result2) {
printError();
return;
}
$row2 = $result2->FetchRow();
$toppings = $row2['toppingId'];
$size = $row2['sizeId'];
showOrderForm($phone, $name, $toppings, $size);
}
function main($OID)
{
global $repeatTimes;
if (!array_key_exists("orderForm", $_GET)) {
$data = takeOrderFromDataBase($OID);
showOrderForm($data, "");
} else {
$badFields = orderValidate($_GET);
if (count($badFields) != 0) {
showOrderForm($_GET, "", $badFields);
} else {
dbUpdate("orders", formatNonItemFields($_GET), "OID", $OID);
for ($i = 1; $i < $repeatTimes; $i++) {
$item = selectItem($_GET, $i);
if (!empty($item)) {
// checks to be sure the item actually has info
if ($item["Quantity"] != 0) {
if ($_GET["iid{$i}"] != "") {
dbUpdate("items", $item, "OID", $OID, "IID", $_GET["iid{$i}"]);
} else {
// if the item does not yet exist in the database
dbInsertNewItem($OID, $item);
}
} else {
// if the quantity of an item is set to zero
dbDeleteItem($_GET["iid{$i}"]);
}
}
}
// go back to the order page
$config = getConfigData();
$backToOrder = getSpecialVariable("backToOrder", $config);
backToWPPage($backToOrder, "oid={$OID}");
}
}
}
