Report not generate based on specific date that been choose.

  • Posts: 556
  • Thank you received: 11
  • Hikashop Business
6 months 3 weeks ago #357957

-- HikaShop version -- : 4.4.3
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.2.34

Hi Hikashop Team,

Our side got settings the date at report as image attach : prnt.sc/4WObxPQ3cJ5Y

But the listing are total how many coupons been used not in the specific day that been choose.

How to settings make it become list out only the amount of coupons been use on the day or date been selected?

Kindly advise. Thank you.

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

  • Posts: 4618
  • Thank you received: 624
  • MODERATOR
6 months 3 weeks ago #357965

Hello,

Can you try to reproduce my configuration shown in my screenshot :



Take a good note of the red bordered settings.
And make us your returns, hope this will help you to fit your needs.
Regards

Last edit: 6 months 3 weeks ago by Philip.

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

  • Posts: 556
  • Thank you received: 11
  • Hikashop Business
6 months 3 weeks ago #357972

Hi,

Our side already settings same as yours but we still cannot get the result as we wish.

The result that we want is the report generate based on the date.

But, the result that we get is the total of how many the coupons been use overall.

Here i attach settings from our side : prnt.sc/Z2xBjhQr-Kov

Kindly provide us the solutions. Thank you.

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

  • Posts: 4618
  • Thank you received: 624
  • MODERATOR
6 months 2 weeks ago #357976

Hello,

Can you provide these elements:
- An Url link to your backend (administrator)
- Backend user references (with maximum Acl)

Note : Use our Contact us form to provide these elements, and add an Url link to this topic.
Precise if your provided website access is in product phase or not.
Regards

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

  • Posts: 556
  • Thank you received: 11
  • Hikashop Business
6 months 2 weeks ago #357993

Hello ,

I already fill in contact us form the information.

Kindly check it. This is the title "Report not generate based on specific date that been choose."

The report been sent by today 4.1.2023 ( around 9:29am )

Thank you.

Last edit: 6 months 2 weeks ago by ler@singmuiheng.com.

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

  • Posts: 82095
  • Thank you received: 13195
  • MODERATOR
6 months 2 weeks ago #358021

Hi,

Thanks for the access.
I looked into it today and found the issue.
I've made a patch in order to fix the problem and it's now working properly on my end.

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

  • Posts: 556
  • Thank you received: 11
  • Hikashop Business
6 months 2 weeks ago #358061

can we have the patch file or how to fix ?

report id 14 is error now

report id 15 is still showing incorrect figure while date set TODAY

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

  • Posts: 82095
  • Thank you received: 13195
  • MODERATOR
6 months 2 weeks ago #358062

Hi,

Sorry, I forgot to say that I included the patch in the install package of HikaShop. So you can download the install package of HikaShop on our website and install it on yours to get the patch.

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

  • Posts: 556
  • Thank you received: 11
  • Hikashop Business
6 months 2 weeks ago #358071

nicolas wrote: Hi,

Sorry, I forgot to say that I included the patch in the install package of HikaShop. So you can download the install package of HikaShop on our website and install it on yours to get the patch.


do you mind to provide us the edited file only?

as this website have some customization, worry patching will revert some changes

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

  • Posts: 82095
  • Thank you received: 13195
  • MODERATOR
6 months 2 weeks ago #358073

Hi,

In the file administrator/components/com_hikashop/classes/widget.php you can change the code:

					if($widget->widget_params->content=='products' || $widget->widget_params->content=='categories'){
						$filters=$this->_dateLimit($widget, $filters, $date_field);
					}else{
						$filters[]='order_discount_code IS NOT NULL AND order_discount_code <> \'\'';
					}
to:
					$filters=$this->_dateLimit($widget, $filters, $date_field);
					if($widget->widget_params->content=='discounts'){
						$filters[]='order_discount_code IS NOT NULL AND order_discount_code <> \'\'';
					}

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

Time to create page: 0.071 seconds
Powered by Kunena Forum