<?php
require "cfg/cfg.php";
require "./common.php";

$id=$_GET['id'];
if ($id=="") {  die('ERROR 1004: non valid function call');}
apridb();
//registrazione visita
stat_aggiorna($_GET['id'],date("Y"),date("m"),1,0,0);
//estrazione dati attività
$qry="select * from hotel WHERE visibile AND id='$id'";
$res=eseguiqry($qry);
$q=quanterighe($res);
$arr=leggiriga($res);
if ($q<=0) {  die('ERROR 1005: non valid function call');}

$title=ucfirst(show_categoria($arr['categoria']))." ".ucfirst($arr['nome'])." (".ucfirst($arr['paese']).", ".ucfirst($arr['provincia'])." - ".$_SESSION['lGenerDescription4'].")";
$description=ucfirst(show_categoria($arr['categoria']))." ".ucfirst($arr['nome']).$_SESSION['lGenerDescription2'].ucfirst($arr['paese'])." (".ucfirst($arr['provincia']).", ".$_SESSION['lGenerDescription4'].")".$_SESSION['lGenerDescription3'];
$keywords=ucfirst(show_categoria($arr['categoria'])).", ".ucfirst($arr['nome']).", ".ucfirst($arr['paese']).", ".ucfirst($arr['provincia']).", ".$_SESSION['lGenerDescription4'].".";

include "filecomuni/_prehead.html";

if ($arr['lon']!=0 && $arr['lat']!=0) {
	$nome_gmap=str_replace("'","\'",$arr['nome']);
	$paese_gmap=str_replace("'","\'",$arr['paese']);
	$frazione_gmap=str_replace("'","\'",$arr['frazione']);
	$sitoweb_gmap=str_replace("/","\/",$arr['sitoweb']);
?>
	<script src="http://maps.google.com/maps?file=api&v=2&key=<?=get_gmap_key()?>" type="text/javascript"></script>	
	<script type="text/javascript">
	function load() {
	      var WINDOW_HTML = '<div style="width: 270px; padding-right: 10px"><div align="center"><font color="#000000"><?=show_categoria($arr['categoria'])?> <?=$nome_gmap?><\/font><br><font color="#004F9D"><?=($frazione_gmap?$frazione_gmap." di ":"")?> <?=$paese_gmap?><\/font> - <font color="#004F9D">Lago di Garda<\/font><br><a href="http://www.gardalove.com/website.php?id=<?=$id?>" target="_blank"><font color="#009900"><?=$sitoweb_gmap?><\/font><\/a><\/div>';
	      if (GBrowserIsCompatible()) {
	        var map = new GMap2(document.getElementById("map"));
	        map.addControl(new GLargeMapControl());
			map.addControl(new GMapTypeControl());
	        map.setCenter(new GLatLng(<?=$arr['lat']?>,<?=$arr['lon']?>), 12);
	        var point = new GLatLng(<?=$arr['lat']?>,<?=$arr['lon']?>);  
	        var marker = new GMarker(point);
			//map.addOverlay(new GMarker(point));
		    map.addOverlay(marker);
			marker.openInfoWindowHtml(WINDOW_HTML);
	      }
	}
	</script>
<?php
} else {
?>
	<script type="text/javascript">
	function load() {
	}
	</script>
<?php
}
include "filecomuni/_posthead.html";
include "filecomuni/_top.html";
?>
<TABLE cellspacing="0" cellpadding="0" border="0" width="100%"><TR>
<TD width="10%" valign="top">

	<?php include "filecomuni/_menu.html";?>
	<?php include "filecomuni/_menu2.html";?>

</TD>
<TD width="90%" valign="top" style="padding-left:2px;padding-right:2px;">
	<h1><?=$_SESSION['lVariePerSvegliarsi']?></h1>

	<table width="100%" cellpadding="5" cellspacing="0" border="0" class="bordotopsfondo"><tr><td align="center">
		<h2><?=ucfirst(show_categoria($arr['categoria']))?> <?=ucfirst($arr['nome'])?> - <?=($arr['frazione']?$arr['frazione']." di ":"")?> <?=ucfirst($arr['paese'])?> (<?=ucfirst($arr['provincia'])?>)</h2>
	</td></tr></table>
	<br style="line-height:3px;">

	<TABLE cellpadding="5" cellspacing="0" border="0"><TR>
		<TD>
<?php
		$pathimg1="http://www.gardalove.it/img_hotel/".$arr['id']."_1_".$arr['img1'];
		$pathimg2="http://www.gardalove.it/img_hotel/".$arr['id']."_2_".$arr['img2'];
		$pathimg3="http://www.gardalove.it/img_hotel/".$arr['id']."_3_".$arr['img3'];
		$pathimg4="http://www.gardalove.it/img_hotel/".$arr['id']."_4_".$arr['img4'];
		$pathimg5="http://www.gardalove.it/img_hotel/".$arr['id']."_5_".$arr['img5'];
		if ($arr['img1']) {
			$width=250;
			$height=188;
			$title=ucfirst(show_categoria($arr['categoria']))." ".$arr['nome']." ".$arr['paese'];
			echo "<A href=\"$pathimg1\" target=\"_blank\"><IMG src=\"".$pathimg1."\" width=\"$width\" height=\"$height\" title=\"$title\" alt=\"$title\"></A>";
		} else echo "<TABLE width=250 height=188 bgcolor=#e0e0e0><TR><TD>".$_SESSION['lErrNoImmagine']."</TD></TR></TABLE>";
?>
		</TD>
		<TD valign="top">
			<b><?=ucfirst(show_categoria($arr['categoria']))." ".$arr['nome']?></b><br>
			<?=$arr['indirizzo']?><br>
			<?=$arr['cap']?> <?=($arr['frazione']?$arr['frazione']." di ":"")?> <?=$arr['paese']?> (<?=$arr['provincia']?>)<br>
			Tel <?=$arr['tel']?><br>
			Fax <?=$arr['fax']?><br>
			<br>
			<?=($arr['sitoweb']?"www: <A href=\"http://www.gardalove.com/website.php?id=".$arr['id']."\" target=\"_blank\">".$arr['sitoweb']."</A><br>\n":"")?>
			<?=($arr['emailweb']?"email: <A href=\"email.php?id=".$arr['id']."\">".str_replace("@","<img src=img/at.gif border=0 width=8 height=9>",$arr['emailweb'])."</A><br>\n":"")?>
			<?=($arr['aggdati_dataora']!="0000-00-00 00:00:00"?"<br><i>(".$_SESSION['lCifreaggiornate']." ".dataformata($arr['aggdati_dataora']).")</i><br>\n":"")?>
		</TD>
	</TR></TABLE>
	<br>
<?php
if (strtotime($arr['lm_dal'])<=strtotime("+15 days",strtotime("now")) && strtotime($arr['lm_al'])>=strtotime("+15 days",strtotime("now")) && $arr['lm_prezzo']>0) {
?>
	<TABLE width="90%" cellpadding="0" cellspacing="0" border="0"><TR><TD style="background:#e0e0e0;">
		<h3><?=$_SESSION['lrisOffertaLastminute']?></h3>
		<P class="testoscheda_dettaglio">
			<FONT class="titololastminute">LASTMINUTE: <b><?=$arr['lm_prezzo']?></b> * <?=($arr['lm_prezzonormale']!=0?"<i><s>".$_SESSION['llasInvecedi']." ".$arr['lm_prezzonormale']."</s></i>":"")?></FONT><br>
			<i><?=$_SESSION['llasOffertavalida']?> <?=strtolower($_SESSION['llasDal'])?> <?=sql2date($arr['lm_dal'])?> <?=strtolower($_SESSION['llasAl'])?> <?=sql2date($arr['lm_al'])?></i><br>
			<?=$_SESSION['llasMinnotti']?>: <b><?=$arr['lm_minnotti']?></b><br>
			<?=$_SESSION['llasMinpersone']?>: <b><?=$arr['lm_minpersone']?></b><br>
			<?=$_SESSION['llasTrattamento']?>: <b><?=$_SESSION["llas".$arr['lm_trattamento']]?></b><br>
			* <?=$_SESSION['llasPrezzo']?><br>
		</P>
	</TD></TR></TABLE>
	<br>
<?php
}
?>
	<TABLE><TR><TD>
<?php
		if ($arr['img2']) {
			$width=250;
			$height=188;
			echo "<A href=\"$pathimg2\" target=\"_blank\"><IMG src=\"".$pathimg2."\" width=\"$width\" height=\"$height\" title=\"$title\" alt=\"$title\"></A>";
		} else echo "<TABLE width=250 height=188 bgcolor=#e0e0e0><TR><TD>".$_SESSION['lErrNoImmagine']."</TD></TR></TABLE>";
?>
	</TD><TD>
<?php
		if ($arr['img3']) {
			$width=250;
			$height=188;
			echo "<A href=\"$pathimg3\" target=\"_blank\"><IMG src=\"".$pathimg3."\" width=\"$width\" height=\"$height\" title=\"$title\" alt=\"$title\"></A>";
		} else echo "<TABLE width=250 height=188 bgcolor=#e0e0e0><TR><TD>".$_SESSION['lErrNoImmagine']."</TD></TR></TABLE>";
?>
	</TD></TR>
	<TR><TD>
<?php
		if ($arr['img4']) {
			$arr_size=getimagesize($pathimg4); //[0]-width, [1]-height
			$width=250;
			$height=188;
			echo "<A href=\"$pathimg4\" target=\"_blank\"><IMG src=\"".$pathimg4."\" width=\"$width\" height=\"$height\" title=\"$title\" alt=\"$title\"></A>";
		} else echo "<TABLE width=250 height=188 bgcolor=#e0e0e0><TR><TD>".$_SESSION['lErrNoImmagine']."</TD></TR></TABLE>";
?>
	</TD><TD>
<?php
		if ($arr['img5']) {
			$arr_size=getimagesize($pathimg5); //[0]-width, [1]-height
			$width=250;
			$height=188;
			echo "<A href=\"$pathimg5\" target=\"_blank\"><IMG src=\"".$pathimg5."\" width=\"$width\" height=\"$height\" title=\"$title\" alt=\"$title\"></A>";
		} else echo "<TABLE width=250 height=188 bgcolor=#e0e0e0><TR><TD>".$_SESSION['lErrNoImmagine']."</TD></TR></TABLE>";
?>
	</TD></TR></TABLE>
	<TABLE cellpadding="5"><TR><TD style="background:#e0e0e0;">
		<P class="testoscheda_dettaglio"><?=nl2br($arr[$_SESSION['lrisCampoDescrizioneLingua']])?></P>
	</TD></TR></TABLE>
	<br>
<?php
$resLP=eseguiqry("select * from listinoprezzi WHERE id_hotel='$id'");
$nresLP=quanterighe($resLP);
if ($nresLP>0) {
	$arrLP=leggiriga($resLP);
?>
	<h3><?=$_SESSION['lrisListinoPrezzi']." ".$arrLP['anno']?></h3>
	<table width="90%" cellpadding="2" cellspacing="0" border="0" class="richiesta">
	<tr><td rowspan="2"><?=$_SESSION['lrisTipoDiSistemazione']?>:</td><td colspan="2"><?=$_SESSION['lrisPrezzoGiornaliero']?></td><td colspan="2"><?=$_SESSION['lrisPrezzoSettimanale']?></td></tr>
	<tr>	<td>min</td><td>max</td><td>min</td><td>max</td></tr>
<?php
	if ($arrLP['singola_gmin']>0 || $arrLP['singola_gmax']>0 || $arrLP['singola_smin']>0 || $arrLP['singola_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisCamera01']?>:</td>
		<td><?=((int)$arrLP['singola_gmin']?$arrLP['singola_gmin']:"")?></td>
		<td><?=((int)$arrLP['singola_gmax']?$arrLP['singola_gmax']:"")?></td>
		<td><?=((int)$arrLP['singola_smin']?$arrLP['singola_smin']:"")?></td>
		<td><?=((int)$arrLP['singola_smax']?$arrLP['singola_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['dop_sin_gmin']>0 || $arrLP['dop_sin_gmax']>0 || $arrLP['dop_sin_smin']>0 || $arrLP['dop_sin_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisCamera21']?>:</td>
		<td><?=((int)$arrLP['dop_sin_gmin']?$arrLP['dop_sin_gmin']:"")?></td>
		<td><?=((int)$arrLP['dop_sin_gmax']?$arrLP['dop_sin_gmax']:"")?></td>
		<td><?=((int)$arrLP['dop_sin_smin']?$arrLP['dop_sin_smin']:"")?></td>
		<td><?=((int)$arrLP['dop_sin_smax']?$arrLP['dop_sin_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['doppia_gmin']>0 || $arrLP['doppia_gmax']>0 || $arrLP['doppia_smin']>0 || $arrLP['doppia_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisCamera02']?>:</td>
		<td><?=((int)$arrLP['doppia_gmin']?$arrLP['doppia_gmin']:"")?></td>
		<td><?=((int)$arrLP['doppia_gmax']?$arrLP['doppia_gmax']:"")?></td>
		<td><?=((int)$arrLP['doppia_smin']?$arrLP['doppia_smin']:"")?></td>
		<td><?=((int)$arrLP['doppia_smax']?$arrLP['doppia_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['triplaa_gmin']>0 || $arrLP['triplaa_gmax']>0 || $arrLP['triplaa_smin']>0 || $arrLP['triplaa_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisCamera03']?>:</td>
		<td><?=((int)$arrLP['triplaa_gmin']?$arrLP['triplaa_gmin']:"")?></td>
		<td><?=((int)$arrLP['triplaa_gmax']?$arrLP['triplaa_gmax']:"")?></td>
		<td><?=((int)$arrLP['triplaa_smin']?$arrLP['triplaa_smin']:"")?></td>
		<td><?=((int)$arrLP['triplaa_smax']?$arrLP['triplaa_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['quadrup_gmin']>0 || $arrLP['quadrup_gmax']>0 || $arrLP['quadrup_smin']>0 || $arrLP['quadrup_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisCamera04']?>:</td>
		<td><?=((int)$arrLP['quadrup_gmin']?$arrLP['quadrup_gmin']:"")?></td>
		<td><?=((int)$arrLP['quadrup_gmax']?$arrLP['quadrup_gmax']:"")?></td>
		<td><?=((int)$arrLP['quadrup_smin']?$arrLP['quadrup_smin']:"")?></td>
		<td><?=((int)$arrLP['quadrup_smax']?$arrLP['quadrup_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['lettoag_gmin']>0 || $arrLP['lettoag_gmax']>0 || $arrLP['lettoag_smin']>0 || $arrLP['lettoag_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisLettoAggiunto']?>:</td>
		<td><?=((int)$arrLP['lettoag_gmin']?$arrLP['lettoag_gmin']:"")?></td>
		<td><?=((int)$arrLP['lettoag_gmax']?$arrLP['lettoag_gmax']:"")?></td>
		<td><?=((int)$arrLP['lettoag_smin']?$arrLP['lettoag_smin']:"")?></td>
		<td><?=((int)$arrLP['lettoag_smax']?$arrLP['lettoag_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['ap_sing_gmin']>0 || $arrLP['ap_sing_gmax']>0 || $arrLP['ap_sing_smin']>0 || $arrLP['ap_sing_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisAppart01']?>:</td>
		<td><?=((int)$arrLP['ap_sing_gmin']?$arrLP['ap_sing_gmin']:"")?></td>
		<td><?=((int)$arrLP['ap_sing_gmax']?$arrLP['ap_sing_gmax']:"")?></td>
		<td><?=((int)$arrLP['ap_sing_smin']?$arrLP['ap_sing_smin']:"")?></td>
		<td><?=((int)$arrLP['ap_sing_smax']?$arrLP['ap_sing_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['ap_dopp_gmin']>0 || $arrLP['ap_dopp_gmax']>0 || $arrLP['ap_dopp_smin']>0 || $arrLP['ap_dopp_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisAppart02']?>:</td>
		<td><?=((int)$arrLP['ap_dopp_gmin']?$arrLP['ap_dopp_gmin']:"")?></td>
		<td><?=((int)$arrLP['ap_dopp_gmax']?$arrLP['ap_dopp_gmax']:"")?></td>
		<td><?=((int)$arrLP['ap_dopp_smin']?$arrLP['ap_dopp_smin']:"")?></td>
		<td><?=((int)$arrLP['ap_dopp_smax']?$arrLP['ap_dopp_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['ap_trip_gmin']>0 || $arrLP['ap_trip_gmax']>0 || $arrLP['ap_trip_smin']>0 || $arrLP['ap_trip_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisAppart03']?>:</td>
		<td><?=((int)$arrLP['ap_trip_gmin']?$arrLP['ap_trip_gmin']:"")?></td>
		<td><?=((int)$arrLP['ap_trip_gmax']?$arrLP['ap_trip_gmax']:"")?></td>
		<td><?=((int)$arrLP['ap_trip_smin']?$arrLP['ap_trip_smin']:"")?></td>
		<td><?=((int)$arrLP['ap_trip_smax']?$arrLP['ap_trip_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['ap_quad_gmin']>0 || $arrLP['ap_quad_gmax']>0 || $arrLP['ap_quad_smin']>0 || $arrLP['ap_quad_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisAppart04']?>:</td>
		<td><?=((int)$arrLP['ap_quad_gmin']?$arrLP['ap_quad_gmin']:"")?></td>
		<td><?=((int)$arrLP['ap_quad_gmax']?$arrLP['ap_quad_gmax']:"")?></td>
		<td><?=((int)$arrLP['ap_quad_smin']?$arrLP['ap_quad_smin']:"")?></td>
		<td><?=((int)$arrLP['ap_quad_smax']?$arrLP['ap_quad_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['ap_quin_gmin']>0 || $arrLP['ap_quin_gmax']>0 || $arrLP['ap_quin_smin']>0 || $arrLP['ap_quin_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisAppart05']?>:</td>
		<td><?=((int)$arrLP['ap_quin_gmin']?$arrLP['ap_quin_gmin']:"")?></td>
		<td><?=((int)$arrLP['ap_quin_gmax']?$arrLP['ap_quin_gmax']:"")?></td>
		<td><?=((int)$arrLP['ap_quin_smin']?$arrLP['ap_quin_smin']:"")?></td>
		<td><?=((int)$arrLP['ap_quin_smax']?$arrLP['ap_quin_smax']:"")?></td>
	</tr>
<?php
	}
	if ($arrLP['ap_sest_gmin']>0 || $arrLP['ap_sest_gmax']>0 || $arrLP['ap_sest_smin']>0 || $arrLP['ap_sest_smax']>0) {
?>
	<tr><td><?=$_SESSION['lrisAppart06']?>:</td>
		<td><?=((int)$arrLP['ap_sest_gmin']?$arrLP['ap_sest_gmin']:"")?></td>
		<td><?=((int)$arrLP['ap_sest_gmax']?$arrLP['ap_sest_gmax']:"")?></td>
		<td><?=((int)$arrLP['ap_sest_smin']?$arrLP['ap_sest_smin']:"")?></td>
		<td><?=((int)$arrLP['ap_sest_smax']?$arrLP['ap_sest_smax']:"")?></td>
	</tr>
<?php
	}
?>
	<tr><td colspan="5"><?=nl2br($arrLP[$_SESSION['lrisCampoInfoLingua']])?></td></tr>
	</td></tr>
	</table>
	<br>
<?php
}

if ($arr['lon']!=0 && $arr['lat']!=0) {
?>
	<br>
	<div id="map" style="width: 590px; height: 500px" style="background:#ffa0a0;"></div>
<?php
}

chiudidb();

?>

</TD></TR>
</TABLE>
<!--- middle end--->

<?php include "filecomuni/_bottom.html"?>