liulin
2025-07-11 e43e3a78eca089bd84b8bde6074e2837b927379d
src/main/java/com/lunhan/water/repository/mapper/RechargeRecordsMapper.java
@@ -10,7 +10,7 @@
 * @author lin.liu
 */
public interface RechargeRecordsMapper extends BasicMapper<RechargeRecordsPO> {
   @Select("SELECT COALESCE(SUM(recharge_water),0) FROM recharge_records WHERE user_id=#{userId}")
   @Select("SELECT COALESCE(SUM(recharge_water),0) FROM recharge_records WHERE user_id=#{userId} and recharge_status=1")
    BigDecimal getSumBuyCount(Long userId);
}