Mongo DB query的等效JAVA Spring Boot代码是什么

Question

我已经编写了MongoDB查询来显示上周的用户数，基于配置文件集合中的lastActive字段，lastActive字段是日期字符串。有人能帮我用SimpleDataformat类或LocalDate类编写相应的Spring Boot java代码吗。请

var today = new Date();
var lastWeekStart = new Date(today.getFullYear(), today.getMonth(), today.getDate() - 7);
var lastWeekEnd = new Date(today.getFullYear(), today.getMonth(), today.getDate() - 7);
var start = new Date(lastWeekStart.setHours(0,0,0,0));
var end = new Date(lastWeekEnd.setHours(23,59,59,999));

db.Profile.aggregate([
{
    "$group": {
        "_id": null,
        "total": { "$sum": 1 },
        "LastWeekUsersList": {
            "$sum": {
                "$cond": [
                    { 
                        "$and": [
                            { "$gte": [ "$lastActive", start ] },
                            { "$lte": [ "$lastActive", end ] }
                        ]
                    },
                    1,
                    0
                ]
            }
        }
    }
}
])

这个如何写相应的Spring Boot代码，我不知道如何写mongo db的java等效查询，请帮我一个人

Answer 1

你可以试试这样的（未经测试）

    @Autowired
    private MongoOperations mongoOperations;

    public MongoOperations getMongoOperations() {
        return mongoOperations;
    } 

   .... 
    Instant start = Instant.parse("2020-07-13T10:30:00.000Z");
    Instant end = Instant.parse("2020-07-20T10:37:00.000Z");
    Criteria criteria = new Criteria().andOperator(
        Criteria.where("lastActive").gt(start),
        Criteria.where("lastActive").lt(end)
    );
    ConditionalOperators.Cond sumCond = ConditionalOperators.when(criteria).then(true).otherwise(false);
    GroupOperation groupOperation = Aggregation.group().count().as("total").sum(sumCond).as("LastWeekUsersList");
    List<MappedType> mappeRes = getMongoOperations().aggregate(Aggregation.newAggregation(
        groupOperation
    ), "myCollecgtion", MappedType.class).getMappedResults();