public SearchRequestDto LocationFilterByStatusFunction(AssociationPreFilterFunctionParameters parameters) { var filter = parameters.BASEDto; filter.WhereClause = "Status NOT IN ('DECOMMISSIONED') AND TYPE='OPERATING'"; return(filter); }
public SearchRequestDto FilterAssets(AssociationPreFilterFunctionParameters parameters) { var filter = parameters.BASEDto; // Default filter to be applied to all Schemas filter.AppendSearchEntry("status", AssetConstants.Active, AssetConstants.Operating); filter.IgnoreWhereClause = true; // Add another filters depending on Schema var attributeHolder = parameters.OriginalEntity; var schemaId = parameters.Metadata.Schema.SchemaId; if ("printer".Equals(schemaId)) { filter.AppendSearchEntry(ISMConstants.PluspCustomerColumn, (string)attributeHolder.GetAttribute("printerpluspcustomer")); filter.AppendWhereClause(AssetConstants.BuildPrinterWhereClause()); } else if ("phone".Equals(schemaId)) { filter.AppendSearchEntry(ISMConstants.PluspCustomerColumn, (string)attributeHolder.GetAttribute("phonepluspcustomer")); filter.AppendSearchEntry(AssetConstants.ClassStructureIdColumn, AssetConstants.PhoneClassStructure); } else { var module = ContextLookuper.LookupContext().Module; if (module == null || !module.EqualsAny(FunctionalRole.AssetControl.GetName(), FunctionalRole.AssetRamControl.GetName())) { //if asset control, or asset ram control could be creating sr out of asset and this would make no sense filter.AppendSearchEntry(AssetConstants.CustodianColumn, SecurityFacade.CurrentUser(false).MaximoPersonId); } } return(filter); }
public SearchRequestDto FilterComponent(AssociationPreFilterFunctionParameters parameters) { var searchDTO = parameters.BASEDto; var system = parameters.OriginalEntity.GetAttribute("system") as String; searchDTO.AppendSearchEntry("description", system + "%"); return(searchDTO); }
public SearchRequestDto FilterAffectedPerson(AssociationPreFilterFunctionParameters parameters) { var filter = parameters.BASEDto; //var w = "STATUS = 'ACTIVE' AND PLUSPCUSTVENDOR ='DE017430' AND LocationOrg = 'HLAG-00'"; filter.WhereClause = "STATUS = 'ACTIVE'"; return(filter); }
public SearchRequestDto FilterAssetSpec(AssociationPreFilterFunctionParameters parameters) { var searchDTO = parameters.BASEDto; var asset = parameters.OriginalEntity.GetAttribute("asset"); searchDTO.AppendSearchEntry("assetnum", asset.ToString()); return(searchDTO); }
public SearchRequestDto AssetFilterBySiteFunction(AssociationPreFilterFunctionParameters parameters) { var filter = parameters.BASEDto; if (parameters.Metadata.Schema.SchemaId.Equals("printer") || parameters.Metadata.Schema.SchemaId.Equals("phone")) { filter.WhereClause = String.Format("LOCATION = '{0}'", parameters.OriginalEntity.Attributes["location"]); } return(filter); }
public SearchRequestDto FilterMovedAsset(AssociationPreFilterFunctionParameters parameters) { var searchDTO = FilterAssetByHlagLocation(parameters); searchDTO.Context = new ApplicationLookupContext { MetadataId = "movedassets" }; searchDTO.IgnoreWhereClause = false; return(searchDTO); }
public IEnumerable <IAssociationOption> ResolveOptions(ApplicationMetadata applicationMetadata, AttributeHolder originalEntity, ApplicationAssociationDefinition association, SearchRequestDto associationFilter) { if (!FullSatisfied(association, originalEntity)) { return(null); } // Set dependante lookup atributes var lookupAttributes = association.LookupAttributes(); foreach (var lookupAttribute in lookupAttributes) { var searchValue = SearchUtils.GetSearchValue(lookupAttribute, originalEntity); if (!String.IsNullOrEmpty(searchValue)) { associationFilter.AppendSearchParam(lookupAttribute.To); associationFilter.AppendSearchValue(searchValue); } else if (lookupAttribute.Query != null) { associationFilter.AppendWhereClause(lookupAttribute.GetQueryReplacingMarkers(association.EntityAssociation.To)); } } // Set projections and pre filter functions var numberOfLabels = BuildProjections(associationFilter, association); var prefilterFunctionName = association.Schema.DataProvider.PreFilterFunctionName; if (prefilterFunctionName != null) { var preFilterParam = new AssociationPreFilterFunctionParameters(applicationMetadata, associationFilter, association, originalEntity); associationFilter = PrefilterInvoker.ApplyPreFilterFunction(DataSetProvider.GetInstance().LookupDataSet(applicationMetadata.Name), preFilterParam, prefilterFunctionName); } var entityMetadata = MetadataProvider.Entity(association.EntityAssociation.To); associationFilter.QueryAlias = association.AssociationKey; var queryResponse = EntityRepository.Get(entityMetadata, associationFilter); if (associationFilter is PaginatedSearchRequestDto) { var paginatedFilter = (PaginatedSearchRequestDto)associationFilter; if (paginatedFilter.NeedsCountUpdate) { paginatedFilter.TotalCount = EntityRepository.Count(entityMetadata, associationFilter); } } var options = BuildOptions(queryResponse, association, numberOfLabels); string filterFunctionName = association.Schema.DataProvider.PostFilterFunctionName; return(filterFunctionName != null?ApplyFilters(applicationMetadata.Name, originalEntity, filterFunctionName, options, association) : options); }
public SearchRequestDto AssetFilterBySiteFunction(AssociationPreFilterFunctionParameters parameters) { var filter = parameters.BASEDto; var location = (string)parameters.OriginalEntity.GetAttribute("location"); if (location == null) { return(filter); } filter.AppendSearchEntry("asset.location", location.ToUpper()); return(filter); }
public SearchRequestDto FilterAssetByHlagLocationAndParentAsset(AssociationPreFilterFunctionParameters parameters) { var searchDTO = FilterAssetByHlagLocation(parameters); var schema = parameters.Metadata.Schema.SchemaId; if (schema.StartsWithAny(ImacConstants.Replace, ImacConstants.Remove, ImacConstants.Move)) { //replace new child asset uses FilterAssetByHlagLocation as the pre filter function, so it wont hit here //add extra parent asset filter -->note that install wont use it var asset = parameters.OriginalEntity.GetAttribute("asset"); searchDTO.AppendSearchEntry("parent", asset.ToString()); } return(searchDTO); }
public SearchRequestDto FilterAssetByHlagLocation(AssociationPreFilterFunctionParameters parameters) { var searchDTO = parameters.BASEDto; var fromLocation = parameters.OriginalEntity.GetAttribute("fromlocation") as String; var schema = parameters.Metadata.Schema.SchemaId; var target = parameters.Relationship.Target; var childAsset = parameters.Relationship.Target.Contains("child"); var isNew = target.Contains("new"); AppendLocationCondition(searchDTO, fromLocation, schema, childAsset, isNew, parameters.Metadata); searchDTO.AppendSearchEntry("status", ImacAssetHelper.GetImacStatusToSearch(schema, childAsset, isNew)); searchDTO.AppendWhereClause(AppendClassificationCondition(schema, childAsset)); return(searchDTO); }
public SearchRequestDto FilterAssets(AssociationPreFilterFunctionParameters parameters) { return(AssetFilterBySiteFunction(parameters)); }
public SearchRequestDto CheckPlannedTools(AssociationPreFilterFunctionParameters parameters) { var filter = parameters.BASEDto; return(filter); }
public SearchRequestDto PreFilterFunction(AssociationPreFilterFunctionParameters parameters) { return(parameters.BASEDto); }
public SearchRequestDto FilterAssetsByItcLocation(AssociationPreFilterFunctionParameters parameters) { var fromLocation = parameters.OriginalEntity.GetAttribute("itcassetlocation") as String; return(AssetByLocationCondition(parameters.BASEDto, fromLocation, parameters.Metadata)); }