I'm looking for someone to make a basic PHP-based web service for me and some well designed MySQL tables to hold and store the data.
There are 2 types of data to be stored:
Merchant Commission - commission available to affiliates from various affiliate networks - can be % or flat rate
User Commission Earned - commission earned by users from affiliate links they clicked and products they purchased
This project is only to build the web service (PHP) to store and retrieve the data and the mysql tables to contain that data.
I want the mysql scripts to create the table and index structures and the 2 PHP files for the web services.
There will be set and get on both merchant and user commission.
Here are the 4 web service calls:
setMerchantCommission - parameters (that i know of so far): affiliateid/name, merchantid, product type, commission currency, commission type, commission value
getMerchantCommission - parameters: affiliateid/name, merchantid/name
setUserCommission - parameters: userid, transactionid, affiliateid, merchantid, currency, commission value
getUserCommission - parameters: userid (returns JSON of entire history of user commission earned including dates earned etc)
I don't accept spammers, so in your application please provide the mysql you would use to create the usercommission table.
Good luck, and let's get cracking!