Færdiggjort

Display Orders by Agency

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.

## Deliverables

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.

## Platform

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+

Evner: Amazon Web Services, Ingeniørarbejde, Javascript, MySQL, PHP, Software Arkitektur, Software Testning, Web Hosting, Hjemmeside Management, Hjemmeside Testning

Se mere: what's my zip coder, mozilla firefox company, how to get a value in javascript, data structure coding, communication agency, code agency, buyer agency, working agency, how to copyright an idea, exclusive agency, agency work, orders, php mysql display existing table, mysql diagram, mysql javascript firefox, javascript database diagram, firefox javascript mysql, javascript value change, javascript diagram, display table

Om arbejdsgiveren:
( 53 bedømmelser ) United States

Projekt ID: #3313270

Tildelt til:

maxk

See private message.

$220.15 USD in 8 dage
(10 bedømmelser)
4.2

10 freelancere byder i gennemsnit $248 på dette job

rattanisoft

See private message.

$637.5 USD in 8 dage
(315 bedømmelser)
7.5
kmzacks

See private message.

$126.65 USD in 8 dage
(187 bedømmelser)
6.9
spidelltech

See private message.

$127.5 USD in 8 dage
(36 bedømmelser)
5.2
jscurless

See private message.

$318.75 USD in 8 dage
(27 bedømmelser)
5.0
alfino

See private message.

$102 USD in 8 dage
(28 bedømmelser)
5.0
thebluetheme

See private message.

$102 USD in 8 dage
(14 bedømmelser)
5.0
onephpcoder

See private message.

$85 USD in 8 dage
(33 bedømmelser)
4.8
blackshadowov

See private message.

$85 USD in 8 dage
(17 bedømmelser)
3.6
rajeswaree

See private message.

$637.5 USD in 8 dage
(6 bedømmelser)
0.0
adamgh

See private message.

$127.5 USD in 8 dage
(0 bedømmelser)
0.0