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