Userdongtai.php 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. /**
  6. * 普通动态
  7. */
  8. class Userdongtai extends Api
  9. {
  10. protected $noNeedLogin = ['info','floor_info'];
  11. protected $noNeedRight = ['*'];
  12. //首页动态列表
  13. public function dongtai_list(){
  14. $map = [
  15. // 'goodnum'=>['gt',100],
  16. 'is_hidden' => 0, //仅自己可见:1=是,0=否
  17. ];
  18. $list = Db::name('user_dongtai')->alias('dt')
  19. ->join('user','dt.user_id = user.id','LEFT')
  20. ->field('dt.*,user.nickname,user.avatar')
  21. ->where($map)
  22. ->order('dt.id desc')->autopage()->select();
  23. $list = list_domain_image($list,['images','avatar']);
  24. if(!empty($list)){
  25. foreach($list as $key => $val){
  26. $list[$key]['is_good'] = $this->is_good($val['id'],$this->auth->id);
  27. }
  28. }
  29. $this->success('success',$list);
  30. }
  31. //发布动态
  32. public function addone(){
  33. $content = input('content','');
  34. $images = input('images','');
  35. if(!$content && !$images){
  36. $this->error(__('Invalid parameters'));
  37. }
  38. $data = [
  39. 'user_id' => $this->auth->id,
  40. 'content' => $content,
  41. 'images' => $images,
  42. 'longitude' => input('longitude',''),
  43. 'latitude' => input('latitude',''),
  44. 'createtime' => time(),
  45. 'updatetime' => time(),
  46. ];
  47. $id = Db::name('user_dongtai')->insertGetId($data);
  48. $this->success('success',$id);
  49. }
  50. //自己看列表
  51. public function my_lists(){
  52. $list = Db::name('user_dongtai')->alias('dt')
  53. ->join('user','dt.user_id = user.id','LEFT')
  54. ->field('dt.*,user.nickname,user.avatar')
  55. ->where('dt.user_id',$this->auth->id)
  56. ->order('dt.id desc')->autopage()->select();
  57. $list = list_domain_image($list,['images','avatar']);
  58. if(!empty($list)){
  59. foreach($list as $key => $val){
  60. $list[$key]['is_good'] = $this->is_good($val['id'],$this->auth->id);
  61. }
  62. }
  63. $this->success('success',$list);
  64. }
  65. //是否点赞
  66. private function is_good($dt_id,$uid){
  67. $where = [
  68. 'dt_id' => $dt_id,
  69. 'user_id' => $uid,
  70. ];
  71. $check = Db::name('user_dongtai_good')->where($where)->find();
  72. if($check){
  73. return 1;
  74. }else{
  75. return 0;
  76. }
  77. }
  78. //详情
  79. public function info(){
  80. $id = input('id');
  81. $info = Db::name('user_dongtai')->alias('dt')
  82. ->join('user','dt.user_id = user.id','LEFT')
  83. ->field('dt.*,user.nickname,user.avatar')
  84. ->where('dt.id',$id)->find();
  85. $info = info_domain_image($info,['images','avatar']);
  86. //是否点赞过
  87. if($info){
  88. $info['isgood'] = $this->is_good($id,$this->auth->id);
  89. }
  90. //评论
  91. if($info){
  92. $info['answer'] = $this->answer_list($id);
  93. }
  94. $this->success('success',$info);
  95. }
  96. //点赞
  97. public function good(){
  98. $id = input('id');
  99. $where = [
  100. 'dt_id' => $id,
  101. 'user_id' => $this->auth->id,
  102. ];
  103. $check = Db::name('user_dongtai_good')->where($where)->find();
  104. if($check){
  105. $this->error('已经赞过了');
  106. }
  107. Db::startTrans();
  108. $rs = Db::name('user_dongtai_good')->insertGetId($where);
  109. $up = Db::name('user_dongtai')->where('id',$id)->setInc('goodnum');
  110. if($rs && $up !== false){
  111. Db::commit();
  112. $this->success('点赞成功');
  113. }
  114. Db::rollback();
  115. $this->error('点赞失败');
  116. }
  117. //评论
  118. public function answer(){
  119. $id = input('id',0);
  120. $content = input('content','');
  121. $to_user_id = input('to_user_id',0);
  122. $level = input('level',1); //回复类型:1=层主回复楼主,2=层中回复
  123. $floor = input('floor',0);
  124. if(empty($content) || empty($id)){
  125. $this->error();
  126. }
  127. //判断
  128. if($level == 2 && $floor == 0){
  129. $this->error('楼层错误');
  130. }
  131. //回复楼主,最新楼层
  132. if($level == 1 || $floor == 0){
  133. $to_user_id = 0;
  134. $floor = 1; //默认一楼
  135. $last_floor = Db::name('user_dongtai_answer')->where(['dt_id'=>$id,'level'=>1])->order('floor desc')->value('floor');
  136. if($last_floor){
  137. $floor = $last_floor + 1;
  138. }
  139. }
  140. //判断user_id
  141. if($to_user_id){
  142. $to_user = Db::name('user')->where('id',$to_user_id)->value('id');
  143. if(empty($to_user)){
  144. $this->error('被回复的用户不存在');
  145. }
  146. }
  147. //data
  148. $data = [
  149. 'dt_id' => $id,
  150. 'floor' => $floor,
  151. 'user_id' => $this->auth->id,
  152. 'content' => $content,
  153. 'to_user_id' => $to_user_id,
  154. 'level' => $level,
  155. 'createtime' => time(),
  156. 'updatetime' => time(),
  157. ];
  158. $rs = Db::name('user_dongtai_answer')->insertGetId($data);
  159. $this->success('评价成功');
  160. }
  161. //评论列表
  162. private function answer_list($dt_id){
  163. //楼
  164. $floor_list = Db::name('user_dongtai_answer')
  165. ->alias('a')
  166. ->field('a.*,user.nickname,user.avatar')
  167. ->join('user','a.user_id = user.id','LEFT')
  168. ->where(['a.dt_id'=>$dt_id,'a.level'=>1])->order('id asc')->autopage()->select();
  169. $floor_list = list_domain_image($floor_list,['avatar']);
  170. if(empty($floor_list)){
  171. return [];
  172. }
  173. //层
  174. $floors = array_column($floor_list,'floor');
  175. $child_lists = Db::name('user_dongtai_answer')->alias('a')
  176. ->field('a.*,user.nickname,user.avatar,tuser.nickname as to_nickname,tuser.avatar as to_avatar')
  177. ->join('user','a.user_id = user.id','LEFT')
  178. ->join('user tuser','a.to_user_id = tuser.id','LEFT')
  179. ->where(['a.floor'=>['IN',$floors],'a.level'=>2])->order('id asc')->select();
  180. $child_lists = list_domain_image($child_lists,['avatar','to_avatar']);
  181. /*if(empty($child_lists)){
  182. return $floor_list;
  183. }*/
  184. //合并
  185. foreach($floor_list as $key => $val){
  186. $child = [];
  187. foreach($child_lists as $k => $v){
  188. if($val['floor'] == $v['floor']){
  189. $child[] = $v;
  190. }
  191. }
  192. //追加到外循环
  193. $floor_list[$key]['childcount'] = 0;
  194. if(count($child) > 4){
  195. $floor_list[$key]['childcount'] = count($child) - 4;
  196. }
  197. $floor_list[$key]['child'] = array_slice($child,0,4);
  198. }
  199. return $floor_list;
  200. }
  201. //单独某一层的详细
  202. public function floor_info(){
  203. $floor_id = input('floor_id');
  204. //楼
  205. $floor_info = Db::name('user_dongtai_answer')
  206. ->alias('a')
  207. ->field('a.*,user.nickname,user.avatar')
  208. ->join('user','a.user_id = user.id','LEFT')
  209. ->where(['a.id'=>$floor_id])->find();
  210. $floor_info = info_domain_image($floor_info,['avatar']);
  211. //层
  212. $floors = $floor_info['floor'];
  213. $child_lists = Db::name('user_dongtai_answer')->alias('a')
  214. ->field('a.*,user.nickname,user.avatar,tuser.nickname as to_nickname,tuser.avatar as to_avatar')
  215. ->join('user','a.user_id = user.id','LEFT')
  216. ->join('user tuser','a.to_user_id = tuser.id','LEFT')
  217. ->where(['a.floor'=>$floors,'a.level'=>2])->order('id asc')->autopage()->select();
  218. $child_lists = list_domain_image($child_lists,['avatar','to_avatar']);
  219. //合并
  220. $floor_info['child'] = $child_lists;
  221. $this->success('success',$floor_info);
  222. }
  223. }