Topicdongtai.php 10 KB

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