0049517: API call - Availability of a promotion is calculated on universal time by the API

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0049517

Retail Modules

Discounts and Promotions

public

2022-06-09 09:49

2022-07-19 06:45

Reporter

rfacon

Assigned To

radhakrishnan

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR22Q4

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0049517: API call - Availability of a promotion is calculated on universal time by the API

Description

When configuring the availability subtab of a promotion using hours filters in the Back Office, this promotion is wrongly applied when a call is done on API Discount

Steps To Reproduce

1. Configure a discount in the Backend, for example:
- Discount/Promotion Type: Price adjustment
- Active = Y
- Define the discount for a product, for example Baby carrier and select "Included Products" = Only those defined.

2. In the subtab 'Availability' add a row: define 'Monday' from '0:00:00' to '23:59:59'

3. Call the API Discount https://{{OPENBRAVO_URL}}/openbravo/ws/org.openbravo.discounts.discount [^] with the product put at step 1 and an order date set on a Monday, "orderDate": "2022-06-06T13:59:00" for example

You will see the discount applied as configured.

4. Change the hour of the 'orderDate" doing several calls :
- "orderDate": "2022-06-06T23:00:00" (Monday)
- "orderDate": "2022-06-05T23:00:00" (Sunday)

In the summer time for France ("orderDate": "2022-06-06") you will see the discount applied from 'Sunday 22:00:00' to 'Monday 21:59:59' (UTC+2)

In the winter time for France ("orderDate": "2022-03-07") you will see the discount applied from 'Sunday 23:00:00' to 'Monday 22:59:59' (UTC+1)

An example of API Discount call is set in attachements

Proposed Solution

Additional Information

Tags

NOR

Relationships

related to	feature request	0048383	pi	closed	jetxarri	Allow to activate promotions on 2 distinct time slots within the same day
related to	defect	0049204		closed	ranjith_qualiantech_com	Modifying the Availibility subtab doesn't update the discount audit section
related to	defect	0049195		closed	radhakrishnan	Availability subtab records can be deleted
related to	defect	0049194		closed	radhakrishnan	Discount availability should be validated with POS time instead of server time
related to	defect	0049518		closed	radhakrishnan	API call - A promotion with an availability set on the last hours of a day is also applied on the last hours of the day before