Merge branch 'develop' into task/mod_hostxrd

[friendica.git] / src / Model / User.php

diff --git a/src/Model/User.php b/src/Model/User.php
index c33092a0fc7e844dbff75b3ddf23900e50672929..c575b44d38ea222593a6b20896fec42ee6d2753d 100644 (file)
--- a/src/Model/User.php
+++ b/src/Model/User.php
@@ -29,13 +29,13 @@ use LightOpenID;
 class User
 {
        /**
-        * @name page/profile types
+        * Page/profile types
         *
-        * PAGE_NORMAL is a typical personal profile account
-        * PAGE_SOAPBOX automatically approves all friend requests as Contact::SHARING, (readonly)
-        * PAGE_COMMUNITY automatically approves all friend requests as Contact::SHARING, but with
+        * PAGE_FLAGS_NORMAL is a typical personal profile account
+        * PAGE_FLAGS_SOAPBOX automatically approves all friend requests as Contact::SHARING, (readonly)
+        * PAGE_FLAGS_COMMUNITY automatically approves all friend requests as Contact::SHARING, but with
         *      write access to wall and comments (no email and not included in page owner's ACL lists)
-        * PAGE_FREELOVE automatically approves all friend requests as full friends (Contact::FRIEND).
+        * PAGE_FLAGS_FREELOVE automatically approves all friend requests as full friends (Contact::FRIEND).
         *
         * @{
         */
@@ -91,12 +91,24 @@ class User
 
        /**
         * @param  integer       $uid
+        * @param array          $fields
         * @return array|boolean User record if it exists, false otherwise
         * @throws Exception
         */
-       public static function getById($uid)
+       public static function getById($uid, array $fields = [])
        {
-               return DBA::selectFirst('user', [], ['uid' => $uid]);
+               return DBA::selectFirst('user', $fields, ['uid' => $uid]);
+       }
+
+       /**
+        * @param  string        $nickname
+        * @param array          $fields
+        * @return array|boolean User record if it exists, false otherwise
+        * @throws Exception
+        */
+       public static function getByNickname($nickname, array $fields = [])
+       {
+               return DBA::selectFirst('user', $fields, ['nickname' => $nickname]);
        }
 
        /**
@@ -134,7 +146,8 @@ class User
                        `user`.`spubkey`,
                        `user`.`page-flags`,
                        `user`.`account-type`,
-                       `user`.`prvnets`
+                       `user`.`prvnets`,
+                       `user`.`account_removed`
                        FROM `contact`
                        INNER JOIN `user`
                                ON `user`.`uid` = `contact`.`uid`
@@ -891,7 +904,7 @@ class User
                Worker::add(PRIORITY_LOW, 'Directory', $self['url']);
 
                // Remove the user relevant data
-               Worker::add(PRIORITY_LOW, 'RemoveUser', $uid);
+               Worker::add(PRIORITY_NEGLIGIBLE, 'RemoveUser', $uid);
 
                return true;
        }
@@ -966,4 +979,51 @@ class User
 
                return $identities;
        }
+
+       /**
+        * Returns statistical information about the current users of this node
+        *
+        * @return array
+        *
+        * @throws Exception
+        */
+       public static function getStatistics()
+       {
+               $statistics = [
+                       'total_users'           => 0,
+                       'active_users_halfyear' => 0,
+                       'active_users_monthly'  => 0,
+               ];
+
+               $userStmt = DBA::p("SELECT `user`.`uid`, `user`.`login_date`, `contact`.`last-item`
+                       FROM `user`
+                       INNER JOIN `profile` ON `profile`.`uid` = `user`.`uid` AND `profile`.`is-default`
+                       INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid` AND `contact`.`self`
+                       WHERE (`profile`.`publish` OR `profile`.`net-publish`) AND `user`.`verified`
+                               AND NOT `user`.`blocked` AND NOT `user`.`account_removed`
+                               AND NOT `user`.`account_expired`");
+
+               if (!DBA::isResult($userStmt)) {
+                       return $statistics;
+               }
+
+               $halfyear = time() - (180 * 24 * 60 * 60);
+               $month = time() - (30 * 24 * 60 * 60);
+
+               while ($user = DBA::fetch($userStmt)) {
+                       $statistics['total_users']++;
+
+                       if ((strtotime($user['login_date']) > $halfyear) ||
+                               (strtotime($user['last-item']) > $halfyear)) {
+                               $statistics['active_users_halfyear']++;
+                       }
+
+                       if ((strtotime($user['login_date']) > $month) ||
+                               (strtotime($user['last-item']) > $month)) {
+                               $statistics['active_users_monthly']++;
+                       }
+               }
+
+               return $statistics;
+       }
 }