We have an usecase, where we are building an app which books time slots for specific mentioned time. For that we have created a table with "From time and To time". Now, we are able to validate booking slot time against the already booked slots.
Struking point: For instance, if a person needs to book time slot from 9 am to 12 pm then we have booked the slot. If another person tries to book time slot for that same time or between the time, we are able to validate and generate error. Now if a person tries to book a slot from 8 am to 1 pm then we are unable to validate. Kindly show any ideas to achieve this requirement
-
2Try put some code that shows you tried some.Mojtaba Hosseini– Mojtaba Hosseini2018-10-24 11:58:07 +00:00Commented Oct 24, 2018 at 11:58
Add a comment
|
1 Answer
Considering that you are handling the models, dates and other stuff, something like this will help you solve the problem:
model.find({
$or: [{
$and: [{
"fromTime": { $gte: desiredFromTime },
},
{
"toTime": { $lte: desiredToTime },
}
]
}, {
$and: [{
"fromTime": { $lte: desiredFromTime },
},
{
"toTime": { $gte: desiredToTime },
}
]
}]
}).exec(function(err,result){
if(result)
console.log("You can't book")
else{
//book the slot
}
})