Skip to content

Privacy-first password manager with built-in email aliasing. Fully encrypted and self-hostable.

13.7 KB
Raw Blame
@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);
    }

}