From cdea8caa5617f0cb77bcbc9803759abd2df50644 Mon Sep 17 00:00:00 2001
From: Niklas Olmes <niklas@olmes.de>
Date: Fri, 24 Apr 2026 19:30:00 +0200
Subject: stipcrm

---
 commissioners.php | 161 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 161 insertions(+)
 create mode 100644 commissioners.php

(limited to 'commissioners.php')

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";
-- 
cgit v1.3.1