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/models/MessageUser.class.php | |
| parent | da0022e5c1abbf9825ae76debaabdff7e8623bb4 (diff) | |
| parent | 97a188592c679890a25c37ab78463add76a52ff7 (diff) | |
Merge branch 'main' into issue-3911issue-3911
Diffstat (limited to 'lib/models/MessageUser.class.php')
| -rw-r--r-- | lib/models/MessageUser.class.php | 98 |
1 files changed, 0 insertions, 98 deletions
diff --git a/lib/models/MessageUser.class.php b/lib/models/MessageUser.class.php deleted file mode 100644 index 0ae6dd5..0000000 --- a/lib/models/MessageUser.class.php +++ /dev/null @@ -1,98 +0,0 @@ -<?php -/** - * MessageUser.class.php - * model class for table message_user - * - * 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 mlunzena - * @copyright (c) Authors - * - * @property array $id alias for pk - * @property string $user_id database column - * @property string $message_id database column - * @property int $readed database column - * @property int $deleted database column - * @property string $snd_rec database column - * @property int $answered database column - * @property int $mkdate database column - * @property User $user belongs_to User - * @property Message $message belongs_to Message - */ - -class MessageUser extends SimpleORMap implements PrivacyObject -{ - protected static function configure($config = []) - { - $config['db_table'] = 'message_user'; - - $config['belongs_to']['user'] = [ - 'class_name' => User::class, - 'foreign_key' => 'user_id', - ]; - $config['belongs_to']['message'] = [ - 'class_name' => Message::class, - 'foreign_key' => 'message_id', - ]; - - $config['registered_callbacks']['after_store'][] = 'cleanUpTags'; - $config['registered_callbacks']['after_delete'][] = 'cleanUpTags'; - - parent::configure($config); - } - - public static function hasUnreadByUserId($user_id) - { - return self::countBySql("snd_rec = 'rec' AND readed = 0 AND user_id = ? AND deleted = 0", [$user_id]) > 0; - } - - public static function findSentByMessageId($message_id) - { - return self::findOneBySQL("message_id=? AND snd_rec='snd'", [$message_id]); - } - - public static function findReceivedByMessageId($message_id) - { - return self::findBySQL("message_id=? AND snd_rec='rec'", [$message_id]); - } - - public function cleanUpTags($callback) - { - $query = "DELETE FROM message_tags - WHERE message_id = :message_id AND user_id = :user_id"; - $statement = DBManager::get()->prepare($query); - $statement->bindValue(':message_id', $this['message_id']); - $statement->bindValue(':user_id', $this['user_id']); - if ($callback == 'after_delete') { - $statement->execute(); - } - if ($callback == 'after_store' && $this->isDirty("deleted") && $this['deleted']) { - $statement->execute(); - $this->message->removeIfOrphaned(); - } - 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(_('MessageUser'), 'message_user', $field_data); - } - } - } -} |
