LP-8 $imagesize = tep_db_prepare_input($HTTP_GET_VARS['imagesize']); // <- LP-8 $category = tep_db_prepare_input($HTTP_GET_VARS['cat']); $month = tep_db_prepare_input($HTTP_GET_VARS['month']); $year = tep_db_prepare_input($HTTP_GET_VARS['year']); $libre = tep_db_prepare_input($HTTP_GET_VARS['libre']); if ($HTTP_GET_VARS['rep'] == "1") $rep = 'export/secure/'; else $rep = 'export/'; //On vérifie le code avant de lancer les requêtes // -> OSC-95 - Amélioration vue INVENTAIRE if ( $format == "inventaire.php" ) $verif = false; // <- OSC-95 - Amélioration vue INVENTAIRE if( ($verif == true and $p==$pass) OR $verif == false) { $included_categories_query = tep_db_query("SELECT c.categories_id, c.parent_id, cd.categories_name FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = cd.categories_id AND cd.language_id = FLOOR($languages_id)"); $inc_cat = array(); // Identification du nom de la catégorie, et l'id de la catégorie parent while ($included_categories = tep_db_fetch_array($included_categories_query)) { $inc_cat[] = array ( 'id' => $included_categories['categories_id'], 'parent' => $included_categories['parent_id'], 'name' => $included_categories['categories_name']); } $cat_info = array(); for ($i=0; $i $inc_cat[$i]['parent'], 'name' => $inc_cat[$i]['name'], 'path' => $inc_cat[$i]['id'], 'link' => '' ); for ($i=0; $i' . $cat_info[$link_array[$j]]['name'] . ' » '; } } // -> PEF : Product Extra fields $extra_fields_array = array(); $extra_fields_query = tep_db_query("select * from " . TABLE_PRODUCTS_EXTRA_FIELDS); while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { $extra_fields_array[$extra_fields['products_extra_fields_name']] = $extra_fields; } // <- PEF // Requête identifiant les produits disponibles dans le catalogue // -> OSC-26: export du catalogue pour les partenaires (ajout de p.products_model) $sql = "SELECT p.*, p.products_image, p.products_model, pd.products_name, pd.products_description, pc.categories_id, pr.date_added as review_date, pr.customers_name, pr.reviews_rating, pt.reviews_text, pt.languages_id as lngr FROM (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc) LEFT JOIN reviews as pr ON (p.products_id = pr.products_id) LEFT JOIN reviews_description as pt ON (pr.reviews_id = pt.reviews_id) WHERE p.products_id = pd.products_id AND p.products_id = pc.products_id AND pd.language_id = FLOOR($languages_id)"; // <- OSC-26 if ( $manufacturer != "ALL" ) $sql .= " AND p.manufacturers_id = " . $manufacturer; if ( $category != "ALL" ) $sql .= " AND pc.categories_id = " . $category; if ( $year != "ALL" ) $sql .= " AND YEAR(pr.date_added) = " . $year; if ( $month != "ALL" ) $sql .= " AND MONTH(pr.date_added) = " . $month; $sql .= " ORDER BY pc.categories_id, pd.products_name"; $products_query = tep_db_query($sql); $product_num = 0; $products_processed=array(); // -> 0000018: export catalogue : doublons et produits finis while($products = tep_db_fetch_array($products_query)) { if ( $products_processed[$products['products_id']] == 1 ) { continue; } $products_processed[$products['products_id']] = 1; // <- 0000018 if (intval($products['manufacturers_id']) > 0) { $manufacturers_query = tep_db_query("SELECT manufacturers_name FROM " . TABLE_MANUFACTURERS . " WHERE manufacturers_id = " . $products['manufacturers_id']); $manufacturers_result = tep_db_fetch_array($manufacturers_query); $products['manufacturers_name'] = $manufacturers_result['manufacturers_name']; } // -> QPBPP135 $price_breaks_array = array(); $price_breaks_query = tep_db_query("select products_price, products_qty from " . TABLE_PRODUCTS_PRICE_BREAK . " where products_id = '" . $products['products_id'] . "' order by products_qty"); while ($price_break = tep_db_fetch_array($price_breaks_query)) { $price_breaks_array[] = $price_break; } // <- QPBPP135 // -> PEF : Product Extra fields $products_extra_fields_array = array(); $products_extra_fields_query = tep_db_query("select * FROM " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " where products_id = '" . $products['products_id'] . "'"); while ($products_extra_fields = tep_db_fetch_array($products_extra_fields_query)) { $products_extra_fields_array[$products_extra_fields['products_extra_fields_id']] = $products_extra_fields; } // <- PEF $special_query = tep_db_query("SELECT specials_new_products_price , expires_date , specials_date_added FROM " . TABLE_SPECIALS . " WHERE products_id = " . $products['products_id'] . " AND status = '1' limit 1"); $special_result = tep_db_fetch_array($special_query); if ($special_result['specials_new_products_price'] > 0) $products['products_price'] = $special_result['specials_new_products_price']; $product_num++; //calcul des prix // la varaible $reduc permet de tester s'il y a une promo $price = tep_add_tax($products['products_price'], tep_get_tax_rate($products['products_tax_class_id'])); if($special_result['specials_new_products_price'] == '' ) { $discount_price = '' ; $regular_price = $price; $reduc = false; } else { $discount_price = $special_result['specials_new_products_price']; $regular_price = $price; $reduc = true; } // Test barcod mod if (!$ean) $products['products_barcode'] == ""; // Test ecotax if ($ecotax) $ecotax_montant = tep_get_ecotax_price_value($products['ecotax_rates_id']); else $ecotax_montant = 0; // -> LP-8 $products['products_image_url'] = HTTP_SERVER . DIR_WS_HTTP_CATALOG . DIR_WS_IMAGES . $products['products_image']; if ( $imagesize != "normal" ) { // ../images/image/flt/762.jpg -> ../images-500x500--3000x3000/image/flt/762.jpg $products['products_image_url'] = str_replace("/images/", "/${imagesize}/", $products['products_image_url']); } // <- LP-8 // On appelle le "plugin" définissant le format du fichier include(DIR_WS_MODULES . 'ExU/' . $format); } $content = $head . $output . $foot; //Soit on met en cache, soit on affiche le résulat if ($cache != "true") { Header( $header ); if ($header2) Header( $header2 ); echo $content; } else { $fp= fopen(DIR_FS_CATALOG . $rep . $fichier,"w"); fputs($fp,"$content"); fclose($fp); } } require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>