/// <summary>
/// Search by criteria model search transection.
/// </summary>
/// <param name="model">The criteria search vendor transection model.</param>
/// <returns></returns>
private IEnumerable <VendorTransectionViewModel> SearchTransection(VendorTransectionSearchViewModel model)
{
return(_mapper.Map <IEnumerable <VendorTransaction>, IEnumerable <VendorTransectionViewModel> >(
this.GetTransections(model.StartDate, model.EndDate, new string[] { model.PurGroup })));
}
/// <summary>
/// Get VendorTransection list.
/// </summary>
/// <returns></returns>
public IEnumerable <VendorTransectionElasticSearchModel> GetListSearchElastic(VendorTransectionSearchViewModel model)
{
return(_elasticSearch.SearchFilter(this.GetQueryFilter(model)));
}
/// <summary>
/// Get query filter search descriptor.
/// </summary>
/// <param name="search">The search value.</param>
/// <returns></returns>
private Func <SearchDescriptor <VendorTransectionElasticSearchModel>, ISearchRequest> GetQueryFilter(VendorTransectionSearchViewModel search)
{
var startDate = UtilityService.ConvertToDateTime(search.StartDate, ConstantValue.DateTimeFormat);
var endDate = UtilityService.ConvertToDateTime(search.EndDate, ConstantValue.DateTimeFormat);
ISearchRequest searchFunc(SearchDescriptor <VendorTransectionElasticSearchModel> s) => s
.Index(ConstantValue.VendorTransactionIndex)
//.From(0)
//.Take(1000)
.Query(q =>
//q.Bool(b =>
// //b.Must(m =>
// // m.Match(mm =>
// // mm.Field(f => search.PurGroup.Contains(f.PurgropCode))
// // .Field(f => _token.PurchasingOrg.Contains(f.PurorgCode))
// // ))
// //b.Filter(ff =>
// // // ff.DateRange(t => t.Field(f => f.ReceiptDate).GreaterThanOrEquals(startDate).LessThanOrEquals(endDate)) &&
// // ff.Term(t => t.Field(f => f.PurgropCode).Value(search.PurGroup))
// //)
// )
q.Match(m => m.Field(f => search.PurGroup.Contains(f.PurgropCode)))
)
.Sort(m => m.Descending(f => f.Id));
return(searchFunc);
}
/// <summary>
/// Get VendorTransection list.
/// </summary>
/// <returns></returns>
public IEnumerable <VendorTransectionViewModel> GetListSearch(VendorTransectionSearchViewModel model)
{
return(this.InitialVendorName(this.SearchTransection(model)));
}
public IActionResult GetListSearch([FromQuery] VendorTransectionSearchViewModel model)
{
return(Ok(_vendorTransection.GetListSearch(model)));
}
