Interface PayDao

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

@author Exrickx

 * @author Exrickx
 */
public interface PayDao extends JpaRepository<Pay,String>, JpaSpecificationExecutor<Pay> {

    List<Pay> getByStateIs(Integer state);

    @Query(value = "select sum(money) from t_pay where state = 1",nativeQuery = true)
    BigDecimal countAllMoney();

    @Query(value = "select sum(money) from t_pay where state = 1 and pay_type = ?1",nativeQuery = true)
    BigDecimal countAllMoneyByType(String payType);

    @Query(value = "select sum(money) from t_pay where state = 1 and create_time between ?1 and ?2",nativeQuery = true)
    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);
}