diff options
Diffstat (limited to 'lib/models/InstituteMember.class.php')
| -rw-r--r-- | lib/models/InstituteMember.class.php | 221 |
1 files changed, 0 insertions, 221 deletions
diff --git a/lib/models/InstituteMember.class.php b/lib/models/InstituteMember.class.php deleted file mode 100644 index ec1c026..0000000 --- a/lib/models/InstituteMember.class.php +++ /dev/null @@ -1,221 +0,0 @@ -<?php -/** - * InstituteMember - * model class for table user_inst - * - * 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 int $id database column - * @property string $user_id database column - * @property string $institut_id database column - * @property string $inst_perms database column - * @property I18NString $sprechzeiten database column - * @property I18NString $raum database column - * @property I18NString $telefon database column - * @property I18NString $fax database column - * @property int $externdefault database column - * @property int $priority database column - * @property int $visible database column - * @property int|null $mkdate database column - * @property int|null $chdate database column - * @property SimpleORMapCollection|DatafieldEntryModel[] $datafields has_many DatafieldEntryModel - * @property User $user belongs_to User - * @property Institute $institute belongs_to Institute - * @property mixed $vorname additional field - * @property mixed $nachname additional field - * @property mixed $username additional field - * @property mixed $email additional field - * @property mixed $title_front additional field - * @property mixed $title_rear additional field - * @property mixed $user_info additional field - * @property mixed $institute_name additional field - */ -class InstituteMember extends SimpleORMap implements PrivacyObject -{ - protected static function configure($config = []) - { - $config['db_table'] = 'user_inst'; - $config['belongs_to']['user'] = [ - 'class_name' => User::class, - 'foreign_key' => 'user_id', - ]; - $config['belongs_to']['institute'] = [ - 'class_name' => Institute::class, - 'foreign_key' => 'institut_id', - ]; - $config['has_many']['datafields'] = [ - 'class_name' => DatafieldEntryModel::class, - 'assoc_foreign_key' => - function($model, $params) { - $model->setValue('range_id', $params[0]->user_id); - $model->setValue('sec_range_id', $params[0]->institut_id); - }, - 'assoc_func' => 'findByModel', - 'on_delete' => 'delete', - 'on_store' => 'store', - 'foreign_key' => - function($institute_member) { - return [$institute_member]; - } - ]; - - $config['additional_fields']['vorname'] = ['user', 'vorname']; - $config['additional_fields']['nachname'] = ['user', 'nachname']; - $config['additional_fields']['username'] = ['user', 'username']; - $config['additional_fields']['email'] = ['user', 'email']; - $config['additional_fields']['title_front'] = ['user', 'title_front']; - $config['additional_fields']['title_rear'] = ['user', 'title_rear']; - $config['additional_fields']['user_info'] = ['user', 'info']; - - $config['additional_fields']['institute_name'] = []; - - $config['i18n_fields']['raum'] = true; - $config['i18n_fields']['sprechzeiten'] = true; - $config['i18n_fields']['telefon'] = true; - $config['i18n_fields']['fax'] = true; - - $config['registered_callbacks']['after_delete'][] = function ($member) { - $institute = $member->institute; - $user_id = $member->user_id; - - if ($institute) { - $institute->status_groups->removeUser($user_id, true); - } - }; - - parent::configure($config); - } - - public static function findByInstitute($institute_id) - { - $query = "SELECT user_inst.*, aum.Vorname, aum.Nachname, aum.Email, - aum.username, ui.title_front, ui.title_rear - FROM user_inst - LEFT JOIN auth_user_md5 aum USING (user_id) - LEFT JOIN user_info ui USING (user_id) - WHERE institut_id = ? - AND inst_perms <> 'user' - ORDER BY inst_perms, Nachname, Vorname"; - return DBManager::get()->fetchAll( - $query, - [$institute_id], - __CLASS__ . '::buildExisting' - ); - } - - public static function findByInstituteAndStatus($institute_id, $status) - { - $query = "SELECT user_inst.*, aum.Vorname, aum.Nachname, aum.Email, - aum.username, ui.title_front, ui.title_rear - FROM user_inst - LEFT JOIN auth_user_md5 aum USING (user_id) - LEFT JOIN user_info ui USING (user_id) - WHERE institut_id = ? - AND user_inst.inst_perms IN (?) - ORDER BY inst_perms, Nachname, Vorname"; - return DBManager::get()->fetchAll( - $query, - [$institute_id, is_array($status) ? $status : words($status)], - __CLASS__ . '::buildExisting' - ); - } - - public static function findByUser($user_id) - { - $query = "SELECT user_inst.*, Institute.Name AS institute_name - FROM user_inst - JOIN Institute USING (institut_id) - WHERE user_id = ? - ORDER BY priority, Institute.Name"; - return DBManager::get()->fetchAll( - $query, - [$user_id], - __CLASS__ . '::buildExisting' - ); - } - - /** - * Finds an institute membership by user and institute id. - * - * @param string $user_id - * @param string $institute_id - * @return InstituteMember|null - */ - public static function findByUserAndInstitute($user_id, $institute_id) - { - return self::findOneBySQL('user_id = ? AND institut_id = ?', [$user_id, $institute_id]); - } - - public function getUserFullname($format = 'full') - { - return User::build(array_merge( - ['motto' => ''], - $this->toArray('vorname nachname username title_front title_rear') - ))->getFullName($format); - } - - /** - * Returns the id of the default institute for a user or false if none is set. - * - * @param string $user_id Id of the user - * @return string institute id or bool false - */ - public static function getDefaultInstituteIdForUser($user_id) - { - $institute = self::findOneBySQL( - "user_id = ? AND inst_perms != 'user' AND externdefault = 1", - [$user_id] - ); - return $institute ? $institute->institut_id : false; - } - - /** - * Returns the id of the default institute for a user or false if none is set. - * - * @param string $user_id Id of the user - * @return bool true if institute was updated, false otherwise - */ - public static function ensureDefaultInstituteForUser($user_id) - { - $institute = self::findOneBySQL( - "user_id = ? AND inst_perms != 'user' ORDER BY externdefault = 1 DESC, priority", - [$user_id] - ); - if (!$institute || $institute->externdefault) { - return false; - } - - $institute->externdefault = true; - $institute->store(); - - return true; - } - - /** - * 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('user_id = ?', [$storage->user_id]); - if ($sorm) { - $field_data = []; - foreach ($sorm as $row) { - $field_data[] = $row->toRawArray(); - } - if ($field_data) { - $storage->addTabularData(_('Einrichtungs Informationen'), 'user_inst', $field_data); - } - } - } -} |