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