new_sdk_wu/www/new_sdk/application/home/controller/Test.php

<?php
/**
 * 关于我们等页面 控制器
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/9/29
 * Time: 14:11
 */

namespace app\home\controller;

use app\common\model\Gift as GiftModel;
use app\api\complex\Naozhewan;
use app\api\complex\Zhaosy;
use app\common\model\Pay;
use app\api\complex\Jiuqu;
use app\api\controller\v1\Role;
use app\api\service\SpecialService;
use app\common\library\AirwallexPay;
use app\common\library\HuaweiObs;
use app\common\library\IpLimit;
use app\common\library\MakeReportGo;
use app\common\logic\PayCallback;
use app\service\PayService;
use app\service\WelfareService;
use think\Cache;
use think\Config;
use think\Controller;
use think\Env;
use think\Request;

class Test extends Controller
{

    public function getIdcard()
    {
        vendor('authSdk.Authentication', '.class.php');
        $auth = new \Authentication();
//{"ai":"100000000000000001","name":"某一一","idNum":"110000190101010001"}

//{"ai":"200000000000000001", "name":"某二一", "idNum":"110000190201010009"}


        $result = $auth->check('1101999999', '100000000000000001', '某一一', '110000190101010001');
//        {"errcode":0,"errmsg":"OK","data":{"result":{"status":0,"pi":"1fffbjzos82bs9cnyj1dna7d6d29zg4esnh99u"}}}

//        $result = $auth->check('1101999999', '200000000000000001', '某二一', '110000190201010009');
        //{"errcode":0,"errmsg":"OK","data":{"result":{"status":1,"pi":null}}}

        //{"ai":"100000000000000001","name":"某一一","idNum":"110000190101010001"}
//        $result = $auth->query($bizid = '1101999999', $ai = '100000000000000001');
        //{"errcode":0,"errmsg":"OK","data":{"result":{"status":0,"pi":"1fffbjzos82bs9cnyj1dna7d6d29zg4esnh99u"}}}


        //{"ai":"200000000000000001", "name":"某二一", "idNum":"110000190201010009"}
//        $result = $auth->query($bizid = '1101999999', $ai = '200000000000000001');
        //{"errcode":0,"errmsg":"OK","data":{"result":{"status":1,"pi":null}}}


        //{"ai":"  300000000000000001"}
//        $result = $auth->query($bizid = '1101999999', $ai = '  300000000000000001');
        //{"errcode":0,"errmsg":"OK","data":{"result":{"status":2,"pi":null}}}

        // 上线
//        $result = $auth->loginout($bizid = '1101999999','123',1,2, '123', '');

        // 下线
//        $result = $auth->loginout($bizid = '1101999999','123',0,0, '', '1fffbjzos82bs9cnyj1dna7d6d29zg4esnh99u');
        echo json_encode($result);
    }

    public function pay()
    {
        $pay = new AirwallexPay();
        $return_url = 'https://www.46yx.com/coin_airwallex/recharge.html';
        $pay->getToken();
//        $pay->createOrder();
        $s = $pay->createOrder(0.01, 'WL' . time(), $return_url);
        var_dump($s);
        die();
    }


    public function test()
    {
//        $data = [
//            "cp_order"=>"1079005143013437394030b59",
//            "extra"=>"123123",
//            "game_id"=>"6344",
//            "money"=>"10.00",
//            "pay_id"=>"g1589430140836000070",
//            "role_id"=>"437505",
//            "server_id"=>"6",
//            "time"=>"1589437933",
//            "to_uid"=>"100503",
//            "to_user"=>"rechargetest",
//            "user_id"=>"100503",
//            "username"=>"rechargetest",
//            "sign"=>"a163a9524b1ade5299da1260639ae80e",
//        ];
//        $polyChannelGame['param'] = '{"appid":14043,"appkey":"a23e431eb902f23d87659eba3bec8d48"}';
//        var_dump((new Zhaosy())->paySign($data,$polyChannelGame));die();

//        var_dump( auth_code(123456789, "ENCODE", AUTH_KEY));die();
//var_dump(  auth_code("Oy7g5Xb8l6k9G6/d9YJyMw67u1XUYZux4hb3M95CFfEAdyuZvfAaUr77vMCigUeoaUTQh+VDWNBJL8SExcIO5BH+f1PX", "DECODE", AUTH_KEY));die();
//        $str = "orderid=" . urlencode('WL16777361765118156666') . "&username=" . urlencode('yyh001') . "&gameid=" . '211' . "&roleid=" . urlencode('2871326237425402990') . "&serverid=" . urlencode('10201') . "&paytype=" . urlencode('old-zfb-wap') . "&amount=" . '6' . "&paytime=" . '1677736176' . "&attach=" . urlencode('M2023030213493237033');
//        $param = $str . "&appkey=" . urlencode('2ffcdd147a0e12eb96eddb192b81d309');
//        var_dump($param);
//        $md5params = md5($param);
//        $params = $str . "&sign=" . urlencode($md5params);
//var_dump($params);die();

//var_dump(getMonthRange('2023-02',false));die();

//        var_dump(isFrozenOption(3558, 178,'register'));
//        var_dump(isFrozenOption(3558, 178, 'member_login'));die();


//        var_dump( auth_code('Oy7g5Xb8l6k9G6/e8IVyYwnrtV/cPcqxtRz1Mt9KFfE', "DECODE", AUTH_KEY));die();
        $data = file_get_contents('php://input');
//       var_dump( $data,auth_code($data,"DECODE",AUTH_KEY));die();

        $decryptStr = $this->opensslDecrypt($data, 'erecNF1vp5Qphd8e');

        echo $decryptStr;
        die();

    }

    public function getTokens()
    {
        $data = input('data');
        var_dump(auth_code($data, "DECODE", Env::get('auth_key')));
    }

    public function getToken()
    {
        $userinfo['id'] = 123231;
        $userinfo['username'] = 'rfsdf';
        $gameid = '172';
        $sub_username = 'cdscdsfsf';
        $token_random = '3232323';
        $token = auth_code($userinfo['id'] . '|' . $userinfo['username'] . '|' . $gameid . '|' . $sub_username . '|' . $token_random . '|sdk', "ENCODE", Env::get('auth_key'));
        var_dump($token);
        var_dump(explode('|', auth_code($token, "DECODE", Env::get('auth_key'))));
        die();
    }

    public function specialCallback()
    {
        $callback_params = 'orderid=WL16613361248395341449&username=yyh001&gameid=158&roleid=78812993478984368&serverid=70&paytype=wx-wap&amount=68&paytime=1661336124&attach=221720220824181521945710673&sign=61bd84c842a36eb8d9d698b6f76ff597';
        (new PayCallback())->specialCallback($callback_params);
    }

    private function opensslDecrypt($data, $key, $method = 'AES-128-ECB')
    {

        try {
            $str = openssl_decrypt($data, $method, $key);

        } catch (\Exception $e) {

            $this->jsonResult('', 0, '接口参数解密失败' . $e->getMessage() . ',请检查参数格式!');
        }

        return $str;
    }

    public function download()
    {
        $makeReport = new MakeReportGo();
        $sql = 'test' . time();
        $makeReport->addTask('admin.memberCoinGetList', $sql, 1);
    }

    public function wefare()
    {
        $wefareService = new WefareService();
        $wefare = $wefareService->wefare(9, 187, 0);
        echo json_encode($wefare);
        exit();
        $game_id = 187;
        $grant_type_id = 8;
        $server_id = 2113;
        $serverid = 0;
        $welfare = model('Welfare')->whereRaw(sprintf('FIND_IN_SET(%s,game_id)', $game_id))
            ->where(['grant_type_id' => $grant_type_id])
//            ->where(['id' => 19])
            ->order('id desc')->find();
        $wefareService = new WefareService();
        if (!$welfare) {
            echo 'no welfare';
            exit();
        }
        $welfareGiftType = model('welfareGiftType')->where(['id' => $welfare['welfare_gift_type_id']])->find();
        if (!$welfareGiftType) {
            echo 'no welfareGiftType';
            exit();
        }

        $game_id = ['in', [187, 188]];
        $channel_id = ['in', [5354, 5434, 3550]];
        $start_time = strtotime(date('Y-m-d'));
        $end_time = strtotime(date('Y-m-d 23:59:59'));
        if (in_array($grant_type_id, [3, 4, 5, 8, 9])) {

            if ($welfareGiftType['type_id'] == 1) {

                switch ($welfareGiftType['time_type']) {
                    case 1: // 全部
                        $start_time = '';
                        $end_time = '';
                        break;
                    case 2: //当日
                        $start_time = strtotime(date('Y-m-d'));
                        $end_time = strtotime(date('Y-m-d 23:59:59'));
                        break;
                    case 3: //周
                        $start_time = mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y"));
                        $end_time = mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y"));
                        break;
                    case 4: //月
                        $start_time = mktime(0, 0, 0, date("m"), 1, date("Y"));
                        $end_time = mktime(23, 59, 59, date("m"), date("t"), date("Y"));
                        break;
                    case 5:  //季度
                        $season = ceil((date('n')) / 3);
                        $start_time = mktime(0, 0, 0, $season * 3 - 3 + 1, 1, date('Y'));
                        $end_time = mktime(23, 59, 59, $season * 3, date('t', mktime(0, 0, 0, $season * 3, 1, date("Y"))), date('Y'));
                        break;
                    case 6: //年
                        $start_time = strtotime(date('Y-01-01 00:00:00', time()));
                        $end_time = strtotime(date('Y-12-31 23:59:59', time()));
                        break;
                    case 7: //自定义
                        $start_time = strtotime(date('Y-m-d', $welfareGiftType['start_time']));
                        $end_time = strtotime(date('Y-m-d 23:59:59', $welfareGiftType['end_time']));
                        break;
                }
            } else {
                echo 'welfareGiftType error';
                exit();
            }

        } elseif (in_array($grant_type_id, [6])) {
            $gameServer = model('GameServer')->where(['game_id' => $game_id, 'id' => $server_id])->find();
            if (!$gameServer) {
                echo 'gameServer error';
                exit();
            }
            $serverid = $gameServer['serverid'];
            $start_time = strtotime(date('Y-m-d', $gameServer['create_time']));
            $end_time = strtotime(date('Y-m-d 23:59:59', $gameServer['create_time'] + 84600 * 7));
        } elseif (in_array($grant_type_id, [7])) {
            $start_time = '';
            $end_time = '';
        }

        $amount = $welfareGiftType['recharge_amount'];

        $members = $wefareService->getUserlistByGrantTypeGameChannelId($grant_type_id, $welfare, $game_id, $channel_id, $serverid, $start_time, $end_time, $amount, []);
        var_dump($members);
        $res = 'null';
        if ($members) {
            $res = $wefareService->saveWelfareGrant($members, $welfare, $grant_type_id);
        }

        var_dump($res);
    }


    public function redis()
    {
        exit("xxxx");

        $redis = new \Redis();

        $redis->connect(Env::get('redis.host', '127.0.0.1'), Env::get('redis.port', 6379));
        if (Env::get('redis.password', '')) {
            $redis->auth(Env::get('redis.password', ''));
        }

//        $redis->connect('123.60.79.32', 8887);
//
//        $redis->auth('Njqfwlkj1221');
        $redis->select(0);
        $iterator = null;
        for ($i = 0; $i < 5; $i++) {

            $res = $redis->scan($iterator, "aoyousdk_*", 10000);
            var_dump($iterator);

            var_dump($res);
//            if($res){
//                $tmp = [];
//                foreach ($res as $k=>$v){
////                    if( strlen(substr($v,9,32)) == 32 &&  $redis->get($v) == 1){
//
//                    $str = str_ireplace('aoyousdk_', '', $v);
////                    var_dump(preg_match("/^[a-z\d]*$/i",$str));
//                    if( strlen($str) == 32 && preg_match("/^[a-z\d]*$/i",$str)){
//                        $tmp[] = $v;
//                    }
//                }
//                if($tmp){var_dump($tmp);
////                    $redis->del($tmp);
//                }
//            }

//            var_dump($res);
        }


    }

    public function ip()
    {
        $ip = '68.205.25.162';
//        $ip = '125.77.44.192';
        $res = (new IpLimit())->validateIp($ip);

        var_dump($res);
        die();
    }

    public function clear()
    {
//        $parent_list  = model('Common/Channel')->getParentChannel();
//        Cache::clear('channel_cache');
        $welfareGiftType['time_type'] = 6;
        $data['cycle_id'] = 2;
        switch ($welfareGiftType['time_type']) {
            case 1: // 全部
                $start_time = '';
                $end_time = '';
                break;
            case 2: //当日

                if ($data['cycle_id'] == 1) { //今日
                    $start_time = strtotime(date('Y-m-d'));
                    $end_time = strtotime(date('Y-m-d 23:59:59'));
                } else { //昨日
                    $start_time = strtotime(date("Y-m-d")) - 86400;
                    $end_time = strtotime(date('Y-m-d')) - 1;
                }
                break;
            case 3: //周
                if ($data['cycle_id'] == 1) { //本周
                    $start_time = mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y"));
                    $end_time = mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y"));
                } else { //上周
                    $start_time = mktime(0, 0, 0, date("m"), date("d") - date("w") + 1 - 7, date("Y"));
                    $end_time = mktime(23, 59, 59, date("m"), date("d") - date("w") + 7 - 7, date("Y"));
                }
                break;
            case 4: //月
                if ($data['cycle_id'] == 1) { //本月
                    $start_time = mktime(0, 0, 0, date("m"), 1, date("Y"));
                    $end_time = mktime(23, 59, 59, date("m"), date("t"), date("Y"));
                } else { //上月
                    $start_time = mktime(0, 0, 0, date("m") - 1, 1, date("Y"));
                    $end_time = mktime(23, 59, 59, date("m"), 0, date("Y"));
                }
                break;
            case 5:  //季度
                if ($data['cycle_id'] == 1) { //本季度
                    $season = ceil((date('n')) / 3);
                    $start_time = mktime(0, 0, 0, $season * 3 - 3 + 1, 1, date('Y'));
                    $end_time = mktime(23, 59, 59, $season * 3, date('t', mktime(0, 0, 0, $season * 3, 1, date("Y"))), date('Y'));
                } else { //上季度
                    $season = ceil((date('n')) / 3) - 1;
                    $start_time = mktime(0, 0, 0, $season * 3 - 3 + 1, 1, date('Y'));
                    $end_time = mktime(23, 59, 59, $season * 3, date('t', mktime(0, 0, 0, $season * 3, 1, date("Y"))), date('Y'));
                }
                break;
            case 6: //年
                if ($data['cycle_id'] == 1) { //今年
                    $start_time = strtotime(date('Y-01-01 00:00:00', time()));
                    $end_time = strtotime(date('Y-12-31 23:59:59', time()));
                } else { // 去年
                    $start_time = strtotime(date('Y-01-01 00:00:00', strtotime('-1 year')));
                    $end_time = strtotime(date('Y-12-31 23:59:59', strtotime('-1 year')));
                }
                break;
            case 7: //自定义
                $start_time = strtotime(date('Y-m-d', $welfareGiftType['start_time']));
                $end_time = strtotime(date('Y-m-d 23:59:59', $welfareGiftType['end_time']));
                break;
        }

        var_dump(date("Y-m-d H:i:s", $start_time), date("Y-m-d H:i:s", $end_time));
    }

    public function welfare()
    {
        if (!input('id')) {
            exit(0);
        }
        $makeReportGo = new MakeReportGo();
        $makeReportGo->welfareTask('welfareList', input('id'));

    }

    public function temporary()
    {
        if (temporary()) {
            echo '禁止登录';
            die();
        }
    }

    public function welfareRongyao()
    {

        $data = [
            'appId' => 'fbss398ab6x5s33xs88edfe5a22',
            'userId' => 'yyh001',
            'orderNum' => 'FL' . time(),
            'propData' => '11',
            'serverId' => '47',
            'roleId' => '52917295621615179',
            'Time' => time(),
        ];
        $serverKey = 'dfsjssfl83943x434x3bdf5x615fc704';
        $data['Sign'] = MD5($data['appId'] . $data['serverId'] . $data['roleId'] . $data['userId'] . $data['propData'] . $data['orderNum'] . $data['Time'] . $serverKey);
        $url = 'https://api.gamedreamsky.com/gitem-yiyou/welfare';

        var_dump($data);
        $result = curl($url, $data);

        var_dump($result);
    }

    public function welfareApi()
    {
        $orderid = 'WL16777420663228642648';
        $payModel = new Pay;
        $payInfo = $payModel->field('id,status,amount,real_amount,userid,gameid,channel_id,ip')->where(['orderid' => $orderid])->find();
        cache('PayNotify:updateOrder:' . $orderid, $payInfo, 300);
        $callback_params = [
            'orderid' => $orderid,
            'gameid' => 212,
            'amount' => 6,
        ];
        (new SpecialService())->welfare($callback_params);
    }

    public function time()
    {
        $formdata = '%Y-%m';
        var_dump(date("Y-m-d", time() - 86400 * 220));
        for ($i = 1; $i <= 7; $i++) {

            var_dump(date("Y-m", mktime(0, 0, 0, date("m") + ($i - 7), 01, date("Y"))));
            $weekormonth[$i]['date'] = date('Y-m', strtotime('+' . $i - 7 . ' month'));
            $weekormonth[$i]['流水'] = 0;
        }
        var_dump($weekormonth);
    }

    public function gettime()
    {
        $welfareGiftType['time_type'] = 6;
        $data['cycle_id'] = 2;
        $welfare['month_type'] = 2;

        list($a, $b) = (new WelfareService())->getTime($welfareGiftType, $data, $welfare);
        var_dump(date('Y-m-d H:i:s', $a), date('Y-m-d H:i:s', $b));
    }

    public function getSpecialParam()
    {
        $data = [
            'channelToken' => 'ZDE5YjJRZFRsU2k4YzVIL1FVbHhtZm9kSlM3WUU5bjRKMi9OWTJFTVlDQm5oLy9oZ1pIZ3c0YmdiMEY2K0tYS3dLWXc5bnNtdUgvZFdWdGU0dFU5RUxId3ZreDRnZmQ3NzZwb0p2NTc3aG9FaUtWWG1OVQ',

        ];
        $polyChannelGame = ['param' => '{"appid":"1455f6eac7838b3c2ab6191906003f51","appkey":"86fea77719a85dfbaf1d609e054d318b","serverkey":"dbe847357fa6a91c4b2bf2dc472245d8"}'];

        $a = (new Naozhewan())->getSpecialParam($data, $polyChannelGame);
        var_dump($a);
    }

    public function getgift()
    {

        $this->getGiftData(10);
    }

    public function getGiftData($game_id)
    {
        $nowtime = NOW_TIMESTAMP;
        //$yearAgo   = strtotime("-1 year");
        $GiftModel = new GiftModel();
        $giftList = $GiftModel->alias('gift')
            ->field('gift.id,gift.title,gift.consume,gift.content,gift.total,gift.used,gift.endtime,info.mobileicon')
            ->join('cy_gameinfo info', 'info.game_id = gift.gameid', 'left')
            ->where(['gift.isdelete' => 0])
            ->where(function ($query) use ($game_id) {
                if (isset($game_id) && !empty($game_id)) {
                    $query->whereRaw(sprintf('FIND_IN_SET(%s,gameid)', $game_id));
                }
            })
            ->where('gift.starttime', '<=', $nowtime)
            ->where('gift.endtime', '>=', $nowtime)
            ->order('gift.create_time desc')
            ->paginate(10);

        if (!empty($giftList)) { // 标识玩家已领取的礼包
            foreach ($giftList as &$gift) {
                // 剩余可领的数量占比
                $gift['percent'] = round(($gift['total'] - $gift['used']) / $gift['total'], 2) * 100;
                //$gift['image'] = STATIC_DOMAIN.$gift['image'];
            }
        }

        var_dump($giftList);
    }

    public function getPay()
    {

        $pay = new PayService();
        $notify_url = Config::get('alipayAop')['notify_url'];
        $wxpayh5_param = $pay->getAlipayAopParam(time(), 1, '测试', '125.77.44.84', $notify_url);
        var_dump($wxpayh5_param);
    }


}