增加私信后端和标签上传
Change-Id: I4d5fbb6a634649359eef53091f07912c6099caeb
diff --git a/ruoyi-system/src/main/resources/mapper/system/SysUserMessageMapper.xml b/ruoyi-system/src/main/resources/mapper/system/SysUserMessageMapper.xml
index 79fe8b7..73e55fc 100644
--- a/ruoyi-system/src/main/resources/mapper/system/SysUserMessageMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/SysUserMessageMapper.xml
@@ -22,4 +22,21 @@
and del_flag = '0'
order by create_time asc
</select>
+
+ <select id="selectChatUserIds" parameterType="java.lang.Long" resultType="map">
+ SELECT DISTINCT
+ CASE
+ WHEN m.sender_id = #{userId} THEN m.receiver_id
+ ELSE m.sender_id
+ END AS userId,
+ u.nick_name AS nickName
+ FROM sys_user_message m
+ INNER JOIN sys_user u
+ ON (m.sender_id = #{userId} AND m.receiver_id = u.user_id)
+ OR (m.receiver_id = #{userId} AND m.sender_id = u.user_id)
+ WHERE (m.sender_id = #{userId} OR m.receiver_id = #{userId})
+ AND m.del_flag = '0'
+ AND u.del_flag = '0'
+ ORDER BY u.nick_name
+ </select>
</mapper>
\ No newline at end of file