From 3f49464b1ee8f9945312ad098f59802d5fa5de99 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 03 四月 2023 12:03:12 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/controller/all/CrdsController.java | 25 +++++++++++++++++++++++++
src/main/java/com/lf/server/service/data/MetaService.java | 7 +++++++
src/main/java/com/lf/server/mapper/data/MetaMapper.java | 8 ++++++++
src/main/resources/mapper/data/MetaMapper.xml | 8 ++++++++
4 files changed, 48 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/all/CrdsController.java b/src/main/java/com/lf/server/controller/all/CrdsController.java
index 486b8ee..4fd8e09 100644
--- a/src/main/java/com/lf/server/controller/all/CrdsController.java
+++ b/src/main/java/com/lf/server/controller/all/CrdsController.java
@@ -4,10 +4,12 @@
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.all.StaticData;
import com.lf.server.entity.data.DirEntity;
+import com.lf.server.entity.data.MetaEntity;
import com.lf.server.helper.HttpHelper;
import com.lf.server.helper.StringHelper;
import com.lf.server.service.data.DirService;
import com.lf.server.service.data.FmeService;
+import com.lf.server.service.data.MetaService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
@@ -34,6 +36,9 @@
@Autowired
FmeService fmeService;
+
+ @Autowired
+ MetaService metaService;
@SysLog()
@ApiOperation(value = "鏌ヨ椤圭洰")
@@ -136,4 +141,24 @@
log.error(ex.getMessage(), ex);
}
}
+
+ @SysLog()
+ @ApiOperation(value = "鏍规嵁鐩綍缂栫爜鏌ヨ鍏冩暟鎹枃浠�")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "dircode", value = "鐩綍缂栫爜", dataType = "String", paramType = "query", example = "01")
+ })
+ @GetMapping(value = "/selectMetasByDirCode")
+ public ResponseMsg<Object> selectMetasByDirCode(String dircode) {
+ try {
+ if (StringHelper.isEmpty(dircode)) {
+ return fail("鐩綍缂栫爜涓嶈兘涓虹┖");
+ }
+
+ List<MetaEntity> list = metaService.selectMetasByDirCode(dircode);
+
+ return success(null == list ? 0 : list.size(), list);
+ } catch (Exception ex) {
+ return fail(ex, null);
+ }
+ }
}
diff --git a/src/main/java/com/lf/server/mapper/data/MetaMapper.java b/src/main/java/com/lf/server/mapper/data/MetaMapper.java
index 1b9dff3..d6bf72a 100644
--- a/src/main/java/com/lf/server/mapper/data/MetaMapper.java
+++ b/src/main/java/com/lf/server/mapper/data/MetaMapper.java
@@ -144,6 +144,14 @@
public List<MetaEntity> selectXlsAnnex(Integer[] ids, String tabs);
/**
+ * 鏍规嵁鐩綍缂栫爜鏌ヨ鍏冩暟鎹枃浠�
+ *
+ * @param dircode
+ * @return
+ */
+ public List<MetaEntity> selectMetasByDirCode(String dircode);
+
+ /**
* 鎻掑叆涓�鏉�
*
* @param entity
diff --git a/src/main/java/com/lf/server/service/data/MetaService.java b/src/main/java/com/lf/server/service/data/MetaService.java
index 0430656..ac5072d 100644
--- a/src/main/java/com/lf/server/service/data/MetaService.java
+++ b/src/main/java/com/lf/server/service/data/MetaService.java
@@ -119,6 +119,13 @@
}
@Override
+ public List<MetaEntity> selectMetasByDirCode(String dircode) {
+ dircode = StringHelper.getRightLike(dircode);
+
+ return metaMapper.selectMetasByDirCode(dircode);
+ }
+
+ @Override
public Integer insert(MetaEntity entity) {
return metaMapper.insert(entity);
}
diff --git a/src/main/resources/mapper/data/MetaMapper.xml b/src/main/resources/mapper/data/MetaMapper.xml
index 86ddaa5..b5a8a6a 100644
--- a/src/main/resources/mapper/data/MetaMapper.xml
+++ b/src/main/resources/mapper/data/MetaMapper.xml
@@ -174,6 +174,14 @@
</if>
</select>
+ <select id="selectMetasByDirCode" resultType="com.lf.server.entity.data.MetaEntity">
+ select a.*, fn_uname(a.create_user) uname, fn_get_fullname(a.depcode, 1) depName, fn_ver(a.verid) verName, fn_get_fullname(a.dircode, 2) dirName
+ from lf.sys_meta a
+ where dircode like #{dircode} and
+ (type = 'tif' or type = 'tiff' or lower(name) in ('骞抽潰鍥剧储寮曟枃浠�.xlsx', '绌胯法瓒婂湴褰㈠浘.dwg', '涓嚎鎴愭灉琛�.xlsx', '绂绘暎鐐�.xlsx', '鎺у埗鐐�.xlsx', '鍦伴潰绾�.xlsx'))
+ order by id;
+ </select>
+
<insert id="insert" parameterType="com.lf.server.entity.data.MetaEntity">
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
select currval('lf.sys_meta_id_seq'::regclass) as id
--
Gitblit v1.9.3