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 Member Posts: 2
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.