if (isset($_POST['selected_id'])) { $selected_id = strtoupper($_POST['selected_id']); } } //---------------------------------------------------------------------------------- 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 {
page(_($help_context = "Item Categories")); include_once $path_to_root . "/includes/ui.inc"; include_once $path_to_root . "/inventory/includes/inventory_db.inc"; 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);
public function put($rest, $id) { $req = $rest->request(); $info = $req->post(); $catego = get_item_category($id); if ($catego == null) { api_error(400, 'Invalid Category ID'); } // 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'); } /* $id, $description, $tax_type_id, $sales_account, $cogs_account, $inventory_account, $adjustment_account, $assembly_account, $units, $mb_flag, $dim1, $dim2, $no_sale */ update_item_category($id, $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); api_success_response("Category has been updated"); }