diff options
Diffstat (limited to 'lib/models/DatafieldEntryModel.php')
| -rw-r--r-- | lib/models/DatafieldEntryModel.php | 261 |
1 files changed, 261 insertions, 0 deletions
diff --git a/lib/models/DatafieldEntryModel.php b/lib/models/DatafieldEntryModel.php new file mode 100644 index 0000000..33503e3 --- /dev/null +++ b/lib/models/DatafieldEntryModel.php @@ -0,0 +1,261 @@ +<?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); + } + } + } +} |