Privacy-first password manager with built-in email aliasing. Fully encrypted and self-hostable.
@page "/users"
@using AliasVault.Admin.Main.Components.Tables
@using AliasVault.Admin.Main.Utilities
@using AliasVault.Shared.Server.Services
@inject ServerSettingsService SettingsService
@inject NavigationManager NavigationManager
@inherits MainBase
<LayoutPageTitle>Users</LayoutPageTitle>
<PageHeader
BreadcrumbItems="@BreadcrumbItems"
Title="@(TotalRecords > 0 ? $"Users ({TotalRecords:N0})" : "Users")"
Description="This page shows an overview of all registered users and the associated vaults.">
<CustomActions>
<RefreshButton OnClick="() => RefreshData(CancellationToken.None)" ButtonText="Refresh" />
<LinkButton Href="users/invites" Text="+ Invite" />
</CustomActions>
</PageHeader>
@if (IsInitialized)
{
<div class="px-4">
<ResponsivePaginator CurrentPage="CurrentPage" PageSize="PageSize" TotalRecords="TotalRecords" OnPageChanged="HandlePageChanged" />
<div class="mb-3 flex space-x-4">
<div class="w-3/4">
<div class="relative">
<SearchIcon />
<input type="text" @bind-value="SearchTerm" @bind-value:event="oninput" id="search" placeholder="Search users..." class="w-full px-4 ps-10 py-2 border rounded text-sm text-gray-700 focus:outline-none focus:ring-2 focus:ring-blue-500 dark:bg-gray-700 dark:border-gray-600 dark:placeholder-gray-400 dark:text-white">
</div>
</div>
<div class="w-1/4">
<select @bind="SelectedUserFilter" class="w-full px-4 py-2 border rounded text-sm text-gray-700 focus:outline-none focus:ring-2 focus:ring-blue-500 dark:bg-gray-700 dark:border-gray-600 dark:placeholder-gray-400 dark:text-white">
<option value="">All Users</option>
<option value="active">Active Users</option>
<option value="inactive">Inactive Users</option>
<option value="blocked">Blocked Users</option>
<option value="2fa">2FA Enabled</option>
</select>
</div>
</div>
</div>
}
@if (IsLoading)
{
<LoadingIndicator />
}
else
{
<div class="px-4">
<SortableTable Columns="@_tableColumns" SortColumn="@SortColumn" SortDirection="@SortDirection" OnSortChanged="HandleSortChanged">
@foreach (var user in UserList)
{
<SortableTableRow OnClick="@(() => NavigateToUser(user.Id))">
<SortableTableColumn IsPrimary="true">@user.CreatedAt.ToString("yyyy-MM-dd HH:mm")</SortableTableColumn>
<SortableTableColumn>
<UserNameDisplay User="@user.User" AsLink="false" />
</SortableTableColumn>
<SortableTableColumn>@RelativeTimeFormatter.Format(user.LastActivityDate)</SortableTableColumn>
<SortableTableColumn>@user.CredentialCount</SortableTableColumn>
<SortableTableColumn>@user.EmailClaimCount</SortableTableColumn>
<SortableTableColumn>@StatisticsService.FormatKilobytes(user.VaultStorageInKb)</SortableTableColumn>
</SortableTableRow>
}
</SortableTable>
</div>
}
@code {
private readonly List<TableColumn> _tableColumns = [
new TableColumn { Title = "Registered (UTC)", PropertyName = "CreatedAt" },
new TableColumn { Title = "Username", PropertyName = "UserName" },
new TableColumn { Title = "Last Activity", PropertyName = "LastActivityDate" },
new TableColumn { Title = "# Credentials", PropertyName = "CredentialCount" },
new TableColumn { Title = "# Email aliases", PropertyName = "EmailClaimCount" },
new TableColumn { Title = "Storage", PropertyName = "VaultStorageInKb" },
];
private List<UserViewModel> UserList { get; set; } = [];
private bool IsInitialized { get; set; } = false;
private bool IsLoading { get; set; } = true;
private int CurrentPage { get; set; } = 1;
private int PageSize { get; set; } = 50;
private int TotalRecords { get; set; }
private string _searchTerm = string.Empty;
private CancellationTokenSource? _searchCancellationTokenSource;
/// <summary>
/// The last search term.
/// </summary>
private string _lastSearchTerm = string.Empty;
private string SearchTerm
{
get => _searchTerm;
set
{
if (_searchTerm != value)
{
_searchTerm = value;
_searchCancellationTokenSource?.Cancel();
_searchCancellationTokenSource = new CancellationTokenSource();
_ = RefreshData(_searchCancellationTokenSource.Token);
}
}
}
private string _selectedUserFilter = string.Empty;
private string _lastSelectedUserFilter = string.Empty;
private string SelectedUserFilter
{
get => _selectedUserFilter;
set
{
if (_selectedUserFilter != value)
{
_selectedUserFilter = value;
_searchCancellationTokenSource?.Cancel();
_searchCancellationTokenSource = new CancellationTokenSource();
_ = RefreshData(_searchCancellationTokenSource.Token);
}
}
}
private string SortColumn { get; set; } = "CreatedAt";
private SortDirection SortDirection { get; set; } = SortDirection.Descending;
private async Task HandleSortChanged((string column, SortDirection direction) sort)
{
SortColumn = sort.column;
SortDirection = sort.direction;
await RefreshData(CancellationToken.None);
}
private void NavigateToUser(string userId)
{
NavigationManager.NavigateTo($"users/{userId}");
}
/// <inheritdoc />
protected override async Task OnInitializedAsync()
{
await base.OnInitializedAsync();
BreadcrumbItems.Add(new BreadcrumbItem { DisplayName = "Users" });
}
/// <inheritdoc />
protected override async Task OnAfterRenderAsync(bool firstRender)
{
if (firstRender)
{
await RefreshData(CancellationToken.None);
}
}
private void HandlePageChanged(int newPage)
{
CurrentPage = newPage;
_ = RefreshData(CancellationToken.None);
}
private async Task RefreshData(CancellationToken cancellationToken = default)
{
try
{
IsLoading = true;
StateHasChanged();
var settings = await SettingsService.GetAllSettingsAsync();
var inactivityCutoffDate = settings.MarkUserInactiveAfterDays > 0 ? DateTime.UtcNow.AddDays(-settings.MarkUserInactiveAfterDays) : (DateTime?)null;
await using var dbContext = await DbContextFactory.CreateDbContextAsync(cancellationToken);
var query = dbContext.AliasVaultUsers.WithVaultStorage(dbContext);
query = ApplySearchFilter(query);
query = ApplyUserFilter(query, inactivityCutoffDate);
query = ApplySort(query, dbContext);
TotalRecords = await query.CountAsync(cancellationToken);
var users = await query
.Skip((CurrentPage - 1) * PageSize)
.Take(PageSize)
.Select(x => new
{
x.User.Id,
x.User.UserName,
x.User.CreatedAt,
x.User.TwoFactorEnabled,
x.User.Blocked,
x.User.LastActivityDate,
x.VaultStorageKb,
CredentialCount = dbContext.VaultManifests.Where(m => m.OwnerGroupId == x.User.PersonalGroupId).Sum(m => m.CredentialsCount),
EmailClaimCount = dbContext.EmailClaims.Count(c => c.State != EmailClaimState.Removed && c.VaultManifest!.OwnerGroupId == x.User.PersonalGroupId),
})
.ToListAsync(cancellationToken);
if (cancellationToken.IsCancellationRequested)
{
return;
}
UserList = users.Select(user =>
{
var lastActivity = user.LastActivityDate ?? user.CreatedAt;
var isInactive = inactivityCutoffDate.HasValue && lastActivity < inactivityCutoffDate.Value;
return new UserViewModel
{
Id = user.Id,
User = new UserDisplay
{
UserId = user.Id,
UserName = user.UserName?.ToLower() ?? "N/A",
Blocked = user.Blocked,
IsInactive = isInactive,
TwoFactorEnabled = user.TwoFactorEnabled,
},
CreatedAt = user.CreatedAt,
LastActivityDate = user.LastActivityDate,
CredentialCount = user.CredentialCount,
EmailClaimCount = user.EmailClaimCount,
VaultStorageInKb = user.VaultStorageKb,
};
}).ToList();
IsLoading = false;
IsInitialized = true;
StateHasChanged();
}
catch (OperationCanceledException)
{
// Expected when cancellation is requested, do nothing
}
}
/// <summary>
/// Apply search filter to the query.
/// </summary>
private IQueryable<UserWithVaultStorage> ApplySearchFilter(IQueryable<UserWithVaultStorage> query)
{
if (SearchTerm.Length > 0)
{
// Reset page number back to 1 if the search term has changed.
if (SearchTerm != _lastSearchTerm && CurrentPage != 1)
{
CurrentPage = 1;
}
_lastSearchTerm = SearchTerm;
var searchTerm = SearchTerm.Trim().ToLower();
query = query.Where(x => EF.Functions.Like(x.User.UserName!.ToLower(), "%" + searchTerm + "%"));
}
return query;
}
/// <summary>
/// Apply user filter to the query.
/// </summary>
private IQueryable<UserWithVaultStorage> ApplyUserFilter(IQueryable<UserWithVaultStorage> query, DateTime? inactivityCutoffDate)
{
if (!string.IsNullOrEmpty(SelectedUserFilter))
{
// Reset page number back to 1 if the filter has changed.
if (SelectedUserFilter != _lastSelectedUserFilter && CurrentPage != 1)
{
CurrentPage = 1;
}
_lastSelectedUserFilter = SelectedUserFilter;
switch (SelectedUserFilter)
{
case "active":
if (inactivityCutoffDate.HasValue)
{
query = query.Where(x => x.User.LastActivityDate >= inactivityCutoffDate.Value || (x.User.LastActivityDate == null && x.User.CreatedAt >= inactivityCutoffDate.Value));
}
query = query.Where(x => !x.User.Blocked);
break;
case "inactive":
if (inactivityCutoffDate.HasValue)
{
query = query.Where(x => (x.User.LastActivityDate != null && x.User.LastActivityDate < inactivityCutoffDate.Value) || (x.User.LastActivityDate == null && x.User.CreatedAt < inactivityCutoffDate.Value));
}
else
{
// If MarkUserInactiveAfterDays is 0, no users are considered inactive
query = query.Where(x => false);
}
break;
case "blocked":
query = query.Where(x => x.User.Blocked);
break;
case "2fa":
query = query.Where(x => x.User.TwoFactorEnabled);
break;
}
}
return query;
}
/// <summary>
/// Apply sort to the query.
/// </summary>
private IQueryable<UserWithVaultStorage> ApplySort(IQueryable<UserWithVaultStorage> query, AliasServerDbContext dbContext)
{
var ascending = SortDirection == SortDirection.Ascending;
return SortColumn switch
{
"CreatedAt" => ascending ? query.OrderBy(x => x.User.CreatedAt) : query.OrderByDescending(x => x.User.CreatedAt),
"UserName" => ascending ? query.OrderBy(x => x.User.UserName) : query.OrderByDescending(x => x.User.UserName),
"LastActivityDate" => ascending ? query.OrderBy(x => x.User.LastActivityDate ?? x.User.CreatedAt) : query.OrderByDescending(x => x.User.LastActivityDate ?? x.User.CreatedAt),
"CredentialCount" => ascending
? query.OrderBy(x => dbContext.VaultManifests.Where(m => m.OwnerGroupId == x.User.PersonalGroupId).Sum(m => m.CredentialsCount))
: query.OrderByDescending(x => dbContext.VaultManifests.Where(m => m.OwnerGroupId == x.User.PersonalGroupId).Sum(m => m.CredentialsCount)),
"EmailClaimCount" => ascending
? query.OrderBy(x => dbContext.EmailClaims.Count(c => c.State != EmailClaimState.Removed && c.VaultManifest!.OwnerGroupId == x.User.PersonalGroupId))
: query.OrderByDescending(x => dbContext.EmailClaims.Count(c => c.State != EmailClaimState.Removed && c.VaultManifest!.OwnerGroupId == x.User.PersonalGroupId)),
"VaultStorageInKb" => ascending ? query.OrderBy(x => x.VaultStorageKb) : query.OrderByDescending(x => x.VaultStorageKb),
_ => ascending ? query.OrderBy(x => x.User.Id) : query.OrderByDescending(x => x.User.Id),
};
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
_searchCancellationTokenSource?.Cancel();
_searchCancellationTokenSource?.Dispose();
}
base.Dispose(disposing);
}
}