admin1/Home/Controller/CompanyController.class.php

<?php
namespace Home\Controller;
use Think\Controller;
class CompanyController extends ComController {
  public function index(){
    	$Data=I();
    	if(isset($Data['list'])){
    	$Company=M("owner_company");
    	$GetPage=$Data['pageCurrent'];//第几页
			$GetSize=$Data['pageSize'];//每页条数
			$Page=($GetPage-1)*$GetSize;

      if($_SESSION['zt_username']!='admin'&&$_SESSION['zt_username']!='zj'){
          $por=$this->getowner();
          //file_put_contents("/var/www/html/log/log.txt",print_r($por,true), FILE_APPEND);
          if(count($por)>0){
                //$por=array('10000001','10000000')
                    if(!empty($Data['owner_id'])){
                        $p="";
                        foreach ($por as $val) {
                            $p.="'".$val."',";
                        }
                        $p.="'www'";
                        $Map['_string']=" (owner_id in(".$p.")) AND (owner_id LIKE '%".$Data['owner_id']."%') ";
                    }else{
                       $Map['owner_id']=array('in',$por); 
                    }
          }else{
            $Map['owner_id']='xxx';
          }
        }else{
                if(!empty($Data['owner_id'])){
                    $Map['owner_id']=array('like','%'.$Data['owner_id'].'%');
                }
            }

			
			if(!empty($Data['owner_name'])){
			  $Map['owner_name']=array('like','%'.$Data['owner_name'].'%');
			  		}
			if(!empty($Data['owner_address'])){
			  $Map['owner_address']=array('like','%'.$Data['owner_address'].'%');
			  		}  		  		
			  	$Count= $Company->where($Map)->count();// 查询满足要求的总记录数
			  	$List = $Company->where($Map)->limit($Page,$GetSize)->order('id desc')->select();
  	  	$Info = array(
          'totalRow' => $Count,
          //'pageSize' => $count,//分页时不传
          'list'     => $List,
      	 );
      	echo json_encode($Info);
      	}else{
         $this->display();
       	}
  }	
  public function getowner(){
      //sp_user表 username=agentid
      //$por=M('owner_weibao')->field('owner_code')->where(array('agentid'=>$_SESSION['zt_username']))->select();
      $por=M('owner_weibao')->query("SELECT owner_code FROM sp_owner_weibao WHERE agentid='".$_SESSION['zt_username']."'
			UNION
			(SELECT owner_id FROM sp_owner_company WHERE create_man='".$_SESSION['zt_username']."')");
      $arr=array();
      foreach ($por as $value) {
        $arr[]=$value['owner_code'];
      }
      return $arr;
    }
  public function add(){
    $Data=I();
    if(!empty($Data['owner_name'])){
      $id=M()->query("SELECT id+10000 as id FROM sp_owner_company order by id desc limit 1");
        if(count($id)>0){
          $Data['owner_id']=$id[0]['id'];
        }else{
          $Data['owner_id']=10001;
        }
      $Data['create_man']=$_SESSION['zt_username'];
      $Company=M("owner_company")->where("owner_name != '".$Data['owner_name']."'")->add($Data);
      
      if($Company>0){
          //日志开始
          $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
          $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---添加设备\r\n';
          $data_log1 ='添加数据：'.json_encode($Data)."\r\n";
          file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
          file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
          //日志结束
          echo json_encode(array('statusCode'=> 200,'message'=>'添加成功'));
      }else{
          echo json_encode(array('statusCode'=> 300,'message'=>'未添加成功，请确认名称是否已经添加'));
      }
    }else{
      $build=M('building')->field('id,build_name')->select();
      $this->assign('build',$build);
      $this->display();
    }
    
  }
  public function edit(){
      if (session('power')==2){
          $this->mtReturn(300,'本账号没有该权限，如需开通请联系管理员',1);
      }else{
    $Data=I();
    switch ($Data['type']) {
        case 'edit':
            //company
        	$build=M('building')->field('id,build_name')->select();
      		$this->assign('build',$build);
            $Company=M("owner_company")->where(array('id'=>$Data['id']))->select();
            $this->assign('list',$Company[0]);
            //$this->display();
            
            //lian xi ren
            $wx=M()->query("SELECT phone,idphone,openid, username FROM sp_wx_customuser  WHERE  type='wx' ORDER BY idphone asc");
            $this->assign('weixin',$wx);

            $lian=M('owner_phone')->where(array('owner_code'=>$Company[0]['owner_id']))->order('time asc')->select();//
            $this->assign('lianlist',$lian);
            //weibao
            $User=M('user')->select();
            $this->assign('weibao',$User);
            $weibao=M('owner_weibao')->query("SELECT w.id as id,w.owner_code as owner_code ,truename,w.datetime FROM sp_owner_weibao w left JOIN sp_user u on w.agentid=u.agentid where w.owner_code='".$Company[0]['owner_id']."'");//
            $this->assign('weibaolist',$weibao);

            //fujin 单位
            $fujin=M("owner_company")->select();
            $this->assign('fujinselect',$fujin);

            $fujinlist=M("owner_company")->query("SELECT f.id, f.owner_code,f.other_code,owner_name,unitinfo,address FROM sp_owner_fujin f LEFT JOIN sp_owner o ON f.other_code=o.owner_code where f.owner_code='".$Company[0]['owner_id']."'");
            $this->assign('fujinlist',$fujinlist);


            $this->assign('action','/home/Company/edit');
            $this->assign('company_code_uid',$Company[0]['owner_id']);
            $this->display();
          break;
        case 'savacompany':
              $used_data=M()->query("select * from sp_owner_company where id=".$Data['saveid']);
              $Company=M("owner_company")->where(array('id'=>$Data['saveid']))->save($Data);
              if($Company>0){
                  //日志代码开始
                  $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---修改sp_owner_company表---ID：'.$Data['saveid']."数据\r\n";
                  $data_log1 ='修改前数据：'.json_encode($used_data)."\r\n";
                  $data_log2 ='修改的数据：'.json_encode($Data)."\r\n";
                  $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                  file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                  file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                  file_put_contents($filename_log, $data_log2, FILE_APPEND|LOCK_EX);
                  //日志代码结束
                  echo json_encode(array('statusCode'=> 200,'message'=>'编辑成功'));
              }else{
                  echo json_encode(array('statusCode'=> 300,'message'=>'编辑失败，请确认是否有内容更新'));
              }
          break;
        case 'addlian':
          $perm=M()->query(" select data2 FROM sp_owner_phone where phone='".$Data['idphone']."' limit 1 ");
          $data2='1,2,3,4';
          if(!empty($perm[0]['data2'])){
            $data2=$perm[0]['data2'];
          }
          $wx=M()->query("SELECT phone,idphone,openid, username FROM sp_wx_customuser  WHERE  type='wx' AND idphone='".$Data['idphone']."'");
          $lian=M('owner_phone');
          if(count($wx)>0){
            if ($wx[0]['username']==null) {
              $wx[0]['username']='';
            }
          $res=$lian->add(array('owner_code'=>$Data['owner_code'],'username'=>$wx[0]['username'],'phone'=>$Data['idphone'],'time'=>date('Y-m-d H:i:s'),'data1'=>$wx[0]['openid'],'data2'=>$data2));
            $new_data = array('owner_code'=>$Data['owner_code'],'username'=>$wx[0]['username'],'phone'=>$Data['idphone'],'time'=>date('Y-m-d H:i:s'),'data1'=>$wx[0]['openid'],'data2'=>$data2);
          }else{
            $res=$lian->add(array('owner_code'=>$Data['owner_code'],'username'=>'','phone'=>'','time'=>date('Y-m-d H:i:s'),'data1'=>'','data2'=>$data2));
            $new_data = array('owner_code'=>$Data['owner_code'],'username'=>'','phone'=>'','time'=>date('Y-m-d H:i:s'),'data1'=>'','data2'=>$data2);
          }
          $ress=$lian->where(array('id'=>$res))->select();

            //日志开始
            $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
            $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---添加\r\n';
            $data_log1 ='添加数据：'.json_encode($new_data)."\r\n";
            file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
            file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
            //日志结束
          echo json_encode($ress[0]);
          break;
        case 'sevalian':
            $used_data=M()->query("select * from sp_owner_phone where id=".$Data['lianid']);
            $res=M('owner_phone')->where(array('id'=>$Data['lianid']))->save($Data);

            //日志开始
            $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
            $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---修改sp_owner_phone表---ID：'.$Data['lianid']."\r\n";
            $data_log1 ='修改前数据：'.json_encode($used_data)."\r\n";
            $data_log2 ='修改的数据：'.json_encode($Data)."\r\n";
            file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
            file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
            file_put_contents($filename_log, $data_log2, FILE_APPEND|LOCK_EX);
            //日志结束

            echo $res;
          break;
        case 'addweibao':
          $weibao=M('owner_weibao');
          $res=$weibao->add(array('agentid'=>$Data['username'],'owner_code'=>$Data['owner_code']));
          $list=$weibao->query("SELECT w.id as id, w.owner_code as owner_code ,truename,w.datetime FROM sp_owner_weibao w left JOIN sp_user u on w.agentid=u.agentid where w.id='".$res."'");
            $new_data=array('agentid'=>$Data['username'],'owner_code'=>$Data['owner_code']);
            //日志开始
            $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
            $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---添加\r\n';
            $data_log1 ='添加数据：'.json_encode($new_data)."\r\n";
            file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
            file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
            //日志结束

          // if ($res) {
          //  $this->mtReturn(200,'添加成功');
          // }else{
          //  $this->mtReturn(200,'添加失败');
          // }
          echo json_encode($list[0]);
          break;
        case 'addfujin':
          $fujin=M('owner_fujin');
          $res=$fujin->add(array('other_code'=>$Data['myownercode'],'owner_code'=>$Data['owner_code']));
          $fujinlist=$fujin->query("SELECT f.id,f.owner_code,f.other_code,o.owner_name,o.owner_address,o.owner_man FROM sp_owner_fujin f LEFT JOIN sp_owner_company o ON f.other_code=o.owner_id where f.id='".$res."'");
            $new_data=array('other_code'=>$Data['myownercode'],'owner_code'=>$Data['owner_code']);
            //日志开始
            $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
            $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---添加\r\n';
            $data_log1 ='添加数据：'.json_encode($new_data)."\r\n";
            file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
            file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
            //日志结束
          
          // if ($res) {
          //  $this->mtReturn(200,'添加成功');
          // }else{
          //  $this->mtReturn(200,'添加失败');
          // }
          echo json_encode($fujinlist[0]);
          break;
        default:
          # code...
          break;
      }
      }
  }
  
  public function del(){
    $Data=I();
    if(!empty($Data['id'])){
       $Company=M("owner_company")->where(array('id'=>$Data['id']))->delete();
      if($Company>0){
          echo json_encode(array('statusCode'=> 200,'message'=>'删除成功'));
      }else{
          echo json_encode(array('statusCode'=> 300,'message'=>'删除失败'));
      }
    }else{
      echo json_encode(array('statusCode'=> 300,'message'=>'删除失败'));
    }
  }

	//
	public function Dellian(){
	      $data=I();
	      if(!empty($data['id'])){
	        $device=M('owner_phone');
              $used_data = M()->query("select * from sp_owner_phone where id=".$data['id']);
	        $res = $device->delete($data['id']);
	        if($res){
                //日志开始
                $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
                $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---删除sp_owner_weibao表---ID：'.$data['id']."\r\n";
                $data_log1 ='删除前数据：'.json_encode($used_data)."\r\n";
                file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
                file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
                //日志开始结束
	        echo json_encode($this->mtReturn(200,'删除成功'));  
	      }else{
	          echo json_encode(array('statusCode'=> 300,'message'=>'删除失败'));
	        }
	      }
	    }
	
	//
	public function Delwei(){
	  $data=I();
	  if(!empty($data['id'])){
	    $device=M('owner_weibao');
          $used_data = M()->query("select * from sp_owner_weibao where id=".$data['id']);
	    $res = $device->delete($data['id']);
	    if($res){
            //日志开始
            $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
            $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---删除sp_owner_weibao表---ID：'.$data['id']."\r\n";
            $data_log1 ='删除前数据：'.json_encode($used_data)."\r\n";
            file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
            file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
            //日志开始结束
	    echo json_encode($this->mtReturn(200,'删除成功'));  
	  }else{
	      echo json_encode(array('statusCode'=> 300,'message'=>'删除失败'));
	    }
	  }
	}
//
    public function Delfujin(){
      $data=I();
      if(!empty($data['id'])){
        $device=M('owner_fujin');
        $used_data = M()->query("select * from sp_owner_fujin  where  id=".$data['id']);
        $res = $device->delete($data['id']);
        if($res){
            //日志开始
            $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
            $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---删除sp_owner_fujin表---ID：'.$data['id']."\r\n";
            $data_log1 ='删除前数据：'.json_encode($used_data)."\r\n";
            file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
            file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
            //日志开始结束


        echo json_encode($this->mtReturn(200,'删除成功'));  
      }else{
          echo json_encode(array('statusCode'=> 300,'message'=>'删除失败'));
        }
      }
    }

public function downdata(){//导出Excel
          $Data=I();
          $Company=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'];
					  		}  		
  	      $expTableData =$Company->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); 
    }     	
 	
    	
}