BuildController.class.php 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  1. <?php
  2. namespace Home\Controller;
  3. use Think\Controller;
  4. class BuildController extends ComController {
  5. public function _initialize() {
  6. parent::_initialize();
  7. $this->dbname ='building';
  8. }
  9. public function index(){
  10. $Data=I();
  11. if(isset($Data['list'])){
  12. $ModelList=M("building");
  13. $GetPage=$Data['pageCurrent'];//第几页
  14. $GetSize=$Data['pageSize'];//每页条数
  15. $Gage=($GetPage-1)*$GetSize;
  16. $Map=array();
  17. if(!empty($Data['build_name']))
  18. {
  19. $Map['build_name']=array('like','%'.$Data['build_name'].'%');
  20. }
  21. if( session('zt_username')!='admin'&&session('zt_username')!='zj' )
  22. {
  23. $por=$this->getbuild();
  24. $Map['id']=array('in',$por);
  25. if(empty($por))
  26. {
  27. $Map['id']='';
  28. }
  29. //file_put_contents("/var/www/html/log/log.txt",print_r($por,true), FILE_APPEND);
  30. }
  31. $Count= $ModelList->where($Map)->count();// 查询满足要求的总记录数
  32. $ListData = $ModelList->field('id,build_name,addr1,addr2,addr3,address,add_time,add_man')->where($Map)->order('id desc')->limit($Gage,$GetSize)->select();
  33. $InfoList = array(
  34. 'totalRow' => $Count,
  35. //'pageSize' => $count,//分页时不传
  36. 'list' => $ListData,
  37. );
  38. echo json_encode($InfoList);
  39. }
  40. else
  41. {
  42. $this->display();
  43. }
  44. }
  45. public function getbuild(){
  46. $build=M()->query("
  47. SELECT building_id FROM sp_owner_company WHERE owner_id in(SELECT owner_code FROM sp_owner_weibao WHERE agentid='".$_SESSION['zt_username']."')
  48. UNION
  49. SELECT id as building_id FROM sp_building WHERE add_man='".$_SESSION['zt_username']."'");
  50. $arr=array();
  51. foreach ($build as $value) {
  52. $arr[]=$value['building_id'];
  53. }
  54. return $arr;
  55. }
  56. /**
  57. * 检查新增前的action
  58. * @assign role array 返回页面参数(角色信息)
  59. * @assign group array 返回页面参数(部门信息)
  60. * @assign action string 返回页面参数(提交时的动作)
  61. */
  62. public function _befor_add(){
  63. $this->assign('action','/home/Build/add');
  64. }
  65. /**
  66. * 检查新增时需要编辑的字段
  67. * @param data array 页面提交的数据源,包含post|get
  68. * @return array 编辑后的数据源
  69. */
  70. public function _befor_insert($Data){
  71. $Count=M("building")->where(array('build_name'=>$Data['build_name']))->count();
  72. if ($Count==1)
  73. {
  74. $this->mtReturn(300,'建筑物名称已存在!');
  75. }
  76. $Data['add_man']=session('zt_username');
  77. $Data['add_time']=date('Y-m-d H:i:s');
  78. return $Data;
  79. }
  80. public function edit(){
  81. if (session('power')==2){
  82. $this->mtReturn(300,'本账号没有该权限,如需开通请联系管理员',1);
  83. }else {
  84. $data = I();
  85. switch ($data['type']) {
  86. case 'owner':
  87. $Owner = M('building');
  88. $list = $Owner->where(array('id' => $data['id']))->select();//二维数组
  89. $this->assign('Ownerlist', $list[0]);
  90. $this->assign('action', '/home/Build/edit');
  91. $this->assign('owner_code_uid', $data['owner_code']);
  92. $this->display();
  93. break;
  94. case 'savaowner':
  95. $owner = M('building');
  96. if (!empty($data['ownerid'])) {
  97. $wx=M()->query("SELECT * FROM sp_building where id=".$data['ownerid']);
  98. $res = $owner->where(array('id' => $data['ownerid']))->save($data);
  99. if ($res) {
  100. //日志代码开始
  101. $data_log ="\r\n".'['.date("Y-m-d H:i:s").']操作人员手机号:'.session('phone_login').'---修改sp_building表---ID:'.$data['ownerid']."数据\r\n";
  102. $data_log1 ='修改前数据:'.json_encode($wx)."\r\n";
  103. $data_log2 ='修改的数据:'.json_encode($data)."\r\n";
  104. $filename_log = "/var/www/html/jdxf/log/config_log".date("Y-m-d").".log";
  105. file_put_contents($filename_log, $data_log, FILE_APPEND|LOCK_EX);
  106. file_put_contents($filename_log, $data_log1, FILE_APPEND|LOCK_EX);
  107. file_put_contents($filename_log, $data_log2, FILE_APPEND|LOCK_EX);
  108. //日志代码结束
  109. $this->mtReturn(200, '配置成功');
  110. } else {
  111. echo json_encode(array('statusCode' => 300, 'message' => '配置未改变'));
  112. }
  113. }
  114. break;
  115. default:
  116. $this->mtReturn(300, '打开失败联系管理员!');
  117. break;
  118. }
  119. }
  120. }
  121. public function del(){
  122. $data=I();
  123. if(!empty($data['id'])){
  124. $device=M('owner_device');
  125. $res = $device->delete($data['id']);
  126. if($res){
  127. echo json_encode($this->mtReturn(200,'删除成功'));
  128. }else{
  129. echo json_encode(array('statusCode'=> 300,'message'=>'删除失败'));
  130. }
  131. }
  132. }
  133. }