toupiaoh5/application/api/controller/Subject.php

<?php

namespace app\api\controller;

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



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

        $find = Db::name('vote_subject')->where('id',1)->find();
        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(); //选手不多，看看不加分页了，直接缓存10秒

//        $button = 'answer';
        //当前用户手里有票，按钮：投票
        //用户手里没有票，但是今天还能答题，按钮：答题加票
        /*$user_votes = Db::name('user_wallet')->where('user_id',$this->auth->id)->value('votes');
        $user_question_count = Db::name('user_question_log')->where('user_id',$this->auth->id)->whereTime('createtime','today')->count('id');
        $exam_times_user_eday = config('site.exam_times_user_eday');
        if($user_votes == 0 && $user_question_count <= $exam_times_user_eday){
            $button = 'answer';
        }*/
        //以上两者都没有，按钮：投票

        foreach($lists as $key => $val){

            $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';
            }

//            $val['button'] = $button;

            $lists[$key] = $val;
        }

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

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

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

        $map = [
            'player_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';
        }

        //名次
        /*$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) );

        //今日投票记录
        $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;
    }
}