mybatis-plus 分页

@Override
public SealListResp queryList(SealListVo sealListVo) {

    QueryWrapper<ElectronicSealTotal> wrapper = new QueryWrapper<>();
    wrapper.eq(StringUtil.isNotEmpty(sealListVo.getUserName()), "user_name", sealListVo.getUserName()).
            eq(StringUtil.isNotEmpty(sealListVo.getUserType()), "user_type", sealListVo.getUserType()).
            eq(StringUtil.isNotEmpty(sealListVo.getUserIdNo()), "info_sn", sealListVo.getUserIdNo()).
            eq(StringUtil.isNotEmpty(sealListVo.getCertSn()), "cert_sn", sealListVo.getCertSn()).
            eq(StringUtil.isNotEmpty(sealListVo.getAppName()), "app_name", sealListVo.getAppName()).
            eq(sealListVo.getStatus() != 0, "seal_status", sealListVo.getStatus());

    if (StringUtil.isNotEmpty(sealListVo.getBeginTime())) {
        wrapper.ge("create_time", sealListVo.getBeginTime());
    }
    if (StringUtil.isNotEmpty(sealListVo.getEndTime())) {
        Date date = DateFormater.formatEndTime(sealListVo.getEndTime());
        wrapper.le("create_time", date);
    }
    wrapper.orderBy(true, false, "create_time");
    //分页
    //默认pagenum,pagesize  1,10
    Long pageNum = 1L;
    Long pageSize = 10L;
    if (StringUtil.isNotEmpty(sealListVo.getPageNum())) {
        pageNum = Long.parseLong(sealListVo.getPageNum());
    }
    if (StringUtil.isNotEmpty(sealListVo.getPageNum())) {
        pageSize = Long.parseLong(sealListVo.getPageSize());
    }

//分页
    Page<ElectronicSealTotal> page = new Page<>(pageNum, pageSize);
    IPage<ElectronicSealTotal> sealIPage = electronicSealTotalService.page(page, wrapper);
    List<SealListResult> sealListResults = new ArrayList<SealListResult>();
    for (ElectronicSealTotal sealTotal : sealIPage.getRecords()) {

        ElectronicSeal seal = electronicSealService.getOne(Wrappers.<ElectronicSeal>lambdaQuery()
                .eq(ElectronicSeal::getSealSn, sealTotal.getSealSn()));
        SealListResult sealListResult = new SealListResult();
        if (ObjectUtils.isNotEmpty(seal)) {
            BeanUtils.copyProperties(seal, sealListResult);
            sealListResult.setStatus(seal.getSealStatus());
            String ESseal =fdfsService.download(seal.getSealUri());
            sealListResult.setSeal(ESseal);

            //拼装缺失的数据
            //idno  idnotype
            sealListResult.setUserIdNo(seal.getInfoSn());
            sealListResult.setUserIdNoType(seal.getInfoType());

            //根据stampSn查询印章信息
            String stampSn = seal.getStampSn();
            Stamp stamp = stampService.getOne(Wrappers.<Stamp>lambdaQuery().eq(Stamp::getStampSn, stampSn));

            sealListResult.setPicType(stamp.getStampFormat());
            sealListResult.setPicData(stamp.getStampUri());
            sealListResults.add(sealListResult);
        }

    }
    SealListResp sealListResp = new SealListResp();
    String total = String.valueOf(sealIPage.getTotal());
    sealListResp.setTotal(total);
    sealListResp.setData(sealListResults);

    return sealListResp;
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值