| | | 1 | | using System; |
| | | 2 | | using System.Linq; |
| | | 3 | | using System.Linq.Expressions; |
| | | 4 | | using Jellyfin.Data.Enums; |
| | | 5 | | using Jellyfin.Database.Implementations.Entities; |
| | | 6 | | using MediaBrowser.Controller.Entities; |
| | | 7 | | using Microsoft.EntityFrameworkCore; |
| | | 8 | | |
| | | 9 | | namespace Jellyfin.Server.Implementations.Item; |
| | | 10 | | |
| | | 11 | | /// <summary> |
| | | 12 | | /// Static class for methods which maps types of ordering to their respecting ordering functions. |
| | | 13 | | /// </summary> |
| | | 14 | | public static class OrderMapper |
| | | 15 | | { |
| | | 16 | | /// <summary> |
| | | 17 | | /// Creates Func to be executed later with a given BaseItemEntity input for sorting items on query. |
| | | 18 | | /// </summary> |
| | | 19 | | /// <param name="sortBy">Item property to sort by.</param> |
| | | 20 | | /// <param name="query">Context Query.</param> |
| | | 21 | | /// <returns>Func to be executed later for sorting query.</returns> |
| | | 22 | | public static Expression<Func<BaseItemEntity, object?>> MapOrderByField(ItemSortBy sortBy, InternalItemsQuery query) |
| | | 23 | | { |
| | 124 | 24 | | return sortBy switch |
| | 124 | 25 | | { |
| | 0 | 26 | | ItemSortBy.AirTime => e => e.SortName, // TODO |
| | 0 | 27 | | ItemSortBy.Runtime => e => e.RunTimeTicks, |
| | 46 | 28 | | ItemSortBy.Random => e => EF.Functions.Random(), |
| | 1 | 29 | | ItemSortBy.DatePlayed => e => e.UserData!.FirstOrDefault(f => f.UserId.Equals(query.User!.Id))!.LastPlayedDa |
| | 0 | 30 | | ItemSortBy.PlayCount => e => e.UserData!.FirstOrDefault(f => f.UserId.Equals(query.User!.Id))!.PlayCount, |
| | 0 | 31 | | ItemSortBy.IsFavoriteOrLiked => e => e.UserData!.FirstOrDefault(f => f.UserId.Equals(query.User!.Id))!.IsFav |
| | 38 | 32 | | ItemSortBy.IsFolder => e => e.IsFolder, |
| | 0 | 33 | | ItemSortBy.IsPlayed => e => e.UserData!.FirstOrDefault(f => f.UserId.Equals(query.User!.Id))!.Played, |
| | 0 | 34 | | ItemSortBy.IsUnplayed => e => !e.UserData!.FirstOrDefault(f => f.UserId.Equals(query.User!.Id))!.Played, |
| | 0 | 35 | | ItemSortBy.DateLastContentAdded => e => e.DateLastMediaAdded, |
| | 0 | 36 | | ItemSortBy.Artist => e => e.ItemValues!.Where(f => f.ItemValue.Type == ItemValueType.Artist).Select(f => f.I |
| | 0 | 37 | | ItemSortBy.AlbumArtist => e => e.ItemValues!.Where(f => f.ItemValue.Type == ItemValueType.AlbumArtist).Selec |
| | 0 | 38 | | ItemSortBy.Studio => e => e.ItemValues!.Where(f => f.ItemValue.Type == ItemValueType.Studios).Select(f => f. |
| | 0 | 39 | | ItemSortBy.OfficialRating => e => e.InheritedParentalRatingValue, |
| | 124 | 40 | | // ItemSortBy.SeriesDatePlayed => "(Select MAX(LastPlayedDate) from TypedBaseItems B" + GetJoinUserDataText( |
| | 0 | 41 | | ItemSortBy.SeriesSortName => e => e.SeriesName, |
| | 124 | 42 | | // ItemSortBy.AiredEpisodeOrder => "AiredEpisodeOrder", |
| | 0 | 43 | | ItemSortBy.Album => e => e.Album, |
| | 0 | 44 | | ItemSortBy.DateCreated => e => e.DateCreated, |
| | 1 | 45 | | ItemSortBy.PremiereDate => e => (e.PremiereDate ?? (e.ProductionYear.HasValue ? DateTime.MinValue.AddYears(e |
| | 0 | 46 | | ItemSortBy.StartDate => e => e.StartDate, |
| | 0 | 47 | | ItemSortBy.Name => e => e.Name, |
| | 0 | 48 | | ItemSortBy.CommunityRating => e => e.CommunityRating, |
| | 0 | 49 | | ItemSortBy.ProductionYear => e => e.ProductionYear, |
| | 0 | 50 | | ItemSortBy.CriticRating => e => e.CriticRating, |
| | 0 | 51 | | ItemSortBy.VideoBitRate => e => e.TotalBitrate, |
| | 0 | 52 | | ItemSortBy.ParentIndexNumber => e => e.ParentIndexNumber, |
| | 0 | 53 | | ItemSortBy.IndexNumber => e => e.IndexNumber, |
| | 38 | 54 | | _ => e => e.SortName |
| | 124 | 55 | | }; |
| | | 56 | | } |
| | | 57 | | } |