From aa4466d3497f57e0ce8c737dde4a34f5f1bde837 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 24 十二月 2022 11:15:21 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/service/show/DataLibService.java | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/lf/server/service/show/DataLibService.java b/src/main/java/com/lf/server/service/show/DataLibService.java index 2f4e354..d099587 100644 --- a/src/main/java/com/lf/server/service/show/DataLibService.java +++ b/src/main/java/com/lf/server/service/show/DataLibService.java @@ -53,14 +53,15 @@ QueryWrapper wrapper = new QueryWrapper(); wrapper.select("depid"); wrapper.gt("depid", 0); - wrapper.apply(String.format("depid != ALL(fn_rec_array(%d, 'dep')", ue.getDepid())); + wrapper.apply(String.format("depid != ALL(fn_rec_array(%d, 'dep'))", ue.getDepid())); + wrapper.groupBy("depid"); Integer srid = baseQueryService.getSrid(baseMapper); if (null != srid) { wrapper.apply(String.format("ST_Intersects(ST_PolygonFromText('%s', %d), geom)", wkt, srid)); } - List<Integer> ids = baseMapper.selectList(wrapper); + List<Integer> ids = baseMapper.selectObjs(wrapper); addDepIds(rs, ids); } catch (Exception ex) { -- Gitblit v1.9.3