diff options
| author | Philipp Schüttlöffel <schuettloeffel@zqs.uni-hannover.de> | 2024-09-24 10:53:31 +0200 |
|---|---|---|
| committer | Philipp Schüttlöffel <schuettloeffel@zqs.uni-hannover.de> | 2024-09-24 10:53:31 +0200 |
| commit | 4459dd7917f4d1c34f40bb68f0e991e9c3d53e4c (patch) | |
| tree | 5c07151ae61276d334e88f6309c30d439a85c12e /lib/classes/AuxLockRules.class.php | |
| parent | da0022e5c1abbf9825ae76debaabdff7e8623bb4 (diff) | |
| parent | 97a188592c679890a25c37ab78463add76a52ff7 (diff) | |
Merge branch 'main' into issue-3911issue-3911
Diffstat (limited to 'lib/classes/AuxLockRules.class.php')
| -rw-r--r-- | lib/classes/AuxLockRules.class.php | 124 |
1 files changed, 0 insertions, 124 deletions
diff --git a/lib/classes/AuxLockRules.class.php b/lib/classes/AuxLockRules.class.php deleted file mode 100644 index 4d06ca2..0000000 --- a/lib/classes/AuxLockRules.class.php +++ /dev/null @@ -1,124 +0,0 @@ -<? -# Lifter002: DONE -# Lifter007: TODO -# Lifter003: TEST -# Lifter010: TODO -/** -* ZusatzLockRules.class.php - Sichtbarkeits-Administration fuer Zusatzangaben bei Teilnehmerlisten -* -* Copyright (C) 2006 Till Glöggler <tgloeggl@inspace.de> -* -* 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. -* -* 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. -*/ - -/** - * @deprecated since Stud.IP 5.3 - */ -class AuxLockRules -{ - - static function _toArray($data) - { - return [ - 'lock_id' => $data['lock_id'], - 'name' => $data['name'], - 'description' => $data['description'], - 'attributes' => json_decode($data['attributes'], true), - 'order' => json_decode($data['sorting'], true) - ]; - } - - static function getAllLockRules() - { - $ret = []; - $db = DBManager::get()->query("SELECT * FROM aux_lock_rules"); - while ($data = $db->fetch(PDO::FETCH_ASSOC)) { - $ret[$data['lock_id']] = AuxLockRules::_toArray($data); - } - - return $ret; - } - - static function getLockRuleById($id) - { - $stmt = DBManager::get()->prepare("SELECT * FROM aux_lock_rules WHERE lock_id = ?"); - $stmt->execute([$id]); - $data = $stmt->fetch(PDO::FETCH_ASSOC); - return AuxLockRules::_toArray($data); - } - - static function getLockRuleBySemId($sem_id) - { - $stmt = DBManager::get()->prepare("SELECT aux_lock_rule FROM seminare WHERE Seminar_id = ?"); - $stmt->execute([$sem_id]); - $lock_rule = $stmt->fetchColumn(); - if ($lock_rule) { - return AuxLockRules::getLockRuleById($lock_rule); - } - return NULL; - } - - static function createLockRule($name, $description, $fields, $order) - { - $id = md5(uniqid(rand())); - $attributes = json_encode($fields); - $sorting = json_encode($order); - $stmt = DBManager::get()->prepare('INSERT INTO aux_lock_rules ' - . '(lock_id, name, description, attributes, sorting) ' - . 'VALUES (?, ?, ?, ?, ?)'); - $stmt->execute([$id, $name, $description, $attributes, $sorting]); - return $id; - } - - static function updateLockRule($id, $name, $description, $fields, $order) - { - $attributes = json_encode($fields); - $sorting = json_encode($order); - $stmt = DBManager::get()->prepare('UPDATE aux_lock_rules ' - . 'SET name = ?, description = ?, attributes = ?, sorting = ? ' - . 'WHERE lock_id = ?'); - return $stmt->execute([$name, $description, $attributes, $sorting, $id]); - } - - static function deleteLockRule($id) - { - $stmt = DBManager::get()->prepare('SELECT COUNT(*) as c FROM seminare WHERE aux_lock_rule = ?'); - $stmt->execute([$id]); - if ($stmt->fetchColumn() > 0) return false; - - $stmt = DBManager::get()->prepare('DELETE FROM aux_lock_rules WHERE lock_id = ?'); - return $stmt->execute([$id]); - } - - static function getSemFields() - { - return [ - 'vasemester' => 'Semester', - 'vanr' => 'Veranstaltungsnummer', - 'vatitle' => 'Veranstaltungstitel', - 'vadozent' => 'Dozent' - ]; - } - - static function checkLockRule($fields) - { - $entries = DataField::getDataFields('usersemdata'); - foreach ($entries as $id => $entry) { - if ($fields[$entry->datafield_id] == 1) return true; - } - - return false; - } -} |
