From 184f466626a5892a3e0baf809aae6cfba8f43a59 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 08 三月 2023 15:23:48 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/controller/show/ComprehensiveController.java |   52 +++++++++++++++++++++++++++++++++++++++++++++++++---
 src/main/java/com/lf/server/entity/all/StaticData.java                   |    2 +-
 pom.xml                                                                  |    6 ++++++
 3 files changed, 56 insertions(+), 4 deletions(-)

diff --git a/pom.xml b/pom.xml
index 1e20d79..cca4ce0 100644
--- a/pom.xml
+++ b/pom.xml
@@ -248,6 +248,12 @@
             <artifactId>poi-ooxml</artifactId>
             <version>3.16</version>
         </dependency>
+        <!--SQLite-->
+        <dependency>
+            <groupId>org.xerial</groupId>
+            <artifactId>sqlite-jdbc</artifactId>
+            <version>3.36.0.3</version>
+        </dependency>
     </dependencies>
 
     <build>
diff --git a/src/main/java/com/lf/server/controller/show/ComprehensiveController.java b/src/main/java/com/lf/server/controller/show/ComprehensiveController.java
index ff88ebd..4c45a5a 100644
--- a/src/main/java/com/lf/server/controller/show/ComprehensiveController.java
+++ b/src/main/java/com/lf/server/controller/show/ComprehensiveController.java
@@ -9,6 +9,7 @@
 import com.lf.server.entity.data.DownloadEntity;
 import com.lf.server.entity.data.MetaFileEntity;
 import com.lf.server.entity.show.PipelineEntity;
+import com.lf.server.entity.sys.AttachEntity;
 import com.lf.server.entity.sys.UserEntity;
 import com.lf.server.helper.StringHelper;
 import com.lf.server.helper.WebHelper;
@@ -19,6 +20,7 @@
 import com.lf.server.service.data.DownloadService;
 import com.lf.server.service.show.MarkService;
 import com.lf.server.service.show.PipelineService;
+import com.lf.server.service.sys.AttachService;
 import com.lf.server.service.sys.DownlogService;
 import com.lf.server.service.sys.TokenService;
 import io.swagger.annotations.Api;
@@ -51,7 +53,7 @@
     TokenService tokenService;
 
     @Autowired
-    BaseUploadService baseUploadService;
+    AttachService attachService;
 
     @Autowired
     DownlogService downlogService;
@@ -63,10 +65,13 @@
     PipelineService pipelineService;
 
     @Autowired
-    UploadAttachService uploadAttachService;
+    DataQueryService dataQueryService;
 
     @Autowired
-    DataQueryService dataQueryService;
+    BaseUploadService baseUploadService;
+
+    @Autowired
+    UploadAttachService uploadAttachService;
 
     @SysLog()
     @ApiOperation(value = "鏌ヨ绠$嚎")
@@ -266,4 +271,45 @@
             return fail(ex, null);
         }
     }
+
+    @SysLog()
+    @ApiOperation(value = "鏌ヨ鏂囦欢")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "tabName", value = "琛ㄥ悕", dataType = "String", paramType = "query", example = "lf.sys_style"),
+            @ApiImplicitParam(name = "eventid", value = "涓婚敭", dataType = "String", paramType = "query", example = "fa25979a5ef8b43ba82a0be35b3fb0d4")
+    })
+    @GetMapping(value = "/selectFiles")
+    public ResponseMsg<List<AttachEntity>> selectFiles(String tabName, String eventid) {
+        try {
+            if (StringHelper.isEmpty(tabName) || StringHelper.isEmpty(eventid)) {
+                return fail("鍙傛暟涓嶈兘涓虹┖", null);
+            }
+
+            List<AttachEntity> list = attachService.selectByTab(tabName, eventid);
+
+            return success(list);
+        } catch (Exception ex) {
+            return fail(ex, null);
+        }
+    }
+
+    @SysLog()
+    @ApiOperation(value = "鍒犻櫎鏂囦欢")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "ids", value = "ID鏁扮粍", dataType = "Integer", paramType = "query", example = "1,2")
+    })
+    @GetMapping(value = "/deletes")
+    public ResponseMsg<Integer> deleteFiles(@RequestParam List<Integer> ids) {
+        try {
+            if (ids == null || ids.isEmpty()) {
+                return fail("id鏁扮粍涓嶈兘涓虹┖", -1);
+            }
+
+            int rows = attachService.deletes(ids);
+
+            return success(rows);
+        } catch (Exception ex) {
+            return fail(ex, 0);
+        }
+    }
 }
diff --git a/src/main/java/com/lf/server/entity/all/StaticData.java b/src/main/java/com/lf/server/entity/all/StaticData.java
index bf3f130..2ce2e2b 100644
--- a/src/main/java/com/lf/server/entity/all/StaticData.java
+++ b/src/main/java/com/lf/server/entity/all/StaticData.java
@@ -216,7 +216,7 @@
     /**
      * 鎵�鏈夋枃浠舵墿灞曞悕
      */
-    public final static List<String> ALL_EXTENSION = new ArrayList<>(Arrays.asList(".txt", ".xml", ".pdf", ".xls", ".xlsx", ".doc", ".docx", ".ppt", ".pptx", ".shp", ".gdb", ".mdb", ".dwg", ".las", ".laz", ".cpt", ".mpt", ".fly", ".efb", ".g3d", ".fbx", ".obj", ".3dm", ".3dml", ".osgb", ".rvt", ".ifc", ".jpg", ".png", ".img", ".tif", ".tiff", ".bmp", ".gif", ".rmvb", ".rm", ".mp3", ".mp4", ".avi", ".wma", ".wmv", ".7z", ".rar", ".zip"));
+    public final static List<String> ALL_EXTENSION = new ArrayList<>(Arrays.asList(".txt", ".xml", ".pdf", ".xls", ".xlsx", ".doc", ".docx", ".ppt", ".pptx", ".shp", ".gdb", ".mdb", ".dwg", ".las", ".laz", ".cpt", ".mpt", ".fly", ".efb", ".g3d", ".fbx", ".obj", ".3dm", ".3dml", ".osgb", ".rvt", ".ifc", ".jpg", ".png", ".img", ".tif", ".tiff", ".dem", ".bmp", ".gif", ".rmvb", ".rm", ".mp3", ".mp4", ".avi", ".wma", ".wmv", ".7z", ".rar", ".zip"));
 
     /**
      * 鎻掑叆鎺掗櫎瀛楁

--
Gitblit v1.9.3