<?php

require_once("inc/config.php");

require_once("../../header.php"); 

require_once("inc_menu.php");

$xtpl = new XTemplate('templates/list.html');


$rowsPerPage = 20;

$pageNum = 1;


if(isset($_GET['page'])) {
	$pageNum = $_GET['page'];
}

$offset = ($pageNum - 1) * $rowsPerPage;

$rows = 0;

$queryFilter .= "";

$queryLang = " AND ItemLang = 'it'";

if($_GET['filterKey'] != "") {
	$queryFilter = " AND ItemTitle LIKE '%".$_GET['filterKey']."%'";
}

if($_GET['filterLang'] != "") {
	$queryLang = " AND ItemLang = '".$_GET['filterLang']."'";
}

$xtpl->assign('comboLang', getComboLang($_GET['filterLang']));

$Query  = "SELECT * FROM ".TABLE_NEWS."  WHERE ID > 0  ".$queryFilter." ".$queryLang." ORDER by DateIns DESC, ID DESC LIMIT $offset, $rowsPerPage";
$query = mysqli_query($conn, $Query);
while($items = mysqli_fetch_array($query)) {

	$rows++;

	if($rows % 2) {
		$xtpl->assign('rows', 'row0');
	}
	else {
		$xtpl->assign('rows', 'row1');
	}
		
	$xtpl->assign('ID', $items['ID']);
	//$xtpl->assign('date', date("d/m/Y", $items['DateIns']));
	$xtpl->assign('itemTitle', $items['ItemTitle']);
	$xtpl->assign('itemLang', $items['ItemLang']);
	
	$xtpl->parse('main.ItemList');
}


$QueryNav = "SELECT COUNT(ID) AS numrows FROM ".TABLE_NEWS."";
$queryNav = mysqli_query($conn, $QueryNav);
$infoNav = mysqli_fetch_array($queryNav);

$numrows = (int)$infoNav['numrows'];

if($numrows > $rowsPerPage) {	

	$maxPage = ceil($numrows/$rowsPerPage);

	$xtpl->assign('nav', getNav($pageNum, $numrows, $maxPage));

	$xtpl->parse('main.viewNav');
}

$xtpl->parse('main');
$xtpl->out('main');

require_once("../../footer.php");
?>