<?php
  
  /*-----------------------------------------------------------------------------------------+
   | cyberproprio v1.0 par Yanick Bourbeau / Edison Communication Inc. 2003                  |
   +-----------------------------------------------------------------------------------------+
   |                                                                                         |
   | Script qui permet de saisir une selection de proprietes via certain criteres            |
   |                                                                                         |
   |                                                                                         |
   +-----------------------------------------------------------------------------------------+
   |                                                                                         |
   | CHANGELOG:                                                                              |
   |                                                                                         |
   | 7oct2003 ybo - Creation de ce fichier                                                   |
   |                                                                                         |
   |                                                                                         |
   |                                                                                         |
   +-----------------------------------------------------------------------------------------*/

// tres important et meme obligatoire.
require_once("../system/include/init.user.php");
       
// on va chercher les regions                                    
$result = $CP["sql"]->Execute("SELECT COUNT(*) FROM propriete_villes");

$script = "dimension('array_villes',".$result->fields[0].",3,1);\r\n";
$CP["tpl"]->set_var("villeCount",$result->fields[0]);			
$result = $CP["sql"]->Execute("SELECT * FROM propriete_villes ORDER BY villeNom ASC");
$pos = 0;

while (!$result->EOF)
	{   
	
	$script.= "array_villes[$pos]['id']='".$result->fields["villeID"]."';\r\n";
	$script.= "array_villes[$pos]['name']='".str_replace("'","\'",$result->fields["villeNom"])."';\r\n";
	$script.= "array_villes[$pos]['region']='".$result->fields["villeRegion"]."';\r\n";
	$result->MoveNext();
	$pos = $pos + 1;

	}

$CP["tpl"]->set_var("script",$script);


if (!isset($_GET["A"])) $_GET["A"] = "";
       
switch($_GET["A"])
{
	//une recherche a ete soumise
	case "chercher":
	  $resultParPage = 10;
		$CP["tpl"]->set_file("page","recherche_resultats.html",1);
		
		if (isset($_GET["POST"]))
			{
			$_POST = unserialize(base64_decode($_GET["POST"]));    
			}
			
		//les infos de recherche
		if (isset($_GET["pos"])) $pos = $_GET["pos"]; else $pos = 0;
		                                                             
		if ($_POST["motcle"] != "")
			$query = "SELECT * FROM proprietes,utilisateurs WHERE proprieteUtilisateur=utilisateurs.utilisateurID AND  proprieteDescription LIKE '%".addslashes($_POST["motcle"])."%' ";
		else
			$query = "SELECT * FROM proprietes,utilisateurs WHERE proprieteUtilisateur=utilisateurs.utilisateurID ";
		
		$prixMax = addslashes($_POST["prixMax"]);
		$prixMax = str_replace(" ","",$prixMax);
		$prixMin = addslashes($_POST["prixMin"]);
		$prixMin = str_replace(" ","",$prixMin); 
		$prixMin = $prixMin + 0;
		$prixMax = $prixMax + 0;
		
		$ville   = addslashes($_POST["ville"]);
		$region  = addslashes($_POST["region"]);
		$type    = addslashes($_POST["typePropriete"]);
		$avecPhoto   = addslashes($_POST["avecPhoto"]);
		
		if ($type != '%')
			$query.= " AND proprieteType = '$type'";
		
		if ($region != '%')
			$query.= " AND proprieteRegion = '$region'";
			 
		if ($ville != '%')
			$query.= " AND proprieteVille = '$ville'";
			
			
		if ($avecPhoto == "oui")
		  $query.=" AND proprietePhotoType <> ''";
		
    $query.= " AND proprieteActif=1 AND (proprietePrix >= $prixMin AND proprietePrix <= $prixMax)";
		$query.= " LIMIT ".$pos."," . $resultParPage;
		
		$result = $CP["sql"]->Execute($query);
		
		//gestion des pages suivantes/precedentes
			$query = str_replace("SELECT * FROM","SELECT COUNT(*) FROM",$query);
		$query = str_replace(" LIMIT ".$pos.",".$resultParPage,"",$query);
		$result2 = $CP["sql"]->Execute($query);

		$POST = base64_encode(serialize($_POST));	      	
		$nbResultats = $result2->fields[0];
		$pagesBar = "";
		for ($x=0;$x<ceil($nbResultats/$resultParPage);$x++)
		{                      
			if ($x == ($pos/$resultParPage))
			$pagesBar .= " ".($x+1)." |";
			else
			$pagesBar .= " <a href='?A=chercher&pos=".($x*$resultParPage)."&POST=".$POST."'>".($x+1)."</a> |";
		}

		//si il y a une page precedente
		if ($pos > 0)  
		{
			$CP["tpl"]->set_var("backPage","");	                                       
			$CP["tpl"]->set_var("backPageURL","href=\"recherche.php?A=chercher&pos=".($pos-$resultParPage)."&POST=".$POST."\"");
		}
		else
		{
			$CP["tpl"]->set_var("backPage","_inactif");	
			$CP["tpl"]->set_var("backPageURL","");
		}
		
		//si il y a une page suivante		        
		if ( $nbResultats > ($pos+$resultParPage))
		{  
			$CP["tpl"]->set_var("nextPage","");	 
			$CP["tpl"]->set_var("nextPageURL","href=\"recherche.php?A=chercher&pos=".($pos+$resultParPage)."&POST=".$POST."\"");
		}
		else                     
		{                        
			$CP["tpl"]->set_var("nextPage","_inactif");				
			$CP["tpl"]->set_var("nextPageURL","DEBUG2");
		}
				
		$CP["tpl"]->set_var("numeroPages",$pagesBar);
		
		
		$proprietes = array();
		while (!$result->EOF)
		{       
		$result2 = $CP["sql"]->Execute("SELECT utilisateurID FROM utilisateurs WHERE utilisateurID='".$result->fields["proprieteUtilisateur"]."'");	
		if ($result2->fields[0] == "")	
			{        
			$result->MoveNext();
			continue;
			}
			
		$result2 = $CP["sql"]->Execute("SELECT * FROM propriete_types WHERE typeID='".$result->fields["proprieteType"]."'");
		$result->fields["proprieteType"] = $result2->fields["typeNom"];
		if ($result->fields["proprieteType"] == "") $result->fields["proprieteType"] = $result->fields["proprieteTypeAutre"];
		
		
		$oVille = $CP["sql"]->Execute("SELECT * FROM propriete_villes WHERE villeID='".$result->fields["proprieteVille"]."'");
		$sVille = $oVille->fields["villeNom"];
		if ($sVille == "") $sVille = $result->fields["proprieteVilleAutre"];
		
		$oRegion = $CP["sql"]->Execute("SELECT * FROM propriete_regions WHERE regionID='".$result->fields["proprieteRegion"]."'");
		$sRegion = $oRegion->fields["regionNom"];
		
		if ($result->fields['proprieteVendu'] == 0)
			{
			$result->fields['proprieteImage']	= "<a href=\"propriete.php?A={$result->fields['proprieteID']}\"><img src=\"showimg.php?Z=1&A={$result->fields['proprieteID']}\" alt=\"\" align=\"right\" border=\"0\"></a>";
			$result->fields['proprietePrix']    = str_replace(",", " ", number_format(str_replace(" ", "", $result->fields['proprietePrix']))) . "$";
		  	$result->fields['proprieteNum']     = "#".$result->fields['proprieteID'];
			$result->fields['proprieteAdresse'] = "$sVille, $sRegion";
			$result->fields['boutonDetails']    = "<a href=\"propriete.php?A={$result->fields['proprieteID']}\"><img onmouseover=\"modifierBoutonImage(this);\" onmouseout=\"modifierBoutonImage(this);\" src=\"images/boutons/bt_details.gif\" alt=\"details\" name=\"details_{$result->fields['proprieteID']}\" border=\"0\"></a></div>";
			}
		  else
			{
			$result->fields['proprieteImage']	= "<img src=\"showimg.php?Z=1&A={$result->fields['proprieteID']}\" alt=\"\" align=\"right\" border=\"0\">";
			$result->fields['proprieteNum']	    = "<font color='red'><b>VENDU!</b></font>&nbsp;";
			$result->fields['proprietePrix']    = "";
			$result->fields['proprieteAdresse'] = "$sVille, $sRegion";
			$result->fields['boutonDetails']    = "&nbsp;</div>";
			}
		
		$proprietes[] = $result->fields;
		
		$result->MoveNext();
		}         
		
		
		$CP["tpl"]->set_loop("proprietes",$proprietes);
		if (count($proprietes) != 0)
			 $CP["tpl"]->set_var("block",$CP["tpl"]->process("","endblock",2));
			 else
			 $CP["tpl"]->set_var("block","");
					
		break;

	default:
		// assignation de la ville                      
		$villes = array();                                    
		$result = $CP["sql"]->Execute("SELECT * FROM propriete_villes ORDER BY villeNom ASC");
		while (!$result->EOF)
			{                   
			$villes[] = $result->fields;
			$result->MoveNext();	
			}
		$CP["tpl"]->set_loop("villes",$villes);
		
		$regions = array();                                    
		$result = $CP["sql"]->Execute("SELECT * FROM propriete_regions ORDER BY regionNom ASC");
		while (!$result->EOF)
			{                   
			$regions[] = $result->fields;
			$result->MoveNext();	
			}
		
		$CP["tpl"]->set_loop("regions",$regions);
		
		$types = array();                                    
		$result = $CP["sql"]->Execute("SELECT * FROM propriete_types ORDER BY typeNom ASC");
		while (!$result->EOF)
			{                   
			$types[] = $result->fields;
			$result->MoveNext();	
			}
		
		$CP["tpl"]->set_loop("types",$types);
		
		$CP["tpl"]->set_file("page","recherche.html");
	break;
}


// affichage du rendu
print $CP["tpl"]->process("","page",2);

?>