#1004 The report shows too many records

[D L]

The report /intranet-timesheet2/weekly_report? shows in the "contract" section:
Shows a summary of the loged hours by all team members of a project (1 week).
Only those users are shown that:

- Have the permission to add hours or
- Have the permission to add absences AND
have at least some absences logged

We found out that as soon as a user has absences logged (even in the past), it will remain on the report, even after the permission to add absences was revoked.

Repro steps:

• Create a user as an Employee;
• Add an absences some months in the past;
• Remove the user from all groups;
  !!! The user will still appear in /intranet-timesheet2/weekly_report? with no hour reported.
• Delete the absence for the user (directly in the table im_user_absences);
  !!! Now the report doesn't show the employee anymore.

This report is used to ensure that everyone has booked their timesheet and wrongly shows employees that are not part of the organization anymore.

[Frank Bergmann]

Please specify the version of ]po[ you are running.

Bests
Frank

[Anonymous]

[Anonymous]

[D L]

Version 5.0.3

[D L]

Proposed a fix:
https://gitlab.project-open.net/project-open/intranet-timesheet2/merge_requests/1