0030730: The current date to check if a discount should be applied or not is taken using GMT timezone

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0030730

Retail Modules

Discounts and Promotions

public

2015-09-01 19:11

2015-09-25 11:58

Reporter

egoitz

Assigned To

mario_castello

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR15Q4

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

OBPS

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0030730: The current date to check if a discount should be applied or not is taken using GMT timezone

Description

To check if a discount should be used or not a query on the sql lite database is executed using the date('now') clause.
the database is returning the current date assuming that the timezone is GMT.
If you are on a different timezone, and the current date is different than the date on the gmt timezone, you can apply discounts that should't or viceversa

Steps To Reproduce

-Put your computer (client side) on gmt+2 on hour 01:30 am
-Open a webpos on chrome
-open the developers tool and the resources section
-go to the database and execute
select date('now')
that returns a date one day previous than the date of your computer

Proposed Solution

Additional Information