<?
include_once('php/init.inc.php');

//Unterkunftsarten
$accommodation_types = array();
$query = mysql_query("select * from accommodation_types", $conn);
while($res = mysql_fetch_assoc($query)) {
	$accommodation_types[$res['accomodation_type_id']] = $res['accommodation_type'];
}
mysql_free_result($query);


//Daten abfragen
$accommodations = array();
$ids = array();

	//Unterkünfte----------------------------------------------------------------------------------------------------------------------------------
	if(!isset($_GET['type'])) {
		$query = mysql_query("select * from accommodations, customers where 
									accommodations.customer_id = customers.customer_id 
									and customers.flag_schobuell = 'Y' 
									and accommodations.flag_parked = 'N'
									and accommodations.delete_date is null
								order by accommodations.mod_date desc", $conn);
	}
	
	else {
		$query = mysql_query("select * from accommodations, customers where 
									accommodations.customer_id = customers.customer_id 
									and customers.flag_schobuell = 'Y' 
									and accommodations.flag_parked = 'N'
									and accommodations.delete_date is null
									and accommodation_type_id = '".addslashes($_GET['type'])."'
								order by accommodations.mod_date desc", $conn);
	}
	

	while($res = mysql_fetch_assoc($query)) {
		
		//Objektart
		$res['accommodation_type'] = $accommodation_types[$res['accommodation_type_id']];
		
		//Austtattungs-Piktogramme
		$res['attributes'] = array();
		
		$query_attributes = mysql_query("select attributes.* from attributes, attributes_accommodations
												where attributes.attribute_id = attributes_accommodations.attribute_id
												and attributes_accommodations.accommodation_id = '".$res['accommodation_id']."'", $conn);
		
		while($res_attributes = mysql_fetch_assoc($query_attributes)) {
			array_push($res['attributes'], $res_attributes);
		}
		
		mysql_free_result($query_attributes);
		
		$accommodations[$res['accommodation_id']] = $res;
		array_push($ids, $res['accommodation_id']);
		
	}
	
	mysql_free_result($query);
	
	//Hauptbild zu den Unterkünften
	$query = mysql_query("select * from images where is_teaser = 'Y' and accommodation_id in (".implode(",", $ids).")", $conn);
	while($res = mysql_fetch_assoc($query)) {
		$accommodations[$res['accommodation_id']]['image_id'] = $res['image_id'];
	}
	mysql_free_result($query);
	

$smarty->assign("accommodations", $accommodations);
$smarty->display("gastgeber.tpl.html");
mysql_close($conn);
?>