Performance improvements when displaying local posts
[friendica.git/.git] / src / Module / Api / Mastodon / Timelines / PublicTimeline.php
1 <?php
2 /**
3  * @copyright Copyright (C) 2010-2024, 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\Module\Api\Mastodon\Timelines;
23
24 use Friendica\Core\Logger;
25 use Friendica\Core\Protocol;
26 use Friendica\Database\DBA;
27 use Friendica\DI;
28 use Friendica\Model\Item;
29 use Friendica\Model\Post;
30 use Friendica\Module\BaseApi;
31 use Friendica\Network\HTTPException;
32 use Friendica\Object\Api\Mastodon\TimelineOrderByTypes;
33
34 /**
35  * @see https://docs.joinmastodon.org/methods/timelines/
36  */
37 class PublicTimeline extends BaseApi
38 {
39         /**
40          * @throws HTTPException\InternalServerErrorException
41          */
42         protected function rawContent(array $request = [])
43         {
44                 $uid = self::getCurrentUserID();
45
46                 $request = $this->getRequest([
47                         'max_id'          => null,  // Return results older than id
48                         'since_id'        => null,  // Return results newer than id
49                         'min_id'          => null,  // Return results immediately newer than id
50                         'limit'           => 20,    // Maximum number of results to return. Defaults to 20.
51                         'local'           => false, // Show only local statuses? Defaults to false.
52                         'remote'          => false, // Show only remote statuses? Defaults to false.
53                         'only_media'      => false, // Show only statuses with media attached? Defaults to false.
54                         'with_muted'      => false, // Pleroma extension: return activities by muted (not by blocked!) users.
55                         'exclude_replies' => false, // Don't show comments
56                         'friendica_order' => TimelineOrderByTypes::ID, // Sort order options (defaults to ID)
57                 ], $request);
58
59                 $condition = [
60                         'gravity' => [Item::GRAVITY_PARENT, Item::GRAVITY_COMMENT], 'private' => Item::PUBLIC,
61                         'network' => Protocol::FEDERATED, 'author-blocked' => false, 'author-hidden' => false
62                 ];
63
64                 $condition = $this->addPagingConditions($request, $condition);
65                 $params = $this->buildOrderAndLimitParams($request);
66
67                 if ($request['local']) {
68                         $condition = DBA::mergeConditions($condition, ['origin' => true]);
69                 } else {
70                         $condition = DBA::mergeConditions($condition, ['uid' => 0]);
71                 }
72
73                 if ($request['remote']) {
74                         $condition = DBA::mergeConditions($condition, ["NOT `uri-id` IN (SELECT `uri-id` FROM `post-user` WHERE `origin` AND `post-user`.`uri-id` = `post-timeline-view`.`uri-id`)"]);
75                 }
76
77                 if ($request['only_media']) {
78                         $condition = DBA::mergeConditions($condition, [
79                                 "`uri-id` IN (SELECT `uri-id` FROM `post-media` WHERE `type` IN (?, ?, ?))",
80                                 Post\Media::AUDIO, Post\Media::IMAGE, Post\Media::VIDEO
81                         ]);
82                 }
83
84                 if ($request['exclude_replies']) {
85                         $condition = DBA::mergeConditions($condition, ['gravity' => Item::GRAVITY_PARENT]);
86                 }
87
88                 if ($request['local']) {
89                         $items = Post::selectLocalTimelineForUser($uid, ['uri-id'], $condition, $params);
90                 } else {
91                         $items = Post::selectTimelineForUser($uid, ['uri-id'], $condition, $params);
92                 }
93
94                 $display_quotes = self::appSupportsQuotes();
95
96                 $statuses = [];
97                 while ($item = Post::fetch($items)) {
98                         try {
99                                 $status =  DI::mstdnStatus()->createFromUriId($item['uri-id'], $uid, $display_quotes);
100                                 $this->updateBoundaries($status, $item, $request['friendica_order']);
101                                 $statuses[] = $status;
102                         } catch (\Throwable $th) {
103                                 Logger::info('Post not fetchable', ['uri-id' => $item['uri-id'], 'uid' => $uid, 'error' => $th]);
104                         }
105                 }
106
107                 DBA::close($items);
108
109                 if (!empty($request['min_id'])) {
110                         $statuses = array_reverse($statuses);
111                 }
112
113                 self::setLinkHeader($request['friendica_order'] != TimelineOrderByTypes::ID);
114                 $this->jsonExit($statuses);
115         }
116 }