lizhenqiu blog

function daorudata(){
		$new_text='请上传Excel文件';
		
		if(! empty ( $_FILES ['file_stu'] ['name'] )){
			
				$file = $_FILES ['file_stu'] ['tmp_name'];
				$file_types = explode ( ".", $_FILES ['file_stu'] ['name'] );
				$file_type = $file_types [count ( $file_types ) - 1];
				 /*判别是不是.xls文件，判别是不是excel文件*/
				 if (strtolower ( $file_type ) != "xls"){
					  $new_text='不是Excel文件，重新上传';
					  //exit;
				 }
				 else{
			// 判断文件是什么格式
    $type = pathinfo($file); 
    $type = strtolower($type["extension"]);
    $type=$type==='csv' ? $type : 'Excel5';
    ini_set('max_execution_time', '0');
    Vendor('PHPExcelN.PHPExcel');
    // 判断使用哪种格式
    $objReader = \PHPExcel_IOFactory::createReader($type);
    $objPHPExcel = $objReader->load($file); 
    $sheet = $objPHPExcel->getSheet(0); 
    // 取得总行数 
    $highestRow = $sheet->getHighestRow();     
    // 取得总列数      
    $highestColumn = $sheet->getHighestColumn(); 
    //循环读取excel文件,读取一条,插入一条
    $data=array();
    //从第一行开始读取数据
	//dump($data);
    for($j=2;$j<=$highestRow;$j++){
        //从A列读取数据
		
        //for($k='A';$k<=$highestColumn;$k++){
            // 读取单元格
			$k='A';
            if($objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue()){
				$data[$j][]=$objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue();
				$vsfsd=$objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue();
				$newdr[$k]['tel']=$vsfsd;
				$pass=str_split('0'.$vsfsd,6);
				$newdr[$k]['pass']=$pass['1'];
				$daoruok=$this->ree($newdr[$k]['tel'],$newdr[$k]['pass']);
				//成功注册
				/*if($daoruok){
					$daoruokstr.='成功注册'.$newdr[$k]['tel'].'<br>';
				}else{
					$daoross.='导入失败'.$newdr[$k]['tel'].'<br>';
				}*/
				$daoross.=$newdr[$k]['tel'].'<br>';
				if($j==$highestRow) $daoross.='会员数据导入结束。<br>';
				//$this->display ();
			}
			
        //} 
    }  
	//dump($data);
	$new_text='正在导入中...';

    //return $data;
	}
 
		}
	$this->assign ( 'daoruokstr', $daoruokstr );
	$this->assign ( 'daoross', $daoross );
		$this->assign ( 'new_text', $new_text );
		$this->display ();
	}

function ree($tel,$pass){
		
		
		

		
				$mapc['tel']=$tel;
				$s_tel=M('huiyuan')->where($mapc)->limit(0,1)->select();
				$s_tel=($s_tel['0']['id']);
				if($s_tel) return false;
		
			//写入注册信息
			$data ['token'] = get_token ();
			//$data['rip']=$this->getip();
			$data['tel']=$tel;//$_SESSION['check_mobile'];//$_POST['tel'];
			$salt=$this->generate_rand(9);//rand(100000,999999);
			$data['salt']=$salt;
			$data['pass']=md5($pass.$salt);
			$data['cTime']=time();
			$data['mTime']=$data['cTime'];
			$saltr=$this->generate_rand(9);
			$data['saltr']=$saltr;
			//$data['lip']=$data['rip'];
			$data['zcj']=0;//$_SESSION['guanzhu_choujiang'];
			//$data['logg']=md5($data['rip'].$data['saltr']);//md5($data['rip'].$data['mTime'].$data['saltr']);
				//注册送抽奖次数
				//$nnpn=($this->config);
				//$nnpn=$nnpn['cjzss']+0;
				
				//$nnpncjzssdd=($this->config);
				//$nnpncjzssdd=$nnpncjzssdd['cjzssdd']+0;
				
				//$data['dtime']=date('Ymd');
				
				//if($nnpn) $data['zcj']=$_SESSION['guanzhu_choujiang']+$nnpn;//$_SESSION['guanzhu_choujiang']+$nnpn;
			
			$res = M('Huiyuan')->add($data);
			if($res){
				//echo '成功注册 '.$tel.'<br />';
			}
		
	}