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!