Topicdongtai.php 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\controller\Api;
  4. use think\Db;
  5. use app\common\library\Keyworld;
  6. use think\Exception;
  7. /**
  8. * 圈子动态
  9. */
  10. class Topicdongtai extends Api
  11. {
  12. protected $noNeedLogin = [];
  13. protected $noNeedRight = ['*'];
  14. //发布动态
  15. public function addone(){
  16. $content = input('content','');
  17. $images = input('images','');
  18. $audio_file = input('audio_file','');
  19. $topic_ids = input('topic_ids','');
  20. $aite = input('aite','','htmlspecialchars_decode');
  21. $type = input('type',1);
  22. $audio_second = input('audio_second',0);
  23. if(!$content && !$images && !$audio_file){
  24. $this->error(__('Invalid parameters'));
  25. }
  26. if(!$this->user_auth_limit()){
  27. $this->error('请先完成实名认证');
  28. }
  29. //关键字替换
  30. $content = Keyworld::sensitive($content);
  31. //只保留一个
  32. if($type == 1){
  33. $audio_file = '';
  34. $audio_second = 0;
  35. }else{
  36. $images = '';
  37. }
  38. $data = [
  39. 'topic_ids' => $topic_ids,
  40. 'user_id' => $this->auth->id,
  41. 'content' => $content,
  42. 'images' => $images,
  43. 'audio_file' => $audio_file,
  44. 'type' => $type,
  45. 'cityname' => input('cityname',''),
  46. 'aite' => $aite,
  47. 'is_public' => input('is_public',1),
  48. 'audio_second' => $audio_second,
  49. 'longitude' => input('longitude',0),
  50. 'latitude' => input('latitude',0),
  51. 'createtime' => time(),
  52. 'updatetime' => time(),
  53. ];
  54. Db::startTrans();
  55. $id = Db::name('topic_dongtai')->insertGetId($data);
  56. //圈子新增一个贴
  57. $rs = Db::name('topic_hub')->where('id','IN',$topic_ids)->setInc('t_number');
  58. //task任务
  59. //发第一条动态
  60. $task_count = Db::name('topic_dongtai')->where('user_id',$this->auth->id)->count();
  61. if($task_count == 1){
  62. $task_rs = \app\common\model\TaskLog::tofinish($this->auth->id,16);
  63. if($task_rs === false){
  64. Db::rollback();
  65. $this->error('完成任务失败');
  66. }
  67. }
  68. //通知艾特的人
  69. if(!empty($aite)){
  70. $aite = json_decode($aite,true);
  71. if(!empty($aite)){
  72. foreach($aite as $key => $uid){
  73. //系统消息
  74. $msg_id = \app\common\model\Message::addMessage($uid,'动态通知',$this->auth->nickname.'发布动态并@了你,快去看看吧','dongtai_aite',$id);
  75. }
  76. }
  77. }
  78. Db::commit();
  79. $this->success('发布成功',$id);
  80. }
  81. //自己看列表
  82. //某用户的帖子列表
  83. public function my_lists(){
  84. $uid = input('uid',$this->auth->id);
  85. if (empty($uid)) {
  86. $uid = $this->auth->id;
  87. }
  88. $where = ['dt.user_id'=>$uid];
  89. if($uid != $this->auth->id){
  90. $where['dt.is_public'] = 1; //不是自己的,就只能看公开的
  91. }
  92. $list = Db::name('topic_dongtai')->alias('dt')
  93. ->join('user','dt.user_id = user.id','LEFT')
  94. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  95. ->field('dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute,uw.vip_endtime')
  96. ->where($where)
  97. ->order('dt.id desc')->autopage()->select();
  98. $list = list_domain_image($list,['images','audio_file','avatar']);
  99. if(!empty($list)){
  100. foreach($list as $key => &$val){
  101. $val['aite'] = json_decode($val['aite'],true);
  102. //用户年龄
  103. $val['age'] = birthtime_to_age($val['birthday']);
  104. unset($val['birthday']);
  105. //用户vip
  106. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  107. unset($val['vip_endtime']);
  108. //追加点赞
  109. $val['isgood'] = $this->is_good($val['id'],$this->auth->id);
  110. //时间
  111. $val['createtime_text'] = get_last_time($val['createtime']);
  112. //关注
  113. $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);
  114. //收藏
  115. $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);
  116. //拉黑
  117. $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);
  118. //层主评论数量
  119. $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();
  120. //话题
  121. $ids_str = $val['topic_ids'];
  122. if($ids_str){
  123. $val['topic_text'] = Db::name('topic_hub')->where('id','IN',$val['topic_ids'])->orderRaw('field(id,'.$ids_str.')')->column('name');
  124. }else{
  125. $val['topic_text'] = [];
  126. }
  127. }
  128. }
  129. $this->success('success',$list);
  130. }
  131. //动态删除
  132. public function delete(){
  133. $id = input('id',0);
  134. $where['id'] = $id;
  135. $where['user_id'] = $this->auth->id;
  136. $dongtai = Db::name('topic_dongtai')->field('id,topic_ids')->where($where)->find();
  137. if (empty($dongtai)) {
  138. $this->error('未找到动态信息');
  139. }
  140. Db::startTrans();
  141. $delRes = Db::name('topic_dongtai')->where('id',$id)->where('user_id',$this->auth->id)->delete();
  142. if (!$delRes) {
  143. Db::rollback();
  144. $this->error('动态删除失败');
  145. }
  146. //话题少一个贴
  147. if (!empty($dongtai['topic_ids'])) {
  148. $res = Db::name('topic_hub')->where('id','IN',$dongtai['topic_ids'])->setDec('t_number');
  149. if (!$res) {
  150. Db::rollback();
  151. $this->error('更新话题数量失败');
  152. }
  153. }
  154. //删除对应的评论,
  155. Db::name('topic_dongtai_answer')->where('dt_id',$id)->delete();
  156. //点赞,
  157. Db::name('topic_dongtai_good')->where('dt_id',$id)->delete();
  158. //评论点赞
  159. Db::name('topic_answer_good')->where('dt_id',$id)->delete();
  160. Db::commit();
  161. $this->success('删除成功');
  162. }
  163. //某个圈子里的动态列表,关注,最新,附近
  164. public function topic_list(){
  165. $where = ['dt.is_public' => 1];
  166. //话题
  167. $topic_id = input('topic_id',0);
  168. $where_exp = [];
  169. if($topic_id){
  170. $where_exp[] = ['exp',Db::raw("FIND_IN_SET('".$topic_id."',dt.topic_ids)")];
  171. }
  172. //最新
  173. $order = input('orderby','new');
  174. $orderby = 'dt.toptime desc,dt.id desc';
  175. //关注
  176. $where_follow = '';
  177. if($order == 'follow'){
  178. //关注的人
  179. $follow_user_ids = Db::name('user_follow')->where(['uid'=>$this->auth->id])->column('follow_uid');
  180. if(!empty($follow_user_ids)){
  181. $where_follow .= '(dt.user_id IN ('.implode(',',$follow_user_ids).'))';
  182. }
  183. //关注的话题
  184. $where_topic = "";
  185. $follow_topic_ids= Db::name('user_follow_topic')->where(['uid'=>$this->auth->id])->column('topic_id');
  186. if(!empty($follow_topic_ids)){
  187. if(!empty($follow_user_ids)){
  188. $where_follow .= ' or ';
  189. }
  190. $where_topic .= "(";
  191. foreach($follow_topic_ids as $ck => $cv){
  192. $where_topic .= "FIND_IN_SET('".$cv."',dt.topic_ids)";
  193. if($ck+1 < count($follow_topic_ids)){
  194. $where_topic .= " or ";
  195. }
  196. }
  197. $where_topic .= ")";
  198. $where_follow .= $where_topic;
  199. }
  200. //默认
  201. if($where_follow == ''){
  202. $where_follow = 'dt.id = 0';
  203. }
  204. }
  205. //附近,根据距离排序
  206. if($order == 'near'){
  207. // $where['dt.cityname'] = $this->auth->cityname;
  208. $orderby = 'dt.toptime desc,distance asc,';
  209. }
  210. //性别
  211. $gender = input('gender','all');
  212. if($gender != 'all'){
  213. $where['user.gender'] = $gender;
  214. }
  215. //属性
  216. $attribute = input('attribute','all');
  217. if($attribute != 'all' && $attribute != 'BOTH'){
  218. $where['user.attribute'] = $attribute;
  219. }
  220. //排除黑名单的
  221. $where_black = [];
  222. $black_ids = Db::name('user_black')->where(['uid'=>$this->auth->id])->column('black_uid');
  223. if(!empty($black_ids)){
  224. $where_black['dt.user_id'] = ['NOTIN',$black_ids];
  225. }
  226. //列表
  227. $field = 'dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute,uw.vip_endtime';
  228. if($order == 'near'){
  229. $field .= ',(st_distance(point (' . $this->auth->longitude . ', ' . $this->auth->latitude . '),point(dt.longitude,dt.latitude))*111195) as distance';
  230. }
  231. $list = Db::name('topic_dongtai')->alias('dt')
  232. ->join('user','dt.user_id = user.id','LEFT')
  233. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  234. ->field($field)
  235. ->where($where)
  236. ->where($where_exp)
  237. ->where($where_follow)
  238. ->where($where_black)
  239. ->order($orderby)
  240. ->autopage()->select();
  241. $list = list_domain_image($list,['images','audio_file','avatar']);
  242. if(!empty($list)){
  243. foreach($list as $key => &$val){
  244. //艾特
  245. $val['aite'] = json_decode($val['aite'],true);
  246. //距离
  247. $val['distance'] = isset($val['distance']) ? $val['distance'] : 0;
  248. $val['distance'] = bcdiv(intval($val['distance']),1000,1).'km';
  249. //vip如果开了隐私保护,需要隐藏距离
  250. $yinsi = $this->user_power($val['user_id'],'yinsi');
  251. if($yinsi == 1){
  252. $val['distance'] = '';
  253. }
  254. //用户年龄
  255. $val['age'] = birthtime_to_age($val['birthday']);
  256. unset($val['birthday']);
  257. //用户vip
  258. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  259. unset($val['vip_endtime']);
  260. //追加点赞
  261. $val['isgood'] = $this->is_good($val['id'],$this->auth->id);
  262. //时间
  263. $val['createtime_text'] = get_last_time($val['createtime']);
  264. //关注
  265. $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);
  266. //收藏
  267. $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);
  268. //拉黑
  269. $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);
  270. //层主评论数量
  271. $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();
  272. //话题
  273. $ids_str = $val['topic_ids'];
  274. if($ids_str){
  275. $val['topic_text'] = Db::name('topic_hub')->where('id','IN',$val['topic_ids'])->orderRaw('field(id,'.$ids_str.')')->column('name');
  276. }else{
  277. $val['topic_text'] = [];
  278. }
  279. //艾特了谁
  280. // $val['aite_user'] = Db::name('user')->where('id','IN',$val['aite'])->column('nickname');
  281. }
  282. }
  283. $this->success('success',$list);
  284. }
  285. //详情
  286. public function info(){
  287. $id = input('id');
  288. $info = Db::name('topic_dongtai')->alias('dt')
  289. ->join('user','dt.user_id = user.id','LEFT')
  290. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  291. ->field('dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute,uw.vip_endtime')
  292. ->where('dt.id',$id)->find();
  293. $info = info_domain_image($info,['images','audio_file','avatar']);
  294. if($info){
  295. $info['aite'] = json_decode($info['aite'],true);
  296. //用户年龄
  297. $info['age'] = birthtime_to_age($info['birthday']);
  298. unset($info['birthday']);
  299. //用户vip
  300. $info['is_vip'] = $info['vip_endtime'] > time() ? 1 : 0;
  301. unset($info['vip_endtime']);
  302. //是否点赞过
  303. $info['isgood'] = $this->is_good($id,$this->auth->id);
  304. //时间
  305. $info['createtime_text'] = get_last_time($info['createtime']);
  306. //关注
  307. $info['is_follow'] = $this->is_follow($this->auth->id,$info['user_id']);
  308. //收藏
  309. $val['is_collect'] = $this->is_collect($id,$this->auth->id);
  310. //拉黑
  311. $val['is_black'] = $this->is_black($this->auth->id,$info['user_id']);
  312. //层主评论数量
  313. $info['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$id,'level'=>1])->count();
  314. //话题
  315. $ids_str = $info['topic_ids'];
  316. if($ids_str){
  317. $val['topic_text'] = Db::name('topic_hub')->where('id','IN',$ids_str)->orderRaw('field(id,'.$ids_str.')')->column('name');
  318. }else{
  319. $val['topic_text'] = [];
  320. }
  321. }
  322. $this->success('success',$info);
  323. }
  324. //点赞,取消点赞
  325. public function good(){
  326. $id = input('id');
  327. $where = [
  328. 'dt_id' => $id,
  329. 'user_id' => $this->auth->id,
  330. ];
  331. $check = Db::name('topic_dongtai_good')->where($where)->find();
  332. $dt_user_id = Db::name('topic_dongtai')->where('id',$id)->value('user_id');
  333. if($check){
  334. Db::name('topic_dongtai_good')->where($where)->delete();
  335. $down = Db::name('topic_dongtai')->where('id',$id)->setDec('goodnum');
  336. $this->success('已取消点赞');
  337. }else{
  338. Db::startTrans();
  339. $where['createtime'] = time();
  340. $rs = Db::name('topic_dongtai_good')->insertGetId($where);
  341. if(!$rs){
  342. Db::rollback();
  343. $this->error('点赞失败');
  344. }
  345. $up = Db::name('topic_dongtai')->where('id',$id)->setInc('goodnum');
  346. if($up === false){
  347. Db::rollback();
  348. $this->error('点赞失败');
  349. }
  350. //系统消息
  351. $msg_id = \app\common\model\Message::addMessage($dt_user_id,'动态点赞','有人赞了你的动态','dongtai_good',$id);
  352. Db::commit();
  353. $this->success('点赞成功');
  354. }
  355. }
  356. //评论
  357. public function answer(){
  358. $id = input('id',0);
  359. $content = input('content','');
  360. $to_user_id = input('to_user_id',0);
  361. $level = input('level',1); //回复类型:1=层主回复楼主,2=层中回复
  362. $floor = input('floor',0);
  363. if(empty($content) || empty($id)){
  364. $this->error();
  365. }
  366. //关键字替换
  367. $content = Keyworld::sensitive($content);
  368. //判断
  369. if($level == 2 && $floor == 0){
  370. $this->error('楼层错误');
  371. }
  372. //回复楼主,最新楼层
  373. if($level == 1 || $floor == 0){
  374. $to_user_id = 0;
  375. $floor = 1; //默认一楼
  376. $last_floor = Db::name('topic_dongtai_answer')->where(['dt_id'=>$id,'level'=>1])->order('floor desc')->value('floor');
  377. if($last_floor){
  378. $floor = $last_floor + 1;
  379. }
  380. }
  381. //判断user_id
  382. if($to_user_id){
  383. $to_user = Db::name('user')->where('id',$to_user_id)->value('id');
  384. if(empty($to_user)){
  385. $this->error('被回复的用户不存在');
  386. }
  387. }
  388. //data
  389. $data = [
  390. 'dt_id' => $id,
  391. 'floor' => $floor,
  392. 'user_id' => $this->auth->id,
  393. 'content' => $content,
  394. 'to_user_id' => $to_user_id,
  395. 'level' => $level,
  396. 'createtime' => time(),
  397. 'updatetime' => time(),
  398. ];
  399. Db::startTrans();
  400. $rs = Db::name('topic_dongtai_answer')->insertGetId($data);
  401. Db::name('topic_dongtai')->where('id',$id)->setInc('answernum');
  402. //系统消息
  403. if($level == 1){
  404. //发给动态用户
  405. $msg_user_id = Db::name('topic_dongtai')->where('id',$id)->value('user_id');
  406. $msg_title = '动态评论';
  407. $msg_content = '有人评论了你的动态';
  408. $infotype_id = $rs;
  409. }else{
  410. //发给层主
  411. $answer_info = Db::name('topic_dongtai_answer')->where(['dt_id'=>$id,'level'=>1,'floor'=>$floor])->find();
  412. $msg_user_id = $answer_info['user_id'];
  413. $msg_title = '动态评论点评';
  414. $msg_content = '有人点评了你的动态评论';
  415. $infotype_id = $answer_info['id'];
  416. }
  417. $msg_id = \app\common\model\Message::addMessage($msg_user_id,$msg_title,$msg_content,'dongtai_answer',$infotype_id);
  418. Db::commit();
  419. $this->success('评价成功');
  420. }
  421. //对评论点赞
  422. public function answer_good(){
  423. $dt_id = input('dt_id',0);
  424. $answer_id = input('answer_id',0);
  425. $where = [
  426. 'dt_id' => $dt_id,
  427. 'answer_id' => $answer_id,
  428. 'user_id' => $this->auth->id,
  429. ];
  430. $check = Db::name('topic_answer_good')->where($where)->find();
  431. if($check){
  432. Db::name('topic_answer_good')->where($where)->delete();
  433. Db::name('topic_dongtai_answer')->where('id',$answer_id)->setDec('goodnum');
  434. $this->success('已取消点赞');
  435. }else{
  436. Db::startTrans();
  437. $where['createtime'] = time();
  438. $rs = Db::name('topic_answer_good')->insertGetId($where);
  439. $up = Db::name('topic_dongtai_answer')->where('id',$answer_id)->setInc('goodnum');
  440. if($rs && $up !== false){
  441. Db::commit();
  442. $this->success('点赞成功');
  443. }
  444. Db::rollback();
  445. $this->error('点赞失败');
  446. }
  447. }
  448. //举报枚举
  449. /*public function report_enum(){
  450. $arr = [
  451. '侮辱谩骂',
  452. '色情低俗',
  453. '政治敏感',
  454. '违法违规',
  455. '其他',
  456. ];
  457. $this->success(1,$arr);
  458. }*/
  459. //举报
  460. /*public function report(){
  461. $field = ['dt_id','type','content','images'];
  462. $data = request_post_hub($field);
  463. $check = Db::name('topic_dongtai')->where('id',$data['dt_id'])->find();
  464. $data['user_id'] = $this->auth->id;
  465. $data['ruser_id'] = $check['user_id'];
  466. $data['createtime'] = time();
  467. Db::name('topic_dongtai_report')->insertGetId($data);
  468. $this->success('举报成功');
  469. }*/
  470. //收藏,取消收藏
  471. public function collect(){
  472. $where = [
  473. 'user_id' => $this->auth->id,
  474. 'table' => 'topic_dongtai',
  475. 'table_id' => input('id',0),
  476. ];
  477. $check = Db::name('user_collect')->where($where)->find();
  478. if($check){
  479. Db::name('user_collect')->where($where)->delete();
  480. $this->success('已取消收藏');
  481. }else{
  482. Db::name('user_collect')->insertGetId($where);
  483. $this->success('收藏成功');
  484. }
  485. }
  486. //我的收藏
  487. public function my_collect(){
  488. $collect_id = Db::name('user_collect')->where(['table'=>'topic_dongtai','user_id'=>$this->auth->id])->column('table_id');
  489. $where = ['dt.id'=>['IN',$collect_id]];
  490. $list = Db::name('topic_dongtai')->alias('dt')
  491. ->join('user','dt.user_id = user.id','LEFT')
  492. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  493. ->field('dt.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute,uw.vip_endtime')
  494. ->where($where)
  495. ->order('dt.id desc')->autopage()->select();
  496. $list = list_domain_image($list,['images','audio_file','avatar']);
  497. if(!empty($list)){
  498. foreach($list as $key => &$val){
  499. $val['aite'] = json_decode($val['aite'],true);
  500. //用户年龄
  501. $val['age'] = birthtime_to_age($val['birthday']);
  502. unset($val['birthday']);
  503. //用户vip
  504. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  505. unset($val['vip_endtime']);
  506. //追加点赞
  507. $val['isgood'] = $this->is_good($val['id'],$this->auth->id);
  508. //时间
  509. $val['createtime_text'] = get_last_time($val['createtime']);
  510. //关注
  511. $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);
  512. //收藏
  513. $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);
  514. //拉黑
  515. $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);
  516. //层主评论数量
  517. $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();
  518. //话题
  519. $ids_str = $val['topic_ids'];
  520. if($ids_str){
  521. $val['topic_text'] = Db::name('topic_hub')->where('id','IN',$val['topic_ids'])->orderRaw('field(id,'.$ids_str.')')->column('name');
  522. }else{
  523. $val['topic_text'] = [];
  524. }
  525. }
  526. }
  527. $this->success('success',$list);
  528. }
  529. //不感兴趣,屏蔽某条
  530. /*public function screen(){
  531. $data = [
  532. 'user_id' => $this->auth->id,
  533. 'dt_id' => input('dt_id',0),
  534. ];
  535. $check = Db::name('topic_dongtai_screen')->where($data)->find();
  536. if($check){
  537. $this->success('操作成功');
  538. }
  539. Db::name('topic_dongtai_screen')->insertGetId($data);
  540. $this->success('操作成功');
  541. }*/
  542. //评论列表
  543. public function answer_list(){
  544. $dt_id = input('dt_id',0);
  545. //楼
  546. $floor_list = Db::name('topic_dongtai_answer')
  547. ->alias('a')
  548. ->field('a.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute')
  549. ->join('user','a.user_id = user.id','LEFT')
  550. ->where(['a.dt_id'=>$dt_id,'a.level'=>1])->order('a.id desc')->autopage()->select();
  551. $floor_list = list_domain_image($floor_list,['avatar']);
  552. //追加子评论
  553. if(!empty($floor_list)){
  554. foreach($floor_list as $key => &$val){
  555. //下面几条子回复,字符串
  556. $val['childremark'] = '';
  557. $map = [
  558. 'a.dt_id' => $dt_id,
  559. 'a.floor' => $val['floor'],
  560. 'a.level' => 2,
  561. ];
  562. $number = Db::name('topic_dongtai_answer')->alias('a')->where($map)->count();
  563. if($number > 0){
  564. $answer_info = Db::name('topic_dongtai_answer')
  565. ->alias('a')
  566. ->field('user.nickname')
  567. ->join('user','a.user_id = user.id','LEFT')
  568. ->where($map)->order('a.id desc')->find();
  569. $val['childremark'] = $answer_info['nickname'].'...等人,共'.$number.'条回复';
  570. }
  571. //时间处理
  572. $val['createtime_text'] = get_last_time($val['createtime']);
  573. //回复是否已赞
  574. $val['is_good'] = $this->answer_is_good($val['id'],$this->auth->id);
  575. //用户年龄
  576. $val['age'] = birthtime_to_age($val['birthday']);
  577. unset($val['birthday']);
  578. }
  579. }
  580. $this->success(1,$floor_list);
  581. }
  582. //单独某一层的详细
  583. public function answer_info(){
  584. $answer_id = input('answer_id');
  585. //楼
  586. $floor_info = Db::name('topic_dongtai_answer')
  587. ->alias('a')
  588. ->field('a.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute')
  589. ->join('user','a.user_id = user.id','LEFT')
  590. ->where(['a.id'=>$answer_id])->find();
  591. $floor_info = info_domain_image($floor_info,['avatar']);
  592. $floor_info['createtime_text'] = get_last_time($floor_info['createtime']);
  593. //用户年龄
  594. $floor_info['age'] = birthtime_to_age($floor_info['birthday']);
  595. unset($floor_info['birthday']);
  596. //回复是否已赞
  597. $floor_info['is_good'] = $this->answer_is_good($answer_id,$this->auth->id);
  598. $floor_info['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$floor_info['dt_id'],'floor'=>$floor_info['floor'],'level'=>2])->count();
  599. //层
  600. $floors = $floor_info['floor'];
  601. $child_lists = Db::name('topic_dongtai_answer')->alias('a')
  602. ->field('a.*,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute')
  603. ->join('user','a.user_id = user.id','LEFT')
  604. ->where(['a.dt_id'=>$floor_info['dt_id'],'a.floor'=>$floors,'a.level'=>2])->order('a.id desc')->autopage()->select();
  605. $child_lists = list_domain_image($child_lists,['avatar','to_avatar']);
  606. if(!empty($child_lists)){
  607. foreach($child_lists as $key => &$answer){
  608. //用户年龄
  609. $answer['age'] = birthtime_to_age($answer['birthday']);
  610. unset($answer['birthday']);
  611. $answer['is_good'] = $this->answer_is_good($answer['id'],$this->auth->id);
  612. $answer['createtime_text'] = get_last_time($answer['createtime']);
  613. }
  614. }
  615. //合并
  616. $floor_info['child'] = $child_lists;
  617. $this->success('success',$floor_info);
  618. }
  619. //是否点赞
  620. private function is_good($dt_id,$uid){
  621. $where = [
  622. 'dt_id' => $dt_id,
  623. 'user_id' => $uid,
  624. ];
  625. $check = Db::name('topic_dongtai_good')->where($where)->find();
  626. if($check){
  627. return 1;
  628. }else{
  629. return 0;
  630. }
  631. }
  632. //回复是否点赞
  633. private function answer_is_good($answer_id,$uid){
  634. $where = [
  635. 'answer_id' => $answer_id,
  636. 'user_id' => $uid,
  637. ];
  638. $check = Db::name('topic_answer_good')->where($where)->find();
  639. if($check){
  640. return 1;
  641. }else{
  642. return 0;
  643. }
  644. }
  645. //动态是否收藏
  646. private function is_collect($dt_id,$uid){
  647. $where = [
  648. 'user_id' => $uid,
  649. 'table' => 'topic_dongtai',
  650. 'table_id' => $dt_id,
  651. ];
  652. $check = Db::name('user_collect')->where($where)->find();
  653. if($check){
  654. return 1;
  655. }else{
  656. return 0;
  657. }
  658. }
  659. //用户是否拉黑
  660. private function is_black($uid,$black_uid){
  661. $where = [
  662. 'uid' => $uid,
  663. 'black_uid' => $black_uid,
  664. ];
  665. $check = Db::name('user_black')->where($where)->find();
  666. if($check){
  667. return 1;
  668. }else{
  669. return 0;
  670. }
  671. }
  672. //我的评论
  673. public function my_answer(){
  674. $map = [
  675. 'a.user_id' => $this->auth->id,
  676. 'a.level' => 1,
  677. ];
  678. $list = Db::name('topic_dongtai_answer')->alias('a')
  679. ->field('a.id,a.createtime,a.content,a.dt_id,
  680. dt.images,dt.content as dt_content,dt.type as dt_type,dtuser.nickname as dtuser_nickname,dtuser.username as dtuser_username,user.username,
  681. user.nickname,user.avatar,user.gender,user.birthday,user.attribute,uw.vip_endtime')
  682. ->join('topic_dongtai dt','a.dt_id = dt.id','LEFT')
  683. ->join('user dtuser','dt.user_id = dtuser.id','LEFT')
  684. ->join('user user','a.user_id = user.id','LEFT')
  685. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  686. ->where($map)->order('a.id desc')->autopage()->select();
  687. $list = list_domain_image($list,['avatar']);
  688. if(!empty($list)){
  689. foreach($list as $key => &$val){
  690. //用户年龄
  691. $val['age'] = birthtime_to_age($val['birthday']);
  692. unset($val['birthday']);
  693. //用户vip
  694. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  695. unset($val['vip_endtime']);
  696. }
  697. }
  698. $this->success(1,$list);
  699. }
  700. //删除我的某个评论
  701. public function delete_answer(){
  702. $id = input('id',0);
  703. if(!$id){
  704. $this->error();
  705. }
  706. Db::startTrans();
  707. $info = Db::name('topic_dongtai_answer')->where('id',$id)->where('user_id',$this->auth->id)->find();
  708. if(!$info){
  709. $this->error('不存在的动态评论');
  710. }
  711. if($info['level'] == 1){
  712. //楼层内都删
  713. $louceng_id = Db::name('topic_dongtai_answer')->where('dt_id',$info['dt_id'])->where('level',2)->where('floor',$info['floor'])->column('id');
  714. if(!empty($louceng_id)){
  715. Db::name('topic_dongtai')->where('id',$info['dt_id'])->setDec('answernum',count($louceng_id));//回复数减1
  716. Db::name('topic_dongtai_answer')->where('id','IN',$louceng_id)->delete();//评论删掉
  717. Db::name('topic_answer_good')->where('answer_id','IN',$louceng_id)->delete();//评论点赞删掉
  718. }
  719. }
  720. Db::name('topic_dongtai')->where('id',$info['dt_id'])->setDec('answernum');//回复数减1
  721. Db::name('topic_dongtai_answer')->where('id',$id)->delete(); //评论删掉
  722. Db::name('topic_answer_good')->where('answer_id',$id)->delete();//评论点赞删掉
  723. Db::commit();
  724. $this->success();
  725. }
  726. //我点赞的动态
  727. public function my_good(){
  728. $where = ['good.user_id'=>$this->auth->id];
  729. $list = Db::name('topic_dongtai')->alias('dt')
  730. ->join('user','dt.user_id = user.id','LEFT')
  731. ->join('user_wallet uw','user.id = uw.user_id','LEFT')
  732. ->join('topic_dongtai_good good','dt.id = good.dt_id','LEFT')
  733. ->field('dt.*,dt.id as dt_id,user.username,user.nickname,user.avatar,user.gender,user.birthday,user.attribute,uw.vip_endtime')
  734. ->where($where)
  735. ->order('dt.id desc')->autopage()->select();
  736. $list = list_domain_image($list,['images','audio_file','avatar']);
  737. if(!empty($list)){
  738. foreach($list as $key => &$val){
  739. $val['aite'] = json_decode($val['aite'],true);
  740. //用户年龄
  741. $val['age'] = birthtime_to_age($val['birthday']);
  742. unset($val['birthday']);
  743. //用户vip
  744. $val['is_vip'] = $val['vip_endtime'] > time() ? 1 : 0;
  745. unset($val['vip_endtime']);
  746. //追加点赞
  747. $val['isgood'] = $this->is_good($val['id'],$this->auth->id);
  748. //时间
  749. $val['createtime_text'] = get_last_time($val['createtime']);
  750. //关注
  751. $val['is_follow'] = $this->is_follow($this->auth->id,$val['user_id']);
  752. //收藏
  753. $val['is_collect'] = $this->is_collect($val['id'],$this->auth->id);
  754. //拉黑
  755. $val['is_black'] = $this->is_black($this->auth->id,$val['user_id']);
  756. //层主评论数量
  757. $val['answernumber'] = Db::name('topic_dongtai_answer')->where(['dt_id'=>$val['id'],'level'=>1])->count();
  758. //话题
  759. $ids_str = $val['topic_ids'];
  760. if($ids_str){
  761. $val['topic_text'] = Db::name('topic_hub')->where('id','IN',$val['topic_ids'])->orderRaw('field(id,'.$ids_str.')')->column('name');
  762. }else{
  763. $val['topic_text'] = [];
  764. }
  765. }
  766. }
  767. $this->success('success',$list);
  768. }
  769. }