From 6da203cc43e5c5497841f5d4224ebe7740cc821f Mon Sep 17 00:00:00 2001
From: liuhaonan <31457034@qq.com>
Date: 星期五, 16 九月 2022 10:56:14 +0800
Subject: [PATCH] changes
---
dao/src/main/resources/mapper/PlatformFileMapper.xml | 21 +++++++++------------
1 files changed, 9 insertions(+), 12 deletions(-)
diff --git a/dao/src/main/resources/mapper/PlatformFileMapper.xml b/dao/src/main/resources/mapper/PlatformFileMapper.xml
index cffb504..8d9c37e 100644
--- a/dao/src/main/resources/mapper/PlatformFileMapper.xml
+++ b/dao/src/main/resources/mapper/PlatformFileMapper.xml
@@ -19,22 +19,19 @@
create_time,update_time
</sql>
+
<select id="fileList" resultType="com.sandu.ximon.dao.bo.PlatformFileListBo">
SELECT
*
FROM
platform_file t1
- LEFT JOIN platform_file_user t2 ON t1.file_Id = t2.file_Id
- WHERE
- 1 =1
- <if test="userId!=null">
- AND
- t2.user_id = #{userId}
- </if>
- <if test="keyword != null and keyword != ''">
- AND (
- t1.file_name LIKE CONCAT('%', #{keyword},'%')
- )
- </if>
+ <where>
+ <if test="fileIdList!=null">
+ t1.file_id IN
+ <foreach collection="fileIdList" open="(" close=")" item="fileId" separator=",">
+ #{fileId}
+ </foreach>
+ </if>
+ </where>
</select>
</mapper>
--
Gitblit v1.9.3