From aae48957ba971ed0a1bfbfa182701cd22bbe8694 Mon Sep 17 00:00:00 2001
From: inleft <inleft@qq.com>
Date: Wed, 31 Aug 2022 18:12:16 +0800
Subject: [PATCH] 新增编辑页 查询接口
---
snowy-main/src/main/java/vip/xiaonuo/modular/blogarticlecomment/controller/BlogArticleCommentOutsideController.java | 193 ++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 184 insertions(+), 9 deletions(-)
diff --git a/snowy-main/src/main/java/vip/xiaonuo/modular/blogarticlecomment/controller/BlogArticleCommentOutsideController.java b/snowy-main/src/main/java/vip/xiaonuo/modular/blogarticlecomment/controller/BlogArticleCommentOutsideController.java
index fa50c0e..19c483c 100644
--- a/snowy-main/src/main/java/vip/xiaonuo/modular/blogarticlecomment/controller/BlogArticleCommentOutsideController.java
+++ b/snowy-main/src/main/java/vip/xiaonuo/modular/blogarticlecomment/controller/BlogArticleCommentOutsideController.java
@@ -26,11 +26,22 @@
import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.date.DateUtil;
+import cn.hutool.core.lang.Dict;
+import cn.hutool.core.util.PageUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.hutool.extra.template.Template;
+import cn.hutool.extra.template.TemplateConfig;
+import cn.hutool.extra.template.TemplateEngine;
+import cn.hutool.extra.template.TemplateUtil;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
import vip.xiaonuo.core.annotion.BusinessLog;
import vip.xiaonuo.core.consts.MyConstant;
+import vip.xiaonuo.core.context.constant.ConstantContextHolder;
+import vip.xiaonuo.core.email.MailSender;
+import vip.xiaonuo.core.email.modular.model.SendMailParam;
import vip.xiaonuo.core.enums.LogAnnotionOpTypeEnum;
import vip.xiaonuo.core.exception.BlogException;
import vip.xiaonuo.core.pojo.response.ResponseData;
@@ -60,19 +71,34 @@
@Resource
private BlogArticleService blogArticleService;
+ @Resource
+ private BlogArticleCommentService commentService;
+
@Resource
- private BlogArticleCommentService blogArticleCommentService;
-
+ private MailSender mailSender;
@PostMapping("/blogComment/add")
@BusinessLog(title = "外部blog系统_blog留言/评论_增加", opType = LogAnnotionOpTypeEnum.ADD)
public ResponseData add(@RequestBody @Validated(BlogArticleCommentAddDto.add.class) BlogArticleCommentAddDto addDto) {
+ BlogArticle checkArticle = null;
+
+ //自我认证
+ if (MyConstant.myIds.contains(addDto.getVisitorNickName())) {
+ if (StrUtil.isEmpty(addDto.getAuthCode()) || !addDto.getAuthCode().equals(ConstantContextHolder.getPushCode())) {
+ throw new BlogException("此名称在这里使用需要正确的授权码..");
+ }
+ }
+
+ if (MyConstant.Yes.equals(addDto.getIsReceiveMail()) && StrUtil.isEmpty(addDto.getVisitorEmail())) {
+ throw new BlogException("如果是想接收通知的话,你可能需要填上一个邮箱..");
+ }
+
if (addDto.getCommentType().equals(MyConstant.CommentType.type_2)) {
if (addDto.getArticleId() == null) {
throw new BlogException("评论类型为日志评论,日志id不能为空");
}
- BlogArticle checkArticle = blogArticleService.getById(addDto.getArticleId());
+ checkArticle = blogArticleService.getById(addDto.getArticleId());
if (checkArticle == null) {
throw new BlogException("查询不到相关日志");
}
@@ -87,7 +113,71 @@
insert.setIsEnable(MyConstant.Yes);
insert.setIsReceiveCallback(addDto.getIsReceiveMail());
- blogArticleCommentService.save(insert);
+ //自己留言已读
+ if (MyConstant.myIds.contains(addDto.getVisitorNickName())) {
+ insert.setIsRead(MyConstant.Yes);
+ }
+
+ commentService.save(insert);
+
+ if (addDto.getReplyId() == null || addDto.getReplyId() == 0L) {
+ //这里为根节点,预留通知我
+ return new SuccessResponseData();
+ }
+
+ BlogArticleComment lastComment = commentService.getById(addDto.getReplyId());
+
+ if (lastComment == null) {
+ return new SuccessResponseData();
+ }
+
+ //发送者是我本体,标记回复该条回复消息已读
+ if (MyConstant.myIds.contains(addDto.getVisitorNickName())) {
+ commentService.lambdaUpdate()
+ .eq(BlogArticleComment::getId, lastComment.getId())
+ .set(BlogArticleComment::getIsRead, MyConstant.Yes)
+ .update();
+ }
+
+ //前一个留言接收邮件回复(如果是给评论者自己的追加可以跳过)
+ if (MyConstant.Yes.equals(lastComment.getIsReceiveCallback())
+ && StrUtil.isNotEmpty(lastComment.getVisitorEmail())
+// && !lastComment.getVisitorNickName().equals(MyConstant.inleft)
+// && !lastComment.getVisitorEmail().equals(MyConstant.email)
+ && !lastComment.getVisitorNickName().equals(addDto.getVisitorNickName())
+ && !lastComment.getVisitorEmail().equals(addDto.getVisitorEmail())) {
+
+ String title = MyConstant.msgTitle;
+ String address;
+ //跳转地址
+ if (addDto.getCommentType().equals(MyConstant.CommentType.type_1)) {
+ //留言板
+ address = String.format(MyConstant.url_1, insert.getId());
+ } else {
+ //文章详情
+ address = String.format(MyConstant.url_2, addDto.getArticleId(), insert.getId());
+ title = checkArticle.getTitle();
+ }
+
+ TemplateEngine engine = TemplateUtil.createEngine(new TemplateConfig(MyConstant.ftlModel.path, TemplateConfig.ResourceMode.CLASSPATH));
+ Template template = engine.getTemplate(MyConstant.ftlModel.reply);
+
+ Dict dict = Dict.create()
+ .set("lastGuest", lastComment.getVisitorNickName())
+ .set("commentContent", lastComment.getCommentContent())
+ .set("address", address)
+ .set("title", title)
+ .set("sender", addDto.getVisitorNickName())
+ .set("sendContent", addDto.getCommentContent());
+ String result = template.render(dict);
+
+ SendMailParam param = new SendMailParam();
+ param.setContent(result);
+ param.setTitle("先前您在 [inleft的小木屋] 的留言有了新的回复！\n");
+ param.setTo(lastComment.getVisitorEmail());
+ mailSender.sendMailHtml(param);
+ }
+
return new SuccessResponseData();
}
@@ -103,7 +193,7 @@
Page queryPage = new Page<>(queryDto.getPageNo(), queryDto.getPageSize());
- List<BlogArticleComment> commentList = blogArticleCommentService.lambdaQuery()
+ List<BlogArticleComment> commentList = commentService.lambdaQuery()
.eq(queryDto.getArticleId() != null, BlogArticleComment::getArticleId, queryDto.getArticleId())
.eq(BlogArticleComment::getCommentType, queryDto.getArticleId() == null ? MyConstant.CommentType.type_1 : MyConstant.CommentType.type_2)
.eq(BlogArticleComment::getIsCheck, MyConstant.Yes)
@@ -117,7 +207,7 @@
BlogCommentVo vo = new BlogCommentVo();
BeanUtil.copyProperties(e, vo);
vo.setIsHasNext(MyConstant.No);
- List<BlogCommentVo> replyList = blogArticleCommentService.getReplyListById(e.getId(), limitCount);
+ List<BlogCommentVo> replyList = commentService.getReplyListById(e.getId(), limitCount);
vo.setReplyList(replyList);
if (e.getAuthStatus().equals(MyConstant.AuthStatus.privateCode)) {
@@ -125,7 +215,7 @@
}
if (CollUtil.isNotEmpty(replyList)
- && blogArticleCommentService.lambdaQuery()
+ && commentService.lambdaQuery()
.eq(BlogArticleComment::getParentId, e.getId())
.eq(BlogArticleComment::getIsCheck, MyConstant.Yes)
.eq(BlogArticleComment::getIsEnable, MyConstant.Yes)
@@ -143,12 +233,12 @@
@GetMapping("/blogComment/queryBlogCommentSubList")
@BusinessLog(title = "外部blog系统_blog留言/评论子列表_查询", opType = LogAnnotionOpTypeEnum.QUERY)
public ResponseData queryBlogCommentSubList(BlogCommentQueryDto queryDto) {
- if (queryDto.getArticleId() != null && blogArticleCommentService.getById(queryDto.getCommentId()) == null) {
+ if (queryDto.getArticleId() != null && commentService.getById(queryDto.getCommentId()) == null) {
throw new BlogException("查询不到相关评论");
}
- List<BlogCommentVo> replyList = blogArticleCommentService.getReplyListById(queryDto.getCommentId(), null);
+ List<BlogCommentVo> replyList = commentService.getReplyListById(queryDto.getCommentId(), null);
// for (BlogCommentVo vo : replyList) {
// vo.setIsHasNext(MyConstant.No);
// if (vo.getAuthStatus().equals(MyConstant.AuthStatus.privateCode)) {
@@ -158,4 +248,89 @@
return new SuccessResponseData(replyList);
}
+
+ @GetMapping("/blogComment/history")
+ @BusinessLog(title = "外部blog系统_blog留言/最近留言查询", opType = LogAnnotionOpTypeEnum.QUERY)
+ public ResponseData history(BlogCommentQueryDto queryDto) {
+ Page queryPage = new Page<>(queryDto.getPageNo(), queryDto.getPageSize());
+
+ //查询最近未读留言,无穷分页,(注意*号隐蔽,登录可见)
+ int unreadCommentListCount = commentService.lambdaQuery()
+ .eq(BlogArticleComment::getIsCheck, MyConstant.Yes)
+ .eq(BlogArticleComment::getIsEnable, MyConstant.Yes)
+ .eq(BlogArticleComment::getIsRead, MyConstant.No)
+ .count();
+
+ //取出所有未读消息+最多10条已读消息
+ long limitTotal = unreadCommentListCount + MyConstant.limitRead;
+
+ //最大页数不能超出限制
+ if (PageUtil.getEnd(queryDto.getPageNo() - 1, queryDto.getPageSize()) > limitTotal
+ && PageUtil.getEnd(queryDto.getPageNo() - 2, queryDto.getPageSize()) > limitTotal) {
+ queryPage.setMaxLimit(limitTotal);
+ return new SuccessResponseData(queryPage);
+ }
+
+ //当前页超出起始页,未达尾页, 限制当前查询个数
+ long limitSize = queryDto.getPageSize();
+ if (PageUtil.getEnd(queryDto.getPageNo() - 1, queryDto.getPageSize()) > limitTotal) {
+ limitSize = limitTotal % queryDto.getPageSize();
+ }
+
+ List<BlogArticleComment> commentList = commentService.lambdaQuery()
+ .eq(BlogArticleComment::getIsCheck, MyConstant.Yes)
+ .eq(BlogArticleComment::getIsEnable, MyConstant.Yes)
+ .orderByAsc(BlogArticleComment::getIsRead)
+ .orderByDesc(BlogArticleComment::getCreateDate)
+ .page(queryPage).getRecords();
+
+ //queryPage.setTotal(limitTotal - (limitTotal % queryDto.getPageSize()));
+ queryPage.setTotal(limitTotal);
+ List<BlogCommentVo> res = commentList.stream()
+ .limit(limitSize)
+ .map(e -> {
+ BlogCommentVo vo = new BlogCommentVo();
+ BeanUtil.copyProperties(e, vo);
+ if (e.getAuthStatus().equals(MyConstant.AuthStatus.privateCode)) {
+ vo.setCommentContent(MyConstant.privateComment);
+ }
+ if (MyConstant.CommentType.type_2 == e.getCommentType()) {
+ vo.setArticleTitle(blogArticleService.lambdaQuery()
+ .eq(BlogArticle::getId, e.getArticleId())
+ .select(BlogArticle::getTitle).one().getTitle());
+ } else {
+ vo.setArticleTitle(MyConstant.msgTitle);
+ }
+
+ return vo;
+ }
+ ).collect(Collectors.toList());
+
+ queryPage.setRecords(res);
+ return new SuccessResponseData(queryPage);
+ }
+
+ // @GetMapping("/blogComment/test")
+ public ResponseData test() {
+
+
+ TemplateEngine engine = TemplateUtil.createEngine(new TemplateConfig("templates", TemplateConfig.ResourceMode.CLASSPATH));
+ Template template = engine.getTemplate("emailReplyModel.ftl");
+ Dict dict = Dict.create()
+ .set("lastGuest", "回复人")
+ .set("commentContent", "评论内容")
+ .set("address", "http://blog.inleft.com")
+ .set("title", "回复标题")
+ .set("sendTime", DateUtil.now())
+ .set("sender", "发送人")
+ .set("sendContent", "发送内容");
+ String result = template.render(dict);
+
+ SendMailParam param = new SendMailParam();
+ param.setContent(result);
+ param.setTitle("先前您在 [inleft的小木屋] 的留言有了新的回复！\n");
+ param.setTo("1479853828@qq.com");
+ mailSender.sendMailHtml(param);
+ return new SuccessResponseData();
+ }
}
--
Gitblit v1.9.1