<?
require '../../../system/config.php';				// nastaveni systemovych promennych pro admin sekci
require '../../../system/db_connect.php';			// pripojeni k databazi
require '../../../system/sessions.php';				// nastartovani session
require '../../../system/functions.php';			// nacteni nadefinovanych funkci
require '../../../system/functions_output.php';		// nacteni nadefinovanych funkci pro vystup
require '../../../system/var_check.php';			// oslashovani promennych v $_POST a $_GET


/* VYKONNA CAST SKRIPTU */
$lang = load_lng_terms($_SESSION['lng']);
$title = $lang['cestovni_agentura'];

$sql = "
	SELECT
		stl.state_id, stl.state_name
		, rgl.region_id, rgl.region_name
		, rsl.resort_id, rsl.resort_name
		, obl.*
		, ob.*
		, g.p_id, g.p_x_small, g.p_y_small, g.uniline_img_id, g.url_xl, g.url_l, g.url_m
		, gl.p_alt
	FROM
		c_state `st`
			LEFT JOIN c_state_lng `stl` ON stl.state_id = st.state_id AND stl.lng_id = {$_SESSION['lng']}
		, c_region `rg`
			LEFT JOIN c_region_lng `rgl` ON rgl.region_id = rg.region_id AND rgl.lng_id = {$_SESSION['lng']}
		, c_resort `rs`
			LEFT JOIN c_resort_lng `rsl` ON rsl.resort_id = rs.resort_id AND rsl.lng_id = {$_SESSION['lng']}
		, c_object `ob`
			LEFT JOIN c_object_lng `obl` ON obl.obj_id = `ob`.obj_id AND obl.lng_id = {$_SESSION['lng']}
			LEFT JOIN c_gallery_bind `gb` ON gb.bind_type = 3 AND gb.bind_order = 1 AND gb.bind_id = ob.obj_id
			LEFT JOIN c_gallery `g` ON g.p_id = gb.p_id
			LEFT JOIN c_gallery_lng `gl` ON gl.p_id = g.p_id AND gl.p_lng = {$_SESSION['lng']}
	WHERE
			st.state_id = rg.state_id
		AND rg.region_id = rs.region_id
		AND rs.resort_id = ob.resort_id
		AND ob.obj_hidden = 0
	";

if ( isset($_GET['s_state']) ) {
	$link = 'state';
	$group = 3;
	$id = (int) $_GET['s_state'];
	$sql .= 'AND st.state_id = ' . $id;
	$sql_header = "
		SELECT
			stl.state_id AS `id`, stl.state_name AS `h1_name`
			, CONCAT('pozadavek.php?s_region=', rgl.region_id) AS `link_url`, rgl.region_name AS `link_name`
		FROM
			c_state_lng `stl`
			, c_region `rg`
				LEFT JOIN c_region_lng `rgl` ON rgl.region_id = rg.region_id AND rgl.lng_id = {$_SESSION['lng']}
		WHERE
				stl.state_id = $id
			AND stl.lng_id = {$_SESSION['lng']}
			AND stl.state_id = rg.state_id
		LIMIT
			1
	";
}
elseif ( isset($_GET['s_region']) ) {
	$link = 'region';
	$group = 3;
	$id = (int) $_GET['s_region'];
	$sql .= 'AND rg.region_id = ' . $id;
	$sql_header = "
		SELECT
			rg.region_map
			, rgl.region_id AS `id`, rgl.region_name AS `h1_name`, rgl.region_desc
			, CONCAT('pozadavek.php?s_resort=', rsl.resort_id) AS `link_url`, rsl.resort_name AS `link_name`
		FROM
			c_region `rg`
			, c_region_lng `rgl`
			, c_resort `rs`
				LEFT JOIN c_resort_lng `rsl` ON rsl.resort_id = rs.resort_id AND rsl.lng_id = {$_SESSION['lng']}
		WHERE
				rg.region_id = $id
			AND rg.region_id = rgl.region_id
			AND rgl.lng_id = {$_SESSION['lng']}
			AND rgl.region_id = rs.region_id
		LIMIT
			1
	";}
elseif ( isset($_GET['s_resort']) ) {
	$link = 'resort';
	$group = 3;
	$id = (int) $_GET['s_resort'];
	$sql .= 'AND rs.resort_id = ' . $id;
	$sql_header = "
		SELECT
			rsl.resort_id AS `id`, rsl.resort_name AS `h1_name`, rsl.resort_desc
			, CONCAT('data_show.php?obj=obj&amp;id=', obl.obj_id) AS `link_url`, obl.obj_name AS `link_name`
			, g.p_id, g.p_x_big, g.p_y_big, g.uniline_img_id, g.url_xl, g.url_l, g.url_m
			, gl.p_alt
		FROM
			c_resort_lng `rsl`
				LEFT JOIN c_gallery_bind `gb` ON gb.bind_type = 2 AND gb.bind_id = rsl.resort_id
				LEFT JOIN c_gallery `g` ON g.p_id = gb.p_id AND g.p_type = 'resort'
				LEFT JOIN c_gallery_lng `gl` ON gl.p_id = g.p_id AND gl.p_lng = {$_SESSION['lng']}
			, c_object `ob`
				LEFT JOIN c_object_lng `obl` ON obl.obj_id = ob.obj_id AND obl.lng_id = {$_SESSION['lng']}
		WHERE
				rsl.resort_id = $id
			AND rsl.lng_id = {$_SESSION['lng']}
			AND rsl.resort_id = ob.resort_id
			AND ob.obj_hidden = 0
		ORDER BY
			g.p_id DESC
		LIMIT
			1
	";
}
elseif ( isset($_GET['s_object']) ) {
	$link = 'object';
	$group = 3;
}

$sql .= "
	ORDER BY
		stl.state_name, rgl.region_name, rsl.resort_name, ob.obj_order";

$result = MSQ_utf($sql_header);
$header_items = array();
$main_info;

while ( $row = @mysql_fetch_assoc($result) ) {
	if ( !$header ) {
		$header = '<h1>' . $row['h1_name'] . '</h1>';
		$title = $row['h1_name'] . ' | ' . $lang['cestovni_agentura'];
	}
	
	if ( $link == 'region' ) {
		$main_info = content_box(
			'big'
			, $row['h1_name']
			, $row['region_desc']
			, false
			, sprintf('<iframe src="%s" width="330" height="330" frameborder="0" scrolling="no" marginheight="0" marginwidth="0"></iframe>'
				, $row['region_map']
			)
		);
	}
	elseif ( $link == 'resort' ) {

		$main_info = '<div class="breadcrumbs">' . quick_link('resort', $row['id']) . "</div>\n";
		$main_info .= content_box(
			'big'
			, $row['h1_name']
			, $row['resort_desc']
			, false
			, sprintf('<img src="%s/gallery/photo_%d.jpg" width="%d" height="%d" alt="%s" />'
				, $conf_basedir, $row['p_id']
				, $row['p_x_big']
				, $row['p_y_big']
				, $row['p_alt']
			)
			. new_gallery($row['id'], 2)
		);
	}
}

$out_body = $header
	. '<ul class="linelist">'
	. quick_list( $link, $id )
	. '</ul>';
$out_body .= '<div class="clear"></div>';
$out_body .= $main_info;

unset($result);

$result = MSQ_utf($sql);

# Paging
$to_page = $conf_page_listing;
$page = $_GET['page']
	? $_GET['page']
	: ($page ? $page : 1);
$total = mysql_num_rows($result);
$max = (int) ceil($total / $to_page);

@mysql_data_seek($result, ($page - 1) * $to_page);
$i = 1;

$out_body .= paging($page, $max);

$zero = array($lang['ne'], $lang['ano']);
$catering = array(1=>$lang['ne'], $lang['v_dome'], $lang['v_restauraci']);
$pets = array(1 => $lang['nedovolen'], $lang['dovolen'], $lang['dovolen_poplatek']);	

while( ($row = @mysql_fetch_assoc($result)) && ($i <= $to_page) ) {
	$out_body .= object_preview( $row, 'apartment' );
	
	$i++;
}

$out_body .= paging($page, $max);

/* ZOBRAZOVACI CAST SKRIPTU */
require '../../../system/page_start.php';			// hlavicka stranky
require '../../../system/page_body.php';			// telo stranky
require '../../../system/page_end.php';				// paticka stranky vcetne uzavreni spojeni s databazi
?>