Context Navigation

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

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

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

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

Download in other formats: