src/Module/Admin/Users.php

   1 <?php
   2 /**
   3  * @copyright Copyright (C) 2020, Friendica
   4  *
   5  * @license GNU AGPL version 3 or any later version
   6  *
   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.
  11  *
  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.
  16  *
  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/>.
  19  *
  20  */
  21
  22 namespace Friendica\Module\Admin;
  23
  24 use Friendica\Content\Pager;
  25 use Friendica\Core\Renderer;
  26 use Friendica\Database\DBA;
  27 use Friendica\DI;
  28 use Friendica\Model\Register;
  29 use Friendica\Model\User;
  30 use Friendica\Module\BaseAdmin;
  31 use Friendica\Util\Temporal;
  32
  33 class Users extends BaseAdmin
  34 {
  35         public static function post(array $parameters = [])
  36         {
  37                 parent::post($parameters);
  38
  39                 $pending     = $_POST['pending']           ?? [];
  40                 $users       = $_POST['user']              ?? [];
  41                 $nu_name     = $_POST['new_user_name']     ?? '';
  42                 $nu_nickname = $_POST['new_user_nickname'] ?? '';
  43                 $nu_email    = $_POST['new_user_email']    ?? '';
  44                 $nu_language = DI::config()->get('system', 'language');
  45
  46                 parent::checkFormSecurityTokenRedirectOnError('/admin/users', 'admin_users');
  47
  48                 if ($nu_name !== '' && $nu_email !== '' && $nu_nickname !== '') {
  49                         try {
  50                                 DI::userService()->createMinimal($nu_name, $nu_email, $nu_nickname, $nu_language);
  51                         } catch (\Exception $ex) {
  52                                 notice($ex->getMessage());
  53                                 return;
  54                         }
  55                 }
  56
  57                 if (!empty($_POST['page_users_block'])) {
  58                         if (User::block($users)) {
  59                                 notice(DI::l10n()->tt('%s user blocked', '%s users blocked', count($users)));
  60                         }
  61                 }
  62
  63                 if (!empty($_POST['page_users_unblock'])) {
  64                         if (User::block($users, false)) {
  65                                 notice(DI::l10n()->tt('%s user unblocked', '%s users unblocked', count($users)));
  66                         }
  67                 }
  68
  69                 if (!empty($_POST['page_users_delete'])) {
  70                         foreach ($users as $uid) {
  71                                 if (local_user() != $uid) {
  72                                         User::remove($uid);
  73                                 } else {
  74                                         notice(DI::l10n()->t('You can\'t remove yourself'));
  75                                 }
  76                         }
  77
  78                         notice(DI::l10n()->tt('%s user deleted', '%s users deleted', count($users)));
  79                 }
  80
  81                 if (!empty($_POST['page_users_approve'])) {
  82                         require_once 'mod/regmod.php';
  83                         foreach ($pending as $hash) {
  84                                 if (User::allow($hash)) {
  85                                         info(DI::l10n()->t('Account approved.'));
  86                                 }
  87                         }
  88                 }
  89
  90                 if (!empty($_POST['page_users_deny'])) {
  91                         require_once 'mod/regmod.php';
  92                         foreach ($pending as $hash) {
  93                                 if (User::deny($hash)) {
  94                                         notice(DI::l10n()->t('Registration revoked'));
  95                                 }
  96                         }
  97                 }
  98
  99                 DI::baseUrl()->redirect('admin/users');
 100         }
 101
 102         public static function content(array $parameters = [])
 103         {
 104                 parent::content($parameters);
 105
 106                 $a = DI::app();
 107
 108                 if ($a->argc > 3) {
 109                         // @TODO: Replace with parameter from router
 110                         $action = $a->argv[2];
 111                         $uid = $a->argv[3];
 112                         $user = User::getById($uid, ['username', 'blocked']);
 113                         if (!DBA::isResult($user)) {
 114                                 notice('User not found' . EOL);
 115                                 DI::baseUrl()->redirect('admin/users');
 116                                 return ''; // NOTREACHED
 117                         }
 118
 119                         switch ($action) {
 120                                 case 'delete':
 121                                         if (local_user() != $uid) {
 122                                                 parent::checkFormSecurityTokenRedirectOnError('/admin/users', 'admin_users', 't');
 123                                                 // delete user
 124                                                 User::remove($uid);
 125
 126                                                 notice(DI::l10n()->t('User "%s" deleted', $user['username']));
 127                                         } else {
 128                                                 notice(DI::l10n()->t('You can\'t remove yourself'));
 129                                         }
 130                                         break;
 131                                 case 'block':
 132                                         parent::checkFormSecurityTokenRedirectOnError('/admin/users', 'admin_users', 't');
 133                                         // @TODO Move this to Model\User:block([$uid]);
 134                                         DBA::update('user', ['blocked' => 1], ['uid' => $uid]);
 135                                         notice(DI::l10n()->t('User "%s" blocked', $user['username']));
 136                                         break;
 137                                 case 'unblock':
 138                                         parent::checkFormSecurityTokenRedirectOnError('/admin/users', 'admin_users', 't');
 139                                         // @TODO Move this to Model\User:unblock([$uid]);
 140                                         DBA::update('user', ['blocked' => 0], ['uid' => $uid]);
 141                                         notice(DI::l10n()->t('User "%s" unblocked', $user['username']));
 142                                         break;
 143                         }
 144
 145                         DI::baseUrl()->redirect('admin/users');
 146                 }
 147
 148                 /* get pending */
 149                 $pending = Register::getPending();
 150
 151                 $pager = new Pager(DI::l10n(), DI::args()->getQueryString(), 100);
 152
 153                 // @TODO Move below block to Model\User::getUsers($start, $count, $order = 'contact.name', $order_direction = '+')
 154                 $valid_orders = [
 155                         'contact.name',
 156                         'user.email',
 157                         'user.register_date',
 158                         'user.login_date',
 159                         'lastitem_date',
 160                         'user.page-flags'
 161                 ];
 162
 163                 $order = 'contact.name';
 164                 $order_direction = '+';
 165                 if (!empty($_GET['o'])) {
 166                         $new_order = $_GET['o'];
 167                         if ($new_order[0] === '-') {
 168                                 $order_direction = '-';
 169                                 $new_order = substr($new_order, 1);
 170                         }
 171
 172                         if (in_array($new_order, $valid_orders)) {
 173                                 $order = $new_order;
 174                         }
 175                 }
 176                 $sql_order = '`' . str_replace('.', '`.`', $order) . '`';
 177                 $sql_order_direction = ($order_direction === '+') ? 'ASC' : 'DESC';
 178
 179                 $usersStmt = DBA::p("SELECT `user`.*, `contact`.`name`, `contact`.`url`, `contact`.`micro`, `user`.`account_expired`, `contact`.`last-item` AS `lastitem_date`
 180                                 FROM `user`
 181                                 INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid` AND `contact`.`self`
 182                                 WHERE `user`.`verified`
 183                                 ORDER BY $sql_order $sql_order_direction LIMIT ?, ?", $pager->getStart(), $pager->getItemsPerPage()
 184                 );
 185                 $users = DBA::toArray($usersStmt);
 186
 187                 $adminlist = explode(',', str_replace(' ', '', DI::config()->get('config', 'admin_email')));
 188                 $_setup_users = function ($e) use ($adminlist) {
 189                         $page_types = [
 190                                 User::PAGE_FLAGS_NORMAL    => DI::l10n()->t('Normal Account Page'),
 191                                 User::PAGE_FLAGS_SOAPBOX   => DI::l10n()->t('Soapbox Page'),
 192                                 User::PAGE_FLAGS_COMMUNITY => DI::l10n()->t('Public Forum'),
 193                                 User::PAGE_FLAGS_FREELOVE  => DI::l10n()->t('Automatic Friend Page'),
 194                                 User::PAGE_FLAGS_PRVGROUP  => DI::l10n()->t('Private Forum')
 195                         ];
 196                         $account_types = [
 197                                 User::ACCOUNT_TYPE_PERSON       => DI::l10n()->t('Personal Page'),
 198                                 User::ACCOUNT_TYPE_ORGANISATION => DI::l10n()->t('Organisation Page'),
 199                                 User::ACCOUNT_TYPE_NEWS         => DI::l10n()->t('News Page'),
 200                                 User::ACCOUNT_TYPE_COMMUNITY    => DI::l10n()->t('Community Forum'),
 201                                 User::ACCOUNT_TYPE_RELAY        => DI::l10n()->t('Relay'),
 202                         ];
 203
 204                         $e['page_flags_raw'] = $e['page-flags'];
 205                         $e['page-flags'] = $page_types[$e['page-flags']];
 206
 207                         $e['account_type_raw'] = ($e['page_flags_raw'] == 0) ? $e['account-type'] : -1;
 208                         $e['account-type'] = ($e['page_flags_raw'] == 0) ? $account_types[$e['account-type']] : '';
 209
 210                         $e['register_date'] = Temporal::getRelativeDate($e['register_date']);
 211                         $e['login_date'] = Temporal::getRelativeDate($e['login_date']);
 212                         $e['lastitem_date'] = Temporal::getRelativeDate($e['lastitem_date']);
 213                         $e['is_admin'] = in_array($e['email'], $adminlist);
 214                         $e['is_deletable'] = (intval($e['uid']) != local_user());
 215                         $e['deleted'] = ($e['account_removed'] ? Temporal::getRelativeDate($e['account_expires_on']) : False);
 216
 217                         return $e;
 218                 };
 219
 220                 $tmp_users = array_map($_setup_users, $users);
 221
 222                 // Get rid of dashes in key names, Smarty3 can't handle them
 223                 // and extracting deleted users
 224
 225                 $deleted = [];
 226                 $users = [];
 227                 foreach ($tmp_users as $user) {
 228                         foreach ($user as $k => $v) {
 229                                 $newkey = str_replace('-', '_', $k);
 230                                 $user[$newkey] = $v;
 231                         }
 232
 233                         if ($user['deleted']) {
 234                                 $deleted[] = $user;
 235                         } else {
 236                                 $users[] = $user;
 237                         }
 238                 }
 239
 240                 $th_users = array_map(null, [DI::l10n()->t('Name'), DI::l10n()->t('Email'), DI::l10n()->t('Register date'), DI::l10n()->t('Last login'), DI::l10n()->t('Last public item'), DI::l10n()->t('Type')], $valid_orders);
 241
 242                 $t = Renderer::getMarkupTemplate('admin/users.tpl');
 243                 $o = Renderer::replaceMacros($t, [
 244                         // strings //
 245                         '$title' => DI::l10n()->t('Administration'),
 246                         '$page' => DI::l10n()->t('Users'),
 247                         '$submit' => DI::l10n()->t('Add User'),
 248                         '$select_all' => DI::l10n()->t('select all'),
 249                         '$h_pending' => DI::l10n()->t('User registrations waiting for confirm'),
 250                         '$h_deleted' => DI::l10n()->t('User waiting for permanent deletion'),
 251                         '$th_pending' => [DI::l10n()->t('Request date'), DI::l10n()->t('Name'), DI::l10n()->t('Email')],
 252                         '$no_pending' => DI::l10n()->t('No registrations.'),
 253                         '$pendingnotetext' => DI::l10n()->t('Note from the user'),
 254                         '$approve' => DI::l10n()->t('Approve'),
 255                         '$deny' => DI::l10n()->t('Deny'),
 256                         '$delete' => DI::l10n()->t('Delete'),
 257                         '$block' => DI::l10n()->t('Block'),
 258                         '$blocked' => DI::l10n()->t('User blocked'),
 259                         '$unblock' => DI::l10n()->t('Unblock'),
 260                         '$siteadmin' => DI::l10n()->t('Site admin'),
 261                         '$accountexpired' => DI::l10n()->t('Account expired'),
 262
 263                         '$h_users' => DI::l10n()->t('Users'),
 264                         '$h_newuser' => DI::l10n()->t('New User'),
 265                         '$th_deleted' => [DI::l10n()->t('Name'), DI::l10n()->t('Email'), DI::l10n()->t('Register date'), DI::l10n()->t('Last login'), DI::l10n()->t('Last public item'), DI::l10n()->t('Permanent deletion')],
 266                         '$th_users' => $th_users,
 267                         '$order_users' => $order,
 268                         '$order_direction_users' => $order_direction,
 269
 270                         '$confirm_delete_multi' => DI::l10n()->t('Selected users will be deleted!\n\nEverything these users had posted on this site will be permanently deleted!\n\nAre you sure?'),
 271                         '$confirm_delete' => DI::l10n()->t('The user {0} will be deleted!\n\nEverything this user has posted on this site will be permanently deleted!\n\nAre you sure?'),
 272
 273                         '$form_security_token' => parent::getFormSecurityToken('admin_users'),
 274
 275                         // values //
 276                         '$baseurl' => DI::baseUrl()->get(true),
 277
 278                         '$pending' => $pending,
 279                         'deleted' => $deleted,
 280                         '$users' => $users,
 281                         '$newusername' => ['new_user_name', DI::l10n()->t('Name'), '', DI::l10n()->t('Name of the new user.')],
 282                         '$newusernickname' => ['new_user_nickname', DI::l10n()->t('Nickname'), '', DI::l10n()->t('Nickname of the new user.')],
 283                         '$newuseremail' => ['new_user_email', DI::l10n()->t('Email'), '', DI::l10n()->t('Email address of the new user.'), '', '', 'email'],
 284                 ]);
 285
 286                 $o .= $pager->renderFull(DBA::count('user'));
 287
 288                 return $o;
 289         }
 290 }