protected void LazyLoadHandlers(LocalizationPart localizationPart) { localizationPart.CultureField.Loader(() => _cultureManager.GetCultureById(localizationPart.Record.CultureId)); localizationPart.MasterContentItemField.Loader(() => _contentManager.Get(localizationPart.Record.MasterContentItemId, VersionOptions.AllVersions)); }
protected void LazyLoadHandlers(LocalizationPart localizationPart) { localizationPart.CultureField.Loader(ctx => _cultureManager.GetCultureById(localizationPart.Record.CultureId)); localizationPart.MasterContentItemField.Loader(ctx => _contentManager.Get(localizationPart.Record.MasterContentItemId, localizationPart.IsPublished() ? VersionOptions.Published : VersionOptions.Latest)); }
protected override void Exporting(FavoriteCulturePart part, ExportContentContext context) { var root = context.Element(part.PartDefinition.Name); if (part.Culture_Id > 0) { var culture = _cultureManager.GetCultureById(part.Culture_Id); if (culture != null) { root.SetAttributeValue("Culture_Id", culture.Culture); } } }
public Orchard.Localization.Records.CultureRecord GetCultureById(int id) { return(_underlyingCultureManager.GetCultureById(id)); }
public ActionResult List(ListContentsViewModelExtension model, PagerParameters pagerParameters) { Pager pager = new Pager(_siteService.GetSiteSettings(), pagerParameters); var versionOptions = VersionOptions.Latest; switch (model.Options.ContentsStatus) { case ContentsStatus.Published: versionOptions = VersionOptions.Published; break; case ContentsStatus.Draft: versionOptions = VersionOptions.Draft; break; case ContentsStatus.AllVersions: versionOptions = VersionOptions.AllVersions; break; default: versionOptions = VersionOptions.Latest; break; } var query = _contentManager.Query(versionOptions, GetListableTypes(false).Select(ctd => ctd.Name).ToArray()); //the lQuery is used only in the case where we have the language queries, but since we cannot clone IContentQuery objects, //we create it here and build is as we build the other var lQuery = _contentManager.Query(versionOptions, GetListableTypes(false).Select(ctd => ctd.Name).ToArray()); if (!string.IsNullOrEmpty(model.TypeName)) { var contentTypeDefinition = _contentDefinitionManager.GetTypeDefinition(model.TypeName); if (contentTypeDefinition == null) { return(HttpNotFound()); } model.TypeDisplayName = !string.IsNullOrWhiteSpace(contentTypeDefinition.DisplayName) ? contentTypeDefinition.DisplayName : contentTypeDefinition.Name; query = query.ForType(model.TypeName); lQuery = lQuery.ForType(model.TypeName); } // FILTER QUERIES: START // // terms query if (model.AdvancedOptions.SelectedTermId > 0) { var termId = model.AdvancedOptions.SelectedTermId; query = query.Join <TermsPartRecord>().Where(x => x.Terms.Any(a => a.TermRecord.Id == termId)); lQuery = lQuery.Join <TermsPartRecord>().Where(x => x.Terms.Any(a => a.TermRecord.Id == termId)); } // owner query if ( //user cannot see everything by default ( !Services.Authorizer.Authorize(AdvancedSearchPermissions.SeesAllContent) || (Services.Authorizer.Authorize(AdvancedSearchPermissions.SeesAllContent) && model.AdvancedOptions.OwnedByMeSeeAll) ) && ( //user has either limitation ((Services.Authorizer.Authorize(AdvancedSearchPermissions.MayChooseToSeeOthersContent)) && (model.AdvancedOptions.OwnedByMe)) || (Services.Authorizer.Authorize(AdvancedSearchPermissions.CanSeeOwnContents) && !Services.Authorizer.Authorize(AdvancedSearchPermissions.MayChooseToSeeOthersContent)) ) ) { //this user can only see the contents they own var lowerName = Services.WorkContext.CurrentUser.UserName.ToLowerInvariant(); var email = Services.WorkContext.CurrentUser.Email; var user = _contentManager.Query <UserPart, UserPartRecord>().Where(u => u.NormalizedUserName == lowerName || u.Email == email).List().FirstOrDefault(); query = query.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id); lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id); } else if (!String.IsNullOrWhiteSpace(model.AdvancedOptions.SelectedOwner)) { var lowerName = model.AdvancedOptions.SelectedOwner == null ? "" : model.AdvancedOptions.SelectedOwner.ToLowerInvariant(); var email = model.AdvancedOptions.SelectedOwner; var user = _contentManager.Query <UserPart, UserPartRecord>().Where(u => u.NormalizedUserName == lowerName || u.Email == email).List().FirstOrDefault(); if (user != null) { query = query.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id); lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id); } else { _notifier.Add(NotifyType.Warning, T("No user found. Ownership filter not applied.")); } } //date query if (model.AdvancedOptions.SelectedFromDate != null || model.AdvancedOptions.SelectedToDate != null) { //set default dates for From and To if they are null. var fromD = _dataLocalization.StringToDatetime(model.AdvancedOptions.SelectedFromDate, "") ?? _dataLocalization.StringToDatetime("09/05/1985", ""); var toD = _dataLocalization.StringToDatetime(model.AdvancedOptions.SelectedToDate, "") ?? DateTime.Now; if (model.AdvancedOptions.DateFilterType == DateFilterOptions.Created) { query = query.Join <CommonPartRecord>().Where(x => x.CreatedUtc >= fromD && x.CreatedUtc <= toD); lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.CreatedUtc >= fromD && x.CreatedUtc <= toD); } else if (model.AdvancedOptions.DateFilterType == DateFilterOptions.Modified) { query = query.Join <CommonPartRecord>().Where(x => x.ModifiedUtc >= fromD && x.ModifiedUtc <= toD); lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.ModifiedUtc >= fromD && x.ModifiedUtc <= toD); } else if (model.AdvancedOptions.DateFilterType == DateFilterOptions.Published) { query = query.Join <CommonPartRecord>().Where(x => x.PublishedUtc >= fromD && x.PublishedUtc <= toD); lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.PublishedUtc >= fromD && x.PublishedUtc <= toD); } } // Has media query if (model.AdvancedOptions.HasMedia) { var allCt = GetListableTypes(false); var listFields = new List <string>(); foreach (var ct in allCt) { var allMediaFld = _contentDefinitionService.GetType(ct.Name).Fields.Where(w => w._Definition.FieldDefinition.Name == "MediaLibraryPickerField"); var allFieldNames = allMediaFld.Select(s => ct.Name + "." + s.Name + "."); listFields.AddRange(allFieldNames); } query = query.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any( w2 => listFields.Contains(w2.PropertyName) && w2.Value != "" )); lQuery = lQuery.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any( w2 => listFields.Contains(w2.PropertyName) && w2.Value != "" )); } // Extended Status query if (!String.IsNullOrWhiteSpace(model.AdvancedOptions.SelectedStatus)) { query = query.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any( w2 => w2.PropertyName == "PublishExtensionPart.PublishExtensionStatus." && w2.Value == model.AdvancedOptions.SelectedStatus )); lQuery = lQuery.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any( w2 => w2.PropertyName == "PublishExtensionPart.PublishExtensionStatus." && w2.Value == model.AdvancedOptions.SelectedStatus )); } // FILTER QUERIES: END // switch (model.Options.OrderBy) { case ContentsOrder.Modified: //query = query.OrderByDescending<ContentPartRecord, int>(ci => ci.ContentItemRecord.Versions.Single(civr => civr.Latest).Id); query = query.OrderByDescending <CommonPartRecord>(cr => cr.ModifiedUtc); lQuery = lQuery.OrderByDescending <CommonPartRecord>(cr => cr.ModifiedUtc); break; case ContentsOrder.Published: query = query.OrderByDescending <CommonPartRecord>(cr => cr.PublishedUtc); lQuery = lQuery.OrderByDescending <CommonPartRecord>(cr => cr.PublishedUtc); break; case ContentsOrder.Created: //query = query.OrderByDescending<ContentPartRecord, int>(ci => ci.Id); query = query.OrderByDescending <CommonPartRecord>(cr => cr.CreatedUtc); lQuery = lQuery.OrderByDescending <CommonPartRecord>(cr => cr.CreatedUtc); break; } model.Options.SelectedFilter = model.TypeName; model.Options.FilterOptions = GetListableTypes(false) .Select(ctd => new KeyValuePair <string, string>(ctd.Name, ctd.DisplayName)) .ToList().OrderBy(kvp => kvp.Value); // FILTER MODELS: START // // language filter model model.AdvancedOptions.LanguageOptions = _commonService.ListCultures().Select(x => new KeyValuePair <int, string>(x.Id, x.Culture)); // taxonomy filter model var termList = new List <KeyValuePair <int, string> >(); foreach (var taxonomy in _taxonomyService.GetTaxonomies()) { termList.Add(new KeyValuePair <int, string>(-1, taxonomy.Name)); foreach (var term in _taxonomyService.GetTerms(taxonomy.Id)) { var gap = new string('-', term.GetLevels()); if (gap.Length > 0) { gap += " "; } termList.Add(new KeyValuePair <int, string>(term.Id, gap + term.Name)); } } model.AdvancedOptions.TaxonomiesOptions = termList; // extended status var partDefinition = _contentDefinitionService.GetPart("PublishExtensionPart"); if (partDefinition != null) { var partField = partDefinition.Fields.Where(w => w.Name == "PublishExtensionStatus").SingleOrDefault(); var settings = partField.Settings.GetModel <EnumerationFieldSettings>().Options; string[] options = (!String.IsNullOrWhiteSpace(settings)) ? settings.Split(new string[] { System.Environment.NewLine }, StringSplitOptions.None) : null; model.AdvancedOptions.StatusOptions = options.Select(s => new KeyValuePair <string, string>(s, T(s).Text)); } #region TEST OF CPF QUERIES //if (model.AdvancedOptions.CPFOwnerId != null) { // var item = _contentManager.Get((int)model.AdvancedOptions.CPFOwnerId); // var parts = item.Parts; // list = Shape.List(); // foreach (var part in parts) { // foreach (var field in part.Fields) { // if (field.FieldDefinition.Name == "ContentPickerField") { // bool noName = String.IsNullOrWhiteSpace(model.AdvancedOptions.CPFName); // if (noName || (!noName && field.Name == model.AdvancedOptions.CPFName)) { // var relatedItems = _contentManager.GetMany<ContentItem>((IEnumerable<int>)field.GetType().GetProperty("Ids").GetValue(field), VersionOptions.Latest, QueryHints.Empty); // list.AddRange(relatedItems.Select(ci => _contentManager.BuildDisplay(ci, "SummaryAdmin"))); // } // } // } // } //} if (model.AdvancedOptions.CPFIdToSearch != null && !String.IsNullOrWhiteSpace(model.AdvancedOptions.CPFName)) { //given an Id, search for all items that have a Content Picker Field whose PropertyName is PCFName and that have the //Id among the corresponding values. string fieldName = (string)model.AdvancedOptions.CPFName; query = query.Join <FieldIndexPartRecord>() .Where(fip => fip.StringFieldIndexRecords .Any(sfi => sfi.PropertyName.Contains(fieldName) && sfi.LatestValue.Contains("{" + model.AdvancedOptions.CPFIdToSearch.ToString() + "}") ) ); lQuery = lQuery.Join <FieldIndexPartRecord>() .Where(fip => fip.StringFieldIndexRecords .Any(sfi => sfi.PropertyName.Contains(fieldName) && sfi.LatestValue.Contains("{" + model.AdvancedOptions.CPFIdToSearch.ToString() + "}") ) ); } #endregion // FILTER MODELS: END // //EXECUTE QUERIES var pagerShape = Shape.Pager(pager).TotalItemCount(0); var list = Shape.List(); IEnumerable <ContentItem> pageOfContentItems = (IEnumerable <ContentItem>)null; //Stopwatch sw = Stopwatch.StartNew(); //the user may not have permission to see anything: in that case, do not execute the query #region original query //this is roughly 1000 slower than the variant below //if (Services.Authorizer.Authorize(AdvancedSearchPermissions.CanSeeOwnContents)) { // // language query // //For any language query, remember that Orchard's localization table, as of Orchard 1.8, has an issue where the content // //created but never translated does not have the default Culture assigned to it. // Expression<Func<LocalizationPartRecord, bool>> selLangPredicate = null; // if (model.AdvancedOptions.SelectedLanguageId > 0) { // bool siteCultureSelected = _cultureManager.GetSiteCulture() == _cultureManager.GetCultureById(model.AdvancedOptions.SelectedLanguageId).Culture; // if (siteCultureSelected) { // selLangPredicate = // x => x.CultureId == model.AdvancedOptions.SelectedLanguageId || // x.CultureId == 0; // } else { // selLangPredicate = // x => x.CultureId == model.AdvancedOptions.SelectedLanguageId; // } // } // if (model.AdvancedOptions.SelectedLanguageId > 0) { // query = query.Join<LocalizationPartRecord>().Where(selLangPredicate); // } // //if we want only items that do not have a specific translation, we have to do things differently, // //because the check is done after the query. Hence, for example, we cannot directly page. // if (model.AdvancedOptions.SelectedUntranslatedLanguageId > 0) { // var allCi = query.List(); // //for (int i = 0; i < allCi.Count(); i++) { //this loop is used to test null conditions and other stuff like that while debugging // // var ci = allCi.ElementAt(i); // // if (ci.Is<LocalizationPart>()) { // // var lci = _localizationService.GetLocalizations(ci, versionOptions); // // var clci = lci.Count(); // // var bo = lci.Any(li => li.Culture.Id == model.AdvancedOptions.SelectedUntranslatedLanguageId); // // } // //} // var untranslatedCi = allCi // .Where(x => // x.Is<LocalizationPart>() && //the content is translatable // ( // x.As<LocalizationPart>().Culture == null || //this is the case where the content was created and never translated to any other culture. // x.As<LocalizationPart>().Culture.Id != model.AdvancedOptions.SelectedUntranslatedLanguageId //not a content in the language in which we are looking translations // ) && // _localizationService.GetLocalizations(x, versionOptions) != null && // !_localizationService.GetLocalizations(x, versionOptions).Any(li => // li.Culture != null && // li.Culture.Id == model.AdvancedOptions.SelectedUntranslatedLanguageId // ) // ); // //.Where(x => // // x.Is<LocalizationPart>() && //some content items may not be translatable // // ( // // (x.As<LocalizationPart>().Culture != null && x.As<LocalizationPart>().Culture.Id != model.AdvancedOptions.SelectedUntranslatedLanguageId) || // // (x.As<LocalizationPart>().Culture == null) //this is the case where the content was created and never translated to any other culture. // // //In that case, in Orchard 1.8, no culture is directly assigned to it, even though the default culture is assumed. // // ) && // // x.As<LocalizationPart>().MasterContentItem == null && // // !allCi.Any(y => // // y.Is<LocalizationPart>() && // // (y.As<LocalizationPart>().MasterContentItem == x || y.As<LocalizationPart>().MasterContentItem == x.As<LocalizationPart>().MasterContentItem) && // // y.As<LocalizationPart>().Culture.Id == model.AdvancedOptions.SelectedUntranslatedLanguageId // // ) // //); // //Paging // pagerShape = Shape.Pager(pager).TotalItemCount(untranslatedCi.Count()); // int pSize = pager.PageSize != 0 ? pager.PageSize : untranslatedCi.Count(); // pageOfContentItems = untranslatedCi // .Skip(pager.GetStartIndex()) // .Take((pager.GetStartIndex() + pSize) > untranslatedCi.Count() ? // untranslatedCi.Count() - pager.GetStartIndex() : // pSize) // .ToList(); // } else { // pagerShape = Shape.Pager(pager).TotalItemCount(query.Count()); // pageOfContentItems = query.Slice(pager.GetStartIndex(), pager.PageSize).ToList(); // } //} else { // Services.Notifier.Error(T("Not authorized to visualize any item.")); //} #endregion if (Services.Authorizer.Authorize(AdvancedSearchPermissions.CanSeeOwnContents)) { // language queries //For any language query, remember that Orchard's localization table, as of Orchard 1.8, has an issue where the content //created but never translated does not have the default Culture assigned to it. Expression <Func <LocalizationPartRecord, bool> > selLangPredicate = null; if (model.AdvancedOptions.SelectedLanguageId > 0) { bool siteCultureSelected = _cultureManager.GetSiteCulture() == _cultureManager.GetCultureById(model.AdvancedOptions.SelectedLanguageId).Culture; if (siteCultureSelected) { selLangPredicate = x => x.CultureId == model.AdvancedOptions.SelectedLanguageId || x.CultureId == 0; } else { selLangPredicate = x => x.CultureId == model.AdvancedOptions.SelectedLanguageId; } query = query.Join <LocalizationPartRecord>().Where(selLangPredicate); } Expression <Func <LocalizationPartRecord, bool> > untranLangPredicate = null; if (model.AdvancedOptions.SelectedUntranslatedLanguageId > 0) { bool siteCultureSelected = _cultureManager.GetSiteCulture() == _cultureManager.GetCultureById(model.AdvancedOptions.SelectedUntranslatedLanguageId).Culture; if (siteCultureSelected) { untranLangPredicate = x => x.CultureId == model.AdvancedOptions.SelectedUntranslatedLanguageId || x.CultureId == 0; } else { untranLangPredicate = x => x.CultureId == model.AdvancedOptions.SelectedUntranslatedLanguageId; } lQuery = lQuery.Join <LocalizationPartRecord>().Where(untranLangPredicate); var lRes = lQuery.List(); var masters = lRes.Where(x => x.As <LocalizationPart>().Record.MasterContentItemId != 0).Select(x => x.As <LocalizationPart>().Record.MasterContentItemId).ToList(); var items = lRes.Select(x => x.Id).ToList(); Expression <Func <LocalizationPartRecord, bool> > sulPredicate = x => x.CultureId != model.AdvancedOptions.SelectedUntranslatedLanguageId && !masters.Contains(x.Id) && !masters.Contains(x.MasterContentItemId) && !items.Contains(x.MasterContentItemId); query = query.Join <LocalizationPartRecord>().Where(sulPredicate); } pagerShape = Shape.Pager(pager).TotalItemCount(query.Count()); pageOfContentItems = query.Slice(pager.GetStartIndex(), pager.PageSize).ToList(); } else { Services.Notifier.Error(T("Not authorized to visualize any item.")); } //sw.Stop(); //Services.Notifier.Error(new LocalizedString(sw.Elapsed.TotalMilliseconds.ToString())); if (pageOfContentItems != null) { list.AddRange(pageOfContentItems.Select(ci => _contentManager.BuildDisplay(ci, "SummaryAdmin"))); } var viewModel = Shape.ViewModel() .ContentItems(list) .Pager(pagerShape) .Options(model.Options) .AdvancedOptions(model.AdvancedOptions) .TypeDisplayName(model.TypeDisplayName ?? ""); return(View(viewModel)); }