wxapp2/Home/Controller/GateMagnetismController.class.php

<?php
namespace Home\Controller;
use Think\Controller;
class GateMagnetismController extends ComController{
	
	
	public function index()
    {  
        $Data=I('');
        $ResData=M()->query("SELECT count(*) FROM sp_door2020 a JOIN sp_owner b ON device_code=owner_code WHERE b.company=".$Data['companyid']." AND b.dwtype=130 and clzt=0;");
		$this->assign('mcsl',$ResData);
     	$this->assign('companyid',$Data['companyid']);
        $this->display('Index/gate_magnetism_system');
    }


	public function change()
    {
        $Data=I('');
		$Map['company']=$Data['companyid'];
        $page = $Data['page'];
        $size = 20;
        $startpage=($page - 1) * 20;
		 switch ($Data['type']) 
		     {
		     	case 'untreated':
					$Map['clzt']=0;
                    $ResData=M()->query("select a.id,a.device_code,a.data1,a.clzt,a.time,d.owner_name from sp_door2020 a join sp_owner d ON a.device_code=d.owner_code where company=".$Map['company']." AND clzt=".$Map['clzt']." order by a.time desc limit ".$startpage.",".$size);
		     		break;
			    case 'treated':
					$Map['clzt']=1;
                    $ResData=M()->query("select a.id,a.device_code,a.data1,a.clzt,a.time,d.owner_name from sp_door2020 a join sp_owner d ON a.device_code=d.owner_code where company=".$Map['company']." AND clzt=".$Map['clzt']." order by a.time desc limit ".$startpage.",".$size);
		     		break;		
		     	default:
                    $ResData=M()->query("select a.id,a.device_code,a.data1,a.clzt,a.time,d.owner_name from sp_door2020 a join sp_owner d ON a.device_code=d.owner_code where company=".$Map['company']." order by a.time desc limit ".$startpage.",".$size);//." and data1!='EF9'"
		     		break;
		     }

		 foreach ($ResData as $key=>$value){
             if ($ResData[$key]['data1']=='DS01'){
                 $ResData[$key]['wtype']='门窗开启';
             }elseif ($ResData[$key]['data1']=='DS02'){
                 $ResData[$key]['wtype']='门窗关闭';
             }elseif ($ResData[$key]['data1']=='DS03'){
                 $ResData[$key]['wtype']='电池电量低';
             }
         }
//        $ResData[0]['totalCount'] = count($ResData);
        echo json_encode($ResData);
//		$this->assign('ResData',$ResData);
//        $this->display('Index/gate_magnetism-list');
    }
	 

}

?>