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',
Code: Select all
'date_format' => 'd-m-Y H:i',
'date_separator' => '-',
'jsmoment_date_format' => 'DD-MM-YYYY HH:mm',
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: When I click on the average from the first column I get the following filtered data:
And a screenshot of the filter:
And the second column: And a screenshot of the filter: 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?