Cakephp logic for calculating commission - Programmers Heaven

Howdy, Stranger!

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

Categories

Cakephp logic for calculating commission

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