package com.yeshi.fanli.dao.user.count;
|
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.data.domain.Sort;
|
import org.springframework.data.mongodb.core.query.Criteria;
|
import org.springframework.data.mongodb.core.query.Query;
|
import org.springframework.stereotype.Repository;
|
|
import com.yeshi.common.MongodbBaseDao;
|
import com.yeshi.fanli.entity.admin.count.CountOrderTrackRate;
|
import com.yeshi.fanli.entity.admin.count.CountOrderTrackRate.OrderTrackRateEnum;
|
|
@Repository
|
public class CountOrderTrackRateDao extends MongodbBaseDao<CountOrderTrackRate> {
|
|
/**
|
* 查询统计最大的一天
|
*
|
* @return
|
*/
|
public CountOrderTrackRate getMaxDate(OrderTrackRateEnum userEnum) {
|
Query query = new Query();
|
query.addCriteria(Criteria.where("type").is(userEnum.name()));
|
query.with(new Sort(Sort.Direction.DESC, "day")).limit(1);
|
return mongoTemplate.findOne(query, CountOrderTrackRate.class);
|
}
|
|
/**
|
* 查询视图
|
*
|
* @param dateType
|
* @param year
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
public List<CountOrderTrackRate> query(OrderTrackRateEnum userEnum, Date startTime, Date endTime) {
|
Query query = new Query();
|
Criteria ca = new Criteria();
|
ca.andOperator(Criteria.where("type").is(userEnum.name()),Criteria.where("day").gte(startTime), Criteria.where("day").lte(endTime));
|
query.addCriteria(ca);
|
return mongoTemplate.find(query, CountOrderTrackRate.class);
|
}
|
|
|
}
|