From dd6687b118561100e1677e88a9c2f5842a54c531 Mon Sep 17 00:00:00 2001
From: jialh <1972868360@qq.com>
Date: 星期四, 16 四月 2026 18:14:14 +0800
Subject: [PATCH] 水电话费
---
service-fee/src/main/java/com/java110/fee/dao/impl/IReportFeeServiceDaoImpl.java | 61 ++++++++++++++++++++++++++++--
1 files changed, 57 insertions(+), 4 deletions(-)
diff --git a/service-fee/src/main/java/com/java110/fee/dao/impl/IReportFeeServiceDaoImpl.java b/service-fee/src/main/java/com/java110/fee/dao/impl/IReportFeeServiceDaoImpl.java
index 17278c7..4b78818 100644
--- a/service-fee/src/main/java/com/java110/fee/dao/impl/IReportFeeServiceDaoImpl.java
+++ b/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);
+ }
+
}
--
Gitblit v1.8.0