protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.SpanTerm(c => c
.Name("named_query")
.Boost(1.1)
.Field("user")
.Value("kimchy")
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Filtered(c => c
.Name("named_query")
.Boost(1.1)
.Filter(qq => qq.MatchAll(m => m.Name("filter")))
.Query(qq => qq.MatchAll(m => m.Name("query")))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Terms(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.Terms(new List<string> { "term1", "term2" })
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Template(sn => sn
.Name("named_query")
.Boost(1.1)
.Inline(_templateString)
.Params(p=>p.Add("query_string", "all about search"))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Terms(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.TermsLookup<Developer>(e=>e.Path(p=>p.LastName).Id(12))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.GeoShapeLineString(c => c
.Name("named_query")
.Boost(1.1)
.Field(p=>p.Location)
.Coordinates(this._coordinates)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Ids(c => c
.Name("named_query")
.Boost(1.1)
.Values(1, 2, 3, 4)
.Types(typeof(Project), typeof(Developer))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Script(sn => sn
.Name("named_query")
.Boost(1.1)
.Inline(_templateString)
.Params(p=>p.Add("param1", 1))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Terms(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.Terms(_terms)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.QueryString(c => c
.Name("named_query")
.Boost(1.1)
.Fields(f => f.Field(p=>p.Description).Field("myOtherField"))
.Query("hello world")
.DefaultField(p=>p.Description)
.DefaultOperator(Operator.Or)
.Analyzer("standard")
.QuoteAnalyzer("quote-an")
.AllowLeadingWildcard()
.AutoGeneratePhraseQueries()
.MaximumDeterminizedStates(2)
.LowercaseExpendedTerms()
.EnablePositionIncrements()
.Escape()
.UseDisMax()
.FuzzyPrefixLength(2)
.FuzzyMaxExpansions(3)
.FuzzyRewrite(RewriteMultiTerm.ConstantScore)
.Rewrite(RewriteMultiTerm.ConstantScore)
.Fuziness(Fuzziness.Auto)
.TieBreaker(1.2)
.AnalyzeWildcard()
.MinimumShouldMatch(2)
.QuoteFieldSuffix("'")
.Lenient()
.Locale("en_US")
.Timezone("root")
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Boosting(c => c
.Name("named_query")
.Boost(1.1)
.Positive(qq => qq.MatchAll(m => m.Name("filter")))
.Negative(qq => qq.MatchAll(m => m.Name("query")))
.NegativeBoost(1.12)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Indices(c => c
.Name("named_query")
.Boost(1.1)
.Indices(Index<Project>())
.Query(qq => qq.MatchAll())
.NoMatchQuery(qq => qq.MatchAll(m => m.Name("no_match")))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Nested(c => c
.Name("named_query")
.Boost(1.1)
.InnerHits(i=>i.Explain())
.Query(qq=>qq.MatchAll())
.Path(p=>p.CuratedTags)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Missing(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.NullValue()
.Existence()
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Wildcard(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.Value("p*oj")
.Rewrite(RewriteMultiTerm.TopTermsBoostN)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.GeoShapePolygon(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Location)
.Coordinates(this._coordinates)
.IgnoreUnmapped()
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Indices(c => c
.Name("named_query")
.Boost(1.1)
.Indices(Nest.Indices.All)
.Query(qq => qq.MatchAll())
.NoMatchQuery(NoMatchShortcut.All)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q .Bool(b => b .MustNot(m => m.MatchAll()) .Should(m => m.MatchAll()) .Must(m => m.MatchAll()) .Filter(f => f.MatchAll()) .MinimumShouldMatch(1) .Boost(2));
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.GeoPolygon(c => c
.Name("named_query")
.Boost(1.1)
.Field(p=>p.Location)
.ValidationMethod(GeoValidationMethod.Strict)
.Points( new GeoLocation(45,-45), new GeoLocation(-34,34))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.SpanMultiTerm(c => c
.Name("named_query")
.Boost(1.1)
.Match(sq=>sq
.Prefix(pr=>pr.Field(p=>p.Name).Value("pre-*"))
)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.GeoShapeMultiLineString(c => c
.Name("named_query")
.Boost(1.1)
.Field(p=>p.Location)
.Coordinates(this._coordinates)
.Relation(GeoShapeRelation.Intersects)
.IgnoreUnmapped()
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.SpanFieldMasking(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Name)
.Query(sq=>sq
.SpanTerm(st=>st.Field(p=>p.Description).Value("dolorem"))
)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.SpanFirst(c => c
.Name("named_query")
.Boost(1.1)
.Match(sq=>sq
.SpanTerm(st=>st.Field(p=>p.Name).Value("value"))
)
.End(3)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Not(c => c
.Name("named_query")
.Boost(1.1)
.Filters(
qq => qq.MatchAll(m => m.Name("query1")),
qq => qq.MatchAll(m => m.Name("query2"))
)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.GeoHashCell(c => c
.Name("named_query")
.Boost(1.1)
.Field(p=>p.Location)
.Location(new GeoLocation(13.4080, 52.5186))
.Neighbors()
.Precision(Nest.Distance.Meters(3))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Terms(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.DisableCoord()
.MinimumShouldMatch(MinimumShouldMatch.Fixed(2))
.Terms(new List<string> { "term1", "term2" })
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.HasParent<Developer>(c => c
.Name("named_query")
.Boost(1.1)
.InnerHits(i=>i.Explain())
.Score(true)
.Query(qq=>qq.MatchAll())
.IgnoreUnmapped(true)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.Regexp(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.Value("s.*y")
.Flags("INTERSECTION|COMPLEMENT|EMPTY")
.MaximumDeterminizedStates(20000)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.GeoIndexedShape(c => c
.Name("named_query")
.Boost(1.1)
.Field(p=>p.Location)
.IndexedShape(p=>p
.Id(2)
.Path(pp=>pp.Location)
)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor<Project> q) => q
.TermRange(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
.GreaterThan("foo")
.GreaterThanOrEquals("foof")
.LessThan("bar")
.LessThanOrEquals("barb")
);
public async Task CanSerialize_QueryContainerDescriptor_WithSimpleMatchQuery()
{
var descriptor = new QueryContainerDescriptor <Project>(c => c.Match(m => m.Field("name").Query("NEST")));
var json = SerializeAndGetJsonString(descriptor);
await Verifier.VerifyJson(json);
}
public NestedSortDescriptor Filter(QueryContainerDescriptor descriptor) => Assign(descriptor, (a, v) => a._queryContainerDescriptor = v);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.Terms(c => c
.Verbatim()
.Field(p => p.Description)
.Terms(new string[] { })
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.ConstantScore(c => c
.Name("named_query")
.Boost(1.1)
.Filter(qq => qq.MatchAll(m => m.Name("filter")))
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.Type(c => c
.Name("named_query")
.Boost(1.1)
.Value <Developer>()
);
public static QueryContainer Id(this QueryContainerDescriptor <BoolCluster.A> q, int id) => q.Term(p => p.Id, id);
protected abstract QueryContainer QueryFluent(QueryContainerDescriptor <Project> q);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.MultiMatch(c => c
.Query("hello world")
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.MultiMatch(c => c
.Fields(Field <Project>(p => p.Description, 2.2).And("myOtherField^0.3"))
.Query("hello world")
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.Term(t => t
.Verbatim()
.Field(p => p.Description)
.Value("")
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.Bool(b => b
.Verbatim()
);
public static QueryContainer O(this QueryContainerDescriptor <A> q, E option) => q.Term(p => p.Option, option);
public TransactionsFilterTests()
{
_transactionDateRange = new TransactionsFilter();
_queryContainerDescriptor = new QueryContainerDescriptor <QueryableTransaction>();
}
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q .Raw(RawTermQuery);
private static QueryContainer ATermQuery(QueryContainerDescriptor <Project> must) => must.Term(p => p.Name, "foo");
public MatchCondition(QueryContainerDescriptor <TEntity> queryContainerDescriptor, Expression <Func <TEntity, object> > expField, object value)
{
_queryContainerDescriptor = queryContainerDescriptor;
_expression = (mqd) => mqd.Field(expField).Query(value.ToString());
}
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.Term(c => c
.Verbatim()
.Field(p => p.Description)
.Value(string.Empty)
);
public ExistsCondition(QueryContainerDescriptor <TEntity> queryContainerDescriptor, string colnum)
{
_queryContainerDescriptor = queryContainerDescriptor;
_colnum = colnum;
}
public MatchAllCondition(QueryContainerDescriptor <TEntity> queryContainerDescriptor)
{
_queryContainerDescriptor = queryContainerDescriptor;
}
public QueryWrapper(QueryContainerDescriptor <T> descriptor)
{
Descriptor = descriptor;
}
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.Exists(c => c
.Name("named_query")
.Boost(1.1)
.Field(p => p.Description)
);
public static QueryContainer getFilter(PropertyInfo property, object input)
{
object propertyValue = property.GetValue(input);
//string propertyName = property.Name;
Type propertyType = propertyValue.GetType();
//string testString = property.GetValue(input).ToString();
QueryContainer filter = new QueryContainer();
if (propertyType == typeof(TimeSpan))
{
//Search model passed a TimeSpan as one of its query terms
//In order to query ElasticSearch, we must convert it to a double, representing total seconds since 00:00
//First, we construct the TimeSpan object
TimeSpan runTimeObject = (TimeSpan)input.GetType().GetRuntimeProperty(property.Name).GetValue(input);
//So we can get it's total seconds
double inSeconds = runTimeObject.TotalSeconds;
//We need to query the right property, so we should fetch it.
PropertyInfo propertyToQuery = input.GetType().GetProperty(property.Name + "insec");
//Finally, we check if we're dealing with timefirst or timelast:
if (property.Name.EndsWith("first"))
{
filter = new QueryContainerDescriptor <T>()
.Range(r => r.Field(propertyToQuery)
.GreaterThanOrEquals(inSeconds)
);
}
else if (property.Name.EndsWith("last"))
{
filter = new QueryContainerDescriptor <T>()
.Range(r => r.Field(propertyToQuery)
.LessThanOrEquals(inSeconds)
);
}
}
else if (propertyType == typeof(DateTime))
{
//We hebben geen datecreated voor OLS, maar voor andere wel
return(new QueryContainer());
}
else if (propertyType == typeof(int))
{
//Lowercost of HigherCost?
if (property.Name.StartsWith("lower"))
{
filter = new QueryContainerDescriptor <T>()
.Range(r => r.Field(input.GetType().GetProperty("fld_cost"))
.GreaterThanOrEquals(Convert.ToInt32(propertyValue) * 100));
}
else if (property.Name.StartsWith("higher"))
{
filter = new QueryContainerDescriptor <T>()
.Range(r => r.Field(input.GetType().GetProperty("fld_cost"))
.LessThanOrEquals(Convert.ToInt32(propertyValue) * 100));
}
}
else
{
//String
filter = new QueryContainerDescriptor <T>()
.MatchPhrasePrefix(t => t.Field(property).Slop(10).MaxExpansions(10).Query(propertyValue.ToString()));
}
return(filter);
}
protected QueryContainer QueryFluent(QueryContainerDescriptor <PercolatedQuery> q) => q
.Percolate(p => p
.DocumentType(typeof(Project))
.Document(Project.Instance)
.Field(f => f.Query)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.Ids(c => c
.Name("named_query")
.Boost(1.1)
.Values(1, 2, 3, 4)
);
protected QueryContainer QueryFluent(QueryContainerDescriptor <ProjectPercolation> q) => q
.Percolate(p => p
.Documents(Project.Instance, Project.Instance, Project.Instance)
.Field(f => f.Query)
);
public static AnalysisCalculation.VazbyFiremNaUradyStat UradyObchodujiciSFirmami_s_vazbouNaPolitiky(Relation.AktualnostType aktualnost, bool showProgress = false)
{
HlidacStatu.Lib.Data.AnalysisCalculation.VazbyFiremNaPolitiky vazbyNaPolitiky = null;
List <Lib.Data.FirmaEvent> sponzorujiciFirmy = null;
QueryContainer qc = null;
switch (aktualnost)
{
case HlidacStatu.Lib.Data.Relation.AktualnostType.Aktualni:
vazbyNaPolitiky = StaticData.FirmySVazbamiNaPolitiky_aktualni_Cache.Get();
qc = new QueryContainerDescriptor <HlidacStatu.Lib.Data.Smlouva>().Term(t => t.Field(f => f.SVazbouNaPolitikyAktualni).Value(true));
sponzorujiciFirmy = StaticData.SponzorujiciFirmy_Nedavne.Get();
break;
case HlidacStatu.Lib.Data.Relation.AktualnostType.Nedavny:
vazbyNaPolitiky = StaticData.FirmySVazbamiNaPolitiky_nedavne_Cache.Get();
qc = new QueryContainerDescriptor <HlidacStatu.Lib.Data.Smlouva>().Term(t => t.Field(f => f.SVazbouNaPolitikyNedavne).Value(true));
sponzorujiciFirmy = StaticData.SponzorujiciFirmy_Nedavne.Get();
break;
case HlidacStatu.Lib.Data.Relation.AktualnostType.Neaktualni:
case HlidacStatu.Lib.Data.Relation.AktualnostType.Libovolny:
vazbyNaPolitiky = StaticData.FirmySVazbamiNaPolitiky_vsechny_Cache.Get();
qc = new QueryContainerDescriptor <HlidacStatu.Lib.Data.Smlouva>().Term(t => t.Field(f => f.SVazbouNaPolitiky).Value(true));
sponzorujiciFirmy = StaticData.SponzorujiciFirmy_Vsechny.Get();
break;
}
Func <int, int, Nest.ISearchResponse <Lib.Data.Smlouva> > searchFunc = null;
searchFunc = (size, page) =>
{
return(Lib.ES.Manager.GetESClient().Search <Lib.Data.Smlouva>(a => a
.TrackTotalHits(page * size == 0)
.Size(size)
.From(page * size)
.Source(m => m.Excludes(e => e.Field(o => o.Prilohy)))
.Query(q => qc)
.Scroll("1m")
));
};
//TODO predelat z projeti vsech smluv na hledani pres vsechna ICO v RS, vybrani statnich firem,
//a dohlednai jejich statistiky vuci jednotlivym ostatnim firmam v RS
Dictionary <string, Analysis.BasicDataForSubject <List <Analysis.BasicData <string> > > > uradyStatni = new Dictionary <string, Analysis.BasicDataForSubject <List <Analysis.BasicData <string> > > >();
Dictionary <string, Analysis.BasicDataForSubject <List <Analysis.BasicData <string> > > > uradySoukr = new Dictionary <string, Analysis.BasicDataForSubject <List <Analysis.BasicData <string> > > >();
object lockObj = new object();
Lib.Searching.Tools.DoActionForQuery <Lib.Data.Smlouva>(Lib.ES.Manager.GetESClient(), searchFunc,
(hit, param) =>
{
Lib.Data.Smlouva s = hit.Source;
List <string> icos = new List <string>();
try
{
var objednatelIco = s.Platce.ico;
if (!string.IsNullOrEmpty(objednatelIco))
{
Firma ff = Firmy.Get(objednatelIco);
if (!ff.Valid || !ff.PatrimStatu())
{
goto end;
}
//vsichni prijemci smlouvy statniho subjektu
icos.AddRange(s.Prijemce.Select(m => m.ico).Where(m => !string.IsNullOrEmpty(m)).Distinct());
lock (lockObj)
{
foreach (var ico in icos)
{
if (vazbyNaPolitiky.SoukromeFirmy.ContainsKey(ico) || sponzorujiciFirmy.Any(m => m.ICO == ico))
{
if (!uradySoukr.ContainsKey(objednatelIco))
{
uradySoukr.Add(objednatelIco, new Analysis.BasicDataForSubject <List <Analysis.BasicData <string> > >());
uradySoukr[objednatelIco].Ico = objednatelIco;
}
uradySoukr[objednatelIco].Add(1, s.CalculatedPriceWithVATinCZK);
if (!uradySoukr[objednatelIco].Detail.Any(m => m.Item == ico))
{
uradySoukr[objednatelIco].Detail.Add(new Analysis.BasicData <string>()
{
Item = ico, CelkemCena = s.CalculatedPriceWithVATinCZK, Pocet = 1
});
}
else
{
var item = uradySoukr[objednatelIco].Detail.First(m => m.Item == ico);
item.Add(1, s.CalculatedPriceWithVATinCZK);
}
}
else if (vazbyNaPolitiky.StatniFirmy.ContainsKey(ico))
{
if (!uradyStatni.ContainsKey(objednatelIco))
{
uradyStatni.Add(objednatelIco, new Analysis.BasicDataForSubject <List <Analysis.BasicData <string> > >());
uradyStatni[objednatelIco].Ico = objednatelIco;
}
uradyStatni[objednatelIco].Add(1, s.CalculatedPriceWithVATinCZK);
if (!uradyStatni[objednatelIco].Detail.Any(m => m.Item == ico))
{
uradyStatni[objednatelIco].Detail.Add(new Analysis.BasicData <string>()
{
Item = ico, CelkemCena = s.CalculatedPriceWithVATinCZK, Pocet = 1
});
}
else
{
var item = uradyStatni[objednatelIco].Detail.First(m => m.Item == ico);
item.Add(1, s.CalculatedPriceWithVATinCZK);
}
}
}
}
}
}
catch (Exception e)
{
HlidacStatu.Util.Consts.Logger.Error("ERROR UradyObchodujiciSFirmami_s_vazbouNaPolitiky", e);
}
end:
return(new Devmasters.Batch.ActionOutputData()
{
CancelRunning = false, Log = null
});
}, null,
showProgress ? Devmasters.Batch.Manager.DefaultOutputWriter : (Action <string>)null,
showProgress ? new Devmasters.Batch.ActionProgressWriter().Write : (Action <ActionProgressData>)null
, true
, prefix: "UradyObchodujiciSFirmami_s_vazbouNaPolitiky " + aktualnost.ToNiceDisplayName()
);
AnalysisCalculation.VazbyFiremNaUradyStat ret = new VazbyFiremNaUradyStat();
ret.SoukromeFirmy = uradySoukr
.Where(m => m.Value.Pocet > 0)
.Select(kv => kv.Value)
.OrderByDescending(o => o.Pocet);
return(ret);
}
public static QueryContainer O(this QueryContainerDescriptor <BoolCluster.A> q, BoolCluster.E option) => q.Term(p => p.Option, option);
QueryContainer BuildPhraseQueryContainer(QueryContainerDescriptor <Building> qd, string term, int slop)
{
return(qd.MatchPhrase(m => m.Field(f => f.Market).Query(term.ToLower()).Slop(slop)));
}
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.ParentId(p => p
.Name("named_query")
.Type <CommitActivity>()
.Id(Project.Instance.Name)
);
protected override QueryContainer QueryFluent(QueryContainerDescriptor <Project> q) => q
.RankFeature(rf => rf
.Name("named_query")
.Boost(1.1)
.Field(f => f.Rank)
.Linear());
