<?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;

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

$Query  = "SELECT * FROM ".TABLE_USR."  WHERE ID > 0 ".$queryFilter." ORDER by Username ASC, 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('name', $items['Name']);
	$xtpl->assign('surname', $items['Surname']);
	$xtpl->assign('uName', $items['Username']);
	
	$xtpl->parse('main.ItemList');
}
		
$QueryNav = "SELECT COUNT(ID) AS numrows FROM ".TABLE_USR."";
$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");
?>