Completed

Web Report: New Web Orders Queue

Create a web report that returns all new web orders that are not flagged "Moved". This web report will also allow us to move orders placed in one database (we'll call it ZCDB) into our internal database (call it IDB for short). This report will give us the ability to:

Step 1 - "Find Customer" - for each customer record returned, perform a search and find matching customers in our IDB.

Step 2 - "Find Photographer" - each order record will have a "photographer" associated with it. Provide a drop-down of names from IDB.

Step 3 - "Insert" - insert the order record retrieved from from ZC and write it to IDB. With these rules:

a. If in Step 1 we find a customer match record in our DB, it will overwrite IDB customer info with ZCDB info. If no match is found then the customer will be inserted into IDB as a new record. Flag ZCDB order record as "MOVED".

b. If in Step 2 a photographer name is selected from the drop-down, then insert the selected photographer into the orders table in IDB. If no name is selected, then insert the original photographer record from ZC into IDB.

We will provide the database schema for ZCDB and IDB. ZCDB is the Zen Cart default database with one minor addition that handles the "MOVED" flag. We will provide sample data for each database for testing. We will also provide detailed mapping to specify the order info that will be retrieved from ZCDB and inserted into IDB.

Please respond with credentials, your bid and delivery time estimate. We will pay bonus for good and quick work. Thanks for looking!

Skills: Engineering, Javascript, MySQL, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: search for photographer, search for a photographer, photographer search, new web create, new web, database queue, report 2 web, work as photographer, work as a photographer, short report, queue, orders, javascript mapping, create report database php, queue php, quick order zen cart, report table, zen cart search, customer report, javascript web mapping

About the Employer:
( 53 reviews ) United States

Project ID: #2813582

Awarded to:

DIBarit

See private message.

$51 USD in 14 days
(116 Reviews)
5.4

12 freelancers are bidding on average $349 for this job

oneclickdevelop

See private message.

$1062.5 USD in 14 days
(108 Reviews)
6.7
lokeshvvw

See private message.

$212.5 USD in 14 days
(98 Reviews)
5.9
smartdatasoft

See private message.

$85 USD in 14 days
(134 Reviews)
5.8
madhazelnut1

See private message.

$161.5 USD in 14 days
(41 Reviews)
5.4
khalidamin

See private message.

$306 USD in 14 days
(44 Reviews)
5.1
softagz

See private message.

$93.5 USD in 14 days
(3 Reviews)
4.0
mrjrm

See private message.

$85 USD in 14 days
(12 Reviews)
3.7
DoubleBit

See private message.

$340 USD in 14 days
(7 Reviews)
3.6
flamealan

See private message.

$382.5 USD in 14 days
(14 Reviews)
3.5
shahramjaved0075

See private message.

$127.5 USD in 14 days
(11 Reviews)
3.5
thecloudkernel

See private message.

$1275 USD in 14 days
(3 Reviews)
0.9