['select', $kommissionen], 'call' => ['', $calls] ]; $editable = [ 'call', 'Kommission' ]; $entrytable = 'commissioners'; $bottom = << Ausgewählte endgültig löschen neuen Kommissionsmitgliedeintrag anlegen EOD; $alwaysbottom = true; $pdf_sql = $email_sql = " SELECT CONCAT(commissioners.ID, 'commissioner', '-', Personen.ID, 'person') AS uid, Personen.ID AS PersID, Personen.*, `call` AS `call`, Kommissionen.Darstellungsname AS Kommission, Kommissionen.`Webinterface Link` AS Link, Kommissionen.`LinkLeistungsueberpruefung` AS LUeLink, `call` AS `CallText`, Kommissionen.Benutzername AS Shorthand FROM commissioners LEFT JOIN Personen ON commissioners.Person = Personen.ID LEFT JOIN Kommissionen ON commissioners.Kommission = Kommissionen.ID WHERE commissioners.ID IN "; $independent_payload_sql = "SELECT Stipendien.*, Personen.*, leistung.commission FROM Stipendien INNER JOIN leistung ON Stipendien.mpulsid = leistung.uid INNER JOIN Personen ON Stipendien.Person = Personen.ID WHERE Stipendien.Jahr = 2022 AND Stipendien.Förderart=7 AND Stipendien.Förderbeginn >= '2022-10-01'"; $payload_sql = " SELECT eventid, persid, token FROM event_participants WHERE eventid=647 AND '999999999' NOT IN "; $independent_payload_sql = " SELECT Stipendien.*, Personen.*, ds.kommission AS komm_ds, ds.bewertung, ds.foerderlimit, ds.rang, leistung.commission AS komm_leistung, social.commission AS komm_sozial FROM Stipendien LEFT JOIN ds ON Stipendien.mpulsid = ds.uid LEFT JOIN leistung ON Stipendien.mpulsid = leistung.uid LEFT JOIN social ON Stipendien.mpulsid = social.commission INNER JOIN Personen ON Stipendien.Person = Personen.ID WHERE Stipendien.Jahr = 2023 AND Stipendien.Förderbeginn >= '2023-10-01' "; $checkboxes = true; include __DIR__ . '/autotable.php'; include __DIR__ . '/autoactions.php'; include __DIR__ . '/autoemail.php'; include __DIR__ . '/autopdf.php'; include __DIR__ . '/autoevent.php'; })(); ?>