<?php
 	 	include_once "inc/script_iniziali.php";
	$idpagina=2;
	$Tpagina="P";
	
	$percorso="";
	$percorsoIMG="https://www.ideal-tek.com/";
	$nImg=-1;
	include_once $percorso."admin/inc/open_db.php";
	
	if ($db_found) {
	include_once "inc/sost.php";
	include_once "inc/lingue.php";

	include_once "inc/func/query_tag.php";
		
	$debugAP=$_REQUEST["debugAP"];
		
	$MacroCat=$_REQUEST["m"];
	$MacroCatExc=$_REQUEST["mf"];
	
	$famiglia=$_REQUEST["f"];
	$categoria=$_REQUEST["c"];
        //eccezione per problemi legali ed impossibilità utilizzare htaccess
        //die("$MacroCatExc");
        
        if($categoria=="tweezer-kit"&&$MacroCatExc==100){
            Header( "HTTP/1.1 301 Moved Permanently" );
            Header( "Location: https://www.ideal-tek.cn/catalogue/8/tweezers/tweezer-kits" );
            die();
        }   
        
        if($categoria=="Teflon-Coated-Tweezers"&&$MacroCatExc==100){
            Header( "HTTP/1.1 301 Moved Permanently" );
            Header( "Location: https://www.ideal-tek.cn/catalogue/8/tweezers/ptfe-coated-tweezers" );
            die();
        }        

        if($categoria=="Teflon-Coated-Tweezers"){
            Header( "HTTP/1.1 301 Moved Permanently" );
            Header( "Location: https://www.ideal-tek.cn/products/2/life-science-microscopy/8/tweezers/PTFE-coated-tweezers" );
            die();
        }

		if($categoria=="micro-shears-and-micro-pliers"){
            Header( "HTTP/1.1 301 Moved Permanently" );
            Header( "Location: https://www.ideal-tek.cn/catalogue/1/cutters-and-pliers" );
            die();
        }

        
		if($MacroCatExc==100&&$categoria){$MacroCat="search";}
	$categoria=str_replace("*and*","&",$categoria);
	$categoria=str_replace("***","&",$categoria);
	$categoria=str_replace("---","**",$categoria);
	$categoria=str_replace("-"," ",$categoria);
	$categoria=str_replace("**","-",$categoria);
	$categoria=str_replace(" wick","-wick",$categoria);
	$categoria=str_replace("medical grade","medical-grade",$categoria);
	$categoria=str_replace("micro s","micro-s",$categoria);
	$categoria=str_replace("micro-scissors","micro scissors",$categoria);
	$categoria=str_replace("micro p","micro-p",$categoria);
	$categoria=str_replace("high tek","high-tek",$categoria);
	$categoria=str_replace("wi fi","wi-fi",$categoria);
	$livello=$_REQUEST["l"];
	$MacroCatN=(int)$MacroCat+4;
        
	include_once "inc/arrayCampi.php";
        
    $idTestiMarket=383+(int)$MacroCat;
    $SQL = "SELECT * FROM articoli where id_art=$idTestiMarket and attivo=1";
    $result = mysqli_query($db, $SQL);
    $num_r = $result ? mysqli_num_rows($result) : 0;
    if($result && $num_r>0){ 
        $db_field = $result ? mysqli_fetch_assoc($result) : null;
        $fotoPagina=$db_field["foto1"];
    }//end if
    $nomeFamiglia=ucfirst($titoloFamiglia[$famiglia]);
    $SQL = "SELECT * FROM articoli where tipo=36 and titolo='$nomeFamiglia' and attivo=1";
    $result = mysqli_query($db, $SQL);
    $num_r = $result ? mysqli_num_rows($result) : 0;
    if($result && $num_r>0){ 
        $db_field = $result ? mysqli_fetch_assoc($result) : null;
        $fotoS=$db_field["foto1"]; 
        if(!$fotoS){$fotoS=$fotoPagina;}
        $fotoPagina=$fotoS;
		$corpoS=$db_field['campo6'];
         $descCHI=fixChineseEncoding($db_field['corpo_i']);
            if($descCHI){$descCat=$descCHI;}else{$descCat=$corpoS;}
		//$descCat=$corpoS;
        $abstractPagina=TagliaStringaEPulisci($descCat, 350);
		//$titleTag=$db_field["campo6_title"];
		$descrTag=$db_field["campo6_descr"];
        //$h1personalizzato=$db_field["campo6_h1"];
         $descSottoCHI=fixChineseEncoding($db_field['abstract_i']);
            if($descSottoCHI){$testosotto=$descSottoCHI;}else{$testosotto=fixChineseEncoding($db_field["campo".$idCampoF."_testo"]);}
		//$testosotto=$db_field["campo6_testo"];
        
    }//end if 
        
	
	$colMacroCat="c".$MacroCatN;

	
	//disabilitato per testo differenziato per ogni market 26-03-2019
/*	$SQL = "SELECT * FROM g_0_text where parametro='$categoria' order by id_cat_txt desc ";
	//print $SQL;
	$result = mysqli_query($db, $SQL);
	$db_field = $result ? mysqli_fetch_assoc($result) : null;
	$descCat=$db_field['corpo'];*/
	

	$idCampoF=(int)$MacroCat+1;
	
	if($MacroCat=='search'){$idCampoF=6;}
		
    $SQL = "SELECT * FROM articoli where tipo=37 and titolo=? and attivo=1";

    $result = db_query($db, $SQL, array($categoria));
    $num_r = $result ? mysqli_num_rows($result) : 0;
        
        //print $SQL.$num_r;
    if($result && $num_r>0){ 
        $db_field = $result ? mysqli_fetch_assoc($result) : null;
        $titoloPagina=$db_field["titolo"]; 
        $titoloPagina=$titoloPagina;
        $titoloPagina=cntranslate($db_found,$titoloPagina);
		 $fotoS=$db_field["foto1"]; 
        if(!$fotoS){$fotoS=$fotoPagina;}
        $fotoPagina=$fotoS;
		//if per serach by products
		if($MacroCat<100){
        $corpoS=$db_field['campo'.$idCampoF];
/*        if(!$corpoS){$corpoS=$db_field['campo1'];}
        if(!$corpoS){$corpoS=$db_field['campo2'];}
        if(!$corpoS){$corpoS=$db_field['campo3'];}
        if(!$corpoS){$corpoS=$db_field['campo4'];}
        if(!$corpoS){$corpoS=$db_field['campo5'];}
        if(!$corpoS){$corpoS=$corpoMarket;}*/
            $descCHI=fixChineseEncoding($db_field['corpo_i']);
            if($descCHI){$descCat=$descCHI;}else{$descCat=$corpoS;}
        $abstractPagina=TagliaStringaEPulisci($descCat, 350);
		//$titleTag=$db_field["campo".$idCampoF."_title"];
		$descrTag=$db_field["campo".$idCampoF."_descr"];
		$h1personalizzato=$db_field["campo".$idCampoF."_h1"];
            $descSottoCHI=fixChineseEncoding($db_field['abstract_i']);
            if($descSottoCHI){$testosotto=$descSottoCHI;}else{$testosotto=fixChineseEncoding($db_field["campo".$idCampoF."_testo"]);}
		
            
		}
    }//end if

		
//ELENCO PIF
if($_SESSION["logged"]=="x24fg56_disabled"){
	
	$SQL = "SELECT c2 FROM g_PIF WHERE attivo=1";
	//print $SQL;
	$result = mysqli_query($db, $SQL);
	$num_r = $result ? mysqli_num_rows($result) : 0;
	if($result && $num_r>0){
		while ($result && ($db_field = mysqli_fetch_assoc($result))) {
			$pifElenco[]=$db_field["c2"];
		}//end while
	}//end if
}


//filtri normali e con like
$paramsF=array();
for($i = 1; $i < 200; ++$i) {
	$cfiltro=$_REQUEST["c".$i];
	if($cfiltro){
		$classDescCat="none";
		$orPartsF=array();
		$cfiltri=array();
		$cfiltri = explode("|", $cfiltro);
		$cF[$i]=array();
			foreach ($cfiltri as &$cfiltroP) {
				if($cfiltroP<>""){
					$cfiltroP=str_replace("*and*","&",$cfiltroP);
					$cfiltroP=str_replace("*piu*","+",$cfiltroP);
					$cF[$i][]=$cfiltroP;
						if($i==62||$i==63||$i==64){
							$cfiltroPEcc62=$cfiltroP;
					$orPartsF[]="c".$i." like ?";
					$paramsF[]="%$cfiltroP%";
						}else{
					$orPartsF[]="c".$i."=?";
					$paramsF[]=$cfiltroP;
						}
				}
			}

		$whereF.=" and (".implode(" or ",$orPartsF).")";
			if($cfiltroPEcc62=="fine"){$whereF.=" and (c62 NOT like'%extra fine%' and c62 NOT like'%ultra fine%' and c62 NOT like'%very fine%')";}
			if($cfiltroPEcc62=="large"){$whereF.=" and (c62 NOT like'%extra large%' and c62 NOT like'%extra extra large%')";}
			if($cfiltroPEcc62=="extra large"){$whereF.=" and (c62 NOT like'%extra extra large%')";}
			if($cfiltroPEcc62=="sharp"){$whereF.=" and (c63 NOT like'%very sharp%')";}

	}
}

//filtri numerici
$cFN[1000][]="1000";
$cFN[1000][]="1000";
for($i = 1; $i < 200; ++$i) {
	$cfiltro=$_REQUEST["cn".$i];
	if($cfiltro){
		$classDescCat="none";
		$cfiltri=array();
		$cfiltri = explode("|", $cfiltro);
		$cFN[$i]=array();
		foreach ($cfiltri as &$cfiltroN) {
			if($cfiltroN){
				$cFN[$i][]=$cfiltroN;
			}
		}
		$whereF.=" and (c".$i.">=? and c".$i."<=?)";
		$paramsF[]=$cfiltri[0];
		$paramsF[]=$cfiltri[1];
	}
}

        $whereF.=" and c28='x'";
        
		//print_r($cF);

//print $whereF;
	
	$colSearch="t1.c1,";

	$titoloColonna[]=$titoloCampo[0];
	$campoColonnaAr[]="c1";
	$NCampo=0;
	$SQL = "SELECT campo FROM g_2_family_tab WHERE id_family=$famiglia";
	//print $SQL;
	$result = mysqli_query($db, $SQL);
	$num_r = $result ? mysqli_num_rows($result) : 0;
	if($result && $num_r>0){
		while ($result && ($db_field = mysqli_fetch_assoc($result))) {
			if($NCampo==0){
				if($MacroCat==""){
					$colSearch=$colSearch."c10,";
					$campoColonnaAr[]="c10";
					$indexColonnaS=9;
					$titoloS=$titoloCampo[$indexColonnaS];
					$titoloColonna[]=$titoloCampo[$indexColonnaS];
				}
			}
			$campoColonnaS=$db_field["campo"];
			$campoColonnaAr[]=$campoColonnaS;
			$colSearch=$colSearch.$campoColonnaS.",";
			//print "col=".$campoColonnaS."<br>";
			$indexColonnaS=str_replace("c","",$campoColonnaS);
			$indexColonnaS=str_replace("C","",$indexColonnaS);
			$indexColonnaS=(int)$indexColonnaS;
			$indexColonnaS=$indexColonnaS-1;
			//print "col2=".$indexColonnaS."<br>";
			$titoloS=$titoloCampo[$indexColonnaS];
			//print "tit=".$titoloS."<br><br>";
			$titoloColonna[]=$titoloCampo[$indexColonnaS];
			$NCampo++;
		}//end while
	}//end if
	$colSearch=substr($colSearch, 0, -1);
	$ColonnaCount=count($titoloColonna);
	for ($x = 0; $x <$ColonnaCount; $x++) {
		$valColonna[$x]=0;
	}
		
	if($_SESSION["logged"]=="x24fg56"){
		$whereC3="";
		$whereC3B="";
	} else {
		$whereC3="t1.c3<>'-' and (t1.c31='' or t1.c31='x' or t1.c31='production') and ";
		$whereC3B="c3<>'-' and (c31='' or c31='x' or c31='production') and ";
	}
		
	$rowsPerPage = 30;
	if($MacroCat==""){
        //eccezione/modifica query per nextmart e prodotti doppi del 5 maggio 2023 - modifica R01-v01
        $query   = "SELECT COUNT(distinct(t1.c2)) AS numrows from g_4_data AS t1 inner JOIN g_4_data_b AS t2 on t1.c2=t2.c2 WHERE $whereC3 t1.c9 = ? $whereF";
		$queryParams = array_merge(array($titoloFamiglia[$famiglia]), $paramsF);
	} else {
        //eccezione/modifica query per nextmart e prodotti doppi del 5 maggio 2023 - modifica R01-v01
		$query   = "SELECT COUNT(distinct(t1.c2)) AS numrows from g_4_data AS t1 inner JOIN g_4_data_b AS t2 on t1.c2=t2.c2 WHERE $whereC3 t1.$colMacroCat = 'yes' AND t1.c9 = ? AND t1.c10 = ? $whereF";
		$queryParams = array_merge(array($titoloFamiglia[$famiglia], $categoria), $paramsF);
	}

	//eccezione inserita per debug breadcrump da ricerca 05-06-2018
	if($MacroCat=="search"&&$categoria){
        //eccezione/modifica query per nextmart e prodotti doppi del 5 maggio 2023 - modifica R01-v01
		$query   = "SELECT COUNT(distinct(t1.c2)) AS numrows from g_4_data AS t1 inner JOIN g_4_data_b AS t2 on t1.c2=t2.c2 WHERE $whereC3 t1.c9 = ?  AND t1.c10 = ? $whereF";
		$queryParams = array_merge(array($titoloFamiglia[$famiglia], $categoria), $paramsF);
	}

//print $query;

		$result  = db_query($db, $query, $queryParams) or die('Error, query failed');
	$row     = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$numrows = $row['numrows'];
	$maxPage = ceil($numrows/$rowsPerPage);
	parse_str($_SERVER['QUERY_STRING'], $selfParams);
	unset($selfParams['page']);
	$selfQuery = http_build_query($selfParams);
	$self = $_SERVER['PHP_SELF'].($selfQuery !== '' ? "?".$selfQuery : "?");
	$nav  = '';
	$pageNum = 1;
	if(isset($_GET['page'])) {$pageNum = $_GET['page'];}
	if(!is_numeric($pageNum)){$pageNum=1;}
		
	if ($pageNum >= 10){	
		$Mleft=240+(30*($pageNum-10));
		$stylePagerContainer="style='margin-left:-".$Mleft."px;'";
	}	
	
	for($page = 1; $page <= $maxPage; $page++){
		if ($page == $pageNum){
		   $nav .= "<a href='#' class='btn nolink Sel'><b>$page</b></a>";
		} else {
		   $nav .= " <a href='$self&page=$page".$varbasepagine."' class='btn'>$page</a> ";
		}
	}
	for($page = $maxPage; $page >= 1; $page--){
		if ($page == $pageNum){
		   $nav2 .= "<a href='#' class='btn nolink Sel'>$page</a>";
		} else {
		   $nav2 .= " <a href='$self&page=$page".$varbasepagine."' class='btn'>$page</a> ";
		}
	}
		
		$pageNext=$pageNum+1;
		if($pageNext>$maxPage){
			$pageNext=$maxPage;
		}
		$pagePrev=$pageNum-1;
		if($pagePrev<1){
			$pagePrev=1;
		}
	

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

//aggiutamento contatore per varianti (prodotti con stesso codice c1)
$query=str_replace("COUNT(id_pro)","COUNT(distinct t1.c1)",$query);
		
		$result  = db_query($db, $query, $queryParams) or die('Error, query failed');
	$row     = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$numrowsC = $row['numrows'];

	if($MacroCat==""||$MacroCat=="search"){
		$SQL = "SELECT $colSearch, id_pro,t1.c2,c37,t1.c1  FROM g_4_data AS t1 inner JOIN g_4_data_b AS t2 on t1.c2=t2.c2 WHERE $whereC3 t1.c9 = ? $whereF order by t1.c36 LIMIT $offset, $rowsPerPage";
		$SQLParams = array_merge(array($titoloFamiglia[$famiglia]), $paramsF);
	} else {
		$SQL = "SELECT $colSearch, id_pro,t1.c2,c37,t1.c1 FROM g_4_data AS t1 inner JOIN g_4_data_b AS t2 on t1.c2=t2.c2 WHERE $whereC3 t1.$colMacroCat = 'yes' AND t1.c9 = ? AND t1.c10 = ? $whereF order by t1.c36 LIMIT $offset, $rowsPerPage";
		$SQLParams = array_merge(array($titoloFamiglia[$famiglia], $categoria), $paramsF);
	}


	//eccezione inserita per debug breadcrump da ricerca 05-06-2018
	if(($MacroCat=="search")&&$categoria){
		$SQL = "SELECT $colSearch, id_pro,t1.c2,c37,t1.c1  FROM g_4_data AS t1 inner JOIN g_4_data_b AS t2 on t1.c2=t2.c2 WHERE $whereC3 t1.c9 = ? AND t1.c10 = ? $whereF order by t1.c36 LIMIT $offset, $rowsPerPage";
		$SQLParams = array_merge(array($titoloFamiglia[$famiglia], $categoria), $paramsF);
	}


	//print $SQL."<br>$MacroCatExc - $categoria";

        //raggruppamento aggiunto per nextmart e prodotti doppi del 5 maggio 2023 - modifica R01-v01
        $SQL=str_replace("order"," group by c2 order",$SQL);

//memorizzo in session per pif massivo
$_SESSION["sqlPagPrec"]=$SQL;
$_SESSION["sqlPagPrecParams"]=$SQLParams;

	if($bebugQuery=="777"){	?><div class="none"><?=$SQL;?></div><?php }

	$contRiga=0;
	$result = db_query($db, $SQL, $SQLParams);
	$num_r = $result ? mysqli_num_rows($result) : 0;

	if($result && $num_r>0){
		while ($result && ($db_field = mysqli_fetch_assoc($result))) {
			for ($x = 0; $x <$ColonnaCount; $x++) {
				$caratteristicaProdottoS=$db_field[$campoColonnaAr[$x]];
				if($campoColonnaAr[$x]=="c37"){
					if($caratteristicaProdottoS=="-"){
						$caratteristicaProdottoS=$db_field["c1"];
					}
				}
                //traduzione descrizione
                if($campoColonnaAr[$x]=="c26"){
                                        $SQLtr = "select titolo,corpo from g_4_testi_cn where c2 = '".$db_field["c2"]."'";
                                        $resulttr = mysqli_query($db, $SQLtr);
                                        $num_rtr = $resulttr ? mysqli_num_rows($resulttr) : 0;
                                        if($resulttr && $num_rtr>0){
                                            $db_fieldtr = $resulttr ? mysqli_fetch_assoc($resulttr) : null;
                                                        $caratteristicaProdottoS=$db_fieldtr['titolo'];
                                        }else{
                                            $codiceBaseTC=$db_field["c36"];
                                            $codiceBaseTC1=$codiceBaseTC.".IT";
                                            $codiceBaseTC2=$codiceBaseTC.".ITE";
                                            $codiceBaseTC3=$codiceBaseTC.".ITU";
                                            $SQLtr = "select titolo,corpo from g_4_testi_cn where chiave = '".$codiceBaseTC."' or chiave = '".$codiceBaseTC1."' or chiave = '".$codiceBaseTC2."' or chiave = '".$codiceBaseTC3."'";
                                                $resulttr = mysqli_query($db, $SQLtr);
                                                $num_rtr = $resulttr ? mysqli_num_rows($resulttr) : 0;
                                                if($resulttr && $num_rtr>0){
                                                    $db_fieldtr = $resulttr ? mysqli_fetch_assoc($resulttr) : null;
                                                                $caratteristicaProdottoS=$db_fieldtr['titolo'];
                                                }
                                        }
                                    }
                
                //eccezione codici per nextmart e prodotti doppi del 5 maggio 2023 - modifica R01-v01
                if($campoColonnaAr[$x]=="c37"||$campoColonnaAr[$x]=="c1"){
					$caratteristicaProdottoS=ripuliscicodice($caratteristicaProdottoS);
				}
                
				$caratteristicaProdotto[$contRiga][$x]=$caratteristicaProdottoS;
			}

			$x++;
			$caratteristicaProdotto[$contRiga][$x]=$db_field["id_pro"];

				$idp=$db_field["c2"];
				$c1att=$db_field["c1"];

				$fotoS="nofoto.jpg";
				$PosizioneFotoS=1;
				$SQLF = "select posizione,foto from g_4_foto where c2 = '$idp' order by posizione";
				$resultF = mysqli_query($db, $SQLF);
				$num_rF = $resultF ? mysqli_num_rows($resultF) : 0;
				if($resultF && $num_rF>0){
					$db_fieldF = $resultF ? mysqli_fetch_assoc($resultF) : null;
					$fotoS=$db_fieldF['foto'];
					$PosizioneFotoS=$db_fieldF['posizione'];
				}
				$fotoProdotto[$contRiga]=$fotoS;
				$ProdottoID[$contRiga]=$idp;
				$fotoProdottoPos[$contRiga]=$PosizioneFotoS;


						//elimino dati per varianti prodotto (stesso codice)
						if($c1att==$c1prec){
								$caratteristicaProdotto[$contRiga][0]="";
								$caratteristicaProdotto[$contRiga][4]="";
								$caratteristicaProdotto[$contRiga][2]="";
								$caratteristicaProdotto[$contRiga][3]="";
								$caratteristicaProdotto[$contRiga][5]="";
								$caratteristicaProdotto[$contRiga][6]="";
								$caratteristicaProdotto[$contRiga][7]="";
								$caratteristicaProdotto[$contRiga][8]="";
								$caratteristicaProdotto[$contRiga][9]="";
									$fotoProdotto[$contRiga]="";
									$fotoProdottoPos[$contRiga]="";
						}
							$c1prec=$c1att;

			$contRiga++;


		}//end while
	}//end if	
	
	$nImg=-1;
		for ($q = 0; $q <$ColonnaCount; $q++) {
			for ($z = 0; $z <$contRiga; $z++) {
				if($caratteristicaProdotto[$z][$q]<>"-"&&$caratteristicaProdotto[$z][$q]<>""&&$caratteristicaProdotto[$z][$q]<>"0.00"){
					$valColonna[$q]=1;
				}
			}
			//print "valCol".$q."=".$valColonna[$q];
		}
		
	
//query per title categorie
if($livello==3){
	$mcat=(int)$MacroCat+1;
$SQL = "SELECT * FROM g_1_market where id_market='".$mcat."'";
//print $SQL;
$result = mysqli_query($db, $SQL);
		$db_field = $result ? mysqli_fetch_assoc($result) : null;
		$titolo=$db_field['market']; 

$SQL = "SELECT * FROM g_2_family where id_family='".$famiglia."'";
//print $SQL;
$result = mysqli_query($db, $SQL);
		$db_field = $result ? mysqli_fetch_assoc($result) : null;
	if($categoria){
		//$pagina=$categoria." - ".$db_field['family']." in ".$titolo; 
        $pagina=cntranslate($db_found,$categoria)." - ".cntranslate($db_found,$db_field['family']);
	}else{$pagina=$db_field['family']; 
          $pagina=cntranslate($db_found,$pagina);
         }

}
	//variabile eccezione per filtri su nuove pagine sottocategorie
	$lf=$_REQUEST["lf"];
		
		
		$subcatf=$_REQUEST["c94"];
		if($subcatf){$subcatfiltro=" - $subcatf";}

		
	//impostazione canonical
	//variabile per eccezione url per search by product
	$sbprod=$_REQUEST["mf"];
	if ($livello>=1&&($MacroCat<>'search')&&$sbprod<>100) { 
	$BreadMacro=strtolower ($titolo);
	$BreadMacro=ucfirst($BreadMacro);
	$urlbc=cleanUrl($BreadMacro);
	$urlbcl1="products/".$MacroCat."/".$urlbc;
	 }
		
	$BreadFam=ucfirst($titoloFamiglia[$famiglia]);
	$urlbcf=cleanUrl($BreadFam);
	if(!$urlbcl1){$urlbcl1="catalogue";}
	$urlcan=$urlbcl1."/".$famiglia."/".$urlbcf;
	if($categoria){
	$categoriaU=str_replace("-","---",$categoria);
	$categoriaU=str_replace(" ","-",$categoriaU);
	$urlcan.="/".$categoriaU;
	}
		
		if($pageNum>1){$urlcan.="?page=$pageNum";}
		$urlcan=strtolower($urlcan);
		
		//query per subcat dinamiche
		$subcat=array();
		if($categoria){
		//if($MacroCatExc==100&&$MacroCat=="search"&&$categoria){
			$SQL="select distinct c94 from g_4_data where $whereC3B c10=? and c94<>'-'";
			$result = db_query($db, $SQL, array($categoria));
			$num_r = $result ? mysqli_num_rows($result) : 0;
				if($result && $num_r>0){
					while ($result && ($db_field = mysqli_fetch_assoc($result))) {
						$subcat[]=$db_field["c94"];
                        $subcatN++;
					}
				}
		}
        
//tag description dove non specificato
if(!$descrTag&&$abstractPagina){$descrTag=strip_tags($abstractPagina);}
if(!$descrTag&&$categoria){$descrTag="Here is a list of our ".strip_tags($categoria);}
        
$pagina=cntranslate($db_found,$pagina);
        
?> 
<!DOCTYPE html>
<html>
<head>
<?php  include "inc/head.php"?>
	
<link rel="canonical" href="https://www.ideal-tek.cn/<?=$urlcan?>"/>
</head> 

<body><!-- HTML structures -->

<?php  include "inc/loading.php"?>
<?php  include "inc/modali.php"?>
<div class="main">
<div class="main2">

    <?php  include "inc/header.php"?>
	
	<?php if($sifotoslidersopra==1){?>
     <div id="linea0" class="section " style="background-color:#eee;">
            <div class="slideshow slideshowP">
                <?php  
                  if(file_exists($percorsoIMG."public/images/crop/".$fotoPagina)){ 
                    $fotoP=$percorsoIMG."public/images/crop/".$fotoPagina;
                   } else {
                    $fotoP=$percorsoIMG."public/images/".$fotoPagina;
                   }?>
                <div class="slideshowFoto" style="background-image:url('<?=$fotoP;?>');"></div><!--foto-->
            </div><!--slideshow-->
    </div><!--section--> 	
	<?php }else{?>
	    <div id="linea0"  class="section " style="background-color:#f3f3f3;height:80px;z-index:1;"> </div>
	<?php }?>
    <div class="container">  
        <div class="section" style="overflow:visible;">
        	<div class="row ">
            	<div class="col-md-3 col-xs-12 ">
               		<?php  include "inc/menu_laterale.php"?>
                	<?php  include "inc/menu_filtri.php"?>
                </div>

                <div class="col-md-9 col-xs-12 " style="min-height:400px;">
                    <div class="boxBase6">
                    <?php  include "inc/breadcrumb.php"?>
                    <?php  if($MacroCat=='search'){if($categoria){$titoloH1=$BreadCat;}else{$titoloH1=$BreadFam;}}else{$titoloH1=$BreadCat;}
                        
                        if($h1personalizzato) {$titoloH1=$h1personalizzato;}              
        
        $titoloH1=cntranslate($db_found,$titoloH1);
                        ?>
                    <h1 class="h1Base"><?=htmlspecialchars($titoloH1, ENT_QUOTES, 'UTF-8').$subcatfiltro;?></h1>

                    	<?php if($_SESSION["logged"]=="x24fg56_disabled"){?>
                    	
						<!--<a href="#" class="IT-btnSalva IT-btnSalva3 backVerde">Publish new product</a>-->
                   		<a href="pif-list.php" class="IT-btnSalva IT-btnSalva3 backBlu">Display PIF</a>
                   		<div class="clear"></div>
                    	<?php  }//end if ?>
                    	<?php  if($descCat<>""){?>
                            <div class="corpoPagina corpoPagina6 <?=$classDescCat;?>">
                                <div class="baseTxt"><?=$abstractPagina;?></div>
                                <div class="moreTxt"><?=$descCat;?></div>
                            </div>
                            <?php  if($descCat){?><a class="moreBtn <?=$classDescCat;?>"><?=$eti[4]//read more?> <i class="fa fa-angle-down" aria-hidden="true"></i></a><?php }?>
                        <?php  }//end if ?>
                    	<?php  if($_SESSION["logged"]=="x24fg56-disabled-ora-da-cms"&&$_SESSION["loggedSalva"]==1){?><a id="btnModTxtCat" class="IT-btnSalva IT-btnSalva5 backRosso">Edit text</a><?php  }//end if ?>
						
						
					<!--ANTEPRIMA sottoCATEGORIE PRODOTTO-->
						<?php  //if($titoloH1=="Hard wire cutters"){$subcat=array("Tungsten carbide","Medical device");}?>
					<?php  if($subcatN>1){?>
							<?php  if($subcatf){?>
						<div id="GoTab" class="" style="position: relative;display: block;cursor: pointer;width: 250px;margin-top: 20px;font-size: 14px;font-weight: 300;background-color: #253081;color:#fff;padding:3px 10px;"><?=$numrowsC;?> <?=$eti[30]//products found - Go to product list?></div>
							<?php }?>
						
							<div class="row row3" >
								<div class="titoloPagina8"><?=$titoloH1?> <?=cntranslate($db_found,"Subcategory");?>:</div>
							<?php   		$nlni=0;
									   foreach ($subcat as &$value) {
										   $linkfiltbase="https://www.ideal-tek.com/prodotti.php?m=".$MacroCat."&f=".$famiglia."&c=".$categoriaJS."&l=".$livello;
											$fotoMacro="";

											if(!$fotoMacro){$fotoMacro="nofoto.jpg";}
										   if($subcatf==$value){$stylescf="font-weight:bold;color:#253081!important";}else{$stylescf="";}
                                           
                                           $valueTCN=cntranslate($db_found,$value);
													?>
												<div class="col-md-2 col-sm-2 col-xs-6 colRow3">
													<a href="<?=$linkfiltbase;?>&c94=<?=$value?>" class="btnProdotto" style="margin-bottom:-30px;">
														<span class="img" style="background-image:url('<?=$percorsoIMG;?>public/upload/subcat/<?=$value;?>.jpg');"></span>
														<span class="titolo" style="font-size:12px;height: 32px;<?=$stylescf?>"><?=$valueTCN;?></span>
													</a>
												</div>
												<?php 
											$nlni++;	
											}//foreach 
									   ?>

								<div class="clear"></div>
							 </div><!--row-->
					<?php }?>
					<!--FINE DEMO ANTEPRIMA CATEGORIE PRODOTTO-->	
						
                    <!--ANTEPRIMA CATEGORIE PRODOTTO-->
					<?php  if($MacroCatExc==100&&$lf==""){?>
							<div id="GoTab" class="" style="position: relative;display: block;cursor: pointer;width: 250px;margin-bottom: 20px;font-size: 14px;font-weight: 300;background-color: #253081;color:#fff;padding:3px 10px;"><?=$numrowsC;?> <?=$eti[30]//products found - Go to product list?></div>
							<div class="row row3">
								<div class="titoloPagina8"><?=$titoloH1?> <?=cntranslate($db_found,"Category");?>:</div>
							<?php   		$nlni=0;
                                        $contC=0;
									   foreach ($titoloCatHeader[$BreadFam] as &$value) {
											$fotoMacro="";
										   	$linkCatD=$linkCatHeader[$BreadFam][$nlni];
											 $SQLCF = "SELECT DISTINCT foto,market FROM g_0_foto WHERE livello=3 and parametro='$value'";
												 $resultCF  = mysqli_query($db, $SQLCF);
												 $num_rCF = $resultCF ? mysqli_num_rows($resultCF) : 0;
												 if($resultCF  && $num_rCF >0){
													$db_fieldCF = $resultCF ? mysqli_fetch_assoc($resultCF) : null;
														$fotoMacro=$db_fieldCF['foto'];
												 }	
											if(!$fotoMacro){$fotoMacro="nofoto.jpg";}
                                           $valueTCN=cntranslate($db_found,$value);
                                           $categoriaTitolo[]=$value;
													?>
												<div class="col-md-2 col-sm-2 col-xs-6 colRow3">
													<a href="<?=$linkCatD;?>" class="btnProdotto">
														<span class="img" style="background-image:url('<?=$percorsoIMG;?>public/foto/thumb/<?=$fotoMacro;?>');"></span>
														<span class="titolo" style="font-size:12px;height: 32px;"><?=$valueTCN;?></span>
													</a>
                                                    <?php  if($_SESSION["logged"]=="x24fg56"){?>
													<div class="IT-boxMenu">
														<a id="btnElencoPdfC<?=$contC;?>" class="IT-btnIconaB backRossoS">DOC CH</a>
													</div>
													<?php  } ?>
												</div>
												<?php 
											$nlni++;$contC++;	
											}//foreach 
									   ?>

								<div class="clear"></div>
							 </div><!--row-->
					<?php }?>
					<!--FINE ANTEPRIMA CATEGORIE PRODOTTO-->	
                    <div class="row  MarginBottom10">
                    
                    <?php  	if(strtolower($titoloH1)=="digital microscopes"){$classColPdf="col-md-6 col-sm-6";}else{$classColPdf="col-md-12 col-sm-12";}
						$SQL = "SELECT etichetta,etichetta2,file,id_pdf from g_0_pdf where parametro=? order by posizione,id_pdf desc";
						$result = db_query($db, $SQL, array($categoria));
						$num_r = $result ? mysqli_num_rows($result) : 0;
						if($result && $num_r>0){
							?>
							<div class="col-md-12 col-sm-12 col-xs-12"><div class="titoloPdfE"><?=cntranslate($db_found,"Documents");?></div></div>
							<?php 
							while ($result && ($db_field = mysqli_fetch_assoc($result))) {
								$idpdf=$db_field["id_pdf"];
								$titolopdf=$db_field["etichetta2"];
                                if(!$titolopdf){
								    $titolopdf=$db_field["etichetta"];
                                    $titolopdf=cntranslateArray($db_found,$titolopdf,$baseeng,$basecn);
                                }
								$filepdf=$db_field["file"];
								?>
								<div class="<?=$classColPdf;?> col-xs-12">
								<a href="public/doc/<?=$filepdf;?>" class="btnPdfE" target="_blank">
								<?php 
								//se loggato(per ora per debug) se immagine cover pdf la mostro 
								//if($_SESSION["logged"]=="x24fg56"){
									$filejpg=str_replace(".pdf",".jpg",$filepdf);
									$cover='public/upload/cover/'.$filejpg;
									if (file_exists($cover)) {
										$titolopdfA=str_replace("'","",$titolopdf);?>
										<span class="img"><img src="<?=$cover;?>" alt="<?=$titolopdfA;?>" ></span>
									<?php } 
								 //}//end if 
                                
								?>

										<span class="label"><i class="fa fa-file-pdf-o" aria-hidden="true"></i> <?=$titolopdf;?></span>
								</a>
								</div>
								<?php 
							}
						}
					?>
                   		<div class="clear"></div>
                    </div><!--row-->
					<div class="pager2">
						<?php  $numrowsT=$numrowsC;
						if($numrowsT==0){$numrowsT="No";}
						?>
						<div class="titolo"><strong><?=$numrowsT;?> <?=$eti[27]//Products found?></strong></div>
						<?php  if($maxPage>1) { ?>
							<?php  if($maxPage>10 && $pageNum<($maxPage-8)) { ?><a href='<?=$self;?>&page=<?=$maxPage;?><?=$varbasepagine;?>' class='btnNP'><i class="fa fa-angle-double-right" aria-hidden="true"></i></a> <?php  }//end if?>
							<?php  if($pageNum<$maxPage) { ?><a href="<?=$self;?>&page=<?=$pageNext;?><?=$varbasepagine;?>" class="btnNP"><i class="fa fa-angle-right" aria-hidden="true"></i></a><?php  }//end if?>
							<div class="pagerBox"><div class="pagerContainer" <?=$stylePagerContainer;?>><?=$nav;?><div class="clear"></div></div></div>
							<?php  if($pageNum>1) { ?><a href="<?=$self;?>&page=<?=$pagePrev;?><?=$varbasepagine;?>" class="btnNP"><i class="fa fa-angle-left" aria-hidden="true"></i></a><?php  }//end if?>
							<?php  if($pageNum>=10 ) { ?><a href='<?=$self;?>&page=1<?=$varbasepagine;?>' class='btnNP'><i class="fa fa-angle-double-left" aria-hidden="true"></i></a> <?php  }//end if?>
							<div class="clear"></div>
						<?php  }//end if?>
						
					</div>
					<div class="table-container">
                    <div class="table">
                       <!-- TITOLI TABELLA-->
                         <div class="table-row BackGrigioScuro">
                			   <?php  for ($q = 0; $q <$ColonnaCount; $q++) { if($q<>0){$classBorder="borderTableRight";}else{$classBorder="";}?>
								   <?php  if($valColonna[$q]==1){
                             $titoloColonna[$q]=cntranslate($db_found,$titoloColonna[$q]);
                                    ?>
               			   			<div class="table-cell Color0 <?=$classBorder;?>"><?=$titoloColonna[$q];?></div><!--cell-->
                                     <?php  if($titoloColonna[$q]=="Short description"){$classAlign=$q;}?>
                			   	   <?php  } ?>
                			   <?php  } ?>
                			   <?php  if($_SESSION["logged"]=="x24fg56_disabled"){?>
                			   		<div class="table-cell Color0 <?=$classBorder;?> backColor1">PIF</div><!--cell-->
                			   <?php  } ?>
                		  </div><!--row-->
                         <?php  $pari=0; 
							for ($x = 0; $x < $contRiga; $x++) { 
							$linkScheda=$percorsoW."scheda.php?m=".$MacroCat."&amp;f=".$famiglia."&amp;c=".$categoria."&amp;l=3&amp;idp=".$ProdottoID[$x];
							if($pari==0){$classBackRiga="";}else {$classBackRiga="backColor6";}
						  ?>
                         <!-- ELENCO TABELLA-->
                          <div class="table-row <?=$classBackRiga;?>">
                			   <?php  for ($q = 0; $q <$ColonnaCount; $q++) { 
							   		if($valColonna[$q]==1){
										if($q==0){
											$classColor="Rosso";$btnTable="<a href='".$linkScheda."' class='Rosso'>";$btnTableChiudi="</a>";
										} else if($q==1){
											$classColor="";$btnTable="<a href='".$linkScheda."' class=''>";$btnTableChiudi="</a>";
										}else{
											$classColor="";$btnTable="";$btnTableChiudi="";
										}
                                        if($q==$classAlign){$classAlignCell="alignLeft";}else{$classAlignCell="";}
										if($q==$ColonnaCount-1){$classBorder="";}else{$classBorder="";}?>
										   <div class="table-cell <?=$classColor;?> <?=$classBorder;?> <?=$classAlignCell;?>">
												<?=$btnTable;?>
                                               <?php  $caratteristicaProdotto[$x][$q]=cntranslate($db_found,$caratteristicaProdotto[$x][$q]);
                                        if($q>0){
                                               $caratteristicaProdotto[$x][$q]=cntranslateArray($db_found,$caratteristicaProdotto[$x][$q],$baseeng,$basecn);
                                        }
                                               ?>
												<?=$caratteristicaProdotto[$x][$q];?>
												<?php  if($q==0){?>
													<?php 
														if($famiglia==5||$famiglia==9){
															$tipoRiempibox=0;
														} else {
															$tipoRiempibox=1;
														}
if($fotoProdotto[$x]){
															 $nImg++; $fotoQ="public/foto/thumb/".$fotoProdotto[$x]; $info = getimagesize($fotoQ); $widthN[$nImg]=$info[0]; $heightN[$nImg]=$info[1]; $riempibox[$nImg]=$tipoRiempibox;?>
													<span class="img"><img class="imgA" src="<?=$percorsoIMG;?>public/foto/thumb/<?=$fotoProdotto[$x]?>"></span>
<?php }?>
													<?php  if($_SESSION["logged"]=="x24fg56_disabled"&&$_SESSION["loggedSalva"]==1){ ?>
														<div class="IT-boxMenuFoto">
															<a id="btnUploadP<?=$x;?>" href="/public/foto/scriptx/pupload.php?id=<?=$ProdottoID[$x];?>&amp;l=4&amp;file=<?=$fotoProdottoPos[$x]?>" class="IT-btnIcona blu"><i class="fa fa-paperclip" aria-hidden="true"></i></a>
															<a href="/public/foto/scriptx/delete.php?id=<?=$ProdottoID[$x];?>&amp;l=4&amp;file=<?=$fotoProdottoPos[$x]?>&amp;<?=csrf_url_param()?>" class="IT-btnIcona rosso"><i class="fa fa-trash-o" aria-hidden="true"></i></a>
														</div>
													<?php  } ?>
												<?php  } ?>
												<?=$btnTableChiudi;?>
										   </div><!--cell-->
								   <?php  }//end if
								   } //Eend for ?>
                			   <?php  if($_SESSION["logged"]=="x24fg56_disabled"){
							  		if(in_array($ProdottoID[$x], $pifElenco)) {
										$classBackColorCell="backVerde";
										$classColorCell="bianco";
										$iconaCell="star";
										$urlPif="href='https://www.ideal-tek.com/inc/func/PIF-add.php?azione=delete&idDel=".$ProdottoID[$x]."'";
										
									}else {
										$classBackColorCell="";
										$classColorCell="";
										$iconaCell="star-o";
										$urlPif="";
									}
							  	?>
                			   		<div class="table-cell <?=$classBorder;?> nero01">
										<a id="pif<?=$x;?>" <?=$urlPif;?> <?=$classBackColorCell;?>  <?=$classColorCell;?> ><i class="fa fa-<?=$iconaCell;?>" aria-hidden="true"></i><span id="valPif<?=$x;?>" class="none"></span></a>
                			   		</div><!--cell-->
                			   <?php  } ?>
                		  </div><!--row-->
                		  <?php  $pari++;
						  if($pari>=2){
							 $pari=0; 
						  }
						 } ?>
                    </div><!--table-->
                    </div><!--table-container-->
                    <?php if($_SESSION["logged"]=="x24fg56_disabled"){?>
						<div class="menuPif">
							<a id="salvaPif" class="IT-btnSalva IT-btnSalva3 backVerde">Save PIF</a>
							<a id="allPif" class="IT-btnSalva IT-btnSalva3 backBlu">Select all PIF (single page)</a>
							<a id="noallPif" class="IT-btnSalva IT-btnSalva3 backBlu none">Deselect all PIF (single page)</a>
							<a id="allPifSuper" href="inc/func/PIF-add-massivo.php?<?=csrf_url_param()?>" class="IT-btnSalva IT-btnSalva3 backBlu2">ADD all pages to PIF</a>
							<a href="inc/func/PIF-add.php?azione=svuota&<?=csrf_url_param()?>" class="IT-btnSalva IT-btnSalva3 backRosso">Clear all PIF</a>
							<div class="clear"></div>
						</div>
                    <?php  }//end if ?>
                    <div class="pager">
                    	<?php  if($maxPage>1) { ?>
							<?php  if($maxPage>10 && $pageNum<($maxPage-8)) { ?><a href='<?=$self;?>&page=<?=$maxPage;?><?=$varbasepagine;?>' class='btnNP'><i class="fa fa-angle-double-right" aria-hidden="true"></i></a> <?php  }//end if?>
							<?php  if($pageNum<$maxPage) { ?><a href="<?=$self;?>&page=<?=$pageNext;?><?=$varbasepagine;?>" class="btnNP"><i class="fa fa-angle-right" aria-hidden="true"></i></a><?php  }//end if?>
							<div class="pagerBox"><div class="pagerContainer" <?=$stylePagerContainer;?>><?=$nav;?><div class="clear"></div></div></div>
							<?php  if($pageNum>1) { ?><a href="<?=$self;?>&page=<?=$pagePrev;?><?=$varbasepagine;?>" class="btnNP"><i class="fa fa-angle-left" aria-hidden="true"></i></a><?php  }//end if?>
							<?php  if($pageNum>=10 ) { ?><a href='<?=$self;?>&page=1<?=$varbasepagine;?>' class='btnNP'><i class="fa fa-angle-double-left" aria-hidden="true"></i></a> <?php  }//end if?>
							<div class="clear"></div>
						<?php  }//end if?>
                    </div>
                        
                        <?php if($testosotto){?>
                            <div class="corpoPagina corpoPagina6">
                            <?=$testosotto?>
                            </div>
                        <?php }?>
                        
				 </div><!--boxBase6-->
                </div>
                <div class="clear"></div>
            </div><!--row-->
        </div><!--section-->
        
        
   </div><!--container-->
   <?php  include "inc/footer.php"; ?>

	</div><!--main2-->
</div><!--main-->
<script>

var MacroCat='<?=$MacroCat;?>';
var famiglia=<?=json_encode($famiglia);?>;
var categoria = <?=json_encode($categoria);?>;
categoria = categoria.replace("&", "***");
var livello = '<?=$livello;?>';
var contRiga = '<?=$contRiga;?>';
var ProdottoID = <?= json_encode($ProdottoID); ?>;
var valPifUrl="",vPif="";
var categoriaCont='<?=$contC-1;?>';
var percorsoBase='<?=$percorsoBase;?>';
    var categoriaTitolo = <?= json_encode($categoriaTitolo); ?>;

for (i = 0; i <= categoriaCont; i++) { 
			$('#btnElencoPdfC'+i).click(function(){
				var id=this.id;
				id = id.replace("btnElencoPdfC", "");
				$('#modaleInserimentoPdf iframe').attr("src",percorsoBase+"inc/func/elenco_pdf_ch.php?&m="+MacroCat+"&f="+famiglia+"&c="+categoriaTitolo[id]+"&l="+livello);	
				$('#modaleInserimentoPdf').addClass("block").removeClass("none");	
				$('#modInsPdfCat').val(categoriaTitolo[id]);
			});
		}
	
$('#btnModTxtCat').click(function(){
	$('#modaleModificaTesto iframe').attr("src","inc/func/modifica_testo_categorie.php?&m="+MacroCat+"&f="+famiglia+"&c="+categoria+"&l="+livello);	
	$('#modaleModificaTesto').addClass("block").removeClass("none");

});
for (i = 0; i < contRiga; i++) { 
	$('#pif'+i).click(function(){	
	var id=this.id;
		id=id.replace("pif","");
		vPif=$('#valPif'+id).html();
	if(vPif==0 || vPif==""){
		$('#valPif'+id).html("1");
		$('#pif'+id+" i").removeClass("fa-star-o").addClass("fa-star");
	} else {
		$('#valPif'+id).html("0");
		$('#pif'+id+" i").removeClass("fa-star").addClass("fa-star-o");			  
	}
});	
}//end for
$('#allPif').click(function(){	
	for (i = 0; i < contRiga; i++) { 
			$('#valPif'+i).html("1");
			$('#pif'+i+" i").removeClass("fa-star-o").addClass("fa-star");
	}//end for
	$('#allPif').addClass("none").removeClass("block");
	$('#noallPif').addClass("block").removeClass("none");
});
$('#noallPif').click(function(){	
	for (i = 0; i < contRiga; i++) { 
		$('#valPif'+i).html("0");
		$('#pif'+i+" i").removeClass("fa-star").addClass("fa-star-o");
	}//end for
	$('#allPif').addClass("block").removeClass("none");
	$('#noallPif').addClass("none").removeClass("block");
});	
$('#salvaPif').click(function(){	
	for (i = 0; i < contRiga; i++) { 
		vPif=$('#valPif'+i).html();
		if (vPif==1) {
			var valPif=ProdottoID[i]
			valPifUrl =valPifUrl+valPif+"|";
		} else {
		}//end if
	}//end for
	//console.log(valPifUrl);
	 location.href="inc/func/PIF-add.php?pif="+valPifUrl+"&csrf_token=<?=urlencode(csrf_token())?>";
});
$('.popUp .box .close').click(function(){
	//location.href="prodotti.php?m="+MacroCat+"&f="+famiglia+"&c="+categoria+"&l="+livello;
	$(".popUp").each(function() {
			$(this).removeClass("block").addClass("none");
	});
});
     $('.moreBtn').click(function(){
                var isVisible = $(".moreTxt").is(':visible');
                $('.baseTxt').slideToggle();
				$('.moreTxt').slideToggle();
                if(isVisible===false){
                   $(this).html("<?=$eti[24]//Close?> <i class='fa fa-angle-up' aria-hidden='true'></i>");
                } else {
                    $(this).html("<?=$eti[4]//read more?> <i class='fa fa-angle-down' aria-hidden='true'></i>");
                }
                
			});
	
	 $('#GoTab').click(function(){
		 $('html, body').animate({scrollTop: $(".pager2").offset().top}, 1000);
	 });
	
</script>

<?php  //include "js/script_resize_immagini_array.php"; ?>
    <?php include_once "cookie/hubspot-tracking.php";?>   
</body>
</html>
<?php
if($db){mysqli_close($db);}

}
else {
print "Database Error";
if($db){mysqli_close($db);}
}
?>