[Skip to main content](#vessel-content)

#   Report not generate based on specific date that been choose.

##

- **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")**
- [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author
- [ Offline](/forum/user/3330-ler-singmuiheng-com)

Less More

- Posts: 575
- Thank you received: 11
-
-

2 years 10 months ago [\#357957](#357957) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")  *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#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.")* was created by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")*

-- 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](https://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 652
-
-

2 years 10 months ago -  2 years 10 months ago [\#357965](#357965) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#357965 "-- 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.")*

Hello,

Can you try to reproduce my configuration shown in my screenshot :
[ ![alt](https://i.ibb.co/Zcqh0xp/screenshot1.png) ](https://i.ibb.co/Zcqh0xp/screenshot1.png "alt")

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: 2 years 10 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")**
- [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author
- [ Offline](/forum/user/3330-ler-singmuiheng-com)

Less More

- Posts: 575
- Thank you received: 11
-
-

2 years 10 months ago [\#357972](#357972) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")  Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#357972 "-- 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.")*

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](https://prnt.sc/Z2xBjhQr-Kov)

Kindly provide us the solutions. Thank you.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 652
-
-

2 years 10 months ago [\#357976](#357976) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#357976 "-- 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.")*

Hello,

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

**Note :** Use our **[ Contact us](https://www.hikashop.com/support/contact-us.html)** 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")**
- [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author
- [ Offline](/forum/user/3330-ler-singmuiheng-com)

Less More

- Posts: 575
- Thank you received: 11
-
-

2 years 10 months ago -  2 years 10 months ago [\#357993](#357993) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")  Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#357993 "-- 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.")*

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: 2 years 10 months ago by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86540
- Thank you received: 14299
-
-

2 years 10 months ago [\#358021](#358021) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#358021 "-- 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.")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")**
- [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author
- [ Offline](/forum/user/3330-ler-singmuiheng-com)

Less More

- Posts: 575
- Thank you received: 11
-
-

2 years 10 months ago [\#358061](#358061) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")  Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#358061 "-- 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.")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86540
- Thank you received: 14299
-
-

2 years 10 months ago [\#358062](#358062) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#358062 "-- 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.")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")**
- [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author
- [ Offline](/forum/user/3330-ler-singmuiheng-com)

Less More

- Posts: 575
- Thank you received: 11
-
-

2 years 10 months ago [\#358071](#358071) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")  Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#358071 "-- 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.")*

> 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86540
- Thank you received: 14299
-
-

2 years 10 months ago [\#358073](#358073) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report not generate based on specific date that been choose.](/forum/36-reports-statistics/907527-report-not-generate-based-on-specific-date-that-been-choose#358073 "-- 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.")*

Hi,

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

if($widget-&gt;widget_params-&gt;content=='products' &#124;&#124; $widget-&gt;widget_params-&gt;content=='categories'){ $filters=$this-&gt;_dateLimit($widget, $filters, $date_field); }else{ $filters[]='order_discount_code IS NOT NULL AND order_discount_code &lt;&gt; \'\''; }

to: Code:

$filters=$this-&gt;_dateLimit($widget, $filters, $date_field); if($widget-&gt;widget_params-&gt;content=='discounts'){ $filters[]='order_discount_code IS NOT NULL AND order_discount_code &lt;&gt; \'\''; }

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3JlcG9ydHMtc3RhdGlzdGljcy85MDc1MjctcmVwb3J0LW5vdC1nZW5lcmF0ZS1iYXNlZC1vbi1zcGVjaWZpYy1kYXRlLXRoYXQtYmVlbi1jaG9vc2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.068 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
