[Feature]Admin/brugere: Export af liste over admins for de forskellige foreninger og afdelinger

[mhewel]

Overordnet beskrivelse af funktionen

Under admin > brugere : Mulighed for at exportere en CSV fil med oversigt over admins for de forskellige foreninger/afdelinger, incl "last_login" for hver bruger.
Der skal kun vises for foreninger / afdelinger der ikke er lukket.

[mhewel]

Flg SQL burde være OK:

SELECT u.name AS Forening, ' ' AS Afdeling, au.username, TO_CHAR(au.last_login, 'YYYY-MM-DD') AS latslogin
FROM members_union AS u,
  members_adminuserinformation_unions AS mau,
  members_adminuserinformation AS ma,
  auth_user AS au
WHERE u.closed_at IS NULL
  AND mau.union_id = u.id
  AND mau.adminuserinformation_id = ma.id 
  AND au.id = ma.user_id
  AND au.is_superuser = false
UNION
SELECT u.name AS Forening, d.name AS Afdeling, au.username, TO_CHAR(au.last_login, 'YYYY-MM-DD') AS latslogin
FROM members_department AS d,
  members_union AS u,
  members_adminuserinformation_unions AS mau,
  members_adminuserinformation AS ma,
  auth_user AS au
WHERE d.closed_dtm IS NULL 
  AND u.id = d.union_id
  AND u.closed_at IS NULL
  AND mau.union_id = u.id
  AND mau.adminuserinformation_id = ma.id 
  AND au.id = ma.user_id
  AND au.is_superuser = false
ORDER by forening, afdeling

[lakridserne]

Ville være fedt hvis man kan sortere på hhv. brugere og foreninger. Husk også, at det ikke er alle der er både admin for en forening og afdeling.