<?
/****************************************************************************************/
/*  Association Liégeoise des Géomètres-Experts -  Union professionnelle fondée en 1889 */
/*                          Membre de l'Union Belge des Géomètres                       */ 
/****************************************************************************************/
/* Conception et programation par Jacques Houbart                                       */
/* Design par Geoffrey Bougnet                                                          */
/****************************************************************************************/
/* Fichier sendmail.php -- Version 1.01 -- Février 2004 -                               */
/* Page PHP d'envoi d'un message par mail                                               */ 
/****************************************************************************************/

define('Geometres_Site',TRUE);  
define("USE_DB",TRUE);
include_once("Common.php"); 
include_once (HTML_LANG_PATH.'lang_search_user.php');
include_once (HTML_LANG_PATH.'lang_form.php');
include_once (HTML_INC_PATH.'InputValidation.php');

								  
/*  Cette page est appelée en popup avec les arguments 
    CallerForm= nom du formulaire de retour, 
	CtrlLat et CtrlLng = controles dans le formulaire ou renvoyer les valeurs du point (input type=hidden ....)
	CtrlData=controle dans le formulaire ou renvoyer la valeur à afficher (input type=text ....)
	PointLat et PointLng = La valeur initiale 
	CityID = ID de la DB pour indiquer la cité
	
	
*/
$ErrrorMsg='';
  
if ($_POST['mode']=='Search')
{  

	if (!$_POST['Localite_ID']&& !$_POST['Search_Name'])
		{
		$ErrrorMsg.=WriteError('Error_Search_NoCritere');
		}
	elseif ($_POST['Search_Name'] && strlen($_POST['Search_Name'])<3)	
		{
		$ErrrorMsg.=WriteError('Error_Search_TooShort');
		}
	elseif ($_POST['Localite_ID']&& (!$_POST['Search_Proxy']))
		{
		$ErrrorMsg.=WriteError('Error_Search_Mode');
		}
}
else
{ //Default initialisation
$_POST['Search_ProOnly']=true; 
}
	
if (($ErrrorMsg=='')&&($_POST['mode']=='Search'))
{	
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//%% Block d'exécution de la recheche

	//###################################################################################################################
	//## Création des requêtes
	if (!$_POST['Localite_ID']) // Recherche sur nom
	{
		// *************************************************************************** 
		// Recherche par nom
		$req0="SELECT `u`.*, `s`.*,`a`.*,`c`.* 
		FROM  `users` `u`, `global_salut` `s`, `users_associations` `a`, `global_country` `c` 
		WHERE
		  (`u`.`LnkSalut` = `s`.`Salut_id`) AND 
		  (`u`.`LnkAssociation` = `a`.`AssocID`) AND 
		  (`u`.`Adr1_Country` = `c`.`ISO3166_Code`)"; 	  
		
		if ($_POST['Search_Option']==3) // Recherche soundex
			 {
	//		 $req0.="AND (u.`SoundKey` = '".soundex($_POST['Search_Name']). "' OR u.`MetaKey`  LIKE '".metaphone($_POST['Search_Name'])."%') "; 
			 $req0.="AND (u.`SoundKey` = '".soundex($_POST['Search_Name']). "') "; 
			 $SearchMessage=sprintf($site_lang['Search_Result_Snd'],$_POST['Search_Name'],soundex($_POST['Search_Name']),metaphone($_POST['Search_Name']));
			 }
		else if ($_POST['Search_Option']==2) // Recherche % texte %
			 {
			 $req0.="AND u.`Nom` LIKE '%".$_POST['Search_Name']."%' "; 
			  $SearchMessage=sprintf($site_lang['Search_Result_InTxt'],$_POST['Search_Name']);
			 }
		else  // Recherche texte
			 {
			 $req0.="AND u.`Nom` LIKE '".$_POST['Search_Name']."%' "; 
			  $SearchMessage=sprintf($site_lang['Search_Result_Txt'],$_POST['Search_Name']);
			 }
		$req0.=" ORDER BY u.`Nom`, u.`Prenom`";
	}
	elseif (($_POST['Search_Proxy']=="L")||($_POST['Search_Proxy']=="C")) //Localite /commune
	{
		// *************************************************************************** 
		// Recherche par localité
	   $req1="SELECT * FROM `global_localites` WHERE `Localite_ID` =".$_POST['Localite_ID']. " LIMIT 1";
	   if (!($query0=$db->sql_query($req1)))  { die_error("Erreur de lecture de la base de donnée - Recherche Membre Proxy Localite Message"); }
	   $record1=$db->sql_fetchrow($query0);  
	
		  
	   if ($_POST['Search_Proxy']=="L")  
		{ // Recherche sur localité
	   		$req0="SELECT `u`.*, `s`.*,`a`.*,`c`.* 
				FROM  `users` `u`, `global_salut` `s`, `users_associations` `a`, `global_country` `c` 
				WHERE
				  (`u`.`LnkSalut` = `s`.`Salut_id`) AND 
				  (`u`.`LnkAssociation` = `a`.`AssocID`) AND 
				  (`u`.`Adr1_Country` = `c`.`ISO3166_Code`) AND 
				  (u.`Adr1_Lnk_Localite` = '".$_POST['Localite_ID']. "') "; 
			$SearchMessage=sprintf($site_lang['Search_Result_Entite'],$record1['Localite'],$record1['CP_Localite'],$record1['Commune']);
		}
		else // 	if ($_POST['Search_Proxy']=="C")  
		{ // Recherche sur Commune
	        $CodePoste=$record1['CP_Commune']; 
			$req0="SELECT `u`.*, `s`.*,`a`.*,`c`.* 
				FROM  `users` `u`, `global_salut` `s`, `users_associations` `a`, `global_country` `c`, `global_localites` `g` 
				WHERE
				  (`u`.`LnkSalut` = `s`.`Salut_id`) AND 
				  (`u`.`LnkAssociation` = `a`.`AssocID`) AND 
				  (`u`.`Adr1_Country` = `c`.`ISO3166_Code`) AND 
		          (`u`.`Adr1_Lnk_Localite` = `g`.`Localite_ID`) AND 
		          (`g`.`CP_Commune` = ".$CodePoste.")"; 
	   		$CommuneName=$record1['Commune'];
	    	$req1="SELECT * FROM `global_localites` WHERE `CP_Commune` = '".$CodePoste."'";
		    if (!($query0=$db->sql_query($req1)))  { die_error("Erreur de lecture de la base de donnée - Recherche Membre Proxy Localite Message"); }
			$CommuneList=array();
			while ($record1=$db->sql_fetchrow($query0)){$CommuneList[]=$record1['Localite'];}
			$SearchMessage=sprintf($site_lang['Search_Result_Commune'],$CommuneName,implode(', ',$CommuneList)); 
		}	
	   $req0.=$_POST['Search_ProOnly']?"AND (u.`Professional` ='Yes')":'';
	   $req0.=" ORDER BY u.`Nom`, u.`Prenom`";
	}
	elseif ($_POST['Search_Proxy']=="P")
	{
		// *************************************************************************** 
		// Distance
	//   $req1="SELECT * FROM `global_localites` WHERE `Localite_ID` =".$_POST['Localite_ID']. " LIMIT 1";
	//   if (!($query0=$db->sql_query($req1)))  { die_error("Erreur de lecture de la base de donnée - Recherche Membre Proxy Localite Message"); }
	//   $record1=$db->sql_fetchrow($query0);  
       $req1="SELECT * FROM `global_localites` WHERE `Localite_ID` =".$_POST['Localite_ID']. " LIMIT 1";
	   if (!($query0=$db->sql_query($req1)))  { die_error("Erreur de lecture de la base de donnée - Recherche Membre Proxy Geo"); }
	   $record1=$db->sql_fetchrow($query0);  

	$Lng=deg2rad($record1['Longitude']);
	$Lat=deg2rad($record1['Latitude']);

	// Calcul hors requête pour optimiser la recherche
	$Cos_Lat=Cos($Lat);
	$Sin_Lat=Sin($Lat);

	
  	$req0="SELECT `u`.*, `s`.*,`a`.*,`c`.*, 
	            (6366*acos(".$Cos_Lat."*cos(RADIANS(`u`.`Latitude`))*cos(RADIANS(`u`.`Longitude`)-".$Lng.")+".$Sin_Lat."*sin(RADIANS(`u`.`Latitude`)))) as `Distance` 
				FROM  `users` `u`, `global_salut` `s`, `users_associations` `a`, `global_country` `c` 
				WHERE
				  (`u`.`LnkSalut` = `s`.`Salut_id`) AND 
				  (`u`.`LnkAssociation` = `a`.`AssocID`) AND 
				  (`u`.`Adr1_Country` = `c`.`ISO3166_Code`)";
  	$req0.=$_POST['Search_ProOnly']?"AND (u.`Professional` ='Yes')":'';
  	$req0.=" ORDER BY Distance ASC, u.`Nom`, u.`Prenom`	LIMIT 10"; 
	$SearchMessage=sprintf($site_lang['Search_Result_Dist'],$record1['Localite'],$record1['CP_Localite'],$record1['Commune'],$record1['Longitude'],$record1['Latitude']);
	} 
	else
	{
	die_error("Erreur interne : Option non implémentée Search_Proxy=".$_POST['Search_Proxy'].". Contacter l'administrateur");
	}
	//###################################################################################################################
	//## Execution de la requete et adffichage des membres
	include_once (HTML_INC_PATH.'NoSpamMail.php');
	InitSecureMailHeader();
	include (HTML_INC_PATH."PageHeader.php"); 

	$SiteTemplate->set_filenames(array('Search_body' => 'user_search_body.tpl'));
	$SiteTemplate->assign_block_vars('UserList_Section',array());


	if (!($query0=$db->sql_query($req0)))  { die_error("Erreur de lecture de la base de donnée - Recherche Membre req=".$req0); }

	if ($record=$db->sql_fetchrow($query0))
	 {

		  do
		  {
			 $UserLanguage=$record['Lang'];
			 $Adresse=$record['Adr1_Site']?$record['Adr1_Site'].'<br />':'';
			 $Adresse.=$record['Adr1_Rue'].', '.$record['Adr1_Num'].($record['Adr1_Bte']?'/'.$record['Adr1_Bte']:'').'<br />';
		 	 $Adresse.=$record['Adr1_Etage']?$record['Adr1_Etage'].'<br />':'';
			 $Adresse.=$record['Adr1_CP'].' '.$record['Adr1_Localite'].'<br />';
		  	 $Adresse.=($record['Adr1_Localite']!=$record['Adr1_Localite'])?'('.$record['Adr1_Commune'].')<br />':'';
		 	 $Adresse.=$record['ISO3166_'.$UserLanguage];
			 
			 $Contact='<table summary="" border="0">';


			 If ($record['Tel']){$Contact.='<tr><td>&nbsp;'.$site_lang['Label_Tel'].'</td><td>&nbsp;'.$record['Tel'].'</td></tr>';}
 			 If ($record['Fax']){$Contact.='<tr><td>&nbsp;'.$site_lang['Label_Fax'].'</td><td>&nbsp;'.$record['Fax'].'</td></tr>';}
 			 If ($record['GSM']){$Contact.='<tr><td>&nbsp;'.$site_lang['Label_GSM'].'</td><td>&nbsp;'.$record['GSM'].'</td></tr>';}			 
            
			 
			 If (defined('SECURE_COUNTRY')){$Contact.='<tr><td>&nbsp;'.$site_lang['Label_Mail'].'</td><td>&nbsp;'.GetSecureMailJavaScriptEventImg($record['Alias'].'@'.($UserLanguage=='NL'?'Landmeter-Expert.org':'Geometre-Expert.org')).'</td></tr>';}
 			 If ($record['Skype']){$Contact.='<tr><td>&nbsp;'.$site_lang['Label_Sky'].'</td><td>&nbsp;<a href="'.$record['Skype'].'"><img src="Pictures/Tooltips/skype_.gif" border="0" width="16" height="16" /></a></td></tr>';}			 
  			 /*If ($record['ICQ']){$Contact.='<tr><td>&nbsp;'.$site_lang['Label_ICQ'].'</td><td>&nbsp;<img src="http://wwp.icq.com/scripts/online.dll?icq='.$record['ICQ'].'&amp;img=5" border="0" width="18" height="18" />&nbsp;<a href="javascript:void(0);" onclick=\'window.open("http://www.icq.com/people/webmsg.php?to='.$site_lang['Label_ICQ'].'","msgwin","toolbar=false,directories=false,status=false,menubar=0,scrollbars=0,resizable=0,width=510,height=546, replace=yes")\' title="Send message without ICQ">Send message to '.$record['ICQ'].'</a></td></tr>';}			 */
 			 If ($record['URL']){$Contact.='<tr><td>&nbsp;'.$site_lang['Label_WebSite'].'</td><td>&nbsp;<a href="'.$record['URL'].'">'.$record['URL'].'</a></td></tr>';}			 
 			 $Contact.='</table>';
			 $Distance='';
			 if ($record['Distance'])
			 	{
					if ($record['Distance']<1)
			 			{
						$Distance=sprintf('%01.0f m',$record['Distance']*1000); 
						}
					else
			 			{
						$Distance=sprintf('%01.3f Km',$record['Distance']); 
						}
				$Distance='<span style="color: #FF9933; font-weight: bold">'.$Distance.'</span>';
			 	}
			 
		  	  $SiteTemplate->assign_block_vars('User_Section',array(
			  'SALUT'       =>   $record['Salut_'.$UserLanguage],
			  'NAME' 		=>   $record['Prenom'].' '.$record['Nom'],
			  'TITRE'		=>   $site_lang['TitreArray'][$record['Statut']],
			  'ASSOC' 		=>  $record['Acronyme_'.$UserLanguage],
			  'ASSOC_LOGO' =>  $record['Assoc_Logo'], 
			  'ADRESSE'	=>	$Adresse,
		  	  'NUMCONSEIL'	=> $record['NConsFed'],
			  'CONTACT'     =>$Contact,
			  'DISTANCE'  => $Distance,
			   ));
	   
		  }
		  while ($record=$db->sql_fetchrow($query0));
	  }
	  else
	  {

  	  $SiteTemplate->assign_block_vars('MessageBox_Section',array('MESSAGE'  => $site_lang['Search_NoResult'] ));
	  }
	
////	
	$SiteTemplate->assign_vars(array(
		'TITLE'		        => $site_lang['Search_Localite_Result_Title'],
		'RESULT_MESSAGE'    => $SearchMessage,
		'NEW_SEARCH'		=> $site_lang['Label_NewSearch'],
		
	));

$SiteTemplate->pparse('Search_body');
include (HTML_INC_PATH."PageFooter.php");
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
}
else
{
//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
//%% Block d'affichage du form de recherche
include (HTML_INC_PATH."PageHeader.php"); 
$SiteTemplate->set_filenames(array('Search_body' => 'user_search_body.tpl'
  //         , 'Search_script' => 'user_search_script.tpl' 
  ));


$ProxyArray=array( 
    '0' => '- '.$site_lang['Label_Proxy'].' -',
	'L' => $site_lang['List_Proxy_Localite'],
	'C'	=> $site_lang['List_Proxy_Commune'],
    'P'	=> sprintf($site_lang['List_Proxy_Dist'],10)
	);

/*'<option value="0" >-'.$site_lang['Label_Proxy'].'-</option>'. 
							'<option value="L" >'.$site_lang['List_Proxy_Localite'].'</option>'.
							'<option value="C" >'.$site_lang['List_Proxy_Commune'].'</option>',
						//	'<option value="-10" selected >'.sprintf($site_lang['List_Proxy_Dist'],10).'</option>'.
						//	'<option value="2" >'.$site_lang['List_InRadius'].' 2 km </option>'.	
						//	'<option value="5" >'.$site_lang['List_InRadius'].' 5 km </option>'.	
						//	'<option value="10" >'.$site_lang['List_InRadius'].' 10 km </option>',	
							//'<option value="20" >'.$site_lang['Label_InRadius'].' 20 km </option>',
*/
$SelectProxy='';
foreach( $ProxyArray  as $Key=>$Variable) {$SelectProxy.='<option value="'.$Key.'" '.(($Key==$_POST['Search_Proxy'])?'selected':'').'>'.$Variable.'</option>';}

$OptionArray=array('1' => $site_lang['Label_Txt'], '2' => $site_lang['Label_InTxt'], '3' => $site_lang['Label_Soundex']);  
  
$SelectOption='';
foreach( $OptionArray  as $Key=>$Variable) {$SelectOption.='<option value="'.$Key.'" '.(($Key==$_POST['Search_Option'])?'selected':'').'>'.$Variable.'</option>';}
  

if ($ErrrorMsg!='') {$SiteTemplate->assign_block_vars('ErrorMessage_Section',array(
	'ERROR_TITLE' =>$site_lang['Error'],
	'ERROR_MSG'  => '<ul type="disc">'.$ErrrorMsg.'</ul>'));}

$SiteTemplate->assign_block_vars('SearchForm_Section',array());
 
$SiteTemplate->assign_vars(array(
	'TITLE'		        => $site_lang['Search_Title'],
	'EXPLAIN'		    => $site_lang['Search_Message'],


	'TITLE_PROXY'		=> $site_lang['Search_SubTitle_Proximity'],
	'EXPLAIN_PROXY'		=> $site_lang['Search_Explain_Proximity'],

	'LABEL_LOCALITE'	=>$site_lang['Label_LocaliteList'],
	'S_LOCALITE'		=> $_POST['Localite_Text'],
	'S_LOCALITE_ID'		=> $_POST['Localite_ID'],

	'LABEL_PROXY'		=> $site_lang['Label_Proxy'],
	'SELECT_PROXY'		=> $SelectProxy,

	'LABEL_PRO'		    => $site_lang['Label_ExecOnly'],
	'S_PRO'  	    	=> isset($_POST['Search_ProOnly'])?" checked":"",
	'V_PRO'       		=> TRUE,

	'TITLE_NAME'	    => $site_lang['Search_SubTitle_Name'],
	'EXPLAIN_NAME'		=>$site_lang['Search_Explain_Name'],
	
	'LABEL_NAME'		=>$site_lang['Label_Word'],
	'S_NAME'		    =>$_POST['Search_Name'],
	'LABEL_OPTION'		=>$site_lang['Label_Mode'],
	'SELECT_OPTION'		=>$SelectOption,
	
	'SUBMIT_LABEL'		=> $site_lang['Label_SrchBtn'],
	'S_MODE'		    => 'Search'
	));
$SiteTemplate->pparse('Search_body');
include (HTML_INC_PATH."PageFooter.php");
}  
?>