From 05683f2b2bdbdbe21cf17ad523c21ab338bd1c54 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期二, 19 七月 2022 21:49:55 +0800
Subject: [PATCH] 优化添加设备 功能
---
service-report/src/main/java/com/java110/report/dao/impl/ReportOweFeeServiceDaoImpl.java | 102 +++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 83 insertions(+), 19 deletions(-)
diff --git a/service-report/src/main/java/com/java110/report/dao/impl/ReportOweFeeServiceDaoImpl.java b/service-report/src/main/java/com/java110/report/dao/impl/ReportOweFeeServiceDaoImpl.java
index 160e7d9..ed651ff 100644
--- a/service-report/src/main/java/com/java110/report/dao/impl/ReportOweFeeServiceDaoImpl.java
+++ b/service-report/src/main/java/com/java110/report/dao/impl/ReportOweFeeServiceDaoImpl.java
@@ -1,15 +1,14 @@
package com.java110.report.dao.impl;
import com.alibaba.fastjson.JSONObject;
+import com.java110.dto.reportOweFee.ReportOweFeeItemDto;
import com.java110.utils.constant.ResponseConstant;
import com.java110.utils.exception.DAOException;
-import com.java110.utils.util.DateUtil;
import com.java110.core.base.dao.BaseServiceDao;
import com.java110.report.dao.IReportOweFeeServiceDao;
import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
+import com.java110.core.log.LoggerFactory;
import org.springframework.stereotype.Service;
-import org.springframework.transaction.annotation.Transactional;
import java.util.List;
import java.util.Map;
@@ -24,38 +23,36 @@
private static Logger logger = LoggerFactory.getLogger(ReportOweFeeServiceDaoImpl.class);
-
-
-
-
/**
* 淇濆瓨娆犺垂缁熻淇℃伅 鍒� instance
- * @param info bId 淇℃伅
+ *
+ * @param info bId 淇℃伅
* @throws DAOException DAO寮傚父
*/
@Override
public void saveReportOweFeeInfo(Map info) throws DAOException {
- logger.debug("淇濆瓨娆犺垂缁熻淇℃伅Instance 鍏ュ弬 info : {}",info);
+ logger.debug("淇濆瓨娆犺垂缁熻淇℃伅Instance 鍏ュ弬 info : {}", info);
- int saveFlag = sqlSessionTemplate.insert("reportOweFeeServiceDaoImpl.saveReportOweFeeInfo",info);
+ int saveFlag = sqlSessionTemplate.insert("reportOweFeeServiceDaoImpl.saveReportOweFeeInfo", info);
- if(saveFlag < 1){
- throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"淇濆瓨娆犺垂缁熻淇℃伅Instance鏁版嵁澶辫触锛�"+ JSONObject.toJSONString(info));
+ if (saveFlag < 1) {
+ throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇濆瓨娆犺垂缁熻淇℃伅Instance鏁版嵁澶辫触锛�" + JSONObject.toJSONString(info));
}
}
/**
* 鏌ヨ娆犺垂缁熻淇℃伅锛坕nstance锛�
+ *
* @param info bId 淇℃伅
* @return List<Map>
* @throws DAOException DAO寮傚父
*/
@Override
public List<Map> getReportOweFeeInfo(Map info) throws DAOException {
- logger.debug("鏌ヨ娆犺垂缁熻淇℃伅 鍏ュ弬 info : {}",info);
+ logger.debug("鏌ヨ娆犺垂缁熻淇℃伅 鍏ュ弬 info : {}", info);
- List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.getReportOweFeeInfo",info);
+ List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.getReportOweFeeInfo", info);
return businessReportOweFeeInfos;
}
@@ -63,28 +60,47 @@
/**
* 淇敼娆犺垂缁熻淇℃伅
+ *
* @param info 淇敼淇℃伅
* @throws DAOException DAO寮傚父
*/
@Override
public void updateReportOweFeeInfo(Map info) throws DAOException {
+ logger.debug("淇敼娆犺垂缁熻淇℃伅Instance 鍏ュ弬 info : {}", info);
+
+ int saveFlag = sqlSessionTemplate.update("reportOweFeeServiceDaoImpl.updateReportOweFeeInfo", info);
+
+ if (saveFlag < 1) {
+ throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇敼娆犺垂缁熻淇℃伅Instance鏁版嵁澶辫触锛�" + JSONObject.toJSONString(info));
+ }
+ }
+ /**
+ * 淇敼娆犺垂缁熻淇℃伅
+ * @param info 淇敼淇℃伅
+ * @throws DAOException DAO寮傚父
+ */
+ @Override
+ public void deleteReportOweFeeInfo(Map info) throws DAOException {
logger.debug("淇敼娆犺垂缁熻淇℃伅Instance 鍏ュ弬 info : {}",info);
- int saveFlag = sqlSessionTemplate.update("reportOweFeeServiceDaoImpl.updateReportOweFeeInfo",info);
+ int saveFlag = sqlSessionTemplate.update("reportOweFeeServiceDaoImpl.deleteReportOweFeeInfo",info);
if(saveFlag < 1){
throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"淇敼娆犺垂缁熻淇℃伅Instance鏁版嵁澶辫触锛�"+ JSONObject.toJSONString(info));
}
}
- /**
+
+
+ /**
* 鏌ヨ娆犺垂缁熻鏁伴噺
+ *
* @param info 娆犺垂缁熻淇℃伅
* @return 娆犺垂缁熻鏁伴噺
*/
@Override
public int queryReportOweFeesCount(Map info) {
- logger.debug("鏌ヨ娆犺垂缁熻鏁版嵁 鍏ュ弬 info : {}",info);
+ logger.debug("鏌ヨ娆犺垂缁熻鏁版嵁 鍏ュ弬 info : {}", info);
List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.queryReportOweFeesCount", info);
if (businessReportOweFeeInfos.size() < 1) {
@@ -96,12 +112,60 @@
@Override
public List<Map> queryReportAllOweFees(Map info) {
- logger.debug("queryReportAllOweFees 鍏ュ弬 info : {}",info);
+ logger.debug("queryReportAllOweFees 鍏ュ弬 info : {}", info);
- List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.queryReportAllOweFees",info);
+ List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.queryReportAllOweFees", info);
return businessReportOweFeeInfos;
}
+ @Override
+ public List<Map> queryReportAllOweFeesByRoom(Map info) {
+ logger.debug("queryReportAllOweFeesByRoom 鍏ュ弬 info : {}", info);
+
+ List<Map> businessReportOweFeeByRoomInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.queryReportAllOweFeesByRoom", info);
+
+ return businessReportOweFeeByRoomInfos;
+ }
+
+ @Override
+ public List<Map> queryReportAllOweFeesByCar(Map info) {
+ logger.debug("queryReportAllOweFeesByCar 鍏ュ弬 info : {}", info);
+
+ List<Map> businessReportOweFeeByCarInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.queryReportAllOweFeesByCar", info);
+
+ return businessReportOweFeeByCarInfos;
+ }
+
+ @Override
+ public double computeReportOweFeeTotalAmount(Map info) {
+ List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.computeReportOweFeeTotalAmount", info);
+ if (businessReportOweFeeInfos.size() < 1) {
+ return 0;
+ }
+ return Double.parseDouble(businessReportOweFeeInfos.get(0).get("total").toString());
+ }
+
+ @Override
+ public List<Map> computeReportOweFeeItemAmount(Map info) {
+ List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.computeReportOweFeeItemAmount", info);
+ return businessReportOweFeeInfos;
+ }
+
+ @Override
+ public int deleteInvalidFee(Map info) {
+ logger.debug("淇漝eleteInvalidFee 鍏ュ弬 info : {}", info);
+
+ int saveFlag = sqlSessionTemplate.insert("reportOweFeeServiceDaoImpl.deleteInvalidFee", info);
+
+ return saveFlag;
+ }
+
+ @Override
+ public List<Map> queryInvalidOweFee(Map info) {
+ List<Map> businessReportOweFeeInfos = sqlSessionTemplate.selectList("reportOweFeeServiceDaoImpl.queryInvalidOweFee", info);
+ return businessReportOweFeeInfos;
+ }
+
}
--
Gitblit v1.8.0