where($Map)->count(); $List=M('owner_share as o') ->join('sp_share_provider as p on o.share_id=p.share_id') ->join('sp_share_category as c on o.category_code=c.category_code') ->join('sp_share_organization as r on o.organization_id=r.organization_id') ->limit($Page,$GetSize) ->field('o.owner_code,o.enabled,o.ports,o.iotype,o.append_time,p.provider_name,c.category_name,r.organization_name') ->where($Map) ->select(); $list2 =array(); foreach ($List as $key=>$value){ $list2[$key]['append_time'] = $value['append_time']; $list2[$key]['enabled'] = $value['enabled']; $list2[$key]['ports'] = $value['ports']; $list2[$key]['iotype'] = $value['iotype']; $list2[$key]['organization_name'] = $value['organization_name']; $list2[$key]['category_name'] = $value['category_name']; $list2[$key]['provider_name'] = $value['provider_name']; $list2[$key]['owner_code'] = $value['owner_code']; } $Info = array( 'totalRow' => $Count, 'list' => $list2, ); echo json_encode($Info); } else { $this->display(); } } public function deldata(){ $Model=M('owner_share'); $Data=I(); if (session('power')==2){ $this->mtReturn(300,'本账号没有该权限,如需开通请联系管理员',1); }else { $used_data = M()->query("select * from sp_owner_share where owner_code=".$Data['id']); $res=$Model->where('owner_code='.$Data['id'])->delete(); 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_share表---设备编号:'.$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); //日志开始结束 $this->mtReturn(200,'删除成功'.$Data['id']); }else{ $this->mtReturn(300,'删除失败'); } } } public function share_edit(){ $Data=I(); $Tab=M('owner_share as o'); if(IS_POST) { if ($Data['ports']!=='0'){ $provider_id=$Data['provider']; $share=M('share_provider')->where("provider_id = '$provider_id'")->find(); $owner_code=$Data['unitId'].'-'.$Data['ports']; $data2['owner_code']=$Data['unitId']; $data2['share_id']=$share['share_id']; $data2['category_code']=$Data['category']; $data2['organization_id']=1; $data2['enabled']=1; $data2['ports']=$Data['ports']; $data2['iotype']=$Data['iotype']; $data2['append_time']=date('Y-m-d H:i:s'); $data2['updata_time']=date('Y-m-d H:i:s'); $res1= M('owner_share')->add($data2); if ($Data['iotype']=='2'){ $ports=16+(int)($Data['ports']); $data1['unitId']=$Data['unitId'].'-'.$ports; }else{ $data1['unitId']=$owner_code; } }else{ $data1['unitId']=$Data['unitId']; } $data1['provider']=$Data['provider']; $data1['category']=$Data['category']; $post_data=json_encode($data1 ); $post_url=$Data['organization']; $ch = curl_init();//初始化 curl_setopt($ch, CURLOPT_TIMEOUT, '30');//超时时间 curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json; charset=utf-8', 'Content-Length: ' . strlen($post_data))) ; curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); //curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB7.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)'); curl_setopt($ch, CURLOPT_POST,1); curl_setopt($ch, CURLOPT_URL,$post_url); curl_setopt($ch, CURLOPT_POSTFIELDS,$post_data); $contents = curl_exec($ch); $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE); if(curl_errno($ch)){//出错则显示错误信息 print curl_error($ch); } curl_close($ch); if($httpCode == 200){ $data['enabled']=1; if($Data['provider']=='OOGuxw0JVti5xtsWoEczQQ=='){ $data['share_id']=1; }else{ $data['share_id']=2; } if ($Data['organization']){ $data['organization_id']=1; } $owner_code=$Data['unitId'].'-'.$Data['ports']; $data['category_code']=$Data['category']; $data['updata_time']=date('Y-m-d H:i:s'); if ($Data['ports']==0){ $wx=M()->query("SELECT * FROM sp_owner where owner_code='".$Data['unitId']."'"); $res=M('owner_share')->where("owner_code = {$Data['unitId']}")->save($data); } } if($httpCode == 200){ //日志代码开始 $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号:'.session('phone_login').'---修改sp_owner表---设备编号:'.$Data['unitId']."数据\r\n"; $data_log1 ='修改前数据:'.json_encode($wx)."\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); //日志代码结束 $this->mtReturn(200,'共享成功'); }else{ $this->mtReturn(300,'共享失败'); } }else{ // $where['owner_code'] = $Data['code']; // $info = $Tab // ->join('sp_share_provider as p on o.share_id=p.share_id') // ->join('sp_share_category as c on o.category_id=c.category_id') // ->where($where) // ->find(); $category=M('share_category')->where('category_id > 0')->select(); $organization=M('share_organization')->where('organization_id > 0')->select(); $this->assign('organization',$organization); $this->assign('category',$category); $this->assign('code',$Data['code']); $this->assign('action','/home/ShareData/share_edit'); //print_r($info); } $this->display(); } }