liulin
2025-07-08 d36ad7a2138062f891000c13d9712b4706f8627c
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}")
    BigDecimal getSumBuyCount(Long userId);
}