Topicdongtai.php 7.9 KB

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