extent overview employee per room query
There is a new query uebersicht_mitarbeiter_pro_raum.sql to provide an overview about the employees in a specific house/room. Currently the result looks like follows:
| Haus | Raum | Flaeche | Genutzte_Flaeche | Sektion | Name | Titel | im_raum_seit | im_raum_bis | Rolle | Beanspruchter Platz für Rolle |
|---|---|---|---|---|---|---|---|---|---|---|
| A20 | 310 | 18 | 15 | 1.4 | Morstein | Account-Gast | 0 | |||
| A20 | 310 | 18 | 15 | 1.4 | Morstein | Student | 3 | |||
| A20 | 310 | 18 | 15 | 1.4 | Eggert | Dr. | Wissenschaftler/in | 12 |
The query shall be extended, so that all roles that can be added to that room are appended (maybe using the UNION operator), e.g.
| Haus | Raum | Flaeche | Genutzte_Flaeche | Sektion | Name | Titel | im_raum_seit | im_raum_bis | Rolle | Beanspruchter Platz für Rolle | Moegliche Anzahl |
|---|---|---|---|---|---|---|---|---|---|---|---|
| A20 | 310 | 18 | 15 | 1.4 | Morstein | Account-Gast | 0 | ||||
| A20 | 310 | 18 | 15 | 1.4 | Morstein | Student | 3 | ||||
| A20 | 310 | 18 | 15 | 1.4 | Eggert | Dr. | Wissenschaftler/in | 12 | |||
| A20 | 310 | 18 | 15 | Student | 3 | 1 | |||||
| A20 | 310 | 18 | 15 | wissenschaftliche Hilfskraft | 3 | 1 | |||||
| etc. |
In case a role doesn't fit in ('Moegliche Anzahl' < 1) it shall not be displayed. Roles that occupy zero space (Account-Gast, Arbeiter) can be excluded as well.