From 652a5eca0e6df9a565eb98026ba320dc3638cd11 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 16 三月 2023 09:17:12 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/all/BaseQueryService.java | 26 ++++++++++++++++++++++----
1 files changed, 22 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/lf/server/service/all/BaseQueryService.java b/src/main/java/com/lf/server/service/all/BaseQueryService.java
index dd28da0..06de9db 100644
--- a/src/main/java/com/lf/server/service/all/BaseQueryService.java
+++ b/src/main/java/com/lf/server/service/all/BaseQueryService.java
@@ -208,6 +208,24 @@
return tabName;
}
+ /**
+ * 娣诲姞缂撳啿鍖鸿繃婊ゆ潯浠�
+ *
+ * @param baseMapper 鐖禡apper
+ * @param wrapper QueryWrapper
+ * @param wkt WKT锛堣憲鍚嶆枃鏈級
+ */
+ public void addBufferWrapper(GeomBaseMapper baseMapper, QueryWrapper wrapper, String wkt, double buffer) {
+ Integer srid = getSrid(baseMapper);
+ if (null == srid) {
+ srid = 4490;
+ }
+ // buffer = buffer * 0.00000899928
+ buffer = buffer / 1852 / 60;
+
+ wrapper.apply(String.format("ST_Intersects(geom, ST_Buffer(ST_GeomFromText('%s', %d), %f, 'endcap=round join=round'))", wkt, srid, buffer));
+ }
+
@Override
public List<IdNameEntity> selectUserFuzzy(String name) {
name = StringHelper.getLikeStr(name);
@@ -223,17 +241,17 @@
}
@Override
- public Integer selectTabsForCount(String tab) {
+ public Integer selectTabsForCount(String tab, String field) {
tab = StringHelper.getLikeStr(tab);
- return baseQueryMapper.selectTabsForCount(tab);
+ return baseQueryMapper.selectTabsForCount(tab, field);
}
@Override
- public List<TabEntity> selectTabsByPage(String tab, String filters, Integer limit, Integer offset) {
+ public List<TabEntity> selectTabsByPage(String tab, String field, String filters, Integer limit, Integer offset) {
tab = StringHelper.getLikeStr(tab);
- return baseQueryMapper.selectTabsByPage(tab, filters, limit, offset);
+ return baseQueryMapper.selectTabsByPage(tab, field, filters, limit, offset);
}
@Override
--
Gitblit v1.9.3