LambdaQueryWrapper 自定义返回字段(分组后统计)

最新推荐文章于 2024-05-18 16:22:30 发布

MMO_

最新推荐文章于 2024-05-18 16:22:30 发布

阅读量1.3w

点赞数

分类专栏： java mybaitsplus 文章标签： java 开发语言

本文链接：https://blog.csdn.net/u010012932/article/details/126746286

版权

java 同时被 2 个专栏收录

18 篇文章 2 订阅

订阅专栏

mybaitsplus

1 篇文章 0 订阅

订阅专栏

QueryWrapper 指定想要返回的字段名，然后转化为LambdaQueryWrapper；

 QueryWrapper<RiskResultsDO> wrapper = new QueryWrapper<>();
        wrapper.select("count(1) as countNum,risk_level_code as riskLevelCode,whether_forecast as whetherForecast ");
        LambdaQueryWrapper<RiskResultsDO> searchInfo = riskResultsRepository.dealSearchInfo(req, wrapper.lambda());
        searchInfo.groupBy(RiskResultsDO::getWhetherForecast);
        searchInfo.groupBy(RiskResultsDO::getRiskLevelCode);
        List<Map<String, Object>> maps = riskResultsRepository.listMaps(searchInfo);

搜索条件处理

 public LambdaQueryWrapper<RiskResultsDO> dealSearchInfo(RiskResultsPageReq req, LambdaQueryWrapper<RiskResultsDO> lambdaQueryWrapper, SFunction<RiskResultsDO, ?> sortFiled, boolean whetherAsc) {
        lambdaQueryWrapper.eq(StringUtils.isNotBlank(req.getEvaluationTypeCode()), RiskResultsDO::getEvaluationTypeCode, req.getEvaluationTypeCode())
                .ge(StringUtils.isNotBlank(req.getStartEvaluationTime()), RiskResultsDO::getEvaluationTime, req.getStartEvaluationTime() + DateUtilConstant.MIN_DAY_TIME)
                .le(StringUtils.isNotBlank(req.getEndEvaluationTime()), RiskResultsDO::getEvaluationTime, req.getEndEvaluationTime() + DateUtilConstant.MAX_DAY_TIME)
                .ge(StringUtils.isNotBlank(req.getStartForecastBelongTime()), RiskResultsDO::getForecastBelongTime, req.getStartForecastBelongTime() + DateUtilConstant.MIN_DAY_TIME)
                .le(StringUtils.isNotBlank(req.getEndForecastBelongTime()), RiskResultsDO::getForecastBelongTime, req.getEndForecastBelongTime() + DateUtilConstant.MAX_DAY_TIME)
                .apply(ObjectUtil.isNotNull(req.getAreaId()), " FIND_IN_SET (" + req.getAreaId() + ",area_ids) ")
                .eq(ObjectUtil.isNotNull(req.getWhetherForecast()), RiskResultsDO::getWhetherForecast, req.getWhetherForecast())
                .eq(ObjectUtil.isNotNull(req.getStationAreaId()), RiskResultsDO::getAreaId, req.getStationAreaId())
                .eq(ObjectUtil.isNotNull(req.getRiskLevelCode()), RiskResultsDO::getRiskLevelCode, req.getRiskLevelCode())
                .eq(ObjectUtil.isNotNull(req.getBelongTypeCode()), RiskResultsDO::getBelongTypeCode, req.getBelongTypeCode());
        if (ObjectUtil.isNotEmpty(req.getWhetherTown()) && req.getWhetherTown().equals(1)) {
            lambdaQueryWrapper.isNotNull(RiskResultsDO::getVillageTownId);
        }
        lambdaQueryWrapper.orderBy(true, whetherAsc, sortFiled);
        return lambdaQueryWrapper;
    }