跨库分页实现代码

weixin_46974942

已于 2024-08-06 09:57:59 修改

阅读量554

点赞数 7

文章标签： java spring

于 2024-08-06 09:40:42 首次发布

本文链接：https://blog.csdn.net/weixin_46974942/article/details/140945982

版权

@Override
public IPage<RetBulletinVO> getNotice(IPage<RetBulletinVO> page, RetBulletinVO retBulletinVO) {
  /*  if (ObjectUtil.isEmpty(retBulletinVO)) {
        return null;
    }*/
    RetBulletinVO retBulletin = new RetBulletinVO();
    ArrayList<RetBulletinVO> collList = new ArrayList<>();

    //结果公告
    if ("30".equals(retBulletinVO.getType()) || "20".equals(retBulletinVO.getType())) {
        List<RetBulletinVO> retBulletinList = retBulletinMapper.getNotice(retBulletinVO);
        if (CollectionUtils.isNotEmpty(retBulletinList)) {
            for (RetBulletinVO bulletinVO : retBulletinList) {
                retBulletin = new RetBulletinVO();
                retBulletin.setId(bulletinVO.getId());
                retBulletin.setTitle(bulletinVO.getTitle());
                retBulletin.setBulletinType("结果公告");
                retBulletin.setSendTime(bulletinVO.getPublishTime());
                retBulletin.setPublishTime(bulletinVO.getPublishTime());
                collList.add(retBulletin);
            }
        }
    }
    //寻源公告
    if ("30".equals(retBulletinVO.getType()) || "10".equals(retBulletinVO.getType())) {
        IMbdLibScoreApiService scoreapiservice = SpringBeanFactory.getBean(IMbdLibScoreApiService.class);
        RetBulletinPageVO retBulletinPageVO = new RetBulletinPageVO();
        BeanUtils.copyProperties(retBulletinVO, retBulletinPageVO);
        ResultData<List<RetBulletinPageVO>> punishs = scoreapiservice.getPunish(retBulletinPageVO);
        List<RetBulletinPageVO> data = punishs.getData();
        if (CollectionUtils.isNotEmpty(data)) {
            for (RetBulletinPageVO bulletinPageVO : data) {
                if (StringUtil.isNotBlank(bulletinPageVO.getTitle())) {
                    retBulletin = new RetBulletinVO();
                    retBulletin.setTitle(bulletinPageVO.getTitle());
                    retBulletin.setSendTime(bulletinPageVO.getPublishTime());
                    retBulletin.setPublishTime(bulletinPageVO.getPublishTime());
                    retBulletin.setBulletinType("寻源公告");
                    retBulletin.setId(bulletinPageVO.getId());
                    collList.add(retBulletin);
                }
            }
        }
    }
    List<RetBulletinVO> pageResult = collList.stream()
            .sorted(Comparator.comparing(RetBulletinVO::getSendTime, Comparator.nullsLast(Comparator.reverseOrder())))
            .skip((page.getCurrent() - 1L) * page.getSize()).limit(page.getSize()).collect(Collectors.toList());
    //记录总条数
    int nums = collList.size();
    page.setRecords(pageResult);
    page.setTotal(nums);
    return page;
}