wxapp2/Home/Controller/EfireController.class.php

<?php
namespace Home\Controller;
use Think\Controller;
class EfireController extends ComController{
	
	
	public function index()
    {  
        $Data=I('');
		$Map['company']=$Data['companyid'];
		$Map['clzt']=0;
//		print_r($Map);
//		$ResData=M('v_efire2018')->where($Map)->order('time desc')->count('id');
        $ResData=M()->query("SELECT count(*) FROM sp_ef2017 a JOIN sp_owner b ON device_code=owner_code WHERE b.company=".$Map['company']." AND b.dwtype=7 and clzt=0;");
//        print_r($ResData);
//        $ResData=M('ef2017')->where($Map)->order('time desc')->count('id');
		$this->assign('wjcn',$ResData);
     	$this->assign('companyid',$Data['companyid']);
        $this->display('Index/efire_system');
    }


	public function change()
    {
        $Data=I('');
        $page = $Data['page'];
        $size = 20;
        $startpage=($page - 1) * 20;
		$Map['company']=$Data['companyid'];
//		print_r($Data);
		 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_ef2017 a join sp_owner d ON a.device_code=d.owner_code where company=".$Map['company']." AND clzt=".$Map['clzt']." order by a.id 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_ef2017 a join sp_owner d ON a.device_code=d.owner_code where company=".$Map['company']." AND clzt=".$Map['clzt']." order by a.id 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_ef2017 a join sp_owner d ON a.device_code=d.owner_code where company=".$Map['company']." order by a.id desc  limit ".$startpage.",".$size);//." and data1!='EF9'"
		     		break;
		     }

//	    $ResData=M('v_ef2017')->where($Map)->order('time desc')->select();
//        print_r($ResData);
		 foreach ($ResData as $key=>$value){
//		     if ($ResData[$key]['data1']!='EF9'){
//                 $ResData[$key]['wtype']='在线';
//             }elseif ($ResData[$key]['data1']=='EF9'){
//                 $ResData[$key]['wtype']='离线';
//             }
             if ($ResData[$key]['data1']=='EF1'){
                 $ResData[$key]['wtype']='欠压报警';
             }elseif ($ResData[$key]['data1']=='EF2'){
                 $ResData[$key]['wtype']='过压报警';
             }elseif ($ResData[$key]['data1']=='EF3'){
                 $ResData[$key]['wtype']='过流报警';
             }elseif ($ResData[$key]['data1']=='EF4'){
                 $ResData[$key]['wtype']='漏电报警';
             }elseif ($ResData[$key]['data1']=='EF5'){
                 $ResData[$key]['wtype']='回路1温度超限报警';
             }elseif ($ResData[$key]['data1']=='EF6'){
                 $ResData[$key]['wtype']='回路2温度超限报警';
             }elseif ($ResData[$key]['data1']=='EF7'){
                 $ResData[$key]['wtype']='回路3温度超限报警';
             }elseif ($ResData[$key]['data1']=='EF9'){
                 $ResData[$key]['wtype']='离线';
             }

//             elseif ($ResData[$key]['data1']=='EF8'){
//                 $ResData[$key]['wtype']='温度4超高';
//             }
         }
        echo json_encode($ResData);
//		$this->assign('ResData',$ResData);
////		s_print($ResData);
//        $this->display('Index/efire-list');
    }
	 

}

?>