column('id', 'ID')->sortable(); $grid->column('buy_order_id', '买单ID')->link(function ($value) { return $value ? admin_url("mex-orders/{$value}") : '-'; }); $grid->column('sell_order_id', '卖单ID')->link(function ($value) { return $value ? admin_url("mex-orders/{$value}") : '-'; }); $grid->column('buyer_id', '买方ID')->link(function ($value) { return admin_url("users/{$value}"); }); $grid->column('seller_id', '卖方ID')->link(function ($value) { return admin_url("users/{$value}"); }); $grid->column('item_id', '商品ID')->link(function ($value) { return admin_url("game-items/{$value}"); }); $grid->column('quantity', '数量'); $grid->column('price', '单价')->display(function ($value) { return number_format($value, 5); }); $grid->column('total_amount', '总金额')->display(function ($value) { return number_format($value, 5); }); $grid->column('transaction_type', '交易类型')->display(function ($value) { return $value instanceof TransactionType ? $value->getDescription() : TransactionType::from($value)->getDescription(); })->label([ 'USER_SELL' => 'success', 'USER_BUY' => 'primary', 'ADMIN_INJECT' => 'warning', 'ADMIN_RECYCLE' => 'info', ]); $grid->column('is_admin_operation', '管理员操作')->bool(); $grid->column('admin_user_id', '管理员ID')->display(function ($value) { return $value ?: '-'; }); $grid->column('created_at', '成交时间')->sortable(); // 禁用新增、编辑和删除 $grid->disableCreateButton(); $grid->disableEditButton(); $grid->disableDeleteButton(); // 筛选器 $grid->filter(function (Grid\Filter $filter) { $filter->equal('id', 'ID'); $filter->equal('buy_order_id', '买单ID'); $filter->equal('sell_order_id', '卖单ID'); $filter->equal('buyer_id', '买方ID'); $filter->equal('seller_id', '卖方ID'); $filter->equal('item_id', '商品ID'); $filter->between('quantity', '数量范围'); $filter->between('price', '价格范围'); $filter->between('total_amount', '总金额范围'); $filter->equal('transaction_type', '交易类型')->select(TransactionType::getAll()); $filter->equal('is_admin_operation', '管理员操作')->select([ 1 => '是', 0 => '否', ]); $filter->equal('admin_user_id', '管理员ID'); $filter->between('created_at', '成交时间')->datetime(); }); // 默认排序 $grid->model()->orderBy('created_at', 'desc'); // 统计信息 $grid->tools(function (Grid\Tools $tools) { $tools->append('