1 files changed, 42 insertions, 0 deletions
diff --git a/orgas.php b/orgas.php
new file mode 100644
index 0000000..90829aa
--- /dev/null
+++ b/orgas.php
@@ -0,0 +1,42 @@
+<?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 = "Alle Organisationen";
+require_once __DIR__ . "/check_auth.php";
+include_once __DIR__ . "/header.php";
+require_once __DIR__ . "/../includes/common.php";
+?>
+
+<h1><?=$_title?></h1>
+
+<?php
+(function () use ($mysqli) {
+    $sql = "
+SELECT
+    Organisationen.ID AS OrgaID, Organisationen.Name, Organisationen.Ort,
+    Superorga.Name AS Superorganisation, Superorga.ID AS SuperOrgaID
+FROM Organisationen
+LEFT JOIN Organisationen AS Superorga ON Organisationen.Superorganisation = Superorga.ID
+";
+    $id = "orgas2";
+    $thdef = ['OrgaID', 'Name', 'Ort', 'SuperOrgaID', 'Superorganisation'];
+    $ajax = $nospinner = true;
+    $order = '[[1, "asc"]]';
+    include __DIR__ . '/autotable.php';
+})();
+
+include_once __DIR__ . "/footer.php";
+?>