java 按日期分组统计_java相关：springboot+mongodb 实现按日期分组分页查询功能

java相关：springboot+mongodb 实现按日期分组分页查询功能

发布于 2020-6-17|

复制链接

摘记: 具体代码如下所示：

```java

WalletDetailsResp walletDetailsResp = new WalletDetailsResp();

List list = new ArrayList<>();

WalletDetailsResp.PageInfoBe ..

具体代码如下所示：

```java

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();

walletDetail.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);

```