Context Navigation

source: trunk/contactcenter/inc/class.bo_global_ldap_catalog.inc.php @ 1419

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

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

Download in other formats: