a

    @Select({
        "SELECT SUM(amount) AS total",
        "FROM recharge_log",
        "WHERE",
        "flag=1 AND payType=#{payType}",
        "AND successTime BETWEEN FROM_DAYS(TO_DAYS(#{beginSuccDate}))",
        "AND FROM_DAYS(TO_DAYS(#{endSuccDate}))"
    })
    BigDecimal getTotalRechargeByPayTypeBetweenTimeSpan(@Param("payType") Short payType, @Param("beginSuccDate") Date beginSuccDate, @Param("endSuccDate") Date endSuccDate);