From 6e15fb58d1530c5dc28be872f950b2d5758246f8 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 27 十一月 2022 08:50:48 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/controller/data/DataLoaderController.java |  105 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 105 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/lf/server/controller/data/DataLoaderController.java b/src/main/java/com/lf/server/controller/data/DataLoaderController.java
index 0dc18f5..1317a43 100644
--- a/src/main/java/com/lf/server/controller/data/DataLoaderController.java
+++ b/src/main/java/com/lf/server/controller/data/DataLoaderController.java
@@ -6,12 +6,17 @@
 import com.lf.server.entity.ctrl.TabEntity;
 import com.lf.server.entity.ctrl.TabMapperEntity;
 import com.lf.server.entity.ctrl.UploadEntity;
+import com.lf.server.entity.data.DictEntity;
 import com.lf.server.entity.data.MetaEntity;
+import com.lf.server.entity.data.MetaFileEntity;
 import com.lf.server.entity.sys.UserEntity;
+import com.lf.server.helper.ClassHelper;
 import com.lf.server.helper.StringHelper;
 import com.lf.server.helper.WebHelper;
+import com.lf.server.mapper.all.BasicMapper;
 import com.lf.server.service.all.BaseQueryService;
 import com.lf.server.service.data.DataLoaderService;
+import com.lf.server.service.data.MetaService;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiImplicitParam;
 import io.swagger.annotations.ApiImplicitParams;
@@ -20,6 +25,8 @@
 import org.springframework.web.bind.annotation.*;
 
 import javax.servlet.http.HttpServletRequest;
+import java.util.ArrayList;
+import java.util.Arrays;
 import java.util.Date;
 import java.util.List;
 
@@ -32,10 +39,62 @@
 @RequestMapping("/dataLoader")
 public class DataLoaderController extends BaseUploadController {
     @Autowired
+    MetaService metaService;
+
+    @Autowired
     BaseQueryService baseQueryService;
 
     @Autowired
     DataLoaderService dataLoaderService;
+
+    private final static String FILE_TYPES = "'xls','shp','gdb','mdb'";
+
+    public static List<String> extList = new ArrayList<>(Arrays.asList(".xls", ".xlsx", ".mdb", ".zip"));
+
+    @SysLog()
+    @ApiOperation(value = "鍒嗛〉鏌ヨ涓婁紶鏁版嵁骞惰繑鍥炶褰曟暟")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "name", value = "鍚嶇О", dataType = "String", paramType = "query", example = ""),
+            @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10"),
+            @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1")
+    })
+    @GetMapping(value = "/selectByPageForUpload")
+    public ResponseMsg<Object> selectByPageForUpload(String name, Integer pageSize, Integer pageIndex, HttpServletRequest req) {
+        try {
+            if (pageSize < 1 || pageIndex < 1) {
+                return fail("姣忛〉椤垫暟鎴栧垎椤垫暟灏忎簬1", null);
+            }
+
+            UserEntity ue = tokenService.getCurrentUser(req);
+
+            int count = metaService.selectCountForUpload(name, ue.getId(), FILE_TYPES);
+            if (count == 0) {
+                return success(0, null);
+            }
+
+            List<MetaEntity> list = metaService.selectByPageForUpload(name, ue.getId(), FILE_TYPES, pageSize, pageSize * (pageIndex - 1));
+
+            return success(count, list);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), null);
+        }
+    }
+
+    @SysLog()
+    @ApiOperation(value = "鏌ヨ鏂囦欢")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "path", value = "璺緞", dataType = "String", paramType = "query")
+    })
+    @GetMapping(value = "/selectFiles")
+    public ResponseMsg<List<MetaFileEntity>> selectFiles(String path) {
+        try {
+            List<MetaFileEntity> list = baseUploadService.selectFiles(path, extList);
+
+            return success(list);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), null);
+        }
+    }
 
     @SysLog()
     @ApiOperation(value = "鏌ヨ鎵�鏈夎〃")
@@ -99,4 +158,50 @@
             return fail(ex.getMessage(), null);
         }
     }
+
+    @SysLog()
+    @ApiOperation(value = "鏌ヨ琛ㄤ腑鏁版嵁")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "id", value = "鍏冩暟鎹甀D", dataType = "Integer", paramType = "1")
+    })
+    @GetMapping(value = "/selectDbData")
+    public ResponseMsg<Object> selectDbData(Integer id) {
+        try {
+            if (null == id || id < 0) {
+                return fail("鍏冩暟鎹甀D涓嶈兘涓虹┖鎴栧皬浜�0", null);
+            }
+
+            MetaEntity meta = metaService.selectById(id);
+            if (null == meta || null == meta.getTab() || meta.getTab().indexOf(".") < 0) {
+                return fail("鎵句笉鍒板厓鏁版嵁淇℃伅", null);
+            }
+
+            String entity = meta.getTab().split(".")[1].replace("_", "").toLowerCase();
+
+            return success(null);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), null);
+        }
+    }
+
+    @SysLog()
+    @ApiOperation(value = "鏌ヨ瀛楁淇℃伅")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "ns", value = "鍚嶇О绌洪棿", dataType = "String", paramType = "query", example = "bd"),
+            @ApiImplicitParam(name = "tab", value = "琛ㄥ悕", dataType = "String", paramType = "query", example = "dlg25wAanp")
+    })
+    @GetMapping(value = "/selectFields")
+    public ResponseMsg<List<DictEntity>> selectFields(String ns, String tab) {
+        try {
+            if (StringHelper.isEmpty(ns) || StringHelper.isEmpty(tab)) {
+                return fail("鍚嶇О绌洪棿鍜岃〃鍚嶄笉鑳戒负绌�", null);
+            }
+
+            List<DictEntity> list = baseQueryService.selectFields(ns, tab);
+
+            return success(list);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), null);
+        }
+    }
 }

--
Gitblit v1.9.3