springboot+mongodb 实现按日期分组分页查询功能
具体代码如下所示：
WalletDetailsRespwalletDetailsResp=newWalletDetailsResp(); Listlist=newArrayList<>(); WalletDetailsResp.PageInfoBeanpageInfoBean=newWalletDetailsResp.PageInfoBean(); List types=newArrayList<>(); 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()); CriteriaeatCriteria=Criteria.where("_change_type").in(types).and("_downstream_user_id").is(userId); Sort.Orderorders=newSort.Order(Sort.Direction.DESC,"changeDate"); AggregationeatAggregation=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(newSort(orders)), Aggregation.skip(pageIndex>1?(pageIndex-1)*pageSize:0L), Aggregation.limit(pageSize)); AggregationResults eatOutputType=mongoTemplate.aggregate(eatAggregation,"inner_cash_change",BasicDBObject.class); for(DBObjectobj:eatOutputType){ WalletDetailsResp.WalletDetailwalletDetail=newWalletDetailsResp.WalletDetail(); walletDetail.setChangeType(Integer.parseInt(obj.get("_change_type").toString())); walletDetail.setChangeMoney(newBigDecimal(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实现按日期分组分页查询功能，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！
声明：本文内容来源于网络，版权归原作者所有，内容由互联网用户自发贡献自行上传，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任。如果您发现有涉嫌版权的内容，欢迎发送邮件至：czq8825#qq.com（发邮件时，请将#更换为@）进行举报，并提供相关证据，一经查实，本站将立刻删除涉嫌侵权内容。