<?
//Includo il file di connessione al Database
include("includes/global.php");
include("includes/funzioni.php");

//Inizializzo la var pagiantore
$paginatore_link = "";

//Setto il numero di Record per pagina di default
if(!(isset($_GET['PR']))){
        $PR = 25;
}else{
	$PR = $_GET['PR'];
	$paginatore_link .= "&amp;PR=".$PR;
}

//Setto la pagina selezionata
if(!(isset($_GET['PS']))){
        $PS = 1;
}else{
	$PS = $_GET['PS'];
	$paginatore_link .= "&amp;PS=".$PS;
}

//Setto il parametro che identifica il blocco di pagine
if(!(isset($_GET['PB']))){
	$PB = 1;
}else{
	$PB = $_GET['PB'];
	$paginatore_link .= "&amp;PB=".$PB;
}

$parametri_order = "";
//Setto il parametro Order BY
if(!(isset($_GET['OB']))){
	$OB = "titolo_ord";
}else{
	$OB = $_GET['OB'];
	$parametri_order .= "&amp;OB=".$OB;
}

//Setto il parametro Order Mode
if(!(isset($_GET['OM']))){
	$OM = "";
}else{
	$OM = $_GET['OM'];
	$parametri_order .= "&amp;OM=".$OM;
}

//Setto i parametri di ricerca
$paramerti_ricerca = "";
(isset($_GET['SF']))?$search_field = $_GET['SF']:$search_field = "";
(isset($_GET['SV']))?$search_value = $_GET['SV']:$search_value = "";


if (($search_field != "") AND ($search_value != "")){
	if(($search_field == "titolo") || ($search_field == "evento") || ($search_field == "luogo")){
		$paramerti_ricerca = "AND (T_N.$search_field LIKE '%".escapeLikeMySqlEscapeString($search_value)."%')";
		$paginatore_link .= "&amp;SF=$search_field&amp;SV=".$search_value;
		$paramerti_ricerca_link = "&amp;SF=$search_field&amp;SV=".$search_value;
	}elseif($search_field == "data"){
		
		$SQL_cerca_data = "SELECT DISTINCT ID_manifesto FROM date WHERE data LIKE '%".escapeLikeMySqlEscapeString($search_value)."%';";
		$RS_cerca_data = mysqli_query($DBConn,$SQL_cerca_data) or die ("Errore SQL! [ $SQL_cerca_data ]");
		$par_cerca_data = "";
		while($DateTrovate = mysqli_fetch_array($RS_cerca_data)){
			$par_cerca_data .= $DateTrovate['ID_manifesto'].",";
		}
		if(strlen($par_cerca_data) > 0){
			$par_cerca_data = substr($par_cerca_data,0,-1);
			$par_cerca_data = "(".$par_cerca_data.")";
		}else{
			$par_cerca_data = "(0)";
		}
		
		$paramerti_ricerca = "AND (T_N.ID IN $par_cerca_data)";
		$paginatore_link .= "&amp;SF=$search_field&amp;SV=".$search_value;
		$paramerti_ricerca_link = "&amp;SF=$search_field&amp;SV=".$search_value;
	/*}elseif($search_field == "autore"){
		
		$SQL_cerca_aut = "SELECT DISTINCT ID_manifesto FROM autori WHERE autore LIKE '%$search_value%';";
		$RS_cerca_aut = mysqli_query($DBConn,$SQL_cerca_aut) or die ("Errore SQL! [ $SQL_cerca_aut ]");
		$par_cerca_aut = "";
		while($AutoriTrovati = mysqli_fetch_array($RS_cerca_aut)){
			$par_cerca_aut .= $AutoriTrovati['ID_manifesto'].",";
		}
		if(strlen($par_cerca_aut) > 0){
			$par_cerca_aut = substr($par_cerca_aut,0,-1);
			$par_cerca_aut = "(".$par_cerca_aut.")";
		}else{
			$par_cerca_aut = "(0)";
		}
		
		$paramerti_ricerca = "AND (T_N.ID IN $par_cerca_aut)";
		$paginatore_link .= "&amp;SF=$search_field&amp;SV=".$search_value;
		$paramerti_ricerca_link = "&amp;SF=$search_field&amp;SV=".$search_value;*/
	}
}

$SQL_num_record = "SELECT T_N.ID FROM manifesti T_N WHERE approve = 'TRUE' $paramerti_ricerca ";
$RS_num_record = mysqli_query($DBConn,$SQL_num_record) or die ("Errore SQL! [ $SQL_num_record ]");
$num_record = mysqli_num_rows($RS_num_record);


$SQL_dati = "SELECT T_N.ID AS ID, T_N.titolo AS titolo, T_N.luogo AS luogo, T_N.evento AS evento ";
$SQL_dati .= " FROM manifesti T_N WHERE approve = 'TRUE' $paramerti_ricerca";
$SQL_dati .= " ORDER BY T_N.$OB $OM";
$start_index = ($PS - 1) * $PR;
$page_index = $PR;

$SQL_dati .= " LIMIT $start_index,$page_index;";
$RS_dati = mysqli_query($DBConn,$SQL_dati) or die ("Errore SQL! $SQL_dati");
//Loop per tutti i dati trovati
$conta_righe = 0;
while($RigaDati = mysqli_fetch_array($RS_dati)){
	$RigaTabellaDati[$conta_righe]['ID'] = $RigaDati['ID'];
	$RigaTabellaDati[$conta_righe]['titolo'] = $RigaDati['titolo'];
	$RigaTabellaDati[$conta_righe]['luogo'] = $RigaDati['luogo'];
	$RigaTabellaDati[$conta_righe]['evento'] = $RigaDati['evento'];
	$conta_righe++;
}

$PaginePerBlocco = 10;

//Conto il numero di pagine da visualizzare
if ($PR == "Tutti"){
	$TotPagine = 1;
}else{
	$TotPagine = $num_record/$PR;
	if(($num_record%$PR)!= 0){
		$TotPagine = (int)$TotPagine+1;
	}
}

$ArrOption = array(25,50,100);

if ($TotPagine > $PaginePerBlocco){
	$TotPBlock = $TotPagine/$PaginePerBlocco;
	if(($TotPagine%$PaginePerBlocco)!= 0){
		$TotPBlock = (int)$TotPBlock+1;
	}
	if ($PB == 1){
		$limite_inf = 1;
		$limite_sup = $PaginePerBlocco*$PB;
		$PBPrec = 1;
		$PBSucc = $PB+1;
		$PageSelPrec = $limite_inf;
		$PageSelSucc = $limite_sup + 1;
	}else if ($PB == $TotPBlock){
		$limite_inf = $PaginePerBlocco*($PB-1)+1;
		$limite_sup = $TotPagine;
		$PBPrec = $PB-1;;
		$PBSucc = $TotPBlock;
		$PageSelPrec = $limite_inf - $PaginePerBlocco;
		$PageSelSucc = $limite_sup;
	}else{
		$limite_inf = $PaginePerBlocco*($PB-1)+1;
		$limite_sup = $PaginePerBlocco*$PB;
		$PBPrec = $PB-1;
		$PBSucc = $PB+1;
		$PageSelPrec = $limite_inf - $PaginePerBlocco;
		$PageSelSucc = $limite_sup + 1;
	}
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
        "http://www.w3.org/TR/2000/REC-xhtml1-20000126/DTD/xhtml1-transitional.dtd">
<html lang="it" xmlns="http://www.w3.org/1999/xhtml">
	<title>Indice locandine - <? include("includes/site_name.inc");?></title>
		<meta http-equiv="content-type" content="text/html; charset=utf-8" />
		<!--STYLE-->
		<? include("includes/style.php");?>
		<!--/STYLE-->
	</head>
	
	<body id="browse">
	
		<!--HEADER-->
		<div class="header">
			<!--MENU-->
			<? include("includes/header.php");?>
			<!--/MENU-->
		</div>
		<!--/HEADER-->	

			<!--BREADCRUMBS-->
			<div class="breadcrumbs">
				
			</div>
			<!--/BREADCRUMBS-->
			<h1>Indice locandine</h1>
			
			<!--DOC SEARCH-->
			<form action="/indice_manifesti.php" method="get" class="docSearch">			
				<fieldset>
					<label class="noBreak">Cerca una parola: <input type="text" name="SV" id="SV" size="30" value="" />
						<select name="SF" id="SF">
							<option value="titolo" <?if($search_field == "titolo"){echo "selected=\"selected\"";}?> >Titolo</option>
							<option value="evento" <?if($search_field == "evento"){echo "selected=\"selected\"";}?>>Evento</option>
							<!--<option value="autore" <?if($search_field == "autore"){echo "selected=\"selected\"";}?>>Autore</option>-->
							<option value="data" <?if($search_field == "data"){echo "selected=\"selected\"";}?>>Data</option>
							<option value="luogo" <?if($search_field == "luogo"){echo "selected=\"selected\"";}?>>Luogo</option>
						</select>
					</label><input type="submit" value="cerca" />
				</fieldset>
			</form>
			<!--/DOC SEARCH-->
			
			<!--DOC INDEX-->
			<table class="docs" summary="Indice documenti in archivio" width="100%">
				<thead>
					<tr>
						<!--TH titolo-->
<?				if($OB == "titolo_ord"){?>
						<th class="ord" width="47%" scope="col" abbr="Titolo">
<?					if ($OM == "DESC"){?>
						<img src="/images/sort_up.gif" border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=titolo_ord&amp;OM=">Titolo</a>
<?					}else{?>
						<img src="/images/sort_down.gif" border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=titolo_ord&amp;OM=DESC">Titolo</a>
<?					}
				}else{?>
						<th class="notOrd" width="47%" scope="col" abbr="Titolo"><a href="/indice_manifesti.php?&amp;OB=titolo_ord&amp;OM=DESC">Titolo</a>
<?				}?>
						<span class="noBold">( documento/i, pag. /)</span></th>
						<!--/TH titolo-->
						<!--TH autore-->
<!--						<th class="notOrd" width="30%" scope="col" abbr="Autore">Autore</th>-->
						<!--/TH autore-->
						<!--TH evento-->
<?				if($OB == "evento"){?>
						<th class="ord" width="23%" scope="col" abbr="Evento">
<?					if ($OM == "DESC"){?>
						<img src="/images/sort_up.gif" border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=evento&amp;OM=">Evento</a></th>
<?					}else{?>
						<img src="/images/sort_down.gif" border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=evento&amp;OM=DESC">Evento</a></th>
<?					}
				}else{?>
						<th class="notOrd" width="23%" scope="col" abbr="Evento"><a href="/indice_manifesti.php?&amp;OB=evento&amp;OM=DESC">Evento</a></th>
<?				}?>
						<!--/TH evento-->
						<!--TH data-->
<!--
<?				if($OB == "data"){?>
					<th class="ord" width="10%" scope="col" abbr="Data">
<?					if ($OM == "DESC"){?>
						<img src="/images/sort_up.gif" border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=data&amp;OM=">Data</a></th>
<?					}else{?>
						<img src="/images/sort_down.gif"  border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=data&amp;OM=DESC">Data</a></th>
<?					}
				}else{?>
						<th class="notOrd" width="10%" scope="col" abbr="Data"><a href="/indice_manifesti.php?&amp;OB=data&amp;OM=DESC">Data</a></th>
<?				}?>
-->
						<th class="notOrd" width="10%" scope="col" abbr="Data">Data</th>
						<!--/TH data-->
						<!--TH luogo-->
<?				if($OB == "luogo"){?>
					<th class="ord" width="20%" scope="col" abbr="Luogo">
<?					if ($OM == "DESC"){?>
						<img src="/images/sort_up.gif" border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=luogo&amp;OM=">Luogo</a></th>
<?					}else{?>
						<img src="/images/sort_down.gif" border="0" class="sortMark" /><a href="/indice_manifesti.php?&amp;OB=luogo&amp;OM=DESC">Luogo</a></th>
<?					}
				}else{?>
						<th class="notOrd" width="20%" scope="col" abbr="Luogo"><a href="/indice_manifesti.php?&amp;OB=luogo&amp;OM=DESC">Luogo</a></th>
<?				}?>
						<!--/TH luogo-->
					</tr>
				</thead>
				<tbody>
<?		if ($conta_righe != 0){
			for ($n_righe=0;$n_righe<$conta_righe;$n_righe++){
				if(($n_righe%2)!=0){$class = "Pair";}else{$class = "Odd";}
				$ID = $RigaTabellaDati[$n_righe]['ID'];
				$TITOLO = $RigaTabellaDati[$n_righe]['titolo'];
				$LUOGO = $RigaTabellaDati[$n_righe]['luogo'];
				$EVENTO = $RigaTabellaDati[$n_righe]['evento'];
				
				/*$SQL_autori = "SELECT autore FROM autori WHERE ID_manifesto = '$ID';";
				$RS_autori = mysqli_query($DBConn,$SQL_autori) or die ("Errore SQL! [ $SQL_autori ]");
				$STR_AUTORI = "";
				while($ArrAutori = mysqli_fetch_array($RS_autori)){
					$STR_AUTORI .= $ArrAutori['autore']."; ";
				}
				if(strlen($STR_AUTORI) > 0){
					$STR_AUTORI = substr($STR_AUTORI,0,-2);
				}*/
				
				
				$SQL_date = "SELECT data FROM date WHERE ID_manifesto = '$ID';";
				$RS_date = mysqli_query($DBConn,$SQL_date) or die ("Errore SQL! [ $SQL_date ]");
				$STR_date = "";
				while($Arrdate = mysqli_fetch_array($RS_date)){
					$STR_date .= $Arrdate['data']."; ";
				}
				if(strlen($STR_date) > 0){
					$STR_date = substr($STR_date,0,-2);
				}

?>
					<tr class="bkg">
						<td scope="row"><a href="/scheda_manifesto.php?ID="></a></td>					
						<!--<td class="small"></td>-->
						<td class="small"></td>
						<td class="small"></td>
						<td class="small"></td>
					</tr>
<?			}
		}else{?>
			<tr class="empty">
				<!--<td colspan="5" height="30"><center>La ricerca non ha prodotto risultati.</center></td>-->
				<td colspan="4" height="30"><center>La ricerca non ha prodotto risultati.</center></td>
			</tr>
<?		}?>
				</tbody>
			</table>
			<!--/DOC INDEX -->
			<!--DOC NAV-->
			<div class="docNav">
				<div class="smallMenu">
					<ul class="withLabel">
						<li class="first">risultati/pag.:
							<ul>
<?
							for($i=0;$i<count($ArrOption);$i++){
								if($i == count($ArrOption)){
									$class_ArrOption = "last";
								}else{
									$class_ArrOption = "middle";
								}
								if ($ArrOption[$i] == $PR){?>
									<li class=""><span class="thisPage"></span></li>
<?								}else{?>
									<li class=""><a href="/indice_manifesti.php?PR="></a></li>
<?								}
							}
?>
							</ul>
						</li>
					</ul>
					<ul class="withLabel">
						<li class="first">pagina:
							<ul>
<?if ($TotPagine > $PaginePerBlocco){?>
			<?if ($PB != 1){?><li class="middle"><a href="/indice_manifesti.php?PB=&amp;PS=&amp;PR=" title="Visualizza i collegamenti alle  pagine precedenti">&lt;&lt;  prec.</a></li><?}?>
<?						for ($ContaPagine=$limite_inf;$ContaPagine<=$limite_sup;$ContaPagine++){
							if($ContaPagine == $limite_sup){
								$class_pagina = "last";
							}else{
								$class_pagina = "middle";
							}
							if ($ContaPagine == $PS){?>
								<li class=""><span class="thisPage"></span></li>
<?							}else{?>
								<li class=""><a href="/indice_manifesti.php?PS=&amp;PR=&amp;PB="></a></li>
<?							}
						}?>
			<?if ($PB != $TotPBlock){?><li class="last"><a href="/indice_manifesti.php?PB=&amp;PS=&amp;PR=" title="Visualizza i collegamenti alle  pagine successive"> succ. &gt;&gt;</a></li><?}?>
<?						
}else{
						for ($ContaPagine=1;$ContaPagine<=$TotPagine;$ContaPagine++){
							if($ContaPagine == $TotPagine){
								$class_pagina = "last";
							}else{
								$class_pagina = "middle";
							}
							if ($ContaPagine == $PS){?>
								<li class=""><span class="thisPage"></span></li>
<?							}else{?>
								<li class=""><a href="/indice_manifesti.php?PS=&amp;PR=&amp;PB="></a></li>
<?							}
						}
}
?>
							</ul>
						</li>
					</ul>
				</div>
			</div>
			<!--/DOC NAV-->
			
		<!--FOOTER-->
		<? include("includes/secondary_footer.php");?>
		<!--/FOOTER-->
		</body>
</html>
<?
//Chiudo la connessione al DataBase
mysqli_close($DBConn);
?>