springboot+mongodb 实现按日期分组分页查询功能

springboot+mongodb 实现按日期分组分页查询功能

具体代码如下所示：

WalletDetailsResp walletDetailsResp = new WalletDetailsResp();

List list = new ArrayList<>();

WalletDetailsResp.PageInfoBean pageInfoBean = new WalletDetailsResp.PageInfoBean();

List types = new ArrayList<>();

types.add(InnerCashType.FINISHER_ADD_CUTMONEY.getCode());

types.add(InnerCashType.FINISHER_ADD_REWARD.getCode());

types.add(InnerCashType.FINISHER_SUB_WITHDRAW.getCode());

types.add(InnerCashType.FINISHER_ADD_WITHDRAW.getCode());

Criteria eatCriteria = Criteria.where("_change_type").in(types).and("_downstream_user_id").is(userId);

Sort.Order orders = new Sort.Order(Sort.Direction.DESC, "changeDate");

Aggregation eatAggregation = Aggregation.newAggregation(

Aggregation.match(eatCriteria),

Aggregation.project("_change_money","_change_type").andExpression("substr(_change_time,0,10)").as("changeDate"),

Aggregation.group("changeDate","_change_type").sum("_change_money").as("changeMoney"),

Aggregation.sort(new Sort(orders)),

Aggregation.skip(pageIndex > 1 ? (pageIndex - 1) * pageSize : 0L),

Aggregation.limit(pageSize));

AggregationResults eatOutputType = mongoTemplate.aggregate(eatAggregation, "inner_cash_change", BasicDBObject.class);

for (DBObject obj : eatOutputType) {

WalletDetailsResp.WalletDetail walletDetail = new WalletDetailsResp.WalletDetail();

walletDetailhttp://.setChangeType(Integer.parseInt(obj.get("_change_type").toString()));

walletDetail.setChangeMoney(new BigDecimal(obj.get("changeMoney").toString()).divide(QRType.YUAN_TO_FEN));

walletDetail.setChangeDate(obj.get("changeDate").toString());

list.add(walletDetail);

}

walletDetailsResp.setWalletDetails(list);

pageInfoBean.setPageIndex(pageIndex);

pageInfoBean.setPageSize(pageSize);

pageInfoBean.setRecordTotal(eatOutputType.getMappedResults().size());

walletDetailsResp.setPageInfo(pageInfoBean);

总结

以上所述是给大家介绍的springboot+mongodb 实现按日期分组分页查询功能，希望对大家有所帮助，如果大家有任何疑问请给我留言，会及时回复大家的。在此也非常感谢大家对我们网站的支持！

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。