3 * @copyright Copyright (C) 2020, Friendica
5 * @license GNU AGPL version 3 or any later version
7 * This program is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU Affero General Public License as
9 * published by the Free Software Foundation, either version 3 of the
10 * License, or (at your option) any later version.
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU Affero General Public License for more details.
17 * You should have received a copy of the GNU Affero General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 namespace Friendica\Model;
24 use Friendica\Core\Logger;
25 use Friendica\Core\Protocol;
26 use Friendica\Database\DBA;
27 use Friendica\Util\DateTimeFormat;
32 * These constants represent the parcel format used to transport a conversation independently of the message protocol.
33 * It currently is stored in the "protocol" field for legacy reasons.
35 const PARCEL_ACTIVITYPUB = 0;
36 const PARCEL_DFRN = 1;
37 const PARCEL_DIASPORA = 2;
38 const PARCEL_SALMON = 3;
39 const PARCEL_FEED = 4; // Deprecated
40 const PARCEL_SPLIT_CONVERSATION = 6;
41 const PARCEL_TWITTER = 67;
42 const PARCEL_UNKNOWN = 255;
44 public static function getByItemUri($item_uri)
46 return DBA::selectFirst('conversation', [], ['item-uri' => $item_uri]);
50 * Store the conversation data
52 * @param array $arr Item array with conversation data
53 * @return array Item array with removed conversation data
56 public static function insert(array $arr)
58 if (in_array(($arr['network'] ?? '') ?: Protocol::PHANTOM,
59 [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::DIASPORA, Protocol::OSTATUS, Protocol::TWITTER]) && !empty($arr['uri'])) {
60 $conversation = ['item-uri' => $arr['uri'], 'received' => DateTimeFormat::utcNow()];
62 if (isset($arr['parent-uri']) && ($arr['parent-uri'] != $arr['uri'])) {
63 $conversation['reply-to-uri'] = $arr['parent-uri'];
66 if (isset($arr['thr-parent']) && ($arr['thr-parent'] != $arr['uri'])) {
67 $conversation['reply-to-uri'] = $arr['thr-parent'];
70 if (isset($arr['conversation-uri'])) {
71 $conversation['conversation-uri'] = $arr['conversation-uri'];
74 if (isset($arr['conversation-href'])) {
75 $conversation['conversation-href'] = $arr['conversation-href'];
78 if (isset($arr['protocol'])) {
79 $conversation['protocol'] = $arr['protocol'];
82 if (isset($arr['source'])) {
83 $conversation['source'] = $arr['source'];
86 $fields = ['item-uri', 'reply-to-uri', 'conversation-uri', 'conversation-href', 'protocol', 'source'];
87 $old_conv = DBA::selectFirst('conversation', $fields, ['item-uri' => $conversation['item-uri']]);
88 if (DBA::isResult($old_conv)) {
89 // Don't update when only the source has changed.
90 // Only do this when there had been no source before.
91 if ($old_conv['source'] != '') {
92 unset($old_conv['source']);
94 // Update structure data all the time but the source only when its from a better protocol.
96 empty($conversation['source'])
98 !empty($old_conv['source'])
99 && ($old_conv['protocol'] < (($conversation['protocol'] ?? '') ?: self::PARCEL_UNKNOWN))
102 unset($conversation['protocol']);
103 unset($conversation['source']);
105 if (!DBA::update('conversation', $conversation, ['item-uri' => $conversation['item-uri']], $old_conv)) {
106 Logger::log('Conversation: update for ' . $conversation['item-uri'] . ' from ' . $old_conv['protocol'] . ' to ' . $conversation['protocol'] . ' failed',
110 if (!DBA::insert('conversation', $conversation, true)) {
111 Logger::log('Conversation: insert for ' . $conversation['item-uri'] . ' (protocol ' . $conversation['protocol'] . ') failed',
117 unset($arr['conversation-uri']);
118 unset($arr['conversation-href']);
119 unset($arr['protocol']);
120 unset($arr['source']);