where($Map)->count(); $List=M('owner_compare as o') ->join('sp_owner as p on o.device_id=p.owner_code') // ->join('sp_owner_company as c on p.company=c.owner_id') ->limit($Page,$GetSize) ->field('o.device_id,o.bao_id,p.owner_name,p.company') ->where($Map) ->select(); $list2 =array(); foreach ($List as $key=>$value){ $Company=M('owner_company')->where('owner_id = '.$value['company'])->select(); $list2[$key]['owner_code'] = $value['device_id']; $list2[$key]['organization_name'] = $value['bao_id']; $list2[$key]['category_name'] = $value['owner_name']; $list2[$key]['provider_name'] = $Company['0']['owner_name']; // $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_compare'); $Data=I(); if (session('power')==2){ $this->mtReturn(300,'本账号没有该权限,如需开通请联系管理员',1); }else { $res=$Model->where('device_id='.$Data['id'])->delete(); if($res) $this->mtReturn(200,'删除成功'.$Data['id']); else $this->mtReturn(300,'删除失败'); } } public function owner_edit(){ $Data=I(); if (session('power')==2){ $this->mtReturn(300,'本账号没有该权限,如需开通请联系管理员',1); }else { if(IS_POST) { $Tab=M('owner_compare'); if ($Data['category']){ $Data1['bao_id']=$Data['category']; $res=$Tab->where('device_id='.$Data['unitId'])->save($Data1); } if($res) $this->mtReturn(200,'修改成功'); else $this->mtReturn(300,'修改失败'); }else{ $bao=M('owner_compare as o') ->join('sp_owner as p on o.device_id=p.owner_code') // ->join('sp_owner_company as c on p.company=c.owner_id') ->field('o.device_id,o.bao_id,p.owner_name,p.company') ->where('device_id='.$Data['code']) ->select(); foreach ($bao as $key=>$value){ $Company=M('owner_company')->where('owner_id = '.$value['company'])->select(); $list2['device_id'] = $value['device_id']; $list2['bao_id'] = $value['bao_id']; $list2['owner_name'] = $value['owner_name']; $list2['company_name'] = $Company['0']['owner_name']; } $this->assign('list2',$list2); $this->assign('code',$Data['code']); $this->assign('action','/home/OwnerCompare/owner_edit'); //print_r($info); } $this->display(); } } public function add(){ if (IS_POST) { $Tab=M('owner_compare'); // $rules = array( // array('phone','','电话号码重复!',0,'unique'), // ); // if (!$Tab->validate($rules)->create()) // { // // echo json_encode(array('statusCode'=>'300','message'=> $menu->getError())); // $this->mtReturn(300,$Tab->getError()); // } // else // { $Data=I(); if(strlen($Data['device_id']) < 1){ $this->mtReturn(300,'请填写完整的原设备ID'); } if(strlen($Data['bao_id']) < 1){ $this->mtReturn(300,'请填写完整的宝山设备ID'); } $res = $Tab->add($Data); if($res) $this->mtReturn(200,'新增成功'); else $this->mtReturn(300,'新增失败'); // } } else { $this->assign('action','/home/OwnerCompare/add'); $this->display(); } } }