Context Navigation

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

Revision 4753, 143.7 KB checked in by roberto.santosjunior, 13 years ago (diff)
Ticket #1820 - Mensagem incorreta ao adicionar grupo duplicado. r4598
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
2292	switch($field)
2293	{
2294	case 'names_ordered':
2295	$data[$field] = addslashes(rawurldecode($value));
2296	case 'corporate_name':
2297	case 'job_title':
2298	case 'department':
2299	case 'web_page':
2300	case 'alias':
2301	case 'given_names':
2302	case 'family_names':
2303	case 'pgp_key':
2304	case 'notes':
2305	$data[$field] = addslashes(rawurldecode($data[$field]));
2306	break;
2307
2308	case 'id_status':
2309	case 'id_prefix':
2310	case 'id_suffix':
2311	if ($data[$field] == 0)
2312	{
2313	unset($data[$field]);
2314	}
2315	break;
2316
2317	case 'birthdate_0':
2318	case 'birthdate_1':
2319	case 'birthdate_2':
2320	case 'birthdate':
2321
2322	if($field == 'birthdate'){
2323	$array_birth = explode("/",$data[$field]);
2324	$date['value'][2] = $array_birth[2];
2325	$date['value'][1] = $array_birth[1];
2326	$date['value'][0] = $array_birth[0];
2327	}else{
2328	switch($date[$datecount]['digit'])
2329	{
2330	case 'Y':
2331	$date['value'][2] = (int) $data[$field];
2332	break;
2333
2334	case 'M':
2335	$date['value'][0] = (int) $data[$field];
2336	break;
2337
2338	case 'D':
2339	$date['value'][1] = (int) $data[$field];
2340	break;
2341	}
2342	unset($data[$field]);
2343	}
2344
2345	$datecount++;
2346
2347	if ($datecount != 3)
2348	{
2349	break;
2350	}
2351
2352	if($date['value'][0] =='' && $date['value'][1] =='' && $date['value'][2] ==''){
2353	$data['birthdate'] = null;
2354	break;
2355	}
2356	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
2357	{
2358	echo serialize(array(
2359	'msg' => lang('Invalid Date'),
2360	'status' => 'invalid_data'
2361	));
2362	return;
2363	}
2364	if( $date['value'][2] != "" && $date['value'][0] != "" && $date['value'][1] != ""){
2365	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
2366	}
2367	break;
2368
2369	case 'sex':
2370	if ($data[$field] !== 'M' and $data[$field] !== 'F')
2371	{
2372	echo serialize(array(
2373	'msg' => lang('Invalid Sex'),
2374	'status' => 'invalid_data'
2375	));
2376	return;
2377	}
2378	break;
2379
2380
2381	case 'addresses':
2382	/* Insert new cities/states */
2383	if (isset($value['new_states']))
2384	{
2385	foreach($value['new_states'] as $type => $state_info)
2386	{
2387	$index = 'address'.$type;
2388
2389	$id_state = $this->bo->catalog->add_state($state_info);
2390	$data['addresses'][$index]['id_state'] = $id_state;
2391
2392	if ($value['new_cities'][$type])
2393	{
2394	$data[$field]['new_cities'][$type]['id_state'] = $id_state;
2395	}
2396	}
2397
2398	unset($data['addresses']['new_states']);
2399	}
2400
2401	if (isset($value['new_cities']))
2402	{
2403	foreach($value['new_cities'] as $type => $city_info)
2404	{
2405	$index = 'address'.$type;
2406
2407	$id_city = $this->bo->catalog->add_city($city_info);
2408	$data['addresses'][$index]['id_city'] = $id_city;
2409	}
2410
2411	unset($data['addresses']['new_cities']);
2412	}
2413
2414	break;
2415
2416	case 'birthdate':
2417	case 'connections':
2418	case 'photo':
2419	/* Does nothing... */
2420	break;
2421
2422	default:
2423	echo serialize(array(
2424	'msg' => lang('Invalid field: ').$field,
2425	'status' => 'invalid_data'
2426	));
2427	return;
2428	}
2429	}
2430
2431	if (!is_null($id) and $id !== '')
2432	{
2433	$id = $this->bo->catalog->update_single_info($id, $data);
2434	$result = array(
2435	'msg' => lang('Updated Successfully!'),
2436	'status' => 'ok'
2437	);
2438	}
2439	else
2440	{
2441	$id = $this->bo->catalog->add_single_entry($data);
2442	$result = array(
2443	'msg' => lang('Entry Added Successfully!'),
2444	'status' => 'ok'
2445	);
2446	}
2447
2448	if (!($id))
2449	{
2450	$result = array(
2451	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
2452	'Report the problem to the Administrator.'),
2453	'status' => 'fail'
2454	);
2455	}
2456
2457	echo serialize($result);
2458	}
2459
2460
2461	function post_full_add_shared()
2462	{
2463	$data = $_POST['data'];
2464	// Exceptions!!! utf8 special chars.
2465	$data = preg_replace("/\%u2(\d+)(\d+)(\d+)/","-",$data);
2466	$data = unserialize(str_replace('\\"', '"', $data));
2467	$this -> bo -> catalog = CreateObject('contactcenter.bo_shared_people_manager');
2468
2469	if (!is_array($data))
2470	{
2471	echo serialize(array(
2472	'msg' => lang('<p>Some problem receiving data from browser. This is probably a bug in ContactCenter<br>'.
2473	'Please go to eGroupWare Bug Reporting page and report this bug.<br>'.
2474	'Sorry for the inconvenient!<br><br>'.
2475	'<b><i>ContactCenter Developer Team</i></b></p>'),
2476	'status' => 'fatal'
2477	));
2478	return;
2479	}
2480	// print_r($data);
2481	// echo '<br><br>';
2482
2483	$replacer = $data['commercialAnd'];
2484	unset($data['commercialAnd']);
2485	if (!is_string($replacer) or strpos($replacer, "'") or strpos($replacer, '"'))
2486	{
2487	echo serialize(array(
2488	'msg' => lang('Invalid \'&\' replacer! This may be an attempt to bypass Security! Action aborted!'),
2489	'status' => 'fatal'
2490	));
2491
2492	return;
2493	}
2494
2495	if ($data['id_contact'])
2496	{
2497	$id = $data['id_contact'];
2498	$id_photo = $id;
2499	unset($data['id_contact']);
2500	}
2501	else
2502	{
2503	$id_photo = '_new_';
2504	}
2505
2506	if ($data['owner'])
2507	{
2508	$owner = $data['owner'];
2509	unset($data['owner']);
2510	}
2511	/*
2512	* Process Photo, if available
2513	*/
2514	$sleep_count = 0;
2515	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
2516	while($photo_ok[0]{0} !== 'o' and $photo_ok[1]{0} === 'y')
2517	{
2518	sleep(1);
2519	$photo_ok = $GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter');
2520	$sleep_count++;
2521
2522	if ($sleep_count > 35)
2523	{
2524	// TODO
2525	return;
2526	}
2527	}
2528	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'n'));
2529
2530	if (isset($this->page_info['photos'][$id_photo]))
2531	{
2532	if (array_search($this->page_info['photos'][$id_photo]['status'], array('changed', 'sync')) === false)
2533	{
2534	echo serialize(array(
2535	'msg' => $this->page_info['photos'][$id_photo]['msg'],
2536	'status' => $this->page_info['photos'][$id_photo]['status']
2537	));
2538
2539	return;
2540	}
2541
2542	$data['photo'] = $this->page_info['photos'][$id_photo]['content'];
2543	unset($this->page_info['photos'][$id_photo]);
2544	$this->save_session();
2545	}
2546
2547	/*
2548	* Arrange Date so it gets inserted correctly
2549	*/
2550
2551	$dateformat = $GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat'];
2552
2553	$j = 0;
2554	for ($i = 0; $i < 5; $i+=2)
2555	{
2556	switch($dateformat{$i})
2557	{
2558	case 'Y':
2559	$date[$j]['size'] = 4;
2560	$date[$j]['digit'] = 'Y';
2561	break;
2562
2563	case 'm':
2564	case 'M':
2565	$date[$j]['size'] = 2;
2566	$date[$j]['digit'] = 'M';
2567	break;
2568
2569	case 'd':
2570	$date[$j]['size'] = 2;
2571	$date[$j]['digit'] = 'D';
2572	}
2573	$j++;
2574	}
2575	$datecount = 0;
2576
2577	/* Verify Data and performs insertion/update */
2578	foreach($data as $field => &$value)
2579	{
2580	if ($value == '' or is_null($value))
2581	{
2582	unset($data[$field]);
2583	continue;
2584	}
2585
2586	switch($field)
2587	{
2588	case 'corporate_name':
2589	case 'job_title':
2590	case 'department':
2591	case 'web_page':
2592	case 'alias':
2593	case 'given_names':
2594	case 'family_names':
2595	case 'groups':
2596	$groups = $data['groups'];
2597	unset($data['groups']);
2598	break;
2599	case 'names_ordered':
2600	case 'pgp_key':
2601	case 'notes':
2602	case 'photo':
2603	$data[$field] = urldecode( $value );
2604	break;
2605
2606	case 'id_status':
2607	case 'id_prefix':
2608	case 'id_suffix':
2609	if ($data[$field] == 0)
2610	{
2611	unset($data[$field]);
2612	}
2613	break;
2614
2615	case 'birthdate_0':
2616	case 'birthdate_1':
2617	case 'birthdate_2':
2618
2619	switch($date[$datecount]['digit'])
2620	{
2621	case 'Y':
2622	$date['value'][2] = (int) $data[$field];
2623	break;
2624
2625	case 'M':
2626	$date['value'][0] = (int) $data[$field];
2627	break;
2628
2629	case 'D':
2630	$date['value'][1] = (int) $data[$field];
2631	break;
2632	}
2633	unset($data[$field]);
2634	$datecount++;
2635
2636	if ($datecount != 3)
2637	{
2638	break;
2639	}
2640
2641	if (!checkdate($date['value'][0], $date['value'][1], $date['value'][2]))
2642	{
2643	echo serialize(array(
2644	'msg' => lang('Invalid Date'),
2645	'status' => 'invalid_data'
2646	));
2647	return;
2648	}
2649
2650	$data['birthdate'] = $date['value'][2].'-'.$date['value'][0].'-'.$date['value'][1];
2651	break;
2652
2653	case 'sex':
2654	if ($data[$field] !== 'M' and $data[$field] !== 'F')
2655	{
2656	echo serialize(array(
2657	'msg' => lang('Invalid Sex'),
2658	'status' => 'invalid_data'
2659	));
2660	return;
2661	}
2662	break;
2663
2664
2665	case 'addresses':
2666	/* Insert new cities/states */
2667	if (isset($value['new_states']))
2668	{
2669	foreach($value['new_states'] as $type => $state_info)
2670	{
2671	$index = 'address'.$type;
2672
2673	$id_state = $this->bo->catalog->add_state($state_info);
2674	$data['addresses'][$index]['id_state'] = $id_state;
2675
2676	if ($value['new_cities'][$type])
2677	{
2678	$value['new_cities'][$type]['id_state'] = $id_state;
2679	}
2680	}
2681
2682	unset($data['addresses']['new_states']);
2683	}
2684
2685	if (isset($value['new_cities']))
2686	{
2687	foreach($value['new_cities'] as $type => $city_info)
2688	{
2689	$index = 'address'.$type;
2690
2691	$id_city = $this->bo->catalog->add_city($city_info);
2692	$data['addresses'][$index]['id_city'] = $id_city;
2693	}
2694
2695	unset($data['addresses']['new_cities']);
2696	}
2697
2698	break;
2699
2700	case 'connections':
2701	/* Does nothing... */
2702	break;
2703
2704	default:
2705	echo serialize(array(
2706	'msg' => lang('Invalid field: ').$field,
2707	'status' => 'invalid_data'
2708	));
2709	return;
2710	}
2711	}
2712
2713	$code = '$id = $this->bo->catalog->';
2714
2715	if (!is_null($id) and $id !== '')
2716	{
2717	$code .= $code.'update_single_info($id, $data);';
2718	$result = array(
2719	'msg' => lang('Updated Successfully!'),
2720	'status' => 'ok'
2721	);
2722	}
2723	else
2724	{
2725	$code .= 'add_single_entry($data,'.$owner.');';
2726	$result = array(
2727	'msg' => lang('Entry Added Successfully!'),
2728	'status' => 'ok'
2729	);
2730	}
2731
2732	eval($code);
2733
2734	if (!($id))
2735	{
2736	$result = array(
2737	'msg' => lang('Some problem occured when trying to insert/update contact information.<br>'.
2738	'Report the problem to the Administrator.'),
2739	'status' => 'fail'
2740	);
2741	}
2742
2743	echo serialize($result);
2744	}
2745	/*!
2746
2747	@function post_photo
2748	@abstract Wrapper to post a photo without reload a page.
2749	@author Raphael Derosso Pereira
2750
2751	*/
2752	function post_photo($id)
2753	{
2754	//print_r($_FILES);
2755	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('wait', 'y'));
2756
2757	if (!is_array($_FILES) and is_array(!$_FILES['cc_pd_photo']))
2758	{
2759	$this->page_info['photos'][$id]['status'] = 'no_upload';
2760	$this->page_info['photos'][$id]['msg'] = lang('No Photos uploaded to Server.');
2761
2762	$this->save_session();
2763	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2764	return;
2765	}
2766
2767	if (!function_exists('imagecreate'))
2768	{
2769	$this->page_info['photos'][$id]['status'] = 'no_GD_lib';
2770	$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.');
2771
2772	$this->save_session();
2773	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2774	return;
2775	}
2776
2777	// TODO: Get Max Size from preferences!
2778	if ($_FILES['cc_pd_photo']['size'] > 1000000)
2779	{
2780	$this->page_info['photos'][$id]['status'] = 'too_large';
2781	$this->page_info['photos'][$id]['msg'] = lang('Image too large! ContactCenter limits the image size to 1 Mb');
2782
2783	$this->save_session();
2784	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2785	return;
2786	}
2787
2788	if ($_FILES['cc_pd_photo']['error'])
2789	{
2790	$this->page_info['photos'][$id]['status'] = 'error';
2791	$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'];
2792
2793	$this->save_session();
2794	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2795	return;
2796	}
2797
2798	switch($_FILES['cc_pd_photo']['type'])
2799	{
2800	case 'image/jpeg':
2801	case 'image/pjpeg':
2802	$src_img = imagecreatefromjpeg($_FILES['cc_pd_photo']['tmp_name']);
2803	if ($src_img == '')
2804	{
2805	$bogus = true;
2806	}
2807	break;
2808
2809	case 'image/png':
2810	case 'image/x-png':
2811	$src_img = imagecreatefrompng($_FILES['cc_pd_photo']['tmp_name']);
2812	if ($src_img == '')
2813	{
2814	$bogus = true;
2815	}
2816	break;
2817
2818	case 'image/gif':
2819	$src_img = imagecreatefromgif($_FILES['cc_pd_photo']['tmp_name']);
2820	if ($src_img == '')
2821	{
2822	$bogus = true;
2823	}
2824	break;
2825
2826	default:
2827
2828	$this->page_info['photos'][$id]['status'] = 'invalid_image';
2829	$this->page_info['photos'][$id]['msg'] = lang('The file must be an JPEG, PNG or GIF Image.');
2830
2831	$this->save_session();
2832	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2833	return;
2834	}
2835
2836	if ($bogus)
2837	{
2838	$this->page_info['photos'][$id]['status'] = 'invalid_file';
2839	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
2840
2841	$this->save_session();
2842	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2843	return;
2844	}
2845
2846	$img_size = getimagesize($_FILES['cc_pd_photo']['tmp_name']);
2847	$dst_img = imagecreatetruecolor(60, 80);
2848
2849	if (!imagecopyresized($dst_img, $src_img, 0, 0, 0, 0, 60, 80, $img_size[0], $img_size[1]))
2850	{
2851	$this->page_info['photos'][$id]['status'] = 'invalid_file';
2852	$this->page_info['photos'][$id]['msg'] = lang('Couldn\'t open Image. It may be corrupted or internal library doesn\'t support this format.');
2853
2854	$this->save_session();
2855	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2856	return;
2857	}
2858
2859	ob_start();
2860	imagepng($dst_img);
2861	$this->page_info['photos'][$id]['content'] = ob_get_contents();
2862	ob_end_clean();
2863
2864	$this->page_info['photos'][$id]['status'] = 'changed';
2865	$this->page_info['photos'][$id]['msg'] = lang('Photo Successfully Updated!');
2866
2867	$this->save_session();
2868
2869	$GLOBALS['phpgw']->session->appsession('ui_data.photo','contactcenter', array('ok', 'y'));
2870
2871	imagedestroy($src_img);
2872	imagedestroy($dst_img);
2873	echo 'ok';
2874	return;
2875	}
2876
2877
2878	/*!
2879
2880	@function get_photo
2881	@abstract Returns the photo to the browser
2882	@author Raphael Derosso Pereira
2883
2884	*/
2885	function get_photo($id)
2886	{
2887	$fields = $this->bo->catalog->get_fields(false);
2888	$fields['photo'] = true;
2889
2890	$contact = $this->bo->catalog->get_single_entry($id, $fields);
2891
2892	if (!$contact['photo'])
2893	{
2894	header('Content-type: image/png');
2895	echo file_get_contents(PHPGW_INCLUDE_ROOT.'/contactcenter/templates/default/images/photo_celepar.png');
2896	return;
2897	}
2898
2899	header('Content-type: image/jpeg');
2900	$photo = imagecreatefromstring ($contact['photo']);
2901	$width = imagesx($photo);
2902	$height = imagesy($photo);
2903	$twidth = 70;
2904	$theight = 90;
2905	$small_photo = imagecreatetruecolor ($twidth, $theight);
2906	imagecopyresampled($small_photo, $photo, 0, 0, 0, 0,$twidth, $theight, $width, $height);
2907	imagejpeg($small_photo,"",100);
2908	return;
2909	}
2910
2911	/*!
2912
2913	@function get_states
2914	@abstract Echos a serialized array containing all the states for the given country
2915	@author Raphael Derosso Pereira
2916
2917	@params $id_country The ID of the Country that contains the requested states
2918
2919	*/
2920	function get_states($id_country)
2921	{
2922	$states = $this->bo->catalog->get_all_states($id_country);
2923
2924	if (!$states)
2925	{
2926	$result = array(
2927	'msg' => lang('No States found for this Country.'),
2928	'status' => 'empty'
2929	);
2930
2931	echo serialize($result);
2932	return;
2933	}
2934
2935	$result = array(
2936	'msg' => lang('States Successfully retrieved!'),
2937	'status' => 'ok'
2938	);
2939
2940	foreach ($states as $state_info)
2941	{
2942	$result['data'][$state_info['id_state']] = $state_info['name'];
2943
2944	if ($state_info['symbol'])
2945	{
2946	$result['data'][$state_info['id_state']] .= ', '.$state_info['symbol'];
2947	}
2948	}
2949
2950	echo serialize($result);
2951	}
2952
2953	/*!
2954
2955	@function get_cities
2956	@abstract Echos a serialized array containing all the cities of a given state
2957	@author Raphael Derosso Pereira
2958
2959	@param $id_country The ID of the Country that has the specified Cities (in case the
2960	Country doesn't have any States)
2961	@param $id_state The ID of the State that has the Cities requested
2962
2963	*/
2964	function get_cities($id_country, $id_state=false)
2965	{
2966	$cities = $this->bo->catalog->get_all_cities($id_country, $id_state);
2967
2968	if (!$cities)
2969	{
2970	$result = array(
2971	'msg' => lang('No Cities found for this State.'),
2972	'status' => 'empty'
2973	);
2974
2975	echo serialize($result);
2976	return;
2977	}
2978
2979	$result = array(
2980	'msg' => lang('Cities Successfully retrieved!'),
2981	'status' => 'ok'
2982	);
2983
2984	foreach ($cities as $city_info)
2985	{
2986	$result['data'][$city_info['id_city']] = $city_info['name'];
2987	}
2988
2989	echo serialize($result);
2990	}
2991
2992	//Traduz o campo na busca completa por entradas no catálogo do usuário.
2993	function aux_full_search ($field,$isldap) {
2994	$retorno = '';
2995	if($isldap) {
2996	switch($field) {
2997	case 'mail':
2998	$retorno = 'contact.connection.mail';
2999	break;
3000	case 'phone':
3001	$retorno = 'contact.connection.phone';
3002	break;
3003	}
3004	}
3005	else {
3006	switch($field) {
3007	case 'corporate':
3008	$retorno = 'contact.corporate_name';
3009	break;
3010	case 'mail':
3011	case 'phone':
3012	$retorno = 'contact.contact_connection.connection.connection_value';
3013	break;
3014	}
3015	}
3016	return $retorno;
3017	}
3018
3019	/*!
3020
3021	@function search
3022	@abstract Echos a serialized array containing the IDs
3023	of the entries that matches the search argument
3024	@author Raphael Derosso Pereira
3025	@author Mário César Kolling (external catalogs)
3026
3027	@param string $str_data A serialized array with two informations:
3028	$data = array(
3029	'search_for' => (string),
3030	'recursive' => (boolean),
3031	);
3032
3033	*/
3034	// SERPRO
3035	function search($str_data)
3036	{
3037	$data = unserialize($str_data);
3038	// It's an external catalog?
3039	$external = $this->bo->is_external($this->page_info['actual_catalog']);
3040	$full_search = isset($data['full_search'])?$data['full_search']:false;
3041
3042	if (!is_array($data) \|\| (!$data['search_for'] && !$full_search) \|\| !is_array($data['fields']))
3043	{
3044	echo serialize(array(
3045	'msg' => lang('Invalid parameters'),
3046	'status' => 'abort'
3047	));
3048
3049	return array('error' => lang('Invalid parameters'));
3050	}
3051
3052
3053	/*
3054	* TODO: look into the database to discover the database's encoding and convert the search_for field accordingly
3055	*/
3056	// Support search parameters with accentuation
3057	if ($this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
3058	/rev 104/
3059	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
3060	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
3061	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
3062	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
3063	/****/
3064	{
3065
3066	$data['search_for'] = utf8_encode($data['search_for']);
3067	}
3068
3069	$rules = array();
3070
3071	if ($data['search_for'] === '*')
3072	{
3073	$rules = array(
3074	0 => array(
3075	'field' => $data['fields']['search'],
3076	'type' => 'LIKE',
3077	'value' => '%'
3078	)
3079	);
3080	}
3081	else
3082	{
3083	$names = explode(' ', $data['search_for']);
3084
3085	if (!is_array($names))
3086	{
3087	if(!$full_search) {
3088	echo serialize(array(
3089	'msg' => lang('Invalid Search Parameter'),
3090	'status' => 'abort'
3091	));
3092	exit;
3093	}
3094	else
3095	$names = array();
3096
3097	}
3098
3099	if (!$external && $this->page_info['actual_catalog']['class'] != 'bo_people_catalog' &&
3100	/rev 104/
3101	//$this->page_info['actual_catalog']['class'] != 'bo_group_manager')
3102	$this->page_info['actual_catalog']['class'] != 'bo_group_manager' &&
3103	$this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' &&
3104	$this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager' )
3105	/*****/
3106	{
3107	/*
3108	* Restrict the returned contacts search to objectClass = phpgwAccount,
3109	* must have attibute phpgwAccountStatus, phpgwAccountVisible != -1
3110	*/
3111
3112	$rules = array(
3113	0 => array(
3114	'field' => 'contact.object_class',
3115	'type' => '=',
3116	'value' => 'phpgwAccount'
3117	),
3118	1 => array(
3119	'field' => 'contact.account_status',
3120	'type' => 'iLIKE',
3121	'value' => '%'
3122	),
3123	/rev 104/
3124	///
3125	//1 => array(
3126	2 => array(
3127	/*****/
3128	'field' => 'contact.account_visible',
3129	'type' => '!=',
3130	'value' => '-1'
3131	/rev 104/
3132	/* ),
3133	2 => array(
3134	'field' => 'contact.object_class',
3135	'type' => '=',
3136	'value' => 'inetOrgPerson'
3137	/****/
3138	),
3139	);
3140
3141	if($full_search) {
3142	foreach($full_search as $field => $value) {
3143	if(trim($value)!='')
3144	array_push($rules,array(
3145	'field' => $this->aux_full_search($field,true),
3146	'type' => 'LIKE',
3147	'value' => ''.$value.''
3148	));
3149	}
3150	}
3151
3152	}
3153	else if(!$external && $full_search) {
3154
3155	foreach($full_search as $field => $value) {
3156	if(trim($value)!='')
3157	array_push($rules,array(
3158	'field' => $this->aux_full_search($field,false),
3159	'type' => 'iLIKE',
3160	'value' => '%'.$value.'%'
3161	));
3162	}
3163
3164	}
3165
3166	foreach ($names as $name)
3167	{
3168	if ($name != '')
3169	{
3170	array_push($rules, array(
3171	'field' => $data['fields']['search'],
3172	'type' => 'iLIKE',
3173	'value' => '%'.$name.'%'
3174	));
3175	}
3176	}
3177	}
3178
3179	if ($external \|\| $this->page_info['actual_catalog']['class'] == 'bo_people_catalog' \|\|
3180	/rev 104/
3181	//$this->page_info['actual_catalog']['class'] == 'bo_group_manager')
3182	$this->page_info['actual_catalog']['class'] == 'bo_group_manager' \|\|
3183	$this->page_info['actual_catalog']['class'] == 'bo_shared_people_manager' \|\|
3184	$this->page_info['actual_catalog']['class'] == 'bo_shared_group_manager')
3185
3186
3187	/***/
3188	{
3189	// Get only this attributes: dn, cn for external catalogs,
3190	// used to restrict the attributes used in filters
3191	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'), $data['search_for'] != null);
3192	}
3193	else
3194	{
3195	// Get only this attributes: dn, cn, phpgwAccountType, objectClass, phpgwAccountStatus, phpghAccountVisible
3196	// for non-external catalogs, used to restrict the attributes used in filters
3197	$ids = $this->bo->find(array(
3198	$data['fields']['id'],
3199	$data['fields']['search'],
3200	'contact.object_class',
3201	//'contact.account_status',
3202	'contact.account_visible',
3203	'contact.connection.mail',
3204	'contact.connection.phone'
3205	), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'), $data['search_for_area'], $data['search_for'] != null );
3206	}
3207
3208	if (!is_array($ids) \|\| !count($ids))
3209	{
3210	$this->last_search_ids = null;
3211	$this->save_session();
3212	return null;
3213	}
3214
3215	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
3216
3217	$ids_f = array();
3218
3219	foreach ($ids as $e_info)
3220	{
3221	/rev 104/
3222	//$ids_f[] = $e_info[$id_field];
3223	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
3224	{
3225	$ids_f[] = $e_info[$id_field];
3226	} else{
3227	$ids_f[] = array(0=>$e_info[$id_field],1=>$e_info['perms'],2=>$e_info['owner']);
3228	}
3229	/****/
3230	}
3231
3232	return $ids_f;
3233	}
3234
3235	// CELEPAR
3236	/*
3237	function search($str_data)
3238	{
3239	$data = unserialize($str_data);
3240
3241	if (!is_array($data) \|\| !$data['search_for'] \|\| !is_array($data['fields']))
3242	{
3243	echo serialize(array(
3244	'msg' => lang('Invalid parameters'),
3245	'status' => 'abort'
3246	));
3247
3248	return;
3249	}
3250
3251	$rules = array();
3252
3253	if ($data['search_for'] === '*')
3254	{
3255	$rules = array(
3256	0 => array(
3257	'field' => $data['fields']['search'],
3258	'type' => 'LIKE',
3259	'value' => '%'
3260	)
3261	);
3262	}
3263	else
3264	{
3265	$names = explode(' ', $data['search_for']);
3266
3267	if (!is_array($names))
3268	{
3269	echo serialize(array(
3270	'msg' => lang('Invalid Search Parameter'),
3271	'status' => 'abort'
3272	));
3273
3274	return;
3275	}
3276
3277	foreach ($names as $name)
3278	{
3279	if ($name != '')
3280	{
3281	array_push($rules, array(
3282	'field' => $data['fields']['search'],
3283	'type' => 'iLIKE',
3284	'value' => '%'.$name.'%'
3285	));
3286	}
3287	}
3288	}
3289
3290
3291
3292	//$catalog = $this->bo->get_branch_by_level($this->bo->catalog_level[0]);
3293
3294	//if ($catalog['class'] === 'bo_people_catalog')
3295	//{
3296	// array_push($rules, array(
3297	// 'field' => 'contact.id_owner',
3298	// 'type' => '=',
3299	// 'value' => $GLOBALS['phpgw_info']['user']['account_id']
3300	// ));
3301	//}
3302
3303
3304	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'));
3305
3306	if (!is_array($ids) \|\| !count($ids))
3307	{
3308	echo serialize(array(
3309	'msg' => lang('No Entries Found!'),
3310	'status' => 'empty'
3311	));
3312
3313	return;
3314	}
3315	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
3316
3317	$ids_f = array();
3318	foreach ($ids as $e_info)
3319	{
3320	$ids_f[] = $e_info[$id_field];
3321	}
3322
3323	echo serialize(array(
3324	'data' => $ids_f,
3325	'msg' => lang('Found %1 Entries', count($ids)),
3326	'status' => 'ok'
3327	));
3328
3329	return;
3330	}*/
3331	/*!
3332
3333	@function get_multiple_entries
3334	@abstract Returns an array containing the specifiend data in the default
3335	CC UI format
3336	@author Raphael Derosso Pereira
3337
3338	@param array str_data A serialized array containing the ID's of the entries
3339	to be taken, the fields to be taken and the rules to be used on the
3340	retrieval:
3341	$data = array(
3342	'ids' => array(...),
3343	'fields' => array(...),
3344	'rules' => array(...)
3345	);
3346
3347	*/
3348	function get_multiple_entries($str_data)
3349	{
3350	$data = unserialize($str_data);
3351
3352	if (!is_array($data) or !count($data) or !count($data['fields']) or !count($data['ids']))
3353	{
3354	return array(
3355	'msg' => lang('Invalid Parameters'),
3356	'status' => 'abort'
3357	);
3358	}
3359
3360	$entries = $this->bo->catalog->get_multiple_entries($data['ids'], $data['fields']);
3361
3362	if (!is_array($entries) or !count($entries))
3363	{
3364	return array(
3365	'msg' => lang('No Entries Found!'),
3366	'status' => 'empty'
3367	);
3368	}
3369
3370	return array(
3371	'msg' => lang('Found %1 Entries!', count($entries)),
3372	'status' => 'ok',
3373	'data' => $entries
3374	);
3375	}
3376
3377	/*
3378
3379	@function get_all_entries
3380	@abstract Returns the specified fields for all catalog's entries
3381	in the default CC UI format
3382	@author Raphael Derosso Pereira
3383
3384	@params array str_data A serialized array containing the fields to
3385	be grabbed, the maximum number of entries to be returned and a
3386	boolean specifying if the calls refers to a new grab or to an
3387	unfinished one.
3388
3389	*/
3390	function get_all_entries($str_data)
3391	{
3392	$data = unserialize($str_data);
3393
3394	if (!is_array($data) or
3395	!count($data) or
3396	!count($data['fields']) or
3397	!$data['maxlength'] or
3398	(!$data['new'] and !$data['offset']))
3399	{
3400	return array(
3401	'msg' => lang('Invalid Parameters'),
3402	'status' => 'abort'
3403	);
3404	}
3405
3406	if ($data['new'])
3407	{
3408	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
3409
3410	$this->save_session();
3411
3412	if (!is_array($this->all_entries) or !count($this->all_entries))
3413	{
3414	return array(
3415	'msg' => lang('No Entries Found!'),
3416	'status' => 'empty'
3417	);
3418	}
3419
3420	$data['offset'] = 0;
3421	}
3422
3423	if ($data['maxlength'] != -1)
3424	{
3425	$result = $this->bo->catalog->get_multiple_entries(array_slice($this->all_entries, $data['offset'], $data['maxlength']), $data['fields']);
3426	}
3427	else
3428	{
3429	$result = $this->bo->catalog->get_multiple_entries($this->all_entries, $data['fields']);
3430	}
3431
3432	$jsCode = array();
3433	$count = 0;
3434	foreach ($result as $each)
3435	{
3436	if (!is_array($each))
3437	{
3438	continue;
3439	}
3440
3441	if($this-> typeContact == 'groups') {
3442
3443	foreach ($each as $field => $value) {
3444
3445	if ($field === 'title') {
3446	$optionName = '\\"'.$value.'\\"';
3447
3448	}
3449	else if ($field === 'short_name') {
3450
3451	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$optionName.' ('.$value.')", "'.$count.'");';
3452	$count++;
3453	}
3454	}
3455	}
3456
3457	else {
3458	foreach ($each as $field => $value) {
3459	if ($field === 'names_ordered') {
3460	if(is_array($value))
3461	$value = $value[0];
3462	$name = '\\"'.$value.'\\"';
3463	}
3464	else if ($field === 'connections') {
3465
3466	foreach ($value as $connection) {
3467	if ($connection['id_type'] == $this->preferences['personCardEmail']) {
3468	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$name.' <'.$connection['connection_value'].'>", "'.$count.'");';
3469	$count++;
3470	}
3471	}
3472	}
3473	}
3474	}
3475	}
3476
3477	$jsCodeFinal = implode("\n", $jsCode);
3478
3479	$nEntries = count($result);
3480
3481	if (!$nEntries)
3482	{
3483	return array(
3484	'msg' => lang('Error while getting user information...'),
3485	'status' => 'abort'
3486	);
3487	}
3488
3489	return array(
3490	'msg' => lang('Found %1 Entries!', $nEntries),
3491	'status' => 'ok',
3492	'typeContact' => $this -> typeContact,
3493	'final' => $nEntries + $data['offset'] < count($this->all_entries) ? false : true,
3494	'offset' => $data['offset'] + $nEntries,
3495	'data' => $jsCodeFinal
3496	);
3497	}
3498
3499	/*********************************************************************\
3500	* Auxiliar Methods *
3501	\*********************************************************************/
3502
3503	/*!
3504
3505	@function save_session
3506	@abstract Saves the data on the session
3507	@author Raphael Derosso Pereira
3508
3509	*/
3510	function save_session()
3511	{
3512	$GLOBALS['phpgw']->session->appsession('ui_data.page_info','contactcenter',$this->page_info);
3513	$GLOBALS['phpgw']->session->appsession('ui_data.all_entries','contactcenter',$this->all_entries);
3514	}
3515
3516	/*!
3517
3518	@function convert_tree
3519	@abstract Converts the tree array in the BO format to a JS tree array compatible
3520	with the one available in eGW
3521	@author Raphael Derosso Pereira
3522
3523	@param (array) $tree The tree in the BO format
3524	@param (string) $name The tree name
3525	@param (string) $iconDir The dir where the icons are
3526	@param (string) $parent The parent
3527	*/
3528
3529	function convert_tree($tree, &$iconDir, $parent='0')
3530	{
3531	// echo "Entrou<br>\tPai: $parent <br>";
3532	$rtree = array();
3533
3534	if ($parent === '0')
3535	{
3536	// echo 'Root!<br>';
3537	$rtree['0'] = array(
3538	'type' => 'catalog_group',
3539	'id' => '0',
3540	'pid' => 'none',
3541	'caption' => lang('Catalogues'),
3542	'class' => 'bo_catalog_group_catalog',
3543	'class_args' => array('_ROOT_', '$this', '$this->get_branch_by_level($this->catalog_level[0])')
3544	);
3545	}
3546
3547	foreach($tree as $id => $value)
3548	{
3549	// echo 'ID: '.$id.'<br>';
3550	$rtree[$parent.'.'.$id] = array(
3551	'type' => $value['type'],
3552	'id' => $parent.'.'.$id,
3553	'pid' => $parent,
3554	'caption' => $value['name']
3555	);
3556
3557	switch($value['type'])
3558	{
3559	case 'catalog_group':
3560	case 'mixed_catalog_group':
3561	$rtree = $rtree + $this->convert_tree($value['sub_branch'],$iconDir,$parent.'.'.$id);
3562	break;
3563	}
3564	}
3565
3566	if (count($rtree))
3567	{
3568	return $rtree;
3569	}
3570	}
3571
3572	function get_catalog_add_contact($id, $echo=true){
3573
3574	$array_participants = array();
3575	if(!$this->bo->catalog->src_info) {
3576	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3577	$this->bo->catalog->src_info = $ldap->srcs[1];
3578	}
3579
3580	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3581	$dn=$this->bo->catalog->src_info['dn'];
3582	$justThese = array("givenname","givenname","sn","telephonenumber","mail");
3583	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
3584	$info = ldap_get_entries($ds, $sr);
3585	for($z = 0; $z < 5; $z++) {
3586	$participant = $info[0][$justThese[$z]];
3587	array_push($array_participants, $participant);
3588	}
3589
3590	ldap_close($ds);
3591	if ($echo)
3592	{
3593	echo serialize($array_participants);
3594	}
3595	else
3596	{
3597	return serialize($array_participants);
3598	}
3599	}
3600
3601	function get_catalog_participants_group($id)
3602	{
3603	if(!$this->bo->catalog->src_info) {
3604	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3605	$this->bo->catalog->src_info = $ldap->srcs[1];
3606	}
3607	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3608	$justThese = array("description","memberuid");
3609	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
3610	$info = ldap_get_entries($ds, $sr);
3611	$member_uids = $info[0]['memberuid'];
3612	$contact['names_ordered'] = $info[0]['description'];
3613	$filter = "";
3614	for($z = 0; $z < count($member_uids); $z++) {
3615	if($member_uids[$z])
3616	$filter.="(uid=".$member_uids[$z].")";
3617	}
3618	$array_participants = array();
3619	if($filter) {
3620	$filter = "(\|".$filter.")";
3621	$valarray = explode(',',$id);
3622	array_shift($valarray);
3623	$dn = implode(',',$valarray);
3624	$justThese = array("cn","mail");
3625	$sr = ldap_search($ds,$dn, $filter,$justThese);
3626	$info = ldap_get_entries($ds, $sr);
3627	for($z = 0; $z < $info['count']; $z++) {
3628	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
3629	$array_emails[$info[$z]['mail'][0]] = null;
3630	array_push($array_participants, $participant);
3631	}
3632	ldap_close($ds);
3633	}
3634	sort($array_participants);
3635	$innerHTML = '';
3636	foreach($array_participants as $index => $participant){
3637	$innerHTML .= $participant;
3638	}
3639	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
3640	echo serialize($return);
3641	}
3642
3643	function get_catalog_participants_list($id)
3644	{
3645
3646	$fields = $this->bo->catalog->get_fields(false);
3647	$fields['names_ordered'] = true;
3648	$fields['mail_forwarding_address'] = true;
3649	$contact = $this->bo->catalog->get_single_entry($id,$fields);
3650
3651	$array_participants = array();
3652	$array_emails = array();
3653
3654	$filter = null;
3655	for($z = 0; $z < $contact['mail_forwarding_address']['count']; $z++) {
3656	if(strstr($contact['mail_forwarding_address'][$z],'@')) {
3657	$filter.="(mail=".$contact['mail_forwarding_address'][$z].")";
3658	$array_emails[$contact['mail_forwarding_address'][$z]] = "<font color=black>".$contact['mail_forwarding_address'][$z]."</font>";
3659	}
3660	else
3661	$array_participants[$z] = "<font color=red>".$contact['mail_forwarding_address'][$z]."</font>";
3662	}
3663
3664	if($filter) {
3665	$filter = "(\|".$filter.")";
3666	if(!$this->bo->catalog->src_info) {
3667	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3668	$this->bo->catalog->src_info = $ldap->srcs[1];
3669	}
3670	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3671	$dn=$this->bo->catalog->src_info['dn'];
3672	$justThese = array("cn","mail");
3673	$sr = ldap_search($ds,$dn, $filter,$justThese);
3674	$info = ldap_get_entries($ds, $sr);
3675	for($z = 0; $z < $info['count']; $z++) {
3676	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
3677	$array_emails[$info[$z]['mail'][0]] = null;
3678	array_push($array_participants, $participant);
3679	}
3680
3681	foreach($array_emails as $index => $email)
3682	if($email)
3683	array_push($array_participants, "      ".$email."<br>");
3684
3685	ldap_close($ds);
3686	}
3687	sort($array_participants);
3688	$innerHTML = '';
3689	foreach($array_participants as $index => $participant){
3690	$innerHTML .= $participant;
3691	}
3692	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
3693	echo serialize($return);
3694	}
3695
3696	function export_contacts($typeExport){
3697
3698	$boGroup = CreateObject('contactcenter.bo_group');
3699	$contacts = $boGroup->get_all_contacts();
3700	$streamBuffer = '';
3701
3702	if(!count($contacts))
3703	echo null;
3704
3705	switch($typeExport) {
3706
3707	case 'outlook_en':
3708	$streamBuffer = "Name;E-mail Address;Notes;Mobile Phone;Pager;Company;".
3709	"Job Title;Home Phone;Home Fax;Business Phone;Business Fax\r\n";
3710	foreach($contacts as $index => $object){
3711	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
3712	. "\"".$object[ 'main-mail' ] . "\";"
3713	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\";"
3714	. "\"".$object[ 'mobile' ] . "\";"
3715	. "\"".$object[ 'business-pager' ] . "\";"
3716	. "\"".$object[ 'corporate_name' ] . "\";"
3717	. "\"".$object[ 'job_title' ] . "\";"
3718	. "\"".$object[ 'home-phone' ] . "\";"
3719	. "\"".$object[ 'home-fax' ] . "\";"
3720	. "\"".$object[ 'business-phone' ] . "\";"
3721	. "\"".$object[ 'business-fax' ] . "\"\r\n";
3722	}
3723	break;
3724
3725	case 'outlook_pt-BR':
3726	$streamBuffer = "Nome;Sobrenome;Segundo nome;Nome;Apelido;End. de email;Endereço residencial;"
3727	."Cidade do endereço residencial;CEP do endereço residencial;Estado;País/região do endereço residencial;"
3728	."Telefone residencial;Fax residencial;Telefone celular;Página pessoal da Web;Rua do endereço comercial;"
3729	."Cidade do endereço comercial;CEP do endereço comercial;Estado do endereço comercial;"
3730	."País/região do endereço comercial;Página comercial da Web;Telefone comercial;Fax comercial;Pager;Empresa;"
3731	."Cargo;Departamento;End. comercial;Observações\r\n";
3732
3733	foreach($contacts as $index => $object){
3734	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
3735	.";;;"
3736	. "\"".$object[ 'alias' ] . "\";"
3737	. "\"".$object[ 'main-mail' ] . "\";"
3738	. "\"".$object[ 'home-address' ] . "\";"
3739	. "\"".$object[ 'home-city_name' ] . "\";"
3740	. "\"".$object[ 'home-postal_code' ] . "\";"
3741	. "\"".$object[ 'home-state_name' ] . "\";"
3742	. "\"".$object[ 'home-id_country' ] . "\";"
3743	. "\"".$object[ 'home-phone' ] . "\";"
3744	. "\"".$object[ 'home-fax' ] . "\";"
3745	. "\"".$object[ 'mobile' ] . "\";"
3746	. "\"".$object[ 'web_page' ] . "\";"
3747	. "\"".$object[ 'business-address' ] . "\";"
3748	. "\"".$object[ 'business-city_name' ] . "\";"
3749	. "\"".$object[ 'business-postal_code' ] . "\";"
3750	. "\"".$object[ 'business-state_name' ] . "\";"
3751	. "\"".$object[ 'business-id_country' ] . "\";"
3752	. "\"".$object[ 'web_page' ] . "\";"
3753	. "\"".$object[ 'business-phone' ] . "\";"
3754	. "\"".$object[ 'business-fax' ] . "\";"
3755	. "\"".$object[ 'business-pager' ] . "\";"
3756	. "\"".$object[ 'corporate_name' ] . "\";"
3757	. "\"".$object[ 'job_title' ] . "\";"
3758	. "\"".$object[ 'department' ] . "\";"
3759	.";"
3760	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\"\r\n";
3761	}
3762
3763	break;
3764
3765	case 'outlook2000_pt-BR':
3766	$streamBuffer = "\"Tratamento\",\"Nome\",\"Segundo Nome\",\"Sobrenome\",\"Sufixo\",".
3767	"\"Empresa\",\"Departamento\",\"Cargo\",\"Rua do endereço comercial\",\"Rua do endereço comercial 2\",".
3768	"\"Rua do endereço comercial 3\",\"Cidade do endereço comercial\",\"Estado do endereço comercial\",".
3769	"\"CEP do endereço comercial\",\"País do endereço comercial\",\"Endereço residencial\",\"Rua residencial 2\",".
3770	"\"Rua residencial 3\",\"Cidade do endereço residencial\",\"Estado\",\"CEP do endereço residencial\",\"País do endereço residencial\",".
3771	"\"Outro endereço\",\"Outro endereço 2\",\"Outro endereço 3\",\"Cidade\",\"Estado\",\"CEP\",\"País\",".
3772	"\"Telefone do assistente\",\"Fax comercial\",\"Telefone comercial\",\"Telefone comercial 2\",\"Retorno de chamada\",".
3773	"\"Telefone do carro\",\"Telefone principal da empresa\",\"Fax residencial\",\"Telefone residencial\",".
3774	"\"Telefone residencial 2\",\"ISDN\",\"Telefone celular\",\"Outro fax\",\"Outro telefone\",\"Pager\",\"Telefone principal\",".
3775	"\"Radiofone\",\"Telefone TTY/TDD\",\"Telex\",\"Aniversário\",\"Anotações\",\"Caixa postal\",\"Categorias\",".
3776	"\"Código da empresa\",\"Código do governo\",\"Cônjuge\",\"Conta\",\"Endereço de correio eletrônico\",".
3777	"\"Nome de exibição do correio eletr.\",\"Endereço de correio eletrônico 2\",".
3778	"\"Nome de exibição do correio eletr.2\",\"Endereço de correio eletrônico 3\",".
3779	"\"Nome de exibição do correio eletr.3\",\"Datas especiais\",\"Disponibilidade da Internet\",".
3780	"\"Filhos\",\"Hobby\",\"Idioma\",\"Indicação\",\"Informações para cobrança\",\"Iniciais\",\"Local\",".
3781	"\"Nome do assistente\",\"Nome do gerenciador\",\"Página da Web\",\"Palavras-chave\",\"Particular\",\"Personalizado 1\",\"Personalizado 2\",".
3782	"\"Personalizado 3\",\"Personalizado 4\",\"Prioridade\",\"Profissão\",\"Quilometragem\",\"Sala\",\"Sensibilidade\",\"Servidor de diretório\",".
3783	"\"Sexo\"\r\n";
3784
3785
3786
3787	foreach($contacts as $index => $object){
3788	$streamBuffer .= "\"".$object[ 'alias' ] . "\","
3789	. "\"".$object[ 'names_ordered' ] . "\","
3790	.",,,"
3791	. "\"".$object[ 'corporate_name' ] . "\","
3792	. "\"".$object[ 'department' ] . "\","
3793	. "\"".$object[ 'job_title' ] . "\","
3794	. "\"".$object[ 'business-address' ] . "\","
3795	. "\"".$object[ 'business-address-2' ] . "\","
3796	.","
3797	. "\"".$object[ 'business-city_name' ] . "\","
3798	. "\"".$object[ 'business-state' ] . "\","
3799	. "\"".$object[ 'business-postal_code' ] . "\","
3800	. "\"".$object[ 'business-id_country' ] . "\","
3801	. "\"".$object[ 'home-address' ] . "\","
3802	. "\"".$object[ 'home-address-2' ] . "\","
3803	.","
3804	. "\"".$object[ 'home-city_name' ] . "\","
3805	. "\"".$object[ 'home-state_name' ] . "\","
3806	. "\"".$object[ 'home-postal_code' ] . "\","
3807	. "\"".$object[ 'home-id_country' ] . "\","
3808	.",,,,,,,,"
3809	. "\"".$object[ 'business-fax' ] . "\","
3810	. "\"".$object[ 'business-phone' ] . "\","
3811	. "\"".$object[ 'business-mobile' ] . "\","
3812	.",,,"
3813	. "\"".$object[ 'home-fax' ] . "\","
3814	. "\"".$object[ 'home-phone' ] . "\","
3815	.",,"
3816	. "\"".$object[ 'mobile' ] . "\","
3817	.",,"
3818	. "\"".$object[ 'home-pager' ] . "\","
3819	. "\"".$object[ 'business-phone' ] . "\","
3820	.",,,"
3821	. "\"".$object[ 'birthdate' ] . "\","
3822	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
3823	.",,,,,,"
3824	. "\"".$object[ 'main-mail' ] . "\","
3825	.","
3826	. "\"".$object[ 'alternative-mail' ] . "\","
3827	.",,,,,,,,,,,,,,"
3828	. "\"".$object[ 'web_page' ] . "\","
3829	.",,,,,,,,,,,,"
3830	. "\"".$object[ 'sex' ] . "\"\r\n";
3831	}
3832	break;
3833
3834	case 'outlook2000_en':
3835	$streamBuffer = "Title,First Name,Middle Name,Last Name,Suffix,Company,Department,Job Title,".
3836	"Business Street,Business Street 2,Business Street 3,Business City,Business State,Business Postal Code,".
3837	"Business Country,Home Street,Home Street 2,Home Street 3,Home City,Home State,Home Postal Code,Home Country,".
3838	"Other Street,Other Street 2,Other Street 3,Other City,Other State,Other Postal Code,Other Country,".
3839	"Assistant's Phone,Business Fax,Business Phone,Business Phone 2,Callback,Car Phone,Company Main Phone,Home Fax,".
3840	"Home Phone,Home Phone 2,ISDN,Mobile Phone,Other Fax,Other Phone,Pager,Primary Phone,Radio Phone,TTY/TDD Phone,Telex,".
3841	"Account,Anniversary,Assistant's Name,Billing Information,Birthday,Categories,Children,Directory Server,E-mail Address,".
3842	"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,".
3843	"Gender,Government ID Number,Hobby,Initials,Internet Free Busy,Keywords,Language,Location,Manager's Name,Mileage,Notes,".
3844	"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";
3845
3846	foreach($contacts as $index => $object)
3847	{
3848	if( array_key_exists("phone", $object) )
3849	$phone = $object['phone'];
3850	else
3851	$phone = $object['business-phone'];
3852
3853	$streamBuffer.= "\"".$object[ 'alias' ] . "\","
3854	. "\"".$object[ 'names_ordered'] . "\","
3855	.",,,"
3856	. "\"".$object[ 'corporate_name' ] . "\","
3857	. "\"".$object[ 'department' ] . "\","
3858	. "\"".$object[ 'job_title' ] . "\","
3859	. "\"".$object[ 'business-address' ] . "\","
3860	. "\"".$object[ 'business-address-2' ] . "\","
3861	.","
3862	. "\"".$object[ 'business-city_name' ] . "\","
3863	. "\"".$object[ 'business-state' ] . "\","
3864	. "\"".$object[ 'business-postal_code' ] . "\","
3865	. "\"".$object[ 'business-id_country' ] . "\","
3866	. "\"".$object[ 'home-address' ] . "\","
3867	. "\"".$object[ 'home-address-2' ] . "\","
3868	.","
3869	. "\"".$object[ 'home-city_name' ] . "\","
3870	. "\"".$object[ 'home-state_name' ] . "\","
3871	. "\"".$object[ 'home-postal_code' ] . "\","
3872	. "\"".$object[ 'home-id_country' ] . "\","
3873	.",,,,,,,,"
3874	. "\"".$object[ 'business-fax' ] . "\","
3875	. "\"".$phone . "\","
3876	. "\"".$object[ 'business-mobile' ] . "\","
3877	.",,,"
3878	. "\"".$object[ 'home-fax' ] . "\","
3879	. "\"".$object[ 'home-phone' ] . "\","
3880	.",,"
3881	. "\"".$object[ 'mobile' ] . "\","
3882	.",,"
3883	. "\"".$object[ 'business-pager' ] . "\","
3884	. "\"".$object[ 'home-pager' ] . "\","
3885	.",,,,,,,,"
3886	. "\"".$object[ 'birthdate' ] . "\","
3887	.",,,"
3888	. "\"".$object[ 'main-mail' ] . "\","
3889	.",,"
3890	. "\"".$object[ 'alternative-mail' ] . "\","
3891	.",,,,,,,,,,,,,,,"
3892	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
3893	.",,,,,,,,,,,,,"
3894	. "\"".$object[ 'web_page' ] . "\"\r\n";
3895
3896	}
3897	break;
3898
3899	case 'thunderbird':
3900	$streamBuffer = "First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,"
3901	."Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,"
3902	."Home Address 2,Home City,Home State,Home ZipCode,Home Country,Work Address,Work Address 2,"
3903	."Work City,Work State,Work ZipCode,Work Country,Job Title,Department,Organization,Web Page 1,"
3904	."Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,\n";
3905
3906	foreach($contacts as $index => $object){
3907	$array_birth = explode("-",$object[ 'birthdate' ]);
3908	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\","
3909	.",,"
3910	. "\"".$object[ 'alias' ] . "\","
3911	. "\"".$object[ 'main-mail' ] . "\","
3912	. "\"".$object[ 'alternative-mail' ] . "\","
3913	.","
3914	. "\"".$phone . "\","
3915	. "\"".$object[ 'home-phone' ] . "\","
3916	. "\"".$object[ 'business-fax' ] . "\","
3917	. "\"".$object[ 'business-pager' ] . "\","
3918	. "\"".$object[ 'mobile' ] . "\","
3919	. "\"".$object[ 'home-address' ] . "\","
3920	. "\"".$object[ 'home-address-2' ] . "\","
3921	. "\"".$object[ 'home-city_name' ] . "\","
3922	. "\"".$object[ 'home-state_name' ] . "\","
3923	. "\"".$object[ 'home-postal_code' ] . "\","
3924	. "\"".$object[ 'home-id_country' ] . "\","
3925	. "\"".$object[ 'business-address' ] . "\","
3926	. "\"".$object[ 'business-address-2' ] . "\","
3927	. "\"".$object[ 'business-city_name' ] . "\","
3928	. "\"".$object[ 'business-state_name' ] . "\","
3929	. "\"".$object[ 'business-postal_code' ] . "\","
3930	. "\"".$object[ 'business-id_country' ] . "\","
3931	. "\"".$object[ 'job_title' ] . "\","
3932	. "\"".$object[ 'department' ] . "\","
3933	. "\"".$object[ 'corporate_name' ] . "\","
3934	. "\"".$object[ 'web_page' ] . "\","
3935	. "\"".$object[ 'web_page' ] . "\","
3936	. "\"".$array_birth[0] . "\","
3937	. "\"".$array_birth[1] . "\","
3938	. "\"".$array_birth[2] . "\","
3939	.",,,,"
3940	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\",\r\n";
3941
3942	}
3943	break;
3944
3945	case 'expresso':
3946	$streamBuffer = 'Nome,Apelido,E-mail Principal,E-mail Alternativo,Celular,'
3947	. 'Telefone Comercial,Endereço Comercial,Complemento End. Comercial,CEP Comercial,Cidade End. Comercial,Estado End. Comercial,País End. Comercial,'
3948	. 'Telefone Residencial,Endereço Residencial,Complemento End. Residencial,CEP Residencial,Cidade End. Residencial,Estado End. Residencial,País End. Residencial,'
3949	. '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'
3950	. "\r\n";
3951
3952	foreach($contacts as $index => $object){
3953	$streamBuffer .= "\"".$object[ 'names_ordered'] . "\","
3954	. "\"".$object[ 'alias' ] . "\","
3955	. "\"".$object[ 'main-mail' ] . "\","
3956	. "\"".$object[ 'alternative-mail' ] . "\","
3957	. "\"".$object[ 'mobile' ] . "\","
3958	. "\"".$object[ 'business-phone' ] . "\","
3959	. "\"".$object[ 'business-address' ] . "\","
3960	. "\"".$object[ 'business-complement' ] . "\","
3961	. "\"".$object[ 'business-postal_code' ] . "\","
3962	. "\"".$object[ 'business-city_name' ] . "\","
3963	. "\"".$object[ 'business-state_name' ] . "\","
3964	. "\"".$object[ 'business-id_country' ] . "\","
3965	. "\"".$object[ 'home-phone' ] . "\","
3966	. "\"".$object[ 'home-address' ] . "\","
3967	. "\"".$object[ 'home-complement' ] . "\","
3968	. "\"".$object[ 'home-postal_code' ] . "\","
3969	. "\"".$object[ 'home-city_name' ] . "\","
3970	. "\"".$object[ 'home-state_name' ] . "\","
3971	. "\"".$object[ 'home-id_country' ] . "\","
3972	. "\"".$object[ 'birthdate' ] . "\","
3973	. "\"".$object[ 'sex' ] . "\","
3974	. "\"".$object[ 'pgp_key' ] . "\","
3975	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
3976	. "\"".$object[ 'web_page' ] . "\","
3977	. "\"".$object[ 'corporate_name' ] . "\","
3978	. "\"".$object[ 'job_title' ] . "\","
3979	. "\"".$object[ 'department' ] . "\","
3980	. "\"".$object[ 'business-fax' ] . "\","
3981	. "\"".$object[ 'business-pager' ] . "\","
3982	. "\"".$object[ 'business-mobile' ] . "\","
3983	. "\"".$object[ 'home-fax' ] . "\","
3984	. "\"".$object[ 'home-pager' ] . "\","
3985	. "\"".$object[ 'business-address-2' ] . "\","
3986	. "\"".$object[ 'home-address-2' ] . "\"\r\n";
3987	}
3988	break;
3989
3990	}
3991
3992	$file = "contacts_".md5(microtime()).".swp";
3993	$tempDir = ini_get("session.save_path");
3994	$f = fopen($tempDir.'/'.$file,"w");
3995	if(!$f)
3996	echo null;
3997
3998	fputs($f,$streamBuffer);
3999	fclose($f);
4000
4001	echo $tempDir.'/'.$file;
4002	}
4003
4004	// Get the csv field and put into array, from php.net
4005	function parse_line($input_text, $delimiter = ',', $text_qualifier = '"') {
4006	$text = trim($input_text);
4007	if(is_string($delimiter) && is_string($text_qualifier)) {
4008	$re_d = '\x' . dechex(ord($delimiter)); //format for regexp
4009	$re_tq = '\x' . dechex(ord($text_qualifier)); //format for regexp
4010
4011	$fields = array();
4012	$field_num = 0;
4013	while(strlen($text) > 0) {
4014	if($text{0} == $text_qualifier) {
4015	preg_match('/^' . $re_tq . '((?:[^' . $re_tq . ']\|(?<=\x5c)' . $re_tq . '))' . $re_tq . $re_d . '?(.)$/', $text, $matches);
4016
4017	$value = str_replace('\\' . $text_qualifier, $text_qualifier, $matches[1]);
4018	$text = trim($matches[2]);
4019
4020	$fields[$field_num++] = $value;
4021	} else {
4022	preg_match('/^([^' . $re_d . '])' . $re_d . '?(.)$/', $text, $matches);
4023
4024	$value = $matches[1];
4025	$text = trim($matches[2]);
4026
4027	$fields[$field_num++] = $value;
4028	}
4029	}
4030	return $fields;
4031	} else
4032	return false;
4033	}
4034
4035	//funcao alterada para importar outros campos alem de nome, telefone e email, de arquivo csv (Outlook 2000)
4036	//em 08/04/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
4037	//Foi adicionada uma funcao (escapesheelcmd()) nas variaveis para que caracteres especiais sejam ignorados
4038	//durante a importacao dos contatos; o processo estava travando por causa de caracteres em campos como nome,
4039	//sobrenome, notas e e-mail;
4040	//em 19/06/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
4041	function import_contacts($typeImport, $id_group=false){
4042	$this->so_group = CreateObject('contactcenter.so_group');
4043	if($file = $_SESSION['contactcenter']['importCSV']) {
4044	unset($_SESSION['contactcenter']['importCSV']);
4045	$len = filesize($file);
4046	$count = 0;
4047	$return = array('error' => false, '_new' => 0, '_existing' => 0, '_failure' => 0);
4048	$handle = @fopen($file, "r") or die(serialize($return['error'] = true));
4049
4050	$input_header = fgets($handle);
4051	if ($typeImport == 'outlook')
4052	$delim = ';';
4053	else if ($typeImport == 'auto')
4054	$delim = strstr($input_header,',') ? ',' : ';';
4055	else
4056	$delim = ',';
4057	$csv_header = $this->parse_line($input_header,$delim);
4058	$firstContact = fgets($handle);
4059	preg_match("/\"(.+)\"[,;]/sU",$firstContact,$matches); // yahoo csv
4060	rewind($handle);
4061
4062	$header = @fgetcsv($handle, $len, $delim) or die(serialize($return['error'] = true));
4063	if(count($header) < 2 \|\| count($header) > 100) {
4064	$return['error'] = true;
4065	$return['sizeheader'] = count($header);
4066	echo serialize($return);
4067	return;
4068	}
4069
4070	if ($matches[0][strlen($matches[0])-1] == ';')
4071	$delim = ';';
4072
4073	$boGroup = CreateObject('contactcenter.bo_group');
4074	$boPeople = CreateObject('contactcenter.bo_people_catalog');
4075	switch($typeImport){
4076	case 'outlook2000':
4077	$name_pos=1;
4078	$name2_pos=2;
4079	$name3_pos=3;
4080	$corporate_street_pos=8;
4081	$cep_pos=13;
4082	$corporate_street_2_pos=22;
4083	$fax_pos=30;
4084	$phone_pos=31;
4085	$home_phone_pos=37;
4086	$personal_cell_pos=40;
4087	$pager_pos=43;
4088	$birth_pos=48;
4089	$notes_pos=49;
4090	$email_pos=56;
4091	$aditionalEmail_pos=59;
4092
4093	break;
4094	case 'outlook':
4095	$name_pos=3;
4096	$email_pos=4;
4097	$phone_pos=7;
4098	$home_phone_pos=10;
4099	$personal_cell_pos=12;
4100	$corporate_street_pos=13;
4101	$cep_pos=15;
4102	$phone_pos=18;
4103	$fax_pos=19;
4104	$pager_pos=20;
4105	$notes_pos=25;
4106	break;
4107	case 'thunderbird':
4108	$name_pos=2;
4109	$email_pos=4;
4110	$phone_pos=7;
4111	break;
4112	case 'expresso':
4113	$name_pos=0;
4114	$alias_pos=1;
4115	$email_pos=2;
4116	$aditionalEmail_pos=3;
4117	$personal_cell_pos=4;
4118	$corporate_phone_pos=5;
4119	$corporate_street_pos=6;
4120	$corporate_comp_pos=7;
4121	$corporate_cep_pos=8;
4122	$corporate_city_pos=9;
4123	$corporate_state_pos=10;
4124	$corporate_country_pos=11;
4125	$home_phone_pos=12;
4126	$street_pos=13;
4127	$comp_pos=14;
4128	$cep_pos=15;
4129	$city_pos=16;
4130	$state_pos=17;
4131	$country_pos=18;
4132	$birth_pos=19;
4133	$sex_pos = 20;
4134	$pgp_key_pos = 21;
4135	$notes_pos=22;
4136	$web_page_pos=23;
4137	$corporate_name_pos=24;
4138	$job_title_pos=25;
4139	$department_pos=26;
4140	$corporate_fax_pos=27;
4141	$corporate_pager_pos=28;
4142	$corporate_cell_pos=29;
4143	$fax_pos=30;
4144	$pager_pos=31;
4145	$corporate_street_2_pos = 32;
4146	$street_2_pos = 33;
4147	break;
4148	default:
4149	foreach($csv_header as $index => $fieldName)
4150	{
4151	switch($fieldName){
4152	case 'Name':
4153	case 'Nome':
4154	case 'First Name':
4155	$name_pos = $index;
4156	break;
4157	case 'Second name':
4158	case 'Segundo nome':
4159	$name2_pos = $index;
4160	break;
4161	case 'Sobrenome':
4162	case 'Surname':
4163	$name3_pos = $index;
4164	break;
4165	case 'Business Street':
4166	case 'Rua do endereço comercial':
4167	$corporate_street_pos = $index;
4168	break;
4169	case 'Rua do endereço comercial 2':
4170	case 'Outro endereço':
4171	$corporate_street_2_pos = $index;
4172	break;
4173	case 'Business Postal Code':
4174	case 'CEP do endereço comercial':
4175	$cep_pos = $index;
4176	break;
4177	case 'Business Fax':
4178	case 'Fax comercial':
4179	case 'Fax':
4180	$fax_pos = $index;
4181	break;
4182	case 'Home Phone':
4183	case 'Telefone residencial':
4184	$home_phone_pos = $index;
4185	break;
4186	case 'Mobile phone':
4187	case 'Telefone celular':
4188	$personal_cell_pos = $index;
4189	break;
4190	case 'Pager':
4191	$pager_pos = $index;
4192	break;
4193	case 'Phone':
4194	case 'Business Phone':
4195	case 'Telefone':
4196	case 'Telefone principal':
4197	case 'Telefone comercial':
4198	case 'Telefone Comercial':
4199	$phone_pos = $index;
4200	break;
4201	case 'Aniversário':
4202	case 'Birthdate':
4203	$birth_pos = $index;
4204	case 'Anotações':
4205	case 'Notes':
4206	$notes_pos = $index;
4207	case 'E-mail':
4208	case 'Email':
4209	case 'E-mail Address':
4210	case 'Endereço de correio eletrônico':
4211	case 'End. de email':
4212	$email_pos = $index;
4213	break;
4214	case 'Endereço de correio eletrônico 2':
4215	$aditionalEmail_pos = $index;
4216	break;
4217	}
4218	}
4219	break;
4220	}
4221
4222	while (($data = fgetcsv($handle, $len, $delim))) {
4223	foreach ($header as $key=>$heading)
4224	$row[$heading]=(isset($data[$key])) ? $data[$key] : '';
4225
4226	$sdata = array();
4227	$full_name = trim($row[$header[$name_pos]]);
4228	$email = trim($row[$header[$email_pos]]);
4229	$phone = trim($row[$header[$phone_pos]]);
4230	$name2 = trim($row[$header[$name2_pos]]);
4231	$name3 = trim($row[$header[$name3_pos]]);
4232
4233	$birth = trim($row[$header[$birth_pos]]);
4234	$notes = trim($row[$header[$notes_pos]]);
4235	$altEmail = trim($row[$header[$altEmail_pos]]);
4236	$sdata['alias'] = trim($row[$header[$alias_pos]]);
4237	$sdata['corporate_name'] = trim($row[$header[$corporate_name_pos]]);
4238	$sdata['job_title'] = trim($row[$header[$job_title_pos]]);
4239	$sdata['department'] = trim($row[$header[$department_pos]]);
4240	$sdata['web_page'] = trim($row[$header[$web_page_pos]]);
4241
4242	$sdata['sex'] = trim($row[$header[$sex_pos]]);
4243	$sdata['pgp_key'] = trim($row[$header[$pgp_key_pos]]);
4244
4245
4246	$full_name = $full_name;
4247	$array_name = explode(' ', str_replace('"','',(str_replace('\'','',$full_name))));
4248	$sdata['given_names'] = addslashes($array_name[0]);
4249	$array_name[0] = null;
4250	$sdata['family_names'] = trim(implode(' ',$array_name));
4251	if($sdata['family_names'] == '')
4252	{
4253	$sdata['family_names'] = addslashes($name2) . " " . addslashes($name3);
4254	}
4255
4256	$sdata['connections']['default_email']['connection_name'] = lang('Main');
4257	$sdata['connections']['default_email']['connection_value'] = addslashes($email);
4258	$sdata['connections']['aditional_email']['connection_name'] = "Alternativo";
4259	$sdata['connections']['aditional_email']['connection_value'] = trim($row[$header[$aditionalEmail_pos]]);
4260
4261	$sdata['connections']['default_phone']['connection_name'] = lang('Main');
4262	$sdata['connections']['default_phone']['connection_value'] = $phone;
4263
4264	if( trim($row[$header[$home_phone_pos]]) != "" )
4265	{
4266	$sdata['connections']['aditional_phone']['home_phone']['connection_name'] = 'Casa';
4267	$sdata['connections']['aditional_phone']['home_phone']['connection_value'] = trim($row[$header[$home_phone_pos]]);
4268	}
4269
4270	if( trim($row[$header[$personal_cell_pos]]) != "" )
4271	{
4272	$sdata['connections']['aditional_phone']['cellphone']['connection_name'] = 'Celular';
4273	$sdata['connections']['aditional_phone']['cellphone']['connection_value'] = trim($row[$header[$personal_cell_pos]]);
4274	}
4275
4276	if( trim($row[$header[$corporate_phone_pos]]) != "")
4277	{
4278	$sdata['connections']['aditional_phone']['corporate_phone']['connection_name'] = 'Trabalho';
4279	$sdata['connections']['aditional_phone']['corporate_phone']['connection_value'] = trim($row[$header[$corporate_phone_pos]]);
4280	}
4281
4282	if( trim($row[$header[$fax_pos]]) != "" )
4283	{
4284	$sdata['connections']['aditional_phone']['fax']['connection_name'] = 'Fax';
4285	$sdata['connections']['aditional_phone']['fax']['connection_value'] = trim($row[$header[$fax_pos]]);
4286	}
4287
4288	if ($GLOBALS['phpgw_info']['server']['personal_contact_type'] == 'True')
4289	{
4290	if( trim($row[$header[$pager_pos]]) != "" )
4291	{
4292	$sdata['connections']['aditional_phone']['pager']['connection_name'] = 'Pager';
4293	$sdata['connections']['aditional_phone']['pager']['connection_value'] = trim($row[$header[$pager_pos]]);
4294	}
4295
4296	if( trim($row[$header[$corporate_fax_pos]]) != "" )
4297	{
4298	$sdata['connections']['aditional_phone']['corporate_fax']['connection_name'] = 'Fax Corporativo';
4299	$sdata['connections']['aditional_phone']['corporate_fax']['connection_value'] = trim($row[$header[$corporate_fax_pos]]);
4300	}
4301
4302	if( trim($row[$header[$corporate_cell_pos]]) != "" )
4303	{
4304	$sdata['connections']['aditional_phone']['corporate_cell']['connection_name'] = 'Celular Corporativo';
4305	$sdata['connections']['aditional_phone']['corporate_cell']['connection_value'] = trim($row[$header[$corporate_cell_pos]]);
4306	}
4307
4308	if( trim($row[$header[$corporate_pager_pos]]) != "" )
4309	{
4310	$sdata['connections']['aditional_phone']['corporate_pager']['connection_name'] = 'Pager Corporativo';
4311	$sdata['connections']['aditional_phone']['corporate_pager']['connection_value'] = trim($row[$header[$corporate_pager_pos]]);
4312	}
4313	}
4314
4315	$sdata['addresses']['address_corporative']['address1'] = trim($row[$header[$corporate_street_pos]]);
4316	$sdata['addresses']['address_corporative']['address2'] = trim($row[$header[$corporate_street_2_pos]]);
4317	$sdata['addresses']['address_corporative']['complement'] = trim($row[$header[$corporate_comp_pos]]);
4318	$sdata['addresses']['address_corporative']['postal_code'] = trim($row[$header[$corporate_cep_pos]]);
4319	$sdata['addresses']['address_corporative']['id_country'] = "BR";
4320	$sdata['addresses']['address_corporative']['id_state'] = trim($row[$header[$corporate_state_pos]]);
4321	$sdata['addresses']['address_corporative']['id_city'] = trim($row[$header[$corporate_city_pos]]);
4322
4323
4324	$sdata['addresses']['address_personal']['address1'] = trim($row[$header[$street_pos]]);
4325	$sdata['addresses']['address_personal']['address2'] = trim($row[$header[$street_2_pos]]);
4326	$sdata['addresses']['address_personal']['complement'] = trim($row[$header[$comp_pos]]);
4327	$sdata['addresses']['address_personal']['postal_code'] = trim($row[$header[$cep_pos]]);
4328	$sdata['addresses']['address_personal']['id_country'] = "BR";
4329	$sdata['addresses']['address_personal']['id_state'] = trim($row[$header[$state_pos]]);
4330	$sdata['addresses']['address_personal']['id_city'] = trim($row[$header[$city_pos]]);
4331
4332	if(trim($birth)) {
4333	$array_birth = explode("/",trim($birth));
4334	$sdata['birthdate'] = date('Y-m-d', mktime(0,0,0,$array_birth[1],$array_birth[0],$array_birth[2]));
4335	}
4336
4337	$sdata['notes'] = addslashes($notes);
4338	//$sdata['is_quick_add'] = true;
4339	$sdata['connections']['default_phone']['connection_value'] = $phone;
4340
4341	// verifica se email já existe!
4342	$email = addslashes($email);
4343	$contact = $boGroup->verify_contact($email);
4344
4345	if(!$sdata['given_names'] && $email){
4346	$a_email = explode("@",$email);
4347	$sdata['given_names'] = addslashes($a_email[0]);
4348	}
4349
4350	$line_iteration = $return['_failure'] + $return['_existing'] + $return['_new'];
4351
4352	if($contact){
4353	$return['_existing']++;
4354	}
4355	else if((!eregi("^[/_a-z0-9-]+(\.[_a-z0-9-]+)@[a-z0-9-]+(\.[a-z0-9-]+)(\.[a-z]{2,3})$", $email)) && $email) {
4356	$return['_failure']++;
4357	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid E-Mail address: " . $email ."<br>";
4358	}
4359	else if (!$sdata['given_names'] \|\| !$boPeople ->quick_add($sdata)){
4360	$return['_failure']++;
4361	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid Name: " . $sdata['given_names'] ."<br>";
4362	}
4363	else{
4364	if($id_group != 0){
4365	$this->so_group->add_user_by_name($id_group,$full_name);
4366	}
4367	$return['_new']++;
4368	}
4369	}
4370	fclose($handle);
4371	unlink($file);
4372	}
4373	else
4374	$return['error'] = true;
4375
4376	echo serialize($return);
4377	}
4378	}
4379
4380	?>

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

Download in other formats: