Example实现排序

最新推荐文章于 2023-06-09 22:43:44 发布

爱吃血肠

最新推荐文章于 2023-06-09 22:43:44 发布

阅读量3.8k

点赞数 1

注意：本文归作者所有，未经作者允许，不得转载

本文链接：https://blog.csdn.net/yunfengfengfeng/article/details/118294287

版权

public PageInfo getAllLimitList(PayLimitWarnQueryModel payLimitWarnQueryModel) {
        log.info("根据条件查询龙支付余额预警列表,param:[{}]", JSONObject.toJSONString(payLimitWarnQueryModel));
        int pageNum = payLimitWarnQueryModel.getPageNum() - 1;
        int pageSize = payLimitWarnQueryModel.getPageSize();
        PageHelper.offsetPage(pageNum * pageSize, pageSize, true);
        Example example = new Example(PayLimitWarn.class);
        example.setOrderByClause("warn_create desc");
        Example.Criteria criteria = example.createCriteria();
        if (payLimitWarnQueryModel.getHandleStatus() != null) {
            criteria.andEqualTo("handleStatus", payLimitWarnQueryModel.getHandleStatus());
        }
        if (payLimitWarnQueryModel.getStartTime() != null || payLimitWarnQueryModel.getEndTime() != null) {
            criteria.andBetween("warnCreate", payLimitWarnQueryModel.getStartTime(), payLimitWarnQueryModel.getEndTime());
        }
        List<PayLimitWarn> payLimitWarns = payLimitWarnMapper.selectByExample(example);
        if (!payLimitWarns.isEmpty()) {
            for (PayLimitWarn payLimitWarn : payLimitWarns) {
                if (payLimitWarn != null && payLimitWarn.getPayChannel() != null) {
                    payLimitWarn.setPayChannelDesc(PayChannelEnum.getMsg(String.valueOf(payLimitWarn.getPayChannel())));
                }
            }
        }
        PageInfo pageInfo = new PageInfo(payLimitWarns);
        return pageInfo;
    }