aboutsummaryrefslogtreecommitdiff
path: root/MediaBrowser.Api/Reports/ReportsService.cs
diff options
context:
space:
mode:
Diffstat (limited to 'MediaBrowser.Api/Reports/ReportsService.cs')
-rw-r--r--MediaBrowser.Api/Reports/ReportsService.cs1183
1 files changed, 1141 insertions, 42 deletions
diff --git a/MediaBrowser.Api/Reports/ReportsService.cs b/MediaBrowser.Api/Reports/ReportsService.cs
index 45bc4a889..b13e5628c 100644
--- a/MediaBrowser.Api/Reports/ReportsService.cs
+++ b/MediaBrowser.Api/Reports/ReportsService.cs
@@ -1,64 +1,1163 @@
-using MediaBrowser.Controller.Entities;
+using MediaBrowser.Controller.Dto;
+using MediaBrowser.Controller.Entities;
using MediaBrowser.Controller.Library;
using MediaBrowser.Model.Querying;
+using System.Collections.Generic;
using System.Threading.Tasks;
+using System.Globalization;
+using System.Linq;
+using MediaBrowser.Model.Dto;
+using MediaBrowser.Controller.Localization;
+using MediaBrowser.Controller.Entities.Movies;
+using MediaBrowser.Controller.Persistence;
+using MediaBrowser.Api.UserLibrary;
+using MediaBrowser.Controller.Collections;
+using MediaBrowser.Controller.Entities.TV;
+using System;
+using MediaBrowser.Controller.Entities.Audio;
+using MediaBrowser.Model.Entities;
+using MediaBrowser.Controller.Net;
+using MediaBrowser.Model.Activity;
+using MediaBrowser.Controller.Activity;
+using System.IO;
+using System.Text;
namespace MediaBrowser.Api.Reports
{
- public class ReportsService : BaseApiService
- {
- private readonly ILibraryManager _libraryManager;
+ /// <summary> The reports service. </summary>
+ /// <seealso cref="T:MediaBrowser.Api.BaseApiService"/>
+ public class ReportsService : BaseApiService
+ {
- public ReportsService(ILibraryManager libraryManager)
- {
- _libraryManager = libraryManager;
- }
- public async Task<object> Get(GetItemReport request)
- {
- var queryResult = await GetQueryResult(request).ConfigureAwait(false);
+ /// <summary> Manager for user. </summary>
+ private readonly IUserManager _userManager;
- var reportResult = GetReportResult(queryResult);
+ /// <summary> Manager for library. </summary>
+ private readonly ILibraryManager _libraryManager;
+ /// <summary> The localization. </summary>
+ private readonly ILocalizationManager _localization;
- return ToOptimizedResult(reportResult);
- }
+ /// <summary>
+ /// Initializes a new instance of the MediaBrowser.Api.Reports.ReportsService class. </summary>
+ /// <param name="userManager"> Manager for user. </param>
+ /// <param name="libraryManager"> Manager for library. </param>
+ /// <param name="localization"> The localization. </param>
+ public ReportsService(IUserManager userManager, ILibraryManager libraryManager, ILocalizationManager localization)
+ {
+ _userManager = userManager;
+ _libraryManager = libraryManager;
+ _localization = localization;
+ }
- private ReportResult GetReportResult(QueryResult<BaseItem> queryResult)
- {
- var reportResult = new ReportResult();
+ /// <summary> Gets the given request. </summary>
+ /// <param name="request"> The request. </param>
+ /// <returns> A Task&lt;object&gt; </returns>
+ public async Task<object> Get(GetReportHeaders request)
+ {
+ if (string.IsNullOrEmpty(request.IncludeItemTypes))
+ return null;
- // Fill rows and columns
+ ReportViewType reportRowType = ReportHelper.GetRowType(request.IncludeItemTypes);
+ ReportBuilder reportBuilder = new ReportBuilder(_libraryManager);
+ var reportResult = reportBuilder.GetReportHeaders(reportRowType, request);
- return reportResult;
- }
+ return ToOptimizedResult(reportResult);
- private Task<QueryResult<BaseItem>> GetQueryResult(BaseReportRequest request)
- {
- // Placeholder in case needed later
- User user = null;
+ }
- var parentItem = string.IsNullOrEmpty(request.ParentId) ?
- (user == null ? _libraryManager.RootFolder : user.RootFolder) :
- _libraryManager.GetItemById(request.ParentId);
+ /// <summary> Gets the given request. </summary>
+ /// <param name="request"> The request. </param>
+ /// <returns> A Task&lt;object&gt; </returns>
+ public async Task<object> Get(GetItemReport request)
+ {
+ if (string.IsNullOrEmpty(request.IncludeItemTypes))
+ return null;
- return ((Folder)parentItem).GetItems(GetItemsQuery(request, user));
- }
+ var reportResult = await GetReportResult(request);
- private InternalItemsQuery GetItemsQuery(BaseReportRequest request, User user)
- {
- var query = new InternalItemsQuery
- {
- User = user,
- CollapseBoxSetItems = false
- };
+ return ToOptimizedResult(reportResult);
+ }
- // Set query values based on request
+ /// <summary> Gets the given request. </summary>
+ /// <param name="request"> The request. </param>
+ /// <returns> A Task&lt;object&gt; </returns>
+ public async Task<object> Get(GetReportDownload request)
+ {
+ if (string.IsNullOrEmpty(request.IncludeItemTypes))
+ return null;
- // Example
- //query.IncludeItemTypes = new[] {"Movie"};
+ var headers = new Dictionary<string, string>();
+ string fileExtension = "csv";
+ string contentType = "text/plain;charset='utf-8'";
+ switch (request.ExportType)
+ {
+ case ReportExportType.CSV:
+ break;
+ case ReportExportType.Excel:
+ contentType = "application/vnd.ms-excel";
+ fileExtension = "xls";
+ break;
+ }
- return query;
- }
- }
+ var filename = "ReportExport." + fileExtension;
+ headers["Content-Disposition"] = string.Format("attachment; filename=\"{0}\"", filename);
+ headers["Content-Encoding"] = "UTF-8";
+
+ ReportViewType reportRowType = ReportHelper.GetRowType(request.IncludeItemTypes);
+ ReportBuilder reportBuilder = new ReportBuilder(_libraryManager);
+ QueryResult<BaseItem> queryResult = await GetQueryResult(request).ConfigureAwait(false);
+ ReportResult reportResult = reportBuilder.GetReportResult(queryResult.Items, reportRowType, request);
+
+ reportResult.TotalRecordCount = queryResult.TotalRecordCount;
+
+ string result = string.Empty;
+ switch (request.ExportType)
+ {
+ case ReportExportType.CSV:
+ result = new ReportExport().ExportToCsv(reportResult);
+ break;
+ case ReportExportType.Excel:
+ result = new ReportExport().ExportToExcel(reportResult);
+ break;
+ }
+
+ object ro = ResultFactory.GetResult(result, contentType, headers);
+ return ro;
+ }
+
+ /// <summary> Gets the given request. </summary>
+ /// <param name="request"> The request. </param>
+ /// <returns> A Task&lt;object&gt; </returns>
+ public async Task<object> Get(GetReportStatistics request)
+ {
+ if (string.IsNullOrEmpty(request.IncludeItemTypes))
+ return null;
+ var reportResult = await GetReportStatistic(request);
+
+ return ToOptimizedResult(reportResult);
+ }
+
+ /// <summary> Gets report statistic. </summary>
+ /// <param name="request"> The request. </param>
+ /// <returns> The report statistic. </returns>
+ private async Task<ReportStatResult> GetReportStatistic(GetReportStatistics request)
+ {
+ ReportViewType reportRowType = ReportHelper.GetRowType(request.IncludeItemTypes);
+ QueryResult<BaseItem> queryResult = await GetQueryResult(request).ConfigureAwait(false);
+
+ ReportStatBuilder reportBuilder = new ReportStatBuilder(_libraryManager);
+ ReportStatResult reportResult = reportBuilder.GetReportStatResult(queryResult.Items, ReportHelper.GetRowType(request.IncludeItemTypes), request.TopItems ?? 5);
+ reportResult.TotalRecordCount = reportResult.Groups.Count();
+ return reportResult;
+ }
+
+ /// <summary> Gets report result. </summary>
+ /// <param name="request"> The request. </param>
+ /// <returns> The report result. </returns>
+ private async Task<ReportResult> GetReportResult(GetItemReport request)
+ {
+
+ ReportViewType reportRowType = ReportHelper.GetRowType(request.IncludeItemTypes);
+ ReportBuilder reportBuilder = new ReportBuilder(_libraryManager);
+ QueryResult<BaseItem> queryResult = await GetQueryResult(request).ConfigureAwait(false);
+ ReportResult reportResult = reportBuilder.GetReportResult(queryResult.Items, reportRowType, request);
+ reportResult.TotalRecordCount = queryResult.TotalRecordCount;
+
+ return reportResult;
+ }
+
+ /// <summary> Gets query result. </summary>
+ /// <param name="request"> The request. </param>
+ /// <returns> The query result. </returns>
+ private async Task<QueryResult<BaseItem>> GetQueryResult(BaseReportRequest request)
+ {
+ // Placeholder in case needed later
+ request.Recursive = true;
+ var user = request.UserId.HasValue ? _userManager.GetUserById(request.UserId.Value) : null;
+ request.Fields = "MediaSources,DateCreated,Settings,Studios,SyncInfo,ItemCounts";
+
+ var parentItem = string.IsNullOrEmpty(request.ParentId) ?
+ (user == null ? _libraryManager.RootFolder : user.RootFolder) :
+ _libraryManager.GetItemById(request.ParentId);
+
+ var item = string.IsNullOrEmpty(request.ParentId) ?
+ user == null ? _libraryManager.RootFolder : user.RootFolder :
+ parentItem;
+
+ IEnumerable<BaseItem> items;
+
+ if (request.Recursive)
+ {
+ var result = await ((Folder)item).GetItems(GetItemsQuery(request, user)).ConfigureAwait(false);
+ return result;
+ }
+ else
+ {
+ if (user == null)
+ {
+ var result = await ((Folder)item).GetItems(GetItemsQuery(request, null)).ConfigureAwait(false);
+ return result;
+ }
+
+ var userRoot = item as UserRootFolder;
+
+ if (userRoot == null)
+ {
+ var result = await ((Folder)item).GetItems(GetItemsQuery(request, user)).ConfigureAwait(false);
+
+ return result;
+ }
+
+ items = ((Folder)item).GetChildren(user, true);
+ }
+
+ return new QueryResult<BaseItem> { Items = items.ToArray() };
+
+ }
+
+ /// <summary> Gets items query. </summary>
+ /// <param name="request"> The request. </param>
+ /// <param name="user"> The user. </param>
+ /// <returns> The items query. </returns>
+ private InternalItemsQuery GetItemsQuery(BaseReportRequest request, User user)
+ {
+ var query = new InternalItemsQuery
+ {
+ User = user,
+ IsPlayed = request.IsPlayed,
+ MediaTypes = request.GetMediaTypes(),
+ IncludeItemTypes = request.GetIncludeItemTypes(),
+ ExcludeItemTypes = request.GetExcludeItemTypes(),
+ Recursive = true,
+ SortBy = request.GetOrderBy(),
+ SortOrder = request.SortOrder ?? SortOrder.Ascending,
+
+ Filter = i => ApplyAdditionalFilters(request, i, user, true, _libraryManager),
+ StartIndex = request.StartIndex,
+ IsMissing = request.IsMissing,
+ IsVirtualUnaired = request.IsVirtualUnaired,
+ IsUnaired = request.IsUnaired,
+ CollapseBoxSetItems = request.CollapseBoxSetItems,
+ NameLessThan = request.NameLessThan,
+ NameStartsWith = request.NameStartsWith,
+ NameStartsWithOrGreater = request.NameStartsWithOrGreater,
+ HasImdbId = request.HasImdbId,
+ IsYearMismatched = request.IsYearMismatched,
+ IsUnidentified = request.IsUnidentified,
+ IsPlaceHolder = request.IsPlaceHolder,
+ IsLocked = request.IsLocked,
+ IsInBoxSet = request.IsInBoxSet,
+ IsHD = request.IsHD,
+ Is3D = request.Is3D,
+ HasTvdbId = request.HasTvdbId,
+ HasTmdbId = request.HasTmdbId,
+ HasOverview = request.HasOverview,
+ HasOfficialRating = request.HasOfficialRating,
+ HasParentalRating = request.HasParentalRating,
+ HasSpecialFeature = request.HasSpecialFeature,
+ HasSubtitles = request.HasSubtitles,
+ HasThemeSong = request.HasThemeSong,
+ HasThemeVideo = request.HasThemeVideo,
+ HasTrailer = request.HasTrailer,
+ Tags = request.GetTags(),
+ OfficialRatings = request.GetOfficialRatings(),
+ Genres = request.GetGenres(),
+ Studios = request.GetStudios(),
+ StudioIds = request.GetStudioIds(),
+ Person = request.Person,
+ PersonIds = request.GetPersonIds(),
+ PersonTypes = request.GetPersonTypes(),
+ Years = request.GetYears(),
+ ImageTypes = request.GetImageTypes().ToArray(),
+ VideoTypes = request.GetVideoTypes().ToArray(),
+ AdjacentTo = request.AdjacentTo
+ };
+
+ if (!string.IsNullOrWhiteSpace(request.Ids))
+ {
+ query.CollapseBoxSetItems = false;
+ }
+
+ foreach (var filter in request.GetFilters())
+ {
+ switch (filter)
+ {
+ case ItemFilter.Dislikes:
+ query.IsLiked = false;
+ break;
+ case ItemFilter.IsFavorite:
+ query.IsFavorite = true;
+ break;
+ case ItemFilter.IsFavoriteOrLikes:
+ query.IsFavoriteOrLiked = true;
+ break;
+ case ItemFilter.IsFolder:
+ query.IsFolder = true;
+ break;
+ case ItemFilter.IsNotFolder:
+ query.IsFolder = false;
+ break;
+ case ItemFilter.IsPlayed:
+ query.IsPlayed = true;
+ break;
+ case ItemFilter.IsRecentlyAdded:
+ break;
+ case ItemFilter.IsResumable:
+ query.IsResumable = true;
+ break;
+ case ItemFilter.IsUnplayed:
+ query.IsPlayed = false;
+ break;
+ case ItemFilter.Likes:
+ query.IsLiked = true;
+ break;
+ }
+ }
+
+ if (request.HasQueryLimit)
+ query.Limit = request.Limit;
+ return query;
+ }
+
+ /// <summary> Applies filtering. </summary>
+ /// <param name="items"> The items. </param>
+ /// <param name="filter"> The filter. </param>
+ /// <param name="user"> The user. </param>
+ /// <param name="repository"> The repository. </param>
+ /// <returns> IEnumerable{BaseItem}. </returns>
+ internal static IEnumerable<BaseItem> ApplyFilter(IEnumerable<BaseItem> items, ItemFilter filter, User user, IUserDataManager repository)
+ {
+ // Avoid implicitly captured closure
+ var currentUser = user;
+
+ switch (filter)
+ {
+ case ItemFilter.IsFavoriteOrLikes:
+ return items.Where(item =>
+ {
+ var userdata = repository.GetUserData(user.Id, item.GetUserDataKey());
+
+ if (userdata == null)
+ {
+ return false;
+ }
+
+ var likes = userdata.Likes ?? false;
+ var favorite = userdata.IsFavorite;
+
+ return likes || favorite;
+ });
+
+ case ItemFilter.Likes:
+ return items.Where(item =>
+ {
+ var userdata = repository.GetUserData(user.Id, item.GetUserDataKey());
+
+ return userdata != null && userdata.Likes.HasValue && userdata.Likes.Value;
+ });
+
+ case ItemFilter.Dislikes:
+ return items.Where(item =>
+ {
+ var userdata = repository.GetUserData(user.Id, item.GetUserDataKey());
+
+ return userdata != null && userdata.Likes.HasValue && !userdata.Likes.Value;
+ });
+
+ case ItemFilter.IsFavorite:
+ return items.Where(item =>
+ {
+ var userdata = repository.GetUserData(user.Id, item.GetUserDataKey());
+
+ return userdata != null && userdata.IsFavorite;
+ });
+
+ case ItemFilter.IsResumable:
+ return items.Where(item =>
+ {
+ var userdata = repository.GetUserData(user.Id, item.GetUserDataKey());
+
+ return userdata != null && userdata.PlaybackPositionTicks > 0;
+ });
+
+ case ItemFilter.IsPlayed:
+ return items.Where(item => item.IsPlayed(currentUser));
+
+ case ItemFilter.IsUnplayed:
+ return items.Where(item => item.IsUnplayed(currentUser));
+
+ case ItemFilter.IsFolder:
+ return items.Where(item => item.IsFolder);
+
+ case ItemFilter.IsNotFolder:
+ return items.Where(item => !item.IsFolder);
+
+ case ItemFilter.IsRecentlyAdded:
+ return items.Where(item => (DateTime.UtcNow - item.DateCreated).TotalDays <= 10);
+ }
+
+ return items;
+ }
+
+ /// <summary> Applies the additional filters. </summary>
+ /// <param name="request"> The request. </param>
+ /// <param name="i"> Zero-based index of the. </param>
+ /// <param name="user"> The user. </param>
+ /// <param name="isPreFiltered"> true if this object is pre filtered. </param>
+ /// <param name="libraryManager"> Manager for library. </param>
+ /// <returns> true if it succeeds, false if it fails. </returns>
+ private bool ApplyAdditionalFilters(BaseReportRequest request, BaseItem i, User user, bool isPreFiltered, ILibraryManager libraryManager)
+ {
+ var video = i as Video;
+
+ if (!isPreFiltered)
+ {
+ var mediaTypes = request.GetMediaTypes();
+ if (mediaTypes.Length > 0)
+ {
+ if (!(!string.IsNullOrEmpty(i.MediaType) && mediaTypes.Contains(i.MediaType, StringComparer.OrdinalIgnoreCase)))
+ {
+ return false;
+ }
+ }
+
+ if (request.IsPlayed.HasValue)
+ {
+ var val = request.IsPlayed.Value;
+ if (i.IsPlayed(user) != val)
+ {
+ return false;
+ }
+ }
+
+ // Exclude item types
+ var excluteItemTypes = request.GetExcludeItemTypes();
+ if (excluteItemTypes.Length > 0 && excluteItemTypes.Contains(i.GetType().Name, StringComparer.OrdinalIgnoreCase))
+ {
+ return false;
+ }
+
+ // Include item types
+ var includeItemTypes = request.GetIncludeItemTypes();
+ if (includeItemTypes.Length > 0 && !includeItemTypes.Contains(i.GetType().Name, StringComparer.OrdinalIgnoreCase))
+ {
+ return false;
+ }
+
+ if (request.IsInBoxSet.HasValue)
+ {
+ var val = request.IsInBoxSet.Value;
+ if (i.Parents.OfType<BoxSet>().Any() != val)
+ {
+ return false;
+ }
+ }
+
+ // Filter by Video3DFormat
+ if (request.Is3D.HasValue)
+ {
+ var val = request.Is3D.Value;
+
+ if (video == null || val != video.Video3DFormat.HasValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.IsHD.HasValue)
+ {
+ var val = request.IsHD.Value;
+
+ if (video == null || val != video.IsHD)
+ {
+ return false;
+ }
+ }
+
+ if (request.IsUnidentified.HasValue)
+ {
+ var val = request.IsUnidentified.Value;
+ if (i.IsUnidentified != val)
+ {
+ return false;
+ }
+ }
+
+ if (request.IsLocked.HasValue)
+ {
+ var val = request.IsLocked.Value;
+ if (i.IsLocked != val)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasOverview.HasValue)
+ {
+ var filterValue = request.HasOverview.Value;
+
+ var hasValue = !string.IsNullOrEmpty(i.Overview);
+
+ if (hasValue != filterValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasImdbId.HasValue)
+ {
+ var filterValue = request.HasImdbId.Value;
+
+ var hasValue = !string.IsNullOrEmpty(i.GetProviderId(MetadataProviders.Imdb));
+
+ if (hasValue != filterValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasTmdbId.HasValue)
+ {
+ var filterValue = request.HasTmdbId.Value;
+
+ var hasValue = !string.IsNullOrEmpty(i.GetProviderId(MetadataProviders.Tmdb));
+
+ if (hasValue != filterValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasTvdbId.HasValue)
+ {
+ var filterValue = request.HasTvdbId.Value;
+
+ var hasValue = !string.IsNullOrEmpty(i.GetProviderId(MetadataProviders.Tvdb));
+
+ if (hasValue != filterValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.IsYearMismatched.HasValue)
+ {
+ var filterValue = request.IsYearMismatched.Value;
+
+ if (UserViewBuilder.IsYearMismatched(i, libraryManager) != filterValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasOfficialRating.HasValue)
+ {
+ var filterValue = request.HasOfficialRating.Value;
+
+ var hasValue = !string.IsNullOrEmpty(i.OfficialRating);
+
+ if (hasValue != filterValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.IsPlaceHolder.HasValue)
+ {
+ var filterValue = request.IsPlaceHolder.Value;
+
+ var isPlaceHolder = false;
+
+ var hasPlaceHolder = i as ISupportsPlaceHolders;
+
+ if (hasPlaceHolder != null)
+ {
+ isPlaceHolder = hasPlaceHolder.IsPlaceHolder;
+ }
+
+ if (isPlaceHolder != filterValue)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasSpecialFeature.HasValue)
+ {
+ var filterValue = request.HasSpecialFeature.Value;
+
+ var movie = i as IHasSpecialFeatures;
+
+ if (movie != null)
+ {
+ var ok = filterValue
+ ? movie.SpecialFeatureIds.Count > 0
+ : movie.SpecialFeatureIds.Count == 0;
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+ else
+ {
+ return false;
+ }
+ }
+
+ if (request.HasSubtitles.HasValue)
+ {
+ var val = request.HasSubtitles.Value;
+
+ if (video == null || val != video.HasSubtitles)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasParentalRating.HasValue)
+ {
+ var val = request.HasParentalRating.Value;
+
+ var rating = i.CustomRating;
+
+ if (string.IsNullOrEmpty(rating))
+ {
+ rating = i.OfficialRating;
+ }
+
+ if (val)
+ {
+ if (string.IsNullOrEmpty(rating))
+ {
+ return false;
+ }
+ }
+ else
+ {
+ if (!string.IsNullOrEmpty(rating))
+ {
+ return false;
+ }
+ }
+ }
+
+ if (request.HasTrailer.HasValue)
+ {
+ var val = request.HasTrailer.Value;
+ var trailerCount = 0;
+
+ var hasTrailers = i as IHasTrailers;
+ if (hasTrailers != null)
+ {
+ trailerCount = hasTrailers.GetTrailerIds().Count;
+ }
+
+ var ok = val ? trailerCount > 0 : trailerCount == 0;
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasThemeSong.HasValue)
+ {
+ var filterValue = request.HasThemeSong.Value;
+
+ var themeCount = 0;
+ var iHasThemeMedia = i as IHasThemeMedia;
+
+ if (iHasThemeMedia != null)
+ {
+ themeCount = iHasThemeMedia.ThemeSongIds.Count;
+ }
+ var ok = filterValue ? themeCount > 0 : themeCount == 0;
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+
+ if (request.HasThemeVideo.HasValue)
+ {
+ var filterValue = request.HasThemeVideo.Value;
+
+ var themeCount = 0;
+ var iHasThemeMedia = i as IHasThemeMedia;
+
+ if (iHasThemeMedia != null)
+ {
+ themeCount = iHasThemeMedia.ThemeVideoIds.Count;
+ }
+ var ok = filterValue ? themeCount > 0 : themeCount == 0;
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+
+ // Apply tag filter
+ var tags = request.GetTags();
+ if (tags.Length > 0)
+ {
+ var hasTags = i as IHasTags;
+ if (hasTags == null)
+ {
+ return false;
+ }
+ if (!(tags.Any(v => hasTags.Tags.Contains(v, StringComparer.OrdinalIgnoreCase))))
+ {
+ return false;
+ }
+ }
+
+ // Apply official rating filter
+ var officialRatings = request.GetOfficialRatings();
+ if (officialRatings.Length > 0 && !officialRatings.Contains(i.OfficialRating ?? string.Empty))
+ {
+ return false;
+ }
+
+ // Apply genre filter
+ var genres = request.GetGenres();
+ if (genres.Length > 0 && !(genres.Any(v => i.Genres.Contains(v, StringComparer.OrdinalIgnoreCase))))
+ {
+ return false;
+ }
+
+ // Filter by VideoType
+ var videoTypes = request.GetVideoTypes();
+ if (videoTypes.Length > 0 && (video == null || !videoTypes.Contains(video.VideoType)))
+ {
+ return false;
+ }
+
+ var imageTypes = request.GetImageTypes().ToList();
+ if (imageTypes.Count > 0)
+ {
+ if (!(imageTypes.Any(i.HasImage)))
+ {
+ return false;
+ }
+ }
+
+ // Apply studio filter
+ var studios = request.GetStudios();
+ if (studios.Length > 0 && !studios.Any(v => i.Studios.Contains(v, StringComparer.OrdinalIgnoreCase)))
+ {
+ return false;
+ }
+
+ // Apply studio filter
+ var studioIds = request.GetStudioIds();
+ if (studioIds.Length > 0 && !studioIds.Any(id =>
+ {
+ var studioItem = libraryManager.GetItemById(id);
+ return studioItem != null && i.Studios.Contains(studioItem.Name, StringComparer.OrdinalIgnoreCase);
+ }))
+ {
+ return false;
+ }
+
+ // Apply year filter
+ var years = request.GetYears();
+ if (years.Length > 0 && !(i.ProductionYear.HasValue && years.Contains(i.ProductionYear.Value)))
+ {
+ return false;
+ }
+
+ // Apply person filter
+ var personIds = request.GetPersonIds();
+ if (personIds.Length > 0)
+ {
+ var names = personIds
+ .Select(libraryManager.GetItemById)
+ .Select(p => p == null ? "-1" : p.Name)
+ .ToList();
+
+ if (!(names.Any(v => i.People.Select(p => p.Name).Contains(v, StringComparer.OrdinalIgnoreCase))))
+ {
+ return false;
+ }
+ }
+
+ // Apply person filter
+ if (!string.IsNullOrEmpty(request.Person))
+ {
+ var personTypes = request.GetPersonTypes();
+
+ if (personTypes.Length == 0)
+ {
+ if (!(i.People.Any(p => string.Equals(p.Name, request.Person, StringComparison.OrdinalIgnoreCase))))
+ {
+ return false;
+ }
+ }
+ else
+ {
+ var types = personTypes;
+
+ var ok = new[] { i }.Any(item =>
+ item.People != null &&
+ item.People.Any(p =>
+ p.Name.Equals(request.Person, StringComparison.OrdinalIgnoreCase) && (types.Contains(p.Type, StringComparer.OrdinalIgnoreCase) || types.Contains(p.Role, StringComparer.OrdinalIgnoreCase))));
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+ }
+ }
+
+ if (request.MinCommunityRating.HasValue)
+ {
+ var val = request.MinCommunityRating.Value;
+
+ if (!(i.CommunityRating.HasValue && i.CommunityRating >= val))
+ {
+ return false;
+ }
+ }
+
+ if (request.MinCriticRating.HasValue)
+ {
+ var val = request.MinCriticRating.Value;
+
+ var hasCriticRating = i as IHasCriticRating;
+
+ if (hasCriticRating != null)
+ {
+ if (!(hasCriticRating.CriticRating.HasValue && hasCriticRating.CriticRating >= val))
+ {
+ return false;
+ }
+ }
+ else
+ {
+ return false;
+ }
+ }
+
+ // Artists
+ if (!string.IsNullOrEmpty(request.ArtistIds))
+ {
+ var artistIds = request.ArtistIds.Split('|');
+
+ var audio = i as IHasArtist;
+
+ if (!(audio != null && artistIds.Any(id =>
+ {
+ var artistItem = libraryManager.GetItemById(id);
+ return artistItem != null && audio.HasAnyArtist(artistItem.Name);
+ })))
+ {
+ return false;
+ }
+ }
+
+ // Artists
+ if (!string.IsNullOrEmpty(request.Artists))
+ {
+ var artists = request.Artists.Split('|');
+
+ var audio = i as IHasArtist;
+
+ if (!(audio != null && artists.Any(audio.HasAnyArtist)))
+ {
+ return false;
+ }
+ }
+
+ // Albums
+ if (!string.IsNullOrEmpty(request.Albums))
+ {
+ var albums = request.Albums.Split('|');
+
+ var audio = i as Audio;
+
+ if (audio != null)
+ {
+ if (!albums.Any(a => string.Equals(a, audio.Album, StringComparison.OrdinalIgnoreCase)))
+ {
+ return false;
+ }
+ }
+
+ var album = i as MusicAlbum;
+
+ if (album != null)
+ {
+ if (!albums.Any(a => string.Equals(a, album.Name, StringComparison.OrdinalIgnoreCase)))
+ {
+ return false;
+ }
+ }
+
+ var musicVideo = i as MusicVideo;
+
+ if (musicVideo != null)
+ {
+ if (!albums.Any(a => string.Equals(a, musicVideo.Album, StringComparison.OrdinalIgnoreCase)))
+ {
+ return false;
+ }
+ }
+
+ return false;
+ }
+
+ // Min index number
+ if (request.MinIndexNumber.HasValue)
+ {
+ if (!(i.IndexNumber.HasValue && i.IndexNumber.Value >= request.MinIndexNumber.Value))
+ {
+ return false;
+ }
+ }
+
+ // Min official rating
+ if (!string.IsNullOrEmpty(request.MinOfficialRating))
+ {
+ var level = _localization.GetRatingLevel(request.MinOfficialRating);
+
+ if (level.HasValue)
+ {
+ var rating = i.CustomRating;
+
+ if (string.IsNullOrEmpty(rating))
+ {
+ rating = i.OfficialRating;
+ }
+
+ if (!string.IsNullOrEmpty(rating))
+ {
+ var itemLevel = _localization.GetRatingLevel(rating);
+
+ if (!(!itemLevel.HasValue || itemLevel.Value >= level.Value))
+ {
+ return false;
+ }
+ }
+ }
+ }
+
+ // Max official rating
+ if (!string.IsNullOrEmpty(request.MaxOfficialRating))
+ {
+ var level = _localization.GetRatingLevel(request.MaxOfficialRating);
+
+ if (level.HasValue)
+ {
+ var rating = i.CustomRating;
+
+ if (string.IsNullOrEmpty(rating))
+ {
+ rating = i.OfficialRating;
+ }
+
+ if (!string.IsNullOrEmpty(rating))
+ {
+ var itemLevel = _localization.GetRatingLevel(rating);
+
+ if (!(!itemLevel.HasValue || itemLevel.Value <= level.Value))
+ {
+ return false;
+ }
+ }
+ }
+ }
+
+ // LocationTypes
+ if (!string.IsNullOrEmpty(request.LocationTypes))
+ {
+ var vals = request.LocationTypes.Split(',');
+ if (!vals.Contains(i.LocationType.ToString(), StringComparer.OrdinalIgnoreCase))
+ {
+ return false;
+ }
+ }
+
+ // ExcludeLocationTypes
+ if (!string.IsNullOrEmpty(request.ExcludeLocationTypes))
+ {
+ var vals = request.ExcludeLocationTypes.Split(',');
+ if (vals.Contains(i.LocationType.ToString(), StringComparer.OrdinalIgnoreCase))
+ {
+ return false;
+ }
+ }
+
+ if (!string.IsNullOrEmpty(request.AlbumArtistStartsWithOrGreater))
+ {
+ var ok = new[] { i }.OfType<IHasAlbumArtist>()
+ .Any(p => string.Compare(request.AlbumArtistStartsWithOrGreater, p.AlbumArtists.FirstOrDefault(), StringComparison.CurrentCultureIgnoreCase) < 1);
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+
+ // Filter by Series Status
+ if (!string.IsNullOrEmpty(request.SeriesStatus))
+ {
+ var vals = request.SeriesStatus.Split(',');
+
+ var ok = new[] { i }.OfType<Series>().Any(p => p.Status.HasValue && vals.Contains(p.Status.Value.ToString(), StringComparer.OrdinalIgnoreCase));
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+
+ // Filter by Series AirDays
+ if (!string.IsNullOrEmpty(request.AirDays))
+ {
+ var days = request.AirDays.Split(',').Select(d => (DayOfWeek)Enum.Parse(typeof(DayOfWeek), d, true));
+
+ var ok = new[] { i }.OfType<Series>().Any(p => p.AirDays != null && days.Any(d => p.AirDays.Contains(d)));
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+
+ if (request.MinPlayers.HasValue)
+ {
+ var filterValue = request.MinPlayers.Value;
+
+ var game = i as Game;
+
+ if (game != null)
+ {
+ var players = game.PlayersSupported ?? 1;
+
+ var ok = players >= filterValue;
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+ else
+ {
+ return false;
+ }
+ }
+
+ if (request.MaxPlayers.HasValue)
+ {
+ var filterValue = request.MaxPlayers.Value;
+
+ var game = i as Game;
+
+ if (game != null)
+ {
+ var players = game.PlayersSupported ?? 1;
+
+ var ok = players <= filterValue;
+
+ if (!ok)
+ {
+ return false;
+ }
+ }
+ else
+ {
+ return false;
+ }
+ }
+
+ if (request.ParentIndexNumber.HasValue)
+ {
+ var filterValue = request.ParentIndexNumber.Value;
+
+ var episode = i as Episode;
+
+ if (episode != null)
+ {
+ if (episode.ParentIndexNumber.HasValue && episode.ParentIndexNumber.Value != filterValue)
+ {
+ return false;
+ }
+ }
+
+ var song = i as Audio;
+
+ if (song != null)
+ {
+ if (song.ParentIndexNumber.HasValue && song.ParentIndexNumber.Value != filterValue)
+ {
+ return false;
+ }
+ }
+ }
+
+ if (request.AiredDuringSeason.HasValue)
+ {
+ var episode = i as Episode;
+
+ if (episode == null)
+ {
+ return false;
+ }
+
+ if (!Series.FilterEpisodesBySeason(new[] { episode }, request.AiredDuringSeason.Value, true).Any())
+ {
+ return false;
+ }
+ }
+
+ if (!string.IsNullOrEmpty(request.MinPremiereDate))
+ {
+ var date = DateTime.Parse(request.MinPremiereDate, null, DateTimeStyles.RoundtripKind).ToUniversalTime();
+
+ if (!(i.PremiereDate.HasValue && i.PremiereDate.Value >= date))
+ {
+ return false;
+ }
+ }
+
+ if (!string.IsNullOrEmpty(request.MaxPremiereDate))
+ {
+ var date = DateTime.Parse(request.MaxPremiereDate, null, DateTimeStyles.RoundtripKind).ToUniversalTime();
+
+ if (!(i.PremiereDate.HasValue && i.PremiereDate.Value <= date))
+ {
+ return false;
+ }
+ }
+
+ return true;
+ }
+
+ /// <summary> Applies the paging. </summary>
+ /// <param name="request"> The request. </param>
+ /// <param name="items"> The items. </param>
+ /// <returns> IEnumerable{BaseItem}. </returns>
+ private IEnumerable<BaseItem> ApplyPaging(GetItems request, IEnumerable<BaseItem> items)
+ {
+ // Start at
+ if (request.StartIndex.HasValue)
+ {
+ items = items.Skip(request.StartIndex.Value);
+ }
+
+ // Return limit
+ if (request.Limit.HasValue)
+ {
+ items = items.Take(request.Limit.Value);
+ }
+
+ return items;
+ }
+
+ }
}