exit;
}
$_POST['ref'] = $myrow["reference"];
$_POST['closed'] = $myrow["closed"];
$_POST['name'] = $myrow["name"];
$_POST['type_'] = $myrow["type_"];
$_POST['date_'] = sql2date($myrow["date_"]);
$_POST['due_date'] = sql2date($myrow["due_date"]);
$_POST['memo_'] = get_comments_string(systypes::dimension(), $selected_id);
hidden('ref', $_POST['ref']);
label_row(tr("Dimension Reference:"), $_POST['ref']);
hidden('selected_id', $selected_id);
} else {
ref_row(tr("Dimension Reference:"), 'ref', references::get_next(systypes::dimension()));
}
text_row_ex(tr("Name") . ":", 'name', 50, 75);
$dim = get_company_pref('use_dimension');
number_list_row(tr("Type"), 'type_', null, 1, $dim);
date_row(tr("Start Date") . ":", 'date_');
date_row(tr("Date Required By") . ":", 'due_date', null, sys_prefs::default_dimension_required_by());
textarea_row(tr("Memo:"), 'memo_', null, 40, 5);
end_table(1);
submit_add_or_update_center($selected_id == -1);
if ($selected_id != -1) {
echo "<br>";
submit_center_first('close', tr("Close This Dimension"));
submit_center_last('delete', tr("Delete This Dimension"));
}
end_form();
//--------------------------------------------------------------------------------------------
end_page();
$result = db_query($sql, "item code could not be retrieved");
$row = db_fetch_row($result);
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");
}