";
        var_dump($result);
    }

    //获取通用策略限制
    public function get_strategy_setting()
    {
        $params = $this->request->post();
        if(isset($params['exchange_id'])) $exchangeid = $params['exchange_id'];
        else $exchangeid = 1;
        if($exchangeid == 1) {
            $data = [
                'bc_min_limit' => $this->auth->bc_min_limit
            ];
        }else if($exchangeid == 2){
            $data = [
                'bc_min_limit' => $this->auth->bc_min_limit_ba
            ];
        }else{
            $data = [
                'bc_min_limit' => 0.000000
            ];
        }
        $this->success('ok',$data);
    }

    //设置补仓余额最低限制，低于不进行补仓
    public function setbc_limit()
    {
        $params = $this->request->post();
        if(!isset($params['bc_min_limit']) || empty($params['bc_min_limit']) || !is_numeric($params['bc_min_limit']))
        {
            $this->error(__('请输入设置的补仓最低余额限制'));
        }
        if(isset($params['exchange_id'])) $exchangeid = $params['exchange_id'];
        else $exchangeid = 1;
        if($exchangeid == 1) {
            $ret = Db::name('user')
                ->where('id',$this->auth->id)
                ->update(['bc_min_limit' => $params['bc_min_limit'],'updatetime'=>time()]);
        }else if($exchangeid == 2){
            $ret = Db::name('user')
                ->where('id',$this->auth->id)
                ->update(['bc_min_limit_ba' => $params['bc_min_limit'],'updatetime'=>time()]);
        }else{
            $ret = false;
        }

        if($ret){
            $this->success(__('提交成功'));
        }else{
            $this->error(__('系统繁忙'));
        }
    }

    //获取排行榜
    public function get_paihang()
    {
        $params = $this->request->post();
        $today = strtotime(date('Y-m-d'));
        if(isset($params['exchange_id'])) $exchangeid = $params['exchange_id'];
        else $exchangeid = 1;
        if($params['type'] == 1)  //日收益
        {
            $data = Db::name('app_ai_user_income a')
                ->field('a.num as income,a.jstime,b.nickname,b.avatar,a.pcnum,a.income_per')
                ->join('user b','b.id=a.user_id','left')
                ->where('a.jstime',date('Y-m-d'))
                ->where('a.exchange_id',$exchangeid)
                ->order('a.num','desc')->limit(10)->select();
            foreach ($data as $key => $value)
            {
                $value['avatar'] = Config::get('site.image_url').$value['avatar'];
                $data[$key] = $value;
            }
        }else if($params['type'] == 2)  //总收益
        {
            $data = Db::name('app_ai_user_income_all a')
                ->field('a.income,b.nickname,b.avatar,a.pcnum,a.income_per')
                ->where('a.income','>',0)
                ->join('user b','b.id=a.user_id','left')
                ->where('a.exchange_id',$exchangeid)
                ->order('a.income','desc')->limit(10)->select();
            foreach ($data as $key => $value)
            {
                $value['avatar'] = Config::get('site.image_url').$value['avatar'];
                $data[$key] = $value;
            }
        }else{    //币种
            $today = strtotime( date('Y-m-d'));
            $data = Db::name('app_ai_strategy_order a')
                ->field('count(a.id) as num,b.coinname,b.id as coin_id,b.image,c.image as exchange_image')
                ->join('app_ai_coin b','b.id=a.coin_id','left')
                ->join('app_ai_exchange c','c.id=b.exchange_id','left')
                ->where('a.type',2)
                ->where('a.createtime','>',$today)
                ->where('b.exchange_id',$exchangeid)
                ->group('a.coin_id')
                ->limit('50')
                ->order('num','desc')
                ->select();
            foreach ($data as $key=>$value)
            {
                $value['image'] = Config::get('site.image_url').$value['image'];
                $value['exchange_image'] = Config::get('site.image_url').$value['exchange_image'];
                $strategy_order = Db::name('app_ai_strategy_order')
                    ->where('coin_id',$value['coin_id'])
                    ->where('type','2')
                    ->where('createtime','>',$today)
                    ->order('id','desc')->find();
                $value['last_time'] = date('H:i:s',$strategy_order['createtime']);
                $data[$key] = $value;
            }
        }
        $this->success('ok',$data);
    }

}