5、发私信/letter/send:
(1)直接给别人发私信:点击私信按钮,弹出消息框,收信人和内容,AJAX异步post发送
(2)回复别人的私信:收信方默认写好的,也是AJAX异步post发送
6、私信列表@{|/letter/detail/${map.conversation.conversationalId}|}:
点击私信的内容,加载私信列表,controller层直接获取conversationId即可,进而能够查message表。
--------------------------------------------------------------------------------------------------------------------------------
1.MessageMapper:
import com.nowcoder.community.entity.Message;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface MessageMapper {
//查询当前用户的会话列表,针对每个用户只返回一条最新的私信
List<Message> selectConversations(int userId,int offset,int limit);
//查询当前用户的会话数量
int selectConversationCount(int userId);
//查询某个会话所包含的私信列表
List<Message> selectLetters(String conversationId,int offset,int limit);
//查询某个会话所包含的私信数量
int selectLetterCount(String conversationId);
//查询未读私信数量
int selectLetterUnreadCount(int userId,String conversationId);
//新增消息
int insertMessage(Message message);
//修改消息状态
int updateStatus(List<Integer> ids,int status);
}
2.MessageMapper.xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.nowcoder.community.mapper.MessageMapper">
<select id="selectConversations" resultType="Message">
select *
from message
where id in (
select max(id) from message
where status != 2
and from_id != 1
and (from_id = #{userId} or to_id = #{userId})
group by conversation_id
)
order by id desc
limit #{offset},#{limit}
</select>
<select id="selectConversationCount" resultType="int">
select count(m.maxid) from (
select max(id) as maxid from message
where status!=2
and from_id!=1
and (from_id=#{userId} or to_id=#{userId})
group by conversation_id
) as m
</select>
<select id="selectLetters" resultType="Message">
select * from message where status!=2 and from_id!=1 and conversation_id=#{conversationId} order by id desc limit #{offset},#{limit};
</select>
<select id="selectLetterCount" resultType="int">
select count(id) from message where status!=2 and from_id!=1 and conversation_id=#{conversationId};
</select>
<select id="selectLetterUnreadCount" resultType="int">
select count(id) from message where status=0 and from_id!=1 and to_id=#{userId}
<if test="conversationId!=null">
and conversation_id=#{conversationId}
</if>
</select>
<insert id="insertMessage" parameterType="Message" keyProperty="id">
insert into message(from_id, to_id, conversation_id, content, status, create_time) VALUES (#{fromId},#{toId},#{conversationId},#{content},#{status},#{createTime});
</insert>
<update id="updateStatus" parameterType="int">
update message set status=#{status} where id in
<foreach collection="ids" item="id" open="(" separator="," close=")">
#{id}
</foreach>
</update>
</mapper>
3.MessageService:
import com.nowcoder.community.entity.Message;
import com.nowcoder.community.mapper.MessageMapper;
import com.nowcoder.community.util.SensitiveFilter;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.util.HtmlUtils;
import java.util.List;
@Service
public class MessageServiceImpl implements MessageService{
@Autowired
private MessageMapper messageMapper;
@Autowired
private SensitiveFilter sensitiveFilter;
@Override
public List<Message> selectConversations(int userId, int offset, int limit) {
return messageMapper.selectConversations(userId, offset, limit);
}
@Override
public int selectConversationCount(int userId) {
return messageMapper.selectConversationCount(userId);
}
@Override
public List<Message> selectLetters(String conversationId, int offset, int limit) {
return messageMapper.selectLetters(conversationId, offset, limit);
}
@Override
public int selectLetterCount(String conversationId) {
return messageMapper.selectLetterCount(conversationId);
}
@Override
public int selectLetterUnreadCount(int userId, String conversationId) {
return messageMapper.selectLetterUnreadCount(userId, conversationId);
}
@Override
public int insertMessage(Message message) {
return messageMapper.insertMessage(message);
}
@Override
public int updateStatus(List<Integer> ids, int status) {
return messageMapper.updateStatus(ids, status);
}
public int addMessage(Message message){
message.setContent(HtmlUtils.htmlEscape(message.getContent()));
message.setContent(sensitiveFilter.filter(message.getContent()));
return messageMapper.insertMessage(message);
}
public int readMessage(List<Integer> ids){
return messageMapper.updateStatus(ids,1);
}
}
4.编写MessageController:
import com.nowcoder.community.entity.Message;
import com.nowcoder.community.entity.Page;
import com.nowcoder.community.entity.User;
import com.nowcoder.community.service.MessageServiceImpl;
import com.nowcoder.community.service.UserServiceImpl;
import com.nowcoder.community.util.CommunityUtil;
import com.nowcoder.community.util.HostHolder;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.*;
@Controller
public class MessageController {
@Autowired
private MessageServiceImpl messageService;
@Autowired
private UserServiceImpl userService;
@Autowired
private HostHolder hostHolder;
@GetMapping("/letter/list")
public String getLetterList(Model model, Page page){
User user = hostHolder.getUser();
//分页信息
page.setLimit(5);
page.setPath("/letter/list");
page.setRows(messageService.selectConversationCount(user.getId()));
//会话列表
List<Message> conversationList = messageService.selectConversations(user.getId(), page.getOffset(), page.getLimit());
List<Map<String,Object>> conversations=new ArrayList<>();
if (conversationList!=null){
for (Message message : conversationList) {
Map<String,Object> map=new HashMap<>();
map.put("conversation",message);
map.put("letterCount",messageService.selectLetterCount(message.getConversationId()));
map.put("unreadCount",messageService.selectLetterUnreadCount(user.getId(), message.getConversationId()));
int target= user.getId()== message.getFromId() ? message.getToId() : message.getFromId();
map.put("target",userService.selectById(target));
conversations.add(map);
}
}
model.addAttribute("conversations",conversations);
//查询未读消息数量
int letterUnreadCount = messageService.selectLetterUnreadCount(user.getId(), null);
model.addAttribute("letterUnreadCount",letterUnreadCount);
return "/site/letter";
}
@GetMapping("/letter/detail/{conversationId}")
public String getLetterDetail(Model model,@PathVariable("conversationId") String conversationId,Page page){
User user = hostHolder.getUser();
//分页信息
page.setPath("/letter/detail/"+conversationId);
page.setLimit(5);
page.setRows(messageService.selectLetterCount(conversationId));
//私信列表
List<Message> lettersList = messageService.selectLetters(conversationId, page.getOffset(), page.getLimit());
List<Map<String,Object>> letters=new ArrayList<>();
if (lettersList!=null){
for (Message letter : lettersList) {
Map<String,Object> map=new HashMap<>();
map.put("letter",letter);
map.put("fromUser",userService.selectById(letter.getFromId()));
letters.add(map);
}
}
model.addAttribute("letters",letters);
//私信目标
model.addAttribute("target",getLetterTarget(conversationId));
//设置已读
List<Integer> ids = getLetterIds(lettersList);
if (!ids.isEmpty()){
messageService.readMessage(ids);
}
return "site/letter-detail";
}
//获取目标用户的方法
private User getLetterTarget(String conversationId){
String[] ids = conversationId.split("_");
int id0 = Integer.parseInt(ids[0]);
int id1 = Integer.parseInt(ids[1]);
if (hostHolder.getUser().getId()==id0){
return userService.selectById(id1);
}
else {
return userService.selectById(id0);
}
}
//获取未读消息的id
private List<Integer> getLetterIds(List<Message> letterList){
List<Integer> ids=new ArrayList<>();
if (letterList!=null){
for (Message message : letterList) {
if (hostHolder.getUser().getId()== message.getToId()&&message.getStatus()==0){
ids.add(message.getId());
}
}
}
return ids;
}
5.index.html:
<li class="nav-item ml-3 btn-group-vertical" th:if="${loginUser!=null}">
<a class="nav-link position-relative" th:href="@{/letter/list}">消息<span class="badge badge-danger">12</span></a>
</li>
6.letter.html:
<div class="position-relative">
<!-- 选项 -->
<ul class="nav nav-tabs mb-3">
<li class="nav-item">
<a class="nav-link position-relative active" th:href="@{/letter/list}">朋友私信<span class="badge badge-danger" th:text="${letterUnreadCount}" th:if="${letterUnreadCount!=0}">3</span></a>
</li>
<li class="nav-item">
<a class="nav-link position-relative" href="notice.html">系统通知<span class="badge badge-danger">27</span></a>
</li>
</ul>
<button type="button" class="btn btn-primary btn-sm position-absolute rt-0" data-toggle="modal" data-target="#sendModal">发私信</button>
</div>
<!-- 私信列表 -->
<ul class="list-unstyled">
<li class="media pb-3 pt-3 mb-3 border-bottom position-relative" th:each="map:${conversations}">
<span class="badge badge-danger" th:text="${map.unreadCount}" th:if="${map.unreadCount!=0}">3</span>
<a href="profile.html">
<img th:src="${map.target.headerUrl}" class="mr-4 rounded-circle user-header" alt="用户头像" >
</a>
<div class="media-body">
<h6 class="mt-0 mb-3">
<span class="text-success" th:utext="${map.target.username}">落基山脉下的闲人</span>
<span class="float-right text-muted font-size-12" th:text="${#dates.format(map.conversation.createTime,'yyyy-MM-dd HH:mm:ss')}">2019-04-28 14:13:25</span>
</h6>
<div>
<a th:href="@{|/letter/detail/${map.conversation.conversationId}|}" th:utext="${map.conversation.content}">米粉车, 你来吧!</a>
<ul class="d-inline font-size-12 float-right">
<li class="d-inline ml-2"><a href="#" class="text-primary">共<i th:text="${map.letterCount}">5</i>条会话</a></li>
</ul>
</div>
</div>
</li>
</ul>
8.letter-detail.html:
<div class="container">
<div class="row">
<div class="col-8">
<h6><b class="square"></b> 来自 <i class="text-success" th:utext="${target.username}">落基山脉下的闲人</i> 的私信</h6>
</div>
<div class="col-4 text-right">
<button type="button" class="btn btn-secondary btn-sm" onclick="back();">返回</button>
<button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#sendModal">给TA私信</button>
</div>
</div>
<!-- 私信列表 -->
<ul class="list-unstyled mt-4">
<li class="media pb-3 pt-3 mb-2" th:each="map:${letters}">
<a href="profile.html">
<img th:src="${map.fromUser.headerUrl}" class="mr-4 rounded-circle user-header" alt="用户头像" >
</a>
<div class="toast show d-lg-block" role="alert" aria-live="assertive" aria-atomic="true">
<div class="toast-header">
<strong class="mr-auto" th:utext="${map.fromUser.username}">落基山脉下的闲人</strong>
<small th:text="${#dates.format(map.letter.createTime,'yyyy-MM-dd HH:mm:ss')}">2019-04-25 15:49:32</small>
<button type="button" class="ml-2 mb-1 close" data-dismiss="toast" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="toast-body" th:utext="${map.letter.content}">
君不见, 黄河之水天上来, 奔流到海不复回!
</div>
</div>
</li>
</ul>
9.letter.js:
$(function(){
$("#sendBtn").click(send_letter);
$(".close").click(delete_msg);
});
function send_letter() {
$("#sendModal").modal("hide");
var toName=$("#recipient-name").val();
var content=$("#message-text").val();
$.post(
CONTEXT_PATH+"/letter/send",
{"toName":toName,"content":content},
function (data) {
data=$.parseJSON(data);
if (data.code==0){
$("#hintBody").text("发送成功");
}
else {
$("#hintBody").text(data.msg);
}
$("#hintModal").modal("show");
setTimeout(function(){
$("#hintModal").modal("hide");
location.reload();
}, 2000);
}
);
}
function delete_msg() {
// TODO 删除数据
$(this).parents(".media").remove();
}