comments_block.php

Go to the documentation of this file.

<?php
$options = [
    'type' => 'object',
    'subtype' => 'comment',
    'limit' => elgg_extract('limit', $vars, 4),
    'wheres' => [],
    'preload_owners' => true,
    'distinct' => false,
    'metadata_name_value_pairs' => ['level' => 1],
];

$owner_guid = elgg_extract('owner_guid', $vars);
$container_guid = elgg_extract('container_guid', $vars);
$subtypes = elgg_extract('subtypes', $vars);

// If owner is defined, view only the comments that have
// been posted on objects owned by that user
if ($owner_guid) {
    $options['wheres'][] = function(\Elgg\Database\QueryBuilder $qb) use ($owner_guid) {
        $qb->joinEntitiesTable('e', 'container_guid', 'inner', 'ce');
        return $qb->compare('ce.owner_guid', '=', $owner_guid, ELGG_VALUE_INTEGER);
    };
}

// If container is defined, view only the comments that have
// been posted on objects placed inside that container
if ($container_guid) {
    $options['wheres'][] = function(\Elgg\Database\QueryBuilder $qb) use ($container_guid) {
        $qb->joinEntitiesTable('e', 'container_guid', 'inner', 'ce');
        return $qb->compare('ce.container_guid', '=', $container_guid, ELGG_VALUE_INTEGER);
    };
}

// If subtypes are defined, view only the comments that have been
// posted on objects that belong to any of those subtypes
if ($subtypes) {
    $options['wheres'][] = function(\Elgg\Database\QueryBuilder $qb) use ($subtypes) {
        $qb->joinEntitiesTable('e', 'container_guid', 'inner', 'ce');
        return $qb->compare('ce.subtype', 'IN', $subtypes, ELGG_VALUE_STRING);
    };
}

$comments = elgg_get_entities($options);
if (empty($comments)) {
    return;
}

$body = elgg_view_entity_list($comments, [
    'pagination' => false,
    'full_view' => false,
    'list_class' => 'elgg-latest-comments',
]);

echo elgg_view_module('aside', elgg_echo('generic_comments:latest'), $body);