-function add_material_cost($parent, $item, $n, $add=true)
-{
- $sql = "SELECT material_cost FROM ".TB_PREF."stock_master WHERE stock_id='$parent'";
- $result = db_query($sql);
- $myrow = db_fetch($result);
- $material_cost = $myrow['material_cost'];
- $sql = "SELECT material_cost FROM ".TB_PREF."stock_master WHERE stock_id='$item'";
- $result = db_query($sql);
- $myrow = db_fetch($result);
- $material_cost2 = $myrow['material_cost'];
- if ($add)
- $material_cost += ($material_cost2 * $n);
- else
- $material_cost -= ($material_cost2 * $n);
- $sql = "UPDATE ".TB_PREF."stock_master SET material_cost=$material_cost
- WHERE stock_id='$parent'";
- db_query($sql,"The cost details for the inventory item could not be updated");
-}