Unit.php 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\ChangeLog;
  4. use app\BaseController;
  5. use think\App;
  6. use think\facade\Db;
  7. class Unit extends BaseController
  8. {
  9. public $post ="";
  10. public function __construct(App $app)
  11. {
  12. parent::__construct($app);
  13. $this->post=$this->request->post();
  14. }
  15. public function create(){
  16. $unit = isset($this->post['unit']) && $this->post['unit'] !==""? trim($this->post['unit']):"";
  17. if($unit==""){
  18. return error_show(1002,"参数unit不能为空");
  19. }
  20. $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):"";
  21. if($token==''){
  22. return error_show(105,"参数token不能为空");
  23. }
  24. $user =GetUserInfo($token);
  25. if(empty($user)||$user['code']!=0){
  26. return error_show(1002,"创建人数据不存在");
  27. }
  28. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  29. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  30. $status = isset($this->post['status']) &&$this->post['status'] !==""? intval($this->post['status']):"1";
  31. $data=[
  32. "unit"=>$unit,
  33. "creater"=>$creater,
  34. "createrid"=>$createrid,
  35. "status"=>$status,
  36. "is_del"=>0,
  37. "addtime"=>date("Y-m-d H:i:s"),
  38. "updatetime"=>date("Y-m-d H:i:s")
  39. ];
  40. $info = Db::name("unit")->insert($data);
  41. if($info){
  42. return error_show(0,"新建成功");
  43. }else{
  44. return error_show(1002,"新建失败");
  45. }
  46. }
  47. public function list(){
  48. $page = isset($this->post['page']) && $this->post['page'] !==""? intval($this->post['page']):"1";
  49. $size = isset($this->post['size']) && $this->post['size'] !=="" ? intval($this->post['size']):"10";
  50. $where=[["is_del","=",0]];
  51. $unit = isset($this->post['unit']) && $this->post['unit'] !=="" ? trim($this->post['unit']):"";
  52. if($unit!==""){
  53. $where[]=['unit',"like","%$unit%"];
  54. }
  55. $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status'])
  56. :"";
  57. if($status!==""){
  58. $where[]=['status',"=",$status];
  59. }
  60. $creater = isset($this->post['creater']) && $this->post['creater'] !=="" ? trim($this->post['creater']):"";
  61. if($creater!=""){
  62. $where[]=['creater',"like","%$creater%"];
  63. }
  64. $start = isset($this->post['start']) && $this->post['start']!=="" ? $this->post['start']:"";
  65. if($start!==""){
  66. // $where[]=['addtime',">=",date('Y-m-d H:i:s')];//,strtotime($start)
  67. $where[]=['addtime',">=",$start];
  68. }
  69. $end = isset($this->post['end']) && $this->post['end']!=="" ? $this->post['end']:"";
  70. if($end!==""){
  71. // $where[]=['addtime',"<",date('Y-m-d H:i:s')];//,strtotime($end)+24*3600
  72. $where[]=['addtime',"<=",$end];
  73. }
  74. $count = Db::name('unit') ->where($where)->count();
  75. $total = ceil($count / $size);
  76. $page = $page >= $total ? $total : $page;
  77. $list = Db::name('unit')->where($where)->page($page,$size)->order("addtime desc")->select();
  78. return app_show(0,"获取成功",['list'=>$list,'count'=>$count]);
  79. }
  80. public function edit(){
  81. $id = isset($this->post['id']) && $this->post['id'] !==""? intval($this->post['id']):"";
  82. if($id==""){
  83. return error_show(1002,"参数id不能为空");
  84. }
  85. $info = Db::name('unit')->where(['id'=>$id,'is_del'=>0])->find();
  86. if($info==""){
  87. return error_show(1003,"未找到数据");
  88. }
  89. if($info['status']==1){
  90. return error_show(1002,"状态是启用状态,无法编辑");
  91. }
  92. $unit = isset($this->post['unit']) && $this->post['unit'] !==""? trim($this->post['unit']):"";
  93. if($unit==""){
  94. return error_show(1002,"参数unit不能为空");
  95. }
  96. // $token = isset($this->post['token'])&&$this->post['token']!='' ? trim($this->post['token']):"";
  97. // if($token==''){
  98. // return error_show(105,"参数token不能为空");
  99. // }
  100. // $user =GetUserInfo($token);
  101. // if(empty($user)||$user['code']!=0){
  102. // return error_show(1002,"创建人数据不存在");
  103. // }
  104. // $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  105. // $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  106. $status = isset($this->post['status']) &&$this->post['status'] !==""? intval($this->post['status']):"0";
  107. $data=[
  108. "id"=>$id,
  109. "unit"=>$unit,
  110. // "creater"=>$creater,
  111. // "createrid"=>$createrid,
  112. // "status"=>$status,
  113. "is_del"=>0,
  114. "updatetime"=>date("Y-m-d H:i:s")
  115. ];
  116. $datainfo = Db::name('unit')->save($data);
  117. $item = array_diff($data,$info);
  118. $json = json_encode($item,JSON_UNESCAPED_UNICODE);
  119. $jsp = json_encode($info,JSON_UNESCAPED_UNICODE);
  120. if($datainfo){
  121. ChangeLog::logAdd(4,$info['id'],$jsp,$json,$this->post['token'],$this->post);
  122. return error_show(0,"更新成功");
  123. }else{
  124. return error_show(1002,"更新失败");
  125. }
  126. }
  127. public function del(){
  128. $id = $this->post['id'] && $this->post['id'] !=="" ? intval($this->post['id']) :"";
  129. if($id===""){
  130. return error_show(1004,"参数id不能为空");
  131. }
  132. $str= Db::name('unit')->where(['id'=>$id,'is_del'=>0])->find();
  133. if(empty($str)){
  134. return error_show(1002,"未找到数据");
  135. }
  136. $end = Db::name('unit')->update(['id'=>$id,'is_del'=>1]);
  137. if($end){
  138. return error_show(0,"删除成功");
  139. }else{
  140. return error_show(1002,"删除失败");
  141. }
  142. }
  143. public function status(){
  144. $id = isset($this->post['id']) && $this->post['id'] !==""? intval($this->post['id']):"";
  145. if($id==""){
  146. return error_show(1002,"参数id不能为空");
  147. }
  148. $info = Db::name("unit")->where([["id","=",$id],["is_del","=",0]])->find();
  149. if(!$info){
  150. return error_show(1002,"未找到对应数据");
  151. }
  152. $status = isset($this->post['status']) && $this->post['status']!==""? intval($this->post['status']):"";
  153. if($status===""){
  154. return error_show(1002,"参数status不能为空");
  155. }
  156. if(!in_array($status,[0,1])){
  157. return error_show(1002,"参数status无效");
  158. }
  159. $info['status']=$status;
  160. $info['updatetime']=date("Y-m-d H:i:s");
  161. $msg = $status==1?"启用":"禁用";
  162. $update = Db::name("unit")->save($info);
  163. return $update? error_show(0,"{$msg}成功"):error_show(1004,"{$msg}失败");
  164. }
  165. }