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); }