PHP MySQL Score calculation engine + frontend

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.

## Deliverables

Attached: the actual Scores calculation page (it only considers Products) and Scores definition page.

Habilidades: Engenharia, Linux, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Veja mais: work competitions, tool design concepts, mobile php files, how to develop php project, how to develop php, develop dashboard in php, define product design, database design for crm, competition engine, score score, product design competition, score, product design competitions, php dashboard, mysql iphone, mobile crm, inherited, frontend php, crm mobile, plans section, mysql sort, php reporting tool, webapp design, php mysql webapp, codeigniter webapp

Acerca do Empregador:
( 25 comentários ) Turin, Italy

ID do Projeto: #3004033

4 freelancers estão ofertando em média $388 para esse trabalho


See private message.

$425 USD in 14 dias
(32 Comentários)

See private message.

$552.5 USD in 14 dias
(4 Comentários)

See private message.

$255 USD in 14 dias
(5 Comentários)

See private message.

$318.75 USD in 14 dias
(0 Comentários)