Context Navigation

class.bo_global_ldap_catalog.inc.php @ 4326

Revision 4326, 38.5 KB checked in by rafaelraymundo, 13 years ago (diff)
Ticket #1726 - Modificado implementação que lista Referrals, sem ldap_next_reference(). r4313
Property svn:eol-style set to `native` Property svn:executable set to ``*

Line
1	<?php
2	/***************************************************************************\
3	* eGroupWare - Contacts Center *
4	* http://www.egroupware.org *
5	* Written by: *
6	* - Raphael Derosso Pereira <raphaelpereira@users.sourceforge.net> *
7	* ------------------------------------------------------------------------- *
8	* This program is free software; you can redistribute it and/or modify it *
9	* under the terms of the GNU General Public License as published by the *
10	* Free Software Foundation; either version 2 of the License, or (at your *
11	* option) any later version. *
12	\***************************************************************************/
13
14	/*
15	This class is responsible for manipulating the Global LDAP Contact Manager
16	*/
17	include_once('class.abo_catalog.inc.php');
18
19	class bo_global_ldap_catalog extends abo_catalog
20	{
21	var $ldap;
22
23	var $src_info;
24
25	var $trans_table;
26	// used to determine if a catalog is external
27	var $external;
28	var $fields = array(
29	'id_contact' => true,
30	'status' => true,
31	'photo' => true,
32	'alias' => true,
33	'prefix' => true,
34	'given_names' => true,
35	'family_names' => true,
36	'account_type' => true,
37	'names_ordered' => true,
38	'suffix' => true,
39	'birthdate' => true,
40	'sex' => true,
41	'pgp_key' => true,
42	'notes' => true,
43	'companies' => true,
44	'relations' => true,
45	'addresses' => true,
46	'connections' => true
47	);
48
49	/*
50
51	@function global_ldap_catalog
52	@abstract Constructor
53	@author Raphael Derosso Pereira
54	@author Mário César Kolling (external catalogs)
55
56	@param integer $id_source The ID of the LDAP source
57	@param string $context Ldap bind DN
58	@param integer $external 0 = internal catalog, 1 = external catalog
59	*/
60	function bo_global_ldap_catalog ( $id_source, $context, $external = 0 )
61	{
62	$this->external = $external;
63	if (!function_exists('ldap_search'))
64	{
65	exit('PHP LDAP support Unavailable!');
66	}
67
68	$this->ldap = CreateObject('contactcenter.bo_ldap_manager');
69
70	if ($this->external)
71	{
72	$all_src = $this->ldap->get_external_ldap_sources();
73	}
74	else
75	{
76	$all_src = $this->ldap->get_all_ldap_sources();
77	}
78
79	if (!$all_src[$id_source] or !$context)
80	{
81	exit('Unavailable LDAP source.');
82	}
83
84	$this->src_info = $all_src[$id_source];
85	$this->src_info['context'] = $context;
86
87	if ($this->external)
88	{
89	$this->trans_table = $this->ldap->get_external_ldap_fields_association($id_source);
90	}
91	else
92	{
93	$this->trans_table = $this->ldap->get_ldap_fields_association($id_source);
94	}
95	}
96
97	/*
98
99	@function find
100	@abstract Searches the LDAP directory for the specified fields with
101	the specified rules and retuns an array containing all the DNs
102	that matches the rules.
103	@author Raphael Derosso Pereira
104
105	@param array $what The fields to be taken
106	@param array $rules The rules to be match. See class.abo_catalog.inc.php
107	for reference
108	@param array $other Other parameters:
109	$return = array(
110	'limit' => (integer),
111	'offset' => (integer) [NOT IMPLEMENTED]
112	)
113
114	*/
115	function find($what, $rules=false, $other=false, $area=false, $recursive=false)
116	{
117	$restric_fields = $this->get_restrictions_without_branch($rules);
118
119	$trans_f = $this->translate_fields($what, $restric_fields);
120
121	foreach($trans_f as $orig => $field_a)
122	{
123	foreach($field_a as $field)
124	{
125	$fields[] = $field;
126	}
127	}
128
129	$fields = array_unique($fields);
130
131	//Testa se a busca foi realizada com aspas
132	$rules_search = $rules[3]['value'];
133	$rules_len = (strlen($rules_search)) -1;
134
135	if((($rules_search{1}) == "\"") && (($rules_search{$rules_len -1}) == "\"")){
136	$rules_search = substr($rules_search,2,$rules_len-3);
137	$filter = "(&(\|(objectClass=phpgwAccount))(&(!(phpgwAccountVisible=-1)))(\|(cn=* $rules_search )(cn=$rules_search )(cn=* $rules_search)))";
138	}
139	else{
140	$filter = $this->process_restrictions($rules, $trans_f);
141	}
142
143	if ($area)
144	{
145	$obj = CreateObject('phpgwapi.config','contactcenter');
146	$opts = $obj->read_repository();
147	$filter = substr($filter,0,-1) .'(' . $opts['cc_ldap_atrib'] . '=' . $area . '))';
148	$opts = null;
149	$obj = null;
150	}
151	// Find objects where 'mail' attribute is not null.
152	$filter = "(&".$filter."(mail=*))";
153
154	$ldap = $GLOBALS['phpgw']->common->ldapConnect($this->src_info['host'], $this->src_info['acc'], $this->src_info['pw'], true);
155	$result_r = $recursive ? ldap_search($ldap , $this->src_info['context'], $filter, $fields, 0, $this->src_info['max_results']) :
156	ldap_list($ldap , $this->src_info['context'], $filter, $fields, 0, $this->src_info['max_results']);
157
158	if (!$result_r)
159	{
160	return false;
161	}
162
163	if ($other['order'])
164	{
165	$sort_f = array($other['order']);
166	$ldap_sort_by = $this->translate_fields($sort_f, $restric_fields);
167	}
168
169	if ($ldap_sort_by)
170	{
171	if (!ldap_sort($ldap, $result_r, $ldap_sort_by[$other['order']][0]))
172	{
173	return false;
174	}
175	}
176
177	$result_u = ldap_get_entries($ldap, $result_r);
178	// No entries found.
179	if(!$result_u)
180	return true;
181
182	$i = 0;
183	foreach ($result_u as $index => $result_p)
184	{
185	if ($index === 'count' or $index === 'dn' or (!$this->external and $result_p['phpgwaccountvisible'][0] == '-1'))
186	{
187	continue;
188	}
189
190	foreach ($trans_f as $orig => $trans)
191	{
192	$orig = substr($orig, strrpos($orig, '.')+1, strlen($orig));
193	foreach ($trans as $f)
194	{
195	if ($f === 'dn')
196	{
197	$return[$i][$orig] = $result_p['dn'];
198	}
199	else if ($result_p[$f][0])
200	{
201	$return[$i][$orig] = $result_p[$f][0];
202	}
203	}
204	}
205	$i++;
206	}
207	if($return)
208	usort($return, array($this, "compareObjects"));
209	return $return;
210	}
211	// Compare function for usort.
212	function compareObjects($a, $b) {
213	return strnatcasecmp($a['names_ordered'], $b['names_ordered']);
214	}
215
216	/*
217
218	@function translate_fields
219	@abstract Return the LDAP objectClass fields that corresponds to the
220	specified parameter fields
221	@author Raphael Derosso Pereira
222
223	@param array $fields The fields in the standard ContactCenter format
224	@param array $rules The rules
225
226	*/
227	function translate_fields ( $fields, &$restric_fields )
228	{
229	$return = array();
230
231	$i = 0;
232	foreach ($fields as $field)
233	{
234	if (!array_key_exists($field,$this->trans_table) or !$this->trans_table[$field])
235	{
236	continue;
237	}
238
239	if (!is_array($this->trans_table[$field]))
240	{
241	$reference = $this->trans_table[$field];
242
243	reset($restric_fields);
244	while(list(,$field_r) = each($restric_fields))
245	{
246	if ($field_r['field'] === $reference and array_key_exists($field_r['value'], $this->trans_table[$reference]))
247	{
248	array_push($return[$field], $this->trans_table[$reference][$field_r['value']]);
249	}
250	}
251	}
252	else
253	{
254	if (!is_array($return[$field]))
255	{
256	$return[$field] = $this->trans_table[$field];
257	}
258	else
259	{
260	array_push($return[$field], $this->trans_table[$field]);
261	}
262	}
263	}
264
265	if (count($return))
266	{
267	return $return;
268	}
269
270	return false;
271	}
272
273	/*
274
275	@function process_restrictions
276	@abstract Returns a LDAP filter string that corresponds to the
277	specified restriction rules
278	@author Raphael Derosso Pereira
279
280	@param string $rules The restriction rules
281
282	*/
283	function process_restrictions( $rules, &$trans_table, $join_type='&' )
284	{
285	if (!is_array($rules) or !count($rules))
286	{
287	return null;
288	}
289
290	foreach($rules as $rule_i => $rule)
291	{
292	$t = array();
293	switch($rule['type'])
294	{
295	case 'branch':
296	switch(strtoupper($rule['value']))
297	{
298	case 'OR':
299	$join = '\|';
300	break;
301
302	case 'AND':
303	$join = '&';
304	break;
305
306	case 'NOT':
307	$join = '!';
308	break;
309
310	default:
311	$join = $join_type;
312	}
313	$return_t[] = $this->process_restrictions($rule['sub_branch'], $trans_table, $join);
314	break;
315
316	case '=':
317	if (array_key_exists($rule['field'], $trans_table))
318	{
319	foreach($trans_table[$rule['field']] as $field)
320	{
321	$t[] = '('.$field.'='.$rule['value'].')';
322	}
323	$return_t[] = '(\|'.implode(' ',$t).')';
324	}
325	break;
326
327	case '!=':
328	if (array_key_exists($rule['field'], $trans_table))
329	{
330	foreach($trans_table[$rule['field']] as $field)
331	{
332	$t[] = '(!('.$field.'='.$rule['value'].'))';
333	}
334	$return_t[] = '(&'.implode(' ',$t).')';
335	}
336	break;
337
338	case '<=':
339	case '<':
340	if (array_key_exists($rule['field'], $trans_table))
341	{
342	foreach($trans_table[$rule['field']] as $field)
343	{
344	$t[] = '('.$field.'<='.$rule['value'].')';
345	}
346	$return_t[] = '(\|'.implode(' ',$t).')';
347	}
348	break;
349
350	case '>':
351	case '>=':
352	if (array_key_exists($rule['field'], $trans_table))
353	{
354	foreach($trans_table[$rule['field']] as $field)
355	{
356	$t[] = '('.$field.'>='.$rule['value'].')';
357	}
358	$return_t[] = '(\|'.implode(' ',$t).')';
359	}
360	break;
361
362	case 'NULL':
363	if (array_key_exists($rule['field'], $trans_table))
364	{
365	foreach($trans_table[$rule['field']] as $field)
366	{
367	$t[] = '(!('.$field.'=*'.'))';
368	}
369	$return_t[] = '(&'.implode(' ',$t).')';
370	}
371	break;
372
373	case 'IN':
374	if (array_key_exists($rule['field'], $trans_table))
375	{
376	foreach($trans_table[$rule['field']] as $field)
377	{
378	foreach($rule['value'] as $value)
379	{
380	$t[] = '('.$field.'='.$value.')';
381	}
382	}
383	$return_t[] = '(\|'.implode(' ',$t).')';
384	}
385	break;
386
387	case 'iLIKE':
388	/* if (array_key_exists($rule['field'], $trans_table))
389	{
390	$value_1 = strtoupper(str_replace('%', '*', $rule['value']));
391	$value_2 = strtolower($value_1);
392
393	foreach($trans_table[$rule['field']] as $field)
394	{
395	$t[] = '('.$field.'='.$value_1.')';
396	$t[] = '('.$field.'='.$value_2.')';
397	}
398	$return_t[] = '(\|'.implode(' ',$t).')';
399	}
400	break;
401
402	*/ case 'LIKE':
403	if (array_key_exists($rule['field'], $trans_table))
404	{
405	$value = str_replace('%', '*', $rule['value']);
406
407	foreach($trans_table[$rule['field']] as $field)
408	{
409	$t[] = '('.$field.'='.$value.')';
410	}
411	$return_t[] = '(\|'.implode(' ',$t).')';
412	}
413	break;
414
415	case 'NOT NULL':
416	if (array_key_exists($rule['field'], $trans_table))
417	{
418	foreach($trans_table[$rule['field']] as $field)
419	{
420	$t[] = '('.$field.'=*'.')';
421	}
422	$return_t[] = '(\|'.implode(' ',$t).')';
423	}
424	break;
425
426	case 'NOT IN':
427	if (array_key_exists($rule['field'], $trans_table))
428	{
429	foreach($trans_table[$rule['field']] as $field)
430	{
431	foreach($rule['value'] as $value)
432	{
433	$t[] = '('.$field.'='.$value.')';
434	}
435	}
436	$return_t[] = '(!(\|'.implode('',$t).'))';
437	}
438	break;
439
440	case 'NOT iLIKE':
441	if (array_key_exists($rule['field'], $trans_table))
442	{
443	$value_1 = strtoupper(str_replace('%', '*', $rule['value']));
444	$value_2 = strtolower($value_1);
445
446	foreach($trans_table[$rule['field']] as $field)
447	{
448	$t[] = '('.$field.'='.$value_1.')';
449	$t[] = '('.$field.'='.$value_2.')';
450	}
451	$return_t[] = '(!(\|'.implode(' ',$t).'))';
452	}
453	break;
454
455	case 'NOT LIKE':
456	if (array_key_exists($rule['field'], $trans_table))
457	{
458	$value = str_replace('%', '*', $rule['value']);
459
460	foreach($trans_table[$rule['field']] as $field)
461	{
462	$t[] = '('.$field.'='.$value.')';
463	}
464	$return_t[] = '(!(\|'.implode(' ',$t).'))';
465	}
466	break;
467	}
468	}
469
470	if (count($return_t))
471	{
472	$return = '('.$join_type;
473	foreach ($return_t as $return_p)
474	{
475	$return .= $return_p;
476	}
477	$return .= ')';
478	}
479	else
480	{
481	$return = null;
482	}
483	return $return;
484	}
485
486	/*!
487
488	@function get_restrictions_without_branch
489	@abstract Returns an array containing the restrictions ignoring the
490	branches
491	@author Raphael Derosso Pereira
492
493	@param array $restrictions The restrictions
494
495	*/
496	function get_restrictions_without_branch(&$restrictions)
497	{
498	if (!is_array($restrictions))
499	{
500	return null;
501	}
502
503	$fields = array();
504
505	foreach ($restrictions as $restrict_data)
506	{
507	switch($restrict_data['type'])
508	{
509	case 'branch':
510	$fields = array_merge($fields, $this->get_restrictions_without_branch($restrict_data['sub_branch']));
511	break;
512
513	case '=':
514	case '!=':
515	case '<=':
516	case '<':
517	case '>':
518	case '>=':
519	case 'NULL':
520	case 'IN':
521	case 'LIKE':
522	case 'iLIKE':
523	case 'NOT NULL':
524	case 'NOT IN':
525	case 'NOT LIKE':
526	case 'NOT iLIKE':
527	array_push($fields, $restrict_data);
528	break;
529
530	default:
531	exit('Error in '.__FILE__.' on '.__LINE__.'<br>The restriction type passed was: '.$restrict_data['type']);
532	}
533	}
534
535	return $fields;
536	}
537
538
539	/*********************************************************************\
540	* Methods to Get Data *
541	\*********************************************************************/
542
543
544	/*!
545
546	@function get_single_entry
547	@abstract Returns all information requested about one contact
548	@author Raphael Derosso Pereira
549
550	@param integer $id_contact The contact ID
551	@param array $fields The array returned by get_fields with true
552	on the fields to be taken.
553
554	*/
555	function get_single_entry ( $id_contact, $fields, $external=false )
556	{
557	if (!is_array($fields))
558	{
559	if (is_object($GLOBALS['phpgw']->log))
560	{
561	$GLOBALS['phpgw']->log->message(array(
562	'text' => 'F-BadcontactcenterParam, wrong get_single_entry parameters type.',
563	'line' => __LINE__,
564	'file' => __FILE__));
565
566	$GLOBALS['phpgw']->log->commit();
567	}
568	else
569	{
570	exit('Argument Error on: <br>File:'.__FILE__.'<br>Line:'.__LINE__.'<br>');
571	}
572	}
573
574	$ldap = $GLOBALS['phpgw']->common->ldapConnect($this->src_info['host'],$this->src_info['acc'],$this->src_info['pw'],true);
575
576	if (!$ldap)
577	{
578	return false;
579	}
580
581	//Alteração feita especificamente para tratar problema da montagem do $id_contact
582	if(!$external)
583	{
584	if($this->src_info['montaDN'] == "true")
585	{
586	$id_contact = preg_replace("/dc=(.*)/i",$this->src_info['dn'],$id_contact);
587	}
588	}
589
590	$resource = @ldap_read($ldap, $id_contact, 'objectClass='.$this->src_info['obj']);
591	$n_entries = @ldap_count_entries($ldap, $resource);
592	if ( $n_entries > 1 or $n_entries < 1)
593	{
594	return false;
595	}
596
597	$first_entry = ldap_first_entry($ldap, $resource);
598	$contact = ldap_get_attributes($ldap,$first_entry);
599	if($contact['jpegPhoto']){
600	$contact['jpegPhoto'] = ldap_get_values_len ($ldap, $first_entry, "jpegPhoto");
601	}
602
603	// print_r($contact);
604
605	// $contact_data = $this->fields;
606
607	foreach($fields as $field => $trueness)
608	{
609	if (!$trueness)
610	{
611	//unset($contact_data[$field]);
612	continue;
613	}
614
615	switch ($field)
616	{
617	case 'companies':
618	unset($l_fields);
619	$l_fields['company_name'] = $this->trans_table['contact.company.company_name'];
620	$l_fields['title'] = $this->trans_table['contact.business_info.title'];
621	//$l_fields['department'] = $this->trans_table['contact.business_info.department'];
622	$l_fields['company_notes'] = $this->trans_table['contact.company.company_notes'];
623
624	//Relaciona o array com o atributo 'ou' do RHDS; tambem verifica se a
625	//preferencia esta configurada para exibir o campo
626	if(isset($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['departmentShow']) && $_SESSION['phpgw_info']['user']['preferences']['contactcenter']['departmentShow'])
627	{
628	$l_fields['department'] = $this->trans_table['contact.business_info.department'];
629	}
630	//Relaciona o array com o atributo 'employeeNumber' do RHDS; tambem verifica se a
631	//preferencia esta configurada para exibir o campo
632	if(isset($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['empNumShow']) && $_SESSION['phpgw_info']['user']['preferences']['contactcenter']['empNumShow'])
633	{
634	$l_fields['empNumber'] = $this->trans_table['contact.business_info.empNumber'];
635	}
636	//Relaciona o array com o atributo 'mobile' do RHDS; tambem verifica se a
637	//preferencia esta configurada para exibir o campo
638	if(isset($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['cellShow']) && $_SESSION['phpgw_info']['user']['preferences']['contactcenter']['cellShow'])
639	{
640	$l_fields['celPhone'] = $this->trans_table['contact.business_info.celPhone'];
641	}
642
643	$contact_data['companies'] = array();
644	foreach($l_fields as $l_field => $l_value)
645	{
646	if (!( $contact[$l_value[0]][0]))
647	{
648	continue;
649	}
650
651	$contact_data['companies']['company1'][$l_field] = utf8_decode($contact[$l_value[0]][0]);
652	}
653
654	if (!(count($contact_data['companies'])))
655	{
656	unset($contact_data['companies']);
657	}
658	break;
659
660	case 'relations':
661	unset($l_fields);
662	if (!$this->trans_table['contact.contact_related.names_ordered'])
663	{
664	unset($contact_data['relations']);
665	}
666
667	$contact_data['relations'] = array();
668	if (!is_array($this->trans_table['contact.contact_related.names_ordered']))
669	{
670	if (!($trans = $this->trans_table[$this->trans_table['contact.contact_related.names_ordered']]))
671	{
672	continue;
673	}
674
675	$i = 1;
676	foreach($trans as $l_type => $l_type_fields)
677	{
678	if (!($contact[$l_type_fields[0]][0]))
679	{
680	continue;
681	}
682
683	$contact_data['relations']['relation'.$i]['type'] = $l_type;
684	$contact_data['relations']['relation'.$i]['names_ordered'] = utf8_decode($contact[$l_type_fields[0]][0]);
685	$i++;
686	}
687	}
688
689	if (!(count($contact_data['relations'])))
690	{
691	unset($contact_data['relations']);
692	}
693	break;
694
695	case 'addresses':
696	unset($l_fields);
697	$l_fields['address1'] = $this->trans_table['contact.address.address1'];
698	$l_fields['address2'] = $this->trans_table['contact.address.address2'];
699	$l_fields['complement'] = $this->trans_table['contact.address.complement'];
700	$l_fields['address_other'] = $this->trans_table['contact.address.address_other'];
701	$l_fields['postal_code'] = $this->trans_table['contact.address.postal_code'];
702	$l_fields['po_box'] = $this->trans_table['contact.address.po_box'];
703	$l_fields['id_city'] = $this->trans_table['contact.address.city.id_city'];
704	$l_fields['city_name'] = $this->trans_table['contact.address.city.city_name'];
705	$l_fields['city_timezone'] = $this->trans_table['contact.address.city.city_timezone'];
706	$l_fields['city_geo_location'] = $this->trans_table['contact.address.city.city_geo_location'];
707	$l_fields['id_state'] = $this->trans_table['contact.address.city.state.id_state'];
708	$l_fields['state_name'] = $this->trans_table['contact.address.city.state.state_name'];
709	$l_fields['state_symbol'] = $this->trans_table['contact.address.city.state.state_symbol'];
710	$l_fields['id_country'] = $this->trans_table['contact.address.city.country.id_country'];
711	$l_fields['country_name'] = $this->trans_table['contact.address.city.country.country_name'];
712	$l_fields['address_is_default'] = $this->trans_table['contact.address.address_is_default'];
713
714	$contact_data['addresses'] = array();
715	foreach($l_fields as $l_field => $l_value)
716	{
717	if (!is_array($l_value))
718	{
719	if (!($trans = $this->trans_table[$l_value]))
720	{
721	continue;
722	}
723
724	$i = 1;
725	foreach($trans as $l_type => $l_type_fields)
726	{
727	if (!($contact[$l_type_fields[0]][0]))
728	{
729	continue;
730	}
731
732	$contact_data['addresses']['address'.$i]['type'] = $l_type;
733	$contact_data['addresses']['address'.$i][$l_field] = utf8_decode($contact[$l_type_fields[0]][0]);
734	$i++;
735	}
736	}
737	else
738	{
739	$contact_data['addresses']['address1'][$l_field] = utf8_decode($contact[$l_value[0]][0]);
740	}
741	}
742
743	if (!(count($contact_data['addresses'])))
744	{
745	unset($contact_data['addresses']);
746	}
747	break;
748
749	case 'connections':
750	$preferences = ExecMethod('contactcenter.ui_preferences.get_preferences');
751	if (!is_array($preferences))
752	{
753	$preferences['personCardEmail'] = 1;
754	$preferences['personCardPhone'] = 2;
755	}
756	unset($l_fields);
757	$l_fields['connection_name'] = $this->trans_table['contact.connection.connection_name'];
758	$l_fields['connection_value'] = $this->trans_table['contact.connection.connection_value'];
759
760	$contact_data['connections'] = array();
761	foreach($l_fields as $l_field => $l_value)
762	{
763	if (!is_array($l_value))
764	{
765	if (!($trans = $this->trans_table[$l_value]))
766	{
767	continue;
768	}
769
770	$i = 1;
771	foreach($trans as $l_type => $l_type_fields)
772	{
773	if (!($contact[$l_type_fields[0]][0]))
774	{
775	continue;
776	}
777
778	switch ($l_type)
779	{
780	case 'email':
781	$contact_data['connections']['connection'.$i]['id_type'] = $preferences['personCardEmail'];
782	break;
783
784	default:
785	$contact_data['connections']['connection'.$i]['id_type'] = $preferences['personCardPhone'];
786	}
787	$contact_data['connections']['connection'.$i]['type'] = $l_type;
788	$contact_data['connections']['connection'.$i][$l_field] = utf8_decode($contact[$l_type_fields[0]][0]);
789	$i++;
790	}
791	}
792	else
793	{
794	$contact_data['connections']['connection1'][$l_field] = utf8_decode($contact[$l_value[0]][0]);
795	}
796	}
797
798	if (!(count($contact_data['connections'])))
799	{
800	unset($contact_data['connections']);
801	}
802	break;
803
804	case 'prefix':
805	unset($l_fields);
806	$l_fields = $this->trans_table['contact.prefixes.prefix'];
807	if (!$l_fields or !$contact[$l_fields[0]][0])
808	{
809	unset($contact_data['prefix']);
810	continue;
811	}
812
813	$contact_data['prefix'] = utf8_decode($contact[$l_fields[0]][0]);
814	break;
815
816	case 'suffix':
817	unset($l_fields);
818	$l_fields = $this->trans_table['contact.suffixes.suffix'];
819	if (!$l_fields or !$contact[$l_fields[0]][0])
820	{
821	unset($contact_data['suffix']);
822	continue;
823	}
824
825	$contact_data['suffix'] = utf8_decode($contact[$l_fields[0]][0]);
826	break;
827
828	case 'status':
829	unset($l_fields);
830	$l_fields = $this->trans_table['contact.status.status_name'];
831	if (!$l_fields or !$contact[$l_fields[0]][0])
832	{
833	unset($contact_data['status']);
834	continue;
835	}
836
837	$contact_data['status'] = utf8_decode($contact[$l_fields[0]][0]);
838	break;
839
840	case 'photo':
841	unset($l_fields);
842	$l_fields = $this->trans_table['contact.photo'];
843	if (!$l_fields or !$contact[$l_fields[0]][0])
844	{
845	unset($contact_data['photo']);
846	continue;
847	}
848
849	$contact_data['photo'] = $contact[$l_fields[0]][0];
850	break;
851
852	default:
853	unset($l_fields);
854	$l_fields = $this->trans_table['contact.'.$field];
855	if (!$l_fields or !$contact[$l_fields[0]][0])
856	{
857	unset($contact_data[$field]);
858	continue;
859	}
860
861	if(count($contact[$l_fields[0]]) > 1)
862	{
863	$tmp = array();
864	foreach ($contact[$l_fields[0]] as $i => $j)
865	{
866	$tmp["$i"] = utf8_decode($j);
867	}
868	//$contact_data[$field] = $contact[$l_fields[0]];
869	$contact_data[$field] = $tmp;
870	}
871	else
872	$contact_data[$field] = utf8_decode($contact[$l_fields[0]][0]);
873
874	break;
875	}
876	}
877
878	if (!is_array($contact_data))
879	{
880	return false;
881	}
882
883	return $contact_data;
884	}
885	//SERPRO
886	/*!
887
888	@function get_all_entries
889	@abstract Returns all information requested about a bunch of contacts, usually a page
890	@author Raphael Derosso Pereira
891	@author Mário César Kolling
892
893	@param string $filter Filter (returned by generate_filter).
894	@param array $fields The array returned by get_fields with true
895	on the fields to be taken.
896
897	*/
898	function get_all_entries($filter, $fields)
899	{
900	if (!is_array($fields))
901	{
902	if (is_object($GLOBALS['phpgw']->log))
903	{
904	$GLOBALS['phpgw']->log->message(array(
905	'text' => 'F-BadcontactcenterParam, wrong get_single_entry parameters type.',
906	'line' => __LINE__,
907	'file' => __FILE__));
908
909	$GLOBALS['phpgw']->log->commit();
910	}
911	else
912	{
913	exit('Argument Error on: <br>File:'.__FILE__.'<br>Line:'.__LINE__.'<br>');
914	}
915	}
916
917	$ldap = $GLOBALS['phpgw']->common->ldapConnect($this->src_info['host'],$this->src_info['acc'],$this->src_info['pw'],true);
918
919	if (!$ldap)
920	{
921	return false;
922	}
923
924	$resource = @ldap_search($ldap, $this->src_info['dn'], $filter);
925	$n_entries = @ldap_count_entries($ldap, $resource);
926
927	ldap_sort($ldap, $resource, 'cn');
928
929	if ( $n_entries < 1)
930	{
931	return false;
932	}
933
934	$contacts = array();
935
936	for ($entry = ldap_first_entry($ldap, $resource);
937	$entry != false;
938	$entry = ldap_next_entry($ldap, $entry))
939	{
940	$contact = ldap_get_attributes($ldap,$entry);
941	if($contact['jpegPhoto']){
942	$contact['jpegPhoto'] = ldap_get_values_len ($ldap, $entry, "jpegPhoto");
943	}
944
945	foreach($fields as $field => $trueness)
946	{
947	if (!$trueness)
948	{
949	//unset($contact_data[$field]);
950	continue;
951	}
952
953	switch ($field)
954	{
955	case 'companies':
956	unset($l_fields);
957	$l_fields['company_name'] = $this->trans_table['contact.company.company_name'];
958	$l_fields['title'] = $this->trans_table['contact.business_info.title'];
959	$l_fields['department'] = $this->trans_table['contact.business_info.department'];
960	$l_fields['company_notes'] = $this->trans_table['contact.company.company_notes'];
961
962	//Relaciona o array com o atributo 'employeeNumber' do RHDS
963	if(isset($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['empNumberShow']) && $_SESSION['phpgw_info']['user']['preferences']['contactcenter']['empNumberShow'])
964	{
965	$l_fields['empNumber'] = $this->trans_table['contact.business_info.empNumber'];
966	}
967
968	//Relaciona o array com o atributo 'mobile' do RHDS
969	$l_fields['celPhone'] = $this->trans_table['contact.business_info.celPhone'];
970
971	$contact_data['companies'] = array();
972	foreach($l_fields as $l_field => $l_value)
973	{
974	if (!( $contact[$l_value[0]][0]))
975	{
976	continue;
977	}
978
979	$contact_data['companies']['company1'][$l_field] = utf8_decode($contact[$l_value[0]][0]);
980	}
981
982	if (!(count($contact_data['companies'])))
983	{
984	unset($contact_data['companies']);
985	}
986	break;
987
988	case 'relations':
989	unset($l_fields);
990	if (!$this->trans_table['contact.contact_related.names_ordered'])
991	{
992	unset($contact_data['relations']);
993	}
994
995	$contact_data['relations'] = array();
996	if (!is_array($this->trans_table['contact.contact_related.names_ordered']))
997	{
998	if (!($trans = $this->trans_table[$this->trans_table['contact.contact_related.names_ordered']]))
999	{
1000	continue;
1001	}
1002
1003	$i = 1;
1004	foreach($trans as $l_type => $l_type_fields)
1005	{
1006	if (!($contact[$l_type_fields[0]][0]))
1007	{
1008	continue;
1009	}
1010
1011	$contact_data['relations']['relation'.$i]['type'] = $l_type;
1012	$contact_data['relations']['relation'.$i]['names_ordered'] = utf8_decode($contact[$l_type_fields[0]][0]);
1013	$i++;
1014	}
1015	}
1016
1017	if (!(count($contact_data['relations'])))
1018	{
1019	unset($contact_data['relations']);
1020	}
1021	break;
1022
1023	case 'addresses':
1024	unset($l_fields);
1025	$l_fields['address1'] = $this->trans_table['contact.address.address1'];
1026	$l_fields['address2'] = $this->trans_table['contact.address.address2'];
1027	$l_fields['complement'] = $this->trans_table['contact.address.complement'];
1028	$l_fields['address_other'] = $this->trans_table['contact.address.address_other'];
1029	$l_fields['postal_code'] = $this->trans_table['contact.address.postal_code'];
1030	$l_fields['po_box'] = $this->trans_table['contact.address.po_box'];
1031	$l_fields['id_city'] = $this->trans_table['contact.address.city.id_city'];
1032	$l_fields['city_name'] = $this->trans_table['contact.address.city.city_name'];
1033	$l_fields['city_timezone'] = $this->trans_table['contact.address.city.city_timezone'];
1034	$l_fields['city_geo_location'] = $this->trans_table['contact.address.city.city_geo_location'];
1035	$l_fields['id_state'] = $this->trans_table['contact.address.city.state.id_state'];
1036	$l_fields['state_name'] = $this->trans_table['contact.address.city.state.state_name'];
1037	$l_fields['state_symbol'] = $this->trans_table['contact.address.city.state.state_symbol'];
1038	$l_fields['id_country'] = $this->trans_table['contact.address.city.country.id_country'];
1039	$l_fields['country_name'] = $this->trans_table['contact.address.city.country.country_name'];
1040	$l_fields['address_is_default'] = $this->trans_table['contact.address.address_is_default'];
1041
1042	$contact_data['addresses'] = array();
1043	foreach($l_fields as $l_field => $l_value)
1044	{
1045	if (!is_array($l_value))
1046	{
1047	if (!($trans = $this->trans_table[$l_value]))
1048	{
1049	continue;
1050	}
1051
1052	$i = 1;
1053	foreach($trans as $l_type => $l_type_fields)
1054	{
1055	if (!($contact[$l_type_fields[0]][0]))
1056	{
1057	continue;
1058	}
1059
1060	$contact_data['addresses']['address'.$i]['type'] = $l_type;
1061	$contact_data['addresses']['address'.$i][$l_field] = utf8_decode($contact[$l_type_fields[0]][0]);
1062	$i++;
1063	}
1064	}
1065	else
1066	{
1067	$contact_data['addresses']['address1'][$l_field] = utf8_decode($contact[$l_value[0]][0]);
1068	}
1069	}
1070
1071	if (!(count($contact_data['addresses'])))
1072	{
1073	unset($contact_data['addresses']);
1074	}
1075	break;
1076
1077	case 'connections':
1078	$preferences = ExecMethod('contactcenter.ui_preferences.get_preferences');
1079	if (!is_array($preferences))
1080	{
1081	$preferences['personCardEmail'] = 1;
1082	$preferences['personCardPhone'] = 2;
1083	}
1084	unset($l_fields);
1085	$l_fields['connection_name'] = $this->trans_table['contact.connection.connection_name'];
1086	$l_fields['connection_value'] = $this->trans_table['contact.connection.connection_value'];
1087
1088	$contact_data['connections'] = array();
1089	foreach($l_fields as $l_field => $l_value)
1090	{
1091	if (!is_array($l_value))
1092	{
1093	if (!($trans = $this->trans_table[$l_value]))
1094	{
1095	continue;
1096	}
1097
1098	$i = 1;
1099	foreach($trans as $l_type => $l_type_fields)
1100	{
1101	if (!($contact[$l_type_fields[0]][0]))
1102	{
1103	continue;
1104	}
1105
1106	switch ($l_type)
1107	{
1108	case 'email':
1109	$contact_data['connections']['connection'.$i]['id_type'] = $preferences['personCardEmail'];
1110	break;
1111
1112	default:
1113	$contact_data['connections']['connection'.$i]['id_type'] = $preferences['personCardPhone'];
1114	}
1115	$contact_data['connections']['connection'.$i]['type'] = $l_type;
1116	$contact_data['connections']['connection'.$i][$l_field] = utf8_decode($contact[$l_type_fields[0]][0]);
1117	$i++;
1118	}
1119	}
1120	else
1121	{
1122	$contact_data['connections']['connection1'][$l_field] = utf8_decode($contact[$l_value[0]][0]);
1123	}
1124	}
1125
1126	if (!(count($contact_data['connections'])))
1127	{
1128	unset($contact_data['connections']);
1129	}
1130	break;
1131
1132	case 'prefix':
1133	unset($l_fields);
1134	$l_fields = $this->trans_table['contact.prefixes.prefix'];
1135	if (!$l_fields or !$contact[$l_fields[0]][0])
1136	{
1137	unset($contact_data['prefix']);
1138	continue;
1139	}
1140
1141	$contact_data['prefix'] = utf8_decode($contact[$l_fields[0]][0]);
1142	break;
1143
1144	case 'suffix':
1145	unset($l_fields);
1146	$l_fields = $this->trans_table['contact.suffixes.suffix'];
1147	if (!$l_fields or !$contact[$l_fields[0]][0])
1148	{
1149	unset($contact_data['suffix']);
1150	continue;
1151	}
1152
1153	$contact_data['suffix'] = utf8_decode($contact[$l_fields[0]][0]);
1154	break;
1155
1156	case 'status':
1157	unset($l_fields);
1158	$l_fields = $this->trans_table['contact.status.status_name'];
1159	if (!$l_fields or !$contact[$l_fields[0]][0])
1160	{
1161	unset($contact_data['status']);
1162	continue;
1163	}
1164
1165	$contact_data['status'] = utf8_decode($contact[$l_fields[0]][0]);
1166	break;
1167
1168	case 'photo':
1169	unset($l_fields);
1170	$l_fields = $this->trans_table['contact.photo'];
1171	if (!$l_fields or !$contact[$l_fields[0]][0])
1172	{
1173	unset($contact_data['photo']);
1174	continue;
1175	}
1176
1177	$contact_data['photo'] = $contact[$l_fields[0]][0];
1178	break;
1179
1180	default:
1181	unset($l_fields);
1182	$l_fields = $this->trans_table['contact.'.$field];
1183	if (!$l_fields or !$contact[$l_fields[0]][0])
1184	{
1185	unset($contact_data[$field]);
1186	continue;
1187	}
1188
1189	if(count($contact[$l_fields[0]]) > 1)
1190	{
1191	$tmp = array();
1192	foreach ($contact[$l_fields[0]] as $i => $j)
1193	{
1194	$tmp["$i"] = utf8_decode($j);
1195	}
1196	//$contact_data[$field] = $contact[$l_fields[0]];
1197	$contact_data[$field] = $tmp;
1198	}
1199	else
1200	$contact_data[$field] = utf8_decode($contact[$l_fields[0]][0]);
1201
1202	break;
1203
1204	}
1205	}
1206
1207	if (is_array($contact_data))
1208	{
1209	$contacts[ldap_get_dn($ldap, $entry)] = $contact_data;
1210	}
1211
1212	}
1213
1214	return $contacts;
1215	}
1216
1217	function get_multiple_entries ( $id_contacts, $fields, $other_data = false, $external=false )
1218	{
1219	if (!is_array($id_contacts) or !is_array($fields) or ($other_data != false and !is_array($other_data)))
1220	{
1221	if (is_object($GLOBALS['phpgw']->log))
1222	{
1223	$GLOBALS['phpgw']->log->message(array(
1224	'text' => 'F-BadcontactcenterParam, wrong get_multiple_entry parameter type.',
1225	'line' => __LINE__,
1226	'file' => __FILE__));
1227
1228	$GLOBALS['phpgw']->log->commit();
1229	}
1230	else {
1231	exit('Argument Error on: <br>File:'.__FILE__.'<br>Line:'.__LINE__.'<br>');
1232	}
1233	}
1234
1235	foreach ($id_contacts as $id)
1236	{
1237	$contacts[$id] = $this->get_single_entry($id,$fields,$external);
1238	}
1239
1240	return $contacts;
1241
1242	// SERPRO
1243
1244	/*$contacts = array();
1245
1246	if ($other_data)
1247	{
1248	//TODO
1249	}
1250
1251	$filter = $this->generate_filter($id_contacts);
1252
1253	//$teste = $this->get_all_entries($filter, $fields);
1254
1255	return $this->get_all_entries($filter, $fields);*/
1256
1257	}
1258
1259	// CELEPAR
1260	function generate_filter($id_contacts)
1261	{
1262	if (($size = count($id_contacts)))
1263	{
1264	$contacts[$id] = $this->get_single_entry($id,$fields);
1265	}
1266
1267	return $contacts;
1268	}
1269
1270	// SERPRO
1271	/*
1272	function generate_filter($id_contacts)
1273	{
1274	if (($size = count($id_contacts)))
1275	{
1276	$filter = '(&(objectClass='.$this->src_info['obj'] . ')(\|';
1277	for ($i = 0; $i < $size; $i++)
1278	{
1279
1280	//
1281	// Não utiliza mais a função ldap_explode, usa a expressão regular a seguir para pegar o primeiro
1282	// componente da dn
1283	//
1284	preg_match('/^(\w=[^,]),.*$/', $id_contacts[$i], $cn);
1285
1286	//
1287	// Adicionados os str_replace para adicionar caracteres de escape em frente aos caracteres '(' e ')',
1288	// posteriormente poderá ser necessário substituir por uma expressão regular mais genérica.
1289	//
1290
1291	if ($cn[1])
1292	{
1293	//
1294	// Esta operação resolve o problema causado pela conversão de caracteres acentuados realizada
1295	// pela função ldap_explode_dn(). Talvez seja necessário utilizar esta tradução em outros lugares,
1296	// neste caso é mais apropriado colocar dentro de uma função.
1297	//
1298	//foreach($cn as $key=>$value){
1299	// $cn[$key]=preg_replace("/\\\([0-9A-Fa-f]{2})/e", "''.chr(hexdec('\\1')).''", $value);
1300	//}
1301
1302	$filter .= '(' . str_replace(')', '\)', str_replace('(','\(',$cn[1])) . ')';
1303	}
1304	}
1305	$filter .= '))';
1306	}
1307
1308	return $filter;
1309
1310	}
1311	*/
1312
1313	function get_all_entries_ids ()
1314	{
1315	$search_fields = array('contact.id_contact', 'contact.names_ordered');
1316	$search_rules = array(
1317	0 => array(
1318	'field' => 'contact.names_ordered',
1319	'type' => 'LIKE',
1320	'value' => '%'
1321	)
1322	);
1323	$search_other = array('order' => 'contact.names_ordered');
1324
1325	$result_i = $this->find($search_fields, $search_rules, $search_other);
1326
1327	if (is_array($result_i) and count($result_i))
1328	{
1329	$result = array();
1330	foreach($result_i as $result_part)
1331	{
1332	$result[] = $result_part['id_contact'];
1333	}
1334
1335	return $result;
1336	}
1337
1338	return null;
1339	}
1340
1341	function get_relations ($id_contact,$extra=false)
1342	{
1343	}
1344
1345	function get_addresses ( $id_contact,$extra=false )
1346	{
1347	}
1348
1349	function get_connections ( $id_contact,$extra=false )
1350	{
1351	}
1352
1353	function get_companies ( $id_contact, $extra=false )
1354	{
1355	}
1356
1357	function get_all_prefixes ( )
1358	{
1359	}
1360
1361	function get_all_suffixes ( )
1362	{
1363	}
1364
1365	function get_all_status ( )
1366	{
1367	}
1368
1369	function get_all_relations_types ( )
1370	{
1371	}
1372
1373	function get_all_addresses_types ( )
1374	{
1375	}
1376
1377	function get_all_connections_types ( )
1378	{
1379	}
1380
1381	function get_vcard ( $id_contact )
1382	{
1383	}
1384
1385
1386
1387
1388	function get_global_tree ( $root )
1389	{
1390	}
1391
1392	function get_actual_brach ( )
1393	{
1394	}
1395
1396	function set_actual_branch ( $branch )
1397	{
1398	}
1399	}
1400	?>

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

Context Navigation

source: branches/2.2.0.1/contactcenter/inc/class.bo_global_ldap_catalog.inc.php @ 4326

Download in other formats: