Affiliate Marketing Query System

We are currently using Miva for affiliate tracking, using the Viking Coders add-on modules for additional functionality. (keep reading even if you never have heard of these systems, its not crucial to bidding on the project). The Affiliate system places the data for each affiliate in a Dbase file. We would like our affiliate partners to access elements of that database. I have included a sample Dbase file as an example so that you can understand the structure of the file. We will NOT be able to adjust the dBase file ??" treat it as a read only. There is a PHP module to access dBase ??" this may be an appropriate solution, but I am open to other suggestions. We will need to extract and manipulate some data elements of that file. The attached powerpoint contains the vision of what we want to accomplish. The affiliate advertisement should have the ability to total the number of orders and do simple math on those orders to show a balance of “carbon reduced??. For example, if Affilate XYZ has sold 3 TPAH and 1 TPAU, they would have a carbon reduced balance of 38,000 lbs (3*6000 lbs + 1*20,000 lbs). There are four SKUs, available on our website. An alternative approach is to create a separate mySQL database with a highly streamlined or automatic way to include data from the Dbase File. In either case you will be responsible for also implementing both the server database files and the java elements needed to reside on the affiliate page (design is not important just the mechanics). ## Deliverables 1) Any server-side scripts (such as cgi or PHP) necessary for execution of the application, along with directions on appropriate file permissions and directory structure. 2) All necessary HTML pages that supports the complete functional specification. The graphic design of these pages isn’t important. 3) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 4) 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. 6) 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). ## Platform The server environment is a standard variant of Unix, running a recent version of perl and Apache. The server supports both perl cgi and PHP. The application must function correctly in the following browsers: Internet Explorer 5 and above Mozilla 1.7 and above Safari 8.5 and above