Method countMoneyByType

xpay-code/src/main/java/cn/exrick/dao/PayDao.java:29–29

(String payType, Date date1, Date date2)

    BigDecimal countMoney(Date date1, Date date2);

    @Query(value = "select sum(money) from t_pay where state = 1 and pay_type = ?1 and create_time between ?2 and ?3",nativeQuery = true)
    BigDecimal countMoneyByType(String payType, Date date1, Date date2);
}