kge/application/index/controller/Plantask.php

<?php

namespace app\index\controller;

use think\Controller;

use Redis;
use think\Db;
use app\common\library\Easemob;
class Plantask extends Controller
{
    //关于本文件里的计划任务
    //只有 public 方法，auto_开头的才是计划任务，其他private 方法都是工具方法

////////////////////////////////////////下面都是计划任务方法///////////////////////////////////////////////////////////////
    //自动删除3天前的爆币日志，提升统计速度
    public function auto_del_baobi_log(){
        $today_start = strtotime(date('Y-m-d')) - (86400 * 3);

        $map = [
            'createtime' => ['lt',$today_start],
        ];
        Db::name('gift_baobi_log')->where($map)->delete();
    }

    //送礼物(api/party/giveGiftToYou)拆分出来的异步用户升级方法,


    //最新方法
    public function auto_user_level_up(){
        Db::startTrans();

        $tasklist = Db::name('gift_user_party')->where('task_status',0)->order('id asc')->field('party_id')->select();

        if(empty($tasklist)){
            Db::rollback();
            echo 'empty';
            exit;
        }

        try {
            //redis
            $redis = new Redis();
            $redisconfig = config("redis");
            $redis->connect($redisconfig["host"], $redisconfig["port"]);
            if ($redisconfig['redis_pwd']) {
                $redis->auth($redisconfig['redis_pwd']);
            }
            if($redisconfig['redis_selectdb'] > 0){
                $redis->select($redisconfig['redis_selectdb']);
            }

            //开始
            $party_ids = array_column($tasklist,'party_id');
            $party_ids = array_flip($party_ids);
            $party_ids = array_flip($party_ids);
            //dump($party_ids);
            $partyInfo_arr = Db::name('party')->where('id','IN',$party_ids)->column('id,user_id,easemob_room_id');
            //dump($partyInfo_arr);exit;
            foreach($partyInfo_arr as $party_id => $partyInfo){
                //更新麦位魅力值
                $this->updateSeatCharm($partyInfo['easemob_room_id'],$partyInfo,$redis);
            }

            //结束
            $rs_up = Db::name('gift_user_party')->where('party_id','IN',$party_ids)->update(['task_status'=>1]);

            Db::commit();
        } catch (ValidateException $e) {
            Db::rollback();
            $this->error($e->getMessage());
        } catch (PDOException $e) {
            Db::rollback();
            $this->error($e->getMessage());
        } catch (Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }

    }

/////////////////////////////////////////下面都是工具方法////////////////////////////////////////////////

    /**
     *  用户赠送礼物后房间内麦位魅力值增加,更新到麦位自定义信息
     * $seatnum 座位数字 1，不是键名 seat1
     */
    private function updateSeatCharm($easemob_room_id,$party_info,$redis) {
        //获取已有信息

        $easemob = new Easemob();
        $seatlist = $easemob->room_getRoomCustomAttribute($easemob_room_id,['seat0','seat1','seat2','seat3','seat4','seat5','seat6','seat7']);

        if(empty($seatlist)){
            return true;
        }

        $matedata = [];

        // 获取用户魅力值
        $users = $redis->zRevRange("hourCharm_".$party_info['id'],0,-1,true);

        //轮询麦位
        foreach($seatlist as $seatnum => $seatdata){
            $seatdata = json_decode($seatdata,true);

            if($users) {
                foreach($users as $user_id => $charm){
                    if(isset($seatdata['userNo']) && $seatdata['userNo'] == $user_id){
                        $seatdata['charm'] = changeW($charm);
                    }
                }
            }

            $seatdata = json_encode($seatdata);

            $matedata[$seatnum] = $seatdata;

        }

        //重新设置麦位小红心
        //获取房间用户周前三名 getPartyUserTop里面摘出来的一部分
        //[环信]更新财富榜前3。
        $avatarArr = $redis->hGet("user_jewel_top3",$party_info['id']);
        $matedata['wealth_top3_userlist'] = $avatarArr;
        $easemob->room_setRoomCustomAttributeForced($easemob_room_id,$party_info['user_id'],$matedata);

        return true;
    }



}