Context Navigation

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

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

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

Download in other formats: