[FIX] product: pricelists with temporary discounts

Create a pricelist with a temporary discount on some product only for today.
Go to the shop. The discount is applied on the product.
Add the product to the cart.
Go to the cart page (review order): the price does not use the discount.

Because the query getting the pricelist item is some handwritten SQL,
it only works for dates, and not e.g. in the case of datetimes.
So the pricelist item encoding the discount is not retrieved, and thus not used.

It turns out e.g. in _website_product_id_change it gives a datetime in context,
explaining why sometimes the discount is applied, and sometimes not.

We use fields.Date.to_date as it should work on all date formats we shall pass.

Co-written with @sbbaro

opw 2054881

closes odoo/odoo#36453

Signed-off-by: Nans Lefebvre (len) <len@odoo.com>

0 files changed, 0 insertions, 0 deletions