(neues Datenmodell)"; require_once __DIR__ . "/check_auth.php"; require_once __DIR__ . "/../includes/common.php"; include_once __DIR__ . "/header.php"; require_once __DIR__ . "/lookup.php"; doTitle(); (function () use ($kommissionen, $calls) { $sql = " SELECT DISTINCT Personen.ID AS PersID, Personen.Nachname, Personen.Vorname, Personen.Email, Personen.Straße, Personen.Adresszusatz, Personen.PLZ, Personen.Ort, GROUP_CONCAT(Hochschulen.KanonischerName SEPARATOR ', ') AS `Hochschule(n)`, GROUP_CONCAT(Kommissionen.Darstellungsname SEPARATOR ', ') AS `Kommission(en) Name`, GROUP_CONCAT(commissioners.`call` SEPARATOR ', ') AS `Calls`, Personen.Anrede, Personen.Ansprache, Personen.`informale Ansprache`, Personen.Titel FROM commissioners LEFT JOIN Personen ON commissioners.Person = Personen.ID LEFT JOIN Kommissionen ON commissioners.Kommission = Kommissionen.ID LEFT JOIN Hochschulen ON Kommissionen.Hochschule = Hochschulen.ID GROUP BY Personen.ID "; $id = "commissioners_new3"; $getthdef = true; $order = '[[1, "desc"]]'; $entrytable = 'Personen'; $idcell = "PersID"; $idcellreal = "ID"; $editable = ['Nachname', 'Vorname', 'Email', 'Straße', 'Adresszusatz', 'PLZ', 'Ort', 'Anrede', 'Ansprache', 'informale Ansprache', 'Titel']; $email_sql = " SELECT DISTINCT CONCAT(Personen.ID, 'person') AS uid, Personen.*, Personen.Straße AS Strasse, Personen.ID AS PersID FROM Personen WHERE Personen.ID IN "; $ajax = false; $pdf_sql = $email_sql; $checkboxes = true; include __DIR__ . '/autotable.php'; include __DIR__ . '/autoactions.php'; include __DIR__ . '/autoemail.php'; include __DIR__ . '/autopdf.php'; include __DIR__ . '/autoevent.php'; })(); ?>