src/main/java/com/lunhan/water/repository/mapper/RechargeRecordsMapper.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
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); }