<?php
/**
- * @copyright Copyright (C) 2010-2021, the Friendica project
+ * @copyright Copyright (C) 2010-2023, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
use Exception;
use Friendica\Core\Logger;
-use Friendica\Core\System;
+use Friendica\Core\Protocol;
use Friendica\Database\Database;
use Friendica\Database\DBA;
-use Friendica\Database\DBStructure;
+use Friendica\DI;
use Friendica\Model\Contact;
use Friendica\Model\ItemURI;
use PDOException;
*/
class User
{
+ const FREQUENCY_DEFAULT = 0;
+ const FREQUENCY_NEVER = 1;
+ const FREQUENCY_ALWAYS = 2;
+ const FREQUENCY_REDUCED = 3;
/**
* Insert a user-contact for a given contact array
*
}
if (empty($contact['uri-id']) && empty($contact['url'])) {
- Logger::info('Missing contact details', ['contact' => $contact, 'callstack' => System::callstack(20)]);
+ Logger::info('Missing contact details', ['contact' => $contact]);
return false;
}
return false;
}
- $fields = $contact;
-
- if (isset($fields['readonly'])) {
- $fields['ignored'] = $fields['readonly'];
- }
-
- if (!empty($fields['self'])) {
- $fields['rel'] = Contact::SELF;
- }
-
- $fields = DBStructure::getFieldsForTable('user-contact', $fields);
+ $fields = self::preparedFields($contact);
$fields['cid'] = $pcid;
$fields['uid'] = $contact['uid'];
$fields['uri-id'] = $contact['uri-id'];
/**
* Apply changes from contact update data to user-contact table
*
- * @param array $fields
- * @param array $condition
- * @return void
- * @throws PDOException
- * @throws Exception
+ * @param array $fields
+ * @param array $condition
+ * @return void
+ * @throws PDOException
+ * @throws Exception
*/
public static function updateByContactUpdate(array $fields, array $condition)
{
DBA::transaction();
+ $update_fields = self::preparedFields($fields);
+ if (!empty($update_fields)) {
+ $contacts = DBA::select('account-user-view', ['pid', 'uri-id', 'uid'], $condition);
+ while ($contact = DBA::fetch($contacts)) {
+ if (empty($contact['uri-id']) || empty($contact['uid'])) {
+ continue;
+ }
+ $update_fields['cid'] = $contact['pid'];
+ $ret = DBA::update('user-contact', $update_fields, ['uri-id' => $contact['uri-id'], 'uid' => $contact['uid']], true);
+ Logger::info('Updated user contact', ['uid' => $contact['uid'], 'id' => $contact['pid'], 'uri-id' => $contact['uri-id'], 'ret' => $ret]);
+ }
+
+ DBA::close($contacts);
+ }
+
+ DBA::commit();
+ }
+
+ /**
+ * Prepare field data for update/insert
+ *
+ * @param array $fields
+ * @return array prepared fields
+ */
+ private static function preparedFields(array $fields): array
+ {
unset($fields['uid']);
unset($fields['cid']);
unset($fields['uri-id']);
$fields['rel'] = Contact::SELF;
}
- $update_fields = DBStructure::getFieldsForTable('user-contact', $fields);
- if (!empty($update_fields)) {
- $contacts = DBA::select('contact', ['uri-id', 'uid'], $condition);
- while ($row = DBA::fetch($contacts)) {
- if (empty($row['uri-id']) || empty($contact['uid'])) {
- continue;
- }
- $ret = DBA::update('user-contact', $update_fields, ['uri-id' => $row['uri-id'], 'uid' => $row['uid']]);
- Logger::info('Updated user contact', ['uid' => $row['uid'], 'uri-id' => $row['uri-id'], 'ret' => $ret]);
- }
-
- DBA::close($contacts);
- }
- DBA::commit();
+ return DI::dbaDefinition()->truncateFieldsForTable('user-contact', $fields);
}
/**
* @param int $cid Either public contact id or user's contact id
* @param int $uid User ID
* @param boolean $blocked Is the contact blocked or unblocked?
+ * @return void
* @throws \Exception
*/
- public static function setBlocked($cid, $uid, $blocked)
+ public static function setBlocked(int $cid, int $uid, bool $blocked)
{
$cdata = Contact::getPublicAndUserContactID($cid, $uid);
if (empty($cdata)) {
return;
}
+ $contact = Contact::getById($cdata['public']);
+ if ($blocked) {
+ Protocol::block($contact, $uid);
+ } else {
+ Protocol::unblock($contact, $uid);
+ }
+
if ($cdata['user'] != 0) {
DBA::update('contact', ['blocked' => $blocked], ['id' => $cdata['user'], 'pending' => false]);
}
* @return boolean is the contact id blocked for the given user?
* @throws \Exception
*/
- public static function isBlocked($cid, $uid)
+ public static function isBlocked(int $cid, int $uid): bool
{
$cdata = Contact::getPublicAndUserContactID($cid, $uid);
if (empty($cdata)) {
if (!empty($cdata['public'])) {
$public_contact = DBA::selectFirst('user-contact', ['blocked'], ['cid' => $cdata['public'], 'uid' => $uid]);
if (DBA::isResult($public_contact)) {
- $public_blocked = $public_contact['blocked'];
+ $public_blocked = (bool) $public_contact['blocked'];
}
}
if (!empty($cdata['user'])) {
$user_contact = DBA::selectFirst('contact', ['blocked'], ['id' => $cdata['user'], 'pending' => false]);
if (DBA::isResult($user_contact)) {
- $user_blocked = $user_contact['blocked'];
+ $user_blocked = (bool) $user_contact['blocked'];
}
}
* @param int $cid Either public contact id or user's contact id
* @param int $uid User ID
* @param boolean $ignored Is the contact ignored or unignored?
+ * @return void
* @throws \Exception
*/
- public static function setIgnored($cid, $uid, $ignored)
+ public static function setIgnored(int $cid, int $uid, bool $ignored)
{
$cdata = Contact::getPublicAndUserContactID($cid, $uid);
if (empty($cdata)) {
*
* @param int $cid Either public contact id or user's contact id
* @param int $uid User ID
- *
* @return boolean is the contact id ignored for the given user?
* @throws \Exception
*/
- public static function isIgnored($cid, $uid)
+ public static function isIgnored(int $cid, int $uid): bool
{
$cdata = Contact::getPublicAndUserContactID($cid, $uid);
if (empty($cdata)) {
if (!empty($cdata['public'])) {
$public_contact = DBA::selectFirst('user-contact', ['ignored'], ['cid' => $cdata['public'], 'uid' => $uid]);
if (DBA::isResult($public_contact)) {
- $public_ignored = $public_contact['ignored'];
+ $public_ignored = (bool) $public_contact['ignored'];
}
}
if (!empty($cdata['user'])) {
$user_contact = DBA::selectFirst('contact', ['readonly'], ['id' => $cdata['user'], 'pending' => false]);
if (DBA::isResult($user_contact)) {
- $user_ignored = $user_contact['readonly'];
+ $user_ignored = (bool) $user_contact['readonly'];
}
}
* @param int $cid Either public contact id or user's contact id
* @param int $uid User ID
* @param boolean $collapsed are the contact's posts collapsed or uncollapsed?
+ * @return void
* @throws \Exception
*/
- public static function setCollapsed($cid, $uid, $collapsed)
+ public static function setCollapsed(int $cid, int $uid, bool $collapsed)
{
$cdata = Contact::getPublicAndUserContactID($cid, $uid);
if (empty($cdata)) {
*
* @param int $cid Either public contact id or user's contact id
* @param int $uid User ID
- *
* @return boolean is the contact id blocked for the given user?
* @throws HTTPException\InternalServerErrorException
* @throws \ImagickException
*/
- public static function isCollapsed($cid, $uid)
+ public static function isCollapsed(int $cid, int $uid): bool
{
$cdata = Contact::getPublicAndUserContactID($cid, $uid);
if (empty($cdata)) {
- return;
+ return false;
}
$collapsed = false;
if (!empty($cdata['public'])) {
$public_contact = DBA::selectFirst('user-contact', ['collapsed'], ['cid' => $cdata['public'], 'uid' => $uid]);
if (DBA::isResult($public_contact)) {
- $collapsed = $public_contact['collapsed'];
+ $collapsed = (bool) $public_contact['collapsed'];
}
}
return $collapsed;
}
+
+ /**
+ * Set the channel post frequency for contact id and user id
+ *
+ * @param int $cid Either public contact id or user's contact id
+ * @param int $uid User ID
+ * @param int $frequency Type of post frequency in channels
+ * @return void
+ * @throws \Exception
+ */
+ public static function setChannelFrequency(int $cid, int $uid, int $frequency)
+ {
+ $cdata = Contact::getPublicAndUserContactID($cid, $uid);
+ if (empty($cdata)) {
+ return;
+ }
+
+ DBA::update('user-contact', ['channel-frequency' => $frequency], ['cid' => $cdata['public'], 'uid' => $uid], true);
+ }
+
+ /**
+ * Returns the channel frequency state for contact id and user id
+ *
+ * @param int $cid Either public contact id or user's contact id
+ * @param int $uid User ID
+ * @return int Type of post frequency in channels
+ * @throws HTTPException\InternalServerErrorException
+ * @throws \ImagickException
+ */
+ public static function getChannelFrequency(int $cid, int $uid): int
+ {
+ $cdata = Contact::getPublicAndUserContactID($cid, $uid);
+ if (empty($cdata)) {
+ return false;
+ }
+
+ $frequency = self::FREQUENCY_DEFAULT;
+
+ if (!empty($cdata['public'])) {
+ $public_contact = DBA::selectFirst('user-contact', ['channel-frequency'], ['cid' => $cdata['public'], 'uid' => $uid]);
+ if (DBA::isResult($public_contact)) {
+ $frequency = $public_contact['channel-frequency'] ?? self::FREQUENCY_DEFAULT;
+ }
+ }
+
+ return $frequency;
+ }
+
+ /**
+ * Set/Release that the user is blocked by the contact
+ *
+ * @param int $cid Either public contact id or user's contact id
+ * @param int $uid User ID
+ * @param boolean $blocked Is the user blocked or unblocked by the contact?
+ * @return void
+ * @throws \Exception
+ */
+ public static function setIsBlocked(int $cid, int $uid, bool $blocked)
+ {
+ $cdata = Contact::getPublicAndUserContactID($cid, $uid);
+ if (empty($cdata)) {
+ return;
+ }
+
+ DBA::update('user-contact', ['is-blocked' => $blocked], ['cid' => $cdata['public'], 'uid' => $uid], true);
+ }
+
+ /**
+ * Returns if the user is blocked by the contact
+ *
+ * @param int $cid Either public contact id or user's contact id
+ * @param int $uid User ID
+ * @return boolean Is the user blocked or unblocked by the contact?
+ * @throws \Exception
+ */
+ public static function isIsBlocked(int $cid, int $uid): bool
+ {
+ $cdata = Contact::getPublicAndUserContactID($cid, $uid);
+ if (empty($cdata)) {
+ return false;
+ }
+
+ if (!empty($cdata['public'])) {
+ $public_contact = DBA::selectFirst('user-contact', ['is-blocked'], ['cid' => $cdata['public'], 'uid' => $uid]);
+ if (DBA::isResult($public_contact)) {
+ return $public_contact['is-blocked'];
+ }
+ }
+
+ return false;
+ }
}
projects / friendica.git / blobdiff