Images on grid

sumitp584 over 8 years ago

Am Trying to achieve a room booking feature. So when the user selects the start datetime and end datetime and checks availability I need to populate the data as shown in the grid. The circle with whites are available and the blacks indicates its non available. I have different approaches in mind but just wanted to check what would be the best approach to achieve the same.
Requirement in short - The user enters start n end datetime, query the booking table get the date and time booking history for the user selected date, then i have to display it hourly for the day in the grid as shown.

Thanks in Advance... !!!

Discussion posts and replies are publicly visible

0 reginaldm377 over 8 years ago

I had some thoughts but first I wanted to know if this is a feature that multiple users can use simultaneously or will it be a single user at a time?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sally Mason
Appian Employee
over 8 years ago

If a single user is clicked one of the icons, you could query the times available and display in results in a grid below, have the grid visibility hidden until the user selects an option and the query returns results?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rama Thummala
Certified Lead Developer
over 8 years ago

@sumitp
The approach is looking pretty good.
What I am thinking is , displaying only the available slots(time periods) would be looking good instead of displaying all the time intervals for given (selected ) time intervals (depends on the business again)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Dastagiri Dudekula over 8 years ago

@sumitp584. The first major challenge is to handle concurrency control. As per your pic there is an ambiguity in the end user perspective for an instance let us say I want to book from 8am-9am, I am unable to figure out whether the 8am-9am session is booked or not booked (from your post explanation) because dark circle is booked and white circles are un-booked.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Dastagiri Dudekula over 8 years ago

One of best ways is to take full circle, indicate the sectors with relevant reserved details along with time fragment. So that it can save the space and time during the end user booking. For idea we can make a timer sheet like the attachment
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel