CREATE TABLE `cc_user` (
  `user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '姓名',
  `phone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '手机号码',
  `is_daili` enum('0','1') COLLATE utf8_unicode_ci DEFAULT '0',
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户密码',
  `recommend` decimal(10,2) DEFAULT '0.00' COMMENT '累计的直推奖(推荐奖)',
  `daili_jiang` decimal(10,2) DEFAULT '0.00' COMMENT '代理商奖,  只拿一次',
  `fenhong` decimal(10,2) DEFAULT '0.00' COMMENT '累计分红,团队奖',
  `brokerage` decimal(10,2) DEFAULT '0.00' COMMENT '累计总佣金',
  `total_amount` decimal(10,2) DEFAULT '0.00' COMMENT '个人累计总业绩',
  `pay_count` decimal(10,2) DEFAULT '0.00' COMMENT '我的钱包',
  `grade` enum('1','2','3','4','5','0') COLLATE utf8_unicode_ci DEFAULT '0' COMMENT '团队等级',
  `section` tinyint(3) DEFAULT '0' COMMENT '区号',
  `job` text COLLATE utf8_unicode_ci COMMENT '节点关系',
  `pid1` int(11) DEFAULT '0' COMMENT '爸爸 (三级关系)',
  `pid2` int(11) DEFAULT '0' COMMENT '爷爷(三级关系)',
  `pid3` int(11) DEFAULT '0' COMMENT '老爷(三级关系)',
  `zhitui_pid` int(11) DEFAULT '0' COMMENT '直推人id',
  `time` int(11) DEFAULT NULL COMMENT '注册时间',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

//佣金记录表
CREATE TABLE `cc_rebate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '分佣金表',
  `order_id` int(11) DEFAULT NULL COMMENT '订单id',
  `user_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订单用户姓名',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `uid` int(11) DEFAULT NULL COMMENT '收益人id(获利佣金的人)',
  `yongjin` decimal(10,2) DEFAULT NULL COMMENT '受益人得到的佣金数量',
  `time` int(11) DEFAULT NULL COMMENT '返利时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


 //注册新会员
    public  function user_add(){
    	 $jiedian_id=I('get.id');
    	 $user_id=session("user.user_id");//直推人id
    	if(IS_POST){
    	      $jiedian_id=I('post.jiedian_id');
    	      $zhitui_id =I('post.zhitui_id');
    	      $name=I('post.name');
    	      $haoma=I('post.haoma');
    	      $pwd=I('post.pwd');
    	      $tui_gui=	M('user')->where(array('pid1'=>$jiedian_id))->count();//统计轨道
    	      
    	       $pid=M('user')->where(array('user_id'=>$pid))->getField("pid1");
    	       $ddd=$this->digui_fu($jiedian_id,$user_id);
    	       $rrd=M('user')->where(array('phone'=>$haoma))->find();
    	      if($rrd){
    	      	$this->success("此账号已经注册过了",U('Index/index'),5);exit;
    	      }
    	      if($ddd==0){
    	      	  $this->success("对不起,此人不是你的下级, 请重新选择安置",U('Index/index'),5);exit;
    	      };
    	      if($tui_gui==3){
    	      	  $this->success("对不起,此节点人下面三个区位,已满, 请重新选择安置",U('Index/index'),5);exit;
    	      };
    	      
    	      $jie_p1 =M('user')->where(array('user_id'=>$jiedian_id))->getField("pid1");
    	      $jie_p2 =M('user')->where(array('user_id'=>$jiedian_id))->getField("pid2");
    	      $jie_p3 =M('user')->where(array('user_id'=>$jiedian_id))->getField("pid3");
    	      
    	        if($jie_p1==0){
									  	  	   	    
	    	  	  $data['pid1']=$jiedian_id;
	    	  	  $data['pid2']='0';
	    	  	  $data['pid3']='0';
	    	  	  $data['name']=$name;
	    	  	  $data['phone']=$haoma;
	    	  	  $data['password']=md5($pwd);
	    	  	  $data['zhitui_pid']=$zhitui_id;
	    	  	  $data['time']=time();
	    	  	  $add = M('user')->add($data);
	    	  	  if($add){
	    	  	  	  $this->jiedian_guanxi($add,$jiedian_id); 	
	    	  	  	  $this->zhituijiang($zhitui_id);
	    	  	  	  $this->success("注册成功",U('Index/index')); 
	    	  	  }	  
	    	   }else{
	    	  	  $data['pid1']=$jiedian_id;
	    	  	  $data['pid2']=$jie_p1;
	    	  	  $data['pid3']=$jie_p2;
	    	  	  $data['name']=$name;
	    	  	  $data['phone']=$haoma;
	    	  	  $data['password']=md5($pwd);
	    	  	  $data['time']=time();
	    	  	  $data['zhitui_pid']=$zhitui_id;
	    	  	  $add = M('user')->add($data);
	    	  	  if($add){
	    	  	  	   $this->jiedian_guanxi($add,$jiedian_id); 		    	  	  	
	    	  	  	   $this->zhituijiang($zhitui_id); 
	    	  	  	   $this->success("注册成功",U('Index/index')); 
	    	  	  	}	
	
	    	  } 
    		
    	}else{
         $users=M('user')->where(array('user_id'=>$jiedian_id))->find();//节点用户
         $zhi_tui=M('user')->where(array('user_id'=>$user_id))->find();
         $this->assign('zhitui',$zhi_tui);
    	 $this->assign('users',$users);
    	 $this->display();	
    	}
 
    }
    
    //拼接节点关系job  和  section
    
    public  function  jiedian_guanxi($aaa,$jiedian_id){
    	  
    	  $data=M('user')->where(array('user_id'=>$jiedian_id))->find();
    	  $job=$data['job'].$aaa."_";
    	  M('user')->where(array('user_id'=>$aaa))->save(array('section'=>$data['section'],'job'=>$job));
    	
    }
    
    
    //判断这个节点人是否是,我的下级;
    public  function  digui_fu($jiedian_id,$user_id){
    	         
    	          $where1['job'] = array('like',"%_$user_id_%");
    	    	  $pss1=M('user')->where(array("user_id"=>$jiedian_id))->getField("job");
    	           $pss=explode('_',$pss1);
    	           $ps=in_array($user_id,$pss);
    	         // dump($ps);eixt;
    	          if($ps){
    	          	
    	          	 return "1";
    	          } else{
    	          	 return "0";//
    	          }
    	
    }
    
    
    
    public function zhituijiang($zhitui_id){
  	  $zhi=M("parameter")->where(array('id'=>4))->getField("zhi");
  	  M('user')->where(array('user_id'=>$zhitui_id))->setInc("recommend",$zhi); 

  }