From f913d44fbf160caafde4de10a8406d7908dfecd6 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 04 十二月 2023 09:19:24 +0800
Subject: [PATCH] 修改查询GDB文件接口
---
src/main/java/com/moon/server/mapper/data/MetaMapper.java | 2 +-
src/main/java/com/moon/server/service/data/MetaService.java | 6 +++++-
src/main/resources/mapper/data/MetaMapper.xml | 5 +----
3 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/moon/server/mapper/data/MetaMapper.java b/src/main/java/com/moon/server/mapper/data/MetaMapper.java
index e2b2c19..d274c3d 100644
--- a/src/main/java/com/moon/server/mapper/data/MetaMapper.java
+++ b/src/main/java/com/moon/server/mapper/data/MetaMapper.java
@@ -160,7 +160,7 @@
* @param ids 鍏冩暟鎹甀D闆嗗悎
* @return 鍏冩暟鎹枃浠堕泦鍚�
*/
- public List<MetaEntity> selectMetaFiles(List<Integer> ids);
+ public List<MetaEntity> selectMetaFiles(String ids);
/**
* 鏌ヨExcel鍏冩暟鎹�
diff --git a/src/main/java/com/moon/server/service/data/MetaService.java b/src/main/java/com/moon/server/service/data/MetaService.java
index 26001a3..6d209c3 100644
--- a/src/main/java/com/moon/server/service/data/MetaService.java
+++ b/src/main/java/com/moon/server/service/data/MetaService.java
@@ -134,8 +134,12 @@
return metaMapper.selectByIdsForTab(ids);
}
- @Override
public List<MetaEntity> selectMetaFiles(List<Integer> ids) {
+ return metaMapper.selectMetaFiles(StringHelper.join(ids, StaticData.COMMA));
+ }
+
+ @Override
+ public List<MetaEntity> selectMetaFiles(String ids) {
return metaMapper.selectMetaFiles(ids);
}
diff --git a/src/main/resources/mapper/data/MetaMapper.xml b/src/main/resources/mapper/data/MetaMapper.xml
index 753778c..a2b1667 100644
--- a/src/main/resources/mapper/data/MetaMapper.xml
+++ b/src/main/resources/mapper/data/MetaMapper.xml
@@ -203,10 +203,7 @@
<select id="selectMetaFiles" resultType="com.moon.server.entity.data.MetaEntity">
select a.*, fn_uname(a.create_user) createName, fn_uname(a.update_user) updateName, 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 id in
- <foreach item="id" collection="ids" index="index" open="(" separator="," close=")">
- #{id}
- </foreach>
+ where id in (#{ids}) or guid in (select guid from lf.sys_meta where type = 'gdb' and id in (#{ids}))
order by a.id desc
</select>
--
Gitblit v1.9.3