ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilMailAutoCompleteBuddyRecipientsProvider.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (c) 1998-2014 ILIAS open source, Extended GPL, see docs/LICENSE */
3 
4 require_once 'Services/Mail/classes/class.ilMailAutoCompleteUserProvider.php';
5 
10 {
14  protected function getFromPart()
15  {
19  global $ilDB;
20 
21  $joins = array();
22 
23  $joins[] = '
24  INNER JOIN buddylist
25  ON (
26  (buddylist.usr_id = usr_data.usr_id AND buddylist.buddy_usr_id = ' . $this->db->quote($this->user_id, 'integer') . ') OR
27  (buddylist.buddy_usr_id = usr_data.usr_id AND buddylist.usr_id = ' . $this->db->quote($this->user_id, 'integer') . ')
28  )';
29 
30  $joins[] = '
31  LEFT JOIN usr_pref profpref
32  ON profpref.usr_id = usr_data.usr_id
33  AND profpref.keyword = ' . $ilDB->quote('public_profile', 'text');
34 
35  $joins[] = '
36  LEFT JOIN usr_pref pubemail
37  ON pubemail.usr_id = usr_data.usr_id
38  AND pubemail.keyword = ' . $ilDB->quote('public_email', 'text');
39 
40  if($joins)
41  {
42  return 'usr_data ' . implode(' ', $joins);
43  }
44  else
45  {
46  return 'usr_data ';
47  }
48  }
49 }
global $ilDB
Class ilMailAutoCompleteUserProvider.