class.ilRoleMailboxSearch.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilRoleMailboxSearch
{
    protected ilDBInterface $db;

    public function __construct(
        protected ilMailRfc822AddressParserFactory $parser_factory,
        ?ilDBInterface $db = null
    ) {
        global $DIC;

        $this->db = $db ?? $DIC->database();
    }

    public function searchRoleIdsByAddressString(string $a_address_list): array
    {
        $parser = $this->parser_factory->getParser($a_address_list);
        $parsed_list = $parser->parse();

        $role_ids = [];
        foreach ($parsed_list as $address) {
            $local_part = $address->getMailbox();
            if (!str_starts_with($local_part, '#') && !($local_part[0] === '"' && $local_part[1] === '#')) {
                // A local-part which doesn't start with a '#' doesn't denote a role.
                // Therefore we can skip it.
                continue;
            }

            $local_part = substr($local_part, 1);

            /* If role contains spaces, eg. 'foo role', double quotes are added which have to be removed here.*/
            if ($local_part[0] === '#' && $local_part[strlen($local_part) - 1] === '"') {
                $local_part = substr($local_part, 1);
                $local_part = substr($local_part, 0, -1);
            }

            if (str_starts_with($local_part, 'il_role_')) {
                $role_id = substr($local_part, 8);
                $query = 'SELECT t.tree ' .
                    'FROM rbac_fa fa ' .
                    'JOIN tree t ON t.child = fa.parent ' .
                    'WHERE fa.rol_id = ' . $this->db->quote($role_id, 'integer') . ' ' .
                    "AND fa.assign = 'y' " .
                    'AND t.tree = 1';
                $res = $this->db->query($query);
                if ($this->db->numRows($res) > 0) {
                    $role_ids[] = (int) $role_id;
                }
                continue;
            }

            $domain = $address->getHost();
            if (str_starts_with($domain, '[') && strrpos($domain, ']')) {
                $domain = substr($domain, 1, -1);
            }
            if ($local_part === '') {
                $local_part = $domain;
                $address->setHost(ilMail::ILIAS_HOST);
                $domain = ilMail::ILIAS_HOST;
            }

            if (strtolower($address->getHost()) === ilMail::ILIAS_HOST) {
                // Search for roles = local-part in the whole repository
                $query = 'SELECT dat.obj_id ' .
                    'FROM object_data dat ' .
                    'JOIN rbac_fa fa ON fa.rol_id = dat.obj_id ' .
                    'JOIN tree t ON t.child = fa.parent ' .
                    'WHERE dat.title =' . $this->db->quote($local_part, 'text') . ' ' .
                    "AND dat.type = 'role' " .
                    "AND fa.assign = 'y' " .
                    'AND t.tree = 1';
            } else {
                // Search for roles like local-part in objects = host
                $query = 'SELECT rdat.obj_id ' .
                    'FROM object_data odat ' .
                    'JOIN object_reference oref ON oref.obj_id = odat.obj_id ' .
                    'JOIN tree otree ON otree.child = oref.ref_id ' .
                    'JOIN rbac_fa rfa ON rfa.parent = otree.child ' .
                    'JOIN object_data rdat ON rdat.obj_id = rfa.rol_id ' .
                    'WHERE odat.title = ' . $this->db->quote($domain, 'text') . ' ' .
                    'AND otree.tree = 1 ' .
                    "AND rfa.assign = 'y' " .
                    'AND rdat.title LIKE ' .
                    $this->db->quote(
                        '%' . preg_replace('/([_%])/', '\\\\$1', $local_part) . '%',
                        'text'
                    );
            }
            $res = $this->db->query($query);

            $count = 0;
            while ($row = $this->db->fetchAssoc($res)) {
                $role_ids[] = (int) $row['obj_id'];

                $count++;
            }

            // Nothing found?
            // In this case, we search for roles = host.
            if ($count === 0 && strtolower($address->getHost()) === ilMail::ILIAS_HOST) {
                $q = 'SELECT dat.obj_id ' .
                    'FROM object_data dat ' .
                    'JOIN object_reference ref ON ref.obj_id = dat.obj_id ' .
                    'JOIN tree t ON t.child = ref.ref_id ' .
                    'WHERE dat.title = ' . $this->db->quote($domain, 'text') . ' ' .
                    "AND dat.type = 'role' " .
                    'AND t.tree = 1 ';
                $res = $this->db->query($q);

                while ($row = $this->db->fetchAssoc($res)) {
                    $role_ids[] = (int) $row['obj_id'];
                }
            }
        }

        return $role_ids;
    }
}