Context Navigation

source: branches/2.2/contactcenter/inc/class.ui_data.inc.php @ 3180

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

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

Download in other formats: