Topicdongtai.php 33 KB

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