Is it possible to search for empty slots?
Brought to you by:
jberanek
Menu
▾
▴
#1567 Is it possible to search for empty slots?
open
nobody
None
1
2018-08-23
2018-07-31
Anonymous
No
I am looking for a way to search or generate a report for all rooms that are empty either on a specific date. I did consider creating a booking type of 'FREE', and then adding a booking for that in every slot by default and then editing them as real bookings are made. However, I decided that was going to be a huge headache and a terrible way to do things.
Is what I want possible? I don't mind doing a bit of work if someone can point me in the right direction?
Thanks
Discussion
Yes, it's possible, but you'd need to write your own code for it. Querying the database is easy. A lot of the difficulty depends on how you want to present the results?
The report results are great, displaying the results like that would be perfect.
Like, if under 'Booking Type' on the report page, 'Available' or 'Free' or something could be added, would be ideal. I realise it can't be an actual booking type or the DB would basically be infintely large full of unbooked slots.
I'm a bit confused. Doesn't the day view give you a list of all rooms that are empty on a specific date?
So, we are using it as a way of booking rooms for staff. We have 8 blocks, each with 4-8 rooms in them. Here's a hypothetical interaction with a member of staff:
Staff: "I need a free room next period or I will throw a tantrum!"
Me: "Well, after running a search, I can see that Block1Room3, Block4Room1, Block4Room2 and Block7Room1 are free that period today"
Staff: "great, I won't say thanks because you are just a computer nerd loser"
Me: "you're welcome have a nice day"
Unless there's a way to view all blocks and rooms on the same page in 'Day View' that I have overlooked?
OK, I understand.
The difficulty with showing all areas in the day view in the general case is that the time slots/periods can be different for each area, so it gets difficult to display them in the same table. However if your areas (blocks) all have the same time slots/periods then the easiest thing is probably to extend the day view so that it does all rooms in all blocks.
If they're not the same, then you probably need some kind of special report as you say, but I'm not quite sure what that would look like.
Thanks for the advice. The code changes are pretty basic but it's really useful to be able to see the whole lot at once.
We often get people looking for a specific rooms in the future, so I coded a search for a single room and time slot. It's fairly easy to create a search form and AJAX report for something like this. Our room count is small enough that the day view shows everything.