Report Statistic Date & Order actual date difference

Hi,

Do you have the "dashboard legacy" setting activated or deactivated in the HikaShop configuration ?
If you change that setting, does it change anything for the data on the dashboard ?
Also, which version of HikaShop were you using before updating ?
I've been looking in our SVN for changes to the reports system regarding the dates and I've been up to 2 years and a half in the past and didn't see any change which would affect the date restrictions.

Also, how did you configure the report? Could you provide a screenshot ? Could you also tell us how you configure your timezone in your Joomla configuration and in your user account in Joomla ?

Hi,

Well, you're not comparing the same data on both screenshots.
On the report, you have many order statuses selected but on the new dashboard, only the "statistics" statuses from the System>Order statuses menu are taken into account. Also, if the "created" order status is enabled as a "statistics" status, then it's the order creation date of orders that is used for the dashboard, and if not, it's the invoice creation date of orders that is used, while in your report, you're using the "last modified" date which is again another date.
The order creation date is the date the order was created in the shop.
The invoice creation date is the date the order was paid.
The last modified date is the date the last time something was changed in th order.
Normally, a customer will pay the order directly after it is created and you won't edit the order afterwards, so all these dates would be almost identical. But it's possible that the order was created two weeks ago, paid last week and that you modified it yesterday.

So because of these, it's totally possible to get results way off between the reports and the dashboard because you're not necessarily comparing the same things and it's highly likely that both are correct for what they are trying to display.

Hi,

Well, first if you want the same data as on the reports, you might want to deactivate the "dashboard legacy" setting of the HikaShop configuration.

Otherwise, regarding the new dashboard, as I said in my previous message, if you enable the "created" status in the "statistic" column of the menu System>Order statuses, it will be the order creation date that will be used.

Hello,

The processing of the date (based on the timestamp) is made directly by MySQL ; so it is possible that you have some timezone in your PHP and that your MySQL do not have the same timezone.
So when MySQL convert the timestamp into a date, due to the different timezone, the result date is different.

And please note that we had to do that task by MySQL because it then aggregate the values depending the date ; it provides better performances (memory and CPU) that getting all the data and process it using PHP.
Regarding the Joomla timezone, it is handle by the statistic system, which add that information in the SQL query

'DATE_FORMAT(FROM_UNIXTIME(CAST(hk_order.order_invoice_created AS SIGNED)'.$this->timeoffsetStr.'),\'{DATE_FORMAT}\') as axis';

Hi,

Well, we don't have the problem on our end.
So we need a concrete example to be able to understand the situation on your end.
Please pick an order and in your phpmyadmin, open the table hikashop_order and provide the order_invoice_created and the order_created values that you have for that order.
Then, run that query:
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
and provide the result. It should display the offset from UTC that is used by your MySQL.
Also, after the line:
$this->timeoffsetStr = '+' . $this->timeoffset ;
in the file administrator/components/com_hikashop/classes/statistics.php pleas add the line:
var_dump($this->timeoffsetStr);
and access your dashboard. You should then see the offset (in seconds) that is used by HikaShop and coming from the configuration of your Joomla at the top of the statistics area. Please provide that value.

Hi,

Thanks.
So for the order SF05273, the timestamp 1513840307 corresponds to 2017-12-21 07:11:47 UTC ( www.unixtimestamp.com/index.php )
The code of the statistics system is:

'DATE_FORMAT(FROM_UNIXTIME(CAST(hk_order.order_invoice_created AS SIGNED)'.$this->timeoffsetStr.'),\'{DATE_FORMAT}\') as axis';

SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(1513840307 AS SIGNED)+28800), '%Y-%m-%d %T')