BaseItemRepository.cs 81 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227
  1. #pragma warning disable RS0030 // Do not use banned APIs
  2. // Do not enforce that because EFCore cannot deal with cultures well.
  3. #pragma warning disable CA1304 // Specify CultureInfo
  4. #pragma warning disable CA1311 // Specify a culture or use an invariant version
  5. #pragma warning disable CA1862 // Use the 'StringComparison' method overloads to perform case-insensitive string comparisons
  6. using System;
  7. using System.Collections.Concurrent;
  8. using System.Collections.Generic;
  9. using System.Globalization;
  10. using System.Linq;
  11. using System.Linq.Expressions;
  12. using System.Reflection;
  13. using System.Text;
  14. using System.Text.Json;
  15. using System.Threading;
  16. using Jellyfin.Data.Enums;
  17. using Jellyfin.Database.Implementations;
  18. using Jellyfin.Database.Implementations.Entities;
  19. using Jellyfin.Database.Implementations.Enums;
  20. using Jellyfin.Extensions;
  21. using Jellyfin.Extensions.Json;
  22. using Jellyfin.Server.Implementations.Extensions;
  23. using MediaBrowser.Common;
  24. using MediaBrowser.Controller;
  25. using MediaBrowser.Controller.Channels;
  26. using MediaBrowser.Controller.Configuration;
  27. using MediaBrowser.Controller.Entities;
  28. using MediaBrowser.Controller.Entities.Audio;
  29. using MediaBrowser.Controller.Entities.TV;
  30. using MediaBrowser.Controller.LiveTv;
  31. using MediaBrowser.Controller.Persistence;
  32. using MediaBrowser.Model.Dto;
  33. using MediaBrowser.Model.Entities;
  34. using MediaBrowser.Model.LiveTv;
  35. using MediaBrowser.Model.Querying;
  36. using Microsoft.EntityFrameworkCore;
  37. using Microsoft.Extensions.Logging;
  38. using BaseItemDto = MediaBrowser.Controller.Entities.BaseItem;
  39. using BaseItemEntity = Jellyfin.Database.Implementations.Entities.BaseItemEntity;
  40. namespace Jellyfin.Server.Implementations.Item;
  41. /*
  42. All queries in this class and all other nullable enabled EFCore repository classes will make liberal use of the null-forgiving operator "!".
  43. This is done as the code isn't actually executed client side, but only the expressions are interpret and the compiler cannot know that.
  44. This is your only warning/message regarding this topic.
  45. */
  46. /// <summary>
  47. /// Handles all storage logic for BaseItems.
  48. /// </summary>
  49. public sealed class BaseItemRepository
  50. : IItemRepository
  51. {
  52. /// <summary>
  53. /// This holds all the types in the running assemblies
  54. /// so that we can de-serialize properly when we don't have strong types.
  55. /// </summary>
  56. private static readonly ConcurrentDictionary<string, Type?> _typeMap = new ConcurrentDictionary<string, Type?>();
  57. private readonly IDbContextFactory<JellyfinDbContext> _dbProvider;
  58. private readonly IServerApplicationHost _appHost;
  59. private readonly IItemTypeLookup _itemTypeLookup;
  60. private readonly IServerConfigurationManager _serverConfigurationManager;
  61. private readonly ILogger<BaseItemRepository> _logger;
  62. private static readonly IReadOnlyList<ItemValueType> _getAllArtistsValueTypes = [ItemValueType.Artist, ItemValueType.AlbumArtist];
  63. private static readonly IReadOnlyList<ItemValueType> _getArtistValueTypes = [ItemValueType.Artist];
  64. private static readonly IReadOnlyList<ItemValueType> _getAlbumArtistValueTypes = [ItemValueType.AlbumArtist];
  65. private static readonly IReadOnlyList<ItemValueType> _getStudiosValueTypes = [ItemValueType.Studios];
  66. private static readonly IReadOnlyList<ItemValueType> _getGenreValueTypes = [ItemValueType.Genre];
  67. /// <summary>
  68. /// Initializes a new instance of the <see cref="BaseItemRepository"/> class.
  69. /// </summary>
  70. /// <param name="dbProvider">The db factory.</param>
  71. /// <param name="appHost">The Application host.</param>
  72. /// <param name="itemTypeLookup">The static type lookup.</param>
  73. /// <param name="serverConfigurationManager">The server Configuration manager.</param>
  74. /// <param name="logger">System logger.</param>
  75. public BaseItemRepository(
  76. IDbContextFactory<JellyfinDbContext> dbProvider,
  77. IServerApplicationHost appHost,
  78. IItemTypeLookup itemTypeLookup,
  79. IServerConfigurationManager serverConfigurationManager,
  80. ILogger<BaseItemRepository> logger)
  81. {
  82. _dbProvider = dbProvider;
  83. _appHost = appHost;
  84. _itemTypeLookup = itemTypeLookup;
  85. _serverConfigurationManager = serverConfigurationManager;
  86. _logger = logger;
  87. }
  88. /// <inheritdoc />
  89. public void DeleteItem(Guid id)
  90. {
  91. if (id.IsEmpty())
  92. {
  93. throw new ArgumentException("Guid can't be empty", nameof(id));
  94. }
  95. using var context = _dbProvider.CreateDbContext();
  96. using var transaction = context.Database.BeginTransaction();
  97. context.AncestorIds.Where(e => e.ItemId == id || e.ParentItemId == id).ExecuteDelete();
  98. context.AttachmentStreamInfos.Where(e => e.ItemId == id).ExecuteDelete();
  99. context.BaseItemImageInfos.Where(e => e.ItemId == id).ExecuteDelete();
  100. context.BaseItemMetadataFields.Where(e => e.ItemId == id).ExecuteDelete();
  101. context.BaseItemProviders.Where(e => e.ItemId == id).ExecuteDelete();
  102. context.BaseItemTrailerTypes.Where(e => e.ItemId == id).ExecuteDelete();
  103. context.BaseItems.Where(e => e.Id == id).ExecuteDelete();
  104. context.Chapters.Where(e => e.ItemId == id).ExecuteDelete();
  105. context.CustomItemDisplayPreferences.Where(e => e.ItemId == id).ExecuteDelete();
  106. context.ItemDisplayPreferences.Where(e => e.ItemId == id).ExecuteDelete();
  107. context.ItemValues.Where(e => e.BaseItemsMap!.Count == 0).ExecuteDelete();
  108. context.ItemValuesMap.Where(e => e.ItemId == id).ExecuteDelete();
  109. context.KeyframeData.Where(e => e.ItemId == id).ExecuteDelete();
  110. context.MediaSegments.Where(e => e.ItemId == id).ExecuteDelete();
  111. context.MediaStreamInfos.Where(e => e.ItemId == id).ExecuteDelete();
  112. context.PeopleBaseItemMap.Where(e => e.ItemId == id).ExecuteDelete();
  113. context.Peoples.Where(e => e.BaseItems!.Count == 0).ExecuteDelete();
  114. context.TrickplayInfos.Where(e => e.ItemId == id).ExecuteDelete();
  115. context.SaveChanges();
  116. transaction.Commit();
  117. }
  118. /// <inheritdoc />
  119. public void UpdateInheritedValues()
  120. {
  121. using var context = _dbProvider.CreateDbContext();
  122. using var transaction = context.Database.BeginTransaction();
  123. context.ItemValuesMap.Where(e => e.ItemValue.Type == ItemValueType.InheritedTags).ExecuteDelete();
  124. // ItemValue Inheritance is now correctly mapped via AncestorId on demand
  125. context.SaveChanges();
  126. transaction.Commit();
  127. }
  128. /// <inheritdoc />
  129. public IReadOnlyList<Guid> GetItemIdsList(InternalItemsQuery filter)
  130. {
  131. ArgumentNullException.ThrowIfNull(filter);
  132. PrepareFilterQuery(filter);
  133. using var context = _dbProvider.CreateDbContext();
  134. return ApplyQueryFilter(context.BaseItems.AsNoTracking(), context, filter).Select(e => e.Id).ToArray();
  135. }
  136. /// <inheritdoc />
  137. public QueryResult<(BaseItemDto Item, ItemCounts ItemCounts)> GetAllArtists(InternalItemsQuery filter)
  138. {
  139. return GetItemValues(filter, _getAllArtistsValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist]);
  140. }
  141. /// <inheritdoc />
  142. public QueryResult<(BaseItemDto Item, ItemCounts ItemCounts)> GetArtists(InternalItemsQuery filter)
  143. {
  144. return GetItemValues(filter, _getArtistValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist]);
  145. }
  146. /// <inheritdoc />
  147. public QueryResult<(BaseItemDto Item, ItemCounts ItemCounts)> GetAlbumArtists(InternalItemsQuery filter)
  148. {
  149. return GetItemValues(filter, _getAlbumArtistValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist]);
  150. }
  151. /// <inheritdoc />
  152. public QueryResult<(BaseItemDto Item, ItemCounts ItemCounts)> GetStudios(InternalItemsQuery filter)
  153. {
  154. return GetItemValues(filter, _getStudiosValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.Studio]);
  155. }
  156. /// <inheritdoc />
  157. public QueryResult<(BaseItemDto Item, ItemCounts ItemCounts)> GetGenres(InternalItemsQuery filter)
  158. {
  159. return GetItemValues(filter, _getGenreValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.Genre]);
  160. }
  161. /// <inheritdoc />
  162. public QueryResult<(BaseItemDto Item, ItemCounts ItemCounts)> GetMusicGenres(InternalItemsQuery filter)
  163. {
  164. return GetItemValues(filter, _getGenreValueTypes, _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicGenre]);
  165. }
  166. /// <inheritdoc />
  167. public IReadOnlyList<string> GetStudioNames()
  168. {
  169. return GetItemValueNames(_getStudiosValueTypes, [], []);
  170. }
  171. /// <inheritdoc />
  172. public IReadOnlyList<string> GetAllArtistNames()
  173. {
  174. return GetItemValueNames(_getAllArtistsValueTypes, [], []);
  175. }
  176. /// <inheritdoc />
  177. public IReadOnlyList<string> GetMusicGenreNames()
  178. {
  179. return GetItemValueNames(
  180. _getGenreValueTypes,
  181. _itemTypeLookup.MusicGenreTypes,
  182. []);
  183. }
  184. /// <inheritdoc />
  185. public IReadOnlyList<string> GetGenreNames()
  186. {
  187. return GetItemValueNames(
  188. _getGenreValueTypes,
  189. [],
  190. _itemTypeLookup.MusicGenreTypes);
  191. }
  192. /// <inheritdoc />
  193. public QueryResult<BaseItemDto> GetItems(InternalItemsQuery filter)
  194. {
  195. ArgumentNullException.ThrowIfNull(filter);
  196. if (!filter.EnableTotalRecordCount || (!filter.Limit.HasValue && (filter.StartIndex ?? 0) == 0))
  197. {
  198. var returnList = GetItemList(filter);
  199. return new QueryResult<BaseItemDto>(
  200. filter.StartIndex,
  201. returnList.Count,
  202. returnList);
  203. }
  204. PrepareFilterQuery(filter);
  205. var result = new QueryResult<BaseItemDto>();
  206. using var context = _dbProvider.CreateDbContext();
  207. IQueryable<BaseItemEntity> dbQuery = PrepareItemQuery(context, filter);
  208. dbQuery = TranslateQuery(dbQuery, context, filter);
  209. if (filter.EnableTotalRecordCount)
  210. {
  211. result.TotalRecordCount = dbQuery.Count();
  212. }
  213. dbQuery = ApplyGroupingFilter(dbQuery, filter);
  214. dbQuery = ApplyQueryPaging(dbQuery, filter);
  215. result.Items = dbQuery.AsEnumerable().Where(e => e is not null).Select(w => DeserialiseBaseItem(w, filter.SkipDeserialization)).ToArray();
  216. result.StartIndex = filter.StartIndex ?? 0;
  217. return result;
  218. }
  219. /// <inheritdoc />
  220. public IReadOnlyList<BaseItemDto> GetItemList(InternalItemsQuery filter)
  221. {
  222. ArgumentNullException.ThrowIfNull(filter);
  223. PrepareFilterQuery(filter);
  224. using var context = _dbProvider.CreateDbContext();
  225. IQueryable<BaseItemEntity> dbQuery = PrepareItemQuery(context, filter);
  226. dbQuery = TranslateQuery(dbQuery, context, filter);
  227. dbQuery = ApplyGroupingFilter(dbQuery, filter);
  228. dbQuery = ApplyQueryPaging(dbQuery, filter);
  229. return dbQuery.AsEnumerable().Where(e => e is not null).Select(w => DeserialiseBaseItem(w, filter.SkipDeserialization)).ToArray();
  230. }
  231. /// <inheritdoc/>
  232. public IReadOnlyList<BaseItem> GetLatestItemList(InternalItemsQuery filter, CollectionType collectionType)
  233. {
  234. ArgumentNullException.ThrowIfNull(filter);
  235. PrepareFilterQuery(filter);
  236. // Early exit if collection type is not tvshows or music
  237. if (collectionType != CollectionType.tvshows && collectionType != CollectionType.music)
  238. {
  239. return Array.Empty<BaseItem>();
  240. }
  241. using var context = _dbProvider.CreateDbContext();
  242. // Subquery to group by SeriesNames/Album and get the max Date Created for each group.
  243. var subquery = PrepareItemQuery(context, filter);
  244. subquery = TranslateQuery(subquery, context, filter);
  245. var subqueryGrouped = subquery.GroupBy(g => collectionType == CollectionType.tvshows ? g.SeriesName : g.Album)
  246. .Select(g => new
  247. {
  248. Key = g.Key,
  249. MaxDateCreated = g.Max(a => a.DateCreated)
  250. })
  251. .OrderByDescending(g => g.MaxDateCreated)
  252. .Select(g => g);
  253. if (filter.Limit.HasValue)
  254. {
  255. subqueryGrouped = subqueryGrouped.Take(filter.Limit.Value);
  256. }
  257. filter.Limit = null;
  258. var mainquery = PrepareItemQuery(context, filter);
  259. mainquery = TranslateQuery(mainquery, context, filter);
  260. mainquery = mainquery.Where(g => g.DateCreated >= subqueryGrouped.Min(s => s.MaxDateCreated));
  261. mainquery = ApplyGroupingFilter(mainquery, filter);
  262. mainquery = ApplyQueryPaging(mainquery, filter);
  263. return mainquery.AsEnumerable().Where(e => e is not null).Select(w => DeserialiseBaseItem(w, filter.SkipDeserialization)).ToArray();
  264. }
  265. /// <inheritdoc />
  266. public IReadOnlyList<string> GetNextUpSeriesKeys(InternalItemsQuery filter, DateTime dateCutoff)
  267. {
  268. ArgumentNullException.ThrowIfNull(filter);
  269. ArgumentNullException.ThrowIfNull(filter.User);
  270. using var context = _dbProvider.CreateDbContext();
  271. var query = context.BaseItems
  272. .AsNoTracking()
  273. .Where(i => filter.TopParentIds.Contains(i.TopParentId!.Value))
  274. .Where(i => i.Type == _itemTypeLookup.BaseItemKindNames[BaseItemKind.Episode])
  275. .Join(
  276. context.UserData.AsNoTracking(),
  277. i => new { UserId = filter.User.Id, ItemId = i.Id },
  278. u => new { UserId = u.UserId, ItemId = u.ItemId },
  279. (entity, data) => new { Item = entity, UserData = data })
  280. .GroupBy(g => g.Item.SeriesPresentationUniqueKey)
  281. .Select(g => new { g.Key, LastPlayedDate = g.Max(u => u.UserData.LastPlayedDate) })
  282. .Where(g => g.Key != null && g.LastPlayedDate != null && g.LastPlayedDate >= dateCutoff)
  283. .OrderByDescending(g => g.LastPlayedDate)
  284. .Select(g => g.Key!);
  285. if (filter.Limit.HasValue)
  286. {
  287. query = query.Take(filter.Limit.Value);
  288. }
  289. return query.ToArray();
  290. }
  291. private IQueryable<BaseItemEntity> ApplyGroupingFilter(IQueryable<BaseItemEntity> dbQuery, InternalItemsQuery filter)
  292. {
  293. // This whole block is needed to filter duplicate entries on request
  294. // for the time being it cannot be used because it would destroy the ordering
  295. // this results in "duplicate" responses for queries that try to lookup individual series or multiple versions but
  296. // for that case the invoker has to run a DistinctBy(e => e.PresentationUniqueKey) on their own
  297. // var enableGroupByPresentationUniqueKey = EnableGroupByPresentationUniqueKey(filter);
  298. // if (enableGroupByPresentationUniqueKey && filter.GroupBySeriesPresentationUniqueKey)
  299. // {
  300. // dbQuery = ApplyOrder(dbQuery, filter);
  301. // dbQuery = dbQuery.GroupBy(e => new { e.PresentationUniqueKey, e.SeriesPresentationUniqueKey }).Select(e => e.First());
  302. // }
  303. // else if (enableGroupByPresentationUniqueKey)
  304. // {
  305. // dbQuery = ApplyOrder(dbQuery, filter);
  306. // dbQuery = dbQuery.GroupBy(e => e.PresentationUniqueKey).Select(e => e.First());
  307. // }
  308. // else if (filter.GroupBySeriesPresentationUniqueKey)
  309. // {
  310. // dbQuery = ApplyOrder(dbQuery, filter);
  311. // dbQuery = dbQuery.GroupBy(e => e.SeriesPresentationUniqueKey).Select(e => e.First());
  312. // }
  313. // else
  314. // {
  315. // dbQuery = dbQuery.Distinct();
  316. // dbQuery = ApplyOrder(dbQuery, filter);
  317. // }
  318. dbQuery = dbQuery.Distinct();
  319. dbQuery = ApplyOrder(dbQuery, filter);
  320. return dbQuery;
  321. }
  322. private IQueryable<BaseItemEntity> ApplyQueryPaging(IQueryable<BaseItemEntity> dbQuery, InternalItemsQuery filter)
  323. {
  324. if (filter.Limit.HasValue || filter.StartIndex.HasValue)
  325. {
  326. var offset = filter.StartIndex ?? 0;
  327. if (offset > 0)
  328. {
  329. dbQuery = dbQuery.Skip(offset);
  330. }
  331. if (filter.Limit.HasValue)
  332. {
  333. dbQuery = dbQuery.Take(filter.Limit.Value);
  334. }
  335. }
  336. return dbQuery;
  337. }
  338. private IQueryable<BaseItemEntity> ApplyQueryFilter(IQueryable<BaseItemEntity> dbQuery, JellyfinDbContext context, InternalItemsQuery filter)
  339. {
  340. dbQuery = TranslateQuery(dbQuery, context, filter);
  341. dbQuery = ApplyOrder(dbQuery, filter);
  342. dbQuery = ApplyGroupingFilter(dbQuery, filter);
  343. dbQuery = ApplyQueryPaging(dbQuery, filter);
  344. return dbQuery;
  345. }
  346. private IQueryable<BaseItemEntity> PrepareItemQuery(JellyfinDbContext context, InternalItemsQuery filter)
  347. {
  348. IQueryable<BaseItemEntity> dbQuery = context.BaseItems.AsNoTracking().AsSplitQuery()
  349. .Include(e => e.TrailerTypes)
  350. .Include(e => e.Provider)
  351. .Include(e => e.LockedFields);
  352. if (filter.DtoOptions.EnableImages)
  353. {
  354. dbQuery = dbQuery.Include(e => e.Images);
  355. }
  356. return dbQuery;
  357. }
  358. /// <inheritdoc/>
  359. public int GetCount(InternalItemsQuery filter)
  360. {
  361. ArgumentNullException.ThrowIfNull(filter);
  362. // Hack for right now since we currently don't support filtering out these duplicates within a query
  363. PrepareFilterQuery(filter);
  364. using var context = _dbProvider.CreateDbContext();
  365. var dbQuery = TranslateQuery(context.BaseItems.AsNoTracking(), context, filter);
  366. return dbQuery.Count();
  367. }
  368. #pragma warning disable CA1307 // Specify StringComparison for clarity
  369. /// <summary>
  370. /// Gets the type.
  371. /// </summary>
  372. /// <param name="typeName">Name of the type.</param>
  373. /// <returns>Type.</returns>
  374. /// <exception cref="ArgumentNullException"><c>typeName</c> is null.</exception>
  375. private static Type? GetType(string typeName)
  376. {
  377. ArgumentException.ThrowIfNullOrEmpty(typeName);
  378. // TODO: this isn't great. Refactor later to be both globally handled by a dedicated service not just an static variable and be loaded eagerly.
  379. // currently this is done so that plugins may introduce their own type of baseitems as we dont know when we are first called, before or after plugins are loaded
  380. return _typeMap.GetOrAdd(typeName, k => AppDomain.CurrentDomain.GetAssemblies()
  381. .Select(a => a.GetType(k))
  382. .FirstOrDefault(t => t is not null));
  383. }
  384. /// <inheritdoc />
  385. public void SaveImages(BaseItemDto item)
  386. {
  387. ArgumentNullException.ThrowIfNull(item);
  388. var images = item.ImageInfos.Select(e => Map(item.Id, e));
  389. using var context = _dbProvider.CreateDbContext();
  390. using var transaction = context.Database.BeginTransaction();
  391. context.BaseItemImageInfos.Where(e => e.ItemId == item.Id).ExecuteDelete();
  392. context.BaseItemImageInfos.AddRange(images);
  393. context.SaveChanges();
  394. transaction.Commit();
  395. }
  396. /// <inheritdoc />
  397. public void SaveItems(IReadOnlyList<BaseItemDto> items, CancellationToken cancellationToken)
  398. {
  399. UpdateOrInsertItems(items, cancellationToken);
  400. }
  401. /// <inheritdoc cref="IItemRepository"/>
  402. public void UpdateOrInsertItems(IReadOnlyList<BaseItemDto> items, CancellationToken cancellationToken)
  403. {
  404. ArgumentNullException.ThrowIfNull(items);
  405. cancellationToken.ThrowIfCancellationRequested();
  406. var tuples = new List<(BaseItemDto Item, List<Guid>? AncestorIds, BaseItemDto TopParent, IEnumerable<string> UserDataKey, List<string> InheritedTags)>();
  407. foreach (var item in items.GroupBy(e => e.Id).Select(e => e.Last()))
  408. {
  409. var ancestorIds = item.SupportsAncestors ?
  410. item.GetAncestorIds().Distinct().ToList() :
  411. null;
  412. var topParent = item.GetTopParent();
  413. var userdataKey = item.GetUserDataKeys();
  414. var inheritedTags = item.GetInheritedTags();
  415. tuples.Add((item, ancestorIds, topParent, userdataKey, inheritedTags));
  416. }
  417. var localItemValueCache = new Dictionary<(int MagicNumber, string Value), Guid>();
  418. using var context = _dbProvider.CreateDbContext();
  419. using var transaction = context.Database.BeginTransaction();
  420. foreach (var item in tuples)
  421. {
  422. var entity = Map(item.Item);
  423. // TODO: refactor this "inconsistency"
  424. entity.TopParentId = item.TopParent?.Id;
  425. if (!context.BaseItems.Any(e => e.Id == entity.Id))
  426. {
  427. context.BaseItems.Add(entity);
  428. }
  429. else
  430. {
  431. context.BaseItemProviders.Where(e => e.ItemId == entity.Id).ExecuteDelete();
  432. context.BaseItems.Attach(entity).State = EntityState.Modified;
  433. }
  434. context.AncestorIds.Where(e => e.ItemId == entity.Id).ExecuteDelete();
  435. if (item.Item.SupportsAncestors && item.AncestorIds != null)
  436. {
  437. foreach (var ancestorId in item.AncestorIds)
  438. {
  439. if (!context.BaseItems.Any(f => f.Id == ancestorId))
  440. {
  441. continue;
  442. }
  443. context.AncestorIds.Add(new AncestorId()
  444. {
  445. ParentItemId = ancestorId,
  446. ItemId = entity.Id,
  447. Item = null!,
  448. ParentItem = null!
  449. });
  450. }
  451. }
  452. // Never save duplicate itemValues as they are now mapped anyway.
  453. var itemValuesToSave = GetItemValuesToSave(item.Item, item.InheritedTags).DistinctBy(e => (GetCleanValue(e.Value), e.MagicNumber));
  454. context.ItemValuesMap.Where(e => e.ItemId == entity.Id).ExecuteDelete();
  455. foreach (var itemValue in itemValuesToSave)
  456. {
  457. if (!localItemValueCache.TryGetValue(itemValue, out var refValue))
  458. {
  459. refValue = context.ItemValues
  460. .Where(f => f.Value == itemValue.Value && (int)f.Type == itemValue.MagicNumber)
  461. .Select(e => e.ItemValueId)
  462. .FirstOrDefault();
  463. }
  464. if (refValue.IsEmpty())
  465. {
  466. context.ItemValues.Add(new ItemValue()
  467. {
  468. CleanValue = GetCleanValue(itemValue.Value),
  469. Type = (ItemValueType)itemValue.MagicNumber,
  470. ItemValueId = refValue = Guid.NewGuid(),
  471. Value = itemValue.Value
  472. });
  473. localItemValueCache[itemValue] = refValue;
  474. }
  475. context.ItemValuesMap.Add(new ItemValueMap()
  476. {
  477. Item = null!,
  478. ItemId = entity.Id,
  479. ItemValue = null!,
  480. ItemValueId = refValue
  481. });
  482. }
  483. }
  484. context.SaveChanges();
  485. transaction.Commit();
  486. }
  487. /// <inheritdoc />
  488. public BaseItemDto? RetrieveItem(Guid id)
  489. {
  490. if (id.IsEmpty())
  491. {
  492. throw new ArgumentException("Guid can't be empty", nameof(id));
  493. }
  494. using var context = _dbProvider.CreateDbContext();
  495. var item = PrepareItemQuery(context, new()
  496. {
  497. DtoOptions = new()
  498. {
  499. EnableImages = true
  500. }
  501. }).FirstOrDefault(e => e.Id == id);
  502. if (item is null)
  503. {
  504. return null;
  505. }
  506. return DeserialiseBaseItem(item);
  507. }
  508. /// <summary>
  509. /// Maps a Entity to the DTO.
  510. /// </summary>
  511. /// <param name="entity">The entity.</param>
  512. /// <param name="dto">The dto base instance.</param>
  513. /// <param name="appHost">The Application server Host.</param>
  514. /// <returns>The dto to map.</returns>
  515. public static BaseItemDto Map(BaseItemEntity entity, BaseItemDto dto, IServerApplicationHost? appHost)
  516. {
  517. dto.Id = entity.Id;
  518. dto.ParentId = entity.ParentId.GetValueOrDefault();
  519. dto.Path = appHost?.ExpandVirtualPath(entity.Path) ?? entity.Path;
  520. dto.EndDate = entity.EndDate;
  521. dto.CommunityRating = entity.CommunityRating;
  522. dto.CustomRating = entity.CustomRating;
  523. dto.IndexNumber = entity.IndexNumber;
  524. dto.IsLocked = entity.IsLocked;
  525. dto.Name = entity.Name;
  526. dto.OfficialRating = entity.OfficialRating;
  527. dto.Overview = entity.Overview;
  528. dto.ParentIndexNumber = entity.ParentIndexNumber;
  529. dto.PremiereDate = entity.PremiereDate;
  530. dto.ProductionYear = entity.ProductionYear;
  531. dto.SortName = entity.SortName;
  532. dto.ForcedSortName = entity.ForcedSortName;
  533. dto.RunTimeTicks = entity.RunTimeTicks;
  534. dto.PreferredMetadataLanguage = entity.PreferredMetadataLanguage;
  535. dto.PreferredMetadataCountryCode = entity.PreferredMetadataCountryCode;
  536. dto.IsInMixedFolder = entity.IsInMixedFolder;
  537. dto.InheritedParentalRatingValue = entity.InheritedParentalRatingValue;
  538. dto.InheritedParentalRatingSubValue = entity.InheritedParentalRatingSubValue;
  539. dto.CriticRating = entity.CriticRating;
  540. dto.PresentationUniqueKey = entity.PresentationUniqueKey;
  541. dto.OriginalTitle = entity.OriginalTitle;
  542. dto.Album = entity.Album;
  543. dto.LUFS = entity.LUFS;
  544. dto.NormalizationGain = entity.NormalizationGain;
  545. dto.IsVirtualItem = entity.IsVirtualItem;
  546. dto.ExternalSeriesId = entity.ExternalSeriesId;
  547. dto.Tagline = entity.Tagline;
  548. dto.TotalBitrate = entity.TotalBitrate;
  549. dto.ExternalId = entity.ExternalId;
  550. dto.Size = entity.Size;
  551. dto.Genres = entity.Genres?.Split('|') ?? [];
  552. dto.DateCreated = entity.DateCreated.GetValueOrDefault();
  553. dto.DateModified = entity.DateModified.GetValueOrDefault();
  554. dto.ChannelId = entity.ChannelId ?? Guid.Empty;
  555. dto.DateLastRefreshed = entity.DateLastRefreshed.GetValueOrDefault();
  556. dto.DateLastSaved = entity.DateLastSaved.GetValueOrDefault();
  557. dto.OwnerId = string.IsNullOrWhiteSpace(entity.OwnerId) ? Guid.Empty : (Guid.TryParse(entity.OwnerId, out var ownerId) ? ownerId : Guid.Empty);
  558. dto.Width = entity.Width.GetValueOrDefault();
  559. dto.Height = entity.Height.GetValueOrDefault();
  560. if (entity.Provider is not null)
  561. {
  562. dto.ProviderIds = entity.Provider.ToDictionary(e => e.ProviderId, e => e.ProviderValue);
  563. }
  564. if (entity.ExtraType is not null)
  565. {
  566. dto.ExtraType = (ExtraType)entity.ExtraType;
  567. }
  568. if (entity.LockedFields is not null)
  569. {
  570. dto.LockedFields = entity.LockedFields?.Select(e => (MetadataField)e.Id).ToArray() ?? [];
  571. }
  572. if (entity.Audio is not null)
  573. {
  574. dto.Audio = (ProgramAudio)entity.Audio;
  575. }
  576. dto.ExtraIds = string.IsNullOrWhiteSpace(entity.ExtraIds) ? [] : entity.ExtraIds.Split('|').Select(e => Guid.Parse(e)).ToArray();
  577. dto.ProductionLocations = entity.ProductionLocations?.Split('|') ?? [];
  578. dto.Studios = entity.Studios?.Split('|') ?? [];
  579. dto.Tags = entity.Tags?.Split('|') ?? [];
  580. if (dto is IHasProgramAttributes hasProgramAttributes)
  581. {
  582. hasProgramAttributes.IsMovie = entity.IsMovie;
  583. hasProgramAttributes.IsSeries = entity.IsSeries;
  584. hasProgramAttributes.EpisodeTitle = entity.EpisodeTitle;
  585. hasProgramAttributes.IsRepeat = entity.IsRepeat;
  586. }
  587. if (dto is LiveTvChannel liveTvChannel)
  588. {
  589. liveTvChannel.ServiceName = entity.ExternalServiceId;
  590. }
  591. if (dto is Trailer trailer)
  592. {
  593. trailer.TrailerTypes = entity.TrailerTypes?.Select(e => (TrailerType)e.Id).ToArray() ?? [];
  594. }
  595. if (dto is Video video)
  596. {
  597. video.PrimaryVersionId = entity.PrimaryVersionId;
  598. }
  599. if (dto is IHasSeries hasSeriesName)
  600. {
  601. hasSeriesName.SeriesName = entity.SeriesName;
  602. hasSeriesName.SeriesId = entity.SeriesId.GetValueOrDefault();
  603. hasSeriesName.SeriesPresentationUniqueKey = entity.SeriesPresentationUniqueKey;
  604. }
  605. if (dto is Episode episode)
  606. {
  607. episode.SeasonName = entity.SeasonName;
  608. episode.SeasonId = entity.SeasonId.GetValueOrDefault();
  609. }
  610. if (dto is IHasArtist hasArtists)
  611. {
  612. hasArtists.Artists = entity.Artists?.Split('|', StringSplitOptions.RemoveEmptyEntries) ?? [];
  613. }
  614. if (dto is IHasAlbumArtist hasAlbumArtists)
  615. {
  616. hasAlbumArtists.AlbumArtists = entity.AlbumArtists?.Split('|', StringSplitOptions.RemoveEmptyEntries) ?? [];
  617. }
  618. if (dto is LiveTvProgram program)
  619. {
  620. program.ShowId = entity.ShowId;
  621. }
  622. if (entity.Images is not null)
  623. {
  624. dto.ImageInfos = entity.Images.Select(e => Map(e, appHost)).ToArray();
  625. }
  626. // dto.Type = entity.Type;
  627. // dto.Data = entity.Data;
  628. // dto.MediaType = Enum.TryParse<MediaType>(entity.MediaType);
  629. if (dto is IHasStartDate hasStartDate)
  630. {
  631. hasStartDate.StartDate = entity.StartDate.GetValueOrDefault();
  632. }
  633. // Fields that are present in the DB but are never actually used
  634. // dto.UnratedType = entity.UnratedType;
  635. // dto.TopParentId = entity.TopParentId;
  636. // dto.CleanName = entity.CleanName;
  637. // dto.UserDataKey = entity.UserDataKey;
  638. if (dto is Folder folder)
  639. {
  640. folder.DateLastMediaAdded = entity.DateLastMediaAdded;
  641. }
  642. return dto;
  643. }
  644. /// <summary>
  645. /// Maps a Entity to the DTO.
  646. /// </summary>
  647. /// <param name="dto">The entity.</param>
  648. /// <returns>The dto to map.</returns>
  649. public BaseItemEntity Map(BaseItemDto dto)
  650. {
  651. var dtoType = dto.GetType();
  652. var entity = new BaseItemEntity()
  653. {
  654. Type = dtoType.ToString(),
  655. Id = dto.Id
  656. };
  657. if (TypeRequiresDeserialization(dtoType))
  658. {
  659. entity.Data = JsonSerializer.Serialize(dto, dtoType, JsonDefaults.Options);
  660. }
  661. entity.ParentId = !dto.ParentId.IsEmpty() ? dto.ParentId : null;
  662. entity.Path = GetPathToSave(dto.Path);
  663. entity.EndDate = dto.EndDate;
  664. entity.CommunityRating = dto.CommunityRating;
  665. entity.CustomRating = dto.CustomRating;
  666. entity.IndexNumber = dto.IndexNumber;
  667. entity.IsLocked = dto.IsLocked;
  668. entity.Name = dto.Name;
  669. entity.CleanName = GetCleanValue(dto.Name);
  670. entity.OfficialRating = dto.OfficialRating;
  671. entity.Overview = dto.Overview;
  672. entity.ParentIndexNumber = dto.ParentIndexNumber;
  673. entity.PremiereDate = dto.PremiereDate;
  674. entity.ProductionYear = dto.ProductionYear;
  675. entity.SortName = dto.SortName;
  676. entity.ForcedSortName = dto.ForcedSortName;
  677. entity.RunTimeTicks = dto.RunTimeTicks;
  678. entity.PreferredMetadataLanguage = dto.PreferredMetadataLanguage;
  679. entity.PreferredMetadataCountryCode = dto.PreferredMetadataCountryCode;
  680. entity.IsInMixedFolder = dto.IsInMixedFolder;
  681. entity.InheritedParentalRatingValue = dto.InheritedParentalRatingValue;
  682. entity.InheritedParentalRatingSubValue = dto.InheritedParentalRatingSubValue;
  683. entity.CriticRating = dto.CriticRating;
  684. entity.PresentationUniqueKey = dto.PresentationUniqueKey;
  685. entity.OriginalTitle = dto.OriginalTitle;
  686. entity.Album = dto.Album;
  687. entity.LUFS = dto.LUFS;
  688. entity.NormalizationGain = dto.NormalizationGain;
  689. entity.IsVirtualItem = dto.IsVirtualItem;
  690. entity.ExternalSeriesId = dto.ExternalSeriesId;
  691. entity.Tagline = dto.Tagline;
  692. entity.TotalBitrate = dto.TotalBitrate;
  693. entity.ExternalId = dto.ExternalId;
  694. entity.Size = dto.Size;
  695. entity.Genres = string.Join('|', dto.Genres);
  696. entity.DateCreated = dto.DateCreated;
  697. entity.DateModified = dto.DateModified;
  698. entity.ChannelId = dto.ChannelId;
  699. entity.DateLastRefreshed = dto.DateLastRefreshed;
  700. entity.DateLastSaved = dto.DateLastSaved;
  701. entity.OwnerId = dto.OwnerId.ToString();
  702. entity.Width = dto.Width;
  703. entity.Height = dto.Height;
  704. entity.Provider = dto.ProviderIds.Select(e => new BaseItemProvider()
  705. {
  706. Item = entity,
  707. ProviderId = e.Key,
  708. ProviderValue = e.Value
  709. }).ToList();
  710. if (dto.Audio.HasValue)
  711. {
  712. entity.Audio = (ProgramAudioEntity)dto.Audio;
  713. }
  714. if (dto.ExtraType.HasValue)
  715. {
  716. entity.ExtraType = (BaseItemExtraType)dto.ExtraType;
  717. }
  718. entity.ExtraIds = dto.ExtraIds is not null ? string.Join('|', dto.ExtraIds) : null;
  719. entity.ProductionLocations = dto.ProductionLocations is not null ? string.Join('|', dto.ProductionLocations) : null;
  720. entity.Studios = dto.Studios is not null ? string.Join('|', dto.Studios) : null;
  721. entity.Tags = dto.Tags is not null ? string.Join('|', dto.Tags) : null;
  722. entity.LockedFields = dto.LockedFields is not null ? dto.LockedFields
  723. .Select(e => new BaseItemMetadataField()
  724. {
  725. Id = (int)e,
  726. Item = entity,
  727. ItemId = entity.Id
  728. })
  729. .ToArray() : null;
  730. if (dto is IHasProgramAttributes hasProgramAttributes)
  731. {
  732. entity.IsMovie = hasProgramAttributes.IsMovie;
  733. entity.IsSeries = hasProgramAttributes.IsSeries;
  734. entity.EpisodeTitle = hasProgramAttributes.EpisodeTitle;
  735. entity.IsRepeat = hasProgramAttributes.IsRepeat;
  736. }
  737. if (dto is LiveTvChannel liveTvChannel)
  738. {
  739. entity.ExternalServiceId = liveTvChannel.ServiceName;
  740. }
  741. if (dto is Video video)
  742. {
  743. entity.PrimaryVersionId = video.PrimaryVersionId;
  744. }
  745. if (dto is IHasSeries hasSeriesName)
  746. {
  747. entity.SeriesName = hasSeriesName.SeriesName;
  748. entity.SeriesId = hasSeriesName.SeriesId;
  749. entity.SeriesPresentationUniqueKey = hasSeriesName.SeriesPresentationUniqueKey;
  750. }
  751. if (dto is Episode episode)
  752. {
  753. entity.SeasonName = episode.SeasonName;
  754. entity.SeasonId = episode.SeasonId;
  755. }
  756. if (dto is IHasArtist hasArtists)
  757. {
  758. entity.Artists = hasArtists.Artists is not null ? string.Join('|', hasArtists.Artists) : null;
  759. }
  760. if (dto is IHasAlbumArtist hasAlbumArtists)
  761. {
  762. entity.AlbumArtists = hasAlbumArtists.AlbumArtists is not null ? string.Join('|', hasAlbumArtists.AlbumArtists) : null;
  763. }
  764. if (dto is LiveTvProgram program)
  765. {
  766. entity.ShowId = program.ShowId;
  767. }
  768. if (dto.ImageInfos is not null)
  769. {
  770. entity.Images = dto.ImageInfos.Select(f => Map(dto.Id, f)).ToArray();
  771. }
  772. if (dto is Trailer trailer)
  773. {
  774. entity.TrailerTypes = trailer.TrailerTypes?.Select(e => new BaseItemTrailerType()
  775. {
  776. Id = (int)e,
  777. Item = entity,
  778. ItemId = entity.Id
  779. }).ToArray() ?? [];
  780. }
  781. // dto.Type = entity.Type;
  782. // dto.Data = entity.Data;
  783. entity.MediaType = dto.MediaType.ToString();
  784. if (dto is IHasStartDate hasStartDate)
  785. {
  786. entity.StartDate = hasStartDate.StartDate;
  787. }
  788. entity.UnratedType = dto.GetBlockUnratedType().ToString();
  789. // Fields that are present in the DB but are never actually used
  790. // dto.UserDataKey = entity.UserDataKey;
  791. if (dto is Folder folder)
  792. {
  793. entity.DateLastMediaAdded = folder.DateLastMediaAdded;
  794. entity.IsFolder = folder.IsFolder;
  795. }
  796. return entity;
  797. }
  798. private string[] GetItemValueNames(IReadOnlyList<ItemValueType> itemValueTypes, IReadOnlyList<string> withItemTypes, IReadOnlyList<string> excludeItemTypes)
  799. {
  800. using var context = _dbProvider.CreateDbContext();
  801. var query = context.ItemValuesMap
  802. .AsNoTracking()
  803. .Where(e => itemValueTypes.Any(w => (ItemValueType)w == e.ItemValue.Type));
  804. if (withItemTypes.Count > 0)
  805. {
  806. query = query.Where(e => withItemTypes.Contains(e.Item.Type));
  807. }
  808. if (excludeItemTypes.Count > 0)
  809. {
  810. query = query.Where(e => !excludeItemTypes.Contains(e.Item.Type));
  811. }
  812. // query = query.DistinctBy(e => e.CleanValue);
  813. return query.Select(e => e.ItemValue)
  814. .GroupBy(e => e.CleanValue)
  815. .Select(e => e.First().Value)
  816. .ToArray();
  817. }
  818. private static bool TypeRequiresDeserialization(Type type)
  819. {
  820. return type.GetCustomAttribute<RequiresSourceSerialisationAttribute>() == null;
  821. }
  822. private BaseItemDto DeserialiseBaseItem(BaseItemEntity baseItemEntity, bool skipDeserialization = false)
  823. {
  824. ArgumentNullException.ThrowIfNull(baseItemEntity, nameof(baseItemEntity));
  825. if (_serverConfigurationManager?.Configuration is null)
  826. {
  827. throw new InvalidOperationException("Server Configuration manager or configuration is null");
  828. }
  829. var typeToSerialise = GetType(baseItemEntity.Type);
  830. return BaseItemRepository.DeserialiseBaseItem(
  831. baseItemEntity,
  832. _logger,
  833. _appHost,
  834. skipDeserialization || (_serverConfigurationManager.Configuration.SkipDeserializationForBasicTypes && (typeToSerialise == typeof(Channel) || typeToSerialise == typeof(UserRootFolder))));
  835. }
  836. /// <summary>
  837. /// Deserialises a BaseItemEntity and sets all properties.
  838. /// </summary>
  839. /// <param name="baseItemEntity">The DB entity.</param>
  840. /// <param name="logger">Logger.</param>
  841. /// <param name="appHost">The application server Host.</param>
  842. /// <param name="skipDeserialization">If only mapping should be processed.</param>
  843. /// <returns>A mapped BaseItem.</returns>
  844. /// <exception cref="InvalidOperationException">Will be thrown if an invalid serialisation is requested.</exception>
  845. public static BaseItemDto DeserialiseBaseItem(BaseItemEntity baseItemEntity, ILogger logger, IServerApplicationHost? appHost, bool skipDeserialization = false)
  846. {
  847. var type = GetType(baseItemEntity.Type) ?? throw new InvalidOperationException("Cannot deserialise unknown type.");
  848. BaseItemDto? dto = null;
  849. if (TypeRequiresDeserialization(type) && baseItemEntity.Data is not null && !skipDeserialization)
  850. {
  851. try
  852. {
  853. dto = JsonSerializer.Deserialize(baseItemEntity.Data, type, JsonDefaults.Options) as BaseItemDto;
  854. }
  855. catch (JsonException ex)
  856. {
  857. logger.LogError(ex, "Error deserializing item with JSON: {Data}", baseItemEntity.Data);
  858. }
  859. }
  860. if (dto is null)
  861. {
  862. dto = Activator.CreateInstance(type) as BaseItemDto ?? throw new InvalidOperationException("Cannot deserialise unknown type.");
  863. }
  864. return Map(baseItemEntity, dto, appHost);
  865. }
  866. private QueryResult<(BaseItemDto Item, ItemCounts ItemCounts)> GetItemValues(InternalItemsQuery filter, IReadOnlyList<ItemValueType> itemValueTypes, string returnType)
  867. {
  868. ArgumentNullException.ThrowIfNull(filter);
  869. if (!filter.Limit.HasValue)
  870. {
  871. filter.EnableTotalRecordCount = false;
  872. }
  873. using var context = _dbProvider.CreateDbContext();
  874. var query = TranslateQuery(context.BaseItems.AsNoTracking(), context, filter);
  875. query = query.Where(e => e.Type == returnType);
  876. // this does not seem to be nesseary but it does not make any sense why this isn't working.
  877. // && e.ItemValues!.Any(f => e.CleanName == f.ItemValue.CleanValue && itemValueTypes.Any(w => (ItemValueType)w == f.ItemValue.Type)));
  878. if (filter.OrderBy.Count != 0
  879. || !string.IsNullOrEmpty(filter.SearchTerm))
  880. {
  881. query = ApplyOrder(query, filter);
  882. }
  883. else
  884. {
  885. query = query.OrderBy(e => e.SortName);
  886. }
  887. if (filter.Limit.HasValue || filter.StartIndex.HasValue)
  888. {
  889. var offset = filter.StartIndex ?? 0;
  890. if (offset > 0)
  891. {
  892. query = query.Skip(offset);
  893. }
  894. if (filter.Limit.HasValue)
  895. {
  896. query = query.Take(filter.Limit.Value);
  897. }
  898. }
  899. var result = new QueryResult<(BaseItemDto, ItemCounts)>();
  900. if (filter.EnableTotalRecordCount)
  901. {
  902. result.TotalRecordCount = query.GroupBy(e => e.PresentationUniqueKey).Select(e => e.First()).Count();
  903. }
  904. var seriesTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Series];
  905. var movieTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Movie];
  906. var episodeTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Episode];
  907. var musicAlbumTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicAlbum];
  908. var musicArtistTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist];
  909. var audioTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Audio];
  910. var trailerTypeName = _itemTypeLookup.BaseItemKindNames[BaseItemKind.Trailer];
  911. var resultQuery = query.Select(e => new
  912. {
  913. item = e,
  914. // TODO: This is bad refactor!
  915. itemCount = new ItemCounts()
  916. {
  917. SeriesCount = e.ItemValues!.Count(f => f.Item.Type == seriesTypeName),
  918. EpisodeCount = e.ItemValues!.Count(f => f.Item.Type == episodeTypeName),
  919. MovieCount = e.ItemValues!.Count(f => f.Item.Type == movieTypeName),
  920. AlbumCount = e.ItemValues!.Count(f => f.Item.Type == musicAlbumTypeName),
  921. ArtistCount = e.ItemValues!.Count(f => f.Item.Type == musicArtistTypeName),
  922. SongCount = e.ItemValues!.Count(f => f.Item.Type == audioTypeName),
  923. TrailerCount = e.ItemValues!.Count(f => f.Item.Type == trailerTypeName),
  924. }
  925. });
  926. result.StartIndex = filter.StartIndex ?? 0;
  927. result.Items = resultQuery.ToArray().Where(e => e is not null).Select(e =>
  928. {
  929. return (DeserialiseBaseItem(e.item, filter.SkipDeserialization), e.itemCount);
  930. }).ToArray();
  931. return result;
  932. }
  933. private static void PrepareFilterQuery(InternalItemsQuery query)
  934. {
  935. if (query.Limit.HasValue && query.EnableGroupByMetadataKey)
  936. {
  937. query.Limit = query.Limit.Value + 4;
  938. }
  939. if (query.IsResumable ?? false)
  940. {
  941. query.IsVirtualItem = false;
  942. }
  943. }
  944. private string GetCleanValue(string value)
  945. {
  946. if (string.IsNullOrWhiteSpace(value))
  947. {
  948. return value;
  949. }
  950. return value.RemoveDiacritics().ToLowerInvariant();
  951. }
  952. private List<(int MagicNumber, string Value)> GetItemValuesToSave(BaseItemDto item, List<string> inheritedTags)
  953. {
  954. var list = new List<(int, string)>();
  955. if (item is IHasArtist hasArtist)
  956. {
  957. list.AddRange(hasArtist.Artists.Select(i => (0, i)));
  958. }
  959. if (item is IHasAlbumArtist hasAlbumArtist)
  960. {
  961. list.AddRange(hasAlbumArtist.AlbumArtists.Select(i => (1, i)));
  962. }
  963. list.AddRange(item.Genres.Select(i => (2, i)));
  964. list.AddRange(item.Studios.Select(i => (3, i)));
  965. list.AddRange(item.Tags.Select(i => (4, i)));
  966. // keywords was 5
  967. list.AddRange(inheritedTags.Select(i => (6, i)));
  968. // Remove all invalid values.
  969. list.RemoveAll(i => string.IsNullOrWhiteSpace(i.Item2));
  970. return list;
  971. }
  972. private static BaseItemImageInfo Map(Guid baseItemId, ItemImageInfo e)
  973. {
  974. return new BaseItemImageInfo()
  975. {
  976. ItemId = baseItemId,
  977. Id = Guid.NewGuid(),
  978. Path = e.Path,
  979. Blurhash = e.BlurHash is null ? null : Encoding.UTF8.GetBytes(e.BlurHash),
  980. DateModified = e.DateModified,
  981. Height = e.Height,
  982. Width = e.Width,
  983. ImageType = (ImageInfoImageType)e.Type,
  984. Item = null!
  985. };
  986. }
  987. private static ItemImageInfo Map(BaseItemImageInfo e, IServerApplicationHost? appHost)
  988. {
  989. return new ItemImageInfo()
  990. {
  991. Path = appHost?.ExpandVirtualPath(e.Path) ?? e.Path,
  992. BlurHash = e.Blurhash is null ? null : Encoding.UTF8.GetString(e.Blurhash),
  993. DateModified = e.DateModified,
  994. Height = e.Height,
  995. Width = e.Width,
  996. Type = (ImageType)e.ImageType
  997. };
  998. }
  999. private string? GetPathToSave(string path)
  1000. {
  1001. if (path is null)
  1002. {
  1003. return null;
  1004. }
  1005. return _appHost.ReverseVirtualPath(path);
  1006. }
  1007. private List<string> GetItemByNameTypesInQuery(InternalItemsQuery query)
  1008. {
  1009. var list = new List<string>();
  1010. if (IsTypeInQuery(BaseItemKind.Person, query))
  1011. {
  1012. list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.Person]!);
  1013. }
  1014. if (IsTypeInQuery(BaseItemKind.Genre, query))
  1015. {
  1016. list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.Genre]!);
  1017. }
  1018. if (IsTypeInQuery(BaseItemKind.MusicGenre, query))
  1019. {
  1020. list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicGenre]!);
  1021. }
  1022. if (IsTypeInQuery(BaseItemKind.MusicArtist, query))
  1023. {
  1024. list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.MusicArtist]!);
  1025. }
  1026. if (IsTypeInQuery(BaseItemKind.Studio, query))
  1027. {
  1028. list.Add(_itemTypeLookup.BaseItemKindNames[BaseItemKind.Studio]!);
  1029. }
  1030. return list;
  1031. }
  1032. private bool IsTypeInQuery(BaseItemKind type, InternalItemsQuery query)
  1033. {
  1034. if (query.ExcludeItemTypes.Contains(type))
  1035. {
  1036. return false;
  1037. }
  1038. return query.IncludeItemTypes.Length == 0 || query.IncludeItemTypes.Contains(type);
  1039. }
  1040. private bool EnableGroupByPresentationUniqueKey(InternalItemsQuery query)
  1041. {
  1042. if (!query.GroupByPresentationUniqueKey)
  1043. {
  1044. return false;
  1045. }
  1046. if (query.GroupBySeriesPresentationUniqueKey)
  1047. {
  1048. return false;
  1049. }
  1050. if (!string.IsNullOrWhiteSpace(query.PresentationUniqueKey))
  1051. {
  1052. return false;
  1053. }
  1054. if (query.User is null)
  1055. {
  1056. return false;
  1057. }
  1058. if (query.IncludeItemTypes.Length == 0)
  1059. {
  1060. return true;
  1061. }
  1062. return query.IncludeItemTypes.Contains(BaseItemKind.Episode)
  1063. || query.IncludeItemTypes.Contains(BaseItemKind.Video)
  1064. || query.IncludeItemTypes.Contains(BaseItemKind.Movie)
  1065. || query.IncludeItemTypes.Contains(BaseItemKind.MusicVideo)
  1066. || query.IncludeItemTypes.Contains(BaseItemKind.Series)
  1067. || query.IncludeItemTypes.Contains(BaseItemKind.Season);
  1068. }
  1069. private IQueryable<BaseItemEntity> ApplyOrder(IQueryable<BaseItemEntity> query, InternalItemsQuery filter)
  1070. {
  1071. var orderBy = filter.OrderBy;
  1072. var hasSearch = !string.IsNullOrEmpty(filter.SearchTerm);
  1073. if (hasSearch)
  1074. {
  1075. orderBy = filter.OrderBy = [(ItemSortBy.SortName, SortOrder.Ascending), .. orderBy];
  1076. }
  1077. else if (orderBy.Count == 0)
  1078. {
  1079. return query;
  1080. }
  1081. IOrderedQueryable<BaseItemEntity>? orderedQuery = null;
  1082. var firstOrdering = orderBy.FirstOrDefault();
  1083. if (firstOrdering != default)
  1084. {
  1085. var expression = OrderMapper.MapOrderByField(firstOrdering.OrderBy, filter);
  1086. if (firstOrdering.SortOrder == SortOrder.Ascending)
  1087. {
  1088. orderedQuery = query.OrderBy(expression);
  1089. }
  1090. else
  1091. {
  1092. orderedQuery = query.OrderByDescending(expression);
  1093. }
  1094. if (firstOrdering.OrderBy is ItemSortBy.Default or ItemSortBy.SortName)
  1095. {
  1096. if (firstOrdering.SortOrder is SortOrder.Ascending)
  1097. {
  1098. orderedQuery = orderedQuery.ThenBy(e => e.Name);
  1099. }
  1100. else
  1101. {
  1102. orderedQuery = orderedQuery.ThenByDescending(e => e.Name);
  1103. }
  1104. }
  1105. }
  1106. foreach (var item in orderBy.Skip(1))
  1107. {
  1108. var expression = OrderMapper.MapOrderByField(item.OrderBy, filter);
  1109. if (item.SortOrder == SortOrder.Ascending)
  1110. {
  1111. orderedQuery = orderedQuery!.ThenBy(expression);
  1112. }
  1113. else
  1114. {
  1115. orderedQuery = orderedQuery!.ThenByDescending(expression);
  1116. }
  1117. }
  1118. return orderedQuery ?? query;
  1119. }
  1120. private IQueryable<BaseItemEntity> TranslateQuery(
  1121. IQueryable<BaseItemEntity> baseQuery,
  1122. JellyfinDbContext context,
  1123. InternalItemsQuery filter)
  1124. {
  1125. var minWidth = filter.MinWidth;
  1126. var maxWidth = filter.MaxWidth;
  1127. var now = DateTime.UtcNow;
  1128. if (filter.IsHD.HasValue)
  1129. {
  1130. const int Threshold = 1200;
  1131. if (filter.IsHD.Value)
  1132. {
  1133. minWidth = Threshold;
  1134. }
  1135. else
  1136. {
  1137. maxWidth = Threshold - 1;
  1138. }
  1139. }
  1140. if (filter.Is4K.HasValue)
  1141. {
  1142. const int Threshold = 3800;
  1143. if (filter.Is4K.Value)
  1144. {
  1145. minWidth = Threshold;
  1146. }
  1147. else
  1148. {
  1149. maxWidth = Threshold - 1;
  1150. }
  1151. }
  1152. if (minWidth.HasValue)
  1153. {
  1154. baseQuery = baseQuery.Where(e => e.Width >= minWidth);
  1155. }
  1156. if (filter.MinHeight.HasValue)
  1157. {
  1158. baseQuery = baseQuery.Where(e => e.Height >= filter.MinHeight);
  1159. }
  1160. if (maxWidth.HasValue)
  1161. {
  1162. baseQuery = baseQuery.Where(e => e.Width >= maxWidth);
  1163. }
  1164. if (filter.MaxHeight.HasValue)
  1165. {
  1166. baseQuery = baseQuery.Where(e => e.Height <= filter.MaxHeight);
  1167. }
  1168. if (filter.IsLocked.HasValue)
  1169. {
  1170. baseQuery = baseQuery.Where(e => e.IsLocked == filter.IsLocked);
  1171. }
  1172. var tags = filter.Tags.ToList();
  1173. var excludeTags = filter.ExcludeTags.ToList();
  1174. if (filter.IsMovie == true)
  1175. {
  1176. if (filter.IncludeItemTypes.Length == 0
  1177. || filter.IncludeItemTypes.Contains(BaseItemKind.Movie)
  1178. || filter.IncludeItemTypes.Contains(BaseItemKind.Trailer))
  1179. {
  1180. baseQuery = baseQuery.Where(e => e.IsMovie);
  1181. }
  1182. }
  1183. else if (filter.IsMovie.HasValue)
  1184. {
  1185. baseQuery = baseQuery.Where(e => e.IsMovie == filter.IsMovie);
  1186. }
  1187. if (filter.IsSeries.HasValue)
  1188. {
  1189. baseQuery = baseQuery.Where(e => e.IsSeries == filter.IsSeries);
  1190. }
  1191. if (filter.IsSports.HasValue)
  1192. {
  1193. if (filter.IsSports.Value)
  1194. {
  1195. tags.Add("Sports");
  1196. }
  1197. else
  1198. {
  1199. excludeTags.Add("Sports");
  1200. }
  1201. }
  1202. if (filter.IsNews.HasValue)
  1203. {
  1204. if (filter.IsNews.Value)
  1205. {
  1206. tags.Add("News");
  1207. }
  1208. else
  1209. {
  1210. excludeTags.Add("News");
  1211. }
  1212. }
  1213. if (filter.IsKids.HasValue)
  1214. {
  1215. if (filter.IsKids.Value)
  1216. {
  1217. tags.Add("Kids");
  1218. }
  1219. else
  1220. {
  1221. excludeTags.Add("Kids");
  1222. }
  1223. }
  1224. if (!string.IsNullOrEmpty(filter.SearchTerm))
  1225. {
  1226. var searchTerm = filter.SearchTerm.ToLower();
  1227. baseQuery = baseQuery.Where(e => e.CleanName!.ToLower().Contains(searchTerm) || (e.OriginalTitle != null && e.OriginalTitle.ToLower().Contains(searchTerm)));
  1228. }
  1229. if (filter.IsFolder.HasValue)
  1230. {
  1231. baseQuery = baseQuery.Where(e => e.IsFolder == filter.IsFolder);
  1232. }
  1233. var includeTypes = filter.IncludeItemTypes;
  1234. // Only specify excluded types if no included types are specified
  1235. if (filter.IncludeItemTypes.Length == 0)
  1236. {
  1237. var excludeTypes = filter.ExcludeItemTypes;
  1238. if (excludeTypes.Length == 1)
  1239. {
  1240. if (_itemTypeLookup.BaseItemKindNames.TryGetValue(excludeTypes[0], out var excludeTypeName))
  1241. {
  1242. baseQuery = baseQuery.Where(e => e.Type != excludeTypeName);
  1243. }
  1244. }
  1245. else if (excludeTypes.Length > 1)
  1246. {
  1247. var excludeTypeName = new List<string>();
  1248. foreach (var excludeType in excludeTypes)
  1249. {
  1250. if (_itemTypeLookup.BaseItemKindNames.TryGetValue(excludeType, out var baseItemKindName))
  1251. {
  1252. excludeTypeName.Add(baseItemKindName!);
  1253. }
  1254. }
  1255. baseQuery = baseQuery.Where(e => !excludeTypeName.Contains(e.Type));
  1256. }
  1257. }
  1258. else if (includeTypes.Length == 1)
  1259. {
  1260. if (_itemTypeLookup.BaseItemKindNames.TryGetValue(includeTypes[0], out var includeTypeName))
  1261. {
  1262. baseQuery = baseQuery.Where(e => e.Type == includeTypeName);
  1263. }
  1264. }
  1265. else if (includeTypes.Length > 1)
  1266. {
  1267. var includeTypeName = new List<string>();
  1268. foreach (var includeType in includeTypes)
  1269. {
  1270. if (_itemTypeLookup.BaseItemKindNames.TryGetValue(includeType, out var baseItemKindName))
  1271. {
  1272. includeTypeName.Add(baseItemKindName!);
  1273. }
  1274. }
  1275. baseQuery = baseQuery.Where(e => includeTypeName.Contains(e.Type));
  1276. }
  1277. if (filter.ChannelIds.Count > 0)
  1278. {
  1279. baseQuery = baseQuery.Where(e => e.ChannelId != null && filter.ChannelIds.Contains(e.ChannelId.Value));
  1280. }
  1281. if (!filter.ParentId.IsEmpty())
  1282. {
  1283. baseQuery = baseQuery.Where(e => e.ParentId!.Value == filter.ParentId);
  1284. }
  1285. if (!string.IsNullOrWhiteSpace(filter.Path))
  1286. {
  1287. baseQuery = baseQuery.Where(e => e.Path == filter.Path);
  1288. }
  1289. if (!string.IsNullOrWhiteSpace(filter.PresentationUniqueKey))
  1290. {
  1291. baseQuery = baseQuery.Where(e => e.PresentationUniqueKey == filter.PresentationUniqueKey);
  1292. }
  1293. if (filter.MinCommunityRating.HasValue)
  1294. {
  1295. baseQuery = baseQuery.Where(e => e.CommunityRating >= filter.MinCommunityRating);
  1296. }
  1297. if (filter.MinIndexNumber.HasValue)
  1298. {
  1299. baseQuery = baseQuery.Where(e => e.IndexNumber >= filter.MinIndexNumber);
  1300. }
  1301. if (filter.MinParentAndIndexNumber.HasValue)
  1302. {
  1303. baseQuery = baseQuery
  1304. .Where(e => (e.ParentIndexNumber == filter.MinParentAndIndexNumber.Value.ParentIndexNumber && e.IndexNumber >= filter.MinParentAndIndexNumber.Value.IndexNumber) || e.ParentIndexNumber > filter.MinParentAndIndexNumber.Value.ParentIndexNumber);
  1305. }
  1306. if (filter.MinDateCreated.HasValue)
  1307. {
  1308. baseQuery = baseQuery.Where(e => e.DateCreated >= filter.MinDateCreated);
  1309. }
  1310. if (filter.MinDateLastSaved.HasValue)
  1311. {
  1312. baseQuery = baseQuery.Where(e => e.DateLastSaved != null && e.DateLastSaved >= filter.MinDateLastSaved.Value);
  1313. }
  1314. if (filter.MinDateLastSavedForUser.HasValue)
  1315. {
  1316. baseQuery = baseQuery.Where(e => e.DateLastSaved != null && e.DateLastSaved >= filter.MinDateLastSavedForUser.Value);
  1317. }
  1318. if (filter.IndexNumber.HasValue)
  1319. {
  1320. baseQuery = baseQuery.Where(e => e.IndexNumber == filter.IndexNumber.Value);
  1321. }
  1322. if (filter.ParentIndexNumber.HasValue)
  1323. {
  1324. baseQuery = baseQuery.Where(e => e.ParentIndexNumber == filter.ParentIndexNumber.Value);
  1325. }
  1326. if (filter.ParentIndexNumberNotEquals.HasValue)
  1327. {
  1328. baseQuery = baseQuery.Where(e => e.ParentIndexNumber != filter.ParentIndexNumberNotEquals.Value || e.ParentIndexNumber == null);
  1329. }
  1330. var minEndDate = filter.MinEndDate;
  1331. var maxEndDate = filter.MaxEndDate;
  1332. if (filter.HasAired.HasValue)
  1333. {
  1334. if (filter.HasAired.Value)
  1335. {
  1336. maxEndDate = DateTime.UtcNow;
  1337. }
  1338. else
  1339. {
  1340. minEndDate = DateTime.UtcNow;
  1341. }
  1342. }
  1343. if (minEndDate.HasValue)
  1344. {
  1345. baseQuery = baseQuery.Where(e => e.EndDate >= minEndDate);
  1346. }
  1347. if (maxEndDate.HasValue)
  1348. {
  1349. baseQuery = baseQuery.Where(e => e.EndDate <= maxEndDate);
  1350. }
  1351. if (filter.MinStartDate.HasValue)
  1352. {
  1353. baseQuery = baseQuery.Where(e => e.StartDate >= filter.MinStartDate.Value);
  1354. }
  1355. if (filter.MaxStartDate.HasValue)
  1356. {
  1357. baseQuery = baseQuery.Where(e => e.StartDate <= filter.MaxStartDate.Value);
  1358. }
  1359. if (filter.MinPremiereDate.HasValue)
  1360. {
  1361. baseQuery = baseQuery.Where(e => e.PremiereDate <= filter.MinPremiereDate.Value);
  1362. }
  1363. if (filter.MaxPremiereDate.HasValue)
  1364. {
  1365. baseQuery = baseQuery.Where(e => e.PremiereDate <= filter.MaxPremiereDate.Value);
  1366. }
  1367. if (filter.TrailerTypes.Length > 0)
  1368. {
  1369. var trailerTypes = filter.TrailerTypes.Select(e => (int)e).ToArray();
  1370. baseQuery = baseQuery.Where(e => trailerTypes.Any(f => e.TrailerTypes!.Any(w => w.Id == f)));
  1371. }
  1372. if (filter.IsAiring.HasValue)
  1373. {
  1374. if (filter.IsAiring.Value)
  1375. {
  1376. baseQuery = baseQuery.Where(e => e.StartDate <= now && e.EndDate >= now);
  1377. }
  1378. else
  1379. {
  1380. baseQuery = baseQuery.Where(e => e.StartDate > now && e.EndDate < now);
  1381. }
  1382. }
  1383. if (filter.PersonIds.Length > 0)
  1384. {
  1385. baseQuery = baseQuery
  1386. .Where(e =>
  1387. context.PeopleBaseItemMap.Where(w => context.BaseItems.Where(r => filter.PersonIds.Contains(r.Id)).Any(f => f.Name == w.People.Name))
  1388. .Any(f => f.ItemId == e.Id));
  1389. }
  1390. if (!string.IsNullOrWhiteSpace(filter.Person))
  1391. {
  1392. baseQuery = baseQuery.Where(e => e.Peoples!.Any(f => f.People.Name == filter.Person));
  1393. }
  1394. if (!string.IsNullOrWhiteSpace(filter.MinSortName))
  1395. {
  1396. // this does not makes sense.
  1397. // baseQuery = baseQuery.Where(e => e.SortName >= query.MinSortName);
  1398. // whereClauses.Add("SortName>=@MinSortName");
  1399. // statement?.TryBind("@MinSortName", query.MinSortName);
  1400. }
  1401. if (!string.IsNullOrWhiteSpace(filter.ExternalSeriesId))
  1402. {
  1403. baseQuery = baseQuery.Where(e => e.ExternalSeriesId == filter.ExternalSeriesId);
  1404. }
  1405. if (!string.IsNullOrWhiteSpace(filter.ExternalId))
  1406. {
  1407. baseQuery = baseQuery.Where(e => e.ExternalId == filter.ExternalId);
  1408. }
  1409. if (!string.IsNullOrWhiteSpace(filter.Name))
  1410. {
  1411. var cleanName = GetCleanValue(filter.Name);
  1412. baseQuery = baseQuery.Where(e => e.CleanName == cleanName);
  1413. }
  1414. // These are the same, for now
  1415. var nameContains = filter.NameContains;
  1416. if (!string.IsNullOrWhiteSpace(nameContains))
  1417. {
  1418. baseQuery = baseQuery.Where(e =>
  1419. e.CleanName!.Contains(nameContains)
  1420. || e.OriginalTitle!.ToLower().Contains(nameContains!));
  1421. }
  1422. if (!string.IsNullOrWhiteSpace(filter.NameStartsWith))
  1423. {
  1424. baseQuery = baseQuery.Where(e => e.SortName!.StartsWith(filter.NameStartsWith) || e.Name!.StartsWith(filter.NameStartsWith));
  1425. }
  1426. if (!string.IsNullOrWhiteSpace(filter.NameStartsWithOrGreater))
  1427. {
  1428. // i hate this
  1429. baseQuery = baseQuery.Where(e => e.SortName!.FirstOrDefault() > filter.NameStartsWithOrGreater[0] || e.Name!.FirstOrDefault() > filter.NameStartsWithOrGreater[0]);
  1430. }
  1431. if (!string.IsNullOrWhiteSpace(filter.NameLessThan))
  1432. {
  1433. // i hate this
  1434. baseQuery = baseQuery.Where(e => e.SortName!.FirstOrDefault() < filter.NameLessThan[0] || e.Name!.FirstOrDefault() < filter.NameLessThan[0]);
  1435. }
  1436. if (filter.ImageTypes.Length > 0)
  1437. {
  1438. var imgTypes = filter.ImageTypes.Select(e => (ImageInfoImageType)e).ToArray();
  1439. baseQuery = baseQuery.Where(e => imgTypes.Any(f => e.Images!.Any(w => w.ImageType == f)));
  1440. }
  1441. if (filter.IsLiked.HasValue)
  1442. {
  1443. baseQuery = baseQuery
  1444. .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.Rating >= UserItemData.MinLikeValue);
  1445. }
  1446. if (filter.IsFavoriteOrLiked.HasValue)
  1447. {
  1448. baseQuery = baseQuery
  1449. .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.IsFavorite == filter.IsFavoriteOrLiked);
  1450. }
  1451. if (filter.IsFavorite.HasValue)
  1452. {
  1453. baseQuery = baseQuery
  1454. .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.IsFavorite == filter.IsFavorite);
  1455. }
  1456. if (filter.IsPlayed.HasValue)
  1457. {
  1458. // We should probably figure this out for all folders, but for right now, this is the only place where we need it
  1459. if (filter.IncludeItemTypes.Length == 1 && filter.IncludeItemTypes[0] == BaseItemKind.Series)
  1460. {
  1461. baseQuery = baseQuery.Where(e => context.BaseItems
  1462. .Where(e => e.IsFolder == false && e.IsVirtualItem == false)
  1463. .Where(f => f.UserData!.FirstOrDefault(e => e.UserId == filter.User!.Id && e.Played)!.Played)
  1464. .Any(f => f.SeriesPresentationUniqueKey == e.PresentationUniqueKey) == filter.IsPlayed);
  1465. }
  1466. else
  1467. {
  1468. baseQuery = baseQuery
  1469. .Select(e => new
  1470. {
  1471. IsPlayed = e.UserData!.Where(f => f.UserId == filter.User!.Id).Select(f => (bool?)f.Played).FirstOrDefault() ?? false,
  1472. Item = e
  1473. })
  1474. .Where(e => e.IsPlayed == filter.IsPlayed)
  1475. .Select(f => f.Item);
  1476. }
  1477. }
  1478. if (filter.IsResumable.HasValue)
  1479. {
  1480. if (filter.IsResumable.Value)
  1481. {
  1482. baseQuery = baseQuery
  1483. .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.PlaybackPositionTicks > 0);
  1484. }
  1485. else
  1486. {
  1487. baseQuery = baseQuery
  1488. .Where(e => e.UserData!.FirstOrDefault(f => f.UserId == filter.User!.Id)!.PlaybackPositionTicks == 0);
  1489. }
  1490. }
  1491. if (filter.ArtistIds.Length > 0)
  1492. {
  1493. baseQuery = baseQuery
  1494. .Where(e => e.ItemValues!.Any(f => f.ItemValue.Type <= ItemValueType.Artist && filter.ArtistIds.Contains(f.ItemId)));
  1495. }
  1496. if (filter.AlbumArtistIds.Length > 0)
  1497. {
  1498. baseQuery = baseQuery
  1499. .Where(e => e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Artist && filter.AlbumArtistIds.Contains(f.ItemId)));
  1500. }
  1501. if (filter.ContributingArtistIds.Length > 0)
  1502. {
  1503. baseQuery = baseQuery
  1504. .Where(e => e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Artist && filter.ContributingArtistIds.Contains(f.ItemId)));
  1505. }
  1506. if (filter.AlbumIds.Length > 0)
  1507. {
  1508. baseQuery = baseQuery.Where(e => context.BaseItems.Where(f => filter.AlbumIds.Contains(f.Id)).Any(f => f.Name == e.Album));
  1509. }
  1510. if (filter.ExcludeArtistIds.Length > 0)
  1511. {
  1512. baseQuery = baseQuery
  1513. .Where(e => !e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Artist && filter.ExcludeArtistIds.Contains(f.ItemId)));
  1514. }
  1515. if (filter.GenreIds.Count > 0)
  1516. {
  1517. baseQuery = baseQuery
  1518. .Where(e => e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Genre && filter.GenreIds.Contains(f.ItemId)));
  1519. }
  1520. if (filter.Genres.Count > 0)
  1521. {
  1522. var cleanGenres = filter.Genres.Select(e => GetCleanValue(e)).ToArray();
  1523. baseQuery = baseQuery
  1524. .Where(e => e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Genre && cleanGenres.Contains(f.ItemValue.CleanValue)));
  1525. }
  1526. if (tags.Count > 0)
  1527. {
  1528. var cleanValues = tags.Select(e => GetCleanValue(e)).ToArray();
  1529. baseQuery = baseQuery
  1530. .Where(e => e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Tags && cleanValues.Contains(f.ItemValue.CleanValue)));
  1531. }
  1532. if (excludeTags.Count > 0)
  1533. {
  1534. var cleanValues = excludeTags.Select(e => GetCleanValue(e)).ToArray();
  1535. baseQuery = baseQuery
  1536. .Where(e => !e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Tags && cleanValues.Contains(f.ItemValue.CleanValue)));
  1537. }
  1538. if (filter.StudioIds.Length > 0)
  1539. {
  1540. baseQuery = baseQuery
  1541. .Where(e => e.ItemValues!.Any(f => f.ItemValue.Type == ItemValueType.Studios && filter.StudioIds.Contains(f.ItemId)));
  1542. }
  1543. if (filter.OfficialRatings.Length > 0)
  1544. {
  1545. baseQuery = baseQuery
  1546. .Where(e => filter.OfficialRatings.Contains(e.OfficialRating));
  1547. }
  1548. Expression<Func<BaseItemEntity, bool>>? minParentalRatingFilter = null;
  1549. if (filter.MinParentalRating != null)
  1550. {
  1551. var min = filter.MinParentalRating;
  1552. minParentalRatingFilter = e => e.InheritedParentalRatingValue >= min.Score || e.InheritedParentalRatingValue == null;
  1553. if (min.SubScore != null)
  1554. {
  1555. minParentalRatingFilter = minParentalRatingFilter.And(e => e.InheritedParentalRatingValue >= min.SubScore || e.InheritedParentalRatingValue == null);
  1556. }
  1557. }
  1558. Expression<Func<BaseItemEntity, bool>>? maxParentalRatingFilter = null;
  1559. if (filter.MaxParentalRating != null)
  1560. {
  1561. var max = filter.MaxParentalRating;
  1562. maxParentalRatingFilter = e => e.InheritedParentalRatingValue <= max.Score || e.InheritedParentalRatingValue == null;
  1563. if (max.SubScore != null)
  1564. {
  1565. maxParentalRatingFilter = maxParentalRatingFilter.And(e => e.InheritedParentalRatingValue <= max.SubScore || e.InheritedParentalRatingValue == null);
  1566. }
  1567. }
  1568. if (filter.HasParentalRating ?? false)
  1569. {
  1570. if (minParentalRatingFilter != null)
  1571. {
  1572. baseQuery = baseQuery.Where(minParentalRatingFilter);
  1573. }
  1574. if (maxParentalRatingFilter != null)
  1575. {
  1576. baseQuery = baseQuery.Where(maxParentalRatingFilter);
  1577. }
  1578. }
  1579. else if (filter.BlockUnratedItems.Length > 0)
  1580. {
  1581. var unratedItemTypes = filter.BlockUnratedItems.Select(f => f.ToString()).ToArray();
  1582. Expression<Func<BaseItemEntity, bool>> unratedItemFilter = e => e.InheritedParentalRatingValue != null || !unratedItemTypes.Contains(e.UnratedType);
  1583. if (minParentalRatingFilter != null && maxParentalRatingFilter != null)
  1584. {
  1585. baseQuery = baseQuery.Where(unratedItemFilter.And(minParentalRatingFilter.And(maxParentalRatingFilter)));
  1586. }
  1587. else if (minParentalRatingFilter != null)
  1588. {
  1589. baseQuery = baseQuery.Where(unratedItemFilter.And(minParentalRatingFilter));
  1590. }
  1591. else if (maxParentalRatingFilter != null)
  1592. {
  1593. baseQuery = baseQuery.Where(unratedItemFilter.And(maxParentalRatingFilter));
  1594. }
  1595. else
  1596. {
  1597. baseQuery = baseQuery.Where(unratedItemFilter);
  1598. }
  1599. }
  1600. else if (minParentalRatingFilter != null || maxParentalRatingFilter != null)
  1601. {
  1602. if (minParentalRatingFilter != null)
  1603. {
  1604. baseQuery = baseQuery.Where(minParentalRatingFilter);
  1605. }
  1606. if (maxParentalRatingFilter != null)
  1607. {
  1608. baseQuery = baseQuery.Where(maxParentalRatingFilter);
  1609. }
  1610. }
  1611. else if (!filter.HasParentalRating ?? false)
  1612. {
  1613. baseQuery = baseQuery
  1614. .Where(e => e.InheritedParentalRatingValue == null);
  1615. }
  1616. if (filter.HasOfficialRating.HasValue)
  1617. {
  1618. if (filter.HasOfficialRating.Value)
  1619. {
  1620. baseQuery = baseQuery
  1621. .Where(e => e.OfficialRating != null && e.OfficialRating != string.Empty);
  1622. }
  1623. else
  1624. {
  1625. baseQuery = baseQuery
  1626. .Where(e => e.OfficialRating == null || e.OfficialRating == string.Empty);
  1627. }
  1628. }
  1629. if (filter.HasOverview.HasValue)
  1630. {
  1631. if (filter.HasOverview.Value)
  1632. {
  1633. baseQuery = baseQuery
  1634. .Where(e => e.Overview != null && e.Overview != string.Empty);
  1635. }
  1636. else
  1637. {
  1638. baseQuery = baseQuery
  1639. .Where(e => e.Overview == null || e.Overview == string.Empty);
  1640. }
  1641. }
  1642. if (filter.HasOwnerId.HasValue)
  1643. {
  1644. if (filter.HasOwnerId.Value)
  1645. {
  1646. baseQuery = baseQuery
  1647. .Where(e => e.OwnerId != null);
  1648. }
  1649. else
  1650. {
  1651. baseQuery = baseQuery
  1652. .Where(e => e.OwnerId == null);
  1653. }
  1654. }
  1655. if (!string.IsNullOrWhiteSpace(filter.HasNoAudioTrackWithLanguage))
  1656. {
  1657. baseQuery = baseQuery
  1658. .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Audio && f.Language == filter.HasNoAudioTrackWithLanguage));
  1659. }
  1660. if (!string.IsNullOrWhiteSpace(filter.HasNoInternalSubtitleTrackWithLanguage))
  1661. {
  1662. baseQuery = baseQuery
  1663. .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle && !f.IsExternal && f.Language == filter.HasNoInternalSubtitleTrackWithLanguage));
  1664. }
  1665. if (!string.IsNullOrWhiteSpace(filter.HasNoExternalSubtitleTrackWithLanguage))
  1666. {
  1667. baseQuery = baseQuery
  1668. .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle && f.IsExternal && f.Language == filter.HasNoExternalSubtitleTrackWithLanguage));
  1669. }
  1670. if (!string.IsNullOrWhiteSpace(filter.HasNoSubtitleTrackWithLanguage))
  1671. {
  1672. baseQuery = baseQuery
  1673. .Where(e => !e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle && f.Language == filter.HasNoSubtitleTrackWithLanguage));
  1674. }
  1675. if (filter.HasSubtitles.HasValue)
  1676. {
  1677. baseQuery = baseQuery
  1678. .Where(e => e.MediaStreams!.Any(f => f.StreamType == MediaStreamTypeEntity.Subtitle) == filter.HasSubtitles.Value);
  1679. }
  1680. if (filter.HasChapterImages.HasValue)
  1681. {
  1682. baseQuery = baseQuery
  1683. .Where(e => e.Chapters!.Any(f => f.ImagePath != null) == filter.HasChapterImages.Value);
  1684. }
  1685. if (filter.HasDeadParentId.HasValue && filter.HasDeadParentId.Value)
  1686. {
  1687. baseQuery = baseQuery
  1688. .Where(e => e.ParentId.HasValue && !context.BaseItems.Any(f => f.Id == e.ParentId.Value));
  1689. }
  1690. if (filter.IsDeadArtist.HasValue && filter.IsDeadArtist.Value)
  1691. {
  1692. baseQuery = baseQuery
  1693. .Where(e => !context.ItemValues.Where(f => _getAllArtistsValueTypes.Contains(f.Type)).Any(f => f.Value == e.Name));
  1694. }
  1695. if (filter.IsDeadStudio.HasValue && filter.IsDeadStudio.Value)
  1696. {
  1697. baseQuery = baseQuery
  1698. .Where(e => !context.ItemValues.Where(f => _getStudiosValueTypes.Contains(f.Type)).Any(f => f.Value == e.Name));
  1699. }
  1700. if (filter.IsDeadGenre.HasValue && filter.IsDeadGenre.Value)
  1701. {
  1702. baseQuery = baseQuery
  1703. .Where(e => !context.ItemValues.Where(f => _getGenreValueTypes.Contains(f.Type)).Any(f => f.Value == e.Name));
  1704. }
  1705. if (filter.IsDeadPerson.HasValue && filter.IsDeadPerson.Value)
  1706. {
  1707. baseQuery = baseQuery
  1708. .Where(e => !context.Peoples.Any(f => f.Name == e.Name));
  1709. }
  1710. if (filter.Years.Length == 1)
  1711. {
  1712. baseQuery = baseQuery
  1713. .Where(e => e.ProductionYear == filter.Years[0]);
  1714. }
  1715. else if (filter.Years.Length > 1)
  1716. {
  1717. baseQuery = baseQuery
  1718. .Where(e => filter.Years.Any(f => f == e.ProductionYear));
  1719. }
  1720. var isVirtualItem = filter.IsVirtualItem ?? filter.IsMissing;
  1721. if (isVirtualItem.HasValue)
  1722. {
  1723. baseQuery = baseQuery
  1724. .Where(e => e.IsVirtualItem == isVirtualItem.Value);
  1725. }
  1726. if (filter.IsSpecialSeason.HasValue)
  1727. {
  1728. if (filter.IsSpecialSeason.Value)
  1729. {
  1730. baseQuery = baseQuery
  1731. .Where(e => e.IndexNumber == 0);
  1732. }
  1733. else
  1734. {
  1735. baseQuery = baseQuery
  1736. .Where(e => e.IndexNumber != 0);
  1737. }
  1738. }
  1739. if (filter.IsUnaired.HasValue)
  1740. {
  1741. if (filter.IsUnaired.Value)
  1742. {
  1743. baseQuery = baseQuery
  1744. .Where(e => e.PremiereDate >= now);
  1745. }
  1746. else
  1747. {
  1748. baseQuery = baseQuery
  1749. .Where(e => e.PremiereDate < now);
  1750. }
  1751. }
  1752. if (filter.MediaTypes.Length > 0)
  1753. {
  1754. var mediaTypes = filter.MediaTypes.Select(f => f.ToString()).ToArray();
  1755. baseQuery = baseQuery
  1756. .Where(e => mediaTypes.Contains(e.MediaType));
  1757. }
  1758. if (filter.ItemIds.Length > 0)
  1759. {
  1760. baseQuery = baseQuery
  1761. .Where(e => filter.ItemIds.Contains(e.Id));
  1762. }
  1763. if (filter.ExcludeItemIds.Length > 0)
  1764. {
  1765. baseQuery = baseQuery
  1766. .Where(e => !filter.ItemIds.Contains(e.Id));
  1767. }
  1768. if (filter.ExcludeProviderIds is not null && filter.ExcludeProviderIds.Count > 0)
  1769. {
  1770. baseQuery = baseQuery.Where(e => !e.Provider!.All(f => !filter.ExcludeProviderIds.All(w => f.ProviderId == w.Key && f.ProviderValue == w.Value)));
  1771. }
  1772. if (filter.HasAnyProviderId is not null && filter.HasAnyProviderId.Count > 0)
  1773. {
  1774. baseQuery = baseQuery.Where(e => e.Provider!.Any(f => !filter.HasAnyProviderId.Any(w => f.ProviderId == w.Key && f.ProviderValue == w.Value)));
  1775. }
  1776. if (filter.HasImdbId.HasValue)
  1777. {
  1778. baseQuery = baseQuery.Where(e => e.Provider!.Any(f => f.ProviderId == "imdb"));
  1779. }
  1780. if (filter.HasTmdbId.HasValue)
  1781. {
  1782. baseQuery = baseQuery.Where(e => e.Provider!.Any(f => f.ProviderId == "tmdb"));
  1783. }
  1784. if (filter.HasTvdbId.HasValue)
  1785. {
  1786. baseQuery = baseQuery.Where(e => e.Provider!.Any(f => f.ProviderId == "tvdb"));
  1787. }
  1788. var queryTopParentIds = filter.TopParentIds;
  1789. if (queryTopParentIds.Length > 0)
  1790. {
  1791. var includedItemByNameTypes = GetItemByNameTypesInQuery(filter);
  1792. var enableItemsByName = (filter.IncludeItemsByName ?? false) && includedItemByNameTypes.Count > 0;
  1793. if (enableItemsByName && includedItemByNameTypes.Count > 0)
  1794. {
  1795. baseQuery = baseQuery.Where(e => includedItemByNameTypes.Contains(e.Type) || queryTopParentIds.Any(w => w == e.TopParentId!.Value));
  1796. }
  1797. else
  1798. {
  1799. baseQuery = baseQuery.Where(e => queryTopParentIds.Contains(e.TopParentId!.Value));
  1800. }
  1801. }
  1802. if (filter.AncestorIds.Length > 0)
  1803. {
  1804. baseQuery = baseQuery.Where(e => e.Children!.Any(f => filter.AncestorIds.Contains(f.ParentItemId)));
  1805. }
  1806. if (!string.IsNullOrWhiteSpace(filter.AncestorWithPresentationUniqueKey))
  1807. {
  1808. baseQuery = baseQuery
  1809. .Where(e => context.BaseItems.Where(f => f.PresentationUniqueKey == filter.AncestorWithPresentationUniqueKey).Any(f => f.Children!.Any(w => w.ItemId == e.Id)));
  1810. }
  1811. if (!string.IsNullOrWhiteSpace(filter.SeriesPresentationUniqueKey))
  1812. {
  1813. baseQuery = baseQuery
  1814. .Where(e => e.SeriesPresentationUniqueKey == filter.SeriesPresentationUniqueKey);
  1815. }
  1816. if (filter.ExcludeInheritedTags.Length > 0)
  1817. {
  1818. baseQuery = baseQuery
  1819. .Where(e => !e.ItemValues!.Where(w => w.ItemValue.Type == ItemValueType.InheritedTags)
  1820. .Any(f => filter.ExcludeInheritedTags.Contains(f.ItemValue.CleanValue)));
  1821. }
  1822. if (filter.IncludeInheritedTags.Length > 0)
  1823. {
  1824. // Episodes do not store inherit tags from their parents in the database, and the tag may be still required by the client.
  1825. // In addition to the tags for the episodes themselves, we need to manually query its parent (the season)'s tags as well.
  1826. if (includeTypes.Length == 1 && includeTypes.FirstOrDefault() is BaseItemKind.Episode)
  1827. {
  1828. baseQuery = baseQuery
  1829. .Where(e => e.ItemValues!.Where(f => f.ItemValue.Type == ItemValueType.InheritedTags)
  1830. .Any(f => filter.IncludeInheritedTags.Contains(f.ItemValue.CleanValue))
  1831. ||
  1832. (e.ParentId.HasValue && context.ItemValuesMap.Where(w => w.ItemId == e.ParentId.Value)!.Where(w => w.ItemValue.Type == ItemValueType.InheritedTags)
  1833. .Any(f => filter.IncludeInheritedTags.Contains(f.ItemValue.CleanValue))));
  1834. }
  1835. // A playlist should be accessible to its owner regardless of allowed tags.
  1836. else if (includeTypes.Length == 1 && includeTypes.FirstOrDefault() is BaseItemKind.Playlist)
  1837. {
  1838. baseQuery = baseQuery
  1839. .Where(e =>
  1840. e.Parents!
  1841. .Any(f =>
  1842. f.ParentItem.ItemValues!.Any(w => w.ItemValue.Type == ItemValueType.Tags && filter.IncludeInheritedTags.Contains(w.ItemValue.CleanValue))
  1843. || e.Data!.Contains($"OwnerUserId\":\"{filter.User!.Id:N}\"")));
  1844. // d ^^ this is stupid it hate this.
  1845. }
  1846. else
  1847. {
  1848. baseQuery = baseQuery
  1849. .Where(e => e.Parents!.Any(f => f.ParentItem.ItemValues!.Any(w => w.ItemValue.Type == ItemValueType.Tags && filter.IncludeInheritedTags.Contains(w.ItemValue.CleanValue))));
  1850. }
  1851. }
  1852. if (filter.SeriesStatuses.Length > 0)
  1853. {
  1854. var seriesStatus = filter.SeriesStatuses.Select(e => e.ToString()).ToArray();
  1855. baseQuery = baseQuery
  1856. .Where(e => seriesStatus.Any(f => e.Data!.Contains(f)));
  1857. }
  1858. if (filter.BoxSetLibraryFolders.Length > 0)
  1859. {
  1860. var boxsetFolders = filter.BoxSetLibraryFolders.Select(e => e.ToString("N", CultureInfo.InvariantCulture)).ToArray();
  1861. baseQuery = baseQuery
  1862. .Where(e => boxsetFolders.Any(f => e.Data!.Contains(f)));
  1863. }
  1864. if (filter.VideoTypes.Length > 0)
  1865. {
  1866. var videoTypeBs = filter.VideoTypes.Select(e => $"\"VideoType\":\"{e}\"");
  1867. baseQuery = baseQuery
  1868. .Where(e => videoTypeBs.Any(f => e.Data!.Contains(f)));
  1869. }
  1870. if (filter.Is3D.HasValue)
  1871. {
  1872. if (filter.Is3D.Value)
  1873. {
  1874. baseQuery = baseQuery
  1875. .Where(e => e.Data!.Contains("Video3DFormat"));
  1876. }
  1877. else
  1878. {
  1879. baseQuery = baseQuery
  1880. .Where(e => !e.Data!.Contains("Video3DFormat"));
  1881. }
  1882. }
  1883. if (filter.IsPlaceHolder.HasValue)
  1884. {
  1885. if (filter.IsPlaceHolder.Value)
  1886. {
  1887. baseQuery = baseQuery
  1888. .Where(e => e.Data!.Contains("IsPlaceHolder\":true"));
  1889. }
  1890. else
  1891. {
  1892. baseQuery = baseQuery
  1893. .Where(e => !e.Data!.Contains("IsPlaceHolder\":true"));
  1894. }
  1895. }
  1896. if (filter.HasSpecialFeature.HasValue)
  1897. {
  1898. if (filter.HasSpecialFeature.Value)
  1899. {
  1900. baseQuery = baseQuery
  1901. .Where(e => e.ExtraIds != null);
  1902. }
  1903. else
  1904. {
  1905. baseQuery = baseQuery
  1906. .Where(e => e.ExtraIds == null);
  1907. }
  1908. }
  1909. if (filter.HasTrailer.HasValue || filter.HasThemeSong.HasValue || filter.HasThemeVideo.HasValue)
  1910. {
  1911. if (filter.HasTrailer.GetValueOrDefault() || filter.HasThemeSong.GetValueOrDefault() || filter.HasThemeVideo.GetValueOrDefault())
  1912. {
  1913. baseQuery = baseQuery
  1914. .Where(e => e.ExtraIds != null);
  1915. }
  1916. else
  1917. {
  1918. baseQuery = baseQuery
  1919. .Where(e => e.ExtraIds == null);
  1920. }
  1921. }
  1922. return baseQuery;
  1923. }
  1924. }