<?
require("includes/config.php");

$template->set_filenames(array(
	'body' => 'a_louer.html'
));

$q = mysql_query("SELECT * FROM villes ORDER BY ville_nom ASC") or die(mysql_error());
while($row = mysql_fetch_array($q)){
	$template->set_block("villes", array(
		"ID"	=>	$row["ville_id"],
		"NOM"	=>	$row["ville_nom"]
	));
	
	if($row["ville_id"] == intval($_GET["ville"])){
		$template->set("CITY_NAME", $row["ville_nom"]);
	}
}

$template->set("CITY", $_GET["ville"]);

if(isset($_GET["type"])){
	$template->set("IN_SEARCH", true);	
	
	$type = $_GET["type"];
	if($locale == "en"){
		switch($type){
			case "Chalet":
				$type = "Cottage";
			break;
			
			case "Condo":
				$type = "Condo";
			break;
			
			case "Maison":
				$type = "House";
			break;
			
			case "Loft":
				$type = "Loft";
			break;
			
			case "Logement":
				$type = "Appartment";
			break;
		}
	}
	$template->set("TYPE", $type);
	$template->set("SLIDER", $_GET["type"]);
}
else{
	// 1 Maison
	// 2 Condo
	// 4 Chalet
	// 5 Logement
	// 6 Loft
	$maison = 0;
	$condo = 0;
	$chalet = 0;
	$logement = 0;
	$loft = 0;
	
	$WHERE = "WHERE etat = '2'";
	
	if(isset($_GET["ville"])){	
		$WHERE .= " AND ville = '".intval($_GET["ville"])."' ";
	}
	
	$q = mysql_query("SELECT COUNT(*) AS total, type FROM proprietes $WHERE GROUP BY type ASC") or die(mysql_error());
	while($row = mysql_fetch_array($q)){
		$r = explode(",", $row["type"]);
		
		// For each type of the row
		for($i = 0; $i<count($r); ++$i){
			switch($r[$i]){
				case 1:	$maison += $row["total"]; break;
				case 2:	$condo += $row["total"]; break;
				case 4:	$chalet += $row["total"]; break;
				case 5:	$logement += $row["total"]; break;
				case 6:	$loft += $row["total"]; break;
			}
		}
	}
	
	$template->set("MAISON_COUNT", $maison);
	$template->set("CONDO_COUNT", $condo);
	$template->set("CHALET_COUNT", $chalet);
	$template->set("LOGEMENT_COUNT", $logement);
	$template->set("LOFT_COUNT", $loft);
}

$template->display('head');
$template->display('body');
$template->display('foot');
?>