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

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

$COUNT = "SELECT COUNT(*) AS total ";
$SELECT = "SELECT * ";
$FROM = "FROM proprietes
		LEFT JOIN propriete_equipements ON propriete_equipements.propriete_id = proprietes.propriete_id
		LEFT JOIN propriete_etages ON propriete_etages.propriete_etage_id = proprietes.etage
		LEFT JOIN propriete_etats ON propriete_etats.propriete_etat_id = proprietes.etat
		LEFT JOIN propriete_inclus ON propriete_inclus.propriete_id = proprietes.propriete_id
		LEFT JOIN propriete_lits ON propriete_lits.propriete_id = proprietes.propriete_id
		LEFT JOIN propriete_photos ON propriete_photos.propriete_id = proprietes.propriete_id
		LEFT JOIN propriete_pieces ON propriete_pieces.propriete_id = proprietes.propriete_id
		LEFT JOIN propriete_fumeurs ON propriete_fumeurs.propriete_fumeur_id = proprietes.fumeur
		LEFT JOIN propriete_meubles ON propriete_meubles.propriete_meuble_id = proprietes.meuble
		LEFT JOIN propriete_animaux ON propriete_animaux.propriete_animaux_id = proprietes.animaux
		LEFT JOIN propriete_remarques ON propriete_remarques.propriete_id = proprietes.propriete_id
		LEFT JOIN propriete_services ON propriete_services.propriete_id = proprietes.propriete_id
		LEFT JOIN propriete_services_bbq ON propriete_services_bbq.propriete_services_bbq_id = propriete_services.prop_bbq_type
		LEFT JOIN propriete_services_chauffage ON propriete_services_chauffage.propriete_services_chauffage_id = propriete_services.prop_chauffage_type
		LEFT JOIN propriete_unites ON propriete_unites.propriete_unite_id  = proprietes.unite
		LEFT JOIN villes ON villes.ville_id = proprietes.ville
		LEFT JOIN propriete_types ON propriete_types.propriete_type_id = proprietes.type";
$ORDER = " ORDER BY ABS(chambres), dossier ";
$GROUP = "";

$first = 0;
$page = 1;
if(isset($_GET["page"]) && $_GET["page"] > 0){
	$first = ($_GET["page"]-1) * MAX_ROWS;
	$page = ($_GET["page"]-1) + 1;
}

$LIMIT = " LIMIT $first, ".MAX_ROWS;

if(isset($_GET["location"]) && $_GET["location"]=="true"){
	$type = mysql_real_escape_string($_GET["type"]);
	$occupants=intval($_GET["occupants"]);
	$chambres=intval($_GET["chambres"]);
	$meubles=intval($_GET["meubles"]);
	$ville=intval($_GET["ville"]);
	$periode=mysql_real_escape_string($_GET["periode"]);
	
	$WHERE = " 1 ";
	if(empty($_SESSION['ADMIN_USER'])){
		$WHERE .= " AND etat = '2' ";
	}
	else{
		$WHERE .= " AND etat != '4' ";
	}
	
	$search = array();
	$track = array();
	
	if(!empty($ville)){
		$template->set("VILLE", $ville);
		array_push($track,"ville=".$ville);

		$qq = mysql_query("SELECT ville_nom FROM villes WHERE ville_id = '".$ville."'");
		$rrow = mysql_fetch_array($qq);
		array_push($search,$rrow["ville_nom"]);
		
		$WHERE .= " AND ville = $ville ";
	}
	
	if(!empty($type)){
		if($locale == "fr"){
			$tranType = $type."s";
		}
		else{
			switch($type){
				case "Chalet":
					$tranType = "Cottages";
				break;
				
				case "Condo":
					$tranType = "Condos";
				break;
				
				case "Maison":
					$tranType = "Houses";
				break;
				
				case "Loft":
					$tranType = "Lofts";
				break;
				
				case "Logement":
					$tranType = "Appartments";
				break;
			}
		}
	
		array_push($search,$tranType);
		array_push($track,"type=".$type);
		
		$_TYPES = array();
		$qq = mysql_query("SELECT * FROM `propriete_types`");
		while($r = mysql_fetch_assoc($qq)){
			$_TYPES[strtolower($r["propriete_type_$locale"])] = $r["propriete_type_id"];
		}
		
		$WHERE .= " AND (`proprietes`.`type` = '".$_TYPES[strtolower($type)]."' OR `proprietes`.`type` LIKE '".$_TYPES[strtolower($type)].",%' OR `proprietes`.`type` LIKE '%,".$_TYPES[strtolower($type)]."' OR `proprietes`.`type` LIKE '%,".$_TYPES[strtolower($type)].",%') ";
	}
	
	if(!empty($periode)){
		array_push($track,"periode=".$periode);
		switch($periode){
			case "semaine_ete" : 
				$periode_n="Semaine été";
			break;

			case "mois_ete" : 
				$periode_n="Mois été";
			break;

			case "saison_ete" : 
				$periode_n="Saison été";
			break;

			case "semaine_hiver" : 
				$periode_n="Semaine hiver";
			break;

			case "mois_hiver" : 
				$periode_n="Mois hiver";
			break;

			case "saison_hiver" : 
				$periode_n="Saison hiver";
			break;

			case "fetes" : 
				$periode_n="Fêtes";
			break;

			case "relache" : 
				$periode_n="Relâche";
			break;

			case "week_end" : 
				$periode_n="Week end";
			break;

			case "annee" : 
				$periode_n="Année";
			break;
		}
		array_push($search,$periode_n);
		$GROUP = " GROUP BY propriete_periodes.propriete_id ";
		$WHERE .= " AND propriete_periode_type = '$periode' ";
		$FROM = "FROM propriete_periodes
				LEFT JOIN propriete_periodes_types ON propriete_periodes_types.periodes_types_id  = propriete_periodes.type
				LEFT JOIN proprietes ON proprietes.propriete_id = propriete_periodes.propriete_id
				LEFT JOIN propriete_equipements ON propriete_equipements.propriete_id = proprietes.propriete_id
				LEFT JOIN propriete_etages ON propriete_etages.propriete_etage_id = proprietes.etage
				LEFT JOIN propriete_etats ON propriete_etats.propriete_etat_id = proprietes.etat
				LEFT JOIN propriete_types ON propriete_types.propriete_type_id = proprietes.type
				LEFT JOIN propriete_inclus ON propriete_inclus.propriete_id = proprietes.propriete_id
				LEFT JOIN propriete_lits ON propriete_lits.propriete_id = proprietes.propriete_id
				LEFT JOIN propriete_photos ON propriete_photos.propriete_id = proprietes.propriete_id
				LEFT JOIN propriete_pieces ON propriete_pieces.propriete_id = proprietes.propriete_id
				LEFT JOIN propriete_fumeurs ON propriete_fumeurs.propriete_fumeur_id = proprietes.fumeur
				LEFT JOIN propriete_meubles ON propriete_meubles.propriete_meuble_id = proprietes.meuble
				LEFT JOIN propriete_animaux ON propriete_animaux.propriete_animaux_id = proprietes.animaux
				LEFT JOIN propriete_remarques ON propriete_remarques.propriete_id = proprietes.propriete_id
				LEFT JOIN propriete_services ON propriete_services.propriete_id = proprietes.propriete_id
				LEFT JOIN propriete_services_bbq ON propriete_services_bbq.propriete_services_bbq_id = propriete_services.prop_bbq_type
				LEFT JOIN propriete_services_chauffage ON propriete_services_chauffage.propriete_services_chauffage_id = propriete_services.prop_chauffage_type
				LEFT JOIN villes ON villes.ville_id = proprietes.ville
				LEFT JOIN propriete_unites ON propriete_unites.propriete_unite_id  = proprietes.unite";
	}
	
	if(!empty($occupants)){
		array_push($track,"occupants=".$occupants);
		switch($occupants){
			case 2 :
				array_push($search,"2 - 5 Occupants");
				$WHERE .= " AND occupation_max >= 2 AND occupation_max <= 5 ";
			break;
			
			case 6 :
				array_push($search,"6 - 10 Occupants");
				$WHERE .= " AND occupation_max >= 6 AND occupation_max <= 10 ";
			break;
			
			case 11 :
				array_push($search,"11 - 16 Occupants");
				$WHERE .= " AND occupation_max >= 11 AND occupation_max <= 16 ";
			break;
			
			case 17 :
				array_push($search,"17+ Occupants");
				$WHERE .= " AND occupation_max >= 17 ";
			break;
		}
	}
	
	if(!empty($chambres)){
		array_push($track,"chambres=".$chambres);
		if($chambres<5){
			array_push($search,"$chambres Chambres");
			$WHERE .= " AND chambres = $chambres ";
		}
		else{
			array_push($search,"$chambres+");
			$WHERE .= " AND chambres >= $chambres ";
		}
	}

	if(isset($meubles) && !empty($meubles)){
		array_push($track,"meubles=".$meubles);
		switch($meubles){
			case 1 :
				array_push($search,"Meublé");
				$WHERE .= " AND (meuble = 2 OR meuble = 5) ";
			break;
			
			case 2 :
				array_push($search,"Semi Meublé");
				$WHERE .= " AND (meuble = 1 OR meuble = 4) ";
			break;
			
			case 3 :
				array_push($search,"Non Meublé");
				$WHERE .= " AND (meuble = 3 OR meuble = 4 OR meuble = 5) ";
			break;
			
			case 4 :
				array_push($search,"Meublé ou Non Meublé");
				$WHERE .= " AND (meuble = 2 OR meuble = 3 OR meuble = 5) ";
			break;
			
			case 5 :
				array_push($search,"Semi Meublé ou Non Meublé");
				$WHERE .= " AND (meuble = 1 OR meuble = 3 OR meuble = 4) ";
			break;
			
			case 6 :
				array_push($search,"Meublé ou Semi Meublé");
				$WHERE .= " AND (meuble = 1 OR meuble = 2 OR meuble = 6) ";
			break;
		}
	}
	
	// Build $search
	if(count($search)==0){
		$search = "Tous";
	}
	else{
		$tmp = "";
		for($i=0; $i<count($search); $i++){
			$tracks = "";
			for($j=0; $j<=$i; $j++){
				$tracks .= "&".$track[$j];
			}
			$tmp .= "<u><a href='".$_SERVER['SCRIPT_NAME']."?location=true".$tracks."'>".$search[$i]."</a></u>";
			if($i<count($search)-1)
				$tmp .= "&nbsp;&gt;&nbsp;";
		}
		$search = $tmp;
	}
}

if(isset($_GET["qsearch"]) && $_GET["qsearch"]=="true"){
	$search = mysql_real_escape_string($_REQUEST["s"]);
	$WHERE = " dossier LIKE '%$search%' ";

	if(empty($_SESSION['ADMIN_USER'])){
		$WHERE .= " AND etat='2' ";
	}
	if(empty($search)){
		$search = "Tous";
	}
	$search = "<u><a href='".$_SERVER['SCRIPT_NAME']."?scroll&qsearch=true&s=".$search."'>".$search."</a></u>";
}

if(isset($WHERE) && !empty($WHERE)){
	$WHERE = " WHERE ".$WHERE;
}

$sql = $SELECT . $FROM . $WHERE . $GROUP . $ORDER . $LIMIT;

$q1 = mysql_query($sql) or die(mysql_error());

$sql = $COUNT . $FROM . $WHERE;

$q2 = mysql_query($sql);
$row = mysql_fetch_array($q2);
$total = $row["total"];

$template->set("NO_HEADER", isset($_GET["noheader"]));

$index = 0;
if(isset($q1) && mysql_num_rows($q1)>0){
	$template->set("FOUND_RESULTS", true);
	$template->set("SEARCH", $search);
	$template->set("TOTAL", $total);
	$template->set("PAGINATION", insert_pagination($page,$total,false,"",MAX_ROWS,"","",false));
	
	$BORD_EAU = array();
	$qx = mysql_query("SELECT * FROM propriete_bord_eau") or die(mysql_error());
	while($row_ = mysql_fetch_array($qx)){
		$BORD_EAU[$row_["propriete_bord_eau_id"]] = $row_["propriete_bord_eau_type_".$locale];
	}
	
	$PISCINE = array();
	$qx = mysql_query("SELECT * FROM propriete_piscine") or die(mysql_error());
	while($row_ = mysql_fetch_array($qx)){
		$PISCINE[$row_["propriete_piscine_id"]] = $row_["propriete_piscine_type_".$locale];
	}
	
	$SPA = array();
	$qx = mysql_query("SELECT * FROM propriete_spa") or die(mysql_error());
	while($row_ = mysql_fetch_array($qx)){
		$SPA[$row_["propriete_spa_id"]] = $row_["propriete_spa_type_".$locale];
	}
	
	$SKI_IN = array();
	$qx = mysql_query("SELECT * FROM propriete_ski_in") or die(mysql_error());
	while($row_ = mysql_fetch_array($qx)){
		$SKI_IN[$row_["propriete_ski_in_id"]] = $row_["propriete_ski_in_type_".$locale];
	}
	
	$SKI_OUT = array();
	$qx = mysql_query("SELECT * FROM propriete_ski_out") or die(mysql_error());
	while($row_ = mysql_fetch_array($qx)){
		$SKI_OUT[$row_["propriete_ski_out_id"]] = $row_["propriete_ski_out_type_".$locale];
	}
	
	while($row=mysql_fetch_array($q1)){
		$row["index"] = ++$index;
		$row['dossier'] = trim($row['dossier']);
		
		// Set immobilier
		$row["MOBILIER"] = $MOBILIER[$row['meuble']];
		$row["BORD_EAU"] = $BORD_EAU[$row['bord_eau']];
		$row["PISCINE"] = $BORD_EAU[$row['piscine']];
		$row["SPA"] = $BORD_EAU[$row['spa']];
		$row["SKI_IN"] = $BORD_EAU[$row['ski_in']];
		$row["SKI_OUT"] = $BORD_EAU[$row['ski_out']];
		
		$row["PERIODES"] = "";
		$q = mysql_query("SELECT * FROM propriete_periodes WHERE propriete_id = '".$row["propriete_id"]."' ORDER BY periode_id") or die(mysql_error());
		while($row2 = mysql_fetch_array($q)){
			$row["PERIODES"] .= '<tr>
									<td>'.$row2["periode_".$locale].'</td>
									<td style="text-align: left;">'.$row2["debut"].'</td>
									<td style="text-align: left;">'.$row2["fin"].'</td>
									<td style="text-align: right;">';
			
			if(is_numeric($row2["montant"])){
				$row["PERIODES"] .= number_format($row2["montant"], 0, '.', ' ');
			}
			else{
				$row["PERIODES"] .= $row2["montant"];
			}
									
			$row["PERIODES"] .= ' $</td></tr>';
		}

		$row = array_change_key_case($row, CASE_UPPER);
		$template->set_block("results", $row);
	}
}

if(!isset($_GET["qsearch"])){
	$template->set("BACK_URL", base64_encode("/recherche.php?location=".$_GET["location"]."&type=".$_GET["type"]."&occupants=".$_GET["occupants"]."&chambres=".$_GET["chambres"]."&meubles=".$_GET["meubles"]."&periode=".$_GET["periode"]."&page=".$_GET["page"]));
}
else{
	$template->set("BACK_URL", base64_encode("/recherche.php?qsearch=true&s=".mysql_real_escape_string($_REQUEST["s"])));
}

if (!isset($_GET["noheader"])){
	$template->display('head');
}
$template->display('body');
if (!isset($_GET["noheader"])){
	$template->display('foot');
}
?>