select(); }else{ $devices=M()->query("SELECT * FROM sp_face WHERE install_man='".$_SESSION['zt_username']."' or company IN(SELECT owner_code FROM sp_owner_weibao WHERE agentid='".$_SESSION['zt_username']."');"); } //dump($devices); $this->assign('devices',$devices); $this->assign('companylist',$company); $this->display(); } //获取到改用户所在的单位所能看到的所有设备 public function getdevice(){ $por=M()->query("SELECT * FROM sp_face 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(); $face=M('face'); $video=M('video'); //验证数据 if(empty($data['owner_code'])||empty($data['owner_name'])||empty($data['face_id'])||empty($data['road'])||empty($data['maliu'])||empty($data['rtmp'])||empty($data['hls'])){ echo json_encode(array('statusCode'=> 300,'message'=>'请填写好必要信息')); } //查看设备号是否存在 $rest= $video->where(array('owner_code'=> $data['owner_code']))->select(); if(count($rest) < 1){// $faces= $face->where(array('id'=> $data['face_id']))->find(); $data['company']=$faces['company']; $data['addtime']=date('Y-m-d H:i:s'); $res = $video->add($data); if($res){ echo json_encode(array('statusCode'=> 200,'message'=>'添加成功')); }else{ echo json_encode(array('statusCode'=> 300,'message'=>'添加失败')); } }else{ echo json_encode(array('statusCode'=> 300,'message'=>'未添加成功,请确认改设备id是否已经添加')); } }else{ $this->assign('action','/home/video/add'); $face=M('face')->select(); $this->assign('face',$face); $this->display(); } } public function edit(){ $video=M('video'); $face=M('face'); $data=I(); if (IS_POST) { //验证数据 if(empty($data['owner_code'])||empty($data['owner_name'])||empty($data['face_id'])||empty($data['road'])||empty($data['maliu'])||empty($data['rtmp'])||empty($data['hls'])){ echo json_encode(array('statusCode'=> 300,'message'=>'请填写好必要信息')); } $faces= $face->where(array('id'=> $data['face_id']))->find(); $data['company']=$faces['company']; $data['addtime']=date('Y-m-d H:i:s'); $res = $video->where(array('id'=> $data['id']))->save($data); if($res){ echo json_encode(array('statusCode'=> 200,'message'=>'编辑成功')); }else{ echo json_encode(array('statusCode'=> 300,'message'=>'编辑失败')); } }else{ $Ownerlist= $video->where(array('id'=> $data['id']))->find(); $this->assign('Ownerlist',$Ownerlist); $this->assign('action','/home/video/edit'); $face=M('face')->select(); $this->assign('face',$face); $this->display(); } } public function video(){ $this->display(); } }