Video.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\SeriesVideoCate;
  4. use app\common\model\UserCollect;
  5. use app\common\model\UserLevelRank;
  6. use app\common\model\UserSearch;
  7. use app\common\model\UserVideo;
  8. use app\common\model\VideoCate;
  9. use app\common\model\VideoComment;
  10. use app\common\model\VideoCommentLike;
  11. use app\common\model\VideoIntro;
  12. use app\common\model\VideoLabel;
  13. use app\common\model\VideoUrl;
  14. use library\tools\Data;
  15. /**
  16. * @title 视频
  17. * @controller Video
  18. * @group base
  19. */
  20. class Video extends Base
  21. {
  22. protected $need_login = ['userReferVideo','userReferVideoDetail','delUserVideo','videoComment','secondCommend','videoTags','videoTransmit','getMyVideoList','delComment'];// 需要登录的
  23. public function initialize()
  24. {
  25. parent::initialize();
  26. parent::setUid();
  27. }
  28. /**
  29. * @title 获取分类
  30. * @desc 获取分类(共两级)
  31. * @author qc
  32. * @url /api/Video/getCateTree
  33. * @method GET
  34. * @header name:Authorization require:1 desc:Token
  35. * @param name:type type:int default:0 desc:类型1单个2系列
  36. * @return name:id type:int default:-- desc:分类id
  37. * @return name:logo type:string default:-- desc:图标
  38. * @return name:title type:string default:0 desc:分类名称
  39. * @return name:children type:array default:0 desc:下级分类
  40. */
  41. public function getCateTree()
  42. {
  43. $type = input('type',1);
  44. if($type == 1) {
  45. $list = VideoCate::where(['is_deleted'=>0])->field('id,logo,title,pid')->order('sort desc')->select()->toArray();
  46. }else{
  47. $list = SeriesVideoCate::where(['is_deleted'=>0])->field('id,logo,title,pid')->order('sort desc')->select()->toArray();
  48. }
  49. $list = make_tree($list);
  50. $this->success('ok',['list'=>$list]);
  51. }
  52. /**
  53. * @title 获取视频标签
  54. * @desc 获取视频标签
  55. * @author qc
  56. * @url /api/Video/getVideoLabel
  57. * @method GET
  58. * @header name:Authorization require:1 desc:Token
  59. * @return name:id type:int default:-- desc:id
  60. * @return name:title type:string default:0 desc:标题
  61. */
  62. public function getVideoLabel()
  63. {
  64. $list = VideoLabel::field('id,title')->where(['is_deleted'=>0,'status'=>1])->select()->toArray();
  65. $this->success('',['list'=>$list]);
  66. }
  67. /**
  68. * @title 获取视频列表(平台发布)
  69. * @desc 获取视频列表
  70. * @author qc
  71. * @method GET
  72. * @url /api/Video/getVideoList
  73. * @header name:Authorization require:1 desc:Token
  74. * @param name:type type:int default:0 desc:类型1单个2系列
  75. * @param name:is_tj type:int default:0 desc:是否推荐0否1是
  76. * @param name:is_hot type:int default:-1 desc:是否置顶0否1是(-1全部)
  77. * @param name:title type:string default:-- desc:标题
  78. * @param name:first_classify type:int default:0 desc:视频一级分类
  79. * @param name:second_classify type:int default:0 desc:视频二级分类
  80. * @param name:page type:int default:0 desc:页数
  81. * @param name:page_num type:int default:20 desc:每页数
  82. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  83. * @return name:title type:string default:-- desc:标题
  84. * @return name:cover type:string default:-- desc:封面
  85. * @return name:video_url type:string default:-- desc:视频地址
  86. * @return name:first_classify type:int default:-- desc:视频一级分类
  87. * @return name:second_classify type:int default:-- desc:视频二级分类
  88. * @return name:is_top type:int default:-- desc:是否置顶(0否,1是)
  89. * @return name:is_vip type:int default:-- desc:是否是vip(0否,1是)
  90. * @return name:is_over type:int default:-- desc:是否完结(0否,1是)
  91. * @return name:label_name type:array default:-- desc:标签
  92. * @return name:read_num type:int default:-- desc:播放量
  93. * @return name:is_collect type:int default:-- desc:是否收藏
  94. * @return name:video_arr type:array default:-- desc:视频地址
  95. * @return name:video_arr.url type:string default:-- desc:视频地址
  96. */
  97. public function getVideoList()
  98. {
  99. $sel_where = [];
  100. $sel_where[] = ['is_deleted','=',0];
  101. $sel_where[] = ['status','=',1];
  102. $title = input('get.title');
  103. $type = input('get.type',0);
  104. $is_hot = input('get.is_hot',-1);
  105. $first_classify = input('get.first_classify');
  106. $second_classify = input('get.second_classify');
  107. $sort_type = input('get.sort_type',1);
  108. $is_tj = input('get.is_tj',0);
  109. if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,1);
  110. if($title) $sel_where[] = ['title','like','%'.$title.'%'];
  111. if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
  112. if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
  113. if($type) $sel_where[] = ['type','=',$type];
  114. if($is_hot >= 0) $sel_where[] = ['is_hot','=',$is_hot];
  115. $where_str = 'id > 0';
  116. if($is_tj) {
  117. $search_log = UserSearch::getSearchTitle($this->user_id,1);
  118. $search_arr = [];
  119. foreach ($search_log as $t){
  120. $search_arr[] = " title like '".'%'.$t."%'" .' ';
  121. }
  122. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  123. }
  124. $order = 'is_top desc,sort desc ,id desc';
  125. if($sort_type == 2)$order = 'id asc';
  126. if($sort_type == 3)$order = 'id desc';
  127. $list = VideoIntro::with(['videoArr'])->where($sel_where)
  128. ->where($where_str)
  129. ->order($order)
  130. ->limit($this->off_set,$this->page_num)->select()->toArray();
  131. array_walk($list,function (&$v,$k){
  132. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,1,$v['id']);
  133. $v['label_name'] = [$v['label']];
  134. $v['read_num'] = array_sum(array_column($v['video_arr'],'read_num'));
  135. });
  136. $this->success('ok',['list'=>$list]);
  137. }
  138. /**
  139. * @title 获取视频详情(平台)
  140. * @desc 获取视频详情
  141. * @author qc
  142. * @method GET
  143. * @url /api/Video/getVideoDetail
  144. * @header name:Authorization require:1 desc:Token
  145. * @param name:id type:int default:0 desc:视频id
  146. * @return name:title type:string default:-- desc:标题
  147. * @return name:cover type:string default:-- desc:封面
  148. * @return name:video_url type:string default:-- desc:视频地址
  149. * @return name:first_classify type:int default:-- desc:视频一级分类
  150. * @return name:is_top type:int default:-- desc:是否置顶(0否,1是)
  151. * @return name:read_num type:int default:-- desc:播放量
  152. * @return name:video_arr type:array default:-- desc:视频地址
  153. * @return name:video_arr.cover type:string default:-- desc:预览图
  154. * @return name:video_arr.url type:string default:-- desc:视频地址
  155. * @return name:video_arr.transmit_num type:int default:-- desc:转发量
  156. * @return name:video_arr.read_num type:int default:-- desc:播放量
  157. * @return name:video_arr.is_vip type:int default:-- desc:是否是需要会员(0否1是)
  158. * @return name:video_arr.is_collect type:int default:-- desc:是否收藏
  159. * @return name:video_arr.collect_num type:int default:-- desc:收藏量
  160. * @return name:video_arr.praise_num type:int default:-- desc:点赞量
  161. * @return name:video_arr.is_praise type:int default:-- desc:是否点赞
  162. * @return name:video_arr.article_id type:int default:-- desc:关联图文id【单个id||系列id】
  163. * @return name:video_arr.article_item type:int default:-- desc:关联图文详情id【item_list.id】
  164. * @return name:video_arr.datum_id type:int default:-- desc:资料id【单个id||系列id】
  165. * @return name:video_arr.datum_item type:int default:-- desc:资料详情id【url_arr.id】
  166. */
  167. public function getVideoDetail()
  168. {
  169. $sel_where = [];
  170. $sel_where[] = ['id','=',input('get.id')];
  171. $detail = VideoIntro::with(['videoArr'])->where($sel_where)->find()->toArray();
  172. if($detail['is_deleted'] == 1 || $detail['status'] == 0)$this->error('该视频已下线');
  173. $detail['label_name'] = [];
  174. if($detail['label']) {
  175. $detail['label_name'] = [$detail['label']];
  176. }
  177. $level_id = UserLevelRank::getUserVip($this->user_id);
  178. foreach ($detail['video_arr'] as &$dv) {
  179. if($dv['is_vip'] && !$level_id) $dv['url'] = '';
  180. $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,1,$detail['id'],$dv['id']);
  181. $dv['collect_num'] = UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>1,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
  182. $dv['is_praise'] = VideoCommentLike::where(['user_id'=>$this->user_id,'type'=>2,'like_id'=>$dv['id']])->count();
  183. $dv['praise_num'] = VideoCommentLike::where(['type'=>2,'like_id'=>$dv['id']])->count();
  184. }
  185. $detail['read_num'] = array_sum(array_column($detail['video_arr'],'read_num'));
  186. $this->success('ok',['detail'=>$detail]);
  187. }
  188. /**
  189. * @title 获取视频列表(用户发布【审核通过的】)
  190. * @desc 用户发布【审核通过的】
  191. * @author qc
  192. * @method GET
  193. * @url /api/Video/getUserVideoList
  194. * @header name:Authorization require:1 desc:Token
  195. * @param name:title type:string default:-- desc:标题
  196. * @param name:first_classify type:int default:0 desc:视频一级分类
  197. * @param name:second_classify type:int default:0 desc:视频二级分类
  198. * @param name:page type:int default:0 desc:页数
  199. * @param name:page_num type:int default:20 desc:每页数
  200. * @return name:title type:string default:-- desc:标题
  201. * @return name:cover type:string default:-- desc:封面
  202. * @return name:video_url type:string default:-- desc:视频地址
  203. * @return name:first_classify type:int default:-- desc:视频一级分类
  204. * @return name:second_classify type:int default:-- desc:视频二级分类
  205. * @return name:read_num type:int default:-- desc:播放量
  206. * @return name:is_collect type:int default:-- desc:是否收藏
  207. */
  208. public function getUserVideoList()
  209. {
  210. $sel_where = [];
  211. $sel_where[] = ['is_deleted','=',0];
  212. $sel_where[] = ['status','=',1];
  213. $title = input('get.title');
  214. $first_classify = input('get.first_classify');
  215. $second_classify = input('get.second_classify');
  216. if($title) $sel_where[] = ['v.title','like','%'.$title.'%'];
  217. if($first_classify) $sel_where[] = ['v.first_classify','=',$first_classify];
  218. if($second_classify) $sel_where[] = ['v.second_classify','=',$second_classify];
  219. $list = UserVideo::field('v.*')->where($sel_where)->order('v.id desc')
  220. ->alias('v')
  221. ->leftJoin('User u','u.id = v.user_id')
  222. ->limit($this->off_set,$this->page_num)
  223. ->select()->toArray();
  224. $this->success('ok',['list'=>$list]);
  225. }
  226. /**
  227. * @title 获取我的视频列表
  228. * @desc 获取我的视频列表
  229. * @author qc
  230. * @method GET
  231. * @url /api/Video/getMyVideoList
  232. * @header name:Authorization require:1 desc:Token
  233. * @param name:title type:string default:-- desc:标题
  234. * @param name:page type:int default:0 desc:页数
  235. * @param name:page_num type:int default:20 desc:每页数
  236. * @return name:title type:string default:-- desc:标题
  237. * @return name:cover type:string default:-- desc:封面
  238. * @return name:video_url type:string default:-- desc:视频地址
  239. * @return name:first_classify type:int default:-- desc:视频一级分类
  240. * @return name:second_classify type:int default:-- desc:视频二级分类
  241. * @return name:read_num type:int default:-- desc:播放量
  242. * @return name:is_collect type:int default:-- desc:是否收藏
  243. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  244. */
  245. public function getMyVideoList()
  246. {
  247. $sel_where = [];
  248. $sel_where[] = ['is_deleted','=',0];
  249. $sel_where[] = ['user_id','=',$this->user_id];
  250. $title = input('get.title');
  251. if($title) $sel_where[] = ['title','like','%'.$title.'%'];
  252. $list = UserVideo::where($sel_where)->order('id desc')
  253. ->limit($this->off_set,$this->page_num)
  254. ->select()->toArray();
  255. $this->success('ok',['list'=>$list]);
  256. }
  257. /**
  258. * @title 获取视频详情(会员)
  259. * @desc 获取视频详情
  260. * @author qc
  261. * @method GET
  262. * @url /api/Video/getUserVideoDetail
  263. * @header name:Authorization require:1 desc:Token
  264. * @param name:id type:int default:0 desc:视频id
  265. * @param name:first_classify type:int default:0 desc:视频一级分类
  266. * @param name:second_classify type:int default:0 desc:视频二级分类
  267. * @param name:page type:int default:0 desc:页数
  268. * @param name:page_num type:int default:20 desc:每页数
  269. * @return name:title type:string default:-- desc:标题
  270. * @return name:cover type:string default:-- desc:封面
  271. * @return name:video_url type:string default:-- desc:视频地址
  272. * @return name:first_classify type:int default:-- desc:视频一级分类
  273. * @return name:second_classify type:int default:-- desc:视频二级分类
  274. * @return name:read_num type:int default:-- desc:播放量
  275. * @return name:is_collect type:int default:-- desc:是否收藏
  276. * @return name:collect_num type:int default:-- desc:收藏量
  277. * @return name:praise_num type:int default:-- desc:点赞量
  278. * @return name:is_praise type:int default:-- desc:是否点赞
  279. * @return name:transmit_num type:int default:-- desc:转发量
  280. */
  281. public function getUserVideoDetail()
  282. {
  283. $detail = UserVideo::where('id',input('get.id'))->find();
  284. if(!$detail)$this->error('该视频已下线');
  285. if($detail->status != 1)$this->error('该视频未通过审核');
  286. $detail->is_collect = 0;
  287. $detail->collect_num = 0;
  288. $detail->is_praise =0;
  289. $detail->praise_num = 0;
  290. $this->success('ok',['detail'=>$detail->toArray()]);
  291. }
  292. /**
  293. * @title 用户提交或修改视频
  294. * @desc 用户提交或修改视频
  295. * @author qc
  296. * @method POST
  297. * @url /api/Video/userReferVideo
  298. * @header name:Authorization require:1 desc:Token
  299. * @param name:id type:int default:-- desc:id(修改时必传)
  300. * @param name:title type:string default:-- desc:标题
  301. * @param name:video_url type:string default:-- desc:视频地址
  302. * @param name:desc type:string default:-- desc:简介
  303. * @param name:first_classify type:int default:-- desc:视频一级分类id
  304. * @param name:second_classify type:int default:-- desc:视频二级分类id
  305. * @param name:label type:string default:-- desc:视频标签id(多个用逗号隔开)
  306. */
  307. public function userReferVideo()
  308. {
  309. $id = input('post.id',0);
  310. $title = input('post.title');
  311. $desc = input('post.desc');
  312. $video_url = input('post.video_url');
  313. $cover = $video_url.'?x-oss-process=video/snapshot,t_2000,m_fast';
  314. $first_classify = input('post.first_classify',0);
  315. $second_classify = input('post.second_classify',0);
  316. $label = input('post.label');
  317. if(!$video_url) $this->error('请上传视频');
  318. if($id){
  319. $check_status = UserVideo::where('id',$id)->value('status');
  320. if($check_status == 1) $this->error('视频已审核通过,不允许修改');
  321. }
  322. $data = [
  323. 'title' => $title,
  324. 'cover' => $cover,
  325. 'user_id' => $this->user_id,
  326. 'desc' => $desc,
  327. 'first_classify' => $first_classify,
  328. 'second_classify' => $second_classify,
  329. 'video_url' => $video_url,
  330. 'label' => $label,
  331. ];
  332. if($id) $data['id'] = $id;
  333. if($id){
  334. UserVideo::where('id',$id)->update($data);
  335. }else{
  336. $res= UserVideo::create($data) ;
  337. }
  338. $this->success('提交成功,请等待审核',['id'=> $id ? :$res->id]);
  339. }
  340. /**
  341. * @title 获取用户提交视频详情
  342. * @desc 获取用户提交视频详情
  343. * @author qc
  344. * @method GET
  345. * @url /api/Video/userReferVideoDetail
  346. * @header name:Authorization require:1 desc:Token
  347. * @param name:id type:int default:-- desc:id
  348. * @return name:title type:string default:-- desc:标题
  349. * @return name:cover type:string default:-- desc:封面
  350. * @return name:video_url type:string default:-- desc:视频地址
  351. * @return name:first_classify type:int default:-- desc:视频一级分类id
  352. * @return name:second_classify type:int default:-- desc:视频二级分类id
  353. * @return name:label type:string default:-- desc:视频标签id(多个用逗号隔开)
  354. */
  355. public function userReferVideoDetail()
  356. {
  357. $detail = UserVideo::where('id',input('get.id'))->find()->toArray();
  358. if($detail['is_deleted'] == 1) $this->error('视频已删除');
  359. $detail['label_name'] = [];
  360. if($detail['label']) {
  361. $detail['label_name'] = [$detail['label']];
  362. }
  363. $this->success('获取成功',['detail'=>$detail]);
  364. }
  365. /**
  366. * @title 用户删除视频记录
  367. * @desc 用户删除视频记录
  368. * @author qc
  369. * @method POST
  370. * @url /api/Video/delUserVideo
  371. * @header name:Authorization require:1 desc:Token
  372. * @param name:id type:int default:-- desc:id
  373. */
  374. public function delUserVideo()
  375. {
  376. UserVideo::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
  377. $this->success('删除成功');
  378. }
  379. /**
  380. * @title 视频评论
  381. * @desc 视频评论
  382. * @author qc
  383. * @method POST
  384. * @url /api/Video/videoComment
  385. * @header name:Authorization require:1 desc:Token
  386. * @param name:video_type type:int default:1 desc:视频类型(1平台2会员)
  387. * @param name:video_id type:int default:-- desc:视频id
  388. * @param name:url_id type:int default:-- desc:平台类型必传
  389. * @param name:content type:string default:-- desc:内容
  390. */
  391. public function videoComment()
  392. {
  393. $video_type = input('post.video_type',1);
  394. $video_id = input('post.video_id');
  395. $url_id = input('post.url_id',0);
  396. $content = input('post.content',0);
  397. if(!$content) $this->error('请输入评论内容');
  398. $res = VideoComment::create(['user_id'=>$this->user_id,'content'=>$content,'video_id'=>$video_id,'url_id'=>$url_id,'video_type'=>$video_type]);;
  399. $detail =VideoComment::where('c.id',$res->id)
  400. ->alias('c')
  401. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  402. ->leftJoin('store_member u','u.id = c.user_id')
  403. ->find()->toArray();
  404. $this->success('评论成功',['detail'=>$detail]);
  405. }
  406. /**
  407. * @title 视频二级评论
  408. * @desc 视频二级评论
  409. * @author qc
  410. * @method POST
  411. * @url /api/Video/secondCommend
  412. * @header name:Authorization require:1 desc:Token
  413. * @param name:id type:int default:1 desc:评论id
  414. * @param name:content type:string default:-- desc:内容
  415. * @return name:name type:string default:-- desc:会员名称
  416. * @return name:headimg type:string default:-- desc:会员头像
  417. * @return name:content type:string default:-- desc:内容
  418. */
  419. public function secondCommend()
  420. {
  421. $comment = VideoComment::where('id',input('post.id'))->find()->toArray();
  422. unset($comment['id']);
  423. unset($comment['create_at']);
  424. $comment['pid'] = input('post.id');
  425. $comment['user_id'] = $this->user_id;
  426. $comment['content'] = input('post.content');
  427. $comment['lev']++;
  428. if(!$comment['source_id']) $comment['source_id'] = input('post.id');
  429. $res = VideoComment::create($comment);
  430. $detail = VideoComment::where('c.id',$res->id)
  431. ->alias('c')
  432. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  433. ->leftJoin('store_member u','u.id = c.user_id')
  434. ->find()->toArray();
  435. $this->success('评论成功',['detail'=>$detail]);
  436. }
  437. /**
  438. * @title 获取视频评论列表
  439. * @desc 获取视频评论列表
  440. * @author qc
  441. * @method GET
  442. * @url /api/Video/getVideoCommentList
  443. * @header name:Authorization require:1 desc:Token
  444. * @param name:video_type type:int default:1 desc:视频类型(1平台2会员)
  445. * @param name:video_id type:int default:-- desc:视频id
  446. * @param name:url_id type:int default:-- desc:平台类型必传
  447. * @param name:sort_type type:int default:1 desc:排序规则1时间2热点
  448. * @param name:page type:int default:-- desc:页数
  449. * @return name:name type:string default:-- desc:会员名称
  450. * @return name:headimg type:string default:-- desc:会员头像
  451. * @return name:content type:string default:-- desc:内容
  452. * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】)
  453. * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】)
  454. * @return name:like_num type:int default:-- desc:点赞数量
  455. * @return name:is_like type:int default:-- desc:是否点赞(0否1是)
  456. * @return name:can_delete type:int default:-- desc:是否可以删除(0否1是)
  457. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  458. *
  459. */
  460. public function getVideoCommentList()
  461. {
  462. $where = [];
  463. $where[] = ['c.video_id','=',input('get.video_id')];
  464. $where[] = ['c.video_type','=',input('get.video_type')];
  465. $where[] = ['c.is_deleted','=',0];
  466. $user_id = $this->user_id;
  467. $sort_type= input('sort_type',1);
  468. $order = $sort_type == 1 ? 'c.id desc' : 'c.like_times desc';
  469. $list =VideoComment::where($where)
  470. ->alias('c')
  471. ->field('c.*,u.name,u.headimg')
  472. ->leftJoin('store_member u','u.id = c.user_id')
  473. ->order($order)
  474. ->limit($this->off_set,$this->page_num)
  475. ->select()->toArray();
  476. array_walk($list,function (&$val,$k)use($user_id){
  477. $children = VideoComment::where(['c.pid'=>$val['id'],'c.is_deleted'=>0])
  478. ->alias('c')
  479. ->field('c.*,u.name,u.headimg')
  480. ->leftJoin('store_member u','u.id = c.user_id')
  481. ->order('c.id asc')
  482. ->select()->toArray();
  483. $val['like_num'] = VideoCommentLike::where('like_id',$val['id'])->count();
  484. $val['children'] = $children;
  485. $val['is_like'] = VideoCommentLike::where(['like_id'=>$val['id'],'user_id'=>$user_id])->count();
  486. $parent = VideoComment::where(['c.id'=>$val['pid'],'c.is_deleted'=>0])
  487. ->alias('c')->field('c.*,u.name,u.headimg')
  488. ->leftJoin('store_member u','u.id = c.user_id')
  489. ->find();
  490. $val['parent'] = $parent ? $parent->toArray() : null;
  491. $val['can_delete'] = $val['user_id'] == $this->user_id ? 1 :0;
  492. });
  493. $total_num = VideoComment::where($where)->alias('c')->count();
  494. $this->success('ok',['list'=>$list,'total_num'=>$total_num]);
  495. }
  496. /**
  497. * @title 删除评论
  498. * @desc 删除评论
  499. * @author qc
  500. * @method POST
  501. * @url /api/Video/delComment
  502. * @header name:Authorization require:1 desc:Token
  503. * @param name:id type:int default:1 desc:评论id
  504. */
  505. public function delComment(){
  506. VideoComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
  507. $this->success('删除成功');
  508. }
  509. /**
  510. * @title 点赞||取消点赞
  511. * @desc 点赞||取消点赞
  512. * @author qc
  513. * @method POST
  514. * @url /api/Video/videoTags
  515. * @header name:Authorization require:1 desc:Token
  516. * @param name:type type:int default:1 desc:1评论点赞,评论记录id(一级)二级评论不要这个功能,2平台视频点赞,3会员视频点赞
  517. * @param name:like_id type:int default:1 desc:点赞id【二级评论不要这个功能】(平台视频点赞用video_arr的iD)
  518. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  519. */
  520. public function videoTags()
  521. {
  522. $type = input('post.type',1);
  523. $like_id = input('post.like_id');
  524. $ret_val = 0;
  525. $check_tags = VideoCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type])->value('id');
  526. if($check_tags) {
  527. VideoCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type])->delete();
  528. if($type == 1) VideoComment::where('id',$like_id)->setDec('like_times');
  529. }else{
  530. Data::save('VideoCommentLike',
  531. ['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type],'user_id',
  532. ['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type]);
  533. $ret_val = 1;
  534. if($type == 1) VideoComment::where('id',$like_id)->setInc('like_times');
  535. }
  536. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  537. }
  538. /**
  539. * @title 视频转发(转发数量统计)
  540. * @desc 转发成功后调用
  541. * @author qc
  542. * @method POST
  543. * @url /api/Video/videoTransmit
  544. * @header name:Authorization require:1 desc:Token
  545. * @param name:video_type type:int default:1 desc:视频类型(1平台2会员)
  546. * @param name:video_id type:int default:-- desc:视频id
  547. * @param name:url_id type:int default:-- desc:平台类型必传
  548. */
  549. public function videoTransmit()
  550. {
  551. $video_type = input('post.video_type',1);
  552. $video_id = input('post.video_id');
  553. $url_id = input('post.url_id',0);
  554. if($video_type == 1) {
  555. VideoUrl::where('id',$url_id)->setInc('transmit_num');
  556. }else{
  557. UserVideo::where('id',$video_id)->setInc('transmit_num');
  558. }
  559. $this->success('ok');
  560. }
  561. /**
  562. * @title 视频播放(播放数量统计)
  563. * @desc 播放数量统计
  564. * @author qc
  565. * @method POST
  566. * @url /api/Video/videoPlay
  567. * @header name:Authorization require:1 desc:Token
  568. * @param name:video_type type:int default:1 desc:视频类型(1平台2会员)
  569. * @param name:video_id type:int default:-- desc:视频id
  570. * @param name:url_id type:int default:-- desc:平台类型必传
  571. */
  572. public function videoPlay()
  573. {
  574. $video_type = input('post.video_type',1);
  575. $video_id = input('post.video_id');
  576. $url_id = input('post.url_id',0);
  577. if($video_type == 1) {
  578. VideoUrl::where('id',$url_id)->setInc('read_num');
  579. }else{
  580. UserVideo::where('id',$video_id)->setInc('read_num');
  581. }
  582. $this->success('ok');
  583. }
  584. }