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