Merge branch 'main' into issue-3911issue-3911

1 files changed, 153 insertions, 0 deletions

diff --git a/lib/raumzeit/IssueDB.php b/lib/raumzeit/IssueDB.php
new file mode 100644
index 0000000..17d8b95
--- /dev/null
+++ b/lib/raumzeit/IssueDB.php
@@ -0,0 +1,153 @@
+<?
+# Lifter002: TODO
+# Lifter003: TEST
+# Lifter007: TODO
+# Lifter010: TODO
+// +--------------------------------------------------------------------------+
+// This file is part of Stud.IP
+// IssueDB.php
+//
+// Datenbank-Abfragen für Issue.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 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.
+// You should have received a copy of the GNU General Public License
+// along with this program; if not, write to the Free Software
+// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+// +--------------------------------------------------------------------------+
+
+
+/**
+ * IssueDB.php
+ *
+ *
+ * @author      Till Glöggler <tgloeggl@uos.de>
+ * @version     19. Oktober 2005
+ * @access      protected
+ * @package     raumzeit
+ * @deprecated
+ */
+
+class IssueDB
+{
+    public static function restoreIssue($issue_id)
+    {
+        $query = "SELECT *
+                  FROM themen
+                  WHERE issue_id = ?";
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([$issue_id]);
+        return $statement->fetch(PDO::FETCH_ASSOC);
+    }
+
+    public static function storeIssue(&$issue)
+    {
+        if ($issue->new) {
+            $query = "INSERT INTO themen
+                        (issue_id, seminar_id, author_id, title, description, mkdate, chdate, priority)
+                      VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
+            $statement = DBManager::get()->prepare($query);
+            $statement->execute([
+                $issue->issue_id,
+                $issue->seminar_id,
+                $issue->author_id,
+                $issue->title,
+                $issue->description,
+                $issue->mkdate,
+                $issue->chdate,
+                $issue->priority
+            ]);
+        } else {
+            $query = "UPDATE themen
+                      SET seminar_id = ?, author_id = ?, title = ?, description = ?, mkdate = ?, priority = ?
+                      WHERE issue_id = ?";
+            $statement = DBManager::get()->prepare($query);
+            $statement->execute([
+                $issue->seminar_id,
+                $issue->author_id,
+                $issue->title,
+                $issue->description,
+                $issue->mkdate,
+                $issue->priority,
+                $issue->issue_id
+            ]);
+
+            if ($statement->rowCount()) {
+                $query = "UPDATE themen SET chdate = UNIX_TIMESTAMP() WHERE issue_id = ?";
+                $statement = DBManager::get()->prepare($query);
+                $statement->execute([$issue->issue_id]);
+
+                $query = "SELECT termin_id FROM themen_termine WHERE issue_id = ?";
+                $statement = DBManager::get()->prepare($query);
+                $statement->execute([$issue->issue_id]);
+                $termin_ids = $statement->fetchAll(PDO::FETCH_COLUMN);
+
+                if (count($termin_ids) > 0) {
+                    $query = "UPDATE termine SET chdate = UNIX_TIMESTAMP() WHERE termin_id IN (?)";
+                    $statement = DBManager::get()->prepare($query);
+                    $statement->execute([$termin_ids]);
+                }
+            }
+
+        }
+        return TRUE;
+    }
+
+    public static function deleteIssue($issue_id)
+    {
+        $query = "DELETE FROM themen WHERE issue_id = ?";
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([$issue_id]);
+
+        $query = "DELETE FROM themen_termine WHERE issue_id = ?";
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([$issue_id]);
+    }
+
+    public static function isIssue($issue_id)
+    {
+        $query = "SELECT 1 FROM themen WHERE issue_id = ?";
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([$issue_id]);
+        return (bool)$statement->fetchColumn();
+    }
+
+    public static function getDatesforIssue($issue_id)
+    {
+        $query = "SELECT termine.*
+                  FROM themen_termine
+                  INNER JOIN termine USING (termin_id)
+                  WHERE issue_id = ?
+                  ORDER BY `date` ASC";
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([$issue_id]);
+
+        $ret = [];
+        while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
+            $ret[$row['termin_id']] = $row;
+        }
+        return $ret;
+    }
+
+    public static function deleteAllIssues($course_id)
+    {
+        $query = "SELECT issue_id FROM themen WHERE seminar_id = ?";
+        $statement = DBManager::get()->prepare($query);
+        $statement->execute([$course_id]);
+        $themen = $statement->fetchAll(PDO::FETCH_COLUMN);
+
+        foreach ($themen as $issue_id) {
+            self::deleteIssue($issue_id, $course_id);
+        }
+
+        return count($themen);
+    }
+}