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}"); } } }