package org.ruoyi.system.service.impl; import cn.dev33.satoken.stp.StpUtil; import cn.hutool.core.util.ObjectUtil; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import lombok.RequiredArgsConstructor; import org.ruoyi.common.core.utils.MapstructUtils; import org.ruoyi.common.core.utils.StringUtils; import org.ruoyi.common.satoken.utils.LoginHelper; import org.ruoyi.core.page.PageQuery; import org.ruoyi.core.page.TableDataInfo; import org.ruoyi.system.domain.SysNotice; import org.ruoyi.system.domain.SysNoticeState; import org.ruoyi.system.domain.SysUser; import org.ruoyi.system.domain.bo.SysNoticeBo; import org.ruoyi.system.domain.vo.SysNoticeVo; import org.ruoyi.system.domain.vo.SysUserVo; import org.ruoyi.system.mapper.SysNoticeMapper; import org.ruoyi.system.mapper.SysNoticeStateMapper; import org.ruoyi.system.mapper.SysUserMapper; import org.ruoyi.system.service.ISysNoticeService; import org.springframework.stereotype.Service; import java.util.ArrayList; import java.util.Arrays; import java.util.List; /** * 公告 服务层实现 * * @author Lion Li */ @RequiredArgsConstructor @Service public class SysNoticeServiceImpl implements ISysNoticeService { private final SysNoticeMapper baseMapper; private final SysNoticeStateMapper noticeStateMapper; private final SysUserMapper userMapper; @Override public TableDataInfo selectPageNoticeList(SysNoticeBo notice, PageQuery pageQuery) { LambdaQueryWrapper lqw = buildQueryWrapper(notice); Page page = baseMapper.selectVoPage(pageQuery.build(), lqw); return TableDataInfo.build(page); } /** * 查询公告信息 * * @param noticeId 公告ID * @return 公告信息 */ @Override public SysNoticeVo selectNoticeById(Long noticeId) { return baseMapper.selectVoById(noticeId); } /** * 查询公告列表 * * @param notice 公告信息 * @return 公告集合 */ @Override public SysNotice getNotice(SysNoticeBo notice) { if(!StpUtil.isLogin()){ return null; } LambdaQueryWrapper lqwState = Wrappers.lambdaQuery(); Long userId = LoginHelper.getLoginUser().getUserId(); lqwState.eq(userId != null, SysNoticeState::getUserId, userId); // 查询未读通知 lqwState.eq(SysNoticeState::getReadStatus, "0"); lqwState.orderByDesc(SysNoticeState::getCreateTime); // 按创建时间降序排序 List states = noticeStateMapper.selectList(lqwState); // 查询公告阅读状态 SysNoticeState sysNoticeState = states.isEmpty() ? null : states.get(0); // 取第一条记录 if (sysNoticeState != null) { return baseMapper.selectById(sysNoticeState.getNoticeId()); }else { return null; } } private LambdaQueryWrapper buildQueryWrapper(SysNoticeBo bo) { LambdaQueryWrapper lqw = Wrappers.lambdaQuery(); lqw.like(StringUtils.isNotBlank(bo.getNoticeTitle()), SysNotice::getNoticeTitle, bo.getNoticeTitle()); lqw.eq(StringUtils.isNotBlank(bo.getNoticeType()), SysNotice::getNoticeType, bo.getNoticeType()); if (StringUtils.isNotBlank(bo.getCreateByName())) { SysUserVo sysUser = userMapper.selectUserByUserName(bo.getCreateByName()); lqw.eq(SysNotice::getCreateBy, ObjectUtil.isNotNull(sysUser) ? sysUser.getUserId() : null); } return lqw; } /** * 新增公告 * * @param bo 公告信息 * @return 结果 */ @Override public int insertNotice(SysNoticeBo bo) { SysNotice notice = MapstructUtils.convert(bo, SysNotice.class); // 插入公告 int insert = baseMapper.insert(notice); // 公告类型(1通知 2公告) if("1".equals(bo.getNoticeType())){ // 将之前通知全部设为已读 noticeStateMapper.readAllNotice(); // 插入通知阅读状态 List sysUserList = userMapper.selectList(); List noticeStateList = new ArrayList<>(); for (SysUser sysUser : sysUserList) { SysNoticeState sysNoticeState = new SysNoticeState(); if (notice != null) { sysNoticeState.setNoticeId(notice.getNoticeId()); sysNoticeState.setUserId(sysUser.getUserId()); noticeStateList.add(sysNoticeState); } } noticeStateMapper.insertBatch(noticeStateList); } return insert; } /** * 修改公告 * * @param bo 公告信息 * @return 结果 */ @Override public int updateNotice(SysNoticeBo bo) { SysNotice notice = MapstructUtils.convert(bo, SysNotice.class); return baseMapper.updateById(notice); } /** * 删除公告对象 * * @param noticeId 公告ID * @return 结果 */ @Override public int deleteNoticeById(Long noticeId) { return baseMapper.deleteById(noticeId); } /** * 批量删除公告信息 * * @param noticeIds 需要删除的公告ID * @return 结果 */ @Override public int deleteNoticeByIds(Long[] noticeIds) { return baseMapper.deleteBatchIds(Arrays.asList(noticeIds)); } }