123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151 |
- <?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();
- $res=$Model->where('owner_code='.$Data['id'])->delete();
- if($res)
- $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){
- $res=M('owner_share')->where("owner_code = {$Data['unitId']}")->save($data);
- }
- }
- if($httpCode == 200)
- $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();
- }
- }
|