diff options
Diffstat (limited to 'commissioners.php')
| -rw-r--r-- | commissioners.php | 161 |
1 files changed, 161 insertions, 0 deletions
diff --git a/commissioners.php b/commissioners.php new file mode 100644 index 0000000..ac389ca --- /dev/null +++ b/commissioners.php @@ -0,0 +1,161 @@ +<?php +/* + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + */ +?> +<?php +/* vim: set ts=4 sw=4 et : */ + +$_title = "Kommissionsmitglieder: mit Zuordnung"; + +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, $kommissionen_sozial, $calls) { + $sql = " +SELECT + commissioners.ID, + Personen.ID AS PersID, + Personen.Nachname, + Personen.Vorname, + Personen.Email, + `call` AS `call`, + Kommissionen.ID AS Kommission, + `call` AS `CallText`, + Kommissionen.Benutzername AS Shorthand, + Personen.Anrede, + Personen.Ansprache, + Personen.`informale Ansprache`, + Personen.Titel, + Personen.Straße, + Personen.Adresszusatz, + Personen.PLZ, + Personen.Ort + +FROM commissioners + +LEFT JOIN Personen ON commissioners.Person = Personen.ID +LEFT JOIN Kommissionen ON commissioners.Kommission = Kommissionen.ID + +"; + $id = "commissioners_new"; + $getthdef = true; + $order = '[[1, "desc"]]'; + $types = [ + 'Kommission' => ['select', $kommissionen], + 'call' => ['', $calls] + ]; + $editable = [ + 'call', + 'Kommission' + ]; + $entrytable = 'commissioners'; + + $bottom = <<<EOD +<div class="admin_actionsbelow"> + Ausgewählte + <button class="medium" style="background: darkorange;" onclick="return delEntry();"><i class="far fa-trash-alt"></i> endgültig löschen</button> +</div> + +<button class="medium" onclick="return addEntry();"><i class="fas fa-user-tie"></i> neuen Kommissionsmitgliedeintrag anlegen</button> +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'; +})(); +?> + +<script> +<? minStart(); ?> +function delEntry() { + $.ajaxSetup({async:false}); + $.ajax({ + type: 'POST', + url: '/db/main/delcomm.php', + data: { + 'ids': getIDs_commissioners_new() + } + }); + $.ajaxSetup({async:true}); + location.href = location.href; +} + +function addEntry() { + promptPerson('', function (pid) { + if (!pid) return; + $.ajaxSetup({async:false}); + $.ajax({ + type: 'POST', + url: '/db/main/addcomm.php', + data: { + 'persid': pid + } + }); + $.ajaxSetup({async:true}); + location.href = location.href; + }); +} +<? minEnd(); ?> +</script> + +<? +include_once __DIR__ . "/footer.php"; |