I need an application that interacts with an affiliate network platform, which advertisers can use to process their commissions in bulk.
Usually an advertiser has to inspect each commission generated in his/her campaign to see if it was valid or not. Only approved commissions get invoiced.
What the application has to do is take a CSV/XLS file as input, map one column to commission IDs and another column to commission status. After that, it should check the values in the status column and map each distinct value in the file to a predefined set of commission statuses in the network (approved/rejected/pending). When all these things are set up, the advertiser can start the mass-processing of commissions, which are modified via API. The end result is that all pending commissions are approved/rejected/left as they were according to the file the advertiser uploaded.
The application will be installed using the platform application store (already up&running). Further API documentation and details about the platform/appstore will be handed over to the chosen bidder.
The app will run on one of our servers (PHP/MySQL/Apache) and all application sources will be handed over once project is complete. We will host the application, NOT you. I do have a strong preference for apps written in the Yii framework ([url removed, login to view]), but this is NOT a requirement.
When bidding, please state whether you will use this PHP framework or not. That way I will know if you have read the specs entirely.