费用报表0819

chengf

2025-08-19 c7255cb752c12bf5c0c5e2b8bac0ad82d4cdf71b

 service-fee/src/main/java/com/java110/fee/cmd/fee/ReportFeeCmd.java

@@ -22,10 +22,7 @@

import java.math.BigDecimal;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.*;

@Java110Cmd(serviceCode = "fee.reportFeeCmd")
public class ReportFeeCmd extends Cmd {
@@ -56,49 +53,93 @@
        int currentYear = java.time.Year.now().getValue();
        feeQueryParams.setEndYear(currentYear + 2);
        int endYear = feeQueryParams.getEndYear();

        List<Map> result = reportFeeInnerServiceSMOImpl.repostPaidInFee(feeQueryParams);
        List<Map> resultTwo =  reportFeeInnerServiceSMOImpl.repostPaidInFeeTwo(feeQueryParams);
        DictDto dictDto = new DictDto();
        dictDto.setTableName("pay_fee_config");
        dictDto.setTableColumns("fee_type_cd");
        List<DictDto> dictDtos = dictV1InnerServiceSMOImpl.queryDicts(dictDto);
        int doYear = endYear - startYear;
        List<List<FeeDto>> reportFeeDtoLists = new ArrayList<>();
        List<List<FeeDto>> reportFeeDtoLists = new LinkedList<>();
        reportFeeDtoLists.add(new LinkedList<FeeDto>());
        reportFeeDtoLists.add(new LinkedList<FeeDto>());
        reportFeeDtoLists.add(new LinkedList<FeeDto>());
        reportFeeDtoLists.add(new LinkedList<FeeDto>());
        int ind = 1;
        for (DictDto dictDto1 : dictDtos) {//类型
            List<FeeDto> reportFeeDtos = new ArrayList<>();
            for (int i = startYear; i <= endYear; i++) {
                for (Map map : result) {
                    FeeDto feeDto = new FeeDto();
                    if (map.get("统计周期")!=null&&map.get("统计周期").equals(i)&&map.get("费用类型编码").equals(dictDto1.getStatusCd())){
                        feeDto.setCurYear((i)+"");
                        feeDto.setFeeTypeCdName(map.get("费用类型名称")+"");
                        double[] doubles = new double[doYear];
                        for (int j = startYear ; j <= endYear ; j++) {
                            if(map.get((j)+"年收费金额(元)")!=null){
                                doubles[j-startYear] = ((BigDecimal)map.get((j)+"年收费金额(元)")).doubleValue();
            List<FeeDto> reportFeeDtos = new LinkedList<>();
            FeeDto feeDto = new FeeDto();
            LinkedList<FeeDto> feeDtos = new LinkedList<>();
            reportFeeDtoLists.add(feeDtos);
            for (int i = startYear; i <= endYear; i++) {//年份
                double[] doubles = new double[doYear+12+1+5];
                feeDto = new FeeDto();
                //0~5
                if(resultTwo != null){
                    for (Map map : resultTwo) {
                        if(map.isEmpty()){
                            break;
                        }
                        else if (map.get("统计周期")!=null&&map.get("统计周期").equals(i)&&map.get("费用类型编码").equals(dictDto1.getStatusCd())){
                            feeDto.setCurYear((i)+"");
                            feeDto.setFeeTypeCdName(map.get("费用类型")+"");
                            doubles[0] = map.get("当年应缴总金额") == null ? 0 : (double) map.get("当年应缴总金额");
                            doubles[1] = map.get("每月费用（合计/月份数）") == null ? 0 : (double) map.get("每月费用（合计/月份数）");
                            doubles[2] = map.get("每月费用月份数") == null ? 0 : ((Long) map.get("每月费用月份数")).intValue();
                        }
                    }
                }

                if(result != null){
                    for (Map map : result) {//类型+年份
                        if(map.isEmpty()){
                            break;
                        }
                        //5 ~ 25
                        else if (map.get("统计周期")!=null&&map.get("统计周期").equals(i)&&map.get("费用类型编码").equals(dictDto1.getStatusCd())){

                            for (int j = startYear ; j <= endYear ; j++) {// 5~(endYear - startYear + 5) = 5 ~ 13
                                if(map.get((j)+"年收费金额(元)")!=null){
                                    feeDto.setCurYear((i)+"");
                                    feeDto.setFeeTypeCdName(map.get("费用类型名称") == null ? null : map.get("费用类型名称")+"");
                                    doubles[j-startYear+5] = ((BigDecimal)map.get((j)+"年收费金额(元)")).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
                                }
                                for (int x = 1 ;x <= 12 ;x++ ){// (endYear - startYear + 6) ~ (endYear - startYear + 6 + 12) = 13 ~ 25
                                    if (map.get((currentYear)+"年"+x+"月收费金额(元)")!=null){
                                        feeDto.setCurYear((i)+"");
                                        feeDto.setFeeTypeCdName(map.get("费用类型名称") == null ? null : map.get("费用类型名称")+"");
                                        doubles[endYear - startYear + x +5] = ((BigDecimal)map.get((currentYear)+"年"+x+"月收费金额(元)")).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
                                    }
                                }
                            }
                        }
                        feeDto.setReport(doubles);
                        reportFeeDtos.add(feeDto);
                    }
//                    if(startYear == currentYear){
//                        for (int x = 1 ; x <= 12 ; x++){
//                            feeDto = new FeeDto();
//                            feeDto.setCurYear(startYear+"/"+x);
//                            feeDto.setFeeTypeCdName(dictDto1.getName());
//                            if(map.get(startYear + "年" + x + "月收费金额(元)")!=null){
//                                d
//                            }
//                        }
//                    }

                }
                if(feeDto.getCurYear() != null){
                    feeDto.setReport(doubles);
                    reportFeeDtos.add(feeDto);
                }
            }
            if (ind == 3 || ind == 7){
                reportFeeDtoLists.add(new LinkedList<>());
            }
            reportFeeDtoLists.add(reportFeeDtos);
            if(ind == 1 || ind == 2){
                reportFeeDtoLists.add(new LinkedList<>());
            }
            ind ++;
        }
        int[] arr = new int[endYear - startYear + 1];
        for (int i = startYear; i <= endYear; i++) {
            arr[i-startYear] = i;
        }
        FeeDto feeDto = new FeeDto();
        feeDto.setRepostList(reportFeeDtoLists);
        feeDto.setYearArr(arr);



        ResultVo resultVo = new ResultVo(reportFeeDtoLists);
        ResultVo resultVo = new ResultVo(feeDto);

        ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);