Context Navigation

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

Revision 4599, 145.0 KB checked in by rafaelraymundo, 13 years ago (diff)
Ticket #2006 - Incluir Contato Compartilhado duplicado
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'] = ceil(($n_entries/($this->page_info['n_cards']) && !$dontPaginate ? $this->page_info['n_cards'] : 1));
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'] = ceil((count($ids)/($this->page_info['n_cards']) && !$dontPaginate ? $this->page_info['n_cards'] : 1));
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	}
1540	else if ($conn_info['id_type'] == $this->preferences['personCardPhone'] and !$default_phone_found)
1541	{
1542	if ($conn_info['connection_is_default'])
1543	{
1544	$default_phone_found = true;
1545	}
1546
1547	/rev 104/
1548	//if ($_SESSION['phpgw_info']['user']['preferences']['contactcenter']['voip_enabled'] && !$external){
1549	// $conn_info['connection_value'] = "<a title=\"".lang("Call Extension")."\" href=\"#\" onclick=\"connectVoip('".$conn_info['connection_value']."', 'ramal')\">".$conn_info['connection_value']."</a>";
1550
1551	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){
1552	$conn_info['connection_value'] = "<a title=\"".lang("Call Extension")."\" href=\"#\" onclick=\"connectVoip('".$conn_info['connection_value']."', 'com')\">".$conn_info['connection_value']."</a>";
1553
1554	/*****/
1555	}
1556	$final[3][$i][3] = $conn_info['connection_value'] ? $conn_info['connection_value'] : 'none';
1557	}
1558	}
1559	}
1560
1561	if (!$final[3][$i][3])
1562	{
1563	$final[3][$i][3] = 'none';
1564	}
1565
1566	if (!$final[3][$i][4])
1567	{
1568	$final[3][$i][4] = 'none';
1569	}
1570
1571	$final[3][$i][5] = $contact['alias']? urldecode( $contact['alias'] ):'none';
1572	$final[3][$i][6] = $ids[$i];
1573
1574	/rev 104/
1575	/* // If contact is a public list, then load the forwarding addresses.
1576	if($contact['account_type'][0] == 'l')
1577	$final[3][$i][7] = array();
1578	*/
1579
1580	//If contact is a public list or a group, then load the forwarding addresses.
1581	if($contact['account_type'][0] == 'l' \|\| $contact['account_type'][0] == 'g')
1582	$final[3][$i][7] = ($contact['account_type'][0] == 'l' ? 'list' : 'group');
1583
1584	if($this->page_info['actual_catalog']['class']=='bo_shared_people_manager') {
1585	$final[3][$i][11] = $perms[$i];
1586	$final[3][$i][12] = lang('Shared').": ".$owner_names[$owners[$i]]['cn'];
1587	}
1588	/******/
1589
1590	$final[4][$i] = $contact['photo'] ? 1 : 0;
1591	$i++;
1592	}
1593	else
1594	{
1595	// coloca mensagem de erro no vetor que retorna para o browser
1596	}
1597	}
1598	$lnk_compose = "location.href=('../expressoMail1_2/index.php?to=";
1599	$final[5] = '<span class="link" onclick="'.$lnk_compose;
1600	$final[6] = $prop_names;
1601	$final[7] = $validos;
1602	$final[8] = $this->page_info['actual_catalog']['class'];
1603	$final[9] = $count;
1604	$final[11] = $this->bo->catalog_level;
1605
1606
1607	$this->page_info['actual_letter'] = $letter;
1608	$this->page_info['actual_page'] = $page;
1609
1610	$this->save_session();
1611	echo serialize($final);
1612	return;
1613	}
1614
1615	$this->page_info['actual_letter'] = $letter;
1616	$this->page_info['actual_page'] = $page;
1617
1618	$this->save_session();
1619
1620	$final[0] = 0;
1621	$final[1] = $this -> typeContact;
1622	echo serialize($final);
1623	}
1624
1625
1626	function get_list_owners_perms_add(){
1627	$acl = CreateObject('phpgwapi.acl');
1628	$find_result = $acl->get_rights_and_owners($GLOBALS['phpgw_info']['user']['account_id'],'contactcenter');
1629	if($find_result){
1630	$owner_names = array();
1631	$filter = "(\|";
1632	foreach($find_result as $owner) {
1633	if(($owner['acl_rights'] & PHPGW_ACL_ADD) == PHPGW_ACL_ADD){
1634	$filter .= "(uidNumber=".$owner['acl_account'].")";
1635	}
1636	}
1637	if(!$this->bo->catalog->src_info) {
1638	$ldap = CreateObject('contactcenter.bo_ldap_manager');
1639	$this->bo->catalog->src_info = $ldap->srcs[1];
1640	}
1641	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], false);
1642	$filter .= ")";
1643	$dn=$this->bo->catalog->src_info['dn'];
1644	$justThese = array("cn","uidnumber","uid");
1645	$sr = ldap_search($ds,$dn, $filter,$justThese);
1646	$info = ldap_get_entries($ds, $sr);
1647	for($z = 0; $z < $info['count']; $z++) {
1648	$owner_names[$info[$z]['uidnumber'][0]] = array("cn" => $info[$z]['cn'][0], "uid" => $info[$z]['uid'][0]);
1649	}
1650	ldap_close($ds);
1651	}
1652	echo serialize ($owner_names);
1653	}
1654
1655	function get_visible_all_ldap()
1656	{
1657	$bo = CreateObject('contactcenter.bo_ldap_manager');
1658	$ldap_query = $bo->srcs;
1659	return $ldap_query[1]['visible'];
1660	}
1661
1662
1663	/*!
1664
1665	@function get_group_data
1666	@abstract Returns all the information of a given Group
1667	@author Nilton Emilio Buhrer Neto
1668
1669	@param (integer) $id The id to get information
1670
1671	*/
1672	function get_group_data($id,$shared_from=null)
1673	{
1674	$this->bo->catalog = CreateObject('contactcenter.bo_group_manager');
1675	$fields = $this->bo->catalog->get_fields(true);
1676	$data = $this->bo->catalog->get_single_entry($id,$fields);
1677
1678	if($id) {
1679	// get All Contacts by group.
1680	$data['contact_in_list'] = $this->bo->catalog->get_contacts_by_group($id);
1681	}
1682
1683	$boGroup = CreateObject('contactcenter.bo_group');
1684
1685	$all_contacts = $boGroup->get_all_contacts('only_email',$shared_from);
1686
1687	$contact_options = "";
1688	if(count($all_contacts)) {
1689	foreach($all_contacts as $idx => $contact) {
1690	$contact_options .= "<OPTION value='".$contact['id_connection']."'>".$contact['names_ordered']." (".$contact['connection_value'].")</OPTION>";
1691	}
1692	}
1693	$data['contact_list'] = $contact_options;
1694	$data['result'] = 'ok';
1695	echo serialize($data);
1696	}
1697
1698	/*!
1699
1700	@function get_full_data
1701	@abstract Returns all the information of a given Entry
1702	@author Raphael Derosso Pereira
1703
1704	@param (integer) $id The id to get information
1705
1706	*/
1707	/rev 104/
1708	//function get_full_data($id)
1709	function get_full_data($id,$catalog='bo_people_catalog')
1710	{
1711	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
1712	/rev 104/
1713	//$this->bo->catalog = CreateObject('contactcenter.bo_people_catalog');
1714	$this->bo->catalog = CreateObject('contactcenter.'.$catalog);
1715	/****/
1716	$fields = $this->bo->catalog->get_fields(true);
1717	$fields['photo'] = false;
1718	$entry = $this->bo->catalog->get_single_entry($id,$fields);
1719
1720	if (is_bool($entry['given_names']))
1721	{
1722	$data['result'] = 'false';
1723	echo serialize($data);
1724	return;
1725	}
1726
1727	$date = explode('-', $entry['birthdate']);
1728	$j = 0;
1729	for ($i = 0; $i < 5; $i+=2)
1730	{
1731	switch($dateformat{$i})
1732	{
1733	case 'Y':
1734	$birthdate[$j] = $date[0];
1735	break;
1736
1737	case 'm':
1738	case 'M':
1739	$birthdate[$j] = $date[1];
1740	break;
1741
1742	case 'd':
1743	$birthdate[$j] = $date[2];
1744	}
1745	$j++;
1746	}
1747	$datecount = 0;
1748
1749	$data['result'] = 'ok';
1750	$data['cc_full_add_contact_id'] = $id;
1751
1752	/* Personal Data */
1753	$data['personal']['cc_pd_photo'] = '../index.php?menuaction=contactcenter.ui_data.data_manager&method=get_photo&id='.$id;
1754	$data['personal']['cc_pd_alias'] = $entry['alias'];
1755	$data['personal']['cc_pd_given_names'] = $entry['given_names'];
1756	$data['personal']['cc_pd_family_names'] = $entry['family_names'];
1757	$data['personal']['cc_pd_full_name'] = $entry['names_ordered'];
1758	$data['personal']['cc_pd_suffix'] = $entry['id_suffix'];
1759	$data['personal']['cc_pd_birthdate_0'] = $birthdate[0];
1760	$data['personal']['cc_pd_birthdate_1'] = $birthdate[1];
1761	$data['personal']['cc_pd_birthdate_2'] = $birthdate[2];
1762	//$data['personal']['cc_pd_sex'] = $entry['sex'] === 'M' ? 1 : ($entry['sex'] === 'F' ? 2 : 0);
1763	$data['personal']['cc_pd_prefix'] = $entry['id_prefix'];
1764	$data['personal']['cc_pd_gpg_finger_print'] = $entry['pgp_key'];
1765	$data['personal']['cc_pd_notes'] = $entry['notes'];
1766
1767	/* Addresses */
1768	if (is_array($entry['addresses']))
1769	{
1770	$data['addresses'] = $entry['addresses'];
1771	}
1772
1773	/* Connections */
1774	if (is_array($entry['connections']))
1775	{
1776	$data['connections'] = array();
1777	foreach ($entry['connections'] as $connection)
1778	{
1779	$type = $connection['id_type'];
1780	$i = count($data['connections'][$type]);
1781	$data['connections'][$type][$i]['id'] = $connection['id_connection'];
1782	$data['connections'][$type][$i]['name'] = $connection['connection_name'];
1783	$data['connections'][$type][$i]['value'] = $connection['connection_value'];
1784	$data['connections'][$type][$i]['is_default'] = $connection['connection_is_default'];
1785	}
1786	}
1787	// print_r($data);
1788	//OBSERVAR cc_department
1789	/Corporative/
1790	if($GLOBALS['phpgw_info']['server']['personal_contact_type']=='True'){
1791	$data['personal']['cc_job_title'] = $entry['job_title'];
1792	$data['personal']['cc_department'] = $entry['department'];
1793	$data['personal']['cc_name_corporate'] = $entry['corporate_name'];
1794	$data['personal']['cc_web_page'] = $entry['web_page'];
1795	}
1796
1797
1798
1799	/* Relations */
1800
1801	echo serialize($data);
1802	}
1803
1804	/*!
1805
1806	@function get_contact_full_add_const
1807	@abstract Returns all the constant fields in Contact Full Add Window to the JS
1808	@author Raphael Derosso Pereira
1809	*/
1810	function get_contact_full_add_const()
1811	{
1812	$data = array();
1813	$boPeopleCatalog = CreateObject('contactcenter.bo_people_catalog');
1814	$predata[] = $boPeopleCatalog -> get_all_prefixes();
1815	$predata[] = $boPeopleCatalog -> get_all_suffixes();
1816	$predata[] = $boPeopleCatalog -> get_all_addresses_types();
1817	$predata[] = $boPeopleCatalog -> get_all_countries();
1818	$predata[] = $boPeopleCatalog -> get_all_connections_types();
1819	//$predata[] = $this->bo->catalog->get_all_relations_types();
1820
1821	$i = 0;
1822	foreach($predata as $data_)
1823	{
1824	if ($data_)
1825	{
1826	$data[$i] = $data_;
1827	}
1828
1829	$i++;
1830	}
1831
1832	if (count($data))
1833	{
1834	echo serialize($data);
1835	return;
1836	}
1837
1838	echo 0;
1839	}
1840
1841	/*!
1842
1843	@function quick_add
1844	@abstract Adds a new Contact using the Quick Add interface
1845	@author Raphael Derosso Pereira
1846
1847	@param string $sdata Serialized data
1848	*/
1849	function quick_add($sdata, $echo=true)
1850	{
1851
1852	$sdata = str_replace('\\"', '"', $sdata);
1853	$new_array = unserialize($sdata);
1854	$tdata = array();
1855
1856	foreach($new_array as $tmp)
1857	$tdata[] = $tmp;
1858
1859	if (!$tdata)
1860	{
1861	if ($echo)
1862	{
1863	echo serialize(array(
1864	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
1865	'status' => 'abort'
1866	));
1867
1868	return;
1869	}
1870	else
1871	{
1872	return serialize(array(
1873	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
1874	'status' => 'abort'
1875	));
1876	}
1877	}
1878
1879	// verifica se email já existe!
1880	$boGroup = CreateObject('contactcenter.bo_group');
1881	$contact = $boGroup->verify_contact($tdata[4]);
1882
1883	if($contact)
1884	{
1885	$str_contact = "\r\n - ".implode("\r\n - ",$contact);
1886
1887	if ($echo)
1888	{
1889	echo serialize(array(
1890	'msg' => lang('Problems on adding your Contact. The email "%1" already exists in: %2',$tdata[4], $str_contact),
1891	'status' => 'alreadyExists'
1892	));
1893
1894	return;
1895	}
1896	else
1897	{
1898	return serialize(array(
1899	'msg' => lang('Problems on adding your Contact. The email "%1" already exists in: %2',$tdata[4], $str_contact),
1900	'status' => 'alreadyExists',
1901	'id_connection' => $contact[1]
1902	));
1903	}
1904	}
1905
1906	$data['alias'] = addslashes($tdata[0]);
1907	$data['given_names'] = addslashes($tdata[1]);
1908	$data['family_names'] = addslashes($tdata[2]);
1909	$data['connections']['default_phone']['connection_name'] = lang('Main');
1910	$data['connections']['default_phone']['connection_value'] = $tdata[3];
1911	$data['connections']['default_email']['connection_name'] = lang('Main');
1912	$data['connections']['default_email']['connection_value'] = $tdata[4];
1913	$data['is_quick_add'] = true;
1914	$boPeople = CreateObject('contactcenter.bo_people_catalog');
1915
1916	$result = $boPeople->quick_add($data);
1917	if ($result)
1918	{
1919	$this->page_info['changed'] = true;
1920
1921	if ($echo)
1922	{
1923	echo serialize(array(
1924	'msg' => lang('Entry added with success!'),
1925	'status' => 'ok'
1926	));
1927	}
1928	else
1929	{
1930	return serialize(array(
1931	'msg' => lang('Entry added with success!'),
1932	'status' => 'ok',
1933	'conn' => $boPeople->get_connections($result)
1934	));
1935	}
1936	}
1937	else
1938	{
1939	if ($echo)
1940	{
1941	echo serialize(array(
1942	'msg' => lang('Problems on adding your Contact. No Contact added!'),
1943	'status' => 'error'
1944	));
1945	}
1946	else
1947	{
1948	echo serialize(array(
1949	'msg' => lang('Problems on adding your Contact. No Contact added!'),
1950	'status' => 'error'
1951	));
1952	}
1953	}
1954
1955	$this->save_session();
1956
1957	}
1958
1959	/*!
1960
1961	@function add_group
1962	@abstract Adds a new Group using the Add Group interface
1963	@author Nilton Emilio Buhrer Neto
1964
1965	@param string $sdata Serialized data
1966	*/
1967	function add_group($sdata)
1968	{
1969	$sdata = str_replace('\\"', '"', $sdata);
1970	$tdata = unserialize($sdata);
1971	$new_tdata = array();
1972
1973	if (!$tdata)
1974	{
1975	echo serialize(array(
1976	'msg' => lang('Problems on adding your Contact. Invalid Data came from client. No Contact added!'),
1977	'status' => 'abort'
1978	));
1979
1980	return;
1981	}
1982
1983	foreach($tdata as $tmp)
1984	$new_tdata[] = $tmp;
1985
1986	$data['title'] = $new_tdata[0];
1987	$data['contact_in_list'] = $new_tdata[1];
1988	$data['id_group'] = $new_tdata[2];
1989	$acumulatedErrors = '';
1990
1991	$actualCatalog = $this->get_actual_catalog();
1992	for ($i = 0; $i < count($data['contact_in_list']); $i++)
1993	{
1994	if (preg_match('/ldap:.:./', $data['contact_in_list'][$i])) // from ldap
1995	{
1996	list(, $level, $dn) = explode(':', $data['contact_in_list'][$i]);
1997
1998	// pesquisa os dados, insere no catálogo e modifica
1999	// a entrada em $data['contact_in_list'][$i]
2000	$set_catalog = $this->set_catalog($level, false);
2001	$contact_data = unserialize($this->get_catalog_add_contact($dn, false));
2002	$tmp_contact[] = $contact_data[0][0];
2003	$tmp_contact[] = $contact_data[1][0];
2004	$tmp_contact[] = $contact_data[2][0];
2005	$tmp_contact[] = $contact_data[3][0];
2006	$tmp_contact[] = $contact_data[4][0];
2007
2008	// Determinar o id_connection
2009	$id_contact = unserialize($this->quick_add(serialize($tmp_contact), false));
2010
2011	switch ($id_contact['status'])
2012	{
2013	case 'ok' :
2014	foreach ($id_contact['conn'] as $connection)
2015	{
2016	if ($connection['id_type'] == 1)
2017	{
2018	$data['contact_in_list'][$i] = $connection['id_connection'];
2019	}
2020	}
2021	break;
2022
2023	case 'alreadyExists': // if e-mail exists get their id_connection from people_catalog
2024	$data['contact_in_list'][$i] = $id_contact['id_connection'];
2025
2026	default:
2027	$acumulatedErrors += $id_contact['msg']."\n";
2028	}
2029	unset($tmp_contact);
2030
2031	}
2032	}
2033	$set_catalog = $this->set_catalog($actualCatalog['data'], false); // retorna ao catálogo original.
2034	$boGroup = CreateObject('contactcenter.bo_group_manager');
2035	$id = $boGroup -> add_group($data);
2036
2037	if ($id)
2038	{
2039	$this->page_info['changed'] = true;
2040
2041	echo serialize(array(
2042	'msg' => lang('Entry added with success!'),
2043	'status' => 'ok'
2044	));
2045	}
2046	else
2047	{
2048	echo serialize(array(
2049	'msg' => lang("Problems on adding your Group. Be sure that a group with this name do not exists").
2050	"\n".$acumulatedErrors,
2051	'status' => 'error'
2052	));
2053	}
2054
2055	$this->save_session();
2056	}
2057
2058	/*!
2059
2060	@function remove_group
2061	@abstract Removes a group if the user has the right to do it
2062	@author Nilton Emilio Buhrer Neto
2063	@param (integer) $id The id to be removed
2064
2065	*/
2066	function remove_group($id)
2067	{
2068	$soGroup = CreateObject('contactcenter.so_group');
2069	$data = array ('id_group' => $id);
2070	if($soGroup -> delete($data)) {
2071	echo serialize(array(
2072	'msg' => lang('Removed Entry ID '.$id.'!'),
2073	'status' => 'ok'
2074	));
2075	}
2076	else {
2077	echo serialize(array(
2078	'msg' => lang("Could\'nt remove group with id: %1", $id),
2079	'status' => 'error'
2080	));
2081	}
2082
2083	$this->save_session();
2084	}
2085
2086
2087	function remove_all_entries (){
2088
2089	$error = false;
2090	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
2091
2092	foreach($this->all_entries as $index => $id) {
2093	$result = $this->bo->catalog->remove_single_entry($id);
2094	if(!$result) {
2095	$error = true;
2096	break;
2097	}
2098	}
2099
2100	if(!$error) {
2101	echo serialize(array(
2102	'msg' => lang('Removed Entry ID '.$id.'!'),
2103	'status' => 'ok'
2104	));
2105	}
2106	else {
2107	echo serialize(array(
2108	'msg' => lang('Couldn\'t remove this entry. Inform the Site Admin!'),
2109	'status' => 'fail'
2110	));
2111	}
2112
2113	$this->save_session();
2114	}
2115
2116	/*!
2117
2118	@function remove_entry
2119	@abstract Removes an entry if the user has the right to do it
2120	@author Raphael Derosso Pereira
2121
2122	@param (integer) $id The id to be removed
2123
2124	*/
2125	function remove_entry ($id)
2126	{
2127	if (!is_int($id))
2128	{
2129	echo lang('Couldn\'t remove entry! Problem passing data to the server. Please inform admin!');
2130	return;
2131	}
2132
2133	$this->page_info['changed'] = true;
2134	$result = $this->bo->catalog->remove_single_entry($id);
2135
2136	if ($result)
2137	{
2138	if ($pos = array_search($id, $this->page_info['actual_entries']))
2139	{
2140	unset($this->page_info['actual_entries'][$pos]);
2141	}
2142
2143	$temp = false;
2144	reset($this->page_info['actual_entries']);
2145	foreach($this->page_info['actual_entries'] as $t)
2146	{
2147	$temp[] = $t;
2148	}
2149
2150	$this->page_info['actual_entries'] = $temp;
2151
2152	echo serialize(array(
2153	'msg' => lang('Removed Entry ID '.$id.'!'),
2154	'status' => 'ok'
2155	));
2156	}
2157	else
2158	{
2159	echo serialize(array(
2160	'msg' => lang('Couldn\'t remove this entry. Inform the Site Admin!'),
2161	'status' => 'fail'
2162	));
2163	}
2164
2165	$this->save_session();
2166	}
2167
2168
2169	/*!
2170
2171	@function post_full_add
2172	@abstract Saves all the information altered/entered in the Full Add
2173	window
2174	@author Raphael Derosso Pereira
2175
2176	*/
2177	function post_full_add()
2178	{
2179	$data = $_POST['data'];
2180	// Exceptions!!! utf8 special chars.
2181	$data = preg_replace("/\%u2(\d+)(\d+)(\d+)/","-",$data);
2182	$data = unserialize(str_replace('\\"', '"', $data));
2183	$this -> bo -> catalog = CreateObject('contactcenter.bo_people_catalog');
2184
2185	if (!is_array($data))
2186	{
2187	echo serialize(array(
2188	'msg' => lang('<p>Some problem receiving data from browser. This is probably a bug in ContactCenter<br>'.
2189	'Please go to eGroupWare Bug Reporting page and report this bug.<br>'.
2190	'Sorry for the inconvenient!<br><br>'.
2191	'<b><i>ContactCenter Developer Team</i></b></p>'),
2192	'status' => 'fatal'
2193	));
2194	return;
2195	}
2196	// print_r($data);
2197	// echo '<br><br>';
2198
2199	$replacer = $data['commercialAnd'];
2200	unset($data['commercialAnd']);
2201	if (!is_string($replacer) or strpos($replacer, "'") or strpos($replacer, '"'))
2202	{
2203	echo serialize(array(
2204	'msg' => lang('Invalid \'&\' replacer! This may be an attempt to bypass Security! Action aborted!'),
2205	'status' => 'fatal'
2206	));
2207
2208	return;
2209	}
2210
2211	if ($data['id_contact'])
2212	{
2213	$id = $data['id_contact'];
2214	$id_photo = $id;
2215	unset($data['id_contact']);
2216	}
2217	else
2218	{
2219	$id_photo = '_new_';
2220	}
2221
2222	/*
2223	* Process Photo, if available
2224	*/
2225	$sleep_count = 0;
2226	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
2227	while($photo_ok[0]{0} !== 'o' and $photo_ok[1]{0} === 'y')
2228	{
2229	sleep(1);
2230	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
2231	$sleep_count++;
2232
2233	if ($sleep_count > 35)
2234	{
2235	// TODO
2236	return;
2237	}
2238	}
2239	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'n'));
2240
2241	if (isset($this->page_info['photos'][$id_photo]))
2242	{
2243	if (array_search($this->page_info['photos'][$id_photo]['status'], array('changed', 'sync')) === false)
2244	{
2245	echo serialize(array(
2246	'msg' => $this->page_info['photos'][$id_photo]['msg'],
2247	'status' => $this->page_info['photos'][$id_photo]['status']
2248	));
2249
2250	return;
2251	}
2252
2253	$data['photo'] = $this->page_info['photos'][$id_photo]['content'];
2254	unset($this->page_info['photos'][$id_photo]);
2255	$this->save_session();
2256	}
2257
2258	/*
2259	* Arrange Date so it gets inserted correctly
2260	*/
2261
2262	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
2263
2264	$j = 0;
2265	for ($i = 0; $i < 5; $i+=2)
2266	{
2267	switch($dateformat{$i})
2268	{
2269	case 'Y':
2270	$date[$j]['size'] = 4;
2271	$date[$j]['digit'] = 'Y';
2272	break;
2273
2274	case 'm':
2275	case 'M':
2276	$date[$j]['size'] = 2;
2277	$date[$j]['digit'] = 'M';
2278	break;
2279
2280	case 'd':
2281	$date[$j]['size'] = 2;
2282	$date[$j]['digit'] = 'D';
2283	}
2284	$j++;
2285	}
2286	$datecount = 0;
2287
2288	/* Verify Data and performs insertion/update */
2289	foreach($data as $field => $value)
2290	{
2291	$dataConn = $data['connections'];
2292	$aa = count($dataConn);
2293
2294	for($i = 0; $i < $aa; $i++ )
2295	{
2296	if($dataConn['connection'.$i]['connection_is_default'] == "TRUE")
2297	{
2298	$email = $dataConn['connection'.$i]['connection_value'];
2299	}
2300	}
2301	// verifica se email já existe!
2302	$boGroup = CreateObject('contactcenter.bo_group');
2303	$contact = $boGroup->verify_contact($email);
2304	if($contact)
2305	{
2306	$str_contact = "\r\n - ".implode("\r\n - ",$contact);
2307	echo serialize(array(
2308	'msg' => lang('Problems on adding your Contact. The email "%1" already exists in: %2',$tdata[4], $str_contact),
2309	'status' => 'alreadyExists'
2310	));
2311	return;
2312	}
2313
2314	switch($field)
2315	{
2316	case 'names_ordered':
2317	$data[$field] = addslashes(rawurldecode($value));
2318	case 'corporate_name':
2319	case 'job_title':
2320	case 'department':
2321	case 'web_page':
2322	case 'alias':
2323	case 'given_names':
2324	case 'family_names':
2325	case 'pgp_key':
2326	case 'notes':
2327	$data[$field] = addslashes(rawurldecode($data[$field]));
2328	break;
2329
2330	case 'id_status':
2331	case 'id_prefix':
2332	case 'id_suffix':
2333	if ($data[$field] == 0)
2334	{
2335	unset($data[$field]);
2336	}
2337	break;
2338
2339	case 'birthdate_0':
2340	case 'birthdate_1':
2341	case 'birthdate_2':
2342	case 'birthdate':
2343
2344	if($field == 'birthdate'){
2345	$array_birth = explode("/",$data[$field]);
2346	$date['value'][2] = $array_birth[2];
2347	$date['value'][1] = $array_birth[1];
2348	$date['value'][0] = $array_birth[0];
2349	}else{
2350	switch($date[$datecount]['digit'])
2351	{
2352	case 'Y':
2353	$date['value'][2] = (int) $data[$field];
2354	break;
2355
2356	case 'M':
2357	$date['value'][0] = (int) $data[$field];
2358	break;
2359
2360	case 'D':
2361	$date['value'][1] = (int) $data[$field];
2362	break;
2363	}
2364	unset($data[$field]);
2365	}
2366
2367	$datecount++;
2368
2369	if ($datecount != 3)
2370	{
2371	break;
2372	}
2373
2374	if($date['value'][0] =='' && $date['value'][1] =='' && $date['value'][2] ==''){
2375	$data['birthdate'] = null;
2376	break;
2377	}
2378	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
2379	{
2380	echo serialize(array(
2381	'msg' => lang('Invalid Date'),
2382	'status' => 'invalid_data'
2383	));
2384	return;
2385	}
2386	if( $date['value'][2] != "" && $date['value'][0] != "" && $date['value'][1] != ""){
2387	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
2388	}
2389	break;
2390
2391	case 'sex':
2392	if ($data[$field] !== 'M' and $data[$field] !== 'F')
2393	{
2394	echo serialize(array(
2395	'msg' => lang('Invalid Sex'),
2396	'status' => 'invalid_data'
2397	));
2398	return;
2399	}
2400	break;
2401
2402
2403	case 'addresses':
2404	/* Insert new cities/states */
2405	if (isset($value['new_states']))
2406	{
2407	foreach($value['new_states'] as $type => $state_info)
2408	{
2409	$index = 'address'.$type;
2410
2411	$id_state = $this->bo->catalog->add_state($state_info);
2412	$data['addresses'][$index]['id_state'] = $id_state;
2413
2414	if ($value['new_cities'][$type])
2415	{
2416	$data[$field]['new_cities'][$type]['id_state'] = $id_state;
2417	}
2418	}
2419
2420	unset($data['addresses']['new_states']);
2421	}
2422
2423	if (isset($value['new_cities']))
2424	{
2425	foreach($value['new_cities'] as $type => $city_info)
2426	{
2427	$index = 'address'.$type;
2428
2429	$id_city = $this->bo->catalog->add_city($city_info);
2430	$data['addresses'][$index]['id_city'] = $id_city;
2431	}
2432
2433	unset($data['addresses']['new_cities']);
2434	}
2435
2436	break;
2437
2438	case 'birthdate':
2439	case 'connections':
2440	case 'photo':
2441	/* Does nothing... */
2442	break;
2443
2444	default:
2445	echo serialize(array(
2446	'msg' => lang('Invalid field: ').$field,
2447	'status' => 'invalid_data'
2448	));
2449	return;
2450	}
2451	}
2452
2453	if (!is_null($id) and $id !== '')
2454	{
2455	$id = $this->bo->catalog->update_single_info($id, $data);
2456	$result = array(
2457	'msg' => lang('Updated Successfully!'),
2458	'status' => 'ok'
2459	);
2460	}
2461	else
2462	{
2463	$id = $this->bo->catalog->add_single_entry($data);
2464	$result = array(
2465	'msg' => lang('Entry Added Successfully!'),
2466	'status' => 'ok'
2467	);
2468	}
2469
2470	if (!($id))
2471	{
2472	$result = array(
2473	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
2474	'Report the problem to the Administrator.'),
2475	'status' => 'fail'
2476	);
2477	}
2478
2479	echo serialize($result);
2480	}
2481
2482
2483	function post_full_add_shared()
2484	{
2485	$data = $_POST['data'];
2486	// Exceptions!!! utf8 special chars.
2487	$data = preg_replace("/\%u2(\d+)(\d+)(\d+)/","-",$data);
2488	$data = unserialize(str_replace('\\"', '"', $data));
2489	$this -> bo -> catalog = CreateObject('contactcenter.bo_shared_people_manager');
2490
2491	if (!is_array($data))
2492	{
2493	echo serialize(array(
2494	'msg' => lang('<p>Some problem receiving data from browser. This is probably a bug in ContactCenter<br>'.
2495	'Please go to eGroupWare Bug Reporting page and report this bug.<br>'.
2496	'Sorry for the inconvenient!<br><br>'.
2497	'<b><i>ContactCenter Developer Team</i></b></p>'),
2498	'status' => 'fatal'
2499	));
2500	return;
2501	}
2502	// print_r($data);
2503	// echo '<br><br>';
2504
2505	$replacer = $data['commercialAnd'];
2506	unset($data['commercialAnd']);
2507	if (!is_string($replacer) or strpos($replacer, "'") or strpos($replacer, '"'))
2508	{
2509	echo serialize(array(
2510	'msg' => lang('Invalid \'&\' replacer! This may be an attempt to bypass Security! Action aborted!'),
2511	'status' => 'fatal'
2512	));
2513
2514	return;
2515	}
2516
2517	if ($data['id_contact'])
2518	{
2519	$id = $data['id_contact'];
2520	$id_photo = $id;
2521	unset($data['id_contact']);
2522	}
2523	else
2524	{
2525	$id_photo = '_new_';
2526	}
2527
2528	if ($data['owner'])
2529	{
2530	$owner = $data['owner'];
2531	unset($data['owner']);
2532	}
2533	/*
2534	* Process Photo, if available
2535	*/
2536	$sleep_count = 0;
2537	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
2538	while($photo_ok[0]{0} !== 'o' and $photo_ok[1]{0} === 'y')
2539	{
2540	sleep(1);
2541	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
2542	$sleep_count++;
2543
2544	if ($sleep_count > 35)
2545	{
2546	// TODO
2547	return;
2548	}
2549	}
2550	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'n'));
2551
2552	if (isset($this->page_info['photos'][$id_photo]))
2553	{
2554	if (array_search($this->page_info['photos'][$id_photo]['status'], array('changed', 'sync')) === false)
2555	{
2556	echo serialize(array(
2557	'msg' => $this->page_info['photos'][$id_photo]['msg'],
2558	'status' => $this->page_info['photos'][$id_photo]['status']
2559	));
2560
2561	return;
2562	}
2563
2564	$data['photo'] = $this->page_info['photos'][$id_photo]['content'];
2565	unset($this->page_info['photos'][$id_photo]);
2566	$this->save_session();
2567	}
2568
2569	/*
2570	* Arrange Date so it gets inserted correctly
2571	*/
2572
2573	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
2574
2575	$j = 0;
2576	for ($i = 0; $i < 5; $i+=2)
2577	{
2578	switch($dateformat{$i})
2579	{
2580	case 'Y':
2581	$date[$j]['size'] = 4;
2582	$date[$j]['digit'] = 'Y';
2583	break;
2584
2585	case 'm':
2586	case 'M':
2587	$date[$j]['size'] = 2;
2588	$date[$j]['digit'] = 'M';
2589	break;
2590
2591	case 'd':
2592	$date[$j]['size'] = 2;
2593	$date[$j]['digit'] = 'D';
2594	}
2595	$j++;
2596	}
2597	$datecount = 0;
2598
2599	/* Verify Data and performs insertion/update */
2600	foreach($data as $field => &$value)
2601	{
2602
2603	$dataConn = $data['connections'];
2604	$aa = count($dataConn);
2605
2606	for($i = 0; $i < $aa; $i++ )
2607	{
2608	if($dataConn['connection'.$i]['connection_is_default'] == "TRUE")
2609	{
2610	$email = $dataConn['connection'.$i]['connection_value'];
2611	}
2612	}
2613	// verifica se email já existe!
2614	$boGroup = CreateObject('contactcenter.bo_group');
2615	$contact = $boGroup->verify_shared_contact($owner,$email);
2616	if($contact)
2617	{
2618	$str_contact = "\r\n - ".implode("\r\n - ",$contact);
2619	echo serialize(array(
2620	'msg' => lang('Problems on adding your Contact. The email "%1" already exists in: %2',$tdata[4], $str_contact),
2621	'status' => 'alreadyExists'
2622	));
2623	return;
2624	}
2625
2626	if ($value == '' or is_null($value))
2627	{
2628	unset($data[$field]);
2629	continue;
2630	}
2631
2632	switch($field)
2633	{
2634	case 'corporate_name':
2635	case 'job_title':
2636	case 'department':
2637	case 'web_page':
2638	case 'alias':
2639	case 'given_names':
2640	case 'family_names':
2641	case 'names_ordered':
2642	case 'pgp_key':
2643	case 'notes':
2644	case 'photo':
2645	$data[$field] = urldecode( $value );
2646	break;
2647
2648	case 'id_status':
2649	case 'id_prefix':
2650	case 'id_suffix':
2651	if ($data[$field] == 0)
2652	{
2653	unset($data[$field]);
2654	}
2655	break;
2656
2657	case 'birthdate_0':
2658	case 'birthdate_1':
2659	case 'birthdate_2':
2660
2661	switch($date[$datecount]['digit'])
2662	{
2663	case 'Y':
2664	$date['value'][2] = (int) $data[$field];
2665	break;
2666
2667	case 'M':
2668	$date['value'][0] = (int) $data[$field];
2669	break;
2670
2671	case 'D':
2672	$date['value'][1] = (int) $data[$field];
2673	break;
2674	}
2675	unset($data[$field]);
2676	$datecount++;
2677
2678	if ($datecount != 3)
2679	{
2680	break;
2681	}
2682
2683	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
2684	{
2685	echo serialize(array(
2686	'msg' => lang('Invalid Date'),
2687	'status' => 'invalid_data'
2688	));
2689	return;
2690	}
2691
2692	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
2693	break;
2694
2695	case 'sex':
2696	if ($data[$field] !== 'M' and $data[$field] !== 'F')
2697	{
2698	echo serialize(array(
2699	'msg' => lang('Invalid Sex'),
2700	'status' => 'invalid_data'
2701	));
2702	return;
2703	}
2704	break;
2705
2706
2707	case 'addresses':
2708	/* Insert new cities/states */
2709	if (isset($value['new_states']))
2710	{
2711	foreach($value['new_states'] as $type => $state_info)
2712	{
2713	$index = 'address'.$type;
2714
2715	$id_state = $this->bo->catalog->add_state($state_info);
2716	$data['addresses'][$index]['id_state'] = $id_state;
2717
2718	if ($value['new_cities'][$type])
2719	{
2720	$value['new_cities'][$type]['id_state'] = $id_state;
2721	}
2722	}
2723
2724	unset($data['addresses']['new_states']);
2725	}
2726
2727	if (isset($value['new_cities']))
2728	{
2729	foreach($value['new_cities'] as $type => $city_info)
2730	{
2731	$index = 'address'.$type;
2732
2733	$id_city = $this->bo->catalog->add_city($city_info);
2734	$data['addresses'][$index]['id_city'] = $id_city;
2735	}
2736
2737	unset($data['addresses']['new_cities']);
2738	}
2739
2740	break;
2741
2742	case 'connections':
2743	/* Does nothing... */
2744	$aaaa = 1111;
2745	break;
2746
2747	default:
2748	echo serialize(array(
2749	'msg' => lang('Invalid field: ').$field,
2750	'status' => 'invalid_data'
2751	));
2752	return;
2753	}
2754	}
2755
2756	$code = '$id = $this->bo->catalog->';
2757
2758	if (!is_null($id) and $id !== '')
2759	{
2760	$code .= $code.'update_single_info($id, $data);';
2761	$result = array(
2762	'msg' => lang('Updated Successfully!'),
2763	'status' => 'ok'
2764	);
2765	}
2766	else
2767	{
2768	$code .= 'add_single_entry($data,'.$owner.');';
2769	$result = array(
2770	'msg' => lang('Entry Added Successfully!'),
2771	'status' => 'ok'
2772	);
2773	}
2774
2775	eval($code);
2776
2777	if (!($id))
2778	{
2779	$result = array(
2780	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
2781	'Report the problem to the Administrator.'),
2782	'status' => 'fail'
2783	);
2784	}
2785
2786	echo serialize($result);
2787	}
2788	/*!
2789
2790	@function post_photo
2791	@abstract Wrapper to post a photo without reload a page.
2792	@author Raphael Derosso Pereira
2793
2794	*/
2795	function post_photo($id)
2796	{
2797	//print_r($_FILES);
2798	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'y'));
2799
2800	if (!is_array($_FILES) and is_array(!$_FILES['cc_pd_photo']))
2801	{
2802	$this->page_info['photos'][$id]['status'] = 'no_upload';
2803	$this->page_info['photos'][$id]['msg'] = lang('No Photos uploaded to Server.');
2804
2805	$this->save_session();
2806	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2807	return;
2808	}
2809
2810	if (!function_exists('imagecreate'))
2811	{
2812	$this->page_info['photos'][$id]['status'] = 'no_GD_lib';
2813	$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.');
2814
2815	$this->save_session();
2816	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2817	return;
2818	}
2819
2820	// TODO: Get Max Size from preferences!
2821	if ($_FILES['cc_pd_photo']['size'] > 1000000)
2822	{
2823	$this->page_info['photos'][$id]['status'] = 'too_large';
2824	$this->page_info['photos'][$id]['msg'] = lang('Image too large! ContactCenter limits the image size to 1 Mb');
2825
2826	$this->save_session();
2827	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2828	return;
2829	}
2830
2831	if ($_FILES['cc_pd_photo']['error'])
2832	{
2833	$this->page_info['photos'][$id]['status'] = 'error';
2834	$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'];
2835
2836	$this->save_session();
2837	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2838	return;
2839	}
2840
2841	switch($_FILES['cc_pd_photo']['type'])
2842	{
2843	case 'image/jpeg':
2844	case 'image/pjpeg':
2845	$src_img = imagecreatefromjpeg($_FILES['cc_pd_photo']['tmp_name']);
2846	if ($src_img == '')
2847	{
2848	$bogus = true;
2849	}
2850	break;
2851
2852	case 'image/png':
2853	case 'image/x-png':
2854	$src_img = imagecreatefrompng($_FILES['cc_pd_photo']['tmp_name']);
2855	if ($src_img == '')
2856	{
2857	$bogus = true;
2858	}
2859	break;
2860
2861	case 'image/gif':
2862	$src_img = imagecreatefromgif($_FILES['cc_pd_photo']['tmp_name']);
2863	if ($src_img == '')
2864	{
2865	$bogus = true;
2866	}
2867	break;
2868
2869	default:
2870
2871	$this->page_info['photos'][$id]['status'] = 'invalid_image';
2872	$this->page_info['photos'][$id]['msg'] = lang('The file must be an JPEG, PNG or GIF Image.');
2873
2874	$this->save_session();
2875	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2876	return;
2877	}
2878
2879	if ($bogus)
2880	{
2881	$this->page_info['photos'][$id]['status'] = 'invalid_file';
2882	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
2883
2884	$this->save_session();
2885	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2886	return;
2887	}
2888
2889	$img_size = getimagesize($_FILES['cc_pd_photo']['tmp_name']);
2890	$dst_img = imagecreatetruecolor(60, 80);
2891
2892	if (!imagecopyresized($dst_img, $src_img, 0, 0, 0, 0, 60, 80, $img_size[0], $img_size[1]))
2893	{
2894	$this->page_info['photos'][$id]['status'] = 'invalid_file';
2895	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
2896
2897	$this->save_session();
2898	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2899	return;
2900	}
2901
2902	ob_start();
2903	imagepng($dst_img);
2904	$this->page_info['photos'][$id]['content'] = ob_get_contents();
2905	ob_end_clean();
2906
2907	$this->page_info['photos'][$id]['status'] = 'changed';
2908	$this->page_info['photos'][$id]['msg'] = lang('Photo Successfully Updated!');
2909
2910	$this->save_session();
2911
2912	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2913
2914	imagedestroy($src_img);
2915	imagedestroy($dst_img);
2916	echo 'ok';
2917	return;
2918	}
2919
2920
2921	/*!
2922
2923	@function get_photo
2924	@abstract Returns the photo to the browser
2925	@author Raphael Derosso Pereira
2926
2927	*/
2928	function get_photo($id)
2929	{
2930	$fields = $this->bo->catalog->get_fields(false);
2931	$fields['photo'] = true;
2932
2933	$contact = $this->bo->catalog->get_single_entry($id, $fields);
2934
2935	if (!$contact['photo'])
2936	{
2937	header('Content-type: image/png');
2938	echo file_get_contents(PHPGW_INCLUDE_ROOT.'/contactcenter/templates/default/images/photo_celepar.png');
2939	return;
2940	}
2941
2942	header('Content-type: image/jpeg');
2943	$photo = imagecreatefromstring ($contact['photo']);
2944	$width = imagesx($photo);
2945	$height = imagesy($photo);
2946	$twidth = 70;
2947	$theight = 90;
2948	$small_photo = imagecreatetruecolor ($twidth, $theight);
2949	imagecopyresampled($small_photo, $photo, 0, 0, 0, 0,$twidth, $theight, $width, $height);
2950	imagejpeg($small_photo,"",100);
2951	return;
2952	}
2953
2954	/*!
2955
2956	@function get_states
2957	@abstract Echos a serialized array containing all the states for the given country
2958	@author Raphael Derosso Pereira
2959
2960	@params $id_country The ID of the Country that contains the requested states
2961
2962	*/
2963	function get_states($id_country)
2964	{
2965	$states = $this->bo->catalog->get_all_states($id_country);
2966
2967	if (!$states)
2968	{
2969	$result = array(
2970	'msg' => lang('No States found for this Country.'),
2971	'status' => 'empty'
2972	);
2973
2974	echo serialize($result);
2975	return;
2976	}
2977
2978	$result = array(
2979	'msg' => lang('States Successfully retrieved!'),
2980	'status' => 'ok'
2981	);
2982
2983	foreach ($states as $state_info)
2984	{
2985	$result['data'][$state_info['id_state']] = $state_info['name'];
2986
2987	if ($state_info['symbol'])
2988	{
2989	$result['data'][$state_info['id_state']] .= ', '.$state_info['symbol'];
2990	}
2991	}
2992
2993	echo serialize($result);
2994	}
2995
2996	/*!
2997
2998	@function get_cities
2999	@abstract Echos a serialized array containing all the cities of a given state
3000	@author Raphael Derosso Pereira
3001
3002	@param $id_country The ID of the Country that has the specified Cities (in case the
3003	Country doesn't have any States)
3004	@param $id_state The ID of the State that has the Cities requested
3005
3006	*/
3007	function get_cities($id_country, $id_state=false)
3008	{
3009	$cities = $this->bo->catalog->get_all_cities($id_country, $id_state);
3010
3011	if (!$cities)
3012	{
3013	$result = array(
3014	'msg' => lang('No Cities found for this State.'),
3015	'status' => 'empty'
3016	);
3017
3018	echo serialize($result);
3019	return;
3020	}
3021
3022	$result = array(
3023	'msg' => lang('Cities Successfully retrieved!'),
3024	'status' => 'ok'
3025	);
3026
3027	foreach ($cities as $city_info)
3028	{
3029	$result['data'][$city_info['id_city']] = $city_info['name'];
3030	}
3031
3032	echo serialize($result);
3033	}
3034
3035	//Traduz o campo na busca completa por entradas no catálogo do usuário.
3036	function aux_full_search ($field,$isldap) {
3037	$retorno = '';
3038	if($isldap) {
3039	switch($field) {
3040	case 'mail':
3041	$retorno = 'contact.connection.mail';
3042	break;
3043	case 'phone':
3044	$retorno = 'contact.connection.phone';
3045	break;
3046	}
3047	}
3048	else {
3049	switch($field) {
3050	case 'corporate':
3051	$retorno = 'contact.corporate_name';
3052	break;
3053	case 'mail':
3054	case 'phone':
3055	$retorno = 'contact.contact_connection.connection.connection_value';
3056	break;
3057	}
3058	}
3059	return $retorno;
3060	}
3061
3062	/*!
3063
3064	@function search
3065	@abstract Echos a serialized array containing the IDs
3066	of the entries that matches the search argument
3067	@author Raphael Derosso Pereira
3068	@author Mário César Kolling (external catalogs)
3069
3070	@param string $str_data A serialized array with two informations:
3071	$data = array(
3072	'search_for' => (string),
3073	'recursive' => (boolean),
3074	);
3075
3076	*/
3077	// SERPRO
3078	function search($str_data)
3079	{
3080	$data = unserialize($str_data);
3081	// It's an external catalog?
3082	$external = $this->bo->is_external($this->page_info['actual_catalog']);
3083	$full_search = isset($data['full_search'])?$data['full_search']:false;
3084
3085	if (!is_array($data) \|\| (!$data['search_for'] && !$full_search) \|\| !is_array($data['fields']))
3086	{
3087	echo serialize(array(
3088	'msg' => lang('Invalid parameters'),
3089	'status' => 'abort'
3090	));
3091
3092	return array('error' => lang('Invalid parameters'));
3093	}
3094
3095
3096	/*
3097	* TODO: look into the database to discover the database's encoding and convert the search_for field accordingly
3098	*/
3099	// Support search parameters with accentuation
3100	if ($this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
3101	/rev 104/
3102	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
3103	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
3104	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
3105	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
3106	/****/
3107	{
3108
3109	$data['search_for'] = utf8_encode($data['search_for']);
3110	}
3111
3112	$rules = array();
3113
3114	if ($data['search_for'] === '*')
3115	{
3116	$rules = array(
3117	0 => array(
3118	'field' => $data['fields']['search'],
3119	'type' => 'LIKE',
3120	'value' => '%'
3121	)
3122	);
3123	}
3124	else
3125	{
3126	$names = explode(' ', $data['search_for']);
3127
3128	if (!is_array($names))
3129	{
3130	if(!$full_search) {
3131	echo serialize(array(
3132	'msg' => lang('Invalid Search Parameter'),
3133	'status' => 'abort'
3134	));
3135	exit;
3136	}
3137	else
3138	$names = array();
3139
3140	}
3141
3142	if (!$external && $this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
3143	/rev 104/
3144	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
3145	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
3146	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
3147	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager' )
3148	/*****/
3149	{
3150	/*
3151	* Restrict the returned contacts search to objectClass = phpgwAccount,
3152	* must have attibute phpgwAccountStatus, phpgwAccountVisible != -1
3153	*/
3154
3155	$rules = array(
3156	0 => array(
3157	'field' => 'contact.object_class',
3158	'type' => '=',
3159	'value' => 'phpgwAccount'
3160	),
3161	1 => array(
3162	'field' => 'contact.account_status',
3163	'type' => 'iLIKE',
3164	'value' => '%'
3165	),
3166	/rev 104/
3167	///
3168	//1 => array(
3169	2 => array(
3170	/*****/
3171	'field' => 'contact.account_visible',
3172	'type' => '!=',
3173	'value' => '-1'
3174	/rev 104/
3175	/* ),
3176	2 => array(
3177	'field' => 'contact.object_class',
3178	'type' => '=',
3179	'value' => 'inetOrgPerson'
3180	/****/
3181	),
3182	);
3183
3184	if($full_search) {
3185	foreach($full_search as $field => $value) {
3186	if(trim($value)!='')
3187	array_push($rules,array(
3188	'field' => $this->aux_full_search($field,true),
3189	'type' => 'LIKE',
3190	'value' => ''.$value.''
3191	));
3192	}
3193	}
3194
3195	}
3196	else if(!$external && $full_search) {
3197
3198	foreach($full_search as $field => $value) {
3199	if(trim($value)!='')
3200	array_push($rules,array(
3201	'field' => $this->aux_full_search($field,false),
3202	'type' => 'iLIKE',
3203	'value' => '%'.$value.'%'
3204	));
3205	}
3206
3207	}
3208
3209	foreach ($names as $name)
3210	{
3211	if ($name != '')
3212	{
3213	array_push($rules, array(
3214	'field' => $data['fields']['search'],
3215	'type' => 'iLIKE',
3216	'value' => '%'.$name.'%'
3217	));
3218	}
3219	}
3220	}
3221
3222	if ($external \|\| $this->page_info['actual_catalog']['class'] == 'bo_people_catalog' \|\|
3223	/rev 104/
3224	//$this->page_info['actual_catalog']['class'] == 'bo_group_manager')
3225	$this->page_info['actual_catalog']['class'] == 'bo_group_manager' \|\|
3226	$this->page_info['actual_catalog']['class'] == 'bo_shared_people_manager' \|\|
3227	$this->page_info['actual_catalog']['class'] == 'bo_shared_group_manager')
3228
3229
3230	/***/
3231	{
3232	// Get only this attributes: dn, cn for external catalogs,
3233	// used to restrict the attributes used in filters
3234	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'), $data['search_for'] != null);
3235	}
3236	else
3237	{
3238	// Get only this attributes: dn, cn, phpgwAccountType, objectClass, phpgwAccountStatus, phpghAccountVisible
3239	// for non-external catalogs, used to restrict the attributes used in filters
3240	$ids = $this->bo->find(array(
3241	$data['fields']['id'],
3242	$data['fields']['search'],
3243	'contact.object_class',
3244	//'contact.account_status',
3245	'contact.account_visible',
3246	'contact.connection.mail',
3247	'contact.connection.phone'
3248	), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'), $data['search_for_area'], $data['search_for'] != null );
3249	}
3250
3251	if (!is_array($ids) \|\| !count($ids))
3252	{
3253	$this->last_search_ids = null;
3254	$this->save_session();
3255	return null;
3256	}
3257
3258	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
3259
3260	$ids_f = array();
3261
3262	foreach ($ids as $e_info)
3263	{
3264	/rev 104/
3265	//$ids_f[] = $e_info[$id_field];
3266	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
3267	{
3268	$ids_f[] = $e_info[$id_field];
3269	} else{
3270	$ids_f[] = array(0=>$e_info[$id_field],1=>$e_info['perms'],2=>$e_info['owner']);
3271	}
3272	/****/
3273	}
3274
3275	return $ids_f;
3276	}
3277
3278	// CELEPAR
3279	/*
3280	function search($str_data)
3281	{
3282	$data = unserialize($str_data);
3283
3284	if (!is_array($data) \|\| !$data['search_for'] \|\| !is_array($data['fields']))
3285	{
3286	echo serialize(array(
3287	'msg' => lang('Invalid parameters'),
3288	'status' => 'abort'
3289	));
3290
3291	return;
3292	}
3293
3294	$rules = array();
3295
3296	if ($data['search_for'] === '*')
3297	{
3298	$rules = array(
3299	0 => array(
3300	'field' => $data['fields']['search'],
3301	'type' => 'LIKE',
3302	'value' => '%'
3303	)
3304	);
3305	}
3306	else
3307	{
3308	$names = explode(' ', $data['search_for']);
3309
3310	if (!is_array($names))
3311	{
3312	echo serialize(array(
3313	'msg' => lang('Invalid Search Parameter'),
3314	'status' => 'abort'
3315	));
3316
3317	return;
3318	}
3319
3320	foreach ($names as $name)
3321	{
3322	if ($name != '')
3323	{
3324	array_push($rules, array(
3325	'field' => $data['fields']['search'],
3326	'type' => 'iLIKE',
3327	'value' => '%'.$name.'%'
3328	));
3329	}
3330	}
3331	}
3332
3333
3334
3335	//$catalog = $this->bo->get_branch_by_level($this->bo->catalog_level[0]);
3336
3337	//if ($catalog['class'] === 'bo_people_catalog')
3338	//{
3339	// array_push($rules, array(
3340	// 'field' => 'contact.id_owner',
3341	// 'type' => '=',
3342	// 'value' => $GLOBALS['phpgw_info']['user']['account_id']
3343	// ));
3344	//}
3345
3346
3347	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'));
3348
3349	if (!is_array($ids) \|\| !count($ids))
3350	{
3351	echo serialize(array(
3352	'msg' => lang('No Entries Found!'),
3353	'status' => 'empty'
3354	));
3355
3356	return;
3357	}
3358	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
3359
3360	$ids_f = array();
3361	foreach ($ids as $e_info)
3362	{
3363	$ids_f[] = $e_info[$id_field];
3364	}
3365
3366	echo serialize(array(
3367	'data' => $ids_f,
3368	'msg' => lang('Found %1 Entries', count($ids)),
3369	'status' => 'ok'
3370	));
3371
3372	return;
3373	}*/
3374	/*!
3375
3376	@function get_multiple_entries
3377	@abstract Returns an array containing the specifiend data in the default
3378	CC UI format
3379	@author Raphael Derosso Pereira
3380
3381	@param array str_data A serialized array containing the ID's of the entries
3382	to be taken, the fields to be taken and the rules to be used on the
3383	retrieval:
3384	$data = array(
3385	'ids' => array(...),
3386	'fields' => array(...),
3387	'rules' => array(...)
3388	);
3389
3390	*/
3391	function get_multiple_entries($str_data)
3392	{
3393	$data = unserialize($str_data);
3394
3395	if (!is_array($data) or !count($data) or !count($data['fields']) or !count($data['ids']))
3396	{
3397	return array(
3398	'msg' => lang('Invalid Parameters'),
3399	'status' => 'abort'
3400	);
3401	}
3402
3403	$entries = $this->bo->catalog->get_multiple_entries($data['ids'], $data['fields']);
3404
3405	if (!is_array($entries) or !count($entries))
3406	{
3407	return array(
3408	'msg' => lang('No Entries Found!'),
3409	'status' => 'empty'
3410	);
3411	}
3412
3413	return array(
3414	'msg' => lang('Found %1 Entries!', count($entries)),
3415	'status' => 'ok',
3416	'data' => $entries
3417	);
3418	}
3419
3420	/*
3421
3422	@function get_all_entries
3423	@abstract Returns the specified fields for all catalog's entries
3424	in the default CC UI format
3425	@author Raphael Derosso Pereira
3426
3427	@params array str_data A serialized array containing the fields to
3428	be grabbed, the maximum number of entries to be returned and a
3429	boolean specifying if the calls refers to a new grab or to an
3430	unfinished one.
3431
3432	*/
3433	function get_all_entries($str_data)
3434	{
3435	$data = unserialize($str_data);
3436
3437	if (!is_array($data) or
3438	!count($data) or
3439	!count($data['fields']) or
3440	!$data['maxlength'] or
3441	(!$data['new'] and !$data['offset']))
3442	{
3443	return array(
3444	'msg' => lang('Invalid Parameters'),
3445	'status' => 'abort'
3446	);
3447	}
3448
3449	if ($data['new'])
3450	{
3451	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
3452
3453	$this->save_session();
3454
3455	if (!is_array($this->all_entries) or !count($this->all_entries))
3456	{
3457	return array(
3458	'msg' => lang('No Entries Found!'),
3459	'status' => 'empty'
3460	);
3461	}
3462
3463	$data['offset'] = 0;
3464	}
3465
3466	if ($data['maxlength'] != -1)
3467	{
3468	$result = $this->bo->catalog->get_multiple_entries(array_slice($this->all_entries, $data['offset'], $data['maxlength']), $data['fields']);
3469	}
3470	else
3471	{
3472	$result = $this->bo->catalog->get_multiple_entries($this->all_entries, $data['fields']);
3473	}
3474
3475	$jsCode = array();
3476	$count = 0;
3477	foreach ($result as $each)
3478	{
3479	if (!is_array($each))
3480	{
3481	continue;
3482	}
3483
3484	if($this-> typeContact == 'groups') {
3485
3486	foreach ($each as $field => $value) {
3487
3488	if ($field === 'title') {
3489	$optionName = '\\"'.$value.'\\"';
3490
3491	}
3492	else if ($field === 'short_name') {
3493
3494	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$optionName.' ('.$value.')", "'.$count.'");';
3495	$count++;
3496	}
3497	}
3498	}
3499
3500	else {
3501	foreach ($each as $field => $value) {
3502	if ($field === 'names_ordered') {
3503	if(is_array($value))
3504	$value = $value[0];
3505	$name = '\\"'.$value.'\\"';
3506	}
3507	else if ($field === 'connections') {
3508
3509	foreach ($value as $connection) {
3510	if ($connection['id_type'] == $this->preferences['personCardEmail']) {
3511	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$name.' <'.$connection['connection_value'].'>", "'.$count.'");';
3512	$count++;
3513	}
3514	}
3515	}
3516	}
3517	}
3518	}
3519
3520	$jsCodeFinal = implode("\n", $jsCode);
3521
3522	$nEntries = count($result);
3523
3524	if (!$nEntries)
3525	{
3526	return array(
3527	'msg' => lang('Error while getting user information...'),
3528	'status' => 'abort'
3529	);
3530	}
3531
3532	return array(
3533	'msg' => lang('Found %1 Entries!', $nEntries),
3534	'status' => 'ok',
3535	'typeContact' => $this -> typeContact,
3536	'final' => $nEntries + $data['offset'] < count($this->all_entries) ? false : true,
3537	'offset' => $data['offset'] + $nEntries,
3538	'data' => $jsCodeFinal
3539	);
3540	}
3541
3542	/*********************************************************************\
3543	* Auxiliar Methods *
3544	\*********************************************************************/
3545
3546	/*!
3547
3548	@function save_session
3549	@abstract Saves the data on the session
3550	@author Raphael Derosso Pereira
3551
3552	*/
3553	function save_session()
3554	{
3555	$GLOBALS['phpgw']->session->appsession('ui_data.page_info','contactcenter',$this->page_info);
3556	$GLOBALS['phpgw']->session->appsession('ui_data.all_entries','contactcenter',$this->all_entries);
3557	}
3558
3559	/*!
3560
3561	@function convert_tree
3562	@abstract Converts the tree array in the BO format to a JS tree array compatible
3563	with the one available in eGW
3564	@author Raphael Derosso Pereira
3565
3566	@param (array) $tree The tree in the BO format
3567	@param (string) $name The tree name
3568	@param (string) $iconDir The dir where the icons are
3569	@param (string) $parent The parent
3570	*/
3571
3572	function convert_tree($tree, &$iconDir, $parent='0')
3573	{
3574	// echo "Entrou<br>\tPai: $parent <br>";
3575	$rtree = array();
3576
3577	if ($parent === '0')
3578	{
3579	// echo 'Root!<br>';
3580	$rtree['0'] = array(
3581	'type' => 'catalog_group',
3582	'id' => '0',
3583	'pid' => 'none',
3584	'caption' => lang('Catalogues'),
3585	'class' => 'bo_catalog_group_catalog',
3586	'class_args' => array('_ROOT_', '$this', '$this->get_branch_by_level($this->catalog_level[0])')
3587	);
3588	}
3589
3590	foreach($tree as $id => $value)
3591	{
3592	// echo 'ID: '.$id.'<br>';
3593	$rtree[$parent.'.'.$id] = array(
3594	'type' => $value['type'],
3595	'id' => $parent.'.'.$id,
3596	'pid' => $parent,
3597	'caption' => $value['name']
3598	);
3599
3600	switch($value['type'])
3601	{
3602	case 'catalog_group':
3603	case 'mixed_catalog_group':
3604	$rtree = $rtree + $this->convert_tree($value['sub_branch'],$iconDir,$parent.'.'.$id);
3605	break;
3606	}
3607	}
3608
3609	if (count($rtree))
3610	{
3611	return $rtree;
3612	}
3613	}
3614
3615	function get_catalog_add_contact($id, $echo=true){
3616
3617	$array_participants = array();
3618	if(!$this->bo->catalog->src_info) {
3619	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3620	$this->bo->catalog->src_info = $ldap->srcs[1];
3621	}
3622
3623	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3624	$dn=$this->bo->catalog->src_info['dn'];
3625	$justThese = array("givenname","givenname","sn","telephonenumber","mail");
3626	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
3627	$info = ldap_get_entries($ds, $sr);
3628	for($z = 0; $z < 5; $z++) {
3629	$participant = $info[0][$justThese[$z]];
3630	array_push($array_participants, $participant);
3631	}
3632
3633	ldap_close($ds);
3634	if ($echo)
3635	{
3636	echo serialize($array_participants);
3637	}
3638	else
3639	{
3640	return serialize($array_participants);
3641	}
3642	}
3643
3644	function get_catalog_participants_group($id)
3645	{
3646	if(!$this->bo->catalog->src_info) {
3647	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3648	$this->bo->catalog->src_info = $ldap->srcs[1];
3649	}
3650	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3651	$justThese = array("description","memberuid");
3652	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
3653	$info = ldap_get_entries($ds, $sr);
3654	$member_uids = $info[0]['memberuid'];
3655	$contact['names_ordered'] = $info[0]['description'];
3656	$filter = "";
3657	for($z = 0; $z < count($member_uids); $z++) {
3658	if($member_uids[$z])
3659	$filter.="(uid=".$member_uids[$z].")";
3660	}
3661	$array_participants = array();
3662	if($filter) {
3663	$filter = "(\|".$filter.")";
3664	$valarray = explode(',',$id);
3665	array_shift($valarray);
3666	$dn = implode(',',$valarray);
3667	$justThese = array("cn","mail");
3668	$sr = ldap_search($ds,$dn, $filter,$justThese);
3669	$info = ldap_get_entries($ds, $sr);
3670	for($z = 0; $z < $info['count']; $z++) {
3671	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
3672	$array_emails[$info[$z]['mail'][0]] = null;
3673	array_push($array_participants, $participant);
3674	}
3675	ldap_close($ds);
3676	}
3677	sort($array_participants);
3678	$innerHTML = '';
3679	foreach($array_participants as $index => $participant){
3680	$innerHTML .= $participant;
3681	}
3682	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
3683	echo serialize($return);
3684	}
3685
3686	function get_catalog_participants_list($id)
3687	{
3688
3689	$fields = $this->bo->catalog->get_fields(false);
3690	$fields['names_ordered'] = true;
3691	$fields['mail_forwarding_address'] = true;
3692	$contact = $this->bo->catalog->get_single_entry($id,$fields);
3693
3694	$array_participants = array();
3695	$array_emails = array();
3696
3697	$filter = null;
3698	for($z = 0; $z < $contact['mail_forwarding_address']['count']; $z++) {
3699	if(strstr($contact['mail_forwarding_address'][$z],'@')) {
3700	$filter.="(mail=".$contact['mail_forwarding_address'][$z].")";
3701	$array_emails[$contact['mail_forwarding_address'][$z]] = "<font color=black>".$contact['mail_forwarding_address'][$z]."</font>";
3702	}
3703	else
3704	$array_participants[$z] = "<font color=red>".$contact['mail_forwarding_address'][$z]."</font>";
3705	}
3706
3707	if($filter) {
3708	$filter = "(\|".$filter.")";
3709	if(!$this->bo->catalog->src_info) {
3710	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3711	$this->bo->catalog->src_info = $ldap->srcs[1];
3712	}
3713	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3714	$dn=$this->bo->catalog->src_info['dn'];
3715	$justThese = array("cn","mail");
3716	$sr = ldap_search($ds,$dn, $filter,$justThese);
3717	$info = ldap_get_entries($ds, $sr);
3718	for($z = 0; $z < $info['count']; $z++) {
3719	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
3720	$array_emails[$info[$z]['mail'][0]] = null;
3721	array_push($array_participants, $participant);
3722	}
3723
3724	foreach($array_emails as $index => $email)
3725	if($email)
3726	array_push($array_participants, "      ".$email."<br>");
3727
3728	ldap_close($ds);
3729	}
3730	sort($array_participants);
3731	$innerHTML = '';
3732	foreach($array_participants as $index => $participant){
3733	$innerHTML .= $participant;
3734	}
3735	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
3736	echo serialize($return);
3737	}
3738
3739	function export_contacts($typeExport){
3740
3741	$boGroup = CreateObject('contactcenter.bo_group');
3742	$contacts = $boGroup->get_all_contacts();
3743	$streamBuffer = '';
3744
3745	if(!count($contacts))
3746	echo null;
3747
3748	switch($typeExport) {
3749
3750	case 'outlook_en':
3751	$streamBuffer = "Name;E-mail Address;Notes;Mobile Phone;Pager;Company;".
3752	"Job Title;Home Phone;Home Fax;Business Phone;Business Fax\r\n";
3753	foreach($contacts as $index => $object){
3754	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
3755	. "\"".$object[ 'main-mail' ] . "\";"
3756	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\";"
3757	. "\"".$object[ 'mobile' ] . "\";"
3758	. "\"".$object[ 'business-pager' ] . "\";"
3759	. "\"".$object[ 'corporate_name' ] . "\";"
3760	. "\"".$object[ 'job_title' ] . "\";"
3761	. "\"".$object[ 'home-phone' ] . "\";"
3762	. "\"".$object[ 'home-fax' ] . "\";"
3763	. "\"".$object[ 'business-phone' ] . "\";"
3764	. "\"".$object[ 'business-fax' ] . "\"\r\n";
3765	}
3766	break;
3767
3768	case 'outlook_pt-BR':
3769	$streamBuffer = "Nome;Sobrenome;Segundo nome;Nome;Apelido;End. de email;Endereço residencial;"
3770	."Cidade do endereço residencial;CEP do endereço residencial;Estado;País/região do endereço residencial;"
3771	."Telefone residencial;Fax residencial;Telefone celular;Página pessoal da Web;Rua do endereço comercial;"
3772	."Cidade do endereço comercial;CEP do endereço comercial;Estado do endereço comercial;"
3773	."País/região do endereço comercial;Página comercial da Web;Telefone comercial;Fax comercial;Pager;Empresa;"
3774	."Cargo;Departamento;End. comercial;Observações\r\n";
3775
3776	foreach($contacts as $index => $object){
3777	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
3778	.";;;"
3779	. "\"".$object[ 'alias' ] . "\";"
3780	. "\"".$object[ 'main-mail' ] . "\";"
3781	. "\"".$object[ 'home-address' ] . "\";"
3782	. "\"".$object[ 'home-city_name' ] . "\";"
3783	. "\"".$object[ 'home-postal_code' ] . "\";"
3784	. "\"".$object[ 'home-state_name' ] . "\";"
3785	. "\"".$object[ 'home-id_country' ] . "\";"
3786	. "\"".$object[ 'home-phone' ] . "\";"
3787	. "\"".$object[ 'home-fax' ] . "\";"
3788	. "\"".$object[ 'mobile' ] . "\";"
3789	. "\"".$object[ 'web_page' ] . "\";"
3790	. "\"".$object[ 'business-address' ] . "\";"
3791	. "\"".$object[ 'business-city_name' ] . "\";"
3792	. "\"".$object[ 'business-postal_code' ] . "\";"
3793	. "\"".$object[ 'business-state_name' ] . "\";"
3794	. "\"".$object[ 'business-id_country' ] . "\";"
3795	. "\"".$object[ 'web_page' ] . "\";"
3796	. "\"".$object[ 'business-phone' ] . "\";"
3797	. "\"".$object[ 'business-fax' ] . "\";"
3798	. "\"".$object[ 'business-pager' ] . "\";"
3799	. "\"".$object[ 'corporate_name' ] . "\";"
3800	. "\"".$object[ 'job_title' ] . "\";"
3801	. "\"".$object[ 'department' ] . "\";"
3802	.";"
3803	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\"\r\n";
3804	}
3805
3806	break;
3807
3808	case 'outlook2000_pt-BR':
3809	$streamBuffer = "\"Tratamento\",\"Nome\",\"Segundo Nome\",\"Sobrenome\",\"Sufixo\",".
3810	"\"Empresa\",\"Departamento\",\"Cargo\",\"Rua do endereço comercial\",\"Rua do endereço comercial 2\",".
3811	"\"Rua do endereço comercial 3\",\"Cidade do endereço comercial\",\"Estado do endereço comercial\",".
3812	"\"CEP do endereço comercial\",\"País do endereço comercial\",\"Endereço residencial\",\"Rua residencial 2\",".
3813	"\"Rua residencial 3\",\"Cidade do endereço residencial\",\"Estado\",\"CEP do endereço residencial\",\"País do endereço residencial\",".
3814	"\"Outro endereço\",\"Outro endereço 2\",\"Outro endereço 3\",\"Cidade\",\"Estado\",\"CEP\",\"País\",".
3815	"\"Telefone do assistente\",\"Fax comercial\",\"Telefone comercial\",\"Telefone comercial 2\",\"Retorno de chamada\",".
3816	"\"Telefone do carro\",\"Telefone principal da empresa\",\"Fax residencial\",\"Telefone residencial\",".
3817	"\"Telefone residencial 2\",\"ISDN\",\"Telefone celular\",\"Outro fax\",\"Outro telefone\",\"Pager\",\"Telefone principal\",".
3818	"\"Radiofone\",\"Telefone TTY/TDD\",\"Telex\",\"Aniversário\",\"Anotações\",\"Caixa postal\",\"Categorias\",".
3819	"\"Código da empresa\",\"Código do governo\",\"Cônjuge\",\"Conta\",\"Endereço de correio eletrônico\",".
3820	"\"Nome de exibição do correio eletr.\",\"Endereço de correio eletrônico 2\",".
3821	"\"Nome de exibição do correio eletr.2\",\"Endereço de correio eletrônico 3\",".
3822	"\"Nome de exibição do correio eletr.3\",\"Datas especiais\",\"Disponibilidade da Internet\",".
3823	"\"Filhos\",\"Hobby\",\"Idioma\",\"Indicação\",\"Informações para cobrança\",\"Iniciais\",\"Local\",".
3824	"\"Nome do assistente\",\"Nome do gerenciador\",\"Página da Web\",\"Palavras-chave\",\"Particular\",\"Personalizado 1\",\"Personalizado 2\",".
3825	"\"Personalizado 3\",\"Personalizado 4\",\"Prioridade\",\"Profissão\",\"Quilometragem\",\"Sala\",\"Sensibilidade\",\"Servidor de diretório\",".
3826	"\"Sexo\"\r\n";
3827
3828
3829
3830	foreach($contacts as $index => $object){
3831	$streamBuffer .= "\"".$object[ 'alias' ] . "\","
3832	. "\"".$object[ 'names_ordered' ] . "\","
3833	.",,,"
3834	. "\"".$object[ 'corporate_name' ] . "\","
3835	. "\"".$object[ 'department' ] . "\","
3836	. "\"".$object[ 'job_title' ] . "\","
3837	. "\"".$object[ 'business-address' ] . "\","
3838	. "\"".$object[ 'business-address-2' ] . "\","
3839	.","
3840	. "\"".$object[ 'business-city_name' ] . "\","
3841	. "\"".$object[ 'business-state' ] . "\","
3842	. "\"".$object[ 'business-postal_code' ] . "\","
3843	. "\"".$object[ 'business-id_country' ] . "\","
3844	. "\"".$object[ 'home-address' ] . "\","
3845	. "\"".$object[ 'home-address-2' ] . "\","
3846	.","
3847	. "\"".$object[ 'home-city_name' ] . "\","
3848	. "\"".$object[ 'home-state_name' ] . "\","
3849	. "\"".$object[ 'home-postal_code' ] . "\","
3850	. "\"".$object[ 'home-id_country' ] . "\","
3851	.",,,,,,,,"
3852	. "\"".$object[ 'business-fax' ] . "\","
3853	. "\"".$object[ 'business-phone' ] . "\","
3854	. "\"".$object[ 'business-mobile' ] . "\","
3855	.",,,"
3856	. "\"".$object[ 'home-fax' ] . "\","
3857	. "\"".$object[ 'home-phone' ] . "\","
3858	.",,"
3859	. "\"".$object[ 'mobile' ] . "\","
3860	.",,"
3861	. "\"".$object[ 'home-pager' ] . "\","
3862	. "\"".$object[ 'business-phone' ] . "\","
3863	.",,,"
3864	. "\"".$object[ 'birthdate' ] . "\","
3865	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
3866	.",,,,,,"
3867	. "\"".$object[ 'main-mail' ] . "\","
3868	.","
3869	. "\"".$object[ 'alternative-mail' ] . "\","
3870	.",,,,,,,,,,,,,,"
3871	. "\"".$object[ 'web_page' ] . "\","
3872	.",,,,,,,,,,,,"
3873	. "\"".$object[ 'sex' ] . "\"\r\n";
3874	}
3875	break;
3876
3877	case 'outlook2000_en':
3878	$streamBuffer = "Title,First Name,Middle Name,Last Name,Suffix,Company,Department,Job Title,".
3879	"Business Street,Business Street 2,Business Street 3,Business City,Business State,Business Postal Code,".
3880	"Business Country,Home Street,Home Street 2,Home Street 3,Home City,Home State,Home Postal Code,Home Country,".
3881	"Other Street,Other Street 2,Other Street 3,Other City,Other State,Other Postal Code,Other Country,".
3882	"Assistant's Phone,Business Fax,Business Phone,Business Phone 2,Callback,Car Phone,Company Main Phone,Home Fax,".
3883	"Home Phone,Home Phone 2,ISDN,Mobile Phone,Other Fax,Other Phone,Pager,Primary Phone,Radio Phone,TTY/TDD Phone,Telex,".
3884	"Account,Anniversary,Assistant's Name,Billing Information,Birthday,Categories,Children,Directory Server,E-mail Address,".
3885	"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,".
3886	"Gender,Government ID Number,Hobby,Initials,Internet Free Busy,Keywords,Language,Location,Manager's Name,Mileage,Notes,".
3887	"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";
3888
3889	foreach($contacts as $index => $object)
3890	{
3891	if( array_key_exists("phone", $object) )
3892	$phone = $object['phone'];
3893	else
3894	$phone = $object['business-phone'];
3895
3896	$streamBuffer.= "\"".$object[ 'alias' ] . "\","
3897	. "\"".$object[ 'names_ordered'] . "\","
3898	.",,,"
3899	. "\"".$object[ 'corporate_name' ] . "\","
3900	. "\"".$object[ 'department' ] . "\","
3901	. "\"".$object[ 'job_title' ] . "\","
3902	. "\"".$object[ 'business-address' ] . "\","
3903	. "\"".$object[ 'business-address-2' ] . "\","
3904	.","
3905	. "\"".$object[ 'business-city_name' ] . "\","
3906	. "\"".$object[ 'business-state' ] . "\","
3907	. "\"".$object[ 'business-postal_code' ] . "\","
3908	. "\"".$object[ 'business-id_country' ] . "\","
3909	. "\"".$object[ 'home-address' ] . "\","
3910	. "\"".$object[ 'home-address-2' ] . "\","
3911	.","
3912	. "\"".$object[ 'home-city_name' ] . "\","
3913	. "\"".$object[ 'home-state_name' ] . "\","
3914	. "\"".$object[ 'home-postal_code' ] . "\","
3915	. "\"".$object[ 'home-id_country' ] . "\","
3916	.",,,,,,,,"
3917	. "\"".$object[ 'business-fax' ] . "\","
3918	. "\"".$phone . "\","
3919	. "\"".$object[ 'business-mobile' ] . "\","
3920	.",,,"
3921	. "\"".$object[ 'home-fax' ] . "\","
3922	. "\"".$object[ 'home-phone' ] . "\","
3923	.",,"
3924	. "\"".$object[ 'mobile' ] . "\","
3925	.",,"
3926	. "\"".$object[ 'business-pager' ] . "\","
3927	. "\"".$object[ 'home-pager' ] . "\","
3928	.",,,,,,,,"
3929	. "\"".$object[ 'birthdate' ] . "\","
3930	.",,,"
3931	. "\"".$object[ 'main-mail' ] . "\","
3932	.",,"
3933	. "\"".$object[ 'alternative-mail' ] . "\","
3934	.",,,,,,,,,,,,,,,"
3935	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
3936	.",,,,,,,,,,,,,"
3937	. "\"".$object[ 'web_page' ] . "\"\r\n";
3938
3939	}
3940	break;
3941
3942	case 'thunderbird':
3943	$streamBuffer = "First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,"
3944	."Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,"
3945	."Home Address 2,Home City,Home State,Home ZipCode,Home Country,Work Address,Work Address 2,"
3946	."Work City,Work State,Work ZipCode,Work Country,Job Title,Department,Organization,Web Page 1,"
3947	."Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,\n";
3948
3949	foreach($contacts as $index => $object){
3950	$array_birth = explode("-",$object[ 'birthdate' ]);
3951	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\","
3952	.",,"
3953	. "\"".$object[ 'alias' ] . "\","
3954	. "\"".$object[ 'main-mail' ] . "\","
3955	. "\"".$object[ 'alternative-mail' ] . "\","
3956	.","
3957	. "\"".$phone . "\","
3958	. "\"".$object[ 'home-phone' ] . "\","
3959	. "\"".$object[ 'business-fax' ] . "\","
3960	. "\"".$object[ 'business-pager' ] . "\","
3961	. "\"".$object[ 'mobile' ] . "\","
3962	. "\"".$object[ 'home-address' ] . "\","
3963	. "\"".$object[ 'home-address-2' ] . "\","
3964	. "\"".$object[ 'home-city_name' ] . "\","
3965	. "\"".$object[ 'home-state_name' ] . "\","
3966	. "\"".$object[ 'home-postal_code' ] . "\","
3967	. "\"".$object[ 'home-id_country' ] . "\","
3968	. "\"".$object[ 'business-address' ] . "\","
3969	. "\"".$object[ 'business-address-2' ] . "\","
3970	. "\"".$object[ 'business-city_name' ] . "\","
3971	. "\"".$object[ 'business-state_name' ] . "\","
3972	. "\"".$object[ 'business-postal_code' ] . "\","
3973	. "\"".$object[ 'business-id_country' ] . "\","
3974	. "\"".$object[ 'job_title' ] . "\","
3975	. "\"".$object[ 'department' ] . "\","
3976	. "\"".$object[ 'corporate_name' ] . "\","
3977	. "\"".$object[ 'web_page' ] . "\","
3978	. "\"".$object[ 'web_page' ] . "\","
3979	. "\"".$array_birth[0] . "\","
3980	. "\"".$array_birth[1] . "\","
3981	. "\"".$array_birth[2] . "\","
3982	.",,,,"
3983	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\",\r\n";
3984
3985	}
3986	break;
3987
3988	case 'expresso':
3989	$streamBuffer = 'Nome,Apelido,E-mail Principal,E-mail Alternativo,Celular,'
3990	. 'Telefone Comercial,Endereço Comercial,Complemento End. Comercial,CEP Comercial,Cidade End. Comercial,Estado End. Comercial,País End. Comercial,'
3991	. 'Telefone Residencial,Endereço Residencial,Complemento End. Residencial,CEP Residencial,Cidade End. Residencial,Estado End. Residencial,País End. Residencial,'
3992	. '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'
3993	. "\r\n";
3994
3995	foreach($contacts as $index => $object){
3996	$streamBuffer .= "\"".$object[ 'names_ordered'] . "\","
3997	. "\"".$object[ 'alias' ] . "\","
3998	. "\"".$object[ 'main-mail' ] . "\","
3999	. "\"".$object[ 'alternative-mail' ] . "\","
4000	. "\"".$object[ 'mobile' ] . "\","
4001	. "\"".$object[ 'business-phone' ] . "\","
4002	. "\"".$object[ 'business-address' ] . "\","
4003	. "\"".$object[ 'business-complement' ] . "\","
4004	. "\"".$object[ 'business-postal_code' ] . "\","
4005	. "\"".$object[ 'business-city_name' ] . "\","
4006	. "\"".$object[ 'business-state_name' ] . "\","
4007	. "\"".$object[ 'business-id_country' ] . "\","
4008	. "\"".$object[ 'home-phone' ] . "\","
4009	. "\"".$object[ 'home-address' ] . "\","
4010	. "\"".$object[ 'home-complement' ] . "\","
4011	. "\"".$object[ 'home-postal_code' ] . "\","
4012	. "\"".$object[ 'home-city_name' ] . "\","
4013	. "\"".$object[ 'home-state_name' ] . "\","
4014	. "\"".$object[ 'home-id_country' ] . "\","
4015	. "\"".$object[ 'birthdate' ] . "\","
4016	. "\"".$object[ 'sex' ] . "\","
4017	. "\"".$object[ 'pgp_key' ] . "\","
4018	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
4019	. "\"".$object[ 'web_page' ] . "\","
4020	. "\"".$object[ 'corporate_name' ] . "\","
4021	. "\"".$object[ 'job_title' ] . "\","
4022	. "\"".$object[ 'department' ] . "\","
4023	. "\"".$object[ 'business-fax' ] . "\","
4024	. "\"".$object[ 'business-pager' ] . "\","
4025	. "\"".$object[ 'business-mobile' ] . "\","
4026	. "\"".$object[ 'home-fax' ] . "\","
4027	. "\"".$object[ 'home-pager' ] . "\","
4028	. "\"".$object[ 'business-address-2' ] . "\","
4029	. "\"".$object[ 'home-address-2' ] . "\"\r\n";
4030	}
4031	break;
4032
4033	}
4034
4035	$file = "contacts_".md5(microtime()).".swp";
4036	$tempDir = ini_get("session.save_path");
4037	$f = fopen($tempDir.'/'.$file,"w");
4038	if(!$f)
4039	echo null;
4040
4041	fputs($f,$streamBuffer);
4042	fclose($f);
4043
4044	echo $tempDir.'/'.$file;
4045	}
4046
4047	// Get the csv field and put into array, from php.net
4048	function parse_line($input_text, $delimiter = ',', $text_qualifier = '"') {
4049	$text = trim($input_text);
4050	if(is_string($delimiter) && is_string($text_qualifier)) {
4051	$re_d = '\x' . dechex(ord($delimiter)); //format for regexp
4052	$re_tq = '\x' . dechex(ord($text_qualifier)); //format for regexp
4053
4054	$fields = array();
4055	$field_num = 0;
4056	while(strlen($text) > 0) {
4057	if($text{0} == $text_qualifier) {
4058	preg_match('/^' . $re_tq . '((?:[^' . $re_tq . ']\|(?<=\x5c)' . $re_tq . '))' . $re_tq . $re_d . '?(.)$/', $text, $matches);
4059
4060	$value = str_replace('\\' . $text_qualifier, $text_qualifier, $matches[1]);
4061	$text = trim($matches[2]);
4062
4063	$fields[$field_num++] = $value;
4064	} else {
4065	preg_match('/^([^' . $re_d . '])' . $re_d . '?(.)$/', $text, $matches);
4066
4067	$value = $matches[1];
4068	$text = trim($matches[2]);
4069
4070	$fields[$field_num++] = $value;
4071	}
4072	}
4073	return $fields;
4074	} else
4075	return false;
4076	}
4077
4078	//funcao alterada para importar outros campos alem de nome, telefone e email, de arquivo csv (Outlook 2000)
4079	//em 08/04/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
4080	//Foi adicionada uma funcao (escapesheelcmd()) nas variaveis para que caracteres especiais sejam ignorados
4081	//durante a importacao dos contatos; o processo estava travando por causa de caracteres em campos como nome,
4082	//sobrenome, notas e e-mail;
4083	//em 19/06/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
4084	function import_contacts($typeImport, $id_group=false){
4085	$this->so_group = CreateObject('contactcenter.so_group');
4086	if($file = $_SESSION['contactcenter']['importCSV']) {
4087	unset($_SESSION['contactcenter']['importCSV']);
4088	$len = filesize($file);
4089	$count = 0;
4090	$return = array('error' => false, '_new' => 0, '_existing' => 0, '_failure' => 0);
4091	$handle = @fopen($file, "r") or die(serialize($return['error'] = true));
4092
4093	$input_header = fgets($handle);
4094	if ($typeImport == 'outlook')
4095	$delim = ';';
4096	else if ($typeImport == 'auto')
4097	$delim = strstr($input_header,',') ? ',' : ';';
4098	else
4099	$delim = ',';
4100	$csv_header = $this->parse_line($input_header,$delim);
4101	$firstContact = fgets($handle);
4102	preg_match("/\"(.+)\"[,;]/sU",$firstContact,$matches); // yahoo csv
4103	rewind($handle);
4104
4105	$header = @fgetcsv($handle, $len, $delim) or die(serialize($return['error'] = true));
4106	if(count($header) < 2 \|\| count($header) > 100) {
4107	$return['error'] = true;
4108	$return['sizeheader'] = count($header);
4109	echo serialize($return);
4110	return;
4111	}
4112
4113	if ($matches[0][strlen($matches[0])-1] == ';')
4114	$delim = ';';
4115
4116	$boGroup = CreateObject('contactcenter.bo_group');
4117	$boPeople = CreateObject('contactcenter.bo_people_catalog');
4118	switch($typeImport){
4119	case 'outlook2000':
4120	$name_pos=1;
4121	$name2_pos=2;
4122	$name3_pos=3;
4123	$corporate_street_pos=8;
4124	$cep_pos=13;
4125	$corporate_street_2_pos=22;
4126	$fax_pos=30;
4127	$phone_pos=31;
4128	$home_phone_pos=37;
4129	$personal_cell_pos=40;
4130	$pager_pos=43;
4131	$birth_pos=48;
4132	$notes_pos=49;
4133	$email_pos=56;
4134	$aditionalEmail_pos=59;
4135
4136	break;
4137	case 'outlook':
4138	$name_pos=3;
4139	$email_pos=4;
4140	$phone_pos=7;
4141	$home_phone_pos=10;
4142	$personal_cell_pos=12;
4143	$corporate_street_pos=13;
4144	$cep_pos=15;
4145	$phone_pos=18;
4146	$fax_pos=19;
4147	$pager_pos=20;
4148	$notes_pos=25;
4149	break;
4150	case 'thunderbird':
4151	$name_pos=2;
4152	$email_pos=4;
4153	$phone_pos=7;
4154	break;
4155	case 'expresso':
4156	$name_pos=0;
4157	$alias_pos=1;
4158	$email_pos=2;
4159	$aditionalEmail_pos=3;
4160	$personal_cell_pos=4;
4161	$corporate_phone_pos=5;
4162	$corporate_street_pos=6;
4163	$corporate_comp_pos=7;
4164	$corporate_cep_pos=8;
4165	$corporate_city_pos=9;
4166	$corporate_state_pos=10;
4167	$corporate_country_pos=11;
4168	$home_phone_pos=12;
4169	$street_pos=13;
4170	$comp_pos=14;
4171	$cep_pos=15;
4172	$city_pos=16;
4173	$state_pos=17;
4174	$country_pos=18;
4175	$birth_pos=19;
4176	$sex_pos = 20;
4177	$pgp_key_pos = 21;
4178	$notes_pos=22;
4179	$web_page_pos=23;
4180	$corporate_name_pos=24;
4181	$job_title_pos=25;
4182	$department_pos=26;
4183	$corporate_fax_pos=27;
4184	$corporate_pager_pos=28;
4185	$corporate_cell_pos=29;
4186	$fax_pos=30;
4187	$pager_pos=31;
4188	$corporate_street_2_pos = 32;
4189	$street_2_pos = 33;
4190	break;
4191	default:
4192	foreach($csv_header as $index => $fieldName)
4193	{
4194	switch($fieldName){
4195	case 'Name':
4196	case 'Nome':
4197	case 'First Name':
4198	$name_pos = $index;
4199	break;
4200	case 'Second name':
4201	case 'Segundo nome':
4202	$name2_pos = $index;
4203	break;
4204	case 'Sobrenome':
4205	case 'Surname':
4206	$name3_pos = $index;
4207	break;
4208	case 'Business Street':
4209	case 'Rua do endereço comercial':
4210	$corporate_street_pos = $index;
4211	break;
4212	case 'Rua do endereço comercial 2':
4213	case 'Outro endereço':
4214	$corporate_street_2_pos = $index;
4215	break;
4216	case 'Business Postal Code':
4217	case 'CEP do endereço comercial':
4218	$cep_pos = $index;
4219	break;
4220	case 'Business Fax':
4221	case 'Fax comercial':
4222	case 'Fax':
4223	$fax_pos = $index;
4224	break;
4225	case 'Home Phone':
4226	case 'Telefone residencial':
4227	$home_phone_pos = $index;
4228	break;
4229	case 'Mobile phone':
4230	case 'Telefone celular':
4231	$personal_cell_pos = $index;
4232	break;
4233	case 'Pager':
4234	$pager_pos = $index;
4235	break;
4236	case 'Phone':
4237	case 'Business Phone':
4238	case 'Telefone':
4239	case 'Telefone principal':
4240	case 'Telefone comercial':
4241	case 'Telefone Comercial':
4242	$phone_pos = $index;
4243	break;
4244	case 'Aniversário':
4245	case 'Birthdate':
4246	$birth_pos = $index;
4247	case 'Anotações':
4248	case 'Notes':
4249	$notes_pos = $index;
4250	case 'E-mail':
4251	case 'Email':
4252	case 'E-mail Address':
4253	case 'Endereço de correio eletrônico':
4254	case 'End. de email':
4255	$email_pos = $index;
4256	break;
4257	case 'Endereço de correio eletrônico 2':
4258	$aditionalEmail_pos = $index;
4259	break;
4260	}
4261	}
4262	break;
4263	}
4264
4265	while (($data = fgetcsv($handle, $len, $delim))) {
4266	foreach ($header as $key=>$heading)
4267	$row[$heading]=(isset($data[$key])) ? $data[$key] : '';
4268
4269	$sdata = array();
4270	$full_name = trim($row[$header[$name_pos]]);
4271	$email = trim($row[$header[$email_pos]]);
4272	$phone = trim($row[$header[$phone_pos]]);
4273	$name2 = trim($row[$header[$name2_pos]]);
4274	$name3 = trim($row[$header[$name3_pos]]);
4275
4276	$birth = trim($row[$header[$birth_pos]]);
4277	$notes = trim($row[$header[$notes_pos]]);
4278	$altEmail = trim($row[$header[$altEmail_pos]]);
4279	$sdata['alias'] = trim($row[$header[$alias_pos]]);
4280	$sdata['corporate_name'] = trim($row[$header[$corporate_name_pos]]);
4281	$sdata['job_title'] = trim($row[$header[$job_title_pos]]);
4282	$sdata['department'] = trim($row[$header[$department_pos]]);
4283	$sdata['web_page'] = trim($row[$header[$web_page_pos]]);
4284
4285	$sdata['sex'] = trim($row[$header[$sex_pos]]);
4286	$sdata['pgp_key'] = trim($row[$header[$pgp_key_pos]]);
4287
4288
4289	$full_name = $full_name;
4290	$array_name = explode(' ', str_replace('"','',(str_replace('\'','',$full_name))));
4291	$sdata['given_names'] = addslashes($array_name[0]);
4292	$array_name[0] = null;
4293	$sdata['family_names'] = trim(implode(' ',$array_name));
4294	if($sdata['family_names'] == '')
4295	{
4296	$sdata['family_names'] = addslashes($name2) . " " . addslashes($name3);
4297	}
4298
4299	$sdata['connections']['default_email']['connection_name'] = lang('Main');
4300	$sdata['connections']['default_email']['connection_value'] = addslashes($email);
4301	$sdata['connections']['aditional_email']['connection_name'] = "Alternativo";
4302	$sdata['connections']['aditional_email']['connection_value'] = trim($row[$header[$aditionalEmail_pos]]);
4303
4304	$sdata['connections']['default_phone']['connection_name'] = lang('Main');
4305	$sdata['connections']['default_phone']['connection_value'] = $phone;
4306
4307	if( trim($row[$header[$home_phone_pos]]) != "" )
4308	{
4309	$sdata['connections']['aditional_phone']['home_phone']['connection_name'] = 'Casa';
4310	$sdata['connections']['aditional_phone']['home_phone']['connection_value'] = trim($row[$header[$home_phone_pos]]);
4311	}
4312
4313	if( trim($row[$header[$personal_cell_pos]]) != "" )
4314	{
4315	$sdata['connections']['aditional_phone']['cellphone']['connection_name'] = 'Celular';
4316	$sdata['connections']['aditional_phone']['cellphone']['connection_value'] = trim($row[$header[$personal_cell_pos]]);
4317	}
4318
4319	if( trim($row[$header[$corporate_phone_pos]]) != "")
4320	{
4321	$sdata['connections']['aditional_phone']['corporate_phone']['connection_name'] = 'Trabalho';
4322	$sdata['connections']['aditional_phone']['corporate_phone']['connection_value'] = trim($row[$header[$corporate_phone_pos]]);
4323	}
4324
4325	if( trim($row[$header[$fax_pos]]) != "" )
4326	{
4327	$sdata['connections']['aditional_phone']['fax']['connection_name'] = 'Fax';
4328	$sdata['connections']['aditional_phone']['fax']['connection_value'] = trim($row[$header[$fax_pos]]);
4329	}
4330
4331	if ($GLOBALS['phpgw_info']['server']['personal_contact_type'] == 'True')
4332	{
4333	if( trim($row[$header[$pager_pos]]) != "" )
4334	{
4335	$sdata['connections']['aditional_phone']['pager']['connection_name'] = 'Pager';
4336	$sdata['connections']['aditional_phone']['pager']['connection_value'] = trim($row[$header[$pager_pos]]);
4337	}
4338
4339	if( trim($row[$header[$corporate_fax_pos]]) != "" )
4340	{
4341	$sdata['connections']['aditional_phone']['corporate_fax']['connection_name'] = 'Fax Corporativo';
4342	$sdata['connections']['aditional_phone']['corporate_fax']['connection_value'] = trim($row[$header[$corporate_fax_pos]]);
4343	}
4344
4345	if( trim($row[$header[$corporate_cell_pos]]) != "" )
4346	{
4347	$sdata['connections']['aditional_phone']['corporate_cell']['connection_name'] = 'Celular Corporativo';
4348	$sdata['connections']['aditional_phone']['corporate_cell']['connection_value'] = trim($row[$header[$corporate_cell_pos]]);
4349	}
4350
4351	if( trim($row[$header[$corporate_pager_pos]]) != "" )
4352	{
4353	$sdata['connections']['aditional_phone']['corporate_pager']['connection_name'] = 'Pager Corporativo';
4354	$sdata['connections']['aditional_phone']['corporate_pager']['connection_value'] = trim($row[$header[$corporate_pager_pos]]);
4355	}
4356	}
4357
4358	$sdata['addresses']['address_corporative']['address1'] = trim($row[$header[$corporate_street_pos]]);
4359	$sdata['addresses']['address_corporative']['address2'] = trim($row[$header[$corporate_street_2_pos]]);
4360	$sdata['addresses']['address_corporative']['complement'] = trim($row[$header[$corporate_comp_pos]]);
4361	$sdata['addresses']['address_corporative']['postal_code'] = trim($row[$header[$corporate_cep_pos]]);
4362	$sdata['addresses']['address_corporative']['id_country'] = "BR";
4363	$sdata['addresses']['address_corporative']['id_state'] = trim($row[$header[$corporate_state_pos]]);
4364	$sdata['addresses']['address_corporative']['id_city'] = trim($row[$header[$corporate_city_pos]]);
4365
4366
4367	$sdata['addresses']['address_personal']['address1'] = trim($row[$header[$street_pos]]);
4368	$sdata['addresses']['address_personal']['address2'] = trim($row[$header[$street_2_pos]]);
4369	$sdata['addresses']['address_personal']['complement'] = trim($row[$header[$comp_pos]]);
4370	$sdata['addresses']['address_personal']['postal_code'] = trim($row[$header[$cep_pos]]);
4371	$sdata['addresses']['address_personal']['id_country'] = "BR";
4372	$sdata['addresses']['address_personal']['id_state'] = trim($row[$header[$state_pos]]);
4373	$sdata['addresses']['address_personal']['id_city'] = trim($row[$header[$city_pos]]);
4374
4375	if(trim($birth)) {
4376	$array_birth = explode("/",trim($birth));
4377	$sdata['birthdate'] = date('Y-m-d', mktime(0,0,0,$array_birth[1],$array_birth[0],$array_birth[2]));
4378	}
4379
4380	$sdata['notes'] = addslashes($notes);
4381	//$sdata['is_quick_add'] = true;
4382	$sdata['connections']['default_phone']['connection_value'] = $phone;
4383
4384	// verifica se email já existe!
4385	$email = addslashes($email);
4386	$contact = $boGroup->verify_contact($email);
4387
4388	if(!$sdata['given_names'] && $email){
4389	$a_email = explode("@",$email);
4390	$sdata['given_names'] = addslashes($a_email[0]);
4391	}
4392
4393	$line_iteration = $return['_failure'] + $return['_existing'] + $return['_new'];
4394
4395	if($contact){
4396	$return['_existing']++;
4397	}
4398	else if((!eregi("^[/_a-z0-9-]+(\.[_a-z0-9-]+)@[a-z0-9-]+(\.[a-z0-9-]+)(\.[a-z]{2,3})$", $email)) && $email) {
4399	$return['_failure']++;
4400	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid E-Mail address: " . $email ."<br>";
4401	}
4402	else if (!$sdata['given_names'] \|\| !$boPeople ->quick_add($sdata)){
4403	$return['_failure']++;
4404	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid Name: " . $sdata['given_names'] ."<br>";
4405	}
4406	else{
4407	if($id_group != 0){
4408	$this->so_group->add_user_by_name($id_group,$full_name);
4409	}
4410	$return['_new']++;
4411	}
4412	}
4413	fclose($handle);
4414	unlink($file);
4415	}
4416	else
4417	$return['error'] = true;
4418
4419	echo serialize($return);
4420	}
4421	}
4422
4423	?>

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

Download in other formats: