#312 Problems with room's capacity

[Anonymous]

Hello, i've installed the MRBS and its fantastic!

It works great and is very usefull, but i'd like to know how to solve this problem:
The capacity of X room is for 30 ppl, but some users are not aware of the capacity, so they book a reservation and when the day comes... we have overcrowded rooms. How can i prevent this to happen? I mean i would ask in the form: how many ppl will be in the conference (for example): 50. and if the ppl in the conference is more than the capacity, the user gets an error: "The maximum capacity of the room is 30, you need to make a reservation in another room". Or at least to show in the form the capacity of the room (atm capacity is not shown).

Thanks in advance.

Esteban Guzmán.

[Anonymous]

This is exactly the functionality that I am looking for also, that is automatic capacity based room assignment on first come first serve basis.

[Bharath Lakshmeesha]

Any update on this functionality? I have similar requirements..

[Campbell Morrison]

The easiest thing to do is to have the capacity of the room displayed in the booking form. You could do this by modifying the SQL query (line 389 in edit_entry.php in MRBS 1.4.11) from:

  $sql = "SELECT R.id, R.room_name, R.area_id

to

  $sql = "SELECT R.id, CONCAT(R.room_name, ' (', R.capacity, ')') AS room_name, R.area_id

[Bharath Lakshmeesha]

Thank you for this. Can we have a validation where if the user enters more than the room capacity then the booking should not be allowed?

[Bharath Lakshmeesha]

Hi Campbell,

Any update on this please?

[Campbell Morrison]

This would require changes to MRBS which you would have to implement yourself.

[Bharath Lakshmeesha]

And this again has to go into edit_entry.php?

[Campbell Morrison]

Well, you'd have to put the client side validation in edit_entry.php and js/edit_entry.js.php and the server side validation in edit_entry_handler.php