Openbravo Issue Tracking System - Retail Modules
View Issue Details
0044889Retail ModulesWeb POSpublic2020-08-25 15:232020-09-15 04:39
martinsdan 
Retail 
normalmajorhave not tried
newopen 
30Ubuntu 18.04.1 LTS
RR19Q3.2 
 
No
0044889: Absolute DateTime is wrongly loaded in the POS
There is a field that stores the ticket date using the original timezone of the POS, in fact ignoring the timezone (em_obpos_createdabsolute).
If we try to load this field, it is converted to UTC as any other date.

There is no way to correctly load it.
Extend the paidReceipts model adding:
new HQLProperty("ord.obposCreatedabsolute", "obposCreatedabsolute")

- Create a ticket in a server with a timezone that is not UTC
- Load the ticket from the backend

The newly added property is not the original date.
Change HQLPropertyList.getJSONArray to not convert absolute references
No tags attached.
Issue History
2020-08-25 15:23martinsdanNew Issue
2020-08-25 15:23martinsdanAssigned To => Retail
2020-08-25 15:23martinsdanResolution time => 1600124400
2020-08-25 15:23martinsdanTriggers an Emergency Pack => No
2020-09-14 09:21ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2020-09-14 13:43marvintmResolution time1600124400 =>
2020-09-14 13:43marvintmNote Added: 0123020
2020-09-14 13:43marvintmTypedefect => design defect
2020-09-15 04:39ranjith_qualiantech_comAssigned Toranjith_qualiantech_com => Retail

Notes
(0123020)
marvintm   
2020-09-14 13:43   
Changed to design defect.

The issue is valid and reproducible. However, in order to fix it, we would need to change the whole ProcessHQLQuery/ExtensibleProperty mechanism, with its corresponding significant API change, and we are unfortunately not in a position to do it for now.