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\Database;
27 use Friendica\Database\DBA;
28 use Friendica\Util\DateTimeFormat;
33 * These constants represent the parcel format used to transport a conversation independently of the message protocol.
34 * It currently is stored in the "protocol" field for legacy reasons.
36 const PARCEL_ACTIVITYPUB = 0;
37 const PARCEL_DFRN = 1;
38 const PARCEL_DIASPORA = 2;
39 const PARCEL_SALMON = 3;
40 const PARCEL_FEED = 4; // Deprecated
41 const PARCEL_SPLIT_CONVERSATION = 6;
42 const PARCEL_TWITTER = 67;
43 const PARCEL_UNKNOWN = 255;
46 * Unknown message direction
50 * The message had been pushed to this sytem
54 * The message had been fetched by our system
58 public static function getByItemUri($item_uri)
60 return DBA::selectFirst('conversation', [], ['item-uri' => $item_uri]);
64 * Store the conversation data
66 * @param array $arr Item array with conversation data
67 * @return array Item array with removed conversation data
70 public static function insert(array $arr)
72 if (in_array(($arr['network'] ?? '') ?: Protocol::PHANTOM,
73 [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::DIASPORA, Protocol::OSTATUS, Protocol::TWITTER]) && !empty($arr['uri'])) {
74 $conversation = ['item-uri' => $arr['uri'], 'received' => DateTimeFormat::utcNow()];
76 if (isset($arr['parent-uri']) && ($arr['parent-uri'] != $arr['uri'])) {
77 $conversation['reply-to-uri'] = $arr['parent-uri'];
80 if (isset($arr['thr-parent']) && ($arr['thr-parent'] != $arr['uri'])) {
81 $conversation['reply-to-uri'] = $arr['thr-parent'];
84 if (isset($arr['conversation-uri'])) {
85 $conversation['conversation-uri'] = $arr['conversation-uri'];
88 if (isset($arr['conversation-href'])) {
89 $conversation['conversation-href'] = $arr['conversation-href'];
92 if (isset($arr['protocol'])) {
93 $conversation['protocol'] = $arr['protocol'];
96 if (isset($arr['direction'])) {
97 $conversation['direction'] = $arr['direction'];
100 if (isset($arr['source'])) {
101 $conversation['source'] = $arr['source'];
104 $fields = ['item-uri', 'reply-to-uri', 'conversation-uri', 'conversation-href', 'protocol', 'source'];
105 $old_conv = DBA::selectFirst('conversation', $fields, ['item-uri' => $conversation['item-uri']]);
106 if (DBA::isResult($old_conv)) {
107 // Don't update when only the source has changed.
108 // Only do this when there had been no source before.
109 if ($old_conv['source'] != '') {
110 unset($old_conv['source']);
112 // Update structure data all the time but the source only when its from a better protocol.
114 empty($conversation['source'])
116 !empty($old_conv['source'])
117 && ($old_conv['protocol'] < (($conversation['protocol'] ?? '') ?: self::PARCEL_UNKNOWN))
120 unset($conversation['protocol']);
121 unset($conversation['source']);
123 if (!DBA::update('conversation', $conversation, ['item-uri' => $conversation['item-uri']], $old_conv)) {
124 Logger::log('Conversation: update for ' . $conversation['item-uri'] . ' from ' . $old_conv['protocol'] . ' to ' . $conversation['protocol'] . ' failed',
128 if (!DBA::insert('conversation', $conversation, Database::INSERT_UPDATE)) {
129 Logger::log('Conversation: insert for ' . $conversation['item-uri'] . ' (protocol ' . $conversation['protocol'] . ') failed',
135 unset($arr['conversation-uri']);
136 unset($arr['conversation-href']);
137 unset($arr['protocol']);
138 unset($arr['source']);
139 unset($arr['direction']);