| Issue 1871: | User specific multiple private calendars and availability and booking management | |
| 1 person starred this issue and may be notified of changes. | Back to list |
Enter a detailed description I run a company focussed Venue Search, booking and meeting booking. We would like to run your calendar sourcing data from our SQL and MYSQL databases. It is easy to integrate your php smart calandar with our internal data, accounts, users, venue employees, venue data, meeting room data, availability etc This is how we see the calendar structure for us (see diagram below). Clearly also the venue employees or group users see a privelaged set of data compared to web visitors (their customers). When searching web users/visitors will select a range of criteria which need to be satisfied from our own DBs. We then present venues and meeting room options at a group and inidividual level that match that criteria, likely availability, delegate capacity, catering, multi event days, other facilities. The meeting rooms will also need to dispay all this data again from our DBs, then via the same interface the user can block out availability, make a booking online and pay. The venue employee can then see all this info in their calendar. Please bear in mind that we have a user admin and data capture tool where we register all user accounts, manage venue data, manage bookings, images, meeting rooms. php/mysql Our relational DB links users to venues and venues to meeting rooms, and users to meeting rooms So we want to use your calendar as a diary per venue per meeting room, so possible 1-99 meeting rooms per venue. Each user account can have 1-20 venues so a user could decide to run 20 calendars or 200 if they had 10 meeting rooms per venue. We also want to use the calendar to check avilability to a end user (so not venue owner), member of public/business that wants to book a meeting room. Can you filter to give a view of available slots on a range of days for example a week, per venue or per meeting room? We have a data capture tool. The principal function of the company is to book venues and meeting rooms. We have built our capture a tool in PHP MySQL Database structure is as follows: Marketing at our company is super admin Users: like Venue general managers, using USERID as a primary key Venues: Details of venues, 1-20 per user using VENUEID as a primary key and USERID as a linked foreign key. Meeting Rooms linked to VENUEID Rooms linked to VENUEID Eating Places and corporate days linked to venue ID and so Each venue, meeting room, rooms, eating place and corporate day needs its own calendar. All linked to one USERID only that user can see there calendars. We need your calendar to plug in with our data structure. Auto create when a user adds a venue, meeting room etc. Each calendar needs to specify its working days and hours On search by a member of the public, I.e a visitor not a user/client, they can search any venue, meeting room, rooms, eating place and corporate day from the front end. and the search engine needs to return time and availability for any given from/to date. Then display all the options and availability and for the visitor to book a slot and add their details for the booking. Does that help? How easy is your tool to integrate or plug in please? Can we achieve the above? Particularly to have all the calendars segregated, input all the bookings either by admin or via public bookings, easily display availability, display availability add to php search functions. please contact me on neil.batchelor@btinternet.com to discuss further Many thanks, Neil
Aug 24, 2013
Project Member
#1
adamrs...@gmail.com
Status:
Invalid
|
|
| ► Sign in to add a comment |