wxapp2/Home/Controller/VideoAlarmController.class.php.bak.2022-01-27

<?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('');
        $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 clzt=".$Map['clzt']." order by a.id desc limit 1000");
                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 clzt=".$Map['clzt']." order by a.id desc limit 1000");
                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 1000");
                break;
        }
        $this->assign('ResData',$ResData);
        $this->display('Index/video-list');
    }
}

?>