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

1 files changed, 0 insertions, 365 deletions

diff --git a/lib/evaluation/classes/db/EvaluationObjectDB.class.php b/lib/evaluation/classes/db/EvaluationObjectDB.class.php
deleted file mode 100644
index fd5728d..0000000
--- a/lib/evaluation/classes/db/EvaluationObjectDB.class.php
+++ /dev/null
@@ -1,365 +0,0 @@
-<?php
-# Lifter002: TODO
-# Lifter007: TODO
-# Lifter003: TODO
-# Lifter010: TODO
-// +--------------------------------------------------------------------------+
-// This file is part of Stud.IP
-// Copyright (C) 2001-2004 Stud.IP
-// +--------------------------------------------------------------------------+
-// 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.
-
-require_once 'lib/evaluation/evaluation.config.php';
-
-/**
- * Databaseclass for all evaluationobjects
- *
- * @author  Alexander Willner <mail@AlexanderWillner.de>
- *
- * @copyright   2004 Stud.IP-Project
- * @access      public
- * @package     evaluation
- *
- */
-class EvaluationObjectDB extends DatabaseObject
-{
-    /**
-     * Constructor
-     * @access   public
-     */
-    public function __construct()
-    {
-        parent::__construct();
-        $this->instanceof = 'EvalDBObject';
-    }
-
-    /**
-     * Gets the name of the range. Copied somewhere from Stud.IP...
-     * @access  public
-     * @param string $rangeID the rangeID
-     * @param boolean $html_decode (optional)
-     * @return  string                    The name of the range
-     */
-    public function getRangename($rangeID, $html_decode = true)
-    {
-        if ($rangeID == "studip") {
-            return _('Systemweite Evaluationen');
-        }
-        $o_type = get_object_type($rangeID, ['sem', 'user', 'inst']);
-        if (in_array($o_type, ['sem','inst','fak'])) {
-            $range = get_object_by_range_id($rangeID);
-            if ($range) {
-                $rangename = $range->getFullName('number-name-semester');
-            } else {
-                $rangename = _('Kein Titel gefunden.');
-            }
-            return $rangename;
-        }
-        if ($o_type != 'user') {
-            $user_id = get_userid($rangeID);
-        } else {
-            $user_id = $rangeID;
-        }
-
-        if ($user_id != $GLOBALS['user']->id) {
-            $rangename = _('Profil') . ': '
-                . get_fullname($user_id, 'full', true)
-                . ' (' . get_username($user_id) . ')';
-        } else {
-            $rangename = _('Profil');
-        }
-        return $rangename;
-    }
-
-    /**
-     * Gets the global Studi.IP perm
-     * @access  public
-     * @param boolean $as_value If YES return as value
-     * @return  string   the perm or NULL
-     */
-    public static function getGlobalPerm($as_value = false)
-    {
-        if ($GLOBALS['perm']->have_perm("root")) {
-            return $as_value ? 63 : "root";
-        } elseif ($GLOBALS['perm']->have_perm("admin")) {
-            return $as_value ? 31 : "admin";
-        } elseif ($GLOBALS['perm']->have_perm("dozent")) {
-            return $as_value ? 15 : "dozent";
-        } elseif ($GLOBALS['perm']->have_perm("tutor")) {
-            return $as_value ? 7 : "dozent";
-        } elseif ($GLOBALS['perm']->have_perm("autor")) {
-            return $as_value ? 3 : "autor";
-        } elseif ($GLOBALS['perm']->have_perm("user")) {
-            return $as_value ? 1 : "user";
-        } else {
-            return $as_value ? 0 : NULL;
-        }
-    }
-
-    /**
-     * Get the Stud.IP-Perm for a range
-     * @param string $rangeID The range id
-     * @param string $userID The user id
-     * @param boolean $as_value If YES return as value
-     * @access   public
-     * @return   string
-     */
-    public static function getRangePerm($rangeID, $userID = NULL, $as_value = false)
-    {
-        if (!$rangeID) {
-            print "no rangeID!<br>";
-            return NULL;
-        }
-        $userID = ($userID) ? $userID : $GLOBALS['user']->id;
-        $range_perm = $GLOBALS['perm']->get_studip_perm($rangeID, $userID);
-
-        if ($rangeID == $userID) {
-            return ($as_value) ? 63 : "root";
-        }
-
-        if (($rangeID == "studip") && ($GLOBALS['perm']->have_perm("root"))) {
-            return ($as_value) ? 63 : "root";
-        }
-
-        switch ($range_perm) {
-            case "root":
-                return ($as_value) ? 63 : "root";
-            case "admin":
-                return ($as_value) ? 31 : "admin";
-            case "dozent":
-                return ($as_value) ? 15 : "dozent";
-            case "tutor":
-                return ($as_value) ? 7 : "dozent";
-            case "autor":
-                return ($as_value) ? 3 : "autor";
-            case "user":
-                return ($as_value) ? 1 : "user";
-            default:
-                return 0;
-        }
-
-    }
-
-    /**
-     * Look for all rangeIDs for my permissions
-     * @param object  Perm &$permObj  PHP-LIB-Perm-Object
-     * @param object  User &$userObj  PHP-LIB-User-Object
-     * @param string $rangeID RangeID of actual page
-     */
-    public function getValidRangeIDs(&$permObj, &$userObj, $rangeID)
-    {
-        $range_ids = [];
-        $username = $userObj->username;
-
-        $range_ids += [
-            $username => ["name" => _("Profil")]
-        ];
-
-        if ($permObj->have_perm("root")) {
-            $range_ids += ["studip" => ["name" => _("Stud.IP-System")]];
-            if (($adminRange = $this->getRangename($rangeID)) &&
-                $rangeID != $userObj->id)
-                $range_ids += [$rangeID => ["name" =>
-                    $adminRange]];
-        } else if ($permObj->have_perm("admin")) {
-            if (($adminRange = $this->getRangename($rangeID)) &&
-                $rangeID != $userObj->id) {
-                $range_ids += [$rangeID => ["name" =>
-                    $adminRange]];
-            }
-        } else if ($permObj->have_perm("dozent") || $permObj->have_perm("tutor")) {
-            if ($ranges = search_range("")) {
-                $range_ids += $ranges;
-            }
-        }
-        return $range_ids;
-    }
-
-    /**
-     * Returns the number of ranges with no permission
-     * @access   public
-     * @param EvaluationObject   &$eval The evaluation
-     * @param boolean $return_ids If YES return the ids
-     * @return array|integer Number of ranges with no permission or array of ids
-     */
-    public static function getEvalUserRangesWithNoPermission(&$eval, $return_ids = false)
-    {
-        $no_permisson = 0;
-        $rangeIDs = $eval->getRangeIDs();
-        $no_permisson_ranges = [];
-        if (!is_array($rangeIDs)) {
-            $rangeIDs = [$rangeIDs];
-        }
-
-        foreach ($eval->getRangeIDs() as $rangeID) {
-            $user_perm = EvaluationObjectDB::getRangePerm($rangeID, $GLOBALS['user']->id, YES);
-            // every range with a lower perm than Tutor
-            if ($user_perm < 7) {
-                $no_permisson++;
-                $no_permisson_ranges[] = $rangeID;
-            }
-        }
-        if ($return_ids == YES) {
-            return $no_permisson_ranges;
-        }
-        return ($no_permisson > 0) ? $no_permisson : NO;
-    }
-
-    /**
-     * Gets the public template ids
-     * @access   public
-     * @param string $searchString The name of the template
-     * @return   array    The public template ids
-     */
-    public function getPublicTemplateIDs($searchString)
-    {
-        $sql = "
-            SELECT eval_id FROM eval
-            LEFT JOIN auth_user_md5 ON user_id = author_id
-            WHERE shared = 1
-              AND author_id <> :current_user
-              AND (title LIKE :search_string
-                   OR text LIKE :search_string
-                   OR Vorname LIKE :search_string
-                   OR Nachname LIKE :search_string
-                   OR username LIKE :search_string
-                  )
-            ORDER BY title";
-
-        return DBManager::get()->fetchFirst(
-            $sql, [':current_user' => $GLOBALS['user']->id, ':search_string' => '%' . $searchString . '%']
-        );
-    }
-
-    /**
-     * Return all evaluationIDs in a specific range
-     *
-     * @access  public
-     * @param string $rangeID Specific rangeID or it is a template
-     * @param string $state Specific state
-     * @return  array   All evaluations in this range and this state
-     */
-    public function getEvaluationIDs($rangeID = "", $state = "")
-    {
-        if (!empty ($rangeID) && !is_scalar($rangeID)) {
-            return $this->throwError(1, _("Übergebene RangeID ist ungültig."));
-        }
-        if ($state != "" &&
-            $state != EVAL_STATE_NEW &&
-            $state != EVAL_STATE_ACTIVE &&
-            $state != EVAL_STATE_STOPPED) {
-            return $this->throwError(2, _("Übergebener Status ist ungültig."));
-        }
-
-        if (get_userid($rangeID) != NULL && $rangeID != NULL) {
-            $rangeID = get_userid($rangeID);
-        }
-
-        if (!empty ($rangeID)) {
-            $sql =
-                "SELECT" .
-                " a.eval_id " .
-                "FROM" .
-                " eval_range a, eval b " .
-                "WHERE" .
-                " a.eval_id = b.eval_id" .
-                " AND " .
-                " a.range_id = ?";
-            $param = $rangeID;
-        } else {
-            $sql =
-                "SELECT" .
-                " b.eval_id " .
-                "FROM" .
-                " eval b " .
-                "LEFT JOIN" .
-                " eval_range " .
-                "ON" .
-                " b.eval_id = eval_range.eval_id " .
-                "WHERE" .
-                " eval_range.eval_id IS NULL" .
-                " AND" .
-                " b.author_id = ?";
-            $param = $GLOBALS['user']->id;
-        }
-
-        if ($state == EVAL_STATE_NEW)
-            $sql .= " AND (b.startdate IS NULL OR b.startdate > " . time() . ")";
-
-        elseif ($state == EVAL_STATE_ACTIVE)
-            $sql .=
-                " AND b.startdate < " . time() . "" .
-                " AND (" .
-                "      (b.timespan IS NULL AND b.stopdate > " . time() . ")" .
-                "       OR" .
-                "      (b.stopdate IS NULL AND (b.startdate+b.timespan) > " . time() . ")" .
-                "       OR" .
-                "      (b.timespan IS NULL AND b.stopdate IS NULL)" .
-                "     )";
-
-        elseif ($state == EVAL_STATE_STOPPED)
-            $sql .=
-                " AND b.startdate < " . time() . "" .
-                " AND (" .
-                "      (b.timespan IS NULL AND b.stopdate <= " . time() . ")" .
-                "       OR" .
-                "      (b.stopdate IS NULL AND (b.startdate+b.timespan) <= " . time() . ")" .
-                "     )";
-
-        $sql .= " ORDER BY chdate DESC";
-
-        return DBManager::get()->fetchFirst($sql, [$param]);
-    }
-
-    /**
-     * Gets the evaluation id for a object id
-     * @access  public
-     * @param string $objectID The object id
-     * @return  string   The evaluation id or nothing
-     */
-    public function getEvalID($objectID)
-    {
-        if (empty ($objectID)) {
-            throw new Exception("FATAL ERROR in getEvalID ;)");
-        }
-
-        $type = EvaluationObjectDB::getType($objectID);
-
-        switch ($type) {
-            case INSTANCEOF_EVALANSWER:
-                $parentID = EvaluationAnswerDB::getParentID($objectID);
-                break;
-            case INSTANCEOF_EVALQUESTION:
-                $parentID = EvaluationQuestionDB::getParentID($objectID);
-                break;
-            case INSTANCEOF_EVALGROUP:
-                $parentID = EvaluationGroupDB::getParentID($objectID);
-                break;
-            default:
-                return $objectID;
-        }
-        return EvaluationObjectDB::getEvalID($parentID);
-    }
-
-    /**
-     * Returns the type of an objectID
-     * @access public
-     * @param string $objectID The objectID
-     * @return string  INSTANCEOF_x, else NO
-     */
-    public function getType($objectID)
-    {
-        return (new EvaluationDB ())->getType($objectID);
-    }
-}