ILIAS\Contact\BuddySystem\MailRecipientSearch\MailRecipientSearchProvider Class Reference

Inheritance diagram for ILIAS\Contact\BuddySystem\MailRecipientSearch\MailRecipientSearchProvider:

Collaboration diagram for ILIAS\Contact\BuddySystem\MailRecipientSearch\MailRecipientSearchProvider:

Protected Member Functions
	getFromPart ()
Protected Member Functions inherited from ILIAS\Mail\RecipientSearch\LegacyUserSearchBasedProvider
	getSelectPart ()
	getFromPart ()
	getWherePart (string $search_query)
	getOrderByPart ()
	getQueryConditionByFieldAndValue (string $field, $a_str)
	getFields ()

Additional Inherited Members
Public Member Functions inherited from ILIAS\Mail\RecipientSearch\LegacyUserSearchBasedProvider
	current ()
	key ()
	rewind ()
Public Member Functions inherited from ILIAS\Mail\RecipientSearch\RecipientSearchProvider
	__construct (protected string $quoted_term, protected string $term)
	valid ()
	next ()
	__destruct ()
Protected Attributes inherited from ILIAS\Mail\RecipientSearch\RecipientSearchProvider
ilDBInterface	$db
ilDBStatement	$res = null
array	$data = null
int	$user_id = 0

Detailed Description

Definition at line 25 of file MailRecipientSearchProvider.php.

Member Function Documentation

getFromPart()

ILIAS\Contact\BuddySystem\MailRecipientSearch\MailRecipientSearchProvider::getFromPart ( )

protected

Reimplemented from ILIAS\Mail\RecipientSearch\LegacyUserSearchBasedProvider.

Definition at line 27 of file MailRecipientSearchProvider.php.

                                    : string
    {
        $joins = [];
 
        $joins[] = implode(' ', [
            'INNER JOIN buddylist',
            'ON ((',
            'buddylist.usr_id = usr_data.usr_id AND',
            'buddylist.buddy_usr_id = ' . $this->db->quote($this->user_id, 'integer'),
            ') OR (',
            'buddylist.buddy_usr_id = usr_data.usr_id AND',
            'buddylist.usr_id = ' . $this->db->quote($this->user_id, 'integer'),
            '))',
        ]);
 
        $joins[] = implode(' ', [
            'LEFT JOIN usr_pref profpref',
            'ON profpref.usr_id = usr_data.usr_id',
            'AND profpref.keyword = ' . $this->db->quote('public_profile', 'text'),
        ]);
 
        $joins[] = implode(' ', [
            'LEFT JOIN usr_pref pubemail',
            'ON pubemail.usr_id = usr_data.usr_id',
            'AND pubemail.keyword = ' . $this->db->quote('public_email', 'text'),
        ]);
 
        return 'usr_data ' . implode(' ', $joins);
    }

---

The documentation for this class was generated from the following file:

• components/ILIAS/Contact/BuddySystem/classes/UserSearch/ILIAS/Contact/BuddySystem/UserSearch/MailRecipientSearchProvider.php