activate('_page_body');
}
if (isset($_POST['_stock_id_update']))
$Ajax->activate('price_table');
//--------------------------------------------------------------------------------------------------
start_form(false, true);
if (!isset($_POST['stock_id']))
$_POST['stock_id'] = get_global_stock_item();
echo "" . _("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."));
set_focus('stock_id');
}
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");
div_start('price_table');
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_button_cell("Edit".$myrow['supplier_id'], _("Edit"));
edit_button_cell("Delete".$myrow['supplier_id'], _("Delete"));
end_row();
$j++;
If ($j == 12)
{
$j = 1;
table_header($th);
} //end of page full new headings
} //end of while loop
end_table();
}
div_end();
}
//-----------------------------------------------------------------------------------------------
if ($Mode =='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='$selected_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 "
";
hidden('selected_id', $selected_id);
start_table($table_style2);
if ($Mode == 'Edit')
{
hidden('supplier_id');
label_row(_("Supplier:"), $supp_name);
}
else
{
supplier_list_row(_("Supplier:"), 'supplier_id', null, false, true);
}
amount_row(_("Price:"), 'price', null,'', get_supplier_currency($selected_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);
submit_add_or_update_center($selected_id == -1, '', true);
end_form();
end_page();
?>