if (isset($_GET['supplier_id']))
{
$supplier_id = strtoupper($_GET['supplier_id']);
-}
+}
elseif (isset($_POST['supplier_id']))
{
$supplier_id = strtoupper($_POST['supplier_id']);
$sql = "INSERT INTO ".TB_PREF."purch_data (supplier_id, stock_id, price, suppliers_uom,
conversion_factor, supplier_description) VALUES (";
- $sql .= "'$supplier_id', '" . $_POST['stock_id'] . "', " .
+ $sql .= "'$supplier_id', '" . $_POST['stock_id'] . "', " .
input_num('price') . ", '" . $_POST['suppliers_uom'] . "', " .
input_num('conversion_factor') . ", '" . $_POST['supplier_description'] . "')";
display_note(_("The purchasing data item has been sucessfully deleted."));
unset ($supplier_id);
}
-
+if (isset($_POST['_stock_id_update']))
+ $Ajax->activate('price_table');
//--------------------------------------------------------------------------------------------------
start_form(false, true);
echo "<center>" . _("Item:"). " ";
stock_purchasable_items_list('stock_id', $_POST['stock_id'], false, true);
-echo "<hr><center>";
+echo "<hr></center>";
set_global_stock_item($_POST['stock_id']);
$mb_flag = get_mb_flag($_POST['stock_id']);
-if ($mb_flag == -1)
+if ($mb_flag == -1)
{
display_error(_("Entered item is not defined. Please re-enter."));
set_focus('stock_id');
-}
-else
+}
+else
{
$sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name,".TB_PREF."suppliers.curr_code
WHERE stock_id = '" . $_POST['stock_id'] . "'";
$result = db_query($sql, "The supplier purchasing details for the selected part could not be retrieved");
-
+ div_start('price_table');
if (db_num_rows($result) == 0)
{
display_note(_("There is no purchasing data set up for the part selected"));
- }
- else
+ }
+ else
{
start_table("$table_style width=60%");
end_table();
}
+ div_end();
}
//------------------------------------------------------------------------------------------------
echo "<br>";
start_table($table_style2);
-if (isset($_GET['Edit']))
+if (isset($_GET['Edit']))
{
hidden('supplier_id', $supplier_id);
label_row(_("Supplier:"), $supp_name);
-}
+}
else
{
supplier_list_row(_("Supplier:"), 'supplier_id', null, false, true);
$supplier_id = $_POST['supplier_id'];
-}
+}
amount_row(_("Price:"), 'price', null,'', get_supplier_currency($supplier_id));
text_row(_("Suppliers Unit of Measure:"), 'suppliers_uom', null, 50, 51);
{
$_POST['conversion_factor'] = exrate_format(1);
}
-amount_row(_("Conversion Factor (to our UOM):"), 'conversion_factor',
+amount_row(_("Conversion Factor (to our UOM):"), 'conversion_factor',
exrate_format($_POST['conversion_factor']), null, null, user_exrate_dec() );
text_row(_("Supplier's Code or Description:"), 'supplier_description', null, 50, 51);
if (isset($_GET['Edit']))
{
submit_center('UpdateRecord', _("Update Purchasing Data"));
-}
-else
+}
+else
{
submit_center('AddRecord', _("Add Purchasing Data"));
}