views:

36

answers:

0

Hi

I need to reaqlize search in product model with prices in different currencies (price and currecny_id field). Every currency have own rate. When user search for product in price range [x, y] USD, range must be converted to all currencies and return values like

(price > from_eur AND price < to_eur AND currecny_id = 1) OR
(price > from_aud AND price < to_aud AND currecny_id = 2)

How to realize search like this using searchlogic?