问MongoDB -否定$elemMatch查询

EN

[{
    name: String,
    bookings: [{
        from: Date
        to: Date
        status: String //'CONFIRMED', 'ON_REQUEST', 'PAID'
    }]
}]

var searchFrom = new Date(2015, 02, 02);
var searchTo = new Date(2015, 02, 05);

{
    name: 'My awesome accommodation',
    bookings: [
    {
      from: Date(2015, 02, 01),
      to: Date(2015, 02, 03),
      status: 'CONFIRMED',
    }, {
      from: Date(2015, 02, 04),
      to: Date(2015, 02, 07),
      status: 'ON_REQUEST'
    }, {
      from: Date(2015, 02, 08),
      to: Date(2015, 02, 10),
      status: 'PAID'
    }]
}

db.accommodations.find({
    'bookings': {
        $and: [{
            $elemMatch: {
                'from': {$lte: searchTo},
                'to': {$gte: searchFrom},
                'status': 'ON_REQUEST'
            }
        }, {
            $not: {
                $elemMatch: {
                    'from': {$lte: searchTo},
                    'to': {$gte: searchFrom},
                    'status': {$in: ['CONFIRMED', 'PAID']
                }
            }
        }]
    }
});