diff --git a/casic-iris-acs/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-iris-acs/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml index c9e6a78..0e9ea97 100644 --- a/casic-iris-acs/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml +++ b/casic-iris-acs/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml @@ -20,7 +20,7 @@ FROM recognition_records r LEFT JOIN bus_device d ON r.DEV_CODE = d.DEV_CODE LEFT JOIN person_ext_view p ON p.ID = r.PERSON_ID - WHERE r.INOUT_TYPE IS NOT NULL + WHERE r.INOUT_TYPE IS NOT NULL and r.INOUT_TYPE != '' AND p.DEPTID IN @@ -42,7 +42,7 @@ count(r.id) AS count FROM recognition_records r LEFT JOIN person_ext_view p ON p.ID = r.PERSON_ID - WHERE r.INOUT_TYPE IS NOT NULL + WHERE r.INOUT_TYPE IS NOT NULL and r.INOUT_TYPE != '' AND p.DEPTID IN