public static BoolFilter<ESDocument> CreateQueryForValue(ISearchCriteria criteria, ISearchFilter filter, ISearchFilterValue value)
{
var query = new BoolFilter<ESDocument>();
var field = filter.Key.ToLower();
if (filter.GetType() == typeof(PriceRangeFilter))
{
var tempQuery = CreatePriceRangeFilter(criteria, field, value as RangeFilterValue);
if (tempQuery != null)
{
query.Must(q => q.Bool(b => tempQuery));
}
}
else
{
if (value.GetType() == typeof(AttributeFilterValue))
{
query.Must(q => q.Term(t=>t.Field(field).Value(((AttributeFilterValue)value).Value)));
}
else if (value.GetType() == typeof(RangeFilterValue))
{
var tempValue = value as RangeFilterValue;
var tempFilter = new RangeFilter<ESDocument>();
tempFilter.Field(field).From(tempValue.Lower).To(tempValue.Upper).IncludeLower(true).IncludeUpper(false);
query.Should(q => q.Range(r => tempFilter));
}
}
return query;
}
private static BoolFilter<ESDocument> CreatePriceRangeFilter(string[] priceLists, int index, string field, string currency, string lowerbound, string upperbound, bool lowerboundincluded, bool upperboundincluded)
{
var query = new BoolFilter<ESDocument>();
// create left part
var filter = new RangeFilter<ESDocument>();
filter.Field(String.Format("{0}_{1}_{2}", field, currency, priceLists[index - 1].ToLower()))/*.From("*").To("*")*/.IncludeLower(lowerboundincluded).IncludeUpper(upperboundincluded);
//query.MustNot(q => q.ConstantScore(c => c.Filter(f => f.Range(r => filter))));
query.MustNot(q => q.Range(r => filter));
// create right part
if (index == priceLists.Count() - 1) // last element
{
var filter2 = new RangeFilter<ESDocument>();
filter2.Field(String.Format("{0}_{1}_{2}", field, currency, priceLists[index].ToLower())).From(lowerbound).To(upperbound).IncludeLower(lowerboundincluded).IncludeUpper(upperboundincluded);
//query.Must(q => q.ConstantScore(c => c.Filter(f => f.Range(r => filter2))));
query.Must(q => q.Range(r => filter2));
}
else
{
query.Should(q => q.Bool(b => CreatePriceRangeFilter(priceLists, index + 1, field, currency, lowerbound, upperbound, lowerboundincluded, upperboundincluded)));
}
return query;
}
/// <summary>
/// Creates the price range filter.
/// </summary>
/// <param name="criteria">The criteria.</param>
/// <param name="field">The field.</param>
/// <param name="value">The value.</param>
/// <returns></returns>
public static BoolFilter<ESDocument> CreatePriceRangeFilter(ISearchCriteria criteria, string field, RangeFilterValue value)
{
var query = new BoolFilter<ESDocument>();
var lowerbound = value.Lower;
var upperbound = value.Upper;
var lowerboundincluded = true;
var upperboundincluded = false;
var currency = criteria.Currency.ToLower();
// format is "fieldname_store_currency_pricelist"
string[] pls = null;
if (criteria is CatalogItemSearchCriteria)
{
pls = ((CatalogItemSearchCriteria)criteria).Pricelists;
}
var parentPriceList = String.Empty;
// Create filter of type
// price_USD_pricelist1:[100 TO 200} (-price_USD_pricelist1:[* TO *} +(price_USD_pricelist2:[100 TO 200} (-price_USD_pricelist2:[* TO *} (+price_USD_pricelist3[100 TO 200}))))
if (pls == null || pls.Count() == 0)
return null;
var priceListId = pls[0].ToLower();
var filter = new RangeFilter<ESDocument>();
filter.Field(String.Format("{0}_{1}_{2}", field, currency, priceListId)).From(lowerbound).To(upperbound).IncludeLower(lowerboundincluded).IncludeUpper(upperboundincluded);
//query.Should(q => q.ConstantScore(c => c.Filter(f => f.Range(r => filter))));
query.Should(q => q.Range(r => filter));
if (pls.Count() > 1)
{
var temp = CreatePriceRangeFilter(pls, 1, field, currency, lowerbound, upperbound, lowerboundincluded, upperboundincluded);
query.Should(q => q.Bool(b => temp));
}
//Query query = new ConstantScoreQuery(filter);
return query;
}
public object BuildQuery(ISearchCriteria criteria)
{
var query = new BoolQuery<ESDocument>();
#region Filters
if (criteria.CurrentFilterValues != null)
{
for (var index = 0; index < criteria.CurrentFilterFields.Length; index++)
{
var filter = criteria.CurrentFilters.ElementAt(index);
var value = criteria.CurrentFilterValues.ElementAt(index);
var field = criteria.CurrentFilterFields.ElementAt(index).ToLower();
// Skip currencies that are not part of the filter
if (filter.GetType() == typeof(PriceRangeFilter)) // special filtering
{
var priceRangeFilter = filter as PriceRangeFilter;
if (priceRangeFilter != null)
{
var currency = priceRangeFilter.Currency;
if (!currency.Equals(criteria.Currency, StringComparison.OrdinalIgnoreCase))
continue;
}
}
if (filter.GetType() == typeof(PriceRangeFilter))
{
var tempQuery = ElasticQueryHelper.CreatePriceRangeFilter(criteria, field, value as RangeFilterValue);
if (tempQuery != null)
{
query.Must(q => q.ConstantScore(c => c.Filter(f => f.Bool(b=>tempQuery))));
}
}
else
{
if (value.GetType() == typeof(AttributeFilterValue))
{
query.Must(q => q.Text(t => t.Field(field).Query(((AttributeFilterValue)value).Value)));
}
else if (value.GetType() == typeof(RangeFilterValue))
{
var tempValue = value as RangeFilterValue;
var tempFilter = new RangeFilter<ESDocument>();
tempFilter.Field(field).From(tempValue.Lower).To(tempValue.Upper).IncludeLower(true).IncludeUpper(false);
query.Should(q => q.ConstantScore(c => c.Filter(f => f.Range(r => tempFilter))));
}
}
}
}
#endregion
#region CatalogItemSearchCriteria
if (criteria is CatalogItemSearchCriteria)
{
var c = criteria as CatalogItemSearchCriteria;
query.Must(m => m
.Range(r => r.Field("startdate").To(c.StartDate.ToString("s")))
);
if (c.StartDateFrom.HasValue)
{
query.Must(m => m
.Range(r => r.Field("startdate").From(c.StartDateFrom.Value.ToString("s")))
);
}
if (c.EndDate.HasValue)
{
query.Must(m => m
.Range(r => r.Field("enddate").From(c.EndDate.Value.ToString("s")))
);
}
query.Must(m => m.Term(t => t.Field("__hidden").Value("false")));
if (c.Outlines != null && c.Outlines.Count > 0)
AddQuery("__outline", query, c.Outlines);
if (!String.IsNullOrEmpty(c.SearchPhrase))
{
AddQueryString("__content", query, c);
}
if (!String.IsNullOrEmpty(c.Catalog))
{
AddQuery("catalog", query, c.Catalog);
}
}
#endregion
if (criteria is ElasticSearchCriteria)
{
var c = criteria as ElasticSearchCriteria;
query.Must(m => m.Custom(c.RawQuery));
}
return query;
}