$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 mouvements de stock // -> 0000014: export douane : ajout de la colonne info, ne pas afficher les lignes quand qtyadd==0 $sql = "SELECT s.*, p.products_price, p.products_tax_class_id, p.products_weight, p.manufacturers_id FROM ( " . TABLE_AUDITED_STOCK . " s, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc) WHERE s.qtyadd != 0 AND s.products_id = p.products_id AND p.products_id = pd.products_id AND p.products_id = pc.products_id AND pd.language_id = FLOOR($languages_id)"; // <- 0000014: export douane : ajout de la colonne info, ne pas afficher les lignes quand qtyadd==0 if ( $manufacturer != "ALL" ) $sql .= " AND p.manufacturers_id = " . $manufacturer; if ( $category != "ALL" ) $sql .= " AND pc.categories_id = " . $category; if ( $year != "ALL" ) $sql .= " AND YEAR(s.date) = " . $year; if ( $month != "ALL" ) $sql .= " AND MONTH(s.date) = " . $month; $sql .= " ORDER BY s.date"; $stock_query = tep_db_query($sql); $product_num = 0; while($stock = tep_db_fetch_array($stock_query)) { if (intval($stock['manufacturers_id']) > 0) { $manufacturers_query = tep_db_query("SELECT manufacturers_name, manufacturers_country FROM " . TABLE_MANUFACTURERS . " WHERE manufacturers_id = " . $stock['manufacturers_id']); $manufacturers_result = tep_db_fetch_array($manufacturers_query); $stock['manufacturers_name'] = $manufacturers_result['manufacturers_name']; $stock['manufacturers_country'] = ucfirst($manufacturers_result['manufacturers_country']); } // -> QPBPP135 $price_breaks_array = array(); $price_breaks_query = tep_db_query("select products_price, products_qty from " . TABLE_PRODUCTS_PRICE_BREAK . " where products_id = '" . $stock['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 = '" . $stock['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 = " . $stock['products_id'] . " AND status = '1' limit 1"); $special_result = tep_db_fetch_array($special_query); if ($special_result['specials_new_products_price'] > 0) $special['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($stock['products_price'], tep_get_tax_rate($stock['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; } // 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'); ?>