class.ilOnScreenChatUserUserAutoComplete.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

require_once 'Services/User/classes/class.ilUserAutoComplete.php';

class ilOnScreenChatUserUserAutoComplete extends ilUserAutoComplete
{
    protected function getFromPart(): string
    {
        global $DIC;

        $from_part = parent::getFromPart();
        $from_part .= '
                        INNER JOIN usr_pref chat_osc_am
                                ON chat_osc_am.usr_id = ud.usr_id
                                AND chat_osc_am.keyword = ' . $DIC->database()->quote('chat_osc_accept_msg', 'text') . '
                                AND chat_osc_am.value = ' . $DIC->database()->quote('y', 'text') . ' ';

        return $from_part;
    }

    protected function getWherePart(array $search_query): string
    {
        global $DIC;

        $where = parent::getWherePart($search_query);
        $where .= ' AND (ud.usr_id != ' . $DIC->database()->quote($this->getUser()->getId(), 'integer') . ') ';

        return $where;
    }
}