<?php
header('Content-Type:text/html;charset=utf-8');
class MemberAction extends CommonAction
{
	private $tab = 'Webuser';
	public function _initialize() {
		parent::_initialize();
		$this->checkLog();	//判断用户是否已经登录
		$this->assign('memberList',$this->getPower());	//用户权限
	}
/**
 * 获取用户基本信息
 * @param  array  $where [筛选条件]
 * @param  string $field [调取字段]
 * @param  string $tab [表格]
 * @return array
 */
	private function getUserInfo($where=array(),$field=array('id','pid','depth','username','name','email','tel','ltime','lip'),$tab='Webuser'){
		$m=M($tab);
		$m=$m->where($where);
		if($field) $m=$m->field($field);
		$data=$m->find();
		return $data;
	}
/**
 * 会员中心（基本情况）
 */
	public function index(){
		$where['id']=array('eq',cookie('uid'));
		$info=$this->getUserInfo($where);
		$this->assign('info',$info);//会员基本信息
		$this->display();
	}
/**
 * 修改用户信息
 */
	public function memedit(){
		if($this->isPost()){
			$m=D($this->tab);
			$_POST['id']=cookie('uid');
			if($m->create()){
				unset($m->username);
				$last=$m->save();
				if($last)
					$this->success('信息修改成功',U('index'));
				else
					$this->error('信息修改失败');
			}else{
				$this->error($m->getError());
			}
		}else{
			$where['id']=array('eq',cookie('uid'));
			$info=$this->getUserInfo($where);
			$this->assign('info',$info);//会员基本信息
			$this->display();
		}
	}
/**
 * 用户修改密码
 */
	public function editpass(){
		if($this->isPost()){
			$m=M($this->tab);
			$where['id']=array('eq',cookie('uid'));
			$where['password']=array('eq',md5($_POST['oldpass']));
			$onearr=$m->where($where)->field('id,password,email')->find();
			if(!$onearr){
				$this->error('原始密码错误，请重新输入');
			}
			$newPwd = I('post.password');
			if(!$newPwd){
				$this->error('新密码不能为空');
			}
			if($newPwd != I('post.password2')){
				$this->error('两次密码不一致，请重新输入');
			}
			if(md5($newPwd) == $onearr['password']){
				$this->error('新密码不能与原始密码相同');
			}
			$where2['id']=array('eq',$onearr['id']);	
			$data['password'] = md5($newPwd);
			$row=$m->where($where2)->save($data);
			if($row){
				$this->clearLog();
				exit('<script>alert("修改成功，请重新登陆！");top.location.href="'.U('Public/login').'";</script>');
			}else{
				$this->error('修改失败！');
			}
			exit;
		}
		$this->display();
	}
/**
 * 资料展示
 */
	public function show(){
		$model = M('Apply');
		//$where['status'] = array('eq',2);
		$order = 'addtime desc';
		$map['isshow2'] = array('eq',1);//列表
		$regfields = $this->getFields($map);//获取字段信息
		$arr=$this->orderFields($regfields);//将字段数组重新整理
		$colnum=count($arr['field']) + 4;	//列数
		$this->assign('colnum',$colnum);
		$this->assign('field',$arr['field']);	//字段(排序)
		$this->assign('regfields',$arr['new_regfields']);	//字段信息 键名为name
		$farr=$this->userInfo(cookie('uid'));//获取当前用户的信息
		
		//dump($where);
		$where['isshow']=array('eq',1);
		$field=array_merge($arr['field'],array('id','uid','username','addtime','status','reviewtime','depth','isshow'));
		$data = $this->_getLists($model,$where,$order,$field,10,'Pages3',array('header'=>'<li style="border:none;">共%totalRows%条记录','pages'=>'%nowPage%/%totalPages%页　</li>','prev'=>'<上一页','next'=>'下一页>','first'=>'首页','last'=>'尾页','theme'=>'%header% %pages% %prePage% %linkPage% %nextPage% %end%'));
		$this->assign('list',$data['list']?$data['list']:array());	//列表
		$this->assign('page',$data['page']);	//分页
		$this->assign('p',$data['p']);	//当前页数
		$this->assign('page_title','资料展示');
		$this->assign('dengji',$farr['dengji']+1);
		$this->assign('empty','<tr><td colspan='.$colnum.' style="padding-left:15px;font-size:14px;">暂无相关信息！</td></tr>');
		$this->display();
	}

/**
 * 资料审核
 */
	public function review(){
		$model = M('Apply');
		//$where['status'] = array('eq',2);
		$order = 'addtime desc';
		//搜索
		if($search['title'] = I('post.title','','trim,htmlspecialchars')){
			$where['title'] = array('like','%'.$search['title'].'%'); 
		}
		if(($search['status'] = I('post.status')) !== ''){
			$where['status'] = array('eq',intval($search['status'])); 
		}
		$this->assign('search',$search);
		$map['isshow2'] = array('eq',1);//列表
		$regfields = $this->getFields($map);//获取字段信息
		$arr=$this->orderFields($regfields);//将字段数组重新整理
		$colnum=count($arr['field']) + 4;	//列数
		$this->assign('colnum',$colnum);
		$this->assign('field',$arr['field']);	//字段(排序)
		$this->assign('regfields',$arr['new_regfields']);	//字段信息 键名为name
		$farr=$this->userInfo(cookie('uid'));//获取当前用户的信息
		if(C('open_power')==='Y'){//开启同等级交互管理权限
			$dep_arr=explode(',',$farr['depth']);
			if(count($dep_arr)>1){
				array_pop($dep_arr);
				$sbarr=implode(',',$dep_arr);
				$where['depth'] = array('like',$sbarr.',%,%');
			}else{
				$where['depth'] = array('like',$farr['depth'].',%');
			}
		}else{
			$where['depth']=array('LIKE',$farr['depth'].'%');//所有子级	
		}
		//dump($where);
		$where['isshow']=array('eq',$farr['dengji']+1);//只是下一级（包括其他子级审核通过的）
		$field=array_merge($arr['field'],array('id','uid','username','addtime','status','reviewtime','depth','isshow'));
		$data = $this->_getLists($model,$where,$order,$field,10,'Pages3',array('header'=>'<li style="border:none;">共%totalRows%条记录','pages'=>'%nowPage%/%totalPages%页　</li>','prev'=>'<上一页','next'=>'下一页>','first'=>'首页','last'=>'尾页','theme'=>'%header% %pages% %prePage% %linkPage% %nextPage% %end%'));
		$this->assign('list',$data['list']?$data['list']:array());	//列表
		$this->assign('page',$data['page']);	//分页
		$this->assign('p',$data['p']);	//当前页数
		$this->assign('page_title','资料审核');
		$this->assign('dengji',$farr['dengji']+1);
		$this->assign('empty','<tr><td colspan='.$colnum.' style="padding-left:15px;font-size:14px;">暂无相关信息！</td></tr>');
		$this->display();
	}
/**
 * 修改审核状态
 */
	public function Shenhe(){
		$Article = M("Apply");
		$id = I('post.id',0,'intval');
		$val = I('post.val',0,'intval');
		if(!$id || !$val || $val >= 3){	//状态值范围0，1，2
			$r['success'] = false;
			$r['msg'] = '参数有误！';
			echo json_encode($r);
			exit;
		}
		$where['id'] = array('eq',$id);
		$status = $Article->where($where)->getField('status');//查询数据库中的审核状态值
		if($val == $status)	//相等直接返回
		{
			$r['success'] = true;
			$r['val'] = $val;
		}else{	//更改审核值
			$arr=$Article->where($where)->setField('status',$val);
			if($arr){
				$r['success'] = true;
				$r['val'] = $val;
			}else{
				$r['success'] = false;
				$r['msg'] = '审核状态修改失败！';
			}
		}
		if($val==1){
			$r['status'] = '<span style="color:red;">审核不通过</span>';
		}else{
			$r['status'] = '审核通过';
			//更改审核状态的值
			$data['isshow']=$this->recurIsshow(cookie('uid'));
			M('Apply')->where('id='.$id)->save($data);
		}
		echo json_encode($r);
	}

/**
 * 资料检索
 */
	public function retrieval(){
		$model = M('Apply');
		if(I('name')){
			$map['name'] = array('eq',I('name'));//导航点击
			$this->assign('name',I('name'));
		}
		$map['issearch'] = array('eq',1);//检索-条件
		$order = 'addtime desc';
		$s_regfields = $this->getFields($map);//获取字段信息-检索
		$s_arr=$this->orderFields($s_regfields);//将字段数组重新整理-检索
		$this->assign('s_field',$s_arr['field']);//检索-字段
		$this->assign('s_regfields',$s_arr['new_regfields']);//检索-字段
		//搜索
		if($this->isPost()){
			
			foreach($s_arr['field'] as $fiev){
				if($s_arr['new_regfields'][$fiev]['isjs']==1){//调用全球国家js组件
					if(I($fiev)){
						if(I($fiev.'2')){
							$where[$fiev] = array('like','%'.I($fiev).'-'.I($fiev.'2').'%'); 
							$search[$fiev]=I($fiev);
							$search[$fiev.'2']=I($fiev.'2');
						}else{
							$where[$fiev] = array('like','%'.I($fiev).'%'); 
							$search[$fiev]=I($fiev);
						}
					}	
				}elseif(is_array(I($fiev))){	//数组
					$str_fiev='';
					foreach(I($fiev) as $vv){
						$str_fiev[]= "%,".$vv.",%";	
					}
					$where[$fiev]=array('like',$str_fiev,'OR');
					$search[$fiev]=I($fiev);
				}elseif(is_array(I($fiev.'_values'))){	//标签组件（关键字）
					$search[$fiev] = ','.implode(',', I($fiev.'_values')).',';
					$search[$fiev.'_type']=I($fiev.'_type');
					foreach(I($fiev.'_values') as $tagk=>$tagv){
						$ta_arr[]='%,'.$tagv.',%';
					}
					if(I($fiev.'_type')==1){	//其中含有
						$where[$fiev] =array('like',$ta_arr,'OR');
					}else{	//全部包含
						$where[$fiev] =array('like',$ta_arr,'AND');
					}	
				}
				else{
					if($search[$fiev] = I($fiev,'','trim,htmlspecialchars')){
						$where[$fiev] = array('like','%'.$search[$fiev].'%'); 
					}
				}
			}
			$this->assign('search',$search);
			unset($search,$ta_arr);
		}
		$where['isshow3'] = array('eq',1);//列表-条件
		$regfields = $this->getFields($where);//获取字段信息-列表
		$arr=$this->orderFields($regfields);//将字段数组重新整理-列表
		$field=array_merge($arr['field'],array('id','uid','username','addtime','status','reviewtime','depth','isshow'));
		$farr=$this->userInfo(cookie('uid'));//获取当前用户的信息
		$where['status']=array('neq',1);//非审核不通过
		$where['isshow']=array('eq',1);//审核通过
		$data = $this->_getLists($model,$where,$order,$field,$listRows=10,'Pages3',array('header'=>'<li style="border:none;">共%totalRows%条记录','pages'=>'%nowPage%/%totalPages%页　</li>','prev'=>'<上一页','next'=>'下一页>','first'=>'首页','last'=>'尾页','theme'=>'%header% %pages% %prePage% %linkPage% %nextPage% %end%'));
		$this->assign('list',$data['list']?$data['list']:array());//列表
		$colnum=count($arr['field']) + 4;	//列数
		$this->assign('colnum',$colnum);
		$this->assign('field',$arr['field']);	//列表字段
		$this->assign('regfields',$arr['new_regfields']);	//列表字段信息 键名为name
		$this->assign('page',$data['page']);	//分页
		$this->assign('p',$data['p']);	//当前页数
		$this->assign('page_title','资料检索');
		$this->assign('empty','<tr><td colspan='.$colnum.' style="padding-left:15px;font-size:14px;">暂无相关信息！</td></tr>');
		$this->display();
	}
/**
 * 资料填报列表
 */
	public function applylist(){
		$model = M('Apply');
		$where['uid'] = array('eq',cookie('uid'));
		$order = 'addtime desc';
		//搜索
		if($search['title'] = I('post.title','','trim,htmlspecialchars')){
			$where['title'] = array('like','%'.$search['title'].'%'); 
		}
		if(($search['status'] = I('post.status')) !== ''){
			$where['status'] = array('eq',intval($search['status'])); 
		}
		$this->assign('search',$search);
		$map['isshow1'] = array('eq',1);//列表
		$regfields = $this->getFields($map);//获取字段信息
		$arr=$this->orderFields($regfields);//将字段数组重新整理
		$colnum=count($arr['field']) + 4;	//列数
		$this->assign('colnum',$colnum);
		$this->assign('field',$arr['field']);	//字段(排序)
		$this->assign('regfields',$arr['new_regfields']);	//字段信息 键名为name
		$field=array_merge($arr['field'],array('id','uid','username','addtime','status','reviewtime','isshow','depth'));
		$data = $this->_getLists($model,$where,$order,$field,10,'Pages3',array('header'=>'<li style="border:none;">共%totalRows%条记录','pages'=>'%nowPage%/%totalPages%页　</li>','prev'=>'<上一页','next'=>'下一页>','first'=>'首页','last'=>'尾页','theme'=>'%header% %pages% %prePage% %linkPage% %nextPage% %end%'));
		$this->assign('list',$data['list']?$data['list']:array());	//列表
		$farr=$this->userInfo(cookie('uid'));//获取当前用户的信息
		$this->assign('dengji',$farr['dengji']);
		$this->assign('page',$data['page']);	//分页
		$this->assign('p',$data['p']);	//当前页数
		$this->assign('page_title','资料填报管理');
		$this->assign('empty','<tr><td colspan='.$colnum.' style="padding-left:15px;font-size:14px;">暂无相关信息！</td></tr>');		
		$this->display();
	}
/**
 * 新增资料填报
 */
	public function apply()
	{
		$model = D('Apply');
		$regfields = $this->getFields();//获取字段信息
		$arr=$this->orderFields($regfields);//将字段数组重新整理
		if($this->isPost()){	//提交申请
			$farr=$this->userInfo(cookie('uid'));//获取当前用户的信息
			$_POST['depth']=$farr['depth'];//用户的depth
			$_POST['isshow']=$this->recurIsshow(cookie('uid'));
			$tag_fields = $this->getFields(array('istags'=>array('eq',1)),'name,description,required');	//使用标签组件 并且是必填 字段
			$js_fields = $this->getFields(array('isjs'=>array('eq',1)),'name');
			//使用js地区组件
			foreach($js_fields as $jsk=>$jsv){
				if($_POST[$jsv['name']]){
					if($_POST[$jsv['name'].'2']){
						$_POST[$jsv['name']]=$_POST[$jsv['name']].'-'.$_POST[$jsv['name'].'2'];//国外地区
					}else{
						$_POST[$jsv['name']]=$_POST[$jsv['name']];
					}
				}
			}
			//两个字段任填写其一
			/*$two_one = array('source'=>'research');
			$this->checkTwoone($two_one);*/
			$rules=$this->getValidate(I('pptags',array()));	//自动验证
			if($model->validate($rules)->create()){
				$model = $this->checkTags($tag_fields,$model);	//对使用标签的必填字段进行判断，并修改model中的属性值
				$yy_arr=$this->getAuto($regfields,$_POST);	//将POST数组重新整理
				if($yy_arr){
					foreach($yy_arr as $yk => $yv){
						$model->$yk=$yv;
					}
				}
				if($model->add()){
					$this->success('资料填报成功',U('applylist'));
				}else{
					$this->error('资料填报失败');
				}
			}else{
				$this->error($model->getError());//自动验证弹框
			}	
		}else{
			$where['id'] = array('eq',$id);
			$strfield=implode(',',$$arr['field']);
			$data=$this->_getRow($model,$where,$strfield);
			$this->assign('data',$data);
			//dump($arr['new_regfields']);
			$this->assign('field',$arr['field']);	//字段(排序)
			$this->assign('regfields',$arr['new_regfields']);	//字段信息 键名为name
			$this->assign('page_title','新增资料填报');//页面标题
			$this->display();
		}
	}
/**
 * 对使用标签的必填字段进行判断，并修改model中的属性值
 * @param  array $fields [使用标签的必填字段]
 * @param  object $model  [create后的对象]
 * @return object
 */
	private function checkTags($fields,$model){
		if($fields && is_array($fields)){
			foreach($fields as $v){
				if(!I($v['name'].'_values') && $v['required']==1){
					$this->error($v['description'].'不能为空！');
				}elseif(I($v['name'].'_values')){
					$model->$v['name'] = ','.implode(',',I($v['name'].'_values')).',';
				}else{
					$model->$v['name'] = '';
				}
			}
		}
		return $model;
	}
/**
 * 资料填报判断 两个字段任填写其一即可
 * @param  array  $field [字段 字段1=>字段2]
 */
	private function checkTwoone($field=array()){
		$map['required']=array('eq',1);	//必填
		$info = $this->getFields($map);//获取字段信息
		if($info){
			$keys = array_keys($field);
			foreach($info as $k => $v){
				if(in_array($v['name'],$field)){
					continue;
				}
				if(in_array($v['name'],$keys)){	//字段名称在定义好的字段中
					if(!I($v['name'],'') && !I($fields[$v['name']],'')){
						$this->error($v['description'].'和'.$info[$fields[$v['name']]]['description'].'两个必须填写一个！');
					}
				}
			}
		}
		return $arr;
	}
/**
 * 递归获取用户审核状态
 * @param $uid 用户id
 */
	private function recurIsshow($uid){
		$farr=$this->userInfo($uid);//获取当前用户的信息
		//判断父类是否有审核
		if($farr['pid']){	//有父级用户
			$shenghe=M('Authgroupf')->where(array('grade'=>array('eq',$farr['dengji']-1)))->getField('isreview');
			if($shenghe){//如果有审核权限
				$back = $farr['dengji'];//当前用户的等级值
			}else{//无审核权限
				$back = $this->recurIsshow($farr['pid']);//判断父类
			}
		}else{
			$back = false;
		}
		if(!$back){ $back =1;}
		return $back;
	}
/**
 * 获取用户信息和等级值
 * @param $uid 用户id
 * @param $field 字段信息
 */
	private function userInfo($uid='',$field='id,pid,depth'){
		$arr=M('Webuser')->where('id='.$uid)->field($field)->find();
		$arr['dengji']=count(explode(',',$arr['depth']));//用户等级
		return($arr);
	}
/**
 * 修改资料填报
 */
	public function edit()
	{
		$model = D('Apply');
		$regfields = $this->getFields();//获取字段信息
		$arr=$this->orderFields($regfields);//将字段数组重新整理
		if($this->isPost()){	//提交申请
			$tag_fields = $this->getFields(array('istags'=>array('eq',1)),'name,description,required');	//使用标签组件 
			$js_fields = $this->getFields(array('isjs'=>array('eq',1)),'name');
			//使用js地区组件
			foreach($js_fields as $jsk=>$jsv){
				if($_POST[$jsv['name']]){
					if($_POST[$jsv['name'].'2']){
						$_POST[$jsv['name']]=$_POST[$jsv['name']].'-'.$_POST[$jsv['name'].'2'];//国外地区
					}else{
						$_POST[$jsv['name']]=$_POST[$jsv['name']];
					}
				}
			}
			//删除原附件信息
			foreach($regfields as $rk=>$rv){
				if($rv['upfile']){
					if($_POST[$rv['name']]){
						if($_POST[$rv['name']] != $_POST['old_'.$rv['name']])
						{

							$this->delFile2($_POST['old_'.$rv['name']]);//删除附件
						}
					}	
				}
			} 
			$rules=$this->getValidate(I('pptags',array()));	//自动验证
			if($model->validate($rules)->create()){
				$model = $this->checkTags($tag_fields,$model);	//对使用标签的必填字段进行判断，并修改model中的属性值
				$yy_arr=$this->getAuto($regfields,$_POST);	//将POST数组重新整理
				if($yy_arr){
					foreach($yy_arr as $yk => $yv){
						$model->$yk=$yv;
					}
				}
				if($model->save()){
					$this->success('修改成功',U('applylist'));
				}else{
					$this->error('修改失败');
				}
			}else{
				$this->error($model->getError());//自动验证弹框
			}	
		}else{
			if(I('id')){
				$id = I('id');
			}else{
				$id = 0;
			}
			$where['id'] = array('eq',$id);
			$arr['field'][]='status';
			$strfield = implode(',',$arr['field']);
			$data = $this->_getRow($model,$where,$strfield);
			$this->assign('data',$data);
			$this->assign('field',$arr['field']);	//字段(排序)
			$this->assign('regfields',$arr['new_regfields']);	//字段信息 键名为name
			$this->assign('page_title','资料修改');//页面标题
			$this->assign('id',$id);//数据id
			$this->display();
		}
		
	}
/**
 * 查看详情
 * @param $id 内容id
 * @param $page_title 页面标题
 */
	public function look()
	{
		if(I('id')){
			$id = I('id');
		}else{
			$id = 0;
		}
		$model = M('Apply');
		$where['id'] = array('eq',$id);
		$regfields = $this->getFields();//获取字段信息
		$arr=$this->orderFields($regfields);//将字段数组重新整理
		$arr['field'][]='status';
		$strfield = implode(',',$arr['field']);
		$data = $this->_getRow($model,$where,$strfield);
		//dump($regfields);
		$this->assign('data',$data);
		$this->assign('field',$arr['field']);	//字段(排序)
		$this->assign('regfields',$arr['new_regfields']);	//字段信息 键名为name
		$this->assign('page_title','资料预览');//页面标题
		$this->display();
	}

/**
 * 获取资料填报自动验证规则
 * @param  array $pptags [使用标签的文本框name]
 */
	private function getValidate($pptags=array()){
		$map['required']=array('eq',1);	//必填
		$info = $this->getFields($map);//获取字段信息
		if($info){
			foreach($info as $k => $v){
				if($v['type'] == 'bstring'){	//多行多列判断
					$arr[]=array($v['name'],'valReferee',$v['description'].'不完整，请确认！',1,'callback',3);
				}elseif($v['type'] == 'c_heckbox'){	//复选框
					$arr[]=array($v['name'],'valCheckbox',$v['description'].'不能为空！',1,'callback',3);
				}elseif($v['type'] == 'string'){
					if(!in_array($v['name'],$pptags)){	//文本型并且未使用标签组件
						$arr[]=array($v['name'],'require',$v['description'].'不能为空！',1,'',3);
					}
				}else{
					$arr[]=array($v['name'],'require',$v['description'].'不能为空！',1,'',3);
				}
			}
		}
		return $arr;
	}
/**
 * 获取资料填报自动填充规则
 * @param   $arr 字段信息数组
 * @param   $POST post获取的数组
 */
	private function getAuto($arr=array(''),$POST){
		if(!empty($arr) && !empty($POST)){
			foreach($arr as $v){
				if(is_array($POST[$v['name']])){
					if($v['type']=='bstring' && $v['id'])//多行多列
					{
						//去除空白数据的数组 start
						$arr=array_filter($POST[$v['name']]);
						foreach($arr as $mk=>$mv)
						{
							$mv=array_filter($mv);
							if(empty($mv))
							{	
								unset($arr[$mk]);
							}
						}
						$arr=array_values($arr);
						//去除空白数据的数组 end
						$string=json_encode($arr);
					}if($v['type']=='c_heckbox' && $v['id']){//复选框
						foreach($POST[$v['name']] as $kk => $vv){
							$string.=$string?$vv.',':','.$vv.',';
						}
					}	
					$row[$v['name']]=$string;	
					unset($string,$arr);				
				}
			}
		}else{
			return false;
		}
		return $row;
	}

/**
 * 获取字段的详细信息
 * @param  $where 字段表条件
 */
	public function getFields($where=array(),$field=''){
		//获取字段信息
		$where_field['isshow'] = array('eq',1);	//状态为开启的字段
		if($where){
			$where_field=array_merge($where_field,$where);
		}
		$m = M('Regfields')->where($where_field);
		if($field){
			$m = $m->field($field);
		}
		$file_info = $m->order('sort')->select();
		return $file_info;
	}
/**
 * 将字段数组重新整理排序
 * @param  $fieldarr 字段数组
 * @return array
 */
	public function orderFields($fieldarr){
		$field=array();	//sql 查询字段
		$new_regfields=array();	//fieldarr 键名为name
		if($fieldarr){
			foreach($fieldarr as $k => $v){
				$field[] = $v['name'];
				$new_regfields[$v['name']] = $v;
			}
		}
		$arr['field']=$field;
		$arr['new_regfields']=$new_regfields;
		return $arr;
	}




/**
 * 删除单个附件
 */
	private function delFile2($file)
	{
		if($file)
		{
			$file2=iconv('UTF-8','GB2312','.'.$file);//支持中文名文件
			if(file_exists($file2))
			{
				unlink($file2);
			}
		}
	}

/**
 * 获取资料审核字段信息 选取并提交至下载页
 */
	public function checkField(){
		$info=$this->getFields();	//字段信息 name名称 description注释
		$this->assign('info',$info);
		$arr=$this->orderFields($info);//将字段数组重新整理
		//搜索
		if($this->isPost()){
			foreach($arr['field'] as $fiev){
				if(is_array(I($fiev))){	//数组
					$str_fiev = array();
					foreach(I($fiev) as $vv){
						$str_fiev[]= "%,".$vv.",%";	
					}
					$where[$fiev]=array('like',$str_fiev,'OR');
					$search[$fiev]=I($fiev);
					unset($str_fiev);
				}else{
					if($search[$fiev] = I($fiev,'','trim,htmlspecialchars')){
						$where[$fiev] = array('like','%'.$search[$fiev].'%'); 
					}
				}
			}
			$this->assign('ppaction',I('ppaction',''));	//检索
			$this->assign('pp_search',base64_encode(json_encode($where)));
		}
		//end
		$this->assign('web_title','资料审核列表');
		$this->assign('action',I('action'));
		$this->assign('uid',$this->uid);
		$this->display();
	}

/**
 * 导出资料审核至excel表
 */
	public function download(){
		$filename='资料审核列表';
		set_time_limit(0);

		$action=I('action');
		$field=array_filter(I('field'));	//下载所需的字段
		$info=$this->getFields(array('name'=>array('in',$field)));	//下载所需字段
		if($info){
			foreach($info as $v){
				$new_field[]=$v['name'];
			}
		}
		if(I('ppaction','') == 'retrieval'){
			if($pp_search = I('pp_search','')){
				$where = json_decode(base64_decode($pp_search),true);
				$where['isshow']=array('eq',1);
			}
		}else{
			$userinfo = $this->getUserInfo(array('id'=>array('eq',cookie('uid'))),array('depth'));
			$depth = (int)count(explode(',', $userinfo['depth']));
			$where['isshow']=array('eq',$depth+1);	//管理员所选择的字段
		}
		$new_field[]='status';
		$new_field[]='depth';
		$new_field[]='isshow';
		
		$list=M('Apply')->field($new_field)->where($where)->select();	//符合条件的资料
		// echo M('Apply')->getLastSql();
		// exit;
		$filename.=date('_YmdHis');
		$filename = iconv('utf-8', 'gb2312', $filename);//文件名称
        vendor("PHPExcel.PHPExcel");
        $objPHPExcel = new PHPExcel();
        $count=count($info);	//导出字段数

        //创建文件并写入
        $name='./Uploads/excel/'.$filename.date('Ymd-His'). '.xls';  
    	$myfile = fopen($name, "w") or die("Unable to open file!");
		$str='<table width="100%" border="1" cellpadding="0" cellspacing="1">';
		$str.='<tr>';
		$str.='<td align="center">序号</td>';
		for($i=0;$i < $count;$i++){	//设置标题
			if($info['type'] == 'bstring'){	//多文本
				$str.='<td align="center">';
        		$row=$info['rownum']?$info['rownum']:1;
				$col=$info['colnum']?$info['colnum']:1;
				$r_width=100 / $col;
				$str.='<table border="1" cellpadding="0" cellspacing="1">';
				$str.='<tr><td align="center" colspan="'.$col.'">'.$info[$i]['description'].'</td></tr>';
				if($info['ctitle']){	//列标题
					$ctitle=explode('#',$info['ctitle']);
					$str.='<tr>';
					foreach($ctitle as $val){
						$str.='<td align="center" style="WORD-WRAP: break-word" width="'.$r_width.'%">'.$val.'</td>';
					}
					$str.='</tr>';
				}
				$str.='</table>';
				$str.='</td>';
			}else{
				$str.='<td align="center">'.$info[$i]['description'].'</td>';
			}
        }
        $str.='<td align="center">状态</td>';
		$str.='</tr>';
		fwrite($myfile, $str); 
		unset($str);
		if($list){
	        foreach($list as $k => $v){
	        	$str='<tr>';
	        	$str.='<td align="center">'.($k+1).'</td>';	//A列
	        	for($i=0;$i < $count;$i++){	//设置标题
		        	//多行文本、多选框、上传附件
		        	$f_info=$this->getFieldInfo($new_field[$i]);//name,type,rownum,colnum,ctitle,upfile
		        	// echo $f_info['name'].'——'.$f_info['type'],'<br/>';
		        	if($f_info['upfile'] == 1){	//图片
		        		if($v[$new_field[$i]])
		        			// $pp_val='<div><img src="http://'.$_SERVER['SERVER_NAME'].$v[$new_field[$i]].'" width="65" height="65" /></div>';
		        			$pp_val=$v[$new_field[$i]];
		        		else
		        			$pp_val='';
		        	}elseif($f_info['type'] == 'c_heckbox'){	//多选框
		        		$pp_val=substr($v[$new_field[$i]],0,-1);
		        		$pp_val=substr($pp_val,1);//截取前后，
		        	}elseif($f_info['type'] == 'bool'){	//多选框
		        		$pp_val=$v[$new_field[$i]] == 1?'是':'否';
		        	}elseif($f_info['type'] == 'bstring'){	//多文本
		        		$row=$f_info['rownum']?$f_info['rownum']:1;
						$col=$f_info['colnum']?$f_info['colnum']:1;
						$r_width=100 / $col;
						/*if($f_info['ctitle']){	//列标题
							$ctitle=explode('#',$f_info['ctitle']);
							$pp_val.='<tr>';
							foreach($ctitle as $val){
								$pp_val.='<td align="center" style="WORD-WRAP: break-word" width="'.$r_width.'%">'.$val.'</td>';
							}
							$pp_val.='</tr>';
						}*/
						if($v[$new_field[$i]]) $value=json_decode($v[$new_field[$i]],true);	//存在数据
						if($value){	//存在数值
							$pp_val='<table border="1" cellpadding="0" cellspacing="1">';
							/*for($ii=1;$ii<=$row;$ii++){	//行
								$pp_val.='<tr>';
								for($iii = 1;$iii<=$col;$iii++){	//列
									$pp_val.='<td align="center">'.$value[$ii][$iii].'</td>';
								}
								$pp_val.='</tr>';
							}*/
							foreach($value as $v1){
								$pp_val.='<tr>';
								foreach($v1 as $v2){
									$pp_val.='<td align="center" style="WORD-WRAP: break-word" width="'.$r_width.'%">'.$v2.'</td>';
								}
								$pp_val.='</tr>';
							}
							$pp_val.='</table>';
						}
						unset($row,$rol,$value,$r_width);
		        	}elseif($f_info['name'] == 'idnumber'){
		        		$pp_val='<div style="vnd.ms-excel.numberformat:@">'.$v[$new_field[$i]].'</div>';
		        	}else{
		        		$pp_val=$v[$new_field[$i]];
		        	}
		        	$str.='<td align="center">'.$pp_val.'</td>';
		        	unset($pp_val);
		        }
		        $zt='';
		        if($v['status']==1){
		        	$zt='审核不通过';
		        }elseif($v['isshow']==1){
		        	$zt='审核通过';
		        }else{
		        	$zt='未审核';
		        }
		        $str.='<td align="center">'.$zt.'</td>';	//状态
		        $str.='</tr>';
		       	fwrite($myfile, $str); 
		       	unset($str);
	        }
    	}
        $str='</table>';
        fwrite($myfile, $str); 
        unset($str);
        $name=iconv('gb2312', 'utf-8', $name);
       	echo '<script>window.location.href="'.$name.'";setTimeout("window.close()",300000)</script>';
		// ob_end_clean();//清除缓冲区,避免乱码
		/*header('Content-Type: application/vnd.ms-excel');
		header('Content-Disposition: attachment;filename='.$filename.'.xls');
		$str=iconv('utf-8', 'gbk', $str);
		echo $str;*/
	}
	/**
 * 获取字段详细信息
 * @param  string $name  字段名
 * @param  string $field 查询field
 * @return array
 */
	private function getFieldInfo($name,$field='name,type,rownum,colnum,ctitle,upfile'){	//type:文本string,多行文本bstring,布尔bool,数字number,文本域t_extarea,下拉列表s_elect,多选框c_heckbox,单选r_adio
		$where['name']=array('eq',$name);
		$data=M('Regfields')->where($where)->field($field)->find();
		return $data;
	}

}