Context Navigation

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

Revision 4806, 145.5 KB checked in by roberto.santosjunior, 13 years ago (diff)
Ticket #1820 - Erro na exibição de contatos no Catálogo Expresso.r4669
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	));
3229	}
3230	}
3231	}
3232
3233	if ($external \|\| $this->page_info['actual_catalog']['class'] == 'bo_people_catalog' \|\|
3234	/rev 104/
3235	//$this->page_info['actual_catalog']['class'] == 'bo_group_manager')
3236	$this->page_info['actual_catalog']['class'] == 'bo_group_manager' \|\|
3237	$this->page_info['actual_catalog']['class'] == 'bo_shared_people_manager' \|\|
3238	$this->page_info['actual_catalog']['class'] == 'bo_shared_group_manager')
3239
3240
3241	/***/
3242	{
3243	// Get only this attributes: dn, cn for external catalogs,
3244	// used to restrict the attributes used in filters
3245	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'), $data['search_for'] != null);
3246	}
3247	else
3248	{
3249	// Get only this attributes: dn, cn, phpgwAccountType, objectClass, phpgwAccountStatus, phpghAccountVisible
3250	// for non-external catalogs, used to restrict the attributes used in filters
3251	$ids = $this->bo->find(array(
3252	$data['fields']['id'],
3253	$data['fields']['search'],
3254	'contact.object_class',
3255	//'contact.account_status',
3256	'contact.account_visible',
3257	'contact.connection.mail',
3258	'contact.connection.phone'
3259	), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'), $data['search_for_area'], $data['search_for'] != null );
3260	}
3261
3262	if (!is_array($ids) \|\| !count($ids))
3263	{
3264	$this->last_search_ids = null;
3265	$this->save_session();
3266	return null;
3267	}
3268
3269	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
3270
3271	$ids_f = array();
3272
3273	foreach ($ids as $e_info)
3274	{
3275	/rev 104/
3276	//$ids_f[] = $e_info[$id_field];
3277	if($this->page_info['actual_catalog']['class'] != 'bo_shared_people_manager' && $this->page_info['actual_catalog']['class'] != 'bo_shared_group_manager')
3278	{
3279	$ids_f[] = $e_info[$id_field];
3280	} else{
3281	$ids_f[] = array(0=>$e_info[$id_field],1=>$e_info['perms'],2=>$e_info['owner']);
3282	}
3283	/****/
3284	}
3285
3286	return $ids_f;
3287	}
3288
3289	// CELEPAR
3290	/*
3291	function search($str_data)
3292	{
3293	$data = unserialize($str_data);
3294
3295	if (!is_array($data) \|\| !$data['search_for'] \|\| !is_array($data['fields']))
3296	{
3297	echo serialize(array(
3298	'msg' => lang('Invalid parameters'),
3299	'status' => 'abort'
3300	));
3301
3302	return;
3303	}
3304
3305	$rules = array();
3306
3307	if ($data['search_for'] === '*')
3308	{
3309	$rules = array(
3310	0 => array(
3311	'field' => $data['fields']['search'],
3312	'type' => 'LIKE',
3313	'value' => '%'
3314	)
3315	);
3316	}
3317	else
3318	{
3319	$names = explode(' ', $data['search_for']);
3320
3321	if (!is_array($names))
3322	{
3323	echo serialize(array(
3324	'msg' => lang('Invalid Search Parameter'),
3325	'status' => 'abort'
3326	));
3327
3328	return;
3329	}
3330
3331	foreach ($names as $name)
3332	{
3333	if ($name != '')
3334	{
3335	array_push($rules, array(
3336	'field' => $data['fields']['search'],
3337	'type' => 'iLIKE',
3338	'value' => '%'.$name.'%'
3339	));
3340	}
3341	}
3342	}
3343
3344
3345
3346	//$catalog = $this->bo->get_branch_by_level($this->bo->catalog_level[0]);
3347
3348	//if ($catalog['class'] === 'bo_people_catalog')
3349	//{
3350	// array_push($rules, array(
3351	// 'field' => 'contact.id_owner',
3352	// 'type' => '=',
3353	// 'value' => $GLOBALS['phpgw_info']['user']['account_id']
3354	// ));
3355	//}
3356
3357
3358	$ids = $this->bo->find(array($data['fields']['id'], $data['fields']['search']), $rules, array('order' => $data['fields']['search'], 'sort' => 'ASC'));
3359
3360	if (!is_array($ids) \|\| !count($ids))
3361	{
3362	echo serialize(array(
3363	'msg' => lang('No Entries Found!'),
3364	'status' => 'empty'
3365	));
3366
3367	return;
3368	}
3369	$id_field = substr($data['fields']['id'], strrpos($data['fields']['id'], '.')+1);
3370
3371	$ids_f = array();
3372	foreach ($ids as $e_info)
3373	{
3374	$ids_f[] = $e_info[$id_field];
3375	}
3376
3377	echo serialize(array(
3378	'data' => $ids_f,
3379	'msg' => lang('Found %1 Entries', count($ids)),
3380	'status' => 'ok'
3381	));
3382
3383	return;
3384	}*/
3385	/*!
3386
3387	@function get_multiple_entries
3388	@abstract Returns an array containing the specifiend data in the default
3389	CC UI format
3390	@author Raphael Derosso Pereira
3391
3392	@param array str_data A serialized array containing the ID's of the entries
3393	to be taken, the fields to be taken and the rules to be used on the
3394	retrieval:
3395	$data = array(
3396	'ids' => array(...),
3397	'fields' => array(...),
3398	'rules' => array(...)
3399	);
3400
3401	*/
3402	function get_multiple_entries($str_data)
3403	{
3404	$data = unserialize($str_data);
3405
3406	if (!is_array($data) or !count($data) or !count($data['fields']) or !count($data['ids']))
3407	{
3408	return array(
3409	'msg' => lang('Invalid Parameters'),
3410	'status' => 'abort'
3411	);
3412	}
3413
3414	$entries = $this->bo->catalog->get_multiple_entries($data['ids'], $data['fields']);
3415
3416	if (!is_array($entries) or !count($entries))
3417	{
3418	return array(
3419	'msg' => lang('No Entries Found!'),
3420	'status' => 'empty'
3421	);
3422	}
3423
3424	return array(
3425	'msg' => lang('Found %1 Entries!', count($entries)),
3426	'status' => 'ok',
3427	'data' => $entries
3428	);
3429	}
3430
3431	/*
3432
3433	@function get_all_entries
3434	@abstract Returns the specified fields for all catalog's entries
3435	in the default CC UI format
3436	@author Raphael Derosso Pereira
3437
3438	@params array str_data A serialized array containing the fields to
3439	be grabbed, the maximum number of entries to be returned and a
3440	boolean specifying if the calls refers to a new grab or to an
3441	unfinished one.
3442
3443	*/
3444	function get_all_entries($str_data)
3445	{
3446	$data = unserialize($str_data);
3447
3448	if (!is_array($data) or
3449	!count($data) or
3450	!count($data['fields']) or
3451	!$data['maxlength'] or
3452	(!$data['new'] and !$data['offset']))
3453	{
3454	return array(
3455	'msg' => lang('Invalid Parameters'),
3456	'status' => 'abort'
3457	);
3458	}
3459
3460	if ($data['new'])
3461	{
3462	$this->all_entries = $this->bo->catalog->get_all_entries_ids();
3463
3464	$this->save_session();
3465
3466	if (!is_array($this->all_entries) or !count($this->all_entries))
3467	{
3468	return array(
3469	'msg' => lang('No Entries Found!'),
3470	'status' => 'empty'
3471	);
3472	}
3473
3474	$data['offset'] = 0;
3475	}
3476
3477	if ($data['maxlength'] != -1)
3478	{
3479	$result = $this->bo->catalog->get_multiple_entries(array_slice($this->all_entries, $data['offset'], $data['maxlength']), $data['fields']);
3480	}
3481	else
3482	{
3483	$result = $this->bo->catalog->get_multiple_entries($this->all_entries, $data['fields']);
3484	}
3485
3486	$jsCode = array();
3487	$count = 0;
3488	foreach ($result as $each)
3489	{
3490	if (!is_array($each))
3491	{
3492	continue;
3493	}
3494
3495	if($this-> typeContact == 'groups') {
3496
3497	foreach ($each as $field => $value) {
3498
3499	if ($field === 'title') {
3500	$optionName = '\\"'.$value.'\\"';
3501
3502	}
3503	else if ($field === 'short_name') {
3504
3505	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$optionName.' ('.$value.')", "'.$count.'");';
3506	$count++;
3507	}
3508	}
3509	}
3510
3511	else {
3512	foreach ($each as $field => $value) {
3513	if ($field === 'names_ordered') {
3514	if(is_array($value))
3515	$value = $value[0];
3516	$name = '\\"'.$value.'\\"';
3517	}
3518	else if ($field === 'connections') {
3519
3520	foreach ($value as $connection) {
3521	if ($connection['id_type'] == $this->preferences['personCardEmail']) {
3522	$jsCode[] = '_this.entries.options[_this.entries.options.length] = new Option("'.$name.' <'.$connection['connection_value'].'>", "'.$count.'");';
3523	$count++;
3524	}
3525	}
3526	}
3527	}
3528	}
3529	}
3530
3531	$jsCodeFinal = implode("\n", $jsCode);
3532
3533	$nEntries = count($result);
3534
3535	if (!$nEntries)
3536	{
3537	return array(
3538	'msg' => lang('Error while getting user information...'),
3539	'status' => 'abort'
3540	);
3541	}
3542
3543	return array(
3544	'msg' => lang('Found %1 Entries!', $nEntries),
3545	'status' => 'ok',
3546	'typeContact' => $this -> typeContact,
3547	'final' => $nEntries + $data['offset'] < count($this->all_entries) ? false : true,
3548	'offset' => $data['offset'] + $nEntries,
3549	'data' => $jsCodeFinal
3550	);
3551	}
3552
3553	/*********************************************************************\
3554	* Auxiliar Methods *
3555	\*********************************************************************/
3556
3557	/*!
3558
3559	@function save_session
3560	@abstract Saves the data on the session
3561	@author Raphael Derosso Pereira
3562
3563	*/
3564	function save_session()
3565	{
3566	$GLOBALS['phpgw']->session->appsession('ui_data.page_info','contactcenter',$this->page_info);
3567	$GLOBALS['phpgw']->session->appsession('ui_data.all_entries','contactcenter',$this->all_entries);
3568	}
3569
3570	/*!
3571
3572	@function convert_tree
3573	@abstract Converts the tree array in the BO format to a JS tree array compatible
3574	with the one available in eGW
3575	@author Raphael Derosso Pereira
3576
3577	@param (array) $tree The tree in the BO format
3578	@param (string) $name The tree name
3579	@param (string) $iconDir The dir where the icons are
3580	@param (string) $parent The parent
3581	*/
3582
3583	function convert_tree($tree, &$iconDir, $parent='0')
3584	{
3585	// echo "Entrou<br>\tPai: $parent <br>";
3586	$rtree = array();
3587
3588	if ($parent === '0')
3589	{
3590	// echo 'Root!<br>';
3591	$rtree['0'] = array(
3592	'type' => 'catalog_group',
3593	'id' => '0',
3594	'pid' => 'none',
3595	'caption' => lang('Catalogues'),
3596	'class' => 'bo_catalog_group_catalog',
3597	'class_args' => array('_ROOT_', '$this', '$this->get_branch_by_level($this->catalog_level[0])')
3598	);
3599	}
3600
3601	foreach($tree as $id => $value)
3602	{
3603	// echo 'ID: '.$id.'<br>';
3604	$rtree[$parent.'.'.$id] = array(
3605	'type' => $value['type'],
3606	'id' => $parent.'.'.$id,
3607	'pid' => $parent,
3608	'caption' => $value['name']
3609	);
3610
3611	switch($value['type'])
3612	{
3613	case 'catalog_group':
3614	case 'mixed_catalog_group':
3615	$rtree = $rtree + $this->convert_tree($value['sub_branch'],$iconDir,$parent.'.'.$id);
3616	break;
3617	}
3618	}
3619
3620	if (count($rtree))
3621	{
3622	return $rtree;
3623	}
3624	}
3625
3626	function get_catalog_add_contact($id, $echo=true){
3627
3628	$array_participants = array();
3629	if(!$this->bo->catalog->src_info) {
3630	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3631	$this->bo->catalog->src_info = $ldap->srcs[1];
3632	}
3633
3634	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3635	$dn=$this->bo->catalog->src_info['dn'];
3636	$justThese = array("givenname","givenname","sn","telephonenumber","mail");
3637	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
3638	$info = ldap_get_entries($ds, $sr);
3639	for($z = 0; $z < 5; $z++) {
3640	$participant = $info[0][$justThese[$z]];
3641	array_push($array_participants, $participant);
3642	}
3643
3644	ldap_close($ds);
3645	if ($echo)
3646	{
3647	echo serialize($array_participants);
3648	}
3649	else
3650	{
3651	return serialize($array_participants);
3652	}
3653	}
3654
3655	function get_catalog_participants_group($id)
3656	{
3657	if(!$this->bo->catalog->src_info) {
3658	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3659	$this->bo->catalog->src_info = $ldap->srcs[1];
3660	}
3661	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3662	$justThese = array("description","memberuid");
3663	$sr = ldap_read($ds,$id, "objectClass=*",$justThese);
3664	$info = ldap_get_entries($ds, $sr);
3665	$member_uids = $info[0]['memberuid'];
3666	$contact['names_ordered'] = $info[0]['description'];
3667	$filter = "";
3668	for($z = 0; $z < count($member_uids); $z++) {
3669	if($member_uids[$z])
3670	$filter.="(uid=".$member_uids[$z].")";
3671	}
3672	$array_participants = array();
3673	if($filter) {
3674	$filter = "(\|".$filter.")";
3675	$valarray = explode(',',$id);
3676	array_shift($valarray);
3677	$dn = implode(',',$valarray);
3678	$justThese = array("cn","mail");
3679	$sr = ldap_search($ds,$dn, $filter,$justThese);
3680	$info = ldap_get_entries($ds, $sr);
3681	for($z = 0; $z < $info['count']; $z++) {
3682	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
3683	$array_emails[$info[$z]['mail'][0]] = null;
3684	array_push($array_participants, $participant);
3685	}
3686	ldap_close($ds);
3687	}
3688	sort($array_participants);
3689	$innerHTML = '';
3690	foreach($array_participants as $index => $participant){
3691	$innerHTML .= $participant;
3692	}
3693	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
3694	echo serialize($return);
3695	}
3696
3697	function get_catalog_participants_list($id)
3698	{
3699
3700	$fields = $this->bo->catalog->get_fields(false);
3701	$fields['names_ordered'] = true;
3702	$fields['mail_forwarding_address'] = true;
3703	$contact = $this->bo->catalog->get_single_entry($id,$fields);
3704
3705	$array_participants = array();
3706	$array_emails = array();
3707
3708	$filter = null;
3709	for($z = 0; $z < $contact['mail_forwarding_address']['count']; $z++) {
3710	if(strstr($contact['mail_forwarding_address'][$z],'@')) {
3711	$filter.="(mail=".$contact['mail_forwarding_address'][$z].")";
3712	$array_emails[$contact['mail_forwarding_address'][$z]] = "<font color=black>".$contact['mail_forwarding_address'][$z]."</font>";
3713	}
3714	else
3715	$array_participants[$z] = "<font color=red>".$contact['mail_forwarding_address'][$z]."</font>";
3716	}
3717
3718	if($filter) {
3719	$filter = "(\|".$filter.")";
3720	if(!$this->bo->catalog->src_info) {
3721	$ldap = CreateObject('contactcenter.bo_ldap_manager');
3722	$this->bo->catalog->src_info = $ldap->srcs[1];
3723	}
3724	$ds = $GLOBALS['phpgw']->common->ldapConnect($this->bo->catalog->src_info['host'], $this->bo->catalog->src_info['acc'], $this->bo->catalog->src_info['pw'], true);
3725	$dn=$this->bo->catalog->src_info['dn'];
3726	$justThese = array("cn","mail");
3727	$sr = ldap_search($ds,$dn, $filter,$justThese);
3728	$info = ldap_get_entries($ds, $sr);
3729	for($z = 0; $z < $info['count']; $z++) {
3730	$participant = '<font color=\'DARKBLUE\'>      "'.$info[$z]['cn'][0].'" <'.$info[$z]['mail'][0].'></font><br>';
3731	$array_emails[$info[$z]['mail'][0]] = null;
3732	array_push($array_participants, $participant);
3733	}
3734
3735	foreach($array_emails as $index => $email)
3736	if($email)
3737	array_push($array_participants, "      ".$email."<br>");
3738
3739	ldap_close($ds);
3740	}
3741	sort($array_participants);
3742	$innerHTML = '';
3743	foreach($array_participants as $index => $participant){
3744	$innerHTML .= $participant;
3745	}
3746	$return = array('size' => count($array_participants), 'names_ordered'=> $contact['names_ordered'], 'inner_html' => $innerHTML);
3747	echo serialize($return);
3748	}
3749
3750	function export_contacts($typeExport){
3751
3752	$boGroup = CreateObject('contactcenter.bo_group');
3753	$contacts = $boGroup->get_all_contacts();
3754	$streamBuffer = '';
3755
3756	if(!count($contacts))
3757	echo null;
3758
3759	switch($typeExport) {
3760
3761	case 'outlook_en':
3762	$streamBuffer = "Name;E-mail Address;Notes;Mobile Phone;Pager;Company;".
3763	"Job Title;Home Phone;Home Fax;Business Phone;Business Fax\r\n";
3764	foreach($contacts as $index => $object){
3765	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
3766	. "\"".$object[ 'main-mail' ] . "\";"
3767	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\";"
3768	. "\"".$object[ 'mobile' ] . "\";"
3769	. "\"".$object[ 'business-pager' ] . "\";"
3770	. "\"".$object[ 'corporate_name' ] . "\";"
3771	. "\"".$object[ 'job_title' ] . "\";"
3772	. "\"".$object[ 'home-phone' ] . "\";"
3773	. "\"".$object[ 'home-fax' ] . "\";"
3774	. "\"".$object[ 'business-phone' ] . "\";"
3775	. "\"".$object[ 'business-fax' ] . "\"\r\n";
3776	}
3777	break;
3778
3779	case 'outlook_pt-BR':
3780	$streamBuffer = "Nome;Sobrenome;Segundo nome;Nome;Apelido;End. de email;Endereço residencial;"
3781	."Cidade do endereço residencial;CEP do endereço residencial;Estado;País/região do endereço residencial;"
3782	."Telefone residencial;Fax residencial;Telefone celular;Página pessoal da Web;Rua do endereço comercial;"
3783	."Cidade do endereço comercial;CEP do endereço comercial;Estado do endereço comercial;"
3784	."País/região do endereço comercial;Página comercial da Web;Telefone comercial;Fax comercial;Pager;Empresa;"
3785	."Cargo;Departamento;End. comercial;Observações\r\n";
3786
3787	foreach($contacts as $index => $object){
3788	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\";"
3789	.";;;"
3790	. "\"".$object[ 'alias' ] . "\";"
3791	. "\"".$object[ 'main-mail' ] . "\";"
3792	. "\"".$object[ 'home-address' ] . "\";"
3793	. "\"".$object[ 'home-city_name' ] . "\";"
3794	. "\"".$object[ 'home-postal_code' ] . "\";"
3795	. "\"".$object[ 'home-state_name' ] . "\";"
3796	. "\"".$object[ 'home-id_country' ] . "\";"
3797	. "\"".$object[ 'home-phone' ] . "\";"
3798	. "\"".$object[ 'home-fax' ] . "\";"
3799	. "\"".$object[ 'mobile' ] . "\";"
3800	. "\"".$object[ 'web_page' ] . "\";"
3801	. "\"".$object[ 'business-address' ] . "\";"
3802	. "\"".$object[ 'business-city_name' ] . "\";"
3803	. "\"".$object[ 'business-postal_code' ] . "\";"
3804	. "\"".$object[ 'business-state_name' ] . "\";"
3805	. "\"".$object[ 'business-id_country' ] . "\";"
3806	. "\"".$object[ 'web_page' ] . "\";"
3807	. "\"".$object[ 'business-phone' ] . "\";"
3808	. "\"".$object[ 'business-fax' ] . "\";"
3809	. "\"".$object[ 'business-pager' ] . "\";"
3810	. "\"".$object[ 'corporate_name' ] . "\";"
3811	. "\"".$object[ 'job_title' ] . "\";"
3812	. "\"".$object[ 'department' ] . "\";"
3813	.";"
3814	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\"\r\n";
3815	}
3816
3817	break;
3818
3819	case 'outlook2000_pt-BR':
3820	$streamBuffer = "\"Tratamento\",\"Nome\",\"Segundo Nome\",\"Sobrenome\",\"Sufixo\",".
3821	"\"Empresa\",\"Departamento\",\"Cargo\",\"Rua do endereço comercial\",\"Rua do endereço comercial 2\",".
3822	"\"Rua do endereço comercial 3\",\"Cidade do endereço comercial\",\"Estado do endereço comercial\",".
3823	"\"CEP do endereço comercial\",\"País do endereço comercial\",\"Endereço residencial\",\"Rua residencial 2\",".
3824	"\"Rua residencial 3\",\"Cidade do endereço residencial\",\"Estado\",\"CEP do endereço residencial\",\"País do endereço residencial\",".
3825	"\"Outro endereço\",\"Outro endereço 2\",\"Outro endereço 3\",\"Cidade\",\"Estado\",\"CEP\",\"País\",".
3826	"\"Telefone do assistente\",\"Fax comercial\",\"Telefone comercial\",\"Telefone comercial 2\",\"Retorno de chamada\",".
3827	"\"Telefone do carro\",\"Telefone principal da empresa\",\"Fax residencial\",\"Telefone residencial\",".
3828	"\"Telefone residencial 2\",\"ISDN\",\"Telefone celular\",\"Outro fax\",\"Outro telefone\",\"Pager\",\"Telefone principal\",".
3829	"\"Radiofone\",\"Telefone TTY/TDD\",\"Telex\",\"Aniversário\",\"Anotações\",\"Caixa postal\",\"Categorias\",".
3830	"\"Código da empresa\",\"Código do governo\",\"Cônjuge\",\"Conta\",\"Endereço de correio eletrônico\",".
3831	"\"Nome de exibição do correio eletr.\",\"Endereço de correio eletrônico 2\",".
3832	"\"Nome de exibição do correio eletr.2\",\"Endereço de correio eletrônico 3\",".
3833	"\"Nome de exibição do correio eletr.3\",\"Datas especiais\",\"Disponibilidade da Internet\",".
3834	"\"Filhos\",\"Hobby\",\"Idioma\",\"Indicação\",\"Informações para cobrança\",\"Iniciais\",\"Local\",".
3835	"\"Nome do assistente\",\"Nome do gerenciador\",\"Página da Web\",\"Palavras-chave\",\"Particular\",\"Personalizado 1\",\"Personalizado 2\",".
3836	"\"Personalizado 3\",\"Personalizado 4\",\"Prioridade\",\"Profissão\",\"Quilometragem\",\"Sala\",\"Sensibilidade\",\"Servidor de diretório\",".
3837	"\"Sexo\"\r\n";
3838
3839
3840
3841	foreach($contacts as $index => $object){
3842	$streamBuffer .= "\"".$object[ 'alias' ] . "\","
3843	. "\"".$object[ 'names_ordered' ] . "\","
3844	.",,,"
3845	. "\"".$object[ 'corporate_name' ] . "\","
3846	. "\"".$object[ 'department' ] . "\","
3847	. "\"".$object[ 'job_title' ] . "\","
3848	. "\"".$object[ 'business-address' ] . "\","
3849	. "\"".$object[ 'business-address-2' ] . "\","
3850	.","
3851	. "\"".$object[ 'business-city_name' ] . "\","
3852	. "\"".$object[ 'business-state' ] . "\","
3853	. "\"".$object[ 'business-postal_code' ] . "\","
3854	. "\"".$object[ 'business-id_country' ] . "\","
3855	. "\"".$object[ 'home-address' ] . "\","
3856	. "\"".$object[ 'home-address-2' ] . "\","
3857	.","
3858	. "\"".$object[ 'home-city_name' ] . "\","
3859	. "\"".$object[ 'home-state_name' ] . "\","
3860	. "\"".$object[ 'home-postal_code' ] . "\","
3861	. "\"".$object[ 'home-id_country' ] . "\","
3862	.",,,,,,,,"
3863	. "\"".$object[ 'business-fax' ] . "\","
3864	. "\"".$object[ 'business-phone' ] . "\","
3865	. "\"".$object[ 'business-mobile' ] . "\","
3866	.",,,"
3867	. "\"".$object[ 'home-fax' ] . "\","
3868	. "\"".$object[ 'home-phone' ] . "\","
3869	.",,"
3870	. "\"".$object[ 'mobile' ] . "\","
3871	.",,"
3872	. "\"".$object[ 'home-pager' ] . "\","
3873	. "\"".$object[ 'business-phone' ] . "\","
3874	.",,,"
3875	. "\"".$object[ 'birthdate' ] . "\","
3876	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
3877	.",,,,,,"
3878	. "\"".$object[ 'main-mail' ] . "\","
3879	.","
3880	. "\"".$object[ 'alternative-mail' ] . "\","
3881	.",,,,,,,,,,,,,,"
3882	. "\"".$object[ 'web_page' ] . "\","
3883	.",,,,,,,,,,,,"
3884	. "\"".$object[ 'sex' ] . "\"\r\n";
3885	}
3886	break;
3887
3888	case 'outlook2000_en':
3889	$streamBuffer = "Title,First Name,Middle Name,Last Name,Suffix,Company,Department,Job Title,".
3890	"Business Street,Business Street 2,Business Street 3,Business City,Business State,Business Postal Code,".
3891	"Business Country,Home Street,Home Street 2,Home Street 3,Home City,Home State,Home Postal Code,Home Country,".
3892	"Other Street,Other Street 2,Other Street 3,Other City,Other State,Other Postal Code,Other Country,".
3893	"Assistant's Phone,Business Fax,Business Phone,Business Phone 2,Callback,Car Phone,Company Main Phone,Home Fax,".
3894	"Home Phone,Home Phone 2,ISDN,Mobile Phone,Other Fax,Other Phone,Pager,Primary Phone,Radio Phone,TTY/TDD Phone,Telex,".
3895	"Account,Anniversary,Assistant's Name,Billing Information,Birthday,Categories,Children,Directory Server,E-mail Address,".
3896	"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,".
3897	"Gender,Government ID Number,Hobby,Initials,Internet Free Busy,Keywords,Language,Location,Manager's Name,Mileage,Notes,".
3898	"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";
3899
3900	foreach($contacts as $index => $object)
3901	{
3902	if( array_key_exists("phone", $object) )
3903	$phone = $object['phone'];
3904	else
3905	$phone = $object['business-phone'];
3906
3907	$streamBuffer.= "\"".$object[ 'alias' ] . "\","
3908	. "\"".$object[ 'names_ordered'] . "\","
3909	.",,,"
3910	. "\"".$object[ 'corporate_name' ] . "\","
3911	. "\"".$object[ 'department' ] . "\","
3912	. "\"".$object[ 'job_title' ] . "\","
3913	. "\"".$object[ 'business-address' ] . "\","
3914	. "\"".$object[ 'business-address-2' ] . "\","
3915	.","
3916	. "\"".$object[ 'business-city_name' ] . "\","
3917	. "\"".$object[ 'business-state' ] . "\","
3918	. "\"".$object[ 'business-postal_code' ] . "\","
3919	. "\"".$object[ 'business-id_country' ] . "\","
3920	. "\"".$object[ 'home-address' ] . "\","
3921	. "\"".$object[ 'home-address-2' ] . "\","
3922	.","
3923	. "\"".$object[ 'home-city_name' ] . "\","
3924	. "\"".$object[ 'home-state_name' ] . "\","
3925	. "\"".$object[ 'home-postal_code' ] . "\","
3926	. "\"".$object[ 'home-id_country' ] . "\","
3927	.",,,,,,,,"
3928	. "\"".$object[ 'business-fax' ] . "\","
3929	. "\"".$phone . "\","
3930	. "\"".$object[ 'business-mobile' ] . "\","
3931	.",,,"
3932	. "\"".$object[ 'home-fax' ] . "\","
3933	. "\"".$object[ 'home-phone' ] . "\","
3934	.",,"
3935	. "\"".$object[ 'mobile' ] . "\","
3936	.",,"
3937	. "\"".$object[ 'business-pager' ] . "\","
3938	. "\"".$object[ 'home-pager' ] . "\","
3939	.",,,,,,,,"
3940	. "\"".$object[ 'birthdate' ] . "\","
3941	.",,,"
3942	. "\"".$object[ 'main-mail' ] . "\","
3943	.",,"
3944	. "\"".$object[ 'alternative-mail' ] . "\","
3945	.",,,,,,,,,,,,,,,"
3946	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
3947	.",,,,,,,,,,,,,"
3948	. "\"".$object[ 'web_page' ] . "\"\r\n";
3949
3950	}
3951	break;
3952
3953	case 'thunderbird':
3954	$streamBuffer = "First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,"
3955	."Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,"
3956	."Home Address 2,Home City,Home State,Home ZipCode,Home Country,Work Address,Work Address 2,"
3957	."Work City,Work State,Work ZipCode,Work Country,Job Title,Department,Organization,Web Page 1,"
3958	."Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,\n";
3959
3960	foreach($contacts as $index => $object){
3961	$array_birth = explode("-",$object[ 'birthdate' ]);
3962	$streamBuffer.= "\"".$object[ 'names_ordered'] . "\","
3963	.",,"
3964	. "\"".$object[ 'alias' ] . "\","
3965	. "\"".$object[ 'main-mail' ] . "\","
3966	. "\"".$object[ 'alternative-mail' ] . "\","
3967	.","
3968	. "\"".$phone . "\","
3969	. "\"".$object[ 'home-phone' ] . "\","
3970	. "\"".$object[ 'business-fax' ] . "\","
3971	. "\"".$object[ 'business-pager' ] . "\","
3972	. "\"".$object[ 'mobile' ] . "\","
3973	. "\"".$object[ 'home-address' ] . "\","
3974	. "\"".$object[ 'home-address-2' ] . "\","
3975	. "\"".$object[ 'home-city_name' ] . "\","
3976	. "\"".$object[ 'home-state_name' ] . "\","
3977	. "\"".$object[ 'home-postal_code' ] . "\","
3978	. "\"".$object[ 'home-id_country' ] . "\","
3979	. "\"".$object[ 'business-address' ] . "\","
3980	. "\"".$object[ 'business-address-2' ] . "\","
3981	. "\"".$object[ 'business-city_name' ] . "\","
3982	. "\"".$object[ 'business-state_name' ] . "\","
3983	. "\"".$object[ 'business-postal_code' ] . "\","
3984	. "\"".$object[ 'business-id_country' ] . "\","
3985	. "\"".$object[ 'job_title' ] . "\","
3986	. "\"".$object[ 'department' ] . "\","
3987	. "\"".$object[ 'corporate_name' ] . "\","
3988	. "\"".$object[ 'web_page' ] . "\","
3989	. "\"".$object[ 'web_page' ] . "\","
3990	. "\"".$array_birth[0] . "\","
3991	. "\"".$array_birth[1] . "\","
3992	. "\"".$array_birth[2] . "\","
3993	.",,,,"
3994	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\",\r\n";
3995
3996	}
3997	break;
3998
3999	case 'expresso':
4000	$streamBuffer = 'Nome,Apelido,E-mail Principal,E-mail Alternativo,Celular,'
4001	. 'Telefone Comercial,Endereço Comercial,Complemento End. Comercial,CEP Comercial,Cidade End. Comercial,Estado End. Comercial,País End. Comercial,'
4002	. 'Telefone Residencial,Endereço Residencial,Complemento End. Residencial,CEP Residencial,Cidade End. Residencial,Estado End. Residencial,País End. Residencial,'
4003	. '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'
4004	. "\r\n";
4005
4006	foreach($contacts as $index => $object){
4007	$streamBuffer .= "\"".$object[ 'names_ordered'] . "\","
4008	. "\"".$object[ 'alias' ] . "\","
4009	. "\"".$object[ 'main-mail' ] . "\","
4010	. "\"".$object[ 'alternative-mail' ] . "\","
4011	. "\"".$object[ 'mobile' ] . "\","
4012	. "\"".$object[ 'business-phone' ] . "\","
4013	. "\"".$object[ 'business-address' ] . "\","
4014	. "\"".$object[ 'business-complement' ] . "\","
4015	. "\"".$object[ 'business-postal_code' ] . "\","
4016	. "\"".$object[ 'business-city_name' ] . "\","
4017	. "\"".$object[ 'business-state_name' ] . "\","
4018	. "\"".$object[ 'business-id_country' ] . "\","
4019	. "\"".$object[ 'home-phone' ] . "\","
4020	. "\"".$object[ 'home-address' ] . "\","
4021	. "\"".$object[ 'home-complement' ] . "\","
4022	. "\"".$object[ 'home-postal_code' ] . "\","
4023	. "\"".$object[ 'home-city_name' ] . "\","
4024	. "\"".$object[ 'home-state_name' ] . "\","
4025	. "\"".$object[ 'home-id_country' ] . "\","
4026	. "\"".$object[ 'birthdate' ] . "\","
4027	. "\"".$object[ 'sex' ] . "\","
4028	. "\"".$object[ 'pgp_key' ] . "\","
4029	. "\"".str_replace("\r\n\x0a","\t",$object[ 'notes' ]) . "\","
4030	. "\"".$object[ 'web_page' ] . "\","
4031	. "\"".$object[ 'corporate_name' ] . "\","
4032	. "\"".$object[ 'job_title' ] . "\","
4033	. "\"".$object[ 'department' ] . "\","
4034	. "\"".$object[ 'business-fax' ] . "\","
4035	. "\"".$object[ 'business-pager' ] . "\","
4036	. "\"".$object[ 'business-mobile' ] . "\","
4037	. "\"".$object[ 'home-fax' ] . "\","
4038	. "\"".$object[ 'home-pager' ] . "\","
4039	. "\"".$object[ 'business-address-2' ] . "\","
4040	. "\"".$object[ 'home-address-2' ] . "\"\r\n";
4041	}
4042	break;
4043
4044	}
4045
4046	$file = "contacts_".md5(microtime()).".swp";
4047	$tempDir = ini_get("session.save_path");
4048	$f = fopen($tempDir.'/'.$file,"w");
4049	if(!$f)
4050	echo null;
4051
4052	fputs($f,$streamBuffer);
4053	fclose($f);
4054
4055	echo $tempDir.'/'.$file;
4056	}
4057
4058	// Get the csv field and put into array, from php.net
4059	function parse_line($input_text, $delimiter = ',', $text_qualifier = '"') {
4060	$text = trim($input_text);
4061	if(is_string($delimiter) && is_string($text_qualifier)) {
4062	$re_d = '\x' . dechex(ord($delimiter)); //format for regexp
4063	$re_tq = '\x' . dechex(ord($text_qualifier)); //format for regexp
4064
4065	$fields = array();
4066	$field_num = 0;
4067	while(strlen($text) > 0) {
4068	if($text{0} == $text_qualifier) {
4069	preg_match('/^' . $re_tq . '((?:[^' . $re_tq . ']\|(?<=\x5c)' . $re_tq . '))' . $re_tq . $re_d . '?(.)$/', $text, $matches);
4070
4071	$value = str_replace('\\' . $text_qualifier, $text_qualifier, $matches[1]);
4072	$text = trim($matches[2]);
4073
4074	$fields[$field_num++] = $value;
4075	} else {
4076	preg_match('/^([^' . $re_d . '])' . $re_d . '?(.)$/', $text, $matches);
4077
4078	$value = $matches[1];
4079	$text = trim($matches[2]);
4080
4081	$fields[$field_num++] = $value;
4082	}
4083	}
4084	return $fields;
4085	} else
4086	return false;
4087	}
4088
4089	//funcao alterada para importar outros campos alem de nome, telefone e email, de arquivo csv (Outlook 2000)
4090	//em 08/04/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
4091	//Foi adicionada uma funcao (escapesheelcmd()) nas variaveis para que caracteres especiais sejam ignorados
4092	//durante a importacao dos contatos; o processo estava travando por causa de caracteres em campos como nome,
4093	//sobrenome, notas e e-mail;
4094	//em 19/06/2009 - Rommel Cysne (rommel.cysne@serpro.gov.br);
4095	function import_contacts($typeImport, $id_group=false){
4096	$this->so_group = CreateObject('contactcenter.so_group');
4097	if($file = $_SESSION['contactcenter']['importCSV']) {
4098	unset($_SESSION['contactcenter']['importCSV']);
4099	$len = filesize($file);
4100	$count = 0;
4101	$return = array('error' => false, '_new' => 0, '_existing' => 0, '_failure' => 0);
4102	$handle = @fopen($file, "r") or die(serialize($return['error'] = true));
4103
4104	$input_header = fgets($handle);
4105	if ($typeImport == 'outlook')
4106	$delim = ';';
4107	else if ($typeImport == 'auto')
4108	$delim = strstr($input_header,',') ? ',' : ';';
4109	else
4110	$delim = ',';
4111	$csv_header = $this->parse_line($input_header,$delim);
4112	$firstContact = fgets($handle);
4113	preg_match("/\"(.+)\"[,;]/sU",$firstContact,$matches); // yahoo csv
4114	rewind($handle);
4115
4116	$header = @fgetcsv($handle, $len, $delim) or die(serialize($return['error'] = true));
4117	if(count($header) < 2 \|\| count($header) > 100) {
4118	$return['error'] = true;
4119	$return['sizeheader'] = count($header);
4120	echo serialize($return);
4121	return;
4122	}
4123
4124	if ($matches[0][strlen($matches[0])-1] == ';')
4125	$delim = ';';
4126
4127	$boGroup = CreateObject('contactcenter.bo_group');
4128	$boPeople = CreateObject('contactcenter.bo_people_catalog');
4129	switch($typeImport){
4130	case 'outlook2000':
4131	$name_pos=1;
4132	$name2_pos=2;
4133	$name3_pos=3;
4134	$corporate_street_pos=8;
4135	$cep_pos=13;
4136	$corporate_street_2_pos=22;
4137	$fax_pos=30;
4138	$phone_pos=31;
4139	$home_phone_pos=37;
4140	$personal_cell_pos=40;
4141	$pager_pos=43;
4142	$birth_pos=48;
4143	$notes_pos=49;
4144	$email_pos=56;
4145	$aditionalEmail_pos=59;
4146
4147	break;
4148	case 'outlook':
4149	$name_pos=3;
4150	$email_pos=4;
4151	$phone_pos=7;
4152	$home_phone_pos=10;
4153	$personal_cell_pos=12;
4154	$corporate_street_pos=13;
4155	$cep_pos=15;
4156	$phone_pos=18;
4157	$fax_pos=19;
4158	$pager_pos=20;
4159	$notes_pos=25;
4160	break;
4161	case 'thunderbird':
4162	$name_pos=2;
4163	$email_pos=4;
4164	$phone_pos=7;
4165	break;
4166	case 'expresso':
4167	$name_pos=0;
4168	$alias_pos=1;
4169	$email_pos=2;
4170	$aditionalEmail_pos=3;
4171	$personal_cell_pos=4;
4172	$corporate_phone_pos=5;
4173	$corporate_street_pos=6;
4174	$corporate_comp_pos=7;
4175	$corporate_cep_pos=8;
4176	$corporate_city_pos=9;
4177	$corporate_state_pos=10;
4178	$corporate_country_pos=11;
4179	$home_phone_pos=12;
4180	$street_pos=13;
4181	$comp_pos=14;
4182	$cep_pos=15;
4183	$city_pos=16;
4184	$state_pos=17;
4185	$country_pos=18;
4186	$birth_pos=19;
4187	$sex_pos = 20;
4188	$pgp_key_pos = 21;
4189	$notes_pos=22;
4190	$web_page_pos=23;
4191	$corporate_name_pos=24;
4192	$job_title_pos=25;
4193	$department_pos=26;
4194	$corporate_fax_pos=27;
4195	$corporate_pager_pos=28;
4196	$corporate_cell_pos=29;
4197	$fax_pos=30;
4198	$pager_pos=31;
4199	$corporate_street_2_pos = 32;
4200	$street_2_pos = 33;
4201	break;
4202	default:
4203	foreach($csv_header as $index => $fieldName)
4204	{
4205	switch($fieldName){
4206	case 'Name':
4207	case 'Nome':
4208	case 'First Name':
4209	$name_pos = $index;
4210	break;
4211	case 'Second name':
4212	case 'Segundo nome':
4213	$name2_pos = $index;
4214	break;
4215	case 'Sobrenome':
4216	case 'Surname':
4217	$name3_pos = $index;
4218	break;
4219	case 'Business Street':
4220	case 'Rua do endereço comercial':
4221	$corporate_street_pos = $index;
4222	break;
4223	case 'Rua do endereço comercial 2':
4224	case 'Outro endereço':
4225	$corporate_street_2_pos = $index;
4226	break;
4227	case 'Business Postal Code':
4228	case 'CEP do endereço comercial':
4229	$cep_pos = $index;
4230	break;
4231	case 'Business Fax':
4232	case 'Fax comercial':
4233	case 'Fax':
4234	$fax_pos = $index;
4235	break;
4236	case 'Home Phone':
4237	case 'Telefone residencial':
4238	$home_phone_pos = $index;
4239	break;
4240	case 'Mobile phone':
4241	case 'Telefone celular':
4242	$personal_cell_pos = $index;
4243	break;
4244	case 'Pager':
4245	$pager_pos = $index;
4246	break;
4247	case 'Phone':
4248	case 'Business Phone':
4249	case 'Telefone':
4250	case 'Telefone principal':
4251	case 'Telefone comercial':
4252	case 'Telefone Comercial':
4253	$phone_pos = $index;
4254	break;
4255	case 'Aniversário':
4256	case 'Birthdate':
4257	$birth_pos = $index;
4258	case 'Anotações':
4259	case 'Notes':
4260	$notes_pos = $index;
4261	case 'E-mail':
4262	case 'Email':
4263	case 'E-mail Address':
4264	case 'Endereço de correio eletrônico':
4265	case 'End. de email':
4266	$email_pos = $index;
4267	break;
4268	case 'Endereço de correio eletrônico 2':
4269	$aditionalEmail_pos = $index;
4270	break;
4271	}
4272	}
4273	break;
4274	}
4275
4276	while (($data = fgetcsv($handle, $len, $delim))) {
4277	foreach ($header as $key=>$heading)
4278	$row[$heading]=(isset($data[$key])) ? $data[$key] : '';
4279
4280	$sdata = array();
4281	$full_name = trim($row[$header[$name_pos]]);
4282	$email = trim($row[$header[$email_pos]]);
4283	$phone = trim($row[$header[$phone_pos]]);
4284	$name2 = trim($row[$header[$name2_pos]]);
4285	$name3 = trim($row[$header[$name3_pos]]);
4286
4287	$birth = trim($row[$header[$birth_pos]]);
4288	$notes = trim($row[$header[$notes_pos]]);
4289	$altEmail = trim($row[$header[$altEmail_pos]]);
4290	$sdata['alias'] = trim($row[$header[$alias_pos]]);
4291	$sdata['corporate_name'] = trim($row[$header[$corporate_name_pos]]);
4292	$sdata['job_title'] = trim($row[$header[$job_title_pos]]);
4293	$sdata['department'] = trim($row[$header[$department_pos]]);
4294	$sdata['web_page'] = trim($row[$header[$web_page_pos]]);
4295
4296	$sdata['sex'] = trim($row[$header[$sex_pos]]);
4297	$sdata['pgp_key'] = trim($row[$header[$pgp_key_pos]]);
4298
4299
4300	$full_name = $full_name;
4301	$array_name = explode(' ', str_replace('"','',(str_replace('\'','',$full_name))));
4302	$sdata['given_names'] = addslashes($array_name[0]);
4303	$array_name[0] = null;
4304	$sdata['family_names'] = trim(implode(' ',$array_name));
4305	if($sdata['family_names'] == '')
4306	{
4307	$sdata['family_names'] = addslashes($name2) . " " . addslashes($name3);
4308	}
4309
4310	$sdata['connections']['default_email']['connection_name'] = lang('Main');
4311	$sdata['connections']['default_email']['connection_value'] = addslashes($email);
4312	$sdata['connections']['aditional_email']['connection_name'] = "Alternativo";
4313	$sdata['connections']['aditional_email']['connection_value'] = trim($row[$header[$aditionalEmail_pos]]);
4314
4315	$sdata['connections']['default_phone']['connection_name'] = lang('Main');
4316	$sdata['connections']['default_phone']['connection_value'] = $phone;
4317
4318	if( trim($row[$header[$home_phone_pos]]) != "" )
4319	{
4320	$sdata['connections']['aditional_phone']['home_phone']['connection_name'] = 'Casa';
4321	$sdata['connections']['aditional_phone']['home_phone']['connection_value'] = trim($row[$header[$home_phone_pos]]);
4322	}
4323
4324	if( trim($row[$header[$personal_cell_pos]]) != "" )
4325	{
4326	$sdata['connections']['aditional_phone']['cellphone']['connection_name'] = 'Celular';
4327	$sdata['connections']['aditional_phone']['cellphone']['connection_value'] = trim($row[$header[$personal_cell_pos]]);
4328	}
4329
4330	if( trim($row[$header[$corporate_phone_pos]]) != "")
4331	{
4332	$sdata['connections']['aditional_phone']['corporate_phone']['connection_name'] = 'Trabalho';
4333	$sdata['connections']['aditional_phone']['corporate_phone']['connection_value'] = trim($row[$header[$corporate_phone_pos]]);
4334	}
4335
4336	if( trim($row[$header[$fax_pos]]) != "" )
4337	{
4338	$sdata['connections']['aditional_phone']['fax']['connection_name'] = 'Fax';
4339	$sdata['connections']['aditional_phone']['fax']['connection_value'] = trim($row[$header[$fax_pos]]);
4340	}
4341
4342	if ($GLOBALS['phpgw_info']['server']['personal_contact_type'] == 'True')
4343	{
4344	if( trim($row[$header[$pager_pos]]) != "" )
4345	{
4346	$sdata['connections']['aditional_phone']['pager']['connection_name'] = 'Pager';
4347	$sdata['connections']['aditional_phone']['pager']['connection_value'] = trim($row[$header[$pager_pos]]);
4348	}
4349
4350	if( trim($row[$header[$corporate_fax_pos]]) != "" )
4351	{
4352	$sdata['connections']['aditional_phone']['corporate_fax']['connection_name'] = 'Fax Corporativo';
4353	$sdata['connections']['aditional_phone']['corporate_fax']['connection_value'] = trim($row[$header[$corporate_fax_pos]]);
4354	}
4355
4356	if( trim($row[$header[$corporate_cell_pos]]) != "" )
4357	{
4358	$sdata['connections']['aditional_phone']['corporate_cell']['connection_name'] = 'Celular Corporativo';
4359	$sdata['connections']['aditional_phone']['corporate_cell']['connection_value'] = trim($row[$header[$corporate_cell_pos]]);
4360	}
4361
4362	if( trim($row[$header[$corporate_pager_pos]]) != "" )
4363	{
4364	$sdata['connections']['aditional_phone']['corporate_pager']['connection_name'] = 'Pager Corporativo';
4365	$sdata['connections']['aditional_phone']['corporate_pager']['connection_value'] = trim($row[$header[$corporate_pager_pos]]);
4366	}
4367	}
4368
4369	$sdata['addresses']['address_corporative']['address1'] = trim($row[$header[$corporate_street_pos]]);
4370	$sdata['addresses']['address_corporative']['address2'] = trim($row[$header[$corporate_street_2_pos]]);
4371	$sdata['addresses']['address_corporative']['complement'] = trim($row[$header[$corporate_comp_pos]]);
4372	$sdata['addresses']['address_corporative']['postal_code'] = trim($row[$header[$corporate_cep_pos]]);
4373	$sdata['addresses']['address_corporative']['id_country'] = "BR";
4374	$sdata['addresses']['address_corporative']['id_state'] = trim($row[$header[$corporate_state_pos]]);
4375	$sdata['addresses']['address_corporative']['id_city'] = trim($row[$header[$corporate_city_pos]]);
4376
4377
4378	$sdata['addresses']['address_personal']['address1'] = trim($row[$header[$street_pos]]);
4379	$sdata['addresses']['address_personal']['address2'] = trim($row[$header[$street_2_pos]]);
4380	$sdata['addresses']['address_personal']['complement'] = trim($row[$header[$comp_pos]]);
4381	$sdata['addresses']['address_personal']['postal_code'] = trim($row[$header[$cep_pos]]);
4382	$sdata['addresses']['address_personal']['id_country'] = "BR";
4383	$sdata['addresses']['address_personal']['id_state'] = trim($row[$header[$state_pos]]);
4384	$sdata['addresses']['address_personal']['id_city'] = trim($row[$header[$city_pos]]);
4385
4386	if(trim($birth)) {
4387	$array_birth = explode("/",trim($birth));
4388	$sdata['birthdate'] = date('Y-m-d', mktime(0,0,0,$array_birth[1],$array_birth[0],$array_birth[2]));
4389	}
4390
4391	$sdata['notes'] = addslashes($notes);
4392	//$sdata['is_quick_add'] = true;
4393	$sdata['connections']['default_phone']['connection_value'] = $phone;
4394
4395	// verifica se email já existe!
4396	$email = addslashes($email);
4397	$contact = $boGroup->verify_contact($email);
4398
4399	if(!$sdata['given_names'] && $email){
4400	$a_email = explode("@",$email);
4401	$sdata['given_names'] = addslashes($a_email[0]);
4402	}
4403
4404	$line_iteration = $return['_failure'] + $return['_existing'] + $return['_new'];
4405
4406	if($contact){
4407	$return['_existing']++;
4408	}
4409	else if((!eregi("^[/_a-z0-9-]+(\.[_a-z0-9-]+)@[a-z0-9-]+(\.[a-z0-9-]+)(\.[a-z]{2,3})$", $email)) && $email) {
4410	$return['_failure']++;
4411	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid E-Mail address: " . $email ."<br>";
4412	}
4413	else if (!$sdata['given_names'] \|\| !$boPeople ->quick_add($sdata)){
4414	$return['_failure']++;
4415	$return['_failure_status'] .= "Line: " . ($line_iteration + 2) . ", Invalid Name: " . $sdata['given_names'] ."<br>";
4416	}
4417	else{
4418	if($id_group != 0){
4419	$this->so_group->add_user_by_name($id_group,$full_name);
4420	}
4421	$return['_new']++;
4422	}
4423	}
4424	fclose($handle);
4425	unlink($file);
4426	}
4427	else
4428	$return['error'] = true;
4429
4430	echo serialize($return);
4431	}
4432	}
4433
4434	?>

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

Download in other formats: