Context Navigation

class.ui_data.inc.php @ 7673

Revision 7673, 162.9 KB checked in by douglasz, 11 years ago (diff)
Ticket #3236 - Correcoes para Performance: Function Within Loop Declaration.
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	* - Jonas Goes <jqhcb@users.sourceforge.net> *
	8	* sponsored by Thyamad - http://www.thyamad.com *
	9	* ------------------------------------------------------------------------- *
	10	* This program is free software; you can redistribute it and/or modify it *
	11	* under the terms of the GNU General Public License as published by the *
	12	* Free Software Foundation; either version 2 of the License, or (at your *
	13	* option) any later version. *
	14	\***************************************************************************/
	15
[1599]	16
[2]	17	class ui_data
	18	{
	19	var $public_functions = array(
	20	'data_manager' => true,
[5131]	21	'advanced_searh_fields' => true
[2]	22	);
[1599]	23
[2]	24	var $bo;
[3334]	25	var $so_group;
[2]	26	var $typeContact;
[3795]	27	var $preferences;
[1599]	28
[2]	29	var $page_info = array(
	30	'n_cards' => 20,
	31	'n_pages' => false,
	32	'actual_letter' => 'A',
	33	'actual_page' => 1,
	34	'actual_entries' => false,
	35	'changed' => false,
	36	'catalogs' => false,
	37	'actual_catalog' => false
	38	);
[1599]	39
[2]	40	/*!
[1599]	41
[2]	42	@function ui_data
	43	@abstract The constructor. Sets the initial parameters and loads
	44	the data saved in the session
	45	@author Raphael Derosso Pereira
[1599]	46
[2]	47	*/
	48	function ui_data()
	49	{
	50	$temp = $GLOBALS['phpgw']->session->appsession('ui_data.page_info','contactcenter');
	51	$temp2 = $GLOBALS['phpgw']->session->appsession('ui_data.all_entries','contactcenter');
[1599]	52
[2]	53	$this->bo = CreateObject('contactcenter.bo_contactcenter');
[1599]	54
[2]	55	if ($temp)
	56	{
	57	$this->page_info = $temp;
	58	}
	59
	60	if ($temp2)
	61	{
	62	$this->all_entries = $temp2;
	63	}
[1599]	64
[2]	65	if (!$this->page_info['actual_catalog'])
	66	{
	67	$catalogs = $this->bo->get_catalog_tree();
	68	$this->page_info['actual_catalog'] = $catalogs[0];
	69	}
[1599]	70
[5131]	71	$this->page_info['actual_catalog'] = $this->bo->set_catalog($this->page_info['actual_catalog']);
[1599]	72
	73
[2]	74	if($this->page_info['actual_catalog']['class'] == 'bo_group_manager')
	75	$this -> typeContact = 'groups';
[1599]	76	/rev 104/
[752]	77	else if($this->page_info['actual_catalog']['class'] == 'bo_shared_group_manager')
	78	$this -> typeContact = 'shared_groups';
	79	else if($this->page_info['actual_catalog']['class'] == 'bo_shared_people_manager')
	80	$this -> typeContact = 'shared_contacts';
[1599]	81	/******/
[2]	82	else
	83	$this -> typeContact = 'contacts';
[3795]	84	$this->preferences = $_SESSION['phpgw_info']['user']['preferences']['contactcenter'];
[2]	85	}
	86
	87	/*!
[1599]	88
[2]	89	@function index
	90	@abstract Builds the Main Page
	91	@author Raphael Derosso Pereira
	92	@author Jonas Goes
[1599]	93
	94	*/
[2]	95	function index()
[1599]	96	{
[2]	97	if(!@is_object($GLOBALS['phpgw']->js))
	98	{
	99	$GLOBALS['phpgw']->js = CreateObject('phpgwapi.javascript');
	100	}
[5288]	101
[2]	102	$GLOBALS['phpgw']->js->validate_file('venus','table');
	103	$GLOBALS['phpgw']->js->validate_file('venus','shapes');
	104	$GLOBALS['phpgw']->js->validate_file('venus','jsStructUtil');
	105	$GLOBALS['phpgw']->js->validate_file('venus','cssUtil');
[1599]	106
[2]	107	// $GLOBALS['phpgw']->js->set_onload('setTimeout(\'updateCards()\',1000)');
	108	$GLOBALS['phpgw']->common->phpgw_header();
[1599]	109
[2]	110	$GLOBALS['phpgw']->template->set_file(array('index' => 'index.tpl'));
	111	$GLOBALS['phpgw']->template->set_var('cc_root_dir', $GLOBALS['phpgw_info']['server']['webserver_url'].'/contactcenter/');
[5288]	112	$GLOBALS['phpgw']->template->set_var('cc_msg_not_informed', lang('Not informed'));
[2]	113	/* Quick Add */
	114	$GLOBALS['phpgw']->template->set_var('cc_qa_alias',lang('Alias').':');
	115	$GLOBALS['phpgw']->template->set_var('cc_qa_given_names',lang('Given Names').':');
	116	$GLOBALS['phpgw']->template->set_var('cc_qa_family_names',lang('Family Names').':');
	117	$GLOBALS['phpgw']->template->set_var('cc_qa_phone',lang('Phone').':');
	118	$GLOBALS['phpgw']->template->set_var('cc_qa_email',lang('Email').':');
	119	$GLOBALS['phpgw']->template->set_var('cc_qa_save',lang('Save'));
	120	$GLOBALS['phpgw']->template->set_var('cc_qa_clear',lang('Clear'));
[285]	121	$GLOBALS['phpgw']->template->set_var('cc_qa_close',lang('Close'));
[2]	122	/* End Quick Add */
[1599]	123
[3282]	124	/* Advanced Search */
	125
	126	$GLOBALS['phpgw']->template->set_var('cc_corporate',lang('Corporate'));
	127	$GLOBALS['phpgw']->template->set_var('cc_cs_title',lang('Advanced Search'));
	128	$GLOBALS['phpgw']->template->set_var('cc_catalogues',lang('Catalogues'));
	129
	130
	131
	132	/* End of Advanced Search*/
	133
[2]	134	$cc_css_file = $GLOBALS['phpgw_info']['server']['webserver_url'].'/contactcenter/styles/cc.css';
	135	$cc_card_image_file = $GLOBALS['phpgw_info']['server']['webserver_url'].'/contactcenter/templates/default/images/card.png';
	136	$GLOBALS['phpgw']->template->set_var('cc_css',$cc_css_file);
	137	$GLOBALS['phpgw']->template->set_var('cc_dtree_css', $cc_dtree_file);
	138	$GLOBALS['phpgw']->template->set_var('cc_card_image',$cc_card_image_file);
[1599]	139
[2]	140	$GLOBALS['phpgw']->template->set_var('cc_personal',lang('Personal'));
[1599]	141
	142	/*rev 104*/
	143	//$GLOBALS['phpgw']->template->set_var('cc_full_add',lang('Full Add'));
[575]	144	$GLOBALS['phpgw']->template->set_var('cc_full_add_button',lang('Full Add'));
[1599]	145	/******/
	146	$GLOBALS['phpgw']->template->set_var('cc_full_add_button_sh',lang('Full Add Shared'));
[2]	147	$GLOBALS['phpgw']->template->set_var('cc_reset',lang('Reset'));
[1599]	148
[2]	149	$GLOBALS['phpgw']->template->set_var('cc_personal_data',lang('Personal Data'));
	150	$GLOBALS['phpgw']->template->set_var('cc_addresses',lang('Addresses'));
	151	$GLOBALS['phpgw']->template->set_var('cc_connections',lang('Connections'));
	152	$GLOBALS['phpgw']->template->set_var('cc_relations',lang('Relations'));
	153
	154	$GLOBALS['phpgw']->template->set_var('cc_quick_add',lang('Quick Add'));
	155	$GLOBALS['phpgw']->template->set_var('cc_catalogs',lang('Catalogues'));
	156	$GLOBALS['phpgw']->template->set_var('cc_group_add',lang('Group Add'));
[1599]	157
[2]	158	/* Panel */
	159	$GLOBALS['phpgw']->template->set_var('cc_panel_new',lang('New').'...');
	160	$GLOBALS['phpgw']->template->set_var('cc_panel_search',lang('Search').'...');
	161	$GLOBALS['phpgw']->template->set_var('cc_panel_table',lang('Table View'));
	162	$GLOBALS['phpgw']->template->set_var('cc_panel_cards',lang('Cards View'));
[285]	163	$GLOBALS['phpgw']->template->set_var('cc_btn_import_export', lang('Import/Export'));
	164	$GLOBALS['phpgw']->template->set_var('cc_btn_new', lang("New..."));
[1599]	165
[2]	166	$GLOBALS['phpgw']->template->set_var('cc_panel_search_found',lang('Showing found entries'));
	167	$GLOBALS['phpgw']->template->set_var('cc_panel_first_page',lang('First Page'));
	168	$GLOBALS['phpgw']->template->set_var('cc_panel_previous_page',lang('Previous Page'));
	169	$GLOBALS['phpgw']->template->set_var('cc_panel_next_page',lang('Next Page'));
	170	$GLOBALS['phpgw']->template->set_var('cc_panel_last_page',lang('Last Page'));
	171	$GLOBALS['phpgw']->template->set_var('cc_all',lang('all'));
	172	/* End Panel */
[1599]	173
[2]	174	/* Messages */
[1599]	175	/rev 104/
[503]	176	$GLOBALS['phpgw']->template->set_var('cc_msg_not_allowed',lang('Not Allowed'));
[1599]	177	$GLOBALS['phpgw']->template->set_var('cc_msg_unavailable',lang('Unavailable function'));
	178	/*****/
[1682]	179
	180
	181	$GLOBALS['phpgw']->template->set_var('cc_msg_name_mandatory',lang('Name is mandatory'));
[1690]	182	$GLOBALS['phpgw']->template->set_var('cc_msg_err_invalid_serch',lang('The query should not have the characters {%,?}'));
[1682]	183	$GLOBALS['phpgw']->template->set_var('cc_msg_tel_or_mail_required',lang('Tel or email is required'));
	184
[2]	185	$GLOBALS['phpgw']->template->set_var('cc_msg_no_cards',lang('No Cards'));
	186	$GLOBALS['phpgw']->template->set_var('cc_msg_err_no_room',lang('No Room for Cards! Increase your browser area.'));
	187	$GLOBALS['phpgw']->template->set_var('cc_msg_card_new',lang('New from same Company'));
	188	$GLOBALS['phpgw']->template->set_var('cc_msg_card_edit',lang('Edit Contact'));
	189	$GLOBALS['phpgw']->template->set_var('cc_msg_card_remove',lang('Remove Contact'));
	190	$GLOBALS['phpgw']->template->set_var('cc_send_mail',lang('Send Mail'));
	191	$GLOBALS['phpgw']->template->set_var('cc_msg_group_edit',lang('Edit Group'));
	192	$GLOBALS['phpgw']->template->set_var('cc_msg_group_remove',lang('Remove Group'));
	193	$GLOBALS['phpgw']->template->set_var('cc_msg_group_remove_confirm',lang('Confirm Removal of this Group?'));
	194	$GLOBALS['phpgw']->template->set_var('cc_msg_card_remove_confirm',lang('Confirm Removal of this Contact?'));
	195	$GLOBALS['phpgw']->template->set_var('cc_participants',lang('Participants'));
	196	$GLOBALS['phpgw']->template->set_var('cc_empty',lang('Empty'));
	197	/* End Messages */
[1599]	198
[2]	199	$GLOBALS['phpgw']->template->set_var('cc_results',lang('Results'));
	200	$GLOBALS['phpgw']->template->set_var('cc_is_my',lang('Is My'));
[285]	201	$GLOBALS['phpgw']->template->set_var('cc_ie_personal',lang('Import/Export pesonal contacts'));
[2]	202	$GLOBALS['phpgw']->template->set_var('cc_btn_search',lang('Search'));
	203	$GLOBALS['phpgw']->template->set_var('cc_add_relation',lang('Add Relation'));
[1599]	204	$GLOBALS['phpgw']->template->set_var('cc_del_relation',lang('Remove Selected Relations'));
[38]	205	$GLOBALS['phpgw']->template->set_var('cc_msg_group',lang('Group'));
	206	$GLOBALS['phpgw']->template->set_var('cc_msg_contact_full',lang('Contact [Full]'));
[1496]	207	$GLOBALS['phpgw']->template->set_var('cc_msg_contact_sh',lang('Contact [Shared]'));
[38]	208	$GLOBALS['phpgw']->template->set_var('cc_msg_contact_qa',lang('Contact [Quick Add]'));
[2]	209	$GLOBALS['phpgw']->template->set_var('cc_contact_title',lang('Contact Center').' - '.lang('Contacts'));
	210	$GLOBALS['phpgw']->template->set_var('cc_window_views_title',lang('Contact Center').' - '.lang('Views'));
	211	$GLOBALS['phpgw']->template->set_var('phpgw_img_dir', $GLOBALS['phpgw_info']['server']['webserver_url'] . '/phpgwapi/images');
[118]	212
[285]	213	$GLOBALS['phpgw']->template->set_var('cc_msg_import_contacts', lang('Import Contacts'));
	214	$GLOBALS['phpgw']->template->set_var('cc_msg_export_contacts', lang('Export Contacts'));
	215	$GLOBALS['phpgw']->template->set_var('cc_msg_expresso_info_csv', lang('The Expresso supports the contacts importation in the CSV file format.'));
	216	$GLOBALS['phpgw']->template->set_var('cc_msg_choose_file_type', lang('Select the file type'));
	217	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_express', lang('Outlook Express'));
	218	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook2k', lang('Outlook 2000'));
	219	$GLOBALS['phpgw']->template->set_var('cc_msg_expresso_default', lang('Expresso (default)'));
	220	$GLOBALS['phpgw']->template->set_var('cc_msg_choose_contacts_file', lang('Select the file that contains the contacts to be imported:'));
	221	$GLOBALS['phpgw']->template->set_var('cc_msg_close_win', lang('Close'));
	222	$GLOBALS['phpgw']->template->set_var('cc_msg_close', lang('Close'));
	223	$GLOBALS['phpgw']->template->set_var('cc_msg_ie_personal', lang('Import / Export personal Contacts'));
	224	$GLOBALS['phpgw']->template->set_var('cc_msg_import_fail', lang('The importation has failed. Verify the file format.'));
	225	$GLOBALS['phpgw']->template->set_var('cc_msg_importing_contacts', lang('Importing Contacts...'));
	226	$GLOBALS['phpgw']->template->set_var('cc_msg_import_finished', lang('The importation has finished.'));
	227	$GLOBALS['phpgw']->template->set_var('cc_msg_new', lang(' new'));
	228	$GLOBALS['phpgw']->template->set_var('cc_msg_failure', lang(' failed'));
	229	$GLOBALS['phpgw']->template->set_var('cc_msg_exists', lang(' were existent'));
	230	$GLOBALS['phpgw']->template->set_var('cc_msg_show_more_info', lang('show more info'));
	231	$GLOBALS['phpgw']->template->set_var('cc_msg_clean', lang('Clean'));
	232	$GLOBALS['phpgw']->template->set_var('cc_msg_invalid_csv', lang('Select a valid CSV file to import your contacts'));
	233	$GLOBALS['phpgw']->template->set_var('cc_msg_export_csv', lang('Select the format type that you want to export your contacts'));
	234	$GLOBALS['phpgw']->template->set_var('cc_msg_automatic', lang('Automatic'));
	235	$GLOBALS['phpgw']->template->set_var('cc_msg_export_error', lang('An error has occurred while the exportation.'));
	236	$GLOBALS['phpgw']->template->set_var('cc_msg_new_email', lang('New Email'));
	237	$GLOBALS['phpgw']->template->set_var('cc_msg_main', lang('Main'));
	238	$GLOBALS['phpgw']->template->set_var('cc_msg_alternative', lang('Alternative'));
	239	$GLOBALS['phpgw']->template->set_var('cc_msg_select_email', lang('Select E-Mail'));
	240	$GLOBALS['phpgw']->template->set_var('cc_msg_new_phone', lang('New Telephone'));
[3549]	241	$GLOBALS['phpgw']->template->set_var('cc_msg_home', lang('Home Phone'));
[285]	242	$GLOBALS['phpgw']->template->set_var('cc_msg_cellphone', lang('Cellphone'));
[1517]	243	$GLOBALS['phpgw']->template->set_var('cc_msg_corporative_cellphone', lang('Corporative Cellphone'));
	244	$GLOBALS['phpgw']->template->set_var('cc_msg_corporative_fax', lang('Corporative Fax'));
[1599]	245	$GLOBALS['phpgw']->template->set_var('cc_msg_corporative_pager', lang('Corporative Pager'));
[285]	246	$GLOBALS['phpgw']->template->set_var('cc_msg_work', lang('Work'));
	247	$GLOBALS['phpgw']->template->set_var('cc_msg_fax', lang('Fax'));
	248	$GLOBALS['phpgw']->template->set_var('cc_msg_pager', lang('Pager'));
	249	$GLOBALS['phpgw']->template->set_var('cc_msg_choose_phone', lang('Select the telephone'));
	250	$GLOBALS['phpgw']->template->set_var('cc_msg_warn_firefox', lang('Warning: Too old version of Firefox'));
	251	$GLOBALS['phpgw']->template->set_var('cc_msg_firefox_half1', lang('For this application work correctly</u>'));
	252	$GLOBALS['phpgw']->template->set_var('cc_msg_firefox_half2', lang('it\'s necessary to update your Firefox Browser for a new version (version > 1.5) Install now clicking in the link bellow, or if you want to update it later'));
	253	$GLOBALS['phpgw']->template->set_var('cc_msg_click_close', lang('click Close'));
	254	$GLOBALS['phpgw']->template->set_var('cc_msg_install_now', lang('Install Now'));
	255	$GLOBALS['phpgw']->template->set_var('cc_msg_install_new_firefox', lang('Install a new Firefox version'));
	256	$GLOBALS['phpgw']->template->set_var('cc_msg_moz_thunderbird', lang('Export as Mozilla Thunderbird CSV.'));
	257	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_express_pt', lang('Export as Outlook Express (Portuguese) CSV.'));
	258	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_express_en', lang('Export as Outlook Express (English) CSV.'));
	259	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_2k_pt', lang('Export as Outlook 2000 (Portuguese) CSV.'));
	260	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_2k_en', lang('Export as Outlook 2000 (English) CSV.'));
[5131]	261	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_2003', lang('Export as Outlook 2003 CSV.'));
[285]	262	$GLOBALS['phpgw']->template->set_var('cc_msg_expresso_default_csv', lang('Export as Expresso (Default) CSV.'));
	263	$GLOBALS['phpgw']->template->set_var('cc_msg_copy_to_catalog', lang('Copy to personal catalog.'));
	264	$GLOBALS['phpgw']->template->set_var('cc_msg_add_contact_to_group', lang('You did not add any contact for this group.'));
	265	$GLOBALS['phpgw']->template->set_var('cc_msg_fill_field_name', lang('Fill the field Full Name'));
[5131]	266	$GLOBALS['phpgw']->template->set_var('cc_msg_show_extra_detail', lang("Show extra contact's details."));
[1599]	267
[3334]	268	$select_groups = '';
	269
	270	$this->so_group = CreateObject('contactcenter.so_group');
	271
	272	$array_groups = $this->so_group->selectGroupsOwnerCanImportContacts($GLOBALS['phpgw_info']['user']['account_id']);
	273
	274	$select_groups = "<select id='id_group'>";//<option value=0>Selecione um grupo...</option></select>";
	275	$select_groups .= "<option value=0 selected>Nenhum...</option>";
	276	foreach ($array_groups as $group){
	277	$select_groups .= "<option value='".$group['id_group']."'>".$group['title']."</option>";
	278	}
	279	$select_groups .= "</select>";
	280
	281	$GLOBALS['phpgw']->template->set_var('cc_select_groups',$select_groups);
	282
[1517]	283	if($GLOBALS['phpgw_info']['server']['personal_contact_type']=='True'){
	284	$GLOBALS['phpgw']->template->set_var('cc_contact_type', 'advanced');
	285	}else{
	286	$GLOBALS['phpgw']->template->set_var('cc_contact_type', 'default');
	287	}
[5131]	288
	289	/*
	290	* Monta Contactcenter Busca Avancada
	291	*/
	292	$c = CreateObject('phpgwapi.config','contactcenter');
	293	$c->read_repository();
	294	$current_config = $c->config_data;
	295
	296	$arraySearch = array();
	297	foreach ($current_config as $index => $value)
	298	{
	299
	300	if(substr($index, 0, 24) == 'cc_attribute_searchable_')
	301	{
	302	if($value == 'true')
	303	{
	304	$v = substr($index, 24, strlen($index));
	305	$arraySearch[] = $v;
	306	}
	307	}
	308	}
	309	$advanceSearchArray = array();
	310	foreach ($arraySearch as $value)
	311	{
	312	foreach ($current_config as $index => $value2)
	313	{
	314	if($value == substr($index, 22, strlen($index)) && substr($index, 0, 22) == 'cc_attribute_ldapname_')
	315	{
	316	foreach ($current_config as $index2 => $value3)
	317	{
	318	if($value == substr($index2, 18, strlen($index2)) && substr($index2, 0, 18) == 'cc_attribute_name_')
	319	$advanceSearchArray[$value2] = $value3;
	320	}
	321	}
	322
	323	}
	324	}
	325
	326	$advanceSearch = array();
	327	foreach ($advanceSearchArray as $index => $value)
	328	$advanceSearch[] ='"'.$index.'":"'.$value.'"';
	329
	330	$advancedFields = "{".implode(',',$advanceSearch)."}";
	331
	332
	333	$GLOBALS['phpgw']->template->set_var('cc_config_advanced_search', $advancedFields);
	334
	335
	336
[2]	337	$GLOBALS['phpgw']->template->parse('out','index');
[1599]	338
[2]	339	$api = CreateObject('contactcenter.ui_api');
	340	$main = $api->get_full_add();
	341	$main .= $api->get_search_obj();
	342	$main .= $api->get_quick_add_plugin();
	343	$main .= $api->get_add_group();
[5131]	344	$main .= $api->get_contact_details();
[2]	345	$main .= $GLOBALS['phpgw']->template->get_var('out');
	346
	347	echo $main;
	348	}
	349
[1599]	350
[2]	351	/*!
[1599]	352
[2]	353	@function data_manager
[1599]	354	@abstract Calls the right method and passes to it the right
[2]	355	parameters
	356	@author Raphael Derosso Pereira
[1599]	357
[2]	358	*/
	359	function data_manager()
	360	{
[5288]	361	$GLOBALS['phpgw']->template->set_file(array('index' => 'index.tpl'));
	362	$GLOBALS['phpgw']->template->set_var('cc_msg_not_informed', lang('Not informed'));
	363
[2]	364	switch($_GET['method'])
	365	{
	366	/* Cards Methods */
	367	case 'set_n_cards':
	368	return $this->set_n_cards((int)$_GET['ncards']);
[1599]	369
	370	case 'get_cards_data':
[3303]	371
[284]	372	$ids = false;
	373	// To support ldap catalogs using accentuation
	374	if ($_POST['letter'] == 'search' && isset($_POST['data']))
	375	{
[285]	376	$ids = utf8_decode($this->search($_POST['data']));
[284]	377	}
[1599]	378
[285]	379	if(isset($_SESSION['ids']))
	380	$ids = $_SESSION['ids'];
[1599]	381
	382	return $this->get_cards_data($_POST['letter'], $_POST['page'], $ids);
	383
[2]	384	case 'get_cards_data_get':
	385	return $this->get_cards_data($_GET['letter'], $_GET['page'], unserialize(str_replace('\\"','"',$_GET['ids'])));
	386
	387
	388	case 'get_photo':
	389	return $this->get_photo($_GET['id']);
	390
[3795]	391	case 'get_init_values':
	392	echo serialize(array("visible_all_ldap" => $this->get_visible_all_ldap(), "preferences" => $this->preferences));
[285]	393	return;
[1599]	394
[2]	395	/* Catalog Methods */
	396	case 'set_catalog':
	397	return $this->set_catalog($_GET['catalog']);
[1599]	398
[2]	399	case 'get_catalog_tree':
	400	echo serialize($this->get_catalog_tree($_GET['level']));
	401	return;
	402
	403	case 'get_actual_catalog':
	404	echo serialize($this->get_actual_catalog());
	405	return;
	406
	407	case 'get_catalog_participants_list':
	408	echo serialize($this->get_catalog_participants_list($_POST['id']));
	409	return;
[1599]	410	/rev 104/
[880]	411	case 'get_catalog_participants_group':
	412	echo serialize($this->get_catalog_participants_group($_POST['id']));
	413	return;
[1599]	414	/***/
[2]	415	case 'get_catalog_add_contact':
[284]	416	// To support ldap catalogs with accentuation
[5131]	417	echo serialize($this->get_catalog_add_contact($_POST['id']));
[2]	418	return;
[1599]	419
[2]	420	/* Full Add Methods */
	421	case 'get_full_data':
[1599]	422	//return $this->get_full_data($_GET['id']);
	423	/rev 104/
[503]	424	return $this->get_full_data($_GET['id'],$_GET['catalog']);
[1599]	425	/****/
	426
[2]	427	case 'get_group':
[1280]	428	return $this->get_group_data($_GET['id'],isset($_GET['shared_from'])?$_GET['shared_from']:null);
[1599]	429
[2]	430	case 'get_contact_full_add_const':
	431	return $this->get_contact_full_add_const();
	432
	433	case 'post_full_add':
	434	return $this->post_full_add();
	435
[1496]	436	case 'post_full_add_shared' :
	437	return $this->post_full_add_shared();
	438
[2]	439	case 'post_photo':
	440	return $this->post_photo((int) $_GET['id'] ? (int) $_GET['id'] : '_new_');
	441
	442	case 'get_states':
	443	return $this->get_states($_GET['country']);
[1599]	444
[2]	445	case 'get_cities':
	446	return $this->get_cities($_GET['country'], $_GET['state'] ? $_GET['state'] : null);
[1599]	447
	448
[2]	449	/* Other Methods */
[1599]	450	case 'quick_add':
[2]	451	return $this->quick_add($_POST['add']);
[1599]	452
	453	case 'add_group':
[2]	454	return $this->add_group($_POST['add']);
[1599]	455
[2]	456	case 'remove_entry':
	457	return $this->remove_entry((int)$_GET['remove']);
[1599]	458
[2]	459	case 'remove_all_entries':
	460	return $this->remove_all_entries();
	461
	462	case 'remove_group':
	463
[1599]	464	return $this->remove_group((int)$_GET['remove']);
	465
[2]	466	case 'search':
[285]	467	$ids = false;
	468	$ids = $this->search($_GET['data']);
[3970]	469	$data = unserialize($_GET['data']);
	470	$dontPaginate = false;
	471	if (isset($data['ccAddGroup'])){
	472	$dontPaginate = true;
	473	}
	474	return $this->get_cards_data('search', '1', $ids, $dontPaginate);
[2]	475
	476	case 'email_win':
	477	$GLOBALS['phpgw']->common->phpgw_header();
	478	$api = CreateObject('contactcenter.ui_api');
	479	$win = $api->get_email_win();
	480	$win .= $api->get_quick_add_plugin();
	481	$win .= '<input id="QAbutton" type="button" value="QuickAdd" />'
	482	.'<br><input type="button" value="EmailWin" onclick="ccEmailWin.open()" />'
	483	.'<script type="text/javascript">'
	484	.' ccQuickAdd.associateAsButton(Element("QAbutton"));'
	485	.'</script>';
	486	echo $win;
	487	return;
	488
	489	/* Information Gathering */
	490	case 'get_multiple_entries':
	491	echo serialize($this->get_multiple_entries(str_replace('\\"','"',$_POST['data'])));
	492	return;
	493
	494	case 'get_all_entries':
	495	echo serialize($this->get_all_entries(str_replace('\\"','"',$_POST['data'])));
	496	return;
	497
	498	case 'import_contacts':
[3334]	499	return $this->import_contacts($_GET['typeImport'],$_GET['id_group']);
[2]	500
	501	case 'export_contacts':
	502	return $this->export_contacts($_POST['typeExport']);
[3313]	503
	504	case 'get_qtds_compartilhado':
	505	return $this->get_qtds_compartilhado();
[3335]	506	case 'get_list_owners_perms_add':
	507	echo $this->get_list_owners_perms_add();
	508	return;
[5131]	509	case 'get_contact_details':
	510	return $this->get_contact_details($_GET['id']);
[2]	511	}
	512	}
	513
	514	/*!
[1599]	515
[2]	516	@function set_n_cards
	517	@abstract Informs the class the number of cards the page can show
	518	@author Raphael Derosso Pereira
[1599]	519
[2]	520	@param integer $n_cards The number of cards
[1599]	521
[2]	522	*/
	523	function set_n_cards($n_cards)
	524	{
	525	if (is_int($n_cards))
	526	{
	527	$this->page_info['n_cards'] = $n_cards;
	528	echo 1;
	529	}
[1599]	530
[2]	531	$this->save_session();
	532	}
[1599]	533
[2]	534	/*!
[1599]	535
[2]	536	@function set_catalog
	537	@abstract Sets the current catalog selected by the user
	538	@author Raphael Derosso Pereira
[1599]	539
[2]	540	@param string $id_catalog The sequence of IDs to reach the catalog
	541	separated by commas
[1599]	542
[2]	543	*/
[3970]	544	function set_catalog($id_catalog, $echo=true)
[2]	545	{
	546	$id_catalog = str_replace('\\"', '"', $id_catalog);
[5131]	547	$temp = $this->bo->set_catalog($id_catalog);
[1599]	548
[3333]	549	if(!$this->bo->catalog->src_info) {
	550	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	551	$this->bo->catalog->src_info = $ldap->srcs[1];
	552	}
	553
	554	$resetCC_actual_letter = 0;
	555	if($this->bo->catalog->src_info['visible'] == "false")
	556	{
	557	$resetCC_actual_letter = 1;
	558	}
	559
[2]	560	if ($temp)
	561	{
[3333]	562	unset($this->page_info['actual_letter']);
[2]	563	$this->page_info['changed'] = true;
	564	$this->page_info['actual_entries'] = false;
[5131]	565	$this->page_info['actual_catalog'] = $temp;
[2]	566	$this->save_session();
[1599]	567
[2]	568	$catalog_info = $this->bo->get_branch_by_level($this->bo->catalog_level[0]);
[1599]	569
[2]	570	if ($catalog_info['class'] === 'bo_global_ldap_catalog' \|\|
	571	$catalog_info['class'] === 'bo_catalog_group_catalog')
	572	{
	573	$perms = 1;
	574	}
	575	else
	576	{
	577	$perms = 15;
	578	}
[1599]	579
[3970]	580	if ($echo)
	581	{
	582	echo serialize(array(
	583	'status' => 'ok',
	584	'catalog' => $catalog_info['class'],
	585	'external' => $catalog_info['external']?true:false,
	586	'resetCC_actual_letter' => $resetCC_actual_letter,
	587	'perms' => $perms
	588	));
	589	}
	590	else
	591	{
	592	return serialize(array(
	593	'status' => 'ok',
	594	'catalog' => $catalog_info['class'],
	595	'external' => $catalog_info['external']?true:false,
	596	'resetCC_actual_letter' => $resetCC_actual_letter,
	597	'perms' => $perms
	598	));
	599	}
[2]	600
	601	return;
	602	}
[1599]	603
[2]	604	echo serialize(array(
	605	'status' => 'ok',
[3333]	606	'resetCC_actual_letter' => $resetCC_actual_letter,
[2]	607	'perms' => 0
	608	));
	609	}
[1599]	610
	611
[2]	612	/*!
[1599]	613
[2]	614	@function get_catalog_tree
	615	@abstract Returns the JS serialized array to used as the tree
	616	level
	617	@author Raphael Derosso Pereira
[3334]	618	@author Mário César Kolling (error messages and timeout)
[1599]	619
	620	@param (string) $level The level to be taken
	621
[2]	622	*/
	623	function get_catalog_tree($level)
	624	{
	625	if ($level === '0')
	626	{
	627	$folderImageDir = $GLOBALS['phpgw_info']['server']['webserver_url'] . '/phpgwapi/dftree/images/';
	628
	629	$parent = '0';
[1599]	630
[2]	631	if (!($tree = $this->bo->get_catalog_tree($level)))
	632	{
	633	return array(
	634	'msg' => lang('Couldn\'t get the Catalogue Tree. Please contact the Administrator.'),
	635	'status' => 'fatal'
	636	);
	637	}
	638	}
	639	else
	640	{
	641	$last_dot = strrpos($level,'.');
	642	$parent = substr($level, 0, $last_dot);
	643	$child = substr($level, $last_dot+1, strlen($level));
	644	if (!($tree[$child] = $this->bo->get_catalog_tree($level)))
	645	{
	646	return array(
	647	'msg' => lang('Couldn\'t get the Catalogue Tree. Please contact the Administrator.'),
	648	'status' => 'fatal'
	649	);
	650	}
[284]	651	// Deals with timeout and returns the generated message to the browser
	652	else if (!empty($tree[$child]['timeout']) && !empty($tree[$child]['msg']))
	653	{
	654	$tmp = array(
	655	'msg' => $tree[$child]['msg'],
	656	'status' => 'fatal'
	657	);
	658	unset($tree[$child]);
	659	return $tmp;
	660	}
[2]	661	}
[1599]	662
[2]	663	$folderImageDir = $GLOBALS['phpgw']->common->image('contactcenter','globalcatalog-mini.png');
	664	$folderImageDir = substr($folderImageDir, 0, strpos($folderImageDir, 'globalcatalog-mini.png'));
[1599]	665
[284]	666	// Deals with error messages from the server and returns them to the browser
	667	if ($tree['msg'])
	668	{
	669	$msg = $tree['msg'];
	670	unset($tree['msg']);
	671	}
	672
[2]	673	$tree_js = $this->convert_tree($tree, $folderImageDir, $parent);
[284]	674
	675	// Return status = ok, or else return generated message to the browser
	676	if (!$msg)
	677	{
	678	return array(
	679	'data' => $tree_js,
	680	'msg' => lang('Catalog Tree Successfully taken!'),
	681	'status' => 'ok'
	682	);
	683	}
	684	else
	685	{
	686	return array(
	687	'data' => $tree_js,
	688	'msg' => $msg,
	689	'status' => 'error'
	690	);
	691	}
[2]	692	}
[1599]	693
[2]	694	/*!
[1599]	695
[2]	696	@function get_actual_catalog
	697	@abstract Returns the actual selected Catalog
	698	@author Raphael Derosso Pereira
	699
	700	*/
	701	function get_actual_catalog()
[1599]	702	{
[2]	703	$level = $this->bo->get_level_by_branch($this->bo->get_actual_catalog(), $this->bo->tree['branches'], '0');
[1599]	704
[2]	705	if ($level)
	706	{
	707	return array(
	708	'status' => 'ok',
	709	'data' => $level
	710	);
	711	}
	712
	713	return array(
	714	'status' => 'fatal',
	715	'msg' => lang('Couldn\'t get the actual catalog.'),
	716	);
	717	}
[1599]	718
[3313]	719	function get_qtds_compartilhado() {
	720	$so_contact = CreateObject('contactcenter.so_contact', $GLOBALS['phpgw_info']['user']['account_id']);
	721	$relacionados = $so_contact->get_relations();
	722
	723	$perms_relacao = array();
	724
	725	foreach($relacionados as $uid_relacionado => $tipo_relacionamento) {
	726	$aclTemp = CreateObject("phpgwapi.acl",$uid_relacionado);
	727	$aclTemp->read();
	728	$perms_relacao[$uid_relacionado] = $aclTemp->get_specific_rights($GLOBALS['phpgw_info']['user']['account_id'],'contactcenter'); //Preciso verificar as permissões que o contato relacionado deu para o atual
	729	}
	730
	731	$validos = array();
	732	$count = 0;
	733	foreach($perms_relacao as $uid_relacionado => $val){
	734	if ($perms_relacao[$uid_relacionado]&2)
	735	{
	736	$validos[$uid_relacionado] = $perms_relacao[$uid_relacionado];
[7655]	737	++$count;
[3313]	738	}
	739	}
	740	echo serialize(array(0=>$count));
	741	}
	742
[2]	743	/*!
[1599]	744
[2]	745	@function get_cards_data
	746	@abstract Returns the information that is placed on the cards
	747	@author Raphael Derosso Pereira
[1599]	748
[2]	749	@param string $letter The first letter to be searched
[1599]	750	@param (int) $page The page to be taken
[2]	751	@param (str) $ids The ids to be taken in case of search
	752
	753	TODO: This function is not well done. It must be rewritten
	754	using the new array 'msg','status','data' schema.
	755	*/
[3970]	756	function get_cards_data($letter, $page, $ids, $dontPaginate = false)
[2]	757	{
[285]	758	if( $ids )
[1599]	759	$_SESSION['ids'] = $ids;
[284]	760
	761	// It's an external catalog?
	762	$external = $this->bo->is_external($this->page_info['actual_catalog']);
[2]	763	//echo $page."\n";
	764	if ($letter !== 'search' and ($letter != $this->page_info['actual_letter'] or
[1599]	765	($letter == $this->page_info['actual_letter'] and $page == $this->page_info['actual_page']) or
[2]	766	$this->page_info['changed']))
	767	{
	768	unset($ids);
	769	$this->page_info['changed'] = false;
[1599]	770
[2]	771	switch ($this->page_info['actual_catalog']['class'])
	772	{
[1599]	773	/rev 104/
[752]	774	case 'bo_shared_people_manager':
[1599]	775	/****/
[752]	776	case 'bo_people_catalog':
[503]	777	$field_name = 'id_contact';
[1599]	778
[503]	779	if ($letter !== 'number')
	780	{
	781	$find_restric[0] = array(
	782	0 => array(
	783	'field' => 'contact.names_ordered',
	784	'type' => 'iLIKE',
	785	'value' => $letter !== 'all' ? $letter.'%' : '%'
[1599]	786	/rev 104/
	787	/* ),
	788	1 => array(
	789	'field' => 'contact.id_owner',
	790	'type' => '=',
	791	'value' => $GLOBALS['phpgw_info']['user']['account_id']
	792	*/
	793	)
[503]	794	);
[1496]	795
	796	//Tratamento de permissão de escrita no compartilhamento de catalogo
	797	$so_contact = CreateObject('contactcenter.so_contact', $GLOBALS['phpgw_info']['user']['account_id']);
	798	$relacionados = $so_contact->get_relations();
	799
[1599]	800	$perms_relacao = array();
	801
[1496]	802	foreach($relacionados as $uid_relacionado => $tipo_relacionamento) {
	803	$aclTemp = CreateObject("phpgwapi.acl",$uid_relacionado);
	804	$aclTemp->read();
	805	$perms_relacao[$uid_relacionado] = $aclTemp->get_specific_rights($GLOBALS['phpgw_info']['user']['account_id'],'contactcenter'); //Preciso verificar as permissões que o contato relacionado deu para o atual
	806	}
	807
	808	$validos = array();
	809	$count = 0;
	810	foreach($perms_relacao as $uid_relacionado => $val){
	811	if ($perms_relacao[$uid_relacionado]&2)
	812	{
	813	$validos[$uid_relacionado] = $perms_relacao[$uid_relacionado];
[7655]	814	++$count;
[1496]	815	}
	816	}
	817	$prop_names = array();
	818	if($validos) {
	819	$filtro = "(\|";
	820	foreach($validos as $i => $prop) {
	821	$filtro .= "(uidNumber=".$i.")";
	822	}
	823	$filtro .= ")";
	824
	825	if(!$this->bo->catalog->src_info) {
	826	$ldaps = CreateObject('contactcenter.bo_ldap_manager');
	827	$this->bo->catalog->src_info = $ldaps->srcs[1];
	828	}
	829	$s = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], false);
	830	$n=$this->bo->catalog->src_info['dn'];
	831	$apenasThese = array("cn","uidnumber","uid");
[1599]	832	$r = ldap_search($s,$n, $filtro,$apenasThese);
[1496]	833	$infos = ldap_get_entries($s, $r);
[1599]	834	ldap_close($s);
[7655]	835	for($z = 0; $z < $infos['count']; ++$z) {
[1496]	836	$prop_names[$infos[$z]['uidnumber'][0]] = array("cn" => $infos[$z]['cn'][0], "uid" => $infos[$z]['uid'][0]);
	837	}
	838	}
	839	//--------------------------------------------------------------------------------
	840	if($this->page_info['actual_catalog']['class'] == 'bo_people_catalog')
	841	{
[752]	842	$find_restric[0][1] = array(
	843	'field' => 'contact.id_owner',
	844	'type' => '=',
	845	'value' => $GLOBALS['phpgw_info']['user']['account_id']
	846	);
	847	}
[1599]	848	/****/
	849
[503]	850	}
	851	else
	852	{
	853	$find_restric[0] = array(
	854	0 => array(
	855	'type' => 'branch',
	856	'value' => 'OR',
	857	'sub_branch' => array(
	858	0 => array(
	859	'field' => 'contact.names_ordered',
	860	'type' => 'LIKE',
	861	'value' => '0%'
	862	),
	863	1 => array(
	864	'field' => 'contact.names_ordered',
	865	'type' => 'LIKE',
	866	'value' => '1%'
	867	),
	868	2 => array(
	869	'field' => 'contact.names_ordered',
	870	'type' => 'LIKE',
	871	'value' => '2%'
	872	),
	873	3 => array(
	874	'field' => 'contact.names_ordered',
	875	'type' => 'LIKE',
	876	'value' => '3%'
	877	),
	878	4 => array(
	879	'field' => 'contact.names_ordered',
	880	'type' => 'LIKE',
	881	'value' => '4%'
	882	),
	883	5 => array(
	884	'field' => 'contact.names_ordered',
	885	'type' => 'LIKE',
	886	'value' => '5%'
	887	),
	888	6 => array(
	889	'field' => 'contact.names_ordered',
	890	'type' => 'LIKE',
	891	'value' => '6%'
	892	),
	893	7 => array(
	894	'field' => 'contact.names_ordered',
	895	'type' => 'LIKE',
	896	'value' => '7%'
	897	),
	898	8 => array(
	899	'field' => 'contact.names_ordered',
	900	'type' => 'LIKE',
	901	'value' => '8%'
	902	),
	903	9 => array(
	904	'field' => 'contact.names_ordered',
	905	'type' => 'LIKE',
	906	'value' => '9%'
[752]	907	),
	908	),
[1599]	909	/rev 104/
	910	/* ),
	911	1 => array(
	912	'field' => 'contact.id_owner',
	913	'type' => '=',
	914	'value' => $GLOBALS['phpgw_info']['user']['account_id']
	915	),
	916	*/
[503]	917	)
	918	);
	919	}
[2]	920
[752]	921	if($this->page_info['actual_catalog']['class'] == 'bo_people_catalog'){
	922	$find_restric[0][1] = array(
	923	'field' => 'contact.id_owner',
	924	'type' => '=',
	925	'value' => $GLOBALS['phpgw_info']['user']['account_id']
[2]	926	);
	927	}
[1599]	928	/*****/
	929
[2]	930	$find_field[0] = array('contact.id_contact','contact.names_ordered');
[1599]	931
[2]	932	$find_other[0] = array(
[1599]	933	/rev 104/
	934	//'offset' => (($page-1)*$this->page_info['n_cards']),
	935	//'limit' => $this->page_info['n_cards'],
	936	/*****/
[2]	937	'order' => 'contact.names_ordered'
	938	);
[1599]	939
[2]	940	break;
[1599]	941
[3420]	942	case 'bo_catalog_group_catalog':
[2]	943	case 'bo_global_ldap_catalog':
[1599]	944
[2]	945	$field_name = 'id_contact';
	946
	947	if ($letter !== 'number')
	948	{
	949	$find_restric[0] = array(
	950	0 => array(
	951	'field' => 'contact.names_ordered',
	952	'type' => 'iLIKE',
[3333]	953	'value' => $letter !== 'all' ? $letter.'%' : '%'
[284]	954	),
	955	/*
	956	* Restrict the returned contacts in a "first letter" search
[1599]	957	/**rev 104
[284]	958	* to objectClass = phpgwAccount, must have attibute phpgwAccountStatus,
[880]	959	* phpgwAccountVisible != -1
[284]	960	*/
	961	1 => array(
	962	'field' => 'contact.object_class',
	963	'type' => '=',
	964	'value' => 'phpgwAccount'
[1599]	965	/rev 104/
	966	//),/*
[284]	967	),
[1599]	968	/****/
[284]	969	2 => array(
	970	'field' => 'contact.account_status',
	971	'type' => 'iLIKE',
	972	'value' => '%'
[1599]	973	/rev 104/
	974	//),*/
	975	//2 => array(
[284]	976	),
	977	3 => array(
[1599]	978	/*****/
[284]	979	'field' => 'contact.account_visible',
	980	'type' => '!=',
	981	'value' => '-1'
[1599]	982	/rev 104/
	983	/* ),
	984	3 => array(
	985	'field' => 'contact.object_class',
	986	'type' => '=',
	987	'value' => 'inetOrgPerson'
	988	),
	989	*/
[880]	990	)
[1599]	991	/*****/
	992
[2]	993	);
[284]	994	// If not external catalog get only phpgwAccountType = u ou l
	995	if (!$external)
	996	{
	997	$find_restric[0][5] = array(
	998	'type' => 'branch',
	999	'value' => 'OR',
	1000	'sub_branch' => array(
	1001	0 => array(
	1002	'field' => 'contact.account_type',
	1003	'type' => '=',
	1004	'value' => 'u'
	1005	),
[285]	1006	1 => array(
[284]	1007	'field' => 'contact.account_type',
	1008	'type' => '=',
[418]	1009	'value' => 'i'
[1599]	1010	/rev 104/
[418]	1011	),
	1012	2 => array(
	1013	'field' => 'contact.account_type',
	1014	'type' => '=',
[1599]	1015	/****/
[284]	1016	'value' => 'l'
[1599]	1017	/rev 104/
[880]	1018	),
	1019	3 => array(
	1020	'field' => 'contact.account_type',
	1021	'type' => '=',
	1022	'value' => 'g'
[1599]	1023	/***/
[3688]	1024	),
	1025	4 => array(
	1026	'field' => 'contact.account_type',
	1027	'type' => '=',
	1028	'value' => 's'
[284]	1029	)
[2]	1030	)
[3688]	1031	);
[284]	1032	}
[2]	1033	}
	1034	else
	1035	{
	1036	$find_restric[0] = array(
[284]	1037	/*
	1038	* Restrict the returned contacts in a "first number" search
[1599]	1039	/**rev 104
[284]	1040	* to objectClass = phpgwAccount, must have attibute phpgwAccountStatus,
[880]	1041	* phpgwAccountVisible != -1
[284]	1042	*/
[2]	1043	0 => array(
[284]	1044	'field' => 'contact.object_class',
	1045	'type' => '=',
	1046	'value' => 'phpgwAccount'
[1599]	1047	/rev 104/
	1048	//),/*
[284]	1049	),
[1599]	1050	/****/
[284]	1051	1 => array(
	1052	'field' => 'contact.account_status',
	1053	'type' => 'iLIKE',
	1054	'value' => '%'
[1599]	1055	/rev 104/
	1056	//),*/
	1057	//1 => array(
[284]	1058	),
	1059	2 => array(
[1599]	1060	/*****/
[284]	1061	'field' => 'contact.account_visible',
	1062	'type' => '!=',
	1063	'value' => '-1'
	1064	),
[1599]	1065	/rev 104/
	1066	/* 2 => array(
	1067	'field' => 'contact.object_class',
	1068	'type' => '=',
	1069	'value' => 'inetOrgPerson'
	1070	),
	1071	*/
	1072	/****/
[284]	1073	3 => array(
[2]	1074	'type' => 'branch',
	1075	'value' => 'OR',
	1076	'sub_branch' => array(
	1077	0 => array(
	1078	'field' => 'contact.names_ordered',
	1079	'type' => 'LIKE',
	1080	'value' => '0%'
	1081	),
	1082	1 => array(
	1083	'field' => 'contact.names_ordered',
	1084	'type' => 'LIKE',
	1085	'value' => '1%'
	1086	),
	1087	2 => array(
	1088	'field' => 'contact.names_ordered',
	1089	'type' => 'LIKE',
	1090	'value' => '2%'
	1091	),
	1092	3 => array(
	1093	'field' => 'contact.names_ordered',
	1094	'type' => 'LIKE',
	1095	'value' => '3%'
	1096	),
	1097	4 => array(
	1098	'field' => 'contact.names_ordered',
	1099	'type' => 'LIKE',
	1100	'value' => '4%'
	1101	),
	1102	5 => array(
	1103	'field' => 'contact.names_ordered',
	1104	'type' => 'LIKE',
	1105	'value' => '5%'
	1106	),
	1107	6 => array(
	1108	'field' => 'contact.names_ordered',
	1109	'type' => 'LIKE',
	1110	'value' => '6%'
	1111	),
	1112	7 => array(
	1113	'field' => 'contact.names_ordered',
	1114	'type' => 'LIKE',
	1115	'value' => '7%'
	1116	),
	1117	8 => array(
	1118	'field' => 'contact.names_ordered',
	1119	'type' => 'LIKE',
	1120	'value' => '8%'
	1121	),
	1122	9 => array(
	1123	'field' => 'contact.names_ordered',
	1124	'type' => 'LIKE',
	1125	'value' => '9%'
	1126	),
	1127	),
	1128	),
	1129	);
[284]	1130	// If not external catalog get only phpgwAccountType = u ou l
	1131	if (!$external)
	1132	{
	1133	$find_restric[0][5] = array(
	1134	'type' => 'branch',
	1135	'value' => 'OR',
	1136	'sub_branch' => array(
	1137	0 => array(
	1138	'field' => 'contact.account_type',
	1139	'type' => '=',
	1140	'value' => 'u'
	1141	),
[418]	1142	1 => array(
	1143	'field' => 'contact.account_type',
	1144	'type' => '=',
[1599]	1145	/rev 104/
	1146	//'value' => 'g'
	1147	//);
	1148	//1 => array(
[418]	1149	'value' => 'i'
	1150	),
[880]	1151	2 => array(
[1599]	1152	/****/
[284]	1153	'field' => 'contact.account_type',
	1154	'type' => '=',
[880]	1155	'value' => 'l'
[1599]	1156	/rev 104/
[880]	1157	),
	1158	3 => array(
[284]	1159	'field' => 'contact.account_type',
	1160	'type' => '=',
[880]	1161	'value' => 'g'
[3688]	1162	),
	1163	/****/
	1164	4 => array(
	1165	'field' => 'contact.account_type',
	1166	'type' => '=',
	1167	'value' => 's'
[284]	1168	)
[2]	1169	)
[284]	1170	);
	1171	}
[2]	1172	}
[284]	1173
	1174	if (!$external)
	1175	{
	1176	// Get only this attributes: dn, cn, phpgwAccountType, objectClass, phpgwAccountStatus, phpghAccountVisible
	1177	// for non-external catalogs, used to restrict the attributes used in filters
	1178	$find_field[0] = array('contact.id_contact','contact.names_ordered','contact.account_type',
[1599]	1179	'contact.object_class','contact.account_visible');
[284]	1180	}
	1181	else
	1182	{
	1183	// Get only this attributes: dn, cn for external catalogs,
	1184	// used to restrict the attributes used in filters
	1185	$find_field[0] = array('contact.id_contact','contact.names_ordered');
	1186	}
[1599]	1187
[2]	1188	$find_other[0] = array(
	1189	//'offset' => (($page-1)*$this->page_info['n_cards']),
	1190	//'limit' => $this->page_info['n_cards'],
	1191	'order' => 'contact.names_ordered'
	1192	);
[1599]	1193
[2]	1194	break;
[1599]	1195
[2]	1196	case 'bo_company_manager':
	1197	$field_name = 'id_company';
[1599]	1198
[2]	1199	$find_field[0] = array('company.id_company','company.company_name');
[1599]	1200
[2]	1201	$find_other[0] = array(
	1202	//'offset' => (($page-1)*$this->page_info['n_cards']),
	1203	//'limit' => $this->page_info['n_cards'],
	1204	'order' => 'company.company_name'
	1205	);
[1599]	1206
[2]	1207	$find_restric[0] = array(
	1208	0 => array(
	1209	'field' => 'company.company_name',
	1210	'type' => 'iLIKE',
	1211	'value' => $letter !== 'all' ? $letter.'%' : '%'
	1212	)
	1213	);
[1599]	1214
[2]	1215	break;
	1216
	1217	case 'bo_group_manager':
[1599]	1218	/rev 104/
[752]	1219	case 'bo_shared_group_manager':
[1599]	1220	/****/
	1221
[2]	1222	$field_name = 'id_group';
[1599]	1223
[2]	1224	if ($letter !== 'number') {
[1599]	1225
[2]	1226	$find_restric[0] = array(
	1227	0 => array(
	1228	'field' => 'group.title',
	1229	'type' => 'iLIKE',
	1230	'value' => $letter !== 'all' ? $letter.'%' : '%'
	1231	)
	1232	);
	1233	}
	1234	else {
[1599]	1235
[2]	1236	$find_restric[0] = array(
	1237	0 => array(
	1238	'field' => 'group.title',
	1239	'type' => 'LIKE',
[1599]	1240	'value' => '0%'
[2]	1241	)
[1599]	1242	);
[2]	1243	}
[1599]	1244	/rev 104/
[752]	1245	if($this->page_info['actual_catalog']['class'] == 'bo_group_manager'){
[1599]	1246	/****/
[752]	1247	array_push($find_restric[0], array(
[2]	1248	'field' => 'group.owner',
	1249	'type' => '=',
[1599]	1250	'value' => $GLOBALS['phpgw_info']['user']['account_id']
[752]	1251	)
	1252	);
	1253	}
[1599]	1254
	1255	$find_field[0] = array('group.id_group','group.title','group.short_name');
[2]	1256	$find_other[0] = array(
	1257	'order' => 'group.title'
[1599]	1258	);
[2]	1259	break;
[1599]	1260
[3420]	1261	/*case 'bo_catalog_group_catalog':
[2]	1262	$this->page_info['actual_entries'] = false;
[1599]	1263
[2]	1264	$this->page_info['actual_letter'] = $letter;
	1265	$this->page_info['actual_page'] = 0;
[1599]	1266
[2]	1267	$this->save_session();
	1268	$final[0] = 0;
[285]	1269	$final[1] = $this->typeContact;
[1599]	1270	echo serialize($final);
[3420]	1271	return;*/
[2]	1272
	1273	}
[1496]	1274
[4806]	1275	if(!$this->bo->catalog->src_info) {
	1276	$ldaps = CreateObject('contactcenter.bo_ldap_manager');
	1277	$this->bo->catalog->src_info = $ldaps->srcs[1];
	1278	}
	1279	$recursive = $this->bo->catalog->src_info['recursive'];
	1280
	1281	$result = $this->bo->find($find_field[0],$find_restric[0],$find_other[0],false,($recursive == "true") ? true : '');
[2]	1282	$n_entries = count($result);
[1599]	1283
[2]	1284	if ($n_entries)
	1285	{
	1286	//echo 'N_entries: '.$n_entries.'<br>';
[4768]	1287	$this->page_info['n_pages'] = $dontPaginate ? 1 : ceil($n_entries/$this->page_info['n_cards']);
[2]	1288	}
	1289	else
	1290	{
	1291	$this->page_info['n_pages'] = 0;
	1292	}
	1293
	1294	if (!$result)
	1295	{
	1296	$this->page_info['actual_entries'] = false;
[1599]	1297
[2]	1298	$this->page_info['actual_letter'] = $letter;
	1299	$this->page_info['actual_page'] = 0;
[1599]	1300
	1301	$this->save_session();
[2]	1302	$final[0] = 0;
[285]	1303	$final[1] = $this->typeContact;
[1599]	1304	echo serialize($final);
[2]	1305	return;
	1306	}
	1307	else
	1308	{
	1309	unset($this->page_info['actual_entries']);
[3180]	1310	if(is_array($result)) {
	1311	foreach ($result as $id => $value)
	1312	{
	1313	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
	1314	$this->page_info['actual_entries'][] = $value[$field_name];
	1315	else
	1316	$this->page_info['actual_entries'][] = array(0=>$value[$field_name],1=>$value['perms'],2=>$value['owner']);
	1317	}
[1599]	1318	}
[2]	1319	}
	1320	}
	1321	else if ($letter === 'search')
	1322	{
[284]	1323	//if (!$ids and $this->page_info['actual_letter'] !== 'search')
[285]	1324	if (!$ids)
[2]	1325	{
[1599]	1326	/rev 104/
[315]	1327	//error_log('!$ids e $this->page_info[\'actual_letter\'] != search');
[1599]	1328	/*****/
[2]	1329	$this->page_info['actual_entries'] = false;
[1599]	1330
[2]	1331	$this->page_info['actual_letter'] = $letter;
	1332	$this->page_info['actual_page'] = 0;
[1599]	1333
[2]	1334	$this->save_session();
	1335	$final[0] = 0;
	1336	$final[1] = $this -> typeContact;
[1599]	1337	echo serialize($final);
[2]	1338	return;
	1339	}
[284]	1340	else if ($ids['error'])
	1341	{
	1342	$this->page_info['actual_entries'] = false;
	1343	$this->page_info['actual_letter'] = $letter;
	1344	$this->page_info['actual_page'] = 0;
	1345
	1346	$this->save_session();
	1347	$final[0] = 0;
	1348	$final[1] = $this -> typeContact;
	1349	$final['error'] = $ids['error'];
	1350	echo serialize($final);
	1351	return;
	1352	}
[285]	1353	else if ($ids)
[1599]	1354	{
[2]	1355	$this->page_info['actual_letter'] = $letter;
	1356	$this->page_info['actual_entries'] = $ids;
[4768]	1357	$this->page_info['n_pages'] = $dontPaginate ? 1 : ceil(count($this->page_info['actual_entries'])/$this->page_info['n_cards']);
[2]	1358	}
	1359	}
	1360	else
	1361	{
	1362	unset($ids);
	1363	}
	1364
	1365	if ($this->page_info['actual_entries'])
	1366	{
	1367	if ($page >= $this->page_info['n_pages'])
	1368	{
	1369	$page = $this->page_info['n_pages'];
	1370	}
[1599]	1371
[2]	1372	$final = array(
	1373	0 => (int)$this->page_info['n_pages'],
	1374	1 => (int)$page,
	1375	2 => array(
	1376	0 => 'cc_company',
	1377	1 => 'cc_name',
	1378	2 => 'cc_title',
	1379	3 => 'cc_phone',
	1380	4 => 'cc_mail',
	1381	5 => 'cc_alias',
	1382	6 => 'cc_id',
[1599]	1383	7 => 'cc_forwarding_address',
	1384	8 => 'cc_empNumber',
	1385	9 => 'cc_department',
	1386	10 => 'cc_mobile'
[2]	1387	)
	1388	);
[4753]	1389
[5131]	1390	//verifica se esta habilitado a opcao de exibir os detalhes extras
	1391	$objconfig = CreateObject('phpgwapi.config', 'contactcenter');
	1392	$config = $objconfig->read_repository();
	1393
[2]	1394	//echo 'Page: '.$page.'<br>';
	1395	$n_entries = count($this->page_info['actual_entries']);
[3970]	1396	$n_cards = $dontPaginate? $n_entries : $this->page_info['n_cards'];
	1397	$id_i = (($page-1)*$n_cards);
	1398	$id_f = $id_i + $n_cards;
[1599]	1399
[2]	1400	//echo 'ID_I: '.$id_i.'<br>';
	1401	//echo 'ID_F: '.$id_f.'<br>';
[3334]	1402	///---------------- Correção Temporária PHP5 -----------------------///
[2]	1403	$ids = array();
[1599]	1404	/rev 104/
[503]	1405	$perms = array();
[752]	1406	$owners = array();
[1599]	1407	/****/
	1408	$array_temp = array();
	1409
[2]	1410	foreach($this->page_info['actual_entries'] as $key=>$tmp){
[1599]	1411	$array_temp[] = $tmp;
[1496]	1412	}
[1599]	1413
[7655]	1414	for($i = $id_i; $i < $id_f and $i < $n_entries; ++$i)
[2]	1415	{
[1599]	1416	/rev 104/
[752]	1417	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
[1599]	1418	{
	1419	/****/
[503]	1420	$ids[] = $array_temp[$i];
[1599]	1421	/rev 104/
	1422	}else {
[503]	1423	$ids[] = $array_temp[$i][0];
	1424	$perms[] = $array_temp[$i][1];
[752]	1425	$owners[] = $array_temp[$i][2];
[1599]	1426	/****/
[503]	1427	}
[2]	1428	}
[1599]	1429
	1430	/rev 104/
[752]	1431	// Carrega o nome completo dos donos dos objetos (contatos e grupos);
	1432	$owner_names = array();
[1599]	1433
[752]	1434	if($owners) {
	1435	$filter = "(\|";
	1436	foreach($owners as $i => $owner) {
	1437	$filter .= "(uidNumber=".$owner.")";
	1438	}
	1439	$filter .= ")";
[1496]	1440
[752]	1441	if(!$this->bo->catalog->src_info) {
	1442	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	1443	$this->bo->catalog->src_info = $ldap->srcs[1];
	1444	}
[1599]	1445	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], false);
[752]	1446	$dn=$this->bo->catalog->src_info['dn'];
	1447	$justThese = array("cn","uidnumber","uid");
[1599]	1448	$sr = ldap_search($ds,$dn, $filter,$justThese);
[752]	1449	$info = ldap_get_entries($ds, $sr);
[1599]	1450	ldap_close($ds);
[7655]	1451	for($z = 0; $z < $info['count']; ++$z) {
[752]	1452	$owner_names[$info[$z]['uidnumber'][0]] = array("cn" => $info[$z]['cn'][0], "uid" => $info[$z]['uid'][0]);
[1599]	1453	}
[5131]	1454
	1455	//SAMPLE : dc=teste, dc=diretorio, dc=empresa
	1456	if(!count($owner_names)){
	1457	$dns = explode(',', $dn);
	1458	for($i = count($dns); $i > 0; $i--){
	1459	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], false);
	1460	//verifica se veio a base como parametro, remoção de erros gerados por paramentro null
	1461	//if(isset($dns[$i])){
	1462	$sr = ldap_search($ds,$dns[$i], $filter,$justThese);
	1463	$info = ldap_get_entries($ds, $sr);
	1464	ldap_close($ds);
[7655]	1465	for($z = 0; $z < $info['count']; ++$z) {
[5131]	1466	$owner_names[$info[$z]['uidnumber'][0]] = array("cn" => $info[$z]['cn'][0], "uid" => $info[$z]['uid'][0]);
	1467	}
	1468	if(count($owner_names)){
	1469	$i = 0;
	1470	}
	1471	// }
	1472	}
	1473	}
[752]	1474	}
[1599]	1475
	1476	/*****/
	1477
	1478
[2]	1479	/// Original
[7655]	1480	//for($i = $id_i; $i < $id_f and $i < $n_entries; ++$i)
[2]	1481	//{
	1482	// $ids[] = $this->page_info['actual_entries'][$i];
	1483	//}
	1484	///
[1599]	1485
[2]	1486	$fields = $this->bo->catalog->get_fields(false);
[1599]	1487	/rev 104/
	1488	//if( $this->typeContact == 'groups') {
[752]	1489	if( $this->typeContact == 'groups' \|\| $this->typeContact == 'shared_groups') {
[1599]	1490	/****/
[2]	1491	$final = array(
	1492	0 => (int)$this->page_info['n_pages'],
	1493	1 => (int)$page,
	1494	2 => array(
	1495	0 => 'cc_title',
	1496	1 => 'cc_short_name',
	1497	2 => 'cc_id',
	1498	3 => 'cc_contacts'
[1599]	1499	)
	1500	);
	1501
[5131]	1502	$groups = $this->bo->catalog->get_multiple_entries($ids,$fields);
[1599]	1503
[2]	1504	$i = 0;
	1505	// contatos do grupo
[1599]	1506	$boGroups = CreateObject('contactcenter.bo_group');
[2]	1507	$contacts = array();
[1599]	1508	foreach($groups as $group) {
	1509
[2]	1510	$final[3][$i][0] = $group['title'] ? $group['title'] : 'none';
[1599]	1511	$final[3][$i][1] = $group['short_name'] ? $group['short_name'] : 'none';
[2]	1512	$final[3][$i][2] = $group['id_group'] ? $group['id_group'] : 'none';
	1513	$contacts = $boGroups -> get_contacts_by_group($group['id_group']);
	1514	$final[3][$i][3] = $contacts;
[752]	1515	$final[3][$i][4] = $perms[$i];
	1516	if($this->typeContact == 'shared_groups'){
	1517	$final[3][$i][5] = lang('Shared').": ".$owner_names[$owners[$i]]['cn'];
	1518	$final[3][$i][6] = $owner_names[$owners[$i]]['uid'];
[1280]	1519	$final[3][$i][7] = $owners[$i]; //uidNumber
[7655]	1520	}
	1521	++$i;
[2]	1522	}
[1599]	1523
[2]	1524	$this->page_info['actual_letter'] = $letter;
[1599]	1525	$this->page_info['actual_page'] = $page;
	1526
	1527
[2]	1528	$lnk_compose = "location.href=('../expressoMail1_2/index.php?to=";
[1599]	1529
	1530	$final[5] = '<span class="link" onclick="'.$lnk_compose;
	1531	/rev 104/
	1532	//$final[10] = 'groups';
	1533	$final[10] = $this->typeContact;
	1534	/******/
	1535	$this->save_session();
[2]	1536	echo serialize($final);
[1599]	1537	return;
[2]	1538	}
[1599]	1539	/rev 104/
[503]	1540	$final[10] = $this -> typeContact;
[1599]	1541	/*****/
	1542
[2]	1543	$fields['photo'] = true;
	1544	$fields['names_ordered'] = true;
	1545	$fields['alias'] = true;
	1546	$fields['account_type'] = true;
	1547	$fields['companies'] = 'default';
	1548	$fields['connections'] = 'default';
[1599]	1549
	1550	/rev 104/
[3334]	1551	// ?aqui alterar a chamada desse método para receber o base dn?
[1599]	1552	//$contacts = &$this->bo->catalog->get_multiple_entries($ids,$fields);
	1553
[285]	1554	// ?aqui alterar a chamada desse método para receber o base dn?
[1419]	1555	if($external)
[1599]	1556	{
[5131]	1557	$contacts = $this->bo->catalog->get_multiple_entries($ids,$fields,false,true);
[1599]	1558	} else{
[5131]	1559	$contacts = $this->bo->catalog->get_multiple_entries($ids,$fields);
[1599]	1560	}
	1561	/*******/
[2]	1562	if (!is_array($contacts) or !count($contacts))
	1563	{
	1564	$final[0] = 0;
	1565	$final[1] = $this -> typeContact;
	1566	echo serialize($final);
	1567	return;
	1568	}
[1599]	1569
[2]	1570	$i = 0;
[3795]	1571	if (!is_array($this->preferences))
	1572	{
	1573	$this->preferences['personCardEmail'] = 1;
	1574	$this->preferences['personCardPhone'] = 2;
	1575	}
[284]	1576	foreach($contacts as $index => $contact)
[2]	1577	{
[284]	1578	/*
[3334]	1579	* TODO: Os timeouts de conexão foram retirados, ver se será necessário retornar essa funcionalidade, e,
	1580	* neste caso, terminar a implementação das mensagens de retorno.
[284]	1581	*/
	1582	if ($index !== 'error'){
	1583	$final[3][$i][0] = $contact['companies']['company1']['company_name']?$contact['companies']['company1']['company_name']:'none';
[1599]	1584
	1585	/rev 104/
	1586	//$final[3][$i][1] = $contact['names_ordered'] ? $contact['names_ordered'] : 'none';
	1587
[1419]	1588	if($this->page_info['actual_catalog']['class']!='bo_global_ldap_catalog'){
[3211]	1589	$final[3][$i][1] = $contact['names_ordered'] ? urldecode(is_array($contact['names_ordered']) ? $contact['names_ordered'][0] : $contact['names_ordered']) : 'none';
[1419]	1590	}
	1591	else {
	1592	$contact['names_ordered'][0] = urldecode($contact['names_ordered'][0]);
	1593	$final[3][$i][1] = $contact['names_ordered'] ? $contact['names_ordered'] : 'none';
	1594	}
[1599]	1595
	1596	/********/
	1597
[5131]	1598	$final[3][$i][2] = $contact['companies']['company1']['title']? $contact['companies']['company1']['title']:'none';
[2]	1599
[1599]	1600	//Para exibir a matricula do empregado
	1601	$final[3][$i][8] = $contact['companies']['company1']['empNumber']?$contact['companies']['company1']['empNumber']:'none';
	1602	//Para exibir o setor/lotacao do empregado
	1603	$final[3][$i][9] = $contact['companies']['company1']['department']?$contact['companies']['company1']['department']:'none';
	1604	//Para exibir o celular empresarial do empregado
	1605	$final[3][$i][10] = $contact['companies']['company1']['celPhone']?$contact['companies']['company1']['celPhone']:'none';
	1606
	1607	//Para exibir o celular empresarial do empregado
[3795]	1608	if ($this->preferences['voip_enabled'] && !$external && $final[3][$i][10] != 'none')
[1599]	1609	$final[3][$i][10] = "<a title=\"".lang("Call Mobile")."\" href=\"#\" onclick=\"connectVoip('".$final[3][$i][10]."', 'mob')\">".$final[3][$i][10]."</a>";
	1610
[284]	1611	if ($contact['connections'])
	1612	{
	1613	$default_email_found = false;
	1614	$default_phone_found = false;
	1615	foreach($contact['connections'] as $conn_info)
[2]	1616	{
[3795]	1617	if ($conn_info['id_type'] == $this->preferences['personCardEmail'] and !$default_email_found)
[2]	1618	{
[284]	1619	if ($conn_info['connection_is_default'])
	1620	{
	1621	$default_email_found = true;
	1622	}
	1623	$final[3][$i][4] = $conn_info['connection_value'] ? $conn_info['connection_value'] : 'none';
[4767]	1624	$final[3][$i][13] = $conn_info['id_connection'];
[2]	1625	}
[3795]	1626	else if ($conn_info['id_type'] == $this->preferences['personCardPhone'] and !$default_phone_found)
[2]	1627	{
[284]	1628	if ($conn_info['connection_is_default'])
	1629	{
	1630	$default_phone_found = true;
	1631	}
[5131]	1632	if($final[3][$i][4] == 'none' or !$final[3][$i][4]){
[5288]	1633	$final[3][$i][4] = lang('Not informed');
[5131]	1634	$final[3][$i][13] = $conn_info['id_connection'];
	1635	}
[1599]	1636	/rev 104/
	1637	//if ($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['voip_enabled'] && !$external){
	1638	// $conn_info['connection_value'] = "<a title=\"".lang("Call Extension")."\" href=\"#\" onclick=\"connectVoip('".$conn_info['connection_value']."', 'ramal')\">".$conn_info['connection_value']."</a>";
	1639
[3795]	1640	if (!($this->preferences['telephone_number'] == $conn_info['connection_value']) && $this->preferences['contactcenter']['voip_enabled'] && $conn_info['connection_value'] && preg_match('/^$[0-9]{2}$[0-9]{4}\-[0-9]{4}$/',$conn_info['connection_value'])==1 && !$external){
[284]	1641	$conn_info['connection_value'] = "<a title=\"".lang("Call Extension")."\" href=\"#\" onclick=\"connectVoip('".$conn_info['connection_value']."', 'com')\">".$conn_info['connection_value']."</a>";
[1599]	1642
	1643	/*****/
[285]	1644	}
[284]	1645	$final[3][$i][3] = $conn_info['connection_value'] ? $conn_info['connection_value'] : 'none';
	1646	}
[5131]	1647	if($final[3][$i][4] == 'none' or !$final[3][$i][4]){
[5288]	1648	$final[3][$i][4] = lang('Not informed');
[5131]	1649	$final[3][$i][13] = $conn_info['id_connection'];
	1650
	1651	}
[2]	1652	}
	1653	}
[1599]	1654
[284]	1655	if (!$final[3][$i][3])
	1656	{
	1657	$final[3][$i][3] = 'none';
	1658	}
	1659
[5131]	1660	if($final[3][$i][4] == 'none' or !$final[3][$i][4]){
[5288]	1661	$final[3][$i][4] = lang('Not informed');
[5131]	1662	$final[3][$i][13] = $conn_info['id_connection'];
	1663
[284]	1664	}
	1665
[1411]	1666	$final[3][$i][5] = $contact['alias']? urldecode( $contact['alias'] ):'none';
[5131]	1667	$final[3][$i][6] = utf8_decode($ids[$i]);
[284]	1668
[1599]	1669	/rev 104/
	1670	/* // If contact is a public list, then load the forwarding addresses.
	1671	if($contact['account_type'][0] == 'l')
	1672	$final[3][$i][7] = array();
	1673	*/
	1674
	1675	//If contact is a public list or a group, then load the forwarding addresses.
[880]	1676	if($contact['account_type'][0] == 'l' \|\| $contact['account_type'][0] == 'g')
	1677	$final[3][$i][7] = ($contact['account_type'][0] == 'l' ? 'list' : 'group');
[503]	1678
[752]	1679	if($this->page_info['actual_catalog']['class']=='bo_shared_people_manager') {
[1599]	1680	$final[3][$i][11] = $perms[$i];
	1681	$final[3][$i][12] = lang('Shared').": ".$owner_names[$owners[$i]]['cn'];
[503]	1682	}
[284]	1683
	1684	$final[4][$i] = $contact['photo'] ? 1 : 0;
[5131]	1685
	1686
[7655]	1687
	1688	++$i;
[2]	1689	}
[284]	1690	else
[2]	1691	{
[284]	1692	// coloca mensagem de erro no vetor que retorna para o browser
[2]	1693	}
[284]	1694	}
	1695	$lnk_compose = "location.href=('../expressoMail1_2/index.php?to=";
	1696	$final[5] = '<span class="link" onclick="'.$lnk_compose;
[1496]	1697	$final[6] = $prop_names;
	1698	$final[7] = $validos;
	1699	$final[8] = $this->page_info['actual_catalog']['class'];
	1700	$final[9] = $count;
[3970]	1701	$final[11] = $this->bo->catalog_level;
[5131]	1702	$final[12] = isset($config['cc_allow_details'])? $config['cc_allow_details'] : false;
	1703	$final[13] = '<span class="" ';
[2]	1704	$this->page_info['actual_letter'] = $letter;
	1705	$this->page_info['actual_page'] = $page;
[1599]	1706
	1707	$this->save_session();
[2]	1708	echo serialize($final);
	1709	return;
	1710	}
[1599]	1711
[2]	1712	$this->page_info['actual_letter'] = $letter;
	1713	$this->page_info['actual_page'] = $page;
[1599]	1714
[2]	1715	$this->save_session();
[1599]	1716
[2]	1717	$final[0] = 0;
	1718	$final[1] = $this -> typeContact;
	1719	echo serialize($final);
	1720	}
[3335]	1721
	1722
	1723	function get_list_owners_perms_add(){
	1724	$acl = CreateObject('phpgwapi.acl');
	1725	$find_result = $acl->get_rights_and_owners($GLOBALS['phpgw_info']['user']['account_id'],'contactcenter');
	1726	if($find_result){
	1727	$owner_names = array();
	1728	$filter = "(\|";
	1729	foreach($find_result as $owner) {
	1730	if(($owner['acl_rights'] & PHPGW_ACL_ADD) == PHPGW_ACL_ADD){
	1731	$filter .= "(uidNumber=".$owner['acl_account'].")";
	1732	}
	1733	}
	1734	if(!$this->bo->catalog->src_info) {
	1735	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	1736	$this->bo->catalog->src_info = $ldap->srcs[1];
	1737	}
	1738	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], false);
	1739	$filter .= ")";
	1740	$dn=$this->bo->catalog->src_info['dn'];
	1741	$justThese = array("cn","uidnumber","uid");
	1742	$sr = ldap_search($ds,$dn, $filter,$justThese);
	1743	$info = ldap_get_entries($ds, $sr);
[7655]	1744	for($z = 0; $z < $info['count']; ++$z) {
[3335]	1745	$owner_names[$info[$z]['uidnumber'][0]] = array("cn" => $info[$z]['cn'][0], "uid" => $info[$z]['uid'][0]);
	1746	}
	1747	ldap_close($ds);
[5131]	1748	if(!count($owner_names)){
	1749	$dns = explode(',', $dn);
	1750	for($i = count($dns); $i > 0; $i--){
	1751	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], false);
	1752	$sr = ldap_search($ds,$dns[$i], $filter,$justThese);
	1753	$info = ldap_get_entries($ds, $sr);
	1754	ldap_close($ds);
[7655]	1755	for($z = 0; $z < $info['count']; ++$z) {
[5131]	1756	$owner_names[$info[$z]['uidnumber'][0]] = array("cn" => $info[$z]['cn'][0], "uid" => $info[$z]['uid'][0]);
	1757	}
	1758	if(count($owner_names)){
	1759	$i = 0;
	1760	}
	1761	}
	1762	}
[3335]	1763	}
	1764	echo serialize ($owner_names);
	1765	}
[1599]	1766
[285]	1767	function get_visible_all_ldap()
	1768	{
	1769	$bo = CreateObject('contactcenter.bo_ldap_manager');
	1770	$ldap_query = $bo->srcs;
[1599]	1771	return $ldap_query[1]['visible'];
[285]	1772	}
[284]	1773
[1599]	1774
[2]	1775	/*!
[1599]	1776
[2]	1777	@function get_group_data
	1778	@abstract Returns all the information of a given Group
	1779	@author Nilton Emilio Buhrer Neto
[1599]	1780
[2]	1781	@param (integer) $id The id to get information
[1599]	1782
	1783	*/
[1280]	1784	function get_group_data($id,$shared_from=null)
[2]	1785	{
	1786	$this->bo->catalog = CreateObject('contactcenter.bo_group_manager');
	1787	$fields = $this->bo->catalog->get_fields(true);
	1788	$data = $this->bo->catalog->get_single_entry($id,$fields);
[285]	1789
	1790	if($id) {
[2]	1791	// get All Contacts by group.
[285]	1792	$data['contact_in_list'] = $this->bo->catalog->get_contacts_by_group($id);
[2]	1793	}
[285]	1794
[2]	1795	$boGroup = CreateObject('contactcenter.bo_group');
[4753]	1796
[5131]	1797	$all_contacts = $boGroup->get_all_contacts(false,$shared_from);
[285]	1798
	1799	$contact_options = "";
	1800	if(count($all_contacts)) {
	1801	foreach($all_contacts as $idx => $contact) {
[5131]	1802	$contact_options .= "<OPTION value='".$contact['id_connection']."'>".$contact['names_ordered'];
	1803	if (isset($contact['connection_value']))
	1804	$contact_options .= " (".$contact['connection_value'].")</OPTION>";
	1805	else
	1806	$contact_options .= " (". $contact['phone'].")</OPTION>";
[285]	1807	}
	1808	}
[1599]	1809	$data['contact_list'] = $contact_options;
	1810	$data['result'] = 'ok';
[285]	1811	echo serialize($data);
	1812	}
	1813
[2]	1814	/*!
[1599]	1815
[2]	1816	@function get_full_data
	1817	@abstract Returns all the information of a given Entry
	1818	@author Raphael Derosso Pereira
[1599]	1819
[2]	1820	@param (integer) $id The id to get information
[1599]	1821
[2]	1822	*/
[1599]	1823	/rev 104/
	1824	//function get_full_data($id)
[503]	1825	function get_full_data($id,$catalog='bo_people_catalog')
[2]	1826	{
	1827	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
[1599]	1828	/rev 104/
	1829	//$this->bo->catalog = CreateObject('contactcenter.bo_people_catalog');
	1830	$this->bo->catalog = CreateObject('contactcenter.'.$catalog);
	1831	/****/
[2]	1832	$fields = $this->bo->catalog->get_fields(true);
	1833	$fields['photo'] = false;
	1834	$entry = $this->bo->catalog->get_single_entry($id,$fields);
	1835
	1836	if (is_bool($entry['given_names']))
	1837	{
	1838	$data['result'] = 'false';
	1839	echo serialize($data);
	1840	return;
	1841	}
	1842
	1843	$date = explode('-', $entry['birthdate']);
	1844	$j = 0;
	1845	for ($i = 0; $i < 5; $i+=2)
	1846	{
	1847	switch($dateformat{$i})
	1848	{
	1849	case 'Y':
	1850	$birthdate[$j] = $date[0];
	1851	break;
	1852
	1853	case 'm':
	1854	case 'M':
	1855	$birthdate[$j] = $date[1];
	1856	break;
	1857
	1858	case 'd':
	1859	$birthdate[$j] = $date[2];
	1860	}
[7655]	1861	++$j;
[2]	1862	}
	1863	$datecount = 0;
[1599]	1864
[2]	1865	$data['result'] = 'ok';
	1866	$data['cc_full_add_contact_id'] = $id;
	1867
	1868	/* Personal Data */
	1869	$data['personal']['cc_pd_photo'] = '../index.php?menuaction=contactcenter.ui_data.data_manager&method=get_photo&id='.$id;
	1870	$data['personal']['cc_pd_alias'] = $entry['alias'];
	1871	$data['personal']['cc_pd_given_names'] = $entry['given_names'];
	1872	$data['personal']['cc_pd_family_names'] = $entry['family_names'];
	1873	$data['personal']['cc_pd_full_name'] = $entry['names_ordered'];
	1874	$data['personal']['cc_pd_suffix'] = $entry['id_suffix'];
	1875	$data['personal']['cc_pd_birthdate_0'] = $birthdate[0];
	1876	$data['personal']['cc_pd_birthdate_1'] = $birthdate[1];
	1877	$data['personal']['cc_pd_birthdate_2'] = $birthdate[2];
	1878	//$data['personal']['cc_pd_sex'] = $entry['sex'] === 'M' ? 1 : ($entry['sex'] === 'F' ? 2 : 0);
	1879	$data['personal']['cc_pd_prefix'] = $entry['id_prefix'];
	1880	$data['personal']['cc_pd_gpg_finger_print'] = $entry['pgp_key'];
	1881	$data['personal']['cc_pd_notes'] = $entry['notes'];
	1882
	1883	/* Addresses */
	1884	if (is_array($entry['addresses']))
	1885	{
	1886	$data['addresses'] = $entry['addresses'];
	1887	}
	1888
	1889	/* Connections */
	1890	if (is_array($entry['connections']))
	1891	{
	1892	$data['connections'] = array();
	1893	foreach ($entry['connections'] as $connection)
	1894	{
	1895	$type = $connection['id_type'];
	1896	$i = count($data['connections'][$type]);
	1897	$data['connections'][$type][$i]['id'] = $connection['id_connection'];
	1898	$data['connections'][$type][$i]['name'] = $connection['connection_name'];
	1899	$data['connections'][$type][$i]['value'] = $connection['connection_value'];
	1900	$data['connections'][$type][$i]['is_default'] = $connection['connection_is_default'];
	1901	}
	1902	}
[1599]	1903	// print_r($data);
	1904	//OBSERVAR cc_department
[1517]	1905	/Corporative/
[1656]	1906	if($GLOBALS['phpgw_info']['server']['personal_contact_type']=='True'){
	1907	$data['personal']['cc_job_title'] = $entry['job_title'];
	1908	$data['personal']['cc_department'] = $entry['department'];
	1909	$data['personal']['cc_name_corporate'] = $entry['corporate_name'];
	1910	$data['personal']['cc_web_page'] = $entry['web_page'];
	1911	}
	1912
[1599]	1913
	1914
[2]	1915	/* Relations */
[5131]	1916	/* Groups */
	1917	/*
	1918	* Criado uma estrutura no data que conterá os grupos do
	1919	* contato. O formato é:
	1920	* data['groups'] = array(
	1921	* 'id_group' => array(
	1922	* 'id_group', 'title', 'short_name'
	1923	* )
	1924	* );
	1925	*/
	1926	$boGroup = CreateObject('contactcenter.bo_group');
	1927	$groups = $boGroup->get_contact_groups($id);
	1928
	1929	$i = 0;
	1930	$data['groups'] = array();
	1931	if(is_array($groups))
	1932	foreach($groups as $group)
	1933	{
	1934	$idGroup = $group['id_group'];
	1935	$data['groups'][$idGroup] = array(
	1936	'title' => $group['title'],
	1937	'id_group' => $idGroup,
	1938	'short_name' => $group['short_name']
	1939	);
[7655]	1940	++$i;
[5131]	1941	}
[4753]	1942
[2]	1943	echo serialize($data);
	1944	}
	1945
	1946	/*!
	1947
	1948	@function get_contact_full_add_const
	1949	@abstract Returns all the constant fields in Contact Full Add Window to the JS
	1950	@author Raphael Derosso Pereira
	1951	*/
	1952	function get_contact_full_add_const()
	1953	{
	1954	$data = array();
	1955	$boPeopleCatalog = CreateObject('contactcenter.bo_people_catalog');
	1956	$predata[] = $boPeopleCatalog -> get_all_prefixes();
	1957	$predata[] = $boPeopleCatalog -> get_all_suffixes();
	1958	$predata[] = $boPeopleCatalog -> get_all_addresses_types();
	1959	$predata[] = $boPeopleCatalog -> get_all_countries();
	1960	$predata[] = $boPeopleCatalog -> get_all_connections_types();
[5131]	1961	$boGroup = CreateObject('contactcenter.bo_group');
	1962	//$predata[] = $boGroup->get_groups_by_user();
[4753]	1963	//$predata[] = $this->bo->catalog->get_all_relations_types();
[2]	1964
[5131]	1965	if ($this->typeContact == 'shared_contacts') {
	1966	$so_contact = CreateObject('contactcenter.so_contact', $GLOBALS['phpgw_info']['user']['account_id']);
	1967	$relacionados = $so_contact->get_relations();
	1968
	1969	foreach($relacionados as $uid_relacionado => $tipo_relacionamento) {
	1970	$predata[] = $boGroup->get_groups_by_user($uid_relacionado);
	1971	}
	1972	} else {
	1973	$predata[] = $boGroup->get_groups_by_user();
	1974	}
	1975
	1976
[2]	1977	$i = 0;
	1978	foreach($predata as $data_)
	1979	{
	1980	if ($data_)
	1981	{
	1982	$data[$i] = $data_;
	1983	}
	1984
[7655]	1985	++$i;
[2]	1986	}
	1987
	1988	if (count($data))
	1989	{
	1990	echo serialize($data);
	1991	return;
	1992	}
[1599]	1993
[2]	1994	echo 0;
	1995	}
[1599]	1996
[2]	1997	/*!
[1599]	1998
[2]	1999	@function quick_add
	2000	@abstract Adds a new Contact using the Quick Add interface
	2001	@author Raphael Derosso Pereira
[1599]	2002
[2]	2003	@param string $sdata Serialized data
	2004	*/
[3970]	2005	function quick_add($sdata, $echo=true)
[2]	2006	{
[1599]	2007
[2]	2008	$sdata = str_replace('\\"', '"', $sdata);
	2009	$new_array = unserialize($sdata);
	2010	$tdata = array();
[1599]	2011
[2]	2012	foreach($new_array as $tmp)
	2013	$tdata[] = $tmp;
[1599]	2014
[2]	2015	if (!$tdata)
	2016	{
[3970]	2017	if ($echo)
	2018	{
[2]	2019	echo serialize(array(
	2020	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
	2021	'status' => 'abort'
	2022	));
[3970]	2023
[2]	2024	return;
[3970]	2025	}
	2026	else
	2027	{
	2028	return serialize(array(
	2029	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
	2030	'status' => 'abort'
	2031	));
	2032	}
[2]	2033	}
[3239]	2034	$data['alias'] = addslashes($tdata[0]);
	2035	$data['given_names'] = addslashes($tdata[1]);
	2036	$data['family_names'] = addslashes($tdata[2]);
[2]	2037	$data['connections']['default_phone']['connection_name'] = lang('Main');
	2038	$data['connections']['default_phone']['connection_value'] = $tdata[3];
	2039	$data['connections']['default_email']['connection_name'] = lang('Main');
	2040	$data['connections']['default_email']['connection_value'] = $tdata[4];
[3660]	2041	$data['is_quick_add'] = true;
[2]	2042	$boPeople = CreateObject('contactcenter.bo_people_catalog');
	2043
[3970]	2044	$result = $boPeople->quick_add($data);
	2045	if ($result)
[1599]	2046	{
[3970]	2047	$this->page_info['changed'] = true;
[1599]	2048
[3970]	2049	if ($echo)
	2050	{
	2051	echo serialize(array(
	2052	'msg' => lang('Entry added with success!'),
	2053	'status' => 'ok'
	2054	));
	2055	}
	2056	else
	2057	{
	2058	return serialize(array(
	2059	'msg' => lang('Entry added with success!'),
	2060	'status' => 'ok',
	2061	'conn' => $boPeople->get_connections($result)
	2062	));
	2063	}
[2]	2064	}
	2065	else
	2066	{
[3970]	2067	if ($echo)
	2068	{
	2069	echo serialize(array(
	2070	'msg' => lang('Problems on adding your Contact. No Contact added!'),
	2071	'status' => 'error'
	2072	));
	2073	}
	2074	else
	2075	{
	2076	echo serialize(array(
	2077	'msg' => lang('Problems on adding your Contact. No Contact added!'),
	2078	'status' => 'error'
	2079	));
	2080	}
[2]	2081	}
	2082
[1599]	2083	$this->save_session();
	2084
[2]	2085	}
	2086
	2087	/*!
[1599]	2088
[2]	2089	@function add_group
	2090	@abstract Adds a new Group using the Add Group interface
	2091	@author Nilton Emilio Buhrer Neto
[1599]	2092
[2]	2093	@param string $sdata Serialized data
	2094	*/
	2095	function add_group($sdata)
	2096	{
	2097	$sdata = str_replace('\\"', '"', $sdata);
	2098	$tdata = unserialize($sdata);
	2099	$new_tdata = array();
[1599]	2100
[2]	2101	if (!$tdata)
	2102	{
	2103	echo serialize(array(
	2104	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
	2105	'status' => 'abort'
	2106	));
[1599]	2107
[2]	2108	return;
	2109	}
[1599]	2110
[2]	2111	foreach($tdata as $tmp)
	2112	$new_tdata[] = $tmp;
[1599]	2113
	2114	$data['title'] = $new_tdata[0];
[2]	2115	$data['contact_in_list'] = $new_tdata[1];
	2116	$data['id_group'] = $new_tdata[2];
[3970]	2117	$acumulatedErrors = '';
[1599]	2118
[3970]	2119	$actualCatalog = $this->get_actual_catalog();
[7673]	2120	$data_count = count($data['contact_in_list']);
	2121	for ($i = 0; $i < $data_count; ++$i)
[3970]	2122	{
	2123	if (preg_match('/ldap:.:./', $data['contact_in_list'][$i])) // from ldap
	2124	{
	2125	list(, $level, $dn) = explode(':', $data['contact_in_list'][$i]);
	2126
	2127	// pesquisa os dados, insere no catálogo e modifica
	2128	// a entrada em $data['contact_in_list'][$i]
	2129	$set_catalog = $this->set_catalog($level, false);
[5158]	2130	$contact_data = unserialize($this->get_catalog_add_contact(utf8_encode($dn), false));
[3970]	2131	$tmp_contact[] = $contact_data[0][0];
	2132	$tmp_contact[] = $contact_data[1][0];
	2133	$tmp_contact[] = $contact_data[2][0];
	2134	$tmp_contact[] = $contact_data[3][0];
	2135	$tmp_contact[] = $contact_data[4][0];
	2136
	2137	// Determinar o id_connection
	2138	$id_contact = unserialize($this->quick_add(serialize($tmp_contact), false));
	2139
	2140	switch ($id_contact['status'])
	2141	{
	2142	case 'ok' :
	2143	foreach ($id_contact['conn'] as $connection)
	2144	{
	2145	if ($connection['id_type'] == 1)
	2146	{
	2147	$data['contact_in_list'][$i] = $connection['id_connection'];
	2148	}
	2149	}
	2150	break;
	2151
	2152	case 'alreadyExists': // if e-mail exists get their id_connection from people_catalog
	2153	$data['contact_in_list'][$i] = $id_contact['id_connection'];
	2154
	2155	default:
	2156	$acumulatedErrors += $id_contact['msg']."\n";
	2157	}
	2158	unset($tmp_contact);
	2159
	2160	}
	2161	}
	2162	$set_catalog = $this->set_catalog($actualCatalog['data'], false); // retorna ao catálogo original.
[2]	2163	$boGroup = CreateObject('contactcenter.bo_group_manager');
	2164	$id = $boGroup -> add_group($data);
[1599]	2165
[2]	2166	if ($id)
	2167	{
	2168	$this->page_info['changed'] = true;
[4753]	2169
	2170	echo serialize(array(
	2171	'msg' => lang('Entry added with success!'),
	2172	'status' => 'ok'
	2173	));
[2]	2174	}
	2175	else
	2176	{
	2177	echo serialize(array(
[4753]	2178	'msg' => lang("Problems on adding your Group. Be sure that a group with this name do not exists").
	2179	"\n".$acumulatedErrors,
[2]	2180	'status' => 'error'
	2181	));
	2182	}
	2183
	2184	$this->save_session();
	2185	}
	2186
	2187	/*!
[1599]	2188
[2]	2189	@function remove_group
	2190	@abstract Removes a group if the user has the right to do it
[1599]	2191	@author Nilton Emilio Buhrer Neto
[2]	2192	@param (integer) $id The id to be removed
[1599]	2193
[2]	2194	*/
	2195	function remove_group($id)
[1599]	2196	{
	2197	$soGroup = CreateObject('contactcenter.so_group');
[2]	2198	$data = array ('id_group' => $id);
	2199	if($soGroup -> delete($data)) {
	2200	echo serialize(array(
	2201	'msg' => lang('Removed Entry ID '.$id.'!'),
	2202	'status' => 'ok'
[1599]	2203	));
[2]	2204	}
	2205	else {
	2206	echo serialize(array(
[4753]	2207	'msg' => lang("Could\'nt remove group with id: %1", $id),
[2]	2208	'status' => 'error'
	2209	));
	2210	}
	2211
[1599]	2212	$this->save_session();
[2]	2213	}
	2214
	2215
	2216	function remove_all_entries (){
[1599]	2217
[2]	2218	$error = false;
	2219	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
	2220
	2221	foreach($this->all_entries as $index => $id) {
	2222	$result = $this->bo->catalog->remove_single_entry($id);
	2223	if(!$result) {
	2224	$error = true;
[1599]	2225	break;
[2]	2226	}
	2227	}
	2228
	2229	if(!$error) {
	2230	echo serialize(array(
	2231	'msg' => lang('Removed Entry ID '.$id.'!'),
	2232	'status' => 'ok'
	2233	));
[1599]	2234	}
[2]	2235	else {
	2236	echo serialize(array(
	2237	'msg' => lang('Couldn\'t remove this entry. Inform the Site Admin!'),
	2238	'status' => 'fail'
	2239	));
	2240	}
	2241
	2242	$this->save_session();
	2243	}
	2244
	2245	/*!
[1599]	2246
[2]	2247	@function remove_entry
	2248	@abstract Removes an entry if the user has the right to do it
	2249	@author Raphael Derosso Pereira
[1599]	2250
[2]	2251	@param (integer) $id The id to be removed
[1599]	2252
[2]	2253	*/
	2254	function remove_entry ($id)
	2255	{
	2256	if (!is_int($id))
	2257	{
	2258	echo lang('Couldn\'t remove entry! Problem passing data to the server. Please inform admin!');
	2259	return;
	2260	}
[1599]	2261
[2]	2262	$this->page_info['changed'] = true;
	2263	$result = $this->bo->catalog->remove_single_entry($id);
[1599]	2264
[2]	2265	if ($result)
	2266	{
	2267	if ($pos = array_search($id, $this->page_info['actual_entries']))
	2268	{
	2269	unset($this->page_info['actual_entries'][$pos]);
	2270	}
[1599]	2271
[2]	2272	$temp = false;
	2273	reset($this->page_info['actual_entries']);
	2274	foreach($this->page_info['actual_entries'] as $t)
	2275	{
	2276	$temp[] = $t;
	2277	}
[1599]	2278
[2]	2279	$this->page_info['actual_entries'] = $temp;
	2280
	2281	echo serialize(array(
	2282	'msg' => lang('Removed Entry ID '.$id.'!'),
	2283	'status' => 'ok'
	2284	));
	2285	}
	2286	else
	2287	{
	2288	echo serialize(array(
	2289	'msg' => lang('Couldn\'t remove this entry. Inform the Site Admin!'),
	2290	'status' => 'fail'
	2291	));
	2292	}
[1599]	2293
[2]	2294	$this->save_session();
	2295	}
	2296
[1599]	2297
[2]	2298	/*!
[1599]	2299
[2]	2300	@function post_full_add
	2301	@abstract Saves all the information altered/entered in the Full Add
	2302	window
	2303	@author Raphael Derosso Pereira
	2304
	2305	*/
	2306	function post_full_add()
	2307	{
[285]	2308	$data = $_POST['data'];
[1599]	2309	// Exceptions!!! utf8 special chars.
[285]	2310	$data = preg_replace("/\%u2(\d+)(\d+)(\d+)/","-",$data);
	2311	$data = unserialize(str_replace('\\"', '"', $data));
[2]	2312	$this -> bo -> catalog = CreateObject('contactcenter.bo_people_catalog');
	2313
	2314	if (!is_array($data))
	2315	{
	2316	echo serialize(array(
	2317	'msg' => lang('<p>Some problem receiving data from browser. This is probably a bug in ContactCenter<br>'.
	2318	'Please go to eGroupWare Bug Reporting page and report this bug.<br>'.
	2319	'Sorry for the inconvenient!<br><br>'.
	2320	'<b><i>ContactCenter Developer Team</i></b></p>'),
	2321	'status' => 'fatal'
	2322	));
	2323	return;
	2324	}
	2325	// print_r($data);
	2326	// echo '<br><br>';
	2327
	2328	$replacer = $data['commercialAnd'];
	2329	unset($data['commercialAnd']);
	2330	if (!is_string($replacer) or strpos($replacer, "'") or strpos($replacer, '"'))
	2331	{
	2332	echo serialize(array(
	2333	'msg' => lang('Invalid \'&\' replacer! This may be an attempt to bypass Security! Action aborted!'),
	2334	'status' => 'fatal'
	2335	));
[1599]	2336
[2]	2337	return;
	2338	}
	2339
	2340	if ($data['id_contact'])
	2341	{
	2342	$id = $data['id_contact'];
	2343	$id_photo = $id;
	2344	unset($data['id_contact']);
	2345	}
	2346	else
	2347	{
	2348	$id_photo = '_new_';
	2349	}
[1599]	2350
	2351	/*
	2352	* Process Photo, if available
[2]	2353	*/
	2354	$sleep_count = 0;
	2355	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
	2356	while($photo_ok[0]{0} !== 'o' and $photo_ok[1]{0} === 'y')
	2357	{
	2358	sleep(1);
	2359	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
[7655]	2360	++$sleep_count;
[2]	2361
	2362	if ($sleep_count > 35)
	2363	{
	2364	// TODO
	2365	return;
	2366	}
	2367	}
	2368	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'n'));
[1599]	2369
[2]	2370	if (isset($this->page_info['photos'][$id_photo]))
	2371	{
	2372	if (array_search($this->page_info['photos'][$id_photo]['status'], array('changed', 'sync')) === false)
	2373	{
	2374	echo serialize(array(
	2375	'msg' => $this->page_info['photos'][$id_photo]['msg'],
	2376	'status' => $this->page_info['photos'][$id_photo]['status']
	2377	));
	2378
	2379	return;
	2380	}
	2381
	2382	$data['photo'] = $this->page_info['photos'][$id_photo]['content'];
	2383	unset($this->page_info['photos'][$id_photo]);
	2384	$this->save_session();
	2385	}
[1599]	2386
[2]	2387	/*
	2388	* Arrange Date so it gets inserted correctly
	2389	*/
[1599]	2390
[2]	2391	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
[1599]	2392
[2]	2393	$j = 0;
	2394	for ($i = 0; $i < 5; $i+=2)
	2395	{
	2396	switch($dateformat{$i})
	2397	{
	2398	case 'Y':
	2399	$date[$j]['size'] = 4;
	2400	$date[$j]['digit'] = 'Y';
	2401	break;
	2402
	2403	case 'm':
	2404	case 'M':
	2405	$date[$j]['size'] = 2;
	2406	$date[$j]['digit'] = 'M';
	2407	break;
	2408
	2409	case 'd':
	2410	$date[$j]['size'] = 2;
	2411	$date[$j]['digit'] = 'D';
	2412	}
[7655]	2413	++$j;
[2]	2414	}
	2415	$datecount = 0;
	2416
	2417	/* Verify Data and performs insertion/update */
[3018]	2418	foreach($data as $field => $value)
[2]	2419	{
[4754]	2420	$dataConn = $data['connections'];
	2421	$aa = count($dataConn);
[1599]	2422
[7655]	2423	for($i = 0; $i < $aa; ++$i )
[4754]	2424	{
	2425	if($dataConn['connection'.$i]['connection_is_default'] == "TRUE")
	2426	{
	2427	$email = $dataConn['connection'.$i]['connection_value'];
	2428	}
	2429	}
	2430
[2]	2431	switch($field)
	2432	{
[3018]	2433	case 'names_ordered':
[3247]	2434	$data[$field] = addslashes(rawurldecode($value));
[1517]	2435	case 'corporate_name':
	2436	case 'job_title':
	2437	case 'department':
	2438	case 'web_page':
[2]	2439	case 'alias':
	2440	case 'given_names':
	2441	case 'family_names':
	2442	case 'pgp_key':
	2443	case 'notes':
[3247]	2444	$data[$field] = addslashes(rawurldecode($data[$field]));
[2]	2445	break;
[1599]	2446
[2]	2447	case 'id_status':
	2448	case 'id_prefix':
	2449	case 'id_suffix':
	2450	if ($data[$field] == 0)
	2451	{
	2452	unset($data[$field]);
	2453	}
	2454	break;
[1599]	2455
[2]	2456	case 'birthdate_0':
	2457	case 'birthdate_1':
	2458	case 'birthdate_2':
[3310]	2459	case 'birthdate':
	2460
	2461	if($field == 'birthdate'){
	2462	$array_birth = explode("/",$data[$field]);
	2463	$date['value'][2] = $array_birth[2];
	2464	$date['value'][1] = $array_birth[1];
	2465	$date['value'][0] = $array_birth[0];
	2466	}else{
	2467	switch($date[$datecount]['digit'])
	2468	{
	2469	case 'Y':
	2470	$date['value'][2] = (int) $data[$field];
	2471	break;
	2472
	2473	case 'M':
	2474	$date['value'][0] = (int) $data[$field];
	2475	break;
	2476
	2477	case 'D':
	2478	$date['value'][1] = (int) $data[$field];
	2479	break;
	2480	}
	2481	unset($data[$field]);
[2]	2482	}
	2483
[7655]	2484	++$datecount;
	2485
[2]	2486	if ($datecount != 3)
	2487	{
	2488	break;
	2489	}
[1599]	2490
[3310]	2491	if($date['value'][0] =='' && $date['value'][1] =='' && $date['value'][2] ==''){
	2492	$data['birthdate'] = null;
	2493	break;
	2494	}
[2]	2495	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
	2496	{
	2497	echo serialize(array(
	2498	'msg' => lang('Invalid Date'),
	2499	'status' => 'invalid_data'
	2500	));
	2501	return;
	2502	}
[3310]	2503	if( $date['value'][2] != "" && $date['value'][0] != "" && $date['value'][1] != ""){
	2504	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
	2505	}
[2]	2506	break;
	2507
	2508	case 'sex':
	2509	if ($data[$field] !== 'M' and $data[$field] !== 'F')
	2510	{
	2511	echo serialize(array(
	2512	'msg' => lang('Invalid Sex'),
	2513	'status' => 'invalid_data'
	2514	));
	2515	return;
	2516	}
	2517	break;
	2518
	2519
	2520	case 'addresses':
	2521	/* Insert new cities/states */
	2522	if (isset($value['new_states']))
	2523	{
	2524	foreach($value['new_states'] as $type => $state_info)
	2525	{
	2526	$index = 'address'.$type;
[1599]	2527
[2]	2528	$id_state = $this->bo->catalog->add_state($state_info);
	2529	$data['addresses'][$index]['id_state'] = $id_state;
	2530
	2531	if ($value['new_cities'][$type])
	2532	{
[3018]	2533	$data[$field]['new_cities'][$type]['id_state'] = $id_state;
[2]	2534	}
	2535	}
	2536
	2537	unset($data['addresses']['new_states']);
	2538	}
	2539
	2540	if (isset($value['new_cities']))
	2541	{
	2542	foreach($value['new_cities'] as $type => $city_info)
	2543	{
	2544	$index = 'address'.$type;
[1599]	2545
[2]	2546	$id_city = $this->bo->catalog->add_city($city_info);
	2547	$data['addresses'][$index]['id_city'] = $id_city;
	2548	}
	2549
	2550	unset($data['addresses']['new_cities']);
	2551	}
	2552
	2553	break;
	2554
[3198]	2555	case 'birthdate':
[2]	2556	case 'connections':
[1687]	2557	case 'photo':
[2]	2558	/* Does nothing... */
	2559	break;
[5131]	2560	case 'groups':
	2561	$groups = $data['groups'];
	2562	unset($data['groups']);
	2563	break;
[2]	2564	default:
	2565	echo serialize(array(
	2566	'msg' => lang('Invalid field: ').$field,
	2567	'status' => 'invalid_data'
	2568	));
	2569	return;
	2570	}
	2571	}
	2572
	2573	if (!is_null($id) and $id !== '')
	2574	{
[4753]	2575	$id = $this->bo->catalog->update_single_info($id, $data);
[2]	2576	$result = array(
	2577	'msg' => lang('Updated Successfully!'),
	2578	'status' => 'ok'
	2579	);
	2580	}
	2581	else
	2582	{
[3018]	2583	$id = $this->bo->catalog->add_single_entry($data);
[2]	2584	$result = array(
	2585	'msg' => lang('Entry Added Successfully!'),
	2586	'status' => 'ok'
	2587	);
	2588	}
[1599]	2589
[2]	2590	if (!($id))
	2591	{
	2592	$result = array(
	2593	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
	2594	'Report the problem to the Administrator.'),
	2595	'status' => 'fail'
	2596	);
	2597	}
[5131]	2598	else
	2599	{
	2600	if (isset($old_connections))
	2601	$this->bo->catalog->update_contact_groups($id, $groups, $old_connections);
	2602	else
	2603	$this->bo->catalog->update_contact_groups($id, $groups);
	2604	}
[2]	2605
	2606	echo serialize($result);
	2607	}
	2608
[1496]	2609
	2610	function post_full_add_shared()
	2611	{
	2612	$data = $_POST['data'];
[1599]	2613	// Exceptions!!! utf8 special chars.
[1496]	2614	$data = preg_replace("/\%u2(\d+)(\d+)(\d+)/","-",$data);
	2615	$data = unserialize(str_replace('\\"', '"', $data));
	2616	$this -> bo -> catalog = CreateObject('contactcenter.bo_shared_people_manager');
	2617
	2618	if (!is_array($data))
	2619	{
	2620	echo serialize(array(
	2621	'msg' => lang('<p>Some problem receiving data from browser. This is probably a bug in ContactCenter<br>'.
	2622	'Please go to eGroupWare Bug Reporting page and report this bug.<br>'.
	2623	'Sorry for the inconvenient!<br><br>'.
	2624	'<b><i>ContactCenter Developer Team</i></b></p>'),
	2625	'status' => 'fatal'
	2626	));
	2627	return;
	2628	}
	2629	// print_r($data);
	2630	// echo '<br><br>';
	2631
	2632	$replacer = $data['commercialAnd'];
	2633	unset($data['commercialAnd']);
	2634	if (!is_string($replacer) or strpos($replacer, "'") or strpos($replacer, '"'))
	2635	{
	2636	echo serialize(array(
	2637	'msg' => lang('Invalid \'&\' replacer! This may be an attempt to bypass Security! Action aborted!'),
	2638	'status' => 'fatal'
	2639	));
[1599]	2640
[1496]	2641	return;
	2642	}
	2643
	2644	if ($data['id_contact'])
	2645	{
	2646	$id = $data['id_contact'];
	2647	$id_photo = $id;
	2648	unset($data['id_contact']);
	2649	}
	2650	else
	2651	{
	2652	$id_photo = '_new_';
	2653	}
	2654
	2655	if ($data['owner'])
	2656	{
	2657	$owner = $data['owner'];
	2658	unset($data['owner']);
	2659	}
[1599]	2660	/*
	2661	* Process Photo, if available
[1496]	2662	*/
	2663	$sleep_count = 0;
	2664	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
	2665	while($photo_ok[0]{0} !== 'o' and $photo_ok[1]{0} === 'y')
	2666	{
	2667	sleep(1);
	2668	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
[7655]	2669	++$sleep_count;
[1496]	2670
	2671	if ($sleep_count > 35)
	2672	{
	2673	// TODO
	2674	return;
	2675	}
	2676	}
	2677	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'n'));
[1599]	2678
[1496]	2679	if (isset($this->page_info['photos'][$id_photo]))
	2680	{
	2681	if (array_search($this->page_info['photos'][$id_photo]['status'], array('changed', 'sync')) === false)
	2682	{
	2683	echo serialize(array(
	2684	'msg' => $this->page_info['photos'][$id_photo]['msg'],
	2685	'status' => $this->page_info['photos'][$id_photo]['status']
	2686	));
	2687
	2688	return;
	2689	}
	2690
	2691	$data['photo'] = $this->page_info['photos'][$id_photo]['content'];
	2692	unset($this->page_info['photos'][$id_photo]);
	2693	$this->save_session();
	2694	}
[1599]	2695
[1496]	2696	/*
	2697	* Arrange Date so it gets inserted correctly
	2698	*/
[1599]	2699
[1496]	2700	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
[1599]	2701
[1496]	2702	$j = 0;
	2703	for ($i = 0; $i < 5; $i+=2)
	2704	{
	2705	switch($dateformat{$i})
	2706	{
	2707	case 'Y':
	2708	$date[$j]['size'] = 4;
	2709	$date[$j]['digit'] = 'Y';
	2710	break;
	2711
	2712	case 'm':
	2713	case 'M':
	2714	$date[$j]['size'] = 2;
	2715	$date[$j]['digit'] = 'M';
	2716	break;
	2717
	2718	case 'd':
	2719	$date[$j]['size'] = 2;
	2720	$date[$j]['digit'] = 'D';
	2721	}
[7655]	2722	++$j;
[1496]	2723	}
	2724	$datecount = 0;
	2725
	2726	/* Verify Data and performs insertion/update */
	2727	foreach($data as $field => &$value)
	2728	{
[4754]	2729
	2730	$dataConn = $data['connections'];
	2731	$aa = count($dataConn);
	2732
[7655]	2733	for($i = 0; $i < $aa; ++$i )
[4754]	2734	{
	2735	if($dataConn['connection'.$i]['connection_is_default'] == "TRUE")
	2736	{
	2737	$email = $dataConn['connection'.$i]['connection_value'];
	2738	}
	2739	}
	2740
[1496]	2741	if ($value == '' or is_null($value))
	2742	{
	2743	unset($data[$field]);
	2744	continue;
	2745	}
[1599]	2746
[1496]	2747	switch($field)
	2748	{
[3341]	2749	case 'corporate_name':
	2750	case 'job_title':
	2751	case 'department':
	2752	case 'web_page':
[1496]	2753	case 'alias':
	2754	case 'given_names':
	2755	case 'family_names':
[4717]	2756	case 'groups':
	2757	$groups = $data['groups'];
	2758	unset($data['groups']);
	2759	break;
[1496]	2760	case 'names_ordered':
	2761	case 'pgp_key':
	2762	case 'notes':
	2763	case 'photo':
[3018]	2764	$data[$field] = urldecode( $value );
[1496]	2765	break;
[1599]	2766
[1496]	2767	case 'id_status':
	2768	case 'id_prefix':
	2769	case 'id_suffix':
	2770	if ($data[$field] == 0)
	2771	{
	2772	unset($data[$field]);
	2773	}
	2774	break;
[1599]	2775
[1496]	2776	case 'birthdate_0':
	2777	case 'birthdate_1':
	2778	case 'birthdate_2':
[1599]	2779
[1496]	2780	switch($date[$datecount]['digit'])
	2781	{
	2782	case 'Y':
	2783	$date['value'][2] = (int) $data[$field];
	2784	break;
	2785
	2786	case 'M':
	2787	$date['value'][0] = (int) $data[$field];
	2788	break;
	2789
	2790	case 'D':
	2791	$date['value'][1] = (int) $data[$field];
	2792	break;
	2793	}
	2794	unset($data[$field]);
[7655]	2795	++$datecount;
[1496]	2796
	2797	if ($datecount != 3)
	2798	{
	2799	break;
	2800	}
[1599]	2801
[1496]	2802	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
	2803	{
	2804	echo serialize(array(
	2805	'msg' => lang('Invalid Date'),
	2806	'status' => 'invalid_data'
	2807	));
	2808	return;
	2809	}
[1599]	2810
[1496]	2811	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
	2812	break;
	2813
	2814	case 'sex':
	2815	if ($data[$field] !== 'M' and $data[$field] !== 'F')
	2816	{
	2817	echo serialize(array(
	2818	'msg' => lang('Invalid Sex'),
	2819	'status' => 'invalid_data'
	2820	));
	2821	return;
	2822	}
	2823	break;
	2824
	2825
	2826	case 'addresses':
	2827	/* Insert new cities/states */
	2828	if (isset($value['new_states']))
	2829	{
	2830	foreach($value['new_states'] as $type => $state_info)
	2831	{
	2832	$index = 'address'.$type;
[1599]	2833
[1496]	2834	$id_state = $this->bo->catalog->add_state($state_info);
	2835	$data['addresses'][$index]['id_state'] = $id_state;
	2836
	2837	if ($value['new_cities'][$type])
	2838	{
	2839	$value['new_cities'][$type]['id_state'] = $id_state;
	2840	}
	2841	}
	2842
	2843	unset($data['addresses']['new_states']);
	2844	}
	2845
	2846	if (isset($value['new_cities']))
	2847	{
	2848	foreach($value['new_cities'] as $type => $city_info)
	2849	{
	2850	$index = 'address'.$type;
[1599]	2851
[1496]	2852	$id_city = $this->bo->catalog->add_city($city_info);
	2853	$data['addresses'][$index]['id_city'] = $id_city;
	2854	}
	2855
	2856	unset($data['addresses']['new_cities']);
	2857	}
	2858
	2859	break;
	2860
	2861	case 'connections':
	2862	/* Does nothing... */
[4754]	2863	$aaaa = 1111;
[1496]	2864	break;
	2865
	2866	default:
	2867	echo serialize(array(
	2868	'msg' => lang('Invalid field: ').$field,
	2869	'status' => 'invalid_data'
	2870	));
	2871	return;
	2872	}
	2873	}
	2874
[5131]	2875	//$code = '$id = $this->bo->catalog->';
[1496]	2876
	2877	if (!is_null($id) and $id !== '')
	2878	{
[5131]	2879	//$code .= $code.'update_single_info($id, $data);';
	2880	$id = $this->bo->catalog->update_single_info($id, $data);
	2881	if(!$id){
[1496]	2882	$result = array(
[5131]	2883	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
	2884	'Report the problem to the Administrator.'),
	2885	'status' => 'fail'
[1496]	2886	);
	2887	}
[5131]	2888	else{
[1496]	2889	$result = array(
[5131]	2890	'msg' => lang('Updated Successfully!'),
[1496]	2891	'status' => 'ok'
	2892	);
	2893	}
[5131]	2894	}
	2895	else
[1496]	2896	{
[5131]	2897	//$code .= 'add_single_entry($data,'.$owner.');';
	2898	$id = $this->bo->catalog->add_single_entry($data,$owner);
	2899	if(!$id){
[1496]	2900	$result = array(
	2901	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
	2902	'Report the problem to the Administrator.'),
	2903	'status' => 'fail'
	2904	);
	2905	}
[5131]	2906	else{
	2907	$result = array(
	2908	'msg' => lang('Entry Added Successfully!'),
	2909	'status' => 'ok'
	2910	);
	2911	}
	2912	}
[1496]	2913	echo serialize($result);
[5131]	2914	}
[2]	2915	/*!
[1599]	2916
[2]	2917	@function post_photo
	2918	@abstract Wrapper to post a photo without reload a page.
	2919	@author Raphael Derosso Pereira
	2920
	2921	*/
	2922	function post_photo($id)
	2923	{
	2924	//print_r($_FILES);
	2925	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'y'));
[1599]	2926
[2]	2927	if (!is_array($_FILES) and is_array(!$_FILES['cc_pd_photo']))
	2928	{
	2929	$this->page_info['photos'][$id]['status'] = 'no_upload';
	2930	$this->page_info['photos'][$id]['msg'] = lang('No Photos uploaded to Server.');
[1599]	2931
[2]	2932	$this->save_session();
	2933	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2934	return;
	2935	}
	2936
	2937	if (!function_exists('imagecreate'))
	2938	{
	2939	$this->page_info['photos'][$id]['status'] = 'no_GD_lib';
	2940	$this->page_info['photos'][$id]['msg'] = lang('Cannot manipulate Image. No Image added. Please, if you want to use images, ask the Administrator to install GD library.');
[1599]	2941
[2]	2942	$this->save_session();
	2943	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2944	return;
	2945	}
	2946
	2947	// TODO: Get Max Size from preferences!
	2948	if ($_FILES['cc_pd_photo']['size'] > 1000000)
	2949	{
	2950	$this->page_info['photos'][$id]['status'] = 'too_large';
	2951	$this->page_info['photos'][$id]['msg'] = lang('Image too large! ContactCenter limits the image size to 1 Mb');
	2952
	2953	$this->save_session();
	2954	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2955	return;
	2956	}
	2957
	2958	if ($_FILES['cc_pd_photo']['error'])
	2959	{
	2960	$this->page_info['photos'][$id]['status'] = 'error';
	2961	$this->page_info['photos'][$id]['msg'] = lang('Some Error occured while processed the Image. Contact the Administrator. The error code was: ').$_FILES['cc_pd_photo']['error'];
	2962
	2963	$this->save_session();
	2964	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2965	return;
	2966	}
[1599]	2967
[2]	2968	switch($_FILES['cc_pd_photo']['type'])
	2969	{
	2970	case 'image/jpeg':
	2971	case 'image/pjpeg':
	2972	$src_img = imagecreatefromjpeg($_FILES['cc_pd_photo']['tmp_name']);
	2973	if ($src_img == '')
	2974	{
	2975	$bogus = true;
	2976	}
	2977	break;
	2978
	2979	case 'image/png':
	2980	case 'image/x-png':
	2981	$src_img = imagecreatefrompng($_FILES['cc_pd_photo']['tmp_name']);
	2982	if ($src_img == '')
	2983	{
	2984	$bogus = true;
	2985	}
	2986	break;
	2987
	2988	case 'image/gif':
	2989	$src_img = imagecreatefromgif($_FILES['cc_pd_photo']['tmp_name']);
	2990	if ($src_img == '')
	2991	{
	2992	$bogus = true;
	2993	}
	2994	break;
	2995
	2996	default:
[1599]	2997
[2]	2998	$this->page_info['photos'][$id]['status'] = 'invalid_image';
	2999	$this->page_info['photos'][$id]['msg'] = lang('The file must be an JPEG, PNG or GIF Image.');
	3000
	3001	$this->save_session();
	3002	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	3003	return;
	3004	}
	3005
	3006	if ($bogus)
	3007	{
	3008	$this->page_info['photos'][$id]['status'] = 'invalid_file';
	3009	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
[1599]	3010
[2]	3011	$this->save_session();
	3012	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	3013	return;
	3014	}
[1599]	3015
[2]	3016	$img_size = getimagesize($_FILES['cc_pd_photo']['tmp_name']);
	3017	$dst_img = imagecreatetruecolor(60, 80);
[1599]	3018
[2]	3019	if (!imagecopyresized($dst_img, $src_img, 0, 0, 0, 0, 60, 80, $img_size[0], $img_size[1]))
	3020	{
	3021	$this->page_info['photos'][$id]['status'] = 'invalid_file';
	3022	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
[1599]	3023
[2]	3024	$this->save_session();
	3025	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	3026	return;
	3027	}
[1599]	3028
[2]	3029	ob_start();
	3030	imagepng($dst_img);
	3031	$this->page_info['photos'][$id]['content'] = ob_get_contents();
	3032	ob_end_clean();
	3033
	3034	$this->page_info['photos'][$id]['status'] = 'changed';
	3035	$this->page_info['photos'][$id]['msg'] = lang('Photo Successfully Updated!');
	3036
	3037	$this->save_session();
[1599]	3038
[2]	3039	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	3040
	3041	imagedestroy($src_img);
	3042	imagedestroy($dst_img);
	3043	echo 'ok';
	3044	return;
	3045	}
	3046
	3047
	3048	/*!
	3049
	3050	@function get_photo
	3051	@abstract Returns the photo to the browser
	3052	@author Raphael Derosso Pereira
	3053
	3054	*/
	3055	function get_photo($id)
	3056	{
	3057	$fields = $this->bo->catalog->get_fields(false);
	3058	$fields['photo'] = true;
[1599]	3059
[2]	3060	$contact = $this->bo->catalog->get_single_entry($id, $fields);
	3061
	3062	if (!$contact['photo'])
	3063	{
	3064	header('Content-type: image/png');
	3065	echo file_get_contents(PHPGW_INCLUDE_ROOT.'/contactcenter/templates/default/images/photo_celepar.png');
	3066	return;
	3067	}
[1599]	3068
[2]	3069	header('Content-type: image/jpeg');
	3070	$photo = imagecreatefromstring ($contact['photo']);
	3071	$width = imagesx($photo);
	3072	$height = imagesy($photo);
[16]	3073	$twidth = 70;
	3074	$theight = 90;
[2]	3075	$small_photo = imagecreatetruecolor ($twidth, $theight);
	3076	imagecopyresampled($small_photo, $photo, 0, 0, 0, 0,$twidth, $theight, $width, $height);
[4753]	3077	imagejpeg($small_photo,"",100);
[2]	3078	return;
	3079	}
[1599]	3080
[2]	3081	/*!
[1599]	3082
[2]	3083	@function get_states
	3084	@abstract Echos a serialized array containing all the states for the given country
	3085	@author Raphael Derosso Pereira
	3086
	3087	@params $id_country The ID of the Country that contains the requested states
	3088
	3089	*/
	3090	function get_states($id_country)
	3091	{
	3092	$states = $this->bo->catalog->get_all_states($id_country);
	3093
	3094	if (!$states)
	3095	{
	3096	$result = array(
	3097	'msg' => lang('No States found for this Country.'),
	3098	'status' => 'empty'
	3099	);
	3100
	3101	echo serialize($result);
	3102	return;
	3103	}
[1599]	3104
[2]	3105	$result = array(
	3106	'msg' => lang('States Successfully retrieved!'),
	3107	'status' => 'ok'
	3108	);
[1599]	3109
[2]	3110	foreach ($states as $state_info)
	3111	{
	3112	$result['data'][$state_info['id_state']] = $state_info['name'];
	3113
	3114	if ($state_info['symbol'])
	3115	{
	3116	$result['data'][$state_info['id_state']] .= ', '.$state_info['symbol'];
	3117	}
	3118	}
	3119
	3120	echo serialize($result);
	3121	}
	3122
	3123	/*!
	3124
	3125	@function get_cities
	3126	@abstract Echos a serialized array containing all the cities of a given state
	3127	@author Raphael Derosso Pereira
	3128
	3129	@param $id_country The ID of the Country that has the specified Cities (in case the
	3130	Country doesn't have any States)
	3131	@param $id_state The ID of the State that has the Cities requested
	3132
	3133	*/
	3134	function get_cities($id_country, $id_state=false)
	3135	{
	3136	$cities = $this->bo->catalog->get_all_cities($id_country, $id_state);
	3137
	3138	if (!$cities)
	3139	{
	3140	$result = array(
	3141	'msg' => lang('No Cities found for this State.'),
	3142	'status' => 'empty'
	3143	);
	3144
	3145	echo serialize($result);
	3146	return;
	3147	}
[1599]	3148
[2]	3149	$result = array(
	3150	'msg' => lang('Cities Successfully retrieved!'),
	3151	'status' => 'ok'
	3152	);
[1599]	3153
[2]	3154	foreach ($cities as $city_info)
	3155	{
	3156	$result['data'][$city_info['id_city']] = $city_info['name'];
	3157	}
[1599]	3158
[2]	3159	echo serialize($result);
	3160	}
	3161
[3282]	3162	//Traduz o campo na busca completa por entradas no catálogo do usuário.
	3163	function aux_full_search ($field,$isldap) {
	3164	$retorno = '';
	3165	if($isldap) {
	3166	switch($field) {
	3167	case 'mail':
	3168	$retorno = 'contact.connection.mail';
	3169	break;
	3170	case 'phone':
	3171	$retorno = 'contact.connection.phone';
	3172	break;
	3173	}
	3174	}
	3175	else {
	3176	switch($field) {
	3177	case 'corporate':
	3178	$retorno = 'contact.corporate_name';
	3179	break;
	3180	case 'mail':
	3181	case 'phone':
	3182	$retorno = 'contact.contact_connection.connection.connection_value';
	3183	break;
	3184	}
	3185	}
	3186	return $retorno;
	3187	}
[2]	3188
	3189	/*!
[1599]	3190
[2]	3191	@function search
	3192	@abstract Echos a serialized array containing the IDs
	3193	of the entries that matches the search argument
	3194	@author Raphael Derosso Pereira
[3334]	3195	@author Mário César Kolling (external catalogs)
[2]	3196
	3197	@param string $str_data A serialized array with two informations:
	3198	$data = array(
	3199	'search_for' => (string),
	3200	'recursive' => (boolean),
	3201	);
	3202
	3203	*/
[285]	3204	// SERPRO
[2]	3205	function search($str_data)
	3206	{
	3207	$data = unserialize($str_data);
[284]	3208	// It's an external catalog?
	3209	$external = $this->bo->is_external($this->page_info['actual_catalog']);
[3282]	3210	$full_search = isset($data['full_search'])?$data['full_search']:false;
	3211
	3212	if (!is_array($data) \|\| (!$data['search_for'] && !$full_search) \|\| !is_array($data['fields']))
[1599]	3213	{
[5131]	3214	// echo serialize(array(
	3215	// 'msg' => lang('Invalid parameters'),
	3216	// 'status' => 'abort'
	3217	// ));
[1599]	3218
[5131]	3219	// return array('error' => lang('Invalid parameters'));
	3220	$rules = array(
	3221	0 => array(
	3222	'field' => $data['fields']['search'],
	3223	'type' => 'LIKE',
	3224	'value' => '%'
	3225	)
	3226	);
[1599]	3227	}
	3228
	3229
[284]	3230	/*
	3231	* TODO: look into the database to discover the database's encoding and convert the search_for field accordingly
	3232	*/
	3233	// Support search parameters with accentuation
	3234	if ($this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
[1599]	3235	/rev 104/
	3236	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
[503]	3237	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
[752]	3238	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
	3239	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
[1599]	3240	/****/
[284]	3241	{
	3242
[5131]	3243	$data['search_for'] = $data['search_for'];
[284]	3244	}
	3245
[1599]	3246	$rules = array();
	3247
	3248	if ($data['search_for'] === '*')
	3249	{
	3250	$rules = array(
	3251	0 => array(
	3252	'field' => $data['fields']['search'],
	3253	'type' => 'LIKE',
	3254	'value' => '%'
	3255	)
	3256	);
	3257	}
	3258	else
	3259	{
[4753]	3260	$names = explode(' ', $data['search_for']);
[1599]	3261
[4753]	3262	if (!is_array($names))
	3263	{
	3264	if(!$full_search) {
	3265	echo serialize(array(
	3266	'msg' => lang('Invalid Search Parameter'),
	3267	'status' => 'abort'
	3268	));
	3269	exit;
	3270	}
	3271	else
	3272	$names = array();
[1599]	3273
[4753]	3274	}
[1599]	3275
[284]	3276	if (!$external && $this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
[1599]	3277	/rev 104/
	3278	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
[503]	3279	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
[1599]	3280	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
[752]	3281	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager' )
[1599]	3282	/*****/
[284]	3283	{
	3284	/*
	3285	* Restrict the returned contacts search to objectClass = phpgwAccount,
[880]	3286	* must have attibute phpgwAccountStatus, phpgwAccountVisible != -1
[284]	3287	*/
[3282]	3288
[284]	3289	$rules = array(
	3290	0 => array(
	3291	'field' => 'contact.object_class',
	3292	'type' => '=',
	3293	'value' => 'phpgwAccount'
	3294	),
	3295	1 => array(
	3296	'field' => 'contact.account_status',
	3297	'type' => 'iLIKE',
	3298	'value' => '%'
	3299	),
[1599]	3300	/rev 104/
	3301	///
	3302	//1 => array(
[284]	3303	2 => array(
[1599]	3304	/*****/
[284]	3305	'field' => 'contact.account_visible',
	3306	'type' => '!=',
	3307	'value' => '-1'
[1599]	3308	/rev 104/
	3309	/* ),
	3310	2 => array(
	3311	'field' => 'contact.object_class',
	3312	'type' => '=',
	3313	'value' => 'inetOrgPerson'
	3314	/****/
[284]	3315	),
	3316	);
[3282]	3317
[4753]	3318	if($full_search) {
	3319	foreach($full_search as $field => $value) {
	3320	if(trim($value)!='')
	3321	array_push($rules,array(
	3322	'field' => $this->aux_full_search($field,true),
	3323	'type' => 'LIKE',
	3324	'value' => ''.$value.''
	3325	));
	3326	}
	3327	}
[3282]	3328
[284]	3329	}
[4274]	3330	else if(!$external && $full_search) {
[3282]	3331
	3332	foreach($full_search as $field => $value) {
	3333	if(trim($value)!='')
	3334	array_push($rules,array(
	3335	'field' => $this->aux_full_search($field,false),
[4753]	3336	'type' => 'iLIKE',
	3337	'value' => '%'.$value.'%'
[3282]	3338	));
[4753]	3339	}
[3282]	3340
	3341	}
[284]	3342
[1599]	3343	foreach ($names as $name)
	3344	{
	3345	if ($name != '')
	3346	{
	3347	array_push($rules, array(
	3348	'field' => $data['fields']['search'],
[4838]	3349	//'type' => 'iLIKE',
	3350	//'value' => '%'.$name.'%'
	3351	'type' => 'LIKE and ~=',
	3352	'value' => $name
[1599]	3353	));
	3354	}
	3355	}
	3356	}
	3357
[284]	3358	if ($external \|\| $this->page_info['actual_catalog']['class'] == 'bo_people_catalog' \|\|
[1599]	3359	/rev 104/
	3360	//$this->page_info['actual_catalog']['class'] == 'bo_group_manager')
[503]	3361	$this->page_info['actual_catalog']['class'] == 'bo_group_manager' \|\|
[752]	3362	$this->page_info['actual_catalog']['class'] == 'bo_shared_people_manager' \|\|
[1599]	3363	$this->page_info['actual_catalog']['class'] == 'bo_shared_group_manager')
	3364
	3365
	3366	/***/
[2]	3367	{
[284]	3368	// Get only this attributes: dn, cn for external catalogs,
	3369	// used to restrict the attributes used in filters
[5131]	3370	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC', 'customFilter' => $data['custom_filter'], 'CN' => $data['CN'], 'exact' => $data['exact']), $data['search_for'] != null); }
[284]	3371	else
	3372	{
	3373	// Get only this attributes: dn, cn, phpgwAccountType, objectClass, phpgwAccountStatus, phpghAccountVisible
	3374	// for non-external catalogs, used to restrict the attributes used in filters
	3375	$ids = $this->bo->find(array(
	3376	$data['fields']['id'],
	3377	$data['fields']['search'],
	3378	'contact.object_class',
[304]	3379	//'contact.account_status',
[3282]	3380	'contact.account_visible',
	3381	'contact.connection.mail',
	3382	'contact.connection.phone'
[5131]	3383	), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC', 'customFilter' => $data['custom_filter'], 'CN' => $data['CN'], 'exact' => $data['exact']), $data['search_for_area'], $data['search_for'] != null ); }
[2]	3384
[1599]	3385	if (!is_array($ids) \|\| !count($ids))
	3386	{
[284]	3387	$this->last_search_ids = null;
	3388	$this->save_session();
	3389	return null;
[1599]	3390	}
[2]	3391
[1599]	3392	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
[2]	3393
[1599]	3394	$ids_f = array();
	3395
	3396	foreach ($ids as $e_info)
	3397	{
	3398	/rev 104/
	3399	//$ids_f[] = $e_info[$id_field];
[752]	3400	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
[1599]	3401	{
	3402	$ids_f[] = $e_info[$id_field];
	3403	} else{
[3371]	3404	$ids_f[] = array(0=>$e_info[$id_field],1=>$e_info['perms'],2=>$e_info['owner']);
[1599]	3405	}
	3406	/****/
	3407	}
[284]	3408
	3409	return $ids_f;
[2]	3410	}
[1599]	3411
[285]	3412	// CELEPAR
	3413	/*
	3414	function search($str_data)
	3415	{
	3416	$data = unserialize($str_data);
[2]	3417
[285]	3418	if (!is_array($data) \|\| !$data['search_for'] \|\| !is_array($data['fields']))
	3419	{
	3420	echo serialize(array(
	3421	'msg' => lang('Invalid parameters'),
	3422	'status' => 'abort'
	3423	));
	3424
	3425	return;
	3426	}
	3427
	3428	$rules = array();
	3429
	3430	if ($data['search_for'] === '*')
	3431	{
	3432	$rules = array(
	3433	0 => array(
	3434	'field' => $data['fields']['search'],
	3435	'type' => 'LIKE',
	3436	'value' => '%'
	3437	)
	3438	);
	3439	}
	3440	else
	3441	{
	3442	$names = explode(' ', $data['search_for']);
	3443
	3444	if (!is_array($names))
	3445	{
	3446	echo serialize(array(
	3447	'msg' => lang('Invalid Search Parameter'),
	3448	'status' => 'abort'
	3449	));
[1599]	3450
[285]	3451	return;
	3452	}
[1599]	3453
[285]	3454	foreach ($names as $name)
	3455	{
	3456	if ($name != '')
	3457	{
	3458	array_push($rules, array(
	3459	'field' => $data['fields']['search'],
	3460	'type' => 'iLIKE',
	3461	'value' => '%'.$name.'%'
	3462	));
	3463	}
	3464	}
	3465	}
	3466
[1599]	3467
	3468
[285]	3469	//$catalog = $this->bo->get_branch_by_level($this->bo->catalog_level[0]);
[1599]	3470
[285]	3471	//if ($catalog['class'] === 'bo_people_catalog')
	3472	//{
	3473	// array_push($rules, array(
	3474	// 'field' => 'contact.id_owner',
	3475	// 'type' => '=',
	3476	// 'value' => $GLOBALS['phpgw_info']['user']['account_id']
	3477	// ));
	3478	//}
[1599]	3479
	3480
[285]	3481	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'));
	3482
	3483	if (!is_array($ids) \|\| !count($ids))
	3484	{
	3485	echo serialize(array(
	3486	'msg' => lang('No Entries Found!'),
	3487	'status' => 'empty'
	3488	));
	3489
	3490	return;
	3491	}
	3492	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
	3493
	3494	$ids_f = array();
	3495	foreach ($ids as $e_info)
	3496	{
	3497	$ids_f[] = $e_info[$id_field];
	3498	}
	3499
	3500	echo serialize(array(
	3501	'data' => $ids_f,
	3502	'msg' => lang('Found %1 Entries', count($ids)),
	3503	'status' => 'ok'
	3504	));
[1599]	3505
[285]	3506	return;
	3507	}*/
[2]	3508	/*!
	3509
	3510	@function get_multiple_entries
	3511	@abstract Returns an array containing the specifiend data in the default
	3512	CC UI format
	3513	@author Raphael Derosso Pereira
	3514
[1599]	3515	@param array str_data A serialized array containing the ID's of the entries
[2]	3516	to be taken, the fields to be taken and the rules to be used on the
	3517	retrieval:
	3518	$data = array(
	3519	'ids' => array(...),
	3520	'fields' => array(...),
	3521	'rules' => array(...)
	3522	);
	3523
	3524	*/
	3525	function get_multiple_entries($str_data)
	3526	{
	3527	$data = unserialize($str_data);
[1599]	3528
[2]	3529	if (!is_array($data) or !count($data) or !count($data['fields']) or !count($data['ids']))
	3530	{
	3531	return array(
	3532	'msg' => lang('Invalid Parameters'),
	3533	'status' => 'abort'
	3534	);
	3535	}
	3536
	3537	$entries = $this->bo->catalog->get_multiple_entries($data['ids'], $data['fields']);
[1599]	3538
[2]	3539	if (!is_array($entries) or !count($entries))
	3540	{
	3541	return array(
	3542	'msg' => lang('No Entries Found!'),
	3543	'status' => 'empty'
	3544	);
	3545	}
	3546
	3547	return array(
	3548	'msg' => lang('Found %1 Entries!', count($entries)),
	3549	'status' => 'ok',
	3550	'data' => $entries
	3551	);
	3552	}
	3553
	3554	/*
	3555
	3556	@function get_all_entries
[1599]	3557	@abstract Returns the specified fields for all catalog's entries
[2]	3558	in the default CC UI format
	3559	@author Raphael Derosso Pereira
	3560
[1599]	3561	@params array str_data A serialized array containing the fields to
[2]	3562	be grabbed, the maximum number of entries to be returned and a
	3563	boolean specifying if the calls refers to a new grab or to an
	3564	unfinished one.
	3565
	3566	*/
	3567	function get_all_entries($str_data)
	3568	{
	3569	$data = unserialize($str_data);
[1599]	3570
	3571	if (!is_array($data) or
	3572	!count($data) or
	3573	!count($data['fields']) or
[2]	3574	!$data['maxlength'] or
	3575	(!$data['new'] and !$data['offset']))
	3576	{
	3577	return array(
	3578	'msg' => lang('Invalid Parameters'),
	3579	'status' => 'abort'
	3580	);
	3581	}
	3582
	3583	if ($data['new'])
	3584	{
	3585	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
	3586
	3587	$this->save_session();
	3588
	3589	if (!is_array($this->all_entries) or !count($this->all_entries))
	3590	{
	3591	return array(
	3592	'msg' => lang('No Entries Found!'),
	3593	'status' => 'empty'
	3594	);
	3595	}
	3596
	3597	$data['offset'] = 0;
	3598	}
[1599]	3599
[2]	3600	if ($data['maxlength'] != -1)
	3601	{
	3602	$result = $this->bo->catalog->get_multiple_entries(array_slice($this->all_entries, $data['offset'], $data['maxlength']), $data['fields']);
	3603	}
	3604	else
	3605	{
	3606	$result = $this->bo->catalog->get_multiple_entries($this->all_entries, $data['fields']);
	3607	}
	3608
	3609	$jsCode = array();
	3610	$count = 0;
	3611	foreach ($result as $each)
	3612	{
	3613	if (!is_array($each))
	3614	{
	3615	continue;
	3616	}
	3617
[1599]	3618	if($this-> typeContact == 'groups') {
	3619
[2]	3620	foreach ($each as $field => $value) {
[1599]	3621
[2]	3622	if ($field === 'title') {
	3623	$optionName = '\\"'.$value.'\\"';
[1599]	3624
[2]	3625	}
	3626	else if ($field === 'short_name') {
[1599]	3627
[2]	3628	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$optionName.' ('.$value.')", "'.$count.'");';
[7655]	3629	++$count;
[1599]	3630	}
[2]	3631	}
	3632	}
[1599]	3633
	3634	else {
[2]	3635	foreach ($each as $field => $value) {
	3636	if ($field === 'names_ordered') {
	3637	if(is_array($value))
	3638	$value = $value[0];
	3639	$name = '\\"'.$value.'\\"';
	3640	}
	3641	else if ($field === 'connections') {
[1599]	3642
[2]	3643	foreach ($value as $connection) {
[3795]	3644	if ($connection['id_type'] == $this->preferences['personCardEmail']) {
[2]	3645	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$name.' <'.$connection['connection_value'].'>", "'.$count.'");';
[7655]	3646	++$count;
[2]	3647	}
	3648	}
	3649	}
	3650	}
	3651	}
	3652	}
	3653
	3654	$jsCodeFinal = implode("\n", $jsCode);
[1599]	3655
[2]	3656	$nEntries = count($result);
[1599]	3657
[2]	3658	if (!$nEntries)
	3659	{
	3660	return array(
	3661	'msg' => lang('Error while getting user information...'),
	3662	'status' => 'abort'
	3663	);
	3664	}
	3665
	3666	return array(
	3667	'msg' => lang('Found %1 Entries!', $nEntries),
	3668	'status' => 'ok',
	3669	'typeContact' => $this -> typeContact,
	3670	'final' => $nEntries + $data['offset'] < count($this->all_entries) ? false : true,
	3671	'offset' => $data['offset'] + $nEntries,
	3672	'data' => $jsCodeFinal
	3673	);
	3674	}
[1599]	3675
[2]	3676	/*********************************************************************\
	3677	* Auxiliar Methods *
	3678	\*********************************************************************/
	3679
	3680	/*!
[1599]	3681
[2]	3682	@function save_session
	3683	@abstract Saves the data on the session
	3684	@author Raphael Derosso Pereira
[1599]	3685
[2]	3686	*/
	3687	function save_session()
	3688	{
	3689	$GLOBALS['phpgw']->session->appsession('ui_data.page_info','contactcenter',$this->page_info);
	3690	$GLOBALS['phpgw']->session->appsession('ui_data.all_entries','contactcenter',$this->all_entries);
	3691	}
	3692
	3693	/*!
[1599]	3694
[2]	3695	@function convert_tree
	3696	@abstract Converts the tree array in the BO format to a JS tree array compatible
	3697	with the one available in eGW
	3698	@author Raphael Derosso Pereira
[1599]	3699
[2]	3700	@param (array) $tree The tree in the BO format
	3701	@param (string) $name The tree name
	3702	@param (string) $iconDir The dir where the icons are
	3703	@param (string) $parent The parent
	3704	*/
	3705
	3706	function convert_tree($tree, &$iconDir, $parent='0')
	3707	{
	3708	// echo "Entrou<br>\tPai: $parent <br>";
	3709	$rtree = array();
	3710
	3711	if ($parent === '0')
	3712	{
	3713	// echo 'Root!<br>';
	3714	$rtree['0'] = array(
	3715	'type' => 'catalog_group',
	3716	'id' => '0',
	3717	'pid' => 'none',
	3718	'caption' => lang('Catalogues'),
	3719	'class' => 'bo_catalog_group_catalog',
	3720	'class_args' => array('_ROOT_', '$this', '$this->get_branch_by_level($this->catalog_level[0])')
	3721	);
	3722	}
	3723
	3724	foreach($tree as $id => $value)
	3725	{
	3726	// echo 'ID: '.$id.'<br>';
	3727	$rtree[$parent.'.'.$id] = array(
	3728	'type' => $value['type'],
	3729	'id' => $parent.'.'.$id,
	3730	'pid' => $parent,
	3731	'caption' => $value['name']
	3732	);
[1599]	3733
[2]	3734	switch($value['type'])
	3735	{
	3736	case 'catalog_group':
	3737	case 'mixed_catalog_group':
	3738	$rtree = $rtree + $this->convert_tree($value['sub_branch'],$iconDir,$parent.'.'.$id);
	3739	break;
	3740	}
	3741	}
	3742
	3743	if (count($rtree))
	3744	{
	3745	return $rtree;
	3746	}
	3747	}
	3748
[3970]	3749	function get_catalog_add_contact($id, $echo=true){
[2]	3750
	3751	$array_participants = array();
[13]	3752	if(!$this->bo->catalog->src_info) {
	3753	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	3754	$this->bo->catalog->src_info = $ldap->srcs[1];
[2]	3755	}
[1599]	3756
	3757	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
[13]	3758	$dn=$this->bo->catalog->src_info['dn'];
	3759	$justThese = array("givenname","givenname","sn","telephonenumber","mail");
[1599]	3760	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
	3761	$info = ldap_get_entries($ds, $sr);
[7655]	3762	for($z = 0; $z < 5; ++$z) {
[1599]	3763	$participant = $info[0][$justThese[$z]];
[5131]	3764	$participant[0] = utf8_decode($participant[0]);
[13]	3765	array_push($array_participants, $participant);
	3766	}
	3767
	3768	ldap_close($ds);
[3970]	3769	if ($echo)
	3770	{
	3771	echo serialize($array_participants);
	3772	}
	3773	else
	3774	{
	3775	return serialize($array_participants);
	3776	}
[1599]	3777	}
	3778
	3779	function get_catalog_participants_group($id)
[880]	3780	{
	3781	if(!$this->bo->catalog->src_info) {
	3782	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	3783	$this->bo->catalog->src_info = $ldap->srcs[1];
[1599]	3784	}
	3785	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
	3786	$justThese = array("description","memberuid");
	3787	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
[880]	3788	$info = ldap_get_entries($ds, $sr);
	3789	$member_uids = $info[0]['memberuid'];
	3790	$contact['names_ordered'] = $info[0]['description'];
[1599]	3791	$filter = "";
[7673]	3792	$member_uids_count = count($member_uids);
	3793	for($z = 0; $z < $member_uids_count; ++$z) {
[880]	3794	if($member_uids[$z])
[1599]	3795	$filter.="(uid=".$member_uids[$z].")";
[880]	3796	}
	3797	$array_participants = array();
	3798	if($filter) {
[962]	3799	$filter = "(\|".$filter.")";
[904]	3800	$valarray = explode(',',$id);
	3801	array_shift($valarray);
	3802	$dn = implode(',',$valarray);
[880]	3803	$justThese = array("cn","mail");
[1599]	3804	$sr = ldap_search($ds,$dn, $filter,$justThese);
	3805	$info = ldap_get_entries($ds, $sr);
[7655]	3806	for($z = 0; $z < $info['count']; ++$z) {
[880]	3807	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
[1599]	3808	$array_emails[$info[$z]['mail'][0]] = null;
	3809	array_push($array_participants, $participant);
[880]	3810	}
	3811	ldap_close($ds);
[1599]	3812	}
[880]	3813	sort($array_participants);
[1599]	3814	$innerHTML = '';
[880]	3815	foreach($array_participants as $index => $participant){
	3816	$innerHTML .= $participant;
	3817	}
[1599]	3818	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
[880]	3819	echo serialize($return);
	3820	}
	3821
[1599]	3822	function get_catalog_participants_list($id)
[2]	3823	{
[1599]	3824
	3825	$fields = $this->bo->catalog->get_fields(false);
[2]	3826	$fields['names_ordered'] = true;
[1599]	3827	$fields['mail_forwarding_address'] = true;
	3828	$contact = $this->bo->catalog->get_single_entry($id,$fields);
	3829
[2]	3830	$array_participants = array();
	3831	$array_emails = array();
[880]	3832
[2]	3833	$filter = null;
[7655]	3834	for($z = 0; $z < $contact['mail_forwarding_address']['count']; ++$z) {
[2]	3835	if(strstr($contact['mail_forwarding_address'][$z],'@')) {
	3836	$filter.="(mail=".$contact['mail_forwarding_address'][$z].")";
	3837	$array_emails[$contact['mail_forwarding_address'][$z]] = "<font color=black>".$contact['mail_forwarding_address'][$z]."</font>";
[1599]	3838	}
	3839	else
[2]	3840	$array_participants[$z] = "<font color=red>".$contact['mail_forwarding_address'][$z]."</font>";
[1599]	3841	}
	3842
[2]	3843	if($filter) {
[1599]	3844	$filter = "(\|".$filter.")";
[2]	3845	if(!$this->bo->catalog->src_info) {
	3846	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	3847	$this->bo->catalog->src_info = $ldap->srcs[1];
	3848	}
[880]	3849	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
[2]	3850	$dn=$this->bo->catalog->src_info['dn'];
	3851	$justThese = array("cn","mail");
[1599]	3852	$sr = ldap_search($ds,$dn, $filter,$justThese);
	3853	$info = ldap_get_entries($ds, $sr);
[7655]	3854	for($z = 0; $z < $info['count']; ++$z) {
[24]	3855	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
[1599]	3856	$array_emails[$info[$z]['mail'][0]] = null;
	3857	array_push($array_participants, $participant);
[2]	3858	}
[1599]	3859
[2]	3860	foreach($array_emails as $index => $email)
[1599]	3861	if($email)
	3862	array_push($array_participants, "      ".$email."<br>");
	3863
[2]	3864	ldap_close($ds);
	3865	}
	3866	sort($array_participants);
[1599]	3867	$innerHTML = '';
[24]	3868	foreach($array_participants as $index => $participant){
	3869	$innerHTML .= $participant;
	3870	}
[1599]	3871	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
[24]	3872	echo serialize($return);
[1599]	3873	}
	3874
[2]	3875	function export_contacts($typeExport){
	3876
	3877	$boGroup = CreateObject('contactcenter.bo_group');
	3878	$contacts = $boGroup->get_all_contacts();
	3879	$streamBuffer = '';
[5131]	3880	$stramArray = Array();
[2]	3881
	3882	if(!count($contacts))
	3883	echo null;
[1599]	3884
[2]	3885	switch($typeExport) {
	3886
	3887	case 'outlook_en':
	3888	$streamBuffer = "Name;E-mail Address;Notes;Mobile Phone;Pager;Company;".
[3322]	3889	"Job Title;Home Phone;Home Fax;Business Phone;Business Fax\r\n";
[293]	3890	foreach($contacts as $index => $object){
[3322]	3891	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
	3892	. "\"".$object[ 'main-mail' ] . "\";"
	3893	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\";"
	3894	. "\"".$object[ 'mobile' ] . "\";"
	3895	. "\"".$object[ 'business-pager' ] . "\";"
	3896	. "\"".$object[ 'corporate_name' ] . "\";"
	3897	. "\"".$object[ 'job_title' ] . "\";"
	3898	. "\"".$object[ 'home-phone' ] . "\";"
	3899	. "\"".$object[ 'home-fax' ] . "\";"
	3900	. "\"".$object[ 'business-phone' ] . "\";"
	3901	. "\"".$object[ 'business-fax' ] . "\"\r\n";
[2]	3902	}
[3215]	3903	break;
[1599]	3904
[2]	3905	case 'outlook_pt-BR':
[5131]	3906	$streamBuffer = "Nome;Apelido;End. de email;Endereço residencial;"
[3322]	3907	."Cidade do endereço residencial;CEP do endereço residencial;Estado;País/região do endereço residencial;"
	3908	."Telefone residencial;Fax residencial;Telefone celular;Página pessoal da Web;Rua do endereço comercial;"
	3909	."Cidade do endereço comercial;CEP do endereço comercial;Estado do endereço comercial;"
	3910	."País/região do endereço comercial;Página comercial da Web;Telefone comercial;Fax comercial;Pager;Empresa;"
	3911	."Cargo;Departamento;End. comercial;Observações\r\n";
[3215]	3912
[293]	3913	foreach($contacts as $index => $object){
[3322]	3914	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
	3915	. "\"".$object[ 'alias' ] . "\";"
	3916	. "\"".$object[ 'main-mail' ] . "\";"
	3917	. "\"".$object[ 'home-address' ] . "\";"
	3918	. "\"".$object[ 'home-city_name' ] . "\";"
	3919	. "\"".$object[ 'home-postal_code' ] . "\";"
	3920	. "\"".$object[ 'home-state_name' ] . "\";"
	3921	. "\"".$object[ 'home-id_country' ] . "\";"
	3922	. "\"".$object[ 'home-phone' ] . "\";"
	3923	. "\"".$object[ 'home-fax' ] . "\";"
	3924	. "\"".$object[ 'mobile' ] . "\";"
	3925	. "\"".$object[ 'web_page' ] . "\";"
	3926	. "\"".$object[ 'business-address' ] . "\";"
	3927	. "\"".$object[ 'business-city_name' ] . "\";"
	3928	. "\"".$object[ 'business-postal_code' ] . "\";"
	3929	. "\"".$object[ 'business-state_name' ] . "\";"
	3930	. "\"".$object[ 'business-id_country' ] . "\";"
	3931	. "\"".$object[ 'web_page' ] . "\";"
	3932	. "\"".$object[ 'business-phone' ] . "\";"
	3933	. "\"".$object[ 'business-fax' ] . "\";"
	3934	. "\"".$object[ 'business-pager' ] . "\";"
	3935	. "\"".$object[ 'corporate_name' ] . "\";"
	3936	. "\"".$object[ 'job_title' ] . "\";"
	3937	. "\"".$object[ 'department' ] . "\";"
[5131]	3938	."\"\";"
[3322]	3939	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\"\r\n";
[2]	3940	}
[3322]	3941
[2]	3942	break;
[1599]	3943
[15]	3944	case 'outlook2000_pt-BR':
	3945	$streamBuffer = "\"Tratamento\",\"Nome\",\"Segundo Nome\",\"Sobrenome\",\"Sufixo\",".
[3322]	3946	"\"Empresa\",\"Departamento\",\"Cargo\",\"Rua do endereço comercial\",\"Rua do endereço comercial 2\",".
	3947	"\"Rua do endereço comercial 3\",\"Cidade do endereço comercial\",\"Estado do endereço comercial\",".
	3948	"\"CEP do endereço comercial\",\"País do endereço comercial\",\"Endereço residencial\",\"Rua residencial 2\",".
	3949	"\"Rua residencial 3\",\"Cidade do endereço residencial\",\"Estado\",\"CEP do endereço residencial\",\"País do endereço residencial\",".
	3950	"\"Outro endereço\",\"Outro endereço 2\",\"Outro endereço 3\",\"Cidade\",\"Estado\",\"CEP\",\"País\",".
[15]	3951	"\"Telefone do assistente\",\"Fax comercial\",\"Telefone comercial\",\"Telefone comercial 2\",\"Retorno de chamada\",".
	3952	"\"Telefone do carro\",\"Telefone principal da empresa\",\"Fax residencial\",\"Telefone residencial\",".
	3953	"\"Telefone residencial 2\",\"ISDN\",\"Telefone celular\",\"Outro fax\",\"Outro telefone\",\"Pager\",\"Telefone principal\",".
[3322]	3954	"\"Radiofone\",\"Telefone TTY/TDD\",\"Telex\",\"Aniversário\",\"Anotações\",\"Caixa postal\",\"Categorias\",".
	3955	"\"Código da empresa\",\"Código do governo\",\"Cônjuge\",\"Conta\",\"Endereço de correio eletrônico\",".
	3956	"\"Nome de exibição do correio eletr.\",\"Endereço de correio eletrônico 2\",".
	3957	"\"Nome de exibição do correio eletr.2\",\"Endereço de correio eletrônico 3\",".
	3958	"\"Nome de exibição do correio eletr.3\",\"Datas especiais\",\"Disponibilidade da Internet\",".
	3959	"\"Filhos\",\"Hobby\",\"Idioma\",\"Indicação\",\"Informações para cobrança\",\"Iniciais\",\"Local\",".
	3960	"\"Nome do assistente\",\"Nome do gerenciador\",\"Página da Web\",\"Palavras-chave\",\"Particular\",\"Personalizado 1\",\"Personalizado 2\",".
	3961	"\"Personalizado 3\",\"Personalizado 4\",\"Prioridade\",\"Profissão\",\"Quilometragem\",\"Sala\",\"Sensibilidade\",\"Servidor de diretório\",".
[15]	3962	"\"Sexo\"\r\n";
[1599]	3963
[3322]	3964
	3965
[293]	3966	foreach($contacts as $index => $object){
[3322]	3967	$streamBuffer .= "\"".$object[ 'alias' ] . "\","
	3968	. "\"".$object[ 'names_ordered' ] . "\","
	3969	.",,,"
	3970	. "\"".$object[ 'corporate_name' ] . "\","
	3971	. "\"".$object[ 'department' ] . "\","
	3972	. "\"".$object[ 'job_title' ] . "\","
	3973	. "\"".$object[ 'business-address' ] . "\","
	3974	. "\"".$object[ 'business-address-2' ] . "\","
	3975	.","
	3976	. "\"".$object[ 'business-city_name' ] . "\","
	3977	. "\"".$object[ 'business-state' ] . "\","
	3978	. "\"".$object[ 'business-postal_code' ] . "\","
	3979	. "\"".$object[ 'business-id_country' ] . "\","
	3980	. "\"".$object[ 'home-address' ] . "\","
	3981	. "\"".$object[ 'home-address-2' ] . "\","
	3982	.","
	3983	. "\"".$object[ 'home-city_name' ] . "\","
	3984	. "\"".$object[ 'home-state_name' ] . "\","
	3985	. "\"".$object[ 'home-postal_code' ] . "\","
	3986	. "\"".$object[ 'home-id_country' ] . "\","
	3987	.",,,,,,,,"
	3988	. "\"".$object[ 'business-fax' ] . "\","
	3989	. "\"".$object[ 'business-phone' ] . "\","
	3990	. "\"".$object[ 'business-mobile' ] . "\","
	3991	.",,,"
	3992	. "\"".$object[ 'home-fax' ] . "\","
	3993	. "\"".$object[ 'home-phone' ] . "\","
	3994	.",,"
	3995	. "\"".$object[ 'mobile' ] . "\","
	3996	.",,"
	3997	. "\"".$object[ 'home-pager' ] . "\","
	3998	. "\"".$object[ 'business-phone' ] . "\","
	3999	.",,,"
	4000	. "\"".$object[ 'birthdate' ] . "\","
	4001	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
	4002	.",,,,,,"
	4003	. "\"".$object[ 'main-mail' ] . "\","
	4004	.","
	4005	. "\"".$object[ 'alternative-mail' ] . "\","
	4006	.",,,,,,,,,,,,,,"
	4007	. "\"".$object[ 'web_page' ] . "\","
	4008	.",,,,,,,,,,,,"
	4009	. "\"".$object[ 'sex' ] . "\"\r\n";
	4010	}
[15]	4011	break;
[1599]	4012
[15]	4013	case 'outlook2000_en':
	4014	$streamBuffer = "Title,First Name,Middle Name,Last Name,Suffix,Company,Department,Job Title,".
	4015	"Business Street,Business Street 2,Business Street 3,Business City,Business State,Business Postal Code,".
	4016	"Business Country,Home Street,Home Street 2,Home Street 3,Home City,Home State,Home Postal Code,Home Country,".
	4017	"Other Street,Other Street 2,Other Street 3,Other City,Other State,Other Postal Code,Other Country,".
	4018	"Assistant's Phone,Business Fax,Business Phone,Business Phone 2,Callback,Car Phone,Company Main Phone,Home Fax,".
	4019	"Home Phone,Home Phone 2,ISDN,Mobile Phone,Other Fax,Other Phone,Pager,Primary Phone,Radio Phone,TTY/TDD Phone,Telex,".
	4020	"Account,Anniversary,Assistant's Name,Billing Information,Birthday,Categories,Children,Directory Server,E-mail Address,".
	4021	"E-mail Type,E-mail Display Name,E-mail 2 Address,E-mail 2 Type,E-mail 2 Display Name,E-mail 3 Address,E-mail 3 Type,E-mail 3 Display Name,".
	4022	"Gender,Government ID Number,Hobby,Initials,Internet Free Busy,Keywords,Language,Location,Manager's Name,Mileage,Notes,".
	4023	"Office Location,Organizational ID Number,PO Box,Priority,Private,Profession,Referred By,Sensitivity,Spouse,User 1,User 2,User 3,User 4,Web Page\r\n";
[1599]	4024
[4753]	4025	foreach($contacts as $index => $object)
	4026	{
	4027	if( array_key_exists("phone", $object) )
	4028	$phone = $object['phone'];
	4029	else
	4030	$phone = $object['business-phone'];
	4031
[3322]	4032	$streamBuffer.= "\"".$object[ 'alias' ] . "\","
	4033	. "\"".$object[ 'names_ordered'] . "\","
	4034	.",,,"
	4035	. "\"".$object[ 'corporate_name' ] . "\","
	4036	. "\"".$object[ 'department' ] . "\","
	4037	. "\"".$object[ 'job_title' ] . "\","
	4038	. "\"".$object[ 'business-address' ] . "\","
	4039	. "\"".$object[ 'business-address-2' ] . "\","
	4040	.","
	4041	. "\"".$object[ 'business-city_name' ] . "\","
	4042	. "\"".$object[ 'business-state' ] . "\","
	4043	. "\"".$object[ 'business-postal_code' ] . "\","
	4044	. "\"".$object[ 'business-id_country' ] . "\","
	4045	. "\"".$object[ 'home-address' ] . "\","
	4046	. "\"".$object[ 'home-address-2' ] . "\","
	4047	.","
	4048	. "\"".$object[ 'home-city_name' ] . "\","
	4049	. "\"".$object[ 'home-state_name' ] . "\","
	4050	. "\"".$object[ 'home-postal_code' ] . "\","
	4051	. "\"".$object[ 'home-id_country' ] . "\","
	4052	.",,,,,,,,"
	4053	. "\"".$object[ 'business-fax' ] . "\","
[4753]	4054	. "\"".$phone . "\","
[3322]	4055	. "\"".$object[ 'business-mobile' ] . "\","
	4056	.",,,"
	4057	. "\"".$object[ 'home-fax' ] . "\","
	4058	. "\"".$object[ 'home-phone' ] . "\","
	4059	.",,"
	4060	. "\"".$object[ 'mobile' ] . "\","
	4061	.",,"
	4062	. "\"".$object[ 'business-pager' ] . "\","
	4063	. "\"".$object[ 'home-pager' ] . "\","
	4064	.",,,,,,,,"
	4065	. "\"".$object[ 'birthdate' ] . "\","
	4066	.",,,"
	4067	. "\"".$object[ 'main-mail' ] . "\","
	4068	.",,"
	4069	. "\"".$object[ 'alternative-mail' ] . "\","
	4070	.",,,,,,,,,,,,,,,"
	4071	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
	4072	.",,,,,,,,,,,,,"
	4073	. "\"".$object[ 'web_page' ] . "\"\r\n";
	4074
[15]	4075	}
	4076	break;
[1599]	4077
[2]	4078	case 'thunderbird':
[3322]	4079	$streamBuffer = "First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,"
	4080	."Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,"
	4081	."Home Address 2,Home City,Home State,Home ZipCode,Home Country,Work Address,Work Address 2,"
	4082	."Work City,Work State,Work ZipCode,Work Country,Job Title,Department,Organization,Web Page 1,"
[5131]	4083	."Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,\r\n";
[1599]	4084
[293]	4085	foreach($contacts as $index => $object){
[3322]	4086	$array_birth = explode("-",$object[ 'birthdate' ]);
	4087
[5131]	4088	$stramArray[0] = "\"".$object[ 'names_ordered'] . "\"";
	4089	$stramArray[1] = "";
	4090	$stramArray[2] = "\"".$object[ 'names_ordered'] . "\"";
	4091	$stramArray[3] = "\"".$object[ 'alias' ] . "\"";
	4092	$stramArray[4] = "\"".$object[ 'main-mail' ] . "\"";
	4093	$stramArray[5] = "\"".$object[ 'alternative-mail' ] . "\"";
	4094	$stramArray[6] = "";
	4095	$stramArray[7] = "\"".$object[ 'business-phone' ] . "\"";
	4096	$stramArray[8] = "\"".$object[ 'home-phone' ] . "\"";
	4097	$stramArray[9] = "\"".$object[ 'business-fax' ] . "\"";
	4098	$stramArray[10] = "\"".$object[ 'business-pager' ] . "\"";
	4099	$stramArray[11] = "\"".$object[ 'mobile' ] . "\"";
	4100	$stramArray[12] = "\"".$object[ 'home-address' ] . "\"";
	4101	$stramArray[13] = "\"".$object[ 'home-address-2' ] . "\"";
	4102	$stramArray[14] = "\"".$object[ 'home-city_name' ] . "\"";
	4103	$stramArray[15] = "\"".$object[ 'home-state_name' ] . "\"";
	4104	$stramArray[16] = "\"".$object[ 'home-postal_code' ] . "\"";
	4105	$stramArray[17] = "\"".$object[ 'home-id_country' ] . "\"";
	4106	$stramArray[18] = "\"".$object[ 'business-address' ] . "\"";
	4107	$stramArray[19] = "\"".$object[ 'business-address-2' ] . "\"";
	4108	$stramArray[20] = "\"".$object[ 'business-city_name' ] . "\"";
	4109	$stramArray[21] = "\"".$object[ 'business-state_name' ] . "\"";
	4110	$stramArray[22] = "\"".$object[ 'business-postal_code' ] . "\"";
	4111	$stramArray[23] = "\"".$object[ 'business-id_country' ] . "\"";
	4112	$stramArray[24] = "\"".$object[ 'job_title' ] . "\"";
	4113	$stramArray[25] = "\"".$object[ 'department' ] . "\"";
	4114	$stramArray[26] = "\"".$object[ 'corporate_name' ] . "\"";
	4115	$stramArray[27] = "";
	4116	$stramArray[28] = "";
	4117	$stramArray[29] = "\"".$array_birth[0] . "\"";
	4118	$stramArray[30] = "\"".$array_birth[1] . "\"";
	4119	$stramArray[31] = "\"".$array_birth[2] . "\"";
	4120	$stramArray[32] = "";
	4121	$stramArray[33] = "";
	4122	$stramArray[34] = "";
	4123	$stramArray[35] = "";
	4124	$stramArray[36] = "";
	4125	$stramArray[37] = "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\"\r\n";
	4126
	4127	if($object[ 'phone' ]){
	4128	if(!$object[ 'home-phone' ])
	4129	$stramArray[8] = "\"".$object[ 'phone' ]. "\"";
	4130	else if(!$object[ 'mobile' ])
	4131	$stramArray[11] = "\"".$object[ 'phone' ]. "\"";
	4132	else if(!$object[ 'business-phone' ])
	4133	$stramArray[7] = "\"".$object[ 'phone' ]. "\"";
	4134	}
	4135
	4136	$streamBuffer .= implode("," , $stramArray);
[2]	4137	}
	4138	break;
[1599]	4139
[285]	4140	case 'expresso':
[3322]	4141	$streamBuffer = 'Nome,Apelido,E-mail Principal,E-mail Alternativo,Celular,'
	4142	. 'Telefone Comercial,Endereço Comercial,Complemento End. Comercial,CEP Comercial,Cidade End. Comercial,Estado End. Comercial,País End. Comercial,'
	4143	. 'Telefone Residencial,Endereço Residencial,Complemento End. Residencial,CEP Residencial,Cidade End. Residencial,Estado End. Residencial,País End. Residencial,'
	4144	. 'Aniversário,Sexo,Assinatura GPG,Notas,Página Web,Empresa,Cargo,Departamento,Fax Comercial,Pager Comercial,Celular Comercial,Fax,Pager,Endereço Comercial 2,Endereço Residencial 2'
	4145	. "\r\n";
[1599]	4146
[3322]	4147	foreach($contacts as $index => $object){
[5131]	4148	$stramArray[0] = "\"".$object[ 'names_ordered'] . "\"";
	4149	$stramArray[1] = "\"".$object[ 'alias' ] . "\"";
	4150	$stramArray[2] = "\"".$object[ 'main-mail' ] . "\"";
	4151	$stramArray[3] = "\"".$object[ 'alternative-mail' ] . "\"";
	4152	$stramArray[4] = "\"".$object[ 'mobile' ] . "\"";
	4153	$stramArray[5] = "\"".$object[ 'business-phone' ] . "\"";
	4154	$stramArray[6] = "\"".$object[ 'business-address' ] . "\"";
	4155	$stramArray[7] = "\"".$object[ 'business-complement' ] . "\"";
	4156	$stramArray[8] = "\"".$object[ 'business-postal_code' ] . "\"";
	4157	$stramArray[9] = "\"".$object[ 'business-city_name' ] . "\"";
	4158	$stramArray[10] = "\"".$object[ 'business-state_name' ] . "\"";
	4159	$stramArray[11] = "\"".$object[ 'business-id_country' ] . "\"";
	4160	$stramArray[12] = "\"".$object[ 'home-phone' ] . "\"";
	4161	$stramArray[13] = "\"".$object[ 'home-address' ] . "\"";
	4162	$stramArray[14] = "\"".$object[ 'home-complement' ] . "\"";
	4163	$stramArray[15] = "\"".$object[ 'home-postal_code' ] . "\"";
	4164	$stramArray[16] = "\"".$object[ 'home-city_name' ] . "\"";
	4165	$stramArray[17] = "\"".$object[ 'home-state_name' ] . "\"";
	4166	$stramArray[18] = "\"".$object[ 'home-id_country' ] . "\"";
	4167	$stramArray[19] = "\"".$object[ 'birthdate' ] . "\"";
	4168	$stramArray[20] = "\"".$object[ 'sex' ] . "\"";
	4169	$stramArray[21] = "\"".$object[ 'pgp_key' ] . "\"";
	4170	$stramArray[22] = "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\"";
	4171	$stramArray[23] = "\"".$object[ 'web_page' ] . "\"";
	4172	$stramArray[24] = "\"".$object[ 'corporate_name' ] . "\"";
	4173	$stramArray[25] = "\"".$object[ 'job_title' ] . "\"";
	4174	$stramArray[26] = "\"".$object[ 'department' ] . "\"";
	4175	$stramArray[27] = "\"".$object[ 'business-fax' ] . "\"";
	4176	$stramArray[28] = "\"".$object[ 'business-pager' ] . "\"";
	4177	$stramArray[29] = "\"".$object[ 'business-mobile' ] . "\"";
	4178	$stramArray[30] = "\"".$object[ 'home-fax' ] . "\"";
	4179	$stramArray[31] = "\"".$object[ 'home-pager' ] . "\"";
	4180	$stramArray[32] = "\"".$object[ 'business-address-2' ] . "\"";
	4181	$stramArray[33] = "\"".$object[ 'home-address-2' ] . "\"\r\n";
	4182
	4183	if($object[ 'phone' ]){
	4184	if(!$object[ 'home-phone' ])
	4185	$stramArray[12] = "\"".$object[ 'phone' ]. "\"";
	4186	else if(!$object[ 'mobile' ])
	4187	$stramArray[4] = "\"".$object[ 'phone' ]. "\"";
	4188	else if(!$object[ 'business-phone' ])
	4189	$stramArray[5] = "\"".$object[ 'phone' ]. "\"";
	4190	}
	4191
	4192	$streamBuffer .= implode("," , $stramArray);
[3322]	4193	}
	4194	break;
[5131]	4195
	4196	case 'outlook2003':
	4197	$streamBuffer = "\"Tratamento\",\"Primeiro nome\",\"Segundo Nome\",\"Sobrenome\",\"Sufixo\",".
	4198	"\"Empresa\",\"Departamento\",\"Cargo\",\"Business Street\",\"Rua do endereço comercial 2\",".
	4199	"\"Rua do endereço comercial 3\",\"Business City\",\"Business State\",".
	4200	"\"Business Postal Code\",\"Business Country\",\"Endereço residencial\",\"Endereço residencial 2\",".
	4201	"\"Endereço residencial 3\",\"Cidade do endereço residencial\",\"Estado\",\"CEP do endereço residencial\",\"País do endereço residencial\",".
	4202	"\"Outro endereço\",\"Outro endereço 2\",\"Outro endereço 3\",\"Cidade\",\"Estado\",\"CEP\",\"País\",".
	4203	"\"Telefone do assistente\",\"Fax comercial\",\"Telefone comercial\",\"Telefone comercial 2\",\"Retorno de chamada\",".
	4204	"\"Telefone do carro\",\"Telefone principal da empresa\",\"Fax residencial\",\"Telefone residencial\",".
	4205	"\"Telefone residencial 2\",\"ISDN\",\"Telefone celular\",\"Outro fax\",\"Outro telefone\",\"Pager\",\"Telefone principal\",".
	4206	"\"Radiofone\",\"Telefone TTY/TDD\",\"Telex\",\"Anotações\",\"Birthday\",\"Caixa postal de outro endereço\",\"Caixa postal do endereço comercial\",".
	4207	"\"Caixa postal do endereço residencial\",\"Categorias\",\"Código da empresa\",\"Código do governo\",\"Conta\",\"Datas especiais\",\"Disponibilidade da internet\",\"E-mail Address\",".
	4208	"\"Tipo de email\",\"Nome para exibição do email\",\"Endereço de email 2\",".
	4209	"\"Tipo de email 2\",\"Nome para exibição do email 2\",".
	4210	"\"Endereço de email 3\",\"Tipo de email 3\",\"Nome para exibição de email 3\",".
	4211	"\"Filhos\",\"Hobby\",\"Idioma\",\"Indicação\",\"Informações para cobrança\",\"Iniciais\",\"Local\",".
	4212	"\"Nome do assistente\",\"Nome do gerenciador\",\"Página da Web\",\"Palavras-chave\",\"Particular\",\"Personalizado 1\",\"Personalizado 2\",".
	4213	"\"Personalizado 3\",\"Personalizado 4\",\"Prioridade\",\"Profissão\",\"Quilometragem\",\"Sala\",\"Sensibilidade\",\"Servidor de diretório\",".
	4214	"\"Sexo\",\"Spouse\"\r\n";
	4215	foreach($contacts as $index => $object){
	4216	$stramArray[0] = "\"".$object[ 'alias' ] . "\"";
	4217	$stramArray[1] = "\"".$object[ 'names_ordered'] . "\"";
	4218	$stramArray[2] = "";
	4219	$stramArray[3] = "";
	4220	$stramArray[4] = "";
	4221	$stramArray[5] = "\"".$object[ 'corporate_name' ] . "\"";
	4222	$stramArray[6] = "\"".$object[ 'department' ] . "\"";
	4223	$stramArray[7] = "\"".$object[ 'job_title' ] . "\"";
	4224	$stramArray[8] = "\"".$object[ 'business-address' ] . "\"";
	4225	$stramArray[9] = "\"".$object[ 'business-address-2' ] . "\"";
	4226	$stramArray[10] = "";
	4227	$stramArray[11] = "\"".$object[ 'business-city_name' ] . "\"";
	4228	$stramArray[12] = "\"".$object[ 'business-state_name' ] . "\"";
	4229	$stramArray[13] = "\"".$object[ 'business-postal_code' ] . "\"";
	4230	$stramArray[14] = "\"".$object[ 'business-id_country' ] . "\"";
	4231	$stramArray[15] = "\"".$object[ 'home-address' ] . "\"";
	4232	$stramArray[16] = "\"".$object[ 'business-address-2' ] . "\"";
	4233	$stramArray[17] = "";
	4234	$stramArray[18] = "\"".$object[ 'home-city_name' ] . "\"";
	4235	$stramArray[19] = "\"".$object[ 'home-state_name' ] . "\"";
	4236	$stramArray[20] = "\"".$object[ 'home-postal_code' ] . "\"";
	4237	$stramArray[21] = "\"".$object[ 'home-id_country' ] . "\"";
	4238	$stramArray[22] = "";
	4239	$stramArray[23] = "";
	4240	$stramArray[24] = "";
	4241	$stramArray[25] = "\"".$object[ 'home-city_name' ] . "\"";
	4242	$stramArray[26] = "\"".$object[ 'home-state_name' ] . "\"";
	4243	$stramArray[27] = "\"".$object[ 'home-postal_code' ] . "\"";
	4244	$stramArray[28] = "\"".$object[ 'home-id_country' ] . "\"";
	4245	$stramArray[29] = "";
	4246	$stramArray[30] = "\"".$object[ 'business-fax' ] . "\"";
	4247	$stramArray[31] = "\"".$object[ 'business-phone' ] . "\"";
	4248	$stramArray[32] = "\"".$object[ 'mobile' ] . "\"";
	4249	$stramArray[33] = "";
	4250	$stramArray[34] = "";
	4251	$stramArray[35] = "";
	4252	$stramArray[36] = "\"".$object[ 'home-fax' ] . "\"";
	4253	$stramArray[37] = "\"".$object[ 'home-phone' ] . "\"";
	4254	$stramArray[38] = "";
	4255	$stramArray[39] = "";
	4256	$stramArray[40] = "\"".$object[ 'mobile' ] . "\"";
	4257	$stramArray[41] = "";
	4258	$stramArray[42] = "";
	4259	$stramArray[43] = "\"".$object[ 'home-pager' ] . "\"";
	4260	$stramArray[44] = "\"".$object[ 'phone' ] . "\"";
	4261	$stramArray[45] = "";
	4262	$stramArray[46] = "";
	4263	$stramArray[47] = "";
	4264	$stramArray[48] = "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\"";
	4265	$stramArray[49] = "\"".$object[ 'birthdate' ] . "\"";
	4266	$stramArray[50] = "";
	4267	$stramArray[51] = "";
	4268	$stramArray[52] = "";
	4269	$stramArray[53] = "";
	4270	$stramArray[54] = "";
	4271	$stramArray[55] = "";
	4272	$stramArray[56] = "";
	4273	$stramArray[57] = "";
	4274	$stramArray[58] = "";
	4275	$stramArray[59] = "\"".$object[ 'main-mail' ] . "\"";
	4276	$stramArray[60] = "";
	4277	$stramArray[61] = "";
	4278	$stramArray[62] = "\"".$object[ 'alternative-mail' ] . "\"";
	4279	$stramArray[63] = "";
	4280	$stramArray[64] = "";
	4281	$stramArray[65] = "";
	4282	$stramArray[66] = "";
	4283	$stramArray[67] = "";
	4284	$stramArray[68] = "";
	4285	$stramArray[69] = "";
	4286	$stramArray[70] = "";
	4287	$stramArray[71] = "";
	4288	$stramArray[72] = "";
	4289	$stramArray[73] = "";
	4290	$stramArray[74] = "";
	4291	$stramArray[75] = "";
	4292	$stramArray[76] = "";
	4293	$stramArray[77] = "\"".$object[ 'web_page' ] . "\"";
	4294	$stramArray[78] = "";
	4295	$stramArray[79] = "";
	4296	$stramArray[80] = "";
	4297	$stramArray[81] = "";
	4298	$stramArray[82] = "";
	4299	$stramArray[83] = "";
	4300	$stramArray[84] = "";
	4301	$stramArray[85] = "";
	4302	$stramArray[86] = "";
	4303	$stramArray[87] = "";
	4304	$stramArray[88] = "";
	4305	$stramArray[89] = "";
	4306	$stramArray[90] = "\"".$object[ 'sex' ] . "\"";
	4307	$stramArray[91] = "\r\n";
	4308
	4309	$streamBuffer .= implode("," , $stramArray);
	4310	}
	4311	break;
[1599]	4312
[2]	4313	}
	4314
	4315	$file = "contacts_".md5(microtime()).".swp";
[5131]	4316	$tempDir = $GLOBALS['phpgw_info']['server']['temp_dir'];
[2]	4317	$f = fopen($tempDir.'/'.$file,"w");
	4318	if(!$f)
	4319	echo null;
[1599]	4320
[2]	4321	fputs($f,$streamBuffer);
	4322	fclose($f);
	4323
	4324	echo $tempDir.'/'.$file;
	4325	}
	4326
[285]	4327	// Get the csv field and put into array, from php.net
	4328	function parse_line($input_text, $delimiter = ',', $text_qualifier = '"') {
	4329	$text = trim($input_text);
	4330	if(is_string($delimiter) && is_string($text_qualifier)) {
	4331	$re_d = '\x' . dechex(ord($delimiter)); //format for regexp
	4332	$re_tq = '\x' . dechex(ord($text_qualifier)); //format for regexp
[1599]	4333
[285]	4334	$fields = array();
	4335	$field_num = 0;
	4336	while(strlen($text) > 0) {
	4337	if($text{0} == $text_qualifier) {
	4338	preg_match('/^' . $re_tq . '((?:[^' . $re_tq . ']\|(?<=\x5c)' . $re_tq . '))' . $re_tq . $re_d . '?(.)$/', $text, $matches);
[1599]	4339
[285]	4340	$value = str_replace('\\' . $text_qualifier, $text_qualifier, $matches[1]);
	4341	$text = trim($matches[2]);
[1599]	4342
[7655]	4343	$fields[++$field_num] = $value;
[285]	4344	} else {
	4345	preg_match('/^([^' . $re_d . '])' . $re_d . '?(.)$/', $text, $matches);
[1599]	4346
[285]	4347	$value = $matches[1];
	4348	$text = trim($matches[2]);
[1599]	4349
[7655]	4350	$fields[++$field_num] = $value;
[285]	4351	}
	4352	}
	4353	return $fields;
	4354	} else
	4355	return false;
	4356	}
[16]	4357
[1599]	4358	//funcao alterada para importar outros campos alem de nome, telefone e email, de arquivo csv (Outlook 2000)
	4359	//em 08/04/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
	4360	//Foi adicionada uma funcao (escapesheelcmd()) nas variaveis para que caracteres especiais sejam ignorados
	4361	//durante a importacao dos contatos; o processo estava travando por causa de caracteres em campos como nome,
	4362	//sobrenome, notas e e-mail;
	4363	//em 19/06/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
[5131]	4364	function import_contacts($typeImport, $id_group=false)
	4365	{
[3334]	4366	$this->so_group = CreateObject('contactcenter.so_group');
[5131]	4367	if($file = $_SESSION['contactcenter']['importCSV'])
	4368	{
[1599]	4369	unset($_SESSION['contactcenter']['importCSV']);
[2]	4370	$len = filesize($file);
	4371	$count = 0;
	4372	$return = array('error' => false, '_new' => 0, '_existing' => 0, '_failure' => 0);
[276]	4373	$handle = @fopen($file, "r") or die(serialize($return['error'] = true));
[1599]	4374
[285]	4375	$input_header = fgets($handle);
	4376	if ($typeImport == 'outlook')
	4377	$delim = ';';
[5131]	4378	else if ($typeImport == 'auto' \|\| $typeImport== 'thunderbird')
[285]	4379	$delim = strstr($input_header,',') ? ',' : ';';
[1599]	4380	else
[285]	4381	$delim = ',';
	4382	$csv_header = $this->parse_line($input_header,$delim);
	4383	$firstContact = fgets($handle);
	4384	preg_match("/\"(.+)\"[,;]/sU",$firstContact,$matches); // yahoo csv
[1599]	4385	rewind($handle);
[285]	4386
[2]	4387	$header = @fgetcsv($handle, $len, $delim) or die(serialize($return['error'] = true));
[15]	4388	if(count($header) < 2 \|\| count($header) > 100) {
[2]	4389	$return['error'] = true;
	4390	$return['sizeheader'] = count($header);
	4391	echo serialize($return);
	4392	return;
	4393	}
[1599]	4394
[285]	4395	if ($matches[0][strlen($matches[0])-1] == ';')
	4396	$delim = ';';
[1599]	4397
[3322]	4398	$boGroup = CreateObject('contactcenter.bo_group');
	4399	$boPeople = CreateObject('contactcenter.bo_people_catalog');
	4400	switch($typeImport){
	4401	case 'outlook2000':
	4402	$name_pos=1;
	4403	$name2_pos=2;
	4404	$name3_pos=3;
	4405	$corporate_street_pos=8;
	4406	$cep_pos=13;
	4407	$corporate_street_2_pos=22;
	4408	$fax_pos=30;
	4409	$phone_pos=31;
	4410	$home_phone_pos=37;
	4411	$personal_cell_pos=40;
	4412	$pager_pos=43;
	4413	$birth_pos=48;
	4414	$notes_pos=49;
	4415	$email_pos=56;
	4416	$aditionalEmail_pos=59;
[1599]	4417
[3322]	4418	break;
	4419	case 'outlook':
[5131]	4420	$name_pos=0;
	4421	$email_pos=2;
	4422	$phone_pos=8;
	4423	$home_phone_pos=9;
	4424	$personal_cell_pos=10;
	4425	$corporate_street_pos=12;
	4426	$cep_pos=14;
	4427	$corporate_phone_pos=18;
[3322]	4428	$fax_pos=19;
	4429	$pager_pos=20;
	4430	$notes_pos=25;
	4431	break;
	4432	case 'thunderbird':
	4433	$name_pos=2;
[5131]	4434	$alias_pos=3;
	4435	//MAILS
[3322]	4436	$email_pos=4;
[5131]	4437	$aditionalEmail_pos=5;
	4438
	4439	//PHONES
	4440	$corporate_phone_pos=7;
	4441	$main_phone_pos=8;
	4442	$home_phone_pos=8;
	4443	$fax_pos=9;
	4444	$pager_pos=10;
	4445	$personal_cell_pos=11;
	4446
	4447	//ADRESS
	4448	$street_pos=12;
	4449	$street_2_pos = 13;
	4450	$city_pos=14;
	4451	$state_pos=15;
	4452	$cep_pos=16;
	4453	$country_pos=17;
	4454
	4455	//CORPORATE ADRESS
	4456	$corporate_street_pos=18;
	4457	$corporate_city_pos=20;
	4458	$corporate_state_pos=21;
	4459	$corporate_cep_pos=22;
	4460	$corporate_country_pos=23;
	4461
	4462	//CORPORATE DETAILS
	4463	$job_title_pos=24;
	4464	$department_pos=25;
	4465	$corporate_name_pos=26;
	4466
	4467	$notes_pos=36;
[3322]	4468	break;
[5131]	4469	case 'outlook2003':
	4470	$alias_pos=0;
	4471	$name_pos=1;
	4472	//CORPORATE DETAILS
	4473	$corporate_name_pos=5;
	4474	$department_pos=6;
	4475	$job_title_pos=7;
	4476	//CORPORATE ADRESS
	4477	$corporate_comp_pos=7;
	4478	$corporate_street_pos=8;
	4479	$street_2_pos = 9;
	4480	$corporate_city_pos=11;
	4481	$corporate_state_pos=12;
	4482	$corporate_cep_pos=13;
	4483	$corporate_country_pos=14;
	4484	//HOME ADRESS
	4485	$street_pos=13;
	4486	$comp_pos=14;
	4487	$cep_pos=15;
	4488	$city_pos=16;
	4489	$state_pos=17;
	4490	$country_pos=18;
	4491	//PHONE's
	4492	$corporate_phone_pos=31;
	4493	$fax_pos=36;
	4494	$home_phone_pos=37;
	4495	$pager_pos=43;
	4496	$main_phone_pos=44;
	4497	//OTHER's
	4498	$notes_pos=48;
	4499	$birth_pos=49;
	4500	//EMAIL's
	4501	$email_pos=59;
	4502	$aditionalEmail_pos=62;
	4503	break;
[3322]	4504	case 'expresso':
	4505	$name_pos=0;
	4506	$alias_pos=1;
	4507	$email_pos=2;
	4508	$aditionalEmail_pos=3;
	4509	$personal_cell_pos=4;
	4510	$corporate_phone_pos=5;
	4511	$corporate_street_pos=6;
	4512	$corporate_comp_pos=7;
	4513	$corporate_cep_pos=8;
	4514	$corporate_city_pos=9;
	4515	$corporate_state_pos=10;
	4516	$corporate_country_pos=11;
	4517	$home_phone_pos=12;
	4518	$street_pos=13;
	4519	$comp_pos=14;
	4520	$cep_pos=15;
	4521	$city_pos=16;
	4522	$state_pos=17;
	4523	$country_pos=18;
	4524	$birth_pos=19;
	4525	$sex_pos = 20;
	4526	$pgp_key_pos = 21;
	4527	$notes_pos=22;
	4528	$web_page_pos=23;
	4529	$corporate_name_pos=24;
	4530	$job_title_pos=25;
	4531	$department_pos=26;
	4532	$corporate_fax_pos=27;
	4533	$corporate_pager_pos=28;
	4534	$corporate_cell_pos=29;
	4535	$fax_pos=30;
	4536	$pager_pos=31;
	4537	$corporate_street_2_pos = 32;
	4538	$street_2_pos = 33;
	4539	break;
[285]	4540	default:
[3322]	4541	foreach($csv_header as $index => $fieldName)
	4542	{
	4543	switch($fieldName){
	4544	case 'Name':
	4545	case 'Nome':
	4546	case 'First Name':
	4547	$name_pos = $index;
	4548	break;
	4549	case 'Second name':
	4550	case 'Segundo nome':
	4551	$name2_pos = $index;
	4552	break;
	4553	case 'Sobrenome':
	4554	case 'Surname':
	4555	$name3_pos = $index;
	4556	break;
	4557	case 'Business Street':
	4558	case 'Rua do endereço comercial':
	4559	$corporate_street_pos = $index;
	4560	break;
	4561	case 'Rua do endereço comercial 2':
	4562	case 'Outro endereço':
	4563	$corporate_street_2_pos = $index;
	4564	break;
	4565	case 'Business Postal Code':
	4566	case 'CEP do endereço comercial':
	4567	$cep_pos = $index;
	4568	break;
	4569	case 'Business Fax':
	4570	case 'Fax comercial':
	4571	case 'Fax':
	4572	$fax_pos = $index;
	4573	break;
	4574	case 'Home Phone':
	4575	case 'Telefone residencial':
	4576	$home_phone_pos = $index;
	4577	break;
	4578	case 'Mobile phone':
	4579	case 'Telefone celular':
	4580	$personal_cell_pos = $index;
	4581	break;
	4582	case 'Pager':
	4583	$pager_pos = $index;
	4584	break;
	4585	case 'Phone':
	4586	case 'Business Phone':
	4587	case 'Telefone':
	4588	case 'Telefone principal':
	4589	case 'Telefone comercial':
[4753]	4590	case 'Telefone Comercial':
[3322]	4591	$phone_pos = $index;
	4592	break;
	4593	case 'Aniversário':
	4594	case 'Birthdate':
	4595	$birth_pos = $index;
	4596	case 'Anotações':
	4597	case 'Notes':
	4598	$notes_pos = $index;
	4599	case 'E-mail':
	4600	case 'Email':
	4601	case 'E-mail Address':
	4602	case 'Endereço de correio eletrônico':
	4603	case 'End. de email':
	4604	$email_pos = $index;
	4605	break;
	4606	case 'Endereço de correio eletrônico 2':
	4607	$aditionalEmail_pos = $index;
	4608	break;
	4609	}
[285]	4610	}
[3322]	4611	break;
[15]	4612	}
[276]	4613
[5131]	4614
	4615
	4616	while (($data = fgetcsv($handle, $len, $delim)))
	4617	{
[3322]	4618	foreach ($header as $key=>$heading)
[2]	4619	$row[$heading]=(isset($data[$key])) ? $data[$key] : '';
[1599]	4620
[3322]	4621	$sdata = array();
[5131]	4622	$full_name = addslashes(trim($row[$header[$name_pos]]));
	4623	$email = addslashes(trim($row[$header[$email_pos]]));
	4624	$phone = addslashes(trim($row[$header[$main_phone_pos]]));
	4625	$name2 = addslashes(trim($row[$header[$name2_pos]]));
	4626	$name3 = addslashes(trim($row[$header[$name3_pos]]));
	4627	$birth = addslashes(trim($row[$header[$birth_pos]]));
	4628	$notes = addslashes(trim($row[$header[$notes_pos]]));
	4629	$altEmail = addslashes(trim($row[$header[$altEmail_pos]]));
	4630	$sdata['alias'] = addslashes(trim($row[$header[$alias_pos]]));
	4631	$sdata['corporate_name'] = addslashes(trim($row[$header[$corporate_name_pos]]));
	4632	$sdata['job_title'] = addslashes(trim($row[$header[$job_title_pos]]));
	4633	$sdata['department'] = addslashes(trim($row[$header[$department_pos]]));
	4634	$sdata['web_page'] = addslashes(trim($row[$header[$web_page_pos]]));
	4635	$sdata['sex'] = addslashes(trim($row[$header[$sex_pos]]));
	4636	$sdata['pgp_key'] = addslashes(trim($row[$header[$pgp_key_pos]]));
[3322]	4637
[2]	4638	$array_name = explode(' ', str_replace('"','',(str_replace('\'','',$full_name))));
[3476]	4639	$sdata['given_names'] = addslashes($array_name[0]);
[2]	4640	$array_name[0] = null;
	4641	$sdata['family_names'] = trim(implode(' ',$array_name));
[1599]	4642	if($sdata['family_names'] == '')
	4643	{
[3476]	4644	$sdata['family_names'] = addslashes($name2) . " " . addslashes($name3);
[1599]	4645	}
[3476]	4646
[3322]	4647	$sdata['connections']['default_email']['connection_name'] = lang('Main');
[3476]	4648	$sdata['connections']['default_email']['connection_value'] = addslashes($email);
[3322]	4649	$sdata['connections']['aditional_email']['connection_name'] = "Alternativo";
	4650	$sdata['connections']['aditional_email']['connection_value'] = trim($row[$header[$aditionalEmail_pos]]);
[1599]	4651
[3322]	4652	$sdata['connections']['default_phone']['connection_name'] = lang('Main');
[4753]	4653	$sdata['connections']['default_phone']['connection_value'] = $phone;
[2]	4654
[4753]	4655	if( trim($row[$header[$home_phone_pos]]) != "" )
[4288]	4656	{
	4657	$sdata['connections']['aditional_phone']['home_phone']['connection_name'] = 'Casa';
	4658	$sdata['connections']['aditional_phone']['home_phone']['connection_value'] = trim($row[$header[$home_phone_pos]]);
	4659	}
[1599]	4660
[4288]	4661	if( trim($row[$header[$personal_cell_pos]]) != "" )
	4662	{
	4663	$sdata['connections']['aditional_phone']['cellphone']['connection_name'] = 'Celular';
	4664	$sdata['connections']['aditional_phone']['cellphone']['connection_value'] = trim($row[$header[$personal_cell_pos]]);
	4665	}
	4666
	4667	if( trim($row[$header[$corporate_phone_pos]]) != "")
	4668	{
	4669	$sdata['connections']['aditional_phone']['corporate_phone']['connection_name'] = 'Trabalho';
	4670	$sdata['connections']['aditional_phone']['corporate_phone']['connection_value'] = trim($row[$header[$corporate_phone_pos]]);
	4671	}
	4672
	4673	if( trim($row[$header[$fax_pos]]) != "" )
	4674	{
	4675	$sdata['connections']['aditional_phone']['fax']['connection_name'] = 'Fax';
	4676	$sdata['connections']['aditional_phone']['fax']['connection_value'] = trim($row[$header[$fax_pos]]);
	4677	}
	4678
	4679	if ($GLOBALS['phpgw_info']['server']['personal_contact_type'] == 'True')
	4680	{
	4681	if( trim($row[$header[$pager_pos]]) != "" )
	4682	{
	4683	$sdata['connections']['aditional_phone']['pager']['connection_name'] = 'Pager';
	4684	$sdata['connections']['aditional_phone']['pager']['connection_value'] = trim($row[$header[$pager_pos]]);
	4685	}
	4686
	4687	if( trim($row[$header[$corporate_fax_pos]]) != "" )
	4688	{
	4689	$sdata['connections']['aditional_phone']['corporate_fax']['connection_name'] = 'Fax Corporativo';
	4690	$sdata['connections']['aditional_phone']['corporate_fax']['connection_value'] = trim($row[$header[$corporate_fax_pos]]);
	4691	}
	4692
	4693	if( trim($row[$header[$corporate_cell_pos]]) != "" )
	4694	{
	4695	$sdata['connections']['aditional_phone']['corporate_cell']['connection_name'] = 'Celular Corporativo';
	4696	$sdata['connections']['aditional_phone']['corporate_cell']['connection_value'] = trim($row[$header[$corporate_cell_pos]]);
	4697	}
	4698
	4699	if( trim($row[$header[$corporate_pager_pos]]) != "" )
	4700	{
	4701	$sdata['connections']['aditional_phone']['corporate_pager']['connection_name'] = 'Pager Corporativo';
	4702	$sdata['connections']['aditional_phone']['corporate_pager']['connection_value'] = trim($row[$header[$corporate_pager_pos]]);
	4703	}
	4704	}
[4753]	4705
[3322]	4706	$sdata['addresses']['address_corporative']['address1'] = trim($row[$header[$corporate_street_pos]]);
	4707	$sdata['addresses']['address_corporative']['address2'] = trim($row[$header[$corporate_street_2_pos]]);
	4708	$sdata['addresses']['address_corporative']['complement'] = trim($row[$header[$corporate_comp_pos]]);
[4753]	4709	$sdata['addresses']['address_corporative']['postal_code'] = trim($row[$header[$corporate_cep_pos]]);
[3322]	4710	$sdata['addresses']['address_corporative']['id_country'] = "BR";
[4753]	4711	$sdata['addresses']['address_corporative']['id_state'] = trim($row[$header[$corporate_state_pos]]);
[3322]	4712	$sdata['addresses']['address_corporative']['id_city'] = trim($row[$header[$corporate_city_pos]]);
[4753]	4713
	4714
[3322]	4715	$sdata['addresses']['address_personal']['address1'] = trim($row[$header[$street_pos]]);
	4716	$sdata['addresses']['address_personal']['address2'] = trim($row[$header[$street_2_pos]]);
	4717	$sdata['addresses']['address_personal']['complement'] = trim($row[$header[$comp_pos]]);
	4718	$sdata['addresses']['address_personal']['postal_code'] = trim($row[$header[$cep_pos]]);
[4753]	4719	$sdata['addresses']['address_personal']['id_country'] = "BR";
	4720	$sdata['addresses']['address_personal']['id_state'] = trim($row[$header[$state_pos]]);
[3322]	4721	$sdata['addresses']['address_personal']['id_city'] = trim($row[$header[$city_pos]]);
[1599]	4722
[5131]	4723	if(trim($birth))
	4724	{
[4085]	4725	$array_birth = explode("/",trim($birth));
	4726	$sdata['birthdate'] = date('Y-m-d', mktime(0,0,0,$array_birth[1],$array_birth[0],$array_birth[2]));
	4727	}
[1599]	4728
[3476]	4729	$sdata['notes'] = addslashes($notes);
[3322]	4730	//$sdata['is_quick_add'] = true;
[16]	4731	$sdata['connections']['default_phone']['connection_value'] = $phone;
[5131]	4732	if(!$phone){
[1599]	4733
[5131]	4734	}
[4753]	4735	// verifica se email já existe!
[3476]	4736	$email = addslashes($email);
[5131]	4737	$contact = false;
	4738	$contact = $boGroup->verify_contact($email, $full_name, $phone);
	4739	if(!$sdata['given_names'] && $email)
	4740	{
[285]	4741	$a_email = explode("@",$email);
[3476]	4742	$sdata['given_names'] = addslashes($a_email[0]);
[285]	4743	}
[2]	4744
[1599]	4745	$line_iteration = $return['_failure'] + $return['_existing'] + $return['_new'];
	4746
[5131]	4747	if($contact[0] != null)
	4748	{
[2]	4749	$return['_existing']++;
[4753]	4750	}
[5928]	4751	else if((!preg_match('/^[a-zA-Z0-9][_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]{1,})$/i', $email)) && $email) {
[2]	4752	$return['_failure']++;
[285]	4753	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid E-Mail address: " . $email ."<br>";
[16]	4754	}
[3237]	4755	else if (!$sdata['given_names'] \|\| !$boPeople ->quick_add($sdata)){
[1599]	4756	$return['_failure']++;
[285]	4757	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid Name: " . $sdata['given_names'] ."<br>";
[2]	4758	}
[4753]	4759	else{
	4760	if($id_group != 0){
[3334]	4761	$this->so_group->add_user_by_name($id_group,$full_name);
[4753]	4762	}
[3334]	4763	$return['_new']++;
	4764	}
[1599]	4765	}
[2]	4766	fclose($handle);
[15]	4767	unlink($file);
[2]	4768	}
	4769	else
	4770	$return['error'] = true;
	4771
	4772	echo serialize($return);
	4773	}
[5131]	4774
	4775	function get_contact_details($id)
	4776	{
	4777	$data = array();
	4778
	4779	if(!$this->bo->catalog->src_info) {
	4780	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	4781	$this->bo->catalog->src_info = $ldap->srcs[1];
	4782	}
	4783	//$id = urlencode($id);
	4784	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
	4785	$dn=$this->bo->catalog->src_info['dn'];
	4786
	4787	//buscar os atributos do ldap
	4788	$configobj = CreateObject('phpgwapi.config', 'contactcenter');
	4789	$prefs = $configobj->read_repository();
	4790	$attr_names = array();
	4791	$attr_types = array();
	4792	$justThese = array();
	4793	foreach ($prefs as $pref_key => $pref_value)
	4794	{
	4795	if (stripos($pref_key, "cc_attribute_name_") !== false)
	4796	{
	4797	$num = substr($pref_key, strlen("cc_attribute_name_"));
	4798	$attr_names[] = $prefs["cc_attribute_name_$num"];
	4799	$attr_types[] = $prefs["cc_attribute_type_$num"];
	4800	$justThese[] = strtolower($prefs["cc_attribute_ldapname_$num"]);
	4801	}
	4802	}
	4803
	4804
	4805
	4806	$sr = ldap_read($ds,utf8_encode($id), "objectClass=*",$justThese);
	4807	$info = ldap_get_entries($ds, $sr);
	4808	if ($info)
	4809	{
[7673]	4810	$justThese_count = count($justThese);
	4811	for ($i = 0; $i < $justThese_count; ++$i)
[5131]	4812	{
	4813	$attr = array();
	4814	$attr['name'] = $attr_names[$i];
	4815	if ($attr_types[$i] == 'multivalues')
	4816	{
	4817	$attr['type'] = 'multivalues';
	4818	$attr['value'] = array();
[7655]	4819	for ($j = 0; $j < $info[0][$justThese[$i]]['count']; ++$j)
[5131]	4820	$attr['value'][] = utf8_decode($info[0][$justThese[$i]][$j]);
	4821	}
	4822	else
	4823	{
	4824	$attr['type'] = 'text';
	4825	$attr['value'] = utf8_decode($info[0][$justThese[$i]][0]);
	4826	}
	4827	$data[] = $attr;
	4828	}
	4829	}
	4830	else
	4831	$data = 'error';
	4832	ldap_close($ds);
	4833
	4834	echo serialize($data);
	4835	}
	4836
[2]	4837	}
	4838
	4839	?>

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

Context Navigation

source: trunk/contactcenter/inc/class.ui_data.inc.php @ 7673

Download in other formats: