NN2023021801/app/api/controller/v1/Test.php

<?php

namespace app\api\controller\v1;

use AlibabaCloud\SDK\OSS\OSS\DeleteMultipleObjectsRequest\body\delete;
use app\admin\controller\coupon\Couponarea;
use app\admin\service\ConfigService;
use app\api\services\ThirdPayServices;
use app\api\services\UserAuthServices;
use app\api\services\UserServices;
use app\common\model\BoxMidHandleModel;
use app\common\model\BoxHandleModel;
use app\common\model\CouponAreaModel;
use app\common\model\CouponPlanLogModel;
use app\common\model\CouponPlanModel;
use app\common\model\MachineListModel;
use app\common\model\MachineModel;
use app\common\model\ShopGoodsModel;
use app\common\model\User;
use app\common\model\UserDataModel;
use app\common\model\UserFansModel;
use app\common\model\UserModel;
use app\common\model\YgOrderModel;
use Grpc\Timeval;
use jobs\CouponPlanJob;
use jobs\JpOrderJob;
use jobs\ShopOrderJob;

use jobs\SystemMiddleOpenBox;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Reader\Xls\MD5;
use Rsa\RsaClient;
use services\CacheServices;
use think\cache\driver\Redis;
use think\db\Where;
use think\Exception;
use think\facade\Cache;
use think\facade\Db;
use think\facade\Filesystem;
use think\Request;
use utils\Queue;

use jianyan\excel\Excel;

class Test
{
     public function test5(Request $request)
    {
        echo 555;
          

        
        return 'success';
        
        $users = Db::name('user')->where('score_account_id','<=',0)->field('id,mobile,money,score,remark')->select();
        
      $count = 0;
      $ids = [];
       $ids1 = [];
        if($users){
            
            foreach ($users as $item){
                /*
                $moneyCount = Db::name('money_log')->where(['uid'=> $item['id']])
                ->where('create_at','<=','2023-02-19 19:30:00')
                ->count('id');
                
                if($moneyCount<=0){
                    Db::name('user')->where(['id'=> $item['id']])->update(['remark'=>$item['remark'].'|更新余额：'.$item['money'].'++0','money'=> 0]);
                    echo '用户'.$item['id'].'处理成功<br>';
                    $ids[] = $item['id'];
                    $count++;
                }else{
                    $ids1[] = $item['id'];
                }
                
                */
            
                /*
                
                $lastMoneyLog = Db::name('money_log')->where(['uid'=> $item['id']])
                ->where('create_at','<=','2023-02-19 19:30:00')
                ->order('create_at','desc')
                ->order('id','desc')
                ->find();
                
                $lastMoneyId = isset($lastMoneyLog['id'])? $lastMoneyLog['id']:0;
                $lastMoney = isset($lastMoneyLog['after_money'])? $lastMoneyLog['after_money']:0;
                
                echo '处理用户：'.$item['id'].'++'.$item['money'].'++'.$lastMoneyId.'++'.$lastMoney."<br>";
                if($lastMoneyLog && $lastMoneyId){
                    Db::name('user')->where(['id'=> $item['id']])->update(['remark'=>$item['remark'].'|更新余额：'.$item['money'].'++'.$lastMoney,'account_id'=> $lastMoneyId,'money'=> $lastMoney]);
                    echo '处理成功<br>';
                    $count++;
                }
                */
                
                
                
                
            
            
                $lastScoreLog = Db::name('score_log')
                ->where(['uid'=> $item['id']])
                ->where('create_at','<=','2023-02-19 19:30:00')
                ->order('create_at','desc')
                ->order('id','desc')
                ->find();
                
                $lastScoreId = isset($lastScoreLog['id'])? $lastScoreLog['id']:0;
                $lastScore = isset($lastScoreLog['after_score'])? $lastScoreLog['after_score']:0;
                echo '处理用户：'.$item['id'].'++'.$item['score'].'++'.$lastScoreId.'++'.$lastScore."<br>";
                if($lastScoreLog && $lastScoreId){
                    Db::name('user')->where(['id'=> $item['id']])->update(['remark'=>$item['remark'].'|更新积分：'.$item['score'].'++'.$lastScore,'score_account_id'=> $lastScoreId,'score'=> $lastScore]);
                      echo '处理成功<br>';
                      $count++;
                }
                
                
            }
        }
        echo "累计处理：".$count."<br>";
        echo "累计ID：".implode(',', $ids)."<br>";
           echo "累计ID1：".implode(',', $ids1)."<br>";
        return 'success';
    }
    
    
    public function test4()
    {
     
     return false;
        $count = 0;
        $list = Db::name('money_log')->where(['type'=> 3])
        ->where('from_id','>', 0)
        ->where('create_at','>','2023-02-19 21:00:00')
        ->select();
        
        Db::startTrans();
        foreach($list as $v){
            echo "空盒退换余额记录：".$v['uid'].'+m+'.$v['money'].'+t+'.$v['type'].'++'.$v['state'].'++'.$v['from_id'].'<br>';
            
            if($v['uid']){
                $totalNum = Db::name('box_record')
                    ->where(['uid'=> $v['uid'],'pay_type'=>2])
                   ->where('create_time','>','2023-02-19 19:30:00')
                   ->sum('num');
                
                $boxNum = Db::name('box_record')
                    ->where(['uid'=> $v['uid'],'pay_type'=>2])
                   ->where('create_time','>','2023-02-19 19:30:00')
                   ->sum(Db::raw('box10+box20+box30+box40'));
                   
               $emptyNum = $totalNum - $boxNum;
               
               $backNum = Db::name('money_log')
                    ->where(['type'=> 3,'uid'=> $v['uid']])
                    ->where('from_id','>', 0)
                    ->where('create_at','>','2023-02-19 21:00:00')
                    ->count('id');
                   
                   echo "用户空盒统计：".$v['uid'].'++'.$totalNum.'++'.$boxNum.'++应退'.$emptyNum.'++退了'.$backNum."个<br>";
                   
                   $getNum = max(0, $backNum - $emptyNum);
                  
                   /**
                   if($getNum>0){
                       $info = Db::name('user')->where(['id'=> $v['uid']])->field('id,money,score,profit_money')->find();
                       $money = $getNum * 288;
                       
                       if(!Db::name('user')->where('id',$v['uid'])->dec('money', $money)->update()){
                            Db::rollback();
                            return '运行账户错误：'.$v['uid'].'++'.$money.'<br>';
                       }
                       
                       $data = [
                        'uid'=>$v['uid'],
                        'type'=> 98,
                        'money'=> $money,
                        'create_at'=> sr_getcurtime(time()),
                        'state'=> 0,
                        'before_money'=> $info['money'],
                        'after_money'=> max(0, $info['money'] - $money),
                        'from_id'=> 0,
                        'uid2'=> 0,
                        'free_type'=> 0
                        ];
                        
                        if(!Db::name('money_log')->insertGetId($data)){
                            Db::rollback();
                            return '运行流水错误：'.$v['uid'].'+'.$money."<br>";
                        }
                        
                        $count++;
                   }
                   **/
                   
            }
        }
        
        Db::commit();
        echo '合计处理：'.$count."个";
        return 'success';
    }
    
     public function test3()
    {
        return false;
        $temps = [];
        $temps1 = [];
        $userIds = [];
        $lists = Db::name('user_unmoney')->where(['status'=>1])
        ->where('create_time','>','2023-02-19 21:00:00')
        ->select();
        foreach ($lists as $v){
            $ids = isset($v['ids'])? $v['ids'] : '';
            $ids = $ids? explode(',', $ids): [];
              $uid = isset($v['uid'])? $v['uid'] : 0;
              $mid = isset($v['id'])? $v['id'] : 0;
              $tempIds = [];
              
              Db::startTrans();
              echo 'IDS:'.$v['ids']."<br>";
              $profitTotal = $profitTotal1= $v['money'];
              /**
              foreach ($ids as $id){
                  $boxInfo = Db::name('box_handle')->where('id','=', $id)->find();
                  //var_dump($info);
                  $rid = isset($boxInfo['rid'])? $boxInfo['rid'] : 0;
                   
                    if($rid && !isset($temps[$rid])){
                //Db::name('box_handle')->where('create_time','>','2023-02-19 19:30:00')->where(['id'=> $id])->update(['is_delete'=>1]);
                    echo "保留：".$mid.'++'.$uid.'++'.$rid.'-'.$id."<br>";
                
                    $temps[$rid] = $rid;
                    $userIds[] = $uid;
                    $tempIds[] = $id;
                }else{
                    $goodsPrice = isset($boxInfo['goods_price'])? $boxInfo['goods_price'] : 0;
                    $sourcePrice = 288;
                    $fee = 10;
                    $backProfit = max(0, $goodsPrice - $fee - $sourcePrice);
                    $profitTotal = max(0, $profitTotal - $backProfit);
                    
                    echo "清除：".$mid.'++'.$uid.'++'.$backProfit.'++'.$goodsPrice.'++'.$rid.'-'.$id."<br>";
                    $info = Db::name('user')->where(['id'=> $uid])->field('id,money,score,profit_money')->find();
                    
                    
                    if(!Db::name('user')->where('id',$uid)->dec('money', $sourcePrice)->update()){
                        Db::rollback();
                        return $uid.'+1+'.$rid.'++'.$id.'++'.$sourcePrice;
                    }
                    
                   // return false;
                    if($backProfit>0 && !Db::name('user')->where(['id'=> $uid])->dec('profit_money', $backProfit)->update()){
                        Db::rollback();
                        return $uid.'+2+'.$rid.'++'.$id;
                    }
                    
                    
                    $data = [
                        'uid'=>$uid,
                        'type'=> 98,
                        'money'=> $sourcePrice,
                        'create_at'=> sr_getcurtime(time()),
                        'state'=> 0,
                        'before_money'=> $info['money'],
                        'after_money'=> max(0, $info['money'] - $sourcePrice),
                        'from_id'=> $id,
                        'uid2'=> 0,
                        'free_type'=> 0
                    ];
                    
                    if(!Db::name('money_log')->insertGetId($data)){
                        Db::rollback();
                        return $uid.'+3+'.$rid.'++'.$id; 
                    }
                    
                    
                    
                     if($boxInfo['is_delete'] != 1 && !Db::name('box_handle')->where('create_time','>','2023-02-19 19:30:00')->where(['id'=> $id])->update(['is_delete'=>1,'update_time'=> date('Y-m-d H:i:s')])){
                        Db::rollback();
                        return $uid.'+4+'.$rid.'++'.$id; 
                    }
                    
                    
                    
                    
                    $temps1[] = $id;
                }
              }
              
              //var_dump($tempIds);
              
              if($profitTotal>0 && $profitTotal != $profitTotal1 && $mid && $tempIds && $temps1 && !Db::name('user_unmoney')->where(['status'=>1,'id'=> $mid])->update(['money'=> $profitTotal,'ids'=> implode(',', $tempIds)])){
                  Db::rollback();
                        return $uid.'+5+'.$mid; 
              }
              
              **/
              
              Db::commit();
              echo "处理：".$mid."++".$uid.'++'.$profitTotal.'++'.$profitTotal1.'++'.($tempIds?implode(',', $tempIds):'')."<br>";
        }
        
       echo count($temps).'<br>';
       echo count($temps1);
        return 'success';
    }
    
    public function test2()
    {
        return false;
        $temps = [];
        $temps1 = [];
        $userIds = [];
        $lists = Db::name('box_handle')->where(['status'=>2,'handle_type'=>2])->where('create_time','>','2023-02-19 19:30:00')->select();
        foreach ($lists as $v){
            $rid = isset($v['rid'])? $v['rid'] : 0;
              $id = isset($v['id'])? $v['id'] : 0;
              $uid = isset($v['uid'])? $v['uid'] : 0;
            if($rid && !isset($temps[$rid])){
                //Db::name('box_handle')->where('create_time','>','2023-02-19 19:30:00')->where(['id'=> $id])->update(['is_delete'=>1]);
                
                
                $temps[$rid] = $rid;
                $userIds[] = $uid;
            }else{
                $price = $v['goods_price'];
            }
        }
        
       echo count($temps);
        return 'success';
    }


    // 根据一个时间戳 返回 还有多少 小时:分钟:秒
    public function getHoursMinuteSencond($time){
        if ($time > 3600){
            $G_time = date('G', $time);

            $hours_time = $G_time-8;
            $format = 'i:s';

            return $hours_time.':'.date($format, $time);

//            $format = 'G:i:s';
        }else{
            $format = ':i:s';
        }

        return date($format, $time);
    }
    



    //签名
    public function diankesign($data)
    {
        ksort($data);
        $signStr = "";
        foreach ($data as $key => $val) {
            $signStr .= $key . '=' . $val . '&';
        }
        $stringSignTemp = $signStr.'key=a05fd6fc1f924b74b83dfd519ce93c28';
        $signtemp = \md5($stringSignTemp);

        return strtoupper($signtemp);

    }

    public function test1(Request $request){
        die();
        $test_info = Db::name('test')->where('id', '=', 1)->lock(true)->find();//加锁查询
        $test_info = Db::name('test')->where('id', '=', 1)->update(['msg'=>intval($test_info['msg'])+1]);
        if (!$test_info){
            return '没有数据';
        }

        return 'success';
    }


    public function test(Request $request){
        
        

//        13=>'提现失败退回
//        edit_user_money(13, 5346035, 1518);
        // 12=>'提现手续费退回',
//        edit_user_money(12, 5345035,55);
//        return 33;
die();
        Db::name('action_liangb')->insert([
            'create_time'=>sr_getcurtime(time()),
            'wd_id'=>'WD534508950100529797'
        ]);

        return 22;
        return AESjiami('guojin789');
//
//        sr_log('请求进来了：'.time());
//        $services = new ThirdPayServices();
//        $services->payDfBack('WD534508956101575010', 0, ['status'=>8, 'asdf'=>'adsfasdf'], 234234);
//
//        return 33;

        Db::startTrans();
        try {
            $test_info = Db::name('test')->where('id', '=', 1)->lock(true)->find();//加锁查询
//            Db::commit();
        }catch (\Exception $e){
            Db::rollback();


        }

        sleep(20);

        return 33;



        sr_log('请求进来了：'.time());
        Db::startTrans();//开启事务
        $test_info = Db::name('test')->where('id', '=', 1)->lock(true)->find();//加锁查询
        if (empty($test_info)) {
            exit('查询的数据不存在~！');
        }
            //执行你想进行的操作
            #*如修改金额
//        $edit = Db::name('user')->where('id', '=', $userInfo['id'])->update(['amount' => $userInfo['amount'] + 10]);
        $test_info = Db::name('test')->where('id', '=', 1)->update(['msg'=>intval($test_info['msg'])+1]);
        if (!$test_info) {
            Db::rollback();
            return '操作失败~！';
        }
        Db::commit();
        return '操作成功';





        return 33;


        return strtotime('2023-02-14'.' '.'01:59:00');

        return AESjiami('abcd123456');  // 结果是 TDFyZ3n/5GksjKtjhj2G1w==
        return AESjiami('1993345xhy');
        die();
        Db::name('box_record')->where('create_time', '>', '2023-02-13 10:48:17')->save([
           'status'=>1
        ]);

        return 33;
        return json_encode(explode('|', env('APP.NOT_OPEN_GOODS_ID')));

        return AESjiami('271234ab');
        die();

        return Db::name('money_log')->where('type', 7)->sum('money');
        die();

        Db::startTrans();
        try {
            $service = new ThirdPayServices();
            $service->payBack("20230206160818959664875", '28', 22, json_encode([]));
            Db::commit();
        }catch (\Exception $e){
            Db::rollback();

            return $e->getMessage();
        }

        return 33;

//        {
//            "pay": "true",
//	"appId": "dianke",
//	"amount": "28",
//	"orderId": "20230206160818959664875",
//	"version": "1.0",
//	"transactionId": "2023020622001491231429909739",
//	"sign": "D9560AEACD28FD948D979AF098C06451"
//}

        return $this->diankesign([
            'appId'=>'dianke',
            'amount'=>'28',
            'orderId'=>'20230206160818959664875',
            'version'=>'1.0',
            'transactionId'=>'2023020622001491231429909739',
            'pay'=>'true'
        ]);


        return AESjiami('abcd123456');
        return 33;
        Db::startTrans();
        try {

            edit_user_money(5, 5344487, 1.5, 0, 2355);

            Db::commit();
        }catch (\Exception $e){
            Db::rollback();

            return $e->getMessage();
        }

        return 33;

        $money = 456710.6;

//        return (int)$money;
        $money = (int)$money;
        return $money -  $money % 100;
        return 33;

        Db::startTrans();
        try {
            edit_user_money(2, 5344460, 30);
            Db::commit();
        }catch (\Exception $e){
            Db::rollback();
            return $e->getMessage();

        }
//


        return 22;


        return AESjiami('le222555');

        Db::startTrans();
        try {
            $service = new ThirdPayServices();
            $service->payBack('SY20230111155456310371725659', 0.21, 15, json_encode(['11'=>'22']));
            Db::commit();
        }catch (\Exception $e){
            Db::rollback();

            return $e->getMessage();

        }
        return 33;

//        $services->

        return ;

        return json_encode(getdate());
        $date = sr_getcurtime(time());

        return $this->GetNextMonth($date);

        return 22;
        return AESjiami('abcd123456');

        Db::startTrans();
        try {
            $service = new ThirdPayServices();

            $service->payBack('SY202301102021116710191277261', 0.32, 15, json_encode(['aa'=>'bb']));

            Db::commit();
        }catch (\Exception $e){
            Db::rollback();
            sr_log($e->getMessage());
            return 'opstate=0'.$e->getMessage();
        }


        return 44;

         return $this->getHoursMinuteSencond(20626);






//        180秒


        return date('Y-m-d H:i:s', $time);

        $hours = $time/60/60;
        $minute = (int)3234/60;
        $second = (int)3234/60/60;

        return $hours.'小时'.$minute.'分'.$second.'秒';


//        Queue::instance()->log('确定手动执行匹配福袋')->do('SystemHandleBox')->job(SystemMiddleOpenBox::class)->push([1]);

        return 33;

        $model = new ShopGoodsModel();
        $goods_arr = $model
            ->where('box_type', 20)
            ->where('goods_type', 2)
            ->field('goods_id,box_type,goods_img,price,goods_name')
            ->page(1, 20)->select();
        return json_encode($goods_arr);

//        Queue::instance()->log('确定手动执行匹配福袋')->do('SystemHandleBox')->job(SystemMiddleOpenBox::class)->push([1]);

        return 33;

        return AESjiami('abcd123456');


        $string = '144.0048';
        return floatval($string);


        Db::startTrans();
        try {
//            edit_user_money(6, 5344210, 144.0000, 0, 5344456);
            edit_user_money(6, 5344210, 3);
            Db::commit();
        }catch (\Exception $e){
            Db::rollback();

            return $e->getMessage();
        }

        return 77;

        return AESjiami('abcd123456');
        return 33;



        return Db::name('box_record')->where('id', '>', '0')->sum('num');



        Db::startTrans();
        try {
            $this->updateUserBox();
            Db::commit();
        }catch (\Exception $e){
            Db::rollback();

            return $e->getMessage();

        }

        return 22;



        return Db::name('box_record')->where('id', '>', 0)->sum('num');

        return 22;
        Db::name('box_record')->where('id', '>', 0)->save([
           'box20'=>0,
           'box30'=>0,
           'box40'=>0
        ]);

        return 22;

        sr_testDb('adsf', 4);

        return $count = rand(0, 10);
        return AESjiami('abcd123456');
        Db::name('box')->insert([
            'create_time'=>sr_getcurtime(time()),
            'buy_most'=>1000,
            'once_buy'=>20,
            'qi_count'=>1,
            'time_set'=>'10:00-10:30|14:00-15:30|18:00-20:00'
        ]);
        return 11;
        return Db::name('tz_log')->where('type', 1)->sum('score');

//        $path_user = Db::name('user')->whereFindInSet('path', 5344633)->sum('tz_num');
//        $tz = Db::name('user')->where('id', 5344633)->value('tz_num');
////        大飞下面 总共 306.7
//        return $path_user + $tz;

        $path_user = Db::name('user')->whereFindInSet('path', 5344367)->sum('tz_num');
        $tz = Db::name('user')->where('id', 5344367)->value('tz_num');

        return $path_user + $tz;


        return 11;
        Db::startTrans();
        try {


            Db::commit();
        }catch (\Exception $e){
            Db::rollback();


        }
        return 33;
        die();
        incUserPerformance(5344809, 5000);
        return 44;
        die();
        incUserPerformance(5344723,10000);
        return 33;
        die();
        return AESjiami('111111');
        $num = 3;
        return sr_getdianLen($num);
//        $num = 3.33;
//        return $num%1;
//        if ($num%1 == 0){
//            return true;
//        }
        return sr_isdouble_xiaoshu('1')?11:22;

        $val = 45.668;
//        return $val*100;
        if (is_float($val*100)){
            return '是的';
        }

        return '不是';
        die();

        Db::name('pingyin_account')->where('id','>', 0)->save(['status'=>1]);
        return 33;
        return ;

        die();
        Db::startTrans();
        try {
            $service = new ThirdPayServices();

            $service->payBack('SY202211090152516106612547818', '0.28', 15, json_encode(['aa'=>'bbb']));

            Db::commit();
        }catch (\Exception $e){
            Db::rollback();
            return $e->getMessage();

        }
        return 33;

        return AESjiami('111111');
        return md5(AESjiami('111111'));
//        die();
        return AESjiami('abcd123456');
        die();

        die();
        $user = Db::name('user')->where('mobile', '15678888155')->find();
        return Db::name('user')->whereFindInSet('path', $user['id'])->where('user_type', 1)->sum('performance_me');

        edit_user_score(3, 5344839, 5000);
        return 33;
        return AESjiami('111111');
die();
//die();
//        payBack($out_trade_no, $pay_money, $pay_type, $content)
//        return AESjiami('a12345678');
//        die();
        return Db::name('user')->whereFindInSet('path', '5344346')->where('user_type', 1)->sum('performance_me');

die();
return Db::name('user')->where('id', 'not in', [5344210,5344229])->sum('score');

        die();
        $res = json_decode('{"sign":"DeoimrF6Y9VvYKHdDHRdV9/d5UMQNWo79SZvTRrBPl+96mC3z69WXR3efgwfw4W7SaX35UUgZtA3UxoplpiPh0Tc7Hg332NUg0h/hRFKNHicS0lOkp/E0bK0sRJ2Q1DOG60kiziZe4aXOcomRPe8FpjCoTfexkh3OmxiCKT5bac=","ysepay_online_fastpay_response":{"code":"10000","msg":"Success","out_trade_no":"20221012221334525683423_yswk3014","trade_no":"01O221012748736903","total_amount":"1.13","trade_status":"WAIT_BUYER_PAY"}}');

        if (isset($res->ysepay_online_fastpay_response->code) && intval($res->ysepay_online_fastpay_response->code) == 10000 && isset($res->ysepay_online_fastpay_response->msg) && intval($res->ysepay_online_fastpay_response->msg) == 'Success'){

                $trade_no = $res->ysepay_online_fastpay_response->trade_no;
//                $insert = [
//                    'total_fee' => $total_amount,
//                    'trade_type' => $trade_type,
//                    'body' => $body,
//                    'state' => 7,
//                    'out_trade_no' => $out_trade_no,
//                    'pay_way' => $pay_way,
//                    'remarks' => $remarks,
//                    'order_type' => $order_type,
//                    'uid' => $uid,
//                    'voucher_img' => $voucher_img,
//                    'out_trade_no1'=>'',
//                    'hy_token_id'=>'',
//                    'buyer_mobile'=>$params['mobile'],
//                    'trade_no'=>$trade_no
//                ];
//                Db::name('payment')->insert($insert);

                return api_succ_return(['msg'=>'成功', 'data'=>['thirdpayYS'=>['trade_no'=>$trade_no]]]);

            }else{
                if (isset($res->ysepay_online_fastpay_response->sub_msg)){
                    return api_error_return($res->ysepay_online_fastpay_response->sub_msg);
                }else{
                    return api_error_return('支付错误，请联系客服');
                }
            }


        return api_error_return('支付错误，请联系客服1');



        incUserPerformance(5344400,10000);
        edit_user_score(8, 5344400, 25000);
        Db::name('user')->where('id', 5344400)->save(['user_type'=>9, 'free_level'=>10000]);
        return 22;


        return AESjiami('abcd123456');

//        edit_user_score(9, 5344638, 15000);

        return 33;

        $ser = new UserServices();
        try {
                    $ser->exchargeMoneyDone(5344371, 1, '17888779318', '15102768809');
        }catch (Exception $e){
            return $e->getMessage();
        }

        return '成功';
        die();
        return AESjiami('yu860802');

        return ceil(9.0234 * 100)/100;
        die();
        $m_user = new UserModel();
        return $m_user->xiaoquPerformance(5344240);

        return Db::name('money_log')->where('uid', 5344240)->whereDay('create_at', 'today')->sum('money');

        die();
        return Db::name('tz_log')->where('type', 1)->sum('score');

        die();
        edit_user_score(9, 5344371,60000);
        die();
        return 10/3;
        return sprintf('%.4f', 10/3);
        return md5(AESjiami('111111'));
        die();
        return AESjiami('le222555');
//        sr_log('asdfasd');
//        $params = ["app_version"=>"1.0","app_sources"=>"android","sys_version"=>"11","sys_model"=>"CMAAN40","udid"=>"21e51c0ca03ed8c2","timestamp"=>"1664551149519","name"=>"111","sign"=>"0B0F7E07B36281F5B8EEAED2207E0567"];
        return createApiSign($request->post());
//        die();
        return createApiSign($request->param());
        die();
//        die();
////        return sysconfig()
//        return AESjiami('111111');
//        $list = Db::name('user')->where('money', '>', 0)->select();
//        foreach ($list as $key=>$val){
//            Db::name('user')->where('id', $val['id'])->save(['money'=>0]);
//        }
//        return 33;
//
//        return AESjiami('abcd123456');
//        return Db::name('user_freelevellog')->where('uid', 333)->where('type', 2)->max('free_level');
//
//        $max_level = Db::name('user_freelevellog')->where('uid', 5344217)->where('type', 1)->max('re_level');
//        return $max_level;
//
//        $num = 23.6666666;
//        return sprintf("%.4f",substr(sprintf("%.5f", $num), 0, -2));


//        return Db::name('score_log')->whereTime('create_at', '>', '2022-09-24 07:03:42')->sum('score');


//        return md5(AESjiami('abcd123456'));

        try {
            $arr = [];
            $begin_time = time() - 86400*30;
            for ($i=0;$i<30;$i++){
                $price =  '1.'.random_int(1, 9).random_int(1, 9);
                Db::name('sys_func_log')->insert([
                    'type'=>1,
                    'money'=>$price,
                    'create_at'=>sr_getcurtime($begin_time + 86400*$i)
                ]);

            }
        }catch (Exception $e){
             return $e->getMessage();
        }

        return json_encode(json_encode($arr));

        return 33;


//        return md5(AESjiami('123456'));
        return $pass = AESjiami('le222555.');
        return preg_match('/\d+/', $pass) && preg_match('/[a-zA-Z]+/', $pass)?'有':'没有';
        return strlen('le222555.');
        return AESjiemi('fZhV5v5NjBSybEPtUoleJg==');
        die();
        return AESjiami('le222555.');
        die();
//        return is_numeric('123456')?'纯数字':'不是';
        return AESjiami('123456');

        return create_invite_code();
        return Db::name('payment')->whereDay('creat_at', 'yesterday')->where('state', 6)->sum('total_fee');
        die();

//        老王:18746178697    7493436
//心态:13260666578    7493433
//郑跃兵:17888779318   7493466
        $teamUsers =[
            '7493436'=>0,
            '7493433'=>0,
            '7493466'=>0
        ];

        $list = Db::name('shop_order')->whereDay('created_time', 'today')->where('status', 1)->select();
        foreach ($list as $key=>$val){
            $path = Db::name('user')->where('id', $val['user_id'])->value('path');

            foreach ($teamUsers as $k1=>&$v1){
                if (strpos(strval($path), strval($k1)) !== false){
                    $v1 += $val['total_price'];
                }
            }
        }

        return json_encode($teamUsers);
        die();
        // 平台所有余额总和
        return Db::name('user')->where('status', 1)->where('user_type', 1)->where('id', 'not in', [7493267, 7493266])->sum('money');
die();


        die();
return json_encode('{"app_id":"app_4f8d1f05-bcfd-4e9e-b093-b60c43036f2d","created_time":"1662713634","description":"\u8d2d\u4e70\u5546\u54c1","expend":{"pay_info":"https:\/\/qr.alipay.com\/bax08139bwvehcew1b3t30c8"},"id":"002112022090916535410414235160744284160","object":"payment","order_no":"HFPAY20220909165205254560022948","party_order_id":"02212209096083454601956","pay_amt":"0.19","pay_channel":"alipay","prod_mode":"true","query_url":"https:\/\/api.adapay.tech\/v1\/expire\/payments\/1\/380d6a9c3aa72e53eeb65e04ec062043","status":"succeeded"}');
        return json_decode('{"app_id":"app_4f8d1f05-bcfd-4e9e-b093-b60c43036f2d","created_time":"1662713634","description":"\u8d2d\u4e70\u5546\u54c1","expend":{"pay_info":"https:\/\/qr.alipay.com\/bax08139bwvehcew1b3t30c8"},"id":"002112022090916535410414235160744284160","object":"payment","order_no":"HFPAY20220909165205254560022948","party_order_id":"02212209096083454601956","pay_amt":"0.19","pay_channel":"alipay","prod_mode":"true","query_url":"https:\/\/api.adapay.tech\/v1\/expire\/payments\/1\/380d6a9c3aa72e53eeb65e04ec062043","status":"succeeded"}', true);
        return api_succ_return('成功');
//        return dirname(__FILE__);
//        include_once  dirname(__FILE__). "../../../../../extend/thirdpay/AdapaySdk/init.php";

//        return 33;
die();

        $str = '7493267,7493426,7493587,7493434,7493466';
        $arr = explode(',', $str);
        $arr = arsort($arr);
        var_dump($arr);
        return json_encode($arr);


        $apikey = 'getAppBanner1';
        $redis = new Redis();
//        $res = '{"code":200,"msg":"查询成功","datas":[{"id":12,"city_name":"安徽","initial":"A","is_del":0,"pid":0},{"id":316,"city_name":"阿坝藏族羌族自治州","initial":"A","is_del":0,"pid":24},{"id":322,"city_name":"安顺市","initial":"A","is_del":0,"pid":25},{"id":68,"city_name":"阿拉善盟","initial":"A","is_del":0,"pid":5},{"id":71,"city_name":"鞍山市","initial":"A","is_del":0,"pid":6},{"id":350,"city_name":"阿里地区","initial":"A","is_del":0,"pid":27},{"id":359,"city_name":"安康市","initial":"A","is_del":0,"pid":28},{"id":137,"city_name":"安庆市","initial":"A","is_del":0,"pid":12},{"id":395,"city_name":"阿克苏地区","initial":"A","is_del":0,"pid":32},{"id":401,"city_name":"阿勒泰地区","initial":"A","is_del":0,"pid":32},{"id":403,"city_name":"阿拉尔市","initial":"A","is_del":0,"pid":32},{"id":197,"city_name":"安阳市","initial":"A","is_del":0,"pid":17},{"id":1,"city_name":"北京","initial":"B","is_del":0,"pid":0},{"id":267,"city_name":"北海市","initial":"B","is_del":0,"pid":21},{"id":272,"city_name":"百色市","initial":"B","is_del":0,"pid":21},{"id":33,"city_name":"北京市","initial":"B","is_del":0,"pid":1},{"id":290,"city_name":"白沙黎族自治县","initial":"B","is_del":0,"pid":22},{"id":294,"city_name":"保亭黎族苗族自治县","initial":"B","is_del":0,"pid":22},{"id":40,"city_name":"保定市","initial":"B","is_del":0,"pid":3},{"id":58,"city_name":"包头市","initial":"B","is_del":0,"pid":5},{"id":314,"city_name":"巴中市","initial":"B","is_del":0,"pid":24},{"id":64,"city_name":"巴彦淖尔市","initial":"B","is_del":0,"pid":5},{"id":323,"city_name":"毕节市","initial":"B","is_del":0,"pid":25},{"id":73,"city_name":"本溪市","initial":"B","is_del":0,"pid":6},{"id":331,"city_name":"保山市","initial":"B","is_del":0,"pid":26},{"id":88,"city_name":"白山市","initial":"B","is_del":0,"pid":7},{"id":90,"city_name":"白城市","initial":"B","is_del":0,"pid":7},{"id":353,"city_name":"宝鸡市","initial":"B","is_del":0,"pid":28},{"id":364,"city_name":"白银市","initial":"B","is_del":0,"pid":29},{"id":132,"city_name":"蚌埠市","initial":"B","is_del":0,"pid":12},{"id":393,"city_name":"博尔塔拉蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":394,"city_name":"巴音郭楞蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":406,"city_name":"北屯市","initial":"B","is_del":0,"pid":32},{"id":180,"city_name":"滨州市","initial":"B","is_del":0,"pid":15},{"id":260,"city_name":"潮州市","initial":"C","is_del":0,"pid":20},{"id":276,"city_name":"崇左市","initial":"C","is_del":0,"pid":21},{"id":23,"city_name":"重庆","initial":"C","is_del":0,"pid":0},{"id":288,"city_name":"澄迈县","initial":"C","is_del":0,"pid":22},{"id":291,"city_name":"昌江黎族自治县","initial":"C","is_del":0,"pid":22},{"id":42,"city_name":"承德市","initial":"C","is_del":0,"pid":3},{"id":298,"city_name":"成都市","initial":"C","is_del":0,"pid":24},{"id":43,"city_name":"沧州市","initial":"C","is_del":0,"pid":3},{"id":60,"city_name":"赤峰市","initial":"C","is_del":0,"pid":5},{"id":336,"city_name":"楚雄彝族自治州","initial":"C","is_del":0,"pid":26},{"id":81,"city_name":"朝阳市","initial":"C","is_del":0,"pid":6},{"id":83,"city_name":"长春市","initial":"C","is_del":0,"pid":7},{"id":346,"city_name":"昌都市","initial":"C","is_del":0,"pid":27},{"id":109,"city_name":"常州市","initial":"C","is_del":0,"pid":10},{"id":392,"city_name":"昌吉回族自治州","initial":"C","is_del":0,"pid":32},{"id":139,"city_name":"滁州市","initial":"C","is_del":0,"pid":12},{"id":144,"city_name":"池州市","initial":"C","is_del":0,"pid":12},{"id":185,"city_name":"长治市","initial":"C","is_del":0,"pid":16},{"id":228,"city_name":"长沙市","initial":"C","is_del":0,"pid":19},{"id":234,"city_name":"常德市","initial":"C","is_del":0,"pid":19},{"id":237,"city_name":"郴州市","initial":"C","is_del":0,"pid":19},{"id":258,"city_name":"东莞市","initial":"D","is_del":0,"pid":20},{"id":285,"city_name":"东方市","initial":"D","is_del":0,"pid":22},{"id":286,"city_name":"定安县","initial":"D","is_del":0,"pid":22},{"id":302,"city_name":"德阳市","initial":"D","is_del":0,"pid":24},{"id":312,"city_name":"达州市","initial":"D","is_del":0,"pid":24},{"id":70,"city_name":"大连市","initial":"D","is_del":0,"pid":6},{"id":74,"city_name":"丹东市","initial":"D","is_del":0,"pid":6},{"id":340,"city_name":"大理白族自治州","initial":"D","is_del":0,"pid":26},{"id":341,"city_name":"德宏傣族景颇族自治州","initial":"D","is_del":0,"pid":26},{"id":343,"city_name":"迪庆藏族自治州","initial":"D","is_del":0,"pid":26},{"id":97,"city_name":"大庆市","initial":"D","is_del":0,"pid":8},{"id":104,"city_name":"大兴安岭地区","initial":"D","is_del":0,"pid":8},{"id":371,"city_name":"定西市","initial":"D","is_del":0,"pid":29},{"id":170,"city_name":"东营市","initial":"D","is_del":0,"pid":15},{"id":178,"city_name":"德州市","initial":"D","is_del":0,"pid":15},{"id":183,"city_name":"大同市","initial":"D","is_del":0,"pid":16},{"id":62,"city_name":"鄂尔多斯市","initial":"E","is_del":0,"pid":5},{"id":216,"city_name":"鄂州市","initial":"E","is_del":0,"pid":18},{"id":223,"city_name":"恩施土家族苗族自治州","initial":"E","is_del":0,"pid":18},{"id":268,"city_name":"防城港市","initial":"F","is_del":0,"pid":21},{"id":13,"city_name":"福建","initial":"F","is_del":0,"pid":0},{"id":72,"city_name":"抚顺市","initial":"F","is_del":0,"pid":6},{"id":77,"city_name":"阜新市","initial":"F","is_del":0,"pid":6},{"id":140,"city_name":"阜阳市","initial":"F","is_del":0,"pid":12},{"id":146,"city_name":"福州市","initial":"F","is_del":0,"pid":13},{"id":164,"city_name":"抚州市","initial":"F","is_del":0,"pid":14},{"id":247,"city_name":"佛山市","initial":"F","is_del":0,"pid":20},{"id":265,"city_name":"桂林市","initial":"G","is_del":0,"pid":21},{"id":270,"city_name":"贵港市","initial":"G","is_del":0,"pid":21},{"id":20,"city_name":"广东","initial":"G","is_del":1,"pid":0},{"id":21,"city_name":"广西","initial":"G","is_del":1,"pid":0},{"id":25,"city_name":"贵州","initial":"G","is_del":1,"pid":0},{"id":29,"city_name":"甘肃","initial":"G","is_del":0,"pid":0},{"id":304,"city_name":"广元市","initial":"G","is_del":0,"pid":24},{"id":311,"city_name":"广安市","initial":"G","is_del":0,"pid":24},{"id":317,"city_name":"甘孜藏族自治州","initial":"G","is_del":0,"pid":24},{"id":319,"city_name":"贵阳市","initial":"G","is_del":0,"pid":25},{"id":374,"city_name":"甘南藏族自治州","initial":"G","is_del":0,"pid":29},{"id":380,"city_name":"果洛藏族自治州","initial":"G","is_del":0,"pid":30},{"id":386,"city_name":"固原市","initial":"G","is_del":0,"pid":31},{"id":161,"city_name":"赣州市","initial":"G","is_del":0,"pid":14},{"id":242,"city_name":"广州市","initial":"G","is_del":0,"pid":20},{"id":3,"city_name":"河北","initial":"H","is_del":0,"pid":0},{"id":8,"city_name":"黑龙江","initial":"H","is_del":0,"pid":0},{"id":17,"city_name":"河南","initial":"H","is_del":0,"pid":0},{"id":273,"city_name":"贺州市","initial":"H","is_del":0,"pid":21},{"id":18,"city_name":"湖北","initial":"H","is_del":0,"pid":0},{"id":274,"city_name":"河池市","initial":"H","is_del":0,"pid":21},{"id":19,"city_name":"湖南","initial":"H","is_del":0,"pid":0},{"id":277,"city_name":"海口市","initial":"H","is_del":0,"pid":22},{"id":22,"city_name":"海南","initial":"H","is_del":1,"pid":0},{"id":38,"city_name":"邯郸市","initial":"H","is_del":0,"pid":3},{"id":45,"city_name":"衡水市","initial":"H","is_del":0,"pid":3},{"id":57,"city_name":"呼和浩特市","initial":"H","is_del":0,"pid":5},{"id":63,"city_name":"呼伦贝尔市","initial":"H","is_del":0,"pid":5},{"id":337,"city_name":"红河哈尼族彝族自治州","initial":"H","is_del":0,"pid":26},{"id":82,"city_name":"葫芦岛市","initial":"H","is_del":0,"pid":6},{"id":92,"city_name":"哈尔滨市","initial":"H","is_del":0,"pid":8},{"id":95,"city_name":"鹤岗市","initial":"H","is_del":0,"pid":8},{"id":357,"city_name":"汉中市","initial":"H","is_del":0,"pid":28},{"id":102,"city_name":"黑河市","initial":"H","is_del":0,"pid":8},{"id":113,"city_name":"淮安市","initial":"H","is_del":0,"pid":10},{"id":119,"city_name":"杭州市","initial":"H","is_del":0,"pid":11},{"id":376,"city_name":"海东市","initial":"H","is_del":0,"pid":30},{"id":377,"city_name":"海北藏族自治州","initial":"H","is_del":0,"pid":30},{"id":378,"city_name":"黄南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":123,"city_name":"湖州市","initial":"H","is_del":0,"pid":11},{"id":379,"city_name":"海南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":382,"city_name":"海西蒙古族藏族自治州","initial":"H","is_del":0,"pid":30},{"id":130,"city_name":"合肥市","initial":"H","is_del":0,"pid":12},{"id":133,"city_name":"淮南市","initial":"H","is_del":0,"pid":12},{"id":135,"city_name":"淮北市","initial":"H","is_del":0,"pid":12},{"id":391,"city_name":"哈密市","initial":"H","is_del":0,"pid":32},{"id":138,"city_name":"黄山市","initial":"H","is_del":0,"pid":12},{"id":398,"city_name":"和田地区","initial":"H","is_del":0,"pid":32},{"id":411,"city_name":"胡杨河市","initial":"H","is_del":0,"pid":32},{"id":181,"city_name":"菏泽市","initial":"H","is_del":0,"pid":15},{"id":198,"city_name":"鹤壁市","initial":"H","is_del":0,"pid":17},{"id":203,"city_name":"漯河市","initial":"H","is_del":0,"pid":17},{"id":212,"city_name":"黄石市","initial":"H","is_del":0,"pid":18},{"id":220,"city_name":"黄冈市","initial":"H","is_del":0,"pid":18},{"id":231,"city_name":"衡阳市","initial":"H","is_del":0,"pid":19},{"id":239,"city_name":"怀化市","initial":"H","is_del":0,"pid":19},{"id":252,"city_name":"惠州市","initial":"H","is_del":0,"pid":20},{"id":255,"city_name":"河源市","initial":"H","is_del":0,"pid":20},{"id":261,"city_name":"揭阳市","initial":"J","is_del":0,"pid":20},{"id":7,"city_name":"吉林","initial":"J","is_del":0,"pid":0},{"id":10,"city_name":"江苏","initial":"J","is_del":0,"pid":0},{"id":14,"city_name":"江西","initial":"J","is_del":0,"pid":0},{"id":75,"city_name":"锦州市","initial":"J","is_del":0,"pid":6},{"id":84,"city_name":"吉林市","initial":"J","is_del":0,"pid":7},{"id":94,"city_name":"鸡西市","initial":"J","is_del":0,"pid":8},{"id":99,"city_name":"佳木斯市","initial":"J","is_del":0,"pid":8},{"id":362,"city_name":"嘉峪关市","initial":"J","is_del":0,"pid":29},{"id":363,"city_name":"金昌市","initial":"J","is_del":0,"pid":29},{"id":369,"city_name":"酒泉市","initial":"J","is_del":0,"pid":29},{"id":122,"city_name":"嘉兴市","initial":"J","is_del":0,"pid":11},{"id":125,"city_name":"金华市","initial":"J","is_del":0,"pid":11},{"id":156,"city_name":"景德镇市","initial":"J","is_del":0,"pid":14},{"id":158,"city_name":"九江市","initial":"J","is_del":0,"pid":14},{"id":162,"city_name":"吉安市","initial":"J","is_del":0,"pid":14},{"id":166,"city_name":"济南市","initial":"J","is_del":0,"pid":15},{"id":173,"city_name":"济宁市","initial":"J","is_del":0,"pid":15},{"id":186,"city_name":"晋城市","initial":"J","is_del":0,"pid":16},{"id":188,"city_name":"晋中市","initial":"J","is_del":0,"pid":16},{"id":200,"city_name":"焦作市","initial":"J","is_del":0,"pid":17},{"id":210,"city_name":"济源市","initial":"J","is_del":0,"pid":17},{"id":217,"city_name":"荆门市","initial":"J","is_del":0,"pid":18},{"id":219,"city_name":"荆州市","initial":"J","is_del":0,"pid":18},{"id":248,"city_name":"江门市","initial":"J","is_del":0,"pid":20},{"id":328,"city_name":"昆明市","initial":"K","is_del":0,"pid":26},{"id":389,"city_name":"克拉玛依市","initial":"K","is_del":0,"pid":32},{"id":396,"city_name":"克孜勒苏柯尔克孜自治州","initial":"K","is_del":0,"pid":32},{"id":397,"city_name":"喀什地区","initial":"K","is_del":0,"pid":32},{"id":409,"city_name":"可克达拉市","initial":"K","is_del":0,"pid":32},{"id":410,"city_name":"昆玉市","initial":"K","is_del":0,"pid":32},{"id":194,"city_name":"开封市","initial":"K","is_del":0,"pid":17},{"id":6,"city_name":"辽宁","initial":"L","is_del":0,"pid":0},{"id":264,"city_name":"柳州市","initial":"L","is_del":0,"pid":21},{"id":275,"city_name":"来宾市","initial":"L","is_del":0,"pid":21},{"id":289,"city_name":"临高县","initial":"L","is_del":0,"pid":22},{"id":292,"city_name":"乐东黎族自治县","initial":"L","is_del":0,"pid":22},{"id":293,"city_name":"陵水黎族自治县","initial":"L","is_del":0,"pid":22},{"id":44,"city_name":"廊坊市","initial":"L","is_del":0,"pid":3},{"id":307,"city_name":"乐山市","initial":"L","is_del":0,"pid":24},{"id":318,"city_name":"凉山彝族自治州","initial":"L","is_del":0,"pid":24},{"id":320,"city_name":"六盘水市","initial":"L","is_del":0,"pid":25},{"id":333,"city_name":"丽江市","initial":"L","is_del":0,"pid":26},{"id":78,"city_name":"辽阳市","initial":"L","is_del":0,"pid":6},{"id":335,"city_name":"临沧市","initial":"L","is_del":0,"pid":26},{"id":86,"city_name":"辽源市","initial":"L","is_del":0,"pid":7},{"id":344,"city_name":"拉萨市","initial":"L","is_del":0,"pid":27},{"id":347,"city_name":"林芝市","initial":"L","is_del":0,"pid":27},{"id":361,"city_name":"兰州市","initial":"L","is_del":0,"pid":29},{"id":112,"city_name":"连云港市","initial":"L","is_del":0,"pid":10},{"id":372,"city_name":"陇南市","initial":"L","is_del":0,"pid":29},{"id":373,"city_name":"临夏回族自治州","initial":"L","is_del":0,"pid":29},{"id":129,"city_name":"丽水市","initial":"L","is_del":0,"pid":11},{"id":142,"city_name":"六安市","initial":"L","is_del":0,"pid":12},{"id":153,"city_name":"龙岩市","initial":"L","is_del":0,"pid":13},{"id":177,"city_name":"临沂市","initial":"L","is_del":0,"pid":15},{"id":179,"city_name":"聊城市","initial":"L","is_del":0,"pid":15},{"id":191,"city_name":"临汾市","initial":"L","is_del":0,"pid":16},{"id":192,"city_name":"吕梁市","initial":"L","is_del":0,"pid":16},{"id":195,"city_name":"洛阳市","initial":"L","is_del":0,"pid":17},{"id":240,"city_name":"娄底市","initial":"L","is_del":0,"pid":19},{"id":303,"city_name":"绵阳市","initial":"M","is_del":0,"pid":24},{"id":309,"city_name":"眉山市","initial":"M","is_del":0,"pid":24},{"id":101,"city_name":"牡丹江市","initial":"M","is_del":0,"pid":8},{"id":134,"city_name":"马鞍山市","initial":"M","is_del":0,"pid":12},{"id":250,"city_name":"茂名市","initial":"M","is_del":0,"pid":20},{"id":253,"city_name":"梅州市","initial":"M","is_del":0,"pid":20},{"id":5,"city_name":"内蒙古","initial":"N","is_del":1,"pid":0},{"id":263,"city_name":"南宁市","initial":"N","is_del":0,"pid":21},{"id":31,"city_name":"宁夏","initial":"N","is_del":0,"pid":0},{"id":306,"city_name":"内江市","initial":"N","is_del":0,"pid":24},{"id":308,"city_name":"南充市","initial":"N","is_del":0,"pid":24},{"id":342,"city_name":"怒江傈僳族自治州","initial":"N","is_del":0,"pid":26},{"id":349,"city_name":"那曲市","initial":"N","is_del":0,"pid":27},{"id":106,"city_name":"南京市","initial":"N","is_del":0,"pid":10},{"id":111,"city_name":"南通市","initial":"N","is_del":0,"pid":10},{"id":120,"city_name":"宁波市","initial":"N","is_del":0,"pid":11},{"id":152,"city_name":"南平市","initial":"N","is_del":0,"pid":13},{"id":154,"city_name":"宁德市","initial":"N","is_del":0,"pid":13},{"id":155,"city_name":"南昌市","initial":"N","is_del":0,"pid":14},{"id":205,"city_name":"南阳市","initial":"N","is_del":0,"pid":17},{"id":300,"city_name":"攀枝花市","initial":"P","is_del":0,"pid":24},{"id":334,"city_name":"普洱市","initial":"P","is_del":0,"pid":26},{"id":79,"city_name":"盘锦市","initial":"P","is_del":0,"pid":6},{"id":368,"city_name":"平凉市","initial":"P","is_del":0,"pid":29},{"id":148,"city_name":"莆田市","initial":"P","is_del":0,"pid":13},{"id":157,"city_name":"萍乡市","initial":"P","is_del":0,"pid":14},{"id":196,"city_name":"平顶山市","initial":"P","is_del":0,"pid":17},{"id":257,"city_name":"清远市","initial":"Q","is_del":0,"pid":20},{"id":269,"city_name":"钦州市","initial":"Q","is_del":0,"pid":21},{"id":282,"city_name":"琼海市","initial":"Q","is_del":0,"pid":22},{"id":30,"city_name":"青海","initial":"Q","is_del":0,"pid":0},{"id":37,"city_name":"秦皇岛市","initial":"Q","is_del":0,"pid":3},{"id":295,"city_name":"琼中黎族苗族自治县","initial":"Q","is_del":0,"pid":22},{"id":325,"city_name":"黔西南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":326,"city_name":"黔东南苗族侗族自治州","initial":"Q","is_del":0,"pid":25},{"id":327,"city_name":"黔南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":329,"city_name":"曲靖市","initial":"Q","is_del":0,"pid":26},{"id":93,"city_name":"齐齐哈尔市","initial":"Q","is_del":0,"pid":8},{"id":100,"city_name":"七台河市","initial":"Q","is_del":0,"pid":8},{"id":370,"city_name":"庆阳市","initial":"Q","is_del":0,"pid":29},{"id":150,"city_name":"泉州市","initial":"Q","is_del":0,"pid":13},{"id":167,"city_name":"青岛市","initial":"Q","is_del":0,"pid":15},{"id":225,"city_name":"潜江市","initial":"Q","is_del":0,"pid":18},{"id":345,"city_name":"日喀则市","initial":"R","is_del":0,"pid":27},{"id":176,"city_name":"日照市","initial":"R","is_del":0,"pid":15},{"id":9,"city_name":"上海","initial":"S","is_del":1,"pid":0},{"id":15,"city_name":"山东","initial":"S","is_del":0,"pid":0},{"id":16,"city_name":"山西","initial":"S","is_del":0,"pid":0},{"id":278,"city_name":"三亚市","initial":"S","is_del":0,"pid":22},{"id":279,"city_name":"三沙市","initial":"S","is_del":0,"pid":22},{"id":24,"city_name":"四川","initial":"S","is_del":1,"pid":0},{"id":28,"city_name":"陕西","initial":"S","is_del":0,"pid":0},{"id":35,"city_name":"石家庄市","initial":"S","is_del":0,"pid":3},{"id":305,"city_name":"遂宁市","initial":"S","is_del":0,"pid":24},{"id":69,"city_name":"沈阳市","initial":"S","is_del":0,"pid":6},{"id":85,"city_name":"四平市","initial":"S","is_del":0,"pid":7},{"id":89,"city_name":"松原市","initial":"S","is_del":0,"pid":7},{"id":348,"city_name":"山南市","initial":"S","is_del":0,"pid":27},{"id":96,"city_name":"双鸭山市","initial":"S","is_del":0,"pid":8},{"id":103,"city_name":"绥化市","initial":"S","is_del":0,"pid":8},{"id":360,"city_name":"商洛市","initial":"S","is_del":0,"pid":28},{"id":105,"city_name":"上海市","initial":"S","is_del":0,"pid":9},{"id":110,"city_name":"苏州市","initial":"S","is_del":0,"pid":10},{"id":118,"city_name":"宿迁市","initial":"S","is_del":0,"pid":10},{"id":124,"city_name":"绍兴市","initial":"S","is_del":0,"pid":11},{"id":384,"city_name":"石嘴山市","initial":"S","is_del":0,"pid":31},{"id":141,"city_name":"宿州市","initial":"S","is_del":0,"pid":12},{"id":402,"city_name":"石河子市","initial":"S","is_del":0,"pid":32},{"id":149,"city_name":"三明市","initial":"S","is_del":0,"pid":13},{"id":408,"city_name":"双河市","initial":"S","is_del":0,"pid":32},{"id":165,"city_name":"上饶市","initial":"S","is_del":0,"pid":14},{"id":187,"city_name":"朔州市","initial":"S","is_del":0,"pid":16},{"id":204,"city_name":"三门峡市","initial":"S","is_del":0,"pid":17},{"id":206,"city_name":"商丘市","initial":"S","is_del":0,"pid":17},{"id":213,"city_name":"十堰市","initial":"S","is_del":0,"pid":18},{"id":222,"city_name":"随州市","initial":"S","is_del":0,"pid":18},{"id":227,"city_name":"神农架林区","initial":"S","is_del":0,"pid":18},{"id":232,"city_name":"邵阳市","initial":"S","is_del":0,"pid":19},{"id":243,"city_name":"韶关市","initial":"S","is_del":0,"pid":20},{"id":244,"city_name":"深圳市","initial":"S","is_del":0,"pid":20},{"id":246,"city_name":"汕头市","initial":"S","is_del":0,"pid":20},{"id":254,"city_name":"汕尾市","initial":"S","is_del":0,"pid":20},{"id":2,"city_name":"天津","initial":"T","is_del":0,"pid":0},{"id":287,"city_name":"屯昌县","initial":"T","is_del":0,"pid":22},{"id":34,"city_name":"天津市","initial":"T","is_del":0,"pid":2},{"id":36,"city_name":"唐山市","initial":"T","is_del":0,"pid":3},{"id":61,"city_name":"通辽市","initial":"T","is_del":0,"pid":5},{"id":324,"city_name":"铜仁市","initial":"T","is_del":0,"pid":25},{"id":80,"city_name":"铁岭市","initial":"T","is_del":0,"pid":6},{"id":87,"city_name":"通化市","initial":"T","is_del":0,"pid":7},{"id":352,"city_name":"铜川市","initial":"T","is_del":0,"pid":28},{"id":365,"city_name":"天水市","initial":"T","is_del":0,"pid":29},{"id":117,"city_name":"泰州市","initial":"T","is_del":0,"pid":10},{"id":128,"city_name":"台州市","initial":"T","is_del":0,"pid":11},{"id":390,"city_name":"吐鲁番市","initial":"T","is_del":0,"pid":32},{"id":136,"city_name":"铜陵市","initial":"T","is_del":0,"pid":12},{"id":400,"city_name":"塔城地区","initial":"T","is_del":0,"pid":32},{"id":404,"city_name":"图木舒克市","initial":"T","is_del":0,"pid":32},{"id":407,"city_name":"铁门关市","initial":"T","is_del":0,"pid":32},{"id":174,"city_name":"泰安市","initial":"T","is_del":0,"pid":15},{"id":182,"city_name":"太原市","initial":"T","is_del":0,"pid":16},{"id":226,"city_name":"天门市","initial":"T","is_del":0,"pid":18},{"id":266,"city_name":"梧州市","initial":"W","is_del":0,"pid":21},{"id":281,"city_name":"五指山市","initial":"W","is_del":0,"pid":22},{"id":283,"city_name":"文昌市","initial":"W","is_del":0,"pid":22},{"id":284,"city_name":"万宁市","initial":"W","is_del":0,"pid":22},{"id":59,"city_name":"乌海市","initial":"W","is_del":0,"pid":5},{"id":65,"city_name":"乌兰察布市","initial":"W","is_del":0,"pid":5},{"id":338,"city_name":"文山壮族苗族自治州","initial":"W","is_del":0,"pid":26},{"id":355,"city_name":"渭南市","initial":"W","is_del":0,"pid":28},{"id":107,"city_name":"无锡市","initial":"W","is_del":0,"pid":10},{"id":366,"city_name":"武威市","initial":"W","is_del":0,"pid":29},{"id":121,"city_name":"温州市","initial":"W","is_del":0,"pid":11},{"id":385,"city_name":"吴忠市","initial":"W","is_del":0,"pid":31},{"id":131,"city_name":"芜湖市","initial":"W","is_del":0,"pid":12},{"id":388,"city_name":"乌鲁木齐市","initial":"W","is_del":0,"pid":32},{"id":405,"city_name":"五家渠市","initial":"W","is_del":0,"pid":32},{"id":172,"city_name":"潍坊市","initial":"W","is_del":0,"pid":15},{"id":175,"city_name":"威海市","initial":"W","is_del":0,"pid":15},{"id":211,"city_name":"武汉市","initial":"W","is_del":0,"pid":18},{"id":27,"city_name":"西藏","initial":"X","is_del":0,"pid":0},{"id":32,"city_name":"新疆","initial":"X","is_del":1,"pid":0},{"id":39,"city_name":"邢台市","initial":"X","is_del":0,"pid":3},{"id":66,"city_name":"兴安盟","initial":"X","is_del":0,"pid":5},{"id":67,"city_name":"锡林郭勒盟","initial":"X","is_del":0,"pid":5},{"id":339,"city_name":"西双版纳傣族自治州","initial":"X","is_del":0,"pid":26},{"id":351,"city_name":"西安市","initial":"X","is_del":0,"pid":28},{"id":354,"city_name":"咸阳市","initial":"X","is_del":0,"pid":28},{"id":108,"city_name":"徐州市","initial":"X","is_del":0,"pid":10},{"id":375,"city_name":"西宁市","initial":"X","is_del":0,"pid":30},{"id":145,"city_name":"宣城市","initial":"X","is_del":0,"pid":12},{"id":147,"city_name":"厦门市","initial":"X","is_del":0,"pid":13},{"id":159,"city_name":"新余市","initial":"X","is_del":0,"pid":14},{"id":190,"city_name":"忻州市","initial":"X","is_del":0,"pid":16},{"id":199,"city_name":"新乡市","initial":"X","is_del":0,"pid":17},{"id":202,"city_name":"许昌市","initial":"X","is_del":0,"pid":17},{"id":207,"city_name":"信阳市","initial":"X","is_del":0,"pid":17},{"id":215,"city_name":"襄阳市","initial":"X","is_del":0,"pid":18},{"id":218,"city_name":"孝感市","initial":"X","is_del":0,"pid":18},{"id":221,"city_name":"咸宁市","initial":"X","is_del":0,"pid":18},{"id":224,"city_name":"仙桃市","initial":"X","is_del":0,"pid":18},{"id":230,"city_name":"湘潭市","initial":"X","is_del":0,"pid":19},{"id":241,"city_name":"湘西土家族苗族自治州","initial":"X","is_del":0,"pid":19},{"id":256,"city_name":"阳江市","initial":"Y","is_del":0,"pid":20},{"id":262,"city_name":"云浮市","initial":"Y","is_del":0,"pid":20},{"id":271,"city_name":"玉林市","initial":"Y","is_del":0,"pid":21},{"id":26,"city_name":"云南","initial":"Y","is_del":1,"pid":0},{"id":310,"city_name":"宜宾市","initial":"Y","is_del":0,"pid":24},{"id":313,"city_name":"雅安市","initial":"Y","is_del":0,"pid":24},{"id":330,"city_name":"玉溪市","initial":"Y","is_del":0,"pid":26},{"id":76,"city_name":"营口市","initial":"Y","is_del":0,"pid":6},{"id":91,"city_name":"延边朝鲜族自治州","initial":"Y","is_del":0,"pid":7},{"id":98,"city_name":"伊春市","initial":"Y","is_del":0,"pid":8},{"id":356,"city_name":"延安市","initial":"Y","is_del":0,"pid":28},{"id":358,"city_name":"榆林市","initial":"Y","is_del":0,"pid":28},{"id":114,"city_name":"盐城市","initial":"Y","is_del":0,"pid":10},{"id":115,"city_name":"扬州市","initial":"Y","is_del":0,"pid":10},{"id":381,"city_name":"玉树藏族自治州","initial":"Y","is_del":0,"pid":30},{"id":383,"city_name":"银川市","initial":"Y","is_del":0,"pid":31},{"id":399,"city_name":"伊犁哈萨克自治州","initial":"Y","is_del":0,"pid":32},{"id":160,"city_name":"鹰潭市","initial":"Y","is_del":0,"pid":14},{"id":163,"city_name":"宜春市","initial":"Y","is_del":0,"pid":14},{"id":171,"city_name":"烟台市","initial":"Y","is_del":0,"pid":15},{"id":184,"city_name":"阳泉市","initial":"Y","is_del":0,"pid":16},{"id":189,"city_name":"运城市","initial":"Y","is_del":0,"pid":16},{"id":201,"city_name":"濮阳市","initial":"Y","is_del":0,"pid":17},{"id":214,"city_name":"宜昌市","initial":"Y","is_del":0,"pid":18},{"id":233,"city_name":"岳阳市","initial":"Y","is_del":0,"pid":19},{"id":236,"city_name":"益阳市","initial":"Y","is_del":0,"pid":19},{"id":238,"city_name":"永州市","initial":"Y","is_del":0,"pid":19},{"id":259,"city_name":"中山市","initial":"Z","is_del":0,"pid":20},{"id":11,"city_name":"浙江","initial":"Z","is_del":0,"pid":0},{"id":280,"city_name":"儋州市","initial":"Z","is_del":0,"pid":22},{"id":41,"city_name":"张家口市","initial":"Z","is_del":0,"pid":3},{"id":297,"city_name":"重庆市","initial":"Z","is_del":0,"pid":23},{"id":299,"city_name":"自贡市","initial":"Z","is_del":0,"pid":24},{"id":301,"city_name":"泸州市","initial":"Z","is_del":0,"pid":24},{"id":315,"city_name":"资阳市","initial":"Z","is_del":0,"pid":24},{"id":321,"city_name":"遵义市","initial":"Z","is_del":0,"pid":25},{"id":332,"city_name":"昭通市","initial":"Z","is_del":0,"pid":26},{"id":367,"city_name":"张掖市","initial":"Z","is_del":0,"pid":29},{"id":116,"city_name":"镇江市","initial":"Z","is_del":0,"pid":10},{"id":126,"city_name":"衢州市","initial":"Z","is_del":0,"pid":11},{"id":127,"city_name":"舟山市","initial":"Z","is_del":0,"pid":11},{"id":387,"city_name":"中卫市","initial":"Z","is_del":0,"pid":31},{"id":143,"city_name":"亳州市","initial":"Z","is_del":0,"pid":12},{"id":151,"city_name":"漳州市","initial":"Z","is_del":0,"pid":13},{"id":168,"city_name":"淄博市","initial":"Z","is_del":0,"pid":15},{"id":169,"city_name":"枣庄市","initial":"Z","is_del":0,"pid":15},{"id":193,"city_name":"郑州市","initial":"Z","is_del":0,"pid":17},{"id":208,"city_name":"周口市","initial":"Z","is_del":0,"pid":17},{"id":209,"city_name":"驻马店市","initial":"Z","is_del":0,"pid":17},{"id":229,"city_name":"株洲市","initial":"Z","is_del":0,"pid":19},{"id":235,"city_name":"张家界市","initial":"Z","is_del":0,"pid":19},{"id":245,"city_name":"珠海市","initial":"Z","is_del":0,"pid":20},{"id":249,"city_name":"湛江市","initial":"Z","is_del":0,"pid":20},{"id":251,"city_name":"肇庆市","initial":"Z","is_del":0,"pid":20}]}';
//        $result = json_decode($res, true);
        $redis->delete($apikey);
//        $redis->set($apikey, $result['datas']);




die();
        Db::startTrans();
        try {

//
//            edit_user_score(24, 7495015, 16);
//            edit_user_scoreaway(8, 7495015, 16);
//
//            edit_user_score(24, 7496456, 40);
//            edit_user_scoreaway(8, 7496456, 40);
//
//            edit_user_score(24, 7494044, 40);
//            edit_user_scoreaway(8, 7494044, 40);

            edit_user_money(17, 7493428,10);


            Db::commit();
        }catch (\Exception $e){
            Db::rollback();

            return $e->getMessage();
        }

        return 'success';

        return AESjiami('abcd123456');

        die();
//        return Db::name('coupon_plan_log')->where('uid', 7501136)->where('plan_id', 'in', '278,282,279,283,275,280,277,281')->sum('buy_num');
        return Db::name('scorelock_log')->where('uid', 7501136)->where('plan_id', 'in', '278,282,279,283,275,280,277,281')->sum('buy_num');

        die();

        // 处理 18198666086	他积分扣5万   6086已经扣除25585
        edit_user_scoreaway(7 , 7572458, 8000);
        edit_user_scoreaway(7 , 7575889, 8000);
        edit_user_scoreaway(7 , 7603254, 6000);
        edit_user_scoreaway(7 , 7572324, 1500);
        edit_user_scoreaway(7 , 7605407, 1500);
        edit_user_scoreaway(7 , 7603010, 585);
        die();
//        15759476806   7588620
//        17537161112   7493442
//        13996260121   7520062
        $mobile = 13996260121;
        $uid = 7520062;
        $total_income = Db::name('payment')->where('state', 6)->where('order_type', 4)->where('uid', $uid)->sum('total_fee');
        $tx_success = Db::name('withdraw_log')->where('status', 1)->where('uid', $uid)->sum('apply_money');

        return $mobile.'充值:'.$total_income.',提现成功：'.$tx_success;

        
//        edit_user_scorelock1(1, 7495271, 1);
die();


//        Db::name('coupon_plan_log')->where('id', '>', 61805)->save(['is_get_dymic'=>2]);
//        return 22;


//        die();
//        $service = new UserServices();
//         try {
//             $service->withdraw(7493456, 100, 1);
//         }catch (Exception $e){
//              return $e->getMessage();
//         }
//
//         return 'success';
//        return Db::name('user')->where('id', 'not in', '7493266,7493267')->sum('score');
//        return Db::name('user')->where('id', 'not in', '7493266,7493267')->where('income_type', 2)->sum('score_away');
//        return 33;

//        return $income = Db::name('payment')->where('state', 6)->where('uid', 7601690)->where('order_type', 4)->sum('total_fee');
//        $withdraw = Db::name('withdraw_log')->where('status', 1)->where('uid', 7539494)->sum('apply_money');
//        return $income - $withdraw;
//        return Db::name('withdraw_log')->where('status', 1)->sum('practical_money');
////        272 277
//        return Db::name('coupon_plan_log')->where('plan_id','in','272')->where('uid', 'not in', '7493266,7493267')->sum('buy_num');
//        $arr = [
//            '超过10000笔数'=>Db::name('withdraw_log')->where('practical_money', '>', 10000)->where('status', 0)->count('id'),
//            '超过10000总金额'=>Db::name('withdraw_log')->where('practical_money', '>', 10000)->where('status', 0)->sum('practical_money'),
//        ];
//
//        return json_encode($arr);
//
//        die();

//        edit_user_score(20, 7569185, 2160);
//        edit_user_score(20, 7493480, 60);
//        return 22;
//        die();
//        return Db::name('user')->where('id', 'not in', '7493267,7493266')->sum('score');
//        return Db::name('coupon_plan_log')->where('uid', 'not in', '7493267,7493266')->where('plan_id', '266')->sum('buy_num');
//        return Db::name('user')->where('id', 'not in', '7493267,7493266')->whereFindInSet('path', '7493430')->sum('buy_num');
//
//        return Db::name('coupon_plan_log')->whereDay('create_time', '-1 day')->where('uid', 'not in', '7493267')->sum('buy_num');
//        return Db::name('coupon_plan_log')->whereDay('create_time', '-1 day')->where('uid', 'not in', '7493267')->sum('buy_num');

//        die();



        $apikey = 'dianfeiarea';
        $redis = new Redis();
        $res = '{"code":200,"msg":"查询成功","datas":[{"id":12,"city_name":"安徽","initial":"A","is_del":0,"pid":0},{"id":316,"city_name":"阿坝藏族羌族自治州","initial":"A","is_del":0,"pid":24},{"id":322,"city_name":"安顺市","initial":"A","is_del":0,"pid":25},{"id":68,"city_name":"阿拉善盟","initial":"A","is_del":0,"pid":5},{"id":71,"city_name":"鞍山市","initial":"A","is_del":0,"pid":6},{"id":350,"city_name":"阿里地区","initial":"A","is_del":0,"pid":27},{"id":359,"city_name":"安康市","initial":"A","is_del":0,"pid":28},{"id":137,"city_name":"安庆市","initial":"A","is_del":0,"pid":12},{"id":395,"city_name":"阿克苏地区","initial":"A","is_del":0,"pid":32},{"id":401,"city_name":"阿勒泰地区","initial":"A","is_del":0,"pid":32},{"id":403,"city_name":"阿拉尔市","initial":"A","is_del":0,"pid":32},{"id":197,"city_name":"安阳市","initial":"A","is_del":0,"pid":17},{"id":1,"city_name":"北京","initial":"B","is_del":0,"pid":0},{"id":267,"city_name":"北海市","initial":"B","is_del":0,"pid":21},{"id":272,"city_name":"百色市","initial":"B","is_del":0,"pid":21},{"id":33,"city_name":"北京市","initial":"B","is_del":0,"pid":1},{"id":290,"city_name":"白沙黎族自治县","initial":"B","is_del":0,"pid":22},{"id":294,"city_name":"保亭黎族苗族自治县","initial":"B","is_del":0,"pid":22},{"id":40,"city_name":"保定市","initial":"B","is_del":0,"pid":3},{"id":58,"city_name":"包头市","initial":"B","is_del":0,"pid":5},{"id":314,"city_name":"巴中市","initial":"B","is_del":0,"pid":24},{"id":64,"city_name":"巴彦淖尔市","initial":"B","is_del":0,"pid":5},{"id":323,"city_name":"毕节市","initial":"B","is_del":0,"pid":25},{"id":73,"city_name":"本溪市","initial":"B","is_del":0,"pid":6},{"id":331,"city_name":"保山市","initial":"B","is_del":0,"pid":26},{"id":88,"city_name":"白山市","initial":"B","is_del":0,"pid":7},{"id":90,"city_name":"白城市","initial":"B","is_del":0,"pid":7},{"id":353,"city_name":"宝鸡市","initial":"B","is_del":0,"pid":28},{"id":364,"city_name":"白银市","initial":"B","is_del":0,"pid":29},{"id":132,"city_name":"蚌埠市","initial":"B","is_del":0,"pid":12},{"id":393,"city_name":"博尔塔拉蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":394,"city_name":"巴音郭楞蒙古自治州","initial":"B","is_del":0,"pid":32},{"id":406,"city_name":"北屯市","initial":"B","is_del":0,"pid":32},{"id":180,"city_name":"滨州市","initial":"B","is_del":0,"pid":15},{"id":260,"city_name":"潮州市","initial":"C","is_del":0,"pid":20},{"id":276,"city_name":"崇左市","initial":"C","is_del":0,"pid":21},{"id":23,"city_name":"重庆","initial":"C","is_del":0,"pid":0},{"id":288,"city_name":"澄迈县","initial":"C","is_del":0,"pid":22},{"id":291,"city_name":"昌江黎族自治县","initial":"C","is_del":0,"pid":22},{"id":42,"city_name":"承德市","initial":"C","is_del":0,"pid":3},{"id":298,"city_name":"成都市","initial":"C","is_del":0,"pid":24},{"id":43,"city_name":"沧州市","initial":"C","is_del":0,"pid":3},{"id":60,"city_name":"赤峰市","initial":"C","is_del":0,"pid":5},{"id":336,"city_name":"楚雄彝族自治州","initial":"C","is_del":0,"pid":26},{"id":81,"city_name":"朝阳市","initial":"C","is_del":0,"pid":6},{"id":83,"city_name":"长春市","initial":"C","is_del":0,"pid":7},{"id":346,"city_name":"昌都市","initial":"C","is_del":0,"pid":27},{"id":109,"city_name":"常州市","initial":"C","is_del":0,"pid":10},{"id":392,"city_name":"昌吉回族自治州","initial":"C","is_del":0,"pid":32},{"id":139,"city_name":"滁州市","initial":"C","is_del":0,"pid":12},{"id":144,"city_name":"池州市","initial":"C","is_del":0,"pid":12},{"id":185,"city_name":"长治市","initial":"C","is_del":0,"pid":16},{"id":228,"city_name":"长沙市","initial":"C","is_del":0,"pid":19},{"id":234,"city_name":"常德市","initial":"C","is_del":0,"pid":19},{"id":237,"city_name":"郴州市","initial":"C","is_del":0,"pid":19},{"id":258,"city_name":"东莞市","initial":"D","is_del":0,"pid":20},{"id":285,"city_name":"东方市","initial":"D","is_del":0,"pid":22},{"id":286,"city_name":"定安县","initial":"D","is_del":0,"pid":22},{"id":302,"city_name":"德阳市","initial":"D","is_del":0,"pid":24},{"id":312,"city_name":"达州市","initial":"D","is_del":0,"pid":24},{"id":70,"city_name":"大连市","initial":"D","is_del":0,"pid":6},{"id":74,"city_name":"丹东市","initial":"D","is_del":0,"pid":6},{"id":340,"city_name":"大理白族自治州","initial":"D","is_del":0,"pid":26},{"id":341,"city_name":"德宏傣族景颇族自治州","initial":"D","is_del":0,"pid":26},{"id":343,"city_name":"迪庆藏族自治州","initial":"D","is_del":0,"pid":26},{"id":97,"city_name":"大庆市","initial":"D","is_del":0,"pid":8},{"id":104,"city_name":"大兴安岭地区","initial":"D","is_del":0,"pid":8},{"id":371,"city_name":"定西市","initial":"D","is_del":0,"pid":29},{"id":170,"city_name":"东营市","initial":"D","is_del":0,"pid":15},{"id":178,"city_name":"德州市","initial":"D","is_del":0,"pid":15},{"id":183,"city_name":"大同市","initial":"D","is_del":0,"pid":16},{"id":62,"city_name":"鄂尔多斯市","initial":"E","is_del":0,"pid":5},{"id":216,"city_name":"鄂州市","initial":"E","is_del":0,"pid":18},{"id":223,"city_name":"恩施土家族苗族自治州","initial":"E","is_del":0,"pid":18},{"id":268,"city_name":"防城港市","initial":"F","is_del":0,"pid":21},{"id":13,"city_name":"福建","initial":"F","is_del":0,"pid":0},{"id":72,"city_name":"抚顺市","initial":"F","is_del":0,"pid":6},{"id":77,"city_name":"阜新市","initial":"F","is_del":0,"pid":6},{"id":140,"city_name":"阜阳市","initial":"F","is_del":0,"pid":12},{"id":146,"city_name":"福州市","initial":"F","is_del":0,"pid":13},{"id":164,"city_name":"抚州市","initial":"F","is_del":0,"pid":14},{"id":247,"city_name":"佛山市","initial":"F","is_del":0,"pid":20},{"id":265,"city_name":"桂林市","initial":"G","is_del":0,"pid":21},{"id":270,"city_name":"贵港市","initial":"G","is_del":0,"pid":21},{"id":20,"city_name":"广东","initial":"G","is_del":1,"pid":0},{"id":21,"city_name":"广西","initial":"G","is_del":1,"pid":0},{"id":25,"city_name":"贵州","initial":"G","is_del":1,"pid":0},{"id":29,"city_name":"甘肃","initial":"G","is_del":0,"pid":0},{"id":304,"city_name":"广元市","initial":"G","is_del":0,"pid":24},{"id":311,"city_name":"广安市","initial":"G","is_del":0,"pid":24},{"id":317,"city_name":"甘孜藏族自治州","initial":"G","is_del":0,"pid":24},{"id":319,"city_name":"贵阳市","initial":"G","is_del":0,"pid":25},{"id":374,"city_name":"甘南藏族自治州","initial":"G","is_del":0,"pid":29},{"id":380,"city_name":"果洛藏族自治州","initial":"G","is_del":0,"pid":30},{"id":386,"city_name":"固原市","initial":"G","is_del":0,"pid":31},{"id":161,"city_name":"赣州市","initial":"G","is_del":0,"pid":14},{"id":242,"city_name":"广州市","initial":"G","is_del":0,"pid":20},{"id":3,"city_name":"河北","initial":"H","is_del":0,"pid":0},{"id":8,"city_name":"黑龙江","initial":"H","is_del":0,"pid":0},{"id":17,"city_name":"河南","initial":"H","is_del":0,"pid":0},{"id":273,"city_name":"贺州市","initial":"H","is_del":0,"pid":21},{"id":18,"city_name":"湖北","initial":"H","is_del":0,"pid":0},{"id":274,"city_name":"河池市","initial":"H","is_del":0,"pid":21},{"id":19,"city_name":"湖南","initial":"H","is_del":0,"pid":0},{"id":277,"city_name":"海口市","initial":"H","is_del":0,"pid":22},{"id":22,"city_name":"海南","initial":"H","is_del":1,"pid":0},{"id":38,"city_name":"邯郸市","initial":"H","is_del":0,"pid":3},{"id":45,"city_name":"衡水市","initial":"H","is_del":0,"pid":3},{"id":57,"city_name":"呼和浩特市","initial":"H","is_del":0,"pid":5},{"id":63,"city_name":"呼伦贝尔市","initial":"H","is_del":0,"pid":5},{"id":337,"city_name":"红河哈尼族彝族自治州","initial":"H","is_del":0,"pid":26},{"id":82,"city_name":"葫芦岛市","initial":"H","is_del":0,"pid":6},{"id":92,"city_name":"哈尔滨市","initial":"H","is_del":0,"pid":8},{"id":95,"city_name":"鹤岗市","initial":"H","is_del":0,"pid":8},{"id":357,"city_name":"汉中市","initial":"H","is_del":0,"pid":28},{"id":102,"city_name":"黑河市","initial":"H","is_del":0,"pid":8},{"id":113,"city_name":"淮安市","initial":"H","is_del":0,"pid":10},{"id":119,"city_name":"杭州市","initial":"H","is_del":0,"pid":11},{"id":376,"city_name":"海东市","initial":"H","is_del":0,"pid":30},{"id":377,"city_name":"海北藏族自治州","initial":"H","is_del":0,"pid":30},{"id":378,"city_name":"黄南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":123,"city_name":"湖州市","initial":"H","is_del":0,"pid":11},{"id":379,"city_name":"海南藏族自治州","initial":"H","is_del":0,"pid":30},{"id":382,"city_name":"海西蒙古族藏族自治州","initial":"H","is_del":0,"pid":30},{"id":130,"city_name":"合肥市","initial":"H","is_del":0,"pid":12},{"id":133,"city_name":"淮南市","initial":"H","is_del":0,"pid":12},{"id":135,"city_name":"淮北市","initial":"H","is_del":0,"pid":12},{"id":391,"city_name":"哈密市","initial":"H","is_del":0,"pid":32},{"id":138,"city_name":"黄山市","initial":"H","is_del":0,"pid":12},{"id":398,"city_name":"和田地区","initial":"H","is_del":0,"pid":32},{"id":411,"city_name":"胡杨河市","initial":"H","is_del":0,"pid":32},{"id":181,"city_name":"菏泽市","initial":"H","is_del":0,"pid":15},{"id":198,"city_name":"鹤壁市","initial":"H","is_del":0,"pid":17},{"id":203,"city_name":"漯河市","initial":"H","is_del":0,"pid":17},{"id":212,"city_name":"黄石市","initial":"H","is_del":0,"pid":18},{"id":220,"city_name":"黄冈市","initial":"H","is_del":0,"pid":18},{"id":231,"city_name":"衡阳市","initial":"H","is_del":0,"pid":19},{"id":239,"city_name":"怀化市","initial":"H","is_del":0,"pid":19},{"id":252,"city_name":"惠州市","initial":"H","is_del":0,"pid":20},{"id":255,"city_name":"河源市","initial":"H","is_del":0,"pid":20},{"id":261,"city_name":"揭阳市","initial":"J","is_del":0,"pid":20},{"id":7,"city_name":"吉林","initial":"J","is_del":0,"pid":0},{"id":10,"city_name":"江苏","initial":"J","is_del":0,"pid":0},{"id":14,"city_name":"江西","initial":"J","is_del":0,"pid":0},{"id":75,"city_name":"锦州市","initial":"J","is_del":0,"pid":6},{"id":84,"city_name":"吉林市","initial":"J","is_del":0,"pid":7},{"id":94,"city_name":"鸡西市","initial":"J","is_del":0,"pid":8},{"id":99,"city_name":"佳木斯市","initial":"J","is_del":0,"pid":8},{"id":362,"city_name":"嘉峪关市","initial":"J","is_del":0,"pid":29},{"id":363,"city_name":"金昌市","initial":"J","is_del":0,"pid":29},{"id":369,"city_name":"酒泉市","initial":"J","is_del":0,"pid":29},{"id":122,"city_name":"嘉兴市","initial":"J","is_del":0,"pid":11},{"id":125,"city_name":"金华市","initial":"J","is_del":0,"pid":11},{"id":156,"city_name":"景德镇市","initial":"J","is_del":0,"pid":14},{"id":158,"city_name":"九江市","initial":"J","is_del":0,"pid":14},{"id":162,"city_name":"吉安市","initial":"J","is_del":0,"pid":14},{"id":166,"city_name":"济南市","initial":"J","is_del":0,"pid":15},{"id":173,"city_name":"济宁市","initial":"J","is_del":0,"pid":15},{"id":186,"city_name":"晋城市","initial":"J","is_del":0,"pid":16},{"id":188,"city_name":"晋中市","initial":"J","is_del":0,"pid":16},{"id":200,"city_name":"焦作市","initial":"J","is_del":0,"pid":17},{"id":210,"city_name":"济源市","initial":"J","is_del":0,"pid":17},{"id":217,"city_name":"荆门市","initial":"J","is_del":0,"pid":18},{"id":219,"city_name":"荆州市","initial":"J","is_del":0,"pid":18},{"id":248,"city_name":"江门市","initial":"J","is_del":0,"pid":20},{"id":328,"city_name":"昆明市","initial":"K","is_del":0,"pid":26},{"id":389,"city_name":"克拉玛依市","initial":"K","is_del":0,"pid":32},{"id":396,"city_name":"克孜勒苏柯尔克孜自治州","initial":"K","is_del":0,"pid":32},{"id":397,"city_name":"喀什地区","initial":"K","is_del":0,"pid":32},{"id":409,"city_name":"可克达拉市","initial":"K","is_del":0,"pid":32},{"id":410,"city_name":"昆玉市","initial":"K","is_del":0,"pid":32},{"id":194,"city_name":"开封市","initial":"K","is_del":0,"pid":17},{"id":6,"city_name":"辽宁","initial":"L","is_del":0,"pid":0},{"id":264,"city_name":"柳州市","initial":"L","is_del":0,"pid":21},{"id":275,"city_name":"来宾市","initial":"L","is_del":0,"pid":21},{"id":289,"city_name":"临高县","initial":"L","is_del":0,"pid":22},{"id":292,"city_name":"乐东黎族自治县","initial":"L","is_del":0,"pid":22},{"id":293,"city_name":"陵水黎族自治县","initial":"L","is_del":0,"pid":22},{"id":44,"city_name":"廊坊市","initial":"L","is_del":0,"pid":3},{"id":307,"city_name":"乐山市","initial":"L","is_del":0,"pid":24},{"id":318,"city_name":"凉山彝族自治州","initial":"L","is_del":0,"pid":24},{"id":320,"city_name":"六盘水市","initial":"L","is_del":0,"pid":25},{"id":333,"city_name":"丽江市","initial":"L","is_del":0,"pid":26},{"id":78,"city_name":"辽阳市","initial":"L","is_del":0,"pid":6},{"id":335,"city_name":"临沧市","initial":"L","is_del":0,"pid":26},{"id":86,"city_name":"辽源市","initial":"L","is_del":0,"pid":7},{"id":344,"city_name":"拉萨市","initial":"L","is_del":0,"pid":27},{"id":347,"city_name":"林芝市","initial":"L","is_del":0,"pid":27},{"id":361,"city_name":"兰州市","initial":"L","is_del":0,"pid":29},{"id":112,"city_name":"连云港市","initial":"L","is_del":0,"pid":10},{"id":372,"city_name":"陇南市","initial":"L","is_del":0,"pid":29},{"id":373,"city_name":"临夏回族自治州","initial":"L","is_del":0,"pid":29},{"id":129,"city_name":"丽水市","initial":"L","is_del":0,"pid":11},{"id":142,"city_name":"六安市","initial":"L","is_del":0,"pid":12},{"id":153,"city_name":"龙岩市","initial":"L","is_del":0,"pid":13},{"id":177,"city_name":"临沂市","initial":"L","is_del":0,"pid":15},{"id":179,"city_name":"聊城市","initial":"L","is_del":0,"pid":15},{"id":191,"city_name":"临汾市","initial":"L","is_del":0,"pid":16},{"id":192,"city_name":"吕梁市","initial":"L","is_del":0,"pid":16},{"id":195,"city_name":"洛阳市","initial":"L","is_del":0,"pid":17},{"id":240,"city_name":"娄底市","initial":"L","is_del":0,"pid":19},{"id":303,"city_name":"绵阳市","initial":"M","is_del":0,"pid":24},{"id":309,"city_name":"眉山市","initial":"M","is_del":0,"pid":24},{"id":101,"city_name":"牡丹江市","initial":"M","is_del":0,"pid":8},{"id":134,"city_name":"马鞍山市","initial":"M","is_del":0,"pid":12},{"id":250,"city_name":"茂名市","initial":"M","is_del":0,"pid":20},{"id":253,"city_name":"梅州市","initial":"M","is_del":0,"pid":20},{"id":5,"city_name":"内蒙古","initial":"N","is_del":1,"pid":0},{"id":263,"city_name":"南宁市","initial":"N","is_del":0,"pid":21},{"id":31,"city_name":"宁夏","initial":"N","is_del":0,"pid":0},{"id":306,"city_name":"内江市","initial":"N","is_del":0,"pid":24},{"id":308,"city_name":"南充市","initial":"N","is_del":0,"pid":24},{"id":342,"city_name":"怒江傈僳族自治州","initial":"N","is_del":0,"pid":26},{"id":349,"city_name":"那曲市","initial":"N","is_del":0,"pid":27},{"id":106,"city_name":"南京市","initial":"N","is_del":0,"pid":10},{"id":111,"city_name":"南通市","initial":"N","is_del":0,"pid":10},{"id":120,"city_name":"宁波市","initial":"N","is_del":0,"pid":11},{"id":152,"city_name":"南平市","initial":"N","is_del":0,"pid":13},{"id":154,"city_name":"宁德市","initial":"N","is_del":0,"pid":13},{"id":155,"city_name":"南昌市","initial":"N","is_del":0,"pid":14},{"id":205,"city_name":"南阳市","initial":"N","is_del":0,"pid":17},{"id":300,"city_name":"攀枝花市","initial":"P","is_del":0,"pid":24},{"id":334,"city_name":"普洱市","initial":"P","is_del":0,"pid":26},{"id":79,"city_name":"盘锦市","initial":"P","is_del":0,"pid":6},{"id":368,"city_name":"平凉市","initial":"P","is_del":0,"pid":29},{"id":148,"city_name":"莆田市","initial":"P","is_del":0,"pid":13},{"id":157,"city_name":"萍乡市","initial":"P","is_del":0,"pid":14},{"id":196,"city_name":"平顶山市","initial":"P","is_del":0,"pid":17},{"id":257,"city_name":"清远市","initial":"Q","is_del":0,"pid":20},{"id":269,"city_name":"钦州市","initial":"Q","is_del":0,"pid":21},{"id":282,"city_name":"琼海市","initial":"Q","is_del":0,"pid":22},{"id":30,"city_name":"青海","initial":"Q","is_del":0,"pid":0},{"id":37,"city_name":"秦皇岛市","initial":"Q","is_del":0,"pid":3},{"id":295,"city_name":"琼中黎族苗族自治县","initial":"Q","is_del":0,"pid":22},{"id":325,"city_name":"黔西南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":326,"city_name":"黔东南苗族侗族自治州","initial":"Q","is_del":0,"pid":25},{"id":327,"city_name":"黔南布依族苗族自治州","initial":"Q","is_del":0,"pid":25},{"id":329,"city_name":"曲靖市","initial":"Q","is_del":0,"pid":26},{"id":93,"city_name":"齐齐哈尔市","initial":"Q","is_del":0,"pid":8},{"id":100,"city_name":"七台河市","initial":"Q","is_del":0,"pid":8},{"id":370,"city_name":"庆阳市","initial":"Q","is_del":0,"pid":29},{"id":150,"city_name":"泉州市","initial":"Q","is_del":0,"pid":13},{"id":167,"city_name":"青岛市","initial":"Q","is_del":0,"pid":15},{"id":225,"city_name":"潜江市","initial":"Q","is_del":0,"pid":18},{"id":345,"city_name":"日喀则市","initial":"R","is_del":0,"pid":27},{"id":176,"city_name":"日照市","initial":"R","is_del":0,"pid":15},{"id":9,"city_name":"上海","initial":"S","is_del":1,"pid":0},{"id":15,"city_name":"山东","initial":"S","is_del":0,"pid":0},{"id":16,"city_name":"山西","initial":"S","is_del":0,"pid":0},{"id":278,"city_name":"三亚市","initial":"S","is_del":0,"pid":22},{"id":279,"city_name":"三沙市","initial":"S","is_del":0,"pid":22},{"id":24,"city_name":"四川","initial":"S","is_del":1,"pid":0},{"id":28,"city_name":"陕西","initial":"S","is_del":0,"pid":0},{"id":35,"city_name":"石家庄市","initial":"S","is_del":0,"pid":3},{"id":305,"city_name":"遂宁市","initial":"S","is_del":0,"pid":24},{"id":69,"city_name":"沈阳市","initial":"S","is_del":0,"pid":6},{"id":85,"city_name":"四平市","initial":"S","is_del":0,"pid":7},{"id":89,"city_name":"松原市","initial":"S","is_del":0,"pid":7},{"id":348,"city_name":"山南市","initial":"S","is_del":0,"pid":27},{"id":96,"city_name":"双鸭山市","initial":"S","is_del":0,"pid":8},{"id":103,"city_name":"绥化市","initial":"S","is_del":0,"pid":8},{"id":360,"city_name":"商洛市","initial":"S","is_del":0,"pid":28},{"id":105,"city_name":"上海市","initial":"S","is_del":0,"pid":9},{"id":110,"city_name":"苏州市","initial":"S","is_del":0,"pid":10},{"id":118,"city_name":"宿迁市","initial":"S","is_del":0,"pid":10},{"id":124,"city_name":"绍兴市","initial":"S","is_del":0,"pid":11},{"id":384,"city_name":"石嘴山市","initial":"S","is_del":0,"pid":31},{"id":141,"city_name":"宿州市","initial":"S","is_del":0,"pid":12},{"id":402,"city_name":"石河子市","initial":"S","is_del":0,"pid":32},{"id":149,"city_name":"三明市","initial":"S","is_del":0,"pid":13},{"id":408,"city_name":"双河市","initial":"S","is_del":0,"pid":32},{"id":165,"city_name":"上饶市","initial":"S","is_del":0,"pid":14},{"id":187,"city_name":"朔州市","initial":"S","is_del":0,"pid":16},{"id":204,"city_name":"三门峡市","initial":"S","is_del":0,"pid":17},{"id":206,"city_name":"商丘市","initial":"S","is_del":0,"pid":17},{"id":213,"city_name":"十堰市","initial":"S","is_del":0,"pid":18},{"id":222,"city_name":"随州市","initial":"S","is_del":0,"pid":18},{"id":227,"city_name":"神农架林区","initial":"S","is_del":0,"pid":18},{"id":232,"city_name":"邵阳市","initial":"S","is_del":0,"pid":19},{"id":243,"city_name":"韶关市","initial":"S","is_del":0,"pid":20},{"id":244,"city_name":"深圳市","initial":"S","is_del":0,"pid":20},{"id":246,"city_name":"汕头市","initial":"S","is_del":0,"pid":20},{"id":254,"city_name":"汕尾市","initial":"S","is_del":0,"pid":20},{"id":2,"city_name":"天津","initial":"T","is_del":0,"pid":0},{"id":287,"city_name":"屯昌县","initial":"T","is_del":0,"pid":22},{"id":34,"city_name":"天津市","initial":"T","is_del":0,"pid":2},{"id":36,"city_name":"唐山市","initial":"T","is_del":0,"pid":3},{"id":61,"city_name":"通辽市","initial":"T","is_del":0,"pid":5},{"id":324,"city_name":"铜仁市","initial":"T","is_del":0,"pid":25},{"id":80,"city_name":"铁岭市","initial":"T","is_del":0,"pid":6},{"id":87,"city_name":"通化市","initial":"T","is_del":0,"pid":7},{"id":352,"city_name":"铜川市","initial":"T","is_del":0,"pid":28},{"id":365,"city_name":"天水市","initial":"T","is_del":0,"pid":29},{"id":117,"city_name":"泰州市","initial":"T","is_del":0,"pid":10},{"id":128,"city_name":"台州市","initial":"T","is_del":0,"pid":11},{"id":390,"city_name":"吐鲁番市","initial":"T","is_del":0,"pid":32},{"id":136,"city_name":"铜陵市","initial":"T","is_del":0,"pid":12},{"id":400,"city_name":"塔城地区","initial":"T","is_del":0,"pid":32},{"id":404,"city_name":"图木舒克市","initial":"T","is_del":0,"pid":32},{"id":407,"city_name":"铁门关市","initial":"T","is_del":0,"pid":32},{"id":174,"city_name":"泰安市","initial":"T","is_del":0,"pid":15},{"id":182,"city_name":"太原市","initial":"T","is_del":0,"pid":16},{"id":226,"city_name":"天门市","initial":"T","is_del":0,"pid":18},{"id":266,"city_name":"梧州市","initial":"W","is_del":0,"pid":21},{"id":281,"city_name":"五指山市","initial":"W","is_del":0,"pid":22},{"id":283,"city_name":"文昌市","initial":"W","is_del":0,"pid":22},{"id":284,"city_name":"万宁市","initial":"W","is_del":0,"pid":22},{"id":59,"city_name":"乌海市","initial":"W","is_del":0,"pid":5},{"id":65,"city_name":"乌兰察布市","initial":"W","is_del":0,"pid":5},{"id":338,"city_name":"文山壮族苗族自治州","initial":"W","is_del":0,"pid":26},{"id":355,"city_name":"渭南市","initial":"W","is_del":0,"pid":28},{"id":107,"city_name":"无锡市","initial":"W","is_del":0,"pid":10},{"id":366,"city_name":"武威市","initial":"W","is_del":0,"pid":29},{"id":121,"city_name":"温州市","initial":"W","is_del":0,"pid":11},{"id":385,"city_name":"吴忠市","initial":"W","is_del":0,"pid":31},{"id":131,"city_name":"芜湖市","initial":"W","is_del":0,"pid":12},{"id":388,"city_name":"乌鲁木齐市","initial":"W","is_del":0,"pid":32},{"id":405,"city_name":"五家渠市","initial":"W","is_del":0,"pid":32},{"id":172,"city_name":"潍坊市","initial":"W","is_del":0,"pid":15},{"id":175,"city_name":"威海市","initial":"W","is_del":0,"pid":15},{"id":211,"city_name":"武汉市","initial":"W","is_del":0,"pid":18},{"id":27,"city_name":"西藏","initial":"X","is_del":0,"pid":0},{"id":32,"city_name":"新疆","initial":"X","is_del":1,"pid":0},{"id":39,"city_name":"邢台市","initial":"X","is_del":0,"pid":3},{"id":66,"city_name":"兴安盟","initial":"X","is_del":0,"pid":5},{"id":67,"city_name":"锡林郭勒盟","initial":"X","is_del":0,"pid":5},{"id":339,"city_name":"西双版纳傣族自治州","initial":"X","is_del":0,"pid":26},{"id":351,"city_name":"西安市","initial":"X","is_del":0,"pid":28},{"id":354,"city_name":"咸阳市","initial":"X","is_del":0,"pid":28},{"id":108,"city_name":"徐州市","initial":"X","is_del":0,"pid":10},{"id":375,"city_name":"西宁市","initial":"X","is_del":0,"pid":30},{"id":145,"city_name":"宣城市","initial":"X","is_del":0,"pid":12},{"id":147,"city_name":"厦门市","initial":"X","is_del":0,"pid":13},{"id":159,"city_name":"新余市","initial":"X","is_del":0,"pid":14},{"id":190,"city_name":"忻州市","initial":"X","is_del":0,"pid":16},{"id":199,"city_name":"新乡市","initial":"X","is_del":0,"pid":17},{"id":202,"city_name":"许昌市","initial":"X","is_del":0,"pid":17},{"id":207,"city_name":"信阳市","initial":"X","is_del":0,"pid":17},{"id":215,"city_name":"襄阳市","initial":"X","is_del":0,"pid":18},{"id":218,"city_name":"孝感市","initial":"X","is_del":0,"pid":18},{"id":221,"city_name":"咸宁市","initial":"X","is_del":0,"pid":18},{"id":224,"city_name":"仙桃市","initial":"X","is_del":0,"pid":18},{"id":230,"city_name":"湘潭市","initial":"X","is_del":0,"pid":19},{"id":241,"city_name":"湘西土家族苗族自治州","initial":"X","is_del":0,"pid":19},{"id":256,"city_name":"阳江市","initial":"Y","is_del":0,"pid":20},{"id":262,"city_name":"云浮市","initial":"Y","is_del":0,"pid":20},{"id":271,"city_name":"玉林市","initial":"Y","is_del":0,"pid":21},{"id":26,"city_name":"云南","initial":"Y","is_del":1,"pid":0},{"id":310,"city_name":"宜宾市","initial":"Y","is_del":0,"pid":24},{"id":313,"city_name":"雅安市","initial":"Y","is_del":0,"pid":24},{"id":330,"city_name":"玉溪市","initial":"Y","is_del":0,"pid":26},{"id":76,"city_name":"营口市","initial":"Y","is_del":0,"pid":6},{"id":91,"city_name":"延边朝鲜族自治州","initial":"Y","is_del":0,"pid":7},{"id":98,"city_name":"伊春市","initial":"Y","is_del":0,"pid":8},{"id":356,"city_name":"延安市","initial":"Y","is_del":0,"pid":28},{"id":358,"city_name":"榆林市","initial":"Y","is_del":0,"pid":28},{"id":114,"city_name":"盐城市","initial":"Y","is_del":0,"pid":10},{"id":115,"city_name":"扬州市","initial":"Y","is_del":0,"pid":10},{"id":381,"city_name":"玉树藏族自治州","initial":"Y","is_del":0,"pid":30},{"id":383,"city_name":"银川市","initial":"Y","is_del":0,"pid":31},{"id":399,"city_name":"伊犁哈萨克自治州","initial":"Y","is_del":0,"pid":32},{"id":160,"city_name":"鹰潭市","initial":"Y","is_del":0,"pid":14},{"id":163,"city_name":"宜春市","initial":"Y","is_del":0,"pid":14},{"id":171,"city_name":"烟台市","initial":"Y","is_del":0,"pid":15},{"id":184,"city_name":"阳泉市","initial":"Y","is_del":0,"pid":16},{"id":189,"city_name":"运城市","initial":"Y","is_del":0,"pid":16},{"id":201,"city_name":"濮阳市","initial":"Y","is_del":0,"pid":17},{"id":214,"city_name":"宜昌市","initial":"Y","is_del":0,"pid":18},{"id":233,"city_name":"岳阳市","initial":"Y","is_del":0,"pid":19},{"id":236,"city_name":"益阳市","initial":"Y","is_del":0,"pid":19},{"id":238,"city_name":"永州市","initial":"Y","is_del":0,"pid":19},{"id":259,"city_name":"中山市","initial":"Z","is_del":0,"pid":20},{"id":11,"city_name":"浙江","initial":"Z","is_del":0,"pid":0},{"id":280,"city_name":"儋州市","initial":"Z","is_del":0,"pid":22},{"id":41,"city_name":"张家口市","initial":"Z","is_del":0,"pid":3},{"id":297,"city_name":"重庆市","initial":"Z","is_del":0,"pid":23},{"id":299,"city_name":"自贡市","initial":"Z","is_del":0,"pid":24},{"id":301,"city_name":"泸州市","initial":"Z","is_del":0,"pid":24},{"id":315,"city_name":"资阳市","initial":"Z","is_del":0,"pid":24},{"id":321,"city_name":"遵义市","initial":"Z","is_del":0,"pid":25},{"id":332,"city_name":"昭通市","initial":"Z","is_del":0,"pid":26},{"id":367,"city_name":"张掖市","initial":"Z","is_del":0,"pid":29},{"id":116,"city_name":"镇江市","initial":"Z","is_del":0,"pid":10},{"id":126,"city_name":"衢州市","initial":"Z","is_del":0,"pid":11},{"id":127,"city_name":"舟山市","initial":"Z","is_del":0,"pid":11},{"id":387,"city_name":"中卫市","initial":"Z","is_del":0,"pid":31},{"id":143,"city_name":"亳州市","initial":"Z","is_del":0,"pid":12},{"id":151,"city_name":"漳州市","initial":"Z","is_del":0,"pid":13},{"id":168,"city_name":"淄博市","initial":"Z","is_del":0,"pid":15},{"id":169,"city_name":"枣庄市","initial":"Z","is_del":0,"pid":15},{"id":193,"city_name":"郑州市","initial":"Z","is_del":0,"pid":17},{"id":208,"city_name":"周口市","initial":"Z","is_del":0,"pid":17},{"id":209,"city_name":"驻马店市","initial":"Z","is_del":0,"pid":17},{"id":229,"city_name":"株洲市","initial":"Z","is_del":0,"pid":19},{"id":235,"city_name":"张家界市","initial":"Z","is_del":0,"pid":19},{"id":245,"city_name":"珠海市","initial":"Z","is_del":0,"pid":20},{"id":249,"city_name":"湛江市","initial":"Z","is_del":0,"pid":20},{"id":251,"city_name":"肇庆市","initial":"Z","is_del":0,"pid":20}]}';
        $result = json_decode($res, true);
        $redis->set($apikey, $result['datas']);

        return 11;
//die();
//        $list = Db::name('user')->where('pid', 7569185)->select();
//        $users = '';
//        foreach ($list as $key=>$val){
//            $users .= ($val['id'].',');
//        }
//        return $users;

//        return json_encode(Db::name('score_log')->where('type', 10)->whereDay('create_at', 'today')->sum('score');
        return $pushDynamic = Db::name('score_log')->where('type', 10)->whereDay('create_at', '-2 day')->sum('score');

        return Db::name('withdraw_log')->where('status', 0)->sum('practical_money');

        $addmoney = intval(number_format(8.32*100 - 8.22*100, '0', '.', ''));

        $need = env('APP.YG_ONCE_ADD') * 100;
//        return json_encode([$addmoney, $need]);
        if (intval($need) > intval($addmoney)){
            return '当前加价幅度不能低于'.env('APP.YG_ONCE_ADD');

        }

        return 11;



        return Db::name('score_log')->whereDay('create_at', '-1 day')->where('type', 10)->sum('score');
        die();
        return Db::name('score_log')->where('id', '>', 618769)->where('type', 11)->sum('score');
//        7493433
        return Db::name('score_log')->where('uid', 7493433)->where('type', 11)->where('create_at', '>', '2022-07-25 00:00:00')->where('create_at', '<', '2022-07-26 00:00:00')->sum('score');
        $day = 'today';
        return $total = Db::name('coupon_plan_log')->whereDay('create_time', $day)->where('uid', 'not in', [7493267,7493266])->sum('buy_num');
//        return Db::name('coupon_plan_log')->where('create_time', '>', '2022-07-24 20:16:42')->where('uid', 'not in', '7493266,7493267')->sum('buy_num');

//        Queue::instance()->log('执行成功新增计划')->do("couponAddNewPlan")->job(CouponPlanJob::class)->push([13, 272, 1]);
//
//        return 22;

//        return Db::name('score_log')->whereDay('create_at', 'today')->where('type', 'in', '11')->sum('score');


        $set_arr = [];
        $list = Db::name('coupon_plan_log')->where('create_time', '>', '2022-07-25 20:00:01')->where('plan_id', 272)->where('uid', 'not in', '7493266,7493267')->select();
        foreach ($list as $key=>$val){

        }



         return Db::name('withdraw_log')->whereDay('create_at', 'today')->sum('apply_money');

        return 33;
        return 33;

         Db::name('coupon_plan_log')->where('create_time', '>', '2022-07-24 20:16:42')->save(['is_get_dymic'=>2]);
         return 44;

        $get_time = time();
        $model = new CouponPlanModel();
       Db::startTrans();
       try {

           $model->addPlan(7528608, 1000, 271, true, 0, $get_time);



//           $m_uer = new UserModel();
//
//           $userinfo = Db::name('user')->where('id', 7493487)->find();
//           $money = 20;
//           // 直推收益
//           $piduserinfo = $m_uer->where('id', $userinfo['pid'])->field('score, id,pid,is_auth,level')->find();
//           $zt_score = number_format($money * env('coupon.COUPON_ZHITUI_SCALE', 0)/100, 4, '.', '');
//           if ($zt_score > 0 && $piduserinfo){
//               if ($piduserinfo['is_auth'] == 1){
//
//                   edit_user_score(9, $piduserinfo['id'],$zt_score);
//               }
//           }

           Db::commit();
       }catch (\Exception $e){

           Db::rollback();
           return $e->getMessage();
       }

        return 33;

//        Queue::instance()->log('竞拍过期执行成功705675')->job(JpOrderJob::class)->do('YgOrderExpired')->secs(5)->push([705675]);
//        return 33;
//        return Db::name('score_log')->where('uid', 7495208)->where('type', 'in', '9,11')->sum('score');

//        return AESjiami('abcd123456');
//
//        Queue::instance()->log('竞拍过期执行成功')->job(JpOrderJob::class)->do('YgOrderExpired')->secs(5)->push([200336]);
////
//        return 33;


//        return Db::name('score_log')->where('uid', )->su




        return createApiSign([
            'timestamp'=> '1658559823114',
'app_version'=> '2.0.0',
'app_sources'=> 'miniapp',
'sys_version'=> '10.0.1',
'udid'=> '16585598231114333537',
'sm_deviceid'=> '16585598231114333537',
'mobile'=> '18280066008',
'password'=> 'JUiJ5bDDSsWEaHKeAhCC7w==',
'login_type'=> 'pass',
'jg_regid'=> '3aasdfad'
        ]);

        return AESjiami('abcd1234');
        return 33;

        return Db::name('shop_goods')->where('price', '<', '999')->field('price,goods_id')->page(1, 10)->select();

//        edit_user_couponnum(5, 7506924, 5);
        return 33;

        $service = new UserServices();
        try {
            $service->withdraw(7494922,300, 1);
        }catch (Exception $e){
             return $e->getMessage();
        }
        return 'success';

        $list = Db::name('score_log')->where('uid', 7494922)->where('type', 3)->page(1,1)->select();
        return json_encode($list);


//        $in = Db::name('score_log')->where('type', 'in', '1,6,13')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score');
//        $out = Db::name('score_log')->where('type', 'in', '2,7,8,9,10,11,15')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score');

        $arr = [
            '消费抢购参加扣除'=>Db::name('score_log')->where('type', 'in', '1')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '消费抢购活动结束发放'=>Db::name('score_log')->where('type', 'in', '2')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '购买商品返积分'=>Db::name('score_log')->where('type', 'in', '5')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '兑换商品'=>Db::name('score_log')->where('type', 'in', '6')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '激励奖'=>Db::name('score_log')->where('type', 'in', '7')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '末尾奖'=>Db::name('score_log')->where('type', 'in', '8')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '直推认购收益'=>Db::name('score_log')->where('type', 'in', '9')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '平级收益'=>Db::name('score_log')->where('type', 'in', '10')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '动态收益'=>Db::name('score_log')->where('type', 'in', '11')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '积分兑换到余额'=>Db::name('score_log')->where('type', 'in', '12')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '分红任务包兑换'=>Db::name('score_log')->where('type', 'in', '13')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '货款补发'=>Db::name('score_log')->where('type', 'in', '14')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '购物收益'=>Db::name('score_log')->where('type', 'in', '15')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score'),
            '货款补缴'=>Db::name('score_log')->where('type', 'in', '16')->whereDay('create_at', 'today')->where('uid', 'not in', '7493266,7493267')->sum('score')


        ];

        return json_encode($arr);

        return Db::name('withdraw_log')->where('status', '0')->select();

        $count = Db::name('xz_log')->where('type', 12)->where('id', '>', 3305814)->where('uid2', '20220705082713911354155')->count('id');
        return $count;
        $list = Db::name('xz_log')->where('type', 12)->select()->toArray();
        $arr = [];
        foreach ($list as $key=>$val){
            $count = Db::name('xz_log')->where('uid2', $val['uid2'])->count('id');
            if ($count > 1){
                $arr[] = $val['uid2'];
            }
        }
        return json_encode($arr);

        $list = Db::name('yg_buy_record')->where('type', 1)->select()->toArray();
        return json_encode($list);

        return $redscore = explode('-', '-');
//        return $beginToday=mktime(0,0,0,intval(date('m')),intval(date('d')),intval(date('Y')));;
//        return $endToday=mktime(24,0,0,intval(date('m')),intval(date('d')),intval(date('Y')));;
        $arr = [];
        // 更新每天的couponarea信息
        $area_list = Db::name('coupon_area')->select();
        foreach ($area_list as $key=>$val){
            $dayval = json_decode($val['buy_time']);
            $day = $dayval->day;
            $arr[] = $day;

            $beginToday=mktime(0,0,0,intval(date('m')),intval(date('d')),intval(date('Y')));
            $endToday=mktime(24,0,0,intval(date('m')),intval(date('d')),intval(date('Y')));

            $is_today = false;
            if ($beginToday<=$day && $endToday>$day){
                $is_today = true;
            }
            Db::name('coupon_area')->where('id', $val['id'])->save(['is_today'=>($is_today?1:0)]);
        }
        return $arr;

        return 22;
        return $list = Db::name('shop_order')->where('user_id', 7605660)->where('status', 2)->select();

        JPushServicePushOneMsg(false, '1507bfd3f73dcc61ff8', '您的竞拍被别人拍下了，快去看看吧', ['type'=>2,'params'=>json_encode(['yg_id'=>'3333'])]);
        return 22;
return AESjiami('whl123456');
        return JPushServicePushOneMsg(false, '1507bfd3f73dcc61ff8', '测试', ['type'=>1,'params'=>json_encode(['url'=>html_entity_decode('https://www.baidu.com')])]);

        return 33;
        return sr_getcurtime(mktime(0,0,0,date('m'), date('d'), date('Y')));
//        return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', '-1 day')->sum('total_fee');
        return $list = Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'in', [])->select();
        $sum = 0;
        foreach ($list as $key=>$val){
            $sum +=$val['total_fee'];
        }
        return $sum;

        $total = 0.0000;
        $list = Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'yesterday')->select();
        foreach ($list as $key=>$val){
            $total += $val['total_fee'];
        }
        return $total;

        return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'yesterday')->sum('total_fee');
        $dayback = '- 10 day';

        $total = Db::name('user')->whereDay('reg_time', $dayback)->count('id');
        $total_shim = Db::name('user')->whereDay('reg_time', $dayback)->where('is_auth', 1)->count('id');
        $res = [
            'date'=>sr_getcurtime(time()-86400*10, 'Y年-m月-d日'),
            'xz_sum'=>Db::name('user')->sum('xz_num'),
            'xz_more_10'=>Db::name('user')->where('xz_num', '>', 11.5)->sum('xz_num'),
            'yesterday_income'=>Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', $dayback)->sum('total_fee'),
            'withdow_success'=>number_format(Db::name('withdraw_log')->whereDay('update_at', $dayback)->where('status', 1)->sum('practical_money'), '2', '.', ''),
            'yesterday_incomeuser'=>$total,
            'yester_incomshiming'=>$total_shim,
            'yester_couponnum'=>Db::name('coupon_plan_log')->whereDay('create_time', $dayback)->count('id'),
            'yeseter_xznum'=>Db::name('xz_log')->where('type', 6)->whereDay('create_at', $dayback)->sum('score'),
            'yester_shouxu'=>Db::name('xz_log')->where('type', 5)->whereDay('create_at', $dayback)->sum('shouxu_num')

        ];

        return $res;
die();

        return json_encode(['tokenId'=>'7493666', 'ip'=>'113.251.62.38', 'timestamp'=>1657861293000, 'deviceId'=>'DeyJvcmdhbml6YXRpb24iOiJqNUtZSUpWVThtVk9ZTEQ1Qm5vRmFjY2Vzc0tleTp3Zlc1dUM4WE9XcTJza2FEUW9YMyIsIm9zIjoiYW5kcm9pZCIsImFwcElkIjoiZGVmYXVsdCIsImVuY29kZSI6MSwiZGF0YSI6ImV5SmhNU0k2SW1WNFkyVndkR2x2YmlJc0ltRTJJam9pWVc1a2NtOXBaQ0lzSW1FM0lqb2lNeTR5TGpJaUxDSmhNVEFpT2lJeE1DSXNJbUV4TXlJNklrMUpJRGdpTENKaE9UWWlPaUpxTlV0WlNVcFdWVGh0Vms5WlRFUTFRbTV2Um1GalkyVnpjMHRsZVRwM1psYzFkVU00V0U5WGNUSnphMkZFVVc5WU15SXNJbUV4TVNJNkltUmxabUYxYkhRaUxDSmxJam9pYW1GMllTNXNZVzVuTGtWNFkyVndkR2x2YmpvZ1pYSnliM0lnY21WME9pQTJNVFEzTURCY2JseDBZWFFnWTI5dExtbHphSFZ0WldrdWJERXhNVEZzTVRFeE1URXhTV3d1YkRFeE1URnNNVEV4TVRFeFNXd3ViREV4TVRGc01URXhNVEV4U1d3b1ZXNXJibTkzYmlCVGIzVnlZMlU2TVRRMU1DbGNibHgwWVhRZ1kyOXRMbWx6YUhWdFpXa3ViREV4TVd3eE1URXhNV3hKYkM1c01URXhNV3d4TVRFeE1URkpiQzVzTVRFeGJERXhNVEZzU1d3dWJERXhNV3d4TVRFeE1XeEpiQ2hWYm10dWIzZHVJRk52ZFhKalpUb3hNRFlwWEc1Y2RHRjBJR052YlM1cGMyaDFiV1ZwTG5OdFlXNTBhV1p5WVhWa0xsTnRRVzUwYVVaeVlYVmtMbWRsZEVSbGRtbGpaVWxrS0ZWdWEyNXZkMjRnVTI5MWNtTmxPakUxS1Z4dVhIUmhkQ0JqYjIwdVpYaGhiWEJzWlM1a1lYRnpiMlowTG1obFlXeDBhSEJoYzNOd2IzSjBMbTEyY0M1MWFTNWhZM1JwZG1sMGVTNVRjR3hoYzJoQlkzUnBkbWwwZVM1cGJtbDBSR0YwWVNoVGNHeGhjMmhCWTNScGRtbDBlUzVyZERvNU5pbGNibHgwWVhRZ1kyOXRMbXhwWVc1NWFTNWpiMjF0YjI1elpHc3VZbUZ6WlM1Q1lYTmxRV04wYVhacGRIa3ViMjVEY21WaGRHVW9RbUZ6WlVGamRHbDJhWFI1TG10ME9qRXhPQ2xjYmx4MFlYUWdZVzVrY205cFpDNWhjSEF1UVdOMGFYWnBkSGt1Y0dWeVptOXliVU55WldGMFpTaEJZM1JwZG1sMGVTNXFZWFpoT2pjNE9UTXBYRzVjZEdGMElHRnVaSEp2YVdRdVlYQndMa0ZqZEdsMmFYUjVMbkJsY21admNtMURjbVZoZEdVb1FXTjBhWFpwZEhrdWFtRjJZVG8zT0Rnd0tWeHVYSFJoZENCaGJtUnliMmxrTG1Gd2NDNUpibk4wY25WdFpXNTBZWFJwYjI0dVkyRnNiRUZqZEdsMmFYUjVUMjVEY21WaGRHVW9TVzV6ZEhKMWJXVnVkR0YwYVc5dUxtcGhkbUU2TVRNd055bGNibHgwWVhRZ1lXNWtjbTlwWkM1aGNIQXVRV04wYVhacGRIbFVhSEpsWVdRdWNHVnlabTl5YlV4aGRXNWphRUZqZEdsMmFYUjVLRUZqZEdsMmFYUjVWR2h5WldGa0xtcGhkbUU2TXpJNE15bGNibHgwWVhRZ1lXNWtjbTlwWkM1aGNIQXVRV04wYVhacGRIbFVhSEpsWVdRdWFHRnVaR3hsVEdGMWJtTm9RV04wYVhacGRIa29RV04wYVhacGRIbFVhSEpsWVdRdWFtRjJZVG96TkRVM0tWeHVYSFJoZENCaGJtUnliMmxrTG1Gd2NDNXpaWEoyWlhKMGNtRnVjMkZqZEdsdmJpNU1ZWFZ1WTJoQlkzUnBkbWwwZVVsMFpXMHVaWGhsWTNWMFpTaE1ZWFZ1WTJoQlkzUnBkbWwwZVVsMFpXMHVhbUYyWVRvNE15bGNibHgwWVhRZ1lXNWtjbTlwWkM1aGNIQXVjMlZ5ZG1WeWRISmhibk5oWTNScGIyNHVWSEpoYm5OaFkzUnBiMjVGZUdWamRYUnZjaTVsZUdWamRYUmxRMkZzYkdKaFkydHpLRlJ5WVc1ellXTjBhVzl1UlhobFkzVjBiM0l1YW1GMllUb3hNelVwWEc1Y2RHRjBJR0Z1WkhKdmFXUXVZWEJ3TG5ObGNuWmxjblJ5WVc1ellXTjBhVzl1TGxSeVlXNXpZV04wYVc5dVJYaGxZM1YwYjNJdVpYaGxZM1YwWlNoVWNtRnVjMkZqZEdsdmJrVjRaV04xZEc5eUxtcGhkbUU2T1RVcFhHNWNkR0YwSUdGdVpISnZhV1F1WVhCd0xrRmpkR2wyYVhSNVZHaHlaV0ZrSkVndWFHRnVaR3hsVFdWemMyRm5aU2hCWTNScGRtbDBlVlJvY21WaFpDNXFZWFpoT2pJd05EUXBYRzVjZEdGMElHRnVaSEp2YVdRdWIzTXVTR0Z1Wkd4bGNpNWthWE53WVhSamFFMWxjM05oWjJVb1NHRnVaR3hsY2k1cVlYWmhPakV3TnlsY2JseDBZWFFnWVc1a2NtOXBaQzV2Y3k1TWIyOXdaWEl1Ykc5dmNDaE1iMjl3WlhJdWFtRjJZVG95TWpRcFhHNWNkR0YwSUdGdVpISnZhV1F1WVhCd0xrRmpkR2wyYVhSNVZHaHlaV0ZrTG0xaGFXNG9RV04wYVhacGRIbFVhSEpsWVdRdWFtRjJZVG8zTlRZeUtWeHVYSFJoZENCcVlYWmhMbXhoYm1jdWNtVm1iR1ZqZEM1TlpYUm9iMlF1YVc1MmIydGxLRTVoZEdsMlpTQk5aWFJvYjJRcFhHNWNkR0YwSUdOdmJTNWhibVJ5YjJsa0xtbHVkR1Z5Ym1Gc0xtOXpMbEoxYm5ScGJXVkpibWwwSkUxbGRHaHZaRUZ1WkVGeVozTkRZV3hzWlhJdWNuVnVLRkoxYm5ScGJXVkpibWwwTG1waGRtRTZOVE01S1Z4dVhIUmhkQ0JqYjIwdVlXNWtjbTlwWkM1cGJuUmxjbTVoYkM1dmN5NWFlV2R2ZEdWSmJtbDBMbTFoYVc0b1dubG5iM1JsU1c1cGRDNXFZWFpoT2prMU1DbGNiaUo5IiwidG4iOiIiLCJlcCI6IiJ9','os'=>'android', 'appVersion'=>'2.0.0']);
// 动态百分之三
//        Queue::instance()->log('动态收益执行成功')->do("couponPlanDynamic")->job(CouponPlanJob::class)->push(['7493267,7493426,7493427,7493428,7493429,7493433,7493446', 2000, 7493500]);
//        return 22;
//        Queue::instance()->log('竞拍过期执行成功')->job(JpOrderJob::class)->do('YgOrderExpired')->secs(5)->push([200203]);
die();
        return 22;
        return Db::name('score_log')->where('from_id', 240)->where('type', 2)->sum('score');
        die();
        $redis = new \think\cache\driver\Redis();

        $redis->delete('getCouponAreaList');
        return 22;
        $redis->set('getCouponAreaList', ['aa'=>'bb']);

        return 22;

//        return Db::name('withdraw_log')->where('status', 1)->sum('practical_money');
//        return Db::name('payment')->where('state', 6)->where('total_fee', '>', '3')->sum('total_fee');

//        $list = Db::name('coupon_plan_log')->whereDay('create_time', '-1 day')->group('uid')->select();
//        return $list;
//
//        $levelarr = array();
//        foreach ($list as $key=>$val){
//            $path = Db::name('user')->where('id', $val['uid'])->value('path');
//            $arr = explode(',', $path);
//            $level = '';
//            foreach ($arr as $key1=>$val1){
//                $level = Db::name('user')->where('id', $val['uid'])->value('level');
//                $level .= $level;
//            }
//
//            array_push($levelarr, $level);
//        }
//
//        return $levelarr;

//        return Db::name('user')->where('id', )
//
//        return Db::name('score_log')->where('type', 11)->whereDay('create_at', 'yesterday')->where('uid', 'not in', [7493267,7493266])->sum('score');
//        return Db::name('coupon_plan_log')->whereDay('create_time', 'yesterday')->where('uid', 'not in', [7493267,7493266])->sum('buy_num');
//
//        return Db::name('coupon_plan_log')->whereDay('create_time', 'today')->group('uid');
//
//        return AESjiami('Hmd1234567890');
//        die();
        return 22;
        $ser = new ThirdPayServices();
        return $ser->getYsfPayJJSubmit(3444, []);

//        edit_user_xz(14,7494382, 20, 111, 0);
//        edit_user_xz(14, $uid, $need_num, $insert_id, $shouxu_num);

        die();
        $model_user = new UserModel();
        $list = $model_user->whereFindInSet('path', 7493430)->field('id,is_auth,nickname, avatar, reg_time')->toArray();

        return 33;

        return 23;

        return password('admin');
        die();

//        aaa
//        return Db::name('thirdxz_hforder')->where('status', 1)->sum('price');
//        return Db::name('withdraw_log')->where('status', 0)->where('practical_money', '>', '10000')->field('uid,apply_money,create_at,zfb_number,zfb_name')->select();
        return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee');
//        return Db::name('xz_log')->where('type', 3)->whereDay('create_at', '-7 day')->sum('score');
//        return 22;

//
//        return 33;
//
//        return AESjiami('a123456789.');
//
//        return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee');
//        return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee');
//return creathfOrderSn();
//        $params = [
//            'mchId'=>env('XZTHIRD.PINWEI_MCHID'),
//            'datetime'=>date('Ymdhis', time())
//        ];
//
//        $params['sign'] = createApiSigncreatePwApiSign($params);
//
//        return $params;
//        return password_hash("rasmuslerdorf", PASSWORD_DEFAULT);

// 想知道以下字符从哪里来，可参见 password_hash() 的例子
//        $hash = '$2y$10$KJwzVxe/plQ/EfDU2BnJIl.tbmvpAkVD0fq3T3a5OAEwGQ0qSBAcgK';
//
//        if (password_verify('rasmuslerdorf', $hash)) {
//            return '密码正确';
//        } else {
//            return '密码错误';
//        }


//        return AESjiemi('5izRb20EuGOQmIasKQCfYQ==');
//      RSA  加密
//        return RSA_openssl('{"test":"asdfasdf","asdf":"555555"}', 'encode');
//        rsa  解密
//        return RSA_openssl('WJOUfBgNuFYHwgfJtwgqVt8tmlbqRzNDCXab9SrdH7xb46b4HFBDhL5AltFITbg19ZxeMZJXsoYyruRHvYP/Y3FBCjdM5N08gaM8Z0OlKW85gJfy3TlfKQmLicYmxuMVcpBLEzFpeM9CBgs5KWDnngb9zz8DlJyzV4tTR/vR73I=', 'decode');

//        GOBOkWqE87XgKLdl+3ePZMk7BUV1qEI0AqiLVuDwKj2GpBVMLR+mh0RrmD7a0ZFunF7ruZpvSU2b1mf3R/UNt+DcDU8wNQL1bCxz/acG5jdkuXi95eCIAyIe2Ym7YeMyFe4y8hvAlj4j/KFHGMWgWBgxdtOXH5o8e9oSlwX3u6g=
//        return RSA_openssl('GOBOkWqE87XgKLdl+3ePZMk7BUV1qEI0AqiLVuDwKj2GpBVMLR+mh0RrmD7a0ZFunF7ruZpvSU2b1mf3R/UNt+DcDU8wNQL1bCxz/acG5jdkuXi95eCIAyIe2Ym7YeMyFe4y8hvAlj4j/KFHGMWgWBgxdtOXH5o8e9oSlwX3u6g=', 'decode');
//        获取某个用户的token

//        die();
//        $start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d'),date('Y')));
//        $w = date('w',strtotime($start));
////        $last_week_mon = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-$w+1-7,date('Y')));
//        $old_start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-90,date('Y')));
//        $end_time = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1);
//
//        // 用户在上一周的抢购数据总和    用户零撸次数
//        $buy_num = Db::name('coupon_plan_log')->where('uid', 7494925)->where('create_time', '>', $old_start)->sum('buy_num');
//
//        return $buy_num;


//        return checkUserNeedsSecuritLogin(7494925);
//        $start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d'),date('Y')));
//        $w = date('w',strtotime($start));
////        $last_week_mon = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-$w+1-7,date('Y')));
//        $old_start = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')-7,date('Y')));
//        $end_time = date('Y-m-d H:i:s',mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1);
//
//        return $end_time;

//        edit_user_xz(8, 7501532, 16);
//        return 22;
//
////return $b_withdraw = array('bankStage'=>[],'businessCode'=>'WITHDRAW');
//        $ser = new ThirdPayServices();
//        return $ser->getYsfPayJJSubmit(3444, []);
//        return 22;


//        return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee');

//return ;
//        $time = time();
//        return $order_timestart = sr_getcurtime($time, 'YmdHis');;
//        $orderi_info = [
//            'businessType'=>"100007",
//            'goodsList'=>[
//                'amount'=>1,
//                'name'=>'商品名字',
//                'number'=>'1箱'
//            ],
//            'id'=>'id34535'
//        ];
//        return json_encode($orderi_info);



//        return $have_count = Db::name('machine_list')->where('uid', 7493460)->where('mid', 2)->where('state', 1)->count();
//        return AESjiami('453322');
//        return number_format(20*(100-5)/100, '2', '.', '');
//        die();
//
//        return password('Wubiao112759?@$+');


//        return Db::name('user')->where('id', 'in', '7590826,7535444,7601260,7601255,7601256,7601258,7601313,7601265,7601268,7601257,7601264,7601309,7601307,7601284,7601316,7601310,7601287,7601270,7601272,7601271,7601304,7601252,7601305,7601253,7601249,7601251,7601250,7601413,7601415,7601414,7601376,7601412,7601383,7601411,7601400,7601371,7601364,7601365,7601291,7601386,7601389,7601340,7601379,7601341,7601342,7601344,7601346,7601295,7601321,7601303,7601323,7601322,7545546,7545533,7545528,7545518,7545504,7545493,7545486,7545495,7545455,7545408,7545406,7545407,7545403,7545544,7545374,7545357,7545412,7545378,7545355,7545588,7545394,7545432,7545414,7545417,7545732,7545804,7545438,7545469,7545591,7545839,7545837,7545743,7545601,7545575,7545885,7545860,7545882,7545739,7545579,7545358,7545472,7545430,7545425,7545383,7545856,7545581,7545381,7545593,7545878,7545448,7545427,7545873,7545754,7545836,7545585,7545433,7545397,7545847,7545893,7545368,7545366,7545431,7545468,7545480,7545476,7545450,7545501,7545517,7545530,7545515,7545497,7545507,7545490,7545736,7545746,7545737,7545742,7545865,7523174,7523220,7523016,7523167,7523226,7523211,7523015,7523175,7523009,7523244,7523253,7523188,7523288,7523208,7523161,7523256,7523212,7523171,7523052,7523360,7523255,7523367,7523383,7523058,7523081,7523224,7523260,7523432,7523319,7523254,7523325,7523332,7523411,7523311,7523350,7523348,7523225,7523292,7523335,7523358,7523388,7523877,7523762,7523909,7523858,7523827,7523588,7523829,7523351,7523833,7526058,7526094,7526113,7526112,7526174,7526064,7526125,7523583,7526081,7526178,7526173,7526126,7526065,7525972,7526155,7526141,7526056,7526090,7526115,7526783,7526743,7526744,7526884,7526955,7526894,7526872,7526871,7527048,7526907,7526909,7526985,7526470,7526988,7526914,7527022,7526499,7526497,7527026,7526782,7543503,7543578,7543630,7543599,7543610,7543574,7543611,7543576,7543615,7544227,7543589,7544071,7544042,7545805,7543620,7544230,7545795,7545199,7545225,7545786,7545208,7545791,7545205,7545799,7543621,7545788,7545763,7545211,7543441,7543459,7543401,7545200,7543407,7543445,7544228,7543454,7543460,7543382,7543423,7543524,7543515,7543509,7543458,7543455,7543436,7543487,7543559,7543519,7543521,7543543,7543529,7543565,7543488,7543549,7543569,7543571,7543440,7543411,7543418,7544073,7544079,7544085,7543406,7544034,7543467,7543421,7543470,7545179,7545764,7545774,7545181,7545173,7545765,7545185,7545164,7545768,7545781,7543466,7545782,7545680,7545701,7545714,7545650,7545651,7545656,7545755,7545905,7545908,7545914,7545965,7546004,7545854,7545600,7545946,7545913,7545925,7546006,7545840,7545728,7545710,7545716,7545699,7545692,7545598,7545620,7545911,7545655,7545685,7545691,7545936,7545643,7545652,7545992,7545918,7545937,7545671,7545687,7545586,7545624,7545648,7545610,7545711,7545723,7545758,7545920,7545981,7545997,7563912,7563923,7563931,7564110,7563934,7563942,7563089,7563327,7563598,7563649,7563650,7563652,7563657,7563357,7563858,7563697,7563380,7563517,7563519,7563523,7563636,7563602,7563172,7563191,7563225,7563734,7563741,7563790,7564133,7563303,7563298,7563229,7563332,7563214,7563360,7563419,7563423,7563362,7563359,7563361,7563531,7563461,7563411,7563408,7563518,7563352,7563467,7563465,7563100,7564367,7564512,7564410,7563414,7564510,7564508,7563683,7563631,7564288,7564294,7564333,7564320,7564326,7564329,7564290,7564291,7564327,7564289,7564308,7564407,7564292,7564298,7564304,7564301,7564578,7564592,7564577,7564240,7564207,7564137,7564122,7564012,7563970,7563211,7563364,7564259,7563594,7564420,7578664,7558661,7558652,7558650,7557288,7557305,7557264,7557279,7557298,7557273,7557419,7558719,7558218,7557342,7557528,7557326,7557497,7557280,7557238,7557176,7557728,7557735,7557484,7557409,7558566,7558410,7558461,7558409,7558408,7558436,7558407,7558417,7558445,7559289,7559282,7559284,7559274,7559310,7559015,7557505,7557507,7557516,7557348,7557322,7559301,7559212,7557140,7558536,7559285,7557483,7557903,7557738,7556724,7556766,7556759,7556773,7556641,7556753,7556910,7556846,7556847,7556744,7556805,7556902,7556906,7550651,7550723,7550774,7551313,7551314,7551310,7551323,7551311,7551553,7551552,7551711,7551698,7551674,7551693,7551678,7551673,7551391,7551382,7551388,7552759,7551873,7551881,7551876,7551912,7551874,7551870,7551609,7551869,7550996,7551709,7550815,7550732,7551608,7551554,7550637,7551875,7550742,7550818,7550685,7550656,7550649,7550662,7550724,7550660,7550658,7551216,7551213,7551224,7551219,7551226,7551231,7551228,7550821,7550746,7550636,7550765,7551251,7551341,7551517,7550908,7551308,7551309,7551317,7551318,7551315,7551312,7551322,7551384,7551381,7551258,7551257,7551400,7551559,7551557,7551671,7551613,7551616,7551615,7551611,7550834,7550835,7550702,7551669,7550826,7550946,7550820,7551182,7551026,7551028,7551186,7551174,7551103,7551142,7551138,7551179,7551143,7551227,7551160,7551241,7551289,7551184,7551270,7551242,7551141,7551250,7551247,7551253,7551202,7548681,7548710,7548682,7548680,7548707,7548712,7548715,7548713,7548714,7548709,7548563,7548776,7548716,7548937,7549047,7549054,7548786,7548829,7548797,7548809,7548811,7548820,7548810,7548881,7548856,7548866,7548869,7548911,7548868,7548888,7548902,7549112,7549086,7549123,7549125,7549121,7549139,7549149,7544546,7551153,7551166,7551180,7551175,7551189,7551173,7551163,7551167,7551197,7548752,7548936,7548940,7548973,7548935,7548949,7551273,7548670,7551279,7551287,7551288,7551285,7551280,7551292,7551291,7551293,7551134,7551249,7551327,7548657,7551765,7551296,7552079,7551769,7552470,7551484,7550461,7550456,7550470,7550466,7550455,7550465,7550464,7550468,7550463,7550457,7550406,7536725,7557092,7548691,7548733,7548749,7548745,7548758,7548816,7548864,7548794,7548894,7549022,7548744,7548915,7548770,7548805,7548899,7548900,7548959,7548934,7548608,7548606,7548649,7548646,7548653,7548998,7548654,7548663,7548665,7548669,7548674,7548835,7548778,7548801,7548804,7548800,7548907,7548913,7548919,7548939,7548921,7548941,7548629,7548626,7548635,7548690,7548831,7548838,7548839,7548874,7548696,7548697,7548742,7548748,7548686,7548850,7548637,7548640,7548634,7548661,7548638,7548641,7548662,7548677,7548688,7527341,7527357,7527339,7527358,7527359,7529164,7529159,7529171,7529152,7529268,7529237,7529231,7529146,7529288,7529154,7529170,7529227,7529160,7529155,7529157,7529252,7529196,7529181,7529150,7529168,7529138,7529232,7530054,7530241,7530224,7529334,7527342,7529224,7530017,7529312,7527343,7527352,7527345,7527344,7529892,7529895,7527356,7527355,7529901,7530398,7530221,7530421,7530444,7529191,7530390,7530307,7530191,7529205,7530452,7534354,7534400,7534402,7534397,7534398,7534351,7534395,7529948,7529212,7534357,7534390,7534383,7534374,7534385,7529233,7529215,7529203,7529141,7529147,7529145,7529173,7529149,7529188,7529261,7529256,7529161,7529189,7529166,7526805,7529240,7529220,7529194,7529222,7529246,7529259,7529271,7529250,7529284,7529323,7529254,7529255,7526851,7529257,7529287,7529310,7529294,7529211,7529186,7529199,7529230,7529286,7529285,7529304,7529317,7529201,7529223,7529216,7529333,7529249,7529305,7529309,7529325,7535500,7535953,7535495,7529289,7535457,7535456,7529192,7529332,7529244,7534421,7534411,7535434,7535437,7535438,7534377,7534414,7535448,7535925,7535930,7534423,7535447,7535950,7535488,7534434,7535463,7541266,7524978,7534430,7524569,7541163,7524471,7523916,7535928,7541165,7523886,7541158,7535945,7543679,7543695,7543657,7544596,7544312,7544331,7543675,7543694,7543705,7544029,7543651,7543638,7544601,7543660,7543658,7543652,7543649,7543678,7543684,7543738,7543731,7543977,7543765,7529320,7544530,7543990,7543676,7544584,7543775,7544549,7544025,7544015,7544020,7543934,7543681,7544011,7543409,7544493,7544523,7544309,7544413,7544532,7544594,7544306,7544410,7544088,7543868,7544235,7544542,7543811,7544301,7545213,7543762,7545261,7545250,7545267,7544010,7543659,7545536,7545670,7545228,7545696,7545644,7545628,7545638,7545829,7545808,7545810,7545852,7545241,7545812,7544244,7545834,7545831,7545811,7545806,7545232,7544593,7544608,7544574,7544558,7544520,7544535,7544544,7544465,7544492,7544515,7544475,7544395,7544402,7544427,7544424,7544390,7544391,7544345,7544362,7544279,7543995,7544234,7545826,7544560,7545809,7544534,7545821,7545824,7545816,7545815,7546023,7545820,7543667,7543963,7543892,7543647,7543860,7543751,7543770,7544923,7544898,7544899,7544900,7544918,7544924,7544920,7544586,7544925,7544571,7544553,7544522,7544550,7544979,7544988,7544869,7544893,7544929,7544940,7544949,7544956,7544970,7544822,7544831,7544839,7544841,7544843,7544846,7544722,7544716,7544708,7545109,7545136,7544844,7545024,7545092,7545798,7544937,7544993,7545832,7545612,7545606,7545607,7545608,7545006,7545007,7545540,7545005,7544857,7544871,7544862,7544856,7544863,7544861,7545775,7545148,7545850,7545862,7545771,7545077,7545060,7545021,7545779,7544622,7545439,7541172,7534415,7534424,7541151,7541170,7524011,7541153,7541168,7541182,7541214,7541208,7541190,7541207,7545784,7545823,7544308,7545276,7541202,7541179,7541200,7541178,7541184,7541177,7541187,7541173,7541203,7541225,7541253,7541249,7541197,7541229,7541243,7541261,7541238,7541218,7541237,7541216,7541263,7541256,7548636,7548701,7548685,7548584,7544519,7548981,7548957,7548987,7544502,7540988,7541054,7540983,7540980,7541020,7541025,7540977,7541028,7540972,7541031,7540995,7541035,7541011,7540948,7541000,7540952,7541018,7541007,7540960,7540957,7540969,7564135,7564283,7564302,7564319,7564293,7571444,7571573,7523959,7571545,7523960,7523971,7523973,7523988,7523993,7523997,7524002,7524017,7524139,7524149,7524382,7524385,7524498,7524499,7524501,7524510,7524610,7524697,7524763,7524803,7524973,7524985,7524549,7524993,7524998,7525015,7525059,7525061,7525072,7525081,7525160,7525162,7525164,7525193,7525220,7525221,7525225,7525243,7525268,7525275,7525273,7525288,7525329,7525373,7525420,7525482,7529239,7529177,7529298,7529311,7529225,7529264,7529313,7529324,7529272,7529238,7529162,7529174,7529965,7529957,7529882,7529916,7530000,7530112,7530093,7529985,7529877,7530021,7530102,7530108,7530101,7530095,7530106,7530099,7529913,7530109,7529908,7529949,7530168,7530043,7529301,7529955,7530222,7530040,7529163,7530305,7530364,7530267,7529984,7530288,7530263,7530297,7530405,7530423,7530450,7543281,7530007,7544656,7543772,7545280,7548692,7548699,7548727,7548773,7548817,7548854,7549177,7601245,7601405,7601339,7601343,7598066,7598077,7598482,7598116,7598100,7598494,7598884,7599190,7599207,7599175,7599224,7599208,7599222,7599241,7599245,7599255,7545551,7563543,7563654,7563693,7551193,7548762,7529193,7592008,7514087,7525687,7524049,7523666,7524093,7524076,7524126,7524080,7524061,7524118,7524109,7524116,7524091,7524064,7523659,7523657,7523664,7523645,7520429,7523151,7523662,7541343,7524134,7524132,7543976,7524158,7548962,7524155,7528958,7524150,7523961')->where('xz_num', '>', 10)->sum('xz_num');
//
////        return Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'today')->sum('total_fee');
//
        $total = Db::name('user')->whereDay('reg_time', 'yesterday')->count('id');
        $total_shim = Db::name('user')->whereDay('reg_time', 'yesterday')->where('is_auth', 1)->count('id');
        $res = [
            '日期'=>sr_getcurtime(time()-86400, 'Y年-m月-d日'),
            '星钻总数'=>Db::name('user')->sum('xz_num'),
            '星钻大于10总数'=>Db::name('user')->where('xz_num', '>', 11.5)->sum('xz_num'),
            '昨日充值'=>Db::name('payment')->where('order_type', 4)->where('state', 6)->whereDay('creat_at', 'yesterday')->sum('total_fee'),
            '昨日提现总金额'=>number_format(Db::name('withdraw_log')->whereDay('update_at', 'yesterday')->where('status', 1)->sum('practical_money'), '2', '.', ''),
            '昨日用户新增总人数'=>$total,
            '昨日用户新增实名人数'=>$total_shim,
            '昨日抢购人数'=>Db::name('coupon_plan_log')->whereDay('create_time', 'yesterday')->count('id'),
            '昨日星钻交易量'=>Db::name('xz_log')->where('type', 6)->whereDay('create_at', 'yesterday')->sum('score'),
            '昨日星钻手续费'=>Db::name('xz_log')->where('type', 5)->whereDay('create_at', 'yesterday')->sum('shouxu_num')

        ];

        return json_encode($res);


//        Queue::instance()->log('执行成功新增计划')->do("couponAddNewPlan")->job(CouponPlanJob::class)->secs(3)->push([13, 152, 1]);
//        return 33;
//        Queue::instance()->log('竞拍过期执行成功')->do('YgOrderExpired')->job(JpOrderJob::class)->push([1]);
//        return 22;
//die();
//        return sysconfig('xzconfig', 'xz_cur_money');;
//        die();
        // 星钻扣退
//        edit_user_xz(13,7497003, 1 );
        // 星钻退回
//        edit_user_xz(8,7496595,1 );
        return 11;
//        return AESjiami('453211');
//        if (vertifySecurityPass('035155')){
//            return '通过';
//        }
//        return '不通过';
//        adsfasdf

//        $list = Db::name('user')->where('id', 'in', '7555174,7538654,7507902,7532263,7520159,7515649,7528156,7600010,7600011,7595952,7502027,7520988,7529577,7570021,7502027,7515649,7553812')->field('mobile,id')->select();
//        $str = '';
//
//        foreach ($list as $key=>$val){
//            $str .= ("'".$val['mobile']."'");
//        }
//
//        return $str;

//            return Db::name('payment')->where('state', 6)->where('out_trade_no', 'like', "%CL%")->sum('total_fee');
//        return Db::name('payment')->where('state', 6)->where('out_trade_no', 'like', "%FYYL%")->sum('total_fee');

//        $sum_before = Db::name('coupon_plan')->where('area_id', 20)->where('state', 1)->sum('target_num');
//        $bobi = $sum_before * 0.7;
//
//        $tuandui = $sum_before * 0.03;
//
//        $score = Db::name('user')->where('mobile', 18981488889)->value('score');
//
//        if (($score + $bobi+$tuandui) > 500000){
//            return '负波比'.'---'.($score + $bobi+$tuandui);
//        }
//
//        return '正波比'.'---'.($score + $bobi+$tuandui);



//        $time_arr = [];
//        for ($i = 0;$i < 5;$i ++){
//
//            $datastr = date("Y-m-d",strtotime("-".$i." day"));
//            $str=$datastr." 0:0:0";
//            $data["star"]=$str;
//            $str=$datastr." 24:00:00";
//            $data["end"]=$str;
////            return $data;
//
//            array_push($time_arr, $data);
////            $time_arr[] = $i;
////            array_push($time_arr, $i);
//        }
//
//
//        return $time_arr;
//
//        die();
//        $income = Db::name('score_log')->where('uid',7494922)->where('state', 1)->sum('score');
//        $out = Db::name('score_log')->where('uid',7494922)->where('state', 2)->sum('score');
//        return [
//            '收入'=>$income,
//            '支出'=>$out,
//            '相差'=>$income-$out
//        ];
//        return ;
//        return AESjiami('mm123456');
//        return Db::name('shop_order')->where('status', 'in', '2,3')->sum('rebate_lock_score');
//        return Db::name('withdraw_log')->where('status', 1)->sum('practical_money');
//        return Db::name('payment')->where('order_type', 'in',"4")->where('state', 6)->sum('total_fee');
//        return getWebUrl();
//        return md5(AESjiami('Hmd1234567890'));
//        return Db::name('score_log')->where('uid', 7525254)->where('state', 2)->sum('score');
//        die();
//        Db::name('ad_error_records')->whereTime('create_time', '<', sr_getcurtime(time()))->save(['status'=>2]);
//        return 22;
//        $count199 = Db::name('renwu_machine_list')->where('rid', 9)->count();
//        $count399 = Db::name('renwu_machine_list')->where('rid', 10)->count();
//
//        return [
//            '199个数'=>$count199,
//            '199'=>$count199 * 199,
//            '399个数'=>$count399,
//            '399'=>$count399 * 399,
//            '共计'=>$count399 * 399+$count199 * 199,
//            '分发'=>Db::name('sys_func_log')->where('type', 1)->sum('money')
//        ];
//
//        die();
//
//        $arr = array(
//            130, 131, 132, 133, 134, 135, 136, 137, 138, 139,
//            144, 147,
//            150, 151, 152, 153, 155, 156, 157, 158, 159,
//            176, 177, 178,
//            180, 181, 182, 183, 184, 185, 186, 187, 188, 189,
//        );
//        $phone = $arr[array_rand($arr)] . '' . mt_rand(1000, 9999) . '' . mt_rand(1000, 9999);

//        die();


//        die();
//        $last_info = Db::name('coupon_plan_log')->where('plan_id', 158)->where('uid', 7548432)->max('id');
//        return $last_info;
//        return AESjiami('abcd123456');
// 今日总实名人数
//        return Db::name('user')->whereDay('reg_time', 'today')->where('is_auth', 1)->count();
//        return Db::name('ad_log')->where('uid', 75133205)->where('status', 2)->whereDay('create_time', 'today')->max('id');
//        return AESjiami('abcd123456');
//        die();
//

//        $redis = new \think\cache\driver\Redis();
//        $redis->clear();
//        return 22;

        // 昨日星钻交易数量
//        return Db::name('xz_log')->where('type', 5)->whereDay('create_at', 'today')->sum('score');

        // 所有积分星钻
        return json_encode(['星钻'=>Db::name('user')->where('xz_num', '>', 0.2)->where('xz_num', '<', 200)->sum('xz_num'), 'score'=>['用户持有'=>Db::name('user')->where('id', 'not in', 7493267)->sum('score'), '池子'=>Db::name('coupon_plan')->where('state', 1)->sum('target_num')] ]);

//        return sr_getcurtime(strtotime('+3 day', strtotime("2022-04-18 12:42:20")));
//        return sr_getcurtime(strtotime('+3 day'));
//
        Db::startTrans();
        try {
            Db::name('user')->where('id', 'in', '7598474,7598479,7598492,7598495,7598508,7598522,7598540,7598555,7598562,7598574,7598590,7598594,7598598,7598605,7598614,7598615,7598616,7598617,7598618,7598619,7598620,7598621,7598622,7598623,7598624,7598625,7598626,7598627,7598628,7598629,7598630,7598632,7598634,7598635,7598637,7598639,7598641,7598642,7598648,7598649,7598650,7598651,7598655,7598656,7598659,7598660,7598661,7598662,7598663,7598664,7598668,7598669,7598670,7598673,7598674,7598675,7598678,7598679,7598684,7598687,7598689,7598690,7598696,7598697,7598698,7598699,7598700,7598701,7598702,7598704,7598709,7598711,7598712,7598713,7598714,7598715,7598717,7598718,7598720,7598723,7598725,7598726,7598728,7598729,7598730,7598731,7598740,7598741,7598748,7598750,7598755,7598756,7598759,7598760,7598761,7598762,7598763,7598764,7598765,7598766,7598767,7598768,7598770,7598771,7598773,7598776,7598777,7598779,7598781,7598782,7598783,7598785,7598787,7598789,7598793,7598794,7598795,7598797,7598801,7598805,7598806,7598808,7598811,7598813,7598814,7598815,7598819,7598821,7598823,7598827,7598828,7598831,7598832,7598833,7598834,7598838,7598843,7598847,7598850,7598855,7598856,7598864,7598869,7598871,7598873,7598877,7598881,7598882,7598885,7598888,7598893,7598899,7598905,7598906,7598910,7598916,7598917,7598918,7598920,7598921,7598923,7598931,7598932,7598933,7598934,7598938,7598939,7598941,7598942,7598945,7598950,7598952,7598957,7598961,7598962,7598969,7598971,7598972,7598977,7598980,7598981,7598983,7598986,7598988,7598989,7598990,7598992,7598993,7598995,7598999,7599000,7599004,7599005,7599013,7599015,7599018,7599020,7599027,7599030,7599042,7599050,7599059,7599070,7599072,7599078,7599080,7599086,7599087,7599094,7599095,7599099,7599105,7599106,7599113,7599155')->inc('total_active', 2000)->update();
            Db::commit();
        }catch (\Exception $e){

            Db::rollback();
            return 'error';
        }

        return 'success';
//        return AESjiami('abcd123456');
        //         当前这一期购买记录 总和
        return Db::name('coupon_plan_log')->where('plan_id', 143)->sum('buy_num');


        // 查看昨天这个人的总收益
        return Db::name('score_log')->where('uid', 7493427)->where('type', 'in', [9,10,11])->whereDay('create_at', 'yesterday')->sum('score');

        // 减少用户积分
//        edit_user_score(16, 7493685, 22);
//        return 33;
//
//        $list = Db::name('machine_list')
//            ->alias('l')
//            ->leftJoin('machine m','m.id = l.mid')
//            ->field('l.*,m.name,m.add_active')
//            ->where('get_type', 'in', [2,3])
//            ->where('state', 2)
//            ->select()
//            ->toArray();
//        foreach ($list as $key=>$val){
//
//            if ($key > 1391){
//                edit_user_active(5,$val['uid'], $val['add_active']);
//            }
//        }
//        return 22;
//        $m_machinelist = new MachineListModel();
//        return $m_machinelist->whereTime('expire_time', '<', date("Y-m-d",strtotime("+90 day")))->where('state', 1)->select()->toArray();
//        return AESjiami('abcd123456');
//return $error_count = env('API.ORDER_ERROR_BOTH_COUNT', 20);
//        $sql = "update zy_user set zy_user.`level` = `super_lv` where `super_lv` > 0";


//        edit_user_score(16,7507305,14);


//        $modeluser = new UserModel();
//        $list = Db::name('active_log')->where('type', 3)->select();
//        foreach ($list as $key=>$val){
//            $modeluser->where('id', $val['uid'])->dec('total_active', $val['score']*2)->update();
//        }
//
//        return 33;



//        // 获取团队上面所有uid
        $str = '';
        $list = Db::name('user')->where('pid', 7496093)->field('id,pid')->select()->toArray();

        foreach ($list as $key=>$val){
            $str = $str . $val['id'].',';
        }
        return $str;



        $model = new UserModel();
        return $model->getFansData(7496093);

//        7495457
        $list = Db::name('user')->whereFindInSet('path', 7495457)->field('id')->select()->toArray();
//        $active_arr = [1=>1,2=>1,3=>10,4=>50,5=>100];
        $active = 1;
        $less = 0;
        foreach ($list as $key=>$val){
            $mlist = Db::name('machine_list')->where('uid', $val['id'])->field('mid,state')->select();
            foreach ($mlist as $k1=>$v1){
                $machine = Db::name('machine')->where('id', $v1['mid'])->find();
                if ($v1['state'] == 1){
                    $active = $active + $machine['add_active'];
                }else{
                    $less = $less + $machine['add_active'];
                }

            }
        }
        return ['active'=>$active, 'less'=>$less];

        // 获取团队下面所有uid
//        $str = '';
//        $list = Db::name('user')->where('pid', 7496093)->field('id,pid')->select()->toArray();
//
//        foreach ($list as $key=>$val){
//            $str = $str . $val['id'].',';
//        }
//
//        return $str;

        Db::startTrans();
        try {
            $list = Db::name('user')->where('pid', 'in', "7496093,7499553,7493635")->where('status', 0)->field('id,status,performance_me,money_income')->select()->toArray();
            foreach ($list as $key=>$val){
                Db::name('user')->where('id', $val['id'])->save(['status'=>1]);
//                if ($val['performance_me'] > 0 || $val['money_income'] > 0){
//                    Db::name('user')->where('id', $val['id'])->save(['status'=>1]);
//                }else{
//                    Db::name('user')->where('id', $val['id'])->save(['status'=>0]);
//                }

            }

            Db::commit();
        }catch (\Exception $e){
            Db::rollback();
              return $e->getMessage();

        }
        return 22;
        $m_user = new UserModel();
        return $m_user->getFansData('7496093');

        return Db::name('payment')->where('state', 6)->where('pay_at', '>', '2022-05-16 00:00:00')->where('order_type', 4)->sum('total_fee');

        // 今日团队新增
        return Db::name('user')->where('reg_time', '>', '2022-05-16 00:00:00')->where('is_auth', 1)->count();

        if (Db::name('xz_log')->where([['uid', '=', 7493426],['type','=', 3],['create_at','>', sr_getcurtime(time()-86400*3)]])->find()){
            return 11;
        }
        return 22;

        die();
        incTodayTeamStatic(7500968, 2, '7493267,7493487,7499425');
        return 11;
        // 全网星钻手续费比例星钻分红
//        return Db::name('userteam_log')->where('day', sr_getcurtime(strtotime("-1 day"), 'Y-m-d'))->where('type', 2)->field('level,day,num')->select();
//        return Db::name('xz_log')->where('uid', 7493727)->where('state', 1)->sum('score');
//    die();



//        return Db::name('payment')->where('state', 6)->where('creat_at', '>', '2022-05-11 00:00:00')->where('order_type', 4)->sum('total_fee');


//
//        return urlencode(getWebUrl().'/api/thirdPayClSuccess');
//        return AESjiemi('KFM7rNmEprpl7awDjqjJNrZ0P82HeE61L1SDN9tT5EW3NLgXk6ku3Oh8fiBPiWKgy41w\/XH3ss2jBIThLmprFA==');
//        return bcmul(10.311933, 100, 0);
//
//
//
//        return sr_getcurtime(time(), 'Ymd');

//        sr_log('aa');
//        return 11;
//        Queue::instance()->log('动态收益执行成功')->do("couponPlanDynamic")->job(CouponPlanJob::class)->push(['7493267,7493426,7493427,7493428,7493429,7493433,7493452,7493974,7495238', 1000, '7503557']);
//        return 11;
//        $path = Db::name('user')->where('id', 7498935)->value('path');
//
//        $arr = explode(',', $path);
//        return Db::name('user')->where('id','in', $arr)->field('level,id')->select();
//
//        $list = Db::name('score_log')->where('create_at', '>', '2022-05-09 02:56:43')->where('type', '1')->field('uid, score')->select()->toArray();
//
//        $arr = [];
//        foreach ($list as $key=>$value){
//            $user = Db::name('user')->where('id', $value['uid'])->field('id,level,path')->find();
//            array_push($arr, ['id'=>$value['uid'], 'level'=>$user['level'], 'score'=>$value['score'], '']);
//        }
//        return $arr;
//
//       return Db::table('zy_devices_record')
////            ->field('username,max(score)')
//            ->group('udid')
//            ->having('count(udid)>1')
//            ->select();
//
//        return Db::name('devices_record')->group('udid')->having("count(udid)>1")->select();
//        return Db::execute('select *  from zy_devices_record  GROUP BY udid HAVING count(udid) > 1');
//
//return        Db::query("select * from zy_user where status=0", ['id' => 1]);
//
//        $list = Db::query("");
//        return $list;
//
//        return Db::query("select *  from zy_devices_record  where 1=1 GROUP BY udid HAVING count(udid) > 1");
//        edit_user_score(9 , 7493430, 0.65);
//        edit_user_score(11 , 7493430, 0.65);
//        return 11;




        // 总共平台波比
//        $muser = new UserModel();
//
//        $userinfo = $muser->where('id', 7493434)->field('score, id,pid,is_auth,level')->find();
//        $piduserinfo = $muser->where('id', $userinfo['pid'])->field('score, id,pid,is_auth,level')->find();
//        $user_de = 605;
//        $pj_score = 0;
//        // 平级收益
//        if ($piduserinfo && $userinfo['level'] > 0){
//            if ($userinfo['level'] == $piduserinfo['level']){
//                $money = $user_de - 560;
//                $pj_score = number_format($money * env('coupon.COUPON_PINGJI_SCALE', 0)/100, 4, '.', '');
//            }
//        }
//
//        return $pj_score;
//
//
//
//        return [
//            'dongtai'=> Db::name('score_log')->where([['type', '=', 11],['create_at', '>','2022-05-07 00:01:18']])->sum('score'),
//            'pingji'=> Db::name('score_log')->where([['type', '=', 10],['create_at', '>','2022-05-07 00:01:18']])->sum('score'),
//            'zhitui'=> Db::name('score_log')->where([['type', '=', 9],['create_at', '>','2022-05-07 00:01:18']])->sum('score'),
//            'jingtai'=> Db::name('score_log')->where([['type', '=', 2],['create_at', '>','2022-05-07 00:01:18']])->sum('score')
//        ];

//
//        $list = Db::name('score_log')->where([['type', '=', 2],['create_at', '>','2022-05-07 00:01:18']])->select()->toArray();
//        $arr = [];
//        foreach ($list as $key=>$value){
//            $user = Db::name('user')->where('id', $value['uid'])->field('id,level,pid')->find();
//            if ($user['level'] > 0){
//                $piduser = Db::name('user')->where('id', $user['pid'])->field('id,level,pid')->find();
//                if ($piduser['level'] == $user['level']){
//                    array_push($arr, $value);
//                }
//
//            }
//        }
//
//        return $arr;


//        return AESjiami('hxf250725');





//        今日总充值
        return Db::name('payment')->where('state', 6)->where('pay_at', '>', '2022-04-16 00:00:00')->where('order_type', 4)->sum('total_fee');
//        return Db::name('payment')->where('state', 6)->where('order_type', 4)->sum('total_fee');
//        return Db::name('payment')->where('state', 6)->where('order_type', 2)->sum('total_fee');
//        return Db::name('withdraw_log')->where('status', 1)->sum('practical_money');
//
//        die();
//        die();
//       =======================================  查看直推看广告  ============================================
//        $list = Db::name('user')->where('pid', 7493477)->where('is_auth', 1)->field('id, mobile')->select();
//        $uids = [];
//        foreach ($list as $key=>$val){
//            array_push($uids, $val['id']);
//
//        }
//        return Db::name('ad_log')->where('type', 2)->whereDay('create_time', 'yesterday')->where('uid', 'in', $uids)->field('create_time')->select();
//        return $uids;
//        ==============================================================================================================
//        return Db::name('sys_func_log')->where('type', 1)->sum('money');
//        return Db::name('user')->where('reg_time', '>', '2022-04-25 00:00:00')->where('reg_time', '<', '2022-04-26 00:00:00')->where('is_auth', 1)->count('id');
//        die();

//        die();
//        return Db::name('payment')->where('state', 6)->where('order_type', 2)->where('pay_at', '<', '2022-04-22 11:45:13')->count('id');
//        die();
//        return Db::name('devices_record')->field('udid, uid')->group('udid')->select();

        // ================  计算任务包很天增长   ================
        $arr = [];
        //  矿机增长
        for ($i=0;$i<9;$i++){
            $time = sr_getcurtime(time()-86400*$i, 'Y-m-d');
            $count = Db::name('renwu_machine_list')->whereDay('create_time',$time)->where('rid', 9)->count();
            $count1 = Db::name('renwu_machine_list')->whereDay('create_time',$time)->where('rid', 10)->count();
            $arr[$time] = ['199'=>$count, '399'=>$count1, 'all'=>$count + $count1];
        }
        return json_encode($arr);
// ================  计算任务包很天增长  ================

        return Db::name('coupon_plan_log')->where('plan_id', 112)->sum('buy_num');
die();
        //        ==========================================================================================
//        ===============计算每一期消费抢购目标金额跟实际买入
        $res = [];
        $list = Db::name('coupon_plan')->where('state', 'in', [1,2])->select()->toArray();
        foreach ($list as $key=>$val){
            $res[$val['id']] = Db::name('coupon_plan_log')->where('plan_id', $val['id'])->sum('buy_num');
        }
        return $res;
//        ==========================================================================================

//        return $request->ip();
//        return AESjiemi('537PacNG7epB4QcZklKbHw==');

//        return intval(2.34);
        // 锁定积分
//        Db::name('shop_order')->where('status','in', [1, 2])->sum('rebate_lock_score');

        // 总积分
        Db::name('shop_order')->where('status','in', [1, 2])->sum('rebate_score');

        //用户总消费
        Db::name('payment')->where('state','in', 6)->where('order_type', 4)->sum('total_fee');

        // 199 分红任务包

        // 399 分红任务包

        // 总提现金额
        return Db::name('withdraw_log')->where('status', 1)->sum('practical_money');


die();
        return Db::name('payment')->where('state', 6)->where('order_type', 4)->sum('total_fee');
//         Db::name('shop_order')->where('status', 'in', [1,2])->update(['ship_code'=>'', 'ship_name'=>'', 'ship_number'=>'', 'status'=>1]);
        $list = Db::name('shop_order')->select()->toArray();
        foreach ($list as $key=>$val){
            $uptime = $val['updated_time'];
            $cutime = $val['created_time'];
            Db::name('shop_order')->where('order_id', $val['order_id'])->update(['created_time'=>$uptime, 'updated_time'=>$cutime]);
        }
        return 11;


//        $user_model = new UserModel();
//        return $list  = $user_model->where('is_auth', 1)->field('id,is_auth')->select();
////        foreach ()

        return 11;
        Db::name('getali_token')->insertGetId([
            'uid'=>33,
            'content'=>json_encode(['aa'=>'bb']),
            'create_time'=>sr_getcurtime(time()),
            'ip'=>$request->ip()
        ]);
        return 22;
        return $count = Db::name('getali_token')->whereDay('create_time', 'today')->where('uid', 33)->count();
        die();
        $pay_info= Db::name('payment')->where('out_trade_no', 'DLB1649942227721944271609429OP')->find();
        sr_testDb(json_encode($pay_info), 1);
        return 22;
        $params = [
            'appid'=>'92b8bd950a272d07038c72fdc4ca80f1',
            'method'=>'payment.aljsapp',
            'merchant'=>'220971127793732674',
            'body'=>'购买商品',
            'external_order_no'=>'24235256',  // 我们自己的订单号
            'total_amount'=>'1.5',
            'notify_url'=>'http://api.meikangjw.com/api/aliResult'
        ];
        $sign = thirdPayGetSign($params, '9e4089dd079d8f6e3bb9f274825818ad');
        $params['sign'] = $sign;

//        return $params;
        $res = _curlrequest('http://openpay.duolaibei.com/api/gateway', $params, 'post');
        return $res;

        return AESjiami('abcd123456');
//        return encode('888888');
//        return decode('123456x544qo83ef');
        $ser = new UserServices();
        $res = $ser->checkSmsCode('286117', 'register', '18280066008');
//        return json_encode($res);
        return $res?'11':'22';
        return $new_login = cryption('888888', 'E', 'zy02022');
        return $new_login = cryption('7H+6DCDrGMtrESqhogM', 'D', 'zy02022');

        return AESjiami('haohao6752');
        $model = new UserModel();
        try {
            $model->getUserDetailByUid('7493267');
        }catch (Exception $e){
            return api_error_return($e->getMessage());
        }
        return 22;
    }







    // 测试redis
    public function testredis(){
        die();
        $redis = new \think\cache\driver\Redis();
        $redis->connect('127.0.0.1', 6379);
        $redis->set('Magic','http://shejishi.cc');
        echo $redis->get('Magic');
    }

    // 订单退款接口
    public function refund(Request $request){
        die();
//die();
//        list($body, $total_amount, $order_type, $remarks, $trade_type, $pay_way, $voucher_img) = $this->_payConf($uid, $params);
        // 这是测试 线要干掉
//        $total_amount = floatval('0.'.mt_rand(1, 3).mt_rand(1, 9));

//        $out_trade_no = 'CL'.rand(1000000000, 9999999999) . (string)date('ymdhis', time()) . (int)microtime(true); // 订单号



        $params = [
            'appid'=>'1059174',
            'out_trade_no'=>'CL82200455302206141216301655180190'
        ];
//        sr_log(json_encode($params));
        $sign = thirdPayGetSignCL('XMLfjHMPOGexsSaadIWSVCNG0XJBClZZ', $params);
        $params['sign'] = $sign;
//        return $params;
//        sr_log(json_encode($params));

        $res = _curlrequest('https://api2.payunk.com/index/refund', $params, 'post');
        sr_log(sr_getcurtime(time()).$res);

        $res = json_decode($res);
        return $res;

        if ($res && isset($res->code) && $res->code == 200){
//            $this->setPaymentOrder(compact('body', 'out_trade_no','total_amount', 'remarks', 'uid', 'trade_type', 'order_type', 'pay_way', 'voucher_img'), 7);
            return api_succ_return(['msg'=>'请求成功', 'data'=>['thirdpayclwx'=>['url'=>$res->url,'success_url'=>$success_url, 'error_url'=>$error_url]]]);

        }else{
            return api_error_return('获取失败');
        }
    }

    // 请求商品缓存
    public function updateTemple(Request $request){
die();
        Db::startTrans();
        try {

            $temp_list = Db::name('shop_buynote')->field('id,content')->select();
            $tempsarr = [];
            foreach ($temp_list as $key=>$val){
                $tempsarr[$val['id']] = $val['content'];
            }

            $list = Db::name('shop_goods')->field('goods_id,buynote_template_id')->select();
            foreach ($list as $key=>$val){
                Db::name('shop_goods')->where('goods_id', $val['goods_id'])->save(['buynote_template'=>$tempsarr[$val['buynote_template_id']]]);
            }

            Db::commit();
        }catch (\Exception $e){

            Db::rollback();
            return $e->getMessage();
        }

        return 'success';


    }



}