Press.php 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\PressComment;
  4. use app\common\model\PlatformLike;
  5. use app\common\model\User;
  6. use app\common\model\UserCollect;
  7. use app\common\model\UserMessage;
  8. use app\common\model\UserReport;
  9. use app\common\model\UserSearch;
  10. use app\common\model\UserTrack;
  11. use app\common\service\CheckPower;
  12. use library\tools\Data;
  13. /**
  14. * @title 新闻
  15. * @controller Press
  16. * @group base
  17. */
  18. class Press extends Base
  19. {
  20. // 需要登录的
  21. protected $need_login = [
  22. 'pressCollect',
  23. 'pressTransmit',
  24. 'pressReport',
  25. 'pressRead',
  26. 'PressTags',
  27. 'pressCommentTags',
  28. 'pressComment',
  29. 'pressSecondComment',
  30. 'getReplyComment',
  31. 'commentMyPress',
  32. 'getMyPressComment',
  33. 'getReplyPress',
  34. 'getPressCollect',
  35. 'getTagsPress',
  36. 'delComment',
  37. ];
  38. public function initialize()
  39. {
  40. parent::initialize();
  41. parent::setUid();
  42. }
  43. /**
  44. * @title 新闻接口说明
  45. * @desc 新闻接口说明
  46. * @author qc
  47. * @url /api/Press/classIntro
  48. * @method GET
  49. * @return name:1 type:string default:-- desc:该模块没有视频!!
  50. */
  51. public function classIntro(){}
  52. /**
  53. * @title 获取新闻列表
  54. * @desc 获取新闻列表
  55. * @author qc
  56. * @method GET
  57. * @url /api/Press/getPressList
  58. * @header name:Authorization require:1 desc:Token
  59. * @param name:title type:string default:-- desc:标题
  60. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  61. * @param name:page type:int default:0 desc:页数
  62. * @param name:page_num type:int default:20 desc:每页数
  63. * @return name:title type:string default:-- desc:标题
  64. * @return name:images type:string default:-- desc:图片多张|隔开
  65. * @return name:images_arr type:array default:-- desc:图片多张[数组]
  66. * @return name:content type:string default:-- desc:详情
  67. * @return name:create_at type:string default:-- desc:时间
  68. * @return name:read_num type:int default:-- desc:阅读
  69. * @return name:is_collect type:int default:-- desc:是否收藏
  70. * @return name:transmit_num type:int default:-- desc:转发量
  71. * @return name:collect_num type:int default:-- desc:收藏量
  72. * @return name:praise_num type:int default:-- desc:点赞量
  73. * @return name:is_praise type:int default:-- desc:是否点赞
  74. * @return name:comment_num type:int default:-- desc:评论量
  75. */
  76. public function getPressList(){
  77. $title = input('get.title');
  78. $sort_type = input('get.sort_type',1);
  79. switch ($sort_type) {
  80. case 1:
  81. $order = ['sort'=>'desc','read_num'=>'desc','id'=>'asc'];
  82. break;
  83. case 2:
  84. $order = ['id'=>'asc','sort'=>'desc'];
  85. break;
  86. case 3:
  87. $order = ['id'=>'desc','sort'=>'desc'];
  88. break;
  89. }
  90. if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,4);
  91. $list = \app\common\model\Press::where(['is_deleted'=>0])
  92. ->field('id,images,title,content,read_num,create_at,transmit_num')
  93. ->when($title,function ($query)use($title){
  94. if($title) $query->where('title|label','like','%'.$title.'%');
  95. })->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  96. foreach ($list as &$v) {
  97. $v['comment_num'] = PressComment::where(['first_id'=>$v['id'],'type'=>1,'is_deleted'=>0])->count();
  98. $v['comment_num'] = numTransform($v['comment_num']);
  99. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$v['id']);
  100. $v['collect_num'] = UserCollect::getCollectNum(4,$v['id']);
  101. $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['id'],1);
  102. $v['praise_num'] = PlatformLike::getPraiseNum($v['id'],1);
  103. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  104. }
  105. $this->success('ok',['list'=>$list]);
  106. }
  107. /**
  108. * @title 获取新闻详情
  109. * @desc 获取新闻详情
  110. * @author qc
  111. * @method GET
  112. * @url /api/Press/getPressDetail
  113. * @header name:Authorization require:1 desc:Token
  114. * @param name:id type:int default:0 desc:新闻id
  115. * @return name:title type:string default:-- desc:标题
  116. * @return name:images type:string default:-- desc:图片多张|隔开
  117. * @return name:images_arr type:array default:-- desc:图片多张[数组]
  118. * @return name:content type:string default:-- desc:详情
  119. * @return name:create_at type:string default:-- desc:时间
  120. * @return name:read_num type:int default:-- desc:阅读
  121. * @return name:is_collect type:int default:-- desc:是否收藏
  122. * @return name:transmit_num type:int default:-- desc:转发量
  123. * @return name:collect_num type:int default:-- desc:收藏量
  124. * @return name:praise_num type:int default:-- desc:点赞量
  125. * @return name:is_praise type:int default:-- desc:是否点赞
  126. * @return name:comment_num type:int default:-- desc:评论量
  127. * @return name:app_name type:string default:-- desc:发布方名称
  128. * @return name:app_logo type:string default:-- desc:发布方头像
  129. */
  130. public function getPressDetail()
  131. {
  132. $sel_where[] = ['id','=',input('get.id')];
  133. $detail = \app\common\model\Press::field('id,images,title,content,read_num,create_at,transmit_num,user_id,is_deleted,status')->where($sel_where)->find()->toArray();
  134. if($detail['is_deleted'] == 1 || $detail['status'] == 0) $this->error('该新闻已下架');
  135. $detail['comment_num'] = PressComment::where(['first_id'=>$detail['id'],'type'=>1,'is_deleted'=>0])->count();
  136. $detail['comment_num'] = numTransform($detail['comment_num']);
  137. $detail['transmit_num'] = numTransform($detail['transmit_num']);
  138. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$detail['id']);
  139. $detail['collect_num'] = UserCollect::getCollectNum(4,$detail['id']);
  140. $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],1);
  141. $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],1);
  142. $app_name = sysconf('app_name');
  143. $app_logo = sysconf('app_logo');
  144. if(!$detail['user_id']){
  145. $detail['app_name'] = $app_name;
  146. $detail['app_logo'] = $app_logo;
  147. }else{
  148. $user_info = User::where('id',$detail['user_id'])->field('name,headimg')->find();
  149. $detail['app_name'] = $user_info ? $user_info->name : '';
  150. $detail['app_logo'] = $user_info ? $user_info->headimg : '';
  151. }
  152. // \app\common\model\Press::where('id',$detail['id'])->setInc('read_num');
  153. UserTrack::crateTrack($this->user_id,4,input('get.id'),0);
  154. $this->success('ok',['detail'=>$detail]);
  155. }
  156. /**
  157. * @title 获取新闻评论列表
  158. * @desc 获取新闻评论列表
  159. * @author qc
  160. * @method GET
  161. * @url /api/Press/getPressCommentList
  162. * @header name:Authorization require:1 desc:Token
  163. * @param name:id type:int default:-- desc:新闻id
  164. * @param name:sort_type type:int default:1 desc:排序规则1时间2热点
  165. * @param name:page type:int default:-- desc:页数
  166. * @param name:page_num type:int default:-- desc:每页数量
  167. * @return name:name type:string default:-- desc:会员名称
  168. * @return name:headimg type:string default:-- desc:会员头像
  169. * @return name:content type:string default:-- desc:内容
  170. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  171. * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】)
  172. * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】)
  173. * @return name:like_num type:int default:-- desc:点赞数量
  174. * @return name:is_like type:int default:-- desc:是否点赞(0否1是)
  175. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  176. */
  177. public function getPressCommentList()
  178. {
  179. $where = [];
  180. $where[] = ['c.first_id','=',input('get.id')];
  181. $where[] = ['c.is_deleted','=',0];
  182. $where[] = ['c.type','=',1];
  183. $user_id = $this->user_id;
  184. $sort_type= input('sort_type',1);
  185. switch ($sort_type) {
  186. case 1:
  187. $order = ['c.is_top'=>'desc','c.id'=>'desc'];
  188. break;
  189. default:
  190. $order = ['c.is_top'=>'desc','c.like_times'=>'desc'];
  191. break;
  192. }
  193. $list =PressComment::where($where)
  194. ->alias('c')
  195. ->field('c.*,u.name,u.headimg')
  196. ->leftJoin('store_member u','u.id = c.user_id')
  197. ->order($order)
  198. ->limit($this->off_set,$this->page_num)
  199. ->select()->toArray();
  200. array_walk($list,function (&$val,$k)use($user_id){
  201. $children = PressComment::where(['c.pid'=>$val['id'],'c.is_deleted'=>0])
  202. ->alias('c')->field('c.*,u.name,u.headimg')
  203. ->leftJoin('store_member u','u.id = c.user_id')
  204. ->order('c.is_top desc,c.id asc')
  205. ->select()->toArray();
  206. $val['children'] = $children ? $children : null;
  207. $val['like_num'] = PlatformLike::getPraiseNum($val['id'],2);
  208. $val['is_like'] = PlatformLike::checkTags($user_id,$val['id'],2);
  209. $parent = PressComment::where(['c.id'=>$val['pid'],'c.is_deleted'=>0])
  210. ->alias('c')->field('c.*,u.name,u.headimg')
  211. ->leftJoin('store_member u','u.id = c.user_id')
  212. ->find();
  213. $val['parent'] = $parent ? $parent->toArray() : null;
  214. });
  215. $total_num = PressComment::where($where)->alias('c')->count();
  216. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num)]);
  217. }
  218. /**
  219. * @title 以下接口调用验证登录【需要header传Authorization】
  220. * @desc 以下接口调用验证登录
  221. * @author qc
  222. * @method
  223. * @url /api/Press/needLogin()
  224. */
  225. public function needLogin(){}
  226. /**
  227. * @title 删除评论
  228. * @desc 删除评论
  229. * @author qc
  230. * @method POST
  231. * @url /api/Press/delComment
  232. * @header name:Authorization require:1 desc:Token
  233. * @param name:id type:int default:1 desc:评论id
  234. */
  235. public function delComment(){
  236. PressComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
  237. $this->success('删除成功');
  238. }
  239. /**
  240. * @title 收藏||取消收藏
  241. * @desc 用户收藏
  242. * @author qc
  243. * @method POST
  244. * @url /api/Press/pressCollect
  245. * @header name:Authorization require:1 desc:Token
  246. * @param name:id type:int require:1 default:-- desc:新闻id
  247. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  248. */
  249. public function pressCollect(){
  250. $coll_status = UserCollect::plateCollect($this->user_id,4,input('post.id',0));
  251. $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]);
  252. }
  253. /**
  254. * @title 新闻转发(转发数量统计)
  255. * @desc 转发成功后调用
  256. * @author qc
  257. * @method POST
  258. * @url /api/Press/pressTransmit
  259. * @header name:Authorization require:1 desc:Token
  260. * @param name:id type:int default:-- desc:新闻id
  261. */
  262. public function pressTransmit()
  263. {
  264. $press_id = input('post.id',0);
  265. \app\common\model\Press::where('id',$press_id)->setInc('transmit_num');
  266. $this->success('ok');
  267. }
  268. /**
  269. * @title 新闻举报
  270. * @desc 新闻举报
  271. * @author qc
  272. * @url /api/Press/pressReport
  273. * @method POST
  274. * @header name:Authorization require:1 desc:Token
  275. * @param name:report_id type:int default:-- desc:举报内容的id
  276. * @param name:case_ids type:string default:-- desc:举报类目id串(逗号隔开)
  277. */
  278. public function pressReport()
  279. {
  280. $report_id= input('post.report_id');
  281. $case_ids= input('post.case_ids');
  282. if(!$report_id) $this->error('请现在举报内容');
  283. if(!$case_ids) $this->error('请选择举报原因');
  284. UserReport::report($this->user_id,7,$report_id,$case_ids);
  285. $this->success('举报成功');
  286. }
  287. /**
  288. * @title 新闻阅读(阅读数量统计)
  289. * @desc 新闻阅读
  290. * @author qc
  291. * @method POST
  292. * @url /api/Press/pressRead
  293. * @header name:Authorization require:1 desc:Token
  294. * @param name:id type:int default:-- desc:新闻id
  295. */
  296. public function pressRead()
  297. {
  298. $press_id = input('post.id',0);
  299. \app\common\model\Press::where('id',$press_id)->setInc('read_num');
  300. $this->success('ok');
  301. }
  302. /**
  303. * @title 新闻点赞||取消点赞
  304. * @desc 点赞||取消点赞
  305. * @author qc
  306. * @method POST
  307. * @url /api/Press/PressTags
  308. * @header name:Authorization require:1 desc:Token
  309. * @param name:id type:int default:1 desc:新闻id
  310. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  311. */
  312. public function pressTags()
  313. {
  314. $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),1);
  315. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  316. }
  317. /**
  318. * @title 新闻评论点赞||取消点赞
  319. * @desc 新闻评论点赞
  320. * @author qc
  321. * @method POST
  322. * @url /api/Press/pressCommentTags
  323. * @header name:Authorization require:1 desc:Token
  324. * @param name:id type:int default:1 desc:评论id
  325. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  326. */
  327. public function pressCommentTags()
  328. {
  329. $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),2);
  330. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  331. }
  332. /**
  333. * @title 新闻评论
  334. * @desc 新闻评论
  335. * @author qc
  336. * @method POST
  337. * @url /api/Press/pressComment
  338. * @header name:Authorization require:1 desc:Token
  339. * @param name:id type:int default:1 desc:新闻id
  340. * @param name:content type:string default:-- desc:内容
  341. * @return name:name type:string default:-- desc:会员名称
  342. * @return name:headimg type:string default:-- desc:会员头像
  343. * @return name:content type:string default:-- desc:内容
  344. * @return name:create_at type:string default:-- desc:时间
  345. */
  346. public function pressComment()
  347. {
  348. $id = input('post.id');
  349. $content = input('post.content',0);
  350. if(!$content) $this->error('请输入评论内容');
  351. $res = PressComment::create(['user_id'=>$this->user_id,'content'=>$content,'first_id'=>$id,'type'=>1]);
  352. $detail =PressComment::where('p.id',$res->id)
  353. ->alias('p')
  354. ->field('p.id,p.content,p.create_at,u.name,u.headimg')
  355. ->leftJoin('store_member u','u.id = p.user_id')
  356. ->find()->toArray();
  357. $this->success('评论成功',['detail'=>$detail]);
  358. }
  359. /**
  360. * @title 新闻二级评论
  361. * @desc 新闻二级评论
  362. * @author qc
  363. * @method POST
  364. * @url /api/Press/pressSecondComment
  365. * @header name:Authorization require:1 desc:Token
  366. * @param name:id type:int default:1 desc:评论id
  367. * @param name:content type:string default:-- desc:内容
  368. * @return name:name type:string default:-- desc:会员名称
  369. * @return name:headimg type:string default:-- desc:会员头像
  370. * @return name:content type:string default:-- desc:内容
  371. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  372. */
  373. public function pressSecondComment()
  374. {
  375. $comment = PressComment::where('id',input('post.id'))->find()->toArray();
  376. $user_info = $this->userInfo('name');
  377. UserMessage:: sendUserMessage($comment['user_id'],'press',1,0,$this->user_id,$comment['id'],$user_info['name'].'回复了您的评论');
  378. unset($comment['id']);
  379. unset($comment['create_at']);
  380. $comment['pid'] = input('post.id');
  381. $comment['user_id'] = $this->user_id;
  382. $comment['content'] = input('post.content');
  383. $comment['lev']++;
  384. if(!$comment['source_id']) $comment['source_id'] = input('post.id');
  385. $res = PressComment::create($comment);
  386. $detail = PressComment::where('p.id',$res->id)
  387. ->alias('p')
  388. ->field('p.id,p.content,p.is_top,p.create_at,u.name,u.headimg')
  389. ->leftJoin('store_member u','u.id = p.user_id')
  390. ->find()->toArray();
  391. $this->success('评论成功',['detail'=>$detail]);
  392. }
  393. /**
  394. * @title 获取角标数量
  395. * @desc 获取角标数量
  396. * @author qc
  397. * @method GET
  398. * @url /api/Press/getMarkNum
  399. * @header name:Authorization require:1 desc:Token
  400. * @return name:reply_num type:int default:-- desc:未读量--回复我的
  401. * @return name:comment_num type:int default:-- desc:未读量--评论我的
  402. */
  403. public function getMarkNum()
  404. {
  405. // 回复我的
  406. $all_comment = PressComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  407. $reply_num = PressComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count();
  408. // 评论我的
  409. $comment_num = PressComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
  410. ->leftJoin('Press i','t.first_id = i.id')
  411. ->alias('t')->count();
  412. $this->success('ok',compact(['reply_num','comment_num']));
  413. }
  414. /**
  415. * @title 消息已读
  416. * @desc 消息已读
  417. * @author qc
  418. * @method POST
  419. * @url /api/Press/unreadChange
  420. * @header name:Authorization require:1 desc:Token
  421. * @param name:id type:string default:-- desc:记录id【不区分类型】
  422. */
  423. public function unreadChange()
  424. {
  425. PressComment::where('id',input('post.id'))->update(['is_read'=>1]);
  426. $this->success('ok');
  427. }
  428. /**
  429. * @title 回复我的【回复我的--回复过我的评论】
  430. * @desc 回复我的
  431. * @author qc
  432. * @method GET
  433. * @url /api/Press/getReplyComment
  434. * @header name:Authorization require:1 desc:Token
  435. * @param name:title type:string default:-- desc:标题
  436. * @param name:page type:int default:0 desc:页数
  437. * @param name:page_num type:int default:20 desc:每页数
  438. * @return name:title type:string default:-- desc:标题
  439. * @return name:cover type:string default:-- desc:封面
  440. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  441. * @return name:iamges_arr type:array default:-- desc:图片【多张】
  442. * @return name:create_at type:string default:-- desc:时间
  443. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  444. * @return name:user_name type:string default:-- desc:用户名【其他会员】
  445. * @return name:headimg type:string default:-- desc:用户头【其他会员】
  446. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  447. * @return name:parent_comment type:array default:-- desc:你的评论内容【别人回复的那个评论】
  448. * @return name:parent_comment.content type:string default:-- desc:内容
  449. * @return name:parent_comment.name type:string default:-- desc:会员名称
  450. * @return name:parent_comment.title type:string default:-- desc:标题
  451. * @return name:parent_comment.press_id type:string default:-- desc:新闻id
  452. */
  453. public function getReplyComment()
  454. {
  455. $all_comment = PressComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  456. if(empty($all_comment)) $this->success('ok',['list'=>null]);
  457. $sel_where = [];
  458. $title = input('get.title');
  459. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  460. $sel_where[] = ['t.is_deleted','=',0];
  461. $sel_where[] = ['t.lev','>=',2];
  462. //$sel_where[] = ['t.user_id','<>',$this->user_id];
  463. $sel_where[] = ['t.pid','in',implode(',',$all_comment)];
  464. $list = PressComment::where($sel_where)
  465. ->alias('t')
  466. ->field('t.id,t.is_top,t.is_read,t.create_at,t.first_id press_id,t.lev,t.content,t.pid,u.name user_name,u.headimg,i.cover,i.images')
  467. ->leftJoin('store_member u','t.user_id = u.id')
  468. ->leftJoin('Press i','t.first_id = i.id')
  469. ->order('t.is_top desc,t.id desc')
  470. ->limit($this->off_set,$this->page_num)
  471. ->select()->toArray();
  472. foreach ($list as &$v) {
  473. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  474. $v['cover'] = $v['images_arr'] ? $v['images_arr'][0] : null;
  475. $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
  476. $parent_comment = PressComment::where([['t.id','=',$v['pid']]])
  477. ->field('t.id,t.first_id press_id,t.is_top,t.content,i.title,i.cover,t.pid,u.name')
  478. ->alias('t')
  479. ->leftJoin('Press i','t.first_id = i.id')
  480. ->leftJoin('store_member u','t.user_id = u.id')
  481. ->find()->toArray();
  482. $v['parent_comment'] = $parent_comment;
  483. }
  484. $this->success('ok',['list'=>$list]);
  485. }
  486. /**
  487. * @title 评论我的
  488. * @desc 评论我的
  489. * @author qc
  490. * @method GET
  491. * @url /api/Press/commentMyPress
  492. * @header name:Authorization require:1 desc:Token
  493. * @param name:title type:string default:-- desc:标题
  494. * @param name:page type:int default:-- desc:页数
  495. * @param name:page_num type:int default:-- desc:每页数
  496. *
  497. * @return name:title type:string default:-- desc:标题
  498. * @return name:press_id type:string default:-- desc:新闻id
  499. * @return name:cover type:string default:-- desc:封面
  500. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  501. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  502. * @return name:create_at type:string default:-- desc:时间
  503. * @return name:user_name type:string default:-- desc:用户名
  504. * @return name:headimg type:string default:-- desc:用户头像
  505. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  506. */
  507. public function commentMyPress()
  508. {
  509. $sel_where = [];
  510. $title = input('get.title');
  511. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  512. $sel_where[] = ['t.is_deleted','=',0];
  513. $sel_where[] = ['i.user_id','=',$this->user_id];
  514. $list = PressComment::where($sel_where)
  515. ->alias('t')
  516. ->field('t.id,t.is_read,t.is_top,t.create_at,t.first_id press_id,t.content,i.images,i.title,i.cover,u.name user_name,u.headimg')
  517. ->leftJoin('Press i','t.first_id = i.id')
  518. ->leftJoin('store_member u','t.user_id = u.id')
  519. ->order('t.is_top desc,t.id desc')
  520. ->limit($this->off_set,$this->page_num)
  521. ->select()->toArray();
  522. array_walk($list,function (&$v){
  523. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  524. $v['cover'] = $v['images_arr'] ? $v['images_arr'][0] : null;
  525. $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
  526. });
  527. $this->success('ok',['list'=>$list]);
  528. }
  529. /**
  530. * @title 我的评论
  531. * @desc 我的评论
  532. * @author qc
  533. * @method GET
  534. * @url /api/Press/getMyPressComment
  535. * @header name:Authorization require:1 desc:Token
  536. * @param name:title type:string default:-- desc:标题
  537. * @param name:page type:int default:-- desc:页数
  538. * @param name:page_num type:int default:-- desc:每页数
  539. *
  540. * @return name:title type:string default:-- desc:标题
  541. * @return name:press_id type:string default:-- desc:新闻id
  542. * @return name:cover type:string default:-- desc:封面
  543. * @return name:images_arr type:array default:-- desc:封面
  544. * @return name:create_at type:string default:-- desc:时间
  545. * @return name:user_name type:string default:-- desc:用户名【用户自己的】
  546. * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
  547. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  548. */
  549. public function getMyPressComment()
  550. {
  551. $where = [];
  552. $where[] = ['t.is_deleted','=',0];
  553. $where[] = ['t.type','=',1];
  554. $where[] = ['t.user_id','=',$this->user_id];
  555. $list = PressComment::where($where)
  556. ->alias('t')
  557. ->field('t.id,t.is_top,t.create_at,t.first_id press_id,i.images,t.content,i.title,i.cover,u.name user_name,u.headimg')
  558. ->leftJoin('Press i','t.first_id = i.id')
  559. ->leftJoin('store_member u','u.id = t.user_id')
  560. ->order('t.is_top desc,id desc')
  561. ->limit($this->off_set,$this->page_num)
  562. ->select()->toArray();
  563. foreach ($list as &$v) {
  564. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  565. $v['cover'] = $v['images_arr'] ? $v['images_arr'][0] : null;
  566. $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
  567. }
  568. $this->success('ok',['list'=>$list]);
  569. }
  570. /**
  571. * @title 我的回复【我的回复--我回复过的评论】
  572. * @desc 我的评论
  573. * @author qc
  574. * @method GET
  575. * @url /api/Press/getReplyPress
  576. * @header name:Authorization require:1 desc:Token
  577. * @param name:title type:string default:-- desc:标题
  578. * @param name:page type:int default:0 desc:页数
  579. * @param name:page_num type:int default:20 desc:每页数
  580. * @return name:title type:string default:-- desc:标题
  581. * @return name:press_id type:int default:-- desc:新闻id
  582. * @return name:cover type:string default:-- desc:封面
  583. * @return name:images_arr type:array default:-- desc:图片多张[数组]
  584. * @return name:create_at type:string default:-- desc:时间
  585. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  586. * @return name:user_name type:string default:-- desc:用户名【用户自己的】
  587. * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
  588. * @return name:parent_comment type:array default:-- desc:上级评论内容【你评论的那个评论】
  589. * @return name:parent_comment.content type:string default:-- desc:内容
  590. * @return name:parent_comment.name type:string default:-- desc:会员名称
  591. * @return name:parent_comment.title type:string default:-- desc:新闻标题
  592. * @return name:parent_comment.press_id type:string default:-- desc:新闻id
  593. */
  594. public function getReplyPress()
  595. {
  596. $user_info = $this->userInfo();
  597. $sel_where = [];
  598. $title = input('get.title');
  599. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  600. $sel_where[] = ['t.user_id','=',$this->user_id];
  601. $sel_where[] = ['t.is_deleted','=',0];
  602. $sel_where[] = ['t.lev','>=',2];
  603. $list = PressComment::where($sel_where)
  604. ->alias('t')
  605. ->field('t.id,t.is_top,t.create_at,t.first_id press_id,t.lev,t.content,t.pid,i.title,i.cover,images')
  606. ->leftJoin('Press i','t.first_id = i.id')
  607. ->order('t.is_top,t.id desc')
  608. ->limit($this->off_set,$this->page_num)
  609. ->select()->toArray();
  610. foreach ($list as &$v) {
  611. $v['user_name'] = $user_info['name'];
  612. $v['headimg'] = $user_info['headimg'];
  613. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  614. $v['cover'] = $v['images_arr'] ? $v['images_arr'][0] : null;
  615. $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
  616. $parent_comment = PressComment::where([['t.id','=',$v['pid']]])
  617. ->field('t.id,t.is_top,t.first_id press_id,t.content,i.title,i.cover,i.images,t.pid,u.name')
  618. ->alias('t')
  619. ->leftJoin('Press i','t.first_id = i.id')
  620. ->leftJoin('store_member u','t.user_id = u.id')
  621. ->find()->toArray();
  622. $parent_comment['images_arr'] = $parent_comment['images'] ? explode('|',$parent_comment['images']) : null;
  623. $v['parent_comment'] = $parent_comment;
  624. }
  625. $this->success('ok',['list'=>$list]);
  626. }
  627. /**
  628. * @title 我的收藏【新闻】
  629. * @desc 我的收藏
  630. * @author qc
  631. * @method GET
  632. * @url /api/Press/getPressCollect
  633. * @header name:Authorization require:1 desc:Token
  634. * @param name:title type:string default:-- desc:标题
  635. * @param name:page type:int default:-- desc:页数
  636. * @param name:page_num type:int default:-- desc:每页数
  637. *
  638. * @return name:title type:string default:-- desc:标题
  639. * @return name:press_id type:string default:-- desc:新闻id
  640. * @return name:cover type:string default:-- desc:封面
  641. * @return name:create_at type:string default:-- desc:时间
  642. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  643. */
  644. public function getPressCollect()
  645. {
  646. $sel_where = [];
  647. $title = input('get.title');
  648. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  649. $sel_where[] = ['t.user_id','=',$this->user_id];
  650. $sel_where[] = ['t.coll_type','=',4];
  651. $list = UserCollect::where($sel_where)
  652. ->alias('t')
  653. ->field('t.id,t.create_at,t.coll_id press_id,i.title,i.cover,images')
  654. ->leftJoin('Press i','t.coll_id = i.id')
  655. ->order('id desc')
  656. ->limit($this->off_set,$this->page_num)
  657. ->select()->toArray();
  658. foreach ($list as &$v) {
  659. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  660. $v['cover'] = $v['images_arr'] ? $v['images_arr'][0] : null;
  661. $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
  662. /* $v['comment_num'] = PressComment::where(['first_id'=>$v['press_id'],'type'=>1,'is_deleted'=>0])->count();
  663. $v['collect_num'] = UserCollect::getCollectNum(4,$v['press_id']);
  664. $v['praise_num'] = PlatformLike::getPraiseNum($v['press_id'],1);*/
  665. }
  666. $this->success('ok',['list'=>$list]);
  667. }
  668. /**
  669. * @title 我的点赞列表【新闻】
  670. * @desc 我的点赞
  671. * @author qc
  672. * @method GET
  673. * @url /api/Press/getTagsPress
  674. * @header name:Authorization require:1 desc:Token
  675. * @param name:title type:string default:-- desc:标题
  676. * @param name:page type:int default:-- desc:页数
  677. * @param name:page_num type:int default:-- desc:每页数
  678. *
  679. * @return name:title type:string default:-- desc:标题
  680. * @return name:press_id type:string default:-- desc:新闻id
  681. * @return name:cover type:string default:-- desc:封面
  682. * @return name:create_at type:string default:-- desc:时间
  683. *
  684. * @return name:is_collect type:int default:-- desc:是否收藏
  685. * @return name:transmit_num type:int default:-- desc:转发量
  686. * @return name:collect_num type:int default:-- desc:收藏量
  687. * @return name:praise_num type:int default:-- desc:点赞量
  688. * @return name:comment_num type:int default:-- desc:评论量
  689. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  690. */
  691. public function getTagsPress()
  692. {
  693. $sel_where = [];
  694. $title = input('get.title');
  695. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  696. $sel_where[] = ['t.user_id','=',$this->user_id];
  697. $sel_where[] = ['t.type','=',1];
  698. $list = PlatformLike::where($sel_where)
  699. ->alias('t')
  700. ->field('t.id,t.create_at,t.like_id press_id,i.title,i.cover,images')
  701. ->leftJoin('Press i','t.like_id = i.id')
  702. ->order('id desc')
  703. ->limit($this->off_set,$this->page_num)
  704. ->select()->toArray();
  705. foreach ($list as &$v) {
  706. $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
  707. $v['comment_num'] = PressComment::where(['first_id'=>$v['press_id'],'type'=>1,'is_deleted'=>0])->count();
  708. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$v['press_id']);
  709. $v['collect_num'] = UserCollect::getCollectNum(4,$v['press_id']);
  710. $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['press_id'],1);
  711. $v['praise_num'] = PlatformLike::getPraiseNum($v['press_id'],1);
  712. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  713. $v['cover'] = $v['images_arr'] ? $v['images_arr'][0] : null;
  714. }
  715. $this->success('ok',['list'=>$list]);
  716. }
  717. /**
  718. * @title 我的浏览历史【新闻】
  719. * @desc 我的浏览历史
  720. * @author qc
  721. * @method GET
  722. * @url /api/Press/getPressTrack
  723. * @header name:Authorization require:1 desc:Token
  724. * @param name:title type:string default:-- desc:标题
  725. * @param name:page type:int default:-- desc:页数
  726. * @param name:page_num type:int default:-- desc:每页数
  727. *
  728. * @return name:title type:string default:-- desc:标题
  729. * @return name:press_id type:string default:-- desc:新闻id
  730. * @return name:cover type:string default:-- desc:封面
  731. * @return name:create_at type:string default:-- desc:时间
  732. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  733. */
  734. public function getPressTrack()
  735. {
  736. $sel_where = [];
  737. $sel_where[] = ['t.user_id','=',$this->user_id];
  738. $sel_where[] = ['t.type','=',4];
  739. $title = input('get.title');
  740. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  741. $list = UserTrack::where($sel_where)
  742. ->alias('t')
  743. ->field('t.id,t.update_int,t.first_id press_id,i.title,i.cover,i.images')
  744. ->leftJoin('Press i','t.first_id = i.id')
  745. ->order('update_int desc')
  746. ->limit($this->off_set,$this->page_num)
  747. ->select()->toArray();
  748. foreach ($list as &$v) {
  749. $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
  750. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  751. $v['cover'] = $v['images_arr'] ? $v['images_arr'][0] : null;
  752. $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
  753. /* $v['comment_num'] = PressComment::where(['first_id'=>$v['press_id'],'type'=>1,'is_deleted'=>0])->count();
  754. $v['collect_num'] = UserCollect::getCollectNum(4,$v['press_id']);
  755. $v['praise_num'] = PlatformLike::getPraiseNum($v['press_id'],1);*/
  756. }
  757. $this->success('ok',['list'=>$list]);
  758. }
  759. }