I need an application with 3 parts: MySQL database, front-end website designed in PHP (or ASP), and a script (probably a Cronjob) to send emails at a date/time specified by a database field. Users will have the ability to choose an address from a list, then create an appointment for a specific date/time for any agent listed in the database. When the user selects an address, the showing instructions for that address will autofill a Memo field. Additionally, this appointment will be stored in the database, then the agent (who was selected from a list from the database) will be emailed at the time of the appointment. (They will also be a button they can click on to edit the agent's email address.) The email will contatin a direct link back to a feedback form, which will create a record of their opinion of the appointment. In addition, their needs to be a simple report that can be run on each address that sums/averages all the data per address. There needs to be an Admin interface that allows the user to add/edit/delete Addresses, add/edit showing information for a particular address, change their email address, and view reports. Their will also need to be a Master Admin interface that will allow for changes to Feedback form; add/edit/delete agents, usernames, email addresses. I will also need the ability to mass import agents and addresses (approximate list size is 2500). Users will have to log with to website via username, password, and office name. They will only have access to certain addresses via authentication and office name. This will be somewhat similar to [login to view URL]
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation help when installing on own webserver (if needed). 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Linux MySQL 4.0.12 PHP 4.3.1 Perl 5.008 (if needed) CronJobs IS AVAILABLE ASP is available