java编码实现根据某个字段分组，再统计某个值

最新推荐文章于 2024-03-05 23:05:35 发布

VIP文章零落成泥560

最新推荐文章于 2024-03-05 23:05:35 发布

阅读量814

点赞数

分类专栏：随笔记文章标签： java mybatis 开发语言

本文链接：https://blog.csdn.net/yesenmanong/article/details/127243812

版权

实现层逻辑如下：

@Override
    public DesignChangeChangedAmountVo queryChangedAmounts() {
        List<DesignChange> designChangeList = this.lambdaQuery()
                .eq(DesignChange::getStatus, Constants.DesignChangeStatus.SHEN_PI_TONG_GUO)
                .eq(DesignChange::getDelFlag, CommonConstant.DEL_FLAG_0)
                .list();

        DesignChangeChangedAmountVo result = new DesignChangeChangedAmountVo();
        //根据合同分组
        Map<String, List<DesignChange>> contractMap = designChangeList.stream()
                .collect(Collectors.groupingBy(DesignChange::getContractId));

        List<DesignChangeChangedAmountVo.ContractTotalChangedAmounts> contracts = new ArrayList<>();
        contractMap.keySet().forEach(i -> {
            List<DesignChange> ls = contractMap.get(i);
            DesignChangeChangedAmountVo.ContractTotalChangedAmounts info = new DesignChangeChangedAmountVo.ContractTotalChangedAmounts();
            info.setContractId(ls.get(0).getContractId());
            info.setContractName(ls.get(0).getContractName());
            //累计造价咨询单位审核金额
            BigDecimal totalChangedAmount = ls.stream().map(DesignChange::getCostConsultUnitAuditAmount)
                    .filter(Objects::nonNull)
                    .reduce(BigDecimal.ZERO, BigDecimal::add);
            info.setContractTotalChangedAmount(totalChangedAmount);