aboutsummaryrefslogtreecommitdiff
path: root/lib/models/DatafieldEntryModel.class.php
diff options
context:
space:
mode:
Diffstat (limited to 'lib/models/DatafieldEntryModel.class.php')
-rw-r--r--lib/models/DatafieldEntryModel.class.php261
1 files changed, 0 insertions, 261 deletions
diff --git a/lib/models/DatafieldEntryModel.class.php b/lib/models/DatafieldEntryModel.class.php
deleted file mode 100644
index 33503e3..0000000
--- a/lib/models/DatafieldEntryModel.class.php
+++ /dev/null
@@ -1,261 +0,0 @@
-<?php
-/**
- * DatafieldEntryModel
- * model class for table datafields_entries
- *
- * 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.
- *
- * @author André Noack <noack@data-quest.de>
- * @copyright 2012 Stud.IP Core-Group
- * @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
- * @category Stud.IP
- *
- * @property array $id alias for pk
- * @property string $datafield_id database column
- * @property string $range_id database column
- * @property string|null $content database column
- * @property int|null $mkdate database column
- * @property int|null $chdate database column
- * @property string $sec_range_id database column
- * @property string $lang database column
- * @property DataField $datafield belongs_to DataField
- * @property mixed $name additional field
- */
-
-class DatafieldEntryModel extends SimpleORMap implements PrivacyObject
-{
- protected static function configure($config = [])
- {
- $config['db_table'] = 'datafields_entries';
- $config['belongs_to']['datafield'] = [
- 'class_name' => DataField::class,
- 'foreign_key' => 'datafield_id'
- ];
- $config['additional_fields']['name'] = ['datafield', 'name'];
- parent::configure($config);
- }
-
- /**
- * returns datafields belonging to given model
- * if a datafield entry not exists yet, a new DatafieldEntryModel is returned
- * second param filters for a given datafield id
- *
- * @param SimpleORMap $model Course,Institute,User,CourseMember or InstituteMember
- * @param string $datafield_id
- * @return array of DatafieldEntryModel
- */
- public static function findByModel(SimpleORMap $model, $datafield_id = null)
- {
- $mask = [
- 'user' => 1,
- 'autor' => 2,
- 'tutor' => 4,
- 'dozent' => 8,
- 'admin' => 16,
- 'root' => 32,
- ];
-
- $sec_range_id = null;
- if ($model instanceof Course) {
- $params[':institution_ids'] = $model->institutes->pluck('institut_id');
- $object_class = SeminarCategories::GetByTypeId($model->status)->id;
- $object_type = 'sem';
- $range_id = $model->id;
- } elseif ($model instanceof Institute) {
- $params[':institution_ids'] = [$model->id];
- $object_class = $model->type;
- $object_type = 'inst';
- $range_id = $model->id;
- } elseif ($model instanceof User) {
- $params[':institution_ids'] = $model->institute_memberships->pluck('institut_id');
- $object_class = $mask[$model->perms];
- $object_type = 'user';
- $range_id = $model->id;
- } elseif($model instanceof CourseMember) {
- $params[':institution_ids'] = $model->course->institutes->pluck('institut_id');
- $object_class = $mask[$model->status];
- $object_type = 'usersemdata';
- $range_id = $model->user_id;
- $sec_range_id = $model->seminar_id;
- } elseif($model instanceof InstituteMember) {
- $params[':institution_ids'] = [$model->institut_id];
- $object_class = $mask[$model->inst_perms];
- $object_type = 'userinstrole';
- $range_id = $model->user_id;
- $sec_range_id = $model->institut_id;
- } elseif ($model instanceof ModulDeskriptor) {
- $params[':institution_ids'] = '';
- if (!empty($model->modul->responsible_institute->institut_id)) {
- $params[':institution_ids'] = [$model->modul->responsible_institute->institut_id];
- }
- $object_class = $model->getVariant();
- $object_type = 'moduldeskriptor';
- $range_id = $model->deskriptor_id;
- } elseif ($model instanceof ModulteilDeskriptor) {
- $params[':institution_ids'] = [$model->modulteil->modul->responsible_institute->institut_id];
- $object_class = $model->getVariant();
- $object_type = 'modulteildeskriptor';
- $range_id = $model->deskriptor_id;
- } elseif ($model instanceof StatusgruppeUser) {
- if (isset($model->group->institute)) {
- $params[':institution_ids'] = [$model->group->institute->id];
- } else {
- $params[':institution_ids'] = [];
- }
- $object_class = 255;
- $object_type = 'userinstrole';
- $range_id = $model->user_id;
- $sec_range_id = $model->statusgruppe_id;
- } elseif ($model instanceof Studiengang) {
- $params[':institution_ids'] = [$model->institut_id];
- $object_class = $model->getVariant();
- $object_type = 'studycourse';
- $range_id = $model->studiengang_id;
- } else {
- throw new InvalidArgumentException('Wrong type of model: ' . get_class($model));
- }
-
- $query = "SELECT a.*, b.*, a.datafield_id, b.datafield_id AS isset_content
- FROM datafields a
- LEFT JOIN datafields_entries b
- ON (a.datafield_id=b.datafield_id AND range_id = :range_id AND sec_range_id = :sec_range_id)
- WHERE object_type = :object_type
- AND (lang IS NULL OR lang = '')
- AND (a.institut_id IS NULL OR a.institut_id IN (:institution_ids))";
-
- if ($datafield_id !== null) {
- $query .= ' AND a.datafield_id = :one_datafield_id';
- $params[':one_datafield_id'] = $datafield_id;
- }
-
- if ($object_type === 'sem' || $object_type === 'inst') {
- // find datafields by status (int)
- $query .= " AND (object_class = :object_class OR object_class IS NULL) ORDER BY priority";
- $params = array_merge($params, [
- ':range_id' => (string) $range_id,
- ':sec_range_id' => (string) $sec_range_id,
- ':object_type' => $object_type,
- ':object_class' => (int) $object_class
- ]);
- } else if ($object_type === 'studycourse') {
- $query .= " AND (LOCATE(:object_class, object_class) OR LOCATE('all', object_class)) ORDER BY priority";
- $params = array_merge($params,[
- ':range_id' => (string) $range_id,
- ':sec_range_id' => (string) $sec_range_id,
- ':object_type' => $object_type,
- ':object_class' => (string) $object_class,
- ]);
- } elseif ($object_type === 'moduldeskriptor'
- || $object_type === 'modulteildeskriptor') {
- // find datafields by language (string)
- $query .= " AND (LOCATE(:object_class, object_class) OR object_class IS NULL) ORDER BY priority";
- $params = array_merge($params,[
- ':range_id' => (string) $range_id,
- ':sec_range_id' => (string) $sec_range_id,
- ':object_type' => $object_type,
- ':object_class' => (string) $object_class,
- ]);
- } else {
- // find datafields by perms or status (int)
- $query .= " AND ((object_class & :object_class) OR object_class IS NULL) ORDER BY priority";
- $params = array_merge($params, [
- ':range_id' => (string) $range_id,
- ':sec_range_id' => (string) $sec_range_id,
- ':object_type' => $object_type,
- ':object_class' => (int) $object_class,
- ]);
- }
-
- $st = DBManager::get()->prepare($query);
- $st->execute($params);
- $ret = [];
- $c = 0;
- $df_entry = new DatafieldEntryModel();
- $df_entry_i18n = new DatafieldEntryModelI18N();
- $df = new DataField();
- while ($row = $st->fetch(PDO::FETCH_ASSOC)) {
- if (mb_strpos($row['type'], 'i18n') === false) {
- $ret[$c] = clone $df_entry;
- } else {
- $ret[$c] = clone $df_entry_i18n;
- $row['content'] = I18NStringDatafield::load([
- $row['datafield_id'],
- $range_id,
- (string) $sec_range_id
- ]);
- }
- $ret[$c]->setData($row, true);
- if (!$row['isset_content']) {
- $ret[$c]->setValue('range_id', (string) $range_id);
- $ret[$c]->setValue('sec_range_id', (string) $sec_range_id);
- $ret[$c]->setValue('lang', '');
- }
- $ret[$c]->setNew(!$row['isset_content']);
- $cloned_df = clone $df;
- $cloned_df->setData($row, true);
- $cloned_df->setNew(false);
- $ret[$c]->setValue('datafield', $cloned_df);
- $c++;
- }
- return $ret;
- }
-
- public function setContentLanguage($language)
- {
- if (!Config::get()->CONTENT_LANGUAGES[$language]) {
- throw new InvalidArgumentException('Language not configured.');
- }
-
- $content_languages = array_keys(Config::get()->CONTENT_LANGUAGES);
- if ($language == reset($content_languages)) {
- $language = '';
- }
-
- $this->lang = $language;
- }
-
- /**
- * returns matching "old-style" DataFieldEntry object
- *
- * @return DataFieldEntry
- */
- public function getTypedDatafield()
- {
- $range_id = $this->sec_range_id
- ? [$this->range_id, $this->sec_range_id, $this->lang]
- : [$this->range_id, '', $this->lang];
-
- $df = DataFieldEntry::createDataFieldEntry($this->datafield, $range_id, $this->getValue('content'));
- $observer = function ($event, $object, $user_data) {
- if ($user_data['changed']) {
- $this->restore();
- }
- };
- NotificationCenter::addObserver($observer, '__invoke', 'DatafieldDidUpdate', $df);
-
- return $df;
- }
-
- /**
- * Export available data of a given user into a storage object
- * (an instance of the StoredUserData class) for that user.
- *
- * @param StoredUserData $storage object to store data into
- */
- public static function exportUserData(StoredUserData $storage)
- {
- $sorm = self::findBySQL("range_id = ?", [$storage->user_id]);
- if ($sorm) {
- $field_data = [];
- foreach ($sorm as $row) {
- $field_data[] = $row->toRawArray();
- }
- if ($field_data) {
- $storage->addTabularData(_('Datenfeld Einträge'), 'datafields_entries', $field_data);
- }
- }
- }
-}
generated by cgit v1.0 at 2026-05-27 12:57:29 +0000