admin1/Home/Controller/ShareDataController.class.php

<?php
namespace Home\Controller;
use Think\Controller;
class ShareDataController extends ComController {
    public function index(){
        $Data=I();
        if(isset($Data['list'])){

            $GetPage=$Data['pageCurrent'];//第几页
            $GetSize=$Data['pageSize'];//每页条数
            $Page=($GetPage-1)*$GetSize;
            $Map=array();
            if(!empty($Data['owner_code'])){
                $Map['owner_code']=$Data['owner_code'];
            }


            //明天 連貫操作sp_owner
            $Count=M('owner_share')->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();
    }
}