ILIAS  release_8 Revision v8.23
ilMailAutoCompleteBuddyRecipientsProvider Class Reference

Class ilMailAutoCompleteBuddyRecipientsProvider. More...

+ Inheritance diagram for ilMailAutoCompleteBuddyRecipientsProvider:
+ Collaboration diagram for ilMailAutoCompleteBuddyRecipientsProvider:

Protected Member Functions

 getFromPart ()
 
- Protected Member Functions inherited from ilMailAutoCompleteUserProvider
 getSelectPart ()
 
 getFromPart ()
 
 getWherePart (string $search_query)
 
 getOrderByPart ()
 
 getQueryConditionByFieldAndValue (string $field, $a_str)
 
 getFields ()
 

Additional Inherited Members

- Public Member Functions inherited from ilMailAutoCompleteUserProvider
 current ()
 
 key ()
 
 rewind ()
 
- Public Member Functions inherited from ilMailAutoCompleteRecipientProvider
 __construct (string $quoted_term, string $term)
 
 valid ()
 
 next ()
 
 __destruct ()
 
- Protected Attributes inherited from ilMailAutoCompleteRecipientProvider
ilDBInterface $db
 
ilDBStatement $res = null
 
array $data = null
 
string $quoted_term
 
string $term = ''
 
int $user_id = 0
 

Detailed Description

Member Function Documentation

◆ getFromPart()

ilMailAutoCompleteBuddyRecipientsProvider::getFromPart ( )
protected
Returns
string

Definition at line 29 of file class.ilMailAutoCompleteBuddyRecipientsProvider.php.

29  : string
30  {
31  $joins = [];
32 
33  $joins[] = implode(' ', [
34  'INNER JOIN buddylist',
35  'ON ((',
36  'buddylist.usr_id = usr_data.usr_id AND',
37  'buddylist.buddy_usr_id = ' . $this->db->quote($this->user_id, 'integer'),
38  ') OR (',
39  'buddylist.buddy_usr_id = usr_data.usr_id AND',
40  'buddylist.usr_id = ' . $this->db->quote($this->user_id, 'integer'),
41  '))',
42  ]);
43 
44  $joins[] = implode(' ', [
45  'LEFT JOIN usr_pref profpref',
46  'ON profpref.usr_id = usr_data.usr_id',
47  'AND profpref.keyword = ' . $this->db->quote('public_profile', 'text'),
48  ]);
49 
50  $joins[] = implode(' ', [
51  'LEFT JOIN usr_pref pubemail',
52  'ON pubemail.usr_id = usr_data.usr_id',
53  'AND pubemail.keyword = ' . $this->db->quote('public_email', 'text'),
54  ]);
55 
56  return 'usr_data ' . implode(' ', $joins);
57  }

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