Subscriber.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\OnScreenChat\Repository;

use ilDBInterface;
use ilObjUser;
use ilUserUtil;
use ilWACException;
use ilWACSignedPath;

class Subscriber
{
    public function __construct(protected ilDBInterface $db, protected ilObjUser $user)
    {
    }

    public function getInitialUserProfileData(): array
    {
        $conversationIds = [];

        $res = $this->db->queryF(
            'SELECT DISTINCT(conversation_id) FROM osc_activity WHERE user_id = %s',
            ['integer'],
            [$this->user->getId()]
        );
        while ($row = $this->db->fetchAssoc($res)) {
            $conversationIds[$row['conversation_id']] = $row['conversation_id'];
        }

        $res = $this->db->queryF(
            'SELECT DISTINCT(conversation_id) FROM osc_messages WHERE user_id = %s',
            ['integer'],
            [$this->user->getId()]
        );
        while ($row = $this->db->fetchAssoc($res)) {
            $conversationIds[$row['conversation_id']] = $row['conversation_id'];
        }

        if (0 === count($conversationIds)) {
            return [];
        }

        $usrIds = [];

        $in = $this->db->in('id', $conversationIds, false, 'text');
        $res = $this->db->query('SELECT DISTINCT(participants) FROM osc_conversation WHERE ' . $in);
        while ($row = $this->db->fetchAssoc($res)) {
            $participants = json_decode((string) $row['participants'], true, 512, JSON_THROW_ON_ERROR);

            if (is_array($participants)) {
                $usrIds = array_unique(array_merge($usrIds, array_filter(array_map(static function ($user): int {
                    if (is_array($user) && isset($user['id'])) {
                        return (int) $user['id'];
                    }

                    return 0;
                }, $participants))));
            }
        }

        return $this->getDataByUserIds($usrIds);
    }

    public function getDataByUserIds(array $usrIds): array
    {
        $usrIds = array_filter(array_map('intval', array_map('trim', $usrIds)));

        $oldWacTokenValue = ilWACSignedPath::getTokenMaxLifetimeInSeconds();
        ilWACSignedPath::setTokenMaxLifetimeInSeconds(60);

        $publicData = ilUserUtil::getNamePresentation($usrIds, true, false, '', false, true, false, true);

        $data = [];

        foreach ($usrIds as $usr_id) {
            $publicImage = $publicData[$usr_id]['img'] ?? '';
            $publicName = '';

            if (isset($publicData[$usr_id])) {
                $login = '';
                if (isset($publicData[$usr_id]['login'])) {
                    $publicName = $login = $publicData[$usr_id]['login'];
                }

                if (isset($publicData[$usr_id]['public_profile']) && $publicData[$usr_id]['public_profile']) {
                    $publicName = implode(' ', array_filter(array_map('trim', [
                        (string) ($publicData[$usr_id]['firstname'] ?? ''),
                        (string) ($publicData[$usr_id]['lastname'] ?? ''),
                    ])));

                    if ($publicName === '') {
                        $publicName = $login;
                    }
                }
            }

            $data[$usr_id] = [
                'public_name' => $publicName,
                'profile_image' => $publicImage
            ];
        }

        ilWACSignedPath::setTokenMaxLifetimeInSeconds($oldWacTokenValue);

        return $data;
    }
}