...."; // echo $_SESSION['idphone']; $Data = I(''); $Map['company']=$Data['companyid']; $Map['clzt']=0; $ResData=M()->query("select count(a.id) as wcls from sp_video2017 as a join sp_owner as b on b.owner_code=a.device_code where b.company='".$Map['company']."' and a.clzt=".$Map['clzt']); // $ResData=M('v_sj2017_2')->where($Map)->count('id'); // $ResData = indexOne($company); $this->assign('wjcn',$ResData[0]['wcls']); $this->assign('companyid',$Data['companyid']); $this->display('Index/video_system'); } public function change() { $Data=I(''); $page = $Data['page']; $size = 20; $startpage=($page - 1) * 20; $Map['company']=$Data['companyid']; switch ($Data['type']) { case 'untreated': $Map['clzt']=0; $ResData=M()->query("select a.id,a.device_code,a.data4,a.clzt,a.time,d.owner_name from sp_video2017 a join sp_owner d ON a.device_code=d.owner_code where d.company=".$Map['company']." AND a.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.data4,a.clzt,a.time,d.owner_name from sp_video2017 a join sp_owner d ON a.device_code=d.owner_code where d.company=".$Map['company']." AND a.clzt=".$Map['clzt']." order by a.id desc limit ".$startpage.",".$size); break; default: $ResData=M()->query("select a.id,a.device_code,a.data4,a.clzt,a.time,d.owner_name from sp_video2017 a join sp_owner d ON a.device_code=d.owner_code where d.company=".$Map['company']." order by a.id desc limit ".$startpage.",".$size); break; } echo json_encode($ResData); // $this->assign('ResData',$ResData); // $this->display('Index/video-list'); } } ?>