Context Navigation

source: trunk/expressoMail1_2/inc/class.ldap_functions.inc.php @ 205

Revision 205, 15.9 KB checked in by niltonneto, 16 years ago (diff)
ver Ticket #154 e #155; Otimizar verificação do Fora de Escritório; Otimizar código que salva as preferências;
Property svn:eol-style set to `native` Property svn:executable set to ``*

Line
1	<?php
2	include_once("class.imap_functions.inc.php");
3
4	function ldapRebind($ldap_connection, $ldap_url)
5	{
6	@ldap_bind($ldap_connection, $_SESSION['phpgw_info']['expressomail']['ldap_server']['acc'],$_SESSION['phpgw_info']['expressomail']['ldap_server']['pw']);
7	}
8
9	class ldap_functions
10	{
11	var $ds;
12	var $ldap_host;
13	var $ldap_context;
14	var $imap;
15
16	// usa o host e context do contact center.
17	function ldapConnect($refer = false){
18	$this->ldap_host = $_SESSION['phpgw_info']['expressomail']['ldap_server']['host'];
19	$this->ldap_context = $_SESSION['phpgw_info']['expressomail']['ldap_server']['dn'];
20	$this->ds = ldap_connect($this->ldap_host);
21	ldap_set_option($this->ds, LDAP_OPT_PROTOCOL_VERSION, 3);
22	ldap_set_option($this->ds, LDAP_OPT_REFERRALS, $refer);
23	if ($refer)
24	{
25	ldap_set_rebind_proc($this->ds, ldapRebind);
26	}
27	@ldap_bind($this->ds, $_SESSION['phpgw_info']['expressomail']['ldap_server']['acc'],$_SESSION['phpgw_info']['expressomail']['ldap_server']['pw']);
28	}
29
30	//Teste jakjr retornando o DS
31	function ldapConnect2($refer = false){
32	$ds = ldap_connect($_SESSION['phpgw_info']['expressomail']['ldap_server']['host']);
33
34	if (!$ds)
35	return false;
36
37	ldap_set_option($ds, LDAP_OPT_PROTOCOL_VERSION, 3);
38	ldap_set_option($ds, LDAP_OPT_REFERRALS, $refer);
39	if ($refer)
40	ldap_set_rebind_proc($ds, ldapRebind);
41	@ldap_bind($ds, $_SESSION['phpgw_info']['expressomail']['ldap_server']['acc'],$_SESSION['phpgw_info']['expressomail']['ldap_server']['pw']);
42
43	return $ds;
44	}
45
46
47	// usa o host e context do setup.
48	function ldapRootConnect($refer = false){
49	$this->ldap_host = $_SESSION['phpgw_info']['expressomail']['server']['ldap_host'];
50	$this->ldap_context = $_SESSION['phpgw_info']['expressomail']['server']['ldap_context'];
51	$this->ds = ldap_connect($this->ldap_host);
52	ldap_set_option($this->ds, LDAP_OPT_PROTOCOL_VERSION, 3);
53	ldap_set_option($this->ds, LDAP_OPT_REFERRALS, $refer);
54	ldap_bind($this->ds, $_SESSION['phpgw_info']['expressomail']['server']['ldap_root_dn'],$_SESSION['phpgw_info']['expressomail']['server']['ldap_root_pw']);
55
56	}
57
58	function quicksearch($params)
59	{
60	include_once("class.functions.inc.php");
61	$functions = new functions;
62
63	$search_for = $params['search_for'];
64	$field = $params['field'];
65	$ID = $params['ID'];
66
67	$contacts_result = array();
68	$contacts_result['field'] = $field;
69	$contacts_result['ID'] = $ID;
70
71	// follow the referral
72	$this->ldapConnect(true);
73
74	if ($this->ds)
75	{
76	if (($field != 'null') && ($ID != 'null'))
77	{
78	$filter="(&(\|(phpgwAccountType=u)(phpgwAccountType=l))(\|(cn=$search_for)(mail=$search_for*)))";
79	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible", "uid");
80	}
81	else
82	{
83	$filter="(& (phpgwAccountType=u)(cn=$search_for) )";
84	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible", "jpegPhoto", "uid");
85	}
86
87	$sr=ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
88	$count_entries = ldap_count_entries($this->ds,$sr);
89
90	if ($count_entries > 200)
91	{
92	// Close old ldap conection
93	ldap_close($this->ds);
94
95	// Reopen a local ldap connection, following referral
96	$this->ldapRootConnect(true);
97
98	$user_dn = $_SESSION['phpgw_info']['expressomail']['user']['account_dn'];
99	$user_sector_dn = ldap_explode_dn ( $user_dn, false );
100	array_shift($user_sector_dn);
101	array_shift($user_sector_dn);
102	$user_sector_dn = implode(",", $user_sector_dn);
103
104	// New search only on user sector
105	$sr=ldap_search($this->ds, $user_sector_dn, $filter, $justthese);
106	$count_entries = ldap_count_entries($this->ds,$sr);
107
108	if ($count_entries > 200){
109	$return = array();
110	$return['status'] = false;
111	$return['error'] = "many results";
112	return $return;
113	}
114	else
115	{
116	$quickSearch_only_in_userSector = true;
117	}
118	}
119	$info = ldap_get_entries($this->ds, $sr);
120
121	$tmp = array();
122	for ($i=0; $i<$info["count"]; $i++)
123	{
124	if ($info[$i]["phpgwaccountvisible"][0] == '-1')
125	continue;
126	$tmp[$info[$i]["mail"][0] . '%' . $info[$i]["telephonenumber"][0] . '%'. $info[$i]["mobile"][0] . '%' . $info[$i]["uid"][0] . '%' . $info[$i]["jpegphoto"]['count']] = $info[$i]["cn"][0];
127	}
128	natcasesort($tmp);
129
130	$i = 0;
131	if (($field != 'null') && ($ID != 'null'))
132	{
133	foreach ($tmp as $info => $cn)
134	{
135	$contacts_result[$i] = array();
136	$contacts_result[$i]["cn"] = $cn;
137	list ($contacts_result[$i]["mail"], $contacts_result[$i]["phone"], $contacts_result[$i]["mobile"]) = split ('%', $info);
138	$i++;
139	}
140	$contacts_result['quickSearch_only_in_userSector'] = $quickSearch_only_in_userSector;
141	}
142	else
143	{
144	$options = '';
145
146	foreach ($tmp as $info => $cn)
147	{
148	$contacts_result[$i] = array();
149	$contacts_result[$i]["cn"] = $cn;
150	list ($contacts_result[$i]["mail"], $contacts_result[$i]["phone"], $contacts_result[$i]["mobile"], $contacts_result[$i]["uid"], $contacts_result[$i]["jpegphoto"]) = split ('%', $info);
151
152	if ($contacts_result[$i]['jpegphoto'])
153	$photo_link = '<img src="./inc/show_user_photo.php?mail='.$contacts_result[$i]['mail'].'">';
154	else
155	$photo_link = '<img src="./templates/default/images/photo.png">';
156
157	// '<tr class="quicksearchcontacts_unselected" onClick="javascript:QuickSearchUser.select_cc(this)">' .
158	$phoneUser = $contacts_result[$i]['phone'];
159
160	if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['voip_enabled'] && $phoneUser) {
161	$phoneUser = '<a title="'.$functions->getLang("Call to Comercial Number").'" href="#" onclick="InfoContact.connectVoip(\''.$phoneUser.'\',\'com\')">'.$phoneUser.'</a>';
162	if($contacts_result[$i]['mobile']){
163	$phoneUser .= ' / <a title="'.$functions->getLang("Call to Mobile Number").'" href="#" onclick="InfoContact.connectVoip(\''.$contacts_result[$i]['mobile'].'\',\'mob\')">'.$contacts_result[$i]['mobile'].'</a>';
164	}
165	}
166	$options .=
167	'<tr class="quicksearchcontacts_unselected">' .
168	'<td class="cc" width="1%">' .
169	'<a title="'.$functions->getLang("Write message").'" onClick="javascript:QuickSearchUser.create_new_message(\''.$contacts_result[$i]["cn"].'\', \''.$contacts_result[$i]["mail"].'\')">' .
170	$photo_link .
171	'</a>' .
172	'</td>' .
173	'<td class="cc">' .
174	'<span name="cn">' . $contacts_result[$i]['cn'] . '</span>' . '<br>' .
175	'<a title="'.$functions->getLang("Write message").'" onClick="javascript:QuickSearchUser.create_new_message(\''.$contacts_result[$i]["cn"].'\', \''.$contacts_result[$i]["mail"].'\')">' .
176	'<font color=blue>' .
177	'<span name="mail">' . $contacts_result[$i]['mail'] . '</span>' . '<br>' .
178	'</font>' .
179	'</a>' .
180	$phoneUser .
181	'</td>' .
182	'</tr>';
183	$i++;
184	}
185	$contacts_result = $options;
186
187	if ($quickSearch_only_in_userSector)
188	{
189	$head_option =
190	'<tr class="quicksearchcontacts_unselected">' .
191	'<td colspan="2" width="100%" align="center">' .
192	$functions->getLang('More than 200 results were found') . '.<br>' .
193	$functions->getLang('Showing only the results found in your organization') . '.';
194	'</td>' .
195	'</tr>';
196	$contacts_result = $head_option . $contacts_result;
197	}
198	}
199	}
200	ldap_close($this->ds);
201	return $contacts_result;
202	}
203
204	function get_organizations($params){
205	$organizations = array();
206	$referral = $params['referral'];
207	$this->ldapConnect($referral);
208	if ($this->ds) {
209	$filter="ou=*";
210	$justthese = array("ou");
211	$sr = ldap_list($this->ds, $this->ldap_context, $filter, $justthese);
212	$info = ldap_get_entries($this->ds, $sr);
213
214	for ($i=0; $i<$info["count"]; $i++)
215	$organizations[$i] = $info[$i]["ou"][0];
216
217	ldap_close($this->ds);
218	sort($organizations);
219	}
220	return $organizations;
221	}
222
223	function get_organizations2($params){
224	$organizations = array();
225	$referral = $params['referral'];
226	$this->ldapRootConnect($referral);
227	if ($this->ds) {
228	$filter="ou=*";
229	$justthese = array("ou");
230	$sr = ldap_list($this->ds, $this->ldap_context, $filter, $justthese);
231	$info = ldap_get_entries($this->ds, $sr);
232
233	for ($i=0; $i<$info["count"]; $i++)
234	{
235	$organizations[$i]['ou'] = $info[$i]["ou"][0];
236	$organizations[$i]['dn'] = $info[$i]["dn"];
237	}
238
239	ldap_close($this->ds);
240	sort($organizations);
241	}
242	return $organizations;
243	}
244
245	function catalogsearch($params)
246	{
247	$this->ldapConnect(true);
248	$cn = $params['search_for'] ? "".$params['search_for']."" : "*";
249	$user_context = "ou=".$params['organization'].",".$this->ldap_context;
250	$max_result = $params['max_result'] ? $params['max_result'] : '200';
251	$error = False;
252
253	if ($this->ds) {
254	$justthese = array("cn", "mail", "phpgwaccounttype", "phpgwAccountVisible");
255	$filter="(&(\|(phpgwAccountType=u)(phpgwAccountType=l))(cn=".$cn."))";
256	$sr=ldap_search($this->ds, $user_context, $filter, $justthese);
257
258	$count_entries = ldap_count_entries($this->ds,$sr);
259	if ($count_entries > $max_result){
260	$info = null;
261	$error = True;
262	}
263	else
264	$info = ldap_get_entries($this->ds, $sr);
265
266	ldap_close($this->ds);
267
268	$u_tmp = array();
269	$g_tmp = array();
270
271	for ($i=0; $i<$info["count"]; $i++){
272	if((strtoupper($info[$i]["phpgwaccounttype"][0]) == 'U') && ($info[$i]["phpgwaccountvisible"][0] != '-1'))
273	$u_tmp[$info[$i]["mail"][0]] = $info[$i]["cn"][0];
274	else
275	$g_tmp[$info[$i]["mail"][0]] = $info[$i]["cn"][0];
276	}
277
278	natcasesort($u_tmp);
279	natcasesort($g_tmp);
280
281	$i = 0;
282	$users = array();
283
284	foreach ($u_tmp as $mail => $cn){
285	$users[$i++] = array("name" => $cn, "email" => $mail);
286	}
287	unset($u_tmp);
288
289	$i = 0;
290	$groups = array();
291
292	foreach ($g_tmp as $mail => $cn){
293	$groups[$i++] = array("name" => $cn, "email" => $mail);
294	}
295	unset($g_tmp);
296
297	return array('users' => $users, 'groups' => $groups, 'error' => $error);
298	}
299	return null;
300	}
301
302	function get_emails_ldap(){
303
304	$result['mail']= array();
305	$result['mailalter']= array();
306	$user = $_SESSION['phpgw_info']['expressomail']['user']['account_lid'];
307	$this->ldapRootConnect(false);
308	if ($this->ds) {
309	$filter="uid=".$user;
310	$justthese = array("mail","mailAlternateAddress");
311	$sr = ldap_search($this->ds,$this->ldap_context, $filter, $justthese);
312	$ent = ldap_get_entries($this->ds, $sr);
313	ldap_close($this->ds);
314
315	for ($i=0; $i<$ent["count"]; $i++){
316	$result['mail'][] = $ent[$i]["mail"][0];
317	$result['mailalter'][] = $ent[$i]["mailalternateaddress"][0];
318	}
319	}
320	return $result;
321	}
322
323	//Busca usuários de um contexto e já retorna as options do select;
324	function get_available_users($params)
325	{
326	$this->ldapRootConnect();
327	//Monta lista de Grupos e Usuários
328	$users = Array();
329	$groups = Array();
330	$user_context= $params['context'];
331	$owner = $_SESSION['phpgw_info']['expressomail']['user']['owner'];
332
333	if ($this->ds)
334	{
335	$justthese = array("gidNumber","cn");
336	if ($params['type'] == 'search')
337	$sr=ldap_search($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=g)(!(phpgwaccountvisible=-1)))"),$justthese);
338	else
339	$sr=ldap_list($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=g)(!(phpgwaccountvisible=-1)))"),$justthese);
340	$info = ldap_get_entries($this->ds, $sr);
341	for ($i=0; $i<$info["count"]; $i++)
342	$groups[$uids=$info[$i]["gidnumber"][0]] = Array('name' => $uids=$info[$i]["cn"][0], 'type' => g);
343	$justthese = array("phpgwaccountvisible","uidNumber","cn");
344	if ($params['type'] == 'search')
345	$sr=ldap_search($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=u)(!(phpgwaccountvisible=-1)))"),$justthese);
346	else
347	$sr=ldap_list($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=u)(!(phpgwaccountvisible=-1)))"),$justthese);
348
349	$info = ldap_get_entries($this->ds, $sr);
350	for ($i=0; $i<$info["count"]; $i++)
351	{
352	if ($info[$i]["phpgwaccountvisible"][0] == '-1')
353	continue;
354	$users[$uids=$info[$i]["uidnumber"][0]] = Array('name' => $uids=$info[$i]["cn"][0], 'type' => u);
355	}
356	}
357	ldap_close($this->ds);
358
359	@asort($users);
360	@reset($users);
361	@asort($groups);
362	@reset($groups);
363	$user_options ='';
364	$group_options ='';
365
366	foreach($groups as $id => $user_array) {
367	$newId = $id.'U';
368	$group_options .= '<option value="'.$newId.'">'.utf8_decode($user_array['name']).'</option>'."\n";
369	}
370	foreach($users as $id => $user_array) {
371	if($owner != $id){
372	$newId = $id.'U';
373	$user_options .= '<option value="'.$newId.'">'.utf8_decode($user_array['name']).'</option>'."\n";
374	}
375	}
376	return array("users" => $user_options, "groups" => $group_options);
377	}
378
379	//Busca usuários de um contexto e já retorna as options do select;
380	function get_available_users2($params)
381	{
382	$this->ldapRootConnect();
383
384	$context= $params['context'];
385	$justthese = array("cn", "uid", "cn");
386	$filter = "(&(phpgwaccounttype=u)(!(phpgwaccountvisible=-1)))";
387
388	if ($this->ds)
389	{
390	$sr=ldap_search($this->ds, $context, $filter, $justthese);
391	$entries = ldap_get_entries($this->ds, $sr);
392
393	for ($i=0; $i<$entries["count"]; $i++){
394	if($_SESSION['phpgw_info']['expressomail']['user']['account_lid'] != $entries[$i]["uid"][0]){
395	$u_tmp[$entries[$i]["uid"][0]] = $entries[$i]["cn"][0];
396	}
397	}
398
399	natcasesort($u_tmp);
400
401	$i = 0;
402	$users = array();
403
404	if (count($u_tmp))
405	{
406	foreach ($u_tmp as $uidnumber => $cn)
407	{
408	$options .= "<option value=$uidnumber>$cn</option>";
409	}
410	unset($u_tmp);
411	}
412
413	ldap_close($this->ds);
414	return $options;
415	}
416	}
417
418	function uid2cn($uid)
419	{
420	// do not follow the referral
421	$this->ldapRootConnect(false);
422	if ($this->ds)
423	{
424	$filter="(&(phpgwAccountType=u)(uid=$uid))";
425	$justthese = array("cn");
426	$sr=ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
427
428	$info = ldap_get_entries($this->ds, $sr);
429	return $info[0]["cn"][0];
430	}
431	return false;
432	}
433	function getSharedUsersFrom($params){
434	$uids = explode(";",$params['uids']);
435
436	$this->imap = new imap_functions();
437	$filter = '';
438
439	foreach($uids as $index => $uid){
440	$params = array();
441	$acl = $this->imap->getacltouser($uid);
442	if(preg_match("/a/",$acl))
443	$filter .= "(uid=$uid)";
444	}
445
446	$this->ldapRootConnect(false);
447	$filter="(&(phpgwAccountType=u)(\|$filter))";
448	if ($this->ds) {
449	$justthese = array("cn","mail");
450	$sr = ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
451	ldap_sort($this->ds,$sr,"cn");
452	$info = ldap_get_entries($this->ds, $sr);
453	$info['myname'] = $_SESSION['phpgw_info']['expressomail']['user']['fullname'];
454	return $info;
455	}
456	}
457
458	function getUserByEmail($params)
459	{
460	$filter="(&(phpgwAccountType=u)(mail=" . $params['email'] . "))";
461	$ldap_context = $_SESSION['phpgw_info']['expressomail']['ldap_server']['dn'];
462	$justthese = array("cn","uid","telephoneNumber","jpegPhoto","mobile");
463
464	// Follow the referral
465	$ds = $this->ldapConnect2(true);
466	if ($ds)
467	{
468	$sr=ldap_search($ds, $ldap_context, $filter, $justthese);
469
470	if (!$sr)
471	return null;
472
473	$entry = ldap_first_entry($ds, $sr);
474
475	if($entry) {
476	$obj = array("cn" => ldap_get_values($ds, $entry, "cn"),
477	"email" => $params['email'],
478	"uid" => ldap_get_values($ds, $entry, "uid"),
479	"type" => "global",
480	"mobile" => @ldap_get_values($ds, $entry, "mobile"),
481	"telefone" => @ldap_get_values($ds, $entry, "telephonenumber")
482	);
483
484	$_SESSION['phpgw_info']['expressomail']['contact_photo'] = ldap_get_values_len($ds, $entry, "jpegphoto");
485	ldap_close($ds);
486	return $obj;
487	}
488	}
489	return null;
490	}
491	}
492	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: