admin1/Home/Controller/UserController.class.php.bak.20200601

<?php
namespace Home\Controller;
use Think\Controller;
class UserController extends ComController {
      
    public function _initialize() {
        parent::_initialize();
        $this->dbname ='User';
    }


public function index(){
    	$Data=I();
    	$Group=M('auth_group');
    	if(isset($Data['list'])){
    	$UserVIew=M("v_user");
    	$GetPage=$Data['pageCurrent'];//第几页
			$GetSize=$Data['pageSize'];//每页条数
			$Page=($GetPage-1)*$GetSize;
			 $Map['status']=1;
			if(!empty($Data['username'])){
			  $Map['username']=$Data['username'];
			  		}
			if(!empty($Data['truename'])){
			  $Map['truename']=$Data['truename'];
			  		}
			if(!empty($Data['depname'])){
			  $Map['depname']=$Data['depname'];
			  		}
			if(!empty($Data['posname'])){
			  $Map['posname']=$Data['posname'];
			  		} 
			  $permdata=$this->permdata();  
	      if (!empty($permdata))
	       {
	          $Map['addman']=$permdata;
	       } 		  		
			  	$Count= $UserVIew->where($Map)->count();// 查询满足要求的总记录数
			  	$List = $UserVIew->field("id,username,truename,agentid,depname,posname,phone,email,address,extension")->where($Map)
			  	->limit($Page,$GetSize)->select();
	  	$Info = array(
        'totalRow' => $Count,
        //'pageSize' => $count,//分页时不传
        'list'     => $List,
    	 );
    	echo json_encode($Info);
    	}else{
    	   $List1 = $Group->field('id,title,pid')->where('type=1')->select();
    	   $List2 = $Group->field('id,title,pid')->where('type=0')->select();
    	   $this->assign('role',$List1);
    	   $this->assign('group',$List2);	
         $this->display();
     	}
    
    	}

  //登陆历史
public function history(){
    $Data=I();
    $Group=M('auth_group');
    if(isset($Data['list'])){
        $UserVIew=M("log_iteration");
        $GetPage=$Data['pageCurrent'];//第几页
        $GetSize=$Data['pageSize'];//每页条数
        $Page=($GetPage-1)*$GetSize;
        $Map['status']=1;
        if(!empty($Data['username'])){
            $Map['username']=$Data['username'];
        }

        $Count= $UserVIew->where($Map)->count();// 查询满足要求的总记录数
        $List = $UserVIew->field("id,addtime,username,content,os,ip,error_count,success_count,type,address")->where($Map)
            ->limit($Page,$GetSize)->order('id desc')->select();
        $Info = array(
            'totalRow' => $Count,
            //'pageSize' => $count,//分页时不传
            'list'     => $List,
        );
        echo json_encode($Info);
    }else{
        $List1 = $Group->field('id,title,pid')->where('type=1')->select();
        $List2 = $Group->field('id,title,pid')->where('type=0')->select();
        $this->assign('role',$List1);
        $this->assign('group',$List2);
        $this->display();
    }



}
 /**
      * 检查新增前的action
      * @assign role array      返回页面参数（角色信息）
      * @assign group array     返回页面参数（部门信息）
      * @assign action string   返回页面参数（提交时的动作）
     */
 public function _befor_add(){
 	       $Group=M('auth_group');  
		     $map['type']=1;
		     $Map['type']=0;
           $List1 = $Group->field('id,title,pid')->where($map)->select();
    	   $List2 = $Group->field('id,title,pid')->where($Map)->select();
    	   $this->assign('role',$List1);
    	   $this->assign('group',$List2);
    	   $this->assign('action','/home/user/add');

  } 
 /**
      * 检查新增时需要编辑的字段
      * @param data array  页面提交的数据源，包含post|get
      * @return array      编辑后的数据源
     */  	
public function _befor_insert($Data){
	       $Group=M('auth_group');
				 $RegId = $Group->field('id')->where(array('title'=> $Data['posname']))->select();
				 $DepId = $Group->field('id')->where(array('title'=> $Data['depname']))->select();
				 $Data['posname']=$RegId[0]['id'];
				 $Data['depname']=$DepId[0]['id'];
				 $Data['password']=md5(md5(I('password')));
				 $Data['ctime']=date('Y-m-d H:i:s',time());
				 $Data['agentid']=$Data['username'];
				 $Data['addman']=session('zt_username');
				 return $Data;
				}

 /**
      * 检查编辑前的action
      * @assign role array        返回页面参数（角色信息）
      * @assign group array       返回页面参数（部门信息）
      * @assign Userlist string   返回页面参数（当前id的用户信息）
      * @assign id  int           返回页面参数（当前id）
      * @assign action string     返回页面参数（提交时的动作）
     */				
public  function _befor_edit(){
  	     $Group=M('auth_group');
   	     $Res=M("v_user")->where(array('id'=> I('id')))->select();
		     $map['type']=1;
		     $Map['type']=0;
		     $Map['id']=array('in',explode(',',$this->groupdata(session('jd_depname')).session('jd_depname')));
			   $map['id']=array('in',explode(',',$this->groupdata(session('jd_posname')).session('jd_posname')));
         $List1 = $Group->field('id,title,pid')->where($map)->select();
    	   $List2 = $Group->field('id,title,pid')->where($Map)->select();
    	   // echo $list1;
    	   $this->assign('role',$List1);
    	   $this->assign('group',$List2);
    	   $this->assign('Userlist',$Res[0]);
    	   $this->assign('id',I('id'));
    	   $this->assign('action','/home/user/edit');
   	     } 
 /**
      * 检查编辑时需要编辑的字段
      * @param data array  页面提交的数据源，包含post|get
      * @return array      编辑后的数据源
     */   	     
public  function _befor_save($Data){
	       if(empty($Data['id'])){
	      	 	$this->mtReturn(300,'获取id失败'); 
 	  	     }
	      if($Data['id']==1){
	      	 	$this->mtReturn(300,'不可编辑超级管理员'); 
 	  	    }
  	    $Reid=M('auth_group')->field('id')->where(array('title'=> $Data['posname']))->select();
  	    $DepId =M('auth_group')->field('id')->where(array('title'=> $Data['depname']))->select();
			  $Data['posname']=$Reid[0]['id'];
			  $Data['depname']=$DepId[0]['id'];
			  if (strlen(I('password'))!==32){
	          $PassWord=md5(md5(I('password')));
	          $Data['password']=$PassWord;
	         }
			  unset($Data['username']);
			  return $Data;
  	 
  	} 	
 /**
      * 检查删除时需要编辑的字段
      * @param data array  页面提交的数据源，包含post|get
      * @return array      返回相应的信息
     */   	
public function _befor_del($Data){
 	  if($Data['id']==1){
 	  	$this->mtReturn(300,'超级管理员不能删除'); 
 	  	}
 	  else if($Data['id']==session('zt_uid')){
 	  	$this->mtReturn(300,'不能删除自己'); 
 	  	}	
 	}  		
public function downdata(){//导出Excel
           $Data=I();
           $UserVIew=M("v_user");
		       $Map['status']=1;
					if(!empty($Data['username'])){
					  $Map['username']=$Data['username'];
					  		}
					if(!empty($Data['truename'])){
					  $Map['truename']=$Data['truename'];
					  		}
					if(!empty($Data['depname'])){
					  $Map['depname']=$Data['depname'];
					  		}
					if(!empty($Data['posname'])){
					  $Map['posname']=$Data['posname'];
					  		} 
					 $permdata=$this->permdata();  
		      if (!empty($permdata))
		       {
		          $Map['addman']=$permdata;
		       }  		
	      $expTableData =$UserVIew->field("username,truename,extension,agentid,depname,posname,phone,email,address")->where($Map)->select();
		    $expCellName=array('登录名','姓名','分机号','座席号','所在部门','担任角色','联系电话','电子邮箱','地址');
		    $expTitle='用户信息';
        $this->exportExcel($expTitle,$expCellName,$expTableData);		  
        // echo json_encode($expTableData); 
    }     	



    	
}