3 * @copyright Copyright (C) 2010-2023, the Friendica project
5 * @license GNU AGPL version 3 or any later version
7 * This program is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU Affero General Public License as
9 * published by the Free Software Foundation, either version 3 of the
10 * License, or (at your option) any later version.
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU Affero General Public License for more details.
17 * You should have received a copy of the GNU Affero General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 namespace Friendica\Model\Post;
24 use Friendica\Database\DBA;
25 use BadMethodCallException;
26 use Friendica\Database\Database;
28 use Friendica\Model\Item;
29 use Friendica\Protocol\ActivityPub;
36 * Add a post to a collection
38 * @param integer $uri_id
39 * @param integer $type
40 * @param integer $author_id
41 * @param integer $cache_uid If set to a non zero value, the featured cache is cleared
43 public static function add(int $uri_id, int $type, int $author_id, int $cache_uid = 0)
46 throw new BadMethodCallException('Empty URI_id');
49 DBA::insert('post-collection', ['uri-id' => $uri_id, 'type' => $type, 'author-id' => $author_id], Database::INSERT_IGNORE);
51 if (!empty($cache_uid) && ($type == self::FEATURED)) {
52 DI::cache()->delete(ActivityPub\Transmitter::CACHEKEY_FEATURED . $cache_uid);
57 * Remove a post from a collection
59 * @param integer $uri_id
60 * @param integer $type
61 * @param integer $cache_uid If set to a non zero value, the featured cache is cleared
63 public static function remove(int $uri_id, int $type, int $cache_uid = 0)
66 throw new BadMethodCallException('Empty URI_id');
69 DBA::delete('post-collection', ['uri-id' => $uri_id, 'type' => $type]);
71 if (!empty($cache_uid) && ($type == self::FEATURED)) {
72 DI::cache()->delete(ActivityPub\Transmitter::CACHEKEY_FEATURED . $cache_uid);
77 * Fetch collections for a given contact
81 * @param array $fields
84 public static function selectToArrayForContact(int $cid, int $type = self::FEATURED, array $fields = [])
86 return DBA::selectToArray('collection-view', $fields, ['cid' => $cid, 'private' => [Item::PUBLIC, Item::UNLISTED], 'deleted' => false, 'type' => $type]);