- AND (trans.type=".ST_CUSTDELIVERY." OR move.type=".ST_CUSTCREDIT.")
- AND (item.mb_flag='B' OR item.mb_flag='M')";
- if ($category != 0)
- $sql .= " AND item.category_id = ".db_escape($category);
- if ($location != '')
- $sql .= " AND move.loc_code = ".db_escape($location);
- if ($fromcust != '')
- $sql .= " AND debtor.debtor_no = ".db_escape($fromcust);
- $sql .= " GROUP BY item.stock_id, debtor.name ORDER BY item.category_id,
- item.stock_id, debtor.name";
+ AND (trans.type=".ST_CUSTDELIVERY." OR move.type=".ST_CUSTCREDIT.")";
+
+ if (!$show_service)
+ $sql .= " AND (item.mb_flag='B' OR item.mb_flag='M')";
+ else
+ $sql .= " AND item.mb_flag<>'F'";
+ if ($category != 0)
+ $sql .= " AND item.category_id = ".db_escape($category);
+
+ if ($location != '')
+ $sql .= " AND move.loc_code = ".db_escape($location);
+
+ if ($fromcust != '')
+ $sql .= " AND debtor.debtor_no = ".db_escape($fromcust);
+
+ $sql .= " GROUP BY item.stock_id, debtor.name ORDER BY item.category_id,
+ item.stock_id, debtor.name";
+