3 * @copyright Copyright (C) 2010-2021, 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\Contact;
25 use Friendica\Core\Logger;
26 use Friendica\Core\System;
27 use Friendica\Database\Database;
28 use Friendica\Database\DBA;
29 use Friendica\Database\DBStructure;
30 use Friendica\Model\Contact;
31 use Friendica\Model\ItemURI;
35 * This class provides information about user related contacts based on the "user-contact" table.
40 * Insert a user-contact for a given contact array
42 * @param array $contact
45 public static function insertForContactArray(array $contact)
47 if (!isset($contact['uid']) || (empty($contact['uri-id']) && empty($contact['url']))) {
48 Logger::info('Missing contact details', ['contact' => $contact, 'callstack' => System::callstack(20)]);
52 if (empty($contact['uri-id'])) {
53 $contact['uri-id'] = ItemURI::getIdByURI($contact['url']);
56 $pcontact = Contact::selectFirst(['id'], ['uri-id' => $contact['uri-id'], 'uid' => 0]);
57 if (!DBA::isResult($pcontact)) {
58 Logger::info('Public contact for user not found', ['uri-id' => $contact['uri-id'], 'uid' => $contact['uid'], 'cid' => $pcontact['id']]);
63 'cid' => $pcontact['id'],
64 'uid' => $contact['uid'],
65 'uri-id' => $contact['uri-id'],
66 'blocked' => $contact['blocked'] ?? false,
67 'ignored' => $contact['readonly'] ?? false,
70 $ret = DBA::insert('user-contact', $fields, Database::INSERT_IGNORE);
72 Logger::info('Inserted user contact', ['uid' => $contact['uid'], 'cid' => $pcontact['id'], 'uri-id' => $contact['uri-id'], 'ret' => $ret]);
78 * Apply changes from contact update data to user-contact table
80 * @param array $fields
81 * @param array $condition
83 * @throws PDOException
86 public static function UpdateByContactUpdate(array $fields, array $condition)
90 unset($fields['uid']);
91 unset($fields['cid']);
92 unset($fields['uri-id']);
94 if (isset($fields['readonly'])) {
95 $fields['ignored'] = $fields['readonly'];
98 $update_fields = DBStructure::getFieldsForTable('user-contact', $fields);
99 if (!empty($update_fields)) {
100 $contacts = DBA::select('contact', ['uri-id', 'uid'], $condition);
101 while ($row = DBA::fetch($contacts)) {
102 if (empty($row['uri-id'])) {
105 $ret = DBA::update('user-contact', $update_fields, ['uri-id' => $row['uri-id'], 'uid' => $row['uid']]);
106 Logger::info('Updated user contact', ['uid' => $row['uid'], 'uri-id' => $row['uri-id'], 'ret' => $ret]);
109 DBA::close($contacts);
115 * Block contact id for user id
117 * @param int $cid Either public contact id or user's contact id
118 * @param int $uid User ID
119 * @param boolean $blocked Is the contact blocked or unblocked?
122 public static function setBlocked($cid, $uid, $blocked)
124 $cdata = Contact::getPublicAndUserContactID($cid, $uid);
129 if ($cdata['user'] != 0) {
130 DBA::update('contact', ['blocked' => $blocked], ['id' => $cdata['user'], 'pending' => false]);
133 DBA::update('user-contact', ['blocked' => $blocked], ['cid' => $cdata['public'], 'uid' => $uid], true);
137 * Returns "block" state for contact id and user id
139 * @param int $cid Either public contact id or user's contact id
140 * @param int $uid User ID
142 * @return boolean is the contact id blocked for the given user?
145 public static function isBlocked($cid, $uid)
147 $cdata = Contact::getPublicAndUserContactID($cid, $uid);
152 $public_blocked = false;
154 if (!empty($cdata['public'])) {
155 $public_contact = DBA::selectFirst('user-contact', ['blocked'], ['cid' => $cdata['public'], 'uid' => $uid]);
156 if (DBA::isResult($public_contact)) {
157 $public_blocked = $public_contact['blocked'];
161 $user_blocked = $public_blocked;
163 if (!empty($cdata['user'])) {
164 $user_contact = DBA::selectFirst('contact', ['blocked'], ['id' => $cdata['user'], 'pending' => false]);
165 if (DBA::isResult($user_contact)) {
166 $user_blocked = $user_contact['blocked'];
170 if ($user_blocked != $public_blocked) {
171 DBA::update('user-contact', ['blocked' => $user_blocked], ['cid' => $cdata['public'], 'uid' => $uid], true);
174 return $user_blocked;
178 * Ignore contact id for user id
180 * @param int $cid Either public contact id or user's contact id
181 * @param int $uid User ID
182 * @param boolean $ignored Is the contact ignored or unignored?
185 public static function setIgnored($cid, $uid, $ignored)
187 $cdata = Contact::getPublicAndUserContactID($cid, $uid);
192 if ($cdata['user'] != 0) {
193 DBA::update('contact', ['readonly' => $ignored], ['id' => $cdata['user'], 'pending' => false]);
196 DBA::update('user-contact', ['ignored' => $ignored], ['cid' => $cdata['public'], 'uid' => $uid], true);
200 * Returns "ignore" state for contact id and user id
202 * @param int $cid Either public contact id or user's contact id
203 * @param int $uid User ID
205 * @return boolean is the contact id ignored for the given user?
208 public static function isIgnored($cid, $uid)
210 $cdata = Contact::getPublicAndUserContactID($cid, $uid);
215 $public_ignored = false;
217 if (!empty($cdata['public'])) {
218 $public_contact = DBA::selectFirst('user-contact', ['ignored'], ['cid' => $cdata['public'], 'uid' => $uid]);
219 if (DBA::isResult($public_contact)) {
220 $public_ignored = $public_contact['ignored'];
224 $user_ignored = $public_ignored;
226 if (!empty($cdata['user'])) {
227 $user_contact = DBA::selectFirst('contact', ['readonly'], ['id' => $cdata['user'], 'pending' => false]);
228 if (DBA::isResult($user_contact)) {
229 $user_ignored = $user_contact['readonly'];
233 if ($user_ignored != $public_ignored) {
234 DBA::update('user-contact', ['ignored' => $user_ignored], ['cid' => $cdata['public'], 'uid' => $uid], true);
237 return $user_ignored;
241 * Set "collapsed" for contact id and user id
243 * @param int $cid Either public contact id or user's contact id
244 * @param int $uid User ID
245 * @param boolean $collapsed are the contact's posts collapsed or uncollapsed?
248 public static function setCollapsed($cid, $uid, $collapsed)
250 $cdata = Contact::getPublicAndUserContactID($cid, $uid);
255 DBA::update('user-contact', ['collapsed' => $collapsed], ['cid' => $cdata['public'], 'uid' => $uid], true);
259 * Returns "collapsed" state for contact id and user id
261 * @param int $cid Either public contact id or user's contact id
262 * @param int $uid User ID
264 * @return boolean is the contact id blocked for the given user?
265 * @throws HTTPException\InternalServerErrorException
266 * @throws \ImagickException
268 public static function isCollapsed($cid, $uid)
270 $cdata = Contact::getPublicAndUserContactID($cid, $uid);
277 if (!empty($cdata['public'])) {
278 $public_contact = DBA::selectFirst('user-contact', ['collapsed'], ['cid' => $cdata['public'], 'uid' => $uid]);
279 if (DBA::isResult($public_contact)) {
280 $collapsed = $public_contact['collapsed'];