package com.ruoyi.article.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.google.common.collect.Lists; import com.ruoyi.article.controller.forepart.dto.ArticleDTO; import com.ruoyi.article.controller.forepart.vo.ArticleCommentsVO; import com.ruoyi.article.controller.forepart.vo.ArticleVO; import com.ruoyi.article.controller.management.dto.MgtArticleAuditDTO; import com.ruoyi.article.controller.management.dto.MgtArticleDTO; import com.ruoyi.article.controller.management.dto.MgtArticleQuery; import com.ruoyi.article.controller.management.dto.MgtArticleUpdDTO; import com.ruoyi.article.controller.management.vo.MgtArticleVO; import com.ruoyi.article.domain.Article; import com.ruoyi.article.domain.ArticleComments; import com.ruoyi.article.domain.MemberArticleCollection; import com.ruoyi.article.domain.MemberLike; import com.ruoyi.article.mapper.ArticleMapper; import com.ruoyi.article.service.IArticleCommentsService; import com.ruoyi.article.service.IArticleService; import com.ruoyi.article.service.IMemberArticleCollectionService; import com.ruoyi.article.service.IMemberLikeService; import com.ruoyi.common.core.constant.SecurityConstants; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.enums.ArticleTypeEnum; import com.ruoyi.common.core.enums.AuditStatusEnum; import com.ruoyi.common.core.exception.ServiceException; import com.ruoyi.common.core.utils.StringUtils; import com.ruoyi.common.core.utils.page.BeanUtils; import com.ruoyi.common.core.utils.page.CollUtils; import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.common.security.utils.SecurityUtils; import com.ruoyi.system.api.domain.Member; import com.ruoyi.system.api.domain.SysUser; import com.ruoyi.system.api.domain.dto.MemberDTO; import com.ruoyi.system.api.feignClient.MemberClient; import com.ruoyi.system.api.feignClient.SysUserClient; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.Objects; import java.util.Set; import java.util.function.Function; import java.util.stream.Collectors; import javax.annotation.Resource; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; /** *

* 资讯表 服务实现类 *

* * @author mitao * @since 2024-05-16 */ @Service public class ArticleServiceImpl extends ServiceImpl implements IArticleService { @Resource private IArticleCommentsService articleCommentsService; @Resource private MemberClient memberClient; @Resource private IMemberLikeService memberLikeService; @Resource private IMemberArticleCollectionService memberArticleCollectionService; @Resource private SysUserClient sysUserClient; @Override public PageDTO getArticleList(ArticleDTO articleDTO) { Page
page = new Page<>(articleDTO.getPageCurr(), articleDTO.getPageSize()); LambdaQueryWrapper< Article> wrapper= Wrappers.lambdaQuery(); if (articleDTO.getArticleType()!=0){ wrapper.eq(Article::getArticleType,articleDTO.getArticleType()); } if (articleDTO.getTitle()!=null){ wrapper.like(Article::getTitle,articleDTO.getTitle()); } wrapper.eq(Article::getListingStatus,0); wrapper.eq(Article::getStatus,2); wrapper.eq( Article::getDelFlag,0); wrapper.orderByDesc(Article::getCreateTime); Page< Article> page1 = this.page(page, wrapper); PageDTO articleCommentsVOPageDTO = PageDTO.of(page1, ArticleVO.class); List list2 = articleCommentsVOPageDTO.getList(); for (ArticleVO articleVO:list2) { if (articleVO.getMemberId()!=null){ R membeOne = memberClient.getMembeOne(articleVO.getMemberId(), SecurityConstants.INNER); Member data = membeOne.getData(); articleVO.setMemberNickname(data.getNickname()); articleVO.setMemberAvatar(data.getAvatar()); }else{ articleVO.setMemberNickname("平台发布"); articleVO.setMemberAvatar("https://jyzx-obs.obs.cn-sccd1.ctyun.cn/d41508d822cb4b7896aaa1bb56e6167f.png"); } LambdaQueryWrapper wrapper1 = Wrappers.lambdaQuery(); wrapper1.eq(MemberLike::getMemberId, articleDTO.getMemberId()); wrapper1.eq(MemberLike::getArticleId, articleVO.getId()); wrapper1.eq(MemberLike::getType, 1); wrapper1.eq(MemberLike::getDelFlag, 0); List list = memberLikeService.list(wrapper1); if (list.size() > 0) { articleVO.setIsLike(1); } else { articleVO.setIsLike(2); } LambdaQueryWrapper wrapper2 = Wrappers.lambdaQuery(); wrapper2.eq(MemberArticleCollection::getMemberId, articleDTO.getMemberId()); wrapper2.eq(MemberArticleCollection::getTargetId, articleVO.getId()); wrapper2.eq(MemberArticleCollection::getDelFlag, 0); List list1 = memberArticleCollectionService.list(wrapper2); if (list1.size() > 0) { articleVO.setIsCollect(1); } else { articleVO.setIsCollect(2); } } return articleCommentsVOPageDTO; } @Override public PageDTO
getMemberArticleList(ArticleDTO articleDTO) { Page
page = new Page<>(articleDTO.getPageCurr(), articleDTO.getPageSize()); LambdaQueryWrapper< Article> wrapper= Wrappers.lambdaQuery(); wrapper.eq(Article::getMemberId,articleDTO.getMemberId()); wrapper.eq(Article::getArticleType,2); wrapper.eq( Article::getDelFlag,0); wrapper.orderByDesc(Article::getCreateTime); Page
page1 = this.page(page, wrapper); return PageDTO.of(page1); } @Override public void saveMemberArticle(ArticleDTO articleDTO) { Article article=new Article(); if (articleDTO.getId()!=null){ article=this.getById(articleDTO.getId()); } article.setMemberId(articleDTO.getMemberId()); article.setArticleType(ArticleTypeEnum.USER_POSTING); article.setStatus(AuditStatusEnum.TO_BE_REVIEWED); article.setContent(articleDTO.getContent()); article.setTitle(articleDTO.getTitle()); article.setImages(articleDTO.getRticleImageUrl()); this.saveOrUpdate(article); } @Override public void delMemberArticle(ArticleDTO articleDTO) { this.removeById(articleDTO.getId()); } @Override public ArticleVO getMemberArticleInfo(ArticleDTO articleDTO) { Article article=this.getById(articleDTO.getId()); if (StringUtils.isNull(article)) { throw new ServiceException("资讯不存在了"); } ArticleVO articleVO = BeanUtils.copyBean(article, ArticleVO.class); if(articleVO!=null){ R membeOne = memberClient.getMembeOne(articleVO.getMemberId(), SecurityConstants.INNER); Member data = membeOne.getData(); if (data!=null){ articleVO.setMemberNickname(data.getNickname()); articleVO.setMemberAvatar(data.getAvatar()); } }else{ articleVO.setMemberNickname("平台发布"); articleVO.setMemberAvatar("https://jyzx-obs.obs.cn-sccd1.ctyun.cn/d41508d822cb4b7896aaa1bb56e6167f.png"); } LambdaQueryWrapper wrapper1= Wrappers.lambdaQuery(); wrapper1.eq(MemberLike::getMemberId,articleDTO.getMemberId()); wrapper1.eq(MemberLike::getArticleId,article.getId()); wrapper1.eq(MemberLike::getType,1); wrapper1.eq( MemberLike::getDelFlag,0); List list = memberLikeService.list(wrapper1); if (list.size()>0){ articleVO.setIsLike(1); }else { articleVO.setIsLike(2); } LambdaQueryWrapper wrapper2= Wrappers.lambdaQuery(); wrapper2.eq(MemberArticleCollection::getMemberId,articleDTO.getMemberId()); wrapper2.eq(MemberArticleCollection::getTargetId,article.getId()); wrapper2.eq( MemberArticleCollection::getDelFlag,0); List list1 = memberArticleCollectionService.list(wrapper2); if (list1.size()>0){ articleVO.setIsCollect(1); }else { articleVO.setIsCollect(2); } return articleVO; } @Override public PageDTO getArticleCommentsList(ArticleDTO articleDTO) { Long userId = SecurityUtils.getUserId(); Member member = memberClient.getMemberByUserId(userId, SecurityConstants.INNER).getData(); Page page = new Page<>(articleDTO.getPageCurr(), articleDTO.getPageSize()); LambdaQueryWrapper< ArticleComments> wrapper= Wrappers.lambdaQuery(); wrapper.eq(ArticleComments::getArticleId,articleDTO.getId()); wrapper.eq( ArticleComments::getDelFlag,0); wrapper.eq( ArticleComments::getType,1); wrapper.orderByDesc(ArticleComments::getCreateTime); Page page1 = articleCommentsService.page(page, wrapper); PageDTO articleCommentsVOPageDTO = PageDTO.of(page1, ArticleCommentsVO.class); List list2 = articleCommentsVOPageDTO.getList(); if (list2!=null){ for(int i=0;i membeOne = memberClient.getMembeOne(articleCommentsVO.getMemberId(), SecurityConstants.INNER); Member data = membeOne.getData(); if (data!=null){ articleCommentsVO.setMemberNickname(data.getNickname()); articleCommentsVO.setMemberNickavatar(data.getAvatar()); }else{ articleCommentsVO.setMemberNickname("平台发布"); articleCommentsVO.setMemberNickavatar("https://jyzx-obs.obs.cn-sccd1.ctyun.cn/d41508d822cb4b7896aaa1bb56e6167f.png"); } LambdaQueryWrapper wrapper1= Wrappers.lambdaQuery(); wrapper1.eq(MemberLike::getMemberId, member.getId()); wrapper1.eq(MemberLike::getArticleId,articleCommentsVO.getId()); wrapper1.eq(MemberLike::getType,2); wrapper1.eq( MemberLike::getDelFlag,0); List list = memberLikeService.list(wrapper1); if (list.size()>0){ articleCommentsVO.setIslike(1); }else { articleCommentsVO.setIslike(2); } List articleCommentsVOList1=new ArrayList<>(); LambdaQueryWrapper< ArticleComments> wrapper2= Wrappers.lambdaQuery(); wrapper2.eq(ArticleComments::getReplyId,articleCommentsVO.getId()); wrapper2.eq( ArticleComments::getDelFlag,0); wrapper2.eq( ArticleComments::getType,2); List list1 = articleCommentsService.list(wrapper2); for (ArticleComments articleComments1:list1){ ArticleCommentsVO articleCommentsVO1=new ArticleCommentsVO(); R membeOne1 = memberClient.getMembeOne(articleComments1.getMemberId(), SecurityConstants.INNER); Member data1 = membeOne1.getData(); R membeOne2 = memberClient.getMembeOne(articleComments1.getBmemberId(), SecurityConstants.INNER); Member data2 = membeOne2.getData(); articleCommentsVO1.setArticleId(articleComments1.getArticleId()); articleCommentsVO1.setContent(articleComments1.getContent()); articleCommentsVO1.setMemberId(articleComments1.getMemberId()); articleCommentsVO1.setId(articleComments1.getId()); if (data1!=null){ articleCommentsVO1.setMemberNickname(data1.getNickname()); articleCommentsVO1.setMemberNickavatar(data1.getAvatar()); } articleCommentsVO1.setLikeCount(articleComments1.getLikeCount()); articleCommentsVO1.setCreateTime(articleComments1.getCreateTime()); if (data2!=null){ articleCommentsVO1.setBmemberNickname(data2.getNickname()); articleCommentsVO1.setBmemberNickavatar(data2.getAvatar()); articleCommentsVO1.setBmemberId(data2.getId()); } articleCommentsVO1.setState(articleComments1.getState()); LambdaQueryWrapper wrapper3= Wrappers.lambdaQuery(); wrapper3.eq(MemberLike::getMemberId,articleCommentsVO.getMemberId()); wrapper3.eq(MemberLike::getArticleId,articleComments1.getId()); wrapper3.eq(MemberLike::getType,2); wrapper3.eq( MemberLike::getDelFlag,0); List list3 = memberLikeService.list(wrapper3); if (list3.size()>0){ articleCommentsVO1.setIslike(1); }else { articleCommentsVO1.setIslike(2); } if (data1!=null){ articleCommentsVOList1.add(articleCommentsVO1); } } articleCommentsVO.setArticleCommentsVOList(articleCommentsVOList1); } } return articleCommentsVOPageDTO; } @Override public void getReport(ArticleDTO articleDTO) { Article article= this.getById(articleDTO.getId()); R membeOne = memberClient.getMembeOne(articleDTO.getMemberId(), SecurityConstants.INNER); Member data = membeOne.getData(); article.setReportBy(data.getId()); article.setReportedTime(LocalDateTime.now()); article.setReported(Boolean.TRUE); this.saveOrUpdate(article); } /** * 获取资讯列表的分页数据 * * @param query 资讯管理查询条件 * @return PageDTO */ @Override public PageDTO getArticlePage(MgtArticleQuery query) { // 构建查询条件 Set sysUserIdSet = null; Set memberIdSet = null; Page
page = new Page<>(query.getPageCurr(), query.getPageSize()); if (StringUtils.isNotBlank(query.getCreateBy()) || StringUtils.isNotBlank( query.getPhone())) { SysUser user = new SysUser(); user.setNickName(query.getCreateBy()); user.setPhonenumber(query.getPhone()); List sysUserList = sysUserClient.getUserListByName(user, SecurityConstants.INNER).getData(); if (CollUtils.isNotEmpty(sysUserList)) { sysUserIdSet = sysUserList.stream().map(SysUser::getUserId) .collect(Collectors.toSet()); } MemberDTO memberDTO = new MemberDTO(); memberDTO.setNickname(query.getCreateBy()); memberDTO.setPhone(query.getPhone()); List memberlist = memberClient.getMemberListByCondition(memberDTO, SecurityConstants.INNER).getData(); if (CollUtils.isNotEmpty(memberlist)) { memberIdSet = memberlist.stream().map(Member::getId) .collect(Collectors.toSet()); } if (StringUtils.isEmpty(sysUserIdSet) && StringUtils.isEmpty(memberIdSet)) { return PageDTO.empty(page); } } // 分页查询 page = this.lambdaQuery() .in(StringUtils.isNotEmpty(sysUserIdSet), Article::getCreateBy, sysUserIdSet) .or() .in(StringUtils.isNotEmpty(memberIdSet), Article::getMemberId, memberIdSet) .eq(StringUtils.isNotNull(query.getListingStatus()), Article::getListingStatus, query.getListingStatus()) .eq(StringUtils.isNotNull(query.getArticleType()), Article::getArticleType, query.getArticleType()) .eq(StringUtils.isNotNull(query.getStatus()), Article::getStatus, query.getStatus()) .in(StringUtils.isNotNull(query.getArticleType()) && query.getArticleType() .equals(ArticleTypeEnum.USER_POSTING), Article::getStatus, Lists.newArrayList(AuditStatusEnum.TO_BE_REVIEWED, AuditStatusEnum.REJECTED)) .like(StringUtils.isNotBlank(query.getTitle()), Article::getTitle, query.getTitle()) .orderByDesc(Article::getReported) .page(new Page<>(query.getPageCurr(), query.getPageSize())); // 若为空直接返回 if (StringUtils.isEmpty(page.getRecords())) { return PageDTO.empty(page); } /*根据资讯的发布类型分别从系统用户表和会员表中查询发布人信息并封装VO*/ PageDTO pageVO = PageDTO.of(page, MgtArticleVO.class); List voList = pageVO.getList(); Set sysUserIds = voList.stream().filter(articleVO -> articleVO.getArticleType() .equals(ArticleTypeEnum.PLATFORM_RELEASE)).map(MgtArticleVO::getCreateBy) .map(Integer::valueOf).collect( Collectors.toSet()); Map userMap; Map memberMap; if (StringUtils.isNotEmpty(sysUserIds)) { List userList = sysUserClient.getUserList(Lists.newArrayList(sysUserIds)) .getData(); userMap = userList.stream().collect( Collectors.toMap(SysUser::getUserId, Function.identity())); } else { userMap = null; } Set memIds = voList.stream().filter(articleVO -> articleVO.getArticleType() .equals(ArticleTypeEnum.USER_POSTING)).map(MgtArticleVO::getMemberId).collect( Collectors.toSet()); Set memIds2 = voList.stream().map(MgtArticleVO::getReportBy).filter( Objects::nonNull).map(Long::valueOf).collect( Collectors.toSet()); memIds.addAll(memIds2); if (StringUtils.isNotEmpty(memIds)) { List memberList = memberClient.getMemberListByIds(memIds, SecurityConstants.INNER).getData(); memberMap = memberList.stream().collect( Collectors.toMap(Member::getId, Function.identity())); } else { memberMap = null; } if (StringUtils.isNotEmpty(userMap)) { voList.stream().filter(articleVO -> articleVO.getArticleType() .equals(ArticleTypeEnum.PLATFORM_RELEASE)).forEach(articleVO -> { SysUser sysUser = userMap.get(Long.valueOf(articleVO.getCreateBy())); if (StringUtils.isNotNull(sysUser)) { articleVO.setCreateBy(sysUser.getNickName()); articleVO.setPhone(sysUser.getPhonenumber()); } else { articleVO.setCreateBy(null); } }); } if (StringUtils.isNotEmpty(memberMap)) { voList.stream().filter(articleVO -> articleVO.getArticleType() .equals(ArticleTypeEnum.USER_POSTING)).forEach(articleVO -> { Member member = memberMap.get(articleVO.getMemberId()); if (StringUtils.isNotNull(member)) { articleVO.setCreateBy(member.getNickname()); articleVO.setPhone(member.getPhone()); } else { articleVO.setCreateBy(null); } }); voList.stream().filter(articleVO -> articleVO.getReported().equals(Boolean.TRUE)) .peek(articleVO -> { Member member = memberMap.get(Long.valueOf(articleVO.getReportBy())); if (StringUtils.isNotNull(member)) { articleVO.setReportBy(member.getNickname()); } }).collect(Collectors.toList()); } return pageVO; } /** * "添加/编辑资讯 * * @param dto 管理后台-资讯传输对象 */ @Override public void saveArticle(MgtArticleDTO dto) { Article article = BeanUtils.copyBean(dto, Article.class); if (StringUtils.isNull(article.getId())) { article.setStatus(AuditStatusEnum.PASSED); article.setArticleType(ArticleTypeEnum.PLATFORM_RELEASE); this.save(article); } else { Article articleById = this.getById(article.getId()); if (StringUtils.isNull(articleById)) { throw new ServiceException("资讯不存在"); } this.updateById(article); } } /** * 处理举报 * * @param id 资讯id */ @Override public void handleReport(Long id) { Article article = this.getById(id); if (StringUtils.isNull(article)) { throw new ServiceException("资讯不存在"); } if (Boolean.FALSE.equals(article.getReported())) { throw new ServiceException("该资讯未举报"); } article.setReported(Boolean.FALSE); this.updateById(article); } /** * 查看详情 * * @param id 资讯id * @return MgtArticleVO */ @Override public MgtArticleVO getDetail(Long id) { Article article = this.getById(id); if (StringUtils.isNull(article)) { throw new ServiceException("资讯不存在"); } MgtArticleVO mgtArticleVO = BeanUtils.copyBean(article, MgtArticleVO.class); long count = articleCommentsService.count( Wrappers.lambdaQuery(ArticleComments.class).eq(ArticleComments::getArticleId, id) .eq(ArticleComments::getType, 1)); mgtArticleVO.setCommentCount((int) count); return mgtArticleVO; } /** * 资讯审核 * * @param dto 管理后台-资讯审核传输对象 */ @Override public void audit(MgtArticleAuditDTO dto) { Article article = this.getById(dto.getId()); if (StringUtils.isNull(article)) { throw new ServiceException("资讯不存在"); } article.setStatus(dto.getStatus()); if (AuditStatusEnum.REJECTED.equals(dto.getStatus())) { article.setRefuseComment(dto.getRefuseComment()); } this.updateById(article); } /** * 上架/下架 * * @param dto 资讯上下架数据传输对象 */ @Override public void updStatus(MgtArticleUpdDTO dto) { this.lambdaUpdate().set(Article::getListingStatus, dto.getListingStatus()) .eq(Article::getId, dto.getId()).update(); } @Override @Transactional(rollbackFor = Exception.class) public void removeCommentsById(Long id) { ArticleComments articleComments = articleCommentsService.getById(id); if (StringUtils.isNull(articleComments)) { throw new ServiceException("评论/回复不存在"); } articleCommentsService.removeById(id); // 评论 if (articleComments.getType().equals(1)) { // 查询回复 List replyList = articleCommentsService.lambdaQuery() .eq(ArticleComments::getReplyId, id).list(); if (StringUtils.isNotEmpty(replyList)) { List replyIds = replyList.stream().map(ArticleComments::getId) .collect(Collectors.toList()); articleCommentsService.removeByIds(replyIds); } } } }