Commits · 14cfe3f28f01805c48974d27838a5052412d52cf · AlekSIS® / Official / AlekSIS-App-Alsijil

Mar 18, 2021

Optimize query in generate_person_list_with_class_register_statistics · 8451aa07

Jonathan Weth authored 4 years ago

- 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

Verified

8451aa07

Feb 28, 2021
- Add missing distinct to extra mark and custom excuse aggregations · 9dd38abe
  Jonathan Weth authored 4 years ago
  
  Verified
  
  9dd38abe
Feb 24, 2021
- Add some explanatory comments · 723361a3
  Jonathan Weth authored 4 years ago
  
  Verified
  
  723361a3
- Filter for absences in get_absences_simple · 852b6e63
  Jonathan Weth authored 4 years ago
  
  Verified
  
  852b6e63
- [Events/extra lessons] Improve variable naming and fix typos · fc34915d
  Jonathan Weth authored 4 years ago
  
  Verified
  
  fc34915d
- [Events/extra lessons] Rewrite if-elif-else-clauses · 7dd1c6b8
  Jonathan Weth authored 4 years ago
  
  Verified
  
  7dd1c6b8
Feb 16, 2021
- Fix type hints and add missing docstrings · bfed8756
  Jonathan Weth authored 4 years ago
  
  Verified
  
  bfed8756
Feb 13, 2021
- Add support for events and extra lessons in statistic views · b0572970
  Jonathan Weth authored 4 years ago
  
  Verified
  
  b0572970
Feb 09, 2021
- Support events and extra lessons in "lesson view" · 8c7320c1
  Jonathan Weth authored 4 years ago
  
  Needed some extra/rewritten API
  Verified
  
  8c7320c1
Jan 22, 2021
- Remove global requests everywhere · b79e2401
  Nik | Klampfradler authored 4 years ago
  
  Verified
  
  b79e2401
Jan 20, 2021
- Add distinct filter to persons query in annoted persons list · 3651c764
  Jonathan Weth authored 4 years ago
  
  Verified
  
  3651c764
Jan 19, 2021
- Eliminate one DB query in full_register_group · 24245204
  Nik | Klampfradler authored 4 years ago
  
  The `or` operator puts the QuerySet into boolean context, which triggers evaluation.
  Verified
  
  24245204
Jan 17, 2021
- Add missing method extensions for events and extra lessons · 9a6a316b
  Jonathan Weth authored 4 years ago
  
  Verified
  
  9a6a316b
Jan 13, 2021
- Add class register model extensions to Event and ExtraLesson models · 8210047e
  Jonathan Weth authored 4 years ago
  
  Verified
  
  8210047e
Nov 22, 2020
- Add confirmation page for register absence form · 57dbd3db
  Jonathan Weth authored 4 years ago
  
  Verified
  
  57dbd3db
Nov 21, 2020
- Set user in revisions to allow further tracking · 9b01a5bb
  Jonathan Weth authored 4 years ago
  
  Verified
  
  9b01a5bb
Nov 17, 2020
- Reformat according to black line length of 100 · 193e1d0e
  Jonathan Weth authored 4 years ago
  
  Verified
  
  193e1d0e
- Solve lint issues and reactivate lint CI job · 566a5254
  Jonathan Weth authored 4 years ago
  
  Verified
  
  566a5254
Nov 13, 2020
- Fix filtering of personal notes in generate_person_list_with_class_register_statistics · da6360fe
  Jonathan Weth authored 4 years ago
  
  Verified
  
  da6360fe
Oct 30, 2020
- Implement detailed students list and include it on several positions · 75e57468
  Jonathan Weth authored 4 years ago
  
  - My groups - My students - Links in week view
  Verified
  
  75e57468
Oct 27, 2020
- Fix typo · 48521964
  Jonathan Weth authored 4 years ago
  
  Verified
  
  48521964
- Use filter in favour of for loops · 29b5aa3a
  Jonathan Weth authored 4 years ago
  
  Verified
  
  29b5aa3a
- Remove legacy caching methods · 8e6c9320
  Jonathan Weth authored 4 years ago
  
  Verified
  
  8e6c9320
Oct 15, 2020
- Fix problems with update_or_create and prefetching · ee72ebc2
  Jonathan Weth authored 4 years ago
  
  Verified
  
  ee72ebc2
Sep 24, 2020
- Show also groups which have child groups with lessons in my groups and select form · df893f6f
  Jonathan Weth authored 4 years ago
  
  In order to do that, refactor the queries to model extensions
  Verified
  
  df893f6f
Sep 10, 2020
- Reformat · 3b8503d8
  Jonathan Weth authored 4 years ago
  
  Verified
  
  3b8503d8
- Optimize model extensions · cbe2050b
  Jonathan Weth authored 4 years ago
  
  Verified
  
  cbe2050b
Sep 07, 2020
- Fix typo · a7727a68
  Jonathan Weth authored 4 years ago
  
  Verified
  
  a7727a68
- Use select_related and prefetch_related everywhere and optimize query count · 6c29d76d
  Jonathan Weth authored 4 years ago
  
  Verified
  
  6c29d76d
Aug 30, 2020
- Reformat · e4189166
  Jonathan Weth authored 4 years ago
  
  Verified
  
  e4189166
Aug 28, 2020
- Apply 1 suggestion(s) to 1 file(s) · 147b4304
  Nik | Klampfradler authored 4 years ago
  
  147b4304
Aug 27, 2020
- Create revisions for personal notes · fbab2b33
  Jonathan Weth authored 4 years ago
  
  Verified
  
  fbab2b33
Aug 18, 2020
- Add several small bug fixes · cbd4e140
  Jonathan Weth authored 4 years ago
  
  Verified
  
  cbd4e140
- Fix and improve register absence form to work with excuse types and a to-period. · 8ace7eca
  Jonathan Weth authored 4 years ago
  
  Verified
  
  8ace7eca
Aug 15, 2020
- Save not only week, but year for week-related stuff · 5739d43b
  Jonathan Weth authored 4 years ago
  
  Verified
  
  5739d43b
Aug 13, 2020
- Do not create personal notes for cancelled lesson periods in mark_absent · 303617e9
  Jonathan Weth authored 4 years ago
  
  Verified
  
  303617e9
Aug 11, 2020
- Save groups a person is member of when personal notes are created · 65ffbc22
  Jonathan Weth authored 4 years ago
  
  Fix #89 to fully work
  Verified
  
  65ffbc22
Aug 03, 2020
- Reformat · 780fd921
  Jonathan Weth authored 4 years ago
  
  Verified
  
  780fd921
Jul 14, 2020
- [Lesson overview] Show extra marks of previous lesson · 49718f69
  Jonathan Weth authored 4 years ago
  
  Verified
  
  49718f69
Jul 11, 2020
- Add excuse_type to personal note form · 483ffee6
  Jonathan Weth authored 4 years ago
  
  Verified
  
  483ffee6