Attr.php 6.0 KB

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