Press.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\PlatformComment;
  4. use app\common\model\PlatformLike;
  5. use app\common\model\UserCollect;
  6. use library\tools\Data;
  7. /**
  8. * @title 新闻
  9. * @controller Press
  10. * @group base
  11. */
  12. class Press extends Base
  13. {
  14. // 需要登录的
  15. protected $need_login = ['pressCollect','pressTransmit','pressRead','PressTags','pressComment','pressCommend','delComment'];
  16. public function initialize()
  17. {
  18. parent::initialize();
  19. parent::setUid();
  20. }
  21. /**
  22. * @title 新闻接口说明
  23. * @desc 新闻接口说明
  24. * @author qc
  25. * @url /api/Press/classIntro
  26. * @method GET
  27. */
  28. public function classIntro(){}
  29. /**
  30. * @title 获取新闻列表
  31. * @desc 获取新闻列表
  32. * @author qc
  33. * @method GET
  34. * @url /api/Press/getPressList
  35. * @header name:Authorization require:1 desc:Token
  36. * @param name:title type:string default:-- desc:标题
  37. * @param name:page type:int default:0 desc:页数
  38. * @param name:page_num type:int default:20 desc:每页数
  39. * @return name:title type:string default:-- desc:标题
  40. * @return name:images type:string default:-- desc:图片多张|隔开
  41. * @return name:cover type:string default:-- desc:视频封面
  42. * @return name:video_url type:string default:-- desc:视频
  43. * @return name:content type:string default:-- desc:详情
  44. * @return name:create_at type:string default:-- desc:时间
  45. * @return name:transmit_num type:int default:-- desc:转发量
  46. * @return name:read_num type:int default:-- desc:阅读
  47. * @return name:is_collect type:int default:-- desc:是否收藏
  48. * @return name:collect_num type:int default:-- desc:收藏量
  49. * @return name:praise_num type:int default:-- desc:点赞量
  50. * @return name:is_praise type:int default:-- desc:是否点赞
  51. */
  52. public function getPressList(){
  53. $title = input('get.title');
  54. $list = \app\common\model\Press::where(['is_deleted'=>0])->when($title,function ($query)use($title){
  55. if($title) $query->where('title','like','%.'.$title.'%');
  56. })->order('sort desc,id desc')->limit($this->off_set,$this->page_num)->select()->toArray();
  57. foreach ($list as &$v) {
  58. $v['comment_num'] = PlatformComment::where(['first_id'=>$v['id'],'type'=>1])->count();
  59. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$v['id']);
  60. $v['collect_num'] = UserCollect::getCollectNum(4,$v['id']);
  61. $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['id'],1);
  62. $v['praise_num'] = PlatformLike::getPraiseNum($v['id'],1);
  63. }
  64. $this->success('ok',['list'=>$list]);
  65. }
  66. /**
  67. * @title 获取新闻详情
  68. * @desc 获取新闻详情
  69. * @author qc
  70. * @method GET
  71. * @url /api/Press/getPressDetail
  72. * @header name:Authorization require:1 desc:Token
  73. * @param name:id type:int default:0 desc:新闻id
  74. * @return name:title type:string default:-- desc:标题
  75. * @return name:images type:string default:-- desc:图片多张|隔开
  76. * @return name:cover type:string default:-- desc:视频封面
  77. * @return name:video_url type:string default:-- desc:视频
  78. * @return name:content type:string default:-- desc:详情
  79. * @return name:create_at type:string default:-- desc:时间
  80. * @return name:transmit_num type:int default:-- desc:转发量
  81. * @return name:read_num type:int default:-- desc:阅读
  82. * @return name:is_collect type:int default:-- desc:是否收藏
  83. * @return name:collect_num type:int default:-- desc:收藏量
  84. * @return name:praise_num type:int default:-- desc:点赞量
  85. * @return name:is_praise type:int default:-- desc:是否点赞
  86. */
  87. public function getPressDetail()
  88. {
  89. $sel_where[] = ['id','=',input('get.id')];
  90. $detail = \app\common\model\Press::where($sel_where)->find()->toArray();
  91. $detail['comment_num'] = PlatformComment::where(['first_id'=>$detail['id'],'type'=>1])->count();
  92. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$detail['id']);
  93. $detail['collect_num'] = UserCollect::getCollectNum(4,$detail['id']);
  94. $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],1);
  95. $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],1);
  96. $this->success('ok',['detail'=>$detail]);
  97. }
  98. /**
  99. * @title 获取新闻评论列表
  100. * @desc 获取新闻评论列表
  101. * @author qc
  102. * @method GET
  103. * @url /api/Press/getPressCommentList
  104. * @header name:Authorization require:1 desc:Token
  105. * @param name:id type:int default:-- desc:新闻id
  106. * @param name:sort_type type:int default:1 desc:排序规则1时间2热点
  107. * @param name:page type:int default:-- desc:页数
  108. * @return name:name type:string default:-- desc:会员名称
  109. * @return name:headimg type:string default:-- desc:会员头像
  110. * @return name:content type:string default:-- desc:内容
  111. * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】)
  112. * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】)
  113. * @return name:like_num type:int default:-- desc:点赞数量
  114. * @return name:is_like type:int default:-- desc:是否点赞(0否1是)
  115. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  116. */
  117. public function getPressCommentList()
  118. {
  119. $where = [];
  120. $where[] = ['c.first_id','=',input('get.id')];
  121. $where[] = ['c.is_deleted','=',0];
  122. $where[] = ['c.type','=',1];
  123. $user_id = $this->user_id;
  124. $sort_type= input('sort_type',1);
  125. $order = $sort_type == 1 ? 'c.id desc' : 'c.like_times desc';
  126. $list =PlatformComment::where($where)
  127. ->alias('c')
  128. ->field('c.*,u.name,u.headimg')
  129. ->leftJoin('store_member u','u.id = c.user_id')
  130. ->order($order)
  131. ->limit($this->off_set,$this->page_num)
  132. ->select()->toArray();
  133. array_walk($list,function (&$val,$k)use($user_id){
  134. $children = PlatformComment::where(['c.pid'=>$val['id'],'c.is_deleted'=>0])
  135. ->alias('c')->field('c.*,u.name,u.headimg')
  136. ->leftJoin('store_member u','u.id = c.user_id')
  137. ->order('c.id asc')
  138. ->select()->toArray();
  139. $val['children'] = $children;
  140. $val['like_num'] = PlatformLike::getPraiseNum($val['id']);
  141. $val['is_like'] = PlatformLike::where(['like_id'=>$val['id'],'user_id'=>$user_id,'type'=>1])->count();
  142. $parent = PlatformComment::where(['c.id'=>$val['pid'],'c.is_deleted'=>0])
  143. ->alias('c')->field('c.*,u.name,u.headimg')
  144. ->leftJoin('store_member u','u.id = c.user_id')
  145. ->find();
  146. $val['parent'] = $parent ? $parent->toArray() : null;
  147. });
  148. $total_num = PlatformComment::where($where)->alias('c')->count();
  149. $this->success('ok',['list'=>$list,'total_num'=>$total_num]);
  150. }
  151. /**
  152. * @title 删除评论
  153. * @desc 删除评论
  154. * @author qc
  155. * @method POST
  156. * @url /api/Press/delComment
  157. * @header name:Authorization require:1 desc:Token
  158. * @param name:id type:int default:1 desc:评论id
  159. */
  160. public function delComment(){
  161. PlatformComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
  162. $this->success('删除成功');
  163. }
  164. /**
  165. * @title 以下接口调用验证登录【需要header传Authorization】
  166. * @desc 转发成功后调用
  167. * @author qc
  168. * @method
  169. * @url /api/Press/needLogin()
  170. */
  171. public function needLogin(){}
  172. /**
  173. * @title 收藏||取消收藏
  174. * @desc 用户收藏
  175. * @author qc
  176. * @method POST
  177. * @url /api/Press/pressCollect
  178. * @header name:Authorization require:1 desc:Token
  179. * @param name:id type:int require:1 default:-- desc:新闻id
  180. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  181. */
  182. public function pressCollect(){
  183. $coll_status = UserCollect::plateCollect($this->user_id,4,input('post.id',0));
  184. $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]);
  185. }
  186. /**
  187. * @title 新闻转发(转发数量统计)
  188. * @desc 转发成功后调用
  189. * @author qc
  190. * @method POST
  191. * @url /api/Press/pressTransmit
  192. * @header name:Authorization require:1 desc:Token
  193. * @param name:id type:int default:-- desc:新闻id
  194. */
  195. public function pressTransmit()
  196. {
  197. $press_id = input('post.id',0);
  198. \app\common\model\Press::where('id',$press_id)->setInc('transmit_num');
  199. $this->success('ok');
  200. }
  201. /**
  202. * @title 新闻阅读(阅读数量统计)
  203. * @desc 新闻阅读
  204. * @author qc
  205. * @method POST
  206. * @url /api/Press/pressRead
  207. * @header name:Authorization require:1 desc:Token
  208. * @param name:id type:int default:-- desc:新闻id
  209. */
  210. public function pressRead()
  211. {
  212. $press_id = input('post.id',0);
  213. \app\common\model\Press::where('id',$press_id)->setInc('read_num');
  214. $this->success('ok');
  215. }
  216. /**
  217. * @title 新闻点赞||取消点赞
  218. * @desc 点赞||取消点赞
  219. * @author qc
  220. * @method POST
  221. * @url /api/Press/PressTags
  222. * @header name:Authorization require:1 desc:Token
  223. * @param name:id type:int default:1 desc:新闻id
  224. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  225. */
  226. public function pressTags()
  227. {
  228. $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),1);
  229. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  230. }
  231. /**
  232. * @title 新闻评论
  233. * @desc 新闻评论
  234. * @author qc
  235. * @method POST
  236. * @url /api/Press/pressComment
  237. * @header name:Authorization require:1 desc:Token
  238. * @param name:id type:int default:1 desc:新闻id
  239. * @param name:content type:string default:-- desc:内容
  240. * @return name:name type:string default:-- desc:会员名称
  241. * @return name:headimg type:string default:-- desc:会员头像
  242. * @return name:content type:string default:-- desc:内容
  243. * @return name:create_at type:string default:-- desc:时间
  244. */
  245. public function pressComment()
  246. {
  247. $id = input('post.id');
  248. $content = input('post.content',0);
  249. if(!$content) $this->error('请输入评论内容');
  250. $res = PlatformComment::create(['user_id'=>$this->user_id,'content'=>$content,'first_id'=>$id,'type'=>1]);
  251. $detail =PlatformComment::where('p.id',$res->id)
  252. ->alias('p')
  253. ->field('p.id,p.content,p.create_at,u.name,u.headimg')
  254. ->leftJoin('store_member u','u.id = c.user_id')
  255. ->find()->toArray();
  256. $this->success('评论成功',['detail'=>$detail]);
  257. }
  258. /**
  259. * @title 新闻二级评论
  260. * @desc 新闻二级评论
  261. * @author qc
  262. * @method POST
  263. * @url /api/Press/pressCommend
  264. * @header name:Authorization require:1 desc:Token
  265. * @param name:id type:int default:1 desc:评论id
  266. * @param name:content type:string default:-- desc:内容
  267. * @return name:name type:string default:-- desc:会员名称
  268. * @return name:headimg type:string default:-- desc:会员头像
  269. * @return name:content type:string default:-- desc:内容
  270. */
  271. public function pressCommend()
  272. {
  273. $comment = PlatformComment::where('id',input('post.id'))->find()->toArray();
  274. unset($comment['id']);
  275. unset($comment['create_at']);
  276. $comment['pid'] = input('post.id');
  277. $comment['user_id'] = $this->user_id;
  278. $comment['content'] = input('post.content');
  279. $comment['lev']++;
  280. if(!$comment['source_id']) $comment['source_id'] = input('post.id');
  281. $res = PlatformComment::create($comment);
  282. $detail = PlatformComment::where('p.id',$res->id)
  283. ->alias('p')
  284. ->field('p.id,p.content,p.create_at,u.name,u.headimg')
  285. ->leftJoin('store_member u','u.id = c.user_id')
  286. ->find()->toArray();
  287. $this->success('评论成功',['detail'=>$detail]);
  288. }
  289. }