Context Navigation

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

Revision 884, 35.6 KB checked in by niltonneto, 15 years ago (diff)
Ticket #516 - Correção da ordenação da busca efetuada no catálogo Ldap.
Property svn:eol-style set to `native` Property svn:executable set to ``*

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

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

Download in other formats: