]> git.mxchange.org Git - friendica.git/blobdiff - src/Model/Contact/Relation.php
Merge pull request #9046 from annando/local-followers
[friendica.git] / src / Model / Contact / Relation.php
index cc0570ec63a2dcd0746a7f40089be190cd27e2c7..24d663cbbf41b34b09b046fe33b0cdb2864740ce 100644 (file)
@@ -28,6 +28,8 @@ use Friendica\Database\DBA;
 use Friendica\DI;
 use Friendica\Model\APContact;
 use Friendica\Model\Contact;
+use Friendica\Model\Profile;
+use Friendica\Model\User;
 use Friendica\Protocol\ActivityPub;
 use Friendica\Util\DateTimeFormat;
 use Friendica\Util\Strings;
@@ -82,18 +84,25 @@ class Relation
                        return;
                }
 
-               $apcontact = APContact::getByURL($url, false);
-
-               if (!empty($apcontact['followers']) && is_string($apcontact['followers'])) {
-                       $followers = ActivityPub::fetchItems($apcontact['followers']);
+               $uid = User::getIdForURL($url);
+               if (!empty($uid)) {
+                       // Fetch the followers/followings locally
+                       $followers = self::getContacts($uid, [Contact::FOLLOWER, Contact::FRIEND]);
+                       $followings = self::getContacts($uid, [Contact::SHARING, Contact::FRIEND]);
                } else {
-                       $followers = [];
-               }
+                       $apcontact = APContact::getByURL($url, false);
 
-               if (!empty($apcontact['following']) && is_string($apcontact['following'])) {
-                       $followings = ActivityPub::fetchItems($apcontact['following']);
-               } else {
-                       $followings = [];
+                       if (!empty($apcontact['followers']) && is_string($apcontact['followers'])) {
+                               $followers = ActivityPub::fetchItems($apcontact['followers']);
+                       } else {
+                               $followers = [];
+                       }
+
+                       if (!empty($apcontact['following']) && is_string($apcontact['following'])) {
+                               $followings = ActivityPub::fetchItems($apcontact['following']);
+                       } else {
+                               $followings = [];
+                       }
                }
 
                if (empty($followers) && empty($followings)) {
@@ -150,6 +159,33 @@ class Relation
                return;
        }
 
+       /**
+        * Fetch contact list from the given local user
+        *
+        * @param integer $uid
+        * @param array $rel
+        * @return void
+        */
+       private static function getContacts(int $uid, array $rel)
+       {
+               $list = [];
+               $profile = Profile::getByUID($uid);
+               if (!empty($profile['hide-friends'])) {
+                       return $list;
+               }
+
+               $condition = ['rel' => $rel, 'uid' => $uid, 'self' => false, 'deleted' => false,
+                       'hidden' => false, 'archive' => false, 'pending' => false];
+               $condition = DBA::mergeConditions($condition, ["`url` IN (SELECT `url` FROM `apcontact`)"]);
+               $contacts = DBA::select('contact', ['url'], $condition);
+               while ($contact = DBA::fetch($contacts)) {
+                       $list[] = $contact['url'];
+               }
+               DBA::close($contacts);
+
+               return $list;
+       }
+
        /**
         * Tests if a given contact url is discoverable
         *
@@ -166,7 +202,7 @@ class Relation
                }
 
                if (empty($contact)) {
-                       $contact = Contact::getByURL($url);
+                       $contact = Contact::getByURL($url, false);
                }
 
                if (empty($contact)) {
@@ -335,7 +371,6 @@ class Relation
         * Returns a paginated list of contacts that are followed the provided public contact.
         *
         * @param int   $cid       Public contact id
-        * @param array $field     Field list
         * @param array $condition Additional condition on the contact table
         * @param int   $count
         * @param int   $offset
@@ -343,14 +378,14 @@ class Relation
         * @return array
         * @throws Exception
         */
-       public static function listFollows(int $cid, array $fields = [], array $condition = [], int $count = 30, int $offset = 0, bool $shuffle = false)
+       public static function listFollows(int $cid, array $condition = [], int $count = 30, int $offset = 0, bool $shuffle = false)
        {
                $condition = DBA::mergeConditions($condition,
                        ['`id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ? AND `follows`)', 
                        $cid]
                );
 
-               return DI::dba()->selectToArray('contact', $fields, $condition,
+               return DI::dba()->selectToArray('contact', [], $condition,
                        ['limit' => [$offset, $count], 'order' => [$shuffle ? 'RAND()' : 'name']]
                );
        }
@@ -377,7 +412,6 @@ class Relation
         * Returns a paginated list of contacts that follow the provided public contact.
         *
         * @param int   $cid       Public contact id
-        * @param array $field     Field list
         * @param array $condition Additional condition on the contact table
         * @param int   $count
         * @param int   $offset
@@ -385,17 +419,104 @@ class Relation
         * @return array
         * @throws Exception
         */
-       public static function listFollowers(int $cid, array $fields = [], array $condition = [], int $count = 30, int $offset = 0, bool $shuffle = false)
+       public static function listFollowers(int $cid, array $condition = [], int $count = 30, int $offset = 0, bool $shuffle = false)
        {
                $condition = DBA::mergeConditions($condition,
                        ['`id` IN (SELECT `cid` FROM `contact-relation` WHERE `relation-cid` = ? AND `follows`)', $cid]
                );
 
-               return DI::dba()->selectToArray('contact', $fields, $condition,
+               return DI::dba()->selectToArray('contact', [], $condition,
                        ['limit' => [$offset, $count], 'order' => [$shuffle ? 'RAND()' : 'name']]
                );
        }
 
+       /**
+        * Counts the number of contacts that are known mutuals with the provided public contact.
+        *
+        * @param int   $cid       Public contact id
+        * @param array $condition Additional condition array on the contact table
+        * @return int
+        * @throws Exception
+        */
+       public static function countMutuals(int $cid, array $condition = [])
+       {
+               $condition = DBA::mergeConditions($condition,
+                       ['`id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ? AND `follows`) 
+                       AND `id` IN (SELECT `cid` FROM `contact-relation` WHERE `relation-cid` = ? AND `follows`)',
+                       $cid, $cid]
+               );
+
+               return DI::dba()->count('contact', $condition);
+       }
+
+       /**
+        * Returns a paginated list of contacts that are known mutuals with the provided public contact.
+        *
+        * @param int   $cid       Public contact id
+        * @param array $condition Additional condition on the contact table
+        * @param int   $count
+        * @param int   $offset
+        * @param bool  $shuffle
+        * @return array
+        * @throws Exception
+        */
+       public static function listMutuals(int $cid, array $condition = [], int $count = 30, int $offset = 0, bool $shuffle = false)
+       {
+               $condition = DBA::mergeConditions($condition,
+                       ['`id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ? AND `follows`) 
+                       AND `id` IN (SELECT `cid` FROM `contact-relation` WHERE `relation-cid` = ? AND `follows`)',
+                       $cid, $cid]
+               );
+
+               return DI::dba()->selectToArray('contact', [], $condition,
+                       ['limit' => [$offset, $count], 'order' => [$shuffle ? 'name' : 'RAND()']]
+               );
+       }
+
+
+       /**
+        * Counts the number of contacts with any relationship with the provided public contact.
+        *
+        * @param int   $cid       Public contact id
+        * @param array $condition Additional condition array on the contact table
+        * @return int
+        * @throws Exception
+        */
+       public static function countAll(int $cid, array $condition = [])
+       {
+               $condition = DBA::mergeConditions($condition,
+                       ['`id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ? AND `follows`) 
+                       OR `id` IN (SELECT `cid` FROM `contact-relation` WHERE `relation-cid` = ? AND `follows`)',
+                               $cid, $cid]
+               );
+
+               return DI::dba()->count('contact', $condition);
+       }
+
+       /**
+        * Returns a paginated list of contacts with any relationship with the provided public contact.
+        *
+        * @param int   $cid       Public contact id
+        * @param array $condition Additional condition on the contact table
+        * @param int   $count
+        * @param int   $offset
+        * @param bool  $shuffle
+        * @return array
+        * @throws Exception
+        */
+       public static function listAll(int $cid, array $condition = [], int $count = 30, int $offset = 0, bool $shuffle = false)
+       {
+               $condition = DBA::mergeConditions($condition,
+                       ['`id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ? AND `follows`) 
+                       OR `id` IN (SELECT `cid` FROM `contact-relation` WHERE `relation-cid` = ? AND `follows`)',
+                               $cid, $cid]
+               );
+
+               return DI::dba()->selectToArray('contact', [], $condition,
+                       ['limit' => [$offset, $count], 'order' => [$shuffle ? 'name' : 'RAND()']]
+               );
+       }
+
        /**
         * Counts the number of contacts that both provided public contacts have interacted with at least once.
         * Interactions include follows and likes and comments on public posts.
@@ -423,7 +544,6 @@ class Relation
         *
         * @param int   $sourceId  Public contact id
         * @param int   $targetId  Public contact id
-        * @param array $field     Field list
         * @param array $condition Additional condition on the contact table
         * @param int   $count
         * @param int   $offset
@@ -434,8 +554,8 @@ class Relation
        public static function listCommon(int $sourceId, int $targetId, array $condition = [], int $count = 30, int $offset = 0, bool $shuffle = false)
        {
                $condition = DBA::mergeConditions($condition,
-                       ["`id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ? AND `follows`
-                       AND `id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ? AND `follows`)",
+                       ["`id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ?) 
+                       AND `id` IN (SELECT `relation-cid` FROM `contact-relation` WHERE `cid` = ?)",
                        $sourceId, $targetId]
                );
 
@@ -444,7 +564,6 @@ class Relation
                );
        }
 
-
        /**
         * Counts the number of contacts that are followed by both provided public contacts.
         *