Context Navigation

source: branches/2.2.0.1/contactcenter/inc/class.ui_data.inc.php @ 4630

Revision 4630, 145.1 KB checked in by rafaelraymundo, 13 years ago (diff)
Ticket #2030 - Erro na Navegação por Contatos Pessoais.
Property svn:eol-style set to `native` Property svn:executable set to ``*

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

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

Download in other formats: