From e54ef5e185c46a35641dce47b792c4f20b98879a Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 02 十一月 2022 19:08:25 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/controller/all/BaseQueryController.java |   83 +++++++++++++++++++++++++++++++++++++++--
 1 files changed, 78 insertions(+), 5 deletions(-)

diff --git a/src/main/java/com/lf/server/controller/all/BaseQueryController.java b/src/main/java/com/lf/server/controller/all/BaseQueryController.java
index af9ce21..1c9ac49 100644
--- a/src/main/java/com/lf/server/controller/all/BaseQueryController.java
+++ b/src/main/java/com/lf/server/controller/all/BaseQueryController.java
@@ -7,6 +7,9 @@
 import com.lf.server.aspect.SysLog;
 import com.lf.server.entity.all.ResponseMsg;
 import com.lf.server.entity.ctrl.IdNameEntity;
+import com.lf.server.entity.ctrl.TabEntity;
+import com.lf.server.entity.data.DictEntity;
+import com.lf.server.entity.data.DomainEntity;
 import com.lf.server.helper.AesHelper;
 import com.lf.server.helper.StringHelper;
 import com.lf.server.mapper.all.BasicMapper;
@@ -140,8 +143,11 @@
             if (StringHelper.isEmpty(field) || StringHelper.isSqlInjection(field)) {
                 return fail("鏌ヨ瀛楁涓嶆纭�", null);
             }
+            if (!StringHelper.isEmpty(value)) {
+                value = value.trim().replace("'", "");
+            }
 
-            value = value == null ? StringHelper.getLikeStr("") : StringHelper.getLikeStr(value.replace("'", ""));
+            value = StringHelper.getLikeStr2(value);
             List<String> rs = baseMapper.selectFieldFuzzy(tab, field, value);
 
             return success(rs);
@@ -155,10 +161,10 @@
     @ApiImplicitParams({
             @ApiImplicitParam(name = "name", value = "鐢ㄦ埛鍚�", dataType = "String", paramType = "query", example = "瀹�")
     })
-    @GetMapping(value = "/selectFieldFuzzy")
+    @GetMapping(value = "/selectUserFuzzy")
     public ResponseMsg<List<IdNameEntity>> selectUserFuzzy(String name) {
         try {
-            List<IdNameEntity> rs = null;
+            List<IdNameEntity> rs = baseQueryService.selectUserFuzzy(name);
 
             return success(rs);
         } catch (Exception ex) {
@@ -171,14 +177,81 @@
     @ApiImplicitParams({
             @ApiImplicitParam(name = "name", value = "鍗曚綅鍚�", dataType = "String", paramType = "query", example = "鍙�")
     })
-    @GetMapping(value = "/selectFieldFuzzy")
+    @GetMapping(value = "/selectDepFuzzy")
     public ResponseMsg<List<IdNameEntity>> selectDepFuzzy(String name) {
         try {
-            List<IdNameEntity> rs = null;
+            List<IdNameEntity> rs = baseQueryService.selectDepFuzzy(name);
 
             return success(rs);
         } catch (Exception ex) {
             return fail(ex.getMessage(), null);
         }
     }
+
+    @SysLog()
+    @ApiOperation(value = "鏌ヨ鎵�鏈夎〃")
+    @GetMapping(value = "/selectTabs")
+    public ResponseMsg<List<TabEntity>> selectTabs() {
+        try {
+            List<TabEntity> list = baseQueryService.selectTabs();
+
+            return success(list);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), null);
+        }
+    }
+
+    @SysLog()
+    @ApiOperation(value = "鏌ヨ瀛楁淇℃伅")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "name", value = "鏄犲皠鍚嶇О", dataType = "String", paramType = "query", example = "dlgAgnp")
+    })
+    @GetMapping(value = "/selectFields")
+    public ResponseMsg<List<DictEntity>> selectFields(String name) {
+        try {
+            BasicMapper baseMapper = baseQueryService.getBasicMapper(name);
+            if (baseMapper == null) {
+                return fail("鏌ヨ瀵硅薄涓嶅瓨鍦�", null);
+            }
+
+            String tabName = baseQueryService.getTabName(baseMapper);
+            if (tabName == null) {
+                return null;
+            }
+
+            String[] strs = tabName.split(".");
+            List<DictEntity> list = baseQueryService.selectFields(strs[0], strs[1]);
+
+            return success(list);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), null);
+        }
+    }
+
+    @SysLog()
+    @ApiOperation(value = "鏌ヨ鍊煎煙淇℃伅")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "name", value = "鏄犲皠鍚嶇О", dataType = "String", paramType = "query", example = "dlgAgnp")
+    })
+    @GetMapping(value = "/selectDomains")
+    public ResponseMsg<List<DomainEntity>> selectDomains(String name) {
+        try {
+            BasicMapper baseMapper = baseQueryService.getBasicMapper(name);
+            if (baseMapper == null) {
+                return fail("鏌ヨ瀵硅薄涓嶅瓨鍦�", null);
+            }
+
+            String tabName = baseQueryService.getTabName(baseMapper);
+            if (tabName == null) {
+                return null;
+            }
+
+            String[] strs = tabName.split(".");
+            List<DomainEntity> list = baseQueryService.selectDomains(strs[0], strs[1]);
+
+            return success(list);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), null);
+        }
+    }
 }

--
Gitblit v1.9.3