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

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

$template->set("DOSSIER_TROUVE", false);
if(isset($_GET["id"])){
	$id = mysql_real_escape_string($_GET["id"]);
	
	$q = mysql_query("	SELECT * 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_meubles ON propriete_meubles.propriete_meuble_id = proprietes.meuble
						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_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_types ON propriete_types.propriete_type_id = proprietes.type
						LEFT JOIN propriete_unites  ON propriete_unites.propriete_unite_id  = proprietes.unite
						LEFT JOIN villes ON villes.ville_id = proprietes.ville
						WHERE proprietes.dossier = '".$id."'") or die(mysql_error());
						
	if(mysql_num_rows($q)>0){
		$row = mysql_fetch_assoc($q);
		foreach($row as $key=>$value){
			$row[$key] = stripslashes($value);
		}
		
		$template->set("ID", $id);
		
		$row["photos"] = array();
		$row["photosI"] = "";
		for($i=1; $i<=21; $i++){
			if (!empty($row['photo'.$i])){
				$file_parts = pathinfo('images-loc/'.$row["photo".$i]);
				$row["photos"][] = 'scaled/'.$file_parts["filename"].'-###.'.$file_parts['extension'];
				
				$initial = 'scaled/'.$file_parts["filename"].'-400.'.$file_parts['extension'];
				$row["photosI"] .= '<li><a href="'.$initial.'"><img border="0" src="'.$initial.'" width="400" /></a></li>';
			}
		}
		$row["photos"] = json_encode($row["photos"]);
		
		// Set immobilier
		$row["MOBILIER"] = $row['meuble'];
		// Change case for template
		$row = array_change_key_case($row, CASE_UPPER);
		
		$row["PERIODES"] = "";
		$propriete_id = $row["PROPRIETE_ID"];
		$q = mysql_query("SELECT * FROM propriete_periodes WHERE propriete_id = '".$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>';
		}
		
		$prop_types = explode(",", $row["TYPE"]);
		$q = mysql_query("SELECT * FROM propriete_types") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if(array_search($row_["propriete_type_id"], $prop_types) !== false){
				if(!isset($slider))	$slider = $row_["propriete_type_".$locale];
				
				$template->set_block("types", array(
					"TYPE"	=>	$row_["propriete_type_".$locale]
				));
			}
		}
		// Set header type
		$template->set("SLIDER", $slider);

		$q = mysql_query("SELECT * FROM propriete_etages") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_etage_id"] == $row["ETAGE"]){
				$row["ETAGE"] = $row_["propriete_etage_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_unites") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_unite_id"] == $row["UNITE"]){
				$row["UNITE"] = $row_["propriete_unite_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_meubles") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_meuble_id"] == $row["MEUBLE"]){
				$row["MEUBLE"] = $row_["propriete_meuble_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_piscine") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_piscine_id"] == $row["PISCINE"]){
				$row['PISCINE'] = $row_["propriete_piscine_type_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_spa") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_spa_id"] == $row["SPA"]){
				$row['SPA'] = $row_["propriete_spa_type_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_ski_in") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_ski_in_id"] == $row["SKI_IN"]){
				$row['SKI_IN'] = $row_["propriete_ski_in_type_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_ski_out") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_ski_out_id"] == $row["SKI_OUT"]){
				$row['SKI_OUT'] = $row_["propriete_ski_out_type_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_bord_eau") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row["BORD_EAU"] == $row_["propriete_bord_eau_id"]){
				$row["BORD_EAU"] = $row_["propriete_bord_eau_type_".$locale];
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_services_bbq") or die(mysql_error());
		$bbq = "";
		while($row_ = mysql_fetch_array($q)){
			if($row["EQ_BBQ1"] != 1 && $row["EQ_BBQ1"]==$row_["propriete_services_bbq_id"]){
				$bbq = $row_["propriete_services_bbq_type_".$locale];
			}
			if($row["EQ_BBQ2"] != 1 && $row["EQ_BBQ2"]==$row_["propriete_services_bbq_id"]){
				$bbq .= " - ".$row_["propriete_services_bbq_type_".$locale];
			}
		}
		if(empty($bbq)) $bbq="Aucun";
		$row["BBQ"] = $bbq;
		
		$q = mysql_query("SELECT * FROM propriete_services_bbq") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_services_bbq_id"] == $row["PROP_BBQ_TYPE"]){
				$template->set("BBQ_TYPE", $row_["propriete_services_bbq_type_".$locale]);
			}
		}
		
		$q = mysql_query("SELECT * FROM propriete_services_chauffage") or die(mysql_error());
		while($row_ = mysql_fetch_array($q)){
			if($row_["propriete_services_chauffage_id"] == $row["PROP_CHAUFFAGE_TYPE"]){
				$template->set("CHAUFFAGE_TYPE", $row_["propriete_services_chauffage_type_".$locale]);
			}
		}
		
		$q = mysql_query("SELECT `propriete_aqueduc_type_".$locale."` AS `aqueduc` FROM propriete_aqueduc WHERE `propriete_aqueduc_id` = '".$row["AQUEDUC"]."'") or die(mysql_error());
		$row_ = mysql_fetch_array($q);
		$template->set("AQUEDUC", $row_["aqueduc"]);
		
		$q = mysql_query("SELECT `propriete_puit_type_".$locale."` AS `puit` FROM propriete_puit WHERE `propriete_puit_id` = '".$row["PUITS"]."'") or die(mysql_error());
		$row_ = mysql_fetch_array($q);
		$template->set("PUIT", $row_["puit"]);
		
		$template->set_block("dossier", $row);
		$template->set("DOSSIER_TROUVE", true);
		
		/* Est-ce qu'il y a une location ? */
		if($IN_ADMIN){
			$q = mysql_query("SELECT `location_id` FROM `locations` WHERE `propriete_id` = '".intval($propriete_id)."' AND `date_arrivee` <= NOW() AND `date_depart` >= NOW()") or die(mysql_error());
			if(mysql_num_rows($q) > 0){
				$row = mysql_fetch_assoc($q);
				$template->set("PROP_LOUE", true);
				$template->set("LOCATION_ID", $row["location_id"]);
			}
			else{
				$template->set("PROP_LOUE", false);
			}
		}
	}
}

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