<?php
/*
$Id: export.php, version 1.0 Mercredi 12 Février 2008 Vaisonet Exp $

Contribution Export universel

http://www.vaisonet.com
Copyright © 2008 Vaisonet

Released under the GNU General Public License
*/
  define(MAX_PRICE_BREAKS,4);
  define('SEP','|');	        // separateur

  $comp = array("Catalogue produit");
  
  $header = 'Content-Disposition: attachment; filename="catalogue.csv"';

  $head = '"Création"' . SEP . '"Id"' . SEP . '"Catégorie"'.SEP.'"SousCatégorie"'.SEP.'"Référence"'.SEP.'"Produit"'.SEP.'"Fournisseur"';
  $head .= SEP.'"Dispo"'.SEP.'"Poids"'.SEP.'"Stock"'.SEP.'"Prix Vente HT"'.SEP.'"Prix Vente TTC"'.SEP.'"Prix Achat HT"';
  for($i=0;$i<MAX_PRICE_BREAKS;$i++) { $ip1 = $i+1; $head .= SEP . '"Px P#' . $ip1 . '"' . SEP . '"Qt P#' . $ip1 . '"'; }

  if ( isset($extra_fields_array) )
  {
    foreach ( $extra_fields_array as $key => $value )
    { $head .= SEP . '"' . $key . '"'; }
  }
  $head .= SEP . '"URL image"';
  $head .= SEP . '"Description"';
  $head .= "\n";

  if ( $cat_info[$products['categories_id']]['parent'] == "0" )
  {
    $category = $cat_info[$products['categories_id']]['name'];
    $subcategory = "";
  }
  else
  {
    $category    = $cat_info[$cat_info[$products['categories_id']]['parent']]['name'];
    $subcategory = $cat_info[$products['categories_id']]['name'];
  }
  $output .= '"' . $products['products_date_added'] . '"';
  $output .= SEP.'"' . $products['products_id'] . '"';
  $output .= SEP.'"' . $category . '"';
  $output .= SEP.'"' . $subcategory . '"';
  $output .= SEP.'"' . $products['products_model'] . '"'; 
  $output .= SEP.'"' . nettoyage_html($products['products_name'], 80) . '"';
  $output .= SEP.'"' . $products['manufacturers_name'] . '"'; 
// -> VDOFS : gestion des articles épuisés
// -> 0000018: export catalogue : doublons et produits finis
  if ( $products['products_out_of_stock'] != 1 ) 
  { 
    if ( $products['products_status'] == 0 ) { $output .= SEP . '"fini"'; }
    else                                     { $output .= SEP . '"dispo"'; }
  }
  else
  { $output .= SEP . '"épuisé"'; }
// <- 0000018
// <- VDOFS
  $output .= SEP . $products['products_weight']; 
  $output .= SEP . $products['products_quantity']; 
  $output .= SEP . $regular_price;
  $output .= SEP . $regular_price * 1.196;
  $output .= SEP . $products['products_cost']; 
  $n=sizeof($price_breaks_array);
  for($i=0;$i<MAX_PRICE_BREAKS;$i++)
  {
    if ( $n > $i ) { $output .= SEP . $price_breaks_array[$i]['products_price'] . SEP . $price_breaks_array[$i]['products_qty']; }
    else           { $output .= SEP . SEP; }
  }
  if ( isset($extra_fields_array) )
  {
    foreach ( $extra_fields_array as $key => $value )
    {
      $output .= SEP . '"' . $products_extra_fields_array[$value['products_extra_fields_id']]['products_extra_fields_value'] . '"';
    }
  }
// -> LP-8
  $output .= SEP . '"' . $products['products_image_url'] . '"';
// <- LP-8
  $output .= SEP.'"' . nettoyage_html($products['products_description']) . '"';
  $output .= "\n";
      
  $foot = '';
?>