changes

liuhaonan

2022-09-16 6da203cc43e5c5497841f5d4224ebe7740cc821f

changes

 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>