//funcions de conexió a la BD
include("gestor/config.php");
include("gestor/funciones.php");
include("gestor/includes/cont.php");
//INICIEM SESSIÓ
//session_start();
include("gestor/includes/fecha_servidor.php");
include("includes/dck_2016_funciones_nc.php");
//conexió BD
$cnx = conectar();
mysql_set_charset('utf8');
$id_menu=53;
$id=addslashes($_REQUEST['id']);
$descargat1="no";
$height_banner="0.35";
include("includes/dck_2016_params.php");
$res = mysql_query("SELECT ingcat,inges,ingen,valcat,vales,valen,valbcat,valbes,valben,propcat,propes,propen,alecat,alees,aleen,envcat,enves,enven FROM apartats_valors WHERE id_apartat='$id'") or die (mysql_error());
list($ingcat,$inges,$ingen,$valcat,$vales,$valen,$valbcat,$valbes,$valben,$propcat,$propes,$propen,$alecat,$alees,$aleen,$envcat,$enves,$enven) = mysql_fetch_array($res);
$ingcat=json_decode($ingcat, true);
$inges=json_decode($inges, true);
$ingen=json_decode($ingen, true);
if($i=="es"){$ingcat=$inges;}
if($i=="en"){$ingcat=$ingen;}
$valcat=json_decode($valcat, true);
$vales=json_decode($vales, true);
$valen=json_decode($valen, true);
if($i=="es"){$valcat=$vales;}
if($i=="en"){$valcat=$valen;}
$valbcat=json_decode($valbcat, true);
$valbes=json_decode($valbes, true);
$valben=json_decode($valben, true);
/*if($i=="es"){$valbcat=$valbes;}
if($i=="en"){$valbcat=$valben;}*/
$propcat=json_decode($propcat, true);
$propes=json_decode($propes, true);
$propen=json_decode($propen, true);
if($i=="es"){$propcat=$propes;}
if($i=="en"){$propcat=$propen;}
$alecat=json_decode($alecat, true);
$alees=json_decode($alees, true);
$aleen=json_decode($aleen, true);
if($i=="es"){$alecat=$alees;}
if($i=="en"){$alecat=$aleen;}
$envcat=json_decode($envcat, true);
$enves=json_decode($enves, true);
$enven=json_decode($enven, true);
if($i=="es"){$envcat=$enves;}
if($i=="en"){$envcat=$enven;}
$res3 = mysql_query("SELECT id FROM apartats_imatges WHERE id_apartat='$id' AND visible=1 ORDER BY posicio ASC") or die (mysql_error());
list($id_imatge) = mysql_fetch_array($res3);
?>
echo $ap_titol[$id]; ?> | echo $p_titol[2]; ?> echo $p_titol[1]; ?> | echo $p_titol[83]; ?>
include("includes/dck_2016_headers_industrial_nc.php"); ?>
include("includes/analytics.php"); ?>
include("includes/dck_2016_menu_industrial_nc.php"); ?>
$res3 = mysql_query("SELECT id FROM apartats_imatges WHERE id_apartat='$id' AND visible=1 ORDER BY posicio ASC") or die (mysql_error());
list($id_imatge) = mysql_fetch_array($res3);
?>
if($ingcat[1]!=""){
?>
echo $p_titol[84]; ?>
for ($ixx = 2; $ixx <= 10; $ixx++) {
if($ingcat[$ixx]!=""){
?>
}
}
?>
}
?>
if($valcat[1]!=""){
?>
echo $p_titol[85]; ?>
for ($ixx = 2; $ixx <= 10; $ixx++) {
if($valcat[$ixx]!=""){
?>
if($ixx==3 || $ixx==5){ ?>
echo $valcat[$ixx]; ?>
}else{ ?>
echo $valcat[$ixx]; ?>
} ?>
if($ixx==3 || $ixx==5){ ?>
echo $valbcat[$ixx]; ?>
}else{ ?>
echo $valbcat[$ixx]; ?>
} ?>
}
}
?>
}
?>
if($propcat[1]!=""){
?>
echo $p_titol[86]; ?>S
for ($ixx = 2; $ixx <= 10; $ixx++) {
if($propcat[$ixx]!=""){
?>
}
}
?>
}
?>
if($alecat[1]!=""){
?>
echo $p_titol[87]; ?>
for ($ixx = 2; $ixx <= 10; $ixx++) {
if($alecat[$ixx]!=""){
?>
}
}
?>
}
?>
if($envcat[1]!=""){
?>
echo $p_titol[88]; ?>
for ($ixx = 2; $ixx <= 10; $ixx++) {
if($envcat[$ixx]!=""){
?>
}
}
?>
}
?>
$res3 = mysql_query("SELECT id FROM apartats_pdf WHERE id_apartat='$id' AND visible=1 ORDER BY posicio ASC") or die (mysql_error());
if (mysql_num_rows($res3) > 0) {
while(list($id_imatge) = mysql_fetch_array($res3)){
?>
}
}
?>
if($ap_apte_bio[$id]==1){ ?>

Bio
} ?>
if($ap_gluten_free[$id]==1){ ?>
![<? echo $p_titol[92]; ?> <? echo $p_titol[92]; ?>](<? echo $url_web_images; ?>images/ic_gluten.jpg)
echo $p_titol[92]; ?>
} ?>
if($ap_lactosa_free[$id]==1){ ?>
![<? echo $p_titol[93]; ?> <? echo $p_titol[93]; ?>](<? echo $url_web_images; ?>images/ic_lactose.jpg)
echo $p_titol[93]; ?>
} ?>
if($ap_egg_free[$id]==1){ ?>
![<? echo $p_titol[94]; ?> <? echo $p_titol[94]; ?>](<? echo $url_web_images; ?>images/ic_egg.jpg)
echo $p_titol[94]; ?>
} ?>
if($ap_apte_vegans[$id]==1){ ?>
![<? echo $p_titol[95]; ?> <? echo $p_titol[95]; ?>](<? echo $url_web_images; ?>images/ic_vegans.jpg)
echo $p_titol[95]; ?>
} ?>

if($ap_gluten_free_cert[$id]==1){ ?>

} ?>
echo $p_titol[80]; ?>
echo $p_titol[81]; ?>
$num=0;
$res2 = mysql_query("SELECT id FROM apartats WHERE id_menu='$id_menu' AND visible=1 AND referencia!='' AND id_categoria='".$ap_id_categoria[$id]."' AND id!='$id' ORDER BY RAND()") or die (mysql_error());
while(list($id2) = mysql_fetch_array($res2)){
$res3 = mysql_query("SELECT id FROM apartats_imatges WHERE id_apartat='$id2' AND visible=1 ORDER BY posicio ASC") or die (mysql_error());
while(list($id_imatge) = mysql_fetch_array($res3)){
$text2=$ap_text[$id2];
$text2=strip_tags($text2);
$text2=html_entity_decode($text2);
$num++;
?>
if($ap_new[$id2]==1){ ?>

} ?>
echo $ap_titol[$ap_id_categoria[$ap_id_categoria[$id]]]; ?>
if($num==5){break;}
}
if($num==5){break;}
}
?>
if($num<5){
$res_grup1 = mysql_query("SELECT id FROM apartats WHERE id_menu='$id_menu' AND visible=1 AND id_categoria='".$ap_id_categoria[$ap_id_categoria[$id]]."' ORDER BY RAND()") or die (mysql_error());
while(list($id_grup1) = mysql_fetch_array($res_grup1)){
$res_grup2 = mysql_query("SELECT id FROM apartats WHERE id_menu='$id_menu' AND visible=1 AND referencia!='' AND id_categoria='$id_grup1' AND id_categoria!='".$ap_id_categoria[$id]."' ORDER BY RAND()") or die (mysql_error());
while(list($id2) = mysql_fetch_array($res_grup2)){
$res3 = mysql_query("SELECT id FROM apartats_imatges WHERE id_apartat='$id2' AND visible=1 ORDER BY posicio ASC") or die (mysql_error());
while(list($id_imatge) = mysql_fetch_array($res3)){
$text2=$ap_text[$id2];
$text2=strip_tags($text2);
$text2=html_entity_decode($text2);
$num++;
?>
if($ap_new[$id2]==1){ ?>

} ?>
echo $ap_titol[$ap_id_categoria[$ap_id_categoria[$id2]]]; ?>
if($num==5){break;}
}
if($num==5){break;}
}
if($num==5){break;}
}
}
?>
if($num<5){
$res_grup2 = mysql_query("SELECT id FROM apartats WHERE id_menu='$id_menu' AND visible=1 AND referencia!='' AND id!='$id' AND id_categoria!='".$ap_id_categoria[$ap_id_categoria[$id]]."' AND id_categoria!='".$ap_id_categoria[$id]."' ORDER BY RAND()") or die (mysql_error());
while(list($id2) = mysql_fetch_array($res_grup2)){
$res3 = mysql_query("SELECT id FROM apartats_imatges WHERE id_apartat='$id2' AND visible=1 ORDER BY posicio ASC") or die (mysql_error());
while(list($id_imatge) = mysql_fetch_array($res3)){
$text2=$ap_text[$id2];
$text2=strip_tags($text2);
$text2=html_entity_decode($text2);
$num++;
?>
if($ap_new[$id2]==1){ ?>

} ?>
echo $ap_titol[$ap_id_categoria[$ap_id_categoria[$id2]]]; ?>
if($num==5){break;}
}
if($num==5){break;}
}
}
?>
include("includes/dck_2016_peu_industrial_nc.php"); ?>
//Tanquem
mysql_close($cnx);
?>