package cn.exrick.xboot.core.serviceimpl; import cn.exrick.xboot.core.common.vo.SearchVo; import cn.exrick.xboot.core.dao.MessageDao; import cn.exrick.xboot.core.entity.Message; import cn.exrick.xboot.core.service.MessageService; import cn.hutool.core.date.DateUtil; import cn.hutool.core.util.StrUtil; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.jpa.domain.Specification; import org.springframework.lang.Nullable; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.persistence.criteria.*; import java.util.ArrayList; import java.util.Date; import java.util.List; /** * 消息内容接口实现 * @author Exrick */ @Slf4j @Service @Transactional public class MessageServiceImpl implements MessageService { @Autowired private MessageDao messageDao; @Override public MessageDao getRepository() { return messageDao; } @Override public Page findByCondition(Message message, SearchVo searchVo, Pageable pageable) { return messageDao.findAll(new Specification() { @Nullable @Override public Predicate toPredicate(Root root, CriteriaQuery cq, CriteriaBuilder cb) { Path titleField = root.get("title"); Path contentField = root.get("content"); Path typeField = root.get("type"); Path isTemplateField = root.get("isTemplate"); Path createTimeField = root.get("createTime"); List list = new ArrayList<>(); // 模糊搜素 if (StrUtil.isNotBlank(message.getTitle())) { list.add(cb.like(titleField, '%' + message.getTitle() + '%')); } if (StrUtil.isNotBlank(message.getContent())) { list.add(cb.like(contentField, '%' + message.getContent() + '%')); } if (message.getType() != null) { list.add(cb.equal(typeField, message.getType())); } if (message.getIsTemplate() != null) { list.add(cb.equal(isTemplateField, message.getIsTemplate())); } // 创建时间 if (StrUtil.isNotBlank(searchVo.getStartDate()) && StrUtil.isNotBlank(searchVo.getEndDate())) { Date start = DateUtil.parse(searchVo.getStartDate()); Date end = DateUtil.parse(searchVo.getEndDate()); list.add(cb.between(createTimeField, start, DateUtil.endOfDay(end))); } Predicate[] arr = new Predicate[list.size()]; cq.where(list.toArray(arr)); return null; } }, pageable); } @Override public List findByCreateSend(Boolean createSend) { return messageDao.findByCreateSend(createSend); } }