<?
require("includes/config.php");
require("includes/TCPDF/tcpdf.php");
require("includes/TCPDF/llbpdf.php");
require("includes/TCPDF/config/lang/eng.php");

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

$template->set("DOSSIER_TROUVE", false);
if(isset($_GET["id"])){
	$PDF_DOSSIER = $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);
		$PRINT_HEADER_TYPE = $row["propriete_type"];

		// create new PDF document
		$pdf = new LLBPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, $IN_ADMIN?"LEGAL":"A4", true, 'UTF-8', false);

		// set document information
		$pdf->SetCreator(PDF_CREATOR);
		$pdf->SetAuthor('Khalife Dany');
		$pdf->SetTitle('Fiche détaillée');
		$pdf->SetSubject('Fiche détaillée');

		$pdf->AddPage();

		// set header and footer fonts
		$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
		$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));

		// set default monospaced font
		$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

		$pdf->SetMargins(34, 55, 55);
		$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
		$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);

		//set auto page breaks
		$pdf->SetAutoPageBreak(FALSE, PDF_MARGIN_BOTTOM);
		
		$f = $pdf->getFontSizePt();
		$x = $pdf->GetX();
		$y = $pdf->GetY();
		$pdf->SetXY(157, 52);
		$pdf->setFontSize(12);
		$pdf->Cell(50, 12, date("d/m/Y"));
		$pdf->SetX($x);
		$pdf->SetY($y);
		$pdf->setFontSize($f);
		
		ob_start();
		
		foreach($row as $key=>$value){
			$row[$key] = stripslashes($value);
		}
		
		// Set immobilier
		$row["mobilier"] = $row['meuble'];

		$q = mysql_query("SELECT * FROM propriete_periodes WHERE propriete_id = '".$row["propriete_id"]."'") or die(mysql_error());
		while($row2 = mysql_fetch_array($q)){
			$template->set_block("periodes", array(
				"PERIODE_FR"		=> 	$row2["periode_fr"],
				"PERIODE_EN"		=> 	$row2["periode_en"],
				"DATE_DEBUT"		=> 	$row2["debut"],
				"DATE_FIN"			=> 	$row2["fin"],
				"MONTANT"			=> 	is_numeric($row2["montant"])?number_format($row2["montant"], 0, '.', ' '):$row2["montant"]
			));
		}
		
		$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_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_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_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=($locale == "fr")?"Aucun":"None";
		$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]);
			}
		}
		
		$row = array_change_key_case($row, CASE_UPPER);
		$template->set_block("dossier", $row);
	
		$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->display("body");
		$html = ob_get_clean();
		$html = explode("<!-- NEWPAGE -->", $html);

		$pdf->writeHTML($html[0], true, false, true, false, '');

		// Image
		try{
			$q = mysql_query("SELECT `photo1` FROM propriete_photos WHERE `propriete_id` = '".$row["PROPRIETE_ID"]."'") or die(mysql_error());
			$photos = mysql_fetch_array($q);
			$image_file = K_PATH_IMAGES.'../../../images-loc/'.$photos["photo1"];

			$pdf->setX(300);
			$pdf->setY(78);
		
			$pdf->Image($image_file, '', '', 52, 30, '', '', 'N', false, 300, 'L', false, false, 0, false, false, false);
		}catch(Exception $e){}
		
		$pdf->AddPage();
		$pdf->SetFont('', '', 9, '', 'default', true);
		$pdf->writeHTML($html[1], true, false, true, false, '');
	
		// Close and output PDF document
		// This method has several options, check the source code documentation for more information.
		$pdf->Output('fiche_détaillée.pdf', 'I');	
		exit;
	}
}

die("Dossier non trouvé!");
?>