package com.boying.dao;

import com.boying.common.BaseDao;
import com.boying.entity.OrderRecord;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

@Repository("orderRecordDao")
public interface OrderRecordDao extends BaseDao<OrderRecord, Long>{

    @Query(value = "select count(id) from OrderRecord where createTime>:yearFirst and createTime<:yearLast")
    long countByYear(Date yearFirst, Date yearLast);

    @Query(value = "select sum(money) from OrderRecord where createTime>:yearFirst and createTime<:yearLast")
    Double sumByYear(Date yearFirst, Date yearLast);

    @Query(value = "select a from OrderRecord a where a.createTime>:yearFirst and a.createTime<:yearLast order by a.id desc")
    List<OrderRecord> findAll2(Date yearFirst, Date yearLast);
}