stipcrmHEADmain

1 files changed, 67 insertions, 0 deletions

diff --git a/searchpatron.php b/searchpatron.php
new file mode 100644
index 0000000..f760436
--- /dev/null
+++ b/searchpatron.php
@@ -0,0 +1,67 @@
+<?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 = "Förderersuche: " . $_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: Organisation, Zuständig, ID.</p>
+
+<?
+(function () use ($mysqli, $_search) {
+    $sql = "
+SELECT
+    Förderer.ID AS FoerdID, Organisationen.Name AS Organisation, Organisationen.ID AS OrgaID,
+    Personen.Nachname AS Zuständig,
+    DATE(Förderer.`Vertrag läuft aus`) AS `Vertrag läuft aus`
+FROM Förderer
+LEFT JOIN Organisationen ON Förderer.Organisation = Organisationen.ID
+LEFT JOIN Personen ON Förderer.Zuständig = Personen.ID
+WHERE
+    Organisationen.Name LIKE ?
+    OR Personen.Nachname LIKE ?
+    OR Förderer.ID = ?
+";
+    $s = '%' . $_search . '%';
+    $stmt = $mysqli->prepare($sql);
+    $stmt->bind_param('ssi', $s, $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/patron/<?=$l->FoerdID?>';
+        </script>
+<?
+        exit(0);
+    }
+    $id = "patronsearch2";
+    $order = '[[1, "asc"]]';
+    include __DIR__ . '/autotable.php';
+    $stmt->reset();
+})();
+
+include_once __DIR__ . "/footer.php";
+?>