PHP Trouble Ticket System

**Background: This project is for an apartment complex, with 100+ apartments, this will be used for tennants to register, login, and report a problem, or file a complaint/comment. When the tennant registers, they need a confirmation email, plain text okay, stating they are registered. We will need a forgot pass feature, where they put in their apartment number, and the pass is emailed. Plain text passwords will be fine in the database. Please see attached powerpoint presentation for an idea of what the client is expecting. DESIGN** * Layout will look mostly like the powerpoint presented * Theme is flexible **TROUBLE FORM** * Get brief description of problem * Automatically put into our database, and notify via email to the tenant that we received their trouble report * Data collected will be used to track typical problems etc.. * Also will be able to post comments and complaints from same form **SERVICE CREW LOGIN** * Service staff will login and see new/existing trouble tickets * Click on a ticket to write notes / close the ticket * Also re-assign tickets to other crew members if needed * Will not see comments / complaints **ADMIN LOGIN** * Admins will be able to login to see avg response times, who has what tickets open, and to make sure tickets are being handled * Also used to see typical problems, and total usage of the site * Will see comments / complaints ## Deliverables 1) Complete and fully-functional working site. 2) Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's test environment. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive complete resellable rights, programmer MAY change the layout, and redistribute as they see fit. ## Platform PHP and mySQL - OR - MS Sql, will probably be using Microsoft for the live site.