class.ilOnScreenChatUserUserAutoComplete.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
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;
    }
}