From fb2f11d7d502ceacbe7fbed176bea4ab0f152f69 Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期四, 03 七月 2025 18:17:59 +0800
Subject: [PATCH] 添加mqtt
---
src/main/java/com/lunhan/water/repository/mapper/PaymentRecordsMapper.java | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/lunhan/water/repository/mapper/PaymentRecordsMapper.java b/src/main/java/com/lunhan/water/repository/mapper/PaymentRecordsMapper.java
index 2cec504..6d0fa90 100644
--- a/src/main/java/com/lunhan/water/repository/mapper/PaymentRecordsMapper.java
+++ b/src/main/java/com/lunhan/water/repository/mapper/PaymentRecordsMapper.java
@@ -1,10 +1,16 @@
package com.lunhan.water.repository.mapper;
-import com.lunhan.water.repository.BasicMapper;import com.lunhan.water.repository.po.PaymentRecordsPO;
+import com.lunhan.water.repository.BasicMapper;
+import com.lunhan.water.repository.po.PaymentRecordsPO;
+import org.apache.ibatis.annotations.Select;
+
+import java.math.BigDecimal;
/**
* PaymentRecords
* @author lin.liu
*/
public interface PaymentRecordsMapper extends BasicMapper<PaymentRecordsPO> {
+ @Select("SELECT COALESCE(SUM(water_amount),0) FROM payment_records WHERE user_id=#{userId}")
+ BigDecimal getSumUseCount(Long userId);
}
--
Gitblit v1.9.3