实现功能

  • 圈子动态查询
  • 圈子实现评论
  • 圈子实现点赞、喜欢功能
  • 圈子实现评论

1、动态查询

我的动态:查询个人发布的动态列表(分页查询),和之前实现的好友动态,推荐动态实现逻辑是一致。

1.1、查询好友动态

查询好友动态与查询推荐动态显示的结构是一样的,只是其查询数据源不同

1.1.1、接口文档

API接口文档:http://192.168.136.160:3000/project/19/interface/api/142

image-20220714151731910

1.1.2、代码步骤

  • Controller层接受请求参数

  • Service数据封装

    • 调用API查询好友动态详情数据
    • 调用API查询动态发布人详情
    • 构造VO对象
  • API层根据用户ID查询好友发布动态详情

    • 查询好友时间线表
    • 查询动态详情

    image-20220714154623316

1.1.3、代码实现

MovementController
1
2
3
4
5
6
7
8
9
10

/**
* 查询好友动态
*/
@GetMapping
public ResponseEntity movements(@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer pagesize) {
PageResult pr = movementService.findFriendMovements(page,pagesize);
return ResponseEntity.ok(pr);
}
MovementService
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
//好友动态
public PageResult findFriendMovements(Integer page, Integer pagesize) {
//1、获取当前用户id
Long userId = UserHolder.getUserId();
//2、查询数据列表
List<Movement> items = movementApi.findFriendMovements(userId,page,pagesize);
//3、非空判断
if(CollUtil.isEmpty(items)) {
return new PageResult();
}
//4、获取好友用户id
List<Long> userIds = CollUtil.getFieldValues(items, "userId", Long.class);
//5、循环数据列表
Map<Long, UserInfo> userMaps = userInfoApi.findByIds(userIds, null);
List<MovementsVo> vos = new ArrayList<>();
for (Movement item : items) {
//5、一个Movement构建一个Vo对象
UserInfo userInfo = userMaps.get(item.getUserId());
MovementsVo vo = MovementsVo.init(userInfo, item);
vos.add(vo);
}
//6、构建返回值
return new PageResult(page,pagesize,0L,vos);
}
movementApi
1
2
3
4
5
6
7
8
9
10
11
12
13
@Override
public List<Movement> findFriendMovements(Long friendId, Integer page, Integer pagesize) {
//1、查询好友时间线表
Query query = Query.query(Criteria.where("friendId").in(friendId))
.skip((page - 1)*pagesize).limit(pagesize)
.with(Sort.by(Sort.Order.desc("created")));
List<MovementTimeLine> lines = mongoTemplate.find(query, MovementTimeLine.class);
//2、提取动态id集合
List<ObjectId> movementIds = CollUtil.getFieldValues(lines, "movementId", ObjectId.class);
//3、根据动态id查询动态详情
Query movementQuery = Query.query(Criteria.where("id").in(movementIds));
return mongoTemplate.find(movementQuery, Movement.class);
}

1.2、查询推荐动态

推荐动态是通过推荐系统计算出的结果,根据个人的偏好进行实时计算得出的结果

  • 推荐系统采集用户的行为特征(日常操作行为)

    • 查看
    • 点赞
    • 评论
  • 大数据推荐系统实时计算,统计推荐数据

  • 将结果写入redis

  • 查询推荐动态

image-20220714155659593

推荐动态-数据格式

  • 推荐动态数据存入Redis服务器中
  • 存入的数据KEY为MOVEMENTS_RECOMMED-{用户id}
  • 存入的数据VALUE为:动态PID字符串(多个PID间使用”,”连接)
1
2
192.168.31.81:6379> get MOVEMENTS_RECOMMEND_1
"2562,3639,2063,3448,2128,2597,2893,2333,3330,2642,2541,3002,3561,3649,2384,2504,3397,2843,2341,2249"

可以看到,在Redis中的数据是有多个发布id组成(pid)由逗号分隔。所以实现中需要自己对这些数据做分页处理。

1.2.1、接口文档

API接口文档:http://192.168.136.160:3000/project/19/interface/api/145

1.2.2、代码步骤

  • Controller层接受请求参数

  • Service数据封装

    • 从redis获取当前用户的推荐PID列表
    • 如果不存在,调用API随机获取10条动态数据
    • 如果存在,调用API根据PID列表查询动态数据
    • 构造VO对象
  • API层编写方法

    • 随机获取
    • 根据pid列表查询

    image-20220714160116481

1.2.3、代码实现

Constants
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
package com.tanhua.commons.utils;

//常量定义
public class Constants {

//手机APP短信验证码CHECK_CODE_
public static final String SMS_CODE = "CHECK_CODE_";

//推荐动态
public static final String MOVEMENTS_RECOMMEND = "MOVEMENTS_RECOMMEND_";

//推荐视频
public static final String VIDEOS_RECOMMEND = "VIDEOS_RECOMMEND_";

//圈子互动KEY
public static final String MOVEMENTS_INTERACT_KEY = "MOVEMENTS_INTERACT_";

//动态点赞用户HashKey
public static final String MOVEMENT_LIKE_HASHKEY = "MOVEMENT_LIKE_";

//动态喜欢用户HashKey
public static final String MOVEMENT_LOVE_HASHKEY = "MOVEMENT_LOVE_";

//视频点赞用户HashKey
public static final String VIDEO_LIKE_HASHKEY = "VIDEO_LIKE";

//访问用户
public static final String VISITORS = "VISITORS";

//关注用户
public static final String FOCUS_USER = "FOCUS_USER_{}_{}";

//初始化密码
public static final String INIT_PASSWORD = "123456";

//环信用户前缀
public static final String HX_USER_PREFIX = "hx";

//jwt加密盐
public static final String JWT_SECRET = "itcast";

//jwt超时时间
public static final int JWT_TIME_OUT = 3_600;
}

MovementController
1
2
3
4
5
6
7
8
9
/**
* 推荐动态
*/
@GetMapping("/recommend")
public ResponseEntity recommend(@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer pagesize) {
PageResult pr = movementService.findRecommendMovements(page,pagesize);
return ResponseEntity.ok(pr);
}
MovementService
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
//推荐动态
public PageResult findRecommendMovements(Integer page, Integer pagesize) {
String redisKey = "MOVEMENTS_RECOMMEND_" + UserHolder.getUserId();
String redisData = this.redisTemplate.opsForValue().get(redisKey);
List<Movement> list = Collections.EMPTY_LIST;
if(StringUtils.isEmpty(redisData)){
list = movementApi.randomMovements(pagesize);
}else {
String[] split = redisData.split(",");
if ((page-1) * pagesize > split.length) {
return new PageResult();
}
List<Long> pids = Arrays.stream(split)
.skip((page - 1) * pagesize)
.limit(pagesize)
.map(e -> Convert.toLong(e))
.collect(Collectors.toList());
list = movementApi.findByPids(pids);
}
List<Long> userIds = CollUtil.getFieldValues(list, "userId", Long.class);
//5、循环数据列表
Map<Long, UserInfo> userMaps = userInfoApi.findByIds(userIds, null);
List<MovementsVo> vos = new ArrayList<>();
for (Movement item : list) {
//5、一个Movement构建一个Vo对象
UserInfo userInfo = userMaps.get(item.getUserId());
MovementsVo vo = MovementsVo.init(userInfo, item);
vos.add(vo);
}
//6、构建返回值
return new PageResult(page,pagesize,0L,vos);
}
movementApi
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
//随机获取多条数据
public List<Movement> randomMovements(Integer counts) {
// 1、创建统计对象,设置统计参数
TypedAggregation aggregation = Aggregation.newAggregation(Movement.class,
Aggregation.sample(counts));
// 2、调用mongoTemplatete方法统计
AggregationResults<Movement> movements = mongoTemplate.aggregate(aggregation,Movement.class);
// 3、获取统计结果
return movements.getMappedResults();
}


//根据PID查询
public List<Movement> findByPids(List<Long> pids) {
Query query = Query.query(Criteria.where("pId").in(pids));
return mongoTemplate.find(query, Movement.class);
}

1、推荐系统动态的执行流程

  • 推荐系统采集用户行为数据
  • 实时计算推荐数据写入redis
  • 从redis查询推荐结果

2、基于List实现分页

  • Stream流处理
  • Skip()和limit()方法

3、从MongoDB获取随机数

  • Aggregation.sample()设置随机采样数
  • aggregate()方法统计

1.3、根据id查询动态详情

image-20220714163040714

根据id查询动态:当手机端查看评论内容时(需要根据动态id,查询动态详情),后续再去查询评论列表

image-20220714162354625

1.3.1、接口文档

API接口文档:http://192.168.136.160:3000/project/19/interface/api/151

1.3.2、代码实现

MovementController
1
2
3
4
5
6
7
8
9
/**
* 根据id查询动态
*/
@GetMapping("/{id}")
public ResponseEntity findById(@PathVariable("id") String movementId) {
MovementsVo vo = movementService.findMovementById(movementId);
return ResponseEntity.ok(vo);
}

MovementService
1
2
3
4
5
6
7
8
9
10

public MovementsVo findMovementById(String movementId) {
Movement movements = movementApi.findById(movementId);
if(movements == null) {
return null;
}else {
UserInfo userInfo = userInfoApi.findById(movements.getUserId());
return MovementsVo.init(userInfo,movements);
}
}
movementApi
1
2
3
4
@Override
public Movement findById(String movementId) {
return mongoTemplate.findById(movementId,Movement.class);
}

1、查询好友动态

  • 理解数据库表结构(3张表)
  • 时间线表->动态详情表
  • Vo对象转化

2、查询推荐动态

  • 推荐动态流程
  • 基于List的数据分页和MongoDB随机获取数据

3、查询单条动态

2、圈子互动

需求分析:

image-20220714163718651

圈子互动是指用户对动态的点赞、喜欢、评论等操作。

点赞、喜欢、评论等均可理解为用户对动态的互动。

表设计:

数据库表:comment

1
2
3
4
5
6
7
8
9
10
11
12
13
将数据记录到表中:保存到MongoDB中
互动表需要几张:需要一张表即可(quanzi_comment)
里面的数据需要分类:通过字段commentType 1-点赞,2-评论,3-喜欢
{
"_id" : ObjectId("5fe7f9263c851428107cd4e8"),
"publishId" : ObjectId("5fae53947e52992e78a3afa5"),
"commentType" : 1,
"userId" : NumberLong(1),
"publishUserId" : NumberLong(1),
"created" : NumberLong(1609038118275),
"likeCount" : 0,
"_class" : "com.tanhua.domain.mongo.Comment"
}

image-20220714164019200

问题分析:

如果我们查询 动态数据,每一条动态需要添加冗余字段

优势:查询动态表一次性获取点赞,喜欢,评论数量

缺点: 进行点赞,喜欢,评论时需要维护对应的字段

image-20220714164248491

image-20220714164704416

数据存储位置:redismongodb

mongodb中的数据

  • 在动态详情Movement表中,加入喜欢,点赞,评论数量:检查数据库访问压力
    • 互动操作的时候,不要忘记对上面的字段进行维护
  • 圈子互动的表 comment
  • 互动完成(点赞,喜欢):不仅要将数据保存到mongo中,需要记录到redis中
  • 页面查询圈子列表时,可以从redis中判断是否有点赞,和喜欢历史

2.1、环境搭建

2.1.1 创建API接口

1
2
3
public interface CommentApi {

}

2.1.2 创建API实现类

1
2
3
4
5
6
@DubboService
public class CommentApiImpl implements CommentApi {

@Autowired
private MongoTemplate mongoTemplate;
}

2.1.3 Movement对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
@Data
@NoArgsConstructor
@AllArgsConstructor
@Document(collection = "movement")
public class Movement implements java.io.Serializable {

private ObjectId id; //主键id
//redis实现,使用Mongodb实现
private Long pid; //Long类型,用于推荐系统的模型(自动增长)
private Long created; //发布时间
private Long userId;
private String textContent; //文字
private List<String> medias; //媒体数据,图片或小视频 url
private String longitude; //经度
private String latitude; //纬度
private String locationName; //位置名称
private Integer state = 0;//状态 0:未审(默认),1:通过,2:驳回

//补充字段
private Integer likeCount = 0; //点赞数
private Integer commentCount = 0; //评论数
private Integer loveCount = 0; //喜欢数

//根据评论类型,获取对应的互动数量
public Integer statisCount(Integer commentType) {
if (commentType == CommentType.LIKE.getType()) {
return this.likeCount;
} else if (commentType == CommentType.COMMENT.getType()) {
return this.commentCount;
} else {
return loveCount;
}
}
}

2.1.4 实体类对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
package com.tanhua.domain.mongo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.bson.types.ObjectId;
import org.springframework.data.mongodb.core.mapping.Document;

/**
* 圈子互动表(点赞,评论,喜欢)
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
@Document(collection = "comment")
public class Comment implements java.io.Serializable{

private ObjectId id;
private ObjectId publishId; //发布id
private Integer commentType; //评论类型,1-点赞,2-评论,3-喜欢
private String content; //评论内容
private Long userId; //评论人
private Long publishUserId; //被评论人ID
private Long created; //发表时间
private Integer likeCount = 0; //当前评论的点赞数

}

2.1.5 VO对象

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
@Data
@NoArgsConstructor
@AllArgsConstructor
public class CommentVo implements Serializable {

private String id; //评论id
private String avatar; //头像
private String nickname; //昵称


private String content; //评论
private String createDate; //评论时间
private Integer likeCount; //点赞数
private Integer hasLiked; //是否点赞(1是,0否)

public static CommentVo init(UserInfo userInfo, Comment item) {
CommentVo vo = new CommentVo();
BeanUtils.copyProperties(userInfo, vo);
BeanUtils.copyProperties(item, vo);
vo.setHasLiked(0);
Date date = new Date(item.getCreated());
vo.setCreateDate(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date));
vo.setId(item.getId().toHexString());
return vo;
}
}

2.1.6 CommentType枚举

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
/**
* 评论类型:1-点赞,2-评论,3-喜欢
*/
public enum CommentType {

LIKE(1), COMMENT(2), LOVE(3);

int type;

CommentType(int type) {
this.type = type;
}

public int getType() {
return type;
}
}

2.2、动态评论

image-20220714163754492

功能包括:查询评论列表,发布评论,对评论点赞和取消点赞。

image-20220714181053783

2.2.1 分页列表查询

CommentController
1
2
3
4
5
6
7
8
//分页查询评理列表
@GetMapping
public ResponseEntity findComments(@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer pagesize,
String movementId) {
PageResult pr = commentsService.findComments(movementId,page,pagesize);
return ResponseEntity.ok(pr);
}
CommentService
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
//分页查询评理列表
public PageResult findComments(String movementId, Integer page, Integer pagesize) {
//1、调用API查询评论列表
List<Comment> list = commentApi.findComments(movementId,CommentType.COMMENT,page,pagesize);
//2、判断list集合是否存在
if(CollUtil.isEmpty(list)) {
return new PageResult();
}
//3、提取所有的用户id,调用UserInfoAPI查询用户详情
List<Long> userIds = CollUtil.getFieldValues(list, "userId", Long.class);
Map<Long, UserInfo> map = userInfoApi.findByIds(userIds, null);
//4、构造vo对象
List<CommentVo> vos = new ArrayList<>();
for (Comment comment : list) {
UserInfo userInfo = map.get(comment.getUserId());
if(userInfo != null) {
CommentVo vo = CommentVo.init(userInfo, comment);
vos.add(vo);
}
}
//5、构造返回值
return new PageResult(page,pagesize,0l,vos);
}
CommentAPI
1
2
3
4
5
6
7
8
9
10
11
//分页查询
public List<Comment> findComments(String movementId, CommentType commentType, Integer page, Integer pagesize) {
//1、构造查询条件
Query query = Query.query(Criteria.where("publishId").is(new ObjectId(movementId)).and("commentType")
.is(commentType.getType()))
.skip((page -1) * pagesize)
.limit(pagesize)
.with(Sort.by(Sort.Order.desc("created")));
//2、查询并返回
return mongoTemplate.find(query,Comment.class);
}

2.2.2 发布评论

image-20220714181021134

CommentController
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
@RestController
@RequestMapping("/comments")
public class CommentsController {


@Autowired
private CommentsService commentsService;

/**
* 发布评论
*/
@PostMapping
public ResponseEntity saveComments(@RequestBody Map map) {
String movementId = (String )map.get("movementId");
String comment = (String)map.get("comment");
commentsService.saveComments(movementId,comment);
return ResponseEntity.ok(null);
}
}
CommentService
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
@Service
@Slf4j
public class CommentsService {

@DubboReference
private CommentApi commentApi;

//发布评论
public void saveComments(String movementId, String comment) {
//1、获取操作用户id
Long userId = UserHolder.getUserId();
//2、构造Comment
Comment comment1 = new Comment();
comment1.setPublishId(new ObjectId(movementId));
comment1.setCommentType(CommentType.COMMENT.getType());
comment1.setContent(comment);
comment1.setUserId(userId);
comment1.setCreated(System.currentTimeMillis());
//3、调用API保存评论
Integer commentCount = commentApi.save(comment1);
log.info("commentCount = " + commentCount);
}
}
CommentAPI
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
//发布评论,并获取评论数量
public Integer save(Comment comment) {
//1、查询动态
Movement movement = mongoTemplate.findById(comment.getPublishId(), Movement.class);
//2、向comment对象设置被评论人属性
if(movement != null) {
comment.setPublishUserId(movement.getUserId());
}
//3、保存到数据库
mongoTemplate.save(comment);
//4、更新动态表中的对应字段
Query query = Query.query(Criteria.where("id").is(comment.getPublishId()));
Update update = new Update();
if(comment.getCommentType() == CommentType.LIKE.getType()) {
update.inc("likeCount",1);
}else if (comment.getCommentType() == CommentType.COMMENT.getType()){
update.inc("commentCount",1);
}else {
update.inc("loveCount",1);
}
//设置更新参数
FindAndModifyOptions options = new FindAndModifyOptions();
options.returnNew(true) ;//获取更新后的最新数据
Movement modify = mongoTemplate.findAndModify(query, update, options, Movement.class);
//5、获取最新的评论数量,并返回
return modify.statisCount(comment.getCommentType() );
}
测试API代码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
@RunWith(SpringRunner.class)
@SpringBootTest(classes = AppServerApplication.class)
public class CommentApiTest {

@DubboReference
private CommentApi commentApi;

@Test
public void testSave() {
Comment comment = new Comment();
comment.setCommentType(CommentType.COMMENT.getType());
comment.setUserId(106l);
comment.setCreated(System.currentTimeMillis());
comment.setContent("测试评论");
comment.setPublishId();
commentApi.save(comment);
}
}

image-20220714180948314

2.3、点赞

Reids缓存,常使用基础String存储。对于点赞等需求是否合适呢?

如果使用String类型进行存储,那么存储格式如图所示,存在如果动态点赞数据量大的情况。

Key较多,不易维护。

image-20220714182142241

使用Hash 进行存储:

使用动态id进行作为key,字段作为hashKey

image-20220714182506983

接口:

image-20220714182753274

点赞思路:

MongoDB操作:

  • 查询是否点赞
  • 保存数据

Redis数据操作:

  • 记录用户点赞状态

image-20220714182947936

2.3.1、编写Controller

修改MovementsController代码,添加点赞与取消点赞方法

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
/**
* 点赞
*/
@GetMapping("/{id}/like")
public ResponseEntity like(@PathVariable("id") String movementId) {
Integer likeCount = commentsService.likeComment(movementId);
return ResponseEntity.ok(likeCount);
}

/**
* 取消点赞
*/
@GetMapping("/{id}/dislike")
public ResponseEntity dislike(@PathVariable("id") String movementId) {
Integer likeCount = commentsService.dislikeComment(movementId);
return ResponseEntity.ok(likeCount);
}

2.3.2、编写Service

创建CommentService,添加点赞与取消点赞方法

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
//动态点赞
public Integer likeComment(String movementId) {
//1、调用API查询用户是否已点赞
Boolean hasComment = commentApi.hasComment(movementId,UserHolder.getUserId(),CommentType.LIKE);
//2、如果已经点赞,抛出异常
if(hasComment) {
throw new BusinessException(ErrorResult.likeError());
}
//3、调用API保存数据到Mongodb
Comment comment = new Comment();
comment.setPublishId(new ObjectId(movementId));
comment.setCommentType(CommentType.LIKE.getType());
comment.setUserId(UserHolder.getUserId());
comment.setCreated(System.currentTimeMillis());
Integer count = commentApi.save(comment);
//4、拼接redis的key,将用户的点赞状态存入redis
String key = Constants.MOVEMENTS_INTERACT_KEY + movementId;
String hashKey = Constants.MOVEMENT_LIKE_HASHKEY + UserHolder.getUserId();
redisTemplate.opsForHash().put(key,hashKey,"1");
return count;
}


//取消点赞
public Integer dislikeComment(String movementId) {
//1、调用API查询用户是否已点赞
Boolean hasComment = commentApi.hasComment(movementId,UserHolder.getUserId(),CommentType.LIKE);
//2、如果未点赞,抛出异常
if(!hasComment) {
throw new BusinessException(ErrorResult.disLikeError());
}
//3、调用API,删除数据,返回点赞数量
Comment comment = new Comment();
comment.setPublishId(new ObjectId(movementId));
comment.setCommentType(CommentType.LIKE.getType());
comment.setUserId(UserHolder.getUserId());
Integer count = commentApi.delete(comment);
//4、拼接redis的key,删除点赞状态
String key = Constants.MOVEMENTS_INTERACT_KEY + movementId;
String hashKey = Constants.MOVEMENT_LIKE_HASHKEY + UserHolder.getUserId();
redisTemplate.opsForHash().delete(key,hashKey);
return count;
}

2.3.3、修改API服务

判断Comment数据是否存在
1
2
3
4
5
6
7
8
//判断comment数据是否存在
public Boolean hasComment(String movementId, Long userId, CommentType commentType) {
Criteria criteria = Criteria.where("userId").is(userId)
.and("publishId").is(new ObjectId(movementId))
.and("commentType").is(commentType.getType());
Query query = Query.query(criteria);
return mongoTemplate.exists(query,Comment.class); //判断数据是否存在
}
删除互动数据
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
//删除
public Integer delete(Comment comment) {
//1、删除Comment表数据
Criteria criteria = Criteria.where("userId").is(comment.getUserId())
.and("publishId").is(comment.getPublishId())
.and("commentType").is(comment.getCommentType());
Query query = Query.query(criteria);
mongoTemplate.remove(query,Comment.class);
//2、修改动态表中的总数量
Query movementQuery = Query.query(Criteria.where("id").is(comment.getPublishId()));
Update update = new Update();
if(comment.getCommentType() == CommentType.LIKE.getType()) {
update.inc("likeCount",-1);
}else if (comment.getCommentType() == CommentType.COMMENT.getType()){
update.inc("commentCount",-1);
}else {
update.inc("loveCount",-1);
}
//设置更新参数
FindAndModifyOptions options = new FindAndModifyOptions();
options.returnNew(true) ;//获取更新后的最新数据
Movement modify = mongoTemplate.findAndModify(movementQuery, update, options, Movement.class);
//5、获取最新的评论数量,并返回
return modify.statisCount(comment.getCommentType() );
}

2.3.4、修改查询动态点赞数

修改之前的查询圈子列表代码,从redis查询是否具有操作记录

2.4、喜欢

喜欢和取消喜欢:和刚才的点赞与取消点赞基本上市一模一样的!操作的类型comment_type=3,操作的字段loveCount

MovementsController

修改MovementsController代码,添加喜欢与取消喜欢方法

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
/**
* 喜欢
*/
@GetMapping("/{id}/love")
public ResponseEntity love(@PathVariable("id") String movementId) {
Integer likeCount = commentsService.loveComment(movementId);
return ResponseEntity.ok(likeCount);
}

/**
* 取消喜欢
*/
@GetMapping("/{id}/unlove")
public ResponseEntity unlove(@PathVariable("id") String movementId) {
Integer likeCount = commentsService.disloveComment(movementId);
return ResponseEntity.ok(likeCount);
}

CommentService

修改CommentService,添加点赞与取消点赞方法

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
//喜欢
public Integer loveComment(String movementId) {
//1、调用API查询用户是否已点赞
Boolean hasComment = commentApi.hasComment(movementId,UserHolder.getUserId(),CommentType.LOVE);
//2、如果已经喜欢,抛出异常
if(hasComment) {
throw new BusinessException(ErrorResult.loveError());
}
//3、调用API保存数据到Mongodb
Comment comment = new Comment();
comment.setPublishId(new ObjectId(movementId));
comment.setCommentType(CommentType.LOVE.getType());
comment.setUserId(UserHolder.getUserId());
comment.setCreated(System.currentTimeMillis());
Integer count = commentApi.save(comment);
//4、拼接redis的key,将用户的点赞状态存入redis
String key = Constants.MOVEMENTS_INTERACT_KEY + movementId;
String hashKey = Constants.MOVEMENT_LOVE_HASHKEY + UserHolder.getUserId();
redisTemplate.opsForHash().put(key,hashKey,"1");
return count;
}

//取消喜欢
public Integer disloveComment(String movementId) {
//1、调用API查询用户是否已点赞
Boolean hasComment = commentApi.hasComment(movementId,UserHolder.getUserId(),CommentType.LOVE);
//2、如果未点赞,抛出异常
if(!hasComment) {
throw new BusinessException(ErrorResult.disloveError());
}
//3、调用API,删除数据,返回点赞数量
Comment comment = new Comment();
comment.setPublishId(new ObjectId(movementId));
comment.setCommentType(CommentType.LOVE.getType());
comment.setUserId(UserHolder.getUserId());
Integer count = commentApi.delete(comment);
//4、拼接redis的key,删除点赞状态
String key = Constants.MOVEMENTS_INTERACT_KEY + movementId;
String hashKey = Constants.MOVEMENT_LOVE_HASHKEY + UserHolder.getUserId();
redisTemplate.opsForHash().delete(key,hashKey);
return count;
}