Summary Reports 3.0 - BUG

Topics related to AppGini plugins/add-ons go here.
Post Reply
imike
Posts: 8
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 1634 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 1634 times
And a screenshot of the filter:
3.png
3.png (25.7 KiB) Viewed 1634 times

And the second column:
4.png
4.png (141.08 KiB) Viewed 1634 times
And a screenshot of the filter:
5.png
5.png (25.72 KiB) Viewed 1634 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: 8
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: 1281
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: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply