users.php

Go to the documentation of this file.

<?php
use Elgg\Database\Clauses\JoinClause;
use Elgg\Database\QueryBuilder;

$user = elgg_extract('entity', $vars);
if (!$user instanceof \ElggUser) {
    return;
}

echo elgg_view_field([
    '#type' => 'hidden',
    'name' => 'guid',
    'value' => $user->guid,
]);

echo elgg_view('output/longtext', [
    'value' => elgg_echo('usersettings:notifications:users:description'),
]);

// Returns a list of all friends, as well as anyone else who the user is subscribed to
$list = elgg_list_entities([
    'selects' => ['GROUP_CONCAT(ers.relationship) as relationships'],
    'types' => 'user',
    'joins' => [
        new JoinClause('entity_relationships', 'ers', function(QueryBuilder $qb, $joined_alias, $main_alias) use ($user) {
            return $qb->merge([
                $qb->compare("{$joined_alias}.guid_two", '=', "{$main_alias}.guid"),
                $qb->compare("{$joined_alias}.guid_one", '=', $user->guid, ELGG_VALUE_INTEGER),
            ], 'AND');
        }),
    ],
    'wheres' => [
        function(QueryBuilder $qb) {
            return $qb->merge([
                $qb->compare('ers.relationship', '=', 'friend', ELGG_VALUE_STRING),
                $qb->compare('ers.relationship', 'LIKE', 'notify:%', ELGG_VALUE_STRING),
            ], 'OR');
        },
    ],
    'sort_by' => [
        'property' => 'name',
        'direction' => 'ASC',
    ],
    'group_by' => 'e.guid',
    'offset_key' => 'subscriptions_users',
    'item_view' => 'notifications/subscriptions/record',
    'user' => $user,
    'limit' => 10,
    'list_class' => 'elgg-subscriptions',
    'item_class' => 'elgg-subscription-record',
    'pagination_behaviour' => 'ajax-replace',
]);

if (empty($list)) {
    echo elgg_view('page/components/no_results', [
        'no_results' => elgg_echo('notifications:subscriptions:no_results'),
    ]);
    return;
}

echo $list;

// form footer
$footer = elgg_view_field([
    '#type' => 'submit',
    'text' => elgg_echo('save'),
]);

elgg_set_form_footer($footer);