select.php

groupoffice

<?php
/**
 * @copyright Intermesh 2003
 * @author Merijn Schering <[e-mail]>
 * @version $Revision: 1.75 $ $Date: 2006/04/10 13:21:11 $

 * This program is free software; you can redistribute it and/or modify it
 * under the terms of the GNU General Public License as published by the
 * Free Software Foundation; either version 2 of the License, or (at your
 * option) any later version.
 */

if (isset($_REQUEST['handler_base64_encoded']))
{
	$_REQUEST['GO_HANDLER'] = base64_decode($_REQUEST['GO_HANDLER']);
}
require_once("../../Group-Office.php");
$GO_SECURITY->authenticate();


require_once($GO_LANGUAGE->get_language_file('addressbook'));

$GO_FIELD = isset($_REQUEST['GO_FIELD']) ? smart_stripslashes($_REQUEST['GO_FIELD']) : '';
$GO_HANDLER = isset($_REQUEST['GO_HANDLER']) ? smart_stripslashes($_REQUEST['GO_HANDLER']) : '';

$task = isset($_REQUEST['task']) ? $_REQUEST['task'] : '';
$mode = isset($_REQUEST['mode']) ? $_REQUEST['mode'] : '';

$pass_value = isset($_REQUEST['pass_value']) ? $_REQUEST['pass_value'] : 'email';
$multiselect = isset($_REQUEST['multiselect']) ? $_REQUEST['multiselect'] :  'false';
$require_email_address = isset($_REQUEST['require_email_address']) ? $_REQUEST['require_email_address'] : 'false';

$tabstrip = new tabstrip('search_type',$cmdSearch);	
$tabstrip->set_attribute('style','width:100%');


if(isset($_REQUEST['show_contacts']) &&  $_REQUEST['show_contacts'] == 'true')
{
	$tabstrip->add_tab('contact',$contacts_contacts);
	$types_used[] = 'contact';
	$show_contacts='true';
}else
{
	$show_contacts='false';
}
if(isset($_REQUEST['show_companies']) &&  $_REQUEST['show_companies'] == 'true')
{
	$types_used[] = 'company';
	$show_companies='true';
	$tabstrip->add_tab('company',$ab_companies);
}else
{
	$show_companies='false';
}
if(isset($_REQUEST['show_users']) &&  $_REQUEST['show_users'] == 'true')
{
	$tabstrip->add_tab('user',$contacts_members);
	$types_used[] = 'user';
	$show_users='true';
}else
{
	$show_users='false';
}
if(isset($_REQUEST['show_projects']) &&  $_REQUEST['show_projects'] == 'true')
{
	$types_used[] = 'project';
	$show_projects='true';
	$tabstrip->add_tab('project', $strProjects);
}else
{
	$show_projects='false';
}
if(isset($_REQUEST['show_files']) &&  $_REQUEST['show_files'] == 'true')
{
	$tabstrip->add_tab('file', $strFiles);
	$types_used[] = 'file';
	$show_files='true';
}else
{
	$show_files='false';
}
$show_mailings = isset($_REQUEST['show_mailings']) && $_REQUEST['show_mailings']=='true' ? true : false;


$search_type = isset($_REQUEST['search_type']) ? $_REQUEST['search_type'] : 'contact';

if (isset($GO_MODULES->modules['addressbook']) && $GO_MODULES->modules['addressbook']['read_permission'])
{
	$GO_MODULES->authenticate('addressbook');
	
	require_once($GO_MODULES->modules['addressbook']['class_path'].'addressbook.class.inc');
	$ab = new addressbook();
	
	
	$ab_settings = $ab->get_settings($GO_SECURITY->user_id);
	if($search_type == '')
	{
		$search_type = $ab_settings['search_type'];
		$tabstrip->set_active_tab($ab_settings['search_type']);
	}else
	{
		 $ab_settings['search_type'] = $search_type;
	}
	
	$addressbook_id = isset($_REQUEST['addressbook_id']) ? $_REQUEST['addressbook_id'] : $ab_settings['addressbook_id'];
	if($addressbook_id == 0)
	{
		$addressbook = $ab->get_addressbook();
		$addressbook_id = $addressbook['id'];
	}
}
$GO_HEADER['head'] = datatable::get_header();
$GO_HEADER['body_arguments'] = 'onkeypress="javascript:executeOnEnter(event, \'search();\');"';
$GO_HEADER['body_arguments'] .= 'onload="javascript:document.select_form.query.focus();"';

$page_title = $contacts_select;
require_once($GO_THEME->theme_path."header.inc");


$form = new form('select_form');
$form->add_html_element(new input('hidden','multiselect', $multiselect));
$form->add_html_element(new input('hidden','require_email_address', $require_email_address));
$form->add_html_element(new input('hidden','show_users', $show_users));
$form->add_html_element(new input('hidden','show_contacts', $show_contacts));
$form->add_html_element(new input('hidden','show_companies', $show_companies));
$form->add_html_element(new input('hidden','show_projects', $show_projects));
$form->add_html_element(new input('hidden','show_files', $show_files));
$form->add_html_element(new input('hidden','pass_value', $pass_value));
$form->add_html_element(new input('hidden','task', $task, false));
$form->add_html_element(new input('hidden','mode', $mode, false));
$form->add_html_element(new input('hidden','GO_FIELD', $GO_FIELD));
$form->add_html_element(new input('hidden','GO_HANDLER', $GO_HANDLER));
$form->add_html_element(new input('hidden','clicked_letter'));
$form->add_html_element(new input('hidden','select_single'));


if ($show_contacts == 'true' || $show_companies == 'true')
{
	$menu = new button_menu();
	if($show_contacts)
	{
		$menu->add_button('add_contact', $ab_new_contact, "javascript:popup('".$GO_MODULES->modules['addressbook']['url'].
			"contact.php?addressbook_id=".$addressbook_id.
			"&popup=true','770','500');");	
	}
			
	if($show_companies)
	{
		$menu->add_button('ab_add_company', $ab_new_company, "javascript:popup('".
			$GO_MODULES->modules['addressbook']['url']."company.php?addressbook_id=".
			$addressbook_id."&popup=true','770','500');");
	}
	$tp_plugin=$GO_MODULES->get_plugin('templates', 'addressbook');
	if($show_mailings && $tp_plugin)
	{
		$menu->add_button('mailings', $ab_mailings, "javascript:change_mode('mailings');");
	}
	
	
	$form->add_html_element($menu);
}

require_once($GO_CONFIG->class_path.'mail/RFC822.class.inc');
$RFC822 = new RFC822();

if (isset($_REQUEST['address_string']))
{
	$addresses = $RFC822->explode_address_list(smart_stripslashes($_REQUEST['address_string']));
}else
{
	$addresses=array();
}

$datatable = new datatable('select_table');
$datatable->set_multiselect(($multiselect == 'true'));

switch($mode)
{
	case 'mailings':
		if(isset($_POST['addresses']))
		{
			$addresses = array_map('smart_stripslashes', $_POST['addresses']);
		}elseif(isset($_POST['select_table']['selected']))
		{
			$addresses = array_map('smart_stripslashes', $_POST['select_table']['selected']);
		}else
		{
			$addresses = array();
		}
		foreach($addresses as $address)
		{
			$form->add_html_element(new input('hidden', 'addresses[]', $address));
		}
		$datatable->add_column(new table_heading($strName));
		require($tp_plugin['class_path'].'templates.class.inc');
		$tp = new templates();
		
		$count = $tp->get_mailing_groups($GO_SECURITY->user_id);
		
		while($tp->next_record())
		{
			$row = new table_row($tp->f('id'));
			$row->set_attribute('ondblclick', "javascript:_select_mailing();");
			
			$row->add_cell(new table_cell($tp->f('name')));			
			$datatable->add_row($row);
		}
	break;
	
	default:

		$datatable->set_remind_selected(true);

		if ($pass_value == 'email')
		{
			$datatable->selected = array_merge($addresses, $datatable->selected);
		}

		$count = 0;
		
		$table = new table();
		$row = new table_row();			

		$h2 = new html_element('h2');
		for($i=0;$i<count($alphabet);$i++)
		{
			$hyperlink = new hyperlink("javascript:letter_click('".$alphabet[$i]."')",$alphabet[$i]);
			$hyperlink->set_attribute('style', 'margin-right:10px;');
			$h2->add_html_element($hyperlink);
		}

		$tabstrip->add_html_element($h2);
		
		$table = new table();
		$row = new table_row();

		$search_fields = new select('search_field');		

		switch ($search_type)
		{
			case 'company':
				$search_fields->add_value('', $strSearchAll);
				$search_fields->add_value('ab_companies.name', $strName);
				$search_fields->add_value('ab_companies.email', $strEmail);
				$search_fields->add_value('ab_companies.address',$strAddress);
				$search_fields->add_value('ab_companies.city', $strCity);
				$search_fields->add_value('ab_companies.zip',$strZip);
				$search_fields->add_value('ab_companies.state',$strState);
				$search_fields->add_value('ab_companies.country', $strCountry);


				$search_field = $ab_settings['search_companies_field'] ;
				if(isset($_REQUEST['search_field']))
				{
					if($search_fields->is_in_select($_REQUEST['search_field']))
					{
						$search_field = $_REQUEST['search_field'];
						if($task != 'show_letter')
						{
							$ab_settings['search_companies_field'] = $_REQUEST['search_field'];
						}
					}
				}		  
				$search_fields->value=$ab_settings['search_companies_field'];
			break;

			case 'user':
				$search_fields->add_value('', $strSearchAll);			
				$search_fields->add_value('users.first_name', $strFirstName);
				$search_fields->add_value('users.last_name', $strLastName);
				$search_fields->add_value('users.email', $strEmail);
				$search_fields->add_value('users.department',$strDepartment);
				$search_fields->add_value('users.function',$strFunction);
				$search_fields->add_value('users.address',$strAddress);
				$search_fields->add_value('users.city', $strCity);
				$search_fields->add_value('users.zip',$strZip);
				$search_fields->add_value('users.state',$strState);
				$search_fields->add_value('users.country', $strCountry);
				$search_fields->add_value('users.comment', $ab_comment);
				
				$search_field = isset($ab_settings['search_users_field']) ? $ab_settings['search_users_field'] : '';
				if(isset($_REQUEST['search_field']))
				{
					if($search_fields->is_in_select($_REQUEST['search_field']))
					{
						$search_field = $_REQUEST['search_field'];
						$ab_settings['search_users_field'] = $_REQUEST['search_field'];
					}
				}		  
				$search_fields->value=$ab_settings['search_users_field'];
			break;
			
			case 'project':
				$search_field = $search_fields->value = 'pmProjects.name';
				$search_fields->add_value('pmProjects.name', $strName);
			break;
			
			case 'file':			
				$home_path = $GO_CONFIG->file_storage_path.'users/'.$_SESSION['GO_SESSION']['username'];
				$search_field = $search_fields->value = isset($_POST['search_field']) ? smart_stripslashes($_POST['search_field']) : $home_path;

				$search_fields->add_value($home_path, 'home');
				
				require_once($GO_LANGUAGE->get_language_file('filesystem'));
				require_once($GO_CONFIG->class_path.'filesystem.class.inc');
				$fs = new filesystem();
				$fs2 = new filesystem();
			  $fs2->get_my_shares($GO_SECURITY->user_id);
				
			  while ($fs2->next_record())
			  {
			    $shares = array();
			    $share_count = $fs->get_shares($fs2->f('user_id'));
			    while ($fs->next_record())
			    {
			      if ($GO_SECURITY->has_permission($GO_SECURITY->user_id, $fs->f('acl_read')) || 
								$GO_SECURITY->has_permission($GO_SECURITY->user_id, $fs->f('acl_write')))
			      {
							$shares[] = $fs->f('path');
			      }
			    }
			    $share_count = count($shares) ;
			    if ($share_count > 0)
			    {
			      if ($user = $GO_USERS->get_user($fs2->f('user_id')))
			      {
							$search_fields->add_optgroup($user['username']);
							for ($i=0;$i<$share_count;$i++)
							{
							  $search_fields->add_value($shares[$i], basename($shares[$i]));
							}
			      }
			    }
			  }		
			break;
			
			default:
				//$search_fields->value = $ab_settings['search_contacts_field'];
				$search_fields->add_value('', $strSearchAll);
				$search_fields->add_value('ab_contacts.first_name', $strFirstName);
				$search_fields->add_value('ab_contacts.last_name', $strLastName);
				$search_fields->add_value('ab_contacts.email', $strEmail);
				$search_fields->add_value('ab_contacts.department',$strDepartment);
				$search_fields->add_value('ab_contacts.function',$strFunction);
				$search_fields->add_value('ab_contacts.address',$strAddress);
				$search_fields->add_value('ab_contacts.city', $strCity);
				$search_fields->add_value('ab_contacts.zip',$strZip);
				$search_fields->add_value('ab_contacts.state',$strState);
				$search_fields->add_value('ab_contacts.country', $strCountry);
				$search_fields->add_value('ab_contacts.comment', $ab_comment);