X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_order_requirements_db.inc;h=a722c1ed96465a5b4fbd5e2e13111d48b392e1c5;hb=de09a35c9e55aceaf1c71052cbb40f44e4b3bbc7;hp=ba53b5a2b2e69192a086342608545835560790c8;hpb=54d84ff9a67620ab38c676cdbcf87853632724f0;p=fa-stable.git diff --git a/manufacturing/includes/db/work_order_requirements_db.inc b/manufacturing/includes/db/work_order_requirements_db.inc index ba53b5a2..a722c1ed 100644 --- a/manufacturing/includes/db/work_order_requirements_db.inc +++ b/manufacturing/includes/db/work_order_requirements_db.inc @@ -57,10 +57,10 @@ function delete_wo_requirements($woid) //-------------------------------------------------------------------------------------- -function update_wo_requirement_issued($woReqID, $quantity) +function update_wo_requirement_issued($woid, $stock_id, $quantity) { $sql = "UPDATE ".TB_PREF."wo_requirements SET units_issued = units_issued + ".db_escape($quantity)." - WHERE id = ".db_escape($woReqID); + WHERE workorder_id = ".db_escape($woid)." AND stock_id = ".db_escape($stock_id); db_query($sql, "The work requirements issued quantity couldn't be updated"); }