From a13573d5ef8d16f4bc2535a3c89c2891e6f5b56c Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期二, 30 五月 2023 15:33:30 +0800
Subject: [PATCH] optimize

---
 service-report/src/main/java/com/java110/report/dao/impl/ReportCommunityServiceDaoImpl.java |  110 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 109 insertions(+), 1 deletions(-)

diff --git a/service-report/src/main/java/com/java110/report/dao/impl/ReportCommunityServiceDaoImpl.java b/service-report/src/main/java/com/java110/report/dao/impl/ReportCommunityServiceDaoImpl.java
index a55be46..e68cd50 100755
--- a/service-report/src/main/java/com/java110/report/dao/impl/ReportCommunityServiceDaoImpl.java
+++ b/service-report/src/main/java/com/java110/report/dao/impl/ReportCommunityServiceDaoImpl.java
@@ -7,7 +7,7 @@
 import com.java110.dto.report.ReportRoomDto;
 import com.java110.report.dao.IReportCommunityServiceDao;
 import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
+import com.java110.core.log.LoggerFactory;
 import org.springframework.stereotype.Service;
 
 import java.util.List;
@@ -82,4 +82,112 @@
 
         return communityDtos;
     }
+
+    @Override
+    public List<Map> queryRoomStructures(Map info) {
+        logger.debug("鏌ヨqueryRoomStructures淇℃伅 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+
+        List<Map> communityDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryRoomStructures", info);
+
+        return communityDtos;
+    }
+
+    @Override
+    public List<Map> queryCarStructures(Map info) {
+        logger.debug("鏌ヨqueryCarStructures淇℃伅 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+
+        List<Map> communityDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryCarStructures", info);
+
+        return communityDtos;
+    }
+
+    public int deleteInvalidFee(Map info){
+        logger.debug("deleteInvalidFee 鍏ュ弬 info : {}", info);
+
+        int saveFlag = sqlSessionTemplate.update("reportCommunityServiceDaoImpl.deleteInvalidFee", info);
+
+        return saveFlag;
+    }
+
+    @Override
+    public List<Map> queryInvalidFeeMonthStatistics(Map info) {
+        logger.debug("鏌ヨ鎶奸噾閫�璐规�婚噾棰濅俊鎭� 鍏ュ弬 info : {}", info);
+
+        List<Map> deposits = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryInvalidFeeMonthStatistics", info);
+
+        return deposits;
+    }
+
+
+    @Override
+    public List<Map> queryRoomsTree(Map info) {
+        logger.debug("鏌ヨqueryRoomsTree淇℃伅 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+
+        List<Map> communityDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryRoomsTree", info);
+
+        return communityDtos;
+    }
+
+    @Override
+    public int queryHisOwnerCarCount(Map info) {
+        logger.debug("鏌ヨ杞﹁締绠＄悊鏁版嵁 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerCarInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryHisOwnerCarCount", info);
+        if (businessOwnerCarInfos.size() < 1) {
+            return 0;
+        }
+
+        return Integer.parseInt(businessOwnerCarInfos.get(0).get("count").toString());
+    }
+
+    @Override
+    public List<Map> queryHisOwnerCars(Map info) {
+        logger.debug("鏌ヨ杞﹁締绠＄悊淇℃伅 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerCarInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryHisOwnerCars", info);
+
+        return businessOwnerCarInfos;
+    }
+
+    @Override
+    public int queryHisOwnerCount(Map info) {
+        logger.debug("鏌ヨqueryHisOwnerCount 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerCarInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryHisOwnerCount", info);
+        if (businessOwnerCarInfos.size() < 1) {
+            return 0;
+        }
+
+        return Integer.parseInt(businessOwnerCarInfos.get(0).get("count").toString());
+    }
+
+    @Override
+    public List<Map> queryHisOwners(Map info) {
+        logger.debug("鏌ヨqueryHisOwners 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerCarInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryHisOwners", info);
+
+        return businessOwnerCarInfos;
+    }
+
+    @Override
+    public int queryHisFeeCount(Map info) {
+        logger.debug("鏌ヨqueryHisFeeCount 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerCarInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryHisFeeCount", info);
+        if (businessOwnerCarInfos.size() < 1) {
+            return 0;
+        }
+
+        return Integer.parseInt(businessOwnerCarInfos.get(0).get("count").toString());
+    }
+
+    @Override
+    public List<Map> queryHisFees(Map info) {
+        logger.debug("鏌ヨ queryHisFees 鍏ュ弬 info : {}", info);
+
+        List<Map> businessOwnerCarInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryHisFees", info);
+
+        return businessOwnerCarInfos;
+    }
 }

--
Gitblit v1.8.0