mongoTemplate的GroupOperation分组查询及Criteria条件查询的使用

mongoTemplate的GroupOperation分组查询及Criteria条件查询的使用
GroupOperation：

//此处类似于SQL中的groupBy,group("")参数可以是String,也可以是String数组
		String[] groupKeys = new String[4];
        GroupOperation groupOp = null;
        if (1==1)) { // 模拟条件
            groupKeys[0] = "";
            groupKeys[1] = "";
            groupKeys[2] = "";
            groupKeys[3] = "";
            groupOp = Aggregation.group(groupKeys);
        } else {
            groupOp = Aggregation.group("", "","");
        }

		//构建查询条件
        Criteria criteria = null
		List<String> gcIds = new ArrayList<>();//
		gcIds.add("firstId1,secondId1,thirdId1");
		gcIds.add("firstId2,secondId2");
		gcIds.add("firstId3");
		//构建一个总的criteria对象 
        Criteria criteria = new Criteria();
        Criteria criteriaTime = new Criteria().andOperator(
                Criteria.where("createDate").gte(beginTime),//createDate为Mongo中的时间，在查询时间区间时，需要用到此方式
                Criteria.where("createDate").lt(theEndTime)
        );
        Criteria criteriaBrand = new Criteria();
        Criteria criteriaSupplier = new Criteria();
        Criteria criteriaGcId = new Criteria();
        Criteria criteriaGoodsName = new Criteria();
        Criteria criteriaPriceType = new Criteria();
        //params中储存前台出来的查询条件
        if (params.getBrandId() != null && params.getBrandId().size() > 0) {
            criteriaBrand = criteriaBrand.and("brandId").in(params.getBrandId());
        }
        if (params.getSupplierId() != null && params.getSupplierId().size() > 0) {
            criteriaSupplier = criteriaSupplier.and("supplierId").in(params.getSupplierId());
        }
        if (!"".equals(params.getGoodsName())&&params.getGoodsName() != null) {
            criteriaGoodsName = criteriaGoodsName.and("goodsName").regex(".*?" +params.getGoodsName()+ ".*");
        }
        if (params.getUnitPriceType() != null && params.getUnitPriceType().size()>0) {
            criteriaPriceType = criteriaPriceType.and("unitPriceType").in(params.getUnitPriceType());
        }
        //这里相当于 where brandId = 1  and ((firstGcId = 1 and secondGcId = 2 and thirdGcId = 3 )or (firstGcId = 4 and secondGcId = 5) or (firstGcId = 6))
        if (gcIds != null && gcIds.size() > 0) {
            Criteria[] orCriteria = new Criteria[gcIds.size()];
            for (int i = 0; i < gcIds.size(); i++) {
                String[] split = gcIds.get(i).split(",");
                if (split.length == 3) {
                    orCriteria[i] = Criteria.where("firstGcId").is(Long.parseLong(split[i])).and("secondGcId").is(Long.parseLong(split[i + 1])).and("thirdGcId").is(Long.parseLong(split[i + 2]));
                }
                if (split.length == 2) {
                    orCriteria[i] = Criteria.where("firstGcId").is(Long.parseLong(split[i])).and("secondGcId").is(Long.parseLong(split[i + 1]));
                }

                if (split.length == 1) {
                    orCriteria[i] = Criteria.where("firstGcId").is(Long.parseLong(split[i]));
                }
            }
            criteriaGcId.orOperator(orCriteria);
        }

        criteria.andOperator(criteriaTime, criteriaBrand, criteriaSupplier, criteriaGcId,criteriaGoodsName,criteriaPriceType);
 
     

注意，一个Criteria对象中，最多只有一个andOperator条件和一个orOperator条件，并且不能为空，所以要用criteria对象将criteriaTime, criteriaBrand, criteriaSupplier, criteriaGcId,criteriaGoodsName,criteriaPriceType这几个对象用and（or）连接

//构建Aggregation对象，groupOp.sum("mongo中要聚合的字段").as("接收的实体类中的属性")
Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.match(criteria),
                Aggregation.sort(Sort.Direction.ASC, "createDate"),
                groupOp
                        .sum("mongo中要聚合的字段").as("接收的实体类中的属性")
                        .sum("totalPurchaseAmount").as("totalPurchaseAmount")
                        .last("createDate").as("createDate"),
                Aggregation.sort(Sort.Direction.ASC, "createDate"),//排序条件
                Aggregation.skip((currentPage-1) *pageSize * 1L),//分页条件，currentPage当前页
                Aggregation.limit(pageSize),//pageSize每页记录数
                //project中字段要与.as()中的字段一一对应
                Aggregation.project("接收的实体类中的属性","totalPurchaseAmount","createDate")
        );
        //获取到所查询的集合
        AggregationResults<GoodsIndentListEntity> aggregateData = mongoTemplate.aggregate(aggregation, GoodsIndentListEntity.class, GoodsIndentListEntity.class);
        List<GoodsIndentListEntity> data = aggregateData.getMappedResults();