snipe
41 lines
1.4 KiB
PHP
41 lines
1.4 KiB
PHP
<?php
|
|
|
|
namespace App\Livewire;
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
use Livewire\Component;
|
|
|
|
/**
|
|
* Livewire component for the admin-facing User API Tokens (Personal Access Tokens) table.
|
|
* Displays all personal access tokens across all users, used on the Settings > OAuth page.
|
|
*/
|
|
class AdminPersonalAccessTokens extends Component
|
|
{
|
|
public function render()
|
|
{
|
|
$tokens = DB::table('oauth_access_tokens')
|
|
->join('oauth_clients', 'oauth_access_tokens.client_id', '=', 'oauth_clients.id')
|
|
->leftJoin('users', 'oauth_access_tokens.user_id', '=', 'users.id')
|
|
->where('oauth_clients.personal_access_client', true)
|
|
->select([
|
|
'oauth_access_tokens.id',
|
|
'oauth_access_tokens.name',
|
|
'oauth_access_tokens.revoked',
|
|
'oauth_access_tokens.created_at',
|
|
'oauth_access_tokens.expires_at',
|
|
'oauth_access_tokens.user_id as token_user_id',
|
|
'oauth_clients.name as client_name',
|
|
'users.id as existing_user_id',
|
|
'users.username as username',
|
|
'users.display_name as display_name',
|
|
'users.deleted_at as user_deleted_at',
|
|
])
|
|
->orderByDesc('oauth_access_tokens.created_at')
|
|
->get();
|
|
|
|
return view('livewire.admin-personal-access-tokens', [
|
|
'tokens' => $tokens,
|
|
]);
|
|
}
|
|
}
|