<?php
 
require_once('includes/Firma_core.php');
require_once(DIR_FS_CATALOG_MODULES . 'warenwirtschaft/csv.php');
 
$csv_script = new csv;
 
$page    = 0;
$page    = $Firma_HTML->get_HTMLUserVars('page'   , 'GET,POST', '0');
$oldpage = $page;
$rows    = $Firma_HTML->get_HTMLUserVars('rows'   , 'GET,POST', '0');
$artnr   = $Firma_HTML->get_HTMLUserVars('artnr'   , 'GET', '0');
 
 
if(!$artnr){
	$csv_file_location = DIR_FS_CATALOG . 'arbeit/shopdaten.csv';
 
	if (isset($_GET['split']) && $_GET['split'] == 'ok') {
					$csv_file_location = DIR_FS_CATALOG . 'arbeit/';
 
					if	(@is_dir($csv_file_location)) {
							$csv_script->set_page($page);
							$csv_script->set_rows($rows);
							$csv_script->set_basename(basename($Firma_php_self));
							$csv_script->get_csv_file($csv_file_location, 55, $categorie_id, true);	
					} else {
							if (isset($_GET['aufruf'])) $messageStack->add('adminHeader', _
  TEXT_ERROR_IMPORT_NOT_FOUND, 'error');
					}
	}else{
		if	(@file_exists($csv_file_location)) { 
				$csv_script->set_page($page);
				$csv_script->set_basename(basename($Firma_php_self));		
				$csv_script->get_csv_file($csv_file_location, 55, $categorie_id);
		} 
	}
	echo 'es wurde(n) ' . $rows . ' Artikel importiert.';
}else{
 
	$Qselect_pic = $Firma_Database_1->query('select products_id, products_image 
' from :table_p where products_model = :products_model');	
	$Qselect_pic->bindTable(':table_p', TABLE_PRODUCTS);
	$Qselect_pic->bindValue(':products_model', $artnr);		
	$Qselect_pic->execute();	
 
	$Firma_Products->create_ProductFailImage_import($Qselect_pic->value( _
  'products_image'));
 
	$Qselect_more_pic = $Firma_Database_1->query('select products_more_image 
' from :table_pmi where products_id = :products_id');	
	$Qselect_more_pic->bindTable(':table_pmi', TABLE_PRODUCTS_MORE_IMAGE);
	$Qselect_more_pic->bindInt(':products_id', $Qselect_pic->value('products_id'));					
	$Qselect_more_pic->execute();	
 
	if($Qselect_more_pic->numberOfRows() > 0){
		while($Qselect_more_pic->next()){
			$Firma_Products->create_ProductFailMoreImage_import( _
  $Qselect_more_pic->value('products_more_image'));
		}
	}
	$Firma_Products->set_ProductClearCache($Qselect_pic->value('products_id'));
 
	echo 'Bilder wurden generiert';
 
}
?>