function can_process()
{
global $selected_id;
if ($selected_id == -1) {
if (!references::is_valid($_POST['ref'])) {
display_error(tr("The dimension reference must be entered."));
set_focus('ref');
return false;
}
if (!is_new_reference($_POST['ref'], systypes::dimension())) {
display_error(tr("The entered reference is already in use."));
set_focus('ref');
return false;
}
}
if (strlen($_POST['name']) == 0) {
display_error(tr("The dimension name must be entered."));
set_focus('name');
return false;
}
if (!is_date($_POST['date_'])) {
display_error(tr("The date entered is in an invalid format."));
set_focus('date_');
return false;
}
if (!is_date($_POST['due_date'])) {
display_error(tr("The required by date entered is in an invalid format."));
set_focus('due_date');
return false;
}
return true;
}
include_once $path_to_root . "/dimensions/includes/dimensions_db.inc";
include_once $path_to_root . "/dimensions/includes/dimensions_ui.inc";
//-------------------------------------------------------------------------------------------------
if ($_GET['trans_no'] != "") {
$id = $_GET['trans_no'];
}
display_heading(systypes::name(systypes::dimension()) . " # " . $id);
$myrow = get_dimension($id);
if (strlen($myrow[0]) == 0) {
echo tr("The work order number sent is not valid.");
exit;
}
start_table($table_style);
$th = array(tr("#"), tr("Reference"), tr("Name"), tr("Type"), tr("Date"), tr("Due Date"));
table_header($th);
start_row();
label_cell($myrow["id"]);
label_cell($myrow["reference"]);
label_cell($myrow["name"]);
label_cell($myrow["type_"]);
label_cell(sql2date($myrow["date_"]));
label_cell(sql2date($myrow["due_date"]));
end_row();
comments_display_row(systypes::dimension(), $id);
end_table();
if ($myrow["closed"] == true) {
echo "<br>" . tr("This dimension is closed.") . "<br>";
}
display_dimension_payments($id);
br(1);
end_page(true);
$row = db_fetch_row($res);
if ($k == 1) {
$row_text = "class='oddrow'";
$k = 0;
} else {
$row_text = "class='evenrow'";
$k++;
}
// check if it's an overdue work order
if (date_diff(Today(), sql2date($myrow["due_date"]), "d") > 0) {
$row_text = "class='overduebg'";
}
start_row($row_text);
$mpage = $path_to_root . "/dimensions/dimension_entry.php?" . SID . "trans_no=" . $myrow["id"];
label_cell(get_dimensions_trans_view_str(systypes::dimension(), $myrow["id"]));
label_cell(get_dimensions_trans_view_str(systypes::dimension(), $myrow["id"], $myrow["reference"]));
label_cell($myrow["name"]);
label_cell($myrow["type_"]);
label_cell(sql2date($myrow["date_"]));
label_cell(sql2date($myrow["due_date"]));
if (!$outstanding_only) {
label_cell($myrow["closed"] ? tr("Yes") : tr("No"));
}
amount_cell($row[0]);
if ($myrow["closed"] == 0) {
label_cell("<a href='{$mpage}'>" . tr("Edit") . "</a>");
}
end_row();
$j++;
if ($j == 12) {
$j = 1;
$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");
}
$i++;
