JAVA查询ODD列表

挽手等风起

于 2022-07-05 16:56:56 发布

阅读量228

点赞数

分类专栏： java 文章标签： servlet

本文链接：https://blog.csdn.net/qq_36697196/article/details/125623478

版权

java 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

    @Override
    public PageInfo<BadEventOddResponse> getBadEventOddList(@Param("request") BadEventOddListRequest request) {
        //分页查询列表
        Page<BadEventOdd> badEventOddPage = badEventOddMapper.selectPage(new Page<>(request.getPageNo(), request.getPageSize()), buildQuery(request));

        //总数查询
        long total = badEventOddPage.getTotal();
        //封装结果集
        List<BadEventOdd> records = badEventOddPage.getRecords();

        //给前端拼接数据

        //赋值转换
        List<BadEventOddResponse> responses = BeanUtil.copyToList(records, BadEventOddResponse.class);

        //设置数据
        PageInfo<BadEventOddResponse> badEventResponsePageInfo = new PageInfo<>(responses);
        //设置 总数
        badEventResponsePageInfo.setTotal(total);


        return badEventResponsePageInfo;
    }



    private QueryWrapper<BadEventOdd> buildQuery(BadEventOddListRequest request) {
        QueryWrapper<BadEventOdd> queryWrapper = new QueryWrapper<>();
        if (StringUtils.isNotBlank(request.getBadEventId()))
            queryWrapper.eq("bad_event_id", request.getBadEventId());
        //ODO 城市

        //获取数据
//        String testRegion = this.getBaseMapper().getTestRegion(request);


        if (StringUtils.isNotBlank(request.getStatus()))
            queryWrapper.eq("source", request.getStatus());
        if (StringUtils.isNotBlank(request.getSource()))
            queryWrapper.eq("source", request.getSource());
        if (!Objects.isNull(request.getOddType()))
            queryWrapper.eq("odd_type", request.getOddType());
        if (!Objects.isNull(request.getOddType()))
            queryWrapper.eq("is_valid", request.getIsValid());
        if (!Objects.isNull(request.getOddEffectiveList()))
            queryWrapper.eq("effective_release_list", request.getOddEffectiveList());
        if (StringUtils.isNotBlank(request.getCreateDate()))
            queryWrapper.eq("create_date", request.getCreateDate());
        if (StringUtils.isNotBlank(request.getUpdateDate()))
            queryWrapper.eq("update_date", request.getUpdateDate());
        queryWrapper.eq("is_delete", 0);
        queryWrapper.orderByDesc("create_date");

        return queryWrapper;

    }