$output[] = '<tr style="background: #eee;">';
$output[] = '<th >Item</th>';
$output[] = '<th >Quantity</th>';
$output[] = '</tr>';
$output[] = '</thead>';
$output[] = '<tbody>';
$item_arr = $xml_obj->item;
$purchaseFailed = array();
if (count($item_arr) > 0) {
foreach ($item_arr as $item) {
$output[] = '<tr>';
$output[] = '<td>' . $item->name . '</td>';
$output[] = '<td>' . $item->quantity . '</td>';
$output[] = '</tr>';
//Get item from store inventory ans save it in order summary
$dbitem = db_getItemByName($item->name);
$success = db_addOrderItem($dborder->id, $dbitem->id, $item->quantity, $item->price);
//Insert order summary for this item
if (!$success) {
array_push($purchaseFailed, $dbitem);
}
}
if (count($purchaseFailed) > 0) {
db_deleteOrder($dborder->id);
}
} else {
$item = $item_arr->item;
$output[] = '<tr>';
$output[] = '<td>' . $item->name . '</td>';
$output[] = '<td>' . $item->quantity . '</td>';
$output[] = '</tr>';
$packagename = $_POST['name'];
} else {
$packagename = "";
}
if (isset($_POST['billable'])) {
$billable = $_POST['billable'];
} else {
$billable = "";
}
if (isset($_POST['active'])) {
$active = $_POST['active'];
} else {
$active = "";
}
if (db_addPackage($packagename, $packagedesc, $active, $billable)) {
$package = db_getItemByName($packagename);
//jh refactored db call : )
$p = array("id" => $package['id'], "name" => $package['name'], "description" => $package['description'], "billable" => $package['billable'], "active" => $package['active'], "price" => $package['price'], "creationdate" => $package['creationdate']);
$result = array('success' => true, 'package' => $p);
} else {
$result = array('success' => false, 'message' => "Package could not be added." . $sql);
}
echo json_encode($result);
} else {
if ($action == "editPackage") {
if (isset($_POST['packagedesc'])) {
$packagedesc = $_POST['packagedesc'];
} else {
$packagedesc = "";
}
if (isset($_POST['packagename'])) {
$referenceid = $_POST['referenceid'];
} else {
$referenceid = "";
}
if (isset($_POST['billable'])) {
$billable = $_POST['billable'];
} else {
$billable = "";
}
if (isset($_POST['type'])) {
$type = $_POST['type'];
} else {
$type = "";
}
if (db_addItem($itemname, $itemdesc, $itemid, $itemprice, $billable, $referenceid, $type, $active)) {
$item = db_getItemByName($itemname);
$result = array('success' => true, 'item' => $item);
} else {
$result = array('success' => false, 'message' => "Item could not be saved");
}
echo json_encode($result);
} else {
if ($action == "modifyItem") {
if (isset($_POST['itemid'])) {
$itemid = $_POST['itemid'];
} else {
$itemid = "";
}
if (isset($_POST['itemdesc'])) {
$itemdesc = $_POST['itemdesc'];
} else {
