Import : pas de "parent category"

<?php /** * @package HikaShop for Joomla! * @version 1.6.0 * @author hikashop.com * @copyright (C) 2010-2012 HIKARI SOFTWARE. All rights reserved. * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html */ defined('_JEXEC') or die('Restricted access'); ?> <?php ob_end_clean(); if(ob_get_level()>2) ob_end_clean(); ob_start(); $eol= "\r\n"; $characteristic = hikashop_get('class.characteristic'); $characteristic->loadConversionTables($this); $config =& hikashop_config(); $separator = $config->get('csv_separator',";"); $db =& JFactory::getDBO(); $columnsTable = $db->getTableFields(hikashop_table('product')); $columnsArray = reset($columnsTable); $columnsArray['categories_ordering']='categories_ordering'; $columns = $products_columns = array_keys($columnsArray); $product_table_count = count($columns); $columns['parent_category']='parent_category'; $columns['categories_image']='categories_image'; $columns['categories']='categories'; $columns['price_value']='price_value'; $columns['price_currency_id']='price_currency_id'; $columns['price_min_quantity']='price_min_quantity'; $columns['price_access']='price_access'; $columns['files']='files'; $columns['images']='images'; $columns['related']='related'; $columns['options']='options'; $characteristicsColumns = array(); if(!empty($this->characteristics)){ foreach($this->characteristics as $characteristic){ if(empty($characteristic->characteristic_parent_id)){ $columns[$characteristic->characteristic_value]=$characteristic->characteristic_value; $characteristicsColumns[]=$characteristic->characteristic_value; } } } $after_category_count = count($columns)-($product_table_count+3); $output=''; foreach($columns as $column){ if(!empty($column)){ $output.= '"'.str_replace('"','\\'.'"',$column).'"'; } $output.= $separator; } echo rtrim($output,$separator).$eol; $output=''; if(!empty($this->categories)){ foreach($this->categories as $category){ echo '"'.str_repeat('"'.$separator.'"',$product_table_count-1).'"'.$separator; if(!empty($category->category_parent_id) && isset($this->categories[$category->category_parent_id])){ echo '"'.str_replace('"','""',$this->categories[$category->category_parent_id]->category_name).'"'.$separator; }else{ echo '""'.$separator; } if(!empty($category->file_path)){ echo '"'.str_replace('"','""',$category->file_path).'"'.$separator; }else{ echo '""'.$separator; } echo '"'.str_replace('"','""',$category->category_name).'"'.$separator.'"'.str_repeat('"'.$separator.'"',$after_category_count-1).'"'.$eol; } } if(!empty($this->products)){ foreach($this->products as $k => $product){ if($product->product_type=="variant"){ $this->products[$k]->product_parent_id = str_replace('"','""',$this->products[$product->product_parent_id]->product_code); } } foreach($this->products as $product){ foreach($products_columns as $column){ echo '"'.str_replace('"','""',$product->$column).'"'.$separator; } $categories = array(); if(!empty($product->categories)){ foreach($product->categories as $category){ if(!empty($this->categories[$category])){ $categories[]=str_replace(array('"',',',';'),array('""','\\,','\\;'),$this->categories[$category]->category_name); } } } echo '""'.$separator.'""'.$separator; if(!empty($categories)){ echo '"'.implode($separator,$categories).'"'.$separator; }else{ echo '""'.$separator; } $values = array(); $codes = array(); $qtys = array(); $accesses = array(); if(!empty($product->prices)){ foreach($product->prices as $price){ $values[]=$price->price_value; $codes[]=$this->currencies[$price->price_currency_id]->currency_code; $qtys[]=$price->price_min_quantity; $accesses[]=$price->price_access; } } if(empty($values)){ echo '""'.$separator.'""'.$separator.'""'.$separator.'""'.$separator; }else{ echo '"'.implode('|',$values).'"'.$separator.'"'.implode('|',$codes).'"'.$separator.'"'.implode('|',$qtys).'"'.$separator.'"'.implode('|',$accesses).'"'.$separator; } $files = array(); if(!empty($product->files)){ foreach($product->files as $file){ $files[]=str_replace(array('"',',',';'),array('""','\\,','\\;'),$file->file_path); } } if(empty($files)){ echo '""'.$separator; }else{ echo '"'.implode($separator,$files).'"'.$separator; } $images = array(); if(!empty($product->images)){ foreach($product->images as $image){ $images[]=str_replace(array('"',',',';'),array('""','\\,','\\;'),$image->file_path); } } if(empty($images)){ echo '""'.$separator; }else{ echo '"'.implode($separator,$images).'"'.$separator; } $related = array(); if(!empty($product->related)){ foreach($product->related as $rel){ $related[]=str_replace(array('"',',',';'),array('""','\\,','\\;'),@$this->products[$rel]->product_code); } } if(empty($related)){ echo '""'.$separator; }else{ echo '"'.implode($separator,$related).'"'.$separator; } $options = array(); if(!empty($product->options)){ foreach($product->options as $rel){ $options[]=str_replace(array('"',',',';'),array('""','\\,','\\;'),@$this->products[$rel]->product_code); } } if(empty($options)){ echo '""'; }else{ echo '"'.implode($separator,$options).'"'; } if(!empty($product->variant_links)){ echo $separator; $characteristics=array(); if(!empty($characteristicsColumns)){ foreach($product->variant_links as $char_id){ if(!empty($this->characteristics[$char_id])){ $char = $this->characteristics[$char_id]; if(!empty($this->characteristics[$char->characteristic_parent_id])){ $key = $this->characteristics[$char->characteristic_parent_id]->characteristic_value; $characteristics[$key] = str_replace('"','""',$char->characteristic_value); } } } $chars = array(); foreach($characteristicsColumns as $characteristic){ $chars[] = '"'.@$characteristics[$characteristic].'"'; } echo implode($separator,$chars); } }elseif(!empty($characteristicsColumns)){ echo $separator; echo str_repeat('""'.$separator,count($characteristicsColumns)-1).'""'; } echo $eol; } } $data = ob_get_clean(); header("Pragma: public"); header("Expires: 0"); // set expiration time header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header("Content-Disposition: attachment; filename=hikashopexport.csv;"); header("Content-Transfer-Encoding: binary"); header('Content-Length: '.strlen($data)); echo $data; exit;