> I have a client who wants me to build a "No-flush Binary
> marketing"
> application in SQL and CF. I've looked at several
> examples and really
> don't know how to approach building an infinite tree
> structure of this
> sort. Can anyone point me to resources for learning how
> to develop this
> type of system, implementing business rules and
> calculating commissions?
> I've never worked with MLM stuff. At first glance it
> seems fairly
> simple, but the further I get the more questions pop up.
> The big thing
> here is probably speed in calculating the left/right
> percentages and
> processing downline commissions - it's an infinite
> structure...
> Anyway, thanks for any information anyone can provide.
I hate working on MLM stuff... The code to maintain the tree and calculate
commissions is a nightmare...
I typically use the NTM model stuff for the database like Joe Celko's sql
for smarties stuff... Have a cross-reference table that shows all downline
as related to all upline, with a 3rd column for "separation". The separation
column can then be related to a 3rd table with just separation and
percentage, that way you can pull commissions vairly easily from the db.
select upline.membername, upline.memberid, xref.separation,
(xref.percentage * ... ) AS commissionvalue,
donwline.memberid, downline.membername
from members upline
left join xref on ( xref.uplineid = upline.memberid )
left join members downline on ( downline.memberid = xref.downlineid )
The larger problem is likely to be maintaining the xref table -- I've been
doing this recently and having a lot of problems with SQL Server running out
of resources to perform an update.
Fortunately I haven't had to work on MLM stuff very often...
hth
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
