新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
springboot+mongodb如何實現(xiàn)按日期分組分頁查詢功能
這篇文章主要介紹springboot+MongoDB如何實現(xiàn)按日期分組分頁查詢功能,文中介紹的非常詳細,具有一定的參考價值,感興趣的小伙伴們一定要看完!
在新平等地區(qū),都構建了全面的區(qū)域性戰(zhàn)略布局,加強發(fā)展的系統(tǒng)性、市場前瞻性、產品創(chuàng)新能力,以專注、極致的服務理念,為客戶提供網(wǎng)站建設、成都網(wǎng)站建設 網(wǎng)站設計制作專業(yè)公司,公司網(wǎng)站建設,企業(yè)網(wǎng)站建設,品牌網(wǎng)站制作,成都全網(wǎng)營銷推廣,成都外貿網(wǎng)站建設公司,新平網(wǎng)站建設費用合理。
具體代碼如下所示:
WalletDetailsResp walletDetailsResp = new WalletDetailsResp(); Listlist = 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);
以上是“springboot+mongodb如何實現(xiàn)按日期分組分頁查詢功能”這篇文章的所有內容,感謝各位的閱讀!希望分享的內容對大家有幫助,更多相關知識,歡迎關注創(chuàng)新互聯(lián)行業(yè)資訊頻道!
本文題目:springboot+mongodb如何實現(xiàn)按日期分組分頁查詢功能
網(wǎng)站鏈接:http://www.dlmjj.cn/article/psspch.html