public virtual List <ItemSearchPropertyInfo> GetPropertiesForSearch(string itemType) { List <ItemSearchPropertyInfo> notSortedList = new List <ItemSearchPropertyInfo>(); List <dynamic> properties = Utils.GetItemTypeProperties(innovatorInstance, itemType); foreach (dynamic property in properties) { //TODO: check this if statesment if (string.Equals("1", property.getProperty("is_hidden")) && !string.Equals("locked_by_id", property.getProperty("name"))) { continue; } var dataType = PropertyDataTypeParser.ParseDataType(property.getProperty("data_type")); ItemSearchPropertyInfo propertyInfo; if (dataType == PropertyDataType.List) { var pinfo = new ListPropertyInfo(); var affectedItem = property.node.GetXmlNodePropertyAttribute("data_source", "keyed_name"); pinfo.ItemsSource = new List <string>() { string.Empty }; //TODO: should show lable not a value List <dynamic> listValueItems = Utilities.Utils.GetValueListByName(innovatorInstance, affectedItem); List <string> listValues = listValueItems.Select(x => x.getProperty("value") as string).ToList(); pinfo.ItemsSource.AddRange(listValues); propertyInfo = pinfo; } else if (dataType == PropertyDataType.ColorList) { var pinfo = new ColorListPropertyInfo(); var affectedItem = property.node.GetXmlNodePropertyAttribute("data_source", "keyed_name"); List <dynamic> items = Utilities.Utils.GetValueListByName(innovatorInstance, affectedItem); var colors = new Dictionary <string, string>() { { string.Empty, string.Empty } }; string value; string label; foreach (dynamic item in items) { value = item.getProperty("value", string.Empty); label = item.getProperty("label", value); if (!colors.ContainsKey(value)) { colors.Add(value, label); } } pinfo.ColorSource = colors; propertyInfo = pinfo; } else { propertyInfo = new ItemSearchPropertyInfo(); } propertyInfo.PropertyName = property.getProperty("name"); propertyInfo.Label = property.getProperty("label"); if (string.IsNullOrEmpty(propertyInfo.Label)) { propertyInfo.Label = property.getProperty("keyed_name"); } propertyInfo.DataType = dataType; propertyInfo.Id = property.getID(); propertyInfo.Pattern = property.getProperty("pattern"); string widthString; if (propertyInfo.PropertyName == "locked_by_id") { widthString = property.getProperty("column_width", "24"); } else { widthString = property.getProperty("column_width", "100"); } propertyInfo.Width = int.Parse(widthString); propertyInfo.DataSource = property.getProperty("data_source"); propertyInfo.Alignment = property.getProperty("column_alignment"); notSortedList.Add(propertyInfo); } notSortedList.Add(new ItemSearchPropertyInfo() { PropertyName = "id", IsHidden = true }); UpdatePropertiesForSearch(notSortedList); List <ItemSearchPropertyInfo> resultList = new List <ItemSearchPropertyInfo>(); var layout = preferencesProvider.GetItemGridLayout(itemType); if (layout != null) { for (int i = 0; i < layout.ColumnOrderList.Count; i++) { var foundedProperty = notSortedList.FirstOrDefault(p => p.PropertyName == layout.ColumnOrderList[i]); if (foundedProperty != null) { int width; if (int.TryParse(layout.ColumnWidthsList[i], out width)) { foundedProperty.Width = width; } resultList.Add(foundedProperty); } } } //Add properties which is not in layoutsettings foreach (var item in notSortedList) { if (!resultList.Contains(item)) { if (item.PropertyName == "locked_by_id") { resultList.Insert(0, item); } else { resultList.Add(item); } } } return(resultList); }
public List <ItemSearchResult> RunSearch(string itemType, SavedSearch search) { var itemForSearch = innovatorInstance.newItem(itemType, "get"); foreach (var prop in search.SavedSearchProperties) { if (!string.IsNullOrEmpty(prop.PropertyValue) && !string.Equals(prop.PropertyValue, "Indeterminate")) { if (prop.DataType == PropertyDataType.Item) { itemForSearch.setProperty(prop.PropertyName, CreateItemSearchProperty(prop.DataSource, prop.PropertyValue)); } else if (prop.DataType == PropertyDataType.Date) { DateTime date; if (DateTime.TryParse(prop.PropertyValue, out date)) { string value = date.ToString("yyyy-MM-dd"); itemForSearch.setProperty(prop.PropertyName, $"{value}T00:00:00 and {value}T23:59:59"); itemForSearch.setPropertyAttribute(prop.PropertyName, "condition", "between"); } } else { itemForSearch.setProperty(prop.PropertyName, prop.PropertyValue); if (prop.PropertyValue.Contains("*") || prop.PropertyValue.Contains("%")) { itemForSearch.setPropertyAttribute(prop.PropertyName, "condition", "like"); } } } } itemForSearch.setAttribute("page", search.Page.ToString()); if (!string.IsNullOrEmpty(search.PageSize)) { itemForSearch.setAttribute("pagesize", search.PageSize.ToString()); } var codes = new Dictionary <string, string>() { { ">", ">" }, { "<", "<" }, }; string parsedString = itemForSearch.ToString(); parsedString = codes.Aggregate(parsedString, (current, code) => current.Replace(code.Key, code.Value)); itemForSearch.loadAML(parsedString); UpdateSearch(itemForSearch, itemType, search.SavedSearchProperties); itemForSearch = itemForSearch.apply(); //itemForSearch.IsErrorItem(true); List <dynamic> itemForSearchList = new List <dynamic>(); var itemsCount = itemForSearch.getItemCount(); for (int i = 0; i < itemsCount; i++) { var currentItem = itemForSearch.getItemByIndex(i); itemForSearchList.Add(currentItem); } UpdateFoundedItems(itemForSearchList); var resultSearchList = new List <ItemSearchResult>(); for (int i = 0; i < itemForSearchList.Count; i++) { var currentItem = itemForSearchList[i]; ItemSearchResult searchResult = new ItemSearchResult(); foreach (var item in search.SavedSearchProperties) { var value = currentItem.getProperty(item.PropertyName); ItemSearchPropertyInfo foundedPropertyInfo; if (item.PropertyName == "locked_by_id") { var lockedPropertyInfo = new LockedByPropertyInfo(); lockedPropertyInfo.IsLocked = !string.IsNullOrEmpty(value); lockedPropertyInfo.IsLockedByMe = string.Equals(value, innovatorInstance.getUserID()); lockedPropertyInfo.PropertyName = item.PropertyName; foundedPropertyInfo = lockedPropertyInfo; } else if (item.DataType == PropertyDataType.ColorList) { var colorProp = item as ColorListPropertyInfo; foundedPropertyInfo = new ColorListPropertyInfo() { PropertyName = item.PropertyName, PropertyValue = value, DataType = item.DataType, ColorSource = colorProp.ColorSource }; } else if (item.DataType == PropertyDataType.Item) { var label = currentItem.getPropertyAttribute(item.PropertyName, "keyed_name", string.Empty); foundedPropertyInfo = new ItemSearchPropertyInfo() { PropertyName = item.PropertyName, PropertyValue = value, Label = label, DataType = item.DataType }; } else { foundedPropertyInfo = new ItemSearchPropertyInfo() { PropertyName = item.PropertyName, PropertyValue = value, DataType = item.DataType }; } searchResult.FoundedItems.Add(foundedPropertyInfo); } resultSearchList.Add(searchResult); } if (resultSearchList.Count > 0) { var firstItem = itemForSearch.getItemByIndex(0); var page = firstItem.getAttribute("page", "1"); var pageMax = firstItem.getAttribute("pagemax", "1"); int value; search.Page = int.TryParse(page, out value) ? value : 1; search.PageMax = int.TryParse(pageMax, out value) ? value : 1; } else { search.Page = 1; search.PageMax = 1; } return(resultSearchList); }