统计库存 加入valid_flag = 1

lyfO_o

2021-06-18 7bef4a9e3388166d8f2e7031496c2532140cd03e

统计库存 加入valid_flag = 1

 src/main/java/com/nanometer/smartlab/dao/OpeWarehouseReserveDao.xml

@@ -213,6 +213,7 @@
        from ope_warehouse_reserve as owr
        where owr.reserve > 0
        and owr.reagent_id = #{id}
        and owr.valid_flag = 1
        group by owr.reagent_id
    </select>