function processRequestConfirmed($page_id, $cid, $request)
{
switch ($request) {
case "delete":
dbCustomerDelete($cid);
foreach (dbGetOrdersForCustomer($cid) as $stuff) {
foreach ($stuff as $order) {
print_r(dbGetOrdersForCustomer($cid));
dbOrderDelete($order["OID"]);
}
}
break;
default:
echo "Dude. Somehow there was a bad request.\n";
}
}
function dbGetCustomersSummary($sort, $reverse)
{
$hadError = false;
$con = dbConnect();
if ($con == null) {
return null;
}
if ($reverse) {
$reverse = "DESC";
} else {
$reverse = "ASC";
}
#still needs OIDs!!!!!
$sql = "SELECT customers.CID, \n customers.Title,\n customers.FirstName,\n customers.LastName,\n customers.City,\n customers.State,\n customers.Country,\n customers.MetDate,\n customers.CustomerCNotes\n FROM customers\n ORDER BY {$sort} {$reverse};";
$result = mysqli_query($con, $sql);
if (!$result) {
dbErrorMsg("Error during sql query in dbGetCustomersSummary" . mysqli_error($con));
$hadError = true;
} else {
$returnArray = array();
while ($row = mysqli_fetch_assoc($result)) {
dbCustomerNormalize2PHP($row);
$row["OID"] = dbGetOrdersForCustomer($row["CID"]);
if ($row["State"] == 'ZZ') {
$row["State"] = '-';
}
$returnArray[] = $row;
}
mysqli_free_result($result);
}
dbClose($con);
if ($hadError) {
return null;
} else {
return $returnArray;
}
}
