" . _("Select an item to display its parent item(s).") . " ";
stock_items_list('stock_id', $_POST['stock_id'], false, true);
echo "
";
set_global_stock_item($_POST['stock_id']);
//-----------------------------------------------------------------------------
function select_link($row)
{
return pager_link( $row["parent"]. " - " . $row["description"],
"/manufacturing/manage/bom_edit.php?stock_id=" . $row["parent"]);
}
$sql = "SELECT
bom.parent,
workcentre.name As WorkCentreName,
location.location_name,
bom.quantity,
parent.description
FROM ".TB_PREF."bom as bom, "
.TB_PREF."stock_master as parent, "
.TB_PREF."workcentres as workcentre, "
.TB_PREF."locations as location
WHERE bom.parent = parent.stock_id
AND bom.workcentre_added = workcentre.id
AND bom.loc_code = location.loc_code
AND bom.component='" . $_POST['stock_id'] . "'";
$cols = array(
_("Parent Item") => array('fun'=>'select_link'),
_("Work Centre"),
_("Location"),
_("Quantity Required")
);
$table =& new_db_pager('usage_table', $sql, $cols);
if (get_post('_stock_id_update'))
$table->set_sql($sql);
display_db_pager($table);
end_form();
end_page();
?>