";
//echo "$ART_ARTICLE_NR ";
//echo "$ART_ARTICLE_NR_t ";
//echo "$ARL_KIND2 ";
$db = mysql_connect('localhost', 'root', 'MMeolCOM2002');
mysql_select_db('ppa',$db);
/*
$where = "where (";
if (!empty($ART_ARTICLE_NR)){
$where .= " Ref_Fournisseur like '$ART_ARTICLE_NR' or Code_EAN like '$ART_ARTICLE_NR'";
}
if (!empty($ARL_SEARCH_NUMBER)){
$where .= " or Ref_Fournisseur like '$ARL_SEARCH_NUMBER' or Code_EAN like '$ARL_SEARCH_NUMBER'";
}
if (!empty($ART_ARTICLE_NR_t)){
$where .= " or Ref_Fournisseur like '$ART_ARTICLE_NR_t' or Code_EAN like '$ART_ARTICLE_NR_t'";
}
if (!empty($ARL_KIND2)){
//$where .= " or Ref_Fournisseur like '$ARL_KIND2' or Code_EAN like '$ARL_KIND2'";
}
if (!empty($ART_ARTICLE_NR_t)){
$where .= " or Ref_Fournisseur like REPLACE('$ART_ARTICLE_NR_t', '.', '')";
}
$sql = "SELECT FORMAT(REPLACE(Prix_euro_ttc, ',', '.'),2),FORMAT(REPLACE(Prix_vente_ttc, ',', '.'),2), FORMAT(REPLACE((Montant_consigne_ht+ (Montant_consigne_ht/100)*19.6), ',', '.'),2) FROM PRIX ".$where.") and code_marque=".$SUP_ID."";
echo "$sql ";
*/
$where = "where (";
if (!empty($ART_ARTICLE_NR)){
$where .= " Ref_Fournisseur like '$ART_ARTICLE_NR'";
}
if (!empty($ART_ARTICLE_NR_t)){
$where .= " or Ref_Fournisseur like '$ART_ARTICLE_NR_t'";
}
if (!empty($ARL_KIND2) and $SUP_ID==3){
$where .= " or Ref_Fournisseur like '$ARL_KIND2'";
}
if (!empty($ARL_KIND_1_DISPLAY)){
$where .= " or Ref_Fournisseur like '$ARL_KIND_1_DISPLAY'";
}
if (!empty($ART_ARTICLE_NR_t)){
$where .= " or Ref_Fournisseur like REPLACE('$ART_ARTICLE_NR_t', '.', '')";
}
$sql = "SELECT FORMAT(REPLACE(Prix_euro_ttc, ',', '.'),2),FORMAT(REPLACE(Prix_vente_ttc, ',', '.'),2), FORMAT(REPLACE((Montant_consigne_ht+ (Montant_consigne_ht/100)*19.6), ',', '.'),2) FROM PRIX ".$where.") and code_marque=".$SUP_ID."";
//echo "$sql ";
//$sql = "SELECT FORMAT(REPLACE(Prix_euro_ttc, ',', '.'),2),FORMAT(REPLACE(Prix_vente_ttc, ',', '.'),2), FORMAT(REPLACE((Montant_consigne_ht+ (Montant_consigne_ht/100)*19.6), ',', '.'),2) FROM PRIX where Code_EAN like '$ARL_SEARCH_NUMBER' and code_marque=".$SUP_ID."";
//echo "$sql ";
$result = @mysql_query($sql);
$row=MYSQL_FETCH_ROW($result);
$prix_1 = floatval($row[0]);
$prix_2 = floatval($row[1]);
$prix_3 = floatval($row[2]);
$prix_1 = number_format($prix_1, 2, ',', ' ');
$prix_2 = number_format($prix_2, 2, ',', ' ');
$prix_3 = number_format($prix_3, 2, ',', ' ');
$prix_total = number_format($row[1]+$row[2], 2, ',', ' ');
$ssqsqssZ = "SELECT gra_sup_id, gra_id, gra_doc_type, gra_lng_id, gra_type, gra_norm, gra_supplier_nr, gra_tab_nr, gra_grd_id,
nvl(gra_tex.tex_text, gra_tex_uni.tex_text) gra_designation,
lga_sort, 2 sort
FROM tof_graphics g
JOIN tof_link_gra_art ON gra_id = lga_gra_id and lga_art_id = $id_art and lga_ctm subrange (90 CAST INTEGER) =1
left outer join tof_designations gra_des on gra_des_id nljoin gra_des.des_id and gra_des.des_lng_id = 6
left outer join tof_des_texts gra_tex on gra_des.des_tex_id nljoin gra_tex.tex_id
left outer join tof_designations gra_des_uni on gra_des_id nljoin gra_des_uni.des_id and gra_des_uni.des_lng_id = 255
left outer join tof_des_texts gra_tex_uni on gra_des_uni.des_tex_id nljoin gra_tex_uni.tex_id
where ( gra_lng_id = 6 or
( gra_lng_id = 255 and not exists (
select gra_id from tof_graphics g1 where g.gra_id = g1.gra_id and g1.gra_lng_id = 6) ) ) and
not exists (select 1 from tof_ali_coordinates ali where lga_gra_id nljoin ali.aco_gra_id and
lga_art_id nljoin ali.aco_ali_art_id and
(4 nljoin ali.aco_gra_lng_id or
(ali.aco_gra_lng_id = 255 and not exists (select 1
from tof_ali_coordinates ali_co
where ali_co.aco_gra_id = ali.aco_gra_id and
ali_co.aco_ali_art_id = ali.aco_ali_art_id and
ali_co.aco_gra_lng_id = 6))))";
$exec_Z = @odbc_exec($con,$ssqsqssZ);
$row_Z = @odbc_fetch_array($exec_Z);
$gra_grd_id = $row_Z['GRA_GRD_ID'];
$gra_tab_nr = $row_Z['GRA_TAB_NR'];
$filename = "pieces-auto_".$gra_tab_nr."/".$gra_grd_id.".jpg";
//echo $filename;
if (file_exists($filename)) {
// echo "Le fichier $filename existe.";
} else {
$filename = "logos-marques/".$SUP_ID.".jpg";
}
?>
<?php echo"$value_m"; ?><?php echo"$SUP_SUP_BRAND"; ?>
<?=$ART_ARTICLE_NR?>
pour<?Php echo"$vehicle_des";?>avec PlusPiecesAuto.com : vente en ligne de pièces auto d'origine à prix bas
pour d'origine pas cher avec pluspiecesauto.com" />
