node.js - 根据日期获取预订数量

Question

如果我将从传递为“1970-01-01”并将到传递为“1970-01-05”，我如何获得预订总数？

Reserved 数组包含所有从从到到日期

的预订房间

这是我的数据:

[
  {
    "_id": "5c0a17013d8ca91bf4ee7885",
    "name": "ABC",
    "reserved": [
      {
        "from": "1970-01-01",
        "to": "1970-01-02",
        "isCompleted": false
      },
      {
        "from": "1970-01-03",
        "to": "1970-01-05",
        "isCompleted": false
      },
      {
        "from": "2017-04-18",
        "to": "2017-04-23",
        "isCompleted": false
      },
      {
        "from": "2018-01-29",
        "to": "2018-01-30",
        "isCompleted": false
      }
    ]
  }
]

我尝试使用查找查询获取数据(我知道那是不正确的)

db.collection.find({
  reserved: {
    $not: {
      $elemMatch: {
        from: {
          $lt: "1970-01-07"
        },
        to: {
          $gt: "1970-01-05"
        },
        "isCompleted": true
      }
    }
  }
})

Answer 1

创建一个利用 $size 的管道过滤数组上的运算符。要进行过滤，您需要 $filter运算符，您的条件将是 $gte 上的 AND和 $lte比较运算符即

{ 
    "$and": [
        { "$gte": [ < from field >, "1970-01-01"] },
        { "$lte": [ < to field >, "1970-01-05"] }
    ]
}

因此您的整体聚合操作将类似于以下内容:

db.collection.aggregate([
    { "$addFields": {
        "totalBookings": {
            "$size": {
                "$filter": {
                    "input": "$reserved",
                    "cond": {
                        "$and": [
                            { "$gte": ["$$this.from", "1970-01-01"] },
                            { "$lte": ["$$this.to", "1970-01-05"] }
                        ]
                    }
                }                
            }
        }
    } }
])