function getItems($oid)
{
global $SETTINGS;
$order = dbGetOrder($oid);
$items = dbGetItems($oid);
$packages = dbGetPackages();
$pieces = dbGetPieces();
$retarray = array();
foreach ($items as $item) {
$row = array();
$row["PKID"] = $item["PKID"];
$row["Quantity"] = $item["Quantity"];
$row["Name"] = findPackageName($item["PKID"], $packages);
$row["Personality"] = $item["Personality"];
if ($item["Personality"]) {
$row["Personality"] = findPieceName($item["Personality"], $pieces);
}
$row["Price"] = findPackagePrice($item["PKID"], $packages);
$retarray[] = $row;
}
// add the charity chapr marketing kit if needed
if ($order["Charity"]) {
$row = array();
$row["PKID"] = $SETTINGS["CharityKitPKID"];
$row["Quantity"] = 1;
$row["Name"] = findPackageName($row["PKID"], $packages);
$row["Personality"] = null;
$retarray[] = $row;
}
return $retarray;
}
function takeOrderFromDataBase($OID)
{
$data = array();
$data["OID"] = $OID;
$order = dbGetOrder($OID);
$data["customerONotes"] = $order["CustomerONotes"];
$data["adminONotes"] = $order["AdminONotes"];
$data["isExpedited"] = $order["IsExpedited"];
$data["orderedDate"] = date("m/d/Y", $order["OrderedDate"]);
// note that ShippingFee, ExpediteFee, and Discount are null
// if not specified - to distinquish them from being 0.00
// translate the null to a blank string here, then back to
// null on the way out of the form.
$data["shippingFee"] = $order["ShippingFee"];
if ($data["shippingFee"] === null) {
$data["shippingFee"] = "";
}
$data["expediteFee"] = $order["ExpediteFee"];
if ($data["expediteFee"] === null) {
$data["expediteFee"] = "";
}
$data["discount"] = $order["Discount"];
if ($data["discount"] === null) {
$data["discount"] = "";
}
$items = dbGetItems($OID);
$i = 1;
foreach ($items as $item) {
$data["iid{$i}"] = $item["IID"];
$data["personality{$i}"] = $item["Personality"];
$data["packages{$i}"] = $item["PKID"];
$data["quantity{$i}"] = $item["Quantity"];
$i++;
}
return $data;
}
function lockInFees($oid)
{
global $SETTINGS;
$changed = false;
$mod = array();
$order = dbGetOrder($oid);
if ($order["IsExpedited"] && $order["ExpediteFee"] === null) {
$changed = true;
$mod["ExpediteFee"] = $SETTINGS["ExpediteFeeDefault"];
}
if ($order["ShippingFee"] === null) {
$changed = true;
$items = dbGetItems($oid);
// TODO - this isn't a GREAT way to calculate shipping because
// it will also count little things.
$count = 0;
foreach ($items as $item) {
$count += $item["Quantity"];
}
$mod["ShippingFee"] = $count * $SETTINGS["ShippingPerChapR"];
}
dbOrderModify($oid, $mod);
}
function dbOrderDuplicate($oid)
{
$order = dbGetOrder($oid);
if (!$order) {
return null;
}
// remove the OID from $order, before insertion
unset($order["OID"]);
$newoid = dbInsertNewOrder($order["CID"], $order);
if (!$newoid) {
dbOrderDelete($newoid);
return null;
}
$items = dbGetItems($oid);
if ($items) {
foreach ($items as $item) {
unset($item["IID"]);
$newiid = dbInsertNewItem($newoid, $item);
if (!$newiid) {
dbOrderDelete($newoid);
// this still leaves orphan items
return null;
}
}
}
return $newoid;
}
function getItems($oid)
{
$items = dbGetItems($oid);
$packages = dbGetPackages();
$pieces = dbGetPieces();
$retarray = array();
foreach ($items as $item) {
$row = array();
$row["Quantity"] = $item["Quantity"];
$row["Name"] = findPackageName($item["PKID"], $packages);
$row["Personality"] = findPieceName($item["Personality"], $pieces);
$row["Price"] = findPackagePrice($item["PKID"], $packages);
$retarray[] = $row;
}
return $retarray;
}
