" . _("Item:"). " ";
stock_purchasable_items_list('stock_id', $_POST['stock_id'], false, true);
echo "
";
set_global_stock_item($_POST['stock_id']);
$mb_flag = get_mb_flag($_POST['stock_id']);
if ($mb_flag == -1)
{
display_error(_("Entered item is not defined. Please re-enter."));
}
else
{
$sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name,".TB_PREF."suppliers.curr_code
FROM ".TB_PREF."purch_data INNER JOIN ".TB_PREF."suppliers
ON ".TB_PREF."purch_data.supplier_id=".TB_PREF."suppliers.supplier_id
WHERE stock_id = '" . $_POST['stock_id'] . "'";
$result = db_query($sql, "The supplier purchasing details for the selected part could not be retrieved");
if (db_num_rows($result) == 0)
{
display_note(_("There is no purchasing data set up for the part selected"));
}
else
{
start_table("$table_style width=60%");
$th = array(_("Supplier"), _("Price"), _("Currency"),
_("Supplier's Unit"), _("Supplier's Description"), "", "");
table_header($th);
$k = $j = 0; //row colour counter
while ($myrow = db_fetch($result))
{
alt_table_row_color($k);
label_cell($myrow["supp_name"]);
amount_cell($myrow["price"]);
label_cell($myrow["curr_code"]);
label_cell($myrow["suppliers_uom"]);
label_cell($myrow["supplier_description"]);
edit_link_cell("stock_id=" . $_POST['stock_id']. "&supplier_id=" . $myrow["supplier_id"] . "&Edit=1");
delete_link_cell("stock_id=" . $_POST['stock_id']. "&supplier_id=" . $myrow["supplier_id"] . "&Delete=1");
end_row();
$j++;
If ($j == 12)
{
$j = 1;
table_header($th);
} //end of page full new headings
} //end of while loop
end_table();
}
}
//------------------------------------------------------------------------------------------------
if (isset($_GET['Edit']))
{
$sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name FROM ".TB_PREF."purch_data
INNER JOIN ".TB_PREF."suppliers ON ".TB_PREF."purch_data.supplier_id=".TB_PREF."suppliers.supplier_id
WHERE ".TB_PREF."purch_data.supplier_id='$supplier_id'
AND ".TB_PREF."purch_data.stock_id='" . $_POST['stock_id'] . "'";
$result = db_query($sql, "The supplier purchasing details for the selected supplier and item could not be retrieved");
$myrow = db_fetch($result);
$supp_name = $myrow["supp_name"];
$_POST['price'] = price_format($myrow["price"]);
$_POST['suppliers_uom'] = $myrow["suppliers_uom"];
$_POST['supplier_description'] = $myrow["supplier_description"];
$_POST['conversion_factor'] = exrate_format($myrow["conversion_factor"]);
}
echo "
";
start_table($table_style2);
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);
if (!isset($_POST['conversion_factor']) || $_POST['conversion_factor'] == "")
{
$_POST['conversion_factor'] = exrate_format(1);
}
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);
end_table(1);
if (isset($_GET['Edit']))
{
submit_center('UpdateRecord', _("Update Purchasing Data"));
}
else
{
submit_center('AddRecord', _("Add Purchasing Data"));
}
end_form();
end_page();
?>