应急空间查询统计过滤

zhongrj

2024-12-03 b3dd0bb411415edcc95876305afcaf61f6aec4ba

应急空间查询统计过滤

 src/main/java/org/springblade/modules/yw/mapper/EmergencySpaceMapper.xml

@@ -47,6 +47,8 @@
        WHERE
            is_deleted = 0
            and type != 7
            and type != 9
            and type != 11
            AND type IS NOT NULL
            GROUP BY type
    </select>

 src/main/java/org/springblade/modules/yw/service/impl/IndParkInfoServiceImpl.java

@@ -167,7 +167,10 @@
     */
    private Integer getSpaceNum() {
        QueryWrapper<EmergencySpaceEntity> wrapper = new QueryWrapper<>();
        wrapper.eq("is_deleted",0).ne("type",7);
        wrapper.eq("is_deleted",0).
            ne("type",7)
            .ne("type",9)
            .ne("type",11);
        return (int)emergencySpaceService.count(wrapper);
    }