Summary Reports 3.0 - BUG

Topics related to AppGini plugins/add-ons go here.
Post Reply
imike
Posts: 7
Joined: 2020-02-25 15:35

Summary Reports 3.0 - BUG

Post by imike » 2020-05-14 07:42

Hey,
I found bug in Summary reports 3.0. Since I have the "DateTime" column, I changed the /hooks/summary-reports_table_name-0.php date format from:

Code: Select all

'date_format' => 'd-m-Y',
'date_separator' => '-',
'jsmoment_date_format' => 'DD-MM-YYYY',
on

Code: Select all

'date_format' => 'd-m-Y H:i',
'date_separator' => '-',
'jsmoment_date_format' => 'DD-MM-YYYY HH:mm',
The first thing:
The table name looks like this:
Table_name from 04-04-2020 00:00 to 30-04-2020 00:00

instead:
Table_name from 04-04-2020 00:00 to 30-04-2020 23:59

My report looks like this:
1.png
1.png (58.37 KiB) Viewed 194 times
When I click on the average from the first column I get the following filtered data:
2.png
2.png (144.39 KiB) Viewed 194 times
And a screenshot of the filter:
3.png
3.png (25.7 KiB) Viewed 194 times

And the second column:
4.png
4.png (141.08 KiB) Viewed 194 times
And a screenshot of the filter:
5.png
5.png (25.72 KiB) Viewed 194 times
Conclusions:
As you can see in the first screenshot, the data for the same period is the same. However, when I click on the data from the second column, the filter is different (correct, it takes the whole month).

I would like to count and filter the entire month, i.e. the period from 01-04-2020 00:00 to 30-04-2020 23:59 instead of 01-04-2020 00:00 to 30-04-2020 00:00.

How to fix it? What do I need to change in the SummaryReport.php file to make it work?

imike
Posts: 7
Joined: 2020-02-25 15:35

Re: Summary Reports 3.0 - BUG

Post by imike » 2020-05-19 06:56

I found another bug but it looks like nobody is interested in the previous one...

User avatar
a.gneady
Site Admin
Posts: 1079
Joined: 2012-09-27 14:46
Contact:

Re: Summary Reports 3.0 - BUG

Post by a.gneady » 2020-05-21 12:23

Hmm .. here is what I understood regarding the issue you're reporting: In Summary Reports, if you set the from and to dates of the report, the data shown includes data from the 'from date' up to but excluding (rather than including) the 'to date'. Is that correct?
:idea: Calendar plugin: Organize your data into beautiful calendars. NEW
:arrow: Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
:arrow: Summary Reports plugin: Build powerful reports and charts for your AppGini apps.
:arrow: Search Page Maker: Compose user-friendly yet powerful search pages for your AppGini apps.

Post Reply