$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 {