21,893
社区成员




CREATE TABLE IF NOT EXISTS `member` (
`shpeng` int(12) DEFAULT NULL COMMENT '接点',
`quyu` int(1) DEFAULT '0' COMMENT '第几市场,=1为第一市场,=2为第二市场,=3为第三市场',
`yzzhichu` int(12) DEFAULT NULL COMMENT '个人业绩',
`urlyz` int(1) DEFAULT '0' COMMENT '级别,分三级,=1,=2,=3',
`id` int(12) NOT NULL AUTO_INCREMENT COMMENT 'ID号',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1032 ;
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (0, 0, 5000, 3, 1001);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1001, 1, 3000, 0, 1002);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1001, 2, 1000, 0, 1003);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1001, 3, 5000, 3, 1004);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1002, 1, 2000, 2, 1005);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1002, 2, 3000, 1, 1006);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1002, 3, 1000, 0, 1007);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1003, 1, 5000, 1, 1008);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1004, 1, 2000, 1, 1009);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1005, 1, 1000, 1, 1010);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1005, 2, 2000, 0, 1011);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1006, 1, 4000, 2, 1012);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1006, 2, 3000, 0, 1013);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1009, 1, 2000, 0, 1014);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1009, 2, 1000, 0, 1015);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1009, 3, 2000, 0, 1016);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1010, 1, 2000, 0, 1017);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1010, 2, 1000, 0, 1018);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1012, 1, 5000, 0, 1019);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1012, 2, 1000, 0, 1020);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1012, 3, 1000, 3, 1021);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1016, 1, 2000, 0, 1022);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1016, 2, 1000, 0, 1023);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1016, 3, 2000, 2, 1024);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1018, 1, 1000, 1, 1025);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1018, 2, 2000, 0, 1026);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1021, 1, 1000, 0, 1027);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1021, 2, 5000, 1, 1028);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1021, 3, 1000, 1, 1029);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1024, 1, 2000, 0, 1030);
INSERT INTO `member` (`shpeng`, `quyu`, `yzzhichu`, `urlyz`, `id`) VALUES (1024, 2, 4000, 3, 1031);
mysql_connect();
mysql_select_db('test');
$rs = mysql_query('select * from member where id=1001');
while($v = mysql_fetch_assoc($rs)) {
$res[$v['id']] = foo($v, $v['urlyz']);
}
foreach($res as $k=>$r) {
echo "$k\n";
foreach($r as $i=>$v) printf("\t%s\t%s * %.2f = %d\n", $i, join("\t", $v), ($v[0]-$v[1])/100, $v[3] * ($v[0]-$v[1])/100);
}
function foo($a, $def=-1, $last=0) {
$res = array();
extract($a);
if($def < 0) $def = $urlyz;
//查找下一级
$rs = mysql_query("select * from member where shpeng='$id'") or die(mysql_error());
while($v = mysql_fetch_assoc($rs)) {
if($def > $v['urlyz']) {
$res[$v['id']] = array($def, $last, $v['urlyz'], $v['yzzhichu']);
foreach(foo($v, $def, max($last, $v['urlyz'])) as $k=>$r) $res[$k] = $r;
}
}
return $res;
}
1001
1002 3 0 0 3000 * 0.03 = 90
1005 3 0 2 2000 * 0.03 = 60
1010 3 2 1 1000 * 0.01 = 10
1017 3 2 0 2000 * 0.01 = 20
1018 3 2 0 1000 * 0.01 = 10
1025 3 2 1 1000 * 0.01 = 10
1026 3 2 0 2000 * 0.01 = 20
1011 3 2 0 2000 * 0.01 = 20
1006 3 0 1 3000 * 0.03 = 90
1012 3 1 2 4000 * 0.02 = 80
1019 3 2 0 5000 * 0.01 = 50
1020 3 2 0 1000 * 0.01 = 10
1013 3 1 0 3000 * 0.02 = 60
1007 3 0 0 1000 * 0.03 = 30
1003 3 0 0 1000 * 0.03 = 30
1008 3 0 1 5000 * 0.03 = 150
与你 #8 提供的结果一致1001
1002 3 0 0 3000 * 0.03 = 90
1005 3 0 2 2000 * 0.03 = 60
1010 3 2 1 1000 * 0.01 = 10
1017 3 2 0 2000 * 0.01 = 20
1018 3 2 0 1000 * 0.01 = 10
1025 3 2 1 1000 * 0.01 = 10
1026 3 2 0 2000 * 0.01 = 20
1011 3 2 0 2000 * 0.01 = 20
1006 3 0 1 3000 * 0.03 = 90
1012 3 1 2 4000 * 0.02 = 80
1019 3 2 0 5000 * 0.01 = 50
1020 3 2 0 1000 * 0.01 = 10
1013 3 1 0 3000 * 0.02 = 60
1007 3 0 0 1000 * 0.03 = 30
1003 3 0 0 1000 * 0.03 = 30
1008 3 0 1 5000 * 0.03 = 150
1002
1003
1004
1009 3 0 1 2000 * 0.03 = 60
1014 3 1 0 2000 * 0.02 = 40
1015 3 1 0 1000 * 0.02 = 20
1016 3 1 0 2000 * 0.02 = 40
1022 3 1 0 2000 * 0.02 = 40
1023 3 1 0 1000 * 0.02 = 20
1024 3 1 2 2000 * 0.02 = 40
1030 3 2 0 2000 * 0.01 = 20
1005
1010 2 0 1 1000 * 0.02 = 20
1017 2 1 0 2000 * 0.01 = 20
1018 2 1 0 1000 * 0.01 = 10
1025 2 1 1 1000 * 0.01 = 10
1026 2 1 0 2000 * 0.01 = 20
1011 2 0 0 2000 * 0.02 = 40
1006
1013 1 0 0 3000 * 0.01 = 30
1007
1008
1009
1014 1 0 0 2000 * 0.01 = 20
1015 1 0 0 1000 * 0.01 = 10
1016 1 0 0 2000 * 0.01 = 20
1022 1 0 0 2000 * 0.01 = 20
1023 1 0 0 1000 * 0.01 = 10
1010
1017 1 0 0 2000 * 0.01 = 20
1018 1 0 0 1000 * 0.01 = 10
1026 1 0 0 2000 * 0.01 = 20
1011
1012
1019 2 0 0 5000 * 0.02 = 100
1020 2 0 0 1000 * 0.02 = 20
1013
1014
1015
1016
1017
1018
1019
1020
1021
1027 3 0 0 1000 * 0.03 = 30
1028 3 0 1 5000 * 0.03 = 150
1029 3 0 1 1000 * 0.03 = 30
1022
1023
1024
1030 2 0 0 2000 * 0.02 = 40
1025
1026
1027
1028
1029
1030
1031