Wrong dates statistics per month

Udo
Topic Author
Offline

6 years 2 months ago #322664 by Udo

Wrong dates statistics per month was created by Udo

-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.19
-- PHP version -- : 7.2.31

Hi,

Strange things are happening in the statistic reports.
When daily or weekly figures are displayed, the associated dates are correct.
But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers.

It's all about a line chart with start date 2020-01-01 and end date 2020-12-31.
Two screenshots are attached to make clear what happens.
.
In screenshot 1 the items are grouped per week.
The X-axis displays the correct dates: Jan 01 unto Jan 01.
An example of the statistics: on Aug. 10 the sales of the previous week are displayed.

In screenshot 2 the items are grouped per month Start date and end date are unchanged.
Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01
Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on.
This is very confusing and incorrect.

The red lines in the charts are sales in the same period last year.

Please advice.

Regards,
Udo.

Regards,
Udo

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 2 months ago #323228 by Udo

Replied by Udo on topic Wrong dates statistics per month

Hi,
Something went wrong, I'm afraid.
I never received an answer on this topic.

regards,
Udo

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

6 years 1 month ago #323355 by Jerome

Replied by Jerome on topic Wrong dates statistics per month

Hello,

Can you please provide a screenshot of your "report" configuration ?

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 1 month ago #323358 by Udo

Replied by Udo on topic Wrong dates statistics per month

Hi,

Attached is a screenshot of the configuration of the monthly sales report.

Before updating to Hikashop 4.3.0 I used the columns display type. That was working fine.
Alas that display type is removed.

Regards,
Udo

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

6 years 1 month ago #323363 by Jerome

Replied by Jerome on topic Wrong dates statistics per month

Hello,

Do you know which version you were using before your update to HikaShop 4.3.0 ?

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 1 month ago #323392 by Udo

Replied by Udo on topic Wrong dates statistics per month

I was using Hikashop 3.5.1

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

6 years 1 month ago #323403 by Jerome

Replied by Jerome on topic Wrong dates statistics per month

Hello,

Between HikaShop 3.5.1 and HikaShop 4.3.0 ; there was a fix related to the handle of the timezone in the reports.
So, I suppose the issue you see is related to a swift of few hours which would correspond to the timezone.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 1 month ago #323458 by Udo

Replied by Udo on topic Wrong dates statistics per month

Hi,

If the issue is caused by this timezone fix it did not affect items grouped by week, only intems grouped by month.

Is there any way to address the problem?

regards,
Udo

Please Log in or Create an account to join the conversation.

Mohamed Thelji
Offline

6 years 1 month ago #323981 by Mohamed Thelji

Replied by Mohamed Thelji on topic Wrong dates statistics per month

Hello Udo,

I just tested it with the same configuration and it worked fine, can you download the last Hikashop version through our website, install it and test it again ?

If you're still having that issue can you send us a temporary access to your back-end so that we can directly test it ? Thank you.

You can send it using our contact form via :
www.hikashop.com/support/contact-us.html

Also, don't forget to add a link to that thread in your message, thank you.

Kind regards,
Mohamed.

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 1 month ago #323996 by Udo

Replied by Udo on topic Wrong dates statistics per month

Hi Mohamed,

I'm using the last Hikashop version 4.3.0

The access details are mailed via the contact form.

Looking at the recent reports I notice that the months Aug and Oct are displayed but Sept is missing.
Aug shows the statistics of the current month September.

Thnaks,
Udo

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 2 weeks ago #324479 by Udo

Replied by Udo on topic Wrong dates statistics per month

Any advice?

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 1 day ago #324962 by Udo

Replied by Udo on topic Wrong dates statistics per month

Hi,
Your temporay access to the website is now disabled.
Unfortunately you didnot reply anymore.

Regards,
Udo

Please Log in or Create an account to join the conversation.

Mohamed Thelji
Offline

6 years 1 day ago - 6 years 1 day ago #324964 by Mohamed Thelji

Replied by Mohamed Thelji on topic Wrong dates statistics per month

Hello Udo and sorry for the late reply,

We were actually able to reproduc that issue on our end, and made a fix. The solution will be to edit the file "administrator\components\com_hikashop\classes\widget.php" and change these lines :

Code:

function _jsDate($group,&$element, $widget=null, $diff=null){
	if(!isset($element->timestamp)){
		switch($group){
			case '%H %j %Y'://day
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime($parts[2], 0, 0, 1, $parts[1], $parts[0]) - $this->timeoffset;
				break;
			case '%j %Y'://day
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime(0, 0, 0, 1, $parts[1], $parts[0])- $this->timeoffset;
				break;
			case '%u %Y'://week
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime(0, 0, 0, 1, $parts[1]*7, $parts[0])- $this->timeoffset;
				break;
			case '%m %Y'://month
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime(0, 0, 0, $parts[1], 1, $parts[0])- $this->timeoffset;
				break;
			case '%Y'://year
				$element->timestamp = gmmktime(0, 0, 0, 1, 1, $element->calculated_date)- $this->timeoffset;
				break;
		}
	}

	if(isset($widget->widget_params->period_compare)){
		if($widget->widget_params->period_compare=='last_period' && isset($widget->elements)){
				$element->timestamp=$element->timestamp+$diff;
		}
	}

	$element->year = date('Y',$element->timestamp);
	$element->month = date('m',$element->timestamp)-1;
	$element->day = date('j',$element->timestamp);
	if($widget->widget_params->date_group=="%H %j %Y"){
		$element->hour = date('G',$element->timestamp);
	}
}

By :

Code:

function _jsDate($group,&$element, $widget=null, $diff=null){
	if(!isset($element->timestamp)){
		switch($group){
			case '%H %j %Y'://day
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime($parts[2], 0, 0, 1, $parts[1], $parts[0]);
				break;
			case '%j %Y'://day
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime(0, 0, 0, 1, $parts[1], $parts[0]);
				break;
			case '%u %Y'://week
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime(0, 0, 0, 1, $parts[1]*7, $parts[0]);
				break;
			case '%m %Y'://month
				$parts = explode(' ',$element->calculated_date);
				$element->timestamp = gmmktime(0, 0, 0, $parts[1], 1, $parts[0]);
				break;
			case '%Y'://year
				$element->timestamp = gmmktime(0, 0, 0, 1, 1, $element->calculated_date);
				break;
		}
	}

	if(isset($widget->widget_params->period_compare)){
		if($widget->widget_params->period_compare=='last_period' && isset($widget->elements)){
				$element->timestamp=$element->timestamp+$diff;
		}
	}

	// Setting the timezone
	$joomlaConfig = JFactory::getConfig();
	if(!HIKASHOP_J30)
		$offset = $joomlaConfig->getValue('config.offset');
	else
		$offset = $joomlaConfig->get('offset');		

	date_default_timezone_set(JFactory::getUser()->getParam('timezone', $offset));

	$element->year = date('Y',$element->timestamp);
	$element->month = date('m',$element->timestamp)-1;
	$element->day = date('j',$element->timestamp);
	if($widget->widget_params->date_group=="%H %j %Y"){
		$element->hour = date('G',$element->timestamp);
	}
}

Thanks for your feedback !
Kind regards,
Mohamed

Last edit: 6 years 1 day ago by Mohamed Thelji.

The following user(s) said Thank You: Udo

Please Log in or Create an account to join the conversation.

Udo
Topic Author
Offline

6 years 18 hours ago #325007 by Udo

Replied by Udo on topic Wrong dates statistics per month

Thanks a lot, Mohamed.

Problem solved!

regards,
Udo

The following user(s) said Thank You: Philip

Please Log in or Create an account to join the conversation.

Time to create page: 0.474 seconds