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

include_once(ROOT_PATH."modules/menu/inc/config.php");


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

$catId = (int)$_GET['catid'];

//$xtpl->assign('catName', getMenuTabList( (int)$_GET['catid'], LANG));

$count = 0;

$QueryList  = "SELECT ".TABLE_PRODOTTI.".ID, ".TABLE_PRODOTTI.".Visible,  ".TABLE_PRODOTTI_DETT.".RefId, ".TABLE_PRODOTTI_DETT.".ItemTitle, ".TABLE_PRODOTTI_DETT.".ItemLang 
FROM ".TABLE_PRODOTTI." LEFT JOIN ".TABLE_PRODOTTI_DETT." ON ".TABLE_PRODOTTI.".ID =  ".TABLE_PRODOTTI_DETT.".RefId 
WHERE ".TABLE_PRODOTTI_DETT.".ItemLang = '".LANG."' AND ".TABLE_PRODOTTI.".Visible = '1' LIMIT 0,1";

$queryList  = mysqli_query($conn, $QueryList);
while ($itemList  = mysqli_fetch_array($queryList)) {	

	$count++;
	
	$xtpl->assign('itemTitle', $itemList['ItemTitle']);
	
	if(LANG != "it") {
		$linkRev = SITE_URL.LANG."/prodotti/".cleanString($itemList['ItemTitle'])."-".$itemList['ID'];
	}
	else {
		$linkRev = SITE_URL."prodotti/".cleanString($itemList['ItemTitle'])."-".$itemList['ID'];
	}

	
	$xtpl->assign('linkRevProd', $linkRev);
		
	$xtpl->assign('last', "");
	
	if($count == 4) {
		$xtpl->assign('last', "-last");
		$count = 0;
	}
	
	
	$QueryImg = "SELECT * FROM ".TABLE_PRODOTTI_IMGS." WHERE RefId = '".(int)$itemList['ID']."' AND SecId = '2' ORDER BY ItemPos ASC, ID DESC";
	$queryImg = mysqli_query($conn, $QueryImg);
	while($infoImg = mysqli_fetch_array($queryImg)) {
		
		$xtpl->assign('pImg', PATH_V_PRODOTTI_IMG.$infoImg['ItemImg']);
		$xtpl->assign('zoomImg', SITE_URL.PATH_V_PRODOTTI_IMG.$infoImg['ItemImg']);
		
		if(file_exists (PATH_V_PRODOTTI_IMG.$infoImg['ItemImg'])) {
			$xtpl->parse('main.viewProd.viewImgProd');
		}
	}	
	
	/*
	$QueryInt2  = "SELECT * FROM ".TABLE_MENU." WHERE ParentId = '".$itemInt['ID']."' AND Visible = '1' ORDER BY ItemPos ASC";
	$queryInt2 = mysqli_query($conn, $QueryInt2);
	while ($itemInt2 = mysqli_fetch_array($queryInt2)) {
		
		$xtpl->assign('itemMenuInt2', getMenuName($itemInt2['ID'], LANG));
		$xtpl->parse('main.viewItemInt.viewItemInt2');	
	}
	*/
	
	$xtpl->parse('main.viewItem');			
}


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