Public bug reported:
Reports > Configure report > Dates: 14th March - 23rd April, 2022,
Report type: Portfolios with reviewers
Tested in both mysql and postgres
When the dates in the institution_data table are within a certain range,
all the information does not appear on the report.
Test cases:
Given there are two entry sets in the institution_data table (created by cron
run each Monday) on these dates ('ctime') and the reporting time period is set
to be between 14th March - 23rd April, 2022, in this case we only get data from
the 18th April (despite the paginator counting 2 results):
2022-04-04 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
AND
2022-04-11 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
However, for the same reporting period, we get BOTH results when the entries in
the table are the following:
2022-03-21 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
And..
2022-03-28 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
The theory is that it's something to do with Daylight Savings time,
which comes into effect on 2nd of April. Specifically, line 2450 in
htdocs/lib/statistics.php, where the $from date is incremented by a week
with $from = $from + (7 * 24 * 60 * 60) to set the $daterange
** Affects: mahara
Importance: Undecided
Status: New
** Description changed:
Reports > Configure report > Dates: 14th March - 23rd April, 2022,
Report type: Portfolios with reviewers
Tested in both mysql and postgres
When the dates in the institution_data table are within a certain range,
all the information does not appear on the report.
Test cases:
- Given there are two entry sets in the institution_data table (created by cron
run each Monday) on these dates and the reporting time period is set to be
between 14th March - 23rd April, 2022, in this case we only get data from the
18th April (despite the paginator counting 2 results):
+ Given there are two entry sets in the institution_data table (created by cron
run each Monday) on these dates ('ctime') and the reporting time period is set
to be between 14th March - 23rd April, 2022, in this case we only get data from
the 18th April (despite the paginator counting 2 results):
2022-04-04 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
AND
2022-04-11 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
However, for the same reporting period, we get BOTH results when the entries
in the table are the following:
2022-03-21 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
And..
2022-03-28 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
The theory is that it's something to do with Daylight Savings time,
which comes into effect on 2nd of April. Specifically, line 2450 in
htdocs/lib/statistics.php, where the $from date is incremented by a week
with $from = $from + (7 * 24 * 60 * 60) to set the $daterange
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/1969872
Title:
'Portfolios with reviewers' report date calculation error
Status in Mahara:
New
Bug description:
Reports > Configure report > Dates: 14th March - 23rd April, 2022,
Report type: Portfolios with reviewers
Tested in both mysql and postgres
When the dates in the institution_data table are within a certain
range, all the information does not appear on the report.
Test cases:
Given there are two entry sets in the institution_data table (created by cron
run each Monday) on these dates ('ctime') and the reporting time period is set
to be between 14th March - 23rd April, 2022, in this case we only get data from
the 18th April (despite the paginator counting 2 results):
2022-04-04 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
AND
2022-04-11 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
However, for the same reporting period, we get BOTH results when the entries
in the table are the following:
2022-03-21 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
And..
2022-03-28 14:22:57 (Monday)
2022-04-18 14:22:57 (Monday)
The theory is that it's something to do with Daylight Savings time,
which comes into effect on 2nd of April. Specifically, line 2450 in
htdocs/lib/statistics.php, where the $from date is incremented by a
week with $from = $from + (7 * 24 * 60 * 60) to set the $daterange
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1969872/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
