VideoMonitoringController.class.php 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. <?php
  2. namespace Home\Controller;
  3. use Think\Controller;
  4. class VideoMonitoringController extends ComController{
  5. public function index()
  6. {
  7. $Data=I('');
  8. $Map['company']=$Data['companyid'];
  9. $ResData1=M()->query("SELECT count(*) as sl FROM sp_owner WHERE company=".$Map['company']." and dwtype=16");
  10. $ResData2=M()->query("SELECT owner_code,owner_name FROM sp_owner WHERE company='".$Map['company']."' and dwtype=16");
  11. // print_r("SELECT owner_code,owner_name FROM sp_owner WHERE company='".$Map['company']."' and dwtype=16");
  12. $this->assign('sl',$ResData1[0]['sl']);
  13. $this->assign('sblist',$ResData2);
  14. $this->assign('companyid',$Data['companyid']);
  15. $this->display('Index/video_monitoring-list');
  16. }
  17. public function change()
  18. {
  19. $Data=I('');
  20. $device=$Data['device'];
  21. $device=$Data['device'];
  22. // print_r($device);
  23. $this->assign('device',$device);
  24. $ResData=M()->query("SELECT company FROM sp_owner WHERE owner_code='".$device."'");
  25. $this->assign('companyid',$ResData[0]['company']);
  26. // echo $device;
  27. // echo '0000000';
  28. $this->display('Index/video_monitoring');
  29. }
  30. public function index2(){
  31. $Data=I('');
  32. $Map['company']=$Data['companyid'];
  33. $ResData2=M()->query("SELECT owner_code,owner_name FROM sp_owner WHERE company='".$Map['company']."' and dwtype=16");
  34. //print_r("SELECT owner_code,owner_name FROM sp_owner WHERE company='".$Map['company']."' and dwtype=16");
  35. //print_r($ResData2);
  36. $arr=array();
  37. foreach($ResData2 as $key => $value){
  38. $arr[$key]=$ResData2[$key]['owner_code'];
  39. }
  40. // print_r($arr);
  41. //$this->assign('sblist',$ResData2);
  42. $this->assign('arr1',$arr);
  43. $this->assign('companyid',$Data['companyid']);
  44. $this->display('Index/video_monitoring-list-x');
  45. }
  46. }
  47. ?>