<?php
include_once("inc/includes.php");

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

$rowsPerPage = 10;

$pageNum = 1;


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

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

$rows = 0;


$count = 0;

$Query = "SELECT * FROM ".TABLE_CONTENTS." WHERE Visible > '0' AND ItemLang = '".LANG."' AND TypeId = '1' ORDER BY ItemPos ASC, DateIns ASC, ID ASC LIMIT $offset, $rowsPerPage";
$query = mysqli_query($conn, $Query);
$totRows = mysqli_num_rows($query);
while($items = mysqli_fetch_array($query)) {
	
	$xtpl->assign('totRows', $totRows);

	$count++;
	
	$xtpl->assign('ID', $items['ID']);
	$xtpl->assign('cDate', date("d/m/Y", $items['DateIns']));
	$xtpl->assign('dataText', $items['DataText']);
	$xtpl->assign('cTitle', txtAbstract($items['ItemTitle'], 30));
	
	
	$linkRev = SITE_URL."azienda/".cleanString($items['ItemTitle'])."-".$items['ID'];
	
	$xtpl->assign('linkRev', $linkRev);
	
	$xtpl->assign('active1', '');
	$xtpl->assign('active2',  '');

	if((int)$_GET['itemid'] == $items['ID']){
		$xtpl->assign('active1', 'active');
		$xtpl->assign('active2',  'active');	
	}			
		
	$xtpl->parse('main.itemConList');
}

if((int)$totNews == 0) {
	$xtpl->parse('main.viewNoEv');
}

$QueryNav = "SELECT COUNT(ID) AS numrows FROM ".TABLE_CONTENTS." WHERE TypeId = '1'";
$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');
?>