public function post($rest)
{
$req = $rest->request();
$info = $req->post();
// Validate Required Fields
if (!isset($info['description'])) {
api_error(412, 'Description is required');
}
if (!isset($info['tax_type_id'])) {
api_error(412, 'Tax Type is required');
}
if (!isset($info['units'])) {
api_error(412, 'Units is required');
}
if (!isset($info['mb_flag'])) {
api_error(412, 'MB Flag is required');
}
if (!isset($info['sales_account'])) {
api_error(412, 'Sales Account is required');
}
if (!isset($info['cogs_account'])) {
api_error(412, 'Cogs Account is required');
}
if (!isset($info['adjustment_account'])) {
api_error(412, 'Adjustment Account is required');
}
if (!isset($info['assembly_account'])) {
api_error(412, 'Assembly Account is required');
}
if (!isset($info['inventory_account'])) {
api_error(412, 'Inventory Account is required');
}
/*
$description, $tax_type_id, $sales_account,
$cogs_account, $inventory_account, $adjustment_account, $assembly_account,
$units, $mb_flag, $dim1, $dim2, $no_sale
*/
add_item_category($info['description'], $info['tax_type_id'], $info['sales_account'], $info['cogs_account'], $info['inventory_account'], $info['adjustment_account'], $info['assembly_account'], $info['units'], $info['mb_flag'], 0, 0, 0);
$id = db_insert_id();
$catego = get_item_category($id);
if ($catego != null) {
api_create_response(json_encode($catego));
} else {
api_error(500, 'Could Not Save to Database');
}
}
simple_page_mode(true);
//----------------------------------------------------------------------------------
if ($Mode == 'ADD_ITEM' || $Mode == 'UPDATE_ITEM') {
//initialise no input errors assumed initially before we test
$input_error = 0;
if (strlen($_POST['description']) == 0) {
$input_error = 1;
display_error(_("The item category description cannot be empty."));
set_focus('description');
}
if ($input_error != 1) {
if ($selected_id != -1) {
update_item_category($selected_id, $_POST['description'], $_POST['tax_type_id'], $_POST['sales_account'], $_POST['cogs_account'], $_POST['inventory_account'], $_POST['adjustment_account'], $_POST['assembly_account'], $_POST['units'], $_POST['mb_flag'], $_POST['dim1'], $_POST['dim2'], check_value('no_sale'));
display_notification(_('Selected item category has been updated'));
} else {
add_item_category($_POST['description'], $_POST['tax_type_id'], $_POST['sales_account'], $_POST['cogs_account'], $_POST['inventory_account'], $_POST['adjustment_account'], $_POST['assembly_account'], $_POST['units'], $_POST['mb_flag'], $_POST['dim1'], $_POST['dim2'], check_value('no_sale'));
display_notification(_('New item category has been added'));
}
$Mode = 'RESET';
}
}
//----------------------------------------------------------------------------------
if ($Mode == 'Delete') {
// PREVENT DELETES IF DEPENDENT RECORDS IN 'stock_master'
if (key_in_foreign_table($selected_id, 'stock_master', 'category_id')) {
display_error(_("Cannot delete this item category because items have been created using this item category."));
} else {
delete_item_category($selected_id);
display_notification(_('Selected item category has been deleted'));
}
$Mode = 'RESET';
}
}
//----------------------------------------------------------------------------------
if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) {
//initialise no input errors assumed initially before we test
$input_error = 0;
if (strlen($_POST['description']) == 0) {
$input_error = 1;
display_error(tr("The item category description cannot be empty."));
set_focus('description');
}
if ($input_error != 1) {
if (isset($selected_id)) {
update_item_category($selected_id, $_POST['description']);
} else {
add_item_category($_POST['description']);
}
meta_forward($_SERVER['PHP_SELF']);
}
}
//----------------------------------------------------------------------------------
if (isset($_GET['delete'])) {
// PREVENT DELETES IF DEPENDENT RECORDS IN 'stock_master'
$sql = "SELECT COUNT(*) FROM stock_master WHERE category_id='{$selected_id}'";
$result = db_query($sql, "could not query stock master");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0) {
display_error(tr("Cannot delete this item category because items have been created using this item category."));
} else {
delete_item_category($selected_id);
meta_forward($_SERVER['PHP_SELF']);
$result = db_query($sql, "Unable to find units");
$row = db_fetch_row($result);
if (!$row[0]) {
$sql = "INSERT INTO " . TB_PREF . "item_units (abbr, name, decimals) VALUES ( {$abbr}, {$name}, {$dec} )";
} else {
$sql = "UPDATE " . TB_PREF . "item_units SET decimals = {$dec} where abbr = {$abbr}";
}
db_query($sql, "Failed adding/updating UOM");
$u++;
}
if ($type == 'ITEM' || $type == 'KIT' || $type == 'FOREIGN') {
$sql = "SELECT category_id, description FROM " . TB_PREF . "stock_category WHERE description='{$category}'";
$result = db_query($sql, "could not get stock category");
$row = db_fetch_row($result);
if (!$row) {
add_item_category($category);
$cat = db_insert_id();
} else {
$cat = $row[0];
}
}
// type, item_code, stock_id, description, category, units, qty, mb_flag, currency, price
if ($type == 'KIT' || $type == 'FOREIGN') {
// Sales Kit or Foreign Item Code
if ($type == 'FOREIGN') {
$foreign = 1;
} else {
$foreign = 0;
}
$sql = "SELECT id from " . TB_PREF . "item_codes WHERE item_code='{$code}' AND stock_id = '{$id}'";
$result = db_query($sql, "item code could not be retrieved");
