From e43e3a78eca089bd84b8bde6074e2837b927379d Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期五, 11 七月 2025 16:29:51 +0800
Subject: [PATCH] 修改资源上传路径
---
src/main/java/com/lunhan/water/repository/mapper/RechargeRecordsMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/lunhan/water/repository/mapper/RechargeRecordsMapper.java b/src/main/java/com/lunhan/water/repository/mapper/RechargeRecordsMapper.java
index 8090db9..c95c3f8 100644
--- a/src/main/java/com/lunhan/water/repository/mapper/RechargeRecordsMapper.java
+++ b/src/main/java/com/lunhan/water/repository/mapper/RechargeRecordsMapper.java
@@ -1,10 +1,16 @@
package com.lunhan.water.repository.mapper;
import com.lunhan.water.repository.BasicMapper;import com.lunhan.water.repository.po.RechargeRecordsPO;
+import org.apache.ibatis.annotations.Select;
+
+import java.math.BigDecimal;
/**
* 充值记录 mapper
* @author lin.liu
*/
public interface RechargeRecordsMapper extends BasicMapper<RechargeRecordsPO> {
+ @Select("SELECT COALESCE(SUM(recharge_water),0) FROM recharge_records WHERE user_id=#{userId} and recharge_status=1")
+ BigDecimal getSumBuyCount(Long userId);
+
}
--
Gitblit v1.9.3