Improved support of active schools

[TheSlimvReal]

see issue: #694
This approach builds a complex view where children/schools and their connected relations can be loaded with a single request. This improves the query performance significantly as the current solution was making a request for each child.

Also I added support for multiple active schools in children list.

Visible/Frontend Changes

• All schools and school classes are visible instantly on children list
• All active schools can be shown in children list (MIGRATION REQUIRED)
• School filter works for multiple active schools of a child in children list
• (?) All active schools are schon in ChildBlockComponent
• (?) All classes of the active schools are shown

Architectural/Backend Changes

• Single index for child - school link that loads all required data in one request

[github-actions]

Deployed to https://pr-1754.aam-digital.net/

[sleidig]

Definitely seems much cleaner and clearer with the promises and other changes 👍

This pops up in my console (not sure whether/how it is related):

Functional seems to work well in in-memory as well as local mode.

[sonarqubecloud]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
1 Code Smell

No Coverage information
0.0% Duplication

[aam-digital-ci]

🎉 This PR is included in version 3.19.0 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀