Tutte le Soluzioni che la
Chimica Pulita e Responsabile
può offrirti !
AREA DOWNLOAD
PRODOTTI
setAttribute(PDO::ATTR_CASE,PDO::CASE_LOWER);
}
catch (PDOException $e) {
//echo 'Connection failed: ' . $e->getMessage();
exit();
}
$gruppo_prd=50;
//echo "->".$gruppo_prd;
if (strlen($gruppo_prd)>0)
{
//echo "1
"; $query="SELECT ar_cod_art,ar_fam_artic,ar_cod_ragrp,li_qualifica,ar_descri,lc_nomeprod,af_descri,ga_descri"; $query.=" FROM gxlistin,m0tabart,gxlicomm,m0artfam,m0artgrp"; $query.=" WHERE li_rel_art = ar_rel_opr"; $query.=" AND li_rel_art = lc_rel_artic AND lc_qualifica IS NULL"; $query.=" AND ar_fam_artic = af_cod_fam AND ar_cod_ragrp = af_codgrup"; $query.=" AND ar_cod_ragrp = ga_cod_grp"; $query.=" AND li_qualifica IS NULL"; $query.=" AND li_cod_divis = '00'"; $query.=" AND lc_cod_divis = '02'"; $query.=" AND li_dta_fvald IS NULL"; $query.=" AND li_stagione[1]='V'"; $query.=" AND li_n_list IN (11,10)"; $query.=" AND lc_nomeprod IS NOT NULL"; $query.=" GROUP BY ar_cod_art,ar_fam_artic,ar_cod_ragrp,li_qualifica,ar_descri,lc_nomeprod,af_descri,ga_descri"; $query.=" INTO TEMP tmp000prod"; $Q_result=$connect->query($query); $query="INSERT INTO tmp000prod"; $query.=" SELECT ar_cod_art,ax_fam_artic,ar_cod_ragrp,li_qualifica,ax_nomprodot,lc_nomeprod,af_descri,ga_descri"; $query.=" FROM gxlistin,m0extart,m0tabart,gxlicomm,m0artfam,m0artgrp"; $query.=" WHERE li_rel_art = ar_rel_opr"; $query.=" AND li_rel_art = ax_rel_opr AND li_qualifica = ax_qualifica"; $query.=" AND li_rel_art = lc_rel_artic AND li_qualifica = lc_qualifica"; $query.=" AND ax_fam_artic = af_cod_fam AND ax_cod_ragrp = af_codgrup"; $query.=" AND ax_cod_ragrp = ga_cod_grp"; $query.=" AND li_cod_divis = '00'"; $query.=" AND lc_cod_divis = '02'"; $query.=" AND li_dta_fvald IS NULL"; $query.=" AND lc_nomeprod IS NOT NULL"; $query.=" AND li_stagione[1]='V'"; $query.=" AND ax_cod_ragrp='$gruppo_prd'"; $query.=" AND li_n_list IN (11,10)"; $query.=" GROUP BY ar_cod_art,ax_fam_artic,ar_cod_ragrp,li_qualifica,ax_nomprodot,lc_nomeprod,af_descri,ga_descri"; $Q_result=$connect->query($query); //$Q_result=ifx_query($query,$connect); $query="SELECT *"; $query.=" FROM tmp000prod"; $query.=" ORDER BY ar_cod_ragrp,ar_fam_artic,ar_cod_art"; $Q_result=$connect->query($query); $grupfam_prec=null; echo "";
$c=0;
foreach ($Q_result as $row)
{
$grupfam=$row['ar_cod_ragrp'].$row['ar_fam_artic']
if ($grupfam_prec<>$grupfam)
{
if ($fam_prec<>null)
echo "
";
}
else
{
echo "![\"\"](\"immagini/imballi.jpg\")
";
}
//ifx_close($connect);
?>
"; $query="SELECT ar_cod_art,ar_fam_artic,ar_cod_ragrp,li_qualifica,ar_descri,lc_nomeprod,af_descri,ga_descri"; $query.=" FROM gxlistin,m0tabart,gxlicomm,m0artfam,m0artgrp"; $query.=" WHERE li_rel_art = ar_rel_opr"; $query.=" AND li_rel_art = lc_rel_artic AND lc_qualifica IS NULL"; $query.=" AND ar_fam_artic = af_cod_fam AND ar_cod_ragrp = af_codgrup"; $query.=" AND ar_cod_ragrp = ga_cod_grp"; $query.=" AND li_qualifica IS NULL"; $query.=" AND li_cod_divis = '00'"; $query.=" AND lc_cod_divis = '02'"; $query.=" AND li_dta_fvald IS NULL"; $query.=" AND li_stagione[1]='V'"; $query.=" AND li_n_list IN (11,10)"; $query.=" AND lc_nomeprod IS NOT NULL"; $query.=" GROUP BY ar_cod_art,ar_fam_artic,ar_cod_ragrp,li_qualifica,ar_descri,lc_nomeprod,af_descri,ga_descri"; $query.=" INTO TEMP tmp000prod"; $Q_result=$connect->query($query); $query="INSERT INTO tmp000prod"; $query.=" SELECT ar_cod_art,ax_fam_artic,ar_cod_ragrp,li_qualifica,ax_nomprodot,lc_nomeprod,af_descri,ga_descri"; $query.=" FROM gxlistin,m0extart,m0tabart,gxlicomm,m0artfam,m0artgrp"; $query.=" WHERE li_rel_art = ar_rel_opr"; $query.=" AND li_rel_art = ax_rel_opr AND li_qualifica = ax_qualifica"; $query.=" AND li_rel_art = lc_rel_artic AND li_qualifica = lc_qualifica"; $query.=" AND ax_fam_artic = af_cod_fam AND ax_cod_ragrp = af_codgrup"; $query.=" AND ax_cod_ragrp = ga_cod_grp"; $query.=" AND li_cod_divis = '00'"; $query.=" AND lc_cod_divis = '02'"; $query.=" AND li_dta_fvald IS NULL"; $query.=" AND lc_nomeprod IS NOT NULL"; $query.=" AND li_stagione[1]='V'"; $query.=" AND ax_cod_ragrp='$gruppo_prd'"; $query.=" AND li_n_list IN (11,10)"; $query.=" GROUP BY ar_cod_art,ax_fam_artic,ar_cod_ragrp,li_qualifica,ax_nomprodot,lc_nomeprod,af_descri,ga_descri"; $Q_result=$connect->query($query); //$Q_result=ifx_query($query,$connect); $query="SELECT *"; $query.=" FROM tmp000prod"; $query.=" ORDER BY ar_cod_ragrp,ar_fam_artic,ar_cod_art"; $Q_result=$connect->query($query); $grupfam_prec=null; echo "
| ".rtrim($row['ga_descri'])." - ".rtrim($row['af_descri'])." | "; echo "|||||
| ".substr($row["ar_cod_art"],0,3).substr($row["ar_cod_art"],5,3)." | "; else echo "".substr($row["ar_cod_art"],0,4).substr($row["ar_cod_art"],5,3)." | "; echo "".rtrim($row["li_qualifica"])." | "; echo ""; //echo " | ".rtrim($row["lc_nomeprod"])." | "; echo "".rtrim($row["ar_descri"])." | "; echo "
";
}
//ifx_close($connect);
?>