Author Topic: Bug Revenue Report using GMT  (Read 602 times)

suvel

  • Beginner
  • *
  • Posts: 11
Bug Revenue Report using GMT
« on: December 17, 2018, 18:29:34 pm »
php version: 7.2.5
Joomla version: 3.9.1
VirtueMart version: 3.4.2.9966
Joomla set to TimeZone "Amsterdam"

It seems that the Revenue Report (and the nice graphic at the main controlpanel  ;)) is using the stored GMT date/time.
I'm aware VM is using GMT time when saving records (orders) but voor displaying, generating invoices etc this GMT time is converted to the local timezone set at Joomla Server configuration.

In my case (1 hour after GMT - Netherlands) :
- when a shopper confirms an order for example at December 17, 2018  00:05  the time stored at the order record will show 2018-12-16 23:05:22
- at my order detail page, order overview page and also on invoices the correct date December 17, 2018 is displayed.
- at the Revenue Report page the view will add this order to date December 16, 2018 and is not corrected according TimeZone setting website.

Is there an easy way to correct this for now and perhaps in the future whitin a new build? The current Revenue Report puzzled the webshop owner  :(

Thx,
Ronald


Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3821
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Bug Revenue Report using GMT
« Reply #1 on: December 18, 2018, 15:09:14 pm »
Have you try to modify the user timezone ?
In this case you can fake the displayed result i think.

suvel

  • Beginner
  • *
  • Posts: 11
Re: Bug Revenue Report using GMT
« Reply #2 on: December 18, 2018, 17:45:14 pm »
For testing 2 administrator users:
1 with timezone "Amsterdam" GMT +1
1 with timezone "London" GMT

No change at date/time backend. Both the same  :-\

Nice try but is seems not to work and does not solve this issue

afterglow80

  • Beginner
  • *
  • Posts: 15
Re: Bug Revenue Report using GMT
« Reply #3 on: April 16, 2019, 04:34:39 am »
I have this same issue. Revenue Report is displaying only in UTC, no matter what timezone server is set to or user is set to, the report will only show UTC. We need some help with showing the report in the timezone we're in. How do we fix this?

afterglow80

  • Beginner
  • *
  • Posts: 15
Re: Bug Revenue Report using GMT
« Reply #4 on: April 29, 2019, 21:32:39 pm »
*bump*