It is very important that the application be responsive. That is, it should look and function well on any common web browser of any size on any device.
As this is an Internet application, security should be the utmost concern. The greatest care must be undertaken to prevent SQL injection and other security vulnerabilities.
Each table requires an additional field called company_id which identifies the calendar. This software will be used by many people at many companies but each company should only ever see their own data. On login the company_id will be determined by the unique user_name entered.
Note that this application could have millions of records for each company. So the Data Manager must be able to handle a subset of records.
This application should perform very similar to the existing Event Manager software for Windows available at [url removed, login to view] The GUI can be minimalist but all functionality should be incorporated.
For reporting I require some way that I can make report templates that users can view. So you don't have to have a custom reporting feautre for users but I need some way I can make reports as needed.
Other functionality that you don't have to complete:
-Save calendar as HTML function
-Change database function
Manage Contacts screen
-Import/Export contacts functions
-Email options (just use php email to send emails)
-Enable Security and Force Login options of Security Tab. These options should be activated at all times.
-Security - Enable Security and Force Login should be set at all times.
-Email tab - SMTP Connection Options (just use php mail) - do all other email options though
You must prove that you can run the Windows software by providing a screen shot of the software running on your machine. I do not have time to tell you how every feature works. You must be able to use the Windows software to see for yourself how it runs. I am more than happy to answer specific questions but cannot hold your hand for every aspect of the software. You must be able to work on your own. This document and the documents mentioned here constitute all of the documentation available. I have nothing else to give you.
The Auto schedule Event function allows you to automatically create events with the chosen time duration for resource/contact pairs. link selected events causes the selected events to be linked. One event will be the main event. Its ID field will be stored in the link_id field of the other events. Linked events will have a line drawn to the main event. Approve events - simply set the event's status to "approved" status. That is you set the status_id field to the id value in the status table which had the "approved" name. Same logic for "rejected".