package com.yeshi.fanli.dao.user;
|
|
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.fanli.dao.MongodbBaseDao;
|
import com.yeshi.fanli.entity.bus.user.UserActiveNumHistory;
|
|
@Repository
|
public class UserActiveNumHistoryDao extends MongodbBaseDao<UserActiveNumHistory> {
|
|
|
/**
|
* 查询统计最大的一天
|
* @return
|
*/
|
public UserActiveNumHistory getMaxDate(){
|
Query query = new Query();
|
query.with(new Sort(Sort.Direction.DESC,"day")).limit(1);;
|
return mongoTemplate.findOne(query, UserActiveNumHistory.class);
|
}
|
|
/**
|
* 查询视图
|
* @param dateType
|
* @param year
|
* @param startTime
|
* @param endTime
|
* @return
|
*/
|
public List<UserActiveNumHistory> query(Date startTime, Date endTime){
|
Query query = new Query();
|
Criteria ca =new Criteria();
|
ca.andOperator(
|
Criteria.where("day").gte(startTime),
|
Criteria.where("day").lte(endTime)
|
);
|
|
query.addCriteria(ca);
|
return mongoTemplate.find(query, UserActiveNumHistory.class);
|
}
|
|
}
|
