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 |  315 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 315 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 8ac9a8c..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
      */
@@ -167,5 +183,304 @@
         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());
+    }
+
+    /**
+     * 鏌ヨ鎵ｆ
+     *
+     * @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