stipcrmHEADmain

1 files changed, 64 insertions, 0 deletions

diff --git a/searchorga.php b/searchorga.php
new file mode 100644
index 0000000..6ca70db
--- /dev/null
+++ b/searchorga.php
@@ -0,0 +1,64 @@
+<?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 : */
+
+$_search = $_GET['search'];
+$_title = "Organisationssuche: " . $_search;
+
+require_once __DIR__ . "/check_auth.php";
+require_once __DIR__ . "/../includes/common.php";
+include_once __DIR__ . "/header.php";
+?>
+
+<h1><?=$_title?></h1>
+
+<p>Es wird gesucht in: Name, ID.</p>
+
+<?
+(function () use ($mysqli, $_search) {
+    $sql = "
+SELECT
+    Organisationen.ID AS OrgaID, Organisationen.Name, Förderer.ID AS FoerdID, Superorga.ID AS SuperOrgaID, Superorga.Name AS Superorganisation
+FROM Organisationen
+LEFT JOIN Förderer ON Organisationen.ID = Förderer.Organisation
+LEFT JOIN Organisationen AS Superorga ON Organisationen.Superorganisation = Superorga.ID
+WHERE
+    Organisationen.Name LIKE ?
+    OR Organisationen.ID = ?
+";
+    $s = '%' . $_search . '%';
+    $stmt = $mysqli->prepare($sql);
+    $stmt->bind_param('si', $s, $_search);
+    $stmt->execute();
+    $r = $stmt->get_result();
+    if ($r->num_rows === 1 && !isset($_GET['action'])) {
+        $l = $r->fetch_object();
+        $stmt->reset();
+        $mysqli->close();
+?>
+        <script>
+            window.location = '/db/orga/<?=$l->OrgaID?>';
+        </script>
+<?
+        exit(0);
+    }
+    $id = "orgasearch2";
+    $order = '[[1, "asc"]]';
+    include __DIR__ . '/autotable.php';
+    $stmt->reset();
+})();
+
+include_once __DIR__ . "/footer.php";
+?>