admin1/Home/View/Controlpanel/FaceController.class.php

<?php
/**
 * Created by PhpStorm.
 * User: TianFeng
 * Date: 2018-09-17
 * Time: 16:58
 */

namespace Home\Controller;
use Think\Controller;
class FaceController extends ComController{
    
    public function index(){
      $Data=I();
    if(isset($Data['list'])){  
      $ModelList=M("owner");
      $GetPage=$Data['pageCurrent'];//第几页
      $GetSize=$Data['pageSize'];//每页条数
      $Gage=($GetPage-1)*$GetSize;
      $Map=array();
      if(!empty($Data['owner_name'])){
        $Map['sp_owner.owner_name']=array('like','%'.$Data['owner_name'].'%');
      }
        if(!empty($Data['owner_name1'])){
        $Map['sp_owner_company.owner_name']=array('like','%'.$Data['owner_name1'].'%');
      }
//权限
        if($_SESSION['zt_username']!='admin' && $_SESSION['zt_username']!='zj')
        {
          $por=$this->getdevice();
          if(count($por)>0){
                //$por=array('10000001','10000000')
                    if(!empty($Data['owner_code'])){
                        $p="";
                        foreach ($por as $val) {
                            $p.="'".$val."',";
                        }
                        $p.="'www'";
                        $Map['_string']=" (owner_code in(".$p.")) AND (owner_code LIKE '%".$Data['owner_code']."%') ";
                    }else{
                       $Map['owner_code']=array('in',$por); 
                    }
            

          }else{
            $Map['owner_code']='xxx';
          }
        }else{
                if(!empty($Data['owner_code'])){
                    $Map['owner_code']=array('like','%'.$Data['owner_code'].'%');
                }
            }
    
      $Count= $ModelList->join("left join __OWNER_COMPANY__ ON owner_id=company")->where($Map)->count();// 查询满足要求的总记录数
      $ListData = $ModelList->field('sp_owner.id,owner_code,sp_owner.owner_name,sim,addr1,unitinfo,addr2,addr3,address,posistion,install_time,install_man,sp_owner_company.owner_name as owner_name1')
      ->where($Map)->where("dwtype=10")->order('id desc')->join("left join __OWNER_COMPANY__ ON owner_id=company")->limit($Gage,$GetSize)->select();
            // s_print($ListData);die;
          $InfoList = array(
                  'totalRow' => $Count,
                  //'pageSize' => $count,//分页时不传
                  'list'     => $ListData,
                 );
          echo json_encode($InfoList);
      }
      else
      {
        $this->display();
      } 
       
    }

  public function getdevice(){
        $por=M()->query("SELECT owner_code FROM sp_owner WHERE install_man='".$_SESSION['zt_username']."' or company IN(SELECT owner_code FROM sp_owner_weibao WHERE agentid='".$_SESSION['zt_username']."');");
        $arr=array();
        foreach ($por as $value) {
            $arr[]=$value['owner_code'];
        }
        return $arr;
    }

    public function add(){
      if (IS_POST) {
        $data=I();
        $owner=M('owner');
        //查看设备号是否存在
        $rest= $owner->where(array('owner_code'=> $data['owner_code']))->select();
        if(count($rest) < 1){//
            $data['dwtype']=10;
            $data['install_man']=$_SESSION['zt_username'];
            $data['install_time']=date('Y-m-d H:i:s');   
            $res = $owner->add($data);    

              if($res){
                                $tab='x';
                                //if($data['dwtype'] != '6'){//dwtype
                                    $tab=$owner->execute("CALL device_table('".$data['owner_code']."','".$data['dwtype']."')");
                                //}
                                $status=$owner->execute("INSERT INTO sp_devices_status(deviceid,deviceno,devicestatus,statustime) VALUES('".$data['owner_code']."','','',NOW())");

                echo json_encode(array('statusCode'=> 200,'message'=>'添加成功'));
              }else{
                  echo json_encode(array('statusCode'=> 300,'message'=>'添加失败'));
              } 
        }else{
          echo json_encode(array('statusCode'=> 300,'message'=>'未添加成功，请确认是否已经添加'));
        }
      }else{
        $this->assign('action','/home/Face/add');
        $company=M('owner_company')->select();
        $this->assign('companylist',$company);
        $this->display();       
      }
	 

    }

    public function edit(){
      
       $this->display();
    }

    public function delete(){
      
    }
}