Fixed costs display in work order view.

[fa-stable.git] / manufacturing / includes / db / work_order_issues_db.inc

diff --git a/manufacturing/includes/db/work_order_issues_db.inc b/manufacturing/includes/db/work_order_issues_db.inc
index b980781acefa6f194089dd8194f777c18b81497b..4c6b4612abeee18c009ba41ace6a1ddb45c6deca 100644 (file)
--- a/manufacturing/includes/db/work_order_issues_db.inc
+++ b/manufacturing/includes/db/work_order_issues_db.inc
@@ -102,9 +102,10 @@ function get_work_order_issues($woid)
 
 function get_additional_issues($woid)
 {
-       $sql = "SELECT issue.*, item.*
+       $sql = "SELECT issue.*, item.*, stock.mb_flag
                FROM ".TB_PREF."wo_issues issue, "
                        .TB_PREF."wo_issue_items item
+                       LEFT JOIN ".TB_PREF."stock_master stock ON stock.stock_id=item.stock_id
                WHERE issue.issue_no=item.issue_id
                AND issue.workorder_id=".db_escape($woid)
                ." ORDER BY item.id";