Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0033265
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2016-06-15 09:412016-06-23 13:39
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision1d10c17d8e96
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033265: Times and DateTimes are not properly converted by the function getJSONArray(Query)

DescriptionIn mobile.core java class "HQLPropertyList", the method "public JSONArray getJSONArray(Query query) throws JSONException" do not sets the UTC timezome when formatting to a javascript date. This is needed because otherwise the WebPOS will load a date time with a difference of the server time zone. For example if the webPOS sends the date "2016-06-10T15:00:00.698Z" it will receive 2016-06-10T13:00:00.698Z". This was properly managed in the deprecated function getJSONObjectRow(Object[])
Steps To ReproduceCreate a new datetime or time field in c_orderline, and create and the functionality to save and load the value. There is a field like this "delivery time" in https://code.openbravo.com/erp/pmods/org.openbravo.retail.deliveryconditions [^]
Proposed SolutionJust add the UTC time zone when formatting dates in getJSONArray(Query):

df.setTimeZone(TimeZone.getTimeZone("UTC"));
TagsNo tags attached.
Attached Filesdiff file icon issue33265.diff [^] (2,577 bytes) 2016-06-15 09:44 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0033496 closedadrianromero Wrong receipt time when loading paid receipts 

-  Notes
(0087285)
adrianromero (manager)
2016-06-15 09:45

The attached file already passes try successfully https://ci.openbravo.com//job/try-ret-test-pgsql-suite1/3424/ [^]
(0087383)
hgbot (developer)
2016-06-17 10:16

Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 1d10c17d8e96b3406ef49fb352a09d287386364a
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Fri Jun 17 10:15:30 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/1d10c17d8e96b3406ef49fb352a09d287386364a [^]

Fixes issue 0033265: Times and DateTimes are not properly converted by the function getJSONArray(Query)
* Sets the UTC time zone when formatting JS date times to be sent to WebPOS
* Indluces formatting of the sources

---
M src/org/openbravo/mobile/core/model/HQLPropertyList.java
---

- Issue History
Date Modified Username Field Change
2016-06-15 09:41 adrianromero New Issue
2016-06-15 09:41 adrianromero Assigned To => adrianromero
2016-06-15 09:41 adrianromero Resolution time => 1466546400
2016-06-15 09:41 adrianromero Triggers an Emergency Pack => No
2016-06-15 09:41 adrianromero Status new => scheduled
2016-06-15 09:44 adrianromero File Added: issue33265.diff
2016-06-15 09:45 adrianromero Note Added: 0087285
2016-06-17 10:16 hgbot Checkin
2016-06-17 10:16 hgbot Note Added: 0087383
2016-06-17 10:16 hgbot Status scheduled => resolved
2016-06-17 10:16 hgbot Resolution open => fixed
2016-06-17 10:16 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/1d10c17d8e96b3406ef49fb352a09d287386364a [^]
2016-06-17 10:18 adrianromero Review Assigned To => marvintm
2016-06-23 13:39 marvintm Status resolved => closed
2016-07-19 12:42 adrianromero Relationship added related to 0033496


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker