Calculating commission based on the levels in cakephp - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Calculating commission based on the levels in cakephp

vickshavicksha Posts: 2Member
Hi,
I am new to cakephp and i need some help.
I have 2 columns in a table, agentid and sponsorid.
I need to calculate commission, if a agent has a sponsorid and this is considered as Level1.
If Level1 sponsor has a sponsorid, then this is considered as level2.
If Level2 sponsor has a sponsorid, then this is considered as level3.
Similarly i need to find for 6 levels to calculate the commission.
The commission varies for each level.

Ex:
agentid => sponsorid
75=>100,
42=>75,
90=>42,
37=>90,
25=>37,
10=>25

Thanks in advance,
Sign In or Register to comment.