From fccf8f68b2e47457a97575fa0228cc25052c71a5 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期三, 01 十一月 2023 01:16:08 +0800
Subject: [PATCH] 优化代码
---
service-report/src/main/java/com/java110/report/dao/impl/ReportFeeStatisticsServiceDaoImpl.java | 325 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 325 insertions(+), 0 deletions(-)
diff --git a/service-report/src/main/java/com/java110/report/dao/impl/ReportFeeStatisticsServiceDaoImpl.java b/service-report/src/main/java/com/java110/report/dao/impl/ReportFeeStatisticsServiceDaoImpl.java
index 11a9beb..a52df22 100644
--- a/service-report/src/main/java/com/java110/report/dao/impl/ReportFeeStatisticsServiceDaoImpl.java
+++ b/service-report/src/main/java/com/java110/report/dao/impl/ReportFeeStatisticsServiceDaoImpl.java
@@ -53,6 +53,19 @@
}
@Override
+ public double getOweFee(Map info) {
+ logger.debug("鏌ヨ鍗曟湀娆犺垂 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getOweFee", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("oweFee").toString());
+ }
+
+ @Override
public double getCurReceivableFee(Map info) {
logger.debug("鏌ヨ鍗曟湀娆犺垂 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
@@ -68,6 +81,7 @@
/**
* 鏌ヨ娆犺垂杩藉洖
+ *
* @param info
* @return
*/
@@ -86,6 +100,7 @@
/**
* 鏌ヨ棰勪氦璐圭敤
+ *
* @param info
* @return
*/
@@ -104,6 +119,7 @@
/**
* 瀹炴敹璐圭敤
+ *
* @param info
* @return
*/
@@ -157,5 +173,314 @@
return infos;
}
+ @Override
+ public List<Map> getConfigFeeSummary(Map info) {
+ logger.debug("鏌ヨ 璐圭敤椤规敹璐圭巼 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getConfigFeeSummary", info);
+
+
+ return infos;
+ }
+
+ @Override
+ public int getObjFeeSummaryCount(Map info) {
+ logger.debug("鏌ヨ 鏀惰垂鎴锋暟 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getObjFeeSummaryCount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Integer.parseInt(infos.get(0).get("total").toString());
+ }
+
+ @Override
+ public List<Map> getObjFeeSummary(Map info) {
+ logger.debug("鏌ヨ 鎴垮眿鏄庣粏琛� 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getObjFeeSummary", info);
+
+
+ return infos;
+ }
+
+ @Override
+ public List<Map> getOwnerFeeSummary(Map info) {
+ logger.debug("鏌ヨ 涓氫富鏄庣粏琛� 鍏ュ弬 info : {}", JSONObject.toJSONString(info));
+
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getOwnerFeeSummary", info);
+
+
+ return infos;
+ }
+
+ /**
+ * 鏌ヨ浼樻儬璐圭敤
+ *
+ * @param info
+ * @return
+ */
+ @Override
+ public double getDiscountFee(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getDiscountFee", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("discountFee").toString());
+ }
+
+ /**
+ * 鏌ヨ婊炵撼閲�
+ *
+ * @param info
+ * @return
+ */
+ @Override
+ public double getLateFee(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getLateFee", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("lateFee").toString());
+ }
+
+ /**
+ * 鏌ヨ棰勫瓨璐︽埛
+ *
+ * @param info
+ * @return
+ */
+ @Override
+ public double getPrestoreAccount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getPrestoreAccount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("prestoreAccount").toString());
+ }
+
+ /**
+ * 鏌ヨ鎵f
+ *
+ * @param info
+ * @return
+ */
+ @Override
+ public double getWithholdAccount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getWithholdAccount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("withholdAccount").toString());
+ }
+
+ @Override
+ public double getTempCarFee(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getTempCarFee", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("tempCarFee").toString());
+ }
+
+ /**
+ * 鎶奸噾 閫�杩�
+ *
+ * @param info
+ * @return
+ */
+ @Override
+ public double geRefundDeposit(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.geRefundDeposit", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("refundDeposit").toString());
+ }
+
+ @Override
+ public double geRefundOrderCount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.geRefundOrderCount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("refundOrderCount").toString());
+ }
+
+ @Override
+ public double geRefundFee(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.geRefundFee", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("refundFee").toString());
+ }
+
+ @Override
+ public double getChargeFee(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getChargeFee", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("chargeFee").toString());
+ }
+
+ @Override
+ public List<Map> getReceivedFeeByFloor(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getReceivedFeeByFloor", info);
+ return infos;
+ }
+
+ @Override
+ public List<Map> getReceivedFeeByPrimeRate(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getReceivedFeeByPrimeRate", info);
+ return infos;
+ }
+
+ @Override
+ public List<Map> getOweFeeByFloor(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getOweFeeByFloor", info);
+ return infos;
+ }
+
+ /**
+ * 鏌ヨ娆犺垂瀵硅薄
+ *
+ * @param info
+ * @return
+ */
+ @Override
+ public List<Map> getObjOweFee(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getObjOweFee", info);
+ return infos;
+ }
+
+ @Override
+ public long getReceivedRoomCount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getReceivedRoomCount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Long.parseLong(infos.get(0).get("count").toString());
+ }
+
+ @Override
+ public double getReceivedRoomAmount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getReceivedRoomAmount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("amount").toString());
+ }
+
+ @Override
+ public long getHisOweReceivedRoomCount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getHisOweReceivedRoomCount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Long.parseLong(infos.get(0).get("count").toString());
+ }
+
+ @Override
+ public double getHisOweReceivedRoomAmount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getHisOweReceivedRoomAmount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("amount").toString());
+ }
+
+ @Override
+ public List<Map> getObjReceivedFee(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getObjReceivedFee", info);
+
+
+ return infos;
+
+ }
+
+ @Override
+ public long getMonthReceivedDetailCount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getMonthReceivedDetailCount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Long.parseLong(infos.get(0).get("count").toString());
+ }
+
+ @Override
+ public List<Map> getMonthReceivedDetailInfo(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getMonthReceivedDetailInfo", info);
+ return infos;
+ }
+
+ @Override
+ public long getMonthOweDetailCount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getMonthOweDetailCount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Long.parseLong(infos.get(0).get("count").toString());
+ }
+
+ @Override
+ public List<Map> getMonthOweDetailInfo(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getMonthOweDetailInfo", info);
+ return infos;
+ }
+
+ @Override
+ public double getMonthOweDetailAmount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getMonthOweDetailAmount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("amount").toString());
+ }
+
+ @Override
+ public double getMonthReceivedDetailAmount(Map info) {
+ List<Map> infos = sqlSessionTemplate.selectList("reportFeeStatisticsServiceDaoImpl.getMonthReceivedDetailAmount", info);
+
+ if (infos == null || infos.size() < 1) {
+ return 0;
+ }
+
+ return Double.parseDouble(infos.get(0).get("amount").toString());
+ }
}
--
Gitblit v1.8.0