Resolve "[SQL] Query for person statistics in week overview takes very long"

Closes #149

See merge request !164

Translations update from Weblate

See merge request !160

Jonathan Weth authored 4 years ago and Jonathan Weth committed 4 years ago

Currently translated at 100.0% (250 of 250 strings)

Translation: AlekSIS/AlekSIS-App-Alsijil
Translate-URL: https://translate.edugit.org/projects/aleksis/aleksis-app-alsijil/de/

Resolve "[SQL] Person statistics in "My students" take very long"

Closes #150

See merge request !162

- Move filter conditions into JOIN clause
- Remove superflouos subquery for tardiness
- Remove unnecessary JOINs
  - Remove need for DISTINCT by fixing double JOIN on personal notes

Currently translated at 100.0% (250 of 250 strings)

Translation: AlekSIS/AlekSIS-App-Alsijil
Translate-URL: https://translate.edugit.org/projects/aleksis/aleksis-app-alsijil/de/

Update translation files

See merge request !161

Overview of all register objects

Closes #137

See merge request !152

Fix rules syntax

See merge request !159

Resolve "Fix usage of user.has_perm with object permissions"

Closes #143

See merge request !157

Merge branch '147-check-permission-rules-if-they-handle-lessons-with-substitutions-correctly' into 'master'

Resolve "Check permission rules if they handle lessons with substitutions correctly"

Closes #147

See merge request !158

Update ci config

See merge request !156