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

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


$xtpl = new XTemplate('templates/prodotti-lista.html');

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

$count = 0;

$QueryList  = "SELECT ".TABLE_PRODOTTI.".ID, ".TABLE_PRODOTTI.".ParentId, ".TABLE_PRODOTTI.".CatId, ".TABLE_PRODOTTI.".Visible,  ".TABLE_PRODOTTI_DETT.".RefId, ".TABLE_PRODOTTI_DETT.".ItemTitle, ".TABLE_PRODOTTI_DETT.".ItemText, ".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.".ParentId = '".$catId."' AND ".TABLE_PRODOTTI.".Visible = '1' ORDER BY ".TABLE_PRODOTTI.".ItemPos ASC, ".TABLE_PRODOTTI.".ID ASC";
$queryList  = mysqli_query($conn, $QueryList);
while ($itemList  = mysqli_fetch_array($queryList)) {	

	$count++;
	
	$xtpl->assign('prodId', $itemList['RefId']);
	$xtpl->assign('catId', $itemList['CatId']);
	$xtpl->assign('itemTitle', $itemList['ItemTitle']);
	$xtpl->assign('itemText', $itemList['ItemText']);
	
	$xtpl->assign('spaceTop', '');
	
	if($count > 1){
		$xtpl->assign('spaceTop', 'spaceTop');
	}
	
	
	$xtpl->assign('countGal', $count);
	
	if(LANG != "it") {
		$linkRev = SITE_URL.LANG."".cleanString(getMenuName2($catId))."/".cleanString($itemList['ItemTitle'])."-".$itemList['ID'];
	}
	else {
		$linkRev = SITE_URL."".cleanString(getMenuName2($catId))."/".cleanString($itemList['ItemTitle'])."-".$itemList['ID'];
	}
	
	//$linkRev = SITE_URL."prodotti_dettaglio.php?catId=".$itemList['ID'];
	
	$xtpl->assign('linkRev', $linkRev);
	 
	$countImg = 0;
	$xtpl->assign('pImg', '');
	$xtpl->assign('altText', "");
	$xtpl->assign('imgTitle', "");
		
	$QueryImg = "SELECT * FROM ".TABLE_PRODOTTI_IMGS." WHERE RefId = '".(int)$itemList['RefId']."' 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('altText', $infoImg['AltText']);
		$xtpl->assign('imgTitle', $infoImg['ImgTitle']);
	
		$countImg++;
	}	
	
	if((int)$countImg == 0) {
		$QueryImg2 = "SELECT * FROM ".TABLE_PRODOTTI_IMGS." WHERE RefId = '".(int)$itemList['RefId']."' AND SecId = '1' ORDER BY ItemPos ASC, ID DESC";
		$queryImg2 = mysqli_query($conn, $QueryImg2);
		while($infoImg2 = mysqli_fetch_array($queryImg2)) {
			$xtpl->assign('pImg', PATH_V_PRODOTTI_IMG.$infoImg2['ItemImg']);
			
			$xtpl->assign('altText', $infoImg2['AltText']);
			$xtpl->assign('imgTitle', $infoImg2['ImgTitle']);
		}
	}

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


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