aboutsummaryrefslogtreecommitdiff
path: root/lib/raumzeit/SeminarDB.class.php
diff options
context:
space:
mode:
Diffstat (limited to 'lib/raumzeit/SeminarDB.class.php')
-rw-r--r--lib/raumzeit/SeminarDB.class.php264
1 files changed, 0 insertions, 264 deletions
diff --git a/lib/raumzeit/SeminarDB.class.php b/lib/raumzeit/SeminarDB.class.php
deleted file mode 100644
index 63241fe..0000000
--- a/lib/raumzeit/SeminarDB.class.php
+++ /dev/null
@@ -1,264 +0,0 @@
-<?php
-# Lifter002: DONE
-# Lifter003: TEST
-# Lifter007: TODO
-# Lifter010: DONE
-// +--------------------------------------------------------------------------+
-// This file is part of Stud.IP
-// SeminarDB.class.php
-//
-// Datenbank-Abfragen für Seminar.class.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.
-// +--------------------------------------------------------------------------+
-
-
-/**
- * SeminarDB.class.php
- *
- *
- * @author Till Glöggler <tgloeggl@uos.de>
- * @version 19. Oktober 2005
- * @access protected
- * @package raumzeit
- * @deprecated
- */
-
-class SeminarDB
-{
- public static function getIssues($seminar_id)
- {
- $query = "SELECT *
- FROM themen
- WHERE themen.seminar_id = ?
- ORDER BY priority";
- $statement = DBManager::get()->prepare($query);
- $statement->execute([$seminar_id]);
- return $statement->fetchAll(PDO::FETCH_ASSOC);
- }
-
- public static function getSingleDates($seminar_id, $start = 0, $end = 0)
- {
- $query = "SELECT termine.*, resource_bookings.resource_id, GROUP_CONCAT(DISTINCT trp.user_id) AS related_persons, GROUP_CONCAT(DISTINCT trg.statusgruppe_id) AS related_groups
- FROM termine
- LEFT JOIN termin_related_persons AS trp ON (termine.termin_id = trp.range_id)
- LEFT JOIN termin_related_groups AS trg ON (termine.termin_id = trg.termin_id)
- LEFT JOIN resource_bookings ON (resource_bookings.range_id = termine.termin_id)
- WHERE termine.range_id = ?
- AND (metadate_id IS NULL OR metadate_id = '')";
- $parameters = [$seminar_id];
-
- if ($start != 0 || $end != 0) {
- $query .= " AND termine.date BETWEEN ? AND ?";
- array_push($parameters, $start, $end);
- }
-
- $query .= " GROUP BY termine.termin_id ORDER BY date";
-
- $statement = DBManager::get()->prepare($query);
- $statement->execute($parameters);
-
- $ret = [];
- while ($data = $statement->fetch(PDO::FETCH_ASSOC)) {
- if ($data['related_persons']) {
- $data['related_persons'] = explode(',', $data['related_persons']);
- }
- if ($data['related_groups']) {
- $data['related_groups'] = explode(',', $data['related_groups']);
- }
-
- $ret[] = $data;
- }
-
- return $ret;
- }
-
- public static function getStatOfNotBookedRooms($cycle_id, $seminar_id, $filterStart = 0, $filterEnd = 0)
- {
- $stat = [
- 'all' => 0,
- 'booked' => 0,
- 'open' => 0,
- 'open_rooms' => [],
- 'declined' => 0,
- 'declined_dates' => [],
- ];
-
- $query = "SELECT termine.*, resource_bookings.resource_id
- FROM termine
- LEFT JOIN resource_bookings ON (resource_bookings.range_id = termin_id)
- WHERE termine.range_id = ? AND metadate_id = ?";
- $parameters = [$seminar_id, $cycle_id];
-
- if ($filterStart != 0 || $filterEnd != 0) {
- $query .= " AND date >= ? AND end_time <= ?";
- array_push($parameters, $filterStart, $filterEnd);
- }
- $query .= " ORDER BY date";
-
- $statement = DBManager::get()->prepare($query);
- $statement->execute($parameters);
-
- while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
- $stat['all'] += 1;
- if ($row['resource_id']) {
- $stat['booked'] += 1;
- } else {
- $stat['open'] += 1;
- $stat['open_rooms'][] = $row;
- }
- }
-
- // count how many singledates have a declined room-request
- $query = "SELECT *
- FROM termine t
- LEFT JOIN resource_requests AS rr ON (t.termin_id = rr.termin_id)
- WHERE range_id = ? AND t.metadate_id = ? AND closed = 3";
- $parameters = [$seminar_id, $cycle_id];
-
- if ($filterStart != 0 && $filterEnd != 0) {
- $query .= " AND date >= ? AND end_time <= ?";
- array_push($parameters, $filterStart, $filterEnd);
- }
- $query .= " ORDER BY date";
-
- $stmt = DBManager::get()->prepare($query);
- $stmt->execute($parameters);
-
- while ($data = $stmt->fetch(PDO::FETCH_ASSOC)) {
- $stat['declined'] += 1;
- $stat['declined_dates'][] = $data;
- }
-
- return $stat;
- }
-
- public static function hasDatesOutOfDuration($start, $end, $seminar_id)
- {
- $query = "SELECT COUNT(*)
- FROM termine
- WHERE range_id = ? AND `date` NOT BETWEEN ? AND ?";
- $statement = DBManager::get()->prepare($query);
- $statement->execute([$seminar_id, $start, $end]);
- return $statement->fetchColumn();
- }
-
- public static function getFirstDate($seminar_id)
- {
- $termine = [];
-
- $query = "SELECT termin_id, date, end_time
- FROM termine
- WHERE range_id = ?
- ORDER BY date";
- $statement = DBManager::get()->prepare($query);
- $statement->execute([$seminar_id]);
-
- $start = 0;
- $end = 0;
-
- while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
- if (($start == 0 && $end == 0) || ($start == $row['date'] && $end == $row['end_time'])) {
- $termine[] = $row['termin_id'];
- $start = $row['date'];
- $end = $row['end_time'];
- }
- }
-
- return $termine ?: false;
- }
-
- public static function getNextDate($seminar_id)
- {
- $termin = [];
-
- $query = "SELECT termin_id, date, end_time
- FROM termine
- WHERE range_id = ? AND date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 HOUR)
- ORDER BY date, end_time";
- $stmt = DBManager::get()->prepare($query);
- $stmt->execute([$seminar_id]);
-
- $start = 0;
- while ($data = $stmt->fetch(PDO::FETCH_ASSOC)) {
- if ($start == 0 || $start == $data['date']) {
- $termin[] = $data['termin_id'];
- $start = $data['date'];
- }
- }
-
- $ex_termin = [];
-
- $query = "SELECT termin_id
- FROM ex_termine
- WHERE range_id = ? AND date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 HOUR)
- AND content != '' AND content IS NOT NULL
- ORDER BY date
- LIMIT 1";
- $stmt = DBManager::get()->prepare($query);
- $stmt->execute([$seminar_id]);
-
- while ($termin_id = $stmt->fetchColumn()) {
- $ex_termin[] = $termin_id;
- }
-
- return compact('termin', 'ex_termin');
- }
-
-
- public static function getDeletedSingleDates($seminar_id, $start = 0, $end = 0)
- {
- if (($start != 0) || ($end != 0)) {
- $query = "SELECT ex_termine.*, GROUP_CONCAT(trp.user_id) AS related_persons, GROUP_CONCAT(DISTINCT trg.statusgruppe_id) AS related_groups
- FROM ex_termine
- LEFT JOIN termin_related_persons AS trp ON (ex_termine.termin_id = trp.range_id)
- LEFT JOIN termin_related_groups AS trg ON (ex_termine.termin_id = trg.termin_id)
- WHERE ex_termine.range_id = ?
- AND (metadate_id IS NULL OR metadate_id = '')
- AND `date` BETWEEN ? AND ?
- GROUP BY ex_termine.termin_id
- ORDER BY date";
- $parameters = [$seminar_id, $start, $end];
- } else {
- $query = "SELECT ex_termine.*, GROUP_CONCAT(trp.user_id) AS related_persons, GROUP_CONCAT(DISTINCT trg.statusgruppe_id) AS related_groups
- FROM ex_termine
- LEFT JOIN termin_related_persons AS trp ON (ex_termine.termin_id = trp.range_id)
- LEFT JOIN termin_related_groups AS trg ON (ex_termine.termin_id = trg.termin_id)
- WHERE ex_termine.range_id = ?
- AND (metadate_id IS NULL OR metadate_id = '')
- GROUP BY ex_termine.termin_id
- ORDER BY date";
- $parameters = [$seminar_id];
- }
- $statement = DBManager::get()->prepare($query);
- $statement->execute($parameters);
-
- $ret = [];
- while ($data = $statement->fetch(PDO::FETCH_ASSOC)) {
- $data['ex_termin'] = true;
-
- if ($data['related_persons']) {
- $data['related_persons'] = explode(',', $data['related_persons']);
- }
- if ($data['related_groups']) {
- $data['related_groups'] = explode(',', $data['related_groups']);
- }
-
- $ret[] = $data;
- }
- return $ret;
- }
-
-}
generated by cgit v1.0 at 2026-05-27 09:15:44 +0000