admin1/Home/Controller/OwnerCompareController.class.php.bak

<?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();
        $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(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();
        }



    }
}