水电话费

jialh

1 天以前 dd6687b118561100e1677e88a9c2f5842a54c531

 service-fee/src/main/java/com/java110/fee/dao/impl/IReportFeeServiceDaoImpl.java

@@ -2,6 +2,7 @@

import com.java110.core.base.dao.BaseServiceDao;
import com.java110.core.log.LoggerFactory;
import com.java110.dto.report.ReportQueryRecord;
import com.java110.fee.dao.IInitializePayFeeServiceDao;
import com.java110.fee.dao.IReportFeeServiceDao;
import com.java110.utils.util.BeanConvertUtil;
@@ -10,10 +11,7 @@
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.*;
import java.util.stream.Collectors;
import java.util.stream.IntStream;

@@ -38,6 +36,61 @@
        params.put("monthList", monthList);
        params.put("endYear", feeQueryParams.getEndYear());
        params.put("yearList", yearList);
        params.put("currentYear", feeQueryParams.getEndYear() - 2);
        return sqlSessionTemplate.selectList("reportFeeServiceDaoImpl.repostInFee", params);
    }


    @Override
    public List<Map> repostPaidInFeeTwo(FeeQueryParams feeQueryParams) {
        List<Integer> yearList = new ArrayList<>();
        for (int year = feeQueryParams.getStartYear(); year <= feeQueryParams.getEndYear(); year++) {
            yearList.add(year);
        }
        List<String> monthList = IntStream.rangeClosed(1, 12)
                .mapToObj(month -> String.format("%02d", month))
                .collect(Collectors.toList());

        Map<String, Object> params = new HashMap<>();
        params.put("communityId", feeQueryParams.getCommunityId());
        params.put("startYear", feeQueryParams.getStartYear());
        params.put("monthList", monthList);
        params.put("endYear", feeQueryParams.getEndYear());
        params.put("yearList", yearList);
        return sqlSessionTemplate.selectList("reportFeeServiceDaoImpl.repostInFeeTwo", params);
    }

    @Override
    public int saveReport(Map map) {
        return sqlSessionTemplate.insert("reportFeeServiceDaoImpl.saveReport", map);
    }

    @Override
    public List<ReportQueryRecord> queryReport(Map map) {
        return BeanConvertUtil.covertBeanList(sqlSessionTemplate.selectList("reportFeeServiceDaoImpl.queryReport", map), ReportQueryRecord.class);
    }

    @Override
    public List<Map> repostPaidInFeeByWhiteOrder(Map map) {
        List<Map> objects = sqlSessionTemplate.selectList("reportFeeServiceDaoImpl.repostPaidInFeeByWhiteOrder", map);

        if (objects.size() == 0){//没有数据时
            objects.get(0).put("count",0);
            return objects;
        }
        List<Map> businessOaWorkflowInfos = sqlSessionTemplate.selectList("reportFeeServiceDaoImpl.countRepostPaidInFeeByWhiteOrder",map);
        if (businessOaWorkflowInfos.size() < 1) {
            objects.get(0).put("count",0);
        }
        else {
            objects.get(0).put("count",businessOaWorkflowInfos.get(0).get("count").toString());
        }

        return objects;
    }
    @Override
    public List<Map> onceRoomFee(Map map) {
        return sqlSessionTemplate.selectList("reportFeeServiceDaoImpl.onceRoomFee", map);
    }

}