Feature: get products in a price range

[gdlcf88]

Price is a property of the ProductSku entity. The ProductView caches the lowest and the highest price of a product:

EShop/modules/EasyAbp.EShop.Products/src/EasyAbp.EShop.Products.Application.Contracts/EasyAbp/EShop/Products/Products/Dtos/ProductViewDto.cs

Lines 32 to 34 in 4d9d410

	public decimal? MinimumPrice { get; set; }
	public decimal? MaximumPrice { get; set; }

That makes a price range query possible to implement. If a customer is querying from min to max, we can query ProductViews with MinimumPrice < max && MaximumPrice > min.

However, I found a problem. Given a product has 2 SKUs with price 100 and 800. When querying from 200 to 700, the result will contain this product. But the truth is that the latter doesn't have an SKU with a price from 200 to 700.

I am still looking for a way to resolve it.