From 2cfcb9ac0cfae50aa1a5be456fa6178cb4a2aaef Mon Sep 17 00:00:00 2001 From: Ethan Pippin Date: Thu, 12 Nov 2026 00:42:03 -0500 Subject: Years, Ratings for filters endpoints --- .../Item/BaseItemRepository.Querying.cs | 60 +++++++++++++++++----- 1 file changed, 46 insertions(+), 14 deletions(-) (limited to 'Jellyfin.Server.Implementations') diff --git a/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs b/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs index 8d573569e9..a46cd9ab99 100644 --- a/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs +++ b/Jellyfin.Server.Implementations/Item/BaseItemRepository.Querying.cs @@ -600,7 +600,7 @@ public sealed partial class BaseItemRepository } /// - public QueryFiltersLegacy GetQueryFiltersLegacy(InternalItemsQuery filter) + public IReadOnlyList GetYears(InternalItemsQuery filter) { ArgumentNullException.ThrowIfNull(filter); PrepareFilterQuery(filter); @@ -608,22 +608,34 @@ public sealed partial class BaseItemRepository using var context = _dbProvider.CreateDbContext(); var baseQuery = PrepareItemQuery(context, filter); baseQuery = TranslateQuery(baseQuery, context, filter); + return GetYears(baseQuery); + } - var matchingItemIds = baseQuery.Select(e => e.Id); + /// + public IReadOnlyList GetOfficialRatings(InternalItemsQuery filter) + { + ArgumentNullException.ThrowIfNull(filter); + PrepareFilterQuery(filter); - var years = baseQuery - .Where(e => e.ProductionYear != null && e.ProductionYear > 0) - .Select(e => e.ProductionYear!.Value) - .Distinct() - .OrderBy(y => y) - .ToArray(); + using var context = _dbProvider.CreateDbContext(); + var baseQuery = PrepareItemQuery(context, filter); + baseQuery = TranslateQuery(baseQuery, context, filter); + return GetOfficialRatings(baseQuery); + } - var officialRatings = baseQuery - .Where(e => e.OfficialRating != null && e.OfficialRating != string.Empty) - .Select(e => e.OfficialRating!) - .Distinct() - .OrderBy(r => r) - .ToArray(); + /// + public QueryFiltersLegacy GetQueryFiltersLegacy(InternalItemsQuery filter) + { + ArgumentNullException.ThrowIfNull(filter); + PrepareFilterQuery(filter); + + using var context = _dbProvider.CreateDbContext(); + var baseQuery = PrepareItemQuery(context, filter); + baseQuery = TranslateQuery(baseQuery, context, filter); + + var matchingItemIds = baseQuery.Select(e => e.Id); + var years = GetYears(baseQuery); + var officialRatings = GetOfficialRatings(baseQuery); var tags = context.ItemValuesMap .Join( @@ -659,4 +671,24 @@ public sealed partial class BaseItemRepository Genres = genres }; } + + private static IReadOnlyList GetYears(IQueryable query) + { + return query + .Where(e => e.ProductionYear != null && e.ProductionYear > 0) + .Select(e => e.ProductionYear!.Value) + .Distinct() + .OrderBy(y => y) + .ToArray(); + } + + private static IReadOnlyList GetOfficialRatings(IQueryable query) + { + return query + .Where(e => e.OfficialRating != null && e.OfficialRating != string.Empty) + .Select(e => e.OfficialRating!) + .Distinct() + .OrderBy(r => r) + .ToArray(); + } } -- cgit v1.2.3