This is a **PHP+MySQL** project aimed to develop a new score calculation module for an existing webapp. The WebApp is build on **CodeIgniter** 1.7.2 and it's sort of a CRM.
It would have a new section where "Score calculations" would happen based on different "Competitions", and appear on a dashboard whose design is attached.
These are the **main concepts** for this project:
1. **Competition**: it's a range of dates, a competition usually starts on the 1st of the month and it lasts until the end of the next month. So we'll have JAN-FEB-2010, MAR-APR-2010, etc
2. **Products & ****Plans: we are basically talking about mobile plans and products, i.e. "iPhone" is a product, "ADSL" is a product, etc, and "No Limits" is a plan, such as "30Hours/month" is a plan, etc ...
3. Scores:** they are assigned on a **competition basis**; you could define different scores for each competition, the combination of products and plans have different scores. (next competition, values are inherited but could be modified)
iPhone: 2 points
iPhone with No Limits plan: 4 points
iPhone with another plan: 3 points
4. **Values** about products and plans sold during the year are stored into database with "inserted_on" dates, so scores would be **calculated according to the product+plans scores definitions for each competition, and published on the Dashboard.** Results would be also aggregated on per Product+Plan, Agents, Total.
In the Reporting section of the tool (will be developed later) we need to collect how many iPhones have been sold, independently from the associated plan, so Products and Plans should be separated entities.
The WebApp is already installed on a shared linux webhosting, you only
have to deliver **new and updated files** required by the tool, with any other information needed to make it work correctly.
Attached: the actual Scores calculation page (it only considers Products) and Scores definition page.