toupiaoh5/application/api/controller/Subject.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;
use think\cache;
use app\utils\RedisKeyEnum;
use app\utils\RedisUtil;
/**
 * 投票
 */
class Subject extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];



    //进行中的唯一一个投票活动
    public function info(){

        $find = Db::name('vote_subject')->where('id',1)->find();
        $find['image'] = localpath_to_netpath($find['image']);
        if(!$find){
            $this->error('没有进行中的投票活动');
        }

        $this->success(1,$find);
    }

    //作品页，选手列表
    public function playerlist(){
        $subject_id = 1;

        $map = [
            'subject_id' => $subject_id,
            'status' => 1,
        ];

        //搜索
        $keyword = input('keyword','');
        if($keyword){
            $map['title|suozaidanwei|tuijiangonghui'] = ['LIKE','%'.$keyword.'%'];
        }

        //选手列表
        $lists = Db::name('vote_player')
            ->where($map)->order('votes desc,id desc')->autopage()->select();

        foreach($lists as $key => $val){
            $val['video_file'] = localpath_to_netpath($val['video_file']);

            $val['video_thumb'] = '';
            if(!empty($val['video_file'])){
                $val['video_thumb'] = $val['video_file'].'?x-oss-process=video/snapshot,t_0,m_fast,f_jpg';
            }

            $lists[$key] = $val;
        }

        //$lists = $this->mingci($subject_id,$lists);

        //今日剩余票数
        $today_my_vote = 0;
        if($this->auth->isLogin()){
            //今天,投了几票
            $today_record = RedisUtil::getInstance(RedisKeyEnum::VOTE_RECORD.date('Y-m-d').':'.$this->auth->id)->get();
            //今天,免费的的票
            $gift_votes = config('site.gift_votes_user_eday');
            //今天，用户答对的次数，也就是答题获得的票数
            $question_vote  = RedisUtil::getInstance(RedisKeyEnum::EAXM_RIGHT.date('Y-m-d').':'.$this->auth->id)->get();
            //今日剩余票数
            $today_my_vote = $gift_votes + $question_vote - $today_record;
        }

        //
        $result = [
            'today_my_vote' => $today_my_vote,
            'players'       => $lists,
        ];

        $this->success(1,$result);
    }

    //选手详情
    public function playerinfo(){
        $player_id = input('player_id','');
        if(!$player_id){
            $this->error();
        }

        $map = [
            'id' => $player_id,
        ];

        $info = Db::name('vote_player')->where($map)->find();

        $info['video_thumb'] = '';
        if(!empty($info['video_file'])){
            $info['video_file']  = localpath_to_netpath($info['video_file']);
            $info['video_thumb'] = $info['video_file'].'?x-oss-process=video/snapshot,t_0,m_fast,f_jpg';
        }

        //获取播放地址和秒数
        $videoVod = new \app\common\library\Video();
        $video_PlayInfo = $videoVod->getPlayInfo($info['vodid']);
        $video_PlayInfo = $video_PlayInfo->PlayInfoList->PlayInfo;

        $info['video_file'] = $video_PlayInfo[0]->PlayURL;
        $info['video_seconds'] = ceil($video_PlayInfo[0]->Duration);

        //名次
        /*$players = Db::name('vote_player')->where(['subject_id'=>$info['subject_id'],'status'=>1])->order('votes desc,id desc')->column('id,votes');
        $id_arr = array_keys($players);
        $mingci = 1;  //名次
        $mingci = array_search($info['id'],$id_arr);
        $mingci++;
        $info['mingci'] = $mingci;*/

        $this->success(1,$info);
    }

    //用户详细资料
    public function getuserinfo(){
        $info = $this->auth->getUserinfo();

        //今天,投了几票
        $today_record = RedisUtil::getInstance(RedisKeyEnum::VOTE_RECORD.date('Y-m-d').':'.$this->auth->id)->get();
        //今天,免费的的票
        $gift_votes = config('site.gift_votes_user_eday');
        //今天，用户答对的次数，也就是答题获得的票数
        $question_vote  = RedisUtil::getInstance(RedisKeyEnum::EAXM_RIGHT.date('Y-m-d').':'.$this->auth->id)->get();

        //基础票数
        $jcps = $gift_votes - $today_record;
        if($jcps < 0){
            $jcps = 0;
        }

        //答题票数
        $dtps = $question_vote - ( ($today_record - $gift_votes) <= 0 ? 0 : ($today_record - $gift_votes) );
        if($dtps < 0){
            $dtps = 0;
        }

        //今日投票记录
        $player_ids = Db::name('vote_record')->where('user_id',$this->auth->id)->where('createdate',strtotime(date('Y-m-d')))->column('player_id');
        $map = [
            'status' => 1,
            'id' => ['IN',$player_ids]
        ];
        $lists = Db::name('vote_player')->field('id,title,votes')
            ->where($map)->order('votes desc,id desc')->select();

        //
        $result = [
            'info' => $info,
            'jcps' => $jcps,
            'dtps' => $dtps,
            'lists' => $lists,
        ];

        $this->success(1,$result);
    }

    //选手票数排行榜，按票
    public function playerlist_votes(){
        $subject_id = 1;

        $map = [
            'subject_id' => $subject_id,
            'status'     => 1,
        ];

        $lists = Db::name('vote_player')->field('id,title,votes')
            ->where($map)->order('votes desc,id desc')->autopage()->select();

        $lists = $this->mingci_vote($subject_id,$lists);

        $this->success(1,$lists);
    }

    //选手票数排行榜，按分
    public function playerlist_score(){
        $subject_id = 1;

        $map = [
            'subject_id' => $subject_id,
            'status'     => 1,
        ];

        $lists = Db::name('vote_player')->field('id,title,score')
            ->where($map)->order('score desc,id desc')->autopage()->select();

        $lists = $this->mingci_score($subject_id,$lists);

        $this->success(1,$lists);
    }

    //oss视频截贞 https://www.alibabacloud.com/help/zh/oss/user-guide/video-snapshots?spm=a2c63.p38356.0.0.6aaa4b78aOSpJH
    //使用fast模式截取视频7s处的内容，输出为JPG格式的图片，宽度为800，高度为600。
    //处理后的URL为：https://oss-console-img-demo-cn-hangzhou.oss-cn-hangzhou.aliyuncs.com/video.mp4?x-oss-process=video/snapshot,t_7000,f_jpg,w_800,h_600,m_fast


    //获得我的名次,票数导向
    private function mingci_vote($subject_id,$list){

        if(empty($list)){
            return $list;
        }
        //准备数据
        $players = Db::name('vote_player')->where(['subject_id'=>$subject_id,'status'=>1])->order('votes desc,id desc')->column('id,votes');
        $id_arr = array_keys($players);

        foreach($list as $key => $val)
        {
            $mingci = 1;  //名次
            $mingci = array_search($val['id'],$id_arr);
            $mingci++;

            //赋值名次
            $list[$key]['mingci'] = $mingci;
        }

        return $list;
    }

    //获得我的名次,分数导向
    private function mingci_score($subject_id,$list){

        if(empty($list)){
            return $list;
        }
        //准备数据
        $players = Db::name('vote_player')->where(['subject_id'=>$subject_id,'status'=>1])->order('score desc,id desc')->column('id,score');
        $id_arr = array_keys($players);

        foreach($list as $key => $val)
        {
            $mingci = 1;  //名次
            $mingci = array_search($val['id'],$id_arr);
            $mingci++;

            //赋值名次
            $list[$key]['mingci'] = $mingci;
        }

        return $list;
    }
}