Context Navigation

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

Revision 1599, 116.1 KB checked in by rafaelraymundo, 15 years ago (diff)
Ticket #719 - Adicionados campos para importacao de contatos no Outlook Express
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,
	21	);
[1599]	22
[2]	23	var $bo;
	24	var $typeContact;
[1599]	25
[2]	26	var $page_info = array(
	27	'n_cards' => 20,
	28	'n_pages' => false,
	29	'actual_letter' => 'A',
	30	'actual_page' => 1,
	31	'actual_entries' => false,
	32	'changed' => false,
	33	'catalogs' => false,
	34	'actual_catalog' => false
	35	);
[1599]	36
[2]	37	/*!
[1599]	38
[2]	39	@function ui_data
	40	@abstract The constructor. Sets the initial parameters and loads
	41	the data saved in the session
	42	@author Raphael Derosso Pereira
[1599]	43
[2]	44	*/
	45	function ui_data()
	46	{
	47	$temp = $GLOBALS['phpgw']->session->appsession('ui_data.page_info','contactcenter');
	48	$temp2 = $GLOBALS['phpgw']->session->appsession('ui_data.all_entries','contactcenter');
[1599]	49
[2]	50	$this->bo = CreateObject('contactcenter.bo_contactcenter');
[1599]	51
[2]	52	if ($temp)
	53	{
	54	$this->page_info = $temp;
	55	}
	56
	57	if ($temp2)
	58	{
	59	$this->all_entries = $temp2;
	60	}
[1599]	61
[2]	62	if (!$this->page_info['actual_catalog'])
	63	{
	64	$catalogs = $this->bo->get_catalog_tree();
	65	$this->page_info['actual_catalog'] = $catalogs[0];
	66	}
[1599]	67
	68	$this->page_info['actual_catalog'] =& $this->bo->set_catalog($this->page_info['actual_catalog']);
	69
	70
[2]	71	if($this->page_info['actual_catalog']['class'] == 'bo_group_manager')
	72	$this -> typeContact = 'groups';
[1599]	73	/rev 104/
[752]	74	else if($this->page_info['actual_catalog']['class'] == 'bo_shared_group_manager')
	75	$this -> typeContact = 'shared_groups';
	76	else if($this->page_info['actual_catalog']['class'] == 'bo_shared_people_manager')
	77	$this -> typeContact = 'shared_contacts';
[1599]	78	/******/
[2]	79	else
	80	$this -> typeContact = 'contacts';
	81	}
	82
	83	/*!
[1599]	84
[2]	85	@function index
	86	@abstract Builds the Main Page
	87	@author Raphael Derosso Pereira
	88	@author Jonas Goes
[1599]	89
	90	*/
[2]	91	function index()
[1599]	92	{
[2]	93	if(!@is_object($GLOBALS['phpgw']->js))
	94	{
	95	$GLOBALS['phpgw']->js = CreateObject('phpgwapi.javascript');
	96	}
	97	$GLOBALS['phpgw']->js->validate_file('venus','table');
	98	$GLOBALS['phpgw']->js->validate_file('venus','shapes');
	99	$GLOBALS['phpgw']->js->validate_file('venus','jsStructUtil');
	100	$GLOBALS['phpgw']->js->validate_file('venus','cssUtil');
[1599]	101
[2]	102	// $GLOBALS['phpgw']->js->set_onload('setTimeout(\'updateCards()\',1000)');
	103	$GLOBALS['phpgw']->common->phpgw_header();
[1599]	104
[2]	105	$GLOBALS['phpgw']->template->set_file(array('index' => 'index.tpl'));
	106	$GLOBALS['phpgw']->template->set_var('cc_root_dir', $GLOBALS['phpgw_info']['server']['webserver_url'].'/contactcenter/');
[1599]	107
[2]	108	/* Quick Add */
	109	$GLOBALS['phpgw']->template->set_var('cc_qa_alias',lang('Alias').':');
	110	$GLOBALS['phpgw']->template->set_var('cc_qa_given_names',lang('Given Names').':');
	111	$GLOBALS['phpgw']->template->set_var('cc_qa_family_names',lang('Family Names').':');
	112	$GLOBALS['phpgw']->template->set_var('cc_qa_phone',lang('Phone').':');
	113	$GLOBALS['phpgw']->template->set_var('cc_qa_email',lang('Email').':');
	114	$GLOBALS['phpgw']->template->set_var('cc_qa_save',lang('Save'));
	115	$GLOBALS['phpgw']->template->set_var('cc_qa_clear',lang('Clear'));
[285]	116	$GLOBALS['phpgw']->template->set_var('cc_qa_close',lang('Close'));
[2]	117	/* End Quick Add */
[1599]	118
[2]	119	$cc_css_file = $GLOBALS['phpgw_info']['server']['webserver_url'].'/contactcenter/styles/cc.css';
	120	$cc_card_image_file = $GLOBALS['phpgw_info']['server']['webserver_url'].'/contactcenter/templates/default/images/card.png';
	121	$GLOBALS['phpgw']->template->set_var('cc_css',$cc_css_file);
	122	$GLOBALS['phpgw']->template->set_var('cc_dtree_css', $cc_dtree_file);
	123	$GLOBALS['phpgw']->template->set_var('cc_card_image',$cc_card_image_file);
[1599]	124
[2]	125	$GLOBALS['phpgw']->template->set_var('cc_personal',lang('Personal'));
[1599]	126
	127	/*rev 104*/
	128	//$GLOBALS['phpgw']->template->set_var('cc_full_add',lang('Full Add'));
[575]	129	$GLOBALS['phpgw']->template->set_var('cc_full_add_button',lang('Full Add'));
[1599]	130	/******/
	131	$GLOBALS['phpgw']->template->set_var('cc_full_add_button_sh',lang('Full Add Shared'));
[2]	132	$GLOBALS['phpgw']->template->set_var('cc_reset',lang('Reset'));
[1599]	133
[2]	134	$GLOBALS['phpgw']->template->set_var('cc_personal_data',lang('Personal Data'));
	135	$GLOBALS['phpgw']->template->set_var('cc_addresses',lang('Addresses'));
	136	$GLOBALS['phpgw']->template->set_var('cc_connections',lang('Connections'));
	137	$GLOBALS['phpgw']->template->set_var('cc_relations',lang('Relations'));
	138
	139	$GLOBALS['phpgw']->template->set_var('cc_quick_add',lang('Quick Add'));
	140	$GLOBALS['phpgw']->template->set_var('cc_catalogs',lang('Catalogues'));
	141	$GLOBALS['phpgw']->template->set_var('cc_group_add',lang('Group Add'));
[1599]	142
[2]	143	/* Panel */
	144	$GLOBALS['phpgw']->template->set_var('cc_panel_new',lang('New').'...');
	145	$GLOBALS['phpgw']->template->set_var('cc_panel_search',lang('Search').'...');
	146	$GLOBALS['phpgw']->template->set_var('cc_panel_table',lang('Table View'));
	147	$GLOBALS['phpgw']->template->set_var('cc_panel_cards',lang('Cards View'));
[285]	148	$GLOBALS['phpgw']->template->set_var('cc_btn_import_export', lang('Import/Export'));
	149	$GLOBALS['phpgw']->template->set_var('cc_btn_new', lang("New..."));
[1599]	150
[2]	151	$GLOBALS['phpgw']->template->set_var('cc_panel_search_found',lang('Showing found entries'));
	152	$GLOBALS['phpgw']->template->set_var('cc_panel_first_page',lang('First Page'));
	153	$GLOBALS['phpgw']->template->set_var('cc_panel_previous_page',lang('Previous Page'));
	154	$GLOBALS['phpgw']->template->set_var('cc_panel_next_page',lang('Next Page'));
	155	$GLOBALS['phpgw']->template->set_var('cc_panel_last_page',lang('Last Page'));
	156	$GLOBALS['phpgw']->template->set_var('cc_all',lang('all'));
	157	/* End Panel */
[1599]	158
[2]	159	/* Messages */
[1599]	160	/rev 104/
[503]	161	$GLOBALS['phpgw']->template->set_var('cc_msg_not_allowed',lang('Not Allowed'));
[1599]	162	$GLOBALS['phpgw']->template->set_var('cc_msg_unavailable',lang('Unavailable function'));
	163	/*****/
[2]	164	$GLOBALS['phpgw']->template->set_var('cc_msg_no_cards',lang('No Cards'));
	165	$GLOBALS['phpgw']->template->set_var('cc_msg_err_no_room',lang('No Room for Cards! Increase your browser area.'));
	166	$GLOBALS['phpgw']->template->set_var('cc_msg_card_new',lang('New from same Company'));
	167	$GLOBALS['phpgw']->template->set_var('cc_msg_card_edit',lang('Edit Contact'));
	168	$GLOBALS['phpgw']->template->set_var('cc_msg_card_remove',lang('Remove Contact'));
	169	$GLOBALS['phpgw']->template->set_var('cc_send_mail',lang('Send Mail'));
	170	$GLOBALS['phpgw']->template->set_var('cc_msg_group_edit',lang('Edit Group'));
	171	$GLOBALS['phpgw']->template->set_var('cc_msg_group_remove',lang('Remove Group'));
	172	$GLOBALS['phpgw']->template->set_var('cc_msg_group_remove_confirm',lang('Confirm Removal of this Group?'));
	173	$GLOBALS['phpgw']->template->set_var('cc_msg_card_remove_confirm',lang('Confirm Removal of this Contact?'));
	174	$GLOBALS['phpgw']->template->set_var('cc_participants',lang('Participants'));
	175	$GLOBALS['phpgw']->template->set_var('cc_empty',lang('Empty'));
	176	/* End Messages */
[1599]	177
[2]	178	$GLOBALS['phpgw']->template->set_var('cc_results',lang('Results'));
	179	$GLOBALS['phpgw']->template->set_var('cc_is_my',lang('Is My'));
[285]	180	$GLOBALS['phpgw']->template->set_var('cc_ie_personal',lang('Import/Export pesonal contacts'));
[2]	181	$GLOBALS['phpgw']->template->set_var('cc_btn_search',lang('Search'));
	182	$GLOBALS['phpgw']->template->set_var('cc_add_relation',lang('Add Relation'));
[1599]	183	$GLOBALS['phpgw']->template->set_var('cc_del_relation',lang('Remove Selected Relations'));
[38]	184	$GLOBALS['phpgw']->template->set_var('cc_msg_group',lang('Group'));
	185	$GLOBALS['phpgw']->template->set_var('cc_msg_contact_full',lang('Contact [Full]'));
[1496]	186	$GLOBALS['phpgw']->template->set_var('cc_msg_contact_sh',lang('Contact [Shared]'));
[38]	187	$GLOBALS['phpgw']->template->set_var('cc_msg_contact_qa',lang('Contact [Quick Add]'));
[2]	188	$GLOBALS['phpgw']->template->set_var('cc_contact_title',lang('Contact Center').' - '.lang('Contacts'));
	189	$GLOBALS['phpgw']->template->set_var('cc_window_views_title',lang('Contact Center').' - '.lang('Views'));
	190	$GLOBALS['phpgw']->template->set_var('phpgw_img_dir', $GLOBALS['phpgw_info']['server']['webserver_url'] . '/phpgwapi/images');
[118]	191
[285]	192	$GLOBALS['phpgw']->template->set_var('cc_msg_import_contacts', lang('Import Contacts'));
	193	$GLOBALS['phpgw']->template->set_var('cc_msg_export_contacts', lang('Export Contacts'));
	194	$GLOBALS['phpgw']->template->set_var('cc_msg_expresso_info_csv', lang('The Expresso supports the contacts importation in the CSV file format.'));
	195	$GLOBALS['phpgw']->template->set_var('cc_msg_choose_file_type', lang('Select the file type'));
	196	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_express', lang('Outlook Express'));
	197	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook2k', lang('Outlook 2000'));
	198	$GLOBALS['phpgw']->template->set_var('cc_msg_expresso_default', lang('Expresso (default)'));
	199	$GLOBALS['phpgw']->template->set_var('cc_msg_choose_contacts_file', lang('Select the file that contains the contacts to be imported:'));
	200	$GLOBALS['phpgw']->template->set_var('cc_msg_close_win', lang('Close'));
	201	$GLOBALS['phpgw']->template->set_var('cc_msg_close', lang('Close'));
	202	$GLOBALS['phpgw']->template->set_var('cc_msg_ie_personal', lang('Import / Export personal Contacts'));
	203	$GLOBALS['phpgw']->template->set_var('cc_msg_import_fail', lang('The importation has failed. Verify the file format.'));
	204	$GLOBALS['phpgw']->template->set_var('cc_msg_importing_contacts', lang('Importing Contacts...'));
	205	$GLOBALS['phpgw']->template->set_var('cc_msg_import_finished', lang('The importation has finished.'));
	206	$GLOBALS['phpgw']->template->set_var('cc_msg_new', lang(' new'));
	207	$GLOBALS['phpgw']->template->set_var('cc_msg_failure', lang(' failed'));
	208	$GLOBALS['phpgw']->template->set_var('cc_msg_exists', lang(' were existent'));
	209	$GLOBALS['phpgw']->template->set_var('cc_msg_show_more_info', lang('show more info'));
	210	$GLOBALS['phpgw']->template->set_var('cc_msg_clean', lang('Clean'));
	211	$GLOBALS['phpgw']->template->set_var('cc_msg_invalid_csv', lang('Select a valid CSV file to import your contacts'));
	212	$GLOBALS['phpgw']->template->set_var('cc_msg_export_csv', lang('Select the format type that you want to export your contacts'));
	213	$GLOBALS['phpgw']->template->set_var('cc_msg_automatic', lang('Automatic'));
	214	$GLOBALS['phpgw']->template->set_var('cc_msg_export_error', lang('An error has occurred while the exportation.'));
	215	$GLOBALS['phpgw']->template->set_var('cc_msg_new_email', lang('New Email'));
	216	$GLOBALS['phpgw']->template->set_var('cc_msg_main', lang('Main'));
	217	$GLOBALS['phpgw']->template->set_var('cc_msg_alternative', lang('Alternative'));
	218	$GLOBALS['phpgw']->template->set_var('cc_msg_select_email', lang('Select E-Mail'));
	219	$GLOBALS['phpgw']->template->set_var('cc_msg_new_phone', lang('New Telephone'));
	220	$GLOBALS['phpgw']->template->set_var('cc_msg_home', lang('Home'));
	221	$GLOBALS['phpgw']->template->set_var('cc_msg_cellphone', lang('Cellphone'));
[1517]	222	$GLOBALS['phpgw']->template->set_var('cc_msg_corporative_cellphone', lang('Corporative Cellphone'));
	223	$GLOBALS['phpgw']->template->set_var('cc_msg_corporative_fax', lang('Corporative Fax'));
[1599]	224	$GLOBALS['phpgw']->template->set_var('cc_msg_corporative_pager', lang('Corporative Pager'));
[285]	225	$GLOBALS['phpgw']->template->set_var('cc_msg_work', lang('Work'));
	226	$GLOBALS['phpgw']->template->set_var('cc_msg_fax', lang('Fax'));
	227	$GLOBALS['phpgw']->template->set_var('cc_msg_pager', lang('Pager'));
	228	$GLOBALS['phpgw']->template->set_var('cc_msg_choose_phone', lang('Select the telephone'));
	229	$GLOBALS['phpgw']->template->set_var('cc_msg_warn_firefox', lang('Warning: Too old version of Firefox'));
	230	$GLOBALS['phpgw']->template->set_var('cc_msg_firefox_half1', lang('For this application work correctly</u>'));
	231	$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'));
	232	$GLOBALS['phpgw']->template->set_var('cc_msg_click_close', lang('click Close'));
	233	$GLOBALS['phpgw']->template->set_var('cc_msg_install_now', lang('Install Now'));
	234	$GLOBALS['phpgw']->template->set_var('cc_msg_install_new_firefox', lang('Install a new Firefox version'));
	235	$GLOBALS['phpgw']->template->set_var('cc_msg_moz_thunderbird', lang('Export as Mozilla Thunderbird CSV.'));
	236	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_express_pt', lang('Export as Outlook Express (Portuguese) CSV.'));
	237	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_express_en', lang('Export as Outlook Express (English) CSV.'));
	238	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_2k_pt', lang('Export as Outlook 2000 (Portuguese) CSV.'));
	239	$GLOBALS['phpgw']->template->set_var('cc_msg_outlook_2k_en', lang('Export as Outlook 2000 (English) CSV.'));
	240	$GLOBALS['phpgw']->template->set_var('cc_msg_expresso_default_csv', lang('Export as Expresso (Default) CSV.'));
	241	$GLOBALS['phpgw']->template->set_var('cc_msg_copy_to_catalog', lang('Copy to personal catalog.'));
	242	$GLOBALS['phpgw']->template->set_var('cc_msg_add_contact_to_group', lang('You did not add any contact for this group.'));
	243	$GLOBALS['phpgw']->template->set_var('cc_msg_fill_field_name', lang('Fill the field Full Name'));
[1599]	244
[1517]	245	if($GLOBALS['phpgw_info']['server']['personal_contact_type']=='True'){
	246	$GLOBALS['phpgw']->template->set_var('cc_contact_type', 'advanced');
	247	}else{
	248	$GLOBALS['phpgw']->template->set_var('cc_contact_type', 'default');
	249	}
[2]	250	$GLOBALS['phpgw']->template->parse('out','index');
[1599]	251
[2]	252	$api = CreateObject('contactcenter.ui_api');
	253	$main = $api->get_full_add();
	254	$main .= $api->get_search_obj();
	255	$main .= $api->get_quick_add_plugin();
	256	$main .= $api->get_add_group();
	257	$main .= $GLOBALS['phpgw']->template->get_var('out');
	258
	259	echo $main;
	260	}
	261
[1599]	262
[2]	263	/*!
[1599]	264
[2]	265	@function data_manager
[1599]	266	@abstract Calls the right method and passes to it the right
[2]	267	parameters
	268	@author Raphael Derosso Pereira
[1599]	269
[2]	270	*/
	271	function data_manager()
	272	{
	273	switch($_GET['method'])
	274	{
	275	/* Cards Methods */
	276	case 'set_n_cards':
	277	return $this->set_n_cards((int)$_GET['ncards']);
[1599]	278
	279	case 'get_cards_data':
[284]	280	$ids = false;
	281	// To support ldap catalogs using accentuation
	282	if ($_POST['letter'] == 'search' && isset($_POST['data']))
	283	{
[285]	284	$ids = utf8_decode($this->search($_POST['data']));
[284]	285	}
[1599]	286
[285]	287	if(isset($_SESSION['ids']))
	288	$ids = $_SESSION['ids'];
[1599]	289
	290	return $this->get_cards_data($_POST['letter'], $_POST['page'], $ids);
	291
[2]	292	case 'get_cards_data_get':
	293	return $this->get_cards_data($_GET['letter'], $_GET['page'], unserialize(str_replace('\\"','"',$_GET['ids'])));
	294
	295
	296	case 'get_photo':
	297	return $this->get_photo($_GET['id']);
	298
[285]	299	case 'get_visible_all_ldap':
	300	echo $this->get_visible_all_ldap();
	301	return;
[1599]	302
[2]	303	/* Catalog Methods */
	304	case 'set_catalog':
	305	return $this->set_catalog($_GET['catalog']);
[1599]	306
[2]	307	case 'get_catalog_tree':
	308	echo serialize($this->get_catalog_tree($_GET['level']));
	309	return;
	310
	311	case 'get_actual_catalog':
	312	echo serialize($this->get_actual_catalog());
	313	return;
	314
	315	case 'get_catalog_participants_list':
	316	echo serialize($this->get_catalog_participants_list($_POST['id']));
	317	return;
[1599]	318	/rev 104/
[880]	319	case 'get_catalog_participants_group':
	320	echo serialize($this->get_catalog_participants_group($_POST['id']));
	321	return;
[1599]	322	/***/
[2]	323	case 'get_catalog_add_contact':
[284]	324	// To support ldap catalogs with accentuation
	325	echo serialize($this->get_catalog_add_contact(utf8_decode($_POST['id'])));
[2]	326	return;
[1599]	327
[2]	328	/* Full Add Methods */
	329	case 'get_full_data':
[1599]	330	//return $this->get_full_data($_GET['id']);
	331	/rev 104/
[503]	332	return $this->get_full_data($_GET['id'],$_GET['catalog']);
[1599]	333	/****/
	334
[2]	335	case 'get_group':
[1280]	336	return $this->get_group_data($_GET['id'],isset($_GET['shared_from'])?$_GET['shared_from']:null);
[1599]	337
[2]	338	case 'get_contact_full_add_const':
	339	return $this->get_contact_full_add_const();
	340
	341	case 'post_full_add':
	342	return $this->post_full_add();
	343
[1496]	344	case 'post_full_add_shared' :
	345	return $this->post_full_add_shared();
	346
[2]	347	case 'post_photo':
	348	return $this->post_photo((int) $_GET['id'] ? (int) $_GET['id'] : '_new_');
	349
	350	case 'get_states':
	351	return $this->get_states($_GET['country']);
[1599]	352
[2]	353	case 'get_cities':
	354	return $this->get_cities($_GET['country'], $_GET['state'] ? $_GET['state'] : null);
[1599]	355
	356
[2]	357	/* Other Methods */
[1599]	358	case 'quick_add':
[2]	359	return $this->quick_add($_POST['add']);
[1599]	360
	361	case 'add_group':
[2]	362	return $this->add_group($_POST['add']);
[1599]	363
[2]	364	case 'remove_entry':
	365	return $this->remove_entry((int)$_GET['remove']);
[1599]	366
[2]	367	case 'remove_all_entries':
	368	return $this->remove_all_entries();
	369
	370	case 'remove_group':
	371
[1599]	372	return $this->remove_group((int)$_GET['remove']);
	373
[2]	374	case 'search':
[285]	375	$ids = false;
	376	$ids = $this->search($_GET['data']);
	377	return $this->get_cards_data('search', '1', $ids);
[2]	378
	379	case 'email_win':
	380	$GLOBALS['phpgw']->common->phpgw_header();
	381	$api = CreateObject('contactcenter.ui_api');
	382	$win = $api->get_email_win();
	383	$win .= $api->get_quick_add_plugin();
	384	$win .= '<input id="QAbutton" type="button" value="QuickAdd" />'
	385	.'<br><input type="button" value="EmailWin" onclick="ccEmailWin.open()" />'
	386	.'<script type="text/javascript">'
	387	.' ccQuickAdd.associateAsButton(Element("QAbutton"));'
	388	.'</script>';
	389	echo $win;
	390	return;
	391
	392	/* Information Gathering */
	393	case 'get_multiple_entries':
	394	echo serialize($this->get_multiple_entries(str_replace('\\"','"',$_POST['data'])));
	395	return;
	396
	397	case 'get_all_entries':
	398	echo serialize($this->get_all_entries(str_replace('\\"','"',$_POST['data'])));
	399	return;
	400
	401	case 'import_contacts':
	402	return $this->import_contacts($_GET['typeImport']);
	403
	404	case 'export_contacts':
	405	return $this->export_contacts($_POST['typeExport']);
	406
	407	}
	408	}
	409
	410	/*!
[1599]	411
[2]	412	@function set_n_cards
	413	@abstract Informs the class the number of cards the page can show
	414	@author Raphael Derosso Pereira
[1599]	415
[2]	416	@param integer $n_cards The number of cards
[1599]	417
[2]	418	*/
	419	function set_n_cards($n_cards)
	420	{
	421	if (is_int($n_cards))
	422	{
	423	$this->page_info['n_cards'] = $n_cards;
	424	echo 1;
	425	}
[1599]	426
[2]	427	$this->save_session();
	428	}
[1599]	429
[2]	430	/*!
[1599]	431
[2]	432	@function set_catalog
	433	@abstract Sets the current catalog selected by the user
	434	@author Raphael Derosso Pereira
[1599]	435
[2]	436	@param string $id_catalog The sequence of IDs to reach the catalog
	437	separated by commas
[1599]	438
[2]	439	*/
	440	function set_catalog($id_catalog)
	441	{
	442	$id_catalog = str_replace('\\"', '"', $id_catalog);
	443	$temp =& $this->bo->set_catalog($id_catalog);
[1599]	444
[2]	445	if ($temp)
	446	{
	447	$this->page_info['changed'] = true;
	448	$this->page_info['actual_entries'] = false;
	449	$this->page_info['actual_catalog'] =& $temp;
	450	$this->save_session();
[1599]	451
[2]	452	$catalog_info = $this->bo->get_branch_by_level($this->bo->catalog_level[0]);
[1599]	453
[2]	454	if ($catalog_info['class'] === 'bo_global_ldap_catalog' \|\|
	455	$catalog_info['class'] === 'bo_catalog_group_catalog')
	456	{
	457	$perms = 1;
	458	}
	459	else
	460	{
	461	$perms = 15;
	462	}
[1599]	463
[2]	464	echo serialize(array(
	465	'status' => 'ok',
	466	'perms' => $perms
	467	));
	468
	469	return;
	470	}
[1599]	471
[2]	472	echo serialize(array(
	473	'status' => 'ok',
	474	'perms' => 0
	475	));
	476	}
[1599]	477
	478
[2]	479	/*!
[1599]	480
[2]	481	@function get_catalog_tree
	482	@abstract Returns the JS serialized array to used as the tree
	483	level
	484	@author Raphael Derosso Pereira
[1599]	485	@author Mï¿œrio Cï¿œsar Kolling (error messages and timeout)
	486
	487	@param (string) $level The level to be taken
	488
[2]	489	*/
	490	function get_catalog_tree($level)
	491	{
	492	if ($level === '0')
	493	{
	494	$folderImageDir = $GLOBALS['phpgw_info']['server']['webserver_url'] . '/phpgwapi/dftree/images/';
	495
	496	$parent = '0';
[1599]	497
[2]	498	if (!($tree = $this->bo->get_catalog_tree($level)))
	499	{
	500	return array(
	501	'msg' => lang('Couldn\'t get the Catalogue Tree. Please contact the Administrator.'),
	502	'status' => 'fatal'
	503	);
	504	}
	505	}
	506	else
	507	{
	508	$last_dot = strrpos($level,'.');
	509	$parent = substr($level, 0, $last_dot);
	510	$child = substr($level, $last_dot+1, strlen($level));
	511	if (!($tree[$child] = $this->bo->get_catalog_tree($level)))
	512	{
	513	return array(
	514	'msg' => lang('Couldn\'t get the Catalogue Tree. Please contact the Administrator.'),
	515	'status' => 'fatal'
	516	);
	517	}
[284]	518	// Deals with timeout and returns the generated message to the browser
	519	else if (!empty($tree[$child]['timeout']) && !empty($tree[$child]['msg']))
	520	{
	521	$tmp = array(
	522	'msg' => $tree[$child]['msg'],
	523	'status' => 'fatal'
	524	);
	525	unset($tree[$child]);
	526	return $tmp;
	527	}
[2]	528	}
[1599]	529
[2]	530	$folderImageDir = $GLOBALS['phpgw']->common->image('contactcenter','globalcatalog-mini.png');
	531	$folderImageDir = substr($folderImageDir, 0, strpos($folderImageDir, 'globalcatalog-mini.png'));
[1599]	532
[284]	533	// Deals with error messages from the server and returns them to the browser
	534	if ($tree['msg'])
	535	{
	536	$msg = $tree['msg'];
	537	unset($tree['msg']);
	538	}
	539
[2]	540	$tree_js = $this->convert_tree($tree, $folderImageDir, $parent);
[284]	541
	542	// Return status = ok, or else return generated message to the browser
	543	if (!$msg)
	544	{
	545	return array(
	546	'data' => $tree_js,
	547	'msg' => lang('Catalog Tree Successfully taken!'),
	548	'status' => 'ok'
	549	);
	550	}
	551	else
	552	{
	553	return array(
	554	'data' => $tree_js,
	555	'msg' => $msg,
	556	'status' => 'error'
	557	);
	558	}
[2]	559	}
[1599]	560
[2]	561	/*!
[1599]	562
[2]	563	@function get_actual_catalog
	564	@abstract Returns the actual selected Catalog
	565	@author Raphael Derosso Pereira
	566
	567	*/
	568	function get_actual_catalog()
[1599]	569	{
[2]	570	$level = $this->bo->get_level_by_branch($this->bo->get_actual_catalog(), $this->bo->tree['branches'], '0');
[1599]	571
[2]	572	if ($level)
	573	{
	574	return array(
	575	'status' => 'ok',
	576	'data' => $level
	577	);
	578	}
	579
	580	return array(
	581	'status' => 'fatal',
	582	'msg' => lang('Couldn\'t get the actual catalog.'),
	583	);
	584	}
[1599]	585
[2]	586	/*!
[1599]	587
[2]	588	@function get_cards_data
	589	@abstract Returns the information that is placed on the cards
	590	@author Raphael Derosso Pereira
[1599]	591
[2]	592	@param string $letter The first letter to be searched
[1599]	593	@param (int) $page The page to be taken
[2]	594	@param (str) $ids The ids to be taken in case of search
	595
	596	TODO: This function is not well done. It must be rewritten
	597	using the new array 'msg','status','data' schema.
	598	*/
	599	function get_cards_data($letter, $page, $ids)
	600	{
[285]	601	if( $ids )
[1599]	602	$_SESSION['ids'] = $ids;
[284]	603
	604	// It's an external catalog?
	605	$external = $this->bo->is_external($this->page_info['actual_catalog']);
[2]	606	//echo $page."\n";
	607	if ($letter !== 'search' and ($letter != $this->page_info['actual_letter'] or
[1599]	608	($letter == $this->page_info['actual_letter'] and $page == $this->page_info['actual_page']) or
[2]	609	$this->page_info['changed']))
	610	{
	611	unset($ids);
	612	$this->page_info['changed'] = false;
[1599]	613
[2]	614	switch ($this->page_info['actual_catalog']['class'])
	615	{
[1599]	616	/rev 104/
[752]	617	case 'bo_shared_people_manager':
[1599]	618	/****/
[752]	619	case 'bo_people_catalog':
[503]	620	$field_name = 'id_contact';
[1599]	621
[503]	622	if ($letter !== 'number')
	623	{
	624	$find_restric[0] = array(
	625	0 => array(
	626	'field' => 'contact.names_ordered',
	627	'type' => 'iLIKE',
	628	'value' => $letter !== 'all' ? $letter.'%' : '%'
[1599]	629	/rev 104/
	630	/* ),
	631	1 => array(
	632	'field' => 'contact.id_owner',
	633	'type' => '=',
	634	'value' => $GLOBALS['phpgw_info']['user']['account_id']
	635	*/
	636	)
[503]	637	);
[1496]	638
	639	//Tratamento de permissão de escrita no compartilhamento de catalogo
	640	$so_contact = CreateObject('contactcenter.so_contact', $GLOBALS['phpgw_info']['user']['account_id']);
	641	$relacionados = $so_contact->get_relations();
	642
[1599]	643	$perms_relacao = array();
	644
[1496]	645	foreach($relacionados as $uid_relacionado => $tipo_relacionamento) {
	646	$aclTemp = CreateObject("phpgwapi.acl",$uid_relacionado);
	647	$aclTemp->read();
	648	$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
	649	}
	650
	651	$validos = array();
	652	$count = 0;
	653	foreach($perms_relacao as $uid_relacionado => $val){
	654	if ($perms_relacao[$uid_relacionado]&2)
	655	{
	656	$validos[$uid_relacionado] = $perms_relacao[$uid_relacionado];
	657	$count++;
	658	}
	659	}
	660	$prop_names = array();
	661	if($validos) {
	662	$filtro = "(\|";
	663	foreach($validos as $i => $prop) {
	664	$filtro .= "(uidNumber=".$i.")";
	665	}
	666	$filtro .= ")";
	667
	668	if(!$this->bo->catalog->src_info) {
	669	$ldaps = CreateObject('contactcenter.bo_ldap_manager');
	670	$this->bo->catalog->src_info = $ldaps->srcs[1];
	671	}
	672	$s = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], false);
	673	$n=$this->bo->catalog->src_info['dn'];
	674	$apenasThese = array("cn","uidnumber","uid");
[1599]	675	$r = ldap_search($s,$n, $filtro,$apenasThese);
[1496]	676	$infos = ldap_get_entries($s, $r);
[1599]	677	ldap_close($s);
[1496]	678	for($z = 0; $z < $infos['count']; $z++) {
	679	$prop_names[$infos[$z]['uidnumber'][0]] = array("cn" => $infos[$z]['cn'][0], "uid" => $infos[$z]['uid'][0]);
	680	}
	681	}
	682	//--------------------------------------------------------------------------------
	683	if($this->page_info['actual_catalog']['class'] == 'bo_people_catalog')
	684	{
[752]	685	$find_restric[0][1] = array(
	686	'field' => 'contact.id_owner',
	687	'type' => '=',
	688	'value' => $GLOBALS['phpgw_info']['user']['account_id']
	689	);
	690	}
[1599]	691	/****/
	692
[503]	693	}
	694	else
	695	{
	696	$find_restric[0] = array(
	697	0 => array(
	698	'type' => 'branch',
	699	'value' => 'OR',
	700	'sub_branch' => array(
	701	0 => array(
	702	'field' => 'contact.names_ordered',
	703	'type' => 'LIKE',
	704	'value' => '0%'
	705	),
	706	1 => array(
	707	'field' => 'contact.names_ordered',
	708	'type' => 'LIKE',
	709	'value' => '1%'
	710	),
	711	2 => array(
	712	'field' => 'contact.names_ordered',
	713	'type' => 'LIKE',
	714	'value' => '2%'
	715	),
	716	3 => array(
	717	'field' => 'contact.names_ordered',
	718	'type' => 'LIKE',
	719	'value' => '3%'
	720	),
	721	4 => array(
	722	'field' => 'contact.names_ordered',
	723	'type' => 'LIKE',
	724	'value' => '4%'
	725	),
	726	5 => array(
	727	'field' => 'contact.names_ordered',
	728	'type' => 'LIKE',
	729	'value' => '5%'
	730	),
	731	6 => array(
	732	'field' => 'contact.names_ordered',
	733	'type' => 'LIKE',
	734	'value' => '6%'
	735	),
	736	7 => array(
	737	'field' => 'contact.names_ordered',
	738	'type' => 'LIKE',
	739	'value' => '7%'
	740	),
	741	8 => array(
	742	'field' => 'contact.names_ordered',
	743	'type' => 'LIKE',
	744	'value' => '8%'
	745	),
	746	9 => array(
	747	'field' => 'contact.names_ordered',
	748	'type' => 'LIKE',
	749	'value' => '9%'
[752]	750	),
	751	),
[1599]	752	/rev 104/
	753	/* ),
	754	1 => array(
	755	'field' => 'contact.id_owner',
	756	'type' => '=',
	757	'value' => $GLOBALS['phpgw_info']['user']['account_id']
	758	),
	759	*/
[503]	760	)
	761	);
	762	}
[2]	763
[752]	764	if($this->page_info['actual_catalog']['class'] == 'bo_people_catalog'){
	765	$find_restric[0][1] = array(
	766	'field' => 'contact.id_owner',
	767	'type' => '=',
	768	'value' => $GLOBALS['phpgw_info']['user']['account_id']
[2]	769	);
	770	}
[1599]	771	/*****/
	772
[2]	773	$find_field[0] = array('contact.id_contact','contact.names_ordered');
[1599]	774
[2]	775	$find_other[0] = array(
[1599]	776	/rev 104/
	777	//'offset' => (($page-1)*$this->page_info['n_cards']),
	778	//'limit' => $this->page_info['n_cards'],
	779	/*****/
[2]	780	'order' => 'contact.names_ordered'
	781	);
[1599]	782
[2]	783	break;
[1599]	784
[2]	785	case 'bo_global_ldap_catalog':
[1599]	786
[2]	787	$field_name = 'id_contact';
	788
	789	if ($letter !== 'number')
	790	{
	791	$find_restric[0] = array(
	792	0 => array(
	793	'field' => 'contact.names_ordered',
	794	'type' => 'iLIKE',
	795	'value' => $letter !== 'all' ? $letter.'%' : '%'
[284]	796	),
	797	/*
	798	* Restrict the returned contacts in a "first letter" search
[1599]	799	/**rev 104
[284]	800	* to objectClass = phpgwAccount, must have attibute phpgwAccountStatus,
[880]	801	* phpgwAccountVisible != -1
[284]	802	*/
	803	1 => array(
	804	'field' => 'contact.object_class',
	805	'type' => '=',
	806	'value' => 'phpgwAccount'
[1599]	807	/rev 104/
	808	//),/*
[284]	809	),
[1599]	810	/****/
[284]	811	2 => array(
	812	'field' => 'contact.account_status',
	813	'type' => 'iLIKE',
	814	'value' => '%'
[1599]	815	/rev 104/
	816	//),*/
	817	//2 => array(
[284]	818	),
	819	3 => array(
[1599]	820	/*****/
[284]	821	'field' => 'contact.account_visible',
	822	'type' => '!=',
	823	'value' => '-1'
[1599]	824	/rev 104/
	825	/* ),
	826	3 => array(
	827	'field' => 'contact.object_class',
	828	'type' => '=',
	829	'value' => 'inetOrgPerson'
	830	),
	831	*/
[880]	832	)
[1599]	833	/*****/
	834
[2]	835	);
[284]	836	// If not external catalog get only phpgwAccountType = u ou l
	837	if (!$external)
	838	{
	839	$find_restric[0][5] = array(
	840	'type' => 'branch',
	841	'value' => 'OR',
	842	'sub_branch' => array(
	843	0 => array(
	844	'field' => 'contact.account_type',
	845	'type' => '=',
	846	'value' => 'u'
	847	),
[285]	848	1 => array(
[284]	849	'field' => 'contact.account_type',
	850	'type' => '=',
[418]	851	'value' => 'i'
[1599]	852	/rev 104/
[418]	853	),
	854	2 => array(
	855	'field' => 'contact.account_type',
	856	'type' => '=',
[1599]	857	/****/
[284]	858	'value' => 'l'
[1599]	859	/rev 104/
[880]	860	),
	861	3 => array(
	862	'field' => 'contact.account_type',
	863	'type' => '=',
	864	'value' => 'g'
[1599]	865	/***/
[284]	866	)
[2]	867	)
[284]	868	);
	869	}
[2]	870	}
	871	else
	872	{
	873	$find_restric[0] = array(
[284]	874	/*
	875	* Restrict the returned contacts in a "first number" search
[1599]	876	/**rev 104
[284]	877	* to objectClass = phpgwAccount, must have attibute phpgwAccountStatus,
[880]	878	* phpgwAccountVisible != -1
[284]	879	*/
[2]	880	0 => array(
[284]	881	'field' => 'contact.object_class',
	882	'type' => '=',
	883	'value' => 'phpgwAccount'
[1599]	884	/rev 104/
	885	//),/*
[284]	886	),
[1599]	887	/****/
[284]	888	1 => array(
	889	'field' => 'contact.account_status',
	890	'type' => 'iLIKE',
	891	'value' => '%'
[1599]	892	/rev 104/
	893	//),*/
	894	//1 => array(
[284]	895	),
	896	2 => array(
[1599]	897	/*****/
[284]	898	'field' => 'contact.account_visible',
	899	'type' => '!=',
	900	'value' => '-1'
	901	),
[1599]	902	/rev 104/
	903	/* 2 => array(
	904	'field' => 'contact.object_class',
	905	'type' => '=',
	906	'value' => 'inetOrgPerson'
	907	),
	908	*/
	909	/****/
[284]	910	3 => array(
[2]	911	'type' => 'branch',
	912	'value' => 'OR',
	913	'sub_branch' => array(
	914	0 => array(
	915	'field' => 'contact.names_ordered',
	916	'type' => 'LIKE',
	917	'value' => '0%'
	918	),
	919	1 => array(
	920	'field' => 'contact.names_ordered',
	921	'type' => 'LIKE',
	922	'value' => '1%'
	923	),
	924	2 => array(
	925	'field' => 'contact.names_ordered',
	926	'type' => 'LIKE',
	927	'value' => '2%'
	928	),
	929	3 => array(
	930	'field' => 'contact.names_ordered',
	931	'type' => 'LIKE',
	932	'value' => '3%'
	933	),
	934	4 => array(
	935	'field' => 'contact.names_ordered',
	936	'type' => 'LIKE',
	937	'value' => '4%'
	938	),
	939	5 => array(
	940	'field' => 'contact.names_ordered',
	941	'type' => 'LIKE',
	942	'value' => '5%'
	943	),
	944	6 => array(
	945	'field' => 'contact.names_ordered',
	946	'type' => 'LIKE',
	947	'value' => '6%'
	948	),
	949	7 => array(
	950	'field' => 'contact.names_ordered',
	951	'type' => 'LIKE',
	952	'value' => '7%'
	953	),
	954	8 => array(
	955	'field' => 'contact.names_ordered',
	956	'type' => 'LIKE',
	957	'value' => '8%'
	958	),
	959	9 => array(
	960	'field' => 'contact.names_ordered',
	961	'type' => 'LIKE',
	962	'value' => '9%'
	963	),
	964	),
	965	),
	966	);
[284]	967	// If not external catalog get only phpgwAccountType = u ou l
	968	if (!$external)
	969	{
	970	$find_restric[0][5] = array(
	971	'type' => 'branch',
	972	'value' => 'OR',
	973	'sub_branch' => array(
	974	0 => array(
	975	'field' => 'contact.account_type',
	976	'type' => '=',
	977	'value' => 'u'
	978	),
[418]	979	1 => array(
	980	'field' => 'contact.account_type',
	981	'type' => '=',
[1599]	982	/rev 104/
	983	//'value' => 'g'
	984	//);
	985	//1 => array(
[418]	986	'value' => 'i'
	987	),
[880]	988	2 => array(
[1599]	989	/****/
[284]	990	'field' => 'contact.account_type',
	991	'type' => '=',
[880]	992	'value' => 'l'
[1599]	993	/rev 104/
[880]	994	),
	995	3 => array(
[284]	996	'field' => 'contact.account_type',
	997	'type' => '=',
[880]	998	'value' => 'g'
[284]	999	)
[1599]	1000	/****/
[2]	1001	)
[284]	1002	);
	1003	}
[2]	1004	}
[284]	1005
	1006	if (!$external)
	1007	{
	1008	// Get only this attributes: dn, cn, phpgwAccountType, objectClass, phpgwAccountStatus, phpghAccountVisible
	1009	// for non-external catalogs, used to restrict the attributes used in filters
	1010	$find_field[0] = array('contact.id_contact','contact.names_ordered','contact.account_type',
[1599]	1011	'contact.object_class','contact.account_visible');
[284]	1012	}
	1013	else
	1014	{
	1015	// Get only this attributes: dn, cn for external catalogs,
	1016	// used to restrict the attributes used in filters
	1017	$find_field[0] = array('contact.id_contact','contact.names_ordered');
	1018	}
[1599]	1019
[2]	1020	$find_other[0] = array(
	1021	//'offset' => (($page-1)*$this->page_info['n_cards']),
	1022	//'limit' => $this->page_info['n_cards'],
	1023	'order' => 'contact.names_ordered'
	1024	);
[1599]	1025
[2]	1026	break;
[1599]	1027
[2]	1028	case 'bo_company_manager':
	1029	$field_name = 'id_company';
[1599]	1030
[2]	1031	$find_field[0] = array('company.id_company','company.company_name');
[1599]	1032
[2]	1033	$find_other[0] = array(
	1034	//'offset' => (($page-1)*$this->page_info['n_cards']),
	1035	//'limit' => $this->page_info['n_cards'],
	1036	'order' => 'company.company_name'
	1037	);
[1599]	1038
[2]	1039	$find_restric[0] = array(
	1040	0 => array(
	1041	'field' => 'company.company_name',
	1042	'type' => 'iLIKE',
	1043	'value' => $letter !== 'all' ? $letter.'%' : '%'
	1044	)
	1045	);
[1599]	1046
[2]	1047	break;
	1048
	1049	case 'bo_group_manager':
[1599]	1050	/rev 104/
[752]	1051	case 'bo_shared_group_manager':
[1599]	1052	/****/
	1053
[2]	1054	$field_name = 'id_group';
[1599]	1055
[2]	1056	if ($letter !== 'number') {
[1599]	1057
[2]	1058	$find_restric[0] = array(
	1059	0 => array(
	1060	'field' => 'group.title',
	1061	'type' => 'iLIKE',
	1062	'value' => $letter !== 'all' ? $letter.'%' : '%'
	1063	)
	1064	);
	1065	}
	1066	else {
[1599]	1067
[2]	1068	$find_restric[0] = array(
	1069	0 => array(
	1070	'field' => 'group.title',
	1071	'type' => 'LIKE',
[1599]	1072	'value' => '0%'
[2]	1073	)
[1599]	1074	);
[2]	1075	}
[1599]	1076	/rev 104/
[752]	1077	if($this->page_info['actual_catalog']['class'] == 'bo_group_manager'){
[1599]	1078	/****/
[752]	1079	array_push($find_restric[0], array(
[2]	1080	'field' => 'group.owner',
	1081	'type' => '=',
[1599]	1082	'value' => $GLOBALS['phpgw_info']['user']['account_id']
[752]	1083	)
	1084	);
	1085	}
[1599]	1086
	1087	$find_field[0] = array('group.id_group','group.title','group.short_name');
[2]	1088	$find_other[0] = array(
	1089	'order' => 'group.title'
[1599]	1090	);
[2]	1091	break;
[1599]	1092
[2]	1093	case 'bo_catalog_group_catalog':
	1094	$this->page_info['actual_entries'] = false;
[1599]	1095
[2]	1096	$this->page_info['actual_letter'] = $letter;
	1097	$this->page_info['actual_page'] = 0;
[1599]	1098
[2]	1099	$this->save_session();
	1100	$final[0] = 0;
[285]	1101	$final[1] = $this->typeContact;
[1599]	1102	echo serialize($final);
[2]	1103	return;
	1104
	1105	}
[1496]	1106
[2]	1107	$result = $this->bo->find($find_field[0],$find_restric[0],$find_other[0]);
	1108	$n_entries = count($result);
[1599]	1109
[2]	1110	if ($n_entries)
	1111	{
	1112	//echo 'N_entries: '.$n_entries.'<br>';
	1113	$this->page_info['n_pages'] = ceil($n_entries/($this->page_info['n_cards'] ? $this->page_info['n_cards'] : 1));
	1114	}
	1115	else
	1116	{
	1117	$this->page_info['n_pages'] = 0;
	1118	}
	1119
	1120	if (!$result)
	1121	{
	1122	$this->page_info['actual_entries'] = false;
[1599]	1123
[2]	1124	$this->page_info['actual_letter'] = $letter;
	1125	$this->page_info['actual_page'] = 0;
[1599]	1126
	1127	$this->save_session();
[2]	1128	$final[0] = 0;
[285]	1129	$final[1] = $this->typeContact;
[1599]	1130	echo serialize($final);
[2]	1131	return;
	1132	}
	1133	else
	1134	{
	1135	unset($this->page_info['actual_entries']);
	1136	foreach ($result as $id => $value)
	1137	{
[1599]	1138	/rev 104/
	1139	// $this->page_info['actual_entries'][] = $value[$field_name];
	1140	//}
[752]	1141	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
[503]	1142	$this->page_info['actual_entries'][] = $value[$field_name];
	1143	else
[752]	1144	$this->page_info['actual_entries'][] = array(0=>$value[$field_name],1=>$value['perms'],2=>$value['owner']);
[1599]	1145	}
	1146	/****/
[285]	1147	//print_r($this->page_info['actual_entries']);
[2]	1148	}
	1149	}
	1150	else if ($letter === 'search')
	1151	{
[284]	1152	//if (!$ids and $this->page_info['actual_letter'] !== 'search')
[285]	1153	if (!$ids)
[2]	1154	{
[1599]	1155	/rev 104/
[315]	1156	//error_log('!$ids e $this->page_info[\'actual_letter\'] != search');
[1599]	1157	/*****/
[2]	1158	$this->page_info['actual_entries'] = false;
[1599]	1159
[2]	1160	$this->page_info['actual_letter'] = $letter;
	1161	$this->page_info['actual_page'] = 0;
[1599]	1162
[2]	1163	$this->save_session();
	1164	$final[0] = 0;
	1165	$final[1] = $this -> typeContact;
[1599]	1166	echo serialize($final);
[2]	1167	return;
	1168	}
[284]	1169	else if ($ids['error'])
	1170	{
	1171	$this->page_info['actual_entries'] = false;
	1172	$this->page_info['actual_letter'] = $letter;
	1173	$this->page_info['actual_page'] = 0;
	1174
	1175	$this->save_session();
	1176	$final[0] = 0;
	1177	$final[1] = $this -> typeContact;
	1178	$final['error'] = $ids['error'];
	1179	echo serialize($final);
	1180	return;
	1181	}
[285]	1182	else if ($ids)
[1599]	1183	{
[2]	1184	$this->page_info['actual_letter'] = $letter;
	1185	$this->page_info['actual_entries'] = $ids;
	1186	$this->page_info['n_pages'] = ceil(count($ids)/($this->page_info['n_cards'] ? $this->page_info['n_cards'] : 1));
	1187	}
	1188	}
	1189	else
	1190	{
	1191	unset($ids);
	1192	}
	1193
	1194	if ($this->page_info['actual_entries'])
	1195	{
	1196	if ($page >= $this->page_info['n_pages'])
	1197	{
	1198	$page = $this->page_info['n_pages'];
	1199	}
[1599]	1200
[2]	1201	$final = array(
	1202	0 => (int)$this->page_info['n_pages'],
	1203	1 => (int)$page,
	1204	2 => array(
	1205	0 => 'cc_company',
	1206	1 => 'cc_name',
	1207	2 => 'cc_title',
	1208	3 => 'cc_phone',
	1209	4 => 'cc_mail',
	1210	5 => 'cc_alias',
	1211	6 => 'cc_id',
[1599]	1212	7 => 'cc_forwarding_address',
	1213	8 => 'cc_empNumber',
	1214	9 => 'cc_department',
	1215	10 => 'cc_mobile'
[2]	1216	)
	1217	);
[1599]	1218
[2]	1219	//echo 'Page: '.$page.'<br>';
	1220	$id_i = (($page-1)*$this->page_info['n_cards']);
	1221	$id_f = $id_i + $this->page_info['n_cards'];
	1222	$n_entries = count($this->page_info['actual_entries']);
[1599]	1223
[2]	1224	//echo 'ID_I: '.$id_i.'<br>';
	1225	//echo 'ID_F: '.$id_f.'<br>';
[1599]	1226	///---------------- Correï¿œï¿œo Temporï¿œria PHP5 -----------------------///
	1227
[2]	1228	$ids = array();
[1599]	1229	/rev 104/
[503]	1230	$perms = array();
[752]	1231	$owners = array();
[1599]	1232	/****/
	1233	$array_temp = array();
	1234
[2]	1235	foreach($this->page_info['actual_entries'] as $key=>$tmp){
[1599]	1236	$array_temp[] = $tmp;
[1496]	1237	}
[1599]	1238
[2]	1239	for($i = $id_i; $i < $id_f and $i < $n_entries; $i++)
	1240	{
[1599]	1241	/rev 104/
[752]	1242	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
[1599]	1243	{
	1244	/****/
[503]	1245	$ids[] = $array_temp[$i];
[1599]	1246	/rev 104/
	1247	}else {
[503]	1248	$ids[] = $array_temp[$i][0];
	1249	$perms[] = $array_temp[$i][1];
[752]	1250	$owners[] = $array_temp[$i][2];
[1599]	1251	/****/
[503]	1252	}
[2]	1253	}
[1599]	1254
	1255	/rev 104/
[752]	1256	// Carrega o nome completo dos donos dos objetos (contatos e grupos);
	1257	$owner_names = array();
[1599]	1258
[752]	1259	if($owners) {
	1260	$filter = "(\|";
	1261	foreach($owners as $i => $owner) {
	1262	$filter .= "(uidNumber=".$owner.")";
	1263	}
	1264	$filter .= ")";
[1496]	1265
[752]	1266	if(!$this->bo->catalog->src_info) {
	1267	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	1268	$this->bo->catalog->src_info = $ldap->srcs[1];
	1269	}
[1599]	1270	$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]	1271	$dn=$this->bo->catalog->src_info['dn'];
	1272	$justThese = array("cn","uidnumber","uid");
[1599]	1273	$sr = ldap_search($ds,$dn, $filter,$justThese);
[752]	1274	$info = ldap_get_entries($ds, $sr);
[1599]	1275	ldap_close($ds);
[752]	1276	for($z = 0; $z < $info['count']; $z++) {
	1277	$owner_names[$info[$z]['uidnumber'][0]] = array("cn" => $info[$z]['cn'][0], "uid" => $info[$z]['uid'][0]);
[1599]	1278	}
[752]	1279	}
[1599]	1280
	1281	/*****/
	1282
	1283
[2]	1284	/// Original
	1285	//for($i = $id_i; $i < $id_f and $i < $n_entries; $i++)
	1286	//{
	1287	// $ids[] = $this->page_info['actual_entries'][$i];
	1288	//}
	1289	///
[1599]	1290
[2]	1291	$fields = $this->bo->catalog->get_fields(false);
[1599]	1292	/rev 104/
	1293	//if( $this->typeContact == 'groups') {
[752]	1294	if( $this->typeContact == 'groups' \|\| $this->typeContact == 'shared_groups') {
[1599]	1295	/****/
[2]	1296	$final = array(
	1297	0 => (int)$this->page_info['n_pages'],
	1298	1 => (int)$page,
	1299	2 => array(
	1300	0 => 'cc_title',
	1301	1 => 'cc_short_name',
	1302	2 => 'cc_id',
	1303	3 => 'cc_contacts'
[1599]	1304	)
	1305	);
	1306
[2]	1307	$groups =& $this->bo->catalog->get_multiple_entries($ids,$fields);
[1599]	1308
[2]	1309	$i = 0;
	1310	// contatos do grupo
[1599]	1311	$boGroups = CreateObject('contactcenter.bo_group');
[2]	1312	$contacts = array();
[1599]	1313	foreach($groups as $group) {
	1314
[2]	1315	$final[3][$i][0] = $group['title'] ? $group['title'] : 'none';
[1599]	1316	$final[3][$i][1] = $group['short_name'] ? $group['short_name'] : 'none';
[2]	1317	$final[3][$i][2] = $group['id_group'] ? $group['id_group'] : 'none';
	1318	$contacts = $boGroups -> get_contacts_by_group($group['id_group']);
	1319	$final[3][$i][3] = $contacts;
[752]	1320	$final[3][$i][4] = $perms[$i];
	1321	if($this->typeContact == 'shared_groups'){
	1322	$final[3][$i][5] = lang('Shared').": ".$owner_names[$owners[$i]]['cn'];
	1323	$final[3][$i][6] = $owner_names[$owners[$i]]['uid'];
[1280]	1324	$final[3][$i][7] = $owners[$i]; //uidNumber
[752]	1325	}
[285]	1326	$i++;
[2]	1327	}
[1599]	1328
[2]	1329	$this->page_info['actual_letter'] = $letter;
[1599]	1330	$this->page_info['actual_page'] = $page;
	1331
	1332
[2]	1333	$lnk_compose = "location.href=('../expressoMail1_2/index.php?to=";
[1599]	1334
	1335	$final[5] = '<span class="link" onclick="'.$lnk_compose;
	1336	/rev 104/
	1337	//$final[10] = 'groups';
	1338	$final[10] = $this->typeContact;
	1339	/******/
	1340	$this->save_session();
[2]	1341	echo serialize($final);
[1599]	1342	return;
[2]	1343	}
[1599]	1344	/rev 104/
[503]	1345	$final[10] = $this -> typeContact;
[1599]	1346	/*****/
	1347
[2]	1348	$fields['photo'] = true;
	1349	$fields['names_ordered'] = true;
	1350	$fields['alias'] = true;
	1351	$fields['account_type'] = true;
	1352	$fields['companies'] = 'default';
	1353	$fields['connections'] = 'default';
[1599]	1354
	1355	/rev 104/
	1356	// ?aqui alterar a chamada desse mï¿œtodo para receber o base dn?
	1357	//$contacts = &$this->bo->catalog->get_multiple_entries($ids,$fields);
	1358
[285]	1359	// ?aqui alterar a chamada desse método para receber o base dn?
[1419]	1360	if($external)
[1599]	1361	{
[1419]	1362	$contacts = &$this->bo->catalog->get_multiple_entries($ids,$fields,false,true);
[1599]	1363	} else{
[1419]	1364	$contacts = &$this->bo->catalog->get_multiple_entries($ids,$fields);
[1599]	1365	}
	1366
	1367	/*******/
	1368
	1369
[2]	1370	if (!is_array($contacts) or !count($contacts))
	1371	{
	1372	$final[0] = 0;
	1373	$final[1] = $this -> typeContact;
	1374	echo serialize($final);
	1375	return;
	1376	}
[1599]	1377
[2]	1378	$i = 0;
[284]	1379	foreach($contacts as $index => $contact)
[2]	1380	{
[284]	1381	/*
[1599]	1382	* TODO: Os timeouts de conexï¿œo foram retirados, ver se serï¿œ necessï¿œrio retornar essa funcionalidade, e,
	1383	* neste caso, terminar a implementaï¿œï¿œo das mensagens de retorno.
[284]	1384	*/
	1385	if ($index !== 'error'){
	1386	$final[3][$i][0] = $contact['companies']['company1']['company_name']?$contact['companies']['company1']['company_name']:'none';
[1599]	1387
	1388	/rev 104/
	1389	//$final[3][$i][1] = $contact['names_ordered'] ? $contact['names_ordered'] : 'none';
	1390
[1419]	1391	if($this->page_info['actual_catalog']['class']!='bo_global_ldap_catalog'){
	1392	$final[3][$i][1] = $contact['names_ordered'] ? urldecode($contact['names_ordered']) : 'none';
	1393	}
	1394	else {
	1395	$contact['names_ordered'][0] = urldecode($contact['names_ordered'][0]);
	1396	$final[3][$i][1] = $contact['names_ordered'] ? $contact['names_ordered'] : 'none';
	1397	}
[1599]	1398
	1399	/********/
	1400
[1411]	1401	$final[3][$i][2] = $contact['companies']['company1']['title']? urldecode( $contact['companies']['company1']['title'] ) :'none';
[2]	1402
[1599]	1403	//Para exibir a matricula do empregado
	1404	$final[3][$i][8] = $contact['companies']['company1']['empNumber']?$contact['companies']['company1']['empNumber']:'none';
	1405	//Para exibir o setor/lotacao do empregado
	1406	$final[3][$i][9] = $contact['companies']['company1']['department']?$contact['companies']['company1']['department']:'none';
	1407	//Para exibir o celular empresarial do empregado
	1408	$final[3][$i][10] = $contact['companies']['company1']['celPhone']?$contact['companies']['company1']['celPhone']:'none';
	1409
	1410	//Para exibir o celular empresarial do empregado
	1411	if ($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['voip_enabled'] && !$external && $final[3][$i][10] != 'none')
	1412	$final[3][$i][10] = "<a title=\"".lang("Call Mobile")."\" href=\"#\" onclick=\"connectVoip('".$final[3][$i][10]."', 'mob')\">".$final[3][$i][10]."</a>";
	1413
[284]	1414	/* Select the correct Email and Telephone to be shown */
	1415	$preferences = ExecMethod('contactcenter.ui_preferences.get_preferences');
[1599]	1416
[284]	1417	if (!is_array($preferences))
[2]	1418	{
[284]	1419	$preferences['personCardEmail'] = 1;
	1420	$preferences['personCardPhone'] = 2;
	1421	}
	1422	if ($contact['connections'])
	1423	{
	1424	$default_email_found = false;
	1425	$default_phone_found = false;
	1426	foreach($contact['connections'] as $conn_info)
[2]	1427	{
[284]	1428	if ($conn_info['id_type'] == $preferences['personCardEmail'] and !$default_email_found)
[2]	1429	{
[284]	1430	if ($conn_info['connection_is_default'])
	1431	{
	1432	$default_email_found = true;
	1433	}
	1434	$final[3][$i][4] = $conn_info['connection_value'] ? $conn_info['connection_value'] : 'none';
[2]	1435	}
[284]	1436	else if ($conn_info['id_type'] == $preferences['personCardPhone'] and !$default_phone_found)
[2]	1437	{
[284]	1438	if ($conn_info['connection_is_default'])
	1439	{
	1440	$default_phone_found = true;
	1441	}
[1599]	1442
	1443	/rev 104/
	1444	//if ($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['voip_enabled'] && !$external){
	1445	// $conn_info['connection_value'] = "<a title=\"".lang("Call Extension")."\" href=\"#\" onclick=\"connectVoip('".$conn_info['connection_value']."', 'ramal')\">".$conn_info['connection_value']."</a>";
	1446
[285]	1447	if (!($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['telephone_number'] == $conn_info['connection_value']) && $_SESSION['phpgw_info']['user']['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]	1448	$conn_info['connection_value'] = "<a title=\"".lang("Call Extension")."\" href=\"#\" onclick=\"connectVoip('".$conn_info['connection_value']."', 'com')\">".$conn_info['connection_value']."</a>";
[1599]	1449
	1450	/*****/
[285]	1451	}
[284]	1452	$final[3][$i][3] = $conn_info['connection_value'] ? $conn_info['connection_value'] : 'none';
	1453	}
[2]	1454	}
	1455	}
[1599]	1456
[284]	1457	if (!$final[3][$i][3])
	1458	{
	1459	$final[3][$i][3] = 'none';
	1460	}
	1461
	1462	if (!$final[3][$i][4])
	1463	{
	1464	$final[3][$i][4] = 'none';
	1465	}
	1466
[1411]	1467	$final[3][$i][5] = $contact['alias']? urldecode( $contact['alias'] ):'none';
[284]	1468	$final[3][$i][6] = $ids[$i];
	1469
[1599]	1470	/rev 104/
	1471	/* // If contact is a public list, then load the forwarding addresses.
	1472	if($contact['account_type'][0] == 'l')
	1473	$final[3][$i][7] = array();
	1474	*/
	1475
	1476	//If contact is a public list or a group, then load the forwarding addresses.
[880]	1477	if($contact['account_type'][0] == 'l' \|\| $contact['account_type'][0] == 'g')
	1478	$final[3][$i][7] = ($contact['account_type'][0] == 'l' ? 'list' : 'group');
[503]	1479
[752]	1480	if($this->page_info['actual_catalog']['class']=='bo_shared_people_manager') {
[1599]	1481	$final[3][$i][11] = $perms[$i];
	1482	$final[3][$i][12] = lang('Shared').": ".$owner_names[$owners[$i]]['cn'];
[503]	1483	}
[1599]	1484	/******/
[284]	1485
	1486	$final[4][$i] = $contact['photo'] ? 1 : 0;
	1487	$i++;
[2]	1488	}
[284]	1489	else
[2]	1490	{
[284]	1491	// coloca mensagem de erro no vetor que retorna para o browser
[2]	1492	}
[284]	1493	}
	1494	$lnk_compose = "location.href=('../expressoMail1_2/index.php?to=";
	1495	$final[5] = '<span class="link" onclick="'.$lnk_compose;
[1496]	1496	$final[6] = $prop_names;
	1497	$final[7] = $validos;
	1498	$final[8] = $this->page_info['actual_catalog']['class'];
	1499	$final[9] = $count;
[2]	1500
[1599]	1501
[2]	1502	$this->page_info['actual_letter'] = $letter;
	1503	$this->page_info['actual_page'] = $page;
[1599]	1504
	1505	$this->save_session();
[2]	1506	echo serialize($final);
	1507	return;
	1508	}
[1599]	1509
[2]	1510	$this->page_info['actual_letter'] = $letter;
	1511	$this->page_info['actual_page'] = $page;
[1599]	1512
[2]	1513	$this->save_session();
[1599]	1514
[2]	1515	$final[0] = 0;
	1516	$final[1] = $this -> typeContact;
	1517	echo serialize($final);
	1518	}
[1599]	1519
[285]	1520	function get_visible_all_ldap()
	1521	{
	1522	$bo = CreateObject('contactcenter.bo_ldap_manager');
	1523	$ldap_query = $bo->srcs;
[1599]	1524	return $ldap_query[1]['visible'];
[285]	1525	}
[284]	1526
[1599]	1527
[2]	1528	/*!
[1599]	1529
[2]	1530	@function get_group_data
	1531	@abstract Returns all the information of a given Group
	1532	@author Nilton Emilio Buhrer Neto
[1599]	1533
[2]	1534	@param (integer) $id The id to get information
[1599]	1535
	1536	*/
[1280]	1537	function get_group_data($id,$shared_from=null)
[2]	1538	{
	1539	$this->bo->catalog = CreateObject('contactcenter.bo_group_manager');
	1540	$fields = $this->bo->catalog->get_fields(true);
	1541	$data = $this->bo->catalog->get_single_entry($id,$fields);
[285]	1542
	1543	if($id) {
[2]	1544	// get All Contacts by group.
[285]	1545	$data['contact_in_list'] = $this->bo->catalog->get_contacts_by_group($id);
[2]	1546	}
[285]	1547
[2]	1548	$boGroup = CreateObject('contactcenter.bo_group');
[1599]	1549
[1280]	1550	$all_contacts = $boGroup->get_all_contacts('only_email',$shared_from);
[285]	1551
	1552	$contact_options = "";
	1553	if(count($all_contacts)) {
	1554	foreach($all_contacts as $idx => $contact) {
	1555	$contact_options .= "<OPTION value='".$contact['id_connection']."'>".$contact['names_ordered']." (".$contact['connection_value'].")</OPTION>";
	1556	}
	1557	}
[1599]	1558	$data['contact_list'] = $contact_options;
	1559	$data['result'] = 'ok';
[285]	1560	echo serialize($data);
	1561	}
	1562
[2]	1563	/*!
[1599]	1564
[2]	1565	@function get_full_data
	1566	@abstract Returns all the information of a given Entry
	1567	@author Raphael Derosso Pereira
[1599]	1568
[2]	1569	@param (integer) $id The id to get information
[1599]	1570
[2]	1571	*/
[1599]	1572	/rev 104/
	1573	//function get_full_data($id)
[503]	1574	function get_full_data($id,$catalog='bo_people_catalog')
[2]	1575	{
	1576	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
[1599]	1577	/rev 104/
	1578	//$this->bo->catalog = CreateObject('contactcenter.bo_people_catalog');
	1579	$this->bo->catalog = CreateObject('contactcenter.'.$catalog);
	1580	/****/
[2]	1581	$fields = $this->bo->catalog->get_fields(true);
	1582	$fields['photo'] = false;
	1583	$entry = $this->bo->catalog->get_single_entry($id,$fields);
	1584
	1585	if (is_bool($entry['given_names']))
	1586	{
	1587	$data['result'] = 'false';
	1588	echo serialize($data);
	1589	return;
	1590	}
	1591
	1592	$date = explode('-', $entry['birthdate']);
	1593	$j = 0;
	1594	for ($i = 0; $i < 5; $i+=2)
	1595	{
	1596	switch($dateformat{$i})
	1597	{
	1598	case 'Y':
	1599	$birthdate[$j] = $date[0];
	1600	break;
	1601
	1602	case 'm':
	1603	case 'M':
	1604	$birthdate[$j] = $date[1];
	1605	break;
	1606
	1607	case 'd':
	1608	$birthdate[$j] = $date[2];
	1609	}
	1610	$j++;
	1611	}
	1612	$datecount = 0;
[1599]	1613
[2]	1614	$data['result'] = 'ok';
	1615	$data['cc_full_add_contact_id'] = $id;
	1616
	1617	/* Personal Data */
	1618	$data['personal']['cc_pd_photo'] = '../index.php?menuaction=contactcenter.ui_data.data_manager&method=get_photo&id='.$id;
	1619	$data['personal']['cc_pd_alias'] = $entry['alias'];
	1620	$data['personal']['cc_pd_given_names'] = $entry['given_names'];
	1621	$data['personal']['cc_pd_family_names'] = $entry['family_names'];
	1622	$data['personal']['cc_pd_full_name'] = $entry['names_ordered'];
	1623	$data['personal']['cc_pd_suffix'] = $entry['id_suffix'];
	1624	$data['personal']['cc_pd_birthdate_0'] = $birthdate[0];
	1625	$data['personal']['cc_pd_birthdate_1'] = $birthdate[1];
	1626	$data['personal']['cc_pd_birthdate_2'] = $birthdate[2];
	1627	//$data['personal']['cc_pd_sex'] = $entry['sex'] === 'M' ? 1 : ($entry['sex'] === 'F' ? 2 : 0);
	1628	$data['personal']['cc_pd_prefix'] = $entry['id_prefix'];
	1629	$data['personal']['cc_pd_gpg_finger_print'] = $entry['pgp_key'];
	1630	$data['personal']['cc_pd_notes'] = $entry['notes'];
	1631
	1632	/* Addresses */
	1633	if (is_array($entry['addresses']))
	1634	{
	1635	$data['addresses'] = $entry['addresses'];
	1636	}
	1637
	1638	/* Connections */
	1639	if (is_array($entry['connections']))
	1640	{
	1641	$data['connections'] = array();
	1642	foreach ($entry['connections'] as $connection)
	1643	{
	1644	$type = $connection['id_type'];
	1645	$i = count($data['connections'][$type]);
	1646	$data['connections'][$type][$i]['id'] = $connection['id_connection'];
	1647	$data['connections'][$type][$i]['name'] = $connection['connection_name'];
	1648	$data['connections'][$type][$i]['value'] = $connection['connection_value'];
	1649	$data['connections'][$type][$i]['is_default'] = $connection['connection_is_default'];
	1650	}
	1651	}
[1599]	1652	// print_r($data);
	1653	//OBSERVAR cc_department
[1517]	1654	/Corporative/
	1655	$data['personal']['cc_name_corporate'] = $entry['corporate_name'];
	1656	$data['personal']['cc_job_title'] = $entry['job_title'];
	1657	$data['personal']['cc_department'] = $entry['department'];
	1658	$data['personal']['cc_name_corporate'] = $entry['corporate_name'];
	1659	$data['personal']['cc_web_page'] = $entry['web_page'];
[1599]	1660
	1661
[2]	1662	/* Relations */
[1599]	1663
[2]	1664	echo serialize($data);
	1665	}
	1666
	1667	/*!
	1668
	1669	@function get_contact_full_add_const
	1670	@abstract Returns all the constant fields in Contact Full Add Window to the JS
	1671	@author Raphael Derosso Pereira
	1672	*/
	1673	function get_contact_full_add_const()
	1674	{
	1675	$data = array();
	1676	$boPeopleCatalog = CreateObject('contactcenter.bo_people_catalog');
	1677	$predata[] = $boPeopleCatalog -> get_all_prefixes();
	1678	$predata[] = $boPeopleCatalog -> get_all_suffixes();
	1679	$predata[] = $boPeopleCatalog -> get_all_addresses_types();
	1680	$predata[] = $boPeopleCatalog -> get_all_countries();
	1681	$predata[] = $boPeopleCatalog -> get_all_connections_types();
	1682	//$predata[] = $this->bo->catalog->get_all_relations_types();
	1683
	1684	$i = 0;
	1685	foreach($predata as $data_)
	1686	{
	1687	if ($data_)
	1688	{
	1689	$data[$i] = $data_;
	1690	}
	1691
	1692	$i++;
	1693	}
	1694
	1695	if (count($data))
	1696	{
	1697	echo serialize($data);
	1698	return;
	1699	}
[1599]	1700
[2]	1701	echo 0;
	1702	}
[1599]	1703
[2]	1704	/*!
[1599]	1705
[2]	1706	@function quick_add
	1707	@abstract Adds a new Contact using the Quick Add interface
	1708	@author Raphael Derosso Pereira
[1599]	1709
[2]	1710	@param string $sdata Serialized data
	1711	*/
	1712	function quick_add($sdata)
	1713	{
[1599]	1714
[2]	1715	$sdata = str_replace('\\"', '"', $sdata);
	1716	$new_array = unserialize($sdata);
	1717	$tdata = array();
[1599]	1718
[2]	1719	foreach($new_array as $tmp)
	1720	$tdata[] = $tmp;
[1599]	1721
[2]	1722	if (!$tdata)
	1723	{
	1724	echo serialize(array(
	1725	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
	1726	'status' => 'abort'
	1727	));
[1599]	1728
[2]	1729	return;
	1730	}
[1599]	1731
	1732	// verifica se email jï¿œ existe!
[2]	1733	$boGroup = CreateObject('contactcenter.bo_group');
	1734	$contact = $boGroup->verify_contact($tdata[4]);
[1599]	1735
[2]	1736	if($contact)
[1599]	1737	{
[2]	1738	$str_contact = "\r\n - ".implode("\r\n - ",$contact);
[1599]	1739
[2]	1740	echo serialize(array(
	1741	'msg' => lang('Problems on adding your Contact. The email "%1" already exists in: %2',$tdata[4], $str_contact),
	1742	'status' => 'alreadyExists'
	1743	));
[1599]	1744
	1745	return;
[2]	1746	}
	1747
	1748	$data['alias'] = $tdata[0];
	1749	$data['given_names'] = $tdata[1];
	1750	$data['family_names'] = $tdata[2];
	1751	// $data['connections']['default_phone']['id_typeof_connection'] = 1;
	1752	$data['connections']['default_phone']['connection_name'] = lang('Main');
	1753	$data['connections']['default_phone']['connection_value'] = $tdata[3];
	1754	// $data['connections']['default_email']['id_typeof_connection'] = 2;
	1755	$data['connections']['default_email']['connection_name'] = lang('Main');
	1756	$data['connections']['default_email']['connection_value'] = $tdata[4];
	1757	$boPeople = CreateObject('contactcenter.bo_people_catalog');
	1758
	1759	if ($boPeople ->quick_add($data))
[1599]	1760	{
[2]	1761	$this->page_info['changed'] = true;
[1599]	1762
[2]	1763	echo serialize(array(
	1764	'msg' => lang('Entry added with success!'),
	1765	'status' => 'ok'
	1766	));
	1767	}
	1768	else
	1769	{
	1770	echo serialize(array(
	1771	'msg' => lang('Problems on adding your Contact. No Contact added!'),
	1772	'status' => 'error'
	1773	));
	1774	}
	1775
[1599]	1776	$this->save_session();
	1777
[2]	1778	}
	1779
	1780	/*!
[1599]	1781
[2]	1782	@function add_group
	1783	@abstract Adds a new Group using the Add Group interface
	1784	@author Nilton Emilio Buhrer Neto
[1599]	1785
[2]	1786	@param string $sdata Serialized data
	1787	*/
	1788	function add_group($sdata)
	1789	{
	1790	$sdata = str_replace('\\"', '"', $sdata);
	1791	$tdata = unserialize($sdata);
	1792	$new_tdata = array();
[1599]	1793
[2]	1794	if (!$tdata)
	1795	{
	1796	echo serialize(array(
	1797	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
	1798	'status' => 'abort'
	1799	));
[1599]	1800
[2]	1801	return;
	1802	}
[1599]	1803
[2]	1804	foreach($tdata as $tmp)
	1805	$new_tdata[] = $tmp;
[1599]	1806
	1807	$data['title'] = $new_tdata[0];
[2]	1808	$data['contact_in_list'] = $new_tdata[1];
	1809	$data['id_group'] = $new_tdata[2];
[1599]	1810
[2]	1811	$boGroup = CreateObject('contactcenter.bo_group_manager');
	1812	$id = $boGroup -> add_group($data);
[1599]	1813
[2]	1814	if ($id)
	1815	{
	1816	$this->page_info['changed'] = true;
[1599]	1817
[2]	1818	echo serialize(array(
	1819	'msg' => lang('Entry added with success!'),
	1820	'status' => 'ok'
	1821	));
	1822	}
	1823	else
	1824	{
	1825	echo serialize(array(
	1826	'msg' => lang('Problems on adding your Contact. No Contact added!'),
	1827	'status' => 'error'
	1828	));
	1829	}
	1830
	1831	$this->save_session();
	1832	}
	1833
	1834	/*!
[1599]	1835
[2]	1836	@function remove_group
	1837	@abstract Removes a group if the user has the right to do it
[1599]	1838	@author Nilton Emilio Buhrer Neto
[2]	1839	@param (integer) $id The id to be removed
[1599]	1840
[2]	1841	*/
	1842	function remove_group($id)
[1599]	1843	{
	1844	$soGroup = CreateObject('contactcenter.so_group');
[2]	1845	$data = array ('id_group' => $id);
	1846	if($soGroup -> delete($data)) {
	1847	echo serialize(array(
	1848	'msg' => lang('Removed Entry ID '.$id.'!'),
	1849	'status' => 'ok'
[1599]	1850	));
[2]	1851	}
	1852	else {
	1853	echo serialize(array(
	1854	'msg' => lang('Problems on adding your Contact. No Contact added!'),
	1855	'status' => 'error'
	1856	));
	1857	}
	1858
[1599]	1859	$this->save_session();
[2]	1860	}
	1861
	1862
	1863	function remove_all_entries (){
[1599]	1864
[2]	1865	$error = false;
	1866	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
	1867
	1868	foreach($this->all_entries as $index => $id) {
	1869	$result = $this->bo->catalog->remove_single_entry($id);
	1870	if(!$result) {
	1871	$error = true;
[1599]	1872	break;
[2]	1873	}
	1874	}
	1875
	1876	if(!$error) {
	1877	echo serialize(array(
	1878	'msg' => lang('Removed Entry ID '.$id.'!'),
	1879	'status' => 'ok'
	1880	));
[1599]	1881	}
[2]	1882	else {
	1883	echo serialize(array(
	1884	'msg' => lang('Couldn\'t remove this entry. Inform the Site Admin!'),
	1885	'status' => 'fail'
	1886	));
	1887	}
	1888
	1889	$this->save_session();
	1890	}
	1891
	1892	/*!
[1599]	1893
[2]	1894	@function remove_entry
	1895	@abstract Removes an entry if the user has the right to do it
	1896	@author Raphael Derosso Pereira
[1599]	1897
[2]	1898	@param (integer) $id The id to be removed
[1599]	1899
[2]	1900	*/
	1901	function remove_entry ($id)
	1902	{
	1903	if (!is_int($id))
	1904	{
	1905	echo lang('Couldn\'t remove entry! Problem passing data to the server. Please inform admin!');
	1906	return;
	1907	}
[1599]	1908
[2]	1909	$this->page_info['changed'] = true;
	1910	$result = $this->bo->catalog->remove_single_entry($id);
[1599]	1911
[2]	1912	if ($result)
	1913	{
	1914	if ($pos = array_search($id, $this->page_info['actual_entries']))
	1915	{
	1916	unset($this->page_info['actual_entries'][$pos]);
	1917	}
[1599]	1918
[2]	1919	$temp = false;
	1920	reset($this->page_info['actual_entries']);
	1921	foreach($this->page_info['actual_entries'] as $t)
	1922	{
	1923	$temp[] = $t;
	1924	}
[1599]	1925
[2]	1926	$this->page_info['actual_entries'] = $temp;
	1927
	1928	echo serialize(array(
	1929	'msg' => lang('Removed Entry ID '.$id.'!'),
	1930	'status' => 'ok'
	1931	));
	1932	}
	1933	else
	1934	{
	1935	echo serialize(array(
	1936	'msg' => lang('Couldn\'t remove this entry. Inform the Site Admin!'),
	1937	'status' => 'fail'
	1938	));
	1939	}
[1599]	1940
[2]	1941	$this->save_session();
	1942	}
	1943
[1599]	1944
[2]	1945	/*!
[1599]	1946
[2]	1947	@function post_full_add
	1948	@abstract Saves all the information altered/entered in the Full Add
	1949	window
	1950	@author Raphael Derosso Pereira
	1951
	1952	*/
	1953	function post_full_add()
	1954	{
[285]	1955	$data = $_POST['data'];
[1599]	1956	// Exceptions!!! utf8 special chars.
[285]	1957	$data = preg_replace("/\%u2(\d+)(\d+)(\d+)/","-",$data);
	1958	$data = unserialize(str_replace('\\"', '"', $data));
[2]	1959	$this -> bo -> catalog = CreateObject('contactcenter.bo_people_catalog');
	1960
	1961	if (!is_array($data))
	1962	{
	1963	echo serialize(array(
	1964	'msg' => lang('<p>Some problem receiving data from browser. This is probably a bug in ContactCenter<br>'.
	1965	'Please go to eGroupWare Bug Reporting page and report this bug.<br>'.
	1966	'Sorry for the inconvenient!<br><br>'.
	1967	'<b><i>ContactCenter Developer Team</i></b></p>'),
	1968	'status' => 'fatal'
	1969	));
	1970	return;
	1971	}
	1972	// print_r($data);
	1973	// echo '<br><br>';
	1974
	1975	$replacer = $data['commercialAnd'];
	1976	unset($data['commercialAnd']);
	1977	if (!is_string($replacer) or strpos($replacer, "'") or strpos($replacer, '"'))
	1978	{
	1979	echo serialize(array(
	1980	'msg' => lang('Invalid \'&\' replacer! This may be an attempt to bypass Security! Action aborted!'),
	1981	'status' => 'fatal'
	1982	));
[1599]	1983
[2]	1984	return;
	1985	}
	1986
	1987	if ($data['id_contact'])
	1988	{
	1989	$id = $data['id_contact'];
	1990	$id_photo = $id;
	1991	unset($data['id_contact']);
	1992	}
	1993	else
	1994	{
	1995	$id_photo = '_new_';
	1996	}
[1599]	1997
	1998	/*
	1999	* Process Photo, if available
[2]	2000	*/
	2001	$sleep_count = 0;
	2002	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
	2003	while($photo_ok[0]{0} !== 'o' and $photo_ok[1]{0} === 'y')
	2004	{
	2005	sleep(1);
	2006	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
	2007	$sleep_count++;
	2008
	2009	if ($sleep_count > 35)
	2010	{
	2011	// TODO
	2012	return;
	2013	}
	2014	}
	2015	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'n'));
[1599]	2016
[2]	2017	if (isset($this->page_info['photos'][$id_photo]))
	2018	{
	2019	if (array_search($this->page_info['photos'][$id_photo]['status'], array('changed', 'sync')) === false)
	2020	{
	2021	echo serialize(array(
	2022	'msg' => $this->page_info['photos'][$id_photo]['msg'],
	2023	'status' => $this->page_info['photos'][$id_photo]['status']
	2024	));
	2025
	2026	return;
	2027	}
	2028
	2029	$data['photo'] = $this->page_info['photos'][$id_photo]['content'];
	2030	unset($this->page_info['photos'][$id_photo]);
	2031	$this->save_session();
	2032	}
[1599]	2033
[2]	2034	/*
	2035	* Arrange Date so it gets inserted correctly
	2036	*/
[1599]	2037
[2]	2038	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
[1599]	2039
[2]	2040	$j = 0;
	2041	for ($i = 0; $i < 5; $i+=2)
	2042	{
	2043	switch($dateformat{$i})
	2044	{
	2045	case 'Y':
	2046	$date[$j]['size'] = 4;
	2047	$date[$j]['digit'] = 'Y';
	2048	break;
	2049
	2050	case 'm':
	2051	case 'M':
	2052	$date[$j]['size'] = 2;
	2053	$date[$j]['digit'] = 'M';
	2054	break;
	2055
	2056	case 'd':
	2057	$date[$j]['size'] = 2;
	2058	$date[$j]['digit'] = 'D';
	2059	}
	2060	$j++;
	2061	}
	2062	$datecount = 0;
	2063
	2064	/* Verify Data and performs insertion/update */
[1411]	2065	foreach($data as $field => &$value)
[2]	2066	{
	2067	if ($value == '' or is_null($value))
	2068	{
	2069	unset($data[$field]);
	2070	continue;
	2071	}
[1599]	2072
[2]	2073	switch($field)
	2074	{
[1517]	2075	case 'corporate_name':
	2076	case 'job_title':
	2077	case 'department':
	2078	case 'web_page':
[2]	2079	case 'alias':
	2080	case 'given_names':
	2081	case 'family_names':
	2082	case 'names_ordered':
	2083	case 'pgp_key':
	2084	case 'notes':
	2085	case 'photo':
[1411]	2086	$value = urldecode( $value );
[2]	2087	/* Do Nothing. This is just to make sure no invalid field is passed */
	2088	break;
[1599]	2089
[2]	2090	case 'id_status':
	2091	case 'id_prefix':
	2092	case 'id_suffix':
	2093	if ($data[$field] == 0)
	2094	{
	2095	unset($data[$field]);
	2096	}
	2097	break;
[1599]	2098
[2]	2099	case 'birthdate_0':
	2100	case 'birthdate_1':
	2101	case 'birthdate_2':
[1599]	2102
[2]	2103	switch($date[$datecount]['digit'])
	2104	{
	2105	case 'Y':
	2106	$date['value'][2] = (int) $data[$field];
	2107	break;
	2108
	2109	case 'M':
	2110	$date['value'][0] = (int) $data[$field];
	2111	break;
	2112
	2113	case 'D':
	2114	$date['value'][1] = (int) $data[$field];
	2115	break;
	2116	}
	2117	unset($data[$field]);
	2118	$datecount++;
	2119
	2120	if ($datecount != 3)
	2121	{
	2122	break;
	2123	}
[1599]	2124
[2]	2125	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
	2126	{
	2127	echo serialize(array(
	2128	'msg' => lang('Invalid Date'),
	2129	'status' => 'invalid_data'
	2130	));
	2131	return;
	2132	}
[1599]	2133
[2]	2134	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
	2135	break;
	2136
	2137	case 'sex':
	2138	if ($data[$field] !== 'M' and $data[$field] !== 'F')
	2139	{
	2140	echo serialize(array(
	2141	'msg' => lang('Invalid Sex'),
	2142	'status' => 'invalid_data'
	2143	));
	2144	return;
	2145	}
	2146	break;
	2147
	2148
	2149	case 'addresses':
	2150	/* Insert new cities/states */
	2151	if (isset($value['new_states']))
	2152	{
	2153	foreach($value['new_states'] as $type => $state_info)
	2154	{
	2155	$index = 'address'.$type;
[1599]	2156
[2]	2157	$id_state = $this->bo->catalog->add_state($state_info);
	2158	$data['addresses'][$index]['id_state'] = $id_state;
	2159
	2160	if ($value['new_cities'][$type])
	2161	{
	2162	$value['new_cities'][$type]['id_state'] = $id_state;
	2163	}
	2164	}
	2165
	2166	unset($data['addresses']['new_states']);
	2167	}
	2168
	2169	if (isset($value['new_cities']))
	2170	{
	2171	foreach($value['new_cities'] as $type => $city_info)
	2172	{
	2173	$index = 'address'.$type;
[1599]	2174
[2]	2175	$id_city = $this->bo->catalog->add_city($city_info);
	2176	$data['addresses'][$index]['id_city'] = $id_city;
	2177	}
	2178
	2179	unset($data['addresses']['new_cities']);
	2180	}
	2181
	2182	break;
	2183
	2184	case 'connections':
	2185	/* Does nothing... */
	2186	break;
	2187
	2188	default:
	2189	echo serialize(array(
	2190	'msg' => lang('Invalid field: ').$field,
	2191	'status' => 'invalid_data'
	2192	));
	2193	return;
	2194	}
	2195	}
	2196
	2197	$code = '$id = $this->bo->catalog->';
	2198
	2199	if (!is_null($id) and $id !== '')
	2200	{
	2201	$code .= $code.'update_single_info($id, $data);';
	2202	$result = array(
	2203	'msg' => lang('Updated Successfully!'),
	2204	'status' => 'ok'
	2205	);
	2206	}
	2207	else
	2208	{
	2209	$code .= 'add_single_entry($data);';
	2210	$result = array(
	2211	'msg' => lang('Entry Added Successfully!'),
	2212	'status' => 'ok'
	2213	);
	2214	}
[1599]	2215
[2]	2216	eval($code);
	2217
	2218	if (!($id))
	2219	{
	2220	$result = array(
	2221	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
	2222	'Report the problem to the Administrator.'),
	2223	'status' => 'fail'
	2224	);
	2225	}
	2226
	2227	echo serialize($result);
	2228	}
	2229
[1496]	2230
	2231	function post_full_add_shared()
	2232	{
	2233	$data = $_POST['data'];
[1599]	2234	// Exceptions!!! utf8 special chars.
[1496]	2235	$data = preg_replace("/\%u2(\d+)(\d+)(\d+)/","-",$data);
	2236	$data = unserialize(str_replace('\\"', '"', $data));
	2237	$this -> bo -> catalog = CreateObject('contactcenter.bo_shared_people_manager');
	2238
	2239	if (!is_array($data))
	2240	{
	2241	echo serialize(array(
	2242	'msg' => lang('<p>Some problem receiving data from browser. This is probably a bug in ContactCenter<br>'.
	2243	'Please go to eGroupWare Bug Reporting page and report this bug.<br>'.
	2244	'Sorry for the inconvenient!<br><br>'.
	2245	'<b><i>ContactCenter Developer Team</i></b></p>'),
	2246	'status' => 'fatal'
	2247	));
	2248	return;
	2249	}
	2250	// print_r($data);
	2251	// echo '<br><br>';
	2252
	2253	$replacer = $data['commercialAnd'];
	2254	unset($data['commercialAnd']);
	2255	if (!is_string($replacer) or strpos($replacer, "'") or strpos($replacer, '"'))
	2256	{
	2257	echo serialize(array(
	2258	'msg' => lang('Invalid \'&\' replacer! This may be an attempt to bypass Security! Action aborted!'),
	2259	'status' => 'fatal'
	2260	));
[1599]	2261
[1496]	2262	return;
	2263	}
	2264
	2265	if ($data['id_contact'])
	2266	{
	2267	$id = $data['id_contact'];
	2268	$id_photo = $id;
	2269	unset($data['id_contact']);
	2270	}
	2271	else
	2272	{
	2273	$id_photo = '_new_';
	2274	}
	2275
	2276	if ($data['owner'])
	2277	{
	2278	$owner = $data['owner'];
	2279	unset($data['owner']);
	2280	}
[1599]	2281	/*
	2282	* Process Photo, if available
[1496]	2283	*/
	2284	$sleep_count = 0;
	2285	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
	2286	while($photo_ok[0]{0} !== 'o' and $photo_ok[1]{0} === 'y')
	2287	{
	2288	sleep(1);
	2289	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
	2290	$sleep_count++;
	2291
	2292	if ($sleep_count > 35)
	2293	{
	2294	// TODO
	2295	return;
	2296	}
	2297	}
	2298	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'n'));
[1599]	2299
[1496]	2300	if (isset($this->page_info['photos'][$id_photo]))
	2301	{
	2302	if (array_search($this->page_info['photos'][$id_photo]['status'], array('changed', 'sync')) === false)
	2303	{
	2304	echo serialize(array(
	2305	'msg' => $this->page_info['photos'][$id_photo]['msg'],
	2306	'status' => $this->page_info['photos'][$id_photo]['status']
	2307	));
	2308
	2309	return;
	2310	}
	2311
	2312	$data['photo'] = $this->page_info['photos'][$id_photo]['content'];
	2313	unset($this->page_info['photos'][$id_photo]);
	2314	$this->save_session();
	2315	}
[1599]	2316
[1496]	2317	/*
	2318	* Arrange Date so it gets inserted correctly
	2319	*/
[1599]	2320
[1496]	2321	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
[1599]	2322
[1496]	2323	$j = 0;
	2324	for ($i = 0; $i < 5; $i+=2)
	2325	{
	2326	switch($dateformat{$i})
	2327	{
	2328	case 'Y':
	2329	$date[$j]['size'] = 4;
	2330	$date[$j]['digit'] = 'Y';
	2331	break;
	2332
	2333	case 'm':
	2334	case 'M':
	2335	$date[$j]['size'] = 2;
	2336	$date[$j]['digit'] = 'M';
	2337	break;
	2338
	2339	case 'd':
	2340	$date[$j]['size'] = 2;
	2341	$date[$j]['digit'] = 'D';
	2342	}
	2343	$j++;
	2344	}
	2345	$datecount = 0;
	2346
	2347	/* Verify Data and performs insertion/update */
	2348	foreach($data as $field => &$value)
	2349	{
	2350	if ($value == '' or is_null($value))
	2351	{
	2352	unset($data[$field]);
	2353	continue;
	2354	}
[1599]	2355
[1496]	2356	switch($field)
	2357	{
	2358	case 'alias':
	2359	case 'given_names':
	2360	case 'family_names':
	2361	case 'names_ordered':
	2362	case 'pgp_key':
	2363	case 'notes':
	2364	case 'photo':
	2365	$value = urldecode( $value );
	2366	/* Do Nothing. This is just to make sure no invalid field is passed */
	2367	break;
[1599]	2368
[1496]	2369	case 'id_status':
	2370	case 'id_prefix':
	2371	case 'id_suffix':
	2372	if ($data[$field] == 0)
	2373	{
	2374	unset($data[$field]);
	2375	}
	2376	break;
[1599]	2377
[1496]	2378	case 'birthdate_0':
	2379	case 'birthdate_1':
	2380	case 'birthdate_2':
[1599]	2381
[1496]	2382	switch($date[$datecount]['digit'])
	2383	{
	2384	case 'Y':
	2385	$date['value'][2] = (int) $data[$field];
	2386	break;
	2387
	2388	case 'M':
	2389	$date['value'][0] = (int) $data[$field];
	2390	break;
	2391
	2392	case 'D':
	2393	$date['value'][1] = (int) $data[$field];
	2394	break;
	2395	}
	2396	unset($data[$field]);
	2397	$datecount++;
	2398
	2399	if ($datecount != 3)
	2400	{
	2401	break;
	2402	}
[1599]	2403
[1496]	2404	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
	2405	{
	2406	echo serialize(array(
	2407	'msg' => lang('Invalid Date'),
	2408	'status' => 'invalid_data'
	2409	));
	2410	return;
	2411	}
[1599]	2412
[1496]	2413	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
	2414	break;
	2415
	2416	case 'sex':
	2417	if ($data[$field] !== 'M' and $data[$field] !== 'F')
	2418	{
	2419	echo serialize(array(
	2420	'msg' => lang('Invalid Sex'),
	2421	'status' => 'invalid_data'
	2422	));
	2423	return;
	2424	}
	2425	break;
	2426
	2427
	2428	case 'addresses':
	2429	/* Insert new cities/states */
	2430	if (isset($value['new_states']))
	2431	{
	2432	foreach($value['new_states'] as $type => $state_info)
	2433	{
	2434	$index = 'address'.$type;
[1599]	2435
[1496]	2436	$id_state = $this->bo->catalog->add_state($state_info);
	2437	$data['addresses'][$index]['id_state'] = $id_state;
	2438
	2439	if ($value['new_cities'][$type])
	2440	{
	2441	$value['new_cities'][$type]['id_state'] = $id_state;
	2442	}
	2443	}
	2444
	2445	unset($data['addresses']['new_states']);
	2446	}
	2447
	2448	if (isset($value['new_cities']))
	2449	{
	2450	foreach($value['new_cities'] as $type => $city_info)
	2451	{
	2452	$index = 'address'.$type;
[1599]	2453
[1496]	2454	$id_city = $this->bo->catalog->add_city($city_info);
	2455	$data['addresses'][$index]['id_city'] = $id_city;
	2456	}
	2457
	2458	unset($data['addresses']['new_cities']);
	2459	}
	2460
	2461	break;
	2462
	2463	case 'connections':
	2464	/* Does nothing... */
	2465	break;
	2466
	2467	default:
	2468	echo serialize(array(
	2469	'msg' => lang('Invalid field: ').$field,
	2470	'status' => 'invalid_data'
	2471	));
	2472	return;
	2473	}
	2474	}
	2475
	2476	$code = '$id = $this->bo->catalog->';
	2477
	2478	if (!is_null($id) and $id !== '')
	2479	{
	2480	$code .= $code.'update_single_info($id, $data);';
	2481	$result = array(
	2482	'msg' => lang('Updated Successfully!'),
	2483	'status' => 'ok'
	2484	);
	2485	}
	2486	else
	2487	{
	2488	$code .= 'add_single_entry($data,'.$owner.');';
	2489	$result = array(
	2490	'msg' => lang('Entry Added Successfully!'),
	2491	'status' => 'ok'
	2492	);
	2493	}
[1599]	2494
[1496]	2495	eval($code);
	2496
	2497	if (!($id))
	2498	{
	2499	$result = array(
	2500	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
	2501	'Report the problem to the Administrator.'),
	2502	'status' => 'fail'
	2503	);
	2504	}
	2505
	2506	echo serialize($result);
	2507	}
[2]	2508	/*!
[1599]	2509
[2]	2510	@function post_photo
	2511	@abstract Wrapper to post a photo without reload a page.
	2512	@author Raphael Derosso Pereira
	2513
	2514	*/
	2515	function post_photo($id)
	2516	{
	2517	//print_r($_FILES);
	2518	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'y'));
[1599]	2519
[2]	2520	if (!is_array($_FILES) and is_array(!$_FILES['cc_pd_photo']))
	2521	{
	2522	$this->page_info['photos'][$id]['status'] = 'no_upload';
	2523	$this->page_info['photos'][$id]['msg'] = lang('No Photos uploaded to Server.');
[1599]	2524
[2]	2525	$this->save_session();
	2526	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2527	return;
	2528	}
	2529
	2530	if (!function_exists('imagecreate'))
	2531	{
	2532	$this->page_info['photos'][$id]['status'] = 'no_GD_lib';
	2533	$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]	2534
[2]	2535	$this->save_session();
	2536	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2537	return;
	2538	}
	2539
	2540	// TODO: Get Max Size from preferences!
	2541	if ($_FILES['cc_pd_photo']['size'] > 1000000)
	2542	{
	2543	$this->page_info['photos'][$id]['status'] = 'too_large';
	2544	$this->page_info['photos'][$id]['msg'] = lang('Image too large! ContactCenter limits the image size to 1 Mb');
	2545
	2546	$this->save_session();
	2547	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2548	return;
	2549	}
	2550
	2551	if ($_FILES['cc_pd_photo']['error'])
	2552	{
	2553	$this->page_info['photos'][$id]['status'] = 'error';
	2554	$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'];
	2555
	2556	$this->save_session();
	2557	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2558	return;
	2559	}
[1599]	2560
[2]	2561	switch($_FILES['cc_pd_photo']['type'])
	2562	{
	2563	case 'image/jpeg':
	2564	case 'image/pjpeg':
	2565	$src_img = imagecreatefromjpeg($_FILES['cc_pd_photo']['tmp_name']);
	2566	if ($src_img == '')
	2567	{
	2568	$bogus = true;
	2569	}
	2570	break;
	2571
	2572	case 'image/png':
	2573	case 'image/x-png':
	2574	$src_img = imagecreatefrompng($_FILES['cc_pd_photo']['tmp_name']);
	2575	if ($src_img == '')
	2576	{
	2577	$bogus = true;
	2578	}
	2579	break;
	2580
	2581	case 'image/gif':
	2582	$src_img = imagecreatefromgif($_FILES['cc_pd_photo']['tmp_name']);
	2583	if ($src_img == '')
	2584	{
	2585	$bogus = true;
	2586	}
	2587	break;
	2588
	2589	default:
[1599]	2590
[2]	2591	$this->page_info['photos'][$id]['status'] = 'invalid_image';
	2592	$this->page_info['photos'][$id]['msg'] = lang('The file must be an JPEG, PNG or GIF Image.');
	2593
	2594	$this->save_session();
	2595	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2596	return;
	2597	}
	2598
	2599	if ($bogus)
	2600	{
	2601	$this->page_info['photos'][$id]['status'] = 'invalid_file';
	2602	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
[1599]	2603
[2]	2604	$this->save_session();
	2605	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2606	return;
	2607	}
[1599]	2608
[2]	2609	$img_size = getimagesize($_FILES['cc_pd_photo']['tmp_name']);
	2610	$dst_img = imagecreatetruecolor(60, 80);
[1599]	2611
[2]	2612	if (!imagecopyresized($dst_img, $src_img, 0, 0, 0, 0, 60, 80, $img_size[0], $img_size[1]))
	2613	{
	2614	$this->page_info['photos'][$id]['status'] = 'invalid_file';
	2615	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
[1599]	2616
[2]	2617	$this->save_session();
	2618	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2619	return;
	2620	}
[1599]	2621
[2]	2622	ob_start();
	2623	imagepng($dst_img);
	2624	$this->page_info['photos'][$id]['content'] = ob_get_contents();
	2625	ob_end_clean();
	2626
	2627	$this->page_info['photos'][$id]['status'] = 'changed';
	2628	$this->page_info['photos'][$id]['msg'] = lang('Photo Successfully Updated!');
	2629
	2630	$this->save_session();
[1599]	2631
[2]	2632	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
	2633
	2634	imagedestroy($src_img);
	2635	imagedestroy($dst_img);
	2636	echo 'ok';
	2637	return;
	2638	}
	2639
	2640
	2641	/*!
	2642
	2643	@function get_photo
	2644	@abstract Returns the photo to the browser
	2645	@author Raphael Derosso Pereira
	2646
	2647	*/
	2648	function get_photo($id)
	2649	{
	2650	$fields = $this->bo->catalog->get_fields(false);
	2651	$fields['photo'] = true;
[1599]	2652
[2]	2653	$contact = $this->bo->catalog->get_single_entry($id, $fields);
	2654
	2655	if (!$contact['photo'])
	2656	{
	2657	header('Content-type: image/png');
	2658	echo file_get_contents(PHPGW_INCLUDE_ROOT.'/contactcenter/templates/default/images/photo_celepar.png');
	2659	return;
	2660	}
[1599]	2661
[2]	2662	header('Content-type: image/jpeg');
	2663	$photo = imagecreatefromstring ($contact['photo']);
	2664	$width = imagesx($photo);
	2665	$height = imagesy($photo);
[16]	2666	$twidth = 70;
	2667	$theight = 90;
[2]	2668	$small_photo = imagecreatetruecolor ($twidth, $theight);
	2669	imagecopyresampled($small_photo, $photo, 0, 0, 0, 0,$twidth, $theight, $width, $height);
	2670	imagejpeg($small_photo,"",100);
	2671	return;
	2672	}
[1599]	2673
[2]	2674	/*!
[1599]	2675
[2]	2676	@function get_states
	2677	@abstract Echos a serialized array containing all the states for the given country
	2678	@author Raphael Derosso Pereira
	2679
	2680	@params $id_country The ID of the Country that contains the requested states
	2681
	2682	*/
	2683	function get_states($id_country)
	2684	{
	2685	$states = $this->bo->catalog->get_all_states($id_country);
	2686
	2687	if (!$states)
	2688	{
	2689	$result = array(
	2690	'msg' => lang('No States found for this Country.'),
	2691	'status' => 'empty'
	2692	);
	2693
	2694	echo serialize($result);
	2695	return;
	2696	}
[1599]	2697
[2]	2698	$result = array(
	2699	'msg' => lang('States Successfully retrieved!'),
	2700	'status' => 'ok'
	2701	);
[1599]	2702
[2]	2703	foreach ($states as $state_info)
	2704	{
	2705	$result['data'][$state_info['id_state']] = $state_info['name'];
	2706
	2707	if ($state_info['symbol'])
	2708	{
	2709	$result['data'][$state_info['id_state']] .= ', '.$state_info['symbol'];
	2710	}
	2711	}
	2712
	2713	echo serialize($result);
	2714	}
	2715
	2716	/*!
	2717
	2718	@function get_cities
	2719	@abstract Echos a serialized array containing all the cities of a given state
	2720	@author Raphael Derosso Pereira
	2721
	2722	@param $id_country The ID of the Country that has the specified Cities (in case the
	2723	Country doesn't have any States)
	2724	@param $id_state The ID of the State that has the Cities requested
	2725
	2726	*/
	2727	function get_cities($id_country, $id_state=false)
	2728	{
	2729	$cities = $this->bo->catalog->get_all_cities($id_country, $id_state);
	2730
	2731	if (!$cities)
	2732	{
	2733	$result = array(
	2734	'msg' => lang('No Cities found for this State.'),
	2735	'status' => 'empty'
	2736	);
	2737
	2738	echo serialize($result);
	2739	return;
	2740	}
[1599]	2741
[2]	2742	$result = array(
	2743	'msg' => lang('Cities Successfully retrieved!'),
	2744	'status' => 'ok'
	2745	);
[1599]	2746
[2]	2747	foreach ($cities as $city_info)
	2748	{
	2749	$result['data'][$city_info['id_city']] = $city_info['name'];
	2750	}
[1599]	2751
[2]	2752	echo serialize($result);
	2753	}
	2754
	2755
	2756	/*!
[1599]	2757
[2]	2758	@function search
	2759	@abstract Echos a serialized array containing the IDs
	2760	of the entries that matches the search argument
	2761	@author Raphael Derosso Pereira
[1599]	2762	@author Mï¿œrio Cï¿œsar Kolling (external catalogs)
[2]	2763
	2764	@param string $str_data A serialized array with two informations:
	2765	$data = array(
	2766	'search_for' => (string),
	2767	'recursive' => (boolean),
	2768	);
	2769
	2770	*/
[285]	2771	// SERPRO
[2]	2772	function search($str_data)
	2773	{
	2774	$data = unserialize($str_data);
[284]	2775	// It's an external catalog?
	2776	$external = $this->bo->is_external($this->page_info['actual_catalog']);
[2]	2777
[1599]	2778	if (!is_array($data) \|\| !$data['search_for'] \|\| !is_array($data['fields']))
	2779	{
	2780	echo serialize(array(
	2781	'msg' => lang('Invalid parameters'),
	2782	'status' => 'abort'
	2783	));
	2784
	2785	return array('error' => lang('Invalid parameters'));
	2786	}
	2787
	2788
[284]	2789	/*
	2790	* TODO: look into the database to discover the database's encoding and convert the search_for field accordingly
	2791	*/
	2792	// Support search parameters with accentuation
	2793	if ($this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
[1599]	2794	/rev 104/
	2795	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
[503]	2796	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
[752]	2797	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
	2798	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
[1599]	2799	/****/
[284]	2800	{
	2801
	2802	$data['search_for'] = utf8_encode($data['search_for']);
	2803	}
	2804
[1599]	2805	$rules = array();
	2806
	2807	if ($data['search_for'] === '*')
	2808	{
	2809	$rules = array(
	2810	0 => array(
	2811	'field' => $data['fields']['search'],
	2812	'type' => 'LIKE',
	2813	'value' => '%'
	2814	)
	2815	);
	2816	}
	2817	else
	2818	{
	2819	$names = explode(' ', $data['search_for']);
	2820
	2821	if (!is_array($names))
	2822	{
	2823	echo serialize(array(
	2824	'msg' => lang('Invalid Search Parameter'),
	2825	'status' => 'abort'
	2826	));
	2827
	2828	}
	2829
[284]	2830	if (!$external && $this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
[1599]	2831	/rev 104/
	2832	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
[503]	2833	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
[1599]	2834	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
[752]	2835	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager' )
[1599]	2836	/*****/
[284]	2837	{
	2838	/*
	2839	* Restrict the returned contacts search to objectClass = phpgwAccount,
[880]	2840	* must have attibute phpgwAccountStatus, phpgwAccountVisible != -1
[284]	2841	*/
	2842	$rules = array(
	2843	0 => array(
	2844	'field' => 'contact.object_class',
	2845	'type' => '=',
	2846	'value' => 'phpgwAccount'
	2847	),
	2848	1 => array(
	2849	'field' => 'contact.account_status',
	2850	'type' => 'iLIKE',
	2851	'value' => '%'
	2852	),
[1599]	2853	/rev 104/
	2854	///
	2855	//1 => array(
[284]	2856	2 => array(
[1599]	2857	/*****/
[284]	2858	'field' => 'contact.account_visible',
	2859	'type' => '!=',
	2860	'value' => '-1'
[1599]	2861	/rev 104/
	2862	/* ),
	2863	2 => array(
	2864	'field' => 'contact.object_class',
	2865	'type' => '=',
	2866	'value' => 'inetOrgPerson'
	2867	/****/
[284]	2868	),
	2869	);
	2870	}
	2871
[1599]	2872	foreach ($names as $name)
	2873	{
	2874	if ($name != '')
	2875	{
	2876	array_push($rules, array(
	2877	'field' => $data['fields']['search'],
	2878	'type' => 'iLIKE',
	2879	'value' => '%'.$name.'%'
	2880	));
	2881	}
	2882	}
	2883	}
	2884
[284]	2885	if ($external \|\| $this->page_info['actual_catalog']['class'] == 'bo_people_catalog' \|\|
[1599]	2886	/rev 104/
	2887	//$this->page_info['actual_catalog']['class'] == 'bo_group_manager')
[503]	2888	$this->page_info['actual_catalog']['class'] == 'bo_group_manager' \|\|
[752]	2889	$this->page_info['actual_catalog']['class'] == 'bo_shared_people_manager' \|\|
[1599]	2890	$this->page_info['actual_catalog']['class'] == 'bo_shared_group_manager')
	2891
	2892
	2893	/***/
[2]	2894	{
[284]	2895	// Get only this attributes: dn, cn for external catalogs,
	2896	// used to restrict the attributes used in filters
	2897	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'));
[2]	2898	}
[284]	2899	else
	2900	{
	2901	// Get only this attributes: dn, cn, phpgwAccountType, objectClass, phpgwAccountStatus, phpghAccountVisible
	2902	// for non-external catalogs, used to restrict the attributes used in filters
	2903	$ids = $this->bo->find(array(
	2904	$data['fields']['id'],
	2905	$data['fields']['search'],
	2906	'contact.object_class',
[304]	2907	//'contact.account_status',
[284]	2908	'contact.account_visible'
[1599]	2909	), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'), $data['search_for_area'] );
[284]	2910	}
[2]	2911
[1599]	2912	if (!is_array($ids) \|\| !count($ids))
	2913	{
[284]	2914	$this->last_search_ids = null;
	2915	$this->save_session();
	2916	return null;
[1599]	2917	}
[2]	2918
[1599]	2919	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
[2]	2920
[1599]	2921	$ids_f = array();
	2922
	2923	foreach ($ids as $e_info)
	2924	{
	2925	/rev 104/
	2926	//$ids_f[] = $e_info[$id_field];
[752]	2927	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
[1599]	2928	{
	2929	$ids_f[] = $e_info[$id_field];
	2930	} else{
	2931	$ids_f[] = array(0=>$e_info[$id_field],1=>$e_info['perms']);
	2932	}
	2933	/****/
	2934	}
[284]	2935
	2936	return $ids_f;
[2]	2937	}
[1599]	2938
[285]	2939	// CELEPAR
	2940	/*
	2941	function search($str_data)
	2942	{
	2943	$data = unserialize($str_data);
[2]	2944
[285]	2945	if (!is_array($data) \|\| !$data['search_for'] \|\| !is_array($data['fields']))
	2946	{
	2947	echo serialize(array(
	2948	'msg' => lang('Invalid parameters'),
	2949	'status' => 'abort'
	2950	));
	2951
	2952	return;
	2953	}
	2954
	2955	$rules = array();
	2956
	2957	if ($data['search_for'] === '*')
	2958	{
	2959	$rules = array(
	2960	0 => array(
	2961	'field' => $data['fields']['search'],
	2962	'type' => 'LIKE',
	2963	'value' => '%'
	2964	)
	2965	);
	2966	}
	2967	else
	2968	{
	2969	$names = explode(' ', $data['search_for']);
	2970
	2971	if (!is_array($names))
	2972	{
	2973	echo serialize(array(
	2974	'msg' => lang('Invalid Search Parameter'),
	2975	'status' => 'abort'
	2976	));
[1599]	2977
[285]	2978	return;
	2979	}
[1599]	2980
[285]	2981	foreach ($names as $name)
	2982	{
	2983	if ($name != '')
	2984	{
	2985	array_push($rules, array(
	2986	'field' => $data['fields']['search'],
	2987	'type' => 'iLIKE',
	2988	'value' => '%'.$name.'%'
	2989	));
	2990	}
	2991	}
	2992	}
	2993
[1599]	2994
	2995
[285]	2996	//$catalog = $this->bo->get_branch_by_level($this->bo->catalog_level[0]);
[1599]	2997
[285]	2998	//if ($catalog['class'] === 'bo_people_catalog')
	2999	//{
	3000	// array_push($rules, array(
	3001	// 'field' => 'contact.id_owner',
	3002	// 'type' => '=',
	3003	// 'value' => $GLOBALS['phpgw_info']['user']['account_id']
	3004	// ));
	3005	//}
[1599]	3006
	3007
[285]	3008	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'));
	3009
	3010	if (!is_array($ids) \|\| !count($ids))
	3011	{
	3012	echo serialize(array(
	3013	'msg' => lang('No Entries Found!'),
	3014	'status' => 'empty'
	3015	));
	3016
	3017	return;
	3018	}
	3019	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
	3020
	3021	$ids_f = array();
	3022	foreach ($ids as $e_info)
	3023	{
	3024	$ids_f[] = $e_info[$id_field];
	3025	}
	3026
	3027	echo serialize(array(
	3028	'data' => $ids_f,
	3029	'msg' => lang('Found %1 Entries', count($ids)),
	3030	'status' => 'ok'
	3031	));
[1599]	3032
[285]	3033	return;
	3034	}*/
[2]	3035	/*!
	3036
	3037	@function get_multiple_entries
	3038	@abstract Returns an array containing the specifiend data in the default
	3039	CC UI format
	3040	@author Raphael Derosso Pereira
	3041
[1599]	3042	@param array str_data A serialized array containing the ID's of the entries
[2]	3043	to be taken, the fields to be taken and the rules to be used on the
	3044	retrieval:
	3045	$data = array(
	3046	'ids' => array(...),
	3047	'fields' => array(...),
	3048	'rules' => array(...)
	3049	);
	3050
	3051	*/
	3052	function get_multiple_entries($str_data)
	3053	{
	3054	$data = unserialize($str_data);
[1599]	3055
[2]	3056	if (!is_array($data) or !count($data) or !count($data['fields']) or !count($data['ids']))
	3057	{
	3058	return array(
	3059	'msg' => lang('Invalid Parameters'),
	3060	'status' => 'abort'
	3061	);
	3062	}
	3063
	3064	$entries = $this->bo->catalog->get_multiple_entries($data['ids'], $data['fields']);
[1599]	3065
[2]	3066	if (!is_array($entries) or !count($entries))
	3067	{
	3068	return array(
	3069	'msg' => lang('No Entries Found!'),
	3070	'status' => 'empty'
	3071	);
	3072	}
	3073
	3074	return array(
	3075	'msg' => lang('Found %1 Entries!', count($entries)),
	3076	'status' => 'ok',
	3077	'data' => $entries
	3078	);
	3079	}
	3080
	3081	/*
	3082
	3083	@function get_all_entries
[1599]	3084	@abstract Returns the specified fields for all catalog's entries
[2]	3085	in the default CC UI format
	3086	@author Raphael Derosso Pereira
	3087
[1599]	3088	@params array str_data A serialized array containing the fields to
[2]	3089	be grabbed, the maximum number of entries to be returned and a
	3090	boolean specifying if the calls refers to a new grab or to an
	3091	unfinished one.
	3092
	3093	*/
	3094	function get_all_entries($str_data)
	3095	{
	3096	$data = unserialize($str_data);
[1599]	3097
	3098	if (!is_array($data) or
	3099	!count($data) or
	3100	!count($data['fields']) or
[2]	3101	!$data['maxlength'] or
	3102	(!$data['new'] and !$data['offset']))
	3103	{
	3104	return array(
	3105	'msg' => lang('Invalid Parameters'),
	3106	'status' => 'abort'
	3107	);
	3108	}
	3109
	3110	if ($data['new'])
	3111	{
	3112	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
	3113
	3114	$this->save_session();
	3115
	3116	if (!is_array($this->all_entries) or !count($this->all_entries))
	3117	{
	3118	return array(
	3119	'msg' => lang('No Entries Found!'),
	3120	'status' => 'empty'
	3121	);
	3122	}
	3123
	3124	$data['offset'] = 0;
	3125	}
[1599]	3126
[2]	3127	if ($data['maxlength'] != -1)
	3128	{
	3129	$result = $this->bo->catalog->get_multiple_entries(array_slice($this->all_entries, $data['offset'], $data['maxlength']), $data['fields']);
	3130	}
	3131	else
	3132	{
	3133	$result = $this->bo->catalog->get_multiple_entries($this->all_entries, $data['fields']);
	3134	}
	3135
	3136	$prefs = ExecMethod('contactcenter.ui_preferences.get_preferences');
[1599]	3137
[2]	3138	$jsCode = array();
	3139	$count = 0;
	3140	foreach ($result as $each)
	3141	{
	3142	if (!is_array($each))
	3143	{
	3144	continue;
	3145	}
	3146
[1599]	3147	if($this-> typeContact == 'groups') {
	3148
[2]	3149	foreach ($each as $field => $value) {
[1599]	3150
[2]	3151	if ($field === 'title') {
	3152	$optionName = '\\"'.$value.'\\"';
[1599]	3153
[2]	3154	}
	3155	else if ($field === 'short_name') {
[1599]	3156
[2]	3157	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$optionName.' ('.$value.')", "'.$count.'");';
[1599]	3158	$count++;
	3159	}
[2]	3160	}
	3161	}
[1599]	3162
	3163	else {
[2]	3164	foreach ($each as $field => $value) {
	3165	if ($field === 'names_ordered') {
	3166	if(is_array($value))
	3167	$value = $value[0];
	3168	$name = '\\"'.$value.'\\"';
	3169	}
	3170	else if ($field === 'connections') {
[1599]	3171
[2]	3172	foreach ($value as $connection) {
	3173	if ($connection['id_type'] == $prefs['personCardEmail']) {
	3174	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$name.' <'.$connection['connection_value'].'>", "'.$count.'");';
	3175	$count++;
	3176	}
	3177	}
	3178	}
	3179	}
	3180	}
	3181	}
	3182
	3183	$jsCodeFinal = implode("\n", $jsCode);
[1599]	3184
[2]	3185	$nEntries = count($result);
[1599]	3186
[2]	3187	if (!$nEntries)
	3188	{
	3189	return array(
	3190	'msg' => lang('Error while getting user information...'),
	3191	'status' => 'abort'
	3192	);
	3193	}
	3194
	3195	return array(
	3196	'msg' => lang('Found %1 Entries!', $nEntries),
	3197	'status' => 'ok',
	3198	'typeContact' => $this -> typeContact,
	3199	'final' => $nEntries + $data['offset'] < count($this->all_entries) ? false : true,
	3200	'offset' => $data['offset'] + $nEntries,
	3201	'data' => $jsCodeFinal
	3202	);
	3203	}
[1599]	3204
[2]	3205	/*********************************************************************\
	3206	* Auxiliar Methods *
	3207	\*********************************************************************/
	3208
	3209	/*!
[1599]	3210
[2]	3211	@function save_session
	3212	@abstract Saves the data on the session
	3213	@author Raphael Derosso Pereira
[1599]	3214
[2]	3215	*/
	3216	function save_session()
	3217	{
	3218	$GLOBALS['phpgw']->session->appsession('ui_data.page_info','contactcenter',$this->page_info);
	3219	$GLOBALS['phpgw']->session->appsession('ui_data.all_entries','contactcenter',$this->all_entries);
	3220	}
	3221
	3222	/*!
[1599]	3223
[2]	3224	@function convert_tree
	3225	@abstract Converts the tree array in the BO format to a JS tree array compatible
	3226	with the one available in eGW
	3227	@author Raphael Derosso Pereira
[1599]	3228
[2]	3229	@param (array) $tree The tree in the BO format
	3230	@param (string) $name The tree name
	3231	@param (string) $iconDir The dir where the icons are
	3232	@param (string) $parent The parent
	3233	*/
	3234
	3235	function convert_tree($tree, &$iconDir, $parent='0')
	3236	{
	3237	// echo "Entrou<br>\tPai: $parent <br>";
	3238	$rtree = array();
	3239
	3240	if ($parent === '0')
	3241	{
	3242	// echo 'Root!<br>';
	3243	$rtree['0'] = array(
	3244	'type' => 'catalog_group',
	3245	'id' => '0',
	3246	'pid' => 'none',
	3247	'caption' => lang('Catalogues'),
	3248	'class' => 'bo_catalog_group_catalog',
	3249	'class_args' => array('_ROOT_', '$this', '$this->get_branch_by_level($this->catalog_level[0])')
	3250	);
	3251	}
	3252
	3253	foreach($tree as $id => $value)
	3254	{
	3255	// echo 'ID: '.$id.'<br>';
	3256	$rtree[$parent.'.'.$id] = array(
	3257	'type' => $value['type'],
	3258	'id' => $parent.'.'.$id,
	3259	'pid' => $parent,
	3260	'caption' => $value['name']
	3261	);
[1599]	3262
[2]	3263	switch($value['type'])
	3264	{
	3265	case 'catalog_group':
	3266	case 'mixed_catalog_group':
	3267	$rtree = $rtree + $this->convert_tree($value['sub_branch'],$iconDir,$parent.'.'.$id);
	3268	break;
	3269	}
	3270	}
	3271
	3272	if (count($rtree))
	3273	{
	3274	return $rtree;
	3275	}
	3276	}
	3277
	3278	function get_catalog_add_contact($id){
	3279
	3280	$array_participants = array();
[13]	3281	if(!$this->bo->catalog->src_info) {
	3282	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	3283	$this->bo->catalog->src_info = $ldap->srcs[1];
[2]	3284	}
[1599]	3285
	3286	$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]	3287	$dn=$this->bo->catalog->src_info['dn'];
	3288	$justThese = array("givenname","givenname","sn","telephonenumber","mail");
[1599]	3289	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
	3290	$info = ldap_get_entries($ds, $sr);
[13]	3291	for($z = 0; $z < 5; $z++) {
[1599]	3292	$participant = $info[0][$justThese[$z]];
[13]	3293	array_push($array_participants, $participant);
	3294	}
	3295
	3296	ldap_close($ds);
[2]	3297	echo serialize($array_participants);
[1599]	3298	}
	3299
	3300	function get_catalog_participants_group($id)
[880]	3301	{
	3302	if(!$this->bo->catalog->src_info) {
	3303	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	3304	$this->bo->catalog->src_info = $ldap->srcs[1];
[1599]	3305	}
	3306	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
	3307	$justThese = array("description","memberuid");
	3308	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
[880]	3309	$info = ldap_get_entries($ds, $sr);
	3310	$member_uids = $info[0]['memberuid'];
	3311	$contact['names_ordered'] = $info[0]['description'];
[1599]	3312	$filter = "";
[880]	3313	for($z = 0; $z < count($member_uids); $z++) {
	3314	if($member_uids[$z])
[1599]	3315	$filter.="(uid=".$member_uids[$z].")";
[880]	3316	}
	3317	$array_participants = array();
	3318	if($filter) {
[962]	3319	$filter = "(\|".$filter.")";
[904]	3320	$valarray = explode(',',$id);
	3321	array_shift($valarray);
	3322	$dn = implode(',',$valarray);
[880]	3323	$justThese = array("cn","mail");
[1599]	3324	$sr = ldap_search($ds,$dn, $filter,$justThese);
	3325	$info = ldap_get_entries($ds, $sr);
[880]	3326	for($z = 0; $z < $info['count']; $z++) {
	3327	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
[1599]	3328	$array_emails[$info[$z]['mail'][0]] = null;
	3329	array_push($array_participants, $participant);
[880]	3330	}
	3331	ldap_close($ds);
[1599]	3332	}
[880]	3333	sort($array_participants);
[1599]	3334	$innerHTML = '';
[880]	3335	foreach($array_participants as $index => $participant){
	3336	$innerHTML .= $participant;
	3337	}
[1599]	3338	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
[880]	3339	echo serialize($return);
	3340	}
	3341
[1599]	3342	function get_catalog_participants_list($id)
[2]	3343	{
[1599]	3344
	3345	$fields = $this->bo->catalog->get_fields(false);
[2]	3346	$fields['names_ordered'] = true;
[1599]	3347	$fields['mail_forwarding_address'] = true;
	3348	$contact = $this->bo->catalog->get_single_entry($id,$fields);
	3349
[2]	3350	$array_participants = array();
	3351	$array_emails = array();
[880]	3352
[2]	3353	$filter = null;
[1599]	3354	for($z = 0; $z < $contact['mail_forwarding_address']['count']; $z++) {
[2]	3355	if(strstr($contact['mail_forwarding_address'][$z],'@')) {
	3356	$filter.="(mail=".$contact['mail_forwarding_address'][$z].")";
	3357	$array_emails[$contact['mail_forwarding_address'][$z]] = "<font color=black>".$contact['mail_forwarding_address'][$z]."</font>";
[1599]	3358	}
	3359	else
[2]	3360	$array_participants[$z] = "<font color=red>".$contact['mail_forwarding_address'][$z]."</font>";
[1599]	3361	}
	3362
[2]	3363	if($filter) {
[1599]	3364	$filter = "(\|".$filter.")";
[2]	3365	if(!$this->bo->catalog->src_info) {
	3366	$ldap = CreateObject('contactcenter.bo_ldap_manager');
	3367	$this->bo->catalog->src_info = $ldap->srcs[1];
	3368	}
[880]	3369	$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]	3370	$dn=$this->bo->catalog->src_info['dn'];
	3371	$justThese = array("cn","mail");
[1599]	3372	$sr = ldap_search($ds,$dn, $filter,$justThese);
	3373	$info = ldap_get_entries($ds, $sr);
[2]	3374	for($z = 0; $z < $info['count']; $z++) {
[24]	3375	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
[1599]	3376	$array_emails[$info[$z]['mail'][0]] = null;
	3377	array_push($array_participants, $participant);
[2]	3378	}
[1599]	3379
[2]	3380	foreach($array_emails as $index => $email)
[1599]	3381	if($email)
	3382	array_push($array_participants, "      ".$email."<br>");
	3383
[2]	3384	ldap_close($ds);
	3385	}
	3386	sort($array_participants);
[1599]	3387	$innerHTML = '';
[24]	3388	foreach($array_participants as $index => $participant){
	3389	$innerHTML .= $participant;
	3390	}
[1599]	3391	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
[24]	3392	echo serialize($return);
[1599]	3393	}
	3394
[2]	3395	function export_contacts($typeExport){
	3396
	3397	$boGroup = CreateObject('contactcenter.bo_group');
	3398	$contacts = $boGroup->get_all_contacts();
	3399	$streamBuffer = '';
	3400
	3401	if(!count($contacts))
	3402	echo null;
[1599]	3403
	3404	/rev 104/
	3405	// Essa iteraï¿œï¿œo transforma uma esturuta com contatos redundantes e separados por email ou tel.
	3406	// em outra com apenas 1 elemento pra cada contato
	3407	/* $i=0;
	3408	foreach($contacts as $object){
	3409	$i=($object['id_contact'] - 1);
	3410	$all_contacts[$i]['name']=$object['names_ordered'];
	3411	if ($object['id_typeof_contact_connection'] == 1)
	3412	$all_contacts[$i]['email']=$object['connection_value'];
	3413	else
	3414	$all_contacts[$i]['phone']=$object['connection_value'];
	3415	}
	3416	*/
	3417	/*****/
	3418
[2]	3419	switch($typeExport) {
	3420
	3421	case 'outlook_en':
	3422	$streamBuffer = "Name;E-mail Address;Notes;Mobile Phone;Pager;Company;".
[1599]	3423	/rev 104/
	3424	/* "Job Title;Home Phone;Home Fax;Business Phone;Business Fax\r\n";
	3425	foreach($all_contacts as $index => $object){
	3426	$streamBuffer.= $object['name'].";".$object['email'].";;;;;;".$object['phone'].";;;\r\n";
	3427	}
	3428	*/
[285]	3429	"Job Title;Home Phone;Home Fax;Business Phone;Business Fax\r\n";
[293]	3430	foreach($contacts as $index => $object){
	3431	$streamBuffer.= $object['names_ordered'].";".$object['connection_value'].";;;;;;".$object['phone'].";;;\r\n";
[2]	3432	}
[1599]	3433	/*****/
[2]	3434	break;
[1599]	3435
[2]	3436	case 'outlook_pt-BR':
[1599]	3437	$streamBuffer = "Nome;End. de email;Endereï¿œo residencial;".
	3438	"Cidade do endereï¿œo residencial;CEP do endereï¿œo residencial;".
	3439	"Estado;Paï¿œs/regiï¿œo do endereï¿œo residencial;Telefone residencial;".
	3440	"Rua do endereï¿œo comercial;Cidade do endereï¿œo comercial;".
	3441	"CEP do endereï¿œo comercial;Estado do endereï¿œo comercial;".
	3442	"Paï¿œs/regiï¿œo do endereï¿œo comercial;Telefone comercial;Empresa;Cargo\r\n";
	3443	/rev 104/
	3444	// foreach($all_contacts as $index => $object){
	3445	// $streamBuffer.= $object['name'].";".$object['email'].";;;;;;".$object['phone'].";;;;;;;;\r\n";
[293]	3446	foreach($contacts as $index => $object){
	3447	$streamBuffer.= $object['names_ordered'].";".$object['connection_value'].";;;;;;".$object['phone'].";;;;;;;;\r\n";
[1599]	3448	/******/
[2]	3449	}
	3450	break;
[1599]	3451
[15]	3452	case 'outlook2000_pt-BR':
	3453	$streamBuffer = "\"Tratamento\",\"Nome\",\"Segundo Nome\",\"Sobrenome\",\"Sufixo\",".
[1599]	3454	"\"Empresa\",\"Departamento\",\"Cargo\",\"Rua do endereï¿œo comercial\",\"Rua do endereï¿œo comercial 2\",".
	3455	"\"Rua do endereï¿œo comercial 3\",\"Cidade do endereï¿œo comercial\",\"Estado do endereï¿œo comercial\",".
	3456	"\"CEP do endereï¿œo comercial\",\"Paï¿œs do endereï¿œo comercial\",\"Endereï¿œo residencial\",\"Rua residencial 2\",".
	3457	"\"Rua residencial 3\",\"Cidade do endereï¿œo residencial\",\"Estado\",\"CEP do endereï¿œo residencial\",\"Paï¿œs do endereï¿œo residencial\",".
	3458	"\"Outro endereï¿œo\",\"Outro endereï¿œo 2\",\"Outro endereï¿œo 3\",\"Cidade\",\"Estado\",\"CEP\",\"Paï¿œs\",".
[15]	3459	"\"Telefone do assistente\",\"Fax comercial\",\"Telefone comercial\",\"Telefone comercial 2\",\"Retorno de chamada\",".
	3460	"\"Telefone do carro\",\"Telefone principal da empresa\",\"Fax residencial\",\"Telefone residencial\",".
	3461	"\"Telefone residencial 2\",\"ISDN\",\"Telefone celular\",\"Outro fax\",\"Outro telefone\",\"Pager\",\"Telefone principal\",".
[1599]	3462	"\"Radiofone\",\"Telefone TTY/TDD\",\"Telex\",\"Aniversï¿œrio\",\"Anotaï¿œï¿œes\",\"Caixa postal\",\"Categorias\",".
	3463	"\"Cï¿œdigo da empresa\",\"Cï¿œdigo do governo\",\"Cï¿œnjuge\",\"Conta\",\"Endereï¿œo de correio eletrï¿œnico\",".
	3464	"\"Nome de exibiï¿œï¿œo do correio eletr.\",\"Endereï¿œo de correio eletrï¿œnico 2\",".
	3465	"\"Nome de exibiï¿œï¿œo do correio eletr.2\",\"Endereï¿œo de correio eletrï¿œnico 3\",".
	3466	"\"Nome de exibiï¿œï¿œo do correio eletr.3\",\"Datas especiais\",\"Disponibilidade da Internet\",".
	3467	"\"Filhos\",\"Hobby\",\"Idioma\",\"Indicaï¿œï¿œo\",\"Informaï¿œï¿œes para cobranï¿œa\",\"Iniciais\",\"Local\",".
	3468	"\"Nome do assistente\",\"Nome do gerenciador\",\"Pï¿œgina da Web\",\"Palavras-chave\",\"Particular\",\"Personalizado 1\",\"Personalizado 2\",".
	3469	"\"Personalizado 3\",\"Personalizado 4\",\"Prioridade\",\"Profissï¿œo\",\"Quilometragem\",\"Sala\",\"Sensibilidade\",\"Servidor de diretï¿œrio\",".
[15]	3470	"\"Sexo\"\r\n";
[1599]	3471
	3472	/rev 104/
	3473	//foreach($all_contacts as $index => $object){
	3474	// $streamBuffer.= ",\"".$object['name']."\",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,".$object['phone'].",,,,,,,,,,,,\"".$object['email']."\",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n";
[293]	3475	foreach($contacts as $index => $object){
	3476	$streamBuffer.= ",\"".$object['names_ordered']."\",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,".$object['phone'].",,,,,,,,,,,,\"".$object['connection_value']."\",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n";
[1599]	3477	/******/
[15]	3478	}
	3479	break;
[1599]	3480
[15]	3481	case 'outlook2000_en':
	3482	$streamBuffer = "Title,First Name,Middle Name,Last Name,Suffix,Company,Department,Job Title,".
	3483	"Business Street,Business Street 2,Business Street 3,Business City,Business State,Business Postal Code,".
	3484	"Business Country,Home Street,Home Street 2,Home Street 3,Home City,Home State,Home Postal Code,Home Country,".
	3485	"Other Street,Other Street 2,Other Street 3,Other City,Other State,Other Postal Code,Other Country,".
	3486	"Assistant's Phone,Business Fax,Business Phone,Business Phone 2,Callback,Car Phone,Company Main Phone,Home Fax,".
	3487	"Home Phone,Home Phone 2,ISDN,Mobile Phone,Other Fax,Other Phone,Pager,Primary Phone,Radio Phone,TTY/TDD Phone,Telex,".
	3488	"Account,Anniversary,Assistant's Name,Billing Information,Birthday,Categories,Children,Directory Server,E-mail Address,".
	3489	"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,".
	3490	"Gender,Government ID Number,Hobby,Initials,Internet Free Busy,Keywords,Language,Location,Manager's Name,Mileage,Notes,".
	3491	"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]	3492
	3493	/rev 104/
	3494	//foreach($all_contacts as $index => $object){
	3495	// $streamBuffer.= ",".$object['name'].",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,".$object['phone'].",,,,,,,,,,,,".$object['email'].",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n";
[293]	3496	foreach($contacts as $index => $object){
	3497	$streamBuffer.= ",".$object['names_ordered'].",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,".$object['phone'].",,,,,,,,,,,,".$object['connection_value'].",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n";
[1599]	3498	/*******/
[15]	3499	}
	3500	break;
[1599]	3501
[2]	3502	case 'thunderbird':
[1599]	3503	$streamBuffer = "\n";
	3504
	3505	/rev 104/
	3506	//foreach($all_contacts as $index => $object){
	3507	// $streamBuffer.= ",,".$object['name'].",,".$object['email'].",,".$object['phone'].",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n";
[293]	3508	foreach($contacts as $index => $object){
	3509	$streamBuffer.= ",,".$object['names_ordered'].",,".$object['connection_value'].",,".$object['phone'].",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n";
[1599]	3510
	3511	/******/
[2]	3512	}
	3513	break;
[1599]	3514
[285]	3515	case 'expresso':
[16]	3516	$streamBuffer = "Nome,Email,Telefone\r\n";
[1599]	3517
	3518	/rev 104/
	3519	//foreach($all_contacts as $index => $object){
	3520	// $streamBuffer.= $object['name'].",".$object['email'].",".$object['phone']."\r\n";
[293]	3521	foreach($contacts as $index => $object){
	3522	$streamBuffer.= $object['names_ordered'].",".$object['connection_value'].",".$object['phone']."\r\n";
[1599]	3523
	3524	/******/
[2]	3525	}
	3526	break;
[1599]	3527
[2]	3528	}
	3529
	3530	$file = "contacts_".md5(microtime()).".swp";
	3531	$tempDir = ini_get("session.save_path");
	3532	$f = fopen($tempDir.'/'.$file,"w");
	3533	if(!$f)
	3534	echo null;
[1599]	3535
[2]	3536	fputs($f,$streamBuffer);
	3537	fclose($f);
	3538
	3539	echo $tempDir.'/'.$file;
	3540	}
	3541
[285]	3542	// Get the csv field and put into array, from php.net
	3543	function parse_line($input_text, $delimiter = ',', $text_qualifier = '"') {
	3544	$text = trim($input_text);
	3545	if(is_string($delimiter) && is_string($text_qualifier)) {
	3546	$re_d = '\x' . dechex(ord($delimiter)); //format for regexp
	3547	$re_tq = '\x' . dechex(ord($text_qualifier)); //format for regexp
[1599]	3548
[285]	3549	$fields = array();
	3550	$field_num = 0;
	3551	while(strlen($text) > 0) {
	3552	if($text{0} == $text_qualifier) {
	3553	preg_match('/^' . $re_tq . '((?:[^' . $re_tq . ']\|(?<=\x5c)' . $re_tq . '))' . $re_tq . $re_d . '?(.)$/', $text, $matches);
[1599]	3554
[285]	3555	$value = str_replace('\\' . $text_qualifier, $text_qualifier, $matches[1]);
	3556	$text = trim($matches[2]);
[1599]	3557
[285]	3558	$fields[$field_num++] = $value;
	3559	} else {
	3560	preg_match('/^([^' . $re_d . '])' . $re_d . '?(.)$/', $text, $matches);
[1599]	3561
[285]	3562	$value = $matches[1];
	3563	$text = trim($matches[2]);
[1599]	3564
[285]	3565	$fields[$field_num++] = $value;
	3566	}
	3567	}
	3568	return $fields;
	3569	} else
	3570	return false;
	3571	}
[16]	3572
[1599]	3573	//funcao alterada para importar outros campos alem de nome, telefone e email, de arquivo csv (Outlook 2000)
	3574	//em 08/04/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
	3575	//Foi adicionada uma funcao (escapesheelcmd()) nas variaveis para que caracteres especiais sejam ignorados
	3576	//durante a importacao dos contatos; o processo estava travando por causa de caracteres em campos como nome,
	3577	//sobrenome, notas e e-mail;
	3578	//em 19/06/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
[2]	3579	function import_contacts($typeImport){
[276]	3580
[1599]	3581	if($file = $_SESSION['contactcenter']['importCSV']) {
	3582	unset($_SESSION['contactcenter']['importCSV']);
[2]	3583	$len = filesize($file);
	3584	$count = 0;
	3585	$return = array('error' => false, '_new' => 0, '_existing' => 0, '_failure' => 0);
[276]	3586	$handle = @fopen($file, "r") or die(serialize($return['error'] = true));
[1599]	3587
[285]	3588	$input_header = fgets($handle);
	3589	if ($typeImport == 'outlook')
	3590	$delim = ';';
	3591	else if ($typeImport == 'auto')
	3592	$delim = strstr($input_header,',') ? ',' : ';';
[1599]	3593	else
[285]	3594	$delim = ',';
	3595	$csv_header = $this->parse_line($input_header,$delim);
	3596	$firstContact = fgets($handle);
	3597	preg_match("/\"(.+)\"[,;]/sU",$firstContact,$matches); // yahoo csv
[1599]	3598	rewind($handle);
[285]	3599
[2]	3600	$header = @fgetcsv($handle, $len, $delim) or die(serialize($return['error'] = true));
[15]	3601	if(count($header) < 2 \|\| count($header) > 100) {
[2]	3602	$return['error'] = true;
	3603	$return['sizeheader'] = count($header);
	3604	echo serialize($return);
	3605	return;
	3606	}
[1599]	3607
[285]	3608	if ($matches[0][strlen($matches[0])-1] == ';')
	3609	$delim = ';';
[1599]	3610
[285]	3611	$boGroup = CreateObject('contactcenter.bo_group');
	3612	$boPeople = CreateObject('contactcenter.bo_people_catalog');
[15]	3613	switch($typeImport){
	3614	case 'outlook2000':
[16]	3615	$name_pos=1;
[1599]	3616	$name2_pos=2;
	3617	$name3_pos=3;
	3618	$addr1_pos=8;
	3619	$cep_pos=13;
	3620	$addr2_pos=22;
	3621	$fax_pos=30;
	3622	$phone_pos=31;
	3623	$resPhone_pos=37;
	3624	$cellPhone_pos=40;
	3625	$pager_pos=43;
	3626	$birth_pos=48;
	3627	$notes_pos=49;
[16]	3628	$email_pos=56;
[1599]	3629	$altEmail_pos=59;
	3630
[15]	3631	break;
[16]	3632	case 'outlook':
[1599]	3633	$name_pos=3;
	3634	$email_pos=4;
[16]	3635	$phone_pos=7;
[1599]	3636	$resPhone_pos=10;
	3637	$cellPhone_pos=12;
	3638	$addr1_pos=13;
	3639	$cep_pos=15;
	3640	$phone_pos=18;
	3641	$fax_pos=19;
	3642	$pager_pos=20;
	3643	$notes_pos=25;
[16]	3644	break;
[15]	3645	case 'thunderbird':
[16]	3646	$name_pos=2;
	3647	$email_pos=4;
[19]	3648	$phone_pos=7;
[15]	3649	break;
[285]	3650	case 'expresso':
[16]	3651	$name_pos=0;
	3652	$email_pos=1;
	3653	$phone_pos=2;
[285]	3654	break;
	3655	default:
	3656	foreach($csv_header as $index => $fieldName)
	3657	{
[1599]	3658	switch($fieldName){
	3659	case 'Name':
	3660	case 'Nome':
	3661	case 'First Name':
[285]	3662	$name_pos = $index;
	3663	break;
[1599]	3664	case 'Second name':
	3665	case 'Segundo nome':
	3666	$name2_pos = $index;
[285]	3667	break;
[1599]	3668	case 'Sobrenome':
	3669	case 'Surname':
	3670	$name3_pos = $index;
	3671	break;
	3672	case 'Business Street':
	3673	case 'Rua do endereÃ§o comercial':
	3674	$addr1_pos = $index;
	3675	break;
	3676	case 'Rua do endereÃ§o comercial 2':
	3677	case 'Outro endereÃ§o':
	3678	$addr2_pos = $index;
	3679	break;
	3680	case 'Business Postal Code':
	3681	case 'CEP do endereÃ§o comercial':
	3682	$cep_pos = $index;
	3683	break;
	3684	case 'Business Fax':
	3685	case 'Fax comercial':
	3686	case 'Fax':
	3687	$fax_pos = $index;
	3688	break;
	3689	case 'Home Phone':
	3690	case 'Telefone residencial':
	3691	$resPhone_pos = $index;
	3692	break;
	3693	case 'Mobile phone':
	3694	case 'Telefone celular':
	3695	$cellPhone_pos = $index;
	3696	break;
	3697	case 'Pager':
	3698	$pager_pos = $index;
	3699	break;
	3700	case 'Phone':
	3701	case 'Business Phone':
	3702	case 'Telefone':
	3703	case 'Telefone principal':
	3704	case 'Telefone comercial':
[285]	3705	$phone_pos = $index;
	3706	break;
[1599]	3707	case 'AniversÃ¡rio':
	3708	case 'Birthdate':
	3709	$birth_pos = $index;
	3710	case 'AnotaÃ§Ãµes':
	3711	case 'Notes':
	3712	$notes_pos = $index;
	3713	case 'E-mail':
	3714	case 'Email':
	3715	case 'E-mail Address':
	3716	case 'Endereï¿œo de correio eletrï¿œnico':
	3717	case 'End. de email':
	3718	$email_pos = $index;
	3719	break;
	3720	case 'Endereï¿œo de correio eletrï¿œnico 2':
	3721	$altEmail_pos = $index;
	3722	break;
[285]	3723	}
[575]	3724	}
[285]	3725	break;
[15]	3726	}
[276]	3727
[2]	3728	while (($data = fgetcsv($handle, $len, $delim))) {
	3729	foreach ($header as $key=>$heading)
	3730	$row[$heading]=(isset($data[$key])) ? $data[$key] : '';
[1599]	3731
[2]	3732	$sdata = array();
[1599]	3733	$full_name = trim($row[$header[$name_pos]]);
[16]	3734	$email = trim($row[$header[$email_pos]]);
	3735	$phone = trim($row[$header[$phone_pos]]);
[1599]	3736	$name2 = trim($row[$header[$name2_pos]]);
	3737	$name3 = trim($row[$header[$name3_pos]]);
	3738
	3739	$addr1 = trim($row[$header[$addr1_pos]]);
	3740	$addr2 = trim($row[$header[$addr2_pos]]);
	3741	$cep = trim($row[$header[$cep_pos]]);
	3742	$fax = trim($row[$header[$fax_pos]]);
	3743	$resPhone = trim($row[$header[$resPhone_pos]]);
	3744	$cellPhone = trim($row[$header[$cellPhone_pos]]);
	3745	$pager = trim($row[$header[$pager_pos]]);
	3746	$birth = trim($row[$header[$birth_pos]]);
	3747	$notes = trim($row[$header[$notes_pos]]);
	3748	$altEmail = trim($row[$header[$altEmail_pos]]);
	3749
	3750	$full_name = escapeshellcmd($full_name);
[2]	3751	$array_name = explode(' ', str_replace('"','',(str_replace('\'','',$full_name))));
[1599]	3752	$sdata['given_names'] = escapeshellcmd($array_name[0]);
[2]	3753	$array_name[0] = null;
	3754	$sdata['family_names'] = trim(implode(' ',$array_name));
[1599]	3755	if($sdata['family_names'] == '')
	3756	{
	3757	$sdata['family_names'] = escapeshellcmd($name2) . " " . escapeshellcmd($name3);
	3758	}
	3759
[2]	3760	$sdata['connections']['default_email']['connection_name'] = lang('Main');
[1599]	3761	$sdata['connections']['default_email']['connection_value'] = escapeshellcmd($email);
[2]	3762
[16]	3763	$sdata['connections']['default_phone']['connection_name'] = lang('Main');
[1599]	3764	$sdata['connections']['default_phone']['connection_value'] = escapeshellcmd($phone);
	3765
	3766	$sdata['connections']['fax']['connection_name'] = lang('Fax');
	3767	$sdata['connections']['fax']['connection_value'] = escapeshellcmd($fax);
	3768
	3769	$sdata['connections']['residencial_phone']['connection_name'] = lang('Residencial');
	3770	$sdata['connections']['residencial_phone']['connection_value'] = escapeshellcmd($resPhone);
	3771
	3772	$sdata['connections']['cellular_phone']['connection_name'] = lang('Cellphone');
	3773	$sdata['connections']['cellular_phone']['connection_value'] = escapeshellcmd($cellPhone);
	3774
	3775	$sdata['connections']['pager']['connection_name'] = lang('Pager');
	3776	$sdata['connections']['pager']['connection_value'] = escapeshellcmd($pager);
	3777
	3778	$sdata['connections']['alternative_email']['connection_name'] = lang('Alternative');
	3779	$sdata['connections']['alternative_email']['connection_value'] = escapeshellcmd($altEmail);
	3780
	3781	$sdata['addresses']['addr1']['address_value'] = escapeshellcmd($addr1);
	3782	$sdata['addresses']['addr2']['address_value'] = escapeshellcmd($addr2);
	3783	$sdata['addresses']['cep']['address_value'] = escapeshellcmd($cep);
	3784
	3785	$array_birth = explode("/",$birth);
	3786
	3787	$sdata['birthdate'] = escapeshellcmd(date('Y-m-d', mktime(0,0,0,$array_birth[1],$array_birth[0],$array_birth[2])));
	3788
	3789	$sdata['notes'] = escapeshellcmd($notes);
	3790	$sdata['is_quick_add'] = true;
[16]	3791	$sdata['connections']['default_phone']['connection_value'] = $phone;
[1599]	3792
[285]	3793	// verifica se email já existe!
[1599]	3794	$email = escapeshellcmd($email);
[2]	3795	$contact = $boGroup->verify_contact($email);
[1599]	3796
[285]	3797	if(!$sdata['given_names'] && $email){
	3798	$a_email = explode("@",$email);
[1599]	3799	$sdata['given_names'] = escapeshellcmd($a_email[0]);
[285]	3800	}
[2]	3801
[1599]	3802	$line_iteration = $return['_failure'] + $return['_existing'] + $return['_new'];
	3803
[2]	3804	if($contact){
	3805	$return['_existing']++;
[1599]	3806	}
	3807	else if(!eregi("^[/_a-z0-9-]+(\.[_a-z0-9-]+)@[a-z0-9-]+(\.[a-z0-9-]+)(\.[a-z]{2,3})$", $email)) {
[2]	3808	$return['_failure']++;
[285]	3809	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid E-Mail address: " . $email ."<br>";
[16]	3810	}
[284]	3811	else if (!$sdata['given_names'] \|\| !$email \|\| !$boPeople ->quick_add($sdata)){
[1599]	3812	$return['_failure']++;
[285]	3813	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid Name: " . $sdata['given_names'] ."<br>";
[2]	3814	}
	3815	else
	3816	$return['_new']++;
[1599]	3817	}
[2]	3818	fclose($handle);
[15]	3819	unlink($file);
[2]	3820	}
	3821	else
	3822	$return['error'] = true;
	3823
	3824	echo serialize($return);
	3825	}
	3826	}
	3827
	3828	?>

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

Download in other formats: