From b306ba3d75769c7d3f5ae9f7b43a8aaa26ed983c Mon Sep 17 00:00:00 2001
From: wuzeyu <1223318623@qq.com>
Date: 星期四, 08 八月 2024 16:15:40 +0800
Subject: [PATCH] 当前余额总量
---
pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardCtrl.java | 19 +++++++++++++++++++
pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardSv.java | 13 +++++++++++++
pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeClientCardMapper.xml | 8 ++++++++
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java | 7 +++++++
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSt/VoICCard.java | 4 ++++
5 files changed, 51 insertions(+), 0 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java
index 2f83f23..84522a1 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java
@@ -183,4 +183,11 @@
* @param money
*/
void updateMoney(@Param("id")Long id , @Param("money")Double money);
+
+ /**
+ *褰撳墠浣欓鎬婚噺锛堢墿鐞嗗崱锛�
+ * @param
+ * @return
+ */
+ Double getTotalMoneyIcCards();
}
\ No newline at end of file
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSt/VoICCard.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSt/VoICCard.java
index d11e433..982a7ca 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSt/VoICCard.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSt/VoICCard.java
@@ -18,4 +18,8 @@
*/
@JSONField(serializeUsing= ObjectWriterImplToString.class)
private Long cardId;
+ /**
+ * 浣欓鎬婚噺
+ */
+ private Double totalMoney;
}
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeClientCardMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeClientCardMapper.xml
index 04879a7..1bdeb43 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeClientCardMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/SeClientCardMapper.xml
@@ -589,4 +589,12 @@
ORDER BY card.id
</select>
+ <!--褰撳墠浣欓鎬婚噺锛堢墿鐞嗗崱锛�-->
+ <select id="getTotalMoneyIcCards" resultType="java.lang.Double">
+ SELECT
+ IFNULL(SUM(money),0) AS totalMoney
+ FROM
+ `se_client_card`
+ WHERE state = 1
+ </select>
</mapper>
\ No newline at end of file
diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardCtrl.java b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardCtrl.java
index bc0c9af..df89ee5 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardCtrl.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardCtrl.java
@@ -83,4 +83,23 @@
return BaseResponseUtils.buildException(e.getMessage());
}
}
+
+
+ /**
+ * 褰撳墠浣欓鎬婚噺锛堢墿鐞嗗崱锛�
+ *
+ * @param
+ * @return
+ */
+ @GetMapping(path = "/getTotalMoneyIcCards")
+ @SsoAop()
+ public BaseResponse<Double> getTotalMoneyIcCards() {
+ try {
+ Double res = icCardSv.getTotalMoneyIcCards();
+ return BaseResponseUtils.buildSuccess(res);
+ }catch (Exception e){
+ log.error("鑾峰彇璁板綍寮傚父", e);
+ return BaseResponseUtils.buildException(e.getMessage());
+ }
+ }
}
diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardSv.java
index bb3f2ba..c712949 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardSv.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/card/IcCardSv.java
@@ -29,6 +29,8 @@
@Autowired
private SeCardOperateMapper seCardOperateMapper;
+ @Autowired
+ private SeClientCardMapper seClientCardMapper;
/**
* 鎸囧畾鏃堕棿娈靛唴寮�鍗℃�绘暟閲忥紙鐗╃悊鍗★級
@@ -137,4 +139,15 @@
return rsVo ;
}
+
+ /**
+ * 褰撳墠浣欓鎬婚噺锛堢墿鐞嗗崱锛�
+ * @param
+ * @return
+ */
+ public Double getTotalMoneyIcCards() {
+
+ Double totalMoney = seClientCardMapper.getTotalMoneyIcCards();
+ return totalMoney ;
+ }
}
--
Gitblit v1.8.0