universesupermarket_api/application/api/controller/Timedtask.php

<?php


namespace app\api\controller;
use AlibabaCloud\Client\AlibabaCloud;
use AlibabaCloud\Client\Exception\ClientException;
use AlibabaCloud\Client\Exception\ServerException;
use think\cache\driver\Redis;
use think\Db;
use think\Exception;

/**
 * @title 定时任务
 * Class Timedtask
 * @controller Timedtask
 * @group base
 */
class Timedtask
{
    /**
     * @title 取消订单定时任务
     * @desc  未支付的自动取消
     * @author  Gavin
     * @url /api/Timedtask/cancelGoodsOrder
     * @method GET
     */
    public function cancelGoodsOrder(){
        $CancelTime = getCancelTime();
        if ($CancelTime<=0){
            die;
        }
        $redis = new Redis();
        $users = $redis->hkeys('buyUserInfo');
        if ($users){
            foreach ($users as &$value){
                $key = 'order_not_pay_'.$value;
                $len = $redis->hGetLen($key);
                if ($len){
                    $list = $redis->hGetvals($key);
                    foreach ($list as &$a){
                        $info = json_decode($a,true);
                        $cancel_time = strtotime($info['create_at'])+($CancelTime*60);
                        if ($cancel_time<time()){
                            $info['status'] = 2;
                            $info['cancel_at'] = date('Y-m-d H:i:s');
                            Db::name('store_order')->insert($info);
                            //加上库存
                            addCollectionInventory($info['c_id'],$info['num']);
                            //减少用户购买数量
                            DecrByCount($info['mid'],$info['c_id'],$info['num']);
                            //删除数据
                            $redis->hdel($key,$info['order_no']);
                        }
                    }
                }else{
                    $redis->hdel('buyUserInfo',$value);
                }
            }
        }
    }


    /**
     * @title 二级市场未支付的自动取消
     * @desc  二级市场未支付的自动取消
     * @author  Gavin
     * @url /api/Timedtask/SecondaryancelGoodsOrder
     * @method GET
     */
    public function SecondaryancelGoodsOrder(){
        $CancelTime = getConfigValue('secondary_cancel_time');
        if ($CancelTime<=0){
            die;
        }
        $list = Db::name('store_order_info_order')->where('status',0)->select();
        foreach ($list as &$v){
            $cancel_time = strtotime($v['create_at'])+($CancelTime*60);
            if ($cancel_time<time()){
                $info['status'] = 2;
                $info['cancel_at'] = date('Y-m-d H:i:s');
                Db::name('store_order_info_order')->where('id',$v['id'])->update($info);

                $cancle = [
                    'mid'=>$v['mid'],
                    'order_id'=>$v['id']
                ];
                Db::name('store_order_info_cancel_log')->insert($cancle);

                $time = date('Y-m-d H:i:s',time()-(60*60));
                $count = Db::name('store_order_info_cancel_log')->where('mid',$v['mid'])->where('create_at','gt',$time)->count();
                if ($count>2){
                    $buy_time = date('Y-m-d H:i:s',time()+(24*60*60));
                    Db::name('store_member')->where('id',$v['mid'])->update(['buy_time'=>$buy_time]);
                }
            }
        }
    }

    /**
     * 藏品铸造hash 定时任务
     * @url /api/Timedtask/castingHash
     */
    public function castingHash(){
        set_time_limit(0);
        $redis = new Redis();
        $list = Db::name('store_collection')->where('is_deleted',0)->select();
        $id = 0;
        $set_count = 0;
        foreach ($list as &$v){
            $count = $redis->get('castingHash_'.$v['id']);
            if ($count && $count>0){
                $id = $v['id'];
                $set_count = $count;
                break;
            }
        }

        if ($id){
            if ($this->redisCreateSetNx($id)){
                $account ='7ae68031830b48b5eeab6ea8c1adddd905502ea7d68f9ba51505744be4df59dd';
                $addr = Db::name('store_collection')->where('id',$id)->value('cover');
                for ($i=0;$i<$set_count;$i++){
                    if ($i<$set_count){
                        $url =getIpAddress()."IssueAddr?account=".$account."&nftId=".$id."&tokenUrl=".$addr;
                        $res=curlRequest($url);
                        $result=json_decode($res,true);
                        if (isset($result) && $result['code']=='200'){
                            $data['goods_id']=$id;
                            $data['hash']=$result['result']['txHash'];
                            $data['tokenid'] = $result['result']['tokenId'];
                            if (Db::name('hash')->insert($data)){
                                $redis->Decr('castingHash_'.$id);  //减一
                                //存入reids list
                                $redis_data = ['hash'=>$data['hash'],'tokenid'=>$data['tokenid'],'create_at'=>date('Y-m-d H:i:s')];
                                $redis->rPush('collectionHash_'.$id,json_encode($redis_data));
                            }
                        }
                    }else{
                        $redis->del('hash_'.$id);
                    }
                }
            }
        }else{
            $redis->del('hash_'.$id);
        }

    }

    /**
     * 发放hash
     * @url /api/Timedtask/sendHash
     */
    public function sendHash(){
        set_time_limit(0);
        Db::name('store_order_info')
            ->whereNotNull('company_hash')
            ->whereIn('status','1,3')
            ->where('company_hash','neq','')
            ->where('collectors_hash','eq','')
            ->chunk(50,function ($list){
                foreach ($list as &$v){

                    if ($v['status']==1){
                        $from = '7ae68031830b48b5eeab6ea8c1adddd905502ea7d68f9ba51505744be4df59dd';
                    }elseif ($v['status']==3){
                        $from = Db::name('store_member')->where('id',$v['to_mid'])->value('wallet_address');
                    }

                    $to = Db::name('store_member')->where('id',$v['mid'])->value('wallet_address');
                    $url=getIpAddress()."transferFrom?from=".$from."&to=".$to."&tokenId=".$v['ddcid'];
                    $res =curlRequest($url);
                    $result=json_decode($res,true);
                    //dump($result);
                    if (isset($result) && $result['code']=='200'){
                        Db::name('store_order_info')->where('id',$v['id'])
                            ->update(['collectors_hash'=>$result['result']['txHash'],'collectors_hash_time'=>date('Y-m-d H:i:s')]);
                    }
                }
        },'id','asc');
    }



    /**
     * @title 创建链账户
     * @desc  创建链账户
     * @author  Gavin
     * @url /api/Timedtask/createAddress
     * @method GET
     */
    public function createAddress(){
        set_time_limit(0);
        $member = Db::name('store_member')
            ->where('wallet_address','eq','')
            ->field('id,phone,wallet_address')
            ->order('id asc')
            ->limit(500)
            ->select();
        foreach ($member as &$v){
            $phone = $v['phone'];
            $wallet_address = getWalletAddress($phone);
            if ($wallet_address){
                Db::name('store_member')->where('id',$v['id'])->update(['accountName'=>$phone,'wallet_address'=>$wallet_address]);
            }else{
                $phone = $v['phone'].rand(10000,99999);
                $wallet_address = getWalletAddress($phone);
                if ($wallet_address){
                    Db::name('store_member')->where('id',$v['id'])->update(['accountName'=>$phone,'wallet_address'=>$wallet_address]);
                }
            }
        }

    }

    /**
     * redis 加锁
     */
    function redisCreateSetNx($id){
        $redis = new Redis();
        $key = 'hash_'.$id;
        $exptime = 5;
        $is_lock = $redis->setnx($key,time()+$exptime);
        if ($is_lock){
            return true;
        }else{
            //加锁失败的情况下，判断锁是否已经存在，如果存在切已经过期，删除锁，重新加锁
            $val = $redis->get($key);
            if ($val && $val<time()){
                $redis->del($key);
            }
            return $redis->setnx($key,time()+$exptime);
        }
    }


}