wxapp2/Home/Controller/VideoAlarmController.class.php

<?php
namespace Home\Controller;
use Think\Controller;
include '../Common/function.php';
class VideoAlarmController extends ComController{
public function index()
     {  
// echo $_SESSION['phone'];
// echo "<br/>....";
// 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');
    }
}

?>