Compare commits

...

3 Commits

2 changed files with 26 additions and 3 deletions
+6 -3
View File
@@ -424,12 +424,15 @@ class Person_model extends DB_Model
public function loadAllStudentUIDSForPersonID($person_id) {
$qry = "SELECT
CONCAT(tp.vorname, ' ', tp.nachname) AS name,
ARRAY_AGG(DISTINCT b.uid ORDER BY b.uid) AS uids
ARRAY_AGG(DISTINCT b.uid ORDER BY b.uid) AS uids,
ARRAY_AGG(DISTINCT CONCAT(stg.typ, stg.kurzbz)) AS stg_oes,
s.semester
FROM public.tbl_student s
JOIN public.tbl_benutzer b ON s.student_uid = b.uid
JOIN public.tbl_person tp ON b.person_id = tp.person_id
GROUP BY tp.vorname, tp.nachname, b.aktiv, b.person_id
HAVING b.person_id = ? AND b.aktiv IS TRUE;";
JOIN public.tbl_studiengang stg ON s.studiengang_kz = stg.studiengang_kz
GROUP BY tp.vorname, tp.nachname, b.aktiv, b.person_id, s.semester
HAVING b.person_id = ? AND b.aktiv IS TRUE";
return $this->execReadOnlyQuery($qry, [$person_id]);
}
+20
View File
@@ -35089,6 +35089,26 @@ array(
)
)
),
array(
'app' => 'anwesenheiten',
'category' => 'global',
'phrase' => 'oldEntsWithoutDocumentFound',
'insertvon' => 'system',
'phrases' => array(
array(
'sprache' => 'German',
'text' => 'Alte Entschuldigungen ohne Dateiupload gefunden',
'description' => '',
'insertvon' => 'system'
),
array(
'sprache' => 'English',
'text' => 'Old excuse notes without file upload detected',
'description' => '',
'insertvon' => 'system'
)
)
),
//
// DIGITALE ANWESENHEITEN PHRASEN END
//