方维直播增加三级分销推广功能

1、推荐链接，输入验证码确定

SELECT * FROM `fanwe_mobile_verify_code` LIMIT 0 , 30
查表确定验证码

2、下载链接不正确问题，
修改数据库 fanwe_m_config"系统手机端配置信息表" android_filename

3、个人页面域名不对。
TODO

4、推广链接 ：
wap/index.php?ctl=distribution&act=init_register&user_id=3766

5、增加user表的祖父 曾祖父id

ALTER TABLE `fanwe_user` ADD `pp_user_id` INT( 11 ) UNSIGNED NULL COMMENT '祖父id';
ALTER TABLE `fanwe_user` ADD `ppp_user_id` INT( 11 ) UNSIGNED NULL COMMENT '曾祖父id';

 

6、增加注册后一二级代理id罗库

mapi/lib/distribution.action.php

//MOCK
$res = $GLOBALS['db']->getRow("select id,p_user_id from " . DB_PREFIX . "user where id =" . $p_user_id);
$p_user_id = $res['id'];
$pp_user_id = $res['p_user_id'];
$ppp_user_id = $GLOBALS['db']->getOne("select id from " . DB_PREFIX . "user where id =" . $pp_user_id);

//MOCK
$data = array(
'head_image' => $system_head_image,
'thumb_head_image' => get_spec_image($system_head_image,40,40),
'p_user_id' =>$p_user_id,
'pp_user_id' => $pp_user_id,
'ppp_user_id'    => $ppp_user_id,
);

 

7、插入后台三级代理配置页面

INSERT INTO `test2_com`.`fanwe_m_config` (`id` ,`code` ,`title` ,`group_id` ,`val` ,`type` ,`sort` ,`value_scope` ,`title_scope` ,`desc`)
VALUES (NULL , 'distribute_level_3', '三级代理比例', '推广配置', '10', '0', '1', NULL , NULL , '三级代理比例');
INSERT INTO `test2_com`.`fanwe_m_config` (`id` ,`code` ,`title` ,`group_id` ,`val` ,`type` ,`sort` ,`value_scope` ,`title_scope` ,`desc`)
VALUES (NULL , 'distribute_level_2', '二级代理比例', '推广配置', '10', '0', '1', NULL , NULL , '二级代理比例');
INSERT INTO `test2_com`.`fanwe_m_config` (`id` ,`code` ,`title` ,`group_id` ,`val` ,`type` ,`sort` ,`value_scope` ,`title_scope` ,`desc`)
VALUES (NULL , 'distribute_level_1', '一级代理比例', '推广配置', '10', '0', '1', NULL , NULL , '一级代理比例');

 

8、用户支付成功增加三级分销充值记录
mapi/lib/vip_pay.action.php 充值会员分销
system/libs/cart.php 最终支付成功回调位置
//MOCK 判断是否是购买了会员，如果是会员的话进行分销
get_vip_charge_distrabute($payment_notice);

if ($payment_notice['order_id']>0) {

 

/*
* 充值会员推广分成
* in
* $payment_notice
* step 1根据订单中的充值名称和vip_rule表对比，有记录则为vip充值
* step 2 获取充值的金额，插入payment_notice表，订单信息协商推广返点_xxx_xxx
* step 3 更新用户余额信息
*/
function get_vip_charge_distrabute(array $arrInput){

$p_user_id = 0;
$pp_user_id = 0;
$ppp_user_id = 0;

$is_vip_charge = $GLOBALS['db']->getOne("select id from ".DB_PREFIX."vip_rule where name=". $arrInput['recharge_name']);
if(!$is_vip_charge){
return;
}

$res = $GLOBALS['db']->getRow("select p_user_id,pp_user_id,ppp_user_id from " . DB_PREFIX . "user where id =" . $arrInput['user_id']);
if($res){
$p_user_id = $res['p_user_id'];
$pp_user_id = $res['pp_user_id'];
$ppp_user_id = $res['ppp_user_id'];
}

$res = $GLOBALS['db']->getAll("select code,val from " . DB_PREFIX . "m_config where code like 'distribute_level_%' " );

if(!$res){
log_err_file("推广分成比例没有设置，请设置推广分成比例！");
return;
}

foreach ($res as $k => $v){
$res[$v['code']] = $v['val'];
}

$diamonds_rate = $GLOBALS['db']->getOne("select val from " . DB_PREFIX . "m_config where code = 'diamonds_rate' " );
$p_user_money = $res['distribute_level_1'] * $arrInput['money']* $diamonds_rate;
$pp_user_money = $res['distribute_level_2'] * $arrInput['money'] * $diamonds_rate;
$ppp_user_money = $res['distribute_level_3'] * $arrInput['money'] * $diamonds_rate;

$payment_notice_insert = array(
'notice_sn' => $arrInput['notice_sn'],
'create_time' => $arrInput['create_time'],
'pay_time' => $arrInput['pay_time'],
'order_id' => $arrInput['order_id'],
'is_paid' => $arrInput['is_paid'],
'payment_id' => $arrInput['payment_id'],
'bank_id' => $arrInput['bank_id'],
'memo' => $arrInput['memo'],
'outer_notice_sn' => $arrInput['outer_notice_sn'],
'deal_id' => $arrInput['deal_id'],
'deal_name' => $arrInput['deal_name'],
'is_has_send_success' => $arrInput['is_has_send_success'],
'paid_send' => $arrInput['paid_send'],
'pay_date' => $arrInput['pay_date'],
'recharge_id' => $arrInput['recharge_id'],
'product_id' => $arrInput['product_id'],
'iap_receipt' => $arrInput['iap_receipt'],
'diamonds' => 0,
'type' => $arrInput['type'],
);

if(!$p_user_id){
$payment_notice_insert['user_id'] = $p_user_id;
$payment_notice_insert['money'] = $res['distribute_level_1'] * $arrInput['money'];
$payment_notice_insert['recharge_name'] = '一级推广返点_'.$arrInput['user_id'];

$GLOBALS['db']->autoExecute(DB_PREFIX."payment_notice",$payment_notice_insert,'INSERT');
$sql = "update ".DB_PREFIX."user set ticket = ticket + ".$p_user_money." where id = ".$p_user_id;
$GLOBALS['db']->query($sql);
}
if(!$pp_user_id){
$payment_notice_insert['user_id'] = $p_user_id;
$payment_notice_insert['money'] = $res['distribute_level_2'] * $arrInput['money'];
$payment_notice_insert['recharge_name'] = '二级推广返点_'.$arrInput['user_id'];

$GLOBALS['db']->autoExecute(DB_PREFIX."payment_notice",$payment_notice_insert,'INSERT');
$sql = "update ".DB_PREFIX."user set ticket = ticket + ".$pp_user_money." where id = ".$pp_user_id;
$GLOBALS['db']->query($sql);
}
if(!$ppp_user_id){
$payment_notice_insert['user_id'] = $p_user_id;
$payment_notice_insert['money'] = $res['distribute_level_3'] * $arrInput['money'];
$payment_notice_insert['recharge_name'] = '三级推广返点_'.$arrInput['user_id'];

$GLOBALS['db']->autoExecute(DB_PREFIX."payment_notice",$payment_notice_insert,'INSERT');
$sql = "update ".DB_PREFIX."user set ticket = ticket + ".$ppp_user_money." where id = ".$ppp_user_id;
$GLOBALS['db']->query($sql);
}


}

 

9、开启会员
修改 /system/define.php ,添加以下代码
//VIP会员模块
define('OPEN_VIP',1);//VIP会员 0 关闭 1 开启