1 files changed, 113 insertions, 0 deletions
diff --git a/commissioners_person.php b/commissioners_person.php
new file mode 100644
index 0000000..2e49cb9
--- /dev/null
+++ b/commissioners_person.php
@@ -0,0 +1,113 @@
+<?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: nur Person <small>(neues Datenmodell)</small>";
+
+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';
+})();
+?>
+
+<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";
+?>