- // create Work Order Requirements based on the bom
- $result = get_bom($stock_id);
-
- while ($myrow = db_fetch($result))
- {
-
- $sql = "INSERT INTO ".TB_PREF."wo_requirements (workorder_id, stock_id, workcentre, units_req, loc_code)
- VALUES (".db_escape($woid).", '" .
- $myrow["component"] . "', '" .
- $myrow["workcentre_added"] . "', '" .
- $myrow["quantity"] . "', '" .
- $myrow["loc_code"] . "')";
-
- db_query($sql, "The work order requirements could not be added");
- }
+ $sql = "INSERT INTO ".TB_PREF."wo_requirements (workorder_id, stock_id, workcentre, units_req, loc_code)
+ SELECT ".db_escape($woid).", component, workcentre_added, quantity, loc_code
+ FROM ".TB_PREF."bom WHERE parent=".db_escape($stock_id);
+
+ db_query($sql, "The work order requirements could not be added");