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 $parserFactory,
        ?ilDBInterface $db = null
    ) {
        global $DIC;

        if (null === $db) {
            $db = $DIC->database();
        }
        $this->db = $db;
    }

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

        $role_ids = [];
        foreach ($parsedList 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;
    }
}