gaoyixia/application/api/controller/Video.php

<?php
namespace app\api\controller;
use app\common\model\UserCollect;
use app\common\model\UserSearch;
use app\common\model\UserVideo;
use app\common\model\VideoCate;
use app\common\model\VideoComment;
use app\common\model\VideoCommentLike;
use app\common\model\VideoIntro;
use app\common\model\VideoLabel;
use app\common\model\VideoUrl;
use library\tools\Data;
/**
 * @title 视频
 * @controller Video
 * @group base
 */
class Video extends Base
{

    protected $need_login = ['userReferVideo','userReferVideoDetail','delUserVideo','videoComment','secondCommend','videoTags','videoTransmit','getMyVideoList'];// 需要登录的

    public function initialize()
    {
        parent::initialize();
        parent::setUid();
        if(in_array($this->request->action(),$this->need_login))parent::checkLogin();
    }

    /**
     * @title 获取分类
     * @desc  获取分类（共两级）
     * @author  qc
     * @url /api/Video/getCateTree
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @return name:id type:int default:-- desc:分类id
     * @return name:logo type:string default:-- desc:图标
     * @return name:title type:string default:0 desc:分类名称
     * @return name:children type:array default:0 desc:下级分类
     */
    public function getCateTree()
    {
        $list = VideoCate::where(['is_deleted'=>0])->field('id,logo,title,pid')->order('sort desc')->select()->toArray();
        $list =  make_tree($list);
        $this->success('ok',['list'=>$list]);
    }

    /**
     * @title 获取视频标签
     * @desc  获取视频标签
     * @author  qc
     * @url /api/Video/getVideoLabel
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @return name:id type:int default:-- desc:id
     * @return name:title type:string default:0 desc:标题
     */
    public function getVideoLabel()
    {
        $list = VideoLabel::field('id,title')->where(['is_deleted'=>0,'status'=>1])->select()->toArray();
        $this->success('',['list'=>$list]);
    }

    /**
     * @title 获取视频列表(平台发布)
     * @desc 获取视频列表
     * @author qc
     * @method GET
     * @url /api/Video/getVideoList
     * @header name:Authorization require:1 desc:Token
     * @param  name:type type:int default:0 desc:类型1单个2系列
     * @param  name:is_tj type:int default:0 desc:是否推荐0否1是
     * @param  name:is_hot type:int default:0 desc:是否置顶0否1是
     * @param  name:title type:string default:-- desc:标题
     * @param  name:first_classify type:int default:0 desc:视频一级分类
     * @param  name:second_classify type:int default:0 desc:视频二级分类
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     * @return name:title type:string default:-- desc:标题
     * @return name:cover type:string default:-- desc:封面
     * @return name:video_url type:string default:-- desc:视频地址
     * @return name:first_classify type:int default:-- desc:视频一级分类
     * @return name:second_classify type:int default:-- desc:视频二级分类
     * @return name:is_top type:int default:-- desc:是否置顶（0否，1是）
     * @return name:is_vip type:int default:-- desc:是否是vip（0否，1是）
     * @return name:is_over type:int default:-- desc:是否完结（0否，1是）
     * @return name:label_name type:array default:-- desc:标签
     * @return name:read_num type:int default:-- desc:播放量
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:video_arr type:array default:-- desc:视频地址
     * @return name:video_arr.url type:string default:-- desc:视频地址
     */
    public function getVideoList()
    {
        $sel_where  = [];
        $sel_where[]  = ['is_deleted','=',0];
        $sel_where[]  = ['status','=',1];
        $title = input('get.title');
        $type = input('get.type',0);
        $is_hot = input('get.is_hot');
        $first_classify = input('get.first_classify');
        $second_classify = input('get.second_classify');
        $sort_type = input('get.sort_type',1);
        $is_tj = input('get.is_tj',0);
        if($title && $this->user_id) UserSearch::create(['user_id'=>$this->user_id,'title'=>$title]);
        if($title)  $sel_where[]  = ['title','like','%'.$title.'%'];
        if($first_classify)  $sel_where[]  = ['first_classify','=',$first_classify];
        if($second_classify)  $sel_where[]  = ['second_classify','=',$second_classify];
        if($type)  $sel_where[]  = ['type','=',$type];
        if($is_hot)  $sel_where[]  = ['is_hot','=',$is_hot];
        $where_str = 'id > 0';
        if($is_tj) {
            $search_log =    UserSearch::where([['user_id','=',$this->user_id]])->order('id desc')->limit(0,10)->column('title');
            $search_arr = [];
            foreach ($search_log as $t){
                $search_arr[] =  " title like '".'%'.$t."%'" .' ';
            }
            if(!empty($search_arr)) $where_str  =  implode(' OR ',$search_arr);
        }
        $order = 'is_top desc,sort desc ,id desc';
        if($sort_type == 2)$order = 'id asc';
        if($sort_type == 3)$order = 'id desc';
        $list = VideoIntro::with(['videoArr'])->where($sel_where)
            ->where($where_str)
            ->order($order)
            ->limit($this->off_set,$this->page)->select()->toArray();
        array_walk($list,function (&$v,$k){
            $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,1,$v['id']);
            $v['label_name'] = VideoLabel::where('id','in', trim($v['label'],','))->column('title');
        });
        $this->success('ok',['list'=>$list]);
    }

    /**
     * @title 获取视频详情(平台)
     * @desc 获取视频详情
     * @author qc
     * @method GET
     * @url /api/Video/getVideoDetail
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:int default:0 desc:视频id
     * @return name:title type:string default:-- desc:标题
     * @return name:cover type:string default:-- desc:封面
     * @return name:video_url type:string default:-- desc:视频地址
     * @return name:first_classify type:int default:-- desc:视频一级分类
     * @return name:is_top type:int default:-- desc:是否置顶（0否，1是）
     * @return name:read_num type:int default:-- desc:播放量
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:video_url type:array default:-- desc:视频地址
     * @return name:video_url.url type:string default:-- desc:视频地址
     * @return name:video_url.transmit_num type:int default:-- desc:转发量
     * @return name:video_url.read_num type:int default:-- desc:播放量
     * @return name:video_url.is_vip type:int default:-- desc:是否是需要会员（0否1是）
     */
    public function getVideoDetail()
    {
        $sel_where  = [];
        $sel_where[]  = ['is_deleted','=',0];
        $sel_where[]  = ['status','=',1];
        $sel_where[]  = ['id','=',input('get.id')];
        $detail = VideoIntro::with(['videoUrl'])->where($sel_where)
            ->order('is_top desc,sort desc ,id desc')->find();
        if(!$detail)$this->error('该视频已下线');
        $detail['label_name'] = [];
        if($detail['label']) {
            $detail['label_name'] = VideoLabel::where('id','in', trim($detail['label'],','))->column('title');
        }
        $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,1,$detail->id);
        $this->success('ok',['detail'=>$detail]);
    }

    /**
     * @title 获取视频列表(用户发布【审核通过的】)
     * @desc 用户发布【审核通过的】
     * @author qc
     * @method GET
     * @url /api/Video/getUserVideoList
     * @header name:Authorization require:1 desc:Token
     * @param  name:title type:string default:-- desc:标题
     * @param  name:first_classify type:int default:0 desc:视频一级分类
     * @param  name:second_classify type:int default:0 desc:视频二级分类
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:title type:string default:-- desc:标题
     * @return name:cover type:string default:-- desc:封面
     * @return name:video_url type:string default:-- desc:视频地址
     * @return name:first_classify type:int default:-- desc:视频一级分类
     * @return name:second_classify type:int default:-- desc:视频二级分类
     * @return name:read_num type:int default:-- desc:播放量
     * @return name:is_collect type:int default:-- desc:是否收藏
     */
    public function getUserVideoList()
    {
        $sel_where  = [];
        $sel_where[]  = ['is_deleted','=',0];
        $sel_where[]  = ['status','=',1];
        $title = input('get.title');
        $first_classify = input('get.first_classify');
        $second_classify = input('get.second_classify');
        if($title)  $sel_where[]  = ['v.title','like','%'.$title.'%'];
        if($first_classify)  $sel_where[]  = ['v.first_classify','=',$first_classify];
        if($second_classify)  $sel_where[]  = ['v.second_classify','=',$second_classify];
        $list = UserVideo::field('v.*')->where($sel_where)->order('v.id desc')
            ->alias('v')
            ->leftJoin('User u','u.id = v.user_id')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        $this->success('ok',['list'=>$list]);
    }


    /**
     * @title 获取我的视频列表
     * @desc 获取我的视频列表
     * @author qc
     * @method GET
     * @url /api/Video/getMyVideoList
     * @header name:Authorization require:1 desc:Token
     * @param  name:title type:string default:-- desc:标题
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:title type:string default:-- desc:标题
     * @return name:cover type:string default:-- desc:封面
     * @return name:video_url type:string default:-- desc:视频地址
     * @return name:first_classify type:int default:-- desc:视频一级分类
     * @return name:second_classify type:int default:-- desc:视频二级分类
     * @return name:read_num type:int default:-- desc:播放量
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
     */
    public function getMyVideoList()
    {
        $sel_where  = [];
        $sel_where[]  = ['is_deleted','=',0];
        $sel_where[]  = ['user_id','=',$this->user_id];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['v.title','like','%'.$title.'%'];
        $list = UserVideo::where($sel_where)->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        $this->success('ok',['list'=>$list]);
    }


    /**
     * @title 获取视频详情(会员)
     * @desc 获取视频详情
     * @author qc
     * @method GET
     * @url /api/Video/getUserVideoDetail
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:int default:0 desc:视频id
     * @param  name:first_classify type:int default:0 desc:视频一级分类
     * @param  name:second_classify type:int default:0 desc:视频二级分类
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:title type:string default:-- desc:标题
     * @return name:cover type:string default:-- desc:封面
     * @return name:video_url type:string default:-- desc:视频地址
     * @return name:first_classify type:int default:-- desc:视频一级分类
     * @return name:second_classify type:int default:-- desc:视频二级分类
     * @return name:read_num type:int default:-- desc:播放量
     * @return name:is_collect type:int default:-- desc:是否收藏
     */
    public function getUserVideoDetail()
    {
        $detail = UserVideo::where('id',input('get.id'))->find();
        if(!$detail)$this->error('该视频已下线');
        if($detail->status != 1)$this->error('该视频未通过审核');
        $detail->is_collect = UserCollect::checkCollectByType($this->user_id,2,$detail->id);
        $this->success('ok',['detail'=>$detail->toArray()]);
    }

    /**
     * @title 用户提交或修改视频
     * @desc 用户提交或修改视频
     * @author qc
     * @method POST
     * @url /api/Video/userReferVideo
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:id(修改时必传)
     * @param name:title type:string default:-- desc:标题
     * @param name:video_url type:string default:-- desc:视频地址
     * @param name:desc type:string default:-- desc:简介
     * @param name:first_classify type:int default:-- desc:视频一级分类id
     * @param name:second_classify type:int default:-- desc:视频二级分类id
     * @param name:label type:string default:-- desc:视频标签id(多个用逗号隔开)
     */
    public function userReferVideo()
    {
        $id = input('post.id');
        $title = input('post.title');
        $desc = input('post.desc');
        $video_url = input('post.video_url');
        $cover = $video_url.'?x-oss-process=video/snapshot,t_2000,m_fast';
        $first_classify = input('post.first_classify',0);
        $second_classify = input('post.second_classify',0);
        $label = input('post.label');
        if(!$video_url) $this->error('请上传视频');
        if($id){
            $check_status = UserVideo::where('id',$id)->value('status');
            if($check_status == 1) $this->error('视频已审核通过，不允许修改');
        }
        $data = [
            'title ' => $title,
            'cover ' => $cover,
            'desc ' => $desc,
            'first_classify ' => $first_classify,
            'second_classify ' => $second_classify,
            'video_url ' => $video_url,
            'label ' => $label,
        ];
        if($id)  $data['id'] =  $id;
        (new UserVideo())->save($data);
        $this->success('提交成功，请等待审核');
    }

    /**
     * @title 获取用户提交视频详情
     * @desc 获取用户提交视频详情
     * @author qc
     * @method GET
     * @url /api/Video/userReferVideoDetail
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:id
     * @return name:title type:string default:-- desc:标题
     * @return name:cover type:string default:-- desc:封面
     * @return name:video_url type:string default:-- desc:视频地址
     * @return name:first_classify type:int default:-- desc:视频一级分类id
     * @return name:second_classify type:int default:-- desc:视频二级分类id
     * @return name:label type:string default:-- desc:视频标签id(多个用逗号隔开)
     */
    public function userReferVideoDetail()
    {
        $detail = UserVideo::where('id',input('get.id'))->find()->toArray();
        if($detail['is_deleted'] == 1) $this->error('视频已删除');
        $detail['label_name'] = [];
        if($detail['label']) {
            $detail['label_name'] = VideoLabel::where('id','in', trim($detail['label'],','))->column('title');
        }
        $this->success('获取成功',['detail'=>$detail]);
    }

    /**
     * @title 用户删除视频记录
     * @desc 用户删除视频记录
     * @author qc
     * @method POST
     * @url /api/Video/delUserVideo
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:id
     */
    public function delUserVideo()
    {
        UserVideo::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
        $this->success('删除成功');
    }

    /**
     * @title 视频评论
     * @desc 视频评论
     * @author qc
     * @method POST
     * @url /api/Video/videoComment
     * @header name:Authorization require:1 desc:Token
     * @param name:video_type type:int default:1 desc:视频类型（1平台2会员)
     * @param name:video_id type:int default:-- desc:视频id
     * @param name:url_id type:int default:-- desc:平台类型必传
     * @param name:content type:string default:-- desc:内容
     */
    public function videoComment()
    {
        $video_type = input('post.video_type',1);
        $video_id = input('post.video_id');
        $url_id = input('post.url_id',0);
        $content = input('post.content',0);
        if(!$content) $this->error('请输入评论内容');
        VideoComment::create(['user_id'=>$this->user_id,'content'=>$content,'video_id'=>$video_id,'url_id'=>$url_id,'video_type'=>$video_type]);;
        $this->success('评论成功');
    }

    /**
     * @title 视频二级评论
     * @desc 视频二级评论
     * @author qc
     * @method POST
     * @url /api/Video/secondCommend
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:评论id
     * @param name:content type:string default:-- desc:内容
     */
    public function secondCommend()
    {
        $comment = VideoComment::where('id',input('post.id'))->find()->toArray();
        unset($comment['id']);
        unset($comment['create_at']);
        $comment['pid'] = input('post.id');
        $comment['content'] = input('post.content');
        $comment['lev']++;
        if(!$comment['source_id']) $comment['source_id'] = input('post.id');
        VideoComment::create($comment);
        $this->success('评论成功');
    }

    /**
     * @title 获取视频评论列表
     * @desc 获取视频评论列表
     * @author qc
     * @method GET
     * @url /api/Video/getVideoCommentList
     * @header name:Authorization require:1 desc:Token
     * @param name:video_type type:int default:1 desc:视频类型（1平台2会员)
     * @param name:video_id type:int default:-- desc:视频id
     * @param name:url_id type:int default:-- desc:平台类型必传
     * @param name:page type:int default:-- desc:页数
     * @return name:name type:string default:-- desc:会员名称
     * @return name:headimg type:string default:-- desc:会员头像
     * @return name:content type:string default:-- desc:内容
     * @return name:children type:array default:-- desc:二级评论（数据同上）
     * @return name:like_num type:int default:-- desc:点赞数量
     * @return name:is_like type:int default:-- desc:是否点赞（0否1是）
     * @return name:total_num type:int default:-- desc:总评论数（仅一级）
     */
    public function getVideoCommentList()
    {
        $where = [];
        $where[] = ['c.video_id','=',input('get.video_id')];
        $where[] = ['c.video_type','=',input('get.video_type')];
        $where[] = ['c.pid','=',0];
        $where[] = ['c.is_deleted','=',0];
        $user_id = $this->user_id;
        $list  =VideoComment::where($where)
            ->field('c.*,u.name,u.headimg')
            ->leftJoin('User u','u.id = c.user_id')
            ->order('c.id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        array_map(function (&$val)use($user_id){
            $children = VideoComment::where(['pid'=>$val['id'],'is_deleted'=>0])
                ->field('c.*,u.name,u.headimg')
                ->leftJoin('User u','u.id = c.user_id')
                ->order('c.id asc')
                ->select()->toArray();
            $val['like_num'] = VideoCommentLike::where('like_id',$val['id'])->count();
            $val['children'] =  $children;
            $val['is_like'] =  VideoCommentLike::where(['like_id'=>$val['id'],'user_id'=>$user_id])->count();
        },$list);
        $total_num  = VideoComment::where($where)->count();
        $this->success('ok',['list'=>$list,'total_num'=>$total_num]);
    }

    /**
     * @title 点赞||取消点赞
     * @desc 点赞||取消点赞
     * @author qc
     * @method POST
     * @url /api/Video/videoTags
     * @header name:Authorization require:1 desc:Token
     * @param name:type type:int default:1 desc:1评论点赞，评论记录id(一级)二级评论不要这个功能，2平台视频点赞，3会员视频点赞
     * @param name:like_id type:int default:1 desc:点赞id【二级评论不要这个功能】
     * @return name:tags type:int default:1 desc:0取消成功，1点赞成功
     */
    public function videoTags()
    {
        $type = input('post.type',1);
        $like_id = input('post.like_id');
        $ret_val = 0;
        $check_tags =  VideoCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type])->value('id');
        if($check_tags) {
            VideoCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type])->delete();
        }else{
            Data::save('VideoCommentLike',
                ['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type],'user_id',
                ['user_id'=>$this->user_id,'like_id'=>$like_id,'type'=>$type]);
            $ret_val = 1;
        }
        $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
    }


    /**
     * @title 视频转发（转发数量统计）
     * @desc 转发成功后调用
     * @author qc
     * @method POST
     * @url /api/Video/videoTransmit
     * @header name:Authorization require:1 desc:Token
     * @param name:video_type type:int default:1 desc:视频类型（1平台2会员)
     * @param name:video_id type:int default:-- desc:视频id
     * @param name:url_id type:int default:-- desc:平台类型必传
     */
    public function videoTransmit()
    {
        $video_type = input('post.video_type',1);
        $video_id = input('post.video_id');
        $url_id = input('post.url_id',0);
        if($video_type == 1) {
            VideoUrl::where('id',$url_id)->setInc('transmit_num');
        }else{
            UserVideo::where('id',$video_id)->setInc('transmit_num');
        }
        $this->success('ok');
    }

    /**
     * @title 视频播放（播放数量统计）
     * @desc 播放数量统计
     * @author qc
     * @method POST
     * @url /api/Video/videoPlay
     * @header name:Authorization require:1 desc:Token
     * @param name:video_type type:int default:1 desc:视频类型（1平台2会员)
     * @param name:video_id type:int default:-- desc:视频id
     * @param name:url_id type:int default:-- desc:平台类型必传
     */
    public function videoPlay()
    {
        $video_type = input('post.video_type',1);
        $video_id = input('post.video_id');
        $url_id = input('post.url_id',0);
        if($video_type == 1) {
            VideoUrl::where('id',$url_id)->setInc('read_num');
        }else{
            UserVideo::where('id',$video_id)->setInc('read_num');
        }
        $this->success('ok');
    }





}