Context Navigation

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

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

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

Download in other formats: