} if (!is_date($_POST['due_date'])) { display_error(_("The required by date entered is in an invalid format.")); set_focus('due_date'); return false; } return true; } //------------------------------------------------------------------------------------- if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) { if (!isset($_POST['dimension_tags'])) { $_POST['dimension_tags'] = array(); } if (can_process()) { if ($selected_id == -1) { $id = add_dimension($_POST['ref'], $_POST['name'], $_POST['type_'], $_POST['date_'], $_POST['due_date'], $_POST['memo_']); add_tag_associations($id, $_POST['dimension_tags']); meta_forward($_SERVER['PHP_SELF'], "AddedID={$id}"); } else { update_dimension($selected_id, $_POST['name'], $_POST['type_'], $_POST['date_'], $_POST['due_date'], $_POST['memo_']); update_tag_associations(TAG_DIMENSION, $selected_id, $_POST['dimension_tags']); meta_forward($_SERVER['PHP_SELF'], "UpdatedID={$selected_id}"); } } } //-------------------------------------------------------------------------------------- if (isset($_POST['delete'])) { $cancel_delete = false; // can't delete it there are productions or issues if (dimension_has_payments($selected_id) || dimension_has_deposits($selected_id)) { display_error(_("This dimension cannot be deleted because it has already been processed."));
if (!$row) { add_item_code($code, $id, $description, $cat, $qty, $foreign); } else { update_item_code($row[0], $code, $id, $description, $cat, $qty, $foreign); } $k++; } if ($type == 'ITEM') { $dim = 0; if ($qty != '') { $dim = get_dimension_by_name($qty); if ($dim == -1) { $date = Today(); $due = add_days($date, sys_prefs::default_dimension_required_by()); $ref = references::get_next(systypes::dimension()); $dim = add_dimension($ref, $qty, 1, $date, $due, "Added due to Item Import"); $dim_n++; } } $sql = "SELECT stock_id FROM " . TB_PREF . "stock_master WHERE stock_id='{$id}'"; $result = db_query($sql, "item could not be retrieved"); $row = db_fetch_row($result); if (!$row) { $sql = "INSERT INTO " . TB_PREF . "stock_master (stock_id, description, long_description, category_id,\n\t\t\t\t\t tax_type_id, units, mb_flag, sales_account, inventory_account, cogs_account,\n\t\t\t\t\t adjustment_account, assembly_account, dimension_id, dimension2_id)\n\t\t\t\t\t VALUES ('{$id}', " . db_escape($description) . ", '',\n\t\t\t\t\t '{$cat}', {$_POST['tax_type_id']}, '{$units}', '{$mb_flag}',\n\t\t\t\t\t '{$_POST['sales_account']}', '{$_POST['inventory_account']}', '{$_POST['cogs_account']}',\n\t\t\t\t\t '{$_POST['adjustment_account']}', '{$_POST['assembly_account']}', {$dim}, 0)"; db_query($sql, "The item could not be added"); if ($mb_flag == "M" || $mb_flag == "B") { $sql = "INSERT INTO " . TB_PREF . "loc_stock (loc_code, stock_id) VALUES ('{$_POST['location']}', '{$id}')"; db_query($sql, "The item locstock could not be added"); } $i++; } else {