This article mainly introduces the recursive commission scheme implemented by PHP, and analyzes the database design and function implementation skills of the PHP commission scheme in more detail in the form of a complete example, involving related skills in PHP mathematical operations. Friends in need can refer to it. I hope it will be helpful to everyone.
Recently, the recursive commission scheme has been used in CRM projects. The analysis is as follows:
The SQL statement is as follows:
CREATE TABLE `crm_proxy_bonux_rule` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '超过的部份提成规则ID', `bouns_rule_name` varchar(20) NOT NULL COMMENT '规则名称,如D套餐0-20范围', `rid` bigint(20) DEFAULT NULL COMMENT '为0,就是默认的全局设置', `start_rang` smallint(6) DEFAULT NULL COMMENT '开始范围', `end_rang` smallint(6) DEFAULT NULL COMMENT '结束范围', `bonus_rate` smallint(6) DEFAULT NULL COMMENT '提成率', `bonus_reward` decimal(8,2) DEFAULT NULL COMMENT '奖励现金', `chain_pre` int(11) DEFAULT NULL COMMENT '链表上一个值默认为0,表示根结点', `chain_next` int(11) DEFAULT NULL COMMENT '链表下一个值', `is_standard` enum('0','1') DEFAULT '0' COMMENT '是否是标准', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
The PHP implementation code is as follows:
private function bouns_recursion($range,$standard,&$rule_list,$amount){ $price = 1000; $max = $standard['end_rang'] ;//最大值 $min = $standard['start_rang'] ;//最小值 $bonus_rate = $standard['bonus_rate'];//分红率 if($range<$min){ return false; } $standard_amount = 0; $plus = 0; //是否是标准 第一个 if($standard['is_standard']==1){ $standard_amount = $price * $min * $bonus_rate / 100; //求提成 600 300 }else{ $plus = 1; //第二次要累加 } if($range > $max){ $number = ($max - $min) + $plus;//算出差值值 5 4-3 == 1 $amount = ($price * $number * $bonus_rate / 100); //求提成 200 }else{ $number = ($range - $min ) + $plus;//算出差值值 4 1 $amount = ($price * $number * $bonus_rate / 100); //求提成 } $amount = $amount + $standard_amount;//800 if(!empty($rule_list[$standard['chain_next']]) && $range > $max){ return $amount += $this->bouns_recursion($range, $rule_list[$standard['chain_next']], $rule_list,$amount); } return $amount; }
Related recommendations:
Detailed explanation of how PHP implements operable verification codes
Detailed explanation of PHP implementation Method of file search
Detailed explanation of how to implement the function of website message board in PHP
The above is the detailed content of Detailed explanation of PHP's implementation of commission calculation through recursion. For more information, please follow other related articles on the PHP Chinese website!