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(''); $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.time desc"); 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.time desc"); 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.time desc");//." 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超高'; // } } $this->assign('ResData',$ResData); // s_print($ResData); $this->display('Index/efire-list'); } } ?>