1、破损数量查询添加过滤条件

ZengTao

2025-09-04 7d60fb2b0b9ed9789454b5d98b6818d68c2af9d1

1、破损数量查询添加过滤条件

 hangzhoumesParent/moduleService/hollowGlassModule/src/main/resources/mapper/HollowGlassRelationInfoMapper.xml

@@ -141,7 +141,7 @@
                        order_number      as order_sort,
                        count(1)          as damage_count
                 from damage
                 where process_id = #{flowCardId}
                 where process_id = #{flowCardId} and type in (8,9) and status < 3
                 group by process_id, technology_number, order_number
             ),
             result_count as (