<?
# Includo le librerie di base
# Includo le librerie standard ed eventuali parametri globali
include("conf/globals.inc.php");

include ("conf/customer.cnf.php");
include ("lib/customer.lib.php");

# Istanzio la libreria repository
$my_repository = new repository("MySQL");

# Istanzio la libreria utility
$my_utility = new utility();

# Istanzio la libreria customer
$my = new customer($my_repository->dbms, $my_utility);
$my_club = new customer($my_repository->dbms, $my_utility);

# Istanzio la libreria query string
$my_query_string = new query_string;

# Leggo la HTTP query string
$ok = $my_query_string->get_query_string();

#Parametro per gestione Menu'
$NOMENU = 0;
if(array_key_exists("NOMENU", $my_query_string->in_query))
	$NOMENU = $my_query_string->in_query["NOMENU"];

if(array_key_exists("annata",$my_query_string->in_query))
	$annata = $my_query_string->in_query["annata"];
else
	$annata = $my_utility->get_annata();

$my_html = new customer();
$my_html->format();

# Eseguo l'accesso al data base
$ok_repository = $my_repository->dbms->repository_connect();
if ($ok_repository < 0) {
	$error_dett = $my_repository->dbms->out_error_description;
	header("Location: ../error/error.php?code=$ok_repository&error=$error_dett&NOMENU=$NOMENU");
	exit;
}

$ok = $my->get_layout($annata);

if ($ok < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok&error=$error_dett&NOMENU=$NOMENU");
	exit;
}

if ($ok == 0 || $ok > 1){
	$error_dett = "Configuration error";
	header("Location: error/error.php?code=$ok&error=$error_dett&NOMENU=$NOMENU");
	exit;
}

$layout = $my->out[0];

// Recupero le informazioni sul distretto
$in = array();
$in["club_id"] = 0;
$ok = $my->club_get_district($in);
if ($ok < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok&error=$error_dett&NOMENU=$NOMENU");
	exit;
}
$head_dis = $my->out[0];

// Recupero le informazioni sul Menu orizzontale (Primo livello)
$in = array();
$in["club_id"] = 0;
$in["annata"] = $annata;
//$in["add_where"] = "(" . implode(',', $my_html->FIRST_LINE_MENU_CATEGORIES_ID) . ") ";
$in["settore"] = "FIRST_LINE_MENU_CATEGORIES_ID";
$ok = $my->club_get_categorie($in);
if ($ok < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok&error=$error_dett&NOMENU=$NOMENU");
	exit;
}
$menu = $my->out;

//Recupero le informazioni sulla categoria 'OTHER'
$in = array();
$in["club_id"] = 0;
$in["annata"] = $annata;
//$in["add_not_where"] = "(" . $my_html->GOVERNOR_CATEGORY_ID . ',' .implode(',', $my_html->FIRST_LINE_MENU_CATEGORIES_ID) . ',' .implode(',', $my_html->WIDENING_MENU_CATEGORIES_ID) . ") ";
$in["settore"] = "SECOND_LINE_MENU_CATEGORIES_ID";
$ok = $my->club_get_categorie($in);
if ($ok < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok&error=$error_dett&NOMENU=$NOMENU");
	exit;
}
$menu2 = $my->out;

$ok = $my->club_get_header();
if ($ok < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok&error=$error_dett&NOMENU=$NOMENU");
	exit;
}

$head = $my->out;

//Recupero le informazioni sulla categoria 'Altri link'
$in = array();
$in["club_id"] = 0;
$in["annata"] = $annata;
$in["settore"] = "WIDENING_MENU_CATEGORIES_ID";
$ok3 = $my->club_get_categorie($in);
if ($ok3 < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok3&error=$error_dett&NOMENU=$NOMENU");
	exit;
}
$menu3 = $my->out;

//Recupero le informazioni sulla categoria 'GOVERNATORE'
$in = array();
$in["club_id"] = 0;
$in["annata"] = $annata;
$in["settore"] = "GOVERNOR_CATEGORY_ID";

$ok = $my->club_get_categorie($in);
if ($ok < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok&error=$error_dett&NOMENU=$NOMENU");
	exit;
}

$governor_category = array();
if (array_key_exists(0,$my->out))
	$governor_category = $my->out[0];

$ok_tipo_carica_id = $my->search_tipo_carica_id("Governatore", "", "Distretto 2060");

if ($ok_tipo_carica_id < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok_tipo_carica_id&error=$error_dett&NOMENU=$NOMENU");
	exit;
}

$tipo_carica = $my->out[0]; 

$tipo_carica_id = $tipo_carica["tipo_carica_id"];

$ok_governatore = $my->get_governatore($tipo_carica_id, $annata);

if ($ok_governatore < 0) {
	$error_dett = $my->out_error_description;
	header("Location: error/error.php?code=$ok_governatore&error=$error_dett&NOMENU=$NOMENU");
	exit;
}

if ($ok_governatore > 0) {

	$governatore = $my->out[0]; 
	
	$in_action = array();
	$in_action["club_id"] = 0;

	if (count($governor_category)){
		
		$in_action["categoria_padre"] = $governor_category["categoria_id"];
	
		$ok_categories = $my->club_get_categorie_figlie($in_action);
		if ($ok_categories < 0) {
			$error_dett = $my->out_error_description;
			header("Location: error/error.php?code=$ok_categories&error=$error_dett&NOMENU=$NOMENU");
			exit;
		}

		$governator_categories = $my->out;

	}

}

$title= "Mappa del Sito";

$dir_year = str_replace("/", "-", $annata);

$css =  "allegati/upload.layout/" . $dir_year . "/style.web.css";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
	<title><?
						if (strcmp("&nbsp",$title))
	 						echo $head_dis["club"] . " - " . $title;
						else
	 						echo $head_dis["club"];
						 ?></title>
	<meta name="keywords" content="<? echo $my_html->HTML_META_KEYWORDS; ?>">
	<meta name="description" content="<? echo $my_voci->out[0]["des_cat"]; ?>">
	<link rel="stylesheet" href="<? echo $my_html->HTML_STYLESHEET; ?>" type="text/css">
	<link rel="shortcut icon" href="<? echo $my_html->HTML_ICO; ?>" />
</head>
<body>
	<div class="container">
	
		<div class="header">

				<? include("header.php"); ?>

		</div>

		<!-- MAIN CONTENT ZONE -->

		<div class="main">

			<!--<h3>Mappa del Sito</h3>-->
			
			<div class="rotary4">Mappa del Sito</div>
			

			<div class="whole_content_sitemap">
			<div class="sitemap">

<?

					$entries = array();

					$entries[] = "<h1 class=\"menu\" style=\"font-size : 12px;\">&nbsp;</h1>";

					$entries[] = "<li><a href=\"index.php?annata=" . $annata . "\">Home</a></li>";

					for($i=0;$i<count($menu);$i++) {

						if ($menu[$i]["numero_figli"])

							$entries[] = "<li><a href=\"#" . $menu[$i]["categoria_id"] . "\">" . $menu[$i]["categoria"] ."</a></li>";

						else

							$entries[] = "<li><a href=\"district_categoria.php?club_id=" . $menu[$i]["club_id"] . "&annata=" . $annata . "&categoria_id=" . $menu[$i]["categoria_id"] . "\">" . $menu[$i]["categoria"] ."</a></li>";

 					}

					$entries[] = "<li class=\"last\"><a href=\"club.php?annata=" . $annata . "\">Club del Distretto</a></li>";

					$entries[] = "<h1 class=\"menu4\">&nbsp;</h1>";

					for($i=0;$i<count($menu2);$i++) {

						if ($menu2[$i]["numero_figli"])

							$entries[] = "<li><a href=\"#" . $menu2[$i]["categoria_id"] . "\">" . $menu2[$i]["categoria"] ."</a></li>";

						else

							$entries[] = "<li><a href=\"district_categoria.php?club_id=" . $menu2[$i]["club_id"] . "&annata=" . $annata . "&categoria_id=" . $menu2[$i]["categoria_id"] . "\">" . $menu2[$i]["categoria"] ."</a></li>";

					}

					$entries[] = "<li class=\"last\"><a href=\"../district/\" target=_blank>Admin Distretto</a></li>";

					$entries[] = "<h4>" . $governor_category["categoria"] . "</h4>";

					for($i=0;$i<$ok_categories - 1;$i++) {

						$entries[] = "<li><a href=\"district_categoria.php?club_id=" . $in_action[$i]["club_id"] . "&annata=" . $annata . "&categoria_id=" . $governator_categories[$i]["categoria_id"] . "&categoria_padre=" . $in_action["categoria_padre"] . "&left_menu=no&leaf=yes\" class=normal>" . $governator_categories[$i]["categoria"] ."</a></li>";

					}

					$entries[] = "<li class=\"last\"><a href=\"district_categoria.php?club_id=" . $in_action[$ok_categories - 1]["club_id"] . "&annata=" . $annata . "&categoria_id=" . $governator_categories[$ok_categories - 1]["categoria_id"] . "&categoria_padre=" . $in_action["categoria_padre"] . "&left_menu=no&leaf=yes\" class=normal>" . $governator_categories[$i]["categoria"] ."</a></li>";

					$entries[] = "<h4>Links</h4>";

					if (!strcmp($annata, "2007/2008")){

						$entries[] = "<li><a href=\"index.php?annata=2007/2008\">I Presidenti dei Club</a></li>";

					}

					$entries[] = "<li><a href=\"mappa.php?club_id=0&annata=" . $annata . ">Mappa del Sito</a></li>";

					for($i=0;$i<$ok3;$i++) {

						$entries[] = "<li><a href=\"district_categoria.php?club_id=" . $menu3[$i]["club_id"] . "&annata=" . $annata . "&categoria_id=" . $menu3[$i]["categoria_id"] . "&leaf=yes\">" . $menu3[$i]["categoria"] ."</a></li>";

					}

					$entries[] = "<li class=\"last\"><a href=\"http://www.2k60.com\">ROTARACT</a></li>";

					$num_elements = count($entries);
					$num_elements_per_column = ceil($num_elements / 3);
					

?>

				<div class="header_split3">HOME</div>
				<div class="split3">

<?

					for ($j=1; $j <= 3; $j++){

?>

					<div>

<?

						for ($i=$num_elements_per_column*($j-1); $i < $j*$num_elements_per_column; $i++){
	
							if ($i >= $num_elements){
								break;
							}
	
							echo $entries[$i];

						}

?>

					</div>

<?

					}

?>

				</div>
				
			</div>

<?

    			 for($i=0;$i<count($menu);$i++) {

  					if ($menu[$i]["numero_figli"] > 0){

							$entries = array();
							$entries[] = "";

              # Istanzio la libreria customer
							$my_leaf = new customer($my_repository->dbms, $my_utility);
							$in_action_leaf = array();
							$in_action_leaf["categoria_padre"] = $menu[$i]["categoria_id"];
							$in_action_leaf["club_id"] = $menu[$i]["club_id"];
							
							$ok_leaf = $my_leaf->club_get_categorie_figlie($in_action_leaf);
							if ($ok_leaf < 0) {
							 $error_dett = $my_leaf->out_error_description;
							 header("Location: error/error.php?code=$ok_leaf&error=$error_dett&NOMENU=$NOMENU");
							 exit;
							}

							$leaf = $my_leaf->out;
							
							for($j = 0; $j < count($leaf) - 1; $j++){
							
								$entries[] = "<li><a href=\"district_categoria.php?club_id=" . $in_action_leaf["club_id"] . "&annata=" . $annata . "&categoria_id=" . $leaf[$j]["categoria_id"] . "&categoria_padre=" . $leaf[$j]["categoria_padre"] ."\">" . $leaf[$j]["categoria"] ."</a></li>";
							
							}
							
							$entries[] = "<li class=\"last\"><a href=\"district_categoria.php?club_id=" . $in_action_leaf["club_id"] . "&annata=" . $annata . "&categoria_id=" . $leaf[count($leaf) - 1]["categoria_id"] . "&categoria_padre=" . $leaf[count($leaf) - 1]["categoria_padre"] ."\">" . $leaf[count($leaf) - 1]["categoria"] ."</a></li>";
							
							
?>

			<div class="subsitemap">

				<div class="header_split"><a name="<? echo $menu[$i]["categoria_id"]; ?>"><? echo $menu[$i]["categoria"]; ?></a></div>

				<div class="split">

					<div>

<?

							for ($i=0; $i < count($entries); $i++){
							
								echo $entries[$i];
							
							}

?>

					</div>

				</div>

			</div>

<?
						
						}
					
					}

					for($i=0;$i<count($menu2);$i++) {

  					if ($menu2[$i]["numero_figli"] > 0){

							$entries = array();
							$entries[] = "";

              # Istanzio la libreria customer
							$my_leaf = new customer($my_repository->dbms, $my_utility);
							$in_action_leaf = array();
							$in_action_leaf["categoria_padre"] = $menu2[$i]["categoria_id"];
							$in_action_leaf["club_id"] = $menu2[$i]["club_id"];
							
							$ok_leaf = $my_leaf->club_get_categorie_figlie($in_action_leaf);
							if ($ok_leaf < 0) {
							 $error_dett = $my_leaf->out_error_description;
							 header("Location: error/error.php?code=$ok_leaf&error=$error_dett&NOmenu2=$NOmenu2");
							 exit;
							}

							$leaf = $my_leaf->out;
							
							for($j = 0; $j < count($leaf) - 1; $j++){
							
								$entries[] = "<li><a href=\"district_categoria.php?club_id=" . $in_action_leaf["club_id"] . "&annata=" . $annata . "&categoria_id=" . $leaf[$j]["categoria_id"] . "&categoria_padre=" . $leaf[$j]["categoria_padre"] ."\">" . $leaf[$j]["categoria"] ."</a></li>";
							
							}
							
							$entries[] = "<li class=\"last\"><a href=\"district_categoria.php?club_id=" . $in_action_leaf["club_id"] . "&annata=" . $annata . "&categoria_id=" . $leaf[count($leaf) - 1]["categoria_id"] . "&categoria_padre=" . $leaf[count($leaf) - 1]["categoria_padre"] ."\">" . $leaf[count($leaf) - 1]["categoria"] ."</a></li>";
							
							
?>

			<div class="subsitemap">

				<div class="header_split"><a name="<? echo $menu2[$i]["categoria_id"]; ?>"><? echo $menu2[$i]["categoria"]; ?></a></div>

				<div class="split">

					<div>

<?

							for ($j=0; $j < count($entries); $j++){
							
								echo $entries[$j];
							
							}

?>

					</div>

				</div>

			</div>

<?
						
						}
					
					}

 
?>

		</div>
		</div>

		<div class="footer">

		<!-- FOOTER ZONE -->
		<? include("footer.html"); ?>
		<!-- /FOOTER ZONE -->

		</div>

	</div>
	
</body>
</html>