<?php

namespace addons\webman\controller;

use addons\webman\Admin;
use addons\webman\model\Channel;
use addons\webman\model\PhoneSmsLog;
use addons\webman\model\Player;
use addons\webman\model\PlayerBank;
use addons\webman\model\PlayerChipRecord;
use addons\webman\model\PlayerDeliveryRecord;
use addons\webman\model\PlayerExtend;
use addons\webman\model\PlayerLevel;
use addons\webman\model\PlayerMoneyEditLog;
use addons\webman\model\PlayerPlatformCash;
use addons\webman\model\PlayerRechargeRecord;
use addons\webman\model\PlayerRegisterRecord;
use addons\webman\model\PlayerTag;
use addons\webman\model\PlayerWalletTransfer;
use addons\webman\model\PlayerWithdrawRecord;
use ExAdmin\ui\component\common\Button;
use ExAdmin\ui\component\common\Html;
use ExAdmin\ui\component\common\Icon;
use ExAdmin\ui\component\form\Form;
use ExAdmin\ui\component\grid\avatar\Avatar;
use ExAdmin\ui\component\grid\card\Card;
use ExAdmin\ui\component\grid\grid\Actions;
use ExAdmin\ui\component\grid\grid\Editable;
use ExAdmin\ui\component\grid\grid\Filter;
use ExAdmin\ui\component\grid\grid\Grid;
use ExAdmin\ui\component\grid\statistic\Statistic;
use ExAdmin\ui\component\grid\tabs\Tabs;
use ExAdmin\ui\component\grid\tag\Tag;
use ExAdmin\ui\component\grid\ToolTip;
use ExAdmin\ui\component\layout\layout\Layout;
use ExAdmin\ui\component\layout\Row;
use ExAdmin\ui\response\Msg;
use ExAdmin\ui\response\Response;
use ExAdmin\ui\support\Container;
use ExAdmin\ui\support\Request;
use support\Cache;
use support\Db;

/**
 * 玩家
 */
class PlayerController
{
    protected $model;

    protected $playerTag;

    private $withdraw;

    private $recharge;

    private $playerChipRecord;

    protected $playerDeliveryRecord;

    protected $playerLevel;

    public function __construct()
    {
        $this->model = plugin()->webman->config('database.player_model');
        $this->playerTag = plugin()->webman->config('database.player_tag_model');
        $this->withdraw = plugin()->webman->config('database.player_withdraw_record_model');
        $this->recharge = plugin()->webman->config('database.player_recharge_record_model');
        $this->playerChipRecord = plugin()->webman->config('database.player_chip_record_model');
        $this->playerDeliveryRecord = plugin()->webman->config('database.player_delivery_record_model');
        $this->playerLevel = plugin()->webman->config('database.player_level_model');
    }

    /**
     * 玩家
     * @auth true
     * @return Grid
     */
    public function index(): Grid
    {
        return Grid::create(new $this->model(), function (Grid $grid) {
            $grid->title(admin_trans('player.title'));
            $requestFilter = Request::input('ex_admin_filter', []);
            if (!empty($requestFilter)) {
                if (isset($requestFilter['created_at_start']) && !empty($requestFilter['created_at_start'])) {
                    $grid->model()->where('player.created_at', '>=', $requestFilter['created_at_start']);
                }
                if (isset($requestFilter['created_at_end']) && !empty($requestFilter['created_at_end'])) {
                    $grid->model()->where('player.created_at', '<=', $requestFilter['created_at_end']);
                }
            }
            $activePlayer = Request::input('active_player') ?? null;
            if (!empty($activePlayer)){
                $grid->model()->whereHas('the_last_player_login_record', function ($query) use ($activePlayer) {
                    if ($activePlayer == 1){
                        $query->whereDate('created_at', date('Y-m-d'));
                    } else {
                        $query->whereYear('created_at', date('Y'))
                            ->whereMonth('created_at', date('m'));
                    }
                });
            }
            $subQuery = PlayerDeliveryRecord::select('player_id', Db::raw('sum(amount) as amount'))
                ->whereNotIn('type', [1,2,3,4,5,9,10])
                ->groupBy('player_id');
            $grid->model()->with(['player_register_record', 'channel', 'the_last_player_login_record'])
                ->select([
                    'player.*',
                    'player_extend.recharge_amount',
                    'player_extend.withdraw_amount',
                    'player_platform_cash.money as money',
                    'record.amount as present_coins'
                ])
                ->leftjoin('player_extend', 'player.id', '=', 'player_extend.player_id')
                ->leftjoin('player_platform_cash', 'player.id', '=', 'player_platform_cash.player_id')
                ->leftjoinSub($subQuery, 'record', function ($join) {
                    $join->on('player.id', '=', 'record.player_id');
                })
                ->orderBy('player.id', 'desc');
            $grid->autoHeight();
            $grid->bordered(true);
            $grid->column('id', admin_trans('player.fields.id'))->fixed(true)->align('center');
            $grid->column('name', admin_trans('player.fields.name'))->display(function ($val, Player $data) {
                $image = $data->avatar ? Avatar::create()->src(is_numeric($data->avatar) ? config('def_avatar.' . $data->avatar) : $data->avatar) : Avatar::create()->icon(Icon::create('UserOutlined'));
                return Html::create()->content([
                    $image,
                    Html::div()->content($val),
                ]);
            })->fixed(true)->align('center');
            $grid->column('uuid', admin_trans('player.fields.uuid'))->fixed(true)->ellipsis(true)->align('center');
            $grid->column('phone', admin_trans('player.fields.phone'))->fixed(true)->ellipsis(true)->align('center');
            $grid->column('money', admin_trans('player_platform_cash.platform_name.' . PlayerPlatformCash::PLATFORM_SELF))->display(function ($val, Player $data) {
                return Tag::create($val)->color('orange')->style(['cursor' => 'pointer'])->modal([$this, 'playerRecord'], ['id' => $data->id])->width('70%')->title($data->name . ' ' . $data->uuid);
            })->ellipsis(true)->align('center')->sortable();
            $grid->column('player_extend.recharge_amount', admin_trans('player_extend.fields.recharge_amount'))->ellipsis(true)->align('center')->sortable();
            $grid->column('player_extend.withdraw_amount', admin_trans('player_extend.fields.withdraw_amount'))->ellipsis(true)->align('center')->sortable();
            $grid->column('status', admin_trans('player.fields.status'))->switch()->ellipsis(true)->align('center');
            $grid->column('player.created_at', admin_trans('player.fields.created_at'))->display(function ($val, Player $data) {
                return Html::create()->content([
                    Html::div()->content(date('Y-m-d H:i:s', strtotime($data->created_at))),
                    Html::div()->content($data->player_register_record->ip ?? ''),
                    Html::div()->content($data->player_register_record->country_name ?? ''),
                ]);
            })->ellipsis(true)->align('center')->sortable();
            $grid->column('last_login', admin_trans('player.fields.player_login_record'))->display(function ($val, Player $data) {
                return Html::create()->content([
                    Html::div()->content($val ?? (!empty($data->the_last_player_login_record->created_at) ? date('Y-m-d H:i:s', strtotime($data->the_last_player_login_record->created_at)) : '')),
                    Html::div()->content($data->the_last_player_login_record->ip ?? ''),
                    Html::div()->content($data->the_last_player_login_record->country_name ?? ''),
                ]);
            })->ellipsis(true)->align('center')->sortable();
            $grid->filter(function (Filter $filter) {
                $filter->like()->text('uuid')->placeholder(admin_trans('player.fields.uuid'));
                $filter->like()->text('name')->placeholder(admin_trans('player.fields.name'));
                $filter->like()->text('phone')->placeholder(admin_trans('player.fields.phone'));
                $filter->eq()->select('department_id')
                    ->showSearch()
                    ->style(['width' => '200px'])
                    ->dropdownMatchSelectWidth()
                    ->placeholder(admin_trans('player.fields.department_id'))
                    ->remoteOptions(admin_url(['addons-webman-controller-ChannelController', 'getDepartmentOptions']));
                $filter->eq()->select('level')
                    ->showSearch()
                    ->style(['width' => '200px'])
                    ->dropdownMatchSelectWidth()
                    ->placeholder(admin_trans('player.fields.level'))
                    ->options(playerLevelOptions());
                $filter->form()->hidden('created_at_start');
                $filter->form()->hidden('created_at_end');
                $filter->form()->dateTimeRange('created_at_start', 'created_at_end', '')->placeholder([admin_trans('public_msg.created_at_start'), admin_trans('public_msg.created_at_end')]);
            });
            $grid->expandFilter();
            $grid->hideDelete();
            $grid->hideSelection();
            $grid->tools([
                    $grid->addButton()->modal($this->form()),
                    Button::create(admin_trans('player.level_setting'))
                        ->danger()
                        ->style(['margin-left' => '10px'])
                        ->drawer($this->levelSetting())
                ]
            );
            $grid->actions(function (Actions $actions, Player $data) {
                $actions->edit()->modal($this->form())->width('60%');
                $actions->hideDel();
                $dropdown = $actions->dropdown();
                $dropdown->prepend(admin_trans('admin.reset_password'), 'fas fa-key')
                    ->modal($this->resetPassword($data->id));
                $dropdown->append(admin_trans('player.wallet.player_wallet'), 'MoneyCollectFilled')
                    ->modal($this->playerWallet([
                        'id' => $data->id,
                        'money' => $data->wallet->money ?? 0,
                    ]))->width('600px');
                $dropdown->append(admin_trans('player.wallet.artificial_recharge'), 'TransactionOutlined')
                    ->modal($this->artificialRecharge([
                        'id' => $data->id,
                        'money' => $data->wallet->money ?? 0,
                    ]))->width('600px')->title(Html::create(admin_trans('player.wallet.artificial_recharge'))->content(
                        ToolTip::create(Icon::create('QuestionCircleOutlined')->style(['marginLeft' => '5px', 'cursor' => 'pointer']))->title(admin_trans('player.wallet.artificial_recharge_tip'))
                    ));
                $dropdown->append(admin_trans('player.wallet.artificial_withdrawal'), 'PayCircleOutlined')
                    ->modal($this->artificialWithdrawal([
                        'id' => $data->id,
                        'money' => $data->wallet->money ?? 0,
                    ]))->width('600px')->title(Html::create(admin_trans('player.wallet.artificial_withdrawal'))->content(
                        ToolTip::create(Icon::create('QuestionCircleOutlined')->style(['marginLeft' => '5px', 'cursor' => 'pointer']))->title(admin_trans('player.wallet.artificial_withdrawal_tip'))
                    ));
            });
            $grid->updateing(function ($ids, $data) {
                if (isset($ids[0]) && isset($data['player_extend'])) {
                    if (PlayerExtend::updateOrCreate(
                        ['player_id' => $ids[0]],
                        $data['player_extend']
                    )) {
                        return message_success(admin_trans('player.remark_edit_success'));
                    }
                }
            });
        });
    }

    /**
     * @return Form
     */
    public function levelSetting(): Form
    {
        $list = PlayerLevel::query()->orderBy('level')->get();
        $data = [];
        /** @var PlayerLevel $playerLevel */
        foreach ($list as $playerLevel) {
            $data['id'][$playerLevel->level] = $playerLevel->id;
            $data['level'][$playerLevel->level] = $playerLevel->level;
            $data['recharge_amount'][$playerLevel->level] = $playerLevel->recharge_amount;
            $data['chip_multiple'][$playerLevel->level] = $playerLevel->chip_multiple;
            $data['bet_rebate_ratio'][$playerLevel->level] = $playerLevel->bet_rebate_ratio;
            $data['damage_rebate_ratio'][$playerLevel->level] = $playerLevel->damage_rebate_ratio;
            $data['content'][$playerLevel->level] = json_decode($playerLevel->content, true);
        }
        return Form::create($data, function (Form $form) {
            $form->labelWidth('200');
            $form->layout('vertical');
            $langList = plugin()->webman->config('ui.lang.list');
            $tabs = $form->tabs()
                ->tabPosition('left')
                ->destroyInactiveTabPane();
            for ($i = 1; $i <= 13; $i++) {
                $tabs->pane(admin_trans('player.level.' . $i), function (Form $form) use ($i, $langList) {
                    $tabs = $form->tabs()->destroyInactiveTabPane();
                    foreach ($langList as $k => $v) {
                        $tabs->pane($v, function (Form $form) use ($k, $i) {
                            $form->text("content." . $i . '.' . $k . ".level_name", admin_trans('player_level.level_name'))
                                ->required()->maxlength(20)
                                ->help(admin_trans('player_level.help.level_name'));
                            $form->textarea("content." . $i . '.' . $k . ".content", admin_trans('player_level.level_content'))
                                ->rows(5)
                                ->required()->showCount()->maxlength(500)
                                ->help(admin_trans('player_level.help.level_content'));
                        });
                    }
                    $form->hidden('id.' . $i);
                    $form->hidden('level.' . $i)->value($i);
                    $form->number('recharge_amount.' . $i, admin_trans('player_level.recharge_amount'))
                        ->min(0)
                        ->max(1000000000)
                        ->precision(0)
                        ->style(['width' => '300px'])
                        ->default(0)
                        ->required()
                        ->controls(false)
                        ->help(admin_trans('player_level.help.recharge_amount', null, ['{max_amount}' => 1000000000]));
                    $form->number('chip_multiple.' . $i, admin_trans('player_level.chip_multiple'))
                        ->min(0)
                        ->max(10000)
                        ->precision(2)
                        ->style(['width' => '300px'])
                        ->controls(false)
                        ->default(0)
                        ->required()
                        ->addonAfter('%')
                        ->help(admin_trans('player_level.help.chip_multiple', null, ['{max_multiple}' => 10000]));
                    $form->number('bet_rebate_amount.' . $i, admin_trans('player_level.bet_rebate_amount'))
                        ->min(0)
                        ->max(1000000000)
                        ->precision(0)
                        ->style(['width' => '300px'])
                        ->controls(false)
                        ->default(0)
                        ->required()
                        ->help(admin_trans('player_level.help.bet_rebate_amount', null, ['{max_amount}' => 1000000000]));
                    $form->number('bet_rebate_ratio.' . $i, admin_trans('player_level.bet_rebate_ratio'))
                        ->min(0)
                        ->max(100)
                        ->precision(2)
                        ->style(['width' => '300px'])
                        ->controls(false)
                        ->addonAfter('%')
                        ->default(0)
                        ->required()
                        ->help(admin_trans('player_level.help.bet_rebate_ratio', null, ['{max_ratio}' => 100]));
                    $form->number('damage_rebate_ratio.' . $i, admin_trans('player_level.damage_rebate_ratio'))
                        ->min(0)
                        ->max(100)
                        ->precision(2)
                        ->style(['width' => '300px'])
                        ->controls(false)
                        ->addonAfter('%')
                        ->default(0)
                        ->required()
                        ->help(admin_trans('player_level.help.damage_rebate_ratio', null, ['{max_ratio}' => 100]));
                });
            }
            $form->saving(function (Form $form) {
                $idArr = $form->input('id');
                $levelArr = $form->input('level');
                $rechargeAmountArr = $form->input('recharge_amount');
                $chipMultipleArr = $form->input('chip_multiple');
                $betRebateAmountArr = $form->input('bet_rebate_amount');
                $betRebateRatioArr = $form->input('bet_rebate_ratio');
                $damageRebateRatioArr = $form->input('damage_rebate_ratio');
                $content = $form->input('content');
                DB::beginTransaction();
                try {
                    foreach ($idArr as $key => $item) {
                        if (empty($rechargeAmountArr[$key])) {
                            throw new \Exception(admin_trans('player_level.recharge_amount_not_found', null, ['{level}' => admin_trans('player_level.level') . $key]));
                        }
                        if (!empty($item)) {
                            $playerLevel = PlayerLevel::query()->find($item);
                        } else {
                            $playerLevel = new PlayerLevel();
                        }
                        $playerLevel->level = $levelArr[$key];
                        $playerLevel->content = json_encode($content[$key]);
                        $playerLevel->recharge_amount = $rechargeAmountArr[$key];
                        $playerLevel->chip_multiple = $chipMultipleArr[$key];
                        $playerLevel->bet_rebate_amount = $betRebateAmountArr[$key];
                        $playerLevel->bet_rebate_ratio = $betRebateRatioArr[$key];
                        $playerLevel->damage_rebate_ratio = $damageRebateRatioArr[$key];
                        if ($key > 1 && $rechargeAmountArr[$key] <= $rechargeAmountArr[$key - 1]) {
                            throw new \Exception(admin_trans('player_level.recharge_amount_must_gt_upper', null, ['{level}' => admin_trans('player_level.level') . $key]));
                        }
                        if ($key > 1 && $key < 7 && $rechargeAmountArr[$key] >= $rechargeAmountArr[$key + 1]) {
                            throw new \Exception(admin_trans('player_level.recharge_amount_must_lt_next', null, ['{level}' => admin_trans('player_level.level') . $key]));
                        }

                        $playerLevel->save();
                    }
                    DB::commit();
                } catch (\Exception $e) {
                    DB::rollBack();
                    return message_error($e->getMessage());
                }
                return message_success(admin_trans('form.save_success'));
            });
        });
    }

    /**
     * 人工提现
     * @auth true
     * @param $data
     * @return Form
     */
    public function artificialWithdrawal($data): Form
    {
        return Form::create(new $this->model, function (Form $form) use ($data) {
            $form->number('coins', admin_trans('player_withdraw_record.fields.coins'))
                ->min(0)
                ->max(100000000)
                ->precision(2)
                ->style(['width' => '100%'])
                ->addonBefore(admin_trans('player.wallet.wallet') . ' ' . $data['money'] ?? 0)
                ->required();
            $form->number('money', admin_trans('player_withdraw_record.fields.money'))
                ->min(0)
                ->max(100000000)
                ->precision(2)
                ->style(['width' => '100%']);
            $form->text('currency', admin_trans('player_withdraw_record.fields.currency'))->maxlength(10);
            $form->text('bank_name', admin_trans('player_withdraw_record.fields.bank_name'))->maxlength(50);
            $form->text('account', admin_trans('player_withdraw_record.fields.account'))->maxlength(50);
            $form->text('account_name', admin_trans('player_withdraw_record.fields.account_name'))->maxlength(50);
            $form->textarea('remark', admin_trans('player_withdraw_record.fields.remark'))->maxlength(255)->bindAttr('rows', 4);
            $form->layout('vertical');
            $form->hidden('id')->value($data['id']);
            $form->saving(function (Form $form) {
                /** @var Player $player */
                $player = Player::where('id', $form->input('id'))->whereNull('deleted_at')->first();
                if (empty($player)) {
                    return message_error(admin_trans('player.not_fount'));
                }
                if ($player->status == 0) {
                    return message_error(admin_trans('player.disable'));
                }
                if ($player->wallet->money < $form->input('coins')) {
                    return message_error(admin_trans('player.insufficient_balance'));
                }
                DB::beginTransaction();
                try {
                    $beforeGameAmount = $player->wallet->money;
                    // 生成订单
                    $playerWithdrawRecord = new PlayerWithdrawRecord();
                    $playerWithdrawRecord->player_id = $player->id;
                    $playerWithdrawRecord->talk_user_id = $player->talk_user_id;
                    $playerWithdrawRecord->department_id = $player->department_id;
                    $playerWithdrawRecord->tradeno = createOrderNo();
                    $playerWithdrawRecord->player_name = $player->name ?? '';
                    $playerWithdrawRecord->player_phone = $player->phone ?? '';
                    $playerWithdrawRecord->money = $form->input('money') ?? 0;
                    $playerWithdrawRecord->coins = $form->input('coins') ?? 0;
                    $playerWithdrawRecord->fee = 0;
                    $playerWithdrawRecord->inmoney = bcsub($playerWithdrawRecord->money, $playerWithdrawRecord->fee, 2); // 实际提现金额
                    $playerWithdrawRecord->currency = $form->input('currency') ?? 0;
                    $playerWithdrawRecord->bank_name = $form->input('bank_name') ?? 0;
                    $playerWithdrawRecord->account = $form->input('account') ?? 0;
                    $playerWithdrawRecord->account_name = $form->input('account_name') ?? 0;
                    $playerWithdrawRecord->type = PlayerWithdrawRecord::TYPE_ARTIFICIAL;
                    $playerWithdrawRecord->status = PlayerWithdrawRecord::STATUS_SUCCESS;
                    $playerWithdrawRecord->finish_time = date('Y-m-d H:i:s');
                    $playerWithdrawRecord->save();
                    // 玩家钱包扣减
                    $player->wallet->money = bcsub($player->wallet->money, $playerWithdrawRecord->coins, 2);
                    // 更新玩家统计
                    $player->player_extend->withdraw_amount = bcadd($player->player_extend->withdraw_amount, $playerWithdrawRecord->coins, 2);
                    $player->push();
                    //寫入金流明細
                    $playerDeliveryRecord = new PlayerDeliveryRecord;
                    $playerDeliveryRecord->player_id = $playerWithdrawRecord->player_id;
                    $playerDeliveryRecord->department_id = $playerWithdrawRecord->department_id;
                    $playerDeliveryRecord->target = $playerWithdrawRecord->getTable();
                    $playerDeliveryRecord->target_id = $playerWithdrawRecord->id;
                    $playerDeliveryRecord->type = PlayerDeliveryRecord::TYPE_WITHDRAWAL;
                    $playerDeliveryRecord->source = 'artificial_withdrawal';
                    $playerDeliveryRecord->amount = $playerWithdrawRecord->coins;
                    $playerDeliveryRecord->amount_before = $beforeGameAmount;
                    $playerDeliveryRecord->amount_after = $player->wallet->money;
                    $playerDeliveryRecord->tradeno = $playerWithdrawRecord->tradeno ?? '';
                    $playerDeliveryRecord->remark = $playerWithdrawRecord->remark ?? '';
                    $playerDeliveryRecord->save();
                    DB::commit();
                } catch (\Exception $e) {
                    DB::rollBack();
                    return message_error(admin_trans('player.artificial_withdrawal_error'));
                }
                return message_success(admin_trans('player.artificial_withdrawal_success'));
            });
        });
    }

    /**
     * 人工充值
     * @auth true
     * @param $data
     * @return Form
     */
    public function artificialRecharge($data): Form
    {
        return Form::create(new $this->model, function (Form $form) use ($data) {
            $form->number('coins', admin_trans('player_recharge_record.fields.coins'))
                ->min(0)
                ->max(100000000)
                ->precision(2)
                ->style(['width' => '100%'])
                ->addonBefore(admin_trans('player.wallet.wallet') . ' ' . $data['money'] ?? 0)
                ->required();
            $form->number('money', admin_trans('player_recharge_record.fields.money'))
                ->min(0)
                ->max(100000000)
                ->precision(2)
                ->style(['width' => '100%']);
            $form->text('currency', admin_trans('player_recharge_record.fields.currency'))->maxlength(10);
            $form->textarea('remark', admin_trans('player_recharge_record.fields.remark'))->maxlength(255)->bindAttr('rows', 4);
            $form->layout('vertical');
            $form->hidden('id')->value($data['id']);
            $form->saving(function (Form $form) {
                /** @var Player $player */
                $player = Player::where('id', $form->input('id'))->whereNull('deleted_at')->first();
                if (empty($player)) {
                    return message_error(admin_trans('player.not_fount'));
                }
                if ($player->status == 0) {
                    return message_error(admin_trans('player.disable'));
                }
                DB::beginTransaction();
                try {
                    $beforeGameAmount = $player->wallet->money;
                    // 生成订单
                    $playerRechargeRecord = new  PlayerRechargeRecord();
                    $playerRechargeRecord->player_id = $player->id;
                    $playerRechargeRecord->department_id = $player->department_id;
                    $playerRechargeRecord->tradeno = createOrderNo();
                    $playerRechargeRecord->player_name = $player->name ?? '';
                    $playerRechargeRecord->money = $form->input('money') ?? 0;
                    $playerRechargeRecord->inmoney = $form->input('money') ?? 0;
                    $playerRechargeRecord->currency = $form->input('currency') ?? '';
                    $playerRechargeRecord->type = PlayerRechargeRecord::TYPE_ARTIFICIAL;
                    $playerRechargeRecord->coins = $form->input('coins');
                    $playerRechargeRecord->status = PlayerRechargeRecord::STATUS_RECHARGED_SUCCESS;
                    $playerRechargeRecord->remark = $form->input('remark');
                    $playerRechargeRecord->finish_time = date('Y-m-d H:i:s');
                    $playerRechargeRecord->user_id = Admin::id() ?? 0;
                    $playerRechargeRecord->user_name = !empty(Admin::user()) ? Admin::user()->toArray()['username'] : '';
                    $playerRechargeRecord->save();
                    $player->wallet->money = bcadd($player->wallet->money, $playerRechargeRecord->coins, 2);
                    $player->player_extend->recharge_amount = bcadd($player->player_extend->recharge_amount, $playerRechargeRecord->coins, 2);
                    $player->push();

                    //寫入金流明細
                    $playerDeliveryRecord = new PlayerDeliveryRecord;
                    $playerDeliveryRecord->player_id = $playerRechargeRecord->player_id;
                    $playerDeliveryRecord->department_id = $playerRechargeRecord->department_id;
                    $playerDeliveryRecord->target = $playerRechargeRecord->getTable();
                    $playerDeliveryRecord->target_id = $playerRechargeRecord->id;
                    $playerDeliveryRecord->type = PlayerDeliveryRecord::TYPE_RECHARGE;
                    $playerDeliveryRecord->source = 'artificial_recharge';
                    $playerDeliveryRecord->amount = $playerRechargeRecord->coins;
                    $playerDeliveryRecord->amount_before = $beforeGameAmount;
                    $playerDeliveryRecord->amount_after = $player->wallet->money;
                    $playerDeliveryRecord->tradeno = $playerRechargeRecord->tradeno ?? '';
                    $playerDeliveryRecord->remark = $playerRechargeRecord->remark ?? '';
                    $playerDeliveryRecord->save();

                    DB::commit();
                } catch (\Exception $e) {
                    DB::rollBack();
                    return message_error(admin_trans('player.artificial_recharge_error'));
                }
                return message_success(admin_trans('player.artificial_recharge_success'));
            });
        });
    }


    /**
     * 处理标签
     * @param array $value
     * @return Html
     */
    public function handleTagIds(array $value): Html
    {
        $options = $this->getPlayerTagOptions($value);
        $html = Html::create();
        foreach ($options as $option) {
            $html->content(
                Tag::create($option)
                    ->color('success')
            );
        }
        return $html;
    }

    /**
     * 获取玩家标签选项(筛选id)
     * @param array $ids
     * @return array
     */
    public function getPlayerTagOptions(array $ids = []): array
    {
        $idsStr = json_encode($ids);
        $cacheKey = md5("player_tag_options_ids_$idsStr");
        if (Cache::has($cacheKey)) {
            return Cache::get($cacheKey);
        } else {
            if (!empty($ids)) {
                $data = (new PlayerTag())->whereIn('id', $ids)->select(['name', 'id'])->get()->toArray();
                $data = $data ? array_column($data, 'name', 'id') : [];
                Cache::set($cacheKey, $data, 24 * 60 * 60);

                return $data;
            }
            return [];
        }
    }

    /**
     * 获取玩家标签(筛选id)
     * @return array
     */
    public function getPlayerTagOptionsFilter(): array
    {
        $cacheKey = "doc_player_tag_options_filter";
        if (Cache::has($cacheKey)) {
            return Cache::get($cacheKey);
        } else {
            $data = (new PlayerTag())->select(['name', 'id'])->get()->toArray();
            $data = $data ? array_column($data, 'name', 'id') : [];
            Cache::set($cacheKey, $data, 24 * 60 * 60);

            return $data;
        }
    }

    /**
     * 玩家标签修改保存
     * @return Form
     */
    public function playerTagForm(): Form
    {
        return Form::create(new $this->playerTag, function (Form $form) {
            $form->text('name', '名称');
            $form->saving(function (Form $form) {
                if ($form->isEdit()) {
                    $id = $form->driver()->get('id');
                    /** @var PlayerTag $tag */
                    $tag = PlayerTag::find($id);
                    $tag->name = $form->input('name');
                    $tag->save();
                } else {
                    $tag = new PlayerTag();
                    $tag->name = $form->input('name');
                    $tag->save();
                }
                return message_success(admin_trans('form.save_success'))->refreshMenu();
            });
        });
    }

    /**
     * 玩家信息
     * @auth true
     * @return Form
     */
    public function form(): Form
    {
        $options = [];
        foreach (config('def_avatar') as $key => $item) {
            $options[$key] = Avatar::create()->style(['padding' => '1px'])->src($item)->shape('square');
        }
        return Form::create(new $this->model(), function (Form $form) use ($options) {
            if ($form->isEdit()) {
                $form->title(admin_trans('player.details'));
                $form->row(function (Form $form) use ($options) {
                    $form->column(function (Form $form) use ($options) {
                        $form->text('phone', admin_trans('player.fields.phone'))->maxlength(50)->ruleNumber()->disabled(true);
                        $form->text('name', admin_trans('player.fields.name'))->maxlength(50);
                        $form->radio('avatar_type', admin_trans('player.avatar_type'))
                            ->button()
                            ->default(is_numeric($form->driver()->get('avatar')) ? 2 : 1)
                            ->options([
                                1 => admin_trans('player.upload_avatar'),
                                2 => admin_trans('player.def_avatar')
                            ])
                            ->when(1, function (Form $form) {
                                $form->image('avatar', admin_trans('player.fields.avatar'))->value(is_numeric($form->driver()->get('avatar')) ? '' : $form->driver()->get('avatar'))->ext('jpg,png,jpeg')->fileSize('1m');
                            })->when(2, function (Form $form) use ($options) {
                                $form->radio('def_avatar', admin_trans('player.def_avatar'))
                                    ->default(1)
                                    ->options($options);
                            });
                        $form->text('player_extend.id_number', admin_trans('player_extend.fields.id_number'))->ruleAlphaNum()->maxlength(20);
                        $form->desc('the_last_player_login_record.created_at', admin_trans('player.fields.login_at'))->value($form->input('the_last_player_login_record.created_at') ? date('Y-m-d H:i:s', strtotime($form->input('the_last_player_login_record.created_at'))) : '');
                        $form->desc('created_at', admin_trans('player.fields.created_at'))->value($form->input('created_at') ? date('Y-m-d H:i:s', strtotime($form->input('created_at'))) : '');
                        $form->desc('player_register_record.ip', admin_trans('player.fields.register_ip'));
                        $form->desc('player_register_record.register_domain', admin_trans('player.fields.register_domain'));
                    })->span(12);

                    $form->column(function (Form $form) {
                        $form->text('player_extend.address', admin_trans('player_extend.fields.address'))->maxlength(255);
                        $form->date('player_extend.birthday', admin_trans('player_extend.fields.birthday'));
                        $form->text('player_extend.email', admin_trans('player_extend.fields.email'))->ruleEmail()->maxlength(20);
                        $form->text('player_extend.line', admin_trans('player_extend.fields.line'))->ruleAlphaNum()->maxlength(20);
                        $form->textarea('player_extend.remark', admin_trans('player_extend.fields.remark'))
                            ->showCount()
                            ->rule(['max:255' => admin_trans('player_extend.fields.remark')]);
                        $playerBank = PlayerBank::query()->where('player_id', $form->driver()->get('id'))->get()->toArray();
                        foreach ($playerBank as $key => $item) {
                            $form->row(function (Form $form) use ($item, $key) {
                                $form->text('bank_name'.$key, admin_trans('player.bank_name'))
                                    ->value($item['bank_name'] ?? 0)
                                    ->disabled(true);
                                $form->text('account_name'.$key, admin_trans('player.account_name'))
                                    ->value($item['account_name'] ?? 0)
                                    ->disabled(true);
                                $form->text('account'.$key, admin_trans('player.account'))
                                    ->value($item['account'] ?? 0)
                                    ->disabled(true);
                            });
                        }
                    })->span(12);
                });
            } else {
                $form->title(admin_trans('player.add_player'));
                $form->text('phone', admin_trans('player.fields.phone'))->maxlength(50)->ruleAlphaNum()->required();
                $form->radio('avatar_type', admin_trans('player.avatar_type'))
                    ->button()
                    ->default(2)
                    ->options([
                        1 => admin_trans('player.upload_avatar'),
                        2 => admin_trans('player.def_avatar')
                    ])
                    ->when(1, function (Form $form) {
                        $form->image('avatar', admin_trans('player.fields.avatar'))->ext('jpg,png,jpeg')->fileSize('1m');
                    })->when(2, function (Form $form) use ($options) {
                        $form->radio('def_avatar', admin_trans('player.def_avatar'))
                            ->default(1)
                            ->options($options);
                    });
                $form->select('country_code', admin_trans('player.fields.country_code'))->options([
                    PhoneSmsLog::COUNTRY_CODE_MY => PhoneSmsLog::COUNTRY_CODE_MY,
                ])->required();
                $form->select('department_id', admin_trans('player.fields.department_id'))->remoteOptions(admin_url(['addons-webman-controller-ChannelController', 'getDepartmentOptions']))->required();
                $form->text('name', admin_trans('player.fields.name'))->maxlength(50)->required();
                $form->password('password', admin_trans('player.new_password'))
                    ->rule([
                        'confirmed' => admin_trans('player.password_confim_validate'),
                        'min:6' => admin_trans('player.password_min_number')
                    ])
                    ->value('')
                    ->required();
                $form->password('password_confirmation', admin_trans('player.confim_password'))
                    ->required();
            }
            $form->saved(function () {
                return message_success(admin_trans('player.save_player_info_success'));
            });
            $form->saving(function (Form $form) {
                if ($form->isEdit()) {
                    $orgData = $form->driver()->get();
                    /** @var Player $player */
                    $player = Player::find($orgData['id']);
                    if (empty($player)) {
                        return message_error(admin_trans('player.not_fount'));
                    }
                    DB::beginTransaction();
                    try {
                        $player->name = $form->input('name');
                        $player->avatar = $form->input('avatar_type') == 1 ? $form->input('avatar') : $form->input('def_avatar');
                        $player->save();
                        PlayerExtend::query()->updateOrCreate(['player_id' => $orgData['id']], [
                            'address' => $form->input('player_extend.address'),
                            'birthday' => $form->input('player_extend.birthday'),
                            'id_number' => $form->input('player_extend.id_number'),
                            'email' => $form->input('player_extend.email'),
                            'line' => $form->input('player_extend.line'),
                            'remark' => $form->input('player_extend.remark'),
                            'player_id' => $orgData['id']]);
                        DB::commit();
                    } catch (\Exception $e) {
                        DB::rollBack();
                        return message_error($e->getMessage());
                    }
                    return message_success(admin_trans('player.save_player_info_success'));
                } else {
                    $phone = $form->input('phone');
                    $password = $form->input('password');
                    $country_code = $form->input('country_code');
                    /** @var $player Player */
                    $player = Player::query()->where('phone', $country_code.$phone)->first();
                    if (!empty($player)) {
                        return message_error(admin_trans('player.phone_has_register'));
                    }
                    /** @var Channel $channel */
                    $channel = Channel::where('department_id', $form->input('department_id'))->first();
                    if (empty($channel)) {
                        return jsonFailResponse(trans('channel_not_found', [], 'message'));
                    }
                    DB::beginTransaction();
                    try {
                        $player = new Player();
                        $player->phone = $country_code.$phone;
                        $player->name = $form->input('name');
                        if ($form->input('avatar_type') == 1) {
                            $player->avatar = $form->input('avatar') ?? config('def_avatar.1');
                        }
                        if ($form->input('avatar_type') == 2) {
                            $player->avatar = $form->input('def_avatar') ?? config('def_avatar.1');
                        }
                        $player->country_code = $country_code;
                        $player->type = Player::TYPE_PLAYER;
                        $player->currency = $channel->currency;
                        $player->department_id = $channel->department_id;
                        $player->password = $password;
                        $player->uuid = gen_uuid();
                        $player->recommend_code = createCode();
                        $player->save();

                        addPlayerExtend($player, [
                            'email' => $data['email'] ?? ''
                        ]);
                        addRegisterRecord($player->id, PlayerRegisterRecord::TYPE_ADMIN, $player->department_id);

                        DB::commit();
                    } catch (\Exception $e) {
                        DB::rollBack();
                        return message_error($e->getMessage());
                    }
                    return message_success(admin_trans('player.save_player_info_success'));
                }
            });
        });
    }

    /**
     * 重置密码
     * @auth true
     * @param $id
     * @return Form
     */
    public function resetPassword($id): Form
    {
        return Form::create(new $this->model, function (Form $form) {
            $form->password('password', admin_trans('player.new_password'))
                ->rule([
                    'confirmed' => admin_trans('player.password_confim_validate'),
                    'min:6' => admin_trans('player.password_min_number')
                ])
                ->value('')
                ->required();
            $form->password('password_confirmation', admin_trans('player.confim_password'))
                ->required();
        });
    }

    /**
     * 玩家钱包
     * @auth true
     * @param $data
     * @return Form
     */
    public function playerWallet($data): Form
    {
        return Form::create(new $this->model, function (Form $form) use ($data) {
            $form->hidden('id')->default($data['id']);
            $form->row(function (Form $form) {
                $type = $form->getBindField('type');
                $form->radio('type', admin_trans('player.wallet.type'))
                    ->button()
                    ->disabled($form->isEdit())
                    ->default(PlayerMoneyEditLog::TYPE_INCREASE)
                    ->options([
                        admin_trans('player.wallet.deduct'),
                        admin_trans('player.wallet.increase'),
                    ])->required()->span(7);
                $form->hidden('type')->bindAttr('value', $type)
                    ->when(PlayerMoneyEditLog::TYPE_DEDUCT, function (Form $form) {
                        $form->select('deduct_action', admin_trans('player.wallet.action'))
                            ->remoteOptions(admin_url([$this, 'getTranOptions'], ['type' => PlayerMoneyEditLog::TYPE_DEDUCT]))
                            ->required()->span(16)->style(['margin-left' => '22px']);
                    })->when(PlayerMoneyEditLog::TYPE_INCREASE, function (Form $form) {
                        $form->select('increase_action', admin_trans('player.wallet.action'))
                            ->remoteOptions(admin_url([$this, 'getTranOptions'], ['type' => PlayerMoneyEditLog::TYPE_INCREASE]))
                            ->required()->span(16)->style(['margin-left' => '22px']);
                    });
            });
            $form->number('money', admin_trans('player.wallet.money'))->min(0)->max(100000000)->precision(2)->style(['width' => '100%'])->addonBefore(admin_trans('player.wallet.wallet') . ' ' . $data['money'] ?? 0)->required();
            $form->textarea('remark', admin_trans('player.wallet.textarea'))->maxlength(255)->bindAttr('rows', 4)->required();
            $form->actions()->hideResetButton();
            $form->saving(function (Form $form) use ($data) {
                return $this->store([
                    'id' => $form->input('id'),
                    'type' => $form->input('type'),
                    'deduct_action' => $form->input('deduct_action'),
                    'increase_action' => $form->input('increase_action'),
                    'money' => $form->input('money'),
                    'remark' => $form->input('remark'),
                ]);
            });
            $form->layout('vertical');
        });
    }

    /**
     * 钱包操作
     * @param $data
     * @return Msg
     */
    public function store($data): Msg
    {
        try {
            DB::beginTransaction();
            playerManualSystem($data);
            DB::commit();
        } catch (\Exception $e) {
            DB::rollBack();
            return message_error(admin_trans('player.wallet.wallet_operation_failed'));
        }

        return message_success(admin_trans('player.wallet.wallet_operation_success'));
    }


    /**
     * 钱包操作类型
     * @param $type
     * @return mixed
     */
    public function getTranOptions($type)
    {
        $options = [];
        if ($type == PlayerMoneyEditLog::TYPE_INCREASE) {
            $transactionType = [
                PlayerMoneyEditLog::ACTIVITY_GIVE,
                PlayerMoneyEditLog::ADMIN_INCREASE,
                PlayerMoneyEditLog::OTHER
            ];
        } else {
            $transactionType = [
                PlayerMoneyEditLog::ADMIN_DEDUCT,
                PlayerMoneyEditLog::OTHER
            ];
        }

        foreach ($transactionType as $item) {
            $options[] = [
                'value' => $item,
                'label' => admin_trans('player.wallet.wallet_type.' . $item),
            ];
        }

        return Response::success($options);
    }

    /**
     * 玩家记录
     * @param $id
     * @auth true
     * @return Card
     */
    public function playerRecord($id): Card
    {
        $tabs = Tabs::create()
            ->pane(admin_trans('player.player_recharge_record'), $this->rechargeRecord($id))
            ->pane(admin_trans('player.player_withdraw_record'), $this->withdrawalRecords($id))
            ->pane(admin_trans('player.player_delivery_record'), $this->playerDeliveryRecord($id));

        return Card::create($tabs);
    }

    /**
     * 提现记录
     * @param $id
     * @return Grid
     */
    public function withdrawalRecords($id): Grid
    {
        return Grid::create(new $this->withdraw(), function (Grid $grid) use ($id) {
            $grid->title(admin_trans('player_withdraw_record.title'));
            $grid->model()->with(['channel'])->where('player_id', $id)->where('status', PlayerWithdrawRecord::STATUS_SUCCESS)->orderBy('created_at', 'desc');
            $exAdminFilter = Request::input('ex_admin_filter', []);
            if (!empty($exAdminFilter)) {
                if (isset($exAdminFilter['created_at_start']) && !empty($exAdminFilter['created_at_start'])) {
                    $grid->model()->where('created_at', '>=', $exAdminFilter['created_at_start']);
                }
                if (isset($exAdminFilter['created_at_end']) && !empty($exAdminFilter['created_at_end'])) {
                    $grid->model()->where('created_at', '<=', $exAdminFilter['created_at_end']);
                }
                if (isset($exAdminFilter['finish_time_start']) && !empty($exAdminFilter['finish_time_start'])) {
                    $grid->model()->where('finish_time', '>=', $exAdminFilter['finish_time_start']);
                }
                if (isset($exAdminFilter['finish_time_end']) && !empty($exAdminFilter['finish_time_end'])) {
                    $grid->model()->where('finish_time', '<=', $exAdminFilter['finish_time_end']);
                }
            }
            $grid->bordered();
            $grid->autoHeight();
            $grid->column('id', admin_trans('player_withdraw_record.fields.id'))->align('center');
            $grid->column('player_phone', admin_trans('player_withdraw_record.fields.player_phone'))->display(function ($val, PlayerWithdrawRecord $data) {
                $image = (isset($data->player->avatar) && !empty($data->player->avatar)) ? Avatar::create()->src($data->player->avatar) : Avatar::create()->icon(Icon::create('UserOutlined'));
                return Html::create()->content([
                    $image,
                    Html::div()->content($val)
                ]);
            })->align('center');
            $grid->column('tradeno', admin_trans('player_withdraw_record.fields.tradeno'))->copy()->align('center');
            $grid->column('money', admin_trans('player_withdraw_record.fields.money'))->display(function ($val, PlayerWithdrawRecord $data) {
                return $val . ' ' . ($data->currency == 'TALK' ? 'Q币' : $data->currency);
            })->align('center');
            $grid->column('coins', admin_trans('player_withdraw_record.fields.coins'))->align('center');
            $grid->column(function (Grid $grid) {
                $grid->column('bank_name', admin_trans('player_withdraw_record.fields.bank_name'))->copy()->align('center');
                $grid->column('account_name', admin_trans('player_withdraw_record.fields.account_name'))->copy()->align('center');
                $grid->column('account', admin_trans('player_withdraw_record.fields.account'))->copy()->align('center');
            }, admin_trans('player_withdraw_record.player_bank'));
            $grid->column('type', admin_trans('player_withdraw_record.fields.type'))->display(function ($val) {
                switch ($val) {
                    case PlayerWithdrawRecord::TYPE_SELF:
                        return Tag::create(admin_trans('player_withdraw_record.type.' . $val))
                            ->color('#3b5999');
                    case PlayerWithdrawRecord::TYPE_ARTIFICIAL:
                        return Tag::create(admin_trans('player_withdraw_record.type.' . $val))
                            ->color('#cd201f');
                    default:
                        return '';
                }
            })->align('center');
            $grid->column('status', admin_trans('player_withdraw_record.fields.status'))
                ->display(function () {
                    return Tag::create(admin_trans('player_withdraw_record.status.' . PlayerWithdrawRecord::STATUS_SUCCESS))->color('#87d068');
                })->align('center')->sortable();
            $grid->column('channel.name', admin_trans('player_withdraw_record.fields.department_id'))->align('center');
            $grid->column('finish_time', admin_trans('player_withdraw_record.fields.finish_time'))->sortable()->align('center');
            $grid->column('created_at', admin_trans('player_withdraw_record.fields.created_at'))->sortable()->align('center');
            $grid->hideDelete();
            $grid->hideSelection();
            $grid->actions(function (Actions $actions) {
                $actions->hideDel();
                $actions->hideEdit();
            });
            $grid->filter(function (Filter $filter) {
                $filter->like()->text('tradeno')->placeholder(admin_trans('player_withdraw_record.fields.tradeno'));
                $filter->form()->hidden('created_at_start');
                $filter->form()->hidden('created_at_end');
                $filter->form()->dateTimeRange('created_at_start', 'created_at_end', '')->placeholder([admin_trans('public_msg.created_at_start'), admin_trans('public_msg.created_at_end')]);
                $filter->form()->hidden('finish_time_start');
                $filter->form()->hidden('finish_time_end');
                $filter->form()->dateTimeRange('finish_time_start', 'finish_time_end', '')->placeholder([admin_trans('player_withdraw_record.fields.finish_time'), admin_trans('player_withdraw_record.fields.finish_time')]);
            });
            $grid->quickSearch();
        });
    }

    /**
     * 钱包操作
     * @param $id
     * @return Grid
     */
    public function playerDeliveryRecord($id): Grid
    {
        return Grid::create(new $this->playerDeliveryRecord, function (Grid $grid) use ($id) {
            $lang = Container::getInstance()->translator->getLocale();
            $grid->title(admin_trans('promoter_profit_record.player_activity_phase_record_title'));
            $grid->model()
                ->where('player_id', $id)
                ->whereIn('type', [
                    PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_ADD,
                    PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT,
                ])
                ->orderBy('id', 'desc');
            $exAdminFilter = Request::input('ex_admin_filter', []);
            if (!empty($exAdminFilter)) {
                if (isset($exAdminFilter['created_at_start']) && !empty($exAdminFilter['created_at_start'])) {
                    $grid->model()->where('created_at', '>=', $exAdminFilter['created_at_start']);
                }
                if (isset($exAdminFilter['created_at_end']) && !empty($exAdminFilter['created_at_end'])) {
                    $grid->model()->where('created_at', '<=', $exAdminFilter['created_at_end']);
                }
            }
            $grid->autoHeight();
            $grid->bordered(true);
            $grid->column('id', admin_trans('player_delivery_record.fields.id'))->align('center');
            $grid->column('source', admin_trans('player_delivery_record.fields.source'))->display(function ($val, PlayerDeliveryRecord $data) use ($lang) {
                switch ($data->type) {
                    case PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_ADD:
                    case PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT:
                        return Tag::create(trans($val, [], 'message', $lang))->color('red');
                    default:
                        return '';
                }
            })->align('center');
            $grid->column('type', admin_trans('player_delivery_record.fields.type'))
                ->display(function ($value) {
                    switch ($value) {
                        case PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_ADD:
                            $tag = Tag::create(admin_trans('player_delivery_record.type.' . PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_ADD))->color('#2db7f5');
                            break;
                        case PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT:
                            $tag = Tag::create(admin_trans('player_delivery_record.type.' . PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT))->color('#108ee9');
                            break;
                        default:
                            $tag = '';
                    }
                    return Html::create()->content([
                        $tag
                    ]);
                })->align('center')->sortable();
            $grid->column('amount', admin_trans('player_delivery_record.fields.amount'))->display(function ($val, PlayerDeliveryRecord $data) {
                if ($data->amount == 0) {
                    return Html::create()->content([$val])->style(['color' => 'green']);
                }
                switch ($data->type) {
                    case PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT:
                        return Html::create()->content(['-' . $val])->style(['color' => '#cd201f']);
                    default:
                        return Html::create()->content(['+' . $val])->style(['color' => 'green']);
                }
            })->align('center');
            $grid->column('user_name', admin_trans('player_delivery_record.fields.user_name'))->display(function ($val, PlayerDeliveryRecord $data) {
                $name = '--';
                if (in_array($data->type, [PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_ADD, PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT])) {
                    $name = $data->user_name ?? '管理员';
                }
                return Html::create()->content([
                    Html::div()->content($name),
                ]);
            });
            $grid->column('created_at', admin_trans('player_delivery_record.fields.created_at'))->align('center')->ellipsis(true);
            $grid->hideDelete();
            $grid->hideSelection();
            $grid->hideTrashed();
            $grid->actions(function (Actions $actions) {
                $actions->hideDel();
            });
            $grid->filter(function (Filter $filter) {
                $filter->eq()->select('type')
                    ->placeholder(admin_trans('player_delivery_record.fields.type'))
                    ->showSearch()
                    ->style(['width' => '200px'])
                    ->dropdownMatchSelectWidth()
                    ->options([
                        PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_ADD => admin_trans('player_delivery_record.type.' . PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_ADD),
                        PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT => admin_trans('player_delivery_record.type.' . PlayerDeliveryRecord::TYPE_MODIFIED_AMOUNT_DEDUCT),
                    ]);
                $filter->form()->hidden('created_at_start');
                $filter->form()->hidden('created_at_end');
                $filter->form()->dateTimeRange('created_at_start', 'created_at_end', '')->placeholder([admin_trans('public_msg.created_at_start'), admin_trans('public_msg.created_at_end')]);
            });
        });
    }

    /**
     * 充值记录
     * @param $id
     * @return Grid
     */
    public function rechargeRecord($id): Grid
    {
        return Grid::create(new $this->recharge(), function (Grid $grid) use ($id) {
            $grid->title(admin_trans('player_recharge_record.title'));
            $grid->bordered();
            $grid->autoHeight();
            $grid->model()->with(['channel', 'channel_recharge_setting'])->where('player_id', $id)->where('status', PlayerRechargeRecord::STATUS_RECHARGED_SUCCESS)->orderBy('created_at', 'desc');
            $grid->column('id', admin_trans('player_recharge_record.fields.id'))->align('center');
            $grid->column('player_phone', admin_trans('player_recharge_record.fields.player_phone'))->display(function ($val, PlayerRechargeRecord $data) {
                $image = (isset($data->player->avatar) && !empty($data->player->avatar)) ? Avatar::create()->src($data->player->avatar) : Avatar::create()->icon(Icon::create('UserOutlined'));
                return Html::create()->content([
                    $image,
                    Html::div()->content($val)
                ]);
            })->align('center');
            $grid->column('tradeno', admin_trans('player_recharge_record.fields.tradeno'))->copy()->align('center');
            $grid->column('channel.name', admin_trans('player_recharge_record.fields.department_id'))->align('center');
            $grid->column('type', admin_trans('player_recharge_record.fields.type'))->display(function ($val) {
                switch ($val) {
                    case PlayerRechargeRecord::TYPE_ACTIVITY:
                        return Tag::create(admin_trans('player_recharge_record.type.' . $val))
                            ->color('#55acee');
                    case PlayerRechargeRecord::TYPE_REGULAR:
                        return Tag::create(admin_trans('player_recharge_record.type.' . $val))
                            ->color('#3b5999');
                    case PlayerRechargeRecord::TYPE_ARTIFICIAL:
                        return Tag::create(admin_trans('player_recharge_record.type.' . $val))
                            ->color('#cd201f');
                    default:
                        return '';
                }
            })->align('center');
            $grid->column('money', admin_trans('player_recharge_record.fields.money'))->display(function ($val, PlayerRechargeRecord $data) {
                return $val . ' ' . ($data->currency == 'TALK' ? 'Q币' : $data->currency);
            })->align('center');
            $grid->column('coins', admin_trans('player_recharge_record.fields.coins'))->align('center');
            $grid->column(function (Grid $grid) {
                $grid->column('bank_name', admin_trans('channel_recharge_method.fields.bank_name'))->copy()->align('center');
                $grid->column('sub_bank', admin_trans('channel_recharge_method.fields.sub_bank'))->copy()->align('center');
                $grid->column('owner', admin_trans('channel_recharge_method.fields.owner'))->copy()->align('center');
                $grid->column('account', admin_trans('channel_recharge_method.fields.account'))->copy()->align('center');
            }, admin_trans('channel_recharge_setting.recharge_setting_info'));
            $grid->column('status', admin_trans('player_recharge_record.fields.status'))->display(function () {
                return Tag::create(admin_trans('player_recharge_record.status_success'))->color('#87d068');
            })->align('center');
            $grid->column('finish_time', admin_trans('player_recharge_record.fields.finish_time'))->sortable()->align('center');
            $grid->column('created_at', admin_trans('player_recharge_record.fields.created_at'))->sortable()->align('center');
            $grid->hideDelete();
            $grid->hideSelection();
            $grid->actions(function (Actions $actions) {
                $actions->hideDel();
                $actions->hideEdit();
            });
            $grid->filter(function (Filter $filter) {
                $filter->eq()->select('type')
                    ->showSearch()
                    ->style(['width' => '200px'])
                    ->dropdownMatchSelectWidth()
                    ->placeholder(admin_trans('player_recharge_record.fields.type'))
                    ->options([
                        PlayerRechargeRecord::TYPE_REGULAR => admin_trans('player_recharge_record.type.' . PlayerRechargeRecord::TYPE_REGULAR),
                        PlayerRechargeRecord::TYPE_ACTIVITY => admin_trans('player_recharge_record.type.' . PlayerRechargeRecord::TYPE_ACTIVITY),
                        PlayerRechargeRecord::TYPE_ARTIFICIAL => admin_trans('player_recharge_record.type.' . PlayerRechargeRecord::TYPE_ARTIFICIAL),
                    ]);
                $filter->like()->text('tradeno')->placeholder(admin_trans('player_recharge_record.fields.tradeno'));
                $filter->between()->dateTimeRange('created_at')->placeholder([admin_trans('player_recharge_record.fields.created_at'), admin_trans('player_recharge_record.fields.created_at')]);
                $filter->between()->dateTimeRange('finish_time')->placeholder([admin_trans('player_recharge_record.fields.finish_time'), admin_trans('player_recharge_record.fields.finish_time')]);

            });
            $grid->quickSearch();
        });
    }


    /**
     * 打码量记录
     * @param $id
     * @return Grid
     */
    public function playerChipRecord($id): Grid
    {
        return Grid::create(new $this->playerChipRecord(), function (Grid $grid) use ($id) {
            $grid->title(admin_trans('player_chip_record.title'));
            $grid->bordered();
            $grid->autoHeight();
            $grid->model()->with(['channel', 'player'])
                ->where('player_id', $id)
                ->orderBy('created_at', 'desc');
            $exAdminFilter = Request::input('ex_admin_filter', []);
            $query = clone $grid->model();
            $totalData = $query->where(function ($query) use($exAdminFilter) {
                if(!empty($exAdminFilter['created_at'])) {
                    $query->whereBetween('created_at', $exAdminFilter['created_at']);
                }
            })->sum('chip_amount');
            $layout = Layout::create();
            $layout->row(function (Row $row) use ($totalData) {
                $row->gutter([10, 0]);
                $row->column(
                    Card::create([
                        Row::create()->column(Statistic::create()->value($totalData)
                            ->prefix(admin_trans('player_chip_record.fields.chip_amount'))
                            ->valueStyle([
                                'font-size' => '14px',
                                'font-weight' => '500',
                                'text-align' => 'center'
                            ])),
                    ])->bodyStyle([
                        'display' => 'flex',
                        'align-items' => 'center',
                        'height' => '30px',
                        'padding' => '0px'
                    ])->hoverable()->headStyle(['height' => '0px', 'border-bottom' => '0px', 'min-height' => '0px'])
                    , 4);
            })->style(['background' => '#fff']);
            $grid->tools([
                $layout
            ]);
            $grid->column('id', admin_trans('player_chip_record.fields.id'))->align('center');
            $grid->column('channel.name', admin_trans('channel.fields.name'))->align('center');
            $grid->column('chip_amount', admin_trans('player_chip_record.fields.chip_amount'))->display(function ($val, PlayerChipRecord $data) {
                if ($val == 0) {
                    return Html::create()->content(['+' . $val])->style(['color' => 'green']);
                }
                switch ($data->type) {
                    case PlayerChipRecord::TYPE_DEC:
                        return Html::create()->content(['-' . $val])->style(['color' => '#cd201f']);
                    default:
                        return Html::create()->content(['+' . $val])->style(['color' => 'green']);
                }
            })->align('center');
            $grid->column('must_chip_amount', admin_trans('player_chip_record.fields.must_chip_amount'))->display(function ($val, PlayerChipRecord $data) {
                if ($val == 0) {
                    return Html::create()->content(['+' . $val])->style(['color' => 'green']);
                }
                switch ($data->type) {
                    case PlayerChipRecord::TYPE_DEC:
                        return Html::create()->content(['-' . $val])->style(['color' => '#cd201f']);
                    default:
                        return Html::create()->content(['+' . $val])->style(['color' => 'green']);
                }
            })->align('center');
            $grid->column('record_type', admin_trans('player_chip_record.fields.record_type'))->display(function ($val) {
                switch ($val) {
                    case PlayerChipRecord::RECORD_TYPE_SIGN:
                    case PlayerChipRecord::RECORD_TYPE_RECHARGE:
                    case PlayerChipRecord::RECORD_TYPE_FIRST_RECHARGE_REWARD:
                        $tag = Tag::create(admin_trans('player_chip_record.record_type.' . $val))
                            ->color('#55acee');
                        break;
                    case PlayerChipRecord::RECORD_TYPE_ACTIVITY:
                    case PlayerChipRecord::RECORD_TYPE_GAME:
                    case PlayerChipRecord::RECORD_TYPE_BET_REBATE:
                        $tag = Tag::create(admin_trans('player_chip_record.record_type.' . $val))
                            ->color('#3b5999');
                        break;
                    case PlayerChipRecord::RECORD_TYPE_COMMISSION:
                    case PlayerChipRecord::RECORD_TYPE_BANKRUPTCY:
                        $tag = Tag::create(admin_trans('player_chip_record.record_type.' . $val))
                            ->color('#cd201f');
                        break;
                    default:
                        return '';
                }
                return Html::create()->content([
                    $tag,
                ]);
            })->align('center');
            $grid->column('amount', admin_trans('player_chip_record.fields.amount'))->align('center');
            $grid->column('created_at', admin_trans('player_chip_record.fields.created_at'))->sortable()->align('center');
            $grid->hideDelete();
            $grid->hideSelection();
            $grid->actions(function (Actions $actions) {
                $actions->hideDel();
                $actions->hideEdit();
            });
            $grid->filter(function (Filter $filter) {
                $filter->eq()->select('record_type')
                    ->showSearch()
                    ->style(['width' => '200px'])
                    ->dropdownMatchSelectWidth()
                    ->placeholder(admin_trans('player_chip_record.fields.record_type'))
                    ->options([
                        PlayerChipRecord::RECORD_TYPE_SIGN => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_SIGN),
                        PlayerChipRecord::RECORD_TYPE_RECHARGE => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_RECHARGE),
                        PlayerChipRecord::RECORD_TYPE_ACTIVITY => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_ACTIVITY),
                        PlayerChipRecord::RECORD_TYPE_GAME => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_GAME),
                        PlayerChipRecord::RECORD_TYPE_COMMISSION => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_COMMISSION),
                        PlayerChipRecord::RECORD_TYPE_BANKRUPTCY => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_BANKRUPTCY),
                        PlayerChipRecord::RECORD_TYPE_BET_REBATE => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_BET_REBATE),
                        PlayerChipRecord::RECORD_TYPE_FIRST_RECHARGE_REWARD => admin_trans('player_chip_record.record_type.' . PlayerChipRecord::RECORD_TYPE_FIRST_RECHARGE_REWARD),
                    ]);
                $filter->between()->dateTimeRange('created_at')->placeholder([admin_trans('player_chip_record.fields.created_at'), admin_trans('player_chip_record.fields.created_at')]);

            });
            $grid->quickSearch();
        });
    }

    /**
     * 取消转账
     * @param $id
     * @auth true
     * @return Msg
     */
    public function cancelTransfer($id): Msg
    {
        /** @var PlayerWalletTransfer $playerWalletTransfer */
        $playerWalletTransfer = PlayerWalletTransfer::query()->where('player_id', $id)->orderBy('id', 'desc')->first();
        /** @var Player $player */
        $player = Player::query()->find($id);
        if (!empty($playerWalletTransfer) && $playerWalletTransfer->type == PlayerWalletTransfer::TYPE_OUT) {
            $playerWalletTransferOut = new PlayerWalletTransfer();
            $playerWalletTransferOut->player_id = $player->id;
            $playerWalletTransferOut->platform_id = $playerWalletTransfer->platform_id;
            $playerWalletTransferOut->department_id = $player->department_id;
            $playerWalletTransferOut->type = PlayerWalletTransfer::TYPE_IN;
            $playerWalletTransferOut->amount = 0;
            $playerWalletTransferOut->reward = 0;
            $playerWalletTransferOut->platform_no = 'cancelTransfer';
            $playerWalletTransferOut->tradeno = createOrderNo();
            $playerWalletTransferOut->save();
            $playerDeliveryRecord = new PlayerDeliveryRecord;
            $playerDeliveryRecord->type = PlayerDeliveryRecord::TYPE_CANCELTRANSFER;
            //寫入金流明細
            $playerDeliveryRecord->player_id = $playerWalletTransferOut->player_id;
            $playerDeliveryRecord->department_id = $playerWalletTransferOut->department_id;
            $playerDeliveryRecord->target = $playerWalletTransferOut->getTable();
            $playerDeliveryRecord->target_id = $playerWalletTransferOut->id;
            $playerDeliveryRecord->source = 'cancel_transfer';
            $playerDeliveryRecord->amount = $playerWalletTransferOut->amount;
            $playerDeliveryRecord->amount_before = $player->wallet->money;
            $playerDeliveryRecord->amount_after = $player->wallet->money;
            $playerDeliveryRecord->tradeno = '';
            $playerDeliveryRecord->remark = '管理员取消转账，平台ID：' . $playerWalletTransfer->platform_id;
            $playerDeliveryRecord->save();
            return message_success(admin_trans('player.action_success'));
        }
        return message_error(admin_trans('player.action_error'));
    }
}