My favorites | Sign in
Project Home Issues
New issue   Search
for
  Advanced search   Search tips   Subscriptions
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
Status:  Invalid
Owner:  ----
Closed:  Aug 2013


Sign in to add a comment
 
Reported by neilbatc...@gmail.com, Jun 14, 2013
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
(No comment was entered for this change.)
Status: Invalid
Sign in to add a comment

Powered by Google Project Hosting