mahara-contributors team mailing list archive

[Kristina Hoeppner <1969872@xxxxxxxxxxxxxxxxxx>]

What are possible solutions?

** Changed in: mahara
       Status: New => Incomplete

** Changed in: mahara
    Milestone: None => 22.10.0

-- 
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:
  Incomplete

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