src/Content/Conversation.php

   1 <?php
   2 /**
   3  * @copyright Copyright (C) 2010-2023, the Friendica project
   4  *
   5  * @license GNU AGPL version 3 or any later version
   6  *
   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.
  11  *
  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.
  16  *
  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/>.
  19  *
  20  */
  21
  22 namespace Friendica\Content;
  23
  24 use Friendica\App;
  25 use Friendica\App\Arguments;
  26 use Friendica\App\BaseURL;
  27 use Friendica\BaseModule;
  28 use Friendica\Core\ACL;
  29 use Friendica\Core\Config\Capability\IManageConfigValues;
  30 use Friendica\Core\Hook;
  31 use Friendica\Core\L10n;
  32 use Friendica\Core\PConfig\Capability\IManagePersonalConfigValues;
  33 use Friendica\Core\Protocol;
  34 use Friendica\Core\Renderer;
  35 use Friendica\Core\Session\Capability\IHandleUserSessions;
  36 use Friendica\Core\Theme;
  37 use Friendica\Database\DBA;
  38 use Friendica\Model\Contact;
  39 use Friendica\Model\Item as ItemModel;
  40 use Friendica\Model\Post;
  41 use Friendica\Model\Tag;
  42 use Friendica\Model\User;
  43 use Friendica\Model\Verb;
  44 use Friendica\Object\Post as PostObject;
  45 use Friendica\Object\Thread;
  46 use Friendica\Protocol\Activity;
  47 use Friendica\Util\Crypto;
  48 use Friendica\Util\DateTimeFormat;
  49 use Friendica\Util\Profiler;
  50 use Friendica\Util\Strings;
  51 use Friendica\Util\Temporal;
  52 use Psr\Log\LoggerInterface;
  53
  54 class Conversation
  55 {
  56         const MODE_COMMUNITY     = 'community';
  57         const MODE_CONTACTS      = 'contacts';
  58         const MODE_CONTACT_POSTS = 'contact-posts';
  59         const MODE_DISPLAY       = 'display';
  60         const MODE_FILED         = 'filed';
  61         const MODE_NETWORK       = 'network';
  62         const MODE_NOTES         = 'notes';
  63         const MODE_SEARCH        = 'search';
  64         const MODE_PROFILE       = 'profile';
  65
  66         /** @var Activity */
  67         private $activity;
  68         /** @var L10n */
  69         private $l10n;
  70         /** @var Profiler */
  71         private $profiler;
  72         /** @var LoggerInterface */
  73         private $logger;
  74         /** @var Item */
  75         private $item;
  76         /** @var App\Arguments */
  77         private $args;
  78         /** @var IManagePersonalConfigValues */
  79         private $pConfig;
  80         /** @var BaseURL */
  81         private $baseURL;
  82         /** @var IManageConfigValues */
  83         private $config;
  84         /** @var App */
  85         private $app;
  86         /** @var App\Page */
  87         private $page;
  88         /** @var App\Mode */
  89         private $mode;
  90         /** @var IHandleUserSessions */
  91         private $session;
  92
  93         public function __construct(LoggerInterface $logger, Profiler $profiler, Activity $activity, L10n $l10n, Item $item, Arguments $args, BaseURL $baseURL, IManageConfigValues $config, IManagePersonalConfigValues $pConfig, App\Page $page, App\Mode $mode, App $app, IHandleUserSessions $session)
  94         {
  95                 $this->activity = $activity;
  96                 $this->item     = $item;
  97                 $this->config   = $config;
  98                 $this->mode     = $mode;
  99                 $this->baseURL  = $baseURL;
 100                 $this->profiler = $profiler;
 101                 $this->logger   = $logger;
 102                 $this->l10n     = $l10n;
 103                 $this->args     = $args;
 104                 $this->pConfig  = $pConfig;
 105                 $this->page     = $page;
 106                 $this->app      = $app;
 107                 $this->session  = $session;
 108         }
 109
 110         /**
 111          * Checks item to see if it is one of the builtin activities (like/dislike, event attendance, consensus items, etc.)
 112          *
 113          * Increments the count of each matching activity and adds a link to the author as needed.
 114          *
 115          * @param array  $activity
 116          * @param array &$conv_responses (already created with builtin activity structure)
 117          * @return void
 118          * @throws ImagickException
 119          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 120          */
 121         public function builtinActivityPuller(array $activity, array &$conv_responses)
 122         {
 123                 $thread_parent = $activity['thr-parent-row'] ?? [];
 124
 125                 foreach ($conv_responses as $mode => $v) {
 126                         $sparkle = '';
 127
 128                         switch ($mode) {
 129                                 case 'like':
 130                                         $verb = Activity::LIKE;
 131                                         break;
 132                                 case 'dislike':
 133                                         $verb = Activity::DISLIKE;
 134                                         break;
 135                                 case 'attendyes':
 136                                         $verb = Activity::ATTEND;
 137                                         break;
 138                                 case 'attendno':
 139                                         $verb = Activity::ATTENDNO;
 140                                         break;
 141                                 case 'attendmaybe':
 142                                         $verb = Activity::ATTENDMAYBE;
 143                                         break;
 144                                 case 'announce':
 145                                         $verb = Activity::ANNOUNCE;
 146                                         break;
 147                                 default:
 148                                         return;
 149                         }
 150
 151                         if (!empty($activity['verb']) && $this->activity->match($activity['verb'], $verb) && ($activity['gravity'] != ItemModel::GRAVITY_PARENT)) {
 152                                 $author = [
 153                                         'uid'     => 0,
 154                                         'id'      => $activity['author-id'],
 155                                         'network' => $activity['author-network'],
 156                                         'url'     => $activity['author-link']
 157                                 ];
 158                                 $url = Contact::magicLinkByContact($author);
 159                                 if (strpos($url, 'contact/redir/') === 0) {
 160                                         $sparkle = ' class="sparkle" ';
 161                                 }
 162
 163                                 $link = '<a href="' . $url . '"' . $sparkle . '>' . htmlentities($activity['author-name']) . '</a>';
 164
 165                                 if (empty($activity['thr-parent-id'])) {
 166                                         $activity['thr-parent-id'] = $activity['parent-uri-id'];
 167                                 }
 168
 169                                 // Skip when the causer of the parent is the same as the author of the announce
 170                                 if (($verb == Activity::ANNOUNCE) && !empty($thread_parent['causer-id']) && ($thread_parent['causer-id'] == $activity['author-id'])) {
 171                                         continue;
 172                                 }
 173
 174                                 if (!isset($conv_responses[$mode][$activity['thr-parent-id']])) {
 175                                         $conv_responses[$mode][$activity['thr-parent-id']] = [
 176                                                 'links' => [],
 177                                                 'self'  => 0,
 178                                         ];
 179                                 } elseif (in_array($link, $conv_responses[$mode][$activity['thr-parent-id']]['links'])) {
 180                                         // only list each unique author once
 181                                         continue;
 182                                 }
 183
 184                                 if ($this->session->getPublicContactId() == $activity['author-id']) {
 185                                         $conv_responses[$mode][$activity['thr-parent-id']]['self'] = 1;
 186                                 }
 187
 188                                 $conv_responses[$mode][$activity['thr-parent-id']]['links'][] = $link;
 189
 190                                 // there can only be one activity verb per item so if we found anything, we can stop looking
 191                                 return;
 192                         }
 193                 }
 194         }
 195
 196         /**
 197          * Format the activity text for an item/photo/video
 198          *
 199          * @param array  $links = array of pre-linked names of actors
 200          * @param string $verb  = one of 'like, 'dislike', 'attendyes', 'attendno', 'attendmaybe'
 201          * @param int    $id    = item id
 202          * @return string formatted text
 203          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 204          */
 205         public function formatActivity(array $links, string $verb, int $id): string
 206         {
 207                 $this->profiler->startRecording('rendering');
 208                 $o        = '';
 209                 $expanded = '';
 210                 $phrase   = '';
 211
 212                 $total = count($links);
 213                 if ($total == 1) {
 214                         $likers = $links[0];
 215
 216                         // Phrase if there is only one liker. In other cases it will be uses for the expanded
 217                         // list which show all likers
 218                         switch ($verb) {
 219                                 case 'like':
 220                                         $phrase = $this->l10n->t('%s likes this.', $likers);
 221                                         break;
 222                                 case 'dislike':
 223                                         $phrase = $this->l10n->t('%s doesn\'t like this.', $likers);
 224                                         break;
 225                                 case 'attendyes':
 226                                         $phrase = $this->l10n->t('%s attends.', $likers);
 227                                         break;
 228                                 case 'attendno':
 229                                         $phrase = $this->l10n->t('%s doesn\'t attend.', $likers);
 230                                         break;
 231                                 case 'attendmaybe':
 232                                         $phrase = $this->l10n->t('%s attends maybe.', $likers);
 233                                         break;
 234                                 case 'announce':
 235                                         $phrase = $this->l10n->t('%s reshared this.', $likers);
 236                                         break;
 237                         }
 238                 } elseif ($total > 1) {
 239                         if ($total < $this->config->get('system', 'max_likers')) {
 240                                 $likers = implode(', ', array_slice($links, 0, -1));
 241                                 $likers .= ' ' . $this->l10n->t('and') . ' ' . $links[count($links) - 1];
 242                         } else {
 243                                 $likers = implode(', ', array_slice($links, 0, $this->config->get('system', 'max_likers') - 1));
 244                                 $likers .= ' ' . $this->l10n->t('and %d other people', $total - $this->config->get('system', 'max_likers'));
 245                         }
 246
 247                         $spanatts = "class=\"btn btn-link fakelink\" onclick=\"openClose('{$verb}list-$id');\"";
 248
 249                         $explikers = '';
 250                         switch ($verb) {
 251                                 case 'like':
 252                                         $phrase    = $this->l10n->t('<button type="button" %1$s>%2$d people</button> like this', $spanatts, $total);
 253                                         $explikers = $this->l10n->t('%s like this.', $likers);
 254                                         break;
 255                                 case 'dislike':
 256                                         $phrase    = $this->l10n->t('<button type="button" %1$s>%2$d people</button> don\'t like this', $spanatts, $total);
 257                                         $explikers = $this->l10n->t('%s don\'t like this.', $likers);
 258                                         break;
 259                                 case 'attendyes':
 260                                         $phrase    = $this->l10n->t('<button type="button" %1$s>%2$d people</button> attend', $spanatts, $total);
 261                                         $explikers = $this->l10n->t('%s attend.', $likers);
 262                                         break;
 263                                 case 'attendno':
 264                                         $phrase    = $this->l10n->t('<button type="button" %1$s>%2$d people</button> don\'t attend', $spanatts, $total);
 265                                         $explikers = $this->l10n->t('%s don\'t attend.', $likers);
 266                                         break;
 267                                 case 'attendmaybe':
 268                                         $phrase    = $this->l10n->t('<button type="button" %1$s>%2$d people</button> attend maybe', $spanatts, $total);
 269                                         $explikers = $this->l10n->t('%s attend maybe.', $likers);
 270                                         break;
 271                                 case 'announce':
 272                                         $phrase    = $this->l10n->t('<button type="button" %1$s>%2$d people</button> reshared this', $spanatts, $total);
 273                                         $explikers = $this->l10n->t('%s reshared this.', $likers);
 274                                         break;
 275                         }
 276
 277                         $expanded .= "\t" . '<p class="wall-item-' . $verb . '-expanded" id="' . $verb . 'list-' . $id . '" style="display: none;" >' . $explikers . '</p>';
 278                 }
 279
 280                 $o .= Renderer::replaceMacros(Renderer::getMarkupTemplate('voting_fakelink.tpl'), [
 281                         '$phrase' => $phrase,
 282                         '$type'   => $verb,
 283                         '$id'     => $id
 284                 ]);
 285                 $o .= $expanded;
 286
 287                 $this->profiler->stopRecording();
 288                 return $o;
 289         }
 290
 291         public function statusEditor(array $x = [], int $notes_cid = 0, bool $popup = false): string
 292         {
 293                 $user = User::getById($this->app->getLoggedInUserId(), ['uid', 'nickname', 'allow_location', 'default-location']);
 294                 if (empty($user['uid'])) {
 295                         return '';
 296                 }
 297
 298                 $this->profiler->startRecording('rendering');
 299                 $o = '';
 300
 301                 $x['allow_location']   = $x['allow_location']   ?? $user['allow_location'];
 302                 $x['default_location'] = $x['default_location'] ?? $user['default-location'];
 303                 $x['nickname']         = $x['nickname']         ?? $user['nickname'];
 304                 $x['lockstate']        = $x['lockstate']        ?? ACL::getLockstateForUserId($user['uid']) ? 'lock' : 'unlock';
 305                 $x['acl']              = $x['acl']              ?? ACL::getFullSelectorHTML($this->page, $user['uid'], true);
 306                 $x['bang']             = $x['bang']             ?? '';
 307                 $x['visitor']          = $x['visitor']          ?? 'block';
 308                 $x['is_owner']         = $x['is_owner']         ?? true;
 309                 $x['profile_uid']      = $x['profile_uid']      ?? $this->session->getLocalUserId();
 310
 311
 312                 $geotag = !empty($x['allow_location']) ? Renderer::replaceMacros(Renderer::getMarkupTemplate('jot_geotag.tpl'), []) : '';
 313
 314                 $tpl = Renderer::getMarkupTemplate('jot-header.tpl');
 315                 $this->page['htmlhead'] .= Renderer::replaceMacros($tpl, [
 316                         '$newpost'   => 'true',
 317                         '$baseurl'   => $this->baseURL,
 318                         '$geotag'    => $geotag,
 319                         '$nickname'  => $x['nickname'],
 320                         '$ispublic'  => $this->l10n->t('Visible to <strong>everybody</strong>'),
 321                         '$linkurl'   => $this->l10n->t('Please enter a image/video/audio/webpage URL:'),
 322                         '$term'      => $this->l10n->t('Tag term:'),
 323                         '$fileas'    => $this->l10n->t('Save to Folder:'),
 324                         '$whereareu' => $this->l10n->t('Where are you right now?'),
 325                         '$delitems'  => $this->l10n->t("Delete item\x28s\x29?"),
 326                         '$is_mobile' => $this->mode->isMobile(),
 327                 ]);
 328
 329                 $jotplugins = '';
 330                 Hook::callAll('jot_tool', $jotplugins);
 331
 332                 if ($this->config->get('system', 'set_creation_date')) {
 333                         $created_at = Temporal::getDateTimeField(
 334                                 new \DateTime(DBA::NULL_DATETIME),
 335                                 new \DateTime('now'),
 336                                 null,
 337                                 $this->l10n->t('Created at'),
 338                                 'created_at'
 339                         );
 340                 } else {
 341                         $created_at = '';
 342                 }
 343
 344                 $tpl = Renderer::getMarkupTemplate('jot.tpl');
 345
 346                 $o .= Renderer::replaceMacros($tpl, [
 347                         '$new_post'            => $this->l10n->t('New Post'),
 348                         '$return_path'         => $this->args->getQueryString(),
 349                         '$action'              => 'item',
 350                         '$share'               => ($x['button'] ?? '') ?: $this->l10n->t('Share'),
 351                         '$loading'             => $this->l10n->t('Loading...'),
 352                         '$upload'              => $this->l10n->t('Upload photo'),
 353                         '$shortupload'         => $this->l10n->t('upload photo'),
 354                         '$attach'              => $this->l10n->t('Attach file'),
 355                         '$shortattach'         => $this->l10n->t('attach file'),
 356                         '$edbold'              => $this->l10n->t('Bold'),
 357                         '$editalic'            => $this->l10n->t('Italic'),
 358                         '$eduline'             => $this->l10n->t('Underline'),
 359                         '$edquote'             => $this->l10n->t('Quote'),
 360                         '$edcode'              => $this->l10n->t('Code'),
 361                         '$edimg'               => $this->l10n->t('Image'),
 362                         '$edurl'               => $this->l10n->t('Link'),
 363                         '$edattach'            => $this->l10n->t('Link or Media'),
 364                         '$edvideo'             => $this->l10n->t('Video'),
 365                         '$setloc'              => $this->l10n->t('Set your location'),
 366                         '$shortsetloc'         => $this->l10n->t('set location'),
 367                         '$noloc'               => $this->l10n->t('Clear browser location'),
 368                         '$shortnoloc'          => $this->l10n->t('clear location'),
 369                         '$title'               => $x['title'] ?? '',
 370                         '$placeholdertitle'    => $this->l10n->t('Set title'),
 371                         '$category'            => $x['category'] ?? '',
 372                         '$placeholdercategory' => Feature::isEnabled($this->session->getLocalUserId(), 'categories') ? $this->l10n->t("Categories \x28comma-separated list\x29") : '',
 373                         '$scheduled_at'        => Temporal::getDateTimeField(
 374                                 new \DateTime(),
 375                                 new \DateTime('now + 6 months'),
 376                                 null,
 377                                 $this->l10n->t('Scheduled at'),
 378                                 'scheduled_at'
 379                         ),
 380                         '$created_at'   => $created_at,
 381                         '$wait'         => $this->l10n->t('Please wait'),
 382                         '$permset'      => $this->l10n->t('Permission settings'),
 383                         '$shortpermset' => $this->l10n->t('Permissions'),
 384                         '$wall'         => $notes_cid ? 0 : 1,
 385                         '$posttype'     => $notes_cid ? ItemModel::PT_PERSONAL_NOTE : ItemModel::PT_ARTICLE,
 386                         '$content'      => $x['content'] ?? '',
 387                         '$post_id'      => $x['post_id'] ?? '',
 388                         '$baseurl'      => $this->baseURL,
 389                         '$defloc'       => $x['default_location'],
 390                         '$visitor'      => $x['visitor'],
 391                         '$pvisit'       => $notes_cid ? 'none' : $x['visitor'],
 392                         '$public'       => $this->l10n->t('Public post'),
 393                         '$lockstate'    => $x['lockstate'],
 394                         '$bang'         => $x['bang'],
 395                         '$profile_uid'  => $x['profile_uid'],
 396                         '$preview'      => $this->l10n->t('Preview'),
 397                         '$jotplugins'   => $jotplugins,
 398                         '$notes_cid'    => $notes_cid,
 399                         '$cancel'       => $this->l10n->t('Cancel'),
 400                         '$rand_num'     => Crypto::randomDigits(12),
 401
 402                         // ACL permissions box
 403                         '$acl' => $x['acl'],
 404
 405                         //jot nav tab (used in some themes)
 406                         '$message' => $this->l10n->t('Message'),
 407                         '$browser' => $this->l10n->t('Browser'),
 408
 409                         '$compose_link_title'  => $this->l10n->t('Open Compose page'),
 410                         '$always_open_compose' => $this->pConfig->get($this->session->getLocalUserId(), 'frio', 'always_open_compose', false),
 411                 ]);
 412
 413
 414                 if ($popup == true) {
 415                         $o = '<div id="jot-popup" style="display: none;">' . $o . '</div>';
 416                 }
 417
 418                 $this->profiler->stopRecording();
 419                 return $o;
 420         }
 421
 422         /**
 423          * "Render" a conversation or list of items for HTML display.
 424          * There are two major forms of display:
 425          *      - Sequential or unthreaded ("New Item View" or search results)
 426          *      - conversation view
 427          * The $mode parameter decides between the various renderings and also
 428          * figures out how to determine page owner and other contextual items
 429          * that are based on unique features of the calling module.
 430          * @param array  $items
 431          * @param string $mode
 432          * @param        $update @TODO Which type?
 433          * @param bool   $preview
 434          * @param string $order
 435          * @param int    $uid
 436          * @return string
 437          * @throws ImagickException
 438          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 439          */
 440         public function create(array $items, string $mode, $update, bool $preview = false, string $order = 'commented', int $uid = 0): string
 441         {
 442                 $this->profiler->startRecording('rendering');
 443
 444                 $this->page->registerFooterScript(Theme::getPathForFile('asset/typeahead.js/dist/typeahead.bundle.js'));
 445                 $this->page->registerFooterScript(Theme::getPathForFile('js/friendica-tagsinput/friendica-tagsinput.js'));
 446                 $this->page->registerStylesheet(Theme::getPathForFile('js/friendica-tagsinput/friendica-tagsinput.css'));
 447                 $this->page->registerStylesheet(Theme::getPathForFile('js/friendica-tagsinput/friendica-tagsinput-typeahead.css'));
 448
 449                 $live_update_div = '';
 450
 451                 $blocklist = $this->getBlocklist();
 452
 453                 $previewing = (($preview) ? ' preview ' : '');
 454
 455                 if ($mode === self::MODE_NETWORK) {
 456                         $items = $this->addChildren($items, false, $order, $uid, $mode);
 457                         if (!$update) {
 458                                 /*
 459                                 * The special div is needed for liveUpdate to kick in for this page.
 460                                 * We only launch liveUpdate if you aren't filtering in some incompatible
 461                                 * way and also you aren't writing a comment (discovered in javascript).
 462                                 */
 463                                 $live_update_div = '<div id="live-network"></div>' . "\r\n"
 464                                         . "<script> var profile_uid = " . $_SESSION['uid']
 465                                         . "; var netargs = '" . substr($this->args->getCommand(), 8)
 466                                         . '?f='
 467                                         . (!empty($_GET['contactid']) ? '&contactid=' . rawurlencode($_GET['contactid']) : '')
 468                                         . (!empty($_GET['search'])    ? '&search='    . rawurlencode($_GET['search'])    : '')
 469                                         . (!empty($_GET['star'])      ? '&star='      . rawurlencode($_GET['star'])      : '')
 470                                         . (!empty($_GET['order'])     ? '&order='     . rawurlencode($_GET['order'])     : '')
 471                                         . (!empty($_GET['bmark'])     ? '&bmark='     . rawurlencode($_GET['bmark'])     : '')
 472                                         . (!empty($_GET['liked'])     ? '&liked='     . rawurlencode($_GET['liked'])     : '')
 473                                         . (!empty($_GET['conv'])      ? '&conv='      . rawurlencode($_GET['conv'])      : '')
 474                                         . (!empty($_GET['nets'])      ? '&nets='      . rawurlencode($_GET['nets'])      : '')
 475                                         . (!empty($_GET['cmin'])      ? '&cmin='      . rawurlencode($_GET['cmin'])      : '')
 476                                         . (!empty($_GET['cmax'])      ? '&cmax='      . rawurlencode($_GET['cmax'])      : '')
 477                                         . (!empty($_GET['file'])      ? '&file='      . rawurlencode($_GET['file'])      : '')
 478
 479                                         . "'; </script>\r\n";
 480                         }
 481                 } elseif ($mode === self::MODE_PROFILE) {
 482                         $items = $this->addChildren($items, false, $order, $uid, $mode);
 483
 484                         if (!$update) {
 485                                 $tab = !empty($_GET['tab']) ? trim($_GET['tab']) : 'posts';
 486
 487                                 if ($tab === 'posts') {
 488                                         /*
 489                                         * This is ugly, but we can't pass the profile_uid through the session to the ajax updater,
 490                                         * because browser prefetching might change it on us. We have to deliver it with the page.
 491                                         */
 492
 493                                         $live_update_div = '<div id="live-profile"></div>' . "\r\n"
 494                                                 . "<script> var profile_uid = " . $uid
 495                                                 . "; var netargs = '?f='; </script>\r\n";
 496                                 }
 497                         }
 498                 } elseif ($mode === self::MODE_NOTES) {
 499                         $items = $this->addChildren($items, false, $order, $this->session->getLocalUserId(), $mode);
 500
 501                         if (!$update) {
 502                                 $live_update_div = '<div id="live-notes"></div>' . "\r\n"
 503                                         . "<script> var profile_uid = " . $this->session->getLocalUserId()
 504                                         . "; var netargs = '?f='; </script>\r\n";
 505                         }
 506                 } elseif ($mode === self::MODE_DISPLAY) {
 507                         $items = $this->addChildren($items, false, $order, $uid, $mode);
 508
 509                         if (!$update) {
 510                                 $live_update_div = '<div id="live-display"></div>' . "\r\n"
 511                                         . "<script> var profile_uid = " . ($this->session->getLocalUserId() ?: 0) . ";"
 512                                         . "</script>";
 513                         }
 514                 } elseif ($mode === self::MODE_COMMUNITY) {
 515                         $items = $this->addChildren($items, true, $order, $uid, $mode);
 516
 517                         if (!$update) {
 518                                 $live_update_div = '<div id="live-community"></div>' . "\r\n"
 519                                         . "<script> var profile_uid = -1; var netargs = '" . substr($this->args->getCommand(), 10)
 520                                         . '?f='
 521                                         . (!empty($_GET['no_sharer']) ? '&no_sharer=' . rawurlencode($_GET['no_sharer']) : '')
 522                                         . (!empty($_GET['accounttype']) ? '&accounttype=' . rawurlencode($_GET['accounttype']) : '')
 523                                         . "'; </script>\r\n";
 524                         }
 525                 } elseif ($mode === self::MODE_CONTACTS) {
 526                         $items = $this->addChildren($items, false, $order, $uid, $mode);
 527
 528                         if (!$update) {
 529                                 $live_update_div = '<div id="live-contact"></div>' . "\r\n"
 530                                         . "<script> var profile_uid = -1; var netargs = '" . substr($this->args->getCommand(), 8)
 531                                         ."?f='; </script>\r\n";
 532                         }
 533                 } elseif ($mode === self::MODE_SEARCH) {
 534                         $live_update_div = '<div id="live-search"></div>' . "\r\n";
 535                 }
 536
 537                 $page_dropping = $this->session->getLocalUserId() && $this->session->getLocalUserId() == $uid && $mode != self::MODE_SEARCH;
 538
 539                 if (!$update) {
 540                         $_SESSION['return_path'] = $this->args->getQueryString();
 541                 }
 542
 543                 $cb = ['items' => $items, 'mode' => $mode, 'update' => $update, 'preview' => $preview];
 544                 Hook::callAll('conversation_start', $cb);
 545
 546                 $items = $cb['items'];
 547
 548                 $conv_responses = [
 549                         'like'        => [],
 550                         'dislike'     => [],
 551                         'attendyes'   => [],
 552                         'attendno'    => [],
 553                         'attendmaybe' => [],
 554                         'announce'    => [],
 555                 ];
 556
 557                 if ($this->pConfig->get($this->session->getLocalUserId(), 'system', 'hide_dislike')) {
 558                         unset($conv_responses['dislike']);
 559                 }
 560
 561                 // array with html for each thread (parent+comments)
 562                 $threads   = [];
 563                 $threadsid = -1;
 564
 565                 $page_template     = Renderer::getMarkupTemplate("conversation.tpl");
 566                 $formSecurityToken = BaseModule::getFormSecurityToken('contact_action');
 567
 568                 if (!empty($items)) {
 569                         if (in_array($mode, [self::MODE_COMMUNITY, self::MODE_CONTACTS, self::MODE_PROFILE])) {
 570                                 $writable = true;
 571                         } else {
 572                                 $writable = $items[0]['writable'] || ($items[0]['uid'] == 0) && in_array($items[0]['network'], Protocol::FEDERATED);
 573                         }
 574
 575                         if (!$this->session->getLocalUserId()) {
 576                                 $writable = false;
 577                         }
 578
 579                         if (in_array($mode, [self::MODE_FILED, self::MODE_SEARCH, self::MODE_CONTACT_POSTS])) {
 580
 581                                 /*
 582                                 * "New Item View" on network page or search page results
 583                                 * - just loop through the items and format them minimally for display
 584                                 */
 585
 586                                 $tpl = 'search_item.tpl';
 587
 588                                 $uriids = [];
 589
 590                                 foreach ($items as $item) {
 591                                         if (in_array($item['uri-id'], $uriids)) {
 592                                                 continue;
 593                                         }
 594
 595                                         $uriids[] = $item['uri-id'];
 596
 597                                         if (!$this->item->isVisibleActivity($item)) {
 598                                                 continue;
 599                                         }
 600
 601                                         if (in_array($item['author-id'], $blocklist)) {
 602                                                 continue;
 603                                         }
 604
 605                                         $threadsid++;
 606
 607                                         // prevent private email from leaking.
 608                                         if ($item['network'] === Protocol::MAIL && $this->session->getLocalUserId() != $item['uid']) {
 609                                                 continue;
 610                                         }
 611
 612                                         $profile_name = $item['author-name'];
 613                                         if (!empty($item['author-link']) && empty($item['author-name'])) {
 614                                                 $profile_name = $item['author-link'];
 615                                         }
 616
 617                                         $tags = Tag::populateFromItem($item);
 618
 619                                         $author       = ['uid' => 0, 'id' => $item['author-id'], 'network' => $item['author-network'], 'url' => $item['author-link']];
 620                                         $profile_link = Contact::magicLinkByContact($author);
 621
 622                                         $sparkle = '';
 623                                         if (strpos($profile_link, 'contact/redir/') === 0) {
 624                                                 $sparkle = ' sparkle';
 625                                         }
 626
 627                                         $locate = ['location' => $item['location'], 'coord' => $item['coord'], 'html' => ''];
 628                                         Hook::callAll('render_location', $locate);
 629                                         $location_html = $locate['html'] ?: Strings::escapeHtml($locate['location'] ?: $locate['coord'] ?: '');
 630
 631                                         $this->item->localize($item);
 632                                         if ($mode === self::MODE_FILED) {
 633                                                 $dropping = true;
 634                                         } else {
 635                                                 $dropping = false;
 636                                         }
 637
 638                                         $drop = [
 639                                                 'dropping' => $dropping,
 640                                                 'pagedrop' => $page_dropping,
 641                                                 'select'   => $this->l10n->t('Select'),
 642                                                 'delete'   => $this->l10n->t('Delete'),
 643                                         ];
 644
 645                                         $likebuttons = [
 646                                                 'like'     => null,
 647                                                 'dislike'  => null,
 648                                                 'share'    => null,
 649                                                 'announce' => null,
 650                                         ];
 651
 652                                         if ($this->pConfig->get($this->session->getLocalUserId(), 'system', 'hide_dislike')) {
 653                                                 unset($likebuttons['dislike']);
 654                                         }
 655
 656                                         $body_html = ItemModel::prepareBody($item, true, $preview);
 657
 658                                         [$categories, $folders] = $this->item->determineCategoriesTerms($item, $this->session->getLocalUserId());
 659
 660                                         if (!empty($item['title'])) {
 661                                                 $title = $item['title'];
 662                                         } elseif (!empty($item['content-warning']) && $this->pConfig->get($this->session->getLocalUserId(), 'system', 'disable_cw', false)) {
 663                                                 $title = ucfirst($item['content-warning']);
 664                                         } else {
 665                                                 $title = '';
 666                                         }
 667
 668                                         if (!empty($item['featured'])) {
 669                                                 $pinned = $this->l10n->t('Pinned item');
 670                                         } else {
 671                                                 $pinned = '';
 672                                         }
 673
 674                                         $tmp_item = [
 675                                                 'template'             => $tpl,
 676                                                 'id'                   => ($preview ? 'P0' : $item['id']),
 677                                                 'guid'                 => ($preview ? 'Q0' : $item['guid']),
 678                                                 'commented'            => $item['commented'],
 679                                                 'received'             => $item['received'],
 680                                                 'created_date'         => $item['created'],
 681                                                 'uriid'                => $item['uri-id'],
 682                                                 'network'              => $item['network'],
 683                                                 'network_name'         => ContactSelector::networkToName($item['author-network'], $item['author-link'], $item['network'], $item['author-gsid']),
 684                                                 'network_icon'         => ContactSelector::networkToIcon($item['network'], $item['author-link'], $item['author-gsid']),
 685                                                 'linktitle'            => $this->l10n->t('View %s\'s profile @ %s', $profile_name, $item['author-link']),
 686                                                 'profile_url'          => $profile_link,
 687                                                 'item_photo_menu_html' => $this->item->photoMenu($item, $formSecurityToken),
 688                                                 'name'                 => $profile_name,
 689                                                 'sparkle'              => $sparkle,
 690                                                 'lock'                 => false,
 691                                                 'thumb'                => $this->baseURL->remove($this->item->getAuthorAvatar($item)),
 692                                                 'title'                => $title,
 693                                                 'body_html'            => $body_html,
 694                                                 'tags'                 => $tags['tags'],
 695                                                 'hashtags'             => $tags['hashtags'],
 696                                                 'mentions'             => $tags['mentions'],
 697                                                 'implicit_mentions'    => $tags['implicit_mentions'],
 698                                                 'txt_cats'             => $this->l10n->t('Categories:'),
 699                                                 'txt_folders'          => $this->l10n->t('Filed under:'),
 700                                                 'has_cats'             => ((count($categories)) ? 'true' : ''),
 701                                                 'has_folders'          => ((count($folders)) ? 'true' : ''),
 702                                                 'categories'           => $categories,
 703                                                 'folders'              => $folders,
 704                                                 'text'                 => strip_tags($body_html),
 705                                                 'localtime'            => DateTimeFormat::local($item['created'], 'r'),
 706                                                 'utc'                  => DateTimeFormat::utc($item['created'], 'c'),
 707                                                 'ago'                  => (($item['app']) ? $this->l10n->t('%s from %s', Temporal::getRelativeDate($item['created']), $item['app']) : Temporal::getRelativeDate($item['created'])),
 708                                                 'location_html'        => $location_html,
 709                                                 'indent'               => '',
 710                                                 'owner_name'           => '',
 711                                                 'owner_url'            => '',
 712                                                 'owner_photo'          => $this->baseURL->remove($this->item->getOwnerAvatar($item)),
 713                                                 'plink'                => ItemModel::getPlink($item),
 714                                                 'edpost'               => false,
 715                                                 'pinned'               => $pinned,
 716                                                 'isstarred'            => 'unstarred',
 717                                                 'star'                 => false,
 718                                                 'drop'                 => $drop,
 719                                                 'vote'                 => $likebuttons,
 720                                                 'like_html'            => '',
 721                                                 'dislike_html '        => '',
 722                                                 'comment_html'         => '',
 723                                                 'conv'                 => ($preview ? '' : ['href' => 'display/' . $item['guid'], 'title' => $this->l10n->t('View in context')]),
 724                                                 'previewing'           => $previewing,
 725                                                 'wait'                 => $this->l10n->t('Please wait'),
 726                                                 'thread_level'         => 1,
 727                                         ];
 728
 729                                         $arr = ['item' => $item, 'output' => $tmp_item];
 730                                         Hook::callAll('display_item', $arr);
 731
 732                                         $threads[$threadsid]['id']      = $item['id'];
 733                                         $threads[$threadsid]['network'] = $item['network'];
 734                                         $threads[$threadsid]['items']   = [$arr['output']];
 735                                 }
 736                         } else {
 737                                 // Normal View
 738                                 $page_template = Renderer::getMarkupTemplate("threaded_conversation.tpl");
 739
 740                                 $conv = new Thread($mode, $preview, $writable);
 741
 742                                 /*
 743                                 * get all the topmost parents
 744                                 * this shouldn't be needed, as we should have only them in our array
 745                                 * But for now, this array respects the old style, just in case
 746                                 */
 747                                 foreach ($items as $item) {
 748                                         if (in_array($item['author-id'], $blocklist)) {
 749                                                 continue;
 750                                         }
 751
 752                                         // Can we put this after the visibility check?
 753                                         $this->builtinActivityPuller($item, $conv_responses);
 754
 755                                         // Only add what is visible
 756                                         if ($item['network'] === Protocol::MAIL && $this->session->getLocalUserId() != $item['uid']) {
 757                                                 continue;
 758                                         }
 759
 760                                         if (!$this->item->isVisibleActivity($item)) {
 761                                                 continue;
 762                                         }
 763
 764                                         /// @todo Check if this call is needed or not
 765                                         $arr = ['item' => $item];
 766                                         Hook::callAll('display_item', $arr);
 767
 768                                         $item['pagedrop'] = $page_dropping;
 769
 770                                         if ($item['gravity'] == ItemModel::GRAVITY_PARENT) {
 771                                                 $item_object = new PostObject($item);
 772                                                 $conv->addParent($item_object);
 773                                         }
 774                                 }
 775
 776                                 $threads = $conv->getTemplateData($conv_responses, $formSecurityToken);
 777                                 if (!$threads) {
 778                                         $this->logger->info('[ERROR] conversation : Failed to get template data.');
 779                                         $threads = [];
 780                                 }
 781                         }
 782                 }
 783
 784                 $o = Renderer::replaceMacros($page_template, [
 785                         '$baseurl'     => $this->baseURL,
 786                         '$return_path' => $this->args->getQueryString(),
 787                         '$live_update' => $live_update_div,
 788                         '$remove'      => $this->l10n->t('remove'),
 789                         '$mode'        => $mode,
 790                         '$update'      => $update,
 791                         '$threads'     => $threads,
 792                         '$dropping'    => ($page_dropping ? $this->l10n->t('Delete Selected Items') : false),
 793                 ]);
 794
 795                 $this->profiler->stopRecording();
 796                 return $o;
 797         }
 798
 799         private function getBlocklist(): array
 800         {
 801                 if (!$this->session->getLocalUserId()) {
 802                         return [];
 803                 }
 804
 805                 $str_blocked = str_replace(["\n", "\r"], ",", $this->pConfig->get($this->session->getLocalUserId(), 'system', 'blocked') ?? '');
 806                 if (empty($str_blocked)) {
 807                         return [];
 808                 }
 809
 810                 $blocklist = [];
 811
 812                 foreach (explode(',', $str_blocked) as $entry) {
 813                         $cid = Contact::getIdForURL(trim($entry), 0, false);
 814                         if (!empty($cid)) {
 815                                 $blocklist[] = $cid;
 816                         }
 817                 }
 818
 819                 return $blocklist;
 820         }
 821
 822         /**
 823          * Adds some information (Causer, post reason, direction) to the fetched post row.
 824          *
 825          * @param array   $row        Post row
 826          * @param array   $activity   Contact data of the resharer
 827          * @param array   $thr_parent Thread parent row
 828          *
 829          * @return array items with parents and comments
 830          */
 831         private function addRowInformation(array $row, array $activity, array $thr_parent): array
 832         {
 833                 $this->profiler->startRecording('rendering');
 834
 835                 if (!$row['writable']) {
 836                         $row['writable'] = in_array($row['network'], Protocol::FEDERATED);
 837                 }
 838
 839                 if (!empty($activity)) {
 840                         if (($row['gravity'] == ItemModel::GRAVITY_PARENT)) {
 841                                 $row['post-reason'] = ItemModel::PR_ANNOUNCEMENT;
 842
 843                                 $row     = array_merge($row, $activity);
 844                                 $contact = Contact::getById($activity['causer-id'], ['url', 'name', 'thumb']);
 845
 846                                 $row['causer-link']   = $contact['url'];
 847                                 $row['causer-avatar'] = $contact['thumb'];
 848                                 $row['causer-name']   = $contact['name'];
 849                         } elseif (($row['gravity'] == ItemModel::GRAVITY_ACTIVITY) && ($row['verb'] == Activity::ANNOUNCE) &&
 850                                 ($row['author-id'] == $activity['causer-id'])) {
 851                                 return $row;
 852                         }
 853                 }
 854
 855                 switch ($row['post-reason']) {
 856                         case ItemModel::PR_TO:
 857                                 $row['direction'] = ['direction' => 7, 'title' => $this->l10n->t('You had been addressed (%s).', 'to')];
 858                                 break;
 859                         case ItemModel::PR_CC:
 860                                 $row['direction'] = ['direction' => 7, 'title' => $this->l10n->t('You had been addressed (%s).', 'cc')];
 861                                 break;
 862                         case ItemModel::PR_BTO:
 863                                 $row['direction'] = ['direction' => 7, 'title' => $this->l10n->t('You had been addressed (%s).', 'bto')];
 864                                 break;
 865                         case ItemModel::PR_BCC:
 866                                 $row['direction'] = ['direction' => 7, 'title' => $this->l10n->t('You had been addressed (%s).', 'bcc')];
 867                                 break;
 868                         case ItemModel::PR_FOLLOWER:
 869                                 $row['direction'] = ['direction' => 6, 'title' => $this->l10n->t('You are following %s.', $row['causer-name'] ?: $row['author-name'])];
 870                                 break;
 871                         case ItemModel::PR_TAG:
 872                                 $row['direction'] = ['direction' => 4, 'title' => $this->l10n->t('You subscribed to one or more tags in this post.')];
 873                                 break;
 874                         case ItemModel::PR_ANNOUNCEMENT:
 875                                 if (!empty($row['causer-id']) && $this->pConfig->get($this->session->getLocalUserId(), 'system', 'display_resharer')) {
 876                                         $row['owner-id']     = $row['causer-id'];
 877                                         $row['owner-link']   = $row['causer-link'];
 878                                         $row['owner-avatar'] = $row['causer-avatar'];
 879                                         $row['owner-name']   = $row['causer-name'];
 880                                 }
 881
 882                                 if (in_array($row['gravity'], [ItemModel::GRAVITY_PARENT, ItemModel::GRAVITY_COMMENT]) && !empty($row['causer-id'])) {
 883                                         $causer = ['uid' => 0, 'id' => $row['causer-id'], 'network' => $row['causer-network'], 'url' => $row['causer-link']];
 884
 885                                         $row['reshared'] = $this->l10n->t('%s reshared this.', '<a href="'. htmlentities(Contact::magicLinkByContact($causer)) .'">' . htmlentities($row['causer-name']) . '</a>');
 886                                 }
 887                                 $row['direction'] = ['direction' => 3, 'title' => (empty($row['causer-id']) ? $this->l10n->t('Reshared') : $this->l10n->t('Reshared by %s <%s>', $row['causer-name'], $row['causer-link']))];
 888                                 break;
 889                         case ItemModel::PR_COMMENT:
 890                                 $row['direction'] = ['direction' => 5, 'title' => $this->l10n->t('%s is participating in this thread.', $row['author-name'])];
 891                                 break;
 892                         case ItemModel::PR_STORED:
 893                                 $row['direction'] = ['direction' => 8, 'title' => $this->l10n->t('Stored for general reasons')];
 894                                 break;
 895                         case ItemModel::PR_GLOBAL:
 896                                 $row['direction'] = ['direction' => 9, 'title' => $this->l10n->t('Global post')];
 897                                 break;
 898                         case ItemModel::PR_RELAY:
 899                                 $row['direction'] = ['direction' => 10, 'title' => (empty($row['causer-id']) ? $this->l10n->t('Sent via an relay server') : $this->l10n->t('Sent via the relay server %s <%s>', $row['causer-name'], $row['causer-link']))];
 900                                 break;
 901                         case ItemModel::PR_FETCHED:
 902                                 $row['direction'] = ['direction' => 2, 'title' => (empty($row['causer-id']) ? $this->l10n->t('Fetched') : $this->l10n->t('Fetched because of %s <%s>', $row['causer-name'], $row['causer-link']))];
 903                                 break;
 904                         case ItemModel::PR_COMPLETION:
 905                                 $row['direction'] = ['direction' => 2, 'title' => $this->l10n->t('Stored because of a child post to complete this thread.')];
 906                                 break;
 907                         case ItemModel::PR_DIRECT:
 908                                 $row['direction'] = ['direction' => 6, 'title' => $this->l10n->t('Local delivery')];
 909                                 break;
 910                         case ItemModel::PR_ACTIVITY:
 911                                 $row['direction'] = ['direction' => 2, 'title' => $this->l10n->t('Stored because of your activity (like, comment, star, ...)')];
 912                                 break;
 913                         case ItemModel::PR_DISTRIBUTE:
 914                                 $row['direction'] = ['direction' => 6, 'title' => $this->l10n->t('Distributed')];
 915                                 break;
 916                         case ItemModel::PR_PUSHED:
 917                                 $row['direction'] = ['direction' => 1, 'title' => $this->l10n->t('Pushed to us')];
 918                                 break;
 919                 }
 920
 921                 $row['thr-parent-row'] = $thr_parent;
 922
 923                 $this->profiler->stopRecording();
 924                 return $row;
 925         }
 926
 927         /**
 928          * Add comments to top level entries that had been fetched before
 929          *
 930          * The system will fetch the comments for the local user whenever possible.
 931          * This behaviour is currently needed to allow commenting on Friendica posts.
 932          *
 933          * @param array  $parents       Parent items
 934          * @param bool   $block_authors
 935          * @param bool   $order
 936          * @param int    $uid
 937          * @param string $mode
 938          * @return array items with parents and comments
 939          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 940          */
 941         private function addChildren(array $parents, bool $block_authors, string $order, int $uid, string $mode): array
 942         {
 943                 $this->profiler->startRecording('rendering');
 944                 if (count($parents) > 1) {
 945                         $max_comments = $this->config->get('system', 'max_comments', 100);
 946                 } else {
 947                         $max_comments = $this->config->get('system', 'max_display_comments', 1000);
 948                 }
 949
 950                 $activities      = [];
 951                 $uriids          = [];
 952                 $commentcounter  = [];
 953                 $activitycounter = [];
 954
 955                 foreach ($parents as $parent) {
 956                         if (!empty($parent['thr-parent-id']) && !empty($parent['gravity']) && ($parent['gravity'] == ItemModel::GRAVITY_ACTIVITY)) {
 957                                 $uriid = $parent['thr-parent-id'];
 958                                 if (!empty($parent['author-id'])) {
 959                                         $activities[$uriid] = ['causer-id' => $parent['author-id']];
 960                                         foreach (['commented', 'received', 'created'] as $orderfields) {
 961                                                 if (!empty($parent[$orderfields])) {
 962                                                         $activities[$uriid][$orderfields] = $parent[$orderfields];
 963                                                 }
 964                                         }
 965                                 }
 966                         } else {
 967                                 $uriid = $parent['uri-id'];
 968                         }
 969                         $uriids[] = $uriid;
 970
 971                         $commentcounter[$uriid]  = 0;
 972                         $activitycounter[$uriid] = 0;
 973                 }
 974
 975                 $condition = ['parent-uri-id' => $uriids];
 976                 if ($block_authors) {
 977                         $condition['author-hidden'] = false;
 978                 }
 979
 980                 if ($this->config->get('system', 'emoji_activities')) {
 981                         $emojis = $this->getEmojis($uriids);
 982                         $condition = DBA::mergeConditions($condition, ["(`gravity` != ? OR `origin`)", ItemModel::GRAVITY_ACTIVITY]);
 983                 }
 984
 985                 $condition = DBA::mergeConditions($condition,
 986                         ["`uid` IN (0, ?) AND (NOT `vid` IN (?, ?, ?) OR `vid` IS NULL)", $uid, Verb::getID(Activity::FOLLOW), Verb::getID(Activity::VIEW), Verb::getID(Activity::READ)]);
 987
 988                 $condition = DBA::mergeConditions($condition, ["(`uid` != ? OR `private` != ?)", 0, ItemModel::PRIVATE]);
 989
 990                 $condition = DBA::mergeConditions($condition,
 991                         ["`visible` AND NOT `deleted` AND NOT `author-blocked` AND NOT `owner-blocked`
 992                         AND ((NOT `contact-pending` AND (`contact-rel` IN (?, ?))) OR `self` OR `contact-uid` = ?)",
 993                         Contact::SHARING, Contact::FRIEND, 0]);
 994
 995                 $thread_parents = Post::select(['uri-id', 'causer-id'], $condition, ['order' => ['uri-id' => false, 'uid']]);
 996
 997                 $thr_parent = [];
 998
 999                 while ($row = Post::fetch($thread_parents)) {
1000                         $thr_parent[$row['uri-id']] = $row;
1001                 }
1002                 DBA::close($thread_parents);
1003
1004                 $params = ['order' => ['uri-id' => true, 'uid' => true]];
1005
1006                 $thread_items = Post::select(array_merge(ItemModel::DISPLAY_FIELDLIST, ['featured', 'contact-uid', 'gravity', 'post-type', 'post-reason']), $condition, $params);
1007
1008                 $items         = [];
1009                 $quote_uri_ids = [];
1010                 $authors       = [];
1011
1012                 while ($row = Post::fetch($thread_items)) {
1013                         if (!empty($items[$row['uri-id']]) && ($row['uid'] == 0)) {
1014                                 continue;
1015                         }
1016
1017                         if (($mode != self::MODE_CONTACTS) && !$row['origin']) {
1018                                 $row['featured'] = false;
1019                         }
1020
1021                         if ($max_comments > 0) {
1022                                 if (($row['gravity'] == ItemModel::GRAVITY_COMMENT) && (++$commentcounter[$row['parent-uri-id']] > $max_comments)) {
1023                                         continue;
1024                                 }
1025                                 if (($row['gravity'] == ItemModel::GRAVITY_ACTIVITY) && (++$activitycounter[$row['parent-uri-id']] > $max_comments)) {
1026                                         continue;
1027                                 }
1028                         }
1029
1030                         $authors[] = $row['author-id'];
1031                         $authors[] = $row['owner-id'];
1032
1033                         if (in_array($row['gravity'], [ItemModel::GRAVITY_PARENT, ItemModel::GRAVITY_COMMENT])) {
1034                                 $quote_uri_ids[$row['uri-id']] = [
1035                                         'uri-id'        => $row['uri-id'],
1036                                         'uri'           => $row['uri'],
1037                                         'parent-uri-id' => $row['parent-uri-id'],
1038                                         'parent-uri'    => $row['parent-uri'],
1039                                 ];
1040                         }
1041
1042                         $items[$row['uri-id']] = $this->addRowInformation($row, $activities[$row['uri-id']] ?? [], $thr_parent[$row['thr-parent-id']] ?? []);
1043                 }
1044
1045                 DBA::close($thread_items);
1046
1047                 $quotes = Post::select(array_merge(ItemModel::DISPLAY_FIELDLIST, ['featured', 'contact-uid', 'gravity', 'post-type', 'post-reason']), ['quote-uri-id' => array_column($quote_uri_ids, 'uri-id'), 'body' => '', 'uid' => 0]);
1048                 while ($quote = Post::fetch($quotes)) {
1049                         $row = $quote;
1050
1051                         $row['uid']           = $uid;
1052                         $row['verb']          = $row['body'] = $row['raw-body'] = Activity::ANNOUNCE;
1053                         $row['gravity']       = ItemModel::GRAVITY_ACTIVITY;
1054                         $row['object-type']   = Activity\ObjectType::NOTE;
1055                         $row['parent-uri']    = $quote_uri_ids[$quote['quote-uri-id']]['parent-uri'];
1056                         $row['parent-uri-id'] = $quote_uri_ids[$quote['quote-uri-id']]['parent-uri-id'];
1057                         $row['thr-parent']    = $quote_uri_ids[$quote['quote-uri-id']]['uri'];
1058                         $row['thr-parent-id'] = $quote_uri_ids[$quote['quote-uri-id']]['uri-id'];
1059
1060                         $authors[] = $row['author-id'];
1061                         $authors[] = $row['owner-id'];
1062
1063                         $items[$row['uri-id']] = $this->addRowInformation($row, [], []);
1064                 }
1065                 DBA::close($quotes);
1066
1067                 $authors = array_unique($authors);
1068
1069                 $blocks    = [];
1070                 $ignores   = [];
1071                 $collapses = [];
1072                 if (!empty($authors)) {
1073                         $usercontacts = DBA::select('user-contact', ['cid', 'blocked', 'ignored', 'collapsed'], ['uid' => $uid, 'cid' => $authors]);
1074                         while ($usercontact = DBA::fetch($usercontacts)) {
1075                                 if ($usercontact['blocked']) {
1076                                         $blocks[] = $usercontact['cid'];
1077                                 }
1078                                 if ($usercontact['ignored']) {
1079                                         $ignores[] = $usercontact['cid'];
1080                                 }
1081                                 if ($usercontact['collapsed']) {
1082                                         $collapses[] = $usercontact['cid'];
1083                                 }
1084                         }
1085                         DBA::close($usercontacts);
1086                 }
1087
1088                 foreach ($items as $key => $row) {
1089                         $items[$key]['emojis'] = $emojis[$key] ?? [];
1090
1091                         $always_display = in_array($mode, [self::MODE_CONTACTS, self::MODE_CONTACT_POSTS]);
1092
1093                         $items[$key]['user-blocked-author']   = !$always_display && in_array($row['author-id'], $blocks);
1094                         $items[$key]['user-ignored-author']   = !$always_display && in_array($row['author-id'], $ignores);
1095                         $items[$key]['user-blocked-owner']    = !$always_display && in_array($row['owner-id'], $blocks);
1096                         $items[$key]['user-ignored-owner']    = !$always_display && in_array($row['owner-id'], $ignores);
1097                         $items[$key]['user-collapsed-author'] = !$always_display && in_array($row['author-id'], $collapses);
1098                         $items[$key]['user-collapsed-owner']  = !$always_display && in_array($row['owner-id'], $collapses);
1099
1100                         if (in_array($mode, [self::MODE_COMMUNITY, self::MODE_NETWORK]) &&
1101                                 (in_array($row['author-id'], $blocks) || in_array($row['owner-id'], $blocks) || in_array($row['author-id'], $ignores) || in_array($row['owner-id'], $ignores))) {
1102                                 unset($items[$key]);
1103                         }
1104                 }
1105
1106                 $items = $this->convSort($items, $order);
1107
1108                 $this->profiler->stopRecording();
1109                 return $items;
1110         }
1111
1112         /**
1113          * Fetch emoji reaction from the conversation
1114          *
1115          * @param array $uriids
1116          * @return array
1117          */
1118         private function getEmojis(array $uriids): array
1119         {
1120                 $activity_emoji = [
1121                         Activity::LIKE        => '👍',
1122                         Activity::DISLIKE     => '👎',
1123                         Activity::ATTEND      => '✔️',
1124                         Activity::ATTENDMAYBE => '❓',
1125                         Activity::ATTENDNO    => '❌',
1126                         Activity::ANNOUNCE    => '♻',
1127                         Activity::VIEW        => '📺',
1128                 ];
1129
1130                 $index_list = array_values($activity_emoji);
1131                 $verbs      = array_merge(array_keys($activity_emoji), [Activity::EMOJIREACT]);
1132
1133                 $condition = DBA::mergeConditions(['parent-uri-id' => $uriids, 'gravity' => ItemModel::GRAVITY_ACTIVITY, 'verb' => $verbs], ["NOT `deleted`"]);
1134                 $separator = chr(255) . chr(255) . chr(255);
1135
1136                 $sql = "SELECT `thr-parent-id`, `body`, `verb`, COUNT(*) AS `total`, GROUP_CONCAT(REPLACE(`author-name`, '" . $separator . "', ' ') SEPARATOR '". $separator ."' LIMIT 50) AS `title` FROM `post-view` WHERE " . array_shift($condition) . " GROUP BY `thr-parent-id`, `verb`, `body`";
1137
1138                 $emojis = [];
1139
1140                 $rows = DBA::p($sql, $condition);
1141                 while ($row = DBA::fetch($rows)) {
1142                         $row['verb'] = $row['body'] ? Activity::EMOJIREACT : $row['verb'];
1143                         $emoji       = $row['body'] ?: $activity_emoji[$row['verb']];
1144                         if (!isset($index_list[$emoji])) {
1145                                 $index_list[] = $emoji;
1146                         }
1147                         $index = array_search($emoji, $index_list);
1148
1149                         $emojis[$row['thr-parent-id']][$index]['emoji'] = $emoji;
1150                         $emojis[$row['thr-parent-id']][$index]['verb']  = $row['verb'];
1151                         $emojis[$row['thr-parent-id']][$index]['total'] = ($emojis[$row['thr-parent-id']][$index]['total'] ?? 0) + $row['total'];
1152                         $emojis[$row['thr-parent-id']][$index]['title'] = array_unique(array_merge($emojis[$row['thr-parent-id']][$index]['title'] ?? [], explode($separator, $row['title'])));
1153                 }
1154                 DBA::close($rows);
1155
1156                 return $emojis;
1157         }
1158
1159         /**
1160          * Plucks the children of the given parent from a given item list.
1161          *
1162          * @param array $item_list
1163          * @param array $parent
1164          * @param bool  $recursive
1165          * @return array
1166          */
1167         private function getItemChildren(array &$item_list, array $parent, bool $recursive = true): array
1168         {
1169                 $this->profiler->startRecording('rendering');
1170                 $children = [];
1171                 foreach ($item_list as $i => $item) {
1172                         if ($item['gravity'] != ItemModel::GRAVITY_PARENT) {
1173                                 if ($recursive) {
1174                                         // Fallback to parent-uri if thr-parent is not set
1175                                         $thr_parent = $item['thr-parent-id'];
1176                                         if ($thr_parent == '') {
1177                                                 $thr_parent = $item['parent-uri-id'];
1178                                         }
1179
1180                                         if ($thr_parent == $parent['uri-id']) {
1181                                                 $item['children'] = $this->getItemChildren($item_list, $item);
1182
1183                                                 $children[] = $item;
1184                                                 unset($item_list[$i]);
1185                                         }
1186                                 } elseif ($item['parent-uri-id'] == $parent['uri-id']) {
1187                                         $children[] = $item;
1188                                         unset($item_list[$i]);
1189                                 }
1190                         }
1191                 }
1192                 $this->profiler->stopRecording();
1193                 return $children;
1194         }
1195
1196         /**
1197          * Recursively sorts a tree-like item array
1198          *
1199          * @param array $items
1200          * @return array
1201          */
1202         private function sortItemChildren(array $items): array
1203         {
1204                 $this->profiler->startRecording('rendering');
1205                 $result = $items;
1206                 usort($result, [$this, 'sortThrReceivedRev']);
1207                 foreach ($result as $k => $i) {
1208                         if (isset($result[$k]['children'])) {
1209                                 $result[$k]['children'] = $this->sortItemChildren($result[$k]['children']);
1210                         }
1211                 }
1212                 $this->profiler->stopRecording();
1213                 return $result;
1214         }
1215
1216         /**
1217          * Recursively add all children items at the top level of a list
1218          *
1219          * @param array $children List of items to append
1220          * @param array $item_list
1221          */
1222         private function addChildrenToList(array $children, array &$item_list)
1223         {
1224                 foreach ($children as $child) {
1225                         $item_list[] = $child;
1226                         if (isset($child['children'])) {
1227                                 $this->addChildrenToList($child['children'], $item_list);
1228                         }
1229                 }
1230         }
1231
1232         /**
1233          * Selectively flattens a tree-like item structure to prevent threading stairs
1234          *
1235          * This recursive function takes the item tree structure created by conv_sort() and
1236          * flatten the extraneous depth levels when people reply sequentially, removing the
1237          * stairs effect in threaded conversations limiting the available content width.
1238          *
1239          * The basic principle is the following: if a post item has only one reply and is
1240          * the last reply of its parent, then the reply is moved to the parent.
1241          *
1242          * This process is rendered somewhat more complicated because items can be either
1243          * replies or likes, and these don't factor at all in the reply count/last reply.
1244          *
1245          * @param array $parent A tree-like array of items
1246          * @return array
1247          */
1248         private function smartFlattenConversation(array $parent): array
1249         {
1250                 $this->profiler->startRecording('rendering');
1251                 if (!isset($parent['children']) || count($parent['children']) == 0) {
1252                         $this->profiler->stopRecording();
1253                         return $parent;
1254                 }
1255
1256                 // We use a for loop to ensure we process the newly-moved items
1257                 for ($i = 0; $i < count($parent['children']); $i++) {
1258                         $child = $parent['children'][$i];
1259
1260                         if (isset($child['children']) && count($child['children'])) {
1261                                 // This helps counting only the regular posts
1262                                 $count_post_closure = function ($var) {
1263                                         $this->profiler->stopRecording();
1264                                         return $var['verb'] === Activity::POST;
1265                                 };
1266
1267                                 $child_post_count = count(array_filter($child['children'], $count_post_closure));
1268
1269                                 $remaining_post_count = count(array_filter(array_slice($parent['children'], $i), $count_post_closure));
1270
1271                                 // If there's only one child's children post and this is the last child post
1272                                 if ($child_post_count == 1 && $remaining_post_count == 1) {
1273
1274                                         // Searches the post item in the children
1275                                         $j = 0;
1276                                         while ($child['children'][$j]['verb'] !== Activity::POST && $j < count($child['children'])) {
1277                                                 $j ++;
1278                                         }
1279
1280                                         $moved_item = $child['children'][$j];
1281                                         unset($parent['children'][$i]['children'][$j]);
1282                                         $parent['children'][] = $moved_item;
1283                                 } else {
1284                                         $parent['children'][$i] = $this->smartFlattenConversation($child);
1285                                 }
1286                         }
1287                 }
1288
1289                 $this->profiler->stopRecording();
1290                 return $parent;
1291         }
1292
1293         /**
1294          * Expands a flat list of items into corresponding tree-like conversation structures.
1295          *
1296          * sort the top-level posts either on "received" or "commented", and finally
1297          * append all the items at the top level (???)
1298          *
1299          * @param array  $item_list A list of items belonging to one or more conversations
1300          * @param string $order     Either on "received" or "commented"
1301          * @return array
1302          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
1303          */
1304         private function convSort(array $item_list, string $order): array
1305         {
1306                 $this->profiler->startRecording('rendering');
1307                 $parents = [];
1308
1309                 if (!(is_array($item_list) && count($item_list))) {
1310                         $this->profiler->stopRecording();
1311                         return $parents;
1312                 }
1313
1314                 $blocklist = $this->getBlocklist();
1315
1316                 $item_array = [];
1317
1318                 // Dedupes the item list on the uri to prevent infinite loops
1319                 foreach ($item_list as $item) {
1320                         if (in_array($item['author-id'], $blocklist)) {
1321                                 continue;
1322                         }
1323
1324                         $item_array[$item['uri-id']] = $item;
1325                 }
1326
1327                 // Extract the top level items
1328                 foreach ($item_array as $item) {
1329                         if ($item['gravity'] == ItemModel::GRAVITY_PARENT) {
1330                                 $parents[] = $item;
1331                         }
1332                 }
1333
1334                 if (stristr($order, 'pinned_received')) {
1335                         usort($parents, [$this, 'sortThrFeaturedReceived']);
1336                 } elseif (stristr($order, 'pinned_commented')) {
1337                         usort($parents, [$this, 'sortThrFeaturedCommented']);
1338                 } elseif (stristr($order, 'received')) {
1339                         usort($parents, [$this, 'sortThrReceived']);
1340                 } elseif (stristr($order, 'commented')) {
1341                         usort($parents, [$this, 'sortThrCommented']);
1342                 } elseif (stristr($order, 'created')) {
1343                         usort($parents, [$this, 'sortThrCreated']);
1344                 }
1345
1346                 /*
1347                 * Plucks children from the item_array, second pass collects eventual orphan
1348                 * items and add them as children of their top-level post.
1349                 */
1350                 foreach ($parents as $i => $parent) {
1351                         $parents[$i]['children'] = array_merge($this->getItemChildren($item_array, $parent, true),
1352                                 $this->getItemChildren($item_array, $parent, false));
1353                 }
1354
1355                 foreach ($parents as $i => $parent) {
1356                         $parents[$i]['children'] = $this->sortItemChildren($parents[$i]['children']);
1357                 }
1358
1359                 if (!$this->pConfig->get($this->session->getLocalUserId(), 'system', 'no_smart_threading', 0)) {
1360                         foreach ($parents as $i => $parent) {
1361                                 $parents[$i] = $this->smartFlattenConversation($parent);
1362                         }
1363                 }
1364
1365                 /// @TODO: Stop recursively adding all children back to the top level (!!!)
1366                 /// However, this apparently ensures responses (likes, attendance) display (?!)
1367                 foreach ($parents as $parent) {
1368                         if (count($parent['children'])) {
1369                                 $this->addChildrenToList($parent['children'], $parents);
1370                         }
1371                 }
1372
1373                 $this->profiler->stopRecording();
1374                 return $parents;
1375         }
1376
1377         /**
1378          * usort() callback to sort item arrays by featured and the received key
1379          *
1380          * @param array $a
1381          * @param array $b
1382          * @return int
1383          */
1384         private function sortThrFeaturedReceived(array $a, array $b): int
1385         {
1386                 if ($b['featured'] && !$a['featured']) {
1387                         return 1;
1388                 } elseif (!$b['featured'] && $a['featured']) {
1389                         return -1;
1390                 }
1391
1392                 return strcmp($b['received'], $a['received']);
1393         }
1394
1395         /**
1396          * usort() callback to sort item arrays by featured and the received key
1397          *
1398          * @param array $a
1399          * @param array $b
1400          * @return int
1401          */
1402         private function sortThrFeaturedCommented(array $a, array $b): int
1403         {
1404                 if ($b['featured'] && !$a['featured']) {
1405                         return 1;
1406                 } elseif (!$b['featured'] && $a['featured']) {
1407                         return -1;
1408                 }
1409
1410                 return strcmp($b['commented'], $a['commented']);
1411         }
1412
1413         /**
1414          * usort() callback to sort item arrays by the received key
1415          *
1416          * @param array $a
1417          * @param array $b
1418          * @return int
1419          */
1420         private function sortThrReceived(array $a, array $b): int
1421         {
1422                 return strcmp($b['received'], $a['received']);
1423         }
1424
1425         /**
1426          * usort() callback to reverse sort item arrays by the received key
1427          *
1428          * @param array $a
1429          * @param array $b
1430          * @return int
1431          */
1432         private function sortThrReceivedRev(array $a, array $b): int
1433         {
1434                 return strcmp($a['received'], $b['received']);
1435         }
1436
1437         /**
1438          * usort() callback to sort item arrays by the commented key
1439          *
1440          * @param array $a
1441          * @param array $b
1442          * @return int
1443          */
1444         private function sortThrCommented(array $a, array $b): int
1445         {
1446                 return strcmp($b['commented'], $a['commented']);
1447         }
1448
1449         /**
1450          * usort() callback to sort item arrays by the created key
1451          *
1452          * @param array $a
1453          * @param array $b
1454          * @return int
1455          */
1456         private function sortThrCreated(array $a, array $b): int
1457         {
1458                 return strcmp($b['created'], $a['created']);
1459         }
1460 }