Context Navigation

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

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

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

Download in other formats: