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
4require_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}
Class ilMailAutoCompleteUserProvider.
global $ilDB