MaintController.class.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. <?php
  2. namespace Home\Controller;
  3. use Think\Controller;
  4. class MaintController extends ComController {
  5. public function index()
  6. { $Data=I();
  7. $this->assign('phone',$Data['phone']);
  8. $this->assign('companyid',$Data['companyid']);
  9. $this->display('Maint/device_manger');
  10. }
  11. public function change()
  12. {
  13. $Data=I('');
  14. $Map['sp_monitor.company']=$Data['companyid'];
  15. switch ($Data['type'])
  16. {
  17. case 'fire':
  18. $Map['sp_monitor.dwtype']=1;
  19. break;
  20. case 'water':
  21. $Map['sp_monitor.dwtype']=array('in','2,5');
  22. break;
  23. case 'fume':
  24. $Map['sp_monitor.dwtype']=3;
  25. break;
  26. case 'rtu':
  27. $Map['sp_monitor.dwtype']=6;
  28. break;
  29. case 'efire':
  30. $Map['sp_monitor.dwtype']=7;
  31. break;
  32. default:
  33. break;
  34. }
  35. $count=M('monitor')->where($Map)->count();
  36. $this->assign('count',$count);
  37. $this->assign('phone',$Data['phone']);
  38. $this->assign('companyid',$Data['companyid']);
  39. $this->assign('type',$Data['type']);
  40. //print_r($Map);
  41. //$ResData=M('monitor')->field('sp_maint_info.status,sp_monitor.*,sp_maint_info.datetime')->join('left join sp_maint_info ON sp_monitor.owner_code = sp_maint_info.owner_code')->where($Map)->select();
  42. $ResData=M('monitor')->where($Map)->select();
  43. //echo M('monitor')->getLastSql();
  44. //$this->assign('ResData1',$ResData1);
  45. $this->assign('ResData',$ResData);
  46. $this->display('Maint/dmanger-list');
  47. }
  48. public function setform()
  49. {
  50. $Data=I();
  51. $ownid="";
  52. $ownsta="";
  53. $num=0;
  54. foreach($Data[status]as $key=>$value){
  55. $ownid.="$key,";
  56. $ownsta.="$value,";
  57. $num+=1;
  58. }
  59. $ownid=substr($ownid,0,strlen($ownid)-1);
  60. $ownsta=substr($ownsta,0,strlen($ownsta)-1);
  61. $this->assign('ownid',$ownid);
  62. $this->assign('ownsta',$ownsta);
  63. $this->assign('count',$num);
  64. $this->assign('type',$Data['type']);
  65. $this->assign('editor',$Data['phone']);
  66. $ownids = explode(',',$Data[ownids]);
  67. $ownidsta = explode(',',$Data[ownidsta]);
  68. $ownstatus=array_combine($ownids,$ownidsta);
  69. $time=date('Y-m-d h:i:s',time());
  70. if($Data['companyid']){
  71. $ResData=M('owner_company')->where("owner_id=$Data[companyid]")->find();
  72. }
  73. $this->assign('owner_id',$ResData['owner_id']);
  74. $this->assign('owner_name',$ResData['owner_name']);
  75. $this->assign('address',$ResData['owner_address']);
  76. $sql="insert into sp_maint_info(owner_code,company,type,status,datetime,qianming,editor,comp_name,owner_address) values ";
  77. foreach($ownstatus as $key=>$value){
  78. $sql.="('$key','$Data[owner_id]','$Data[types]','$value','$time','$Data[qianming]','$Data[editors]','$Data[owner_name]','$Data[owner_address]');";
  79. }
  80. $sql=substr($sql,0,strlen($sql)-1).";";
  81. //echo $sql;
  82. if($Data[ownids]){
  83. if(strlen($Data[qianming]) > 1){
  84. if($Data[ownids]>0){
  85. $val=M()->execute($sql);
  86. if($val){
  87. echo "<script>window.history.go(-2);</script>";
  88. }else{
  89. $this->error('提交失败');
  90. }
  91. }else{
  92. $this->error('请选择设备');
  93. }
  94. }else{
  95. $this->error('请进行签名');
  96. }
  97. }
  98. $this->display('Maint/setform');
  99. }
  100. public function maintlist()
  101. { $Data=I();
  102. $Map['sp_maint_info.type']=$Data['type'];
  103. $Map['sp_maint_info.company']=$Data['compangid'];
  104. $counts=M('maint_info')->where($Map)->count();
  105. //echo $counts;
  106. $ResData=M('maint_info')->where($Map)->order("datetime desc")->select();
  107. //echo M('maint_info')->getLastSql();
  108. $this->assign('ResData',$ResData);
  109. $this->assign('counts',$counts);
  110. $this->assign('count',$Data['count']);
  111. $this->assign('type',$Data['type']);
  112. $this->assign('companyid',$Data['compangid']);
  113. $this->display('Maint/maint-list');
  114. }
  115. }
  116. ?>