Context Navigation

source: branches/2.2/expressoMail1_2/inc/class.ldap_functions.inc.php @ 3388

Revision 3388, 30.1 KB checked in by brunocosta, 14 years ago (diff)
Ticket #619 - Implementadas informações extendidas nas buscas do email.
Property svn:eol-style set to `native` Property svn:executable set to ``*

Line
1	<?php
2	include_once("class.imap_functions.inc.php");
3	include_once("class.functions.inc.php");
4
5	function ldapRebind($ldap_connection, $ldap_url)
6	{
7	@ldap_bind($ldap_connection, $_SESSION['phpgw_info']['expressomail']['ldap_server']['acc'],$_SESSION['phpgw_info']['expressomail']['ldap_server']['pw']);
8	}
9
10	class ldap_functions
11	{
12	var $ds;
13	var $ldap_host;
14	var $ldap_context;
15	var $imap;
16	var $external_srcs;
17	var $max_result;
18	var $functions;
19	function ldap_functions(){
20	// todo: Page Configuration for External Catalogs.
21	@include("../contactcenter/setup/external_catalogs.inc.php");
22	$this->external_srcs= ( isset( $external_srcs ) ) ? $external_srcs : NULL;
23	$this->max_result = 200;
24	$this->functions = new functions();
25	}
26	// Using ContactCenter configuration.
27	function ldapConnect($refer = false,$catalog = 0){
28	if ($catalog > 0 && is_array($this->external_srcs)){
29	$this->ldap_host = $this->external_srcs[$catalog]['host'];
30	$this->ldap_context = $this->external_srcs[$catalog]['dn'];
31	$this->bind_dn = $this->external_srcs[$catalog]['acc'];
32	$this->bind_dn_pw = $this->external_srcs[$catalog]['pw'];
33	$this->object_class = $this->external_srcs[$catalog]['obj'];
34	$this->base_dn = $this->external_srcs[$catalog]['dn'];
35	$this->branch = $this->external_srcs[$catalog]['branch'];
36	}else {
37	$this->ldap_host = $_SESSION['phpgw_info']['expressomail']['ldap_server']['host'];
38	$this->ldap_context = $_SESSION['phpgw_info']['expressomail']['ldap_server']['dn'];
39	$this->bind_dn = $_SESSION['phpgw_info']['expressomail']['ldap_server']['acc'];
40	$this->bind_dn_pw = $_SESSION['phpgw_info']['expressomail']['ldap_server']['pw'];
41	$this->branch = 'ou';
42	}
43
44	$this->ds = ldap_connect($this->ldap_host);
45	ldap_set_option($this->ds, LDAP_OPT_PROTOCOL_VERSION, 3);
46	ldap_set_option($this->ds, LDAP_OPT_REFERRALS, $refer);
47	if ($refer) {
48	ldap_set_rebind_proc($this->ds, ldapRebind);
49	}
50	@ldap_bind($this->ds,$this->bind_dn,$this->bind_dn_pw );
51	}
52
53	//Teste jakjr retornando o DS
54	function ldapConnect2($refer = false){
55	$ds = ldap_connect($_SESSION['phpgw_info']['expressomail']['ldap_server']['host']);
56
57	if (!$ds)
58	return false;
59
60	ldap_set_option($ds, LDAP_OPT_PROTOCOL_VERSION, 3);
61	ldap_set_option($ds, LDAP_OPT_REFERRALS, $refer);
62	if ($refer)
63	ldap_set_rebind_proc($ds, ldapRebind);
64	@ldap_bind($ds, $_SESSION['phpgw_info']['expressomail']['ldap_server']['acc'],$_SESSION['phpgw_info']['expressomail']['ldap_server']['pw']);
65
66	return $ds;
67	}
68
69
70	// usa o host e context do setup.
71	function ldapRootConnect($refer = false){
72	$this->ldap_host = $_SESSION['phpgw_info']['expressomail']['server']['ldap_host'];
73	$this->ldap_context = $_SESSION['phpgw_info']['expressomail']['server']['ldap_context'];
74	$this->ds = ldap_connect($this->ldap_host);
75	ldap_set_option($this->ds, LDAP_OPT_PROTOCOL_VERSION, 3);
76	ldap_set_option($this->ds, LDAP_OPT_REFERRALS, $refer);
77	ldap_bind($this->ds, $_SESSION['phpgw_info']['expressomail']['server']['ldap_root_dn'],$_SESSION['phpgw_info']['expressomail']['server']['ldap_root_pw']);
78
79	}
80
81	function quicksearch($params)
82	{
83	include_once("class.functions.inc.php");
84	$functions = new functions;
85
86	$search_for = utf8_encode($params['search_for']);
87	$field = $params['field'];
88	$ID = $params['ID'];
89
90	if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['extended_info'])
91	$extendedinfo=true;
92	else
93	$extendedinfo=false;
94
95	$search_for = explode(" ",$search_for);
96	$aux="";
97	foreach ($search_for as $search)
98	{
99	if(!$aux)
100	{
101	$aux=$search;
102	}
103	else
104	{
105	if (strlen($search) > 2)
106	{
107	$aux=$aux."*".$search;
108	}
109	else
110	{
111	$aux=$aux." ".$search;
112	}
113	}
114	}
115	$search_for=$aux;
116
117	$contacts_result = array();
118	$contacts_result['field'] = $field;
119	$contacts_result['ID'] = $ID;
120	// follow the referral
121	$this->ldapConnect(true);
122
123	if ($this->ds)
124	{
125	if (($field != 'null') && ($ID != 'null'))
126	{
127	$filter="(& (&(\|(phpgwAccountType=u)(phpgwAccountType=g)(phpgwAccountType=l))(mail=)) (\|(cn=$search_for)(mail=$search_for*)) (!(phpgwaccountvisible=-1)) )";
128	if($extendedinfo)
129	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible", "uid", "employeeNumber", "ou");
130	else
131	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible", "uid");
132	}
133	else
134	{
135	$filter="(& (phpgwAccountType=u)(cn=$search_for) (!(phpgwaccountvisible=-1)) )";
136	if($extendedinfo)
137	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible","jpegPhoto", "uid", "employeeNumber", "ou");
138	else
139	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible","jpegPhoto", "uid");
140	}
141	$sr=@ldap_search($this->ds, $this->ldap_context, $filter, $justthese, 0, $this->max_result + 1);
142	if(!$sr)
143	return null;
144	$count_entries = ldap_count_entries($this->ds,$sr);
145
146	// Get user org dn.
147	$user_dn = $_SESSION['phpgw_info']['expressomail']['user']['account_dn'];
148	$user_sector_dn = ldap_explode_dn ( $user_dn, false );
149	array_shift($user_sector_dn);
150	array_shift($user_sector_dn);
151	$user_sector_dn = implode(",", $user_sector_dn);
152
153	// New search only on user sector
154	if ($count_entries > $this->max_result)
155	{
156	// Close old ldap conection
157	ldap_close($this->ds);
158
159	// Reopen a local ldap connection, following referral
160	$this->ldapRootConnect(true);
161
162	$sr= ldap_search($this->ds, $user_sector_dn, $filter, $justthese);
163	if(!$sr)
164	return null;
165	$count_entries = ldap_count_entries($this->ds,$sr);
166
167	if ($count_entries > $this->max_result){
168	$return = array();
169	$return['status'] = false;
170	$return['error'] = "many results";
171	return $return;
172	}
173	else
174	{
175	$quickSearch_only_in_userSector = true;
176	}
177	}
178
179	$info = ldap_get_entries($this->ds, $sr);
180
181	$tmp = array();
182	$tmp_users_from_user_org = array();
183
184	if (!$quickSearch_only_in_userSector) {
185	$catalogsNum=count($this->external_srcs);
186	for ($i=0; $i<=count($this->external_srcs); $i++) {
187	if ($this->external_srcs[$i]["quicksearch"]) {
188	$this->ldapConnect(true,$i);
189	$filter="(\|(cn=$search_for)(mail=$search_for))";
190	if($extendedinfo)
191	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible", "uid","employeeNumber", "ou");
192	else
193	$justthese = array("cn", "mail", "telephoneNumber", "mobile", "phpgwAccountVisible", "uid");
194	$sr=@ldap_search($this->ds, $this->ldap_context, $filter, $justthese, 0, $this->max_result+1);
195	if(!$sr)
196	return null;
197	$count_entries = ldap_count_entries($this->ds,$sr);
198	$search = ldap_get_entries($this->ds, $sr);
199	for ($j=0; $j<$search["count"]; $j++) {
200	$info[] = $search[$j];
201	}
202	$info["count"] = count($info)-1;
203	}
204	}
205	}
206
207	for ($i=0; $i<$info["count"]; $i++)
208	{
209	if ($quickSearch_only_in_userSector)
210	{
211	$tmp[$info[$i]["mail"][0] . '%' . $info[$i]["telephonenumber"][0] . '%'. $info[$i]["mobile"][0] . '%' . $info[$i]["uid"][0] . '%' . $info[$i]["jpegphoto"]['count'] . '%' . $info[$i]["employeenumber"][0] . '%' . $info[$i]["ou"][0]] = utf8_decode($info[$i]["cn"][0]);
212	}
213	else
214	{
215	if (preg_match("/$user_sector_dn/i", $info[$i]['dn']))
216	{
217	$tmp_users_from_user_org[$info[$i]["mail"][0] . '%' . $info[$i]["telephonenumber"][0] . '%'. $info[$i]["mobile"][0] . '%' . $info[$i]["uid"][0] . '%' . $info[$i]["jpegphoto"]['count'] . '%' . $info[$i]["employeenumber"][0] . '%' . $info[$i]["ou"][0]] = utf8_decode($info[$i]["cn"][0]);
218	}
219	else
220	{
221	$tmp[$info[$i]["mail"][0] . '%' . $info[$i]["telephonenumber"][0] . '%'. $info[$i]["mobile"][0] . '%' . $info[$i]["uid"][0] . '%' . $info[$i]["jpegphoto"]['count'] . '%' . $info[$i]["employeenumber"][0] . '%' . $info[$i]["ou"][0]] = utf8_decode($info[$i]["cn"][0]);
222	}
223	}
224	}
225	natcasesort($tmp_users_from_user_org);
226	natcasesort($tmp);
227
228	if (($field != 'null') && ($ID != 'null'))
229	{
230	$i = 0;
231
232	$tmp = array_merge($tmp, $tmp_users_from_user_org);
233	natcasesort($tmp);
234
235	foreach ($tmp as $info => $cn)
236	{
237	$contacts_result[$i] = array();
238	$contacts_result[$i]["cn"] = $cn;
239	list ($contacts_result[$i]["mail"], $contacts_result[$i]["phone"], $contacts_result[$i]["mobile"], $contacts_result[$i]["uid"], $contacts_result[$i]["jpegphoto"], $contacts_result[$i]["employeenumber"], $contacts_result[$i]["ou"]) = split ('%', $info);
240	$i++;
241	}
242	$contacts_result['quickSearch_only_in_userSector'] = $quickSearch_only_in_userSector;
243	}
244	else
245	{
246	$options_users_from_user_org = '';
247	$options = '';
248
249	/* List of users from user org */
250	$i = 0;
251	foreach ($tmp_users_from_user_org as $info => $cn)
252	{
253	$contacts_result[$i] = array();
254	$options_users_from_user_org .= $this->make_quicksearch_card($info, $cn);
255	$i++;
256	}
257
258	/* List of users from others org */
259	foreach ($tmp as $info => $cn)
260	{
261	$contacts_result[$i] = array();
262	$options .= $this->make_quicksearch_card($info, $cn);
263	$i++;
264	}
265
266	if ($quickSearch_only_in_userSector)
267	{
268	if ($options != '')
269	{
270	$head_option =
271	'<tr class="quicksearchcontacts_unselected">' .
272	'<td colspan="2" width="100%" align="center">' .
273	str_replace("%1", $this->max_result,$this->functions->getLang('More than %1 results were found')) . '.<br>' .
274	$this->functions->getLang('Showing only the results found in your organization') . '.';
275	'</td>' .
276	'</tr>';
277	$contacts_result = $head_option . $options_users_from_user_org . $options;
278	}
279	else
280	{
281	$return = array();
282	$return['status'] = false;
283	$return['error'] = "many results";
284	return $return;
285	}
286	}
287	else
288	{
289	if (($options_users_from_user_org != '') && ($options != ''))
290	{
291	$head_option0 =
292	'<tr class="quicksearchcontacts_unselected">' .
293	'<td colspan="2" width="100%" align="center" style="background:#EEEEEE"><B>' .
294	$this->functions->getLang('Users from your organization') . '</B> ['.count($tmp_users_from_user_org).']';
295	'</td>' .
296	'</tr>';
297
298	$head_option1 =
299	'<tr class="quicksearchcontacts_unselected">' .
300	'<td colspan="2" width="100%" align="center" style="background:#EEEEEE"><B>' .
301	$this->functions->getLang('Users from others organizations') . '</B> ['.count($tmp).']';
302	'</td>' .
303	'</tr>';
304	}
305	$contacts_result = $head_option0 . $options_users_from_user_org . $head_option1 . $options;
306	}
307	}
308	}
309	ldap_close($this->ds);
310	return $contacts_result;
311	}
312
313	function make_quicksearch_card($info, $cn)
314	{
315	include_once("class.functions.inc.php");
316	$functions = new functions;
317
318	$contacts_result = array();
319	$contacts_result["cn"] = $cn;
320	if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['extended_info'])
321	$extendedinfo=true;
322	else
323	$extendedinfo=false;
324
325	list ($contacts_result["mail"], $contacts_result["phone"], $contacts_result["mobile"], $contacts_result["uid"], $contacts_result["jpegphoto"], $contacts_result["employeenumber"], $contacts_result["ou"]) = split ('%', $info);
326
327	if ($contacts_result['jpegphoto'])
328	$photo_link = '<img src="./inc/show_user_photo.php?mail='.$contacts_result['mail'].'">';
329	else
330	$photo_link = '<img src="./templates/default/images/photo.jpg">';
331
332	$phoneUser = $contacts_result['phone'];
333
334	if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['voip_enabled'] && $phoneUser) {
335	$phoneUser = '<a title="'.$this->functions->getLang("Call to Comercial Number").'" href="#" onclick="InfoContact.connectVoip(\''.$phoneUser.'\',\'com\')">'.$phoneUser.'</a>';
336	if($contacts_result['mobile']){
337	$phoneUser .= ' / <a title="'.$this->functions->getLang("Call to Mobile Number").'" href="#" onclick="InfoContact.connectVoip(\''.$contacts_result['mobile'].'\',\'mob\')">'.$contacts_result['mobile'].'</a>';
338	}
339	}
340	//verifica de existe o celular do funcionario ($contacts_result["mobile"]), se nao, $phoneUser fica vazia;
341
342	$mobileUser = $contacts_result["mobile"];
343	if($mobileUser && !$voipMobile) {
344	$phoneUser .= " / $mobileUser";
345	}
346	$empNumber = $contacts_result["employeenumber"];
347	if($empNumber) {
348	$empNumber = "$empNumber - ";
349	}
350	$ou = $contacts_result["ou"];
351	if($ou) {
352	$ou = "<br/>$ou" ;
353	}
354
355	// Begin: nickname, firstname and lastname for QuickAdd.
356	$fn = $contacts_result["cn"];
357	$array_name = explode(" ", $fn);
358	if(count($array_name) > 1){
359	$fn = $array_name[0];
360	array_shift($array_name);
361	$sn = implode(" ",$array_name);
362	}
363	// End:
364	$option =
365	'<tr class="quicksearchcontacts_unselected">' .
366	'<td class="cc" width="1%">' .
367	'<a title="'.$this->functions->getLang("Write message").'" onClick="javascript:QuickSearchUser.create_new_message(\''.$contacts_result["cn"].'\', \''.$contacts_result["mail"].'\')">' .
368	$photo_link .
369	'</a>' .
370	'</td>' .
371	'<td class="cc">' .
372	'<span name="cn">' . $empNumber . $contacts_result['cn'] . '</span>' . '<br>' .
373	'<a title="'.$functions->getLang("Write message").'" onClick="javascript:QuickSearchUser.create_new_message(\''.$contacts_result["cn"].'\', \''.$contacts_result["mail"].'\')">' .
374	'<font color=blue>' .
375	'<span name="mail">' . $contacts_result['mail'] . '</span></a></font>'.
376	'<img src="templates/default/images/user_card.png" style="cursor: pointer;" title="'.$this->functions->getLang("Add Contact").'" onclick="javascript:connector.loadScript(\'ccQuickAdd\');ccQuickAddOne.showList(\''.$fn.','.$fn.','.$sn.','.$contacts_result["mail"].'\')">'.
377	'<br>' .
378	$phoneUser .
379	$ou .
380	'</td>' .
381	'</tr>';
382	return $option;
383	}
384
385	function get_catalogs(){
386	$catalogs = array();
387	$catalogs[0] = $this->functions->getLang("Global Catalog");
388	if($this->external_srcs)
389	foreach ($this->external_srcs as $key => $valor ){
390	$catalogs[$key] = $valor['name'];
391	}
392	return $catalogs;
393	}
394	function get_organizations($params){
395	$organizations = array();
396	$params['referral']?$referral = $params['referral']:$referral = false;
397	$cat = $params['catalog'];
398
399	$this->ldapConnect($referral,$cat);
400
401	if($this->branch != '') {
402	$filter="(&(".$this->branch."=*)(!(phpgwAccountVisible=-1)))";
403	$justthese = array("$this->branch");
404	$sr = ldap_list($this->ds, $this->ldap_context, $filter, $justthese);
405	$info = ldap_get_entries($this->ds, $sr);
406
407	for ($i=0; $i<$info["count"]; $i++)
408	$organizations[$i] = $info[$i]["ou"][0];
409
410	ldap_close($this->ds);
411	sort($organizations);
412	return $organizations;
413	}else{
414	return null;
415	}
416	}
417	function get_organizations2($params){
418	$organizations = array();
419	$referral = $params['referral'];
420	$this->ldapRootConnect($referral);
421	if ($this->ds) {
422	$filter="(&(ou=*)(!(phpgwAccountVisible=-1)))";
423	$justthese = array("ou");
424	$sr = ldap_list($this->ds, $this->ldap_context, $filter, $justthese);
425	$info = ldap_get_entries($this->ds, $sr);
426
427	for ($i=0; $i<$info["count"]; $i++)
428	{
429	$organizations[$i]['ou'] = $info[$i]["ou"][0];
430	$organizations[$i]['dn'] = $info[$i]["dn"];
431	}
432
433	ldap_close($this->ds);
434	sort($organizations);
435	}
436	return $organizations;
437	}
438	//Busca usuarios de um contexto e ja retorna as options do select - usado por template serpro;
439	function search_users($params)
440	{
441	$this->ldapConnect(false,0);
442	//Monta lista de Grupos e Usuarios
443	$users = Array();
444	$groups = Array();
445	$user_context= $this->ldap_context;
446	$owner = $_SESSION['phpgw_info']['expressomail']['user']['owner'];
447	$filtro =utf8_encode($params['filter']);
448	$context =utf8_encode($params['context']);//adicionado
449
450	if ($this->ds)
451	{
452	$justthese = array("gidNumber","cn");
453	if ($params['type'] == 'search')
454	$sr=ldap_search($this->ds, $context, ("(&(phpgwaccounttype=g)(!(phpgwaccountvisible=-1))(cn=$filtro))"),$justthese);
455	else
456	$sr=ldap_list($this->ds, $context ? $context : $user_context, ("(&(phpgwaccounttype=g)(!(phpgwaccountvisible=-1))(cn=".$filtro."))"),$justthese);
457	$info = ldap_get_entries($this->ds, $sr);
458	for ($i=0; $i<$info["count"]; $i++)
459	$groups[$uids=$info[$i]["gidnumber"][0]] = Array('name' => $uids=$info[$i]["cn"][0], 'type' => g);
460	$justthese = array("phpgwaccountvisible","uidNumber","cn");
461	if ($params['type'] == 'search')
462	// $sr=ldap_search($this->ds, $user_context, ("(&(phpgwaccounttype=u)(!(phpgwaccountvisible=-1))(phpgwaccountstatus=A)(\|(cn=$filtro)(mail=$filtro*)))"),$justthese);
463	$sr=ldap_search($this->ds, $context, ("(&(phpgwaccounttype=u)(!(phpgwaccountvisible=-1))(phpgwaccountstatus=A)(\|(cn=$filtro)(mail=$filtro*)))"),$justthese);
464	else
465	$sr=ldap_list($this->ds, $context ? $context : $user_context, ("(&(phpgwaccounttype=u)(!(phpgwaccountvisible=-1))(phpgwaccountstatus=A)(\|(cn=$filtro)(mail=$filtro*)))"),$justthese);
466
467	$info = ldap_get_entries($this->ds, $sr);
468	for ($i=0; $i<$info["count"]; $i++)
469	{
470	if ($info[$i]["phpgwaccountvisible"][0] == '-1')
471	continue;
472	$users[$uids=$info[$i]["uidnumber"][0]] = Array('name' => $uids=$info[$i]["cn"][0], 'type' => u);
473	}
474	}
475	ldap_close($this->ds);
476
477	@asort($users);
478	@reset($users);
479	@asort($groups);
480	@reset($groups);
481	$user_options ='';
482	$group_options ='';
483
484	foreach($groups as $id => $user_array) {
485	$newId = $id.'U';
486	$group_options .= '<option value="'.$newId.'">'.utf8_decode($user_array['name']).'</option>'."\n";
487	}
488	foreach($users as $id => $user_array) {
489	if($owner != $id){
490	$newId = $id.'U';
491	$user_options .= '<option value="'.$newId.'">'.utf8_decode($user_array['name']).'</option>'."\n";
492	}
493	}
494	return array("users" => $user_options, "groups" => $group_options);
495	}
496
497	function catalogsearch($params)
498	{
499	$cn = $params['search_for'] ? "".utf8_encode($params['search_for'])."" : "*";
500	$max_result = $params['max_result'] ? $params['max_result'] : $this->max_result;
501	$catalog = $params['catalog'];
502	$error = False;
503	if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['extended_info'])
504	$extendedinfo=true;
505	else
506	$extendedinfo=false;
507
508
509	$this->ldapConnect(true,$catalog);
510
511	$params['organization'] == 'all' ? $user_context = $this->ldap_context :$user_context = $this->branch."=".$params['organization'].",".$this->ldap_context;
512
513	if ($this->ds) {
514	if ($catalog == 0){
515	//os atributos "employeeNumber" e "ou" foram adicionado ao vetor de busca;
516	if($extendedinfo)
517	$justthese = array("cn", "mail", "phpgwaccounttype", "phpgwAccountVisible", "employeeNumber", "ou");
518	else
519	$justthese = array("cn", "mail", "phpgwaccounttype", "phpgwAccountVisible");
520
521	$filter="(&(\|(phpgwAccountType=u)(phpgwAccountType=l))(cn=".$cn."))";
522	//$user_context = "ou=".$params['organization'].",".$this->ldap_context;
523	}else {
524	//os atributos "employeeNumber" e "ou" foram adicionado ao vetor de busca;
525	if($extendedinfo)
526	$justthese = array("cn", "mail", "employeeNumber", "ou");
527	else
528	$justthese = array("cn", "mail");
529	$filter="(&(objectClass=".$this->object_class.")(cn=".$cn."))";
530	//$user_context = $this->branch."=".$params['organization'].",".$external_srcs[$catalog]['dn'];
531	}
532
533	$sr=@ldap_search($this->ds, $user_context, $filter, $justthese, 0, $max_result+1);
534	if(!$sr)
535	return null;
536	$count_entries = ldap_count_entries($this->ds,$sr);
537	if ($count_entries > $max_result){
538	$info = null;
539	$error = True;
540	}
541	else
542	$info = ldap_get_entries($this->ds, $sr);
543
544	ldap_close($this->ds);
545
546	$u_tmp = array();
547	$g_tmp = array();
548
549	for ($i=0; $i<$info["count"]; $i++){
550	if((!$catalog==0)\|\|(strtoupper($info[$i]["phpgwaccounttype"][0]) == 'U') && ($info[$i]["phpgwaccountvisible"][0] != '-1'))
551	//aqui eh feita a concatenacao do departamento ao cn;
552	$u_tmp[$info[$i]["mail"][0]] = utf8_decode($info[$i]["cn"][0]). '%' . $info[$i]["ou"][0];
553	if((!$catalog==0)\|\|(strtoupper($info[$i]["phpgwaccounttype"][0]) == 'L') && ($info[$i]["phpgwaccountvisible"][0] != '-1'))
554	$g_tmp[$info[$i]["mail"][0]] = utf8_decode($info[$i]["cn"][0]);
555	}
556
557	natcasesort($u_tmp);
558	natcasesort($g_tmp);
559
560	$i = 0;
561	$users = array();
562
563	foreach ($u_tmp as $mail => $cn){
564
565	$tmp = explode("%", $cn); //explode o cn pelo caracter "%" e joga em $tmp;
566	$name = $tmp[0]; //pega o primeiro item (cn) do vetor resultante do explode acima;
567	$department = $tmp[1]; //pega o segundo item (ou) do vetor resultanto do explode acima;
568	$users[$i++] = array("name" => $name, "email" => $mail, "department" => $department);
569
570	}
571	unset($u_tmp);
572
573	$i = 0;
574	$groups = array();
575
576	foreach ($g_tmp as $mail => $cn){
577	$groups[$i++] = array("name" => $cn, "email" => $mail);
578	}
579	unset($g_tmp);
580
581	return array('users' => $users, 'groups' => $groups, 'error' => $error);
582	}else
583	return null;
584	}
585
586	function get_emails_ldap(){
587
588	$result['mail']= array();
589	$result['mailalter']= array();
590	$user = $_SESSION['phpgw_info']['expressomail']['user']['account_lid'];
591	$this->ldapRootConnect(false);
592	if ($this->ds) {
593	$filter="uid=".$user;
594	$justthese = array("mail","mailAlternateAddress");
595	$sr = ldap_search($this->ds,$this->ldap_context, $filter, $justthese);
596	$ent = ldap_get_entries($this->ds, $sr);
597	ldap_close($this->ds);
598
599	for ($i=0; $i<$ent["count"]; $i++){
600	$result['mail'][] = $ent[$i]["mail"][0];
601	$result['mailalter'][] = $ent[$i]["mailalternateaddress"][0];
602	}
603	}
604	return $result;
605	}
606
607	//Busca usuarios de um contexto e ja retorna as options do select;
608	function get_available_users($params)
609	{
610	$this->ldapRootConnect();
611	//Monta lista de Grupos e Usuarios
612	$users = Array();
613	$groups = Array();
614	$user_context= $params['context'];
615	$owner = $_SESSION['phpgw_info']['expressomail']['user']['owner'];
616
617	if ($this->ds)
618	{
619	$justthese = array("gidNumber","cn");
620	if ($params['type'] == 'search')
621	$sr=ldap_search($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=g)(!(phpgwaccountvisible=-1)))"),$justthese);
622	else
623	$sr=ldap_list($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=g)(!(phpgwaccountvisible=-1)))"),$justthese);
624	$info = ldap_get_entries($this->ds, $sr);
625	for ($i=0; $i<$info["count"]; $i++)
626	$groups[$uids=$info[$i]["gidnumber"][0]] = Array('name' => $uids=$info[$i]["cn"][0], 'type' => g);
627	$justthese = array("phpgwaccountvisible","uidNumber","cn");
628	if ($params['type'] == 'search')
629	$sr=ldap_search($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=u)(!(phpgwaccountvisible=-1)))"),$justthese);
630	else
631	$sr=ldap_list($this->ds, $user_context, ("(&(cn=*)(phpgwaccounttype=u)(!(phpgwaccountvisible=-1)))"),$justthese);
632
633	$info = ldap_get_entries($this->ds, $sr);
634	for ($i=0; $i<$info["count"]; $i++)
635	{
636	if ($info[$i]["phpgwaccountvisible"][0] == '-1')
637	continue;
638	$users[$uids=$info[$i]["uidnumber"][0]] = Array('name' => $uids=$info[$i]["cn"][0], 'type' => u);
639	}
640	}
641	ldap_close($this->ds);
642
643	@asort($users);
644	@reset($users);
645	@asort($groups);
646	@reset($groups);
647	$user_options ='';
648	$group_options ='';
649
650	foreach($groups as $id => $user_array) {
651	$newId = $id.'U';
652	$group_options .= '<option value="'.$newId.'">'.utf8_decode($user_array['name']).'</option>'."\n";
653	}
654	foreach($users as $id => $user_array) {
655	if($owner != $id){
656	$newId = $id.'U';
657	$user_options .= '<option value="'.$newId.'">'.utf8_decode($user_array['name']).'</option>'."\n";
658	}
659	}
660	return array("users" => $user_options, "groups" => $group_options);
661	}
662
663	//Busca usuarios de um contexto e ja retorna as options do select;
664	function get_available_users2($params)
665	{
666	$this->ldapRootConnect();
667
668	$context= $params['context'];
669	$justthese = array("cn", "uid", "cn");
670	$filter = "(&(phpgwaccounttype=u)(!(phpgwaccountvisible=-1)))";
671
672	if ($this->ds)
673	{
674	$sr=ldap_search($this->ds, $context, $filter, $justthese);
675	$entries = ldap_get_entries($this->ds, $sr);
676
677	for ($i=0; $i<$entries["count"]; $i++){
678	if($_SESSION['phpgw_info']['expressomail']['user']['account_lid'] != $entries[$i]["uid"][0]){
679	$u_tmp[$entries[$i]["uid"][0]] = $entries[$i]["cn"][0];
680	}
681	}
682
683	natcasesort($u_tmp);
684
685	$i = 0;
686	$users = array();
687
688	if (count($u_tmp))
689	{
690	foreach ($u_tmp as $uidnumber => $cn)
691	{
692	$options .= "<option value=$uidnumber>$cn</option>";
693	}
694	unset($u_tmp);
695	}
696
697	ldap_close($this->ds);
698	return $options;
699	}
700	}
701
702	function uid2cn($uid)
703	{
704	// do not follow the referral
705	$this->ldapRootConnect(false);
706	if ($this->ds)
707	{
708	$filter="(&(phpgwAccountType=u)(uid=$uid))";
709	$justthese = array("cn");
710	$sr=@ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
711	if(!$sr)
712	return false;
713	$info = ldap_get_entries($this->ds, $sr);
714	return utf8_decode($info[0]["cn"][0]);
715	}
716	return false;
717	}
718	function uidnumber2uid($uidnumber)
719	{
720	// do not follow the referral
721	$this->ldapRootConnect(false);
722	if ($this->ds)
723	{
724	$filter="(&(phpgwAccountType=u)(uidnumber=$uidnumber))";
725	$justthese = array("uid");
726	$sr=@ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
727	if(!$sr)
728	return false;
729	$info = ldap_get_entries($this->ds, $sr);
730	return $info[0]["uid"][0];
731	}
732	return false;
733	}
734	function getSharedUsersFrom($params){
735	$filter = '';
736	$i = 0;
737	//Added to save if must save sent messages in shared folder
738	$acl_save_sent_in_shared = array();
739
740	if($params['uids']) {
741	$uids = explode(";",$params['uids']);
742	$this->imap = new imap_functions();
743	foreach($uids as $index => $uid){
744	$params = array();
745	//Added to save if user has create permission
746	$acl_create_message = array();
747	$acl = $this->imap->getacltouser($uid);
748	if ( preg_match("/a/",$acl )){
749	$filter .= "(uid=$uid)";
750	if ( preg_match("/p/",$acl )){
751	$acl_save_sent_in_shared[ $i ] =$uid;
752	$i++;
753	}
754	}
755	}
756	}
757
758	$this->ldapRootConnect(false);
759	if ($this->ds) {
760	$justthese = array("cn","mail","uid");
761	if($filter) {
762	$filter="(&(\|(phpgwAccountType=u)(phpgwAccountType=s))(\|$filter))";
763	$sr = ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
764	ldap_sort($this->ds,$sr,"cn");
765	$info = ldap_get_entries($this->ds, $sr);
766	$var = print_r($acl_save_sent_in_shared, true);
767	for ($i = 0;$i < $info["count"]; $i++){
768	$info[$i]['cn'][0] = utf8_decode($info[$i]['cn'][0]);
769	//verify if user has permission to save sent messages in a shared folder
770	if ( in_array( $info[$i]['uid'][0],$acl_save_sent_in_shared) ){
771	$info[$i]['save_shared'][0] = 'y';
772	} else $info[$i]['save_shared'][0] = 'n';
773	}
774	}
775
776	$info['myname'] = $_SESSION['phpgw_info']['expressomail']['user']['fullname'];
777
778	//Find institucional_account.
779	$filter="(&(phpgwAccountType=i)(mailForwardingAddress=".$_SESSION['phpgw_info']['expressomail']['user']['email']."))";
780	$sr = ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
781	##
782	# @AUTHOR Rodrigo Souza dos Santos
783	# @DATE 2008/09/17
784	# @BRIEF Changing to ensure that the variable session is always with due value.
785	##
786	if(ldap_count_entries($this->ds,$sr))
787	{
788	ldap_sort($this->ds,$sr,"cn");
789	$result = ldap_get_entries($this->ds, $sr);
790	for ($j = 0;$j < $result["count"]; $j++){
791	$info[$i]['cn'][0] = utf8_decode($result[$j]['cn'][0]);
792	$info[$i]['mail'][0] = $result[$j]['mail'][0];
793	$info[$i]['save_shared'][0] = 'n';
794	$info[$i++]['uid'][0] = $result[$j]['uid'][0];
795	}
796	}
797
798	$_SESSION['phpgw_info']['expressomail']['user']['shared_mailboxes'] = $info;
799
800	return $info;
801	}
802	}
803
804	function getUserByEmail($params)
805	{
806	$expires = 60602430; / 30 days */
807	header("Cache-Control: maxage=".$expires);
808	header("Pragma: public");
809	header("Expires: ".gmdate('D, d M Y H:i:s', time()+$expires));
810	$filter="(&(phpgwAccountType=u)(mail=" . $params['email'] . "))";
811	$ldap_context = $_SESSION['phpgw_info']['expressomail']['ldap_server']['dn'];
812	if($_SESSION['phpgw_info']['user']['preferences']['expressoMail']['extended_info'])
813	$extendedinfo=true;
814	else
815	$extendedinfo=false;
816
817	if($extendedinfo)
818	$justthese = array("cn","uid","telephoneNumber","jpegPhoto","mobile","ou","employeeNumber");
819	else
820	$justthese = array("cn","uid","telephoneNumber","jpegPhoto","mobile");
821
822	// Follow the referral
823	$ds = $this->ldapConnect2(true);
824	if ($ds)
825	{
826	$sr=@ldap_search($ds, $ldap_context, $filter, $justthese);
827
828	if (!$sr)
829	return null;
830
831	$entry = ldap_first_entry($ds, $sr);
832
833	if($entry) {
834	$obj = array("cn" => utf8_decode(current(ldap_get_values($ds, $entry, "cn"))),
835	"email" => $params['email'],
836	"uid" => ldap_get_values($ds, $entry, "uid"),
837	"type" => "global",
838	"mobile" => @ldap_get_values($ds, $entry, "mobile"),
839	"telefone" => @ldap_get_values($ds, $entry, "telephonenumber"),
840	"ou" => @ldap_get_values($ds, $entry, "ou"),
841	"employeeNumber" => @ldap_get_values($ds, $entry, "employeeNumber")
842	);
843
844	$_SESSION['phpgw_info']['expressomail']['contact_photo'] = @ldap_get_values_len($ds, $entry, "jpegphoto");
845	ldap_close($ds);
846	return $obj;
847	}
848	}
849	return null;
850	}
851
852	function uid2uidnumber($uid)
853	{
854	// do not follow the referral
855	$this->ldapRootConnect(false);
856	if ($this->ds)
857	{
858	$filter="(&(phpgwAccountType=u)(uid=$uid))";
859	$justthese = array("uidnumber");
860	$sr=@ldap_search($this->ds, $this->ldap_context, $filter, $justthese);
861	if(!$sr)
862	return false;
863	$info = ldap_get_entries($this->ds, $sr);
864	return $info[0]["uidnumber"][0];
865	}
866	return false;
867	}
868	}
869	?>

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

Download in other formats: