function magicalInsert($row)
{
// send the appropriate data to insert customer
$customer = array_slice($row, 0, 14, true);
print_r("customer");
print_r($customer);
$CID = dbInsertNewCustomer($customer);
// send the appropriate data to insert order
$order = array_slice($row, 14, 19, true);
print_r("order");
print_r($order);
$OID = dbInsertNewOrder($CID, $order);
// send the appropriate data to insert items
$products = array_slice($row, 33, 1, true);
$items = $products["Products"];
foreach ($items as $item) {
print_r("item");
print_r($item);
dbInsertNewItem($OID, $item);
}
}
function addOrderToDataBase($CID, $data)
{
global $SETTINGS;
$OID = dbInsertNewOrder($CID, translateOrderInfo($data));
$item = array();
for ($i = 1; $i <= $SETTINGS["MaxItems"]; $i++) {
$item["PKID"] = $data["packages{$i}"];
$item["Personality"] = $data["personality{$i}"];
$item["Quantity"] = $data["quantity{$i}"];
if ($item["Quantity"] != 0) {
$IID = dbInsertNewItem($OID, $item);
}
}
return $OID;
}
function dbReplaceItem($OID, $row)
{
return dbInsertNewItem($OID, $row, true);
}
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}");
}
}
}
