Event Management - Preventing overlapping

10 years ago
2
Topic
Hey guys,

I'm currently developing a meeting management system using Joomla and Seblod but I'm stuck at the event overlapping validation.

For example, if I got these meeting:

Meeting 1
  • Date: 2013-12-12
  • Begin: 11:00 AM
  • End: 12:00 PM
Meeting 2
  • Date: 2013-12-12
  • Begin: 1:00 PM
  • End: 2:00 PM
For the begin/end time, I got a dropdown list with all hours of a day. But, in the begin dropdown, I should disable unavailable hours, like 11 AM, 11:30, 1PM, 1:30.

Then, once the begin time is selected (example: 10:00 AM), I shouldn't be able to end it after 11 AM because there's an event already but it CAN finish at 11 AM.

So, I need a dropdown populated with available hours and another one depending on the first one.

If someone has a trick or a tip that can help me, I would appreciate it!
Get a Book for SEBLOD
106 Posts
krkr
10 years ago
0
Level 1
Hey

If you will get something on this, let me and all others to know it too. I am interested in this, but have no time to start this.

Thnx
154 Posts
WebOne
10 years ago
0
Level 1
These might help you. You are going to have to build a custom query for your dropdown
http://stackoverflow.com/questions/13414795/mysql-php-find-available-time-slots
http://stackoverflow.com/questions/13513516/find-if-time-slots-are-available-in-database-table
http://stackoverflow.com/questions/16459756/mysql-show-time-slots-avaliable-and-time-slots-busy-from-table

Get a Book for SEBLOD