public static function table(Table $table): Table
{
return $table
->columns([
ViewColumn::make('username')
->label('Player')
->searchable(query: function (Builder $query, string $search): Builder {
$countryCodes = CountryEmojiHelper::getCountryCodesFromName($search);
return $query->where(function (Builder $subQuery) use ($search, $countryCodes) {
$subQuery->where('username', 'like', "%{$search}%")
->orWhere('minecraft_uuid', 'like', "%{$search}%")
->orWhereIn('country_code', $countryCodes);
});
})
->sortable()
->view('admin.players.columns.username'),
TextColumn::make('last_login_at')
->label('Last Login')
->sortable(),
]);
}
public static function table(Table $table): Table
{
return $table
->columns([
ViewColumn::make('username')
->label('Player')
->searchable(query: function (Builder $query, string $search): Builder {
$countryCodes = CountryEmojiHelper::getCountryCodesFromName($search);
return $query->where(function (Builder $subQuery) use ($search, $countryCodes) {
$subQuery->where('username', 'like', "%{$search}%")
->orWhere('minecraft_uuid', 'like', "%{$search}%")
->orWhereIn('country_code', $countryCodes);
});
})
->sortable()
->view('admin.players.columns.username'),
TextColumn::make('last_login_at')
->label('Last Login')
->sortable(),
]);
}