<?php

namespace app\api\model;

use think\Db;
use think\Model;
use think\facade\Env;
use app\common\pay\SignContract;
class User extends Model
{
    
    public function txt(){
        $list = db::name('user_monster_feed_log')->group('uid')->field('uid, sum(price) as price')->select();
        $total_price = db::name('user_monster_feed_log')->sum('price');
        dump($list);
        dump($total_price);
    }

    //清除用户token
    public function create_user_token($uid, $phone){
        if(empty($uid) && empty($phone)){
            return ['code' => 201, 'msg' => '参数错误', 'data' => null];
        }
        
        if(!empty($uid)){
            $user_info = db::name('user')->where('uid',$uid)->find();
            if($user_info){
                $data = [];
                $data['login_token'] = '';
                $data['update_time'] = time();
                $reslut = db::name('user')->where('uid',$uid)->update($data);
                if($reslut){
                    return ['code' => 200, 'msg' => '清除成功', 'data' => null];
                }
            }
        }else if(!empty($phone)){
            $user_info = db::name('user')->where('user_name',$phone)->find();
            if($user_info){
                $data = [];
                $data['login_token'] = '';
                $data['update_time'] = time();
                $reslut = db::name('user')->where('uid',$user_info['uid'])->update($data);
                if($reslut){
                    return ['code' => 200, 'msg' => '清除成功', 'data' => null];
                }
            }
        }
        
        return ['code' => 200, 'msg' => '请求成功', 'data' => null];
    }
    
    
    //检查用户登录状态
    public function check_login_token($login_token)
    {
        if (empty($login_token)) {
            return ['code' => 201, 'msg' => '登录失效', 'data' => null];
        }
        $map = [];
        $map[] = ['login_token', '=', $login_token];
        $user_info = db::name('user')->where($map)->find();
        if (empty($user_info)) {
            return ['code' => 201, 'msg' => '登录失效', 'data' => null];
        } elseif ($user_info['login_status'] != 1) {
            if($user_info['login_status'] == 3){
                return ['code' => 202, 'msg' => '该账号已被注销', 'data' => null];
            }
            return ['code' => 202, 'msg' => '用户已被封禁', 'data' => null];
        } else {
            //用户IP是否被封禁
            $map = [];
            $map[] = ['type', '=', 3];
            $map[] = ['type_text', '=', $user_info['login_ip']];
            $map[] = ['is_delete', '=', 1];
            $block_ip = db::name('block')->where($map)->find();
            if($block_ip){
                return ['code' => 202, 'msg' => '当前IP地址已被封禁。', 'data' => null];
            }
            
            //用户设备号是否被封禁
            $map = [];
            $map[] = ['type', '=', 1];
            $map[] = ['type_text', '=', $user_info['last_login_device']];
            $map[] = ['is_delete', '=', 1];
            $block_device = db::name('block')->where($map)->find();
            if($block_device){
                return ['code' => 202, 'msg' => '当前设备号已被封禁。', 'data' => null];
            }
            return ['code' => 200, 'msg' => '登录成功', 'data' => $user_info['uid']];
        }
    }

    //生成邀请 二维码
    public function get_user_reg_qrcode($uid)
    {
        $user_info = db::name('user')->where('uid', $uid)->find();
        if (empty($user_info)) {
            return ['code' => 200, 'msg' => '信息不存在', 'data' => null];
        }
        $web_site = model('admin/Config')->get_system_config('web_site');
        
        if (empty($user_info['reg_code_path'])||1) {

            $url = $web_site . "/index.php/index/index/register?reg_code=" . $user_info['reg_code']; //二维码地址
            require_once Env::get('root_path') . "/extend/phpqrcode/phpqrcode.php";
            $data = $url;
            $level = 'L'; // 容错级别：L、M、Q、H
            $size = 4;
            $qrcode = new \QRcode("");
            ob_start();
            //设置二维码图片名称，以及存放的路径
            $filename = './uploads/qrcode/' . time() . rand(10000, 99999) . '.jpg';
            $qrcode->png($data, $filename, $level, $size, 2);
            //上传到七牛云
   
            $reg_code_path = substr($filename, 1);
            dump($reg_code_path);exit;
            model('admin/Upload')->server_local_upload($reg_code_path);
            // $reg_code_path = $web_site . substr($filename, 1);
            db::name('user')->where(['uid' => $uid])->update(['reg_code_path' => $reg_code_path]);
            return ['code' => 200, 'msg' => '获取成功', 'data' => $reg_code_path];
        } else {
            return ['code' => 200, 'msg' => '获取成功', 'data' => $user_info['reg_code_path']];
        }
    }


    //获取用户信息
    public function get_user_info($uid)
    {
        $config = get_uncache_system_config();
        $map = [];
        $map[] = ['uid', '=', $uid];
        $user_info = db::name('user')->field('uid,user_name,base64_nick_name,head_pic,sex,birthday,special_uid,money,frozen_money,integral,room_profit,is_real,follow_num,fans_num,autograph,hobby,country,province,city,constellation,reg_code_path,charm_level,contribution_level,is_can_recharge,user_sig,is_teenager,reg_code,add_time,nick_name_color,is_room_hiding,is_open_address,vid')->where($map)->find();
        if (empty($user_info)) {
            return ['code' => 201, 'msg' => '用户信息不存在', 'data' => null];
        }
        $user_info['head_pic'] = localpath_to_netpath($user_info['head_pic']);
        $user_info['reg_code_path'] = localpath_to_netpath($user_info['reg_code_path']);
        $user_info['nick_name'] = mb_convert_encoding(base64_decode($user_info['base64_nick_name']), 'UTF-8', 'UTF-8');
        $user_info['collect_room_num'] = db::name('user_collect_room')->where(['uid' => $uid])->count(); //获取用户收藏房间总数
        $room = db::name('room')->where(['room_owner_uid' => $uid])->find();
        $user_info['rid'] = 0;
        if (!empty($room)) {
            $user_info['rid'] = $room['rid'];
        }
        if(empty($user_info['nick_name_color'])){
            $user_info['nick_name_color'] = '';
        }
        // $user_info['reg_url'] = 'http://' . $_SERVER['HTTP_HOST'] . '/index.php/index/index/register?reg_code=' . $user_info['reg_code'];
        $user_info['reg_url'] = $config['loacl_resource_url'] . '/index.php/index/index/register?reg_code=' . $user_info['reg_code'];
        //是否有公会
        $guild_id = 0;
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['status', '=', 1];
        $map[] = ['is_delete', '=', 1];
        $guild_info = db::name('user_guild')->where($map)->find();
        if($guild_info){
            $guild_id = $guild_info['guild_id'];
        }
        $user_info['guild_id'] = $guild_id;
        $user_info['is_new'] = 2;
        $is_new_time = $user_info['add_time'] + (60*60*24*7);
        if(time() < $is_new_time){
            $user_info['is_new'] = 1;
        }
        
        //cp数量
        $user_info['cp_num'] = 0;
        //CP信息
        $user_cp_info = model('Coupling')->user_coupling_info($uid);
        if($user_cp_info['data']['is_have_cp'] == 1){
            $user_info['cp_num'] = 1;
        }
        
        
        return ['code' => 200, 'msg' => '获取成功', 'data' => $user_info];
    }
    //指定用户信息
    public function get_base_user_info($uid)
    {
        $map = [];
        $map[] = ['uid', '=', $uid];
        $user_info = db::name('user')->field('uid,base64_nick_name,head_pic,sex,birthday,special_uid,follow_num,fans_num,autograph,country,province,city,constellation,charm_level,contribution_level')->where($map)->find();
        if (empty($user_info)) {
            return ['code' => 201, 'msg' => '用户不存在', 'data' => null];
        }
        $user_info['head_pic'] = localpath_to_netpath($user_info['head_pic']);
        $user_info['nick_name'] = mb_convert_encoding(base64_decode($user_info['base64_nick_name']), 'UTF-8', 'UTF-8');
        return ['code' => 200, 'msg' => '获取成功', 'data' => $user_info];
    }
    //用户资金信息
    public function get_user_money($uid)
    {
        $user_money = db::name('user')->field('uid,integral,money,real_name,alipay_name,alipay_account,room_profit,bank_card,open_bank,bank_card_number,bank_user_name')->find($uid);
        $user_money['money'] = $user_money['money'];
        // if (empty($user_money['alipay_account']) && empty($user_money['alipay_name'])) {
        if(empty($user_money['bank_card_number']) && empty($user_money['bank_card']) && empty($user_money['bank_user_name']) && empty($user_money['open_bank'])){
            $user_money['is_ali'] = 0;
        } else {
            $user_money['is_ali'] = 1;
        }
        $user_money['integral'] = (int)$user_money['integral'];
        // $map = [];
        // $map[] = ['player_uid', '=', $uid];
        // $map[] = ['status', '=', 3];
        // $map[] = ['is_over', '=', 1];
        // $order_income = db::name('user_player_order')->where($map)->sum('total_amount');

        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['change_type', '=', 6];
        $gifts_income =  db::name('user_money_log')->field('change_type,change_value')->where($map)->sum('change_value');

        // $map = [];
        // $map[] = ['uid', '=', $uid];
        // $map[] = ['change_type', '=', 5];
        // $order_income =  db::name('user_money_log')->field('change_type,change_value')->where($map)->sum('change_value');
        $user_money['gifts_income'] = $gifts_income; //礼物收入
        // $user_money['order_income'] = $order_income; //获取陪玩订单收益

        return ['code' => 200, 'msg' => '获取成功', 'data' => $user_money];
    }
    //用户收藏房间列表
    public function get_user_collect_room_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 10 ? $page_limit : 10;
        $model = Db::name('user_collect_room')->alias('a')->join('yy_room b', 'a.rid = b.rid');
        $map = [];
        $map[] = ['a.uid', '=', $uid];
        $map[] = ['b.is_delete', '=', 1];
        $model = $model->where($map);
        $list = $model->field('b.room_number,b.room_name,b.room_cover')->order('a.id desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['room_cover'] = localpath_to_netpath($v['room_cover']);
        }
        $data['on'] = $list;
        $data['off'] = [];
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }
    //用户余额资金日志列表
    public function get_user_money_log_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $ChangeTypeLable = model('admin/UserMoneyLog')->ChangeTypeLable();
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['money_type', '=', 1];
        $list = db::name('user_money_log')->field('log_id,change_type,change_value,remarks,add_time')->where($map)->order('log_id desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['change_type_desc'] = $ChangeTypeLable[$v['change_type']];
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }
    //用户积分资金日志列表
    public function get_user_integral_log_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $ChangeTypeLable = model('admin/UserMoneyLog')->ChangeTypeLable();
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['money_type', '=', 2];
        $list = db::name('user_money_log')->field('change_type,change_value,remarks,add_time')->where($map)->order('log_id desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['change_type_desc'] = $ChangeTypeLable[$v['change_type']];
            $v['change_value'] = (int)$v['change_value'];
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }
    //获取陪玩订单收益
    public function get_player_order_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $ChangeTypeLable = model('admin/UserMoneyLog')->ChangeTypeLable();
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['change_type', '=', 5];
        $list = db::name('user_money_log')->field('change_type,change_value,remarks,add_time')->where($map)->order('log_id desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['change_type_desc'] = $ChangeTypeLable[$v['change_type']];
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }
    //获取礼物收入
    public function get_gift_reward_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $ChangeTypeLable = model('admin/UserMoneyLog')->ChangeTypeLable();
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['change_type', '=', 4];
        $list = db::name('user_money_log')->field('change_type,change_value,remarks,add_time')->where($map)->order('log_id desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['change_type_desc'] = $ChangeTypeLable[$v['change_type']];
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }
    
    public function get_send_gift_user_list($uid, $gift_from_type,  $page, $page_limit)
    {
        $map = [];
        $map[] = ['uid', '=', $uid];
        if (!empty($gift_from_type)) {
            $map[] = ['gift_from_type', '=', $gift_from_type];
        }
        $list = db::name('user_send_gift')->field('uid,receive_uid,sum(gift_total_price) as total_send_amount,max(add_time) as last_send_time')->where($map)->group('receive_uid')->page($page, $page_limit)->order('add_time desc')->select();
        $map = [];
        $map[] = ['uid', 'in', array_column($list, 'receive_uid')];
        $user_list = db::name('user')->field('uid,base64_nick_name,head_pic')->where($map)->select();
        $user_data = [];
        foreach ($user_list as $k => $v) {

            $user_data[$v['uid']]['nick_name'] = mb_convert_encoding(base64_decode($v['base64_nick_name']), 'UTF-8', 'UTF-8');
            $user_data[$v['uid']]['head_pic'] = localpath_to_netpath($v['head_pic']);
            $user_data[$v['uid']]['uid'] = $v['uid'];
        }
        foreach ($list as $k => &$v) {
            $v['send_user_info'] = $user_data[$v['receive_uid']];
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }
    
    public function get_send_gift_list($uid, $gift_from_type, $receive_uid, $page, $page_limit)
    {
        $map = [];
        $map[] = ['uid', '=', $uid];
        if (!empty($gift_from_type)) {
            $map[] = ['gift_from_type', '=', $gift_from_type];
        }
        if (!empty($receive_uid)) {
            $map[] = ['receive_uid', '=', $receive_uid];
        }
        $list = db::name('user_send_gift')->field('gid,gift_name,gift_price,gift_num,gift_total_price')->where($map)->page($page, $page_limit)->select();
        $gift_data = db::name('gift')->cache(10)->column('base_image', 'gid');
        foreach ($list as $k => &$v) {
            $v['base_image'] = localpath_to_netpath($gift_data[$v['gid']]);
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }

    public function get_receive_gift_user_list($uid, $gift_from_type, $page, $page_limit)
    {
        $map = [];
        $map[] = ['receive_uid', '=', $uid];
        if (!empty($gift_from_type)) {
            $map[] = ['gift_from_type', '=', $gift_from_type];
        }
        $list = db::name('user_send_gift')->field('uid,receive_uid,sum(gift_total_price) as total_send_amount,max(add_time) as last_send_time')->where($map)->group('uid')->page($page, $page_limit)->order('add_time desc')->select();
        $map = [];
        $map[] = ['uid', 'in', array_column($list, 'uid')];
        $user_list = db::name('user')->field('uid,base64_nick_name,head_pic')->where($map)->select();
        $user_data = [];
        foreach ($user_list as $k => $v) {
            $user_data[$v['uid']]['nick_name'] = mb_convert_encoding(base64_decode($v['base64_nick_name']), 'UTF-8', 'UTF-8');
            $user_data[$v['uid']]['head_pic'] = localpath_to_netpath($v['head_pic']);
            $user_data[$v['uid']]['uid'] = $v['uid'];
        }
        foreach ($list as $k => &$v) {
            $v['send_user_info'] = $user_data[$v['uid']];
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }

    public function get_receive_gift_list($receive_uid, $gift_from_type, $uid,  $page, $page_limit)
    {
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['receive_uid', '=', $receive_uid];
        if (!empty($gift_from_type)) {
            $map[] = ['gift_from_type', '=', $gift_from_type];
        }
        $list = db::name('user_send_gift')->field('gid,gift_name,gift_price,gift_num,gift_total_price,add_time')->where($map)->page($page, $page_limit)->select();
        $gift_data = db::name('gift')->cache(10)->column('base_image', 'gid');
        foreach ($list as $k => &$v) {
            $v['base_image'] = localpath_to_netpath($gift_data[$v['gid']]);
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }

    public function get_user_level_info($uid)
    {
        $charm_level_info = $this->get_user_charm_level_info($uid);
        $contribution_level_info = $this->get_user_contribution_info($uid);
        $nobility_info = $this->get_user_nobility_info($uid);
        $data = [];
        $data['charm_level_info'] = $charm_level_info['data'];
        $data['contribution_level_info'] = $contribution_level_info['data'];
        $data['nobility_info'] = $nobility_info['data'];
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }
    
    //用户爵位信息
    public function get_user_nobility_info($uid){
        
        $user_info = db::name('user')->field('nobility_id')->find($uid);
        $nobility_id = $user_info['nobility_id'];
        $nobility_image = '';
        if(!empty($user_info['nobility_id'])){
            $nobility_info = db::name('nobility')->find($nobility_id);
            $nobility_image = localpath_to_netpath($nobility_info['image']);
        }
        
        $data = [];
        $data['nobility_id'] = $nobility_id;
        $data['nobility_image'] = $nobility_image;
        
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }

    //获取用户等级魅力值详情
    public function get_user_charm_level_info($uid)
    {
        $user_info = db::name('user')->field('charm_value,charm_level')->find($uid);
        $map = [];
        $map[] = ['type', '=', 1];
        $map[] = ['is_delete', '=', 1];
        $user_level_list = db::name('user_level')->cache(600)->where($map)->order('level asc')->select();
        $rest_value = $user_info['charm_value'];
        $next_value = 0;
        $now_level_image = "";
        $next_level_image = "";
        $next_level = $user_info['charm_level'];
        foreach ($user_level_list as $k => $v) {
            if ($v['level'] == $user_info['charm_level']) {
                $now_level_image = $v['image'];
            }
            $rest_values = $rest_value;
            $rest_value = $rest_value - $v['number'];
            //下一等级初始化
            $next_value = $v['level'];
            $next_level_image = $v['image'];
            if ($rest_value < 0) {
                $rest_values = $rest_values;
                $next_value = $v['number'];
                $next_level_image = $v['image'];
                $next_level = $v['level'];
                break;
            }
        }
        $data = [];
        $data['now_level'] = $user_info['charm_level'];
        // $data['now_value'] = $user_info['charm_value'] * 1;
        $data['now_value'] = $rest_values;
        $data['now_level_image'] = localpath_to_netpath($now_level_image);
        $data['next_level'] = $next_level;
        $data['next_level_image'] = localpath_to_netpath($next_level_image);
        $data['next_value'] = $next_value;
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }

    //获取用户头像框详情
    public function get_user_avatar_info($uid)
    {
        $data = [];
        //获取用户头像框
        $map = [];
        $map[] = ['a.is_using', '=', 1];
        $map[] = ['a.uid', '=', $uid];
        $map[] = ['a.end_time', '>', time()];
        $map[] = ['a.type', '=', 1];
        $map[] = ['b.show_status', '=', 1];
        $map[] = ['b.is_delete', '=', 1];
        $model = Db::name('user_decorate')->alias('a')->join('yy_decorate b', 'a.did = b.did');
        $user_decorate_info = $model->field('b.base_image,b.play_image,b.title,a.uid')->where($map)->find();
        $data['avatar_play_image'] = '';
        if (!empty($user_decorate_info)) {
            $data['avatar_play_image'] = localpath_to_netpath($user_decorate_info['play_image']);
        }
        
        //翅膀装扮
        $map = [];
        $map[] = ['a.is_using', '=', 1];
        $map[] = ['a.uid', '=', $uid];
        $map[] = ['a.end_time', '>', time()];
        $map[] = ['a.type', '=', 1];
        $map[] = ['b.show_status', '=', 1];
        $map[] = ['b.is_delete', '=', 1];
        $model = Db::name('user_decorate')->alias('a')->join('yy_decorate b', 'a.did = b.did');
        $user_decorate_info = $model->field('b.base_image,b.play_image,b.title,a.uid')->where($map)->find();
        $data['win_base_image'] = '';
        $data['win_play_image'] = '';
        if (!empty($user_decorate_info)) {
            $data['win_base_image'] = localpath_to_netpath($user_decorate_info['base_image']);
            $data['win_play_image'] = localpath_to_netpath($user_decorate_info['play_image']);
        }
        
        
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }
    //获取用户魅力等级、财富值等级详情
    public function get_user_charm_contribution_info($user_info)
    {
        $user_info = db::name('user')->field('charm_level,contribution_level')->find($user_info);
        //获取用户财富值、魅力值等级
        $map = [];
        $map[] = ['is_delete', '=', 1];
        $user_level_list =  db::name('user_level')->cache(600)->where($map)->order('level asc')->select();
        $data = [];
        $data['charm_level_image'] = '';
        $data['contribution_level_image'] = '';
        foreach ($user_level_list as $k => $v) {
            if ($v['type'] == 1 && $user_info['charm_level'] == $v['level']) {
                $data['charm_level_image'] = localpath_to_netpath($v['image']);
            } elseif ($v['type'] == 2 && $user_info['contribution_level'] == $v['level']) {
                $data['contribution_level_image'] = localpath_to_netpath($v['image']);
            }
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }


    //获取用户贡献值详情
    public function get_user_contribution_info($uid)
    {
        $user_info = db::name('user')->field('contribution_value,contribution_level')->find($uid);
        $map = [];
        $map[] = ['type', '=', 2];
        $map[] = ['is_delete', '=', 1];
        $user_level_list = db::name('user_level')->cache(600)->where($map)->order('level asc')->select();
        $rest_value = $user_info['contribution_value'];
        $next_value = 0;
        $now_level_image = "";
        $next_level_image = "";
        $next_level = $user_info['contribution_level'];
        foreach ($user_level_list as $k => $v) {
            if ($v['level'] == $user_info['contribution_level']) {
                $now_level_image = $v['image'];
            }
            $rest_values = $rest_value;
            $rest_value = $rest_value - $v['number'];
            //下一等级初始化
            $next_value = $v['level'];
            $next_level_image = $v['image'];
            if ($rest_value < 0) {
                $rest_values = $rest_values;
                $next_value = $v['number'];
                $next_level_image = $v['image'];
                $next_level = $v['level'];
                break;
            }
        }
        $data = [];
        $data['now_level'] = $user_info['contribution_level'];
        // $data['now_value'] = $user_info['contribution_value'] * 1;
        $data['now_value'] = $rest_values;
        $data['now_level_image'] = localpath_to_netpath($now_level_image);
        $data['next_level'] = $next_level;
        $data['next_level_image'] = localpath_to_netpath($next_level_image);
        $data['next_value'] = $next_value;
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }

    public function get_user_follow_list($uid, $page, $page_limit)
    {

        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $map = [];
        $map[] = ['a.uid', '=', $uid];
        $model = Db::name('user_follow')->alias('a')->join('yy_user b', 'a.follow_uid = b.uid');
        $model = $model->where($map);
        $list = $model->field('a.fid,a.follow_uid,b.uid,b.base64_nick_name,b.head_pic,b.uid,b.sex,b.special_uid,b.is_online')->order('a.fid desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['head_pic'] = localpath_to_netpath($v['head_pic']);
            $v['nick_name'] = mb_convert_encoding(base64_decode($v['base64_nick_name']), 'UTF-8', 'UTF-8');
            $v['is_follow'] = 2;
            $is_follow = db::name('user_follow')->where(['uid' => $v['follow_uid'], 'follow_uid' => $uid])->find();
            if ($is_follow) {
                $v['is_follow'] = 1;
            }
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }

    public function get_user_fans_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $map = [];
        $map[] = ['a.follow_uid', '=', $uid];
        $model = Db::name('user_follow')->alias('a')->join('yy_user b', 'a.uid = b.uid');
        $model = $model->where($map);
        $list = $model->field('a.fid,a.uid as fuid,a.follow_uid,b.uid,b.base64_nick_name,b.head_pic,b.uid,b.sex,b.special_uid,b.is_online')->order('a.fid desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['head_pic'] = localpath_to_netpath($v['head_pic']);
            $v['nick_name'] = mb_convert_encoding(base64_decode($v['base64_nick_name']), 'UTF-8', 'UTF-8');
            $v['is_follow'] = 2;
            $is_follow = db::name('user_follow')->where(['uid' => $uid, 'follow_uid' => $v['fuid']])->find();
            if ($is_follow) {
                $v['is_follow'] = 1;
            }
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }
    //获取我的邀请人
    public function get_user_child_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $map = [];
        $map[] = ['pid', '=', $uid];
        $list = Db::name('user')->where($map)->field('uid,pid,nick_name,base64_nick_name,head_pic,sex,special_uid,add_time')->order('uid desc')->page($page, $page_limit)->select();
        foreach ($list as $k => &$v) {
            $v['head_pic'] = localpath_to_netpath($v['head_pic']);
            $v['nick_name'] = mb_convert_encoding(base64_decode($v['base64_nick_name']), 'UTF-8', 'UTF-8');
            $v['add_time'] = date('Y-m-d H:i:s', $v['add_time']);
            $where = [];
            $where[] = ['uid', '=', $uid];
            $where[] = ['change_type', '=', 22];
            $where[] = ['from_uid', '=', $v['uid']];
            $v['give_earnings'] = db::name('user_money_log')->where($where)->sum('change_value');
        }
        
        //用户总收益
        $user_earnings = db::name('user_money_log')->where('uid', $uid)->where('change_type', 22)->sum('change_value');
        $data = [];
        $data['list'] = $list;
        $data['user_total_earnings'] = $user_earnings;
        return ['code' => 200, 'msg' => '获取成功', 'data' => $data];
    }
    //关注用户
    public function follow_user($uid, $follow_uid)
    {
        $user_info = db::name('user')->find($follow_uid);
        if (empty($user_info)) {
            return ['code' => 201, 'msg' => '关注用户不存在', 'data' => null];
        }
        if ($uid == $follow_uid) {
            return ['code' => 201, 'msg' => '不能关注自己', 'data' => null];
        }
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['follow_uid', '=', $follow_uid];
        $info = db::name('user_follow')->where($map)->find();
        if (!empty($info)) {
            return ['code' => 200, 'msg' => '关注成功', 'data' => null];
        }
        $data = [];
        $data['uid'] = $uid;
        $data['follow_uid'] = $follow_uid;
        $data['add_time'] = time();
        $data['update_time'] = time();
        $reslut = db::name('user_follow')->insert($data);
        if ($reslut) {
            db::name('user')->where(['uid' => $uid])->setInc('follow_num');
            db::name('user')->where(['uid' => $follow_uid])->setInc('fans_num');
            return ['code' => 200, 'msg' => '关注成功', 'data' => null];
        } else {
            return ['code' => 201, 'msg' => '关注失败', 'data' => null];
        }
    }
    //取消关注
    public function unfollow_user($uid, $follow_uid)
    {
        $user_info = db::name('user')->find($follow_uid);
        if (empty($user_info)) {
            return ['code' => 201, 'msg' => '关注用户不存在', 'data' => null];
        }
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['follow_uid', '=', $follow_uid];
        $info = db::name('user_follow')->where($map)->find();
        if (empty($info)) {
            return ['code' => 200, 'msg' => '取关成功', 'data' => null];
        }
        $reslut = db::name('user_follow')->delete($info['fid']);
        if ($reslut) {
            db::name('user')->where(['uid' => $uid])->setDec('follow_num');
            db::name('user')->where(['uid' => $follow_uid])->setDec('fans_num');
            return ['code' => 200, 'msg' => '取注成功', 'data' => null];
        } else {
            return ['code' => 201, 'msg' => '取注失败', 'data' => null];
        }
    }
    public function modify_user_info($uid, $nick_name, $birthday, $sex, $head_pic, $city, $autograph, $hobby)
    {

        $text = $nick_name . $autograph . $hobby;
        if(!empty($text)) {
            $result = model('Tencent')->content_moderation('Text', $text);
            if($result['code'] != 200) {
                return ['code' => 201, 'msg' => '昵称或签名或爱好有违禁词!', 'data' => null];
            }
        }          
        

        $data = [];
        $data['uid'] = $uid;
        if (!empty($nick_name)) {
            $nick_name = htmlspecialchars_decode($nick_name);
            $data['nick_name'] = $nick_name;
            $data['base64_nick_name'] = base64_encode($nick_name);
            $nick_name_info = db::name('user')->where('base64_nick_name', $data['base64_nick_name'])->find();
            if(!empty($nick_name_info)){
                if($uid != $nick_name_info['uid']){
                    return['code' => 201, 'msg' => '该昵称已被占用', 'data' => null];
                }
            }
            if(mb_strlen($nick_name) > 15){
                return['code' => 201, 'msg' => '昵称长度不能超过15个字符', 'data' => null];
            }
        }
        if (!empty($birthday)) {
            $data['birthday'] = $birthday;
            $constellation = $this->get_user_constellation($birthday);
            $data['constellation'] = $constellation['data'];
        }
        
        
        if (!empty($head_pic)) {
            // $data['head_pic'] = $param['path'];
            $filepath_url = get_filepath_url();
            $params = parse_url($filepath_url);
            $param = parse_url($head_pic);
            if(isset($param['host'])) {
                if (!empty($param['path'])) {
                    if($params['host'] == $param['host']) {
                        $head_pic = $param['path'];
                        $head_pic = trim($head_pic, '/');
                    } 
                    $data['head_pic'] = $head_pic;
                }
            } else {
                $data['head_pic'] = $head_pic;
            }
            
        }
        
        
        if (!empty($city)) {
            $data['city'] = $city;
        }

        if (!empty($autograph)) {
            $data['autograph'] = $autograph;
        }
        if(!empty($hobby)){
            $data['hobby'] = $hobby;
        }
        $validate = validate('admin/User');
        $reslut = $validate->scene('apiEditInfo')->check($data);
        if ($reslut !== true) {
            return ['code' => 201, 'msg' => $validate->getError(), 'data' => null];
        }
        $data['sex'] = $sex;
        $data['update_time'] = time();
        // $reslut = model('admin/user')->save($data);
        $reslut = db::name('user')->update($data);
        if ($reslut) {
            $user_info = db::name('user')->field('uid,user_name,base64_nick_name,head_pic,sex,birthday,special_uid,money,frozen_money,integral,room_profit,is_real,follow_num,fans_num,autograph,hobby,country,province,city,constellation')->find($uid);
            $user_info['nick_name'] = mb_convert_encoding(base64_decode($user_info['base64_nick_name']), 'UTF-8', 'UTF-8');
            $user_info['head_pic'] = localpath_to_netpath($user_info['head_pic']);
            return ['code' => 200, 'msg' => '修改成功', 'data' => $user_info];
        } else {
            return ['code' => 201, 'msg' => '修改失败', 'data' => null];
        }
    }
    public function modify_password($mobile, $password)
    {
        $uid = db::name('user')->where(['user_name' => $mobile])->value('uid');
        $data = [];
        $data['uid'] = $uid;
        $data['password'] = $password;
        $validate = validate('admin/User');
        $reslut = $validate->scene('apiEditPassword')->check($data);
        if ($reslut !== true) {
            return ['code' => 201, 'msg' => $validate->getError(), 'data' => null];
        }
        // $reslut = model('admin/user')->save($data);
        $reslut = db::name('user')->where(['uid' => $uid])->update(['password' => md5($password)]);
        
        //撸号修改密码
        $user_lu_pwd = db::name('user_lu_pwd')->where(['uid'=>$uid])->find();
        if(!empty($user_lu_pwd)){
            db::name('user_lu_pwd')->where(['uid'=>$uid])->update(['pwd'=>$password]);       
        }
 
        
        if ($reslut) {
            return ['code' => 200, 'msg' => '修改成功', 'data' => null];
        } else {
            return ['code' => 201, 'msg' => '修改失败', 'data' => null];
        }
    }

    public function modify_trade_password($uid, $trade_password)
    {
        $data = [];
        $data['uid'] = $uid;
        $data['trade_password'] = $trade_password;
        $validate = validate('admin/User');
        $reslut = $validate->scene('apiEditTradePassword')->check($data);
        if ($reslut !== true) {
            return ['code' => 201, 'msg' => $validate->getError(), 'data' => null];
        }
        // $reslut = model('admin/user')->save($data);
        $data['trade_password'] = md5($trade_password);
        $reslut = $reslut = db::name('user')->update($data);
        if ($reslut) {
            return ['code' => 200, 'msg' => '修改成功', 'data' => null];
        } else {
            return ['code' => 201, 'msg' => '修改失败', 'data' => null];
        }
    }
    //修改用户打赏价值/等级
    // public function change_user_contribution_value($uid, $change_value)
    // {
    //     $user_info = db::name('user')->field('uid,contribution_value')->find($uid);
    //     $map = [];
    //     $map[] = ['type', '=', 2];
    //     $map[] = ['is_delete', '=', 1];
    //     $user_level_list = db::name('user_level')->where($map)->order('level asc')->select();
    //     $rest_value = $user_info['contribution_value'] + $change_value;
    //     $now_level = 0;
    //     foreach ($user_level_list as $k => $v) {
    //         $rest_value = $rest_value - $v['number'];
    //         if ($rest_value < 0) {
    //             break;
    //         }
    //         $now_level = $v['level'];
    //     }
    //     $map = [];
    //     $map[] = ['uid', '=', $uid];
    //     $data = [];
    //     $data['contribution_value'] = Db::raw('contribution_value+' . $change_value);
    //     $data['contribution_level'] = $now_level;
    //     $data['update_time'] = time();
    //     $reslut = db::name('user')->where($map)->update($data);
    //     if ($reslut) {
    //         return ['code' => 200, 'msg' => '修改成功', 'data' => null];
    //     } else {
    //         return ['code' => 201, 'msg' => '修改失败', 'data' => null];
    //     }
    // }
    //修改用户打赏价值/等级
    public function change_user_contribution_value($uid, $change_value)
    {
        $user_info = db::name('user')->field('uid,contribution_value,sex,contribution_level')->find($uid);
        $change_value = $change_value * 10;
        $map = [];
        $map[] = ['type', '=', 2];
        $map[] = ['is_delete', '=', 1];
        $user_level_list = db::name('user_level')->where($map)->order('level asc')->select();
        $rest_value = $user_info['contribution_value'] + $change_value;
        $now_level = 0;
        foreach ($user_level_list as $k => $v) {
            $rest_value = $rest_value - $v['number'];
            
            if ($rest_value < 0) {
            // if ($rest_value < $v['number']) {
                break;
            }
            $now_level = $v['level'];
        }
      
        $level_difference = $now_level - $user_info['contribution_level'];
        $now_levels = $now_level+1;
        $contribution_level = $user_info['contribution_level']+1;
       
        Db::startTrans();
        try {
            //该等级是否获得新装扮
            if($level_difference > 0){
                // dump(1111);
                for($i = $contribution_level; $i < $now_levels; $i++){
                    $map = [];
                    $map[] = ['type', '=', 2];
                    $map[] = ['is_delete', '=', 1];
                    $map[] = ['level', '=', $i];
                    $user_level_info = db::name('user_level')->where($map)->find();
                    
                    if(!empty($user_level_info['head_decorate_id'])){//head_decorate_id
                            //该装扮是否存在
                        $map = [];
                        $map[] = ['is_delete', '=', 1];
                        $map[] = ['did', '=', $user_level_info['head_decorate_id']];
                        $decorate = db::name('decorate')->where($map)->find();
                        // dump($decorate);
                        if($decorate){
                            //添加到用户装扮
                            $map = [];
                            $map[] = ['uid', '=', $uid];
                            $map[] = ['did', '=', $user_level_info['head_decorate_id']];
                            $user_decorate = db::name('user_decorate')->where($map)->find();
                            if(!$user_decorate){
                                $add_date = [];
                                $add_date['uid'] = $uid;
                                $add_date['type'] = 1;
                                $add_date['did'] = $user_level_info['head_decorate_id'];
                                $time = 720 * 60 * 60 * 24;
                                $add_date['end_time'] = time() + $time;
                                $add_date['add_time'] = time();
                                $reslut = db::name('user_decorate')->insert($add_date);
                                if(!$reslut){
                                    Db::rollback();
                                    return ['code' => 201, 'msg' => "获取失败", 'data' => null];
                                }
                            }
                        }
                    }
                    if(!empty($user_level_info['mount_decorate_id'])){
                        //该进场特效是否存在
                        $map = [];
                        $map[] = ['is_delete', '=', 1];
                        $map[] = ['did', '=', $user_level_info['mount_decorate_id']];
                        $decorate = db::name('decorate')->where($map)->find();
                        if($decorate){
                            //添加到用户装扮
                            $map = [];
                            $map[] = ['uid', '=', $uid];
                            $map[] = ['did', '=', $user_level_info['mount_decorate_id']];
                            $user_decorate = db::name('user_decorate')->where($map)->find();
                            if(!$user_decorate){
                                $add_date = [];
                                $add_date['uid'] = $uid;
                                $add_date['type'] = 3;
                                $add_date['did'] = $user_level_info['mount_decorate_id'];
                                $time = 720 * 60 * 60 * 24;
                                $add_date['end_time'] = time() + $time;
                                $add_date['add_time'] = time();
                                $reslut = db::name('user_decorate')->insert($add_date);
                                if(!$reslut){
                                    Db::rollback();
                                    return ['code' => 201, 'msg' => "获取失败", 'data' => null];
                                }
                            }
                        }
                    }
                    //判断用户性别
                    // if($user_info['sex'] == 1){
                    //     if(!empty($user_level_info['head_decorate_id'])){//head_decorate_id
                    //         //该装扮是否存在
                    //         $map = [];
                    //         $map[] = ['is_delete', '=', 1];
                    //         $map[] = ['did', '=', $user_level_info['man_head_decorate_id']];
                    //         $decorate = db::name('decorate')->where($map)->find();
                    //         // dump($decorate);
                    //         if($decorate){
                    //             //添加到用户装扮
                    //             $map = [];
                    //             $map[] = ['uid', '=', $uid];
                    //             $map[] = ['did', '=', $user_level_info['man_head_decorate_id']];
                    //             $user_decorate = db::name('user_decorate')->where($map)->find();
                    //             if(!$user_decorate){
                    //                 $add_date = [];
                    //                 $add_date['uid'] = $uid;
                    //                 $add_date['type'] = 1;
                    //                 $add_date['did'] = $user_level_info['man_head_decorate_id'];
                    //                 $time = 720 * 60 * 60 * 24;
                    //                 $add_date['end_time'] = time() + $time;
                    //                 $add_date['add_time'] = time();
                    //                 $reslut = db::name('user_decorate')->insert($add_date);
                    //                 if(!$reslut){
                    //                     Db::rollback();
                    //                     return ['code' => 201, 'msg' => "获取失败", 'data' => null];
                    //                 }
                    //             }
                    //         }
                    //     }
                    //     if(!empty($user_level_info['man_mount_decorate_id'])){
                    //         //该进场特效是否存在
                    //         $map = [];
                    //         $map[] = ['is_delete', '=', 1];
                    //         $map[] = ['did', '=', $user_level_info['man_mount_decorate_id']];
                    //         $decorate = db::name('decorate')->where($map)->find();
                    //         if($decorate){
                    //             //添加到用户装扮
                    //             $map = [];
                    //             $map[] = ['uid', '=', $uid];
                    //             $map[] = ['did', '=', $user_level_info['man_mount_decorate_id']];
                    //             $user_decorate = db::name('user_decorate')->where($map)->find();
                    //             if(!$user_decorate){
                    //                 $add_date = [];
                    //                 $add_date['uid'] = $uid;
                    //                 $add_date['type'] = 3;
                    //                 $add_date['did'] = $user_level_info['man_mount_decorate_id'];
                    //                 $time = 720 * 60 * 60 * 24;
                    //                 $add_date['end_time'] = time() + $time;
                    //                 $add_date['add_time'] = time();
                    //                 $reslut = db::name('user_decorate')->insert($add_date);
                    //                 if(!$reslut){
                    //                     Db::rollback();
                    //                     return ['code' => 201, 'msg' => "获取失败", 'data' => null];
                    //                 }
                    //             }
                    //         }
                    //     }
                    // }else{
                    //     if(!empty($user_level_info['woman_head_decorate_id'])){//head_decorate_id
                    //         //该装扮是否存在
                    //         $map = [];
                    //         $map[] = ['is_delete', '=', 1];
                    //         $map[] = ['did', '=', $user_level_info['woman_head_decorate_id']];
                    //         $decorate = db::name('decorate')->where($map)->find();
                    //         // dump($decorate);
                    //         if($decorate){
                    //             //添加到用户装扮
                    //             $map = [];
                    //             $map[] = ['uid', '=', $uid];
                    //             $map[] = ['did', '=', $user_level_info['woman_head_decorate_id']];
                    //             $user_decorate = db::name('user_decorate')->where($map)->find();
                    //             if(!$user_decorate){
                    //                 $add_date = [];
                    //                 $add_date['uid'] = $uid;
                    //                 $add_date['type'] = 1;
                    //                 $add_date['did'] = $user_level_info['woman_head_decorate_id'];
                    //                 $time = 720 * 60 * 60 * 24;
                    //                 $add_date['end_time'] = time() + $time;
                    //                 $add_date['add_time'] = time();
                    //                 $reslut = db::name('user_decorate')->insert($add_date);
                    //                 if(!$reslut){
                    //                     Db::rollback();
                    //                     return ['code' => 201, 'msg' => "获取失败", 'data' => null];
                    //                 }
                    //             }
                    //         }
                    //     }
                    //     if(!empty($user_level_info['woman_mount_decorate_id'])){
                    //         //该进场特效是否存在
                    //         $map = [];
                    //         $map[] = ['is_delete', '=', 1];
                    //         $map[] = ['did', '=', $user_level_info['woman_mount_decorate_id']];
                    //         $decorate = db::name('decorate')->where($map)->find();
                    //         if($decorate){
                    //             //添加到用户装扮
                    //             $map = [];
                    //             $map[] = ['uid', '=', $uid];
                    //             $map[] = ['did', '=', $user_level_info['woman_mount_decorate_id']];
                    //             $user_decorate = db::name('user_decorate')->where($map)->find();
                    //             if(!$user_decorate){
                    //                 $add_date = [];
                    //                 $add_date['uid'] = $uid;
                    //                 $add_date['type'] = 3;
                    //                 $add_date['did'] = $user_level_info['woman_mount_decorate_id'];
                    //                 $time = 720 * 60 * 60 * 24;
                    //                 $add_date['end_time'] = time() + $time;
                    //                 $add_date['add_time'] = time();
                    //                 $reslut = db::name('user_decorate')->insert($add_date);
                    //                 if(!$reslut){
                    //                     Db::rollback();
                    //                     return ['code' => 201, 'msg' => "获取失败", 'data' => null];
                    //                 }
                    //             }
                    //         }
                    //     }
                    // }
                }
            }
            
            $map = [];
            $map[] = ['uid', '=', $uid];
            $data = [];
            $data['contribution_value'] = Db::raw('contribution_value+' . $change_value);
            $data['contribution_level'] = $now_level;
            $data['update_time'] = time();
            $reslut = db::name('user')->where($map)->update($data);
            if (!$reslut) {
                return ['code' => 201, 'msg' => '修改失败', 'data' => null];
            }
            
            Db::commit();
            return ['code' => 200, 'msg' => "修改成功", 'data' => null];
        } catch (\Exception $e) {
            //回滚事务
            Db::rollback();
            return ['code' => 201, 'msg' => "修改失败", 'data' => null];
        }
        
        // $map = [];
        // $map[] = ['uid', '=', $uid];
        // $data = [];
        // $data['contribution_value'] = Db::raw('contribution_value+' . $change_value);
        // $data['contribution_level'] = $now_level;
        // $data['update_time'] = time();
        // $reslut = db::name('user')->where($map)->update($data);
        // if ($reslut) {
        //     return ['code' => 200, 'msg' => '修改成功', 'data' => null];
        // } else {
        //     return ['code' => 201, 'msg' => '修改失败', 'data' => null];
        // }
    }
    //修改用户房间魅力值
    public function change_user_room_charm_value($uid, $rid, $change_value, $user_id)
    {
        $change_value = $change_value * 10;
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['rid', '=', $rid];
        $data = [];
        $data['update_time'] = time();
        $info = db::name('room_user_cc')->where($map)->find();
        Db::startTrans();
        try {
            if($info){
                $cid = $info['cid'];
                $reslut = db::name('room_user_cc')->where('cid', $cid)->inc('charm_value', $change_value)->inc('total_charm_value', $change_value)->update($data);
                if (!$reslut) {
                    Db::rollback();
                    return ['code' => 201, 'msg' => "失败", 'data' => null];
                }
            }else{
                $data = [];
                $data['uid'] = $uid;
                $data['rid'] = $rid;
                $data['charm_value'] = $change_value;
                $data['total_charm_value'] = $change_value;
                $data['uid'] = $uid;
                $data['add_time'] = time();
                $data['update_time'] = time();
                $cid = db::name('room_user_cc')->insertGetId($data);
                if (!$cid) {
                    Db::rollback();
                    return ['code' => 201, 'msg' => "失败", 'data' => null];
                }
            }
            
            //增加用户明细
            $charm_log = db::name('room_user_micro_charm_log')->where('uid', $user_id)->where('cid', $cid)->find();
            if($charm_log){
                $reslut = db::name('room_user_micro_charm_log')->where('id', $charm_log['id'])->inc('change_value', $change_value)->update(['update_time' => time()]);
            }else{
                $insert = [];
                $insert['uid'] = $user_id;
                $insert['cid'] = $cid;
                $insert['change_value'] = $change_value;
                $insert['add_time'] = time();
                $reslut = db::name('room_user_micro_charm_log')->insert($insert);
            }
            if(!$reslut){
                Db::rollback();
                return ['code' => 201, 'msg' => "失败", 'data' => null];
            }
            
            Db::commit();
            return ['code' => 200, 'msg' => "成功", 'data' => null];
        } catch (\Exception $e) {
            dump($e);
            //回滚事务
            Db::rollback();
            return ['code' => 201, 'msg' => "失败", 'data' => null];
        }
    }
    //修改用户房间财富值
    public function change_user_room_contribution_value($uid, $rid, $change_value)
    {
        $change_value = $change_value * 10;
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['rid', '=', $rid];
        $data = [];
        $data['update_time'] = time();
        $reslut = db::name('room_user_cc')->where($map)->inc('contribution_value', $change_value)->inc('total_contribution_value', $change_value)->update($data);
        if (!$reslut) {
            $data = [];
            $data['uid'] = $uid;
            $data['rid'] = $rid;
            $data['contribution_value'] = $change_value;
            $data['total_contribution_value'] = $change_value;
            $data['uid'] = $uid;
            $data['add_time'] = time();
            $data['update_time'] = time();
            db::name('room_user_cc')->insert($data);
        }
        return ['code' => 200, 'msg' => '修改成功', 'data' => null];
    }

    //修改用户打赏价值/等级
    public function change_user_charm_value($uid, $change_value)
    {
        $change_value = $change_value * 10;
        $user_info = db::name('user')->field('uid,charm_value')->find($uid);
        $map = [];
        $map[] = ['type', '=', 1];
        $map[] = ['is_delete', '=', 1];
        $user_level_list = db::name('user_level')->where($map)->order('level asc')->select();
        $rest_value = $user_info['charm_value'] + $change_value;
        $now_level = 0;
        foreach ($user_level_list as $k => $v) {
            $rest_value = $rest_value - $v['number'];
            if ($rest_value < 0) {
                break;
            }
            $now_level = $v['level'];
        }
        $map = [];
        $map[] = ['uid', '=', $uid];
        $data = [];
        $data['charm_value'] = Db::raw('charm_value+' . $change_value);
        $data['charm_level'] = $now_level;
        $data['update_time'] = time();
        $reslut = db::name('user')->where($map)->update($data);
        if ($reslut) {
            return ['code' => 200, 'msg' => '修改成功', 'data' => null];
        } else {
            return ['code' => 201, 'msg' => '修改失败', 'data' => null];
        }
    }
    //增加厅主房间收益记录
    public function change_user_room_profit($uid, $rid, $change_value)
    {
        $change_value = $change_value * 10;
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['rid', '=', $rid];
        $data = [];
        $data['update_time'] = time();
        $reslut = db::name('room_user_cc')->where($map)->inc('room_profit', $change_value)->update($data);
        if (!$reslut) {
            $data = [];
            $data['uid'] = $uid;
            $data['rid'] = $rid;
            $data['room_profit'] = $change_value;
            $data['add_time'] = time();
            $data['update_time'] = time();
            db::name('room_user_cc')->insert($data);
        }
        return ['code' => 200, 'msg' => '修改成功', 'data' => null];
    }

    //兑换查询
    public function exchange_check($money)
    {
        $config = model('admin/Config')->get_system_config();
        $exchange_rate = $config['exchange_rate'];
        $data['money'] = ($money * $exchange_rate);
        return ['code' => 200, 'msg' => '查询成功', 'data' => $data];
    }

    //用户转赠
    public function user_give_integral($uid, $reveive_uid, $integral, $last_login_device)
    {
        
        if ($integral < 1 || intval($integral) != $integral) {
            return ['code' => 201, 'msg' => '转赠数量必须为正整数', 'data' => null];
        }
        if($uid == $reveive_uid){
            return ['code' => 201, 'msg' => '无法转赠给自己', 'data' => null];
        }
        
        $user_info = db::name('user')->find($uid);
        if($user_info['is_teenager'] == 1){
            return ['code' => 201, 'msg' => '已开启青少年模式', 'data' => null];
        }
        if($user_info['is_can_recharge'] != 1){
            return ['code' => 201, 'msg' => '您当前未有转赠权限', 'data' => null];
        }
        $ress = model('api/UserWallet')->get_user_wallet($uid, $user_info['money'], $user_info['integral']);
        if($ress['code'] != 200) {
            return $ress;
        }        

        $map = [];
        $map[] = ['uid','=',$uid];
        $map[] = ['change_type', '=', 17];
        $map[] = ['add_time', '>', time()-5];
        $time_lag = db::name('user_money_log')->where($map)->order('log_id desc')->find();
        if($time_lag){
            return ['code' => 201, 'msg' => '转赠间隔不能少于5秒', 'data' => null];
        }
        Db::startTrans();
        try {
            //扣除积分
            $reslut =  model('admin/User')->change_user_money_by_uid($uid, -$integral, 2, 17, "转赠扣除", $reveive_uid, 0);
            if ($reslut['code'] != 200) {
                Db::rollback();
                return ['code' => 201, 'msg' => $reslut['msg'], 'data' => null];
            }
            //增加积分
            $reslut =  model('admin/User')->change_user_money_by_uid($reveive_uid, $integral, 2, 17, "转赠增加", $uid, 0);
            if ($reslut['code'] != 200) {
                Db::rollback();
                return ['code' => 201, 'msg' => $reslut['msg'], 'data' => null];
            }
            //发送消息开始
            $message_data = [
                'from_uid' => $uid,
                'to_uid' => $reveive_uid,
                'integral' => $integral,
            ];
            model('api/AsyncPushMessage')->store_message($message_data, 1);
            //发送消息结束
            // 提交事务
            Db::commit();
            return ['code' => 200, 'msg' => "转赠成功", 'data' => null];
        } catch (\Exception $e) {
            // 回滚事务
            Db::rollback();
            return ['code' => 201, 'msg' => "转赠失败", 'data' => null];
        }
    }
    //用户转赠列表查询
    public function get_user_give_integral_list($uid,$page,$page_limit){
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $ChangeTypeLable = model('admin/UserMoneyLog')->ChangeTypeLable();
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['money_type', '=', 2];
        $map[]=['change_type','=',17];//用户转赠
        $list = db::name('user_money_log')->field('change_type,change_value,remarks,from_uid,add_time')->where($map)->order('log_id desc')->page($page, $page_limit)->select();
        $map=[];
        $map[] = ['uid', 'in', array_column($list, 'from_uid')];
        $user_data = db::name('user')->field('uid,base64_nick_name,head_pic')->where($map)->column('uid,base64_nick_name,head_pic','uid');
        foreach ($user_data as $a => &$b) {
            $b['nick_name'] = mb_convert_encoding(base64_decode($b['base64_nick_name']), 'UTF-8', 'UTF-8');
            $b['head_pic'] = localpath_to_netpath($b['head_pic']);
        }
        foreach ($list as $k => &$v) {
            $v['change_type_desc'] = $ChangeTypeLable[$v['change_type']];
            $v['from_user_info']=$user_data[$v['from_uid']];
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }

    // 兑换
    public function exchange($uid, $money)
    {
        $user_info = db::name('user')->find($uid);
        if($user_info['is_teenager'] == 1){
            return ['code' => 201, 'msg' => '已开启青少年模式', 'data' => null];
        }
        $exchange_rate = get_system_config('exchange_rate');

        if ($money < 1) {
            return ['code' => 201, 'msg' => '兑换余额必须大于1', 'data' => null];
        }
        if (floor($money) != $money) {
            return ['code' => 201, 'msg' => '兑换余额必须为整数', 'data' => null];
        }
        $ress = model('api/UserWallet')->get_user_wallet($uid, $user_info['money'], $user_info['integral']);
        if($ress['code'] != 200) {
            return $ress;
        }        
        
        
        Db::startTrans();
        try {

            //扣除余额记录
            $change_money = $money;
            $reslut = model('admin/User')->change_user_money_by_uid($uid, -$change_money, 1, 11, "金币兑换扣除余额", $uid, $uid);
            if ($reslut['code'] != 200) {
                Db::rollback();
                return ['code' => 201, 'msg' => '余额不足', 'data' => null];
            }
            //增加金币
            $change_integral = $money * $exchange_rate;
            $reslut = model('admin/User')->change_user_money_by_uid($uid, $change_integral, 2, 12, "余额兑换增加金币", $uid, $uid);
            if ($reslut['code'] != 200) {
                Db::rollback();
                return ['code' => 201, 'msg' => '余额不足', 'data' => null];
            }

            $arr = [];
            $arr['uid'] = $uid;
            $arr['money'] = $change_money;
            $arr['integral'] = $change_integral;
            $arr['add_time'] = time();
            $arr['update_time'] = time();
            $reslut = DB::name('user_exchange')->insert($arr);
            if (!$reslut) {
                Db::rollback();
                return ['code' => 201, 'msg' => '兑换失败', 'data' => null];
            }
            Db::commit();
            return ['code' => 200, 'msg' => '兑换成功', 'data' => null];
        } catch (\Exception $e) {
            // 回滚事务
            Db::rollback();
        }
    }

    // 提现
    public function user_withdrawal($uid, $money, $type)
    {
   
        
        // if($money < 30){
        //     return ['code' => 201, 'msg' => '提现金额不能小于0', 'data' => null];
        // }
        
        $user_info = Db::name('user')->find($uid);
        if($user_info['is_teenager'] == 1){
            return ['code' => 201, 'msg' => '已开启青少年模式', 'data' => null];
        }
   
        
        $ress = model('api/UserWallet')->get_user_wallet($uid, $user_info['money'], $user_info['integral']);
        if($ress['code'] != 200) {
            return $ress;
        }        
        
        
        if($user_info['is_real'] != 1){
            return ['code' => 201, 'msg' => '请先实名认证', 'data' => null];
        }
        
        $real_name = $user_info['real_name'];
        $id_card = $user_info['card_id'];        
        $result = SignContract::getSignStatus($real_name, $id_card);
        if(!(isset($result[2]['status']) && ($result[2]['status']==1))){
            return ['code' => 201, 'msg' => '您尚未签约!', 'data' => null];
        }

        
        $age = getAgeId($user_info['card_id']);
        if(!$age){
            return ['code' => 201, 'msg' => '该身份证号未满18岁', 'data' => null];
        }
        if($type == 1){
            if (empty($user_info['alipay_account'])) {
                return ['code' => 201, 'msg' => '请先绑定支付宝', 'data' => null];
            }
            
            if(trim($user_info['alipay_name']) != trim($real_name)){
                return ['code' => 201, 'msg' => '认证(签约)姓名和支付宝姓名不一致!', 'data' => null];  
            }
      
        }else if($type == 2){
            if (empty($user_info['bank_card_number'])) {
                return ['code' => 201, 'msg' => '请先绑定银行卡', 'data' => null];
            }
         
            //银行卡姓名 和  真实姓名
            if(trim($user_info['bank_user_name']) != trim($real_name)){
                return ['code' => 201, 'msg' => '认证(签约)姓名和银行卡姓名不一致!', 'data' => null];  
            }            
 
        }
        
        $config = model('admin/Config')->get_system_config();
        if ($money < $config['min_withdraw_amount']) {
            return ['code' => 201, 'msg' => '提现金额不能小于' . $config['min_withdraw_amount'], 'data' => null];
        }
        
        //一天最多提现次数
        $today_withdraw_num = get_system_config('today_withdraw_num');
        $user_withdraw_num = db::name('user_withdrawal')->where('uid', $uid)->whereTime('add_time', 'today')->count();
        if($user_withdraw_num >= $today_withdraw_num){
            return ['code' => 201, 'msg' => '用户当天提现次数已达上限', 'data' => null];
        }
        
        // $map = [];
        // $map[] = ['uid', '=', $uid];
        // $map[] = ['status', '=', 2];
        // $user_player_info = Db::name('user_player')->where($map)->find();
        // if (empty($user_player_info)) {
        //     return ['code' => 201, 'msg' => '请先通过陪玩资质认证，即可提现'];
        // }
        
        
        // $map = [];
        // $map[] = ['uid', '=', $uid];
        // $map[] = ['add_time', '>', (time() - 46200)];
        // $user_withdraw_info = Db::name('user_withdrawal')->where($map)->find();
        // if (!empty($user_withdraw_info)) {
        //     return ['code' => 201, 'msg' => '12小时内只能提现一次', 'data' => null];
        // }

        // $withdraw_week = get_system_config('withdraw_week');
        // $withdraw_week = explode(',', $withdraw_week);
        // if (!in_array(date('w'), $withdraw_week)) {
        //     $weekarray = ["日", "一", "二", "三", "四", "五", "六"];
        //     $msg = "请于";
        //     foreach ($withdraw_week as $k => $v) {
        //         $msg .= "周" . $weekarray[$v];
        //     }
        //     $msg .= "进行提现";
        //     return ['code' => 201, 'msg' => $msg, 'data' => null];
        // }

        if ($money > $user_info['money']) {
            return ['code' => 201, 'msg' => '余额不足', 'data' => null];
        }

        Db::startTrans();
        try {
            $order_sn = $this->create_user_withdrawal_order_sn();
            $data = [];
            $data['order_sn'] = $order_sn;
            $data['uid'] = $uid;
            $data['money'] = $money;
            $data['general_money'] =  $money * (1 - $config['user_withdraw_rate']); //到账金额
            $data['type'] = $type;
            if($type == 1){
                $data['real_name'] = $user_info['alipay_name'];
                $data['alipay_account'] =  $user_info['alipay_account'];
            }else if($type == 2){
                $data['real_name'] = $user_info['bank_user_name'];
                $data['bank_card'] = $user_info['bank_card'];
                $data['open_bank'] = $user_info['open_bank'];
                $data['bank_card_number'] = $user_info['bank_card_number'];
            }
            $data['remarke'] =  '';
            $data['status'] = 1;
            $data['deal_time'] = 0;
            $data['add_time'] = time();
            $data['update_time'] = time();
            $data['new_type'] = 2;
            $user_withdrawal_wid = DB::name('user_withdrawal')->insertGetId($data);
            if (!$user_withdrawal_wid) {
                Db::rollback();
                return ['code' => 201, 'msg' => "请重试", 'data' => null];
            }
            
            
            //扣除账户余额
            $reslut = model('admin/User')->change_user_money_by_uid($uid, -$money, 1, 13, "余额提现:" . $order_sn, $uid, $user_withdrawal_wid);
            if ($reslut['code'] != 200) {
                Db::rollback();
                return ['code' => 201, 'msg' => $reslut['msg'], 'data' => null];
            }
            //增加冻结余额
            $reslut = Db::name('user')->where('uid', $user_info['uid'])->setInc('frozen_money', $money);
            if (!$reslut) {
                Db::rollback();
                return ['code' => 201, 'msg' => "请重试", 'data' => null];
            }
            
            //修改提现余额
            $surplus_money_money =  Db::name('user')->where('uid', $user_info['uid'])->value('money');
            DB::name('user_withdrawal')->where(['wid'=>$user_withdrawal_wid])->update(['surplus_money'=>$surplus_money_money]);
       
            // 提交事务
            Db::commit();
            return ['code' => 200, 'msg' => "提现成功", 'data' => null];
        } catch (\Exception $e) {
            // 回滚事务
            Db::rollback();
            return ['code' => 201, 'msg' => "提现失败", 'data' => null];
        }
    }
    
    
    /**
     * 银行卡提现
     * @param $uid
     * @param $money
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function user_withdrawal_bank($uid, $money){
         return ['code' => 201, 'msg' => '请升级app!', 'data' => null];

        if(!preg_match("/^[1-9][0-9]*$/" ,$money) || $money <= 30){
             return ['code' => 201, 'msg' => '提现金额至少30元!', 'data' => null];
        }       
        
        // $w_num = db::name('user_withdrawal')->whereTime('add_time', 'today')->where([['uid','=',$uid],['status','in',[1,2]]])->count('*');
        // if($w_num > 3){
        //     return ['code' => 201, 'msg' => '每天最多提现3笔!', 'data' => null];
        // }        
        
        
        //  return ['code' => 201, 'msg' => '提现维护中,马上回来!', 'data' => null];
        $user_info = Db::name('user')->find($uid);
        if($user_info['is_teenager'] == 1){
            return ['code' => 201, 'msg' => '已开启青少年模式', 'data' => null];
        }
        if($user_info['is_real'] != 1){
            return ['code' => 201, 'msg' => '请先实名认证', 'data' => null];
        }
        $age = getAgeId($user_info['card_id']);
        if(!$age){
            return ['code' => 201, 'msg' => '该身份证号未满18岁', 'data' => null];
        }        
        
    
        if (empty($user_info['is_bind_bank_card']) || ($user_info['is_bind_bank_card']==2) ||  empty($user_info['bank_card_number'])) {
            return ['code' => 201, 'msg' => '请先绑定银行卡!', 'data' => null];
        }
        
        $config = model('admin/Config')->get_system_config();
        // if ($money < $config['min_withdraw_amount']) {
        //     return ['code' => 201, 'msg' => '提现金额不能小于' . $config['min_withdraw_amount'], 'data' => null];
        // }
        
        
        $reslut = model('HuiFu')->check_member_card($uid);
        if($reslut['code'] != 200){
            return ['code' => 201, 'msg' =>$reslut['msg'] , 'data' => null];
        }
        
        if ($money > $user_info['money']) {
            return ['code' => 201, 'msg' => '余额不足', 'data' => null];
        }
      
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['add_time', '>', (time() - 46200)];
        // $user_withdraw_info = Db::name('user_withdrawal')->where($map)->find();
        $user_withdraw_num  = Db::name('user_withdrawal')->where($map)->count("*");
        if($user_withdraw_num > 3){
             return ['code' => 201, 'msg' => '12小时内最多可提现3次', 'data' => null];
        }
        
        // if (!empty($user_withdraw_info)) {
        //     return ['code' => 201, 'msg' => '12小时内只能提现一次', 'data' => null];
        // }        
        
    
        if($money>10000){
            return ['code' => 201, 'msg' => '最大提现金额不能超过10000元', 'data' => null];
        }
        
        
        Db::startTrans();
        try {
            $order_sn = $this->create_user_withdrawal_order_sn();
            $data = [];
            $data['order_sn'] = $order_sn;
            $data['uid'] = $uid;
            $data['money'] = $money;
            $data['general_money'] =  $money * (1 - $config['bank_user_withdraw_rate']); //到账金额
//            $data['real_name'] = $user_info['alipay_name'];
//            $data['alipay_account'] =  $user_info['alipay_account'];

            $data['bank_card_name'] = $user_info['bank_card_name'];
            $data['bank_card_number'] = $user_info['bank_card_number'];
            $data['bank_user_name'] = $user_info['bank_user_name'];
            $data['bank_cert_id'] = $user_info['bank_cert_id'];
            $data['bank_tel_no'] = $user_info['bank_tel_no'];
            $data['withd_type'] = 2;  //银行卡提现
            $data['type'] = 2;  //银行卡提现
            $data['remarke'] =  '';
            $data['status'] = 1;
            $data['deal_time'] = 0;
            $data['add_time'] = time();
            $data['update_time'] = time();
            $user_withdrawal_wid = DB::name('user_withdrawal')->insertGetId($data);
            if (!$user_withdrawal_wid) {
                Db::rollback();
                return ['code' => 201, 'msg' => "请重试", 'data' => null];
            }
            
        
            //扣除账户余额
            $reslut = model('admin/User')->change_user_money_by_uid($uid, -$money, 1, 13, "余额提现:" . $order_sn, $uid, $user_withdrawal_wid);
            if ($reslut['code'] != 200) {
                Db::rollback();
                return ['code' => 201, 'msg' => $reslut['msg'], 'data' => null];
            }
            //增加冻结余额
            $reslut = Db::name('user')->where('uid', $user_info['uid'])->setInc('frozen_money', $money);
            if (!$reslut) {
                Db::rollback();
                return ['code' => 201, 'msg' => "请重试", 'data' => null];
            }
            // 提交事务
            Db::commit();
            return ['code' => 200, 'msg' => "提现成功", 'data' => null];
        } catch (\Exception $e) {
            // 回滚事务
            Db::rollback();
            // halt($e);
            return ['code' => 201, 'msg' => "提现失败", 'data' => null];
        }
    }    
    
    
    public function binding_zfb($uid, $alipay_name, $alipay_account)
    {

        if (empty($alipay_name)) {
            return ['code' => 201, 'msg' => '真实姓名必须', 'data' => null];
        }
        if (empty($alipay_account)) {
            return ['code' => 201, 'msg' => '支付宝账号必须', 'data' => null];
        }
        $user_info = db::name('user')->find($uid);
        if (!empty($user_info['alipay_name']) || !empty($user_info['alipay_account'])) {
            // return ['code' => 201, 'msg' => '您已绑定支付宝信息', 'data' => null];
        }
        //该支付宝是否已被绑定
        $where = [];
        $where[] = ['alipay_account', '=', $alipay_account];
        $where[] = ['uid', 'neq', $uid];
        $user_alipay_account = db::name('user')->where($where)->count();
        if($user_alipay_account > 2){
            return ['code' => 201, 'msg' => '该支付宝已被绑定3个账号 不能再次绑定', 'data' => null];
        }
        
        $map = [];
        $map[] = ['uid', '=', $uid];
        //调用第三方实名认证接口
        $data = [];
        $data['alipay_name'] = $alipay_name;
        $data['alipay_account'] = $alipay_account;
        $data['update_time'] = time();
        $reslut = Db::name('user')->where($map)->update($data);
        if ($reslut) {
            return ['code' => 200, 'msg' => '绑定成功', 'data' => null];
        } else {
            return ['code' => 201, 'msg' => '绑定失败', 'data' => null];
        }
    }
    
    public function binding_bank_card($uid, $bank_user_name, $bank_card, $open_bank, $bank_card_number)
    {

        if (empty($bank_user_name)) {
            return ['code' => 201, 'msg' => '真实姓名必须', 'data' => null];
        }
        if (empty($bank_card_number)) {
            return ['code' => 201, 'msg' => '银行卡号必须', 'data' => null];
        }
        if (empty($bank_card)) {
            return ['code' => 201, 'msg' => '所属银行必须', 'data' => null];
        }
        if (empty($open_bank)) {
            return ['code' => 201, 'msg' => '开户行必须', 'data' => null];
        }
        $user_info = db::name('user')->find($uid);
        if (!empty($user_info['bank_user_name']) || !empty($user_info['bank_card_number'])) {
            // return ['code' => 201, 'msg' => '您已绑定银行卡信息', 'data' => null];
        }
        $map = [];
        $map[] = ['uid', '=', $uid];
        //调用第三方实名认证接口
        $data = [];
        $data['bank_user_name'] = $bank_user_name;
        $data['bank_card_number'] = $bank_card_number;
        $data['bank_card'] = $bank_card;
        $data['open_bank'] = $open_bank;
        $data['update_time'] = time();
        $reslut = Db::name('user')->where($map)->update($data);
        if ($reslut) {
            return ['code' => 200, 'msg' => '绑定成功', 'data' => null];
        } else {
            return ['code' => 201, 'msg' => '绑定失败', 'data' => null];
        }
    }
    
    
    /**
     * 绑定银行卡
     * @param $bank_card_number   //银行卡号
     * @param $bank_user_name      //银行卡姓名
     * @param $bank_cert_id       //银行卡对应身份证号
     * @param $bank_tel_no        //银行卡电话
     * @param $bank_card_name      //银行卡名字
     * @return array
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
//     public function binding_bank_card($uid,$bank_card_number, $bank_user_name, $bank_cert_id, $bank_tel_no,$bank_card_name)
//     {
        
//         if(empty($bank_card_name)){
//             return ['code' => 201, 'msg' => '请填写银行卡所属银行!', 'data' => null];
//         }
//         if (empty($bank_card_number)) {
//             return ['code' => 201, 'msg' => '请填写银行卡卡号!', 'data' => null];
//         }
//         if (empty($bank_user_name)) {
//             return ['code' => 201, 'msg' => '请填写银行卡所属真实姓名!', 'data' => null];
//         }
//         if (empty($bank_cert_id)) {
//             return ['code' => 201, 'msg' => '请填写银行卡身份证号', 'data' => null];
//         }
//         if (empty($bank_tel_no)) {
//             return ['code' => 201, 'msg' => '请填写银行卡绑定手机号', 'data' => null];
//         }
//         $user_info = db::name('user')->find($uid);
//         if(empty($user_info)){
//             return ['code' => 201, 'msg' => '被绑定对象不存在!', 'data' => null];
//         }
//         //进行换绑流程
//         if($user_info['is_bind_bank_card']==1 && !empty($user_info['bind_bank_card_id'])){
//             if(!(($user_info['bank_card_number']==$bank_card_number) && ($user_info['bank_tel_no'] == $bank_tel_no))){
//                 //进行换绑
//                 $result = $this->change_bank_card($uid,$bank_card_number, $bank_user_name, $bank_cert_id, $bank_tel_no,$bank_card_name);
//                 return   $result;
//             }else{
//                 return ['code' => 201, 'msg' => '您已经绑定过银行卡了!', 'data' => null];
//             }
//         }
// //        if (!empty($user_info['bank_card_number']) && !empty($user_info['bank_cert_id'])) {
// //            // return ['code' => 201, 'msg' => '您已绑定银行卡信息', 'data' => null];
// //        }

//         $data = [];

//         //1：创建支付对象[创建过的对象 不需要重复创建]
//         if($user_info['is_bank_member_create'] == 2){
//             // $memberBankCreate = new MemberCreate();
//             // $createMemberResult =  $memberBankCreate->create($user_info['uid'],$bank_user_name);
         
//             $createMemberResult = model('HuiFu')->member_create($user_info['uid'],$bank_user_name);
//             if($createMemberResult['status'] != 'succeeded'){
//                 return ['code' => 201, 'msg' =>  $createMemberResult['error_msg'], 'data' => null];
//             }
//             //支付对象已经产生
//             Db::name('user')->where(['uid'=>$uid])->update(['is_bank_member_create'=>1,'update_time'=>time()]);
//         }

//         //2：绑定银行卡[还未绑定银行卡]
//         if(empty($user_info['bind_bank_card_id'])){
//             $accountInfo = [
//                 'card_id'=>$bank_card_number,   //银行卡卡号
//                 'card_name'=>$bank_user_name,     //银行卡姓名
//                 'cert_id' =>$bank_cert_id,  //银行卡身份证号
//                 'tel_no' => $bank_tel_no, //银行卡手机号
//             ];
//             // $bindCard = new BindCard();
//             // $bindCardResult = $bindCard->bind_card($user_info['uid'],$accountInfo);
//             $bindCardResult = model('HuiFu')->bind_card($user_info['uid'],$accountInfo);
//             if($bindCardResult['status'] !='succeeded'){
//                 return ['code' => 201, 'msg' => $bindCardResult['error_msg'], 'data' => null];
//             }
//             //生成结算对象id
//             if(empty($bindCardResult['id'])){
//                 return ['code' => 201, 'msg' => '获取不到银行卡创建id!', 'data' => null];
//             }
//             $data['bind_bank_card_id'] = $bindCardResult['id'];
//         }
//         $data['bank_card_name'] = $bank_card_name;
//         $data['bank_card_number'] = $bank_card_number;
//         $data['bank_user_name'] = $bank_user_name;
//         $data['bank_cert_id'] = $bank_cert_id;
//         $data['bank_tel_no'] = $bank_tel_no;
//         $data['update_time'] = time();
//         $data['is_bank_member_create'] = 1;
//         $data['is_bind_bank_card'] = 1;
//         $map = [];
//         $map[] = ['uid', '=', $uid];
//         $reslut = Db::name('user')->where($map)->update($data);
//         if ($reslut) {
//             return ['code' => 200, 'msg' => '绑定成功', 'data' => null];
//         } else {
//             return ['code' => 201, 'msg' => '绑定失败', 'data' => null];
//         }
//     }  
    
    
    /**
     * 换绑银行卡
     * @param $uid
     * @param $bank_card_number
     * @param $bank_user_name
     * @param $bank_cert_id
     * @param $bank_tel_no
     * @param $bank_card_name
     */
    // public function change_bank_card($uid,$bank_card_number, $bank_user_name, $bank_cert_id, $bank_tel_no,$bank_card_name){
    //     //1：删除原有绑定的银行卡
    //     $user_info = db::name('user')->find($uid);
    //     // $deleteCard = new DeleteCard();
    //     // $result    = $deleteCard->delete_card($uid,$user_info['bind_bank_card_id']);
        
    //     $result = model('HuiFu')->delete_card($uid,$user_info['bind_bank_card_id']);
    //     if($result['status'] !== 'succeeded'){
    //         return ['code' => 200, 'msg' => $result['error_msg'], 'data' => null];
    //     }else{
    //         //1：清除原先绑定的银行卡信息
    //         $data['bank_card_name'] = '';
    //         $data['bank_card_number'] = '';
    //         $data['bank_user_name'] = '';
    //         $data['bank_cert_id'] = '';
    //         $data['bank_tel_no'] = '';
    //         $data['update_time'] = time();
    //         $data['bind_bank_card_id'] = '';  //清除绑定对象id
    //         $data['is_bind_bank_card'] = 2;   //未绑定银行卡
    //         $map = [];
    //         $map[] = ['uid', '=', $uid];
    //         $reslut = Db::name('user')->where($map)->update($data);
    //     }
    //     //2：在度创建银行对象
    //     $data = [];
    //     $accountInfo = [
    //         'card_id'=>$bank_card_number,   //银行卡卡号
    //         'card_name'=>$bank_user_name,     //银行卡姓名
    //         'cert_id' =>$bank_cert_id,  //银行卡身份证号
    //         'tel_no' => $bank_tel_no, //银行卡手机号
    //     ];
    //     // $bindCard = new BindCard();
    //     // $bindCardResult = $bindCard->bind_card($user_info['uid'],$accountInfo);
        
    //     $bindCardResult = model('HuiFu')->bind_card($user_info['uid'],$accountInfo);
    //     if($bindCardResult['status'] !='succeeded'){
    //         return ['code' => 201, 'msg' => $bindCardResult['error_msg'], 'data' => null];
    //     }
    //     //生成结算对象id
    //     if(empty($bindCardResult['id'])){
    //         return ['code' => 201, 'msg' => '获取不到银行卡创建id!', 'data' => null];
    //     }
    //     $data['bind_bank_card_id'] = $bindCardResult['id'];
    //     //3：修改数据库信息
    //     $data['bank_card_name'] = $bank_card_name;
    //     $data['bank_card_number'] = $bank_card_number;
    //     $data['bank_user_name'] = $bank_user_name;
    //     $data['bank_cert_id'] = $bank_cert_id;
    //     $data['bank_tel_no'] = $bank_tel_no;
    //     $data['update_time'] = time();
    //     $data['is_bank_member_create'] = 1;
    //     $data['is_bind_bank_card'] = 1;
    //     $map = [];
    //     $map[] = ['uid', '=', $uid];
    //     $reslut = Db::name('user')->where($map)->update($data);
    //     if ($reslut) {
    //         return ['code' => 200, 'msg' => '绑定成功', 'data' => null];
    //     } else {
    //         return ['code' => 201, 'msg' => '绑定失败', 'data' => null];
    //     }
    // }     
    
    
    //生成订单号
    private function create_user_withdrawal_order_sn()
    {
        $order_sn = 'TX' . date('YmdHis') . mt_rand(10000, 99999);
        $map = [];
        $map[] = ['order_sn', '=', $order_sn];
        $reslut = db::name('user_withdrawal')->where($map)->find();
        if (empty($reslut)) {
            return $order_sn;
        } else {
            $this->create_user_withdrawal_order_sn();
        }
    }

    public function get_user_withdrawal_info($uid)
    {
        $config = get_uncache_system_config();
        $user_info = DB::name('user')->field(['alipay_name', 'alipay_account', 'integral', 'money','bank_user_name', 'bank_card', 'open_bank','is_bind_bank_card','bank_card_name','bank_card_number','bank_user_name','bank_cert_id','bank_tel_no'])->find($uid);
        // dump($user);die;
        $user_info['is_bingd_alipay'] = 1; //已绑定
        if (empty($user_info['alipay_name']) || empty($user_info['alipay_name'])) {
            $user_info['is_bingd_alipay']; //未绑定
        }
        $user_info['withdraw_rate'] = round((1 - $config['user_withdraw_rate']),2);
        $user_info['user_withdraw_rate'] = $config['user_withdraw_rate'];
        return ['code' => 200, 'msg' => '获取成功', 'data' => $user_info];
    }

    // 提现记录
    public function get_user_withdrawal_list($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 30 ? $page_limit : 30;
        $list = Db::name('user_withdrawal')->field('order_sn, money,general_money,real_name,alipay_account,bank_card_number,bank_card,open_bank,remarke,status,add_time')->where('uid', $uid)->order('wid', 'desc')->page($page, $page_limit)->select();
        foreach ($list as $key => &$v) {
            if ($v['status'] == 1) {
                $v['status_desc'] = '审核中';
            } elseif ($v['status'] == 2) {
                $v['status_desc'] = '已提现';
            } elseif ($v['status'] == 3) {
                $v['status_desc'] = '已拒绝' . ':' . $v['remarke'];
            }
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $list];
    }

    // 兑换记录
    public function exchange_log($uid, $page, $page_limit)
    {
        $page = intval($page);
        $page_limit = $page_limit < 10 ? $page_limit : 10;
        $data = DB::name('user_exchange')->where('uid', $uid)->order('eid', 'desc')->page($page, $page_limit)->select();
        foreach ($data as $key => &$v) {
            $v['add_time'] = date('Y-m-d H:i:s', $v['add_time']);
        }
        return ['code' => 200, 'msg' => '查询成功', 'data' => $data];
    }
    //上传用户相册
    public function add_user_albums($uid, $image)
    {
        $image_list = explode(',', $image);
        $insert_data = [];
        foreach ($image_list as $k => $v) {
            if (!empty($v)) {
                $data = [];
                $data['uid'] = $uid;
                $data['image'] = $v;
                $data['add_time'] = time();
                $data['update_time'] = time();
                $insert_data[] = $data;
            } else {
                return ['code' => 201, 'msg' => '图片格式错误', 'data' => null];
            }
        }
        if (!empty($insert_data)) {
            $reslut = db::name('user_albums')->insertAll($insert_data);
            if (!$reslut) {
                return ['code' => 201, 'msg' => '添加失败', 'data' => null];
            } else {
                return  ['code' => 200, 'msg' => '添加成功', 'data' => null];
            }
        }
    }
    //上传用户相册
    public function delete_user_albums($uid, $aid)
    {
        $map = [];
        $map[] = ['aid', '=', $aid];
        $map[] = ['uid', '=', $uid];
        $data = [];
        $data['is_delete'] = 2;
        $data['delete_time'] = time();
        $data['update_time'] = time();
        $reslut = db::name('user_albums')->where($map)->update($data);
        if (!$reslut) {
            return ['code' => 201, 'msg' => '移除失败', 'data' => null];
        } else {
            return  ['code' => 200, 'msg' => '移除成功', 'data' => null];
        }
    }

    //获取星座
    public function get_user_constellation($birthday)
    {
        $birthday = date('Y-m-d', strtotime($birthday));
        if (empty($birthday)) {
            return ['code' => 201, 'msg' => '生日日期格式非法', 'data' => null];
        }
        $birthday_arr = explode('-', $birthday);
        $month = $birthday_arr[1];
        $day = $birthday_arr[2];
        $xingzuo = '';
        // 检查参数有效性
        if ($month < 1 || $month > 12 || $day < 1 || $day > 31) {
            return $xingzuo;
        }

        if (($month == 1 && $day >= 20) || ($month == 2 && $day <= 18)) {
            $xingzuo = "水瓶座";
        } else if (($month == 2 && $day >= 19) || ($month == 3 && $day <= 20)) {
            $xingzuo = "双鱼座";
        } else if (($month == 3 && $day >= 21) || ($month == 4 && $day <= 19)) {
            $xingzuo = "白羊座";
        } else if (($month == 4 && $day >= 20) || ($month == 5 && $day <= 20)) {
            $xingzuo = "金牛座";
        } else if (($month == 5 && $day >= 21) || ($month == 6 && $day <= 21)) {
            $xingzuo = "双子座";
        } else if (($month == 6 && $day >= 22) || ($month == 7 && $day <= 22)) {
            $xingzuo = "巨蟹座";
        } else if (($month == 7 && $day >= 23) || ($month == 8 && $day <= 22)) {
            $xingzuo = "狮子座";
        } else if (($month == 8 && $day >= 23) || ($month == 9 && $day <= 22)) {
            $xingzuo = "处女座";
        } else if (($month == 9 && $day >= 23) || ($month == 10 && $day <= 23)) {
            $xingzuo = "天秤座";
        } else if (($month == 10 && $day >= 24) || ($month == 11 && $day <= 22)) {
            $xingzuo = "天蝎座";
        } else if (($month == 11 && $day >= 23) || ($month == 12 && $day <= 21)) {
            $xingzuo = "射手座";
        } else if (($month == 12 && $day >= 22) || ($month == 1 && $day <= 19)) {
            $xingzuo = "摩羯座";
        }
        return ['code' => 200, 'msg' => '获取成功', 'data' => $xingzuo];
    }
    
    //退出登录
    public function log_out($uid){
        $user_info = db::name('user')->find($uid);
        if($user_info){
            $map = [];
            $map[] = ['uid', '=', $uid];
            $data = [];
            $data['login_token'] = '';
          db::name('user')->where($map)->update($data); 
        }
        return ['code' => 200, 'msg' => '退出成功', 'data' => null];
    }
    
    //注销账号
    public function logout_user_name($uid){
        $user_info = db::name('user')->find($uid);
        if(!$user_info){
            return ['code' => 201, 'msg' => '参数错误', 'data' => null];
        }
        if($user_info['is_teenager'] == 1){
            return ['code' => 201, 'msg' => '青少年模式已开启', 'data' => null];
        }
        
        //注册时间是否超过七天
        $reg_time = $user_info['add_time'] + (60*60*24*7);
        $now_time = time();
        if($now_time < $reg_time){
            return ['code' => 201, 'msg' => '注册七天内无法注销', 'data' => null];
        }
        
        //背包里是否还有礼物
        $map = [];
        $map[] = ['uid', '=', $uid];
        $map[] = ['is_tester', '=', 1];
        $map[] = ['num', '>', 0];
        $user_gift_pack = db::name('user_gift_pack')->where($map)->select();
        if(!empty($user_gift_pack)){
            return ['code' => 201, 'msg' => '背包中尚且有礼物无法注销', 'data' => null];
        }
        
        if($user_info['money'] >= 100 || $user_info['integral'] >= 100){
            return ['code' => 201, 'msg' => '当前用户金币或者钻石大于100，无法注销', 'data' => null];
        }
        
        Db::startTrans();
        try {
            $update = [];
            $update['login_status'] = 3;
            $update['is_online'] = 2;
            $update['user_name'] = $user_info['user_name'].'zx'.time();
            
            if(!empty($user_info['alipay_name'])){
                $update['alipay_name'] = $user_info['alipay_name'].'zx'.time();
            }
            
            if(!empty($user_info['alipay_account'])){
                $update['alipay_account'] = $user_info['alipay_account'].'zx'.time();
            }
            
            
            //身份证号注销
            if(!empty($user_info['card_id'])){
                 $update['card_id'] = $user_info['card_id'].'zx';
            }
      
            // $update['wx_openid'] = $user_info['wx_openid'].'zx'.$user_info['uid'];
            // $update['qq_openid'] = $user_info['qq_openid'].'zx'.$user_info['uid'];
            $update['login_token'] = '';
            $update['update_time'] = time();
            $reslut = db::name('user')->where('uid', $uid)->update($update);
            if(!$reslut){
                Db::rollback();
                return ['code' => 201, 'msg' => '注销失败', 'data' => null];
            }
            
            //用户是否已有所在房间
            $user_room_visitor = db::name('room_visitor')->where('uid', $uid)->find();
            if($user_room_visitor){
                model('api/room')->quit_room($uid, $user_room_visitor['rid']);//踢出房间
            }
            
            Db::commit();
            $push_user_data = [];
            $push_user_data['uid'] = $uid;
            //推送信息
            $push_data = [];
            $push_data['code'] = 311;
            $push_data['msg'] = "账号注销";
            $push_data['data'] = $push_user_data;
            model('api/WebSocketPush')->send_to_one($uid, $push_data);
            return ['code' => 200, 'msg' => '注销成功', 'data' => null];
        } catch (\Exception $e) {
            // 回滚事务
            dump($e);
            Db::rollback();
            return ['code' => 201, 'msg' => '注销失败', 'data' => null];
        }
    }
    
    //是否进厅隐身
    public function user_is_room_hiding($uid, $is_room_hiding){
        $user_info = db::name('user')->find($uid);
        if(!$user_info){
            return ['code' => 201, 'msg' => '参数错误', 'data' => null];
        }
        if($user_info['nobility_id'] < 6){
            return ['code' => 201, 'msg' => '需要国王爵位', 'data' => null];
        }
        
        $data = [];
        $data['is_room_hiding'] = $is_room_hiding;
        
        $update = [];
        $update['is_room_hiding'] = $is_room_hiding;
        $update['update_time'] = time();
        $reslut = db::name('user')->where('uid', $uid)->update($update);
        if ($reslut) {
            return ['code' => 200, 'msg' => '成功', 'data' => $data];
        } else {
            return ['code' => 201, 'msg' => '失败', 'data' => null];
        }
    }
    
    //位置信息开关
    public function options_is_open_address($uid, $is_open_address){
        $user_info = db::name('user')->find($uid);
        if(!$user_info){
            return ['code' => 201, 'msg' => '参数错误', 'data' => null];
        }
        
        $data = [];
        $data['is_open_address'] = $is_open_address;
        
        $update = [];
        $update['is_open_address'] = $is_open_address;
        $update['update_time'] = time();
        $reslut = db::name('user')->where('uid', $uid)->update($update);
        if ($reslut) {
            return ['code' => 200, 'msg' => '成功', 'data' => $data];
        } else {
            return ['code' => 201, 'msg' => '失败', 'data' => null];
        }
    }
    
    
    public function check_user_is_real($uid)
    {
        $is_real = Db::name('user')->where('uid', $uid)->value('is_real');
        $data['is_real'] = empty($is_real) ? 2 : $is_real;
        return ['code' => 200, 'msg' => '已实名', 'data' => $data];
    }
    
    
    //客服信息
    public function  get_kf_message(){
         $data =  db::name('support_staff')->field("id,image,content,contents")->order('id','asc')->select();
         foreach($data as &$v){
             $v['image'] = localpath_to_netpath($v['image']);
         } 
         return ['code' => 200, 'msg' => 'success', 'data' => $data];
    }  
    

    //用户提现方式
    public  function get_user_withdrawal_detail($uid,$start="",$end="",$page,$page_limit){
          $where = [];
          $where[] = ['uw.uid','=',$uid];
          //提现数据大于  9月26号
          $where[] = ['uw.add_time','>=',1727280000];
          if(!empty($start)){
              $start = strtotime($start. " 00:00");
              $where[] = ['uw.add_time','>=',$start];
          }
          
          if(!empty($end)){
              $end = strtotime($end . " 23:59:59");
              $where[] = ['uw.add_time','<=',$end];
          }
          
          
          $user_withdraw_detail = db::name('user_withdrawal')
                ->alias('uw')
                ->field('uw.wid,uw.type,uw.general_money,uw.money,uw.surplus_money,uw.withd_type,uw.status,deal_type,add_time')
                ->where($where)
                ->order(['wid'=>'desc'])
                ->page($page,$page_limit)
                ->select();
         foreach ($user_withdraw_detail as &$v){
             //线下提现
             if($v['deal_type']  == 2){
                //   if(in_array($v['status'],[4,5])){
                //         $v['status'] = 1;
                //   }elseif($v['status'] == 6){
                //         $v['status'] = 2;
                //   }
                  if(in_array($v['status'],[4,5,6])){
                        $v['status'] = 2;
                  }            
             }
         }       
         $with_money =   db::name('user_withdrawal')
                ->alias('uw')
                ->where($where)
                // ->whereRaw("(uw.deal_type=1 and uw.status=2) or (uw.deal_type=2 and uw.status=6)")
                ->whereRaw("uw.status  in (2,4,5,6)")
                ->sum('general_money');
         return ['code' => 200, 'msg' => 'success', 'data' => ['detail'=>$user_withdraw_detail,'all'=>$with_money]];
    }    
    
    
    //用户提现方式
    public  function  get_one_withdrawal_detail($uid,$wid){
       $with_info =  db::name('user_withdrawal')
                ->alias('uw')
                ->field('uw.wid,uw.type,uw.general_money,uw.money,uw.surplus_money,server_money,uw.withd_type,uw.status,deal_type,add_time,remarke,alipay_account,bank_card_number,deal_type')
                ->where(['uid'=>$uid,'wid'=>$wid])
                ->find();
        if(empty($with_info)){
             return ['code' => 201, 'msg' => '提现不存在!', 'data' => null];
        }
        if($with_info['type'] == 1){
            $with_info['account'] = $with_info['alipay_account'];
        }
        if($with_info['type'] == 2){
            $with_info['account'] = $with_info['bank_card_number'];
        }

        if($with_info['deal_type'] == 2){
            if(in_array($with_info['status'],[4,5,6])){
                    $with_info['status'] = 2;
            }  
        }
        
        $with_info['server_money'] =  del_coin_num($with_info['money'] - $with_info['general_money'],2);
        unset($with_info['alipay_account'],$with_info['bank_card_number'],$with_info['deal_type']);
        return ['code' => 200, 'msg' => 'success', 'data' => $with_info];
    }
    
    
}