function ForumManager::unreadTopics

File

core/modules/forum/src/ForumManager.php, line 485

Class

ForumManager

Provides forum manager service.

Namespace

Code

public function unreadTopics($term, $uid) {
    $query = $this->connection
        ->select('node_field_data', 'n');
    $query->join('forum', 'f', '[n].[vid] = [f].[vid] AND [f].[tid] = :tid', [
        ':tid' => $term,
    ]);
    $query->leftJoin('history', 'h', '[n].[nid] = [h].[nid] AND [h].[uid] = :uid', [
        ':uid' => $uid,
    ]);
    $query->addExpression('COUNT([n].[nid])', 'count');
    return $query->condition('status', 1)
        ->condition('n.default_langcode', 1)
        ->condition('n.created', HISTORY_READ_LIMIT, '>')
        ->isNull('h.nid')
        ->addTag('node_access')
        ->execute()
        ->fetchField();
}