Inform role manager about expiration of users with the roles they are responsible for

[MarliesRikken]

New Feature Request

Summary

Problem:
Rolemanagers don't know when the users of their roles are expiring. Only users themselves get a notification.

Value:
Help role managers extend the role for users that still need it.

Proposed Solution

Ideas:

• notification per user
• monthly report
• Give role manager choice in which notification type they want?

Uitwerking

• Action: Describe the logic or flow change.
• Design: [Link to Figma/Screenshots]
• Impact: Does this affect existing APIs or UI components?

Developer Checklist

To be completed by the developer during implementation.

• Add required changes and feature flags config files
• Create and document database changes and migrations
• Create and document API changes and migrations
• check for backwards compatibility
• Updated CHANGELOG and other documentation where needed

Testing and QA

Describe how to verify and test this change.

Test Environment and Setup

1. Point to [URL/Branch]
2. Use account with [Role/Permissions]

Test Checklist

• Happy Path: Feature works as intended under normal conditions.
• Edge Case: [Describe specific test item]
• Validation: [Describe specific test item]
• UI/UX: Verified layout across screen sizes.

Extra Information

Add any other context, related issues, or technical notes here.

[MarliesRikken]

Related discussion: https://surf-net.slack.com/archives/C03A6DUQ0KA/p1779202890836279