From 64d3e9657fb45b6415b19e23f483d46a82efe939 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 06 三月 2023 13:56:42 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/service/all/BaseQueryService.java |   77 +++++++++++++++++++++++++++-----------
 1 files changed, 55 insertions(+), 22 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 5f554f1..286df38 100644
--- a/src/main/java/com/lf/server/service/all/BaseQueryService.java
+++ b/src/main/java/com/lf/server/service/all/BaseQueryService.java
@@ -2,9 +2,9 @@
 
 import com.baomidou.mybatisplus.annotation.TableName;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.lf.server.entity.all.RedisCacheKey;
 import com.lf.server.entity.ctrl.IdNameEntity;
+import com.lf.server.entity.ctrl.KeyValueEntity;
 import com.lf.server.entity.ctrl.TabEntity;
 import com.lf.server.entity.data.DictEntity;
 import com.lf.server.entity.data.DomainEntity;
@@ -15,7 +15,6 @@
 import com.lf.server.mapper.all.BasicMapper;
 import com.lf.server.mapper.all.GeomBaseMapper;
 import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.data.redis.cache.RedisCache;
 import org.springframework.stereotype.Service;
 
 import java.util.HashMap;
@@ -73,19 +72,19 @@
     /**
      * 鑾峰彇鍊煎璞�
      *
-     * @param value 鍊�
+     * @param val 鍊�
      * @return 瀵硅薄
      */
-    private Object getObjectVal(String value) {
-        if (StringHelper.isInteger(value)) {
-            return Long.parseLong(value);
+    private Object getObjectVal(String val) {
+        if (StringHelper.isInteger(val)) {
+            return Long.parseLong(val);
         }
 
-        if (StringHelper.isNumeric(value)) {
-            return Double.parseDouble(value);
+        if (StringHelper.isNumeric(val)) {
+            return Double.parseDouble(val);
         }
 
-        return value.replace("'", "");
+        return val.replace("'", "");
     }
 
     /**
@@ -94,30 +93,36 @@
      * @param wrapper QueryWrapper
      * @param field   瀛楁
      * @param express 琛ㄨ揪寮�
-     * @param value   鍊�
+     * @param val     鍊�
      */
-    private void addWrapper(QueryWrapper wrapper, String field, String express, Object value) {
+    private void addWrapper(QueryWrapper wrapper, String field, String express, Object val) {
+        if (StringHelper.isDate(val.toString())) {
+            wrapper.apply(String.format("%s %s '%s'", field, express, val));
+            return;
+        }
+
         switch (express) {
             case "like":
-                wrapper.like(field, value);
+                wrapper.like("UPPER(" + field + ")", val.toString().toUpperCase());
                 break;
             case ">":
-                wrapper.gt(field, value);
+                wrapper.gt(field, val);
                 break;
             case ">=":
-                wrapper.ge(field, value);
+                wrapper.ge(field, val);
                 break;
             case "<>":
-                wrapper.ne(field, value);
+            case "!=":
+                wrapper.ne(field, val);
                 break;
             case "=":
-                wrapper.eq(field, value);
+                wrapper.eq(field, val);
                 break;
             case "<":
-                wrapper.lt(field, value);
+                wrapper.lt(field, val);
                 break;
             case "<=":
-                wrapper.le(field, value);
+                wrapper.le(field, val);
                 break;
             default:
                 break;
@@ -137,7 +142,9 @@
             wkt = AesHelper.decrypt(wkt);
 
             Integer srid = getSrid((GeomBaseMapper) basicMapper);
-            wrapper.apply(String.format("ST_Intersects(ST_PolygonFromText('%s', %d), geom)", wkt, srid));
+            if (null != srid) {
+                wrapper.apply(String.format("ST_Intersects(ST_PolygonFromText('%s', %d), geom)", wkt, srid));
+            }
         }
     }
 
@@ -147,7 +154,7 @@
      * @param basicMapper 绌洪棿鍩虹Mapper
      * @return SRID
      */
-    private Integer getSrid(GeomBaseMapper basicMapper) {
+    public Integer getSrid(GeomBaseMapper basicMapper) {
         String tab = getTabName(basicMapper);
         String key = RedisCacheKey.sridKey(tab);
 
@@ -216,8 +223,17 @@
     }
 
     @Override
-    public List<TabEntity> selectTabs() {
-        return baseQueryMapper.selectTabs();
+    public Integer selectTabsForCount(String tab, String field) {
+        tab = StringHelper.getLikeStr(tab);
+
+        return baseQueryMapper.selectTabsForCount(tab, field);
+    }
+
+    @Override
+    public List<TabEntity> selectTabsByPage(String tab, String field, String filters, Integer limit, Integer offset) {
+        tab = StringHelper.getLikeStr(tab);
+
+        return baseQueryMapper.selectTabsByPage(tab, field, filters, limit, offset);
     }
 
     @Override
@@ -229,4 +245,21 @@
     public List<DomainEntity> selectDomains(String ns, String tab) {
         return baseQueryMapper.selectDomains(ns, tab);
     }
+
+    @Override
+    public String selectRoute(double x1, double y1, double x2, double y2) {
+        return baseQueryMapper.selectRoute(x1, y1, x2, y2);
+    }
+
+    @Override
+    public List<KeyValueEntity> selectLocation(String wkt) {
+        return baseQueryMapper.selectLocation(wkt);
+    }
+
+    @Override
+    public List<KeyValueEntity> selectDirTypes(String name) {
+        name = StringHelper.getLikeStr(name);
+
+        return baseQueryMapper.selectDirTypes(name);
+    }
 }

--
Gitblit v1.9.3