admin1/Home/Controller/OwnerCompareController.class.php

<?php
namespace Home\Controller;
use Think\Controller;
class OwnerCompareController 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['device_id']=$Data['owner_code'];
            }


            //明天 連貫操作sp_owner
            $Count=M('owner_compare')->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 {
            $used_data = M()->query("select * from sp_owner_compare where device_id=".$Data['id']);
            $res=$Model->where('device_id='.$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_compare表---设备编号：'.$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 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'];
                    $wx=M()->query("SELECT * FROM sp_owner_compare where device_id='".$Data['unitId']."'");
                    $res=$Tab->where('device_id='.$Data['unitId'])->save($Data1);
                }
                if($res){
                    //日志代码开始
                    $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号：'.session('phone_login').'---修改sp_owner_compare表---设备编号：'.$Data['unitId']."数据\r\n";
                    $data_log1 ='修改前数据：'.json_encode($wx)."\r\n";
                    $data_log2 ='修改的数据：'.json_encode($Data1)."\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{

                $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){
                //日志开始
                $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').'---新增宝山用传设备ID配置 \r\n';
                $data_log1 ='添加数据：'.json_encode($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,'新增成功');
            }else{
                $this->mtReturn(300,'新增失败');
            }


            // }

        }
        else
        {
            $this->assign('action','/home/OwnerCompare/add');
            $this->display();
        }



    }
}