X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_order_produce_items_db.inc;h=5b2dad2dbaba4f60b3d8e0192d910c8c9a3418dd;hb=a5242af68e65661edb7175412444dce536a7f311;hp=8c3f8d073898da2fe1c3013ef36dbe15216def49;hpb=46d3debec422c5ad5ee99c4acfe42bfa60308afb;p=fa-stable.git diff --git a/manufacturing/includes/db/work_order_produce_items_db.inc b/manufacturing/includes/db/work_order_produce_items_db.inc index 8c3f8d07..5b2dad2d 100644 --- a/manufacturing/includes/db/work_order_produce_items_db.inc +++ b/manufacturing/includes/db/work_order_produce_items_db.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ function work_order_produce($woid, $ref, $quantity, $date_, $memo_, $close_wo) { begin_transaction(); @@ -22,7 +31,7 @@ function work_order_produce($woid, $ref, $quantity, $date_, $memo_, $close_wo) $date = date2sql($date_); $sql = "INSERT INTO ".TB_PREF."wo_manufacture (workorder_id, reference, quantity, date_) - VALUES ($woid, ".db_quote($ref).", $quantity, '$date')"; + VALUES ($woid, ".db_escape($ref).", $quantity, '$date')"; db_query($sql,"A work order manufacture could not be added"); @@ -36,6 +45,11 @@ function work_order_produce($woid, $ref, $quantity, $date_, $memo_, $close_wo) // update wo quantity and close wo if requested work_order_update_finished_quantity($woid, $quantity, $close_wo); + // ------------------------------------------------------------------------- + + work_order_quick_costs($woid, $details["stock_id"], $quantity, $date_, 0, true); + + // ------------------------------------------------------------------------- if ($memo_) add_comments(29, $id, $date_, $memo_);