| | |
|---|
| | | 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) { |
|---|
