I have an existing database structure that contains orders, order details, and customers. Customers are referred by Agencies, so there is a link to the Agency and Agency contacts. In addition, all communication is logged between an Agency, its contacts and my company. What I need is to pass an Agency as a variable to a php page that will return all the orders for that Agency, along with all of the required information about each order and the communication surrounding each order. I have attached a database diagram, database creation sql, and an example screen that shows how the returned information should be returned along with the database fields that correspond to each printed value. If needed, I can also supply sample values for the database to make coding it easier. Since the database already exists, its data values and structure cannot change. Please look over all the documents in the attached zip file to get an idea of the project scope before asking questions. Visual look and feel of the interface is not as important as returning the correct data from each table.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
All information in the attached zip diagrams must be included in the finished project. All information requested must be shown for every order that exists for each agency. Agencies are managed in the accounts table of the databse. All database creation sql is included.
This project should run in every browser (IE, Firefox, Safari, Mozilla, Konqueror, Opera) it should run on PHP 5+ on Apache 2.0+ with MySQL database 4.2+